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_DEAL_TERMS_PVT dependencies on OKC_API

Line 51: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

47:
48:
49: PROCEDURE process_billing_setup(
50: p_api_version IN NUMBER,
51: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
52: x_return_status OUT NOCOPY VARCHAR2,
53: x_msg_count OUT NOCOPY NUMBER,
54: x_msg_data OUT NOCOPY VARCHAR2,
55: p_rgpv_rec IN billing_setup_rec_type,

Line 120: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

116: x_msg_data => x_msg_data,
117: p_rgpv_rec => lp_labill_rgpv_rec,
118: x_rgpv_rec => lx_labill_rgpv_rec);
119:
120: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
122: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
123: RAISE OKC_API.G_EXCEPTION_ERROR;
124: END IF;

Line 121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

117: p_rgpv_rec => lp_labill_rgpv_rec,
118: x_rgpv_rec => lx_labill_rgpv_rec);
119:
120: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
122: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
123: RAISE OKC_API.G_EXCEPTION_ERROR;
124: END IF;
125:

Line 122: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

118: x_rgpv_rec => lx_labill_rgpv_rec);
119:
120: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
122: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
123: RAISE OKC_API.G_EXCEPTION_ERROR;
124: END IF;
125:
126: x_rgpv_rec.rgp_id := lx_labill_rgpv_rec.id;

Line 123: RAISE OKC_API.G_EXCEPTION_ERROR;

119:
120: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
122: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
123: RAISE OKC_API.G_EXCEPTION_ERROR;
124: END IF;
125:
126: x_rgpv_rec.rgp_id := lx_labill_rgpv_rec.id;
127: x_rgpv_rec.rgp_labill_lapmth_id := lx_labill_rgpv_rec.id;

Line 149: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

145: x_msg_data => x_msg_data,
146: p_rgpv_rec => lp_labill_rgpv_rec,
147: x_rgpv_rec => lx_labill_rgpv_rec);
148:
149: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
150: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
151: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
152: RAISE OKC_API.G_EXCEPTION_ERROR;
153: END IF;

Line 150: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

146: p_rgpv_rec => lp_labill_rgpv_rec,
147: x_rgpv_rec => lx_labill_rgpv_rec);
148:
149: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
150: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
151: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
152: RAISE OKC_API.G_EXCEPTION_ERROR;
153: END IF;
154: x_rgpv_rec.rgp_id := p_rgpv_rec.rgp_id;

Line 151: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

147: x_rgpv_rec => lx_labill_rgpv_rec);
148:
149: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
150: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
151: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
152: RAISE OKC_API.G_EXCEPTION_ERROR;
153: END IF;
154: x_rgpv_rec.rgp_id := p_rgpv_rec.rgp_id;
155:

Line 152: RAISE OKC_API.G_EXCEPTION_ERROR;

148:
149: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
150: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
151: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
152: RAISE OKC_API.G_EXCEPTION_ERROR;
153: END IF;
154: x_rgpv_rec.rgp_id := p_rgpv_rec.rgp_id;
155:
156: END IF;

Line 174: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

170: p_khrv_rec => lp_khrv_rec,
171: x_chrv_rec => lx_chrv_rec,
172: x_khrv_rec => lx_khrv_rec);
173:
174: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
175: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
176: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
177: RAISE OKC_API.G_EXCEPTION_ERROR;
178: END IF;

Line 175: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

171: x_chrv_rec => lx_chrv_rec,
172: x_khrv_rec => lx_khrv_rec);
173:
174: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
175: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
176: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
177: RAISE OKC_API.G_EXCEPTION_ERROR;
178: END IF;
179:

Line 176: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

172: x_khrv_rec => lx_khrv_rec);
173:
174: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
175: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
176: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
177: RAISE OKC_API.G_EXCEPTION_ERROR;
178: END IF;
179:
180:

Line 177: RAISE OKC_API.G_EXCEPTION_ERROR;

173:
174: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
175: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
176: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
177: RAISE OKC_API.G_EXCEPTION_ERROR;
178: END IF;
179:
180:
181: IF (p_rgpv_rec.rul_lapmth_id IS NULL) THEN

Line 204: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

200: x_msg_data => x_msg_data,
201: p_rulv_rec => lp_lapmth_rulv_rec,
202: x_rulv_rec => lx_lapmth_rulv_rec);
203:
204: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
205: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
206: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
207: RAISE OKC_API.G_EXCEPTION_ERROR;
208: END IF;

Line 205: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

201: p_rulv_rec => lp_lapmth_rulv_rec,
202: x_rulv_rec => lx_lapmth_rulv_rec);
203:
204: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
205: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
206: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
207: RAISE OKC_API.G_EXCEPTION_ERROR;
208: END IF;
209:

Line 206: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

202: x_rulv_rec => lx_lapmth_rulv_rec);
203:
204: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
205: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
206: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
207: RAISE OKC_API.G_EXCEPTION_ERROR;
208: END IF;
209:
210: x_rgpv_rec.rul_lapmth_id := lx_lapmth_rulv_rec.id;

Line 207: RAISE OKC_API.G_EXCEPTION_ERROR;

203:
204: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
205: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
206: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
207: RAISE OKC_API.G_EXCEPTION_ERROR;
208: END IF;
209:
210: x_rgpv_rec.rul_lapmth_id := lx_lapmth_rulv_rec.id;
211:

Line 240: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

236: x_msg_data => x_msg_data,
237: p_rulv_rec => lp_lapmth_rulv_rec,
238: x_rulv_rec => lx_lapmth_rulv_rec);
239:
240: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
242: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
243: RAISE OKC_API.G_EXCEPTION_ERROR;
244: END IF;

Line 241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

237: p_rulv_rec => lp_lapmth_rulv_rec,
238: x_rulv_rec => lx_lapmth_rulv_rec);
239:
240: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
242: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
243: RAISE OKC_API.G_EXCEPTION_ERROR;
244: END IF;
245:

Line 242: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

238: x_rulv_rec => lx_lapmth_rulv_rec);
239:
240: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
242: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
243: RAISE OKC_API.G_EXCEPTION_ERROR;
244: END IF;
245:
246: END IF;

Line 243: RAISE OKC_API.G_EXCEPTION_ERROR;

239:
240: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
241: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
242: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
243: RAISE OKC_API.G_EXCEPTION_ERROR;
244: END IF;
245:
246: END IF;
247:

Line 272: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

268: x_msg_data => x_msg_data,
269: p_rulv_rec => lp_labacc_rulv_rec,
270: x_rulv_rec => lx_labacc_rulv_rec);
271:
272: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
273: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
274: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
275: RAISE OKC_API.G_EXCEPTION_ERROR;
276: END IF;

Line 273: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

269: p_rulv_rec => lp_labacc_rulv_rec,
270: x_rulv_rec => lx_labacc_rulv_rec);
271:
272: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
273: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
274: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
275: RAISE OKC_API.G_EXCEPTION_ERROR;
276: END IF;
277:

Line 274: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

270: x_rulv_rec => lx_labacc_rulv_rec);
271:
272: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
273: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
274: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
275: RAISE OKC_API.G_EXCEPTION_ERROR;
276: END IF;
277:
278: x_rgpv_rec.rul_labacc_id := lx_labacc_rulv_rec.id;

Line 275: RAISE OKC_API.G_EXCEPTION_ERROR;

271:
272: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
273: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
274: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
275: RAISE OKC_API.G_EXCEPTION_ERROR;
276: END IF;
277:
278: x_rgpv_rec.rul_labacc_id := lx_labacc_rulv_rec.id;
279:

Line 308: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

304: x_msg_data => x_msg_data,
305: p_rulv_rec => lp_labacc_rulv_rec,
306: x_rulv_rec => lx_labacc_rulv_rec);
307:
308: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
309: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
310: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
311: RAISE OKC_API.G_EXCEPTION_ERROR;
312: END IF;

Line 309: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

305: p_rulv_rec => lp_labacc_rulv_rec,
306: x_rulv_rec => lx_labacc_rulv_rec);
307:
308: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
309: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
310: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
311: RAISE OKC_API.G_EXCEPTION_ERROR;
312: END IF;
313:

Line 310: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

306: x_rulv_rec => lx_labacc_rulv_rec);
307:
308: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
309: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
310: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
311: RAISE OKC_API.G_EXCEPTION_ERROR;
312: END IF;
313:
314: END IF;

Line 311: RAISE OKC_API.G_EXCEPTION_ERROR;

307:
308: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
309: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
310: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
311: RAISE OKC_API.G_EXCEPTION_ERROR;
312: END IF;
313:
314: END IF;
315:

Line 343: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

339: x_msg_data => x_msg_data,
340: p_rulv_rec => lp_lainvd_rulv_rec,
341: x_rulv_rec => lx_lainvd_rulv_rec);
342:
343: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
344: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
345: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
346: RAISE OKC_API.G_EXCEPTION_ERROR;
347: END IF;

Line 344: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

340: p_rulv_rec => lp_lainvd_rulv_rec,
341: x_rulv_rec => lx_lainvd_rulv_rec);
342:
343: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
344: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
345: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
346: RAISE OKC_API.G_EXCEPTION_ERROR;
347: END IF;
348:

Line 345: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

341: x_rulv_rec => lx_lainvd_rulv_rec);
342:
343: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
344: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
345: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
346: RAISE OKC_API.G_EXCEPTION_ERROR;
347: END IF;
348:
349: x_rgpv_rec.rul_lainvd_id := lx_lainvd_rulv_rec.id;

Line 346: RAISE OKC_API.G_EXCEPTION_ERROR;

342:
343: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
344: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
345: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
346: RAISE OKC_API.G_EXCEPTION_ERROR;
347: END IF;
348:
349: x_rgpv_rec.rul_lainvd_id := lx_lainvd_rulv_rec.id;
350:

Line 382: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

378: x_msg_data => x_msg_data,
379: p_rulv_rec => lp_lainvd_rulv_rec,
380: x_rulv_rec => lx_lainvd_rulv_rec);
381:
382: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
383: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
384: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
385: RAISE OKC_API.G_EXCEPTION_ERROR;
386: END IF;

Line 383: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

379: p_rulv_rec => lp_lainvd_rulv_rec,
380: x_rulv_rec => lx_lainvd_rulv_rec);
381:
382: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
383: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
384: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
385: RAISE OKC_API.G_EXCEPTION_ERROR;
386: END IF;
387:

Line 384: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

380: x_rulv_rec => lx_lainvd_rulv_rec);
381:
382: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
383: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
384: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
385: RAISE OKC_API.G_EXCEPTION_ERROR;
386: END IF;
387:
388: END IF;

Line 385: RAISE OKC_API.G_EXCEPTION_ERROR;

381:
382: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
383: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
384: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
385: RAISE OKC_API.G_EXCEPTION_ERROR;
386: END IF;
387:
388: END IF;
389:

Line 410: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

406: x_msg_data => x_msg_data,
407: p_rulv_rec => lp_lainpr_rulv_rec,
408: x_rulv_rec => lx_lainpr_rulv_rec);
409:
410: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
411: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
412: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
413: RAISE OKC_API.G_EXCEPTION_ERROR;
414: END IF;

Line 411: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

407: p_rulv_rec => lp_lainpr_rulv_rec,
408: x_rulv_rec => lx_lainpr_rulv_rec);
409:
410: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
411: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
412: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
413: RAISE OKC_API.G_EXCEPTION_ERROR;
414: END IF;
415:

Line 412: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

408: x_rulv_rec => lx_lainpr_rulv_rec);
409:
410: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
411: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
412: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
413: RAISE OKC_API.G_EXCEPTION_ERROR;
414: END IF;
415:
416: x_rgpv_rec.rul_lainpr_id := lx_lainpr_rulv_rec.id;

Line 413: RAISE OKC_API.G_EXCEPTION_ERROR;

409:
410: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
411: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
412: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
413: RAISE OKC_API.G_EXCEPTION_ERROR;
414: END IF;
415:
416: x_rgpv_rec.rul_lainpr_id := lx_lainpr_rulv_rec.id;
417:

Line 438: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

434: x_msg_data => x_msg_data,
435: p_rulv_rec => lp_lainpr_rulv_rec,
436: x_rulv_rec => lx_lainpr_rulv_rec);
437:
438: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
439: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
440: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
441: RAISE OKC_API.G_EXCEPTION_ERROR;
442: END IF;

Line 439: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

435: p_rulv_rec => lp_lainpr_rulv_rec,
436: x_rulv_rec => lx_lainpr_rulv_rec);
437:
438: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
439: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
440: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
441: RAISE OKC_API.G_EXCEPTION_ERROR;
442: END IF;
443:

Line 440: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

436: x_rulv_rec => lx_lainpr_rulv_rec);
437:
438: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
439: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
440: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
441: RAISE OKC_API.G_EXCEPTION_ERROR;
442: END IF;
443:
444: END IF;

Line 441: RAISE OKC_API.G_EXCEPTION_ERROR;

437:
438: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
439: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
440: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
441: RAISE OKC_API.G_EXCEPTION_ERROR;
442: END IF;
443:
444: END IF;
445:

Line 446: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

442: END IF;
443:
444: END IF;
445:
446: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
447:
448: EXCEPTION
449: WHEN OKC_API.G_EXCEPTION_ERROR THEN
450: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

Line 449: WHEN OKC_API.G_EXCEPTION_ERROR THEN

445:
446: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
447:
448: EXCEPTION
449: WHEN OKC_API.G_EXCEPTION_ERROR THEN
450: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
451: p_api_name => l_api_name,
452: p_pkg_name => g_pkg_name,
453: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 450: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

446: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
447:
448: EXCEPTION
449: WHEN OKC_API.G_EXCEPTION_ERROR THEN
450: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
451: p_api_name => l_api_name,
452: p_pkg_name => g_pkg_name,
453: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
454: x_msg_count => x_msg_count,

Line 453: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

449: WHEN OKC_API.G_EXCEPTION_ERROR THEN
450: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
451: p_api_name => l_api_name,
452: p_pkg_name => g_pkg_name,
453: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
454: x_msg_count => x_msg_count,
455: x_msg_data => x_msg_data,
456: p_api_type => g_api_type);
457:

Line 458: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

454: x_msg_count => x_msg_count,
455: x_msg_data => x_msg_data,
456: p_api_type => g_api_type);
457:
458: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
459: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
460: p_api_name => l_api_name,
461: p_pkg_name => g_pkg_name,
462: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 459: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

455: x_msg_data => x_msg_data,
456: p_api_type => g_api_type);
457:
458: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
459: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
460: p_api_name => l_api_name,
461: p_pkg_name => g_pkg_name,
462: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
463: x_msg_count => x_msg_count,

Line 462: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

458: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
459: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
460: p_api_name => l_api_name,
461: p_pkg_name => g_pkg_name,
462: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
463: x_msg_count => x_msg_count,
464: x_msg_data => x_msg_data,
465: p_api_type => g_api_type);
466:

Line 468: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

464: x_msg_data => x_msg_data,
465: p_api_type => g_api_type);
466:
467: WHEN OTHERS THEN
468: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
469: p_api_name => l_api_name,
470: p_pkg_name => g_pkg_name,
471: p_exc_name => 'OTHERS',
472: x_msg_count => x_msg_count,

Line 479: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

475: END process_billing_setup;
476:
477: PROCEDURE process_rvi(
478: p_api_version IN NUMBER,
479: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
480: x_return_status OUT NOCOPY VARCHAR2,
481: x_msg_count OUT NOCOPY NUMBER,
482: x_msg_data OUT NOCOPY VARCHAR2,
483: p_rgpv_rec IN rvi_rec_type,

Line 539: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

535: x_msg_data => x_msg_data,
536: p_rgpv_rec => lp_larvin_rgpv_rec,
537: x_rgpv_rec => lx_larvin_rgpv_rec);
538:
539: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
540: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
541: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
542: RAISE OKC_API.G_EXCEPTION_ERROR;
543: END IF;

Line 540: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

536: p_rgpv_rec => lp_larvin_rgpv_rec,
537: x_rgpv_rec => lx_larvin_rgpv_rec);
538:
539: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
540: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
541: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
542: RAISE OKC_API.G_EXCEPTION_ERROR;
543: END IF;
544:

Line 541: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

537: x_rgpv_rec => lx_larvin_rgpv_rec);
538:
539: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
540: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
541: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
542: RAISE OKC_API.G_EXCEPTION_ERROR;
543: END IF;
544:
545: x_rgpv_rec.rgp_id := lx_larvin_rgpv_rec.id;

Line 542: RAISE OKC_API.G_EXCEPTION_ERROR;

538:
539: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
540: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
541: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
542: RAISE OKC_API.G_EXCEPTION_ERROR;
543: END IF;
544:
545: x_rgpv_rec.rgp_id := lx_larvin_rgpv_rec.id;
546:

Line 565: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

561: x_msg_data => x_msg_data,
562: p_rgpv_rec => lp_larvin_rgpv_rec,
563: x_rgpv_rec => lx_larvin_rgpv_rec);
564:
565: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
566: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
567: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
568: RAISE OKC_API.G_EXCEPTION_ERROR;
569: END IF;

Line 566: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

562: p_rgpv_rec => lp_larvin_rgpv_rec,
563: x_rgpv_rec => lx_larvin_rgpv_rec);
564:
565: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
566: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
567: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
568: RAISE OKC_API.G_EXCEPTION_ERROR;
569: END IF;
570:

Line 567: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

563: x_rgpv_rec => lx_larvin_rgpv_rec);
564:
565: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
566: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
567: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
568: RAISE OKC_API.G_EXCEPTION_ERROR;
569: END IF;
570:
571: END IF;

Line 568: RAISE OKC_API.G_EXCEPTION_ERROR;

564:
565: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
566: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
567: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
568: RAISE OKC_API.G_EXCEPTION_ERROR;
569: END IF;
570:
571: END IF;
572:

Line 592: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

588: x_msg_data => x_msg_data,
589: p_rulv_rec => lp_larvau_rulv_rec,
590: x_rulv_rec => lx_larvau_rulv_rec);
591:
592: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
593: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
594: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
595: RAISE OKC_API.G_EXCEPTION_ERROR;
596: END IF;

Line 593: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

589: p_rulv_rec => lp_larvau_rulv_rec,
590: x_rulv_rec => lx_larvau_rulv_rec);
591:
592: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
593: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
594: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
595: RAISE OKC_API.G_EXCEPTION_ERROR;
596: END IF;
597:

Line 594: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

590: x_rulv_rec => lx_larvau_rulv_rec);
591:
592: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
593: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
594: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
595: RAISE OKC_API.G_EXCEPTION_ERROR;
596: END IF;
597:
598: x_rgpv_rec.rul_larvau_id := lx_larvau_rulv_rec.id;

Line 595: RAISE OKC_API.G_EXCEPTION_ERROR;

591:
592: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
593: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
594: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
595: RAISE OKC_API.G_EXCEPTION_ERROR;
596: END IF;
597:
598: x_rgpv_rec.rul_larvau_id := lx_larvau_rulv_rec.id;
599:

Line 620: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

616: x_msg_data => x_msg_data,
617: p_rulv_rec => lp_larvau_rulv_rec,
618: x_rulv_rec => lx_larvau_rulv_rec);
619:
620: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
621: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
622: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
623: RAISE OKC_API.G_EXCEPTION_ERROR;
624: END IF;

Line 621: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

617: p_rulv_rec => lp_larvau_rulv_rec,
618: x_rulv_rec => lx_larvau_rulv_rec);
619:
620: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
621: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
622: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
623: RAISE OKC_API.G_EXCEPTION_ERROR;
624: END IF;
625:

Line 622: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

618: x_rulv_rec => lx_larvau_rulv_rec);
619:
620: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
621: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
622: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
623: RAISE OKC_API.G_EXCEPTION_ERROR;
624: END IF;
625:
626: x_rgpv_rec.rul_larvau_id := lx_larvau_rulv_rec.id;

Line 623: RAISE OKC_API.G_EXCEPTION_ERROR;

619:
620: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
621: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
622: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
623: RAISE OKC_API.G_EXCEPTION_ERROR;
624: END IF;
625:
626: x_rgpv_rec.rul_larvau_id := lx_larvau_rulv_rec.id;
627: END IF;

Line 648: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

644: x_msg_data => x_msg_data,
645: p_rulv_rec => lp_larvam_rulv_rec,
646: x_rulv_rec => lx_larvam_rulv_rec);
647:
648: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
649: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
650: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
651: RAISE OKC_API.G_EXCEPTION_ERROR;
652: END IF;

Line 649: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

645: p_rulv_rec => lp_larvam_rulv_rec,
646: x_rulv_rec => lx_larvam_rulv_rec);
647:
648: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
649: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
650: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
651: RAISE OKC_API.G_EXCEPTION_ERROR;
652: END IF;
653:

Line 650: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

646: x_rulv_rec => lx_larvam_rulv_rec);
647:
648: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
649: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
650: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
651: RAISE OKC_API.G_EXCEPTION_ERROR;
652: END IF;
653:
654: x_rgpv_rec.rul_larvam_id := lx_larvam_rulv_rec.id;

Line 651: RAISE OKC_API.G_EXCEPTION_ERROR;

647:
648: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
649: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
650: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
651: RAISE OKC_API.G_EXCEPTION_ERROR;
652: END IF;
653:
654: x_rgpv_rec.rul_larvam_id := lx_larvam_rulv_rec.id;
655:

Line 676: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

672: x_msg_data => x_msg_data,
673: p_rulv_rec => lp_larvam_rulv_rec,
674: x_rulv_rec => lx_larvam_rulv_rec);
675:
676: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
677: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
678: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
679: RAISE OKC_API.G_EXCEPTION_ERROR;
680: END IF;

Line 677: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

673: p_rulv_rec => lp_larvam_rulv_rec,
674: x_rulv_rec => lx_larvam_rulv_rec);
675:
676: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
677: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
678: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
679: RAISE OKC_API.G_EXCEPTION_ERROR;
680: END IF;
681:

Line 678: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

674: x_rulv_rec => lx_larvam_rulv_rec);
675:
676: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
677: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
678: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
679: RAISE OKC_API.G_EXCEPTION_ERROR;
680: END IF;
681:
682: x_rgpv_rec.rul_larvam_id := lx_larvam_rulv_rec.id;

Line 679: RAISE OKC_API.G_EXCEPTION_ERROR;

675:
676: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
677: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
678: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
679: RAISE OKC_API.G_EXCEPTION_ERROR;
680: END IF;
681:
682: x_rgpv_rec.rul_larvam_id := lx_larvam_rulv_rec.id;
683: END IF;

Line 702: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

698: p_check_box_value => p_rgpv_rec.larvau_rule_information1,
699: p_fee_types_rec => lp_fee_types_rec,
700: x_fee_types_rec => lx_fee_types_rec);
701:
702: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
703: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
704: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
705: RAISE OKC_API.G_EXCEPTION_ERROR;
706: END IF;

Line 703: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

699: p_fee_types_rec => lp_fee_types_rec,
700: x_fee_types_rec => lx_fee_types_rec);
701:
702: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
703: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
704: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
705: RAISE OKC_API.G_EXCEPTION_ERROR;
706: END IF;
707:

Line 704: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

700: x_fee_types_rec => lx_fee_types_rec);
701:
702: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
703: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
704: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
705: RAISE OKC_API.G_EXCEPTION_ERROR;
706: END IF;
707:
708: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

Line 705: RAISE OKC_API.G_EXCEPTION_ERROR;

701:
702: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
703: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
704: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
705: RAISE OKC_API.G_EXCEPTION_ERROR;
706: END IF;
707:
708: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
709:

Line 708: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

704: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
705: RAISE OKC_API.G_EXCEPTION_ERROR;
706: END IF;
707:
708: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
709:
710: EXCEPTION
711: WHEN OKC_API.G_EXCEPTION_ERROR THEN
712: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

Line 711: WHEN OKC_API.G_EXCEPTION_ERROR THEN

707:
708: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
709:
710: EXCEPTION
711: WHEN OKC_API.G_EXCEPTION_ERROR THEN
712: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
713: p_api_name => l_api_name,
714: p_pkg_name => g_pkg_name,
715: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 712: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

708: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
709:
710: EXCEPTION
711: WHEN OKC_API.G_EXCEPTION_ERROR THEN
712: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
713: p_api_name => l_api_name,
714: p_pkg_name => g_pkg_name,
715: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
716: x_msg_count => x_msg_count,

Line 715: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

711: WHEN OKC_API.G_EXCEPTION_ERROR THEN
712: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
713: p_api_name => l_api_name,
714: p_pkg_name => g_pkg_name,
715: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
716: x_msg_count => x_msg_count,
717: x_msg_data => x_msg_data,
718: p_api_type => g_api_type);
719:

Line 720: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

716: x_msg_count => x_msg_count,
717: x_msg_data => x_msg_data,
718: p_api_type => g_api_type);
719:
720: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
721: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
722: p_api_name => l_api_name,
723: p_pkg_name => g_pkg_name,
724: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 721: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

717: x_msg_data => x_msg_data,
718: p_api_type => g_api_type);
719:
720: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
721: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
722: p_api_name => l_api_name,
723: p_pkg_name => g_pkg_name,
724: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
725: x_msg_count => x_msg_count,

Line 724: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

720: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
721: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
722: p_api_name => l_api_name,
723: p_pkg_name => g_pkg_name,
724: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
725: x_msg_count => x_msg_count,
726: x_msg_data => x_msg_data,
727: p_api_type => g_api_type);
728:

Line 730: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

726: x_msg_data => x_msg_data,
727: p_api_type => g_api_type);
728:
729: WHEN OTHERS THEN
730: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
731: p_api_name => l_api_name,
732: p_pkg_name => g_pkg_name,
733: p_exc_name => 'OTHERS',
734: x_msg_count => x_msg_count,