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

Line 104: x_return_status := OKL_API.G_RET_STS_SUCCESS;

100: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_billed');
101: END IF;
102:
103: l_interest_billed := 0;
104: x_return_status := OKL_API.G_RET_STS_SUCCESS;
105: IF ( p_khr_id IS NULL ) THEN
106: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
107: END IF;
108:

Line 106: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

102:
103: l_interest_billed := 0;
104: x_return_status := OKL_API.G_RET_STS_SUCCESS;
105: IF ( p_khr_id IS NULL ) THEN
106: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
107: END IF;
108:
109: OPEN l_interest_billed_csr(p_khr_id, p_from_date, p_to_date);
110: FETCH l_interest_billed_csr INTO l_interest_billed;

Line 119: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

115: END IF;
116:
117: RETURN l_interest_billed;
118: EXCEPTION
119: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
120: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
121: RETURN l_interest_billed;
122: WHEN OTHERS THEN
123: IF l_interest_billed_csr%ISOPEN THEN

Line 120: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

116:
117: RETURN l_interest_billed;
118: EXCEPTION
119: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
120: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
121: RETURN l_interest_billed;
122: WHEN OTHERS THEN
123: IF l_interest_billed_csr%ISOPEN THEN
124: CLOSE l_interest_billed_csr;

Line 126: OKL_API.SET_MESSAGE(

122: WHEN OTHERS THEN
123: IF l_interest_billed_csr%ISOPEN THEN
124: CLOSE l_interest_billed_csr;
125: END IF;
126: OKL_API.SET_MESSAGE(
127: p_app_name => G_APP_NAME,
128: p_msg_name => G_UNEXPECTED_ERROR,
129: p_token1 => G_SQLCODE_TOKEN,
130: p_token1_value => SQLCODE,

Line 250: x_return_status := OKL_API.G_RET_STS_SUCCESS;

246: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_paid');
247: END IF;
248:
249: l_interest_paid := 0;
250: x_return_status := OKL_API.G_RET_STS_SUCCESS;
251: IF ( p_khr_id IS NULL ) THEN
252: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
253: END IF;
254:

Line 252: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

248:
249: l_interest_paid := 0;
250: x_return_status := OKL_API.G_RET_STS_SUCCESS;
251: IF ( p_khr_id IS NULL ) THEN
252: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
253: END IF;
254:
255: OPEN l_interest_paid_csr(p_khr_id, p_from_date, p_to_date);
256: FETCH l_interest_paid_csr INTO l_interest_paid;

Line 265: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

261: END IF;
262:
263: RETURN l_interest_paid;
264: EXCEPTION
265: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
266: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
267: RETURN l_interest_paid;
268: WHEN OTHERS THEN
269: IF l_interest_paid_csr%ISOPEN THEN

Line 266: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

262:
263: RETURN l_interest_paid;
264: EXCEPTION
265: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
266: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
267: RETURN l_interest_paid;
268: WHEN OTHERS THEN
269: IF l_interest_paid_csr%ISOPEN THEN
270: CLOSE l_interest_paid_csr;

Line 272: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

268: WHEN OTHERS THEN
269: IF l_interest_paid_csr%ISOPEN THEN
270: CLOSE l_interest_paid_csr;
271: END IF;
272: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
273: OKL_API.SET_MESSAGE(
274: p_app_name => G_APP_NAME,
275: p_msg_name => G_UNEXPECTED_ERROR,
276: p_token1 => G_SQLCODE_TOKEN,

Line 273: OKL_API.SET_MESSAGE(

269: IF l_interest_paid_csr%ISOPEN THEN
270: CLOSE l_interest_paid_csr;
271: END IF;
272: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
273: OKL_API.SET_MESSAGE(
274: p_app_name => G_APP_NAME,
275: p_msg_name => G_UNEXPECTED_ERROR,
276: p_token1 => G_SQLCODE_TOKEN,
277: p_token1_value => SQLCODE,

Line 367: x_return_status := OKL_API.G_RET_STS_SUCCESS;

363: END IF;
364:
365: l_interest_amt := 0;
366: l_interest_due := 0;
367: x_return_status := OKL_API.G_RET_STS_SUCCESS;
368: IF ( p_khr_id IS NULL ) THEN
369: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
370: END IF;
371:

Line 369: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

365: l_interest_amt := 0;
366: l_interest_due := 0;
367: x_return_status := OKL_API.G_RET_STS_SUCCESS;
368: IF ( p_khr_id IS NULL ) THEN
369: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
370: END IF;
371:
372: OPEN l_principal_basis_csr(p_khr_id);
373: FETCH l_principal_basis_csr INTO l_principal_basis;

Line 404: p_init_msg_list => OKL_API.G_FALSE,

400: --change for bug fix 4905791
401: IF (l_rev_rec_mthd = 'ACTUAL') THEN
402: l_interest_due := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(
403: p_api_version => l_api_version,
404: p_init_msg_list => OKL_API.G_FALSE,
405: x_return_status => x_return_status,
406: x_msg_count => x_msg_count,
407: x_msg_data => x_msg_data,
408: p_contract_id => p_khr_id,

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

410: p_start_date => l_start_date,
411: p_due_date => l_to_date,
412: p_principal_basis => 'ACTUAL');
413:
414: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
415: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
416: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
417: RAISE OKL_API.G_EXCEPTION_ERROR;
418: END IF;

Line 415: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

411: p_due_date => l_to_date,
412: p_principal_basis => 'ACTUAL');
413:
414: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
415: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
416: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
417: RAISE OKL_API.G_EXCEPTION_ERROR;
418: END IF;
419: ELSE

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

412: p_principal_basis => 'ACTUAL');
413:
414: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
415: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
416: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
417: RAISE OKL_API.G_EXCEPTION_ERROR;
418: END IF;
419: ELSE
420:

Line 417: RAISE OKL_API.G_EXCEPTION_ERROR;

413:
414: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
415: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
416: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
417: RAISE OKL_API.G_EXCEPTION_ERROR;
418: END IF;
419: ELSE
420:
421: IF l_principal_basis = 'ACTUAL' THEN

Line 424: p_init_msg_list => OKL_API.G_FALSE,

420:
421: IF l_principal_basis = 'ACTUAL' THEN
422: l_interest_due := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(
423: p_api_version => l_api_version,
424: p_init_msg_list => OKL_API.G_FALSE,
425: x_return_status => x_return_status,
426: x_msg_count => x_msg_count,
427: x_msg_data => x_msg_data,
428: p_contract_id => p_khr_id,

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

429: p_currency_code => l_contract_info_rec.currency_code,
430: p_start_date => l_start_date,
431: p_due_date => l_to_date,
432: p_principal_basis => 'ACTUAL');
433: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
434: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
435: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
436: RAISE OKL_API.G_EXCEPTION_ERROR;
437: END IF;

Line 434: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

430: p_start_date => l_start_date,
431: p_due_date => l_to_date,
432: p_principal_basis => 'ACTUAL');
433: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
434: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
435: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
436: RAISE OKL_API.G_EXCEPTION_ERROR;
437: END IF;
438: ELSIF l_principal_basis = 'SCHEDULED' THEN

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

431: p_due_date => l_to_date,
432: p_principal_basis => 'ACTUAL');
433: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
434: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
435: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
436: RAISE OKL_API.G_EXCEPTION_ERROR;
437: END IF;
438: ELSIF l_principal_basis = 'SCHEDULED' THEN
439: /*OPEN l_int_calc_basis_csr(p_khr_id);

Line 436: RAISE OKL_API.G_EXCEPTION_ERROR;

432: p_principal_basis => 'ACTUAL');
433: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
434: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
435: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
436: RAISE OKL_API.G_EXCEPTION_ERROR;
437: END IF;
438: ELSIF l_principal_basis = 'SCHEDULED' THEN
439: /*OPEN l_int_calc_basis_csr(p_khr_id);
440: FETCH l_int_calc_basis_csr INTO l_int_calc_basis;

Line 452: p_init_msg_list => OKL_API.G_FALSE,

448: ELSIF (l_int_calc_basis = 'FLOAT') THEN
449: LOOP
450: OKL_STREAM_GENERATOR_PVT.get_next_billing_date(
451: p_api_version => l_api_version,
452: p_init_msg_list => OKL_API.G_FALSE,
453: p_khr_id => p_khr_id,
454: p_billing_date => l_start_date,
455: x_next_due_date => l_due_date,
456: x_next_period_start_date => l_next_period_start_date,

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

457: x_next_period_end_date => l_next_period_end_date,
458: x_return_status => x_return_status,
459: x_msg_count => x_msg_count,
460: x_msg_data => x_msg_data);
461: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
462: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
463: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
464: RAISE OKL_API.G_EXCEPTION_ERROR;
465: END IF;

Line 462: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

458: x_return_status => x_return_status,
459: x_msg_count => x_msg_count,
460: x_msg_data => x_msg_data);
461: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
462: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
463: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
464: RAISE OKL_API.G_EXCEPTION_ERROR;
465: END IF;
466: --dkagrawa changed condition from > to >= for bug 4742907

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

459: x_msg_count => x_msg_count,
460: x_msg_data => x_msg_data);
461: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
462: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
463: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
464: RAISE OKL_API.G_EXCEPTION_ERROR;
465: END IF;
466: --dkagrawa changed condition from > to >= for bug 4742907
467: --dkagrawa handled nvl for fully billed contract bug#6660659

Line 464: RAISE OKL_API.G_EXCEPTION_ERROR;

460: x_msg_data => x_msg_data);
461: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
462: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
463: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
464: RAISE OKL_API.G_EXCEPTION_ERROR;
465: END IF;
466: --dkagrawa changed condition from > to >= for bug 4742907
467: --dkagrawa handled nvl for fully billed contract bug#6660659
468: IF nvl(l_due_date,l_to_date) >= l_to_date THEN

Line 473: p_init_msg_list => OKL_API.G_FALSE,

469: l_due_date := l_to_date;
470: END IF;
471: l_interest_amt := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(
472: p_api_version => l_api_version,
473: p_init_msg_list => OKL_API.G_FALSE,
474: x_return_status => x_return_status,
475: x_msg_count => x_msg_count,
476: x_msg_data => x_msg_data,
477: p_contract_id => p_khr_id,

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

479: p_start_date => l_next_period_start_date,
480: p_due_date => l_due_date,
481: p_principal_basis => 'SCHEDULED');
482:
483: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
484: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
485: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
486: RAISE OKL_API.G_EXCEPTION_ERROR;
487: END IF;

Line 484: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

480: p_due_date => l_due_date,
481: p_principal_basis => 'SCHEDULED');
482:
483: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
484: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
485: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
486: RAISE OKL_API.G_EXCEPTION_ERROR;
487: END IF;
488:

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

481: p_principal_basis => 'SCHEDULED');
482:
483: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
484: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
485: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
486: RAISE OKL_API.G_EXCEPTION_ERROR;
487: END IF;
488:
489: l_interest_due := l_interest_due + l_interest_amt;

Line 486: RAISE OKL_API.G_EXCEPTION_ERROR;

482:
483: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
484: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
485: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
486: RAISE OKL_API.G_EXCEPTION_ERROR;
487: END IF;
488:
489: l_interest_due := l_interest_due + l_interest_amt;
490: IF l_due_date >= l_to_date THEN

Line 504: WHEN OKL_API.G_EXCEPTION_ERROR THEN

500: END IF;
501:
502: RETURN l_interest_due;
503: EXCEPTION
504: WHEN OKL_API.G_EXCEPTION_ERROR THEN
505: x_return_status := OKL_API.G_RET_STS_ERROR;
506: RETURN l_interest_due;
507: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
508: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 505: x_return_status := OKL_API.G_RET_STS_ERROR;

501:
502: RETURN l_interest_due;
503: EXCEPTION
504: WHEN OKL_API.G_EXCEPTION_ERROR THEN
505: x_return_status := OKL_API.G_RET_STS_ERROR;
506: RETURN l_interest_due;
507: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
508: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
509: RETURN l_interest_due;

Line 507: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

503: EXCEPTION
504: WHEN OKL_API.G_EXCEPTION_ERROR THEN
505: x_return_status := OKL_API.G_RET_STS_ERROR;
506: RETURN l_interest_due;
507: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
508: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
509: RETURN l_interest_due;
510: WHEN OTHERS THEN
511: IF l_principal_basis_csr%ISOPEN THEN

Line 508: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

504: WHEN OKL_API.G_EXCEPTION_ERROR THEN
505: x_return_status := OKL_API.G_RET_STS_ERROR;
506: RETURN l_interest_due;
507: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
508: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
509: RETURN l_interest_due;
510: WHEN OTHERS THEN
511: IF l_principal_basis_csr%ISOPEN THEN
512: CLOSE l_principal_basis_csr;

Line 517: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

513: END IF;
514: IF l_contract_info_csr%ISOPEN THEN
515: CLOSE l_contract_info_csr;
516: END IF;
517: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
518: OKL_API.SET_MESSAGE(
519: p_app_name => G_APP_NAME,
520: p_msg_name => G_UNEXPECTED_ERROR,
521: p_token1 => G_SQLCODE_TOKEN,

Line 518: OKL_API.SET_MESSAGE(

514: IF l_contract_info_csr%ISOPEN THEN
515: CLOSE l_contract_info_csr;
516: END IF;
517: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
518: OKL_API.SET_MESSAGE(
519: p_app_name => G_APP_NAME,
520: p_msg_name => G_UNEXPECTED_ERROR,
521: p_token1 => G_SQLCODE_TOKEN,
522: p_token1_value => SQLCODE,

Line 631: x_return_status := OKL_API.G_RET_STS_SUCCESS;

627: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_principal_bal');
628: END IF;
629:
630: l_principal_bal := 0;
631: x_return_status := OKL_API.G_RET_STS_SUCCESS;
632: IF ( p_khr_id IS NULL ) THEN
633: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
634: END IF;
635:

Line 633: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

629:
630: l_principal_bal := 0;
631: x_return_status := OKL_API.G_RET_STS_SUCCESS;
632: IF ( p_khr_id IS NULL ) THEN
633: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
634: END IF;
635:
636: OPEN l_principal_basis_csr(p_khr_id);
637: FETCH l_principal_basis_csr INTO l_start_date,l_principal_basis;

Line 670: p_init_msg_list => OKL_API.G_FALSE,

666: --change for bug fix 4905791
667: IF (l_principal_basis = 'ACTUAL' OR l_rev_rec_mthd = 'ACTUAL') THEN
668: OKL_VARIABLE_INTEREST_PVT.prin_date_range_var_rate_ctr (
669: p_api_version => l_api_version,
670: p_init_msg_list => OKL_API.G_FALSE,
671: x_return_status => x_return_status,
672: x_msg_count => x_msg_count,
673: x_msg_data => x_msg_data,
674: p_contract_id => p_khr_id,

Line 698: p_init_msg_list => OKL_API.G_FALSE,

694: END IF;
695:
696: OKL_VARIABLE_INTEREST_PVT.prin_date_range_var_rate_ctr (
697: p_api_version => l_api_version,
698: p_init_msg_list => OKL_API.G_FALSE,
699: x_return_status => x_return_status,
700: x_msg_count => x_msg_count,
701: x_msg_data => x_msg_data,
702: p_contract_id => p_khr_id,

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

706: p_principal_basis => 'SCHEDULED',
707: x_principal_balance_tbl => l_principal_balance_tbl);
708: END IF;
709:
710: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
711: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
712: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
713: RAISE OKL_API.G_EXCEPTION_ERROR;
714: END IF;

Line 711: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

707: x_principal_balance_tbl => l_principal_balance_tbl);
708: END IF;
709:
710: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
711: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
712: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
713: RAISE OKL_API.G_EXCEPTION_ERROR;
714: END IF;
715:

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

708: END IF;
709:
710: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
711: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
712: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
713: RAISE OKL_API.G_EXCEPTION_ERROR;
714: END IF;
715:
716: IF l_principal_balance_tbl.COUNT > 0 THEN

Line 713: RAISE OKL_API.G_EXCEPTION_ERROR;

709:
710: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
711: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
712: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
713: RAISE OKL_API.G_EXCEPTION_ERROR;
714: END IF;
715:
716: IF l_principal_balance_tbl.COUNT > 0 THEN
717: l_principal_bal := l_principal_balance_tbl(l_principal_balance_tbl.COUNT).principal_balance;

Line 726: WHEN OKL_API.G_EXCEPTION_ERROR THEN

722: END IF;
723:
724: RETURN l_principal_bal;
725: EXCEPTION
726: WHEN OKL_API.G_EXCEPTION_ERROR THEN
727:
728: -- sechawla 02-may-08 6939451
729: IF contract_csr%ISOPEN THEN
730: CLOSE contract_csr;

Line 733: x_return_status := OKL_API.G_RET_STS_ERROR;

729: IF contract_csr%ISOPEN THEN
730: CLOSE contract_csr;
731: END IF;
732:
733: x_return_status := OKL_API.G_RET_STS_ERROR;
734: RETURN l_principal_bal;
735: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
736:
737: -- sechawla 02-may-08 6939451

Line 735: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

731: END IF;
732:
733: x_return_status := OKL_API.G_RET_STS_ERROR;
734: RETURN l_principal_bal;
735: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
736:
737: -- sechawla 02-may-08 6939451
738: IF contract_csr%ISOPEN THEN
739: CLOSE contract_csr;

Line 742: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

738: IF contract_csr%ISOPEN THEN
739: CLOSE contract_csr;
740: END IF;
741:
742: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
743: RETURN l_principal_bal;
744: WHEN OTHERS THEN
745:
746: -- sechawla 02-may-08 6939451

Line 754: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

750:
751: IF l_principal_basis_csr%ISOPEN THEN
752: CLOSE l_principal_basis_csr;
753: END IF;
754: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
755: OKL_API.SET_MESSAGE(
756: p_app_name => G_APP_NAME,
757: p_msg_name => G_UNEXPECTED_ERROR,
758: p_token1 => G_SQLCODE_TOKEN,

Line 755: OKL_API.SET_MESSAGE(

751: IF l_principal_basis_csr%ISOPEN THEN
752: CLOSE l_principal_basis_csr;
753: END IF;
754: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
755: OKL_API.SET_MESSAGE(
756: p_app_name => G_APP_NAME,
757: p_msg_name => G_UNEXPECTED_ERROR,
758: p_token1 => G_SQLCODE_TOKEN,
759: p_token1_value => SQLCODE,

Line 884: x_return_status := OKL_API.G_RET_STS_SUCCESS;

880: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_principal_paid');
881: END IF;
882:
883: l_principal_paid := 0;
884: x_return_status := OKL_API.G_RET_STS_SUCCESS;
885: IF ( p_khr_id IS NULL ) THEN
886: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
887: END IF;
888: -- Begin bug 6456733

Line 886: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

882:
883: l_principal_paid := 0;
884: x_return_status := OKL_API.G_RET_STS_SUCCESS;
885: IF ( p_khr_id IS NULL ) THEN
886: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
887: END IF;
888: -- Begin bug 6456733
889: --OPEN l_principal_paid_csr(p_khr_id, p_kle_id, p_from_date, p_to_date);
890: OPEN l_principal_paid_csr(p_khr_id, p_from_date, p_to_date);

Line 900: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

896: END IF;
897:
898: RETURN l_principal_paid;
899: EXCEPTION
900: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
901: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
902: RETURN l_principal_paid;
903: WHEN OTHERS THEN
904: IF l_principal_paid_csr%ISOPEN THEN

Line 901: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

897:
898: RETURN l_principal_paid;
899: EXCEPTION
900: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
901: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
902: RETURN l_principal_paid;
903: WHEN OTHERS THEN
904: IF l_principal_paid_csr%ISOPEN THEN
905: CLOSE l_principal_paid_csr;

Line 907: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

903: WHEN OTHERS THEN
904: IF l_principal_paid_csr%ISOPEN THEN
905: CLOSE l_principal_paid_csr;
906: END IF;
907: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
908: OKL_API.SET_MESSAGE(
909: p_app_name => G_APP_NAME,
910: p_msg_name => G_UNEXPECTED_ERROR,
911: p_token1 => G_SQLCODE_TOKEN,

Line 908: OKL_API.SET_MESSAGE(

904: IF l_principal_paid_csr%ISOPEN THEN
905: CLOSE l_principal_paid_csr;
906: END IF;
907: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
908: OKL_API.SET_MESSAGE(
909: p_app_name => G_APP_NAME,
910: p_msg_name => G_UNEXPECTED_ERROR,
911: p_token1 => G_SQLCODE_TOKEN,
912: p_token1_value => SQLCODE,

Line 959: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

955: END IF;
956:
957: l_interest_rate_change_flag := 'N';
958: IF ( p_khr_id IS NULL ) THEN
959: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
960: END IF;
961:
962: OPEN l_var_int_params_csr(p_khr_id);
963: FETCH l_var_int_params_csr INTO l_var_int_params_rec;

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

966: x_return_status => x_return_status,
967: p_khr_id => p_khr_id,
968: p_effective_date => l_var_int_params_rec.interest_calc_end_date + 1);
969:
970: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
971: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
972: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
973: RAISE OKL_API.G_EXCEPTION_ERROR;
974: END IF;

Line 971: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

967: p_khr_id => p_khr_id,
968: p_effective_date => l_var_int_params_rec.interest_calc_end_date + 1);
969:
970: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
971: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
972: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
973: RAISE OKL_API.G_EXCEPTION_ERROR;
974: END IF;
975: IF l_effective_int_rate <> l_var_int_params_rec.interest_rate THEN

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

968: p_effective_date => l_var_int_params_rec.interest_calc_end_date + 1);
969:
970: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
971: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
972: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
973: RAISE OKL_API.G_EXCEPTION_ERROR;
974: END IF;
975: IF l_effective_int_rate <> l_var_int_params_rec.interest_rate THEN
976: l_interest_rate_change_flag := 'Y';

Line 973: RAISE OKL_API.G_EXCEPTION_ERROR;

969:
970: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
971: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
972: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
973: RAISE OKL_API.G_EXCEPTION_ERROR;
974: END IF;
975: IF l_effective_int_rate <> l_var_int_params_rec.interest_rate THEN
976: l_interest_rate_change_flag := 'Y';
977: END IF;

Line 985: WHEN OKL_API.G_EXCEPTION_ERROR THEN

981: END IF;
982:
983: RETURN l_interest_rate_change_flag;
984: EXCEPTION
985: WHEN OKL_API.G_EXCEPTION_ERROR THEN
986: x_return_status := OKL_API.G_RET_STS_ERROR;
987: RETURN l_interest_rate_change_flag;
988: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
989: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 986: x_return_status := OKL_API.G_RET_STS_ERROR;

982:
983: RETURN l_interest_rate_change_flag;
984: EXCEPTION
985: WHEN OKL_API.G_EXCEPTION_ERROR THEN
986: x_return_status := OKL_API.G_RET_STS_ERROR;
987: RETURN l_interest_rate_change_flag;
988: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
989: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
990: RETURN l_interest_rate_change_flag;

Line 988: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

984: EXCEPTION
985: WHEN OKL_API.G_EXCEPTION_ERROR THEN
986: x_return_status := OKL_API.G_RET_STS_ERROR;
987: RETURN l_interest_rate_change_flag;
988: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
989: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
990: RETURN l_interest_rate_change_flag;
991: WHEN OTHERS THEN
992: IF l_var_int_params_csr%ISOPEN THEN

Line 989: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

985: WHEN OKL_API.G_EXCEPTION_ERROR THEN
986: x_return_status := OKL_API.G_RET_STS_ERROR;
987: RETURN l_interest_rate_change_flag;
988: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
989: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
990: RETURN l_interest_rate_change_flag;
991: WHEN OTHERS THEN
992: IF l_var_int_params_csr%ISOPEN THEN
993: CLOSE l_var_int_params_csr;

Line 995: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

991: WHEN OTHERS THEN
992: IF l_var_int_params_csr%ISOPEN THEN
993: CLOSE l_var_int_params_csr;
994: END IF;
995: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
996: OKL_API.SET_MESSAGE(
997: p_app_name => G_APP_NAME,
998: p_msg_name => G_UNEXPECTED_ERROR,
999: p_token1 => G_SQLCODE_TOKEN,

Line 996: OKL_API.SET_MESSAGE(

992: IF l_var_int_params_csr%ISOPEN THEN
993: CLOSE l_var_int_params_csr;
994: END IF;
995: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
996: OKL_API.SET_MESSAGE(
997: p_app_name => G_APP_NAME,
998: p_msg_name => G_UNEXPECTED_ERROR,
999: p_token1 => G_SQLCODE_TOKEN,
1000: p_token1_value => SQLCODE,

Line 1053: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1049: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_effective_int_rate');
1050: END IF;
1051:
1052: l_effective_int_rate := 0;
1053: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1054: IF ( p_khr_id IS NULL ) THEN
1055: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1056: END IF;
1057:

Line 1055: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1051:
1052: l_effective_int_rate := 0;
1053: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1054: IF ( p_khr_id IS NULL ) THEN
1055: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1056: END IF;
1057:
1058: OPEN l_calc_basis_csr(p_khr_id);
1059: FETCH l_calc_basis_csr INTO l_process_flag, l_end_date;

Line 1069: p_init_msg_list => OKL_API.G_FALSE,

1065: END IF;
1066:
1067: OKL_VARIABLE_INTEREST_PVT.interest_date_range (
1068: p_api_version => l_api_version,
1069: p_init_msg_list => OKL_API.G_FALSE,
1070: x_return_status => x_return_status,
1071: x_msg_count => x_msg_count,
1072: x_msg_data => x_msg_data,
1073: p_contract_id => p_khr_id,

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

1075: p_end_date => l_effective_date,
1076: p_process_flag => l_process_flag,
1077: x_interest_rate_tbl => l_interest_rate_tbl);
1078:
1079: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1080: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1081: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
1082: RAISE OKL_API.G_EXCEPTION_ERROR;
1083: END IF;

Line 1080: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1076: p_process_flag => l_process_flag,
1077: x_interest_rate_tbl => l_interest_rate_tbl);
1078:
1079: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1080: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1081: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
1082: RAISE OKL_API.G_EXCEPTION_ERROR;
1083: END IF;
1084:

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

1077: x_interest_rate_tbl => l_interest_rate_tbl);
1078:
1079: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1080: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1081: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
1082: RAISE OKL_API.G_EXCEPTION_ERROR;
1083: END IF;
1084:
1085: IF l_interest_rate_tbl.COUNT > 0 THEN

Line 1082: RAISE OKL_API.G_EXCEPTION_ERROR;

1078:
1079: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1080: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1081: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
1082: RAISE OKL_API.G_EXCEPTION_ERROR;
1083: END IF;
1084:
1085: IF l_interest_rate_tbl.COUNT > 0 THEN
1086: l_effective_int_rate := l_interest_rate_tbl(l_interest_rate_tbl.COUNT).rate;

Line 1095: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1091: END IF;
1092:
1093: RETURN l_effective_int_rate;
1094: EXCEPTION
1095: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1096: x_return_status := OKL_API.G_RET_STS_ERROR;
1097: RETURN l_effective_int_rate;
1098: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1099: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1096: x_return_status := OKL_API.G_RET_STS_ERROR;

1092:
1093: RETURN l_effective_int_rate;
1094: EXCEPTION
1095: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1096: x_return_status := OKL_API.G_RET_STS_ERROR;
1097: RETURN l_effective_int_rate;
1098: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1099: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1100: RETURN l_effective_int_rate;

Line 1098: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1094: EXCEPTION
1095: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1096: x_return_status := OKL_API.G_RET_STS_ERROR;
1097: RETURN l_effective_int_rate;
1098: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1099: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1100: RETURN l_effective_int_rate;
1101: WHEN OTHERS THEN
1102: IF l_calc_basis_csr%ISOPEN THEN

Line 1099: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1095: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1096: x_return_status := OKL_API.G_RET_STS_ERROR;
1097: RETURN l_effective_int_rate;
1098: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1099: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1100: RETURN l_effective_int_rate;
1101: WHEN OTHERS THEN
1102: IF l_calc_basis_csr%ISOPEN THEN
1103: CLOSE l_calc_basis_csr;

Line 1105: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1101: WHEN OTHERS THEN
1102: IF l_calc_basis_csr%ISOPEN THEN
1103: CLOSE l_calc_basis_csr;
1104: END IF;
1105: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1106: OKL_API.SET_MESSAGE(
1107: p_app_name => G_APP_NAME,
1108: p_msg_name => G_UNEXPECTED_ERROR,
1109: p_token1 => G_SQLCODE_TOKEN,

Line 1106: OKL_API.SET_MESSAGE(

1102: IF l_calc_basis_csr%ISOPEN THEN
1103: CLOSE l_calc_basis_csr;
1104: END IF;
1105: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1106: OKL_API.SET_MESSAGE(
1107: p_app_name => G_APP_NAME,
1108: p_msg_name => G_UNEXPECTED_ERROR,
1109: p_token1 => G_SQLCODE_TOKEN,
1110: p_token1_value => SQLCODE,

Line 1160: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1156:
1157: l_interest_billed := 0;
1158: l_interest_due := 0;
1159: l_interest_due_unbilled := 0;
1160: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1161: IF ( p_khr_id IS NULL ) THEN
1162: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1163: END IF;
1164:

Line 1162: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1158: l_interest_due := 0;
1159: l_interest_due_unbilled := 0;
1160: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1161: IF ( p_khr_id IS NULL ) THEN
1162: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1163: END IF;
1164:
1165: OPEN l_start_date_csr(p_khr_id);
1166: FETCH l_start_date_csr INTO l_start_date;

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

1168: l_interest_due := get_interest_due(
1169: x_return_status => x_return_status,
1170: p_khr_id => p_khr_id,
1171: p_to_date => p_effective_date);
1172: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1173: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1174: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1175: RAISE OKL_API.G_EXCEPTION_ERROR;
1176: END IF;

Line 1173: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1169: x_return_status => x_return_status,
1170: p_khr_id => p_khr_id,
1171: p_to_date => p_effective_date);
1172: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1173: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1174: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1175: RAISE OKL_API.G_EXCEPTION_ERROR;
1176: END IF;
1177: l_interest_billed := get_interest_billed(

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

1170: p_khr_id => p_khr_id,
1171: p_to_date => p_effective_date);
1172: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1173: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1174: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1175: RAISE OKL_API.G_EXCEPTION_ERROR;
1176: END IF;
1177: l_interest_billed := get_interest_billed(
1178: x_return_status => x_return_status,

Line 1175: RAISE OKL_API.G_EXCEPTION_ERROR;

1171: p_to_date => p_effective_date);
1172: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1173: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1174: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1175: RAISE OKL_API.G_EXCEPTION_ERROR;
1176: END IF;
1177: l_interest_billed := get_interest_billed(
1178: x_return_status => x_return_status,
1179: p_khr_id => p_khr_id,

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

1178: x_return_status => x_return_status,
1179: p_khr_id => p_khr_id,
1180: p_from_date => l_start_date,
1181: p_to_date => p_effective_date);
1182: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1183: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1184: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1185: RAISE OKL_API.G_EXCEPTION_ERROR;
1186: END IF;

Line 1183: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1179: p_khr_id => p_khr_id,
1180: p_from_date => l_start_date,
1181: p_to_date => p_effective_date);
1182: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1183: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1184: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1185: RAISE OKL_API.G_EXCEPTION_ERROR;
1186: END IF;
1187: l_interest_due_unbilled := l_interest_due - l_interest_billed;

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

1180: p_from_date => l_start_date,
1181: p_to_date => p_effective_date);
1182: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1183: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1184: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1185: RAISE OKL_API.G_EXCEPTION_ERROR;
1186: END IF;
1187: l_interest_due_unbilled := l_interest_due - l_interest_billed;
1188:

Line 1185: RAISE OKL_API.G_EXCEPTION_ERROR;

1181: p_to_date => p_effective_date);
1182: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1183: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1184: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1185: RAISE OKL_API.G_EXCEPTION_ERROR;
1186: END IF;
1187: l_interest_due_unbilled := l_interest_due - l_interest_billed;
1188:
1189: IF(NVL(l_debug_enabled,'N')='Y') THEN

Line 1195: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1191: END IF;
1192:
1193: RETURN l_interest_due_unbilled;
1194: EXCEPTION
1195: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1196: x_return_status := OKL_API.G_RET_STS_ERROR;
1197: RETURN l_interest_due_unbilled;
1198: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1199: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1196: x_return_status := OKL_API.G_RET_STS_ERROR;

1192:
1193: RETURN l_interest_due_unbilled;
1194: EXCEPTION
1195: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1196: x_return_status := OKL_API.G_RET_STS_ERROR;
1197: RETURN l_interest_due_unbilled;
1198: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1199: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1200: RETURN l_interest_due_unbilled;

Line 1198: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1194: EXCEPTION
1195: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1196: x_return_status := OKL_API.G_RET_STS_ERROR;
1197: RETURN l_interest_due_unbilled;
1198: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1199: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1200: RETURN l_interest_due_unbilled;
1201: WHEN OTHERS THEN
1202: IF l_start_date_csr%ISOPEN THEN

Line 1199: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1195: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1196: x_return_status := OKL_API.G_RET_STS_ERROR;
1197: RETURN l_interest_due_unbilled;
1198: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1199: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1200: RETURN l_interest_due_unbilled;
1201: WHEN OTHERS THEN
1202: IF l_start_date_csr%ISOPEN THEN
1203: CLOSE l_start_date_csr;

Line 1205: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1201: WHEN OTHERS THEN
1202: IF l_start_date_csr%ISOPEN THEN
1203: CLOSE l_start_date_csr;
1204: END IF;
1205: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1206: OKL_API.SET_MESSAGE(
1207: p_app_name => G_APP_NAME,
1208: p_msg_name => G_UNEXPECTED_ERROR,
1209: p_token1 => G_SQLCODE_TOKEN,

Line 1206: OKL_API.SET_MESSAGE(

1202: IF l_start_date_csr%ISOPEN THEN
1203: CLOSE l_start_date_csr;
1204: END IF;
1205: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1206: OKL_API.SET_MESSAGE(
1207: p_app_name => G_APP_NAME,
1208: p_msg_name => G_UNEXPECTED_ERROR,
1209: p_token1 => G_SQLCODE_TOKEN,
1210: p_token1_value => SQLCODE,

Line 1299: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1295: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_principal_billed');
1296: END IF;
1297:
1298: l_principal_billed := 0;
1299: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1300: IF ( p_khr_id IS NULL ) THEN
1301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1302: END IF;
1303:

Line 1301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1297:
1298: l_principal_billed := 0;
1299: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1300: IF ( p_khr_id IS NULL ) THEN
1301: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1302: END IF;
1303:
1304: -- Begin bug 6456733
1305: --OPEN l_principal_billed_csr(p_khr_id, p_kle_id, p_from_date, p_to_date);

Line 1317: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1313: END IF;
1314:
1315: RETURN l_principal_billed;
1316: EXCEPTION
1317: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1318: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1319: RETURN l_principal_billed;
1320: WHEN OTHERS THEN
1321: IF l_principal_billed_csr%ISOPEN THEN

Line 1318: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1314:
1315: RETURN l_principal_billed;
1316: EXCEPTION
1317: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1318: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1319: RETURN l_principal_billed;
1320: WHEN OTHERS THEN
1321: IF l_principal_billed_csr%ISOPEN THEN
1322: CLOSE l_principal_billed_csr;

Line 1324: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1320: WHEN OTHERS THEN
1321: IF l_principal_billed_csr%ISOPEN THEN
1322: CLOSE l_principal_billed_csr;
1323: END IF;
1324: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1325: OKL_API.SET_MESSAGE(
1326: p_app_name => G_APP_NAME,
1327: p_msg_name => G_UNEXPECTED_ERROR,
1328: p_token1 => G_SQLCODE_TOKEN,

Line 1325: OKL_API.SET_MESSAGE(

1321: IF l_principal_billed_csr%ISOPEN THEN
1322: CLOSE l_principal_billed_csr;
1323: END IF;
1324: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1325: OKL_API.SET_MESSAGE(
1326: p_app_name => G_APP_NAME,
1327: p_msg_name => G_UNEXPECTED_ERROR,
1328: p_token1 => G_SQLCODE_TOKEN,
1329: p_token1_value => SQLCODE,

Line 1403: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1399: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_float_factor_billed');
1400: END IF;
1401:
1402: l_float_factor_billed := 0;
1403: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1404: IF ( p_khr_id IS NULL ) THEN
1405: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1406: END IF;
1407:

Line 1405: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1401:
1402: l_float_factor_billed := 0;
1403: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1404: IF ( p_khr_id IS NULL ) THEN
1405: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1406: END IF;
1407:
1408: OPEN l_float_billed_csr(p_khr_id, p_effective_date);
1409: FETCH l_float_billed_csr INTO l_float_factor_billed;

Line 1418: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1414: END IF;
1415:
1416: RETURN l_float_factor_billed;
1417: EXCEPTION
1418: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1419: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1420: RETURN l_float_factor_billed;
1421: WHEN OTHERS THEN
1422: IF l_float_billed_csr%ISOPEN THEN

Line 1419: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1415:
1416: RETURN l_float_factor_billed;
1417: EXCEPTION
1418: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1419: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1420: RETURN l_float_factor_billed;
1421: WHEN OTHERS THEN
1422: IF l_float_billed_csr%ISOPEN THEN
1423: CLOSE l_float_billed_csr;

Line 1425: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1421: WHEN OTHERS THEN
1422: IF l_float_billed_csr%ISOPEN THEN
1423: CLOSE l_float_billed_csr;
1424: END IF;
1425: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1426: OKL_API.SET_MESSAGE(
1427: p_app_name => G_APP_NAME,
1428: p_msg_name => G_UNEXPECTED_ERROR,
1429: p_token1 => G_SQLCODE_TOKEN,

Line 1426: OKL_API.SET_MESSAGE(

1422: IF l_float_billed_csr%ISOPEN THEN
1423: CLOSE l_float_billed_csr;
1424: END IF;
1425: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1426: OKL_API.SET_MESSAGE(
1427: p_app_name => G_APP_NAME,
1428: p_msg_name => G_UNEXPECTED_ERROR,
1429: p_token1 => G_SQLCODE_TOKEN,
1430: p_token1_value => SQLCODE,

Line 1505: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1501: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_loan_payment_billed');
1502: END IF;
1503:
1504: l_loan_payment_billed := 0;
1505: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1506: IF ( p_khr_id IS NULL ) THEN
1507: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1508: END IF;
1509:

Line 1507: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1503:
1504: l_loan_payment_billed := 0;
1505: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1506: IF ( p_khr_id IS NULL ) THEN
1507: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1508: END IF;
1509:
1510: OPEN l_loan_payment_billed_csr(p_khr_id, p_effective_date);
1511: FETCH l_loan_payment_billed_csr INTO l_loan_payment_billed;

Line 1520: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1516: END IF;
1517:
1518: RETURN l_loan_payment_billed;
1519: EXCEPTION
1520: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1521: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1522: RETURN l_loan_payment_billed;
1523: WHEN OTHERS THEN
1524: IF l_loan_payment_billed_csr%ISOPEN THEN

Line 1521: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1517:
1518: RETURN l_loan_payment_billed;
1519: EXCEPTION
1520: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1521: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1522: RETURN l_loan_payment_billed;
1523: WHEN OTHERS THEN
1524: IF l_loan_payment_billed_csr%ISOPEN THEN
1525: CLOSE l_loan_payment_billed_csr;

Line 1527: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1523: WHEN OTHERS THEN
1524: IF l_loan_payment_billed_csr%ISOPEN THEN
1525: CLOSE l_loan_payment_billed_csr;
1526: END IF;
1527: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1528: OKL_API.SET_MESSAGE(
1529: p_app_name => G_APP_NAME,
1530: p_msg_name => G_UNEXPECTED_ERROR,
1531: p_token1 => G_SQLCODE_TOKEN,

Line 1528: OKL_API.SET_MESSAGE(

1524: IF l_loan_payment_billed_csr%ISOPEN THEN
1525: CLOSE l_loan_payment_billed_csr;
1526: END IF;
1527: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1528: OKL_API.SET_MESSAGE(
1529: p_app_name => G_APP_NAME,
1530: p_msg_name => G_UNEXPECTED_ERROR,
1531: p_token1 => G_SQLCODE_TOKEN,
1532: p_token1_value => SQLCODE,

Line 1614: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1610: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_loan_payment_paid');
1611: END IF;
1612:
1613: l_loan_payment_paid := 0;
1614: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1615: IF ( p_khr_id IS NULL ) THEN
1616: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1617: END IF;
1618:

Line 1616: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1612:
1613: l_loan_payment_paid := 0;
1614: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1615: IF ( p_khr_id IS NULL ) THEN
1616: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1617: END IF;
1618:
1619: OPEN l_laon_payment_csr(p_khr_id, p_effective_date);
1620: FETCH l_laon_payment_csr INTO l_loan_payment_paid;

Line 1629: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1625: END IF;
1626:
1627: RETURN l_loan_payment_paid;
1628: EXCEPTION
1629: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1630: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1631: RETURN l_loan_payment_paid;
1632: WHEN OTHERS THEN
1633: IF l_laon_payment_csr%ISOPEN THEN

Line 1630: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1626:
1627: RETURN l_loan_payment_paid;
1628: EXCEPTION
1629: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1630: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1631: RETURN l_loan_payment_paid;
1632: WHEN OTHERS THEN
1633: IF l_laon_payment_csr%ISOPEN THEN
1634: CLOSE l_laon_payment_csr;

Line 1636: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1632: WHEN OTHERS THEN
1633: IF l_laon_payment_csr%ISOPEN THEN
1634: CLOSE l_laon_payment_csr;
1635: END IF;
1636: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1637: OKL_API.SET_MESSAGE(
1638: p_app_name => G_APP_NAME,
1639: p_msg_name => G_UNEXPECTED_ERROR,
1640: p_token1 => G_SQLCODE_TOKEN,

Line 1637: OKL_API.SET_MESSAGE(

1633: IF l_laon_payment_csr%ISOPEN THEN
1634: CLOSE l_laon_payment_csr;
1635: END IF;
1636: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1637: OKL_API.SET_MESSAGE(
1638: p_app_name => G_APP_NAME,
1639: p_msg_name => G_UNEXPECTED_ERROR,
1640: p_token1 => G_SQLCODE_TOKEN,
1641: p_token1_value => SQLCODE,

Line 1689: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1685: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_excess_loan_payment');
1686: END IF;
1687:
1688: l_excess_loan_payment := 0;
1689: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1690: IF ( p_khr_id IS NULL ) THEN
1691: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1692: END IF;
1693:

Line 1691: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1687:
1688: l_excess_loan_payment := 0;
1689: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1690: IF ( p_khr_id IS NULL ) THEN
1691: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1692: END IF;
1693:
1694: OPEN l_laon_payment_csr(p_khr_id);
1695: FETCH l_laon_payment_csr INTO l_excess_loan_payment;

Line 1704: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1700: END IF;
1701:
1702: RETURN l_excess_loan_payment;
1703: EXCEPTION
1704: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1705: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1706: RETURN l_excess_loan_payment;
1707: WHEN OTHERS THEN
1708: IF l_laon_payment_csr%ISOPEN THEN

Line 1705: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1701:
1702: RETURN l_excess_loan_payment;
1703: EXCEPTION
1704: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1705: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1706: RETURN l_excess_loan_payment;
1707: WHEN OTHERS THEN
1708: IF l_laon_payment_csr%ISOPEN THEN
1709: CLOSE l_laon_payment_csr;

Line 1711: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1707: WHEN OTHERS THEN
1708: IF l_laon_payment_csr%ISOPEN THEN
1709: CLOSE l_laon_payment_csr;
1710: END IF;
1711: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1712: OKL_API.SET_MESSAGE(
1713: p_app_name => G_APP_NAME,
1714: p_msg_name => G_UNEXPECTED_ERROR,
1715: p_token1 => G_SQLCODE_TOKEN,

Line 1712: OKL_API.SET_MESSAGE(

1708: IF l_laon_payment_csr%ISOPEN THEN
1709: CLOSE l_laon_payment_csr;
1710: END IF;
1711: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1712: OKL_API.SET_MESSAGE(
1713: p_app_name => G_APP_NAME,
1714: p_msg_name => G_UNEXPECTED_ERROR,
1715: p_token1 => G_SQLCODE_TOKEN,
1716: p_token1_value => SQLCODE,

Line 1756: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1752: IF(NVL(l_debug_enabled,'N')='Y') THEN
1753: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_last_interim_int_calc_date');
1754: END IF;
1755:
1756: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1757: IF ( p_khr_id IS NULL ) THEN
1758: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1759: END IF;
1760:

Line 1758: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1754: END IF;
1755:
1756: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1757: IF ( p_khr_id IS NULL ) THEN
1758: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1759: END IF;
1760:
1761: OPEN l_interest_calc_date_csr(p_khr_id);
1762: FETCH l_interest_calc_date_csr INTO l_last_interest_date;

Line 1769: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1765: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_last_interim_int_calc_date');
1766: END IF;
1767: RETURN l_last_interest_date;
1768: EXCEPTION
1769: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1770: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1771: RETURN l_last_interest_date;
1772: WHEN OTHERS THEN
1773: IF l_interest_calc_date_csr%ISOPEN THEN

Line 1770: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1766: END IF;
1767: RETURN l_last_interest_date;
1768: EXCEPTION
1769: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1770: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1771: RETURN l_last_interest_date;
1772: WHEN OTHERS THEN
1773: IF l_interest_calc_date_csr%ISOPEN THEN
1774: CLOSE l_interest_calc_date_csr;

Line 1776: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1772: WHEN OTHERS THEN
1773: IF l_interest_calc_date_csr%ISOPEN THEN
1774: CLOSE l_interest_calc_date_csr;
1775: END IF;
1776: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1777: OKL_API.SET_MESSAGE(
1778: p_app_name => G_APP_NAME,
1779: p_msg_name => G_UNEXPECTED_ERROR,
1780: p_token1 => G_SQLCODE_TOKEN,

Line 1777: OKL_API.SET_MESSAGE(

1773: IF l_interest_calc_date_csr%ISOPEN THEN
1774: CLOSE l_interest_calc_date_csr;
1775: END IF;
1776: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1777: OKL_API.SET_MESSAGE(
1778: p_app_name => G_APP_NAME,
1779: p_msg_name => G_UNEXPECTED_ERROR,
1780: p_token1 => G_SQLCODE_TOKEN,
1781: p_token1_value => SQLCODE,

Line 1878: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1874: l_debug_enabled := okl_debug_pub.check_log_enabled;
1875: IF(NVL(l_debug_enabled,'N')='Y') THEN
1876: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_last_sch_int_calc_date');
1877: END IF;
1878: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1879: IF ( p_khr_id IS NULL ) THEN
1880: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1881: END IF;
1882:

Line 1880: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1876: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_last_sch_int_calc_date');
1877: END IF;
1878: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1879: IF ( p_khr_id IS NULL ) THEN
1880: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1881: END IF;
1882:
1883: OPEN l_pdt_csr(p_khr_id);
1884: FETCH l_pdt_csr INTO l_pdtv_rec.id;

Line 1889: p_init_msg_list => OKL_API.G_FALSE,

1885: CLOSE l_pdt_csr;
1886:
1887: OKL_SETUPPRODUCTS_PVT.getpdt_parameters(
1888: p_api_version => l_api_version,
1889: p_init_msg_list => OKL_API.G_FALSE,
1890: x_return_status => x_return_status,
1891: x_no_data_found => x_no_data_found,
1892: x_msg_count => x_msg_count,
1893: x_msg_data => x_msg_data,

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

1892: x_msg_count => x_msg_count,
1893: x_msg_data => x_msg_data,
1894: p_pdtv_rec => l_pdtv_rec,
1895: p_pdt_parameter_rec => x_pdt_parameter_rec );
1896: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1898: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1899: RAISE OKL_API.G_EXCEPTION_ERROR;
1900: END IF;

Line 1897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1893: x_msg_data => x_msg_data,
1894: p_pdtv_rec => l_pdtv_rec,
1895: p_pdt_parameter_rec => x_pdt_parameter_rec );
1896: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1898: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1899: RAISE OKL_API.G_EXCEPTION_ERROR;
1900: END IF;
1901: OPEN l_date_csr(p_khr_id);

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

1894: p_pdtv_rec => l_pdtv_rec,
1895: p_pdt_parameter_rec => x_pdt_parameter_rec );
1896: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1898: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1899: RAISE OKL_API.G_EXCEPTION_ERROR;
1900: END IF;
1901: OPEN l_date_csr(p_khr_id);
1902: FETCH l_date_csr INTO l_start_date,l_end_date;

Line 1899: RAISE OKL_API.G_EXCEPTION_ERROR;

1895: p_pdt_parameter_rec => x_pdt_parameter_rec );
1896: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1897: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1898: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1899: RAISE OKL_API.G_EXCEPTION_ERROR;
1900: END IF;
1901: OPEN l_date_csr(p_khr_id);
1902: FETCH l_date_csr INTO l_start_date,l_end_date;
1903: CLOSE l_date_csr;

Line 1935: p_init_msg_list => OKL_API.G_FALSE,

1931:
1932: LOOP
1933: OKL_STREAM_GENERATOR_PVT.get_next_billing_date(
1934: p_api_version => l_api_version,
1935: p_init_msg_list => OKL_API.G_FALSE,
1936: p_khr_id => p_khr_id,
1937: p_billing_date => l_start_date,
1938: x_next_due_date => l_due_date,
1939: x_next_period_start_date => l_next_period_start_date,

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

1940: x_next_period_end_date => l_next_period_end_date,
1941: x_return_status => x_return_status,
1942: x_msg_count => x_msg_count,
1943: x_msg_data => x_msg_data);
1944: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1945: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1946: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
1947: RAISE OKL_API.G_EXCEPTION_ERROR;
1948: END IF;

Line 1945: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1941: x_return_status => x_return_status,
1942: x_msg_count => x_msg_count,
1943: x_msg_data => x_msg_data);
1944: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1945: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1946: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
1947: RAISE OKL_API.G_EXCEPTION_ERROR;
1948: END IF;
1949:

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

1942: x_msg_count => x_msg_count,
1943: x_msg_data => x_msg_data);
1944: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1945: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1946: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
1947: RAISE OKL_API.G_EXCEPTION_ERROR;
1948: END IF;
1949:
1950: IF (l_due_date > l_date_terminated OR l_due_date IS NULL) THEN

Line 1947: RAISE OKL_API.G_EXCEPTION_ERROR;

1943: x_msg_data => x_msg_data);
1944: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1945: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1946: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
1947: RAISE OKL_API.G_EXCEPTION_ERROR;
1948: END IF;
1949:
1950: IF (l_due_date > l_date_terminated OR l_due_date IS NULL) THEN
1951: l_last_interest_date := l_start_date;

Line 1982: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1978:
1979: RETURN l_last_interest_date;
1980:
1981: EXCEPTION
1982: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1983: x_return_status := OKL_API.G_RET_STS_ERROR;
1984: RETURN l_last_interest_date;
1985: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1986: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1983: x_return_status := OKL_API.G_RET_STS_ERROR;

1979: RETURN l_last_interest_date;
1980:
1981: EXCEPTION
1982: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1983: x_return_status := OKL_API.G_RET_STS_ERROR;
1984: RETURN l_last_interest_date;
1985: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1986: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1987: RETURN l_last_interest_date;

Line 1985: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1981: EXCEPTION
1982: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1983: x_return_status := OKL_API.G_RET_STS_ERROR;
1984: RETURN l_last_interest_date;
1985: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1986: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1987: RETURN l_last_interest_date;
1988: WHEN OTHERS THEN
1989: IF l_pdt_csr%ISOPEN THEN

Line 1986: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1982: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1983: x_return_status := OKL_API.G_RET_STS_ERROR;
1984: RETURN l_last_interest_date;
1985: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1986: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1987: RETURN l_last_interest_date;
1988: WHEN OTHERS THEN
1989: IF l_pdt_csr%ISOPEN THEN
1990: CLOSE l_pdt_csr;

Line 2004: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2000: END IF;
2001: IF l_catchup_csr%ISOPEN THEN
2002: CLOSE l_catchup_csr;
2003: END IF;
2004: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2005: OKL_API.SET_MESSAGE(
2006: p_app_name => G_APP_NAME,
2007: p_msg_name => G_UNEXPECTED_ERROR,
2008: p_token1 => G_SQLCODE_TOKEN,

Line 2005: OKL_API.SET_MESSAGE(

2001: IF l_catchup_csr%ISOPEN THEN
2002: CLOSE l_catchup_csr;
2003: END IF;
2004: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2005: OKL_API.SET_MESSAGE(
2006: p_app_name => G_APP_NAME,
2007: p_msg_name => G_UNEXPECTED_ERROR,
2008: p_token1 => G_SQLCODE_TOKEN,
2009: p_token1_value => SQLCODE,

Line 2088: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2084: l_debug_enabled := okl_debug_pub.check_log_enabled;
2085: IF(NVL(l_debug_enabled,'N')='Y') THEN
2086: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_open_invoices');
2087: END IF;
2088: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2089: IF ( p_khr_id IS NULL ) THEN
2090: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2091: END IF;
2092:

Line 2090: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2086: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_open_invoices');
2087: END IF;
2088: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2089: IF ( p_khr_id IS NULL ) THEN
2090: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2091: END IF;
2092:
2093: OPEN l_invoice_info_csr(p_khr_id);
2094: FETCH l_invoice_info_csr BULK COLLECT INTO x_invoice_tbl;

Line 2101: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2097: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_open_invoices');
2098: END IF;
2099:
2100: EXCEPTION
2101: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2102: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2103: WHEN OTHERS THEN
2104: IF l_invoice_info_csr%ISOPEN THEN
2105: CLOSE l_invoice_info_csr;

Line 2102: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2098: END IF;
2099:
2100: EXCEPTION
2101: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2102: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2103: WHEN OTHERS THEN
2104: IF l_invoice_info_csr%ISOPEN THEN
2105: CLOSE l_invoice_info_csr;
2106: END IF;

Line 2107: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2103: WHEN OTHERS THEN
2104: IF l_invoice_info_csr%ISOPEN THEN
2105: CLOSE l_invoice_info_csr;
2106: END IF;
2107: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2108: OKL_API.SET_MESSAGE(
2109: p_app_name => G_APP_NAME,
2110: p_msg_name => G_UNEXPECTED_ERROR,
2111: p_token1 => G_SQLCODE_TOKEN,

Line 2108: OKL_API.SET_MESSAGE(

2104: IF l_invoice_info_csr%ISOPEN THEN
2105: CLOSE l_invoice_info_csr;
2106: END IF;
2107: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2108: OKL_API.SET_MESSAGE(
2109: p_app_name => G_APP_NAME,
2110: p_msg_name => G_UNEXPECTED_ERROR,
2111: p_token1 => G_SQLCODE_TOKEN,
2112: p_token1_value => SQLCODE,