27: | 30-JUL-2003 K.Boussema Updated the definition of C_FLEXFIELD_SEGMENT|
28: | 27-SEP-2003 K.Boussema Reviewed the generation of conditions |
29: | 18-DEC-2003 K.Boussema Changed to fix bug 3042840,3307761,3268940 |
30: | 3310291 and 3320689 |
31: | 23-FEB-2004 K.Boussema Made changes for the FND_LOG. |
32: | 22-MAR-2004 K.Boussema Added a parameter p_module to the TRACE calls|
33: | and the procedure. |
34: | 28-APR-2004 K.Boussema Bug 3596711: |
35: | Changed the compiler to allow a row in cond.|
167: --=============================================================================
168: -- *********** Local Trace Routine **********
169: --=============================================================================
170:
171: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
172: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
173: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
174: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
175: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
168: -- *********** Local Trace Routine **********
169: --=============================================================================
170:
171: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
172: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
173: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
174: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
175: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
176: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
169: --=============================================================================
170:
171: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
172: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
173: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
174: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
175: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
176: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
177:
170:
171: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
172: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
173: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
174: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
175: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
176: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
177:
178: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
171: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
172: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
173: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
174: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
175: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
176: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
177:
178: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
179: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_cmp_condition_pkg';
172: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
173: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
174: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
175: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
176: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
177:
178: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
179: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_cmp_condition_pkg';
180:
187: ,p_module IN VARCHAR2)
188: IS
189: BEGIN
190: ----------------------------------------------------------------------------
191: -- Following is for FND log.
192: ----------------------------------------------------------------------------
193: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
194: fnd_log.message(p_level, p_module);
195: ELSIF p_level >= g_log_level THEN
190: ----------------------------------------------------------------------------
191: -- Following is for FND log.
192: ----------------------------------------------------------------------------
193: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
194: fnd_log.message(p_level, p_module);
195: ELSIF p_level >= g_log_level THEN
196: fnd_log.string(p_level, p_module, p_msg);
197: END IF;
198:
192: ----------------------------------------------------------------------------
193: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
194: fnd_log.message(p_level, p_module);
195: ELSIF p_level >= g_log_level THEN
196: fnd_log.string(p_level, p_module, p_msg);
197: END IF;
198:
199: EXCEPTION
200: WHEN xla_exceptions_pkg.application_exception THEN
813: --=============================================================================
814:
815: BEGIN
816:
817: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
818: g_log_enabled := fnd_log.test
819: (log_level => g_log_level
820: ,module => C_DEFAULT_MODULE);
821:
814:
815: BEGIN
816:
817: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
818: g_log_enabled := fnd_log.test
819: (log_level => g_log_level
820: ,module => C_DEFAULT_MODULE);
821:
822: IF NOT g_log_enabled THEN