46: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
47: CLOSE cur_old_ref_values;
48: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
49: igs_ge_msg_stack.add;
50: app_exception.raise_exception;
51: RETURN;
52: END IF;
53: CLOSE cur_old_ref_values;
54:
97: new_references.item_code
98: ) THEN
99: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
100: igs_ge_msg_stack.add;
101: app_exception.raise_exception;
102: END IF;
103:
104: IF (((old_references.ld_cal_type = new_references.ld_cal_type) AND
105: (old_references.ld_sequence_number = new_references.ld_sequence_number)) OR
111: new_references.ld_sequence_number
112: ) THEN
113: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
114: igs_ge_msg_stack.add;
115: app_exception.raise_exception;
116: END IF;
117:
118: END check_parent_existance;
119:
187: IF (cur_rowid%FOUND) THEN
188: CLOSE cur_rowid;
189: fnd_message.set_name ('IGF', 'IGF_AW_COAIT_COAI_FK');
190: igs_ge_msg_stack.add;
191: app_exception.raise_exception;
192: RETURN;
193: END IF;
194: CLOSE cur_rowid;
195:
224: IF (cur_rowid%FOUND) THEN
225: CLOSE cur_rowid;
226: fnd_message.set_name ('IGF', 'IGF_AW_COAIT_CI_FK');
227: igs_ge_msg_stack.add;
228: app_exception.raise_exception;
229: RETURN;
230: END IF;
231: CLOSE cur_rowid;
232:
286: )
287: ) THEN
288: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
289: igs_ge_msg_stack.add;
290: app_exception.raise_exception;
291: END IF;
292: check_parent_existance;
293: ELSIF (p_action = 'UPDATE') THEN
294: -- Call all the procedures related to Before Update.
303: )
304: ) THEN
305: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
306: igs_ge_msg_stack.add;
307: app_exception.raise_exception;
308: END IF;
309: END IF;
310:
311: END before_dml;
525: END IF;
526: ELSE
527: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
528: igs_ge_msg_stack.add;
529: app_exception.raise_exception;
530: END IF;
531:
532: before_dml(
533: p_action => 'INSERT',
621: IF (c1%notfound) THEN
622: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
623: igs_ge_msg_stack.add;
624: CLOSE c1;
625: app_exception.raise_exception;
626: RETURN;
627: END IF;
628: CLOSE c1;
629:
634: NULL;
635: ELSE
636: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
637: igs_ge_msg_stack.add;
638: app_exception.raise_exception;
639: END IF;
640:
641: RETURN;
642:
687: END IF;
688: ELSE
689: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
690: igs_ge_msg_stack.add;
691: app_exception.raise_exception;
692: END IF;
693:
694: before_dml(
695: p_action => 'UPDATE',