Home » Applications » Oracle Fusion Apps & E-Business Suite » Personalization need [need to create error message based upon a query output] (ORACLE r12.1.3)
Personalization need [need to create error message based upon a query output] [message #634385] Mon, 09 March 2015 05:52 Go to next message
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
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 Go to previous messageGo to next message
m_shehpar
Messages: 73
Registered: October 2010
Location: Pakistan
Member
can't any body help here ??? Smile
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 Go to previous message
Littlefoot
Messages: 21671
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'

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


Current Time: Sat May 15 09:34:57 CDT 2021