43: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
44: CLOSE cur_old_ref_values;
45: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
46: igs_ge_msg_stack.add;
47: app_exception.raise_exception;
48: RETURN;
49: END IF;
50: CLOSE cur_old_ref_values;
51:
88: new_references.assessment_type
89: ) THEN
90: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
91: igs_ge_msg_stack.add;
92: app_exception.raise_exception;
93: END IF;
94:
95: IF (((old_references.load_cal_type = new_references.load_cal_type)) OR
96: ((new_references.load_cal_type IS NULL))) THEN
99: new_references.load_cal_type
100: ) THEN
101: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
102: igs_ge_msg_stack.add;
103: app_exception.raise_exception;
104: END IF;
105:
106: END check_parent_existance;
107:
167: IF (cur_rowid%FOUND) THEN
168: CLOSE cur_rowid;
169: fnd_message.set_name ('IGS', 'IGS_AS_ANON_ATYP_FK');
170: igs_ge_msg_stack.add;
171: app_exception.raise_exception;
172: RETURN;
173: END IF;
174: CLOSE cur_rowid;
175:
202: IF (cur_rowid%FOUND) THEN
203: CLOSE cur_rowid;
204: fnd_message.set_name ('IGS', 'IGS_AS_ANON_CAT_FK');
205: igs_ge_msg_stack.add;
206: app_exception.raise_exception;
207: RETURN;
208: END IF;
209: CLOSE cur_rowid;
210:
255: )
256: ) THEN
257: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
258: igs_ge_msg_stack.add;
259: app_exception.raise_exception;
260: END IF;
261: check_parent_existance;
262: ELSIF (p_action = 'UPDATE') THEN
263: -- Call all the procedures related to Before Update.
269: )
270: ) THEN
271: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
272: igs_ge_msg_stack.add;
273: app_exception.raise_exception;
274: END IF;
275: END IF;
276:
277: END before_dml;
319: END IF;
320: ELSE
321: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
322: igs_ge_msg_stack.add;
323: app_exception.raise_exception;
324: END IF;
325:
326: before_dml(
327: p_action => 'INSERT',
399: IF (c1%notfound) THEN
400: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
401: igs_ge_msg_stack.add;
402: CLOSE c1;
403: app_exception.raise_exception;
404: RETURN;
405: END IF;
406: CLOSE c1;
407:
412: NULL;
413: ELSE
414: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
415: igs_ge_msg_stack.add;
416: app_exception.raise_exception;
417: END IF;
418:
419: RETURN;
420:
458: END IF;
459: ELSE
460: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
461: igs_ge_msg_stack.add;
462: app_exception.raise_exception;
463: END IF;
464:
465: before_dml(
466: p_action => 'UPDATE',