OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Personalization need [need to create error message based upon a query output]

Home » Applications » Oracle Fusion Apps & E-Business Suite » Personalization need [need to create error message based upon a query output] (ORACLE r12.1.3)

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

Personalization need [need to create error message based upon a query output] [message #634385]

Mon, 09 March 2015 05:52

m_shehpar
Messages: 73
Registered: October 2010
Location: Pakistan

Member

Hi all,

I googled alot but didnt find such help. I have called a function in form personaliztion and it either returns 0 or 1. I want to throw an error message and Raise form_trigger_failure incase 1 is returned. Kindly help me how to to do it. below is my function call:

= ' declare

v_output NUMBER;

begin

v_output := NFA_LINE_CONSUMPTION ( '''||${item.LINES.ATTRIBUTE1.value}||'''

                                 , '''||${item.LINES.ATTRIBUTE2.value}||'''

                                 , '''||${item.LINES.BASE_LINE_TOTAL.value}||'''

                                 );

end'

With thanks

Shabbir

Report message to a moderator

Re: Personalization need [need to create error message based upon a query output] [message #634422 is a reply to message #634385]

Tue, 10 March 2015 01:34

m_shehpar
Messages: 73
Registered: October 2010
Location: Pakistan

Member

can't any body help here ??? Smile

Report message to a moderator

Re: Personalization need [need to create error message based upon a query output] [message #634427 is a reply to message #634422]

Tue, 10 March 2015 01:58

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

I don't use Oracle Apps.

Would adding that condition into code you posted do any good? Such as

= ' declare
  v_output NUMBER;
begin
  v_output := NFA_LINE_CONSUMPTION ( '''||${item.LINES.ATTRIBUTE1.value}||'''
                                 , '''||${item.LINES.ATTRIBUTE2.value}||'''
                                 , '''||${item.LINES.BASE_LINE_TOTAL.value}||'''
                                 );

  if v_output = 1 then
     raise form_trigger_failure;
  end if;
end'

Report message to a moderator

Previous Topic:	Travel approval before expenses reporting
Next Topic:	Communicating to Fusion Applications via JCA Sockets/HTTP/Webservice

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Mar 12 06:45:04 CDT 2026