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

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

79: AND rulb2.rule_information_category = 'LASLL'
80: AND rulb2.RULE_INFORMATION7 IS NOT NULL
81: AND styb.STREAM_TYPE_PURPOSE = 'VARIABLE_INTEREST_SCHEDULE';
82:
83: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
84: l_recurrence_date DATE := NULL;
85: l_frequency okc_rules_b.object1_id1%type;
86: l_adder_months NUMBER := 0;
87:

Line 187: IF(l_return_status <> OKL_API.G_RET_STS_SUCCESS)THEN

183: x_date => l_end_date,
184: x_return_status => l_return_status,
185: p_recurrence_date => l_recurrence_date,
186: p_arrears_pay_dates_option => 'LAST_DAY_OF_PERIOD');
187: IF(l_return_status <> OKL_API.G_RET_STS_SUCCESS)THEN
188: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
189: END IF;
190:
191: OKL_VARIABLE_INTEREST_PVT.print_debug('l_start_date: '|| l_start_date);

Line 188: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

184: x_return_status => l_return_status,
185: p_recurrence_date => l_recurrence_date,
186: p_arrears_pay_dates_option => 'LAST_DAY_OF_PERIOD');
187: IF(l_return_status <> OKL_API.G_RET_STS_SUCCESS)THEN
188: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
189: END IF;
190:
191: OKL_VARIABLE_INTEREST_PVT.print_debug('l_start_date: '|| l_start_date);
192: OKL_VARIABLE_INTEREST_PVT.print_debug('l_end_date: '|| l_end_date);

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

252: p_invoice_date IN DATE) IS
253:
254: l_api_version CONSTANT NUMBER := 1.0;
255: l_api_name CONSTANT VARCHAR2(30) := 'VARIABLE_INT_REV_LOAN_FLOAT';
256: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
257: l_msg_index_out NUMBER;
258: l_interest_calculated NUMBER := 0;
259: l_total_loan_pmt NUMBER := 0;
260: l_invoice_id NUMBER;

Line 305: x_return_status := OKL_API.G_RET_STS_SUCCESS;

301: OKL_VARIABLE_INTEREST_PVT.Print_debug('Currency Code: '|| p_currency_code);
302: OKL_VARIABLE_INTEREST_PVT.print_debug('Start Date: '|| p_start_date);
303: OKL_VARIABLE_INTEREST_PVT.print_debug('Due Date: '|| p_due_date);
304:
305: x_return_status := OKL_API.G_RET_STS_SUCCESS;
306: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl.delete;
307: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter := 0;
308: OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl.delete;
309: OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl_counter := 0;

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

316: x_return_status => x_return_status,
317: x_msg_count => x_msg_count,
318: x_msg_data => x_msg_data);
319:
320: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
321: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_TXNS');
322: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
323: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
324: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_TXNS');

Line 322: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

318: x_msg_data => x_msg_data);
319:
320: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
321: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_TXNS');
322: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
323: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
324: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_TXNS');
325: RAISE variable_int_rev_loan_float;
326: END IF;

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

319:
320: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
321: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_TXNS');
322: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
323: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
324: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_TXNS');
325: RAISE variable_int_rev_loan_float;
326: END IF;
327:

Line 347: p_init_msg_list => OKL_API.G_FALSE,

343: FOR i IN l_payment_tbl.FIRST..l_payment_tbl.LAST LOOP
344:
345: l_interest := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(
346: p_api_version => 1.0,
347: p_init_msg_list => OKL_API.G_FALSE,
348: x_return_status => x_return_status,
349: x_msg_count => x_msg_count,
350: x_msg_data => x_msg_data,
351: p_contract_id => p_contract_id,

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

352: p_currency_code => p_currency_code,
353: p_start_date => l_payment_tbl(i).period_start_date,
354: p_due_date => l_payment_tbl(i).period_end_date,
355: p_conversion_factor => l_payment_tbl(i).conversion_factor);
356: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
357: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
358: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
359: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
360: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CALCULATE_TOTAL_INTEREST_DUE');

Line 358: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

354: p_due_date => l_payment_tbl(i).period_end_date,
355: p_conversion_factor => l_payment_tbl(i).conversion_factor);
356: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
357: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
358: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
359: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
360: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
361: RAISE variable_int_rev_loan_float;
362: END IF;

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

355: p_conversion_factor => l_payment_tbl(i).conversion_factor);
356: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
357: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
358: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
359: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
360: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
361: RAISE variable_int_rev_loan_float;
362: END IF;
363:

Line 370: p_init_msg_list => OKL_API.G_FALSE,

366: END IF;
367: ELSE
368: l_interest_calculated := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(
369: p_api_version => 1.0,
370: p_init_msg_list => OKL_API.G_FALSE,
371: x_return_status => x_return_status,
372: x_msg_count => x_msg_count,
373: x_msg_data => x_msg_data,
374: p_contract_id => p_contract_id,

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

374: p_contract_id => p_contract_id,
375: p_currency_code => p_currency_code,
376: p_start_date => p_start_date,
377: p_due_date => p_due_date);
378: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
379: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
380: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
381: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
382: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CALCULATE_TOTAL_INTEREST_DUE');

Line 380: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

376: p_start_date => p_start_date,
377: p_due_date => p_due_date);
378: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
379: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
380: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
381: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
382: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
383: RAISE variable_int_rev_loan_float;
384: END IF;

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

377: p_due_date => p_due_date);
378: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
379: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
380: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
381: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
382: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
383: RAISE variable_int_rev_loan_float;
384: END IF;
385: END IF;

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

393: p_khr_id => p_contract_id,
394: x_arrears_pay_dates_option => l_arrears_pay_dates_option,
395: x_return_status => x_return_status);
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: x_arrears_pay_dates_option => l_arrears_pay_dates_option,
395: x_return_status => x_return_status);
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: x_return_status => x_return_status);
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: IF (p_principal_basis = 'ACTUAL') THEN

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: IF (p_principal_basis = 'ACTUAL') THEN
404: l_stream_element_start_date := p_start_date;

Line 463: p_create_invoice_flag => OKL_API.G_TRUE,

459: p_amount => l_invoice_amt,
460: --Bug# 13026821
461: p_due_date => p_invoice_date,
462: p_stream_type_purpose => l_stream_type_purpose,
463: p_create_invoice_flag => OKL_API.G_TRUE,
464: p_parent_strm_element_id => NULL,
465: x_invoice_id => l_invoice_id,
466: x_stream_element_id => l_stream_element_id);
467:

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

464: p_parent_strm_element_id => NULL,
465: x_invoice_id => l_invoice_id,
466: x_stream_element_id => l_stream_element_id);
467:
468: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
469: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CREATE_STREAM_INVOICE');
470: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
471: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
472: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CREATE_STREAM_INVOICE');

Line 470: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

466: x_stream_element_id => l_stream_element_id);
467:
468: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
469: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CREATE_STREAM_INVOICE');
470: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
471: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
472: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CREATE_STREAM_INVOICE');
473: RAISE variable_int_rev_loan_float;
474: END IF;

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

467:
468: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
469: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CREATE_STREAM_INVOICE');
470: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
471: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
472: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CREATE_STREAM_INVOICE');
473: RAISE variable_int_rev_loan_float;
474: END IF;
475: i_vir_tbl := OKL_VARIABLE_INTEREST_PVT.g_vir_tbl;

Line 480: p_init_msg_list => OKL_API.G_TRUE,

476:
477: --checkwhat does it do
478: OKL_VARIABLE_INTEREST_PVT.upd_vir_params_with_invoice (
479: p_api_version => 1.0,
480: p_init_msg_list => OKL_API.G_TRUE,
481: x_return_status => x_return_status,
482: x_msg_count => x_msg_count,
483: x_msg_data => x_msg_data,
484: p_source_id => l_invoice_id,

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

483: x_msg_data => x_msg_data,
484: p_source_id => l_invoice_id,
485: p_vir_tbl => i_vir_tbl,
486: x_vir_tbl => r_vir_tbl);
487: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
488: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
489: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
490: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
491: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');

Line 489: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

485: p_vir_tbl => i_vir_tbl,
486: x_vir_tbl => r_vir_tbl);
487: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
488: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
489: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
490: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
491: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
492: RAISE variable_int_rev_loan_float;
493: END IF;

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

486: x_vir_tbl => r_vir_tbl);
487: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
488: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
489: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
490: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
491: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
492: RAISE variable_int_rev_loan_float;
493: END IF;
494:

Line 499: p_init_msg_list => OKL_API.G_TRUE,

495: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl := r_vir_tbl;
496:
497: OKL_VR_DATA_HANDLER_PVT.INSERT_VIR_PARAMS(
498: p_api_version => 1.0,
499: p_init_msg_list => OKL_API.G_TRUE,
500: x_return_status => x_return_status,
501: x_msg_count => x_msg_count,
502: x_msg_data => x_msg_data,
503: p_vir_tbl => OKL_VARIABLE_INTEREST_PVT.g_vir_tbl);

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

500: x_return_status => x_return_status,
501: x_msg_count => x_msg_count,
502: x_msg_data => x_msg_data,
503: p_vir_tbl => OKL_VARIABLE_INTEREST_PVT.g_vir_tbl);
504: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
505: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to INSERT_VIR_PARAMS');
506: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
507: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
508: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to INSERT_VIR_PARAMS');

Line 506: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

502: x_msg_data => x_msg_data,
503: p_vir_tbl => OKL_VARIABLE_INTEREST_PVT.g_vir_tbl);
504: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
505: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to INSERT_VIR_PARAMS');
506: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
507: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
508: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to INSERT_VIR_PARAMS');
509: RAISE variable_int_rev_loan_float;
510: END IF;

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

503: p_vir_tbl => OKL_VARIABLE_INTEREST_PVT.g_vir_tbl);
504: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
505: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to INSERT_VIR_PARAMS');
506: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
507: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
508: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to INSERT_VIR_PARAMS');
509: RAISE variable_int_rev_loan_float;
510: END IF;
511:

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

516: x_msg_count => x_msg_count,
517: x_msg_data => x_msg_data,
518: p_vpb_tbl => OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl);
519:
520: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
521: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to INSERT_PRINCIPAL_BAL_TXN');
522: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
523: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
524: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to INSERT_PRINCIPAL_BAL_TXN');

Line 522: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

518: p_vpb_tbl => OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl);
519:
520: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
521: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to INSERT_PRINCIPAL_BAL_TXN');
522: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
523: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
524: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to INSERT_PRINCIPAL_BAL_TXN');
525: RAISE variable_int_rev_loan_float;
526: END IF;

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

519:
520: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
521: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to INSERT_PRINCIPAL_BAL_TXN');
522: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
523: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
524: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to INSERT_PRINCIPAL_BAL_TXN');
525: RAISE variable_int_rev_loan_float;
526: END IF;
527:

Line 536: x_return_status := OKL_API.G_RET_STS_ERROR;

532:
533: EXCEPTION
534: WHEN variable_int_rev_loan_float THEN
535: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception var_int_float_failed raised in procedure VARIABLE_INT_REV_LOAN_FLOAT');
536: x_return_status := OKL_API.G_RET_STS_ERROR;
537: WHEN OTHERS THEN
538: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception raised in procedure VARIABLE_INT_REV_LOAN_FLOAT');
539: Okl_Api.SET_MESSAGE(
540: p_app_name => G_APP_NAME,

Line 539: Okl_Api.SET_MESSAGE(

535: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception var_int_float_failed raised in procedure VARIABLE_INT_REV_LOAN_FLOAT');
536: x_return_status := OKL_API.G_RET_STS_ERROR;
537: WHEN OTHERS THEN
538: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception raised in procedure VARIABLE_INT_REV_LOAN_FLOAT');
539: Okl_Api.SET_MESSAGE(
540: p_app_name => G_APP_NAME,
541: p_msg_name => G_UNEXPECTED_ERROR,
542: p_token1 => G_SQLCODE_TOKEN,
543: p_token1_value => SQLCODE,

Line 547: x_return_status := OKL_API.G_RET_STS_ERROR;

543: p_token1_value => SQLCODE,
544: p_token2 => G_SQLERRM_TOKEN,
545: p_token2_value => SQLERRM);
546:
547: x_return_status := OKL_API.G_RET_STS_ERROR;
548:
549: END variable_int_rev_loan_float;
550:
551:

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

582: p_invoice_date IN DATE) IS
583:
584: l_api_version CONSTANT NUMBER := 1.0;
585: l_api_name CONSTANT VARCHAR2(30) := 'VARIABLE_INTEREST_LOAN_FLOAT';
586: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
587: l_msg_index_out NUMBER;
588: l_principal_balance NUMBER := 0;
589: l_interest_calculated NUMBER := 0;
590: r_principal_balance_tbl OKL_VARIABLE_INTEREST_PVT.principal_balance_tbl_typ;

Line 717: x_return_status := OKL_API.G_RET_STS_SUCCESS;

713: OKL_VARIABLE_INTEREST_PVT.Print_debug('Currency Code: '|| p_currency_code);
714: OKL_VARIABLE_INTEREST_PVT.print_debug('Start Date: '|| p_start_date);
715: OKL_VARIABLE_INTEREST_PVT.print_debug('Due Date: '|| p_due_date);
716:
717: x_return_status := OKL_API.G_RET_STS_SUCCESS;
718:
719: --Bug# 13447258: Variable Rate processing is not allowed for Float Loan contracts if
720: -- contract streams have not been upgraded to asset level
721: OKL_VARIABLE_INT_UTIL_PVT.check_vr_asset_level_upgrade(

Line 725: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

721: OKL_VARIABLE_INT_UTIL_PVT.check_vr_asset_level_upgrade(
722: p_khr_id => p_contract_id,
723: x_return_status => x_return_status);
724:
725: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
726: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
727: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
728: RAISE var_int_loan_float_failed;
729: END IF;

Line 726: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

722: p_khr_id => p_contract_id,
723: x_return_status => x_return_status);
724:
725: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
726: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
727: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
728: RAISE var_int_loan_float_failed;
729: END IF;
730:

Line 727: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

723: x_return_status => x_return_status);
724:
725: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
726: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
727: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
728: RAISE var_int_loan_float_failed;
729: END IF;
730:
731: OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl.delete;

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

739: x_return_status => x_return_status,
740: x_msg_count => x_msg_count,
741: x_msg_data => x_msg_data);
742:
743: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
744: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_TXNS');
745: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
746: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
747: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_TXNS');

Line 745: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

741: x_msg_data => x_msg_data);
742:
743: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
744: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_TXNS');
745: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
746: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
747: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_TXNS');
748: RAISE var_int_loan_float_failed;
749: END IF;

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

742:
743: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
744: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to POPULATE_TXNS');
745: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
746: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
747: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to POPULATE_TXNS');
748: RAISE var_int_loan_float_failed;
749: END IF;
750:

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

752: OKL_ISG_UTILS_PVT.get_arrears_pay_dates_option(
753: p_khr_id => p_contract_id,
754: x_arrears_pay_dates_option => l_arrears_pay_dates_option,
755: x_return_status => x_return_status);
756: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
757: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
758: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
759: RAISE OKL_API.G_EXCEPTION_ERROR;
760: END IF;

Line 757: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

753: p_khr_id => p_contract_id,
754: x_arrears_pay_dates_option => l_arrears_pay_dates_option,
755: x_return_status => x_return_status);
756: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
757: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
758: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
759: RAISE OKL_API.G_EXCEPTION_ERROR;
760: END IF;
761:

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

754: x_arrears_pay_dates_option => l_arrears_pay_dates_option,
755: x_return_status => x_return_status);
756: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
757: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
758: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
759: RAISE OKL_API.G_EXCEPTION_ERROR;
760: END IF;
761:
762: --Bug# 14165508

Line 759: RAISE OKL_API.G_EXCEPTION_ERROR;

755: x_return_status => x_return_status);
756: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
757: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
758: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
759: RAISE OKL_API.G_EXCEPTION_ERROR;
760: END IF;
761:
762: --Bug# 14165508
763: IF OKL_VARIABLE_INTEREST_PVT.G_DAYS_IN_A_MONTH_CODE = '30' THEN

Line 788: p_init_msg_list => OKL_API.G_FALSE,

784:
785: --Added parameter p_line_id by bkatraga for bug 13447258
786: l_interest := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(
787: p_api_version => 1.0,
788: p_init_msg_list => OKL_API.G_FALSE,
789: x_return_status => x_return_status,
790: x_msg_count => x_msg_count,
791: x_msg_data => x_msg_data,
792: p_contract_id => p_contract_id,

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

794: p_start_date => l_payment_tbl(i).period_start_date,
795: p_due_date => l_payment_tbl(i).period_end_date,
796: p_line_id => l_asset_rec.id,
797: p_conversion_factor => l_payment_tbl(i).conversion_factor);
798: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
799: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
800: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
801: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
802: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CALCULATE_TOTAL_INTEREST_DUE');

Line 800: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

796: p_line_id => l_asset_rec.id,
797: p_conversion_factor => l_payment_tbl(i).conversion_factor);
798: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
799: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
800: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
801: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
802: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
803: RAISE var_int_loan_float_failed;
804: END IF;

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

797: p_conversion_factor => l_payment_tbl(i).conversion_factor);
798: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
799: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
800: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
801: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
802: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
803: RAISE var_int_loan_float_failed;
804: END IF;
805:

Line 814: p_init_msg_list => OKL_API.G_FALSE,

810:
811: --Added parameter p_line_id by bkatraga for bug 13447258
812: l_interest_calculated := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(
813: p_api_version => 1.0,
814: p_init_msg_list => OKL_API.G_FALSE,
815: x_return_status => x_return_status,
816: x_msg_count => x_msg_count,
817: x_msg_data => x_msg_data,
818: p_contract_id => p_contract_id,

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

819: p_currency_code => p_currency_code,
820: p_start_date => p_start_date,
821: p_due_date => p_due_date,
822: p_line_id => l_asset_rec.id);
823: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
824: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
825: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
826: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
827: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CALCULATE_TOTAL_INTEREST_DUE');

Line 825: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

821: p_due_date => p_due_date,
822: p_line_id => l_asset_rec.id);
823: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
824: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
825: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
826: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
827: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
828: RAISE var_int_loan_float_failed;
829: END IF;

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

822: p_line_id => l_asset_rec.id);
823: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
824: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
825: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
826: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
827: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CALCULATE_TOTAL_INTEREST_DUE');
828: RAISE var_int_loan_float_failed;
829: END IF;
830:

Line 909: p_create_invoice_flag => OKL_API.G_TRUE,

905: p_amount => l_invoice_amt,
906: --Bug# 13026821
907: p_due_date => p_invoice_date,
908: p_stream_type_purpose => l_stream_type_purpose,
909: p_create_invoice_flag => OKL_API.G_TRUE,
910: p_parent_strm_element_id => NULL,
911: x_invoice_id => l_invoice_id,
912: x_stream_element_id => l_stream_element_id);
913:

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

910: p_parent_strm_element_id => NULL,
911: x_invoice_id => l_invoice_id,
912: x_stream_element_id => l_stream_element_id);
913:
914: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
915: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CREATE_STREAM_INVOICE');
916: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
917: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
918: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CREATE_STREAM_INVOICE');

Line 916: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

912: x_stream_element_id => l_stream_element_id);
913:
914: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
915: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CREATE_STREAM_INVOICE');
916: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
917: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
918: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CREATE_STREAM_INVOICE');
919: RAISE var_int_loan_float_failed;
920: END IF;

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

913:
914: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
915: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CREATE_STREAM_INVOICE');
916: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
917: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
918: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CREATE_STREAM_INVOICE');
919: RAISE var_int_loan_float_failed;
920: END IF;
921: i_vir_tbl := OKL_VARIABLE_INTEREST_PVT.g_vir_tbl;

Line 926: p_init_msg_list => OKL_API.G_TRUE,

922:
923: --checkwhat does it do
924: OKL_VARIABLE_INTEREST_PVT.upd_vir_params_with_invoice (
925: p_api_version => 1.0,
926: p_init_msg_list => OKL_API.G_TRUE,
927: x_return_status => x_return_status,
928: x_msg_count => x_msg_count,
929: x_msg_data => x_msg_data,
930: p_source_id => l_invoice_id,

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

929: x_msg_data => x_msg_data,
930: p_source_id => l_invoice_id,
931: p_vir_tbl => i_vir_tbl,
932: x_vir_tbl => r_vir_tbl);
933: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
934: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
935: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
936: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
937: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');

Line 935: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

931: p_vir_tbl => i_vir_tbl,
932: x_vir_tbl => r_vir_tbl);
933: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
934: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
935: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
936: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
937: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
938: RAISE var_int_loan_float_failed;
939: END IF;

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

932: x_vir_tbl => r_vir_tbl);
933: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
934: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
935: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
936: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
937: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
938: RAISE var_int_loan_float_failed;
939: END IF;
940:

Line 945: p_init_msg_list => OKL_API.G_TRUE,

941: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl := r_vir_tbl;
942:
943: OKL_VR_DATA_HANDLER_PVT.INSERT_VIR_PARAMS(
944: p_api_version => 1.0,
945: p_init_msg_list => OKL_API.G_TRUE,
946: x_return_status => x_return_status,
947: x_msg_count => x_msg_count,
948: x_msg_data => x_msg_data,
949: p_vir_tbl => OKL_VARIABLE_INTEREST_PVT.g_vir_tbl);

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

946: x_return_status => x_return_status,
947: x_msg_count => x_msg_count,
948: x_msg_data => x_msg_data,
949: p_vir_tbl => OKL_VARIABLE_INTEREST_PVT.g_vir_tbl);
950: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
951: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to INSERT_VIR_PARAMS');
952: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
953: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
954: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to INSERT_VIR_PARAMS');

Line 952: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

948: x_msg_data => x_msg_data,
949: p_vir_tbl => OKL_VARIABLE_INTEREST_PVT.g_vir_tbl);
950: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
951: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to INSERT_VIR_PARAMS');
952: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
953: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
954: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to INSERT_VIR_PARAMS');
955: RAISE var_int_loan_float_failed;
956: END IF;

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

949: p_vir_tbl => OKL_VARIABLE_INTEREST_PVT.g_vir_tbl);
950: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
951: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to INSERT_VIR_PARAMS');
952: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
953: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
954: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to INSERT_VIR_PARAMS');
955: RAISE var_int_loan_float_failed;
956: END IF;
957:

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

966: x_msg_count => x_msg_count,
967: x_msg_data => x_msg_data,
968: p_vpb_tbl => OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl);
969:
970: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
971: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to INSERT_PRINCIPAL_BAL_TXN');
972: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
973: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
974: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to INSERT_PRINCIPAL_BAL_TXN');

Line 972: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

968: p_vpb_tbl => OKL_VARIABLE_INTEREST_PVT.g_vpb_tbl);
969:
970: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
971: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to INSERT_PRINCIPAL_BAL_TXN');
972: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
973: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
974: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to INSERT_PRINCIPAL_BAL_TXN');
975: RAISE var_int_loan_float_failed;
976: END IF;

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

969:
970: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
971: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to INSERT_PRINCIPAL_BAL_TXN');
972: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
973: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
974: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to INSERT_PRINCIPAL_BAL_TXN');
975: RAISE var_int_loan_float_failed;
976: END IF;
977:

Line 1016: p_create_invoice_flag => OKL_API.G_TRUE,

1012: p_line_id => l_kle_id,
1013: p_amount => l_invoice_amt,
1014: p_due_date => l_strm_element_date,
1015: p_stream_type_purpose => l_stream_type_purpose,
1016: p_create_invoice_flag => OKL_API.G_TRUE,
1017: p_parent_strm_element_id => l_parent_strm_element_id,
1018: x_invoice_id => l_invoice_id,
1019: x_stream_element_id => l_stream_element_id);
1020: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

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

1016: p_create_invoice_flag => OKL_API.G_TRUE,
1017: p_parent_strm_element_id => l_parent_strm_element_id,
1018: x_invoice_id => l_invoice_id,
1019: x_stream_element_id => l_stream_element_id);
1020: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1021: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CREATE_STREAM_INVOICE');
1022: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1023: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1024: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CREATE_STREAM_INVOICE');

Line 1022: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1018: x_invoice_id => l_invoice_id,
1019: x_stream_element_id => l_stream_element_id);
1020: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1021: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CREATE_STREAM_INVOICE');
1022: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1023: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1024: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CREATE_STREAM_INVOICE');
1025: RAISE var_int_loan_float_failed;
1026: END IF;

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

1019: x_stream_element_id => l_stream_element_id);
1020: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1021: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to CREATE_STREAM_INVOICE');
1022: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1023: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1024: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to CREATE_STREAM_INVOICE');
1025: RAISE var_int_loan_float_failed;
1026: END IF;
1027:

Line 1036: x_return_status := OKL_API.G_RET_STS_ERROR;

1032:
1033: EXCEPTION
1034: WHEN var_int_loan_float_failed THEN
1035: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception var_int_loan_float_failed raised in procedure VARIABLE_INTEREST_LOAN_FLOAT');
1036: x_return_status := OKL_API.G_RET_STS_ERROR;
1037: WHEN OTHERS THEN
1038: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception raised in procedure VARIABLE_INTEREST_LOAN_FLOAT');
1039: Okl_Api.SET_MESSAGE(
1040: p_app_name => G_APP_NAME,

Line 1039: Okl_Api.SET_MESSAGE(

1035: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception var_int_loan_float_failed raised in procedure VARIABLE_INTEREST_LOAN_FLOAT');
1036: x_return_status := OKL_API.G_RET_STS_ERROR;
1037: WHEN OTHERS THEN
1038: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception raised in procedure VARIABLE_INTEREST_LOAN_FLOAT');
1039: Okl_Api.SET_MESSAGE(
1040: p_app_name => G_APP_NAME,
1041: p_msg_name => G_UNEXPECTED_ERROR,
1042: p_token1 => G_SQLCODE_TOKEN,
1043: p_token1_value => SQLCODE,

Line 1047: x_return_status := OKL_API.G_RET_STS_ERROR;

1043: p_token1_value => SQLCODE,
1044: p_token2 => G_SQLERRM_TOKEN,
1045: p_token2_value => SQLERRM);
1046:
1047: x_return_status := OKL_API.G_RET_STS_ERROR;
1048:
1049: END variable_interest_loan_float;
1050:
1051:

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

1115: p_khr_id => OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID,
1116: x_arrears_pay_dates_option => l_arrears_pay_dates_option,
1117: x_return_status => x_return_status);
1118:
1119: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1121: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1122: RAISE OKL_API.G_EXCEPTION_ERROR;
1123: END IF;

Line 1120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1116: x_arrears_pay_dates_option => l_arrears_pay_dates_option,
1117: x_return_status => x_return_status);
1118:
1119: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1121: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1122: RAISE OKL_API.G_EXCEPTION_ERROR;
1123: END IF;
1124:

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

1117: x_return_status => x_return_status);
1118:
1119: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1121: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1122: RAISE OKL_API.G_EXCEPTION_ERROR;
1123: END IF;
1124:
1125: OKL_VARIABLE_INTEREST_PVT.print_debug('Internal Arrears Pay Date Option : '|| l_arrears_pay_dates_option);

Line 1122: RAISE OKL_API.G_EXCEPTION_ERROR;

1118:
1119: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1120: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1121: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1122: RAISE OKL_API.G_EXCEPTION_ERROR;
1123: END IF;
1124:
1125: OKL_VARIABLE_INTEREST_PVT.print_debug('Internal Arrears Pay Date Option : '|| l_arrears_pay_dates_option);
1126: END IF;

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

1178: x_return_status => x_return_status,
1179: x_msg_count => x_msg_count,
1180: x_msg_data => x_msg_data);
1181:
1182: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1183: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to OKL_STREAM_GENERATOR_PVT.get_next_billing_date');
1184: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1185: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1186: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to OKL_STREAM_GENERATOR_PVT.get_next_billing_date');

Line 1184: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1180: x_msg_data => x_msg_data);
1181:
1182: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1183: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to OKL_STREAM_GENERATOR_PVT.get_next_billing_date');
1184: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1185: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1186: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to OKL_STREAM_GENERATOR_PVT.get_next_billing_date');
1187: RAISE process_int_float_failed;
1188: END IF;

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

1181:
1182: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1183: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to OKL_STREAM_GENERATOR_PVT.get_next_billing_date');
1184: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1185: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1186: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to OKL_STREAM_GENERATOR_PVT.get_next_billing_date');
1187: RAISE process_int_float_failed;
1188: END IF;
1189:

Line 1220: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1216: END IF;
1217:
1218: OKL_VARIABLE_INTEREST_PVT.print_debug('Stream Element Date: '||l_due_date);
1219:
1220: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1221: ----------------------------------------------------
1222: -- Create new transaction header for every
1223: -- contract and bill_date combination
1224: ----------------------------------------------------

Line 1259: p_init_msg_list => OKL_API.G_TRUE,

1255:
1256: IF (OKL_VARIABLE_INTEREST_PVT.G_DEAL_TYPE = 'LOAN') THEN
1257: variable_interest_loan_float(
1258: p_api_version => 1.0,
1259: p_init_msg_list => OKL_API.G_TRUE,
1260: x_return_status => x_return_status,
1261: x_msg_count => x_msg_count,
1262: x_msg_data => x_msg_data,
1263: p_contract_id => OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID,

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

1268: p_start_date => l_int_cal_start_date,
1269: p_due_date => l_due_date,
1270: --Bug# 13026821
1271: p_invoice_date => l_invoice_date);
1272: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1273: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to VARIABLE_INTEREST_LOAN_FLOAT');
1274: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1275: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1276: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to VARIABLE_INTEREST_LOAN_FLOAT');

Line 1274: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1270: --Bug# 13026821
1271: p_invoice_date => l_invoice_date);
1272: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1273: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to VARIABLE_INTEREST_LOAN_FLOAT');
1274: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1275: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1276: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to VARIABLE_INTEREST_LOAN_FLOAT');
1277: RAISE process_int_float_failed;
1278: END IF;

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

1271: p_invoice_date => l_invoice_date);
1272: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1273: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to VARIABLE_INTEREST_LOAN_FLOAT');
1274: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1275: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1276: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to VARIABLE_INTEREST_LOAN_FLOAT');
1277: RAISE process_int_float_failed;
1278: END IF;
1279: ELSIF (OKL_VARIABLE_INTEREST_PVT.G_DEAL_TYPE = 'LOAN-REVOLVING') THEN

Line 1282: p_init_msg_list => OKL_API.G_TRUE,

1278: END IF;
1279: ELSIF (OKL_VARIABLE_INTEREST_PVT.G_DEAL_TYPE = 'LOAN-REVOLVING') THEN
1280: variable_int_rev_loan_float(
1281: p_api_version => 1.0,
1282: p_init_msg_list => OKL_API.G_TRUE,
1283: x_return_status => x_return_status,
1284: x_msg_count => x_msg_count,
1285: x_msg_data => x_msg_data,
1286: p_contract_id => OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID,

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

1291: p_start_date => l_int_cal_start_date,
1292: p_due_date => l_due_date,
1293: --Bug# 13026821
1294: p_invoice_date => l_invoice_date);
1295: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1296: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to VARIABLE_INT_REV_LOAN_FLOAT');
1297: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1298: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1299: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to VARIABLE_INT_REV_LOAN_FLOAT');

Line 1297: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1293: --Bug# 13026821
1294: p_invoice_date => l_invoice_date);
1295: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1296: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to VARIABLE_INT_REV_LOAN_FLOAT');
1297: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1298: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1299: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to VARIABLE_INT_REV_LOAN_FLOAT');
1300: RAISE process_int_float_failed;
1301: END IF;

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

1294: p_invoice_date => l_invoice_date);
1295: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1296: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to VARIABLE_INT_REV_LOAN_FLOAT');
1297: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1298: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1299: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to VARIABLE_INT_REV_LOAN_FLOAT');
1300: RAISE process_int_float_failed;
1301: END IF;
1302: END IF;

Line 1313: p_init_msg_list => OKL_API.G_TRUE,

1309: FND_FILE.PUT_LINE (FND_FILE.LOG, '===============================================================================');
1310:
1311: OKL_VR_DATA_HANDLER_PVT.UPDATE_LAST_INT_CAL_DATE(
1312: p_api_version => 1.0,
1313: p_init_msg_list => OKL_API.G_TRUE,
1314: x_return_status => x_return_status,
1315: x_msg_count => x_msg_count,
1316: x_msg_data => x_msg_data,
1317: p_contract_id => OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID,

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

1315: x_msg_count => x_msg_count,
1316: x_msg_data => x_msg_data,
1317: p_contract_id => OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID,
1318: p_last_interest_cal_date => l_due_date);
1319: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1320: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to UPDATE_LAST_INT_CAL_DATE');
1321: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1322: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1323: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPDATE_LAST_INT_CAL_DATE');

Line 1321: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1317: p_contract_id => OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID,
1318: p_last_interest_cal_date => l_due_date);
1319: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1320: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to UPDATE_LAST_INT_CAL_DATE');
1321: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1322: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1323: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPDATE_LAST_INT_CAL_DATE');
1324: RAISE process_int_float_failed;
1325: END IF;

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

1318: p_last_interest_cal_date => l_due_date);
1319: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1320: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to UPDATE_LAST_INT_CAL_DATE');
1321: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1322: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1323: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to UPDATE_LAST_INT_CAL_DATE');
1324: RAISE process_int_float_failed;
1325: END IF;
1326:

Line 1337: x_return_status := OKL_API.G_RET_STS_ERROR;

1333:
1334: EXCEPTION
1335: WHEN process_int_float_failed THEN
1336: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception process_int_float_failed raised in procedure PROCESS_INTEREST_FLOAT');
1337: x_return_status := OKL_API.G_RET_STS_ERROR;
1338: WHEN OTHERS THEN
1339: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception raised in procedure PROCESS_INTEREST_FLOAT');
1340: Okl_Api.SET_MESSAGE(
1341: p_app_name => G_APP_NAME,

Line 1340: Okl_Api.SET_MESSAGE(

1336: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception process_int_float_failed raised in procedure PROCESS_INTEREST_FLOAT');
1337: x_return_status := OKL_API.G_RET_STS_ERROR;
1338: WHEN OTHERS THEN
1339: OKL_VARIABLE_INTEREST_PVT.print_error_message ('Exception raised in procedure PROCESS_INTEREST_FLOAT');
1340: Okl_Api.SET_MESSAGE(
1341: p_app_name => G_APP_NAME,
1342: p_msg_name => G_UNEXPECTED_ERROR,
1343: p_token1 => G_SQLCODE_TOKEN,
1344: p_token1_value => SQLCODE,

Line 1347: x_return_status := OKL_API.G_RET_STS_ERROR;

1343: p_token1 => G_SQLCODE_TOKEN,
1344: p_token1_value => SQLCODE,
1345: p_token2 => G_SQLERRM_TOKEN,
1346: p_token2_value => SQLERRM);
1347: x_return_status := OKL_API.G_RET_STS_ERROR;
1348: END process_interest_float;
1349: END;