Oracle Forms

Dear friends,
I had created a form in which, i get empno,empname from database table with vertical scroll bar and i should update the datas into another table apart from empno,empname by clicking the options out of three radiobuttons created. Each radio button indicating different amount to be entered. and the user has to just click the the radio buttons options along side the empno,empname scrolling all the employees in the table.
What are the possible step i should take??
I usually get empno,empname by just entering deptno,another item by just entering the deptno in the form.
I have given coding in the when -radio-changed trigger as---
if :adv.radio='1' then
insert into floodadv (empno,ename,opt1_2500)
select empno,ename,2500 from emp where
:deptno=deptno and :empno=empno and :ename=ename;
execute_query('VALIDATE');
elsif :adv.radio='2' then
insert into floodadv (empno,ename,opt2_basic)
select empno,ename,sal from emp where
:deptno=deptno and :empno=empno and :ename=ename;
execute_query('VALIDATE');
elsif :adv.radio='3' then
insert into floodadv (empno,ename,opt2_basic)
select empno,ename,0 from emp where
:deptno=deptno and :empno=empno and :ename=ename;
execute_query('VALIDATE');
end if;

but when i commit by pressing save (commit_form;) it shows error frm-40508 unable to insert record. what shall i do to insert record into another table along with empno,empname,deptno.
please explain and do need ful. I have to insert datas in tabular format