136:
137: -- Bug #3368868 : Ends
138:
139: EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS := p_result;
140: EDR_STANDARD_PUB.G_SIGNATURE_STATUS := p_result;
141: -- Bug #3368868 : Starts
142: -- If transaction status is ERROR do not call post_op_api
143: IF l_trans_status <> 'ERROR' THEN
144: -- Bug #3368868 : Ends
159:
160: -- Bug 3411859 : Start
161: -- Signature status should be set to null in all cases .
162: EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS := null;
163: EDR_STANDARD_PUB.G_SIGNATURE_STATUS := null;
164: -- Bug 3411859 : End
165:
166: EXCEPTION
167: WHEN OTHERS THEN
165:
166: EXCEPTION
167: WHEN OTHERS THEN
168: EDR_PSIG_PAGE_FLOW.SIGNATURE_STATUS := null;
169: EDR_STANDARD_PUB.G_SIGNATURE_STATUS := null;
170: WF_CORE.CONTEXT('EDR_PSIG_PAGE_FLOW','Post Operation Proc Excution',p_itemtype,p_itemkey,l_SQL);
171: raise;
172: END;
173:
592: EXIT;
593: END IF;
594:
595: --obtain the overiding details for offline ntf
596: EDR_STANDARD.FIND_WF_NTF_RECIPIENT
597: (P_ORIGINAL_RECIPIENT => l_username,
598: P_MESSAGE_TYPE => 'EDRPSIGF',
599: P_MESSAGE_NAME => 'PSIG_OFFLINE_MSG_11511',
600: P_RECIPIENT => l_overriding_approver,
1082: -- if they are differnt then only call find wf ntf recipients API.
1083:
1084: IF( l_user_name <> WF_ENGINE.CONTEXT_USER) THEN
1085:
1086: EDR_STANDARD.FIND_WF_NTF_RECIPIENT(P_ORIGINAL_RECIPIENT => l_user_name,
1087: P_MESSAGE_TYPE => 'EDRPSIGF',
1088: P_MESSAGE_NAME => 'PSIG_EREC_MESSAGE_BLAF',
1089: P_RECIPIENT => l_overriding_approver,
1090: P_NTF_ROUTING_COMMENTS => l_overriding_comments,
1660: parent_context=> NULL);
1661: /* start the Workflow process */
1662:
1663:
1664: /* Set process Owner SKARIMIS for BLAF standard */
1665: wf_engine.setitemowner
1666: (ITEMTYPE=>l_itemtype,
1667: ITEMKEY=>l_item_key,
1668: OWNER=>GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'#WF_SIGN_REQUESTER'));
1749: l_signature_mode := GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype, p_itemkey,EDR_CONSTANTS_GRP.G_SIGNATURE_MODE);
1750: --Bug 4160412: End
1751:
1752: IF p_funcmode='RUN' THEN
1753: /* Set process Owner SKARIMIS for BLAF standard */
1754: wf_engine.setitemowner
1755: (ITEMTYPE=>p_itemtype,
1756: ITEMKEY=>p_itemkey,
1757: OWNER=>GET_WF_ITEM_ATTRIBUTE_TEXT(p_itemtype,p_itemkey,'#WF_SIGN_REQUESTER'));