42: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
43: CLOSE cur_old_ref_values;
44: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
45: igs_ge_msg_stack.add;
46: app_exception.raise_exception;
47: RETURN;
48: END IF;
49: CLOSE cur_old_ref_values;
50:
86: new_references.fund_code
87: ) THEN
88: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
89: igs_ge_msg_stack.add;
90: app_exception.raise_exception;
91: END IF;
92:
93: IF (((old_references.fund_id = new_references.fund_id)) OR
94: ((new_references.fund_id IS NULL))) THEN
97: new_references.fund_id
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: END check_parent_existance;
105:
169: IF (cur_rowid%FOUND) THEN
170: CLOSE cur_rowid;
171: fnd_message.set_name ('IGF', 'IGF_AW_FINC_FCAT_FK');
172: igs_ge_msg_stack.add;
173: app_exception.raise_exception;
174: RETURN;
175: END IF;
176: CLOSE cur_rowid;
177:
204: IF (cur_rowid%FOUND) THEN
205: CLOSE cur_rowid;
206: fnd_message.set_name ('IGF', 'IGF_AW_FINC_FMAST_FK');
207: igs_ge_msg_stack.add;
208: app_exception.raise_exception;
209: RETURN;
210: END IF;
211: CLOSE cur_rowid;
212:
256: )
257: ) THEN
258: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
259: igs_ge_msg_stack.add;
260: app_exception.raise_exception;
261: END IF;
262: check_parent_existance;
263: ELSIF (p_action = 'UPDATE') THEN
264: -- Call all the procedures related to Before Update.
271: )
272: ) THEN
273: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
274: igs_ge_msg_stack.add;
275: app_exception.raise_exception;
276: END IF;
277: END IF;
278:
279: END before_dml;
322: END IF;
323: ELSE
324: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
325: igs_ge_msg_stack.add;
326: app_exception.raise_exception;
327: END IF;
328:
329: before_dml(
330: 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: