APPS.PA_DCTN_APRV_NOTIFICATION dependencies on FND_API

Line 274: WHEN FND_API.G_EXC_ERROR THEN

270: x_err_stack := l_err_stack;
271: END IF;
272:
273: EXCEPTION
274: WHEN FND_API.G_EXC_ERROR THEN
275: WF_CORE.CONTEXT('PA_DCTN_APRV_NOTIFICATION ','Start_Dctn_Aprv_Wf');
276: RAISE;
277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
278: x_err_code := SQLCODE;

Line 277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

273: EXCEPTION
274: WHEN FND_API.G_EXC_ERROR THEN
275: WF_CORE.CONTEXT('PA_DCTN_APRV_NOTIFICATION ','Start_Dctn_Aprv_Wf');
276: RAISE;
277: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
278: x_err_code := SQLCODE;
279: WF_CORE.CONTEXT('PA_DCTN_APRV_NOTIFICATION','Start_Dctn_Aprv_Wf');
280: RAISE;
281: WHEN OTHERS THEN

Line 355: PA_PAGE_CONTENTS_PUB.Create_Page_Contents(p_init_msg_list => fnd_api.g_false

351: CLOSE c_vendor_info;
352:
353: x_content_id := 0;
354:
355: PA_PAGE_CONTENTS_PUB.Create_Page_Contents(p_init_msg_list => fnd_api.g_false
356: ,p_validate_only => fnd_api.g_false
357: ,p_object_type => 'PA_DCTN_APRV_NOTIFY'
358: ,p_pk1_value => p_dctn_hdr_rec.deduction_req_id
359: ,p_pk2_value => NULL

Line 356: ,p_validate_only => fnd_api.g_false

352:
353: x_content_id := 0;
354:
355: PA_PAGE_CONTENTS_PUB.Create_Page_Contents(p_init_msg_list => fnd_api.g_false
356: ,p_validate_only => fnd_api.g_false
357: ,p_object_type => 'PA_DCTN_APRV_NOTIFY'
358: ,p_pk1_value => p_dctn_hdr_rec.deduction_req_id
359: ,p_pk2_value => NULL
360: ,x_page_content_id => l_page_content_id

Line 733: WHEN FND_API.G_EXC_ERROR THEN

729: resultout := WF_ENGINE.eng_completed||':'||'F';
730: END IF;
731:
732: EXCEPTION
733: WHEN FND_API.G_EXC_ERROR THEN
734: WF_CORE.CONTEXT('PA_PWP_NOTIFICATION','SELECT_PROJECT_MANAGER',itemtype, itemkey, to_char(actid), funcmode);
735: RAISE;
736:
737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

733: WHEN FND_API.G_EXC_ERROR THEN
734: WF_CORE.CONTEXT('PA_PWP_NOTIFICATION','SELECT_PROJECT_MANAGER',itemtype, itemkey, to_char(actid), funcmode);
735: RAISE;
736:
737: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
738: WF_CORE.CONTEXT('PA_PWP_NOTIFICATION','SELECT_PROJECT_MANAGER',itemtype, itemkey, to_char(actid), funcmode);
739: RAISE;
740:
741: WHEN OTHERS THEN

Line 794: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

790: ,x_return_status => l_return_status
791: ,x_msg_count => l_msg_count
792: ,x_msg_data => l_msg_data);
793:
794: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
795: WF_NOTIFICATION.WriteToClob(document, 'Content Generation failed');
796: DBMS_LOB.writeappend(document, 255, SUBSTR(SQLERRM, 255));
797: END IF;
798: ELSE