[Home] [Help]
57: OPEN cur_old_ref_values;
58: FETCH cur_old_ref_values INTO old_references;
59: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
60: CLOSE cur_old_ref_values;
61: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
62: igs_ge_msg_stack.add;
63: app_exception.raise_exception;
64: RETURN;
65: END IF;
199: IF ( get_pk_for_validation(
200: new_references.interface_mkdes_id
201: )
202: ) THEN
203: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
204: igs_ge_msg_stack.add;
205: app_exception.raise_exception;
206: END IF;
207: ELSIF (p_action = 'VALIDATE_INSERT') THEN
209: IF ( get_pk_for_validation (
210: new_references.interface_mkdes_id
211: )
212: ) THEN
213: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
214: igs_ge_msg_stack.add;
215: app_exception.raise_exception;
216: END IF;
217: END IF;
291: ELSE
292: x_program_update_date := SYSDATE;
293: END IF;
294: ELSE
295: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
296: igs_ge_msg_stack.add;
297: app_exception.raise_exception;
298: END IF;
299:
464:
465: OPEN c1;
466: FETCH c1 INTO tlinfo;
467: IF (c1%notfound) THEN
468: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
469: igs_ge_msg_stack.add;
470: CLOSE c1;
471: app_exception.raise_exception;
472: RETURN;
495: AND ((tlinfo.error_text = x_error_text) OR ((tlinfo.error_text IS NULL) AND (X_error_text IS NULL)))
496: ) THEN
497: NULL;
498: ELSE
499: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
500: igs_ge_msg_stack.add;
501: app_exception.raise_exception;
502: END IF;
503:
561: IF (x_last_update_login IS NULL) THEN
562: x_last_update_login := -1;
563: END IF;
564: ELSE
565: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
566: igs_ge_msg_stack.add;
567: app_exception.raise_exception;
568: END IF;
569: