DBA Data[Home] [Help]

APPS.PO_CONTERMS_WF_PVT dependencies on PO_CONTERMS_WF_PVT

Line 1: package body PO_CONTERMS_WF_PVT AS

1: package body PO_CONTERMS_WF_PVT AS
2: /* $Header: POXVWCTB.pls 120.5 2011/12/12 09:23:45 ssindhe ship $ */
3:
4: --< CONTERMS FPJ Start>
5: -- Get profile option that enables/disables the debug log for workflow

Line 526: wf_core.context('PO_CONTERMS_WF_PVT', 'CONTRACT_TERMS_CHANGED', 'l_contracts_call_Exception');

522: itemkey => itemkey,
523: p_api_name => l_api_name,
524: p_return_status => l_return_status);
525: END IF;
526: wf_core.context('PO_CONTERMS_WF_PVT', 'CONTRACT_TERMS_CHANGED', 'l_contracts_call_Exception');
527: RAISE;
528: WHEN OTHERS THEN
529: IF (g_po_wf_debug = 'Y') THEN
530: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,

Line 533: wf_core.context('PO_CONTERMS_WF_PVT', 'CONTRACT_TERMS_CHANGED', 'Exception');

529: IF (g_po_wf_debug = 'Y') THEN
530: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,
531: '300: End IN Exception: contract_terms_Changed ');
532: END IF;
533: wf_core.context('PO_CONTERMS_WF_PVT', 'CONTRACT_TERMS_CHANGED', 'Exception');
534: RAISE;
535:
536: END CONTRACT_TERMS_CHANGED;
537:

Line 710: , VALUE => 'PO_CONTERMS_WF_PVT.UPDATE_CONTERMS_DATES');

706: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
707: ELSE
708: Fnd_message.set_name('PO','PO_API_ERROR');
709: Fnd_message.set_token( token => 'PROC_CALLER'
710: , VALUE => 'PO_CONTERMS_WF_PVT.UPDATE_CONTERMS_DATES');
711: Fnd_message.set_token( token => 'PROC_CALLED'
712: , VALUE => l_k_api_name);
713: FND_MSG_PUB.Add;
714: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );

Line 741: (p_pkg_name => 'PO_CONTERMS_WF_PVT',

737: IF FND_MSG_PUB.Check_Msg_Level
738: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
739: THEN
740: FND_MSG_PUB.Add_Exc_Msg
741: (p_pkg_name => 'PO_CONTERMS_WF_PVT',
742: p_procedure_name =>'UPDATE_CONTERMS_DATES');
743:
744: END IF; --msg level
745: FND_MSG_PUB.Count_And_Get

Line 1153: , VALUE => 'PO_CONTERMS_WF_PVT.UPDATE_CONTRACT_TERMS');

1149: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );
1150: ELSE
1151: Fnd_message.set_name('PO','PO_API_ERROR');
1152: Fnd_message.set_token( token => 'PROC_CALLER'
1153: , VALUE => 'PO_CONTERMS_WF_PVT.UPDATE_CONTRACT_TERMS');
1154: Fnd_message.set_token( token => 'PROC_CALLED'
1155: , VALUE => l_k_api_name);
1156: FND_MSG_PUB.Add;
1157: x_msg_data := FND_MSG_PUB.Get(p_msg_index=>1,p_encoded =>'F' );

Line 1176: (p_pkg_name => 'PO_CONTERMS_WF_PVT',

1172: IF FND_MSG_PUB.Check_Msg_Level
1173: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1174: THEN
1175: FND_MSG_PUB.Add_Exc_Msg
1176: (p_pkg_name => 'PO_CONTERMS_WF_PVT',
1177: p_procedure_name =>'UPDATE_CONTRACT_TERMS');
1178:
1179: END IF; --msg level
1180: FND_MSG_PUB.Count_And_Get

Line 1346: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_STANDARD_CONTRACT', 'l_contracts_call_Exception');

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' ),
1350: 'PO_CONTERMS_WF_PVT.IS_STANDARD_CONTRACT');

Line 1350: 'PO_CONTERMS_WF_PVT.IS_STANDARD_CONTRACT');

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:
1353: WHEN OTHERS THEN
1354: IF (g_po_wf_debug = 'Y') THEN

Line 1360: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_STANDARD_CONTRACT', 'l_contracts_call_Exception');

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,
1364: 'PO_CONTERMS_WF_PVT.IS_STANDARD_CONTRACT');

Line 1364: 'PO_CONTERMS_WF_PVT.IS_STANDARD_CONTRACT');

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:
1367: END IS_STANDARD_CONTRACT;
1368: -------------------------------------------------------------------------------

Line 1495: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_TEMPLATE_EXPIRED', 'l_contracts_call_Exception');

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' ),
1499: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_TEMPLATE_EXPIRED');

Line 1499: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_TEMPLATE_EXPIRED');

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:
1502: WHEN OTHERS THEN
1503: IF (g_po_wf_debug = 'Y') THEN

Line 1509: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_TEMPLATE_EXPIRED', 'l_contracts_call_Exception');

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,
1513: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_TEMPLATE_EXPIRED');

Line 1513: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_TEMPLATE_EXPIRED');

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:
1516: END IS_CONTRACT_TEMPLATE_EXPIRED;
1517:

Line 1646: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_EXIST', 'l_contracts_call_Exception');

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' ),
1650: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_ARTICLES_EXIST');

Line 1650: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_ARTICLES_EXIST');

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:
1653: WHEN OTHERS THEN
1654: IF (g_po_wf_debug = 'Y') THEN

Line 1660: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_EXIST', 'l_contracts_call_Exception');

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,
1664: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_ARTICLES_EXIST');

Line 1664: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_ARTICLES_EXIST');

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:
1667:
1668: END IS_CONTRACT_ARTICLES_EXIST;

Line 1798: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_AMENDED', 'l_contracts_call_Exception');

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' ),
1802: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_ARTICLES_AMENDED');

Line 1802: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_ARTICLES_AMENDED');

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:
1805: WHEN OTHERS THEN
1806: IF (g_po_wf_debug = 'Y') THEN

Line 1812: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_ARTICLES_AMENDED', 'l_contracts_call_Exception');

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,
1816: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_ARTICLES_AMENDED');

Line 1816: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_ARTICLES_AMENDED');

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:
1819:
1820: END IS_CONTRACT_ARTICLES_AMENDED;

Line 1955: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_EXIST', 'l_contracts_call_Exception');

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' ),
1959: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_DELIVRABLS_EXIST');

Line 1959: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_DELIVRABLS_EXIST');

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:
1962: WHEN OTHERS THEN
1963: IF (g_po_wf_debug = 'Y') THEN

Line 1969: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_EXIST', 'l_contracts_call_Exception');

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,
1973: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_DELIVRABLS_EXIST');

Line 1973: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_DELIVRABLS_EXIST');

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:
1976:
1977: END IS_CONTRACT_DELIVRABLS_EXIST;

Line 2111: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_AMENDED', 'l_contracts_call_Exception');

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' ),
2115: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_DELIVRABLS_AMENDED');

Line 2115: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_DELIVRABLS_AMENDED');

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:
2118: WHEN OTHERS THEN
2119: IF (g_po_wf_debug = 'Y') THEN

Line 2125: wf_core.context('PO_CONTERMS_WF_PVT', 'IS_CONTRACT_DELIVRABLS_AMENDED', 'l_contracts_call_Exception');

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,
2129: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_DELIVRABLS_AMENDED');

Line 2129: 'PO_CONTERMS_WF_PVT.IS_CONTRACT_DELIVRABLS_AMENDED');

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:
2132:
2133: END IS_CONTRACT_DELIVRABLS_AMENDED;

Line 2284: End PO_CONTERMS_WF_PVT;

2280: END cancel_deliverables;
2281:
2282: /* CONTERMS FPJ END */
2283: --
2284: End PO_CONTERMS_WF_PVT;