APPS.PO_R12_CAT_UPG_UTL dependencies on PO_INTERFACE_ERRORS

Line 18: -- a) PO_INTERFACE_ERRORS table

14: --Name: add_fatal_error
15: --Pre-reqs:
16: -- None
17: --Modifies:
18: -- a) PO_INTERFACE_ERRORS table
19: -- b) FND_MSG_PUB on unhandled exceptions.
20: --Locks:
21: -- None.
22: --Function:

Line 23: -- Inserts error message into PO_INTERFACE_ERRORS in an autonomous

19: -- b) FND_MSG_PUB on unhandled exceptions.
20: --Locks:
21: -- None.
22: --Function:
23: -- Inserts error message into PO_INTERFACE_ERRORS in an autonomous
24: -- transaction. As per ECO bug 4927349, all messages for catalog migration will
25: -- be provided by iProcurement (product code ICX).
26: --
27: --Parameters:

Line 28: -- Same as the PO_INTERFACE_ERRORS_SV1.handle_interface_errors() procedure.

24: -- transaction. As per ECO bug 4927349, all messages for catalog migration will
25: -- be provided by iProcurement (product code ICX).
26: --
27: --Parameters:
28: -- Same as the PO_INTERFACE_ERRORS_SV1.handle_interface_errors() procedure.
29: --End of Comments
30: --------------------------------------------------------------------------------
31: PROCEDURE add_fatal_error
32: (

Line 101: --PO_INTERFACE_ERRORS_UTL.add_to_tbl

97: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'header_processable_flag='|| l_hdr_proc_flag);
98: PO_R12_CAT_UPG_DEBUG.log_stmt(l_log_head,l_progress,'interface_dist_id='|| p_interface_distribution_id);
99: END IF;
100:
101: --PO_INTERFACE_ERRORS_UTL.add_to_tbl
102: /*
103: PO_INTERFACE_ERRORS_SV1.handle_interface_errors
104: (
105: x_interface_type => 'PO_DOCS_OPEN_INTERFACE',

Line 103: PO_INTERFACE_ERRORS_SV1.handle_interface_errors

99: END IF;
100:
101: --PO_INTERFACE_ERRORS_UTL.add_to_tbl
102: /*
103: PO_INTERFACE_ERRORS_SV1.handle_interface_errors
104: (
105: x_interface_type => 'PO_DOCS_OPEN_INTERFACE',
106: x_error_type => 'FATAL',
107: x_batch_id => PO_R12_CAT_UPG_PVT.g_job.batch_id,

Line 155: INSERT INTO PO_INTERFACE_ERRORS

151: l_original_message := FND_MESSAGE.get;
152: l_error_message_text := substrb(l_original_message, 1, 2000);
153:
154: l_progress := '020';
155: INSERT INTO PO_INTERFACE_ERRORS
156: (
157: INTERFACE_TYPE,
158: INTERFACE_TRANSACTION_ID,
159: COLUMN_NAME,

Line 182: PO_INTERFACE_ERRORS_S.nextval,

178:
179: ) VALUES (
180:
181: 'PO_DOCS_OPEN_INTERFACE',
182: PO_INTERFACE_ERRORS_S.nextval,
183: p_column_name,
184: substrb(p_column_value, 1, 4000),
185: p_table_name,
186: l_error_message_text,