APPS.JA_CN_FA_ADIRA_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_Real_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: lv_period_name VARCHAR2(10);

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_Real_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: lv_period_name VARCHAR2(10);
56: ld_start_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_Real_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: lv_period_name VARCHAR2(10);
56: ld_start_date DATE;
57: ld_end_date DATE;

Line 123: FND_LOG.STRING(ln_proc_level,

119: --logging for debug
120: FND_FILE.PUT_LINE(FND_FILE.log, lv_procedure_name);
121: IF (ln_proc_level >= ln_dbg_level)
122: THEN
123: FND_LOG.STRING(ln_proc_level,
124: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
125: '.begin',
126: 'Enter procedure');
127: FND_LOG.STRING(ln_proc_level,

Line 127: FND_LOG.STRING(ln_proc_level,

123: FND_LOG.STRING(ln_proc_level,
124: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
125: '.begin',
126: 'Enter procedure');
127: FND_LOG.STRING(ln_proc_level,
128: lv_procedure_name ||
129: '.parameters',
130: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
131: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 166: FND_LOG.STRING(ln_statement_level,

162:
163: --logging the variables
164: IF (ln_statement_level >= ln_dbg_level)
165: THEN
166: FND_LOG.STRING(ln_statement_level,
167: lv_procedure_name,
168: 'ld_start_date=' || ld_start_date || ',' ||
169: 'ld_end_date=' || ld_end_date);
170: END IF; --(ln_statement_level >= ln_dbg_level)

Line 258: FND_LOG.STRING(ln_proc_level,

254: END IF; --ln_row_count = 0
255:
256: --logging for debug
257: IF (ln_proc_level >= ln_dbg_level) THEN
258: FND_LOG.STRING(ln_proc_level,
259: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
260: 'Exit procedure');
261: END IF; -- (ln_proc_level>=ln_dbg_level)
262: EXCEPTION

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

260: 'Exit procedure');
261: END IF; -- (ln_proc_level>=ln_dbg_level)
262: EXCEPTION
263: WHEN OTHERS THEN
264: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
265: THEN
266: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
267: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
268: '.Other_Exception ',

Line 266: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

262: EXCEPTION
263: WHEN OTHERS THEN
264: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
265: THEN
266: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
267: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
268: '.Other_Exception ',
269: SQLCODE || SQLERRM);
270: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

266: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
267: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
268: '.Other_Exception ',
269: SQLCODE || SQLERRM);
270: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
271: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
272: RAISE;
273: END Add_Asset_Decreasing_Real_Info;
274: