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

Line 11: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

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:

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

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

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

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;

Line 706: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

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

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:

Line 708: RAISE OKL_API.G_EXCEPTION_ERROR;

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);

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

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;

Line 780: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

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

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;

Line 782: RAISE OKL_API.G_EXCEPTION_ERROR;

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;

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

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;

Line 798: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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);

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

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;

Line 800: RAISE OKL_API.G_EXCEPTION_ERROR;

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:

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

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

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

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;

Line 1010: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

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

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);

Line 1012: RAISE OKL_API.G_EXCEPTION_ERROR;

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;

Line 1036: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

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;

Line 1037: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

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;

Line 1038: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

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:

Line 1039: RAISE Okl_Api.G_EXCEPTION_ERROR;

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

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

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

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

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;

Line 1167: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

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

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;

Line 1169: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

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;

Line 1186: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

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

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);

Line 1188: RAISE OKL_API.G_EXCEPTION_ERROR;

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;

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

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

Line 1288: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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;

Line 1314: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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(

Line 1317: when OKL_API.G_EXCEPTION_ERROR then

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',

Line 1318: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 1326: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

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',

Line 1327: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 1336: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

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,