APPS.XLA_ACCOUNTING_ERR_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 42

|     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;

Line: 1544

PROCEDURE insert_errors IS
l_log_module                VARCHAR2(240);

Line: 1548

      l_log_module := C_DEFAULT_MODULE||'.insert_errors';

Line: 1552

         (p_msg      => 'BEGIN of procedure INSERT_ERRORS'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 1566

         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);

Line: 1617

         (p_msg      => 'END of procedure INSERT_ERRORS'
         ,p_level    => C_LEVEL_PROCEDURE
         ,p_module   => l_log_module);

Line: 1626

       (p_location       => 'xla_accounting_err_pkg.insert_errors');

Line: 1627

END insert_errors;  -- end of procedure

Line: 1941

   g_accounting_errors.DELETE;