APPS.JA_CN_JRCFI_EXPORT_PKG dependencies on FND_LOG

Line 61: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

57: pv_period_from IN VARCHAR2,
58: pv_period_to IN VARCHAR2,
59: pn_cfs_report_id NUMBER) IS
60: lv_procedure_name VARCHAR2(40) := 'Add_Journal_Cash_Flow_Items';
61: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
62: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
63: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
64: NO_DATA EXCEPTION;
65: ln_cash_flow_item_rule NUMBER;

Line 62: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

58: pv_period_to IN VARCHAR2,
59: pn_cfs_report_id NUMBER) IS
60: lv_procedure_name VARCHAR2(40) := 'Add_Journal_Cash_Flow_Items';
61: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
62: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
63: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
64: NO_DATA EXCEPTION;
65: ln_cash_flow_item_rule NUMBER;
66: ld_start_date DATE;

Line 63: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

59: pn_cfs_report_id NUMBER) IS
60: lv_procedure_name VARCHAR2(40) := 'Add_Journal_Cash_Flow_Items';
61: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
62: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
63: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
64: NO_DATA EXCEPTION;
65: ln_cash_flow_item_rule NUMBER;
66: ld_start_date DATE;
67: ld_end_date DATE;

Line 230: FND_LOG.STRING(ln_proc_level,

226:
227: BEGIN
228: --logging for debug
229: IF (ln_proc_level >= ln_dbg_level) THEN
230: FND_LOG.STRING(ln_proc_level,
231: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
232: '.begin',
233: 'Enter procedure');
234: -- logging the parameters

Line 235: FND_LOG.STRING(ln_proc_level,

231: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
232: '.begin',
233: 'Enter procedure');
234: -- logging the parameters
235: FND_LOG.STRING(ln_proc_level,
236: lv_procedure_name || '.parameters',
237: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
238: 'pn_ledger_id=' || pn_ledger_id || ',' ||
239: 'pv_accounting_year=' || pv_accounting_year || ',' ||

Line 264: FND_LOG.STRING(ln_proc_level,

260: CLOSE cash_flow_item_rule_cur;
261:
262: --logging the variables
263: IF (ln_proc_level >= ln_dbg_level) THEN
264: FND_LOG.STRING(ln_proc_level,
265: lv_procedure_name,
266: 'The cash flow item rule is:' ||
267: ln_cash_flow_item_rule);
268: END IF; --(ln_proc_level >= ln_dbg_level)

Line 297: FND_LOG.STRING(ln_statement_level,

293: END IF; --pv_period_to IS NOT NULL
294:
295: --logging the variables
296: IF (ln_statement_level >= ln_dbg_level) THEN
297: FND_LOG.STRING(ln_statement_level,
298: lv_procedure_name,
299: 'ld_start_date' || ld_start_date || ',' ||
300: 'ld_end_date=' || ld_end_date);
301: END IF; --(ln_statement_level >= ln_dbg_level)

Line 369: FND_LOG.STRING(ln_proc_level,

365: END IF; --(ln_row_count = 0)
366:
367: --logging for debug
368: IF (ln_proc_level >= ln_dbg_level) THEN
369: FND_LOG.STRING(ln_proc_level,
370: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
371: 'Exit procedure');
372: END IF; -- (ln_proc_level>=ln_dbg_level)
373:

Line 376: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

372: END IF; -- (ln_proc_level>=ln_dbg_level)
373:
374: EXCEPTION
375: WHEN OTHERS THEN
376: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
377: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
378: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
379: '.Other_Exception ',
380: SQLCODE || SQLERRM);

Line 377: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

373:
374: EXCEPTION
375: WHEN OTHERS THEN
376: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
377: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
378: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
379: '.Other_Exception ',
380: SQLCODE || SQLERRM);
381: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

377: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
378: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
379: '.Other_Exception ',
380: SQLCODE || SQLERRM);
381: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
382: FND_FILE.put_line(FND_FILE.log,
383: lv_procedure_name || SQLCODE || SQLERRM);
384: RAISE;
385: END Add_Journal_Cash_Flow_Items;