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 735: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

731: -------------------------------------------------------------------------------------------------
732:
733: Procedure generate_asset_summary(
734: p_api_version IN NUMBER,
735: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
736: x_return_status OUT NOCOPY VARCHAR2,
737: x_msg_count OUT NOCOPY NUMBER,
738: x_msg_data OUT NOCOPY VARCHAR2,
739: p_las_rec IN las_rec_type,

Line 2785: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2781: -- Version : 1.0
2782: -- End of comments
2783: PROCEDURE update_contract_line(
2784: p_api_version IN NUMBER,
2785: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2786: x_return_status OUT NOCOPY VARCHAR2,
2787: x_msg_count OUT NOCOPY NUMBER,
2788: x_msg_data OUT NOCOPY VARCHAR2,
2789: p_id IN NUMBER,

Line 2812: x_return_status := OKC_API.START_ACTIVITY(

2808: OKL_CONTEXT.SET_OKL_ORG_CONTEXT(
2809: p_org_id => p_org_id,
2810: p_organization_id => p_organization_id);
2811: */
2812: x_return_status := OKC_API.START_ACTIVITY(
2813: p_api_name => l_api_name,
2814: p_pkg_name => g_pkg_name,
2815: p_init_msg_list => p_init_msg_list,
2816: l_api_version => l_api_version,

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

2818: p_api_type => g_api_type,
2819: x_return_status => x_return_status);
2820:
2821: -- check if activity started successfully
2822: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2823: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2824: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2825: RAISE OKC_API.G_EXCEPTION_ERROR;
2826: END IF;

Line 2823: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2819: x_return_status => x_return_status);
2820:
2821: -- check if activity started successfully
2822: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2823: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2824: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2825: RAISE OKC_API.G_EXCEPTION_ERROR;
2826: END IF;
2827:

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

2820:
2821: -- check if activity started successfully
2822: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2823: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2824: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2825: RAISE OKC_API.G_EXCEPTION_ERROR;
2826: END IF;
2827:
2828: lp_clev_rec.id := p_id;

Line 2825: RAISE OKC_API.G_EXCEPTION_ERROR;

2821: -- check if activity started successfully
2822: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2823: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2824: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2825: RAISE OKC_API.G_EXCEPTION_ERROR;
2826: END IF;
2827:
2828: lp_clev_rec.id := p_id;
2829: lp_klev_rec.id := p_id;

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

2841: p_edit_mode => 'N',
2842: x_clev_rec => lx_clev_rec,
2843: x_klev_rec => lx_klev_rec);
2844:
2845: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2846: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2847: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2848: RAISE OKC_API.G_EXCEPTION_ERROR;
2849: END IF;

Line 2846: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2842: x_clev_rec => lx_clev_rec,
2843: x_klev_rec => lx_klev_rec);
2844:
2845: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2846: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2847: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2848: RAISE OKC_API.G_EXCEPTION_ERROR;
2849: END IF;
2850:

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

2843: x_klev_rec => lx_klev_rec);
2844:
2845: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2846: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2847: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2848: RAISE OKC_API.G_EXCEPTION_ERROR;
2849: END IF;
2850:
2851: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

Line 2848: RAISE OKC_API.G_EXCEPTION_ERROR;

2844:
2845: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2846: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2847: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2848: RAISE OKC_API.G_EXCEPTION_ERROR;
2849: END IF;
2850:
2851: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2852: x_msg_data => x_msg_data);

Line 2892: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

2888: -- Version : 1.0
2889: -- End of comments
2890: PROCEDURE update_contract_line(
2891: p_api_version IN NUMBER,
2892: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
2893: x_return_status OUT NOCOPY VARCHAR2,
2894: x_msg_count OUT NOCOPY NUMBER,
2895: x_msg_data OUT NOCOPY VARCHAR2,
2896: p_id IN NUMBER,

Line 2932: x_return_status := OKC_API.START_ACTIVITY(

2928: OKL_CONTEXT.SET_OKL_ORG_CONTEXT(
2929: p_org_id => p_org_id,
2930: p_organization_id => p_organization_id);
2931: */
2932: x_return_status := OKC_API.START_ACTIVITY(
2933: p_api_name => l_api_name,
2934: p_pkg_name => g_pkg_name,
2935: p_init_msg_list => p_init_msg_list,
2936: l_api_version => l_api_version,

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

2938: p_api_type => g_api_type,
2939: x_return_status => x_return_status);
2940:
2941: -- check if activity started successfully
2942: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2943: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2944: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2945: RAISE OKC_API.G_EXCEPTION_ERROR;
2946: END IF;

Line 2943: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2939: x_return_status => x_return_status);
2940:
2941: -- check if activity started successfully
2942: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2943: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2944: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2945: RAISE OKC_API.G_EXCEPTION_ERROR;
2946: END IF;
2947:

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

2940:
2941: -- check if activity started successfully
2942: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2943: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2944: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2945: RAISE OKC_API.G_EXCEPTION_ERROR;
2946: END IF;
2947:
2948: lp_clev_rec.id := p_id;

Line 2945: RAISE OKC_API.G_EXCEPTION_ERROR;

2941: -- check if activity started successfully
2942: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2943: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2944: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2945: RAISE OKC_API.G_EXCEPTION_ERROR;
2946: END IF;
2947:
2948: lp_clev_rec.id := p_id;
2949: lp_klev_rec.id := p_id;

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

2963: p_edit_mode => 'N',
2964: x_clev_rec => lx_clev_rec,
2965: x_klev_rec => lx_klev_rec);
2966:
2967: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2968: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2969: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2970: RAISE OKC_API.G_EXCEPTION_ERROR;
2971: END IF;

Line 2968: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2964: x_clev_rec => lx_clev_rec,
2965: x_klev_rec => lx_klev_rec);
2966:
2967: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2968: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2969: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2970: RAISE OKC_API.G_EXCEPTION_ERROR;
2971: END IF;
2972:

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

2965: x_klev_rec => lx_klev_rec);
2966:
2967: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2968: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2969: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2970: RAISE OKC_API.G_EXCEPTION_ERROR;
2971: END IF;
2972:
2973:

Line 2970: RAISE OKC_API.G_EXCEPTION_ERROR;

2966:
2967: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2968: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2969: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2970: RAISE OKC_API.G_EXCEPTION_ERROR;
2971: END IF;
2972:
2973:
2974: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

Line 3015: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3011: -- Version : 1.0
3012: -- End of comments
3013: PROCEDURE update_fin_cap_cost(
3014: p_api_version IN NUMBER,
3015: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3016: x_return_status OUT NOCOPY VARCHAR2,
3017: x_msg_count OUT NOCOPY NUMBER,
3018: x_msg_data OUT NOCOPY VARCHAR2,
3019: P_new_yn IN VARCHAR2,

Line 3051: x_return_status := OKC_API.START_ACTIVITY(

3047: OKL_CONTEXT.SET_OKL_ORG_CONTEXT(
3048: p_org_id => p_org_id,
3049: p_organization_id => p_organization_id);
3050: */
3051: x_return_status := OKC_API.START_ACTIVITY(
3052: p_api_name => l_api_name,
3053: p_pkg_name => g_pkg_name,
3054: p_init_msg_list => p_init_msg_list,
3055: l_api_version => l_api_version,

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

3057: p_api_type => g_api_type,
3058: x_return_status => x_return_status);
3059:
3060: -- check if activity started successfully
3061: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3062: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3063: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3064: RAISE OKC_API.G_EXCEPTION_ERROR;
3065: END IF;

Line 3062: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3058: x_return_status => x_return_status);
3059:
3060: -- check if activity started successfully
3061: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3062: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3063: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3064: RAISE OKC_API.G_EXCEPTION_ERROR;
3065: END IF;
3066:

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

3059:
3060: -- check if activity started successfully
3061: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3062: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3063: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3064: RAISE OKC_API.G_EXCEPTION_ERROR;
3065: END IF;
3066:
3067: lp_clev_rec.id := p_top_line_id;

Line 3064: RAISE OKC_API.G_EXCEPTION_ERROR;

3060: -- check if activity started successfully
3061: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3062: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3063: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3064: RAISE OKC_API.G_EXCEPTION_ERROR;
3065: END IF;
3066:
3067: lp_clev_rec.id := p_top_line_id;
3068: lp_clev_rec.line_number := '1';

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

3085:
3086: IF((p_down_payment_receiver IS NOT NULL) AND
3087: (p_down_payment_receiver = 'VENDOR' OR p_down_payment_receiver = 'LESSOR')) THEN
3088: IF(p_cap_down_pay_yn IS NOT NULL AND p_cap_down_pay_yn = 'N' AND p_down_payment_receiver = 'VENDOR') THEN
3089: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
3090: p_msg_name => 'OKL_INVALID_COMBINATION');
3091: x_return_status := OKC_API.g_ret_sts_error;
3092: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3093: END IF;

Line 3091: x_return_status := OKC_API.g_ret_sts_error;

3087: (p_down_payment_receiver = 'VENDOR' OR p_down_payment_receiver = 'LESSOR')) THEN
3088: IF(p_cap_down_pay_yn IS NOT NULL AND p_cap_down_pay_yn = 'N' AND p_down_payment_receiver = 'VENDOR') THEN
3089: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
3090: p_msg_name => 'OKL_INVALID_COMBINATION');
3091: x_return_status := OKC_API.g_ret_sts_error;
3092: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3093: END IF;
3094: END IF;
3095:

Line 3092: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3088: IF(p_cap_down_pay_yn IS NOT NULL AND p_cap_down_pay_yn = 'N' AND p_down_payment_receiver = 'VENDOR') THEN
3089: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
3090: p_msg_name => 'OKL_INVALID_COMBINATION');
3091: x_return_status := OKC_API.g_ret_sts_error;
3092: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3093: END IF;
3094: END IF;
3095:
3096: OKL_CREATE_KLE_PUB.update_fin_cap_cost(

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

3105: p_klev_rec => lp_klev_rec,
3106: x_clev_rec => lx_clev_rec,
3107: x_klev_rec => lx_klev_rec);
3108:
3109: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3111: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3112: RAISE OKC_API.G_EXCEPTION_ERROR;
3113: END IF;

Line 3110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3106: x_clev_rec => lx_clev_rec,
3107: x_klev_rec => lx_klev_rec);
3108:
3109: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3111: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3112: RAISE OKC_API.G_EXCEPTION_ERROR;
3113: END IF;
3114:

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

3107: x_klev_rec => lx_klev_rec);
3108:
3109: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3111: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3112: RAISE OKC_API.G_EXCEPTION_ERROR;
3113: END IF;
3114:
3115: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

Line 3112: RAISE OKC_API.G_EXCEPTION_ERROR;

3108:
3109: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3110: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3111: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3112: RAISE OKC_API.G_EXCEPTION_ERROR;
3113: END IF;
3114:
3115: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
3116:

Line 3148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

3144: END;
3145:
3146: PROCEDURE update_fin_cap_cost(
3147: p_api_version IN NUMBER,
3148: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
3149: x_return_status OUT NOCOPY VARCHAR2,
3150: x_msg_count OUT NOCOPY NUMBER,
3151: x_msg_data OUT NOCOPY VARCHAR2,
3152: p_fin_adj_tbl IN fin_adj_tbl_type

Line 3162: x_return_status := OKC_API.START_ACTIVITY(

3158: lp_asset_number VARCHAR2(50);
3159: lp_new_yn VARCHAR2(10);
3160:
3161: BEGIN
3162: x_return_status := OKC_API.START_ACTIVITY(
3163: p_api_name => l_api_name,
3164: p_pkg_name => g_pkg_name,
3165: p_init_msg_list => p_init_msg_list,
3166: l_api_version => l_api_version,

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

3168: p_api_type => g_api_type,
3169: x_return_status => x_return_status);
3170:
3171: -- check if activity started successfully
3172: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3173: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3174: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3175: RAISE OKC_API.G_EXCEPTION_ERROR;
3176: END IF;

Line 3173: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3169: x_return_status => x_return_status);
3170:
3171: -- check if activity started successfully
3172: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3173: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3174: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3175: RAISE OKC_API.G_EXCEPTION_ERROR;
3176: END IF;
3177:

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

3170:
3171: -- check if activity started successfully
3172: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3173: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3174: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3175: RAISE OKC_API.G_EXCEPTION_ERROR;
3176: END IF;
3177:
3178: FOR l_fin_adj_rec_index IN p_fin_adj_tbl.FIRST .. p_fin_adj_tbl.LAST

Line 3175: RAISE OKC_API.G_EXCEPTION_ERROR;

3171: -- check if activity started successfully
3172: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3173: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3174: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3175: RAISE OKC_API.G_EXCEPTION_ERROR;
3176: END IF;
3177:
3178: FOR l_fin_adj_rec_index IN p_fin_adj_tbl.FIRST .. p_fin_adj_tbl.LAST
3179: LOOP

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

3186:
3187: IF((l_fin_adj_rec.p_down_payment_receiver IS NOT NULL) AND
3188: (l_fin_adj_rec.p_down_payment_receiver = 'VENDOR' OR l_fin_adj_rec.p_down_payment_receiver = 'LESSOR')) THEN
3189: 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
3190: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
3191: p_msg_name => 'OKL_INVALID_COMBINATION');
3192: x_return_status := OKC_API.g_ret_sts_error;
3193: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3194: END IF;

Line 3192: x_return_status := OKC_API.g_ret_sts_error;

3188: (l_fin_adj_rec.p_down_payment_receiver = 'VENDOR' OR l_fin_adj_rec.p_down_payment_receiver = 'LESSOR')) THEN
3189: 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
3190: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
3191: p_msg_name => 'OKL_INVALID_COMBINATION');
3192: x_return_status := OKC_API.g_ret_sts_error;
3193: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3194: END IF;
3195: END IF;
3196:

Line 3193: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3189: 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
3190: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
3191: p_msg_name => 'OKL_INVALID_COMBINATION');
3192: x_return_status := OKC_API.g_ret_sts_error;
3193: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3194: END IF;
3195: END IF;
3196:
3197: update_fin_cap_cost(

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

3209: p_oec => l_fin_adj_rec.p_oec,
3210: p_cap_down_pay_yn => l_fin_adj_rec.p_cap_down_pay_yn,
3211: p_down_payment_receiver => l_fin_adj_rec.p_down_payment_receiver);
3212:
3213: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3214: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3215: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3216: RAISE OKC_API.G_EXCEPTION_ERROR;
3217: END IF;

Line 3214: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

3210: p_cap_down_pay_yn => l_fin_adj_rec.p_cap_down_pay_yn,
3211: p_down_payment_receiver => l_fin_adj_rec.p_down_payment_receiver);
3212:
3213: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3214: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3215: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3216: RAISE OKC_API.G_EXCEPTION_ERROR;
3217: END IF;
3218:

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

3211: p_down_payment_receiver => l_fin_adj_rec.p_down_payment_receiver);
3212:
3213: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3214: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3215: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3216: RAISE OKC_API.G_EXCEPTION_ERROR;
3217: END IF;
3218:
3219: END LOOP;

Line 3216: RAISE OKC_API.G_EXCEPTION_ERROR;

3212:
3213: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3214: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
3215: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
3216: RAISE OKC_API.G_EXCEPTION_ERROR;
3217: END IF;
3218:
3219: END LOOP;
3220: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);