DBA Data[Home] [Help]

APPS.IGS_PE_NONIMG_FORM_PKG dependencies on APP_EXCEPTION

Line 86: app_exception.raise_exception;

82: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
83: CLOSE cur_old_ref_values;
84: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
85: igs_ge_msg_stack.add;
86: app_exception.raise_exception;
87: RETURN;
88: END IF;
89: CLOSE cur_old_ref_values;
90:

Line 310: APP_EXCEPTION.RAISE_EXCEPTION;

306: NULL;
307: ELSIF NOT Igs_Pe_Person_Pkg.Get_PK_For_Validation ( new_references.person_id ) THEN
308: FND_MESSAGE.SET_NAME ('FND','FORM_RECORD_DELETED');
309: IGS_GE_MSG_STACK.ADD;
310: APP_EXCEPTION.RAISE_EXCEPTION;
311: END IF;
312:
313: END check_parent_existance;
314:

Line 469: app_exception.raise_exception;

465: -- Call all the procedures related to Before Insert.
466: IF ( get_pk_for_validation( new_references.nonimg_form_id ) ) THEN
467: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
468: igs_ge_msg_stack.add;
469: app_exception.raise_exception;
470: END IF;
471: ELSIF (p_action = 'DELETE') THEN
472: -- Call all the procedures related to Before Delete.
473: check_child_existance;

Line 479: app_exception.raise_exception;

475: -- Call all the procedures related to Before Insert.
476: IF ( get_pk_for_validation ( new_references.nonimg_form_id ) ) THEN
477: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
478: igs_ge_msg_stack.add;
479: app_exception.raise_exception;
480: END IF;
481: ELSIF (p_action = 'VALIDATE_DELETE') THEN
482: check_child_existance;
483: END IF;

Line 566: app_exception.raise_exception;

562: END IF;
563: ELSE
564: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
565: igs_ge_msg_stack.add;
566: app_exception.raise_exception;
567: END IF;
568:
569: before_dml(
570: p_action => 'INSERT',

Line 736: app_exception.raise_exception;

732: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
733: fnd_message.set_token ('ERR_CD', SQLCODE);
734: igs_ge_msg_stack.add;
735: igs_sc_gen_001.unset_ctx('R');
736: app_exception.raise_exception;
737: ELSE
738: igs_sc_gen_001.unset_ctx('R');
739: RAISE;
740: END IF;

Line 855: app_exception.raise_exception;

851: IF (c1%notfound) THEN
852: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
853: igs_ge_msg_stack.add;
854: CLOSE c1;
855: app_exception.raise_exception;
856: RETURN;
857: END IF;
858: CLOSE c1;
859:

Line 907: app_exception.raise_exception;

903: NULL;
904: ELSE
905: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
906: igs_ge_msg_stack.add;
907: app_exception.raise_exception;
908: END IF;
909:
910: RETURN;
911:

Line 992: app_exception.raise_exception;

988: END IF;
989: ELSE
990: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
991: igs_ge_msg_stack.add;
992: app_exception.raise_exception;
993: END IF;
994:
995: before_dml(
996: p_action => 'UPDATE',

Line 1102: app_exception.raise_exception;

1098: IF (SQL%NOTFOUND) THEN
1099: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1100: igs_ge_msg_stack.add;
1101: igs_sc_gen_001.unset_ctx('R');
1102: app_exception.raise_exception;
1103: END IF;
1104: IF (x_mode = 'S') THEN
1105: igs_sc_gen_001.unset_ctx('R');
1106: END IF;

Line 1119: app_exception.raise_exception;

1115: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1116: fnd_message.set_token ('ERR_CD', SQLCODE);
1117: igs_ge_msg_stack.add;
1118: igs_sc_gen_001.unset_ctx('R');
1119: app_exception.raise_exception;
1120: ELSE
1121: igs_sc_gen_001.unset_ctx('R');
1122: RAISE;
1123: END IF;

Line 1324: app_exception.raise_exception;

1320: IF (SQL%NOTFOUND) THEN
1321: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1322: igs_ge_msg_stack.add;
1323: igs_sc_gen_001.unset_ctx('R');
1324: app_exception.raise_exception;
1325: END IF;
1326: IF (x_mode = 'S') THEN
1327: igs_sc_gen_001.unset_ctx('R');
1328: END IF;