42: OPEN cur_old_ref_values;
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;
87: new_references.src_cat_id,
88: new_references.attribute_name
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:
113: NULL;
114: ELSIF NOT igs_ad_source_cat_pkg.get_pk_for_validation (
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:
218: OPEN cur_rowid;
219: FETCH cur_rowid INTO lv_rowid;
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;
273: IF ( get_pk_for_validation(
274: new_references.discrepancy_attr_id
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;
289: IF ( get_pk_for_validation (
290: new_references.discrepancy_attr_id
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;
343: IF (x_last_update_login IS NULL) THEN
344: x_last_update_login := -1;
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:
428:
429: OPEN c1;
430: FETCH c1 INTO tlinfo;
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;
443: AND (tlinfo.discrepancy_rule_cd = x_discrepancy_rule_cd)
444: ) THEN
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:
490: IF (x_last_update_login IS NULL) THEN
491: x_last_update_login := -1;
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: