eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_ENCUMBRANCE_POSTPROCESSING dependencies on PO_ONLINE_REPORT_TEXT

Line 218: PO_ONLINE_REPORT_TEXT.transaction_type%TYPE := 'ENCUMBRANCE';

214: := PO_DOCUMENT_FUNDS_PVT.g_result_ERROR;
215:
216: -- current module
217: g_module_ENCUMBRANCE CONSTANT
218: PO_ONLINE_REPORT_TEXT.transaction_type%TYPE := 'ENCUMBRANCE';
219:
220: --bug#5353223
221: g_CREDIT CONSTANT VARCHAR2(2) :='Cr';
222: g_DEBIT CONSTANT VARCHAR2(2) :='Dr';

Line 3352: -- PO_ONLINE_REPORT_TEXT

3348: --Pre-reqs:
3349: -- PO_ENCUMBRANCE_GT result fields have been populated
3350: --Modifies:
3351: -- PO_ENCUMBRANCE_GT
3352: -- PO_ONLINE_REPORT_TEXT
3353: --Locks:
3354: -- None.
3355: --Function:
3356: --

Line 3366: -- PO_ONLINE_REPORT_TEXT table

3362: -- ID of the current user
3363: --OUT:
3364: --x_online_report_id
3365: -- The unique ID of the result information in the
3366: -- PO_ONLINE_REPORT_TEXT table
3367: --x_po_return_code
3368: -- The return code for this transaction, based on the GL result
3369: -- code and PO warning conditions
3370: --x_po_return_msg

Line 3643: -- PO_ONLINE_REPORT_TEXT

3639: --Name: create_exception_report
3640: --Pre-reqs:
3641: -- None.
3642: --Modifies:
3643: -- PO_ONLINE_REPORT_TEXT
3644: --Locks:
3645: -- None.
3646: --Function:
3647: -- Inserts a single row into the PO_ONLINE_REPORT_TEXT table,

Line 3647: -- Inserts a single row into the PO_ONLINE_REPORT_TEXT table,

3643: -- PO_ONLINE_REPORT_TEXT
3644: --Locks:
3645: -- None.
3646: --Function:
3647: -- Inserts a single row into the PO_ONLINE_REPORT_TEXT table,
3648: -- which provides information about the cause of an exception.
3649: -- This message is an overall-transaction level message.
3650: --Parameters:
3651: --IN:

Line 3653: -- The detail message to be put into PO_ONLINE_REPORT_TEXT

3649: -- This message is an overall-transaction level message.
3650: --Parameters:
3651: --IN:
3652: --p_message_text
3653: -- The detail message to be put into PO_ONLINE_REPORT_TEXT
3654: -- This message indicates why the overall transaction was unsuccessful
3655: --p_user_id
3656: -- ID of the current user
3657: --OUT:

Line 3660: -- PO_ONLINE_REPORT_TEXT table

3656: -- ID of the current user
3657: --OUT:
3658: --x_online_report_id
3659: -- The unique ID of the result information in the
3660: -- PO_ONLINE_REPORT_TEXT table
3661: --Testing:
3662: --
3663: --End of Comments
3664: -------------------------------------------------------------------------------

Line 3725: -- PO_ONLINE_REPORT_TEXT

3721: --Name: insert_report_autonomous
3722: --Pre-reqs:
3723: -- None
3724: --Modifies:
3725: -- PO_ONLINE_REPORT_TEXT
3726: --Locks:
3727: -- None.
3728: --Function:
3729: -- Inserts rows into the PO_ONLINE_REPORT_TEXT table to

Line 3729: -- Inserts rows into the PO_ONLINE_REPORT_TEXT table to

3725: -- PO_ONLINE_REPORT_TEXT
3726: --Locks:
3727: -- None.
3728: --Function:
3729: -- Inserts rows into the PO_ONLINE_REPORT_TEXT table to
3730: -- represent the transaction result "details". This is either
3731: -- the distribution-specific result information or the specific
3732: -- exception information for the overall transaction.
3733: --Parameters:

Line 3742: -- The detail message to be put into PO_ONLINE_REPORT_TEXT

3738: -- rows (result information for each distribution)
3739: -- VALUES: g_report_level_TRANSACTION, g_report_level_DISTRIBUTION
3740: --p_message_text
3741: -- Used only if reporting level is g_report_level_TRANSACTION
3742: -- The detail message to be put into PO_ONLINE_REPORT_TEXT
3743: -- This message indicates why the overall transaction was unsuccessful
3744: --p_user_id
3745: -- ID of the current user
3746: --p_sequence_num_tbl

Line 3774: -- PO_ONLINE_REPORT_TEXT table

3770: -- PO_ENCUMBRANCE_GT which we are reporting on
3771: --OUT:
3772: --x_online_report_id
3773: -- The unique ID of the result information in the
3774: -- PO_ONLINE_REPORT_TEXT table
3775: --Testing:
3776: --
3777: --End of Comments
3778: -------------------------------------------------------------------------------

Line 3802: l_report_id PO_ONLINE_REPORT_TEXT.online_report_id%TYPE;

3798:
3799: l_api_name CONSTANT varchar2(30) := 'INSERT_REPORT_AUTONOMOUS';
3800: l_log_head CONSTANT varchar2(100) := g_log_head || l_api_name;
3801: l_progress varchar2(3) := '000';
3802: l_report_id PO_ONLINE_REPORT_TEXT.online_report_id%TYPE;
3803:
3804: l_user_id NUMBER;
3805: l_message_text PO_ONLINE_REPORT_TEXT.text_line%TYPE;
3806:

Line 3805: l_message_text PO_ONLINE_REPORT_TEXT.text_line%TYPE;

3801: l_progress varchar2(3) := '000';
3802: l_report_id PO_ONLINE_REPORT_TEXT.online_report_id%TYPE;
3803:
3804: l_user_id NUMBER;
3805: l_message_text PO_ONLINE_REPORT_TEXT.text_line%TYPE;
3806:
3807: l_single_message_flag BOOLEAN;
3808:
3809: BEGIN

Line 3825: SELECT PO_ONLINE_REPORT_TEXT_S.nextval

3821: x_online_report_id := NULL;
3822:
3823: l_progress := '010';
3824:
3825: SELECT PO_ONLINE_REPORT_TEXT_S.nextval
3826: INTO l_report_id
3827: FROM dual;
3828:
3829: l_progress := '020';

Line 3877: INSERT INTO PO_ONLINE_REPORT_TEXT(

3873: IF l_single_message_flag THEN
3874:
3875: l_progress := '100';
3876:
3877: INSERT INTO PO_ONLINE_REPORT_TEXT(
3878: online_report_id
3879: , sequence
3880: , last_updated_by
3881: , last_update_date

Line 3906: INSERT INTO PO_ONLINE_REPORT_TEXT(

3902: ELSE
3903: l_progress := '200';
3904:
3905: FORALL i IN 1 .. p_sequence_num_tbl.COUNT
3906: INSERT INTO PO_ONLINE_REPORT_TEXT(
3907: online_report_id
3908: , sequence
3909: , last_updated_by
3910: , last_update_date