32: | build its query. bug # 3113574 |
33: | 10/13/2003 S. Singhania Added NOCOPY hint to OUT parameters in |
34: | GET_QUERY_STRINGS |
35: | 03/24/2004 S. Singhania Added local trace procedure and added |
36: | FND_LOG messages. |
37: | Bug 3389175. Added a condition to perform |
38: | outerjoin to the Trx id view if fnd log |
39: | is enabled. |
40: | 06/27/2005 W. Shen Bug 4447717. directly return if no |
34: | GET_QUERY_STRINGS |
35: | 03/24/2004 S. Singhania Added local trace procedure and added |
36: | FND_LOG messages. |
37: | Bug 3389175. Added a condition to perform |
38: | outerjoin to the Trx id view if fnd log |
39: | is enabled. |
40: | 06/27/2005 W. Shen Bug 4447717. directly return if no |
41: | transaction identifier |
42: | 07/20/2005 W. Shen Change the get_transcation_identifiers |
67:
68: --=============================================================================
69: -- *********** Local Trace Routine **********
70: --=============================================================================
71: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
72: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
73: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
74: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
75: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
68: --=============================================================================
69: -- *********** Local Trace Routine **********
70: --=============================================================================
71: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
72: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
73: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
74: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
75: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
76: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
69: -- *********** Local Trace Routine **********
70: --=============================================================================
71: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
72: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
73: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
74: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
75: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
76: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
77:
70: --=============================================================================
71: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
72: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
73: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
74: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
75: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
76: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
77:
78: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
71: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
72: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
73: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
74: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
75: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
76: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
77:
78: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
79: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_transaction_id_pkg';
72: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
73: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
74: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
75: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
76: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
77:
78: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
79: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_transaction_id_pkg';
80:
86: ,p_level IN NUMBER
87: ,p_module IN VARCHAR2 DEFAULT C_DEFAULT_MODULE) IS
88: BEGIN
89: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
90: fnd_log.message(p_level, p_module);
91: ELSIF p_level >= g_log_level THEN
92: fnd_log.string(p_level, p_module, p_msg);
93: END IF;
94:
88: BEGIN
89: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
90: fnd_log.message(p_level, p_module);
91: ELSIF p_level >= g_log_level THEN
92: fnd_log.string(p_level, p_module, p_msg);
93: END IF;
94:
95: EXCEPTION
96: WHEN xla_exceptions_pkg.application_exception THEN
893: --
894: --=============================================================================
895:
896: BEGIN
897: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
898: g_log_enabled := fnd_log.test
899: (log_level => g_log_level
900: ,module => C_DEFAULT_MODULE);
901:
894: --=============================================================================
895:
896: BEGIN
897: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
898: g_log_enabled := fnd_log.test
899: (log_level => g_log_level
900: ,module => C_DEFAULT_MODULE);
901:
902: IF NOT g_log_enabled THEN