OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Embeded Function in Notification Activity

Home » Applications » Oracle Fusion Apps & E-Business Suite » Embeded Function in Notification Activity

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

Embeded Function in Notification Activity [message #177478]

Wed, 14 June 2006 22:28

ying
Messages: 143
Registered: May 2002

Senior Member

Hi,

I'm now trying to embed PL/SQL function in notification activity. If I'm not mistaken, this is call a post-notification function. I found that once I have added the function in the notification activity, the result type (Approved/Rejected) which is supposed to return from the notification upon user's respond was not return. So, I believe that I should do something in my Pl/SQL function.

So, from my understanding, I should get the result within Pl/SQL function upon user's respond, i.e:

if ( funcmode = RESPOND ) then
<your RESPOND executable statements>
resultout := 'COMPLETE';
return;
end if;

But how should I get the value of the result type upon user's respond???

Pls advise.....

Report message to a moderator

Re: Embeded Function in Notification Activity [message #177516 is a reply to message #177478]

Thu, 15 June 2006 04:49

agostino_neto
Messages: 180
Registered: July 2005

Senior Member

I don't think the result type is given by your post-notification function.
Check your notification has a result type - Approval, also check your process diagram. What do you do next depending on user reject or approbation?
For resultout look at Developer’s Guide. There is an explanation for different results (COMPLETE, WAITING, DEFERED, NOTIFIED, ERROR).

Report message to a moderator

Re: Embeded Function in Notification Activity [message #177637 is a reply to message #177478]

Thu, 15 June 2006 20:09

ying
Messages: 143
Registered: May 2002

Senior Member

Hi,

I manage to solve the problem by getting the result from my notification in the post-notification function and return the value from my post-notification in order to transite to next node. Below is my code:

SELECT
notification_id into ntf_id
FROM
wf_item_activity_statuses
WHERE
process_activity = p_actid
and item_key = p_item_key;

nft_result := Wf_Notification.GetAttrText
(nid =>ntf_id ,
aname =>'RESULT');

result := 'COMPLETE:'nft_result;

Report message to a moderator