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:
135: new_references.party_id
136: ) THEN
137: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
138: igs_ge_msg_stack.add;
139: app_exception.raise_exception;
140: END IF;
141:
142: IF (((old_references.inquiry_type_id = new_references.inquiry_type_id)) OR
143: ((new_references.inquiry_type_id IS NULL))) THEN
146: new_references.inquiry_type_id
147: ) THEN
148: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
149: igs_ge_msg_stack.add;
150: app_exception.raise_exception;
151: END IF;
152:
153: END check_parent_existance;
154:
255: IF (cur_rowid%FOUND) THEN
256: CLOSE cur_rowid;
257: fnd_message.set_name ('IGS', 'IGS_AD_AIEOU_AIEST_FK');
258: igs_ge_msg_stack.add;
259: app_exception.raise_exception;
260: RETURN;
261: END IF;
262: CLOSE cur_rowid;
263:
310: )
311: ) THEN
312: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
313: igs_ge_msg_stack.add;
314: app_exception.raise_exception;
315: END IF;
316: check_uniqueness;
317: check_parent_existance;
318: ELSIF (p_action = 'UPDATE') THEN
326: )
327: ) THEN
328: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
329: igs_ge_msg_stack.add;
330: app_exception.raise_exception;
331: END IF;
332: check_uniqueness;
333: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
334: check_uniqueness;
380: END IF;
381: ELSE
382: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
383: igs_ge_msg_stack.add;
384: app_exception.raise_exception;
385: END IF;
386:
387: X_ENT_ORG_UNIT_ID := -1;
388: before_dml(
466: IF (c1%notfound) THEN
467: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
468: igs_ge_msg_stack.add;
469: CLOSE c1;
470: app_exception.raise_exception;
471: RETURN;
472: END IF;
473: CLOSE c1;
474:
480: NULL;
481: ELSE
482: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
483: igs_ge_msg_stack.add;
484: app_exception.raise_exception;
485: END IF;
486:
487: RETURN;
488:
527: END IF;
528: ELSE
529: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
530: igs_ge_msg_stack.add;
531: app_exception.raise_exception;
532: END IF;
533:
534: before_dml(
535: p_action => 'UPDATE',