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_INTEREST_PVT dependencies on OKL_EXECUTE_FORMULA_PUB

Line 415: Okl_Execute_Formula_Pub.EXECUTE(p_api_version => 1.0,

411: --Changed the formula to CONTRACT_CAP_AMNT_LOAN by bkatraga for bug 13031080
412: --Bug# 13809156: Changed Formula to CONTRACT_CAP_AMNT_PRICE to reduce
413: -- capitalized downpayment when computing contract cap amount
414: -- Derive Principal Balance
415: Okl_Execute_Formula_Pub.EXECUTE(p_api_version => 1.0,
416: p_init_msg_list => OKL_API.G_FALSE,
417: x_return_status => x_return_status,
418: x_msg_count => x_msg_count,
419: x_msg_data => x_msg_data,

Line 423: p_additional_parameters => Okl_Execute_Formula_Pub.g_additional_parameters, -- vsgandhi Bug 13106699

419: x_msg_data => x_msg_data,
420: p_formula_name => 'CONTRACT_CAP_AMNT_PRICE',
421: p_contract_id => p_contract_id,
422: p_line_id => NULL,
423: p_additional_parameters => Okl_Execute_Formula_Pub.g_additional_parameters, -- vsgandhi Bug 13106699
424: x_value => x_principal_balance
425: );
426:
427: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN

Line 428: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE completed successfully');

424: x_value => x_principal_balance
425: );
426:
427: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
428: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE completed successfully');
429: ELSIF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
430: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
431: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
432: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 430: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');

426:
427: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
428: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE completed successfully');
429: ELSIF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
430: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
431: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
432: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
433: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
434: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');

Line 431: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');

427: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
428: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE completed successfully');
429: ELSIF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
430: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
431: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
432: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
433: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
434: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');
435: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');

Line 434: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');

430: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
431: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
432: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
433: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
434: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');
435: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');
436: RAISE get_ctr_fin_amt_failed;
437: END IF;
438:

Line 435: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');

431: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
432: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
433: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
434: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');
435: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');
436: RAISE get_ctr_fin_amt_failed;
437: END IF;
438:
439: G_CONTRACT_ID := p_contract_id;

Line 516: Okl_Execute_Formula_Pub.EXECUTE(p_api_version => 1.0,

512: --Changed the formula to LINE_CAP_AMNT_LOAN by bkatraga for bug 13031080
513: --Bug# 14637671: Changed Formula to LINE_CAP_AMNT_PRICE to reduce
514: -- capitalized downpayment when computing line cap amount
515: -- Derive Principal Balance
516: Okl_Execute_Formula_Pub.EXECUTE(p_api_version => 1.0,
517: p_init_msg_list => OKL_API.G_FALSE,
518: x_return_status => x_return_status,
519: x_msg_count => x_msg_count,
520: x_msg_data => x_msg_data,

Line 524: p_additional_parameters => Okl_Execute_Formula_Pub.g_additional_parameters, -- vsgandhi bug13106699

520: x_msg_data => x_msg_data,
521: p_formula_name => 'LINE_CAP_AMNT_PRICE',
522: p_contract_id => p_contract_id,
523: p_line_id => p_line_id,
524: p_additional_parameters => Okl_Execute_Formula_Pub.g_additional_parameters, -- vsgandhi bug13106699
525: x_value => x_principal_balance
526: );
527:
528: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN

Line 529: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE completed successfully');

525: x_value => x_principal_balance
526: );
527:
528: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
529: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE completed successfully');
530: ELSIF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
531: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
532: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
533: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 531: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');

527:
528: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
529: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE completed successfully');
530: ELSIF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
531: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
532: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
533: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
534: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
535: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');

Line 532: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');

528: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
529: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE completed successfully');
530: ELSIF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
531: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
532: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
533: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
534: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
535: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');
536: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');

Line 535: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');

531: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
532: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
533: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
534: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
535: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');
536: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');
537: RAISE get_asset_fin_amt_failed;
538: END IF;
539:

Line 536: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');

532: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
533: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
534: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
535: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');
536: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');
537: RAISE get_asset_fin_amt_failed;
538: END IF;
539:
540: G_CONTRACT_ID := p_contract_id;

Line 6120: Okl_Execute_Formula_Pub.EXECUTE(

6116: l_total_asset_val := 0;
6117: FOR current_line in contract_line_csr(p_contract_id, p_due_date)
6118: LOOP
6119: -- Derive Asset Cost
6120: Okl_Execute_Formula_Pub.EXECUTE(
6121: p_api_version => 1.0,
6122: p_init_msg_list => OKL_API.G_FALSE,
6123: x_return_status => x_return_status,
6124: x_msg_count => x_msg_count,

Line 6131: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE completed successfully');

6127: p_contract_id => p_contract_id,
6128: p_line_id => current_line.id,
6129: x_value => l_asset_cost);
6130: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
6131: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE completed successfully');
6132: ELSIF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
6133: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
6134: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
6135: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 6133: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');

6129: x_value => l_asset_cost);
6130: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
6131: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE completed successfully');
6132: ELSIF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
6133: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
6134: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
6135: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
6136: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
6137: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');

Line 6134: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');

6130: IF (x_return_status = Okl_Api.G_RET_STS_SUCCESS) THEN
6131: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE completed successfully');
6132: ELSIF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
6133: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
6134: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
6135: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
6136: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
6137: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');
6138: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');

Line 6137: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');

6133: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
6134: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
6135: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
6136: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
6137: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');
6138: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');
6139: RAISE Create_Daily_Int_Str_failed;
6140: END IF;
6141:

Line 6138: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');

6134: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned unexpected error');
6135: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
6136: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
6137: print_debug ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');
6138: print_error_message ('Procedure OKL_EXECUTE_FORMULA_PUB.EXECUTE returned exception');
6139: RAISE Create_Daily_Int_Str_failed;
6140: END IF;
6141:
6142: IF (l_asset_cost > 0) THEN

Line 6372: Okl_Execute_Formula_Pub.EXECUTE(p_api_version => 1.0,

6368: END IF;
6369: CLOSE formula_csr;
6370:
6371: -- Derive Interest using formula
6372: Okl_Execute_Formula_Pub.EXECUTE(p_api_version => 1.0,
6373: p_init_msg_list => OKL_API.G_TRUE,
6374: x_return_status => x_return_status,
6375: x_msg_count => x_msg_count,
6376: x_msg_data => x_msg_data,

Line 6380: p_additional_parameters => Okl_Execute_Formula_Pub.g_additional_parameters, -- vsgandhi bug 13106699

6376: x_msg_data => x_msg_data,
6377: p_formula_name => l_formula_name,
6378: p_contract_id => p_contract_id,
6379: p_line_id => p_line_id,
6380: p_additional_parameters => Okl_Execute_Formula_Pub.g_additional_parameters, -- vsgandhi bug 13106699
6381: x_value => l_interest_calculated
6382: );
6383: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
6384: print_error_message('Unexpected error raised in call to OKL_EXECUTE_FORMULA_PUB.EXECUTE');

Line 6384: print_error_message('Unexpected error raised in call to OKL_EXECUTE_FORMULA_PUB.EXECUTE');

6380: p_additional_parameters => Okl_Execute_Formula_Pub.g_additional_parameters, -- vsgandhi bug 13106699
6381: x_value => l_interest_calculated
6382: );
6383: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
6384: print_error_message('Unexpected error raised in call to OKL_EXECUTE_FORMULA_PUB.EXECUTE');
6385: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
6386: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
6387: print_error_message('Error raised in call to OKL_EXECUTE_FORMULA_PUB.EXECUTE');
6388: RAISE calc_total_int_due_failed;

Line 6387: print_error_message('Error raised in call to OKL_EXECUTE_FORMULA_PUB.EXECUTE');

6383: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
6384: print_error_message('Unexpected error raised in call to OKL_EXECUTE_FORMULA_PUB.EXECUTE');
6385: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
6386: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
6387: print_error_message('Error raised in call to OKL_EXECUTE_FORMULA_PUB.EXECUTE');
6388: RAISE calc_total_int_due_failed;
6389: END IF;
6390: END IF;
6391: RETURN l_interest_calculated;