44: OPEN cur_old_ref_values;
45: FETCH cur_old_ref_values INTO old_references;
46: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
47: CLOSE cur_old_ref_values;
48: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
49: igs_ge_msg_stack.add;
50: app_exception.raise_exception;
51: RETURN;
52: END IF;
95: ELSIF NOT igs_he_ex_rn_dat_ln_pkg.get_pk_for_validation (
96: new_references.extract_run_id,
97: new_references.line_number
98: ) THEN
99: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
100: igs_ge_msg_stack.add;
101: app_exception.raise_exception;
102: END IF;
103:
169: OPEN cur_rowid;
170: FETCH cur_rowid INTO lv_rowid;
171: IF (cur_rowid%FOUND) THEN
172: CLOSE cur_rowid;
173: fnd_message.set_name ('IGS', 'IGS_HE_HEERDAFD_HEERDALN_FK');
174: igs_ge_msg_stack.add;
175: app_exception.raise_exception;
176: RETURN;
177: END IF;
230: new_references.line_number,
231: new_references.field_number
232: )
233: ) THEN
234: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
235: igs_ge_msg_stack.add;
236: app_exception.raise_exception;
237: END IF;
238: check_parent_existance;
246: new_references.line_number,
247: new_references.field_number
248: )
249: ) THEN
250: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
251: igs_ge_msg_stack.add;
252: app_exception.raise_exception;
253: END IF;
254: END IF;
301: IF (x_last_update_login IS NULL) THEN
302: x_last_update_login := -1;
303: END IF;
304: ELSE
305: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
306: igs_ge_msg_stack.add;
307: app_exception.raise_exception;
308: END IF;
309:
395:
396: OPEN c1;
397: FETCH c1 INTO tlinfo;
398: IF (c1%notfound) THEN
399: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
400: igs_ge_msg_stack.add;
401: CLOSE c1;
402: app_exception.raise_exception;
403: RETURN;
410: AND ((tlinfo.override_value = x_override_value) OR ((tlinfo.override_value IS NULL) AND (X_override_value IS NULL)))
411: ) THEN
412: NULL;
413: ELSE
414: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
415: igs_ge_msg_stack.add;
416: app_exception.raise_exception;
417: END IF;
418:
459: IF (x_last_update_login IS NULL) THEN
460: x_last_update_login := -1;
461: END IF;
462: ELSE
463: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
464: igs_ge_msg_stack.add;
465: app_exception.raise_exception;
466: END IF;
467: