Enabling trace in DBMS OUTPUT for HR APIs

While doing conversion,interface or any extension in HR sometime we have to debug the API to analyze the transaction flow.Below code snippet will be useful for such debugging (only for HR APIs).The below debug message we can view in the editor console itself.

Steps

1) Enable the DBMS OUTPUT.
2) EXEC DBMS_OUTPUT.ENABLE(1000000);
3) DECLARE

BEGIN
HR_UTILITY.SET_TRACE_OPTIONS(‘TRACE_DEST:DBMS_OUTPUT’);
HR_UTILITY.TRACE_ON(NULL, ‘XX_TRACE’) ;

—-
HR_UTILITY.TRACE_OFF;
END;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s