DBA Data[Home] [Help]

APPS.PO_CONTERMS_WF_PVT dependencies on PO_REQAPPROVAL_INIT1

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

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,

Line 1326: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, 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,
1330: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),

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

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:

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

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,

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

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,

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

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:

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

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,

Line 1475: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, 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,
1479: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),

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

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:

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

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,

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

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,

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

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:

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

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,

Line 1626: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, 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,
1630: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),

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

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:

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

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,

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

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,

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

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:

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

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,

Line 1778: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, 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,
1782: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),

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

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:

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

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,

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

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,

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

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:

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

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,

Line 1935: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, 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,
1939: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),

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

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:

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

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,

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

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,

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

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:

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

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,

Line 2091: l_preparer_user_name := PO_REQAPPROVAL_INIT1.get_preparer_user_name(itemType, 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,
2095: l_doc_string, FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' ),

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

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:

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

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,

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

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,

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

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: