When an output parameter is defined it is not necessary to explicitly return it using RETURN keyword. Just setting the OUTPUT variable's value as desired is enough.

CREATE PROCEDURE sp_Test

@person_id uniqueidentifier,