488: OPEN c;
489: FETCH c INTO Recinfo;
490: IF ( c%NOTFOUND ) THEN
491: CLOSE c;
492: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
493: APP_EXCEPTION.RAISE_EXCEPTION;
494: END IF;
495: CLOSE C;
496:
618: AND ( x_attribute20 IS NULL ) ) )
619: ) THEN
620: RETURN;
621: ELSE
622: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
623: APP_EXCEPTION.RAISE_EXCEPTION;
624: END IF;
625:
626: END Lock_Row;
741: WHERE orig_system_ref_id = x_orig_system_ref_id;
742:
743: EXCEPTION
744: WHEN NO_DATA_FOUND THEN
745: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
746: FND_MESSAGE.SET_TOKEN('RECORD', 'orig_sys_reference_rec');
747: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_orig_system_ref_id));
748: FND_MSG_PUB.ADD;
749: RAISE FND_API.G_EXC_ERROR;
742:
743: EXCEPTION
744: WHEN NO_DATA_FOUND THEN
745: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
746: FND_MESSAGE.SET_TOKEN('RECORD', 'orig_sys_reference_rec');
747: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_orig_system_ref_id));
748: FND_MSG_PUB.ADD;
749: RAISE FND_API.G_EXC_ERROR;
750:
743: EXCEPTION
744: WHEN NO_DATA_FOUND THEN
745: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
746: FND_MESSAGE.SET_TOKEN('RECORD', 'orig_sys_reference_rec');
747: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_orig_system_ref_id));
748: FND_MSG_PUB.ADD;
749: RAISE FND_API.G_EXC_ERROR;
750:
751: END Select_Row;