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_IDENTIFY_TARGET_POP dependencies on FND_FILE

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

46: retcode := 0;
47: -- Check if UCAS and HESA are enabled, ie country = UK
48: IF NOT Igs_Uc_Utils.is_ucas_hesa_enabled THEN
49: fnd_message.set_name('IGS','IGS_UC_HE_NOT_ENABLED');
50: fnd_file.put_line(fnd_file.log, fnd_message.get);
51: errbuf := fnd_message.get ;
52: retcode := 2;
53: RETURN;
54: END IF;

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

63: fnd_message.set_name('IGS','IGS_HE_DLHE_QUAL_PERIOD');
64: fnd_message.set_token('QUAL_PERIOD',cur_qual_period_rec.qual_period_code);
65: fnd_message.set_token('DESC',cur_qual_period_rec.qual_period_desc);
66: fnd_message.set_token('TYPE',cur_qual_period_rec.qual_period_type);
67: fnd_file.put_line(fnd_file.log,fnd_message.get);
68: -- Call the dlhe_identify_spa procedure for each qualifying period
69: igs_he_identify_target_pop.Dlhe_identify_spa(p_submission_name => p_submission_name,
70: p_return_name => p_return_name,
71: p_qual_period => cur_qual_period_rec.qual_period_code,

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

80: WHEN OTHERS THEN
81: ROLLBACK;
82: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
83: Fnd_Message.Set_Token('NAME','igs_he_identify_target_pop.dlhe_identify_population');
84: fnd_file.put_line(fnd_file.log, fnd_message.get);
85: errbuf := fnd_message.get ;
86: retcode := 2;
87:
88: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;

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

266: fnd_message.set_name('IGS','IGS_HE_DLHE_ST_IDENT_POP');
267: fnd_message.set_token('TOTAL_STD_POP',l_tot_ident_pop );
268: fnd_message.set_token('RETURN_NAME',p_return_name);
269: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
270: fnd_file.put_line(fnd_file.log, fnd_message.get);
271:
272: ELSIF p_qual_type = 'R' THEN
273:
274: -- Get the research students and their SPAs

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

344: fnd_message.set_name('IGS','IGS_HE_DLHE_ST_IDENT_POP');
345: fnd_message.set_token('TOTAL_STD_POP',l_tot_ident_pop );
346: fnd_message.set_token('RETURN_NAME',p_return_name);
347: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
348: fnd_file.put_line(fnd_file.log, fnd_message.get);
349:
350: END IF; -- End if for qual type
351:
352: -- Report the total number of new student DLHE records created

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

353: fnd_message.set_name('IGS','IGS_HE_DLHE_REC_CREATED');
354: fnd_message.set_token('CREATED_DLHE', l_new_dlhe_cnt);
355: fnd_message.set_token('RETURN_NAME',p_return_name);
356: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
357: fnd_file.put_line(fnd_file.log, fnd_message.get);
358:
359: -- Report the total number of student DLHE records updated with the current qualifying period
360: fnd_message.set_name('IGS','IGS_HE_DLHE_REC_UPDATED');
361: fnd_message.set_token('UPDATED_DLHE', l_upd_dlhe_cnt);

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

360: fnd_message.set_name('IGS','IGS_HE_DLHE_REC_UPDATED');
361: fnd_message.set_token('UPDATED_DLHE', l_upd_dlhe_cnt);
362: fnd_message.set_token('RETURN_NAME',p_return_name);
363: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
364: fnd_file.put_line(fnd_file.log, fnd_message.get);
365:
366: -- Report the total number of students failed to satisfy the field validations
367: fnd_message.set_name('IGS','IGS_HE_DLHE_FAILED_STD');
368: fnd_message.set_token('FAIL_DLHE', l_fail_std_cnt);

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

367: fnd_message.set_name('IGS','IGS_HE_DLHE_FAILED_STD');
368: fnd_message.set_token('FAIL_DLHE', l_fail_std_cnt);
369: fnd_message.set_token('RETURN_NAME',p_return_name);
370: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
371: fnd_file.put_line(fnd_file.log, fnd_message.get);
372:
373: -- Report the total number of students have the student DLHE records with open qualifying period,
374: -- for them not required to modify student DLHE record.
375: fnd_message.set_name('IGS','IGS_HE_DLHE_NOT_MODIFIED');

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

375: fnd_message.set_name('IGS','IGS_HE_DLHE_NOT_MODIFIED');
376: fnd_message.set_token('NOT_MOD', l_not_mod_cnt);
377: fnd_message.set_token('RETURN_NAME',p_return_name);
378: fnd_message.set_token('QUAL_PERIOD',p_qual_period);
379: fnd_file.put_line(fnd_file.log, fnd_message.get);
380:
381: END IF; -- End if For closed qual_period
382:
383: EXCEPTION

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

383: EXCEPTION
384: WHEN OTHERS THEN
385: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
386: Fnd_Message.Set_Token('NAME','igs_he_identify_target_pop.dlhe_identify_spa');
387: fnd_file.put_line(fnd_file.log, fnd_message.get);
388: App_Exception.Raise_Exception;
389:
390: END dlhe_identify_spa;
391:

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

683: EXCEPTION
684: WHEN OTHERS THEN
685: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
686: Fnd_Message.Set_Token('NAME','igs_he_identify_target_pop.dlhe_process_spa');
687: fnd_file.put_line(fnd_file.log, fnd_message.get);
688: App_Exception.Raise_Exception;
689:
690: END dlhe_process_spa;
691:

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

1061: p_include:= 'N';
1062: fnd_message.set_name('IGS','IGS_HE_QUAL_FAIL_TO_DERIVE');
1063: fnd_message.set_token('PERSON_NUMBER', l_person_number);
1064: fnd_message.set_token('COURSE', p_course_cd);
1065: fnd_file.put_line(fnd_file.log, fnd_message.get);
1066: ELSIF (l_hesa_qual1 IS NULL OR l_hesa_qual1 NOT IN ('02','03','04','05','06','07','08','12','13','14','18','20','21','22','23','28','29','30','33','41','42') )
1067: AND (l_hesa_qual2 IS NULL OR l_hesa_qual2 NOT IN ('02','03','04','05','06','07','08','12','13','14','18','20','21','22','23','28','29','30','33','41','42')) THEN
1068: --Person failed to satisfy the qualification field validation, so report it in the log file
1069: p_include:= 'N';

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

1071: fnd_message.set_token('PERSON_NUMBER', l_person_number);
1072: fnd_message.set_token('COURSE', p_course_cd);
1073: fnd_message.set_token('QUAL1', l_hesa_qual1 );
1074: fnd_message.set_token('QUAL2', l_hesa_qual2);
1075: fnd_file.put_line(fnd_file.log, fnd_message.get);
1076: END IF;
1077:
1078: -- Get the location_of_study
1079: -- smaddali modified call to this cursor to pass l_spa.version_number instead of p_version_number

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

1100: p_include:= 'N';
1101: fnd_message.set_name('IGS','IGS_HE_LOCSDY_FAIL_TO_DERIVE');
1102: fnd_message.set_token('PERSON_NUMBER', l_person_number);
1103: fnd_message.set_token('COURSE', p_course_cd);
1104: fnd_file.put_line(fnd_file.log, fnd_message.get);
1105: ELSIF l_hesa_locsdy = '7' THEN
1106: p_include:= 'N';
1107: fnd_message.set_name('IGS','IGS_HE_LOCSDY_VALID_FAILED');
1108: fnd_message.set_token('PERSON_NUMBER', l_person_number);

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

1107: fnd_message.set_name('IGS','IGS_HE_LOCSDY_VALID_FAILED');
1108: fnd_message.set_token('PERSON_NUMBER', l_person_number);
1109: fnd_message.set_token('COURSE', p_course_cd);
1110: fnd_message.set_token('LOCSDY', l_hesa_locsdy);
1111: fnd_file.put_line(fnd_file.log, fnd_message.get);
1112: END IF;
1113:
1114: -- Derive RSNLEAVE (field 33) value
1115: l_rsn_inst_left := NULL;

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

1130: fnd_message.set_name('IGS','IGS_HE_RSNLEAVE_VALID_FAILED');
1131: fnd_message.set_token('PERSON_NUMBER', l_person_number);
1132: fnd_message.set_token('COURSE', p_course_cd);
1133: fnd_message.set_token('RSNLEAVE', l_rsn_inst_left);
1134: fnd_file.put_line(fnd_file.log, fnd_message.get);
1135: END IF;
1136:
1137: -- Derive DOMICILE (Field 12) value
1138: l_hesa_domicile := NULL;

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

1146: p_include:= 'N';
1147: fnd_message.set_name('IGS','IGS_HE_DOMICILE_FAIL_TO_DERIVE');
1148: fnd_message.set_token('PERSON_NUMBER', l_person_number);
1149: fnd_message.set_token('COURSE', p_course_cd);
1150: fnd_file.put_line(fnd_file.log, fnd_message.get);
1151: ELSIF l_hesa_domicile NOT IN ('1610','1614','1641','1651','1653','1656','1659','1661','1676','1678','1693',
1152: '1710','1728','1751','1755','3826','4826','5826','6826','7826','8826',
1153: '1638','1639','1670','1700','1727','1831','1832','1833','1835','1850') THEN
1154: p_include:= 'N';

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

1155: fnd_message.set_name('IGS','IGS_HE_DOMICILE_VALID_FAILED');
1156: fnd_message.set_token('PERSON_NUMBER', l_person_number);
1157: fnd_message.set_token('COURSE', p_course_cd);
1158: fnd_message.set_token('DOMICILE', l_hesa_domicile);
1159: fnd_file.put_line(fnd_file.log, fnd_message.get);
1160: END IF;
1161:
1162: -- Derive MODE (70) field value
1163: l_mode := NULL;

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

1177: p_include:= 'N';
1178: fnd_message.set_name('IGS','IGS_HE_MODE_FAIL_TO_DERIVE');
1179: fnd_message.set_token('PERSON_NUMBER', l_person_number);
1180: fnd_message.set_token('COURSE', p_course_cd);
1181: fnd_file.put_line(fnd_file.log, fnd_message.get);
1182: ELSIF l_mode = '63' OR l_mode = '64' THEN
1183: p_include:= 'N';
1184: fnd_message.set_name('IGS','IGS_HE_MODE_VALID_FAILED');
1185: fnd_message.set_token('PERSON_NUMBER', l_person_number);

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

1184: fnd_message.set_name('IGS','IGS_HE_MODE_VALID_FAILED');
1185: fnd_message.set_token('PERSON_NUMBER', l_person_number);
1186: fnd_message.set_token('COURSE', p_course_cd);
1187: fnd_message.set_token('MODE', l_mode);
1188: fnd_file.put_line(fnd_file.log, fnd_message.get);
1189: END IF;
1190:
1191: -- Check whether the field values satisfies the condition
1192: IF p_include = 'N' THEN

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

1266: p_include:= 'N';
1267: fnd_message.set_name('IGS','IGS_HE_MSTUFEE_FAIL_TO_DERIVE');
1268: fnd_message.set_token('PERSON_NUMBER', l_person_number);
1269: fnd_message.set_token('COURSE', p_course_cd);
1270: fnd_file.put_line(fnd_file.log, fnd_message.get);
1271: ELSIF l_hesa_mstufee NOT IN ('11','12','13','14','15','16','17','19') THEN
1272: p_include:= 'N';
1273: fnd_message.set_name('IGS','IGS_HE_MSTUFEE_VALID_FAILED');
1274: fnd_message.set_token('PERSON_NUMBER', l_person_number);

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

1273: fnd_message.set_name('IGS','IGS_HE_MSTUFEE_VALID_FAILED');
1274: fnd_message.set_token('PERSON_NUMBER', l_person_number);
1275: fnd_message.set_token('COURSE', p_course_cd);
1276: fnd_message.set_token('MSTUFEE', l_hesa_mstufee);
1277: fnd_file.put_line(fnd_file.log, fnd_message.get);
1278: END IF;
1279:
1280: -- Derive Reason for leaving institution (RSNLEAVE Field 33)
1281: l_rsn_inst_left := NULL;

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

1296: fnd_message.set_name('IGS','IGS_HE_RSNLEAVE_VALID_FAILED');
1297: fnd_message.set_token('PERSON_NUMBER', l_person_number);
1298: fnd_message.set_token('COURSE', p_course_cd);
1299: fnd_message.set_token('RSNLEAVE', l_rsn_inst_left);
1300: fnd_file.put_line(fnd_file.log, fnd_message.get);
1301: END IF;
1302:
1303: -- Check whether the student satisfies the field validation
1304: IF p_include = 'N' THEN

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

1318: EXCEPTION
1319: WHEN OTHERS THEN
1320: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');
1321: Fnd_Message.Set_Token('NAME','igs_he_identify_target_pop.dlhe_review_spa');
1322: fnd_file.put_line(fnd_file.log, fnd_message.get);
1323: App_Exception.Raise_Exception;
1324:
1325: END dlhe_review_spa;
1326: