18: | 18-MAR-2003 K.Boussema Added amb_context_code column |
19: | 22-APR-2003 K.Boussema Included error messages |
20: | 22-JUN-2003 K.Boussema Updated error messages |
21: | 17-JUL-2003 K.Boussema Reviewd the code |
22: | 23-FEB-2004 K.Boussema Made changes for the FND_LOG. |
23: | 17-MAR-2004 K.Boussema Reviewed GetPADHashId to handle multiple AADs|
24: | with the same name (same product_rule_code) |
25: | 22-MAR-2004 K.Boussema Added a parameter p_module to the TRACE calls|
26: | and the procedure. |
42: --=============================================================================
43: -- *********** Local Trace Routine **********
44: --=============================================================================
45:
46: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
47: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
48: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
49: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
50: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
43: -- *********** Local Trace Routine **********
44: --=============================================================================
45:
46: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
47: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
48: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
49: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
50: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
51: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
44: --=============================================================================
45:
46: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
47: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
48: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
49: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
50: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
51: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
52:
45:
46: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
47: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
48: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
49: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
50: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
51: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
52:
53: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
46: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
47: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
48: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
49: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
50: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
51: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
52:
53: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
54: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_cmp_hash_pkg';
47: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
48: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
49: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
50: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
51: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
52:
53: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
54: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_cmp_hash_pkg';
55:
61: ,p_level IN NUMBER
62: ,p_module IN VARCHAR2 DEFAULT C_DEFAULT_MODULE) IS
63: BEGIN
64: ----------------------------------------------------------------------------
65: -- Following is for FND log.
66: ----------------------------------------------------------------------------
67: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
68: fnd_log.message(p_level, p_module);
69: ELSIF p_level >= g_log_level THEN
64: ----------------------------------------------------------------------------
65: -- Following is for FND log.
66: ----------------------------------------------------------------------------
67: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
68: fnd_log.message(p_level, p_module);
69: ELSIF p_level >= g_log_level THEN
70: fnd_log.string(p_level, p_module, p_msg);
71: END IF;
72:
66: ----------------------------------------------------------------------------
67: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
68: fnd_log.message(p_level, p_module);
69: ELSIF p_level >= g_log_level THEN
70: fnd_log.string(p_level, p_module, p_msg);
71: END IF;
72:
73: EXCEPTION
74: WHEN xla_exceptions_pkg.application_exception THEN
722: --=============================================================================
723:
724: BEGIN
725:
726: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
727: g_log_enabled := fnd_log.test
728: (log_level => g_log_level
729: ,module => C_DEFAULT_MODULE);
730:
723:
724: BEGIN
725:
726: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
727: g_log_enabled := fnd_log.test
728: (log_level => g_log_level
729: ,module => C_DEFAULT_MODULE);
730:
731: IF NOT g_log_enabled THEN