Custom.pll [message #95373] |
Tue, 23 September 2003 05:59 |
Small Step
Messages: 1 Registered: September 2003
|
Junior Member |
|
|
Can anybody tell me which are the exact events for which i can write code in custom.pll
|
|
|
Re: Custom.pll [message #95418 is a reply to message #95373] |
Thu, 11 December 2003 01:18 |
Kalyan
Messages: 16 Registered: October 2001
|
Junior Member |
|
|
hi,
Yor can write the code for the events like zoom, and for some business rules (like diabling and enabling fields,case restirction, messgae dictionary).. It is located in au_top/resource
|
|
|
Customizes Custom.pll file. [message #95836 is a reply to message #95418] |
Fri, 28 May 2004 22:43 |
Ritesh
Messages: 38 Registered: November 2001
|
Member |
|
|
i am worrking on the Oracle apps, and i customized the custom.pll file in zoom event i just simply write the code inside this event and i save the file and upload in $AU_TOP/ resorces folder.. then my apps give a error ---WHEN-LOGON Excaption....your pl/sql is not registered...but i do the same step whatever in oracle user giud is said....
so plz give the idea ....
thanks...
Ritesh
|
|
|
Re: Custom.pll [message #95837 is a reply to message #95418] |
Fri, 28 May 2004 22:57 |
Ritesh
Messages: 38 Registered: November 2001
|
Member |
|
|
in zoom_available function, i write simple code here
function zoom_ava
if (form='reet' and block='dept') then
oracle developer guide in chapter 28 whatever is written there same code i write but changes is form name , block name that's it...
then shows a message....
and my apps application is not open....then i upload the previous custom.pll & .plx then work...plz give me the solution & why is happened....
thanks..
tritesh
|
|
|
Re: Custom.pll [message #95839 is a reply to message #95418] |
Fri, 28 May 2004 23:11 |
Ritesh
Messages: 38 Registered: November 2001
|
Member |
|
|
in zoom_available function, i write simple code here
function zoom_ava
if (form='reet' and block='dept') then
oracle developer guide in chapter 28 whatever is written there same code i write but changes is form name , block name that's it...
then shows a message....
and my apps application is not open....then i upload the previous custom.pll & .plx then work...plz give me the solution & why is happened....
thanks..
tritesh
|
|
|
|
|
Re: Custom.pll [message #96640 is a reply to message #95839] |
Fri, 07 January 2005 22:22 |
Friend
Messages: 33 Registered: January 2002
|
Member |
|
|
why r u using function.use this hope it helps.
Whenever the cursor changes block in the form, the form calls the ZOOM_AVAILABLE function in the CUSTOM library. If this function returns TRUE, then the Zoom entries on the menu and toolbar are enabled; if it returns FALSE, then they are disabled.
Here is a code example to enable the Zoom functionality in Custom.pll:
function zoom_available return boolean is
form_name varchar2(30) := name_in('system.current_form');
block_name varchar2(30) := name_in('system.cursor_block');
begin
if (form_name = 'DEMXXEOR' and block_name = 'ORDERS') then
return TRUE;
else
return FALSE;
end if;
end zoom_available;
And an example of how to process the event in Custom.pll:
procedure event(event_name varchar2) is
form_name varchar2(30) := name_in('system.current_form');
block_name varchar2(30) := name_in('system.cursor_block');
begin
if (event_name = 'ZOOM') then
if (form_name = 'CSXSRISR' and block_name = 'INCIDENT_TRACKING') then
copy('Spanner is Cool', 'INCIDENT_TRACKING.PRODUCT_NAME');
fnd_message.set_string ('Je fais ici mes dérivations de données.');
fnd_message.show;
end if;
end if;
end event;
|
|
|