APPS.JA_CN_FA_ADI_EXPORT_PKG dependencies on FND_LOG

Line 51: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

47: ,pv_accounting_year VARCHAR2
48: ,pv_period_from VARCHAR2
49: ,pv_period_to VARCHAR2) IS
50: lv_procedure_name VARCHAR2(40) := 'Add_Asset_Decreasing_Info';
51: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
52: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
53: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
54: ln_row_count NUMBER;
55: ld_start_date DATE;

Line 52: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

48: ,pv_period_from VARCHAR2
49: ,pv_period_to VARCHAR2) IS
50: lv_procedure_name VARCHAR2(40) := 'Add_Asset_Decreasing_Info';
51: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
52: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
53: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
54: ln_row_count NUMBER;
55: ld_start_date DATE;
56: ld_end_date DATE;

Line 53: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

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

Line 176: FND_LOG.STRING(ln_proc_level,

172: --logging for debug
173: FND_FILE.PUT_LINE(FND_FILE.log, lv_procedure_name);
174: IF (ln_proc_level >= ln_dbg_level)
175: THEN
176: FND_LOG.STRING(ln_proc_level,
177: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
178: '.begin',
179: 'Enter procedure');
180: FND_LOG.STRING(ln_proc_level,

Line 180: FND_LOG.STRING(ln_proc_level,

176: FND_LOG.STRING(ln_proc_level,
177: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
178: '.begin',
179: 'Enter procedure');
180: FND_LOG.STRING(ln_proc_level,
181: lv_procedure_name ||
182: '.parameters',
183: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
184: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 218: FND_LOG.STRING(ln_statement_level,

214:
215: --logging the variables
216: IF (ln_statement_level >= ln_dbg_level)
217: THEN
218: FND_LOG.STRING(ln_statement_level,
219: lv_procedure_name,
220: 'ld_start_date=' || ld_start_date || ',' ||
221: 'ld_end_date=' || ld_end_date);
222: END IF; --(ln_statement_level >= ln_dbg_level)

Line 498: FND_LOG.STRING(ln_proc_level,

494: END IF; --ln_row_count = 0
495:
496: --logging for debug
497: IF (ln_proc_level >= ln_dbg_level) THEN
498: FND_LOG.STRING(ln_proc_level,
499: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
500: 'Exit procedure');
501: END IF; -- (ln_proc_level>=ln_dbg_level)
502: EXCEPTION

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

500: 'Exit procedure');
501: END IF; -- (ln_proc_level>=ln_dbg_level)
502: EXCEPTION
503: WHEN OTHERS THEN
504: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
505: THEN
506: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
507: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
508: '.Other_Exception ',

Line 506: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

502: EXCEPTION
503: WHEN OTHERS THEN
504: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
505: THEN
506: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
507: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
508: '.Other_Exception ',
509: SQLCODE || SQLERRM);
510: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

506: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
507: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
508: '.Other_Exception ',
509: SQLCODE || SQLERRM);
510: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
511: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
512: RAISE;
513: END Add_Asset_Decreasing_Info;
514: