[Home] [Help]
60: OPEN cur_old_ref_values;
61: FETCH cur_old_ref_values INTO old_references;
62: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
63: CLOSE cur_old_ref_values;
64: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
65: igs_ge_msg_stack.add;
66: app_exception.raise_exception;
67: RETURN;
68: END IF;
187: /*IF ( get_pk_for_validation(x_lookup_type,x_lookup_code
188:
189: )
190: ) THEN
191: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
192: igs_ge_msg_stack.add;
193: app_exception.raise_exception;
194: END IF;
195: ELSIF (p_action = 'VALIDATE_INSERT') THEN
197: IF ( get_pk_for_validation (x_lookup_type,x_lookup_code
198:
199: )
200: ) THEN
201: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
202: igs_ge_msg_stack.add;
203: app_exception.raise_exception;
204:
205: END IF;
268: IF (x_last_update_login IS NULL) THEN
269: x_last_update_login := -1;
270: END IF;
271: ELSE
272: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
273: igs_ge_msg_stack.add;
274: app_exception.raise_exception;
275: END IF;
276:
436:
437: OPEN c1;
438: FETCH c1 INTO tlinfo;
439: IF (c1%notfound) THEN
440: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
441: igs_ge_msg_stack.add;
442: CLOSE c1;
443: app_exception.raise_exception;
444: RETURN;
470: AND ((tlinfo.av_transcript_disp_options = x_av_transcript_disp_options) OR ((tlinfo.av_transcript_disp_options IS NULL) AND (X_av_transcript_disp_options IS NULL)))
471: ) THEN
472: NULL;
473: ELSE
474: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
475: igs_ge_msg_stack.add;
476: app_exception.raise_exception;
477: END IF;
478:
535: IF (x_last_update_login IS NULL) THEN
536: x_last_update_login := -1;
537: END IF;
538: ELSE
539: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
540: igs_ge_msg_stack.add;
541: app_exception.raise_exception;
542: END IF;
543: