16: | HISTORY |
17: | 01/27/2006 V. Swapna Created |
18: | 03/27/2006 V. Swapna Modify the filter for zero amount lines |
19: | and add the initialization routine for the |
20: | trace messages to appear in the fnd_log. |
21: | 08/24/2006 Ejaz Sayyed bug#5417847 change in condition to pick the|
22: | negative amt lines and drop zero amt lines |
23: | i.e.debit/credit <> 0 for p_zero_amt_filter|
24: | 02/16/2009 N. K. Surana Instead of function calling new PROCEDURE |
27:
28: --=============================================================================
29: -- *********** Local Trace Routine **********
30: --=============================================================================
31: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
32: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
33: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
34: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
35: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
28: --=============================================================================
29: -- *********** Local Trace Routine **********
30: --=============================================================================
31: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
32: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
33: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
34: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
35: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
36: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
29: -- *********** Local Trace Routine **********
30: --=============================================================================
31: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
32: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
33: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
34: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
35: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
36: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
37:
30: --=============================================================================
31: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
32: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
33: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
34: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
35: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
36: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
37:
38: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
31: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
32: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
33: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
34: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
35: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
36: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
37:
38: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
39: C_DEFAULT_MODULE CONSTANT VARCHAR2(240):= 'xla.plsql.XLA_CREATE_ACCT_RPT_PVT ';
32: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
33: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
34: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
35: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
36: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
37:
38: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
39: C_DEFAULT_MODULE CONSTANT VARCHAR2(240):= 'xla.plsql.XLA_CREATE_ACCT_RPT_PVT ';
40:
47: ,p_level IN NUMBER
48: ,p_module IN VARCHAR2) IS
49: BEGIN
50: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
51: fnd_log.message(p_level, NVL(p_module,C_DEFAULT_MODULE));
52: ELSIF p_level >= g_log_level THEN
53: fnd_log.string(p_level, NVL(p_module,C_DEFAULT_MODULE), p_msg);
54: END IF;
55:
49: BEGIN
50: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
51: fnd_log.message(p_level, NVL(p_module,C_DEFAULT_MODULE));
52: ELSIF p_level >= g_log_level THEN
53: fnd_log.string(p_level, NVL(p_module,C_DEFAULT_MODULE), p_msg);
54: END IF;
55:
56: EXCEPTION
57: WHEN xla_exceptions_pkg.application_exception THEN
355: --
356: --=============================================================================
357:
358: BEGIN
359: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
360: g_log_enabled := fnd_log.test
361: (log_level => g_log_level
362: ,MODULE => C_DEFAULT_MODULE);
363:
356: --=============================================================================
357:
358: BEGIN
359: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
360: g_log_enabled := fnd_log.test
361: (log_level => g_log_level
362: ,MODULE => C_DEFAULT_MODULE);
363:
364: IF NOT g_log_enabled THEN