OraFAQ Forum: Oracle Fusion Apps & E-Business Suite

Home » Applications » Oracle Fusion Apps & E-Business Suite » Set value of an item (Oracle E-Business 11.10.5.2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Set value of an item [message #415098]

Fri, 24 July 2009 14:11

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

Report message to a moderator

Re: Set value of an item [message #415274 is a reply to message #415098]

Mon, 27 July 2009 00:41

sangakirankumar
Messages: 18
Registered: August 2008
Location: india

Junior Member

Hi,

Try,

COPY(X_ENC_ACCOUNT,'TOMAI_MAIN_LINES_BLK.TO_ACCOUNT_ID');

Thanks!

Report message to a moderator

Re: Set value of an item [message #415370 is a reply to message #415274]

Mon, 27 July 2009 07:54

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

Report message to a moderator

Re: Set value of an item [message #415371 is a reply to message #415370]

Mon, 27 July 2009 08:06

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!

Report message to a moderator

Re: Set value of an item [message #415517 is a reply to message #415371]

Tue, 28 July 2009 02:36

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.

Report message to a moderator

Re: Set value of an item [message #415583 is a reply to message #415517]

Tue, 28 July 2009 05:22

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!

Report message to a moderator

Previous Topic:	Update SIT
Next Topic:	Recognise Button Click Event

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 12:30:51 CST 2025