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_FUNDING_CHECKLIST_PVT dependencies on OKC_API

Line 605: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

601: p_rulv_migr_rec => p_rulv_migr_tbl(i),
602: p_mode => p_mode
603: );
604:
605: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
606: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
607: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
608: raise OKC_API.G_EXCEPTION_ERROR;
609: End If;

Line 606: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

602: p_mode => p_mode
603: );
604:
605: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
606: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
607: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
608: raise OKC_API.G_EXCEPTION_ERROR;
609: End If;
610:

Line 607: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

603: );
604:
605: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
606: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
607: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
608: raise OKC_API.G_EXCEPTION_ERROR;
609: End If;
610:
611: EXIT WHEN (i = p_rulv_tbl.LAST);

Line 608: raise OKC_API.G_EXCEPTION_ERROR;

604:
605: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
606: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
607: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
608: raise OKC_API.G_EXCEPTION_ERROR;
609: End If;
610:
611: EXIT WHEN (i = p_rulv_tbl.LAST);
612: i := p_rulv_tbl.NEXT(i);

Line 765: l_chr_id okc_k_headers_b.id%type := OKC_API.G_MISS_NUM;

761: l_lease_app_list_found boolean := FALSE;
762: l_lease_app_found_str VARCHAR2(10);
763: l_lease_app_list_found_str VARCHAR2(10);
764: l_funding_checklist_tpl okc_rules_b.rule_information2%TYPE;
765: l_chr_id okc_k_headers_b.id%type := OKC_API.G_MISS_NUM;
766: l_rgpv_id okc_rule_groups_b.id%type;
767: l_grp_row_not_found boolean;
768: lp_rgpv_rec okl_okc_migration_pvt.rgpv_rec_type;
769: lx_rgpv_rec okl_okc_migration_pvt.rgpv_rec_type;

Line 825: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

821: x_funding_checklist_tpl => l_funding_checklist_tpl,
822: x_lease_app_id => x_lease_app_id,
823: x_credit_id => x_credit_id);
824:
825: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
826: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
827: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
828: raise OKC_API.G_EXCEPTION_ERROR;
829: End If;

Line 826: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

822: x_lease_app_id => x_lease_app_id,
823: x_credit_id => x_credit_id);
824:
825: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
826: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
827: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
828: raise OKC_API.G_EXCEPTION_ERROR;
829: End If;
830:

Line 827: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

823: x_credit_id => x_credit_id);
824:
825: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
826: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
827: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
828: raise OKC_API.G_EXCEPTION_ERROR;
829: End If;
830:
831: IF (l_lease_app_found_str = 'TRUE') THEN

Line 828: raise OKC_API.G_EXCEPTION_ERROR;

824:
825: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
826: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
827: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
828: raise OKC_API.G_EXCEPTION_ERROR;
829: End If;
830:
831: IF (l_lease_app_found_str = 'TRUE') THEN
832: l_lease_app_found := TRUE;

Line 863: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

859: x_msg_data => x_msg_data,
860: p_rgpv_rec => lp_rgpv_rec,
861: x_rgpv_rec => lx_rgpv_rec);
862:
863: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
864: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
865: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
866: raise OKC_API.G_EXCEPTION_ERROR;
867: End If;

Line 864: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

860: p_rgpv_rec => lp_rgpv_rec,
861: x_rgpv_rec => lx_rgpv_rec);
862:
863: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
864: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
865: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
866: raise OKC_API.G_EXCEPTION_ERROR;
867: End If;
868:

Line 865: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

861: x_rgpv_rec => lx_rgpv_rec);
862:
863: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
864: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
865: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
866: raise OKC_API.G_EXCEPTION_ERROR;
867: End If;
868:
869: l_rgpv_id := lx_rgpv_rec.id;

Line 866: raise OKC_API.G_EXCEPTION_ERROR;

862:
863: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
864: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
865: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
866: raise OKC_API.G_EXCEPTION_ERROR;
867: End If;
868:
869: l_rgpv_id := lx_rgpv_rec.id;
870: END IF;

Line 887: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

883: p_rulv_migr_tbl => lp_rulv_tbl,
884: p_mode => G_INSERT_MODE
885: );
886:
887: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
888: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
889: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
890: raise OKC_API.G_EXCEPTION_ERROR;
891: End If;

Line 888: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

884: p_mode => G_INSERT_MODE
885: );
886:
887: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
888: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
889: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
890: raise OKC_API.G_EXCEPTION_ERROR;
891: End If;
892:

Line 889: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

885: );
886:
887: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
888: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
889: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
890: raise OKC_API.G_EXCEPTION_ERROR;
891: End If;
892:
893: --DBMS_OUTPUT.PUT_LINE('after copy_rulv_tbl');

Line 890: raise OKC_API.G_EXCEPTION_ERROR;

886:
887: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
888: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
889: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
890: raise OKC_API.G_EXCEPTION_ERROR;
891: End If;
892:
893: --DBMS_OUTPUT.PUT_LINE('after copy_rulv_tbl');
894: -- validation

Line 905: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

901: x_msg_data => x_msg_data,
902: p_rulv_tbl => lp_rulv_tbl,
903: x_rulv_tbl => lx_rulv_tbl);
904:
905: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
906: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
907: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
908: raise OKC_API.G_EXCEPTION_ERROR;
909: End If;

Line 906: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

902: p_rulv_tbl => lp_rulv_tbl,
903: x_rulv_tbl => lx_rulv_tbl);
904:
905: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
906: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
907: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
908: raise OKC_API.G_EXCEPTION_ERROR;
909: End If;
910:

Line 907: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

903: x_rulv_tbl => lx_rulv_tbl);
904:
905: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
906: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
907: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
908: raise OKC_API.G_EXCEPTION_ERROR;
909: End If;
910:
911: l_return_status := validate_hdr_attr_aftimg(p_rulv_rec => p_rulv_tbl(p_rulv_tbl.FIRST));

Line 908: raise OKC_API.G_EXCEPTION_ERROR;

904:
905: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
906: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
907: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
908: raise OKC_API.G_EXCEPTION_ERROR;
909: End If;
910:
911: l_return_status := validate_hdr_attr_aftimg(p_rulv_rec => p_rulv_tbl(p_rulv_tbl.FIRST));
912: --- Store the highest degree of error

Line 1023: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1019: p_rulv_migr_tbl => lp_rulv_tbl,
1020: p_mode => G_UPDATE_MODE
1021: );
1022:
1023: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1024: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1025: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1026: raise OKC_API.G_EXCEPTION_ERROR;
1027: End If;

Line 1024: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1020: p_mode => G_UPDATE_MODE
1021: );
1022:
1023: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1024: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1025: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1026: raise OKC_API.G_EXCEPTION_ERROR;
1027: End If;
1028:

Line 1025: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

1021: );
1022:
1023: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1024: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1025: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1026: raise OKC_API.G_EXCEPTION_ERROR;
1027: End If;
1028:
1029: --DBMS_OUTPUT.PUT_LINE('after copy_rulv_tbl');

Line 1026: raise OKC_API.G_EXCEPTION_ERROR;

1022:
1023: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1024: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1025: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1026: raise OKC_API.G_EXCEPTION_ERROR;
1027: End If;
1028:
1029: --DBMS_OUTPUT.PUT_LINE('after copy_rulv_tbl');
1030: -- validation

Line 1041: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1037: x_msg_data => x_msg_data,
1038: p_rulv_tbl => lp_rulv_tbl,
1039: x_rulv_tbl => lx_rulv_tbl);
1040:
1041: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1042: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1043: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1044: raise OKC_API.G_EXCEPTION_ERROR;
1045: End If;

Line 1042: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1038: p_rulv_tbl => lp_rulv_tbl,
1039: x_rulv_tbl => lx_rulv_tbl);
1040:
1041: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1042: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1043: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1044: raise OKC_API.G_EXCEPTION_ERROR;
1045: End If;
1046:

Line 1043: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

1039: x_rulv_tbl => lx_rulv_tbl);
1040:
1041: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1042: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1043: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1044: raise OKC_API.G_EXCEPTION_ERROR;
1045: End If;
1046:
1047: l_return_status := validate_hdr_attr_aftimg(p_rulv_rec => p_rulv_tbl(p_rulv_tbl.FIRST));

Line 1044: raise OKC_API.G_EXCEPTION_ERROR;

1040:
1041: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1042: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1043: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1044: raise OKC_API.G_EXCEPTION_ERROR;
1045: End If;
1046:
1047: l_return_status := validate_hdr_attr_aftimg(p_rulv_rec => p_rulv_tbl(p_rulv_tbl.FIRST));
1048: --- Store the highest degree of error

Line 1158: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1154: p_rulv_migr_tbl => lp_rulv_tbl,
1155: p_mode => G_DELETE_MODE
1156: );
1157:
1158: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1159: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1160: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1161: raise OKC_API.G_EXCEPTION_ERROR;
1162: End If;

Line 1159: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1155: p_mode => G_DELETE_MODE
1156: );
1157:
1158: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1159: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1160: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1161: raise OKC_API.G_EXCEPTION_ERROR;
1162: End If;
1163:

Line 1160: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

1156: );
1157:
1158: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1159: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1160: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1161: raise OKC_API.G_EXCEPTION_ERROR;
1162: End If;
1163:
1164: --DBMS_OUTPUT.PUT_LINE('after copy_rulv_tbl');

Line 1161: raise OKC_API.G_EXCEPTION_ERROR;

1157:
1158: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1159: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1160: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1161: raise OKC_API.G_EXCEPTION_ERROR;
1162: End If;
1163:
1164: --DBMS_OUTPUT.PUT_LINE('after copy_rulv_tbl');
1165:

Line 1174: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1170: x_msg_count => x_msg_count,
1171: x_msg_data => x_msg_data,
1172: p_rulv_tbl => lp_rulv_tbl);
1173:
1174: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1175: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1176: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1177: raise OKC_API.G_EXCEPTION_ERROR;
1178: End If;

Line 1175: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1171: x_msg_data => x_msg_data,
1172: p_rulv_tbl => lp_rulv_tbl);
1173:
1174: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1175: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1176: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1177: raise OKC_API.G_EXCEPTION_ERROR;
1178: End If;
1179:

Line 1176: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

1172: p_rulv_tbl => lp_rulv_tbl);
1173:
1174: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1175: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1176: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1177: raise OKC_API.G_EXCEPTION_ERROR;
1178: End If;
1179:
1180: /*** End API body ******************************************************/

Line 1177: raise OKC_API.G_EXCEPTION_ERROR;

1173:
1174: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1175: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1176: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1177: raise OKC_API.G_EXCEPTION_ERROR;
1178: End If;
1179:
1180: /*** End API body ******************************************************/
1181:

Line 1413: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1409: x_msg_data => x_msg_data,
1410: p_rulv_tbl => lp_rulv_tbl,
1411: x_rulv_tbl => lx_rulv_tbl);
1412:
1413: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1414: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1415: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1416: raise OKC_API.G_EXCEPTION_ERROR;
1417: End If;

Line 1414: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1410: p_rulv_tbl => lp_rulv_tbl,
1411: x_rulv_tbl => lx_rulv_tbl);
1412:
1413: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1414: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1415: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1416: raise OKC_API.G_EXCEPTION_ERROR;
1417: End If;
1418:

Line 1415: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

1411: x_rulv_tbl => lx_rulv_tbl);
1412:
1413: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1414: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1415: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1416: raise OKC_API.G_EXCEPTION_ERROR;
1417: End If;
1418:
1419: /*** End API body ******************************************************/

Line 1416: raise OKC_API.G_EXCEPTION_ERROR;

1412:
1413: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1414: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1415: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1416: raise OKC_API.G_EXCEPTION_ERROR;
1417: End If;
1418:
1419: /*** End API body ******************************************************/
1420: