42: FETCH cur_old_ref_values INTO old_references;
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;
149: new_references.completion_perd
150: )
151: ) THEN
152: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
153: igs_ge_msg_stack.add;
154: app_exception.raise_exception;
155: END IF;
156:
157: ELSIF (p_action = 'VALIDATE_INSERT') THEN
160: new_references.completion_perd
161: )
162: ) THEN
163: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
164: igs_ge_msg_stack.add;
165: app_exception.raise_exception;
166: END IF;
167:
168: END IF;
211: x_last_update_login := -1;
212: END IF;
213: ELSE
214: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
215: igs_ge_msg_stack.add;
216: app_exception.raise_exception;
217: END IF;
218:
219: before_dml(
290: OPEN c1;
291: FETCH c1 INTO tlinfo;
292: IF (c1%notfound) THEN
293: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
294: igs_ge_msg_stack.add;
295: CLOSE c1;
296: app_exception.raise_exception;
297: RETURN;
298: END IF;
304: ) THEN
305: NULL;
306: ELSE
307: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
308: igs_ge_msg_stack.add;
309: app_exception.raise_exception;
310: END IF;
311:
312: RETURN;
350: x_last_update_login := -1;
351: END IF;
352: ELSE
353: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
354: igs_ge_msg_stack.add;
355: app_exception.raise_exception;
356: END IF;
357:
358: before_dml(