135: x_return_status := l_return_status;
136: x_msg_data := l_msg_data;
137: x_msg_count := l_msg_count;
138:
139: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
140: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
141: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
142: RAISE OKL_API.G_EXCEPTION_ERROR;
143: END IF;
136: x_msg_data := l_msg_data;
137: x_msg_count := l_msg_count;
138:
139: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
140: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
141: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
142: RAISE OKL_API.G_EXCEPTION_ERROR;
143: END IF;
144:
137: x_msg_count := l_msg_count;
138:
139: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
140: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
141: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
142: RAISE OKL_API.G_EXCEPTION_ERROR;
143: END IF;
144:
145: IF l_match_found = 1 THEN
138:
139: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
140: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
141: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
142: RAISE OKL_API.G_EXCEPTION_ERROR;
143: END IF;
144:
145: IF l_match_found = 1 THEN
146: EXIT;
178: x_return_status := l_return_status;
179: x_msg_data := l_msg_data;
180: x_msg_count := l_msg_count;
181:
182: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
183: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
184: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
185: RAISE OKL_API.G_EXCEPTION_ERROR;
186: END IF;
179: x_msg_data := l_msg_data;
180: x_msg_count := l_msg_count;
181:
182: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
183: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
184: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
185: RAISE OKL_API.G_EXCEPTION_ERROR;
186: END IF;
187:
180: x_msg_count := l_msg_count;
181:
182: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
183: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
184: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
185: RAISE OKL_API.G_EXCEPTION_ERROR;
186: END IF;
187:
188: IF l_match_found = 1 THEN
181:
182: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
183: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
184: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
185: RAISE OKL_API.G_EXCEPTION_ERROR;
186: END IF;
187:
188: IF l_match_found = 1 THEN
189: EXIT;
224: x_return_status := l_return_status;
225: x_msg_data := l_msg_data;
226: x_msg_count := l_msg_count;
227:
228: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
229: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
230: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
231: RAISE OKL_API.G_EXCEPTION_ERROR;
232: END IF;
225: x_msg_data := l_msg_data;
226: x_msg_count := l_msg_count;
227:
228: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
229: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
230: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
231: RAISE OKL_API.G_EXCEPTION_ERROR;
232: END IF;
233:
226: x_msg_count := l_msg_count;
227:
228: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
229: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
230: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
231: RAISE OKL_API.G_EXCEPTION_ERROR;
232: END IF;
233:
234: IF l_match_found = 1 THEN
227:
228: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
229: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
230: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
231: RAISE OKL_API.G_EXCEPTION_ERROR;
232: END IF;
233:
234: IF l_match_found = 1 THEN
235: EXIT;
266: x_return_status := l_return_status;
267: x_msg_data := l_msg_data;
268: x_msg_count := l_msg_count;
269:
270: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
271: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
272: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
273: RAISE OKL_API.G_EXCEPTION_ERROR;
274: END IF;
267: x_msg_data := l_msg_data;
268: x_msg_count := l_msg_count;
269:
270: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
271: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
272: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
273: RAISE OKL_API.G_EXCEPTION_ERROR;
274: END IF;
275:
268: x_msg_count := l_msg_count;
269:
270: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
271: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
272: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
273: RAISE OKL_API.G_EXCEPTION_ERROR;
274: END IF;
275:
276: END IF;
269:
270: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
271: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
272: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
273: RAISE OKL_API.G_EXCEPTION_ERROR;
274: END IF;
275:
276: END IF;
277:
279:
280: EXCEPTION
281:
282: WHEN OTHERS THEN
283: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
284: x_msg_count := l_msg_count ;
285: x_msg_data := l_msg_data ;
286:
287: END handle_combi_pay;
816:
817: EXCEPTION
818:
819: WHEN OTHERS THEN
820: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
821: x_msg_count := l_msg_count ;
822: x_msg_data := l_msg_data ;
823:
824: END search_combi;