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;
52:
89: )
90: ) THEN
91: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
92: igs_ge_msg_stack.add;
93: app_exception.raise_exception;
94: END IF;
95:
96: END check_uniqueness;
97:
232: )
233: ) THEN
234: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
235: igs_ge_msg_stack.add;
236: app_exception.raise_exception;
237: END IF;
238: check_uniqueness;
239: ELSIF (p_action = 'UPDATE') THEN
240: -- Call all the procedures related to Before Update.
249: )
250: ) THEN
251: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
252: igs_ge_msg_stack.add;
253: app_exception.raise_exception;
254: END IF;
255: check_uniqueness;
256: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
257: check_uniqueness;
307: END IF;
308: ELSE
309: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
310: igs_ge_msg_stack.add;
311: app_exception.raise_exception;
312: END IF;
313:
314:
315: new_references.org_id := igs_ge_gen_003.get_org_id;
400: IF (c1%notfound) THEN
401: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
402: igs_ge_msg_stack.add;
403: CLOSE c1;
404: app_exception.raise_exception;
405: RETURN;
406: END IF;
407: CLOSE c1;
408:
414: NULL;
415: ELSE
416: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
417: igs_ge_msg_stack.add;
418: app_exception.raise_exception;
419: END IF;
420:
421: RETURN;
422:
461: END IF;
462: ELSE
463: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
464: igs_ge_msg_stack.add;
465: app_exception.raise_exception;
466: END IF;
467:
468: before_dml(
469: p_action => 'UPDATE',