APPS.IGS_PS_US_EM_GRP_PKG dependencies on APP_EXCEPTION

Line 48: app_exception.raise_exception;

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

Line 94: app_exception.raise_exception;

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

Line 123: app_exception.raise_exception;

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

Line 251: app_exception.raise_exception;

247: IF (cur_rowid%FOUND) THEN
248: CLOSE cur_rowid;
249: fnd_message.set_name ('IGS', 'IGS_PS_CI_EMG_FK1');
250: igs_ge_msg_stack.add;
251: app_exception.raise_exception;
252: RETURN;
253: END IF;
254: CLOSE cur_rowid;
255:

Line 306: app_exception.raise_exception;

302: )
303: ) THEN
304: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
305: igs_ge_msg_stack.add;
306: app_exception.raise_exception;
307: END IF;
308: check_uniqueness;
309: check_parent_existance;
310: ELSIF (p_action = 'UPDATE') THEN

Line 325: app_exception.raise_exception;

321: )
322: ) THEN
323: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
324: igs_ge_msg_stack.add;
325: app_exception.raise_exception;
326: END IF;
327: check_uniqueness;
328: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
329: check_uniqueness;

Line 381: app_exception.raise_exception;

377: END IF;
378: ELSE
379: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
380: igs_ge_msg_stack.add;
381: app_exception.raise_exception;
382: END IF;
383:
384: SELECT igs_ps_us_em_grp_s.NEXTVAL
385: INTO x_exam_meet_group_id

Line 470: app_exception.raise_exception;

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

Line 484: app_exception.raise_exception;

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

Line 531: app_exception.raise_exception;

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