59: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
60: CLOSE cur_old_ref_values;
61: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
62: igs_ge_msg_stack.add;
63: app_exception.raise_exception;
64: RETURN;
65: END IF;
66: CLOSE cur_old_ref_values;
67:
212: )
213: ) THEN
214: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
215: igs_ge_msg_stack.add;
216: app_exception.raise_exception;
217: END IF;
218: ELSIF (p_action = 'VALIDATE_INSERT') THEN
219: -- Call all the procedures related to Before Insert.
220: IF ( get_pk_for_validation (
222: )
223: ) THEN
224: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
225: igs_ge_msg_stack.add;
226: app_exception.raise_exception;
227: END IF;
228: END IF;
229:
230: END before_dml;
304: END IF;
305: ELSE
306: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
307: igs_ge_msg_stack.add;
308: app_exception.raise_exception;
309: END IF;
310:
311: SELECT igf_db_ytd_smr_s.NEXTVAL
312: INTO x_ytds_id
481: IF (c1%notfound) THEN
482: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
483: igs_ge_msg_stack.add;
484: CLOSE c1;
485: app_exception.raise_exception;
486: RETURN;
487: END IF;
488: CLOSE c1;
489:
510: NULL;
511: ELSE
512: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
513: igs_ge_msg_stack.add;
514: app_exception.raise_exception;
515: END IF;
516:
517: RETURN;
518:
576: END IF;
577: ELSE
578: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
579: igs_ge_msg_stack.add;
580: app_exception.raise_exception;
581: END IF;
582:
583: before_dml(
584: p_action => 'UPDATE',