APPS.IGS_EN_TIMESLOT_PRTY_PKG dependencies on APP_EXCEPTION

Line 49: app_exception.raise_exception;

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

Line 117: app_exception.raise_exception;

113: ,new_references.priority_value
114: ) THEN
115: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
116: igs_ge_msg_stack.add;
117: app_exception.raise_exception;
118: END IF;
119: END check_uniqueness ;
120: PROCEDURE check_parent_existance AS
121: /*************************************************************

Line 142: app_exception.raise_exception;

138: new_references.igs_en_timeslot_stup_id
139: ) THEN
140: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
141: igs_ge_msg_stack.add;
142: app_exception.raise_exception;
143: END IF;
144:
145: END check_parent_existance;
146:

Line 270: app_exception.raise_exception;

266: IF (cur_rowid%FOUND) THEN
267: CLOSE cur_rowid;
268: fnd_message.set_name ('IGS', 'IGS_EN_ETPY_ETST_FK');
269: igs_ge_msg_stack.add;
270: app_exception.raise_exception;
271: RETURN;
272: END IF;
273: CLOSE cur_rowid;
274:

Line 324: app_exception.raise_exception;

320: IF get_pk_for_validation(
321: new_references.igs_en_timeslot_prty_id) THEN
322: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
323: igs_ge_msg_stack.add;
324: app_exception.raise_exception;
325: END IF;
326: check_uniqueness;
327: check_constraints;
328: check_parent_existance;

Line 345: app_exception.raise_exception;

341: IF get_pk_for_validation (
342: new_references.igs_en_timeslot_prty_id) THEN
343: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
344: igs_ge_msg_stack.add;
345: app_exception.raise_exception;
346: END IF;
347: check_uniqueness;
348: check_constraints;
349: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 432: app_exception.raise_exception;

428: END IF;
429: ELSE
430: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
431: igs_ge_msg_stack.add;
432: app_exception.raise_exception;
433: end if;
434:
435: select igs_en_timeslot_prty_s.nextval into x_igs_en_timeslot_prty_id from dual;
436:

Line 513: app_exception.raise_exception;

509: IF (c1%notfound) THEN
510: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
511: igs_ge_msg_stack.add;
512: CLOSE c1;
513: app_exception.raise_exception;
514: RETURN;
515: END IF;
516: CLOSE c1;
517: if ( ( tlinfo.IGS_EN_TIMESLOT_STUP_ID = X_IGS_EN_TIMESLOT_STUP_ID)

Line 525: app_exception.raise_exception;

521: NULL;
522: ELSE
523: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
524: igs_ge_msg_stack.add;
525: app_exception.raise_exception;
526: END IF;
527: RETURN;
528: END lock_row;
529: PROCEDURE update_row (

Line 568: app_exception.raise_exception;

564: END IF;
565: ELSE
566: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
567: igs_ge_msg_stack.add;
568: app_exception.raise_exception;
569: END IF;
570: before_dml(
571: p_action=>'UPDATE',
572: x_rowid=>X_ROWID,