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

Line 135: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');

131: DELETE igs_uc_istrpqr_ints WHERE appno = p_app_no;
132:
133: EXCEPTION
134: WHEN OTHERS THEN
135: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
136: fnd_message.set_token('NAME','igs_uc_expunge_app.delete_ucas_interface_rec'||' - '||SQLERRM);
137: igs_ge_msg_stack.add;
138: app_exception.raise_exception;
139:

Line 136: fnd_message.set_token('NAME','igs_uc_expunge_app.delete_ucas_interface_rec'||' - '||SQLERRM);

132:
133: EXCEPTION
134: WHEN OTHERS THEN
135: Fnd_Message.Set_name('IGS','IGS_GE_UNHANDLED_EXP');
136: fnd_message.set_token('NAME','igs_uc_expunge_app.delete_ucas_interface_rec'||' - '||SQLERRM);
137: igs_ge_msg_stack.add;
138: app_exception.raise_exception;
139:
140: END delete_ucas_interface_rec;

Line 333: fnd_message.set_name( 'IGS','IGS_UC_OBS_SETUP_NOT_SET');

329: FETCH cur_system_val_setup INTO l_setup_comp;
330: CLOSE cur_system_val_setup;
331:
332: IF l_setup_comp = 'X' THEN
333: fnd_message.set_name( 'IGS','IGS_UC_OBS_SETUP_NOT_SET');
334: fnd_file.put_line(fnd_file.log, fnd_message.get);
335: -- end job in warning state
336: retcode := 1;
337: ELSE

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

330: CLOSE cur_system_val_setup;
331:
332: IF l_setup_comp = 'X' THEN
333: fnd_message.set_name( 'IGS','IGS_UC_OBS_SETUP_NOT_SET');
334: fnd_file.put_line(fnd_file.log, fnd_message.get);
335: -- end job in warning state
336: retcode := 1;
337: ELSE
338:

Line 395: fnd_message.set_name('IGS','IGS_UC_APPNO_CHOICE_PROC');

391: l_oss_app_inst_suspended := 'Y';
392:
393: -- log Application Choice processing message.
394: fnd_file.put_line (fnd_file.log,' ');
395: fnd_message.set_name('IGS','IGS_UC_APPNO_CHOICE_PROC');
396: fnd_message.set_token('APPNO', TO_CHAR(l_wrong_app_rec.app_no));
397: fnd_message.set_token('CHOICE',TO_CHAR(l_expunge_choice_det(l_loc)));
398: fnd_file.put_line(fnd_file.log, fnd_message.get);
399:

Line 396: fnd_message.set_token('APPNO', TO_CHAR(l_wrong_app_rec.app_no));

392:
393: -- log Application Choice processing message.
394: fnd_file.put_line (fnd_file.log,' ');
395: fnd_message.set_name('IGS','IGS_UC_APPNO_CHOICE_PROC');
396: fnd_message.set_token('APPNO', TO_CHAR(l_wrong_app_rec.app_no));
397: fnd_message.set_token('CHOICE',TO_CHAR(l_expunge_choice_det(l_loc)));
398: fnd_file.put_line(fnd_file.log, fnd_message.get);
399:
400: --Identify the OSS Admission Application instances to be suspended.

Line 397: fnd_message.set_token('CHOICE',TO_CHAR(l_expunge_choice_det(l_loc)));

393: -- log Application Choice processing message.
394: fnd_file.put_line (fnd_file.log,' ');
395: fnd_message.set_name('IGS','IGS_UC_APPNO_CHOICE_PROC');
396: fnd_message.set_token('APPNO', TO_CHAR(l_wrong_app_rec.app_no));
397: fnd_message.set_token('CHOICE',TO_CHAR(l_expunge_choice_det(l_loc)));
398: fnd_file.put_line(fnd_file.log, fnd_message.get);
399:
400: --Identify the OSS Admission Application instances to be suspended.
401: OPEN cur_oss_ad_appl_inst(l_wrong_app_rec.app_no, l_expunge_choice_det(l_loc));

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

394: fnd_file.put_line (fnd_file.log,' ');
395: fnd_message.set_name('IGS','IGS_UC_APPNO_CHOICE_PROC');
396: fnd_message.set_token('APPNO', TO_CHAR(l_wrong_app_rec.app_no));
397: fnd_message.set_token('CHOICE',TO_CHAR(l_expunge_choice_det(l_loc)));
398: fnd_file.put_line(fnd_file.log, fnd_message.get);
399:
400: --Identify the OSS Admission Application instances to be suspended.
401: OPEN cur_oss_ad_appl_inst(l_wrong_app_rec.app_no, l_expunge_choice_det(l_loc));
402: FETCH cur_oss_ad_appl_inst INTO l_appl_inst_rec;

Line 408: fnd_message.set_name( 'IGS','IGS_UC_NO_XPG_APPL_INST');

404: IF cur_oss_ad_appl_inst%NOTFOUND THEN
405:
406: --When there are no Application Instances to Suspend then log the message and proceed with expunge process FOR next Application number.
407: CLOSE cur_oss_ad_appl_inst;
408: fnd_message.set_name( 'IGS','IGS_UC_NO_XPG_APPL_INST');
409: fnd_message.set_token('APP_NO',TO_CHAR(l_wrong_app_rec.app_no));
410: fnd_message.set_token('CHOICE_NO',TO_CHAR(l_expunge_choice_det(l_loc)));
411: fnd_file.put_line (fnd_file.log,fnd_message.get);
412:

Line 409: fnd_message.set_token('APP_NO',TO_CHAR(l_wrong_app_rec.app_no));

405:
406: --When there are no Application Instances to Suspend then log the message and proceed with expunge process FOR next Application number.
407: CLOSE cur_oss_ad_appl_inst;
408: fnd_message.set_name( 'IGS','IGS_UC_NO_XPG_APPL_INST');
409: fnd_message.set_token('APP_NO',TO_CHAR(l_wrong_app_rec.app_no));
410: fnd_message.set_token('CHOICE_NO',TO_CHAR(l_expunge_choice_det(l_loc)));
411: fnd_file.put_line (fnd_file.log,fnd_message.get);
412:
413: ELSE

Line 410: fnd_message.set_token('CHOICE_NO',TO_CHAR(l_expunge_choice_det(l_loc)));

406: --When there are no Application Instances to Suspend then log the message and proceed with expunge process FOR next Application number.
407: CLOSE cur_oss_ad_appl_inst;
408: fnd_message.set_name( 'IGS','IGS_UC_NO_XPG_APPL_INST');
409: fnd_message.set_token('APP_NO',TO_CHAR(l_wrong_app_rec.app_no));
410: fnd_message.set_token('CHOICE_NO',TO_CHAR(l_expunge_choice_det(l_loc)));
411: fnd_file.put_line (fnd_file.log,fnd_message.get);
412:
413: ELSE
414:

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

407: CLOSE cur_oss_ad_appl_inst;
408: fnd_message.set_name( 'IGS','IGS_UC_NO_XPG_APPL_INST');
409: fnd_message.set_token('APP_NO',TO_CHAR(l_wrong_app_rec.app_no));
410: fnd_message.set_token('CHOICE_NO',TO_CHAR(l_expunge_choice_det(l_loc)));
411: fnd_file.put_line (fnd_file.log,fnd_message.get);
412:
413: ELSE
414:
415: CLOSE cur_oss_ad_appl_inst;

Line 427: x_description => fnd_message.get_string('IGS','IGS_UC_XPG_DEC_BATCH'),

423: l_rowid := NULL;
424: l_dec_batch_id := NULL;
425: igs_ad_batc_def_det_pkg.insert_row ( x_rowid => l_rowid,
426: x_batch_id => l_dec_batch_id,
427: x_description => fnd_message.get_string('IGS','IGS_UC_XPG_DEC_BATCH'),
428: x_acad_cal_type => l_oss_ad_appl_inst_rec.acad_cal_type,
429: x_acad_ci_sequence_number => l_oss_ad_appl_inst_rec.acad_ci_sequence_number,
430: x_adm_cal_type => l_oss_ad_appl_inst_rec.adm_cal_type,
431: x_adm_ci_sequence_number => l_oss_ad_appl_inst_rec.adm_ci_sequence_number,

Line 498: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_ERR');

494: l_oss_app_inst_suspended := 'N';
495: l_all_makred_app_inst_expunged := 'N';
496: l_dec_imp_err := ' - '||l_error_message;
497:
498: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_ERR');
499: fnd_message.set_token('APP_NO', l_oss_ad_appl_inst_rec.alt_appl_id);
500: fnd_message.set_token('CHOICE_NO',l_oss_ad_appl_inst_rec.choice_number);
501: fnd_message.set_token('BATCH_ID', l_dec_batch_id);
502: fnd_file.put_line(fnd_file.log,fnd_message.get()||l_dec_imp_err);

Line 499: fnd_message.set_token('APP_NO', l_oss_ad_appl_inst_rec.alt_appl_id);

495: l_all_makred_app_inst_expunged := 'N';
496: l_dec_imp_err := ' - '||l_error_message;
497:
498: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_ERR');
499: fnd_message.set_token('APP_NO', l_oss_ad_appl_inst_rec.alt_appl_id);
500: fnd_message.set_token('CHOICE_NO',l_oss_ad_appl_inst_rec.choice_number);
501: fnd_message.set_token('BATCH_ID', l_dec_batch_id);
502: fnd_file.put_line(fnd_file.log,fnd_message.get()||l_dec_imp_err);
503: ELSE

Line 500: fnd_message.set_token('CHOICE_NO',l_oss_ad_appl_inst_rec.choice_number);

496: l_dec_imp_err := ' - '||l_error_message;
497:
498: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_ERR');
499: fnd_message.set_token('APP_NO', l_oss_ad_appl_inst_rec.alt_appl_id);
500: fnd_message.set_token('CHOICE_NO',l_oss_ad_appl_inst_rec.choice_number);
501: fnd_message.set_token('BATCH_ID', l_dec_batch_id);
502: fnd_file.put_line(fnd_file.log,fnd_message.get()||l_dec_imp_err);
503: ELSE
504: OPEN cur_per_no(l_oss_ad_appl_inst_rec.person_id);

Line 501: fnd_message.set_token('BATCH_ID', l_dec_batch_id);

497:
498: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_ERR');
499: fnd_message.set_token('APP_NO', l_oss_ad_appl_inst_rec.alt_appl_id);
500: fnd_message.set_token('CHOICE_NO',l_oss_ad_appl_inst_rec.choice_number);
501: fnd_message.set_token('BATCH_ID', l_dec_batch_id);
502: fnd_file.put_line(fnd_file.log,fnd_message.get()||l_dec_imp_err);
503: ELSE
504: OPEN cur_per_no(l_oss_ad_appl_inst_rec.person_id);
505: FETCH cur_per_no INTO l_person_no;

Line 502: fnd_file.put_line(fnd_file.log,fnd_message.get()||l_dec_imp_err);

498: fnd_message.set_name('IGS','IGS_UC_OBS_APP_DEC_IMP_ERR');
499: fnd_message.set_token('APP_NO', l_oss_ad_appl_inst_rec.alt_appl_id);
500: fnd_message.set_token('CHOICE_NO',l_oss_ad_appl_inst_rec.choice_number);
501: fnd_message.set_token('BATCH_ID', l_dec_batch_id);
502: fnd_file.put_line(fnd_file.log,fnd_message.get()||l_dec_imp_err);
503: ELSE
504: OPEN cur_per_no(l_oss_ad_appl_inst_rec.person_id);
505: FETCH cur_per_no INTO l_person_no;
506: CLOSE cur_per_no;

Line 507: fnd_message.set_name('IGS','IGS_UC_OBS_APPL_INST_COMP');

503: ELSE
504: OPEN cur_per_no(l_oss_ad_appl_inst_rec.person_id);
505: FETCH cur_per_no INTO l_person_no;
506: CLOSE cur_per_no;
507: fnd_message.set_name('IGS','IGS_UC_OBS_APPL_INST_COMP');
508: fnd_message.set_token('PER_NO', l_person_no);
509: fnd_message.set_token('APPL_NUM', l_oss_ad_appl_inst_rec.admission_appl_number);
510: fnd_message.set_token('PROG_CD', l_oss_ad_appl_inst_rec.nominated_course_cd);
511: fnd_message.set_token('PROG_VER', l_oss_ad_appl_inst_rec.crv_version_number);

Line 508: fnd_message.set_token('PER_NO', l_person_no);

504: OPEN cur_per_no(l_oss_ad_appl_inst_rec.person_id);
505: FETCH cur_per_no INTO l_person_no;
506: CLOSE cur_per_no;
507: fnd_message.set_name('IGS','IGS_UC_OBS_APPL_INST_COMP');
508: fnd_message.set_token('PER_NO', l_person_no);
509: fnd_message.set_token('APPL_NUM', l_oss_ad_appl_inst_rec.admission_appl_number);
510: fnd_message.set_token('PROG_CD', l_oss_ad_appl_inst_rec.nominated_course_cd);
511: fnd_message.set_token('PROG_VER', l_oss_ad_appl_inst_rec.crv_version_number);
512: fnd_message.set_token('LOC', l_oss_ad_appl_inst_rec.location_cd);

Line 509: fnd_message.set_token('APPL_NUM', l_oss_ad_appl_inst_rec.admission_appl_number);

505: FETCH cur_per_no INTO l_person_no;
506: CLOSE cur_per_no;
507: fnd_message.set_name('IGS','IGS_UC_OBS_APPL_INST_COMP');
508: fnd_message.set_token('PER_NO', l_person_no);
509: fnd_message.set_token('APPL_NUM', l_oss_ad_appl_inst_rec.admission_appl_number);
510: fnd_message.set_token('PROG_CD', l_oss_ad_appl_inst_rec.nominated_course_cd);
511: fnd_message.set_token('PROG_VER', l_oss_ad_appl_inst_rec.crv_version_number);
512: fnd_message.set_token('LOC', l_oss_ad_appl_inst_rec.location_cd);
513: fnd_message.set_token('ATT_TYPE', l_oss_ad_appl_inst_rec.attendance_mode);

Line 510: fnd_message.set_token('PROG_CD', l_oss_ad_appl_inst_rec.nominated_course_cd);

506: CLOSE cur_per_no;
507: fnd_message.set_name('IGS','IGS_UC_OBS_APPL_INST_COMP');
508: fnd_message.set_token('PER_NO', l_person_no);
509: fnd_message.set_token('APPL_NUM', l_oss_ad_appl_inst_rec.admission_appl_number);
510: fnd_message.set_token('PROG_CD', l_oss_ad_appl_inst_rec.nominated_course_cd);
511: fnd_message.set_token('PROG_VER', l_oss_ad_appl_inst_rec.crv_version_number);
512: fnd_message.set_token('LOC', l_oss_ad_appl_inst_rec.location_cd);
513: fnd_message.set_token('ATT_TYPE', l_oss_ad_appl_inst_rec.attendance_mode);
514: fnd_message.set_token('ATT_MODE', l_oss_ad_appl_inst_rec.attendance_type);

Line 511: fnd_message.set_token('PROG_VER', l_oss_ad_appl_inst_rec.crv_version_number);

507: fnd_message.set_name('IGS','IGS_UC_OBS_APPL_INST_COMP');
508: fnd_message.set_token('PER_NO', l_person_no);
509: fnd_message.set_token('APPL_NUM', l_oss_ad_appl_inst_rec.admission_appl_number);
510: fnd_message.set_token('PROG_CD', l_oss_ad_appl_inst_rec.nominated_course_cd);
511: fnd_message.set_token('PROG_VER', l_oss_ad_appl_inst_rec.crv_version_number);
512: fnd_message.set_token('LOC', l_oss_ad_appl_inst_rec.location_cd);
513: fnd_message.set_token('ATT_TYPE', l_oss_ad_appl_inst_rec.attendance_mode);
514: fnd_message.set_token('ATT_MODE', l_oss_ad_appl_inst_rec.attendance_type);
515: fnd_file.put_line(fnd_file.log,fnd_message.get());

Line 512: fnd_message.set_token('LOC', l_oss_ad_appl_inst_rec.location_cd);

508: fnd_message.set_token('PER_NO', l_person_no);
509: fnd_message.set_token('APPL_NUM', l_oss_ad_appl_inst_rec.admission_appl_number);
510: fnd_message.set_token('PROG_CD', l_oss_ad_appl_inst_rec.nominated_course_cd);
511: fnd_message.set_token('PROG_VER', l_oss_ad_appl_inst_rec.crv_version_number);
512: fnd_message.set_token('LOC', l_oss_ad_appl_inst_rec.location_cd);
513: fnd_message.set_token('ATT_TYPE', l_oss_ad_appl_inst_rec.attendance_mode);
514: fnd_message.set_token('ATT_MODE', l_oss_ad_appl_inst_rec.attendance_type);
515: fnd_file.put_line(fnd_file.log,fnd_message.get());
516: END IF ; -- decision import failed or passed

Line 513: fnd_message.set_token('ATT_TYPE', l_oss_ad_appl_inst_rec.attendance_mode);

509: fnd_message.set_token('APPL_NUM', l_oss_ad_appl_inst_rec.admission_appl_number);
510: fnd_message.set_token('PROG_CD', l_oss_ad_appl_inst_rec.nominated_course_cd);
511: fnd_message.set_token('PROG_VER', l_oss_ad_appl_inst_rec.crv_version_number);
512: fnd_message.set_token('LOC', l_oss_ad_appl_inst_rec.location_cd);
513: fnd_message.set_token('ATT_TYPE', l_oss_ad_appl_inst_rec.attendance_mode);
514: fnd_message.set_token('ATT_MODE', l_oss_ad_appl_inst_rec.attendance_type);
515: fnd_file.put_line(fnd_file.log,fnd_message.get());
516: END IF ; -- decision import failed or passed
517:

Line 514: fnd_message.set_token('ATT_MODE', l_oss_ad_appl_inst_rec.attendance_type);

510: fnd_message.set_token('PROG_CD', l_oss_ad_appl_inst_rec.nominated_course_cd);
511: fnd_message.set_token('PROG_VER', l_oss_ad_appl_inst_rec.crv_version_number);
512: fnd_message.set_token('LOC', l_oss_ad_appl_inst_rec.location_cd);
513: fnd_message.set_token('ATT_TYPE', l_oss_ad_appl_inst_rec.attendance_mode);
514: fnd_message.set_token('ATT_MODE', l_oss_ad_appl_inst_rec.attendance_type);
515: fnd_file.put_line(fnd_file.log,fnd_message.get());
516: END IF ; -- decision import failed or passed
517:
518: END LOOP; -- End of the Admission Application Instances Loop FOR UCAS Wrong Applications

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

511: fnd_message.set_token('PROG_VER', l_oss_ad_appl_inst_rec.crv_version_number);
512: fnd_message.set_token('LOC', l_oss_ad_appl_inst_rec.location_cd);
513: fnd_message.set_token('ATT_TYPE', l_oss_ad_appl_inst_rec.attendance_mode);
514: fnd_message.set_token('ATT_MODE', l_oss_ad_appl_inst_rec.attendance_type);
515: fnd_file.put_line(fnd_file.log,fnd_message.get());
516: END IF ; -- decision import failed or passed
517:
518: END LOOP; -- End of the Admission Application Instances Loop FOR UCAS Wrong Applications
519:

Line 547: fnd_message.set_name('IGS','IGS_UC_XPG_APP_CHO_REC_COMP');

543: DELETE igs_uc_ioffer_ints
544: WHERE appno = l_wrong_app_rec.app_no
545: AND choiceno = l_expunge_choice_det(l_loc);
546:
547: fnd_message.set_name('IGS','IGS_UC_XPG_APP_CHO_REC_COMP');
548: fnd_message.set_token('APP_NO', TO_CHAR(l_wrong_app_rec.app_no));
549: fnd_message.set_token('CHOICE_NO',TO_CHAR(l_expunge_choice_det(l_loc)));
550: fnd_file.put_line(fnd_file.log,fnd_message.get());
551:

Line 548: fnd_message.set_token('APP_NO', TO_CHAR(l_wrong_app_rec.app_no));

544: WHERE appno = l_wrong_app_rec.app_no
545: AND choiceno = l_expunge_choice_det(l_loc);
546:
547: fnd_message.set_name('IGS','IGS_UC_XPG_APP_CHO_REC_COMP');
548: fnd_message.set_token('APP_NO', TO_CHAR(l_wrong_app_rec.app_no));
549: fnd_message.set_token('CHOICE_NO',TO_CHAR(l_expunge_choice_det(l_loc)));
550: fnd_file.put_line(fnd_file.log,fnd_message.get());
551:
552: END IF;

Line 549: fnd_message.set_token('CHOICE_NO',TO_CHAR(l_expunge_choice_det(l_loc)));

545: AND choiceno = l_expunge_choice_det(l_loc);
546:
547: fnd_message.set_name('IGS','IGS_UC_XPG_APP_CHO_REC_COMP');
548: fnd_message.set_token('APP_NO', TO_CHAR(l_wrong_app_rec.app_no));
549: fnd_message.set_token('CHOICE_NO',TO_CHAR(l_expunge_choice_det(l_loc)));
550: fnd_file.put_line(fnd_file.log,fnd_message.get());
551:
552: END IF;
553:

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

546:
547: fnd_message.set_name('IGS','IGS_UC_XPG_APP_CHO_REC_COMP');
548: fnd_message.set_token('APP_NO', TO_CHAR(l_wrong_app_rec.app_no));
549: fnd_message.set_token('CHOICE_NO',TO_CHAR(l_expunge_choice_det(l_loc)));
550: fnd_file.put_line(fnd_file.log,fnd_message.get());
551:
552: END IF;
553:
554: END LOOP; -- End of the Choices (pl/sql table) Loop FOR UCAS Wrong Application

Line 609: fnd_message.set_name('IGS','IGS_UC_END_DT_ALT_PID_COMP');

605: x_attribute19 => l_alt_pers_id_rec.attribute19,
606: x_attribute20 => l_alt_pers_id_rec.attribute20,
607: x_region_cd => l_alt_pers_id_rec.region_cd);
608:
609: fnd_message.set_name('IGS','IGS_UC_END_DT_ALT_PID_COMP');
610: fnd_message.set_token('APP_NO', l_wrong_app_rec.app_no);
611: fnd_file.put_line(fnd_file.log,fnd_message.get());
612: EXCEPTION
613: WHEN OTHERS THEN

Line 610: fnd_message.set_token('APP_NO', l_wrong_app_rec.app_no);

606: x_attribute20 => l_alt_pers_id_rec.attribute20,
607: x_region_cd => l_alt_pers_id_rec.region_cd);
608:
609: fnd_message.set_name('IGS','IGS_UC_END_DT_ALT_PID_COMP');
610: fnd_message.set_token('APP_NO', l_wrong_app_rec.app_no);
611: fnd_file.put_line(fnd_file.log,fnd_message.get());
612: EXCEPTION
613: WHEN OTHERS THEN
614: l_pe_alt_pers_id_closed := 'N';

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

607: x_region_cd => l_alt_pers_id_rec.region_cd);
608:
609: fnd_message.set_name('IGS','IGS_UC_END_DT_ALT_PID_COMP');
610: fnd_message.set_token('APP_NO', l_wrong_app_rec.app_no);
611: fnd_file.put_line(fnd_file.log,fnd_message.get());
612: EXCEPTION
613: WHEN OTHERS THEN
614: l_pe_alt_pers_id_closed := 'N';
615: l_mesg_data := NULL;

Line 621: fnd_message.set_name('IGS','IGS_UC_END_DT_ALT_PID_ERR');

617: OPEN cur_per_no(l_alt_pers_id_rec.pe_person_id);
618: FETCH cur_per_no INTO l_person_no;
619: CLOSE cur_per_no;
620: IGS_GE_MSG_STACK.GET(IGS_GE_MSG_STACK.COUNT_MSG,FND_API.G_FALSE, l_mesg_data, l_msg_index);
621: fnd_message.set_name('IGS','IGS_UC_END_DT_ALT_PID_ERR');
622: fnd_message.set_token('PER_NO', l_person_no);
623: fnd_message.set_token('ALT_PID', l_alt_pers_id_rec.api_person_id);
624: fnd_message.set_token('PID_TYPE',l_alt_pers_id_rec.person_id_type);
625: fnd_file.put_line(fnd_file.log,fnd_message.get()||' - '||l_mesg_data);

Line 622: fnd_message.set_token('PER_NO', l_person_no);

618: FETCH cur_per_no INTO l_person_no;
619: CLOSE cur_per_no;
620: IGS_GE_MSG_STACK.GET(IGS_GE_MSG_STACK.COUNT_MSG,FND_API.G_FALSE, l_mesg_data, l_msg_index);
621: fnd_message.set_name('IGS','IGS_UC_END_DT_ALT_PID_ERR');
622: fnd_message.set_token('PER_NO', l_person_no);
623: fnd_message.set_token('ALT_PID', l_alt_pers_id_rec.api_person_id);
624: fnd_message.set_token('PID_TYPE',l_alt_pers_id_rec.person_id_type);
625: fnd_file.put_line(fnd_file.log,fnd_message.get()||' - '||l_mesg_data);
626: END;

Line 623: fnd_message.set_token('ALT_PID', l_alt_pers_id_rec.api_person_id);

619: CLOSE cur_per_no;
620: IGS_GE_MSG_STACK.GET(IGS_GE_MSG_STACK.COUNT_MSG,FND_API.G_FALSE, l_mesg_data, l_msg_index);
621: fnd_message.set_name('IGS','IGS_UC_END_DT_ALT_PID_ERR');
622: fnd_message.set_token('PER_NO', l_person_no);
623: fnd_message.set_token('ALT_PID', l_alt_pers_id_rec.api_person_id);
624: fnd_message.set_token('PID_TYPE',l_alt_pers_id_rec.person_id_type);
625: fnd_file.put_line(fnd_file.log,fnd_message.get()||' - '||l_mesg_data);
626: END;
627: END IF;

Line 624: fnd_message.set_token('PID_TYPE',l_alt_pers_id_rec.person_id_type);

620: IGS_GE_MSG_STACK.GET(IGS_GE_MSG_STACK.COUNT_MSG,FND_API.G_FALSE, l_mesg_data, l_msg_index);
621: fnd_message.set_name('IGS','IGS_UC_END_DT_ALT_PID_ERR');
622: fnd_message.set_token('PER_NO', l_person_no);
623: fnd_message.set_token('ALT_PID', l_alt_pers_id_rec.api_person_id);
624: fnd_message.set_token('PID_TYPE',l_alt_pers_id_rec.person_id_type);
625: fnd_file.put_line(fnd_file.log,fnd_message.get()||' - '||l_mesg_data);
626: END;
627: END IF;
628: CLOSE cur_alt_pers_id;

Line 625: fnd_file.put_line(fnd_file.log,fnd_message.get()||' - '||l_mesg_data);

621: fnd_message.set_name('IGS','IGS_UC_END_DT_ALT_PID_ERR');
622: fnd_message.set_token('PER_NO', l_person_no);
623: fnd_message.set_token('ALT_PID', l_alt_pers_id_rec.api_person_id);
624: fnd_message.set_token('PID_TYPE',l_alt_pers_id_rec.person_id_type);
625: fnd_file.put_line(fnd_file.log,fnd_message.get()||' - '||l_mesg_data);
626: END;
627: END IF;
628: CLOSE cur_alt_pers_id;
629:

Line 640: fnd_message.set_name('IGS','IGS_UC_XPG_INT_REC_COMP');

636: l_ucas_app_recs_deleted := 'Y';
637: BEGIN
638: --Call the sub procedure to delete Wrong Applicant records from UCAS Interface tables.
639: delete_ucas_interface_rec(l_wrong_app_rec.app_no);
640: fnd_message.set_name('IGS','IGS_UC_XPG_INT_REC_COMP');
641: fnd_file.put_line(fnd_file.log,fnd_message.get());
642: EXCEPTION
643: WHEN OTHERS THEN
644: l_ucas_app_recs_deleted := 'N';

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

637: BEGIN
638: --Call the sub procedure to delete Wrong Applicant records from UCAS Interface tables.
639: delete_ucas_interface_rec(l_wrong_app_rec.app_no);
640: fnd_message.set_name('IGS','IGS_UC_XPG_INT_REC_COMP');
641: fnd_file.put_line(fnd_file.log,fnd_message.get());
642: EXCEPTION
643: WHEN OTHERS THEN
644: l_ucas_app_recs_deleted := 'N';
645: l_mesg_data := NULL;

Line 648: fnd_message.set_name('IGS','IGS_UC_XPG_INT_REC_ERR');

644: l_ucas_app_recs_deleted := 'N';
645: l_mesg_data := NULL;
646: l_msg_index := NULL;
647: IGS_GE_MSG_STACK.GET(IGS_GE_MSG_STACK.COUNT_MSG,FND_API.G_FALSE, l_mesg_data, l_msg_index);
648: fnd_message.set_name('IGS','IGS_UC_XPG_INT_REC_ERR');
649: fnd_message.set_token('APP_NO', l_wrong_app_rec.app_no);
650: fnd_file.put_line(fnd_file.log,fnd_message.get()||' - '||l_mesg_data);
651: END;
652: END IF; ----End of Check FOR all oss applications are suspended and Alternate IDs are end dated.

Line 649: fnd_message.set_token('APP_NO', l_wrong_app_rec.app_no);

645: l_mesg_data := NULL;
646: l_msg_index := NULL;
647: IGS_GE_MSG_STACK.GET(IGS_GE_MSG_STACK.COUNT_MSG,FND_API.G_FALSE, l_mesg_data, l_msg_index);
648: fnd_message.set_name('IGS','IGS_UC_XPG_INT_REC_ERR');
649: fnd_message.set_token('APP_NO', l_wrong_app_rec.app_no);
650: fnd_file.put_line(fnd_file.log,fnd_message.get()||' - '||l_mesg_data);
651: END;
652: END IF; ----End of Check FOR all oss applications are suspended and Alternate IDs are end dated.
653:

Line 650: fnd_file.put_line(fnd_file.log,fnd_message.get()||' - '||l_mesg_data);

646: l_msg_index := NULL;
647: IGS_GE_MSG_STACK.GET(IGS_GE_MSG_STACK.COUNT_MSG,FND_API.G_FALSE, l_mesg_data, l_msg_index);
648: fnd_message.set_name('IGS','IGS_UC_XPG_INT_REC_ERR');
649: fnd_message.set_token('APP_NO', l_wrong_app_rec.app_no);
650: fnd_file.put_line(fnd_file.log,fnd_message.get()||' - '||l_mesg_data);
651: END;
652: END IF; ----End of Check FOR all oss applications are suspended and Alternate IDs are end dated.
653:
654: -- IGS_UC_WRONG_APP.EXPUNGED can be set to 'Y' in following 2 conditions.

Line 685: fnd_message.set_name('IGS','IGS_UC_XPG_APP_NO_REC_COMP');

681: x_choice6_lost => l_wrong_app_rec.choice6_lost,
682: x_choice7_lost => l_wrong_app_rec.choice7_lost);
683: -- Display the Application level expunge message only when complete Application details are expunged.
684: IF l_ucas_app_expunged = 'Y' THEN
685: fnd_message.set_name('IGS','IGS_UC_XPG_APP_NO_REC_COMP');
686: fnd_message.set_token('APP_NO', l_wrong_app_rec.app_no);
687: fnd_file.put_line(fnd_file.log,fnd_message.get());
688: fnd_file.put_line(fnd_file.log,' ');
689: END IF;

Line 686: fnd_message.set_token('APP_NO', l_wrong_app_rec.app_no);

682: x_choice7_lost => l_wrong_app_rec.choice7_lost);
683: -- Display the Application level expunge message only when complete Application details are expunged.
684: IF l_ucas_app_expunged = 'Y' THEN
685: fnd_message.set_name('IGS','IGS_UC_XPG_APP_NO_REC_COMP');
686: fnd_message.set_token('APP_NO', l_wrong_app_rec.app_no);
687: fnd_file.put_line(fnd_file.log,fnd_message.get());
688: fnd_file.put_line(fnd_file.log,' ');
689: END IF;
690: EXCEPTION

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

683: -- Display the Application level expunge message only when complete Application details are expunged.
684: IF l_ucas_app_expunged = 'Y' THEN
685: fnd_message.set_name('IGS','IGS_UC_XPG_APP_NO_REC_COMP');
686: fnd_message.set_token('APP_NO', l_wrong_app_rec.app_no);
687: fnd_file.put_line(fnd_file.log,fnd_message.get());
688: fnd_file.put_line(fnd_file.log,' ');
689: END IF;
690: EXCEPTION
691: WHEN OTHERS THEN

Line 695: fnd_message.set_name('IGS','IGS_UC_MARK_APP_EXPUNGED_ERR');

691: WHEN OTHERS THEN
692: l_mesg_data := NULL;
693: l_msg_index := NULL;
694: IGS_GE_MSG_STACK.GET(IGS_GE_MSG_STACK.COUNT_MSG,FND_API.G_FALSE, l_mesg_data, l_msg_index);
695: fnd_message.set_name('IGS','IGS_UC_MARK_APP_EXPUNGED_ERR');
696: fnd_message.set_token('APP_NO', l_wrong_app_rec.app_no);
697: fnd_file.put_line(fnd_file.log,fnd_message.get()||' - '||l_mesg_data);
698: END;
699: END IF;

Line 696: fnd_message.set_token('APP_NO', l_wrong_app_rec.app_no);

692: l_mesg_data := NULL;
693: l_msg_index := NULL;
694: IGS_GE_MSG_STACK.GET(IGS_GE_MSG_STACK.COUNT_MSG,FND_API.G_FALSE, l_mesg_data, l_msg_index);
695: fnd_message.set_name('IGS','IGS_UC_MARK_APP_EXPUNGED_ERR');
696: fnd_message.set_token('APP_NO', l_wrong_app_rec.app_no);
697: fnd_file.put_line(fnd_file.log,fnd_message.get()||' - '||l_mesg_data);
698: END;
699: END IF;
700:

Line 697: fnd_file.put_line(fnd_file.log,fnd_message.get()||' - '||l_mesg_data);

693: l_msg_index := NULL;
694: IGS_GE_MSG_STACK.GET(IGS_GE_MSG_STACK.COUNT_MSG,FND_API.G_FALSE, l_mesg_data, l_msg_index);
695: fnd_message.set_name('IGS','IGS_UC_MARK_APP_EXPUNGED_ERR');
696: fnd_message.set_token('APP_NO', l_wrong_app_rec.app_no);
697: fnd_file.put_line(fnd_file.log,fnd_message.get()||' - '||l_mesg_data);
698: END;
699: END IF;
700:
701: END LOOP; -- End of the UCAS Wrong Applications Loop

Line 709: fnd_message.set_name( 'IGS','IGS_GE_UNHANDLED_EXP');

705: EXCEPTION
706: WHEN OTHERS THEN
707: ROLLBACK;
708: retcode := 2;
709: fnd_message.set_name( 'IGS','IGS_GE_UNHANDLED_EXP');
710: fnd_message.set_token('NAME','igs_uc_expunge_app.expunge_proc'||' - '||SQLERRM);
711: errbuf := fnd_message.get;
712: igs_ge_msg_stack.conc_exception_hndl;
713:

Line 710: fnd_message.set_token('NAME','igs_uc_expunge_app.expunge_proc'||' - '||SQLERRM);

706: WHEN OTHERS THEN
707: ROLLBACK;
708: retcode := 2;
709: fnd_message.set_name( 'IGS','IGS_GE_UNHANDLED_EXP');
710: fnd_message.set_token('NAME','igs_uc_expunge_app.expunge_proc'||' - '||SQLERRM);
711: errbuf := fnd_message.get;
712: igs_ge_msg_stack.conc_exception_hndl;
713:
714: END expunge_proc;

Line 711: errbuf := fnd_message.get;

707: ROLLBACK;
708: retcode := 2;
709: fnd_message.set_name( 'IGS','IGS_GE_UNHANDLED_EXP');
710: fnd_message.set_token('NAME','igs_uc_expunge_app.expunge_proc'||' - '||SQLERRM);
711: errbuf := fnd_message.get;
712: igs_ge_msg_stack.conc_exception_hndl;
713:
714: END expunge_proc;
715: