APPS.PO_REQAPPROVAL_ACTION dependencies on FND_API

Line 595: IF l_sub_check_status = FND_API.G_RET_STS_SUCCESS THEN

591:
592: -- New call in FPI
593: l_sub_check_status := DocCompleteCheck(itemtype, itemkey);
594:
595: IF l_sub_check_status = FND_API.G_RET_STS_SUCCESS THEN
596:
597: resultout := wf_engine.eng_completed || ':' || 'Y';
598: x_resultout := 'Y';
599:

Line 600: ELSIF l_sub_check_status = FND_API.G_RET_STS_ERROR THEN

596:
597: resultout := wf_engine.eng_completed || ':' || 'Y';
598: x_resultout := 'Y';
599:
600: ELSIF l_sub_check_status = FND_API.G_RET_STS_ERROR THEN
601:
602: resultout := wf_engine.eng_completed || ':' || 'N';
603: x_resultout := 'N';
604:

Line 605: ELSIF l_sub_check_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

601:
602: resultout := wf_engine.eng_completed || ':' || 'N';
603: x_resultout := 'N';
604:
605: ELSIF l_sub_check_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
606:
607: raise FND_API.G_EXC_UNEXPECTED_ERROR;
608: END IF;
609: --

Line 607: raise FND_API.G_EXC_UNEXPECTED_ERROR;

603: x_resultout := 'N';
604:
605: ELSIF l_sub_check_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
606:
607: raise FND_API.G_EXC_UNEXPECTED_ERROR;
608: END IF;
609: --
610:
611: x_progress := 'PO_REQAPPROVAL_ACTION.Doc_complete_check: 02. RESULT= ' || x_resultout;

Line 621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

617: EXCEPTION
618:
619: WHEN doc_manager_exception THEN
620: raise;
621: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
622: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
623: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
624: WF_CORE.context('PO_REQAPPROVAL_ACTION', 'Doc_complete_check', itemtype, itemkey, x_progress);
625: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, 'PO_REQAPPROVAL_ACTION.DOC_COMPLETE_CHECK');

Line 1709: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1705: ** x_sub_check_status = G_RET_STS_ERROR then return G_RET_STS_ERROR
1706: ** Else issue a notification to the system admin that something is wrong with the
1707: ** Submission Check API call.
1708: */
1709: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1710:
1711: IF x_sub_check_status = FND_API.G_RET_STS_SUCCESS THEN
1712: return(FND_API.G_RET_STS_SUCCESS);
1713: ELSE

Line 1711: IF x_sub_check_status = FND_API.G_RET_STS_SUCCESS THEN

1707: ** Submission Check API call.
1708: */
1709: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1710:
1711: IF x_sub_check_status = FND_API.G_RET_STS_SUCCESS THEN
1712: return(FND_API.G_RET_STS_SUCCESS);
1713: ELSE
1714:
1715: x_progress := 'PO_REQAPPROVAL_ACTION.DocCompleteCheck: x_sub_check_status= ' ||

Line 1712: return(FND_API.G_RET_STS_SUCCESS);

1708: */
1709: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1710:
1711: IF x_sub_check_status = FND_API.G_RET_STS_SUCCESS THEN
1712: return(FND_API.G_RET_STS_SUCCESS);
1713: ELSE
1714:
1715: x_progress := 'PO_REQAPPROVAL_ACTION.DocCompleteCheck: x_sub_check_status= ' ||
1716: x_sub_check_status || ' On_Line_Report_id= ' ||

Line 1753: return (FND_API.G_RET_STS_SUCCESS);

1749:
1750: IF (g_po_wf_debug = 'Y') THEN
1751: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1752: END IF;
1753: return (FND_API.G_RET_STS_SUCCESS);
1754: END IF; --l_error=W
1755: END IF;-- l_conterms_yn
1756:
1757: --

Line 1767: return(FND_API.G_RET_STS_ERROR);

1763:
1764: /* Get the text of the online_report and store in workflow item attribute */
1765: get_online_report_text( itemtype, itemkey, x_online_report_id );
1766:
1767: return(FND_API.G_RET_STS_ERROR);
1768:
1769: END IF; --API is success
1770:
1771: ELSE

Line 1792: return(FND_API.G_RET_STS_UNEXP_ERROR);

1788: IF (g_po_wf_debug = 'Y') THEN
1789: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
1790: END IF;
1791:
1792: return(FND_API.G_RET_STS_UNEXP_ERROR);
1793:
1794: END IF;
1795: --
1796:

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

2849: -- Get warning message off of stack.
2850: -- Bug 3518326: Since we pass l_warning_mesg directly
2851: -- into the 'ADVISORY WARNING' wf attribute below, we
2852: -- have to make sure that we decode it. Hence, pass
2853: -- p_encoded = FND_API.G_FALSE to FND_MSG_PUB.get().
2854:
2855: l_warning_mesg := FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE);
2856:
2857: -- Set the warning message to workflow attribute ADVISORY_WARNING.

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

2851: -- into the 'ADVISORY WARNING' wf attribute below, we
2852: -- have to make sure that we decode it. Hence, pass
2853: -- p_encoded = FND_API.G_FALSE to FND_MSG_PUB.get().
2854:
2855: l_warning_mesg := FND_MSG_PUB.get(p_encoded => FND_API.G_FALSE);
2856:
2857: -- Set the warning message to workflow attribute ADVISORY_WARNING.
2858: -- If there is no message then it will be set to null
2859: -- Bug 3536831: Call new get_advisory_warning procedure so that the

Line 3429: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3425: );
3426:
3427: l_progress := '010';
3428:
3429: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3431: END IF;
3432:
3433: l_progress := '100';

Line 3430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3426:
3427: l_progress := '010';
3428:
3429: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3430: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3431: END IF;
3432:
3433: l_progress := '100';
3434:

Line 3438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3434:
3435: COMMIT;
3436:
3437: EXCEPTION
3438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3439: ROLLBACK TO ReserveAutonomous_SP;
3440: /* Bug 3293107: removed to_char() around l_progress */
3441: wf_core.context('PO_REQAPPROVAL_ACTION','ReserveAutonomous',
3442: l_progress);