1321: itemkey => itemkey,
1322: p_api_name =>'OKC_TERMS_UTIl_GRP.DEVIATION_FROM_STANDARD',
1323: p_return_status => l_return_status);
1324: END IF;
1325: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1326: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1327: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_STANDARD_CONTRACT', 'l_contracts_call_Exception');
1328:
1329: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1322: p_api_name =>'OKC_TERMS_UTIl_GRP.DEVIATION_FROM_STANDARD',
1323: p_return_status => l_return_status);
1324: END IF;
1325: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1326: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1327: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_STANDARD_CONTRACT', 'l_contracts_call_Exception');
1328:
1329: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1330: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1325: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1326: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1327: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_STANDARD_CONTRACT', 'l_contracts_call_Exception');
1328:
1329: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1330: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1331: 'PO_CONTERMS_WF_PVT.IS_STANDARD_CONTRACT');
1332: RAISE;
1333:
1335: IF (g_po_wf_debug = 'Y') THEN
1336: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1337: '300: End IN Exception: IS_STANDARD_CONTRACT ');
1338: END IF;
1339: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1340: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1341: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_STANDARD_CONTRACT', 'l_contracts_call_Exception');
1342:
1343: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1336: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1337: '300: End IN Exception: IS_STANDARD_CONTRACT ');
1338: END IF;
1339: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1340: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1341: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_STANDARD_CONTRACT', 'l_contracts_call_Exception');
1342:
1343: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1344: l_doc_string, sqlerrm,
1339: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1340: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1341: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_STANDARD_CONTRACT', 'l_contracts_call_Exception');
1342:
1343: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1344: l_doc_string, sqlerrm,
1345: 'PO_CONTERMS_WF_PVT.IS_STANDARD_CONTRACT');
1346: RAISE;
1347:
1470: itemkey => itemkey,
1471: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_CONTRACT_TEMPLATE_EXPIRED',
1472: p_return_status => l_return_status);
1473: END IF;
1474: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1475: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1476: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_TEMPLATE_EXPIRED', 'l_contracts_call_Exception');
1477:
1478: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1471: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_CONTRACT_TEMPLATE_EXPIRED',
1472: p_return_status => l_return_status);
1473: END IF;
1474: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1475: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1476: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_TEMPLATE_EXPIRED', 'l_contracts_call_Exception');
1477:
1478: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1479: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1474: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1475: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1476: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_TEMPLATE_EXPIRED', 'l_contracts_call_Exception');
1477:
1478: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1479: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1480: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_TEMPLATE_EXPIRED');
1481: RAISE;
1482:
1484: IF (g_po_wf_debug = 'Y') THEN
1485: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1486: '300: End IN Exception: IS_CONTRACT_TEMPLATE_EXPIRED ');
1487: END IF;
1488: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1489: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1490: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_TEMPLATE_EXPIRED', 'l_contracts_call_Exception');
1491:
1492: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1485: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1486: '300: End IN Exception: IS_CONTRACT_TEMPLATE_EXPIRED ');
1487: END IF;
1488: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1489: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1490: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_TEMPLATE_EXPIRED', 'l_contracts_call_Exception');
1491:
1492: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1493: l_doc_string, sqlerrm,
1488: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1489: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1490: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_TEMPLATE_EXPIRED', 'l_contracts_call_Exception');
1491:
1492: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1493: l_doc_string, sqlerrm,
1494: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_TEMPLATE_EXPIRED');
1495: RAISE;
1496:
1621: itemkey => itemkey,
1622: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_ARTICLE_EXIST',
1623: p_return_status => l_return_status);
1624: END IF;
1625: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1626: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1627: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_EXIST', 'l_contracts_call_Exception');
1628:
1629: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1622: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_ARTICLE_EXIST',
1623: p_return_status => l_return_status);
1624: END IF;
1625: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1626: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1627: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_EXIST', 'l_contracts_call_Exception');
1628:
1629: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1630: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1625: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1626: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1627: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_EXIST', 'l_contracts_call_Exception');
1628:
1629: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1630: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1631: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_ARTICLES_EXIST');
1632: RAISE;
1633:
1635: IF (g_po_wf_debug = 'Y') THEN
1636: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1637: '300: End IN Exception: IS_CONTRACT_ARTICLES_EXIST ');
1638: END IF;
1639: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1640: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1641: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_EXIST', 'l_contracts_call_Exception');
1642:
1643: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1636: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1637: '300: End IN Exception: IS_CONTRACT_ARTICLES_EXIST ');
1638: END IF;
1639: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1640: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1641: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_EXIST', 'l_contracts_call_Exception');
1642:
1643: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1644: l_doc_string, sqlerrm,
1639: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1640: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1641: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_EXIST', 'l_contracts_call_Exception');
1642:
1643: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1644: l_doc_string, sqlerrm,
1645: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_ARTICLES_EXIST');
1646: RAISE;
1647:
1773: itemkey => itemkey,
1774: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED',
1775: p_return_status => l_return_status);
1776: END IF;
1777: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1778: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1779: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_AMENDED', 'l_contracts_call_Exception');
1780:
1781: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1774: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_ARTICLE_AMENDED',
1775: p_return_status => l_return_status);
1776: END IF;
1777: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1778: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1779: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_AMENDED', 'l_contracts_call_Exception');
1780:
1781: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1782: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1777: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1778: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1779: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_AMENDED', 'l_contracts_call_Exception');
1780:
1781: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1782: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1783: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_ARTICLES_AMENDED');
1784: RAISE;
1785:
1787: IF (g_po_wf_debug = 'Y') THEN
1788: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1789: '300: End IN Exception: IS_CONTRACT_ARTICLES_AMENDED ');
1790: END IF;
1791: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1792: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1793: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_AMENDED', 'l_contracts_call_Exception');
1794:
1795: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1788: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1789: '300: End IN Exception: IS_CONTRACT_ARTICLES_AMENDED ');
1790: END IF;
1791: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1792: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1793: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_AMENDED', 'l_contracts_call_Exception');
1794:
1795: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1796: l_doc_string, sqlerrm,
1791: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1792: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1793: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_AMENDED', 'l_contracts_call_Exception');
1794:
1795: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1796: l_doc_string, sqlerrm,
1797: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_ARTICLES_AMENDED');
1798: RAISE;
1799:
1930: itemkey => itemkey,
1931: p_api_name =>'OKC_TERMS_UTIl_GRP.Is_Deliverable_Exist',
1932: p_return_status => l_return_status);
1933: END IF;
1934: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1935: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1936: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_EXIST', 'l_contracts_call_Exception');
1937:
1938: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1931: p_api_name =>'OKC_TERMS_UTIl_GRP.Is_Deliverable_Exist',
1932: p_return_status => l_return_status);
1933: END IF;
1934: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1935: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1936: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_EXIST', 'l_contracts_call_Exception');
1937:
1938: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1939: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1934: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1935: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1936: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_EXIST', 'l_contracts_call_Exception');
1937:
1938: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1939: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
1940: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_DELIVRABLS_EXIST');
1941: RAISE;
1942:
1944: IF (g_po_wf_debug = 'Y') THEN
1945: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1946: '300: End IN Exception: IS_CONTRACT_DELIVRABLS_EXIST ');
1947: END IF;
1948: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1949: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1950: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_EXIST', 'l_contracts_call_Exception');
1951:
1952: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1945: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
1946: '300: End IN Exception: IS_CONTRACT_DELIVRABLS_EXIST ');
1947: END IF;
1948: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1949: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1950: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_EXIST', 'l_contracts_call_Exception');
1951:
1952: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1953: l_doc_string, sqlerrm,
1948: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
1949: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
1950: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_EXIST', 'l_contracts_call_Exception');
1951:
1952: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
1953: l_doc_string, sqlerrm,
1954: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_DELIVRABLS_EXIST');
1955: RAISE;
1956:
2086: itemkey => itemkey,
2087: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_DELIVERABLE_AMENDED',
2088: p_return_status => l_return_status);
2089: END IF;
2090: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2091: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2092: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_AMENDED', 'l_contracts_call_Exception');
2093:
2094: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
2087: p_api_name =>'OKC_TERMS_UTIl_GRP.IS_DELIVERABLE_AMENDED',
2088: p_return_status => l_return_status);
2089: END IF;
2090: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2091: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2092: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_AMENDED', 'l_contracts_call_Exception');
2093:
2094: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
2095: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
2090: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2091: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2092: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_AMENDED', 'l_contracts_call_Exception');
2093:
2094: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
2095: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),
2096: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_DELIVRABLS_AMENDED');
2097: RAISE;
2098:
2100: IF (g_po_wf_debug = 'Y') THEN
2101: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
2102: '300: End IN Exception: IS_CONTRACT_DELIVRABLS_AMENDED ');
2103: END IF;
2104: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2105: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2106: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_AMENDED', 'l_contracts_call_Exception');
2107:
2108: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
2101: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
2102: '300: End IN Exception: IS_CONTRACT_DELIVRABLS_AMENDED ');
2103: END IF;
2104: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2105: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2106: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_AMENDED', 'l_contracts_call_Exception');
2107:
2108: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
2109: l_doc_string, sqlerrm,
2104: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);
2105: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, itemkey);
2106: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_AMENDED', 'l_contracts_call_Exception');
2107:
2108: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name,
2109: l_doc_string, sqlerrm,
2110: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_DELIVRABLS_AMENDED');
2111: RAISE;
2112: