APPS.IGS_AD_ACAD_HISTORY_PKG dependencies on APP_EXCEPTION

Line 147: App_Exception.Raise_Exception;

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:
150: IF x_school_attended_name IS NOT NULL THEN
151: OPEN c_school_attended_name(x_institution_code);

Line 157: App_Exception.Raise_Exception;

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;
160:
161: --Validate Degree Earned

Line 170: App_Exception.Raise_Exception;

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;
173:
174: --Validate Degree Attempted

Line 183: App_Exception.Raise_Exception;

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

Line 192: APP_EXCEPTION.RAISE_EXCEPTION;

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;
195:
196: --Validate Degree Earned earlier than Date of Birth

Line 204: APP_EXCEPTION.RAISE_EXCEPTION;

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;
207:
208: --Validate Degree Earned earlier than Date of Birth

Line 217: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 223: APP_EXCEPTION.RAISE_EXCEPTION;

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;
226:
227: --If institution_code is passed then

Line 509: App_Exception.Raise_Exception;

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:
512:
513: IF x_school_attended_name IS NOT NULL AND x_institution_code IS NOT NULL THEN

Line 520: App_Exception.Raise_Exception;

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;
523:
524: --Validate Degree Earned

Line 533: App_Exception.Raise_Exception;

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

Line 542: APP_EXCEPTION.RAISE_EXCEPTION;

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;
545:
546: --Validate Degree Earned earlier than Date of Birth

Line 555: APP_EXCEPTION.RAISE_EXCEPTION;

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

Line 561: APP_EXCEPTION.RAISE_EXCEPTION;

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;
564:
565: --Validate Degree Attempted

Line 574: App_Exception.Raise_Exception;

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;
577:
578: IF x_status = 'I' THEN

Line 585: App_Exception.Raise_Exception;

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;
588: --If institution_code is passed then
589: IF ( x_school_party_id is NULL

Line 628: App_Exception.Raise_Exception;

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:
631: END IF;
632: