41: FETCH cur_old_ref_values INTO old_references;
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;
161: new_references.keyword
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.
174: new_references.keyword
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;
225: x_last_update_login := -1;
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
303: OPEN c1;
304: FETCH c1 INTO tlinfo;
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;
316: ) THEN
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;
361: x_last_update_login := -1;
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(