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

Line 291: IF (l_vipv_rec.request_id = Okl_Api.G_MISS_NUM) THEN

287: END IF;
288: IF (l_vipv_rec.rebook_status = OKC_API.G_MISS_CHAR ) THEN
289: l_vipv_rec.rebook_status := NULL;
290: END IF;
291: IF (l_vipv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
292: l_vipv_rec.request_id := NULL;
293: END IF;
294: IF (l_vipv_rec.program_application_id = Okl_Api.G_MISS_NUM) THEN
295: l_vipv_rec.program_application_id := NULL;

Line 294: IF (l_vipv_rec.program_application_id = Okl_Api.G_MISS_NUM) THEN

290: END IF;
291: IF (l_vipv_rec.request_id = Okl_Api.G_MISS_NUM) THEN
292: l_vipv_rec.request_id := NULL;
293: END IF;
294: IF (l_vipv_rec.program_application_id = Okl_Api.G_MISS_NUM) THEN
295: l_vipv_rec.program_application_id := NULL;
296: END IF;
297: IF (l_vipv_rec.program_id = Okl_Api.G_MISS_NUM) THEN
298: l_vipv_rec.program_id := NULL;

Line 297: IF (l_vipv_rec.program_id = Okl_Api.G_MISS_NUM) THEN

293: END IF;
294: IF (l_vipv_rec.program_application_id = Okl_Api.G_MISS_NUM) THEN
295: l_vipv_rec.program_application_id := NULL;
296: END IF;
297: IF (l_vipv_rec.program_id = Okl_Api.G_MISS_NUM) THEN
298: l_vipv_rec.program_id := NULL;
299: END IF;
300: IF (l_vipv_rec.program_update_date = Okl_Api.G_MISS_DATE) THEN
301: l_vipv_rec.program_update_date := NULL;

Line 300: IF (l_vipv_rec.program_update_date = Okl_Api.G_MISS_DATE) THEN

296: END IF;
297: IF (l_vipv_rec.program_id = Okl_Api.G_MISS_NUM) THEN
298: l_vipv_rec.program_id := NULL;
299: END IF;
300: IF (l_vipv_rec.program_update_date = Okl_Api.G_MISS_DATE) THEN
301: l_vipv_rec.program_update_date := NULL;
302: END IF;
303: IF (l_vipv_rec.org_id = Okl_Api.G_MISS_NUM) THEN
304: l_vipv_rec.org_id := NULL;

Line 303: IF (l_vipv_rec.org_id = Okl_Api.G_MISS_NUM) THEN

299: END IF;
300: IF (l_vipv_rec.program_update_date = Okl_Api.G_MISS_DATE) THEN
301: l_vipv_rec.program_update_date := NULL;
302: END IF;
303: IF (l_vipv_rec.org_id = Okl_Api.G_MISS_NUM) THEN
304: l_vipv_rec.org_id := NULL;
305: END IF;
306: IF (l_vipv_rec.attribute_category = OKC_API.G_MISS_CHAR ) THEN
307: l_vipv_rec.attribute_category := NULL;

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

754: x_return_status => x_return_status,
755: x_msg_count => x_msg_count,
756: x_msg_data => x_msg_data,
757: p_vipv_rec => p_vipv_tbl(i));
758: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
759: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
760: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
761: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
762: END IF;

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

755: x_msg_count => x_msg_count,
756: x_msg_data => x_msg_data,
757: p_vipv_rec => p_vipv_tbl(i));
758: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
759: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
760: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
761: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
762: END IF;
763: EXIT WHEN (i = p_vipv_tbl.LAST);

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

756: x_msg_data => x_msg_data,
757: p_vipv_rec => p_vipv_tbl(i));
758: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
759: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
760: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
761: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
762: END IF;
763: EXIT WHEN (i = p_vipv_tbl.LAST);
764: i := p_vipv_tbl.NEXT(i);

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

757: p_vipv_rec => p_vipv_tbl(i));
758: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
759: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
760: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
761: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
762: END IF;
763: EXIT WHEN (i = p_vipv_tbl.LAST);
764: i := p_vipv_tbl.NEXT(i);
765: END LOOP;

Line 837: IF (x_vip_rec.request_id IS NULL OR x_vip_rec.request_id = Okl_Api.G_MISS_NUM) THEN

833: BEGIN
834: x_vip_rec := p_vip_rec;
835: x_vip_rec.OBJECT_VERSION_NUMBER := 1;
836:
837: IF (x_vip_rec.request_id IS NULL OR x_vip_rec.request_id = Okl_Api.G_MISS_NUM) THEN
838: SELECT
839: DECODE(Fnd_Global.CONC_REQUEST_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
840: DECODE(Fnd_Global.PROG_APPL_ID,-1,NULL,Fnd_Global.CONC_REQUEST_ID),
841: DECODE(Fnd_Global.CONC_PROGRAM_ID,-1,NULL,Fnd_Global.CONC_PROGRAM_ID),

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

1144: x_msg_count => x_msg_count,
1145: x_msg_data => x_msg_data,
1146: p_vipv_rec => p_vipv_tbl(i),
1147: x_vipv_rec => x_vipv_tbl(i));
1148: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1149: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1150: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1151: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
1152: END IF;

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

1145: x_msg_data => x_msg_data,
1146: p_vipv_rec => p_vipv_tbl(i),
1147: x_vipv_rec => x_vipv_tbl(i));
1148: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1149: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1150: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1151: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
1152: END IF;
1153: EXIT WHEN (i = p_vipv_tbl.LAST);

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

1146: p_vipv_rec => p_vipv_tbl(i),
1147: x_vipv_rec => x_vipv_tbl(i));
1148: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1149: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1150: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1151: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
1152: END IF;
1153: EXIT WHEN (i = p_vipv_tbl.LAST);
1154: i := p_vipv_tbl.NEXT(i);

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

1147: x_vipv_rec => x_vipv_tbl(i));
1148: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1149: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1150: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1151: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
1152: END IF;
1153: EXIT WHEN (i = p_vipv_tbl.LAST);
1154: i := p_vipv_tbl.NEXT(i);
1155: END LOOP;

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

1410: x_return_status => x_return_status,
1411: x_msg_count => x_msg_count,
1412: x_msg_data => x_msg_data,
1413: p_vipv_rec => p_vipv_tbl(i));
1414: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1415: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1416: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1417: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
1418: END IF;

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

1411: x_msg_count => x_msg_count,
1412: x_msg_data => x_msg_data,
1413: p_vipv_rec => p_vipv_tbl(i));
1414: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1415: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1416: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1417: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
1418: END IF;
1419: EXIT WHEN (i = p_vipv_tbl.LAST);

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

1412: x_msg_data => x_msg_data,
1413: p_vipv_rec => p_vipv_tbl(i));
1414: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1415: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1416: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1417: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
1418: END IF;
1419: EXIT WHEN (i = p_vipv_tbl.LAST);
1420: i := p_vipv_tbl.NEXT(i);

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

1413: p_vipv_rec => p_vipv_tbl(i));
1414: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1415: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1416: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1417: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
1418: END IF;
1419: EXIT WHEN (i = p_vipv_tbl.LAST);
1420: i := p_vipv_tbl.NEXT(i);
1421: END LOOP;

Line 1516: IF (x_vip_rec.request_id = Okl_Api.G_MISS_NUM)

1512: IF (x_vip_rec.rebook_status = OKC_API.G_MISS_CHAR)
1513: THEN
1514: x_vip_rec.rebook_status := l_vip_rec.rebook_status;
1515: END IF;
1516: IF (x_vip_rec.request_id = Okl_Api.G_MISS_NUM)
1517: THEN
1518: x_vip_rec.request_id := l_vip_rec.request_id;
1519: END IF;
1520: IF (x_vip_rec.program_application_id = Okl_Api.G_MISS_NUM)

Line 1520: IF (x_vip_rec.program_application_id = Okl_Api.G_MISS_NUM)

1516: IF (x_vip_rec.request_id = Okl_Api.G_MISS_NUM)
1517: THEN
1518: x_vip_rec.request_id := l_vip_rec.request_id;
1519: END IF;
1520: IF (x_vip_rec.program_application_id = Okl_Api.G_MISS_NUM)
1521: THEN
1522: x_vip_rec.program_application_id := l_vip_rec.program_application_id;
1523: END IF;
1524: IF (x_vip_rec.program_id = Okl_Api.G_MISS_NUM)

Line 1524: IF (x_vip_rec.program_id = Okl_Api.G_MISS_NUM)

1520: IF (x_vip_rec.program_application_id = Okl_Api.G_MISS_NUM)
1521: THEN
1522: x_vip_rec.program_application_id := l_vip_rec.program_application_id;
1523: END IF;
1524: IF (x_vip_rec.program_id = Okl_Api.G_MISS_NUM)
1525: THEN
1526: x_vip_rec.program_id := l_vip_rec.program_id;
1527: END IF;
1528: IF (x_vip_rec.program_update_date = Okl_Api.G_MISS_DATE)

Line 1528: IF (x_vip_rec.program_update_date = Okl_Api.G_MISS_DATE)

1524: IF (x_vip_rec.program_id = Okl_Api.G_MISS_NUM)
1525: THEN
1526: x_vip_rec.program_id := l_vip_rec.program_id;
1527: END IF;
1528: IF (x_vip_rec.program_update_date = Okl_Api.G_MISS_DATE)
1529: THEN
1530: x_vip_rec.program_update_date := l_vip_rec.program_update_date;
1531: END IF;
1532: IF (x_vip_rec.org_id = Okl_Api.G_MISS_NUM)

Line 1532: IF (x_vip_rec.org_id = Okl_Api.G_MISS_NUM)

1528: IF (x_vip_rec.program_update_date = Okl_Api.G_MISS_DATE)
1529: THEN
1530: x_vip_rec.program_update_date := l_vip_rec.program_update_date;
1531: END IF;
1532: IF (x_vip_rec.org_id = Okl_Api.G_MISS_NUM)
1533: THEN
1534: x_vip_rec.org_id := l_vip_rec.org_id;
1535: END IF;
1536: IF (x_vip_rec.attribute_category = OKC_API.G_MISS_CHAR)

Line 1785: IF (x_vipv_rec.object_version_number = OKL_API.G_MISS_NUM)

1781: -- so it may be verified through LOCK_ROW.
1782: l_db_vipv_rec := get_rec(p_vipv_rec, l_return_status);
1783: IF (l_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1784: -- Post-TAPI changes - Added for object version compatibility for now
1785: IF (x_vipv_rec.object_version_number = OKL_API.G_MISS_NUM)
1786: THEN
1787: x_vipv_rec.object_version_number := l_db_vipv_rec.object_version_number;
1788: END IF;
1789: IF (x_vipv_rec.id = OKC_API.G_MISS_NUM)

Line 1809: IF (x_vipv_rec.request_id = Okl_Api.G_MISS_NUM)

1805: IF (x_vipv_rec.rebook_status = OKC_API.G_MISS_CHAR)
1806: THEN
1807: x_vipv_rec.rebook_status := l_db_vipv_rec.rebook_status;
1808: END IF;
1809: IF (x_vipv_rec.request_id = Okl_Api.G_MISS_NUM)
1810: THEN
1811: x_vipv_rec.request_id := l_db_vipv_rec.request_id;
1812: END IF;
1813: IF (x_vipv_rec.program_application_id = Okl_Api.G_MISS_NUM)

Line 1813: IF (x_vipv_rec.program_application_id = Okl_Api.G_MISS_NUM)

1809: IF (x_vipv_rec.request_id = Okl_Api.G_MISS_NUM)
1810: THEN
1811: x_vipv_rec.request_id := l_db_vipv_rec.request_id;
1812: END IF;
1813: IF (x_vipv_rec.program_application_id = Okl_Api.G_MISS_NUM)
1814: THEN
1815: x_vipv_rec.program_application_id := l_db_vipv_rec.program_application_id;
1816: END IF;
1817: IF (x_vipv_rec.program_id = Okl_Api.G_MISS_NUM)

Line 1817: IF (x_vipv_rec.program_id = Okl_Api.G_MISS_NUM)

1813: IF (x_vipv_rec.program_application_id = Okl_Api.G_MISS_NUM)
1814: THEN
1815: x_vipv_rec.program_application_id := l_db_vipv_rec.program_application_id;
1816: END IF;
1817: IF (x_vipv_rec.program_id = Okl_Api.G_MISS_NUM)
1818: THEN
1819: x_vipv_rec.program_id := l_db_vipv_rec.program_id;
1820: END IF;
1821: IF (x_vipv_rec.program_update_date = Okl_Api.G_MISS_DATE)

Line 1821: IF (x_vipv_rec.program_update_date = Okl_Api.G_MISS_DATE)

1817: IF (x_vipv_rec.program_id = Okl_Api.G_MISS_NUM)
1818: THEN
1819: x_vipv_rec.program_id := l_db_vipv_rec.program_id;
1820: END IF;
1821: IF (x_vipv_rec.program_update_date = Okl_Api.G_MISS_DATE)
1822: THEN
1823: x_vipv_rec.program_update_date := l_db_vipv_rec.program_update_date;
1824: END IF;
1825: IF (x_vipv_rec.org_id = Okl_Api.G_MISS_NUM)

Line 1825: IF (x_vipv_rec.org_id = Okl_Api.G_MISS_NUM)

1821: IF (x_vipv_rec.program_update_date = Okl_Api.G_MISS_DATE)
1822: THEN
1823: x_vipv_rec.program_update_date := l_db_vipv_rec.program_update_date;
1824: END IF;
1825: IF (x_vipv_rec.org_id = Okl_Api.G_MISS_NUM)
1826: THEN
1827: x_vipv_rec.org_id := l_db_vipv_rec.org_id;
1828: END IF;
1829: IF (x_vipv_rec.attribute_category = OKC_API.G_MISS_CHAR)

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

2070: x_msg_count => x_msg_count,
2071: x_msg_data => x_msg_data,
2072: p_vipv_rec => p_vipv_tbl(i),
2073: x_vipv_rec => x_vipv_tbl(i));
2074: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2075: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2076: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2077: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2078: END IF;

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

2071: x_msg_data => x_msg_data,
2072: p_vipv_rec => p_vipv_tbl(i),
2073: x_vipv_rec => x_vipv_tbl(i));
2074: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2075: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2076: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2077: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2078: END IF;
2079: EXIT WHEN (i = p_vipv_tbl.LAST);

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

2072: p_vipv_rec => p_vipv_tbl(i),
2073: x_vipv_rec => x_vipv_tbl(i));
2074: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2075: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2076: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2077: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2078: END IF;
2079: EXIT WHEN (i = p_vipv_tbl.LAST);
2080: i := p_vipv_tbl.NEXT(i);

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

2073: x_vipv_rec => x_vipv_tbl(i));
2074: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2075: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2076: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2077: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2078: END IF;
2079: EXIT WHEN (i = p_vipv_tbl.LAST);
2080: i := p_vipv_tbl.NEXT(i);
2081: END LOOP;

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

2293: x_return_status => x_return_status,
2294: x_msg_count => x_msg_count,
2295: x_msg_data => x_msg_data,
2296: p_vipv_rec => p_vipv_tbl(i));
2297: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2298: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2299: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2300: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2301: END IF;

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

2294: x_msg_count => x_msg_count,
2295: x_msg_data => x_msg_data,
2296: p_vipv_rec => p_vipv_tbl(i));
2297: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2298: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2299: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2300: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2301: END IF;
2302: EXIT WHEN (i = p_vipv_tbl.LAST);

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

2295: x_msg_data => x_msg_data,
2296: p_vipv_rec => p_vipv_tbl(i));
2297: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2298: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2299: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2300: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2301: END IF;
2302: EXIT WHEN (i = p_vipv_tbl.LAST);
2303: i := p_vipv_tbl.NEXT(i);

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

2296: p_vipv_rec => p_vipv_tbl(i));
2297: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2298: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2299: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2300: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2301: END IF;
2302: EXIT WHEN (i = p_vipv_tbl.LAST);
2303: i := p_vipv_tbl.NEXT(i);
2304: END LOOP;