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

Line 707: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

703: -------------------------------------------------------------------------------------------------
704:
705: Procedure generate_asset_summary(
706: p_api_version IN NUMBER,
707: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
708: x_return_status OUT NOCOPY VARCHAR2,
709: x_msg_count OUT NOCOPY NUMBER,
710: x_msg_data OUT NOCOPY VARCHAR2,
711: p_las_rec IN las_rec_type,

Line 2757: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2753: -- Version : 1.0
2754: -- End of comments
2755: PROCEDURE update_contract_line(
2756: p_api_version IN NUMBER,
2757: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2758: x_return_status OUT NOCOPY VARCHAR2,
2759: x_msg_count OUT NOCOPY NUMBER,
2760: x_msg_data OUT NOCOPY VARCHAR2,
2761: p_id IN NUMBER,

Line 2784: x_return_status := OKC_API.START_ACTIVITY(

2780: OKL_CONTEXT.SET_OKL_ORG_CONTEXT(
2781: p_org_id => p_org_id,
2782: p_organization_id => p_organization_id);
2783: */
2784: x_return_status := OKC_API.START_ACTIVITY(
2785: p_api_name => l_api_name,
2786: p_pkg_name => g_pkg_name,
2787: p_init_msg_list => p_init_msg_list,
2788: l_api_version => l_api_version,

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

2790: p_api_type => g_api_type,
2791: x_return_status => x_return_status);
2792:
2793: -- check if activity started successfully
2794: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2795: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2796: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2797: RAISE OKC_API.G_EXCEPTION_ERROR;
2798: END IF;

Line 2795: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2791: x_return_status => x_return_status);
2792:
2793: -- check if activity started successfully
2794: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2795: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2796: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2797: RAISE OKC_API.G_EXCEPTION_ERROR;
2798: END IF;
2799:

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

2792:
2793: -- check if activity started successfully
2794: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2795: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2796: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2797: RAISE OKC_API.G_EXCEPTION_ERROR;
2798: END IF;
2799:
2800: lp_clev_rec.id := p_id;

Line 2797: RAISE OKC_API.G_EXCEPTION_ERROR;

2793: -- check if activity started successfully
2794: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2795: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2796: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2797: RAISE OKC_API.G_EXCEPTION_ERROR;
2798: END IF;
2799:
2800: lp_clev_rec.id := p_id;
2801: lp_klev_rec.id := p_id;

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

2813: p_edit_mode => 'N',
2814: x_clev_rec => lx_clev_rec,
2815: x_klev_rec => lx_klev_rec);
2816:
2817: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2818: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2819: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2820: RAISE OKC_API.G_EXCEPTION_ERROR;
2821: END IF;

Line 2818: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2814: x_clev_rec => lx_clev_rec,
2815: x_klev_rec => lx_klev_rec);
2816:
2817: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2818: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2819: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2820: RAISE OKC_API.G_EXCEPTION_ERROR;
2821: END IF;
2822:

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

2815: x_klev_rec => lx_klev_rec);
2816:
2817: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2818: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2819: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2820: RAISE OKC_API.G_EXCEPTION_ERROR;
2821: END IF;
2822:
2823: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 2820: RAISE OKC_API.G_EXCEPTION_ERROR;

2816:
2817: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2818: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2819: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2820: RAISE OKC_API.G_EXCEPTION_ERROR;
2821: END IF;
2822:
2823: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2824: x_msg_data => x_msg_data);

Line 2864: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2860: -- Version : 1.0
2861: -- End of comments
2862: PROCEDURE update_contract_line(
2863: p_api_version IN NUMBER,
2864: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2865: x_return_status OUT NOCOPY VARCHAR2,
2866: x_msg_count OUT NOCOPY NUMBER,
2867: x_msg_data OUT NOCOPY VARCHAR2,
2868: p_id IN NUMBER,

Line 2904: x_return_status := OKC_API.START_ACTIVITY(

2900: OKL_CONTEXT.SET_OKL_ORG_CONTEXT(
2901: p_org_id => p_org_id,
2902: p_organization_id => p_organization_id);
2903: */
2904: x_return_status := OKC_API.START_ACTIVITY(
2905: p_api_name => l_api_name,
2906: p_pkg_name => g_pkg_name,
2907: p_init_msg_list => p_init_msg_list,
2908: l_api_version => l_api_version,

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

2910: p_api_type => g_api_type,
2911: x_return_status => x_return_status);
2912:
2913: -- check if activity started successfully
2914: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2915: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2916: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2917: RAISE OKC_API.G_EXCEPTION_ERROR;
2918: END IF;

Line 2915: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2911: x_return_status => x_return_status);
2912:
2913: -- check if activity started successfully
2914: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2915: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2916: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2917: RAISE OKC_API.G_EXCEPTION_ERROR;
2918: END IF;
2919:

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

2912:
2913: -- check if activity started successfully
2914: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2915: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2916: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2917: RAISE OKC_API.G_EXCEPTION_ERROR;
2918: END IF;
2919:
2920: lp_clev_rec.id := p_id;

Line 2917: RAISE OKC_API.G_EXCEPTION_ERROR;

2913: -- check if activity started successfully
2914: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2915: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2916: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2917: RAISE OKC_API.G_EXCEPTION_ERROR;
2918: END IF;
2919:
2920: lp_clev_rec.id := p_id;
2921: lp_klev_rec.id := p_id;

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

2935: p_edit_mode => 'N',
2936: x_clev_rec => lx_clev_rec,
2937: x_klev_rec => lx_klev_rec);
2938:
2939: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2940: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2941: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2942: RAISE OKC_API.G_EXCEPTION_ERROR;
2943: END IF;

Line 2940: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2936: x_clev_rec => lx_clev_rec,
2937: x_klev_rec => lx_klev_rec);
2938:
2939: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2940: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2941: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2942: RAISE OKC_API.G_EXCEPTION_ERROR;
2943: END IF;
2944:

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

2937: x_klev_rec => lx_klev_rec);
2938:
2939: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2940: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2941: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2942: RAISE OKC_API.G_EXCEPTION_ERROR;
2943: END IF;
2944:
2945:

Line 2942: RAISE OKC_API.G_EXCEPTION_ERROR;

2938:
2939: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2940: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2941: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2942: RAISE OKC_API.G_EXCEPTION_ERROR;
2943: END IF;
2944:
2945:
2946: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

Line 2987: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2983: -- Version : 1.0
2984: -- End of comments
2985: PROCEDURE update_fin_cap_cost(
2986: p_api_version IN NUMBER,
2987: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2988: x_return_status OUT NOCOPY VARCHAR2,
2989: x_msg_count OUT NOCOPY NUMBER,
2990: x_msg_data OUT NOCOPY VARCHAR2,
2991: P_new_yn IN VARCHAR2,

Line 3023: x_return_status := OKC_API.START_ACTIVITY(

3019: OKL_CONTEXT.SET_OKL_ORG_CONTEXT(
3020: p_org_id => p_org_id,
3021: p_organization_id => p_organization_id);
3022: */
3023: x_return_status := OKC_API.START_ACTIVITY(
3024: p_api_name => l_api_name,
3025: p_pkg_name => g_pkg_name,
3026: p_init_msg_list => p_init_msg_list,
3027: l_api_version => l_api_version,

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

3029: p_api_type => g_api_type,
3030: x_return_status => x_return_status);
3031:
3032: -- check if activity started successfully
3033: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3034: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3035: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3036: RAISE OKC_API.G_EXCEPTION_ERROR;
3037: END IF;

Line 3034: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3030: x_return_status => x_return_status);
3031:
3032: -- check if activity started successfully
3033: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3034: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3035: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3036: RAISE OKC_API.G_EXCEPTION_ERROR;
3037: END IF;
3038:

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

3031:
3032: -- check if activity started successfully
3033: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3034: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3035: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3036: RAISE OKC_API.G_EXCEPTION_ERROR;
3037: END IF;
3038:
3039: lp_clev_rec.id := p_top_line_id;

Line 3036: RAISE OKC_API.G_EXCEPTION_ERROR;

3032: -- check if activity started successfully
3033: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3034: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3035: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3036: RAISE OKC_API.G_EXCEPTION_ERROR;
3037: END IF;
3038:
3039: lp_clev_rec.id := p_top_line_id;
3040: lp_clev_rec.line_number := '1';

Line 3061: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

3057:
3058: IF((p_down_payment_receiver IS NOT NULL) AND
3059: (p_down_payment_receiver = 'VENDOR' OR p_down_payment_receiver = 'LESSOR')) THEN
3060: IF(p_cap_down_pay_yn IS NOT NULL AND p_cap_down_pay_yn = 'N' AND p_down_payment_receiver = 'VENDOR') THEN
3061: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
3062: p_msg_name => 'OKL_INVALID_COMBINATION');
3063: x_return_status := OKC_API.g_ret_sts_error;
3064: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3065: END IF;

Line 3063: x_return_status := OKC_API.g_ret_sts_error;

3059: (p_down_payment_receiver = 'VENDOR' OR p_down_payment_receiver = 'LESSOR')) THEN
3060: IF(p_cap_down_pay_yn IS NOT NULL AND p_cap_down_pay_yn = 'N' AND p_down_payment_receiver = 'VENDOR') THEN
3061: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
3062: p_msg_name => 'OKL_INVALID_COMBINATION');
3063: x_return_status := OKC_API.g_ret_sts_error;
3064: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3065: END IF;
3066: END IF;
3067:

Line 3064: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3060: IF(p_cap_down_pay_yn IS NOT NULL AND p_cap_down_pay_yn = 'N' AND p_down_payment_receiver = 'VENDOR') THEN
3061: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
3062: p_msg_name => 'OKL_INVALID_COMBINATION');
3063: x_return_status := OKC_API.g_ret_sts_error;
3064: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3065: END IF;
3066: END IF;
3067:
3068: OKL_CREATE_KLE_PUB.update_fin_cap_cost(

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

3077: p_klev_rec => lp_klev_rec,
3078: x_clev_rec => lx_clev_rec,
3079: x_klev_rec => lx_klev_rec);
3080:
3081: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3082: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3083: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3084: RAISE OKC_API.G_EXCEPTION_ERROR;
3085: END IF;

Line 3082: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3078: x_clev_rec => lx_clev_rec,
3079: x_klev_rec => lx_klev_rec);
3080:
3081: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3082: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3083: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3084: RAISE OKC_API.G_EXCEPTION_ERROR;
3085: END IF;
3086:

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

3079: x_klev_rec => lx_klev_rec);
3080:
3081: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3082: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3083: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3084: RAISE OKC_API.G_EXCEPTION_ERROR;
3085: END IF;
3086:
3087: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

Line 3084: RAISE OKC_API.G_EXCEPTION_ERROR;

3080:
3081: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3082: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3083: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3084: RAISE OKC_API.G_EXCEPTION_ERROR;
3085: END IF;
3086:
3087: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
3088:

Line 3120: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3116: END;
3117:
3118: PROCEDURE update_fin_cap_cost(
3119: p_api_version IN NUMBER,
3120: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3121: x_return_status OUT NOCOPY VARCHAR2,
3122: x_msg_count OUT NOCOPY NUMBER,
3123: x_msg_data OUT NOCOPY VARCHAR2,
3124: p_fin_adj_tbl IN fin_adj_tbl_type

Line 3134: x_return_status := OKC_API.START_ACTIVITY(

3130: lp_asset_number VARCHAR2(50);
3131: lp_new_yn VARCHAR2(10);
3132:
3133: BEGIN
3134: x_return_status := OKC_API.START_ACTIVITY(
3135: p_api_name => l_api_name,
3136: p_pkg_name => g_pkg_name,
3137: p_init_msg_list => p_init_msg_list,
3138: l_api_version => l_api_version,

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

3140: p_api_type => g_api_type,
3141: x_return_status => x_return_status);
3142:
3143: -- check if activity started successfully
3144: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3145: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3146: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3147: RAISE OKC_API.G_EXCEPTION_ERROR;
3148: END IF;

Line 3145: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3141: x_return_status => x_return_status);
3142:
3143: -- check if activity started successfully
3144: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3145: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3146: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3147: RAISE OKC_API.G_EXCEPTION_ERROR;
3148: END IF;
3149:

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

3142:
3143: -- check if activity started successfully
3144: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3145: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3146: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3147: RAISE OKC_API.G_EXCEPTION_ERROR;
3148: END IF;
3149:
3150: FOR l_fin_adj_rec_index IN p_fin_adj_tbl.FIRST .. p_fin_adj_tbl.LAST

Line 3147: RAISE OKC_API.G_EXCEPTION_ERROR;

3143: -- check if activity started successfully
3144: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3145: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3146: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3147: RAISE OKC_API.G_EXCEPTION_ERROR;
3148: END IF;
3149:
3150: FOR l_fin_adj_rec_index IN p_fin_adj_tbl.FIRST .. p_fin_adj_tbl.LAST
3151: LOOP

Line 3162: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

3158:
3159: IF((l_fin_adj_rec.p_down_payment_receiver IS NOT NULL) AND
3160: (l_fin_adj_rec.p_down_payment_receiver = 'VENDOR' OR l_fin_adj_rec.p_down_payment_receiver = 'LESSOR')) THEN
3161: IF(l_fin_adj_rec.p_cap_down_pay_yn IS NOT NULL AND l_fin_adj_rec.p_cap_down_pay_yn = 'N' AND l_fin_adj_rec.p_down_payment_receiver = 'VENDOR') THEN
3162: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
3163: p_msg_name => 'OKL_INVALID_COMBINATION');
3164: x_return_status := OKC_API.g_ret_sts_error;
3165: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3166: END IF;

Line 3164: x_return_status := OKC_API.g_ret_sts_error;

3160: (l_fin_adj_rec.p_down_payment_receiver = 'VENDOR' OR l_fin_adj_rec.p_down_payment_receiver = 'LESSOR')) THEN
3161: IF(l_fin_adj_rec.p_cap_down_pay_yn IS NOT NULL AND l_fin_adj_rec.p_cap_down_pay_yn = 'N' AND l_fin_adj_rec.p_down_payment_receiver = 'VENDOR') THEN
3162: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
3163: p_msg_name => 'OKL_INVALID_COMBINATION');
3164: x_return_status := OKC_API.g_ret_sts_error;
3165: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3166: END IF;
3167: END IF;
3168:

Line 3165: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3161: IF(l_fin_adj_rec.p_cap_down_pay_yn IS NOT NULL AND l_fin_adj_rec.p_cap_down_pay_yn = 'N' AND l_fin_adj_rec.p_down_payment_receiver = 'VENDOR') THEN
3162: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
3163: p_msg_name => 'OKL_INVALID_COMBINATION');
3164: x_return_status := OKC_API.g_ret_sts_error;
3165: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3166: END IF;
3167: END IF;
3168:
3169: update_fin_cap_cost(

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

3181: p_oec => l_fin_adj_rec.p_oec,
3182: p_cap_down_pay_yn => l_fin_adj_rec.p_cap_down_pay_yn,
3183: p_down_payment_receiver => l_fin_adj_rec.p_down_payment_receiver);
3184:
3185: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3186: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3187: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3188: RAISE OKC_API.G_EXCEPTION_ERROR;
3189: END IF;

Line 3186: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3182: p_cap_down_pay_yn => l_fin_adj_rec.p_cap_down_pay_yn,
3183: p_down_payment_receiver => l_fin_adj_rec.p_down_payment_receiver);
3184:
3185: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3186: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3187: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3188: RAISE OKC_API.G_EXCEPTION_ERROR;
3189: END IF;
3190:

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

3183: p_down_payment_receiver => l_fin_adj_rec.p_down_payment_receiver);
3184:
3185: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3186: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3187: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3188: RAISE OKC_API.G_EXCEPTION_ERROR;
3189: END IF;
3190:
3191: END LOOP;

Line 3188: RAISE OKC_API.G_EXCEPTION_ERROR;

3184:
3185: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3186: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3187: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3188: RAISE OKC_API.G_EXCEPTION_ERROR;
3189: END IF;
3190:
3191: END LOOP;
3192: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);