DBA Data[Home] [Help]

APPS.XLA_CMP_EXTRACT_PKG dependencies on FND_LOG

Line 43: | 23-FEB-2004 K.Boussema Made changes for the FND_LOG. |

39: | GenerateExtractColumns and |
40: | GenerateHeaderCursor procedures |
41: | 02-FEB-2004 K.Boussema Reviewed FlushGtTable procedure |
42: | 11-FEB-2004 K.Boussema Revised GenerateHeaderCursor procedure |
43: | 23-FEB-2004 K.Boussema Made changes for the FND_LOG. |
44: | 12-MAR-2004 K.Boussema Changed to incorporate the select of lookups |
45: | from the extract objects |
46: | 22-MAR-2004 K.Boussema Added a parameter p_module to the TRACE calls|
47: | and the procedure. |

Line 685: --| CALL FND_LOG trace API |

681: --
682: --
683: --+==========================================================================+
684: --| |
685: --| CALL FND_LOG trace API |
686: --| |
687: --| |
688: --| |
689: --| |

Line 709: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

705: --=============================================================================
706: -- *********** Local Trace Routine **********
707: --=============================================================================
708:
709: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
710: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
711: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
712: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
713: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

Line 710: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;

706: -- *********** Local Trace Routine **********
707: --=============================================================================
708:
709: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
710: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
711: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
712: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
713: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
714: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 711: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;

707: --=============================================================================
708:
709: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
710: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
711: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
712: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
713: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
714: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
715:

Line 712: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;

708:
709: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
710: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
711: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
712: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
713: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
714: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
715:
716: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;

Line 713: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;

709: C_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
710: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
711: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
712: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
713: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
714: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
715:
716: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
717: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_cmp_extract_pkg';

Line 714: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

710: C_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
711: C_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
712: C_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
713: C_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
714: C_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
715:
716: C_LEVEL_LOG_DISABLED CONSTANT NUMBER := 99;
717: C_DEFAULT_MODULE CONSTANT VARCHAR2(240) := 'xla.plsql.xla_cmp_extract_pkg';
718:

Line 729: -- Following is for FND log.

725: ,p_module IN VARCHAR2)
726: IS
727: BEGIN
728: ----------------------------------------------------------------------------
729: -- Following is for FND log.
730: ----------------------------------------------------------------------------
731: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
732: fnd_log.message(p_level, p_module);
733: ELSIF p_level >= g_log_level THEN

Line 732: fnd_log.message(p_level, p_module);

728: ----------------------------------------------------------------------------
729: -- Following is for FND log.
730: ----------------------------------------------------------------------------
731: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
732: fnd_log.message(p_level, p_module);
733: ELSIF p_level >= g_log_level THEN
734: fnd_log.string(p_level, p_module, p_msg);
735: END IF;
736:

Line 734: fnd_log.string(p_level, p_module, p_msg);

730: ----------------------------------------------------------------------------
731: IF (p_msg IS NULL AND p_level >= g_log_level) THEN
732: fnd_log.message(p_level, p_module);
733: ELSIF p_level >= g_log_level THEN
734: fnd_log.string(p_level, p_module, p_msg);
735: END IF;
736:
737: EXCEPTION
738: WHEN xla_exceptions_pkg.application_exception THEN

Line 6163: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

6159: --=============================================================================
6160:
6161: BEGIN
6162:
6163: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6164: g_log_enabled := fnd_log.test
6165: (log_level => g_log_level
6166: ,module => C_DEFAULT_MODULE);
6167:

Line 6164: g_log_enabled := fnd_log.test

6160:
6161: BEGIN
6162:
6163: g_log_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
6164: g_log_enabled := fnd_log.test
6165: (log_level => g_log_level
6166: ,module => C_DEFAULT_MODULE);
6167:
6168: IF NOT g_log_enabled THEN