42: OPEN cur_old_ref_values;
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;
85: IF ( get_uk_for_validation (
86: new_references.class_standing
87: )
88: ) THEN
89: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
90: igs_ge_msg_stack.add;
91: app_exception.raise_exception;
92: END IF;
93:
249: IF ( get_pk_for_validation(
250: new_references.igs_pr_class_std_id
251: )
252: ) THEN
253: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
254: igs_ge_msg_stack.add;
255: app_exception.raise_exception;
256: END IF;
257: check_uniqueness;
266: IF ( get_pk_for_validation (
267: new_references.igs_pr_class_std_id
268: )
269: ) THEN
270: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
271: igs_ge_msg_stack.add;
272: app_exception.raise_exception;
273: END IF;
274: check_uniqueness;
322: IF (x_last_update_login IS NULL) THEN
323: x_last_update_login := -1;
324: END IF;
325: ELSE
326: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
327: igs_ge_msg_stack.add;
328: app_exception.raise_exception;
329: END IF;
330:
410:
411: OPEN c1;
412: FETCH c1 INTO tlinfo;
413: IF (c1%notfound) THEN
414: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
415: igs_ge_msg_stack.add;
416: CLOSE c1;
417: app_exception.raise_exception;
418: RETURN;
425: AND (tlinfo.closed_ind = x_closed_ind)
426: ) THEN
427: NULL;
428: ELSE
429: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
430: igs_ge_msg_stack.add;
431: app_exception.raise_exception;
432: END IF;
433:
472: IF (x_last_update_login IS NULL) THEN
473: x_last_update_login := -1;
474: END IF;
475: ELSE
476: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
477: igs_ge_msg_stack.add;
478: app_exception.raise_exception;
479: END IF;
480: