Use raise notice for view the string that is generated by loop.

   raise notice 'INSERT INTO TABLE_B(COLUMN_B) 
     values( % )'; rec.COLUMN_A_OFTABLE_A;