DBA Data[Home] [Help]

APPS.OKL_TQD_PVT dependencies on OKL_API

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

791: x_return_status => x_return_status,
792: x_msg_count => x_msg_count,
793: x_msg_data => x_msg_data,
794: p_tqdv_rec => p_tqdv_tbl(i));
795: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
796: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
797: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
798: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
799: END IF;

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

792: x_msg_count => x_msg_count,
793: x_msg_data => x_msg_data,
794: p_tqdv_rec => p_tqdv_tbl(i));
795: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
796: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
797: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
798: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
799: END IF;
800: EXIT WHEN (i = p_tqdv_tbl.LAST);

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

793: x_msg_data => x_msg_data,
794: p_tqdv_rec => p_tqdv_tbl(i));
795: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
796: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
797: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
798: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
799: END IF;
800: EXIT WHEN (i = p_tqdv_tbl.LAST);
801: i := p_tqdv_tbl.NEXT(i);

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

794: p_tqdv_rec => p_tqdv_tbl(i));
795: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
796: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
797: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
798: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
799: END IF;
800: EXIT WHEN (i = p_tqdv_tbl.LAST);
801: i := p_tqdv_tbl.NEXT(i);
802: END LOOP;

Line 1024: x_return_status := OKL_API.START_ACTIVITY(l_api_name,

1020: x_tqdv_rec.OBJECT_VERSION_NUMBER := 1;
1021: RETURN(l_return_status);
1022: END Set_Attributes;
1023: BEGIN
1024: x_return_status := OKL_API.START_ACTIVITY(l_api_name,
1025: G_PKG_NAME,
1026: p_init_msg_list,
1027: l_api_version,
1028: p_api_version,

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

1138: x_msg_count => x_msg_count,
1139: x_msg_data => x_msg_data,
1140: p_tqdv_rec => p_tqdv_tbl(i),
1141: x_tqdv_rec => x_tqdv_tbl(i));
1142: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1143: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1144: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1145: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
1146: END IF;

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

1139: x_msg_data => x_msg_data,
1140: p_tqdv_rec => p_tqdv_tbl(i),
1141: x_tqdv_rec => x_tqdv_tbl(i));
1142: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1143: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1144: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1145: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
1146: END IF;
1147: EXIT WHEN (i = p_tqdv_tbl.LAST);

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

1140: p_tqdv_rec => p_tqdv_tbl(i),
1141: x_tqdv_rec => x_tqdv_tbl(i));
1142: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1143: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1144: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1145: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
1146: END IF;
1147: EXIT WHEN (i = p_tqdv_tbl.LAST);
1148: i := p_tqdv_tbl.NEXT(i);

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

1141: x_tqdv_rec => x_tqdv_tbl(i));
1142: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1143: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1144: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1145: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
1146: END IF;
1147: EXIT WHEN (i = p_tqdv_tbl.LAST);
1148: i := p_tqdv_tbl.NEXT(i);
1149: END LOOP;

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

1380: x_return_status => x_return_status,
1381: x_msg_count => x_msg_count,
1382: x_msg_data => x_msg_data,
1383: p_tqdv_rec => p_tqdv_tbl(i));
1384: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1385: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1386: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1387: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
1388: END IF;

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

1381: x_msg_count => x_msg_count,
1382: x_msg_data => x_msg_data,
1383: p_tqdv_rec => p_tqdv_tbl(i));
1384: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1385: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1386: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1387: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
1388: END IF;
1389: EXIT WHEN (i = p_tqdv_tbl.LAST);

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

1382: x_msg_data => x_msg_data,
1383: p_tqdv_rec => p_tqdv_tbl(i));
1384: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1385: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1386: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1387: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
1388: END IF;
1389: EXIT WHEN (i = p_tqdv_tbl.LAST);
1390: i := p_tqdv_tbl.NEXT(i);

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

1383: p_tqdv_rec => p_tqdv_tbl(i));
1384: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1385: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
1386: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1387: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
1388: END IF;
1389: EXIT WHEN (i = p_tqdv_tbl.LAST);
1390: i := p_tqdv_tbl.NEXT(i);
1391: END LOOP;

Line 1741: IF (x_tqdv_rec.object_version_number = OKL_API.G_MISS_NUM)

1737: IF (x_tqdv_rec.id = OKC_API.G_MISS_NUM)
1738: THEN
1739: x_tqdv_rec.id := l_db_tqdv_rec.id;
1740: END IF;
1741: IF (x_tqdv_rec.object_version_number = OKL_API.G_MISS_NUM)
1742: THEN
1743: x_tqdv_rec.object_version_number := l_db_tqdv_rec.object_version_number;
1744: END IF;
1745: IF (x_tqdv_rec.number_of_units = OKC_API.G_MISS_NUM)

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

2008: x_msg_count => x_msg_count,
2009: x_msg_data => x_msg_data,
2010: p_tqdv_rec => p_tqdv_tbl(i),
2011: x_tqdv_rec => x_tqdv_tbl(i));
2012: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2013: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2014: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2015: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2016: END IF;

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

2009: x_msg_data => x_msg_data,
2010: p_tqdv_rec => p_tqdv_tbl(i),
2011: x_tqdv_rec => x_tqdv_tbl(i));
2012: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2013: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2014: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2015: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2016: END IF;
2017: EXIT WHEN (i = p_tqdv_tbl.LAST);

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

2010: p_tqdv_rec => p_tqdv_tbl(i),
2011: x_tqdv_rec => x_tqdv_tbl(i));
2012: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2013: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2014: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2015: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2016: END IF;
2017: EXIT WHEN (i = p_tqdv_tbl.LAST);
2018: i := p_tqdv_tbl.NEXT(i);

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

2011: x_tqdv_rec => x_tqdv_tbl(i));
2012: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2013: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2014: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2015: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2016: END IF;
2017: EXIT WHEN (i = p_tqdv_tbl.LAST);
2018: i := p_tqdv_tbl.NEXT(i);
2019: END LOOP;

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

2207: x_return_status => x_return_status,
2208: x_msg_count => x_msg_count,
2209: x_msg_data => x_msg_data,
2210: p_tqdv_rec => p_tqdv_tbl(i));
2211: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2212: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2214: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2215: END IF;

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

2208: x_msg_count => x_msg_count,
2209: x_msg_data => x_msg_data,
2210: p_tqdv_rec => p_tqdv_tbl(i));
2211: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2212: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2214: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2215: END IF;
2216: EXIT WHEN (i = p_tqdv_tbl.LAST);

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

2209: x_msg_data => x_msg_data,
2210: p_tqdv_rec => p_tqdv_tbl(i));
2211: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2212: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2214: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2215: END IF;
2216: EXIT WHEN (i = p_tqdv_tbl.LAST);
2217: i := p_tqdv_tbl.NEXT(i);

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

2210: p_tqdv_rec => p_tqdv_tbl(i));
2211: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2212: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
2213: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2214: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
2215: END IF;
2216: EXIT WHEN (i = p_tqdv_tbl.LAST);
2217: i := p_tqdv_tbl.NEXT(i);
2218: END LOOP;