Total Pageviews

May 2, 2016

5/02/2016 08:24:00 PM
Custom Library (custom.pll) allows to extend/customize Oracle Applications form(Oracle Form) without changing or modifying Oracle Applications code. Examples may include enforcing a new business rule, opening a form using zoom etc. Most of the things that we can do using custom.pll, we can achieve that using Forms Personalization. Since Custom.pll takes the full advantage of PL/SQL so it is having an edge over Forms Personalization for complex customizations.
CUSTOM.pll is used to add extensions to Oracle’s form Functionality. Some of the common scenarios where CUSTOM.pll can be used are:-
1. Enabling/Disabling the fields
2. Changing the List of Values in a LOV field at runtime
3. Defaulting values
4. Additional record level validations
5. Navigation to other screens
6. Enabling Special Menu

Where is this located?
Custom.pll is located in $AU_TOP/resource Directory
1)Download the CUSTOM.pll

2)Open with Forms

3)Goto Event Procedure
  Write the Following Code in the place of 'Real Code Starts Here'

    form_name      varchar2(30) := name_in('system.current_form');
    block_name     varchar2(30) := name_in('system.cursor_block');
    begin
 
    if (event_name = 'WHEN-NEW-FORM-INSTANCE') then  
    if (form_name = 'APXWCARD' and block_name = 'CARDS') then
       APP_ITEM_PROPERTY2.SET_PROPERTY('CARDS.DEPARTMENT_NAME', -BlockName.FieldName
        DISPLAYED,
        PROPERTY_OFF);
       APP_ITEM_PROPERTY2.SET_PROPERTY('PO_HEADERS.SEGMENT1',
PROMPT_TEXT,
        'PO Number');
       APP_ITEM_PROPERTY2.SET_PROPERTY('REGIONS.REGION_LONG_NAME',
        CASE_RESTRICTION,
        UPPERCASE);
      end if;
      end if;  (attach the Library called APPCORE2.pll)


4)    Compile the Library we can get .pll    (Program link Library)
      Execute the Library we will get .plx   (Program Link Executable)
 (File ->Administration->Compile File)

5)Transfer both .pll and .plx files into the Resource folder in the AU top.
  (Note: before going to copy into the server close the complete Application)




Note:When we are copying the custom.PLL in to the Resource folder
we have to close the application because If application is opened
CUSTOM.pll being used , All the forms in oracle
applications developed with TEMPLETE.fmb contains CUSTOM.pll
If file is being used by other program we can not Update the file.
thats why we will close the application.

When we are working inthe project all the Users will be connected to
Oracle apps we can not ask every one to closethe application.for that
we will get the
 Alternative Path(Link File Path) from DBA we will place the CUSTOM.pll
in that folder.only we have to reLogin we can find the Customization
Other users no need to Logout.