43: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
44: CLOSE cur_old_ref_values;
45: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
46: igs_ge_msg_stack.add;
47: app_exception.raise_exception;
48: RETURN;
49: END IF;
50: CLOSE cur_old_ref_values ;
51:
113: END IF;
114: ELSE
115: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
116: igs_ge_msg_stack.add;
117: app_exception.raise_exception;
118: END IF;
119:
120: set_column_values (
121: 'INSERT',
194: IF (c1%notfound) THEN
195: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
196: igs_ge_msg_stack.add;
197: CLOSE c1;
198: app_exception.raise_exception;
199: RETURN;
200: END IF;
201: CLOSE c1;
202:
208: NULL;
209: ELSE
210: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
211: igs_ge_msg_stack.add;
212: app_exception.raise_exception;
213: END IF;
214:
215: RETURN;
216:
254: END IF;
255: ELSE
256: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
257: igs_ge_msg_stack.add;
258: app_exception.raise_exception;
259: END IF;
260:
261: set_column_values (
262: 'UPDATE',