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: +===========================================================================*/
25:
26: --=============================================================================
27: -- *********** Local Trace Routine **********
28: --=============================================================================
29: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
30: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
31: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
32: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
33: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
26: --=============================================================================
27: -- *********** Local Trace Routine **********
28: --=============================================================================
29: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
30: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
31: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
32: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
33: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
34: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
27: -- *********** Local Trace Routine **********
28: --=============================================================================
29: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
30: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
31: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
32: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
33: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
34: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
35:
28: --=============================================================================
29: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
30: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
31: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
32: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
33: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
34: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
35:
36: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
29: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
30: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
31: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
32: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
33: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
34: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
35:
36: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
37: C_DEFAULT_MODULE CONSTANT VARCHAR2(240):= 'xla.plsql.XLA_CREATE_ACCT_RPT_PVT ';
30: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
31: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
32: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
33: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
34: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
35:
36: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
37: C_DEFAULT_MODULE CONSTANT VARCHAR2(240):= 'xla.plsql.XLA_CREATE_ACCT_RPT_PVT ';
38:
45: ,p_level IN NUMBER
46: ,p_module IN VARCHAR2) IS
47: BEGIN
48: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
49: fnd_log.message(p_level, NVL(p_module,C_DEFAULT_MODULE));
50: ELSIF p_level >= g_log_level THEN
51: fnd_log.string(p_level, NVL(p_module,C_DEFAULT_MODULE), p_msg);
52: END IF;
53:
47: BEGIN
48: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
49: fnd_log.message(p_level, NVL(p_module,C_DEFAULT_MODULE));
50: ELSIF p_level >= g_log_level THEN
51: fnd_log.string(p_level, NVL(p_module,C_DEFAULT_MODULE), p_msg);
52: END IF;
53:
54: EXCEPTION
55: WHEN xla_exceptions_pkg.application_exception THEN
334: --
335: --=============================================================================
336:
337: BEGIN
338: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
339: g_log_enabled := fnd_log.test
340: (log_level => g_log_level
341: ,MODULE => C_DEFAULT_MODULE);
342:
335: --=============================================================================
336:
337: BEGIN
338: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
339: g_log_enabled := fnd_log.test
340: (log_level => g_log_level
341: ,MODULE => C_DEFAULT_MODULE);
342:
343: IF NOT g_log_enabled THEN