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

Line 100: fnd_message.set_name('IGS','IGS_HE_DLHE_QUAL_PERIOD');

96: CLOSE c_qual_dets;
97:
98:
99: -- Report the Qualifying period details in the log file
100: fnd_message.set_name('IGS','IGS_HE_DLHE_QUAL_PERIOD');
101: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
102: fnd_message.set_token('DESC',l_qual_dets.qual_period_desc);
103: fnd_message.set_token('TYPE',l_qual_dets.qual_period_type);
104: fnd_file.put_line(fnd_file.log,fnd_message.get);

Line 101: fnd_message.set_token('QUAL_PERIOD',p_qual_period);

97:
98:
99: -- Report the Qualifying period details in the log file
100: fnd_message.set_name('IGS','IGS_HE_DLHE_QUAL_PERIOD');
101: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
102: fnd_message.set_token('DESC',l_qual_dets.qual_period_desc);
103: fnd_message.set_token('TYPE',l_qual_dets.qual_period_type);
104: fnd_file.put_line(fnd_file.log,fnd_message.get);
105:

Line 102: fnd_message.set_token('DESC',l_qual_dets.qual_period_desc);

98:
99: -- Report the Qualifying period details in the log file
100: fnd_message.set_name('IGS','IGS_HE_DLHE_QUAL_PERIOD');
101: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
102: fnd_message.set_token('DESC',l_qual_dets.qual_period_desc);
103: fnd_message.set_token('TYPE',l_qual_dets.qual_period_type);
104: fnd_file.put_line(fnd_file.log,fnd_message.get);
105:
106:

Line 103: fnd_message.set_token('TYPE',l_qual_dets.qual_period_type);

99: -- Report the Qualifying period details in the log file
100: fnd_message.set_name('IGS','IGS_HE_DLHE_QUAL_PERIOD');
101: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
102: fnd_message.set_token('DESC',l_qual_dets.qual_period_desc);
103: fnd_message.set_token('TYPE',l_qual_dets.qual_period_type);
104: fnd_file.put_line(fnd_file.log,fnd_message.get);
105:
106:
107: --Validate Parameters

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

100: fnd_message.set_name('IGS','IGS_HE_DLHE_QUAL_PERIOD');
101: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
102: fnd_message.set_token('DESC',l_qual_dets.qual_period_desc);
103: fnd_message.set_token('TYPE',l_qual_dets.qual_period_type);
104: fnd_file.put_line(fnd_file.log,fnd_message.get);
105:
106:
107: --Validate Parameters
108: IF l_qual_dets.qual_period_type = 'R' AND p_census_date IS NOT NULL THEN

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

107: --Validate Parameters
108: IF l_qual_dets.qual_period_type = 'R' AND p_census_date IS NOT NULL THEN
109:
110: -- Set warning for 'R' qual type and census date
111: fnd_message.set_name('IGS','IGS_HE_DLHE_CENSUS');
112: fnd_file.put_line(fnd_file.log, fnd_message.get);
113:
114: ELSIF l_qual_dets.qual_period_type = 'L' AND p_census_date IS NULL THEN
115:

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

108: IF l_qual_dets.qual_period_type = 'R' AND p_census_date IS NOT NULL THEN
109:
110: -- Set warning for 'R' qual type and census date
111: fnd_message.set_name('IGS','IGS_HE_DLHE_CENSUS');
112: fnd_file.put_line(fnd_file.log, fnd_message.get);
113:
114: ELSIF l_qual_dets.qual_period_type = 'L' AND p_census_date IS NULL THEN
115:
116: -- Set error for 'L' qual type and census date and exit

Line 117: fnd_message.set_name('IGS','IGS_HE_DLHE_NO_CENSUS');

113:
114: ELSIF l_qual_dets.qual_period_type = 'L' AND p_census_date IS NULL THEN
115:
116: -- Set error for 'L' qual type and census date and exit
117: fnd_message.set_name('IGS','IGS_HE_DLHE_NO_CENSUS');
118: fnd_file.put_line(fnd_file.log, fnd_message.get);
119: errbuf := fnd_message.get ;
120: retcode := 2;
121: RETURN;

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

114: ELSIF l_qual_dets.qual_period_type = 'L' AND p_census_date IS NULL THEN
115:
116: -- Set error for 'L' qual type and census date and exit
117: fnd_message.set_name('IGS','IGS_HE_DLHE_NO_CENSUS');
118: fnd_file.put_line(fnd_file.log, fnd_message.get);
119: errbuf := fnd_message.get ;
120: retcode := 2;
121: RETURN;
122:

Line 119: errbuf := fnd_message.get ;

115:
116: -- Set error for 'L' qual type and census date and exit
117: fnd_message.set_name('IGS','IGS_HE_DLHE_NO_CENSUS');
118: fnd_file.put_line(fnd_file.log, fnd_message.get);
119: errbuf := fnd_message.get ;
120: retcode := 2;
121: RETURN;
122:
123: END IF;

Line 427: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

423: CLOSE c_dlhe_rec;
424: END IF;
425:
426: ROLLBACK;
427: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
428: Fnd_Message.Set_Token('NAME','igs_he_import_popdlhe.import_popdlhe_to_oss - ' || SQLERRM);
429: fnd_file.put_line(fnd_file.log, fnd_message.get);
430: errbuf := fnd_message.get ;
431: retcode := 2;

Line 428: Fnd_Message.Set_Token('NAME','igs_he_import_popdlhe.import_popdlhe_to_oss - ' || SQLERRM);

424: END IF;
425:
426: ROLLBACK;
427: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
428: Fnd_Message.Set_Token('NAME','igs_he_import_popdlhe.import_popdlhe_to_oss - ' || SQLERRM);
429: fnd_file.put_line(fnd_file.log, fnd_message.get);
430: errbuf := fnd_message.get ;
431: retcode := 2;
432:

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

425:
426: ROLLBACK;
427: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
428: Fnd_Message.Set_Token('NAME','igs_he_import_popdlhe.import_popdlhe_to_oss - ' || SQLERRM);
429: fnd_file.put_line(fnd_file.log, fnd_message.get);
430: errbuf := fnd_message.get ;
431: retcode := 2;
432:
433: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

Line 430: errbuf := fnd_message.get ;

426: ROLLBACK;
427: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
428: Fnd_Message.Set_Token('NAME','igs_he_import_popdlhe.import_popdlhe_to_oss - ' || SQLERRM);
429: fnd_file.put_line(fnd_file.log, fnd_message.get);
430: errbuf := fnd_message.get ;
431: retcode := 2;
432:
433: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
434:

Line 529: Fnd_Message.Set_Name('IGS','IGS_HE_DLHE_FAIL_FIELD_DERIVE');

525: END IF;
526: l_error_cnt := l_error_cnt + 1;
527: END IF;
528:
529: Fnd_Message.Set_Name('IGS','IGS_HE_DLHE_FAIL_FIELD_DERIVE');
530: Fnd_Message.Set_Token('FIELD',l_error_message);
531: Fnd_Message.Set_Token('POPDLHE_ID',p_popdlhe_dtls.popdlhe_id);
532: Fnd_Message.Set_Token('HUSID',p_popdlhe_dtls.husid);
533: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 530: Fnd_Message.Set_Token('FIELD',l_error_message);

526: l_error_cnt := l_error_cnt + 1;
527: END IF;
528:
529: Fnd_Message.Set_Name('IGS','IGS_HE_DLHE_FAIL_FIELD_DERIVE');
530: Fnd_Message.Set_Token('FIELD',l_error_message);
531: Fnd_Message.Set_Token('POPDLHE_ID',p_popdlhe_dtls.popdlhe_id);
532: Fnd_Message.Set_Token('HUSID',p_popdlhe_dtls.husid);
533: fnd_file.put_line(fnd_file.log, fnd_message.get);
534:

Line 531: Fnd_Message.Set_Token('POPDLHE_ID',p_popdlhe_dtls.popdlhe_id);

527: END IF;
528:
529: Fnd_Message.Set_Name('IGS','IGS_HE_DLHE_FAIL_FIELD_DERIVE');
530: Fnd_Message.Set_Token('FIELD',l_error_message);
531: Fnd_Message.Set_Token('POPDLHE_ID',p_popdlhe_dtls.popdlhe_id);
532: Fnd_Message.Set_Token('HUSID',p_popdlhe_dtls.husid);
533: fnd_file.put_line(fnd_file.log, fnd_message.get);
534:
535: RETURN FALSE;

Line 532: Fnd_Message.Set_Token('HUSID',p_popdlhe_dtls.husid);

528:
529: Fnd_Message.Set_Name('IGS','IGS_HE_DLHE_FAIL_FIELD_DERIVE');
530: Fnd_Message.Set_Token('FIELD',l_error_message);
531: Fnd_Message.Set_Token('POPDLHE_ID',p_popdlhe_dtls.popdlhe_id);
532: Fnd_Message.Set_Token('HUSID',p_popdlhe_dtls.husid);
533: fnd_file.put_line(fnd_file.log, fnd_message.get);
534:
535: RETURN FALSE;
536: END IF;

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

529: Fnd_Message.Set_Name('IGS','IGS_HE_DLHE_FAIL_FIELD_DERIVE');
530: Fnd_Message.Set_Token('FIELD',l_error_message);
531: Fnd_Message.Set_Token('POPDLHE_ID',p_popdlhe_dtls.popdlhe_id);
532: Fnd_Message.Set_Token('HUSID',p_popdlhe_dtls.husid);
533: fnd_file.put_line(fnd_file.log, fnd_message.get);
534:
535: RETURN FALSE;
536: END IF;
537:

Line 540: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

536: END IF;
537:
538: EXCEPTION
539: WHEN OTHERS THEN
540: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
541: Fnd_Message.Set_Token('NAME','igs_he_import_popdlhe.validate_popdlhe - ' ||SQLERRM);
542: fnd_file.put_line(fnd_file.log, fnd_message.get);
543: App_Exception.Raise_Exception;
544:

Line 541: Fnd_Message.Set_Token('NAME','igs_he_import_popdlhe.validate_popdlhe - ' ||SQLERRM);

537:
538: EXCEPTION
539: WHEN OTHERS THEN
540: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
541: Fnd_Message.Set_Token('NAME','igs_he_import_popdlhe.validate_popdlhe - ' ||SQLERRM);
542: fnd_file.put_line(fnd_file.log, fnd_message.get);
543: App_Exception.Raise_Exception;
544:
545: END validate_popdlhe;

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

538: EXCEPTION
539: WHEN OTHERS THEN
540: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
541: Fnd_Message.Set_Token('NAME','igs_he_import_popdlhe.validate_popdlhe - ' ||SQLERRM);
542: fnd_file.put_line(fnd_file.log, fnd_message.get);
543: App_Exception.Raise_Exception;
544:
545: END validate_popdlhe;
546:

Line 600: Fnd_Message.Set_Name('IGS','IGS_HE_DLHE_FAIL_PERSON_DERIVE');

596: END IF;
597:
598: -- At this stage we have not found person id
599: -- return NULL and log message
600: Fnd_Message.Set_Name('IGS','IGS_HE_DLHE_FAIL_PERSON_DERIVE');
601: Fnd_Message.Set_Token('POPDLHE_ID',p_popdlhe_dtls.popdlhe_id);
602: Fnd_Message.Set_Token('HUSID',p_popdlhe_dtls.husid);
603: fnd_file.put_line(fnd_file.log, fnd_message.get);
604:

Line 601: Fnd_Message.Set_Token('POPDLHE_ID',p_popdlhe_dtls.popdlhe_id);

597:
598: -- At this stage we have not found person id
599: -- return NULL and log message
600: Fnd_Message.Set_Name('IGS','IGS_HE_DLHE_FAIL_PERSON_DERIVE');
601: Fnd_Message.Set_Token('POPDLHE_ID',p_popdlhe_dtls.popdlhe_id);
602: Fnd_Message.Set_Token('HUSID',p_popdlhe_dtls.husid);
603: fnd_file.put_line(fnd_file.log, fnd_message.get);
604:
605: RETURN NULL;

Line 602: Fnd_Message.Set_Token('HUSID',p_popdlhe_dtls.husid);

598: -- At this stage we have not found person id
599: -- return NULL and log message
600: Fnd_Message.Set_Name('IGS','IGS_HE_DLHE_FAIL_PERSON_DERIVE');
601: Fnd_Message.Set_Token('POPDLHE_ID',p_popdlhe_dtls.popdlhe_id);
602: Fnd_Message.Set_Token('HUSID',p_popdlhe_dtls.husid);
603: fnd_file.put_line(fnd_file.log, fnd_message.get);
604:
605: RETURN NULL;
606:

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

599: -- return NULL and log message
600: Fnd_Message.Set_Name('IGS','IGS_HE_DLHE_FAIL_PERSON_DERIVE');
601: Fnd_Message.Set_Token('POPDLHE_ID',p_popdlhe_dtls.popdlhe_id);
602: Fnd_Message.Set_Token('HUSID',p_popdlhe_dtls.husid);
603: fnd_file.put_line(fnd_file.log, fnd_message.get);
604:
605: RETURN NULL;
606:
607:

Line 610: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

606:
607:
608: EXCEPTION
609: WHEN OTHERS THEN
610: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
611: Fnd_Message.Set_Token('NAME','igs_he_import_popdlhe.get_person_id - ' ||SQLERRM);
612: fnd_file.put_line(fnd_file.log, fnd_message.get);
613: App_Exception.Raise_Exception;
614:

Line 611: Fnd_Message.Set_Token('NAME','igs_he_import_popdlhe.get_person_id - ' ||SQLERRM);

607:
608: EXCEPTION
609: WHEN OTHERS THEN
610: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
611: Fnd_Message.Set_Token('NAME','igs_he_import_popdlhe.get_person_id - ' ||SQLERRM);
612: fnd_file.put_line(fnd_file.log, fnd_message.get);
613: App_Exception.Raise_Exception;
614:
615: END get_person_id;

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

608: EXCEPTION
609: WHEN OTHERS THEN
610: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
611: Fnd_Message.Set_Token('NAME','igs_he_import_popdlhe.get_person_id - ' ||SQLERRM);
612: fnd_file.put_line(fnd_file.log, fnd_message.get);
613: App_Exception.Raise_Exception;
614:
615: END get_person_id;
616:

Line 636: fnd_message.set_name('IGS','IGS_HE_DLHE_IMP_IDENT_POP');

632: *******************************************************************/
633: BEGIN
634:
635: -- Report the total number of DLHE records processed
636: fnd_message.set_name('IGS','IGS_HE_DLHE_IMP_IDENT_POP');
637: fnd_message.set_token('TOTAL_DLHE', p_total_dlhe_cnt);
638: fnd_message.set_token('RETURN_NAME',p_return_name);
639: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
640: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 637: fnd_message.set_token('TOTAL_DLHE', p_total_dlhe_cnt);

633: BEGIN
634:
635: -- Report the total number of DLHE records processed
636: fnd_message.set_name('IGS','IGS_HE_DLHE_IMP_IDENT_POP');
637: fnd_message.set_token('TOTAL_DLHE', p_total_dlhe_cnt);
638: fnd_message.set_token('RETURN_NAME',p_return_name);
639: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
640: fnd_file.put_line(fnd_file.log, fnd_message.get);
641:

Line 638: fnd_message.set_token('RETURN_NAME',p_return_name);

634:
635: -- Report the total number of DLHE records processed
636: fnd_message.set_name('IGS','IGS_HE_DLHE_IMP_IDENT_POP');
637: fnd_message.set_token('TOTAL_DLHE', p_total_dlhe_cnt);
638: fnd_message.set_token('RETURN_NAME',p_return_name);
639: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
640: fnd_file.put_line(fnd_file.log, fnd_message.get);
641:
642: -- Report the total number of new student DLHE records created

Line 639: fnd_message.set_token('QUAL_PERIOD',p_qual_period);

635: -- Report the total number of DLHE records processed
636: fnd_message.set_name('IGS','IGS_HE_DLHE_IMP_IDENT_POP');
637: fnd_message.set_token('TOTAL_DLHE', p_total_dlhe_cnt);
638: fnd_message.set_token('RETURN_NAME',p_return_name);
639: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
640: fnd_file.put_line(fnd_file.log, fnd_message.get);
641:
642: -- Report the total number of new student DLHE records created
643: fnd_message.set_name('IGS','IGS_HE_DLHE_REC_CREATED');

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

636: fnd_message.set_name('IGS','IGS_HE_DLHE_IMP_IDENT_POP');
637: fnd_message.set_token('TOTAL_DLHE', p_total_dlhe_cnt);
638: fnd_message.set_token('RETURN_NAME',p_return_name);
639: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
640: fnd_file.put_line(fnd_file.log, fnd_message.get);
641:
642: -- Report the total number of new student DLHE records created
643: fnd_message.set_name('IGS','IGS_HE_DLHE_REC_CREATED');
644: fnd_message.set_token('CREATED_DLHE', p_new_dlhe_cnt);

Line 643: fnd_message.set_name('IGS','IGS_HE_DLHE_REC_CREATED');

639: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
640: fnd_file.put_line(fnd_file.log, fnd_message.get);
641:
642: -- Report the total number of new student DLHE records created
643: fnd_message.set_name('IGS','IGS_HE_DLHE_REC_CREATED');
644: fnd_message.set_token('CREATED_DLHE', p_new_dlhe_cnt);
645: fnd_message.set_token('RETURN_NAME',p_return_name);
646: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
647: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 644: fnd_message.set_token('CREATED_DLHE', p_new_dlhe_cnt);

640: fnd_file.put_line(fnd_file.log, fnd_message.get);
641:
642: -- Report the total number of new student DLHE records created
643: fnd_message.set_name('IGS','IGS_HE_DLHE_REC_CREATED');
644: fnd_message.set_token('CREATED_DLHE', p_new_dlhe_cnt);
645: fnd_message.set_token('RETURN_NAME',p_return_name);
646: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
647: fnd_file.put_line(fnd_file.log, fnd_message.get);
648:

Line 645: fnd_message.set_token('RETURN_NAME',p_return_name);

641:
642: -- Report the total number of new student DLHE records created
643: fnd_message.set_name('IGS','IGS_HE_DLHE_REC_CREATED');
644: fnd_message.set_token('CREATED_DLHE', p_new_dlhe_cnt);
645: fnd_message.set_token('RETURN_NAME',p_return_name);
646: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
647: fnd_file.put_line(fnd_file.log, fnd_message.get);
648:
649: -- Report the total number of student DLHE records updated with the current qualifying period

Line 646: fnd_message.set_token('QUAL_PERIOD',p_qual_period);

642: -- Report the total number of new student DLHE records created
643: fnd_message.set_name('IGS','IGS_HE_DLHE_REC_CREATED');
644: fnd_message.set_token('CREATED_DLHE', p_new_dlhe_cnt);
645: fnd_message.set_token('RETURN_NAME',p_return_name);
646: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
647: fnd_file.put_line(fnd_file.log, fnd_message.get);
648:
649: -- Report the total number of student DLHE records updated with the current qualifying period
650: fnd_message.set_name('IGS','IGS_HE_DLHE_REC_UPDATED');

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

643: fnd_message.set_name('IGS','IGS_HE_DLHE_REC_CREATED');
644: fnd_message.set_token('CREATED_DLHE', p_new_dlhe_cnt);
645: fnd_message.set_token('RETURN_NAME',p_return_name);
646: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
647: fnd_file.put_line(fnd_file.log, fnd_message.get);
648:
649: -- Report the total number of student DLHE records updated with the current qualifying period
650: fnd_message.set_name('IGS','IGS_HE_DLHE_REC_UPDATED');
651: fnd_message.set_token('UPDATED_DLHE', p_upd_dlhe_cnt);

Line 650: fnd_message.set_name('IGS','IGS_HE_DLHE_REC_UPDATED');

646: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
647: fnd_file.put_line(fnd_file.log, fnd_message.get);
648:
649: -- Report the total number of student DLHE records updated with the current qualifying period
650: fnd_message.set_name('IGS','IGS_HE_DLHE_REC_UPDATED');
651: fnd_message.set_token('UPDATED_DLHE', p_upd_dlhe_cnt);
652: fnd_message.set_token('RETURN_NAME',p_return_name);
653: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
654: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 651: fnd_message.set_token('UPDATED_DLHE', p_upd_dlhe_cnt);

647: fnd_file.put_line(fnd_file.log, fnd_message.get);
648:
649: -- Report the total number of student DLHE records updated with the current qualifying period
650: fnd_message.set_name('IGS','IGS_HE_DLHE_REC_UPDATED');
651: fnd_message.set_token('UPDATED_DLHE', p_upd_dlhe_cnt);
652: fnd_message.set_token('RETURN_NAME',p_return_name);
653: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
654: fnd_file.put_line(fnd_file.log, fnd_message.get);
655:

Line 652: fnd_message.set_token('RETURN_NAME',p_return_name);

648:
649: -- Report the total number of student DLHE records updated with the current qualifying period
650: fnd_message.set_name('IGS','IGS_HE_DLHE_REC_UPDATED');
651: fnd_message.set_token('UPDATED_DLHE', p_upd_dlhe_cnt);
652: fnd_message.set_token('RETURN_NAME',p_return_name);
653: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
654: fnd_file.put_line(fnd_file.log, fnd_message.get);
655:
656: -- Report the total number of students failed to satisfy the field validations

Line 653: fnd_message.set_token('QUAL_PERIOD',p_qual_period);

649: -- Report the total number of student DLHE records updated with the current qualifying period
650: fnd_message.set_name('IGS','IGS_HE_DLHE_REC_UPDATED');
651: fnd_message.set_token('UPDATED_DLHE', p_upd_dlhe_cnt);
652: fnd_message.set_token('RETURN_NAME',p_return_name);
653: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
654: fnd_file.put_line(fnd_file.log, fnd_message.get);
655:
656: -- Report the total number of students failed to satisfy the field validations
657: fnd_message.set_name('IGS','IGS_HE_DLHE_FAILED_STD');

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

650: fnd_message.set_name('IGS','IGS_HE_DLHE_REC_UPDATED');
651: fnd_message.set_token('UPDATED_DLHE', p_upd_dlhe_cnt);
652: fnd_message.set_token('RETURN_NAME',p_return_name);
653: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
654: fnd_file.put_line(fnd_file.log, fnd_message.get);
655:
656: -- Report the total number of students failed to satisfy the field validations
657: fnd_message.set_name('IGS','IGS_HE_DLHE_FAILED_STD');
658: fnd_message.set_token('FAIL_DLHE', p_fail_dlhe_cnt);

Line 657: fnd_message.set_name('IGS','IGS_HE_DLHE_FAILED_STD');

653: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
654: fnd_file.put_line(fnd_file.log, fnd_message.get);
655:
656: -- Report the total number of students failed to satisfy the field validations
657: fnd_message.set_name('IGS','IGS_HE_DLHE_FAILED_STD');
658: fnd_message.set_token('FAIL_DLHE', p_fail_dlhe_cnt);
659: fnd_message.set_token('RETURN_NAME',p_return_name);
660: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
661: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 658: fnd_message.set_token('FAIL_DLHE', p_fail_dlhe_cnt);

654: fnd_file.put_line(fnd_file.log, fnd_message.get);
655:
656: -- Report the total number of students failed to satisfy the field validations
657: fnd_message.set_name('IGS','IGS_HE_DLHE_FAILED_STD');
658: fnd_message.set_token('FAIL_DLHE', p_fail_dlhe_cnt);
659: fnd_message.set_token('RETURN_NAME',p_return_name);
660: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
661: fnd_file.put_line(fnd_file.log, fnd_message.get);
662:

Line 659: fnd_message.set_token('RETURN_NAME',p_return_name);

655:
656: -- Report the total number of students failed to satisfy the field validations
657: fnd_message.set_name('IGS','IGS_HE_DLHE_FAILED_STD');
658: fnd_message.set_token('FAIL_DLHE', p_fail_dlhe_cnt);
659: fnd_message.set_token('RETURN_NAME',p_return_name);
660: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
661: fnd_file.put_line(fnd_file.log, fnd_message.get);
662:
663: -- Report the total number of students have the student DLHE records with open qualifying period,

Line 660: fnd_message.set_token('QUAL_PERIOD',p_qual_period);

656: -- Report the total number of students failed to satisfy the field validations
657: fnd_message.set_name('IGS','IGS_HE_DLHE_FAILED_STD');
658: fnd_message.set_token('FAIL_DLHE', p_fail_dlhe_cnt);
659: fnd_message.set_token('RETURN_NAME',p_return_name);
660: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
661: fnd_file.put_line(fnd_file.log, fnd_message.get);
662:
663: -- Report the total number of students have the student DLHE records with open qualifying period,
664: -- for them not required to modify student DLHE record.

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

657: fnd_message.set_name('IGS','IGS_HE_DLHE_FAILED_STD');
658: fnd_message.set_token('FAIL_DLHE', p_fail_dlhe_cnt);
659: fnd_message.set_token('RETURN_NAME',p_return_name);
660: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
661: fnd_file.put_line(fnd_file.log, fnd_message.get);
662:
663: -- Report the total number of students have the student DLHE records with open qualifying period,
664: -- for them not required to modify student DLHE record.
665: fnd_message.set_name('IGS','IGS_HE_DLHE_NOT_MODIFIED');

Line 665: fnd_message.set_name('IGS','IGS_HE_DLHE_NOT_MODIFIED');

661: fnd_file.put_line(fnd_file.log, fnd_message.get);
662:
663: -- Report the total number of students have the student DLHE records with open qualifying period,
664: -- for them not required to modify student DLHE record.
665: fnd_message.set_name('IGS','IGS_HE_DLHE_NOT_MODIFIED');
666: fnd_message.set_token('NOT_MOD', p_not_mod_dlhe_cnt);
667: fnd_message.set_token('RETURN_NAME',p_return_name);
668: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
669: fnd_file.put_line(fnd_file.log, fnd_message.get);

Line 666: fnd_message.set_token('NOT_MOD', p_not_mod_dlhe_cnt);

662:
663: -- Report the total number of students have the student DLHE records with open qualifying period,
664: -- for them not required to modify student DLHE record.
665: fnd_message.set_name('IGS','IGS_HE_DLHE_NOT_MODIFIED');
666: fnd_message.set_token('NOT_MOD', p_not_mod_dlhe_cnt);
667: fnd_message.set_token('RETURN_NAME',p_return_name);
668: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
669: fnd_file.put_line(fnd_file.log, fnd_message.get);
670:

Line 667: fnd_message.set_token('RETURN_NAME',p_return_name);

663: -- Report the total number of students have the student DLHE records with open qualifying period,
664: -- for them not required to modify student DLHE record.
665: fnd_message.set_name('IGS','IGS_HE_DLHE_NOT_MODIFIED');
666: fnd_message.set_token('NOT_MOD', p_not_mod_dlhe_cnt);
667: fnd_message.set_token('RETURN_NAME',p_return_name);
668: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
669: fnd_file.put_line(fnd_file.log, fnd_message.get);
670:
671: EXCEPTION

Line 668: fnd_message.set_token('QUAL_PERIOD',p_qual_period);

664: -- for them not required to modify student DLHE record.
665: fnd_message.set_name('IGS','IGS_HE_DLHE_NOT_MODIFIED');
666: fnd_message.set_token('NOT_MOD', p_not_mod_dlhe_cnt);
667: fnd_message.set_token('RETURN_NAME',p_return_name);
668: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
669: fnd_file.put_line(fnd_file.log, fnd_message.get);
670:
671: EXCEPTION
672: WHEN OTHERS THEN

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

665: fnd_message.set_name('IGS','IGS_HE_DLHE_NOT_MODIFIED');
666: fnd_message.set_token('NOT_MOD', p_not_mod_dlhe_cnt);
667: fnd_message.set_token('RETURN_NAME',p_return_name);
668: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
669: fnd_file.put_line(fnd_file.log, fnd_message.get);
670:
671: EXCEPTION
672: WHEN OTHERS THEN
673: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

Line 673: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

669: fnd_file.put_line(fnd_file.log, fnd_message.get);
670:
671: EXCEPTION
672: WHEN OTHERS THEN
673: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
674: Fnd_Message.Set_Token('NAME','igs_he_import_popdlhe.log_results - ' ||SQLERRM);
675: fnd_file.put_line(fnd_file.log, fnd_message.get);
676: App_Exception.Raise_Exception;
677:

Line 674: Fnd_Message.Set_Token('NAME','igs_he_import_popdlhe.log_results - ' ||SQLERRM);

670:
671: EXCEPTION
672: WHEN OTHERS THEN
673: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
674: Fnd_Message.Set_Token('NAME','igs_he_import_popdlhe.log_results - ' ||SQLERRM);
675: fnd_file.put_line(fnd_file.log, fnd_message.get);
676: App_Exception.Raise_Exception;
677:
678: END log_results;

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

671: EXCEPTION
672: WHEN OTHERS THEN
673: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
674: Fnd_Message.Set_Token('NAME','igs_he_import_popdlhe.log_results - ' ||SQLERRM);
675: fnd_file.put_line(fnd_file.log, fnd_message.get);
676: App_Exception.Raise_Exception;
677:
678: END log_results;
679: