DBA Data[Home] [Help]

APPS.OKL_BPD_CAP_PURPOSE_PVT dependencies on OKL_API

Line 150: l_rcav_tbl(i).sty_id = Okl_Api.G_MISS_NUM ) THEN

146: LOOP
147: l_rcav_tbl(i).rct_id_details := l_rct_id_details;
148: l_rcav_tbl(i).sty_id := l_strm_tbl(j).sty_id;
149: IF (l_rcav_tbl(i).sty_id = NULL OR
150: l_rcav_tbl(i).sty_id = Okl_Api.G_MISS_NUM ) THEN
151: x_return_status := OKC_API.G_RET_STS_ERROR;
152: OKC_API.set_message( p_app_name => G_APP_NAME,
153: p_msg_name =>'OKL_BPD_RCPT_ALLOC_ERR');
154: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 177: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

173: x_rcav_tbl
174: );
175:
176: x_return_status := l_return_status;
177: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
178: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
179: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
180: RAISE OKL_API.G_EXCEPTION_ERROR;
181: END IF;

Line 178: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

174: );
175:
176: x_return_status := l_return_status;
177: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
178: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
179: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
180: RAISE OKL_API.G_EXCEPTION_ERROR;
181: END IF;
182:

Line 179: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

175:
176: x_return_status := l_return_status;
177: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
178: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
179: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
180: RAISE OKL_API.G_EXCEPTION_ERROR;
181: END IF;
182:
183: -- exceptions........

Line 180: RAISE OKL_API.G_EXCEPTION_ERROR;

176: x_return_status := l_return_status;
177: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
178: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
179: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
180: RAISE OKL_API.G_EXCEPTION_ERROR;
181: END IF;
182:
183: -- exceptions........
184:

Line 309: l_rcav_tbl(i).sty_id = Okl_Api.G_MISS_NUM ) THEN

305: LOOP
306: l_rcav_tbl(i).id := l_strm_tbl(j).id;
307: l_rcav_tbl(i).sty_id := l_strm_tbl(j).sty_id;
308: IF (l_rcav_tbl(i).sty_id = NULL OR
309: l_rcav_tbl(i).sty_id = Okl_Api.G_MISS_NUM ) THEN
310: x_return_status := OKC_API.G_RET_STS_ERROR;
311: OKC_API.set_message( p_app_name => G_APP_NAME,
312: p_msg_name =>'OKL_BPD_RCPT_ALLOC_ERR');
313: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 333: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

329: x_rcav_tbl
330: );
331:
332: x_return_status := l_return_status;
333: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
334: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
335: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
336: RAISE OKL_API.G_EXCEPTION_ERROR;
337: END IF;

Line 334: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

330: );
331:
332: x_return_status := l_return_status;
333: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
334: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
335: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
336: RAISE OKL_API.G_EXCEPTION_ERROR;
337: END IF;
338:

Line 335: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

331:
332: x_return_status := l_return_status;
333: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
334: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
335: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
336: RAISE OKL_API.G_EXCEPTION_ERROR;
337: END IF;
338:
339: -- exceptions........

Line 336: RAISE OKL_API.G_EXCEPTION_ERROR;

332: x_return_status := l_return_status;
333: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
334: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
335: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
336: RAISE OKL_API.G_EXCEPTION_ERROR;
337: END IF;
338:
339: -- exceptions........
340:

Line 483: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

479: l_rcav_tbl
480: );
481:
482: x_return_status := l_return_status;
483: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
484: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
485: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
486: RAISE OKL_API.G_EXCEPTION_ERROR;
487: END IF;

Line 484: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

480: );
481:
482: x_return_status := l_return_status;
483: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
484: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
485: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
486: RAISE OKL_API.G_EXCEPTION_ERROR;
487: END IF;
488:

Line 485: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

481:
482: x_return_status := l_return_status;
483: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
484: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
485: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
486: RAISE OKL_API.G_EXCEPTION_ERROR;
487: END IF;
488:
489: -- exceptions........

Line 486: RAISE OKL_API.G_EXCEPTION_ERROR;

482: x_return_status := l_return_status;
483: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
484: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
485: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
486: RAISE OKL_API.G_EXCEPTION_ERROR;
487: END IF;
488:
489: -- exceptions........
490: