43: FETCH cur_old_ref_values INTO old_references;
44: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
45: CLOSE cur_old_ref_values;
46: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
47: igs_ge_msg_stack.add;
48: app_exception.raise_exception;
49: RETURN;
50: END IF;
51: CLOSE cur_old_ref_values;
79: IF (p_inserting OR (p_updating AND (old_references.step_catalog_cd <> new_references.step_catalog_cd))) THEN
80: IF NOT IGS_TR_VAL_TRI.val_tr_step_ctlg (new_references.step_catalog_cd,
81: v_message_name) THEN
82: Fnd_Message.Set_Name('IGS', v_message_name);
83: IGS_GE_MSG_STACK.ADD;
84: App_Exception.Raise_Exception;
85: END IF;
86: END IF;
87: END BeforeRowInsertUpdate;
191: new_references.persl_stat_type
192: )
193: ) THEN
194: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
195: igs_ge_msg_stack.add;
196: app_exception.raise_exception;
197: END IF;
198: ELSIF (p_action = 'DELETE') THEN
199: -- Call all the procedures related to Before Delete.
204: new_references.persl_stat_type
205: )
206: ) THEN
207: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
208: igs_ge_msg_stack.add;
209: app_exception.raise_exception;
210: END IF;
211: ELSIF (p_action = 'VALIDATE_DELETE') THEN
212: check_child_existance;
257: x_last_update_login := -1;
258: END IF;
259: ELSE
260: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
261: igs_ge_msg_stack.add;
262: app_exception.raise_exception;
263: END IF;
264:
265: before_dml(
341: OPEN c1;
342: FETCH c1 INTO tlinfo;
343: IF (c1%notfound) THEN
344: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
345: igs_ge_msg_stack.add;
346: CLOSE c1;
347: app_exception.raise_exception;
348: RETURN;
349: END IF;
356: ) THEN
357: NULL;
358: ELSE
359: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
360: igs_ge_msg_stack.add;
361: app_exception.raise_exception;
362: END IF;
363:
364: RETURN;
403: x_last_update_login := -1;
404: END IF;
405: ELSE
406: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
407: igs_ge_msg_stack.add;
408: app_exception.raise_exception;
409: END IF;
410:
411: before_dml(