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 2491: p_init_msg_list => OKC_API.G_FALSE,

2487:
2488: l_cvmv_rec.chr_id := p_khr_id;
2489: okl_version_pub.version_contract(
2490: p_api_version => 1.0,
2491: p_init_msg_list => OKC_API.G_FALSE,
2492: x_return_status => x_return_status,
2493: x_msg_count => x_msg_count,
2494: x_msg_data => x_msg_data,
2495: p_cvmv_rec => l_cvmv_rec,

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

2496: p_commit => OKL_API.G_FALSE,
2497: x_cvmv_rec => x_cvmv_rec
2498: );
2499:
2500: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2501: RAISE rebook_contract_failed;
2502: END IF;
2503:
2504: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 3207: x_return_status := OKC_API.G_RET_STS_SUCCESS;

3203: IF (G_DEBUG_ENABLED = 'Y') THEN
3204: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
3205: END IF;
3206:
3207: x_return_status := OKC_API.G_RET_STS_SUCCESS;
3208:
3209: --
3210: -- Check for Securitized Contract
3211: --

Line 3217: p_init_msg_list => OKC_API.G_FALSE,

3213: LOOP
3214:
3215: Okl_Securitization_Pvt.check_khr_securitized(
3216: p_api_version => 1.0,
3217: p_init_msg_list => OKC_API.G_FALSE,
3218: x_return_status => x_return_status,
3219: x_msg_count => x_msg_count,
3220: x_msg_data => x_msg_data,
3221: p_khr_id => p_chr_id,

Line 3247: p_init_msg_list => OKC_API.G_FALSE,

3243:
3244: IF (l_disb_strm_tbl.COUNT > 0) THEN
3245: okl_streams_pub.update_streams(
3246: p_api_version => 1.0,
3247: p_init_msg_list => OKC_API.G_FALSE,
3248: x_return_status => x_return_status,
3249: x_msg_count => x_msg_count,
3250: x_msg_data => x_msg_data,
3251: p_stmv_tbl => l_disb_strm_tbl,

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

3251: p_stmv_tbl => l_disb_strm_tbl,
3252: x_stmv_tbl => x_disb_strm_tbl
3253: );
3254:
3255: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3256: RAISE secu_failed;
3257: END IF;
3258: END IF;
3259:

Line 3290: p_init_msg_list => OKC_API.G_FALSE,

3286: --Bug 6740000 ssdeshpa Start
3287: IF(l_deal_type IN('LEASEOP','LEASEDF','LEASEST')) THEN
3288: Okl_Securitization_Pvt.modify_pool_contents(
3289: p_api_version => 1.0,
3290: p_init_msg_list => OKC_API.G_FALSE,
3291: x_return_status => x_return_status,
3292: x_msg_count => x_msg_count,
3293: x_msg_data => x_msg_data,
3294: p_transaction_reason => Okl_Securitization_Pvt.G_TRX_REASON_ASSET_TERMINATION,

Line 3304: p_init_msg_list => OKC_API.G_FALSE,

3300: );
3301: ELSIF(l_deal_type IN('LOAN', 'LOAN-REVOLVING')) THEN
3302: Okl_Securitization_Pvt.modify_pool_contents(
3303: p_api_version => 1.0,
3304: p_init_msg_list => OKC_API.G_FALSE,
3305: x_return_status => x_return_status,
3306: x_msg_count => x_msg_count,
3307: x_msg_data => x_msg_data,
3308: p_transaction_reason => Okl_Securitization_Pvt.G_TRX_REASON_ASSET_TERMINATION,

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

3313: p_stream_type_subclass => 'LOAN_PAYMENT'
3314: );
3315: END IF;
3316: --Bug 6740000 ssdeshpa End
3317: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3318: RAISE secu_failed;
3319: END IF;
3320:
3321: IF l_alt_purchase THEN

Line 3324: p_init_msg_list => OKC_API.G_FALSE,

3320:
3321: IF l_alt_purchase THEN
3322: Okl_Securitization_Pvt.modify_pool_contents(
3323: p_api_version => 1.0,
3324: p_init_msg_list => OKC_API.G_FALSE,
3325: x_return_status => x_return_status,
3326: x_msg_count => x_msg_count,
3327: x_msg_data => x_msg_data,
3328: p_transaction_reason => Okl_Securitization_Pvt.G_TRX_REASON_ASSET_DISPOSAL,

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

3331: p_transaction_date => l_okl_tcn_type_rec.date_transaction_occurred,
3332: p_effective_date => l_okl_tcn_type_rec.date_transaction_occurred,
3333: p_stream_type_subclass => 'RESIDUAL'
3334: );
3335: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3336: RAISE secu_failed;
3337: END IF;
3338: END IF;
3339:

Line 3355: p_init_msg_list => OKC_API.G_FALSE,

3351: -- Create Pool transaction for Mass Rebook
3352: --
3353: Okl_Securitization_Pvt.modify_pool_contents(
3354: p_api_version => 1.0,
3355: p_init_msg_list => OKC_API.G_FALSE,
3356: x_return_status => x_return_status,
3357: x_msg_count => x_msg_count,
3358: x_msg_data => x_msg_data,
3359: p_transaction_reason => Okl_Securitization_Pvt.G_TRX_REASON_CONTRACT_REBOOK,

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

3361: p_transaction_date => l_okl_trbk_txn_rec.date_transaction_occurred,
3362: p_effective_date => l_okl_trbk_txn_rec.date_transaction_occurred
3363: );
3364:
3365: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3366: RAISE secu_failed;
3367: END IF;
3368:
3369: -- Bug# 4775555: Start

Line 3388: p_init_msg_list => OKC_API.G_FALSE,

3384:
3385: IF (l_accu_strm_tbl.COUNT > 0) THEN
3386: okl_streams_pub.update_streams(
3387: p_api_version => 1.0,
3388: p_init_msg_list => OKC_API.G_FALSE,
3389: x_return_status => x_return_status,
3390: x_msg_count => x_msg_count,
3391: x_msg_data => x_msg_data,
3392: p_stmv_tbl => l_accu_strm_tbl,

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

3392: p_stmv_tbl => l_accu_strm_tbl,
3393: x_stmv_tbl => x_accu_strm_tbl
3394: );
3395:
3396: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3397: RAISE secu_failed;
3398: END IF;
3399: END IF;
3400: */

Line 3408: p_init_msg_list => OKC_API.G_FALSE,

3404: -- Regenerate disbursement streams
3405: --
3406: okl_stream_generator_pvt.create_disb_streams(
3407: p_api_version => 1.0,
3408: p_init_msg_list => OKC_API.G_FALSE,
3409: x_return_status => x_return_status,
3410: x_msg_count => x_msg_count,
3411: x_msg_data => x_msg_data,
3412: p_contract_id => p_chr_id

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

3411: x_msg_data => x_msg_data,
3412: p_contract_id => p_chr_id
3413: );
3414:
3415: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3416: RAISE secu_failed;
3417: END IF;
3418:
3419: -- Bug# 4775555

Line 3425: p_init_msg_list => OKC_API.G_FALSE,

3421: -- Regenerate Present Value Disbursement streams
3422: --
3423: okl_stream_generator_pvt.create_pv_streams(
3424: p_api_version => 1.0,
3425: p_init_msg_list => OKC_API.G_FALSE,
3426: x_return_status => x_return_status,
3427: x_msg_count => x_msg_count,
3428: x_msg_data => x_msg_data,
3429: p_contract_id => p_chr_id

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

3428: x_msg_data => x_msg_data,
3429: p_contract_id => p_chr_id
3430: );
3431:
3432: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3433: RAISE secu_failed;
3434: END IF;
3435: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3436: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After regerating Present Value Disbursement streams');

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

3447: x_msg_data => x_msg_data,
3448: p_khr_id => p_chr_id
3449: );
3450:
3451: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3452: RAISE secu_failed;
3453: END IF;
3454:
3455:

Line 3465: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

3461: WHEN secu_failed THEN
3462: NULL; -- excception is handled by caller
3463:
3464: WHEN OTHERS THEN
3465: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
3466: p_api_name => l_api_name,
3467: p_pkg_name => G_PKG_NAME,
3468: p_exc_name => 'OTHERS',
3469: x_msg_count => x_msg_count,

Line 6108: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

6104: ------------------------------------------------------------------------------
6105: /* Added for CR */
6106: PROCEDURE create_mass_rbk_set_values(
6107: p_api_version IN NUMBER,
6108: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
6109: x_return_status OUT NOCOPY VARCHAR2,
6110: x_msg_count OUT NOCOPY NUMBER,
6111: x_msg_data OUT NOCOPY VARCHAR2,
6112: p_request_name IN OKL_MASS_RBK_CRITERIA.REQUEST_NAME%TYPE,