APEX

Hi All,

I have a classic report in my application

Report Query :

SELECT APEX_ITEM.DISPLAY_AND_SAVE(8,B.PRIMARY_DLR_NUM||'-'||B.PRIMARY_DLR_NAME)||
APEX_ITEM.HIDDEN(9,A.ARM_EMPLID)||
APEX_ITEM.HIDDEN(10,A.AE_EMPLID)||APEX_ITEM.HIDDEN(11,B.PRIMARY_DLR_NUM)||
APEX_ITEM.HIDDEN(13,B.PRIMARY_DLR_NAME)||
APEX_ITEM.HIDDEN(12,B.DLR_TYPE_CD) "Dealer",
C.DLR_STATUS "DLR_OPT_IN",
C.ARM_STATUS "ARM_OPT_IN",
C.AE_STATUS "AE_OPT_IN",
C.ALT_ARM_MAIL_ID "ARM_EMAIL_ALT",
C.ALT_AE_MAIL_ID "AE_EMAIL_ALT",
C.ARM_STATUS "STATUS",
C.APPROVED_DATE "APPVR_DATE" 
FROM EMPLOYEE_DEALER_RELATION A, DEALER B , EV_DR_ARM_AE_OVERRIDE C
WHERE  ((A.ARM_EMPLID= :P1_ARM
AND A.AE_EMPLID = :P1_AE ) OR (B.DLR_TYPE_CD = :P1_DEALER_TYPE_CODE))
AND A.PRIMARY_DLR_NUM = B.PRIMARY_DLR_NUM
AND A.PRIMARY_DLR_NUM = C.DEALER_ID 
AND A.ARM_EMPLID = C.ARM_ID 
AND A.AE_EMPLID = C.AE_ID 

C.DLR_STATUS "DLR_OPT_IN",

C.ARM_STATUS "ARM_OPT_IN",

C.AE_STATUS "AE_OPT_IN",

These three columns are displayed as Radio Group ,

I have a process in the page which will insert a new record and update the existing record.

In the report , user can modify any column and press the submit button will call the above said process.

Process Code:

DECLARE
V_EXISTS NUMBER:=0;
V_ERRMSG VARCHAR2(4000);
V_ERRCODE VARCHAR2(100);
BEGIN
FOR I in 1..APEX_APPLICATION.G_F01.COUNT 
LOOP
 BEGIN
      BEGIN
      SELECT 1 INTO V_EXISTS FROM EV_DR_ARM_AE_OVERRIDE
      WHERE ARM_ID = APEX_APPLICATION.G_F09(I)
       AND  AE_ID  = APEX_APPLICATION.G_F10(I)
       AND  DEALER_ID = APEX_APPLICATION.G_F11(I);
      EXCEPTION WHEN OTHERS THEN
      V_EXISTS:=0;
      END;


IF V_EXISTS = 0 THEN
      INSERT INTO EV_DR_ARM_AE_OVERRIDE(ARM_ID,AE_ID,DEALER_ID,DEALER_NAME,DLR_STATUS,ARM_STATUS,
      AE_STATUS,ALT_ARM_MAIL_ID,ALT_AE_MAIL_ID,UPDATED_BY,UPDATED_DATE,APPROVAL_STATUS,APPROVED_BY,
      APPROVED_DATE,DEALER_TYPE_CODE) VALUES(apex_application.G_f09(I),apex_application.G_f10(I),apex_application.G_f11(I),
      apex_application.G_f13(I),
      APEX_APPLICATION.G_F01(I),APEX_APPLICATION.G_F02(I),APEX_APPLICATION.G_F03(I),      APEX_APPLICATION.G_F04(I),APEX_APPLICATION.G_F05(I),:APP_USER,SYSDATE,APEX_APPLICATION.G_F06(I),
      :APP_USER,APEX_APPLICATION.G_F07(I),apex_application.G_f12(I));
      COMMIT;
ELSE
     UPDATE EV_DR_ARM_AE_OVERRIDE
     SET DLR_STATUS = APEX_APPLICATION.G_F02(I),
         ARM_STATUS = APEX_APPLICATION.G_F03(I),
         AE_STATUS  = APEX_APPLICATION.G_F03(I),
         ALT_ARM_MAIL_ID = APEX_APPLICATION.G_F04(I),
         ALT_AE_MAIL_ID =  APEX_APPLICATION.G_F05(I),
         UPDATED_BY     = :APP_USER,
         UPDATED_DATE   = SYSDATE,
         APPROVAL_STATUS = APEX_APPLICATION.G_F06(I),
         APPROVED_BY   = :APP_USER
      WHERE ARM_ID = APEX_APPLICATION.G_F09(I)
       AND  AE_ID  = APEX_APPLICATION.G_F10(I)
       AND  DEALER_ID = APEX_APPLICATION.G_F11(I);
  COMMIT;
END IF;
EXCEPTION WHEN OTHERS THEN
V_ERRMSG:=SQLERRM;
V_ERRCODE:=SQLCODE;
INSERT INTO EVANTAGE_ERROR_LOG VALUES(APEX_APPLICATION.G_F09(I)||'-'||APEX_APPLICATION.G_F10(I)
||'-'||APEX_APPLICATION.G_F11(I),V_ERRMSG,V_ERRCODE,:APP_USER,SYSDATE);
COMMIT;
END;
END LOOP;
EXCEPTION WHEN OTHERS THEN
V_ERRMSG:=SQLERRM;
V_ERRCODE:=SQLCODE;
INSERT INTO EVANTAGE_ERROR_LOG VALUES(NULL,V_ERRMSG,V_ERRCODE,:APP_USER,SYSDATE);
COMMIT;
END;

Now my problem is , when i select radio group value and press submit i am getting page 404 not found , its not even calling my process, without radio button(if am not selecting any value - NULL) my process executing perfectly.

Could someone please let me know how i can resolve or what i have missed here?

Thanks in Advance.

Cheers,

San.