32:
33: PRAGMA AUTONOMOUS_TRANSACTION;
34:
35: l_interface_type VARCHAR2(25) := 'RCV-856';
36: l_error_message po_interface_errors.error_message%TYPE ;
37: l_group_id NUMBER;
38: l_header_interface_id NUMBER;
39: BEGIN
40:
72: WHERE interface_transaction_id = p_rti_id ;
73:
74: END IF;
75:
76: INSERT INTO po_interface_errors(Interface_Type,
77: Interface_Transaction_Id,
78: column_name,
79: table_name,
80: error_message,
94: Program_Update_date,
95: BATCH_ID)
96: VALUES
97: (l_interface_type,
98: po_interface_errors_s.NEXTVAL,
99: p_column_name,
100: p_table_name,
101: l_error_message,
102: p_Error_Message_name,