The following lines contain the word 'select', 'insert', 'update' or 'delete':
| 08/27/2003 S. Singhania Modified STACK_ERROR to insert message |
| rather than encoded message. |
| Bug # 3113574 |
| 09/09/2003 S. Singhania Added the procedure body for |
| SET_ERROR_SOURCE |
| 10/14/2003 S. Singhania Renamed SET_ERROR_SOURCE to |
| SET_OPTIONS. |
| Added new parameters to INITIALIZE. |
| 02/28/2004 S. Singhania Bug 3416534. Updated local trace |
| procedure and added FND_LOG messages |
| 03/23/2004 S. Singhania Added a parameter p_module to the TRACE|
| calls and the procedure. |
+===========================================================================*/
--=============================================================================
-- **************** declaraions ********************
--=============================================================================
-------------------------------------------------------------------------------
-- declaring private variables
-------------------------------------------------------------------------------
g_error_index PLS_INTEGER := 0;
PROCEDURE insert_errors IS
l_log_module VARCHAR2(240);
l_log_module := C_DEFAULT_MODULE||'.insert_errors';
(p_msg => 'BEGIN of procedure INSERT_ERRORS'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
INSERT INTO xla_accounting_errors
(accounting_error_id
,application_id
,event_id
,entity_id
,ledger_id
,ae_header_id
,ae_line_num
,accounting_batch_id
,message_number
,encoded_msg
,error_source_code
,created_by
,creation_date
,last_update_date
,last_updated_by
,last_update_login
,program_update_date
,program_application_id
,program_id
,request_id)
VALUES (xla_accounting_errors_s.nextval
,g_accounting_errors(i).application_id
,g_accounting_errors(i).event_id
,g_accounting_errors(i).entity_id
,g_accounting_errors(i).ledger_id
,g_accounting_errors(i).ae_header_id
,g_accounting_errors(i).ae_line_num
,g_accounting_errors(i).accounting_batch_id
,g_accounting_errors(i).message_number
,g_accounting_errors(i).encoded_msg
,g_accounting_errors(i).error_source_code
,xla_environment_pkg.g_usr_id
,sysdate
,sysdate
,xla_environment_pkg.g_usr_id
,xla_environment_pkg.g_login_id
,NULL
,xla_environment_pkg.g_prog_appl_id
,xla_environment_pkg.g_prog_id
,g_accounting_errors(i).request_id);
(p_msg => 'END of procedure INSERT_ERRORS'
,p_level => C_LEVEL_PROCEDURE
,p_module => l_log_module);
(p_location => 'xla_accounting_err_pkg.insert_errors');
END insert_errors; -- end of procedure
g_accounting_errors.DELETE;