DBA Data[Home] [Help]

APPS.JA_CN_FSG_FORMULA_EXTRACT_PKG dependencies on FND_LOG

Line 120: ln_dbg_level NUMBER :=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

116: AND jcccg.axis_set_id=jccrcg.axis_set_id
117: AND jcccg.cal_axis_seq=jccrcg.axis_seq
118: ORDER BY jcccg.calculation_seq;
119:
120: ln_dbg_level NUMBER :=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
121: ln_proc_level NUMBER :=FND_LOG.LEVEL_PROCEDURE;
122: lv_proc_name VARCHAR2(100) :='Extract_Row_Formula';
123:
124: BEGIN

Line 121: ln_proc_level NUMBER :=FND_LOG.LEVEL_PROCEDURE;

117: AND jcccg.cal_axis_seq=jccrcg.axis_seq
118: ORDER BY jcccg.calculation_seq;
119:
120: ln_dbg_level NUMBER :=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
121: ln_proc_level NUMBER :=FND_LOG.LEVEL_PROCEDURE;
122: lv_proc_name VARCHAR2(100) :='Extract_Row_Formula';
123:
124: BEGIN
125:

Line 129: FND_LOG.String(ln_proc_level

125:
126: --log
127: IF (ln_proc_level >= ln_dbg_level)
128: THEN
129: FND_LOG.String(ln_proc_level
130: ,GV_MODULE_PREFIX||'.'||lv_proc_name||'.begin'
131: ,'Enter procedure'
132: );
133: FND_LOG.String(ln_proc_level

Line 133: FND_LOG.String(ln_proc_level

129: FND_LOG.String(ln_proc_level
130: ,GV_MODULE_PREFIX||'.'||lv_proc_name||'.begin'
131: ,'Enter procedure'
132: );
133: FND_LOG.String(ln_proc_level
134: ,GV_MODULE_PREFIX||'.'||lv_proc_name||'.parameters'
135: ,'pn_coa '||ln_coa
136: );
137: FND_LOG.String(ln_proc_level

Line 137: FND_LOG.String(ln_proc_level

133: FND_LOG.String(ln_proc_level
134: ,GV_MODULE_PREFIX||'.'||lv_proc_name||'.parameters'
135: ,'pn_coa '||ln_coa
136: );
137: FND_LOG.String(ln_proc_level
138: ,GV_MODULE_PREFIX||'.'||lv_proc_name||'.parameters'
139: ,'pn_axis_set_id '||ln_axis_set_id
140: );
141: FND_LOG.String(ln_proc_level

Line 141: FND_LOG.String(ln_proc_level

137: FND_LOG.String(ln_proc_level
138: ,GV_MODULE_PREFIX||'.'||lv_proc_name||'.parameters'
139: ,'pn_axis_set_id '||ln_axis_set_id
140: );
141: FND_LOG.String(ln_proc_level
142: ,GV_MODULE_PREFIX||'.'||lv_proc_name||'.parameters'
143: ,'pn_axis_seq '||ln_axis_seq
144: );
145: END IF;

Line 261: FND_LOG.STRING(ln_proc_level

257:
258: --log for debug
259: IF ( ln_proc_level >= ln_dbg_level)
260: THEN
261: FND_LOG.STRING(ln_proc_level
262: ,GV_MODULE_PREFIX||'.'||lv_proc_name||'.end'
263: ,'Exit procedure'
264: );
265: END IF;

Line 271: FND_LOG.String(ln_proc_level

267: EXCEPTION
268: WHEN OTHERS THEN
269: IF (ln_proc_level >= ln_dbg_level)
270: THEN
271: FND_LOG.String(ln_proc_level
272: ,GV_MODULE_PREFIX||'.'||lv_proc_name||'. Other_Exception '
273: ,SQLCODE||':'||SQLERRM
274: );
275: END IF;

Line 409: ln_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;

405: AND axis_set_id=ln_axis_set_id
406: AND axis_name=lv_axis_name_low;
407:
408:
409: ln_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
410: ln_proc_level NUMBER :=FND_LOG.Level_Procedure;
411: lv_proc_name VARCHAR2(100) :='Populate_Formula';
412:
413:

Line 410: ln_proc_level NUMBER :=FND_LOG.Level_Procedure;

406: AND axis_name=lv_axis_name_low;
407:
408:
409: ln_dbg_level NUMBER :=FND_LOG.G_Current_Runtime_Level;
410: ln_proc_level NUMBER :=FND_LOG.Level_Procedure;
411: lv_proc_name VARCHAR2(100) :='Populate_Formula';
412:
413:
414: BEGIN

Line 419: FND_LOG.String(ln_proc_level

415:
416: --log for debug
417: IF (ln_proc_level >= ln_dbg_level)
418: THEN
419: FND_LOG.String(ln_proc_level
420: ,GV_MODULE_PREFIX||'.'||lv_proc_name||'.begin'
421: ,'Enter procedure'
422: );
423: FND_LOG.String(ln_proc_level

Line 423: FND_LOG.String(ln_proc_level

419: FND_LOG.String(ln_proc_level
420: ,GV_MODULE_PREFIX||'.'||lv_proc_name||'.begin'
421: ,'Enter procedure'
422: );
423: FND_LOG.String(ln_proc_level
424: ,GV_MODULE_PREFIX||'.'||lv_proc_name||'.parameters'
425: ,'pn_coa '||ln_coa
426: );
427: FND_LOG.String(ln_proc_level

Line 427: FND_LOG.String(ln_proc_level

423: FND_LOG.String(ln_proc_level
424: ,GV_MODULE_PREFIX||'.'||lv_proc_name||'.parameters'
425: ,'pn_coa '||ln_coa
426: );
427: FND_LOG.String(ln_proc_level
428: ,GV_MODULE_PREFIX||'.'||lv_proc_name||'.parameters'
429: ,'pn_axis_set_id '||ln_axis_set_id
430: );
431: FND_LOG.String(ln_proc_level

Line 431: FND_LOG.String(ln_proc_level

427: FND_LOG.String(ln_proc_level
428: ,GV_MODULE_PREFIX||'.'||lv_proc_name||'.parameters'
429: ,'pn_axis_set_id '||ln_axis_set_id
430: );
431: FND_LOG.String(ln_proc_level
432: ,GV_MODULE_PREFIX||'.'||lv_proc_name||'.parameters'
433: ,'pn_axis_seq '||ln_axis_seq
434: );
435: END IF;

Line 666: FND_LOG.STRING(ln_proc_level

662:
663: --log for debug
664: IF ( ln_proc_level >= ln_dbg_level)
665: THEN
666: FND_LOG.STRING(ln_proc_level
667: ,GV_MODULE_PREFIX||'.'||lv_proc_name||'.end'
668: ,'Exit procedure'
669: );
670: END IF;

Line 676: FND_LOG.String(ln_proc_level

672: EXCEPTION
673: WHEN OTHERS THEN
674: IF (ln_proc_level >= ln_dbg_level)
675: THEN
676: FND_LOG.String(ln_proc_level
677: ,GV_module_prefix||'.'||lv_proc_name||'.Other_Exception '
678: ,SQLCODE||':'||SQLERRM
679: );
680: END IF; --(ln_proc_level >= ln_dbg_level)