[Home] [Help]
141: IF NVL(FND_PROFILE.VALUE('OSS_COUNTRY_CODE'),'*') = 'GB'
142: AND (x_degree_attempted IS NOT NULL
143: OR x_degree_earned IS NOT NULL
144: OR x_program_code IS NOT NULL) THEN
145: Fnd_Message.Set_Name ('IGS', 'IGS_AD_GB_ACAD_HIST');
146: IGS_GE_MSG_STACK.ADD;
147: App_Exception.Raise_Exception;
148: END IF;
149:
151: OPEN c_school_attended_name(x_institution_code);
152: FETCH c_school_attended_name INTO lv_school_attended_name;
153: CLOSE c_school_attended_name;
154: IF lv_school_attended_name <> x_school_attended_name THEN
155: Fnd_Message.Set_Name ('IGS', 'IGS_AD_INVALID_INST');
156: IGS_GE_MSG_STACK.ADD;
157: App_Exception.Raise_Exception;
158: END IF;
159: END IF;
164: lv_degree := NULL;
165: FETCH c_degree_code INTO lv_degree;
166: CLOSE c_degree_code;
167: IF lv_degree IS NULL THEN
168: Fnd_Message.Set_Name ('IGS', 'IGS_AD_INVALID_DEG_EARNED');
169: IGS_GE_MSG_STACK.ADD;
170: App_Exception.Raise_Exception;
171: END IF;
172: END IF;
177: lv_degree := NULL;
178: FETCH c_degree_code INTO lv_degree;
179: CLOSE c_degree_code;
180: IF lv_degree IS NULL THEN
181: Fnd_Message.Set_Name ('IGS', 'IGS_AD_INVALID_DEG_ATTEMPTED');
182: IGS_GE_MSG_STACK.ADD;
183: App_Exception.Raise_Exception;
184: END IF;
185: END IF;
186:
187: -- Validate Start Date and End Date
188: IF x_start_date IS NOT NULL AND x_end_date IS NOT NULL THEN
189: IF x_end_date < x_start_date THEN
190: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_INVALID_DATE');
191: IGS_GE_MSG_STACK.ADD;
192: APP_EXCEPTION.RAISE_EXCEPTION;
193: END IF;
194: END IF;
198: OPEN get_dob_dt_cur(x_person_id);
199: FETCH get_dob_dt_cur INTO l_birth_dt;
200: CLOSE get_dob_dt_cur;
201: IF l_birth_dt IS NOT NULL AND l_birth_dt > l_education_rec.start_date_attended THEN
202: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_STRT_DT_LESS_BIRTH_DT');
203: IGS_GE_MSG_STACK.ADD;
204: APP_EXCEPTION.RAISE_EXCEPTION;
205: END IF;
206: END IF;
211: OPEN get_dob_dt_cur(x_person_id);
212: FETCH get_dob_dt_cur INTO l_birth_dt;
213: CLOSE get_dob_dt_cur;
214: IF l_birth_dt IS NOT NULL AND x_start_date IS NOT NULL AND l_birth_dt > x_start_date THEN
215: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_STRT_DT_LESS_BIRTH_DT');
216: IGS_GE_MSG_STACK.ADD;
217: APP_EXCEPTION.RAISE_EXCEPTION;
218: END IF;
219:
217: APP_EXCEPTION.RAISE_EXCEPTION;
218: END IF;
219:
220: IF l_birth_dt IS NOT NULL AND x_end_date IS NOT NULL AND l_birth_dt > x_end_date THEN
221: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_ENDDT_LESS_BIRTHDT');
222: IGS_GE_MSG_STACK.ADD;
223: APP_EXCEPTION.RAISE_EXCEPTION;
224: END IF;
225: END IF;
503: nvl(old_degree_earned,'NulL') <> nvl(x_degree_earned,'NulL') or
504: nvl(old_program_code,'NulL') <> nvl(x_program_code,'NulL')
505: )
506: THEN
507: Fnd_Message.Set_Name ('IGS', 'IGS_AD_GB_ACAD_HIST');
508: IGS_GE_MSG_STACK.ADD;
509: App_Exception.Raise_Exception;
510: END IF;
511:
514: OPEN c_school_attended_name(x_institution_code);
515: FETCH c_school_attended_name INTO lv_school_attended_name;
516: CLOSE c_school_attended_name;
517: IF lv_school_attended_name <> x_school_attended_name THEN
518: Fnd_Message.Set_Name ('IGS', 'IGS_AD_INVALID_INST');
519: IGS_GE_MSG_STACK.ADD;
520: App_Exception.Raise_Exception;
521: END IF;
522: END IF;
527: lv_degree := NULL;
528: FETCH c_degree_code INTO lv_degree;
529: CLOSE c_degree_code;
530: IF lv_degree IS NULL THEN
531: Fnd_Message.Set_Name ('IGS', 'IGS_AD_INVALID_DEGREE_EARNED');
532: IGS_GE_MSG_STACK.ADD;
533: App_Exception.Raise_Exception;
534: END IF;
535: END IF;
536:
537: -- Validate Start Date and End Date
538: IF x_start_date IS NOT NULL AND x_end_date IS NOT NULL THEN
539: IF x_end_date < x_start_date THEN
540: FND_MESSAGE.SET_NAME ('IGS', 'IGS_GE_INVALID_DATE');
541: IGS_GE_MSG_STACK.ADD;
542: APP_EXCEPTION.RAISE_EXCEPTION;
543: END IF;
544: END IF;
549: OPEN get_dob_dt_cur(x_person_id);
550: FETCH get_dob_dt_cur INTO l_birth_dt;
551: CLOSE get_dob_dt_cur;
552: IF l_birth_dt IS NOT NULL AND x_start_date IS NOT NULL AND l_birth_dt > x_start_date THEN
553: FND_MESSAGE.SET_NAME ('IGS', 'IGS_AD_STRT_DT_LESS_BIRTH_DT');
554: IGS_GE_MSG_STACK.ADD;
555: APP_EXCEPTION.RAISE_EXCEPTION;
556: END IF;
557:
555: APP_EXCEPTION.RAISE_EXCEPTION;
556: END IF;
557:
558: IF l_birth_dt IS NOT NULL AND x_end_date IS NOT NULL AND l_birth_dt > x_end_date THEN
559: FND_MESSAGE.SET_NAME ('IGS', 'IGS_PE_ENDDT_LESS_BIRTHDT');
560: IGS_GE_MSG_STACK.ADD;
561: APP_EXCEPTION.RAISE_EXCEPTION;
562: END IF;
563: END IF;
568: lv_degree := NULL;
569: FETCH c_degree_code INTO lv_degree;
570: CLOSE c_degree_code;
571: IF lv_degree IS NULL THEN
572: Fnd_Message.Set_Name ('IGS', 'IGS_AD_INVALID_DEGREE_ATTEMPTED');
573: IGS_GE_MSG_STACK.ADD;
574: App_Exception.Raise_Exception;
575: END IF;
576: END IF;
579: OPEN c_adv_standing(x_institution_code, x_person_id);
580: FETCH c_adv_standing INTO lv_adv_standing_exists;
581: CLOSE c_adv_standing;
582: IF lv_adv_standing_exists = '1' THEN
583: Fnd_Message.Set_Name ('IGS', 'IGS_AD_ADV_STD_DTLS_EXTS');
584: IGS_GE_MSG_STACK.ADD;
585: App_Exception.Raise_Exception;
586: END IF;
587: END IF;
622:
623: IF l_active_ind = 'I' THEN
624:
625: IF nvl(x_status, 'I') = 'I' OR (x_status = 'A' AND l_count IS NOT NULL) THEN
626: Fnd_Message.Set_Name ('IGS', 'IGS_AD_INACTIVE_ACAD_HIST');
627: IGS_GE_MSG_STACK.ADD;
628: App_Exception.Raise_Exception;
629: END IF;
630: