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 379: OKL_API.SET_MESSAGE(p_app_name => G_OKC_APP,

375: AND (p_lease_header_rec.Jtot_Object1_Code IS NULL OR p_lease_header_rec.Jtot_Object1_Code = OKC_API.G_MISS_CHAR)
376: THEN
377: lp_sifv_rec.jtot_object1_code := p_lease_header_rec.jtot_object1_code;
378: /* smahapat for fee type soln
379: OKL_API.SET_MESSAGE(p_app_name => G_OKC_APP,
380: p_msg_name => G_REQUIRED_VALUE,
381: p_token1 => G_COL_NAME_TOKEN,
382: p_token1_value => 'JTOT_OBJECT1_CODE'
383: );

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

392: AND (p_lease_header_rec.object1_id1 IS NULL OR p_lease_header_rec.object1_id1 = OKC_API.G_MISS_CHAR)
393: THEN
394: lp_sifv_rec.object1_id1 := p_lease_header_rec.object1_id1;
395: /* smahapat for fee type soln
396: OKL_API.SET_MESSAGE(p_app_name => G_OKC_APP,
397: p_msg_name => G_REQUIRED_VALUE,
398: p_token1 => G_COL_NAME_TOKEN,
399: p_token1_value => 'OBJECT1_ID1'
400: );

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

417:
418: IF l_sif_csr%ROWCOUNT = 1 THEN
419: lp_sifv_rec.sif_id := l_sif_data.id;
420: ELSE
421: OKL_API.SET_MESSAGE(p_app_name => G_OKC_APP,
422: p_msg_name => G_REQUIRED_VALUE,
423: p_token1 => G_COL_NAME_TOKEN,
424: p_token1_value => 'SIF_ID');
425: x_return_status := Okc_Api.G_RET_STS_ERROR;

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

449: END IF;
450: RETURN NULL;
451: WHEN OTHERS THEN
452: -- store SQL error message on message stack
453: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
454: p_msg_name => G_UNEXPECTED_ERROR,
455: p_token1 => G_SQLCODE_TOKEN,
456: p_token1_value => SQLCODE,
457: p_token2 => G_SQLERRM_TOKEN,

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

554: -- cyclic dependancy of OKL_SIF_PVT with OKL_INVOKE_PRICING_ENGINE_PVT
555: IF lp_sifv_rec.deal_type = OKL_INVOKE_PRICING_ENGINE_PVT.G_XMLG_TRX_SUBTYPE_LS_REST_OUT
556: AND (p_loan_header_rec.Jtot_Object1_Code IS NULL OR p_loan_header_rec.Jtot_Object1_Code = OKC_API.G_MISS_CHAR)
557: THEN
558: OKL_API.SET_MESSAGE(p_app_name => G_OKC_APP,
559: p_msg_name => G_REQUIRED_VALUE,
560: p_token1 => G_COL_NAME_TOKEN,
561: p_token1_value => 'JTOT_OBJECT1_CODE'
562: );

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

567: END IF;
568: IF lp_sifv_rec.deal_type = OKL_INVOKE_PRICING_ENGINE_PVT.G_XMLG_TRX_SUBTYPE_LS_REST_OUT
569: AND (p_loan_header_rec.object1_id1 IS NULL OR p_loan_header_rec.object1_id1 = OKC_API.G_MISS_CHAR)
570: THEN
571: OKL_API.SET_MESSAGE(p_app_name => G_OKC_APP,
572: p_msg_name => G_REQUIRED_VALUE,
573:
574: p_token1 => G_COL_NAME_TOKEN,
575: p_token1_value => 'OBJECT1_ID1'

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

592: LOOP
593: IF l_sif_csr%ROWCOUNT = 1 THEN
594: lp_sifv_rec.sif_id := l_sif_data.id;
595: ELSE
596: OKL_API.SET_MESSAGE(p_app_name => G_OKC_APP,
597: p_msg_name => G_REQUIRED_VALUE,
598:
599: p_token1 => G_COL_NAME_TOKEN,
600: p_token1_value => 'SIF_ID');

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

621: END IF;
622: RETURN NULL;
623: WHEN OTHERS THEN
624: -- store SQL error message on message stack
625: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
626: p_msg_name => G_UNEXPECTED_ERROR,
627: p_token1 => G_SQLCODE_TOKEN,
628: p_token1_value => SQLCODE,
629: p_token2 => G_SQLERRM_TOKEN,

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

743: x_return_status := G_RET_STS_UNEXP_ERROR;
744: WHEN OTHERS THEN
745:
746: -- store SQL error message on message stack
747: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
748: p_msg_name => G_UNEXPECTED_ERROR,
749: p_token1 => G_SQLCODE_TOKEN,
750: p_token1_value => SQLCODE,
751: p_token2 => G_SQLERRM_TOKEN,

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

835: get_sil_id(p_csm_one_off_fee_tbl(i).kle_asset_id,l_sfev_one_off_tbl(i).sil_id);
836: IF l_sfev_one_off_tbl(i).sil_id = 0 THEN
837:
838:
839: Okl_Api.SET_MESSAGE(p_app_name => G_OKC_APP,
840: p_msg_name => G_INVALID_VALUE,
841: p_token1 => G_COL_NAME_TOKEN,
842: p_token1_value => 'KLE_ASSET_ID'
843: );

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

859: l_sfev_one_off_tbl.DELETE;
860: RETURN l_sfev_one_off_tbl;
861: WHEN OTHERS THEN
862: -- store SQL error message on message stack
863: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
864: p_msg_name => G_UNEXPECTED_ERROR,
865: p_token1 => G_SQLCODE_TOKEN,
866: p_token1_value => SQLCODE,
867: p_token2 => G_SQLERRM_TOKEN,

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

923: AND p_csm_periodic_expenses_tbl(i).kle_asset_id <> Okc_Api.G_MISS_NUM
924: THEN
925: get_sil_id(p_csm_periodic_expenses_tbl(i).kle_asset_id,l_sfev_periodic_tbl(i).sil_id);
926: IF l_sfev_periodic_tbl(i).sil_id = 0 THEN
927: Okl_Api.SET_MESSAGE(p_app_name => G_OKC_APP,
928: p_msg_name => G_INVALID_VALUE,
929: p_token1 => G_COL_NAME_TOKEN,
930: p_token1_value => 'KLE_ASSET_ID'
931: );

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

968: l_sfev_periodic_tbl.DELETE;
969: RETURN l_sfev_periodic_tbl;
970: WHEN OTHERS THEN
971: -- store SQL error message on message stack
972: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
973: p_msg_name => G_UNEXPECTED_ERROR,
974: p_token1 => G_SQLCODE_TOKEN,
975: p_token1_value => SQLCODE,
976: p_token2 => G_SQLERRM_TOKEN,

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

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

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

1064: RETURN l_sfev_periodic_tbl;
1065: WHEN OTHERS THEN
1066: -- store SQL error message on message stack
1067:
1068: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
1069: p_msg_name => G_UNEXPECTED_ERROR,
1070: p_token1 => G_SQLCODE_TOKEN,
1071: p_token1_value => SQLCODE,
1072: p_token2 => G_SQLERRM_TOKEN,

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

1132: RETURN l_siyv_tbl;
1133:
1134: WHEN OTHERS THEN
1135: -- store SQL error message on message stack
1136: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
1137: p_msg_name => G_UNEXPECTED_ERROR,
1138: p_token1 => G_SQLCODE_TOKEN,
1139: p_token1_value => SQLCODE,
1140: p_token2 => G_SQLERRM_TOKEN,

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

1228:
1229: get_sil_id(p_csm_stream_types_tbl(i).kle_asset_id,l_sitv_tbl(i).sil_id);
1230:
1231: IF l_sitv_tbl(i).sil_id = 0 THEN
1232: Okl_Api.SET_MESSAGE(p_app_name => G_OKC_APP,
1233: p_msg_name => G_INVALID_VALUE,
1234: p_token1 => G_COL_NAME_TOKEN,
1235:
1236: p_token1_value => 'KLE_ASSET_ID'

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

1275: p_attribute_code => 'OKL_FEE_LINE_ID'
1276:
1277: );
1278:
1279: Okl_Api.SET_MESSAGE(p_app_name => G_OKC_APP,
1280: p_msg_name => G_INVALID_VALUE,
1281: p_token1 => G_COL_NAME_TOKEN,
1282: p_token1_value => l_token1_value
1283: );

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

1317: RETURN l_sitv_tbl;
1318: WHEN OTHERS THEN
1319:
1320: -- store SQL error message on message stack
1321: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
1322: p_msg_name => G_UNEXPECTED_ERROR,
1323: p_token1 => G_SQLCODE_TOKEN,
1324: p_token1_value => SQLCODE,
1325: p_token2 => G_SQLERRM_TOKEN,

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

1426: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1427: x_return_status := G_RET_STS_UNEXP_ERROR;
1428: WHEN OTHERS THEN
1429: -- store SQL error message on message stack
1430: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
1431: p_msg_name => G_UNEXPECTED_ERROR,
1432: p_token1 => G_SQLCODE_TOKEN,
1433: p_token1_value => SQLCODE,
1434: p_token2 => G_SQLERRM_TOKEN,

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

1526:
1527:
1528: IF l_sfev_periodic_tbl(i).sil_id = 0 THEN
1529:
1530: Okl_Api.SET_MESSAGE(p_app_name => G_OKC_APP,
1531: p_msg_name => G_INVALID_VALUE,
1532: p_token1 => G_COL_NAME_TOKEN,
1533: p_token1_value => 'KLE_ASSET_ID'
1534: );

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

1562: RETURN l_sfev_periodic_tbl;
1563: WHEN OTHERS THEN
1564:
1565: -- store SQL error message on message stack
1566: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
1567: p_msg_name => G_UNEXPECTED_ERROR,
1568: p_token1 => G_SQLCODE_TOKEN,
1569: p_token1_value => SQLCODE,
1570: p_token2 => G_SQLERRM_TOKEN,

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

1750: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1751: x_return_status := G_RET_STS_UNEXP_ERROR;
1752: WHEN OTHERS THEN
1753: -- store SQL error message on message stack
1754: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
1755: p_msg_name => G_UNEXPECTED_ERROR,
1756: p_token1 => G_SQLCODE_TOKEN,
1757: p_token1_value => SQLCODE,
1758: p_token2 => G_SQLERRM_TOKEN,

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

1949: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1950: x_return_status := G_RET_STS_UNEXP_ERROR;
1951: WHEN OTHERS THEN
1952: -- store SQL error message on message stack
1953: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
1954: p_msg_name => G_UNEXPECTED_ERROR,
1955: p_token1 => G_SQLCODE_TOKEN,
1956: p_token1_value => SQLCODE,
1957: p_token2 => G_SQLERRM_TOKEN,

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

2089: x_return_status := G_RET_STS_UNEXP_ERROR;
2090: WHEN OTHERS THEN
2091:
2092: -- store SQL error message on message stack
2093: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
2094: p_msg_name => G_UNEXPECTED_ERROR,
2095: p_token1 => G_SQLCODE_TOKEN,
2096: p_token1_value => SQLCODE,
2097: p_token2 => G_SQLERRM_TOKEN,

Line 2124: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

2120:
2121: l_sif_id NUMBER;
2122: l_khr_id NUMBER;
2123: BEGIN
2124: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2125:
2126: OPEN update_sif_id_csr(p_trans_id);
2127: FETCH update_sif_id_csr into l_sif_id, l_khr_id;
2128: IF update_sif_id_csr%NOTFOUND THEN

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

2125:
2126: OPEN update_sif_id_csr(p_trans_id);
2127: FETCH update_sif_id_csr into l_sif_id, l_khr_id;
2128: IF update_sif_id_csr%NOTFOUND THEN
2129: okl_api.set_message(p_app_name => G_APP_NAME,
2130: p_msg_name => 'Transaction Number Not Found');
2131:
2132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2133: END IF;

Line 2132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2128: IF update_sif_id_csr%NOTFOUND THEN
2129: okl_api.set_message(p_app_name => G_APP_NAME,
2130: p_msg_name => 'Transaction Number Not Found');
2131:
2132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2133: END IF;
2134:
2135: CLOSE update_sif_id_csr;
2136:

Line 2146: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

2142: x_khr_id := l_khr_id;
2143: END IF;
2144:
2145: EXCEPTION
2146: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2147: IF update_sif_id_csr%ISOPEN THEN
2148: CLOSE update_sif_id_csr;
2149: END IF;
2150: x_return_status := Okl_Api.G_RET_STS_ERROR ;

Line 2150: x_return_status := Okl_Api.G_RET_STS_ERROR ;

2146: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2147: IF update_sif_id_csr%ISOPEN THEN
2148: CLOSE update_sif_id_csr;
2149: END IF;
2150: x_return_status := Okl_Api.G_RET_STS_ERROR ;
2151:
2152: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2153: IF update_sif_id_csr%ISOPEN THEN
2154: CLOSE update_sif_id_csr;

Line 2152: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2148: CLOSE update_sif_id_csr;
2149: END IF;
2150: x_return_status := Okl_Api.G_RET_STS_ERROR ;
2151:
2152: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2153: IF update_sif_id_csr%ISOPEN THEN
2154: CLOSE update_sif_id_csr;
2155: END IF;
2156: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 2156: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

2152: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2153: IF update_sif_id_csr%ISOPEN THEN
2154: CLOSE update_sif_id_csr;
2155: END IF;
2156: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2157:
2158: WHEN OTHERS THEN
2159: IF update_sif_id_csr%ISOPEN THEN
2160: CLOSE update_sif_id_csr;

Line 2162: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

2158: WHEN OTHERS THEN
2159: IF update_sif_id_csr%ISOPEN THEN
2160: CLOSE update_sif_id_csr;
2161: END IF;
2162: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
2163:
2164:
2165: END;
2166:

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

2268: RETURN(l_pending);
2269: EXCEPTION
2270: WHEN OTHERS THEN
2271: -- store SQL error message on message stack
2272: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
2273: p_msg_name => G_UNEXPECTED_ERROR,
2274: p_token1 => G_SQLCODE_TOKEN,
2275:
2276: p_token1_value => SQLCODE,

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

2304: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
2305: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
2306: END IF;
2307: IF(l_pending) THEN
2308: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
2309: p_msg_name => G_OKL_CSM_PENDING
2310:
2311: );
2312: l_return_status := G_RET_STS_ERROR;

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

2482:
2483: /*
2484: FOR i IN x_csm_one_off_fee_tbl.FIRST..x_csm_one_off_fee_tbl.LAST LOOP
2485: IF x_csm_one_off_fee_tbl(i).kle_asset_id IS NOT NULL OR
2486: x_csm_one_off_fee_tbl(i).kle_asset_id <> OKL_API.G_MISS_NUM THEN
2487: END IF;
2488: IF x_csm_one_off_fee_tbl(i).kle_fee_id IS NOT NULL OR
2489: x_csm_one_off_fee_tbl(i).kle_fee_id <> OKL_API.G_MISS_NUM THEN
2490: END IF;

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

2485: IF x_csm_one_off_fee_tbl(i).kle_asset_id IS NOT NULL OR
2486: x_csm_one_off_fee_tbl(i).kle_asset_id <> OKL_API.G_MISS_NUM THEN
2487: END IF;
2488: IF x_csm_one_off_fee_tbl(i).kle_fee_id IS NOT NULL OR
2489: x_csm_one_off_fee_tbl(i).kle_fee_id <> OKL_API.G_MISS_NUM THEN
2490: END IF;
2491: IF x_csm_one_off_fee_tbl(i).other_type_id IS NOT NULL OR
2492: x_csm_one_off_fee_tbl(i).other_type_id <> OKL_API.G_MISS_NUM THEN
2493: END IF;

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

2488: IF x_csm_one_off_fee_tbl(i).kle_fee_id IS NOT NULL OR
2489: x_csm_one_off_fee_tbl(i).kle_fee_id <> OKL_API.G_MISS_NUM THEN
2490: END IF;
2491: IF x_csm_one_off_fee_tbl(i).other_type_id IS NOT NULL OR
2492: x_csm_one_off_fee_tbl(i).other_type_id <> OKL_API.G_MISS_NUM THEN
2493: END IF;
2494: END LOOP;
2495: */
2496:

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

2789: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
2790: x_return_status := G_RET_STS_UNEXP_ERROR;
2791: WHEN OTHERS THEN
2792: -- store SQL error message on message stack
2793: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
2794: p_msg_name => G_UNEXPECTED_ERROR,
2795: p_token1 => G_SQLCODE_TOKEN,
2796: p_token1_value => SQLCODE,
2797: p_token2 => G_SQLERRM_TOKEN,

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

2909: EXCEPTION
2910:
2911: WHEN OTHERS THEN
2912: -- store SQL error message on message stack
2913: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
2914: p_msg_name => G_UNEXPECTED_ERROR,
2915: p_token1 => G_SQLCODE_TOKEN,
2916: p_token1_value => SQLCODE,
2917: p_token2 => G_SQLERRM_TOKEN,

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

2943: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
2944: END IF;
2945: IF(l_pending) THEN
2946:
2947: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
2948: p_msg_name => G_OKL_CSM_PENDING
2949: );
2950: l_return_status := G_RET_STS_ERROR;
2951: RAISE G_EXCEPTION_ERROR;

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

3417: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
3418: x_return_status := G_RET_STS_UNEXP_ERROR;
3419: WHEN OTHERS THEN
3420: -- store SQL error message on message stack
3421: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
3422: p_msg_name => G_UNEXPECTED_ERROR,
3423: p_token1 => G_SQLCODE_TOKEN,
3424: p_token1_value => SQLCODE,
3425: p_token2 => G_SQLERRM_TOKEN,

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

3564: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
3565: x_return_status := G_RET_STS_UNEXP_ERROR;
3566: WHEN OTHERS THEN
3567: -- store SQL error message on message stack
3568: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
3569: p_msg_name => G_UNEXPECTED_ERROR,
3570: p_token1 => G_SQLCODE_TOKEN,
3571: p_token1_value => SQLCODE,
3572: p_token2 => G_SQLERRM_TOKEN,

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

3606: THEN
3607: l_target_count := l_target_count + 1;
3608: END IF;
3609: IF l_target_count > 1 THEN
3610: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
3611:
3612: p_msg_name => G_OKL_MULTIPLE_TARGET_VALUES);
3613: RAISE G_EXCEPTION_ERROR;
3614: END IF;

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

3629: l_siyv_tbl.DELETE;
3630: RETURN l_siyv_tbl;
3631: WHEN OTHERS THEN
3632: -- store SQL error message on message stack
3633: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
3634: p_msg_name => G_UNEXPECTED_ERROR,
3635: p_token1 => G_SQLCODE_TOKEN,
3636: p_token1_value => SQLCODE,
3637: p_token2 => G_SQLERRM_TOKEN,

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

3715: WHEN OTHERS THEN
3716: -- store SQL error message on message stack
3717:
3718:
3719: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
3720: p_msg_name => G_UNEXPECTED_ERROR,
3721: p_token1 => G_SQLCODE_TOKEN,
3722: p_token1_value => SQLCODE,
3723: p_token2 => G_SQLERRM_TOKEN,

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

3737: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
3738: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
3739: END IF;
3740: IF(l_pending) THEN
3741: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
3742: p_msg_name => G_OKL_CSM_PENDING
3743: );
3744: l_return_status := G_RET_STS_ERROR;
3745: RAISE G_EXCEPTION_ERROR;

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

3749: p_khr_id => p_csm_lease_header.khr_id,
3750: x_pricing_engine => l_pricing_engine,
3751: x_return_status => x_return_status);
3752:
3753: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3754: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3755: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3756: raise OKL_API.G_EXCEPTION_ERROR;
3757: END IF;

Line 3754: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3750: x_pricing_engine => l_pricing_engine,
3751: x_return_status => x_return_status);
3752:
3753: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3754: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3755: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3756: raise OKL_API.G_EXCEPTION_ERROR;
3757: END IF;
3758:

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

3751: x_return_status => x_return_status);
3752:
3753: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3754: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3755: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3756: raise OKL_API.G_EXCEPTION_ERROR;
3757: END IF;
3758:
3759: IF ( l_pricing_engine = 'INTERNAL') THEN

Line 3756: raise OKL_API.G_EXCEPTION_ERROR;

3752:
3753: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
3754: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3755: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
3756: raise OKL_API.G_EXCEPTION_ERROR;
3757: END IF;
3758:
3759: IF ( l_pricing_engine = 'INTERNAL') THEN
3760: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

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

3756: raise OKL_API.G_EXCEPTION_ERROR;
3757: END IF;
3758:
3759: IF ( l_pricing_engine = 'INTERNAL') THEN
3760: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
3761: p_msg_name => G_OKL_INT_PRIC_RESTR_NA
3762: );
3763: l_return_status := G_RET_STS_ERROR;
3764: RAISE G_EXCEPTION_ERROR;

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

4090: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
4091: x_return_status := G_RET_STS_UNEXP_ERROR;
4092: WHEN OTHERS THEN
4093: -- store SQL error message on message stack
4094: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
4095: p_msg_name => G_UNEXPECTED_ERROR,
4096: p_token1 => G_SQLCODE_TOKEN,
4097: p_token1_value => SQLCODE,
4098: p_token2 => G_SQLERRM_TOKEN,

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

4198: RETURN(l_pending);
4199: EXCEPTION
4200: WHEN OTHERS THEN
4201: -- store SQL error message on message stack
4202: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
4203: p_msg_name => G_UNEXPECTED_ERROR,
4204: p_token1 => G_SQLCODE_TOKEN,
4205: p_token1_value => SQLCODE,
4206: p_token2 => G_SQLERRM_TOKEN,

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

4222:
4223: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
4224: END IF;
4225: IF(l_pending) THEN
4226: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
4227: p_msg_name => G_OKL_CSM_PENDING
4228: );
4229: l_return_status := G_RET_STS_ERROR;
4230: RAISE G_EXCEPTION_ERROR;

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

4235: p_khr_id => p_csm_loan_header.khr_id,
4236: x_pricing_engine => l_pricing_engine,
4237: x_return_status => x_return_status);
4238:
4239: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
4240: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4241: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
4242: raise OKL_API.G_EXCEPTION_ERROR;
4243: END IF;

Line 4240: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4236: x_pricing_engine => l_pricing_engine,
4237: x_return_status => x_return_status);
4238:
4239: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
4240: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4241: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
4242: raise OKL_API.G_EXCEPTION_ERROR;
4243: END IF;
4244:

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

4237: x_return_status => x_return_status);
4238:
4239: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
4240: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4241: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
4242: raise OKL_API.G_EXCEPTION_ERROR;
4243: END IF;
4244:
4245: IF ( l_pricing_engine = 'INTERNAL') THEN

Line 4242: raise OKL_API.G_EXCEPTION_ERROR;

4238:
4239: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) then
4240: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4241: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) then
4242: raise OKL_API.G_EXCEPTION_ERROR;
4243: END IF;
4244:
4245: IF ( l_pricing_engine = 'INTERNAL') THEN
4246: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,

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

4242: raise OKL_API.G_EXCEPTION_ERROR;
4243: END IF;
4244:
4245: IF ( l_pricing_engine = 'INTERNAL') THEN
4246: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
4247: p_msg_name => G_OKL_INT_PRIC_RESTR_NA
4248: );
4249: l_return_status := G_RET_STS_ERROR;
4250: RAISE G_EXCEPTION_ERROR;

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

4625: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
4626: x_return_status := G_RET_STS_UNEXP_ERROR;
4627: WHEN OTHERS THEN
4628: -- store SQL error message on message stack
4629: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
4630: p_msg_name => G_UNEXPECTED_ERROR,
4631: p_token1 => G_SQLCODE_TOKEN,
4632: p_token1_value => SQLCODE,
4633: p_token2 => G_SQLERRM_TOKEN,

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

4712: RETURN(l_pending);
4713: EXCEPTION
4714: WHEN OTHERS THEN
4715: -- store SQL error message on message stack
4716: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
4717: p_msg_name => G_UNEXPECTED_ERROR,
4718: p_token1 => G_SQLCODE_TOKEN,
4719: p_token1_value => SQLCODE,
4720: p_token2 => G_SQLERRM_TOKEN,

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

4735: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
4736: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
4737: END IF;
4738: IF(l_pending) THEN
4739: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
4740: p_msg_name => G_OKL_CSM_PENDING
4741: );
4742: l_return_status := G_RET_STS_ERROR;
4743: RAISE G_EXCEPTION_ERROR;

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

5062: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
5063: x_return_status := G_RET_STS_UNEXP_ERROR;
5064: WHEN OTHERS THEN
5065: -- store SQL error message on message stack
5066: Okl_Api.SET_MESSAGE(p_app_name => G_APP_NAME,
5067: p_msg_name => G_UNEXPECTED_ERROR,
5068: p_token1 => G_SQLCODE_TOKEN,
5069:
5070: p_token1_value => SQLCODE,