DBA Data[Home] [Help]

APPS.JA_CN_CFSSE_CALCULATE_PKG dependencies on FND_LOG

Line 29: g_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

25: --TYPE G_PERIOD_NAME_TBL IS TABLE OF gl_periods.period_name%TYPE INDEX BY BINARY_INTEGER;
26:
27: --==== Golbal Variables ============
28: g_module_name VARCHAR2(30) := 'JA_CN_CFSSE_CALCULATE_PKG';
29: g_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
30: g_proc_level NUMBER := FND_LOG.Level_Procedure;
31: g_stmt_level NUMBER := FND_LOG.Level_Statement;
32:
33: --==========================================================================

Line 30: g_proc_level NUMBER := FND_LOG.Level_Procedure;

26:
27: --==== Golbal Variables ============
28: g_module_name VARCHAR2(30) := 'JA_CN_CFSSE_CALCULATE_PKG';
29: g_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
30: g_proc_level NUMBER := FND_LOG.Level_Procedure;
31: g_stmt_level NUMBER := FND_LOG.Level_Statement;
32:
33: --==========================================================================
34: -- PROCEDURE NAME:

Line 31: g_stmt_level NUMBER := FND_LOG.Level_Statement;

27: --==== Golbal Variables ============
28: g_module_name VARCHAR2(30) := 'JA_CN_CFSSE_CALCULATE_PKG';
29: g_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
30: g_proc_level NUMBER := FND_LOG.Level_Procedure;
31: g_stmt_level NUMBER := FND_LOG.Level_Statement;
32:
33: --==========================================================================
34: -- PROCEDURE NAME:
35: -- Populate_LastYear_Period_Names Private

Line 97: FND_LOG.STRING(g_proc_level,

93: BEGIN
94: --log for debug
95: IF (g_proc_level >= g_dbg_level)
96: THEN
97: FND_LOG.STRING(g_proc_level,
98: g_module_name || '.' || l_procedure_name || '.begin',
99: 'begin procedure');
100: END IF; --( g_proc_level >= g_dbg_level)
101:

Line 137: FND_LOG.STRING(g_proc_level,

133:
134: --log for debug
135: IF (g_proc_level >= g_dbg_level)
136: THEN
137: FND_LOG.STRING(g_proc_level,
138: g_module_name || '.' || l_procedure_name || '.end',
139: 'end procedure');
140: END IF; --( g_proc_level >= g_dbg_level)
141:

Line 144: IF (FND_LOG.LEVEL_UNEXPECTED >= g_dbg_level)

140: END IF; --( g_proc_level >= g_dbg_level)
141:
142: EXCEPTION
143: WHEN OTHERS THEN
144: IF (FND_LOG.LEVEL_UNEXPECTED >= g_dbg_level)
145: THEN
146: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
147: g_module_name || l_procedure_name ||
148: '.OTHER_EXCEPTION',

Line 146: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

142: EXCEPTION
143: WHEN OTHERS THEN
144: IF (FND_LOG.LEVEL_UNEXPECTED >= g_dbg_level)
145: THEN
146: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
147: g_module_name || l_procedure_name ||
148: '.OTHER_EXCEPTION',
149: SQLCODE || ':' || SQLERRM);
150: END IF;

Line 281: FND_LOG.STRING(g_proc_level,

277: BEGIN
278: --log for debug
279: IF (g_proc_level >= g_dbg_level)
280: THEN
281: FND_LOG.STRING(g_proc_level,
282: g_module_name || '.' || l_procedure_name || '.begin',
283: 'begin procedure');
284: FND_LOG.STRING(g_proc_level,
285: g_module_name || '.' || l_procedure_name ||

Line 284: FND_LOG.STRING(g_proc_level,

280: THEN
281: FND_LOG.STRING(g_proc_level,
282: g_module_name || '.' || l_procedure_name || '.begin',
283: 'begin procedure');
284: FND_LOG.STRING(g_proc_level,
285: g_module_name || '.' || l_procedure_name ||
286: '.p_legal_entity_id is',
287: p_legal_entity_id);
288: FND_LOG.STRING(g_proc_level,

Line 288: FND_LOG.STRING(g_proc_level,

284: FND_LOG.STRING(g_proc_level,
285: g_module_name || '.' || l_procedure_name ||
286: '.p_legal_entity_id is',
287: p_legal_entity_id);
288: FND_LOG.STRING(g_proc_level,
289: g_module_name || '.' || l_procedure_name ||
290: '.p_ledger_id is',
291: p_ledger_id);
292: FND_LOG.STRING(g_proc_level,

Line 292: FND_LOG.STRING(g_proc_level,

288: FND_LOG.STRING(g_proc_level,
289: g_module_name || '.' || l_procedure_name ||
290: '.p_ledger_id is',
291: p_ledger_id);
292: FND_LOG.STRING(g_proc_level,
293: g_module_name || '.' || l_procedure_name ||
294: '.p_period_name is',
295: p_period_name);
296: FND_LOG.STRING(g_proc_level,

Line 296: FND_LOG.STRING(g_proc_level,

292: FND_LOG.STRING(g_proc_level,
293: g_module_name || '.' || l_procedure_name ||
294: '.p_period_name is',
295: p_period_name);
296: FND_LOG.STRING(g_proc_level,
297: g_module_name || '.' || l_procedure_name ||
298: '.p_axis_set_id is',
299: p_axis_set_id);
300: FND_LOG.STRING(g_proc_level,

Line 300: FND_LOG.STRING(g_proc_level,

296: FND_LOG.STRING(g_proc_level,
297: g_module_name || '.' || l_procedure_name ||
298: '.p_axis_set_id is',
299: p_axis_set_id);
300: FND_LOG.STRING(g_proc_level,
301: g_module_name || '.' || l_procedure_name ||
302: '.p_rounding_option is',
303: p_rounding_option);
304: FND_LOG.STRING(g_proc_level,

Line 304: FND_LOG.STRING(g_proc_level,

300: FND_LOG.STRING(g_proc_level,
301: g_module_name || '.' || l_procedure_name ||
302: '.p_rounding_option is',
303: p_rounding_option);
304: FND_LOG.STRING(g_proc_level,
305: g_module_name || '.' || l_procedure_name ||
306: '.p_balance_type is',
307: p_balance_type);
308:

Line 309: FND_LOG.STRING(g_proc_level,

305: g_module_name || '.' || l_procedure_name ||
306: '.p_balance_type is',
307: p_balance_type);
308:
309: FND_LOG.STRING(g_proc_level,
310: g_module_name || '.' || l_procedure_name ||
311: '.p_coa',
312: p_coa);
313:

Line 314: FND_LOG.STRING(g_proc_level, --Added for CNAO Enhancement

310: g_module_name || '.' || l_procedure_name ||
311: '.p_coa',
312: p_coa);
313:
314: FND_LOG.STRING(g_proc_level, --Added for CNAO Enhancement
315: g_module_name || '.' || l_segment_override ||
316: '.p_segment_override',
317: p_segment_override);
318: END IF; --( g_proc_level >= g_dbg_level)

Line 358: FND_LOG.STRING(g_stmt_level,

354:
355: --log for debug
356: IF (g_stmt_level >= g_dbg_level)
357: THEN
358: FND_LOG.STRING(g_stmt_level,
359: g_module_name || '.' || l_procedure_name ||
360: '.call JA_CN_CFS_CALCULATE_PKG.Categorize_Rows',
361: 'Successfully');
362: END IF; --( g_stmt_level >= g_dbg_level)

Line 379: FND_LOG.STRING(g_stmt_level,

375:
376: --log for debug
377: IF (g_stmt_level >= g_dbg_level)
378: THEN
379: FND_LOG.STRING(g_stmt_level,
380: g_module_name || '.' || l_procedure_name ||
381: '.call JA_CN_CFS_CALCULATE_PKG.Populate_Period_Names',
382: 'Successfully');
383: END IF; --( g_stmt_level >= g_dbg_level)

Line 418: FND_LOG.STRING(g_stmt_level,

414:
415: --log for debug
416: IF (g_stmt_level >= g_dbg_level)
417: THEN
418: FND_LOG.STRING(g_stmt_level,
419: g_module_name || '.' || l_procedure_name ||
420: '.call JA_CN_CFS_CALCULATE_PKG.Calculate_Rows_Amount',
421: 'Successfully');
422: END IF; --( g_stmt_level >= g_dbg_level)

Line 459: FND_LOG.STRING(g_stmt_level,

455:
456: --log for debug
457: IF (g_stmt_level >= g_dbg_level)
458: THEN
459: FND_LOG.STRING(g_stmt_level,
460: g_module_name || '.' || l_procedure_name ||
461: '.operate each row',
462: rec_rows.TYPE);
463: END IF; --( g_stmt_level >= g_dbg_level)

Line 554: FND_LOG.STRING(g_stmt_level,

550:
551: --log for debug
552: IF (g_stmt_level >= g_dbg_level)
553: THEN
554: FND_LOG.STRING(g_stmt_level,
555: g_module_name || '.' || l_procedure_name ||
556: '.row detail',
557: l_xml_output_row.getclobval());
558: END IF; --( g_stmt_level >= g_dbg_level)

Line 656: FND_LOG.STRING(g_stmt_level,

652:
653: --log for debug
654: IF (g_stmt_level >= g_dbg_level)
655: THEN
656: FND_LOG.STRING(g_stmt_level,
657: g_module_name || '.' || l_procedure_name ||
658: '.row detail',
659: l_xml_output_row.getclobval());
660: END IF; --( g_stmt_level >= g_dbg_level)

Line 692: FND_LOG.STRING(g_stmt_level,

688:
689: --log for debug
690: IF (g_stmt_level >= g_dbg_level)
691: THEN
692: FND_LOG.STRING(g_stmt_level,
693: g_module_name || '.' || l_procedure_name ||
694: '.row detail',
695: l_xml_output_row.getclobval());
696: END IF; --( g_stmt_level >= g_dbg_level)

Line 776: FND_LOG.STRING(g_proc_level,

772:
773: --log for debug
774: IF (g_proc_level >= g_dbg_level)
775: THEN
776: FND_LOG.STRING(g_proc_level,
777: g_module_name || '.' || l_procedure_name || '.end',
778: 'end procedure');
779: END IF; --( g_proc_level >= g_dbg_level)
780:

Line 783: IF (FND_LOG.LEVEL_UNEXPECTED >= g_dbg_level)

779: END IF; --( g_proc_level >= g_dbg_level)
780:
781: EXCEPTION
782: WHEN OTHERS THEN
783: IF (FND_LOG.LEVEL_UNEXPECTED >= g_dbg_level)
784: THEN
785: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
786: g_module_name || l_procedure_name ||
787: '.OTHER_EXCEPTION',

Line 785: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

781: EXCEPTION
782: WHEN OTHERS THEN
783: IF (FND_LOG.LEVEL_UNEXPECTED >= g_dbg_level)
784: THEN
785: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
786: g_module_name || l_procedure_name ||
787: '.OTHER_EXCEPTION',
788: SQLCODE || ':' || SQLERRM);
789: END IF;