The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE insert_po_interface_errors_msg(
X_interface_type IN VARCHAR2,
X_Interface_Header_ID IN NUMBER,
X_Interface_Line_Id IN NUMBER,
X_Interface_Dist_Id IN NUMBER,
X_error_message_text IN VARCHAR2,
X_error_message_name IN VARCHAR2,
X_column_name IN VARCHAR2,
X_table_name IN VARCHAR2,
X_batch_id IN NUMBER)
IS
-- Moved the AUTONOMOUS_TRANSACTION inside this new procedure. Prior to this
-- it was present in the public function insert_po_interface_errors(). That
-- function, in turn, now calls this procedure.
-- Bug 2705777. Making this an autonomous transaction to avoid rollback issues
-- with the main transaction's savepoints.
PRAGMA AUTONOMOUS_TRANSACTION;
insert into po_interface_errors(Interface_Type,
Interface_Transaction_Id,
column_name,
table_name,
error_message,
Error_Message_Name,
processing_date,
Creation_Date,
Created_By,
Last_Update_Date,
Last_Updated_by,
Last_Update_Login,
Interface_Header_ID,
Interface_Line_Id,
Interface_Distribution_Id,
Request_Id,
Program_Application_id,
Program_Id,
Program_Update_date,
Batch_Id)
VALUES
(X_interface_type,
po_interface_errors_s.nextval,
X_column_name,
X_table_name,
X_Error_Message_text,
X_Error_Message_name,
sysdate,
sysdate,
fnd_global.user_id,
sysdate,
fnd_global.user_id,
fnd_global.login_id,
X_interface_header_id,
X_interface_line_id,
X_Interface_Dist_Id,
fnd_global.conc_request_id,
fnd_global.prog_appl_id,
fnd_global.conc_program_id,
sysdate,
X_batch_id);
po_message_s.sql_error('insert_po_interface_errors_msg', X_progress,
sqlcode);
END insert_po_interface_errors_msg;
X_compl_code := po_interface_errors_sv1.insert_po_interface_errors(
X_interface_type,
X_Error_type, --
X_Batch_id,
X_Interface_Header_ID,
X_Interface_Line_Id ,
X_Interface_Dist_Id,
X_Error_Message_name,
X_column_name,
X_table_name,
X_TokenName1,
X_TokenName2,
X_TokenName3,
X_TokenName4,
X_TokenName5,
X_TokenName6,
X_TokenValue1,
X_TokenValue2,
X_TokenValue3,
X_TokenValue4,
X_TokenValue5,
X_TokenValue6);
FUNCTION NAME: insert_po_interface_errors()
=========================================================================*/
FUNCTION insert_po_interface_errors(X_interface_type IN VARCHAR2,
X_Error_type IN VARCHAR2,
X_Batch_id IN NUMBER,
X_Interface_Header_ID IN NUMBER,
X_Interface_Line_Id IN NUMBER,
X_Interface_Dist_Id IN NUMBER,
X_error_message_name IN VARCHAR2,
X_column_name IN VARCHAR2,
X_table_name IN VARCHAR2,
X_TokenName1 IN VARCHAR2,
X_TokenName2 IN VARCHAR2,
X_TokenName3 IN VARCHAR2,
X_TokenName4 IN VARCHAR2,
X_TokenName5 IN VARCHAR2,
X_TokenName6 IN VARCHAR2,
X_TokenValue1 IN VARCHAR2,
X_TokenValue2 IN VARCHAR2,
X_TokenValue3 IN VARCHAR2,
X_TokenValue4 IN VARCHAR2,
X_TokenValue5 IN VARCHAR2,
X_TokenValue6 IN VARCHAR2)
Return VARCHAR2 IS
X_progress varchar2(30) := null;
/* Bug 2860580. Added BATCH_ID in the INSERT statement */
--
-- Refactored this code to call this private function. This private function
-- is also called from the new public procedure handle_interface_errors_msg()
insert_po_interface_errors_msg(X_interface_type,
X_interface_header_id,
X_interface_line_id,
X_Interface_Dist_Id,
X_Error_Message,
X_Error_Message_name,
X_column_name,
X_table_name,
X_Batch_id);
po_message_s.sql_error('insert_po_interface_errors', X_progress, sqlcode);
END insert_po_interface_errors;
insert_po_interface_errors_msg(X_interface_type,
X_Interface_Header_ID,
X_Interface_Line_Id ,
X_Interface_Dist_Id,
X_Error_Message_text,
X_Error_Message_name,
X_column_name,
X_table_name,
X_Batch_id);