DBA Data[Home] [Help]

APPS.PO_REQIMP_PKG dependencies on PO_INTERFACE_ERRORS

Line 5: l_error_msg po_interface_errors.error_message%TYPE ;

1: PACKAGE BODY PO_REQIMP_PKG AS
2: /* $Header: jaaupirb.pls 120.6 2008/07/18 15:55:57 abuissa ship $ */
3:
4: -- ** Declare global variables
5: l_error_msg po_interface_errors.error_message%TYPE ;
6: l_error_flag number;
7: l_index NATURAL;
8:
9: g_count NUMBER := 0; -- Bug 3032472 : Counts number of rec in PO_APPROVED_SUPPLIER_LIST

Line 792: INSERT INTO po_interface_errors

788: IF SQL%NOTFOUND THEN
789: RAISE l_update_failure;
790: END IF;
791:
792: INSERT INTO po_interface_errors
793: (
794: interface_type,
795: interface_transaction_id,
796: error_message,

Line 1256: -- | Any errors will be flagged by inserting a record in PO_INTERFACE_ERRORS

1252: -- | This procedure will obtain the code_combination_id from the table
1253: -- | GL_CODE_COMBINATIONS for the given item and subinventory. It will store
1254: -- | the code_combination_id in the charge_account_id column of the table
1255: -- | PO_REQUISITIONS_INTERFACE.
1256: -- | Any errors will be flagged by inserting a record in PO_INTERFACE_ERRORS
1257: -- | Possible errors are :
1258: -- | AUTOGL ERROR - Could not retrieve chart_of_accounts_id and/or
1259: -- | set_of_books_id.
1260: -- | AUTOGL ERROR - Could not retrieve subinventory expense_account.