Home » Applications » Oracle Fusion Apps & E-Business Suite » Set value of an item (Oracle E-Business 11.10.5.2)
Set value of an item [message #415098] Fri, 24 July 2009 14:11 Go to next message
ezechinedu
Messages: 8
Registered: July 2009
Junior Member
Hi All

I am doing some customization with the custom.pll approach and need to assign value to an item as below

:TOMAI_MAIN_LINES_BLK.TO_ACCOUNT_ID' := X_ENC_ACCOUNT ;

but this fails on compilation. Does anyone have ideas how to achieve this
Re: Set value of an item [message #415274 is a reply to message #415098] Mon, 27 July 2009 00:41 Go to previous messageGo to next message
sangakirankumar
Messages: 18
Registered: August 2008
Location: india
Junior Member

Hi,

Try,

COPY(X_ENC_ACCOUNT,'TOMAI_MAIN_LINES_BLK.TO_ACCOUNT_ID');

Thanks!
Re: Set value of an item [message #415370 is a reply to message #415274] Mon, 27 July 2009 07:54 Go to previous messageGo to next message
ezechinedu
Messages: 8
Registered: July 2009
Junior Member
Thank sangakirankumar

This resolved the problem,

One more thing do you have any idea how to recognise the when-button-pressed event in custom.pll. I am doing a customization which uses when-validate-record and only want it to trigger on the OK button but it triggers on this and closing of form.

Any idea how i can restrict it to only fire when the ok button is clicked.

I tried the code below but the system.current_item returns null when the button is clicked

if (form_name = 'POXRQERQ' and block_name = 'PO_APPROVE' and name_in('system.current_item') = 'po_approve_c1.wf_ok_button') then

Thanks
Re: Set value of an item [message #415371 is a reply to message #415370] Mon, 27 July 2009 08:06 Go to previous messageGo to next message
sangakirankumar
Messages: 18
Registered: August 2008
Location: india
Junior Member

This may help you...

Create a Global Variable.
say lv_tem_ok VARCHAR2(1) DEFAULT 'N';

When you press ok button then set this to 'Y';
lv_tem_ok := 'Y';

Use this variable now where ever you want.

If lv_tem_ok = 'Y' Then
write your code here and set back the variable to N..
lv_tem_ok := 'N';
end if;



Thanks!
Re: Set value of an item [message #415517 is a reply to message #415371] Tue, 28 July 2009 02:36 Go to previous messageGo to next message
ezechinedu
Messages: 8
Registered: July 2009
Junior Member
Thanks for your help.

My only fear is that this will involve modifying the existing oracle form which we are not allowed to do at this time.

i need to do this from custom.pll without touching the existing Oracle forms.

Is there any way i can do this including a workaround if you know any.
Re: Set value of an item [message #415583 is a reply to message #415517] Tue, 28 July 2009 05:22 Go to previous message
sangakirankumar
Messages: 18
Registered: August 2008
Location: india
Junior Member

Hi Try this,

Instead of name_in('system.current_item') = 'po_approve_c1.wf_ok_button')

name_in('system.trigger_item') = 'po_approve_c1.wf_ok_button'

i.e 'BlockName.ButtonName'

Thanks!
Previous Topic: Update SIT
Next Topic: Recognise Button Click Event
Goto Forum:
  


Current Time: Thu Dec 08 12:12:52 CST 2016

Total time taken to generate the page: 0.23878 seconds