45: OPEN cur_old_ref_values;
46: FETCH cur_old_ref_values INTO old_references;
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;
94: new_references.hold_type,
95: new_references.start_date
96: )
97: ) THEN
98: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
99: igs_ge_msg_stack.add;
100: app_exception.raise_exception;
101: END IF;
102:
120: NULL;
121: ELSIF NOT igs_en_elgb_ovr_pkg.get_pk_for_validation (
122: new_references.elgb_override_id
123: ) THEN
124: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
125: igs_ge_msg_stack.add;
126: app_exception.raise_exception;
127: END IF;
128:
131: NULL;
132: ELSIF NOT igs_fi_encmb_type_pkg.get_pk_for_validation (
133: new_references.hold_type
134: ) THEN
135: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
136: igs_ge_msg_stack.add;
137: app_exception.raise_exception;
138: END IF;
139:
198: OPEN cur_rowid;
199: FETCH cur_rowid INTO lv_rowid;
200: IF (cur_rowid%FOUND) THEN
201: CLOSE cur_rowid;
202: fnd_message.set_name ('IGS', 'IGS_EN_HRO_ET_FK');
203: igs_ge_msg_stack.add;
204: app_exception.raise_exception;
205: RETURN;
206: END IF;
273: OPEN cur_rowid;
274: FETCH cur_rowid INTO lv_rowid;
275: IF (cur_rowid%FOUND) THEN
276: CLOSE cur_rowid;
277: fnd_message.set_name ('IGS', 'IGS_EN_HRO_EOA_FK');
278: igs_ge_msg_stack.add;
279: app_exception.raise_exception;
280: RETURN;
281: END IF;
287: p_message_name VARCHAR2(30);
288: BEGIN
289: IF ( p_inserting = TRUE OR (p_updating = TRUE AND new_references.hold_type <> old_references.hold_type) ) THEN
290: IF NOT igs_en_val_etde.enrp_val_et_closed(new_references.hold_type,p_message_name) THEN
291: Fnd_Message.Set_Name('IGS', p_message_name);
292: IGS_GE_MSG_STACK.ADD;
293: App_Exception.Raise_Exception;
294: END IF;
295: END IF;
346: IF ( get_pk_for_validation(
347: new_references.hold_rel_ovr_id
348: )
349: ) THEN
350: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
351: igs_ge_msg_stack.add;
352: app_exception.raise_exception;
353: END IF;
354: check_uniqueness;
364: IF ( get_pk_for_validation (
365: new_references.hold_rel_ovr_id
366: )
367: ) THEN
368: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
369: igs_ge_msg_stack.add;
370: app_exception.raise_exception;
371: END IF;
372: check_uniqueness;
421: IF (x_last_update_login IS NULL) THEN
422: x_last_update_login := -1;
423: END IF;
424: ELSE
425: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
426: igs_ge_msg_stack.add;
427: app_exception.raise_exception;
428: END IF;
429:
524:
525: OPEN c1;
526: FETCH c1 INTO tlinfo;
527: IF (c1%notfound) THEN
528: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
529: igs_ge_msg_stack.add;
530: CLOSE c1;
531: app_exception.raise_exception;
532: RETURN;
542: AND (tlinfo.start_date = x_start_date)
543: ) THEN
544: NULL;
545: ELSE
546: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
547: igs_ge_msg_stack.add;
548: app_exception.raise_exception;
549: END IF;
550:
592: IF (x_last_update_login IS NULL) THEN
593: x_last_update_login := -1;
594: END IF;
595: ELSE
596: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
597: igs_ge_msg_stack.add;
598: app_exception.raise_exception;
599: END IF;
600: