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

Line 19: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;

15: G_LEASE_TYPE CONSTANT VARCHAR2(30) := 'LEASE_TYPE';
16: G_INT_BASIS CONSTANT VARCHAR2(30) := 'INT_BASIS';
17: G_OKL_LLA_VAR_RATE_MISSING CONSTANT VARCHAR2(30) := 'OKL_LLA_VAR_RATE_MISSING';
18: G_CONT_ID CONSTANT VARCHAR2(30) := 'CONT_ID';
19: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
21:
22: -- smadhava Bug#4542290 - 22-Aug-2005 - Added - Start
23: G_OKL_LLA_REBOOK_INVALID CONSTANT VARCHAR2(30) := 'OKL_LLA_REBOOK_INVALID';

Line 20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;

16: G_INT_BASIS CONSTANT VARCHAR2(30) := 'INT_BASIS';
17: G_OKL_LLA_VAR_RATE_MISSING CONSTANT VARCHAR2(30) := 'OKL_LLA_VAR_RATE_MISSING';
18: G_CONT_ID CONSTANT VARCHAR2(30) := 'CONT_ID';
19: G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_REQUIRED_VALUE;
20: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
21:
22: -- smadhava Bug#4542290 - 22-Aug-2005 - Added - Start
23: G_OKL_LLA_REBOOK_INVALID CONSTANT VARCHAR2(30) := 'OKL_LLA_REBOOK_INVALID';
24: G_OKL_LLA_RBK_INT_PROC_INVAL CONSTANT VARCHAR2(30) := 'OKL_LLA_RBK_INT_PROCESS_INVAL';

Line 254: x_return_status := OKL_API.G_RET_STS_SUCCESS;

250: FROM OKL_K_RATE_PARAMS
251: WHERE KHR_ID = p_id
252: AND EFFECTIVE_TO_DATE IS NULL;
253: BEGIN
254: x_return_status := OKL_API.G_RET_STS_SUCCESS;
255:
256: OPEN effective_from_date_csr(p_chr_id);
257: FETCH effective_from_date_csr
258: INTO x_effective_from_date;

Line 266: x_return_status := OKL_API.G_RET_STS_ERROR;

262: x_no_data_found := FALSE;
263: END IF;
264: CLOSE effective_from_date_csr;
265: EXCEPTION WHEN OTHERS THEN
266: x_return_status := OKL_API.G_RET_STS_ERROR;
267: END;
268:
269: procedure get_product(
270: p_api_version IN NUMBER,

Line 303: x_return_status := OKL_API.G_RET_STS_SUCCESS;

299:
300: l_hdr_rec l_hdr_csr%ROWTYPE;
301:
302: begin
303: x_return_status := OKL_API.G_RET_STS_SUCCESS;
304: OPEN l_hdr_csr(p_khr_id);
305: FETCH l_hdr_csr INTO l_hdr_rec;
306: IF l_hdr_csr%NOTFOUND THEN
307: CLOSE l_hdr_csr;

Line 308: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

304: OPEN l_hdr_csr(p_khr_id);
305: FETCH l_hdr_csr INTO l_hdr_rec;
306: IF l_hdr_csr%NOTFOUND THEN
307: CLOSE l_hdr_csr;
308: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
309: END IF;
310: CLOSE l_hdr_csr;
311:
312: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

325: p_pdtv_rec => p_pdtv_rec,
326: x_no_data_found => x_no_data_found,
327: p_pdt_parameter_rec => x_pdt_parameter_rec);
328:
329: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
330: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
331: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
332: RAISE OKL_API.G_EXCEPTION_ERROR;
333: ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN

Line 330: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

326: x_no_data_found => x_no_data_found,
327: p_pdt_parameter_rec => x_pdt_parameter_rec);
328:
329: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
330: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
331: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
332: RAISE OKL_API.G_EXCEPTION_ERROR;
333: ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN
334: x_return_status := OKL_API.G_RET_STS_ERROR;

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

327: p_pdt_parameter_rec => x_pdt_parameter_rec);
328:
329: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
330: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
331: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
332: RAISE OKL_API.G_EXCEPTION_ERROR;
333: ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN
334: x_return_status := OKL_API.G_RET_STS_ERROR;
335: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 332: RAISE OKL_API.G_EXCEPTION_ERROR;

328:
329: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
330: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
331: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
332: RAISE OKL_API.G_EXCEPTION_ERROR;
333: ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN
334: x_return_status := OKL_API.G_RET_STS_ERROR;
335: RAISE OKL_API.G_EXCEPTION_ERROR;
336: END IF;

Line 333: ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN

329: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
330: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
331: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
332: RAISE OKL_API.G_EXCEPTION_ERROR;
333: ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN
334: x_return_status := OKL_API.G_RET_STS_ERROR;
335: RAISE OKL_API.G_EXCEPTION_ERROR;
336: END IF;
337: --x_pdt_parameter_rec := x_pdt_parameter_rec2;

Line 334: x_return_status := OKL_API.G_RET_STS_ERROR;

330: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
331: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
332: RAISE OKL_API.G_EXCEPTION_ERROR;
333: ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN
334: x_return_status := OKL_API.G_RET_STS_ERROR;
335: RAISE OKL_API.G_EXCEPTION_ERROR;
336: END IF;
337: --x_pdt_parameter_rec := x_pdt_parameter_rec2;
338: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 335: RAISE OKL_API.G_EXCEPTION_ERROR;

331: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
332: RAISE OKL_API.G_EXCEPTION_ERROR;
333: ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN
334: x_return_status := OKL_API.G_RET_STS_ERROR;
335: RAISE OKL_API.G_EXCEPTION_ERROR;
336: END IF;
337: --x_pdt_parameter_rec := x_pdt_parameter_rec2;
338: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
339: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'x_pdt_parameter_rec.name=' || x_pdt_parameter_rec.name);

Line 382: x_return_status := OKL_API.G_RET_STS_SUCCESS;

378:
379: l_hdr_rec l_hdr_csr%ROWTYPE;
380:
381: begin
382: x_return_status := OKL_API.G_RET_STS_SUCCESS;
383: OPEN l_hdr_csr(p_khr_id);
384: FETCH l_hdr_csr INTO l_hdr_rec;
385: IF l_hdr_csr%NOTFOUND THEN
386: CLOSE l_hdr_csr;

Line 387: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

383: OPEN l_hdr_csr(p_khr_id);
384: FETCH l_hdr_csr INTO l_hdr_rec;
385: IF l_hdr_csr%NOTFOUND THEN
386: CLOSE l_hdr_csr;
387: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
388: END IF;
389: CLOSE l_hdr_csr;
390:
391: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

405: p_pdtv_rec => p_pdtv_rec,
406: x_no_data_found => x_no_data_found,
407: p_pdt_parameter_rec => x_pdt_parameter_rec);
408:
409: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
410: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
411: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
412: RAISE OKL_API.G_EXCEPTION_ERROR;
413: ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN

Line 410: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

406: x_no_data_found => x_no_data_found,
407: p_pdt_parameter_rec => x_pdt_parameter_rec);
408:
409: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
410: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
411: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
412: RAISE OKL_API.G_EXCEPTION_ERROR;
413: ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN
414: x_return_status := OKL_API.G_RET_STS_ERROR;

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

407: p_pdt_parameter_rec => x_pdt_parameter_rec);
408:
409: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
410: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
411: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
412: RAISE OKL_API.G_EXCEPTION_ERROR;
413: ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN
414: x_return_status := OKL_API.G_RET_STS_ERROR;
415: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 412: RAISE OKL_API.G_EXCEPTION_ERROR;

408:
409: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
410: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
411: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
412: RAISE OKL_API.G_EXCEPTION_ERROR;
413: ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN
414: x_return_status := OKL_API.G_RET_STS_ERROR;
415: RAISE OKL_API.G_EXCEPTION_ERROR;
416: END IF;

Line 413: ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN

409: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
410: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
411: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
412: RAISE OKL_API.G_EXCEPTION_ERROR;
413: ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN
414: x_return_status := OKL_API.G_RET_STS_ERROR;
415: RAISE OKL_API.G_EXCEPTION_ERROR;
416: END IF;
417: --x_pdt_parameter_rec := x_pdt_parameter_rec2;

Line 414: x_return_status := OKL_API.G_RET_STS_ERROR;

410: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
411: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
412: RAISE OKL_API.G_EXCEPTION_ERROR;
413: ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN
414: x_return_status := OKL_API.G_RET_STS_ERROR;
415: RAISE OKL_API.G_EXCEPTION_ERROR;
416: END IF;
417: --x_pdt_parameter_rec := x_pdt_parameter_rec2;
418: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 415: RAISE OKL_API.G_EXCEPTION_ERROR;

411: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
412: RAISE OKL_API.G_EXCEPTION_ERROR;
413: ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN
414: x_return_status := OKL_API.G_RET_STS_ERROR;
415: RAISE OKL_API.G_EXCEPTION_ERROR;
416: END IF;
417: --x_pdt_parameter_rec := x_pdt_parameter_rec2;
418: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
419: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'x_pdt_parameter_rec.name=' || x_pdt_parameter_rec.name);

Line 592: x_return_status := OKL_API.G_RET_STS_SUCCESS;

588: l_product_id NUMBER;
589: l_contract_start_date DATE;
590:
591: begin
592: x_return_status := OKL_API.G_RET_STS_SUCCESS;
593:
594: x_return_status := OKL_API.START_ACTIVITY(
595: p_api_name => l_api_name,
596: p_pkg_name => g_pkg_name,

Line 594: x_return_status := OKL_API.START_ACTIVITY(

590:
591: begin
592: x_return_status := OKL_API.G_RET_STS_SUCCESS;
593:
594: x_return_status := OKL_API.START_ACTIVITY(
595: p_api_name => l_api_name,
596: p_pkg_name => g_pkg_name,
597: p_init_msg_list => p_init_msg_list,
598: l_api_version => l_api_version,

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

610: p_khr_id => p_krpv_rec.khr_id,
611: x_product_id => l_product_id,
612: x_pdt_parameter_rec => l_pdt_parameter_rec);
613:
614: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
615: RAISE OKL_API.G_EXCEPTION_ERROR;
616: END IF;
617:
618: l_deal_type := l_pdt_parameter_rec.deal_type;

Line 615: RAISE OKL_API.G_EXCEPTION_ERROR;

611: x_product_id => l_product_id,
612: x_pdt_parameter_rec => l_pdt_parameter_rec);
613:
614: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
615: RAISE OKL_API.G_EXCEPTION_ERROR;
616: END IF;
617:
618: l_deal_type := l_pdt_parameter_rec.deal_type;
619: l_interest_calculation_basis := l_pdt_parameter_rec.interest_calculation_basis;

Line 679: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

675: ,p_token1 => 'PARAMETER_NAME'
676: ,p_token1_value => 'BASE_RATE'
677: ,p_token2 => 'CONTRACT_NUMBER'
678: ,p_token2_value => l_contract_number);
679: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
680: END IF;
681:
682: IF ((l_orig_rate_rec.INTEREST_START_DATE IS NOT NULL AND
683: l_orig_rate_rec.INTEREST_START_DATE <> G_MISS_DATE) OR

Line 693: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

689: ,p_token1 => 'PARAMETER_NAME'
690: ,p_token1_value => 'INTEREST_START_DATE'
691: ,p_token2 => 'CONTRACT_NUMBER'
692: ,p_token2_value => l_contract_number);
693: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
694: END IF;
695:
696: IF ((l_orig_rate_rec.PRINCIPAL_BASIS_CODE IS NOT NULL AND
697: l_orig_rate_rec.PRINCIPAL_BASIS_CODE <> G_MISS_CHAR) OR

Line 707: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

703: ,p_token1 => 'PARAMETER_NAME'
704: ,p_token1_value => 'PRINCIPAL_BASIS_CODE'
705: ,p_token2 => 'CONTRACT_NUMBER'
706: ,p_token2_value => l_contract_number);
707: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
708: END IF;
709:
710: IF ((l_orig_rate_rec.DAYS_IN_A_MONTH_CODE IS NOT NULL AND
711: l_orig_rate_rec.DAYS_IN_A_MONTH_CODE <> G_MISS_CHAR) OR

Line 721: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

717: ,p_token1 => 'PARAMETER_NAME'
718: ,p_token1_value => 'DAYS_IN_A_MONTH_CODE'
719: ,p_token2 => 'CONTRACT_NUMBER'
720: ,p_token2_value => l_contract_number);
721: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
722: END IF;
723:
724: IF ((l_orig_rate_rec.DAYS_IN_A_YEAR_CODE IS NOT NULL AND
725: l_orig_rate_rec.DAYS_IN_A_YEAR_CODE <> G_MISS_CHAR) OR

Line 735: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

731: ,p_token1 => 'PARAMETER_NAME'
732: ,p_token1_value => 'DAYS_IN_A_YEAR_CODE'
733: ,p_token2 => 'CONTRACT_NUMBER'
734: ,p_token2_value => l_contract_number);
735: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
736: END IF;
737:
738: IF ((l_orig_rate_rec.CATCHUP_START_DATE IS NOT NULL AND
739: l_orig_rate_rec.CATCHUP_START_DATE <> G_MISS_DATE) OR

Line 749: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

745: ,p_token1 => 'PARAMETER_NAME'
746: ,p_token1_value => 'CATCHUP_START_DATE'
747: ,p_token2 => 'CONTRACT_NUMBER'
748: ,p_token2_value => l_contract_number);
749: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
750: END IF;
751:
752: IF ((l_orig_rate_rec.CATCHUP_SETTLEMENT_CODE IS NOT NULL AND
753: l_orig_rate_rec.CATCHUP_SETTLEMENT_CODE <> G_MISS_CHAR) OR

Line 763: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

759: ,p_token1 => 'PARAMETER_NAME'
760: ,p_token1_value => 'CATCHUP_SETTLEMENT_CODE'
761: ,p_token2 => 'CONTRACT_NUMBER'
762: ,p_token2_value => l_contract_number);
763: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
764: END IF;
765:
766: IF ((l_orig_rate_rec.RATE_CHANGE_START_DATE IS NOT NULL AND
767: l_orig_rate_rec.RATE_CHANGE_START_DATE <> G_MISS_DATE) OR

Line 777: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

773: ,p_token1 => 'PARAMETER_NAME'
774: ,p_token1_value => 'RATE_CHANGE_START_DATE'
775: ,p_token2 => 'CONTRACT_NUMBER'
776: ,p_token2_value => l_contract_number);
777: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
778: END IF;
779: END IF; -- no_data
780: END IF; -- rebook_copy
781:

Line 853: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

849: IF (p_krpv_rec.EFFECTIVE_FROM_DATE < l_orig_rate_rec.EFFECTIVE_FROM_DATE) THEN
850: OKC_API.SET_MESSAGE(
851: p_app_name => G_APP_NAME
852: ,p_msg_name => 'OKL_LLA_VAR_RATE_EFF_DATE');
853: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
854: END IF;
855: ELSIF (l_deal_type IN ('LEASEOP', 'LEASEDF', 'LEASEST') AND
856: l_interest_calculation_basis = 'REAMORT' ) THEN
857: IF (p_krpv_rec.EFFECTIVE_FROM_DATE <= l_rebook_date) OR

Line 863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

859: THEN
860: OKC_API.SET_MESSAGE(
861: p_app_name => G_APP_NAME
862: ,p_msg_name => 'OKL_LLA_VAR_RATE_RBK_DATE');
863: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
864: END IF;
865: ELSIF ((l_deal_type = 'LOAN') AND
866: l_interest_calculation_basis IN
867: ('FIXED', 'FLOAT', 'CATCHUP/CLEANUP' )) THEN

Line 876: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

872: IF (p_krpv_rec.EFFECTIVE_FROM_DATE < l_orig_rate_rec.EFFECTIVE_FROM_DATE) THEN
873: OKC_API.SET_MESSAGE(
874: p_app_name => G_APP_NAME
875: ,p_msg_name => 'OKL_LLA_VAR_RATE_EFF_DATE');
876: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
877: END IF;
878: ELSIF (l_deal_type = 'LOAN' AND
879: l_interest_calculation_basis = 'REAMORT') THEN
880: IF (p_krpv_rec.EFFECTIVE_FROM_DATE <= l_rebook_date) OR

Line 886: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

882: THEN
883: OKC_API.SET_MESSAGE(
884: p_app_name => G_APP_NAME
885: ,p_msg_name => 'OKL_LLA_VAR_RATE_RBK_DATE');
886: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
887: END IF;
888: ELSIF (l_deal_type = 'LOAN-REVOLVING' AND
889: l_interest_calculation_basis = 'FLOAT') THEN
890: IF (p_krpv_rec.EFFECTIVE_FROM_DATE < l_orig_rate_rec.EFFECTIVE_FROM_DATE) THEN

Line 894: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

890: IF (p_krpv_rec.EFFECTIVE_FROM_DATE < l_orig_rate_rec.EFFECTIVE_FROM_DATE) THEN
891: OKC_API.SET_MESSAGE(
892: p_app_name => G_APP_NAME
893: ,p_msg_name => 'OKL_LLA_VAR_RATE_EFF_DATE');
894: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
895: END IF;
896: END IF; -- if deal_type
897: END IF; -- if any rate params changed
898:

Line 901: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

897: END IF; -- if any rate params changed
898:
899: END IF; -- if no_data
900:
901: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
902:
903: EXCEPTION
904: WHEN OKL_API.G_EXCEPTION_ERROR THEN
905: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 904: WHEN OKL_API.G_EXCEPTION_ERROR THEN

900:
901: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
902:
903: EXCEPTION
904: WHEN OKL_API.G_EXCEPTION_ERROR THEN
905: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
906: p_api_name => l_api_name,
907: p_pkg_name => g_pkg_name,
908: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 905: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

901: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
902:
903: EXCEPTION
904: WHEN OKL_API.G_EXCEPTION_ERROR THEN
905: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
906: p_api_name => l_api_name,
907: p_pkg_name => g_pkg_name,
908: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
909: x_msg_count => x_msg_count,

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

904: WHEN OKL_API.G_EXCEPTION_ERROR THEN
905: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
906: p_api_name => l_api_name,
907: p_pkg_name => g_pkg_name,
908: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
909: x_msg_count => x_msg_count,
910: x_msg_data => x_msg_data,
911: p_api_type => g_api_type);
912:

Line 913: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

909: x_msg_count => x_msg_count,
910: x_msg_data => x_msg_data,
911: p_api_type => g_api_type);
912:
913: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
914: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
915: p_api_name => l_api_name,
916: p_pkg_name => g_pkg_name,
917: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 914: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

910: x_msg_data => x_msg_data,
911: p_api_type => g_api_type);
912:
913: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
914: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
915: p_api_name => l_api_name,
916: p_pkg_name => g_pkg_name,
917: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
918: x_msg_count => x_msg_count,

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

913: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
914: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
915: p_api_name => l_api_name,
916: p_pkg_name => g_pkg_name,
917: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
918: x_msg_count => x_msg_count,
919: x_msg_data => x_msg_data,
920: p_api_type => g_api_type);
921:

Line 923: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

919: x_msg_data => x_msg_data,
920: p_api_type => g_api_type);
921:
922: WHEN OTHERS THEN
923: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
924: p_api_name => l_api_name,
925: p_pkg_name => g_pkg_name,
926: p_exc_name => 'OTHERS',
927: x_msg_count => x_msg_count,

Line 1016: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1012: l_last_billed_due_date DATE;
1013: --Bug# 7566308
1014: begin
1015:
1016: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1017:
1018: x_return_status := OKL_API.START_ACTIVITY(
1019: p_api_name => l_api_name,
1020: p_pkg_name => g_pkg_name,

Line 1018: x_return_status := OKL_API.START_ACTIVITY(

1014: begin
1015:
1016: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1017:
1018: x_return_status := OKL_API.START_ACTIVITY(
1019: p_api_name => l_api_name,
1020: p_pkg_name => g_pkg_name,
1021: p_init_msg_list => p_init_msg_list,
1022: l_api_version => l_api_version,

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

1045: x_msg_data => x_msg_data,
1046: p_krpv_rec => p_krpv_rec,
1047: p_orig_eff_from_date => l_effective_from_date);
1048:
1049: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1050: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1051: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1052: RAISE OKL_API.G_EXCEPTION_ERROR;
1053: END IF;

Line 1050: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1046: p_krpv_rec => p_krpv_rec,
1047: p_orig_eff_from_date => l_effective_from_date);
1048:
1049: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1050: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1051: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1052: RAISE OKL_API.G_EXCEPTION_ERROR;
1053: END IF;
1054:

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

1047: p_orig_eff_from_date => l_effective_from_date);
1048:
1049: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1050: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1051: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1052: RAISE OKL_API.G_EXCEPTION_ERROR;
1053: END IF;
1054:
1055: END IF;

Line 1052: RAISE OKL_API.G_EXCEPTION_ERROR;

1048:
1049: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1050: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1051: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1052: RAISE OKL_API.G_EXCEPTION_ERROR;
1053: END IF;
1054:
1055: END IF;
1056: --Bug# 7566308

Line 1076: RAISE OKL_API.G_EXCEPTION_ERROR;

1072:
1073: IF (l_rate_count > 0) THEN
1074: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
1075: ,p_msg_name => 'OKL_LLA_VAR_RATE_EXISTS');
1076: RAISE OKL_API.G_EXCEPTION_ERROR;
1077: END IF;
1078: END IF;
1079: --Bug# 7566308
1080:

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

1138: p_product_id => l_product_id,
1139: p_k_rate_tbl => l_k_rate_tbl,
1140: p_validate_flag => p_validate_flag);
1141:
1142: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1143: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1144: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1145: RAISE OKL_API.G_EXCEPTION_ERROR;
1146: END IF;

Line 1143: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1139: p_k_rate_tbl => l_k_rate_tbl,
1140: p_validate_flag => p_validate_flag);
1141:
1142: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1143: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1144: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1145: RAISE OKL_API.G_EXCEPTION_ERROR;
1146: END IF;
1147:

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

1140: p_validate_flag => p_validate_flag);
1141:
1142: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1143: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1144: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1145: RAISE OKL_API.G_EXCEPTION_ERROR;
1146: END IF;
1147:
1148: -- Bug 4722746

Line 1145: RAISE OKL_API.G_EXCEPTION_ERROR;

1141:
1142: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1143: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1144: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1145: RAISE OKL_API.G_EXCEPTION_ERROR;
1146: END IF;
1147:
1148: -- Bug 4722746
1149: IF (l_pdt_parameter_rec.interest_calculation_basis = 'CATCHUP/CLEANUP'

Line 1182: RAISE OKL_API.G_EXCEPTION_ERROR;

1178: OKC_API.set_message(p_app_name => G_APP_NAME,
1179: p_msg_name => G_REQUIRED_VALUE,
1180: p_token1 => G_COL_NAME_TOKEN,
1181: p_token1_value => 'CATCHUP FREQUENCY');
1182: RAISE OKL_API.G_EXCEPTION_ERROR;
1183: END IF;
1184:
1185: ELSE
1186: -- One of the four is not null

Line 1195: RAISE OKL_API.G_EXCEPTION_ERROR;

1191: OKC_API.set_message(p_app_name => G_APP_NAME,
1192: p_msg_name => G_REQUIRED_VALUE,
1193: p_token1 => G_COL_NAME_TOKEN,
1194: p_token1_value => 'Catchup Frequency');
1195: RAISE OKL_API.G_EXCEPTION_ERROR;
1196: END IF;
1197:
1198: --print('Catchup :2');
1199: IF (l_krpv_rec.catchup_start_date is NOT NULL AND

Line 1216: RAISE OKL_API.G_EXCEPTION_ERROR;

1212: OKC_API.set_message(p_app_name => G_APP_NAME,
1213: p_msg_name => G_REQUIRED_VALUE,
1214: p_token1 => G_COL_NAME_TOKEN,
1215: p_token1_value => 'Catchup Settlement');
1216: RAISE OKL_API.G_EXCEPTION_ERROR;
1217: END IF;
1218:
1219: --print('Catchup :4');
1220: IF (l_krpv_rec.catchup_basis_code is NOT NULL AND

Line 1228: RAISE OKL_API.G_EXCEPTION_ERROR;

1224: OKC_API.set_message(p_app_name => G_APP_NAME,
1225: p_msg_name => G_REQUIRED_VALUE,
1226: p_token1 => G_COL_NAME_TOKEN,
1227: p_token1_value => 'Catchup Basis');
1228: RAISE OKL_API.G_EXCEPTION_ERROR;
1229: END IF;
1230:
1231:
1232: END IF;

Line 1265: RAISE OKL_API.G_EXCEPTION_ERROR;

1261: p_token1 => 'EFF_DATE',
1262: p_token1_value => p_krpv_rec.effective_from_Date,
1263: p_token2 => 'INTEREST_DATE',
1264: p_token2_value => l_last_billed_due_date);
1265: RAISE OKL_API.G_EXCEPTION_ERROR;
1266: END IF;
1267: END IF;
1268:
1269: -- Bug 4999888

Line 1279: RAISE OKL_API.G_EXCEPTION_ERROR;

1275: p_token1 => 'EFF_DATE',
1276: p_token1_value => p_krpv_rec.effective_from_Date,
1277: p_token2 => 'INTEREST_DATE',
1278: p_token2_value => l_last_interest_cal_date);
1279: RAISE OKL_API.G_EXCEPTION_ERROR;
1280: END IF;
1281: END IF;
1282: END IF;
1283: END IF;

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

1324: END IF;
1325: --Bug# 7566308
1326: END IF;
1327:
1328: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1329: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1330: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1331: RAISE OKL_API.G_EXCEPTION_ERROR;
1332: END IF;

Line 1329: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1325: --Bug# 7566308
1326: END IF;
1327:
1328: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1329: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1330: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1331: RAISE OKL_API.G_EXCEPTION_ERROR;
1332: END IF;
1333:

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

1326: END IF;
1327:
1328: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1329: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1330: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1331: RAISE OKL_API.G_EXCEPTION_ERROR;
1332: END IF;
1333:
1334: okl_contract_status_pub.cascade_lease_status_edit

Line 1331: RAISE OKL_API.G_EXCEPTION_ERROR;

1327:
1328: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1329: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1330: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1331: RAISE OKL_API.G_EXCEPTION_ERROR;
1332: END IF;
1333:
1334: okl_contract_status_pub.cascade_lease_status_edit
1335: (p_api_version => p_api_version,

Line 1342: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

1338: x_msg_count => x_msg_count,
1339: x_msg_data => x_msg_data,
1340: p_chr_id => l_krpv_rec.khr_id);
1341:
1342: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1343: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1344: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1345: raise OKL_API.G_EXCEPTION_ERROR;
1346: End If;

Line 1343: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1339: x_msg_data => x_msg_data,
1340: p_chr_id => l_krpv_rec.khr_id);
1341:
1342: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1343: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1344: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1345: raise OKL_API.G_EXCEPTION_ERROR;
1346: End If;
1347:

Line 1344: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

1340: p_chr_id => l_krpv_rec.khr_id);
1341:
1342: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1343: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1344: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1345: raise OKL_API.G_EXCEPTION_ERROR;
1346: End If;
1347:
1348: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

Line 1345: raise OKL_API.G_EXCEPTION_ERROR;

1341:
1342: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
1343: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1344: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1345: raise OKL_API.G_EXCEPTION_ERROR;
1346: End If;
1347:
1348: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1349:

Line 1348: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

1344: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
1345: raise OKL_API.G_EXCEPTION_ERROR;
1346: End If;
1347:
1348: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1349:
1350: EXCEPTION
1351: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1352: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1351: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1347:
1348: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1349:
1350: EXCEPTION
1351: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1352: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1353: p_api_name => l_api_name,
1354: p_pkg_name => g_pkg_name,
1355: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1352: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1348: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1349:
1350: EXCEPTION
1351: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1352: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1353: p_api_name => l_api_name,
1354: p_pkg_name => g_pkg_name,
1355: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1356: x_msg_count => x_msg_count,

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

1351: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1352: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1353: p_api_name => l_api_name,
1354: p_pkg_name => g_pkg_name,
1355: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1356: x_msg_count => x_msg_count,
1357: x_msg_data => x_msg_data,
1358: p_api_type => g_api_type);
1359:

Line 1360: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1356: x_msg_count => x_msg_count,
1357: x_msg_data => x_msg_data,
1358: p_api_type => g_api_type);
1359:
1360: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1361: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1362: p_api_name => l_api_name,
1363: p_pkg_name => g_pkg_name,
1364: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1361: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1357: x_msg_data => x_msg_data,
1358: p_api_type => g_api_type);
1359:
1360: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1361: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1362: p_api_name => l_api_name,
1363: p_pkg_name => g_pkg_name,
1364: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1365: x_msg_count => x_msg_count,

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

1360: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1361: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1362: p_api_name => l_api_name,
1363: p_pkg_name => g_pkg_name,
1364: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1365: x_msg_count => x_msg_count,
1366: x_msg_data => x_msg_data,
1367: p_api_type => g_api_type);
1368:

Line 1370: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1366: x_msg_data => x_msg_data,
1367: p_api_type => g_api_type);
1368:
1369: WHEN OTHERS THEN
1370: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1371: p_api_name => l_api_name,
1372: p_pkg_name => g_pkg_name,
1373: p_exc_name => 'OTHERS',
1374: x_msg_count => x_msg_count,

Line 1399: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1395: l_count NUMBER;
1396:
1397: begin
1398:
1399: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1400:
1401: x_return_status := OKL_API.START_ACTIVITY(
1402: p_api_name => l_api_name,
1403: p_pkg_name => g_pkg_name,

Line 1401: x_return_status := OKL_API.START_ACTIVITY(

1397: begin
1398:
1399: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1400:
1401: x_return_status := OKL_API.START_ACTIVITY(
1402: p_api_name => l_api_name,
1403: p_pkg_name => g_pkg_name,
1404: p_init_msg_list => p_init_msg_list,
1405: l_api_version => l_api_version,

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

1447: l_krpv_rec,
1448: x_krpv_rec);
1449: END IF;
1450:
1451: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1452: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1453: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1454: RAISE OKL_API.G_EXCEPTION_ERROR;
1455: END IF;

Line 1452: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1448: x_krpv_rec);
1449: END IF;
1450:
1451: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1452: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1453: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1454: RAISE OKL_API.G_EXCEPTION_ERROR;
1455: END IF;
1456:

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

1449: END IF;
1450:
1451: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1452: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1453: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1454: RAISE OKL_API.G_EXCEPTION_ERROR;
1455: END IF;
1456:
1457: x_krpr_rec.khr_id := x_krpv_rec.khr_id;

Line 1454: RAISE OKL_API.G_EXCEPTION_ERROR;

1450:
1451: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1452: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1453: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1454: RAISE OKL_API.G_EXCEPTION_ERROR;
1455: END IF;
1456:
1457: x_krpr_rec.khr_id := x_krpv_rec.khr_id;
1458: x_krpr_rec.parameter_type_code := x_krpv_rec.parameter_type_code;

Line 1472: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

1468: x_krpr_rec.days_in_a_month_code := x_krpv_rec.days_in_a_month_code;
1469: x_krpr_rec.days_in_a_year_code := x_krpv_rec.days_in_a_year_code;
1470: x_krpr_rec.interest_basis_code := x_krpv_rec.interest_basis_code;
1471:
1472: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1473:
1474: EXCEPTION
1475: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1476: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1475: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1471:
1472: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1473:
1474: EXCEPTION
1475: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1476: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1477: p_api_name => l_api_name,
1478: p_pkg_name => g_pkg_name,
1479: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1476: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1472: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1473:
1474: EXCEPTION
1475: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1476: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1477: p_api_name => l_api_name,
1478: p_pkg_name => g_pkg_name,
1479: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1480: x_msg_count => x_msg_count,

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

1475: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1476: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1477: p_api_name => l_api_name,
1478: p_pkg_name => g_pkg_name,
1479: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1480: x_msg_count => x_msg_count,
1481: x_msg_data => x_msg_data,
1482: p_api_type => g_api_type);
1483:

Line 1484: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1480: x_msg_count => x_msg_count,
1481: x_msg_data => x_msg_data,
1482: p_api_type => g_api_type);
1483:
1484: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1485: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1486: p_api_name => l_api_name,
1487: p_pkg_name => g_pkg_name,
1488: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1485: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1481: x_msg_data => x_msg_data,
1482: p_api_type => g_api_type);
1483:
1484: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1485: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1486: p_api_name => l_api_name,
1487: p_pkg_name => g_pkg_name,
1488: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1489: x_msg_count => x_msg_count,

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

1484: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1485: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1486: p_api_name => l_api_name,
1487: p_pkg_name => g_pkg_name,
1488: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1489: x_msg_count => x_msg_count,
1490: x_msg_data => x_msg_data,
1491: p_api_type => g_api_type);
1492:

Line 1494: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1490: x_msg_data => x_msg_data,
1491: p_api_type => g_api_type);
1492:
1493: WHEN OTHERS THEN
1494: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1495: p_api_name => l_api_name,
1496: p_pkg_name => g_pkg_name,
1497: p_exc_name => 'OTHERS',
1498: x_msg_count => x_msg_count,

Line 1521: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1517: x_krpv_rec krpv_rec_type;
1518: l_count NUMBER;
1519:
1520: begin
1521: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1522:
1523: x_return_status := OKL_API.START_ACTIVITY(
1524: p_api_name => l_api_name,
1525: p_pkg_name => g_pkg_name,

Line 1523: x_return_status := OKL_API.START_ACTIVITY(

1519:
1520: begin
1521: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1522:
1523: x_return_status := OKL_API.START_ACTIVITY(
1524: p_api_name => l_api_name,
1525: p_pkg_name => g_pkg_name,
1526: p_init_msg_list => p_init_msg_list,
1527: l_api_version => l_api_version,

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

1569: l_krpv_rec,
1570: x_krpv_rec);
1571: END IF;
1572:
1573: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1574: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1575: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1576: RAISE OKL_API.G_EXCEPTION_ERROR;
1577: END IF;

Line 1574: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1570: x_krpv_rec);
1571: END IF;
1572:
1573: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1574: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1575: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1576: RAISE OKL_API.G_EXCEPTION_ERROR;
1577: END IF;
1578:

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

1571: END IF;
1572:
1573: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1574: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1575: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1576: RAISE OKL_API.G_EXCEPTION_ERROR;
1577: END IF;
1578:
1579: x_krpar_rec.khr_id := x_krpv_rec.khr_id;

Line 1576: RAISE OKL_API.G_EXCEPTION_ERROR;

1572:
1573: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1574: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1575: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1576: RAISE OKL_API.G_EXCEPTION_ERROR;
1577: END IF;
1578:
1579: x_krpar_rec.khr_id := x_krpv_rec.khr_id;
1580: x_krpar_rec.parameter_type_code := x_krpv_rec.parameter_type_code;

Line 1594: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

1590: x_krpar_rec.rate_change_start_date := x_krpv_rec.rate_change_start_date;
1591: x_krpar_rec.rate_change_frequency_code := x_krpv_rec.rate_change_frequency_code;
1592: x_krpar_rec.rate_change_value := x_krpv_rec.rate_change_value;
1593:
1594: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1595:
1596: EXCEPTION
1597: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1598: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1597: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1593:
1594: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1595:
1596: EXCEPTION
1597: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1598: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1599: p_api_name => l_api_name,
1600: p_pkg_name => g_pkg_name,
1601: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1598: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1594: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1595:
1596: EXCEPTION
1597: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1598: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1599: p_api_name => l_api_name,
1600: p_pkg_name => g_pkg_name,
1601: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1602: x_msg_count => x_msg_count,

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

1597: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1598: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1599: p_api_name => l_api_name,
1600: p_pkg_name => g_pkg_name,
1601: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1602: x_msg_count => x_msg_count,
1603: x_msg_data => x_msg_data,
1604: p_api_type => g_api_type);
1605:

Line 1606: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1602: x_msg_count => x_msg_count,
1603: x_msg_data => x_msg_data,
1604: p_api_type => g_api_type);
1605:
1606: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1607: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1608: p_api_name => l_api_name,
1609: p_pkg_name => g_pkg_name,
1610: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1607: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1603: x_msg_data => x_msg_data,
1604: p_api_type => g_api_type);
1605:
1606: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1607: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1608: p_api_name => l_api_name,
1609: p_pkg_name => g_pkg_name,
1610: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1611: x_msg_count => x_msg_count,

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

1606: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1607: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1608: p_api_name => l_api_name,
1609: p_pkg_name => g_pkg_name,
1610: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1611: x_msg_count => x_msg_count,
1612: x_msg_data => x_msg_data,
1613: p_api_type => g_api_type);
1614:

Line 1616: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1612: x_msg_data => x_msg_data,
1613: p_api_type => g_api_type);
1614:
1615: WHEN OTHERS THEN
1616: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1617: p_api_name => l_api_name,
1618: p_pkg_name => g_pkg_name,
1619: p_exc_name => 'OTHERS',
1620: x_msg_count => x_msg_count,

Line 1642: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1638: x_krpv_rec krpv_rec_type;
1639: l_count NUMBER;
1640:
1641: begin
1642: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1643:
1644: x_return_status := OKL_API.START_ACTIVITY(
1645: p_api_name => l_api_name,
1646: p_pkg_name => g_pkg_name,

Line 1644: x_return_status := OKL_API.START_ACTIVITY(

1640:
1641: begin
1642: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1643:
1644: x_return_status := OKL_API.START_ACTIVITY(
1645: p_api_name => l_api_name,
1646: p_pkg_name => g_pkg_name,
1647: p_init_msg_list => p_init_msg_list,
1648: l_api_version => l_api_version,

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

1683: l_krpv_rec,
1684: x_krpv_rec);
1685: END IF;
1686:
1687: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1688: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1689: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1690: RAISE OKL_API.G_EXCEPTION_ERROR;
1691: END IF;

Line 1688: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1684: x_krpv_rec);
1685: END IF;
1686:
1687: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1688: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1689: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1690: RAISE OKL_API.G_EXCEPTION_ERROR;
1691: END IF;
1692:

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

1685: END IF;
1686:
1687: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1688: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1689: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1690: RAISE OKL_API.G_EXCEPTION_ERROR;
1691: END IF;
1692:
1693: x_krpc_rec.khr_id := x_krpv_rec.khr_id;

Line 1690: RAISE OKL_API.G_EXCEPTION_ERROR;

1686:
1687: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1688: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1689: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1690: RAISE OKL_API.G_EXCEPTION_ERROR;
1691: END IF;
1692:
1693: x_krpc_rec.khr_id := x_krpv_rec.khr_id;
1694: x_krpc_rec.parameter_type_code := x_krpv_rec.parameter_type_code;

Line 1701: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

1697: x_krpc_rec.conversion_option_code := x_krpv_rec.conversion_option_code;
1698: x_krpc_rec.next_conversion_date := x_krpv_rec.next_conversion_date;
1699: x_krpc_rec.conversion_type_code := x_krpv_rec.conversion_type_code;
1700:
1701: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1702:
1703: EXCEPTION
1704: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1705: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 1704: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1700:
1701: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1702:
1703: EXCEPTION
1704: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1705: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1706: p_api_name => l_api_name,
1707: p_pkg_name => g_pkg_name,
1708: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 1705: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1701: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1702:
1703: EXCEPTION
1704: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1705: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1706: p_api_name => l_api_name,
1707: p_pkg_name => g_pkg_name,
1708: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1709: x_msg_count => x_msg_count,

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

1704: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1705: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1706: p_api_name => l_api_name,
1707: p_pkg_name => g_pkg_name,
1708: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1709: x_msg_count => x_msg_count,
1710: x_msg_data => x_msg_data,
1711: p_api_type => g_api_type);
1712:

Line 1713: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1709: x_msg_count => x_msg_count,
1710: x_msg_data => x_msg_data,
1711: p_api_type => g_api_type);
1712:
1713: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1714: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1715: p_api_name => l_api_name,
1716: p_pkg_name => g_pkg_name,
1717: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1714: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1710: x_msg_data => x_msg_data,
1711: p_api_type => g_api_type);
1712:
1713: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1714: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1715: p_api_name => l_api_name,
1716: p_pkg_name => g_pkg_name,
1717: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1718: x_msg_count => x_msg_count,

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

1713: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1714: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1715: p_api_name => l_api_name,
1716: p_pkg_name => g_pkg_name,
1717: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1718: x_msg_count => x_msg_count,
1719: x_msg_data => x_msg_data,
1720: p_api_type => g_api_type);
1721:

Line 1723: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

1719: x_msg_data => x_msg_data,
1720: p_api_type => g_api_type);
1721:
1722: WHEN OTHERS THEN
1723: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1724: p_api_name => l_api_name,
1725: p_pkg_name => g_pkg_name,
1726: p_exc_name => 'OTHERS',
1727: x_msg_count => x_msg_count,

Line 1778: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1774: l_contract_start_date DATE;
1775: l_krpv_tbl krpv_tbl_type;
1776: --l_k_rate_tbl krpv_tbl_type;
1777: begin
1778: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1779:
1780: x_return_status := OKL_API.START_ACTIVITY(
1781: p_api_name => l_api_name,
1782: p_pkg_name => g_pkg_name,

Line 1780: x_return_status := OKL_API.START_ACTIVITY(

1776: --l_k_rate_tbl krpv_tbl_type;
1777: begin
1778: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1779:
1780: x_return_status := OKL_API.START_ACTIVITY(
1781: p_api_name => l_api_name,
1782: p_pkg_name => g_pkg_name,
1783: p_init_msg_list => p_init_msg_list,
1784: l_api_version => l_api_version,

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

1800: p_khr_id => p_krpv_rec.khr_id,
1801: x_product_id => l_product_id,
1802: x_pdt_parameter_rec => l_pdt_parameter_rec);
1803:
1804: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1805: RAISE OKL_API.G_EXCEPTION_ERROR;
1806: END IF;
1807:
1808: l_deal_type := l_pdt_parameter_rec.deal_type;

Line 1805: RAISE OKL_API.G_EXCEPTION_ERROR;

1801: x_product_id => l_product_id,
1802: x_pdt_parameter_rec => l_pdt_parameter_rec);
1803:
1804: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1805: RAISE OKL_API.G_EXCEPTION_ERROR;
1806: END IF;
1807:
1808: l_deal_type := l_pdt_parameter_rec.deal_type;
1809: l_interest_calculation_basis := l_pdt_parameter_rec.interest_calculation_basis;

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

1819: x_msg_count => x_msg_count,
1820: x_msg_data => x_msg_data,
1821: p_krpv_rec => p_krpv_rec);
1822:
1823: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1824: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1825: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1826: RAISE OKL_API.G_EXCEPTION_ERROR;
1827: END IF;

Line 1824: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1820: x_msg_data => x_msg_data,
1821: p_krpv_rec => p_krpv_rec);
1822:
1823: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1824: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1825: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1826: RAISE OKL_API.G_EXCEPTION_ERROR;
1827: END IF;
1828: END IF;

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

1821: p_krpv_rec => p_krpv_rec);
1822:
1823: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1824: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1825: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1826: RAISE OKL_API.G_EXCEPTION_ERROR;
1827: END IF;
1828: END IF;
1829: --Bug# 7566308

Line 1826: RAISE OKL_API.G_EXCEPTION_ERROR;

1822:
1823: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1824: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1825: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1826: RAISE OKL_API.G_EXCEPTION_ERROR;
1827: END IF;
1828: END IF;
1829: --Bug# 7566308
1830:

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

1879: p_product_id => l_product_id,
1880: p_k_rate_tbl => l_krpv_tbl,
1881: p_validate_flag => 'F');
1882:
1883: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1884: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1885: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1886: RAISE OKL_API.G_EXCEPTION_ERROR;
1887: END IF;

Line 1884: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1880: p_k_rate_tbl => l_krpv_tbl,
1881: p_validate_flag => 'F');
1882:
1883: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1884: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1885: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1886: RAISE OKL_API.G_EXCEPTION_ERROR;
1887: END IF;
1888:

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

1881: p_validate_flag => 'F');
1882:
1883: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1884: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1885: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1886: RAISE OKL_API.G_EXCEPTION_ERROR;
1887: END IF;
1888:
1889: -- Bug 4722746

Line 1886: RAISE OKL_API.G_EXCEPTION_ERROR;

1882:
1883: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1884: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1885: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1886: RAISE OKL_API.G_EXCEPTION_ERROR;
1887: END IF;
1888:
1889: -- Bug 4722746
1890: IF (l_pdt_parameter_rec.interest_calculation_basis = 'CATCHUP/CLEANUP'

Line 1925: RAISE OKL_API.G_EXCEPTION_ERROR;

1921: OKC_API.set_message(p_app_name => G_APP_NAME,
1922: p_msg_name => G_REQUIRED_VALUE,
1923: p_token1 => G_COL_NAME_TOKEN,
1924: p_token1_value => 'CATCHUP FREQUENCY');
1925: RAISE OKL_API.G_EXCEPTION_ERROR;
1926: END IF;
1927:
1928: ELSE
1929: -- One of the four is not null

Line 1941: RAISE OKL_API.G_EXCEPTION_ERROR;

1937: OKC_API.set_message(p_app_name => G_APP_NAME,
1938: p_msg_name => G_REQUIRED_VALUE,
1939: p_token1 => G_COL_NAME_TOKEN,
1940: p_token1_value => 'Catchup Frequency');
1941: RAISE OKL_API.G_EXCEPTION_ERROR;
1942: END IF;
1943:
1944: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1945: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Catchup :6');

Line 1966: RAISE OKL_API.G_EXCEPTION_ERROR;

1962: OKC_API.set_message(p_app_name => G_APP_NAME,
1963: p_msg_name => G_REQUIRED_VALUE,
1964: p_token1 => G_COL_NAME_TOKEN,
1965: p_token1_value => 'Catchup Settlement');
1966: RAISE OKL_API.G_EXCEPTION_ERROR;
1967: END IF;
1968:
1969: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
1970: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Catchup :8');

Line 1980: RAISE OKL_API.G_EXCEPTION_ERROR;

1976: OKC_API.set_message(p_app_name => G_APP_NAME,
1977: p_msg_name => G_REQUIRED_VALUE,
1978: p_token1 => G_COL_NAME_TOKEN,
1979: p_token1_value => 'Catchup Basis');
1980: RAISE OKL_API.G_EXCEPTION_ERROR;
1981: END IF;
1982:
1983:
1984: END IF;

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

1999:
2000: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2001: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After update_row() finished');
2002: END IF;
2003: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2004: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2005: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2006: RAISE OKL_API.G_EXCEPTION_ERROR;
2007: END IF;

Line 2004: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2000: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2001: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After update_row() finished');
2002: END IF;
2003: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2004: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2005: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2006: RAISE OKL_API.G_EXCEPTION_ERROR;
2007: END IF;
2008:

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

2001: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After update_row() finished');
2002: END IF;
2003: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2004: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2005: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2006: RAISE OKL_API.G_EXCEPTION_ERROR;
2007: END IF;
2008:
2009: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 2006: RAISE OKL_API.G_EXCEPTION_ERROR;

2002: END IF;
2003: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2004: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2005: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2006: RAISE OKL_API.G_EXCEPTION_ERROR;
2007: END IF;
2008:
2009: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2010: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Before calling cascade_lease_status_update...');

Line 2020: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

2016: x_msg_count => x_msg_count,
2017: x_msg_data => x_msg_data,
2018: p_chr_id => l_krpv_rec.khr_id);
2019:
2020: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
2021: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2022: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
2023: raise OKL_API.G_EXCEPTION_ERROR;
2024: End If;

Line 2021: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2017: x_msg_data => x_msg_data,
2018: p_chr_id => l_krpv_rec.khr_id);
2019:
2020: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
2021: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2022: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
2023: raise OKL_API.G_EXCEPTION_ERROR;
2024: End If;
2025: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 2022: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

2018: p_chr_id => l_krpv_rec.khr_id);
2019:
2020: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
2021: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2022: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
2023: raise OKL_API.G_EXCEPTION_ERROR;
2024: End If;
2025: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2026: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After cascade_lease_status_update finished ...');

Line 2023: raise OKL_API.G_EXCEPTION_ERROR;

2019:
2020: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
2021: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2022: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
2023: raise OKL_API.G_EXCEPTION_ERROR;
2024: End If;
2025: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2026: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After cascade_lease_status_update finished ...');
2027: END IF;

Line 2029: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

2025: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2026: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'After cascade_lease_status_update finished ...');
2027: END IF;
2028:
2029: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
2030:
2031: EXCEPTION
2032: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2033: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2032: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2028:
2029: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
2030:
2031: EXCEPTION
2032: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2033: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2034: p_api_name => l_api_name,
2035: p_pkg_name => g_pkg_name,
2036: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2033: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2029: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
2030:
2031: EXCEPTION
2032: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2033: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2034: p_api_name => l_api_name,
2035: p_pkg_name => g_pkg_name,
2036: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2037: x_msg_count => x_msg_count,

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

2032: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2033: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2034: p_api_name => l_api_name,
2035: p_pkg_name => g_pkg_name,
2036: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2037: x_msg_count => x_msg_count,
2038: x_msg_data => x_msg_data,
2039: p_api_type => g_api_type);
2040:

Line 2041: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2037: x_msg_count => x_msg_count,
2038: x_msg_data => x_msg_data,
2039: p_api_type => g_api_type);
2040:
2041: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2042: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2043: p_api_name => l_api_name,
2044: p_pkg_name => g_pkg_name,
2045: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2042: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2038: x_msg_data => x_msg_data,
2039: p_api_type => g_api_type);
2040:
2041: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2042: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2043: p_api_name => l_api_name,
2044: p_pkg_name => g_pkg_name,
2045: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2046: x_msg_count => x_msg_count,

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

2041: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2042: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2043: p_api_name => l_api_name,
2044: p_pkg_name => g_pkg_name,
2045: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2046: x_msg_count => x_msg_count,
2047: x_msg_data => x_msg_data,
2048: p_api_type => g_api_type);
2049:

Line 2051: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2047: x_msg_data => x_msg_data,
2048: p_api_type => g_api_type);
2049:
2050: WHEN OTHERS THEN
2051: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2052: p_api_name => l_api_name,
2053: p_pkg_name => g_pkg_name,
2054: p_exc_name => 'OTHERS',
2055: x_msg_count => x_msg_count,

Line 2077: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2073: x_krpv_rec krpv_rec_type;
2074: l_count NUMBER;
2075:
2076: begin
2077: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2078:
2079: x_return_status := OKL_API.START_ACTIVITY(
2080: p_api_name => l_api_name,
2081: p_pkg_name => g_pkg_name,

Line 2079: x_return_status := OKL_API.START_ACTIVITY(

2075:
2076: begin
2077: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2078:
2079: x_return_status := OKL_API.START_ACTIVITY(
2080: p_api_name => l_api_name,
2081: p_pkg_name => g_pkg_name,
2082: p_init_msg_list => p_init_msg_list,
2083: l_api_version => l_api_version,

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

2108: x_msg_data,
2109: l_krpv_rec,
2110: x_krpv_rec);
2111:
2112: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2113: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2114: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2115: RAISE OKL_API.G_EXCEPTION_ERROR;
2116: END IF;

Line 2113: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2109: l_krpv_rec,
2110: x_krpv_rec);
2111:
2112: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2113: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2114: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2115: RAISE OKL_API.G_EXCEPTION_ERROR;
2116: END IF;
2117:

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

2110: x_krpv_rec);
2111:
2112: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2113: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2114: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2115: RAISE OKL_API.G_EXCEPTION_ERROR;
2116: END IF;
2117:
2118: x_krpr_rec.khr_id := x_krpv_rec.khr_id;

Line 2115: RAISE OKL_API.G_EXCEPTION_ERROR;

2111:
2112: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2113: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2114: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2115: RAISE OKL_API.G_EXCEPTION_ERROR;
2116: END IF;
2117:
2118: x_krpr_rec.khr_id := x_krpv_rec.khr_id;
2119: x_krpr_rec.parameter_type_code := x_krpv_rec.parameter_type_code;

Line 2133: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

2129: x_krpr_rec.days_in_a_month_code := x_krpv_rec.days_in_a_month_code;
2130: x_krpr_rec.days_in_a_year_code := x_krpv_rec.days_in_a_year_code;
2131: x_krpr_rec.interest_basis_code := x_krpv_rec.interest_basis_code;
2132:
2133: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
2134:
2135: EXCEPTION
2136: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2137: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2136: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2132:
2133: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
2134:
2135: EXCEPTION
2136: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2137: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2138: p_api_name => l_api_name,
2139: p_pkg_name => g_pkg_name,
2140: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2137: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2133: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
2134:
2135: EXCEPTION
2136: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2137: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2138: p_api_name => l_api_name,
2139: p_pkg_name => g_pkg_name,
2140: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2141: x_msg_count => x_msg_count,

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

2136: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2137: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2138: p_api_name => l_api_name,
2139: p_pkg_name => g_pkg_name,
2140: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2141: x_msg_count => x_msg_count,
2142: x_msg_data => x_msg_data,
2143: p_api_type => g_api_type);
2144:

Line 2145: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2141: x_msg_count => x_msg_count,
2142: x_msg_data => x_msg_data,
2143: p_api_type => g_api_type);
2144:
2145: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2146: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2147: p_api_name => l_api_name,
2148: p_pkg_name => g_pkg_name,
2149: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2146: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2142: x_msg_data => x_msg_data,
2143: p_api_type => g_api_type);
2144:
2145: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2146: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2147: p_api_name => l_api_name,
2148: p_pkg_name => g_pkg_name,
2149: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2150: x_msg_count => x_msg_count,

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

2145: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2146: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2147: p_api_name => l_api_name,
2148: p_pkg_name => g_pkg_name,
2149: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2150: x_msg_count => x_msg_count,
2151: x_msg_data => x_msg_data,
2152: p_api_type => g_api_type);
2153:

Line 2155: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2151: x_msg_data => x_msg_data,
2152: p_api_type => g_api_type);
2153:
2154: WHEN OTHERS THEN
2155: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2156: p_api_name => l_api_name,
2157: p_pkg_name => g_pkg_name,
2158: p_exc_name => 'OTHERS',
2159: x_msg_count => x_msg_count,

Line 2181: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2177: x_krpv_rec krpv_rec_type;
2178: l_count NUMBER;
2179:
2180: begin
2181: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2182:
2183: x_return_status := OKL_API.START_ACTIVITY(
2184: p_api_name => l_api_name,
2185: p_pkg_name => g_pkg_name,

Line 2183: x_return_status := OKL_API.START_ACTIVITY(

2179:
2180: begin
2181: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2182:
2183: x_return_status := OKL_API.START_ACTIVITY(
2184: p_api_name => l_api_name,
2185: p_pkg_name => g_pkg_name,
2186: p_init_msg_list => p_init_msg_list,
2187: l_api_version => l_api_version,

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

2212: x_msg_data,
2213: l_krpv_rec,
2214: x_krpv_rec);
2215:
2216: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2218: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2219: RAISE OKL_API.G_EXCEPTION_ERROR;
2220: END IF;

Line 2217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2213: l_krpv_rec,
2214: x_krpv_rec);
2215:
2216: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2218: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2219: RAISE OKL_API.G_EXCEPTION_ERROR;
2220: END IF;
2221:

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

2214: x_krpv_rec);
2215:
2216: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2218: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2219: RAISE OKL_API.G_EXCEPTION_ERROR;
2220: END IF;
2221:
2222: x_krpar_rec.khr_id := x_krpv_rec.khr_id;

Line 2219: RAISE OKL_API.G_EXCEPTION_ERROR;

2215:
2216: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2217: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2218: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2219: RAISE OKL_API.G_EXCEPTION_ERROR;
2220: END IF;
2221:
2222: x_krpar_rec.khr_id := x_krpv_rec.khr_id;
2223: x_krpar_rec.parameter_type_code := x_krpv_rec.parameter_type_code;

Line 2237: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

2233: x_krpar_rec.rate_change_start_date := x_krpv_rec.rate_change_start_date;
2234: x_krpar_rec.rate_change_frequency_code := x_krpv_rec.rate_change_frequency_code;
2235: x_krpar_rec.rate_change_value := x_krpv_rec.rate_change_value;
2236:
2237: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
2238:
2239: EXCEPTION
2240: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2241: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2240: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2236:
2237: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
2238:
2239: EXCEPTION
2240: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2241: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2242: p_api_name => l_api_name,
2243: p_pkg_name => g_pkg_name,
2244: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2241: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2237: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
2238:
2239: EXCEPTION
2240: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2241: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2242: p_api_name => l_api_name,
2243: p_pkg_name => g_pkg_name,
2244: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2245: x_msg_count => x_msg_count,

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

2240: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2241: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2242: p_api_name => l_api_name,
2243: p_pkg_name => g_pkg_name,
2244: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2245: x_msg_count => x_msg_count,
2246: x_msg_data => x_msg_data,
2247: p_api_type => g_api_type);
2248:

Line 2249: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2245: x_msg_count => x_msg_count,
2246: x_msg_data => x_msg_data,
2247: p_api_type => g_api_type);
2248:
2249: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2250: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2251: p_api_name => l_api_name,
2252: p_pkg_name => g_pkg_name,
2253: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2250: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2246: x_msg_data => x_msg_data,
2247: p_api_type => g_api_type);
2248:
2249: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2250: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2251: p_api_name => l_api_name,
2252: p_pkg_name => g_pkg_name,
2253: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2254: x_msg_count => x_msg_count,

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

2249: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2250: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2251: p_api_name => l_api_name,
2252: p_pkg_name => g_pkg_name,
2253: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2254: x_msg_count => x_msg_count,
2255: x_msg_data => x_msg_data,
2256: p_api_type => g_api_type);
2257:

Line 2259: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2255: x_msg_data => x_msg_data,
2256: p_api_type => g_api_type);
2257:
2258: WHEN OTHERS THEN
2259: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2260: p_api_name => l_api_name,
2261: p_pkg_name => g_pkg_name,
2262: p_exc_name => 'OTHERS',
2263: x_msg_count => x_msg_count,

Line 2285: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2281: x_krpv_rec krpv_rec_type;
2282: l_count NUMBER;
2283:
2284: begin
2285: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2286:
2287: x_return_status := OKL_API.START_ACTIVITY(
2288: p_api_name => l_api_name,
2289: p_pkg_name => g_pkg_name,

Line 2287: x_return_status := OKL_API.START_ACTIVITY(

2283:
2284: begin
2285: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2286:
2287: x_return_status := OKL_API.START_ACTIVITY(
2288: p_api_name => l_api_name,
2289: p_pkg_name => g_pkg_name,
2290: p_init_msg_list => p_init_msg_list,
2291: l_api_version => l_api_version,

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

2309: x_msg_data,
2310: l_krpv_rec,
2311: x_krpv_rec);
2312:
2313: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2314: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2315: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2316: RAISE OKL_API.G_EXCEPTION_ERROR;
2317: END IF;

Line 2314: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2310: l_krpv_rec,
2311: x_krpv_rec);
2312:
2313: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2314: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2315: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2316: RAISE OKL_API.G_EXCEPTION_ERROR;
2317: END IF;
2318:

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

2311: x_krpv_rec);
2312:
2313: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2314: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2315: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2316: RAISE OKL_API.G_EXCEPTION_ERROR;
2317: END IF;
2318:
2319: x_krpc_rec.khr_id := x_krpv_rec.khr_id;

Line 2316: RAISE OKL_API.G_EXCEPTION_ERROR;

2312:
2313: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2314: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2315: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2316: RAISE OKL_API.G_EXCEPTION_ERROR;
2317: END IF;
2318:
2319: x_krpc_rec.khr_id := x_krpv_rec.khr_id;
2320: x_krpc_rec.parameter_type_code := x_krpv_rec.parameter_type_code;

Line 2327: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

2323: x_krpc_rec.conversion_option_code := x_krpv_rec.conversion_option_code;
2324: x_krpc_rec.next_conversion_date := x_krpv_rec.next_conversion_date;
2325: x_krpc_rec.conversion_type_code := x_krpv_rec.conversion_type_code;
2326:
2327: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
2328:
2329: EXCEPTION
2330: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2331: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2330: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2326:
2327: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
2328:
2329: EXCEPTION
2330: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2331: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2332: p_api_name => l_api_name,
2333: p_pkg_name => g_pkg_name,
2334: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2331: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2327: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
2328:
2329: EXCEPTION
2330: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2331: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2332: p_api_name => l_api_name,
2333: p_pkg_name => g_pkg_name,
2334: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2335: x_msg_count => x_msg_count,

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

2330: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2331: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2332: p_api_name => l_api_name,
2333: p_pkg_name => g_pkg_name,
2334: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2335: x_msg_count => x_msg_count,
2336: x_msg_data => x_msg_data,
2337: p_api_type => g_api_type);
2338:

Line 2339: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2335: x_msg_count => x_msg_count,
2336: x_msg_data => x_msg_data,
2337: p_api_type => g_api_type);
2338:
2339: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2340: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2341: p_api_name => l_api_name,
2342: p_pkg_name => g_pkg_name,
2343: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2340: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2336: x_msg_data => x_msg_data,
2337: p_api_type => g_api_type);
2338:
2339: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2340: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2341: p_api_name => l_api_name,
2342: p_pkg_name => g_pkg_name,
2343: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2344: x_msg_count => x_msg_count,

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

2339: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2340: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2341: p_api_name => l_api_name,
2342: p_pkg_name => g_pkg_name,
2343: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2344: x_msg_count => x_msg_count,
2345: x_msg_data => x_msg_data,
2346: p_api_type => g_api_type);
2347:

Line 2349: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2345: x_msg_data => x_msg_data,
2346: p_api_type => g_api_type);
2347:
2348: WHEN OTHERS THEN
2349: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2350: p_api_name => l_api_name,
2351: p_pkg_name => g_pkg_name,
2352: p_exc_name => 'OTHERS',
2353: x_msg_count => x_msg_count,

Line 2406: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2402: l_orig_effective_from_date DATE;
2403: l_del_count NUMBER := 0; -- Bug 4874280
2404: l_khr_id NUMBER;
2405: begin
2406: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2407:
2408: x_return_status := OKL_API.START_ACTIVITY(
2409: p_api_name => l_api_name,
2410: p_pkg_name => g_pkg_name,

Line 2408: x_return_status := OKL_API.START_ACTIVITY(

2404: l_khr_id NUMBER;
2405: begin
2406: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2407:
2408: x_return_status := OKL_API.START_ACTIVITY(
2409: p_api_name => l_api_name,
2410: p_pkg_name => g_pkg_name,
2411: p_init_msg_list => p_init_msg_list,
2412: l_api_version => l_api_version,

Line 2439: RAISE OKL_API.G_EXCEPTION_ERROR;

2435: l_parameter_type_code := 'CONVERSION';
2436: ELSE
2437: OKC_API.set_message(p_app_name => G_APP_NAME,
2438: p_msg_name => 'OKL_LLA_VAR_RATE_INV_PARAM');
2439: RAISE OKL_API.G_EXCEPTION_ERROR;
2440: END IF;
2441:
2442: FOR r IN get_effective_to_date_csr(
2443: p_krpdel_tbl(i).khr_id,

Line 2460: RAISE OKL_API.G_EXCEPTION_ERROR;

2456: END IF;
2457: IF (l_effective_to_date IS NOT NULL) THEN
2458: OKC_API.set_message(p_app_name => G_APP_NAME,
2459: p_msg_name => 'OKL_LLA_VAR_RATE_DELETE_ERR');
2460: RAISE OKL_API.G_EXCEPTION_ERROR;
2461: END IF;
2462:
2463: --Bug# 7440232
2464: IF (l_sts_code = 'BOOKED') THEN

Line 2467: RAISE OKL_API.G_EXCEPTION_ERROR;

2463: --Bug# 7440232
2464: IF (l_sts_code = 'BOOKED') THEN
2465: OKC_API.set_message(p_app_name => G_APP_NAME,
2466: p_msg_name => 'OKL_LLA_VAR_RATE_DELETE_ERR1');
2467: RAISE OKL_API.G_EXCEPTION_ERROR;
2468: END IF;
2469:
2470: IF (l_orig_system_source_code = 'OKL_REBOOK') THEN
2471:

Line 2491: RAISE OKL_API.G_EXCEPTION_ERROR;

2487: IF (l_orig_effective_from_date =
2488: p_krpdel_tbl(i).effective_from_date) THEN
2489: OKC_API.set_message(p_app_name => G_APP_NAME,
2490: p_msg_name => 'OKL_LLA_VAR_RATE_DELETE_ERR2');
2491: RAISE OKL_API.G_EXCEPTION_ERROR;
2492: END IF;
2493:
2494: /*UPDATE OKL_K_RATE_PARAMS
2495: SET EFFECTIVE_TO_DATE = NULL

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

2648: x_msg_count,
2649: x_msg_data,
2650: l_krpv_rec2);
2651:
2652: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2653: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2654: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2655: RAISE OKL_API.G_EXCEPTION_ERROR;
2656: END IF;

Line 2653: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2649: x_msg_data,
2650: l_krpv_rec2);
2651:
2652: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2653: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2654: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2655: RAISE OKL_API.G_EXCEPTION_ERROR;
2656: END IF;
2657:

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

2650: l_krpv_rec2);
2651:
2652: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2653: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2654: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2655: RAISE OKL_API.G_EXCEPTION_ERROR;
2656: END IF;
2657:
2658: IF (l_orig_system_source_code = 'OKL_REBOOK') THEN

Line 2655: RAISE OKL_API.G_EXCEPTION_ERROR;

2651:
2652: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2653: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2654: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2655: RAISE OKL_API.G_EXCEPTION_ERROR;
2656: END IF;
2657:
2658: IF (l_orig_system_source_code = 'OKL_REBOOK') THEN
2659:

Line 2675: RAISE OKL_API.G_EXCEPTION_ERROR;

2671: IF (l_orig_effective_from_date =
2672: p_krpdel_tbl(i).effective_from_date) THEN
2673: OKC_API.set_message(p_app_name => G_APP_NAME,
2674: p_msg_name => 'OKL_LA_VAR_RATE_DELETE_ERR2');
2675: RAISE OKL_API.G_EXCEPTION_ERROR;
2676: END IF;*/
2677:
2678: UPDATE OKL_K_RATE_PARAMS
2679: SET EFFECTIVE_TO_DATE = NULL

Line 2703: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then

2699: x_msg_count => x_msg_count,
2700: x_msg_data => x_msg_data,
2701: p_chr_id => l_khr_id);
2702:
2703: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
2704: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2705: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
2706: raise OKL_API.G_EXCEPTION_ERROR;
2707: End If;

Line 2704: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2700: x_msg_data => x_msg_data,
2701: p_chr_id => l_khr_id);
2702:
2703: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
2704: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2705: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
2706: raise OKL_API.G_EXCEPTION_ERROR;
2707: End If;
2708: END IF;

Line 2705: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then

2701: p_chr_id => l_khr_id);
2702:
2703: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
2704: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2705: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
2706: raise OKL_API.G_EXCEPTION_ERROR;
2707: End If;
2708: END IF;
2709:

Line 2706: raise OKL_API.G_EXCEPTION_ERROR;

2702:
2703: If x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR Then
2704: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2705: Elsif x_return_status = OKL_API.G_RET_STS_ERROR Then
2706: raise OKL_API.G_EXCEPTION_ERROR;
2707: End If;
2708: END IF;
2709:
2710: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

Line 2710: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

2706: raise OKL_API.G_EXCEPTION_ERROR;
2707: End If;
2708: END IF;
2709:
2710: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
2711:
2712: EXCEPTION
2713: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2714: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 2713: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2709:
2710: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
2711:
2712: EXCEPTION
2713: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2714: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2715: p_api_name => l_api_name,
2716: p_pkg_name => g_pkg_name,
2717: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 2714: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2710: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
2711:
2712: EXCEPTION
2713: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2714: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2715: p_api_name => l_api_name,
2716: p_pkg_name => g_pkg_name,
2717: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2718: x_msg_count => x_msg_count,

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

2713: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2714: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2715: p_api_name => l_api_name,
2716: p_pkg_name => g_pkg_name,
2717: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2718: x_msg_count => x_msg_count,
2719: x_msg_data => x_msg_data,
2720: p_api_type => g_api_type);
2721:

Line 2722: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2718: x_msg_count => x_msg_count,
2719: x_msg_data => x_msg_data,
2720: p_api_type => g_api_type);
2721:
2722: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2723: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2724: p_api_name => l_api_name,
2725: p_pkg_name => g_pkg_name,
2726: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 2723: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2719: x_msg_data => x_msg_data,
2720: p_api_type => g_api_type);
2721:
2722: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2723: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2724: p_api_name => l_api_name,
2725: p_pkg_name => g_pkg_name,
2726: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2727: x_msg_count => x_msg_count,

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

2722: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2723: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2724: p_api_name => l_api_name,
2725: p_pkg_name => g_pkg_name,
2726: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2727: x_msg_count => x_msg_count,
2728: x_msg_data => x_msg_data,
2729: p_api_type => g_api_type);
2730:

Line 2732: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

2728: x_msg_data => x_msg_data,
2729: p_api_type => g_api_type);
2730:
2731: WHEN OTHERS THEN
2732: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
2733: p_api_name => l_api_name,
2734: p_pkg_name => g_pkg_name,
2735: p_exc_name => 'OTHERS',
2736: x_msg_count => x_msg_count,

Line 2835: x_return_status := OKL_API.START_ACTIVITY(

2831: l_deal_type VARCHAR2(30);
2832: l_interest_calculation_basis VARCHAR2(30);
2833: l_revenue_recognition_method VARCHAR2(30);
2834: begin
2835: x_return_status := OKL_API.START_ACTIVITY(
2836: p_api_name => l_api_name,
2837: p_pkg_name => g_pkg_name,
2838: p_init_msg_list => p_init_msg_list,
2839: l_api_version => l_api_version,

Line 2847: x_return_status := OKL_API.G_RET_STS_SUCCESS;

2843:
2844: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
2845: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In validate_k_rate_params QA checker' || to_char(sysdate,'HH24:MI:SS') || ' with p_khr_id= ' || p_khr_id || ' ...');
2846: END IF;
2847: x_return_status := OKL_API.G_RET_STS_SUCCESS;
2848: OPEN l_hdr_csr(p_khr_id);
2849: FETCH l_hdr_csr INTO l_hdr_rec;
2850: IF l_hdr_csr%NOTFOUND THEN
2851: CLOSE l_hdr_csr;

Line 2852: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2848: OPEN l_hdr_csr(p_khr_id);
2849: FETCH l_hdr_csr INTO l_hdr_rec;
2850: IF l_hdr_csr%NOTFOUND THEN
2851: CLOSE l_hdr_csr;
2852: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2853: END IF;
2854: CLOSE l_hdr_csr;
2855:
2856: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

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

2868: p_pdtv_rec => p_pdtv_rec,
2869: x_no_data_found => x_no_data_found,
2870: p_pdt_parameter_rec => x_pdt_parameter_rec);
2871:
2872: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2873: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2874: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2875: RAISE OKL_API.G_EXCEPTION_ERROR;
2876: ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN

Line 2873: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2869: x_no_data_found => x_no_data_found,
2870: p_pdt_parameter_rec => x_pdt_parameter_rec);
2871:
2872: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2873: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2874: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2875: RAISE OKL_API.G_EXCEPTION_ERROR;
2876: ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN
2877: x_return_status := OKL_API.G_RET_STS_ERROR;

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

2870: p_pdt_parameter_rec => x_pdt_parameter_rec);
2871:
2872: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2873: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2874: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2875: RAISE OKL_API.G_EXCEPTION_ERROR;
2876: ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN
2877: x_return_status := OKL_API.G_RET_STS_ERROR;
2878: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 2875: RAISE OKL_API.G_EXCEPTION_ERROR;

2871:
2872: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2873: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2874: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2875: RAISE OKL_API.G_EXCEPTION_ERROR;
2876: ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN
2877: x_return_status := OKL_API.G_RET_STS_ERROR;
2878: RAISE OKL_API.G_EXCEPTION_ERROR;
2879: END IF;

Line 2876: ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN

2872: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2873: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2874: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2875: RAISE OKL_API.G_EXCEPTION_ERROR;
2876: ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN
2877: x_return_status := OKL_API.G_RET_STS_ERROR;
2878: RAISE OKL_API.G_EXCEPTION_ERROR;
2879: END IF;
2880:

Line 2877: x_return_status := OKL_API.G_RET_STS_ERROR;

2873: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2874: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2875: RAISE OKL_API.G_EXCEPTION_ERROR;
2876: ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN
2877: x_return_status := OKL_API.G_RET_STS_ERROR;
2878: RAISE OKL_API.G_EXCEPTION_ERROR;
2879: END IF;
2880:
2881: --print('Product_subclass=' || x_pdt_parameter_rec.product_subclass);

Line 2878: RAISE OKL_API.G_EXCEPTION_ERROR;

2874: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2875: RAISE OKL_API.G_EXCEPTION_ERROR;
2876: ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN
2877: x_return_status := OKL_API.G_RET_STS_ERROR;
2878: RAISE OKL_API.G_EXCEPTION_ERROR;
2879: END IF;
2880:
2881: --print('Product_subclass=' || x_pdt_parameter_rec.product_subclass);
2882: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 2921: RAISE OKL_API.G_EXCEPTION_ERROR;

2917: ,p_token1 => G_LEASE_TYPE
2918: ,p_token1_value => 'LEASEOP,LEASEDF,LEASEST'
2919: ,p_token2 => G_INT_BASIS
2920: ,p_token2_value => 'FIXED,REAMORT');
2921: RAISE OKL_API.G_EXCEPTION_ERROR;
2922: END IF;
2923: ELS */
2924: IF (((l_deal_type IN ('LEASEOP', 'LEASEDF', 'LEASEST')) AND
2925: (l_interest_calculation_basis IN ( 'FLOAT_FACTORS', 'REAMORT'))) OR

Line 2942: RAISE OKL_API.G_EXCEPTION_ERROR;

2938: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
2939: ,p_msg_name => G_OKL_LLA_VAR_RATE_MISSING
2940: ,p_token1 => G_CONT_ID
2941: ,p_token1_value => p_khr_id);
2942: RAISE OKL_API.G_EXCEPTION_ERROR;
2943: END IF;
2944:
2945: END IF;
2946:

Line 2988: RAISE OKL_API.G_EXCEPTION_ERROR;

2984: OKC_API.set_message(p_app_name => G_APP_NAME,
2985: p_msg_name => G_REQUIRED_VALUE,
2986: p_token1 => G_COL_NAME_TOKEN,
2987: p_token1_value => 'Catchup Frequency');
2988: RAISE OKL_API.G_EXCEPTION_ERROR;
2989: END IF;
2990:
2991: --print('Catchup :2');
2992: /*IF (l_k_rate_tbl(i).catchup_start_date is NOT NULL AND

Line 3008: RAISE OKL_API.G_EXCEPTION_ERROR;

3004: OKC_API.set_message(p_app_name => G_APP_NAME,
3005: p_msg_name => G_REQUIRED_VALUE,
3006: p_token1 => G_COL_NAME_TOKEN,
3007: p_token1_value => 'Catchup Settlement');
3008: RAISE OKL_API.G_EXCEPTION_ERROR;
3009: END IF;
3010:
3011: --print('Catchup :4');
3012: IF (l_k_rate_tbl(i).catchup_basis_code is NOT NULL AND

Line 3020: RAISE OKL_API.G_EXCEPTION_ERROR;

3016: OKC_API.set_message(p_app_name => G_APP_NAME,
3017: p_msg_name => G_REQUIRED_VALUE,
3018: p_token1 => G_COL_NAME_TOKEN,
3019: p_token1_value => 'Catchup Basis');
3020: RAISE OKL_API.G_EXCEPTION_ERROR;
3021: END IF;
3022: END LOOP;
3023:
3024: END IF;

Line 3027: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

3023:
3024: END IF;
3025:
3026:
3027: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
3028:
3029: EXCEPTION
3030: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3031: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 3030: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3026:
3027: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
3028:
3029: EXCEPTION
3030: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3031: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3032: p_api_name => l_api_name,
3033: p_pkg_name => g_pkg_name,
3034: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 3031: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3027: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
3028:
3029: EXCEPTION
3030: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3031: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3032: p_api_name => l_api_name,
3033: p_pkg_name => g_pkg_name,
3034: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3035: x_msg_count => x_msg_count,

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

3030: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3031: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3032: p_api_name => l_api_name,
3033: p_pkg_name => g_pkg_name,
3034: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3035: x_msg_count => x_msg_count,
3036: x_msg_data => x_msg_data,
3037: p_api_type => g_api_type);
3038:

Line 3039: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3035: x_msg_count => x_msg_count,
3036: x_msg_data => x_msg_data,
3037: p_api_type => g_api_type);
3038:
3039: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3040: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3041: p_api_name => l_api_name,
3042: p_pkg_name => g_pkg_name,
3043: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 3040: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3036: x_msg_data => x_msg_data,
3037: p_api_type => g_api_type);
3038:
3039: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3040: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3041: p_api_name => l_api_name,
3042: p_pkg_name => g_pkg_name,
3043: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3044: x_msg_count => x_msg_count,

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

3039: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3040: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3041: p_api_name => l_api_name,
3042: p_pkg_name => g_pkg_name,
3043: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
3044: x_msg_count => x_msg_count,
3045: x_msg_data => x_msg_data,
3046: p_api_type => g_api_type);
3047:

Line 3049: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3045: x_msg_data => x_msg_data,
3046: p_api_type => g_api_type);
3047:
3048: WHEN OTHERS THEN
3049: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3050: p_api_name => l_api_name,
3051: p_pkg_name => g_pkg_name,
3052: p_exc_name => 'OTHERS',
3053: x_msg_count => x_msg_count,

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

3102: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3103: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'x_return_status=' || x_return_status);
3104: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'name=' || x_pdt_parameter_rec.name);
3105: END IF;
3106: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3107: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3108: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3109: RAISE OKL_API.G_EXCEPTION_ERROR;
3110: /*ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN

Line 3107: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3103: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'x_return_status=' || x_return_status);
3104: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'name=' || x_pdt_parameter_rec.name);
3105: END IF;
3106: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3107: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3108: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3109: RAISE OKL_API.G_EXCEPTION_ERROR;
3110: /*ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN
3111: x_return_status := OKL_API.G_RET_STS_ERROR;

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

3104: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'name=' || x_pdt_parameter_rec.name);
3105: END IF;
3106: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3107: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3108: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3109: RAISE OKL_API.G_EXCEPTION_ERROR;
3110: /*ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN
3111: x_return_status := OKL_API.G_RET_STS_ERROR;
3112: RAISE OKL_API.G_EXCEPTION_ERROR;*/

Line 3109: RAISE OKL_API.G_EXCEPTION_ERROR;

3105: END IF;
3106: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3107: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3108: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3109: RAISE OKL_API.G_EXCEPTION_ERROR;
3110: /*ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN
3111: x_return_status := OKL_API.G_RET_STS_ERROR;
3112: RAISE OKL_API.G_EXCEPTION_ERROR;*/
3113: END IF;

Line 3110: /*ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN

3106: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3107: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3108: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3109: RAISE OKL_API.G_EXCEPTION_ERROR;
3110: /*ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN
3111: x_return_status := OKL_API.G_RET_STS_ERROR;
3112: RAISE OKL_API.G_EXCEPTION_ERROR;*/
3113: END IF;
3114:

Line 3111: x_return_status := OKL_API.G_RET_STS_ERROR;

3107: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3108: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3109: RAISE OKL_API.G_EXCEPTION_ERROR;
3110: /*ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN
3111: x_return_status := OKL_API.G_RET_STS_ERROR;
3112: RAISE OKL_API.G_EXCEPTION_ERROR;*/
3113: END IF;
3114:
3115: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN

Line 3112: RAISE OKL_API.G_EXCEPTION_ERROR;*/

3108: ELSIF ( x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3109: RAISE OKL_API.G_EXCEPTION_ERROR;
3110: /*ELSIF NVL(x_pdt_parameter_rec.Name,OKL_API.G_MISS_CHAR) = OKL_API.G_MISS_CHAR THEN
3111: x_return_status := OKL_API.G_RET_STS_ERROR;
3112: RAISE OKL_API.G_EXCEPTION_ERROR;*/
3113: END IF;
3114:
3115: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3116: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Deal_type=' || x_pdt_parameter_rec.Deal_type);

Line 3211: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3207: l_addl_int_rate_exist BOOLEAN;
3208: l_conv_basis_exist BOOLEAN;
3209:
3210: BEGIN
3211: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3212:
3213: x_return_status := OKL_API.START_ACTIVITY(
3214: p_api_name => l_api_name,
3215: p_pkg_name => g_pkg_name,

Line 3213: x_return_status := OKL_API.START_ACTIVITY(

3209:
3210: BEGIN
3211: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3212:
3213: x_return_status := OKL_API.START_ACTIVITY(
3214: p_api_name => l_api_name,
3215: p_pkg_name => g_pkg_name,
3216: p_init_msg_list => p_init_msg_list,
3217: l_api_version => l_api_version,

Line 3310: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

3306: END IF;
3307: END LOOP;
3308:
3309: --dbms_output.put_line('here4');
3310: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
3311:
3312: EXCEPTION
3313: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3314: --Close all cursors if open

Line 3313: WHEN OKL_API.G_EXCEPTION_ERROR THEN

3309: --dbms_output.put_line('here4');
3310: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
3311:
3312: EXCEPTION
3313: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3314: --Close all cursors if open
3315: IF c_int_rate_param%ISOPEN THEN
3316: CLOSE c_int_rate_param;
3317: END IF;

Line 3318: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3314: --Close all cursors if open
3315: IF c_int_rate_param%ISOPEN THEN
3316: CLOSE c_int_rate_param;
3317: END IF;
3318: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3319: l_api_name,
3320: G_PKG_NAME,
3321: 'OKL_API.G_RET_STS_ERROR',
3322: x_msg_count,

Line 3321: 'OKL_API.G_RET_STS_ERROR',

3317: END IF;
3318: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3319: l_api_name,
3320: G_PKG_NAME,
3321: 'OKL_API.G_RET_STS_ERROR',
3322: x_msg_count,
3323: x_msg_data,
3324: '_PVT');
3325:

Line 3326: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

3322: x_msg_count,
3323: x_msg_data,
3324: '_PVT');
3325:
3326: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3327: --Close all cursors if open
3328: IF c_int_rate_param%ISOPEN THEN
3329: CLOSE c_int_rate_param;
3330: END IF;

Line 3331: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

3327: --Close all cursors if open
3328: IF c_int_rate_param%ISOPEN THEN
3329: CLOSE c_int_rate_param;
3330: END IF;
3331: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
3332: l_api_name,
3333: G_PKG_NAME,
3334: 'OKL_API.G_RET_STS_UNEXP_ERROR',
3335: x_msg_count,

Line 3334: 'OKL_API.G_RET_STS_UNEXP_ERROR',

3330: END IF;
3331: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
3332: l_api_name,
3333: G_PKG_NAME,
3334: 'OKL_API.G_RET_STS_UNEXP_ERROR',
3335: x_msg_count,
3336: x_msg_data,
3337: '_PVT');
3338:

Line 3344: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

3340: --Close all cursors if open
3341: IF c_int_rate_param%ISOPEN THEN
3342: CLOSE c_int_rate_param;
3343: END IF;
3344: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
3345: l_api_name,
3346: G_PKG_NAME,
3347: 'OTHERS',
3348: x_msg_count,

Line 3503: x_return_status := OKL_API.START_ACTIVITY(

3499:
3500:
3501: BEGIN
3502: x_return_status := OKC_API.G_RET_STS_SUCCESS;
3503: x_return_status := OKL_API.START_ACTIVITY(
3504: p_api_name => l_api_name,
3505: p_pkg_name => g_pkg_name,
3506: p_init_msg_list => p_init_msg_list,
3507: l_api_version => l_api_version,

Line 3547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3543: ,p_token1_value =>
3544: 'INTEREST_START_DATE,RATE_CHANGE_START_DATE,CATCHUP_START_DATE'
3545: ,p_token2 => 'CONTRACT_NUMBER'
3546: ,p_token2_value => l_contract_number);
3547: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3548: END IF;
3549:
3550: IF (l_pdt_parameter_rec.DEAL_TYPE IN ('LEASEOP', 'LEASEDF', 'LEASEST') AND
3551: l_pdt_parameter_rec.interest_calculation_basis IN

Line 3578: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3574: p_chr_id ,
3575: l_effective_from_date,
3576: l_no_data_found);
3577: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3578: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3579: END IF;
3580:
3581: IF NOT(l_no_data_found) THEN
3582: l_krpv_rec.khr_id := p_chr_id;

Line 3618: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3614: p_krpv_rec => l_krpv_rec,
3615: x_krpv_rec => x_krpv_rec);
3616: --p_validate_flag => 'Y');
3617: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3618: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3619: END IF; */
3620:
3621: update okl_k_rate_params
3622: set effective_from_date = p_new_start_date

Line 3642: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

3638: END IF;
3639:
3640: END IF;
3641:
3642: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
3643:
3644: EXCEPTION
3645: WHEN OTHERS THEN
3646: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 3646: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

3642: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
3643:
3644: EXCEPTION
3645: WHEN OTHERS THEN
3646: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3647: p_api_name => l_api_name,
3648: p_pkg_name => g_pkg_name,
3649: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3650: x_msg_count => x_msg_count,

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

3645: WHEN OTHERS THEN
3646: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
3647: p_api_name => l_api_name,
3648: p_pkg_name => g_pkg_name,
3649: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
3650: x_msg_count => x_msg_count,
3651: x_msg_data => x_msg_data,
3652: p_api_type => g_api_type);
3653:

Line 3813: x_return_status := OKL_API.G_RET_STS_SUCCESS;

3809: BEGIN
3810: IF (G_DEBUG_ENABLED = 'Y') THEN
3811: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
3812: END IF;
3813: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3814: -- Call start_activity to create savepoint, check compatibility
3815: -- and initialize message list
3816: x_return_status := OKL_API.START_ACTIVITY (
3817: l_api_name

Line 3816: x_return_status := OKL_API.START_ACTIVITY (

3812: END IF;
3813: x_return_status := OKL_API.G_RET_STS_SUCCESS;
3814: -- Call start_activity to create savepoint, check compatibility
3815: -- and initialize message list
3816: x_return_status := OKL_API.START_ACTIVITY (
3817: l_api_name
3818: ,p_init_msg_list
3819: ,'_PVT'
3820: ,x_return_status);

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

3818: ,p_init_msg_list
3819: ,'_PVT'
3820: ,x_return_status);
3821: -- Check if activity started successfully
3822: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3823: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3824: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3825: RAISE OKL_API.G_EXCEPTION_ERROR;
3826: END IF;

Line 3823: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3819: ,'_PVT'
3820: ,x_return_status);
3821: -- Check if activity started successfully
3822: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3823: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3824: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3825: RAISE OKL_API.G_EXCEPTION_ERROR;
3826: END IF;
3827:

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

3820: ,x_return_status);
3821: -- Check if activity started successfully
3822: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3823: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3824: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3825: RAISE OKL_API.G_EXCEPTION_ERROR;
3826: END IF;
3827:
3828: --Bug# 13447258: Do not perform Rebook Effective Date validations for Mass Rebooks

Line 3825: RAISE OKL_API.G_EXCEPTION_ERROR;

3821: -- Check if activity started successfully
3822: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3823: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3824: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3825: RAISE OKL_API.G_EXCEPTION_ERROR;
3826: END IF;
3827:
3828: --Bug# 13447258: Do not perform Rebook Effective Date validations for Mass Rebooks
3829: -- 4766555

Line 3836: IF (l_mass_rebook_flag = OKL_API.G_FALSE) THEN

3832: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
3833: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'check_rebook_allowed:l_mass_rebook_flag=' || l_mass_rebook_flag);
3834: END IF;
3835:
3836: IF (l_mass_rebook_flag = OKL_API.G_FALSE) THEN
3837:
3838: -- Obtain the contract details - Book classification, Interest Calculation Basis, Revenue Recognition Method, Interest Processed flag
3839: OKL_K_RATE_PARAMS_PVT.get_product(
3840: p_api_version => p_api_version,

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

3844: x_msg_data => x_msg_data,
3845: p_khr_id => p_chr_id,
3846: x_pdt_parameter_rec => l_pdt_params_rec);
3847:
3848: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3849: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3850: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3851: RAISE OKL_API.G_EXCEPTION_ERROR;
3852: END IF;

Line 3849: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

3845: p_khr_id => p_chr_id,
3846: x_pdt_parameter_rec => l_pdt_params_rec);
3847:
3848: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3849: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3850: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3851: RAISE OKL_API.G_EXCEPTION_ERROR;
3852: END IF;
3853:

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

3846: x_pdt_parameter_rec => l_pdt_params_rec);
3847:
3848: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3849: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3850: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3851: RAISE OKL_API.G_EXCEPTION_ERROR;
3852: END IF;
3853:
3854: l_book_class := l_pdt_params_rec.deal_type;

Line 3851: RAISE OKL_API.G_EXCEPTION_ERROR;

3847:
3848: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3849: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3850: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
3851: RAISE OKL_API.G_EXCEPTION_ERROR;
3852: END IF;
3853:
3854: l_book_class := l_pdt_params_rec.deal_type;
3855: l_interest_calc_basis := l_pdt_params_rec.interest_calculation_basis;

Line 3891: RAISE OKL_API.G_EXCEPTION_ERROR;

3887: ,p_token1 => G_BOOK_CLASS
3888: ,p_token1_value => l_book_class_meaning
3889: ,p_token2 => G_INT_CALC_BASIS
3890: ,p_token2_value => l_interest_calc_meaning);
3891: RAISE OKL_API.G_EXCEPTION_ERROR;
3892: END IF;
3893:
3894: IF ( l_interest_calc_basis = G_ICB_REAMORT) THEN
3895: -- Donot allow Rebook if interest has been processed

Line 3897: IF (l_mass_rebook_flag = OKL_API.G_TRUE) THEN -- 4766555

3893:
3894: IF ( l_interest_calc_basis = G_ICB_REAMORT) THEN
3895: -- Donot allow Rebook if interest has been processed
3896: IF ( l_interest_proc_date IS NOT NULL ) THEN
3897: IF (l_mass_rebook_flag = OKL_API.G_TRUE) THEN -- 4766555
3898: NULL;
3899: ELSE
3900: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3901: ,p_msg_name => G_OKL_LLA_RBK_INT_PROC_INVAL

Line 3904: RAISE OKL_API.G_EXCEPTION_ERROR;

3900: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3901: ,p_msg_name => G_OKL_LLA_RBK_INT_PROC_INVAL
3902: ,p_token1 => G_COL_NAME
3903: ,p_token1_value => l_contract_number);
3904: RAISE OKL_API.G_EXCEPTION_ERROR;
3905: END IF;
3906: ELSE
3907: -- Get the due date of the Rental stream that was last billed
3908: OPEN get_last_billed_due_date(p_chr_id, G_STRM_RENT);

Line 3927: RAISE OKL_API.G_EXCEPTION_ERROR;

3923: ,p_token1 => G_STREAM
3924: ,p_token1_value => l_stream_name
3925: ,p_token2 => G_DUE_DATE
3926: ,p_token2_value => l_last_billed_due_date);
3927: RAISE OKL_API.G_EXCEPTION_ERROR;
3928: /*ELSIF ( l_last_accrued_due_date IS NOT NULL
3929: AND p_rebook_date <= l_last_accrued_due_date) THEN
3930: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3931: ,p_msg_name => G_OKL_LLA_RBK_DATE_ACCR_INVAL

Line 3936: RAISE OKL_API.G_EXCEPTION_ERROR; */ -- Bug 5000110

3932: ,p_token1 => G_STREAM
3933: ,p_token1_value => l_stream_name
3934: ,p_token2 => G_DUE_DATE
3935: ,p_token2_value => l_last_accrued_due_date);
3936: RAISE OKL_API.G_EXCEPTION_ERROR; */ -- Bug 5000110
3937: END IF; -- end of check for rebook date
3938: END IF; -- end of check for interest rate processed
3939:
3940: END IF; -- end of REAMORT check

Line 3952: RAISE OKL_API.G_EXCEPTION_ERROR;

3948: ,p_token1 => G_BOOK_CLASS
3949: ,p_token1_value => l_book_class_meaning
3950: ,p_token2 => G_INT_CALC_BASIS
3951: ,p_token2_value => l_interest_calc_meaning);
3952: RAISE OKL_API.G_EXCEPTION_ERROR;
3953: END IF;
3954: IF ( l_interest_calc_basis = G_ICB_REAMORT) THEN
3955: -- Donot allow Rebook if interest has been processed
3956: IF ( l_interest_proc_date IS NOT NULL ) THEN

Line 3957: IF (l_mass_rebook_flag = OKL_API.G_TRUE) THEN -- 4766555

3953: END IF;
3954: IF ( l_interest_calc_basis = G_ICB_REAMORT) THEN
3955: -- Donot allow Rebook if interest has been processed
3956: IF ( l_interest_proc_date IS NOT NULL ) THEN
3957: IF (l_mass_rebook_flag = OKL_API.G_TRUE) THEN -- 4766555
3958: NULL;
3959: ELSE
3960: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3961: ,p_msg_name => G_OKL_LLA_RBK_INT_PROC_INVAL

Line 3964: RAISE OKL_API.G_EXCEPTION_ERROR;

3960: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3961: ,p_msg_name => G_OKL_LLA_RBK_INT_PROC_INVAL
3962: ,p_token1 => G_COL_NAME
3963: ,p_token1_value => l_contract_number);
3964: RAISE OKL_API.G_EXCEPTION_ERROR;
3965: END IF;
3966: ELSE
3967: -- Get the due date of the Rental stream that was last billed
3968: OPEN get_last_billed_due_date(p_chr_id, G_STRM_RENT);

Line 3988: RAISE OKL_API.G_EXCEPTION_ERROR;

3984: ,p_token1 => G_STREAM
3985: ,p_token1_value => l_stream_name
3986: ,p_token2 => G_DUE_DATE
3987: ,p_token2_value => l_last_billed_due_date);
3988: RAISE OKL_API.G_EXCEPTION_ERROR;
3989: /*ELSIF ( l_last_accrued_due_date IS NOT NULL AND
3990: p_rebook_date <= l_last_accrued_due_date) THEN
3991: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
3992: ,p_msg_name => G_OKL_LLA_RBK_DATE_ACCR_INVAL

Line 3997: RAISE OKL_API.G_EXCEPTION_ERROR; */ -- Bug 5000110

3993: ,p_token1 => G_STREAM
3994: ,p_token1_value => l_stream_name
3995: ,p_token2 => G_DUE_DATE
3996: ,p_token2_value => l_last_accrued_due_date);
3997: RAISE OKL_API.G_EXCEPTION_ERROR; */ -- Bug 5000110
3998: END IF; -- end of check for rebook date
3999: END IF; -- end of check for interest rate processed
4000:
4001: END IF; -- end of REAMORT check

Line 4013: RAISE OKL_API.G_EXCEPTION_ERROR;

4009: ,p_token1 => G_BOOK_CLASS
4010: ,p_token1_value => l_book_class_meaning
4011: ,p_token2 => G_INT_CALC_BASIS
4012: ,p_token2_value => l_interest_calc_meaning);
4013: RAISE OKL_API.G_EXCEPTION_ERROR;
4014: END IF;
4015:
4016: IF ( l_interest_calc_basis = G_ICB_REAMORT) THEN
4017: -- Donot allow Rebook if interest has been processed

Line 4019: IF (l_mass_rebook_flag = OKL_API.G_TRUE) THEN -- 4766555

4015:
4016: IF ( l_interest_calc_basis = G_ICB_REAMORT) THEN
4017: -- Donot allow Rebook if interest has been processed
4018: IF ( l_interest_proc_date IS NOT NULL ) THEN
4019: IF (l_mass_rebook_flag = OKL_API.G_TRUE) THEN -- 4766555
4020: NULL;
4021: ELSE
4022: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4023: ,p_msg_name => G_OKL_LLA_RBK_INT_PROC_INVAL

Line 4026: RAISE OKL_API.G_EXCEPTION_ERROR;

4022: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4023: ,p_msg_name => G_OKL_LLA_RBK_INT_PROC_INVAL
4024: ,p_token1 => G_COL_NAME
4025: ,p_token1_value => l_contract_number);
4026: RAISE OKL_API.G_EXCEPTION_ERROR;
4027: END IF;
4028: ELSE
4029: -- Get the due date of the rent stream that was last billed
4030: OPEN get_last_billed_due_date(p_chr_id, G_STRM_RENT);

Line 4050: RAISE OKL_API.G_EXCEPTION_ERROR;

4046: ,p_token1 => G_STREAM
4047: ,p_token1_value => l_stream_name
4048: ,p_token2 => G_DUE_DATE
4049: ,p_token2_value => l_last_billed_due_date);
4050: RAISE OKL_API.G_EXCEPTION_ERROR;
4051: /*ELSIF ( l_last_accrued_due_date IS NOT NULL AND
4052: p_rebook_date <= l_last_accrued_due_date) THEN
4053: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4054: ,p_msg_name => G_OKL_LLA_RBK_DATE_ACCR_INVAL

Line 4059: RAISE OKL_API.G_EXCEPTION_ERROR; */ -- Bug 5000110

4055: ,p_token1 => G_STREAM
4056: ,p_token1_value => l_stream_name
4057: ,p_token2 => G_DUE_DATE
4058: ,p_token2_value => l_last_accrued_due_date);
4059: RAISE OKL_API.G_EXCEPTION_ERROR; */ -- Bug 5000110
4060: END IF; -- end of check for rebook date
4061: END IF; -- end of check for interest rate processed
4062:
4063: END IF; -- end of REAMORT check

Line 4075: RAISE OKL_API.G_EXCEPTION_ERROR;

4071: ,p_token1 => G_BOOK_CLASS
4072: ,p_token1_value => l_book_class_meaning
4073: ,p_token2 => G_INT_CALC_BASIS
4074: ,p_token2_value => l_interest_calc_meaning);
4075: RAISE OKL_API.G_EXCEPTION_ERROR;
4076: END IF;
4077:
4078: --Bug# 13831818
4079: IF (l_interest_calc_basis = G_ICB_CATCHUP_CLEANUP) THEN

Line 4086: RAISE OKL_API.G_EXCEPTION_ERROR;

4082: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4083: ,p_msg_name => G_OKL_LLA_RBK_INT_CAL_DT_INV
4084: ,p_token2 => G_DUE_DATE
4085: ,p_token2_value => l_interest_proc_date);
4086: RAISE OKL_API.G_EXCEPTION_ERROR;
4087: END IF;
4088: END IF;
4089: --Bug# 13831818
4090:

Line 4093: IF (l_mass_rebook_flag = OKL_API.G_TRUE) THEN -- 4766555

4089: --Bug# 13831818
4090:
4091: IF ( l_interest_calc_basis = G_ICB_REAMORT) THEN
4092: IF ( l_interest_proc_date IS NOT NULL ) THEN
4093: IF (l_mass_rebook_flag = OKL_API.G_TRUE) THEN -- 4766555
4094: NULL;
4095: ELSE
4096: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4097: ,p_msg_name => G_OKL_LLA_RBK_INT_PROC_INVAL

Line 4100: RAISE OKL_API.G_EXCEPTION_ERROR;

4096: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4097: ,p_msg_name => G_OKL_LLA_RBK_INT_PROC_INVAL
4098: ,p_token1 => G_COL_NAME
4099: ,p_token1_value => l_contract_number);
4100: RAISE OKL_API.G_EXCEPTION_ERROR;
4101: END IF;
4102: ELSE
4103: /* 13394074
4104: -- Get the due date of the rent stream that was last billed

Line 4127: RAISE OKL_API.G_EXCEPTION_ERROR;

4123: ,p_token1 => G_STREAM
4124: ,p_token1_value => l_stream_name
4125: ,p_token2 => G_DUE_DATE
4126: ,p_token2_value => l_last_billed_due_date);
4127: RAISE OKL_API.G_EXCEPTION_ERROR;
4128: 13394074 */
4129: /*ELSIF ( l_last_accrued_due_date IS NOT NULL AND
4130: p_rebook_date <= l_last_accrued_due_date) THEN
4131: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

Line 4137: RAISE OKL_API.G_EXCEPTION_ERROR; */ -- Bug 5000110

4133: ,p_token1 => G_STREAM
4134: ,p_token1_value => l_stream_name
4135: ,p_token2 => G_DUE_DATE
4136: ,p_token2_value => l_last_accrued_due_date);
4137: RAISE OKL_API.G_EXCEPTION_ERROR; */ -- Bug 5000110
4138: --END IF; -- end of check for rebook date 13394074
4139:
4140: /* 13394074 Start */
4141: IF (l_rev_recog_method = G_RRM_ACTUAL) THEN

Line 4155: RAISE OKL_API.G_EXCEPTION_ERROR;

4151: ,p_token1 => G_STREAM
4152: ,p_token1_value => l_stream_name
4153: ,p_token2 => G_DUE_DATE
4154: ,p_token2_value => l_last_billed_due_date);
4155: RAISE OKL_API.G_EXCEPTION_ERROR;
4156: END IF;
4157: ELSE
4158: -- Get the due date of the principal payment stream last billed
4159: OPEN get_last_billed_due_date(p_chr_id, G_STRM_PRINCIPAL_PAYMENT);

Line 4171: RAISE OKL_API.G_EXCEPTION_ERROR;

4167: ,p_token1 => G_STREAM
4168: ,p_token1_value => l_stream_name
4169: ,p_token2 => G_DUE_DATE
4170: ,p_token2_value => l_last_billed_due_date);
4171: RAISE OKL_API.G_EXCEPTION_ERROR;
4172: END IF;
4173:
4174: -- Get the due date of the interest payment stream last billed
4175: OPEN get_last_billed_due_date(p_chr_id, G_STRM_INTEREST_PAYMENT);

Line 4187: RAISE OKL_API.G_EXCEPTION_ERROR;

4183: ,p_token1 => G_STREAM
4184: ,p_token1_value => l_stream_name
4185: ,p_token2 => G_DUE_DATE
4186: ,p_token2_value => l_last_billed_due_date);
4187: RAISE OKL_API.G_EXCEPTION_ERROR;
4188: END IF;
4189:
4190: END IF;
4191:

Line 4224: RAISE OKL_API.G_EXCEPTION_ERROR;

4220: ,p_token1 => G_STREAM
4221: ,p_token1_value => l_stream_name
4222: ,p_token2 => G_DUE_DATE
4223: ,p_token2_value => l_last_billed_due_date);
4224: RAISE OKL_API.G_EXCEPTION_ERROR;
4225: /*ELSIF ( l_last_accrued_due_date IS NOT NULL AND
4226: p_rebook_date <= l_last_accrued_due_date) THEN
4227: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4228: ,p_msg_name => G_OKL_LLA_RBK_DATE_ACCR_INVAL

Line 4233: RAISE OKL_API.G_EXCEPTION_ERROR; */ -- Bug 5000110

4229: ,p_token1 => G_STREAM
4230: ,p_token1_value => l_stream_name
4231: ,p_token2 => G_DUE_DATE
4232: ,p_token2_value => l_last_accrued_due_date);
4233: RAISE OKL_API.G_EXCEPTION_ERROR; */ -- Bug 5000110
4234: END IF; -- end of check for rebook date
4235: -- Check if the Revenue Recognition Method is Actual
4236: ELSIF ( l_rev_recog_method = G_RRM_ACTUAL) THEN
4237: -- Get the due date of the Variable Loan Payment stream that was last billed

Line 4259: RAISE OKL_API.G_EXCEPTION_ERROR;

4255: ,p_token1 => G_STREAM
4256: ,p_token1_value => l_stream_name
4257: ,p_token2 => G_DUE_DATE
4258: ,p_token2_value => l_last_billed_due_date);
4259: RAISE OKL_API.G_EXCEPTION_ERROR;
4260: /*ELSIF ( l_last_accrued_due_date IS NOT NULL AND
4261: p_rebook_date <= l_last_accrued_due_date) THEN
4262: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4263: ,p_msg_name => G_OKL_LLA_RBK_DATE_ACCR_INVAL

Line 4268: RAISE OKL_API.G_EXCEPTION_ERROR; */ -- Bug 5000110

4264: ,p_token1 => G_STREAM
4265: ,p_token1_value => l_stream_name
4266: ,p_token2 => G_DUE_DATE
4267: ,p_token2_value => l_last_accrued_due_date);
4268: RAISE OKL_API.G_EXCEPTION_ERROR; */ -- Bug 5000110
4269: END IF; -- end of check for rebook date
4270: END IF; -- end of check for Revenue Recognition Method
4271: END IF; -- end of check for Interest Calculation Basis=FLOAT
4272:

Line 4282: RAISE OKL_API.G_EXCEPTION_ERROR;

4278: ,p_token1 => G_BOOK_CLASS
4279: ,p_token1_value => l_book_class_meaning
4280: ,p_token2 => G_INT_CALC_BASIS
4281: ,p_token2_value => l_interest_calc_meaning);
4282: RAISE OKL_API.G_EXCEPTION_ERROR;
4283: ELSE
4284: -- Check if the Revenue Recognition Method is Estimated and Actual
4285: --IF ( l_rev_recog_method = G_RRM_EST_ACTUAL) THEN 13394074
4286: IF ( l_rev_recog_method = G_RRM_EST_BILLED) THEN -- 13394074

Line 4309: RAISE OKL_API.G_EXCEPTION_ERROR;

4305: ,p_token1 => G_STREAM
4306: ,p_token1_value => l_stream_name
4307: ,p_token2 => G_DUE_DATE
4308: ,p_token2_value => l_last_billed_due_date);
4309: RAISE OKL_API.G_EXCEPTION_ERROR;
4310: /*ELSIF ( l_last_accrued_due_date IS NOT NULL AND
4311: p_rebook_date <= l_last_accrued_due_date) THEN
4312: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4313: ,p_msg_name => G_OKL_LLA_RBK_DATE_ACCR_INVAL

Line 4318: RAISE OKL_API.G_EXCEPTION_ERROR; */ -- Bug 5000110

4314: ,p_token1 => G_STREAM
4315: ,p_token1_value => l_stream_name
4316: ,p_token2 => G_DUE_DATE
4317: ,p_token2_value => l_last_accrued_due_date);
4318: RAISE OKL_API.G_EXCEPTION_ERROR; */ -- Bug 5000110
4319: END IF; -- end of check for rebook date
4320: -- Check if the Revenue Recognition Method is Actual
4321: ELSIF ( l_rev_recog_method = G_RRM_ACTUAL) THEN
4322: -- Get the due date of the Variable Loan Payment stream that was last billed

Line 4344: RAISE OKL_API.G_EXCEPTION_ERROR;

4340: ,p_token1 => G_STREAM
4341: ,p_token1_value => l_stream_name
4342: ,p_token2 => G_DUE_DATE
4343: ,p_token2_value => l_last_billed_due_date);
4344: RAISE OKL_API.G_EXCEPTION_ERROR;
4345: /*ELSIF ( l_last_accrued_due_date IS NOT NULL AND
4346: p_rebook_date <= l_last_accrued_due_date) THEN
4347: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
4348: ,p_msg_name => G_OKL_LLA_RBK_DATE_ACCR_INVAL

Line 4353: RAISE OKL_API.G_EXCEPTION_ERROR; */ -- Bug 5000110

4349: ,p_token1 => G_STREAM
4350: ,p_token1_value => l_stream_name
4351: ,p_token2 => G_DUE_DATE
4352: ,p_token2_value => l_last_accrued_due_date);
4353: RAISE OKL_API.G_EXCEPTION_ERROR; */ -- Bug 5000110
4354: END IF; -- end of check for rebook date
4355: END IF; -- end of check for Revenue Recognition Method
4356: END IF; -- end of check for Interest Calculation Basis=FLOAT
4357: /*-- Raise an error if the book classification is not valid.

Line 4359: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR; */

4355: END IF; -- end of check for Revenue Recognition Method
4356: END IF; -- end of check for Interest Calculation Basis=FLOAT
4357: /*-- Raise an error if the book classification is not valid.
4358: ELSE
4359: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR; */
4360: END IF;
4361:
4362: END IF;
4363: --Bug# 13447258: End

Line 4365: OKL_API.END_ACTIVITY (x_msg_count,

4361:
4362: END IF;
4363: --Bug# 13447258: End
4364:
4365: OKL_API.END_ACTIVITY (x_msg_count,
4366: x_msg_data );
4367:
4368: EXCEPTION
4369: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 4369: WHEN OKL_API.G_EXCEPTION_ERROR THEN

4365: OKL_API.END_ACTIVITY (x_msg_count,
4366: x_msg_data );
4367:
4368: EXCEPTION
4369: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4370: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4371: l_api_name,
4372: G_PKG_NAME,
4373: 'OKL_API.G_RET_STS_ERROR',

Line 4370: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

4366: x_msg_data );
4367:
4368: EXCEPTION
4369: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4370: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4371: l_api_name,
4372: G_PKG_NAME,
4373: 'OKL_API.G_RET_STS_ERROR',
4374: x_msg_count,

Line 4373: 'OKL_API.G_RET_STS_ERROR',

4369: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4370: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4371: l_api_name,
4372: G_PKG_NAME,
4373: 'OKL_API.G_RET_STS_ERROR',
4374: x_msg_count,
4375: x_msg_data,
4376: '_PVT');
4377: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 4377: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4373: 'OKL_API.G_RET_STS_ERROR',
4374: x_msg_count,
4375: x_msg_data,
4376: '_PVT');
4377: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4378: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
4379: l_api_name,
4380: G_PKG_NAME,
4381: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 4378: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

4374: x_msg_count,
4375: x_msg_data,
4376: '_PVT');
4377: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4378: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
4379: l_api_name,
4380: G_PKG_NAME,
4381: 'OKL_API.G_RET_STS_UNEXP_ERROR',
4382: x_msg_count,

Line 4381: 'OKL_API.G_RET_STS_UNEXP_ERROR',

4377: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4378: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
4379: l_api_name,
4380: G_PKG_NAME,
4381: 'OKL_API.G_RET_STS_UNEXP_ERROR',
4382: x_msg_count,
4383: x_msg_data,
4384: '_PVT');
4385: WHEN OTHERS THEN

Line 4386: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

4382: x_msg_count,
4383: x_msg_data,
4384: '_PVT');
4385: WHEN OTHERS THEN
4386: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
4387: l_api_name,
4388: G_PKG_NAME,
4389: 'OTHERS',
4390: x_msg_count,

Line 4701: --x_return_status := OKL_API.G_RET_STS_ERROR;

4697: END IF;
4698:
4699: EXCEPTION WHEN OTHERS THEN
4700:
4701: --x_return_status := OKL_API.G_RET_STS_ERROR;
4702: /* DEBUG */
4703: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
4704: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'sqlcode=' || SQLCODE || ':sqlerrm=' || SQLERRM);
4705: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'Printing copy_var_int_rate_params:l_kkhr_id_tab.count=' || l_kkhr_id_tab.COUNT || ' ...');

Line 4782: l_base_rate = OKL_API.G_MISS_NUM) THEN

4778: INTO l_base_rate;
4779: CLOSE base_rate_csr;
4780:
4781: IF (l_base_rate IS NULL OR
4782: l_base_rate = OKL_API.G_MISS_NUM) THEN
4783: x_base_rate_defined := FALSE;
4784: ELSE
4785: x_base_rate_defined := TRUE;
4786: END IF;

Line 4787: x_return_status := OKL_API.G_RET_STS_SUCCESS;

4783: x_base_rate_defined := FALSE;
4784: ELSE
4785: x_base_rate_defined := TRUE;
4786: END IF;
4787: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4788:
4789: EXCEPTION
4790: WHEN NO_DATA_FOUND THEN -- Bug 4905142
4791: x_base_rate_defined := FALSE;

Line 4792: x_return_status := OKL_API.G_RET_STS_SUCCESS;

4788:
4789: EXCEPTION
4790: WHEN NO_DATA_FOUND THEN -- Bug 4905142
4791: x_base_rate_defined := FALSE;
4792: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4793: WHEN OTHERS THEN
4794: x_return_status := OKL_API.G_RET_STS_ERROR;
4795: x_base_rate_defined := FALSE;
4796: END;

Line 4794: x_return_status := OKL_API.G_RET_STS_ERROR;

4790: WHEN NO_DATA_FOUND THEN -- Bug 4905142
4791: x_base_rate_defined := FALSE;
4792: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4793: WHEN OTHERS THEN
4794: x_return_status := OKL_API.G_RET_STS_ERROR;
4795: x_base_rate_defined := FALSE;
4796: END;
4797:
4798: PROCEDURE check_principal_payment(

Line 4833: x_return_status := OKL_API.G_RET_STS_SUCCESS;

4829: l_api_version NUMBER := 1;
4830: l_api_name VARCHAR2(30) := 'check_principal_payment';
4831:
4832: BEGIN
4833: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4834: x_principal_payment_defined := FALSE;
4835:
4836: x_return_status := OKL_API.START_ACTIVITY(
4837: p_api_name => l_api_name,

Line 4836: x_return_status := OKL_API.START_ACTIVITY(

4832: BEGIN
4833: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4834: x_principal_payment_defined := FALSE;
4835:
4836: x_return_status := OKL_API.START_ACTIVITY(
4837: p_api_name => l_api_name,
4838: p_pkg_name => g_pkg_name,
4839: p_init_msg_list => p_init_msg_list,
4840: l_api_version => l_api_version,

Line 4851: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4847: OPEN strm_name_csr ( l_hdrrl_rec.object1_id1 );
4848: FETCH strm_name_csr into l_strm_name_rec;
4849: IF strm_name_csr%NOTFOUND THEN
4850: CLOSE strm_name_csr;
4851: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4852: END IF;
4853: CLOSE strm_name_csr;
4854:
4855: IF ( l_strm_name_rec.stream_type_purpose = 'PRINCIPAL_PAYMENT' ) Then

Line 4860: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

4856: x_principal_payment_defined := TRUE;
4857: END IF;
4858: END LOOP;
4859:
4860: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
4861:
4862: EXCEPTION
4863: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4864: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 4863: WHEN OKL_API.G_EXCEPTION_ERROR THEN

4859:
4860: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
4861:
4862: EXCEPTION
4863: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4864: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4865: p_api_name => l_api_name,
4866: p_pkg_name => g_pkg_name,
4867: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 4864: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

4860: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
4861:
4862: EXCEPTION
4863: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4864: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4865: p_api_name => l_api_name,
4866: p_pkg_name => g_pkg_name,
4867: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
4868: x_msg_count => x_msg_count,

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

4863: WHEN OKL_API.G_EXCEPTION_ERROR THEN
4864: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4865: p_api_name => l_api_name,
4866: p_pkg_name => g_pkg_name,
4867: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
4868: x_msg_count => x_msg_count,
4869: x_msg_data => x_msg_data,
4870: p_api_type => g_api_type);
4871:

Line 4872: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

4868: x_msg_count => x_msg_count,
4869: x_msg_data => x_msg_data,
4870: p_api_type => g_api_type);
4871:
4872: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4873: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4874: p_api_name => l_api_name,
4875: p_pkg_name => g_pkg_name,
4876: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 4873: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

4869: x_msg_data => x_msg_data,
4870: p_api_type => g_api_type);
4871:
4872: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4873: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4874: p_api_name => l_api_name,
4875: p_pkg_name => g_pkg_name,
4876: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
4877: x_msg_count => x_msg_count,

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

4872: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
4873: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4874: p_api_name => l_api_name,
4875: p_pkg_name => g_pkg_name,
4876: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
4877: x_msg_count => x_msg_count,
4878: x_msg_data => x_msg_data,
4879: p_api_type => g_api_type);
4880:

Line 4882: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

4878: x_msg_data => x_msg_data,
4879: p_api_type => g_api_type);
4880:
4881: WHEN OTHERS THEN
4882: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
4883: p_api_name => l_api_name,
4884: p_pkg_name => g_pkg_name,
4885: p_exc_name => 'OTHERS',
4886: x_msg_count => x_msg_count,

Line 4974: x_return_status := OKL_API.G_RET_STS_SUCCESS;

4970:
4971: l_last_billed_due_date DATE;
4972: BEGIN
4973:
4974: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4975:
4976: x_return_status := OKL_API.START_ACTIVITY(
4977: p_api_name => l_api_name,
4978: p_pkg_name => g_pkg_name,

Line 4976: x_return_status := OKL_API.START_ACTIVITY(

4972: BEGIN
4973:
4974: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4975:
4976: x_return_status := OKL_API.START_ACTIVITY(
4977: p_api_name => l_api_name,
4978: p_pkg_name => g_pkg_name,
4979: p_init_msg_list => p_init_msg_list,
4980: l_api_version => 1,

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

4990: x_msg_data => x_msg_data,
4991: p_khr_id => p_khr_id,
4992: x_pdt_parameter_rec => l_pdt_params_rec);
4993:
4994: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4995: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4996: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4997: RAISE OKL_API.G_EXCEPTION_ERROR;
4998: END IF;

Line 4995: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4991: p_khr_id => p_khr_id,
4992: x_pdt_parameter_rec => l_pdt_params_rec);
4993:
4994: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4995: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4996: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4997: RAISE OKL_API.G_EXCEPTION_ERROR;
4998: END IF;
4999:

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

4992: x_pdt_parameter_rec => l_pdt_params_rec);
4993:
4994: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4995: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4996: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4997: RAISE OKL_API.G_EXCEPTION_ERROR;
4998: END IF;
4999:
5000: l_interest_calc_basis := l_pdt_params_rec.interest_calculation_basis;

Line 4997: RAISE OKL_API.G_EXCEPTION_ERROR;

4993:
4994: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4995: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4996: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4997: RAISE OKL_API.G_EXCEPTION_ERROR;
4998: END IF;
4999:
5000: l_interest_calc_basis := l_pdt_params_rec.interest_calculation_basis;
5001: l_rev_recog_method := l_pdt_params_rec.revenue_recognition_method;

Line 5011: RAISE OKL_API.G_EXCEPTION_ERROR;

5007: l_parameter_type_code := 'CONVERSION';
5008: ELSE
5009: OKC_API.set_message(p_app_name => G_APP_NAME,
5010: p_msg_name => 'OKL_LLA_VAR_RATE_INV_PARAM');
5011: RAISE OKL_API.G_EXCEPTION_ERROR;
5012: END IF;
5013:
5014: l_effective_from_date := null;
5015: FOR r IN get_effective_from_date_csr(p_khr_id, l_parameter_type_code)

Line 5031: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

5027: END IF;
5028: IF (l_effective_from_date is NULL) THEN
5029: l_krpv_rec.effective_from_date := NULL;
5030: x_krpv_rec := l_krpv_rec;
5031: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
5032: x_msg_data => x_msg_data);
5033: return;
5034: END IF;
5035:

Line 5042: RAISE OKL_API.G_EXCEPTION_ERROR;

5038: END IF;
5039: IF (l_orig_system_source_code <> 'OKL_REBOOK') THEN
5040: OKC_API.set_message(p_app_name => G_APP_NAME,
5041: p_msg_name => 'OKL_LLA_VAR_RATE_COPY_NA');
5042: RAISE OKL_API.G_EXCEPTION_ERROR;
5043: END IF;
5044:
5045: -- Bug 4999888
5046: IF (l_interest_calc_basis = 'FIXED' and l_rev_recog_method='ACTUAL') THEN

Line 5067: RAISE OKL_API.G_EXCEPTION_ERROR;

5063: p_token1 => 'EFF_DATE',
5064: p_token1_value => p_effective_from_date,
5065: p_token2 => 'INTEREST_DATE',
5066: p_token2_value => l_last_billed_due_date);
5067: RAISE OKL_API.G_EXCEPTION_ERROR;
5068: END IF;
5069: END IF;
5070:
5071: -- Bug 4999888

Line 5082: RAISE OKL_API.G_EXCEPTION_ERROR;

5078: p_token1 => 'EFF_DATE',
5079: p_token1_value => p_effective_from_date,
5080: p_token2 => 'INTEREST_DATE',
5081: p_token2_value => l_last_interest_cal_date);
5082: RAISE OKL_API.G_EXCEPTION_ERROR;
5083: END IF;
5084: END IF;
5085: END IF;
5086:

Line 5102: x_return_status := OKL_API.G_RET_STS_ERROR;

5098: IF (l_orig_effective_from_date <> l_effective_from_date) THEN
5099: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5100: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'copy:Yes, inside...');
5101: END IF;
5102: x_return_status := OKL_API.G_RET_STS_ERROR;
5103: OKC_API.set_message(p_app_name => G_APP_NAME,
5104: p_msg_name => 'OKL_LLA_VAR_RATE_EXISTS');
5105: RAISE OKL_API.G_EXCEPTION_ERROR;
5106: END IF;

Line 5105: RAISE OKL_API.G_EXCEPTION_ERROR;

5101: END IF;
5102: x_return_status := OKL_API.G_RET_STS_ERROR;
5103: OKC_API.set_message(p_app_name => G_APP_NAME,
5104: p_msg_name => 'OKL_LLA_VAR_RATE_EXISTS');
5105: RAISE OKL_API.G_EXCEPTION_ERROR;
5106: END IF;
5107:
5108: SELECT
5109: KHR_ID, l_parameter_type_code, p_effective_from_date,

Line 5195: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

5191: AND PARAMETER_TYPE_CODE = l_parameter_type_code
5192: AND EFFECTIVE_FROM_DATE = l_effective_from_date
5193: AND EFFECTIVE_TO_DATE IS NULL;
5194:
5195: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
5196:
5197: EXCEPTION
5198: WHEN OKL_API.G_EXCEPTION_ERROR THEN
5199: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 5198: WHEN OKL_API.G_EXCEPTION_ERROR THEN

5194:
5195: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
5196:
5197: EXCEPTION
5198: WHEN OKL_API.G_EXCEPTION_ERROR THEN
5199: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
5200: p_api_name => l_api_name,
5201: p_pkg_name => g_pkg_name,
5202: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 5199: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

5195: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
5196:
5197: EXCEPTION
5198: WHEN OKL_API.G_EXCEPTION_ERROR THEN
5199: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
5200: p_api_name => l_api_name,
5201: p_pkg_name => g_pkg_name,
5202: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
5203: x_msg_count => x_msg_count,

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

5198: WHEN OKL_API.G_EXCEPTION_ERROR THEN
5199: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
5200: p_api_name => l_api_name,
5201: p_pkg_name => g_pkg_name,
5202: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
5203: x_msg_count => x_msg_count,
5204: x_msg_data => x_msg_data,
5205: p_api_type => g_api_type);
5206:

Line 5207: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

5203: x_msg_count => x_msg_count,
5204: x_msg_data => x_msg_data,
5205: p_api_type => g_api_type);
5206:
5207: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5208: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
5209: p_api_name => l_api_name,
5210: p_pkg_name => g_pkg_name,
5211: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 5208: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

5204: x_msg_data => x_msg_data,
5205: p_api_type => g_api_type);
5206:
5207: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5208: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
5209: p_api_name => l_api_name,
5210: p_pkg_name => g_pkg_name,
5211: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
5212: x_msg_count => x_msg_count,

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

5207: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5208: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
5209: p_api_name => l_api_name,
5210: p_pkg_name => g_pkg_name,
5211: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
5212: x_msg_count => x_msg_count,
5213: x_msg_data => x_msg_data,
5214: p_api_type => g_api_type);
5215:

Line 5217: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

5213: x_msg_data => x_msg_data,
5214: p_api_type => g_api_type);
5215:
5216: WHEN OTHERS THEN
5217: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
5218: p_api_name => l_api_name,
5219: p_pkg_name => g_pkg_name,
5220: p_exc_name => 'OTHERS',
5221: x_msg_count => x_msg_count,

Line 5249: x_return_status := OKL_API.START_ACTIVITY(

5245:
5246: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5247: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'In Sync_base_rate procedure...');
5248: END IF;
5249: x_return_status := OKL_API.START_ACTIVITY(
5250: p_api_name => l_api_name,
5251: p_pkg_name => g_pkg_name,
5252: p_init_msg_list => p_init_msg_list,
5253: l_api_version => 1,

Line 5285: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

5281: AND EFFECTIVE_TO_DATE IS NULL
5282: AND BASE_RATE IS NULL;
5283: END IF;
5284:
5285: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
5286:
5287: EXCEPTION
5288: WHEN OKL_API.G_EXCEPTION_ERROR THEN
5289: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 5288: WHEN OKL_API.G_EXCEPTION_ERROR THEN

5284:
5285: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
5286:
5287: EXCEPTION
5288: WHEN OKL_API.G_EXCEPTION_ERROR THEN
5289: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
5290: p_api_name => l_api_name,
5291: p_pkg_name => g_pkg_name,
5292: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 5289: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

5285: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
5286:
5287: EXCEPTION
5288: WHEN OKL_API.G_EXCEPTION_ERROR THEN
5289: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
5290: p_api_name => l_api_name,
5291: p_pkg_name => g_pkg_name,
5292: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
5293: x_msg_count => x_msg_count,

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

5288: WHEN OKL_API.G_EXCEPTION_ERROR THEN
5289: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
5290: p_api_name => l_api_name,
5291: p_pkg_name => g_pkg_name,
5292: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
5293: x_msg_count => x_msg_count,
5294: x_msg_data => x_msg_data,
5295: p_api_type => g_api_type);
5296:

Line 5297: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

5293: x_msg_count => x_msg_count,
5294: x_msg_data => x_msg_data,
5295: p_api_type => g_api_type);
5296:
5297: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5298: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
5299: p_api_name => l_api_name,
5300: p_pkg_name => g_pkg_name,
5301: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 5298: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

5294: x_msg_data => x_msg_data,
5295: p_api_type => g_api_type);
5296:
5297: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5298: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
5299: p_api_name => l_api_name,
5300: p_pkg_name => g_pkg_name,
5301: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
5302: x_msg_count => x_msg_count,

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

5297: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
5298: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
5299: p_api_name => l_api_name,
5300: p_pkg_name => g_pkg_name,
5301: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
5302: x_msg_count => x_msg_count,
5303: x_msg_data => x_msg_data,
5304: p_api_type => g_api_type);
5305:

Line 5307: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

5303: x_msg_data => x_msg_data,
5304: p_api_type => g_api_type);
5305:
5306: WHEN OTHERS THEN
5307: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
5308: p_api_name => l_api_name,
5309: p_pkg_name => g_pkg_name,
5310: p_exc_name => 'OTHERS',
5311: x_msg_count => x_msg_count,