APPS.IGS_PS_USO_CLAS_MEET_PKG dependencies on APP_EXCEPTION

Line 47: app_exception.raise_exception;

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

Line 90: app_exception.raise_exception;

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

Line 116: app_exception.raise_exception;

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

Line 126: app_exception.raise_exception;

122: ELSIF NOT igs_ps_unit_ofr_opt_pkg.get_uk_for_validation(
123: new_references.uoo_id) THEN
124: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
125: igs_ge_msg_stack.add;
126: app_exception.raise_exception;
127: END IF;
128:
129: END check_parent_existance;
130:

Line 229: app_exception.raise_exception;

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

Line 264: app_exception.raise_exception;

260: IF (cur_rowid%FOUND) THEN
261: CLOSE cur_rowid;
262: fnd_message.set_name ('IGS', 'IGS_PS_USO_CM_FK2');
263: igs_ge_msg_stack.add;
264: app_exception.raise_exception;
265: RETURN;
266: END IF;
267: CLOSE cur_rowid;
268:

Line 319: app_exception.raise_exception;

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

Line 335: app_exception.raise_exception;

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

Line 389: app_exception.raise_exception;

385: END IF;
386: ELSE
387: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
388: igs_ge_msg_stack.add;
389: app_exception.raise_exception;
390: END IF;
391:
392: SELECT igs_ps_uso_clas_meet_s.NEXTVAL
393: INTO x_class_meet_id

Line 478: app_exception.raise_exception;

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

Line 494: app_exception.raise_exception;

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

Line 541: app_exception.raise_exception;

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