A man has been mistakenly given a vasectomy by medics who were supposed to be performing a “minor procedure” on him, a hospital has admitted.