eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_REP_CONTRACT_PROCESS_PVT dependencies on OKC_REP_CONTRACT_PROCESS_PVT

Line 1: PACKAGE BODY OKC_REP_CONTRACT_PROCESS_PVT AS

1: PACKAGE BODY OKC_REP_CONTRACT_PROCESS_PVT AS
2: /* $Header: OKCVREPPROCSB.pls 120.19.12020000.23 2013/06/04 11:56:03 nbingi ship $ */
3:
4: ---------------------------------------------------------------------------
5: -- GLOBAL CONSTANTS

Line 432: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_contacts');

428: BEGIN
429:
430: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
431: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
432: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_contacts');
433: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
434: 'Contract Id is: ' || to_char(p_contract_id));
435: END IF;
436: l_api_name := 'delete_contacts';

Line 466: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_contacts');

462: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
463:
464: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
465: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
466: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_contacts');
467: END IF;
468:
469:
470: EXCEPTION

Line 551: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_parties');

547: BEGIN
548:
549: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
550: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
551: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_parties');
552: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
553: 'Contract Id is: ' || p_contract_id);
554: END IF;
555: l_api_name := 'delete_parties';

Line 585: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_parties');

581: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
582:
583: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
584: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
585: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_parties');
586: END IF;
587:
588:
589: EXCEPTION

Line 678: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_risks');

674: BEGIN
675:
676: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
677: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
678: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_risks');
679: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
680: 'Contract Id is: ' || p_contract_id);
681: END IF;
682: l_api_name := 'delete_risks';

Line 730: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_risks');

726: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
727:
728: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
729: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
730: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_risks');
731: END IF;
732:
733:
734: EXCEPTION

Line 836: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_related_contracts');

832: BEGIN
833:
834: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
835: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
836: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_related_contracts');
837: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
838: 'Contract Id is: ' || p_contract_id);
839: END IF;
840: l_api_name := 'delete_related_contracts';

Line 889: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_related_contracts');

885: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
886:
887: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
888: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
889: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_related_contracts');
890: END IF;
891:
892:
893: EXCEPTION

Line 992: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_ACL');

988: BEGIN
989:
990: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
991: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
992: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_ACL');
993: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
994: 'Contract Id is: ' || p_contract_id);
995: END IF;
996: l_api_name := 'delete_ACL';

Line 1060: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_ACL');

1056: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1057:
1058: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1059: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1060: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_ACL');
1061: END IF;
1062:
1063:
1064: EXCEPTION

Line 1159: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_status_history');

1155: BEGIN
1156:
1157: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1158: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1159: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_status_history');
1160: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1161: 'Contract Id is: ' || to_char(p_contract_id));
1162: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1163: 'Contract Version is: ' || to_char(p_contract_version));

Line 1196: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_status_history');

1192: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1193:
1194: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1195: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1196: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_status_history');
1197: END IF;
1198:
1199:
1200: EXCEPTION

Line 1288: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_approval_history');

1284: BEGIN
1285:
1286: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1287: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1288: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_approval_history');
1289: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1290: 'Contract Id is: ' || to_char(p_contract_id));
1291: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1292: 'Contract Version is: ' || to_char(p_contract_version));

Line 1325: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_approval_history');

1321: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1322:
1323: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1324: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1325: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_approval_history');
1326: END IF;
1327:
1328:
1329: EXCEPTION

Line 1413: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_bookmarks');

1409: BEGIN
1410:
1411: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1412: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1413: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_bookmarks');
1414: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1415: 'Contract Id is: ' || p_contract_id);
1416: END IF;
1417: l_api_name := 'delete_bookmarks';

Line 1451: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_bookmarks');

1447: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1448:
1449: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1450: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1451: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_bookmarks');
1452: END IF;
1453:
1454:
1455: EXCEPTION

Line 1534: 'Entered Function OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header');

1530: BEGIN
1531:
1532: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1533: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1534: 'Entered Function OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header');
1535: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1536: 'Contract Id is: ' || p_contract_id);
1537: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1538: 'Object Version is: ' || p_object_version_number);

Line 1647: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header');

1643: BEGIN
1644: l_api_name := 'Lock_Contract_header';
1645: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1646: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1647: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header');
1648: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1649: 'Contract Id is: ' || p_contract_id);
1650: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1651: 'Object Version is: ' || p_object_version_number);

Line 1760: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_contract');

1756: BEGIN
1757:
1758: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1759: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1760: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_contract');
1761: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1762: 'Contract Id is: ' || p_contract_id);
1763: END IF;
1764: l_api_name := 'delete_contract';

Line 1782: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header()');

1778: x_return_status := FND_API.G_RET_STS_SUCCESS;
1779:
1780: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1781: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1782: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header()');
1783: END IF;
1784: -- Lock the contract header
1785: Lock_Contract_Header(
1786: p_contract_id => p_contract_id,

Line 1792: 'OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header return status is: '

1788: x_return_status => x_return_status
1789: );
1790: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1791: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1792: 'OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header return status is: '
1793: || x_return_status);
1794: END IF;
1795: -----------------------------------------------------
1796: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1825: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.delete_contacts()');

1821:
1822: if (contract_rec.contract_version_num = 1) THEN
1823: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1824: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1825: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.delete_contacts()');
1826: END IF;
1827: delete_contacts(
1828: p_api_version => 1.0,
1829: p_commit => FND_API.G_FALSE,

Line 1837: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_contacts return status is: '

1833: x_msg_count => x_msg_count,
1834: x_return_status => x_return_status);
1835: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1836: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1837: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_contacts return status is: '
1838: || x_return_status);
1839: END IF;
1840: -----------------------------------------------------
1841: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1851: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.delete_parties()');

1847:
1848:
1849: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1850: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1851: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.delete_parties()');
1852: END IF;
1853: delete_parties(
1854: p_api_version => 1.0,
1855: p_init_msg_list => FND_API.G_FALSE,

Line 1863: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_parties return status is: '

1859: x_msg_count => x_msg_count,
1860: x_return_status => x_return_status);
1861: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1862: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1863: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_parties return status is: '
1864: || x_return_status);
1865: END IF;
1866: -----------------------------------------------------
1867: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1877: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.delete_risks()');

1873:
1874:
1875: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1876: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1877: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.delete_risks()');
1878: END IF;
1879: delete_risks(
1880: p_api_version => 1.0,
1881: p_init_msg_list => FND_API.G_FALSE,

Line 1889: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_risks return status is: '

1885: x_msg_count => x_msg_count,
1886: x_return_status => x_return_status);
1887: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1888: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1889: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_risks return status is: '
1890: || x_return_status);
1891: END IF;
1892: -----------------------------------------------------
1893: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1903: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.delete_ACL()');

1899:
1900:
1901: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1902: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1903: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.delete_ACL()');
1904: END IF;
1905: delete_ACL(
1906: p_api_version => 1.0,
1907: p_init_msg_list => FND_API.G_FALSE,

Line 1915: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_ACL return status is: '

1911: x_msg_count => x_msg_count,
1912: x_return_status => x_return_status);
1913: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1914: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1915: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_ACL return status is: '
1916: || x_return_status);
1917: END IF;
1918: -----------------------------------------------------
1919: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1929: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.delete_status_history()');

1925:
1926:
1927: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1928: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1929: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.delete_status_history()');
1930: END IF;
1931: delete_status_history(
1932: p_api_version => 1.0,
1933: p_init_msg_list => FND_API.G_FALSE,

Line 1942: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_status_history return status is: '

1938: x_msg_count => x_msg_count,
1939: x_return_status => x_return_status);
1940: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1941: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1942: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_status_history return status is: '
1943: || x_return_status);
1944: END IF;
1945: -----------------------------------------------------
1946: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1956: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.delete_approval_history()');

1952:
1953:
1954: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1955: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1956: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.delete_approval_history()');
1957: END IF;
1958: delete_approval_history(
1959: p_api_version => 1.0,
1960: p_init_msg_list => FND_API.G_FALSE,

Line 1969: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_approval_history return status is: '

1965: x_msg_count => x_msg_count,
1966: x_return_status => x_return_status);
1967: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1968: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1969: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_approval_history return status is: '
1970: || x_return_status);
1971: END IF;
1972: -----------------------------------------------------
1973: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1983: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.delete_bookmarks()');

1979:
1980:
1981: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1982: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1983: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.delete_bookmarks()');
1984: END IF;
1985: delete_bookmarks(
1986: p_api_version => 1.0,
1987: p_init_msg_list => FND_API.G_FALSE,

Line 1996: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_bookmarks return status is: '

1992: x_msg_count => x_msg_count,
1993: x_return_status => x_return_status);
1994: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1995: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1996: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_bookmarks return status is: '
1997: || x_return_status);
1998: END IF;
1999: -----------------------------------------------------
2000: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2013: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.delete_related_contracts()');

2009:
2010:
2011: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2012: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2013: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.delete_related_contracts()');
2014: END IF;
2015: delete_related_contracts(
2016: p_api_version => 1.0,
2017: p_init_msg_list => FND_API.G_FALSE,

Line 2025: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_related_contracts return status is: '

2021: x_msg_count => x_msg_count,
2022: x_return_status => x_return_status);
2023: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2024: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2025: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_related_contracts return status is: '
2026: || x_return_status);
2027: END IF;
2028: -----------------------------------------------------
2029: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2068: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.delete_uda_attribute_values()');

2064:
2065: /* 14543447 - kkolukul - Uda Integration */
2066: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2067: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2068: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.delete_uda_attribute_values()');
2069: END IF;
2070: delete_uda_attribute_values(
2071: p_api_version => 1.0,
2072: p_init_msg_list => FND_API.G_FALSE,

Line 2080: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_uda_attribute_values return status is: '

2076: x_msg_count => x_msg_count,
2077: x_return_status => x_return_status);
2078: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2079: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
2080: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_uda_attribute_values return status is: '
2081: || x_return_status);
2082: END IF;
2083: -----------------------------------------------------
2084: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 2411: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_contract');

2407: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2408:
2409: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2410: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2411: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_contract');
2412: END IF;
2413:
2414:
2415: EXCEPTION

Line 2522: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_contacts');

2518: BEGIN
2519:
2520: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2521: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2522: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_contacts');
2523: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2524: 'Source Contract Id is: ' || to_char(p_source_contract_id));
2525: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2526: 'Target Contract Id is: ' || to_char(p_target_contract_id));

Line 2602: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_contacts');

2598: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2599:
2600: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2601: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2602: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_contacts');
2603: END IF;
2604:
2605:
2606: EXCEPTION

Line 2701: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_parties');

2697: BEGIN
2698:
2699: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2700: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2701: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_parties');
2702: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2703: 'Source Contract Id is: ' || to_char(p_source_contract_id));
2704: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2705: 'Target Contract Id is: ' || to_char(p_target_contract_id));

Line 2772: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_parties');

2768: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2769:
2770: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2771: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2772: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_parties');
2773: END IF;
2774:
2775:
2776: EXCEPTION

Line 2882: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_risks');

2878: BEGIN
2879:
2880: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2881: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2882: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_risks');
2883: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2884: 'Source Contract Id is: ' || to_char(p_source_contract_id));
2885: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2886: 'Target Contract Id is: ' || to_char(p_target_contract_id));

Line 2999: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_risks');

2995: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2996:
2997: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2998: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2999: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_risks');
3000: END IF;
3001:
3002:
3003: EXCEPTION

Line 3122: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_ACL');

3118: BEGIN
3119:
3120: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3121: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3122: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_ACL');
3123: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3124: 'Source Contract Id is: ' || p_source_contract_id);
3125: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3126: 'Target Contract Id is: ' || p_target_contract_id);

Line 3199: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_ACL');

3195: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
3196:
3197: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3198: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3199: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_ACL');
3200: END IF;
3201:
3202:
3203: EXCEPTION

Line 3318: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_contract_details');

3314: BEGIN
3315:
3316: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3317: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3318: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_contract_details');
3319: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3320: 'Source Contract Id is: ' || p_source_contract_id);
3321: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3322: 'Target Contract Id is: ' || p_target_contract_id);

Line 3344: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.copy_parties()');

3340: x_return_status := FND_API.G_RET_STS_SUCCESS;
3341:
3342: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3343: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3344: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.copy_parties()');
3345: END IF;
3346: copy_parties(
3347: p_api_version => 1.0,
3348: p_init_msg_list => FND_API.G_FALSE,

Line 3357: 'OKC_REP_CONTRACT_PROCESS_PVT.copy_parties return status is: '

3353: x_msg_count => x_msg_count,
3354: x_return_status => x_return_status);
3355: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3356: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3357: 'OKC_REP_CONTRACT_PROCESS_PVT.copy_parties return status is: '
3358: || x_return_status);
3359: END IF;
3360: ----------------------------------------------------
3361: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3371: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.copy_contacts()');

3367:
3368:
3369: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3370: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3371: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.copy_contacts()');
3372: END IF;
3373: copy_contacts(
3374: p_api_version => 1.0,
3375: p_init_msg_list => FND_API.G_FALSE,

Line 3384: 'OKC_REP_CONTRACT_PROCESS_PVT.copy_contacts return status is: '

3380: x_msg_count => x_msg_count,
3381: x_return_status => x_return_status);
3382: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3383: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3384: 'OKC_REP_CONTRACT_PROCESS_PVT.copy_contacts return status is: '
3385: || x_return_status);
3386: END IF;
3387: -----------------------------------------------------
3388: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3397: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.copy_risks()');

3393: -----------------------------------------------------
3394:
3395: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3396: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3397: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.copy_risks()');
3398: END IF;
3399: copy_risks(
3400: p_api_version => 1.0,
3401: p_init_msg_list => FND_API.G_FALSE,

Line 3410: 'OKC_REP_CONTRACT_PROCESS_PVT.copy_risks return status is: '

3406: x_msg_count => x_msg_count,
3407: x_return_status => x_return_status);
3408: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3409: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3410: 'OKC_REP_CONTRACT_PROCESS_PVT.copy_risks return status is: '
3411: || x_return_status);
3412: END IF;
3413: -----------------------------------------------------
3414: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3423: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.copy_ACL()');

3419: --------------------------------------------------------
3420:
3421: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3422: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3423: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.copy_ACL()');
3424: END IF;
3425: copy_ACL(
3426: p_api_version => 1.0,
3427: p_init_msg_list => FND_API.G_FALSE,

Line 3436: 'OKC_REP_CONTRACT_PROCESS_PVT.copy_ACL return status is: '

3432: x_msg_count => x_msg_count,
3433: x_return_status => x_return_status);
3434: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3435: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3436: 'OKC_REP_CONTRACT_PROCESS_PVT.copy_ACL return status is: '
3437: || x_return_status);
3438: END IF;
3439: -----------------------------------------------------
3440: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3451: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.copy_uda_attribute_values()');

3447: --14543447 - kkolukul- UDA Integration
3448:
3449: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3450: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3451: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.copy_uda_attribute_values()');
3452: END IF;
3453: copy_uda_attribute_values(
3454: p_api_version => 1.0,
3455: p_init_msg_list => FND_API.G_FALSE,

Line 3464: 'OKC_REP_CONTRACT_PROCESS_PVT.copy_uda_attribute_values return status is: '

3460: x_msg_count => x_msg_count,
3461: x_return_status => x_return_status);
3462: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3463: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3464: 'OKC_REP_CONTRACT_PROCESS_PVT.copy_uda_attribute_values return status is: '
3465: || x_return_status);
3466: END IF;
3467: -----------------------------------------------------
3468: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3616: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_contract_details');

3612: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
3613:
3614: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3615: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3616: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_contract_details');
3617: END IF;
3618:
3619:
3620: EXCEPTION

Line 3746: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.version_contract_usages');

3742: BEGIN
3743:
3744: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3745: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3746: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.version_contract_usages');
3747: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3748: ' Contract Id is: ' || to_char(p_contract_id));
3749: END IF;
3750: l_api_name := 'version_contract_usages';

Line 3869: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.');

3865: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
3866:
3867: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3868: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3869: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.');
3870: END IF;
3871:
3872:
3873: EXCEPTION

Line 3985: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.version_contract_details');

3981: BEGIN
3982:
3983: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3984: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3985: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.version_contract_details');
3986: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3987: 'Contract Id is: ' || p_contract_id);
3988: END IF;
3989: l_api_name := 'version_contract_details';

Line 4008: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header()');

4004:
4005: -- Lock the contract header
4006: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4007: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4008: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header()');
4009: END IF;
4010: -- Lock the contract header
4011: Lock_Contract_Header(
4012: p_contract_id => p_contract_id,

Line 4018: 'OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header return status is: '

4014: x_return_status => x_return_status
4015: );
4016: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4017: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4018: 'OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header return status is: '
4019: || x_return_status);
4020: END IF;
4021: -----------------------------------------------------
4022: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4420: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.version_contract_details');

4416: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4417:
4418: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4419: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4420: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.version_contract_details');
4421: END IF;
4422:
4423:
4424: EXCEPTION

Line 4544: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.sign_contract');

4540: l_effective_date_matches_flag := FND_API.G_FALSE;
4541:
4542: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4543: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4544: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.sign_contract');
4545: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4546: 'Contract Id is: ' || p_contract_id);
4547: END IF;
4548: l_api_name := 'sign_contacts';

Line 4584: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header()');

4580:
4581: -- Lock the contract header
4582: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4583: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4584: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header()');
4585: END IF;
4586: -- Lock the contract header
4587: Lock_Contract_Header(
4588: p_contract_id => p_contract_id,

Line 4594: 'OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header return status is: '

4590: x_return_status => x_return_status
4591: );
4592: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4593: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4594: 'OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header return status is: '
4595: || x_return_status);
4596: END IF;
4597: -----------------------------------------------------
4598: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4837: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.sign_contract');

4833: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4834:
4835: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4836: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4837: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.sign_contract');
4838: END IF;
4839:
4840:
4841: EXCEPTION

Line 4979: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.Esign_contract');

4975: BEGIN
4976:
4977: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4978: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4979: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.Esign_contract');
4980: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4981: 'Contract Id is: ' || p_contract_id);
4982: END IF;
4983: l_api_name := 'Esign_contract';

Line 5240: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.Esign_contract');

5236: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
5237:
5238: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5239: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5240: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.Esign_contract');
5241: END IF;
5242:
5243: EXCEPTION
5244: WHEN FND_API.G_EXC_ERROR THEN

Line 5355: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.terminate_contract');

5351: BEGIN
5352:
5353: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5354: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5355: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.terminate_contract');
5356: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5357: 'Contract Id is: ' || p_contract_id);
5358: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5359: 'Termination date is: ' || to_char(p_termination_date));

Line 5397: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header()');

5393:
5394: -- Lock the contract header
5395: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5396: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5397: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header()');
5398: END IF;
5399: -- Lock the contract header
5400: Lock_Contract_Header(
5401: p_contract_id => p_contract_id,

Line 5407: 'OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header return status is: '

5403: x_return_status => x_return_status
5404: );
5405: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5406: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
5407: 'OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header return status is: '
5408: || x_return_status);
5409: END IF;
5410: -----------------------------------------------------
5411: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 5535: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.terminate_contract');

5531: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
5532:
5533: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5534: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5535: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.terminate_contract');
5536: END IF;
5537:
5538:
5539: EXCEPTION

Line 5689: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.repository_notifier');

5685:
5686: BEGIN
5687: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5688: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5689: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.repository_notifier');
5690: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5691: 'Contract Id is: ' || p_contract_id);
5692: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5693: 'Contract Number is: ' || p_contract_number);

Line 6009: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.repository_notifier');

6005: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6006: FND_LOG.STRING(
6007: FND_LOG.LEVEL_PROCEDURE,
6008: G_MODULE||l_api_name,
6009: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.repository_notifier');
6010: END IF;
6011:
6012:
6013: EXCEPTION

Line 6138: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.cancel_approval');

6134: BEGIN
6135:
6136: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6137: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6138: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.cancel_approval');
6139: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6140: 'Contract Id is: ' || p_contract_id);
6141: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6142: 'Contract Version is: ' || p_contract_version);

Line 6305: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.cancel_approval');

6301: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
6302:
6303: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6304: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6305: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.cancel_approval');
6306: END IF;
6307:
6308: EXCEPTION
6309: WHEN FND_API.G_EXC_ERROR THEN

Line 6450: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.get_next_contract_number');

6446: BEGIN
6447:
6448: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6449: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6450: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.get_next_contract_number');
6451: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6452: 'Org Id is: ' || p_org_id);
6453: END IF;
6454: l_api_name := 'get_next_contract_number';

Line 6573: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.get_next_contract_number');

6569: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
6570:
6571: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6572: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6573: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.get_next_contract_number');
6574: END IF;
6575:
6576: EXCEPTION
6577: WHEN FND_API.G_EXC_ERROR THEN

Line 6688: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_uda_attribute_values');

6684: BEGIN
6685:
6686: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6687: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6688: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_uda_attribute_values');
6689: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
6690: 'Contract Id is: ' || to_char(p_contract_id));
6691: END IF;
6692: l_api_name := 'delete_uda_attribute_values';

Line 7070: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_uda_attribute_values');

7066: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
7067:
7068: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7069: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7070: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_uda_attribute_values');
7071: END IF;
7072:
7073:
7074: EXCEPTION

Line 7179: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_uda_attribute_values');

7175: BEGIN
7176:
7177: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7178: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7179: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_uda_attribute_values');
7180: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7181: 'Source Contract Id is: ' || p_source_contract_id);
7182: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7183: 'Target Contract Id is: ' || p_target_contract_id);

Line 7318: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_uda_attribute_values');

7314: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
7315:
7316: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7317: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7318: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_uda_attribute_values');
7319: END IF;
7320:
7321:
7322: EXCEPTION

Line 7416: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.version_uda_attribute_values');

7412: BEGIN
7413:
7414: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7415: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7416: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.version_uda_attribute_values');
7417: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7418: 'Contract Id is: ' || to_char(p_contract_id));
7419: END IF;
7420: l_api_name := 'version_uda_attribute_values';

Line 7785: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.version_uda_attribute_values');

7781: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
7782:
7783: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7784: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
7785: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.version_uda_attribute_values');
7786: END IF;
7787:
7788:
7789: EXCEPTION

Line 7854: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name, '100: Entered OKC_REP_CONTRACT_PROCESS_PVT.call_contract_preview_cp_yn');

7850: BEGIN
7851: l_api_name := 'call_contract_preview_cp_yn';
7852: l_return_status := 'N';
7853: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
7854: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name, '100: Entered OKC_REP_CONTRACT_PROCESS_PVT.call_contract_preview_cp_yn');
7855: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name, '100: p_contract_id is: ' || p_contract_id);
7856: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name, '100: p_contract_type is: ' || p_contract_type);
7857: END IF;
7858:

Line 7920: END OKC_REP_CONTRACT_PROCESS_PVT;

7916: END IF;
7917: RAISE;
7918: END call_contract_preview_cp_yn;
7919:
7920: END OKC_REP_CONTRACT_PROCESS_PVT;