56: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
57: CLOSE cur_old_ref_values;
58: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
59: igs_ge_msg_stack.add;
60: app_exception.raise_exception;
61: RETURN;
62: END IF;
63: CLOSE cur_old_ref_values;
64:
115: new_references.clrp1_id
116: ) THEN
117: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
118: igs_ge_msg_stack.add;
119: app_exception.raise_exception;
120: END IF;
121:
122: END check_parent_existance;
123:
185: IF (cur_rowid%FOUND) THEN
186: CLOSE cur_rowid;
187: fnd_message.set_name ('IGF', 'IGF_SL_CLRP8_CLRP1_FK');
188: igs_ge_msg_stack.add;
189: app_exception.raise_exception;
190: RETURN;
191: END IF;
192: CLOSE cur_rowid;
193:
266: )
267: ) THEN
268: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
269: igs_ge_msg_stack.add;
270: app_exception.raise_exception;
271: END IF;
272: check_parent_existance;
273: ELSIF (p_action = 'UPDATE') THEN
274: -- Call all the procedures related to Before Update.
281: )
282: ) THEN
283: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
284: igs_ge_msg_stack.add;
285: app_exception.raise_exception;
286: END IF;
287: END IF;
288:
289: END before_dml;
362: END IF;
363: ELSE
364: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
365: igs_ge_msg_stack.add;
366: app_exception.raise_exception;
367: END IF;
368:
369: before_dml(
370: p_action => 'INSERT',
519: IF (c1%notfound) THEN
520: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
521: igs_ge_msg_stack.add;
522: CLOSE c1;
523: app_exception.raise_exception;
524: RETURN;
525: END IF;
526: CLOSE c1;
527:
545: NULL;
546: ELSE
547: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
548: igs_ge_msg_stack.add;
549: app_exception.raise_exception;
550: END IF;
551:
552: RETURN;
553:
608: END IF;
609: ELSE
610: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
611: igs_ge_msg_stack.add;
612: app_exception.raise_exception;
613: END IF;
614:
615: before_dml(
616: p_action => 'UPDATE',