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.OKL_UBB_INTEGRATION_PVT dependencies on OKC_API

Line 273: x_return_status := OKC_API.G_RET_STS_SUCCESS;

269: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'rgd: '||p_rgd_code);
270: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'info: '||p_rule_information_category);
271: END IF;
272:
273: x_return_status := OKC_API.G_RET_STS_SUCCESS;
274:
275: OPEN rulv_csr (p_rule_information_category,
276: p_rgd_code,
277: p_jtot_object1_code,

Line 356: x_return_status := OKC_API.G_RET_STS_ERROR;

352: WHEN rule_failed THEN
353: IF rulv_csr%ISOPEN THEN
354: CLOSE rulv_csr;
355: END IF;
356: x_return_status := OKC_API.G_RET_STS_ERROR;
357: okl_api.set_message(
358: G_APP_NAME,
359: G_OKL_RULE_ERROR
360: );

Line 363: x_return_status := OKC_API.G_RET_STS_ERROR;

359: G_OKL_RULE_ERROR
360: );
361:
362: WHEN OTHERS THEN
363: x_return_status := OKC_API.G_RET_STS_ERROR;
364: okl_api.set_message(
365: G_APP_NAME,
366: G_UNEXPECTED_ERROR,
367: 'OKL_SQLCODE',

Line 416: x_return_status := OKC_API.G_RET_STS_SUCCESS;

412: END IF;
413: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
414: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
415: END IF;
416: x_return_status := OKC_API.G_RET_STS_SUCCESS;
417:
418: OPEN party_csr (p_chr_id,
419: p_rle_code,
420: p_jtot_object1_code);

Line 432: x_return_status := OKC_API.G_RET_STS_SUCCESS;

428:
429: return;
430: EXCEPTION
431: WHEN party_failed THEN
432: x_return_status := OKC_API.G_RET_STS_SUCCESS;
433: IF party_csr%ISOPEN THEN
434: CLOSE party_csr;
435: END IF;
436:

Line 443: x_return_status := OKC_API.G_RET_STS_ERROR;

439: G_OKL_PARTY_ROLE_ERROR
440: );
441:
442: WHEN OTHERS THEN
443: x_return_status := OKC_API.G_RET_STS_ERROR;
444: okl_api.set_message(
445: G_APP_NAME,
446: G_UNEXPECTED_ERROR,
447: 'OKL_SQLCODE',

Line 497: x_return_status := OKC_API.G_RET_STS_SUCCESS;

493: END IF;
494: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
495: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
496: END IF;
497: x_return_status := OKC_API.G_RET_STS_SUCCESS;
498:
499: OPEN header_csr(p_chr_id);
500: FETCH header_csr INTO x_header_rec;
501: IF header_csr%NOTFOUND THEN

Line 511: x_return_status := OKC_API.G_RET_STS_ERROR;

507: WHEN header_failed THEN
508: IF header_csr%ISOPEN THEN
509: CLOSE header_csr;
510: END IF;
511: x_return_status := OKC_API.G_RET_STS_ERROR;
512: okl_api.set_message(
513: G_APP_NAME,
514: G_OKL_NO_CONTRACT_HEADER
515: );

Line 517: x_return_status := OKC_API.G_RET_STS_ERROR;

513: G_APP_NAME,
514: G_OKL_NO_CONTRACT_HEADER
515: );
516: WHEN OTHERS THEN
517: x_return_status := OKC_API.G_RET_STS_ERROR;
518: okl_api.set_message(
519: G_APP_NAME,
520: G_UNEXPECTED_ERROR,
521: 'OKL_SQLCODE',

Line 579: x_return_status := OKC_API.G_RET_STS_ERROR;

575: RETURN;
576:
577: EXCEPTION
578: WHEN OTHERS THEN
579: x_return_status := OKC_API.G_RET_STS_ERROR;
580: okl_api.set_message(
581: G_APP_NAME,
582: G_UNEXPECTED_ERROR,
583: 'OKL_SQLCODE',

Line 655: x_return_status := OKC_API.G_RET_STS_ERROR;

651: G_OKL_RULE_ERROR
652: );
653:
654: WHEN OTHERS THEN
655: x_return_status := OKC_API.G_RET_STS_ERROR;
656: okl_api.set_message(
657: G_APP_NAME,
658: G_UNEXPECTED_ERROR,
659: 'OKL_SQLCODE',

Line 730: x_return_status := OKC_API.G_RET_STS_ERROR;

726: G_OKL_RULE_ERROR
727: );
728:
729: WHEN OTHERS THEN
730: x_return_status := OKC_API.G_RET_STS_ERROR;
731: okl_api.set_message(
732: G_APP_NAME,
733: G_UNEXPECTED_ERROR,
734: 'OKL_SQLCODE',

Line 793: x_return_status := OKC_API.G_RET_STS_SUCCESS;

789: END IF;
790: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
791: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
792: END IF;
793: x_return_status := OKC_API.G_RET_STS_SUCCESS;
794:
795: x_oks_header_rec.contract_number := p_header_rec.contract_number||'-OKL';
796: x_oks_header_rec.start_date := p_header_rec.start_date;
797: x_oks_header_rec.end_date := p_header_rec.end_date; -- + 1; -- To match with OKS bill Schedule dates

Line 883: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

879: p_jtot_object1_code => 'OKX_PARTY',
880: x_party_id => x_party_id
881: );
882:
883: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
884: RAISE header_failed;
885: END IF;
886:
887: x_oks_header_rec.party_id := x_party_id;

Line 911: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

907: p_chr_id => p_header_rec.id,
908: x_bill_to_id => l_bill_to_id
909: );
910:
911: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
912: RAISE header_failed;
913: END IF;
914:
915: --debug_message('Bill to object1_id1 : '||x_rulv_rec.object1_id1);

Line 939: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

935: p_chr_id => p_header_rec.id,
936: p_cle_id => NULL,
937: x_rulv_rec => x_rulv_rec
938: );
939: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
940: RAISE header_failed;
941: END IF;
942:
943: x_oks_header_rec.price_list_id := x_rulv_rec.object2_id1;

Line 947: x_return_status := OKC_API.G_RET_STS_ERROR;

943: x_oks_header_rec.price_list_id := x_rulv_rec.object2_id1;
944:
945: EXCEPTION
946: WHEN header_failed THEN
947: x_return_status := OKC_API.G_RET_STS_ERROR;
948:
949: WHEN OTHERS THEN
950: x_return_status := OKC_API.G_RET_STS_ERROR;
951: okl_api.set_message(

Line 950: x_return_status := OKC_API.G_RET_STS_ERROR;

946: WHEN header_failed THEN
947: x_return_status := OKC_API.G_RET_STS_ERROR;
948:
949: WHEN OTHERS THEN
950: x_return_status := OKC_API.G_RET_STS_ERROR;
951: okl_api.set_message(
952: G_APP_NAME,
953: G_UNEXPECTED_ERROR,
954: 'OKL_SQLCODE',

Line 1026: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1022:
1023: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1024: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1025: END IF;
1026: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1027:
1028: get_contract_header(
1029: x_return_status => x_return_status,
1030: x_msg_count => x_msg_count,

Line 1036: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1032: p_chr_id => p_header_id,
1033: x_header_rec => x_oks_header_rec
1034: );
1035:
1036: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1037: RAISE line_failed;
1038: END IF;
1039:
1040: IF (p_oks_header_id IS NOT NULL) THEN

Line 1100: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1096: p_chr_id => NULL,
1097: p_cle_id => p_line_rec.id,
1098: x_rulv_rec => x_rulv_rec
1099: );
1100: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1101: RAISE line_failed;
1102: END IF;
1103:
1104: x_usage_item_id := x_rulv_rec.object1_id1; -- Required to get Counter later

Line 1151: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1147: p_jtot_object1_code => 'OKX_PARTY',
1148: x_party_id => x_party_id
1149: );
1150:
1151: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1152: RAISE line_failed;
1153: END IF;
1154:
1155: x_oks_line_rec.customer_id := x_party_id;

Line 1180: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1176: p_chr_id => p_header_id,
1177: x_cust_acc_id => l_cust_acc_id
1178: );
1179:
1180: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1181: RAISE line_failed;
1182: END IF;
1183:
1184: --x_oks_line_rec.cust_account := x_rulv_rec.object1_id1;

Line 1210: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1206: p_chr_id => p_header_id,
1207: x_bill_to_id => l_bill_to_id
1208: );
1209:
1210: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1211: RAISE line_failed;
1212: END IF;
1213:
1214: --x_oks_line_rec.bill_to_id := x_rulv_rec.object1_id1;

Line 1230: x_return_status := OKC_API.G_RET_STS_ERROR;

1226: IF ra_rule_csr%ISOPEN THEN
1227: CLOSE ra_rule_csr;
1228: END IF;
1229: */
1230: x_return_status := OKC_API.G_RET_STS_ERROR;
1231:
1232: WHEN OTHERS THEN
1233: x_return_status := OKC_API.G_RET_STS_ERROR;
1234: okl_api.set_message(

Line 1233: x_return_status := OKC_API.G_RET_STS_ERROR;

1229: */
1230: x_return_status := OKC_API.G_RET_STS_ERROR;
1231:
1232: WHEN OTHERS THEN
1233: x_return_status := OKC_API.G_RET_STS_ERROR;
1234: okl_api.set_message(
1235: G_APP_NAME,
1236: G_UNEXPECTED_ERROR,
1237: 'OKL_SQLCODE',

Line 1279: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1275: END IF;
1276: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1277: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1278: END IF;
1279: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1280:
1281: IF (p_oks_header_id IS NOT NULL) THEN
1282: x_oks_covered_rec.k_id := p_oks_header_id;
1283: END IF;

Line 1301: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1297: p_chr_id => NULL,
1298: p_cle_id => p_usage_line_id,
1299: x_rulv_rec => x_rulv_rec
1300: );
1301: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1302: RAISE covered_failed;
1303: END IF;
1304:
1305: x_oks_covered_rec.customer_product_id := p_counter_id;

Line 1326: x_return_status := OKC_API.G_RET_STS_ERROR;

1322:
1323: EXCEPTION
1324:
1325: WHEN covered_failed THEN
1326: x_return_status := OKC_API.G_RET_STS_ERROR;
1327:
1328: WHEN OTHERS THEN
1329: x_return_status := OKC_API.G_RET_STS_ERROR;
1330: okl_api.set_message(

Line 1329: x_return_status := OKC_API.G_RET_STS_ERROR;

1325: WHEN covered_failed THEN
1326: x_return_status := OKC_API.G_RET_STS_ERROR;
1327:
1328: WHEN OTHERS THEN
1329: x_return_status := OKC_API.G_RET_STS_ERROR;
1330: okl_api.set_message(
1331: G_APP_NAME,
1332: G_UNEXPECTED_ERROR,
1333: 'OKL_SQLCODE',

Line 1380: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1376: END IF;
1377: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1378: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1379: END IF;
1380: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1381:
1382: OPEN top_csr(p_chr_id,
1383: p_link_asset_line_id);
1384: FETCH top_csr INTO l_id;

Line 1397: x_return_status := OKC_API.G_RET_STS_ERROR;

1393: WHEN top_failed THEN
1394: IF top_csr%ISOPEN THEN
1395: CLOSE top_csr;
1396: END IF;
1397: x_return_status := OKC_API.G_RET_STS_ERROR;
1398: okl_api.set_message(
1399: G_APP_NAME,
1400: G_OKL_NO_TOP_LINE,
1401: 'LINE_NUM',

Line 1405: x_return_status := OKC_API.G_RET_STS_ERROR;

1401: 'LINE_NUM',
1402: p_link_asset_line_no
1403: );
1404: WHEN OTHERS THEN
1405: x_return_status := OKC_API.G_RET_STS_ERROR;
1406: okl_api.set_message(
1407: G_APP_NAME,
1408: G_UNEXPECTED_ERROR,
1409: 'OKL_SQLCODE',

Line 1611: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1607:
1608: l_proc_name VARCHAR2(35) := 'CREATE_UBB_CONTRACT';
1609: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_UBB_CONTRACT';
1610: l_api_version CONSTANT NUMBER := 1;
1611: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1612:
1613: x_top_line_id OKC_K_LINES_V.ID%TYPE;
1614: x_usage_item_id CS_COUNTERS.USAGE_ITEM_ID%TYPE;
1615:

Line 1675: x_return_status := OKC_API.START_ACTIVITY(

1671: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
1672: END IF;
1673: -- call START_ACTIVITY to create savepoint, check compatibility
1674: -- and initialize message list
1675: x_return_status := OKC_API.START_ACTIVITY(
1676: p_api_name => l_api_name,
1677: p_pkg_name => G_PKG_NAME,
1678: p_init_msg_list => p_init_msg_list,
1679: l_api_version => l_api_version,

Line 1685: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1681: p_api_type => G_API_TYPE,
1682: x_return_status => x_return_status);
1683:
1684: -- check if activity started successfully
1685: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1686: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1687: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
1688: raise OKC_API.G_EXCEPTION_ERROR;
1689: END IF;

Line 1686: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1682: x_return_status => x_return_status);
1683:
1684: -- check if activity started successfully
1685: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1686: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1687: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
1688: raise OKC_API.G_EXCEPTION_ERROR;
1689: END IF;
1690:

Line 1687: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then

1683:
1684: -- check if activity started successfully
1685: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1686: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1687: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
1688: raise OKC_API.G_EXCEPTION_ERROR;
1689: END IF;
1690:
1691: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Line 1688: raise OKC_API.G_EXCEPTION_ERROR;

1684: -- check if activity started successfully
1685: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1686: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1687: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
1688: raise OKC_API.G_EXCEPTION_ERROR;
1689: END IF;
1690:
1691: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1692:

Line 1705: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1701: p_chr_id => p_chr_id,
1702: x_header_rec => x_header_rec
1703: );
1704:
1705: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1706: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1707: END IF;
1708: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1709: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'STS Code : '||x_header_rec.sts_code);

Line 1706: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1702: x_header_rec => x_header_rec
1703: );
1704:
1705: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1706: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1707: END IF;
1708: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1709: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'STS Code : '||x_header_rec.sts_code);
1710: END IF;

Line 1721: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1717: p_header_rec => x_header_rec,
1718: x_oks_header_rec => l_oks_header_rec
1719: );
1720:
1721: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1722: RAISE OKC_API.G_EXCEPTION_ERROR;
1723: END IF;
1724: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1725: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'STS Code : '||l_oks_header_rec.sts_code);

Line 1722: RAISE OKC_API.G_EXCEPTION_ERROR;

1718: x_oks_header_rec => l_oks_header_rec
1719: );
1720:
1721: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1722: RAISE OKC_API.G_EXCEPTION_ERROR;
1723: END IF;
1724: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1725: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'STS Code : '||l_oks_header_rec.sts_code);
1726: END IF;

Line 1743: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1739: x_msg_count => x_msg_count,
1740: x_msg_data => x_msg_data
1741: );
1742:
1743: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1744: RAISE OKC_API.G_EXCEPTION_ERROR;
1745: END IF;
1746:
1747: x_chr_id := x_oks_chr_id;

Line 1744: RAISE OKC_API.G_EXCEPTION_ERROR;

1740: x_msg_data => x_msg_data
1741: );
1742:
1743: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1744: RAISE OKC_API.G_EXCEPTION_ERROR;
1745: END IF;
1746:
1747: x_chr_id := x_oks_chr_id;
1748: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1775: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1771: x_usage_item_id => l_usage_item_id,
1772: x_oks_line_rec => l_oks_line_rec
1773: );
1774:
1775: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1776: RAISE OKC_API.G_EXCEPTION_ERROR;
1777: END IF;
1778:
1779: --

Line 1776: RAISE OKC_API.G_EXCEPTION_ERROR;

1772: x_oks_line_rec => l_oks_line_rec
1773: );
1774:
1775: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1776: RAISE OKC_API.G_EXCEPTION_ERROR;
1777: END IF;
1778:
1779: --
1780: -- Defaults from Contract Header

Line 1797: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1793: x_msg_count => x_msg_count,
1794: x_msg_data => x_msg_data
1795: );
1796:
1797: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1798: RAISE OKC_API.G_EXCEPTION_ERROR;
1799: END IF;
1800:
1801: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1798: RAISE OKC_API.G_EXCEPTION_ERROR;

1794: x_msg_data => x_msg_data
1795: );
1796:
1797: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1798: RAISE OKC_API.G_EXCEPTION_ERROR;
1799: END IF;
1800:
1801: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1802: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'OKS Usage Line ID: '||x_oks_usage_line_id);

Line 1820: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1816: p_link_asset_line_id => link_asset_rec.id,
1817: p_link_asset_line_no => link_asset_rec.line_number,
1818: x_top_line_id => x_top_line_id
1819: );
1820: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1821: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1822: END IF;
1823:
1824: l_ib_count := 0;

Line 1821: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1817: p_link_asset_line_no => link_asset_rec.line_number,
1818: x_top_line_id => x_top_line_id
1819: );
1820: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1821: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1822: END IF;
1823:
1824: l_ib_count := 0;
1825: FOR ib_rec IN ib_csr(p_chr_id,

Line 1854: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1850: p_header_rec => x_header_rec,
1851: x_oks_covered_rec => l_oks_covered_level_rec
1852: );
1853:
1854: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1855: RAISE OKC_API.G_EXCEPTION_ERROR;
1856: END IF;
1857:
1858: l_oks_covered_level_rec.currency_code := x_header_rec.currency_code;

Line 1855: RAISE OKC_API.G_EXCEPTION_ERROR;

1851: x_oks_covered_rec => l_oks_covered_level_rec
1852: );
1853:
1854: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1855: RAISE OKC_API.G_EXCEPTION_ERROR;
1856: END IF;
1857:
1858: l_oks_covered_level_rec.currency_code := x_header_rec.currency_code;
1859: l_oks_covered_level_rec.product_end_date := ADD_MONTHS(x_header_rec.start_date, x_header_rec.term_duration) - 1;

Line 1873: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1869: x_return_status => x_return_status,
1870: x_msg_count => x_msg_count,
1871: x_msg_data => x_msg_data
1872: );
1873: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1874: RAISE OKC_API.G_EXCEPTION_ERROR;
1875: END IF;
1876: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1877: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After covered line');

Line 1874: RAISE OKC_API.G_EXCEPTION_ERROR;

1870: x_msg_count => x_msg_count,
1871: x_msg_data => x_msg_data
1872: );
1873: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1874: RAISE OKC_API.G_EXCEPTION_ERROR;
1875: END IF;
1876: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1877: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After covered line');
1878: END IF;

Line 1931: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1927: p_cle_id => g_usage_rec.id,
1928: x_rulv_rec => x_rulv_rec
1929: );
1930:
1931: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1932: RAISE OKC_API.G_EXCEPTION_ERROR;
1933: END IF;
1934:
1935: l_oks_ver := '?';

Line 1932: RAISE OKC_API.G_EXCEPTION_ERROR;

1928: x_rulv_rec => x_rulv_rec
1929: );
1930:
1931: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1932: RAISE OKC_API.G_EXCEPTION_ERROR;
1933: END IF;
1934:
1935: l_oks_ver := '?';
1936: OPEN check_oks_ver;

Line 1969: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1965: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1966: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Bill Status : '||x_return_status);
1967: END IF;
1968:
1969: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1970: RAISE OKC_API.G_EXCEPTION_ERROR;
1971: END IF;
1972:
1973: ELSE -- oks_ver = 9

Line 1970: RAISE OKC_API.G_EXCEPTION_ERROR;

1966: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Bill Status : '||x_return_status);
1967: END IF;
1968:
1969: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1970: RAISE OKC_API.G_EXCEPTION_ERROR;
1971: END IF;
1972:
1973: ELSE -- oks_ver = 9
1974:

Line 2002: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1998: okl_api.set_message(
1999: G_APP_NAME,
2000: G_OKL_NO_LINK_ASSET_LINE
2001: );
2002: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2003: END IF;
2004:
2005: IF (l_ib_count = 0) THEN
2006: okl_api.set_message(

Line 2010: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2006: okl_api.set_message(
2007: G_APP_NAME,
2008: G_OKL_NO_IB_LINE
2009: );
2010: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2011: END IF;
2012:
2013: IF (l_counter_count = 0) THEN
2014: okl_api.set_message(

Line 2018: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2014: okl_api.set_message(
2015: G_APP_NAME,
2016: G_OKL_NO_COUNTER_INSTANCE
2017: );
2018: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2019: END IF;
2020:
2021: -- Link OKS Usage line with that of OKL
2022: link_oks_line(

Line 2031: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

2027: p_okl_usage_line_id => usage_rec.id, -- OKL Usage Line ID
2028: p_oks_usage_line_id => x_oks_usage_line_id -- OKS Usage Line ID
2029: );
2030:
2031: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2032: RAISE OKC_API.G_EXCEPTION_ERROR;
2033: END IF;
2034:
2035: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 2032: RAISE OKC_API.G_EXCEPTION_ERROR;

2028: p_oks_usage_line_id => x_oks_usage_line_id -- OKS Usage Line ID
2029: );
2030:
2031: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2032: RAISE OKC_API.G_EXCEPTION_ERROR;
2033: END IF;
2034:
2035: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2036: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Link Line Done');

Line 2050: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

2046: x_msg_data => x_msg_data,
2047: p_okl_usage_line_id => usage_rec.id,
2048: p_oks_usage_line_id => x_oks_usage_line_id);
2049:
2050: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2051: RAISE OKC_API.G_EXCEPTION_ERROR;
2052: END IF;
2053:
2054: END LOOP; -- usage_csr

Line 2051: RAISE OKC_API.G_EXCEPTION_ERROR;

2047: p_okl_usage_line_id => usage_rec.id,
2048: p_oks_usage_line_id => x_oks_usage_line_id);
2049:
2050: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2051: RAISE OKC_API.G_EXCEPTION_ERROR;
2052: END IF;
2053:
2054: END LOOP; -- usage_csr
2055:

Line 2063: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2059: okl_api.set_message(
2060: G_APP_NAME,
2061: G_OKL_NO_USAGE_LINE
2062: );
2063: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2064: END IF;
2065:
2066:
2067: -- Link OKS Header, create above, with that of OKL

Line 2076: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

2072: p_okl_header_id => p_chr_id,
2073: p_oks_header_id => x_chr_id
2074: );
2075:
2076: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2077: RAISE OKC_API.G_EXCEPTION_ERROR;
2078: END IF;
2079: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2080: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Link Header Done');

Line 2077: RAISE OKC_API.G_EXCEPTION_ERROR;

2073: p_oks_header_id => x_chr_id
2074: );
2075:
2076: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2077: RAISE OKC_API.G_EXCEPTION_ERROR;
2078: END IF;
2079: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2080: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Link Header Done');
2081: END IF;

Line 2086: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,

2082:
2083:
2084: -- End activity
2085:
2086: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
2087: x_msg_data => x_msg_data);
2088:
2089: Exception
2090: when OKC_API.G_EXCEPTION_ERROR then

Line 2090: when OKC_API.G_EXCEPTION_ERROR then

2086: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count,
2087: x_msg_data => x_msg_data);
2088:
2089: Exception
2090: when OKC_API.G_EXCEPTION_ERROR then
2091:
2092: IF counter_csr%ISOPEN THEN
2093: CLOSE counter_csr;
2094: END IF;

Line 2096: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

2092: IF counter_csr%ISOPEN THEN
2093: CLOSE counter_csr;
2094: END IF;
2095:
2096: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2097: p_api_name => l_api_name,
2098: p_pkg_name => G_PKG_NAME,
2099: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
2100: x_msg_count => x_msg_count,

Line 2099: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

2095:
2096: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2097: p_api_name => l_api_name,
2098: p_pkg_name => G_PKG_NAME,
2099: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
2100: x_msg_count => x_msg_count,
2101: x_msg_data => x_msg_data,
2102: p_api_type => G_API_TYPE);
2103:

Line 2105: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

2101: x_msg_data => x_msg_data,
2102: p_api_type => G_API_TYPE);
2103:
2104:
2105: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
2106:
2107: IF counter_csr%ISOPEN THEN
2108: CLOSE counter_csr;
2109: END IF;

Line 2111: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

2107: IF counter_csr%ISOPEN THEN
2108: CLOSE counter_csr;
2109: END IF;
2110:
2111: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2112: p_api_name => l_api_name,
2113: p_pkg_name => G_PKG_NAME,
2114: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
2115: x_msg_count => x_msg_count,

Line 2114: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

2110:
2111: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2112: p_api_name => l_api_name,
2113: p_pkg_name => G_PKG_NAME,
2114: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
2115: x_msg_count => x_msg_count,
2116: x_msg_data => x_msg_data,
2117: p_api_type => G_API_TYPE);
2118:

Line 2125: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

2121: IF counter_csr%ISOPEN THEN
2122: CLOSE counter_csr;
2123: END IF;
2124:
2125: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2126: p_api_name => l_api_name,
2127: p_pkg_name => G_PKG_NAME,
2128: p_exc_name => 'OTHERS',
2129: x_msg_count => x_msg_count,

Line 2163: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2159: END IF;
2160: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2161: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
2162: END IF;
2163: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2164:
2165: l_crjv_rec.chr_id := p_okl_header_id;
2166: l_crjv_rec.rty_code := 'OKLUBB';
2167: l_crjv_rec.object1_id1 := p_oks_header_id;

Line 2173: p_init_msg_list => OKC_API.G_FALSE,

2169: l_crjv_rec.jtot_object1_code := 'OKL_SERVICE';
2170:
2171: OKC_K_REL_OBJS_PUB.create_row (
2172: p_api_version => 1.0,
2173: p_init_msg_list => OKC_API.G_FALSE,
2174: x_return_status => x_return_status,
2175: x_msg_count => x_msg_count,
2176: x_msg_data => x_msg_data,
2177: p_crjv_rec => l_crjv_rec,

Line 2181: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

2177: p_crjv_rec => l_crjv_rec,
2178: x_crjv_rec => x_crjv_rec
2179: );
2180:
2181: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2182: RAISE oks_header_failed;
2183: END IF;
2184:
2185: EXCEPTION

Line 2187: x_return_status := OKC_API.G_RET_STS_ERROR;

2183: END IF;
2184:
2185: EXCEPTION
2186: WHEN oks_header_failed THEN
2187: x_return_status := OKC_API.G_RET_STS_ERROR;
2188:
2189: WHEN OTHERS THEN
2190: x_return_status := OKC_API.G_RET_STS_ERROR;
2191: okl_api.set_message(

Line 2190: x_return_status := OKC_API.G_RET_STS_ERROR;

2186: WHEN oks_header_failed THEN
2187: x_return_status := OKC_API.G_RET_STS_ERROR;
2188:
2189: WHEN OTHERS THEN
2190: x_return_status := OKC_API.G_RET_STS_ERROR;
2191: okl_api.set_message(
2192: G_APP_NAME,
2193: G_UNEXPECTED_ERROR,
2194: 'OKL_SQLCODE',

Line 2236: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2232: IF (G_DEBUG_ENABLED = 'Y') THEN
2233: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2234: END IF;
2235:
2236: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2237: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2238: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
2239: END IF;
2240:

Line 2262: p_init_msg_list => OKC_API.G_FALSE,

2258: ----- Changes by Kanti
2259: ----- Validate the JTOT Object code, ID1 and ID2
2260:
2261: okl_la_validation_util_pvt.VALIDATE_STYLE_JTOT (p_api_version => 1.0,
2262: p_init_msg_list => OKC_API.G_FALSE,
2263: x_return_status => x_return_status,
2264: x_msg_count => x_msg_count,
2265: x_msg_data => x_msg_data,
2266: p_object_name => l_cimv_rec.jtot_object1_code,

Line 2270: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

2266: p_object_name => l_cimv_rec.jtot_object1_code,
2267: p_id1 => l_cimv_rec.object1_id1,
2268: p_id2 => l_cimv_rec.object1_id2);
2269:
2270: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2271: RAISE oks_line_failed;
2272: END IF;
2273:
2274: ---- Changes End

Line 2278: p_init_msg_list => OKC_API.G_FALSE,

2274: ---- Changes End
2275:
2276: OKC_CONTRACT_ITEM_PUB.update_contract_item(
2277: p_api_version => 1.0,
2278: p_init_msg_list => OKC_API.G_FALSE,
2279: x_return_status => x_return_status,
2280: x_msg_count => x_msg_count,
2281: x_msg_data => x_msg_data,
2282: p_cimv_rec => l_cimv_rec,

Line 2286: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

2282: p_cimv_rec => l_cimv_rec,
2283: x_cimv_rec => x_cimv_rec
2284: );
2285:
2286: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2287: RAISE oks_line_failed;
2288: END IF;
2289:
2290: EXCEPTION

Line 2298: x_return_status := OKC_API.G_RET_STS_ERROR;

2294: IF item_csr%ISOPEN THEN
2295: CLOSE item_csr;
2296: END IF;
2297:
2298: x_return_status := OKC_API.G_RET_STS_ERROR;
2299:
2300: WHEN OTHERS THEN
2301: x_return_status := OKC_API.G_RET_STS_ERROR;
2302: okl_api.set_message(

Line 2301: x_return_status := OKC_API.G_RET_STS_ERROR;

2297:
2298: x_return_status := OKC_API.G_RET_STS_ERROR;
2299:
2300: WHEN OTHERS THEN
2301: x_return_status := OKC_API.G_RET_STS_ERROR;
2302: okl_api.set_message(
2303: G_APP_NAME,
2304: G_UNEXPECTED_ERROR,
2305: 'OKL_SQLCODE',