[Home] [Help]
47: OPEN cur_old_ref_values;
48: FETCH cur_old_ref_values INTO old_references;
49: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
50: CLOSE cur_old_ref_values;
51: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
52: igs_ge_msg_stack.add;
53: app_exception.raise_exception;
54: RETURN;
55: END IF;
192: IF ( get_pk_for_validation(
193: new_references.rfmb_id
194: )
195: ) THEN
196: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
197: igs_ge_msg_stack.add;
198: app_exception.raise_exception;
199: END IF;
200: ELSIF (p_action = 'VALIDATE_INSERT') THEN
202: IF ( get_pk_for_validation (
203: new_references.rfmb_id
204: )
205: ) THEN
206: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
207: igs_ge_msg_stack.add;
208: app_exception.raise_exception;
209: END IF;
210:
284: ELSE
285: x_program_update_date := SYSDATE;
286: END IF;
287: ELSE
288: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
289: igs_ge_msg_stack.add;
290: app_exception.raise_exception;
291: END IF;
292:
406:
407: OPEN c1;
408: FETCH c1 INTO tlinfo;
409: IF (c1%notfound) THEN
410: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
411: igs_ge_msg_stack.add;
412: CLOSE c1;
413: app_exception.raise_exception;
414: RETURN;
426: AND ((tlinfo.reject_reason = x_reject_reason) OR ((tlinfo.reject_reason IS NULL) AND (X_reject_reason IS NULL)))
427: ) THEN
428: NULL;
429: ELSE
430: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
431: igs_ge_msg_stack.add;
432: app_exception.raise_exception;
433: END IF;
434:
482: IF (x_last_update_login IS NULL) THEN
483: x_last_update_login := -1;
484: END IF;
485: ELSE
486: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
487: igs_ge_msg_stack.add;
488: app_exception.raise_exception;
489: END IF;
490: