APPS.XLA_AAD_LOADER_UTIL_PVT dependencies on XLA_AAD_LOADER_LOGS

Line 2120: DELETE FROM xla_aad_loader_logs

2116: p_module => l_log_module,
2117: p_level => C_LEVEL_PROCEDURE);
2118: END IF;
2119:
2120: DELETE FROM xla_aad_loader_logs
2121: WHERE application_id = p_application_id
2122: AND amb_context_code = p_amb_context_code
2123: AND request_code = p_request_code;
2124:

Line 2126: trace(p_msg => '# row deleted into xla_aad_loader_logs = '||SQL%ROWCOUNT,

2122: AND amb_context_code = p_amb_context_code
2123: AND request_code = p_request_code;
2124:
2125: IF (C_LEVEL_EVENT >= g_log_level) THEN
2126: trace(p_msg => '# row deleted into xla_aad_loader_logs = '||SQL%ROWCOUNT,
2127: p_module => l_log_module,
2128: p_level => C_LEVEL_EVENT);
2129: END IF;
2130:

Line 2444: INSERT INTO xla_aad_loader_logs

2440: ,p_module => l_log_module);
2441: END IF;
2442:
2443: FORALL i IN 1 .. g_err_msgs.COUNT
2444: INSERT INTO xla_aad_loader_logs
2445: (aad_loader_log_id
2446: ,amb_context_code
2447: ,application_id
2448: ,request_code

Line 2463: (xla_aad_loader_logs_s.nextval

2459: ,program_application_id
2460: ,program_id
2461: ,request_id)
2462: VALUES
2463: (xla_aad_loader_logs_s.nextval
2464: ,p_amb_context_code
2465: ,p_application_id
2466: ,p_request_code
2467: ,'ERROR'

Line 2482: trace(p_msg => '# errors inserted into xla_aad_loader_logs = '||SQL%ROWCOUNT

2478: ,xla_environment_pkg.g_prog_id
2479: ,xla_environment_pkg.g_req_Id);
2480:
2481: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
2482: trace(p_msg => '# errors inserted into xla_aad_loader_logs = '||SQL%ROWCOUNT
2483: ,p_module => l_log_module
2484: ,p_level => C_LEVEL_STATEMENT);
2485: END IF;
2486:

Line 4164: -- Description: This API inserts the data into xla_aad_loader_logs table.

4160:
4161: --=============================================================================
4162: -- Bug 9923803:
4163: -- Name: insert_aadloaderlog
4164: -- Description: This API inserts the data into xla_aad_loader_logs table.
4165: --
4166: --=============================================================================
4167: PROCEDURE insert_aadloaderlog(
4168: p_amb_context_code IN VARCHAR2

Line 4177: INSERT INTO xla_aad_loader_logs

4173: ,p_component_code IN VARCHAR2)
4174: IS
4175: PRAGMA AUTONOMOUS_TRANSACTION;
4176: BEGIN
4177: INSERT INTO xla_aad_loader_logs
4178: (aad_loader_log_id ,amb_context_code ,application_id ,request_code ,log_type_code ,encoded_message ,message_num
4179: ,component_code ,object_version_number ,creation_date ,created_by ,last_update_date ,last_updated_by ,last_update_login
4180: ,program_update_date ,program_application_id ,program_id ,request_id)
4181: VALUES

Line 4182: (xla_aad_loader_logs_s.NEXTVAL ,p_amb_context_code ,p_application_id ,p_request_code ,p_log_type_code ,p_encoded_message,0

4178: (aad_loader_log_id ,amb_context_code ,application_id ,request_code ,log_type_code ,encoded_message ,message_num
4179: ,component_code ,object_version_number ,creation_date ,created_by ,last_update_date ,last_updated_by ,last_update_login
4180: ,program_update_date ,program_application_id ,program_id ,request_id)
4181: VALUES
4182: (xla_aad_loader_logs_s.NEXTVAL ,p_amb_context_code ,p_application_id ,p_request_code ,p_log_type_code ,p_encoded_message,0
4183: ,p_component_code ,1,SYSDATE ,xla_environment_pkg.g_usr_id ,SYSDATE ,xla_environment_pkg.g_usr_id ,xla_environment_pkg.g_login_id
4184: ,sysdate,xla_environment_pkg.g_prog_appl_id ,xla_environment_pkg.g_prog_id ,xla_environment_pkg.g_req_Id);
4185: COMMIT;
4186: EXCEPTION