You are setting parameters_collection_id to a string value, which of course is not what you want.
Assuming your SP returns an INT you can do this:
DECLARE @returnVal INT
EXEC @returnVal = CADEBILL.get_next_parameters_collection_id
UPDATE #quote_detail
SET parameters_collection_id = @returnVal