1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

How to add 'Note' to Invoice Approval Workflow - Rejection Notification

Discussion in 'Oracle Apps Technical' started by chester04, Jun 23, 2015.

  1. chester04

    chester04 Active Member

    Messages:
    36
    Likes Received:
    0
    Trophy Points:
    100
    Hi All,

    I've customized the APINVAPR workflow to add rejection notification since it is not available in the standard workflow.
    But I'm having hard time to add the below requirements:

    1. Add "Notes" section to rejection notification.
    - I've tried to add the attribute 'WF_NOTE' in the message body but I got an error: Attribute WF_NOTE does not refer to a framework region

    2. When rejecting invoice, make 'Note' section a require field.
    - I've tried to add below code but it is not working.

    IF (funcmode = 'RESPOND') THEN
    l_nid := WF_ENGINE.context_nid;
    l_result := wf_notification.GetAttrText(l_nid, 'RESULT');
    l_response_reason := WF_ENGINE.GetItemAttrText(itemtype,
    itemkey,
    'WF_NOTE');

    IF l_result = 'REJECT' AND l_response_reason IS NULL THEN
    resultout := 'ERROR: You must enter a rejection note.';
    RETURN;
    END IF;
    END IF;

    Please help. Thank you.

    BR,
    Chester