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

Line 69: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

65: p_chr_id IN NUMBER,
66: x_arrears_yn OUT NOCOPY VARCHAR2,
67: x_periods_tbl OUT NOCOPY periods_tbl_type) IS
68:
69: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
70: l_api_name CONSTANT VARCHAR2(30) := 'GET_PYMT_SCHED_PERIODS';
71: l_api_version CONSTANT NUMBER := 1.0;
72:
73: CURSOR fin_cle_csr(p_chr_id IN NUMBER) IS

Line 117: x_return_status := OKL_API.G_RET_STS_SUCCESS;

113: l_counter NUMBER;
114: l_start_day NUMBER;
115: BEGIN
116:
117: x_return_status := OKL_API.G_RET_STS_SUCCESS;
118:
119: OPEN fin_cle_csr(p_chr_id => p_chr_id);
120: FETCH fin_cle_csr INTO fin_cle_rec;
121: CLOSE fin_cle_csr;

Line 185: WHEN OKL_API.G_EXCEPTION_ERROR Then

181:
182: x_periods_tbl := l_periods_tbl;
183:
184: EXCEPTION
185: WHEN OKL_API.G_EXCEPTION_ERROR Then
186: x_return_status := OKL_API.G_RET_STS_ERROR;
187:
188: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
189: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 186: x_return_status := OKL_API.G_RET_STS_ERROR;

182: x_periods_tbl := l_periods_tbl;
183:
184: EXCEPTION
185: WHEN OKL_API.G_EXCEPTION_ERROR Then
186: x_return_status := OKL_API.G_RET_STS_ERROR;
187:
188: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
189: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
190:

Line 188: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

184: EXCEPTION
185: WHEN OKL_API.G_EXCEPTION_ERROR Then
186: x_return_status := OKL_API.G_RET_STS_ERROR;
187:
188: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
189: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
190:
191: WHEN OTHERS THEN
192: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 189: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

185: WHEN OKL_API.G_EXCEPTION_ERROR Then
186: x_return_status := OKL_API.G_RET_STS_ERROR;
187:
188: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
189: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
190:
191: WHEN OTHERS THEN
192: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
193:

Line 192: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

188: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
189: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
190:
191: WHEN OTHERS THEN
192: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
193:
194: END get_pymt_sched_periods;
195:
196:

Line 219: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

215: -- End of comments
216:
217: PROCEDURE load_ln_streams_dtl(
218: p_api_version IN NUMBER,
219: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
220: x_return_status OUT NOCOPY VARCHAR2,
221: x_msg_count OUT NOCOPY NUMBER,
222: x_msg_data OUT NOCOPY VARCHAR2,
223: p_chr_id IN NUMBER,

Line 312: x_return_status := OKL_API.G_RET_STS_SUCCESS;

308: l_temp_tbl temp_tbl_type;
309:
310: BEGIN
311:
312: x_return_status := OKL_API.G_RET_STS_SUCCESS;
313: -- Call start_activity to create savepoint, check compatibility
314: -- and initialize message list
315: x_return_status := OKL_API.START_ACTIVITY (
316: l_api_name

Line 315: x_return_status := OKL_API.START_ACTIVITY (

311:
312: x_return_status := OKL_API.G_RET_STS_SUCCESS;
313: -- Call start_activity to create savepoint, check compatibility
314: -- and initialize message list
315: x_return_status := OKL_API.START_ACTIVITY (
316: l_api_name
317: ,p_init_msg_list
318: ,'_PVT'
319: ,x_return_status);

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

317: ,p_init_msg_list
318: ,'_PVT'
319: ,x_return_status);
320: -- Check if activity started successfully
321: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
322: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
323: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
324: RAISE OKL_API.G_EXCEPTION_ERROR;
325: END IF;

Line 322: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

318: ,'_PVT'
319: ,x_return_status);
320: -- Check if activity started successfully
321: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
322: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
323: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
324: RAISE OKL_API.G_EXCEPTION_ERROR;
325: END IF;
326:

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

319: ,x_return_status);
320: -- Check if activity started successfully
321: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
322: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
323: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
324: RAISE OKL_API.G_EXCEPTION_ERROR;
325: END IF;
326:
327: --Derive starting Principal Balance

Line 324: RAISE OKL_API.G_EXCEPTION_ERROR;

320: -- Check if activity started successfully
321: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
322: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
323: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
324: RAISE OKL_API.G_EXCEPTION_ERROR;
325: END IF;
326:
327: --Derive starting Principal Balance
328: Okl_Execute_Formula_Pub.EXECUTE(p_api_version => p_api_version,

Line 338: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

334: p_contract_id => p_chr_id,
335: p_line_id => NULL,
336: x_value => l_princ_bal
337: );
338: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
339: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
340: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
341: RAISE OKL_API.G_EXCEPTION_ERROR;
342: END IF;

Line 339: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

335: p_line_id => NULL,
336: x_value => l_princ_bal
337: );
338: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
339: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
340: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
341: RAISE OKL_API.G_EXCEPTION_ERROR;
342: END IF;
343:

Line 340: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

336: x_value => l_princ_bal
337: );
338: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
339: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
340: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
341: RAISE OKL_API.G_EXCEPTION_ERROR;
342: END IF;
343:
344: indx := 1;

Line 341: RAISE OKL_API.G_EXCEPTION_ERROR;

337: );
338: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
339: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
340: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
341: RAISE OKL_API.G_EXCEPTION_ERROR;
342: END IF;
343:
344: indx := 1;
345: l_amort_sched_tbl(indx).principal_balance := l_princ_bal;

Line 368: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);

364: END LOOP;
365: CLOSE c_amort_sch_dtl_csr;
366:
367: x_amort_sched_tbl := l_amort_sched_tbl;
368: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);
369:
370: EXCEPTION
371:
372: ------------------------------------------------------------

Line 376: WHEN OKL_API.G_EXCEPTION_ERROR THEN

372: ------------------------------------------------------------
373: -- Exception handling
374: ------------------------------------------------------------
375:
376: WHEN OKL_API.G_EXCEPTION_ERROR THEN
377: IF c_amort_sch_dtl_csr%ISOPEN THEN
378: CLOSE c_amort_sch_dtl_csr;
379: END IF;
380:

Line 382: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

378: CLOSE c_amort_sch_dtl_csr;
379: END IF;
380:
381:
382: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
383: p_api_name => l_api_name,
384: p_pkg_name => G_PKG_NAME,
385: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
386: x_msg_count => x_msg_count,

Line 385: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

381:
382: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
383: p_api_name => l_api_name,
384: p_pkg_name => G_PKG_NAME,
385: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
386: x_msg_count => x_msg_count,
387: x_msg_data => x_msg_data,
388: p_api_type => '_PVT');
389:

Line 390: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

386: x_msg_count => x_msg_count,
387: x_msg_data => x_msg_data,
388: p_api_type => '_PVT');
389:
390: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
391:
392: IF c_amort_sch_dtl_csr%ISOPEN THEN
393: CLOSE c_amort_sch_dtl_csr;
394: END IF;

Line 397: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

393: CLOSE c_amort_sch_dtl_csr;
394: END IF;
395:
396:
397: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
398: p_api_name => l_api_name,
399: p_pkg_name => G_PKG_NAME,
400: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
401: x_msg_count => x_msg_count,

Line 400: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

396:
397: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
398: p_api_name => l_api_name,
399: p_pkg_name => G_PKG_NAME,
400: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
401: x_msg_count => x_msg_count,
402: x_msg_data => x_msg_data,
403: p_api_type => '_PVT');
404:

Line 411: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

407: CLOSE c_amort_sch_dtl_csr;
408: END IF;
409:
410:
411: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
412: p_api_name => l_api_name,
413: p_pkg_name => G_PKG_NAME,
414: p_exc_name => 'OTHERS',
415: x_msg_count => x_msg_count,

Line 475: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

471: -- End of comments
472:
473: PROCEDURE load_ln_streams_summ(
474: p_api_version IN NUMBER,
475: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
476: x_return_status OUT NOCOPY VARCHAR2,
477: x_msg_count OUT NOCOPY NUMBER,
478: x_msg_data OUT NOCOPY VARCHAR2,
479: p_chr_id IN NUMBER,

Line 566: x_return_status := OKL_API.G_RET_STS_SUCCESS;

562:
563: l_period_date DATE;
564: BEGIN
565:
566: x_return_status := OKL_API.G_RET_STS_SUCCESS;
567: -- Call start_activity to create savepoint, check compatibility
568: -- and initialize message list
569: x_return_status := OKL_API.START_ACTIVITY (
570: l_api_name

Line 569: x_return_status := OKL_API.START_ACTIVITY (

565:
566: x_return_status := OKL_API.G_RET_STS_SUCCESS;
567: -- Call start_activity to create savepoint, check compatibility
568: -- and initialize message list
569: x_return_status := OKL_API.START_ACTIVITY (
570: l_api_name
571: ,p_init_msg_list
572: ,'_PVT'
573: ,x_return_status);

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

571: ,p_init_msg_list
572: ,'_PVT'
573: ,x_return_status);
574: -- Check if activity started successfully
575: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
576: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
577: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
578: RAISE OKL_API.G_EXCEPTION_ERROR;
579: END IF;

Line 576: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

572: ,'_PVT'
573: ,x_return_status);
574: -- Check if activity started successfully
575: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
576: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
577: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
578: RAISE OKL_API.G_EXCEPTION_ERROR;
579: END IF;
580:

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

573: ,x_return_status);
574: -- Check if activity started successfully
575: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
576: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
577: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
578: RAISE OKL_API.G_EXCEPTION_ERROR;
579: END IF;
580:
581:

Line 578: RAISE OKL_API.G_EXCEPTION_ERROR;

574: -- Check if activity started successfully
575: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
576: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
577: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
578: RAISE OKL_API.G_EXCEPTION_ERROR;
579: END IF;
580:
581:
582:

Line 594: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

590: x_arrears_yn => l_arrears_yn,
591: x_periods_tbl => l_periods_tbl
592: );
593:
594: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
595: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
596: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
597: RAISE Okl_Api.G_EXCEPTION_ERROR;
598: END IF;

Line 595: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

591: x_periods_tbl => l_periods_tbl
592: );
593:
594: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
595: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
596: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
597: RAISE Okl_Api.G_EXCEPTION_ERROR;
598: END IF;
599:

Line 596: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

592: );
593:
594: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
595: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
596: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
597: RAISE Okl_Api.G_EXCEPTION_ERROR;
598: END IF;
599:
600: --Derive starting Principal Balance

Line 597: RAISE Okl_Api.G_EXCEPTION_ERROR;

593:
594: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
595: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
596: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
597: RAISE Okl_Api.G_EXCEPTION_ERROR;
598: END IF;
599:
600: --Derive starting Principal Balance
601: Okl_Execute_Formula_Pub.EXECUTE(p_api_version => p_api_version,

Line 611: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

607: p_contract_id => p_chr_id,
608: p_line_id => NULL,
609: x_value => l_princ_bal
610: );
611: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
612: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
613: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
614: RAISE OKL_API.G_EXCEPTION_ERROR;
615: END IF;

Line 612: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

608: p_line_id => NULL,
609: x_value => l_princ_bal
610: );
611: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
612: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
613: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
614: RAISE OKL_API.G_EXCEPTION_ERROR;
615: END IF;
616:

Line 613: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

609: x_value => l_princ_bal
610: );
611: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
612: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
613: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
614: RAISE OKL_API.G_EXCEPTION_ERROR;
615: END IF;
616:
617: indx := 1;

Line 614: RAISE OKL_API.G_EXCEPTION_ERROR;

610: );
611: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
612: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
613: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
614: RAISE OKL_API.G_EXCEPTION_ERROR;
615: END IF;
616:
617: indx := 1;
618: l_amort_sched_tbl(indx).principal_balance := l_princ_bal;

Line 673: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);

669: EXIT WHEN c_amort_sch_summ_csr%NOTFOUND;
670: END LOOP;
671: CLOSE c_amort_sch_summ_csr;
672: x_amort_sched_tbl := l_amort_sched_tbl;
673: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);
674:
675: EXCEPTION
676:
677: ------------------------------------------------------------

Line 681: WHEN OKL_API.G_EXCEPTION_ERROR THEN

677: ------------------------------------------------------------
678: -- Exception handling
679: ------------------------------------------------------------
680:
681: WHEN OKL_API.G_EXCEPTION_ERROR THEN
682: IF c_amort_sch_summ_csr%ISOPEN THEN
683: CLOSE c_amort_sch_summ_csr;
684: END IF;
685:

Line 690: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

686: IF c_amort_sch_ppd_csr%ISOPEN THEN
687: CLOSE c_amort_sch_ppd_csr;
688: END IF;
689:
690: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
691: p_api_name => l_api_name,
692: p_pkg_name => G_PKG_NAME,
693: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
694: x_msg_count => x_msg_count,

Line 693: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

689:
690: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
691: p_api_name => l_api_name,
692: p_pkg_name => G_PKG_NAME,
693: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
694: x_msg_count => x_msg_count,
695: x_msg_data => x_msg_data,
696: p_api_type => '_PVT');
697:

Line 698: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

694: x_msg_count => x_msg_count,
695: x_msg_data => x_msg_data,
696: p_api_type => '_PVT');
697:
698: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
699:
700: IF c_amort_sch_summ_csr%ISOPEN THEN
701: CLOSE c_amort_sch_summ_csr;
702: END IF;

Line 708: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

704: IF c_amort_sch_ppd_csr%ISOPEN THEN
705: CLOSE c_amort_sch_ppd_csr;
706: END IF;
707:
708: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
709: p_api_name => l_api_name,
710: p_pkg_name => G_PKG_NAME,
711: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
712: x_msg_count => x_msg_count,

Line 711: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

707:
708: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
709: p_api_name => l_api_name,
710: p_pkg_name => G_PKG_NAME,
711: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
712: x_msg_count => x_msg_count,
713: x_msg_data => x_msg_data,
714: p_api_type => '_PVT');
715:

Line 725: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

721: IF c_amort_sch_ppd_csr%ISOPEN THEN
722: CLOSE c_amort_sch_ppd_csr;
723: END IF;
724:
725: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
726: p_api_name => l_api_name,
727: p_pkg_name => G_PKG_NAME,
728: p_exc_name => 'OTHERS',
729: x_msg_count => x_msg_count,

Line 756: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

752: -- End of comments
753:
754: PROCEDURE load_ln_actual_dtl(
755: p_api_version IN NUMBER,
756: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
757: x_return_status OUT NOCOPY VARCHAR2,
758: x_msg_count OUT NOCOPY NUMBER,
759: x_msg_data OUT NOCOPY VARCHAR2,
760: p_chr_id IN NUMBER,

Line 816: x_return_status := OKL_API.G_RET_STS_SUCCESS;

812: l_proj_interest_rate NUMBER;
813:
814: BEGIN
815:
816: x_return_status := OKL_API.G_RET_STS_SUCCESS;
817: -- Call start_activity to create savepoint, check compatibility
818: -- and initialize message list
819: x_return_status := OKL_API.START_ACTIVITY (
820: l_api_name

Line 819: x_return_status := OKL_API.START_ACTIVITY (

815:
816: x_return_status := OKL_API.G_RET_STS_SUCCESS;
817: -- Call start_activity to create savepoint, check compatibility
818: -- and initialize message list
819: x_return_status := OKL_API.START_ACTIVITY (
820: l_api_name
821: ,p_init_msg_list
822: ,'_PVT'
823: ,x_return_status);

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

821: ,p_init_msg_list
822: ,'_PVT'
823: ,x_return_status);
824: -- Check if activity started successfully
825: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
827: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
828: RAISE OKL_API.G_EXCEPTION_ERROR;
829: END IF;

Line 826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

822: ,'_PVT'
823: ,x_return_status);
824: -- Check if activity started successfully
825: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
827: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
828: RAISE OKL_API.G_EXCEPTION_ERROR;
829: END IF;
830:

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

823: ,x_return_status);
824: -- Check if activity started successfully
825: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
827: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
828: RAISE OKL_API.G_EXCEPTION_ERROR;
829: END IF;
830:
831: --Derive Principal Balance

Line 828: RAISE OKL_API.G_EXCEPTION_ERROR;

824: -- Check if activity started successfully
825: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
826: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
827: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
828: RAISE OKL_API.G_EXCEPTION_ERROR;
829: END IF;
830:
831: --Derive Principal Balance
832: Okl_Execute_Formula_Pub.EXECUTE(p_api_version => p_api_version,

Line 842: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

838: p_contract_id => p_chr_id,
839: p_line_id => NULL,
840: x_value => l_principal_balance
841: );
842: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
843: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
844: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
845: RAISE OKL_API.G_EXCEPTION_ERROR;
846: END IF;

Line 843: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

839: p_line_id => NULL,
840: x_value => l_principal_balance
841: );
842: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
843: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
844: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
845: RAISE OKL_API.G_EXCEPTION_ERROR;
846: END IF;
847:

Line 844: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

840: x_value => l_principal_balance
841: );
842: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
843: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
844: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
845: RAISE OKL_API.G_EXCEPTION_ERROR;
846: END IF;
847:
848: l_counter := 1;

Line 845: RAISE OKL_API.G_EXCEPTION_ERROR;

841: );
842: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
843: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
844: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
845: RAISE OKL_API.G_EXCEPTION_ERROR;
846: END IF;
847:
848: l_counter := 1;
849: l_amort_sched_tbl(l_counter).principal_balance := l_principal_balance;

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

878: x_interest_rate => l_proj_interest_rate,
879: x_schedule_table => l_schedule_tbl,
880: x_return_status => x_return_status);
881:
882: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
883: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
884: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
885: RAISE OKL_API.G_EXCEPTION_ERROR;
886: END IF;

Line 883: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

879: x_schedule_table => l_schedule_tbl,
880: x_return_status => x_return_status);
881:
882: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
883: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
884: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
885: RAISE OKL_API.G_EXCEPTION_ERROR;
886: END IF;
887:

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

880: x_return_status => x_return_status);
881:
882: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
883: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
884: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
885: RAISE OKL_API.G_EXCEPTION_ERROR;
886: END IF;
887:
888: IF (l_schedule_tbl.COUNT > 0) THEN

Line 885: RAISE OKL_API.G_EXCEPTION_ERROR;

881:
882: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
883: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
884: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
885: RAISE OKL_API.G_EXCEPTION_ERROR;
886: END IF;
887:
888: IF (l_schedule_tbl.COUNT > 0) THEN
889:

Line 908: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);

904:
905: x_amort_sched_tbl := l_amort_sched_tbl;
906: x_proj_interest_rate := l_proj_interest_rate;
907:
908: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);
909:
910: EXCEPTION
911:
912: ------------------------------------------------------------

Line 916: WHEN OKL_API.G_EXCEPTION_ERROR THEN

912: ------------------------------------------------------------
913: -- Exception handling
914: ------------------------------------------------------------
915:
916: WHEN OKL_API.G_EXCEPTION_ERROR THEN
917:
918: IF amort_sched_dtl_csr%ISOPEN THEN
919: CLOSE amort_sched_dtl_csr;
920: END IF;

Line 922: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

918: IF amort_sched_dtl_csr%ISOPEN THEN
919: CLOSE amort_sched_dtl_csr;
920: END IF;
921:
922: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
923: p_api_name => l_api_name,
924: p_pkg_name => G_PKG_NAME,
925: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
926: x_msg_count => x_msg_count,

Line 925: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

921:
922: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
923: p_api_name => l_api_name,
924: p_pkg_name => G_PKG_NAME,
925: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
926: x_msg_count => x_msg_count,
927: x_msg_data => x_msg_data,
928: p_api_type => '_PVT');
929:

Line 930: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

926: x_msg_count => x_msg_count,
927: x_msg_data => x_msg_data,
928: p_api_type => '_PVT');
929:
930: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
931:
932: IF amort_sched_dtl_csr%ISOPEN THEN
933: CLOSE amort_sched_dtl_csr;
934: END IF;

Line 936: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

932: IF amort_sched_dtl_csr%ISOPEN THEN
933: CLOSE amort_sched_dtl_csr;
934: END IF;
935:
936: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
937: p_api_name => l_api_name,
938: p_pkg_name => G_PKG_NAME,
939: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
940: x_msg_count => x_msg_count,

Line 939: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

935:
936: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
937: p_api_name => l_api_name,
938: p_pkg_name => G_PKG_NAME,
939: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
940: x_msg_count => x_msg_count,
941: x_msg_data => x_msg_data,
942: p_api_type => '_PVT');
943:

Line 950: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

946: IF amort_sched_dtl_csr%ISOPEN THEN
947: CLOSE amort_sched_dtl_csr;
948: END IF;
949:
950: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
951: p_api_name => l_api_name,
952: p_pkg_name => G_PKG_NAME,
953: p_exc_name => 'OTHERS',
954: x_msg_count => x_msg_count,

Line 979: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

975: -- End of comments
976:
977: PROCEDURE load_ln_actual_summ(
978: p_api_version IN NUMBER,
979: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
980: x_return_status OUT NOCOPY VARCHAR2,
981: x_msg_count OUT NOCOPY NUMBER,
982: x_msg_data OUT NOCOPY VARCHAR2,
983: p_chr_id IN NUMBER,

Line 1045: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1041: l_proj_interest_rate NUMBER;
1042:
1043: BEGIN
1044:
1045: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1046: -- Call start_activity to create savepoint, check compatibility
1047: -- and initialize message list
1048: x_return_status := OKL_API.START_ACTIVITY (
1049: l_api_name

Line 1048: x_return_status := OKL_API.START_ACTIVITY (

1044:
1045: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1046: -- Call start_activity to create savepoint, check compatibility
1047: -- and initialize message list
1048: x_return_status := OKL_API.START_ACTIVITY (
1049: l_api_name
1050: ,p_init_msg_list
1051: ,'_PVT'
1052: ,x_return_status);

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

1050: ,p_init_msg_list
1051: ,'_PVT'
1052: ,x_return_status);
1053: -- Check if activity started successfully
1054: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1055: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1056: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1057: RAISE OKL_API.G_EXCEPTION_ERROR;
1058: END IF;

Line 1055: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1051: ,'_PVT'
1052: ,x_return_status);
1053: -- Check if activity started successfully
1054: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1055: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1056: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1057: RAISE OKL_API.G_EXCEPTION_ERROR;
1058: END IF;
1059:

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

1052: ,x_return_status);
1053: -- Check if activity started successfully
1054: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1055: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1056: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1057: RAISE OKL_API.G_EXCEPTION_ERROR;
1058: END IF;
1059:
1060: --Derive Principal Balance

Line 1057: RAISE OKL_API.G_EXCEPTION_ERROR;

1053: -- Check if activity started successfully
1054: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1055: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1056: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1057: RAISE OKL_API.G_EXCEPTION_ERROR;
1058: END IF;
1059:
1060: --Derive Principal Balance
1061: Okl_Execute_Formula_Pub.EXECUTE(p_api_version => p_api_version,

Line 1071: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1067: p_contract_id => p_chr_id,
1068: p_line_id => NULL,
1069: x_value => l_principal_balance
1070: );
1071: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1072: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1073: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1074: RAISE OKL_API.G_EXCEPTION_ERROR;
1075: END IF;

Line 1072: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1068: p_line_id => NULL,
1069: x_value => l_principal_balance
1070: );
1071: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1072: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1073: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1074: RAISE OKL_API.G_EXCEPTION_ERROR;
1075: END IF;
1076:

Line 1073: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1069: x_value => l_principal_balance
1070: );
1071: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1072: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1073: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1074: RAISE OKL_API.G_EXCEPTION_ERROR;
1075: END IF;
1076:
1077: l_temp_counter := 0;

Line 1074: RAISE OKL_API.G_EXCEPTION_ERROR;

1070: );
1071: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1072: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1073: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1074: RAISE OKL_API.G_EXCEPTION_ERROR;
1075: END IF;
1076:
1077: l_temp_counter := 0;
1078: OPEN amort_sched_dtl_csr(p_chr_id => p_chr_id);

Line 1104: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1100: x_arrears_yn => l_arrears_yn,
1101: x_periods_tbl => l_periods_tbl
1102: );
1103:
1104: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1105: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1106: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1107: RAISE OKL_API.G_EXCEPTION_ERROR;
1108: END IF;

Line 1105: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1101: x_periods_tbl => l_periods_tbl
1102: );
1103:
1104: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1105: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1106: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1107: RAISE OKL_API.G_EXCEPTION_ERROR;
1108: END IF;
1109:

Line 1106: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1102: );
1103:
1104: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1105: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1106: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1107: RAISE OKL_API.G_EXCEPTION_ERROR;
1108: END IF;
1109:
1110: l_counter := 1;

Line 1107: RAISE OKL_API.G_EXCEPTION_ERROR;

1103:
1104: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1105: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1106: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1107: RAISE OKL_API.G_EXCEPTION_ERROR;
1108: END IF;
1109:
1110: l_counter := 1;
1111: l_amort_sched_tbl(l_counter).principal_balance := l_principal_balance;

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

1175: x_interest_rate => l_proj_interest_rate,
1176: x_schedule_table => l_schedule_tbl,
1177: x_return_status => x_return_status);
1178:
1179: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1180: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1181: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1182: RAISE OKL_API.G_EXCEPTION_ERROR;
1183: END IF;

Line 1180: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1176: x_schedule_table => l_schedule_tbl,
1177: x_return_status => x_return_status);
1178:
1179: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1180: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1181: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1182: RAISE OKL_API.G_EXCEPTION_ERROR;
1183: END IF;
1184:

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

1177: x_return_status => x_return_status);
1178:
1179: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1180: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1181: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1182: RAISE OKL_API.G_EXCEPTION_ERROR;
1183: END IF;
1184:
1185: IF (l_schedule_tbl.COUNT > 0 AND l_periods_tbl.COUNT > 0) THEN

Line 1182: RAISE OKL_API.G_EXCEPTION_ERROR;

1178:
1179: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1180: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1181: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1182: RAISE OKL_API.G_EXCEPTION_ERROR;
1183: END IF;
1184:
1185: IF (l_schedule_tbl.COUNT > 0 AND l_periods_tbl.COUNT > 0) THEN
1186:

Line 1255: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);

1251:
1252: x_amort_sched_tbl := l_amort_sched_tbl;
1253: x_proj_interest_rate := l_proj_interest_rate;
1254:
1255: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);
1256:
1257: EXCEPTION
1258:
1259: ------------------------------------------------------------

Line 1263: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1259: ------------------------------------------------------------
1260: -- Exception handling
1261: ------------------------------------------------------------
1262:
1263: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1264:
1265: IF amort_sched_dtl_csr%ISOPEN THEN
1266: CLOSE amort_sched_dtl_csr;
1267: END IF;

Line 1269: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

1265: IF amort_sched_dtl_csr%ISOPEN THEN
1266: CLOSE amort_sched_dtl_csr;
1267: END IF;
1268:
1269: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1270: p_api_name => l_api_name,
1271: p_pkg_name => G_PKG_NAME,
1272: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1273: x_msg_count => x_msg_count,

Line 1272: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1268:
1269: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1270: p_api_name => l_api_name,
1271: p_pkg_name => G_PKG_NAME,
1272: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1273: x_msg_count => x_msg_count,
1274: x_msg_data => x_msg_data,
1275: p_api_type => '_PVT');
1276:

Line 1277: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1273: x_msg_count => x_msg_count,
1274: x_msg_data => x_msg_data,
1275: p_api_type => '_PVT');
1276:
1277: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1278:
1279: IF amort_sched_dtl_csr%ISOPEN THEN
1280: CLOSE amort_sched_dtl_csr;
1281: END IF;

Line 1283: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

1279: IF amort_sched_dtl_csr%ISOPEN THEN
1280: CLOSE amort_sched_dtl_csr;
1281: END IF;
1282:
1283: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1284: p_api_name => l_api_name,
1285: p_pkg_name => G_PKG_NAME,
1286: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1287: x_msg_count => x_msg_count,

Line 1286: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1282:
1283: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1284: p_api_name => l_api_name,
1285: p_pkg_name => G_PKG_NAME,
1286: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1287: x_msg_count => x_msg_count,
1288: x_msg_data => x_msg_data,
1289: p_api_type => '_PVT');
1290:

Line 1297: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

1293: IF amort_sched_dtl_csr%ISOPEN THEN
1294: CLOSE amort_sched_dtl_csr;
1295: END IF;
1296:
1297: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1298: p_api_name => l_api_name,
1299: p_pkg_name => G_PKG_NAME,
1300: p_exc_name => 'OTHERS',
1301: x_msg_count => x_msg_count,

Line 1328: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1324: -- End of comments
1325:
1326: PROCEDURE load_ln_float_eb_dtl(
1327: p_api_version IN NUMBER,
1328: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1329: x_return_status OUT NOCOPY VARCHAR2,
1330: x_msg_count OUT NOCOPY NUMBER,
1331: x_msg_data OUT NOCOPY VARCHAR2,
1332: p_chr_id IN NUMBER,

Line 1448: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1444: l_counter NUMBER;
1445:
1446: BEGIN
1447:
1448: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1449: -- Call start_activity to create savepoint, check compatibility
1450: -- and initialize message list
1451: x_return_status := OKL_API.START_ACTIVITY (
1452: l_api_name

Line 1451: x_return_status := OKL_API.START_ACTIVITY (

1447:
1448: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1449: -- Call start_activity to create savepoint, check compatibility
1450: -- and initialize message list
1451: x_return_status := OKL_API.START_ACTIVITY (
1452: l_api_name
1453: ,p_init_msg_list
1454: ,'_PVT'
1455: ,x_return_status);

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

1453: ,p_init_msg_list
1454: ,'_PVT'
1455: ,x_return_status);
1456: -- Check if activity started successfully
1457: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1458: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1459: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1460: RAISE OKL_API.G_EXCEPTION_ERROR;
1461: END IF;

Line 1458: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1454: ,'_PVT'
1455: ,x_return_status);
1456: -- Check if activity started successfully
1457: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1458: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1459: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1460: RAISE OKL_API.G_EXCEPTION_ERROR;
1461: END IF;
1462:

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

1455: ,x_return_status);
1456: -- Check if activity started successfully
1457: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1458: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1459: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1460: RAISE OKL_API.G_EXCEPTION_ERROR;
1461: END IF;
1462:
1463: --Derive Principal Balance

Line 1460: RAISE OKL_API.G_EXCEPTION_ERROR;

1456: -- Check if activity started successfully
1457: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1458: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1459: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1460: RAISE OKL_API.G_EXCEPTION_ERROR;
1461: END IF;
1462:
1463: --Derive Principal Balance
1464: Okl_Execute_Formula_Pub.EXECUTE(p_api_version => p_api_version,

Line 1474: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1470: p_contract_id => p_chr_id,
1471: p_line_id => NULL,
1472: x_value => l_principal_balance
1473: );
1474: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1475: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1476: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1477: RAISE OKL_API.G_EXCEPTION_ERROR;
1478: END IF;

Line 1475: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1471: p_line_id => NULL,
1472: x_value => l_principal_balance
1473: );
1474: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1475: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1476: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1477: RAISE OKL_API.G_EXCEPTION_ERROR;
1478: END IF;
1479:

Line 1476: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1472: x_value => l_principal_balance
1473: );
1474: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1475: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1476: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1477: RAISE OKL_API.G_EXCEPTION_ERROR;
1478: END IF;
1479:
1480: OPEN last_bill_date_csr(p_chr_id => p_chr_id);

Line 1477: RAISE OKL_API.G_EXCEPTION_ERROR;

1473: );
1474: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1475: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1476: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1477: RAISE OKL_API.G_EXCEPTION_ERROR;
1478: END IF;
1479:
1480: OPEN last_bill_date_csr(p_chr_id => p_chr_id);
1481: FETCH last_bill_date_csr INTO l_last_bill_date;

Line 1514: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);

1510: CLOSE amort_sched_dtl_csr;
1511:
1512: x_amort_sched_tbl := l_amort_sched_tbl;
1513:
1514: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);
1515:
1516: EXCEPTION
1517:
1518: ------------------------------------------------------------

Line 1522: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1518: ------------------------------------------------------------
1519: -- Exception handling
1520: ------------------------------------------------------------
1521:
1522: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1523:
1524: IF amort_sched_dtl_csr%ISOPEN THEN
1525: CLOSE amort_sched_dtl_csr;
1526: END IF;

Line 1528: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

1524: IF amort_sched_dtl_csr%ISOPEN THEN
1525: CLOSE amort_sched_dtl_csr;
1526: END IF;
1527:
1528: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1529: p_api_name => l_api_name,
1530: p_pkg_name => G_PKG_NAME,
1531: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1532: x_msg_count => x_msg_count,

Line 1531: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1527:
1528: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1529: p_api_name => l_api_name,
1530: p_pkg_name => G_PKG_NAME,
1531: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1532: x_msg_count => x_msg_count,
1533: x_msg_data => x_msg_data,
1534: p_api_type => '_PVT');
1535:

Line 1536: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1532: x_msg_count => x_msg_count,
1533: x_msg_data => x_msg_data,
1534: p_api_type => '_PVT');
1535:
1536: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1537:
1538: IF amort_sched_dtl_csr%ISOPEN THEN
1539: CLOSE amort_sched_dtl_csr;
1540: END IF;

Line 1542: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

1538: IF amort_sched_dtl_csr%ISOPEN THEN
1539: CLOSE amort_sched_dtl_csr;
1540: END IF;
1541:
1542: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1543: p_api_name => l_api_name,
1544: p_pkg_name => G_PKG_NAME,
1545: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1546: x_msg_count => x_msg_count,

Line 1545: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1541:
1542: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1543: p_api_name => l_api_name,
1544: p_pkg_name => G_PKG_NAME,
1545: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1546: x_msg_count => x_msg_count,
1547: x_msg_data => x_msg_data,
1548: p_api_type => '_PVT');
1549:

Line 1556: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

1552: IF amort_sched_dtl_csr%ISOPEN THEN
1553: CLOSE amort_sched_dtl_csr;
1554: END IF;
1555:
1556: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1557: p_api_name => l_api_name,
1558: p_pkg_name => G_PKG_NAME,
1559: p_exc_name => 'OTHERS',
1560: x_msg_count => x_msg_count,

Line 1586: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1582: -- End of comments
1583:
1584: PROCEDURE load_ln_float_eb_summ(
1585: p_api_version IN NUMBER,
1586: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1587: x_return_status OUT NOCOPY VARCHAR2,
1588: x_msg_count OUT NOCOPY NUMBER,
1589: x_msg_data OUT NOCOPY VARCHAR2,
1590: p_chr_id IN NUMBER,

Line 1683: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1679: l_periods_tbl periods_tbl_type;
1680: l_arrears_yn VARCHAR2(1);
1681: BEGIN
1682:
1683: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1684: -- Call start_activity to create savepoint, check compatibility
1685: -- and initialize message list
1686: x_return_status := OKL_API.START_ACTIVITY (
1687: l_api_name

Line 1686: x_return_status := OKL_API.START_ACTIVITY (

1682:
1683: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1684: -- Call start_activity to create savepoint, check compatibility
1685: -- and initialize message list
1686: x_return_status := OKL_API.START_ACTIVITY (
1687: l_api_name
1688: ,p_init_msg_list
1689: ,'_PVT'
1690: ,x_return_status);

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

1688: ,p_init_msg_list
1689: ,'_PVT'
1690: ,x_return_status);
1691: -- Check if activity started successfully
1692: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1693: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1694: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1695: RAISE OKL_API.G_EXCEPTION_ERROR;
1696: END IF;

Line 1693: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1689: ,'_PVT'
1690: ,x_return_status);
1691: -- Check if activity started successfully
1692: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1693: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1694: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1695: RAISE OKL_API.G_EXCEPTION_ERROR;
1696: END IF;
1697:

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

1690: ,x_return_status);
1691: -- Check if activity started successfully
1692: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1693: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1694: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1695: RAISE OKL_API.G_EXCEPTION_ERROR;
1696: END IF;
1697:
1698: --Derive Principal Balance

Line 1695: RAISE OKL_API.G_EXCEPTION_ERROR;

1691: -- Check if activity started successfully
1692: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1693: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1694: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1695: RAISE OKL_API.G_EXCEPTION_ERROR;
1696: END IF;
1697:
1698: --Derive Principal Balance
1699: Okl_Execute_Formula_Pub.EXECUTE(p_api_version => p_api_version,

Line 1709: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1705: p_contract_id => p_chr_id,
1706: p_line_id => NULL,
1707: x_value => l_principal_balance
1708: );
1709: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1710: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1711: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1712: RAISE OKL_API.G_EXCEPTION_ERROR;
1713: END IF;

Line 1710: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1706: p_line_id => NULL,
1707: x_value => l_principal_balance
1708: );
1709: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1710: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1711: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1712: RAISE OKL_API.G_EXCEPTION_ERROR;
1713: END IF;
1714:

Line 1711: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1707: x_value => l_principal_balance
1708: );
1709: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1710: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1711: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1712: RAISE OKL_API.G_EXCEPTION_ERROR;
1713: END IF;
1714:
1715: OPEN last_bill_date_csr(p_chr_id => p_chr_id);

Line 1712: RAISE OKL_API.G_EXCEPTION_ERROR;

1708: );
1709: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1710: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1711: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1712: RAISE OKL_API.G_EXCEPTION_ERROR;
1713: END IF;
1714:
1715: OPEN last_bill_date_csr(p_chr_id => p_chr_id);
1716: FETCH last_bill_date_csr INTO l_last_bill_date;

Line 1753: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1749: x_arrears_yn => l_arrears_yn,
1750: x_periods_tbl => l_periods_tbl
1751: );
1752:
1753: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1754: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1755: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1756: RAISE OKL_API.G_EXCEPTION_ERROR;
1757: END IF;

Line 1754: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1750: x_periods_tbl => l_periods_tbl
1751: );
1752:
1753: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1754: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1755: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1756: RAISE OKL_API.G_EXCEPTION_ERROR;
1757: END IF;
1758:

Line 1755: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1751: );
1752:
1753: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1754: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1755: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1756: RAISE OKL_API.G_EXCEPTION_ERROR;
1757: END IF;
1758:
1759: l_counter := 1;

Line 1756: RAISE OKL_API.G_EXCEPTION_ERROR;

1752:
1753: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1754: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1755: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1756: RAISE OKL_API.G_EXCEPTION_ERROR;
1757: END IF;
1758:
1759: l_counter := 1;
1760: l_amort_sched_tbl(l_counter).principal_balance := l_principal_balance;

Line 1817: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);

1813: END IF;
1814:
1815: x_amort_sched_tbl := l_amort_sched_tbl;
1816:
1817: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);
1818:
1819: EXCEPTION
1820:
1821: ------------------------------------------------------------

Line 1825: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1821: ------------------------------------------------------------
1822: -- Exception handling
1823: ------------------------------------------------------------
1824:
1825: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1826:
1827: IF amort_sched_dtl_csr%ISOPEN THEN
1828: CLOSE amort_sched_dtl_csr;
1829: END IF;

Line 1831: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

1827: IF amort_sched_dtl_csr%ISOPEN THEN
1828: CLOSE amort_sched_dtl_csr;
1829: END IF;
1830:
1831: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1832: p_api_name => l_api_name,
1833: p_pkg_name => G_PKG_NAME,
1834: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1835: x_msg_count => x_msg_count,

Line 1834: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

1830:
1831: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1832: p_api_name => l_api_name,
1833: p_pkg_name => G_PKG_NAME,
1834: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1835: x_msg_count => x_msg_count,
1836: x_msg_data => x_msg_data,
1837: p_api_type => '_PVT');
1838:

Line 1839: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1835: x_msg_count => x_msg_count,
1836: x_msg_data => x_msg_data,
1837: p_api_type => '_PVT');
1838:
1839: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1840:
1841: IF amort_sched_dtl_csr%ISOPEN THEN
1842: CLOSE amort_sched_dtl_csr;
1843: END IF;

Line 1845: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

1841: IF amort_sched_dtl_csr%ISOPEN THEN
1842: CLOSE amort_sched_dtl_csr;
1843: END IF;
1844:
1845: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1846: p_api_name => l_api_name,
1847: p_pkg_name => G_PKG_NAME,
1848: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1849: x_msg_count => x_msg_count,

Line 1848: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

1844:
1845: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1846: p_api_name => l_api_name,
1847: p_pkg_name => G_PKG_NAME,
1848: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1849: x_msg_count => x_msg_count,
1850: x_msg_data => x_msg_data,
1851: p_api_type => '_PVT');
1852:

Line 1859: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

1855: IF amort_sched_dtl_csr%ISOPEN THEN
1856: CLOSE amort_sched_dtl_csr;
1857: END IF;
1858:
1859: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1860: p_api_name => l_api_name,
1861: p_pkg_name => G_PKG_NAME,
1862: p_exc_name => 'OTHERS',
1863: x_msg_count => x_msg_count,

Line 1891: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1887: -- End of comments
1888:
1889: PROCEDURE load_ln_cc_strm_dtl(
1890: p_api_version IN NUMBER,
1891: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1892: x_return_status OUT NOCOPY VARCHAR2,
1893: x_msg_count OUT NOCOPY NUMBER,
1894: x_msg_data OUT NOCOPY VARCHAR2,
1895: p_chr_id IN NUMBER,

Line 2011: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2007: l_max_bill_counter NUMBER;
2008:
2009: BEGIN
2010:
2011: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2012: -- Call start_activity to create savepoint, check compatibility
2013: -- and initialize message list
2014: x_return_status := OKL_API.START_ACTIVITY (
2015: l_api_name

Line 2014: x_return_status := OKL_API.START_ACTIVITY (

2010:
2011: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2012: -- Call start_activity to create savepoint, check compatibility
2013: -- and initialize message list
2014: x_return_status := OKL_API.START_ACTIVITY (
2015: l_api_name
2016: ,p_init_msg_list
2017: ,'_PVT'
2018: ,x_return_status);

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

2016: ,p_init_msg_list
2017: ,'_PVT'
2018: ,x_return_status);
2019: -- Check if activity started successfully
2020: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2021: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2022: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2023: RAISE OKL_API.G_EXCEPTION_ERROR;
2024: END IF;

Line 2021: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2017: ,'_PVT'
2018: ,x_return_status);
2019: -- Check if activity started successfully
2020: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2021: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2022: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2023: RAISE OKL_API.G_EXCEPTION_ERROR;
2024: END IF;
2025:

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

2018: ,x_return_status);
2019: -- Check if activity started successfully
2020: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2021: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2022: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2023: RAISE OKL_API.G_EXCEPTION_ERROR;
2024: END IF;
2025:
2026: --Derive Principal Balance

Line 2023: RAISE OKL_API.G_EXCEPTION_ERROR;

2019: -- Check if activity started successfully
2020: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2021: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2022: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2023: RAISE OKL_API.G_EXCEPTION_ERROR;
2024: END IF;
2025:
2026: --Derive Principal Balance
2027: Okl_Execute_Formula_Pub.EXECUTE(p_api_version => p_api_version,

Line 2037: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2033: p_contract_id => p_chr_id,
2034: p_line_id => NULL,
2035: x_value => l_principal_balance
2036: );
2037: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2038: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2039: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2040: RAISE OKL_API.G_EXCEPTION_ERROR;
2041: END IF;

Line 2038: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2034: p_line_id => NULL,
2035: x_value => l_principal_balance
2036: );
2037: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2038: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2039: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2040: RAISE OKL_API.G_EXCEPTION_ERROR;
2041: END IF;
2042:

Line 2039: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2035: x_value => l_principal_balance
2036: );
2037: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2038: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2039: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2040: RAISE OKL_API.G_EXCEPTION_ERROR;
2041: END IF;
2042:
2043: l_max_bill_counter := 0;

Line 2040: RAISE OKL_API.G_EXCEPTION_ERROR;

2036: );
2037: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2038: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2039: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2040: RAISE OKL_API.G_EXCEPTION_ERROR;
2041: END IF;
2042:
2043: l_max_bill_counter := 0;
2044: l_temp_counter := 0;

Line 2094: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);

2090: END IF;
2091:
2092: x_amort_sched_tbl := l_amort_sched_tbl;
2093:
2094: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);
2095:
2096: EXCEPTION
2097:
2098: ------------------------------------------------------------

Line 2102: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2098: ------------------------------------------------------------
2099: -- Exception handling
2100: ------------------------------------------------------------
2101:
2102: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2103:
2104: IF amort_sched_dtl_csr%ISOPEN THEN
2105: CLOSE amort_sched_dtl_csr;
2106: END IF;

Line 2108: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2104: IF amort_sched_dtl_csr%ISOPEN THEN
2105: CLOSE amort_sched_dtl_csr;
2106: END IF;
2107:
2108: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2109: p_api_name => l_api_name,
2110: p_pkg_name => G_PKG_NAME,
2111: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2112: x_msg_count => x_msg_count,

Line 2111: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

2107:
2108: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2109: p_api_name => l_api_name,
2110: p_pkg_name => G_PKG_NAME,
2111: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2112: x_msg_count => x_msg_count,
2113: x_msg_data => x_msg_data,
2114: p_api_type => '_PVT');
2115:

Line 2116: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2112: x_msg_count => x_msg_count,
2113: x_msg_data => x_msg_data,
2114: p_api_type => '_PVT');
2115:
2116: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2117:
2118: IF amort_sched_dtl_csr%ISOPEN THEN
2119: CLOSE amort_sched_dtl_csr;
2120: END IF;

Line 2122: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2118: IF amort_sched_dtl_csr%ISOPEN THEN
2119: CLOSE amort_sched_dtl_csr;
2120: END IF;
2121:
2122: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2123: p_api_name => l_api_name,
2124: p_pkg_name => G_PKG_NAME,
2125: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2126: x_msg_count => x_msg_count,

Line 2125: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

2121:
2122: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2123: p_api_name => l_api_name,
2124: p_pkg_name => G_PKG_NAME,
2125: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2126: x_msg_count => x_msg_count,
2127: x_msg_data => x_msg_data,
2128: p_api_type => '_PVT');
2129:

Line 2136: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2132: IF amort_sched_dtl_csr%ISOPEN THEN
2133: CLOSE amort_sched_dtl_csr;
2134: END IF;
2135:
2136: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2137: p_api_name => l_api_name,
2138: p_pkg_name => G_PKG_NAME,
2139: p_exc_name => 'OTHERS',
2140: x_msg_count => x_msg_count,

Line 2166: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2162: -- End of comments
2163:
2164: PROCEDURE load_ln_cc_strm_summ(
2165: p_api_version IN NUMBER,
2166: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2167: x_return_status OUT NOCOPY VARCHAR2,
2168: x_msg_count OUT NOCOPY NUMBER,
2169: x_msg_data OUT NOCOPY VARCHAR2,
2170: p_chr_id IN NUMBER,

Line 2231: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2227: l_max_bill_counter NUMBER;
2228:
2229: BEGIN
2230:
2231: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2232: -- Call start_activity to create savepoint, check compatibility
2233: -- and initialize message list
2234: x_return_status := OKL_API.START_ACTIVITY (
2235: l_api_name

Line 2234: x_return_status := OKL_API.START_ACTIVITY (

2230:
2231: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2232: -- Call start_activity to create savepoint, check compatibility
2233: -- and initialize message list
2234: x_return_status := OKL_API.START_ACTIVITY (
2235: l_api_name
2236: ,p_init_msg_list
2237: ,'_PVT'
2238: ,x_return_status);

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

2236: ,p_init_msg_list
2237: ,'_PVT'
2238: ,x_return_status);
2239: -- Check if activity started successfully
2240: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2241: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2242: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2243: RAISE OKL_API.G_EXCEPTION_ERROR;
2244: END IF;

Line 2241: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2237: ,'_PVT'
2238: ,x_return_status);
2239: -- Check if activity started successfully
2240: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2241: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2242: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2243: RAISE OKL_API.G_EXCEPTION_ERROR;
2244: END IF;
2245:

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

2238: ,x_return_status);
2239: -- Check if activity started successfully
2240: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2241: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2242: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2243: RAISE OKL_API.G_EXCEPTION_ERROR;
2244: END IF;
2245:
2246: --Derive Principal Balance

Line 2243: RAISE OKL_API.G_EXCEPTION_ERROR;

2239: -- Check if activity started successfully
2240: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2241: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2242: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2243: RAISE OKL_API.G_EXCEPTION_ERROR;
2244: END IF;
2245:
2246: --Derive Principal Balance
2247: Okl_Execute_Formula_Pub.EXECUTE(p_api_version => p_api_version,

Line 2257: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2253: p_contract_id => p_chr_id,
2254: p_line_id => NULL,
2255: x_value => l_principal_balance
2256: );
2257: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2258: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2259: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2260: RAISE OKL_API.G_EXCEPTION_ERROR;
2261: END IF;

Line 2258: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2254: p_line_id => NULL,
2255: x_value => l_principal_balance
2256: );
2257: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2258: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2259: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2260: RAISE OKL_API.G_EXCEPTION_ERROR;
2261: END IF;
2262:

Line 2259: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2255: x_value => l_principal_balance
2256: );
2257: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2258: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2259: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2260: RAISE OKL_API.G_EXCEPTION_ERROR;
2261: END IF;
2262:
2263: l_temp_counter := 0;

Line 2260: RAISE OKL_API.G_EXCEPTION_ERROR;

2256: );
2257: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2258: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2259: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2260: RAISE OKL_API.G_EXCEPTION_ERROR;
2261: END IF;
2262:
2263: l_temp_counter := 0;
2264: OPEN amort_sched_dtl_csr(p_chr_id => p_chr_id);

Line 2296: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2292: x_arrears_yn => l_arrears_yn,
2293: x_periods_tbl => l_periods_tbl
2294: );
2295:
2296: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2297: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2298: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2299: RAISE OKL_API.G_EXCEPTION_ERROR;
2300: END IF;

Line 2297: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2293: x_periods_tbl => l_periods_tbl
2294: );
2295:
2296: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2297: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2298: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2299: RAISE OKL_API.G_EXCEPTION_ERROR;
2300: END IF;
2301:

Line 2298: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2294: );
2295:
2296: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2297: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2298: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2299: RAISE OKL_API.G_EXCEPTION_ERROR;
2300: END IF;
2301:
2302: l_counter := 1;

Line 2299: RAISE OKL_API.G_EXCEPTION_ERROR;

2295:
2296: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2297: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2298: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2299: RAISE OKL_API.G_EXCEPTION_ERROR;
2300: END IF;
2301:
2302: l_counter := 1;
2303: l_amort_sched_tbl(l_counter).principal_balance := l_principal_balance;

Line 2385: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);

2381: END IF;
2382:
2383: x_amort_sched_tbl := l_amort_sched_tbl;
2384:
2385: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);
2386:
2387: EXCEPTION
2388:
2389: ------------------------------------------------------------

Line 2393: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2389: ------------------------------------------------------------
2390: -- Exception handling
2391: ------------------------------------------------------------
2392:
2393: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2394:
2395: IF amort_sched_dtl_csr%ISOPEN THEN
2396: CLOSE amort_sched_dtl_csr;
2397: END IF;

Line 2399: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2395: IF amort_sched_dtl_csr%ISOPEN THEN
2396: CLOSE amort_sched_dtl_csr;
2397: END IF;
2398:
2399: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2400: p_api_name => l_api_name,
2401: p_pkg_name => G_PKG_NAME,
2402: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2403: x_msg_count => x_msg_count,

Line 2402: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

2398:
2399: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2400: p_api_name => l_api_name,
2401: p_pkg_name => G_PKG_NAME,
2402: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2403: x_msg_count => x_msg_count,
2404: x_msg_data => x_msg_data,
2405: p_api_type => '_PVT');
2406:

Line 2407: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2403: x_msg_count => x_msg_count,
2404: x_msg_data => x_msg_data,
2405: p_api_type => '_PVT');
2406:
2407: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2408:
2409: IF amort_sched_dtl_csr%ISOPEN THEN
2410: CLOSE amort_sched_dtl_csr;
2411: END IF;

Line 2413: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2409: IF amort_sched_dtl_csr%ISOPEN THEN
2410: CLOSE amort_sched_dtl_csr;
2411: END IF;
2412:
2413: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2414: p_api_name => l_api_name,
2415: p_pkg_name => G_PKG_NAME,
2416: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2417: x_msg_count => x_msg_count,

Line 2416: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

2412:
2413: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2414: p_api_name => l_api_name,
2415: p_pkg_name => G_PKG_NAME,
2416: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2417: x_msg_count => x_msg_count,
2418: x_msg_data => x_msg_data,
2419: p_api_type => '_PVT');
2420:

Line 2427: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2423: IF amort_sched_dtl_csr%ISOPEN THEN
2424: CLOSE amort_sched_dtl_csr;
2425: END IF;
2426:
2427: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2428: p_api_name => l_api_name,
2429: p_pkg_name => G_PKG_NAME,
2430: p_exc_name => 'OTHERS',
2431: x_msg_count => x_msg_count,

Line 2446: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2442: x_msg_data OUT NOCOPY VARCHAR2,
2443: p_chr_id IN NUMBER,
2444: x_schedule_match_yn OUT NOCOPY VARCHAR2) IS
2445:
2446: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2447: l_api_name CONSTANT VARCHAR2(30) := 'CHECK_PAYMENT_SCHEDULE';
2448: l_api_version CONSTANT NUMBER := 1.0;
2449:
2450: TYPE l_payment_details_rec IS RECORD (

Line 2565: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

2561: END IF;
2562: END;
2563:
2564: BEGIN
2565: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2566: x_schedule_match_yn := 'N';
2567:
2568: l_payment_table_counter := 1;
2569: OPEN l_payment_lines_csr;

Line 2668: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2664: END IF;
2665:
2666: EXCEPTION
2667: WHEN schedule_mismatch THEN
2668: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2669: x_schedule_match_yn := 'N';
2670:
2671: WHEN OTHERS THEN
2672: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2672: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2668: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2669: x_schedule_match_yn := 'N';
2670:
2671: WHEN OTHERS THEN
2672: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2673: x_schedule_match_yn := 'N';
2674:
2675: END check_payment_schedule;
2676:

Line 2679: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2675: END check_payment_schedule;
2676:
2677: PROCEDURE load_loan_amort_schedule(
2678: p_api_version IN NUMBER,
2679: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2680: x_return_status OUT NOCOPY VARCHAR2,
2681: x_msg_count OUT NOCOPY NUMBER,
2682: x_msg_data OUT NOCOPY VARCHAR2,
2683: p_chr_id IN NUMBER,

Line 2716: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2712: l_proj_interest_rate NUMBER;
2713:
2714: BEGIN
2715:
2716: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2717: -- Call start_activity to create savepoint, check compatibility
2718: -- and initialize message list
2719: x_return_status := OKL_API.START_ACTIVITY (
2720: l_api_name

Line 2719: x_return_status := OKL_API.START_ACTIVITY (

2715:
2716: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2717: -- Call start_activity to create savepoint, check compatibility
2718: -- and initialize message list
2719: x_return_status := OKL_API.START_ACTIVITY (
2720: l_api_name
2721: ,p_init_msg_list
2722: ,'_PVT'
2723: ,x_return_status);

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

2721: ,p_init_msg_list
2722: ,'_PVT'
2723: ,x_return_status);
2724: -- Check if activity started successfully
2725: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2726: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2727: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2728: RAISE OKL_API.G_EXCEPTION_ERROR;
2729: END IF;

Line 2726: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2722: ,'_PVT'
2723: ,x_return_status);
2724: -- Check if activity started successfully
2725: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2726: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2727: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2728: RAISE OKL_API.G_EXCEPTION_ERROR;
2729: END IF;
2730:

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

2723: ,x_return_status);
2724: -- Check if activity started successfully
2725: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2726: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2727: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2728: RAISE OKL_API.G_EXCEPTION_ERROR;
2729: END IF;
2730:
2731: -- Summary Report: Check whether all assets have same Payment Schedule

Line 2728: RAISE OKL_API.G_EXCEPTION_ERROR;

2724: -- Check if activity started successfully
2725: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2726: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2727: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2728: RAISE OKL_API.G_EXCEPTION_ERROR;
2729: END IF;
2730:
2731: -- Summary Report: Check whether all assets have same Payment Schedule
2732: IF p_report_type = G_REPORT_TYPE_SUMMARY THEN

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

2739: x_msg_data => x_msg_data,
2740: p_chr_id => p_chr_id,
2741: x_schedule_match_yn => l_schedule_match_yn);
2742:
2743: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2744: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2745: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2746: RAISE OKL_API.G_EXCEPTION_ERROR;
2747: END IF;

Line 2744: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2740: p_chr_id => p_chr_id,
2741: x_schedule_match_yn => l_schedule_match_yn);
2742:
2743: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2744: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2745: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2746: RAISE OKL_API.G_EXCEPTION_ERROR;
2747: END IF;
2748:

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

2741: x_schedule_match_yn => l_schedule_match_yn);
2742:
2743: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2744: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2745: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2746: RAISE OKL_API.G_EXCEPTION_ERROR;
2747: END IF;
2748:
2749: END IF;

Line 2746: RAISE OKL_API.G_EXCEPTION_ERROR;

2742:
2743: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2744: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2745: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2746: RAISE OKL_API.G_EXCEPTION_ERROR;
2747: END IF;
2748:
2749: END IF;
2750:

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

2766: x_msg_data => x_msg_data,
2767: p_chr_id => p_chr_id,
2768: x_amort_sched_tbl => x_amort_sched_tbl);
2769:
2770: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2771: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2772: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2773: RAISE OKL_API.G_EXCEPTION_ERROR;
2774: END IF;

Line 2771: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2767: p_chr_id => p_chr_id,
2768: x_amort_sched_tbl => x_amort_sched_tbl);
2769:
2770: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2771: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2772: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2773: RAISE OKL_API.G_EXCEPTION_ERROR;
2774: END IF;
2775:

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

2768: x_amort_sched_tbl => x_amort_sched_tbl);
2769:
2770: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2771: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2772: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2773: RAISE OKL_API.G_EXCEPTION_ERROR;
2774: END IF;
2775:
2776:

Line 2773: RAISE OKL_API.G_EXCEPTION_ERROR;

2769:
2770: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2771: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2772: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2773: RAISE OKL_API.G_EXCEPTION_ERROR;
2774: END IF;
2775:
2776:
2777: ELSIF p_report_type = G_REPORT_TYPE_DETAIL THEN

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

2784: x_msg_data => x_msg_data,
2785: p_chr_id => p_chr_id,
2786: x_amort_sched_tbl => x_amort_sched_tbl);
2787:
2788: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2789: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2790: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2791: RAISE OKL_API.G_EXCEPTION_ERROR;
2792: END IF;

Line 2789: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2785: p_chr_id => p_chr_id,
2786: x_amort_sched_tbl => x_amort_sched_tbl);
2787:
2788: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2789: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2790: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2791: RAISE OKL_API.G_EXCEPTION_ERROR;
2792: END IF;
2793:

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

2786: x_amort_sched_tbl => x_amort_sched_tbl);
2787:
2788: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2789: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2790: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2791: RAISE OKL_API.G_EXCEPTION_ERROR;
2792: END IF;
2793:
2794:

Line 2791: RAISE OKL_API.G_EXCEPTION_ERROR;

2787:
2788: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2789: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2790: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2791: RAISE OKL_API.G_EXCEPTION_ERROR;
2792: END IF;
2793:
2794:
2795: END IF;

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

2809: p_chr_id => p_chr_id,
2810: x_proj_interest_rate => l_proj_interest_rate,
2811: x_amort_sched_tbl => x_amort_sched_tbl);
2812:
2813: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2814: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2815: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2816: RAISE OKL_API.G_EXCEPTION_ERROR;
2817: END IF;

Line 2814: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2810: x_proj_interest_rate => l_proj_interest_rate,
2811: x_amort_sched_tbl => x_amort_sched_tbl);
2812:
2813: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2814: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2815: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2816: RAISE OKL_API.G_EXCEPTION_ERROR;
2817: END IF;
2818:

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

2811: x_amort_sched_tbl => x_amort_sched_tbl);
2812:
2813: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2814: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2815: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2816: RAISE OKL_API.G_EXCEPTION_ERROR;
2817: END IF;
2818:
2819: ELSIF p_report_type = G_REPORT_TYPE_DETAIL THEN

Line 2816: RAISE OKL_API.G_EXCEPTION_ERROR;

2812:
2813: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2814: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2815: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2816: RAISE OKL_API.G_EXCEPTION_ERROR;
2817: END IF;
2818:
2819: ELSIF p_report_type = G_REPORT_TYPE_DETAIL THEN
2820:

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

2828: p_chr_id => p_chr_id,
2829: x_proj_interest_rate => l_proj_interest_rate,
2830: x_amort_sched_tbl => x_amort_sched_tbl);
2831:
2832: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2833: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2834: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2835: RAISE OKL_API.G_EXCEPTION_ERROR;
2836: END IF;

Line 2833: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2829: x_proj_interest_rate => l_proj_interest_rate,
2830: x_amort_sched_tbl => x_amort_sched_tbl);
2831:
2832: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2833: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2834: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2835: RAISE OKL_API.G_EXCEPTION_ERROR;
2836: END IF;
2837:

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

2830: x_amort_sched_tbl => x_amort_sched_tbl);
2831:
2832: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2833: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2834: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2835: RAISE OKL_API.G_EXCEPTION_ERROR;
2836: END IF;
2837:
2838: END IF;

Line 2835: RAISE OKL_API.G_EXCEPTION_ERROR;

2831:
2832: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2833: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2834: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2835: RAISE OKL_API.G_EXCEPTION_ERROR;
2836: END IF;
2837:
2838: END IF;
2839: x_proj_interest_rate :=l_proj_interest_rate;

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

2851: x_msg_data => x_msg_data,
2852: p_chr_id => p_chr_id,
2853: x_amort_sched_tbl => x_amort_sched_tbl);
2854:
2855: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2856: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2857: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2858: RAISE OKL_API.G_EXCEPTION_ERROR;
2859: END IF;

Line 2856: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2852: p_chr_id => p_chr_id,
2853: x_amort_sched_tbl => x_amort_sched_tbl);
2854:
2855: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2856: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2857: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2858: RAISE OKL_API.G_EXCEPTION_ERROR;
2859: END IF;
2860:

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

2853: x_amort_sched_tbl => x_amort_sched_tbl);
2854:
2855: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2856: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2857: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2858: RAISE OKL_API.G_EXCEPTION_ERROR;
2859: END IF;
2860:
2861: ELSIF p_report_type = G_REPORT_TYPE_DETAIL THEN

Line 2858: RAISE OKL_API.G_EXCEPTION_ERROR;

2854:
2855: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2856: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2857: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2858: RAISE OKL_API.G_EXCEPTION_ERROR;
2859: END IF;
2860:
2861: ELSIF p_report_type = G_REPORT_TYPE_DETAIL THEN
2862:

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

2869: x_msg_data => x_msg_data,
2870: p_chr_id => p_chr_id,
2871: x_amort_sched_tbl => x_amort_sched_tbl);
2872:
2873: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2874: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2875: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2876: RAISE OKL_API.G_EXCEPTION_ERROR;
2877: END IF;

Line 2874: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2870: p_chr_id => p_chr_id,
2871: x_amort_sched_tbl => x_amort_sched_tbl);
2872:
2873: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2874: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2875: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2876: RAISE OKL_API.G_EXCEPTION_ERROR;
2877: END IF;
2878:

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

2871: x_amort_sched_tbl => x_amort_sched_tbl);
2872:
2873: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2874: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2875: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2876: RAISE OKL_API.G_EXCEPTION_ERROR;
2877: END IF;
2878:
2879: END IF;

Line 2876: RAISE OKL_API.G_EXCEPTION_ERROR;

2872:
2873: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2874: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2875: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2876: RAISE OKL_API.G_EXCEPTION_ERROR;
2877: END IF;
2878:
2879: END IF;
2880: x_proj_interest_rate := chr_product_rec.implicit_interest_rate;

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

2892: x_msg_data => x_msg_data,
2893: p_chr_id => p_chr_id,
2894: x_amort_sched_tbl => x_amort_sched_tbl);
2895:
2896: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2898: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2899: RAISE OKL_API.G_EXCEPTION_ERROR;
2900: END IF;

Line 2897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2893: p_chr_id => p_chr_id,
2894: x_amort_sched_tbl => x_amort_sched_tbl);
2895:
2896: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2898: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2899: RAISE OKL_API.G_EXCEPTION_ERROR;
2900: END IF;
2901:

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

2894: x_amort_sched_tbl => x_amort_sched_tbl);
2895:
2896: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2898: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2899: RAISE OKL_API.G_EXCEPTION_ERROR;
2900: END IF;
2901:
2902: ELSIF p_report_type = G_REPORT_TYPE_DETAIL THEN

Line 2899: RAISE OKL_API.G_EXCEPTION_ERROR;

2895:
2896: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2898: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2899: RAISE OKL_API.G_EXCEPTION_ERROR;
2900: END IF;
2901:
2902: ELSIF p_report_type = G_REPORT_TYPE_DETAIL THEN
2903:

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

2910: x_msg_data => x_msg_data,
2911: p_chr_id => p_chr_id,
2912: x_amort_sched_tbl => x_amort_sched_tbl);
2913:
2914: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2915: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2916: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2917: RAISE OKL_API.G_EXCEPTION_ERROR;
2918: END IF;

Line 2915: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2911: p_chr_id => p_chr_id,
2912: x_amort_sched_tbl => x_amort_sched_tbl);
2913:
2914: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2915: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2916: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2917: RAISE OKL_API.G_EXCEPTION_ERROR;
2918: END IF;
2919:

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

2912: x_amort_sched_tbl => x_amort_sched_tbl);
2913:
2914: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2915: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2916: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2917: RAISE OKL_API.G_EXCEPTION_ERROR;
2918: END IF;
2919:
2920: END IF;

Line 2917: RAISE OKL_API.G_EXCEPTION_ERROR;

2913:
2914: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2915: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2916: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2917: RAISE OKL_API.G_EXCEPTION_ERROR;
2918: END IF;
2919:
2920: END IF;
2921: x_proj_interest_rate := chr_product_rec.implicit_interest_rate;

Line 2941: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);

2937: END IF;
2938: END IF;
2939:
2940: END IF;
2941: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);
2942:
2943: EXCEPTION
2944:
2945: ------------------------------------------------------------

Line 2949: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2945: ------------------------------------------------------------
2946: -- Exception handling
2947: ------------------------------------------------------------
2948:
2949: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2950:
2951: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2952: p_api_name => l_api_name,
2953: p_pkg_name => G_PKG_NAME,

Line 2951: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2947: ------------------------------------------------------------
2948:
2949: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2950:
2951: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2952: p_api_name => l_api_name,
2953: p_pkg_name => G_PKG_NAME,
2954: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2955: x_msg_count => x_msg_count,

Line 2954: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

2950:
2951: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2952: p_api_name => l_api_name,
2953: p_pkg_name => G_PKG_NAME,
2954: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2955: x_msg_count => x_msg_count,
2956: x_msg_data => x_msg_data,
2957: p_api_type => '_PVT');
2958:

Line 2959: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2955: x_msg_count => x_msg_count,
2956: x_msg_data => x_msg_data,
2957: p_api_type => '_PVT');
2958:
2959: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2960:
2961: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2962: p_api_name => l_api_name,
2963: p_pkg_name => G_PKG_NAME,

Line 2961: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2957: p_api_type => '_PVT');
2958:
2959: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2960:
2961: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2962: p_api_name => l_api_name,
2963: p_pkg_name => G_PKG_NAME,
2964: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2965: x_msg_count => x_msg_count,

Line 2964: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

2960:
2961: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2962: p_api_name => l_api_name,
2963: p_pkg_name => G_PKG_NAME,
2964: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2965: x_msg_count => x_msg_count,
2966: x_msg_data => x_msg_data,
2967: p_api_type => '_PVT');
2968:

Line 2971: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2967: p_api_type => '_PVT');
2968:
2969: WHEN OTHERS THEN
2970:
2971: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2972: p_api_name => l_api_name,
2973: p_pkg_name => G_PKG_NAME,
2974: p_exc_name => 'OTHERS',
2975: x_msg_count => x_msg_count,