6: --
7: ---------------------------------------------------------------------------
8: -- INSERT_REJECTIONS():
9: -- AP Invoice Gateway Import Process uses this procedure to reject
10: -- invalid data and insert them to AP_INTERFACE_REJECTIONS table.
11: -- The table stores both header and line level invoice information.
12: -- The column PARENT_TABLE indicates the table from which the invoice
13: -- fetched is being rejected - AP_INVOICES_INTERFACE or
14: -- AP_INVOICE_LINES_INTERFACE. If the source of PARENT_TABLE is
30: l_debug_info VARCHAR2(100);
31: BEGIN
32: -------------------------- DEBUG INFORMATION ------------------------------
33: l_curr_calling_sequence := 'jg_globe_flex_val.'||l_debug_loc||'<-'||p_calling_sequence;
34: l_debug_info := 'Insert rejection information to ap_interface_rejections';
35: ---------------------------------------------------------------------------
36: --
37: -- Insert into AP_INTERFACE_REJECTIONS
38: --
33: l_curr_calling_sequence := 'jg_globe_flex_val.'||l_debug_loc||'<-'||p_calling_sequence;
34: l_debug_info := 'Insert rejection information to ap_interface_rejections';
35: ---------------------------------------------------------------------------
36: --
37: -- Insert into AP_INTERFACE_REJECTIONS
38: --
39: INSERT INTO ap_interface_rejections(
40: parent_table,
41: parent_id,
35: ---------------------------------------------------------------------------
36: --
37: -- Insert into AP_INTERFACE_REJECTIONS
38: --
39: INSERT INTO ap_interface_rejections(
40: parent_table,
41: parent_id,
42: reject_lookup_code,
43: last_updated_by,