300:
301: --=============================================================================
302: -- *********** Local Trace Routine **********
303: --=============================================================================
304: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
305: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
306: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
307: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
308: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
301: --=============================================================================
302: -- *********** Local Trace Routine **********
303: --=============================================================================
304: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
305: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
306: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
307: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
308: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
309: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
302: -- *********** Local Trace Routine **********
303: --=============================================================================
304: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
305: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
306: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
307: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
308: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
309: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
310:
303: --=============================================================================
304: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
305: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
306: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
307: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
308: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
309: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
310:
311: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
304: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
305: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
306: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
307: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
308: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
309: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
310:
311: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
312: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := ''$oracle_user_name$.plsql.$TAB_API_PACKAGE_NAME_3$'';
305: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
306: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
307: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
308: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
309: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
310:
311: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
312: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := ''$oracle_user_name$.plsql.$TAB_API_PACKAGE_NAME_3$'';
313:
321: )
322: IS
323: BEGIN
324: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
325: fnd_log.message(p_level, p_module);
326: ELSIF p_level >= g_log_level THEN
327: fnd_log.string(p_level, p_module, p_msg);
328: END IF;
329:
323: BEGIN
324: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
325: fnd_log.message(p_level, p_module);
326: ELSIF p_level >= g_log_level THEN
327: fnd_log.string(p_level, p_module, p_msg);
328: END IF;
329:
330: EXCEPTION
331: WHEN app_exceptions.application_exception THEN
636:
637:
638: --Trace initialization
639: BEGIN
640: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
641: g_log_enabled := fnd_log.test
642: (log_level => g_log_level
643: ,module => C_DEFAULT_MODULE);
644:
637:
638: --Trace initialization
639: BEGIN
640: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
641: g_log_enabled := fnd_log.test
642: (log_level => g_log_level
643: ,module => C_DEFAULT_MODULE);
644:
645: IF NOT g_log_enabled THEN
1322:
1323: --=============================================================================
1324: -- *********** Local Trace Routine **********
1325: --=============================================================================
1326: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1327: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1328: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1329: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1330: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1323: --=============================================================================
1324: -- *********** Local Trace Routine **********
1325: --=============================================================================
1326: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1327: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1328: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1329: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1330: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1331: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1324: -- *********** Local Trace Routine **********
1325: --=============================================================================
1326: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1327: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1328: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1329: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1330: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1331: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1332:
1325: --=============================================================================
1326: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1327: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1328: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1329: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1330: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1331: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1332:
1333: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
1326: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
1327: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1328: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1329: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1330: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1331: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1332:
1333: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
1334: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_cmp_tab_pkg';
1327: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
1328: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
1329: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
1330: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
1331: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
1332:
1333: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
1334: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_cmp_tab_pkg';
1335:
1344: ,p_level IN NUMBER
1345: ) IS
1346: BEGIN
1347: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
1348: fnd_log.message(p_level, p_module);
1349: ELSIF p_level >= g_log_level THEN
1350: fnd_log.string(p_level, p_module, p_msg);
1351: END IF;
1352:
1346: BEGIN
1347: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
1348: fnd_log.message(p_level, p_module);
1349: ELSIF p_level >= g_log_level THEN
1350: fnd_log.string(p_level, p_module, p_msg);
1351: END IF;
1352:
1353: EXCEPTION
1354: WHEN xla_exceptions_pkg.application_exception THEN
4583:
4584:
4585: --Trace initialization
4586: BEGIN
4587: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4588: g_log_enabled := fnd_log.test
4589: (log_level => g_log_level
4590: ,module => C_DEFAULT_MODULE);
4591:
4584:
4585: --Trace initialization
4586: BEGIN
4587: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
4588: g_log_enabled := fnd_log.test
4589: (log_level => g_log_level
4590: ,module => C_DEFAULT_MODULE);
4591:
4592: IF NOT g_log_enabled THEN