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

Line 75: fnd_message.set_name('IGS','IGS_HE_VERIFY_CHECK_CODES');

71:
72: BEGIN
73:
74: -- Log Header
75: fnd_message.set_name('IGS','IGS_HE_VERIFY_CHECK_CODES');
76: fnd_message.set_token('DATE',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
77: fnd_file.put_line(fnd_file.log,fnd_message.get());
78:
79: -- Loop through all field associations of selected user defined return class

Line 76: fnd_message.set_token('DATE',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

72: BEGIN
73:
74: -- Log Header
75: fnd_message.set_name('IGS','IGS_HE_VERIFY_CHECK_CODES');
76: fnd_message.set_token('DATE',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
77: fnd_file.put_line(fnd_file.log,fnd_message.get());
78:
79: -- Loop through all field associations of selected user defined return class
80: -- Need to determine every OSS value that doesn't have a corresponding HESA value

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

73:
74: -- Log Header
75: fnd_message.set_name('IGS','IGS_HE_VERIFY_CHECK_CODES');
76: fnd_message.set_token('DATE',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
77: fnd_file.put_line(fnd_file.log,fnd_message.get());
78:
79: -- Loop through all field associations of selected user defined return class
80: -- Need to determine every OSS value that doesn't have a corresponding HESA value
81: FOR l_assoc IN c_assoc LOOP

Line 164: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_CODES');

160:
161: END LOOP; -- association codes
162:
163: -- Log Summary
164: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_CODES');
165: fnd_message.set_token('MISSING',l_count);
166: fnd_file.put_line(fnd_file.log,fnd_message.get());
167:
168: EXCEPTION

Line 165: fnd_message.set_token('MISSING',l_count);

161: END LOOP; -- association codes
162:
163: -- Log Summary
164: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_CODES');
165: fnd_message.set_token('MISSING',l_count);
166: fnd_file.put_line(fnd_file.log,fnd_message.get());
167:
168: EXCEPTION
169: WHEN OTHERS THEN

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

162:
163: -- Log Summary
164: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_CODES');
165: fnd_message.set_token('MISSING',l_count);
166: fnd_file.put_line(fnd_file.log,fnd_message.get());
167:
168: EXCEPTION
169: WHEN OTHERS THEN
170:

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

183: IF c_fields%ISOPEN THEN
184: CLOSE c_fields;
185: END IF;
186:
187: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
188: Fnd_Message.Set_Token('NAME','igs_he_verify_setup_pkg.check_associations - ' || SQLERRM);
189: fnd_file.put_line(fnd_file.log, fnd_message.get);
190: App_Exception.Raise_Exception;
191:

Line 188: Fnd_Message.Set_Token('NAME','igs_he_verify_setup_pkg.check_associations - ' || SQLERRM);

184: CLOSE c_fields;
185: END IF;
186:
187: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
188: Fnd_Message.Set_Token('NAME','igs_he_verify_setup_pkg.check_associations - ' || SQLERRM);
189: fnd_file.put_line(fnd_file.log, fnd_message.get);
190: App_Exception.Raise_Exception;
191:
192: END check_associations;

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

185: END IF;
186:
187: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
188: Fnd_Message.Set_Token('NAME','igs_he_verify_setup_pkg.check_associations - ' || SQLERRM);
189: fnd_file.put_line(fnd_file.log, fnd_message.get);
190: App_Exception.Raise_Exception;
191:
192: END check_associations;
193:

Line 415: fnd_message.set_name('IGS','IGS_HE_VERIFY_CHECK_HESA');

411:
412: BEGIN
413:
414: -- Log Header
415: fnd_message.set_name('IGS','IGS_HE_VERIFY_CHECK_HESA');
416: fnd_message.set_token('DATE',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
417: fnd_file.put_line(fnd_file.log,fnd_message.get());
418:
419: -- Get award conferral dates (to be used in c_get_spa)

Line 416: fnd_message.set_token('DATE',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

412: BEGIN
413:
414: -- Log Header
415: fnd_message.set_name('IGS','IGS_HE_VERIFY_CHECK_HESA');
416: fnd_message.set_token('DATE',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
417: fnd_file.put_line(fnd_file.log,fnd_message.get());
418:
419: -- Get award conferral dates (to be used in c_get_spa)
420: igs_he_extract_fields_pkg.get_awd_dtls( p_submission_name, l_awd_table, l_prog_rec_flag, l_prog_type_rec_flag);

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

413:
414: -- Log Header
415: fnd_message.set_name('IGS','IGS_HE_VERIFY_CHECK_HESA');
416: fnd_message.set_token('DATE',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
417: fnd_file.put_line(fnd_file.log,fnd_message.get());
418:
419: -- Get award conferral dates (to be used in c_get_spa)
420: igs_he_extract_fields_pkg.get_awd_dtls( p_submission_name, l_awd_table, l_prog_rec_flag, l_prog_type_rec_flag);
421: igs_he_extract_fields_pkg.get_min_max_awd_dates( p_submission_name, g_he_submsn_header.enrolment_start_date, g_he_submsn_header.enrolment_end_date, l_awd_conf_start_dt, l_awd_conf_end_dt);

Line 760: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_UNIT');

756: FROM igs_he_verify_data_t
757: WHERE unit_flag = 'N';
758:
759: -- Log Summary of Module Results
760: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_UNIT');
761: fnd_message.set_token('MISSING',l_count);
762: fnd_file.put_line(fnd_file.log,fnd_message.get());
763:
764: ELSE

Line 761: fnd_message.set_token('MISSING',l_count);

757: WHERE unit_flag = 'N';
758:
759: -- Log Summary of Module Results
760: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_UNIT');
761: fnd_message.set_token('MISSING',l_count);
762: fnd_file.put_line(fnd_file.log,fnd_message.get());
763:
764: ELSE
765:

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

758:
759: -- Log Summary of Module Results
760: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_UNIT');
761: fnd_message.set_token('MISSING',l_count);
762: fnd_file.put_line(fnd_file.log,fnd_message.get());
763:
764: ELSE
765:
766:

Line 774: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_PROG');

770: FROM igs_he_verify_data_t
771: WHERE prog_flag = 'N';
772:
773: -- Log Summary of Program Results
774: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_PROG');
775: fnd_message.set_token('MISSING',l_count);
776: fnd_file.put_line(fnd_file.log,fnd_message.get());
777:
778: -- Get count of missing POOUS HESA Records

Line 775: fnd_message.set_token('MISSING',l_count);

771: WHERE prog_flag = 'N';
772:
773: -- Log Summary of Program Results
774: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_PROG');
775: fnd_message.set_token('MISSING',l_count);
776: fnd_file.put_line(fnd_file.log,fnd_message.get());
777:
778: -- Get count of missing POOUS HESA Records
779: SELECT COUNT(DISTINCT course_cd || crv_version_number || cal_type || location_cd || attendance_mode || attendance_type || unit_set_cd || us_version_number)

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

772:
773: -- Log Summary of Program Results
774: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_PROG');
775: fnd_message.set_token('MISSING',l_count);
776: fnd_file.put_line(fnd_file.log,fnd_message.get());
777:
778: -- Get count of missing POOUS HESA Records
779: SELECT COUNT(DISTINCT course_cd || crv_version_number || cal_type || location_cd || attendance_mode || attendance_type || unit_set_cd || us_version_number)
780: INTO l_count

Line 785: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_POOUS');

781: FROM igs_he_verify_data_t
782: WHERE poous_flag = 'N';
783:
784: -- Log Summary of POOUS Results
785: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_POOUS');
786: fnd_message.set_token('MISSING',l_count);
787: fnd_file.put_line(fnd_file.log,fnd_message.get());
788:
789: -- Get count of missing or incomplete SPA HESA Records

Line 786: fnd_message.set_token('MISSING',l_count);

782: WHERE poous_flag = 'N';
783:
784: -- Log Summary of POOUS Results
785: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_POOUS');
786: fnd_message.set_token('MISSING',l_count);
787: fnd_file.put_line(fnd_file.log,fnd_message.get());
788:
789: -- Get count of missing or incomplete SPA HESA Records
790: SELECT COUNT(DISTINCT person_id || course_cd)

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

783:
784: -- Log Summary of POOUS Results
785: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_POOUS');
786: fnd_message.set_token('MISSING',l_count);
787: fnd_file.put_line(fnd_file.log,fnd_message.get());
788:
789: -- Get count of missing or incomplete SPA HESA Records
790: SELECT COUNT(DISTINCT person_id || course_cd)
791: INTO l_count

Line 796: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_SPA');

792: FROM igs_he_verify_data_t
793: WHERE spa_flag = 'N' OR qualaim_flag = 'N' OR sin_flag = 'N';
794:
795: -- Log Summary of POOUS Results
796: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_SPA');
797: fnd_message.set_token('MISSING',l_count);
798: fnd_file.put_line(fnd_file.log,fnd_message.get());
799:
800: -- Get count of missing or incomplete SPA HESA Records

Line 797: fnd_message.set_token('MISSING',l_count);

793: WHERE spa_flag = 'N' OR qualaim_flag = 'N' OR sin_flag = 'N';
794:
795: -- Log Summary of POOUS Results
796: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_SPA');
797: fnd_message.set_token('MISSING',l_count);
798: fnd_file.put_line(fnd_file.log,fnd_message.get());
799:
800: -- Get count of missing or incomplete SPA HESA Records
801: SELECT COUNT(DISTINCT person_id || course_cd || unit_set_cd || us_version_number)

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

794:
795: -- Log Summary of POOUS Results
796: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_SPA');
797: fnd_message.set_token('MISSING',l_count);
798: fnd_file.put_line(fnd_file.log,fnd_message.get());
799:
800: -- Get count of missing or incomplete SPA HESA Records
801: SELECT COUNT(DISTINCT person_id || course_cd || unit_set_cd || us_version_number)
802: INTO l_count

Line 807: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_SUSA');

803: FROM igs_he_verify_data_t
804: WHERE susa_flag = 'N';
805:
806: -- Log Summary of POOUS Results
807: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_SUSA');
808: fnd_message.set_token('MISSING',l_count);
809: fnd_file.put_line(fnd_file.log,fnd_message.get());
810:
811: END IF;

Line 808: fnd_message.set_token('MISSING',l_count);

804: WHERE susa_flag = 'N';
805:
806: -- Log Summary of POOUS Results
807: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_SUSA');
808: fnd_message.set_token('MISSING',l_count);
809: fnd_file.put_line(fnd_file.log,fnd_message.get());
810:
811: END IF;
812:

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

805:
806: -- Log Summary of POOUS Results
807: fnd_message.set_name('IGS','IGS_HE_VERIFY_MISS_SUSA');
808: fnd_message.set_token('MISSING',l_count);
809: fnd_file.put_line(fnd_file.log,fnd_message.get());
810:
811: END IF;
812:
813: EXCEPTION

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

845: IF c_enr_su%ISOPEN THEN
846: CLOSE c_enr_su;
847: END IF;
848:
849: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
850: Fnd_Message.Set_Token('NAME','igs_he_verify_setup_pkg.check_HESA_data - ' || SQLERRM);
851: fnd_file.put_line(fnd_file.log, fnd_message.get);
852: App_Exception.Raise_Exception;
853:

Line 850: Fnd_Message.Set_Token('NAME','igs_he_verify_setup_pkg.check_HESA_data - ' || SQLERRM);

846: CLOSE c_enr_su;
847: END IF;
848:
849: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
850: Fnd_Message.Set_Token('NAME','igs_he_verify_setup_pkg.check_HESA_data - ' || SQLERRM);
851: fnd_file.put_line(fnd_file.log, fnd_message.get);
852: App_Exception.Raise_Exception;
853:
854: END check_HESA_data;

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

847: END IF;
848:
849: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
850: Fnd_Message.Set_Token('NAME','igs_he_verify_setup_pkg.check_HESA_data - ' || SQLERRM);
851: fnd_file.put_line(fnd_file.log, fnd_message.get);
852: App_Exception.Raise_Exception;
853:
854: END check_HESA_data;
855:

Line 915: fnd_message.set_name('IGS','IGS_HE_PROC_SUBM');

911: CLOSE c_extract_dtls;
912:
913:
914: -- Log Header
915: fnd_message.set_name('IGS','IGS_HE_PROC_SUBM');
916: fnd_message.set_token('SUBMISSION_NAME',g_he_submsn_return.submission_name);
917: fnd_message.set_token('USER_RETURN_SUBCLASS',g_he_submsn_return.user_return_subclass);
918: fnd_message.set_token('RETURN_NAME',g_he_submsn_return.return_name);
919: fnd_message.set_token('ENROLMENT_START_DATE',g_he_submsn_header.enrolment_start_date);

Line 916: fnd_message.set_token('SUBMISSION_NAME',g_he_submsn_return.submission_name);

912:
913:
914: -- Log Header
915: fnd_message.set_name('IGS','IGS_HE_PROC_SUBM');
916: fnd_message.set_token('SUBMISSION_NAME',g_he_submsn_return.submission_name);
917: fnd_message.set_token('USER_RETURN_SUBCLASS',g_he_submsn_return.user_return_subclass);
918: fnd_message.set_token('RETURN_NAME',g_he_submsn_return.return_name);
919: fnd_message.set_token('ENROLMENT_START_DATE',g_he_submsn_header.enrolment_start_date);
920: fnd_message.set_token('ENROLMENT_END_DATE',g_he_submsn_header.enrolment_end_date);

Line 917: fnd_message.set_token('USER_RETURN_SUBCLASS',g_he_submsn_return.user_return_subclass);

913:
914: -- Log Header
915: fnd_message.set_name('IGS','IGS_HE_PROC_SUBM');
916: fnd_message.set_token('SUBMISSION_NAME',g_he_submsn_return.submission_name);
917: fnd_message.set_token('USER_RETURN_SUBCLASS',g_he_submsn_return.user_return_subclass);
918: fnd_message.set_token('RETURN_NAME',g_he_submsn_return.return_name);
919: fnd_message.set_token('ENROLMENT_START_DATE',g_he_submsn_header.enrolment_start_date);
920: fnd_message.set_token('ENROLMENT_END_DATE',g_he_submsn_header.enrolment_end_date);
921: fnd_file.put_line(fnd_file.log,fnd_message.get());

Line 918: fnd_message.set_token('RETURN_NAME',g_he_submsn_return.return_name);

914: -- Log Header
915: fnd_message.set_name('IGS','IGS_HE_PROC_SUBM');
916: fnd_message.set_token('SUBMISSION_NAME',g_he_submsn_return.submission_name);
917: fnd_message.set_token('USER_RETURN_SUBCLASS',g_he_submsn_return.user_return_subclass);
918: fnd_message.set_token('RETURN_NAME',g_he_submsn_return.return_name);
919: fnd_message.set_token('ENROLMENT_START_DATE',g_he_submsn_header.enrolment_start_date);
920: fnd_message.set_token('ENROLMENT_END_DATE',g_he_submsn_header.enrolment_end_date);
921: fnd_file.put_line(fnd_file.log,fnd_message.get());
922:

Line 919: fnd_message.set_token('ENROLMENT_START_DATE',g_he_submsn_header.enrolment_start_date);

915: fnd_message.set_name('IGS','IGS_HE_PROC_SUBM');
916: fnd_message.set_token('SUBMISSION_NAME',g_he_submsn_return.submission_name);
917: fnd_message.set_token('USER_RETURN_SUBCLASS',g_he_submsn_return.user_return_subclass);
918: fnd_message.set_token('RETURN_NAME',g_he_submsn_return.return_name);
919: fnd_message.set_token('ENROLMENT_START_DATE',g_he_submsn_header.enrolment_start_date);
920: fnd_message.set_token('ENROLMENT_END_DATE',g_he_submsn_header.enrolment_end_date);
921: fnd_file.put_line(fnd_file.log,fnd_message.get());
922:
923:

Line 920: fnd_message.set_token('ENROLMENT_END_DATE',g_he_submsn_header.enrolment_end_date);

916: fnd_message.set_token('SUBMISSION_NAME',g_he_submsn_return.submission_name);
917: fnd_message.set_token('USER_RETURN_SUBCLASS',g_he_submsn_return.user_return_subclass);
918: fnd_message.set_token('RETURN_NAME',g_he_submsn_return.return_name);
919: fnd_message.set_token('ENROLMENT_START_DATE',g_he_submsn_header.enrolment_start_date);
920: fnd_message.set_token('ENROLMENT_END_DATE',g_he_submsn_header.enrolment_end_date);
921: fnd_file.put_line(fnd_file.log,fnd_message.get());
922:
923:
924: -- Delete Temp Table

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

917: fnd_message.set_token('USER_RETURN_SUBCLASS',g_he_submsn_return.user_return_subclass);
918: fnd_message.set_token('RETURN_NAME',g_he_submsn_return.return_name);
919: fnd_message.set_token('ENROLMENT_START_DATE',g_he_submsn_header.enrolment_start_date);
920: fnd_message.set_token('ENROLMENT_END_DATE',g_he_submsn_header.enrolment_end_date);
921: fnd_file.put_line(fnd_file.log,fnd_message.get());
922:
923:
924: -- Delete Temp Table
925: DELETE FROM IGS_HE_VERIFY_DATA_T;

Line 943: fnd_message.set_name('IGS','IGS_HE_VERIFY_REPORT_SUB');

939:
940: COMMIT;
941:
942: -- Submit Report Log
943: fnd_message.set_name('IGS','IGS_HE_VERIFY_REPORT_SUB');
944: fnd_message.set_token('DATE',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
945: fnd_file.put_line(fnd_file.log,fnd_message.get());
946:
947:

Line 944: fnd_message.set_token('DATE',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));

940: COMMIT;
941:
942: -- Submit Report Log
943: fnd_message.set_name('IGS','IGS_HE_VERIFY_REPORT_SUB');
944: fnd_message.set_token('DATE',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
945: fnd_file.put_line(fnd_file.log,fnd_message.get());
946:
947:
948: -- Submit the Report

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

941:
942: -- Submit Report Log
943: fnd_message.set_name('IGS','IGS_HE_VERIFY_REPORT_SUB');
944: fnd_message.set_token('DATE',TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS'));
945: fnd_file.put_line(fnd_file.log,fnd_message.get());
946:
947:
948: -- Submit the Report
949: l_request_id := NULL ;

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

968: END IF;
969:
970: ROLLBACK;
971:
972: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
973: Fnd_Message.Set_Token('NAME','igs_he_verify_setup_pkg.verify_setup - ' ||SQLERRM);
974: errbuf := fnd_message.get;
975: fnd_file.put_line(fnd_file.log, errbuf);
976: retcode := 2;

Line 973: Fnd_Message.Set_Token('NAME','igs_he_verify_setup_pkg.verify_setup - ' ||SQLERRM);

969:
970: ROLLBACK;
971:
972: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
973: Fnd_Message.Set_Token('NAME','igs_he_verify_setup_pkg.verify_setup - ' ||SQLERRM);
974: errbuf := fnd_message.get;
975: fnd_file.put_line(fnd_file.log, errbuf);
976: retcode := 2;
977: App_Exception.Raise_Exception;

Line 974: errbuf := fnd_message.get;

970: ROLLBACK;
971:
972: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
973: Fnd_Message.Set_Token('NAME','igs_he_verify_setup_pkg.verify_setup - ' ||SQLERRM);
974: errbuf := fnd_message.get;
975: fnd_file.put_line(fnd_file.log, errbuf);
976: retcode := 2;
977: App_Exception.Raise_Exception;
978: