DBA Data[Home] [Help]

APPS.JA_CN_FA_BI_EXPORT_PKG dependencies on FND_LOG

Line 55: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 56: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

Line 57: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

53: IS
54: lv_procedure_name VARCHAR2(40) := 'Add_Basic_Information';
55: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
56: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
57: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
58: NO_DATA EXCEPTION;
59: ld_start_date DATE;
60: ld_end_date DATE;
61: ln_cost_row_count NUMBER; -- row count for fixed asset account

Line 213: FND_LOG.STRING(ln_proc_level,

209: BEGIN
210: --logging for debug
211: IF (ln_proc_level >= ln_dbg_level)
212: THEN
213: FND_LOG.STRING(ln_proc_level,
214: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
215: '.begin',
216: 'Enter procedure');
217: -- logging the parameters

Line 218: FND_LOG.STRING(ln_proc_level,

214: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
215: '.begin',
216: 'Enter procedure');
217: -- logging the parameters
218: FND_LOG.STRING(ln_proc_level,
219: lv_procedure_name ||
220: '.parameters',
221: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
222: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 266: FND_LOG.STRING(ln_statement_level,

262:
263: --logging the variables
264: IF (ln_statement_level >= ln_dbg_level)
265: THEN
266: FND_LOG.STRING(ln_statement_level,
267: lv_procedure_name,
268: 'ld_start_date' || ld_start_date || ',' ||
269: 'ld_end_date=' || ld_end_date);
270: END IF; --(ln_statement_level >= ln_dbg_level)

Line 365: FND_LOG.STRING(ln_proc_level,

361:
362: --logging for debug
363: IF (ln_proc_level >= ln_dbg_level)
364: THEN
365: FND_LOG.STRING(ln_proc_level,
366: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
367: 'Exit procedure');
368: END IF; -- (ln_proc_level>=ln_dbg_level)
369: EXCEPTION

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

367: 'Exit procedure');
368: END IF; -- (ln_proc_level>=ln_dbg_level)
369: EXCEPTION
370: WHEN OTHERS THEN
371: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
372: THEN
373: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
374: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
375: '.Other_Exception ',

Line 373: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

369: EXCEPTION
370: WHEN OTHERS THEN
371: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
372: THEN
373: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
374: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
375: '.Other_Exception ',
376: SQLCODE || SQLERRM);
377: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

373: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
374: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
375: '.Other_Exception ',
376: SQLCODE || SQLERRM);
377: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
378: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
379: RAISE;
380: END Add_Basic_Information;
381: