-- your code:
message('1');
select something into some_Var from some_table where ...
message('2');
insert into another_table (col1) values (some_var);
message('3');
for cur_r in (select ... from ...) loop
  message('in loop');
  ...
end loop;
...