APPS.IGS_PS_RSV_USEC_PRI_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 93: app_exception.raise_exception;

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

Line 120: app_exception.raise_exception;

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

Line 130: App_Exception.Raise_Exception;

126: ELSIF NOT igs_lookups_view_pkg.get_pk_for_validation('RESERVE_SEAT_PRIORITY',
127: new_references.priority_value) THEN
128: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
129: IGS_GE_MSG_STACK.ADD;
130: App_Exception.Raise_Exception;
131: END IF;
132:
133: END check_parent_existance;
134:

Line 254: app_exception.raise_exception;

250: IF (cur_rowid%FOUND) THEN
251: CLOSE cur_rowid;
252: fnd_message.set_name ('IGS', 'IGS_PS_USPR_UOO_UFK');
253: igs_ge_msg_stack.add;
254: app_exception.raise_exception;
255: RETURN;
256: END IF;
257: CLOSE cur_rowid;
258:

Line 309: app_exception.raise_exception;

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

Line 328: app_exception.raise_exception;

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

Line 386: app_exception.raise_exception;

382: END IF;
383: ELSE
384: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
385: igs_ge_msg_stack.add;
386: app_exception.raise_exception;
387: END IF;
388:
389: SELECT igs_ps_rsv_usec_pri_s.NEXTVAL
390: INTO x_rsv_usec_pri_id

Line 475: app_exception.raise_exception;

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

Line 489: app_exception.raise_exception;

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

Line 536: app_exception.raise_exception;

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