APPS.IGS_PE_NONIMG_STAT_PKG dependencies on APP_EXCEPTION

Line 54: app_exception.raise_exception;

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

Line 233: app_exception.raise_exception;

229: new_references.action_date
230: ) ) THEN
231: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
232: igs_ge_msg_stack.add;
233: app_exception.raise_exception;
234: END IF;
235:
236: END check_uniqueness;
237:

Line 257: app_exception.raise_exception;

253: NULL;
254: ELSIF NOT igs_pe_nonimg_form_pkg.get_pk_for_validation ( new_references.nonimg_form_id ) THEN
255: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
256: igs_ge_msg_stack.add;
257: app_exception.raise_exception;
258: END IF;
259:
260: END check_parent_existance;
261:

Line 359: app_exception.raise_exception;

355: IF (cur_rowid%FOUND) THEN
356: CLOSE cur_rowid;
357: fnd_message.set_name ('IGS', 'IGS_PE_PENST_PENIF_FK');
358: igs_ge_msg_stack.add;
359: app_exception.raise_exception;
360: RETURN;
361: END IF;
362: CLOSE cur_rowid;
363:

Line 423: app_exception.raise_exception;

419: -- Call all the procedures related to Before Insert.
420: IF ( get_pk_for_validation( new_references.nonimg_stat_id ) ) THEN
421: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
422: igs_ge_msg_stack.add;
423: app_exception.raise_exception;
424: END IF;
425: check_uniqueness;
426: check_parent_existance;
427: ELSIF (p_action = 'UPDATE') THEN

Line 436: app_exception.raise_exception;

432: -- Call all the procedures related to Before Insert.
433: IF ( get_pk_for_validation ( new_references.nonimg_stat_id ) ) THEN
434: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
435: igs_ge_msg_stack.add;
436: app_exception.raise_exception;
437: END IF;
438: check_uniqueness;
439: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
440: check_uniqueness;

Line 492: app_exception.raise_exception;

488: END IF;
489: ELSE
490: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
491: igs_ge_msg_stack.add;
492: app_exception.raise_exception;
493: END IF;
494:
495: before_dml(
496: p_action => 'INSERT',

Line 568: app_exception.raise_exception;

564: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
565: fnd_message.set_token ('ERR_CD', SQLCODE);
566: igs_ge_msg_stack.add;
567: igs_sc_gen_001.unset_ctx('R');
568: app_exception.raise_exception;
569: ELSE
570: igs_sc_gen_001.unset_ctx('R');
571: RAISE;
572: END IF;

Line 622: app_exception.raise_exception;

618: IF (c1%notfound) THEN
619: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
620: igs_ge_msg_stack.add;
621: CLOSE c1;
622: app_exception.raise_exception;
623: RETURN;
624: END IF;
625: CLOSE c1;
626:

Line 642: app_exception.raise_exception;

638: NULL;
639: ELSE
640: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
641: igs_ge_msg_stack.add;
642: app_exception.raise_exception;
643: END IF;
644:
645: RETURN;
646:

Line 695: app_exception.raise_exception;

691: END IF;
692: ELSE
693: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
694: igs_ge_msg_stack.add;
695: app_exception.raise_exception;
696: END IF;
697:
698: before_dml(
699: p_action => 'UPDATE',

Line 741: app_exception.raise_exception;

737: IF (SQL%NOTFOUND) THEN
738: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
739: igs_ge_msg_stack.add;
740: igs_sc_gen_001.unset_ctx('R');
741: app_exception.raise_exception;
742: END IF;
743: IF (x_mode = 'S') THEN
744: igs_sc_gen_001.unset_ctx('R');
745: END IF;

Line 756: app_exception.raise_exception;

752: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
753: fnd_message.set_token ('ERR_CD', SQLCODE);
754: igs_ge_msg_stack.add;
755: igs_sc_gen_001.unset_ctx('R');
756: app_exception.raise_exception;
757: ELSE
758: igs_sc_gen_001.unset_ctx('R');
759: RAISE;
760: END IF;

Line 863: app_exception.raise_exception;

859: IF (SQL%NOTFOUND) THEN
860: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
861: igs_ge_msg_stack.add;
862: igs_sc_gen_001.unset_ctx('R');
863: app_exception.raise_exception;
864: END IF;
865: IF (x_mode = 'S') THEN
866: igs_sc_gen_001.unset_ctx('R');
867: END IF;