[Home] [Help]
43: FETCH cur_old_ref_values INTO old_references;
44: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
45: CLOSE cur_old_ref_values;
46: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
47: igs_ge_msg_stack.add;
48: app_exception.raise_exception;
49: RETURN;
50: END IF;
51: CLOSE cur_old_ref_values;
174: new_references.delivery_method_type
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 = 'DELETE') THEN
182: -- Call all the procedures related to Before Delete.
187: new_references.delivery_method_type
188: )
189: ) THEN
190: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
191: igs_ge_msg_stack.add;
192: app_exception.raise_exception;
193: END IF;
194: ELSIF (p_action = 'VALIDATE_DELETE') THEN
195: check_child_existance;
240: x_last_update_login := -1;
241: END IF;
242: ELSE
243: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
244: igs_ge_msg_stack.add;
245: app_exception.raise_exception;
246: END IF;
247:
248: before_dml(
324: OPEN c1;
325: FETCH c1 INTO tlinfo;
326: IF (c1%notfound) THEN
327: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
328: igs_ge_msg_stack.add;
329: CLOSE c1;
330: app_exception.raise_exception;
331: RETURN;
332: END IF;
339: ) THEN
340: NULL;
341: ELSE
342: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
343: igs_ge_msg_stack.add;
344: app_exception.raise_exception;
345: END IF;
346:
347: RETURN;
386: x_last_update_login := -1;
387: END IF;
388: ELSE
389: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
390: igs_ge_msg_stack.add;
391: app_exception.raise_exception;
392: END IF;
393:
394: before_dml(