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_MESSAGE

Line 49: fnd_message.set_name('IGS','IGS_UC_HE_NOT_ENABLED');

45:
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;

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 51: errbuf := fnd_message.get ;

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;
55:

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

59: p_return_name,
60: p_qual_period) LOOP
61:
62: -- Report the Qualifying period details in the log file
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);

Line 64: fnd_message.set_token('QUAL_PERIOD',cur_qual_period_rec.qual_period_code);

60: p_qual_period) LOOP
61:
62: -- Report the Qualifying period details in the log file
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

Line 65: fnd_message.set_token('DESC',cur_qual_period_rec.qual_period_desc);

61:
62: -- Report the Qualifying period details in the log file
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,

Line 66: fnd_message.set_token('TYPE',cur_qual_period_rec.qual_period_type);

62: -- Report the Qualifying period details in the log file
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,

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 82: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

78:
79: EXCEPTION
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;

Line 83: Fnd_Message.Set_Token('NAME','igs_he_identify_target_pop.dlhe_identify_population');

79: EXCEPTION
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:

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 85: errbuf := fnd_message.get ;

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;
89:

Line 266: fnd_message.set_name('IGS','IGS_HE_DLHE_ST_IDENT_POP');

262: -- total number of identified leavers students for the population
263: l_tot_ident_pop := l_tot_ident_pop + l_new_dlhe_cnt + l_upd_dlhe_cnt + l_fail_std_cnt + l_not_mod_cnt;
264:
265: -- Report the total number of Leaver students identifed in the population
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);

Line 267: fnd_message.set_token('TOTAL_STD_POP',l_tot_ident_pop );

263: l_tot_ident_pop := l_tot_ident_pop + l_new_dlhe_cnt + l_upd_dlhe_cnt + l_fail_std_cnt + l_not_mod_cnt;
264:
265: -- Report the total number of Leaver students identifed in the population
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:

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

264:
265: -- Report the total number of Leaver students identifed in the population
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

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

265: -- Report the total number of Leaver students identifed in the population
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:

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 344: fnd_message.set_name('IGS','IGS_HE_DLHE_ST_IDENT_POP');

340: -- total number of identified research students for the population
341: l_tot_ident_pop := l_tot_ident_pop + l_new_dlhe_cnt + l_upd_dlhe_cnt + l_fail_std_cnt + l_not_mod_cnt;
342:
343: -- Report the total number of research students identifed for target population
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);

Line 345: fnd_message.set_token('TOTAL_STD_POP',l_tot_ident_pop );

341: l_tot_ident_pop := l_tot_ident_pop + l_new_dlhe_cnt + l_upd_dlhe_cnt + l_fail_std_cnt + l_not_mod_cnt;
342:
343: -- Report the total number of research students identifed for target population
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:

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

342:
343: -- Report the total number of research students identifed for target population
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

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

343: -- Report the total number of research students identifed for target population
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:

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 353: fnd_message.set_name('IGS','IGS_HE_DLHE_REC_CREATED');

349:
350: END IF; -- End if for qual type
351:
352: -- Report the total number of new student DLHE records created
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);

Line 354: fnd_message.set_token('CREATED_DLHE', l_new_dlhe_cnt);

350: END IF; -- End if for qual type
351:
352: -- Report the total number of new student DLHE records created
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:

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

351:
352: -- Report the total number of new student DLHE records created
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

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

352: -- Report the total number of new student DLHE records created
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');

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 360: fnd_message.set_name('IGS','IGS_HE_DLHE_REC_UPDATED');

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);
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);

Line 361: fnd_message.set_token('UPDATED_DLHE', l_upd_dlhe_cnt);

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);
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:

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

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);
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

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

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);
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');

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 367: fnd_message.set_name('IGS','IGS_HE_DLHE_FAILED_STD');

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);
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);

Line 368: fnd_message.set_token('FAIL_DLHE', l_fail_std_cnt);

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);
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:

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

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);
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,

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

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);
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.

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 375: fnd_message.set_name('IGS','IGS_HE_DLHE_NOT_MODIFIED');

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');
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);

Line 376: fnd_message.set_token('NOT_MOD', l_not_mod_cnt);

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');
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:

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

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');
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

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

374: -- for them not required to modify student DLHE record.
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:

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 385: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

381: END IF; -- End if For closed qual_period
382:
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:

Line 386: Fnd_Message.Set_Token('NAME','igs_he_identify_target_pop.dlhe_identify_spa');

382:
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;

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 685: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

681: END IF; -- End if for include N
682:
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:

Line 686: Fnd_Message.Set_Token('NAME','igs_he_identify_target_pop.dlhe_process_spa');

682:
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;

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 1062: fnd_message.set_name('IGS','IGS_HE_QUAL_FAIL_TO_DERIVE');

1058: p_classification => l_hesa_classification);
1059:
1060: IF l_hesa_qual1 IS NULL AND l_hesa_qual2 IS NULL THEN
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') )

Line 1063: fnd_message.set_token('PERSON_NUMBER', l_person_number);

1059:
1060: IF l_hesa_qual1 IS NULL AND l_hesa_qual2 IS NULL THEN
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

Line 1064: fnd_message.set_token('COURSE', p_course_cd);

1060: IF l_hesa_qual1 IS NULL AND l_hesa_qual2 IS NULL THEN
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

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 1070: fnd_message.set_name('IGS','IGS_HE_QUAL_VALID_FAILED');

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';
1070: fnd_message.set_name('IGS','IGS_HE_QUAL_VALID_FAILED');
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);

Line 1071: fnd_message.set_token('PERSON_NUMBER', l_person_number);

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';
1070: fnd_message.set_name('IGS','IGS_HE_QUAL_VALID_FAILED');
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);

Line 1072: fnd_message.set_token('COURSE', p_course_cd);

1068: --Person failed to satisfy the qualification field validation, so report it in the log file
1069: p_include:= 'N';
1070: fnd_message.set_name('IGS','IGS_HE_QUAL_VALID_FAILED');
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;

Line 1073: fnd_message.set_token('QUAL1', l_hesa_qual1 );

1069: p_include:= 'N';
1070: fnd_message.set_name('IGS','IGS_HE_QUAL_VALID_FAILED');
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:

Line 1074: fnd_message.set_token('QUAL2', l_hesa_qual2);

1070: fnd_message.set_name('IGS','IGS_HE_QUAL_VALID_FAILED');
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

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 1101: fnd_message.set_name('IGS','IGS_HE_LOCSDY_FAIL_TO_DERIVE');

1097:
1098: -- If field value null or field value is not in the list then report the message in the log file
1099: IF l_hesa_locsdy IS NULL THEN
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

Line 1102: fnd_message.set_token('PERSON_NUMBER', l_person_number);

1098: -- If field value null or field value is not in the list then report the message in the log file
1099: IF l_hesa_locsdy IS NULL THEN
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';

Line 1103: fnd_message.set_token('COURSE', p_course_cd);

1099: IF l_hesa_locsdy IS NULL THEN
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');

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 1107: fnd_message.set_name('IGS','IGS_HE_LOCSDY_VALID_FAILED');

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);
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);

Line 1108: fnd_message.set_token('PERSON_NUMBER', l_person_number);

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);
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;

Line 1109: fnd_message.set_token('COURSE', p_course_cd);

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);
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:

Line 1110: fnd_message.set_token('LOCSDY', l_hesa_locsdy);

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);
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

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 1130: fnd_message.set_name('IGS','IGS_HE_RSNLEAVE_VALID_FAILED');

1126:
1127: -- If the field value is not in the list then report the message in log file
1128: IF l_rsn_inst_left = '05' THEN
1129: p_include:= 'N';
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);

Line 1131: fnd_message.set_token('PERSON_NUMBER', l_person_number);

1127: -- If the field value is not in the list then report the message in log file
1128: IF l_rsn_inst_left = '05' THEN
1129: p_include:= 'N';
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;

Line 1132: fnd_message.set_token('COURSE', p_course_cd);

1128: IF l_rsn_inst_left = '05' THEN
1129: p_include:= 'N';
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:

Line 1133: fnd_message.set_token('RSNLEAVE', l_rsn_inst_left);

1129: p_include:= 'N';
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

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 1147: fnd_message.set_name('IGS','IGS_HE_DOMICILE_FAIL_TO_DERIVE');

1143:
1144: -- If field value is null or field value is not in the list then report the message in log file
1145: IF l_hesa_domicile IS NULL THEN
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',

Line 1148: fnd_message.set_token('PERSON_NUMBER', l_person_number);

1144: -- If field value is null or field value is not in the list then report the message in log file
1145: IF l_hesa_domicile IS NULL THEN
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',

Line 1149: fnd_message.set_token('COURSE', p_course_cd);

1145: IF l_hesa_domicile IS NULL THEN
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

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 1155: fnd_message.set_name('IGS','IGS_HE_DOMICILE_VALID_FAILED');

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';
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);

Line 1156: fnd_message.set_token('PERSON_NUMBER', l_person_number);

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';
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;

Line 1157: fnd_message.set_token('COURSE', p_course_cd);

1153: '1638','1639','1670','1700','1727','1831','1832','1833','1835','1850') THEN
1154: p_include:= 'N';
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:

Line 1158: fnd_message.set_token('DOMICILE', l_hesa_domicile);

1154: p_include:= 'N';
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

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 1178: fnd_message.set_name('IGS','IGS_HE_MODE_FAIL_TO_DERIVE');

1174:
1175: -- If field value is null or field value is not in the list then report the message in log file
1176: IF l_mode IS NULL THEN
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

Line 1179: fnd_message.set_token('PERSON_NUMBER', l_person_number);

1175: -- If field value is null or field value is not in the list then report the message in log file
1176: IF l_mode IS NULL THEN
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';

Line 1180: fnd_message.set_token('COURSE', p_course_cd);

1176: IF l_mode IS NULL THEN
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');

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 1184: fnd_message.set_name('IGS','IGS_HE_MODE_VALID_FAILED');

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);
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);

Line 1185: fnd_message.set_token('PERSON_NUMBER', l_person_number);

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);
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;

Line 1186: fnd_message.set_token('COURSE', p_course_cd);

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);
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:

Line 1187: fnd_message.set_token('MODE', l_mode);

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);
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

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 1267: fnd_message.set_name('IGS','IGS_HE_MSTUFEE_FAIL_TO_DERIVE');

1263:
1264: -- If field value is null or field value is not in the list then report the message in log file
1265: IF l_hesa_mstufee IS NULL THEN
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

Line 1268: fnd_message.set_token('PERSON_NUMBER', l_person_number);

1264: -- If field value is null or field value is not in the list then report the message in log file
1265: IF l_hesa_mstufee IS NULL THEN
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';

Line 1269: fnd_message.set_token('COURSE', p_course_cd);

1265: IF l_hesa_mstufee IS NULL THEN
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');

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 1273: fnd_message.set_name('IGS','IGS_HE_MSTUFEE_VALID_FAILED');

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);
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);

Line 1274: fnd_message.set_token('PERSON_NUMBER', l_person_number);

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);
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;

Line 1275: fnd_message.set_token('COURSE', p_course_cd);

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);
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:

Line 1276: fnd_message.set_token('MSTUFEE', l_hesa_mstufee);

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);
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)

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 1296: fnd_message.set_name('IGS','IGS_HE_RSNLEAVE_VALID_FAILED');

1292:
1293: -- If field value is not in the list then report the message in log file
1294: IF l_rsn_inst_left = '05' THEN
1295: p_include:= 'N';
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);

Line 1297: fnd_message.set_token('PERSON_NUMBER', l_person_number);

1293: -- If field value is not in the list then report the message in log file
1294: IF l_rsn_inst_left = '05' THEN
1295: p_include:= 'N';
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;

Line 1298: fnd_message.set_token('COURSE', p_course_cd);

1294: IF l_rsn_inst_left = '05' THEN
1295: p_include:= 'N';
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:

Line 1299: fnd_message.set_token('RSNLEAVE', l_rsn_inst_left);

1295: p_include:= 'N';
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

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 1320: Fnd_Message.Set_Name('IGS','IGS_GE_UNHANDLED_EXP');

1316: END IF; -- Qualifying period type
1317:
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:

Line 1321: Fnd_Message.Set_Token('NAME','igs_he_identify_target_pop.dlhe_review_spa');

1317:
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;

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: