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 325: x_return_status := OKL_API.G_RET_STS_SUCCESS;

321: l_temp_tbl temp_tbl_type;
322:
323: BEGIN
324:
325: x_return_status := OKL_API.G_RET_STS_SUCCESS;
326: -- Call start_activity to create savepoint, check compatibility
327: -- and initialize message list
328: x_return_status := OKL_API.START_ACTIVITY (
329: l_api_name

Line 328: x_return_status := OKL_API.START_ACTIVITY (

324:
325: x_return_status := OKL_API.G_RET_STS_SUCCESS;
326: -- Call start_activity to create savepoint, check compatibility
327: -- and initialize message list
328: x_return_status := OKL_API.START_ACTIVITY (
329: l_api_name
330: ,p_init_msg_list
331: ,'_PVT'
332: ,x_return_status);

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

330: ,p_init_msg_list
331: ,'_PVT'
332: ,x_return_status);
333: -- Check if activity started successfully
334: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
335: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
336: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
337: RAISE OKL_API.G_EXCEPTION_ERROR;
338: END IF;

Line 335: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

331: ,'_PVT'
332: ,x_return_status);
333: -- Check if activity started successfully
334: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
335: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
336: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
337: RAISE OKL_API.G_EXCEPTION_ERROR;
338: END IF;
339:

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

332: ,x_return_status);
333: -- Check if activity started successfully
334: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
335: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
336: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
337: RAISE OKL_API.G_EXCEPTION_ERROR;
338: END IF;
339:
340: --Derive starting Principal Balance

Line 337: RAISE OKL_API.G_EXCEPTION_ERROR;

333: -- Check if activity started successfully
334: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
335: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
336: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
337: RAISE OKL_API.G_EXCEPTION_ERROR;
338: END IF;
339:
340: --Derive starting Principal Balance
341: Okl_Execute_Formula_Pub.EXECUTE(p_api_version => p_api_version,

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

347: p_contract_id => p_chr_id,
348: p_line_id => NULL,
349: x_value => l_princ_bal
350: );
351: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
352: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
353: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
354: RAISE OKL_API.G_EXCEPTION_ERROR;
355: END IF;

Line 352: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

348: p_line_id => NULL,
349: x_value => l_princ_bal
350: );
351: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
352: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
353: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
354: RAISE OKL_API.G_EXCEPTION_ERROR;
355: END IF;
356:

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

349: x_value => l_princ_bal
350: );
351: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
352: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
353: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
354: RAISE OKL_API.G_EXCEPTION_ERROR;
355: END IF;
356:
357: indx := 1;

Line 354: RAISE OKL_API.G_EXCEPTION_ERROR;

350: );
351: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
352: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
353: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
354: RAISE OKL_API.G_EXCEPTION_ERROR;
355: END IF;
356:
357: indx := 1;
358: l_amort_sched_tbl(indx).principal_balance := l_princ_bal;

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

377: END LOOP;
378: CLOSE c_amort_sch_dtl_csr;
379:
380: x_amort_sched_tbl := l_amort_sched_tbl;
381: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);
382:
383: EXCEPTION
384:
385: ------------------------------------------------------------

Line 389: WHEN OKL_API.G_EXCEPTION_ERROR THEN

385: ------------------------------------------------------------
386: -- Exception handling
387: ------------------------------------------------------------
388:
389: WHEN OKL_API.G_EXCEPTION_ERROR THEN
390: IF c_amort_sch_dtl_csr%ISOPEN THEN
391: CLOSE c_amort_sch_dtl_csr;
392: END IF;
393:

Line 395: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

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

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

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

Line 403: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

399: x_msg_count => x_msg_count,
400: x_msg_data => x_msg_data,
401: p_api_type => '_PVT');
402:
403: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
404:
405: IF c_amort_sch_dtl_csr%ISOPEN THEN
406: CLOSE c_amort_sch_dtl_csr;
407: END IF;

Line 410: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

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

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

409:
410: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
411: p_api_name => l_api_name,
412: p_pkg_name => G_PKG_NAME,
413: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
414: x_msg_count => x_msg_count,
415: x_msg_data => x_msg_data,
416: p_api_type => '_PVT');
417:

Line 424: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

420: CLOSE c_amort_sch_dtl_csr;
421: END IF;
422:
423:
424: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
425: p_api_name => l_api_name,
426: p_pkg_name => G_PKG_NAME,
427: p_exc_name => 'OTHERS',
428: x_msg_count => x_msg_count,

Line 488: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

484: -- End of comments
485:
486: PROCEDURE load_ln_streams_summ(
487: p_api_version IN NUMBER,
488: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
489: x_return_status OUT NOCOPY VARCHAR2,
490: x_msg_count OUT NOCOPY NUMBER,
491: x_msg_data OUT NOCOPY VARCHAR2,
492: p_chr_id IN NUMBER,

Line 592: x_return_status := OKL_API.G_RET_STS_SUCCESS;

588:
589: l_period_date DATE;
590: BEGIN
591:
592: x_return_status := OKL_API.G_RET_STS_SUCCESS;
593: -- Call start_activity to create savepoint, check compatibility
594: -- and initialize message list
595: x_return_status := OKL_API.START_ACTIVITY (
596: l_api_name

Line 595: x_return_status := OKL_API.START_ACTIVITY (

591:
592: x_return_status := OKL_API.G_RET_STS_SUCCESS;
593: -- Call start_activity to create savepoint, check compatibility
594: -- and initialize message list
595: x_return_status := OKL_API.START_ACTIVITY (
596: l_api_name
597: ,p_init_msg_list
598: ,'_PVT'
599: ,x_return_status);

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

597: ,p_init_msg_list
598: ,'_PVT'
599: ,x_return_status);
600: -- Check if activity started successfully
601: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
602: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
603: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
604: RAISE OKL_API.G_EXCEPTION_ERROR;
605: END IF;

Line 602: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

598: ,'_PVT'
599: ,x_return_status);
600: -- Check if activity started successfully
601: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
602: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
603: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
604: RAISE OKL_API.G_EXCEPTION_ERROR;
605: END IF;
606:

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

599: ,x_return_status);
600: -- Check if activity started successfully
601: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
602: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
603: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
604: RAISE OKL_API.G_EXCEPTION_ERROR;
605: END IF;
606:
607:

Line 604: RAISE OKL_API.G_EXCEPTION_ERROR;

600: -- Check if activity started successfully
601: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
602: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
603: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
604: RAISE OKL_API.G_EXCEPTION_ERROR;
605: END IF;
606:
607:
608:

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

616: x_arrears_yn => l_arrears_yn,
617: x_periods_tbl => l_periods_tbl
618: );
619:
620: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
621: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
622: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
623: RAISE Okl_Api.G_EXCEPTION_ERROR;
624: END IF;

Line 621: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

617: x_periods_tbl => l_periods_tbl
618: );
619:
620: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
621: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
622: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
623: RAISE Okl_Api.G_EXCEPTION_ERROR;
624: END IF;
625:

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

618: );
619:
620: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
621: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
622: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
623: RAISE Okl_Api.G_EXCEPTION_ERROR;
624: END IF;
625:
626: --Derive starting Principal Balance

Line 623: RAISE Okl_Api.G_EXCEPTION_ERROR;

619:
620: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
621: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
622: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
623: RAISE Okl_Api.G_EXCEPTION_ERROR;
624: END IF;
625:
626: --Derive starting Principal Balance
627: Okl_Execute_Formula_Pub.EXECUTE(p_api_version => p_api_version,

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

633: p_contract_id => p_chr_id,
634: p_line_id => NULL,
635: x_value => l_princ_bal
636: );
637: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
638: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
639: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
640: RAISE OKL_API.G_EXCEPTION_ERROR;
641: END IF;

Line 638: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

634: p_line_id => NULL,
635: x_value => l_princ_bal
636: );
637: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
638: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
639: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
640: RAISE OKL_API.G_EXCEPTION_ERROR;
641: END IF;
642:

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

635: x_value => l_princ_bal
636: );
637: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
638: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
639: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
640: RAISE OKL_API.G_EXCEPTION_ERROR;
641: END IF;
642:
643: indx := 1;

Line 640: RAISE OKL_API.G_EXCEPTION_ERROR;

636: );
637: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
638: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
639: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
640: RAISE OKL_API.G_EXCEPTION_ERROR;
641: END IF;
642:
643: indx := 1;
644: l_amort_sched_tbl(indx).principal_balance := l_princ_bal;

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

695: EXIT WHEN c_amort_sch_summ_csr%NOTFOUND;
696: END LOOP;
697: CLOSE c_amort_sch_summ_csr;
698: x_amort_sched_tbl := l_amort_sched_tbl;
699: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);
700:
701: EXCEPTION
702:
703: ------------------------------------------------------------

Line 707: WHEN OKL_API.G_EXCEPTION_ERROR THEN

703: ------------------------------------------------------------
704: -- Exception handling
705: ------------------------------------------------------------
706:
707: WHEN OKL_API.G_EXCEPTION_ERROR THEN
708: IF c_amort_sch_summ_csr%ISOPEN THEN
709: CLOSE c_amort_sch_summ_csr;
710: END IF;
711:

Line 716: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

712: IF c_amort_sch_ppd_csr%ISOPEN THEN
713: CLOSE c_amort_sch_ppd_csr;
714: END IF;
715:
716: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
717: p_api_name => l_api_name,
718: p_pkg_name => G_PKG_NAME,
719: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
720: x_msg_count => x_msg_count,

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

715:
716: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
717: p_api_name => l_api_name,
718: p_pkg_name => G_PKG_NAME,
719: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
720: x_msg_count => x_msg_count,
721: x_msg_data => x_msg_data,
722: p_api_type => '_PVT');
723:

Line 724: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

720: x_msg_count => x_msg_count,
721: x_msg_data => x_msg_data,
722: p_api_type => '_PVT');
723:
724: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
725:
726: IF c_amort_sch_summ_csr%ISOPEN THEN
727: CLOSE c_amort_sch_summ_csr;
728: END IF;

Line 734: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

730: IF c_amort_sch_ppd_csr%ISOPEN THEN
731: CLOSE c_amort_sch_ppd_csr;
732: END IF;
733:
734: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
735: p_api_name => l_api_name,
736: p_pkg_name => G_PKG_NAME,
737: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
738: x_msg_count => x_msg_count,

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

733:
734: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
735: p_api_name => l_api_name,
736: p_pkg_name => G_PKG_NAME,
737: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
738: x_msg_count => x_msg_count,
739: x_msg_data => x_msg_data,
740: p_api_type => '_PVT');
741:

Line 751: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

747: IF c_amort_sch_ppd_csr%ISOPEN THEN
748: CLOSE c_amort_sch_ppd_csr;
749: END IF;
750:
751: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
752: p_api_name => l_api_name,
753: p_pkg_name => G_PKG_NAME,
754: p_exc_name => 'OTHERS',
755: x_msg_count => x_msg_count,

Line 782: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

778: -- End of comments
779:
780: PROCEDURE load_ln_actual_dtl(
781: p_api_version IN NUMBER,
782: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
783: x_return_status OUT NOCOPY VARCHAR2,
784: x_msg_count OUT NOCOPY NUMBER,
785: x_msg_data OUT NOCOPY VARCHAR2,
786: p_chr_id IN NUMBER,

Line 842: x_return_status := OKL_API.G_RET_STS_SUCCESS;

838: l_proj_interest_rate NUMBER;
839:
840: BEGIN
841:
842: x_return_status := OKL_API.G_RET_STS_SUCCESS;
843: -- Call start_activity to create savepoint, check compatibility
844: -- and initialize message list
845: x_return_status := OKL_API.START_ACTIVITY (
846: l_api_name

Line 845: x_return_status := OKL_API.START_ACTIVITY (

841:
842: x_return_status := OKL_API.G_RET_STS_SUCCESS;
843: -- Call start_activity to create savepoint, check compatibility
844: -- and initialize message list
845: x_return_status := OKL_API.START_ACTIVITY (
846: l_api_name
847: ,p_init_msg_list
848: ,'_PVT'
849: ,x_return_status);

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

847: ,p_init_msg_list
848: ,'_PVT'
849: ,x_return_status);
850: -- Check if activity started successfully
851: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
852: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
853: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
854: RAISE OKL_API.G_EXCEPTION_ERROR;
855: END IF;

Line 852: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

848: ,'_PVT'
849: ,x_return_status);
850: -- Check if activity started successfully
851: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
852: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
853: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
854: RAISE OKL_API.G_EXCEPTION_ERROR;
855: END IF;
856:

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

849: ,x_return_status);
850: -- Check if activity started successfully
851: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
852: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
853: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
854: RAISE OKL_API.G_EXCEPTION_ERROR;
855: END IF;
856:
857: --Derive Principal Balance

Line 854: RAISE OKL_API.G_EXCEPTION_ERROR;

850: -- Check if activity started successfully
851: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
852: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
853: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
854: RAISE OKL_API.G_EXCEPTION_ERROR;
855: END IF;
856:
857: --Derive Principal Balance
858: Okl_Execute_Formula_Pub.EXECUTE(p_api_version => p_api_version,

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

864: p_contract_id => p_chr_id,
865: p_line_id => NULL,
866: x_value => l_principal_balance
867: );
868: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
869: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
870: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
871: RAISE OKL_API.G_EXCEPTION_ERROR;
872: END IF;

Line 869: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

865: p_line_id => NULL,
866: x_value => l_principal_balance
867: );
868: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
869: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
870: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
871: RAISE OKL_API.G_EXCEPTION_ERROR;
872: END IF;
873:

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

866: x_value => l_principal_balance
867: );
868: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
869: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
870: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
871: RAISE OKL_API.G_EXCEPTION_ERROR;
872: END IF;
873:
874: l_counter := 1;

Line 871: RAISE OKL_API.G_EXCEPTION_ERROR;

867: );
868: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
869: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
870: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
871: RAISE OKL_API.G_EXCEPTION_ERROR;
872: END IF;
873:
874: l_counter := 1;
875: l_amort_sched_tbl(l_counter).principal_balance := l_principal_balance;

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

904: x_interest_rate => l_proj_interest_rate,
905: x_schedule_table => l_schedule_tbl,
906: x_return_status => x_return_status);
907:
908: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
909: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
910: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
911: RAISE OKL_API.G_EXCEPTION_ERROR;
912: END IF;

Line 909: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

905: x_schedule_table => l_schedule_tbl,
906: x_return_status => x_return_status);
907:
908: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
909: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
910: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
911: RAISE OKL_API.G_EXCEPTION_ERROR;
912: END IF;
913:

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

906: x_return_status => x_return_status);
907:
908: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
909: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
910: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
911: RAISE OKL_API.G_EXCEPTION_ERROR;
912: END IF;
913:
914: IF (l_schedule_tbl.COUNT > 0) THEN

Line 911: RAISE OKL_API.G_EXCEPTION_ERROR;

907:
908: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
909: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
910: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
911: RAISE OKL_API.G_EXCEPTION_ERROR;
912: END IF;
913:
914: IF (l_schedule_tbl.COUNT > 0) THEN
915:

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

930:
931: x_amort_sched_tbl := l_amort_sched_tbl;
932: x_proj_interest_rate := l_proj_interest_rate;
933:
934: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);
935:
936: EXCEPTION
937:
938: ------------------------------------------------------------

Line 942: WHEN OKL_API.G_EXCEPTION_ERROR THEN

938: ------------------------------------------------------------
939: -- Exception handling
940: ------------------------------------------------------------
941:
942: WHEN OKL_API.G_EXCEPTION_ERROR THEN
943:
944: IF amort_sched_dtl_csr%ISOPEN THEN
945: CLOSE amort_sched_dtl_csr;
946: END IF;

Line 948: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

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

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

947:
948: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
949: p_api_name => l_api_name,
950: p_pkg_name => G_PKG_NAME,
951: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
952: x_msg_count => x_msg_count,
953: x_msg_data => x_msg_data,
954: p_api_type => '_PVT');
955:

Line 956: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

952: x_msg_count => x_msg_count,
953: x_msg_data => x_msg_data,
954: p_api_type => '_PVT');
955:
956: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
957:
958: IF amort_sched_dtl_csr%ISOPEN THEN
959: CLOSE amort_sched_dtl_csr;
960: END IF;

Line 962: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

958: IF amort_sched_dtl_csr%ISOPEN THEN
959: CLOSE amort_sched_dtl_csr;
960: END IF;
961:
962: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
963: p_api_name => l_api_name,
964: p_pkg_name => G_PKG_NAME,
965: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
966: x_msg_count => x_msg_count,

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

961:
962: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
963: p_api_name => l_api_name,
964: p_pkg_name => G_PKG_NAME,
965: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
966: x_msg_count => x_msg_count,
967: x_msg_data => x_msg_data,
968: p_api_type => '_PVT');
969:

Line 976: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

972: IF amort_sched_dtl_csr%ISOPEN THEN
973: CLOSE amort_sched_dtl_csr;
974: END IF;
975:
976: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
977: p_api_name => l_api_name,
978: p_pkg_name => G_PKG_NAME,
979: p_exc_name => 'OTHERS',
980: x_msg_count => x_msg_count,

Line 1005: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1001: -- End of comments
1002:
1003: PROCEDURE load_ln_actual_summ(
1004: p_api_version IN NUMBER,
1005: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1006: x_return_status OUT NOCOPY VARCHAR2,
1007: x_msg_count OUT NOCOPY NUMBER,
1008: x_msg_data OUT NOCOPY VARCHAR2,
1009: p_chr_id IN NUMBER,

Line 1071: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1067: l_proj_interest_rate NUMBER;
1068:
1069: BEGIN
1070:
1071: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1072: -- Call start_activity to create savepoint, check compatibility
1073: -- and initialize message list
1074: x_return_status := OKL_API.START_ACTIVITY (
1075: l_api_name

Line 1074: x_return_status := OKL_API.START_ACTIVITY (

1070:
1071: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1072: -- Call start_activity to create savepoint, check compatibility
1073: -- and initialize message list
1074: x_return_status := OKL_API.START_ACTIVITY (
1075: l_api_name
1076: ,p_init_msg_list
1077: ,'_PVT'
1078: ,x_return_status);

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

1076: ,p_init_msg_list
1077: ,'_PVT'
1078: ,x_return_status);
1079: -- Check if activity started successfully
1080: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1081: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1082: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1083: RAISE OKL_API.G_EXCEPTION_ERROR;
1084: END IF;

Line 1081: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1077: ,'_PVT'
1078: ,x_return_status);
1079: -- Check if activity started successfully
1080: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1081: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1082: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1083: RAISE OKL_API.G_EXCEPTION_ERROR;
1084: END IF;
1085:

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

1078: ,x_return_status);
1079: -- Check if activity started successfully
1080: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1081: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1082: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1083: RAISE OKL_API.G_EXCEPTION_ERROR;
1084: END IF;
1085:
1086: --Derive Principal Balance

Line 1083: RAISE OKL_API.G_EXCEPTION_ERROR;

1079: -- Check if activity started successfully
1080: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1081: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1082: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1083: RAISE OKL_API.G_EXCEPTION_ERROR;
1084: END IF;
1085:
1086: --Derive Principal Balance
1087: Okl_Execute_Formula_Pub.EXECUTE(p_api_version => p_api_version,

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

1093: p_contract_id => p_chr_id,
1094: p_line_id => NULL,
1095: x_value => l_principal_balance
1096: );
1097: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1098: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1099: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1100: RAISE OKL_API.G_EXCEPTION_ERROR;
1101: END IF;

Line 1098: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1094: p_line_id => NULL,
1095: x_value => l_principal_balance
1096: );
1097: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1098: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1099: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1100: RAISE OKL_API.G_EXCEPTION_ERROR;
1101: END IF;
1102:

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

1095: x_value => l_principal_balance
1096: );
1097: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1098: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1099: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1100: RAISE OKL_API.G_EXCEPTION_ERROR;
1101: END IF;
1102:
1103: l_temp_counter := 0;

Line 1100: RAISE OKL_API.G_EXCEPTION_ERROR;

1096: );
1097: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1098: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1099: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1100: RAISE OKL_API.G_EXCEPTION_ERROR;
1101: END IF;
1102:
1103: l_temp_counter := 0;
1104: OPEN amort_sched_dtl_csr(p_chr_id => p_chr_id);

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

1126: x_arrears_yn => l_arrears_yn,
1127: x_periods_tbl => l_periods_tbl
1128: );
1129:
1130: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1132: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1133: RAISE OKL_API.G_EXCEPTION_ERROR;
1134: END IF;

Line 1131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1127: x_periods_tbl => l_periods_tbl
1128: );
1129:
1130: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1132: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1133: RAISE OKL_API.G_EXCEPTION_ERROR;
1134: END IF;
1135:

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

1128: );
1129:
1130: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1132: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1133: RAISE OKL_API.G_EXCEPTION_ERROR;
1134: END IF;
1135:
1136: l_counter := 1;

Line 1133: RAISE OKL_API.G_EXCEPTION_ERROR;

1129:
1130: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1131: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1132: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1133: RAISE OKL_API.G_EXCEPTION_ERROR;
1134: END IF;
1135:
1136: l_counter := 1;
1137: l_amort_sched_tbl(l_counter).principal_balance := l_principal_balance;

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

1201: x_interest_rate => l_proj_interest_rate,
1202: x_schedule_table => l_schedule_tbl,
1203: x_return_status => x_return_status);
1204:
1205: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1206: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1207: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1208: RAISE OKL_API.G_EXCEPTION_ERROR;
1209: END IF;

Line 1206: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1202: x_schedule_table => l_schedule_tbl,
1203: x_return_status => x_return_status);
1204:
1205: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1206: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1207: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1208: RAISE OKL_API.G_EXCEPTION_ERROR;
1209: END IF;
1210:

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

1203: x_return_status => x_return_status);
1204:
1205: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1206: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1207: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1208: RAISE OKL_API.G_EXCEPTION_ERROR;
1209: END IF;
1210:
1211: IF (l_schedule_tbl.COUNT > 0 AND l_periods_tbl.COUNT > 0) THEN

Line 1208: RAISE OKL_API.G_EXCEPTION_ERROR;

1204:
1205: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1206: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1207: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1208: RAISE OKL_API.G_EXCEPTION_ERROR;
1209: END IF;
1210:
1211: IF (l_schedule_tbl.COUNT > 0 AND l_periods_tbl.COUNT > 0) THEN
1212:

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

1277:
1278: x_amort_sched_tbl := l_amort_sched_tbl;
1279: x_proj_interest_rate := l_proj_interest_rate;
1280:
1281: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);
1282:
1283: EXCEPTION
1284:
1285: ------------------------------------------------------------

Line 1289: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1285: ------------------------------------------------------------
1286: -- Exception handling
1287: ------------------------------------------------------------
1288:
1289: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1290:
1291: IF amort_sched_dtl_csr%ISOPEN THEN
1292: CLOSE amort_sched_dtl_csr;
1293: END IF;

Line 1295: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

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

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

1294:
1295: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1296: p_api_name => l_api_name,
1297: p_pkg_name => G_PKG_NAME,
1298: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1299: x_msg_count => x_msg_count,
1300: x_msg_data => x_msg_data,
1301: p_api_type => '_PVT');
1302:

Line 1303: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1299: x_msg_count => x_msg_count,
1300: x_msg_data => x_msg_data,
1301: p_api_type => '_PVT');
1302:
1303: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1304:
1305: IF amort_sched_dtl_csr%ISOPEN THEN
1306: CLOSE amort_sched_dtl_csr;
1307: END IF;

Line 1309: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

1305: IF amort_sched_dtl_csr%ISOPEN THEN
1306: CLOSE amort_sched_dtl_csr;
1307: END IF;
1308:
1309: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1310: p_api_name => l_api_name,
1311: p_pkg_name => G_PKG_NAME,
1312: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1313: x_msg_count => x_msg_count,

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

1308:
1309: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1310: p_api_name => l_api_name,
1311: p_pkg_name => G_PKG_NAME,
1312: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1313: x_msg_count => x_msg_count,
1314: x_msg_data => x_msg_data,
1315: p_api_type => '_PVT');
1316:

Line 1323: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

1319: IF amort_sched_dtl_csr%ISOPEN THEN
1320: CLOSE amort_sched_dtl_csr;
1321: END IF;
1322:
1323: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1324: p_api_name => l_api_name,
1325: p_pkg_name => G_PKG_NAME,
1326: p_exc_name => 'OTHERS',
1327: x_msg_count => x_msg_count,

Line 1354: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1350: -- End of comments
1351:
1352: PROCEDURE load_ln_float_eb_dtl(
1353: p_api_version IN NUMBER,
1354: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1355: x_return_status OUT NOCOPY VARCHAR2,
1356: x_msg_count OUT NOCOPY NUMBER,
1357: x_msg_data OUT NOCOPY VARCHAR2,
1358: p_chr_id IN NUMBER,

Line 1496: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1492: l_counter NUMBER;
1493:
1494: BEGIN
1495:
1496: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1497: -- Call start_activity to create savepoint, check compatibility
1498: -- and initialize message list
1499: x_return_status := OKL_API.START_ACTIVITY (
1500: l_api_name

Line 1499: x_return_status := OKL_API.START_ACTIVITY (

1495:
1496: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1497: -- Call start_activity to create savepoint, check compatibility
1498: -- and initialize message list
1499: x_return_status := OKL_API.START_ACTIVITY (
1500: l_api_name
1501: ,p_init_msg_list
1502: ,'_PVT'
1503: ,x_return_status);

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

1501: ,p_init_msg_list
1502: ,'_PVT'
1503: ,x_return_status);
1504: -- Check if activity started successfully
1505: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1506: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1507: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1508: RAISE OKL_API.G_EXCEPTION_ERROR;
1509: END IF;

Line 1506: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1502: ,'_PVT'
1503: ,x_return_status);
1504: -- Check if activity started successfully
1505: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1506: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1507: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1508: RAISE OKL_API.G_EXCEPTION_ERROR;
1509: END IF;
1510:

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

1503: ,x_return_status);
1504: -- Check if activity started successfully
1505: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1506: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1507: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1508: RAISE OKL_API.G_EXCEPTION_ERROR;
1509: END IF;
1510:
1511: --Derive Principal Balance

Line 1508: RAISE OKL_API.G_EXCEPTION_ERROR;

1504: -- Check if activity started successfully
1505: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1506: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1507: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1508: RAISE OKL_API.G_EXCEPTION_ERROR;
1509: END IF;
1510:
1511: --Derive Principal Balance
1512: Okl_Execute_Formula_Pub.EXECUTE(p_api_version => p_api_version,

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

1518: p_contract_id => p_chr_id,
1519: p_line_id => NULL,
1520: x_value => l_principal_balance
1521: );
1522: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1523: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1524: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1525: RAISE OKL_API.G_EXCEPTION_ERROR;
1526: END IF;

Line 1523: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1519: p_line_id => NULL,
1520: x_value => l_principal_balance
1521: );
1522: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1523: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1524: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1525: RAISE OKL_API.G_EXCEPTION_ERROR;
1526: END IF;
1527:

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

1520: x_value => l_principal_balance
1521: );
1522: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1523: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1524: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1525: RAISE OKL_API.G_EXCEPTION_ERROR;
1526: END IF;
1527:
1528: OPEN last_bill_date_csr(p_chr_id => p_chr_id);

Line 1525: RAISE OKL_API.G_EXCEPTION_ERROR;

1521: );
1522: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1523: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1524: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1525: RAISE OKL_API.G_EXCEPTION_ERROR;
1526: END IF;
1527:
1528: OPEN last_bill_date_csr(p_chr_id => p_chr_id);
1529: FETCH last_bill_date_csr INTO l_last_bill_date;

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

1558: CLOSE amort_sched_dtl_csr;
1559:
1560: x_amort_sched_tbl := l_amort_sched_tbl;
1561:
1562: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);
1563:
1564: EXCEPTION
1565:
1566: ------------------------------------------------------------

Line 1570: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1566: ------------------------------------------------------------
1567: -- Exception handling
1568: ------------------------------------------------------------
1569:
1570: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1571:
1572: IF amort_sched_dtl_csr%ISOPEN THEN
1573: CLOSE amort_sched_dtl_csr;
1574: END IF;

Line 1576: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

1572: IF amort_sched_dtl_csr%ISOPEN THEN
1573: CLOSE amort_sched_dtl_csr;
1574: END IF;
1575:
1576: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1577: p_api_name => l_api_name,
1578: p_pkg_name => G_PKG_NAME,
1579: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1580: x_msg_count => x_msg_count,

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

1575:
1576: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1577: p_api_name => l_api_name,
1578: p_pkg_name => G_PKG_NAME,
1579: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1580: x_msg_count => x_msg_count,
1581: x_msg_data => x_msg_data,
1582: p_api_type => '_PVT');
1583:

Line 1584: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1580: x_msg_count => x_msg_count,
1581: x_msg_data => x_msg_data,
1582: p_api_type => '_PVT');
1583:
1584: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1585:
1586: IF amort_sched_dtl_csr%ISOPEN THEN
1587: CLOSE amort_sched_dtl_csr;
1588: END IF;

Line 1590: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

1586: IF amort_sched_dtl_csr%ISOPEN THEN
1587: CLOSE amort_sched_dtl_csr;
1588: END IF;
1589:
1590: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1591: p_api_name => l_api_name,
1592: p_pkg_name => G_PKG_NAME,
1593: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1594: x_msg_count => x_msg_count,

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

1589:
1590: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1591: p_api_name => l_api_name,
1592: p_pkg_name => G_PKG_NAME,
1593: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1594: x_msg_count => x_msg_count,
1595: x_msg_data => x_msg_data,
1596: p_api_type => '_PVT');
1597:

Line 1604: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

1600: IF amort_sched_dtl_csr%ISOPEN THEN
1601: CLOSE amort_sched_dtl_csr;
1602: END IF;
1603:
1604: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1605: p_api_name => l_api_name,
1606: p_pkg_name => G_PKG_NAME,
1607: p_exc_name => 'OTHERS',
1608: x_msg_count => x_msg_count,

Line 1634: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1630: -- End of comments
1631:
1632: PROCEDURE load_ln_float_eb_summ(
1633: p_api_version IN NUMBER,
1634: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1635: x_return_status OUT NOCOPY VARCHAR2,
1636: x_msg_count OUT NOCOPY NUMBER,
1637: x_msg_data OUT NOCOPY VARCHAR2,
1638: p_chr_id IN NUMBER,

Line 1750: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1746: l_arrears_yn VARCHAR2(1);
1747:
1748: BEGIN
1749:
1750: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1751: -- Call start_activity to create savepoint, check compatibility
1752: -- and initialize message list
1753: x_return_status := OKL_API.START_ACTIVITY (
1754: l_api_name

Line 1753: x_return_status := OKL_API.START_ACTIVITY (

1749:
1750: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1751: -- Call start_activity to create savepoint, check compatibility
1752: -- and initialize message list
1753: x_return_status := OKL_API.START_ACTIVITY (
1754: l_api_name
1755: ,p_init_msg_list
1756: ,'_PVT'
1757: ,x_return_status);

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

1755: ,p_init_msg_list
1756: ,'_PVT'
1757: ,x_return_status);
1758: -- Check if activity started successfully
1759: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1760: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1761: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1762: RAISE OKL_API.G_EXCEPTION_ERROR;
1763: END IF;

Line 1760: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1756: ,'_PVT'
1757: ,x_return_status);
1758: -- Check if activity started successfully
1759: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1760: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1761: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1762: RAISE OKL_API.G_EXCEPTION_ERROR;
1763: END IF;
1764:

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

1757: ,x_return_status);
1758: -- Check if activity started successfully
1759: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1760: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1761: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1762: RAISE OKL_API.G_EXCEPTION_ERROR;
1763: END IF;
1764:
1765: --Derive Principal Balance

Line 1762: RAISE OKL_API.G_EXCEPTION_ERROR;

1758: -- Check if activity started successfully
1759: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1760: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1761: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1762: RAISE OKL_API.G_EXCEPTION_ERROR;
1763: END IF;
1764:
1765: --Derive Principal Balance
1766: Okl_Execute_Formula_Pub.EXECUTE(p_api_version => p_api_version,

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

1772: p_contract_id => p_chr_id,
1773: p_line_id => NULL,
1774: x_value => l_principal_balance
1775: );
1776: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1777: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1778: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1779: RAISE OKL_API.G_EXCEPTION_ERROR;
1780: END IF;

Line 1777: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1773: p_line_id => NULL,
1774: x_value => l_principal_balance
1775: );
1776: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1777: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1778: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1779: RAISE OKL_API.G_EXCEPTION_ERROR;
1780: END IF;
1781:

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

1774: x_value => l_principal_balance
1775: );
1776: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1777: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1778: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1779: RAISE OKL_API.G_EXCEPTION_ERROR;
1780: END IF;
1781:
1782: OPEN last_bill_date_csr(p_chr_id => p_chr_id);

Line 1779: RAISE OKL_API.G_EXCEPTION_ERROR;

1775: );
1776: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1777: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1778: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1779: RAISE OKL_API.G_EXCEPTION_ERROR;
1780: END IF;
1781:
1782: OPEN last_bill_date_csr(p_chr_id => p_chr_id);
1783: FETCH last_bill_date_csr INTO l_last_bill_date;

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

1816: x_arrears_yn => l_arrears_yn,
1817: x_periods_tbl => l_periods_tbl
1818: );
1819:
1820: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1821: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1822: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1823: RAISE OKL_API.G_EXCEPTION_ERROR;
1824: END IF;

Line 1821: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1817: x_periods_tbl => l_periods_tbl
1818: );
1819:
1820: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1821: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1822: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1823: RAISE OKL_API.G_EXCEPTION_ERROR;
1824: END IF;
1825:

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

1818: );
1819:
1820: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1821: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1822: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1823: RAISE OKL_API.G_EXCEPTION_ERROR;
1824: END IF;
1825:
1826: l_counter := 1;

Line 1823: RAISE OKL_API.G_EXCEPTION_ERROR;

1819:
1820: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1821: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1822: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1823: RAISE OKL_API.G_EXCEPTION_ERROR;
1824: END IF;
1825:
1826: l_counter := 1;
1827: l_amort_sched_tbl(l_counter).principal_balance := l_principal_balance;

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

1880: END IF;
1881:
1882: x_amort_sched_tbl := l_amort_sched_tbl;
1883:
1884: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);
1885:
1886: EXCEPTION
1887:
1888: ------------------------------------------------------------

Line 1892: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1888: ------------------------------------------------------------
1889: -- Exception handling
1890: ------------------------------------------------------------
1891:
1892: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1893:
1894: IF amort_sched_dtl_csr%ISOPEN THEN
1895: CLOSE amort_sched_dtl_csr;
1896: END IF;

Line 1898: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

1894: IF amort_sched_dtl_csr%ISOPEN THEN
1895: CLOSE amort_sched_dtl_csr;
1896: END IF;
1897:
1898: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1899: p_api_name => l_api_name,
1900: p_pkg_name => G_PKG_NAME,
1901: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1902: x_msg_count => x_msg_count,

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

1897:
1898: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1899: p_api_name => l_api_name,
1900: p_pkg_name => G_PKG_NAME,
1901: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1902: x_msg_count => x_msg_count,
1903: x_msg_data => x_msg_data,
1904: p_api_type => '_PVT');
1905:

Line 1906: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1902: x_msg_count => x_msg_count,
1903: x_msg_data => x_msg_data,
1904: p_api_type => '_PVT');
1905:
1906: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1907:
1908: IF amort_sched_dtl_csr%ISOPEN THEN
1909: CLOSE amort_sched_dtl_csr;
1910: END IF;

Line 1912: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

1908: IF amort_sched_dtl_csr%ISOPEN THEN
1909: CLOSE amort_sched_dtl_csr;
1910: END IF;
1911:
1912: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1913: p_api_name => l_api_name,
1914: p_pkg_name => G_PKG_NAME,
1915: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1916: x_msg_count => x_msg_count,

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

1911:
1912: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1913: p_api_name => l_api_name,
1914: p_pkg_name => G_PKG_NAME,
1915: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1916: x_msg_count => x_msg_count,
1917: x_msg_data => x_msg_data,
1918: p_api_type => '_PVT');
1919:

Line 1926: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

1922: IF amort_sched_dtl_csr%ISOPEN THEN
1923: CLOSE amort_sched_dtl_csr;
1924: END IF;
1925:
1926: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
1927: p_api_name => l_api_name,
1928: p_pkg_name => G_PKG_NAME,
1929: p_exc_name => 'OTHERS',
1930: x_msg_count => x_msg_count,

Line 1958: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

1954: -- End of comments
1955:
1956: PROCEDURE load_ln_cc_strm_dtl(
1957: p_api_version IN NUMBER,
1958: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
1959: x_return_status OUT NOCOPY VARCHAR2,
1960: x_msg_count OUT NOCOPY NUMBER,
1961: x_msg_data OUT NOCOPY VARCHAR2,
1962: p_chr_id IN NUMBER,

Line 2099: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2095: l_max_bill_counter NUMBER;
2096:
2097: BEGIN
2098:
2099: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2100: -- Call start_activity to create savepoint, check compatibility
2101: -- and initialize message list
2102: x_return_status := OKL_API.START_ACTIVITY (
2103: l_api_name

Line 2102: x_return_status := OKL_API.START_ACTIVITY (

2098:
2099: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2100: -- Call start_activity to create savepoint, check compatibility
2101: -- and initialize message list
2102: x_return_status := OKL_API.START_ACTIVITY (
2103: l_api_name
2104: ,p_init_msg_list
2105: ,'_PVT'
2106: ,x_return_status);

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

2104: ,p_init_msg_list
2105: ,'_PVT'
2106: ,x_return_status);
2107: -- Check if activity started successfully
2108: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2109: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2110: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2111: RAISE OKL_API.G_EXCEPTION_ERROR;
2112: END IF;

Line 2109: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2105: ,'_PVT'
2106: ,x_return_status);
2107: -- Check if activity started successfully
2108: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2109: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2110: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2111: RAISE OKL_API.G_EXCEPTION_ERROR;
2112: END IF;
2113:

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

2106: ,x_return_status);
2107: -- Check if activity started successfully
2108: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2109: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2110: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2111: RAISE OKL_API.G_EXCEPTION_ERROR;
2112: END IF;
2113:
2114: --Derive Principal Balance

Line 2111: RAISE OKL_API.G_EXCEPTION_ERROR;

2107: -- Check if activity started successfully
2108: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2109: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2110: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2111: RAISE OKL_API.G_EXCEPTION_ERROR;
2112: END IF;
2113:
2114: --Derive Principal Balance
2115: Okl_Execute_Formula_Pub.EXECUTE(p_api_version => p_api_version,

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

2121: p_contract_id => p_chr_id,
2122: p_line_id => NULL,
2123: x_value => l_principal_balance
2124: );
2125: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2127: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2128: RAISE OKL_API.G_EXCEPTION_ERROR;
2129: END IF;

Line 2126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2122: p_line_id => NULL,
2123: x_value => l_principal_balance
2124: );
2125: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2127: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2128: RAISE OKL_API.G_EXCEPTION_ERROR;
2129: END IF;
2130:

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

2123: x_value => l_principal_balance
2124: );
2125: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2127: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2128: RAISE OKL_API.G_EXCEPTION_ERROR;
2129: END IF;
2130:
2131: l_max_bill_counter := 0;

Line 2128: RAISE OKL_API.G_EXCEPTION_ERROR;

2124: );
2125: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2127: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2128: RAISE OKL_API.G_EXCEPTION_ERROR;
2129: END IF;
2130:
2131: l_max_bill_counter := 0;
2132: l_temp_counter := 0;

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

2178: END IF;
2179:
2180: x_amort_sched_tbl := l_amort_sched_tbl;
2181:
2182: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);
2183:
2184: EXCEPTION
2185:
2186: ------------------------------------------------------------

Line 2190: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2186: ------------------------------------------------------------
2187: -- Exception handling
2188: ------------------------------------------------------------
2189:
2190: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2191:
2192: IF amort_sched_dtl_csr%ISOPEN THEN
2193: CLOSE amort_sched_dtl_csr;
2194: END IF;

Line 2196: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2192: IF amort_sched_dtl_csr%ISOPEN THEN
2193: CLOSE amort_sched_dtl_csr;
2194: END IF;
2195:
2196: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2197: p_api_name => l_api_name,
2198: p_pkg_name => G_PKG_NAME,
2199: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2200: x_msg_count => x_msg_count,

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

2195:
2196: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2197: p_api_name => l_api_name,
2198: p_pkg_name => G_PKG_NAME,
2199: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2200: x_msg_count => x_msg_count,
2201: x_msg_data => x_msg_data,
2202: p_api_type => '_PVT');
2203:

Line 2204: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2200: x_msg_count => x_msg_count,
2201: x_msg_data => x_msg_data,
2202: p_api_type => '_PVT');
2203:
2204: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2205:
2206: IF amort_sched_dtl_csr%ISOPEN THEN
2207: CLOSE amort_sched_dtl_csr;
2208: END IF;

Line 2210: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2206: IF amort_sched_dtl_csr%ISOPEN THEN
2207: CLOSE amort_sched_dtl_csr;
2208: END IF;
2209:
2210: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2211: p_api_name => l_api_name,
2212: p_pkg_name => G_PKG_NAME,
2213: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2214: x_msg_count => x_msg_count,

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

2209:
2210: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2211: p_api_name => l_api_name,
2212: p_pkg_name => G_PKG_NAME,
2213: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2214: x_msg_count => x_msg_count,
2215: x_msg_data => x_msg_data,
2216: p_api_type => '_PVT');
2217:

Line 2224: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2220: IF amort_sched_dtl_csr%ISOPEN THEN
2221: CLOSE amort_sched_dtl_csr;
2222: END IF;
2223:
2224: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2225: p_api_name => l_api_name,
2226: p_pkg_name => G_PKG_NAME,
2227: p_exc_name => 'OTHERS',
2228: x_msg_count => x_msg_count,

Line 2254: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2250: -- End of comments
2251:
2252: PROCEDURE load_ln_cc_strm_summ(
2253: p_api_version IN NUMBER,
2254: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2255: x_return_status OUT NOCOPY VARCHAR2,
2256: x_msg_count OUT NOCOPY NUMBER,
2257: x_msg_data OUT NOCOPY VARCHAR2,
2258: p_chr_id IN NUMBER,

Line 2328: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2324: l_max_bill_counter NUMBER;
2325:
2326: BEGIN
2327:
2328: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2329: -- Call start_activity to create savepoint, check compatibility
2330: -- and initialize message list
2331: x_return_status := OKL_API.START_ACTIVITY (
2332: l_api_name

Line 2331: x_return_status := OKL_API.START_ACTIVITY (

2327:
2328: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2329: -- Call start_activity to create savepoint, check compatibility
2330: -- and initialize message list
2331: x_return_status := OKL_API.START_ACTIVITY (
2332: l_api_name
2333: ,p_init_msg_list
2334: ,'_PVT'
2335: ,x_return_status);

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

2333: ,p_init_msg_list
2334: ,'_PVT'
2335: ,x_return_status);
2336: -- Check if activity started successfully
2337: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2338: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2339: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2340: RAISE OKL_API.G_EXCEPTION_ERROR;
2341: END IF;

Line 2338: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2334: ,'_PVT'
2335: ,x_return_status);
2336: -- Check if activity started successfully
2337: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2338: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2339: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2340: RAISE OKL_API.G_EXCEPTION_ERROR;
2341: END IF;
2342:

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

2335: ,x_return_status);
2336: -- Check if activity started successfully
2337: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2338: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2339: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2340: RAISE OKL_API.G_EXCEPTION_ERROR;
2341: END IF;
2342:
2343: --Derive Principal Balance

Line 2340: RAISE OKL_API.G_EXCEPTION_ERROR;

2336: -- Check if activity started successfully
2337: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2338: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2339: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2340: RAISE OKL_API.G_EXCEPTION_ERROR;
2341: END IF;
2342:
2343: --Derive Principal Balance
2344: Okl_Execute_Formula_Pub.EXECUTE(p_api_version => p_api_version,

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

2350: p_contract_id => p_chr_id,
2351: p_line_id => NULL,
2352: x_value => l_principal_balance
2353: );
2354: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2356: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2357: RAISE OKL_API.G_EXCEPTION_ERROR;
2358: END IF;

Line 2355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2351: p_line_id => NULL,
2352: x_value => l_principal_balance
2353: );
2354: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2356: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2357: RAISE OKL_API.G_EXCEPTION_ERROR;
2358: END IF;
2359:

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

2352: x_value => l_principal_balance
2353: );
2354: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2356: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2357: RAISE OKL_API.G_EXCEPTION_ERROR;
2358: END IF;
2359:
2360: l_temp_counter := 0;

Line 2357: RAISE OKL_API.G_EXCEPTION_ERROR;

2353: );
2354: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2355: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2356: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2357: RAISE OKL_API.G_EXCEPTION_ERROR;
2358: END IF;
2359:
2360: l_temp_counter := 0;
2361: OPEN amort_sched_dtl_csr(p_chr_id => p_chr_id);

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

2389: x_arrears_yn => l_arrears_yn,
2390: x_periods_tbl => l_periods_tbl
2391: );
2392:
2393: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2394: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2395: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2396: RAISE OKL_API.G_EXCEPTION_ERROR;
2397: END IF;

Line 2394: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2390: x_periods_tbl => l_periods_tbl
2391: );
2392:
2393: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2394: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2395: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2396: RAISE OKL_API.G_EXCEPTION_ERROR;
2397: END IF;
2398:

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

2391: );
2392:
2393: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2394: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2395: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2396: RAISE OKL_API.G_EXCEPTION_ERROR;
2397: END IF;
2398:
2399: l_counter := 1;

Line 2396: RAISE OKL_API.G_EXCEPTION_ERROR;

2392:
2393: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2394: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2395: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2396: RAISE OKL_API.G_EXCEPTION_ERROR;
2397: END IF;
2398:
2399: l_counter := 1;
2400: l_amort_sched_tbl(l_counter).principal_balance := l_principal_balance;

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

2478: END IF;
2479:
2480: x_amort_sched_tbl := l_amort_sched_tbl;
2481:
2482: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);
2483:
2484: EXCEPTION
2485:
2486: ------------------------------------------------------------

Line 2490: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2486: ------------------------------------------------------------
2487: -- Exception handling
2488: ------------------------------------------------------------
2489:
2490: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2491:
2492: IF amort_sched_dtl_csr%ISOPEN THEN
2493: CLOSE amort_sched_dtl_csr;
2494: END IF;

Line 2496: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2492: IF amort_sched_dtl_csr%ISOPEN THEN
2493: CLOSE amort_sched_dtl_csr;
2494: END IF;
2495:
2496: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2497: p_api_name => l_api_name,
2498: p_pkg_name => G_PKG_NAME,
2499: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2500: x_msg_count => x_msg_count,

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

2495:
2496: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2497: p_api_name => l_api_name,
2498: p_pkg_name => G_PKG_NAME,
2499: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2500: x_msg_count => x_msg_count,
2501: x_msg_data => x_msg_data,
2502: p_api_type => '_PVT');
2503:

Line 2504: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2500: x_msg_count => x_msg_count,
2501: x_msg_data => x_msg_data,
2502: p_api_type => '_PVT');
2503:
2504: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2505:
2506: IF amort_sched_dtl_csr%ISOPEN THEN
2507: CLOSE amort_sched_dtl_csr;
2508: END IF;

Line 2510: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2506: IF amort_sched_dtl_csr%ISOPEN THEN
2507: CLOSE amort_sched_dtl_csr;
2508: END IF;
2509:
2510: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2511: p_api_name => l_api_name,
2512: p_pkg_name => G_PKG_NAME,
2513: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2514: x_msg_count => x_msg_count,

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

2509:
2510: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2511: p_api_name => l_api_name,
2512: p_pkg_name => G_PKG_NAME,
2513: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2514: x_msg_count => x_msg_count,
2515: x_msg_data => x_msg_data,
2516: p_api_type => '_PVT');
2517:

Line 2524: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2520: IF amort_sched_dtl_csr%ISOPEN THEN
2521: CLOSE amort_sched_dtl_csr;
2522: END IF;
2523:
2524: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2525: p_api_name => l_api_name,
2526: p_pkg_name => G_PKG_NAME,
2527: p_exc_name => 'OTHERS',
2528: x_msg_count => x_msg_count,

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

2539: x_msg_data OUT NOCOPY VARCHAR2,
2540: p_chr_id IN NUMBER,
2541: x_schedule_match_yn OUT NOCOPY VARCHAR2) IS
2542:
2543: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2544: l_api_name CONSTANT VARCHAR2(30) := 'CHECK_PAYMENT_SCHEDULE';
2545: l_api_version CONSTANT NUMBER := 1.0;
2546:
2547: TYPE l_payment_details_rec IS RECORD (

Line 2676: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

2672: END IF;
2673: END;
2674:
2675: BEGIN
2676: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
2677: x_schedule_match_yn := 'N';
2678:
2679: l_payment_table_counter := 1;
2680: l_payment_table_tmt_counter := 1;

Line 2865: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2861: --Bug 14529968
2862:
2863: EXCEPTION
2864: WHEN schedule_mismatch THEN
2865: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2866: x_schedule_match_yn := 'N';
2867:
2868: WHEN OTHERS THEN
2869: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2869: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2865: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2866: x_schedule_match_yn := 'N';
2867:
2868: WHEN OTHERS THEN
2869: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2870: x_schedule_match_yn := 'N';
2871:
2872: END check_payment_schedule;
2873:

Line 2876: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,

2872: END check_payment_schedule;
2873:
2874: PROCEDURE load_loan_amort_schedule(
2875: p_api_version IN NUMBER,
2876: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
2877: x_return_status OUT NOCOPY VARCHAR2,
2878: x_msg_count OUT NOCOPY NUMBER,
2879: x_msg_data OUT NOCOPY VARCHAR2,
2880: p_chr_id IN NUMBER,

Line 2913: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2909: l_proj_interest_rate NUMBER;
2910:
2911: BEGIN
2912:
2913: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2914: -- Call start_activity to create savepoint, check compatibility
2915: -- and initialize message list
2916: x_return_status := OKL_API.START_ACTIVITY (
2917: l_api_name

Line 2916: x_return_status := OKL_API.START_ACTIVITY (

2912:
2913: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2914: -- Call start_activity to create savepoint, check compatibility
2915: -- and initialize message list
2916: x_return_status := OKL_API.START_ACTIVITY (
2917: l_api_name
2918: ,p_init_msg_list
2919: ,'_PVT'
2920: ,x_return_status);

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

2918: ,p_init_msg_list
2919: ,'_PVT'
2920: ,x_return_status);
2921: -- Check if activity started successfully
2922: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2923: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2924: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2925: RAISE OKL_API.G_EXCEPTION_ERROR;
2926: END IF;

Line 2923: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2919: ,'_PVT'
2920: ,x_return_status);
2921: -- Check if activity started successfully
2922: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2923: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2924: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2925: RAISE OKL_API.G_EXCEPTION_ERROR;
2926: END IF;
2927:

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

2920: ,x_return_status);
2921: -- Check if activity started successfully
2922: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2923: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2924: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2925: RAISE OKL_API.G_EXCEPTION_ERROR;
2926: END IF;
2927:
2928: -- Summary Report: Check whether all assets have same Payment Schedule

Line 2925: RAISE OKL_API.G_EXCEPTION_ERROR;

2921: -- Check if activity started successfully
2922: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2923: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2924: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2925: RAISE OKL_API.G_EXCEPTION_ERROR;
2926: END IF;
2927:
2928: -- Summary Report: Check whether all assets have same Payment Schedule
2929: IF p_report_type = G_REPORT_TYPE_SUMMARY THEN

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

2936: x_msg_data => x_msg_data,
2937: p_chr_id => p_chr_id,
2938: x_schedule_match_yn => l_schedule_match_yn);
2939:
2940: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2941: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2942: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2943: RAISE OKL_API.G_EXCEPTION_ERROR;
2944: END IF;

Line 2941: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2937: p_chr_id => p_chr_id,
2938: x_schedule_match_yn => l_schedule_match_yn);
2939:
2940: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2941: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2942: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2943: RAISE OKL_API.G_EXCEPTION_ERROR;
2944: END IF;
2945:

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

2938: x_schedule_match_yn => l_schedule_match_yn);
2939:
2940: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2941: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2942: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2943: RAISE OKL_API.G_EXCEPTION_ERROR;
2944: END IF;
2945:
2946: END IF;

Line 2943: RAISE OKL_API.G_EXCEPTION_ERROR;

2939:
2940: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2941: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2942: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2943: RAISE OKL_API.G_EXCEPTION_ERROR;
2944: END IF;
2945:
2946: END IF;
2947:

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

2963: x_msg_data => x_msg_data,
2964: p_chr_id => p_chr_id,
2965: x_amort_sched_tbl => x_amort_sched_tbl);
2966:
2967: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2968: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2969: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2970: RAISE OKL_API.G_EXCEPTION_ERROR;
2971: END IF;

Line 2968: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2964: p_chr_id => p_chr_id,
2965: x_amort_sched_tbl => x_amort_sched_tbl);
2966:
2967: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2968: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2969: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2970: RAISE OKL_API.G_EXCEPTION_ERROR;
2971: END IF;
2972:

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

2965: x_amort_sched_tbl => x_amort_sched_tbl);
2966:
2967: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2968: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2969: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2970: RAISE OKL_API.G_EXCEPTION_ERROR;
2971: END IF;
2972:
2973:

Line 2970: RAISE OKL_API.G_EXCEPTION_ERROR;

2966:
2967: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2968: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2969: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2970: RAISE OKL_API.G_EXCEPTION_ERROR;
2971: END IF;
2972:
2973:
2974: ELSIF p_report_type = G_REPORT_TYPE_DETAIL THEN

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

2981: x_msg_data => x_msg_data,
2982: p_chr_id => p_chr_id,
2983: x_amort_sched_tbl => x_amort_sched_tbl);
2984:
2985: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2986: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2987: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2988: RAISE OKL_API.G_EXCEPTION_ERROR;
2989: END IF;

Line 2986: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2982: p_chr_id => p_chr_id,
2983: x_amort_sched_tbl => x_amort_sched_tbl);
2984:
2985: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2986: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2987: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2988: RAISE OKL_API.G_EXCEPTION_ERROR;
2989: END IF;
2990:

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

2983: x_amort_sched_tbl => x_amort_sched_tbl);
2984:
2985: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2986: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2987: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2988: RAISE OKL_API.G_EXCEPTION_ERROR;
2989: END IF;
2990:
2991:

Line 2988: RAISE OKL_API.G_EXCEPTION_ERROR;

2984:
2985: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2986: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2987: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2988: RAISE OKL_API.G_EXCEPTION_ERROR;
2989: END IF;
2990:
2991:
2992: END IF;

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

3006: p_chr_id => p_chr_id,
3007: x_proj_interest_rate => l_proj_interest_rate,
3008: x_amort_sched_tbl => x_amort_sched_tbl);
3009:
3010: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3011: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3012: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3013: RAISE OKL_API.G_EXCEPTION_ERROR;
3014: END IF;

Line 3011: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3007: x_proj_interest_rate => l_proj_interest_rate,
3008: x_amort_sched_tbl => x_amort_sched_tbl);
3009:
3010: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3011: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3012: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3013: RAISE OKL_API.G_EXCEPTION_ERROR;
3014: END IF;
3015:

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

3008: x_amort_sched_tbl => x_amort_sched_tbl);
3009:
3010: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3011: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3012: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3013: RAISE OKL_API.G_EXCEPTION_ERROR;
3014: END IF;
3015:
3016: ELSIF p_report_type = G_REPORT_TYPE_DETAIL THEN

Line 3013: RAISE OKL_API.G_EXCEPTION_ERROR;

3009:
3010: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3011: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3012: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3013: RAISE OKL_API.G_EXCEPTION_ERROR;
3014: END IF;
3015:
3016: ELSIF p_report_type = G_REPORT_TYPE_DETAIL THEN
3017:

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

3025: p_chr_id => p_chr_id,
3026: x_proj_interest_rate => l_proj_interest_rate,
3027: x_amort_sched_tbl => x_amort_sched_tbl);
3028:
3029: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3030: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3031: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3032: RAISE OKL_API.G_EXCEPTION_ERROR;
3033: END IF;

Line 3030: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3026: x_proj_interest_rate => l_proj_interest_rate,
3027: x_amort_sched_tbl => x_amort_sched_tbl);
3028:
3029: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3030: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3031: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3032: RAISE OKL_API.G_EXCEPTION_ERROR;
3033: END IF;
3034:

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

3027: x_amort_sched_tbl => x_amort_sched_tbl);
3028:
3029: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3030: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3031: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3032: RAISE OKL_API.G_EXCEPTION_ERROR;
3033: END IF;
3034:
3035: END IF;

Line 3032: RAISE OKL_API.G_EXCEPTION_ERROR;

3028:
3029: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3030: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3031: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3032: RAISE OKL_API.G_EXCEPTION_ERROR;
3033: END IF;
3034:
3035: END IF;
3036: x_proj_interest_rate :=l_proj_interest_rate;

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

3048: x_msg_data => x_msg_data,
3049: p_chr_id => p_chr_id,
3050: x_amort_sched_tbl => x_amort_sched_tbl);
3051:
3052: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3053: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3054: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3055: RAISE OKL_API.G_EXCEPTION_ERROR;
3056: END IF;

Line 3053: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3049: p_chr_id => p_chr_id,
3050: x_amort_sched_tbl => x_amort_sched_tbl);
3051:
3052: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3053: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3054: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3055: RAISE OKL_API.G_EXCEPTION_ERROR;
3056: END IF;
3057:

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

3050: x_amort_sched_tbl => x_amort_sched_tbl);
3051:
3052: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3053: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3054: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3055: RAISE OKL_API.G_EXCEPTION_ERROR;
3056: END IF;
3057:
3058: ELSIF p_report_type = G_REPORT_TYPE_DETAIL THEN

Line 3055: RAISE OKL_API.G_EXCEPTION_ERROR;

3051:
3052: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3053: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3054: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3055: RAISE OKL_API.G_EXCEPTION_ERROR;
3056: END IF;
3057:
3058: ELSIF p_report_type = G_REPORT_TYPE_DETAIL THEN
3059:

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

3066: x_msg_data => x_msg_data,
3067: p_chr_id => p_chr_id,
3068: x_amort_sched_tbl => x_amort_sched_tbl);
3069:
3070: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3071: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3072: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3073: RAISE OKL_API.G_EXCEPTION_ERROR;
3074: END IF;

Line 3071: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3067: p_chr_id => p_chr_id,
3068: x_amort_sched_tbl => x_amort_sched_tbl);
3069:
3070: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3071: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3072: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3073: RAISE OKL_API.G_EXCEPTION_ERROR;
3074: END IF;
3075:

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

3068: x_amort_sched_tbl => x_amort_sched_tbl);
3069:
3070: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3071: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3072: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3073: RAISE OKL_API.G_EXCEPTION_ERROR;
3074: END IF;
3075:
3076: END IF;

Line 3073: RAISE OKL_API.G_EXCEPTION_ERROR;

3069:
3070: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3071: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3072: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3073: RAISE OKL_API.G_EXCEPTION_ERROR;
3074: END IF;
3075:
3076: END IF;
3077: x_proj_interest_rate := chr_product_rec.implicit_interest_rate;

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

3089: x_msg_data => x_msg_data,
3090: p_chr_id => p_chr_id,
3091: x_amort_sched_tbl => x_amort_sched_tbl);
3092:
3093: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3094: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3095: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3096: RAISE OKL_API.G_EXCEPTION_ERROR;
3097: END IF;

Line 3094: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3090: p_chr_id => p_chr_id,
3091: x_amort_sched_tbl => x_amort_sched_tbl);
3092:
3093: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3094: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3095: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3096: RAISE OKL_API.G_EXCEPTION_ERROR;
3097: END IF;
3098:

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

3091: x_amort_sched_tbl => x_amort_sched_tbl);
3092:
3093: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3094: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3095: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3096: RAISE OKL_API.G_EXCEPTION_ERROR;
3097: END IF;
3098:
3099: ELSIF p_report_type = G_REPORT_TYPE_DETAIL THEN

Line 3096: RAISE OKL_API.G_EXCEPTION_ERROR;

3092:
3093: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3094: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3095: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3096: RAISE OKL_API.G_EXCEPTION_ERROR;
3097: END IF;
3098:
3099: ELSIF p_report_type = G_REPORT_TYPE_DETAIL THEN
3100:

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

3107: x_msg_data => x_msg_data,
3108: p_chr_id => p_chr_id,
3109: x_amort_sched_tbl => x_amort_sched_tbl);
3110:
3111: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3112: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3113: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3114: RAISE OKL_API.G_EXCEPTION_ERROR;
3115: END IF;

Line 3112: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3108: p_chr_id => p_chr_id,
3109: x_amort_sched_tbl => x_amort_sched_tbl);
3110:
3111: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3112: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3113: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3114: RAISE OKL_API.G_EXCEPTION_ERROR;
3115: END IF;
3116:

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

3109: x_amort_sched_tbl => x_amort_sched_tbl);
3110:
3111: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3112: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3113: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3114: RAISE OKL_API.G_EXCEPTION_ERROR;
3115: END IF;
3116:
3117: END IF;

Line 3114: RAISE OKL_API.G_EXCEPTION_ERROR;

3110:
3111: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3112: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3113: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3114: RAISE OKL_API.G_EXCEPTION_ERROR;
3115: END IF;
3116:
3117: END IF;
3118: x_proj_interest_rate := chr_product_rec.implicit_interest_rate;

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

3134: END IF;
3135: END IF;
3136:
3137: END IF;
3138: OKL_API.END_ACTIVITY (x_msg_count,x_msg_data);
3139:
3140: EXCEPTION
3141:
3142: ------------------------------------------------------------

Line 3146: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3142: ------------------------------------------------------------
3143: -- Exception handling
3144: ------------------------------------------------------------
3145:
3146: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3147:
3148: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
3149: p_api_name => l_api_name,
3150: p_pkg_name => G_PKG_NAME,

Line 3148: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

3144: ------------------------------------------------------------
3145:
3146: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3147:
3148: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
3149: p_api_name => l_api_name,
3150: p_pkg_name => G_PKG_NAME,
3151: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3152: x_msg_count => x_msg_count,

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

3147:
3148: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
3149: p_api_name => l_api_name,
3150: p_pkg_name => G_PKG_NAME,
3151: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3152: x_msg_count => x_msg_count,
3153: x_msg_data => x_msg_data,
3154: p_api_type => '_PVT');
3155:

Line 3156: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3152: x_msg_count => x_msg_count,
3153: x_msg_data => x_msg_data,
3154: p_api_type => '_PVT');
3155:
3156: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3157:
3158: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
3159: p_api_name => l_api_name,
3160: p_pkg_name => G_PKG_NAME,

Line 3158: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

3154: p_api_type => '_PVT');
3155:
3156: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3157:
3158: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
3159: p_api_name => l_api_name,
3160: p_pkg_name => G_PKG_NAME,
3161: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3162: x_msg_count => x_msg_count,

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

3157:
3158: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
3159: p_api_name => l_api_name,
3160: p_pkg_name => G_PKG_NAME,
3161: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3162: x_msg_count => x_msg_count,
3163: x_msg_data => x_msg_data,
3164: p_api_type => '_PVT');
3165:

Line 3168: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

3164: p_api_type => '_PVT');
3165:
3166: WHEN OTHERS THEN
3167:
3168: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
3169: p_api_name => l_api_name,
3170: p_pkg_name => G_PKG_NAME,
3171: p_exc_name => 'OTHERS',
3172: x_msg_count => x_msg_count,