...
written by Charley , November 13, 2006

Anil,

I find that now with the Forms Personalization released last year, it is rare that Custom.pll will be needed. So many of the things I used to do with it are now included in the personalization capability of the forms.

...
written by Charley , November 13, 2006

Anil,

I find that now with the Forms Personalization released last year, it is rare that Custom.pll will be needed. So many of the things I used to do with it are now included in the personalization capability of the forms.

...
written by Anil Passi , November 15, 2006

indeed, i stopped using custom.pll too...almost.

Forms personalization still wont suppoort the scenario, when you want to provide a message box with multiple choices...hence good old custom.pll is still alive

...
written by Anil Passi , November 15, 2006

indeed, i stopped using custom.pll too...almost.

Forms personalization still wont suppoort the scenario, when you want to provide a message box with multiple choices...hence good old custom.pll is still alive

...
written by AragoRn , November 22, 2006

Anil,
i worked on 11.5.10.2, there i didnt find an option of changing the record group query attached to lov using form personalization. the same thing i can do comfortably using custom.pll

i feel for complex customizations is better to go for custom.pll ... what does .pld used for?
and how does custom.pll gets called when the form is developed from Templat.fmb ... i hav a vague idea of APPCORE lib internal calls Custom.pll n thts the reason for using APPCORE2 lib functions in custom.pll rather than APPCORE routines. can u elaborate more on the tight integration of custom.pll with forms and apps??

can u plz throw some light on whether we hav a custom.pll in coming fusion versions? i heard oracle completely gonna rule out the usage of D2K, then vl there b an existence of custom.pll then??

Regards,
Kishore

...
written by AragoRn , November 22, 2006

Anil,
i worked on 11.5.10.2, there i didnt find an option of changing the record group query attached to lov using form personalization. the same thing i can do comfortably using custom.pll

i feel for complex customizations is better to go for custom.pll ... what does .pld used for?
and how does custom.pll gets called when the form is developed from Templat.fmb ... i hav a vague idea of APPCORE lib internal calls Custom.pll n thts the reason for using APPCORE2 lib functions in custom.pll rather than APPCORE routines. can u elaborate more on the tight integration of custom.pll with forms and apps??

can u plz throw some light on whether we hav a custom.pll in coming fusion versions? i heard oracle completely gonna rule out the usage of D2K, then vl there b an existence of custom.pll then??

Regards,
Kishore

...
written by Anil Passi , December 10, 2006

There was a typo...
It should have read..
CUSTOM.pll is attached to APPCORE.
APPCORE2 is attached to CUSTOM.pll

Hence the execution is
APPCORE-->CUSTOM-->APPCORE2[if need be]

========
If instead we ever had
CUSTOM.pll attached to APPCORE.
APPCORE attached to CUSTOM.pll
then possible execution could be
APPCORE-->CUSTOM-->APPCORE-->CUSTOM--APPCORE--CUSTOM
Hence causing circular reference.

Hence, APPCORE2 is attached to CUSTOM.pll
So that when CUSTOM.pll calls for example APP_DATE, then it gets executed from APPCORE2.

This is so because APPCORE is not attached to CUSTOM.pll


Oracle Apps Dev guide documents this as well

Thanks
Anil Passi

...
written by Anil Passi , December 10, 2006

There was a typo...
It should have read..
CUSTOM.pll is attached to APPCORE.
APPCORE2 is attached to CUSTOM.pll

Hence the execution is
APPCORE-->CUSTOM-->APPCORE2[if need be]

========
If instead we ever had
CUSTOM.pll attached to APPCORE.
APPCORE attached to CUSTOM.pll
then possible execution could be
APPCORE-->CUSTOM-->APPCORE-->CUSTOM--APPCORE--CUSTOM
Hence causing circular reference.

Hence, APPCORE2 is attached to CUSTOM.pll
So that when CUSTOM.pll calls for example APP_DATE, then it gets executed from APPCORE2.

This is so because APPCORE is not attached to CUSTOM.pll


Oracle Apps Dev guide documents this as well

Thanks
Anil Passi

...
written by Anil Passi , January 21, 2007

Hi Suresh

Simply open the jsp file, and you will either find jdbc commands using tables or the java class files being referenced [the class files might have table referenced]

...
written by suresh , January 21, 2007

how to find table information in a .jsp

thanks

...
written by Anil Passi , January 21, 2007

Hi Suresh

Simply open the jsp file, and you will either find jdbc commands using tables or the java class files being referenced [the class files might have table referenced]

...
written by suresh , January 21, 2007

how to find table information in a .jsp

thanks

...
written by raj , January 29, 2007

Sunil,
can u give us more light on custom.pll
i.e what are the basics that we need to follow to use custom.pll with an example

regards
raj

...
written by Shripad , March 06, 2007

Hi Anil,
I am trying to learn oracle apps forms.
I have written a package and attached it to
custom.pll.I am having a procedure TEST_PROC(event_name).I want to know how the event value will be passed to my formal parameter event_name

...
written by rapps , May 20, 2007

hi anil,
i have a doubt regarding custom.pll how this code will be executed when a from is opened.. i saw the code of custom.pll in it most of the code was commented ,,how this code will be executed

thank you
rapps

...
written by PRASAD , August 04, 2007

HI ANIL,

I AM PRETY NEW TO THIS ORACLE APPS. CAN U TEL ME THE DIFFERENCE BETWEEN CUSTOM TABLE AND DATABASE TABLE.


THANKS
PRASAD

...
written by malati , September 11, 2007

Hi Anil,

Great site for beginners.thanks for sharing ur knowledge.I would like to request u to please write an article on custom.pll's.that would be really helpful for all of us.

Thanks in advance.
Malati

How to use CUSTOM.PLL for ZOOM.
written by Pavankumar B Barlota , January 29, 2008

Hi Anil,

Can you please help me out to use Custom.pll for zoom?

I am calling my Custom form from the ISO form using ZOOM button there.
So, what are the changes needed for this...in custom.pll.

Plese give me step by step detail as i am new to this technology.
If it is easy to use by personalization then explain that too!

waiting for u r reply....

Custom.pll
written by tara , February 01, 2008

hi anil

iam new to this software job especially in oracle apps. can you tell me how to take first step and proceed to get through.

Thanks
mona

...
written by Githesh Gopinath , February 12, 2009

Its Very good

Problem using Custom.pll for when-new-item-instance trigger on descriptive flex field
written by Amit Kumar , April 15, 2009

Hi Anil,

I want to write some code on when-new-item-instance for descriptive flex field using Custom.pll. But when i am going to see my my changes after clicking on the DFF i am unable to see my changes. Can't we write anything on When-New-Item_instance for a DFF. Same Code is perfectly working for other fields for the same trigger.for ex:-

IF ( event_name = 'WHEN-NEW-ITEM-INSTANCE'
AND block_name = 'RCV_TRANSACTION'
AND item_name = 'DESCFLEX'
) THEN

fnd_message.set_string ('Enter into DFF');
fnd_message.show;

END IF;