158: l_valid_obj BOOLEAN;
159: l_bus_object HZ_REGISTRY_VALIDATE_BO_PVT.COMPLETENESS_REC_TYPE;
160: l_errorcode NUMBER;
161: BEGIN
162: -- Standard start of API savepoint
163: SAVEPOINT do_create_location_bo_pub;
164:
165: -- initialize API return status to success.
166: x_return_status := FND_API.G_RET_STS_SUCCESS;
476: FROM HZ_LOCATIONS loc
477: WHERE loc.location_id = l_loc_id;
478:
479: BEGIN
480: -- Standard start of API savepoint
481: SAVEPOINT do_update_location_bo_pub;
482:
483: -- initialize API return status to success.
484: x_return_status := FND_API.G_RET_STS_SUCCESS;