APPS.IGF_GR_PELL_SETUP_PKG dependencies on APP_EXCEPTION

Line 74: app_exception.raise_exception;

70: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
71: CLOSE cur_old_ref_values;
72: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
73: igs_ge_msg_stack.add;
74: app_exception.raise_exception;
75: RETURN;
76: END IF;
77: CLOSE cur_old_ref_values;
78:

Line 150: app_exception.raise_exception;

146: )
147: ) THEN
148: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
149: igs_ge_msg_stack.add;
150: app_exception.raise_exception;
151: END IF;
152:
153: END check_uniqueness;
154:

Line 188: app_exception.raise_exception;

184: new_references.ci_sequence_number
185: ) THEN
186: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
187: igs_ge_msg_stack.add;
188: app_exception.raise_exception;
189: END IF;
190:
191: IF (((old_references.course_cd = new_references.course_cd) AND
192: (old_references.version_number = new_references.version_number)) OR

Line 202: app_exception.raise_exception;

198: new_references.version_number
199: ) THEN
200: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
201: igs_ge_msg_stack.add;
202: app_exception.raise_exception;
203: END IF;
204:
205: END check_parent_existance;
206:

Line 320: app_exception.raise_exception;

316: IF (cur_rowid%FOUND) THEN
317: CLOSE cur_rowid;
318: fnd_message.set_name ('IGF', 'IGF_GR_PELL_CI_FK');
319: igs_ge_msg_stack.add;
320: app_exception.raise_exception;
321: RETURN;
322: END IF;
323: CLOSE cur_rowid;
324:

Line 356: app_exception.raise_exception;

352: IF (cur_rowid%FOUND) THEN
353: CLOSE cur_rowid;
354: fnd_message.set_name ('IGF', 'IGF_GR_PELL_PSV_FK');
355: igs_ge_msg_stack.add;
356: app_exception.raise_exception;
357: RETURN;
358: END IF;
359: CLOSE cur_rowid;
360:

Line 390: app_exception.raise_exception;

386: IF (cur_rowid%FOUND) THEN
387: CLOSE cur_rowid;
388: fnd_message.set_name ('IGF', 'IGF_GR_CANT_DEL_REP_PELL_ST');
389: igs_ge_msg_stack.add;
390: app_exception.raise_exception;
391: RETURN;
392: END IF;
393: CLOSE cur_rowid;
394:

Line 424: app_exception.raise_exception;

420: IF (cur_rowid%FOUND) THEN
421: CLOSE cur_rowid;
422: fnd_message.set_name ('IGF', 'IGF_GR_CANT_DEL_REP_ENT_ST');
423: igs_ge_msg_stack.add;
424: app_exception.raise_exception;
425: RETURN;
426: END IF;
427: CLOSE cur_rowid;
428:

Line 471: app_exception.raise_exception;

467: IF rec_get_child.num_of_rec >1 THEN
468: fnd_message.set_name ('IGS', 'IGS_SS_INQ_DELETE_RECORD_INSTR');
469: igs_ge_msg_stack.add;
470: CLOSE cur_get_child;
471: app_exception.raise_exception;
472: END IF;
473: CLOSE cur_get_child;
474: END check_child;
475:

Line 574: app_exception.raise_exception;

570: )
571: ) THEN
572: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
573: igs_ge_msg_stack.add;
574: app_exception.raise_exception;
575: END IF;
576: check_uniqueness;
577: check_parent_existance;
578: ELSIF (p_action = 'UPDATE') THEN

Line 595: app_exception.raise_exception;

591: )
592: ) THEN
593: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
594: igs_ge_msg_stack.add;
595: app_exception.raise_exception;
596: END IF;
597: check_uniqueness;
598: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
599: check_uniqueness;

Line 679: app_exception.raise_exception;

675: END IF;
676: ELSE
677: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
678: igs_ge_msg_stack.add;
679: app_exception.raise_exception;
680: END IF;
681:
682: SELECT igf_gr_pell_setup_s.nextval INTO x_pell_seq_id FROM dual;
683: before_dml(

Line 888: app_exception.raise_exception;

884: IF (c1%notfound) THEN
885: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
886: igs_ge_msg_stack.add;
887: CLOSE c1;
888: app_exception.raise_exception;
889: RETURN;
890: END IF;
891: CLOSE c1;
892:

Line 925: app_exception.raise_exception;

921: NULL;
922: ELSE
923: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
924: igs_ge_msg_stack.add;
925: app_exception.raise_exception;
926: END IF;
927:
928: RETURN;
929:

Line 998: app_exception.raise_exception;

994: END IF;
995: ELSE
996: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
997: igs_ge_msg_stack.add;
998: app_exception.raise_exception;
999: END IF;
1000:
1001: before_dml(
1002: p_action => 'UPDATE',