APPS.JA_CN_PS_SI_PRJ_EXPORT_PKG dependencies on FND_LOG

Line 50: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

46: , pn_accounting_year IN NUMBER
47: )
48: IS
49: lv_procedure_name VARCHAR(30) := 'Add_Project_Information';
50: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
51: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
52: ln_row_count NUMBER := 0;
53: lv_prj_seg VARCHAR2(20);
54: lv_prj_id_seg VARCHAR2(20) := 'FLEX_VALUE';

Line 51: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

47: )
48: IS
49: lv_procedure_name VARCHAR(30) := 'Add_Project_Information';
50: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
51: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
52: ln_row_count NUMBER := 0;
53: lv_prj_seg VARCHAR2(20);
54: lv_prj_id_seg VARCHAR2(20) := 'FLEX_VALUE';
55: lv_prj_name_seg VARCHAR2(20) := 'DESCRIPTION';

Line 78: FND_LOG.STRING( ln_proc_level

74: BEGIN
75: --logging for debug
76: IF (ln_proc_level >= ln_dbg_level)
77: THEN
78: FND_LOG.STRING( ln_proc_level
79: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.begin'
80: , 'Enter procedure');
81: --logging the parameters
82: FND_LOG.STRING( ln_proc_level

Line 82: FND_LOG.STRING( ln_proc_level

78: FND_LOG.STRING( ln_proc_level
79: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.begin'
80: , 'Enter procedure');
81: --logging the parameters
82: FND_LOG.STRING( ln_proc_level
83: , GV_MODULE_PREFIX || '.' || lv_procedure_name
84: || '.parameters'
85: , 'pn_coa_id=' || pn_coa_id || ','
86: || 'pv_accounting_year=' || pn_accounting_year);

Line 133: FND_LOG.STRING( ln_proc_level

129: , pn_coa_id
130: );
131: IF(ln_proc_level >= ln_dbg_level)
132: THEN
133: FND_LOG.STRING( ln_proc_level
134: , lv_procedure_name || '.variables'
135: , 'lv_prj_seg='|| lv_prj_seg ||','
136: || 'lv_prj_level_attr=' || lv_prj_level_attr||','
137: || 'lv_prj_type_attr=' || lv_prj_type_attr||','

Line 211: FND_LOG.STRING( ln_proc_level

207: ')';
208: --logging for debug
209: IF( ln_proc_level >= ln_dbg_level )
210: THEN
211: FND_LOG.STRING( ln_proc_level
212: , lv_procedure_name || '.variables'
213: , 'lv_cursor_sql=' || lv_cursor_sql );
214: END IF ;
215: FND_FILE.PUT_LINE( FND_FILE.log

Line 330: FND_LOG.STRING( ln_proc_level

326: END IF; -- (ln_row_count = 0)
327: --logging for debug
328: IF (ln_proc_level >= ln_dbg_level)
329: THEN
330: FND_LOG.STRING( ln_proc_level
331: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end'
332: , 'Exit Procedure');
333: END IF; --(ln_proc_level >= ln_dgb_level)
334: EXCEPTION

Line 336: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

332: , 'Exit Procedure');
333: END IF; --(ln_proc_level >= ln_dgb_level)
334: EXCEPTION
335: WHEN OTHERS THEN
336: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
337: THEN
338: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
339: , GV_MODULE_PREFIX || '.' || lv_procedure_name ||
340: '.Other Exception'

Line 338: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

334: EXCEPTION
335: WHEN OTHERS THEN
336: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
337: THEN
338: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
339: , GV_MODULE_PREFIX || '.' || lv_procedure_name ||
340: '.Other Exception'
341: , SQLCODE || SQLERRM);
342: END IF; --(FND_LOG.LEVEL.UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 342: END IF; --(FND_LOG.LEVEL.UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

338: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
339: , GV_MODULE_PREFIX || '.' || lv_procedure_name ||
340: '.Other Exception'
341: , SQLCODE || SQLERRM);
342: END IF; --(FND_LOG.LEVEL.UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
343: FND_FILE.put_line( FND_FILE.log
344: , lv_procedure_name || SQLCODE || SQLERRM);
345: RAISE;
346: END Add_Project_Information;