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_QUOTE_TO_CONTRACT_PVT dependencies on OKC_API

Line 303: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

299: -- History : 28-Oct-2005 SKGAUTAM created
300: --
301: -- End of comments
302: PROCEDURE update_leaseapp_status(p_api_version IN NUMBER,
303: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
304: x_return_status OUT NOCOPY VARCHAR2,
305: x_msg_count OUT NOCOPY NUMBER,
306: x_msg_data OUT NOCOPY VARCHAR2,
307: p_lap_id IN OKL_LEASE_APPLICATIONS_B.ID%TYPE) IS

Line 359: x_return_status := okc_api.G_RET_STS_SUCCESS;

355: RAISE OKL_API.G_EXCEPTION_ERROR;
356: END IF;
357:
358:
359: x_return_status := okc_api.G_RET_STS_SUCCESS;
360: OKL_API.END_ACTIVITY(
361: x_msg_count => x_msg_count
362: ,x_msg_data => x_msg_data);
363: EXCEPTION

Line 399: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

395: -- Description : This procedure is a wrapper that creates create_vendor
396:
397: -- End of comments
398: PROCEDURE create_vendor(p_api_version IN NUMBER,
399: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
400: x_return_status OUT NOCOPY VARCHAR2,
401: x_msg_count OUT NOCOPY NUMBER,
402: x_msg_data OUT NOCOPY VARCHAR2,
403: p_chr_id IN NUMBER,

Line 460: lp_cplv_rec.sfwt_flag := OKC_API.G_FALSE;

456: RAISE OKL_API.G_EXCEPTION_ERROR;
457: END IF;
458:
459: lp_cplv_rec.object_version_number := 1.0;
460: lp_cplv_rec.sfwt_flag := OKC_API.G_FALSE;
461: lp_cplv_rec.dnz_chr_id := p_chr_id;
462: lp_cplv_rec.chr_id := p_chr_id;
463: lp_cplv_rec.cle_id := p_cle_id;
464: lp_cplv_rec.object1_id1 := p_vendor_id;

Line 501: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

497: IF(l_debug_enabled='Y') THEN
498: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_k_party_roles_pvt.create_k_party_role'
499: ,'end debug call create_k_party_role');
500: END IF;
501: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
502: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
503: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
504: RAISE OKL_API.G_EXCEPTION_ERROR;
505: END IF;

Line 503: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

499: ,'end debug call create_k_party_role');
500: END IF;
501: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
502: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
503: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
504: RAISE OKL_API.G_EXCEPTION_ERROR;
505: END IF;
506: END IF;
507: x_return_status := okc_api.G_RET_STS_SUCCESS;

Line 507: x_return_status := okc_api.G_RET_STS_SUCCESS;

503: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
504: RAISE OKL_API.G_EXCEPTION_ERROR;
505: END IF;
506: END IF;
507: x_return_status := okc_api.G_RET_STS_SUCCESS;
508: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
509: ,x_msg_data => x_msg_data);
510: EXCEPTION
511: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 610: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

606: -- History : 20-Jun-2005 SKGAUTAM created
607: --
608: -- End of comments
609: PROCEDURE create_rule_group(p_api_version IN NUMBER,
610: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
611: x_return_status OUT NOCOPY VARCHAR2,
612: x_msg_count OUT NOCOPY NUMBER,
613: x_msg_data OUT NOCOPY VARCHAR2,
614: p_cle_id IN NUMBER,

Line 671: x_return_status := okc_api.G_RET_STS_SUCCESS;

667: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
668: RAISE OKL_API.G_EXCEPTION_ERROR;
669: END IF;
670: x_rgp_id := lx_rgpv_rec.id;
671: x_return_status := okc_api.G_RET_STS_SUCCESS;
672: OKL_API.END_ACTIVITY(
673: x_msg_count => x_msg_count
674: ,x_msg_data => x_msg_data);
675: EXCEPTION

Line 895: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

891: -- History : 20-Jun-2005 SKGAUTAM created
892: --
893: -- End of comments
894: PROCEDURE validate_payment_details(p_api_version IN NUMBER,
895: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
896: x_return_status OUT NOCOPY VARCHAR2,
897: x_msg_count OUT NOCOPY NUMBER,
898: x_msg_data OUT NOCOPY VARCHAR2,
899: p_chr_id IN NUMBER,

Line 1114: x_return_status := okc_api.G_RET_STS_SUCCESS;

1110: RAISE OKL_API.G_EXCEPTION_ERROR;
1111: END IF;
1112: END IF;
1113: x_payment_levels_tbl := l_payment_levels_tbl;
1114: x_return_status := okc_api.G_RET_STS_SUCCESS;
1115: OKL_API.END_ACTIVITY(
1116: x_msg_count => x_msg_count
1117: ,x_msg_data => x_msg_data);
1118: EXCEPTION

Line 1401: x_return_status := okc_api.G_RET_STS_SUCCESS;

1397: RAISE OKL_API.G_EXCEPTION_ERROR;
1398: END IF;
1399: END LOOP; -- end of payment_level_table
1400: END IF; -- if payment_level_tbl has any records
1401: x_return_status := okc_api.G_RET_STS_SUCCESS;
1402: OKL_API.END_ACTIVITY(
1403: x_msg_count => x_msg_count
1404: ,x_msg_data => x_msg_data);
1405: EXCEPTION

Line 1448: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1444: -- 04-Jan-2008 RRAVIKIR modified for Bug#6707125 for correct allocation of
1445: -- amount to associated assets of a Fee Line
1446: -- End of comments
1447: PROCEDURE create_link_assets (p_api_version IN NUMBER,
1448: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1449: x_return_status OUT NOCOPY VARCHAR2,
1450: x_msg_count OUT NOCOPY NUMBER,
1451: x_msg_data OUT NOCOPY VARCHAR2,
1452: p_cle_id IN NUMBER,

Line 1649: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1645: IF(l_debug_enabled='Y') THEN
1646: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_contract_line_item_pvt.create_contract_line_item'
1647: ,'end debug call create_contract_line_item');
1648: END IF;
1649: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1650: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1651: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1652: RAISE OKL_API.G_EXCEPTION_ERROR;
1653: END IF;

Line 1651: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1647: ,'end debug call create_contract_line_item');
1648: END IF;
1649: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1650: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1651: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1652: RAISE OKL_API.G_EXCEPTION_ERROR;
1653: END IF;
1654: END IF;
1655: END IF;

Line 1656: x_return_status := okc_api.G_RET_STS_SUCCESS;

1652: RAISE OKL_API.G_EXCEPTION_ERROR;
1653: END IF;
1654: END IF;
1655: END IF;
1656: x_return_status := okc_api.G_RET_STS_SUCCESS;
1657: OKL_API.END_ACTIVITY(
1658: x_msg_count => x_msg_count
1659: ,x_msg_data => x_msg_data);
1660: EXCEPTION

Line 1701: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1697: -- History : 20-Jun-2005 SKGAUTAM created
1698: --
1699: -- End of comments
1700: PROCEDURE create_expense_dtls(p_api_version IN NUMBER,
1701: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1702: x_return_status OUT NOCOPY VARCHAR2,
1703: x_msg_count OUT NOCOPY NUMBER,
1704: x_msg_data OUT NOCOPY VARCHAR2,
1705: p_cle_id IN NUMBER,

Line 1861: x_return_status := okc_api.G_RET_STS_SUCCESS;

1857: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1858: RAISE OKL_API.G_EXCEPTION_ERROR;
1859: END IF;
1860: END IF; -- end of create
1861: x_return_status := okc_api.G_RET_STS_SUCCESS;
1862: OKL_API.END_ACTIVITY(
1863: x_msg_count => x_msg_count
1864: ,x_msg_data => x_msg_data);
1865: EXCEPTION

Line 1906: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1902: -- History : 20-Jun-2005 SKGAUTAM created
1903: --
1904: -- End of comments
1905: PROCEDURE create_insurance_lines (p_api_version IN NUMBER,
1906: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1907: x_return_status OUT NOCOPY VARCHAR2,
1908: x_msg_count OUT NOCOPY NUMBER,
1909: x_msg_data OUT NOCOPY VARCHAR2,
1910: p_chr_id IN NUMBER) IS

Line 1960: x_return_status := okc_api.G_RET_STS_SUCCESS;

1956: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1957: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1958: RAISE OKL_API.G_EXCEPTION_ERROR;
1959: END IF;
1960: x_return_status := okc_api.G_RET_STS_SUCCESS;
1961: OKL_API.END_ACTIVITY(
1962: x_msg_count => x_msg_count
1963: ,x_msg_data => x_msg_data);
1964: EXCEPTION

Line 2006: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2002: -- History : 20-Jun-2005 SKGAUTAM created
2003: --
2004: -- End of comments
2005: PROCEDURE create_service_lines (p_api_version IN NUMBER,
2006: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2007: x_return_status OUT NOCOPY VARCHAR2,
2008: x_msg_count OUT NOCOPY NUMBER,
2009: x_msg_data OUT NOCOPY VARCHAR2,
2010: p_quote_id IN NUMBER,

Line 2267: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2263: IF(l_debug_enabled='Y') THEN
2264: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.create_vendor'
2265: ,'end debug call create_vendor');
2266: END IF;
2267: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2268: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2269: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2270: RAISE OKL_API.G_EXCEPTION_ERROR;
2271: END IF;

Line 2269: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2265: ,'end debug call create_vendor');
2266: END IF;
2267: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2268: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2269: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2270: RAISE OKL_API.G_EXCEPTION_ERROR;
2271: END IF;
2272:
2273: IF(l_debug_enabled='Y') THEN

Line 2290: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2286: IF(l_debug_enabled='Y') THEN
2287: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.create_vendor'
2288: ,'end debug call create_vendor');
2289: END IF;
2290: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2291: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2292: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2293: RAISE OKL_API.G_EXCEPTION_ERROR;
2294: END IF;

Line 2292: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2288: ,'end debug call create_vendor');
2289: END IF;
2290: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2291: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2292: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2293: RAISE OKL_API.G_EXCEPTION_ERROR;
2294: END IF;
2295: END IF;
2296:

Line 2298: x_return_status := okc_api.G_RET_STS_SUCCESS;

2294: END IF;
2295: END IF;
2296:
2297: END LOOP;
2298: x_return_status := okc_api.G_RET_STS_SUCCESS;
2299: OKL_API.END_ACTIVITY(
2300: x_msg_count => x_msg_count
2301: ,x_msg_data => x_msg_data);
2302: EXCEPTION

Line 2344: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2340: -- Version : 1.0
2341: -- History : 20-Jun-2005 SKGAUTAM created
2342: -- End of comments
2343: PROCEDURE create_fee_lines(p_api_version IN NUMBER,
2344: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2345: x_return_status OUT NOCOPY VARCHAR2,
2346: x_msg_count OUT NOCOPY NUMBER,
2347: x_msg_data OUT NOCOPY VARCHAR2,
2348: p_quote_id IN NUMBER,

Line 2510: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2506: IF(l_debug_enabled='Y') THEN
2507: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.create_vendor'
2508: ,'end debug call create_vendor');
2509: END IF;
2510: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2511: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2512: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2513: RAISE OKL_API.G_EXCEPTION_ERROR;
2514: END IF;

Line 2512: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2508: ,'end debug call create_vendor');
2509: END IF;
2510: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2511: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2512: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2513: RAISE OKL_API.G_EXCEPTION_ERROR;
2514: END IF;
2515: END IF;
2516: END IF;

Line 2542: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2538: IF(l_debug_enabled='Y') THEN
2539: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_maintain_fee_pvt.create_fee_type'
2540: ,'end debug call create_fee_type');
2541: END IF;
2542: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2544: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2545: RAISE OKL_API.G_EXCEPTION_ERROR;
2546: END IF;

Line 2544: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2540: ,'end debug call create_fee_type');
2541: END IF;
2542: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2543: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2544: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2545: RAISE OKL_API.G_EXCEPTION_ERROR;
2546: END IF;
2547: l_cle_id := lx_fee_types_rec.line_id;
2548: IF l_quote_fee_rec.fee_type IN ('MISCELLANEOUS', 'EXPENSE', 'CAPITALIZED', 'FINANCED','INCOME','ROLLOVER') THEN

Line 2571: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2567: IF(l_debug_enabled='Y') THEN
2568: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.create_link_assets'
2569: ,'end debug call create_link_assets');
2570: END IF;
2571: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2572: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2573: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2574: RAISE OKL_API.G_EXCEPTION_ERROR;
2575: END IF;

Line 2573: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2569: ,'end debug call create_link_assets');
2570: END IF;
2571: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2572: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2573: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2574: RAISE OKL_API.G_EXCEPTION_ERROR;
2575: END IF;
2576: END IF;
2577:

Line 2597: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2593: IF(l_debug_enabled='Y') THEN
2594: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.create_expense_dtls'
2595: ,'end debug call create_expense_dtls');
2596: END IF;
2597: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2599: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2600: RAISE OKL_API.G_EXCEPTION_ERROR;
2601: END IF;

Line 2599: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2595: ,'end debug call create_expense_dtls');
2596: END IF;
2597: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2598: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2599: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2600: RAISE OKL_API.G_EXCEPTION_ERROR;
2601: END IF;
2602: END IF;
2603: IF l_quote_fee_rec.fee_type IN ('MISCELLANEOUS', 'PASSTHROUGH', 'FINANCED', 'INCOME', 'ROLLOVER', 'SEC_DEPOSIT') THEN

Line 2650: x_return_status := okc_api.G_RET_STS_SUCCESS;

2646: END IF;
2647: END IF;
2648: END IF;
2649: END LOOP;
2650: x_return_status := okc_api.G_RET_STS_SUCCESS;
2651: OKL_API.END_ACTIVITY(
2652: x_msg_count => x_msg_count
2653: ,x_msg_data => x_msg_data);
2654: EXCEPTION

Line 2697: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2693: -- History : 20-Jun-2005 SKGAUTAM created
2694: --
2695: -- End of comments
2696: PROCEDURE create_asset_addon( p_api_version IN NUMBER,
2697: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2698: x_return_status OUT NOCOPY VARCHAR2,
2699: x_msg_count OUT NOCOPY NUMBER,
2700: x_msg_data OUT NOCOPY VARCHAR2,
2701: p_clev_fin_rec IN clev_fin_rec,

Line 2844: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2840: IF(l_debug_enabled='Y') THEN
2841: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_CREATE_KLE_PVT.create_add_on_line'
2842: ,'end debug call create_add_on_line');
2843: END IF;
2844: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2845: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2846: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2847: RAISE OKL_API.G_EXCEPTION_ERROR;
2848: END IF;

Line 2846: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2842: ,'end debug call create_add_on_line');
2843: END IF;
2844: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2845: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2846: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2847: RAISE OKL_API.G_EXCEPTION_ERROR;
2848: END IF;
2849:
2850: -- create the party as vendor for the supplier present on the asset

Line 2870: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2866: IF(l_debug_enabled='Y') THEN
2867: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.create_vendor'
2868: ,'end debug call create_vendor');
2869: END IF;
2870: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2871: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2872: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2873: RAISE OKL_API.G_EXCEPTION_ERROR;
2874: END IF;

Line 2872: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2868: ,'end debug call create_vendor');
2869: END IF;
2870: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2871: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2872: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2873: RAISE OKL_API.G_EXCEPTION_ERROR;
2874: END IF;
2875: IF(l_debug_enabled='Y') THEN
2876: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.create_vendor'

Line 2892: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2888: IF(l_debug_enabled='Y') THEN
2889: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.create_vendor'
2890: ,'end debug call create_vendor');
2891: END IF;
2892: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2893: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2894: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2895: RAISE OKL_API.G_EXCEPTION_ERROR;
2896: END IF;

Line 2894: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

2890: ,'end debug call create_vendor');
2891: END IF;
2892: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2893: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2894: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2895: RAISE OKL_API.G_EXCEPTION_ERROR;
2896: END IF;
2897: END IF;
2898:

Line 2902: x_return_status := okc_api.G_RET_STS_SUCCESS;

2898:
2899:
2900: END LOOP;
2901: -- END IF;
2902: x_return_status := okc_api.G_RET_STS_SUCCESS;
2903: OKL_API.END_ACTIVITY(
2904: x_msg_count => x_msg_count
2905: ,x_msg_data => x_msg_data);
2906: EXCEPTION

Line 2951: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2947: -- Amount Subsidy
2948: --
2949: -- End of comments
2950: PROCEDURE create_asset_subsidy (p_api_version IN NUMBER,
2951: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2952: x_return_status OUT NOCOPY VARCHAR2,
2953: x_msg_count OUT NOCOPY NUMBER,
2954: x_msg_data OUT NOCOPY VARCHAR2,
2955: --p_clev_fin_rec IN clev_fin_rec, -- Commented by rravikir for bug#6707125

Line 3049: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3045: IF(l_debug_enabled='Y') THEN
3046: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.create_vendor'
3047: ,'end debug call create_vendor');
3048: END IF;
3049: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3050: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3051: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3052: RAISE OKL_API.G_EXCEPTION_ERROR;
3053: END IF;

Line 3051: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3047: ,'end debug call create_vendor');
3048: END IF;
3049: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3050: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3051: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3052: RAISE OKL_API.G_EXCEPTION_ERROR;
3053: END IF;
3054: END IF;
3055:

Line 3077: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3073: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_asset_subsidy_pvt.create_asset_subsidy'
3074: ,'end debug call create_asset_subsidy');
3075: END IF;
3076:
3077: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3078: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3079: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3080: RAISE OKL_API.G_EXCEPTION_ERROR;
3081: END IF;

Line 3079: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3075: END IF;
3076:
3077: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3078: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3079: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3080: RAISE OKL_API.G_EXCEPTION_ERROR;
3081: END IF;
3082: END IF;
3083: END IF;

Line 3086: x_return_status := okc_api.G_RET_STS_SUCCESS;

3082: END IF;
3083: END IF;
3084: END LOOP; -- Outer Loop Added by rravikir for bug#6707125
3085:
3086: x_return_status := okc_api.G_RET_STS_SUCCESS;
3087:
3088: OKL_API.END_ACTIVITY(
3089: x_msg_count => x_msg_count
3090: ,x_msg_data => x_msg_data);

Line 3127: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3123: -- Procedure Name : create_asset_down_payment
3124: -- Description : This procedure creates down payment for an asset
3125: -- End of comments
3126: PROCEDURE create_asset_down_payment (p_api_version IN NUMBER,
3127: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3128: x_return_status OUT NOCOPY VARCHAR2,
3129: x_msg_count OUT NOCOPY NUMBER,
3130: x_msg_data OUT NOCOPY VARCHAR2,
3131: p_clev_fin_rec IN clev_fin_rec,

Line 3235: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3231: IF(l_debug_enabled='Y') THEN
3232: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.Okl_La_Asset_Pvt.update_Fin_Cap_Cost'
3233: ,'end debug call update_Fin_Cap_Cost');
3234: END IF;
3235: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3236: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3237: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3238: RAISE OKL_API.G_EXCEPTION_ERROR;
3239: END IF;

Line 3237: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3233: ,'end debug call update_Fin_Cap_Cost');
3234: END IF;
3235: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3236: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3237: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3238: RAISE OKL_API.G_EXCEPTION_ERROR;
3239: END IF;
3240: END IF;
3241: x_return_status := okc_api.G_RET_STS_SUCCESS;

Line 3241: x_return_status := okc_api.G_RET_STS_SUCCESS;

3237: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3238: RAISE OKL_API.G_EXCEPTION_ERROR;
3239: END IF;
3240: END IF;
3241: x_return_status := okc_api.G_RET_STS_SUCCESS;
3242:
3243: OKL_API.END_ACTIVITY(
3244: x_msg_count => x_msg_count
3245: ,x_msg_data => x_msg_data);

Line 3281: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3277: -- Procedure Name : create_asset_tradein
3278: -- Description : This procedure creates trade in for an asset
3279: -- End of comments
3280: PROCEDURE create_asset_tradein (p_api_version IN NUMBER,
3281: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3282: x_return_status OUT NOCOPY VARCHAR2,
3283: x_msg_count OUT NOCOPY NUMBER,
3284: x_msg_data OUT NOCOPY VARCHAR2,
3285: p_clev_fin_rec IN clev_fin_rec,

Line 3370: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3366: IF(l_debug_enabled='Y') THEN
3367: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.Okl_La_Tradein_Pvt.create_Tradein'
3368: ,'end debug call create_Tradein');
3369: END IF;
3370: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3371: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3372: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3373: RAISE OKL_API.G_EXCEPTION_ERROR;
3374: END IF;

Line 3372: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3368: ,'end debug call create_Tradein');
3369: END IF;
3370: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3371: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3372: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3373: RAISE OKL_API.G_EXCEPTION_ERROR;
3374: END IF;
3375:
3376: END IF;

Line 3377: x_return_status := okc_api.G_RET_STS_SUCCESS;

3373: RAISE OKL_API.G_EXCEPTION_ERROR;
3374: END IF;
3375:
3376: END IF;
3377: x_return_status := okc_api.G_RET_STS_SUCCESS;
3378:
3379: OKL_API.END_ACTIVITY(
3380: x_msg_count => x_msg_count
3381: ,x_msg_data => x_msg_data);

Line 3425: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3421: -- Version : 1.0
3422: -- History : 20-Jun-2005 SKGAUTAM created
3423: -- End of comments
3424: PROCEDURE create_asset_lines(p_api_version IN NUMBER,
3425: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3426: x_return_status OUT NOCOPY VARCHAR2,
3427: x_msg_count OUT NOCOPY NUMBER,
3428: x_msg_data OUT NOCOPY VARCHAR2,
3429: p_chr_id IN NUMBER,

Line 3701: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3697: IF(l_debug_enabled='Y') THEN
3698: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_create_kle_pvt.create_all_line'
3699: ,'end debug call create_all_line');
3700: END IF;
3701: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3702: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3703: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3704: RAISE OKL_API.G_EXCEPTION_ERROR;
3705: END IF;

Line 3703: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3699: ,'end debug call create_all_line');
3700: END IF;
3701: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3702: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3703: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3704: RAISE OKL_API.G_EXCEPTION_ERROR;
3705: END IF;
3706: --populate quote contract asset id mapping table
3707: l_qte_cntrct_ast_tbl(l_ast_counter).qte_asset_id := l_quote_asset_rec.ID;

Line 3727: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3723: IF(l_debug_enabled='Y') THEN
3724: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.create_asset_addon'
3725: ,'end debug call create_asset_addon');
3726: END IF;
3727: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3728: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3729: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3730: RAISE OKL_API.G_EXCEPTION_ERROR;
3731: END IF;

Line 3729: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3725: ,'end debug call create_asset_addon');
3726: END IF;
3727: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3728: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3729: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3730: RAISE OKL_API.G_EXCEPTION_ERROR;
3731: END IF;
3732: -- create the party as vendor for the supplier present on the asset
3733: IF l_quote_asset_rec.supplier_id IS NOT NULL THEN

Line 3752: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3748: IF(l_debug_enabled='Y') THEN
3749: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.create_vendor'
3750: ,'end debug call create_vendor');
3751: END IF;
3752: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3753: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3754: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3755: RAISE OKL_API.G_EXCEPTION_ERROR;
3756: END IF;

Line 3754: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3750: ,'end debug call create_vendor');
3751: END IF;
3752: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3753: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3754: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3755: RAISE OKL_API.G_EXCEPTION_ERROR;
3756: END IF;
3757: IF(l_debug_enabled='Y') THEN
3758: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.create_vendor'

Line 3774: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3770: IF(l_debug_enabled='Y') THEN
3771: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.create_vendor'
3772: ,'end debug call create_vendor');
3773: END IF;
3774: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3775: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3776: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3777: RAISE OKL_API.G_EXCEPTION_ERROR;
3778: END IF;

Line 3776: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3772: ,'end debug call create_vendor');
3773: END IF;
3774: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3775: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3776: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3777: RAISE OKL_API.G_EXCEPTION_ERROR;
3778: END IF;
3779: END IF;
3780:

Line 3806: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3802: IF(l_debug_enabled='Y') THEN
3803: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.create_asset_subsidy'
3804: ,'end debug call create_asset_subsidy');
3805: END IF;
3806: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3807: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3808: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3809: RAISE OKL_API.G_EXCEPTION_ERROR;
3810: END IF;

Line 3808: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3804: ,'end debug call create_asset_subsidy');
3805: END IF;
3806: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3807: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3808: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3809: RAISE OKL_API.G_EXCEPTION_ERROR;
3810: END IF;
3811:
3812: End : Commented by rravikir for bug#6707125

Line 3832: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3828: IF(l_debug_enabled='Y') THEN
3829: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.create_asset_down_payment'
3830: ,'end debug call create_asset_down_payment');
3831: END IF;
3832: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3833: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3834: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3835: RAISE OKL_API.G_EXCEPTION_ERROR;
3836: END IF;

Line 3834: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3830: ,'end debug call create_asset_down_payment');
3831: END IF;
3832: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3833: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3834: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3835: RAISE OKL_API.G_EXCEPTION_ERROR;
3836: END IF;
3837: -- create trade in
3838: IF(l_debug_enabled='Y') THEN

Line 3855: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3851: IF(l_debug_enabled='Y') THEN
3852: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.create_asset_tradein'
3853: ,'end debug call create_asset_tradein');
3854: END IF;
3855: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3856: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3857: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3858: RAISE OKL_API.G_EXCEPTION_ERROR;
3859: END IF;

Line 3857: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3853: ,'end debug call create_asset_tradein');
3854: END IF;
3855: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3856: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3857: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3858: RAISE OKL_API.G_EXCEPTION_ERROR;
3859: END IF;
3860: --create asset rent payments
3861: l_pymnt_counter := 0;

Line 3898: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3894: IF(l_debug_enabled='Y') THEN
3895: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.create_payment_plans'
3896: ,'end debug call create_payment_plans');
3897: END IF;
3898: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3899: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3900: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3901: RAISE OKL_API.G_EXCEPTION_ERROR;
3902: END IF;

Line 3900: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3896: ,'end debug call create_payment_plans');
3897: END IF;
3898: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3899: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3900: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3901: RAISE OKL_API.G_EXCEPTION_ERROR;
3902: END IF;
3903: END IF;
3904:

Line 3943: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3939: IF(l_debug_enabled='Y') THEN
3940: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.create_payment_plans'
3941: ,'end debug call create_payment_plans');
3942: END IF;
3943: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3944: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3945: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3946: RAISE OKL_API.G_EXCEPTION_ERROR;
3947: END IF;

Line 3945: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3941: ,'end debug call create_payment_plans');
3942: END IF;
3943: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3944: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3945: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3946: RAISE OKL_API.G_EXCEPTION_ERROR;
3947: END IF;
3948: END IF;
3949:

Line 3988: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3984: IF(l_debug_enabled='Y') THEN
3985: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.create_payment_plans'
3986: ,'end debug call create_payment_plans');
3987: END IF;
3988: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3989: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3990: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3991: RAISE OKL_API.G_EXCEPTION_ERROR;
3992: END IF;

Line 3990: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

3986: ,'end debug call create_payment_plans');
3987: END IF;
3988: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3989: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3990: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3991: RAISE OKL_API.G_EXCEPTION_ERROR;
3992: END IF;
3993: END IF;
3994: END LOOP;

Line 4022: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4018: IF(l_debug_enabled='Y') THEN
4019: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.create_asset_tradein'
4020: ,'end debug call create_asset_tradein');
4021: END IF;
4022: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4023: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4024: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4025: RAISE OKL_API.G_EXCEPTION_ERROR;
4026: END IF;

Line 4024: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4020: ,'end debug call create_asset_tradein');
4021: END IF;
4022: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4023: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4024: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4025: RAISE OKL_API.G_EXCEPTION_ERROR;
4026: END IF;
4027: END IF;
4028: /*

Line 4065: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4061: IF(l_debug_enabled='Y') THEN
4062: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.create_payment_plans'
4063: ,'end debug call okl_la_payments_pvt.process_payment');
4064: END IF;
4065: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4066: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4067: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4068: RAISE OKL_API.G_EXCEPTION_ERROR;
4069: END IF;

Line 4067: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4063: ,'end debug call okl_la_payments_pvt.process_payment');
4064: END IF;
4065: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4066: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4067: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4068: RAISE OKL_API.G_EXCEPTION_ERROR;
4069: END IF;
4070: END IF;
4071: */

Line 4072: x_return_status := okc_api.G_RET_STS_SUCCESS;

4068: RAISE OKL_API.G_EXCEPTION_ERROR;
4069: END IF;
4070: END IF;
4071: */
4072: x_return_status := okc_api.G_RET_STS_SUCCESS;
4073: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
4074: ,x_msg_data => x_msg_data);
4075: EXCEPTION
4076: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 4117: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

4113: -- Version : 1.0
4114: -- History : 20-Jun-2005 SKGAUTAM created
4115: -- End of comments
4116: PROCEDURE create_rules(p_api_version IN NUMBER,
4117: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4118: x_return_status OUT NOCOPY VARCHAR2,
4119: x_msg_count OUT NOCOPY NUMBER,
4120: x_msg_data OUT NOCOPY VARCHAR2,
4121: p_chr_id IN NUMBER,

Line 4212: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4208: IF(l_debug_enabled='Y') THEN
4209: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_COPY_CONTRACT_PUB.copy_rules'
4210: ,'end debug call copy_rules');
4211: END IF;
4212: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4213: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4214: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4215: RAISE OKL_API.G_EXCEPTION_ERROR;
4216: END IF;

Line 4214: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4210: ,'end debug call copy_rules');
4211: END IF;
4212: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4213: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4214: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4215: RAISE OKL_API.G_EXCEPTION_ERROR;
4216: END IF;
4217: END LOOP;
4218: END IF;

Line 4226: lp_rgr_tbl(i).sfwt_flag := OKC_API.G_FALSE;

4222: l_lapv_rec.PROPERTY_TAX_BILLING_TYPE IS NOT NULL )
4223: THEN
4224: lp_rgr_tbl(i).rgd_code := 'LAHDTX';
4225: lp_rgr_tbl(i).object_version_number := '1.0';
4226: lp_rgr_tbl(i).sfwt_flag := OKC_API.G_FALSE;
4227: lp_rgr_tbl(i).std_template_yn := 'N';
4228: lp_rgr_tbl(i).warn_yn := 'N';
4229: lp_rgr_tbl(i).template_yn := 'N';
4230: lp_rgr_tbl(i).rule_information_category := 'LAPRTX';

Line 4242: lp_rgr_tbl(i).sfwt_flag := OKC_API.G_FALSE;

4238: l_lapv_rec.UPFRONT_TAX_STREAM_TYPE IS NOT NULL
4239: THEN
4240: lp_rgr_tbl(i).rgd_code := 'LAHDTX';
4241: lp_rgr_tbl(i).object_version_number := '1.0';
4242: lp_rgr_tbl(i).sfwt_flag := OKC_API.G_FALSE;
4243: lp_rgr_tbl(i).std_template_yn := 'N';
4244: lp_rgr_tbl(i).warn_yn := 'N';
4245: lp_rgr_tbl(i).template_yn := 'N';
4246: lp_rgr_tbl(i).rule_information_category := 'LASTPR';

Line 4263: lp_rgr_tbl(i).sfwt_flag := OKC_API.G_FALSE;

4259: l_lapv_rec.INTEREST_DISCLOSED IS NOT NULL)
4260: THEN
4261: lp_rgr_tbl(i).rgd_code := 'LAHDTX';
4262: lp_rgr_tbl(i).object_version_number := '1.0';
4263: lp_rgr_tbl(i).sfwt_flag := OKC_API.G_FALSE;
4264: lp_rgr_tbl(i).std_template_yn := 'N';
4265: lp_rgr_tbl(i).warn_yn := 'N';
4266: lp_rgr_tbl(i).template_yn := 'N';
4267: lp_rgr_tbl(i).rule_information_category := 'LASTCL';

Line 4280: lp_rgr_tbl(i).sfwt_flag := OKC_API.G_FALSE;

4276:
4277: lp_rgr_tbl(i).rgd_code := 'LAHDTX';
4278: lp_rgr_tbl(i).object_version_number := '1.0';
4279: -- create all rules under this rule group
4280: lp_rgr_tbl(i).sfwt_flag := OKC_API.G_FALSE;
4281: lp_rgr_tbl(i).std_template_yn := 'N';
4282: lp_rgr_tbl(i).warn_yn := 'N';
4283: lp_rgr_tbl(i).template_yn := 'N';
4284: lp_rgr_tbl(i).rule_information_category := 'LAMETX';

Line 4291: lp_rgr_tbl(i).sfwt_flag := OKC_API.G_FALSE;

4287:
4288: lp_rgr_tbl(i).rgd_code := 'LAHDTX';
4289: lp_rgr_tbl(i).object_version_number := '1.0';
4290: -- create all rules under this rule group
4291: lp_rgr_tbl(i).sfwt_flag := OKC_API.G_FALSE;
4292: lp_rgr_tbl(i).std_template_yn := 'N';
4293: lp_rgr_tbl(i).warn_yn := 'N';
4294: lp_rgr_tbl(i).template_yn := 'N';
4295: lp_rgr_tbl(i).rule_information_category := 'LAAUTX';

Line 4316: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4312: IF(l_debug_enabled='Y') THEN
4313: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_RGRP_RULES_PROCESS_PUB.process_rule_group_rules'
4314: ,'end debug call process_rule_group_rules');
4315: END IF;
4316: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4317: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4318: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4319: RAISE OKL_API.G_EXCEPTION_ERROR;
4320: END IF;

Line 4318: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4314: ,'end debug call process_rule_group_rules');
4315: END IF;
4316: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4317: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4318: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4319: RAISE OKL_API.G_EXCEPTION_ERROR;
4320: END IF;
4321:
4322: x_return_status := okc_api.G_RET_STS_SUCCESS;

Line 4322: x_return_status := okc_api.G_RET_STS_SUCCESS;

4318: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4319: RAISE OKL_API.G_EXCEPTION_ERROR;
4320: END IF;
4321:
4322: x_return_status := okc_api.G_RET_STS_SUCCESS;
4323: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
4324: ,x_msg_data => x_msg_data);
4325: EXCEPTION
4326: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 4367: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

4363: -- Version : 1.0
4364: -- History : 20-Jun-2005 SKGAUTAM created
4365: -- End of comments
4366: PROCEDURE create_party_roles(p_api_version IN NUMBER,
4367: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4368: x_return_status OUT NOCOPY VARCHAR2,
4369: x_msg_count OUT NOCOPY NUMBER,
4370: x_msg_data OUT NOCOPY VARCHAR2,
4371: p_chr_id IN NUMBER,

Line 4440: lp_cplv_rec.sfwt_flag := OKC_API.G_FALSE;

4436: l_chr_id := p_chr_id;
4437: l_lapv_rec := p_lapv_rec;
4438: -- now we attach the party to the header
4439: lp_cplv_rec.object_version_number := 1.0;
4440: lp_cplv_rec.sfwt_flag := OKC_API.G_FALSE;
4441: lp_cplv_rec.dnz_chr_id := l_chr_id;
4442: lp_cplv_rec.chr_id := l_chr_id;
4443: lp_cplv_rec.cle_id := NULL;
4444: lp_cplv_rec.object1_id1 := l_lapv_rec.PROSPECT_ID;

Line 4453: x_return_status := OKC_API.g_ret_sts_error;

4449: OPEN check_party_csr(l_chr_id,l_lapv_rec.PROSPECT_ID);
4450: FETCH check_party_csr INTO row_count;
4451: CLOSE check_party_csr;
4452: IF row_count = 1 THEN
4453: x_return_status := OKC_API.g_ret_sts_error;
4454: OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'Party_already_exists');
4455: RAISE OKL_API.G_EXCEPTION_ERROR;
4456: END IF;
4457:

Line 4454: OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'Party_already_exists');

4450: FETCH check_party_csr INTO row_count;
4451: CLOSE check_party_csr;
4452: IF row_count = 1 THEN
4453: x_return_status := OKC_API.g_ret_sts_error;
4454: OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'Party_already_exists');
4455: RAISE OKL_API.G_EXCEPTION_ERROR;
4456: END IF;
4457:
4458: -- Validate the JTOT Object code, ID1 and ID2

Line 4468: p_init_msg_list => OKC_API.G_FALSE,

4464: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_la_validation_util_pvt.VALIDATE_ROLE_JTOT'
4465: ,'begin debug call VALIDATE_ROLE_JTOT');
4466: END IF;
4467: okl_la_validation_util_pvt.VALIDATE_ROLE_JTOT (p_api_version => p_api_version,
4468: p_init_msg_list => OKC_API.G_FALSE,
4469: x_return_status => x_return_status,
4470: x_msg_count => x_msg_count,
4471: x_msg_data => x_msg_data,
4472: p_object_name => lp_cplv_rec.jtot_object1_code,

Line 4479: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4475: IF(l_debug_enabled='Y') THEN
4476: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_la_validation_util_pvt.VALIDATE_ROLE_JTOT'
4477: ,'end debug call VALIDATE_ROLE_JTOT');
4478: END IF;
4479: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4480: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4481: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4482: RAISE OKL_API.G_EXCEPTION_ERROR;
4483: END IF;

Line 4481: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4477: ,'end debug call VALIDATE_ROLE_JTOT');
4478: END IF;
4479: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4480: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4481: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4482: RAISE OKL_API.G_EXCEPTION_ERROR;
4483: END IF;
4484: END IF;
4485: IF(l_debug_enabled='Y') THEN

Line 4506: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4502: IF(l_debug_enabled='Y') THEN
4503: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_k_party_roles_pvt.create_k_party_role'
4504: ,'end debug call create_k_party_role');
4505: END IF;
4506: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4507: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4508: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4509: RAISE OKL_API.G_EXCEPTION_ERROR;
4510: END IF;

Line 4508: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4504: ,'end debug call create_k_party_role');
4505: END IF;
4506: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4507: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4508: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4509: RAISE OKL_API.G_EXCEPTION_ERROR;
4510: END IF;
4511: -- Create Lessor
4512: -- now we attach the party to the header

Line 4514: lp_cplv_rec.sfwt_flag := OKC_API.G_FALSE;

4510: END IF;
4511: -- Create Lessor
4512: -- now we attach the party to the header
4513: lp_cplv_rec.object_version_number := 1.0;
4514: lp_cplv_rec.sfwt_flag := OKC_API.G_FALSE;
4515: lp_cplv_rec.dnz_chr_id := l_chr_id;
4516: lp_cplv_rec.chr_id := l_chr_id;
4517: lp_cplv_rec.cle_id := NULL;
4518: lp_cplv_rec.object1_id1 := l_lapv_rec.ORG_ID;

Line 4527: x_return_status := OKC_API.g_ret_sts_error;

4523: OPEN check_party_csr(l_chr_id,l_lapv_rec.ORG_ID);
4524: FETCH check_party_csr INTO row_count;
4525: CLOSE check_party_csr;
4526: IF row_count = 1 THEN
4527: x_return_status := OKC_API.g_ret_sts_error;
4528: OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'Party_already_exists');
4529: RAISE OKL_API.G_EXCEPTION_ERROR;
4530: END IF;
4531: --Validate the JTOT Object code, ID1 and ID2

Line 4528: OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'Party_already_exists');

4524: FETCH check_party_csr INTO row_count;
4525: CLOSE check_party_csr;
4526: IF row_count = 1 THEN
4527: x_return_status := OKC_API.g_ret_sts_error;
4528: OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'Party_already_exists');
4529: RAISE OKL_API.G_EXCEPTION_ERROR;
4530: END IF;
4531: --Validate the JTOT Object code, ID1 and ID2
4532: OPEN role_csr(lp_cplv_rec.rle_code);

Line 4541: p_init_msg_list => OKC_API.G_FALSE,

4537: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_la_validation_util_pvt.VALIDATE_ROLE_JTOT'
4538: ,'begin debug call VALIDATE_ROLE_JTOT');
4539: END IF;
4540: okl_la_validation_util_pvt.VALIDATE_ROLE_JTOT (p_api_version => p_api_version,
4541: p_init_msg_list => OKC_API.G_FALSE,
4542: x_return_status => x_return_status,
4543: x_msg_count => x_msg_count,
4544: x_msg_data => x_msg_data,
4545: p_object_name => lp_cplv_rec.jtot_object1_code,

Line 4552: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4548: IF(l_debug_enabled='Y') THEN
4549: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_la_validation_util_pvt.VALIDATE_ROLE_JTOT'
4550: ,'end debug call VALIDATE_ROLE_JTOT');
4551: END IF;
4552: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4553: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4554: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4555: RAISE OKL_API.G_EXCEPTION_ERROR;
4556: END IF;

Line 4554: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4550: ,'end debug call VALIDATE_ROLE_JTOT');
4551: END IF;
4552: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4553: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4554: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4555: RAISE OKL_API.G_EXCEPTION_ERROR;
4556: END IF;
4557: END IF;
4558: IF(l_debug_enabled='Y') THEN

Line 4579: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4575: IF(l_debug_enabled='Y') THEN
4576: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_k_party_roles_pvt.create_k_party_role'
4577: ,'end debug call create_k_party_role');
4578: END IF;
4579: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4580: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4581: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4582: RAISE OKL_API.G_EXCEPTION_ERROR;
4583: END IF;

Line 4581: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4577: ,'end debug call create_k_party_role');
4578: END IF;
4579: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4580: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4581: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4582: RAISE OKL_API.G_EXCEPTION_ERROR;
4583: END IF;
4584: l_cplv_id := lx_cplv_rec.ID;
4585: lp_ctcv_rec.object_version_number := 1.0;

Line 4607: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

4603: IF(l_debug_enabled='Y') THEN
4604: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKC_CONTRACT_PARTY_PUB.create_contact'
4605: ,'end debug call create_contact');
4606: END IF;
4607: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4608: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4609: x_return_status := l_return_status;
4610: RAISE G_EXCEPTION_HALT_VALIDATION;
4611: ELSE

Line 4608: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4604: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKC_CONTRACT_PARTY_PUB.create_contact'
4605: ,'end debug call create_contact');
4606: END IF;
4607: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
4608: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4609: x_return_status := l_return_status;
4610: RAISE G_EXCEPTION_HALT_VALIDATION;
4611: ELSE
4612: x_return_status := OKC_API.G_RET_STS_WARNING;

Line 4612: x_return_status := OKC_API.G_RET_STS_WARNING;

4608: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4609: x_return_status := l_return_status;
4610: RAISE G_EXCEPTION_HALT_VALIDATION;
4611: ELSE
4612: x_return_status := OKC_API.G_RET_STS_WARNING;
4613: okc_util.get_name_desc_from_jtfv(p_object_code => lx_cplv_rec.jtot_object1_code,
4614: p_id1 => lx_cplv_rec.object1_id1,
4615: p_id2 => lx_cplv_rec.object1_id2,
4616: x_name => l_party_name,

Line 4618: OKC_API.set_message(G_APP_NAME,'OKC_CONTACT_NOT_COPIED','PARTY_NAME',l_party_name);

4614: p_id1 => lx_cplv_rec.object1_id1,
4615: p_id2 => lx_cplv_rec.object1_id2,
4616: x_name => l_party_name,
4617: x_description => l_party_desc);
4618: OKC_API.set_message(G_APP_NAME,'OKC_CONTACT_NOT_COPIED','PARTY_NAME',l_party_name);
4619: END IF;
4620: END IF;
4621: -- create vendor
4622: FOR l_c_cplv IN c_cplv(l_lapv_rec.PROGRAM_AGREEMENT_ID) LOOP

Line 4624: lp_cplv_rec.sfwt_flag := OKC_API.G_FALSE;

4620: END IF;
4621: -- create vendor
4622: FOR l_c_cplv IN c_cplv(l_lapv_rec.PROGRAM_AGREEMENT_ID) LOOP
4623: lp_cplv_rec.object_version_number := 1.0;
4624: lp_cplv_rec.sfwt_flag := OKC_API.G_FALSE;
4625: lp_cplv_rec.dnz_chr_id := l_chr_id;
4626: lp_cplv_rec.chr_id := l_chr_id;
4627: lp_cplv_rec.cle_id := NULL;
4628: lp_cplv_rec.object1_id1 := l_c_cplv.object1_id1;

Line 4637: x_return_status := OKC_API.g_ret_sts_error;

4633: OPEN check_party_csr(l_chr_id,l_c_cplv.object1_id1);
4634: FETCH check_party_csr INTO row_count;
4635: CLOSE check_party_csr;
4636: IF row_count = 1 THEN
4637: x_return_status := OKC_API.g_ret_sts_error;
4638: OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'Party_already_exists');
4639: RAISE OKL_API.G_EXCEPTION_ERROR;
4640: END IF;
4641: --Validate the JTOT Object code, ID1 and ID2

Line 4638: OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'Party_already_exists');

4634: FETCH check_party_csr INTO row_count;
4635: CLOSE check_party_csr;
4636: IF row_count = 1 THEN
4637: x_return_status := OKC_API.g_ret_sts_error;
4638: OKC_API.SET_MESSAGE(p_app_name => g_app_name, p_msg_name => 'Party_already_exists');
4639: RAISE OKL_API.G_EXCEPTION_ERROR;
4640: END IF;
4641: --Validate the JTOT Object code, ID1 and ID2
4642: OPEN role_csr(lp_cplv_rec.rle_code);

Line 4651: p_init_msg_list => OKC_API.G_FALSE,

4647: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_la_validation_util_pvt.VALIDATE_ROLE_JTOT'
4648: ,'begin debug call VALIDATE_ROLE_JTOT');
4649: END IF;
4650: okl_la_validation_util_pvt.VALIDATE_ROLE_JTOT (p_api_version => p_api_version,
4651: p_init_msg_list => OKC_API.G_FALSE,
4652: x_return_status => x_return_status,
4653: x_msg_count => x_msg_count,
4654: x_msg_data => x_msg_data,
4655: p_object_name => lp_cplv_rec.jtot_object1_code,

Line 4662: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4658: IF(l_debug_enabled='Y') THEN
4659: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_la_validation_util_pvt.VALIDATE_ROLE_JTOT'
4660: ,'end debug call VALIDATE_ROLE_JTOT');
4661: END IF;
4662: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4663: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4664: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4665: RAISE OKL_API.G_EXCEPTION_ERROR;
4666: END IF;

Line 4664: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4660: ,'end debug call VALIDATE_ROLE_JTOT');
4661: END IF;
4662: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4663: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4664: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4665: RAISE OKL_API.G_EXCEPTION_ERROR;
4666: END IF;
4667: END IF;
4668: IF(l_debug_enabled='Y') THEN

Line 4689: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4685: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_k_party_roles_pvt.create_k_party_role'
4686: ,'end debug call create_k_party_role');
4687: END IF;
4688:
4689: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4690: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4691: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4692: RAISE OKL_API.G_EXCEPTION_ERROR;
4693: END IF;

Line 4691: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4687: END IF;
4688:
4689: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4690: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4691: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4692: RAISE OKL_API.G_EXCEPTION_ERROR;
4693: END IF;
4694: END LOOP;
4695: x_return_status := okc_api.G_RET_STS_SUCCESS;

Line 4695: x_return_status := okc_api.G_RET_STS_SUCCESS;

4691: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4692: RAISE OKL_API.G_EXCEPTION_ERROR;
4693: END IF;
4694: END LOOP;
4695: x_return_status := okc_api.G_RET_STS_SUCCESS;
4696: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
4697: ,x_msg_data => x_msg_data);
4698: EXCEPTION
4699: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 4740: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

4736: -- Version : 1.0
4737: -- History : 20-Jun-2005 SKGAUTAM created
4738: -- End of comments
4739: PROCEDURE create_contract_header(p_api_version IN NUMBER,
4740: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
4741: x_return_status OUT NOCOPY VARCHAR2,
4742: x_msg_count OUT NOCOPY NUMBER,
4743: x_msg_data OUT NOCOPY VARCHAR2,
4744: p_contract_number IN VARCHAR2,

Line 4861: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4857: IF(l_debug_enabled='Y') THEN
4858: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_CONTRACT_PUB.validate_contract_header'
4859: ,'end debug call validate_contract_header');
4860: END IF;
4861: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4862: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4863: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4864: RAISE OKL_API.G_EXCEPTION_ERROR;
4865: END IF;

Line 4863: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4859: ,'end debug call validate_contract_header');
4860: END IF;
4861: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4862: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4863: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4864: RAISE OKL_API.G_EXCEPTION_ERROR;
4865: END IF;
4866: IF(l_debug_enabled='Y') THEN
4867: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_CONTRACT_PUB.create_contract_header'

Line 4884: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4880: IF(l_debug_enabled='Y') THEN
4881: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_CONTRACT_PUB.create_contract_header'
4882: ,'end debug call create_contract_header');
4883: END IF;
4884: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4885: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4886: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4887: RAISE OKL_API.G_EXCEPTION_ERROR;
4888: END IF;

Line 4886: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4882: ,'end debug call create_contract_header');
4883: END IF;
4884: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4885: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4886: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4887: RAISE OKL_API.G_EXCEPTION_ERROR;
4888: END IF;
4889: x_chr_id := lx_chrv_rec.id;
4890: -- copy master lease

Line 4913: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4909: IF(l_debug_enabled='Y') THEN
4910: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_OKC_MIGRATION_PVT.create_governance'
4911: ,'end debug call create_governance');
4912: END IF;
4913: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4914: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4915: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4916: RAISE OKL_API.G_EXCEPTION_ERROR;
4917: END IF;

Line 4915: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4911: ,'end debug call create_governance');
4912: END IF;
4913: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4914: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4915: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4916: RAISE OKL_API.G_EXCEPTION_ERROR;
4917: END IF;
4918: END IF;
4919: -- copy credit line

Line 4942: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

4938: IF(l_debug_enabled='Y') THEN
4939: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_OKC_MIGRATION_PVT.create_governance'
4940: ,'end debug call create_governance');
4941: END IF;
4942: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4943: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4944: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4945: RAISE OKL_API.G_EXCEPTION_ERROR;
4946: END IF;

Line 4944: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

4940: ,'end debug call create_governance');
4941: END IF;
4942: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
4943: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4944: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4945: RAISE OKL_API.G_EXCEPTION_ERROR;
4946: END IF;
4947: END IF;
4948: x_return_status := okc_api.G_RET_STS_SUCCESS;

Line 4948: x_return_status := okc_api.G_RET_STS_SUCCESS;

4944: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
4945: RAISE OKL_API.G_EXCEPTION_ERROR;
4946: END IF;
4947: END IF;
4948: x_return_status := okc_api.G_RET_STS_SUCCESS;
4949: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
4950: ,x_msg_data => x_msg_data);
4951: EXCEPTION
4952: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 5011: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

5007: -- History : 20-Jun-2005 SKGAUTAM created
5008: -- 04-Jan-2008 RRAVIKIR code added to invoke procedure create_asset_subsidy for subsidy creation
5009: -- End of comments
5010: PROCEDURE create_contract(p_api_version IN NUMBER,
5011: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
5012: x_return_status OUT NOCOPY VARCHAR2,
5013: x_msg_count OUT NOCOPY NUMBER,
5014: x_msg_data OUT NOCOPY VARCHAR2,
5015: p_contract_number IN VARCHAR2,

Line 5281: p_init_msg_list => OKC_API.G_FALSE,

5277: END IF;
5278: -- moved code here for bug#6765840 End
5279:
5280: create_contract_header(p_api_version => p_api_version,
5281: p_init_msg_list => OKC_API.G_FALSE,
5282: x_return_status => x_return_status,
5283: x_msg_count => x_msg_count,
5284: x_msg_data => x_msg_data,
5285: p_contract_number => l_contract_number,

Line 5305: p_init_msg_list => OKC_API.G_FALSE,

5301: ,'begin debug call create_party_roles');
5302: END IF;
5303:
5304: create_party_roles(p_api_version => p_api_version,
5305: p_init_msg_list => OKC_API.G_FALSE,
5306: x_return_status => x_return_status,
5307: x_msg_count => x_msg_count,
5308: x_msg_data => x_msg_data,
5309: p_chr_id => l_chr_id,

Line 5326: p_init_msg_list => OKC_API.G_FALSE,

5322: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.create_pcreate_rulesarty_roles'
5323: ,'begin debug call create_rules');
5324: END IF;
5325: create_rules(p_api_version => p_api_version,
5326: p_init_msg_list => OKC_API.G_FALSE,
5327: x_return_status => x_return_status,
5328: x_msg_count => x_msg_count,
5329: x_msg_data => x_msg_data,
5330: p_chr_id => l_chr_id,

Line 5349: p_init_msg_list => OKC_API.G_FALSE,

5345: ,'begin debug call create_asset_lines');
5346: END IF;
5347:
5348: create_asset_lines(p_api_version => p_api_version,
5349: p_init_msg_list => OKC_API.G_FALSE,
5350: x_return_status => x_return_status,
5351: x_msg_count => x_msg_count,
5352: x_msg_data => x_msg_data,
5353: p_chr_id => l_chr_id,

Line 5395: p_init_msg_list => OKC_API.G_FALSE,

5391: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_quote_to_contract_pvt.create asset subsidy'
5392: ,'begin debug call create_asset_subsidy');
5393: END IF;
5394: create_asset_subsidy(p_api_version => p_api_version,
5395: p_init_msg_list => OKC_API.G_FALSE,
5396: x_return_status => x_return_status,
5397: x_msg_count => x_msg_count,
5398: x_msg_data => x_msg_data,
5399: p_quote_id => l_lapv_rec.quote_id,

Line 5537: x_return_status := okc_api.G_RET_STS_SUCCESS;

5533:
5534: END IF;
5535: -- Bug#4741121 - viselvar - Modified - End
5536:
5537: x_return_status := okc_api.G_RET_STS_SUCCESS;
5538: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count
5539: ,x_msg_data => x_msg_data);
5540: EXCEPTION
5541: WHEN OKL_API.G_EXCEPTION_ERROR THEN