[Home] [Help]
64: OPEN cur_old_ref_values;
65: FETCH cur_old_ref_values INTO old_references;
66: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
67: CLOSE cur_old_ref_values;
68: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
69: igs_ge_msg_stack.add;
70: app_exception.raise_exception;
71: RETURN;
72: END IF;
239: IF ( get_pk_for_validation(
240: new_references.ytdd_id
241: )
242: ) THEN
243: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
244: igs_ge_msg_stack.add;
245: app_exception.raise_exception;
246: END IF;
247: ELSIF (p_action = 'VALIDATE_INSERT') THEN
249: IF ( get_pk_for_validation (
250: new_references.ytdd_id
251: )
252: ) THEN
253: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
254: igs_ge_msg_stack.add;
255: app_exception.raise_exception;
256: END IF;
257: END IF;
338: ELSE
339: x_program_update_date := SYSDATE;
340: END IF;
341: ELSE
342: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
343: igs_ge_msg_stack.add;
344: app_exception.raise_exception;
345: END IF;
346:
548:
549: OPEN c1;
550: FETCH c1 INTO tlinfo;
551: IF (c1%notfound) THEN
552: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
553: igs_ge_msg_stack.add;
554: CLOSE c1;
555: app_exception.raise_exception;
556: RETURN;
585: AND ((tlinfo.rec_count = x_rec_count) OR ((tlinfo.rec_count IS NULL) AND (x_rec_count IS NULL)))
586: ) THEN
587: NULL;
588: ELSE
589: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
590: igs_ge_msg_stack.add;
591: app_exception.raise_exception;
592: END IF;
593:
658: IF (x_last_update_login IS NULL) THEN
659: x_last_update_login := -1;
660: END IF;
661: ELSE
662: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
663: igs_ge_msg_stack.add;
664: app_exception.raise_exception;
665: END IF;
666: