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

Line 64: l_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

60: ,p_start_period IN VARCHAR2
61: ,p_end_period IN VARCHAR2) IS
62:
63: --variables start here
64: l_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
65: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
66: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
67: l_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
68: l_flag VARCHAR2(15);

Line 65: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

61: ,p_end_period IN VARCHAR2) IS
62:
63: --variables start here
64: l_runtime_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
65: l_procedure_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
66: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
67: l_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
68: l_flag VARCHAR2(15);
69:

Line 66: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

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

Line 67: l_exception_level NUMBER := FND_LOG.LEVEL_EXCEPTION;

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

Line 269: FND_LOG.STRING(l_procedure_level,

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

Line 284: FND_LOG.STRING(l_exception_level,

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

Line 306: FND_LOG.STRING(l_exception_level,

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

Line 323: FND_LOG.STRING(l_exception_level,

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

Line 334: FND_LOG.STRING(l_statement_level,

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

Line 341: FND_LOG.STRING(l_statement_level,

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

Line 365: FND_LOG.STRING(l_statement_level,

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

Line 389: FND_LOG.STRING(l_statement_level,

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

Line 417: FND_LOG.STRING(l_statement_level,

413: END CASE; END LOOP;
414: CLOSE c_in_ja_cn_dff_assignments;
415: --log
416: IF (l_statement_level >= l_runtime_level) THEN
417: FND_LOG.STRING(l_statement_level,
418: l_module_name,
419: 'Fetched: l_context_code=' ||
420: nvl(to_char(l_context_code), 'null'));
421: FND_LOG.STRING(l_statement_level,

Line 421: FND_LOG.STRING(l_statement_level,

417: FND_LOG.STRING(l_statement_level,
418: l_module_name,
419: 'Fetched: l_context_code=' ||
420: nvl(to_char(l_context_code), 'null'));
421: FND_LOG.STRING(l_statement_level,
422: l_module_name,
423: 'Fetched: l_attribute_column4cost_center=' ||
424: nvl(to_char(l_attribute_column4cost_center), '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_attribute_column4cost_center=' ||
424: nvl(to_char(l_attribute_column4cost_center), 'null'));
425: FND_LOG.STRING(l_statement_level,
426: l_module_name,
427: 'Fetched: l_attribute_column4third_party=' ||
428: nvl(to_char(l_attribute_column4third_party), 'null'));
429:

Line 430: FND_LOG.STRING(l_statement_level,

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

Line 435: FND_LOG.STRING(l_statement_level,

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

Line 446: FND_LOG.STRING(l_statement_level,

442: --fetch the account subsidiary info and save to temp table
443: OPEN c_in_ja_cn_journal_lines;
444: --log
445: IF (l_statement_level >= l_runtime_level) THEN
446: FND_LOG.STRING(l_statement_level,
447: l_module_name,
448: 'Fetched account segments start below:');
449:
450: END IF;

Line 465: FND_LOG.STRING(l_statement_level,

461: INTO l_account_segment;
462: EXIT WHEN c_in_ja_cn_journal_lines%NOTFOUND;
463: --log
464: IF (l_statement_level >= l_runtime_level) THEN
465: FND_LOG.STRING(l_statement_level,
466: l_module_name,
467: 'about to insert subsidiary info of account: ' ||
468: l_account_segment || ' to temp table');
469:

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

479: FND_MESSAGE.set_name('JA', 'JA_CN_NO_DATA_FOUND');
480: l_message := FND_MESSAGE.get();
481: FND_FILE.put_line(FND_FILE.LOG, l_message);
482: IF (l_exception_level >= l_runtime_level) THEN
483: FND_LOG.STRING(l_exception_level, l_module_name, l_message);
484: END IF;
485: retcode := 1;
486: errbuf := l_message;
487: RETURN;

Line 509: FND_LOG.STRING(l_statement_level,

505: AND period_name = l_current_period;
506:
507: --log current period and it's start date
508: IF (l_statement_level >= l_runtime_level) THEN
509: FND_LOG.STRING(l_statement_level,
510: l_module_name,
511: 'about to generate journal lines info for period:' ||
512: l_current_period || ' start date:' ||
513: l_current_start_date);

Line 526: FND_LOG.STRING(l_statement_level,

522: INTO l_ja_cn_subsidiary_gbl_tmp_row;
523: EXIT WHEN c_in_ja_cn_subsidiary_gbl_tmp%NOTFOUND;
524: --log
525: IF (l_statement_level >= l_runtime_level) THEN
526: FND_LOG.STRING(l_statement_level,
527: l_module_name,
528: 'about to generate group clause for account:' ||
529: l_ja_cn_subsidiary_gbl_tmp_row.account_segment_value);
530:

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

549: '@PREFIX_COLUMN_CLAUSE',
550: l_prefix_column_clause);
551: /*IF (l_exception_level >= l_runtime_level)
552: THEN
553: fnd_log.STRING(fnd_log.level_statement, l_module_name, l_sql_stmt);
554: END IF;*/
555: FND_FILE.PUT_LINE(FND_FILE.LOG, l_sql_stmt);
556: EXECUTE IMMEDIATE REPLACE(l_sql_stmt,
557: '@AND_CONDITION',

Line 583: FND_LOG.STRING(l_statement_level,

579: FROM gl_ledgers--gl_sets_of_books
580: WHERE ledger_id = p_ledger_id );--set_of_books_id = l_set_of_books_id);
581: --log
582: IF (l_statement_level >= l_runtime_level) THEN
583: FND_LOG.STRING(l_statement_level,
584: l_module_name,
585: 'Fetched: l_functional_currency=' ||
586: nvl(to_char(l_functional_currency), 'null'));
587: END IF;

Line 673: FND_LOG.STRING(l_procedure_level,

669: END LOOP;
670: CLOSE c_in_journal_lines_gbl_tmp;
671: IF (l_procedure_level >= l_runtime_level) THEN
672:
673: FND_LOG.STRING(l_procedure_level,
674: l_module_name,
675: 'Stop running ' || l_module_name);
676:
677: END IF;

Line 720: l_runtime_level NUMBER := FND_LOG.G_Current_Runtime_Level;

716: ,p_has_project VARCHAR2
717: ,p_return_column_clause OUT NOCOPY VARCHAR2
718: ,p_return_prefix_column_clause OUT NOCOPY VARCHAR2) IS
719:
720: l_runtime_level NUMBER := FND_LOG.G_Current_Runtime_Level;
721: l_procedure_level NUMBER := FND_LOG.Level_Procedure;
722: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
723: l_module_name CONSTANT VARCHAR2(300) := 'JA_CN_JE_EXP_PKG.Gen_Clauses';
724:

Line 721: l_procedure_level NUMBER := FND_LOG.Level_Procedure;

717: ,p_return_column_clause OUT NOCOPY VARCHAR2
718: ,p_return_prefix_column_clause OUT NOCOPY VARCHAR2) IS
719:
720: l_runtime_level NUMBER := FND_LOG.G_Current_Runtime_Level;
721: l_procedure_level NUMBER := FND_LOG.Level_Procedure;
722: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
723: l_module_name CONSTANT VARCHAR2(300) := 'JA_CN_JE_EXP_PKG.Gen_Clauses';
724:
725: key PLS_INTEGER := 0;

Line 722: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

718: ,p_return_prefix_column_clause OUT NOCOPY VARCHAR2) IS
719:
720: l_runtime_level NUMBER := FND_LOG.G_Current_Runtime_Level;
721: l_procedure_level NUMBER := FND_LOG.Level_Procedure;
722: l_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
723: l_module_name CONSTANT VARCHAR2(300) := 'JA_CN_JE_EXP_PKG.Gen_Clauses';
724:
725: key PLS_INTEGER := 0;
726: column_clause VARCHAR2(500) := '';

Line 730: FND_LOG.STRING(l_procedure_level,

726: column_clause VARCHAR2(500) := '';
727: prefix_column_clause VARCHAR2(500) := '';
728: BEGIN
729: IF (l_procedure_level >= l_runtime_level) THEN
730: FND_LOG.STRING(l_procedure_level,
731: l_module_name,
732: 'Start to generate clauses by ' || l_module_name ||
733: ' in sequence of [CC][TP][PL][PT] with: ' ||
734: nvl(p_has_cost_center, 'null') ||

Line 753: FND_LOG.STRING(l_statement_level,

749: IF (p_has_project = 'Y') THEN
750: key := key + 1;
751: END IF;
752: IF (l_statement_level >= l_runtime_level) THEN
753: FND_LOG.STRING(l_statement_level,
754: l_module_name,
755: 'Generated key is: ' || key);
756: END IF;
757:

Line 760: FND_LOG.STRING(l_statement_level,

756: END IF;
757:
758: IF p_column_clauses.EXISTS(key) = FALSE THEN
759: IF (l_statement_level >= l_runtime_level) THEN
760: FND_LOG.STRING(l_statement_level,
761: l_module_name,
762: 'There is no clauses pre-generated with key: ' || key ||
763: ' so, generate it right now!');
764: END IF;

Line 799: FND_LOG.STRING(l_procedure_level,

795: p_return_prefix_column_clause := p_prefix_column_clauses(key);
796: p_return_column_clause := p_column_clauses(key);
797: IF (l_procedure_level >= l_runtime_level) THEN
798:
799: FND_LOG.STRING(l_procedure_level,
800: l_module_name,
801: 'Stop running ' || l_module_name);
802:
803: END IF;