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;
88: ELSIF NOT igs_he_ut_calc_type_pkg.get_pk_for_validation (
89: new_references.tariff_calc_type_cd ,
90: 'N'
91: ) THEN
92: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
93: igs_ge_msg_stack.add;
94: app_exception.raise_exception;
95: END IF;
96:
176: new_references.tariff_calc_type_cd,
177: new_references.tariff_level_cd
178: )
179: ) THEN
180: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
181: igs_ge_msg_stack.add;
182: app_exception.raise_exception;
183: END IF;
184: check_parent_existance;
191: new_references.tariff_calc_type_cd,
192: new_references.tariff_level_cd
193: )
194: ) THEN
195: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
196: igs_ge_msg_stack.add;
197: app_exception.raise_exception;
198: END IF;
199: END IF;
237: IF (x_last_update_login IS NULL) THEN
238: x_last_update_login := -1;
239: END IF;
240: ELSE
241: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
242: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_CALC_LVL_PKG.INSERT_ROW');
243: igs_ge_msg_stack.add;
244: app_exception.raise_exception;
245: END IF;
238: x_last_update_login := -1;
239: END IF;
240: ELSE
241: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
242: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_CALC_LVL_PKG.INSERT_ROW');
243: igs_ge_msg_stack.add;
244: app_exception.raise_exception;
245: END IF;
246:
309:
310: OPEN c1;
311: FETCH c1 INTO tlinfo;
312: IF (c1%notfound) THEN
313: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
314: igs_ge_msg_stack.add;
315: CLOSE c1;
316: app_exception.raise_exception;
317: RETURN;
322: (tlinfo.closed_ind = x_closed_ind)
323: ) THEN
324: NULL;
325: ELSE
326: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
327: igs_ge_msg_stack.add;
328: app_exception.raise_exception;
329: END IF;
330:
368: IF (x_last_update_login IS NULL) THEN
369: x_last_update_login := -1;
370: END IF;
371: ELSE
372: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
373: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_CALC_LVL_PKG.UPDATE_ROW');
374: igs_ge_msg_stack.add;
375: app_exception.raise_exception;
376: END IF;
369: x_last_update_login := -1;
370: END IF;
371: ELSE
372: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
373: fnd_message.set_token ('ROUTINE', 'IGS_HE_UT_CALC_LVL_PKG.UPDATE_ROW');
374: igs_ge_msg_stack.add;
375: app_exception.raise_exception;
376: END IF;
377: