50: -- +-----------------+------------+---------------+
51: --
52: -------------------------------------------------------------------------------
53:
54: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
55: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
56: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
57: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
58: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
51: --
52: -------------------------------------------------------------------------------
53:
54: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
55: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
56: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
57: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
58: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
59: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
52: -------------------------------------------------------------------------------
53:
54: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
55: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
56: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
57: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
58: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
59: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
60: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
53:
54: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
55: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
56: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
57: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
58: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
59: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
60: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
61: G_MODULE_NAME CONSTANT VARCHAR2(50) :='AP.PLSQL.AP_SLA_PROCESSING_PKG.';
54: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
55: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
56: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
57: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
58: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
59: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
60: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
61: G_MODULE_NAME CONSTANT VARCHAR2(50) :='AP.PLSQL.AP_SLA_PROCESSING_PKG.';
62: G_COMMIT_SIZE CONSTANT NUMBER := 10000;
55: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;
56: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
57: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
58: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
59: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
60: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
61: G_MODULE_NAME CONSTANT VARCHAR2(50) :='AP.PLSQL.AP_SLA_PROCESSING_PKG.';
62: G_COMMIT_SIZE CONSTANT NUMBER := 10000;
63:
56: G_LEVEL_ERROR CONSTANT NUMBER := FND_LOG.LEVEL_ERROR;
57: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
58: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
59: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
60: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
61: G_MODULE_NAME CONSTANT VARCHAR2(50) :='AP.PLSQL.AP_SLA_PROCESSING_PKG.';
62: G_COMMIT_SIZE CONSTANT NUMBER := 10000;
63:
64: TYPE l_event_ids_typ IS TABLE OF NUMBER(15)
95: IS
96:
97: BEGIN
98: IF (p_level >= G_CURRENT_RUNTIME_LEVEL ) THEN
99: FND_LOG.STRING(p_level,
100: G_MODULE_NAME||p_procedure_name,
101: p_debug_info);
102: END IF;
103:
140: BEGIN
141:
142: l_curr_calling_sequence := 'ap_sla_processing_pkg'||l_procedure_name
143: ||'<-'||p_calling_sequence;
144: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
145:
146: ---------------------------------------------------------------------
147: l_debug_info := 'Begin of procedure '||l_procedure_name;
148: trace(G_LEVEL_PROCEDURE, l_procedure_name, l_debug_info);
357:
358: BEGIN
359:
360: l_curr_calling_sequence := 'AP_SLA_PROCESSING_PKG.PRE_ACCOUNTING_PROC';
361: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
362: ---------------------------------------------------------------------
363: l_debug_info := 'Begin of procedure '||l_procedure_name;
364: trace(G_LEVEL_PROCEDURE, l_procedure_name, l_debug_info);
365: ---------------------------------------------------------------------
591: l_event_ids l_event_ids_typ;
592:
593: BEGIN
594: l_curr_calling_sequence := 'AP_SLA_PROCESSING_PKG.POSTPROCESSING_PROC';
595: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
596:
597: -------------------------------------------------------------------------
598: l_debug_info := 'Begin of procedure '||l_procedure_name;
599: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
1852:
1853: BEGIN
1854:
1855: l_curr_calling_sequence := 'AP_SLA_PROCESSING_PKG.EXTRACT';
1856: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1857:
1858: -------------------------------------------------------------------------
1859: l_debug_info := 'Begin of procedure '||l_procedure_name;
1860: trace(G_LEVEL_STATEMENT, l_procedure_name, l_debug_info);
2063:
2064: BEGIN
2065:
2066: l_curr_calling_sequence := 'AP_SLA_PROCESSING_PKG.POST_ACCOUNTING_PROC';
2067: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2068: ---------------------------------------------------------------------
2069: l_debug_info := 'Begin of procedure '||l_procedure_name;
2070: trace(G_LEVEL_PROCEDURE, l_procedure_name, l_debug_info);
2071: ---------------------------------------------------------------------