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

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

49: g_error_rec_cnt := 0;
50:
51: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
52: fnd_message.set_token('VIEW', 'REFERENCE CODES ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
53: fnd_file.put_line(fnd_file.log, fnd_message.get);
54:
55: -- Get all the reocords from interface table with status = 'N'
56: FOR new_crfcode_rec IN int_crfcode_cur
57: LOOP

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

65: -- log record level processing message
66: fnd_message.set_name('IGS','IGS_UC_PROC_REFCODE_REC');
67: fnd_message.set_token('CODE', new_crfcode_rec.code);
68: fnd_message.set_token('TYPE', new_crfcode_rec.code_type);
69: fnd_file.put_line(fnd_file.log, fnd_message.get);
70:
71:
72: -- validate mandatory fields have values.
73: IF new_crfcode_rec.code_type IS NULL OR new_crfcode_rec.code IS NULL THEN

Line 114: fnd_file.put_line(fnd_file.log, SQLERRM);

110: );
111: EXCEPTION
112: WHEN OTHERS THEN
113: g_error_code := '9998';
114: fnd_file.put_line(fnd_file.log, SQLERRM);
115:
116: END;
117:
118: ELSE /* Update the record */

Line 132: fnd_file.put_line(fnd_file.log, SQLERRM);

128: );
129: EXCEPTION
130: WHEN OTHERS THEN
131: g_error_code := '9998';
132: fnd_file.put_line(fnd_file.log, SQLERRM);
133:
134: -- log error message
135: igs_uc_proc_ucas_data.log_error_msg(g_error_code);
136: END;

Line 160: fnd_file.put_line(fnd_file.log, SQLERRM);

156: CLOSE chk_code_type_cur;
157: END IF;
158:
159: g_error_code := '1055';
160: fnd_file.put_line(fnd_file.log, SQLERRM);
161: END;
162:
163: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
164: -- while processing the record.

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

192: WHEN OTHERS THEN
193: ROLLBACK;
194: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
195: fnd_message.set_token('VIEW', 'REF CODES'||' - '||SQLERRM);
196: fnd_file.put_line(fnd_file.log, fnd_message.get);
197: END process_cvrefcodes;
198:
199:
200:

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

236: g_error_rec_cnt := 0;
237:
238: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
239: fnd_message.set_token('VIEW', 'CVREFAWARDBODY ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
240: fnd_file.put_line(fnd_file.log, fnd_message.get);
241:
242: -- Get all the reocords from interface table with status = 'N'
243: FOR new_awdbdy_rec IN int_awdbdy_cur LOOP
244:

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

251: fnd_message.set_name('IGS','IGS_UC_PROC_REFAWD_REC');
252: fnd_message.set_token('YEAR', new_awdbdy_rec.year);
253: fnd_message.set_token('SITTING', new_awdbdy_rec.sitting);
254: fnd_message.set_token('AWDBDY', new_awdbdy_rec.awardingbody);
255: fnd_file.put_line(fnd_file.log, fnd_message.get);
256:
257:
258: -- validate mandatory fields have values.
259: IF new_awdbdy_rec.year IS NULL OR new_awdbdy_rec.sitting IS NULL OR new_awdbdy_rec.awardingbody IS NULL THEN

Line 289: fnd_file.put_line(fnd_file.log, SQLERRM);

285:
286: EXCEPTION
287: WHEN OTHERS THEN
288: g_error_code := '9999';
289: fnd_file.put_line(fnd_file.log, SQLERRM);
290:
291: END;
292:
293: ELSE -- update

Line 310: fnd_file.put_line(fnd_file.log, SQLERRM);

306:
307: EXCEPTION
308: WHEN OTHERS THEN
309: g_error_code := '9998';
310: fnd_file.put_line(fnd_file.log, SQLERRM);
311:
312: END;
313: END IF; -- insert/update
314:

Line 328: fnd_file.put_line(fnd_file.log, SQLERRM);

324: CLOSE old_awdbdy_cur;
325: END IF;
326:
327: g_error_code := '1055';
328: fnd_file.put_line(fnd_file.log, SQLERRM);
329: END;
330:
331: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
332: -- while processing the record.

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

361: WHEN OTHERS THEN
362: ROLLBACK;
363: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
364: fnd_message.set_token('VIEW', 'CVREFAWARDBODY'||' - '||SQLERRM);
365: fnd_file.put_line(fnd_file.log, fnd_message.get);
366: END process_cvrefawardbody;
367:
368:
369:

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

399: g_error_rec_cnt := 0;
400:
401: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
402: fnd_message.set_token('VIEW', 'CVREFAPR ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
403: fnd_file.put_line(fnd_file.log, fnd_message.get);
404:
405: -- Get all the reocords from interface table with status = 'N'
406: FOR new_refapr_rec IN int_refapr_cur LOOP
407:

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

414: -- log record level processing message
415: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
416: fnd_message.set_token('KEY', 'DOM');
417: fnd_message.set_token('VALUE', new_refapr_rec.dom);
418: fnd_file.put_line(fnd_file.log, fnd_message.get);
419:
420:
421: -- validate mandatory fields have values.
422: IF new_refapr_rec.dom IS NULL THEN

Line 450: fnd_file.put_line(fnd_file.log, SQLERRM);

446:
447: EXCEPTION
448: WHEN OTHERS THEN
449: g_error_code := '9999';
450: fnd_file.put_line(fnd_file.log, SQLERRM);
451: END;
452:
453: ELSE -- update
454: BEGIN

Line 468: fnd_file.put_line(fnd_file.log, SQLERRM);

464:
465: EXCEPTION
466: WHEN OTHERS THEN
467: g_error_code := '9998';
468: fnd_file.put_line(fnd_file.log, SQLERRM);
469: END;
470: END IF;
471:
472: END IF; -- error not null

Line 485: fnd_file.put_line(fnd_file.log, SQLERRM);

481: CLOSE old_refapr_cur;
482: END IF;
483:
484: g_error_code := '1055';
485: fnd_file.put_line(fnd_file.log, SQLERRM);
486: END;
487:
488: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
489: -- while processing the record.

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

518: WHEN OTHERS THEN
519: ROLLBACK;
520: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
521: fnd_message.set_token('VIEW', 'CVREFAPR'||' - '||SQLERRM);
522: fnd_file.put_line(fnd_file.log, fnd_message.get);
523: END process_cvrefapr;
524:
525:
526: PROCEDURE process_cvrefkeyword IS

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

553: g_error_rec_cnt := 0;
554:
555: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
556: fnd_message.set_token('VIEW', 'CVREFKEYWORD ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
557: fnd_file.put_line(fnd_file.log, fnd_message.get);
558:
559: -- Get all the reocords from interface table with status = 'N'
560: FOR new_refkwd_rec IN int_refkwd_cur LOOP
561:

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

567: -- log record level processing message
568: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
569: fnd_message.set_token('KEY', 'KEYWORD');
570: fnd_message.set_token('VALUE', new_refkwd_rec.keyword);
571: fnd_file.put_line(fnd_file.log, fnd_message.get);
572:
573:
574: -- validate mandatory fields have values.
575: IF new_refkwd_rec.keyword IS NULL THEN

Line 601: fnd_file.put_line(fnd_file.log, SQLERRM);

597:
598: EXCEPTION
599: WHEN OTHERS THEN
600: g_error_code := '9999';
601: fnd_file.put_line(fnd_file.log, SQLERRM);
602: END;
603:
604: ELSE -- update
605: BEGIN

Line 617: fnd_file.put_line(fnd_file.log, SQLERRM);

613:
614: EXCEPTION
615: WHEN OTHERS THEN
616: g_error_code := '9998';
617: fnd_file.put_line(fnd_file.log, SQLERRM);
618: END;
619: END IF;
620:
621: END IF; -- error not null

Line 634: fnd_file.put_line(fnd_file.log, SQLERRM);

630: CLOSE old_refkwd_cur;
631: END IF;
632:
633: g_error_code := '1055';
634: fnd_file.put_line(fnd_file.log, SQLERRM);
635: END;
636:
637: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
638: -- while processing the record.

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

666: WHEN OTHERS THEN
667: ROLLBACK;
668: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
669: fnd_message.set_token('VIEW', 'CVREFKEYWORD'||' - '||SQLERRM);
670: fnd_file.put_line(fnd_file.log, fnd_message.get);
671: END process_cvrefkeyword;
672:
673:
674: PROCEDURE process_cvrefpocc IS

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

709: g_error_rec_cnt := 0;
710:
711: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
712: fnd_message.set_token('VIEW', 'CVREFPOCC ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
713: fnd_file.put_line(fnd_file.log, fnd_message.get);
714:
715: -- Get all the reocords from interface table with status = 'N'
716: FOR new_refpocc_rec IN int_refpocc_cur LOOP
717:

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

724: -- log record level processing message
725: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
726: fnd_message.set_token('KEY', 'POCC');
727: fnd_message.set_token('VALUE', new_refpocc_rec.pocc);
728: fnd_file.put_line(fnd_file.log, fnd_message.get);
729:
730:
731: -- validate mandatory fields have values.
732: IF new_refpocc_rec.pocc IS NULL THEN

Line 766: fnd_file.put_line(fnd_file.log, SQLERRM);

762:
763: EXCEPTION
764: WHEN OTHERS THEN
765: g_error_code := '9999';
766: fnd_file.put_line(fnd_file.log, SQLERRM);
767: END;
768:
769: ELSE -- update
770: BEGIN

Line 788: fnd_file.put_line(fnd_file.log, SQLERRM);

784:
785: EXCEPTION
786: WHEN OTHERS THEN
787: g_error_code := '9998';
788: fnd_file.put_line(fnd_file.log, SQLERRM);
789: END;
790: END IF;
791:
792: END IF; -- error not null

Line 805: fnd_file.put_line(fnd_file.log, SQLERRM);

801: CLOSE old_refpocc_cur;
802: END IF;
803:
804: g_error_code := '1055';
805: fnd_file.put_line(fnd_file.log, SQLERRM);
806: END;
807:
808: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
809: -- while processing the record.

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

836: WHEN OTHERS THEN
837: ROLLBACK;
838: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
839: fnd_message.set_token('VIEW', 'CVREFPOCC'||' - '||SQLERRM);
840: fnd_file.put_line(fnd_file.log, fnd_message.get);
841: END process_cvrefpocc;
842:
843:
844:

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

937: g_error_rec_cnt := 0;
938:
939: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
940: fnd_message.set_token('VIEW', 'CVREFOFFERABBREV ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
941: fnd_file.put_line(fnd_file.log, fnd_message.get);
942:
943: -- Get all the reocords from interface table with status = 'N'
944: FOR new_refoffab_rec IN int_refoffab_cur LOOP
945:

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

953: -- log record level processing message
954: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
955: fnd_message.set_token('KEY', 'Abbreviation Code');
956: fnd_message.set_token('VALUE', new_refoffab_rec.abbrevcode);
957: fnd_file.put_line(fnd_file.log, fnd_message.get);
958:
959:
960: -- validate mandatory fields have values.
961: IF new_refoffab_rec.abbrevcode IS NULL OR new_refoffab_rec.letterformat IS NULL THEN

Line 997: fnd_file.put_line(fnd_file.log, SQLERRM);

993:
994: EXCEPTION
995: WHEN OTHERS THEN
996: g_error_code := '9999';
997: fnd_file.put_line(fnd_file.log, SQLERRM);
998: END;
999:
1000: ELSE -- update
1001: BEGIN

Line 1023: fnd_file.put_line(fnd_file.log, SQLERRM);

1019:
1020: EXCEPTION
1021: WHEN OTHERS THEN
1022: g_error_code := '9998';
1023: fnd_file.put_line(fnd_file.log, SQLERRM);
1024: END;
1025: END IF;
1026:
1027: END IF; -- error not null

Line 1040: fnd_file.put_line(fnd_file.log, SQLERRM);

1036: CLOSE old_refoffab_cur;
1037: END IF;
1038:
1039: g_error_code := '1055';
1040: fnd_file.put_line(fnd_file.log, SQLERRM);
1041: END;
1042:
1043: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
1044: -- while processing the record.

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

1072: WHEN OTHERS THEN
1073: ROLLBACK;
1074: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1075: fnd_message.set_token('VIEW', 'CVREFOFFERABBREV'||' - '||SQLERRM);
1076: fnd_file.put_line(fnd_file.log, fnd_message.get);
1077: END process_cvrefofferabbrev;
1078:
1079:
1080:

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

1112: g_error_rec_cnt := 0;
1113:
1114: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1115: fnd_message.set_token('VIEW', 'CVREFSUBJ ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1116: fnd_file.put_line(fnd_file.log, fnd_message.get);
1117:
1118: -- Get all the reocords from interface table with status = 'N'
1119: FOR new_refsubj_rec IN int_refsubj_cur LOOP
1120:

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

1127: -- log record level processing message
1128: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
1129: fnd_message.set_token('KEY', 'SUBJECT ');
1130: fnd_message.set_token('VALUE', new_refsubj_rec.subjcode);
1131: fnd_file.put_line(fnd_file.log, fnd_message.get);
1132:
1133:
1134: -- validate mandatory fields have values.
1135: IF new_refsubj_rec.subjcode IS NULL OR new_refsubj_rec.SUBJTEXT IS NULL THEN

Line 1164: fnd_file.put_line(fnd_file.log, SQLERRM);

1160:
1161: EXCEPTION
1162: WHEN OTHERS THEN
1163: g_error_code := '9999';
1164: fnd_file.put_line(fnd_file.log, SQLERRM);
1165: END;
1166:
1167: ELSE -- update
1168: BEGIN

Line 1183: fnd_file.put_line(fnd_file.log, SQLERRM);

1179:
1180: EXCEPTION
1181: WHEN OTHERS THEN
1182: g_error_code := '9998';
1183: fnd_file.put_line(fnd_file.log, SQLERRM);
1184: END;
1185: END IF;
1186:
1187: END IF; -- error not null

Line 1200: fnd_file.put_line(fnd_file.log, SQLERRM);

1196: CLOSE old_refsubj_cur;
1197: END IF;
1198:
1199: g_error_code := '1055';
1200: fnd_file.put_line(fnd_file.log, SQLERRM);
1201: END;
1202:
1203: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
1204: -- while processing the record.

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

1231: WHEN OTHERS THEN
1232: ROLLBACK;
1233: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1234: fnd_message.set_token('VIEW', 'CVREFSUBJ'||' - '||SQLERRM);
1235: fnd_file.put_line(fnd_file.log, fnd_message.get);
1236: END process_cvrefsubj;
1237:
1238:
1239:

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

1274: g_error_rec_cnt := 0;
1275:
1276: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1277: fnd_message.set_token('VIEW', 'CVREFTARIFF ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1278: fnd_file.put_line(fnd_file.log, fnd_message.get);
1279:
1280: -- Get all the reocords from interface table with status = 'N'
1281: FOR new_reftariff_rec IN int_reftariff_cur LOOP
1282:

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

1288: -- log record level processing message
1289: fnd_message.set_name('IGS','IGS_UC_PROC_REFTARIFF_REC');
1290: fnd_message.set_token('EXAMLVL' , new_reftariff_rec.examlevel);
1291: fnd_message.set_token('EXAMGRADE', new_reftariff_rec.examgrade);
1292: fnd_file.put_line(fnd_file.log, fnd_message.get);
1293:
1294: -- validate mandatory fields have values.
1295: IF new_reftariff_rec.examlevel IS NULL OR new_reftariff_rec.examgrade IS NULL OR new_reftariff_rec.tariffscore IS NULL THEN
1296: g_error_code := '1037';

Line 1324: fnd_file.put_line(fnd_file.log, SQLERRM);

1320:
1321: EXCEPTION
1322: WHEN OTHERS THEN
1323: g_error_code := '9999';
1324: fnd_file.put_line(fnd_file.log, SQLERRM);
1325: END;
1326:
1327: ELSE -- update
1328: BEGIN

Line 1342: fnd_file.put_line(fnd_file.log, SQLERRM);

1338:
1339: EXCEPTION
1340: WHEN OTHERS THEN
1341: g_error_code := '9998';
1342: fnd_file.put_line(fnd_file.log, SQLERRM);
1343: END;
1344: END IF;
1345:
1346: END IF; -- error not null

Line 1359: fnd_file.put_line(fnd_file.log, SQLERRM);

1355: CLOSE old_reftariff_cur;
1356: END IF;
1357:
1358: g_error_code := '1055';
1359: fnd_file.put_line(fnd_file.log, SQLERRM);
1360: END;
1361:
1362: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
1363: -- while processing the record.

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

1391: WHEN OTHERS THEN
1392: ROLLBACK;
1393: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1394: fnd_message.set_token('VIEW', 'CVREFTARIFF'||' - '||SQLERRM);
1395: fnd_file.put_line(fnd_file.log, fnd_message.get);
1396:
1397: END process_cvreftariff;
1398:
1399:

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

1440: g_error_rec_cnt := 0;
1441:
1442: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1443: fnd_message.set_token('VIEW', 'CVJOINTADMISSIONS ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1444: fnd_file.put_line(fnd_file.log, fnd_message.get);
1445:
1446: -- Get all the reocords from interface table with status = 'N'
1447: FOR new_cjntadm_rec IN int_cjntadm_cur LOOP
1448:

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

1454: -- log record level processing message
1455: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
1456: fnd_message.set_token('KEY' , 'CHILDINST ');
1457: fnd_message.set_token('VALUE', new_cjntadm_rec.childinst);
1458: fnd_file.put_line(fnd_file.log, fnd_message.get);
1459:
1460:
1461: -- validate mandatory fields have values.
1462: IF new_cjntadm_rec.childinst IS NULL OR new_cjntadm_rec.parentinst1 IS NULL THEN

Line 1570: fnd_file.put_line(fnd_file.log, SQLERRM);

1566:
1567: EXCEPTION
1568: WHEN OTHERS THEN
1569: g_error_code := '9999';
1570: fnd_file.put_line(fnd_file.log, SQLERRM);
1571: END;
1572:
1573: ELSE -- update
1574: BEGIN

Line 1590: fnd_file.put_line(fnd_file.log, SQLERRM);

1586:
1587: EXCEPTION
1588: WHEN OTHERS THEN
1589: g_error_code := '9998';
1590: fnd_file.put_line(fnd_file.log, SQLERRM);
1591: END;
1592: END IF;
1593:
1594: END IF; -- error not null

Line 1612: fnd_file.put_line(fnd_file.log, SQLERRM);

1608: CLOSE chk_inst_cur;
1609: END IF;
1610:
1611: g_error_code := '1055';
1612: fnd_file.put_line(fnd_file.log, SQLERRM);
1613: END;
1614:
1615: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
1616: -- while processing the record.

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

1643: WHEN OTHERS THEN
1644: ROLLBACK;
1645: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1646: fnd_message.set_token('VIEW', 'CVJOINTADMISSIONS'||' - '||SQLERRM);
1647: fnd_file.put_line(fnd_file.log, fnd_message.get);
1648: END process_cvjointadmissions;
1649:
1650:
1651: PROCEDURE process_cvrefcountry IS

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

1680: g_error_rec_cnt := 0;
1681:
1682: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1683: fnd_message.set_token('VIEW', 'CVREFCOUNTRY ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1684: fnd_file.put_line(fnd_file.log, fnd_message.get);
1685:
1686: -- Get all the reocords from interface table with status = 'N'
1687: FOR new_country_rec IN int_country_cur LOOP
1688:

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

1694: -- log record level processing message
1695: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
1696: fnd_message.set_token('KEY' , 'COUNTRY CODE');
1697: fnd_message.set_token('VALUE', new_country_rec.countrycode);
1698: fnd_file.put_line(fnd_file.log, fnd_message.get);
1699:
1700:
1701: -- validate mandatory fields have values.
1702: IF new_country_rec.countrycode IS NULL THEN

Line 1730: fnd_file.put_line(fnd_file.log, SQLERRM);

1726:
1727: EXCEPTION
1728: WHEN OTHERS THEN
1729: g_error_code := '9999';
1730: fnd_file.put_line(fnd_file.log, SQLERRM);
1731: END;
1732:
1733: ELSE -- update
1734: BEGIN

Line 1748: fnd_file.put_line(fnd_file.log, SQLERRM);

1744:
1745: EXCEPTION
1746: WHEN OTHERS THEN
1747: g_error_code := '9998';
1748: fnd_file.put_line(fnd_file.log, SQLERRM);
1749: END;
1750: END IF;
1751:
1752: END IF; -- error not null

Line 1765: fnd_file.put_line(fnd_file.log, SQLERRM);

1761: CLOSE old_country_cur;
1762: END IF;
1763:
1764: g_error_code := '1055';
1765: fnd_file.put_line(fnd_file.log, SQLERRM);
1766: END;
1767:
1768: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
1769: -- while processing the record.

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

1797: WHEN OTHERS THEN
1798: ROLLBACK;
1799: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1800: fnd_message.set_token('VIEW', 'CVREFPRECOUNTRY'||' - '||SQLERRM);
1801: fnd_file.put_line(fnd_file.log, fnd_message.get);
1802: END process_cvrefcountry;
1803:
1804:
1805: