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

Line 67: l_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

63: ,P_XML_OUTPUT_FORMAT IN VARCHAR2) AS
64:
65: --variables start here
66: l_module_name CONSTANT VARCHAR2(300) := 'JA_CN_AB_EXP_PKG.Run_Export';
67: l_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
68: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
69: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
70: l_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
71: l_message VARCHAR2(300);

Line 68: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

64:
65: --variables start here
66: l_module_name CONSTANT VARCHAR2(300) := 'JA_CN_AB_EXP_PKG.Run_Export';
67: l_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
68: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
69: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
70: l_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
71: l_message VARCHAR2(300);
72: l_flag VARCHAR2(15);

Line 69: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

65: --variables start here
66: l_module_name CONSTANT VARCHAR2(300) := 'JA_CN_AB_EXP_PKG.Run_Export';
67: l_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
68: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
69: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
70: l_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
71: l_message VARCHAR2(300);
72: l_flag VARCHAR2(15);
73: l_number_a NUMBER;

Line 70: l_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

66: l_module_name CONSTANT VARCHAR2(300) := 'JA_CN_AB_EXP_PKG.Run_Export';
67: l_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
68: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
69: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
70: l_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
71: l_message VARCHAR2(300);
72: l_flag VARCHAR2(15);
73: l_number_a NUMBER;
74: l_number_b NUMBER;

Line 268: FND_LOG.STRING(l_procedure_level,

264: l_na_curr_req_id := FND_GLOBAL.CONC_REQUEST_ID;
265: --log the parameters
266: IF (l_procedure_level >= l_runtime_level) THEN
267:
268: FND_LOG.STRING(l_procedure_level,
269: l_module_name,
270: 'Start to run ' || l_module_name ||
271: 'with parameter: p_coa_id=' ||
272: nvl(to_char(p_coa_id), 'null') || ' p_ledger_id=' ||

Line 283: FND_LOG.STRING(l_exception_level,

279:
280: --call JA_CN_UTILITY.Check_Profile, if it doesn't return true, exit
281: IF JA_CN_UTILITY.Check_Profile() <> TRUE THEN
282: IF (l_exception_level >= l_runtime_level) THEN
283: FND_LOG.STRING(l_exception_level,
284: l_module_name,
285: 'Check profile failed!');
286: END IF; --l_exception_level >= l_runtime_level
287: retcode := 1;

Line 303: FND_LOG.STRING(l_exception_level,

299: l_message := FND_MESSAGE.get();
300: FND_FILE.put_line(FND_FILE.LOG, l_message);
301:
302: IF (l_exception_level >= l_runtime_level) THEN
303: FND_LOG.STRING(l_exception_level,
304: l_module_name,
305: 'Check account period range failed!');
306: END IF;
307: retcode := 1;

Line 320: FND_LOG.STRING(l_exception_level,

316: x_flag => l_flag);
317:
318: IF l_flag = -1 THEN
319: IF (l_exception_level >= l_runtime_level) THEN
320: FND_LOG.STRING(l_exception_level,
321: l_module_name,
322: 'Get SOB or COA failed!');
323: END IF;
324: retcode := 1;

Line 330: FND_LOG.STRING(l_statement_level,

326: END IF;
327:
328: --log the SOB
329: IF (l_statement_level >= l_runtime_level) THEN
330: FND_LOG.STRING(l_statement_level,
331: l_module_name,
332: 'Fetched: l_set_of_books_id=' ||
333: nvl(to_char(l_set_of_books_id), 'null'));
334: END IF;

Line 338: FND_LOG.STRING(l_statement_level,

334: END IF;
335:
336: --log chat of account
337: IF (l_statement_level >= l_runtime_level) THEN
338: FND_LOG.STRING(l_statement_level,
339: l_module_name,
340: 'Fetched: l_chart_of_accounts_id=' ||
341: nvl(to_char(l_chart_of_accounts_id), 'null'));
342: END IF;

Line 361: FND_LOG.STRING(l_statement_level,

357: AND period_name = p_end_period;
358:
359: --log start data and end date
360: IF (l_statement_level >= l_runtime_level) THEN
361: FND_LOG.STRING(l_statement_level,
362: l_module_name,
363: 'Fetched: start date=' ||
364: nvl(to_char(l_start_date), 'null') || ' end date=' ||
365: nvl(to_char(l_end_date), 'null'));

Line 386: FND_LOG.STRING(l_statement_level,

382: AND id_flex_code = 'GL#');--l_chart_of_accounts_id);
383:
384: --log
385: IF (l_statement_level >= l_runtime_level) THEN
386: FND_LOG.STRING(l_statement_level,
387: l_module_name,
388: 'Fetched: l_flex_value_set_id=' ||
389: nvl(to_char(l_flex_value_set_id), 'null'));
390: END IF; --l_statement_level >= l_runtime_level

Line 421: FND_LOG.STRING(l_statement_level,

417: CLOSE c_in_ja_cn_dff_assignments;
418:
419: --log
420: IF (l_statement_level >= l_runtime_level) THEN
421: FND_LOG.STRING(l_statement_level,
422: l_module_name,
423: 'Fetched: l_context_code=' ||
424: nvl(to_char(l_context_code), 'null'));
425: FND_LOG.STRING(l_statement_level,

Line 425: FND_LOG.STRING(l_statement_level,

421: FND_LOG.STRING(l_statement_level,
422: l_module_name,
423: 'Fetched: l_context_code=' ||
424: nvl(to_char(l_context_code), 'null'));
425: FND_LOG.STRING(l_statement_level,
426: l_module_name,
427: 'Fetched: l_attribute_column4cost_center=' ||
428: nvl(to_char(l_attribute_column4cost_center), 'null'));
429: FND_LOG.STRING(l_statement_level,

Line 429: FND_LOG.STRING(l_statement_level,

425: FND_LOG.STRING(l_statement_level,
426: l_module_name,
427: 'Fetched: l_attribute_column4cost_center=' ||
428: nvl(to_char(l_attribute_column4cost_center), 'null'));
429: FND_LOG.STRING(l_statement_level,
430: l_module_name,
431: 'Fetched: l_attribute_column4third_party=' ||
432: nvl(to_char(l_attribute_column4third_party), 'null'));
433:

Line 434: FND_LOG.STRING(l_statement_level,

430: l_module_name,
431: 'Fetched: l_attribute_column4third_party=' ||
432: nvl(to_char(l_attribute_column4third_party), 'null'));
433:
434: FND_LOG.STRING(l_statement_level,
435: l_module_name,
436: 'Fetched: l_attribute_column4personnel=' ||
437: nvl(to_char(l_attribute_column4personnel), 'null'));
438:

Line 439: FND_LOG.STRING(l_statement_level,

435: l_module_name,
436: 'Fetched: l_attribute_column4personnel=' ||
437: nvl(to_char(l_attribute_column4personnel), 'null'));
438:
439: FND_LOG.STRING(l_statement_level,
440: l_module_name,
441: 'Fetched: l_attribute_column4project=' ||
442: nvl(to_char(l_attribute_column4project), 'null'));
443:

Line 444: FND_LOG.STRING(l_statement_level,

440: l_module_name,
441: 'Fetched: l_attribute_column4project=' ||
442: nvl(to_char(l_attribute_column4project), 'null'));
443:
444: FND_LOG.STRING(l_statement_level,
445: l_module_name,
446: 'Fetched: l_attribute_column4is_foreign=' ||
447: nvl(to_char(l_attribute_column4is_foreign), 'null'));
448:

Line 449: FND_LOG.STRING(l_statement_level,

445: l_module_name,
446: 'Fetched: l_attribute_column4is_foreign=' ||
447: nvl(to_char(l_attribute_column4is_foreign), 'null'));
448:
449: FND_LOG.STRING(l_statement_level,
450: l_module_name,
451: 'Fetched: l_attribute_column4balanceside=' ||
452: nvl(to_char(l_attribute_column4balanceside), 'null'));
453:

Line 454: FND_LOG.STRING(l_statement_level,

450: l_module_name,
451: 'Fetched: l_attribute_column4balanceside=' ||
452: nvl(to_char(l_attribute_column4balanceside), 'null'));
453:
454: FND_LOG.STRING(l_statement_level,
455: l_module_name,
456: 'Fetched: l_attribute_column4account_lev=' ||
457: nvl(to_char(l_attribute_column4account_lev), 'null'));
458:

Line 466: FND_LOG.STRING(l_statement_level,

462: OPEN c_in_ja_cn_account_balances;
463:
464: --log
465: IF (l_statement_level >= l_runtime_level) THEN
466: FND_LOG.STRING(l_statement_level,
467: l_module_name,
468: 'Fetched account segments start below:');
469:
470: END IF; --l_statement_level >= l_runtime_level

Line 495: /*IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

491: where
492: flex_value_set_id=:1 and
493: flex_value=:2';
494: --log
495: /*IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
496: fnd_log.STRING(fnd_log.level_statement, l_module_name, l_sql_stmt);
497:
498: END IF;*/
499:

Line 496: fnd_log.STRING(fnd_log.level_statement, l_module_name, l_sql_stmt);

492: flex_value_set_id=:1 and
493: flex_value=:2';
494: --log
495: /*IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
496: fnd_log.STRING(fnd_log.level_statement, l_module_name, l_sql_stmt);
497:
498: END IF;*/
499:
500: LOOP

Line 506: FND_LOG.STRING(l_statement_level, l_module_name, l_account_segment);

502: INTO l_account_segment;
503: EXIT WHEN c_in_ja_cn_account_balances%NOTFOUND;
504: --log
505: IF (l_statement_level >= l_runtime_level) THEN
506: FND_LOG.STRING(l_statement_level, l_module_name, l_account_segment);
507: END IF; --l_statement_level >= l_runtime_level
508: EXECUTE IMMEDIATE l_sql_stmt
509: USING l_flex_value_set_id, l_account_segment;
510: END LOOP;

Line 518: FND_LOG.STRING(l_exception_level, l_module_name, l_message);

514: FND_MESSAGE.set_name('JA', 'JA_CN_NO_DATA_FOUND');
515: l_message := FND_MESSAGE.get();
516: FND_FILE.put_line(FND_FILE.output, l_message);
517: IF (l_exception_level >= l_runtime_level) THEN
518: FND_LOG.STRING(l_exception_level, l_module_name, l_message);
519: END IF;
520: retcode := 1;
521: errbuf := l_message;
522: RETURN;

Line 543: FND_LOG.STRING(l_statement_level,

539: WHERE ledger_id = p_ledger_id;--set_of_books_id = l_set_of_books_id;
540:
541: --log currency name and currency code
542: IF (l_statement_level >= l_runtime_level) THEN
543: FND_LOG.STRING(l_statement_level,
544: l_module_name,
545: 'Fetched: l_functional_currency=' ||
546: nvl(to_char(l_functional_currency), 'null'));
547: END IF;

Line 567: FND_LOG.STRING(l_statement_level,

563: AND period_name = l_current_period;
564:
565: --log current period and it's start date
566: IF (l_statement_level >= l_runtime_level) THEN
567: FND_LOG.STRING(l_statement_level,
568: l_module_name,
569: 'about to generate journal lines info for period:' ||
570: l_current_period || ' start date:' ||
571: l_current_start_date);

Line 584: FND_LOG.STRING(l_statement_level,

580: INTO l_ja_cn_subsidiary_gbl_tmp_row;
581: EXIT WHEN c_in_ja_cn_subsidiary_gbl_tmp%NOTFOUND;
582: --log
583: IF (l_statement_level >= l_runtime_level) THEN
584: FND_LOG.STRING(l_statement_level,
585: l_module_name,
586: 'about to generate group clause for account:' ||
587: l_ja_cn_subsidiary_gbl_tmp_row.account_segment_value);
588:

Line 980: FND_LOG.STRING(l_procedure_level,

976:
977: --log
978: IF (l_procedure_level >= l_runtime_level) THEN
979:
980: FND_LOG.STRING(l_procedure_level,
981: l_module_name,
982: 'Stop running ' || l_module_name);
983:
984: END IF;