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

55: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_billed');
56: END IF;
57:
58: l_interest_billed := 0;
59: x_return_status := OKL_API.G_RET_STS_SUCCESS;
60: IF ( p_khr_id IS NULL ) THEN
61: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
62: END IF;
63:

Line 61: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

57:
58: l_interest_billed := 0;
59: x_return_status := OKL_API.G_RET_STS_SUCCESS;
60: IF ( p_khr_id IS NULL ) THEN
61: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
62: END IF;
63:
64: --Bug# 13447258: Added parameter p_kle_id
65: OPEN l_interest_billed_csr(p_khr_id, p_kle_id, p_from_date, p_to_date);

Line 75: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

71: END IF;
72:
73: RETURN l_interest_billed;
74: EXCEPTION
75: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
76: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
77: RETURN l_interest_billed;
78: WHEN OTHERS THEN
79: IF l_interest_billed_csr%ISOPEN THEN

Line 76: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

72:
73: RETURN l_interest_billed;
74: EXCEPTION
75: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
76: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
77: RETURN l_interest_billed;
78: WHEN OTHERS THEN
79: IF l_interest_billed_csr%ISOPEN THEN
80: CLOSE l_interest_billed_csr;

Line 82: OKL_API.SET_MESSAGE(

78: WHEN OTHERS THEN
79: IF l_interest_billed_csr%ISOPEN THEN
80: CLOSE l_interest_billed_csr;
81: END IF;
82: OKL_API.SET_MESSAGE(
83: p_app_name => G_APP_NAME,
84: p_msg_name => G_UNEXPECTED_ERROR,
85: p_token1 => G_SQLCODE_TOKEN,
86: p_token1_value => SQLCODE,

Line 163: x_return_status := OKL_API.G_RET_STS_SUCCESS;

159: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_interest_paid');
160: END IF;
161:
162: l_interest_paid := 0;
163: x_return_status := OKL_API.G_RET_STS_SUCCESS;
164: IF ( p_khr_id IS NULL ) THEN
165: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
166: END IF;
167:

Line 165: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

161:
162: l_interest_paid := 0;
163: x_return_status := OKL_API.G_RET_STS_SUCCESS;
164: IF ( p_khr_id IS NULL ) THEN
165: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
166: END IF;
167:
168: --Bug# 13447258: Added parameter p_kle_id
169: OPEN l_interest_paid_csr(p_khr_id, p_kle_id, p_from_date, p_to_date);

Line 179: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

175: END IF;
176:
177: RETURN l_interest_paid;
178: EXCEPTION
179: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
180: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
181: RETURN l_interest_paid;
182: WHEN OTHERS THEN
183: IF l_interest_paid_csr%ISOPEN THEN

Line 180: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

176:
177: RETURN l_interest_paid;
178: EXCEPTION
179: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
180: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
181: RETURN l_interest_paid;
182: WHEN OTHERS THEN
183: IF l_interest_paid_csr%ISOPEN THEN
184: CLOSE l_interest_paid_csr;

Line 186: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

182: WHEN OTHERS THEN
183: IF l_interest_paid_csr%ISOPEN THEN
184: CLOSE l_interest_paid_csr;
185: END IF;
186: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
187: OKL_API.SET_MESSAGE(
188: p_app_name => G_APP_NAME,
189: p_msg_name => G_UNEXPECTED_ERROR,
190: p_token1 => G_SQLCODE_TOKEN,

Line 187: OKL_API.SET_MESSAGE(

183: IF l_interest_paid_csr%ISOPEN THEN
184: CLOSE l_interest_paid_csr;
185: END IF;
186: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
187: OKL_API.SET_MESSAGE(
188: p_app_name => G_APP_NAME,
189: p_msg_name => G_UNEXPECTED_ERROR,
190: p_token1 => G_SQLCODE_TOKEN,
191: p_token1_value => SQLCODE,

Line 281: x_return_status := OKL_API.G_RET_STS_SUCCESS;

277: END IF;
278:
279: l_interest_amt := 0;
280: l_interest_due := 0;
281: x_return_status := OKL_API.G_RET_STS_SUCCESS;
282: IF ( p_khr_id IS NULL ) THEN
283: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
284: END IF;
285:

Line 283: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

279: l_interest_amt := 0;
280: l_interest_due := 0;
281: x_return_status := OKL_API.G_RET_STS_SUCCESS;
282: IF ( p_khr_id IS NULL ) THEN
283: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
284: END IF;
285:
286: OPEN l_principal_basis_csr(p_khr_id);
287: FETCH l_principal_basis_csr INTO l_principal_basis;

Line 318: p_init_msg_list => OKL_API.G_FALSE,

314: --change for bug fix 4905791
315: IF (l_rev_rec_mthd = 'ACTUAL') THEN
316: l_interest_due := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(
317: p_api_version => l_api_version,
318: p_init_msg_list => OKL_API.G_FALSE,
319: x_return_status => x_return_status,
320: x_msg_count => x_msg_count,
321: x_msg_data => x_msg_data,
322: p_contract_id => p_khr_id,

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

324: p_start_date => l_start_date,
325: p_due_date => l_to_date,
326: p_principal_basis => 'ACTUAL');
327:
328: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
329: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
330: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
331: RAISE OKL_API.G_EXCEPTION_ERROR;
332: END IF;

Line 329: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

325: p_due_date => l_to_date,
326: p_principal_basis => 'ACTUAL');
327:
328: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
329: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
330: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
331: RAISE OKL_API.G_EXCEPTION_ERROR;
332: END IF;
333: ELSE

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

326: p_principal_basis => 'ACTUAL');
327:
328: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
329: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
330: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
331: RAISE OKL_API.G_EXCEPTION_ERROR;
332: END IF;
333: ELSE
334:

Line 331: RAISE OKL_API.G_EXCEPTION_ERROR;

327:
328: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
329: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
330: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
331: RAISE OKL_API.G_EXCEPTION_ERROR;
332: END IF;
333: ELSE
334:
335: IF l_principal_basis = 'ACTUAL' THEN

Line 338: p_init_msg_list => OKL_API.G_FALSE,

334:
335: IF l_principal_basis = 'ACTUAL' THEN
336: l_interest_due := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(
337: p_api_version => l_api_version,
338: p_init_msg_list => OKL_API.G_FALSE,
339: x_return_status => x_return_status,
340: x_msg_count => x_msg_count,
341: x_msg_data => x_msg_data,
342: p_contract_id => p_khr_id,

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

343: p_currency_code => l_contract_info_rec.currency_code,
344: p_start_date => l_start_date,
345: p_due_date => l_to_date,
346: p_principal_basis => 'ACTUAL');
347: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
348: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
349: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
350: RAISE OKL_API.G_EXCEPTION_ERROR;
351: END IF;

Line 348: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

344: p_start_date => l_start_date,
345: p_due_date => l_to_date,
346: p_principal_basis => 'ACTUAL');
347: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
348: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
349: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
350: RAISE OKL_API.G_EXCEPTION_ERROR;
351: END IF;
352: ELSIF l_principal_basis = 'SCHEDULED' THEN

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

345: p_due_date => l_to_date,
346: p_principal_basis => 'ACTUAL');
347: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
348: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
349: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
350: RAISE OKL_API.G_EXCEPTION_ERROR;
351: END IF;
352: ELSIF l_principal_basis = 'SCHEDULED' THEN
353: /*OPEN l_int_calc_basis_csr(p_khr_id);

Line 350: RAISE OKL_API.G_EXCEPTION_ERROR;

346: p_principal_basis => 'ACTUAL');
347: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
348: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
349: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
350: RAISE OKL_API.G_EXCEPTION_ERROR;
351: END IF;
352: ELSIF l_principal_basis = 'SCHEDULED' THEN
353: /*OPEN l_int_calc_basis_csr(p_khr_id);
354: FETCH l_int_calc_basis_csr INTO l_int_calc_basis;

Line 366: p_init_msg_list => OKL_API.G_FALSE,

362: ELSIF (l_int_calc_basis = 'FLOAT') THEN
363: LOOP
364: OKL_STREAM_GENERATOR_PVT.get_next_billing_date(
365: p_api_version => l_api_version,
366: p_init_msg_list => OKL_API.G_FALSE,
367: p_khr_id => p_khr_id,
368: p_billing_date => l_start_date,
369: x_next_due_date => l_due_date,
370: x_next_period_start_date => l_next_period_start_date,

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

371: x_next_period_end_date => l_next_period_end_date,
372: x_return_status => x_return_status,
373: x_msg_count => x_msg_count,
374: x_msg_data => x_msg_data);
375: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
376: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
377: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
378: RAISE OKL_API.G_EXCEPTION_ERROR;
379: END IF;

Line 376: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

372: x_return_status => x_return_status,
373: x_msg_count => x_msg_count,
374: x_msg_data => x_msg_data);
375: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
376: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
377: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
378: RAISE OKL_API.G_EXCEPTION_ERROR;
379: END IF;
380: --dkagrawa changed condition from > to >= for bug 4742907

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

373: x_msg_count => x_msg_count,
374: x_msg_data => x_msg_data);
375: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
376: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
377: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
378: RAISE OKL_API.G_EXCEPTION_ERROR;
379: END IF;
380: --dkagrawa changed condition from > to >= for bug 4742907
381: --dkagrawa handled nvl for fully billed contract bug#6660659

Line 378: RAISE OKL_API.G_EXCEPTION_ERROR;

374: x_msg_data => x_msg_data);
375: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
376: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
377: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
378: RAISE OKL_API.G_EXCEPTION_ERROR;
379: END IF;
380: --dkagrawa changed condition from > to >= for bug 4742907
381: --dkagrawa handled nvl for fully billed contract bug#6660659
382: IF nvl(l_due_date,l_to_date) >= l_to_date THEN

Line 387: p_init_msg_list => OKL_API.G_FALSE,

383: l_due_date := l_to_date;
384: END IF;
385: l_interest_amt := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(
386: p_api_version => l_api_version,
387: p_init_msg_list => OKL_API.G_FALSE,
388: x_return_status => x_return_status,
389: x_msg_count => x_msg_count,
390: x_msg_data => x_msg_data,
391: p_contract_id => p_khr_id,

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

393: p_start_date => l_next_period_start_date,
394: p_due_date => l_due_date,
395: p_principal_basis => 'SCHEDULED');
396:
397: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
398: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
399: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
400: RAISE OKL_API.G_EXCEPTION_ERROR;
401: END IF;

Line 398: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

394: p_due_date => l_due_date,
395: p_principal_basis => 'SCHEDULED');
396:
397: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
398: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
399: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
400: RAISE OKL_API.G_EXCEPTION_ERROR;
401: END IF;
402:

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

395: p_principal_basis => 'SCHEDULED');
396:
397: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
398: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
399: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
400: RAISE OKL_API.G_EXCEPTION_ERROR;
401: END IF;
402:
403: l_interest_due := l_interest_due + l_interest_amt;

Line 400: RAISE OKL_API.G_EXCEPTION_ERROR;

396:
397: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
398: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
399: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
400: RAISE OKL_API.G_EXCEPTION_ERROR;
401: END IF;
402:
403: l_interest_due := l_interest_due + l_interest_amt;
404: IF l_due_date >= l_to_date THEN

Line 418: WHEN OKL_API.G_EXCEPTION_ERROR THEN

414: END IF;
415:
416: RETURN l_interest_due;
417: EXCEPTION
418: WHEN OKL_API.G_EXCEPTION_ERROR THEN
419: x_return_status := OKL_API.G_RET_STS_ERROR;
420: RETURN l_interest_due;
421: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
422: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 419: x_return_status := OKL_API.G_RET_STS_ERROR;

415:
416: RETURN l_interest_due;
417: EXCEPTION
418: WHEN OKL_API.G_EXCEPTION_ERROR THEN
419: x_return_status := OKL_API.G_RET_STS_ERROR;
420: RETURN l_interest_due;
421: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
422: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
423: RETURN l_interest_due;

Line 421: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

417: EXCEPTION
418: WHEN OKL_API.G_EXCEPTION_ERROR THEN
419: x_return_status := OKL_API.G_RET_STS_ERROR;
420: RETURN l_interest_due;
421: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
422: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
423: RETURN l_interest_due;
424: WHEN OTHERS THEN
425: IF l_principal_basis_csr%ISOPEN THEN

Line 422: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

418: WHEN OKL_API.G_EXCEPTION_ERROR THEN
419: x_return_status := OKL_API.G_RET_STS_ERROR;
420: RETURN l_interest_due;
421: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
422: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
423: RETURN l_interest_due;
424: WHEN OTHERS THEN
425: IF l_principal_basis_csr%ISOPEN THEN
426: CLOSE l_principal_basis_csr;

Line 431: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

427: END IF;
428: IF l_contract_info_csr%ISOPEN THEN
429: CLOSE l_contract_info_csr;
430: END IF;
431: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
432: OKL_API.SET_MESSAGE(
433: p_app_name => G_APP_NAME,
434: p_msg_name => G_UNEXPECTED_ERROR,
435: p_token1 => G_SQLCODE_TOKEN,

Line 432: OKL_API.SET_MESSAGE(

428: IF l_contract_info_csr%ISOPEN THEN
429: CLOSE l_contract_info_csr;
430: END IF;
431: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
432: OKL_API.SET_MESSAGE(
433: p_app_name => G_APP_NAME,
434: p_msg_name => G_UNEXPECTED_ERROR,
435: p_token1 => G_SQLCODE_TOKEN,
436: p_token1_value => SQLCODE,

Line 545: x_return_status := OKL_API.G_RET_STS_SUCCESS;

541: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_principal_bal');
542: END IF;
543:
544: l_principal_bal := 0;
545: x_return_status := OKL_API.G_RET_STS_SUCCESS;
546: IF ( p_khr_id IS NULL ) THEN
547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
548: END IF;
549:

Line 547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

543:
544: l_principal_bal := 0;
545: x_return_status := OKL_API.G_RET_STS_SUCCESS;
546: IF ( p_khr_id IS NULL ) THEN
547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
548: END IF;
549:
550: OPEN l_principal_basis_csr(p_khr_id);
551: FETCH l_principal_basis_csr INTO l_start_date,l_principal_basis;

Line 584: p_init_msg_list => OKL_API.G_FALSE,

580: --change for bug fix 4905791
581: IF (l_principal_basis = 'ACTUAL' OR l_rev_rec_mthd = 'ACTUAL') THEN
582: OKL_VARIABLE_INTEREST_PVT.prin_date_range_var_rate_ctr (
583: p_api_version => l_api_version,
584: p_init_msg_list => OKL_API.G_FALSE,
585: x_return_status => x_return_status,
586: x_msg_count => x_msg_count,
587: x_msg_data => x_msg_data,
588: p_contract_id => p_khr_id,

Line 612: p_init_msg_list => OKL_API.G_FALSE,

608: END IF;
609:
610: OKL_VARIABLE_INTEREST_PVT.prin_date_range_var_rate_ctr (
611: p_api_version => l_api_version,
612: p_init_msg_list => OKL_API.G_FALSE,
613: x_return_status => x_return_status,
614: x_msg_count => x_msg_count,
615: x_msg_data => x_msg_data,
616: p_contract_id => p_khr_id,

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

620: p_principal_basis => 'SCHEDULED',
621: x_principal_balance_tbl => l_principal_balance_tbl);
622: END IF;
623:
624: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
625: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
626: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
627: RAISE OKL_API.G_EXCEPTION_ERROR;
628: END IF;

Line 625: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

621: x_principal_balance_tbl => l_principal_balance_tbl);
622: END IF;
623:
624: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
625: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
626: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
627: RAISE OKL_API.G_EXCEPTION_ERROR;
628: END IF;
629:

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

622: END IF;
623:
624: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
625: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
626: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
627: RAISE OKL_API.G_EXCEPTION_ERROR;
628: END IF;
629:
630: IF l_principal_balance_tbl.COUNT > 0 THEN

Line 627: RAISE OKL_API.G_EXCEPTION_ERROR;

623:
624: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
625: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
626: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
627: RAISE OKL_API.G_EXCEPTION_ERROR;
628: END IF;
629:
630: IF l_principal_balance_tbl.COUNT > 0 THEN
631: l_principal_bal := l_principal_balance_tbl(l_principal_balance_tbl.COUNT).principal_balance;

Line 640: WHEN OKL_API.G_EXCEPTION_ERROR THEN

636: END IF;
637:
638: RETURN l_principal_bal;
639: EXCEPTION
640: WHEN OKL_API.G_EXCEPTION_ERROR THEN
641:
642: -- sechawla 02-may-08 6939451
643: IF contract_csr%ISOPEN THEN
644: CLOSE contract_csr;

Line 647: x_return_status := OKL_API.G_RET_STS_ERROR;

643: IF contract_csr%ISOPEN THEN
644: CLOSE contract_csr;
645: END IF;
646:
647: x_return_status := OKL_API.G_RET_STS_ERROR;
648: RETURN l_principal_bal;
649: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
650:
651: -- sechawla 02-may-08 6939451

Line 649: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

645: END IF;
646:
647: x_return_status := OKL_API.G_RET_STS_ERROR;
648: RETURN l_principal_bal;
649: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
650:
651: -- sechawla 02-may-08 6939451
652: IF contract_csr%ISOPEN THEN
653: CLOSE contract_csr;

Line 656: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

652: IF contract_csr%ISOPEN THEN
653: CLOSE contract_csr;
654: END IF;
655:
656: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
657: RETURN l_principal_bal;
658: WHEN OTHERS THEN
659:
660: -- sechawla 02-may-08 6939451

Line 668: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

664:
665: IF l_principal_basis_csr%ISOPEN THEN
666: CLOSE l_principal_basis_csr;
667: END IF;
668: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
669: OKL_API.SET_MESSAGE(
670: p_app_name => G_APP_NAME,
671: p_msg_name => G_UNEXPECTED_ERROR,
672: p_token1 => G_SQLCODE_TOKEN,

Line 669: OKL_API.SET_MESSAGE(

665: IF l_principal_basis_csr%ISOPEN THEN
666: CLOSE l_principal_basis_csr;
667: END IF;
668: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
669: OKL_API.SET_MESSAGE(
670: p_app_name => G_APP_NAME,
671: p_msg_name => G_UNEXPECTED_ERROR,
672: p_token1 => G_SQLCODE_TOKEN,
673: p_token1_value => SQLCODE,

Line 837: x_return_status := OKL_API.G_RET_STS_SUCCESS;

833: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_principal_paid');
834: END IF;
835:
836: l_principal_paid := 0;
837: x_return_status := OKL_API.G_RET_STS_SUCCESS;
838: IF ( p_khr_id IS NULL ) THEN
839: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
840: END IF;
841: -- Begin bug 6456733

Line 839: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

835:
836: l_principal_paid := 0;
837: x_return_status := OKL_API.G_RET_STS_SUCCESS;
838: IF ( p_khr_id IS NULL ) THEN
839: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
840: END IF;
841: -- Begin bug 6456733
842: --OPEN l_principal_paid_csr(p_khr_id, p_kle_id, p_from_date, p_to_date);
843: OPEN l_principal_paid_csr(p_khr_id, p_from_date, p_to_date);

Line 853: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

849: END IF;
850:
851: RETURN l_principal_paid;
852: EXCEPTION
853: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
854: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
855: RETURN l_principal_paid;
856: WHEN OTHERS THEN
857: IF l_principal_paid_csr%ISOPEN THEN

Line 854: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

850:
851: RETURN l_principal_paid;
852: EXCEPTION
853: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
854: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
855: RETURN l_principal_paid;
856: WHEN OTHERS THEN
857: IF l_principal_paid_csr%ISOPEN THEN
858: CLOSE l_principal_paid_csr;

Line 860: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

856: WHEN OTHERS THEN
857: IF l_principal_paid_csr%ISOPEN THEN
858: CLOSE l_principal_paid_csr;
859: END IF;
860: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
861: OKL_API.SET_MESSAGE(
862: p_app_name => G_APP_NAME,
863: p_msg_name => G_UNEXPECTED_ERROR,
864: p_token1 => G_SQLCODE_TOKEN,

Line 861: OKL_API.SET_MESSAGE(

857: IF l_principal_paid_csr%ISOPEN THEN
858: CLOSE l_principal_paid_csr;
859: END IF;
860: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
861: OKL_API.SET_MESSAGE(
862: p_app_name => G_APP_NAME,
863: p_msg_name => G_UNEXPECTED_ERROR,
864: p_token1 => G_SQLCODE_TOKEN,
865: p_token1_value => SQLCODE,

Line 912: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

908: END IF;
909:
910: l_interest_rate_change_flag := 'N';
911: IF ( p_khr_id IS NULL ) THEN
912: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
913: END IF;
914:
915: OPEN l_var_int_params_csr(p_khr_id);
916: FETCH l_var_int_params_csr INTO l_var_int_params_rec;

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

919: x_return_status => x_return_status,
920: p_khr_id => p_khr_id,
921: p_effective_date => l_var_int_params_rec.interest_calc_end_date + 1);
922:
923: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
924: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
925: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
926: RAISE OKL_API.G_EXCEPTION_ERROR;
927: END IF;

Line 924: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

920: p_khr_id => p_khr_id,
921: p_effective_date => l_var_int_params_rec.interest_calc_end_date + 1);
922:
923: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
924: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
925: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
926: RAISE OKL_API.G_EXCEPTION_ERROR;
927: END IF;
928: IF l_effective_int_rate <> l_var_int_params_rec.interest_rate THEN

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

921: p_effective_date => l_var_int_params_rec.interest_calc_end_date + 1);
922:
923: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
924: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
925: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
926: RAISE OKL_API.G_EXCEPTION_ERROR;
927: END IF;
928: IF l_effective_int_rate <> l_var_int_params_rec.interest_rate THEN
929: l_interest_rate_change_flag := 'Y';

Line 926: RAISE OKL_API.G_EXCEPTION_ERROR;

922:
923: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
924: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
925: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
926: RAISE OKL_API.G_EXCEPTION_ERROR;
927: END IF;
928: IF l_effective_int_rate <> l_var_int_params_rec.interest_rate THEN
929: l_interest_rate_change_flag := 'Y';
930: END IF;

Line 938: WHEN OKL_API.G_EXCEPTION_ERROR THEN

934: END IF;
935:
936: RETURN l_interest_rate_change_flag;
937: EXCEPTION
938: WHEN OKL_API.G_EXCEPTION_ERROR THEN
939: x_return_status := OKL_API.G_RET_STS_ERROR;
940: RETURN l_interest_rate_change_flag;
941: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
942: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 939: x_return_status := OKL_API.G_RET_STS_ERROR;

935:
936: RETURN l_interest_rate_change_flag;
937: EXCEPTION
938: WHEN OKL_API.G_EXCEPTION_ERROR THEN
939: x_return_status := OKL_API.G_RET_STS_ERROR;
940: RETURN l_interest_rate_change_flag;
941: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
942: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
943: RETURN l_interest_rate_change_flag;

Line 941: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

937: EXCEPTION
938: WHEN OKL_API.G_EXCEPTION_ERROR THEN
939: x_return_status := OKL_API.G_RET_STS_ERROR;
940: RETURN l_interest_rate_change_flag;
941: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
942: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
943: RETURN l_interest_rate_change_flag;
944: WHEN OTHERS THEN
945: IF l_var_int_params_csr%ISOPEN THEN

Line 942: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

938: WHEN OKL_API.G_EXCEPTION_ERROR THEN
939: x_return_status := OKL_API.G_RET_STS_ERROR;
940: RETURN l_interest_rate_change_flag;
941: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
942: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
943: RETURN l_interest_rate_change_flag;
944: WHEN OTHERS THEN
945: IF l_var_int_params_csr%ISOPEN THEN
946: CLOSE l_var_int_params_csr;

Line 948: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

944: WHEN OTHERS THEN
945: IF l_var_int_params_csr%ISOPEN THEN
946: CLOSE l_var_int_params_csr;
947: END IF;
948: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
949: OKL_API.SET_MESSAGE(
950: p_app_name => G_APP_NAME,
951: p_msg_name => G_UNEXPECTED_ERROR,
952: p_token1 => G_SQLCODE_TOKEN,

Line 949: OKL_API.SET_MESSAGE(

945: IF l_var_int_params_csr%ISOPEN THEN
946: CLOSE l_var_int_params_csr;
947: END IF;
948: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
949: OKL_API.SET_MESSAGE(
950: p_app_name => G_APP_NAME,
951: p_msg_name => G_UNEXPECTED_ERROR,
952: p_token1 => G_SQLCODE_TOKEN,
953: p_token1_value => SQLCODE,

Line 1006: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1002: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_effective_int_rate');
1003: END IF;
1004:
1005: l_effective_int_rate := 0;
1006: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1007: IF ( p_khr_id IS NULL ) THEN
1008: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1009: END IF;
1010:

Line 1008: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1004:
1005: l_effective_int_rate := 0;
1006: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1007: IF ( p_khr_id IS NULL ) THEN
1008: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1009: END IF;
1010:
1011: OPEN l_calc_basis_csr(p_khr_id);
1012: FETCH l_calc_basis_csr INTO l_process_flag, l_end_date;

Line 1022: p_init_msg_list => OKL_API.G_FALSE,

1018: END IF;
1019:
1020: OKL_VARIABLE_INTEREST_PVT.interest_date_range (
1021: p_api_version => l_api_version,
1022: p_init_msg_list => OKL_API.G_FALSE,
1023: x_return_status => x_return_status,
1024: x_msg_count => x_msg_count,
1025: x_msg_data => x_msg_data,
1026: p_contract_id => p_khr_id,

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

1028: p_end_date => l_effective_date,
1029: p_process_flag => l_process_flag,
1030: x_interest_rate_tbl => l_interest_rate_tbl);
1031:
1032: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1033: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1034: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
1035: RAISE OKL_API.G_EXCEPTION_ERROR;
1036: END IF;

Line 1033: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1029: p_process_flag => l_process_flag,
1030: x_interest_rate_tbl => l_interest_rate_tbl);
1031:
1032: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1033: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1034: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
1035: RAISE OKL_API.G_EXCEPTION_ERROR;
1036: END IF;
1037:

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

1030: x_interest_rate_tbl => l_interest_rate_tbl);
1031:
1032: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1033: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1034: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
1035: RAISE OKL_API.G_EXCEPTION_ERROR;
1036: END IF;
1037:
1038: IF l_interest_rate_tbl.COUNT > 0 THEN

Line 1035: RAISE OKL_API.G_EXCEPTION_ERROR;

1031:
1032: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1033: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1034: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
1035: RAISE OKL_API.G_EXCEPTION_ERROR;
1036: END IF;
1037:
1038: IF l_interest_rate_tbl.COUNT > 0 THEN
1039: l_effective_int_rate := l_interest_rate_tbl(l_interest_rate_tbl.COUNT).rate;

Line 1048: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1044: END IF;
1045:
1046: RETURN l_effective_int_rate;
1047: EXCEPTION
1048: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1049: x_return_status := OKL_API.G_RET_STS_ERROR;
1050: RETURN l_effective_int_rate;
1051: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1052: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1049: x_return_status := OKL_API.G_RET_STS_ERROR;

1045:
1046: RETURN l_effective_int_rate;
1047: EXCEPTION
1048: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1049: x_return_status := OKL_API.G_RET_STS_ERROR;
1050: RETURN l_effective_int_rate;
1051: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1052: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1053: RETURN l_effective_int_rate;

Line 1051: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1047: EXCEPTION
1048: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1049: x_return_status := OKL_API.G_RET_STS_ERROR;
1050: RETURN l_effective_int_rate;
1051: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1052: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1053: RETURN l_effective_int_rate;
1054: WHEN OTHERS THEN
1055: IF l_calc_basis_csr%ISOPEN THEN

Line 1052: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1048: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1049: x_return_status := OKL_API.G_RET_STS_ERROR;
1050: RETURN l_effective_int_rate;
1051: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1052: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1053: RETURN l_effective_int_rate;
1054: WHEN OTHERS THEN
1055: IF l_calc_basis_csr%ISOPEN THEN
1056: CLOSE l_calc_basis_csr;

Line 1058: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1054: WHEN OTHERS THEN
1055: IF l_calc_basis_csr%ISOPEN THEN
1056: CLOSE l_calc_basis_csr;
1057: END IF;
1058: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1059: OKL_API.SET_MESSAGE(
1060: p_app_name => G_APP_NAME,
1061: p_msg_name => G_UNEXPECTED_ERROR,
1062: p_token1 => G_SQLCODE_TOKEN,

Line 1059: OKL_API.SET_MESSAGE(

1055: IF l_calc_basis_csr%ISOPEN THEN
1056: CLOSE l_calc_basis_csr;
1057: END IF;
1058: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1059: OKL_API.SET_MESSAGE(
1060: p_app_name => G_APP_NAME,
1061: p_msg_name => G_UNEXPECTED_ERROR,
1062: p_token1 => G_SQLCODE_TOKEN,
1063: p_token1_value => SQLCODE,

Line 1113: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1109:
1110: l_interest_billed := 0;
1111: l_interest_due := 0;
1112: l_interest_due_unbilled := 0;
1113: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1114: IF ( p_khr_id IS NULL ) THEN
1115: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1116: END IF;
1117:

Line 1115: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1111: l_interest_due := 0;
1112: l_interest_due_unbilled := 0;
1113: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1114: IF ( p_khr_id IS NULL ) THEN
1115: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1116: END IF;
1117:
1118: OPEN l_start_date_csr(p_khr_id);
1119: FETCH l_start_date_csr INTO l_start_date;

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

1121: l_interest_due := get_interest_due(
1122: x_return_status => x_return_status,
1123: p_khr_id => p_khr_id,
1124: p_to_date => p_effective_date);
1125: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1127: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1128: RAISE OKL_API.G_EXCEPTION_ERROR;
1129: END IF;

Line 1126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1122: x_return_status => x_return_status,
1123: p_khr_id => p_khr_id,
1124: p_to_date => p_effective_date);
1125: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1127: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1128: RAISE OKL_API.G_EXCEPTION_ERROR;
1129: END IF;
1130: l_interest_billed := get_interest_billed(

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

1123: p_khr_id => p_khr_id,
1124: p_to_date => p_effective_date);
1125: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1127: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1128: RAISE OKL_API.G_EXCEPTION_ERROR;
1129: END IF;
1130: l_interest_billed := get_interest_billed(
1131: x_return_status => x_return_status,

Line 1128: RAISE OKL_API.G_EXCEPTION_ERROR;

1124: p_to_date => p_effective_date);
1125: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1126: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1127: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1128: RAISE OKL_API.G_EXCEPTION_ERROR;
1129: END IF;
1130: l_interest_billed := get_interest_billed(
1131: x_return_status => x_return_status,
1132: p_khr_id => p_khr_id,

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

1131: x_return_status => x_return_status,
1132: p_khr_id => p_khr_id,
1133: p_from_date => l_start_date,
1134: p_to_date => p_effective_date);
1135: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1136: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1137: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1138: RAISE OKL_API.G_EXCEPTION_ERROR;
1139: END IF;

Line 1136: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1132: p_khr_id => p_khr_id,
1133: p_from_date => l_start_date,
1134: p_to_date => p_effective_date);
1135: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1136: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1137: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1138: RAISE OKL_API.G_EXCEPTION_ERROR;
1139: END IF;
1140: l_interest_due_unbilled := l_interest_due - l_interest_billed;

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

1133: p_from_date => l_start_date,
1134: p_to_date => p_effective_date);
1135: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1136: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1137: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1138: RAISE OKL_API.G_EXCEPTION_ERROR;
1139: END IF;
1140: l_interest_due_unbilled := l_interest_due - l_interest_billed;
1141:

Line 1138: RAISE OKL_API.G_EXCEPTION_ERROR;

1134: p_to_date => p_effective_date);
1135: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1136: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1137: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1138: RAISE OKL_API.G_EXCEPTION_ERROR;
1139: END IF;
1140: l_interest_due_unbilled := l_interest_due - l_interest_billed;
1141:
1142: IF(NVL(l_debug_enabled,'N')='Y') THEN

Line 1148: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1144: END IF;
1145:
1146: RETURN l_interest_due_unbilled;
1147: EXCEPTION
1148: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1149: x_return_status := OKL_API.G_RET_STS_ERROR;
1150: RETURN l_interest_due_unbilled;
1151: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1152: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1149: x_return_status := OKL_API.G_RET_STS_ERROR;

1145:
1146: RETURN l_interest_due_unbilled;
1147: EXCEPTION
1148: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1149: x_return_status := OKL_API.G_RET_STS_ERROR;
1150: RETURN l_interest_due_unbilled;
1151: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1152: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1153: RETURN l_interest_due_unbilled;

Line 1151: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1147: EXCEPTION
1148: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1149: x_return_status := OKL_API.G_RET_STS_ERROR;
1150: RETURN l_interest_due_unbilled;
1151: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1152: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1153: RETURN l_interest_due_unbilled;
1154: WHEN OTHERS THEN
1155: IF l_start_date_csr%ISOPEN THEN

Line 1152: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1148: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1149: x_return_status := OKL_API.G_RET_STS_ERROR;
1150: RETURN l_interest_due_unbilled;
1151: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1152: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1153: RETURN l_interest_due_unbilled;
1154: WHEN OTHERS THEN
1155: IF l_start_date_csr%ISOPEN THEN
1156: CLOSE l_start_date_csr;

Line 1158: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1154: WHEN OTHERS THEN
1155: IF l_start_date_csr%ISOPEN THEN
1156: CLOSE l_start_date_csr;
1157: END IF;
1158: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1159: OKL_API.SET_MESSAGE(
1160: p_app_name => G_APP_NAME,
1161: p_msg_name => G_UNEXPECTED_ERROR,
1162: p_token1 => G_SQLCODE_TOKEN,

Line 1159: OKL_API.SET_MESSAGE(

1155: IF l_start_date_csr%ISOPEN THEN
1156: CLOSE l_start_date_csr;
1157: END IF;
1158: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1159: OKL_API.SET_MESSAGE(
1160: p_app_name => G_APP_NAME,
1161: p_msg_name => G_UNEXPECTED_ERROR,
1162: p_token1 => G_SQLCODE_TOKEN,
1163: p_token1_value => SQLCODE,

Line 1252: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1248: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_principal_billed');
1249: END IF;
1250:
1251: l_principal_billed := 0;
1252: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1253: IF ( p_khr_id IS NULL ) THEN
1254: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1255: END IF;
1256:

Line 1254: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1250:
1251: l_principal_billed := 0;
1252: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1253: IF ( p_khr_id IS NULL ) THEN
1254: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1255: END IF;
1256:
1257: -- Begin bug 6456733
1258: --OPEN l_principal_billed_csr(p_khr_id, p_kle_id, p_from_date, p_to_date);

Line 1270: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1266: END IF;
1267:
1268: RETURN l_principal_billed;
1269: EXCEPTION
1270: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1271: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1272: RETURN l_principal_billed;
1273: WHEN OTHERS THEN
1274: IF l_principal_billed_csr%ISOPEN THEN

Line 1271: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1267:
1268: RETURN l_principal_billed;
1269: EXCEPTION
1270: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1271: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1272: RETURN l_principal_billed;
1273: WHEN OTHERS THEN
1274: IF l_principal_billed_csr%ISOPEN THEN
1275: CLOSE l_principal_billed_csr;

Line 1277: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1273: WHEN OTHERS THEN
1274: IF l_principal_billed_csr%ISOPEN THEN
1275: CLOSE l_principal_billed_csr;
1276: END IF;
1277: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1278: OKL_API.SET_MESSAGE(
1279: p_app_name => G_APP_NAME,
1280: p_msg_name => G_UNEXPECTED_ERROR,
1281: p_token1 => G_SQLCODE_TOKEN,

Line 1278: OKL_API.SET_MESSAGE(

1274: IF l_principal_billed_csr%ISOPEN THEN
1275: CLOSE l_principal_billed_csr;
1276: END IF;
1277: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1278: OKL_API.SET_MESSAGE(
1279: p_app_name => G_APP_NAME,
1280: p_msg_name => G_UNEXPECTED_ERROR,
1281: p_token1 => G_SQLCODE_TOKEN,
1282: p_token1_value => SQLCODE,

Line 1356: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1352: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_float_factor_billed');
1353: END IF;
1354:
1355: l_float_factor_billed := 0;
1356: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1357: IF ( p_khr_id IS NULL ) THEN
1358: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1359: END IF;
1360:

Line 1358: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1354:
1355: l_float_factor_billed := 0;
1356: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1357: IF ( p_khr_id IS NULL ) THEN
1358: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1359: END IF;
1360:
1361: OPEN l_float_billed_csr(p_khr_id, p_effective_date);
1362: FETCH l_float_billed_csr INTO l_float_factor_billed;

Line 1371: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1367: END IF;
1368:
1369: RETURN l_float_factor_billed;
1370: EXCEPTION
1371: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1372: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1373: RETURN l_float_factor_billed;
1374: WHEN OTHERS THEN
1375: IF l_float_billed_csr%ISOPEN THEN

Line 1372: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1368:
1369: RETURN l_float_factor_billed;
1370: EXCEPTION
1371: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1372: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1373: RETURN l_float_factor_billed;
1374: WHEN OTHERS THEN
1375: IF l_float_billed_csr%ISOPEN THEN
1376: CLOSE l_float_billed_csr;

Line 1378: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1374: WHEN OTHERS THEN
1375: IF l_float_billed_csr%ISOPEN THEN
1376: CLOSE l_float_billed_csr;
1377: END IF;
1378: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1379: OKL_API.SET_MESSAGE(
1380: p_app_name => G_APP_NAME,
1381: p_msg_name => G_UNEXPECTED_ERROR,
1382: p_token1 => G_SQLCODE_TOKEN,

Line 1379: OKL_API.SET_MESSAGE(

1375: IF l_float_billed_csr%ISOPEN THEN
1376: CLOSE l_float_billed_csr;
1377: END IF;
1378: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1379: OKL_API.SET_MESSAGE(
1380: p_app_name => G_APP_NAME,
1381: p_msg_name => G_UNEXPECTED_ERROR,
1382: p_token1 => G_SQLCODE_TOKEN,
1383: p_token1_value => SQLCODE,

Line 1458: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1454: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_loan_payment_billed');
1455: END IF;
1456:
1457: l_loan_payment_billed := 0;
1458: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1459: IF ( p_khr_id IS NULL ) THEN
1460: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1461: END IF;
1462:

Line 1460: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1456:
1457: l_loan_payment_billed := 0;
1458: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1459: IF ( p_khr_id IS NULL ) THEN
1460: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1461: END IF;
1462:
1463: OPEN l_loan_payment_billed_csr(p_khr_id, p_effective_date);
1464: FETCH l_loan_payment_billed_csr INTO l_loan_payment_billed;

Line 1473: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1469: END IF;
1470:
1471: RETURN l_loan_payment_billed;
1472: EXCEPTION
1473: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1474: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1475: RETURN l_loan_payment_billed;
1476: WHEN OTHERS THEN
1477: IF l_loan_payment_billed_csr%ISOPEN THEN

Line 1474: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1470:
1471: RETURN l_loan_payment_billed;
1472: EXCEPTION
1473: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1474: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1475: RETURN l_loan_payment_billed;
1476: WHEN OTHERS THEN
1477: IF l_loan_payment_billed_csr%ISOPEN THEN
1478: CLOSE l_loan_payment_billed_csr;

Line 1480: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1476: WHEN OTHERS THEN
1477: IF l_loan_payment_billed_csr%ISOPEN THEN
1478: CLOSE l_loan_payment_billed_csr;
1479: END IF;
1480: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1481: OKL_API.SET_MESSAGE(
1482: p_app_name => G_APP_NAME,
1483: p_msg_name => G_UNEXPECTED_ERROR,
1484: p_token1 => G_SQLCODE_TOKEN,

Line 1481: OKL_API.SET_MESSAGE(

1477: IF l_loan_payment_billed_csr%ISOPEN THEN
1478: CLOSE l_loan_payment_billed_csr;
1479: END IF;
1480: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1481: OKL_API.SET_MESSAGE(
1482: p_app_name => G_APP_NAME,
1483: p_msg_name => G_UNEXPECTED_ERROR,
1484: p_token1 => G_SQLCODE_TOKEN,
1485: p_token1_value => SQLCODE,

Line 1567: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1563: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_loan_payment_paid');
1564: END IF;
1565:
1566: l_loan_payment_paid := 0;
1567: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1568: IF ( p_khr_id IS NULL ) THEN
1569: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1570: END IF;
1571:

Line 1569: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1565:
1566: l_loan_payment_paid := 0;
1567: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1568: IF ( p_khr_id IS NULL ) THEN
1569: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1570: END IF;
1571:
1572: OPEN l_laon_payment_csr(p_khr_id, p_effective_date);
1573: FETCH l_laon_payment_csr INTO l_loan_payment_paid;

Line 1582: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1578: END IF;
1579:
1580: RETURN l_loan_payment_paid;
1581: EXCEPTION
1582: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1583: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1584: RETURN l_loan_payment_paid;
1585: WHEN OTHERS THEN
1586: IF l_laon_payment_csr%ISOPEN THEN

Line 1583: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1579:
1580: RETURN l_loan_payment_paid;
1581: EXCEPTION
1582: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1583: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1584: RETURN l_loan_payment_paid;
1585: WHEN OTHERS THEN
1586: IF l_laon_payment_csr%ISOPEN THEN
1587: CLOSE l_laon_payment_csr;

Line 1589: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1585: WHEN OTHERS THEN
1586: IF l_laon_payment_csr%ISOPEN THEN
1587: CLOSE l_laon_payment_csr;
1588: END IF;
1589: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1590: OKL_API.SET_MESSAGE(
1591: p_app_name => G_APP_NAME,
1592: p_msg_name => G_UNEXPECTED_ERROR,
1593: p_token1 => G_SQLCODE_TOKEN,

Line 1590: OKL_API.SET_MESSAGE(

1586: IF l_laon_payment_csr%ISOPEN THEN
1587: CLOSE l_laon_payment_csr;
1588: END IF;
1589: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1590: OKL_API.SET_MESSAGE(
1591: p_app_name => G_APP_NAME,
1592: p_msg_name => G_UNEXPECTED_ERROR,
1593: p_token1 => G_SQLCODE_TOKEN,
1594: p_token1_value => SQLCODE,

Line 1642: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1638: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_excess_loan_payment');
1639: END IF;
1640:
1641: l_excess_loan_payment := 0;
1642: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1643: IF ( p_khr_id IS NULL ) THEN
1644: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1645: END IF;
1646:

Line 1644: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1640:
1641: l_excess_loan_payment := 0;
1642: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1643: IF ( p_khr_id IS NULL ) THEN
1644: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1645: END IF;
1646:
1647: OPEN l_laon_payment_csr(p_khr_id);
1648: FETCH l_laon_payment_csr INTO l_excess_loan_payment;

Line 1657: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1653: END IF;
1654:
1655: RETURN l_excess_loan_payment;
1656: EXCEPTION
1657: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1658: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1659: RETURN l_excess_loan_payment;
1660: WHEN OTHERS THEN
1661: IF l_laon_payment_csr%ISOPEN THEN

Line 1658: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1654:
1655: RETURN l_excess_loan_payment;
1656: EXCEPTION
1657: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1658: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1659: RETURN l_excess_loan_payment;
1660: WHEN OTHERS THEN
1661: IF l_laon_payment_csr%ISOPEN THEN
1662: CLOSE l_laon_payment_csr;

Line 1664: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1660: WHEN OTHERS THEN
1661: IF l_laon_payment_csr%ISOPEN THEN
1662: CLOSE l_laon_payment_csr;
1663: END IF;
1664: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1665: OKL_API.SET_MESSAGE(
1666: p_app_name => G_APP_NAME,
1667: p_msg_name => G_UNEXPECTED_ERROR,
1668: p_token1 => G_SQLCODE_TOKEN,

Line 1665: OKL_API.SET_MESSAGE(

1661: IF l_laon_payment_csr%ISOPEN THEN
1662: CLOSE l_laon_payment_csr;
1663: END IF;
1664: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1665: OKL_API.SET_MESSAGE(
1666: p_app_name => G_APP_NAME,
1667: p_msg_name => G_UNEXPECTED_ERROR,
1668: p_token1 => G_SQLCODE_TOKEN,
1669: p_token1_value => SQLCODE,

Line 1709: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1705: IF(NVL(l_debug_enabled,'N')='Y') THEN
1706: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_last_interim_int_calc_date');
1707: END IF;
1708:
1709: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1710: IF ( p_khr_id IS NULL ) THEN
1711: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1712: END IF;
1713:

Line 1711: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1707: END IF;
1708:
1709: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1710: IF ( p_khr_id IS NULL ) THEN
1711: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1712: END IF;
1713:
1714: OPEN l_interest_calc_date_csr(p_khr_id);
1715: FETCH l_interest_calc_date_csr INTO l_last_interest_date;

Line 1722: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1718: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_last_interim_int_calc_date');
1719: END IF;
1720: RETURN l_last_interest_date;
1721: EXCEPTION
1722: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1723: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1724: RETURN l_last_interest_date;
1725: WHEN OTHERS THEN
1726: IF l_interest_calc_date_csr%ISOPEN THEN

Line 1723: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1719: END IF;
1720: RETURN l_last_interest_date;
1721: EXCEPTION
1722: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1723: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1724: RETURN l_last_interest_date;
1725: WHEN OTHERS THEN
1726: IF l_interest_calc_date_csr%ISOPEN THEN
1727: CLOSE l_interest_calc_date_csr;

Line 1729: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1725: WHEN OTHERS THEN
1726: IF l_interest_calc_date_csr%ISOPEN THEN
1727: CLOSE l_interest_calc_date_csr;
1728: END IF;
1729: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1730: OKL_API.SET_MESSAGE(
1731: p_app_name => G_APP_NAME,
1732: p_msg_name => G_UNEXPECTED_ERROR,
1733: p_token1 => G_SQLCODE_TOKEN,

Line 1730: OKL_API.SET_MESSAGE(

1726: IF l_interest_calc_date_csr%ISOPEN THEN
1727: CLOSE l_interest_calc_date_csr;
1728: END IF;
1729: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1730: OKL_API.SET_MESSAGE(
1731: p_app_name => G_APP_NAME,
1732: p_msg_name => G_UNEXPECTED_ERROR,
1733: p_token1 => G_SQLCODE_TOKEN,
1734: p_token1_value => SQLCODE,

Line 1864: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1860: l_debug_enabled := okl_debug_pub.check_log_enabled;
1861: IF(NVL(l_debug_enabled,'N')='Y') THEN
1862: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_last_sch_int_calc_date');
1863: END IF;
1864: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1865: IF ( p_khr_id IS NULL ) THEN
1866: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1867: END IF;
1868:

Line 1866: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1862: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_last_sch_int_calc_date');
1863: END IF;
1864: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1865: IF ( p_khr_id IS NULL ) THEN
1866: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1867: END IF;
1868:
1869: OPEN l_pdt_csr(p_khr_id);
1870: FETCH l_pdt_csr INTO l_pdtv_rec.id;

Line 1875: p_init_msg_list => OKL_API.G_FALSE,

1871: CLOSE l_pdt_csr;
1872:
1873: OKL_SETUPPRODUCTS_PVT.getpdt_parameters(
1874: p_api_version => l_api_version,
1875: p_init_msg_list => OKL_API.G_FALSE,
1876: x_return_status => x_return_status,
1877: x_no_data_found => x_no_data_found,
1878: x_msg_count => x_msg_count,
1879: x_msg_data => x_msg_data,

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

1878: x_msg_count => x_msg_count,
1879: x_msg_data => x_msg_data,
1880: p_pdtv_rec => l_pdtv_rec,
1881: p_pdt_parameter_rec => x_pdt_parameter_rec );
1882: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1883: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1884: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1885: RAISE OKL_API.G_EXCEPTION_ERROR;
1886: END IF;

Line 1883: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1879: x_msg_data => x_msg_data,
1880: p_pdtv_rec => l_pdtv_rec,
1881: p_pdt_parameter_rec => x_pdt_parameter_rec );
1882: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1883: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1884: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1885: RAISE OKL_API.G_EXCEPTION_ERROR;
1886: END IF;
1887:

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

1880: p_pdtv_rec => l_pdtv_rec,
1881: p_pdt_parameter_rec => x_pdt_parameter_rec );
1882: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1883: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1884: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1885: RAISE OKL_API.G_EXCEPTION_ERROR;
1886: END IF;
1887:
1888: --Bug# 14049528

Line 1885: RAISE OKL_API.G_EXCEPTION_ERROR;

1881: p_pdt_parameter_rec => x_pdt_parameter_rec );
1882: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1883: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1884: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1885: RAISE OKL_API.G_EXCEPTION_ERROR;
1886: END IF;
1887:
1888: --Bug# 14049528
1889: OPEN l_date_csr(p_khr_id);

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

1949: p_khr_id => p_khr_id,
1950: x_arrears_pay_dates_option => l_arrears_pay_dates_option,
1951: x_return_status => x_return_status);
1952:
1953: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1954: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1955: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1956: RAISE OKL_API.G_EXCEPTION_ERROR;
1957: END IF;

Line 1954: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1950: x_arrears_pay_dates_option => l_arrears_pay_dates_option,
1951: x_return_status => x_return_status);
1952:
1953: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1954: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1955: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1956: RAISE OKL_API.G_EXCEPTION_ERROR;
1957: END IF;
1958: END IF;

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

1951: x_return_status => x_return_status);
1952:
1953: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1954: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1955: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1956: RAISE OKL_API.G_EXCEPTION_ERROR;
1957: END IF;
1958: END IF;
1959: --Bug# 14049528

Line 1956: RAISE OKL_API.G_EXCEPTION_ERROR;

1952:
1953: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1954: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1955: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1956: RAISE OKL_API.G_EXCEPTION_ERROR;
1957: END IF;
1958: END IF;
1959: --Bug# 14049528
1960:

Line 1968: p_init_msg_list => OKL_API.G_FALSE,

1964:
1965: LOOP
1966: OKL_STREAM_GENERATOR_PVT.get_next_billing_date(
1967: p_api_version => l_api_version,
1968: p_init_msg_list => OKL_API.G_FALSE,
1969: p_khr_id => p_khr_id,
1970: p_billing_date => l_start_date,
1971: x_next_due_date => l_due_date,
1972: x_next_period_start_date => l_next_period_start_date,

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

1973: x_next_period_end_date => l_next_period_end_date,
1974: x_return_status => x_return_status,
1975: x_msg_count => x_msg_count,
1976: x_msg_data => x_msg_data);
1977: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1978: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1979: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
1980: RAISE OKL_API.G_EXCEPTION_ERROR;
1981: END IF;

Line 1978: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1974: x_return_status => x_return_status,
1975: x_msg_count => x_msg_count,
1976: x_msg_data => x_msg_data);
1977: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1978: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1979: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
1980: RAISE OKL_API.G_EXCEPTION_ERROR;
1981: END IF;
1982:

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

1975: x_msg_count => x_msg_count,
1976: x_msg_data => x_msg_data);
1977: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1978: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1979: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
1980: RAISE OKL_API.G_EXCEPTION_ERROR;
1981: END IF;
1982:
1983: --Bug# 14049528

Line 1980: RAISE OKL_API.G_EXCEPTION_ERROR;

1976: x_msg_data => x_msg_data);
1977: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1978: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1979: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR)THEN
1980: RAISE OKL_API.G_EXCEPTION_ERROR;
1981: END IF;
1982:
1983: --Bug# 14049528
1984: l_interest_calc_date := l_due_date;

Line 2058: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2054:
2055: RETURN l_last_interest_date;
2056:
2057: EXCEPTION
2058: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2059: x_return_status := OKL_API.G_RET_STS_ERROR;
2060: RETURN l_last_interest_date;
2061: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2062: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2059: x_return_status := OKL_API.G_RET_STS_ERROR;

2055: RETURN l_last_interest_date;
2056:
2057: EXCEPTION
2058: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2059: x_return_status := OKL_API.G_RET_STS_ERROR;
2060: RETURN l_last_interest_date;
2061: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2062: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2063: RETURN l_last_interest_date;

Line 2061: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2057: EXCEPTION
2058: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2059: x_return_status := OKL_API.G_RET_STS_ERROR;
2060: RETURN l_last_interest_date;
2061: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2062: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2063: RETURN l_last_interest_date;
2064: WHEN OTHERS THEN
2065: IF l_pdt_csr%ISOPEN THEN

Line 2062: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2058: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2059: x_return_status := OKL_API.G_RET_STS_ERROR;
2060: RETURN l_last_interest_date;
2061: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2062: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2063: RETURN l_last_interest_date;
2064: WHEN OTHERS THEN
2065: IF l_pdt_csr%ISOPEN THEN
2066: CLOSE l_pdt_csr;

Line 2080: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2076: END IF;
2077: IF l_catchup_csr%ISOPEN THEN
2078: CLOSE l_catchup_csr;
2079: END IF;
2080: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2081: OKL_API.SET_MESSAGE(
2082: p_app_name => G_APP_NAME,
2083: p_msg_name => G_UNEXPECTED_ERROR,
2084: p_token1 => G_SQLCODE_TOKEN,

Line 2081: OKL_API.SET_MESSAGE(

2077: IF l_catchup_csr%ISOPEN THEN
2078: CLOSE l_catchup_csr;
2079: END IF;
2080: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2081: OKL_API.SET_MESSAGE(
2082: p_app_name => G_APP_NAME,
2083: p_msg_name => G_UNEXPECTED_ERROR,
2084: p_token1 => G_SQLCODE_TOKEN,
2085: p_token1_value => SQLCODE,

Line 2164: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2160: l_debug_enabled := okl_debug_pub.check_log_enabled;
2161: IF(NVL(l_debug_enabled,'N')='Y') THEN
2162: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_open_invoices');
2163: END IF;
2164: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2165: IF ( p_khr_id IS NULL ) THEN
2166: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2167: END IF;
2168:

Line 2166: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2162: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRVIUB.pls call get_open_invoices');
2163: END IF;
2164: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2165: IF ( p_khr_id IS NULL ) THEN
2166: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2167: END IF;
2168:
2169: OPEN l_invoice_info_csr(p_khr_id);
2170: FETCH l_invoice_info_csr BULK COLLECT INTO x_invoice_tbl;

Line 2177: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2173: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRVIUB.pls call get_open_invoices');
2174: END IF;
2175:
2176: EXCEPTION
2177: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2178: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2179: WHEN OTHERS THEN
2180: IF l_invoice_info_csr%ISOPEN THEN
2181: CLOSE l_invoice_info_csr;

Line 2178: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2174: END IF;
2175:
2176: EXCEPTION
2177: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2178: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2179: WHEN OTHERS THEN
2180: IF l_invoice_info_csr%ISOPEN THEN
2181: CLOSE l_invoice_info_csr;
2182: END IF;

Line 2183: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2179: WHEN OTHERS THEN
2180: IF l_invoice_info_csr%ISOPEN THEN
2181: CLOSE l_invoice_info_csr;
2182: END IF;
2183: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2184: OKL_API.SET_MESSAGE(
2185: p_app_name => G_APP_NAME,
2186: p_msg_name => G_UNEXPECTED_ERROR,
2187: p_token1 => G_SQLCODE_TOKEN,

Line 2184: OKL_API.SET_MESSAGE(

2180: IF l_invoice_info_csr%ISOPEN THEN
2181: CLOSE l_invoice_info_csr;
2182: END IF;
2183: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2184: OKL_API.SET_MESSAGE(
2185: p_app_name => G_APP_NAME,
2186: p_msg_name => G_UNEXPECTED_ERROR,
2187: p_token1 => G_SQLCODE_TOKEN,
2188: p_token1_value => SQLCODE,

Line 2257: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2253: AND str.sty_id = sty.id
2254: AND sty.stream_type_purpose = 'PRINCIPAL_BALANCE';
2255:
2256: BEGIN
2257: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2258: x_prin_stream_flag := 0;
2259:
2260: OPEN l_check_fee_csr(p_khr_id);
2261: FETCH l_check_fee_csr INTO l_fee_exists;

Line 2288: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2284: END LOOP;
2285: END IF;
2286:
2287: EXCEPTION
2288: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2289: x_return_status := OKL_API.G_RET_STS_ERROR;
2290: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2291: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2292: WHEN OTHERS THEN

Line 2289: x_return_status := OKL_API.G_RET_STS_ERROR;

2285: END IF;
2286:
2287: EXCEPTION
2288: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2289: x_return_status := OKL_API.G_RET_STS_ERROR;
2290: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2291: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2292: WHEN OTHERS THEN
2293: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2290: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2286:
2287: EXCEPTION
2288: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2289: x_return_status := OKL_API.G_RET_STS_ERROR;
2290: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2291: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2292: WHEN OTHERS THEN
2293: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2294: OKL_API.SET_MESSAGE(

Line 2291: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2287: EXCEPTION
2288: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2289: x_return_status := OKL_API.G_RET_STS_ERROR;
2290: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2291: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2292: WHEN OTHERS THEN
2293: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2294: OKL_API.SET_MESSAGE(
2295: p_app_name => G_APP_NAME,

Line 2293: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2289: x_return_status := OKL_API.G_RET_STS_ERROR;
2290: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2291: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2292: WHEN OTHERS THEN
2293: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2294: OKL_API.SET_MESSAGE(
2295: p_app_name => G_APP_NAME,
2296: p_msg_name => G_UNEXPECTED_ERROR,
2297: p_token1 => G_SQLCODE_TOKEN,

Line 2294: OKL_API.SET_MESSAGE(

2290: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2291: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2292: WHEN OTHERS THEN
2293: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2294: OKL_API.SET_MESSAGE(
2295: p_app_name => G_APP_NAME,
2296: p_msg_name => G_UNEXPECTED_ERROR,
2297: p_token1 => G_SQLCODE_TOKEN,
2298: p_token1_value => SQLCODE,

Line 2371: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2367: x_msg_data VARCHAR2(2000);
2368:
2369:
2370: BEGIN
2371: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2372:
2373: -- Check Transaction_Type
2374: OPEN Transaction_Type_csr(p_transaction_type);
2375: FETCH Transaction_Type_csr INTO l_Trx_Type_rec;

Line 2377: Okl_Api.SET_MESSAGE(G_APP_NAME, OKL_API.G_INVALID_VALUE, OKL_API.G_COL_NAME_TOKEN, p_transaction_type);

2373: -- Check Transaction_Type
2374: OPEN Transaction_Type_csr(p_transaction_type);
2375: FETCH Transaction_Type_csr INTO l_Trx_Type_rec;
2376: IF Transaction_Type_csr%NOTFOUND THEN
2377: Okl_Api.SET_MESSAGE(G_APP_NAME, OKL_API.G_INVALID_VALUE, OKL_API.G_COL_NAME_TOKEN, p_transaction_type);
2378: CLOSE Transaction_Type_csr;
2379: RAISE Okl_Api.G_EXCEPTION_ERROR;
2380: END IF;
2381: CLOSE Transaction_Type_csr;

Line 2379: RAISE Okl_Api.G_EXCEPTION_ERROR;

2375: FETCH Transaction_Type_csr INTO l_Trx_Type_rec;
2376: IF Transaction_Type_csr%NOTFOUND THEN
2377: Okl_Api.SET_MESSAGE(G_APP_NAME, OKL_API.G_INVALID_VALUE, OKL_API.G_COL_NAME_TOKEN, p_transaction_type);
2378: CLOSE Transaction_Type_csr;
2379: RAISE Okl_Api.G_EXCEPTION_ERROR;
2380: END IF;
2381: CLOSE Transaction_Type_csr;
2382:
2383: OPEN chr_csr(p_chr_id);

Line 2389: l_tmpl_identify_rec.memo_yn := OKL_API.G_MISS_CHAR;

2385: CLOSE chr_csr;
2386:
2387: l_tmpl_identify_rec.transaction_type_id := l_Trx_Type_rec.trx_try_id;
2388: l_tmpl_identify_rec.product_id := l_chr_rec.pdt_id;
2389: l_tmpl_identify_rec.memo_yn := OKL_API.G_MISS_CHAR;
2390:
2391: OKL_SECURITIZATION_PVT.Check_Khr_ia_associated(
2392: p_api_version => l_api_version,
2393: p_init_msg_list => OKL_API.G_FALSE,

Line 2393: p_init_msg_list => OKL_API.G_FALSE,

2389: l_tmpl_identify_rec.memo_yn := OKL_API.G_MISS_CHAR;
2390:
2391: OKL_SECURITIZATION_PVT.Check_Khr_ia_associated(
2392: p_api_version => l_api_version,
2393: p_init_msg_list => OKL_API.G_FALSE,
2394: x_return_status => x_return_status,
2395: x_msg_count => x_msg_count,
2396: x_msg_data => x_msg_data,
2397: p_khr_id => p_chr_id,

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

2400: x_fact_synd_code => l_fact_synd_code,
2401: x_inv_acct_code => l_inv_acct_code
2402: );
2403:
2404: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2405: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2406: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2407: RAISE OKL_API.G_EXCEPTION_ERROR;
2408: END IF;

Line 2405: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2401: x_inv_acct_code => l_inv_acct_code
2402: );
2403:
2404: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2405: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2406: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2407: RAISE OKL_API.G_EXCEPTION_ERROR;
2408: END IF;
2409:

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

2402: );
2403:
2404: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2405: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2406: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2407: RAISE OKL_API.G_EXCEPTION_ERROR;
2408: END IF;
2409:
2410: l_tmpl_identify_rec.factoring_synd_flag := l_fact_synd_code;

Line 2407: RAISE OKL_API.G_EXCEPTION_ERROR;

2403:
2404: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2405: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2406: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2407: RAISE OKL_API.G_EXCEPTION_ERROR;
2408: END IF;
2409:
2410: l_tmpl_identify_rec.factoring_synd_flag := l_fact_synd_code;
2411: l_tmpl_identify_rec.investor_code := l_inv_acct_code;

Line 2414: p_init_msg_list => OKL_API.G_FALSE,

2410: l_tmpl_identify_rec.factoring_synd_flag := l_fact_synd_code;
2411: l_tmpl_identify_rec.investor_code := l_inv_acct_code;
2412:
2413: OKL_ACCOUNT_DIST_PVT.GET_TEMPLATE_INFO(p_api_version => l_api_version,
2414: p_init_msg_list => OKL_API.G_FALSE,
2415: x_return_status => x_return_status,
2416: x_msg_count => x_msg_count,
2417: x_msg_data => x_msg_data,
2418: p_tmpl_identify_rec => l_tmpl_identify_rec,

Line 2422: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2418: p_tmpl_identify_rec => l_tmpl_identify_rec,
2419: x_template_tbl => l_template_tbl,
2420: p_validity_date => p_transaction_date);
2421:
2422: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2423: RAISE OKL_API.G_EXCEPTION_ERROR;
2424: END IF;
2425:
2426: -- Raise an error if template is not found.

Line 2423: RAISE OKL_API.G_EXCEPTION_ERROR;

2419: x_template_tbl => l_template_tbl,
2420: p_validity_date => p_transaction_date);
2421:
2422: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2423: RAISE OKL_API.G_EXCEPTION_ERROR;
2424: END IF;
2425:
2426: -- Raise an error if template is not found.
2427: IF (l_template_tbl.COUNT = 0) THEN

Line 2433: OKL_API.SET_MESSAGE(p_app_name => g_app_name

2429: OPEN trx_type_name_csr (l_Trx_Type_rec.trx_try_id);
2430: FETCH trx_type_name_csr INTO l_trx_type_name_rec;
2431: CLOSE trx_type_name_csr;
2432:
2433: OKL_API.SET_MESSAGE(p_app_name => g_app_name
2434: ,p_msg_name => 'OKL_TMPL_NOT_FOUND'
2435: ,p_token1 => 'PRODUCT'
2436: ,p_token1_value => l_chr_rec.pdt_name
2437: ,p_token2 => 'TRANSACTION_TYPE'

Line 2444: RAISE OKL_API.G_EXCEPTION_ERROR;

2440: ,p_token3_value => ' '
2441: ,p_token4 => 'ACCOUNTING_DATE'
2442: ,p_token4_value => p_transaction_date);
2443:
2444: RAISE OKL_API.G_EXCEPTION_ERROR;
2445:
2446: ELSE
2447:
2448: OPEN get_acct_derivation_csr;

Line 2456: IF (l_tmpl_rec.FMA_ID IS NULL) OR (l_tmpl_rec.FMA_ID = OKL_API.G_MISS_NUM) THEN

2452: FOR j IN 1..l_template_tbl.COUNT
2453: LOOP
2454: l_tmpl_rec := l_template_tbl(j);
2455:
2456: IF (l_tmpl_rec.FMA_ID IS NULL) OR (l_tmpl_rec.FMA_ID = OKL_API.G_MISS_NUM) THEN
2457: -- If the formula is not found associated with template
2458: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2459: p_msg_name => 'OKL_FMA_NOT_PRESENT',
2460: p_token1 => 'TEMPLATE_NAME',

Line 2458: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

2454: l_tmpl_rec := l_template_tbl(j);
2455:
2456: IF (l_tmpl_rec.FMA_ID IS NULL) OR (l_tmpl_rec.FMA_ID = OKL_API.G_MISS_NUM) THEN
2457: -- If the formula is not found associated with template
2458: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2459: p_msg_name => 'OKL_FMA_NOT_PRESENT',
2460: p_token1 => 'TEMPLATE_NAME',
2461: p_token1_value => l_tmpl_rec.NAME);
2462: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2462: RAISE OKL_API.G_EXCEPTION_ERROR;

2458: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2459: p_msg_name => 'OKL_FMA_NOT_PRESENT',
2460: p_token1 => 'TEMPLATE_NAME',
2461: p_token1_value => l_tmpl_rec.NAME);
2462: RAISE OKL_API.G_EXCEPTION_ERROR;
2463: END IF;
2464:
2465: IF (l_account_derivation = 'ATS') THEN
2466:

Line 2476: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

2472: END LOOP;
2473: CLOSE atl_csr;
2474:
2475: IF (l_rowcount < 2) THEN
2476: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2477: p_msg_name => 'OKL_LT2_LINE_IN_TMPL',
2478: p_token1 => 'TEMPLATE',
2479: p_token1_value => l_tmpl_rec.NAME,
2480: p_token2 => 'COUNT',

Line 2482: x_return_status := OKL_API.G_RET_STS_ERROR;

2478: p_token1 => 'TEMPLATE',
2479: p_token1_value => l_tmpl_rec.NAME,
2480: p_token2 => 'COUNT',
2481: p_token2_value => l_rowcount);
2482: x_return_status := OKL_API.G_RET_STS_ERROR;
2483: RAISE OKL_API.G_EXCEPTION_ERROR;
2484: END IF;
2485: END IF;
2486: END LOOP;

Line 2483: RAISE OKL_API.G_EXCEPTION_ERROR;

2479: p_token1_value => l_tmpl_rec.NAME,
2480: p_token2 => 'COUNT',
2481: p_token2_value => l_rowcount);
2482: x_return_status := OKL_API.G_RET_STS_ERROR;
2483: RAISE OKL_API.G_EXCEPTION_ERROR;
2484: END IF;
2485: END IF;
2486: END LOOP;
2487:

Line 2491: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2487:
2488: END IF;
2489:
2490: EXCEPTION
2491: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2492: x_return_status := OKL_API.G_RET_STS_ERROR;
2493: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2494: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2495: WHEN OTHERS THEN

Line 2492: x_return_status := OKL_API.G_RET_STS_ERROR;

2488: END IF;
2489:
2490: EXCEPTION
2491: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2492: x_return_status := OKL_API.G_RET_STS_ERROR;
2493: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2494: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2495: WHEN OTHERS THEN
2496: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2493: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2489:
2490: EXCEPTION
2491: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2492: x_return_status := OKL_API.G_RET_STS_ERROR;
2493: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2494: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2495: WHEN OTHERS THEN
2496: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2497: OKL_API.SET_MESSAGE(

Line 2494: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2490: EXCEPTION
2491: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2492: x_return_status := OKL_API.G_RET_STS_ERROR;
2493: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2494: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2495: WHEN OTHERS THEN
2496: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2497: OKL_API.SET_MESSAGE(
2498: p_app_name => G_APP_NAME,

Line 2496: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2492: x_return_status := OKL_API.G_RET_STS_ERROR;
2493: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2494: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2495: WHEN OTHERS THEN
2496: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2497: OKL_API.SET_MESSAGE(
2498: p_app_name => G_APP_NAME,
2499: p_msg_name => G_UNEXPECTED_ERROR,
2500: p_token1 => G_SQLCODE_TOKEN,

Line 2497: OKL_API.SET_MESSAGE(

2493: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2494: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2495: WHEN OTHERS THEN
2496: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2497: OKL_API.SET_MESSAGE(
2498: p_app_name => G_APP_NAME,
2499: p_msg_name => G_UNEXPECTED_ERROR,
2500: p_token1 => G_SQLCODE_TOKEN,
2501: p_token1_value => SQLCODE,

Line 2532: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2528: AND str.sty_id = sty.id
2529: AND sty.stream_type_purpose in ('VARIABLE_INTEREST', 'VARIABLE_LOAN_PAYMENT', 'INTEREST_CATCHUP');
2530:
2531: BEGIN
2532: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2533:
2534: OPEN check_chr_streams_csr(p_khr_id);
2535: FETCH check_chr_streams_csr INTO l_chr_streams_exist, l_contract_number;
2536: CLOSE check_chr_streams_csr;

Line 2540: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

2536: CLOSE check_chr_streams_csr;
2537:
2538: IF (l_chr_streams_exist = 'Y') THEN
2539: -- If contract level variable interest streams exist
2540: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2541: p_msg_name => 'OKL_VR_ASSET_NOT_UPGRADE',
2542: p_token1 => 'CONTRACT_NUMBER',
2543: p_token1_value => l_contract_number);
2544: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2544: RAISE OKL_API.G_EXCEPTION_ERROR;

2540: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
2541: p_msg_name => 'OKL_VR_ASSET_NOT_UPGRADE',
2542: p_token1 => 'CONTRACT_NUMBER',
2543: p_token1_value => l_contract_number);
2544: RAISE OKL_API.G_EXCEPTION_ERROR;
2545: END IF;
2546:
2547: EXCEPTION
2548: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 2548: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2544: RAISE OKL_API.G_EXCEPTION_ERROR;
2545: END IF;
2546:
2547: EXCEPTION
2548: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2549: x_return_status := OKL_API.G_RET_STS_ERROR;
2550: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2551: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2552: WHEN OTHERS THEN

Line 2549: x_return_status := OKL_API.G_RET_STS_ERROR;

2545: END IF;
2546:
2547: EXCEPTION
2548: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2549: x_return_status := OKL_API.G_RET_STS_ERROR;
2550: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2551: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2552: WHEN OTHERS THEN
2553: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 2550: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2546:
2547: EXCEPTION
2548: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2549: x_return_status := OKL_API.G_RET_STS_ERROR;
2550: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2551: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2552: WHEN OTHERS THEN
2553: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2554: OKL_API.SET_MESSAGE(

Line 2551: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2547: EXCEPTION
2548: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2549: x_return_status := OKL_API.G_RET_STS_ERROR;
2550: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2551: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2552: WHEN OTHERS THEN
2553: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2554: OKL_API.SET_MESSAGE(
2555: p_app_name => G_APP_NAME,

Line 2553: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2549: x_return_status := OKL_API.G_RET_STS_ERROR;
2550: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2551: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2552: WHEN OTHERS THEN
2553: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2554: OKL_API.SET_MESSAGE(
2555: p_app_name => G_APP_NAME,
2556: p_msg_name => G_UNEXPECTED_ERROR,
2557: p_token1 => G_SQLCODE_TOKEN,

Line 2554: OKL_API.SET_MESSAGE(

2550: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2551: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2552: WHEN OTHERS THEN
2553: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2554: OKL_API.SET_MESSAGE(
2555: p_app_name => G_APP_NAME,
2556: p_msg_name => G_UNEXPECTED_ERROR,
2557: p_token1 => G_SQLCODE_TOKEN,
2558: p_token1_value => SQLCODE,