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.JE_IT_LISTING_PKG dependencies on FND_FILE

Line 472: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

468: FND_MESSAGE.SET_TOKEN('VAT_YEAR',P_YEAR_OF_DECLARATION);
469: errbuf :=FND_MESSAGE.get;
470: retcode := 2; -- Error
471: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
472: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
473: WHEN l_setup_not_available THEN
474: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
475: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Exception in PROCEDURE Extract_Data - Not setup_available');
476: END IF;

Line 482: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

478: FND_MESSAGE.SET_TOKEN('VAT_REP',l_entity_identifier);
479: FND_MESSAGE.SET_TOKEN('VAT_YEAR',P_YEAR_OF_DECLARATION);
480: errbuf :=FND_MESSAGE.get;
481: retcode := 2; -- Error
482: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
483: WHEN l_final_already_run THEN
484: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
485: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Exception in PROCEDURE Extract_Data - l_final_already_run');
486: END IF;

Line 493: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

489: FND_MESSAGE.SET_TOKEN('VAT_YEAR',P_YEAR_OF_DECLARATION);
490: errbuf :=FND_MESSAGE.get;
491: retcode := 2; -- Error
492: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
493: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
494: WHEN l_prelim_not_run THEN
495: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
496: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Exception in PROCEDURE Extract_Data - l_prelim_not_run ');
497: END IF;

Line 504: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

500: FND_MESSAGE.SET_TOKEN('VAT_YEAR',P_YEAR_OF_DECLARATION);
501: errbuf :=FND_MESSAGE.get;
502: retcode := 2; --Error
503: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
504: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
505: WHEN l_final_not_run THEN
506: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
507: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Exception in PROCEDURE Extract_Data - l_final_not_run ');
508: END IF;

Line 515: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

511: FND_MESSAGE.SET_TOKEN('VAT_YEAR',P_YEAR_OF_DECLARATION);
512: errbuf :=FND_MESSAGE.get;
513: retcode := 2; --Error
514: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
515: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
516: WHEN e_request_submit_error THEN
517: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
518: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Exception in PROCEDURE Extract_Data - e_request_submit_error');
519: END IF;

Line 524: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

520: errbuf := g_errbuf;
521: retcode := 1; -- Warning
522: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
523: IF g_debug_flag = 'Y' THEN
524: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
525: END IF;
526: WHEN OTHERS THEN
527: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
528: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Extract_Data','Exception in PROCEDURE Extract_Data ');

Line 534: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

530: errbuf :='Unknown exception occured in JE_IT_LISTING_PKG.Extract_Data';
531: retcode := 2; -- Error
532: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
533: IF g_debug_flag = 'Y' THEN
534: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
535: END IF;
536: END Extract_Data;
537: --------------------------------------------------------------------------------
538: /*===========================================================================+

Line 611: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

607: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Exception in fetching p_status_code for cur_status');
608: END IF;
609: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
610: IF g_debug_flag = 'Y' THEN
611: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
612: END IF;
613: END;
614:
615: IF g_retcode = 2 THEN

Line 651: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

647: errbuf :=FND_MESSAGE.get;
648: retcode := 2; --Error
649: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
650: IF g_debug_flag = 'Y' THEN
651: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
652: END IF;
653: WHEN l_prelim_not_run THEN
654: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
655: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Exception in PROCEDURE Final_data - l_prelim_not_run ');

Line 659: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);

655: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Exception in PROCEDURE Final_data - l_prelim_not_run ');
656: END IF;
657: FND_MESSAGE.SET_NAME('JE','JE_IT_PRELIMINARY_LISTING');
658: errbuf :=FND_MESSAGE.get;
659: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
660: retcode := 2; --Error
661: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
662: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
663: WHEN l_final_already_run THEN

Line 662: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

658: errbuf :=FND_MESSAGE.get;
659: FND_FILE.PUT_LINE(FND_FILE.LOG, errbuf);
660: retcode := 2; --Error
661: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
662: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
663: WHEN l_final_already_run THEN
664: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
665: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Exception in PROCEDURE Final_data - l_final_already_run ');
666: END IF;

Line 670: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

666: END IF;
667: errbuf :='Final mode is already run for this Fiscal Period.';
668: retcode := 2; --Error
669: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
670: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
671: WHEN OTHERS THEN
672: IF (G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL ) THEN
673: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Final_data','Exception in PROCEDURE Final_data');
674: END IF;

Line 679: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

675: errbuf :='Unknown Exception Occured in the package JE_IT_LISTING_PKG in PROCEDURE Final_data';
676: retcode := 2; --Error
677: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
678: IF g_debug_flag = 'Y' THEN
679: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
680: END IF;
681: END Final_data;
682:
683: --------------------------------------------------------------------------------

Line 734: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

730: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Insert_tax_data','Exception in PROCEDURE Purge_trx_data');
731: END IF;
732: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
733: IF g_debug_flag = 'Y' THEN
734: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
735: END IF;
736: END Purge_trx_data;
737: --------------------------------------------------------------------------------
738: --------------------------------------------------------------------------------

Line 938: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

934: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ap','Exception in PROCEDURE Fetch_trx_data_ap');
935: END IF;
936: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
937: IF g_debug_flag = 'Y' THEN
938: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
939: END IF;
940: ROLLBACK TO before_insert_lines;
941: END Fetch_trx_data_ap;
942:

Line 1129: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

1125: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Fetch_trx_data_ar','Exception in PROCEDURE Fetch_trx_data_ar');
1126: END IF;
1127: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
1128: IF g_debug_flag = 'Y' THEN
1129: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
1130: END IF;
1131: ROLLBACK TO before_insert_lines;
1132: END Fetch_trx_data_ar;
1133:

Line 1521: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

1517: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Insert_tax_data','Exception in PROCEDURE Insert_tax_data');
1518: END IF;
1519: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
1520: IF g_debug_flag = 'Y' THEN
1521: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
1522: END IF;
1523: END Insert_tax_data;
1524:
1525: --------------------------------------------------------------------------------

Line 1581: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

1577: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Init_gt_variables','Exception in PROCEDURE Insert_tax_data');
1578: END IF;
1579: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
1580: IF g_debug_flag = 'Y' THEN
1581: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
1582: END IF;
1583: END;
1584: -----------------------------------------------------------------------------
1585: /*===========================================================================+

Line 2008: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

2004: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Generate_trx_headers','Exception in PROCEDURE Generate_trx_headers');
2005: END IF;
2006: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
2007: IF g_debug_flag = 'Y' THEN
2008: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
2009: END IF;
2010: ROLLBACK TO before_insert_parties;
2011: END Generate_trx_headers;
2012: --------------------------------------------------------------------------------

Line 2127: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

2123: g_retcode :=2;
2124: g_errbuf :='Exception in Fetching ledger id,balancing segment value and chart of account id';
2125: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
2126: IF g_debug_flag = 'Y' THEN
2127: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
2128: END IF;
2129: END;
2130:
2131: BEGIN

Line 2156: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

2152: g_retcode :=2;
2153: g_errbuf :='Exception in Fetching start and end date of the declaration year';
2154: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
2155: IF g_debug_flag = 'Y' THEN
2156: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
2157: END IF;
2158: END;
2159:
2160:

Line 2184: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

2180: g_retcode :=2;
2181: g_errbuf :='Exception in Fetching start and end date of the declaration year';
2182: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
2183: IF g_debug_flag = 'Y' THEN
2184: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
2185: END IF;
2186: END;
2187:
2188:

Line 2207: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

2203: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.Initialize_proc_var','Exception in PROCEDURE Initialize_proc_var');
2204: END IF;
2205: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
2206: IF g_debug_flag = 'Y' THEN
2207: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
2208: END IF;
2209: END Initialize_proc_var;
2210: -----------------------------------------------------------------------------------
2211:

Line 2259: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

2255: FND_LOG.STRING(G_LEVEL_EXCEPTION, 'JE.plsql.JE_IT_LISTING_PKG.get_bsv','Exception in FUNCTIONI get_bsv');
2256: END IF;
2257: g_error_buffer := SQLCODE || ': ' || SUBSTR(SQLERRM, 1, 80);
2258: IF g_debug_flag = 'Y' THEN
2259: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);
2260: END IF;
2261: RETURN NULL;
2262: END get_bsv;
2263: