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_APAB_EXPORT_PKG dependencies on FND_LOG

Line 65: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

61: ,pv_period_to IN VARCHAR2
62: )
63: IS
64: lv_procedure_name VARCHAR2(40) := 'Add_Account_Amount_Balance';
65: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
66: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
67: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
68: ln_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
69: NO_DATA EXCEPTION;

Line 66: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

62: )
63: IS
64: lv_procedure_name VARCHAR2(40) := 'Add_Account_Amount_Balance';
65: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
66: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
67: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
68: ln_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
69: NO_DATA EXCEPTION;
70:

Line 67: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

63: IS
64: lv_procedure_name VARCHAR2(40) := 'Add_Account_Amount_Balance';
65: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
66: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
67: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
68: ln_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
69: NO_DATA EXCEPTION;
70:
71: lv_debit FND_LOOKUP_VALUES.MEANING%TYPE;

Line 68: ln_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

64: lv_procedure_name VARCHAR2(40) := 'Add_Account_Amount_Balance';
65: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
66: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
67: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
68: ln_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
69: NO_DATA EXCEPTION;
70:
71: lv_debit FND_LOOKUP_VALUES.MEANING%TYPE;
72: lv_credit FND_LOOKUP_VALUES.MEANING%TYPE;

Line 254: FND_LOG.STRING(ln_proc_level,

250: BEGIN
251: --logging for debug
252: IF (ln_proc_level >= ln_dbg_level)
253: THEN
254: FND_LOG.STRING(ln_proc_level,
255: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
256: '.begin',
257: 'Enter procedure');
258: -- logging the parameters

Line 259: FND_LOG.STRING(ln_proc_level,

255: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
256: '.begin',
257: 'Enter procedure');
258: -- logging the parameters
259: FND_LOG.STRING(ln_proc_level,
260: lv_procedure_name ||
261: '.parameters',
262: 'pn_legal_entity_id=' || pn_legal_entity_id || ',' ||
263: 'pn_ledger_id=' || pn_ledger_id || ',' ||

Line 315: FND_LOG.STRING(ln_statement_level,

311:
312: --logging the variables
313: IF (ln_statement_level >= ln_dbg_level)
314: THEN
315: FND_LOG.STRING(ln_statement_level,
316: lv_procedure_name,
317: 'ld_start_date=' || ld_start_date || ',' ||
318: 'ld_end_date=' || ld_end_date);
319: END IF; --(ln_statement_level >= ln_dbg_level)

Line 359: FND_LOG.STRING(ln_statement_level,

355:
356: --logging the variables
357: IF (ln_statement_level >= ln_dbg_level)
358: THEN
359: FND_LOG.STRING(ln_statement_level,
360: lv_procedure_name,
361: 'ln_flex_value_set_id=' || ln_flex_value_set_id);
362: END IF; --(ln_statement_level >= ln_dbg_level)
363: FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

Line 387: FND_LOG.STRING(ln_statement_level,

383:
384: --logging the variables
385: IF (ln_statement_level >= ln_dbg_level)
386: THEN
387: FND_LOG.STRING(ln_statement_level,
388: lv_procedure_name,
389: 'l_attribute_column4balanceside=' || l_attribute_column4balanceside || ',' ||
390: 'l_attribute_column4account_lev=' || l_attribute_column4account_lev);
391: END IF; --(ln_statement_level >= ln_dbg_level)

Line 406: FND_LOG.STRING(ln_statement_level,

402: --Fetch the account subsidiary info for each account and save JA_CN_SUBSIDIARY_GT
403: OPEN c_in_ja_cn_account_balances;
404: --log
405: IF (ln_statement_level >= ln_dbg_level) THEN
406: FND_LOG.STRING(ln_statement_level,
407: GV_MODULE_PREFIX,
408: 'Fetched account segments start below:');
409: END IF; --ln_statement_level >= ln_runtime_level
410: lv_sql_stmt := 'insert into JA_CN_SUBSIDIARY_GT

Line 430: FND_LOG.STRING(ln_statement_level, GV_MODULE_PREFIX, l_account_segment);

426: EXIT WHEN c_in_ja_cn_account_balances%NOTFOUND;
427:
428: --log
429: IF (ln_statement_level >= ln_dbg_level) THEN
430: FND_LOG.STRING(ln_statement_level, GV_MODULE_PREFIX, l_account_segment);
431: END IF; --ln_statement_level >= ln_runtime_level
432: EXECUTE IMMEDIATE lv_sql_stmt
433: USING ln_flex_value_set_id, l_account_segment;
434: END LOOP;

Line 442: FND_LOG.STRING(ln_exception_level, GV_MODULE_PREFIX, lv_message);

438: FND_MESSAGE.set_name('JA', 'JA_CN_NO_DATA_FOUND');
439: lv_message := FND_MESSAGE.get();
440: FND_FILE.put_line(FND_FILE.LOG, lv_message);
441: IF (ln_exception_level >= ln_dbg_level) THEN
442: FND_LOG.STRING(ln_exception_level, GV_MODULE_PREFIX, lv_message);
443: END IF;
444: ln_row_count := 0;
445: END IF; --c_in_ja_cn_account_balances%ROWCOUNT = 0
446: CLOSE c_in_ja_cn_account_balances;

Line 466: FND_LOG.STRING(ln_statement_level,

462:
463: --logging the variables
464: IF (ln_statement_level >= ln_dbg_level)
465: THEN
466: FND_LOG.STRING(ln_statement_level,
467: lv_procedure_name,
468: 'l_functional_currency=' || l_functional_currency );
469: END IF; --(ln_statement_level >= ln_dbg_level)
470: FND_FILE.put_line(FND_FILE.log, lv_procedure_name ||

Line 491: FND_LOG.STRING(ln_statement_level,

487: AND period_name = l_current_period;
488:
489: --log current period and it's start date
490: IF (ln_statement_level >= ln_dbg_level) THEN
491: FND_LOG.STRING(ln_statement_level,
492: GV_MODULE_PREFIX,
493: 'about to generate journal lines info for period:' ||
494: l_current_period || ' start date:' ||
495: ld_current_start_date);

Line 507: FND_LOG.STRING(ln_statement_level,

503: INTO l_ja_cn_subsidiary_gbl_tmp_row;
504: EXIT WHEN c_in_ja_cn_subsidiary_gbl_tmp%NOTFOUND;
505: --log
506: IF (ln_statement_level >= ln_dbg_level) THEN
507: FND_LOG.STRING(ln_statement_level,
508: GV_MODULE_PREFIX,
509: 'about to generate group clause for account:' ||
510: l_ja_cn_subsidiary_gbl_tmp_row.account_segment_value);
511:

Line 803: FND_LOG.STRING(ln_proc_level,

799:
800: --logging for debug
801: IF (ln_proc_level >= ln_dbg_level)
802: THEN
803: FND_LOG.STRING(ln_proc_level,
804: GV_MODULE_PREFIX || '.' || lv_procedure_name || '.end',
805: 'Exit procedure');
806: END IF; -- (ln_proc_level>=ln_dbg_level)
807:

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

807:
808: --To handle the No Data Found Exception
809: EXCEPTION
810: WHEN OTHERS THEN
811: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
812: THEN
813: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
814: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
815: '.Other_Exception ',

Line 813: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,

809: EXCEPTION
810: WHEN OTHERS THEN
811: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
812: THEN
813: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
814: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
815: '.Other_Exception ',
816: SQLCODE || SQLERRM);
817: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

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

813: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,
814: GV_MODULE_PREFIX || '.' || lv_procedure_name ||
815: '.Other_Exception ',
816: SQLCODE || SQLERRM);
817: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
818: FND_FILE.put_line(FND_FILE.log, lv_procedure_name || SQLCODE || SQLERRM);
819: RAISE;
820:
821: END Add_Account_Amount_Balance;