I don't see the full code for your stored procedure, but I assume that you have SELECT INTO/CREATE TABLE for the same temp-table name in your procedure, this is not permitted.
If you tell us more about what you want to achieve, we can help you with alternatives.