113: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
114: CLOSE cur_old_ref_values;
115: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
116: igs_ge_msg_stack.add;
117: app_exception.raise_exception;
118: RETURN;
119: END IF;
120: CLOSE cur_old_ref_values;
121:
230: END IF;
231: ELSE
232: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
233: igs_ge_msg_stack.add;
234: app_exception.raise_exception;
235: END IF;
236:
237: before_dml(
238: p_action => 'INSERT',
373: IF (c1%notfound) THEN
374: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
375: igs_ge_msg_stack.add;
376: CLOSE c1;
377: app_exception.raise_exception;
378: RETURN;
379: END IF;
380: CLOSE c1;
381:
390: NULL;
391: ELSE
392: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
393: igs_ge_msg_stack.add;
394: app_exception.raise_exception;
395: END IF;
396:
397: -- Initialize API return status to success.
398: x_return_status := fnd_api.g_ret_sts_success;
477: END IF;
478: ELSE
479: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
480: igs_ge_msg_stack.add;
481: app_exception.raise_exception;
482: END IF;
483:
484: before_dml(
485: p_action => 'UPDATE',