49: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
50: CLOSE cur_old_ref_values;
51: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
52: igs_ge_msg_stack.ADD;
53: app_exception.raise_exception;
54: RETURN;
55: END IF;
56: CLOSE cur_old_ref_values;
57:
140: )
141: ) THEN
142: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
143: igs_ge_msg_stack.add;
144: app_exception.raise_exception;
145: END IF;
146:
147: ELSIF (p_action = 'VALIDATE_INSERT') THEN
148: -- Call all the procedures related to Before Insert.
154: )
155: ) THEN
156: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
157: igs_ge_msg_stack.add;
158: app_exception.raise_exception;
159: END IF;
160:
161: END IF;
162:
211: END IF;
212: ELSE
213: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
214: igs_ge_msg_stack.ADD;
215: app_exception.raise_exception;
216: END IF;
217:
218: before_dml(
219: p_action => 'INSERT',
322: IF (c1%NOTFOUND) THEN
323: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
324: igs_ge_msg_stack.ADD;
325: CLOSE c1;
326: app_exception.raise_exception;
327: RETURN;
328: END IF;
329: CLOSE c1;
330:
342: NULL;
343: ELSE
344: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
345: igs_ge_msg_stack.ADD;
346: app_exception.raise_exception;
347: END IF;
348:
349: RETURN;
350:
433: END IF;
434: ELSE
435: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
436: igs_ge_msg_stack.ADD;
437: app_exception.raise_exception;
438: END IF;
439:
440: before_dml(
441: p_action => 'UPDATE',