[Home] [Help]
51: OPEN cur_old_ref_values;
52: FETCH cur_old_ref_values INTO old_references;
53: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
54: CLOSE cur_old_ref_values;
55: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
56: igs_ge_msg_stack.add;
57: app_exception.raise_exception;
58: RETURN;
59: END IF;
202: IF ( get_pk_for_validation(
203: new_references.contact_code
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: ELSIF (p_action = 'DELETE') THEN
215: IF ( get_pk_for_validation (
216: new_references.contact_code
217: )
218: ) THEN
219: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
220: igs_ge_msg_stack.add;
221: app_exception.raise_exception;
222: END IF;
223: ELSIF (p_action = 'VALIDATE_DELETE') THEN
277: IF (x_last_update_login IS NULL) THEN
278: x_last_update_login := -1;
279: END IF;
280: ELSE
281: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
282: igs_ge_msg_stack.add;
283: app_exception.raise_exception;
284: END IF;
285:
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;
429: AND (tlinfo.sent_to_ucas = x_sent_to_ucas)
430: ) THEN
431: NULL;
432: ELSE
433: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
434: igs_ge_msg_stack.add;
435: app_exception.raise_exception;
436: END IF;
437:
485: IF (x_last_update_login IS NULL) THEN
486: x_last_update_login := -1;
487: END IF;
488: ELSE
489: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
490: igs_ge_msg_stack.add;
491: app_exception.raise_exception;
492: END IF;
493: