166: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
167: CLOSE cur_old_ref_values;
168: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
169: igs_ge_msg_stack.add;
170: app_exception.raise_exception;
171: RETURN;
172: END IF;
173: CLOSE cur_old_ref_values;
174:
333: new_references.cbth_id
334: ) THEN
335: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
336: igs_ge_msg_stack.add;
337: app_exception.raise_exception;
338: END IF;
339:
340: END check_parent_existance;
341:
432: IF (cur_rowid%FOUND) THEN
433: CLOSE cur_rowid;
434: fnd_message.set_name ('IGF', 'IGF_SL_CLRP1_CBTH_FK');
435: igs_ge_msg_stack.add;
436: app_exception.raise_exception;
437: RETURN;
438: END IF;
439: CLOSE cur_rowid;
440:
731: )
732: ) THEN
733: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
734: igs_ge_msg_stack.add;
735: app_exception.raise_exception;
736: END IF;
737: check_parent_existance;
738: ELSIF (p_action = 'UPDATE') THEN
739: -- Call all the procedures related to Before Update.
748: )
749: ) THEN
750: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
751: igs_ge_msg_stack.add;
752: app_exception.raise_exception;
753: END IF;
754: ELSIF (p_action = 'VALIDATE_DELETE') THEN
755: check_child_existance;
756: END IF;
940: END IF;
941: ELSE
942: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
943: igs_ge_msg_stack.add;
944: app_exception.raise_exception;
945: END IF;
946:
947: SELECT igf_sl_cl_resp_r1_s.nextval
948: INTO x_clrp1_id
1652: IF (c1%notfound) THEN
1653: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1654: igs_ge_msg_stack.add;
1655: CLOSE c1;
1656: app_exception.raise_exception;
1657: RETURN;
1658: END IF;
1659: CLOSE c1;
1660:
1788: NULL;
1789: ELSE
1790: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1791: igs_ge_msg_stack.add;
1792: app_exception.raise_exception;
1793: END IF;
1794:
1795: RETURN;
1796:
1961: END IF;
1962: ELSE
1963: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1964: igs_ge_msg_stack.add;
1965: app_exception.raise_exception;
1966: END IF;
1967:
1968: before_dml(
1969: p_action => 'UPDATE',