47: x_return_status => l_return_status,
48: x_msg_count => lx_msg_count,
49: x_msg_data => lx_msg_data);
50:
51: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
52: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
53: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
54: RAISE okl_api.G_EXCEPTION_ERROR;
55: END IF;
48: x_msg_count => lx_msg_count,
49: x_msg_data => lx_msg_data);
50:
51: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
52: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
53: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
54: RAISE okl_api.G_EXCEPTION_ERROR;
55: END IF;
56: END LOOP;
49: x_msg_data => lx_msg_data);
50:
51: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
52: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
53: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
54: RAISE okl_api.G_EXCEPTION_ERROR;
55: END IF;
56: END LOOP;
57: resultout := 'COMPLETE:';
50:
51: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
52: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
53: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
54: RAISE okl_api.G_EXCEPTION_ERROR;
55: END IF;
56: END LOOP;
57: resultout := 'COMPLETE:';
58: RETURN ;
127: x_return_status => l_return_status,
128: x_msg_count => lx_msg_count,
129: x_msg_data => lx_msg_data);
130:
131: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
132: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
133: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
134: RAISE okl_api.G_EXCEPTION_ERROR;
135: END IF;
128: x_msg_count => lx_msg_count,
129: x_msg_data => lx_msg_data);
130:
131: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
132: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
133: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
134: RAISE okl_api.G_EXCEPTION_ERROR;
135: END IF;
136: END LOOP;
129: x_msg_data => lx_msg_data);
130:
131: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
132: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
133: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
134: RAISE okl_api.G_EXCEPTION_ERROR;
135: END IF;
136: END LOOP;
137: resultout := 'COMPLETE:';
130:
131: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
132: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
133: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
134: RAISE okl_api.G_EXCEPTION_ERROR;
135: END IF;
136: END LOOP;
137: resultout := 'COMPLETE:';
138: RETURN ;
207: x_return_status => l_return_status,
208: x_msg_count => lx_msg_count,
209: x_msg_data => lx_msg_data);
210:
211: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
212: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
213: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
214: RAISE okl_api.G_EXCEPTION_ERROR;
215: END IF;
208: x_msg_count => lx_msg_count,
209: x_msg_data => lx_msg_data);
210:
211: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
212: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
213: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
214: RAISE okl_api.G_EXCEPTION_ERROR;
215: END IF;
216: END LOOP;
209: x_msg_data => lx_msg_data);
210:
211: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
212: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
213: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
214: RAISE okl_api.G_EXCEPTION_ERROR;
215: END IF;
216: END LOOP;
217: resultout := 'COMPLETE:';
210:
211: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
212: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
213: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
214: RAISE okl_api.G_EXCEPTION_ERROR;
215: END IF;
216: END LOOP;
217: resultout := 'COMPLETE:';
218: RETURN ;
316: x_return_status => l_return_status,
317: x_msg_count => lx_msg_count,
318: x_msg_data => lx_msg_data);
319:
320: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
321: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
322: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
323: RAISE okl_api.G_EXCEPTION_ERROR;
324: END IF;
317: x_msg_count => lx_msg_count,
318: x_msg_data => lx_msg_data);
319:
320: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
321: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
322: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
323: RAISE okl_api.G_EXCEPTION_ERROR;
324: END IF;
325: END LOOP;
318: x_msg_data => lx_msg_data);
319:
320: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
321: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
322: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
323: RAISE okl_api.G_EXCEPTION_ERROR;
324: END IF;
325: END LOOP;
326: resultout := 'COMPLETE:';
319:
320: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
321: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
322: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
323: RAISE okl_api.G_EXCEPTION_ERROR;
324: END IF;
325: END LOOP;
326: resultout := 'COMPLETE:';
327: RETURN ;
413: ,x_return_status => l_return_status
414: ,x_msg_count => lx_msg_count
415: ,x_msg_data => lx_msg_data);
416:
417: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
418: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
419: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
420: RAISE okl_api.G_EXCEPTION_ERROR;
421: END IF;
414: ,x_msg_count => lx_msg_count
415: ,x_msg_data => lx_msg_data);
416:
417: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
418: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
419: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
420: RAISE okl_api.G_EXCEPTION_ERROR;
421: END IF;
422: END LOOP;
415: ,x_msg_data => lx_msg_data);
416:
417: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
418: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
419: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
420: RAISE okl_api.G_EXCEPTION_ERROR;
421: END IF;
422: END LOOP;
423: resultout := 'COMPLETE:';
416:
417: IF (l_return_status = okl_api.G_RET_STS_UNEXP_ERROR) THEN
418: RAISE okl_api.G_EXCEPTION_UNEXPECTED_ERROR;
419: ELSIF (l_return_status = okl_api.G_RET_STS_ERROR) THEN
420: RAISE okl_api.G_EXCEPTION_ERROR;
421: END IF;
422: END LOOP;
423: resultout := 'COMPLETE:';
424: RETURN ;