CREATE OR REPLACE FUNCTION DANP.test_2 ( p_name VARCHAR2 )
   RETURN VARCHAR2
IS
   p_displayed    VARCHAR2 ( 100 );
   p_name_last    VARCHAR2 ( 100 );
   p_name_first   VARCHAR2 ( 100 );
BEGIN
   p_displayed   := NULL;



   IF p_name IS NULL
   THEN
      p_displayed   := ' Displayed_Name: ' || RPAD ( ' ', 30 ) || '  Organization#: ' || RPAD ( ' ', 4 );
   ELSE
      SELECT    ' Displayed_Name: '
             || RPAD ( NVL ( danp.test_get_user_name, ' ' ), 30 )
             || '  Organization#: '
             || LPAD ( NVL ( danp.test_get_user_org_nbr, 0 ), 4 )
      INTO   p_displayed
      FROM   DUAL
      WHERE  danp.test_get_user_valid = 'VALID';
   END IF;

   IF p_name_last IS NULL
   THEN
      p_displayed   := ' Displayed_Name: ' || RPAD ( ' ', 30 ) || '  Organization#: ' || RPAD ( ' ', 4 );
   ELSE
      SELECT    ' Displayed_Name: '
             || RPAD ( NVL ( danp.test_get_user_name_last, ' ' ), 30 )
             || '  Organization#: '
             || LPAD ( NVL ( danp.test_get_user_org_nbr, 0 ), 4 )
      INTO   p_displayed4
      FROM   DUAL
      WHERE  danp.test_get_user_valid = 'VALID';
   END IF;

   IF p_name_first IS NULL
   THEN
      p_displayed   := ' Displayed_Name: ' || RPAD ( ' ', 30 ) || '  Organization#: ' || RPAD ( ' ', 4 );
   ELSE
      SELECT    ' Displayed_Name: '
             || RPAD ( NVL ( danp.test_get_user_name_first, ' ' ), 30 )
             || '  Organization#: '
             || LPAD ( NVL ( danp.test_get_user_org_nbr, 0 ), 4 )
      INTO   p_displayed
      FROM   DUAL
      WHERE  danp.test_get_user_valid = 'VALID';
   END IF;

   RETURN p_displayed;
EXCEPTION
   WHEN NO_DATA_FOUND
   THEN
      p_displayed   := ' Displayed_Name: ' || RPAD ( 'Not_Found', 30 ) || '  Organization#: ' || RPAD ( 'N/A', 4 );
      RETURN p_displayed;
END test_2;
/
SHOW ERRORS;