43: OPEN cur_old_ref_values;
44: FETCH cur_old_ref_values INTO old_references;
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;
111: IF get_uk_for_validation (
112: new_references.igs_en_timeslot_stup_id
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 ;
136: NULL;
137: ELSIF NOT igs_en_timeslot_stup_pkg.get_pk_for_validation (
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:
264: OPEN cur_rowid;
265: FETCH cur_rowid INTO lv_rowid;
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;
318: -- Call all the procedures related to Before Insert.
319: Null;
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;
339: ELSIF (p_action = 'VALIDATE_INSERT') THEN
340: -- Call all the procedures related to Before Insert.
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;
426: IF x_last_update_login IS NULL THEN
427: x_last_update_login := -1;
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:
506: BEGIN
507: OPEN c1;
508: FETCH c1 INTO tlinfo;
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;
519: AND (tlinfo.PRIORITY_VALUE = X_PRIORITY_VALUE)
520: ) THEN
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;
562: IF x_last_update_login IS NULL THEN
563: x_last_update_login := -1;
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(