73: l_primary_strm_name OKL_STRM_TYPE_v.name%Type;
74:
75: BEGIN
76:
77: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
78:
79: OPEN get_k_info_csr (p_khr_id);
80: FETCH get_k_info_csr INTO l_product_id, l_contract_start_date,l_deal_type,l_report_product_id;
81: CLOSE get_k_info_csr;
94: CLOSE get_primary_strm_type_csr;
95:
96: ELSE
97:
98: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
99: p_msg_name => 'OKL_NO_PDT_FOUND');
100: RAISE Okl_Api.G_EXCEPTION_ERROR;
101:
102: END IF;
96: ELSE
97:
98: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
99: p_msg_name => 'OKL_NO_PDT_FOUND');
100: RAISE Okl_Api.G_EXCEPTION_ERROR;
101:
102: END IF;
103: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
104:
99: p_msg_name => 'OKL_NO_PDT_FOUND');
100: RAISE Okl_Api.G_EXCEPTION_ERROR;
101:
102: END IF;
103: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
104:
105: EXCEPTION
106: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
107: IF get_k_info_csr%ISOPEN THEN
102: END IF;
103: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
104:
105: EXCEPTION
106: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
107: IF get_k_info_csr%ISOPEN THEN
108: CLOSE get_k_info_csr;
109: END IF;
110: IF get_primary_strm_type_csr%ISOPEN THEN
109: END IF;
110: IF get_primary_strm_type_csr%ISOPEN THEN
111: CLOSE get_primary_strm_type_csr;
112: END IF;
113: x_return_status := Okl_Api.G_RET_STS_ERROR ;
114:
115: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
116: IF get_k_info_csr%ISOPEN THEN
117: CLOSE get_k_info_csr;
111: CLOSE get_primary_strm_type_csr;
112: END IF;
113: x_return_status := Okl_Api.G_RET_STS_ERROR ;
114:
115: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
116: IF get_k_info_csr%ISOPEN THEN
117: CLOSE get_k_info_csr;
118: END IF;
119: IF get_primary_strm_type_csr%ISOPEN THEN
118: END IF;
119: IF get_primary_strm_type_csr%ISOPEN THEN
120: CLOSE get_primary_strm_type_csr;
121: END IF;
122: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
123:
124: WHEN OTHERS THEN
125: IF get_k_info_csr%ISOPEN THEN
126: CLOSE get_k_info_csr;
127: END IF;
128: IF get_primary_strm_type_csr%ISOPEN THEN
129: CLOSE get_primary_strm_type_csr;
130: END IF;
131: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
132:
133: END get_primary_stream_type;
134:
135: PROCEDURE get_primary_stream_type
191: l_primary_strm_name OKL_STRM_TYPE_v.name%Type;
192:
193: BEGIN
194:
195: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
196:
197:
198: OPEN get_k_info_csr (p_khr_id);
199: FETCH get_k_info_csr INTO l_product_id, l_contract_start_date,l_deal_type,l_report_product_id;
218: CLOSE get_primary_strm_type_csr;
219:
220: ELSE
221:
222: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
223: p_msg_name => 'OKL_NO_PDT_FOUND');
224: RAISE Okl_Api.G_EXCEPTION_ERROR;
225:
226: END IF;
220: ELSE
221:
222: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
223: p_msg_name => 'OKL_NO_PDT_FOUND');
224: RAISE Okl_Api.G_EXCEPTION_ERROR;
225:
226: END IF;
227: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
228:
223: p_msg_name => 'OKL_NO_PDT_FOUND');
224: RAISE Okl_Api.G_EXCEPTION_ERROR;
225:
226: END IF;
227: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
228:
229: EXCEPTION
230: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
231: IF get_k_info_csr%ISOPEN THEN
226: END IF;
227: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
228:
229: EXCEPTION
230: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
231: IF get_k_info_csr%ISOPEN THEN
232: CLOSE get_k_info_csr;
233: END IF;
234: IF get_primary_strm_type_csr%ISOPEN THEN
233: END IF;
234: IF get_primary_strm_type_csr%ISOPEN THEN
235: CLOSE get_primary_strm_type_csr;
236: END IF;
237: x_return_status := Okl_Api.G_RET_STS_ERROR ;
238:
239: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
240: IF get_k_info_csr%ISOPEN THEN
241: CLOSE get_k_info_csr;
235: CLOSE get_primary_strm_type_csr;
236: END IF;
237: x_return_status := Okl_Api.G_RET_STS_ERROR ;
238:
239: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
240: IF get_k_info_csr%ISOPEN THEN
241: CLOSE get_k_info_csr;
242: END IF;
243: IF get_primary_strm_type_csr%ISOPEN THEN
242: END IF;
243: IF get_primary_strm_type_csr%ISOPEN THEN
244: CLOSE get_primary_strm_type_csr;
245: END IF;
246: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
247:
248: WHEN OTHERS THEN
249: IF get_k_info_csr%ISOPEN THEN
250: CLOSE get_k_info_csr;
251: END IF;
252: IF get_primary_strm_type_csr%ISOPEN THEN
253: CLOSE get_primary_strm_type_csr;
254: END IF;
255: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
256:
257: END get_primary_stream_type;
258:
259: PROCEDURE get_dependent_stream_type(
319: l_dependetn_sty_id NUMBER;
320: l_dependetn_sty_name OKL_STRM_TYPE_v.name%Type;
321:
322: BEGIN
323: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
324:
325:
326: OPEN get_k_info_csr (p_khr_id);
327: FETCH get_k_info_csr INTO l_product_id, l_contract_start_date,l_deal_type,l_report_product_id;
342: CLOSE get_depend_strm_type_csr;
343:
344: ELSE
345:
346: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
347: p_msg_name => 'OKL_NO_PDT_FOUND');
348: RAISE Okl_Api.G_EXCEPTION_ERROR;
349:
350: END IF;
344: ELSE
345:
346: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
347: p_msg_name => 'OKL_NO_PDT_FOUND');
348: RAISE Okl_Api.G_EXCEPTION_ERROR;
349:
350: END IF;
351: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
352: EXCEPTION
347: p_msg_name => 'OKL_NO_PDT_FOUND');
348: RAISE Okl_Api.G_EXCEPTION_ERROR;
349:
350: END IF;
351: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
352: EXCEPTION
353: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
354: IF get_k_info_csr%ISOPEN THEN
355: CLOSE get_k_info_csr;
349:
350: END IF;
351: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
352: EXCEPTION
353: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
354: IF get_k_info_csr%ISOPEN THEN
355: CLOSE get_k_info_csr;
356: END IF;
357: IF get_depend_strm_type_csr%ISOPEN THEN
356: END IF;
357: IF get_depend_strm_type_csr%ISOPEN THEN
358: CLOSE get_depend_strm_type_csr;
359: END IF;
360: x_return_status := Okl_Api.G_RET_STS_ERROR ;
361:
362: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
363: IF get_k_info_csr%ISOPEN THEN
364: CLOSE get_k_info_csr;
358: CLOSE get_depend_strm_type_csr;
359: END IF;
360: x_return_status := Okl_Api.G_RET_STS_ERROR ;
361:
362: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
363: IF get_k_info_csr%ISOPEN THEN
364: CLOSE get_k_info_csr;
365: END IF;
366: IF get_depend_strm_type_csr%ISOPEN THEN
365: END IF;
366: IF get_depend_strm_type_csr%ISOPEN THEN
367: CLOSE get_depend_strm_type_csr;
368: END IF;
369: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
370:
371: WHEN OTHERS THEN
372: IF get_k_info_csr%ISOPEN THEN
373: CLOSE get_k_info_csr;
374: END IF;
375: IF get_depend_strm_type_csr%ISOPEN THEN
376: CLOSE get_depend_strm_type_csr;
377: END IF;
378: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
379:
380:
381: END get_dependent_stream_type;
382:
456: l_dependetn_sty_id NUMBER;
457: l_dependetn_sty_name OKL_STRM_TYPE_v.name%Type;
458:
459: BEGIN
460: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
461:
462:
463: /*OPEN get_k_info_csr (p_khr_id);
464: FETCH get_k_info_csr INTO l_product_id, l_contract_start_date;
487: CLOSE get_depend_strm_type_csr;
488:
489: ELSE
490:
491: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
492: p_msg_name => 'OKL_NO_PDT_FOUND');
493: RAISE Okl_Api.G_EXCEPTION_ERROR;
494:
495: END IF;
489: ELSE
490:
491: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
492: p_msg_name => 'OKL_NO_PDT_FOUND');
493: RAISE Okl_Api.G_EXCEPTION_ERROR;
494:
495: END IF;
496: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
497: EXCEPTION
492: p_msg_name => 'OKL_NO_PDT_FOUND');
493: RAISE Okl_Api.G_EXCEPTION_ERROR;
494:
495: END IF;
496: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
497: EXCEPTION
498: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
499: IF get_k_info_csr%ISOPEN THEN
500: CLOSE get_k_info_csr;
494:
495: END IF;
496: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
497: EXCEPTION
498: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
499: IF get_k_info_csr%ISOPEN THEN
500: CLOSE get_k_info_csr;
501: END IF;
502: IF get_depend_strm_type_csr%ISOPEN THEN
501: END IF;
502: IF get_depend_strm_type_csr%ISOPEN THEN
503: CLOSE get_depend_strm_type_csr;
504: END IF;
505: x_return_status := Okl_Api.G_RET_STS_ERROR ;
506:
507: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
508: IF get_k_info_csr%ISOPEN THEN
509: CLOSE get_k_info_csr;
503: CLOSE get_depend_strm_type_csr;
504: END IF;
505: x_return_status := Okl_Api.G_RET_STS_ERROR ;
506:
507: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
508: IF get_k_info_csr%ISOPEN THEN
509: CLOSE get_k_info_csr;
510: END IF;
511: IF get_depend_strm_type_csr%ISOPEN THEN
510: END IF;
511: IF get_depend_strm_type_csr%ISOPEN THEN
512: CLOSE get_depend_strm_type_csr;
513: END IF;
514: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
515:
516: WHEN OTHERS THEN
517: IF get_k_info_csr%ISOPEN THEN
518: CLOSE get_k_info_csr;
519: END IF;
520: IF get_depend_strm_type_csr%ISOPEN THEN
521: CLOSE get_depend_strm_type_csr;
522: END IF;
523: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
524:
525:
526: END get_dependent_stream_type;
527:
536: -- End of comments
537:
538: PROCEDURE validate_strm_gen_template(
539: p_api_version IN NUMBER,
540: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
541: x_return_status OUT NOCOPY VARCHAR2,
542: x_msg_count OUT NOCOPY NUMBER,
543: x_msg_data OUT NOCOPY VARCHAR2,
544: p_khr_id IN NUMBER
664: l_kle_id NUMBER;
665: l_lty_code VARCHAR(30);
666: l_sty_id NUMBER;
667: l_sty_name_purpose OKL_STRM_TYPE_B.stream_type_purpose%TYPE;
668: l_primary_flag VARCHAR2(3) := OKL_API.G_FALSE;
669: l_dep_flag VARCHAR2(3) := OKL_API.G_FALSE;
670: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
671: l_primary_sty_id okl_strm_type_b.ID%TYPE;
672: l_primary_sty_name OKL_STRM_TYPE_v.name%TYPE;
665: l_lty_code VARCHAR(30);
666: l_sty_id NUMBER;
667: l_sty_name_purpose OKL_STRM_TYPE_B.stream_type_purpose%TYPE;
668: l_primary_flag VARCHAR2(3) := OKL_API.G_FALSE;
669: l_dep_flag VARCHAR2(3) := OKL_API.G_FALSE;
670: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
671: l_primary_sty_id okl_strm_type_b.ID%TYPE;
672: l_primary_sty_name OKL_STRM_TYPE_v.name%TYPE;
673: l_dependent_sty_id okl_strm_type_b.ID%TYPE;
666: l_sty_id NUMBER;
667: l_sty_name_purpose OKL_STRM_TYPE_B.stream_type_purpose%TYPE;
668: l_primary_flag VARCHAR2(3) := OKL_API.G_FALSE;
669: l_dep_flag VARCHAR2(3) := OKL_API.G_FALSE;
670: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
671: l_primary_sty_id okl_strm_type_b.ID%TYPE;
672: l_primary_sty_name OKL_STRM_TYPE_v.name%TYPE;
673: l_dependent_sty_id okl_strm_type_b.ID%TYPE;
674: l_dependent_sty_name OKL_STRM_TYPE_v.name%TYPE;
672: l_primary_sty_name OKL_STRM_TYPE_v.name%TYPE;
673: l_dependent_sty_id okl_strm_type_b.ID%TYPE;
674: l_dependent_sty_name OKL_STRM_TYPE_v.name%TYPE;
675: l_fee_type VARCHAR2(30);
676: l_recurr_yn VARCHAR2(3):= OKL_API.G_FALSE;
677: l_pass_through_percentage NUMBER;
678: l_rec_period NUMBER;
679: l_expense_amount NUMBER;
680: l_idc NUMBER;
681: l_lookup_strm_purpose OKL_STRM_TYPE_B.stream_type_purpose%TYPE;
682:
683:
684: BEGIN
685: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
686:
687: -- Call start_activity to create savepoint, check compatibility
688: -- and initialize message list
689: x_return_status := okl_api.start_activity (
685: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
686:
687: -- Call start_activity to create savepoint, check compatibility
688: -- and initialize message list
689: x_return_status := okl_api.start_activity (
690: l_api_name
691: ,p_init_msg_list
692: ,'_PVT'
693: ,x_return_status);
691: ,p_init_msg_list
692: ,'_PVT'
693: ,x_return_status);
694: -- Check if activity started successfully
695: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
696: RAISE okl_api.g_exception_unexpected_error;
697: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
698: RAISE okl_api.g_exception_error;
699: END IF;
692: ,'_PVT'
693: ,x_return_status);
694: -- Check if activity started successfully
695: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
696: RAISE okl_api.g_exception_unexpected_error;
697: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
698: RAISE okl_api.g_exception_error;
699: END IF;
700:
693: ,x_return_status);
694: -- Check if activity started successfully
695: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
696: RAISE okl_api.g_exception_unexpected_error;
697: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
698: RAISE okl_api.g_exception_error;
699: END IF;
700:
701: OPEN get_k_info_csr (p_khr_id);
694: -- Check if activity started successfully
695: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN
696: RAISE okl_api.g_exception_unexpected_error;
697: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN
698: RAISE okl_api.g_exception_error;
699: END IF;
700:
701: OPEN get_k_info_csr (p_khr_id);
702: FETCH get_k_info_csr INTO l_deal_type;
733:
734:
735:
736:
737: l_return_status := Okl_Api.G_RET_STS_SUCCESS;
738:
739: IF (l_sty_name_purpose = 'RENT') THEN
740:
741: l_primary_flag := OKL_API.G_TRUE;
737: l_return_status := Okl_Api.G_RET_STS_SUCCESS;
738:
739: IF (l_sty_name_purpose = 'RENT') THEN
740:
741: l_primary_flag := OKL_API.G_TRUE;
742:
743: get_primary_stream_type(
744: p_khr_id => p_khr_id,
745: p_deal_type => l_deal_type,
747: x_return_status => l_return_status,
748: x_primary_sty_id => l_primary_sty_id,
749: x_primary_sty_name => l_primary_sty_name);
750:
751: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
752:
753: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
754: p_msg_name => 'OKL_ISG_STRM_TMPL_VAL_MSG',
755: p_token1 => 'PURPOSE_CODE',
749: x_primary_sty_name => l_primary_sty_name);
750:
751: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
752:
753: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
754: p_msg_name => 'OKL_ISG_STRM_TMPL_VAL_MSG',
755: p_token1 => 'PURPOSE_CODE',
756: p_token1_value => l_sty_name_purpose,
757: p_token2 => 'PRODUCT',
756: p_token1_value => l_sty_name_purpose,
757: p_token2 => 'PRODUCT',
758: p_token2_value => l_deal_type);
759:
760: RAISE OKL_API.G_EXCEPTION_ERROR;
761: END IF;
762:
763:
764:
771: x_return_status => l_return_status,
772: x_dependent_sty_id => l_dependent_sty_id,
773: x_dependent_sty_name =>l_dependent_sty_name);
774:
775: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
776:
777: OPEN get_strm_type_purpose ('RENT_ACCRUAL');
778: FETCH get_strm_type_purpose INTO l_lookup_strm_purpose;
779: CLOSE get_strm_type_purpose;
777: OPEN get_strm_type_purpose ('RENT_ACCRUAL');
778: FETCH get_strm_type_purpose INTO l_lookup_strm_purpose;
779: CLOSE get_strm_type_purpose;
780:
781: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
782: p_msg_name => 'OKL_ISG_STRM_TMPL_VAL_MSG',
783: p_token1 => 'PURPOSE_CODE',
784: p_token1_value => l_lookup_strm_purpose,
785: p_token2 => 'PRODUCT',
786: p_token2_value => l_deal_type);
787:
788:
789:
790: RAISE OKL_API.G_EXCEPTION_ERROR;
791: END IF;
792: END IF;
793:
794: IF (l_deal_type IN ('LOAN', 'LOAN-REVOLVING')) THEN
800: x_return_status => l_return_status,
801: x_dependent_sty_id => l_dependent_sty_id,
802: x_dependent_sty_name =>l_dependent_sty_name);
803:
804: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
805: OPEN get_strm_type_purpose ('LOAN_PAYMENT');
806: FETCH get_strm_type_purpose INTO l_lookup_strm_purpose;
807: CLOSE get_strm_type_purpose;
808:
805: OPEN get_strm_type_purpose ('LOAN_PAYMENT');
806: FETCH get_strm_type_purpose INTO l_lookup_strm_purpose;
807: CLOSE get_strm_type_purpose;
808:
809: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
810: p_msg_name => 'OKL_ISG_STRM_TMPL_VAL_MSG',
811: p_token1 => 'PURPOSE_CODE',
812: p_token1_value => l_lookup_strm_purpose,
813: p_token2 => 'PRODUCT',
830: x_return_status => l_return_status,
831: x_dependent_sty_id => l_dependent_sty_id,
832: x_dependent_sty_name =>l_dependent_sty_name);
833:
834: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
835:
836: OPEN get_strm_type_purpose ('LEASE_INCOME');
837: FETCH get_strm_type_purpose INTO l_lookup_strm_purpose;
838: CLOSE get_strm_type_purpose;
836: OPEN get_strm_type_purpose ('LEASE_INCOME');
837: FETCH get_strm_type_purpose INTO l_lookup_strm_purpose;
838: CLOSE get_strm_type_purpose;
839:
840: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
841: p_msg_name => 'OKL_ISG_STRM_TMPL_VAL_MSG',
842: p_token1 => 'PURPOSE_CODE',
843: p_token1_value => l_lookup_strm_purpose,
844: p_token2 => 'PRODUCT',
843: p_token1_value => l_lookup_strm_purpose,
844: p_token2 => 'PRODUCT',
845: p_token2_value => l_deal_type);
846:
847: RAISE OKL_API.G_EXCEPTION_ERROR;
848: END IF;
849: END IF;
850:
851: IF (l_deal_type IN ('LEASEDF', 'LEASEST', 'LOAN', 'LOAN-REVOLVING')) THEN
857: x_return_status => l_return_status,
858: x_dependent_sty_id => l_dependent_sty_id,
859: x_dependent_sty_name =>l_dependent_sty_name);
860:
861: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
862:
863: OPEN get_strm_type_purpose ('PRINCIPAL_PAYMENT');
864: FETCH get_strm_type_purpose INTO l_lookup_strm_purpose;
865: CLOSE get_strm_type_purpose;
863: OPEN get_strm_type_purpose ('PRINCIPAL_PAYMENT');
864: FETCH get_strm_type_purpose INTO l_lookup_strm_purpose;
865: CLOSE get_strm_type_purpose;
866:
867: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
868: p_msg_name => 'OKL_ISG_STRM_TMPL_VAL_MSG',
869: p_token1 => 'PURPOSE_CODE',
870: p_token1_value => l_lookup_strm_purpose,
871: p_token2 => 'PRODUCT',
880: x_return_status => l_return_status,
881: x_dependent_sty_id => l_dependent_sty_id,
882: x_dependent_sty_name =>l_dependent_sty_name);
883:
884: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
885: OPEN get_strm_type_purpose ('INTEREST_PAYMENT');
886: FETCH get_strm_type_purpose INTO l_lookup_strm_purpose;
887: CLOSE get_strm_type_purpose;
888:
885: OPEN get_strm_type_purpose ('INTEREST_PAYMENT');
886: FETCH get_strm_type_purpose INTO l_lookup_strm_purpose;
887: CLOSE get_strm_type_purpose;
888:
889: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
890: p_msg_name => 'OKL_ISG_STRM_TMPL_VAL_MSG',
891: p_token1 => 'PURPOSE_CODE',
892: p_token1_value => l_lookup_strm_purpose,
893: p_token2 => 'PRODUCT',
902: x_return_status => l_return_status,
903: x_dependent_sty_id => l_dependent_sty_id,
904: x_dependent_sty_name =>l_dependent_sty_name);
905:
906: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
907:
908: OPEN get_strm_type_purpose ('PRINCIPAL_BALANCE');
909: FETCH get_strm_type_purpose INTO l_lookup_strm_purpose;
910: CLOSE get_strm_type_purpose;
908: OPEN get_strm_type_purpose ('PRINCIPAL_BALANCE');
909: FETCH get_strm_type_purpose INTO l_lookup_strm_purpose;
910: CLOSE get_strm_type_purpose;
911:
912: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
913: p_msg_name => 'OKL_ISG_STRM_TMPL_VAL_MSG',
914: p_token1 => 'PURPOSE_CODE',
915: p_token1_value => l_lookup_strm_purpose,
916: p_token2 => 'PRODUCT',
931: x_return_status => l_return_status,
932: x_primary_sty_id => l_primary_sty_id,
933: x_primary_sty_name => l_primary_sty_name);
934:
935: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
936:
937:
938: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
939: p_msg_name => 'OKL_ISG_STRM_TMPL_VAL_MSG',
934:
935: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
936:
937:
938: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
939: p_msg_name => 'OKL_ISG_STRM_TMPL_VAL_MSG',
940: p_token1 => 'PURPOSE_CODE',
941: p_token1_value => l_sty_name_purpose,
942: p_token2 => 'PRODUCT',
959: x_return_status => l_return_status,
960: x_dependent_sty_id => l_dependent_sty_id,
961: x_dependent_sty_name =>l_dependent_sty_name);
962:
963: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
964:
965: OPEN get_strm_type_purpose ('SERVICE_INCOME');
966: FETCH get_strm_type_purpose INTO l_lookup_strm_purpose;
967: CLOSE get_strm_type_purpose;
965: OPEN get_strm_type_purpose ('SERVICE_INCOME');
966: FETCH get_strm_type_purpose INTO l_lookup_strm_purpose;
967: CLOSE get_strm_type_purpose;
968:
969: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
970: p_msg_name => 'OKL_ISG_STRM_TMPL_VAL_MSG',
971: p_token1 => 'PURPOSE_CODE',
972: p_token1_value => l_lookup_strm_purpose,
973: p_token2 => 'PRODUCT',
986: x_return_status => l_return_status,
987: x_dependent_sty_id => l_dependent_sty_id,
988: x_dependent_sty_name =>l_dependent_sty_name);
989:
990: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
991:
992: OPEN get_strm_type_purpose ('AMORTIZED_FEE_EXPENSE');
993: FETCH get_strm_type_purpose INTO l_lookup_strm_purpose;
994: CLOSE get_strm_type_purpose;
992: OPEN get_strm_type_purpose ('AMORTIZED_FEE_EXPENSE');
993: FETCH get_strm_type_purpose INTO l_lookup_strm_purpose;
994: CLOSE get_strm_type_purpose;
995:
996: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
997: p_msg_name => 'OKL_ISG_STRM_TMPL_VAL_MSG',
998: p_token1 => 'PURPOSE_CODE',
999: p_token1_value => l_lookup_strm_purpose,
1000: p_token2 => 'PRODUCT',
1009: x_return_status => l_return_status,
1010: x_dependent_sty_id => l_dependent_sty_id,
1011: x_dependent_sty_name =>l_dependent_sty_name);
1012:
1013: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1014:
1015: OPEN get_strm_type_purpose ('FEE_INCOME');
1016: FETCH get_strm_type_purpose INTO l_lookup_strm_purpose;
1017: CLOSE get_strm_type_purpose;
1015: OPEN get_strm_type_purpose ('FEE_INCOME');
1016: FETCH get_strm_type_purpose INTO l_lookup_strm_purpose;
1017: CLOSE get_strm_type_purpose;
1018:
1019: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
1020: p_msg_name => 'OKL_ISG_STRM_TMPL_VAL_MSG',
1021: p_token1 => 'PURPOSE_CODE',
1022: p_token1_value => l_lookup_strm_purpose,
1023: p_token2 => 'PRODUCT',
1036: x_return_status => l_return_status,
1037: x_dependent_sty_id => l_dependent_sty_id,
1038: x_dependent_sty_name =>l_dependent_sty_name);
1039:
1040: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1041:
1042: OPEN get_strm_type_purpose ('AMORTIZED_FEE_EXPENSE');
1043: FETCH get_strm_type_purpose INTO l_lookup_strm_purpose;
1044: CLOSE get_strm_type_purpose;
1042: OPEN get_strm_type_purpose ('AMORTIZED_FEE_EXPENSE');
1043: FETCH get_strm_type_purpose INTO l_lookup_strm_purpose;
1044: CLOSE get_strm_type_purpose;
1045:
1046: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
1047: p_msg_name => 'OKL_ISG_STRM_TMPL_VAL_MSG',
1048: p_token1 => 'PURPOSE_CODE',
1049: p_token1_value => l_lookup_strm_purpose,
1050: p_token2 => 'PRODUCT',
1060: x_return_status => l_return_status,
1061: x_dependent_sty_id => l_dependent_sty_id,
1062: x_dependent_sty_name =>l_dependent_sty_name);
1063:
1064: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1065:
1066: OPEN get_strm_type_purpose ('PERIODIC_EXPENSE_PAYABLE');
1067: FETCH get_strm_type_purpose INTO l_lookup_strm_purpose;
1068: CLOSE get_strm_type_purpose;
1066: OPEN get_strm_type_purpose ('PERIODIC_EXPENSE_PAYABLE');
1067: FETCH get_strm_type_purpose INTO l_lookup_strm_purpose;
1068: CLOSE get_strm_type_purpose;
1069:
1070: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
1071: p_msg_name => 'OKL_ISG_STRM_TMPL_VAL_MSG',
1072: p_token1 => 'PURPOSE_CODE',
1073: p_token1_value => l_lookup_strm_purpose,
1074: p_token2 => 'PRODUCT',
1085: x_return_status => l_return_status,
1086: x_dependent_sty_id => l_dependent_sty_id,
1087: x_dependent_sty_name =>l_dependent_sty_name);
1088:
1089: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
1090:
1091: OPEN get_strm_type_purpose ('PASS_THRU_REV_ACCRUAL');
1092: FETCH get_strm_type_purpose INTO l_lookup_strm_purpose;
1093: CLOSE get_strm_type_purpose;
1091: OPEN get_strm_type_purpose ('PASS_THRU_REV_ACCRUAL');
1092: FETCH get_strm_type_purpose INTO l_lookup_strm_purpose;
1093: CLOSE get_strm_type_purpose;
1094:
1095: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,
1096: p_msg_name => 'OKL_ISG_STRM_TMPL_VAL_MSG',
1097: p_token1 => 'PURPOSE_CODE',
1098: p_token1_value => l_lookup_strm_purpose,
1099: p_token2 => 'PRODUCT',
1119:
1120:
1121: END LOOP;
1122:
1123: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1124:
1125: okl_api.end_activity(x_msg_count => x_msg_count,
1126: x_msg_data => x_msg_data);
1127:
1121: END LOOP;
1122:
1123: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1124:
1125: okl_api.end_activity(x_msg_count => x_msg_count,
1126: x_msg_data => x_msg_data);
1127:
1128: EXCEPTION
1129:
1126: x_msg_data => x_msg_data);
1127:
1128: EXCEPTION
1129:
1130: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1131:
1132: IF get_k_info_csr%ISOPEN THEN
1133: CLOSE get_k_info_csr;
1134: END IF;
1160: IF c_fee_idc%ISOPEN THEN
1161: CLOSE c_fee_idc;
1162: END IF;
1163:
1164: x_return_status := OKL_API.G_RET_STS_ERROR;
1165:
1166: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1167:
1168: IF get_k_info_csr%ISOPEN THEN
1162: END IF;
1163:
1164: x_return_status := OKL_API.G_RET_STS_ERROR;
1165:
1166: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1167:
1168: IF get_k_info_csr%ISOPEN THEN
1169: CLOSE get_k_info_csr;
1170: END IF;
1196: IF c_fee_idc%ISOPEN THEN
1197: CLOSE c_fee_idc;
1198: END IF;
1199:
1200: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1201:
1202: WHEN OTHERS THEN
1203:
1204: IF get_k_info_csr%ISOPEN THEN
1232: IF c_fee_idc%ISOPEN THEN
1233: CLOSE c_fee_idc;
1234: END IF;
1235:
1236: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1237:
1238:
1239: END validate_strm_gen_template;
1240:
1299: l_deal_type okl_k_headers.deal_type%Type;
1300: l_report_product_id NUMBER;
1301: -- kthiruva bug#4371472 end
1302: BEGIN
1303: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1304:
1305: -- kthiruva bug#4371472 start
1306: FOR tmp_rec in G_GET_K_INFO_CSR (p_khr_id)
1307: LOOP
1331: CLOSE get_depend_strm_type_csr;
1332:
1333: ELSE
1334:
1335: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1336: p_msg_name => 'OKL_NO_PDT_FOUND');
1337: RAISE Okl_Api.G_EXCEPTION_ERROR;
1338:
1339: END IF;
1333: ELSE
1334:
1335: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1336: p_msg_name => 'OKL_NO_PDT_FOUND');
1337: RAISE Okl_Api.G_EXCEPTION_ERROR;
1338:
1339: END IF;
1340: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1341: EXCEPTION
1336: p_msg_name => 'OKL_NO_PDT_FOUND');
1337: RAISE Okl_Api.G_EXCEPTION_ERROR;
1338:
1339: END IF;
1340: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1341: EXCEPTION
1342: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1343: IF get_k_info_csr%ISOPEN THEN
1344: CLOSE get_k_info_csr;
1338:
1339: END IF;
1340: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1341: EXCEPTION
1342: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1343: IF get_k_info_csr%ISOPEN THEN
1344: CLOSE get_k_info_csr;
1345: END IF;
1346: IF get_depend_strm_type_csr%ISOPEN THEN
1345: END IF;
1346: IF get_depend_strm_type_csr%ISOPEN THEN
1347: CLOSE get_depend_strm_type_csr;
1348: END IF;
1349: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1350:
1351: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1352: IF get_k_info_csr%ISOPEN THEN
1353: CLOSE get_k_info_csr;
1347: CLOSE get_depend_strm_type_csr;
1348: END IF;
1349: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1350:
1351: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1352: IF get_k_info_csr%ISOPEN THEN
1353: CLOSE get_k_info_csr;
1354: END IF;
1355: IF get_depend_strm_type_csr%ISOPEN THEN
1354: END IF;
1355: IF get_depend_strm_type_csr%ISOPEN THEN
1356: CLOSE get_depend_strm_type_csr;
1357: END IF;
1358: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1359:
1360: WHEN OTHERS THEN
1361: IF get_k_info_csr%ISOPEN THEN
1362: CLOSE get_k_info_csr;
1363: END IF;
1364: IF get_depend_strm_type_csr%ISOPEN THEN
1365: CLOSE get_depend_strm_type_csr;
1366: END IF;
1367: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1368:
1369:
1370: END get_dependent_stream_type;
1371:
1413: l_dependetn_sty_id NUMBER;
1414: l_dependetn_sty_name OKL_STRM_TYPE_v.name%Type;
1415:
1416: BEGIN
1417: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1418:
1419: IF p_get_k_info_rec.pdt_id IS NULL
1420: THEN
1421: OPEN G_GET_K_INFO_CSR (p_khr_id);
1444: END IF;
1445: CLOSE get_depend_strm_type_csr;
1446:
1447: ELSE
1448: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1449: p_msg_name => 'OKL_NO_PDT_FOUND');
1450: RAISE Okl_Api.G_EXCEPTION_ERROR;
1451: END IF;
1452: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1446:
1447: ELSE
1448: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1449: p_msg_name => 'OKL_NO_PDT_FOUND');
1450: RAISE Okl_Api.G_EXCEPTION_ERROR;
1451: END IF;
1452: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1453: EXCEPTION
1454: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1448: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1449: p_msg_name => 'OKL_NO_PDT_FOUND');
1450: RAISE Okl_Api.G_EXCEPTION_ERROR;
1451: END IF;
1452: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1453: EXCEPTION
1454: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1455: IF G_GET_K_INFO_CSR%ISOPEN THEN
1456: CLOSE G_GET_K_INFO_CSR;
1450: RAISE Okl_Api.G_EXCEPTION_ERROR;
1451: END IF;
1452: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1453: EXCEPTION
1454: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1455: IF G_GET_K_INFO_CSR%ISOPEN THEN
1456: CLOSE G_GET_K_INFO_CSR;
1457: END IF;
1458: IF get_depend_strm_type_csr%ISOPEN THEN
1457: END IF;
1458: IF get_depend_strm_type_csr%ISOPEN THEN
1459: CLOSE get_depend_strm_type_csr;
1460: END IF;
1461: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1462:
1463: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1464: IF G_GET_K_INFO_CSR%ISOPEN THEN
1465: CLOSE G_GET_K_INFO_CSR;
1459: CLOSE get_depend_strm_type_csr;
1460: END IF;
1461: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1462:
1463: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1464: IF G_GET_K_INFO_CSR%ISOPEN THEN
1465: CLOSE G_GET_K_INFO_CSR;
1466: END IF;
1467: IF get_depend_strm_type_csr%ISOPEN THEN
1466: END IF;
1467: IF get_depend_strm_type_csr%ISOPEN THEN
1468: CLOSE get_depend_strm_type_csr;
1469: END IF;
1470: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1471:
1472: WHEN OTHERS THEN
1473: IF G_GET_K_INFO_CSR%ISOPEN THEN
1474: CLOSE G_GET_K_INFO_CSR;
1475: END IF;
1476: IF get_depend_strm_type_csr%ISOPEN THEN
1477: CLOSE get_depend_strm_type_csr;
1478: END IF;
1479: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1480: END get_dep_stream_type;
1481:
1482: -- Overloaded get_dep_stream_type
1483: PROCEDURE get_dep_stream_type(
1526: l_report_product_id NUMBER;
1527: --bug#4371472 kthiruva end
1528:
1529: BEGIN
1530: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1531: IF p_get_k_info_rec.pdt_id IS NULL
1532: THEN
1533: FOR tmp_rec in G_GET_K_INFO_CSR (p_khr_id)
1534: LOOP
1560: x_dependent_sty_name := l_dependetn_sty_name;
1561: END IF;
1562: CLOSE get_depend_strm_type_csr;
1563: ELSE
1564: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1565: p_msg_name => 'OKL_NO_PDT_FOUND');
1566: RAISE Okl_Api.G_EXCEPTION_ERROR;
1567: END IF;
1568: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1562: CLOSE get_depend_strm_type_csr;
1563: ELSE
1564: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1565: p_msg_name => 'OKL_NO_PDT_FOUND');
1566: RAISE Okl_Api.G_EXCEPTION_ERROR;
1567: END IF;
1568: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1569: EXCEPTION
1570: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1564: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,
1565: p_msg_name => 'OKL_NO_PDT_FOUND');
1566: RAISE Okl_Api.G_EXCEPTION_ERROR;
1567: END IF;
1568: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1569: EXCEPTION
1570: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1571: IF G_GET_K_INFO_CSR%ISOPEN THEN
1572: CLOSE G_GET_K_INFO_CSR;
1566: RAISE Okl_Api.G_EXCEPTION_ERROR;
1567: END IF;
1568: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
1569: EXCEPTION
1570: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1571: IF G_GET_K_INFO_CSR%ISOPEN THEN
1572: CLOSE G_GET_K_INFO_CSR;
1573: END IF;
1574: IF get_depend_strm_type_csr%ISOPEN THEN
1573: END IF;
1574: IF get_depend_strm_type_csr%ISOPEN THEN
1575: CLOSE get_depend_strm_type_csr;
1576: END IF;
1577: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1578:
1579: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1580: IF G_GET_K_INFO_CSR%ISOPEN THEN
1581: CLOSE G_GET_K_INFO_CSR;
1575: CLOSE get_depend_strm_type_csr;
1576: END IF;
1577: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1578:
1579: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1580: IF G_GET_K_INFO_CSR%ISOPEN THEN
1581: CLOSE G_GET_K_INFO_CSR;
1582: END IF;
1583: IF get_depend_strm_type_csr%ISOPEN THEN
1582: END IF;
1583: IF get_depend_strm_type_csr%ISOPEN THEN
1584: CLOSE get_depend_strm_type_csr;
1585: END IF;
1586: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1587:
1588: WHEN OTHERS THEN
1589: IF G_GET_K_INFO_CSR%ISOPEN THEN
1590: CLOSE G_GET_K_INFO_CSR;
1591: END IF;
1592: IF get_depend_strm_type_csr%ISOPEN THEN
1593: CLOSE get_depend_strm_type_csr;
1594: END IF;
1595: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1596: END get_dep_stream_type;
1597: -- Added by RGOOTY: End
1598:
1599:
1642: BEGIN
1643:
1644:
1645: -- Initialize the status
1646: l_return_status := OKL_API.G_RET_STS_SUCCESS;
1647:
1648: OPEN c_arrears_option_at_sgt_csr (p_khr_id => p_khr_id);
1649: FETCH c_arrears_option_at_sgt_csr INTO l_arrears_pay_dates_option;
1650: CLOSE c_arrears_option_at_sgt_csr;
1653: x_arrears_pay_dates_option := l_arrears_pay_dates_option;
1654: x_return_status := l_return_status;
1655:
1656: EXCEPTION
1657: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1658: IF c_arrears_option_at_sgt_csr%ISOPEN THEN
1659: CLOSE c_arrears_option_at_sgt_csr;
1660: END IF;
1661: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1657: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1658: IF c_arrears_option_at_sgt_csr%ISOPEN THEN
1659: CLOSE c_arrears_option_at_sgt_csr;
1660: END IF;
1661: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1662:
1663: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1664: IF c_arrears_option_at_sgt_csr%ISOPEN THEN
1665: CLOSE c_arrears_option_at_sgt_csr;
1659: CLOSE c_arrears_option_at_sgt_csr;
1660: END IF;
1661: x_return_status := Okl_Api.G_RET_STS_ERROR ;
1662:
1663: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1664: IF c_arrears_option_at_sgt_csr%ISOPEN THEN
1665: CLOSE c_arrears_option_at_sgt_csr;
1666: END IF;
1667: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1663: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1664: IF c_arrears_option_at_sgt_csr%ISOPEN THEN
1665: CLOSE c_arrears_option_at_sgt_csr;
1666: END IF;
1667: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1668:
1669: WHEN OTHERS THEN
1670: IF c_arrears_option_at_sgt_csr%ISOPEN THEN
1671: CLOSE c_arrears_option_at_sgt_csr;
1670: IF c_arrears_option_at_sgt_csr%ISOPEN THEN
1671: CLOSE c_arrears_option_at_sgt_csr;
1672: END IF;
1673:
1674: OKL_API.SET_MESSAGE (
1675: p_app_name => G_APP_NAME,
1676: p_msg_name => G_DB_ERROR,
1677: p_token1 => G_PROG_NAME_TOKEN,
1678: p_token1_value => l_api_name,
1679: p_token2 => G_SQLCODE_TOKEN,
1680: p_token2_value => sqlcode,
1681: p_token3 => G_SQLERRM_TOKEN,
1682: p_token3_value => sqlerrm);
1683: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
1684: END get_arrears_pay_dates_option;
1685: -- end DJANASWA ER6274342
1686:
1687: END OKL_ISG_UTILS_PVT;