1.

What Is The Best Way To Add Debugging To The Code In Apps?

Answer»

Use fnd_log.string , i.e. FND Logging. Behind the scenes Oracles FND Logging USES autonomous transaction to insert RECORDS in a table named fnd_log_messages.

For EXAMPLE

DECLARE BEGIN fnd_log.STRING(log_level => fnd_log.level_statement ,module=>'xxxx '||'pkg/procedurename ' ,message=>'your debug message here'); END ; Three profile options effecting FND Logging are FND: Debug Log MODE.
FND: Debug Log ENABLED.
FND: Debug Log Module.

 

Use fnd_log.string , i.e. FND Logging. Behind the scenes Oracles FND Logging uses autonomous transaction to insert records in a table named fnd_log_messages.

For example

 



Discussion

No Comment Found