APPS.IGS_PS_US_EXAM_MEET_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 92: app_exception.raise_exception;

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

Line 118: app_exception.raise_exception;

114: new_references.exam_meet_group_id
115: ) THEN
116: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
117: igs_ge_msg_stack.add;
118: app_exception.raise_exception;
119: END IF;
120:
121: IF (((old_references.uoo_id = new_references.uoo_id)) OR
122: ((new_references.uoo_id IS NULL))) THEN

Line 129: app_exception.raise_exception;

125: new_references.uoo_id
126: ) THEN
127: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
128: igs_ge_msg_stack.add;
129: app_exception.raise_exception;
130: END IF;
131:
132: END check_parent_existance;
133:

Line 232: app_exception.raise_exception;

228: IF (cur_rowid%FOUND) THEN
229: CLOSE cur_rowid;
230: fnd_message.set_name ('IGS', 'IGS_PS_EMG_EM_FK2');
231: igs_ge_msg_stack.add;
232: app_exception.raise_exception;
233: RETURN;
234: END IF;
235: CLOSE cur_rowid;
236:

Line 267: app_exception.raise_exception;

263: IF (cur_rowid%FOUND) THEN
264: CLOSE cur_rowid;
265: fnd_message.set_name ('IGS', 'IGS_PS_UOO_EM_FK1');
266: igs_ge_msg_stack.add;
267: app_exception.raise_exception;
268: RETURN;
269: END IF;
270: CLOSE cur_rowid;
271:

Line 322: app_exception.raise_exception;

318: )
319: ) THEN
320: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
321: igs_ge_msg_stack.add;
322: app_exception.raise_exception;
323: END IF;
324: check_uniqueness;
325: check_parent_existance;
326: ELSIF (p_action = 'UPDATE') THEN

Line 338: app_exception.raise_exception;

334: )
335: ) THEN
336: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
337: igs_ge_msg_stack.add;
338: app_exception.raise_exception;
339: END IF;
340: check_uniqueness;
341: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
342: check_uniqueness;

Line 392: app_exception.raise_exception;

388: END IF;
389: ELSE
390: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
391: igs_ge_msg_stack.add;
392: app_exception.raise_exception;
393: END IF;
394:
395: SELECT igs_ps_us_exam_meet_s.NEXTVAL
396: INTO x_exam_meet_id

Line 481: app_exception.raise_exception;

477: IF (c1%notfound) THEN
478: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
479: igs_ge_msg_stack.add;
480: CLOSE c1;
481: app_exception.raise_exception;
482: RETURN;
483: END IF;
484: CLOSE c1;
485:

Line 495: app_exception.raise_exception;

491: NULL;
492: ELSE
493: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
494: igs_ge_msg_stack.add;
495: app_exception.raise_exception;
496: END IF;
497:
498: RETURN;
499:

Line 542: app_exception.raise_exception;

538: END IF;
539: ELSE
540: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
541: igs_ge_msg_stack.add;
542: app_exception.raise_exception;
543: END IF;
544:
545: before_dml(
546: p_action => 'UPDATE',