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_CREDIT_DATAPOINTS_PVT dependencies on OKL_API

Line 2248: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_EXTENDS_K_END');

2244:
2245: l_contract_end_date := ADD_MONTHS(p_level_start_date, p_contract_term) - 1;
2246:
2247: IF l_end_date > l_contract_end_date THEN
2248: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_EXTENDS_K_END');
2249: RAISE OKL_API.G_EXCEPTION_ERROR;
2250: END IF;
2251:
2252: x_return_status := G_RET_STS_SUCCESS;

Line 2249: RAISE OKL_API.G_EXCEPTION_ERROR;

2245: l_contract_end_date := ADD_MONTHS(p_level_start_date, p_contract_term) - 1;
2246:
2247: IF l_end_date > l_contract_end_date THEN
2248: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_EXTENDS_K_END');
2249: RAISE OKL_API.G_EXCEPTION_ERROR;
2250: END IF;
2251:
2252: x_return_status := G_RET_STS_SUCCESS;
2253:

Line 2256: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2252: x_return_status := G_RET_STS_SUCCESS;
2253:
2254: EXCEPTION
2255:
2256: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2257: x_return_status := G_RET_STS_ERROR;
2258:
2259: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2260: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 2259: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2255:
2256: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2257: x_return_status := G_RET_STS_ERROR;
2258:
2259: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2260: x_return_status := G_RET_STS_UNEXP_ERROR;
2261:
2262: WHEN OTHERS THEN
2263: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 2263: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

2259: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2260: x_return_status := G_RET_STS_UNEXP_ERROR;
2261:
2262: WHEN OTHERS THEN
2263: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
2264: p_msg_name => G_DB_ERROR,
2265: p_token1 => G_PROG_NAME_TOKEN,
2266: p_token1_value => l_api_name,
2267: p_token2 => G_SQLCODE_TOKEN,

Line 2396: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2392: ,p_frequency_code => l_freq_code
2393: ,p_cashflow_level_tbl => cf_level_tbl
2394: ,x_return_status => l_return_status);
2395: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2396: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2397: ELSIF l_return_status = G_RET_STS_ERROR THEN
2398: RAISE OKL_API.G_EXCEPTION_ERROR;
2399: END IF;
2400:

Line 2398: RAISE OKL_API.G_EXCEPTION_ERROR;

2394: ,x_return_status => l_return_status);
2395: IF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2396: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2397: ELSIF l_return_status = G_RET_STS_ERROR THEN
2398: RAISE OKL_API.G_EXCEPTION_ERROR;
2399: END IF;
2400:
2401: FOR j IN cf_level_tbl.FIRST .. cf_level_tbl.LAST LOOP
2402: IF cf_level_tbl.EXISTS(j) THEN

Line 2418: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2414:
2415: RETURN NULL;
2416:
2417: EXCEPTION
2418: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2419: l_pmnt_end_date := NULL;
2420:
2421: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2422: l_pmnt_end_date := NULL;

Line 2421: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2417: EXCEPTION
2418: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2419: l_pmnt_end_date := NULL;
2420:
2421: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2422: l_pmnt_end_date := NULL;
2423:
2424: WHEN NO_DATA_FOUND THEN
2425: l_pmnt_end_date := NULL;

Line 2906: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

2902: ---------------------------------------------
2903: -- PROCEDURE fetch_leaseapp_datapoints
2904: ---------------------------------------------
2905: PROCEDURE fetch_leaseapp_datapoints(p_api_version IN NUMBER
2906: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
2907: ,p_leaseapp_id IN NUMBER
2908: ,x_lap_dp_tbl_type OUT NOCOPY lap_dp_tbl_type
2909: ,x_return_status OUT NOCOPY VARCHAR2
2910: ,x_msg_count OUT NOCOPY NUMBER

Line 2958: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2954: x_msg_count => x_msg_count,
2955: x_msg_data => x_msg_data,
2956: p_datapoints_tbl => x_data_points_tbl);
2957: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2958: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2959: ELSIF x_return_status = G_RET_STS_ERROR THEN
2960: RAISE OKL_API.G_EXCEPTION_ERROR;
2961: END IF;
2962:

Line 2960: RAISE OKL_API.G_EXCEPTION_ERROR;

2956: p_datapoints_tbl => x_data_points_tbl);
2957: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2958: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2959: ELSIF x_return_status = G_RET_STS_ERROR THEN
2960: RAISE OKL_API.G_EXCEPTION_ERROR;
2961: END IF;
2962:
2963: IF (x_data_points_tbl.COUNT > 0) THEN
2964: FOR i IN x_data_points_tbl.FIRST .. x_data_points_tbl.LAST LOOP

Line 2977: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2973:
2974: x_return_status := G_RET_STS_SUCCESS;
2975:
2976: EXCEPTION
2977: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2978: IF (c_get_leaseapp_template%ISOPEN) THEN
2979: CLOSE c_get_leaseapp_template;
2980: END IF;
2981:

Line 2982: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2978: IF (c_get_leaseapp_template%ISOPEN) THEN
2979: CLOSE c_get_leaseapp_template;
2980: END IF;
2981:
2982: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2983: IF (c_get_leaseapp_template%ISOPEN) THEN
2984: CLOSE c_get_leaseapp_template;
2985: END IF;
2986:

Line 2998: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

2994: ---------------------------------------------
2995: -- PROCEDURE store_leaseapp_datapoints
2996: ---------------------------------------------
2997: PROCEDURE store_leaseapp_datapoints(p_api_version IN NUMBER
2998: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
2999: ,p_lap_dp_tbl IN lap_dp_tbl_type
3000: ,x_return_status OUT NOCOPY VARCHAR2
3001: ,x_msg_count OUT NOCOPY NUMBER
3002: ,x_msg_data OUT NOCOPY VARCHAR2) IS

Line 3039: IF (lp_lap_dp_tbl(ln_index).id is null OR lp_lap_dp_tbl(ln_index).id = OKL_API.G_MISS_NUM) THEN

3035: END IF;
3036: END LOOP;
3037:
3038: ln_index := lp_lap_dp_tbl.FIRST;
3039: IF (lp_lap_dp_tbl(ln_index).id is null OR lp_lap_dp_tbl(ln_index).id = OKL_API.G_MISS_NUM) THEN
3040:
3041: okl_lad_pvt.insert_row (p_api_version => G_API_VERSION
3042: ,p_init_msg_list => G_FALSE
3043: ,x_return_status => x_return_status

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

3044: ,x_msg_count => x_msg_count
3045: ,x_msg_data => x_msg_data
3046: ,p_ladv_tbl => lp_lap_dp_tbl
3047: ,x_ladv_tbl => lpx_lap_dp_tbl);
3048: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3049: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3050: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3051: RAISE OKL_API.G_EXCEPTION_ERROR;
3052: END IF;

Line 3049: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3045: ,x_msg_data => x_msg_data
3046: ,p_ladv_tbl => lp_lap_dp_tbl
3047: ,x_ladv_tbl => lpx_lap_dp_tbl);
3048: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3049: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3050: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3051: RAISE OKL_API.G_EXCEPTION_ERROR;
3052: END IF;
3053: ELSE

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

3046: ,p_ladv_tbl => lp_lap_dp_tbl
3047: ,x_ladv_tbl => lpx_lap_dp_tbl);
3048: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3049: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3050: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3051: RAISE OKL_API.G_EXCEPTION_ERROR;
3052: END IF;
3053: ELSE
3054: okl_lad_pvt.update_row (p_api_version => G_API_VERSION

Line 3051: RAISE OKL_API.G_EXCEPTION_ERROR;

3047: ,x_ladv_tbl => lpx_lap_dp_tbl);
3048: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3049: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3050: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3051: RAISE OKL_API.G_EXCEPTION_ERROR;
3052: END IF;
3053: ELSE
3054: okl_lad_pvt.update_row (p_api_version => G_API_VERSION
3055: ,p_init_msg_list => G_FALSE

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

3057: ,x_msg_count => x_msg_count
3058: ,x_msg_data => x_msg_data
3059: ,p_ladv_tbl => lp_lap_dp_tbl
3060: ,x_ladv_tbl => lpx_lap_dp_tbl);
3061: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3062: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3063: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3064: RAISE OKL_API.G_EXCEPTION_ERROR;
3065: END IF;

Line 3062: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3058: ,x_msg_data => x_msg_data
3059: ,p_ladv_tbl => lp_lap_dp_tbl
3060: ,x_ladv_tbl => lpx_lap_dp_tbl);
3061: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3062: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3063: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3064: RAISE OKL_API.G_EXCEPTION_ERROR;
3065: END IF;
3066: END IF;

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

3059: ,p_ladv_tbl => lp_lap_dp_tbl
3060: ,x_ladv_tbl => lpx_lap_dp_tbl);
3061: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3062: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3063: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3064: RAISE OKL_API.G_EXCEPTION_ERROR;
3065: END IF;
3066: END IF;
3067: END IF;

Line 3064: RAISE OKL_API.G_EXCEPTION_ERROR;

3060: ,x_ladv_tbl => lpx_lap_dp_tbl);
3061: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3062: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3063: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3064: RAISE OKL_API.G_EXCEPTION_ERROR;
3065: END IF;
3066: END IF;
3067: END IF;
3068:

Line 3072: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3068:
3069: x_return_status := G_RET_STS_SUCCESS;
3070:
3071: EXCEPTION
3072: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3073: x_return_status := G_RET_STS_ERROR;
3074: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3075: x_return_status := G_RET_STS_UNEXP_ERROR;
3076: WHEN OTHERS THEN

Line 3074: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3070:
3071: EXCEPTION
3072: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3073: x_return_status := G_RET_STS_ERROR;
3074: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3075: x_return_status := G_RET_STS_UNEXP_ERROR;
3076: WHEN OTHERS THEN
3077: x_return_status := G_RET_STS_ERROR;
3078: END store_leaseapp_datapoints;

Line 3084: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

3080: ---------------------------------------------
3081: -- PROCEDURE delete_leaseapp_datapoints
3082: ---------------------------------------------
3083: PROCEDURE delete_leaseapp_datapoints(p_api_version IN NUMBER
3084: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
3085: ,p_leaseapp_id IN NUMBER
3086: ,x_return_status OUT NOCOPY VARCHAR2
3087: ,x_msg_count OUT NOCOPY NUMBER
3088: ,x_msg_data OUT NOCOPY VARCHAR2) IS

Line 3127: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3123: ,p_ladv_tbl => lap_dp_tbl
3124: ,px_error_tbl => l_error_tbl_type );
3125:
3126: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3127: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3128: ELSIF x_return_status = G_RET_STS_ERROR THEN
3129: RAISE OKL_API.G_EXCEPTION_ERROR;
3130: END IF;
3131: END IF;

Line 3129: RAISE OKL_API.G_EXCEPTION_ERROR;

3125:
3126: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
3127: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3128: ELSIF x_return_status = G_RET_STS_ERROR THEN
3129: RAISE OKL_API.G_EXCEPTION_ERROR;
3130: END IF;
3131: END IF;
3132:
3133: x_return_status := G_RET_STS_SUCCESS;

Line 3136: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3132:
3133: x_return_status := G_RET_STS_SUCCESS;
3134:
3135: EXCEPTION
3136: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3137: x_return_status := G_RET_STS_ERROR;
3138: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3139: x_return_status := G_RET_STS_UNEXP_ERROR;
3140: WHEN OTHERS THEN

Line 3138: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3134:
3135: EXCEPTION
3136: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3137: x_return_status := G_RET_STS_ERROR;
3138: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3139: x_return_status := G_RET_STS_UNEXP_ERROR;
3140: WHEN OTHERS THEN
3141: x_return_status := G_RET_STS_ERROR;
3142: END delete_leaseapp_datapoints;