51: OPEN cur_old_ref_values;
52: FETCH cur_old_ref_values INTO old_references;
53: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
54: CLOSE cur_old_ref_values;
55: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
56: igs_ge_msg_stack.add;
57: app_exception.raise_exception;
58: RETURN;
59: END IF;
106: NULL;
107: ELSIF NOT igs_he_ext_run_dtls_pkg.get_pk_for_validation (
108: new_references.extract_run_id
109: ) THEN
110: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
111: igs_ge_msg_stack.add;
112: app_exception.raise_exception;
113: END IF;
114:
196: OPEN cur_rowid;
197: FETCH cur_rowid INTO lv_rowid;
198: IF (cur_rowid%FOUND) THEN
199: CLOSE cur_rowid;
200: fnd_message.set_name ('IGS', 'IGS_HE_HEERDALN_HEERDTL_FK');
201: igs_ge_msg_stack.add;
202: app_exception.raise_exception;
203: RETURN;
204: END IF;
270: new_references.extract_run_id,
271: new_references.line_number
272: )
273: ) THEN
274: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
275: igs_ge_msg_stack.add;
276: app_exception.raise_exception;
277: END IF;
278: check_parent_existance;
288: new_references.extract_run_id,
289: new_references.line_number
290: )
291: ) THEN
292: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
293: igs_ge_msg_stack.add;
294: app_exception.raise_exception;
295: END IF;
296: ELSIF (p_action = 'VALIDATE_DELETE') THEN
351: IF (x_last_update_login IS NULL) THEN
352: x_last_update_login := -1;
353: END IF;
354: ELSE
355: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
356: igs_ge_msg_stack.add;
357: app_exception.raise_exception;
358: END IF;
359:
483:
484: OPEN c1;
485: FETCH c1 INTO tlinfo;
486: IF (c1%notfound) THEN
487: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
488: igs_ge_msg_stack.add;
489: CLOSE c1;
490: app_exception.raise_exception;
491: RETURN;
506: AND (tlinfo.recalculate_flag = x_recalculate_flag)
507: ) THEN
508: NULL;
509: ELSE
510: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
511: igs_ge_msg_stack.add;
512: app_exception.raise_exception;
513: END IF;
514:
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: