eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_API

Line 11: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

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;

Line 71: okl_api.end_activity(

67: x_msg_out VARCHAR2(2000);
68:
69: BEGIN
70:
71: okl_api.end_activity(
72: X_msg_count => x_msg_count,
73: X_msg_data => x_msg_data
74: );
75:

Line 263: x_return_status := OKL_API.G_RET_STS_ERROR;

259: x_chrv_rec.LAST_UPDATED_BY,
260: x_chrv_rec.LAST_UPDATE_DATE,
261: x_chrv_rec.LAST_UPDATE_LOGIN;
262: IF okc_chrv_pk_csr%NOTFOUND THEN
263: x_return_status := OKL_API.G_RET_STS_ERROR;
264: END IF;
265: CLOSE okc_chrv_pk_csr;
266: RETURN(x_chrv_rec);
267: EXCEPTION

Line 270: OKL_API.set_message(

266: RETURN(x_chrv_rec);
267: EXCEPTION
268: WHEN OTHERS THEN
269: -- store SQL error message on message stack for caller
270: OKL_API.set_message(
271: G_APP_NAME,
272: G_UNEXPECTED_ERROR,
273: 'SQLcode',
274: SQLCODE,

Line 278: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

274: SQLCODE,
275: 'SQLerrm',
276: SQLERRM);
277: -- notify caller of an UNEXPECTED error
278: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
279: -- if the cursor is open
280: IF okc_chrv_pk_csr%ISOPEN THEN
281: CLOSE okc_chrv_pk_csr;
282: END IF;

Line 358: x_return_status := OKL_API.G_RET_STS_SUCCESS;

354: l_okl_k_headers_v_pk okl_k_headers_v_pk_csr%ROWTYPE;
355: l_khrv_rec khrv_rec_type;
356: BEGIN
357:
358: x_return_status := OKL_API.G_RET_STS_SUCCESS;
359: -- Get current database values
360: OPEN okl_k_headers_v_pk_csr (p_khr_id);
361: FETCH okl_k_headers_v_pk_csr INTO
362: l_khrv_rec.ID,

Line 421: x_return_status := OKL_API.G_RET_STS_ERROR;

417: l_khrv_rec.PREFUNDING_ELIGIBLE_YN,
418: l_khrv_rec.REVOLVING_CREDIT_YN
419: ;
420: IF okl_k_headers_v_pk_csr%NOTFOUND THEN
421: x_return_status := OKL_API.G_RET_STS_ERROR;
422: END IF;
423: CLOSE okl_k_headers_v_pk_csr;
424: RETURN(l_khrv_rec);
425: EXCEPTION

Line 428: OKL_API.set_message(

424: RETURN(l_khrv_rec);
425: EXCEPTION
426: WHEN OTHERS THEN
427: -- store SQL error message on message stack for caller
428: OKL_API.set_message(
429: G_APP_NAME,
430: G_UNEXPECTED_ERROR,
431: 'SQLcode',
432: SQLCODE,

Line 440: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

436: -- if the cursor is open
437: IF okl_k_headers_v_pk_csr%ISOPEN THEN
438: CLOSE okl_k_headers_v_pk_csr;
439: END IF;
440: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
441: END get_khrv_rec;
442:
443: ------------------------------------------------------------------------------
444: -- PROCEDURE validate_rebook_reason

Line 489: okl_api.set_message(

485: RETURN;
486:
487: EXCEPTION
488: WHEN rebook_failed THEN
489: okl_api.set_message(
490: G_APP_NAME,
491: G_INVALID_VALUE,
492: 'COL_NAME',
493: 'REBOOK REASON'

Line 699: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

695: x_return_status => x_return_status,
696: x_primary_sty_id => x_billing_adj_sty_id
697: );
698:
699: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
700: RAISE copy_failed;
701: END IF;
702:
703: -- Get Stream id for purpose = INVESTOR_DISB_ADJUSTMENT

Line 716: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

712: x_return_status => x_return_status,
713: x_primary_sty_id => x_inv_disb_adj_sty_id
714: );
715:
716: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
717: RAISE copy_failed;
718: END IF;
719: */
720:

Line 836: okl_api.set_message(

832: OPEN strm_hdr_csr(p_rebook_chr_id);
833: FETCH strm_hdr_csr INTO l_stmv_rec;
834:
835: IF strm_hdr_csr%NOTFOUND THEN
836: okl_api.set_message(
837: G_APP_NAME,
838: G_LLA_NO_STREAM
839: );
840:

Line 1033: okl_api.set_message(

1029:
1030: END LOOP;
1031:
1032: IF (l_no_of_ele = 0) THEN
1033: okl_api.set_message(
1034: G_APP_NAME,
1035: G_LLA_NO_STREAM_ELEMENT
1036: );
1037: RAISE copy_failed;

Line 1172: okl_api.set_message(

1168: /*
1169: OPEN strm_csr(p_chr_id);
1170: FETCH strm_csr INTO l_id;
1171: IF strm_csr%NOTFOUND THEN
1172: okl_api.set_message(
1173: G_APP_NAME,
1174: G_LLA_NO_STREAM
1175: );
1176: debug_message('Failed');

Line 1708: p_init_msg_list => OKL_API.G_FALSE,

1704: l_rgpv_rec.rgp_type := 'KRG';
1705:
1706: OKL_RULE_PUB.create_rule_group(
1707: p_api_version => 1.0,
1708: p_init_msg_list => OKL_API.G_FALSE,
1709: x_return_status => x_return_status,
1710: x_msg_count => x_msg_count,
1711: x_msg_data => x_msg_data,
1712: p_rgpv_rec => l_rgpv_rec,

Line 1736: p_init_msg_list => Okl_Api.G_FALSE,

1732: -- Get SLH Rule from Rebook Contract
1733: --
1734: Okl_Rule_Apis_Pvt.Get_Contract_Rules(
1735: p_api_version => 1.0,
1736: p_init_msg_list => Okl_Api.G_FALSE,
1737: p_rgpv_rec => l_rebook_rgpv_rec,
1738: p_rdf_code => 'LASLH',
1739: x_return_status => x_return_status,
1740: x_msg_count => x_msg_count,

Line 2024: p_init_msg_list => Okl_Api.G_FALSE,

2020: -- Get SLH Rule from Rebook Contract
2021: --
2022: Okl_Rule_Apis_Pvt.Get_Contract_Rules(
2023: p_api_version => 1.0,
2024: p_init_msg_list => Okl_Api.G_FALSE,
2025: p_rgpv_rec => l_rebook_rgpv_rec,
2026: p_rdf_code => 'LASLH',
2027: x_return_status => x_return_status,
2028: x_msg_count => x_msg_count,

Line 2188: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2184: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2185: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
2186: END IF;
2187:
2188: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2189:
2190: -- Get Sales Tax header rule
2191: -- LAHDTX: LASTCL, LASTPR
2192: --

Line 2259: p_init_msg_list => OKL_API.G_FALSE,

2255: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Update LASTCL rule: '||x_rbk_lastcl_rec.id);
2256: END IF;
2257: okl_rule_pub.update_rule(
2258: p_api_version => 1.0,
2259: p_init_msg_list => OKL_API.G_FALSE,
2260: x_return_status => x_return_status,
2261: x_msg_count => x_msg_count,
2262: x_msg_data => x_msg_data,
2263: p_rulv_rec => x_rbk_lastcl_rec,

Line 2285: p_init_msg_list => OKL_API.G_FALSE,

2281: l_rgpv_rec.cle_id := NULL;
2282: l_rgpv_rec.rgp_type := 'KRG';
2283: okl_rule_pub.create_rule_group(
2284: p_api_version => 1.0,
2285: p_init_msg_list => OKL_API.G_FALSE,
2286: x_return_status => x_return_status,
2287: x_msg_count => x_msg_count,
2288: x_msg_data => x_msg_data,
2289: p_rgpv_rec => l_rgpv_rec,

Line 2302: p_init_msg_list => OKL_API.G_FALSE,

2298: x_rbk_lastcl_rec.id := NULL;
2299: x_rbk_lastcl_rec.rgp_id := x_rgpv_rec.id;
2300: okl_rule_pub.create_rule(
2301: p_api_version => 1.0,
2302: p_init_msg_list => OKL_API.G_FALSE,
2303: x_return_status => x_return_status,
2304: x_msg_count => x_msg_count,
2305: x_msg_data => x_msg_data,
2306: p_rulv_rec => x_rbk_lastcl_rec,

Line 2377: p_init_msg_list => OKL_API.G_FALSE,

2373: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Update LASTPR rule: '||x_rbk_lastpr_rec.id);
2374: END IF;
2375: okl_rule_pub.update_rule(
2376: p_api_version => 1.0,
2377: p_init_msg_list => OKL_API.G_FALSE,
2378: x_return_status => x_return_status,
2379: x_msg_count => x_msg_count,
2380: x_msg_data => x_msg_data,
2381: p_rulv_rec => x_rbk_lastpr_rec,

Line 2399: x_rgpv_rec.id = OKL_API.G_MISS_NUM) THEN

2395: -- Create rule group and rule information
2396:
2397: IF (x_rgpv_rec.id IS NULL
2398: OR
2399: x_rgpv_rec.id = OKL_API.G_MISS_NUM) THEN
2400: l_rgpv_rec.rgd_code := 'LAHDTX';
2401: l_rgpv_rec.chr_id := p_orig_chr_id;
2402: l_rgpv_rec.dnz_chr_id := p_orig_chr_id;
2403: l_rgpv_rec.cle_id := NULL;

Line 2407: p_init_msg_list => OKL_API.G_FALSE,

2403: l_rgpv_rec.cle_id := NULL;
2404: l_rgpv_rec.rgp_type := 'KRG';
2405: okl_rule_pub.create_rule_group(
2406: p_api_version => 1.0,
2407: p_init_msg_list => OKL_API.G_FALSE,
2408: x_return_status => x_return_status,
2409: x_msg_count => x_msg_count,
2410: x_msg_data => x_msg_data,
2411: p_rgpv_rec => l_rgpv_rec,

Line 2424: p_init_msg_list => OKL_API.G_FALSE,

2420: x_rbk_lastpr_rec.id := NULL;
2421: x_rbk_lastpr_rec.rgp_id := x_rgpv_rec.id;
2422: okl_rule_pub.create_rule(
2423: p_api_version => 1.0,
2424: p_init_msg_list => OKL_API.G_FALSE,
2425: x_return_status => x_return_status,
2426: x_msg_count => x_msg_count,
2427: x_msg_data => x_msg_data,
2428: p_rulv_rec => x_rbk_lastpr_rec,

Line 2558: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2554: BEGIN
2555: IF (G_DEBUG_ENABLED = 'Y') THEN
2556: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
2557: END IF;
2558: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2559: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2560: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
2561: END IF;
2562:

Line 2582: p_init_msg_list => OKL_API.G_FALSE,

2578: --
2579:
2580: okl_party_payments_pvt.create_party_payment_hdr(
2581: p_api_version => 1.0,
2582: p_init_msg_list => OKL_API.G_FALSE,
2583: x_return_status => x_return_status,
2584: x_msg_count => x_msg_count,
2585: x_msg_data => x_msg_data,
2586: p_pphv_rec => l_pphv_rec,

Line 2589: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2585: x_msg_data => x_msg_data,
2586: p_pphv_rec => l_pphv_rec,
2587: x_pphv_rec => x_pphv_rec
2588: );
2589: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2590: RAISE sync_party_failed;
2591: END IF;
2592: ELSE
2593: -- Update header rec

Line 2601: p_init_msg_list => OKL_API.G_FALSE,

2597: l_pphv_rec.payout_basis_formula := rbk_evg_hdr_rec.payout_basis_formula;
2598: l_pphv_rec.passthru_stream_type_id := rbk_evg_hdr_rec.passthru_stream_type_id;
2599: okl_party_payments_pvt.update_party_payment_hdr(
2600: p_api_version => 1.0,
2601: p_init_msg_list => OKL_API.G_FALSE,
2602: x_return_status => x_return_status,
2603: x_msg_count => x_msg_count,
2604: x_msg_data => x_msg_data,
2605: p_pphv_rec => l_pphv_rec,

Line 2608: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2604: x_msg_data => x_msg_data,
2605: p_pphv_rec => l_pphv_rec,
2606: x_pphv_rec => x_pphv_rec
2607: );
2608: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2609: RAISE sync_party_failed;
2610: END IF;
2611: END IF;
2612: CLOSE orig_evg_hdr_csr;

Line 2670: p_init_msg_list => OKL_API.G_FALSE,

2666: l_ppydv_u_rec.payment_basis := rbk_evg_dtl_rec.payment_basis;
2667:
2668: okl_party_payments_pvt.update_party_payment_dtls(
2669: p_api_version => 1.0,
2670: p_init_msg_list => OKL_API.G_FALSE,
2671: x_return_status => x_return_status,
2672: x_msg_count => x_msg_count,
2673: x_msg_data => x_msg_data,
2674: p_ppydv_rec => l_ppydv_u_rec,

Line 2682: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2678: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2679: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Update Status: '||x_return_status);
2680: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'x_ppydv_rec.id: '||x_ppydv_rec.id);
2681: END IF;
2682: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2683: RAISE sync_party_failed;
2684: END IF;
2685: END LOOP;
2686: --Bug# 4880939

Line 2742: p_init_msg_list => OKL_API.G_FALSE,

2738: l_ppydv_c_rec.payment_basis := rbk_evg_dtl_rec.payment_basis;
2739:
2740: okl_party_payments_pvt.create_party_payment_dtls(
2741: p_api_version => 1.0,
2742: p_init_msg_list => OKL_API.G_FALSE,
2743: x_return_status => x_return_status,
2744: x_msg_count => x_msg_count,
2745: x_msg_data => x_msg_data,
2746: p_ppydv_rec => l_ppydv_c_rec,

Line 2754: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2750: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2751: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Create Status: '||x_return_status);
2752: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'x_ppydv_rec.id: '||x_ppydv_rec.id);
2753: END IF;
2754: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2755: RAISE sync_party_failed;
2756: END IF;
2757: END LOOP;
2758: --Bug# 4880939

Line 2769: p_init_msg_list => OKL_API.G_FALSE,

2765: LOOP
2766:
2767: okl_copy_contract_pub.copy_party_roles(
2768: p_api_version => 1.0,
2769: p_init_msg_list => OKL_API.G_FALSE,
2770: x_return_status => x_return_status,
2771: x_msg_count => x_msg_count,
2772: x_msg_data => x_msg_data,
2773: p_cpl_id => rebook_party_rec.id,

Line 2780: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2776: p_rle_code => rebook_party_rec.rle_code,
2777: x_cpl_id => x_cpl_id
2778: );
2779:
2780: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2781: RAISE sync_party_failed;
2782: END IF;
2783:
2784: FOR party_rule_rec IN party_rule_csr (p_rebook_chr_id,

Line 2792: p_init_msg_list => OKL_API.G_FALSE,

2788: -- Now copy Rules attached to the party copied above
2789: --
2790: okl_copy_contract_pub.copy_rules (
2791: p_api_version => 1.0,
2792: p_init_msg_list => OKL_API.G_FALSE,
2793: x_return_status => x_return_status,
2794: x_msg_count => x_msg_count,
2795: x_msg_data => x_msg_data,
2796: p_rgp_id => party_rule_rec.rgp_id,

Line 2803: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2799: p_to_template_yn => 'N',
2800: x_rgp_id => x_rgp_id
2801: );
2802:
2803: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2804: RAISE sync_party_failed;
2805: END IF;
2806: END LOOP; -- rule
2807:

Line 2893: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2889: l_khrv_rec := get_khrv_rec(
2890: p_khr_id => p_orig_chr_id,
2891: x_return_status => x_return_status
2892: );
2893: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2894: RAISE sync_failed;
2895: END IF;
2896:
2897: l_chrv_rec := get_chrv_rec(

Line 2901: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2897: l_chrv_rec := get_chrv_rec(
2898: p_chr_id => p_orig_chr_id,
2899: x_return_status => x_return_status
2900: );
2901: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2902: RAISE sync_failed;
2903: END IF;
2904:
2905: FOR header_rec IN header_csr(p_rebook_chr_id)

Line 2978: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2974: PROCEDURE sync_passthru_party(
2975: x_return_status OUT NOCOPY VARCHAR2
2976: ) IS
2977: BEGIN
2978: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2979: END sync_passthru_party;
2980:
2981: ------------------------------------------------------------------------------
2982: -- PROCEDURE process_pth_detail

Line 3046: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3042: IF (G_DEBUG_ENABLED = 'Y') THEN
3043: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
3044: END IF;
3045:
3046: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3047: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3048: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
3049: END IF;
3050:

Line 3093: p_init_msg_list => OKL_API.G_FALSE,

3089: l_ppydv_rec.payment_basis := rbk_pth_detail_rec.payment_basis;
3090:
3091: okl_party_payments_pvt.create_party_payment_dtls(
3092: p_api_version => 1.0,
3093: p_init_msg_list => OKL_API.G_FALSE,
3094: x_return_status => x_return_status,
3095: x_msg_count => x_msg_count,
3096: x_msg_data => x_msg_data,
3097: p_ppydv_rec => l_ppydv_rec,

Line 3104: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3100: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3101: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'>>>> Pth detail created: '||x_return_status);
3102: END IF;
3103:
3104: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3105: RAISE process_pth_failed;
3106: END IF;
3107: ELSE
3108: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 3133: p_init_msg_list => OKL_API.G_FALSE,

3129: l_ppydv_rec.payment_basis := rbk_pth_detail_rec.payment_basis;
3130:
3131: okl_party_payments_pvt.update_party_payment_dtls(
3132: p_api_version => 1.0,
3133: p_init_msg_list => OKL_API.G_FALSE,
3134: x_return_status => x_return_status,
3135: x_msg_count => x_msg_count,
3136: x_msg_data => x_msg_data,
3137: p_ppydv_rec => l_ppydv_rec,

Line 3144: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3140: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3141: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'>>>> Pth detail updated: '||x_return_status);
3142: END IF;
3143:
3144: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3145: RAISE process_pth_failed;
3146: END IF;
3147: -- update passthru detail
3148: END IF;

Line 3159: x_return_status := OKL_API.G_RET_STS_ERROR;

3155:
3156: EXCEPTION
3157:
3158: WHEN process_pth_failed THEN
3159: x_return_status := OKL_API.G_RET_STS_ERROR;
3160: END process_pth_detail;
3161:
3162: ------------------------------------------------------------------------------
3163: -- PROCEDURE sync_passthru_detail

Line 3290: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3286: BEGIN
3287: IF (G_DEBUG_ENABLED = 'Y') THEN
3288: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
3289: END IF;
3290: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3291: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3292: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
3293: END IF;
3294:

Line 3351: p_init_msg_list => OKL_API.G_FALSE,

3347:
3348: IF (l_c_pphv_tbl.COUNT > 0) THEN
3349: okl_party_payments_pvt.create_party_payment_hdr(
3350: p_api_version => 1.0,
3351: p_init_msg_list => OKL_API.G_FALSE,
3352: x_return_status => x_return_status,
3353: x_msg_count => x_msg_count,
3354: x_msg_data => x_msg_data,
3355: p_pphv_tbl => l_c_pphv_tbl,

Line 3361: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3357: );
3358: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3359: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'PTH header insert for: '||pth_rec.orig_system_id1||': '||x_return_status);
3360: END IF;
3361: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3362: RAISE pth_failed;
3363: END IF;
3364: END IF;
3365: IF (l_u_pphv_tbl.COUNT > 0) THEN

Line 3368: p_init_msg_list => OKL_API.G_FALSE,

3364: END IF;
3365: IF (l_u_pphv_tbl.COUNT > 0) THEN
3366: okl_party_payments_pvt.update_party_payment_hdr(
3367: p_api_version => 1.0,
3368: p_init_msg_list => OKL_API.G_FALSE,
3369: x_return_status => x_return_status,
3370: x_msg_count => x_msg_count,
3371: x_msg_data => x_msg_data,
3372: p_pphv_tbl => l_u_pphv_tbl,

Line 3378: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3374: );
3375: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3376: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'PTH header update for: '||pth_rec.orig_system_id1||': '||x_return_status);
3377: END IF;
3378: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3379: RAISE pth_failed;
3380: END IF;
3381: END IF;
3382:

Line 3412: p_init_msg_list => OKL_API.G_FALSE,

3408: -- okc_k_party_roles_b and okl_k_party_roles
3409: /*
3410: okl_okc_migration_pvt.create_k_party_role(
3411: p_api_version => 1.0,
3412: p_init_msg_list => OKL_API.G_FALSE,
3413: x_return_status => x_return_status,
3414: x_msg_count => x_msg_count,
3415: x_msg_data => x_msg_data,
3416: p_cplv_rec => l_cplv_rec,

Line 3422: p_init_msg_list => OKL_API.G_FALSE,

3418: */
3419:
3420: okl_k_party_roles_pvt.create_k_party_role(
3421: p_api_version => 1.0,
3422: p_init_msg_list => OKL_API.G_FALSE,
3423: x_return_status => x_return_status,
3424: x_msg_count => x_msg_count,
3425: x_msg_data => x_msg_data,
3426: p_cplv_rec => l_cplv_rec,

Line 3435: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3431: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3432: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'>> Vendor '||pth_vendor_rec.vendor_id||' created: '||x_return_status);
3433: END IF;
3434:
3435: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3436: RAISE pth_failed;
3437: END IF;
3438:
3439: process_pth_detail(

Line 3452: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3448: p_rbk_cle_id => pth_rec.id,
3449: p_rbk_cpl_id => pth_vendor_rec.id
3450: );
3451:
3452: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3453: RAISE pth_failed;
3454: END IF;
3455:
3456: ELSE

Line 3474: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3470: p_rbk_cle_id => pth_rec.id,
3471: p_rbk_cpl_id => pth_vendor_rec.id
3472: );
3473:
3474: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3475: RAISE pth_failed;
3476: END IF;
3477:
3478: END IF; -- orig_vendor_csr

Line 3495: p_init_msg_list => OKL_API.G_FALSE,

3491: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'>> Vendor to be deleted cpl_id: '||rbk_del_vendor_rec.id);
3492: END IF;
3493: okl_maintain_fee_pvt.delete_passthru_party(
3494: p_api_version => 1.0,
3495: p_init_msg_list => OKL_API.G_FALSE,
3496: x_return_status => x_return_status,
3497: x_msg_count => x_msg_count,
3498: x_msg_data => x_msg_data,
3499: p_cpl_id => rbk_del_vendor_rec.id

Line 3505: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

3501: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3502: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Vendor deleted: '||x_return_status);
3503: END IF;
3504:
3505: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
3506: RAISE pth_failed;
3507: END IF;
3508:
3509: END LOOP; -- rbk_del_vendor_rec

Line 3515: x_return_status := OKL_API.G_RET_STS_ERROR;

3511: END LOOP; -- pth_csr
3512:
3513: EXCEPTION
3514: WHEN pth_failed THEN
3515: x_return_status := OKL_API.G_RET_STS_ERROR;
3516: END sync_passthru_detail;
3517:
3518: ------------------------------------------------------------------------------
3519: -- PROCEDURE sync_fee_line

Line 3908: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3904: IF (G_DEBUG_ENABLED = 'Y') THEN
3905: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
3906: END IF;
3907:
3908: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3909: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3910: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
3911: END IF;
3912:

Line 3931: p_init_msg_list => OKL_API.G_FALSE,

3927:
3928: -- Make Fee top-line ABANDONED
3929: okl_contract_pub.update_contract_line(
3930: p_api_version => 1.0,
3931: p_init_msg_list => OKL_API.G_FALSE,
3932: x_return_status => x_return_status,
3933: x_msg_count => x_msg_count,
3934: x_msg_data => x_msg_data,
3935: p_clev_rec => l_clev_rec,

Line 3960: p_init_msg_list => OKL_API.G_FALSE,

3956: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Sub line delete: '||fee_subline_rec.id);
3957: END IF;
3958: okl_contract_pub.update_contract_line(
3959: p_api_version => 1.0,
3960: p_init_msg_list => OKL_API.G_FALSE,
3961: x_return_status => x_return_status,
3962: x_msg_count => x_msg_count,
3963: x_msg_data => x_msg_data,
3964: p_clev_rec => l_clev_rec,

Line 4022: p_init_msg_list => OKL_API.G_FALSE,

4018:
4019: IF (i > 0) THEN
4020: okl_copy_asset_pub.copy_all_lines(
4021: p_api_version => 1.0,
4022: p_init_msg_list => OKL_API.G_FALSE,
4023: x_return_status => x_return_status,
4024: x_msg_count => x_msg_count,
4025: x_msg_data => x_msg_data,
4026: p_from_cle_id_tbl => l_rbk_fee_tbl,

Line 4115: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4111: FETCH c_fee_orig_csr INTO c_fee_orig_rec;
4112:
4113: IF(c_fee_orig_csr%NOTFOUND) THEN
4114: CLOSE c_fee_orig_csr;
4115: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4116: ELSE
4117: l_orig_fee_top_line_id := c_fee_rbk_rec.orig_system_id1; -- for future use
4118: -- check if either of the fee, (amount where fee type is not Rollover), idc,
4119: -- (qte_id and fee type is not Rollover), supplier are changed between the contracts only then merge the change

Line 4129: 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)

4125: -- amount has changed on a fee type that is not Rollover
4126: OR((NVL(c_fee_orig_rec.amount,0) <> NVL(c_fee_rbk_rec.amount,0)) AND c_fee_orig_rec.fee_type <> G_ROLLOVER_FEE)
4127: OR(NVL(c_fee_orig_rec.initial_direct_cost,0) <> NVL(c_fee_rbk_rec.initial_direct_cost,0)) -- idc has changed
4128: -- for non rollover fee quote has changed (is there a quote for other fee types??)
4129: 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)
4130: -- 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
4131: -- fee start date changes are not synced up on the original fee line
4132: -- 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)))
4133: 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)))

Line 4130: -- 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

4126: OR((NVL(c_fee_orig_rec.amount,0) <> NVL(c_fee_rbk_rec.amount,0)) AND c_fee_orig_rec.fee_type <> G_ROLLOVER_FEE)
4127: OR(NVL(c_fee_orig_rec.initial_direct_cost,0) <> NVL(c_fee_rbk_rec.initial_direct_cost,0)) -- idc has changed
4128: -- for non rollover fee quote has changed (is there a quote for other fee types??)
4129: 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)
4130: -- 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
4131: -- fee start date changes are not synced up on the original fee line
4132: -- 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)))
4133: 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)))
4134: --Bug# 4558486

Line 4132: -- 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)))

4128: -- for non rollover fee quote has changed (is there a quote for other fee types??)
4129: 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)
4130: -- 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
4131: -- fee start date changes are not synced up on the original fee line
4132: -- 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)))
4133: 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)))
4134: --Bug# 4558486
4135: 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))
4136: OR(NVL(c_fee_orig_rec.attribute1, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute1, OKL_API.G_MISS_CHAR))

Line 4133: 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)))

4129: 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)
4130: -- 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
4131: -- fee start date changes are not synced up on the original fee line
4132: -- 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)))
4133: 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)))
4134: --Bug# 4558486
4135: 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))
4136: OR(NVL(c_fee_orig_rec.attribute1, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute1, OKL_API.G_MISS_CHAR))
4137: OR(NVL(c_fee_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))

Line 4135: 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))

4131: -- fee start date changes are not synced up on the original fee line
4132: -- 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)))
4133: 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)))
4134: --Bug# 4558486
4135: 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))
4136: OR(NVL(c_fee_orig_rec.attribute1, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute1, OKL_API.G_MISS_CHAR))
4137: OR(NVL(c_fee_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))
4138: OR(NVL(c_fee_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
4139: OR(NVL(c_fee_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))

Line 4136: OR(NVL(c_fee_orig_rec.attribute1, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute1, OKL_API.G_MISS_CHAR))

4132: -- 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)))
4133: 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)))
4134: --Bug# 4558486
4135: 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))
4136: OR(NVL(c_fee_orig_rec.attribute1, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute1, OKL_API.G_MISS_CHAR))
4137: OR(NVL(c_fee_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))
4138: OR(NVL(c_fee_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
4139: OR(NVL(c_fee_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
4140: OR(NVL(c_fee_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))

Line 4137: OR(NVL(c_fee_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))

4133: 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)))
4134: --Bug# 4558486
4135: 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))
4136: OR(NVL(c_fee_orig_rec.attribute1, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute1, OKL_API.G_MISS_CHAR))
4137: OR(NVL(c_fee_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))
4138: OR(NVL(c_fee_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
4139: OR(NVL(c_fee_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
4140: OR(NVL(c_fee_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
4141: OR(NVL(c_fee_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))

Line 4138: OR(NVL(c_fee_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))

4134: --Bug# 4558486
4135: 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))
4136: OR(NVL(c_fee_orig_rec.attribute1, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute1, OKL_API.G_MISS_CHAR))
4137: OR(NVL(c_fee_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))
4138: OR(NVL(c_fee_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
4139: OR(NVL(c_fee_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
4140: OR(NVL(c_fee_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
4141: OR(NVL(c_fee_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
4142: OR(NVL(c_fee_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))

Line 4139: OR(NVL(c_fee_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))

4135: 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))
4136: OR(NVL(c_fee_orig_rec.attribute1, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute1, OKL_API.G_MISS_CHAR))
4137: OR(NVL(c_fee_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))
4138: OR(NVL(c_fee_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
4139: OR(NVL(c_fee_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
4140: OR(NVL(c_fee_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
4141: OR(NVL(c_fee_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
4142: OR(NVL(c_fee_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
4143: OR(NVL(c_fee_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))

Line 4140: OR(NVL(c_fee_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))

4136: OR(NVL(c_fee_orig_rec.attribute1, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute1, OKL_API.G_MISS_CHAR))
4137: OR(NVL(c_fee_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))
4138: OR(NVL(c_fee_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
4139: OR(NVL(c_fee_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
4140: OR(NVL(c_fee_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
4141: OR(NVL(c_fee_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
4142: OR(NVL(c_fee_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
4143: OR(NVL(c_fee_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
4144: OR(NVL(c_fee_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))

Line 4141: OR(NVL(c_fee_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))

4137: OR(NVL(c_fee_orig_rec.attribute2, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute2, OKL_API.G_MISS_CHAR))
4138: OR(NVL(c_fee_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
4139: OR(NVL(c_fee_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
4140: OR(NVL(c_fee_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
4141: OR(NVL(c_fee_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
4142: OR(NVL(c_fee_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
4143: OR(NVL(c_fee_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
4144: OR(NVL(c_fee_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
4145: OR(NVL(c_fee_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))

Line 4142: OR(NVL(c_fee_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))

4138: OR(NVL(c_fee_orig_rec.attribute3, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute3, OKL_API.G_MISS_CHAR))
4139: OR(NVL(c_fee_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
4140: OR(NVL(c_fee_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
4141: OR(NVL(c_fee_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
4142: OR(NVL(c_fee_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
4143: OR(NVL(c_fee_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
4144: OR(NVL(c_fee_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
4145: OR(NVL(c_fee_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
4146: OR(NVL(c_fee_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))

Line 4143: OR(NVL(c_fee_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))

4139: OR(NVL(c_fee_orig_rec.attribute4, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute4, OKL_API.G_MISS_CHAR))
4140: OR(NVL(c_fee_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
4141: OR(NVL(c_fee_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
4142: OR(NVL(c_fee_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
4143: OR(NVL(c_fee_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
4144: OR(NVL(c_fee_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
4145: OR(NVL(c_fee_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
4146: OR(NVL(c_fee_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
4147: OR(NVL(c_fee_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))

Line 4144: OR(NVL(c_fee_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))

4140: OR(NVL(c_fee_orig_rec.attribute5, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute5, OKL_API.G_MISS_CHAR))
4141: OR(NVL(c_fee_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
4142: OR(NVL(c_fee_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
4143: OR(NVL(c_fee_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
4144: OR(NVL(c_fee_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
4145: OR(NVL(c_fee_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
4146: OR(NVL(c_fee_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
4147: OR(NVL(c_fee_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))
4148: OR(NVL(c_fee_orig_rec.attribute13, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute13, OKL_API.G_MISS_CHAR))

Line 4145: OR(NVL(c_fee_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))

4141: OR(NVL(c_fee_orig_rec.attribute6, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute6, OKL_API.G_MISS_CHAR))
4142: OR(NVL(c_fee_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
4143: OR(NVL(c_fee_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
4144: OR(NVL(c_fee_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
4145: OR(NVL(c_fee_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
4146: OR(NVL(c_fee_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
4147: OR(NVL(c_fee_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))
4148: OR(NVL(c_fee_orig_rec.attribute13, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute13, OKL_API.G_MISS_CHAR))
4149: OR(NVL(c_fee_orig_rec.attribute14, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute14, OKL_API.G_MISS_CHAR))

Line 4146: OR(NVL(c_fee_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))

4142: OR(NVL(c_fee_orig_rec.attribute7, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute7, OKL_API.G_MISS_CHAR))
4143: OR(NVL(c_fee_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
4144: OR(NVL(c_fee_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
4145: OR(NVL(c_fee_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
4146: OR(NVL(c_fee_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
4147: OR(NVL(c_fee_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))
4148: OR(NVL(c_fee_orig_rec.attribute13, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute13, OKL_API.G_MISS_CHAR))
4149: OR(NVL(c_fee_orig_rec.attribute14, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute14, OKL_API.G_MISS_CHAR))
4150: OR(NVL(c_fee_orig_rec.attribute15, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute15, OKL_API.G_MISS_CHAR))

Line 4147: OR(NVL(c_fee_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))

4143: OR(NVL(c_fee_orig_rec.attribute8, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute8, OKL_API.G_MISS_CHAR))
4144: OR(NVL(c_fee_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
4145: OR(NVL(c_fee_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
4146: OR(NVL(c_fee_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
4147: OR(NVL(c_fee_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))
4148: OR(NVL(c_fee_orig_rec.attribute13, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute13, OKL_API.G_MISS_CHAR))
4149: OR(NVL(c_fee_orig_rec.attribute14, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute14, OKL_API.G_MISS_CHAR))
4150: OR(NVL(c_fee_orig_rec.attribute15, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute15, OKL_API.G_MISS_CHAR))
4151:

Line 4148: OR(NVL(c_fee_orig_rec.attribute13, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute13, OKL_API.G_MISS_CHAR))

4144: OR(NVL(c_fee_orig_rec.attribute9, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute9, OKL_API.G_MISS_CHAR))
4145: OR(NVL(c_fee_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
4146: OR(NVL(c_fee_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
4147: OR(NVL(c_fee_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))
4148: OR(NVL(c_fee_orig_rec.attribute13, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute13, OKL_API.G_MISS_CHAR))
4149: OR(NVL(c_fee_orig_rec.attribute14, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute14, OKL_API.G_MISS_CHAR))
4150: OR(NVL(c_fee_orig_rec.attribute15, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute15, OKL_API.G_MISS_CHAR))
4151:
4152: )THEN

Line 4149: OR(NVL(c_fee_orig_rec.attribute14, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute14, OKL_API.G_MISS_CHAR))

4145: OR(NVL(c_fee_orig_rec.attribute10, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute10, OKL_API.G_MISS_CHAR))
4146: OR(NVL(c_fee_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
4147: OR(NVL(c_fee_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))
4148: OR(NVL(c_fee_orig_rec.attribute13, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute13, OKL_API.G_MISS_CHAR))
4149: OR(NVL(c_fee_orig_rec.attribute14, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute14, OKL_API.G_MISS_CHAR))
4150: OR(NVL(c_fee_orig_rec.attribute15, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute15, OKL_API.G_MISS_CHAR))
4151:
4152: )THEN
4153: l_orig_st_fee_rec.line_id := c_fee_rbk_rec.orig_system_id1;

Line 4150: OR(NVL(c_fee_orig_rec.attribute15, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute15, OKL_API.G_MISS_CHAR))

4146: OR(NVL(c_fee_orig_rec.attribute11, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute11, OKL_API.G_MISS_CHAR))
4147: OR(NVL(c_fee_orig_rec.attribute12, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute12, OKL_API.G_MISS_CHAR))
4148: OR(NVL(c_fee_orig_rec.attribute13, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute13, OKL_API.G_MISS_CHAR))
4149: OR(NVL(c_fee_orig_rec.attribute14, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute14, OKL_API.G_MISS_CHAR))
4150: OR(NVL(c_fee_orig_rec.attribute15, OKL_API.G_MISS_CHAR) <> NVL(c_fee_rbk_rec.attribute15, OKL_API.G_MISS_CHAR))
4151:
4152: )THEN
4153: l_orig_st_fee_rec.line_id := c_fee_rbk_rec.orig_system_id1;
4154: l_orig_st_fee_rec.dnz_chr_id := p_orig_chr_id;

Line 4226: p_init_msg_list => OKL_API.G_FALSE,

4222:
4223: -- Update corresponding Orig Fee line
4224: okl_maintain_fee_pvt.update_fee_type(
4225: p_api_version => 1.0,
4226: p_init_msg_list => OKL_API.G_FALSE,
4227: x_return_status => x_return_status,
4228: x_msg_count => x_msg_count,
4229: x_msg_data => x_msg_data,
4230: p_fee_types_rec => l_orig_st_fee_rec,

Line 4265: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

4261: x_rulv_rec => x_rulv_freq_rec,
4262: x_rule_count => x_rule_count
4263: );
4264:
4265: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
4266: RAISE sync_fee_failed;
4267: END IF;
4268: l_orig_freq_rule_id := x_rulv_freq_rec.id;
4269: l_orig_freq_rgp_id := x_rulv_freq_rec.rgp_id;

Line 4282: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

4278: p_rule_code => 'LAFREQ',
4279: x_rulv_rec => x_rulv_freq_rec,
4280: x_rule_count => x_rule_count
4281: );
4282: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
4283: RAISE sync_fee_failed;
4284: END IF;
4285:
4286: IF (l_orig_freq <> x_rulv_freq_rec.object1_id1) THEN

Line 4295: p_init_msg_list => OKL_API.G_FALSE,

4291: x_rulv_freq_rec.rgp_id := l_orig_freq_rgp_id;
4292: x_rulv_freq_rec.dnz_chr_id := p_orig_chr_id;
4293: okl_rule_pub.update_rule(
4294: p_api_version => 1.0,
4295: p_init_msg_list => OKL_API.G_FALSE,
4296: x_return_status => x_return_status,
4297: x_msg_count => x_msg_count,
4298: x_msg_data => x_msg_data,
4299: p_rulv_rec => x_rulv_freq_rec,

Line 4324: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

4320: x_rulv_rec => x_rulv_exp_rec,
4321: x_rule_count => x_rule_count
4322: );
4323:
4324: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
4325: RAISE sync_fee_failed;
4326: END IF;
4327: l_orig_exp_rule_id := x_rulv_exp_rec.id;
4328: l_orig_exp_rgp_id := x_rulv_exp_rec.rgp_id;

Line 4342: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

4338: p_rule_code => 'LAFEXP',
4339: x_rulv_rec => x_rulv_exp_rec,
4340: x_rule_count => x_rule_count
4341: );
4342: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
4343: RAISE sync_fee_failed;
4344: END IF;
4345:
4346: IF (l_orig_exp_period <> x_rulv_exp_rec.rule_information1

Line 4358: p_init_msg_list => OKL_API.G_FALSE,

4354: x_rulv_exp_rec.rgp_id := l_orig_exp_rgp_id;
4355: x_rulv_exp_rec.dnz_chr_id := p_orig_chr_id;
4356: okl_rule_pub.update_rule(
4357: p_api_version => 1.0,
4358: p_init_msg_list => OKL_API.G_FALSE,
4359: x_return_status => x_return_status,
4360: x_msg_count => x_msg_count,
4361: x_msg_data => x_msg_data,
4362: p_rulv_rec => x_rulv_exp_rec,

Line 4400: p_init_msg_list => OKL_API.G_FALSE,

4396: -- okc_k_party_roles_b and okl_k_party_roles
4397: /*
4398: okl_okc_migration_pvt.update_k_party_role(
4399: p_api_version => 1.0,
4400: p_init_msg_list => OKL_API.G_FALSE,
4401: x_return_status => x_return_status,
4402: x_msg_count => x_msg_count,
4403: x_msg_data => x_msg_data,
4404: p_cplv_rec => l_cplv_rec,

Line 4411: p_init_msg_list => OKL_API.G_FALSE,

4407:
4408: l_kplv_rec.id := l_cplv_rec.id;
4409: okl_k_party_roles_pvt.update_k_party_role(
4410: p_api_version => 1.0,
4411: p_init_msg_list => OKL_API.G_FALSE,
4412: x_return_status => x_return_status,
4413: x_msg_count => x_msg_count,
4414: x_msg_data => x_msg_data,
4415: p_cplv_rec => l_cplv_rec,

Line 4442: p_init_msg_list => OKL_API.G_FALSE,

4438: -- okc_k_party_roles_b and okl_k_party_roles
4439: /*
4440: okl_okc_migration_pvt.create_k_party_role(
4441: p_api_version => 1.0,
4442: p_init_msg_list => OKL_API.G_FALSE,
4443: x_return_status => x_return_status,
4444: x_msg_count => x_msg_count,
4445: x_msg_data => x_msg_data,
4446: p_cplv_rec => l_cplv_rec,

Line 4452: p_init_msg_list => OKL_API.G_FALSE,

4448: */
4449:
4450: okl_k_party_roles_pvt.create_k_party_role(
4451: p_api_version => 1.0,
4452: p_init_msg_list => OKL_API.G_FALSE,
4453: x_return_status => x_return_status,
4454: x_msg_count => x_msg_count,
4455: x_msg_data => x_msg_data,
4456: p_cplv_rec => l_cplv_rec,

Line 4546: p_init_msg_list => OKL_API.G_FALSE,

4542:
4543: IF (l_u_line_item_tbl.COUNT > 0) THEN
4544: okl_contract_line_item_pvt.update_contract_line_item(
4545: p_api_version => 1.0,
4546: p_init_msg_list => OKL_API.G_FALSE,
4547: x_return_status => x_return_status,
4548: x_msg_count => x_msg_count,
4549: x_msg_data => x_msg_data,
4550: p_line_item_tbl => l_u_line_item_tbl,

Line 4596: p_init_msg_list => OKL_API.G_FALSE,

4592: /*
4593: IF (l_c_line_item_tbl.COUNT > 0) THEN
4594: okl_contract_line_item_pvt.create_contract_line_item(
4595: p_api_version => 1.0,
4596: p_init_msg_list => OKL_API.G_FALSE,
4597: x_return_status => x_return_status,
4598: x_msg_count => x_msg_count,
4599: x_msg_data => x_msg_data,
4600: p_line_item_tbl => l_c_line_item_tbl,

Line 4619: x_return_status := OKL_API.G_RET_STS_ERROR;

4615:
4616: -- OKL.H Projects changes ---
4617: EXCEPTION
4618: WHEN sync_fee_failed THEN
4619: x_return_status := OKL_API.G_RET_STS_ERROR;
4620:
4621: when OKL_API.G_EXCEPTION_ERROR then
4622: x_return_status := 'OKC_API.G_RET_STS_ERROR';
4623:

Line 4621: when OKL_API.G_EXCEPTION_ERROR then

4617: EXCEPTION
4618: WHEN sync_fee_failed THEN
4619: x_return_status := OKL_API.G_RET_STS_ERROR;
4620:
4621: when OKL_API.G_EXCEPTION_ERROR then
4622: x_return_status := 'OKC_API.G_RET_STS_ERROR';
4623:
4624: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
4625: x_return_status := 'OKC_API.G_RET_STS_UNEXP_ERROR';

Line 4624: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

4620:
4621: when OKL_API.G_EXCEPTION_ERROR then
4622: x_return_status := 'OKC_API.G_RET_STS_ERROR';
4623:
4624: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
4625: x_return_status := 'OKC_API.G_RET_STS_UNEXP_ERROR';
4626:
4627: END sync_fee_line;
4628:

Line 4907: p_init_msg_list => OKL_API.G_FALSE,

4903:
4904:
4905: okl_copy_contract_pub.copy_party_roles(
4906: p_api_version => 1.0,
4907: p_init_msg_list => OKL_API.G_FALSE,
4908: x_return_status => x_return_status,
4909: x_msg_count => x_msg_count,
4910: x_msg_data => x_msg_data,
4911: p_cpl_id => l_party_roles_new_rec.id,

Line 4917: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

4913: p_chr_id => NULL,
4914: p_rle_code => l_party_roles_new_rec.rle_code,
4915: x_cpl_id => x_cpl_id
4916: );
4917: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
4918: okl_debug_pub.logmessage('okl_copy_contract_pub.copy_party_roles sync_failed ');
4919: RAISE sync_failed;
4920: END IF;
4921: elsif (l_party_roles_old_rec.object1_id1 <> l_party_roles_new_rec.object1_id1) then

Line 4936: p_init_msg_list => OKL_API.G_FALSE,

4932: l_cplv_rec.rle_code := l_party_roles_new_rec.rle_code;
4933:
4934: okl_okc_migration_pvt.update_k_party_role(
4935: p_api_version => 1.0,
4936: p_init_msg_list => OKL_API.G_FALSE,
4937: x_return_status => x_return_status,
4938: x_msg_count => x_msg_count,
4939: x_msg_data => x_msg_data,
4940: p_cplv_rec => l_cplv_rec,

Line 4944: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

4940: p_cplv_rec => l_cplv_rec,
4941: x_cplv_rec => x_cplv_rec);
4942:
4943: -- check return status
4944: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
4945: okl_debug_pub.logmessage(' okl_okc_migration_pvt.update_contract_item sync_failed ');
4946: RAISE sync_failed;
4947: END IF;
4948:

Line 5026: p_init_msg_list => OKL_API.G_FALSE,

5022: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'new line id: '||l_new_klev_tbl(1).id);
5023: END IF;
5024: okl_copy_asset_pub.copy_all_lines(
5025: p_api_version => 1.0,
5026: p_init_msg_list => OKL_API.G_FALSE,
5027: x_return_status => x_return_status,
5028: x_msg_count => x_msg_count,
5029: x_msg_data => x_msg_data,
5030: p_from_cle_id_tbl => l_new_klev_tbl,

Line 5086: p_init_msg_list => OKL_API.G_FALSE,

5082: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'new line id: '||l_new_klev_tbl(1).id);
5083: END IF;
5084: okl_copy_asset_pub.copy_all_lines(
5085: p_api_version => 1.0,
5086: p_init_msg_list => OKL_API.G_FALSE,
5087: x_return_status => x_return_status,
5088: x_msg_count => x_msg_count,
5089: x_msg_data => x_msg_data,
5090: p_from_cle_id_tbl => l_new_klev_tbl,

Line 5298: p_init_msg_list => OKL_API.G_FALSE,

5294:
5295: -- Update contrat header with new start and end date
5296: okl_contract_pub.update_contract_header(
5297: p_api_version => 1.0,
5298: p_init_msg_list => OKL_API.G_FALSE,
5299: x_return_status => x_return_status,
5300: x_msg_count => x_msg_count,
5301: x_msg_data => x_msg_data,
5302: p_restricted_update => OKL_API.G_FALSE,

Line 5302: p_restricted_update => OKL_API.G_FALSE,

5298: p_init_msg_list => OKL_API.G_FALSE,
5299: x_return_status => x_return_status,
5300: x_msg_count => x_msg_count,
5301: x_msg_data => x_msg_data,
5302: p_restricted_update => OKL_API.G_FALSE,
5303: p_chrv_rec => l_chrv_rec,
5304: p_khrv_rec => l_khrv_rec,
5305: x_chrv_rec => x_chrv_rec,
5306: x_khrv_rec => x_khrv_rec

Line 5319: x_return_status := OKL_API.G_RET_STS_ERROR;

5315: END IF;
5316:
5317: EXCEPTION
5318: WHEN check_update_failed THEN
5319: x_return_status := OKL_API.G_RET_STS_ERROR;
5320: END check_and_update_date;
5321:
5322: ------------------------------------------------------------------------------
5323: -- PROCEDURE sync_rebook_orig_contract

Line 5404: okl_api.set_message(

5400: p_chr_id => p_rebook_chr_id,
5401: x_orig_chr_id => l_orig_chr_id
5402: );
5403: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
5404: okl_api.set_message(
5405: G_APP_NAME,
5406: G_LLA_NO_ORIG_REFERENCE
5407: );
5408: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 5556: p_init_msg_list => OKL_API.G_FALSE,

5552: -- Sync Subsidy lines
5553: --
5554: okl_subsidy_process_pvt.rebook_synchronize(
5555: p_api_version => p_api_version,
5556: p_init_msg_list => OKL_API.G_FALSE,
5557: x_return_status => x_return_status,
5558: x_msg_count => x_msg_count,
5559: x_msg_data => x_msg_data,
5560: p_rbk_chr_id => p_rebook_chr_id,

Line 5599: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

5595: RAISE OKC_API.G_EXCEPTION_ERROR;
5596: END IF;
5597:
5598: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
5599: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
5600: x_msg_data => x_msg_data);
5601:
5602: EXCEPTION
5603: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 5691: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

5687:
5688:
5689: EXCEPTION
5690: WHEN OTHERS THEN
5691: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
5692: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5693: END raise_business_event;
5694:
5695:

Line 5692: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

5688:
5689: EXCEPTION
5690: WHEN OTHERS THEN
5691: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
5692: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5693: END raise_business_event;
5694:
5695:
5696: /*

Line 5771: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

5767: */
5768: raise_business_event(p_chr_id => p_from_chr_id
5769: ,p_new_chr_id => x_rebook_chr_id
5770: ,x_return_status => x_return_status);
5771: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5773: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5774: RAISE OKL_API.G_EXCEPTION_ERROR;
5775: END IF;

Line 5772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

5768: raise_business_event(p_chr_id => p_from_chr_id
5769: ,p_new_chr_id => x_rebook_chr_id
5770: ,x_return_status => x_return_status);
5771: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5773: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5774: RAISE OKL_API.G_EXCEPTION_ERROR;
5775: END IF;
5776:

Line 5773: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

5769: ,p_new_chr_id => x_rebook_chr_id
5770: ,x_return_status => x_return_status);
5771: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5773: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5774: RAISE OKL_API.G_EXCEPTION_ERROR;
5775: END IF;
5776:
5777: /*

Line 5774: RAISE OKL_API.G_EXCEPTION_ERROR;

5770: ,x_return_status => x_return_status);
5771: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
5772: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
5773: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
5774: RAISE OKL_API.G_EXCEPTION_ERROR;
5775: END IF;
5776:
5777: /*
5778: -- mvasudev, 08/23/2004

Line 5783: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

5779: -- END, Code change to enable Business Event
5780: */
5781:
5782: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
5783: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
5784: x_msg_data => x_msg_data);
5785:
5786: EXCEPTION
5787: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 5920: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

5916: x_value => l_contract_secu,
5917: x_inv_agmt_chr_id_tbl => l_inv_agmt_chr_id_tbl
5918: );
5919:
5920: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
5921: RAISE secu_failed;
5922: END IF;
5923:
5924: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 5928: IF (l_contract_secu <> OKL_API.G_TRUE) THEN -- Do not proceed, return success

5924: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5925: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Contract Securitized? '||l_contract_secu);
5926: END IF;
5927:
5928: IF (l_contract_secu <> OKL_API.G_TRUE) THEN -- Do not proceed, return success
5929: x_return_status := OKL_API.G_RET_STS_SUCCESS;
5930: RETURN;
5931: END IF;
5932:

Line 5929: x_return_status := OKL_API.G_RET_STS_SUCCESS;

5925: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Contract Securitized? '||l_contract_secu);
5926: END IF;
5927:
5928: IF (l_contract_secu <> OKL_API.G_TRUE) THEN -- Do not proceed, return success
5929: x_return_status := OKL_API.G_RET_STS_SUCCESS;
5930: RETURN;
5931: END IF;
5932:
5933: --

Line 6066: p_init_msg_list => OKL_API.G_FALSE,

6062: -- Generate Investor accrual streams
6063: --
6064: OKL_ACCRUAL_SEC_PVT.CREATE_STREAMS(
6065: p_api_version => 1.0,
6066: p_init_msg_list => OKL_API.G_FALSE,
6067: x_return_status => x_return_status,
6068: x_msg_count => x_msg_count,
6069: x_msg_data => x_msg_data,
6070: p_khr_id => p_orig_chr_id

Line 6182: okl_api.set_message(

6178: p_chr_id => p_chr_id,
6179: x_orig_chr_id => l_orig_chr_id
6180: );
6181: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
6182: okl_api.set_message(
6183: G_APP_NAME,
6184: G_LLA_NO_ORIG_REFERENCE
6185: );
6186: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 6335: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

6331: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
6332: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After call okl_generate_accruals_pvt.adjust_accruals'||x_return_status);
6333: END IF;
6334:
6335: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
6336: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
6337: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
6338: RAISE Okl_Api.G_EXCEPTION_ERROR;
6339: END IF;

Line 6336: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

6332: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After call okl_generate_accruals_pvt.adjust_accruals'||x_return_status);
6333: END IF;
6334:
6335: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
6336: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
6337: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
6338: RAISE Okl_Api.G_EXCEPTION_ERROR;
6339: END IF;
6340: END IF;

Line 6337: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

6333: END IF;
6334:
6335: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
6336: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
6337: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
6338: RAISE Okl_Api.G_EXCEPTION_ERROR;
6339: END IF;
6340: END IF;
6341: -- Bug# 4775555: End

Line 6338: RAISE Okl_Api.G_EXCEPTION_ERROR;

6334:
6335: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
6336: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
6337: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
6338: RAISE Okl_Api.G_EXCEPTION_ERROR;
6339: END IF;
6340: END IF;
6341: -- Bug# 4775555: End
6342:

Line 6397: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

6393: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
6394: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After call okl_generate_accruals_pvt.adjust_accruals'||x_return_status);
6395: END IF;
6396:
6397: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
6398: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
6399: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
6400: RAISE Okl_Api.G_EXCEPTION_ERROR;
6401: END IF;

Line 6398: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

6394: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After call okl_generate_accruals_pvt.adjust_accruals'||x_return_status);
6395: END IF;
6396:
6397: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
6398: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
6399: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
6400: RAISE Okl_Api.G_EXCEPTION_ERROR;
6401: END IF;
6402: END IF;

Line 6399: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

6395: END IF;
6396:
6397: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
6398: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
6399: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
6400: RAISE Okl_Api.G_EXCEPTION_ERROR;
6401: END IF;
6402: END IF;
6403:

Line 6400: RAISE Okl_Api.G_EXCEPTION_ERROR;

6396:
6397: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
6398: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
6399: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
6400: RAISE Okl_Api.G_EXCEPTION_ERROR;
6401: END IF;
6402: END IF;
6403:
6404: END IF;

Line 6408: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

6404: END IF;
6405: -- MGAAP end 7263041
6406:
6407: --**********************************************************
6408: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
6409: x_msg_data => x_msg_data);
6410:
6411: EXCEPTION
6412: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 6537: okl_api.set_message(

6533: OPEN orig_csr(p_from_chr_id);
6534: FETCH orig_csr INTO l_orig_contract_number, l_orig_sts_code;--:| 24-Mar-08 cklee Bug# 6801137 -- Added validation logic |
6535:
6536: IF orig_csr%NOTFOUND THEN
6537: okl_api.set_message(
6538: G_APP_NAME,
6539: G_LLA_CHR_ID
6540: );
6541: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 6545: okl_api.set_message(

6541: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
6542: --start:| 24-Mar-08 cklee Bug# 6801137 -- Added validation logic |
6543: ELSE
6544: IF l_orig_sts_code <> 'BOOKED' THEN
6545: okl_api.set_message(
6546: G_APP_NAME,
6547: 'OKL_LLA_REV_ONLY_BOOKED'
6548: );
6549: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 6678: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

6674:
6675: x_rebook_chr_id := x_chr_id;
6676:
6677: --**********************************************************
6678: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
6679: x_msg_data => x_msg_data);
6680:
6681: EXCEPTION
6682: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 6843: x_return_status := OKL_API.G_RET_STS_SUCCESS;

6839: IF (G_DEBUG_ENABLED = 'Y') THEN
6840: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
6841: END IF;
6842:
6843: x_return_status := OKL_API.G_RET_STS_SUCCESS;
6844: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
6845: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
6846: END IF;
6847: -- call START_ACTIVITY to create savepoint, check compatibility

Line 6849: x_return_status := OKL_API.START_ACTIVITY(

6845: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
6846: END IF;
6847: -- call START_ACTIVITY to create savepoint, check compatibility
6848: -- and initialize message list
6849: x_return_status := OKL_API.START_ACTIVITY(
6850: p_api_name => l_api_name,
6851: p_pkg_name => G_PKG_NAME,
6852: p_init_msg_list => p_init_msg_list,
6853: l_api_version => l_api_version,

Line 6859: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

6855: p_api_type => G_API_TYPE,
6856: x_return_status => x_return_status);
6857:
6858: -- check if activity started successfully
6859: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
6860: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
6861: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
6862: raise OKL_API.G_EXCEPTION_ERROR;
6863: END IF;

Line 6860: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

6856: x_return_status => x_return_status);
6857:
6858: -- check if activity started successfully
6859: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
6860: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
6861: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
6862: raise OKL_API.G_EXCEPTION_ERROR;
6863: END IF;
6864:

Line 6861: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

6857:
6858: -- check if activity started successfully
6859: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
6860: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
6861: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
6862: raise OKL_API.G_EXCEPTION_ERROR;
6863: END IF;
6864:
6865: --Bug# 6344223

Line 6862: raise OKL_API.G_EXCEPTION_ERROR;

6858: -- check if activity started successfully
6859: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
6860: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
6861: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
6862: raise OKL_API.G_EXCEPTION_ERROR;
6863: END IF;
6864:
6865: --Bug# 6344223
6866: OPEN check_split_trx_csr;

Line 6968: p_init_msg_list => OKL_API.G_FALSE,

6964:
6965: -- Call Streams api to update Link_Hist_Stream_Id and Trx_Id
6966: okl_streams_pub.update_streams(
6967: p_api_version => 1.0,
6968: p_init_msg_list => OKL_API.G_FALSE,
6969: x_return_status => x_return_status,
6970: x_msg_count => x_msg_count,
6971: x_msg_data => x_msg_data,
6972: p_stmv_tbl => l_new_strm_tbl,

Line 6980: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

6976: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
6977: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of New Strms - Trx ID and Hist ID '||x_return_status);
6978: END IF;
6979:
6980: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
6981: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
6982: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
6983: raise OKL_API.G_EXCEPTION_ERROR;
6984: END IF;

Line 6981: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

6977: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of New Strms - Trx ID and Hist ID '||x_return_status);
6978: END IF;
6979:
6980: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
6981: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
6982: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
6983: raise OKL_API.G_EXCEPTION_ERROR;
6984: END IF;
6985: END IF;

Line 6982: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

6978: END IF;
6979:
6980: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
6981: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
6982: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
6983: raise OKL_API.G_EXCEPTION_ERROR;
6984: END IF;
6985: END IF;
6986: END IF;

Line 6983: raise OKL_API.G_EXCEPTION_ERROR;

6979:
6980: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
6981: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
6982: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
6983: raise OKL_API.G_EXCEPTION_ERROR;
6984: END IF;
6985: END IF;
6986: END IF;
6987:

Line 6988: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

6984: END IF;
6985: END IF;
6986: END IF;
6987:
6988: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
6989: x_msg_data => x_msg_data);
6990:
6991: EXCEPTION
6992: when OKL_API.G_EXCEPTION_ERROR then

Line 6992: when OKL_API.G_EXCEPTION_ERROR then

6988: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
6989: x_msg_data => x_msg_data);
6990:
6991: EXCEPTION
6992: when OKL_API.G_EXCEPTION_ERROR then
6993: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
6994: p_api_name => l_api_name,
6995: p_pkg_name => G_PKG_NAME,
6996: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 6993: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

6989: x_msg_data => x_msg_data);
6990:
6991: EXCEPTION
6992: when OKL_API.G_EXCEPTION_ERROR then
6993: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
6994: p_api_name => l_api_name,
6995: p_pkg_name => G_PKG_NAME,
6996: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
6997: x_msg_count => x_msg_count,

Line 6996: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

6992: when OKL_API.G_EXCEPTION_ERROR then
6993: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
6994: p_api_name => l_api_name,
6995: p_pkg_name => G_PKG_NAME,
6996: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
6997: x_msg_count => x_msg_count,
6998: x_msg_data => x_msg_data,
6999: p_api_type => G_API_TYPE);
7000:

Line 7001: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

6997: x_msg_count => x_msg_count,
6998: x_msg_data => x_msg_data,
6999: p_api_type => G_API_TYPE);
7000:
7001: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
7002: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
7003: p_api_name => l_api_name,
7004: p_pkg_name => G_PKG_NAME,
7005: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 7002: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

6998: x_msg_data => x_msg_data,
6999: p_api_type => G_API_TYPE);
7000:
7001: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
7002: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
7003: p_api_name => l_api_name,
7004: p_pkg_name => G_PKG_NAME,
7005: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
7006: x_msg_count => x_msg_count,

Line 7005: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

7001: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
7002: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
7003: p_api_name => l_api_name,
7004: p_pkg_name => G_PKG_NAME,
7005: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
7006: x_msg_count => x_msg_count,
7007: x_msg_data => x_msg_data,
7008: p_api_type => G_API_TYPE);
7009:

Line 7011: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

7007: x_msg_data => x_msg_data,
7008: p_api_type => G_API_TYPE);
7009:
7010: when OTHERS then
7011: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
7012: p_api_name => l_api_name,
7013: p_pkg_name => G_PKG_NAME,
7014: p_exc_name => 'OTHERS',
7015: x_msg_count => x_msg_count,

Line 7138: x_return_status := OKL_API.G_RET_STS_SUCCESS;

7134: IF (G_DEBUG_ENABLED = 'Y') THEN
7135: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
7136: END IF;
7137:
7138: x_return_status := OKL_API.G_RET_STS_SUCCESS;
7139: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7140: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
7141: END IF;
7142: -- call START_ACTIVITY to create savepoint, check compatibility

Line 7144: x_return_status := OKL_API.START_ACTIVITY(

7140: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
7141: END IF;
7142: -- call START_ACTIVITY to create savepoint, check compatibility
7143: -- and initialize message list
7144: x_return_status := OKL_API.START_ACTIVITY(
7145: p_api_name => l_api_name,
7146: p_pkg_name => G_PKG_NAME,
7147: p_init_msg_list => p_init_msg_list,
7148: l_api_version => l_api_version,

Line 7154: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

7150: p_api_type => G_API_TYPE,
7151: x_return_status => x_return_status);
7152:
7153: -- check if activity started successfully
7154: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7155: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7156: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7157: raise OKL_API.G_EXCEPTION_ERROR;
7158: END IF;

Line 7155: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

7151: x_return_status => x_return_status);
7152:
7153: -- check if activity started successfully
7154: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7155: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7156: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7157: raise OKL_API.G_EXCEPTION_ERROR;
7158: END IF;
7159:

Line 7156: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

7152:
7153: -- check if activity started successfully
7154: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7155: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7156: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7157: raise OKL_API.G_EXCEPTION_ERROR;
7158: END IF;
7159:
7160: -- For On-line and Mass rebook, calculate disbursement adjustment

Line 7157: raise OKL_API.G_EXCEPTION_ERROR;

7153: -- check if activity started successfully
7154: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7155: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7156: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7157: raise OKL_API.G_EXCEPTION_ERROR;
7158: END IF;
7159:
7160: -- For On-line and Mass rebook, calculate disbursement adjustment
7161: -- for all Current Billable Streams for which disbursement was done

Line 7242: p_init_msg_list => OKL_API.G_FALSE,

7238:
7239: IF (l_selv_tbl.COUNT > 0) THEN
7240: okl_streams_pub.update_stream_elements(
7241: p_api_version => 1.0,
7242: p_init_msg_list => OKL_API.G_FALSE,
7243: x_return_status => x_return_status,
7244: x_msg_count => x_msg_count,
7245: x_msg_data => x_msg_data,
7246: p_selv_tbl => l_selv_tbl,

Line 7254: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

7250: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7251: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of Stream Elements - Date Disbursed '||x_return_status);
7252: END IF;
7253:
7254: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7255: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7256: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7257: raise OKL_API.G_EXCEPTION_ERROR;
7258: END IF;

Line 7255: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

7251: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of Stream Elements - Date Disbursed '||x_return_status);
7252: END IF;
7253:
7254: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7255: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7256: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7257: raise OKL_API.G_EXCEPTION_ERROR;
7258: END IF;
7259: END IF;

Line 7256: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

7252: END IF;
7253:
7254: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7255: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7256: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7257: raise OKL_API.G_EXCEPTION_ERROR;
7258: END IF;
7259: END IF;
7260:

Line 7257: raise OKL_API.G_EXCEPTION_ERROR;

7253:
7254: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7255: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7256: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7257: raise OKL_API.G_EXCEPTION_ERROR;
7258: END IF;
7259: END IF;
7260:
7261: END IF;

Line 7336: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

7332: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7333: 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);
7334: END IF;
7335:
7336: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7337: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7338: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7339: RAISE OKL_API.G_EXCEPTION_ERROR;
7340: END IF;

Line 7337: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

7333: 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);
7334: END IF;
7335:
7336: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7337: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7338: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7339: RAISE OKL_API.G_EXCEPTION_ERROR;
7340: END IF;
7341: -- sjalasut, added code for Contract Rebook Enhancement. END

Line 7338: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

7334: END IF;
7335:
7336: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7337: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7338: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7339: RAISE OKL_API.G_EXCEPTION_ERROR;
7340: END IF;
7341: -- sjalasut, added code for Contract Rebook Enhancement. END
7342:

Line 7339: RAISE OKL_API.G_EXCEPTION_ERROR;

7335:
7336: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7337: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7338: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7339: RAISE OKL_API.G_EXCEPTION_ERROR;
7340: END IF;
7341: -- sjalasut, added code for Contract Rebook Enhancement. END
7342:
7343: END IF;

Line 7345: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

7341: -- sjalasut, added code for Contract Rebook Enhancement. END
7342:
7343: END IF;
7344:
7345: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
7346: x_msg_data => x_msg_data);
7347:
7348: EXCEPTION
7349: when OKL_API.G_EXCEPTION_ERROR then

Line 7349: when OKL_API.G_EXCEPTION_ERROR then

7345: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
7346: x_msg_data => x_msg_data);
7347:
7348: EXCEPTION
7349: when OKL_API.G_EXCEPTION_ERROR then
7350: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
7351: p_api_name => l_api_name,
7352: p_pkg_name => G_PKG_NAME,
7353: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 7350: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

7346: x_msg_data => x_msg_data);
7347:
7348: EXCEPTION
7349: when OKL_API.G_EXCEPTION_ERROR then
7350: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
7351: p_api_name => l_api_name,
7352: p_pkg_name => G_PKG_NAME,
7353: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
7354: x_msg_count => x_msg_count,

Line 7353: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

7349: when OKL_API.G_EXCEPTION_ERROR then
7350: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
7351: p_api_name => l_api_name,
7352: p_pkg_name => G_PKG_NAME,
7353: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
7354: x_msg_count => x_msg_count,
7355: x_msg_data => x_msg_data,
7356: p_api_type => G_API_TYPE);
7357:

Line 7358: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

7354: x_msg_count => x_msg_count,
7355: x_msg_data => x_msg_data,
7356: p_api_type => G_API_TYPE);
7357:
7358: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
7359: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
7360: p_api_name => l_api_name,
7361: p_pkg_name => G_PKG_NAME,
7362: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 7359: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

7355: x_msg_data => x_msg_data,
7356: p_api_type => G_API_TYPE);
7357:
7358: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
7359: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
7360: p_api_name => l_api_name,
7361: p_pkg_name => G_PKG_NAME,
7362: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
7363: x_msg_count => x_msg_count,

Line 7362: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

7358: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
7359: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
7360: p_api_name => l_api_name,
7361: p_pkg_name => G_PKG_NAME,
7362: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
7363: x_msg_count => x_msg_count,
7364: x_msg_data => x_msg_data,
7365: p_api_type => G_API_TYPE);
7366:

Line 7368: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

7364: x_msg_data => x_msg_data,
7365: p_api_type => G_API_TYPE);
7366:
7367: when OTHERS then
7368: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
7369: p_api_name => l_api_name,
7370: p_pkg_name => G_PKG_NAME,
7371: p_exc_name => 'OTHERS',
7372: x_msg_count => x_msg_count,

Line 7488: x_return_status := OKL_API.G_RET_STS_SUCCESS;

7484: IF (G_DEBUG_ENABLED = 'Y') THEN
7485: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
7486: END IF;
7487:
7488: x_return_status := OKL_API.G_RET_STS_SUCCESS;
7489: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7490: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
7491: END IF;
7492: -- call START_ACTIVITY to create savepoint, check compatibility

Line 7494: x_return_status := OKL_API.START_ACTIVITY(

7490: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
7491: END IF;
7492: -- call START_ACTIVITY to create savepoint, check compatibility
7493: -- and initialize message list
7494: x_return_status := OKL_API.START_ACTIVITY(
7495: p_api_name => l_api_name,
7496: p_pkg_name => G_PKG_NAME,
7497: p_init_msg_list => p_init_msg_list,
7498: l_api_version => l_api_version,

Line 7504: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

7500: p_api_type => G_API_TYPE,
7501: x_return_status => x_return_status);
7502:
7503: -- check if activity started successfully
7504: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7505: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7506: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7507: raise OKL_API.G_EXCEPTION_ERROR;
7508: END IF;

Line 7505: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

7501: x_return_status => x_return_status);
7502:
7503: -- check if activity started successfully
7504: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7505: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7506: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7507: raise OKL_API.G_EXCEPTION_ERROR;
7508: END IF;
7509:

Line 7506: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

7502:
7503: -- check if activity started successfully
7504: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7505: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7506: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7507: raise OKL_API.G_EXCEPTION_ERROR;
7508: END IF;
7509:
7510: -- For On-line and Mass rebook, calculate billing adjustment

Line 7507: raise OKL_API.G_EXCEPTION_ERROR;

7503: -- check if activity started successfully
7504: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7505: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7506: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7507: raise OKL_API.G_EXCEPTION_ERROR;
7508: END IF;
7509:
7510: -- For On-line and Mass rebook, calculate billing adjustment
7511: -- for all Current Billable Streams for which billing was done

Line 7593: p_init_msg_list => OKL_API.G_FALSE,

7589:
7590: IF (l_selv_tbl.COUNT > 0) THEN
7591: okl_streams_pub.update_stream_elements(
7592: p_api_version => 1.0,
7593: p_init_msg_list => OKL_API.G_FALSE,
7594: x_return_status => x_return_status,
7595: x_msg_count => x_msg_count,
7596: x_msg_data => x_msg_data,
7597: p_selv_tbl => l_selv_tbl,

Line 7605: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

7601: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7602: 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);
7603: END IF;
7604:
7605: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7606: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7607: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7608: raise OKL_API.G_EXCEPTION_ERROR;
7609: END IF;

Line 7606: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

7602: 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);
7603: END IF;
7604:
7605: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7606: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7607: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7608: raise OKL_API.G_EXCEPTION_ERROR;
7609: END IF;
7610: END IF;

Line 7607: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

7603: END IF;
7604:
7605: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7606: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7607: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7608: raise OKL_API.G_EXCEPTION_ERROR;
7609: END IF;
7610: END IF;
7611:

Line 7608: raise OKL_API.G_EXCEPTION_ERROR;

7604:
7605: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7606: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7607: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7608: raise OKL_API.G_EXCEPTION_ERROR;
7609: END IF;
7610: END IF;
7611:
7612: END IF;

Line 7678: ,p_commit => OKL_API.G_FALSE

7674: ,p_init_msg_list => p_init_msg_list
7675: ,x_return_status => x_return_status
7676: ,x_msg_count => x_msg_count
7677: ,x_msg_data => x_msg_data
7678: ,p_commit => OKL_API.G_FALSE
7679: ,p_rebook_adj_tbl => l_rebook_adj_tbl
7680: );
7681:
7682: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 7686: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

7682: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
7683: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After calling OKL_REBOOK_CM_PVT.Rebook_Bill_adjustments '||x_return_status);
7684: END IF;
7685:
7686: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7687: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7688: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7689: raise OKL_API.G_EXCEPTION_ERROR;
7690: END IF;

Line 7687: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

7683: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After calling OKL_REBOOK_CM_PVT.Rebook_Bill_adjustments '||x_return_status);
7684: END IF;
7685:
7686: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7687: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7688: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7689: raise OKL_API.G_EXCEPTION_ERROR;
7690: END IF;
7691:

Line 7688: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

7684: END IF;
7685:
7686: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7687: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7688: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7689: raise OKL_API.G_EXCEPTION_ERROR;
7690: END IF;
7691:
7692: --Bug# 4884423

Line 7689: raise OKL_API.G_EXCEPTION_ERROR;

7685:
7686: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7687: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7688: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7689: raise OKL_API.G_EXCEPTION_ERROR;
7690: END IF;
7691:
7692: --Bug# 4884423
7693: --Added new procedure for passthrough adjustments

Line 7704: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

7700: ,x_return_status => x_return_status
7701: ,x_msg_count => x_msg_count
7702: ,x_msg_data => x_msg_data
7703: );
7704: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7705: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7706: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7707: RAISE OKL_API.G_EXCEPTION_ERROR;
7708: END IF;

Line 7705: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

7701: ,x_msg_count => x_msg_count
7702: ,x_msg_data => x_msg_data
7703: );
7704: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7705: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7706: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7707: RAISE OKL_API.G_EXCEPTION_ERROR;
7708: END IF;
7709: -- sjalasut, added code for Contract Rebook Enhancement. END

Line 7706: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

7702: ,x_msg_data => x_msg_data
7703: );
7704: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7705: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7706: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7707: RAISE OKL_API.G_EXCEPTION_ERROR;
7708: END IF;
7709: -- sjalasut, added code for Contract Rebook Enhancement. END
7710: */

Line 7707: RAISE OKL_API.G_EXCEPTION_ERROR;

7703: );
7704: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7705: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7706: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7707: RAISE OKL_API.G_EXCEPTION_ERROR;
7708: END IF;
7709: -- sjalasut, added code for Contract Rebook Enhancement. END
7710: */
7711:

Line 7727: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

7723: p_trx_id => p_trx_id,
7724: p_trx_date => p_trx_date
7725: );
7726:
7727: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7728: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7729: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7730: RAISE OKL_API.G_EXCEPTION_ERROR;
7731: END IF;

Line 7728: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

7724: p_trx_date => p_trx_date
7725: );
7726:
7727: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7728: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7729: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7730: RAISE OKL_API.G_EXCEPTION_ERROR;
7731: END IF;
7732:

Line 7729: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

7725: );
7726:
7727: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7728: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7729: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7730: RAISE OKL_API.G_EXCEPTION_ERROR;
7731: END IF;
7732:
7733: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 7730: RAISE OKL_API.G_EXCEPTION_ERROR;

7726:
7727: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7728: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7729: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7730: RAISE OKL_API.G_EXCEPTION_ERROR;
7731: END IF;
7732:
7733: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
7734: x_msg_data => x_msg_data);

Line 7733: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

7729: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7730: RAISE OKL_API.G_EXCEPTION_ERROR;
7731: END IF;
7732:
7733: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
7734: x_msg_data => x_msg_data);
7735:
7736: EXCEPTION
7737: when OKL_API.G_EXCEPTION_ERROR then

Line 7737: when OKL_API.G_EXCEPTION_ERROR then

7733: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
7734: x_msg_data => x_msg_data);
7735:
7736: EXCEPTION
7737: when OKL_API.G_EXCEPTION_ERROR then
7738: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
7739: p_api_name => l_api_name,
7740: p_pkg_name => G_PKG_NAME,
7741: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 7738: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

7734: x_msg_data => x_msg_data);
7735:
7736: EXCEPTION
7737: when OKL_API.G_EXCEPTION_ERROR then
7738: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
7739: p_api_name => l_api_name,
7740: p_pkg_name => G_PKG_NAME,
7741: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
7742: x_msg_count => x_msg_count,

Line 7741: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

7737: when OKL_API.G_EXCEPTION_ERROR then
7738: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
7739: p_api_name => l_api_name,
7740: p_pkg_name => G_PKG_NAME,
7741: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
7742: x_msg_count => x_msg_count,
7743: x_msg_data => x_msg_data,
7744: p_api_type => G_API_TYPE);
7745:

Line 7746: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

7742: x_msg_count => x_msg_count,
7743: x_msg_data => x_msg_data,
7744: p_api_type => G_API_TYPE);
7745:
7746: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
7747: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
7748: p_api_name => l_api_name,
7749: p_pkg_name => G_PKG_NAME,
7750: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 7747: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

7743: x_msg_data => x_msg_data,
7744: p_api_type => G_API_TYPE);
7745:
7746: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
7747: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
7748: p_api_name => l_api_name,
7749: p_pkg_name => G_PKG_NAME,
7750: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
7751: x_msg_count => x_msg_count,

Line 7750: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

7746: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
7747: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
7748: p_api_name => l_api_name,
7749: p_pkg_name => G_PKG_NAME,
7750: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
7751: x_msg_count => x_msg_count,
7752: x_msg_data => x_msg_data,
7753: p_api_type => G_API_TYPE);
7754:

Line 7756: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

7752: x_msg_data => x_msg_data,
7753: p_api_type => G_API_TYPE);
7754:
7755: when OTHERS then
7756: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
7757: p_api_name => l_api_name,
7758: p_pkg_name => G_PKG_NAME,
7759: p_exc_name => 'OTHERS',
7760: x_msg_count => x_msg_count,

Line 7887: x_return_status := OKL_API.G_RET_STS_SUCCESS;

7883: l_gl_date DATE;
7884:
7885: BEGIN
7886:
7887: x_return_status := OKL_API.G_RET_STS_SUCCESS;
7888: debug_message(l_proc_name);
7889: -- call START_ACTIVITY to create savepoint, check compatibility
7890: -- and initialize message list
7891: x_return_status := OKL_API.START_ACTIVITY(

Line 7891: x_return_status := OKL_API.START_ACTIVITY(

7887: x_return_status := OKL_API.G_RET_STS_SUCCESS;
7888: debug_message(l_proc_name);
7889: -- call START_ACTIVITY to create savepoint, check compatibility
7890: -- and initialize message list
7891: x_return_status := OKL_API.START_ACTIVITY(
7892: p_api_name => l_api_name,
7893: p_pkg_name => G_PKG_NAME,
7894: p_init_msg_list => p_init_msg_list,
7895: l_api_version => l_api_version,

Line 7901: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

7897: p_api_type => G_API_TYPE,
7898: x_return_status => x_return_status);
7899:
7900: -- check if activity started successfully
7901: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7902: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7903: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7904: raise OKL_API.G_EXCEPTION_ERROR;
7905: END IF;

Line 7902: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

7898: x_return_status => x_return_status);
7899:
7900: -- check if activity started successfully
7901: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7902: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7903: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7904: raise OKL_API.G_EXCEPTION_ERROR;
7905: END IF;
7906:

Line 7903: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

7899:
7900: -- check if activity started successfully
7901: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7902: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7903: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7904: raise OKL_API.G_EXCEPTION_ERROR;
7905: END IF;
7906:
7907: -- For On-line and Mass rebook, calculate accrual adjustment

Line 7904: raise OKL_API.G_EXCEPTION_ERROR;

7900: -- check if activity started successfully
7901: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7902: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7903: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7904: raise OKL_API.G_EXCEPTION_ERROR;
7905: END IF;
7906:
7907: -- For On-line and Mass rebook, calculate accrual adjustment
7908: -- for all Current Accrual Streams for which Accruals were generated

Line 7977: p_init_msg_list => OKL_API.G_FALSE,

7973:
7974: IF (l_selv_tbl.COUNT > 0) THEN
7975: okl_streams_pub.update_stream_elements(
7976: p_api_version => 1.0,
7977: p_init_msg_list => OKL_API.G_FALSE,
7978: x_return_status => x_return_status,
7979: x_msg_count => x_msg_count,
7980: x_msg_data => x_msg_data,
7981: p_selv_tbl => l_selv_tbl,

Line 7987: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

7983: );
7984:
7985: debug_message('After Update of Stream Elements - Accrued Yn and Accrual Adj Flag '||x_return_status);
7986:
7987: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7988: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7989: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7990: raise OKL_API.G_EXCEPTION_ERROR;
7991: END IF;

Line 7988: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

7984:
7985: debug_message('After Update of Stream Elements - Accrued Yn and Accrual Adj Flag '||x_return_status);
7986:
7987: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7988: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7989: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7990: raise OKL_API.G_EXCEPTION_ERROR;
7991: END IF;
7992: END IF;

Line 7989: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

7985: debug_message('After Update of Stream Elements - Accrued Yn and Accrual Adj Flag '||x_return_status);
7986:
7987: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7988: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7989: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7990: raise OKL_API.G_EXCEPTION_ERROR;
7991: END IF;
7992: END IF;
7993:

Line 7990: raise OKL_API.G_EXCEPTION_ERROR;

7986:
7987: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
7988: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7989: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
7990: raise OKL_API.G_EXCEPTION_ERROR;
7991: END IF;
7992: END IF;
7993:
7994: END IF;

Line 8072: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

8068: p_stream_tbl => l_stream_tbl);
8069:
8070: debug_message('After calling OKL_GENERATE_ACCRUALS_PVT.ADJUST_ACCRUALS '||x_return_status);
8071:
8072: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8073: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8074: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8075: raise OKL_API.G_EXCEPTION_ERROR;
8076: END IF;

Line 8073: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

8069:
8070: debug_message('After calling OKL_GENERATE_ACCRUALS_PVT.ADJUST_ACCRUALS '||x_return_status);
8071:
8072: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8073: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8074: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8075: raise OKL_API.G_EXCEPTION_ERROR;
8076: END IF;
8077: END IF;

Line 8074: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

8070: debug_message('After calling OKL_GENERATE_ACCRUALS_PVT.ADJUST_ACCRUALS '||x_return_status);
8071:
8072: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8073: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8074: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8075: raise OKL_API.G_EXCEPTION_ERROR;
8076: END IF;
8077: END IF;
8078:

Line 8075: raise OKL_API.G_EXCEPTION_ERROR;

8071:
8072: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8073: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8074: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8075: raise OKL_API.G_EXCEPTION_ERROR;
8076: END IF;
8077: END IF;
8078:
8079: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 8079: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

8075: raise OKL_API.G_EXCEPTION_ERROR;
8076: END IF;
8077: END IF;
8078:
8079: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
8080: x_msg_data => x_msg_data);
8081:
8082: EXCEPTION
8083: when OKL_API.G_EXCEPTION_ERROR then

Line 8083: when OKL_API.G_EXCEPTION_ERROR then

8079: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
8080: x_msg_data => x_msg_data);
8081:
8082: EXCEPTION
8083: when OKL_API.G_EXCEPTION_ERROR then
8084: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8085: p_api_name => l_api_name,
8086: p_pkg_name => G_PKG_NAME,
8087: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 8084: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

8080: x_msg_data => x_msg_data);
8081:
8082: EXCEPTION
8083: when OKL_API.G_EXCEPTION_ERROR then
8084: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8085: p_api_name => l_api_name,
8086: p_pkg_name => G_PKG_NAME,
8087: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
8088: x_msg_count => x_msg_count,

Line 8087: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

8083: when OKL_API.G_EXCEPTION_ERROR then
8084: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8085: p_api_name => l_api_name,
8086: p_pkg_name => G_PKG_NAME,
8087: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
8088: x_msg_count => x_msg_count,
8089: x_msg_data => x_msg_data,
8090: p_api_type => G_API_TYPE);
8091:

Line 8092: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

8088: x_msg_count => x_msg_count,
8089: x_msg_data => x_msg_data,
8090: p_api_type => G_API_TYPE);
8091:
8092: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
8093: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8094: p_api_name => l_api_name,
8095: p_pkg_name => G_PKG_NAME,
8096: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 8093: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

8089: x_msg_data => x_msg_data,
8090: p_api_type => G_API_TYPE);
8091:
8092: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
8093: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8094: p_api_name => l_api_name,
8095: p_pkg_name => G_PKG_NAME,
8096: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
8097: x_msg_count => x_msg_count,

Line 8096: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

8092: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
8093: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8094: p_api_name => l_api_name,
8095: p_pkg_name => G_PKG_NAME,
8096: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
8097: x_msg_count => x_msg_count,
8098: x_msg_data => x_msg_data,
8099: p_api_type => G_API_TYPE);
8100:

Line 8102: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

8098: x_msg_data => x_msg_data,
8099: p_api_type => G_API_TYPE);
8100:
8101: when OTHERS then
8102: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8103: p_api_name => l_api_name,
8104: p_pkg_name => G_PKG_NAME,
8105: p_exc_name => 'OTHERS',
8106: x_msg_count => x_msg_count,

Line 8273: x_return_status := OKL_API.G_RET_STS_SUCCESS;

8269: IF (G_DEBUG_ENABLED = 'Y') THEN
8270: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
8271: END IF;
8272:
8273: x_return_status := OKL_API.G_RET_STS_SUCCESS;
8274: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
8275: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
8276: END IF;
8277: -- call START_ACTIVITY to create savepoint, check compatibility

Line 8279: x_return_status := OKL_API.START_ACTIVITY(

8275: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
8276: END IF;
8277: -- call START_ACTIVITY to create savepoint, check compatibility
8278: -- and initialize message list
8279: x_return_status := OKL_API.START_ACTIVITY(
8280: p_api_name => l_api_name,
8281: p_pkg_name => G_PKG_NAME,
8282: p_init_msg_list => p_init_msg_list,
8283: l_api_version => l_api_version,

Line 8289: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

8285: p_api_type => G_API_TYPE,
8286: x_return_status => x_return_status);
8287:
8288: -- check if activity started successfully
8289: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8291: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8292: RAISE OKL_API.G_EXCEPTION_ERROR;
8293: END IF;

Line 8290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

8286: x_return_status => x_return_status);
8287:
8288: -- check if activity started successfully
8289: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8291: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8292: RAISE OKL_API.G_EXCEPTION_ERROR;
8293: END IF;
8294:

Line 8291: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

8287:
8288: -- check if activity started successfully
8289: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8291: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8292: RAISE OKL_API.G_EXCEPTION_ERROR;
8293: END IF;
8294:
8295: -- For On-line and Mass rebook, calculate accrual adjustment

Line 8292: RAISE OKL_API.G_EXCEPTION_ERROR;

8288: -- check if activity started successfully
8289: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8290: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8291: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8292: RAISE OKL_API.G_EXCEPTION_ERROR;
8293: END IF;
8294:
8295: -- For On-line and Mass rebook, calculate accrual adjustment
8296: -- for all Current Accrual Streams for which Accruals were generated

Line 8384: p_init_msg_list => OKL_API.G_FALSE,

8380:
8381: IF (l_selv_tbl.COUNT > 0) THEN
8382: okl_streams_pub.update_stream_elements(
8383: p_api_version => 1.0,
8384: p_init_msg_list => OKL_API.G_FALSE,
8385: x_return_status => x_return_status,
8386: x_msg_count => x_msg_count,
8387: x_msg_data => x_msg_data,
8388: p_selv_tbl => l_selv_tbl,

Line 8396: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

8392: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
8393: 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);
8394: END IF;
8395:
8396: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8397: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8398: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8399: RAISE OKL_API.G_EXCEPTION_ERROR;
8400: END IF;

Line 8397: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

8393: 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);
8394: END IF;
8395:
8396: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8397: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8398: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8399: RAISE OKL_API.G_EXCEPTION_ERROR;
8400: END IF;
8401: END IF;

Line 8398: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

8394: END IF;
8395:
8396: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8397: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8398: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8399: RAISE OKL_API.G_EXCEPTION_ERROR;
8400: END IF;
8401: END IF;
8402:

Line 8399: RAISE OKL_API.G_EXCEPTION_ERROR;

8395:
8396: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
8397: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8398: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
8399: RAISE OKL_API.G_EXCEPTION_ERROR;
8400: END IF;
8401: END IF;
8402:
8403: END IF;

Line 8492: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

8488: x_stream_tbl := l_stream_tbl;
8489: x_accrual_rec := l_accrual_rec;
8490: END IF;
8491:
8492: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
8493: x_msg_data => x_msg_data);
8494:
8495: EXCEPTION
8496: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 8496: WHEN OKL_API.G_EXCEPTION_ERROR THEN

8492: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
8493: x_msg_data => x_msg_data);
8494:
8495: EXCEPTION
8496: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8497: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8498: p_api_name => l_api_name,
8499: p_pkg_name => G_PKG_NAME,
8500: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 8497: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

8493: x_msg_data => x_msg_data);
8494:
8495: EXCEPTION
8496: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8497: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8498: p_api_name => l_api_name,
8499: p_pkg_name => G_PKG_NAME,
8500: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
8501: x_msg_count => x_msg_count,

Line 8500: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

8496: WHEN OKL_API.G_EXCEPTION_ERROR THEN
8497: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8498: p_api_name => l_api_name,
8499: p_pkg_name => G_PKG_NAME,
8500: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
8501: x_msg_count => x_msg_count,
8502: x_msg_data => x_msg_data,
8503: p_api_type => G_API_TYPE);
8504:

Line 8505: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

8501: x_msg_count => x_msg_count,
8502: x_msg_data => x_msg_data,
8503: p_api_type => G_API_TYPE);
8504:
8505: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8506: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8507: p_api_name => l_api_name,
8508: p_pkg_name => G_PKG_NAME,
8509: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 8506: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

8502: x_msg_data => x_msg_data,
8503: p_api_type => G_API_TYPE);
8504:
8505: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8506: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8507: p_api_name => l_api_name,
8508: p_pkg_name => G_PKG_NAME,
8509: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
8510: x_msg_count => x_msg_count,

Line 8509: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

8505: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
8506: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8507: p_api_name => l_api_name,
8508: p_pkg_name => G_PKG_NAME,
8509: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
8510: x_msg_count => x_msg_count,
8511: x_msg_data => x_msg_data,
8512: p_api_type => G_API_TYPE);
8513:

Line 8515: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

8511: x_msg_data => x_msg_data,
8512: p_api_type => G_API_TYPE);
8513:
8514: WHEN OTHERS THEN
8515: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8516: p_api_name => l_api_name,
8517: p_pkg_name => G_PKG_NAME,
8518: p_exc_name => 'OTHERS',
8519: x_msg_count => x_msg_count,

Line 8680: x_return_status := OKL_API.G_RET_STS_SUCCESS;

8676: IF (G_DEBUG_ENABLED = 'Y') THEN
8677: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
8678: END IF;
8679:
8680: x_return_status := OKL_API.G_RET_STS_SUCCESS;
8681: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
8682: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
8683: END IF;
8684: -- call START_ACTIVITY to create savepoint, check compatibility

Line 8686: x_return_status := OKL_API.START_ACTIVITY(

8682: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
8683: END IF;
8684: -- call START_ACTIVITY to create savepoint, check compatibility
8685: -- and initialize message list
8686: x_return_status := OKL_API.START_ACTIVITY(
8687: p_api_name => l_api_name,
8688: p_pkg_name => G_PKG_NAME,
8689: p_init_msg_list => p_init_msg_list,
8690: l_api_version => l_api_version,

Line 8696: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

8692: p_api_type => G_API_TYPE,
8693: x_return_status => x_return_status);
8694:
8695: -- check if activity started successfully
8696: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8697: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8698: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8699: raise OKL_API.G_EXCEPTION_ERROR;
8700: END IF;

Line 8697: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

8693: x_return_status => x_return_status);
8694:
8695: -- check if activity started successfully
8696: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8697: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8698: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8699: raise OKL_API.G_EXCEPTION_ERROR;
8700: END IF;
8701:

Line 8698: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

8694:
8695: -- check if activity started successfully
8696: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8697: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8698: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8699: raise OKL_API.G_EXCEPTION_ERROR;
8700: END IF;
8701:
8702: -- For On-line and Mass rebook, calculate disbursement adjustment

Line 8699: raise OKL_API.G_EXCEPTION_ERROR;

8695: -- check if activity started successfully
8696: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8697: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8698: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8699: raise OKL_API.G_EXCEPTION_ERROR;
8700: END IF;
8701:
8702: -- For On-line and Mass rebook, calculate disbursement adjustment
8703: -- for all Current Billable Securitized Streams for which billing was done

Line 8782: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

8778: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
8779: 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);
8780: END IF;
8781:
8782: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8783: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8784: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8785: raise OKL_API.G_EXCEPTION_ERROR;
8786: END IF;

Line 8783: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

8779: 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);
8780: END IF;
8781:
8782: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8783: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8784: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8785: raise OKL_API.G_EXCEPTION_ERROR;
8786: END IF;
8787: END IF;

Line 8784: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

8780: END IF;
8781:
8782: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8783: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8784: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8785: raise OKL_API.G_EXCEPTION_ERROR;
8786: END IF;
8787: END IF;
8788: END LOOP;

Line 8785: raise OKL_API.G_EXCEPTION_ERROR;

8781:
8782: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8783: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8784: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8785: raise OKL_API.G_EXCEPTION_ERROR;
8786: END IF;
8787: END IF;
8788: END LOOP;
8789: END LOOP;

Line 8800: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

8796: x_return_status => x_return_status,
8797: x_primary_sty_id => l_disb_adj_sty_id
8798: );
8799:
8800: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8801: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8802: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8803: raise OKL_API.G_EXCEPTION_ERROR;
8804: END IF;

Line 8801: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

8797: x_primary_sty_id => l_disb_adj_sty_id
8798: );
8799:
8800: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8801: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8802: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8803: raise OKL_API.G_EXCEPTION_ERROR;
8804: END IF;
8805:

Line 8802: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

8798: );
8799:
8800: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8801: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8802: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8803: raise OKL_API.G_EXCEPTION_ERROR;
8804: END IF;
8805:
8806: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 8803: raise OKL_API.G_EXCEPTION_ERROR;

8799:
8800: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8801: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8802: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8803: raise OKL_API.G_EXCEPTION_ERROR;
8804: END IF;
8805:
8806: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
8807: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Disb Adjustment Stream Type Id: '||l_disb_adj_sty_id);

Line 8866: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

8862: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Historizing Existing Investor Disbursement Adjustment Stream');
8863: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After calling OKL_STREAMS_PUB.update_streams'||x_return_status);
8864: END IF;
8865:
8866: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8867: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8868: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8869: raise OKL_API.G_EXCEPTION_ERROR;
8870: END IF;

Line 8867: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

8863: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After calling OKL_STREAMS_PUB.update_streams'||x_return_status);
8864: END IF;
8865:
8866: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8867: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8868: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8869: raise OKL_API.G_EXCEPTION_ERROR;
8870: END IF;
8871: END IF;

Line 8868: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

8864: END IF;
8865:
8866: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8867: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8868: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8869: raise OKL_API.G_EXCEPTION_ERROR;
8870: END IF;
8871: END IF;
8872:

Line 8869: raise OKL_API.G_EXCEPTION_ERROR;

8865:
8866: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8867: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8868: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8869: raise OKL_API.G_EXCEPTION_ERROR;
8870: END IF;
8871: END IF;
8872:
8873: l_stmv_rec_new_disb.khr_id := p_orig_khr_id;

Line 8916: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

8912: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Creating New Investor Disbursement Adjustment Stream');
8913: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After calling OKL_STREAMS_PUB.create_streams'||x_return_status);
8914: END IF;
8915:
8916: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8917: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8918: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8919: raise OKL_API.G_EXCEPTION_ERROR;
8920: END IF;

Line 8917: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

8913: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After calling OKL_STREAMS_PUB.create_streams'||x_return_status);
8914: END IF;
8915:
8916: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8917: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8918: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8919: raise OKL_API.G_EXCEPTION_ERROR;
8920: END IF;
8921: END IF;

Line 8918: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

8914: END IF;
8915:
8916: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8917: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8918: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8919: raise OKL_API.G_EXCEPTION_ERROR;
8920: END IF;
8921: END IF;
8922:

Line 8919: raise OKL_API.G_EXCEPTION_ERROR;

8915:
8916: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8917: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8918: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8919: raise OKL_API.G_EXCEPTION_ERROR;
8920: END IF;
8921: END IF;
8922:
8923: -- New Disbursement Adjustment = 0

Line 8958: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

8954: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Historizing Existing Investor Disbursement Adjustment Stream');
8955: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After calling OKL_STREAMS_PUB.update_streams'||x_return_status);
8956: END IF;
8957:
8958: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8959: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8960: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8961: raise OKL_API.G_EXCEPTION_ERROR;
8962: END IF;

Line 8959: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

8955: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After calling OKL_STREAMS_PUB.update_streams'||x_return_status);
8956: END IF;
8957:
8958: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8959: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8960: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8961: raise OKL_API.G_EXCEPTION_ERROR;
8962: END IF;
8963: END IF;

Line 8960: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

8956: END IF;
8957:
8958: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8959: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8960: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8961: raise OKL_API.G_EXCEPTION_ERROR;
8962: END IF;
8963: END IF;
8964: END IF;

Line 8961: raise OKL_API.G_EXCEPTION_ERROR;

8957:
8958: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
8959: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
8960: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
8961: raise OKL_API.G_EXCEPTION_ERROR;
8962: END IF;
8963: END IF;
8964: END IF;
8965:

Line 8973: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

8969: END LOOP;
8970:
8971: END IF;
8972:
8973: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
8974: x_msg_data => x_msg_data);
8975:
8976: EXCEPTION
8977: when OKL_API.G_EXCEPTION_ERROR then

Line 8977: when OKL_API.G_EXCEPTION_ERROR then

8973: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
8974: x_msg_data => x_msg_data);
8975:
8976: EXCEPTION
8977: when OKL_API.G_EXCEPTION_ERROR then
8978: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8979: p_api_name => l_api_name,
8980: p_pkg_name => G_PKG_NAME,
8981: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 8978: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

8974: x_msg_data => x_msg_data);
8975:
8976: EXCEPTION
8977: when OKL_API.G_EXCEPTION_ERROR then
8978: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8979: p_api_name => l_api_name,
8980: p_pkg_name => G_PKG_NAME,
8981: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
8982: x_msg_count => x_msg_count,

Line 8981: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

8977: when OKL_API.G_EXCEPTION_ERROR then
8978: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8979: p_api_name => l_api_name,
8980: p_pkg_name => G_PKG_NAME,
8981: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
8982: x_msg_count => x_msg_count,
8983: x_msg_data => x_msg_data,
8984: p_api_type => G_API_TYPE);
8985:

Line 8986: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

8982: x_msg_count => x_msg_count,
8983: x_msg_data => x_msg_data,
8984: p_api_type => G_API_TYPE);
8985:
8986: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
8987: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8988: p_api_name => l_api_name,
8989: p_pkg_name => G_PKG_NAME,
8990: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 8987: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

8983: x_msg_data => x_msg_data,
8984: p_api_type => G_API_TYPE);
8985:
8986: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
8987: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8988: p_api_name => l_api_name,
8989: p_pkg_name => G_PKG_NAME,
8990: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
8991: x_msg_count => x_msg_count,

Line 8990: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

8986: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
8987: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8988: p_api_name => l_api_name,
8989: p_pkg_name => G_PKG_NAME,
8990: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
8991: x_msg_count => x_msg_count,
8992: x_msg_data => x_msg_data,
8993: p_api_type => G_API_TYPE);
8994:

Line 8996: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

8992: x_msg_data => x_msg_data,
8993: p_api_type => G_API_TYPE);
8994:
8995: when OTHERS then
8996: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
8997: p_api_name => l_api_name,
8998: p_pkg_name => G_PKG_NAME,
8999: p_exc_name => 'OTHERS',
9000: x_msg_count => x_msg_count,

Line 9116: x_return_status := OKL_API.G_RET_STS_SUCCESS;

9112: IF (G_DEBUG_ENABLED = 'Y') THEN
9113: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
9114: END IF;
9115:
9116: x_return_status := OKL_API.G_RET_STS_SUCCESS;
9117: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
9118: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
9119: END IF;
9120: -- call START_ACTIVITY to create savepoint, check compatibility

Line 9122: x_return_status := OKL_API.START_ACTIVITY(

9118: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
9119: END IF;
9120: -- call START_ACTIVITY to create savepoint, check compatibility
9121: -- and initialize message list
9122: x_return_status := OKL_API.START_ACTIVITY(
9123: p_api_name => l_api_name,
9124: p_pkg_name => G_PKG_NAME,
9125: p_init_msg_list => p_init_msg_list,
9126: l_api_version => l_api_version,

Line 9132: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

9128: p_api_type => G_API_TYPE,
9129: x_return_status => x_return_status);
9130:
9131: -- check if activity started successfully
9132: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9133: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9134: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9135: raise OKL_API.G_EXCEPTION_ERROR;
9136: END IF;

Line 9133: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

9129: x_return_status => x_return_status);
9130:
9131: -- check if activity started successfully
9132: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9133: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9134: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9135: raise OKL_API.G_EXCEPTION_ERROR;
9136: END IF;
9137:

Line 9134: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

9130:
9131: -- check if activity started successfully
9132: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9133: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9134: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9135: raise OKL_API.G_EXCEPTION_ERROR;
9136: END IF;
9137:
9138: --Bug# 6344223

Line 9135: raise OKL_API.G_EXCEPTION_ERROR;

9131: -- check if activity started successfully
9132: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9133: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9134: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9135: raise OKL_API.G_EXCEPTION_ERROR;
9136: END IF;
9137:
9138: --Bug# 6344223
9139: OPEN check_split_trx_csr;

Line 9209: p_init_msg_list => OKL_API.G_FALSE,

9205:
9206: -- Call Streams api to update Link_Hist_Stream_Id and Trx_Id
9207: okl_streams_pub.update_streams(
9208: p_api_version => 1.0,
9209: p_init_msg_list => OKL_API.G_FALSE,
9210: x_return_status => x_return_status,
9211: x_msg_count => x_msg_count,
9212: x_msg_data => x_msg_data,
9213: p_stmv_tbl => l_new_strm_tbl,

Line 9221: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then

9217: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
9218: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of New Strms - Trx ID and Hist ID '||x_return_status);
9219: END IF;
9220:
9221: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9222: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9223: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9224: raise OKL_API.G_EXCEPTION_ERROR;
9225: END IF;

Line 9222: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

9218: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After Update of New Strms - Trx ID and Hist ID '||x_return_status);
9219: END IF;
9220:
9221: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9222: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9223: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9224: raise OKL_API.G_EXCEPTION_ERROR;
9225: END IF;
9226: END IF;

Line 9223: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then

9219: END IF;
9220:
9221: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9222: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9223: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9224: raise OKL_API.G_EXCEPTION_ERROR;
9225: END IF;
9226: END IF;
9227: END IF;

Line 9224: raise OKL_API.G_EXCEPTION_ERROR;

9220:
9221: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
9222: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9223: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
9224: raise OKL_API.G_EXCEPTION_ERROR;
9225: END IF;
9226: END IF;
9227: END IF;
9228:

Line 9229: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

9225: END IF;
9226: END IF;
9227: END IF;
9228:
9229: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
9230: x_msg_data => x_msg_data);
9231:
9232: EXCEPTION
9233: when OKL_API.G_EXCEPTION_ERROR then

Line 9233: when OKL_API.G_EXCEPTION_ERROR then

9229: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
9230: x_msg_data => x_msg_data);
9231:
9232: EXCEPTION
9233: when OKL_API.G_EXCEPTION_ERROR then
9234: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9235: p_api_name => l_api_name,
9236: p_pkg_name => G_PKG_NAME,
9237: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 9234: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

9230: x_msg_data => x_msg_data);
9231:
9232: EXCEPTION
9233: when OKL_API.G_EXCEPTION_ERROR then
9234: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9235: p_api_name => l_api_name,
9236: p_pkg_name => G_PKG_NAME,
9237: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
9238: x_msg_count => x_msg_count,

Line 9237: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

9233: when OKL_API.G_EXCEPTION_ERROR then
9234: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9235: p_api_name => l_api_name,
9236: p_pkg_name => G_PKG_NAME,
9237: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
9238: x_msg_count => x_msg_count,
9239: x_msg_data => x_msg_data,
9240: p_api_type => G_API_TYPE);
9241:

Line 9242: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

9238: x_msg_count => x_msg_count,
9239: x_msg_data => x_msg_data,
9240: p_api_type => G_API_TYPE);
9241:
9242: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
9243: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9244: p_api_name => l_api_name,
9245: p_pkg_name => G_PKG_NAME,
9246: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 9243: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

9239: x_msg_data => x_msg_data,
9240: p_api_type => G_API_TYPE);
9241:
9242: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
9243: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9244: p_api_name => l_api_name,
9245: p_pkg_name => G_PKG_NAME,
9246: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
9247: x_msg_count => x_msg_count,

Line 9246: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

9242: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
9243: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9244: p_api_name => l_api_name,
9245: p_pkg_name => G_PKG_NAME,
9246: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
9247: x_msg_count => x_msg_count,
9248: x_msg_data => x_msg_data,
9249: p_api_type => G_API_TYPE);
9250:

Line 9252: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

9248: x_msg_data => x_msg_data,
9249: p_api_type => G_API_TYPE);
9250:
9251: when OTHERS then
9252: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9253: p_api_name => l_api_name,
9254: p_pkg_name => G_PKG_NAME,
9255: p_exc_name => 'OTHERS',
9256: x_msg_count => x_msg_count,

Line 9365: x_return_status := OKL_API.G_RET_STS_SUCCESS;

9361: IF (G_DEBUG_ENABLED = 'Y') THEN
9362: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
9363: END IF;
9364:
9365: x_return_status := OKL_API.G_RET_STS_SUCCESS;
9366: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
9367: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
9368: END IF;
9369: -- call START_ACTIVITY to create savepoint, check compatibility

Line 9371: x_return_status := OKL_API.START_ACTIVITY(

9367: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
9368: END IF;
9369: -- call START_ACTIVITY to create savepoint, check compatibility
9370: -- and initialize message list
9371: x_return_status := OKL_API.START_ACTIVITY(
9372: p_api_name => l_api_name,
9373: p_pkg_name => G_PKG_NAME,
9374: p_init_msg_list => p_init_msg_list,
9375: l_api_version => l_api_version,

Line 9381: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

9377: p_api_type => G_API_TYPE,
9378: x_return_status => x_return_status);
9379:
9380: -- check if activity started successfully
9381: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9382: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9383: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9384: RAISE OKL_API.G_EXCEPTION_ERROR;
9385: END IF;

Line 9382: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

9378: x_return_status => x_return_status);
9379:
9380: -- check if activity started successfully
9381: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9382: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9383: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9384: RAISE OKL_API.G_EXCEPTION_ERROR;
9385: END IF;
9386:

Line 9383: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

9379:
9380: -- check if activity started successfully
9381: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9382: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9383: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9384: RAISE OKL_API.G_EXCEPTION_ERROR;
9385: END IF;
9386:
9387: -- For On-line and Mass rebook, calculate accrual adjustment

Line 9384: RAISE OKL_API.G_EXCEPTION_ERROR;

9380: -- check if activity started successfully
9381: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9382: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9383: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9384: RAISE OKL_API.G_EXCEPTION_ERROR;
9385: END IF;
9386:
9387: -- For On-line and Mass rebook, calculate accrual adjustment
9388: -- for all Current Accrual Streams for which Accruals were generated

Line 9467: p_init_msg_list => OKL_API.G_FALSE,

9463:
9464: IF (l_selv_tbl.COUNT > 0) THEN
9465: okl_streams_pub.update_stream_elements(
9466: p_api_version => 1.0,
9467: p_init_msg_list => OKL_API.G_FALSE,
9468: x_return_status => x_return_status,
9469: x_msg_count => x_msg_count,
9470: x_msg_data => x_msg_data,
9471: p_selv_tbl => l_selv_tbl,

Line 9479: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

9475: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
9476: 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);
9477: END IF;
9478:
9479: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9480: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9481: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9482: RAISE OKL_API.G_EXCEPTION_ERROR;
9483: END IF;

Line 9480: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

9476: 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);
9477: END IF;
9478:
9479: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9480: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9481: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9482: RAISE OKL_API.G_EXCEPTION_ERROR;
9483: END IF;
9484: END IF;

Line 9481: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

9477: END IF;
9478:
9479: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9480: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9481: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9482: RAISE OKL_API.G_EXCEPTION_ERROR;
9483: END IF;
9484: END IF;
9485:

Line 9482: RAISE OKL_API.G_EXCEPTION_ERROR;

9478:
9479: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
9480: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
9481: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
9482: RAISE OKL_API.G_EXCEPTION_ERROR;
9483: END IF;
9484: END IF;
9485:
9486: END IF;

Line 9520: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

9516: x_inv_stream_tbl := l_stream_tbl;
9517: x_inv_accrual_rec := l_accrual_rec;
9518: END IF;
9519:
9520: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
9521: x_msg_data => x_msg_data);
9522:
9523: EXCEPTION
9524: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 9524: WHEN OKL_API.G_EXCEPTION_ERROR THEN

9520: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
9521: x_msg_data => x_msg_data);
9522:
9523: EXCEPTION
9524: WHEN OKL_API.G_EXCEPTION_ERROR THEN
9525: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9526: p_api_name => l_api_name,
9527: p_pkg_name => G_PKG_NAME,
9528: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 9525: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

9521: x_msg_data => x_msg_data);
9522:
9523: EXCEPTION
9524: WHEN OKL_API.G_EXCEPTION_ERROR THEN
9525: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9526: p_api_name => l_api_name,
9527: p_pkg_name => G_PKG_NAME,
9528: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
9529: x_msg_count => x_msg_count,

Line 9528: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

9524: WHEN OKL_API.G_EXCEPTION_ERROR THEN
9525: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9526: p_api_name => l_api_name,
9527: p_pkg_name => G_PKG_NAME,
9528: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
9529: x_msg_count => x_msg_count,
9530: x_msg_data => x_msg_data,
9531: p_api_type => G_API_TYPE);
9532:

Line 9533: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

9529: x_msg_count => x_msg_count,
9530: x_msg_data => x_msg_data,
9531: p_api_type => G_API_TYPE);
9532:
9533: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
9534: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9535: p_api_name => l_api_name,
9536: p_pkg_name => G_PKG_NAME,
9537: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 9534: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

9530: x_msg_data => x_msg_data,
9531: p_api_type => G_API_TYPE);
9532:
9533: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
9534: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9535: p_api_name => l_api_name,
9536: p_pkg_name => G_PKG_NAME,
9537: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
9538: x_msg_count => x_msg_count,

Line 9537: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

9533: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
9534: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9535: p_api_name => l_api_name,
9536: p_pkg_name => G_PKG_NAME,
9537: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
9538: x_msg_count => x_msg_count,
9539: x_msg_data => x_msg_data,
9540: p_api_type => G_API_TYPE);
9541:

Line 9543: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

9539: x_msg_data => x_msg_data,
9540: p_api_type => G_API_TYPE);
9541:
9542: WHEN OTHERS THEN
9543: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
9544: p_api_name => l_api_name,
9545: p_pkg_name => G_PKG_NAME,
9546: p_exc_name => 'OTHERS',
9547: x_msg_count => x_msg_count,