How to disable of the Add New Record Button, Clear Button and Delete Button from the Oracle apps Custom Form EBS R12.

How to disable of the Add New Record Button, Clear Button and Delete Button from the Oracle apps Custom Form EBS R12.

    

Write the code in the Form Level Trigger (WHEN-NEW-BLOCK-INSTANCE)

-- New Record Bottom, Clear Record Button and Delete Button is disable in the Oracle apps Form. --

       IF :XXBEX_PRO_BUDGET_HEADER_V.PROJECT_STATUS IN ('PROJECT APPROVED') THEN

           

               APP_SPECIAL.ENABLE('FILE.NEW', PROPERTY_OFF);                       

               APP_SPECIAL.ENABLE('EDIT.CLEAR', PROPERTY_OFF);

               APP_SPECIAL.ENABLE('EDIT.DELETE',PROPERTY_OFF);

        ELSE

               APP_SPECIAL.ENABLE('FILE.NEW', PROPERTY_ON);                       

               APP_SPECIAL.ENABLE('EDIT.CLEAR', PROPERTY_ON);

               APP_SPECIAL.ENABLE('EDIT.DELETE',PROPERTY_ON);

        END IF;

When we open the form and click on the block level Data then following Bottom is disable.

New Record Bottom, Clear Record Button and Delete Button is disable in the Form.