APPS.JA_CN_FA_MM_EXPORT_PKG dependencies on FND_LOG

Line 51: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

47: , pv_period_from IN VARCHAR2
48: , pv_period_to IN VARCHAR2
49: )
50: IS
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: lv_procedure_name VARCHAR2(40) := 'Add_FA_Modification_Method';
55: lv_tran_type_code VARCHAR2(20);

Line 52: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

48: , pv_period_to IN VARCHAR2
49: )
50: IS
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: lv_procedure_name VARCHAR2(40) := 'Add_FA_Modification_Method';
55: lv_tran_type_code VARCHAR2(20);
56: lv_tran_type VARCHAR2(80);

Line 53: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

49: )
50: IS
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: lv_procedure_name VARCHAR2(40) := 'Add_FA_Modification_Method';
55: lv_tran_type_code VARCHAR2(20);
56: lv_tran_type VARCHAR2(80);
57: ld_start_date DATE;

Line 111: FND_LOG.STRING( ln_proc_level

107:
108: --logging for debug
109: IF (ln_proc_level>=ln_dbg_level)
110: THEN
111: FND_LOG.STRING( ln_proc_level
112: , GV_MODULE_PREFIX ||'.' || lv_procedure_name ||
113: '.begin'
114: , 'Enter procedure'
115: );

Line 118: FND_LOG.STRING(ln_proc_level,

114: , 'Enter procedure'
115: );
116:
117: -- logging the parameters
118: FND_LOG.STRING(ln_proc_level,
119: lv_procedure_name ||
120: '.parameters',
121: 'pn_legal_entity_id=' || pn_legal_entity_id|| ',' ||
122: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 164: FND_LOG.STRING(ln_statement_level,

160:
161: --log start data and end date
162: IF (ln_statement_level >= ln_dbg_level)
163: THEN
164: FND_LOG.STRING(ln_statement_level,
165: lv_procedure_name,
166: 'Fetched: start date=' ||
167: nvl(to_char(ld_start_date), 'null') || ' end date=' ||
168: nvl(to_char(ld_end_date), 'null'));

Line 238: FND_LOG.STRING( ln_proc_level

234:
235: --logging for debug
236: IF (ln_proc_level>=ln_dbg_level)
237: THEN
238: FND_LOG.STRING( ln_proc_level
239: , GV_MODULE_PREFIX ||'.' || lv_procedure_name || '.end'
240: , 'Exit procedure'
241: );
242: END IF; -- (ln_proc_level>=ln_dbg_level)

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

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

Line 248: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

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

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

248: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
249: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
250: '.Other_Exception ',
251: SQLCODE || SQLERRM);
252: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
253: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
254:
255: END Add_FA_Modification_Method;
256: END JA_CN_FA_MM_EXPORT_PKG;