41: OPEN cur_old_ref_values;
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;
87: ELSIF NOT igs_he_ut_calc_type_pkg.get_pk_for_validation (
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:
98: NULL;
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:
110: NULL;
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:
198: new_references.tariff_calc_type_cd,
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;
213: new_references.tariff_calc_type_cd,
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;
259: IF (x_last_update_login IS NULL) THEN
260: x_last_update_login := -1;
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;
260: x_last_update_login := -1;
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:
330:
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;
343: (tlinfo.parent_award_cd = x_parent_award_cd)
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:
389: IF (x_last_update_login IS NULL) THEN
390: x_last_update_login := -1;
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;
390: x_last_update_login := -1;
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: