APPS.IGS_PE_SN_CONTACT_PKG dependencies on APP_EXCEPTION

Line 49: app_exception.raise_exception;

45: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
46: CLOSE cur_old_ref_values;
47: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
48: igs_ge_msg_stack.add;
49: app_exception.raise_exception;
50: RETURN;
51: END IF;
52: CLOSE cur_old_ref_values;
53:

Line 95: app_exception.raise_exception;

91: )
92: ) THEN
93: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
94: igs_ge_msg_stack.add;
95: app_exception.raise_exception;
96: END IF;
97:
98: END check_uniqueness;
99:

Line 121: app_exception.raise_exception;

117: new_references.disability_id
118: ) THEN
119: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
120: igs_ge_msg_stack.add;
121: app_exception.raise_exception;
122: END IF;
123:
124: END check_parent_existance;
125:

Line 228: app_exception.raise_exception;

224: IF (cur_rowid%FOUND) THEN
225: CLOSE cur_rowid;
226: fnd_message.set_name ('IGS', 'IGS_PE_SNCT_PD_FK');
227: igs_ge_msg_stack.add;
228: app_exception.raise_exception;
229: RETURN;
230: END IF;
231: CLOSE cur_rowid;
232:

Line 285: app_exception.raise_exception;

281: )
282: ) THEN
283: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
284: igs_ge_msg_stack.add;
285: app_exception.raise_exception;
286: END IF;
287: check_uniqueness;
288: check_parent_existance;
289: ELSIF (p_action = 'UPDATE') THEN

Line 301: app_exception.raise_exception;

297: )
298: ) THEN
299: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
300: igs_ge_msg_stack.add;
301: app_exception.raise_exception;
302: END IF;
303: check_uniqueness;
304:
305: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 357: app_exception.raise_exception;

353: END IF;
354: ELSE
355: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
356: igs_ge_msg_stack.add;
357: app_exception.raise_exception;
358: END IF;
359:
360: SELECT igs_pe_sn_contact_s.NEXTVAL
361: INTO x_sn_contact_id

Line 426: app_exception.raise_exception;

422: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
423: fnd_message.set_token ('ERR_CD', SQLCODE);
424: igs_ge_msg_stack.add;
425: igs_sc_gen_001.unset_ctx('R');
426: app_exception.raise_exception;
427: ELSE
428: igs_sc_gen_001.unset_ctx('R');
429: RAISE;
430: END IF;

Line 471: app_exception.raise_exception;

467: IF (c1%notfound) THEN
468: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
469: igs_ge_msg_stack.add;
470: CLOSE c1;
471: app_exception.raise_exception;
472: RETURN;
473: END IF;
474: CLOSE c1;
475:

Line 486: app_exception.raise_exception;

482: NULL;
483: ELSE
484: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
485: igs_ge_msg_stack.add;
486: app_exception.raise_exception;
487: END IF;
488:
489: RETURN;
490:

Line 534: app_exception.raise_exception;

530: END IF;
531: ELSE
532: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
533: igs_ge_msg_stack.add;
534: app_exception.raise_exception;
535: END IF;
536:
537: before_dml(
538: p_action => 'UPDATE',

Line 570: app_exception.raise_exception;

566: IF (SQL%NOTFOUND) THEN
567: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
568: igs_ge_msg_stack.add;
569: igs_sc_gen_001.unset_ctx('R');
570: app_exception.raise_exception;
571: END IF;
572: IF (x_mode = 'S') THEN
573: igs_sc_gen_001.unset_ctx('R');
574: END IF;

Line 585: app_exception.raise_exception;

581: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
582: fnd_message.set_token ('ERR_CD', SQLCODE);
583: igs_ge_msg_stack.add;
584: igs_sc_gen_001.unset_ctx('R');
585: app_exception.raise_exception;
586: ELSE
587: igs_sc_gen_001.unset_ctx('R');
588: RAISE;
589: END IF;

Line 679: app_exception.raise_exception;

675: IF (SQL%NOTFOUND) THEN
676: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
677: igs_ge_msg_stack.add;
678: igs_sc_gen_001.unset_ctx('R');
679: app_exception.raise_exception;
680: END IF;
681: IF (x_mode = 'S') THEN
682: igs_sc_gen_001.unset_ctx('R');
683: END IF;