A man who suffered non-life-threatening injuries in a shooting in Northern Ireland was an off-duty police officer, the PSNI has said.