APPS.JA_CN_CFI_EXPORT_PKG dependencies on FND_LOG

Line 58: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

54: ,pn_chart_of_account_id IN NUMBER
55: )
56: IS
57: lv_procedure_name VARCHAR2(40) := 'Add_Cash_Flow_Items';
58: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
59: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
60: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
61: lv_error_msg VARCHAR2(2000) := NULL;
62: lv_added_zero VARCHAR2(30) := '';

Line 59: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

55: )
56: IS
57: lv_procedure_name VARCHAR2(40) := 'Add_Cash_Flow_Items';
58: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
59: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
60: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
61: lv_error_msg VARCHAR2(2000) := NULL;
62: lv_added_zero VARCHAR2(30) := '';
63: ln_max_length NUMBER := 0;

Line 60: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

56: IS
57: lv_procedure_name VARCHAR2(40) := 'Add_Cash_Flow_Items';
58: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
59: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
60: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
61: lv_error_msg VARCHAR2(2000) := NULL;
62: lv_added_zero VARCHAR2(30) := '';
63: ln_max_length NUMBER := 0;
64: lv_report_name VARCHAR2(100) := NULL;

Line 110: FND_LOG.STRING(ln_proc_level,

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

Line 115: FND_LOG.STRING(ln_proc_level,

111: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
112: '.begin',
113: 'Enter procedure');
114: -- logging the parameters
115: FND_LOG.STRING(ln_proc_level,
116: lv_procedure_name ||
117: '.parameters',
118: 'pn_chart_of_account_id=' || pn_chart_of_account_id || ',' ||
119: 'pn_cfs_report_id=' || pn_cfs_report_id);

Line 190: FND_LOG.STRING(ln_statement_level,

186:
187: --logging the variables
188: IF (ln_statement_level >= ln_dbg_level)
189: THEN
190: FND_LOG.STRING(ln_statement_level,
191: lv_procedure_name,
192: 'ln_rec_count:' || ln_rec_count);
193: END IF; --(ln_statement_level >= ln_dbg_level)
194: FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

Line 268: FND_LOG.STRING(ln_proc_level,

264:
265: --logging for debug
266: IF (ln_proc_level >= ln_dbg_level)
267: THEN
268: FND_LOG.STRING(ln_proc_level,
269: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
270: 'Exit procedure');
271: END IF; -- (ln_proc_level>=ln_dbg_level)
272:

Line 279: FND_LOG.STRING(ln_proc_level,

275: /* WHEN NO_DATA THEN
276: --logging for debug
277: IF (ln_proc_level >= ln_dbg_level)
278: THEN
279: FND_LOG.STRING(ln_proc_level,
280: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
281: 'exception',
282: 'No data for Cash Flow Items');
283: END IF; --ln_proc_level>=ln_dbg_level

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

284: Ja_Cn_Utility.Print_No_Data_Found_For_Log('CASH_FLOW_ITEMS');
285: RAISE;*/
286: --End: Deleted for bug# 9722570
287: WHEN OTHERS THEN
288: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
289: THEN
290: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
291: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
292: '.Other_Exception ',

Line 290: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

286: --End: Deleted for bug# 9722570
287: WHEN OTHERS THEN
288: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
289: THEN
290: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
291: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
292: '.Other_Exception ',
293: SQLCODE || SQLERRM);
294: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

290: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
291: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
292: '.Other_Exception ',
293: SQLCODE || SQLERRM);
294: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
295: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
296: RAISE;
297: END Add_Cash_Flow_Items;
298: