APPS.IGS_PE_CONTACT_DTLS_PKG dependencies on APP_EXCEPTION

Line 79: app_exception.raise_exception;

75: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
76: CLOSE cur_old_ref_values;
77: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
78: igs_ge_msg_stack.add;
79: app_exception.raise_exception;
80: RETURN;
81: END IF;
82:
83: CLOSE cur_old_ref_values;

Line 180: app_exception.raise_exception;

176: new_references.location_venue_addr_id
177: ) THEN
178: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
179: igs_ge_msg_stack.add;
180: app_exception.raise_exception;
181: END IF;
182:
183: END check_parent_existance;
184:

Line 247: app_exception.raise_exception;

243: IF (cur_rowid%FOUND) THEN
244: CLOSE cur_rowid;
245: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
246: igs_ge_msg_stack.add;
247: app_exception.raise_exception;
248: RETURN;
249: END IF;
250: CLOSE cur_rowid;
251:

Line 359: app_exception.raise_exception;

355: IF (get_pk_for_validation(
356: new_references.contact_point_id)) THEN
357: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
358: igs_ge_msg_stack.add;
359: app_exception.raise_exception;
360: END IF;
361: check_constraints;
362: check_parent_existance;
363: ELSIF (p_action = 'UPDATE') THEN

Line 377: app_exception.raise_exception;

373: IF (get_pk_for_validation (
374: new_references.contact_point_id)) THEN
375: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
376: igs_ge_msg_stack.add;
377: app_exception.raise_exception;
378: END IF;
379: check_constraints;
380: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
381: check_constraints;

Line 509: app_exception.raise_exception;

505: END IF;
506: ELSE
507: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
508: igs_ge_msg_stack.add;
509: app_exception.raise_exception;
510: END IF;
511:
512: SELECT igs_pe_contact_dtls_s.nextval INTO x_contact_point_id
513: FROM dual;

Line 677: app_exception.raise_exception;

673: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
674: fnd_message.set_token ('ERR_CD', SQLCODE);
675: igs_ge_msg_stack.add;
676: igs_sc_gen_001.unset_ctx('R');
677: app_exception.raise_exception;
678: ELSE
679: igs_sc_gen_001.unset_ctx('R');
680: RAISE;
681: END IF;

Line 779: app_exception.raise_exception;

775: IF (c1%notfound) THEN
776: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
777: igs_ge_msg_stack.add;
778: CLOSE c1;
779: app_exception.raise_exception;
780: RETURN;
781: END IF;
782:
783: CLOSE c1;

Line 883: app_exception.raise_exception;

879: NULL;
880: ELSE
881: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
882: igs_ge_msg_stack.add;
883: app_exception.raise_exception;
884: END IF;
885:
886: RETURN;
887:

Line 963: app_exception.raise_exception;

959: END IF;
960: ELSE
961: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
962: igs_ge_msg_stack.add;
963: app_exception.raise_exception;
964: END IF;
965:
966: before_dml(
967: p_action=>'UPDATE',

Line 1074: app_exception.raise_exception;

1070: IF (SQL%NOTFOUND) THEN
1071: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1072: igs_ge_msg_stack.add;
1073: igs_sc_gen_001.unset_ctx('R');
1074: app_exception.raise_exception;
1075: END IF;
1076: IF (x_mode = 'S') THEN
1077: igs_sc_gen_001.unset_ctx('R');
1078: END IF;

Line 1094: app_exception.raise_exception;

1090: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1091: fnd_message.set_token ('ERR_CD', SQLCODE);
1092: igs_ge_msg_stack.add;
1093: igs_sc_gen_001.unset_ctx('R');
1094: app_exception.raise_exception;
1095: ELSE
1096: igs_sc_gen_001.unset_ctx('R');
1097: RAISE;
1098: END IF;

Line 1272: app_exception.raise_exception;

1268: IF (SQL%NOTFOUND) THEN
1269: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1270: igs_ge_msg_stack.add;
1271: igs_sc_gen_001.unset_ctx('R');
1272: app_exception.raise_exception;
1273: END IF;
1274: IF (x_mode = 'S') THEN
1275: igs_sc_gen_001.unset_ctx('R');
1276: END IF;