As I said, this is something really stupid (no offense here) I did such mistakes the time.
You miss the last END for the stored procedure:

CREATE PROCEDURE bpsp_fillbuspass 
AS
  BEGIN
      --- Huge code here

  END -- That is missing

And there is no need to create temp table before SP :-)