APPS.OKL_ISG_UTILS_PVT dependencies on OKL_API

Line 77: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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;

Line 98: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

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;

Line 100: RAISE Okl_Api.G_EXCEPTION_ERROR;

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:

Line 103: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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

Line 106: WHEN Okl_Api.G_EXCEPTION_ERROR 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

Line 113: x_return_status := Okl_Api.G_RET_STS_ERROR ;

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;

Line 115: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR 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;
118: END IF;
119: IF get_primary_strm_type_csr%ISOPEN THEN

Line 122: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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;

Line 131: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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

Line 195: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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;

Line 222: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

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;

Line 224: RAISE Okl_Api.G_EXCEPTION_ERROR;

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:

Line 227: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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

Line 230: WHEN Okl_Api.G_EXCEPTION_ERROR 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

Line 237: x_return_status := Okl_Api.G_RET_STS_ERROR ;

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;

Line 239: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR 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;
242: END IF;
243: IF get_primary_strm_type_csr%ISOPEN THEN

Line 246: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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;

Line 255: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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(

Line 323: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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;

Line 346: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

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;

Line 348: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

Line 351: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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;

Line 353: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

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

Line 360: x_return_status := Okl_Api.G_RET_STS_ERROR ;

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;

Line 362: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR 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;
365: END IF;
366: IF get_depend_strm_type_csr%ISOPEN THEN

Line 369: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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;

Line 378: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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:

Line 460: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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;

Line 491: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

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;

Line 493: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

Line 496: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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;

Line 498: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

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

Line 505: x_return_status := Okl_Api.G_RET_STS_ERROR ;

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;

Line 507: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR 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;
510: END IF;
511: IF get_depend_strm_type_csr%ISOPEN THEN

Line 514: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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;

Line 523: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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:

Line 540: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

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

Line 668: l_primary_flag VARCHAR2(3) := OKL_API.G_FALSE;

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;

Line 669: l_dep_flag VARCHAR2(3) := OKL_API.G_FALSE;

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;

Line 670: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

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;

Line 676: l_recurr_yn VARCHAR2(3):= OKL_API.G_FALSE;

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;

Line 685: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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 (

Line 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);

Line 695: IF (x_return_status = okl_api.g_ret_sts_unexp_error) THEN

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;

Line 696: RAISE okl_api.g_exception_unexpected_error;

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:

Line 697: ELSIF (x_return_status = okl_api.g_ret_sts_error) THEN

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);

Line 698: RAISE okl_api.g_exception_error;

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;

Line 737: l_return_status := Okl_Api.G_RET_STS_SUCCESS;

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;

Line 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,

Line 751: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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',

Line 753: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,

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',

Line 760: RAISE OKL_API.G_EXCEPTION_ERROR;

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:

Line 775: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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;

Line 781: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,

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',

Line 790: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 804: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS 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:

Line 809: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,

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',

Line 834: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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;

Line 840: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,

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',

Line 847: RAISE OKL_API.G_EXCEPTION_ERROR;

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

Line 861: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS 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;

Line 867: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,

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',

Line 884: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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:

Line 889: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,

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',

Line 906: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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;

Line 912: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,

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',

Line 935: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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',

Line 938: OKL_API.set_message(p_app_name => OKL_API.G_APP_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',
940: p_token1 => 'PURPOSE_CODE',
941: p_token1_value => l_sty_name_purpose,
942: p_token2 => 'PRODUCT',

Line 963: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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;

Line 969: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,

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',

Line 990: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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;

Line 996: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,

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',

Line 1013: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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;

Line 1019: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,

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',

Line 1040: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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;

Line 1046: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,

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',

Line 1064: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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;

Line 1070: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,

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',

Line 1089: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

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;

Line 1095: OKL_API.set_message(p_app_name => OKL_API.G_APP_NAME,

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',

Line 1123: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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:

Line 1125: okl_api.end_activity(x_msg_count => x_msg_count,

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:

Line 1130: WHEN OKL_API.G_EXCEPTION_ERROR THEN

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;

Line 1164: x_return_status := OKL_API.G_RET_STS_ERROR;

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

Line 1166: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR 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;

Line 1200: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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

Line 1236: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

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:

Line 1303: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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

Line 1335: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

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;

Line 1337: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

Line 1340: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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;

Line 1342: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

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

Line 1349: x_return_status := Okl_Api.G_RET_STS_ERROR ;

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;

Line 1351: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR 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;
1354: END IF;
1355: IF get_depend_strm_type_csr%ISOPEN THEN

Line 1358: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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;

Line 1367: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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:

Line 1417: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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);

Line 1448: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

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;

Line 1450: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

Line 1452: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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;

Line 1454: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

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

Line 1461: x_return_status := Okl_Api.G_RET_STS_ERROR ;

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;

Line 1463: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR 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;
1466: END IF;
1467: IF get_depend_strm_type_csr%ISOPEN THEN

Line 1470: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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;

Line 1479: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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(

Line 1530: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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

Line 1564: Okl_Api.SET_MESSAGE(p_app_name => g_app_name,

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;

Line 1566: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

Line 1568: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

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;

Line 1570: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

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

Line 1577: x_return_status := Okl_Api.G_RET_STS_ERROR ;

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;

Line 1579: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR 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;
1582: END IF;
1583: IF get_depend_strm_type_csr%ISOPEN THEN

Line 1586: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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;

Line 1595: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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:

Line 1646: l_return_status := OKL_API.G_RET_STS_SUCCESS;

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;

Line 1657: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

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 ;

Line 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;

Line 1663: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR 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;
1666: END IF;
1667: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 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;

Line 1674: OKL_API.SET_MESSAGE (

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,

Line 1683: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

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;