DBA Data[Home] [Help]

APPS.PO_CONTERMS_WF_PVT dependencies on PO_REQAPPROVAL_INIT1

Line 1344: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

1340: itemkey => itemkey,
1341: p_api_name =>'OKC_TERMS_UTIl_GRP.DEVIATION_FROM_STANDARD',
1342: p_return_status => l_return_status);
1343: END IF;
1344: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1345: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1346: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_STANDARD_CONTRACT', 'l_contracts_call_Exception');
1347:
1348: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

Line 1345: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

1341: p_api_name =>'OKC_TERMS_UTIl_GRP.DEVIATION_FROM_STANDARD',
1342: p_return_status => l_return_status);
1343: END IF;
1344: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1345: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1346: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_STANDARD_CONTRACT', 'l_contracts_call_Exception');
1347:
1348: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1349: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),

Line 1348: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

1344: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1345: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1346: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_STANDARD_CONTRACT', 'l_contracts_call_Exception');
1347:
1348: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1349: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1350: 'PO_CONTERMS_WF_PVT.IS_STANDARD_CONTRACT');
1351: RAISE;
1352:

Line 1358: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

1354: IF (g_po_wf_debug = 'Y') THEN
1355: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1356: '300: End IN Exception: IS_STANDARD_CONTRACT ');
1357: END IF;
1358: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1359: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1360: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_STANDARD_CONTRACT', 'l_contracts_call_Exception');
1361:
1362: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

Line 1359: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

1355: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1356: '300: End IN Exception: IS_STANDARD_CONTRACT ');
1357: END IF;
1358: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1359: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1360: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_STANDARD_CONTRACT', 'l_contracts_call_Exception');
1361:
1362: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1363: l_doc_string, sqlerrm,

Line 1362: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

1358: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1359: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1360: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_STANDARD_CONTRACT', 'l_contracts_call_Exception');
1361:
1362: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1363: l_doc_string, sqlerrm,
1364: 'PO_CONTERMS_WF_PVT.IS_STANDARD_CONTRACT');
1365: RAISE;
1366:

Line 1493: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

1489: itemkey => itemkey,
1490: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_CONTRACT_TEMPLATE_EXPIRED',
1491: p_return_status => l_return_status);
1492: END IF;
1493: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1494: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1495: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_TEMPLATE_EXPIRED', 'l_contracts_call_Exception');
1496:
1497: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

Line 1494: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

1490: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_CONTRACT_TEMPLATE_EXPIRED',
1491: p_return_status => l_return_status);
1492: END IF;
1493: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1494: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1495: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_TEMPLATE_EXPIRED', 'l_contracts_call_Exception');
1496:
1497: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1498: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),

Line 1497: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

1493: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1494: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1495: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_TEMPLATE_EXPIRED', 'l_contracts_call_Exception');
1496:
1497: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1498: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1499: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_TEMPLATE_EXPIRED');
1500: RAISE;
1501:

Line 1507: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

1503: IF (g_po_wf_debug = 'Y') THEN
1504: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1505: '300: End IN Exception: IS_CONTRACT_TEMPLATE_EXPIRED ');
1506: END IF;
1507: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1508: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1509: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_TEMPLATE_EXPIRED', 'l_contracts_call_Exception');
1510:
1511: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

Line 1508: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

1504: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1505: '300: End IN Exception: IS_CONTRACT_TEMPLATE_EXPIRED ');
1506: END IF;
1507: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1508: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1509: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_TEMPLATE_EXPIRED', 'l_contracts_call_Exception');
1510:
1511: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1512: l_doc_string, sqlerrm,

Line 1511: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

1507: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1508: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1509: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_TEMPLATE_EXPIRED', 'l_contracts_call_Exception');
1510:
1511: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1512: l_doc_string, sqlerrm,
1513: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_TEMPLATE_EXPIRED');
1514: RAISE;
1515:

Line 1644: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

1640: itemkey => itemkey,
1641: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_ARTICLE_EXIST',
1642: p_return_status => l_return_status);
1643: END IF;
1644: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1645: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1646: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_EXIST', 'l_contracts_call_Exception');
1647:
1648: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

Line 1645: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

1641: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_ARTICLE_EXIST',
1642: p_return_status => l_return_status);
1643: END IF;
1644: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1645: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1646: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_EXIST', 'l_contracts_call_Exception');
1647:
1648: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1649: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),

Line 1648: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

1644: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1645: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1646: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_EXIST', 'l_contracts_call_Exception');
1647:
1648: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1649: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1650: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_ARTICLES_EXIST');
1651: RAISE;
1652:

Line 1658: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

1654: IF (g_po_wf_debug = 'Y') THEN
1655: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1656: '300: End IN Exception: IS_CONTRACT_ARTICLES_EXIST ');
1657: END IF;
1658: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1659: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1660: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_EXIST', 'l_contracts_call_Exception');
1661:
1662: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

Line 1659: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

1655: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1656: '300: End IN Exception: IS_CONTRACT_ARTICLES_EXIST ');
1657: END IF;
1658: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1659: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1660: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_EXIST', 'l_contracts_call_Exception');
1661:
1662: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1663: l_doc_string, sqlerrm,

Line 1662: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

1658: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1659: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1660: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_EXIST', 'l_contracts_call_Exception');
1661:
1662: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1663: l_doc_string, sqlerrm,
1664: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_ARTICLES_EXIST');
1665: RAISE;
1666:

Line 1796: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

1792: itemkey => itemkey,
1793: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED',
1794: p_return_status => l_return_status);
1795: END IF;
1796: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1797: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1798: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_AMENDED', 'l_contracts_call_Exception');
1799:
1800: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

Line 1797: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

1793: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED',
1794: p_return_status => l_return_status);
1795: END IF;
1796: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1797: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1798: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_AMENDED', 'l_contracts_call_Exception');
1799:
1800: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1801: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),

Line 1800: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

1796: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1797: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1798: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_AMENDED', 'l_contracts_call_Exception');
1799:
1800: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1801: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1802: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_ARTICLES_AMENDED');
1803: RAISE;
1804:

Line 1810: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

1806: IF (g_po_wf_debug = 'Y') THEN
1807: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1808: '300: End IN Exception: IS_CONTRACT_ARTICLES_AMENDED ');
1809: END IF;
1810: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1811: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1812: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_AMENDED', 'l_contracts_call_Exception');
1813:
1814: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

Line 1811: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

1807: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1808: '300: End IN Exception: IS_CONTRACT_ARTICLES_AMENDED ');
1809: END IF;
1810: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1811: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1812: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_AMENDED', 'l_contracts_call_Exception');
1813:
1814: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1815: l_doc_string, sqlerrm,

Line 1814: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

1810: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1811: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1812: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_AMENDED', 'l_contracts_call_Exception');
1813:
1814: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1815: l_doc_string, sqlerrm,
1816: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_ARTICLES_AMENDED');
1817: RAISE;
1818:

Line 1953: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

1949: itemkey => itemkey,
1950: p_api_name =>'OKC_TERMS_UTIl_GRP.Is_Deliverable_Exist',
1951: p_return_status => l_return_status);
1952: END IF;
1953: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1954: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1955: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_EXIST', 'l_contracts_call_Exception');
1956:
1957: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

Line 1954: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

1950: p_api_name =>'OKC_TERMS_UTIl_GRP.Is_Deliverable_Exist',
1951: p_return_status => l_return_status);
1952: END IF;
1953: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1954: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1955: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_EXIST', 'l_contracts_call_Exception');
1956:
1957: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1958: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),

Line 1957: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

1953: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1954: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1955: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_EXIST', 'l_contracts_call_Exception');
1956:
1957: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1958: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1959: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_DELIVRABLS_EXIST');
1960: RAISE;
1961:

Line 1967: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

1963: IF (g_po_wf_debug = 'Y') THEN
1964: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1965: '300: End IN Exception: IS_CONTRACT_DELIVRABLS_EXIST ');
1966: END IF;
1967: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1968: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1969: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_EXIST', 'l_contracts_call_Exception');
1970:
1971: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

Line 1968: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

1964: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1965: '300: End IN Exception: IS_CONTRACT_DELIVRABLS_EXIST ');
1966: END IF;
1967: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1968: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1969: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_EXIST', 'l_contracts_call_Exception');
1970:
1971: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1972: l_doc_string, sqlerrm,

Line 1971: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

1967: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1968: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1969: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_EXIST', 'l_contracts_call_Exception');
1970:
1971: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1972: l_doc_string, sqlerrm,
1973: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_DELIVRABLS_EXIST');
1974: RAISE;
1975:

Line 2109: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

2105: itemkey => itemkey,
2106: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_DELIVERABLE_AMENDED',
2107: p_return_status => l_return_status);
2108: END IF;
2109: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2110: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2111: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_AMENDED', 'l_contracts_call_Exception');
2112:
2113: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

Line 2110: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

2106: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_DELIVERABLE_AMENDED',
2107: p_return_status => l_return_status);
2108: END IF;
2109: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2110: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2111: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_AMENDED', 'l_contracts_call_Exception');
2112:
2113: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
2114: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),

Line 2113: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

2109: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2110: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2111: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_AMENDED', 'l_contracts_call_Exception');
2112:
2113: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
2114: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
2115: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_DELIVRABLS_AMENDED');
2116: RAISE;
2117:

Line 2123: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

2119: IF (g_po_wf_debug = 'Y') THEN
2120: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
2121: '300: End IN Exception: IS_CONTRACT_DELIVRABLS_AMENDED ');
2122: END IF;
2123: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2124: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2125: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_AMENDED', 'l_contracts_call_Exception');
2126:
2127: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

Line 2124: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);

2120: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
2121: '300: End IN Exception: IS_CONTRACT_DELIVRABLS_AMENDED ');
2122: END IF;
2123: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2124: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2125: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_AMENDED', 'l_contracts_call_Exception');
2126:
2127: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
2128: l_doc_string, sqlerrm,

Line 2127: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,

2123: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2124: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2125: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_AMENDED', 'l_contracts_call_Exception');
2126:
2127: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
2128: l_doc_string, sqlerrm,
2129: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_DELIVRABLS_AMENDED');
2130: RAISE;
2131: