DBA Data[Home] [Help]

APPS.PO_REQAPPROVAL_ACTION dependencies on FND_API

Line 610: IF l_sub_check_status = FND_API.G_RET_STS_SUCCESS THEN

606:
607: -- New call in FPI
608: l_sub_check_status := DocCompleteCheck(itemtype, itemkey);
609:
610: IF l_sub_check_status = FND_API.G_RET_STS_SUCCESS THEN
611:
612: /*Bug 11727653: BYPASSING MULTIPLE SUBMISSION CHECKS IN WORKFLOW
613: - setting the bypass flag to Y once submission checks are successful*/
614: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,

Line 622: ELSIF l_sub_check_status = FND_API.G_RET_STS_ERROR THEN

618:
619: resultout := wf_engine.eng_completed || ':' || 'Y';
620: x_resultout := 'Y';
621:
622: ELSIF l_sub_check_status = FND_API.G_RET_STS_ERROR THEN
623:
624: resultout := wf_engine.eng_completed || ':' || 'N';
625: x_resultout := 'N';
626:

Line 627: ELSIF l_sub_check_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

623:
624: resultout := wf_engine.eng_completed || ':' || 'N';
625: x_resultout := 'N';
626:
627: ELSIF l_sub_check_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
628:
629: raise FND_API.G_EXC_UNEXPECTED_ERROR;
630: END IF;
631: --

Line 629: raise FND_API.G_EXC_UNEXPECTED_ERROR;

625: x_resultout := 'N';
626:
627: ELSIF l_sub_check_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
628:
629: raise FND_API.G_EXC_UNEXPECTED_ERROR;
630: END IF;
631: --
632:
633: x_progress := 'PO_REQAPPROVAL_ACTION.Doc_complete_check: 02. RESULT= ' || x_resultout;

Line 643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

639: EXCEPTION
640:
641: WHEN doc_manager_exception THEN
642: raise;
643: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
644: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
645: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
646: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Doc_complete_check', itemtype, itemkey, x_progress);
647: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.DOC_COMPLETE_CHECK');

Line 1842: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1838: ** x_sub_check_status = G_RET_STS_ERROR then return G_RET_STS_ERROR
1839: ** Else issue a notification to the system admin that something is wrong with the
1840: ** Submission Check API call.
1841: */
1842: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1843:
1844: IF x_sub_check_status = FND_API.G_RET_STS_SUCCESS THEN
1845: return(FND_API.G_RET_STS_SUCCESS);
1846: ELSE

Line 1844: IF x_sub_check_status = FND_API.G_RET_STS_SUCCESS THEN

1840: ** Submission Check API call.
1841: */
1842: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1843:
1844: IF x_sub_check_status = FND_API.G_RET_STS_SUCCESS THEN
1845: return(FND_API.G_RET_STS_SUCCESS);
1846: ELSE
1847:
1848: x_progress := 'PO_REQAPPROVAL_ACTION.DocCompleteCheck: x_sub_check_status= ' ||

Line 1845: return(FND_API.G_RET_STS_SUCCESS);

1841: */
1842: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1843:
1844: IF x_sub_check_status = FND_API.G_RET_STS_SUCCESS THEN
1845: return(FND_API.G_RET_STS_SUCCESS);
1846: ELSE
1847:
1848: x_progress := 'PO_REQAPPROVAL_ACTION.DocCompleteCheck: x_sub_check_status= ' ||
1849: x_sub_check_status || ' On_Line_Report_id= ' ||

Line 1886: return (FND_API.G_RET_STS_SUCCESS);

1882:
1883: IF (g_po_wf_debug = 'Y') THEN
1884: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1885: END IF;
1886: return (FND_API.G_RET_STS_SUCCESS);
1887: END IF; --l_error=W
1888: END IF;-- l_conterms_yn
1889:
1890: --

Line 1900: return(FND_API.G_RET_STS_ERROR);

1896:
1897: /* Get the text of the online_report and store in workflow item attribute */
1898: get_online_report_text( itemtype, itemkey, x_online_report_id );
1899:
1900: return(FND_API.G_RET_STS_ERROR);
1901:
1902: END IF; --API is success
1903:
1904: ELSE

Line 3070: -- p_encoded = FND_API.G_FALSE to FND_MSG_PUB.get().

3066: -- Get warning message off of stack.
3067: -- Bug 3518326: Since we pass l_warning_mesg directly
3068: -- into the 'ADVISORY WARNING' wf attribute below, we
3069: -- have to make sure that we decode it. Hence, pass
3070: -- p_encoded = FND_API.G_FALSE to FND_MSG_PUB.get().
3071:
3072: l_warning_mesg := FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE);
3073:
3074: -- Set the warning message to workflow attribute ADVISORY_WARNING.

Line 3072: l_warning_mesg := FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE);

3068: -- into the 'ADVISORY WARNING' wf attribute below, we
3069: -- have to make sure that we decode it. Hence, pass
3070: -- p_encoded = FND_API.G_FALSE to FND_MSG_PUB.get().
3071:
3072: l_warning_mesg := FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE);
3073:
3074: -- Set the warning message to workflow attribute ADVISORY_WARNING.
3075: -- If there is no message then it will be set to null
3076: -- Bug 3536831: Call new get_advisory_warning procedure so that the

Line 3664: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3660: );
3661:
3662: l_progress := '010';
3663:
3664: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3666: END IF;
3667:
3668: l_progress := '100';

Line 3665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3661:
3662: l_progress := '010';
3663:
3664: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3666: END IF;
3667:
3668: l_progress := '100';
3669:

Line 3673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3669:
3670: COMMIT;
3671:
3672: EXCEPTION
3673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3674: ROLLBACK TO ReserveAutonomous_SP;
3675: /* Bug 3293107: removed to_char() around l_progress */
3676: wf_core.context('PO_REQAPPROVAL_ACTION','ReserveAutonomous',
3677: l_progress);