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

Line 406: OKL_API.SET_MESSAGE(p_app_name => G_OKC_APP,

402: AND (p_lease_header_rec.Jtot_Object1_Code IS NULL OR p_lease_header_rec.Jtot_Object1_Code = OKC_API.G_MISS_CHAR)
403: THEN
404: lp_sifv_rec.jtot_object1_code := p_lease_header_rec.jtot_object1_code;
405: /* smahapat for fee type soln
406: OKL_API.SET_MESSAGE(p_app_name => G_OKC_APP,
407: p_msg_name => G_REQUIRED_VALUE,
408: p_token1 => G_COL_NAME_TOKEN,
409: p_token1_value => 'JTOT_OBJECT1_CODE'
410: );

Line 423: OKL_API.SET_MESSAGE(p_app_name => G_OKC_APP,

419: AND (p_lease_header_rec.object1_id1 IS NULL OR p_lease_header_rec.object1_id1 = OKC_API.G_MISS_CHAR)
420: THEN
421: lp_sifv_rec.object1_id1 := p_lease_header_rec.object1_id1;
422: /* smahapat for fee type soln
423: OKL_API.SET_MESSAGE(p_app_name => G_OKC_APP,
424: p_msg_name => G_REQUIRED_VALUE,
425: p_token1 => G_COL_NAME_TOKEN,
426: p_token1_value => 'OBJECT1_ID1'
427: );

Line 448: OKL_API.SET_MESSAGE(p_app_name => G_OKC_APP,

444:
445: IF l_sif_csr%ROWCOUNT = 1 THEN
446: lp_sifv_rec.sif_id := l_sif_data.id;
447: ELSE
448: OKL_API.SET_MESSAGE(p_app_name => G_OKC_APP,
449: p_msg_name => G_REQUIRED_VALUE,
450: p_token1 => G_COL_NAME_TOKEN,
451: p_token1_value => 'SIF_ID');
452: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 480: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

476: END IF;
477: RETURN NULL;
478: WHEN OTHERS THEN
479: -- store SQL error message on message stack
480: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
481: p_msg_name => G_UNEXPECTED_ERROR,
482: p_token1 => G_SQLCODE_TOKEN,
483: p_token1_value => SQLCODE,
484: p_token2 => G_SQLERRM_TOKEN,

Line 585: OKL_API.SET_MESSAGE(p_app_name => G_OKC_APP,

581: -- cyclic dependancy of OKL_SIF_PVT with OKL_INVOKE_PRICING_ENGINE_PVT
582: IF lp_sifv_rec.deal_type = OKL_INVOKE_PRICING_ENGINE_PVT.G_XMLG_TRX_SUBTYPE_LS_REST_OUT
583: AND (p_loan_header_rec.Jtot_Object1_Code IS NULL OR p_loan_header_rec.Jtot_Object1_Code = OKC_API.G_MISS_CHAR)
584: THEN
585: OKL_API.SET_MESSAGE(p_app_name => G_OKC_APP,
586: p_msg_name => G_REQUIRED_VALUE,
587: p_token1 => G_COL_NAME_TOKEN,
588: p_token1_value => 'JTOT_OBJECT1_CODE'
589: );

Line 598: OKL_API.SET_MESSAGE(p_app_name => G_OKC_APP,

594: END IF;
595: IF lp_sifv_rec.deal_type = OKL_INVOKE_PRICING_ENGINE_PVT.G_XMLG_TRX_SUBTYPE_LS_REST_OUT
596: AND (p_loan_header_rec.object1_id1 IS NULL OR p_loan_header_rec.object1_id1 = OKC_API.G_MISS_CHAR)
597: THEN
598: OKL_API.SET_MESSAGE(p_app_name => G_OKC_APP,
599: p_msg_name => G_REQUIRED_VALUE,
600:
601: p_token1 => G_COL_NAME_TOKEN,
602: p_token1_value => 'OBJECT1_ID1'

Line 623: OKL_API.SET_MESSAGE(p_app_name => G_OKC_APP,

619: LOOP
620: IF l_sif_csr%ROWCOUNT = 1 THEN
621: lp_sifv_rec.sif_id := l_sif_data.id;
622: ELSE
623: OKL_API.SET_MESSAGE(p_app_name => G_OKC_APP,
624: p_msg_name => G_REQUIRED_VALUE,
625:
626: p_token1 => G_COL_NAME_TOKEN,
627: p_token1_value => 'SIF_ID');

Line 652: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

648: END IF;
649: RETURN NULL;
650: WHEN OTHERS THEN
651: -- store SQL error message on message stack
652: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
653: p_msg_name => G_UNEXPECTED_ERROR,
654: p_token1 => G_SQLCODE_TOKEN,
655: p_token1_value => SQLCODE,
656: p_token2 => G_SQLERRM_TOKEN,

Line 796: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

792: x_return_status := G_RET_STS_UNEXP_ERROR;
793: WHEN OTHERS THEN
794:
795: -- store SQL error message on message stack
796: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
797: p_msg_name => G_UNEXPECTED_ERROR,
798: p_token1 => G_SQLCODE_TOKEN,
799: p_token1_value => SQLCODE,
800: p_token2 => G_SQLERRM_TOKEN,

Line 925: Okl_Api.SET_MESSAGE(p_app_name => G_OKC_APP,

921: get_sil_id(p_csm_one_off_fee_tbl(i).kle_asset_id,l_sfev_one_off_tbl(i).sil_id);
922: IF l_sfev_one_off_tbl(i).sil_id = 0 THEN
923:
924:
925: Okl_Api.SET_MESSAGE(p_app_name => G_OKC_APP,
926: p_msg_name => G_INVALID_VALUE,
927: p_token1 => G_COL_NAME_TOKEN,
928: p_token1_value => 'KLE_ASSET_ID'
929: );

Line 949: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

945: l_sfev_one_off_tbl.DELETE;
946: RETURN l_sfev_one_off_tbl;
947: WHEN OTHERS THEN
948: -- store SQL error message on message stack
949: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
950: p_msg_name => G_UNEXPECTED_ERROR,
951: p_token1 => G_SQLCODE_TOKEN,
952: p_token1_value => SQLCODE,
953: p_token2 => G_SQLERRM_TOKEN,

Line 1036: Okl_Api.SET_MESSAGE(p_app_name => G_OKC_APP,

1032: AND p_csm_periodic_expenses_tbl(i).kle_asset_id <> Okc_Api.G_MISS_NUM
1033: THEN
1034: get_sil_id(p_csm_periodic_expenses_tbl(i).kle_asset_id,l_sfev_periodic_tbl(i).sil_id);
1035: IF l_sfev_periodic_tbl(i).sil_id = 0 THEN
1036: Okl_Api.SET_MESSAGE(p_app_name => G_OKC_APP,
1037: p_msg_name => G_INVALID_VALUE,
1038: p_token1 => G_COL_NAME_TOKEN,
1039: p_token1_value => 'KLE_ASSET_ID'
1040: );

Line 1081: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

1077: l_sfev_periodic_tbl.DELETE;
1078: RETURN l_sfev_periodic_tbl;
1079: WHEN OTHERS THEN
1080: -- store SQL error message on message stack
1081: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
1082: p_msg_name => G_UNEXPECTED_ERROR,
1083: p_token1 => G_SQLCODE_TOKEN,
1084: p_token1_value => SQLCODE,
1085: p_token2 => G_SQLERRM_TOKEN,

Line 1167: Okl_Api.SET_MESSAGE(p_app_name => G_OKC_APP,

1163: AND p_csm_periodic_expenses_tbl(j).kle_asset_id <> Okc_Api.G_MISS_NUM
1164: THEN
1165: get_sil_id(p_csm_periodic_expenses_tbl(j).kle_asset_id,l_sfev_periodic_tbl(i).sil_id);
1166: IF l_sfev_periodic_tbl(i).sil_id = 0 THEN
1167: Okl_Api.SET_MESSAGE(p_app_name => G_OKC_APP,
1168: p_msg_name => G_INVALID_VALUE,
1169:
1170: p_token1 => G_COL_NAME_TOKEN,
1171: p_token1_value => 'KLE_ASSET_ID'

Line 1197: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

1193: RETURN l_sfev_periodic_tbl;
1194: WHEN OTHERS THEN
1195: -- store SQL error message on message stack
1196:
1197: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
1198: p_msg_name => G_UNEXPECTED_ERROR,
1199: p_token1 => G_SQLCODE_TOKEN,
1200: p_token1_value => SQLCODE,
1201: p_token2 => G_SQLERRM_TOKEN,

Line 1265: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

1261: RETURN l_siyv_tbl;
1262:
1263: WHEN OTHERS THEN
1264: -- store SQL error message on message stack
1265: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
1266: p_msg_name => G_UNEXPECTED_ERROR,
1267: p_token1 => G_SQLCODE_TOKEN,
1268: p_token1_value => SQLCODE,
1269: p_token2 => G_SQLERRM_TOKEN,

Line 1361: Okl_Api.SET_MESSAGE(p_app_name => G_OKC_APP,

1357:
1358: get_sil_id(p_csm_stream_types_tbl(i).kle_asset_id,l_sitv_tbl(i).sil_id);
1359:
1360: IF l_sitv_tbl(i).sil_id = 0 THEN
1361: Okl_Api.SET_MESSAGE(p_app_name => G_OKC_APP,
1362: p_msg_name => G_INVALID_VALUE,
1363: p_token1 => G_COL_NAME_TOKEN,
1364:
1365: p_token1_value => 'KLE_ASSET_ID'

Line 1408: Okl_Api.SET_MESSAGE(p_app_name => G_OKC_APP,

1404: p_attribute_code => 'OKL_FEE_LINE_ID'
1405:
1406: );
1407:
1408: Okl_Api.SET_MESSAGE(p_app_name => G_OKC_APP,
1409: p_msg_name => G_INVALID_VALUE,
1410: p_token1 => G_COL_NAME_TOKEN,
1411: p_token1_value => l_token1_value
1412: );

Line 1450: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

1446: RETURN l_sitv_tbl;
1447: WHEN OTHERS THEN
1448:
1449: -- store SQL error message on message stack
1450: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
1451: p_msg_name => G_UNEXPECTED_ERROR,
1452: p_token1 => G_SQLCODE_TOKEN,
1453: p_token1_value => SQLCODE,
1454: p_token2 => G_SQLERRM_TOKEN,

Line 1580: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

1576: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1577: x_return_status := G_RET_STS_UNEXP_ERROR;
1578: WHEN OTHERS THEN
1579: -- store SQL error message on message stack
1580: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
1581: p_msg_name => G_UNEXPECTED_ERROR,
1582: p_token1 => G_SQLCODE_TOKEN,
1583: p_token1_value => SQLCODE,
1584: p_token2 => G_SQLERRM_TOKEN,

Line 1697: Okl_Api.SET_MESSAGE(p_app_name => G_OKC_APP,

1693:
1694:
1695: IF l_sfev_periodic_tbl(i).sil_id = 0 THEN
1696:
1697: Okl_Api.SET_MESSAGE(p_app_name => G_OKC_APP,
1698: p_msg_name => G_INVALID_VALUE,
1699: p_token1 => G_COL_NAME_TOKEN,
1700: p_token1_value => 'KLE_ASSET_ID'
1701: );

Line 1733: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

1729: RETURN l_sfev_periodic_tbl;
1730: WHEN OTHERS THEN
1731:
1732: -- store SQL error message on message stack
1733: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
1734: p_msg_name => G_UNEXPECTED_ERROR,
1735: p_token1 => G_SQLCODE_TOKEN,
1736: p_token1_value => SQLCODE,
1737: p_token2 => G_SQLERRM_TOKEN,

Line 1948: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

1944: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1945: x_return_status := G_RET_STS_UNEXP_ERROR;
1946: WHEN OTHERS THEN
1947: -- store SQL error message on message stack
1948: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
1949: p_msg_name => G_UNEXPECTED_ERROR,
1950: p_token1 => G_SQLCODE_TOKEN,
1951: p_token1_value => SQLCODE,
1952: p_token2 => G_SQLERRM_TOKEN,

Line 2177: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

2173: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
2174: x_return_status := G_RET_STS_UNEXP_ERROR;
2175: WHEN OTHERS THEN
2176: -- store SQL error message on message stack
2177: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
2178: p_msg_name => G_UNEXPECTED_ERROR,
2179: p_token1 => G_SQLCODE_TOKEN,
2180: p_token1_value => SQLCODE,
2181: p_token2 => G_SQLERRM_TOKEN,

Line 2351: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

2347: x_return_status := G_RET_STS_UNEXP_ERROR;
2348: WHEN OTHERS THEN
2349:
2350: -- store SQL error message on message stack
2351: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
2352: p_msg_name => G_UNEXPECTED_ERROR,
2353: p_token1 => G_SQLCODE_TOKEN,
2354: p_token1_value => SQLCODE,
2355: p_token2 => G_SQLERRM_TOKEN,

Line 2382: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

2378:
2379: l_sif_id NUMBER;
2380: l_khr_id NUMBER;
2381: BEGIN
2382: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2383:
2384: OPEN update_sif_id_csr(p_trans_id);
2385: FETCH update_sif_id_csr into l_sif_id, l_khr_id;
2386: IF update_sif_id_csr%NOTFOUND THEN

Line 2387: okl_api.set_message(p_app_name => G_APP_NAME,

2383:
2384: OPEN update_sif_id_csr(p_trans_id);
2385: FETCH update_sif_id_csr into l_sif_id, l_khr_id;
2386: IF update_sif_id_csr%NOTFOUND THEN
2387: okl_api.set_message(p_app_name => G_APP_NAME,
2388: p_msg_name => 'Transaction Number Not Found');
2389:
2390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2391: END IF;

Line 2390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2386: IF update_sif_id_csr%NOTFOUND THEN
2387: okl_api.set_message(p_app_name => G_APP_NAME,
2388: p_msg_name => 'Transaction Number Not Found');
2389:
2390: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2391: END IF;
2392:
2393: CLOSE update_sif_id_csr;
2394:

Line 2404: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

2400: x_khr_id := l_khr_id;
2401: END IF;
2402:
2403: EXCEPTION
2404: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2405: IF update_sif_id_csr%ISOPEN THEN
2406: CLOSE update_sif_id_csr;
2407: END IF;
2408: x_return_status := Okl_Api.G_RET_STS_ERROR ;

Line 2408: x_return_status := Okl_Api.G_RET_STS_ERROR ;

2404: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2405: IF update_sif_id_csr%ISOPEN THEN
2406: CLOSE update_sif_id_csr;
2407: END IF;
2408: x_return_status := Okl_Api.G_RET_STS_ERROR ;
2409:
2410: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2411: IF update_sif_id_csr%ISOPEN THEN
2412: CLOSE update_sif_id_csr;

Line 2410: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2406: CLOSE update_sif_id_csr;
2407: END IF;
2408: x_return_status := Okl_Api.G_RET_STS_ERROR ;
2409:
2410: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2411: IF update_sif_id_csr%ISOPEN THEN
2412: CLOSE update_sif_id_csr;
2413: END IF;
2414: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 2414: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

2410: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2411: IF update_sif_id_csr%ISOPEN THEN
2412: CLOSE update_sif_id_csr;
2413: END IF;
2414: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2415:
2416: WHEN OTHERS THEN
2417: IF update_sif_id_csr%ISOPEN THEN
2418: CLOSE update_sif_id_csr;

Line 2420: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

2416: WHEN OTHERS THEN
2417: IF update_sif_id_csr%ISOPEN THEN
2418: CLOSE update_sif_id_csr;
2419: END IF;
2420: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2421:
2422:
2423: END;
2424:

Line 2530: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

2526: RETURN(l_pending);
2527: EXCEPTION
2528: WHEN OTHERS THEN
2529: -- store SQL error message on message stack
2530: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
2531: p_msg_name => G_UNEXPECTED_ERROR,
2532: p_token1 => G_SQLCODE_TOKEN,
2533:
2534: p_token1_value => SQLCODE,

Line 2566: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

2562: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2563: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
2564: END IF;
2565: IF(l_pending) THEN
2566: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
2567: p_msg_name => G_OKL_CSM_PENDING
2568:
2569: );
2570: l_return_status := G_RET_STS_ERROR;

Line 2748: x_csm_one_off_fee_tbl(i).kle_asset_id <> OKL_API.G_MISS_NUM THEN

2744:
2745: /*
2746: FOR i IN x_csm_one_off_fee_tbl.FIRST..x_csm_one_off_fee_tbl.LAST LOOP
2747: IF x_csm_one_off_fee_tbl(i).kle_asset_id IS NOT NULL OR
2748: x_csm_one_off_fee_tbl(i).kle_asset_id <> OKL_API.G_MISS_NUM THEN
2749: END IF;
2750: IF x_csm_one_off_fee_tbl(i).kle_fee_id IS NOT NULL OR
2751: x_csm_one_off_fee_tbl(i).kle_fee_id <> OKL_API.G_MISS_NUM THEN
2752: END IF;

Line 2751: x_csm_one_off_fee_tbl(i).kle_fee_id <> OKL_API.G_MISS_NUM THEN

2747: IF x_csm_one_off_fee_tbl(i).kle_asset_id IS NOT NULL OR
2748: x_csm_one_off_fee_tbl(i).kle_asset_id <> OKL_API.G_MISS_NUM THEN
2749: END IF;
2750: IF x_csm_one_off_fee_tbl(i).kle_fee_id IS NOT NULL OR
2751: x_csm_one_off_fee_tbl(i).kle_fee_id <> OKL_API.G_MISS_NUM THEN
2752: END IF;
2753: IF x_csm_one_off_fee_tbl(i).other_type_id IS NOT NULL OR
2754: x_csm_one_off_fee_tbl(i).other_type_id <> OKL_API.G_MISS_NUM THEN
2755: END IF;

Line 2754: x_csm_one_off_fee_tbl(i).other_type_id <> OKL_API.G_MISS_NUM THEN

2750: IF x_csm_one_off_fee_tbl(i).kle_fee_id IS NOT NULL OR
2751: x_csm_one_off_fee_tbl(i).kle_fee_id <> OKL_API.G_MISS_NUM THEN
2752: END IF;
2753: IF x_csm_one_off_fee_tbl(i).other_type_id IS NOT NULL OR
2754: x_csm_one_off_fee_tbl(i).other_type_id <> OKL_API.G_MISS_NUM THEN
2755: END IF;
2756: END LOOP;
2757: */
2758:

Line 3055: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

3051: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
3052: x_return_status := G_RET_STS_UNEXP_ERROR;
3053: WHEN OTHERS THEN
3054: -- store SQL error message on message stack
3055: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
3056: p_msg_name => G_UNEXPECTED_ERROR,
3057: p_token1 => G_SQLCODE_TOKEN,
3058: p_token1_value => SQLCODE,
3059: p_token2 => G_SQLERRM_TOKEN,

Line 3175: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

3171: EXCEPTION
3172:
3173: WHEN OTHERS THEN
3174: -- store SQL error message on message stack
3175: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
3176: p_msg_name => G_UNEXPECTED_ERROR,
3177: p_token1 => G_SQLCODE_TOKEN,
3178: p_token1_value => SQLCODE,
3179: p_token2 => G_SQLERRM_TOKEN,

Line 3209: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

3205: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
3206: END IF;
3207: IF(l_pending) THEN
3208:
3209: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
3210: p_msg_name => G_OKL_CSM_PENDING
3211: );
3212: l_return_status := G_RET_STS_ERROR;
3213: RAISE G_EXCEPTION_ERROR;

Line 3683: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

3679: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
3680: x_return_status := G_RET_STS_UNEXP_ERROR;
3681: WHEN OTHERS THEN
3682: -- store SQL error message on message stack
3683: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
3684: p_msg_name => G_UNEXPECTED_ERROR,
3685: p_token1 => G_SQLCODE_TOKEN,
3686: p_token1_value => SQLCODE,
3687: p_token2 => G_SQLERRM_TOKEN,

Line 3830: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

3826: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
3827: x_return_status := G_RET_STS_UNEXP_ERROR;
3828: WHEN OTHERS THEN
3829: -- store SQL error message on message stack
3830: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
3831: p_msg_name => G_UNEXPECTED_ERROR,
3832: p_token1 => G_SQLCODE_TOKEN,
3833: p_token1_value => SQLCODE,
3834: p_token2 => G_SQLERRM_TOKEN,

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

3868: THEN
3869: l_target_count := l_target_count + 1;
3870: END IF;
3871: IF l_target_count > 1 THEN
3872: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
3873:
3874: p_msg_name => G_OKL_MULTIPLE_TARGET_VALUES);
3875: RAISE G_EXCEPTION_ERROR;
3876: END IF;

Line 3895: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

3891: l_siyv_tbl.DELETE;
3892: RETURN l_siyv_tbl;
3893: WHEN OTHERS THEN
3894: -- store SQL error message on message stack
3895: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
3896: p_msg_name => G_UNEXPECTED_ERROR,
3897: p_token1 => G_SQLCODE_TOKEN,
3898: p_token1_value => SQLCODE,
3899: p_token2 => G_SQLERRM_TOKEN,

Line 3981: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

3977: WHEN OTHERS THEN
3978: -- store SQL error message on message stack
3979:
3980:
3981: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
3982: p_msg_name => G_UNEXPECTED_ERROR,
3983: p_token1 => G_SQLCODE_TOKEN,
3984: p_token1_value => SQLCODE,
3985: p_token2 => G_SQLERRM_TOKEN,

Line 4003: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

3999: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4000: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
4001: END IF;
4002: IF(l_pending) THEN
4003: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
4004: p_msg_name => G_OKL_CSM_PENDING
4005: );
4006: l_return_status := G_RET_STS_ERROR;
4007: RAISE G_EXCEPTION_ERROR;

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

4011: p_khr_id => p_csm_lease_header.khr_id,
4012: x_pricing_engine => l_pricing_engine,
4013: x_return_status => x_return_status);
4014:
4015: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
4016: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4017: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
4018: raise OKL_API.G_EXCEPTION_ERROR;
4019: END IF;

Line 4016: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4012: x_pricing_engine => l_pricing_engine,
4013: x_return_status => x_return_status);
4014:
4015: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
4016: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4017: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
4018: raise OKL_API.G_EXCEPTION_ERROR;
4019: END IF;
4020:

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

4013: x_return_status => x_return_status);
4014:
4015: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
4016: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4017: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
4018: raise OKL_API.G_EXCEPTION_ERROR;
4019: END IF;
4020:
4021: IF ( l_pricing_engine = 'INTERNAL') THEN

Line 4018: raise OKL_API.G_EXCEPTION_ERROR;

4014:
4015: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
4016: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4017: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
4018: raise OKL_API.G_EXCEPTION_ERROR;
4019: END IF;
4020:
4021: IF ( l_pricing_engine = 'INTERNAL') THEN
4022: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 4022: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

4018: raise OKL_API.G_EXCEPTION_ERROR;
4019: END IF;
4020:
4021: IF ( l_pricing_engine = 'INTERNAL') THEN
4022: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
4023: p_msg_name => G_OKL_INT_PRIC_RESTR_NA
4024: );
4025: l_return_status := G_RET_STS_ERROR;
4026: RAISE G_EXCEPTION_ERROR;

Line 4356: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

4352: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
4353: x_return_status := G_RET_STS_UNEXP_ERROR;
4354: WHEN OTHERS THEN
4355: -- store SQL error message on message stack
4356: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
4357: p_msg_name => G_UNEXPECTED_ERROR,
4358: p_token1 => G_SQLCODE_TOKEN,
4359: p_token1_value => SQLCODE,
4360: p_token2 => G_SQLERRM_TOKEN,

Line 4464: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

4460: RETURN(l_pending);
4461: EXCEPTION
4462: WHEN OTHERS THEN
4463: -- store SQL error message on message stack
4464: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
4465: p_msg_name => G_UNEXPECTED_ERROR,
4466: p_token1 => G_SQLCODE_TOKEN,
4467: p_token1_value => SQLCODE,
4468: p_token2 => G_SQLERRM_TOKEN,

Line 4488: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

4484:
4485: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
4486: END IF;
4487: IF(l_pending) THEN
4488: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
4489: p_msg_name => G_OKL_CSM_PENDING
4490: );
4491: l_return_status := G_RET_STS_ERROR;
4492: RAISE G_EXCEPTION_ERROR;

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

4497: p_khr_id => p_csm_loan_header.khr_id,
4498: x_pricing_engine => l_pricing_engine,
4499: x_return_status => x_return_status);
4500:
4501: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
4502: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4503: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
4504: raise OKL_API.G_EXCEPTION_ERROR;
4505: END IF;

Line 4502: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4498: x_pricing_engine => l_pricing_engine,
4499: x_return_status => x_return_status);
4500:
4501: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
4502: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4503: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
4504: raise OKL_API.G_EXCEPTION_ERROR;
4505: END IF;
4506:

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

4499: x_return_status => x_return_status);
4500:
4501: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
4502: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4503: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
4504: raise OKL_API.G_EXCEPTION_ERROR;
4505: END IF;
4506:
4507: IF ( l_pricing_engine = 'INTERNAL') THEN

Line 4504: raise OKL_API.G_EXCEPTION_ERROR;

4500:
4501: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
4502: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4503: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
4504: raise OKL_API.G_EXCEPTION_ERROR;
4505: END IF;
4506:
4507: IF ( l_pricing_engine = 'INTERNAL') THEN
4508: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

Line 4508: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

4504: raise OKL_API.G_EXCEPTION_ERROR;
4505: END IF;
4506:
4507: IF ( l_pricing_engine = 'INTERNAL') THEN
4508: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
4509: p_msg_name => G_OKL_INT_PRIC_RESTR_NA
4510: );
4511: l_return_status := G_RET_STS_ERROR;
4512: RAISE G_EXCEPTION_ERROR;

Line 4891: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

4887: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
4888: x_return_status := G_RET_STS_UNEXP_ERROR;
4889: WHEN OTHERS THEN
4890: -- store SQL error message on message stack
4891: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
4892: p_msg_name => G_UNEXPECTED_ERROR,
4893: p_token1 => G_SQLCODE_TOKEN,
4894: p_token1_value => SQLCODE,
4895: p_token2 => G_SQLERRM_TOKEN,

Line 4978: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

4974: RETURN(l_pending);
4975: EXCEPTION
4976: WHEN OTHERS THEN
4977: -- store SQL error message on message stack
4978: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
4979: p_msg_name => G_UNEXPECTED_ERROR,
4980: p_token1 => G_SQLCODE_TOKEN,
4981: p_token1_value => SQLCODE,
4982: p_token2 => G_SQLERRM_TOKEN,

Line 5001: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

4997: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4998: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
4999: END IF;
5000: IF(l_pending) THEN
5001: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
5002: p_msg_name => G_OKL_CSM_PENDING
5003: );
5004: l_return_status := G_RET_STS_ERROR;
5005: RAISE G_EXCEPTION_ERROR;

Line 5331: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

5327: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
5328: x_return_status := G_RET_STS_UNEXP_ERROR;
5329: WHEN OTHERS THEN
5330: -- store SQL error message on message stack
5331: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
5332: p_msg_name => G_UNEXPECTED_ERROR,
5333: p_token1 => G_SQLCODE_TOKEN,
5334:
5335: p_token1_value => SQLCODE,