DBA Data[Home] [Help]

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.15 2008/04/15 05:46:51 kkolukul ship $ */
3:
4: ---------------------------------------------------------------------------
5: -- GLOBAL CONSTANTS

Line 331: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_contacts');

327: BEGIN
328:
329: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
330: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
331: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_contacts');
332: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
333: 'Contract Id is: ' || to_char(p_contract_id));
334: END IF;
335: l_api_name := 'delete_contacts';

Line 365: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_contacts');

361: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
362:
363: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
364: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
365: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_contacts');
366: END IF;
367:
368:
369: EXCEPTION

Line 450: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_parties');

446: BEGIN
447:
448: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
449: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
450: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_parties');
451: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
452: 'Contract Id is: ' || p_contract_id);
453: END IF;
454: l_api_name := 'delete_parties';

Line 484: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_parties');

480: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
481:
482: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
483: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
484: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_parties');
485: END IF;
486:
487:
488: EXCEPTION

Line 577: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_risks');

573: BEGIN
574:
575: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
576: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
577: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_risks');
578: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
579: 'Contract Id is: ' || p_contract_id);
580: END IF;
581: l_api_name := 'delete_risks';

Line 629: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_risks');

625: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
626:
627: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
628: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
629: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_risks');
630: END IF;
631:
632:
633: EXCEPTION

Line 726: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_related_contracts');

722: BEGIN
723:
724: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
725: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
726: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_related_contracts');
727: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
728: 'Contract Id is: ' || p_contract_id);
729: END IF;
730: l_api_name := 'delete_related_contracts';

Line 760: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_related_contracts');

756: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
757:
758: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
759: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
760: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_related_contracts');
761: END IF;
762:
763:
764: EXCEPTION

Line 863: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_ACL');

859: BEGIN
860:
861: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
862: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
863: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_ACL');
864: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
865: 'Contract Id is: ' || p_contract_id);
866: END IF;
867: l_api_name := 'delete_ACL';

Line 931: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_ACL');

927: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
928:
929: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
930: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
931: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_ACL');
932: END IF;
933:
934:
935: EXCEPTION

Line 1030: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_status_history');

1026: BEGIN
1027:
1028: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1029: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1030: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_status_history');
1031: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1032: 'Contract Id is: ' || to_char(p_contract_id));
1033: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1034: 'Contract Version is: ' || to_char(p_contract_version));

Line 1067: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_status_history');

1063: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
1064:
1065: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1066: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1067: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_status_history');
1068: END IF;
1069:
1070:
1071: EXCEPTION

Line 1159: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_approval_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_approval_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_approval_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_approval_history');
1197: END IF;
1198:
1199:
1200: EXCEPTION

Line 1284: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_bookmarks');

1280: BEGIN
1281:
1282: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1283: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1284: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_bookmarks');
1285: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1286: 'Contract Id is: ' || p_contract_id);
1287: END IF;
1288: l_api_name := 'delete_bookmarks';

Line 1322: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_bookmarks');

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

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

1401: BEGIN
1402:
1403: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1404: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1405: 'Entered Function OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header');
1406: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1407: 'Contract Id is: ' || p_contract_id);
1408: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1409: 'Object Version is: ' || p_object_version_number);

Line 1518: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header');

1514: BEGIN
1515: l_api_name := 'Lock_Contract_header';
1516: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1517: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1518: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header');
1519: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1520: 'Contract Id is: ' || p_contract_id);
1521: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1522: 'Object Version is: ' || p_object_version_number);

Line 1630: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_contract');

1626: BEGIN
1627:
1628: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1629: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1630: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.delete_contract');
1631: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
1632: 'Contract Id is: ' || p_contract_id);
1633: END IF;
1634: l_api_name := 'delete_contract';

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

1648: x_return_status := FND_API.G_RET_STS_SUCCESS;
1649:
1650: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1651: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1652: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header()');
1653: END IF;
1654: -- Lock the contract header
1655: Lock_Contract_Header(
1656: p_contract_id => p_contract_id,

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

1658: x_return_status => x_return_status
1659: );
1660: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1661: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1662: 'OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header return status is: '
1663: || x_return_status);
1664: END IF;
1665: -----------------------------------------------------
1666: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1691:
1692: if (contract_rec.contract_version_num = 1) THEN
1693: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1694: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1695: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.delete_contacts()');
1696: END IF;
1697: delete_contacts(
1698: p_api_version => 1.0,
1699: p_commit => FND_API.G_FALSE,

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

1703: x_msg_count => x_msg_count,
1704: x_return_status => x_return_status);
1705: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1706: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1707: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_contacts return status is: '
1708: || x_return_status);
1709: END IF;
1710: -----------------------------------------------------
1711: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1717:
1718:
1719: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1720: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1721: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.delete_parties()');
1722: END IF;
1723: delete_parties(
1724: p_api_version => 1.0,
1725: p_init_msg_list => FND_API.G_FALSE,

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

1729: x_msg_count => x_msg_count,
1730: x_return_status => x_return_status);
1731: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1732: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1733: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_parties return status is: '
1734: || x_return_status);
1735: END IF;
1736: -----------------------------------------------------
1737: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1743:
1744:
1745: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1746: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1747: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.delete_risks()');
1748: END IF;
1749: delete_risks(
1750: p_api_version => 1.0,
1751: p_init_msg_list => FND_API.G_FALSE,

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

1755: x_msg_count => x_msg_count,
1756: x_return_status => x_return_status);
1757: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1758: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1759: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_risks return status is: '
1760: || x_return_status);
1761: END IF;
1762: -----------------------------------------------------
1763: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1769:
1770:
1771: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1772: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1773: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.delete_ACL()');
1774: END IF;
1775: delete_ACL(
1776: p_api_version => 1.0,
1777: p_init_msg_list => FND_API.G_FALSE,

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

1781: x_msg_count => x_msg_count,
1782: x_return_status => x_return_status);
1783: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1784: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1785: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_ACL return status is: '
1786: || x_return_status);
1787: END IF;
1788: -----------------------------------------------------
1789: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1795:
1796:
1797: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1798: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1799: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.delete_related_contracts()');
1800: END IF;
1801: delete_related_contracts(
1802: p_api_version => 1.0,
1803: p_init_msg_list => FND_API.G_FALSE,

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

1807: x_msg_count => x_msg_count,
1808: x_return_status => x_return_status);
1809: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1810: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
1811: 'OKC_REP_CONTRACT_PROCESS_PVT.delete_related_contracts return status is: '
1812: || x_return_status);
1813: END IF;
1814: -----------------------------------------------------
1815: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

1821:
1822:
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_status_history()');
1826: END IF;
1827: delete_status_history(
1828: p_api_version => 1.0,
1829: p_init_msg_list => FND_API.G_FALSE,

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

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

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

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

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

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

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

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

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

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

Line 2245: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_contract');

2241: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2242:
2243: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2244: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2245: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.delete_contract');
2246: END IF;
2247:
2248:
2249: EXCEPTION

Line 2356: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_contacts');

2352: BEGIN
2353:
2354: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2355: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2356: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_contacts');
2357: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2358: 'Source Contract Id is: ' || to_char(p_source_contract_id));
2359: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2360: 'Target Contract Id is: ' || to_char(p_target_contract_id));

Line 2432: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_contacts');

2428: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2429:
2430: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2431: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2432: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_contacts');
2433: END IF;
2434:
2435:
2436: EXCEPTION

Line 2531: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_parties');

2527: BEGIN
2528:
2529: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2530: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2531: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_parties');
2532: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2533: 'Source Contract Id is: ' || to_char(p_source_contract_id));
2534: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2535: 'Target Contract Id is: ' || to_char(p_target_contract_id));

Line 2602: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_parties');

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_parties');
2603: END IF;
2604:
2605:
2606: EXCEPTION

Line 2712: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_risks');

2708: BEGIN
2709:
2710: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2711: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2712: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_risks');
2713: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2714: 'Source Contract Id is: ' || to_char(p_source_contract_id));
2715: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2716: 'Target Contract Id is: ' || to_char(p_target_contract_id));

Line 2829: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_risks');

2825: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2826:
2827: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2828: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2829: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_risks');
2830: END IF;
2831:
2832:
2833: EXCEPTION

Line 2952: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_ACL');

2948: BEGIN
2949:
2950: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2951: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2952: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_ACL');
2953: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2954: 'Source Contract Id is: ' || p_source_contract_id);
2955: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2956: 'Target Contract Id is: ' || p_target_contract_id);

Line 3029: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_ACL');

3025: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
3026:
3027: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3028: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3029: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_ACL');
3030: END IF;
3031:
3032:
3033: EXCEPTION

Line 3148: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_contract_details');

3144: BEGIN
3145:
3146: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3147: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3148: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.copy_contract_details');
3149: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3150: 'Source Contract Id is: ' || p_source_contract_id);
3151: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3152: 'Target Contract Id is: ' || p_target_contract_id);

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

3170: x_return_status := FND_API.G_RET_STS_SUCCESS;
3171:
3172: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3173: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3174: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.copy_parties()');
3175: END IF;
3176: copy_parties(
3177: p_api_version => 1.0,
3178: p_init_msg_list => FND_API.G_FALSE,

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

3183: x_msg_count => x_msg_count,
3184: x_return_status => x_return_status);
3185: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3186: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3187: 'OKC_REP_CONTRACT_PROCESS_PVT.copy_parties return status is: '
3188: || x_return_status);
3189: END IF;
3190: ----------------------------------------------------
3191: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

3197:
3198:
3199: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3200: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3201: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.copy_contacts()');
3202: END IF;
3203: copy_contacts(
3204: p_api_version => 1.0,
3205: p_init_msg_list => FND_API.G_FALSE,

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

3210: x_msg_count => x_msg_count,
3211: x_return_status => x_return_status);
3212: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3213: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3214: 'OKC_REP_CONTRACT_PROCESS_PVT.copy_contacts return status is: '
3215: || x_return_status);
3216: END IF;
3217: -----------------------------------------------------
3218: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

3223: -----------------------------------------------------
3224:
3225: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3226: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3227: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.copy_risks()');
3228: END IF;
3229: copy_risks(
3230: p_api_version => 1.0,
3231: p_init_msg_list => FND_API.G_FALSE,

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

3236: x_msg_count => x_msg_count,
3237: x_return_status => x_return_status);
3238: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3239: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3240: 'OKC_REP_CONTRACT_PROCESS_PVT.copy_risks return status is: '
3241: || x_return_status);
3242: END IF;
3243: -----------------------------------------------------
3244: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

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

3249: --------------------------------------------------------
3250:
3251: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3252: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3253: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.copy_ACL()');
3254: END IF;
3255: copy_ACL(
3256: p_api_version => 1.0,
3257: p_init_msg_list => FND_API.G_FALSE,

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

3262: x_msg_count => x_msg_count,
3263: x_return_status => x_return_status);
3264: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3265: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3266: 'OKC_REP_CONTRACT_PROCESS_PVT.copy_ACL return status is: '
3267: || x_return_status);
3268: END IF;
3269: -----------------------------------------------------
3270: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3417: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_contract_details');

3413: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
3414:
3415: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3416: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3417: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.copy_contract_details');
3418: END IF;
3419:
3420:
3421: EXCEPTION

Line 3542: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.version_contract_details');

3538: BEGIN
3539:
3540: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3541: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3542: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.version_contract_details');
3543: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3544: 'Contract Id is: ' || p_contract_id);
3545: END IF;
3546: l_api_name := 'version_contract_details';

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

3561:
3562: -- Lock the contract header
3563: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3564: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3565: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header()');
3566: END IF;
3567: -- Lock the contract header
3568: Lock_Contract_Header(
3569: p_contract_id => p_contract_id,

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

3571: x_return_status => x_return_status
3572: );
3573: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3574: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
3575: 'OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header return status is: '
3576: || x_return_status);
3577: END IF;
3578: -----------------------------------------------------
3579: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 3913: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.version_contract_details');

3909: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
3910:
3911: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3912: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
3913: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.version_contract_details');
3914: END IF;
3915:
3916:
3917: EXCEPTION

Line 4037: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.sign_contract');

4033: l_effective_date_matches_flag := FND_API.G_FALSE;
4034:
4035: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4036: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4037: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.sign_contract');
4038: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4039: 'Contract Id is: ' || p_contract_id);
4040: END IF;
4041: l_api_name := 'sign_contacts';

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

4073:
4074: -- Lock the contract header
4075: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4076: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4077: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header()');
4078: END IF;
4079: -- Lock the contract header
4080: Lock_Contract_Header(
4081: p_contract_id => p_contract_id,

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

4083: x_return_status => x_return_status
4084: );
4085: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4086: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4087: 'OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header return status is: '
4088: || x_return_status);
4089: END IF;
4090: -----------------------------------------------------
4091: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4330: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.sign_contract');

4326: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4327:
4328: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4329: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4330: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.sign_contract');
4331: END IF;
4332:
4333:
4334: EXCEPTION

Line 4453: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.terminate_contract');

4449: BEGIN
4450:
4451: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4452: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4453: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.terminate_contract');
4454: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4455: 'Contract Id is: ' || p_contract_id);
4456: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4457: 'Termination date is: ' || to_char(p_termination_date));

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

4491:
4492: -- Lock the contract header
4493: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4494: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4495: 'Calling OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header()');
4496: END IF;
4497: -- Lock the contract header
4498: Lock_Contract_Header(
4499: p_contract_id => p_contract_id,

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

4501: x_return_status => x_return_status
4502: );
4503: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4504: FND_LOG.STRING( FND_LOG.LEVEL_STATEMENT ,G_MODULE||l_api_name,
4505: 'OKC_REP_CONTRACT_PROCESS_PVT.Lock_Contract_Header return status is: '
4506: || x_return_status);
4507: END IF;
4508: -----------------------------------------------------
4509: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 4633: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.terminate_contract');

4629: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4630:
4631: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4632: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4633: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.terminate_contract');
4634: END IF;
4635:
4636:
4637: EXCEPTION

Line 4777: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.repository_notifier');

4773:
4774: BEGIN
4775: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4776: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4777: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.repository_notifier');
4778: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4779: 'Contract Id is: ' || p_contract_id);
4780: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
4781: 'Contract Number is: ' || p_contract_number);

Line 5057: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.repository_notifier');

5053: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5054: FND_LOG.STRING(
5055: FND_LOG.LEVEL_PROCEDURE,
5056: G_MODULE||l_api_name,
5057: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.repository_notifier');
5058: END IF;
5059:
5060:
5061: EXCEPTION

Line 5181: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.cancel_approval');

5177: BEGIN
5178:
5179: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5180: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5181: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.cancel_approval');
5182: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5183: 'Contract Id is: ' || p_contract_id);
5184: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5185: 'Contract Version is: ' || p_contract_version);

Line 5322: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.cancel_approval');

5318: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
5319:
5320: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5321: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5322: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.cancel_approval');
5323: END IF;
5324:
5325: EXCEPTION
5326: WHEN FND_API.G_EXC_ERROR THEN

Line 5467: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.get_next_contract_number');

5463: BEGIN
5464:
5465: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5466: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5467: 'Entered OKC_REP_CONTRACT_PROCESS_PVT.get_next_contract_number');
5468: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5469: 'Org Id is: ' || p_org_id);
5470: END IF;
5471: l_api_name := 'get_next_contract_number';

Line 5589: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.get_next_contract_number');

5585: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
5586:
5587: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
5588: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
5589: 'Leaving OKC_REP_CONTRACT_PROCESS_PVT.get_next_contract_number');
5590: END IF;
5591:
5592: EXCEPTION
5593: WHEN FND_API.G_EXC_ERROR THEN

Line 5669: END OKC_REP_CONTRACT_PROCESS_PVT;

5665: END get_next_contract_number;
5666:
5667:
5668:
5669: END OKC_REP_CONTRACT_PROCESS_PVT;