eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JA_CN_FA_RAI_EXPORT_PKG dependencies on FND_LOG

Line 55: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

51: pn_ledger_id IN NUMBER,
52: pv_accounting_year IN VARCHAR2,
53: pv_period_from IN VARCHAR2,
54: pv_period_to IN VARCHAR2) IS
55: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
56: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
57: lv_procedure_name VARCHAR2(40) := 'Add_FA_Real_Asset_Info';
58: ld_start_date DATE;
59: ld_end_date DATE;

Line 56: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

52: pv_accounting_year IN VARCHAR2,
53: pv_period_from IN VARCHAR2,
54: pv_period_to IN VARCHAR2) IS
55: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
56: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
57: lv_procedure_name VARCHAR2(40) := 'Add_FA_Real_Asset_Info';
58: ld_start_date DATE;
59: ld_end_date DATE;
60: ld_start_date_monthly DATE;

Line 77: FND_LOG.STRING(ln_proc_level,

73:
74: BEGIN
75: --logging for debug
76: IF (ln_proc_level >= ln_dbg_level) THEN
77: FND_LOG.STRING(ln_proc_level,
78: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
79: '.begin',
80: 'Enter procedure');
81:

Line 83: FND_LOG.STRING(ln_proc_level,

79: '.begin',
80: 'Enter procedure');
81:
82: -- logging the parameters
83: FND_LOG.STRING(ln_proc_level,
84: lv_procedure_name || '.parameters',
85: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
86: 'pn_ledger_id=' || pn_ledger_id || ',' ||
87: 'pv_accounting_year=' || pv_accounting_year || ',' ||

Line 177: FND_LOG.STRING(ln_proc_level,

173: pv_module_name => Ja_Cn_Utility.GV_MODULE_FA);
174: END IF; --IF (ln_row_count = 0)
175: --logging for debug
176: IF (ln_proc_level >= ln_dbg_level) THEN
177: FND_LOG.STRING(ln_proc_level,
178: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
179: 'Exit procedure');
180: END IF; -- (ln_proc_level>=ln_dbg_level)
181:

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

180: END IF; -- (ln_proc_level>=ln_dbg_level)
181:
182: EXCEPTION
183: WHEN OTHERS THEN
184: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
185: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
186: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
187: '.Other_Exception ',
188: SQLCODE || SQLERRM);

Line 185: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

181:
182: EXCEPTION
183: WHEN OTHERS THEN
184: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
185: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
186: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
187: '.Other_Exception ',
188: SQLCODE || SQLERRM);
189: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

185: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
186: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
187: '.Other_Exception ',
188: SQLCODE || SQLERRM);
189: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
190: FND_FILE.put_line(FND_FILE.log,
191: lv_procedure_name || SQLCODE || SQLERRM);
192: END Add_FA_Real_Asset_Info;
193:

Line 224: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

220: pv_accounting_year IN VARCHAR2,
221: pv_period_from IN VARCHAR2,
222: pv_period_to IN VARCHAR2)
223: RETURN NUMBER IS
224: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
225: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
226: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
227: ln_full_retirement_count NUMBER := 0;
228: ln_reinstate_count NUMBER := 0;

Line 225: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

221: pv_period_from IN VARCHAR2,
222: pv_period_to IN VARCHAR2)
223: RETURN NUMBER IS
224: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
225: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
226: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
227: ln_full_retirement_count NUMBER := 0;
228: ln_reinstate_count NUMBER := 0;
229: ln_row_count NUMBER := 0;

Line 226: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

222: pv_period_to IN VARCHAR2)
223: RETURN NUMBER IS
224: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
225: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
226: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
227: ln_full_retirement_count NUMBER := 0;
228: ln_reinstate_count NUMBER := 0;
229: ln_row_count NUMBER := 0;
230: lb_retirement_flag BOOLEAN := false;

Line 319: FND_LOG.STRING(ln_proc_level,

315: BEGIN
316:
317: --logging for debug
318: IF (ln_proc_level >= ln_dbg_level) THEN
319: FND_LOG.STRING(ln_proc_level,
320: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
321: '.begin',
322: 'Enter procedure');
323:

Line 325: FND_LOG.STRING(ln_proc_level,

321: '.begin',
322: 'Enter procedure');
323:
324: -- logging the parameters
325: FND_LOG.STRING(ln_proc_level,
326: lv_procedure_name || '.parameters',
327: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
328: 'pn_ledger_id=' || pn_ledger_id || ',' ||
329: 'pv_accounting_year=' || pv_accounting_year || ',' ||

Line 369: FND_LOG.STRING(ln_statement_level,

365: END IF; -- pv_period_to IS NOT NULL
366:
367: --log start data and end date
368: IF (ln_statement_level >= ln_dbg_level) THEN
369: FND_LOG.STRING(ln_statement_level,
370: lv_procedure_name,
371: 'Fetched: start date=' ||
372: nvl(to_char(ld_start_date), 'null') || ' end date=' ||
373: nvl(to_char(ld_end_date), 'null'));

Line 566: FND_LOG.STRING(ln_proc_level,

562: END IF; --(ln_row_count = 0)*/
563:
564: --logging for debug
565: IF (ln_proc_level >= ln_dbg_level) THEN
566: FND_LOG.STRING(ln_proc_level,
567: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
568: 'Exit procedure');
569: END IF; -- (ln_proc_level>=ln_dbg_level)
570:

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

576: END IF; --(ln_row_count = 0)
577:
578: EXCEPTION
579: WHEN OTHERS THEN
580: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
581: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
582: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
583: '.Other_Exception ',
584: SQLCODE || SQLERRM);

Line 581: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

577:
578: EXCEPTION
579: WHEN OTHERS THEN
580: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
581: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
582: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
583: '.Other_Exception ',
584: SQLCODE || SQLERRM);
585: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

581: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
582: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
583: '.Other_Exception ',
584: SQLCODE || SQLERRM);
585: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
586: FND_FILE.put_line(FND_FILE.log,
587: lv_procedure_name || SQLCODE || SQLERRM);
588:
589: END Add_FA_Real_Asset_Info_Monthly;