DBA Data[Home] [Help]

APPS.OKL_MASS_REBOOK_PVT dependencies on OKC_API

Line 1329: p_init_msg_list => OKC_API.G_FALSE,

1325: END LOOP;
1326:
1327: okl_contract_pub.update_contract_line(
1328: p_api_version => 1.0,
1329: p_init_msg_list => OKC_API.G_FALSE,
1330: x_return_status => x_return_status,
1331: x_msg_count => x_msg_count,
1332: x_msg_data => x_msg_data,
1333: p_clev_tbl => l_clev_tbl,

Line 1814: p_init_msg_list => OKC_API.G_FALSE,

1810: END IF;
1811: l_rulv_rec.id := l_slh_id;
1812: okl_rule_pub.delete_rule(
1813: p_api_version => 1.0,
1814: p_init_msg_list => OKC_API.G_FALSE,
1815: x_return_status => x_return_status,
1816: x_msg_count => x_msg_count,
1817: x_msg_data => x_msg_data,
1818: p_rulv_rec => l_rulv_rec

Line 1837: p_init_msg_list => OKC_API.G_FALSE,

1833: l_rulv_tbl(k).id := sll_rec.id;
1834: END LOOP;
1835: okl_rule_pub.delete_rule(
1836: p_api_version => 1.0,
1837: p_init_msg_list => OKC_API.G_FALSE,
1838: x_return_status => x_return_status,
1839: x_msg_count => x_msg_count,
1840: x_msg_data => x_msg_data,
1841: p_rulv_tbl => l_rulv_tbl

Line 1892: p_init_msg_list => Okc_Api.G_FALSE,

1888: END IF;
1889:
1890: Okl_Rule_Pub.create_rule(
1891: p_api_version => 1.0,
1892: p_init_msg_list => Okc_Api.G_FALSE,
1893: x_return_status => x_return_status,
1894: x_msg_count => x_msg_count,
1895: x_msg_data => x_msg_data,
1896: p_rulv_rec => l_slh_rulv_rec,

Line 1904: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1900: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1901: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH status: '||x_return_status);
1902: END IF;
1903:
1904: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1905: RAISE update_failed;
1906: END IF;
1907:
1908: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 1961: p_init_msg_list => Okc_Api.G_FALSE,

1957:
1958: l_match_found := 'N';
1959: Okl_Rule_Pub.create_rule(
1960: p_api_version => 1.0,
1961: p_init_msg_list => Okc_Api.G_FALSE,
1962: x_return_status => x_return_status,
1963: x_msg_count => x_msg_count,
1964: x_msg_data => x_msg_data,
1965: p_rulv_tbl => l_sll_rulv_tbl,

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

1965: p_rulv_tbl => l_sll_rulv_tbl,
1966: x_rulv_tbl => x_sll_rulv_tbl
1967: );
1968:
1969: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1970: RAISE update_failed;
1971: END IF;
1972:
1973: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 2094: p_init_msg_list => Okc_Api.G_FALSE,

2090:
2091: IF (l_previous_lasll_exists) THEN
2092: Okl_Rule_Pub.create_rule(
2093: p_api_version => 1.0,
2094: p_init_msg_list => Okc_Api.G_FALSE,
2095: x_return_status => x_return_status,
2096: x_msg_count => x_msg_count,
2097: x_msg_data => x_msg_data,
2098: p_rulv_tbl => l_sll_rulv_tbl,

Line 2102: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

2098: p_rulv_tbl => l_sll_rulv_tbl,
2099: x_rulv_tbl => x_sll_rulv_tbl
2100: );
2101:
2102: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2103: RAISE update_failed;
2104: END IF;
2105:
2106: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 2163: p_init_msg_list => OKC_API.G_FALSE,

2159: END IF;
2160: l_rulv_rec.id := l_slh_id;
2161: okl_rule_pub.delete_rule(
2162: p_api_version => 1.0,
2163: p_init_msg_list => OKC_API.G_FALSE,
2164: x_return_status => x_return_status,
2165: x_msg_count => x_msg_count,
2166: x_msg_data => x_msg_data,
2167: p_rulv_rec => l_rulv_rec

Line 2186: p_init_msg_list => OKC_API.G_FALSE,

2182: l_rulv_tbl(k).id := sll_rec.id;
2183: END LOOP;
2184: okl_rule_pub.delete_rule(
2185: p_api_version => 1.0,
2186: p_init_msg_list => OKC_API.G_FALSE,
2187: x_return_status => x_return_status,
2188: x_msg_count => x_msg_count,
2189: x_msg_data => x_msg_data,
2190: p_rulv_tbl => l_rulv_tbl

Line 2241: p_init_msg_list => Okc_Api.G_FALSE,

2237: END IF;
2238:
2239: Okl_Rule_Pub.create_rule(
2240: p_api_version => 1.0,
2241: p_init_msg_list => Okc_Api.G_FALSE,
2242: x_return_status => x_return_status,
2243: x_msg_count => x_msg_count,
2244: x_msg_data => x_msg_data,
2245: p_rulv_rec => l_slh_rulv_rec,

Line 2253: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

2249: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2250: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'SLH status: '||x_return_status);
2251: END IF;
2252:
2253: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2254: RAISE update_failed;
2255: END IF;
2256:
2257: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 2311: p_init_msg_list => Okc_Api.G_FALSE,

2307:
2308: l_match_found := 'N';
2309: Okl_Rule_Pub.create_rule(
2310: p_api_version => 1.0,
2311: p_init_msg_list => Okc_Api.G_FALSE,
2312: x_return_status => x_return_status,
2313: x_msg_count => x_msg_count,
2314: x_msg_data => x_msg_data,
2315: p_rulv_tbl => l_sll_rulv_tbl,

Line 2319: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

2315: p_rulv_tbl => l_sll_rulv_tbl,
2316: x_rulv_tbl => x_sll_rulv_tbl
2317: );
2318:
2319: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
2320: RAISE update_failed;
2321: END IF;
2322:
2323: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 2552: p_init_msg_list => OKC_API.G_FALSE,

2548:
2549: l_cvmv_rec.chr_id := p_khr_id;
2550: okl_version_pub.version_contract(
2551: p_api_version => 1.0,
2552: p_init_msg_list => OKC_API.G_FALSE,
2553: x_return_status => x_return_status,
2554: x_msg_count => x_msg_count,
2555: x_msg_data => x_msg_data,
2556: p_cvmv_rec => l_cvmv_rec,

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

2557: p_commit => OKL_API.G_FALSE,
2558: x_cvmv_rec => x_cvmv_rec
2559: );
2560:
2561: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2562: RAISE rebook_contract_failed;
2563: END IF;
2564:
2565: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 3331: x_return_status := OKC_API.G_RET_STS_SUCCESS;

3327: IF (G_DEBUG_ENABLED = 'Y') THEN
3328: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
3329: END IF;
3330:
3331: x_return_status := OKC_API.G_RET_STS_SUCCESS;
3332:
3333: --
3334: -- Check for Securitized Contract
3335: --

Line 3341: p_init_msg_list => OKC_API.G_FALSE,

3337: LOOP
3338:
3339: Okl_Securitization_Pvt.check_khr_securitized(
3340: p_api_version => 1.0,
3341: p_init_msg_list => OKC_API.G_FALSE,
3342: x_return_status => x_return_status,
3343: x_msg_count => x_msg_count,
3344: x_msg_data => x_msg_data,
3345: p_khr_id => p_chr_id,

Line 3371: p_init_msg_list => OKC_API.G_FALSE,

3367:
3368: IF (l_disb_strm_tbl.COUNT > 0) THEN
3369: okl_streams_pub.update_streams(
3370: p_api_version => 1.0,
3371: p_init_msg_list => OKC_API.G_FALSE,
3372: x_return_status => x_return_status,
3373: x_msg_count => x_msg_count,
3374: x_msg_data => x_msg_data,
3375: p_stmv_tbl => l_disb_strm_tbl,

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

3375: p_stmv_tbl => l_disb_strm_tbl,
3376: x_stmv_tbl => x_disb_strm_tbl
3377: );
3378:
3379: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3380: RAISE secu_failed;
3381: END IF;
3382: END IF;
3383:

Line 3414: p_init_msg_list => OKC_API.G_FALSE,

3410: --Bug 6740000 ssdeshpa Start
3411: IF(l_deal_type IN('LEASEOP','LEASEDF','LEASEST')) THEN
3412: Okl_Securitization_Pvt.modify_pool_contents(
3413: p_api_version => 1.0,
3414: p_init_msg_list => OKC_API.G_FALSE,
3415: x_return_status => x_return_status,
3416: x_msg_count => x_msg_count,
3417: x_msg_data => x_msg_data,
3418: p_transaction_reason => Okl_Securitization_Pvt.G_TRX_REASON_ASSET_TERMINATION,

Line 3428: p_init_msg_list => OKC_API.G_FALSE,

3424: );
3425: ELSIF(l_deal_type IN('LOAN', 'LOAN-REVOLVING')) THEN
3426: Okl_Securitization_Pvt.modify_pool_contents(
3427: p_api_version => 1.0,
3428: p_init_msg_list => OKC_API.G_FALSE,
3429: x_return_status => x_return_status,
3430: x_msg_count => x_msg_count,
3431: x_msg_data => x_msg_data,
3432: p_transaction_reason => Okl_Securitization_Pvt.G_TRX_REASON_ASSET_TERMINATION,

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

3437: p_stream_type_subclass => 'LOAN_PAYMENT'
3438: );
3439: END IF;
3440: --Bug 6740000 ssdeshpa End
3441: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3442: RAISE secu_failed;
3443: END IF;
3444:
3445: IF l_alt_purchase THEN

Line 3448: p_init_msg_list => OKC_API.G_FALSE,

3444:
3445: IF l_alt_purchase THEN
3446: Okl_Securitization_Pvt.modify_pool_contents(
3447: p_api_version => 1.0,
3448: p_init_msg_list => OKC_API.G_FALSE,
3449: x_return_status => x_return_status,
3450: x_msg_count => x_msg_count,
3451: x_msg_data => x_msg_data,
3452: p_transaction_reason => Okl_Securitization_Pvt.G_TRX_REASON_ASSET_DISPOSAL,

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

3455: p_transaction_date => l_okl_tcn_type_rec.date_transaction_occurred,
3456: p_effective_date => l_okl_tcn_type_rec.date_transaction_occurred,
3457: p_stream_type_subclass => 'RESIDUAL'
3458: );
3459: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3460: RAISE secu_failed;
3461: END IF;
3462: END IF;
3463:

Line 3479: p_init_msg_list => OKC_API.G_FALSE,

3475: -- Create Pool transaction for Mass Rebook
3476: --
3477: Okl_Securitization_Pvt.modify_pool_contents(
3478: p_api_version => 1.0,
3479: p_init_msg_list => OKC_API.G_FALSE,
3480: x_return_status => x_return_status,
3481: x_msg_count => x_msg_count,
3482: x_msg_data => x_msg_data,
3483: p_transaction_reason => Okl_Securitization_Pvt.G_TRX_REASON_CONTRACT_REBOOK,

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

3485: p_transaction_date => l_okl_trbk_txn_rec.date_transaction_occurred,
3486: p_effective_date => l_okl_trbk_txn_rec.date_transaction_occurred
3487: );
3488:
3489: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3490: RAISE secu_failed;
3491: END IF;
3492:
3493: -- Bug# 4775555: Start

Line 3512: p_init_msg_list => OKC_API.G_FALSE,

3508:
3509: IF (l_accu_strm_tbl.COUNT > 0) THEN
3510: okl_streams_pub.update_streams(
3511: p_api_version => 1.0,
3512: p_init_msg_list => OKC_API.G_FALSE,
3513: x_return_status => x_return_status,
3514: x_msg_count => x_msg_count,
3515: x_msg_data => x_msg_data,
3516: p_stmv_tbl => l_accu_strm_tbl,

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

3516: p_stmv_tbl => l_accu_strm_tbl,
3517: x_stmv_tbl => x_accu_strm_tbl
3518: );
3519:
3520: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3521: RAISE secu_failed;
3522: END IF;
3523: END IF;
3524: */

Line 3532: p_init_msg_list => OKC_API.G_FALSE,

3528: -- Regenerate disbursement streams
3529: --
3530: okl_stream_generator_pvt.create_disb_streams(
3531: p_api_version => 1.0,
3532: p_init_msg_list => OKC_API.G_FALSE,
3533: x_return_status => x_return_status,
3534: x_msg_count => x_msg_count,
3535: x_msg_data => x_msg_data,
3536: p_contract_id => p_chr_id

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

3535: x_msg_data => x_msg_data,
3536: p_contract_id => p_chr_id
3537: );
3538:
3539: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3540: RAISE secu_failed;
3541: END IF;
3542:
3543: -- Bug# 4775555

Line 3549: p_init_msg_list => OKC_API.G_FALSE,

3545: -- Regenerate Present Value Disbursement streams
3546: --
3547: okl_stream_generator_pvt.create_pv_streams(
3548: p_api_version => 1.0,
3549: p_init_msg_list => OKC_API.G_FALSE,
3550: x_return_status => x_return_status,
3551: x_msg_count => x_msg_count,
3552: x_msg_data => x_msg_data,
3553: p_contract_id => p_chr_id

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

3552: x_msg_data => x_msg_data,
3553: p_contract_id => p_chr_id
3554: );
3555:
3556: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3557: RAISE secu_failed;
3558: END IF;
3559: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3560: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After regerating Present Value Disbursement streams');

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

3571: x_msg_data => x_msg_data,
3572: p_khr_id => p_chr_id
3573: );
3574:
3575: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3576: RAISE secu_failed;
3577: END IF;
3578:
3579:

Line 3589: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

3585: WHEN secu_failed THEN
3586: NULL; -- excception is handled by caller
3587:
3588: WHEN OTHERS THEN
3589: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
3590: p_api_name => l_api_name,
3591: p_pkg_name => G_PKG_NAME,
3592: p_exc_name => 'OTHERS',
3593: x_msg_count => x_msg_count,

Line 6248: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

6244: ------------------------------------------------------------------------------
6245: /* Added for CR */
6246: PROCEDURE create_mass_rbk_set_values(
6247: p_api_version IN NUMBER,
6248: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
6249: x_return_status OUT NOCOPY VARCHAR2,
6250: x_msg_count OUT NOCOPY NUMBER,
6251: x_msg_data OUT NOCOPY VARCHAR2,
6252: p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE,