146: EXCEPTION
147:
148: WHEN FND_API.G_EXC_ERROR
149: THEN
150: WF_CORE.CONTEXT('PA_PROJECT_WF','SELECT_PROJECT_APPROVER',itemtype, itemkey, to_char(actid), funcmode);
151: RAISE;
152:
153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
154: THEN
151: RAISE;
152:
153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
154: THEN
155: WF_CORE.CONTEXT('PA_PROJECT_WF','SELECT_PROJECT_APPROVER',itemtype, itemkey, to_char(actid), funcmode);
156: RAISE;
157:
158: WHEN OTHERS
159: THEN
156: RAISE;
157:
158: WHEN OTHERS
159: THEN
160: WF_CORE.CONTEXT('PA_PROJECT_WF','SELECT_PROJECT_APPROVER',itemtype, itemkey, to_char(actid), funcmode);
161: RAISE;
162:
163:
164:
231: EXCEPTION
232: WHEN OTHERS
233: THEN
234: p_err_code := SQLCODE;
235: WF_CORE.CONTEXT('PA_PROJECT_WF','START_PROJECT_WF');
236: RAISE;
237:
238:
239: END Start_Project_Wf;
307: );
308:
309: IF (l_err_code < 0)
310: THEN
311: WF_CORE.CONTEXT('PA_PROJECT_WF','GET_PROJ_STATUS_ATTRIBUTES',itemtype, itemkey, to_char(actid), funcmode);
312: RAISE FND_API.G_EXC_ERROR;
313: ELSIF (l_err_code > 0)
314: THEN
315: resultout := wf_engine.eng_completed||':'||'F';
312: RAISE FND_API.G_EXC_ERROR;
313: ELSIF (l_err_code > 0)
314: THEN
315: resultout := wf_engine.eng_completed||':'||'F';
316: WF_CORE.CONTEXT('PA_PROJECT_WF','GET_PROJ_STATUS_ATTRIBUTES',itemtype, itemkey, to_char(actid), funcmode);
317: PA_WORKFLOW_UTILS.Set_Notification_Messages
318: (p_item_type => itemtype
319: , p_item_key => itemkey
320: );
601: EXCEPTION
602:
603: WHEN FND_API.G_EXC_ERROR
604: THEN
605: WF_CORE.CONTEXT('PA_PROJECT_WF','SET_SUCCESS_STATUS',itemtype, itemkey, to_char(actid), funcmode);
606: RAISE;
607:
608: WHEN OTHERS
609: THEN
606: RAISE;
607:
608: WHEN OTHERS
609: THEN
610: WF_CORE.CONTEXT('PA_PROJECT_WF','SET_SUCCESS_STATUS',itemtype, itemkey, to_char(actid), funcmode);
611: RAISE;
612:
613: END Set_Success_status;
614:
642: IF (l_err_code < 0)
643: -- Don't Check for positive error codes because there isn't any notification to display the
644: -- business rule messages.
645: THEN
646: WF_CORE.CONTEXT('PA_PROJECT_WF','GET_PROJ_STATUS_ATTRIBUTES',itemtype, itemkey, to_char(actid), funcmode);
647: RAISE FND_API.G_EXC_ERROR;
648: END IF;
649:
650: Pa_workflow_utils.Set_Global_Attr (p_item_type => itemtype,
725: EXCEPTION
726:
727: WHEN FND_API.G_EXC_ERROR
728: THEN
729: WF_CORE.CONTEXT('PA_PROJECT_WF','SET_FAILURE_STATUS',itemtype, itemkey, to_char(actid), funcmode);
730: RAISE;
731:
732: WHEN OTHERS
733: THEN
730: RAISE;
731:
732: WHEN OTHERS
733: THEN
734: WF_CORE.CONTEXT('PA_PROJECT_WF','SET_FAILURE_STATUS',itemtype, itemkey, to_char(actid), funcmode);
735: RAISE;
736:
737: END Set_Failure_status;
738:
768: x_err_stage => l_err_stage );
769:
770: IF (l_err_code < 0)
771: THEN
772: WF_CORE.CONTEXT('PA_PROJECT_WF','GET_PROJ_STATUS_ATTRIBUTES',itemtype, itemkey, to_char(actid), funcmode);
773: RAISE FND_API.G_EXC_ERROR;
774: ELSIF (l_err_code > 0)
775: THEN
776: resultout := wf_engine.eng_completed||':'||'F';
773: RAISE FND_API.G_EXC_ERROR;
774: ELSIF (l_err_code > 0)
775: THEN
776: resultout := wf_engine.eng_completed||':'||'F';
777: WF_CORE.CONTEXT('PA_PROJECT_WF','GET_PROJ_STATUS_ATTRIBUTES',itemtype, itemkey, to_char(actid), funcmode);
778: PA_WORKFLOW_UTILS.Set_Notification_Messages
779: (p_item_type => itemtype
780: , p_item_key => itemkey
781: );
813: EXCEPTION
814:
815: WHEN FND_API.G_EXC_ERROR
816: THEN
817: WF_CORE.CONTEXT('PA_PROJECT_WF','VERIFY_STATUS_CHANGE_RULES',itemtype, itemkey, to_char(actid), funcmode);
818: RAISE;
819:
820: WHEN OTHERS THEN
821: WF_CORE.CONTEXT('PA_PROJECT_WF','VERIFY_STATUS_CHANGE_RULES',itemtype, itemkey, to_char(actid), funcmode);
817: WF_CORE.CONTEXT('PA_PROJECT_WF','VERIFY_STATUS_CHANGE_RULES',itemtype, itemkey, to_char(actid), funcmode);
818: RAISE;
819:
820: WHEN OTHERS THEN
821: WF_CORE.CONTEXT('PA_PROJECT_WF','VERIFY_STATUS_CHANGE_RULES',itemtype, itemkey, to_char(actid), funcmode);
822: RAISE;
823:
824: END Verify_status_change_rules;
825:
847:
848: EXCEPTION
849: WHEN OTHERS
850: THEN
851: WF_CORE.CONTEXT('PA_PROJECT_WF','WF_STATUS_FAILURE', x_item_type, x_item_key);
852: RAISE;
853:
854: END Wf_Status_failure;
855:
906: EXCEPTION
907: WHEN OTHERS
908: THEN
909: x_err_code := SQLCODE;
910: WF_CORE.CONTEXT('PA_PROJECT_WF','GET_PROJ_STATUS_ATTRIBUTES', x_item_type, x_item_key);
911: RAISE;
912:
913: END Get_proj_status_attributes;
914:
991:
992: EXCEPTION
993: WHEN OTHERS THEN
994: x_err_code := SQLCODE ;
995: WF_CORE.CONTEXT('PA_PROJECT_WF ','VALIDATE_CHANGES');
996: RAISE;
997:
998: END Validate_Changes;
999: