APPS.IGS_PR_STU_ACAD_STAT_PKG dependencies on APP_EXCEPTION

Line 58: app_exception.raise_exception;

54: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
55: CLOSE cur_old_ref_values;
56: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
57: igs_ge_msg_stack.add;
58: app_exception.raise_exception;
59: RETURN;
60: END IF;
61: CLOSE cur_old_ref_values;
62:

Line 117: app_exception.raise_exception;

113: new_references.course_cd
114: ) THEN
115: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
116: igs_ge_msg_stack.add;
117: app_exception.raise_exception;
118: END IF;
119:
120: IF (((old_references.cal_type= new_references.cal_type) AND
121: (old_references.ci_sequence_number = new_references.ci_sequence_number)) OR

Line 131: APP_EXCEPTION.RAISE_EXCEPTION;

127: new_references.ci_sequence_number
128: ) THEN
129: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
130: IGS_GE_MSG_STACK.ADD;
131: APP_EXCEPTION.RAISE_EXCEPTION;
132: END IF;
133:
134: IF (((old_references.stat_type = new_references.stat_type)) OR
135: ((new_references.stat_type IS NULL))) THEN

Line 142: app_exception.raise_exception;

138: new_references.stat_type
139: ) THEN
140: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
141: igs_ge_msg_stack.add;
142: app_exception.raise_exception;
143: END IF;
144:
145: END check_parent_existance;
146:

Line 220: APP_EXCEPTION.RAISE_EXCEPTION;

216: IF (cur_rowid%FOUND) THEN
217: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SAS_SCA_FK');
218: IGS_GE_MSG_STACK.ADD;
219: CLOSE cur_rowid;
220: APP_EXCEPTION.RAISE_EXCEPTION;
221: RETURN;
222: END IF;
223: CLOSE cur_rowid;
224: END get_fk_igs_en_stdnt_ps_att;

Line 244: APP_EXCEPTION.RAISE_EXCEPTION;

240: IF (cur_rowid%FOUND) THEN
241: Fnd_Message.Set_Name ('IGS', 'IGS_PR_SAS_CI_FK');
242: IGS_GE_MSG_STACK.ADD;
243: CLOSE cur_rowid;
244: APP_EXCEPTION.RAISE_EXCEPTION;
245: RETURN;
246: END IF;
247: CLOSE cur_rowid;
248: END get_fk_igs_ca_inst;

Line 277: app_exception.raise_exception;

273: IF (cur_rowid%FOUND) THEN
274: CLOSE cur_rowid;
275: fnd_message.set_name ('IGS', 'IGS_PR_SAS_STTY_FK');
276: igs_ge_msg_stack.add;
277: app_exception.raise_exception;
278: RETURN;
279: END IF;
280: CLOSE cur_rowid;
281:

Line 353: app_exception.raise_exception;

349: new_references.timeframe)
350: ) THEN
351: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
352: igs_ge_msg_stack.add;
353: app_exception.raise_exception;
354: END IF;
355: ELSIF (p_action = 'UPDATE') THEN
356: -- Call all the procedures related to Before Update.
357: check_parent_existance;

Line 371: app_exception.raise_exception;

367: )
368: ) THEN
369: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
370: igs_ge_msg_stack.add;
371: app_exception.raise_exception;
372: END IF;
373: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
374: -- Call all the procedures related to Before Update.
375: check_parent_existance;

Line 437: app_exception.raise_exception;

433: END IF;
434: ELSE
435: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
436: igs_ge_msg_stack.add;
437: app_exception.raise_exception;
438: END IF;
439:
440: before_dml(
441: p_action => 'INSERT',

Line 564: app_exception.raise_exception;

560: IF (c1%notfound) THEN
561: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
562: igs_ge_msg_stack.add;
563: CLOSE c1;
564: app_exception.raise_exception;
565: RETURN;
566: END IF;
567: CLOSE c1;
568:

Line 584: app_exception.raise_exception;

580: NULL;
581: ELSE
582: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
583: igs_ge_msg_stack.add;
584: app_exception.raise_exception;
585: END IF;
586:
587: RETURN;
588:

Line 640: app_exception.raise_exception;

636: END IF;
637: ELSE
638: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
639: igs_ge_msg_stack.add;
640: app_exception.raise_exception;
641: END IF;
642:
643: before_dml(
644: p_action => 'UPDATE',