[Home] [Help]
74: OPEN cur_old_ref_values;
75: FETCH cur_old_ref_values INTO old_references;
76: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
77: CLOSE cur_old_ref_values;
78: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
79: igs_ge_msg_stack.add;
80: app_exception.raise_exception;
81: RETURN;
82: END IF;
278: IF ( get_pk_for_validation(
279: new_references.mrr_id
280: )
281: ) THEN
282: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
283: igs_ge_msg_stack.add;
284: app_exception.raise_exception;
285: END IF;
286: ELSIF (p_action = 'VALIDATE_INSERT') THEN
288: IF ( get_pk_for_validation (
289: new_references.mrr_id
290: )
291: ) THEN
292: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
293: igs_ge_msg_stack.add;
294: app_exception.raise_exception;
295: END IF;
296: END IF;
391: ELSE
392: x_program_update_date := SYSDATE;
393: END IF;
394: ELSE
395: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
396: igs_ge_msg_stack.add;
397: app_exception.raise_exception;
398: END IF;
399:
647:
648: OPEN c1;
649: FETCH c1 INTO tlinfo;
650: IF (c1%notfound) THEN
651: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
652: igs_ge_msg_stack.add;
653: CLOSE c1;
654: app_exception.raise_exception;
655: RETURN;
694: AND ((tlinfo.current_ssn = x_current_ssn) OR ((tlinfo.current_ssn IS NULL) AND (x_current_ssn IS NULL)))
695: ) THEN
696: NULL;
697: ELSE
698: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
699: igs_ge_msg_stack.add;
700: app_exception.raise_exception;
701: END IF;
702:
777: IF (x_last_update_login IS NULL) THEN
778: x_last_update_login := -1;
779: END IF;
780: ELSE
781: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
782: igs_ge_msg_stack.add;
783: app_exception.raise_exception;
784: END IF;
785: