165: END IF;
166:
167: EXCEPTION
168:
169: WHEN FND_API.G_EXC_ERROR
170: THEN
171: WF_CORE.CONTEXT('PA_PROJECT_WF','SELECT_PROJECT_APPROVER',itemtype, itemkey, to_char(actid), funcmode);
172: RAISE;
173:
170: THEN
171: WF_CORE.CONTEXT('PA_PROJECT_WF','SELECT_PROJECT_APPROVER',itemtype, itemkey, to_char(actid), funcmode);
172: RAISE;
173:
174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
175: THEN
176: WF_CORE.CONTEXT('PA_PROJECT_WF','SELECT_PROJECT_APPROVER',itemtype, itemkey, to_char(actid), funcmode);
177: RAISE;
178:
329:
330: IF (l_err_code < 0)
331: THEN
332: WF_CORE.CONTEXT('PA_PROJECT_WF','GET_PROJ_STATUS_ATTRIBUTES',itemtype, itemkey, to_char(actid), funcmode);
333: RAISE FND_API.G_EXC_ERROR;
334: ELSIF (l_err_code > 0)
335: THEN
336: resultout := wf_engine.eng_completed||':'||'F';
337: WF_CORE.CONTEXT('PA_PROJECT_WF','GET_PROJ_STATUS_ATTRIBUTES',itemtype, itemkey, to_char(actid), funcmode);
544: ,x_msg_count => l_msg_count
545: ,x_msg_data => l_err_stack
546: ,x_return_status => l_return_status
547: );
548: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
549: RAISE FND_API.G_EXC_ERROR;
550: END IF;
551: END IF;
552: End Commenting for Bug 3819086 */
545: ,x_msg_data => l_err_stack
546: ,x_return_status => l_return_status
547: );
548: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
549: RAISE FND_API.G_EXC_ERROR;
550: END IF;
551: END IF;
552: End Commenting for Bug 3819086 */
553:
621:
622:
623: EXCEPTION
624:
625: WHEN FND_API.G_EXC_ERROR
626: THEN
627: WF_CORE.CONTEXT('PA_PROJECT_WF','SET_SUCCESS_STATUS',itemtype, itemkey, to_char(actid), funcmode);
628: RAISE;
629:
665: -- Don't Check for positive error codes because there isn't any notification to display the
666: -- business rule messages.
667: THEN
668: WF_CORE.CONTEXT('PA_PROJECT_WF','GET_PROJ_STATUS_ATTRIBUTES',itemtype, itemkey, to_char(actid), funcmode);
669: RAISE FND_API.G_EXC_ERROR;
670: END IF;
671:
672: Pa_workflow_utils.Set_Global_Attr (p_item_type => itemtype,
673: p_item_key => itemkey,
745: /* End of code for 7299466*/
746:
747: EXCEPTION
748:
749: WHEN FND_API.G_EXC_ERROR
750: THEN
751: WF_CORE.CONTEXT('PA_PROJECT_WF','SET_FAILURE_STATUS',itemtype, itemkey, to_char(actid), funcmode);
752: RAISE;
753:
791:
792: IF (l_err_code < 0)
793: THEN
794: WF_CORE.CONTEXT('PA_PROJECT_WF','GET_PROJ_STATUS_ATTRIBUTES',itemtype, itemkey, to_char(actid), funcmode);
795: RAISE FND_API.G_EXC_ERROR;
796: ELSIF (l_err_code > 0)
797: THEN
798: resultout := wf_engine.eng_completed||':'||'F';
799: WF_CORE.CONTEXT('PA_PROJECT_WF','GET_PROJ_STATUS_ATTRIBUTES',itemtype, itemkey, to_char(actid), funcmode);
833: END IF;
834:
835: EXCEPTION
836:
837: WHEN FND_API.G_EXC_ERROR
838: THEN
839: WF_CORE.CONTEXT('PA_PROJECT_WF','VERIFY_STATUS_CHANGE_RULES',itemtype, itemkey, to_char(actid), funcmode);
840: RAISE;
841: