DBA Data[Home] [Help]

APPS.IGS_AD_ACAD_HISTORY_PKG dependencies on IGS_GE_MSG_STACK

Line 146: IGS_GE_MSG_STACK.ADD;

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:
150: IF x_school_attended_name IS NOT NULL THEN

Line 156: IGS_GE_MSG_STACK.ADD;

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

Line 169: IGS_GE_MSG_STACK.ADD;

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

Line 182: IGS_GE_MSG_STACK.ADD;

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:

Line 191: IGS_GE_MSG_STACK.ADD;

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

Line 203: IGS_GE_MSG_STACK.ADD;

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

Line 216: IGS_GE_MSG_STACK.ADD;

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:
220: IF l_birth_dt IS NOT NULL AND x_end_date IS NOT NULL AND l_birth_dt > x_end_date THEN

Line 222: IGS_GE_MSG_STACK.ADD;

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

Line 508: IGS_GE_MSG_STACK.ADD;

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:
512:

Line 519: IGS_GE_MSG_STACK.ADD;

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

Line 532: IGS_GE_MSG_STACK.ADD;

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:

Line 541: IGS_GE_MSG_STACK.ADD;

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

Line 554: IGS_GE_MSG_STACK.ADD;

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:
558: IF l_birth_dt IS NOT NULL AND x_end_date IS NOT NULL AND l_birth_dt > x_end_date THEN

Line 560: IGS_GE_MSG_STACK.ADD;

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

Line 573: IGS_GE_MSG_STACK.ADD;

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

Line 584: IGS_GE_MSG_STACK.ADD;

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

Line 627: IGS_GE_MSG_STACK.ADD;

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