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:
115: new_references.src_cat_id
116: ) THEN
117: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
118: igs_ge_msg_stack.add;
119: app_exception.raise_exception;
120: END IF;
121:
122: END check_parent_existance;
123:
220: IF (cur_rowid%FOUND) THEN
221: CLOSE cur_rowid;
222: fnd_message.set_name ('IGS', 'IGS_AD_ADDA_ADSC_FK');
223: igs_ge_msg_stack.add;
224: app_exception.raise_exception;
225: RETURN;
226: END IF;
227: CLOSE cur_rowid;
228:
275: )
276: ) THEN
277: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
278: igs_ge_msg_stack.add;
279: app_exception.raise_exception;
280: END IF;
281: check_uniqueness;
282: check_parent_existance;
283: ELSIF (p_action = 'UPDATE') THEN
291: )
292: ) THEN
293: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
294: igs_ge_msg_stack.add;
295: app_exception.raise_exception;
296: END IF;
297: check_uniqueness;
298: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
299: check_uniqueness;
345: END IF;
346: ELSE
347: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
348: igs_ge_msg_stack.add;
349: app_exception.raise_exception;
350: END IF;
351:
352: x_discrepancy_attr_id := -1;
353: before_dml(
431: IF (c1%notfound) THEN
432: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
433: igs_ge_msg_stack.add;
434: CLOSE c1;
435: app_exception.raise_exception;
436: RETURN;
437: END IF;
438: CLOSE c1;
439:
445: NULL;
446: ELSE
447: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
448: igs_ge_msg_stack.add;
449: app_exception.raise_exception;
450: END IF;
451:
452: RETURN;
453:
492: END IF;
493: ELSE
494: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
495: igs_ge_msg_stack.add;
496: app_exception.raise_exception;
497: END IF;
498:
499: before_dml(
500: p_action => 'UPDATE',