[Home] [Help]
7:
8: -- Global Variables
9: G_INIT_NUMBER NUMBER := -9999;
10: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_CONTRACT_REBOOK_PVT';
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
12: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
13:
14: --Bug# 4212626
15: G_INSURANCE_LSE_ID CONSTANT NUMBER := 47;
96: x_msg_out VARCHAR2(2000);
97:
98: BEGIN
99:
100: okl_api.end_activity(
101: X_msg_count => x_msg_count,
102: X_msg_data => x_msg_data
103: );
104:
288: x_chrv_rec.LAST_UPDATED_BY,
289: x_chrv_rec.LAST_UPDATE_DATE,
290: x_chrv_rec.LAST_UPDATE_LOGIN;
291: IF okc_chrv_pk_csr%NOTFOUND THEN
292: x_return_status := OKL_API.G_RET_STS_ERROR;
293: END IF;
294: CLOSE okc_chrv_pk_csr;
295: RETURN(x_chrv_rec);
296: EXCEPTION
295: RETURN(x_chrv_rec);
296: EXCEPTION
297: WHEN OTHERS THEN
298: -- store SQL error message on message stack for caller
299: OKL_API.set_message(
300: G_APP_NAME,
301: G_UNEXPECTED_ERROR,
302: 'SQLcode',
303: SQLCODE,
303: SQLCODE,
304: 'SQLerrm',
305: SQLERRM);
306: -- notify caller of an UNEXPECTED error
307: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
308: -- if the cursor is open
309: IF okc_chrv_pk_csr%ISOPEN THEN
310: CLOSE okc_chrv_pk_csr;
311: END IF;
383: l_okl_k_headers_v_pk okl_k_headers_v_pk_csr%ROWTYPE;
384: l_khrv_rec khrv_rec_type;
385: BEGIN
386:
387: x_return_status := OKL_API.G_RET_STS_SUCCESS;
388: -- Get current database values
389: OPEN okl_k_headers_v_pk_csr (p_khr_id);
390: FETCH okl_k_headers_v_pk_csr INTO
391: l_khrv_rec.ID,
446: l_khrv_rec.PREFUNDING_ELIGIBLE_YN,
447: l_khrv_rec.REVOLVING_CREDIT_YN
448: ;
449: IF okl_k_headers_v_pk_csr%NOTFOUND THEN
450: x_return_status := OKL_API.G_RET_STS_ERROR;
451: END IF;
452: CLOSE okl_k_headers_v_pk_csr;
453: RETURN(l_khrv_rec);
454: EXCEPTION
453: RETURN(l_khrv_rec);
454: EXCEPTION
455: WHEN OTHERS THEN
456: -- store SQL error message on message stack for caller
457: OKL_API.set_message(
458: G_APP_NAME,
459: G_UNEXPECTED_ERROR,
460: 'SQLcode',
461: SQLCODE,
465: -- if the cursor is open
466: IF okl_k_headers_v_pk_csr%ISOPEN THEN
467: CLOSE okl_k_headers_v_pk_csr;
468: END IF;
469: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
470: END get_khrv_rec;
471:
472: ------------------------------------------------------------------------------
473: -- PROCEDURE validate_rebook_reason
514: RETURN;
515:
516: EXCEPTION
517: WHEN rebook_failed THEN
518: okl_api.set_message(
519: G_APP_NAME,
520: G_INVALID_VALUE,
521: 'COL_NAME',
522: 'REBOOK REASON'
724: x_return_status => x_return_status,
725: x_primary_sty_id => x_billing_adj_sty_id
726: );
727:
728: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
729: RAISE copy_failed;
730: END IF;
731:
732: -- Get Stream id for purpose = INVESTOR_DISB_ADJUSTMENT
741: x_return_status => x_return_status,
742: x_primary_sty_id => x_inv_disb_adj_sty_id
743: );
744:
745: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
746: RAISE copy_failed;
747: END IF;
748: */
749:
861: OPEN strm_hdr_csr(p_rebook_chr_id);
862: FETCH strm_hdr_csr INTO l_stmv_rec;
863:
864: IF strm_hdr_csr%NOTFOUND THEN
865: okl_api.set_message(
866: G_APP_NAME,
867: G_LLA_NO_STREAM
868: );
869:
1058:
1059: END LOOP;
1060:
1061: IF (l_no_of_ele = 0) THEN
1062: okl_api.set_message(
1063: G_APP_NAME,
1064: G_LLA_NO_STREAM_ELEMENT
1065: );
1066: RAISE copy_failed;
1197: /*
1198: OPEN strm_csr(p_chr_id);
1199: FETCH strm_csr INTO l_id;
1200: IF strm_csr%NOTFOUND THEN
1201: okl_api.set_message(
1202: G_APP_NAME,
1203: G_LLA_NO_STREAM
1204: );
1205: debug_message('Failed');
1733: l_rgpv_rec.rgp_type := 'KRG';
1734:
1735: OKL_RULE_PUB.create_rule_group(
1736: p_api_version => 1.0,
1737: p_init_msg_list => OKL_API.G_FALSE,
1738: x_return_status => x_return_status,
1739: x_msg_count => x_msg_count,
1740: x_msg_data => x_msg_data,
1741: p_rgpv_rec => l_rgpv_rec,
1761: -- Get SLH Rule from Rebook Contract
1762: --
1763: Okl_Rule_Apis_Pvt.Get_Contract_Rules(
1764: p_api_version => 1.0,
1765: p_init_msg_list => Okl_Api.G_FALSE,
1766: p_rgpv_rec => l_rebook_rgpv_rec,
1767: p_rdf_code => 'LASLH',
1768: x_return_status => x_return_status,
1769: x_msg_count => x_msg_count,
2049: -- Get SLH Rule from Rebook Contract
2050: --
2051: Okl_Rule_Apis_Pvt.Get_Contract_Rules(
2052: p_api_version => 1.0,
2053: p_init_msg_list => Okl_Api.G_FALSE,
2054: p_rgpv_rec => l_rebook_rgpv_rec,
2055: p_rdf_code => 'LASLH',
2056: x_return_status => x_return_status,
2057: x_msg_count => x_msg_count,
2282: BEGIN
2283: IF (G_DEBUG_ENABLED = 'Y') THEN
2284: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2285: END IF;
2286: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2287: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2288: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
2289: END IF;
2290:
2306: --
2307:
2308: okl_party_payments_pvt.create_party_payment_hdr(
2309: p_api_version => 1.0,
2310: p_init_msg_list => OKL_API.G_FALSE,
2311: x_return_status => x_return_status,
2312: x_msg_count => x_msg_count,
2313: x_msg_data => x_msg_data,
2314: p_pphv_rec => l_pphv_rec,
2313: x_msg_data => x_msg_data,
2314: p_pphv_rec => l_pphv_rec,
2315: x_pphv_rec => x_pphv_rec
2316: );
2317: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2318: RAISE sync_party_failed;
2319: END IF;
2320: ELSE
2321: -- Update header rec
2325: l_pphv_rec.payout_basis_formula := rbk_evg_hdr_rec.payout_basis_formula;
2326: l_pphv_rec.passthru_stream_type_id := rbk_evg_hdr_rec.passthru_stream_type_id;
2327: okl_party_payments_pvt.update_party_payment_hdr(
2328: p_api_version => 1.0,
2329: p_init_msg_list => OKL_API.G_FALSE,
2330: x_return_status => x_return_status,
2331: x_msg_count => x_msg_count,
2332: x_msg_data => x_msg_data,
2333: p_pphv_rec => l_pphv_rec,
2332: x_msg_data => x_msg_data,
2333: p_pphv_rec => l_pphv_rec,
2334: x_pphv_rec => x_pphv_rec
2335: );
2336: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2337: RAISE sync_party_failed;
2338: END IF;
2339: END IF;
2340: CLOSE orig_evg_hdr_csr;
2394: l_ppydv_u_rec.payment_basis := rbk_evg_dtl_rec.payment_basis;
2395:
2396: okl_party_payments_pvt.update_party_payment_dtls(
2397: p_api_version => 1.0,
2398: p_init_msg_list => OKL_API.G_FALSE,
2399: x_return_status => x_return_status,
2400: x_msg_count => x_msg_count,
2401: x_msg_data => x_msg_data,
2402: p_ppydv_rec => l_ppydv_u_rec,
2406: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2407: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Update Status: '||x_return_status);
2408: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'x_ppydv_rec.id: '||x_ppydv_rec.id);
2409: END IF;
2410: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2411: RAISE sync_party_failed;
2412: END IF;
2413: END LOOP;
2414: --Bug# 4880939
2466: l_ppydv_c_rec.payment_basis := rbk_evg_dtl_rec.payment_basis;
2467:
2468: okl_party_payments_pvt.create_party_payment_dtls(
2469: p_api_version => 1.0,
2470: p_init_msg_list => OKL_API.G_FALSE,
2471: x_return_status => x_return_status,
2472: x_msg_count => x_msg_count,
2473: x_msg_data => x_msg_data,
2474: p_ppydv_rec => l_ppydv_c_rec,
2478: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2479: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Create Status: '||x_return_status);
2480: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'x_ppydv_rec.id: '||x_ppydv_rec.id);
2481: END IF;
2482: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2483: RAISE sync_party_failed;
2484: END IF;
2485: END LOOP;
2486: --Bug# 4880939
2493: LOOP
2494:
2495: okl_copy_contract_pub.copy_party_roles(
2496: p_api_version => 1.0,
2497: p_init_msg_list => OKL_API.G_FALSE,
2498: x_return_status => x_return_status,
2499: x_msg_count => x_msg_count,
2500: x_msg_data => x_msg_data,
2501: p_cpl_id => rebook_party_rec.id,
2504: p_rle_code => rebook_party_rec.rle_code,
2505: x_cpl_id => x_cpl_id
2506: );
2507:
2508: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2509: RAISE sync_party_failed;
2510: END IF;
2511:
2512: FOR party_rule_rec IN party_rule_csr (p_rebook_chr_id,
2516: -- Now copy Rules attached to the party copied above
2517: --
2518: okl_copy_contract_pub.copy_rules (
2519: p_api_version => 1.0,
2520: p_init_msg_list => OKL_API.G_FALSE,
2521: x_return_status => x_return_status,
2522: x_msg_count => x_msg_count,
2523: x_msg_data => x_msg_data,
2524: p_rgp_id => party_rule_rec.rgp_id,
2527: p_to_template_yn => 'N',
2528: x_rgp_id => x_rgp_id
2529: );
2530:
2531: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2532: RAISE sync_party_failed;
2533: END IF;
2534: END LOOP; -- rule
2535:
2629: l_khrv_rec := get_khrv_rec(
2630: p_khr_id => p_orig_chr_id,
2631: x_return_status => x_return_status
2632: );
2633: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2634: RAISE sync_failed;
2635: END IF;
2636:
2637: l_chrv_rec := get_chrv_rec(
2637: l_chrv_rec := get_chrv_rec(
2638: p_chr_id => p_orig_chr_id,
2639: x_return_status => x_return_status
2640: );
2641: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2642: RAISE sync_failed;
2643: END IF;
2644:
2645: FOR header_rec IN header_csr(p_rebook_chr_id)
2727: PROCEDURE sync_passthru_party(
2728: x_return_status OUT NOCOPY VARCHAR2
2729: ) IS
2730: BEGIN
2731: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2732: END sync_passthru_party;
2733:
2734: ------------------------------------------------------------------------------
2735: -- PROCEDURE process_pth_detail
2795: IF (G_DEBUG_ENABLED = 'Y') THEN
2796: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2797: END IF;
2798:
2799: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2800: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2801: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
2802: END IF;
2803:
2842: l_ppydv_rec.payment_basis := rbk_pth_detail_rec.payment_basis;
2843:
2844: okl_party_payments_pvt.create_party_payment_dtls(
2845: p_api_version => 1.0,
2846: p_init_msg_list => OKL_API.G_FALSE,
2847: x_return_status => x_return_status,
2848: x_msg_count => x_msg_count,
2849: x_msg_data => x_msg_data,
2850: p_ppydv_rec => l_ppydv_rec,
2853: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2854: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'>>>> Pth detail created: '||x_return_status);
2855: END IF;
2856:
2857: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2858: RAISE process_pth_failed;
2859: END IF;
2860: ELSE
2861: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2882: l_ppydv_rec.payment_basis := rbk_pth_detail_rec.payment_basis;
2883:
2884: okl_party_payments_pvt.update_party_payment_dtls(
2885: p_api_version => 1.0,
2886: p_init_msg_list => OKL_API.G_FALSE,
2887: x_return_status => x_return_status,
2888: x_msg_count => x_msg_count,
2889: x_msg_data => x_msg_data,
2890: p_ppydv_rec => l_ppydv_rec,
2893: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2894: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'>>>> Pth detail updated: '||x_return_status);
2895: END IF;
2896:
2897: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2898: RAISE process_pth_failed;
2899: END IF;
2900: -- update passthru detail
2901: END IF;
2908:
2909: EXCEPTION
2910:
2911: WHEN process_pth_failed THEN
2912: x_return_status := OKL_API.G_RET_STS_ERROR;
2913: END process_pth_detail;
2914:
2915: ------------------------------------------------------------------------------
2916: -- PROCEDURE sync_passthru_detail
3039: BEGIN
3040: IF (G_DEBUG_ENABLED = 'Y') THEN
3041: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
3042: END IF;
3043: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3044: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3045: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
3046: END IF;
3047:
3100:
3101: IF (l_c_pphv_tbl.COUNT > 0) THEN
3102: okl_party_payments_pvt.create_party_payment_hdr(
3103: p_api_version => 1.0,
3104: p_init_msg_list => OKL_API.G_FALSE,
3105: x_return_status => x_return_status,
3106: x_msg_count => x_msg_count,
3107: x_msg_data => x_msg_data,
3108: p_pphv_tbl => l_c_pphv_tbl,
3110: );
3111: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3112: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'PTH header insert for: '||pth_rec.orig_system_id1||': '||x_return_status);
3113: END IF;
3114: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3115: RAISE pth_failed;
3116: END IF;
3117: END IF;
3118: IF (l_u_pphv_tbl.COUNT > 0) THEN
3117: END IF;
3118: IF (l_u_pphv_tbl.COUNT > 0) THEN
3119: okl_party_payments_pvt.update_party_payment_hdr(
3120: p_api_version => 1.0,
3121: p_init_msg_list => OKL_API.G_FALSE,
3122: x_return_status => x_return_status,
3123: x_msg_count => x_msg_count,
3124: x_msg_data => x_msg_data,
3125: p_pphv_tbl => l_u_pphv_tbl,
3127: );
3128: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3129: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'PTH header update for: '||pth_rec.orig_system_id1||': '||x_return_status);
3130: END IF;
3131: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3132: RAISE pth_failed;
3133: END IF;
3134: END IF;
3135:
3161: -- okc_k_party_roles_b and okl_k_party_roles
3162: /*
3163: okl_okc_migration_pvt.create_k_party_role(
3164: p_api_version => 1.0,
3165: p_init_msg_list => OKL_API.G_FALSE,
3166: x_return_status => x_return_status,
3167: x_msg_count => x_msg_count,
3168: x_msg_data => x_msg_data,
3169: p_cplv_rec => l_cplv_rec,
3171: */
3172:
3173: okl_k_party_roles_pvt.create_k_party_role(
3174: p_api_version => 1.0,
3175: p_init_msg_list => OKL_API.G_FALSE,
3176: x_return_status => x_return_status,
3177: x_msg_count => x_msg_count,
3178: x_msg_data => x_msg_data,
3179: p_cplv_rec => l_cplv_rec,
3184: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3185: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'>> Vendor '||pth_vendor_rec.vendor_id||' created: '||x_return_status);
3186: END IF;
3187:
3188: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3189: RAISE pth_failed;
3190: END IF;
3191:
3192: process_pth_detail(
3201: p_rbk_cle_id => pth_rec.id,
3202: p_rbk_cpl_id => pth_vendor_rec.id
3203: );
3204:
3205: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3206: RAISE pth_failed;
3207: END IF;
3208:
3209: ELSE
3223: p_rbk_cle_id => pth_rec.id,
3224: p_rbk_cpl_id => pth_vendor_rec.id
3225: );
3226:
3227: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3228: RAISE pth_failed;
3229: END IF;
3230:
3231: END IF; -- orig_vendor_csr
3244: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'>> Vendor to be deleted cpl_id: '||rbk_del_vendor_rec.id);
3245: END IF;
3246: okl_maintain_fee_pvt.delete_passthru_party(
3247: p_api_version => 1.0,
3248: p_init_msg_list => OKL_API.G_FALSE,
3249: x_return_status => x_return_status,
3250: x_msg_count => x_msg_count,
3251: x_msg_data => x_msg_data,
3252: p_cpl_id => rbk_del_vendor_rec.id
3254: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3255: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Vendor deleted: '||x_return_status);
3256: END IF;
3257:
3258: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3259: RAISE pth_failed;
3260: END IF;
3261:
3262: END LOOP; -- rbk_del_vendor_rec
3264: END LOOP; -- pth_csr
3265:
3266: EXCEPTION
3267: WHEN pth_failed THEN
3268: x_return_status := OKL_API.G_RET_STS_ERROR;
3269: END sync_passthru_detail;
3270:
3271: ------------------------------------------------------------------------------
3272: -- PROCEDURE sync_fee_line
3627: IF (G_DEBUG_ENABLED = 'Y') THEN
3628: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
3629: END IF;
3630:
3631: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3632: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3633: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
3634: END IF;
3635:
3650:
3651: -- Make Fee top-line ABANDONED
3652: okl_contract_pub.update_contract_line(
3653: p_api_version => 1.0,
3654: p_init_msg_list => OKL_API.G_FALSE,
3655: x_return_status => x_return_status,
3656: x_msg_count => x_msg_count,
3657: x_msg_data => x_msg_data,
3658: p_clev_rec => l_clev_rec,
3679: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Sub line delete: '||fee_subline_rec.id);
3680: END IF;
3681: okl_contract_pub.update_contract_line(
3682: p_api_version => 1.0,
3683: p_init_msg_list => OKL_API.G_FALSE,
3684: x_return_status => x_return_status,
3685: x_msg_count => x_msg_count,
3686: x_msg_data => x_msg_data,
3687: p_clev_rec => l_clev_rec,
3741:
3742: IF (i > 0) THEN
3743: okl_copy_asset_pub.copy_all_lines(
3744: p_api_version => 1.0,
3745: p_init_msg_list => OKL_API.G_FALSE,
3746: x_return_status => x_return_status,
3747: x_msg_count => x_msg_count,
3748: x_msg_data => x_msg_data,
3749: p_from_cle_id_tbl => l_rbk_fee_tbl,
3778: FETCH c_fee_orig_csr INTO c_fee_orig_rec;
3779:
3780: IF(c_fee_orig_csr%NOTFOUND) THEN
3781: CLOSE c_fee_orig_csr;
3782: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3783: ELSE
3784: l_orig_fee_top_line_id := c_fee_rbk_rec.orig_system_id1; -- for future use
3785: -- check if either of the fee, (amount where fee type is not Rollover), idc,
3786: -- (qte_id and fee type is not Rollover), supplier are changed between the contracts only then merge the change
3794: -- Bug 12938353: RGOOTY: Income Fee Enhancement
3795: OR(c_fee_orig_rec.fee_type = 'INCOME' AND (NVL(c_fee_orig_rec.origination_income,0) <> NVL(c_fee_rbk_rec.origination_income,0) ) )
3796: OR(NVL(c_fee_orig_rec.initial_direct_cost,0) <> NVL(c_fee_rbk_rec.initial_direct_cost,0)) -- idc has changed
3797: -- for non rollover fee quote has changed (is there a quote for other fee types??)
3798: OR((NVL(c_fee_orig_rec.qte_id, OKL_API.G_MISS_NUM) <> NVL(c_fee_rbk_rec.qte_id, OKL_API.G_MISS_NUM)) AND c_fee_orig_rec.fee_type <> G_ROLLOVER_FEE)
3799: -- OR(NVL(c_fee_orig_rec.vendor_party_id, OKL_API.G_MISS_NUM) <> NVL(c_fee_rbk_rec.vendor_party_id, OKL_API.G_MISS_NUM)) -- optional supplier info has changed
3800: -- fee start date changes are not synced up on the original fee line
3801: -- OR(TRUNC(NVL(c_fee_orig_rec.start_date,OKL_API.G_MISS_DATE)) <> TRUNC(NVL(c_fee_rbk_rec.start_date,OKL_API.G_MISS_DATE)))
3802: OR(TRUNC(NVL(c_fee_orig_rec.end_date,OKL_API.G_MISS_DATE)) <> TRUNC(NVL(c_fee_rbk_rec.end_date,OKL_API.G_MISS_DATE)))
3795: OR(c_fee_orig_rec.fee_type = 'INCOME' AND (NVL(c_fee_orig_rec.origination_income,0) <> NVL(c_fee_rbk_rec.origination_income,0) ) )
3796: OR(NVL(c_fee_orig_rec.initial_direct_cost,0) <> NVL(c_fee_rbk_rec.initial_direct_cost,0)) -- idc has changed
3797: -- for non rollover fee quote has changed (is there a quote for other fee types??)
3798: OR((NVL(c_fee_orig_rec.qte_id, OKL_API.G_MISS_NUM) <> NVL(c_fee_rbk_rec.qte_id, OKL_API.G_MISS_NUM)) AND c_fee_orig_rec.fee_type <> G_ROLLOVER_FEE)
3799: -- OR(NVL(c_fee_orig_rec.vendor_party_id, OKL_API.G_MISS_NUM) <> NVL(c_fee_rbk_rec.vendor_party_id, OKL_API.G_MISS_NUM)) -- optional supplier info has changed
3800: -- fee start date changes are not synced up on the original fee line
3801: -- OR(TRUNC(NVL(c_fee_orig_rec.start_date,OKL_API.G_MISS_DATE)) <> TRUNC(NVL(c_fee_rbk_rec.start_date,OKL_API.G_MISS_DATE)))
3802: OR(TRUNC(NVL(c_fee_orig_rec.end_date,OKL_API.G_MISS_DATE)) <> TRUNC(NVL(c_fee_rbk_rec.end_date,OKL_API.G_MISS_DATE)))
3803: --Bug# 4558486
3797: -- for non rollover fee quote has changed (is there a quote for other fee types??)
3798: OR((NVL(c_fee_orig_rec.qte_id, OKL_API.G_MISS_NUM) <> NVL(c_fee_rbk_rec.qte_id, OKL_API.G_MISS_NUM)) AND c_fee_orig_rec.fee_type <> G_ROLLOVER_FEE)
3799: -- OR(NVL(c_fee_orig_rec.vendor_party_id, OKL_API.G_MISS_NUM) <> NVL(c_fee_rbk_rec.vendor_party_id, OKL_API.G_MISS_NUM)) -- optional supplier info has changed
3800: -- fee start date changes are not synced up on the original fee line
3801: -- OR(TRUNC(NVL(c_fee_orig_rec.start_date,OKL_API.G_MISS_DATE)) <> TRUNC(NVL(c_fee_rbk_rec.start_date,OKL_API.G_MISS_DATE)))
3802: OR(TRUNC(NVL(c_fee_orig_rec.end_date,OKL_API.G_MISS_DATE)) <> TRUNC(NVL(c_fee_rbk_rec.end_date,OKL_API.G_MISS_DATE)))
3803: --Bug# 4558486
3804: OR(NVL(c_fee_orig_rec.attribute_category, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute_category, OKL_API.G_MISS_CHAR))
3805: OR(NVL(c_fee_orig_rec.attribute1, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute1, OKL_API.G_MISS_CHAR))
3798: OR((NVL(c_fee_orig_rec.qte_id, OKL_API.G_MISS_NUM) <> NVL(c_fee_rbk_rec.qte_id, OKL_API.G_MISS_NUM)) AND c_fee_orig_rec.fee_type <> G_ROLLOVER_FEE)
3799: -- OR(NVL(c_fee_orig_rec.vendor_party_id, OKL_API.G_MISS_NUM) <> NVL(c_fee_rbk_rec.vendor_party_id, OKL_API.G_MISS_NUM)) -- optional supplier info has changed
3800: -- fee start date changes are not synced up on the original fee line
3801: -- OR(TRUNC(NVL(c_fee_orig_rec.start_date,OKL_API.G_MISS_DATE)) <> TRUNC(NVL(c_fee_rbk_rec.start_date,OKL_API.G_MISS_DATE)))
3802: OR(TRUNC(NVL(c_fee_orig_rec.end_date,OKL_API.G_MISS_DATE)) <> TRUNC(NVL(c_fee_rbk_rec.end_date,OKL_API.G_MISS_DATE)))
3803: --Bug# 4558486
3804: OR(NVL(c_fee_orig_rec.attribute_category, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute_category, OKL_API.G_MISS_CHAR))
3805: OR(NVL(c_fee_orig_rec.attribute1, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute1, OKL_API.G_MISS_CHAR))
3806: OR(NVL(c_fee_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))
3800: -- fee start date changes are not synced up on the original fee line
3801: -- OR(TRUNC(NVL(c_fee_orig_rec.start_date,OKL_API.G_MISS_DATE)) <> TRUNC(NVL(c_fee_rbk_rec.start_date,OKL_API.G_MISS_DATE)))
3802: OR(TRUNC(NVL(c_fee_orig_rec.end_date,OKL_API.G_MISS_DATE)) <> TRUNC(NVL(c_fee_rbk_rec.end_date,OKL_API.G_MISS_DATE)))
3803: --Bug# 4558486
3804: OR(NVL(c_fee_orig_rec.attribute_category, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute_category, OKL_API.G_MISS_CHAR))
3805: OR(NVL(c_fee_orig_rec.attribute1, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute1, OKL_API.G_MISS_CHAR))
3806: OR(NVL(c_fee_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))
3807: OR(NVL(c_fee_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
3808: OR(NVL(c_fee_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
3801: -- OR(TRUNC(NVL(c_fee_orig_rec.start_date,OKL_API.G_MISS_DATE)) <> TRUNC(NVL(c_fee_rbk_rec.start_date,OKL_API.G_MISS_DATE)))
3802: OR(TRUNC(NVL(c_fee_orig_rec.end_date,OKL_API.G_MISS_DATE)) <> TRUNC(NVL(c_fee_rbk_rec.end_date,OKL_API.G_MISS_DATE)))
3803: --Bug# 4558486
3804: OR(NVL(c_fee_orig_rec.attribute_category, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute_category, OKL_API.G_MISS_CHAR))
3805: OR(NVL(c_fee_orig_rec.attribute1, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute1, OKL_API.G_MISS_CHAR))
3806: OR(NVL(c_fee_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))
3807: OR(NVL(c_fee_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
3808: OR(NVL(c_fee_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
3809: OR(NVL(c_fee_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
3802: OR(TRUNC(NVL(c_fee_orig_rec.end_date,OKL_API.G_MISS_DATE)) <> TRUNC(NVL(c_fee_rbk_rec.end_date,OKL_API.G_MISS_DATE)))
3803: --Bug# 4558486
3804: OR(NVL(c_fee_orig_rec.attribute_category, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute_category, OKL_API.G_MISS_CHAR))
3805: OR(NVL(c_fee_orig_rec.attribute1, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute1, OKL_API.G_MISS_CHAR))
3806: OR(NVL(c_fee_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))
3807: OR(NVL(c_fee_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
3808: OR(NVL(c_fee_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
3809: OR(NVL(c_fee_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
3810: OR(NVL(c_fee_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
3803: --Bug# 4558486
3804: OR(NVL(c_fee_orig_rec.attribute_category, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute_category, OKL_API.G_MISS_CHAR))
3805: OR(NVL(c_fee_orig_rec.attribute1, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute1, OKL_API.G_MISS_CHAR))
3806: OR(NVL(c_fee_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))
3807: OR(NVL(c_fee_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
3808: OR(NVL(c_fee_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
3809: OR(NVL(c_fee_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
3810: OR(NVL(c_fee_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
3811: OR(NVL(c_fee_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
3804: OR(NVL(c_fee_orig_rec.attribute_category, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute_category, OKL_API.G_MISS_CHAR))
3805: OR(NVL(c_fee_orig_rec.attribute1, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute1, OKL_API.G_MISS_CHAR))
3806: OR(NVL(c_fee_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))
3807: OR(NVL(c_fee_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
3808: OR(NVL(c_fee_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
3809: OR(NVL(c_fee_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
3810: OR(NVL(c_fee_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
3811: OR(NVL(c_fee_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
3812: OR(NVL(c_fee_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
3805: OR(NVL(c_fee_orig_rec.attribute1, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute1, OKL_API.G_MISS_CHAR))
3806: OR(NVL(c_fee_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))
3807: OR(NVL(c_fee_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
3808: OR(NVL(c_fee_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
3809: OR(NVL(c_fee_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
3810: OR(NVL(c_fee_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
3811: OR(NVL(c_fee_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
3812: OR(NVL(c_fee_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
3813: OR(NVL(c_fee_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
3806: OR(NVL(c_fee_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))
3807: OR(NVL(c_fee_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
3808: OR(NVL(c_fee_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
3809: OR(NVL(c_fee_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
3810: OR(NVL(c_fee_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
3811: OR(NVL(c_fee_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
3812: OR(NVL(c_fee_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
3813: OR(NVL(c_fee_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
3814: OR(NVL(c_fee_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
3807: OR(NVL(c_fee_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
3808: OR(NVL(c_fee_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
3809: OR(NVL(c_fee_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
3810: OR(NVL(c_fee_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
3811: OR(NVL(c_fee_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
3812: OR(NVL(c_fee_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
3813: OR(NVL(c_fee_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
3814: OR(NVL(c_fee_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
3815: OR(NVL(c_fee_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
3808: OR(NVL(c_fee_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
3809: OR(NVL(c_fee_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
3810: OR(NVL(c_fee_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
3811: OR(NVL(c_fee_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
3812: OR(NVL(c_fee_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
3813: OR(NVL(c_fee_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
3814: OR(NVL(c_fee_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
3815: OR(NVL(c_fee_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
3816: OR(NVL(c_fee_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))
3809: OR(NVL(c_fee_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
3810: OR(NVL(c_fee_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
3811: OR(NVL(c_fee_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
3812: OR(NVL(c_fee_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
3813: OR(NVL(c_fee_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
3814: OR(NVL(c_fee_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
3815: OR(NVL(c_fee_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
3816: OR(NVL(c_fee_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))
3817: OR(NVL(c_fee_orig_rec.attribute13, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute13, OKL_API.G_MISS_CHAR))
3810: OR(NVL(c_fee_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
3811: OR(NVL(c_fee_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
3812: OR(NVL(c_fee_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
3813: OR(NVL(c_fee_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
3814: OR(NVL(c_fee_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
3815: OR(NVL(c_fee_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
3816: OR(NVL(c_fee_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))
3817: OR(NVL(c_fee_orig_rec.attribute13, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute13, OKL_API.G_MISS_CHAR))
3818: OR(NVL(c_fee_orig_rec.attribute14, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute14, OKL_API.G_MISS_CHAR))
3811: OR(NVL(c_fee_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
3812: OR(NVL(c_fee_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
3813: OR(NVL(c_fee_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
3814: OR(NVL(c_fee_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
3815: OR(NVL(c_fee_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
3816: OR(NVL(c_fee_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))
3817: OR(NVL(c_fee_orig_rec.attribute13, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute13, OKL_API.G_MISS_CHAR))
3818: OR(NVL(c_fee_orig_rec.attribute14, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute14, OKL_API.G_MISS_CHAR))
3819: OR(NVL(c_fee_orig_rec.attribute15, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute15, OKL_API.G_MISS_CHAR))
3812: OR(NVL(c_fee_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
3813: OR(NVL(c_fee_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
3814: OR(NVL(c_fee_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
3815: OR(NVL(c_fee_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
3816: OR(NVL(c_fee_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))
3817: OR(NVL(c_fee_orig_rec.attribute13, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute13, OKL_API.G_MISS_CHAR))
3818: OR(NVL(c_fee_orig_rec.attribute14, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute14, OKL_API.G_MISS_CHAR))
3819: OR(NVL(c_fee_orig_rec.attribute15, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute15, OKL_API.G_MISS_CHAR))
3820:
3813: OR(NVL(c_fee_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
3814: OR(NVL(c_fee_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
3815: OR(NVL(c_fee_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
3816: OR(NVL(c_fee_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))
3817: OR(NVL(c_fee_orig_rec.attribute13, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute13, OKL_API.G_MISS_CHAR))
3818: OR(NVL(c_fee_orig_rec.attribute14, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute14, OKL_API.G_MISS_CHAR))
3819: OR(NVL(c_fee_orig_rec.attribute15, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute15, OKL_API.G_MISS_CHAR))
3820:
3821: )THEN
3814: OR(NVL(c_fee_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
3815: OR(NVL(c_fee_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
3816: OR(NVL(c_fee_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))
3817: OR(NVL(c_fee_orig_rec.attribute13, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute13, OKL_API.G_MISS_CHAR))
3818: OR(NVL(c_fee_orig_rec.attribute14, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute14, OKL_API.G_MISS_CHAR))
3819: OR(NVL(c_fee_orig_rec.attribute15, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute15, OKL_API.G_MISS_CHAR))
3820:
3821: )THEN
3822: l_orig_st_fee_rec.line_id := c_fee_rbk_rec.orig_system_id1;
3815: OR(NVL(c_fee_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
3816: OR(NVL(c_fee_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))
3817: OR(NVL(c_fee_orig_rec.attribute13, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute13, OKL_API.G_MISS_CHAR))
3818: OR(NVL(c_fee_orig_rec.attribute14, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute14, OKL_API.G_MISS_CHAR))
3819: OR(NVL(c_fee_orig_rec.attribute15, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute15, OKL_API.G_MISS_CHAR))
3820:
3821: )THEN
3822: l_orig_st_fee_rec.line_id := c_fee_rbk_rec.orig_system_id1;
3823: l_orig_st_fee_rec.dnz_chr_id := p_orig_chr_id;
3895:
3896: -- Update corresponding Orig Fee line
3897: okl_maintain_fee_pvt.update_fee_type(
3898: p_api_version => 1.0,
3899: p_init_msg_list => OKL_API.G_FALSE,
3900: x_return_status => x_return_status,
3901: x_msg_count => x_msg_count,
3902: x_msg_data => x_msg_data,
3903: p_fee_types_rec => l_orig_st_fee_rec,
3934: x_rulv_rec => x_rulv_freq_rec,
3935: x_rule_count => x_rule_count
3936: );
3937:
3938: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3939: RAISE sync_fee_failed;
3940: END IF;
3941: l_orig_freq_rule_id := x_rulv_freq_rec.id;
3942: l_orig_freq_rgp_id := x_rulv_freq_rec.rgp_id;
3951: p_rule_code => 'LAFREQ',
3952: x_rulv_rec => x_rulv_freq_rec,
3953: x_rule_count => x_rule_count
3954: );
3955: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3956: RAISE sync_fee_failed;
3957: END IF;
3958:
3959: IF (l_orig_freq <> x_rulv_freq_rec.object1_id1) THEN
3964: x_rulv_freq_rec.rgp_id := l_orig_freq_rgp_id;
3965: x_rulv_freq_rec.dnz_chr_id := p_orig_chr_id;
3966: okl_rule_pub.update_rule(
3967: p_api_version => 1.0,
3968: p_init_msg_list => OKL_API.G_FALSE,
3969: x_return_status => x_return_status,
3970: x_msg_count => x_msg_count,
3971: x_msg_data => x_msg_data,
3972: p_rulv_rec => x_rulv_freq_rec,
3993: x_rulv_rec => x_rulv_exp_rec,
3994: x_rule_count => x_rule_count
3995: );
3996:
3997: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3998: RAISE sync_fee_failed;
3999: END IF;
4000: l_orig_exp_rule_id := x_rulv_exp_rec.id;
4001: l_orig_exp_rgp_id := x_rulv_exp_rec.rgp_id;
4011: p_rule_code => 'LAFEXP',
4012: x_rulv_rec => x_rulv_exp_rec,
4013: x_rule_count => x_rule_count
4014: );
4015: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
4016: RAISE sync_fee_failed;
4017: END IF;
4018:
4019: IF (l_orig_exp_period <> x_rulv_exp_rec.rule_information1
4027: x_rulv_exp_rec.rgp_id := l_orig_exp_rgp_id;
4028: x_rulv_exp_rec.dnz_chr_id := p_orig_chr_id;
4029: okl_rule_pub.update_rule(
4030: p_api_version => 1.0,
4031: p_init_msg_list => OKL_API.G_FALSE,
4032: x_return_status => x_return_status,
4033: x_msg_count => x_msg_count,
4034: x_msg_data => x_msg_data,
4035: p_rulv_rec => x_rulv_exp_rec,
4069: -- okc_k_party_roles_b and okl_k_party_roles
4070: /*
4071: okl_okc_migration_pvt.update_k_party_role(
4072: p_api_version => 1.0,
4073: p_init_msg_list => OKL_API.G_FALSE,
4074: x_return_status => x_return_status,
4075: x_msg_count => x_msg_count,
4076: x_msg_data => x_msg_data,
4077: p_cplv_rec => l_cplv_rec,
4080:
4081: l_kplv_rec.id := l_cplv_rec.id;
4082: okl_k_party_roles_pvt.update_k_party_role(
4083: p_api_version => 1.0,
4084: p_init_msg_list => OKL_API.G_FALSE,
4085: x_return_status => x_return_status,
4086: x_msg_count => x_msg_count,
4087: x_msg_data => x_msg_data,
4088: p_cplv_rec => l_cplv_rec,
4111: -- okc_k_party_roles_b and okl_k_party_roles
4112: /*
4113: okl_okc_migration_pvt.create_k_party_role(
4114: p_api_version => 1.0,
4115: p_init_msg_list => OKL_API.G_FALSE,
4116: x_return_status => x_return_status,
4117: x_msg_count => x_msg_count,
4118: x_msg_data => x_msg_data,
4119: p_cplv_rec => l_cplv_rec,
4121: */
4122:
4123: okl_k_party_roles_pvt.create_k_party_role(
4124: p_api_version => 1.0,
4125: p_init_msg_list => OKL_API.G_FALSE,
4126: x_return_status => x_return_status,
4127: x_msg_count => x_msg_count,
4128: x_msg_data => x_msg_data,
4129: p_cplv_rec => l_cplv_rec,
4215:
4216: IF (l_u_line_item_tbl.COUNT > 0) THEN
4217: okl_contract_line_item_pvt.update_contract_line_item(
4218: p_api_version => 1.0,
4219: p_init_msg_list => OKL_API.G_FALSE,
4220: x_return_status => x_return_status,
4221: x_msg_count => x_msg_count,
4222: x_msg_data => x_msg_data,
4223: p_line_item_tbl => l_u_line_item_tbl,
4265: /*
4266: IF (l_c_line_item_tbl.COUNT > 0) THEN
4267: okl_contract_line_item_pvt.create_contract_line_item(
4268: p_api_version => 1.0,
4269: p_init_msg_list => OKL_API.G_FALSE,
4270: x_return_status => x_return_status,
4271: x_msg_count => x_msg_count,
4272: x_msg_data => x_msg_data,
4273: p_line_item_tbl => l_c_line_item_tbl,
4288:
4289: -- OKL.H Projects changes ---
4290: EXCEPTION
4291: WHEN sync_fee_failed THEN
4292: x_return_status := OKL_API.G_RET_STS_ERROR;
4293:
4294: when OKL_API.G_EXCEPTION_ERROR then
4295: x_return_status := 'OKC_API.G_RET_STS_ERROR';
4296:
4290: EXCEPTION
4291: WHEN sync_fee_failed THEN
4292: x_return_status := OKL_API.G_RET_STS_ERROR;
4293:
4294: when OKL_API.G_EXCEPTION_ERROR then
4295: x_return_status := 'OKC_API.G_RET_STS_ERROR';
4296:
4297: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
4298: x_return_status := 'OKC_API.G_RET_STS_UNEXP_ERROR';
4293:
4294: when OKL_API.G_EXCEPTION_ERROR then
4295: x_return_status := 'OKC_API.G_RET_STS_ERROR';
4296:
4297: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
4298: x_return_status := 'OKC_API.G_RET_STS_UNEXP_ERROR';
4299:
4300: END sync_fee_line;
4301:
4530: IF (G_DEBUG_ENABLED = 'Y') THEN
4531: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
4532: END IF;
4533:
4534: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4535: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4536: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
4537: END IF;
4538:
4553:
4554: IF (i > 0) THEN
4555: okl_copy_asset_pub.copy_all_lines(
4556: p_api_version => 1.0,
4557: p_init_msg_list => OKL_API.G_FALSE,
4558: x_return_status => x_return_status,
4559: x_msg_count => x_msg_count,
4560: x_msg_data => x_msg_data,
4561: p_from_cle_id_tbl => l_rbk_service_tbl,
4586: FETCH c_service_orig_csr INTO c_service_orig_rec;
4587:
4588: IF(c_service_orig_csr%NOTFOUND) THEN
4589: CLOSE c_service_orig_csr;
4590: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4591: ELSE
4592: l_orig_service_top_line_id := c_service_rbk_rec.orig_system_id1; -- for future use
4593:
4594: IF(
4594: IF(
4595: (c_service_orig_rec.object1_id1 <> c_service_rbk_rec.object1_id1)
4596: OR(c_service_orig_rec.item_description <> c_service_rbk_rec.item_description)
4597: OR(NVL(c_service_orig_rec.amount,0) <> NVL(c_service_rbk_rec.amount,0))
4598: OR(TRUNC(NVL(c_service_orig_rec.end_date,OKL_API.G_MISS_DATE)) <> TRUNC(NVL(c_service_rbk_rec.end_date,OKL_API.G_MISS_DATE)))
4599: OR(NVL(c_service_orig_rec.attribute_category, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute_category, OKL_API.G_MISS_CHAR))
4600: OR(NVL(c_service_orig_rec.attribute1, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute1, OKL_API.G_MISS_CHAR))
4601: OR(NVL(c_service_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))
4602: OR(NVL(c_service_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
4595: (c_service_orig_rec.object1_id1 <> c_service_rbk_rec.object1_id1)
4596: OR(c_service_orig_rec.item_description <> c_service_rbk_rec.item_description)
4597: OR(NVL(c_service_orig_rec.amount,0) <> NVL(c_service_rbk_rec.amount,0))
4598: OR(TRUNC(NVL(c_service_orig_rec.end_date,OKL_API.G_MISS_DATE)) <> TRUNC(NVL(c_service_rbk_rec.end_date,OKL_API.G_MISS_DATE)))
4599: OR(NVL(c_service_orig_rec.attribute_category, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute_category, OKL_API.G_MISS_CHAR))
4600: OR(NVL(c_service_orig_rec.attribute1, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute1, OKL_API.G_MISS_CHAR))
4601: OR(NVL(c_service_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))
4602: OR(NVL(c_service_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
4603: OR(NVL(c_service_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
4596: OR(c_service_orig_rec.item_description <> c_service_rbk_rec.item_description)
4597: OR(NVL(c_service_orig_rec.amount,0) <> NVL(c_service_rbk_rec.amount,0))
4598: OR(TRUNC(NVL(c_service_orig_rec.end_date,OKL_API.G_MISS_DATE)) <> TRUNC(NVL(c_service_rbk_rec.end_date,OKL_API.G_MISS_DATE)))
4599: OR(NVL(c_service_orig_rec.attribute_category, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute_category, OKL_API.G_MISS_CHAR))
4600: OR(NVL(c_service_orig_rec.attribute1, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute1, OKL_API.G_MISS_CHAR))
4601: OR(NVL(c_service_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))
4602: OR(NVL(c_service_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
4603: OR(NVL(c_service_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
4604: OR(NVL(c_service_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
4597: OR(NVL(c_service_orig_rec.amount,0) <> NVL(c_service_rbk_rec.amount,0))
4598: OR(TRUNC(NVL(c_service_orig_rec.end_date,OKL_API.G_MISS_DATE)) <> TRUNC(NVL(c_service_rbk_rec.end_date,OKL_API.G_MISS_DATE)))
4599: OR(NVL(c_service_orig_rec.attribute_category, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute_category, OKL_API.G_MISS_CHAR))
4600: OR(NVL(c_service_orig_rec.attribute1, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute1, OKL_API.G_MISS_CHAR))
4601: OR(NVL(c_service_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))
4602: OR(NVL(c_service_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
4603: OR(NVL(c_service_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
4604: OR(NVL(c_service_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
4605: OR(NVL(c_service_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
4598: OR(TRUNC(NVL(c_service_orig_rec.end_date,OKL_API.G_MISS_DATE)) <> TRUNC(NVL(c_service_rbk_rec.end_date,OKL_API.G_MISS_DATE)))
4599: OR(NVL(c_service_orig_rec.attribute_category, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute_category, OKL_API.G_MISS_CHAR))
4600: OR(NVL(c_service_orig_rec.attribute1, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute1, OKL_API.G_MISS_CHAR))
4601: OR(NVL(c_service_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))
4602: OR(NVL(c_service_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
4603: OR(NVL(c_service_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
4604: OR(NVL(c_service_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
4605: OR(NVL(c_service_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
4606: OR(NVL(c_service_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
4599: OR(NVL(c_service_orig_rec.attribute_category, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute_category, OKL_API.G_MISS_CHAR))
4600: OR(NVL(c_service_orig_rec.attribute1, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute1, OKL_API.G_MISS_CHAR))
4601: OR(NVL(c_service_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))
4602: OR(NVL(c_service_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
4603: OR(NVL(c_service_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
4604: OR(NVL(c_service_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
4605: OR(NVL(c_service_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
4606: OR(NVL(c_service_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
4607: OR(NVL(c_service_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
4600: OR(NVL(c_service_orig_rec.attribute1, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute1, OKL_API.G_MISS_CHAR))
4601: OR(NVL(c_service_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))
4602: OR(NVL(c_service_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
4603: OR(NVL(c_service_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
4604: OR(NVL(c_service_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
4605: OR(NVL(c_service_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
4606: OR(NVL(c_service_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
4607: OR(NVL(c_service_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
4608: OR(NVL(c_service_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
4601: OR(NVL(c_service_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))
4602: OR(NVL(c_service_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
4603: OR(NVL(c_service_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
4604: OR(NVL(c_service_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
4605: OR(NVL(c_service_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
4606: OR(NVL(c_service_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
4607: OR(NVL(c_service_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
4608: OR(NVL(c_service_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
4609: OR(NVL(c_service_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
4602: OR(NVL(c_service_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
4603: OR(NVL(c_service_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
4604: OR(NVL(c_service_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
4605: OR(NVL(c_service_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
4606: OR(NVL(c_service_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
4607: OR(NVL(c_service_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
4608: OR(NVL(c_service_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
4609: OR(NVL(c_service_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
4610: OR(NVL(c_service_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
4603: OR(NVL(c_service_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
4604: OR(NVL(c_service_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
4605: OR(NVL(c_service_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
4606: OR(NVL(c_service_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
4607: OR(NVL(c_service_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
4608: OR(NVL(c_service_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
4609: OR(NVL(c_service_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
4610: OR(NVL(c_service_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
4611: OR(NVL(c_service_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))
4604: OR(NVL(c_service_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
4605: OR(NVL(c_service_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
4606: OR(NVL(c_service_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
4607: OR(NVL(c_service_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
4608: OR(NVL(c_service_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
4609: OR(NVL(c_service_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
4610: OR(NVL(c_service_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
4611: OR(NVL(c_service_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))
4612: OR(NVL(c_service_orig_rec.attribute13, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute13, OKL_API.G_MISS_CHAR))
4605: OR(NVL(c_service_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
4606: OR(NVL(c_service_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
4607: OR(NVL(c_service_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
4608: OR(NVL(c_service_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
4609: OR(NVL(c_service_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
4610: OR(NVL(c_service_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
4611: OR(NVL(c_service_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))
4612: OR(NVL(c_service_orig_rec.attribute13, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute13, OKL_API.G_MISS_CHAR))
4613: OR(NVL(c_service_orig_rec.attribute14, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute14, OKL_API.G_MISS_CHAR))
4606: OR(NVL(c_service_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
4607: OR(NVL(c_service_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
4608: OR(NVL(c_service_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
4609: OR(NVL(c_service_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
4610: OR(NVL(c_service_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
4611: OR(NVL(c_service_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))
4612: OR(NVL(c_service_orig_rec.attribute13, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute13, OKL_API.G_MISS_CHAR))
4613: OR(NVL(c_service_orig_rec.attribute14, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute14, OKL_API.G_MISS_CHAR))
4614: OR(NVL(c_service_orig_rec.attribute15, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute15, OKL_API.G_MISS_CHAR))
4607: OR(NVL(c_service_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
4608: OR(NVL(c_service_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
4609: OR(NVL(c_service_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
4610: OR(NVL(c_service_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
4611: OR(NVL(c_service_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))
4612: OR(NVL(c_service_orig_rec.attribute13, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute13, OKL_API.G_MISS_CHAR))
4613: OR(NVL(c_service_orig_rec.attribute14, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute14, OKL_API.G_MISS_CHAR))
4614: OR(NVL(c_service_orig_rec.attribute15, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute15, OKL_API.G_MISS_CHAR))
4615:
4608: OR(NVL(c_service_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
4609: OR(NVL(c_service_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
4610: OR(NVL(c_service_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
4611: OR(NVL(c_service_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))
4612: OR(NVL(c_service_orig_rec.attribute13, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute13, OKL_API.G_MISS_CHAR))
4613: OR(NVL(c_service_orig_rec.attribute14, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute14, OKL_API.G_MISS_CHAR))
4614: OR(NVL(c_service_orig_rec.attribute15, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute15, OKL_API.G_MISS_CHAR))
4615:
4616: )THEN
4609: OR(NVL(c_service_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
4610: OR(NVL(c_service_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
4611: OR(NVL(c_service_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))
4612: OR(NVL(c_service_orig_rec.attribute13, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute13, OKL_API.G_MISS_CHAR))
4613: OR(NVL(c_service_orig_rec.attribute14, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute14, OKL_API.G_MISS_CHAR))
4614: OR(NVL(c_service_orig_rec.attribute15, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute15, OKL_API.G_MISS_CHAR))
4615:
4616: )THEN
4617:
4610: OR(NVL(c_service_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
4611: OR(NVL(c_service_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))
4612: OR(NVL(c_service_orig_rec.attribute13, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute13, OKL_API.G_MISS_CHAR))
4613: OR(NVL(c_service_orig_rec.attribute14, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute14, OKL_API.G_MISS_CHAR))
4614: OR(NVL(c_service_orig_rec.attribute15, OKL_API.G_MISS_CHAR) <> NVL(c_service_rbk_rec.attribute15, OKL_API.G_MISS_CHAR))
4615:
4616: )THEN
4617:
4618: l_orig_clev_rec.id := c_service_orig_rec.id;
4678:
4679: -- Update corresponding Orig service line
4680: okl_contract_top_line_pvt.update_contract_top_line(
4681: p_api_version => 1.0,
4682: p_init_msg_list => OKL_API.G_FALSE,
4683: x_return_status => x_return_status,
4684: x_msg_count => x_msg_count,
4685: x_msg_data => x_msg_data,
4686: p_clev_rec => l_orig_clev_rec,
4765:
4766: -- Create rule records to store expense info on original contract
4767: OKL_RGRP_RULES_PROCESS_PUB.process_rule_group_rules(
4768: p_api_version => 1.0,
4769: p_init_msg_list => OKL_API.G_FALSE,
4770: x_return_status => x_return_status,
4771: x_msg_count => x_msg_count,
4772: x_msg_data => x_msg_data,
4773: p_chr_id => p_orig_chr_id,
4774: p_line_id => l_orig_service_top_line_id,
4775: p_cpl_id => NULL,
4776: p_rrd_id => NULL,
4777: p_rgr_tbl => l_rgr_tbl);
4778: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
4779: RAISE sync_service_failed;
4780: END IF;
4781:
4782: -- Else if original contract has expense info, then update
4793: x_rulv_rec => x_rulv_freq_rec,
4794: x_rule_count => x_rule_count
4795: );
4796:
4797: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
4798: RAISE sync_service_failed;
4799: END IF;
4800:
4801: l_orig_freq_rule_id := x_rulv_freq_rec.id;
4812: x_rulv_rec => x_rulv_freq_rec,
4813: x_rule_count => x_rule_count
4814: );
4815:
4816: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
4817: RAISE sync_service_failed;
4818: END IF;
4819:
4820: IF (l_orig_freq <> x_rulv_freq_rec.object1_id1) THEN
4826: x_rulv_freq_rec.rgp_id := l_orig_freq_rgp_id;
4827: x_rulv_freq_rec.dnz_chr_id := p_orig_chr_id;
4828: okl_rule_pub.update_rule(
4829: p_api_version => 1.0,
4830: p_init_msg_list => OKL_API.G_FALSE,
4831: x_return_status => x_return_status,
4832: x_msg_count => x_msg_count,
4833: x_msg_data => x_msg_data,
4834: p_rulv_rec => x_rulv_freq_rec,
4855: x_rulv_rec => x_rulv_exp_rec,
4856: x_rule_count => x_rule_count
4857: );
4858:
4859: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
4860: RAISE sync_service_failed;
4861: END IF;
4862:
4863: l_orig_exp_rule_id := x_rulv_exp_rec.id;
4874: p_rule_code => 'LAFEXP',
4875: x_rulv_rec => x_rulv_exp_rec,
4876: x_rule_count => x_rule_count
4877: );
4878: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
4879: RAISE sync_service_failed;
4880: END IF;
4881:
4882: IF (l_orig_exp_period <> x_rulv_exp_rec.rule_information1 OR
4890: x_rulv_exp_rec.rgp_id := l_orig_exp_rgp_id;
4891: x_rulv_exp_rec.dnz_chr_id := p_orig_chr_id;
4892: okl_rule_pub.update_rule(
4893: p_api_version => 1.0,
4894: p_init_msg_list => OKL_API.G_FALSE,
4895: x_return_status => x_return_status,
4896: x_msg_count => x_msg_count,
4897: x_msg_data => x_msg_data,
4898: p_rulv_rec => x_rulv_exp_rec,
4966:
4967: IF (l_u_line_item_tbl.COUNT > 0) THEN
4968: okl_contract_line_item_pvt.update_contract_line_item(
4969: p_api_version => 1.0,
4970: p_init_msg_list => OKL_API.G_FALSE,
4971: x_return_status => x_return_status,
4972: x_msg_count => x_msg_count,
4973: x_msg_data => x_msg_data,
4974: p_line_item_tbl => l_u_line_item_tbl,
5014: CLOSE c_service_rbk_csr;
5015:
5016: EXCEPTION
5017: WHEN sync_service_failed THEN
5018: x_return_status := OKL_API.G_RET_STS_ERROR;
5019:
5020: when OKL_API.G_EXCEPTION_ERROR then
5021: x_return_status := 'OKC_API.G_RET_STS_ERROR';
5022:
5016: EXCEPTION
5017: WHEN sync_service_failed THEN
5018: x_return_status := OKL_API.G_RET_STS_ERROR;
5019:
5020: when OKL_API.G_EXCEPTION_ERROR then
5021: x_return_status := 'OKC_API.G_RET_STS_ERROR';
5022:
5023: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
5024: x_return_status := 'OKC_API.G_RET_STS_UNEXP_ERROR';
5019:
5020: when OKL_API.G_EXCEPTION_ERROR then
5021: x_return_status := 'OKC_API.G_RET_STS_ERROR';
5022:
5023: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
5024: x_return_status := 'OKC_API.G_RET_STS_UNEXP_ERROR';
5025:
5026: END sync_service_line;
5027:
5315: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5316: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
5317: END IF;
5318:
5319: x_return_status := OKL_API.G_RET_STS_SUCCESS;
5320:
5321: -- Sync rule groups that existed on the original contract
5322: FOR l_rgp_orig_rec IN l_rgp_orig_csr(p_chr_id => p_orig_chr_id) LOOP
5323:
5344: -- Rule exists on rebook copy contract
5345: IF (l_rul_rbk_rec.id IS NOT NULL) THEN
5346:
5347: -- Check for changes during rebook
5348: IF (NVL(l_rul_rbk_rec.rule_information1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information1,OKL_API.G_MISS_CHAR)
5349: OR
5350: NVL(l_rul_rbk_rec.rule_information2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information2,OKL_API.G_MISS_CHAR)
5351: OR
5352: NVL(l_rul_rbk_rec.rule_information3,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information3,OKL_API.G_MISS_CHAR)
5346:
5347: -- Check for changes during rebook
5348: IF (NVL(l_rul_rbk_rec.rule_information1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information1,OKL_API.G_MISS_CHAR)
5349: OR
5350: NVL(l_rul_rbk_rec.rule_information2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information2,OKL_API.G_MISS_CHAR)
5351: OR
5352: NVL(l_rul_rbk_rec.rule_information3,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information3,OKL_API.G_MISS_CHAR)
5353: OR
5354: NVL(l_rul_rbk_rec.rule_information4,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information4,OKL_API.G_MISS_CHAR)
5348: IF (NVL(l_rul_rbk_rec.rule_information1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information1,OKL_API.G_MISS_CHAR)
5349: OR
5350: NVL(l_rul_rbk_rec.rule_information2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information2,OKL_API.G_MISS_CHAR)
5351: OR
5352: NVL(l_rul_rbk_rec.rule_information3,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information3,OKL_API.G_MISS_CHAR)
5353: OR
5354: NVL(l_rul_rbk_rec.rule_information4,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information4,OKL_API.G_MISS_CHAR)
5355: OR
5356: NVL(l_rul_rbk_rec.rule_information5,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information5,OKL_API.G_MISS_CHAR)
5350: NVL(l_rul_rbk_rec.rule_information2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information2,OKL_API.G_MISS_CHAR)
5351: OR
5352: NVL(l_rul_rbk_rec.rule_information3,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information3,OKL_API.G_MISS_CHAR)
5353: OR
5354: NVL(l_rul_rbk_rec.rule_information4,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information4,OKL_API.G_MISS_CHAR)
5355: OR
5356: NVL(l_rul_rbk_rec.rule_information5,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information5,OKL_API.G_MISS_CHAR)
5357: OR
5358: NVL(l_rul_rbk_rec.rule_information6,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information6,OKL_API.G_MISS_CHAR)
5352: NVL(l_rul_rbk_rec.rule_information3,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information3,OKL_API.G_MISS_CHAR)
5353: OR
5354: NVL(l_rul_rbk_rec.rule_information4,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information4,OKL_API.G_MISS_CHAR)
5355: OR
5356: NVL(l_rul_rbk_rec.rule_information5,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information5,OKL_API.G_MISS_CHAR)
5357: OR
5358: NVL(l_rul_rbk_rec.rule_information6,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information6,OKL_API.G_MISS_CHAR)
5359: OR
5360: NVL(l_rul_rbk_rec.rule_information7,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information7,OKL_API.G_MISS_CHAR)
5354: NVL(l_rul_rbk_rec.rule_information4,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information4,OKL_API.G_MISS_CHAR)
5355: OR
5356: NVL(l_rul_rbk_rec.rule_information5,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information5,OKL_API.G_MISS_CHAR)
5357: OR
5358: NVL(l_rul_rbk_rec.rule_information6,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information6,OKL_API.G_MISS_CHAR)
5359: OR
5360: NVL(l_rul_rbk_rec.rule_information7,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information7,OKL_API.G_MISS_CHAR)
5361: OR
5362: NVL(l_rul_rbk_rec.rule_information8,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information8,OKL_API.G_MISS_CHAR)
5356: NVL(l_rul_rbk_rec.rule_information5,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information5,OKL_API.G_MISS_CHAR)
5357: OR
5358: NVL(l_rul_rbk_rec.rule_information6,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information6,OKL_API.G_MISS_CHAR)
5359: OR
5360: NVL(l_rul_rbk_rec.rule_information7,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information7,OKL_API.G_MISS_CHAR)
5361: OR
5362: NVL(l_rul_rbk_rec.rule_information8,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information8,OKL_API.G_MISS_CHAR)
5363: OR
5364: NVL(l_rul_rbk_rec.rule_information9,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information9,OKL_API.G_MISS_CHAR)
5358: NVL(l_rul_rbk_rec.rule_information6,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information6,OKL_API.G_MISS_CHAR)
5359: OR
5360: NVL(l_rul_rbk_rec.rule_information7,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information7,OKL_API.G_MISS_CHAR)
5361: OR
5362: NVL(l_rul_rbk_rec.rule_information8,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information8,OKL_API.G_MISS_CHAR)
5363: OR
5364: NVL(l_rul_rbk_rec.rule_information9,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information9,OKL_API.G_MISS_CHAR)
5365: OR
5366: NVL(l_rul_rbk_rec.rule_information10,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information10,OKL_API.G_MISS_CHAR)
5360: NVL(l_rul_rbk_rec.rule_information7,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information7,OKL_API.G_MISS_CHAR)
5361: OR
5362: NVL(l_rul_rbk_rec.rule_information8,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information8,OKL_API.G_MISS_CHAR)
5363: OR
5364: NVL(l_rul_rbk_rec.rule_information9,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information9,OKL_API.G_MISS_CHAR)
5365: OR
5366: NVL(l_rul_rbk_rec.rule_information10,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information10,OKL_API.G_MISS_CHAR)
5367: OR
5368: NVL(l_rul_rbk_rec.rule_information11,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information11,OKL_API.G_MISS_CHAR)
5362: NVL(l_rul_rbk_rec.rule_information8,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information8,OKL_API.G_MISS_CHAR)
5363: OR
5364: NVL(l_rul_rbk_rec.rule_information9,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information9,OKL_API.G_MISS_CHAR)
5365: OR
5366: NVL(l_rul_rbk_rec.rule_information10,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information10,OKL_API.G_MISS_CHAR)
5367: OR
5368: NVL(l_rul_rbk_rec.rule_information11,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information11,OKL_API.G_MISS_CHAR)
5369: OR
5370: NVL(l_rul_rbk_rec.rule_information12,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information12,OKL_API.G_MISS_CHAR)
5364: NVL(l_rul_rbk_rec.rule_information9,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information9,OKL_API.G_MISS_CHAR)
5365: OR
5366: NVL(l_rul_rbk_rec.rule_information10,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information10,OKL_API.G_MISS_CHAR)
5367: OR
5368: NVL(l_rul_rbk_rec.rule_information11,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information11,OKL_API.G_MISS_CHAR)
5369: OR
5370: NVL(l_rul_rbk_rec.rule_information12,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information12,OKL_API.G_MISS_CHAR)
5371: OR
5372: NVL(l_rul_rbk_rec.rule_information13,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information13,OKL_API.G_MISS_CHAR)
5366: NVL(l_rul_rbk_rec.rule_information10,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information10,OKL_API.G_MISS_CHAR)
5367: OR
5368: NVL(l_rul_rbk_rec.rule_information11,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information11,OKL_API.G_MISS_CHAR)
5369: OR
5370: NVL(l_rul_rbk_rec.rule_information12,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information12,OKL_API.G_MISS_CHAR)
5371: OR
5372: NVL(l_rul_rbk_rec.rule_information13,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information13,OKL_API.G_MISS_CHAR)
5373: OR
5374: NVL(l_rul_rbk_rec.rule_information14,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information14,OKL_API.G_MISS_CHAR)
5368: NVL(l_rul_rbk_rec.rule_information11,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information11,OKL_API.G_MISS_CHAR)
5369: OR
5370: NVL(l_rul_rbk_rec.rule_information12,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information12,OKL_API.G_MISS_CHAR)
5371: OR
5372: NVL(l_rul_rbk_rec.rule_information13,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information13,OKL_API.G_MISS_CHAR)
5373: OR
5374: NVL(l_rul_rbk_rec.rule_information14,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information14,OKL_API.G_MISS_CHAR)
5375: OR
5376: NVL(l_rul_rbk_rec.rule_information15,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information15,OKL_API.G_MISS_CHAR)
5370: NVL(l_rul_rbk_rec.rule_information12,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information12,OKL_API.G_MISS_CHAR)
5371: OR
5372: NVL(l_rul_rbk_rec.rule_information13,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information13,OKL_API.G_MISS_CHAR)
5373: OR
5374: NVL(l_rul_rbk_rec.rule_information14,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information14,OKL_API.G_MISS_CHAR)
5375: OR
5376: NVL(l_rul_rbk_rec.rule_information15,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information15,OKL_API.G_MISS_CHAR)
5377: OR
5378: NVL(l_rul_rbk_rec.object1_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object1_id1,OKL_API.G_MISS_CHAR)
5372: NVL(l_rul_rbk_rec.rule_information13,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information13,OKL_API.G_MISS_CHAR)
5373: OR
5374: NVL(l_rul_rbk_rec.rule_information14,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information14,OKL_API.G_MISS_CHAR)
5375: OR
5376: NVL(l_rul_rbk_rec.rule_information15,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information15,OKL_API.G_MISS_CHAR)
5377: OR
5378: NVL(l_rul_rbk_rec.object1_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object1_id1,OKL_API.G_MISS_CHAR)
5379: OR
5380: NVL(l_rul_rbk_rec.object2_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object2_id1,OKL_API.G_MISS_CHAR)
5374: NVL(l_rul_rbk_rec.rule_information14,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information14,OKL_API.G_MISS_CHAR)
5375: OR
5376: NVL(l_rul_rbk_rec.rule_information15,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information15,OKL_API.G_MISS_CHAR)
5377: OR
5378: NVL(l_rul_rbk_rec.object1_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object1_id1,OKL_API.G_MISS_CHAR)
5379: OR
5380: NVL(l_rul_rbk_rec.object2_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object2_id1,OKL_API.G_MISS_CHAR)
5381: OR
5382: NVL(l_rul_rbk_rec.object3_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object3_id1,OKL_API.G_MISS_CHAR)
5376: NVL(l_rul_rbk_rec.rule_information15,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information15,OKL_API.G_MISS_CHAR)
5377: OR
5378: NVL(l_rul_rbk_rec.object1_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object1_id1,OKL_API.G_MISS_CHAR)
5379: OR
5380: NVL(l_rul_rbk_rec.object2_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object2_id1,OKL_API.G_MISS_CHAR)
5381: OR
5382: NVL(l_rul_rbk_rec.object3_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object3_id1,OKL_API.G_MISS_CHAR)
5383: OR
5384: NVL(l_rul_rbk_rec.object1_id2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object1_id2,OKL_API.G_MISS_CHAR)
5378: NVL(l_rul_rbk_rec.object1_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object1_id1,OKL_API.G_MISS_CHAR)
5379: OR
5380: NVL(l_rul_rbk_rec.object2_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object2_id1,OKL_API.G_MISS_CHAR)
5381: OR
5382: NVL(l_rul_rbk_rec.object3_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object3_id1,OKL_API.G_MISS_CHAR)
5383: OR
5384: NVL(l_rul_rbk_rec.object1_id2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object1_id2,OKL_API.G_MISS_CHAR)
5385: OR
5386: NVL(l_rul_rbk_rec.object2_id2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object2_id2,OKL_API.G_MISS_CHAR)
5380: NVL(l_rul_rbk_rec.object2_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object2_id1,OKL_API.G_MISS_CHAR)
5381: OR
5382: NVL(l_rul_rbk_rec.object3_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object3_id1,OKL_API.G_MISS_CHAR)
5383: OR
5384: NVL(l_rul_rbk_rec.object1_id2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object1_id2,OKL_API.G_MISS_CHAR)
5385: OR
5386: NVL(l_rul_rbk_rec.object2_id2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object2_id2,OKL_API.G_MISS_CHAR)
5387: OR
5388: NVL(l_rul_rbk_rec.object3_id2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object3_id2,OKL_API.G_MISS_CHAR)
5382: NVL(l_rul_rbk_rec.object3_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object3_id1,OKL_API.G_MISS_CHAR)
5383: OR
5384: NVL(l_rul_rbk_rec.object1_id2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object1_id2,OKL_API.G_MISS_CHAR)
5385: OR
5386: NVL(l_rul_rbk_rec.object2_id2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object2_id2,OKL_API.G_MISS_CHAR)
5387: OR
5388: NVL(l_rul_rbk_rec.object3_id2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object3_id2,OKL_API.G_MISS_CHAR)
5389: ) THEN
5390:
5384: NVL(l_rul_rbk_rec.object1_id2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object1_id2,OKL_API.G_MISS_CHAR)
5385: OR
5386: NVL(l_rul_rbk_rec.object2_id2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object2_id2,OKL_API.G_MISS_CHAR)
5387: OR
5388: NVL(l_rul_rbk_rec.object3_id2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object3_id2,OKL_API.G_MISS_CHAR)
5389: ) THEN
5390:
5391: l_rul_rbk_rec.id := l_rul_orig_rec.id;
5392: l_rul_rbk_rec.rgp_id := l_rul_orig_rec.rgp_id;
5393: l_rul_rbk_rec.dnz_chr_id := l_rul_orig_rec.dnz_chr_id;
5394:
5395: okl_rule_pub.update_rule(
5396: p_api_version => 1.0,
5397: p_init_msg_list => OKL_API.G_FALSE,
5398: x_return_status => x_return_status,
5399: x_msg_count => x_msg_count,
5400: x_msg_data => x_msg_data,
5401: p_rulv_rec => l_rul_rbk_rec,
5401: p_rulv_rec => l_rul_rbk_rec,
5402: x_rulv_rec => x_rulv_rec
5403: );
5404:
5405: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
5406: RAISE sync_terms_failed;
5407: END IF;
5408:
5409: END IF;
5414: l_rulv_rec.id := l_rul_orig_rec.id;
5415:
5416: okl_rule_pub.delete_rule(
5417: p_api_version => 1.0,
5418: p_init_msg_list => OKL_API.G_FALSE,
5419: x_return_status => x_return_status,
5420: x_msg_count => x_msg_count,
5421: x_msg_data => x_msg_data,
5422: p_rulv_rec => l_rulv_rec);
5420: x_msg_count => x_msg_count,
5421: x_msg_data => x_msg_data,
5422: p_rulv_rec => l_rulv_rec);
5423:
5424: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
5425: RAISE sync_terms_failed;
5426: END IF;
5427:
5428: END IF;
5444: l_rul_rbk_rec.dnz_chr_id := p_orig_chr_id;
5445:
5446: okl_rule_pub.create_rule(
5447: p_api_version => 1.0,
5448: p_init_msg_list => OKL_API.G_FALSE,
5449: x_return_status => x_return_status,
5450: x_msg_count => x_msg_count,
5451: x_msg_data => x_msg_data,
5452: p_rulv_rec => l_rul_rbk_rec,
5451: x_msg_data => x_msg_data,
5452: p_rulv_rec => l_rul_rbk_rec,
5453: x_rulv_rec => x_rulv_rec);
5454:
5455: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
5456: CLOSE l_rbk_new_rul_csr;
5457: RAISE sync_terms_failed;
5458: END IF;
5459:
5468: l_rgpv_rec.id := l_rgp_orig_rec.id;
5469:
5470: okl_rule_pub.delete_rule_group(
5471: p_api_version => 1.0,
5472: p_init_msg_list => OKL_API.G_FALSE,
5473: x_return_status => x_return_status,
5474: x_msg_count => x_msg_count,
5475: x_msg_data => x_msg_data,
5476: p_rgpv_rec => l_rgpv_rec);
5474: x_msg_count => x_msg_count,
5475: x_msg_data => x_msg_data,
5476: p_rgpv_rec => l_rgpv_rec);
5477:
5478: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
5479: RAISE sync_terms_failed;
5480: END IF;
5481:
5482: END IF;
5487: p_rebook_chr_id => p_rebook_chr_id) LOOP
5488:
5489: okl_copy_contract_pvt.copy_rules(
5490: p_api_version => 1.0,
5491: p_init_msg_list => OKL_API.G_FALSE,
5492: x_return_status => x_return_status,
5493: x_msg_count => x_msg_count,
5494: x_msg_data => x_msg_data,
5495: p_rgp_id => l_rbk_new_rgp_rec.id,
5497: p_chr_id => NULL,
5498: p_to_template_yn => 'N',
5499: x_rgp_id => x_rgp_id);
5500:
5501: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
5502: RAISE sync_terms_failed;
5503: END IF;
5504:
5505: END LOOP;
5857: -- Supplier Invoice added during rebook
5858:
5859: okl_copy_contract_pub.copy_party_roles(
5860: p_api_version => 1.0,
5861: p_init_msg_list => OKL_API.G_FALSE,
5862: x_return_status => x_return_status,
5863: x_msg_count => x_msg_count,
5864: x_msg_data => x_msg_data,
5865: p_cpl_id => l_party_roles_new_rec.id,
5867: p_chr_id => NULL,
5868: p_rle_code => l_party_roles_new_rec.rle_code,
5869: x_cpl_id => x_cpl_id
5870: );
5871: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
5872: okl_debug_pub.logmessage('okl_copy_contract_pub.copy_party_roles sync_failed ');
5873: RAISE sync_failed;
5874: END IF;
5875:
5885: l_cplv_rec.rle_code := l_party_roles_new_rec.rle_code;
5886:
5887: okl_okc_migration_pvt.update_k_party_role(
5888: p_api_version => 1.0,
5889: p_init_msg_list => OKL_API.G_FALSE,
5890: x_return_status => x_return_status,
5891: x_msg_count => x_msg_count,
5892: x_msg_data => x_msg_data,
5893: p_cplv_rec => l_cplv_rec,
5893: p_cplv_rec => l_cplv_rec,
5894: x_cplv_rec => x_cplv_rec);
5895:
5896: -- check return status
5897: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
5898: okl_debug_pub.logmessage(' okl_okc_migration_pvt.update_contract_item sync_failed ');
5899: RAISE sync_failed;
5900: END IF;
5901:
5932: l_sidv_rec.shipping_address_code := l_supp_invoice_new_rec.shipping_address_code;
5933:
5934: OKL_SUPP_INVOICE_DTLS_PVT.create_sup_inv_dtls(
5935: p_api_version => 1.0,
5936: p_init_msg_list => OKL_API.G_FALSE,
5937: x_return_status => x_return_status,
5938: x_msg_count => x_msg_count,
5939: x_msg_data => x_msg_data,
5940: p_sidv_rec => l_sidv_rec,
5940: p_sidv_rec => l_sidv_rec,
5941: x_sidv_rec => x_sidv_rec);
5942:
5943: -- check return status
5944: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
5945: okl_debug_pub.logmessage(' OKL_SUPP_INVOICE_DTLS_PVT.create_sup_inv_dtls failed ');
5946: RAISE sync_failed;
5947: END IF;
5948:
5945: okl_debug_pub.logmessage(' OKL_SUPP_INVOICE_DTLS_PVT.create_sup_inv_dtls failed ');
5946: RAISE sync_failed;
5947: END IF;
5948:
5949: ELSIF ( NVL(l_supp_invoice_old_rec.invoice_number,OKL_API.G_MISS_CHAR) <> NVL(l_supp_invoice_new_rec.invoice_number,OKL_API.G_MISS_CHAR)
5950: OR NVL(l_supp_invoice_old_rec.date_invoiced,OKL_API.G_MISS_DATE) <> NVL(l_supp_invoice_new_rec.date_invoiced,OKL_API.G_MISS_DATE)
5951: OR NVL(l_supp_invoice_old_rec.shipping_address_id1,OKL_API.G_MISS_NUM) <> NVL(l_supp_invoice_new_rec.shipping_address_id1,OKL_API.G_MISS_NUM)) THEN
5952:
5953: l_sidv_rec := l_sidv_temp_rec;
5946: RAISE sync_failed;
5947: END IF;
5948:
5949: ELSIF ( NVL(l_supp_invoice_old_rec.invoice_number,OKL_API.G_MISS_CHAR) <> NVL(l_supp_invoice_new_rec.invoice_number,OKL_API.G_MISS_CHAR)
5950: OR NVL(l_supp_invoice_old_rec.date_invoiced,OKL_API.G_MISS_DATE) <> NVL(l_supp_invoice_new_rec.date_invoiced,OKL_API.G_MISS_DATE)
5951: OR NVL(l_supp_invoice_old_rec.shipping_address_id1,OKL_API.G_MISS_NUM) <> NVL(l_supp_invoice_new_rec.shipping_address_id1,OKL_API.G_MISS_NUM)) THEN
5952:
5953: l_sidv_rec := l_sidv_temp_rec;
5954:
5947: END IF;
5948:
5949: ELSIF ( NVL(l_supp_invoice_old_rec.invoice_number,OKL_API.G_MISS_CHAR) <> NVL(l_supp_invoice_new_rec.invoice_number,OKL_API.G_MISS_CHAR)
5950: OR NVL(l_supp_invoice_old_rec.date_invoiced,OKL_API.G_MISS_DATE) <> NVL(l_supp_invoice_new_rec.date_invoiced,OKL_API.G_MISS_DATE)
5951: OR NVL(l_supp_invoice_old_rec.shipping_address_id1,OKL_API.G_MISS_NUM) <> NVL(l_supp_invoice_new_rec.shipping_address_id1,OKL_API.G_MISS_NUM)) THEN
5952:
5953: l_sidv_rec := l_sidv_temp_rec;
5954:
5955: l_sidv_rec.id := l_supp_invoice_old_rec.id;
5962: l_sidv_rec.shipping_address_code := l_supp_invoice_new_rec.shipping_address_code;
5963:
5964: OKL_SUPP_INVOICE_DTLS_PVT.update_sup_inv_dtls(
5965: p_api_version => 1.0,
5966: p_init_msg_list => OKL_API.G_FALSE,
5967: x_return_status => x_return_status,
5968: x_msg_count => x_msg_count,
5969: x_msg_data => x_msg_data,
5970: p_sidv_rec => l_sidv_rec,
5970: p_sidv_rec => l_sidv_rec,
5971: x_sidv_rec => x_sidv_rec);
5972:
5973: -- check return status
5974: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
5975: okl_debug_pub.logmessage(' OKL_SUPP_INVOICE_DTLS_PVT.update_sup_inv_dtls failed ');
5976: RAISE sync_failed;
5977: END IF;
5978:
6060: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'new line id: '||l_new_klev_tbl(1).id);
6061: END IF;
6062: okl_copy_asset_pub.copy_all_lines(
6063: p_api_version => 1.0,
6064: p_init_msg_list => OKL_API.G_FALSE,
6065: x_return_status => x_return_status,
6066: x_msg_count => x_msg_count,
6067: x_msg_data => x_msg_data,
6068: p_from_cle_id_tbl => l_new_klev_tbl,
6120: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'new line id: '||l_new_klev_tbl(1).id);
6121: END IF;
6122: okl_copy_asset_pub.copy_all_lines(
6123: p_api_version => 1.0,
6124: p_init_msg_list => OKL_API.G_FALSE,
6125: x_return_status => x_return_status,
6126: x_msg_count => x_msg_count,
6127: x_msg_data => x_msg_data,
6128: p_from_cle_id_tbl => l_new_klev_tbl,
6180: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'new line id: '||l_new_klev_tbl(1).id);
6181: END IF;
6182: okl_copy_asset_pub.copy_all_lines(
6183: p_api_version => 1.0,
6184: p_init_msg_list => OKL_API.G_FALSE,
6185: x_return_status => x_return_status,
6186: x_msg_count => x_msg_count,
6187: x_msg_data => x_msg_data,
6188: p_from_cle_id_tbl => l_new_klev_tbl,
6225: l_sidv_rec.shipping_address_code := l_supp_invoice_new_rec.shipping_address_code;
6226:
6227: OKL_SUPP_INVOICE_DTLS_PVT.create_sup_inv_dtls(
6228: p_api_version => 1.0,
6229: p_init_msg_list => OKL_API.G_FALSE,
6230: x_return_status => x_return_status,
6231: x_msg_count => x_msg_count,
6232: x_msg_data => x_msg_data,
6233: p_sidv_rec => l_sidv_rec,
6233: p_sidv_rec => l_sidv_rec,
6234: x_sidv_rec => x_sidv_rec);
6235:
6236: -- check return status
6237: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6238: okl_debug_pub.logmessage(' OKL_SUPP_INVOICE_DTLS_PVT.create_sup_inv_dtls failed ');
6239: RAISE sync_failed;
6240: END IF;
6241: END IF;
6448:
6449: -- Update contrat header with new start and end date
6450: okl_contract_pub.update_contract_header(
6451: p_api_version => 1.0,
6452: p_init_msg_list => OKL_API.G_FALSE,
6453: x_return_status => x_return_status,
6454: x_msg_count => x_msg_count,
6455: x_msg_data => x_msg_data,
6456: p_restricted_update => OKL_API.G_FALSE,
6452: p_init_msg_list => OKL_API.G_FALSE,
6453: x_return_status => x_return_status,
6454: x_msg_count => x_msg_count,
6455: x_msg_data => x_msg_data,
6456: p_restricted_update => OKL_API.G_FALSE,
6457: p_chrv_rec => l_chrv_rec,
6458: p_khrv_rec => l_khrv_rec,
6459: x_chrv_rec => x_chrv_rec,
6460: x_khrv_rec => x_khrv_rec
6469: END IF;
6470:
6471: EXCEPTION
6472: WHEN check_update_failed THEN
6473: x_return_status := OKL_API.G_RET_STS_ERROR;
6474: END check_and_update_date;
6475:
6476: --Bug# 8652738
6477: ------------------------------------------------------------------------------
6770: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
6771: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
6772: END IF;
6773:
6774: x_return_status := OKL_API.G_RET_STS_SUCCESS;
6775:
6776: -- Sync rule groups that existed on the original contract
6777: FOR l_rgp_orig_rec IN l_rgp_orig_csr(p_chr_id => p_orig_chr_id) LOOP
6778:
6798: -- Rule exists on rebook copy contract
6799: IF (l_rul_rbk_rec.id IS NOT NULL) THEN
6800:
6801: -- Check for changes during rebook
6802: IF (NVL(l_rul_rbk_rec.rule_information1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information1,OKL_API.G_MISS_CHAR)
6803: OR
6804: NVL(l_rul_rbk_rec.rule_information2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information2,OKL_API.G_MISS_CHAR)
6805: OR
6806: NVL(l_rul_rbk_rec.rule_information3,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information3,OKL_API.G_MISS_CHAR)
6800:
6801: -- Check for changes during rebook
6802: IF (NVL(l_rul_rbk_rec.rule_information1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information1,OKL_API.G_MISS_CHAR)
6803: OR
6804: NVL(l_rul_rbk_rec.rule_information2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information2,OKL_API.G_MISS_CHAR)
6805: OR
6806: NVL(l_rul_rbk_rec.rule_information3,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information3,OKL_API.G_MISS_CHAR)
6807: OR
6808: NVL(l_rul_rbk_rec.rule_information4,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information4,OKL_API.G_MISS_CHAR)
6802: IF (NVL(l_rul_rbk_rec.rule_information1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information1,OKL_API.G_MISS_CHAR)
6803: OR
6804: NVL(l_rul_rbk_rec.rule_information2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information2,OKL_API.G_MISS_CHAR)
6805: OR
6806: NVL(l_rul_rbk_rec.rule_information3,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information3,OKL_API.G_MISS_CHAR)
6807: OR
6808: NVL(l_rul_rbk_rec.rule_information4,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information4,OKL_API.G_MISS_CHAR)
6809: OR
6810: NVL(l_rul_rbk_rec.rule_information5,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information5,OKL_API.G_MISS_CHAR)
6804: NVL(l_rul_rbk_rec.rule_information2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information2,OKL_API.G_MISS_CHAR)
6805: OR
6806: NVL(l_rul_rbk_rec.rule_information3,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information3,OKL_API.G_MISS_CHAR)
6807: OR
6808: NVL(l_rul_rbk_rec.rule_information4,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information4,OKL_API.G_MISS_CHAR)
6809: OR
6810: NVL(l_rul_rbk_rec.rule_information5,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information5,OKL_API.G_MISS_CHAR)
6811: OR
6812: NVL(l_rul_rbk_rec.rule_information6,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information6,OKL_API.G_MISS_CHAR)
6806: NVL(l_rul_rbk_rec.rule_information3,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information3,OKL_API.G_MISS_CHAR)
6807: OR
6808: NVL(l_rul_rbk_rec.rule_information4,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information4,OKL_API.G_MISS_CHAR)
6809: OR
6810: NVL(l_rul_rbk_rec.rule_information5,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information5,OKL_API.G_MISS_CHAR)
6811: OR
6812: NVL(l_rul_rbk_rec.rule_information6,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information6,OKL_API.G_MISS_CHAR)
6813: OR
6814: NVL(l_rul_rbk_rec.rule_information7,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information7,OKL_API.G_MISS_CHAR)
6808: NVL(l_rul_rbk_rec.rule_information4,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information4,OKL_API.G_MISS_CHAR)
6809: OR
6810: NVL(l_rul_rbk_rec.rule_information5,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information5,OKL_API.G_MISS_CHAR)
6811: OR
6812: NVL(l_rul_rbk_rec.rule_information6,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information6,OKL_API.G_MISS_CHAR)
6813: OR
6814: NVL(l_rul_rbk_rec.rule_information7,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information7,OKL_API.G_MISS_CHAR)
6815: OR
6816: NVL(l_rul_rbk_rec.rule_information8,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information8,OKL_API.G_MISS_CHAR)
6810: NVL(l_rul_rbk_rec.rule_information5,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information5,OKL_API.G_MISS_CHAR)
6811: OR
6812: NVL(l_rul_rbk_rec.rule_information6,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information6,OKL_API.G_MISS_CHAR)
6813: OR
6814: NVL(l_rul_rbk_rec.rule_information7,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information7,OKL_API.G_MISS_CHAR)
6815: OR
6816: NVL(l_rul_rbk_rec.rule_information8,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information8,OKL_API.G_MISS_CHAR)
6817: OR
6818: NVL(l_rul_rbk_rec.rule_information9,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information9,OKL_API.G_MISS_CHAR)
6812: NVL(l_rul_rbk_rec.rule_information6,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information6,OKL_API.G_MISS_CHAR)
6813: OR
6814: NVL(l_rul_rbk_rec.rule_information7,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information7,OKL_API.G_MISS_CHAR)
6815: OR
6816: NVL(l_rul_rbk_rec.rule_information8,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information8,OKL_API.G_MISS_CHAR)
6817: OR
6818: NVL(l_rul_rbk_rec.rule_information9,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information9,OKL_API.G_MISS_CHAR)
6819: OR
6820: NVL(l_rul_rbk_rec.rule_information10,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information10,OKL_API.G_MISS_CHAR)
6814: NVL(l_rul_rbk_rec.rule_information7,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information7,OKL_API.G_MISS_CHAR)
6815: OR
6816: NVL(l_rul_rbk_rec.rule_information8,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information8,OKL_API.G_MISS_CHAR)
6817: OR
6818: NVL(l_rul_rbk_rec.rule_information9,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information9,OKL_API.G_MISS_CHAR)
6819: OR
6820: NVL(l_rul_rbk_rec.rule_information10,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information10,OKL_API.G_MISS_CHAR)
6821: OR
6822: NVL(l_rul_rbk_rec.rule_information11,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information11,OKL_API.G_MISS_CHAR)
6816: NVL(l_rul_rbk_rec.rule_information8,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information8,OKL_API.G_MISS_CHAR)
6817: OR
6818: NVL(l_rul_rbk_rec.rule_information9,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information9,OKL_API.G_MISS_CHAR)
6819: OR
6820: NVL(l_rul_rbk_rec.rule_information10,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information10,OKL_API.G_MISS_CHAR)
6821: OR
6822: NVL(l_rul_rbk_rec.rule_information11,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information11,OKL_API.G_MISS_CHAR)
6823: OR
6824: NVL(l_rul_rbk_rec.rule_information12,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information12,OKL_API.G_MISS_CHAR)
6818: NVL(l_rul_rbk_rec.rule_information9,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information9,OKL_API.G_MISS_CHAR)
6819: OR
6820: NVL(l_rul_rbk_rec.rule_information10,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information10,OKL_API.G_MISS_CHAR)
6821: OR
6822: NVL(l_rul_rbk_rec.rule_information11,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information11,OKL_API.G_MISS_CHAR)
6823: OR
6824: NVL(l_rul_rbk_rec.rule_information12,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information12,OKL_API.G_MISS_CHAR)
6825: OR
6826: NVL(l_rul_rbk_rec.rule_information13,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information13,OKL_API.G_MISS_CHAR)
6820: NVL(l_rul_rbk_rec.rule_information10,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information10,OKL_API.G_MISS_CHAR)
6821: OR
6822: NVL(l_rul_rbk_rec.rule_information11,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information11,OKL_API.G_MISS_CHAR)
6823: OR
6824: NVL(l_rul_rbk_rec.rule_information12,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information12,OKL_API.G_MISS_CHAR)
6825: OR
6826: NVL(l_rul_rbk_rec.rule_information13,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information13,OKL_API.G_MISS_CHAR)
6827: OR
6828: NVL(l_rul_rbk_rec.rule_information14,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information14,OKL_API.G_MISS_CHAR)
6822: NVL(l_rul_rbk_rec.rule_information11,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information11,OKL_API.G_MISS_CHAR)
6823: OR
6824: NVL(l_rul_rbk_rec.rule_information12,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information12,OKL_API.G_MISS_CHAR)
6825: OR
6826: NVL(l_rul_rbk_rec.rule_information13,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information13,OKL_API.G_MISS_CHAR)
6827: OR
6828: NVL(l_rul_rbk_rec.rule_information14,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information14,OKL_API.G_MISS_CHAR)
6829: OR
6830: NVL(l_rul_rbk_rec.rule_information15,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information15,OKL_API.G_MISS_CHAR)
6824: NVL(l_rul_rbk_rec.rule_information12,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information12,OKL_API.G_MISS_CHAR)
6825: OR
6826: NVL(l_rul_rbk_rec.rule_information13,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information13,OKL_API.G_MISS_CHAR)
6827: OR
6828: NVL(l_rul_rbk_rec.rule_information14,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information14,OKL_API.G_MISS_CHAR)
6829: OR
6830: NVL(l_rul_rbk_rec.rule_information15,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information15,OKL_API.G_MISS_CHAR)
6831: OR
6832: NVL(l_rul_rbk_rec.object1_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object1_id1,OKL_API.G_MISS_CHAR)
6826: NVL(l_rul_rbk_rec.rule_information13,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information13,OKL_API.G_MISS_CHAR)
6827: OR
6828: NVL(l_rul_rbk_rec.rule_information14,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information14,OKL_API.G_MISS_CHAR)
6829: OR
6830: NVL(l_rul_rbk_rec.rule_information15,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information15,OKL_API.G_MISS_CHAR)
6831: OR
6832: NVL(l_rul_rbk_rec.object1_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object1_id1,OKL_API.G_MISS_CHAR)
6833: OR
6834: NVL(l_rul_rbk_rec.object2_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object2_id1,OKL_API.G_MISS_CHAR)
6828: NVL(l_rul_rbk_rec.rule_information14,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information14,OKL_API.G_MISS_CHAR)
6829: OR
6830: NVL(l_rul_rbk_rec.rule_information15,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information15,OKL_API.G_MISS_CHAR)
6831: OR
6832: NVL(l_rul_rbk_rec.object1_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object1_id1,OKL_API.G_MISS_CHAR)
6833: OR
6834: NVL(l_rul_rbk_rec.object2_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object2_id1,OKL_API.G_MISS_CHAR)
6835: OR
6836: NVL(l_rul_rbk_rec.object3_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object3_id1,OKL_API.G_MISS_CHAR)
6830: NVL(l_rul_rbk_rec.rule_information15,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.rule_information15,OKL_API.G_MISS_CHAR)
6831: OR
6832: NVL(l_rul_rbk_rec.object1_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object1_id1,OKL_API.G_MISS_CHAR)
6833: OR
6834: NVL(l_rul_rbk_rec.object2_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object2_id1,OKL_API.G_MISS_CHAR)
6835: OR
6836: NVL(l_rul_rbk_rec.object3_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object3_id1,OKL_API.G_MISS_CHAR)
6837: OR
6838: NVL(l_rul_rbk_rec.object1_id2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object1_id2,OKL_API.G_MISS_CHAR)
6832: NVL(l_rul_rbk_rec.object1_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object1_id1,OKL_API.G_MISS_CHAR)
6833: OR
6834: NVL(l_rul_rbk_rec.object2_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object2_id1,OKL_API.G_MISS_CHAR)
6835: OR
6836: NVL(l_rul_rbk_rec.object3_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object3_id1,OKL_API.G_MISS_CHAR)
6837: OR
6838: NVL(l_rul_rbk_rec.object1_id2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object1_id2,OKL_API.G_MISS_CHAR)
6839: OR
6840: NVL(l_rul_rbk_rec.object2_id2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object2_id2,OKL_API.G_MISS_CHAR)
6834: NVL(l_rul_rbk_rec.object2_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object2_id1,OKL_API.G_MISS_CHAR)
6835: OR
6836: NVL(l_rul_rbk_rec.object3_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object3_id1,OKL_API.G_MISS_CHAR)
6837: OR
6838: NVL(l_rul_rbk_rec.object1_id2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object1_id2,OKL_API.G_MISS_CHAR)
6839: OR
6840: NVL(l_rul_rbk_rec.object2_id2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object2_id2,OKL_API.G_MISS_CHAR)
6841: OR
6842: NVL(l_rul_rbk_rec.object3_id2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object3_id2,OKL_API.G_MISS_CHAR)
6836: NVL(l_rul_rbk_rec.object3_id1,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object3_id1,OKL_API.G_MISS_CHAR)
6837: OR
6838: NVL(l_rul_rbk_rec.object1_id2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object1_id2,OKL_API.G_MISS_CHAR)
6839: OR
6840: NVL(l_rul_rbk_rec.object2_id2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object2_id2,OKL_API.G_MISS_CHAR)
6841: OR
6842: NVL(l_rul_rbk_rec.object3_id2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object3_id2,OKL_API.G_MISS_CHAR)
6843: ) THEN
6844:
6838: NVL(l_rul_rbk_rec.object1_id2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object1_id2,OKL_API.G_MISS_CHAR)
6839: OR
6840: NVL(l_rul_rbk_rec.object2_id2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object2_id2,OKL_API.G_MISS_CHAR)
6841: OR
6842: NVL(l_rul_rbk_rec.object3_id2,OKL_API.G_MISS_CHAR) <> NVL(l_rul_orig_rec.object3_id2,OKL_API.G_MISS_CHAR)
6843: ) THEN
6844:
6845: l_rul_rbk_rec.id := l_rul_orig_rec.id;
6846: l_rul_rbk_rec.rgp_id := l_rul_orig_rec.rgp_id;
6847: l_rul_rbk_rec.dnz_chr_id := l_rul_orig_rec.dnz_chr_id;
6848:
6849: okl_rule_pub.update_rule(
6850: p_api_version => 1.0,
6851: p_init_msg_list => OKL_API.G_FALSE,
6852: x_return_status => x_return_status,
6853: x_msg_count => x_msg_count,
6854: x_msg_data => x_msg_data,
6855: p_rulv_rec => l_rul_rbk_rec,
6855: p_rulv_rec => l_rul_rbk_rec,
6856: x_rulv_rec => x_rulv_rec
6857: );
6858:
6859: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6860: RAISE sync_terms_failed;
6861: END IF;
6862:
6863: END IF;
6868: l_rulv_rec.id := l_rul_orig_rec.id;
6869:
6870: okl_rule_pub.delete_rule(
6871: p_api_version => 1.0,
6872: p_init_msg_list => OKL_API.G_FALSE,
6873: x_return_status => x_return_status,
6874: x_msg_count => x_msg_count,
6875: x_msg_data => x_msg_data,
6876: p_rulv_rec => l_rulv_rec);
6874: x_msg_count => x_msg_count,
6875: x_msg_data => x_msg_data,
6876: p_rulv_rec => l_rulv_rec);
6877:
6878: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6879: RAISE sync_terms_failed;
6880: END IF;
6881:
6882: END IF;
6898: l_rul_rbk_rec.dnz_chr_id := p_orig_chr_id;
6899:
6900: okl_rule_pub.create_rule(
6901: p_api_version => 1.0,
6902: p_init_msg_list => OKL_API.G_FALSE,
6903: x_return_status => x_return_status,
6904: x_msg_count => x_msg_count,
6905: x_msg_data => x_msg_data,
6906: p_rulv_rec => l_rul_rbk_rec,
6905: x_msg_data => x_msg_data,
6906: p_rulv_rec => l_rul_rbk_rec,
6907: x_rulv_rec => x_rulv_rec);
6908:
6909: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6910: CLOSE l_rbk_new_rul_csr;
6911: RAISE sync_terms_failed;
6912: END IF;
6913:
6922: l_rgpv_rec.id := l_rgp_orig_rec.id;
6923:
6924: okl_rule_pub.delete_rule_group(
6925: p_api_version => 1.0,
6926: p_init_msg_list => OKL_API.G_FALSE,
6927: x_return_status => x_return_status,
6928: x_msg_count => x_msg_count,
6929: x_msg_data => x_msg_data,
6930: p_rgpv_rec => l_rgpv_rec);
6928: x_msg_count => x_msg_count,
6929: x_msg_data => x_msg_data,
6930: p_rgpv_rec => l_rgpv_rec);
6931:
6932: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6933: RAISE sync_terms_failed;
6934: END IF;
6935:
6936: END IF;
6941: p_rebook_chr_id => p_rebook_chr_id) LOOP
6942:
6943: okl_copy_contract_pvt.copy_rules(
6944: p_api_version => 1.0,
6945: p_init_msg_list => OKL_API.G_FALSE,
6946: x_return_status => x_return_status,
6947: x_msg_count => x_msg_count,
6948: x_msg_data => x_msg_data,
6949: p_rgp_id => l_rbk_new_rgp_rec.id,
6951: p_chr_id => p_orig_chr_id,
6952: p_to_template_yn => 'N',
6953: x_rgp_id => x_rgp_id);
6954:
6955: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
6956: RAISE sync_terms_failed;
6957: END IF;
6958:
6959: END LOOP;
7047: p_chr_id => p_rebook_chr_id,
7048: x_orig_chr_id => l_orig_chr_id
7049: );
7050: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7051: okl_api.set_message(
7052: G_APP_NAME,
7053: G_LLA_NO_ORIG_REFERENCE
7054: );
7055: RAISE OKC_API.G_EXCEPTION_ERROR;
7221: RAISE OKC_API.G_EXCEPTION_ERROR;
7222: END IF;
7223:
7224: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
7225: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
7226: x_msg_data => x_msg_data);
7227:
7228: EXCEPTION
7229: WHEN OKC_API.G_EXCEPTION_ERROR THEN
7329:
7330:
7331: EXCEPTION
7332: WHEN OTHERS THEN
7333: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
7334: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7335: END raise_business_event;
7336:
7337:
7330:
7331: EXCEPTION
7332: WHEN OTHERS THEN
7333: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
7334: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7335: END raise_business_event;
7336:
7337:
7338: /*
7375: THEN
7376:
7377: l_icx_date_format := NVL(fnd_profile.value('ICX_DATE_FORMAT_MASK'),'DD-MON-RRRR');
7378:
7379: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
7380: p_msg_name => 'OKL_LLA_CHK_RBK_LIMIT_DATE',
7381: p_token1 => 'REBOOK_LIMIT_DATE',
7382: p_token1_value => TO_CHAR(FND_DATE.canonical_to_date(l_rbk_limit_date_rec.rule_information1),l_icx_date_format));
7383: RAISE OKC_API.G_EXCEPTION_ERROR;
7428: */
7429: raise_business_event(p_chr_id => p_from_chr_id
7430: ,p_new_chr_id => x_rebook_chr_id
7431: ,x_return_status => x_return_status);
7432: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
7433: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7434: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7435: RAISE OKL_API.G_EXCEPTION_ERROR;
7436: END IF;
7429: raise_business_event(p_chr_id => p_from_chr_id
7430: ,p_new_chr_id => x_rebook_chr_id
7431: ,x_return_status => x_return_status);
7432: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
7433: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7434: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7435: RAISE OKL_API.G_EXCEPTION_ERROR;
7436: END IF;
7437:
7430: ,p_new_chr_id => x_rebook_chr_id
7431: ,x_return_status => x_return_status);
7432: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
7433: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7434: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7435: RAISE OKL_API.G_EXCEPTION_ERROR;
7436: END IF;
7437:
7438: /*
7431: ,x_return_status => x_return_status);
7432: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
7433: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7434: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7435: RAISE OKL_API.G_EXCEPTION_ERROR;
7436: END IF;
7437:
7438: /*
7439: -- mvasudev, 08/23/2004
7440: -- END, Code change to enable Business Event
7441: */
7442:
7443: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
7444: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
7445: x_msg_data => x_msg_data);
7446:
7447: EXCEPTION
7448: WHEN OKC_API.G_EXCEPTION_ERROR THEN
7577: x_value => l_contract_secu,
7578: x_inv_agmt_chr_id_tbl => l_inv_agmt_chr_id_tbl
7579: );
7580:
7581: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
7582: RAISE secu_failed;
7583: END IF;
7584:
7585: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7585: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7586: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Contract Securitized? '||l_contract_secu);
7587: END IF;
7588:
7589: IF (l_contract_secu <> OKL_API.G_TRUE) THEN -- Do not proceed, return success
7590: x_return_status := OKL_API.G_RET_STS_SUCCESS;
7591: RETURN;
7592: END IF;
7593:
7586: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Contract Securitized? '||l_contract_secu);
7587: END IF;
7588:
7589: IF (l_contract_secu <> OKL_API.G_TRUE) THEN -- Do not proceed, return success
7590: x_return_status := OKL_API.G_RET_STS_SUCCESS;
7591: RETURN;
7592: END IF;
7593:
7594: --
7723: -- Generate Investor accrual streams
7724: --
7725: OKL_ACCRUAL_SEC_PVT.CREATE_STREAMS(
7726: p_api_version => 1.0,
7727: p_init_msg_list => OKL_API.G_FALSE,
7728: x_return_status => x_return_status,
7729: x_msg_count => x_msg_count,
7730: x_msg_data => x_msg_data,
7731: p_khr_id => p_orig_chr_id
7842: p_chr_id => p_chr_id,
7843: x_orig_chr_id => l_orig_chr_id
7844: );
7845: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
7846: okl_api.set_message(
7847: G_APP_NAME,
7848: G_LLA_NO_ORIG_REFERENCE
7849: );
7850: RAISE OKC_API.G_EXCEPTION_ERROR;
7997: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7998: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After call okl_generate_accruals_pvt.adjust_accruals'||x_return_status);
7999: END IF;
8000:
8001: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
8002: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
8003: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
8004: RAISE Okl_Api.G_EXCEPTION_ERROR;
8005: END IF;
7998: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After call okl_generate_accruals_pvt.adjust_accruals'||x_return_status);
7999: END IF;
8000:
8001: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
8002: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
8003: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
8004: RAISE Okl_Api.G_EXCEPTION_ERROR;
8005: END IF;
8006: END IF;
7999: END IF;
8000:
8001: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
8002: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
8003: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
8004: RAISE Okl_Api.G_EXCEPTION_ERROR;
8005: END IF;
8006: END IF;
8007: -- Bug# 4775555: End
8000:
8001: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
8002: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
8003: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
8004: RAISE Okl_Api.G_EXCEPTION_ERROR;
8005: END IF;
8006: END IF;
8007: -- Bug# 4775555: End
8008:
8062: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
8063: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After call okl_generate_accruals_pvt.adjust_accruals'||x_return_status);
8064: END IF;
8065:
8066: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
8067: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
8068: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
8069: RAISE Okl_Api.G_EXCEPTION_ERROR;
8070: END IF;
8063: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After call okl_generate_accruals_pvt.adjust_accruals'||x_return_status);
8064: END IF;
8065:
8066: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
8067: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
8068: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
8069: RAISE Okl_Api.G_EXCEPTION_ERROR;
8070: END IF;
8071: END IF;
8064: END IF;
8065:
8066: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
8067: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
8068: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
8069: RAISE Okl_Api.G_EXCEPTION_ERROR;
8070: END IF;
8071: END IF;
8072:
8065:
8066: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
8067: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
8068: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
8069: RAISE Okl_Api.G_EXCEPTION_ERROR;
8070: END IF;
8071: END IF;
8072:
8073: END IF;
8073: END IF;
8074: -- MGAAP end 7263041
8075:
8076: --**********************************************************
8077: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
8078: x_msg_data => x_msg_data);
8079:
8080: EXCEPTION
8081: WHEN OKC_API.G_EXCEPTION_ERROR THEN
8202: OPEN orig_csr(p_from_chr_id);
8203: FETCH orig_csr INTO l_orig_contract_number, l_orig_sts_code;--:| 24-Mar-08 cklee Bug# 6801137 -- Added validation logic |
8204:
8205: IF orig_csr%NOTFOUND THEN
8206: okl_api.set_message(
8207: G_APP_NAME,
8208: G_LLA_CHR_ID
8209: );
8210: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8210: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8211: --start:| 24-Mar-08 cklee Bug# 6801137 -- Added validation logic |
8212: ELSE
8213: IF l_orig_sts_code <> 'BOOKED' THEN
8214: okl_api.set_message(
8215: G_APP_NAME,
8216: 'OKL_LLA_REV_ONLY_BOOKED'
8217: );
8218: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
8343:
8344: x_rebook_chr_id := x_chr_id;
8345:
8346: --**********************************************************
8347: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
8348: x_msg_data => x_msg_data);
8349:
8350: EXCEPTION
8351: WHEN OKC_API.G_EXCEPTION_ERROR THEN
8508: IF (G_DEBUG_ENABLED = 'Y') THEN
8509: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
8510: END IF;
8511:
8512: x_return_status := OKL_API.G_RET_STS_SUCCESS;
8513: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
8514: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
8515: END IF;
8516: -- call START_ACTIVITY to create savepoint, check compatibility
8514: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
8515: END IF;
8516: -- call START_ACTIVITY to create savepoint, check compatibility
8517: -- and initialize message list
8518: x_return_status := OKL_API.START_ACTIVITY(
8519: p_api_name => l_api_name,
8520: p_pkg_name => G_PKG_NAME,
8521: p_init_msg_list => p_init_msg_list,
8522: l_api_version => l_api_version,
8524: p_api_type => G_API_TYPE,
8525: x_return_status => x_return_status);
8526:
8527: -- check if activity started successfully
8528: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8529: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8530: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8531: raise OKL_API.G_EXCEPTION_ERROR;
8532: END IF;
8525: x_return_status => x_return_status);
8526:
8527: -- check if activity started successfully
8528: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8529: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8530: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8531: raise OKL_API.G_EXCEPTION_ERROR;
8532: END IF;
8533:
8526:
8527: -- check if activity started successfully
8528: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8529: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8530: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8531: raise OKL_API.G_EXCEPTION_ERROR;
8532: END IF;
8533:
8534: --Bug# 6344223
8527: -- check if activity started successfully
8528: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8529: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8530: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8531: raise OKL_API.G_EXCEPTION_ERROR;
8532: END IF;
8533:
8534: --Bug# 6344223
8535: OPEN check_split_trx_csr;
8633:
8634: -- Call Streams api to update Link_Hist_Stream_Id and Trx_Id
8635: okl_streams_pub.update_streams(
8636: p_api_version => 1.0,
8637: p_init_msg_list => OKL_API.G_FALSE,
8638: x_return_status => x_return_status,
8639: x_msg_count => x_msg_count,
8640: x_msg_data => x_msg_data,
8641: p_stmv_tbl => l_new_strm_tbl,
8645: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
8646: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of New Strms - Trx ID and Hist ID '||x_return_status);
8647: END IF;
8648:
8649: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8650: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8651: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8652: raise OKL_API.G_EXCEPTION_ERROR;
8653: END IF;
8646: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of New Strms - Trx ID and Hist ID '||x_return_status);
8647: END IF;
8648:
8649: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8650: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8651: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8652: raise OKL_API.G_EXCEPTION_ERROR;
8653: END IF;
8654: END IF;
8647: END IF;
8648:
8649: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8650: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8651: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8652: raise OKL_API.G_EXCEPTION_ERROR;
8653: END IF;
8654: END IF;
8655: END IF;
8648:
8649: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8650: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8651: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8652: raise OKL_API.G_EXCEPTION_ERROR;
8653: END IF;
8654: END IF;
8655: END IF;
8656:
8653: END IF;
8654: END IF;
8655: END IF;
8656:
8657: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
8658: x_msg_data => x_msg_data);
8659:
8660: EXCEPTION
8661: when OKL_API.G_EXCEPTION_ERROR then
8657: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
8658: x_msg_data => x_msg_data);
8659:
8660: EXCEPTION
8661: when OKL_API.G_EXCEPTION_ERROR then
8662: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8663: p_api_name => l_api_name,
8664: p_pkg_name => G_PKG_NAME,
8665: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
8658: x_msg_data => x_msg_data);
8659:
8660: EXCEPTION
8661: when OKL_API.G_EXCEPTION_ERROR then
8662: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8663: p_api_name => l_api_name,
8664: p_pkg_name => G_PKG_NAME,
8665: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
8666: x_msg_count => x_msg_count,
8661: when OKL_API.G_EXCEPTION_ERROR then
8662: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8663: p_api_name => l_api_name,
8664: p_pkg_name => G_PKG_NAME,
8665: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
8666: x_msg_count => x_msg_count,
8667: x_msg_data => x_msg_data,
8668: p_api_type => G_API_TYPE);
8669:
8666: x_msg_count => x_msg_count,
8667: x_msg_data => x_msg_data,
8668: p_api_type => G_API_TYPE);
8669:
8670: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
8671: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8672: p_api_name => l_api_name,
8673: p_pkg_name => G_PKG_NAME,
8674: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
8667: x_msg_data => x_msg_data,
8668: p_api_type => G_API_TYPE);
8669:
8670: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
8671: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8672: p_api_name => l_api_name,
8673: p_pkg_name => G_PKG_NAME,
8674: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
8675: x_msg_count => x_msg_count,
8670: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
8671: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8672: p_api_name => l_api_name,
8673: p_pkg_name => G_PKG_NAME,
8674: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
8675: x_msg_count => x_msg_count,
8676: x_msg_data => x_msg_data,
8677: p_api_type => G_API_TYPE);
8678:
8676: x_msg_data => x_msg_data,
8677: p_api_type => G_API_TYPE);
8678:
8679: when OTHERS then
8680: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8681: p_api_name => l_api_name,
8682: p_pkg_name => G_PKG_NAME,
8683: p_exc_name => 'OTHERS',
8684: x_msg_count => x_msg_count,
8803: IF (G_DEBUG_ENABLED = 'Y') THEN
8804: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
8805: END IF;
8806:
8807: x_return_status := OKL_API.G_RET_STS_SUCCESS;
8808: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
8809: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
8810: END IF;
8811: -- call START_ACTIVITY to create savepoint, check compatibility
8809: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
8810: END IF;
8811: -- call START_ACTIVITY to create savepoint, check compatibility
8812: -- and initialize message list
8813: x_return_status := OKL_API.START_ACTIVITY(
8814: p_api_name => l_api_name,
8815: p_pkg_name => G_PKG_NAME,
8816: p_init_msg_list => p_init_msg_list,
8817: l_api_version => l_api_version,
8819: p_api_type => G_API_TYPE,
8820: x_return_status => x_return_status);
8821:
8822: -- check if activity started successfully
8823: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8824: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8825: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8826: raise OKL_API.G_EXCEPTION_ERROR;
8827: END IF;
8820: x_return_status => x_return_status);
8821:
8822: -- check if activity started successfully
8823: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8824: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8825: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8826: raise OKL_API.G_EXCEPTION_ERROR;
8827: END IF;
8828:
8821:
8822: -- check if activity started successfully
8823: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8824: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8825: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8826: raise OKL_API.G_EXCEPTION_ERROR;
8827: END IF;
8828:
8829: -- For On-line and Mass rebook, calculate disbursement adjustment
8822: -- check if activity started successfully
8823: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8824: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8825: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8826: raise OKL_API.G_EXCEPTION_ERROR;
8827: END IF;
8828:
8829: -- For On-line and Mass rebook, calculate disbursement adjustment
8830: -- for all Current Billable Streams for which disbursement was done
8907:
8908: IF (l_selv_tbl.COUNT > 0) THEN
8909: okl_streams_pub.update_stream_elements(
8910: p_api_version => 1.0,
8911: p_init_msg_list => OKL_API.G_FALSE,
8912: x_return_status => x_return_status,
8913: x_msg_count => x_msg_count,
8914: x_msg_data => x_msg_data,
8915: p_selv_tbl => l_selv_tbl,
8919: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
8920: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of Stream Elements - Date Disbursed '||x_return_status);
8921: END IF;
8922:
8923: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8924: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8925: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8926: raise OKL_API.G_EXCEPTION_ERROR;
8927: END IF;
8920: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of Stream Elements - Date Disbursed '||x_return_status);
8921: END IF;
8922:
8923: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8924: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8925: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8926: raise OKL_API.G_EXCEPTION_ERROR;
8927: END IF;
8928: END IF;
8921: END IF;
8922:
8923: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8924: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8925: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8926: raise OKL_API.G_EXCEPTION_ERROR;
8927: END IF;
8928: END IF;
8929:
8922:
8923: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8924: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8925: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8926: raise OKL_API.G_EXCEPTION_ERROR;
8927: END IF;
8928: END IF;
8929:
8930: END IF;
9001: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
9002: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After calling OKL_BPD_TERMINATION_ADJ_PVT.create_rbk_passthru_adj '||x_return_status);
9003: END IF;
9004:
9005: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9006: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9007: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9008: RAISE OKL_API.G_EXCEPTION_ERROR;
9009: END IF;
9002: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After calling OKL_BPD_TERMINATION_ADJ_PVT.create_rbk_passthru_adj '||x_return_status);
9003: END IF;
9004:
9005: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9006: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9007: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9008: RAISE OKL_API.G_EXCEPTION_ERROR;
9009: END IF;
9010: -- sjalasut, added code for Contract Rebook Enhancement. END
9003: END IF;
9004:
9005: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9006: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9007: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9008: RAISE OKL_API.G_EXCEPTION_ERROR;
9009: END IF;
9010: -- sjalasut, added code for Contract Rebook Enhancement. END
9011:
9004:
9005: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9006: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9007: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9008: RAISE OKL_API.G_EXCEPTION_ERROR;
9009: END IF;
9010: -- sjalasut, added code for Contract Rebook Enhancement. END
9011:
9012: END IF;
9010: -- sjalasut, added code for Contract Rebook Enhancement. END
9011:
9012: END IF;
9013:
9014: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
9015: x_msg_data => x_msg_data);
9016:
9017: EXCEPTION
9018: when OKL_API.G_EXCEPTION_ERROR then
9014: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
9015: x_msg_data => x_msg_data);
9016:
9017: EXCEPTION
9018: when OKL_API.G_EXCEPTION_ERROR then
9019: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9020: p_api_name => l_api_name,
9021: p_pkg_name => G_PKG_NAME,
9022: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
9015: x_msg_data => x_msg_data);
9016:
9017: EXCEPTION
9018: when OKL_API.G_EXCEPTION_ERROR then
9019: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9020: p_api_name => l_api_name,
9021: p_pkg_name => G_PKG_NAME,
9022: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
9023: x_msg_count => x_msg_count,
9018: when OKL_API.G_EXCEPTION_ERROR then
9019: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9020: p_api_name => l_api_name,
9021: p_pkg_name => G_PKG_NAME,
9022: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
9023: x_msg_count => x_msg_count,
9024: x_msg_data => x_msg_data,
9025: p_api_type => G_API_TYPE);
9026:
9023: x_msg_count => x_msg_count,
9024: x_msg_data => x_msg_data,
9025: p_api_type => G_API_TYPE);
9026:
9027: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
9028: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9029: p_api_name => l_api_name,
9030: p_pkg_name => G_PKG_NAME,
9031: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
9024: x_msg_data => x_msg_data,
9025: p_api_type => G_API_TYPE);
9026:
9027: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
9028: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9029: p_api_name => l_api_name,
9030: p_pkg_name => G_PKG_NAME,
9031: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
9032: x_msg_count => x_msg_count,
9027: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
9028: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9029: p_api_name => l_api_name,
9030: p_pkg_name => G_PKG_NAME,
9031: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
9032: x_msg_count => x_msg_count,
9033: x_msg_data => x_msg_data,
9034: p_api_type => G_API_TYPE);
9035:
9033: x_msg_data => x_msg_data,
9034: p_api_type => G_API_TYPE);
9035:
9036: when OTHERS then
9037: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9038: p_api_name => l_api_name,
9039: p_pkg_name => G_PKG_NAME,
9040: p_exc_name => 'OTHERS',
9041: x_msg_count => x_msg_count,
9158: IF (G_DEBUG_ENABLED = 'Y') THEN
9159: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
9160: END IF;
9161:
9162: x_return_status := OKL_API.G_RET_STS_SUCCESS;
9163: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
9164: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
9165: END IF;
9166: -- call START_ACTIVITY to create savepoint, check compatibility
9164: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
9165: END IF;
9166: -- call START_ACTIVITY to create savepoint, check compatibility
9167: -- and initialize message list
9168: x_return_status := OKL_API.START_ACTIVITY(
9169: p_api_name => l_api_name,
9170: p_pkg_name => G_PKG_NAME,
9171: p_init_msg_list => p_init_msg_list,
9172: l_api_version => l_api_version,
9174: p_api_type => G_API_TYPE,
9175: x_return_status => x_return_status);
9176:
9177: -- check if activity started successfully
9178: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9179: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9180: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9181: raise OKL_API.G_EXCEPTION_ERROR;
9182: END IF;
9175: x_return_status => x_return_status);
9176:
9177: -- check if activity started successfully
9178: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9179: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9180: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9181: raise OKL_API.G_EXCEPTION_ERROR;
9182: END IF;
9183:
9176:
9177: -- check if activity started successfully
9178: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9179: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9180: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9181: raise OKL_API.G_EXCEPTION_ERROR;
9182: END IF;
9183:
9184: -- For On-line and Mass rebook, calculate billing adjustment
9177: -- check if activity started successfully
9178: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9179: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9180: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9181: raise OKL_API.G_EXCEPTION_ERROR;
9182: END IF;
9183:
9184: -- For On-line and Mass rebook, calculate billing adjustment
9185: -- for all Current Billable Streams for which billing was done
9263:
9264: IF (l_selv_tbl.COUNT > 0) THEN
9265: okl_streams_pub.update_stream_elements(
9266: p_api_version => 1.0,
9267: p_init_msg_list => OKL_API.G_FALSE,
9268: x_return_status => x_return_status,
9269: x_msg_count => x_msg_count,
9270: x_msg_data => x_msg_data,
9271: p_selv_tbl => l_selv_tbl,
9275: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
9276: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of Stream Elements - Date Billed and Bill Adj Flag '||x_return_status);
9277: END IF;
9278:
9279: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9280: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9281: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9282: raise OKL_API.G_EXCEPTION_ERROR;
9283: END IF;
9276: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of Stream Elements - Date Billed and Bill Adj Flag '||x_return_status);
9277: END IF;
9278:
9279: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9280: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9281: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9282: raise OKL_API.G_EXCEPTION_ERROR;
9283: END IF;
9284: END IF;
9277: END IF;
9278:
9279: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9280: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9281: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9282: raise OKL_API.G_EXCEPTION_ERROR;
9283: END IF;
9284: END IF;
9285:
9278:
9279: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9280: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9281: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9282: raise OKL_API.G_EXCEPTION_ERROR;
9283: END IF;
9284: END IF;
9285:
9286: END IF;
9348: ,p_init_msg_list => p_init_msg_list
9349: ,x_return_status => x_return_status
9350: ,x_msg_count => x_msg_count
9351: ,x_msg_data => x_msg_data
9352: ,p_commit => OKL_API.G_FALSE
9353: ,p_rebook_adj_tbl => l_rebook_adj_tbl
9354: );
9355:
9356: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
9356: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
9357: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After calling OKL_REBOOK_CM_PVT.Rebook_Bill_adjustments '||x_return_status);
9358: END IF;
9359:
9360: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9361: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9362: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9363: raise OKL_API.G_EXCEPTION_ERROR;
9364: END IF;
9357: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After calling OKL_REBOOK_CM_PVT.Rebook_Bill_adjustments '||x_return_status);
9358: END IF;
9359:
9360: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9361: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9362: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9363: raise OKL_API.G_EXCEPTION_ERROR;
9364: END IF;
9365:
9358: END IF;
9359:
9360: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9361: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9362: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9363: raise OKL_API.G_EXCEPTION_ERROR;
9364: END IF;
9365:
9366: --Bug# 4884423
9359:
9360: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9361: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9362: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9363: raise OKL_API.G_EXCEPTION_ERROR;
9364: END IF;
9365:
9366: --Bug# 4884423
9367: --Added new procedure for passthrough adjustments
9374: ,x_return_status => x_return_status
9375: ,x_msg_count => x_msg_count
9376: ,x_msg_data => x_msg_data
9377: );
9378: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9379: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9380: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9381: RAISE OKL_API.G_EXCEPTION_ERROR;
9382: END IF;
9375: ,x_msg_count => x_msg_count
9376: ,x_msg_data => x_msg_data
9377: );
9378: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9379: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9380: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9381: RAISE OKL_API.G_EXCEPTION_ERROR;
9382: END IF;
9383: -- sjalasut, added code for Contract Rebook Enhancement. END
9376: ,x_msg_data => x_msg_data
9377: );
9378: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9379: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9380: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9381: RAISE OKL_API.G_EXCEPTION_ERROR;
9382: END IF;
9383: -- sjalasut, added code for Contract Rebook Enhancement. END
9384: */
9377: );
9378: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9379: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9380: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9381: RAISE OKL_API.G_EXCEPTION_ERROR;
9382: END IF;
9383: -- sjalasut, added code for Contract Rebook Enhancement. END
9384: */
9385:
9397: p_trx_id => p_trx_id,
9398: p_trx_date => p_trx_date
9399: );
9400:
9401: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9402: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9403: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9404: RAISE OKL_API.G_EXCEPTION_ERROR;
9405: END IF;
9398: p_trx_date => p_trx_date
9399: );
9400:
9401: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9402: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9403: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9404: RAISE OKL_API.G_EXCEPTION_ERROR;
9405: END IF;
9406:
9399: );
9400:
9401: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9402: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9403: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9404: RAISE OKL_API.G_EXCEPTION_ERROR;
9405: END IF;
9406:
9407: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
9400:
9401: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9402: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9403: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9404: RAISE OKL_API.G_EXCEPTION_ERROR;
9405: END IF;
9406:
9407: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
9408: x_msg_data => x_msg_data);
9403: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9404: RAISE OKL_API.G_EXCEPTION_ERROR;
9405: END IF;
9406:
9407: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
9408: x_msg_data => x_msg_data);
9409:
9410: EXCEPTION
9411: when OKL_API.G_EXCEPTION_ERROR then
9407: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
9408: x_msg_data => x_msg_data);
9409:
9410: EXCEPTION
9411: when OKL_API.G_EXCEPTION_ERROR then
9412: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9413: p_api_name => l_api_name,
9414: p_pkg_name => G_PKG_NAME,
9415: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
9408: x_msg_data => x_msg_data);
9409:
9410: EXCEPTION
9411: when OKL_API.G_EXCEPTION_ERROR then
9412: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9413: p_api_name => l_api_name,
9414: p_pkg_name => G_PKG_NAME,
9415: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
9416: x_msg_count => x_msg_count,
9411: when OKL_API.G_EXCEPTION_ERROR then
9412: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9413: p_api_name => l_api_name,
9414: p_pkg_name => G_PKG_NAME,
9415: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
9416: x_msg_count => x_msg_count,
9417: x_msg_data => x_msg_data,
9418: p_api_type => G_API_TYPE);
9419:
9416: x_msg_count => x_msg_count,
9417: x_msg_data => x_msg_data,
9418: p_api_type => G_API_TYPE);
9419:
9420: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
9421: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9422: p_api_name => l_api_name,
9423: p_pkg_name => G_PKG_NAME,
9424: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
9417: x_msg_data => x_msg_data,
9418: p_api_type => G_API_TYPE);
9419:
9420: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
9421: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9422: p_api_name => l_api_name,
9423: p_pkg_name => G_PKG_NAME,
9424: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
9425: x_msg_count => x_msg_count,
9420: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
9421: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9422: p_api_name => l_api_name,
9423: p_pkg_name => G_PKG_NAME,
9424: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
9425: x_msg_count => x_msg_count,
9426: x_msg_data => x_msg_data,
9427: p_api_type => G_API_TYPE);
9428:
9426: x_msg_data => x_msg_data,
9427: p_api_type => G_API_TYPE);
9428:
9429: when OTHERS then
9430: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9431: p_api_name => l_api_name,
9432: p_pkg_name => G_PKG_NAME,
9433: p_exc_name => 'OTHERS',
9434: x_msg_count => x_msg_count,
9557: l_gl_date DATE;
9558:
9559: BEGIN
9560:
9561: x_return_status := OKL_API.G_RET_STS_SUCCESS;
9562: debug_message(l_proc_name);
9563: -- call START_ACTIVITY to create savepoint, check compatibility
9564: -- and initialize message list
9565: x_return_status := OKL_API.START_ACTIVITY(
9561: x_return_status := OKL_API.G_RET_STS_SUCCESS;
9562: debug_message(l_proc_name);
9563: -- call START_ACTIVITY to create savepoint, check compatibility
9564: -- and initialize message list
9565: x_return_status := OKL_API.START_ACTIVITY(
9566: p_api_name => l_api_name,
9567: p_pkg_name => G_PKG_NAME,
9568: p_init_msg_list => p_init_msg_list,
9569: l_api_version => l_api_version,
9571: p_api_type => G_API_TYPE,
9572: x_return_status => x_return_status);
9573:
9574: -- check if activity started successfully
9575: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9576: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9577: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9578: raise OKL_API.G_EXCEPTION_ERROR;
9579: END IF;
9572: x_return_status => x_return_status);
9573:
9574: -- check if activity started successfully
9575: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9576: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9577: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9578: raise OKL_API.G_EXCEPTION_ERROR;
9579: END IF;
9580:
9573:
9574: -- check if activity started successfully
9575: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9576: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9577: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9578: raise OKL_API.G_EXCEPTION_ERROR;
9579: END IF;
9580:
9581: -- For On-line and Mass rebook, calculate accrual adjustment
9574: -- check if activity started successfully
9575: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9576: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9577: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9578: raise OKL_API.G_EXCEPTION_ERROR;
9579: END IF;
9580:
9581: -- For On-line and Mass rebook, calculate accrual adjustment
9582: -- for all Current Accrual Streams for which Accruals were generated
9647:
9648: IF (l_selv_tbl.COUNT > 0) THEN
9649: okl_streams_pub.update_stream_elements(
9650: p_api_version => 1.0,
9651: p_init_msg_list => OKL_API.G_FALSE,
9652: x_return_status => x_return_status,
9653: x_msg_count => x_msg_count,
9654: x_msg_data => x_msg_data,
9655: p_selv_tbl => l_selv_tbl,
9657: );
9658:
9659: debug_message('After Update of Stream Elements - Accrued Yn and Accrual Adj Flag '||x_return_status);
9660:
9661: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9662: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9663: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9664: raise OKL_API.G_EXCEPTION_ERROR;
9665: END IF;
9658:
9659: debug_message('After Update of Stream Elements - Accrued Yn and Accrual Adj Flag '||x_return_status);
9660:
9661: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9662: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9663: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9664: raise OKL_API.G_EXCEPTION_ERROR;
9665: END IF;
9666: END IF;
9659: debug_message('After Update of Stream Elements - Accrued Yn and Accrual Adj Flag '||x_return_status);
9660:
9661: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9662: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9663: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9664: raise OKL_API.G_EXCEPTION_ERROR;
9665: END IF;
9666: END IF;
9667:
9660:
9661: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9662: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9663: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9664: raise OKL_API.G_EXCEPTION_ERROR;
9665: END IF;
9666: END IF;
9667:
9668: END IF;
9742: p_stream_tbl => l_stream_tbl);
9743:
9744: debug_message('After calling OKL_GENERATE_ACCRUALS_PVT.ADJUST_ACCRUALS '||x_return_status);
9745:
9746: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9747: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9748: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9749: raise OKL_API.G_EXCEPTION_ERROR;
9750: END IF;
9743:
9744: debug_message('After calling OKL_GENERATE_ACCRUALS_PVT.ADJUST_ACCRUALS '||x_return_status);
9745:
9746: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9747: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9748: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9749: raise OKL_API.G_EXCEPTION_ERROR;
9750: END IF;
9751: END IF;
9744: debug_message('After calling OKL_GENERATE_ACCRUALS_PVT.ADJUST_ACCRUALS '||x_return_status);
9745:
9746: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9747: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9748: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9749: raise OKL_API.G_EXCEPTION_ERROR;
9750: END IF;
9751: END IF;
9752:
9745:
9746: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9747: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9748: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9749: raise OKL_API.G_EXCEPTION_ERROR;
9750: END IF;
9751: END IF;
9752:
9753: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
9749: raise OKL_API.G_EXCEPTION_ERROR;
9750: END IF;
9751: END IF;
9752:
9753: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
9754: x_msg_data => x_msg_data);
9755:
9756: EXCEPTION
9757: when OKL_API.G_EXCEPTION_ERROR then
9753: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
9754: x_msg_data => x_msg_data);
9755:
9756: EXCEPTION
9757: when OKL_API.G_EXCEPTION_ERROR then
9758: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9759: p_api_name => l_api_name,
9760: p_pkg_name => G_PKG_NAME,
9761: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
9754: x_msg_data => x_msg_data);
9755:
9756: EXCEPTION
9757: when OKL_API.G_EXCEPTION_ERROR then
9758: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9759: p_api_name => l_api_name,
9760: p_pkg_name => G_PKG_NAME,
9761: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
9762: x_msg_count => x_msg_count,
9757: when OKL_API.G_EXCEPTION_ERROR then
9758: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9759: p_api_name => l_api_name,
9760: p_pkg_name => G_PKG_NAME,
9761: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
9762: x_msg_count => x_msg_count,
9763: x_msg_data => x_msg_data,
9764: p_api_type => G_API_TYPE);
9765:
9762: x_msg_count => x_msg_count,
9763: x_msg_data => x_msg_data,
9764: p_api_type => G_API_TYPE);
9765:
9766: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
9767: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9768: p_api_name => l_api_name,
9769: p_pkg_name => G_PKG_NAME,
9770: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
9763: x_msg_data => x_msg_data,
9764: p_api_type => G_API_TYPE);
9765:
9766: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
9767: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9768: p_api_name => l_api_name,
9769: p_pkg_name => G_PKG_NAME,
9770: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
9771: x_msg_count => x_msg_count,
9766: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
9767: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9768: p_api_name => l_api_name,
9769: p_pkg_name => G_PKG_NAME,
9770: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
9771: x_msg_count => x_msg_count,
9772: x_msg_data => x_msg_data,
9773: p_api_type => G_API_TYPE);
9774:
9772: x_msg_data => x_msg_data,
9773: p_api_type => G_API_TYPE);
9774:
9775: when OTHERS then
9776: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9777: p_api_name => l_api_name,
9778: p_pkg_name => G_PKG_NAME,
9779: p_exc_name => 'OTHERS',
9780: x_msg_count => x_msg_count,
9943: IF (G_DEBUG_ENABLED = 'Y') THEN
9944: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
9945: END IF;
9946:
9947: x_return_status := OKL_API.G_RET_STS_SUCCESS;
9948: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
9949: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
9950: END IF;
9951: -- call START_ACTIVITY to create savepoint, check compatibility
9949: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
9950: END IF;
9951: -- call START_ACTIVITY to create savepoint, check compatibility
9952: -- and initialize message list
9953: x_return_status := OKL_API.START_ACTIVITY(
9954: p_api_name => l_api_name,
9955: p_pkg_name => G_PKG_NAME,
9956: p_init_msg_list => p_init_msg_list,
9957: l_api_version => l_api_version,
9959: p_api_type => G_API_TYPE,
9960: x_return_status => x_return_status);
9961:
9962: -- check if activity started successfully
9963: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9964: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9965: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9966: RAISE OKL_API.G_EXCEPTION_ERROR;
9967: END IF;
9960: x_return_status => x_return_status);
9961:
9962: -- check if activity started successfully
9963: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9964: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9965: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9966: RAISE OKL_API.G_EXCEPTION_ERROR;
9967: END IF;
9968:
9961:
9962: -- check if activity started successfully
9963: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9964: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9965: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9966: RAISE OKL_API.G_EXCEPTION_ERROR;
9967: END IF;
9968:
9969: -- For On-line and Mass rebook, calculate accrual adjustment
9962: -- check if activity started successfully
9963: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9964: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9965: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9966: RAISE OKL_API.G_EXCEPTION_ERROR;
9967: END IF;
9968:
9969: -- For On-line and Mass rebook, calculate accrual adjustment
9970: -- for all Current Accrual Streams for which Accruals were generated
10054:
10055: IF (l_selv_tbl.COUNT > 0) THEN
10056: okl_streams_pub.update_stream_elements(
10057: p_api_version => 1.0,
10058: p_init_msg_list => OKL_API.G_FALSE,
10059: x_return_status => x_return_status,
10060: x_msg_count => x_msg_count,
10061: x_msg_data => x_msg_data,
10062: p_selv_tbl => l_selv_tbl,
10066: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
10067: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of Stream Elements - Accrued Yn and Accrual Adj Flag '||x_return_status);
10068: END IF;
10069:
10070: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
10071: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10072: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
10073: RAISE OKL_API.G_EXCEPTION_ERROR;
10074: END IF;
10067: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of Stream Elements - Accrued Yn and Accrual Adj Flag '||x_return_status);
10068: END IF;
10069:
10070: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
10071: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10072: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
10073: RAISE OKL_API.G_EXCEPTION_ERROR;
10074: END IF;
10075: END IF;
10068: END IF;
10069:
10070: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
10071: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10072: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
10073: RAISE OKL_API.G_EXCEPTION_ERROR;
10074: END IF;
10075: END IF;
10076:
10069:
10070: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
10071: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10072: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
10073: RAISE OKL_API.G_EXCEPTION_ERROR;
10074: END IF;
10075: END IF;
10076:
10077: END IF;
10162: x_stream_tbl := l_stream_tbl;
10163: x_accrual_rec := l_accrual_rec;
10164: END IF;
10165:
10166: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
10167: x_msg_data => x_msg_data);
10168:
10169: EXCEPTION
10170: WHEN OKL_API.G_EXCEPTION_ERROR THEN
10166: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
10167: x_msg_data => x_msg_data);
10168:
10169: EXCEPTION
10170: WHEN OKL_API.G_EXCEPTION_ERROR THEN
10171: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
10172: p_api_name => l_api_name,
10173: p_pkg_name => G_PKG_NAME,
10174: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
10167: x_msg_data => x_msg_data);
10168:
10169: EXCEPTION
10170: WHEN OKL_API.G_EXCEPTION_ERROR THEN
10171: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
10172: p_api_name => l_api_name,
10173: p_pkg_name => G_PKG_NAME,
10174: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
10175: x_msg_count => x_msg_count,
10170: WHEN OKL_API.G_EXCEPTION_ERROR THEN
10171: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
10172: p_api_name => l_api_name,
10173: p_pkg_name => G_PKG_NAME,
10174: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
10175: x_msg_count => x_msg_count,
10176: x_msg_data => x_msg_data,
10177: p_api_type => G_API_TYPE);
10178:
10175: x_msg_count => x_msg_count,
10176: x_msg_data => x_msg_data,
10177: p_api_type => G_API_TYPE);
10178:
10179: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
10180: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
10181: p_api_name => l_api_name,
10182: p_pkg_name => G_PKG_NAME,
10183: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
10176: x_msg_data => x_msg_data,
10177: p_api_type => G_API_TYPE);
10178:
10179: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
10180: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
10181: p_api_name => l_api_name,
10182: p_pkg_name => G_PKG_NAME,
10183: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
10184: x_msg_count => x_msg_count,
10179: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
10180: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
10181: p_api_name => l_api_name,
10182: p_pkg_name => G_PKG_NAME,
10183: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
10184: x_msg_count => x_msg_count,
10185: x_msg_data => x_msg_data,
10186: p_api_type => G_API_TYPE);
10187:
10185: x_msg_data => x_msg_data,
10186: p_api_type => G_API_TYPE);
10187:
10188: WHEN OTHERS THEN
10189: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
10190: p_api_name => l_api_name,
10191: p_pkg_name => G_PKG_NAME,
10192: p_exc_name => 'OTHERS',
10193: x_msg_count => x_msg_count,
10350: IF (G_DEBUG_ENABLED = 'Y') THEN
10351: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
10352: END IF;
10353:
10354: x_return_status := OKL_API.G_RET_STS_SUCCESS;
10355: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
10356: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
10357: END IF;
10358: -- call START_ACTIVITY to create savepoint, check compatibility
10356: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
10357: END IF;
10358: -- call START_ACTIVITY to create savepoint, check compatibility
10359: -- and initialize message list
10360: x_return_status := OKL_API.START_ACTIVITY(
10361: p_api_name => l_api_name,
10362: p_pkg_name => G_PKG_NAME,
10363: p_init_msg_list => p_init_msg_list,
10364: l_api_version => l_api_version,
10366: p_api_type => G_API_TYPE,
10367: x_return_status => x_return_status);
10368:
10369: -- check if activity started successfully
10370: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10371: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10372: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10373: raise OKL_API.G_EXCEPTION_ERROR;
10374: END IF;
10367: x_return_status => x_return_status);
10368:
10369: -- check if activity started successfully
10370: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10371: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10372: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10373: raise OKL_API.G_EXCEPTION_ERROR;
10374: END IF;
10375:
10368:
10369: -- check if activity started successfully
10370: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10371: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10372: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10373: raise OKL_API.G_EXCEPTION_ERROR;
10374: END IF;
10375:
10376: -- For On-line and Mass rebook, calculate disbursement adjustment
10369: -- check if activity started successfully
10370: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10371: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10372: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10373: raise OKL_API.G_EXCEPTION_ERROR;
10374: END IF;
10375:
10376: -- For On-line and Mass rebook, calculate disbursement adjustment
10377: -- for all Current Billable Securitized Streams for which billing was done
10452: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
10453: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of Stream Elements - Date Billed and Bill Adj Flag '||x_return_status);
10454: END IF;
10455:
10456: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10457: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10458: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10459: raise OKL_API.G_EXCEPTION_ERROR;
10460: END IF;
10453: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of Stream Elements - Date Billed and Bill Adj Flag '||x_return_status);
10454: END IF;
10455:
10456: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10457: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10458: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10459: raise OKL_API.G_EXCEPTION_ERROR;
10460: END IF;
10461: END IF;
10454: END IF;
10455:
10456: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10457: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10458: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10459: raise OKL_API.G_EXCEPTION_ERROR;
10460: END IF;
10461: END IF;
10462: END LOOP;
10455:
10456: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10457: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10458: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10459: raise OKL_API.G_EXCEPTION_ERROR;
10460: END IF;
10461: END IF;
10462: END LOOP;
10463: END LOOP;
10470: x_return_status => x_return_status,
10471: x_primary_sty_id => l_disb_adj_sty_id
10472: );
10473:
10474: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10475: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10476: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10477: raise OKL_API.G_EXCEPTION_ERROR;
10478: END IF;
10471: x_primary_sty_id => l_disb_adj_sty_id
10472: );
10473:
10474: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10475: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10476: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10477: raise OKL_API.G_EXCEPTION_ERROR;
10478: END IF;
10479:
10472: );
10473:
10474: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10475: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10476: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10477: raise OKL_API.G_EXCEPTION_ERROR;
10478: END IF;
10479:
10480: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
10473:
10474: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10475: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10476: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10477: raise OKL_API.G_EXCEPTION_ERROR;
10478: END IF;
10479:
10480: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
10481: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Disb Adjustment Stream Type Id: '||l_disb_adj_sty_id);
10536: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Historizing Existing Investor Disbursement Adjustment Stream');
10537: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After calling OKL_STREAMS_PUB.update_streams'||x_return_status);
10538: END IF;
10539:
10540: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10541: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10542: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10543: raise OKL_API.G_EXCEPTION_ERROR;
10544: END IF;
10537: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After calling OKL_STREAMS_PUB.update_streams'||x_return_status);
10538: END IF;
10539:
10540: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10541: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10542: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10543: raise OKL_API.G_EXCEPTION_ERROR;
10544: END IF;
10545: END IF;
10538: END IF;
10539:
10540: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10541: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10542: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10543: raise OKL_API.G_EXCEPTION_ERROR;
10544: END IF;
10545: END IF;
10546:
10539:
10540: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10541: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10542: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10543: raise OKL_API.G_EXCEPTION_ERROR;
10544: END IF;
10545: END IF;
10546:
10547: l_stmv_rec_new_disb.khr_id := p_orig_khr_id;
10586: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Creating New Investor Disbursement Adjustment Stream');
10587: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After calling OKL_STREAMS_PUB.create_streams'||x_return_status);
10588: END IF;
10589:
10590: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10591: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10592: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10593: raise OKL_API.G_EXCEPTION_ERROR;
10594: END IF;
10587: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After calling OKL_STREAMS_PUB.create_streams'||x_return_status);
10588: END IF;
10589:
10590: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10591: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10592: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10593: raise OKL_API.G_EXCEPTION_ERROR;
10594: END IF;
10595: END IF;
10588: END IF;
10589:
10590: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10591: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10592: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10593: raise OKL_API.G_EXCEPTION_ERROR;
10594: END IF;
10595: END IF;
10596:
10589:
10590: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10591: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10592: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10593: raise OKL_API.G_EXCEPTION_ERROR;
10594: END IF;
10595: END IF;
10596:
10597: -- New Disbursement Adjustment = 0
10628: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Historizing Existing Investor Disbursement Adjustment Stream');
10629: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After calling OKL_STREAMS_PUB.update_streams'||x_return_status);
10630: END IF;
10631:
10632: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10633: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10634: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10635: raise OKL_API.G_EXCEPTION_ERROR;
10636: END IF;
10629: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After calling OKL_STREAMS_PUB.update_streams'||x_return_status);
10630: END IF;
10631:
10632: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10633: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10634: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10635: raise OKL_API.G_EXCEPTION_ERROR;
10636: END IF;
10637: END IF;
10630: END IF;
10631:
10632: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10633: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10634: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10635: raise OKL_API.G_EXCEPTION_ERROR;
10636: END IF;
10637: END IF;
10638: END IF;
10631:
10632: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10633: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10634: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10635: raise OKL_API.G_EXCEPTION_ERROR;
10636: END IF;
10637: END IF;
10638: END IF;
10639:
10643: END LOOP;
10644:
10645: END IF;
10646:
10647: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
10648: x_msg_data => x_msg_data);
10649:
10650: EXCEPTION
10651: when OKL_API.G_EXCEPTION_ERROR then
10647: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
10648: x_msg_data => x_msg_data);
10649:
10650: EXCEPTION
10651: when OKL_API.G_EXCEPTION_ERROR then
10652: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
10653: p_api_name => l_api_name,
10654: p_pkg_name => G_PKG_NAME,
10655: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
10648: x_msg_data => x_msg_data);
10649:
10650: EXCEPTION
10651: when OKL_API.G_EXCEPTION_ERROR then
10652: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
10653: p_api_name => l_api_name,
10654: p_pkg_name => G_PKG_NAME,
10655: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
10656: x_msg_count => x_msg_count,
10651: when OKL_API.G_EXCEPTION_ERROR then
10652: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
10653: p_api_name => l_api_name,
10654: p_pkg_name => G_PKG_NAME,
10655: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
10656: x_msg_count => x_msg_count,
10657: x_msg_data => x_msg_data,
10658: p_api_type => G_API_TYPE);
10659:
10656: x_msg_count => x_msg_count,
10657: x_msg_data => x_msg_data,
10658: p_api_type => G_API_TYPE);
10659:
10660: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
10661: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
10662: p_api_name => l_api_name,
10663: p_pkg_name => G_PKG_NAME,
10664: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
10657: x_msg_data => x_msg_data,
10658: p_api_type => G_API_TYPE);
10659:
10660: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
10661: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
10662: p_api_name => l_api_name,
10663: p_pkg_name => G_PKG_NAME,
10664: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
10665: x_msg_count => x_msg_count,
10660: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
10661: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
10662: p_api_name => l_api_name,
10663: p_pkg_name => G_PKG_NAME,
10664: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
10665: x_msg_count => x_msg_count,
10666: x_msg_data => x_msg_data,
10667: p_api_type => G_API_TYPE);
10668:
10666: x_msg_data => x_msg_data,
10667: p_api_type => G_API_TYPE);
10668:
10669: when OTHERS then
10670: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
10671: p_api_name => l_api_name,
10672: p_pkg_name => G_PKG_NAME,
10673: p_exc_name => 'OTHERS',
10674: x_msg_count => x_msg_count,
10880: IF (G_DEBUG_ENABLED = 'Y') THEN
10881: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
10882: END IF;
10883:
10884: x_return_status := OKL_API.G_RET_STS_SUCCESS;
10885: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
10886: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
10887: END IF;
10888: -- call START_ACTIVITY to create savepoint, check compatibility
10886: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
10887: END IF;
10888: -- call START_ACTIVITY to create savepoint, check compatibility
10889: -- and initialize message list
10890: x_return_status := OKL_API.START_ACTIVITY(
10891: p_api_name => l_api_name,
10892: p_pkg_name => G_PKG_NAME,
10893: p_init_msg_list => p_init_msg_list,
10894: l_api_version => l_api_version,
10896: p_api_type => G_API_TYPE,
10897: x_return_status => x_return_status);
10898:
10899: -- check if activity started successfully
10900: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10901: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10902: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10903: raise OKL_API.G_EXCEPTION_ERROR;
10904: END IF;
10897: x_return_status => x_return_status);
10898:
10899: -- check if activity started successfully
10900: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10901: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10902: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10903: raise OKL_API.G_EXCEPTION_ERROR;
10904: END IF;
10905:
10898:
10899: -- check if activity started successfully
10900: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10901: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10902: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10903: raise OKL_API.G_EXCEPTION_ERROR;
10904: END IF;
10905:
10906: --Bug# 6344223
10899: -- check if activity started successfully
10900: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
10901: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
10902: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
10903: raise OKL_API.G_EXCEPTION_ERROR;
10904: END IF;
10905:
10906: --Bug# 6344223
10907: OPEN check_split_trx_csr;
11006:
11007: -- Call Streams api to update Link_Hist_Stream_Id and Trx_Id
11008: okl_streams_pub.update_streams(
11009: p_api_version => 1.0,
11010: p_init_msg_list => OKL_API.G_FALSE,
11011: x_return_status => x_return_status,
11012: x_msg_count => x_msg_count,
11013: x_msg_data => x_msg_data,
11014: p_stmv_tbl => l_new_strm_tbl,
11018: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
11019: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of New Strms - Trx ID and Hist ID '||x_return_status);
11020: END IF;
11021:
11022: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
11023: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
11024: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
11025: raise OKL_API.G_EXCEPTION_ERROR;
11026: END IF;
11019: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of New Strms - Trx ID and Hist ID '||x_return_status);
11020: END IF;
11021:
11022: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
11023: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
11024: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
11025: raise OKL_API.G_EXCEPTION_ERROR;
11026: END IF;
11027: END IF;
11020: END IF;
11021:
11022: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
11023: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
11024: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
11025: raise OKL_API.G_EXCEPTION_ERROR;
11026: END IF;
11027: END IF;
11028:
11021:
11022: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
11023: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
11024: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
11025: raise OKL_API.G_EXCEPTION_ERROR;
11026: END IF;
11027: END IF;
11028:
11029: --sechawla
11073:
11074: -- Call Streams api to update Link_Hist_Stream_Id and Trx_Id
11075: okl_streams_pub.update_streams(
11076: p_api_version => 1.0,
11077: p_init_msg_list => OKL_API.G_FALSE,
11078: x_return_status => x_return_status,
11079: x_msg_count => x_msg_count,
11080: x_msg_data => x_msg_data,
11081: p_stmv_tbl => l_new_strm_sec_tbl,
11085: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
11086: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of New Strms - Trx ID and Hist ID '||x_return_status);
11087: END IF;
11088:
11089: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
11090: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
11091: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
11092: raise OKL_API.G_EXCEPTION_ERROR;
11093: END IF;
11086: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of New Strms - Trx ID and Hist ID '||x_return_status);
11087: END IF;
11088:
11089: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
11090: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
11091: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
11092: raise OKL_API.G_EXCEPTION_ERROR;
11093: END IF;
11094: END IF;
11087: END IF;
11088:
11089: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
11090: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
11091: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
11092: raise OKL_API.G_EXCEPTION_ERROR;
11093: END IF;
11094: END IF;
11095:
11088:
11089: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
11090: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
11091: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
11092: raise OKL_API.G_EXCEPTION_ERROR;
11093: END IF;
11094: END IF;
11095:
11096:
11096:
11097: END IF;
11098:
11099:
11100: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
11101: x_msg_data => x_msg_data);
11102:
11103: EXCEPTION
11104: when OKL_API.G_EXCEPTION_ERROR then
11100: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
11101: x_msg_data => x_msg_data);
11102:
11103: EXCEPTION
11104: when OKL_API.G_EXCEPTION_ERROR then
11105: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
11106: p_api_name => l_api_name,
11107: p_pkg_name => G_PKG_NAME,
11108: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
11101: x_msg_data => x_msg_data);
11102:
11103: EXCEPTION
11104: when OKL_API.G_EXCEPTION_ERROR then
11105: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
11106: p_api_name => l_api_name,
11107: p_pkg_name => G_PKG_NAME,
11108: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
11109: x_msg_count => x_msg_count,
11104: when OKL_API.G_EXCEPTION_ERROR then
11105: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
11106: p_api_name => l_api_name,
11107: p_pkg_name => G_PKG_NAME,
11108: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
11109: x_msg_count => x_msg_count,
11110: x_msg_data => x_msg_data,
11111: p_api_type => G_API_TYPE);
11112:
11109: x_msg_count => x_msg_count,
11110: x_msg_data => x_msg_data,
11111: p_api_type => G_API_TYPE);
11112:
11113: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
11114: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
11115: p_api_name => l_api_name,
11116: p_pkg_name => G_PKG_NAME,
11117: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
11110: x_msg_data => x_msg_data,
11111: p_api_type => G_API_TYPE);
11112:
11113: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
11114: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
11115: p_api_name => l_api_name,
11116: p_pkg_name => G_PKG_NAME,
11117: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
11118: x_msg_count => x_msg_count,
11113: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
11114: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
11115: p_api_name => l_api_name,
11116: p_pkg_name => G_PKG_NAME,
11117: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
11118: x_msg_count => x_msg_count,
11119: x_msg_data => x_msg_data,
11120: p_api_type => G_API_TYPE);
11121:
11119: x_msg_data => x_msg_data,
11120: p_api_type => G_API_TYPE);
11121:
11122: when OTHERS then
11123: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
11124: p_api_name => l_api_name,
11125: p_pkg_name => G_PKG_NAME,
11126: p_exc_name => 'OTHERS',
11127: x_msg_count => x_msg_count,
11232: IF (G_DEBUG_ENABLED = 'Y') THEN
11233: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
11234: END IF;
11235:
11236: x_return_status := OKL_API.G_RET_STS_SUCCESS;
11237: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
11238: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
11239: END IF;
11240: -- call START_ACTIVITY to create savepoint, check compatibility
11238: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
11239: END IF;
11240: -- call START_ACTIVITY to create savepoint, check compatibility
11241: -- and initialize message list
11242: x_return_status := OKL_API.START_ACTIVITY(
11243: p_api_name => l_api_name,
11244: p_pkg_name => G_PKG_NAME,
11245: p_init_msg_list => p_init_msg_list,
11246: l_api_version => l_api_version,
11248: p_api_type => G_API_TYPE,
11249: x_return_status => x_return_status);
11250:
11251: -- check if activity started successfully
11252: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
11253: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
11254: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
11255: RAISE OKL_API.G_EXCEPTION_ERROR;
11256: END IF;
11249: x_return_status => x_return_status);
11250:
11251: -- check if activity started successfully
11252: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
11253: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
11254: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
11255: RAISE OKL_API.G_EXCEPTION_ERROR;
11256: END IF;
11257:
11250:
11251: -- check if activity started successfully
11252: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
11253: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
11254: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
11255: RAISE OKL_API.G_EXCEPTION_ERROR;
11256: END IF;
11257:
11258: -- For On-line and Mass rebook, calculate accrual adjustment
11251: -- check if activity started successfully
11252: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
11253: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
11254: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
11255: RAISE OKL_API.G_EXCEPTION_ERROR;
11256: END IF;
11257:
11258: -- For On-line and Mass rebook, calculate accrual adjustment
11259: -- for all Current Accrual Streams for which Accruals were generated
11334:
11335: IF (l_selv_tbl.COUNT > 0) THEN
11336: okl_streams_pub.update_stream_elements(
11337: p_api_version => 1.0,
11338: p_init_msg_list => OKL_API.G_FALSE,
11339: x_return_status => x_return_status,
11340: x_msg_count => x_msg_count,
11341: x_msg_data => x_msg_data,
11342: p_selv_tbl => l_selv_tbl,
11346: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
11347: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of Stream Elements - Accrued Yn and Accrual Adj Flag '||x_return_status);
11348: END IF;
11349:
11350: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
11351: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
11352: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
11353: RAISE OKL_API.G_EXCEPTION_ERROR;
11354: END IF;
11347: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of Stream Elements - Accrued Yn and Accrual Adj Flag '||x_return_status);
11348: END IF;
11349:
11350: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
11351: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
11352: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
11353: RAISE OKL_API.G_EXCEPTION_ERROR;
11354: END IF;
11355: END IF;
11348: END IF;
11349:
11350: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
11351: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
11352: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
11353: RAISE OKL_API.G_EXCEPTION_ERROR;
11354: END IF;
11355: END IF;
11356:
11349:
11350: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
11351: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
11352: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
11353: RAISE OKL_API.G_EXCEPTION_ERROR;
11354: END IF;
11355: END IF;
11356:
11357: END IF;
11387: x_inv_stream_tbl := l_stream_tbl;
11388: x_inv_accrual_rec := l_accrual_rec;
11389: END IF;
11390:
11391: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
11392: x_msg_data => x_msg_data);
11393:
11394: EXCEPTION
11395: WHEN OKL_API.G_EXCEPTION_ERROR THEN
11391: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
11392: x_msg_data => x_msg_data);
11393:
11394: EXCEPTION
11395: WHEN OKL_API.G_EXCEPTION_ERROR THEN
11396: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
11397: p_api_name => l_api_name,
11398: p_pkg_name => G_PKG_NAME,
11399: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
11392: x_msg_data => x_msg_data);
11393:
11394: EXCEPTION
11395: WHEN OKL_API.G_EXCEPTION_ERROR THEN
11396: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
11397: p_api_name => l_api_name,
11398: p_pkg_name => G_PKG_NAME,
11399: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
11400: x_msg_count => x_msg_count,
11395: WHEN OKL_API.G_EXCEPTION_ERROR THEN
11396: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
11397: p_api_name => l_api_name,
11398: p_pkg_name => G_PKG_NAME,
11399: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
11400: x_msg_count => x_msg_count,
11401: x_msg_data => x_msg_data,
11402: p_api_type => G_API_TYPE);
11403:
11400: x_msg_count => x_msg_count,
11401: x_msg_data => x_msg_data,
11402: p_api_type => G_API_TYPE);
11403:
11404: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
11405: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
11406: p_api_name => l_api_name,
11407: p_pkg_name => G_PKG_NAME,
11408: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
11401: x_msg_data => x_msg_data,
11402: p_api_type => G_API_TYPE);
11403:
11404: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
11405: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
11406: p_api_name => l_api_name,
11407: p_pkg_name => G_PKG_NAME,
11408: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
11409: x_msg_count => x_msg_count,
11404: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
11405: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
11406: p_api_name => l_api_name,
11407: p_pkg_name => G_PKG_NAME,
11408: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
11409: x_msg_count => x_msg_count,
11410: x_msg_data => x_msg_data,
11411: p_api_type => G_API_TYPE);
11412:
11410: x_msg_data => x_msg_data,
11411: p_api_type => G_API_TYPE);
11412:
11413: WHEN OTHERS THEN
11414: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
11415: p_api_name => l_api_name,
11416: p_pkg_name => G_PKG_NAME,
11417: p_exc_name => 'OTHERS',
11418: x_msg_count => x_msg_count,