59: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
60: CLOSE cur_old_ref_values;
61: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
62: igs_ge_msg_stack.add;
63: app_exception.raise_exception;
64: RETURN;
65: END IF;
66: CLOSE cur_old_ref_values;
67:
122: new_references.person_id
123: ) THEN
124: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
125: igs_ge_msg_stack.add;
126: app_exception.raise_exception;
127: END IF;
128:
129: END check_parent_existance;
130:
191: IF (cur_rowid%FOUND) THEN
192: CLOSE cur_rowid;
193: fnd_message.set_name ('IGS', 'IGS_UC_UCEQS_IHP_FK');
194: igs_ge_msg_stack.add;
195: app_exception.raise_exception;
196: RETURN;
197: END IF;
198: CLOSE cur_rowid;
199:
276: )
277: ) THEN
278: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
279: igs_ge_msg_stack.add;
280: app_exception.raise_exception;
281: END IF;
282: check_parent_existance;
283: ELSIF (p_action = 'UPDATE') THEN
284: -- Call all the procedures related to Before Update.
290: )
291: ) THEN
292: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
293: igs_ge_msg_stack.add;
294: app_exception.raise_exception;
295: END IF;
296: END IF;
297:
298: END before_dml;
356: END IF;
357: ELSE
358: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
359: igs_ge_msg_stack.add;
360: app_exception.raise_exception;
361: END IF;
362:
363: SELECT igs_uc_exp_qual_sum_s.NEXTVAL
364: INTO x_exp_qual_sum_id
520: IF (c1%notfound) THEN
521: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
522: igs_ge_msg_stack.add;
523: CLOSE c1;
524: app_exception.raise_exception;
525: RETURN;
526: END IF;
527: CLOSE c1;
528:
549: NULL;
550: ELSE
551: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
552: igs_ge_msg_stack.add;
553: app_exception.raise_exception;
554: END IF;
555:
556: RETURN;
557:
611: END IF;
612: ELSE
613: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
614: igs_ge_msg_stack.add;
615: app_exception.raise_exception;
616: END IF;
617:
618: before_dml(
619: p_action => 'UPDATE',