42: FETCH cur_old_ref_values INTO old_references;
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;
88: new_references.tariff_calc_type_cd,
89: 'N'
90: ) THEN
91: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
92: igs_ge_msg_stack.add;
93: app_exception.raise_exception;
94: END IF;
95:
96: IF (((old_references.award_cd = new_references.award_cd)) OR
99: ELSIF NOT igs_ps_awd_pkg.get_pk_for_validation (
100: new_references.award_cd
101: ) THEN
102: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
103: igs_ge_msg_stack.add;
104: app_exception.raise_exception;
105: END IF;
106:
107:
111: ELSIF NOT igs_ps_awd_pkg.get_pk_for_validation (
112: new_references.parent_award_cd
113: ) THEN
114: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
115: igs_ge_msg_stack.add;
116: app_exception.raise_exception;
117: END IF;
118:
119: END check_parent_existance;
199: new_references.award_cd
200: )
201: ) THEN
202: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
203: igs_ge_msg_stack.add;
204: app_exception.raise_exception;
205: END IF;
206: check_parent_existance;
207: ELSIF (p_action = 'UPDATE') THEN
214: new_references.award_cd
215: )
216: ) THEN
217: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
218: igs_ge_msg_stack.add;
219: app_exception.raise_exception;
220: END IF;
221: END IF;
222:
261: END IF;
262: ELSE
263: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
264: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_PRT_AWARD_PKG.INSERT_ROW');
265: igs_ge_msg_stack.add;
266: app_exception.raise_exception;
267: END IF;
268:
269: before_dml(
331: OPEN c1;
332: FETCH c1 INTO tlinfo;
333: IF (c1%notfound) THEN
334: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
335: igs_ge_msg_stack.add;
336: CLOSE c1;
337: app_exception.raise_exception;
338: RETURN;
339: END IF;
344: ) THEN
345: NULL;
346: ELSE
347: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
348: igs_ge_msg_stack.add;
349: app_exception.raise_exception;
350: END IF;
351:
352: RETURN;
391: END IF;
392: ELSE
393: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
394: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_PRT_AWARD_PKG.UPDATE_ROW');
395: igs_ge_msg_stack.add;
396: app_exception.raise_exception;
397: END IF;
398:
399: before_dml(