56: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
57: CLOSE cur_old_ref_values;
58: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
59: igs_ge_msg_stack.add;
60: app_exception.raise_exception;
61: RETURN;
62: END IF;
63: CLOSE cur_old_ref_values;
64:
113: new_references.app_id
114: ) THEN
115: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
116: igs_ge_msg_stack.add;
117: app_exception.raise_exception;
118: END IF;
119:
120: IF (((old_references.subject_id = new_references.subject_id)) OR
121: ((new_references.subject_id IS NULL))) THEN
124: new_references.subject_id
125: ) THEN
126: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
127: igs_ge_msg_stack.add;
128: app_exception.raise_exception;
129: END IF;
130:
131: END check_parent_existance;
132:
191: IF (cur_rowid%FOUND) THEN
192: CLOSE cur_rowid;
193: fnd_message.set_name ('IGS', 'IGS_UC_UCAPRE_UCAP_FK');
194: igs_ge_msg_stack.add;
195: app_exception.raise_exception;
196: RETURN;
197: END IF;
198: CLOSE cur_rowid;
199:
226: IF (cur_rowid%FOUND) THEN
227: CLOSE cur_rowid;
228: fnd_message.set_name ('IGS', 'IGS_UC_UCAPRE_UCCOES_FK');
229: igs_ge_msg_stack.add;
230: app_exception.raise_exception;
231: RETURN;
232: END IF;
233: CLOSE cur_rowid;
234:
304: )
305: ) THEN
306: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
307: igs_ge_msg_stack.add;
308: app_exception.raise_exception;
309: END IF;
310: check_parent_existance;
311: ELSIF (p_action = 'UPDATE') THEN
312: -- Call all the procedures related to Before Update.
318: )
319: ) THEN
320: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
321: igs_ge_msg_stack.add;
322: app_exception.raise_exception;
323: END IF;
324: END IF;
325:
326: END before_dml;
381: END IF;
382: ELSE
383: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
384: igs_ge_msg_stack.add;
385: app_exception.raise_exception;
386: END IF;
387:
388: SELECT igs_uc_app_results_s.NEXTVAL
389: INTO x_app_result_id
526: IF (c1%notfound) THEN
527: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
528: igs_ge_msg_stack.add;
529: CLOSE c1;
530: app_exception.raise_exception;
531: RETURN;
532: END IF;
533: CLOSE c1;
534:
551: NULL;
552: ELSE
553: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
554: igs_ge_msg_stack.add;
555: app_exception.raise_exception;
556: END IF;
557:
558: RETURN;
559:
610: END IF;
611: ELSE
612: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
613: igs_ge_msg_stack.add;
614: app_exception.raise_exception;
615: END IF;
616:
617: before_dml(
618: p_action => 'UPDATE',