328: END IF;
329: EXCEPTION
330: WHEN OTHERS THEN
331: retcode:=2;
332: errbuf := fnd_message.get_string('IGS','IGS_GE_UNHANDLED_EXCEPTION');
333: Igs_Ge_Msg_Stack.conc_exception_hndl;
334: RETURN;
335: END admp_val_offer_defer_term;
336:
619: p_routeb_pref => c_appl_inst_rec.routeb_pref,
620: p_alt_appl_id => c_appl_inst_rec.alt_appl_id ) = FALSE THEN
621:
622: fnd_file.put_line(fnd_file.log, 'Application could not be created');
623: fnd_message.set_name('IGS', l_message_name);
624: fnd_file.put_line(fnd_file.log, fnd_message.get);
625: RETURN FALSE;
626:
627: ELSE -- Else for Application
620: p_alt_appl_id => c_appl_inst_rec.alt_appl_id ) = FALSE THEN
621:
622: fnd_file.put_line(fnd_file.log, 'Application could not be created');
623: fnd_message.set_name('IGS', l_message_name);
624: fnd_file.put_line(fnd_file.log, fnd_message.get);
625: RETURN FALSE;
626:
627: ELSE -- Else for Application
628: IF IGS_AD_GEN_014.insert_adm_appl_prog(
720: RETURN TRUE;
721: ELSE -- Else of Application Instance
722: IF l_message_name IN ('IGS_AD_NOMINATE_PRG_OFR_ENTRY', 'IGS_AD_NOMINATED_PRG_ENTRYPNT') THEN
723: l_message_name := 'IGS_AD_CAL_PGM_NOT_OFFER';
724: fnd_message.set_name('IGS', l_message_name);
725: fnd_message.set_token('PGM', c_appl_inst_rec.nominated_course_cd);
726: fnd_message.set_token('ALTCODE', c_appl_inst_rec.acad_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.acad_ci_sequence_number)
727: || '/' || c_appl_inst_rec.final_adm_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.final_adm_ci_sequence_number) );
728: fnd_file.put_line(fnd_file.log, 'Application could not be created');
721: ELSE -- Else of Application Instance
722: IF l_message_name IN ('IGS_AD_NOMINATE_PRG_OFR_ENTRY', 'IGS_AD_NOMINATED_PRG_ENTRYPNT') THEN
723: l_message_name := 'IGS_AD_CAL_PGM_NOT_OFFER';
724: fnd_message.set_name('IGS', l_message_name);
725: fnd_message.set_token('PGM', c_appl_inst_rec.nominated_course_cd);
726: fnd_message.set_token('ALTCODE', c_appl_inst_rec.acad_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.acad_ci_sequence_number)
727: || '/' || c_appl_inst_rec.final_adm_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.final_adm_ci_sequence_number) );
728: fnd_file.put_line(fnd_file.log, 'Application could not be created');
729: fnd_file.put_line(fnd_file.log, fnd_message.get);
722: IF l_message_name IN ('IGS_AD_NOMINATE_PRG_OFR_ENTRY', 'IGS_AD_NOMINATED_PRG_ENTRYPNT') THEN
723: l_message_name := 'IGS_AD_CAL_PGM_NOT_OFFER';
724: fnd_message.set_name('IGS', l_message_name);
725: fnd_message.set_token('PGM', c_appl_inst_rec.nominated_course_cd);
726: fnd_message.set_token('ALTCODE', c_appl_inst_rec.acad_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.acad_ci_sequence_number)
727: || '/' || c_appl_inst_rec.final_adm_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.final_adm_ci_sequence_number) );
728: fnd_file.put_line(fnd_file.log, 'Application could not be created');
729: fnd_file.put_line(fnd_file.log, fnd_message.get);
730: ELSE
725: fnd_message.set_token('PGM', c_appl_inst_rec.nominated_course_cd);
726: fnd_message.set_token('ALTCODE', c_appl_inst_rec.acad_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.acad_ci_sequence_number)
727: || '/' || c_appl_inst_rec.final_adm_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_inst_rec.final_adm_ci_sequence_number) );
728: fnd_file.put_line(fnd_file.log, 'Application could not be created');
729: fnd_file.put_line(fnd_file.log, fnd_message.get);
730: ELSE
731: fnd_file.put_line(fnd_file.log, 'Application could not be created');
732: fnd_message.set_name('IGS', l_message_name);
733: fnd_file.put_line(fnd_file.log, fnd_message.get);
728: fnd_file.put_line(fnd_file.log, 'Application could not be created');
729: fnd_file.put_line(fnd_file.log, fnd_message.get);
730: ELSE
731: fnd_file.put_line(fnd_file.log, 'Application could not be created');
732: fnd_message.set_name('IGS', l_message_name);
733: fnd_file.put_line(fnd_file.log, fnd_message.get);
734: END IF;
735: RETURN FALSE;
736: END IF;
729: fnd_file.put_line(fnd_file.log, fnd_message.get);
730: ELSE
731: fnd_file.put_line(fnd_file.log, 'Application could not be created');
732: fnd_message.set_name('IGS', l_message_name);
733: fnd_file.put_line(fnd_file.log, fnd_message.get);
734: END IF;
735: RETURN FALSE;
736: END IF;
737: RETURN FALSE;
736: END IF;
737: RETURN FALSE;
738: ELSE -- Else for Application Program
739: fnd_file.put_line(fnd_file.log, 'Application could not be created');
740: fnd_message.set_name('IGS', l_message_name);
741: fnd_file.put_line(fnd_file.log, fnd_message.get);
742: RETURN FALSE;
743: END IF;
744: END IF;
737: RETURN FALSE;
738: ELSE -- Else for Application Program
739: fnd_file.put_line(fnd_file.log, 'Application could not be created');
740: fnd_message.set_name('IGS', l_message_name);
741: fnd_file.put_line(fnd_file.log, fnd_message.get);
742: RETURN FALSE;
743: END IF;
744: END IF;
745: END LOOP;
969: igs_ad_gen_009.admp_get_sys_aos(cst_offer),
970: c_appl_offer_rec.adm_cal_type,
971: c_appl_offer_rec.adm_ci_sequence_number,
972: v_message_name) = FALSE THEN
973: fnd_message.set_name('IGS', v_message_name);
974: fnd_file.put_line(fnd_file.log, fnd_message.get);
975: END IF;
976: -- calculate the offer response date if the user doesn't passes the value
977: IF p_offer_response_dt IS NULL THEN
970: c_appl_offer_rec.adm_cal_type,
971: c_appl_offer_rec.adm_ci_sequence_number,
972: v_message_name) = FALSE THEN
973: fnd_message.set_name('IGS', v_message_name);
974: fnd_file.put_line(fnd_file.log, fnd_message.get);
975: END IF;
976: -- calculate the offer response date if the user doesn't passes the value
977: IF p_offer_response_dt IS NULL THEN
978:
994: END IF;
995:
996: IF l_offer_response_dt IS NOT NULL THEN
997: IF l_offer_response_dt < p_offer_dt THEN
998: fnd_message.set_name('IGS', 'IGS_AD_OFR_RSPDT_GE_OFRDT');
999: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1000: fnd_file.put_line(fnd_file.log, fnd_message.get);
1001: RETURN FALSE;
1002: END IF;
996: IF l_offer_response_dt IS NOT NULL THEN
997: IF l_offer_response_dt < p_offer_dt THEN
998: fnd_message.set_name('IGS', 'IGS_AD_OFR_RSPDT_GE_OFRDT');
999: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1000: fnd_file.put_line(fnd_file.log, fnd_message.get);
1001: RETURN FALSE;
1002: END IF;
1003: END IF;
1004:
1176: IF IGS_AD_VAL_ACAI.admp_val_acai_ec (
1177: l_adm_cat,
1178: c_appl_offer_rec.enrolment_cat,
1179: v_message_name) = FALSE THEN
1180: fnd_message.set_name('IGS', v_message_name);
1181: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1182: fnd_file.put_line(fnd_file.log, fnd_message.get);
1183: RETURN FALSE;
1184: END IF;
1178: c_appl_offer_rec.enrolment_cat,
1179: v_message_name) = FALSE THEN
1180: fnd_message.set_name('IGS', v_message_name);
1181: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1182: fnd_file.put_line(fnd_file.log, fnd_message.get);
1183: RETURN FALSE;
1184: END IF;
1185:
1186: -- rrengara
1195: c_appl_offer_rec.sequence_number,
1196: 'N', -- Confirm course indicator.
1197: 'N', -- Perform eligibility check indicator.
1198: v_message_name) = FALSE THEN
1199: fnd_message.set_name('IGS', v_message_name);
1200: fnd_file.put_line(fnd_file.log, 'Application could not be created'); -- added - apadegal adtd001 igs.m
1201: fnd_file.put_line(fnd_file.log, fnd_message.get);
1202: RETURN FALSE; -- added - apadegal adtd001 igs.m
1203: END IF;
1197: 'N', -- Perform eligibility check indicator.
1198: v_message_name) = FALSE THEN
1199: fnd_message.set_name('IGS', v_message_name);
1200: fnd_file.put_line(fnd_file.log, 'Application could not be created'); -- added - apadegal adtd001 igs.m
1201: fnd_file.put_line(fnd_file.log, fnd_message.get);
1202: RETURN FALSE; -- added - apadegal adtd001 igs.m
1203: END IF;
1204: END IF; -- PRE-ENROLL IND = 'Y'
1205: ELSE
1204: END IF; -- PRE-ENROLL IND = 'Y'
1205: ELSE
1206: IF v_message_name IN ('IGS_AD_NOMINATE_PRG_OFR_ENTRY', 'IGS_AD_NOMINATED_PRG_ENTRYPNT') THEN
1207: v_message_name := 'IGS_AD_CAL_PGM_NOT_OFFER';
1208: fnd_message.set_name('IGS', v_message_name);
1209: fnd_message.set_token('PGM', c_appl_offer_rec.nominated_course_cd);
1210: fnd_message.set_token('ALTCODE', c_appl_offer_rec.acad_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_offer_rec.acad_ci_sequence_number)
1211: || '/' || c_appl_offer_rec.final_adm_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_offer_rec.final_adm_ci_sequence_number) );
1212: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1205: ELSE
1206: IF v_message_name IN ('IGS_AD_NOMINATE_PRG_OFR_ENTRY', 'IGS_AD_NOMINATED_PRG_ENTRYPNT') THEN
1207: v_message_name := 'IGS_AD_CAL_PGM_NOT_OFFER';
1208: fnd_message.set_name('IGS', v_message_name);
1209: fnd_message.set_token('PGM', c_appl_offer_rec.nominated_course_cd);
1210: fnd_message.set_token('ALTCODE', c_appl_offer_rec.acad_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_offer_rec.acad_ci_sequence_number)
1211: || '/' || c_appl_offer_rec.final_adm_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_offer_rec.final_adm_ci_sequence_number) );
1212: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1213: fnd_file.put_line(fnd_file.log, fnd_message.get);
1206: IF v_message_name IN ('IGS_AD_NOMINATE_PRG_OFR_ENTRY', 'IGS_AD_NOMINATED_PRG_ENTRYPNT') THEN
1207: v_message_name := 'IGS_AD_CAL_PGM_NOT_OFFER';
1208: fnd_message.set_name('IGS', v_message_name);
1209: fnd_message.set_token('PGM', c_appl_offer_rec.nominated_course_cd);
1210: fnd_message.set_token('ALTCODE', c_appl_offer_rec.acad_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_offer_rec.acad_ci_sequence_number)
1211: || '/' || c_appl_offer_rec.final_adm_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_offer_rec.final_adm_ci_sequence_number) );
1212: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1213: fnd_file.put_line(fnd_file.log, fnd_message.get);
1214: ELSE
1209: fnd_message.set_token('PGM', c_appl_offer_rec.nominated_course_cd);
1210: fnd_message.set_token('ALTCODE', c_appl_offer_rec.acad_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_offer_rec.acad_ci_sequence_number)
1211: || '/' || c_appl_offer_rec.final_adm_cal_type || ',' || IGS_GE_NUMBER.TO_CANN(c_appl_offer_rec.final_adm_ci_sequence_number) );
1212: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1213: fnd_file.put_line(fnd_file.log, fnd_message.get);
1214: ELSE
1215: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1216: fnd_message.set_name('IGS', v_message_name);
1217: fnd_file.put_line(fnd_file.log, fnd_message.get);
1212: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1213: fnd_file.put_line(fnd_file.log, fnd_message.get);
1214: ELSE
1215: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1216: fnd_message.set_name('IGS', v_message_name);
1217: fnd_file.put_line(fnd_file.log, fnd_message.get);
1218: END IF;
1219: RETURN FALSE;
1220: END IF;
1213: fnd_file.put_line(fnd_file.log, fnd_message.get);
1214: ELSE
1215: fnd_file.put_line(fnd_file.log, 'Application could not be created');
1216: fnd_message.set_name('IGS', v_message_name);
1217: fnd_file.put_line(fnd_file.log, fnd_message.get);
1218: END IF;
1219: RETURN FALSE;
1220: END IF;
1221: END LOOP;
1749: cur_application_details_rec.sequence_number,
1750: 'Y', -- Confirm course indicator.
1751: 'Y', -- Perform eligibility check indicator.
1752: v_message_name) = FALSE THEN
1753: fnd_message.set_name('IGS', v_message_name);
1754: fnd_file.put_line(fnd_file.log, 'Application could not be created'); -- added - apadegal adtd001 igs.m
1755: fnd_file.put_line(fnd_file.log, fnd_message.get);
1756: RETURN FALSE ; -- added - apadegal adtd001 igs.m
1757: END IF;
1751: 'Y', -- Perform eligibility check indicator.
1752: v_message_name) = FALSE THEN
1753: fnd_message.set_name('IGS', v_message_name);
1754: fnd_file.put_line(fnd_file.log, 'Application could not be created'); -- added - apadegal adtd001 igs.m
1755: fnd_file.put_line(fnd_file.log, fnd_message.get);
1756: RETURN FALSE ; -- added - apadegal adtd001 igs.m
1757: END IF;
1758:
1759: RETURN TRUE; -- added - apadegal adtd001 igs.m