APPS.JA_CN_FA_MI_EXPORT_PKG dependencies on FND_LOG

Line 52: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 53: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

Line 54: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

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

Line 139: FND_LOG.STRING(ln_proc_level,

135: --logging for debug
136: FND_FILE.PUT_LINE(FND_FILE.log, lv_procedure_name);
137: IF (ln_proc_level >= ln_dbg_level)
138: THEN
139: FND_LOG.STRING(ln_proc_level,
140: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
141: '.begin',
142: 'Enter procedure');
143: FND_LOG.STRING(ln_proc_level,

Line 143: FND_LOG.STRING(ln_proc_level,

139: FND_LOG.STRING(ln_proc_level,
140: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
141: '.begin',
142: 'Enter procedure');
143: FND_LOG.STRING(ln_proc_level,
144: lv_procedure_name ||
145: '.parameters',
146: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
147: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 182: FND_LOG.STRING(ln_statement_level,

178:
179: --logging the variables
180: IF (ln_statement_level >= ln_dbg_level)
181: THEN
182: FND_LOG.STRING(ln_statement_level,
183: lv_procedure_name,
184: 'ld_start_date=' || ld_start_date || ',' ||
185: 'ld_end_date=' || ld_end_date);
186: END IF; --(ln_statement_level >= ln_dbg_level)

Line 744: FND_LOG.STRING(ln_proc_level,

740: END IF; --ln_row_count = 0
741:
742: --logging for debug
743: IF (ln_proc_level >= ln_dbg_level) THEN
744: FND_LOG.STRING(ln_proc_level,
745: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
746: 'Exit procedure');
747: END IF; -- (ln_proc_level>=ln_dbg_level)
748: EXCEPTION

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

746: 'Exit procedure');
747: END IF; -- (ln_proc_level>=ln_dbg_level)
748: EXCEPTION
749: WHEN OTHERS THEN
750: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
751: THEN
752: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
753: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
754: '.Other_Exception ',

Line 752: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

748: EXCEPTION
749: WHEN OTHERS THEN
750: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
751: THEN
752: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
753: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
754: '.Other_Exception ',
755: SQLCODE || SQLERRM);
756: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

752: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
753: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
754: '.Other_Exception ',
755: SQLCODE || SQLERRM);
756: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
757: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
758: RAISE;
759: END Add_Asset_Modification_Info;
760: