[Home] [Help]
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';
3678: --Pre-reqs:
3679: -- PO_ENCUMBRANCE_GT result fields have been populated
3680: --Modifies:
3681: -- PO_ENCUMBRANCE_GT
3682: -- PO_ONLINE_REPORT_TEXT
3683: --Locks:
3684: -- None.
3685: --Function:
3686: --
3692: -- ID of the current user
3693: --OUT:
3694: --x_online_report_id
3695: -- The unique ID of the result information in the
3696: -- PO_ONLINE_REPORT_TEXT table
3697: --x_po_return_code
3698: -- The return code for this transaction, based on the GL result
3699: -- code and PO warning conditions
3700: --x_po_return_msg
3969: --Name: create_exception_report
3970: --Pre-reqs:
3971: -- None.
3972: --Modifies:
3973: -- PO_ONLINE_REPORT_TEXT
3974: --Locks:
3975: -- None.
3976: --Function:
3977: -- Inserts a single row into the PO_ONLINE_REPORT_TEXT table,
3973: -- PO_ONLINE_REPORT_TEXT
3974: --Locks:
3975: -- None.
3976: --Function:
3977: -- Inserts a single row into the PO_ONLINE_REPORT_TEXT table,
3978: -- which provides information about the cause of an exception.
3979: -- This message is an overall-transaction level message.
3980: --Parameters:
3981: --IN:
3979: -- This message is an overall-transaction level message.
3980: --Parameters:
3981: --IN:
3982: --p_message_text
3983: -- The detail message to be put into PO_ONLINE_REPORT_TEXT
3984: -- This message indicates why the overall transaction was unsuccessful
3985: --p_user_id
3986: -- ID of the current user
3987: --OUT:
3986: -- ID of the current user
3987: --OUT:
3988: --x_online_report_id
3989: -- The unique ID of the result information in the
3990: -- PO_ONLINE_REPORT_TEXT table
3991: --Testing:
3992: --
3993: --End of Comments
3994: -------------------------------------------------------------------------------
4051: --Name: insert_report_autonomous
4052: --Pre-reqs:
4053: -- None
4054: --Modifies:
4055: -- PO_ONLINE_REPORT_TEXT
4056: --Locks:
4057: -- None.
4058: --Function:
4059: -- Inserts rows into the PO_ONLINE_REPORT_TEXT table to
4055: -- PO_ONLINE_REPORT_TEXT
4056: --Locks:
4057: -- None.
4058: --Function:
4059: -- Inserts rows into the PO_ONLINE_REPORT_TEXT table to
4060: -- represent the transaction result "details". This is either
4061: -- the distribution-specific result information or the specific
4062: -- exception information for the overall transaction.
4063: --Parameters:
4068: -- rows (result information for each distribution)
4069: -- VALUES: g_report_level_TRANSACTION, g_report_level_DISTRIBUTION
4070: --p_message_text
4071: -- Used only if reporting level is g_report_level_TRANSACTION
4072: -- The detail message to be put into PO_ONLINE_REPORT_TEXT
4073: -- This message indicates why the overall transaction was unsuccessful
4074: --p_user_id
4075: -- ID of the current user
4076: --p_sequence_num_tbl
4100: -- PO_ENCUMBRANCE_GT which we are reporting on
4101: --OUT:
4102: --x_online_report_id
4103: -- The unique ID of the result information in the
4104: -- PO_ONLINE_REPORT_TEXT table
4105: --Testing:
4106: --
4107: --End of Comments
4108: -------------------------------------------------------------------------------
4128:
4129: l_api_name CONSTANT varchar2(30) := 'INSERT_REPORT_AUTONOMOUS';
4130: l_log_head CONSTANT varchar2(100) := g_log_head || l_api_name;
4131: l_progress varchar2(3) := '000';
4132: l_report_id PO_ONLINE_REPORT_TEXT.online_report_id%TYPE;
4133:
4134: l_user_id NUMBER;
4135: l_message_text PO_ONLINE_REPORT_TEXT.text_line%TYPE;
4136:
4131: l_progress varchar2(3) := '000';
4132: l_report_id PO_ONLINE_REPORT_TEXT.online_report_id%TYPE;
4133:
4134: l_user_id NUMBER;
4135: l_message_text PO_ONLINE_REPORT_TEXT.text_line%TYPE;
4136:
4137: l_single_message_flag BOOLEAN;
4138:
4139: BEGIN
4151: x_online_report_id := NULL;
4152:
4153: l_progress := '010';
4154:
4155: SELECT PO_ONLINE_REPORT_TEXT_S.nextval
4156: INTO l_report_id
4157: FROM dual;
4158:
4159: l_progress := '020';
4177: --unexpected error returned from execute_gl_call
4178: if l_message_text = 'GL_FUNDS_API_EXC' then
4179:
4180:
4181: INSERT INTO PO_ONLINE_REPORT_TEXT(
4182: online_report_id
4183: , sequence
4184: , last_updated_by
4185: , last_update_date
4255: IF l_single_message_flag THEN
4256:
4257: l_progress := '100';
4258:
4259: INSERT INTO PO_ONLINE_REPORT_TEXT(
4260: online_report_id
4261: , sequence
4262: , last_updated_by
4263: , last_update_date
4284: ELSE
4285: l_progress := '200';
4286:
4287: FORALL i IN 1 .. p_sequence_num_tbl.COUNT
4288: INSERT INTO PO_ONLINE_REPORT_TEXT(
4289: online_report_id
4290: , sequence
4291: , last_updated_by
4292: , last_update_date