38: FETCH cur_old_ref_values INTO old_references;
39: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
40: CLOSE cur_old_ref_values;
41: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
42: igs_ge_msg_stack.add;
43: app_exception.raise_exception;
44: RETURN;
45: END IF;
46: CLOSE cur_old_ref_values;
82: new_references.but_label
83: )
84: ) THEN
85: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
86: igs_ge_msg_stack.add;
87: app_exception.raise_exception;
88: END IF;
89:
90: END check_uniqueness;
206: new_references.subform_code
207: )
208: ) THEN
209: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
210: igs_ge_msg_stack.add;
211: app_exception.raise_exception;
212: END IF;
213: check_uniqueness;
214: ELSIF (p_action = 'UPDATE') THEN
222: new_references.subform_code
223: )
224: ) THEN
225: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
226: igs_ge_msg_stack.add;
227: app_exception.raise_exception;
228: END IF;
229: check_uniqueness;
230: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
267: x_last_update_login := -1;
268: END IF;
269: ELSE
270: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
271: igs_ge_msg_stack.add;
272: app_exception.raise_exception;
273: END IF;
274: before_dml(
275: p_action => 'INSERT',
339: OPEN c1;
340: FETCH c1 INTO tlinfo;
341: IF (c1%notfound) THEN
342: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
343: igs_ge_msg_stack.add;
344: CLOSE c1;
345: app_exception.raise_exception;
346: RETURN;
347: END IF;
353: ) THEN
354: NULL;
355: ELSE
356: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
357: igs_ge_msg_stack.add;
358: app_exception.raise_exception;
359: END IF;
360: RETURN;
361: END lock_row;
395: x_last_update_login := -1;
396: END IF;
397: ELSE
398: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
399: igs_ge_msg_stack.add;
400: app_exception.raise_exception;
401: END IF;
402: before_dml(
403: p_action => 'UPDATE',