APPS.PO_INTERFACE_ERRORS_UTL dependencies on PO_INTERFACE_ERRORS

Line 1: PACKAGE BODY PO_INTERFACE_ERRORS_UTL AS

1: PACKAGE BODY PO_INTERFACE_ERRORS_UTL AS
2: /* $Header: PO_INTERFACE_ERRORS_UTL.plb 120.1 2006/05/25 22:00:12 bao noship $ */
3:
4: d_pkg_name CONSTANT VARCHAR2(50) :=
5: PO_LOG.get_package_base('PO_INTERFACE_ERRORS_UTL');

Line 2: /* $Header: PO_INTERFACE_ERRORS_UTL.plb 120.1 2006/05/25 22:00:12 bao noship $ */

1: PACKAGE BODY PO_INTERFACE_ERRORS_UTL AS
2: /* $Header: PO_INTERFACE_ERRORS_UTL.plb 120.1 2006/05/25 22:00:12 bao noship $ */
3:
4: d_pkg_name CONSTANT VARCHAR2(50) :=
5: PO_LOG.get_package_base('PO_INTERFACE_ERRORS_UTL');
6:

Line 5: PO_LOG.get_package_base('PO_INTERFACE_ERRORS_UTL');

1: PACKAGE BODY PO_INTERFACE_ERRORS_UTL AS
2: /* $Header: PO_INTERFACE_ERRORS_UTL.plb 120.1 2006/05/25 22:00:12 bao noship $ */
3:
4: d_pkg_name CONSTANT VARCHAR2(50) :=
5: PO_LOG.get_package_base('PO_INTERFACE_ERRORS_UTL');
6:
7: TYPE errors_tbl_type IS TABLE OF PO_INTERFACE_ERRORS%ROWTYPE;
8:
9: g_errors_tbl errors_tbl_type;

Line 7: TYPE errors_tbl_type IS TABLE OF PO_INTERFACE_ERRORS%ROWTYPE;

3:
4: d_pkg_name CONSTANT VARCHAR2(50) :=
5: PO_LOG.get_package_base('PO_INTERFACE_ERRORS_UTL');
6:
7: TYPE errors_tbl_type IS TABLE OF PO_INTERFACE_ERRORS%ROWTYPE;
8:
9: g_errors_tbl errors_tbl_type;
10:
11: g_batch_size CONSTANT NUMBER := 5000; -- maximum number of messages the

Line 13: -- them to PO_INTERFACE ERRORS table

9: g_errors_tbl errors_tbl_type;
10:
11: g_batch_size CONSTANT NUMBER := 5000; -- maximum number of messages the
12: -- structure will hold before flushing
13: -- them to PO_INTERFACE ERRORS table
14:
15: -------------------------------------------------------
16: -------------- PUBLIC PROCEDURES ----------------------
17: -------------------------------------------------------

Line 77: p_err_rec IN PO_INTERFACE_ERRORS%ROWTYPE

73: --End of Comments
74: ------------------------------------------------------------------------
75: PROCEDURE add_to_errors_tbl
76: ( p_err_type IN VARCHAR2,
77: p_err_rec IN PO_INTERFACE_ERRORS%ROWTYPE
78: ) IS
79:
80: d_api_name CONSTANT VARCHAR2(30) := 'add_to_errors_tbl';
81: d_module CONSTANT VARCHAR2(255) := d_pkg_name || d_api_name || '.';

Line 110: SELECT po_interface_errors_s.nextval

106: END IF;
107:
108: d_position := 10;
109:
110: SELECT po_interface_errors_s.nextval
111: INTO g_errors_tbl(l_indx).interface_transaction_id
112: FROM DUAL;
113:
114: -- default WHO columns, etc.

Line 229: INSERT INTO po_interface_errors

225: RETURN;
226: END IF;
227:
228: FORALL i IN 1..g_errors_tbl.COUNT
229: INSERT INTO po_interface_errors
230: VALUES g_errors_tbl(i);
231:
232: d_position := 10;
233:

Line 283: END PO_INTERFACE_ERRORS_UTL;

279: RAISE;
280: END get_error_count;
281:
282:
283: END PO_INTERFACE_ERRORS_UTL;