7: G_EXCEPTION_STOP_VALIDATION EXCEPTION;
8:
9:
10: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SEC_PARTIES_PVT';
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
12: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
13: l_api_name VARCHAR2(35) := 'SEC_PARTIES';
14:
15:
533: EXIT WHEN (i >= p_inv_tbl.last);
534: END LOOP;
535:
536: --Call End Activity
537: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
538: x_msg_data => x_msg_data);
539:
540:
541: EXCEPTION
701: x_msg_data => x_msg_data,
702: p_cplv_rec => l_cplv_rec);
703:
704:
705: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
706: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
707: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
708: RAISE OKL_API.G_EXCEPTION_ERROR;
709: END IF;
702: p_cplv_rec => l_cplv_rec);
703:
704:
705: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
706: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
707: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
708: RAISE OKL_API.G_EXCEPTION_ERROR;
709: END IF;
710:
703:
704:
705: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
706: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
707: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
708: RAISE OKL_API.G_EXCEPTION_ERROR;
709: END IF;
710:
711:
704:
705: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
706: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
707: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
708: RAISE OKL_API.G_EXCEPTION_ERROR;
709: END IF;
710:
711:
712: --dbms_output.put_line('l_count '||l_count);
775:
776: -- insert into okl_sec_temp values ('4 ',l_cplv_rec.dnz_chr_id, lx_currency_code, lx_org_id, to_char(l_klev_rec.AMOUNT));
777:
778:
779: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
780: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
781: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
782: RAISE OKL_API.G_EXCEPTION_ERROR;
783: END IF;
776: -- insert into okl_sec_temp values ('4 ',l_cplv_rec.dnz_chr_id, lx_currency_code, lx_org_id, to_char(l_klev_rec.AMOUNT));
777:
778:
779: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
780: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
781: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
782: RAISE OKL_API.G_EXCEPTION_ERROR;
783: END IF;
784:
777:
778:
779: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
780: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
781: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
782: RAISE OKL_API.G_EXCEPTION_ERROR;
783: END IF;
784:
785: l_cplv_rec.rle_code := G_INVESTOR_RLE_CODE;
778:
779: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
780: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
781: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
782: RAISE OKL_API.G_EXCEPTION_ERROR;
783: END IF;
784:
785: l_cplv_rec.rle_code := G_INVESTOR_RLE_CODE;
786: l_cplv_rec.jtot_object1_code := G_INVESTOR_OBJECT_CODE;
793: x_msg_data,
794: l_cplv_rec,
795: lx_cplv_rec);
796:
797: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
798: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
799: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
800: RAISE OKL_API.G_EXCEPTION_ERROR;
801: END IF;
794: l_cplv_rec,
795: lx_cplv_rec);
796:
797: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
798: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
799: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
800: RAISE OKL_API.G_EXCEPTION_ERROR;
801: END IF;
802: EXIT WHEN (i >= p_inv_tbl.last);
795: lx_cplv_rec);
796:
797: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
798: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
799: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
800: RAISE OKL_API.G_EXCEPTION_ERROR;
801: END IF;
802: EXIT WHEN (i >= p_inv_tbl.last);
803: END LOOP;
796:
797: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
798: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
799: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
800: RAISE OKL_API.G_EXCEPTION_ERROR;
801: END IF;
802: EXIT WHEN (i >= p_inv_tbl.last);
803: END LOOP;
804:
802: EXIT WHEN (i >= p_inv_tbl.last);
803: END LOOP;
804:
805: --Call End Activity
806: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
807: x_msg_data => x_msg_data);
808:
809:
810: EXCEPTION
1005:
1006: -- insert into okl_sec_temp values ('u4 ',l_cplv_rec.dnz_chr_id, lx_currency_code, lx_org_id, x_inv_tbl(1).description);
1007:
1008:
1009: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1010: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1011: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1012: RAISE OKL_API.G_EXCEPTION_ERROR;
1013: END IF;
1006: -- insert into okl_sec_temp values ('u4 ',l_cplv_rec.dnz_chr_id, lx_currency_code, lx_org_id, x_inv_tbl(1).description);
1007:
1008:
1009: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1010: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1011: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1012: RAISE OKL_API.G_EXCEPTION_ERROR;
1013: END IF;
1014:
1007:
1008:
1009: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1010: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1011: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1012: RAISE OKL_API.G_EXCEPTION_ERROR;
1013: END IF;
1014:
1015: EXIT WHEN (i >= p_inv_tbl.last);
1008:
1009: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1010: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1011: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1012: RAISE OKL_API.G_EXCEPTION_ERROR;
1013: END IF;
1014:
1015: EXIT WHEN (i >= p_inv_tbl.last);
1016: END LOOP;
1032: ,x_msg_data => x_msg_data
1033: ,p_poxv_rec => lp_poxv_rec
1034: ,x_poxv_rec => lx_poxv_rec);
1035:
1036: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1037: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1038: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1039: RAISE Okl_Api.G_EXCEPTION_ERROR;
1040: END IF;
1033: ,p_poxv_rec => lp_poxv_rec
1034: ,x_poxv_rec => lx_poxv_rec);
1035:
1036: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1037: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1038: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1039: RAISE Okl_Api.G_EXCEPTION_ERROR;
1040: END IF;
1041: END IF;
1034: ,x_poxv_rec => lx_poxv_rec);
1035:
1036: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1037: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1038: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1039: RAISE Okl_Api.G_EXCEPTION_ERROR;
1040: END IF;
1041: END IF;
1042:
1035:
1036: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1037: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1038: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1039: RAISE Okl_Api.G_EXCEPTION_ERROR;
1040: END IF;
1041: END IF;
1042:
1043: --Call End Activity
1040: END IF;
1041: END IF;
1042:
1043: --Call End Activity
1044: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1045: x_msg_data => x_msg_data);
1046:
1047:
1048: EXCEPTION
1162: x_msg_count => x_msg_count,
1163: x_msg_data => x_msg_data,
1164: p_fee_types_rec => l_fee_rec) ;
1165:
1166: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1167: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1168: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1169: RAISE OKL_API.G_EXCEPTION_ERROR;
1170: END IF;
1163: x_msg_data => x_msg_data,
1164: p_fee_types_rec => l_fee_rec) ;
1165:
1166: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1167: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1168: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1169: RAISE OKL_API.G_EXCEPTION_ERROR;
1170: END IF;
1171:
1164: p_fee_types_rec => l_fee_rec) ;
1165:
1166: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1167: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1168: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1169: RAISE OKL_API.G_EXCEPTION_ERROR;
1170: END IF;
1171:
1172: END LOOP;
1165:
1166: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1167: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1168: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1169: RAISE OKL_API.G_EXCEPTION_ERROR;
1170: END IF;
1171:
1172: END LOOP;
1173: -- gboomina Bug 6814331 - End
1181: x_msg_count => x_msg_count,
1182: x_msg_data => x_msg_data,
1183: p_line_id => p_inv_tbl(i).cle_id);
1184:
1185: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1186: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1187: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1188: RAISE OKL_API.G_EXCEPTION_ERROR;
1189: END IF;
1182: x_msg_data => x_msg_data,
1183: p_line_id => p_inv_tbl(i).cle_id);
1184:
1185: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1186: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1187: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1188: RAISE OKL_API.G_EXCEPTION_ERROR;
1189: END IF;
1190:
1183: p_line_id => p_inv_tbl(i).cle_id);
1184:
1185: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1186: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1187: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1188: RAISE OKL_API.G_EXCEPTION_ERROR;
1189: END IF;
1190:
1191: EXIT WHEN (i >= p_inv_tbl.last);
1184:
1185: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1186: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1187: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1188: RAISE OKL_API.G_EXCEPTION_ERROR;
1189: END IF;
1190:
1191: EXIT WHEN (i >= p_inv_tbl.last);
1192: END LOOP;
1191: EXIT WHEN (i >= p_inv_tbl.last);
1192: END LOOP;
1193:
1194: --Call End Activity
1195: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1196: x_msg_data => x_msg_data);
1197:
1198:
1199: EXCEPTION
1284:
1285: OPEN chr_csr( p_chr_id );
1286: FETCH chr_csr INTO CHR_REC;
1287: if (chr_csr%NOTFOUND ) Then
1288: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1289: End If;
1290: CLOSE chr_csr;
1291:
1292: x_hdr_tbl(1) := CHR_REC.ID;
1310: Else
1311: x_hdr_tbl(1) := 'GET_FROM_REQUEST';
1312: End if;
1313:
1314: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1315:
1316: Exception
1317: when OKL_API.G_EXCEPTION_ERROR then
1318: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1313:
1314: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1315:
1316: Exception
1317: when OKL_API.G_EXCEPTION_ERROR then
1318: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1319: p_api_name => l_api_name,
1320: p_pkg_name => g_pkg_name,
1321: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1314: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1315:
1316: Exception
1317: when OKL_API.G_EXCEPTION_ERROR then
1318: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1319: p_api_name => l_api_name,
1320: p_pkg_name => g_pkg_name,
1321: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1322: x_msg_count => x_msg_count,
1317: when OKL_API.G_EXCEPTION_ERROR then
1318: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1319: p_api_name => l_api_name,
1320: p_pkg_name => g_pkg_name,
1321: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
1322: x_msg_count => x_msg_count,
1323: x_msg_data => x_msg_data,
1324: p_api_type => g_api_type);
1325:
1322: x_msg_count => x_msg_count,
1323: x_msg_data => x_msg_data,
1324: p_api_type => g_api_type);
1325:
1326: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1327: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1328: p_api_name => l_api_name,
1329: p_pkg_name => g_pkg_name,
1330: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1323: x_msg_data => x_msg_data,
1324: p_api_type => g_api_type);
1325:
1326: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1327: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1328: p_api_name => l_api_name,
1329: p_pkg_name => g_pkg_name,
1330: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1331: x_msg_count => x_msg_count,
1326: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
1327: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1328: p_api_name => l_api_name,
1329: p_pkg_name => g_pkg_name,
1330: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
1331: x_msg_count => x_msg_count,
1332: x_msg_data => x_msg_data,
1333: p_api_type => g_api_type);
1334:
1332: x_msg_data => x_msg_data,
1333: p_api_type => g_api_type);
1334:
1335: when OTHERS then
1336: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
1337: p_api_name => l_api_name,
1338: p_pkg_name => g_pkg_name,
1339: p_exc_name => 'OTHERS',
1340: x_msg_count => x_msg_count,