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

Line 94: fnd_file.put_line(which, buffer);

90: buffer IN VARCHAR2) IS
91:
92: BEGIN
93:
94: fnd_file.put_line(which, buffer);
95:
96: EXCEPTION
97:
98: WHEN UTL_FILE.INVALID_PATH THEN

Line 610: fnd_file.put_line( fnd_file.log, fnd_message.get);

606: x_trx_count := 0;
607: x_bal_count := 0;
608:
609: fnd_message.set_name('FND', 'CONC-ARGUMENTS');
610: fnd_file.put_line( fnd_file.log, fnd_message.get);
611: fnd_file.put_line(fnd_file.log, '----------------------------------------');
612: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
613: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
614: put_line( fnd_file.log, fnd_message.get);

Line 611: fnd_file.put_line(fnd_file.log, '----------------------------------------');

607: x_bal_count := 0;
608:
609: fnd_message.set_name('FND', 'CONC-ARGUMENTS');
610: fnd_file.put_line( fnd_file.log, fnd_message.get);
611: fnd_file.put_line(fnd_file.log, '----------------------------------------');
612: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
613: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
614: put_line( fnd_file.log, fnd_message.get);
615: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');

Line 614: put_line( fnd_file.log, fnd_message.get);

610: fnd_file.put_line( fnd_file.log, fnd_message.get);
611: fnd_file.put_line(fnd_file.log, '----------------------------------------');
612: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
613: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
614: put_line( fnd_file.log, fnd_message.get);
615: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
616: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
617: put_line( fnd_file.log, fnd_message.get);
618: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_START');

Line 617: put_line( fnd_file.log, fnd_message.get);

613: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
614: put_line( fnd_file.log, fnd_message.get);
615: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
616: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
617: put_line( fnd_file.log, fnd_message.get);
618: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_START');
619: fnd_message.set_token('PERIOD_START', p_period_start);
620: put_line( fnd_file.log, fnd_message.get);
621: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_END');

Line 620: put_line( fnd_file.log, fnd_message.get);

616: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
617: put_line( fnd_file.log, fnd_message.get);
618: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_START');
619: fnd_message.set_token('PERIOD_START', p_period_start);
620: put_line( fnd_file.log, fnd_message.get);
621: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_END');
622: fnd_message.set_token('PERIOD_END', p_period_end);
623: put_line( fnd_file.log, fnd_message.get);
624: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');

Line 623: put_line( fnd_file.log, fnd_message.get);

619: fnd_message.set_token('PERIOD_START', p_period_start);
620: put_line( fnd_file.log, fnd_message.get);
621: fnd_message.set_name('JL', 'JL_CO_GL_MG_PERIOD_END');
622: fnd_message.set_token('PERIOD_END', p_period_end);
623: put_line( fnd_file.log, fnd_message.get);
624: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');
625: fnd_message.set_token('LITERAL_START', p_literal_start);
626: put_line( fnd_file.log, fnd_message.get);
627: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_END');

Line 626: put_line( fnd_file.log, fnd_message.get);

622: fnd_message.set_token('PERIOD_END', p_period_end);
623: put_line( fnd_file.log, fnd_message.get);
624: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');
625: fnd_message.set_token('LITERAL_START', p_literal_start);
626: put_line( fnd_file.log, fnd_message.get);
627: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_END');
628: fnd_message.set_token('LITERAL_END', p_literal_end);
629: put_line( fnd_file.log, fnd_message.get);
630: fnd_file.put_line(fnd_file.log, '----------------------------------------');

Line 629: put_line( fnd_file.log, fnd_message.get);

625: fnd_message.set_token('LITERAL_START', p_literal_start);
626: put_line( fnd_file.log, fnd_message.get);
627: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_END');
628: fnd_message.set_token('LITERAL_END', p_literal_end);
629: put_line( fnd_file.log, fnd_message.get);
630: fnd_file.put_line(fnd_file.log, '----------------------------------------');
631:
632:
633: /******************************************************

Line 630: fnd_file.put_line(fnd_file.log, '----------------------------------------');

626: put_line( fnd_file.log, fnd_message.get);
627: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_END');
628: fnd_message.set_token('LITERAL_END', p_literal_end);
629: put_line( fnd_file.log, fnd_message.get);
630: fnd_file.put_line(fnd_file.log, '----------------------------------------');
631:
632:
633: /******************************************************
634: Check for JL_CO_GL_MG_HEADERS.STATUS = 'Y'. If any row

Line 689: put_line( fnd_file.log, fnd_message.get);

685: COMMIT;
686: fnd_message.set_name('JL', 'JL_CO_GL_MG_DELETE');
687: fnd_message.set_token('NUMBER', TO_CHAR(SQL%ROWCOUNT));
688: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
689: put_line( fnd_file.log, fnd_message.get);
690: ELSE
691: NULL;
692: fnd_message.set_name('JL', 'JL_CO_GL_MG_NOT_DELETE');
693: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');

Line 694: put_line( fnd_file.log, fnd_message.get);

690: ELSE
691: NULL;
692: fnd_message.set_name('JL', 'JL_CO_GL_MG_NOT_DELETE');
693: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
694: put_line( fnd_file.log, fnd_message.get);
695: END IF;
696:
697: EXCEPTION
698:

Line 721: put_line( fnd_file.log, fnd_message.get);

717: COMMIT;
718: fnd_message.set_name('JL', 'JL_CO_GL_MG_DELETE');
719: fnd_message.set_token('NUMBER', TO_CHAR(SQL%ROWCOUNT));
720: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');
721: put_line( fnd_file.log, fnd_message.get);
722: ELSE
723: NULL;
724: fnd_message.set_name('JL', 'JL_CO_GL_MG_NOT_DELETE');
725: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');

Line 726: put_line( fnd_file.log, fnd_message.get);

722: ELSE
723: NULL;
724: fnd_message.set_name('JL', 'JL_CO_GL_MG_NOT_DELETE');
725: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');
726: put_line( fnd_file.log, fnd_message.get);
727: END IF;
728:
729: EXCEPTION
730:

Line 788: put_line( fnd_file.log, fnd_message.get);

784: fnd_message.set_name('JL', 'JL_CO_GL_MG_INSERT');
785: fnd_message.set_token('NUMBER', '1');
786: fnd_message.set_token('TYPE', ' ');
787: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_HEADERS');
788: put_line( fnd_file.log, fnd_message.get);
789:
790: EXCEPTION
791:
792: WHEN OTHERS THEN

Line 883: put_line( fnd_file.log, fnd_message.get);

879: fnd_message.set_name('JL', 'JL_CO_GL_MG_INSERT');
880: fnd_message.set_token('NUMBER', TO_CHAR(x_trx_count));
881: fnd_message.set_token('TYPE', 'NIT_TRANSACTIONS');
882: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
883: put_line( fnd_file.log, fnd_message.get);
884:
885: END IF;
886:
887: IF x_bal_count > 0 THEN

Line 893: put_line( fnd_file.log, fnd_message.get);

889: fnd_message.set_name('JL', 'JL_CO_GL_MG_INSERT');
890: fnd_message.set_token('NUMBER', TO_CHAR(x_bal_count));
891: fnd_message.set_token('TYPE', 'NIT_BALANCES');
892: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LINES');
893: put_line( fnd_file.log, fnd_message.get);
894:
895: END IF;
896:
897: IF x_trx_count = 0 AND x_bal_count = 0 THEN

Line 927: put_line( fnd_file.log, x_message);

923:
924: WHEN HEADERS_STATUS_Y THEN
925:
926: x_message := '----***************** W A R N I N G **********************----';
927: put_line( fnd_file.log, x_message);
928: fnd_message.set_name('JL', 'JL_CO_GL_MG_FILE_SENT');
929: fnd_message.set_token('YEAR', p_reported_year);
930: x_error_text := fnd_message.get;
931: put_line( fnd_file.log, x_error_text);

Line 931: put_line( fnd_file.log, x_error_text);

927: put_line( fnd_file.log, x_message);
928: fnd_message.set_name('JL', 'JL_CO_GL_MG_FILE_SENT');
929: fnd_message.set_token('YEAR', p_reported_year);
930: x_error_text := fnd_message.get;
931: put_line( fnd_file.log, x_error_text);
932: x_error_text := SUBSTR(x_error_text, 1, 100);
933: x_message := '----******************************************************----';
934: put_line( fnd_file.log, x_message);
935: app_exception.raise_exception (exception_type => 'APP',

Line 934: put_line( fnd_file.log, x_message);

930: x_error_text := fnd_message.get;
931: put_line( fnd_file.log, x_error_text);
932: x_error_text := SUBSTR(x_error_text, 1, 100);
933: x_message := '----******************************************************----';
934: put_line( fnd_file.log, x_message);
935: app_exception.raise_exception (exception_type => 'APP',
936: exception_code =>
937: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_CO_GL_MG_FILE_SENT'),
938: exception_text => x_error_text);

Line 943: fnd_file.put_line( fnd_file.log, fnd_message.get);

939:
940: WHEN OTHERS THEN
941:
942: fnd_message.set_name('JL', 'JL_CO_FA_GENERAL_ERROR');
943: fnd_file.put_line( fnd_file.log, fnd_message.get);
944: x_error_code := SQLCODE;
945: x_error_text := SUBSTR(SQLERRM,1,200);
946: ROLLBACK;
947: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);

Line 1105: fnd_file.put_line( fnd_file.log, fnd_message.get);

1101:
1102: BEGIN <>
1103:
1104: fnd_message.set_name('FND', 'CONC-ARGUMENTS');
1105: fnd_file.put_line( fnd_file.log, fnd_message.get);
1106: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1107: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
1108: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
1109: put_line( fnd_file.log, fnd_message.get);

Line 1106: fnd_file.put_line(fnd_file.log, '----------------------------------------');

1102: BEGIN <>
1103:
1104: fnd_message.set_name('FND', 'CONC-ARGUMENTS');
1105: fnd_file.put_line( fnd_file.log, fnd_message.get);
1106: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1107: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
1108: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
1109: put_line( fnd_file.log, fnd_message.get);
1110: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');

Line 1109: put_line( fnd_file.log, fnd_message.get);

1105: fnd_file.put_line( fnd_file.log, fnd_message.get);
1106: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1107: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
1108: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
1109: put_line( fnd_file.log, fnd_message.get);
1110: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
1111: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
1112: put_line( fnd_file.log, fnd_message.get);
1113: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');

Line 1112: put_line( fnd_file.log, fnd_message.get);

1108: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
1109: put_line( fnd_file.log, fnd_message.get);
1110: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
1111: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
1112: put_line( fnd_file.log, fnd_message.get);
1113: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');
1114: fnd_message.set_token('LITERAL_START', p_literal_start);
1115: put_line( fnd_file.log, fnd_message.get);
1116: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_END');

Line 1115: put_line( fnd_file.log, fnd_message.get);

1111: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
1112: put_line( fnd_file.log, fnd_message.get);
1113: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_START');
1114: fnd_message.set_token('LITERAL_START', p_literal_start);
1115: put_line( fnd_file.log, fnd_message.get);
1116: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_END');
1117: fnd_message.set_token('LITERAL_END', p_literal_end);
1118: put_line( fnd_file.log, fnd_message.get);
1119: fnd_file.put_line(fnd_file.log, '----------------------------------------');

Line 1118: put_line( fnd_file.log, fnd_message.get);

1114: fnd_message.set_token('LITERAL_START', p_literal_start);
1115: put_line( fnd_file.log, fnd_message.get);
1116: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_END');
1117: fnd_message.set_token('LITERAL_END', p_literal_end);
1118: put_line( fnd_file.log, fnd_message.get);
1119: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1120:
1121: /******************************************************
1122: Check for JL_CO_GL_MG_HEADERS.STATUS = 'Y'. If any row

Line 1119: fnd_file.put_line(fnd_file.log, '----------------------------------------');

1115: put_line( fnd_file.log, fnd_message.get);
1116: fnd_message.set_name('JL', 'JL_CO_GL_MG_LITERAL_END');
1117: fnd_message.set_token('LITERAL_END', p_literal_end);
1118: put_line( fnd_file.log, fnd_message.get);
1119: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1120:
1121: /******************************************************
1122: Check for JL_CO_GL_MG_HEADERS.STATUS = 'Y'. If any row
1123: exists with status of 'Y' then give a message to USER

Line 1183: put_line(fnd_file.log, fnd_message.get);

1179:
1180: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1181: fnd_message.set_token('GENERIC_TEXT',
1182: 'Exception "NO_DATA_FOUND" for selection of flags from JL_CO_GL_MG_LITERALS table');
1183: put_line(fnd_file.log, fnd_message.get);
1184: x_error_code := SQLCODE;
1185: x_error_text := SUBSTR(SQLERRM,1,200);
1186: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);
1187:

Line 1193: put_line(fnd_file.log, fnd_message.get);

1189:
1190: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1191: fnd_message.set_token('GENERIC_TEXT',
1192: 'Exception "TOO_MANY_ROWS" for selection of flags from JL_CO_GL_MG_LITERALS table');
1193: put_line(fnd_file.log, fnd_message.get);
1194: x_error_code := SQLCODE;
1195: x_error_text := SUBSTR(SQLERRM,1,200);
1196: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);
1197:

Line 1203: put_line(fnd_file.log, fnd_message.get);

1199:
1200: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1201: fnd_message.set_token('GENERIC_TEXT',
1202: 'Exception "OTHERS" for selection of flags from JL_CO_GL_MG_LITERALS table');
1203: put_line(fnd_file.log, fnd_message.get);
1204: x_error_code := SQLCODE;
1205: x_error_text := SUBSTR(SQLERRM,1,200);
1206: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);
1207:

Line 1355: put_line( fnd_file.log, x_message);

1351:
1352: IF count_process_flag > 0 THEN
1353:
1354: x_message := '----***************** W A R N I N G **********************----';
1355: put_line( fnd_file.log, x_message);
1356: fnd_message.set_name('JL', 'JL_CO_GL_MG_TH_ALERT');
1357: fnd_message.set_token('NUMBER', TO_CHAR(count_process_flag));
1358: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LITERALS');
1359: x_error_text := fnd_message.get;

Line 1360: put_line( fnd_file.log, x_error_text);

1356: fnd_message.set_name('JL', 'JL_CO_GL_MG_TH_ALERT');
1357: fnd_message.set_token('NUMBER', TO_CHAR(count_process_flag));
1358: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LITERALS');
1359: x_error_text := fnd_message.get;
1360: put_line( fnd_file.log, x_error_text);
1361: x_error_text := SUBSTR(x_error_text, 1, 100);
1362: x_message := '----******************************************************----';
1363: put_line( fnd_file.log, x_message);
1364: app_exception.raise_exception (exception_type => 'APP',

Line 1363: put_line( fnd_file.log, x_message);

1359: x_error_text := fnd_message.get;
1360: put_line( fnd_file.log, x_error_text);
1361: x_error_text := SUBSTR(x_error_text, 1, 100);
1362: x_message := '----******************************************************----';
1363: put_line( fnd_file.log, x_message);
1364: app_exception.raise_exception (exception_type => 'APP',
1365: exception_code =>
1366: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_CO_GL_MG_TH_ALERT'),
1367: exception_text => x_error_text);

Line 1376: put_line( fnd_file.log, x_message);

1372:
1373: WHEN HEADERS_STATUS_Y THEN
1374:
1375: x_message := '----***************** W A R N I N G **********************----';
1376: put_line( fnd_file.log, x_message);
1377: fnd_message.set_name('JL', 'JL_CO_GL_MG_FILE_SENT');
1378: fnd_message.set_token('YEAR', p_reported_year);
1379: x_error_text := fnd_message.get;
1380: put_line( fnd_file.log, x_error_text);

Line 1380: put_line( fnd_file.log, x_error_text);

1376: put_line( fnd_file.log, x_message);
1377: fnd_message.set_name('JL', 'JL_CO_GL_MG_FILE_SENT');
1378: fnd_message.set_token('YEAR', p_reported_year);
1379: x_error_text := fnd_message.get;
1380: put_line( fnd_file.log, x_error_text);
1381: x_error_text := SUBSTR(x_error_text, 1, 100);
1382: x_message := '----******************************************************----';
1383: put_line( fnd_file.log, x_message);
1384: app_exception.raise_exception (exception_type => 'APP',

Line 1383: put_line( fnd_file.log, x_message);

1379: x_error_text := fnd_message.get;
1380: put_line( fnd_file.log, x_error_text);
1381: x_error_text := SUBSTR(x_error_text, 1, 100);
1382: x_message := '----******************************************************----';
1383: put_line( fnd_file.log, x_message);
1384: app_exception.raise_exception (exception_type => 'APP',
1385: exception_code =>
1386: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_CO_GL_MG_FILE_SENT'),
1387: exception_text => x_error_text);

Line 1392: fnd_file.put_line( fnd_file.log, fnd_message.get);

1388:
1389: WHEN OTHERS THEN
1390:
1391: fnd_message.set_name('JL', 'JL_CO_FA_GENERAL_ERROR');
1392: fnd_file.put_line( fnd_file.log, fnd_message.get);
1393: x_error_code := SQLCODE;
1394: x_error_text := SUBSTR(SQLERRM,1,200);
1395: ROLLBACK;
1396: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);

Line 1483: fnd_file.put_line( fnd_file.log, fnd_message.get);

1479:
1480: BEGIN <>
1481:
1482: fnd_message.set_name('FND', 'CONC-ARGUMENTS');
1483: fnd_file.put_line( fnd_file.log, fnd_message.get);
1484: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1485: fnd_message.set_name('JL', 'JL_CO_GL_MG_LEGAL_ENTITY_ID');
1486: fnd_message.set_token('LEGAL_ENTITY_ID', p_legal_entity_id);
1487: put_line( fnd_file.log, fnd_message.get);

Line 1484: fnd_file.put_line(fnd_file.log, '----------------------------------------');

1480: BEGIN <>
1481:
1482: fnd_message.set_name('FND', 'CONC-ARGUMENTS');
1483: fnd_file.put_line( fnd_file.log, fnd_message.get);
1484: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1485: fnd_message.set_name('JL', 'JL_CO_GL_MG_LEGAL_ENTITY_ID');
1486: fnd_message.set_token('LEGAL_ENTITY_ID', p_legal_entity_id);
1487: put_line( fnd_file.log, fnd_message.get);
1488: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');

Line 1487: put_line( fnd_file.log, fnd_message.get);

1483: fnd_file.put_line( fnd_file.log, fnd_message.get);
1484: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1485: fnd_message.set_name('JL', 'JL_CO_GL_MG_LEGAL_ENTITY_ID');
1486: fnd_message.set_token('LEGAL_ENTITY_ID', p_legal_entity_id);
1487: put_line( fnd_file.log, fnd_message.get);
1488: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
1489: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
1490: put_line( fnd_file.log, fnd_message.get);
1491: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');

Line 1490: put_line( fnd_file.log, fnd_message.get);

1486: fnd_message.set_token('LEGAL_ENTITY_ID', p_legal_entity_id);
1487: put_line( fnd_file.log, fnd_message.get);
1488: fnd_message.set_name('JL', 'JL_CO_GL_MG_SET_OF_BOOKS_ID');
1489: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
1490: put_line( fnd_file.log, fnd_message.get);
1491: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
1492: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
1493: put_line( fnd_file.log, fnd_message.get);
1494: fnd_message.set_name('JL', 'JL_CO_GL_MG_LABEL');

Line 1493: put_line( fnd_file.log, fnd_message.get);

1489: fnd_message.set_token('SET_OF_BOOKS_ID', p_set_of_books_id);
1490: put_line( fnd_file.log, fnd_message.get);
1491: fnd_message.set_name('JL', 'JL_CO_GL_MG_REPORTED_YEAR');
1492: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
1493: put_line( fnd_file.log, fnd_message.get);
1494: fnd_message.set_name('JL', 'JL_CO_GL_MG_LABEL');
1495: fnd_message.set_token('LABEL', p_label);
1496: put_line( fnd_file.log, fnd_message.get);
1497: fnd_file.put_line(fnd_file.log, '----------------------------------------');

Line 1496: put_line( fnd_file.log, fnd_message.get);

1492: fnd_message.set_token('REPORTED_YEAR', p_reported_year);
1493: put_line( fnd_file.log, fnd_message.get);
1494: fnd_message.set_name('JL', 'JL_CO_GL_MG_LABEL');
1495: fnd_message.set_token('LABEL', p_label);
1496: put_line( fnd_file.log, fnd_message.get);
1497: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1498:
1499:
1500: /******************************************************

Line 1497: fnd_file.put_line(fnd_file.log, '----------------------------------------');

1493: put_line( fnd_file.log, fnd_message.get);
1494: fnd_message.set_name('JL', 'JL_CO_GL_MG_LABEL');
1495: fnd_message.set_token('LABEL', p_label);
1496: put_line( fnd_file.log, fnd_message.get);
1497: fnd_file.put_line(fnd_file.log, '----------------------------------------');
1498:
1499:
1500: /******************************************************
1501: Check for JL_CO_GL_MG_HEADERS.STATUS = 'Y'. If any row

Line 1594: put_line(fnd_file.log, fnd_message.get);

1590:
1591: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1592: fnd_message.set_token('GENERIC_TEXT',
1593: 'Exception "NO_DATA_FOUND" while selecting company information');
1594: put_line(fnd_file.log, fnd_message.get);
1595: x_error_code := SQLCODE;
1596: x_error_text := SUBSTR(SQLERRM,1,200);
1597: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);
1598:

Line 1604: put_line(fnd_file.log, fnd_message.get);

1600:
1601: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1602: fnd_message.set_token('GENERIC_TEXT',
1603: 'Exception "TOO_MANY_ROWS" while selecting company information');
1604: put_line(fnd_file.log, fnd_message.get);
1605: x_error_code := SQLCODE;
1606: x_error_text := SUBSTR(SQLERRM,1,200);
1607: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);
1608:

Line 1614: put_line(fnd_file.log, fnd_message.get);

1610:
1611: fnd_message.set_name('AR', 'GENERIC_MESSAGE');
1612: fnd_message.set_token('GENERIC_TEXT',
1613: 'Exception "OTHERS" while selecting company information');
1614: put_line(fnd_file.log, fnd_message.get);
1615: x_error_code := SQLCODE;
1616: x_error_text := SUBSTR(SQLERRM,1,200);
1617: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);
1618:

Line 1721: put_line(fnd_file.output, identifi_register);

1717: /**********************************************
1718: Write identification register to the flat file
1719: **********************************************/
1720:
1721: put_line(fnd_file.output, identifi_register);
1722:
1723: fnd_message.set_name('JL', 'JL_CO_GL_MG_INDENTI_REGISTER');
1724: put_line( fnd_file.log, fnd_message.get);
1725:

Line 1724: put_line( fnd_file.log, fnd_message.get);

1720:
1721: put_line(fnd_file.output, identifi_register);
1722:
1723: fnd_message.set_name('JL', 'JL_CO_GL_MG_INDENTI_REGISTER');
1724: put_line( fnd_file.log, fnd_message.get);
1725:
1726: /****************************************
1727: Write movement_register to the flat file
1728: ****************************************/

Line 1736: put_line(fnd_file.output, movement_register);

1732: FOR g_count IN 1..tab_record_counter LOOP
1733:
1734: movement_register := tab_flat_file (g_count);
1735:
1736: put_line(fnd_file.output, movement_register);
1737:
1738: END LOOP;
1739:
1740: fnd_message.set_name('JL', 'JL_CO_GL_MG_MOVE_REGISTER');

Line 1742: put_line( fnd_file.log, fnd_message.get);

1738: END LOOP;
1739:
1740: fnd_message.set_name('JL', 'JL_CO_GL_MG_MOVE_REGISTER');
1741: fnd_message.set_token('NUMBER', tab_record_counter);
1742: put_line( fnd_file.log, fnd_message.get);
1743:
1744: ELSE
1745:
1746: NULL;

Line 1750: put_line( fnd_file.log, x_message);

1746: NULL;
1747:
1748: fnd_message.set_name('JL', 'JL_CO_GL_MG_NO_MOVE_REGISTER');
1749: x_message := fnd_message.get;
1750: put_line( fnd_file.log, x_message);
1751: put_line( fnd_file.output, x_message);
1752:
1753: END IF;
1754:

Line 1751: put_line( fnd_file.output, x_message);

1747:
1748: fnd_message.set_name('JL', 'JL_CO_GL_MG_NO_MOVE_REGISTER');
1749: x_message := fnd_message.get;
1750: put_line( fnd_file.log, x_message);
1751: put_line( fnd_file.output, x_message);
1752:
1753: END IF;
1754:
1755: closed_register := '3'||

Line 1769: put_line(fnd_file.output, closed_register);

1765: /**************************************
1766: Write closed_register to the flat file
1767: **************************************/
1768:
1769: put_line(fnd_file.output, closed_register);
1770:
1771: fnd_message.set_name('JL', 'JL_CO_GL_MG_CLOSE_REGISTER');
1772: put_line( fnd_file.log, fnd_message.get);
1773:

Line 1772: put_line( fnd_file.log, fnd_message.get);

1768:
1769: put_line(fnd_file.output, closed_register);
1770:
1771: fnd_message.set_name('JL', 'JL_CO_GL_MG_CLOSE_REGISTER');
1772: put_line( fnd_file.log, fnd_message.get);
1773:
1774: /********************************************
1775: Update the jl_co_gl_mg_headers.status to 'Y'
1776: for final generation is done for DIAN

Line 1813: put_line( fnd_file.log, x_message);

1809:
1810: WHEN HEADERS_STATUS_Y THEN
1811:
1812: x_message := '----***************** W A R N I N G **********************----';
1813: put_line( fnd_file.log, x_message);
1814: fnd_message.set_name('JL', 'JL_CO_GL_MG_FILE_SENT');
1815: fnd_message.set_token('YEAR', p_reported_year);
1816: x_error_text := fnd_message.get;
1817: put_line( fnd_file.log, x_error_text);

Line 1817: put_line( fnd_file.log, x_error_text);

1813: put_line( fnd_file.log, x_message);
1814: fnd_message.set_name('JL', 'JL_CO_GL_MG_FILE_SENT');
1815: fnd_message.set_token('YEAR', p_reported_year);
1816: x_error_text := fnd_message.get;
1817: put_line( fnd_file.log, x_error_text);
1818: x_error_text := SUBSTR(x_error_text, 1, 100);
1819: x_message := '----******************************************************----';
1820: put_line( fnd_file.log, x_message);
1821: app_exception.raise_exception (exception_type => 'APP',

Line 1820: put_line( fnd_file.log, x_message);

1816: x_error_text := fnd_message.get;
1817: put_line( fnd_file.log, x_error_text);
1818: x_error_text := SUBSTR(x_error_text, 1, 100);
1819: x_message := '----******************************************************----';
1820: put_line( fnd_file.log, x_message);
1821: app_exception.raise_exception (exception_type => 'APP',
1822: exception_code =>
1823: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_CO_GL_MG_FILE_SENT'),
1824: exception_text => x_error_text);

Line 1830: put_line( fnd_file.log, x_message);

1826:
1827: WHEN MG_GENERAL_ALERT THEN
1828:
1829: x_message := '----***************** W A R N I N G **********************----';
1830: put_line( fnd_file.log, x_message);
1831: fnd_message.set_name('JL', 'JL_CO_GL_MG_GEN_ALERT');
1832: fnd_message.set_token('NUMBER', TO_CHAR(count_process_flag));
1833: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LITERALS');
1834: x_error_text := SUBSTR(fnd_message.get, 1, 200);

Line 1835: put_line( fnd_file.log, x_error_text);

1831: fnd_message.set_name('JL', 'JL_CO_GL_MG_GEN_ALERT');
1832: fnd_message.set_token('NUMBER', TO_CHAR(count_process_flag));
1833: fnd_message.set_token('TABLE', 'JL_CO_GL_MG_LITERALS');
1834: x_error_text := SUBSTR(fnd_message.get, 1, 200);
1835: put_line( fnd_file.log, x_error_text);
1836: x_error_text := SUBSTR(x_error_text, 1, 100);
1837: x_message := '----******************************************************----';
1838: put_line( fnd_file.log, x_message);
1839: app_exception.raise_exception (exception_type => 'APP',

Line 1838: put_line( fnd_file.log, x_message);

1834: x_error_text := SUBSTR(fnd_message.get, 1, 200);
1835: put_line( fnd_file.log, x_error_text);
1836: x_error_text := SUBSTR(x_error_text, 1, 100);
1837: x_message := '----******************************************************----';
1838: put_line( fnd_file.log, x_message);
1839: app_exception.raise_exception (exception_type => 'APP',
1840: exception_code =>
1841: jl_zz_fa_utilities_pkg.get_app_errnum('JL', 'JL_CO_GL_MG_GEN_ALERT'),
1842: exception_text => x_error_text);

Line 1856: fnd_file.put_line( fnd_file.log, fnd_message.get);

1852:
1853: WHEN OTHERS THEN
1854:
1855: fnd_message.set_name('JL', 'JL_CO_FA_GENERAL_ERROR');
1856: fnd_file.put_line( fnd_file.log, fnd_message.get);
1857: x_error_code := SQLCODE;
1858: x_error_text := SUBSTR(SQLERRM,1,200);
1859: RAISE_APPLICATION_ERROR( x_error_code, x_error_text);
1860: