Script for Validating Application user account

This script will be more helpful to validate the users login issue.
It will identify the exact issue of the user login.

SQL> set serveroutput on size 100000
SQL> DECLARE
2 l_result varchar2(30000);
3 userid number;
4 BEGIN
5 l_result := fnd_web_sec.validate_login('GUEST', 'ORACLE' );
6 dbms_output.put_line( 'Result = ' || l_result );
7 if l_result = 'N' then
8 dbms_output.put_line( 'Error stack = ' );
9 l_result := fnd_message.get();
10 dbms_output.put_line( l_result );
11 end if;
12 END;
13 /
Result = Y

PL/SQL procedure successfully completed.

SQL> set serveroutput on size 100000
SQL> DECLARE
2 l_result varchar2(30000);
3 userid number;
4 BEGIN
5 l_result := fnd_web_sec.validate_login('GUNEET', 'welcome' );
6 dbms_output.put_line( 'Result = ' || l_result );
7 if l_result = 'N' then
8 dbms_output.put_line( 'Error stack = ' );
9 l_result := fnd_message.get();
10 dbms_output.put_line( l_result );
11 end if;
12 END;
13 /
Result = N
Error stack =
Your account does not exist or has expired. Please contact the Web Master or
System Administrator.

PL/SQL procedure successfully completed.