create or replace procedure insert_err_logs is
reqid tbl%rowtype;
tbtype tbl1.type%type;
begin
  insert into v_test select id from tbl;
  for reqid in (select id from v_test)
  loop
    begin
    dbms_output.put_line('Current ID: ' || reqid.id);
      select type into tbtype from tbl1 where id = reqid.id and type = 'refill';
    EXCEPTION
      WHEN NO_DATA_FOUND THEN
      insert into tbl2 (id, type, col) select * from tbl1 where id = reqid.id and type = 'withdrawal';
      end;
    end loop;
    execute immediate 'truncate table v_test';
end;

SQL> select * from tbl1;

        ID TYPE                 COL
---------- -------------------- ------------------------------
       123 withdraw             first row
       223 withdraw             second row
       332 refill               third row
       432 refill               fourth row
       532 refill               fifth row
       634 production           sixth row
       734 production           seventh row
       332 withdraw             thirdrow_
       432 withdraw             fourthrow_
       532 withdraw             fifthrow_

10 rows selected

SQL> select * from tbl2;

        ID TYPE                 COL                                 STATE
---------- -------------------- ------------------------------ ----------