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_FILE

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 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 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 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 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 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 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 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 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 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 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 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 975: fnd_file.put_line(fnd_file.log, errbuf);

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:
979: END verify_return;