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_ACUI_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_Usage_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_Usage_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 176: FND_LOG.STRING(ln_proc_level,

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

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

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

Line 184: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

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

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

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

Line 223: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

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

Line 224: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

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

Line 225: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

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

Line 408: FND_LOG.STRING(ln_proc_level,

404: BEGIN
405:
406: --logging for debug
407: IF (ln_proc_level >= ln_dbg_level) THEN
408: FND_LOG.STRING(ln_proc_level,
409: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
410: '.begin',
411: 'Enter procedure');
412:

Line 414: FND_LOG.STRING(ln_proc_level,

410: '.begin',
411: 'Enter procedure');
412:
413: -- logging the parameters
414: FND_LOG.STRING(ln_proc_level,
415: lv_procedure_name || '.parameters',
416: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
417: 'pn_ledger_id=' || pn_ledger_id || ',' ||
418: 'pv_accounting_year=' || pv_accounting_year || ',' ||

Line 457: FND_LOG.STRING(ln_statement_level,

453: ld_end_date := to_date(pv_accounting_year || '1231', 'YYYYMMDD');
454: END IF; -- pv_period_to IS NOT NULL
455:
456: IF (ln_statement_level >= ln_dbg_level) THEN
457: FND_LOG.STRING(ln_statement_level,
458: lv_procedure_name,
459: 'Fetched: start date=' ||
460: nvl(to_char(ld_start_date), 'null') || ' end date=' ||
461: nvl(to_char(ld_end_date), 'null'));

Line 470: FND_LOG.STRING(ln_proc_level,

466: nvl(to_char(ld_end_date), 'null'));
467:
468: --logging for debug
469: IF (ln_proc_level >= ln_dbg_level) THEN
470: FND_LOG.STRING(ln_proc_level,
471: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
472: 'Exit procedure');
473: END IF; -- (ln_proc_level>=ln_dbg_level)
474:

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

706: RETURN 1;
707: END IF; --(ln_row_count = 0)
708: EXCEPTION
709: WHEN OTHERS THEN
710: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
711: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
712: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
713: '.Other_Exception ',
714: SQLCODE || SQLERRM);

Line 711: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

707: END IF; --(ln_row_count = 0)
708: EXCEPTION
709: WHEN OTHERS THEN
710: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
711: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
712: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
713: '.Other_Exception ',
714: SQLCODE || SQLERRM);
715: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

711: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
712: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
713: '.Other_Exception ',
714: SQLCODE || SQLERRM);
715: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
716: FND_FILE.put_line(FND_FILE.log,
717: lv_procedure_name || SQLCODE || SQLERRM);
718:
719: END Add_FA_Usage_Info_Monthly;