45: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
46: CLOSE cur_old_ref_values;
47: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
48: igs_ge_msg_stack.add;
49: app_exception.raise_exception;
50: RETURN;
51: END IF;
52: CLOSE cur_old_ref_values;
53:
95: new_references.version_number
96: ) THEN
97: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
98: igs_ge_msg_stack.add;
99: app_exception.raise_exception;
100: END IF;
101:
102: IF (((old_references.cal_type = new_references.cal_type)) OR
103: ((new_references.cal_type IS NULL))) THEN
106: new_references.cal_type
107: ) THEN
108: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
109: igs_ge_msg_stack.add;
110: app_exception.raise_exception;
111: END IF;
112:
113: END check_parent_existance;
114:
180: IF (cur_rowid%FOUND) THEN
181: CLOSE cur_rowid;
182: fnd_message.set_name ('IGS', 'IGS_EN_CEC_CRV_FK');
183: igs_ge_msg_stack.add;
184: app_exception.raise_exception;
185: RETURN;
186: END IF;
187: CLOSE cur_rowid;
188:
215: IF (cur_rowid%FOUND) THEN
216: CLOSE cur_rowid;
217: fnd_message.set_name ('IGS', 'IGS_EN_CEC_CAT_FK');
218: igs_ge_msg_stack.add;
219: app_exception.raise_exception;
220: RETURN;
221: END IF;
222: CLOSE cur_rowid;
223:
274: )
275: ) THEN
276: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
277: igs_ge_msg_stack.add;
278: app_exception.raise_exception;
279: END IF;
280: check_parent_existance;
281: ELSIF (p_action = 'UPDATE') THEN
282: -- 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;
338: END IF;
339: ELSE
340: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
341: igs_ge_msg_stack.add;
342: app_exception.raise_exception;
343: END IF;
344:
345: before_dml(
346: p_action => 'INSERT',
418: IF (c1%notfound) THEN
419: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
420: igs_ge_msg_stack.add;
421: CLOSE c1;
422: app_exception.raise_exception;
423: RETURN;
424: END IF;
425: CLOSE c1;
426:
431: NULL;
432: ELSE
433: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
434: igs_ge_msg_stack.add;
435: app_exception.raise_exception;
436: END IF;
437:
438: RETURN;
439:
479: END IF;
480: ELSE
481: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
482: igs_ge_msg_stack.add;
483: app_exception.raise_exception;
484: END IF;
485:
486: before_dml(
487: p_action => 'UPDATE',