APPS.JA_CN_PS_FA_BI_EXP_PKG dependencies on FND_LOG

Line 54: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

50: , pv_period_to IN VARCHAR2
51: )
52: IS
53: lv_procedure_name VARCHAR2(40) := 'Add_Basic_Information';
54: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
55: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
56: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
57: ld_start_date DATE;
58: ld_end_date DATE;

Line 55: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

51: )
52: IS
53: lv_procedure_name VARCHAR2(40) := 'Add_Basic_Information';
54: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
55: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
56: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
57: ld_start_date DATE;
58: ld_end_date DATE;
59: ln_cost_row_count NUMBER := 0;

Line 56: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

52: IS
53: lv_procedure_name VARCHAR2(40) := 'Add_Basic_Information';
54: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
55: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
56: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
57: ld_start_date DATE;
58: ld_end_date DATE;
59: ln_cost_row_count NUMBER := 0;
60:

Line 132: FND_LOG.STRING( ln_proc_level

128: BEGIN
129: --logging for debug
130: IF (ln_proc_level >= ln_dbg_level)
131: THEN
132: FND_LOG.STRING( ln_proc_level
133: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.begin'
134: , 'Enter procedure');
135: -- logging the parameters
136: FND_LOG.STRING( ln_proc_level

Line 136: FND_LOG.STRING( ln_proc_level

132: FND_LOG.STRING( ln_proc_level
133: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.begin'
134: , 'Enter procedure');
135: -- logging the parameters
136: FND_LOG.STRING( ln_proc_level
137: , lv_procedure_name || '.parameters'
138: , 'pn_legal_entity_id=' || pn_legal_entity_id || ','
139: || 'pn_ledger_id=' || pn_ledger_id || ','
140: || 'pv_accounting_year=' || pv_accounting_year || ','

Line 189: FND_LOG.STRING( ln_statement_level

185:
186: --logging the variables
187: IF (ln_statement_level >= ln_dbg_level)
188: THEN
189: FND_LOG.STRING( ln_statement_level
190: , lv_procedure_name
191: , 'ld_start_date=' || ld_start_date || ','
192: || 'ld_end_date=' || ld_end_date
193: );

Line 243: FND_LOG.STRING( ln_proc_level

239:
240: --logging for debug
241: IF (ln_proc_level >= ln_dbg_level)
242: THEN
243: FND_LOG.STRING( ln_proc_level
244: , GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end'
245: , 'Exit procedure');
246: END IF; -- (ln_proc_level>=ln_dbg_level)
247: EXCEPTION

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

245: , 'Exit procedure');
246: END IF; -- (ln_proc_level>=ln_dbg_level)
247: EXCEPTION
248: WHEN OTHERS THEN
249: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
250: THEN
251: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
252: , GV_MODULE_PREFIX || '.' || lv_procedure_name
253: || '.Other_Exception '

Line 251: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

247: EXCEPTION
248: WHEN OTHERS THEN
249: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
250: THEN
251: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
252: , GV_MODULE_PREFIX || '.' || lv_procedure_name
253: || '.Other_Exception '
254: , SQLCODE || SQLERRM);
255: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 255: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

251: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
252: , GV_MODULE_PREFIX || '.' || lv_procedure_name
253: || '.Other_Exception '
254: , SQLCODE || SQLERRM);
255: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
256: FND_FILE.put_line( FND_FILE.log
257: , lv_procedure_name || SQLCODE || SQLERRM);
258: RAISE;
259: END Add_Basic_Information;