Enabling FND logging and getting FND log messages

Enabling FND logging and getting FND log messages
1. Go to System Administrator --> Profiles--> System.
2. Query for 'FND%LOG%' for the current user.
3. Set FND: Debug Log Enabled - 'YES'
       FND: Debug Log Level - 'Statement'
       FND: Debug Log Module - %

4. Log out and Login Again.

5. Run the following query in the database from the backend.
   select max(log_sequence) from fnd_log_messages;
   Note down the log sequence.
6. Reproduce the problem.
7. Run the following query in the database from the backend.
    select max(log_sequence) from fnd_log_messages;
    Note down the log sequence.
11. Run the following query in the database from the backend.
    select module,message_text from fnd_log_messages where log_sequence
between (sequence obtained in step 5) and (sequence obtained in step 7).