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_COM_INST_DATA dependencies on FND_MESSAGE

Line 37: fnd_message.set_name('IGS','IGS_UC_CURR_INST_NOT_SET');

33: FETCH crnt_inst_cur INTO g_crnt_institute;
34: CLOSE crnt_inst_cur;
35:
36: IF g_crnt_institute IS NULL THEN
37: fnd_message.set_name('IGS','IGS_UC_CURR_INST_NOT_SET');
38: errbuf := fnd_message.get;
39: fnd_file.put_line(fnd_file.log, errbuf);
40: retcode := 2;
41: RETURN;

Line 38: errbuf := fnd_message.get;

34: CLOSE crnt_inst_cur;
35:
36: IF g_crnt_institute IS NULL THEN
37: fnd_message.set_name('IGS','IGS_UC_CURR_INST_NOT_SET');
38: errbuf := fnd_message.get;
39: fnd_file.put_line(fnd_file.log, errbuf);
40: retcode := 2;
41: RETURN;
42: END IF;

Line 47: fnd_message.set_name('IGS','IGS_UC_GEN_PRTY_PROF_NOT_SET');

43:
44: -- validate that the Generate party Num profile is set to Y else log error message
45: -- Added this validation as part of Bug# 3327176
46: IF fnd_profile.value('HZ_GENERATE_PARTY_NUMBER') <> 'Y' THEN
47: fnd_message.set_name('IGS','IGS_UC_GEN_PRTY_PROF_NOT_SET');
48: errbuf := fnd_message.get;
49: fnd_file.put_line(fnd_file.log, errbuf);
50: retcode := 2;
51: RETURN;

Line 48: errbuf := fnd_message.get;

44: -- validate that the Generate party Num profile is set to Y else log error message
45: -- Added this validation as part of Bug# 3327176
46: IF fnd_profile.value('HZ_GENERATE_PARTY_NUMBER') <> 'Y' THEN
47: fnd_message.set_name('IGS','IGS_UC_GEN_PRTY_PROF_NOT_SET');
48: errbuf := fnd_message.get;
49: fnd_file.put_line(fnd_file.log, errbuf);
50: retcode := 2;
51: RETURN;
52: END IF;

Line 57: fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');

53:
54: EXCEPTION
55: WHEN OTHERS THEN
56: retcode := 2;
57: fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
58: fnd_message.set_token('NAME','IGS_UC_PROC_COM_INST_DATA.COMMON_DATA_SETUP '||' - '||SQLERRM);
59: errbuf := fnd_message.get;
60: fnd_file.put_line(fnd_file.LOG, errbuf);
61: app_exception.raise_exception;

Line 58: fnd_message.set_token('NAME','IGS_UC_PROC_COM_INST_DATA.COMMON_DATA_SETUP '||' - '||SQLERRM);

54: EXCEPTION
55: WHEN OTHERS THEN
56: retcode := 2;
57: fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
58: fnd_message.set_token('NAME','IGS_UC_PROC_COM_INST_DATA.COMMON_DATA_SETUP '||' - '||SQLERRM);
59: errbuf := fnd_message.get;
60: fnd_file.put_line(fnd_file.LOG, errbuf);
61: app_exception.raise_exception;
62: END common_data_setup;

Line 59: errbuf := fnd_message.get;

55: WHEN OTHERS THEN
56: retcode := 2;
57: fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
58: fnd_message.set_token('NAME','IGS_UC_PROC_COM_INST_DATA.COMMON_DATA_SETUP '||' - '||SQLERRM);
59: errbuf := fnd_message.get;
60: fnd_file.put_line(fnd_file.LOG, errbuf);
61: app_exception.raise_exception;
62: END common_data_setup;
63:

Line 111: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

107: g_error_rec_cnt := 0;
108: l_rowcnt := 0;
109:
110: -- log record processing message
111: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
112: fnd_message.set_token('VIEW', 'UVINSTITUTION ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
113: fnd_file.put_line(fnd_file.log, fnd_message.get);
114:
115: -- record level initialization

Line 112: fnd_message.set_token('VIEW', 'UVINSTITUTION ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

108: l_rowcnt := 0;
109:
110: -- log record processing message
111: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
112: fnd_message.set_token('VIEW', 'UVINSTITUTION ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
113: fnd_file.put_line(fnd_file.log, fnd_message.get);
114:
115: -- record level initialization
116: g_error_code := NULL;

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

109:
110: -- log record processing message
111: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
112: fnd_message.set_token('VIEW', 'UVINSTITUTION ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
113: fnd_file.put_line(fnd_file.log, fnd_message.get);
114:
115: -- record level initialization
116: g_error_code := NULL;
117:

Line 319: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

315: EXCEPTION
316: WHEN OTHERS THEN
317: -- Process should continue with processing of other view data
318: ROLLBACK;
319: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
320: fnd_message.set_token('VIEW', 'UVINSTITUTION'||' - '||SQLERRM);
321: fnd_file.put_line(fnd_file.log, fnd_message.get);
322: END process_uvinstitution;
323:

Line 320: fnd_message.set_token('VIEW', 'UVINSTITUTION'||' - '||SQLERRM);

316: WHEN OTHERS THEN
317: -- Process should continue with processing of other view data
318: ROLLBACK;
319: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
320: fnd_message.set_token('VIEW', 'UVINSTITUTION'||' - '||SQLERRM);
321: fnd_file.put_line(fnd_file.log, fnd_message.get);
322: END process_uvinstitution;
323:
324:

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

317: -- Process should continue with processing of other view data
318: ROLLBACK;
319: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
320: fnd_message.set_token('VIEW', 'UVINSTITUTION'||' - '||SQLERRM);
321: fnd_file.put_line(fnd_file.log, fnd_message.get);
322: END process_uvinstitution;
323:
324:
325: /* ============================================================================================================= */

Line 388: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

384: g_success_rec_cnt := 0;
385: g_error_rec_cnt := 0;
386: l_rec_status := NULL;
387:
388: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
389: fnd_message.set_token('VIEW', 'UVOFFERABBREV ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
390: fnd_file.put_line(fnd_file.log, fnd_message.get);
391:
392: -- Get all the reocords from interface table with status = 'N'

Line 389: fnd_message.set_token('VIEW', 'UVOFFERABBREV ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

385: g_error_rec_cnt := 0;
386: l_rec_status := NULL;
387:
388: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
389: fnd_message.set_token('VIEW', 'UVOFFERABBREV ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
390: fnd_file.put_line(fnd_file.log, fnd_message.get);
391:
392: -- Get all the reocords from interface table with status = 'N'
393: FOR new_uvoffabrv_rec IN int_uvoffabrv_cur LOOP

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

386: l_rec_status := NULL;
387:
388: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
389: fnd_message.set_token('VIEW', 'UVOFFERABBREV ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
390: fnd_file.put_line(fnd_file.log, fnd_message.get);
391:
392: -- Get all the reocords from interface table with status = 'N'
393: FOR new_uvoffabrv_rec IN int_uvoffabrv_cur LOOP
394:

Line 403: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');

399: l_rec_status := 'N';
400: old_uvoffabrv_rec := NULL;
401:
402: -- log message for the record being processed
403: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
404: fnd_message.set_token('KEY', 'Abbreviation Code ');
405: fnd_message.set_token('VALUE', TO_CHAR(new_uvoffabrv_rec.abbrevid));
406: fnd_file.put_line(fnd_file.log, fnd_message.get);
407:

Line 404: fnd_message.set_token('KEY', 'Abbreviation Code ');

400: old_uvoffabrv_rec := NULL;
401:
402: -- log message for the record being processed
403: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
404: fnd_message.set_token('KEY', 'Abbreviation Code ');
405: fnd_message.set_token('VALUE', TO_CHAR(new_uvoffabrv_rec.abbrevid));
406: fnd_file.put_line(fnd_file.log, fnd_message.get);
407:
408:

Line 405: fnd_message.set_token('VALUE', TO_CHAR(new_uvoffabrv_rec.abbrevid));

401:
402: -- log message for the record being processed
403: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
404: fnd_message.set_token('KEY', 'Abbreviation Code ');
405: fnd_message.set_token('VALUE', TO_CHAR(new_uvoffabrv_rec.abbrevid));
406: fnd_file.put_line(fnd_file.log, fnd_message.get);
407:
408:
409: -- validate mandatory fields have values.

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

402: -- log message for the record being processed
403: fnd_message.set_name('IGS','IGS_UC_PROC_INTERFACE_REC');
404: fnd_message.set_token('KEY', 'Abbreviation Code ');
405: fnd_message.set_token('VALUE', TO_CHAR(new_uvoffabrv_rec.abbrevid));
406: fnd_file.put_line(fnd_file.log, fnd_message.get);
407:
408:
409: -- validate mandatory fields have values.
410: -- jchakrab removed validation check for letterformat as its no longer used

Line 552: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

548: EXCEPTION
549: -- Process should continue with processing of other view data
550: WHEN OTHERS THEN
551: ROLLBACK;
552: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
553: fnd_message.set_token('VIEW', 'UVOFFERABBREV'||' - '||SQLERRM);
554: fnd_file.put_line(fnd_file.log, fnd_message.get);
555:
556: END process_uvofferabbrev;

Line 553: fnd_message.set_token('VIEW', 'UVOFFERABBREV'||' - '||SQLERRM);

549: -- Process should continue with processing of other view data
550: WHEN OTHERS THEN
551: ROLLBACK;
552: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
553: fnd_message.set_token('VIEW', 'UVOFFERABBREV'||' - '||SQLERRM);
554: fnd_file.put_line(fnd_file.log, fnd_message.get);
555:
556: END process_uvofferabbrev;
557:

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

550: WHEN OTHERS THEN
551: ROLLBACK;
552: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
553: fnd_message.set_token('VIEW', 'UVOFFERABBREV'||' - '||SQLERRM);
554: fnd_file.put_line(fnd_file.log, fnd_message.get);
555:
556: END process_uvofferabbrev;
557:
558:

Line 592: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

588: -- initialize variables
589: g_success_rec_cnt := 0;
590: g_error_rec_cnt := 0;
591:
592: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
593: fnd_message.set_token('VIEW', 'CVINSTITUTION ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
594: fnd_file.put_line(fnd_file.log, fnd_message.get);
595:
596: -- Get all the reocords from interface table with status = 'N'

Line 593: fnd_message.set_token('VIEW', 'CVINSTITUTION ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

589: g_success_rec_cnt := 0;
590: g_error_rec_cnt := 0;
591:
592: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
593: fnd_message.set_token('VIEW', 'CVINSTITUTION ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
594: fnd_file.put_line(fnd_file.log, fnd_message.get);
595:
596: -- Get all the reocords from interface table with status = 'N'
597: FOR new_cvinst_rec IN int_cvinst_cur LOOP

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

590: g_error_rec_cnt := 0;
591:
592: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
593: fnd_message.set_token('VIEW', 'CVINSTITUTION ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
594: fnd_file.put_line(fnd_file.log, fnd_message.get);
595:
596: -- Get all the reocords from interface table with status = 'N'
597: FOR new_cvinst_rec IN int_cvinst_cur LOOP
598:

Line 606: fnd_message.set_name('IGS','IGS_UC_INST_PROC');

602: g_error_code := NULL;
603: old_inst_rec := NULL;
604:
605: -- log record level processing message
606: fnd_message.set_name('IGS','IGS_UC_INST_PROC');
607: fnd_message.set_token('INST', new_cvinst_rec.inst);
608: fnd_file.put_line(fnd_file.log, fnd_message.get);
609:
610:

Line 607: fnd_message.set_token('INST', new_cvinst_rec.inst);

603: old_inst_rec := NULL;
604:
605: -- log record level processing message
606: fnd_message.set_name('IGS','IGS_UC_INST_PROC');
607: fnd_message.set_token('INST', new_cvinst_rec.inst);
608: fnd_file.put_line(fnd_file.log, fnd_message.get);
609:
610:
611: -- validate mandatory fields have values.

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

604:
605: -- log record level processing message
606: fnd_message.set_name('IGS','IGS_UC_INST_PROC');
607: fnd_message.set_token('INST', new_cvinst_rec.inst);
608: fnd_file.put_line(fnd_file.log, fnd_message.get);
609:
610:
611: -- validate mandatory fields have values.
612: IF new_cvinst_rec.inst IS NULL THEN

Line 727: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

723: EXCEPTION
724: -- Process should continue with processing of other view data
725: WHEN OTHERS THEN
726: ROLLBACK;
727: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
728: fnd_message.set_token('VIEW', 'CVINSTITUTION'||' - '||SQLERRM);
729: fnd_file.put_line(fnd_file.log, fnd_message.get);
730: END process_cvinstitution ;
731:

Line 728: fnd_message.set_token('VIEW', 'CVINSTITUTION'||' - '||SQLERRM);

724: -- Process should continue with processing of other view data
725: WHEN OTHERS THEN
726: ROLLBACK;
727: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
728: fnd_message.set_token('VIEW', 'CVINSTITUTION'||' - '||SQLERRM);
729: fnd_file.put_line(fnd_file.log, fnd_message.get);
730: END process_cvinstitution ;
731:
732:

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

725: WHEN OTHERS THEN
726: ROLLBACK;
727: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
728: fnd_message.set_token('VIEW', 'CVINSTITUTION'||' - '||SQLERRM);
729: fnd_file.put_line(fnd_file.log, fnd_message.get);
730: END process_cvinstitution ;
731:
732:
733:

Line 779: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

775: -- initialize variables
776: g_success_rec_cnt := 0;
777: g_error_rec_cnt := 0;
778:
779: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
780: fnd_message.set_token('VIEW', 'CVEBLSUBJECT ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
781: fnd_file.put_line(fnd_file.log, fnd_message.get);
782:
783: -- Get all the reocords from interface table with status = 'N'

Line 780: fnd_message.set_token('VIEW', 'CVEBLSUBJECT ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

776: g_success_rec_cnt := 0;
777: g_error_rec_cnt := 0;
778:
779: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
780: fnd_message.set_token('VIEW', 'CVEBLSUBJECT ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
781: fnd_file.put_line(fnd_file.log, fnd_message.get);
782:
783: -- Get all the reocords from interface table with status = 'N'
784: FOR new_eblsubj_rec IN int_cveblsubj_cur LOOP

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

777: g_error_rec_cnt := 0;
778:
779: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
780: fnd_message.set_token('VIEW', 'CVEBLSUBJECT ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
781: fnd_file.put_line(fnd_file.log, fnd_message.get);
782:
783: -- Get all the reocords from interface table with status = 'N'
784: FOR new_eblsubj_rec IN int_cveblsubj_cur LOOP
785:

Line 794: fnd_message.set_name('IGS','IGS_UC_SUBJ_PROC');

790: old_eblsubj_rec := NULL;
791: l_awd_body_flag := NULL;
792:
793: -- log record level processing message
794: fnd_message.set_name('IGS','IGS_UC_SUBJ_PROC');
795: fnd_message.set_token('SUBJ', TO_CHAR(new_eblsubj_rec.subjectid));
796: fnd_file.put_line(fnd_file.log, fnd_message.get);
797:
798:

Line 795: fnd_message.set_token('SUBJ', TO_CHAR(new_eblsubj_rec.subjectid));

791: l_awd_body_flag := NULL;
792:
793: -- log record level processing message
794: fnd_message.set_name('IGS','IGS_UC_SUBJ_PROC');
795: fnd_message.set_token('SUBJ', TO_CHAR(new_eblsubj_rec.subjectid));
796: fnd_file.put_line(fnd_file.log, fnd_message.get);
797:
798:
799: -- validate mandatory fields have values.

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

792:
793: -- log record level processing message
794: fnd_message.set_name('IGS','IGS_UC_SUBJ_PROC');
795: fnd_message.set_token('SUBJ', TO_CHAR(new_eblsubj_rec.subjectid));
796: fnd_file.put_line(fnd_file.log, fnd_message.get);
797:
798:
799: -- validate mandatory fields have values.
800: IF new_eblsubj_rec.subjectid IS NULL OR

Line 933: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

929: EXCEPTION
930: -- Process should continue with processing of other view data
931: WHEN OTHERS THEN
932: ROLLBACK;
933: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
934: fnd_message.set_token('VIEW', 'CVEBLSUBJECT'||' - '||SQLERRM);
935: fnd_file.put_line(fnd_file.log, fnd_message.get);
936: END process_cveblsubject ;
937:

Line 934: fnd_message.set_token('VIEW', 'CVEBLSUBJECT'||' - '||SQLERRM);

930: -- Process should continue with processing of other view data
931: WHEN OTHERS THEN
932: ROLLBACK;
933: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
934: fnd_message.set_token('VIEW', 'CVEBLSUBJECT'||' - '||SQLERRM);
935: fnd_file.put_line(fnd_file.log, fnd_message.get);
936: END process_cveblsubject ;
937:
938:

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

931: WHEN OTHERS THEN
932: ROLLBACK;
933: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
934: fnd_message.set_token('VIEW', 'CVEBLSUBJECT'||' - '||SQLERRM);
935: fnd_file.put_line(fnd_file.log, fnd_message.get);
936: END process_cveblsubject ;
937:
938:
939:

Line 989: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

985: -- initialize variables
986: g_success_rec_cnt := 0;
987: g_error_rec_cnt := 0;
988:
989: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
990: fnd_message.set_token('VIEW', 'CVSCHOOL ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
991: fnd_file.put_line(fnd_file.log, fnd_message.get);
992:
993:

Line 990: fnd_message.set_token('VIEW', 'CVSCHOOL ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

986: g_success_rec_cnt := 0;
987: g_error_rec_cnt := 0;
988:
989: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
990: fnd_message.set_token('VIEW', 'CVSCHOOL ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
991: fnd_file.put_line(fnd_file.log, fnd_message.get);
992:
993:
994: -- Get all the reocords from interface table with status = 'N'

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

987: g_error_rec_cnt := 0;
988:
989: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
990: fnd_message.set_token('VIEW', 'CVSCHOOL ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
991: fnd_file.put_line(fnd_file.log, fnd_message.get);
992:
993:
994: -- Get all the reocords from interface table with status = 'N'
995: FOR new_school_rec IN int_cvschool_cur LOOP

Line 1005: fnd_message.set_name('IGS','IGS_UC_SCH_PROC');

1001: old_school_rec := NULL;
1002:
1003:
1004: -- log record level processing message
1005: fnd_message.set_name('IGS','IGS_UC_SCH_PROC');
1006: fnd_message.set_token('SCH', TO_CHAR(new_school_rec.school));
1007: fnd_file.put_line(fnd_file.log, fnd_message.get);
1008:
1009:

Line 1006: fnd_message.set_token('SCH', TO_CHAR(new_school_rec.school));

1002:
1003:
1004: -- log record level processing message
1005: fnd_message.set_name('IGS','IGS_UC_SCH_PROC');
1006: fnd_message.set_token('SCH', TO_CHAR(new_school_rec.school));
1007: fnd_file.put_line(fnd_file.log, fnd_message.get);
1008:
1009:
1010: -- validate mandatory fields have values.

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

1003:
1004: -- log record level processing message
1005: fnd_message.set_name('IGS','IGS_UC_SCH_PROC');
1006: fnd_message.set_token('SCH', TO_CHAR(new_school_rec.school));
1007: fnd_file.put_line(fnd_file.log, fnd_message.get);
1008:
1009:
1010: -- validate mandatory fields have values.
1011: IF new_school_rec.school IS NULL OR new_school_rec.estabgrp IS NULL THEN

Line 1119: fnd_message.set_name('IGS','IGS_UC_SCH_SITE_PROC');

1115: OPEN old_schsite_cur(new_school_rec.school, NVL(new_school_rec.sitecode,'A'));
1116: FETCH old_schsite_cur INTO l_schsite_rowid;
1117: CLOSE old_schsite_cur;
1118:
1119: fnd_message.set_name('IGS','IGS_UC_SCH_SITE_PROC');
1120: fnd_message.set_token('SCH', TO_CHAR(new_school_rec.school));
1121: fnd_message.set_token('SITE', NVL(new_school_rec.sitecode,'A'));
1122: fnd_file.put_line(fnd_file.log, fnd_message.get);
1123:

Line 1120: fnd_message.set_token('SCH', TO_CHAR(new_school_rec.school));

1116: FETCH old_schsite_cur INTO l_schsite_rowid;
1117: CLOSE old_schsite_cur;
1118:
1119: fnd_message.set_name('IGS','IGS_UC_SCH_SITE_PROC');
1120: fnd_message.set_token('SCH', TO_CHAR(new_school_rec.school));
1121: fnd_message.set_token('SITE', NVL(new_school_rec.sitecode,'A'));
1122: fnd_file.put_line(fnd_file.log, fnd_message.get);
1123:
1124: IF l_schsite_rowid IS NULL THEN

Line 1121: fnd_message.set_token('SITE', NVL(new_school_rec.sitecode,'A'));

1117: CLOSE old_schsite_cur;
1118:
1119: fnd_message.set_name('IGS','IGS_UC_SCH_SITE_PROC');
1120: fnd_message.set_token('SCH', TO_CHAR(new_school_rec.school));
1121: fnd_message.set_token('SITE', NVL(new_school_rec.sitecode,'A'));
1122: fnd_file.put_line(fnd_file.log, fnd_message.get);
1123:
1124: IF l_schsite_rowid IS NULL THEN
1125: BEGIN

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

1118:
1119: fnd_message.set_name('IGS','IGS_UC_SCH_SITE_PROC');
1120: fnd_message.set_token('SCH', TO_CHAR(new_school_rec.school));
1121: fnd_message.set_token('SITE', NVL(new_school_rec.sitecode,'A'));
1122: fnd_file.put_line(fnd_file.log, fnd_message.get);
1123:
1124: IF l_schsite_rowid IS NULL THEN
1125: BEGIN
1126: igs_uc_com_schsites_pkg.insert_row -- IGSXI11B.pls

Line 1240: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

1236: EXCEPTION
1237: -- Process should continue with processing of other view data
1238: WHEN OTHERS THEN
1239: ROLLBACK;
1240: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1241: fnd_message.set_token('VIEW', 'CVSCHOOL'||' - '||SQLERRM);
1242: fnd_file.put_line(fnd_file.log, fnd_message.get);
1243: END process_cvschool ;
1244:

Line 1241: fnd_message.set_token('VIEW', 'CVSCHOOL'||' - '||SQLERRM);

1237: -- Process should continue with processing of other view data
1238: WHEN OTHERS THEN
1239: ROLLBACK;
1240: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1241: fnd_message.set_token('VIEW', 'CVSCHOOL'||' - '||SQLERRM);
1242: fnd_file.put_line(fnd_file.log, fnd_message.get);
1243: END process_cvschool ;
1244:
1245:

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

1238: WHEN OTHERS THEN
1239: ROLLBACK;
1240: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1241: fnd_message.set_token('VIEW', 'CVSCHOOL'||' - '||SQLERRM);
1242: fnd_file.put_line(fnd_file.log, fnd_message.get);
1243: END process_cvschool ;
1244:
1245:
1246: PROCEDURE process_cvschoolcontact IS

Line 1297: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

1293: g_success_rec_cnt := 0;
1294: g_error_rec_cnt := 0;
1295: l_check_flag := NULL;
1296:
1297: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1298: fnd_message.set_token('VIEW', 'CVSCHOOLCONTACT ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1299: fnd_file.put_line(fnd_file.log, fnd_message.get);
1300:
1301: -- Get all the reocords from interface table with status = 'N'

Line 1298: fnd_message.set_token('VIEW', 'CVSCHOOLCONTACT ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

1294: g_error_rec_cnt := 0;
1295: l_check_flag := NULL;
1296:
1297: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1298: fnd_message.set_token('VIEW', 'CVSCHOOLCONTACT ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1299: fnd_file.put_line(fnd_file.log, fnd_message.get);
1300:
1301: -- Get all the reocords from interface table with status = 'N'
1302: FOR new_schcntct_rec IN int_cvschcnt_cur LOOP

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

1295: l_check_flag := NULL;
1296:
1297: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1298: fnd_message.set_token('VIEW', 'CVSCHOOLCONTACT ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1299: fnd_file.put_line(fnd_file.log, fnd_message.get);
1300:
1301: -- Get all the reocords from interface table with status = 'N'
1302: FOR new_schcntct_rec IN int_cvschcnt_cur LOOP
1303:

Line 1311: fnd_message.set_name('IGS','IGS_UC_SCH_SITE_CNTCT_PROC');

1307: old_schsite_cnt_rec := NULL;
1308:
1309:
1310: -- log record level processing message
1311: fnd_message.set_name('IGS','IGS_UC_SCH_SITE_CNTCT_PROC');
1312: fnd_message.set_token('SCH', TO_CHAR(new_schcntct_rec.school));
1313: fnd_message.set_token('SITE', new_schcntct_rec.sitecode);
1314: fnd_message.set_token('CONTACT', TO_CHAR(new_schcntct_rec.contactcode));
1315: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 1312: fnd_message.set_token('SCH', TO_CHAR(new_schcntct_rec.school));

1308:
1309:
1310: -- log record level processing message
1311: fnd_message.set_name('IGS','IGS_UC_SCH_SITE_CNTCT_PROC');
1312: fnd_message.set_token('SCH', TO_CHAR(new_schcntct_rec.school));
1313: fnd_message.set_token('SITE', new_schcntct_rec.sitecode);
1314: fnd_message.set_token('CONTACT', TO_CHAR(new_schcntct_rec.contactcode));
1315: fnd_file.put_line(fnd_file.log, fnd_message.get);
1316:

Line 1313: fnd_message.set_token('SITE', new_schcntct_rec.sitecode);

1309:
1310: -- log record level processing message
1311: fnd_message.set_name('IGS','IGS_UC_SCH_SITE_CNTCT_PROC');
1312: fnd_message.set_token('SCH', TO_CHAR(new_schcntct_rec.school));
1313: fnd_message.set_token('SITE', new_schcntct_rec.sitecode);
1314: fnd_message.set_token('CONTACT', TO_CHAR(new_schcntct_rec.contactcode));
1315: fnd_file.put_line(fnd_file.log, fnd_message.get);
1316:
1317:

Line 1314: fnd_message.set_token('CONTACT', TO_CHAR(new_schcntct_rec.contactcode));

1310: -- log record level processing message
1311: fnd_message.set_name('IGS','IGS_UC_SCH_SITE_CNTCT_PROC');
1312: fnd_message.set_token('SCH', TO_CHAR(new_schcntct_rec.school));
1313: fnd_message.set_token('SITE', new_schcntct_rec.sitecode);
1314: fnd_message.set_token('CONTACT', TO_CHAR(new_schcntct_rec.contactcode));
1315: fnd_file.put_line(fnd_file.log, fnd_message.get);
1316:
1317:
1318: -- assigning default to sitecode and assigning to same record variable for further processing.

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

1311: fnd_message.set_name('IGS','IGS_UC_SCH_SITE_CNTCT_PROC');
1312: fnd_message.set_token('SCH', TO_CHAR(new_schcntct_rec.school));
1313: fnd_message.set_token('SITE', new_schcntct_rec.sitecode);
1314: fnd_message.set_token('CONTACT', TO_CHAR(new_schcntct_rec.contactcode));
1315: fnd_file.put_line(fnd_file.log, fnd_message.get);
1316:
1317:
1318: -- assigning default to sitecode and assigning to same record variable for further processing.
1319: new_schcntct_rec.sitecode := NVL(new_schcntct_rec.sitecode, 'A') ;

Line 1490: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

1486: EXCEPTION
1487: -- Process should continue with processing of other view data
1488: WHEN OTHERS THEN
1489: ROLLBACK;
1490: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1491: fnd_message.set_token('VIEW', 'CVSCHOOLCONTACT'||' - '||SQLERRM);
1492: fnd_file.put_line(fnd_file.log, fnd_message.get);
1493: END process_cvschoolcontact ;
1494:

Line 1491: fnd_message.set_token('VIEW', 'CVSCHOOLCONTACT'||' - '||SQLERRM);

1487: -- Process should continue with processing of other view data
1488: WHEN OTHERS THEN
1489: ROLLBACK;
1490: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1491: fnd_message.set_token('VIEW', 'CVSCHOOLCONTACT'||' - '||SQLERRM);
1492: fnd_file.put_line(fnd_file.log, fnd_message.get);
1493: END process_cvschoolcontact ;
1494:
1495:

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

1488: WHEN OTHERS THEN
1489: ROLLBACK;
1490: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1491: fnd_message.set_token('VIEW', 'CVSCHOOLCONTACT'||' - '||SQLERRM);
1492: fnd_file.put_line(fnd_file.log, fnd_message.get);
1493: END process_cvschoolcontact ;
1494:
1495:
1496:

Line 1555: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

1551: -- initialize variables
1552: g_success_rec_cnt := 0;
1553: g_error_rec_cnt := 0;
1554:
1555: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1556: fnd_message.set_token('VIEW', 'CVCOURSE ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1557: fnd_file.put_line(fnd_file.log, fnd_message.get);
1558:
1559: -- Get all the reocords from interface table with status = 'N'

Line 1556: fnd_message.set_token('VIEW', 'CVCOURSE ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

1552: g_success_rec_cnt := 0;
1553: g_error_rec_cnt := 0;
1554:
1555: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1556: fnd_message.set_token('VIEW', 'CVCOURSE ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1557: fnd_file.put_line(fnd_file.log, fnd_message.get);
1558:
1559: -- Get all the reocords from interface table with status = 'N'
1560: FOR new_cvcrse_rec IN int_cvcrse_cur LOOP

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

1553: g_error_rec_cnt := 0;
1554:
1555: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1556: fnd_message.set_token('VIEW', 'CVCOURSE ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1557: fnd_file.put_line(fnd_file.log, fnd_message.get);
1558:
1559: -- Get all the reocords from interface table with status = 'N'
1560: FOR new_cvcrse_rec IN int_cvcrse_cur LOOP
1561:

Line 1569: fnd_message.set_name('IGS','IGS_UC_INST_CRS_CAMP_PROC');

1565: old_crse_rec := NULL;
1566:
1567:
1568: -- log record level processing message
1569: fnd_message.set_name('IGS','IGS_UC_INST_CRS_CAMP_PROC');
1570: fnd_message.set_token('INST', new_cvcrse_rec.inst);
1571: fnd_message.set_token('COURSE', new_cvcrse_rec.course);
1572: fnd_message.set_token('CAMPUS', new_cvcrse_rec.campus);
1573: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 1570: fnd_message.set_token('INST', new_cvcrse_rec.inst);

1566:
1567:
1568: -- log record level processing message
1569: fnd_message.set_name('IGS','IGS_UC_INST_CRS_CAMP_PROC');
1570: fnd_message.set_token('INST', new_cvcrse_rec.inst);
1571: fnd_message.set_token('COURSE', new_cvcrse_rec.course);
1572: fnd_message.set_token('CAMPUS', new_cvcrse_rec.campus);
1573: fnd_file.put_line(fnd_file.log, fnd_message.get);
1574:

Line 1571: fnd_message.set_token('COURSE', new_cvcrse_rec.course);

1567:
1568: -- log record level processing message
1569: fnd_message.set_name('IGS','IGS_UC_INST_CRS_CAMP_PROC');
1570: fnd_message.set_token('INST', new_cvcrse_rec.inst);
1571: fnd_message.set_token('COURSE', new_cvcrse_rec.course);
1572: fnd_message.set_token('CAMPUS', new_cvcrse_rec.campus);
1573: fnd_file.put_line(fnd_file.log, fnd_message.get);
1574:
1575:

Line 1572: fnd_message.set_token('CAMPUS', new_cvcrse_rec.campus);

1568: -- log record level processing message
1569: fnd_message.set_name('IGS','IGS_UC_INST_CRS_CAMP_PROC');
1570: fnd_message.set_token('INST', new_cvcrse_rec.inst);
1571: fnd_message.set_token('COURSE', new_cvcrse_rec.course);
1572: fnd_message.set_token('CAMPUS', new_cvcrse_rec.campus);
1573: fnd_file.put_line(fnd_file.log, fnd_message.get);
1574:
1575:
1576: -- validate mandatory fields have values.

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

1569: fnd_message.set_name('IGS','IGS_UC_INST_CRS_CAMP_PROC');
1570: fnd_message.set_token('INST', new_cvcrse_rec.inst);
1571: fnd_message.set_token('COURSE', new_cvcrse_rec.course);
1572: fnd_message.set_token('CAMPUS', new_cvcrse_rec.campus);
1573: fnd_file.put_line(fnd_file.log, fnd_message.get);
1574:
1575:
1576: -- validate mandatory fields have values.
1577: IF new_cvcrse_rec.course IS NULL OR new_cvcrse_rec.campus IS NULL OR new_cvcrse_rec.inst IS NULL THEN

Line 1846: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

1842: EXCEPTION
1843: -- Process should continue with processing of other view data
1844: WHEN OTHERS THEN
1845: ROLLBACK;
1846: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1847: fnd_message.set_token('VIEW', 'CVCOURSE'||' - '||SQLERRM);
1848: fnd_file.put_line(fnd_file.log, fnd_message.get);
1849: END process_cvcourse ;
1850:

Line 1847: fnd_message.set_token('VIEW', 'CVCOURSE'||' - '||SQLERRM);

1843: -- Process should continue with processing of other view data
1844: WHEN OTHERS THEN
1845: ROLLBACK;
1846: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1847: fnd_message.set_token('VIEW', 'CVCOURSE'||' - '||SQLERRM);
1848: fnd_file.put_line(fnd_file.log, fnd_message.get);
1849: END process_cvcourse ;
1850:
1851:

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

1844: WHEN OTHERS THEN
1845: ROLLBACK;
1846: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
1847: fnd_message.set_token('VIEW', 'CVCOURSE'||' - '||SQLERRM);
1848: fnd_file.put_line(fnd_file.log, fnd_message.get);
1849: END process_cvcourse ;
1850:
1851:
1852:

Line 1891: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

1887: -- initialize variables
1888: g_success_rec_cnt := 0;
1889: g_error_rec_cnt := 0;
1890:
1891: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1892: fnd_message.set_token('VIEW', 'UVCOURSE ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1893: fnd_file.put_line(fnd_file.log, fnd_message.get);
1894:
1895: -- Get all the reocords from interface table with status = 'N'

Line 1892: fnd_message.set_token('VIEW', 'UVCOURSE ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

1888: g_success_rec_cnt := 0;
1889: g_error_rec_cnt := 0;
1890:
1891: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1892: fnd_message.set_token('VIEW', 'UVCOURSE ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1893: fnd_file.put_line(fnd_file.log, fnd_message.get);
1894:
1895: -- Get all the reocords from interface table with status = 'N'
1896: FOR new_uvcrse_rec IN int_uvcrse_cur LOOP

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

1889: g_error_rec_cnt := 0;
1890:
1891: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
1892: fnd_message.set_token('VIEW', 'UVCOURSE ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
1893: fnd_file.put_line(fnd_file.log, fnd_message.get);
1894:
1895: -- Get all the reocords from interface table with status = 'N'
1896: FOR new_uvcrse_rec IN int_uvcrse_cur LOOP
1897:

Line 1905: fnd_message.set_name('IGS','IGS_UC_CRS_CAMP_PROC');

1901: old_ucrse_rec := NULL;
1902:
1903:
1904: -- log record level processing - Course and campus
1905: fnd_message.set_name('IGS','IGS_UC_CRS_CAMP_PROC');
1906: fnd_message.set_token('COURSE', new_uvcrse_rec.course);
1907: fnd_message.set_token('CAMPUS', new_uvcrse_rec.campus);
1908: fnd_file.put_line(fnd_file.log, fnd_message.get);
1909:

Line 1906: fnd_message.set_token('COURSE', new_uvcrse_rec.course);

1902:
1903:
1904: -- log record level processing - Course and campus
1905: fnd_message.set_name('IGS','IGS_UC_CRS_CAMP_PROC');
1906: fnd_message.set_token('COURSE', new_uvcrse_rec.course);
1907: fnd_message.set_token('CAMPUS', new_uvcrse_rec.campus);
1908: fnd_file.put_line(fnd_file.log, fnd_message.get);
1909:
1910: -- validate mandatory fields have values.

Line 1907: fnd_message.set_token('CAMPUS', new_uvcrse_rec.campus);

1903:
1904: -- log record level processing - Course and campus
1905: fnd_message.set_name('IGS','IGS_UC_CRS_CAMP_PROC');
1906: fnd_message.set_token('COURSE', new_uvcrse_rec.course);
1907: fnd_message.set_token('CAMPUS', new_uvcrse_rec.campus);
1908: fnd_file.put_line(fnd_file.log, fnd_message.get);
1909:
1910: -- validate mandatory fields have values.
1911: IF new_uvcrse_rec.course IS NULL OR new_uvcrse_rec.campus IS NULL THEN

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

1904: -- log record level processing - Course and campus
1905: fnd_message.set_name('IGS','IGS_UC_CRS_CAMP_PROC');
1906: fnd_message.set_token('COURSE', new_uvcrse_rec.course);
1907: fnd_message.set_token('CAMPUS', new_uvcrse_rec.campus);
1908: fnd_file.put_line(fnd_file.log, fnd_message.get);
1909:
1910: -- validate mandatory fields have values.
1911: IF new_uvcrse_rec.course IS NULL OR new_uvcrse_rec.campus IS NULL THEN
1912: g_error_code := '1037';

Line 2040: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

2036: EXCEPTION
2037: -- Process should continue with processing of other view data
2038: WHEN OTHERS THEN
2039: ROLLBACK;
2040: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
2041: fnd_message.set_token('VIEW', 'UVCOURSE'||' - '||SQLERRM);
2042: fnd_file.put_line(fnd_file.log, fnd_message.get);
2043: END process_uvcourse ;
2044:

Line 2041: fnd_message.set_token('VIEW', 'UVCOURSE'||' - '||SQLERRM);

2037: -- Process should continue with processing of other view data
2038: WHEN OTHERS THEN
2039: ROLLBACK;
2040: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
2041: fnd_message.set_token('VIEW', 'UVCOURSE'||' - '||SQLERRM);
2042: fnd_file.put_line(fnd_file.log, fnd_message.get);
2043: END process_uvcourse ;
2044:
2045:

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

2038: WHEN OTHERS THEN
2039: ROLLBACK;
2040: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
2041: fnd_message.set_token('VIEW', 'UVCOURSE'||' - '||SQLERRM);
2042: fnd_file.put_line(fnd_file.log, fnd_message.get);
2043: END process_uvcourse ;
2044:
2045:
2046: PROCEDURE process_uvcoursekeyword IS

Line 2146: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');

2142: g_success_rec_cnt := 0;
2143: g_error_rec_cnt := 0;
2144: l_set_level_success := 'Y';
2145:
2146: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
2147: fnd_message.set_token('VIEW', 'UVCOURSEKEYWORD ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2148: fnd_file.put_line(fnd_file.log, fnd_message.get);
2149:
2150: -- Setting Error code to NULL for 'N' status records.

Line 2147: fnd_message.set_token('VIEW', 'UVCOURSEKEYWORD ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

2143: g_error_rec_cnt := 0;
2144: l_set_level_success := 'Y';
2145:
2146: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
2147: fnd_message.set_token('VIEW', 'UVCOURSEKEYWORD ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2148: fnd_file.put_line(fnd_file.log, fnd_message.get);
2149:
2150: -- Setting Error code to NULL for 'N' status records.
2151: -- This is done to support the logic for processing as a combined set whereby the entire set is

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

2144: l_set_level_success := 'Y';
2145:
2146: fnd_message.set_name('IGS','IGS_UC_PROC_VIEW_DATA');
2147: fnd_message.set_token('VIEW', 'UVCOURSEKEYWORD ON '||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
2148: fnd_file.put_line(fnd_file.log, fnd_message.get);
2149:
2150: -- Setting Error code to NULL for 'N' status records.
2151: -- This is done to support the logic for processing as a combined set whereby the entire set is
2152: -- marked as error if atleast one rec in the set is invalid.

Line 2162: fnd_message.set_name('IGS','IGS_UC_CRS_CAMP_OPT_PROC');

2158: FOR int_crseops_rec IN int_crseops_cur LOOP
2159:
2160: l_set_level_success := 'Y'; -- initializing to Yes for each set
2161: -- log record level processing message
2162: fnd_message.set_name('IGS','IGS_UC_CRS_CAMP_OPT_PROC');
2163: fnd_message.set_token('COURSE', int_crseops_rec.course);
2164: fnd_message.set_token('CAMPUS', int_crseops_rec.campus);
2165: fnd_message.set_token('OPTION', int_crseops_rec.optioncode);
2166: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 2163: fnd_message.set_token('COURSE', int_crseops_rec.course);

2159:
2160: l_set_level_success := 'Y'; -- initializing to Yes for each set
2161: -- log record level processing message
2162: fnd_message.set_name('IGS','IGS_UC_CRS_CAMP_OPT_PROC');
2163: fnd_message.set_token('COURSE', int_crseops_rec.course);
2164: fnd_message.set_token('CAMPUS', int_crseops_rec.campus);
2165: fnd_message.set_token('OPTION', int_crseops_rec.optioncode);
2166: fnd_file.put_line(fnd_file.log, fnd_message.get);
2167:

Line 2164: fnd_message.set_token('CAMPUS', int_crseops_rec.campus);

2160: l_set_level_success := 'Y'; -- initializing to Yes for each set
2161: -- log record level processing message
2162: fnd_message.set_name('IGS','IGS_UC_CRS_CAMP_OPT_PROC');
2163: fnd_message.set_token('COURSE', int_crseops_rec.course);
2164: fnd_message.set_token('CAMPUS', int_crseops_rec.campus);
2165: fnd_message.set_token('OPTION', int_crseops_rec.optioncode);
2166: fnd_file.put_line(fnd_file.log, fnd_message.get);
2167:
2168: -- Check whether any correspoinding records exist in UCAS table.

Line 2165: fnd_message.set_token('OPTION', int_crseops_rec.optioncode);

2161: -- log record level processing message
2162: fnd_message.set_name('IGS','IGS_UC_CRS_CAMP_OPT_PROC');
2163: fnd_message.set_token('COURSE', int_crseops_rec.course);
2164: fnd_message.set_token('CAMPUS', int_crseops_rec.campus);
2165: fnd_message.set_token('OPTION', int_crseops_rec.optioncode);
2166: fnd_file.put_line(fnd_file.log, fnd_message.get);
2167:
2168: -- Check whether any correspoinding records exist in UCAS table.
2169: -- IF exists delete old keyword records for the combination.

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

2162: fnd_message.set_name('IGS','IGS_UC_CRS_CAMP_OPT_PROC');
2163: fnd_message.set_token('COURSE', int_crseops_rec.course);
2164: fnd_message.set_token('CAMPUS', int_crseops_rec.campus);
2165: fnd_message.set_token('OPTION', int_crseops_rec.optioncode);
2166: fnd_file.put_line(fnd_file.log, fnd_message.get);
2167:
2168: -- Check whether any correspoinding records exist in UCAS table.
2169: -- IF exists delete old keyword records for the combination.
2170: FOR old_crskwd_del_rec IN old_crskwd_del_cur(int_crseops_rec.course,

Line 2191: fnd_message.set_name('IGS','IGS_UC_CRSE_KEYWORD_PROC');

2187: old_crsekwd_rec := NULL;
2188: l_crse_keyword_id := NULL;
2189:
2190: -- log record level processing message
2191: fnd_message.set_name('IGS','IGS_UC_CRSE_KEYWORD_PROC');
2192: fnd_message.set_token('KEYWORD', new_ucrsekwd_rec.keyword);
2193: fnd_file.put_line(fnd_file.log, ' ' || fnd_message.get);
2194:
2195: -- validate mandatory fields have values.

Line 2192: fnd_message.set_token('KEYWORD', new_ucrsekwd_rec.keyword);

2188: l_crse_keyword_id := NULL;
2189:
2190: -- log record level processing message
2191: fnd_message.set_name('IGS','IGS_UC_CRSE_KEYWORD_PROC');
2192: fnd_message.set_token('KEYWORD', new_ucrsekwd_rec.keyword);
2193: fnd_file.put_line(fnd_file.log, ' ' || fnd_message.get);
2194:
2195: -- validate mandatory fields have values.
2196: IF new_ucrsekwd_rec.course IS NULL OR new_ucrsekwd_rec.campus IS NULL OR new_ucrsekwd_rec.optioncode IS NULL THEN

Line 2193: fnd_file.put_line(fnd_file.log, ' ' || fnd_message.get);

2189:
2190: -- log record level processing message
2191: fnd_message.set_name('IGS','IGS_UC_CRSE_KEYWORD_PROC');
2192: fnd_message.set_token('KEYWORD', new_ucrsekwd_rec.keyword);
2193: fnd_file.put_line(fnd_file.log, ' ' || fnd_message.get);
2194:
2195: -- validate mandatory fields have values.
2196: IF new_ucrsekwd_rec.course IS NULL OR new_ucrsekwd_rec.campus IS NULL OR new_ucrsekwd_rec.optioncode IS NULL THEN
2197: g_error_code := '1037';

Line 2400: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');

2396: EXCEPTION
2397: -- Process should continue with processing of other view data
2398: WHEN OTHERS THEN
2399: ROLLBACK;
2400: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
2401: fnd_message.set_token('VIEW', 'UVCOURSEKEYWORD'||' - '||SQLERRM);
2402: fnd_file.put_line(fnd_file.log, fnd_message.get);
2403: END process_uvcoursekeyword ;
2404:

Line 2401: fnd_message.set_token('VIEW', 'UVCOURSEKEYWORD'||' - '||SQLERRM);

2397: -- Process should continue with processing of other view data
2398: WHEN OTHERS THEN
2399: ROLLBACK;
2400: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
2401: fnd_message.set_token('VIEW', 'UVCOURSEKEYWORD'||' - '||SQLERRM);
2402: fnd_file.put_line(fnd_file.log, fnd_message.get);
2403: END process_uvcoursekeyword ;
2404:
2405: END igs_uc_proc_com_inst_data;

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

2398: WHEN OTHERS THEN
2399: ROLLBACK;
2400: fnd_message.set_name('IGS','IGS_UC_ERROR_PROC_DATA');
2401: fnd_message.set_token('VIEW', 'UVCOURSEKEYWORD'||' - '||SQLERRM);
2402: fnd_file.put_line(fnd_file.log, fnd_message.get);
2403: END process_uvcoursekeyword ;
2404:
2405: END igs_uc_proc_com_inst_data;