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

Line 56: x_return_status := OKL_API.G_RET_STS_SUCCESS;

52: l_rebook_contract VARCHAR2(10);
53: l_parameter_list wf_parameter_list_t;
54: l_contract_process VARCHAR2(20);
55: BEGIN
56: x_return_status := OKL_API.G_RET_STS_SUCCESS;
57:
58: -- wrapper API to get contract process. this API determines in which status the
59: -- contract in question is.
60: l_contract_process := okl_lla_util_pvt.get_contract_process(p_chr_id => p_chr_id);

Line 75: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

71: p_parameters => l_parameter_list);
72:
73: EXCEPTION
74: WHEN OTHERS THEN
75: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
76: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
77: END raise_business_event;
78:
79: /*

Line 76: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

72:
73: EXCEPTION
74: WHEN OTHERS THEN
75: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
76: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
77: END raise_business_event;
78:
79: /*
80: * sjalasut: aug 18, 04 added procedure to call private wrapper that raises the business event. END

Line 210: If nvl(l_talv_rec.salvage_value,OKL_API.G_MISS_NUM) = OKL_API.G_MISS_NUM AND

206: FETCH l_residual_value_csr INTO l_residual_value_rec;
207: CLOSE l_residual_value_csr;
208:
209:
210: If nvl(l_talv_rec.salvage_value,OKL_API.G_MISS_NUM) = OKL_API.G_MISS_NUM AND
211: nvl(l_talv_rec.percent_salvage_value, OKL_API.G_MISS_NUM) = OKL_API.G_MISS_NUM then
212: --Bug# 4186455 : Do not populate salvage value for Loan and loan revolving deal types
213: for l_deal_type_rec in l_deal_type_csr(p_chr_id => l_talv_rec.dnz_khr_id)
214: loop

Line 211: nvl(l_talv_rec.percent_salvage_value, OKL_API.G_MISS_NUM) = OKL_API.G_MISS_NUM then

207: CLOSE l_residual_value_csr;
208:
209:
210: If nvl(l_talv_rec.salvage_value,OKL_API.G_MISS_NUM) = OKL_API.G_MISS_NUM AND
211: nvl(l_talv_rec.percent_salvage_value, OKL_API.G_MISS_NUM) = OKL_API.G_MISS_NUM then
212: --Bug# 4186455 : Do not populate salvage value for Loan and loan revolving deal types
213: for l_deal_type_rec in l_deal_type_csr(p_chr_id => l_talv_rec.dnz_khr_id)
214: loop
215: If l_deal_type_rec.deal_type = 'LOAN' then

Line 216: If nvl(l_deal_type_rec.reporting_pdt_id,OKL_API.G_MISS_NUM) <> OKL_API.G_MISS_NUM then

212: --Bug# 4186455 : Do not populate salvage value for Loan and loan revolving deal types
213: for l_deal_type_rec in l_deal_type_csr(p_chr_id => l_talv_rec.dnz_khr_id)
214: loop
215: If l_deal_type_rec.deal_type = 'LOAN' then
216: If nvl(l_deal_type_rec.reporting_pdt_id,OKL_API.G_MISS_NUM) <> OKL_API.G_MISS_NUM then
217: for l_pdt_deal_rec in l_pdt_deal_csr(p_pdt_id => l_deal_type_rec.reporting_pdt_id)
218: loop
219: If l_pdt_deal_rec.deal_type = 'LEASEOP' then -- reporting pdt is operating lease
220:

Line 244: If nvl(l_talv_rec.deprn_rate,OKL_API.G_MISS_NUM) <> OKL_API.G_MISS_NUM then

240:
241: --Bug# 3657624 : Depreciation Rate should not be divided by 100
242: /*
243: --Bug# 3621663 : To support flat rate methods
244: If nvl(l_talv_rec.deprn_rate,OKL_API.G_MISS_NUM) <> OKL_API.G_MISS_NUM then
245: l_talv_rec.deprn_rate := l_talv_rec.deprn_rate/100;
246: End If;
247: --Bug# 3621663
248: */

Line 274: IF(OKL_LLA_UTIL_PVT.is_lease_contract(l_talv_rec.dnz_khr_id)= OKL_API.G_TRUE

270: */
271: OPEN c_get_cle_id;
272: FETCH c_get_cle_id INTO l_cle_id;
273: CLOSE c_get_cle_id;
274: IF(OKL_LLA_UTIL_PVT.is_lease_contract(l_talv_rec.dnz_khr_id)= OKL_API.G_TRUE
275: AND (l_talv_rec.corporate_book IS NOT NULL
276: AND l_talv_rec.corporate_book <> OKL_API.G_MISS_CHAR))THEN
277: raise_business_event(p_api_version => p_api_version,
278: p_init_msg_list => p_init_msg_list,

Line 276: AND l_talv_rec.corporate_book <> OKL_API.G_MISS_CHAR))THEN

272: FETCH c_get_cle_id INTO l_cle_id;
273: CLOSE c_get_cle_id;
274: IF(OKL_LLA_UTIL_PVT.is_lease_contract(l_talv_rec.dnz_khr_id)= OKL_API.G_TRUE
275: AND (l_talv_rec.corporate_book IS NOT NULL
276: AND l_talv_rec.corporate_book <> OKL_API.G_MISS_CHAR))THEN
277: raise_business_event(p_api_version => p_api_version,
278: p_init_msg_list => p_init_msg_list,
279: p_chr_id => l_talv_rec.dnz_khr_id,
280: p_asset_id => l_cle_id,

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

283: x_return_status => x_return_status,
284: x_msg_count => x_msg_count,
285: x_msg_data => x_msg_data
286: );
287: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
288: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
289: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
290: RAISE OKL_API.G_EXCEPTION_ERROR;
291: END IF;

Line 288: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

284: x_msg_count => x_msg_count,
285: x_msg_data => x_msg_data
286: );
287: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
288: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
289: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
290: RAISE OKL_API.G_EXCEPTION_ERROR;
291: END IF;
292: END IF;

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

285: x_msg_data => x_msg_data
286: );
287: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
288: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
289: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
290: RAISE OKL_API.G_EXCEPTION_ERROR;
291: END IF;
292: END IF;
293: /*

Line 290: RAISE OKL_API.G_EXCEPTION_ERROR;

286: );
287: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
288: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
289: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
290: RAISE OKL_API.G_EXCEPTION_ERROR;
291: END IF;
292: END IF;
293: /*
294: * sjalasut: aug 18, 04 added code to enable business event. END

Line 628: x_return_status := OKL_API.G_RET_STS_SUCCESS;

624: l_header_curr_conv_type OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_TYPE%TYPE;
625: l_header_curr_conv_date OKL_K_HEADERS_FULL_V.CURRENCY_CONVERSION_DATE%TYPE;
626:
627: BEGIN
628: x_return_status := OKL_API.G_RET_STS_SUCCESS;
629: -- Call start_activity to create savepoint, check compatibility
630: -- and initialize message list
631: x_return_status := OKC_API.START_ACTIVITY (l_api_name
632: ,p_init_msg_list

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

647: x_msg_count => x_msg_count,
648: x_msg_data => x_msg_data,
649: p_cle_id => p_talv_rec.kle_id);
650:
651: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
652: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
653: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
654: RAISE OKL_API.G_EXCEPTION_ERROR;
655: END IF;

Line 652: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

648: x_msg_data => x_msg_data,
649: p_cle_id => p_talv_rec.kle_id);
650:
651: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
652: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
653: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
654: RAISE OKL_API.G_EXCEPTION_ERROR;
655: END IF;
656: --Bug# 4959361

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

649: p_cle_id => p_talv_rec.kle_id);
650:
651: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
652: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
653: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
654: RAISE OKL_API.G_EXCEPTION_ERROR;
655: END IF;
656: --Bug# 4959361
657:

Line 654: RAISE OKL_API.G_EXCEPTION_ERROR;

650:
651: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
652: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
653: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
654: RAISE OKL_API.G_EXCEPTION_ERROR;
655: END IF;
656: --Bug# 4959361
657:
658: l_talv_rec := p_talv_rec;

Line 693: OKL_API.set_message(p_app_name => G_APP_NAME,

689: l_talv_rec := p_talv_rec;
690: OPEN c_get_currency_code(p_kle_id => l_talv_rec.kle_id);
691:
692: IF c_get_currency_code%NOTFOUND THEN
693: OKL_API.set_message(p_app_name => G_APP_NAME,
694: p_msg_name => G_LINE_RECORD);
695: RAISE OKL_API.G_EXCEPTION_ERROR;
696: END IF;
697: FETCH c_get_currency_code INTO l_currency_code;

Line 695: RAISE OKL_API.G_EXCEPTION_ERROR;

691:
692: IF c_get_currency_code%NOTFOUND THEN
693: OKL_API.set_message(p_app_name => G_APP_NAME,
694: p_msg_name => G_LINE_RECORD);
695: RAISE OKL_API.G_EXCEPTION_ERROR;
696: END IF;
697: FETCH c_get_currency_code INTO l_currency_code;
698: CLOSE c_get_currency_code;
699:

Line 708: OKL_API.set_message(p_app_name => G_APP_NAME,

704: OKL_ACCOUNTING_UTIL.CROSS_CURRENCY_ROUND_AMOUNT(l_talv_rec.depreciation_cost,
705: l_currency_code);
706:
707: IF (l_deprn_cost <> 0 AND l_talv_rec.depreciation_cost = 0) THEN
708: OKL_API.set_message(p_app_name => G_APP_NAME,
709: p_msg_name => G_AMOUNT_ROUNDING,
710: p_token1 => 'AMT',
711: p_token1_value => to_char(l_deprn_cost));
712: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 720: OKL_API.set_message(p_app_name => G_APP_NAME,

716: OKL_ACCOUNTING_UTIL.CROSS_CURRENCY_ROUND_AMOUNT(l_talv_rec.salvage_value,
717: l_currency_code);
718:
719: IF (l_salvage_value <> 0 AND l_talv_rec.salvage_value = 0) THEN
720: OKL_API.set_message(p_app_name => G_APP_NAME,
721: p_msg_name => G_AMOUNT_ROUNDING,
722: p_token1 => 'AMT',
723: p_token1_value => to_char(l_salvage_value));
724: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 733: If nvl(l_talv_rec.deprn_rate,OKL_API.G_MISS_NUM) <> OKL_API.G_MISS_NUM then

729:
730: --Bug# 3657624 : Depreciation Rate should not be divided by 100
731: /*
732: --Bug# 3621663 : To support flat rate methods
733: If nvl(l_talv_rec.deprn_rate,OKL_API.G_MISS_NUM) <> OKL_API.G_MISS_NUM then
734: l_talv_rec.deprn_rate := l_talv_rec.deprn_rate/100;
735: End If;
736: --Bug# 3621663
737: */

Line 759: If nvl(l_talv_rec.salvage_value,OKL_API.G_MISS_NUM) = OKL_API.G_MISS_NUM AND

755: OPEN l_residual_value_csr (p_talv_rec.kle_id);
756: FETCH l_residual_value_csr INTO l_residual_value_rec;
757: CLOSE l_residual_value_csr;
758:
759: If nvl(l_talv_rec.salvage_value,OKL_API.G_MISS_NUM) = OKL_API.G_MISS_NUM AND
760: nvl(l_talv_rec.percent_salvage_value, OKL_API.G_MISS_NUM) = OKL_API.G_MISS_NUM then
761: --Bug# 4186455 : Do not populate salvage value for Loan and loan revolving deal types
762:
763: for l_deal_type_rec in l_deal_type_csr(p_chr_id => l_contract_id)

Line 760: nvl(l_talv_rec.percent_salvage_value, OKL_API.G_MISS_NUM) = OKL_API.G_MISS_NUM then

756: FETCH l_residual_value_csr INTO l_residual_value_rec;
757: CLOSE l_residual_value_csr;
758:
759: If nvl(l_talv_rec.salvage_value,OKL_API.G_MISS_NUM) = OKL_API.G_MISS_NUM AND
760: nvl(l_talv_rec.percent_salvage_value, OKL_API.G_MISS_NUM) = OKL_API.G_MISS_NUM then
761: --Bug# 4186455 : Do not populate salvage value for Loan and loan revolving deal types
762:
763: for l_deal_type_rec in l_deal_type_csr(p_chr_id => l_contract_id)
764: loop

Line 767: If nvl(l_deal_type_rec.reporting_pdt_id,OKL_API.G_MISS_NUM) <> OKL_API.G_MISS_NUM then

763: for l_deal_type_rec in l_deal_type_csr(p_chr_id => l_contract_id)
764: loop
765:
766: If l_deal_type_rec.deal_type = 'LOAN' then
767: If nvl(l_deal_type_rec.reporting_pdt_id,OKL_API.G_MISS_NUM) <> OKL_API.G_MISS_NUM then
768: for l_pdt_deal_rec in l_pdt_deal_csr(p_pdt_id => l_deal_type_rec.reporting_pdt_id)
769: loop
770: If l_pdt_deal_rec.deal_type = 'LEASEOP' then -- reporting pdt is operating lease
771: IF l_talv_rec.salvage_value is null THEN

Line 820: (ln_chr_id <> OKL_API.G_MISS_NUM) THEN

816: CLOSE get_chr_id;
817: -- We need to change the status of the header whenever there is updating happening
818: -- after the contract status is approved
819: IF (ln_chr_id is NOT NULL) AND
820: (ln_chr_id <> OKL_API.G_MISS_NUM) THEN
821: --cascade edit status on to lines
822: okl_contract_status_pub.cascade_lease_status_edit
823: (p_api_version => p_api_version,
824: p_init_msg_list => p_init_msg_list,

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

825: x_return_status => x_return_status,
826: x_msg_count => x_msg_count,
827: x_msg_data => x_msg_data,
828: p_chr_id => ln_chr_id);
829: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
830: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
831: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
832: RAISE OKC_API.G_EXCEPTION_ERROR;
833: END IF;

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

827: x_msg_data => x_msg_data,
828: p_chr_id => ln_chr_id);
829: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
830: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
831: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
832: RAISE OKC_API.G_EXCEPTION_ERROR;
833: END IF;
834: END IF;
835: END IF;

Line 838: IF(OKL_LLA_UTIL_PVT.is_lease_contract(l_contract_id)= OKL_API.G_TRUE

834: END IF;
835: END IF;
836:
837: --vthiruva..fix for business events..30-Dec-2004..Start
838: IF(OKL_LLA_UTIL_PVT.is_lease_contract(l_contract_id)= OKL_API.G_TRUE
839: AND l_old_book_code IS NULL
840: AND (l_talv_rec.corporate_book IS NOT NULL
841: AND l_talv_rec.corporate_book <> OKL_API.G_MISS_CHAR))THEN
842: raise_business_event(p_api_version => p_api_version,

Line 841: AND l_talv_rec.corporate_book <> OKL_API.G_MISS_CHAR))THEN

837: --vthiruva..fix for business events..30-Dec-2004..Start
838: IF(OKL_LLA_UTIL_PVT.is_lease_contract(l_contract_id)= OKL_API.G_TRUE
839: AND l_old_book_code IS NULL
840: AND (l_talv_rec.corporate_book IS NOT NULL
841: AND l_talv_rec.corporate_book <> OKL_API.G_MISS_CHAR))THEN
842: raise_business_event(p_api_version => p_api_version,
843: p_init_msg_list => p_init_msg_list,
844: p_chr_id => l_contract_id,
845: p_asset_id => l_asset_id,

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

848: x_return_status => x_return_status,
849: x_msg_count => x_msg_count,
850: x_msg_data => x_msg_data
851: );
852: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
853: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
854: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
855: RAISE OKL_API.G_EXCEPTION_ERROR;
856: END IF;

Line 853: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

849: x_msg_count => x_msg_count,
850: x_msg_data => x_msg_data
851: );
852: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
853: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
854: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
855: RAISE OKL_API.G_EXCEPTION_ERROR;
856: END IF;
857: END IF;

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

850: x_msg_data => x_msg_data
851: );
852: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
853: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
854: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
855: RAISE OKL_API.G_EXCEPTION_ERROR;
856: END IF;
857: END IF;
858: --vthiruva..fix for business events..30-Dec-2004..end

Line 855: RAISE OKL_API.G_EXCEPTION_ERROR;

851: );
852: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
853: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
854: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
855: RAISE OKL_API.G_EXCEPTION_ERROR;
856: END IF;
857: END IF;
858: --vthiruva..fix for business events..30-Dec-2004..end
859:

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

926: x_msg_data => x_msg_data,
927: p_talv_rec => p_talv_tbl(p),
928: x_talv_rec => x_talv_tbl(p));
929:
930: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
931: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
932: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
933: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
934: END IF;

Line 931: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);

927: p_talv_rec => p_talv_tbl(p),
928: x_talv_rec => x_talv_tbl(p));
929:
930: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
931: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
932: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
933: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
934: END IF;
935: EXIT WHEN (p = p_talv_tbl.LAST);

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

928: x_talv_rec => x_talv_tbl(p));
929:
930: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
931: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
932: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
933: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
934: END IF;
935: EXIT WHEN (p = p_talv_tbl.LAST);
936: p := p_talv_tbl.NEXT(p);

Line 933: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);

929:
930: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
931: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
932: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
933: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
934: END IF;
935: EXIT WHEN (p = p_talv_tbl.LAST);
936: p := p_talv_tbl.NEXT(p);
937: END LOOP;

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

934: END IF;
935: EXIT WHEN (p = p_talv_tbl.LAST);
936: p := p_talv_tbl.NEXT(p);
937: END LOOP;
938: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
939: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
940: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
941: RAISE OKL_API.G_EXCEPTION_ERROR;
942: END IF;

Line 939: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

935: EXIT WHEN (p = p_talv_tbl.LAST);
936: p := p_talv_tbl.NEXT(p);
937: END LOOP;
938: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
939: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
940: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
941: RAISE OKL_API.G_EXCEPTION_ERROR;
942: END IF;
943: END IF;

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

936: p := p_talv_tbl.NEXT(p);
937: END LOOP;
938: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
939: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
940: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
941: RAISE OKL_API.G_EXCEPTION_ERROR;
942: END IF;
943: END IF;
944:

Line 941: RAISE OKL_API.G_EXCEPTION_ERROR;

937: END LOOP;
938: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
939: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
940: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
941: RAISE OKL_API.G_EXCEPTION_ERROR;
942: END IF;
943: END IF;
944:
945: -- End Modification

Line 1038: (ln_chr_id <> OKL_API.G_MISS_NUM) THEN

1034: CLOSE get_chr_id;
1035: -- We need to change the status of the header whenever there is updating happening
1036: -- after the contract status is approved
1037: IF (ln_chr_id is NOT NULL) AND
1038: (ln_chr_id <> OKL_API.G_MISS_NUM) THEN
1039: --cascade edit status on to lines
1040: okl_contract_status_pub.cascade_lease_status_edit
1041: (p_api_version => p_api_version,
1042: p_init_msg_list => p_init_msg_list,

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

1043: x_return_status => x_return_status,
1044: x_msg_count => x_msg_count,
1045: x_msg_data => x_msg_data,
1046: p_chr_id => ln_chr_id);
1047: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1048: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1049: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1050: RAISE OKC_API.G_EXCEPTION_ERROR;
1051: END IF;

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

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