42: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
43: CLOSE cur_old_ref_values;
44: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
45: igs_ge_msg_stack.add;
46: app_exception.raise_exception;
47: RETURN;
48: END IF;
49: CLOSE cur_old_ref_values;
50:
162: )
163: ) THEN
164: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
165: igs_ge_msg_stack.add;
166: app_exception.raise_exception;
167: END IF;
168: ELSIF (p_action = 'DELETE') THEN
169: -- Call all the procedures related to Before Delete.
170: check_child_existance;
175: )
176: ) THEN
177: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
178: igs_ge_msg_stack.add;
179: app_exception.raise_exception;
180: END IF;
181: ELSIF (p_action = 'VALIDATE_DELETE') THEN
182: check_child_existance;
183: END IF;
226: END IF;
227: ELSE
228: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
229: igs_ge_msg_stack.add;
230: app_exception.raise_exception;
231: END IF;
232:
233: /* SELECT igs_uc_ref_keywords_s.NEXTVAL
234: INTO x_keyword
305: IF (c1%notfound) THEN
306: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
307: igs_ge_msg_stack.add;
308: CLOSE c1;
309: app_exception.raise_exception;
310: RETURN;
311: END IF;
312: CLOSE c1;
313:
317: NULL;
318: ELSE
319: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
320: igs_ge_msg_stack.add;
321: app_exception.raise_exception;
322: END IF;
323:
324: RETURN;
325:
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 => 'UPDATE',