APPS.IGS_EN_TIMESLOT_PREF_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 123: app_exception.raise_exception;

119: ,new_references.sequence_number
120: ) THEN
121: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
122: igs_ge_msg_stack.add;
123: app_exception.raise_exception;
124: END IF;
125: END check_uniqueness ;
126: PROCEDURE check_parent_existance AS
127: /*************************************************************

Line 148: app_exception.raise_exception;

144: new_references.igs_en_timeslot_prty_id
145: ) 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 263: app_exception.raise_exception;

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

Line 283: App_Exception.Raise_Exception;

279: CLOSE grp_id_cur;
280: IF NOT IGS_PE_PERSID_GROUP_PKG.val_persid_group(l_group_id,p_message_name) THEN
281: Fnd_Message.Set_Name('IGS', p_message_name);
282: IGS_GE_MSG_STACK.ADD;
283: App_Exception.Raise_Exception;
284: END IF;
285: END IF;
286: END BeforeInsertUpdate;
287:

Line 340: app_exception.raise_exception;

336: IF get_pk_for_validation(
337: new_references.igs_en_timeslot_pref_id) THEN
338: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
339: igs_ge_msg_stack.add;
340: app_exception.raise_exception;
341: END IF;
342: check_uniqueness;
343: check_constraints;
344: check_parent_existance;

Line 362: app_exception.raise_exception;

358: IF get_pk_for_validation (
359: new_references.igs_en_timeslot_pref_id) THEN
360: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
361: igs_ge_msg_stack.add;
362: app_exception.raise_exception;
363: END IF;
364: check_uniqueness;
365: check_constraints;
366: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 452: app_exception.raise_exception;

448: END IF;
449: ELSE
450: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
451: igs_ge_msg_stack.add;
452: app_exception.raise_exception;
453: end if;
454:
455: select igs_en_timeslot_pref_s.nextval into x_igs_en_timeslot_pref_id from dual;
456:

Line 545: app_exception.raise_exception;

541: IF (c1%notfound) THEN
542: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
543: igs_ge_msg_stack.add;
544: CLOSE c1;
545: app_exception.raise_exception;
546: RETURN;
547: END IF;
548: CLOSE c1;
549: if ( (tlinfo.IGS_EN_TIMESLOT_PRTY_ID = X_IGS_EN_TIMESLOT_PRTY_ID)

Line 563: app_exception.raise_exception;

559: NULL;
560: ELSE
561: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
562: igs_ge_msg_stack.add;
563: app_exception.raise_exception;
564: END IF;
565: RETURN;
566: END lock_row;
567: PROCEDURE update_row (

Line 608: app_exception.raise_exception;

604: END IF;
605: ELSE
606: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
607: igs_ge_msg_stack.add;
608: app_exception.raise_exception;
609: END IF;
610: before_dml(
611: p_action=>'UPDATE',
612: x_rowid=>X_ROWID,