APPS.IGS_PS_RSV_UOP_PRI_PKG dependencies on APP_EXCEPTION

Line 51: app_exception.raise_exception;

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

Line 102: app_exception.raise_exception;

98: )
99: ) THEN
100: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
101: igs_ge_msg_stack.add;
102: app_exception.raise_exception;
103: END IF;
104:
105: END check_uniqueness;
106:

Line 138: app_exception.raise_exception;

134: new_references.ci_sequence_number
135: ) THEN
136: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
137: igs_ge_msg_stack.add;
138: app_exception.raise_exception;
139: END IF;
140:
141: IF (((old_references.priority_value = new_references.priority_value)) OR
142: ((new_references.priority_value IS NULL))) THEN

Line 148: App_Exception.Raise_Exception;

144: ELSIF NOT igs_lookups_view_pkg.get_pk_for_validation('RESERVE_SEAT_PRIORITY',
145: new_references.priority_value) THEN
146: Fnd_Message.Set_Name('FND','FORM_RECORD_DELETED');
147: IGS_GE_MSG_STACK.ADD;
148: App_Exception.Raise_Exception;
149: END IF;
150:
151: END check_parent_existance;
152:

Line 265: app_exception.raise_exception;

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

Line 326: app_exception.raise_exception;

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

Line 342: app_exception.raise_exception;

338: )
339: ) THEN
340: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
341: igs_ge_msg_stack.add;
342: app_exception.raise_exception;
343: END IF;
344: check_uniqueness;
345: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
346: check_uniqueness;

Line 401: app_exception.raise_exception;

397: END IF;
398: ELSE
399: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
400: igs_ge_msg_stack.add;
401: app_exception.raise_exception;
402: END IF;
403:
404: SELECT igs_ps_rsv_uop_pri_s.NEXTVAL
405: INTO x_rsv_uop_pri_id

Line 505: app_exception.raise_exception;

501: IF (c1%notfound) THEN
502: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
503: igs_ge_msg_stack.add;
504: CLOSE c1;
505: app_exception.raise_exception;
506: RETURN;
507: END IF;
508: CLOSE c1;
509:

Line 522: app_exception.raise_exception;

518: NULL;
519: ELSE
520: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
521: igs_ge_msg_stack.add;
522: app_exception.raise_exception;
523: END IF;
524:
525: RETURN;
526:

Line 572: app_exception.raise_exception;

568: END IF;
569: ELSE
570: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
571: igs_ge_msg_stack.add;
572: app_exception.raise_exception;
573: END IF;
574:
575: before_dml(
576: p_action => 'UPDATE',