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_SETUP_TRXPARAMS_PUB dependencies on OKL_API

Line 27: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

23: BEGIN
24: l_return_status := G_RET_STS_SUCCESS;
25: l_sxpv_rec := p_sxpv_rec;
26:
27: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
28: p_pkg_name => G_PKG_NAME,
29: p_init_msg_list => p_init_msg_list,
30: l_api_version => l_api_version,
31: p_api_version => p_api_version,

Line 63: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

59: /* re-assign local record structure using output record from pvt api */
60: l_sxpv_rec := x_sxpv_rec;
61:
62:
63: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
64: x_msg_data => x_msg_data);
65: x_return_status := l_return_status;
66: EXCEPTION
67: WHEN G_EXCEPTION_ERROR THEN

Line 68: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

64: x_msg_data => x_msg_data);
65: x_return_status := l_return_status;
66: EXCEPTION
67: WHEN G_EXCEPTION_ERROR THEN
68: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
69: p_pkg_name => G_PKG_NAME,
70: p_exc_name => G_EXC_NAME_ERROR,
71: x_msg_count => x_msg_count,
72: x_msg_data => x_msg_data,

Line 75: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

71: x_msg_count => x_msg_count,
72: x_msg_data => x_msg_data,
73: p_api_type => G_API_TYPE);
74: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
75: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
76: p_pkg_name => G_PKG_NAME,
77: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
78: x_msg_count => x_msg_count,
79: x_msg_data => x_msg_data,

Line 82: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

78: x_msg_count => x_msg_count,
79: x_msg_data => x_msg_data,
80: p_api_type => G_API_TYPE);
81: WHEN OTHERS THEN
82: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
83: p_pkg_name => G_PKG_NAME,
84: p_exc_name => G_EXC_NAME_OTHERS,
85: x_msg_count => x_msg_count,
86: x_msg_data => x_msg_data,

Line 114: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

110: BEGIN
111: x_return_status := G_RET_STS_SUCCESS;
112: l_sxpv_rec := p_sxpv_rec;
113:
114: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
115: p_pkg_name => G_PKG_NAME,
116: p_init_msg_list => p_init_msg_list,
117: l_api_version => l_api_version,
118: p_api_version => p_api_version,

Line 147: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

143: /* re-assign local record structure using output record from pvt api */
144: l_sxpv_rec := x_sxpv_rec;
145:
146:
147: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
148: x_msg_data => x_msg_data);
149: x_return_status := l_return_status;
150: EXCEPTION
151: WHEN G_EXCEPTION_ERROR THEN

Line 152: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

148: x_msg_data => x_msg_data);
149: x_return_status := l_return_status;
150: EXCEPTION
151: WHEN G_EXCEPTION_ERROR THEN
152: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
153: p_pkg_name => G_PKG_NAME,
154: p_exc_name => G_EXC_NAME_ERROR,
155: x_msg_count => x_msg_count,
156: x_msg_data => x_msg_data,

Line 159: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

155: x_msg_count => x_msg_count,
156: x_msg_data => x_msg_data,
157: p_api_type => G_API_TYPE);
158: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
159: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
160: p_pkg_name => G_PKG_NAME,
161: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
162: x_msg_count => x_msg_count,
163: x_msg_data => x_msg_data,

Line 166: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

162: x_msg_count => x_msg_count,
163: x_msg_data => x_msg_data,
164: p_api_type => G_API_TYPE);
165: WHEN OTHERS THEN
166: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
167: p_pkg_name => G_PKG_NAME,
168: p_exc_name => G_EXC_NAME_OTHERS,
169: x_msg_count => x_msg_count,
170: x_msg_data => x_msg_data,

Line 188: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

184: l_api_version CONSTANT NUMBER := 1;
185: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
186: rec_num INTEGER := 0;
187: BEGIN
188: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
189: p_pkg_name => G_PKG_NAME,
190: p_init_msg_list => p_init_msg_list,
191: l_api_version => l_api_version,
192: p_api_version => p_api_version,

Line 218: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

214: RAISE G_EXCEPTION_ERROR;
215: END IF;
216:
217: END LOOP;
218: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
219: x_msg_data => x_msg_data);
220: x_return_status := l_return_status;
221: EXCEPTION
222: WHEN G_EXCEPTION_ERROR THEN

Line 223: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

219: x_msg_data => x_msg_data);
220: x_return_status := l_return_status;
221: EXCEPTION
222: WHEN G_EXCEPTION_ERROR THEN
223: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
224: p_pkg_name => G_PKG_NAME,
225: p_exc_name => G_EXC_NAME_ERROR,
226: x_msg_count => x_msg_count,
227: x_msg_data => x_msg_data,

Line 230: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

226: x_msg_count => x_msg_count,
227: x_msg_data => x_msg_data,
228: p_api_type => G_API_TYPE);
229: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
230: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
231: p_pkg_name => G_PKG_NAME,
232: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
233: x_msg_count => x_msg_count,
234: x_msg_data => x_msg_data,

Line 237: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

233: x_msg_count => x_msg_count,
234: x_msg_data => x_msg_data,
235: p_api_type => G_API_TYPE);
236: WHEN OTHERS THEN
237: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
238: p_pkg_name => G_PKG_NAME,
239: p_exc_name => G_EXC_NAME_OTHERS,
240: x_msg_count => x_msg_count,
241: x_msg_data => x_msg_data,

Line 261: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

257: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
258: rec_num INTEGER := 0;
259: BEGIN
260:
261: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
262: p_pkg_name => G_PKG_NAME,
263: p_init_msg_list => p_init_msg_list,
264: l_api_version => l_api_version,
265: p_api_version => p_api_version,

Line 291: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

287: RAISE G_EXCEPTION_ERROR;
288: END IF;
289:
290: END LOOP;
291: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
292: x_msg_data => x_msg_data);
293: x_return_status := l_return_status;
294: EXCEPTION
295: WHEN G_EXCEPTION_ERROR THEN

Line 296: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

292: x_msg_data => x_msg_data);
293: x_return_status := l_return_status;
294: EXCEPTION
295: WHEN G_EXCEPTION_ERROR THEN
296: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
297: p_pkg_name => G_PKG_NAME,
298: p_exc_name => G_EXC_NAME_ERROR,
299: x_msg_count => x_msg_count,
300: x_msg_data => x_msg_data,

Line 303: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

299: x_msg_count => x_msg_count,
300: x_msg_data => x_msg_data,
301: p_api_type => G_API_TYPE);
302: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
303: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
304: p_pkg_name => G_PKG_NAME,
305: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
306: x_msg_count => x_msg_count,
307: x_msg_data => x_msg_data,

Line 310: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

306: x_msg_count => x_msg_count,
307: x_msg_data => x_msg_data,
308: p_api_type => G_API_TYPE);
309: WHEN OTHERS THEN
310: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
311: p_pkg_name => G_PKG_NAME,
312: p_exc_name => G_EXC_NAME_OTHERS,
313: x_msg_count => x_msg_count,
314: x_msg_data => x_msg_data,

Line 341: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

337: BEGIN
338: x_return_status := G_RET_STS_SUCCESS;
339: l_sxpv_rec := p_sxpv_rec;
340:
341: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
342: p_pkg_name => G_PKG_NAME,
343: p_init_msg_list => p_init_msg_list,
344: l_api_version => l_api_version,
345: p_api_version => p_api_version,

Line 376: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

372: l_sxpv_rec := x_sxpv_rec;
373:
374:
375:
376: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
377: x_msg_data => x_msg_data);
378: x_return_status := l_return_status;
379:
380: EXCEPTION

Line 382: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

378: x_return_status := l_return_status;
379:
380: EXCEPTION
381: WHEN G_EXCEPTION_ERROR THEN
382: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
383: p_pkg_name => G_PKG_NAME,
384: p_exc_name => G_EXC_NAME_ERROR,
385: x_msg_count => x_msg_count,
386: x_msg_data => x_msg_data,

Line 389: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

385: x_msg_count => x_msg_count,
386: x_msg_data => x_msg_data,
387: p_api_type => G_API_TYPE);
388: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
389: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
390: p_pkg_name => G_PKG_NAME,
391: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
392: x_msg_count => x_msg_count,
393: x_msg_data => x_msg_data,

Line 396: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

392: x_msg_count => x_msg_count,
393: x_msg_data => x_msg_data,
394: p_api_type => G_API_TYPE);
395: WHEN OTHERS THEN
396: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
397: p_pkg_name => G_PKG_NAME,
398: p_exc_name => G_EXC_NAME_OTHERS,
399: x_msg_count => x_msg_count,
400: x_msg_data => x_msg_data,

Line 419: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

415: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
416: rec_num INTEGER := 0;
417: BEGIN
418:
419: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
420: p_pkg_name => G_PKG_NAME,
421: p_init_msg_list => p_init_msg_list,
422: l_api_version => l_api_version,
423: p_api_version => p_api_version,

Line 449: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

445: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
446: RAISE G_EXCEPTION_ERROR;
447: END IF;
448: END LOOP;
449: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
450: x_msg_data => x_msg_data);
451: x_return_status := l_return_status;
452:
453: EXCEPTION

Line 455: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

451: x_return_status := l_return_status;
452:
453: EXCEPTION
454: WHEN G_EXCEPTION_ERROR THEN
455: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
456: p_pkg_name => G_PKG_NAME,
457: p_exc_name => G_EXC_NAME_ERROR,
458: x_msg_count => x_msg_count,
459: x_msg_data => x_msg_data,

Line 462: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

458: x_msg_count => x_msg_count,
459: x_msg_data => x_msg_data,
460: p_api_type => G_API_TYPE);
461: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
462: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
463: p_pkg_name => G_PKG_NAME,
464: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
465: x_msg_count => x_msg_count,
466: x_msg_data => x_msg_data,

Line 469: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

465: x_msg_count => x_msg_count,
466: x_msg_data => x_msg_data,
467: p_api_type => G_API_TYPE);
468: WHEN OTHERS THEN
469: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
470: p_pkg_name => G_PKG_NAME,
471: p_exc_name => G_EXC_NAME_OTHERS,
472: x_msg_count => x_msg_count,
473: x_msg_data => x_msg_data,

Line 500: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

496: BEGIN
497: l_return_status := G_RET_STS_SUCCESS;
498: l_sxpv_rec := p_sxpv_rec;
499:
500: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
501: p_pkg_name => G_PKG_NAME,
502: p_init_msg_list => p_init_msg_list,
503: l_api_version => l_api_version,
504: p_api_version => p_api_version,

Line 536: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

532: /* re-assign local record structure using output record from pvt api */
533: l_sxpv_rec := x_sxpv_rec;
534:
535:
536: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
537: x_msg_data => x_msg_data);
538: x_return_status := l_return_status;
539: EXCEPTION
540: WHEN G_EXCEPTION_ERROR THEN

Line 541: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

537: x_msg_data => x_msg_data);
538: x_return_status := l_return_status;
539: EXCEPTION
540: WHEN G_EXCEPTION_ERROR THEN
541: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
542: p_pkg_name => G_PKG_NAME,
543: p_exc_name => G_EXC_NAME_ERROR,
544: x_msg_count => x_msg_count,
545: x_msg_data => x_msg_data,

Line 548: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

544: x_msg_count => x_msg_count,
545: x_msg_data => x_msg_data,
546: p_api_type => G_API_TYPE);
547: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
548: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
549: p_pkg_name => G_PKG_NAME,
550: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
551: x_msg_count => x_msg_count,
552: x_msg_data => x_msg_data,

Line 555: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

551: x_msg_count => x_msg_count,
552: x_msg_data => x_msg_data,
553: p_api_type => G_API_TYPE);
554: WHEN OTHERS THEN
555: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
556: p_pkg_name => G_PKG_NAME,
557: p_exc_name => G_EXC_NAME_OTHERS,
558: x_msg_count => x_msg_count,
559: x_msg_data => x_msg_data,

Line 587: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

583: BEGIN
584: x_return_status := G_RET_STS_SUCCESS;
585: l_sxpv_rec := p_sxpv_rec;
586:
587: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
588: p_pkg_name => G_PKG_NAME,
589: p_init_msg_list => p_init_msg_list,
590: l_api_version => l_api_version,
591: p_api_version => p_api_version,

Line 620: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

616: /* re-assign local record structure using output record from pvt api */
617: l_sxpv_rec := x_sxpv_rec;
618:
619:
620: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
621: x_msg_data => x_msg_data);
622: x_return_status := l_return_status;
623: EXCEPTION
624: WHEN G_EXCEPTION_ERROR THEN

Line 625: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

621: x_msg_data => x_msg_data);
622: x_return_status := l_return_status;
623: EXCEPTION
624: WHEN G_EXCEPTION_ERROR THEN
625: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
626: p_pkg_name => G_PKG_NAME,
627: p_exc_name => G_EXC_NAME_ERROR,
628: x_msg_count => x_msg_count,
629: x_msg_data => x_msg_data,

Line 632: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

628: x_msg_count => x_msg_count,
629: x_msg_data => x_msg_data,
630: p_api_type => G_API_TYPE);
631: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
632: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
633: p_pkg_name => G_PKG_NAME,
634: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
635: x_msg_count => x_msg_count,
636: x_msg_data => x_msg_data,

Line 639: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

635: x_msg_count => x_msg_count,
636: x_msg_data => x_msg_data,
637: p_api_type => G_API_TYPE);
638: WHEN OTHERS THEN
639: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
640: p_pkg_name => G_PKG_NAME,
641: p_exc_name => G_EXC_NAME_OTHERS,
642: x_msg_count => x_msg_count,
643: x_msg_data => x_msg_data,

Line 661: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

657: l_api_version CONSTANT NUMBER := 1;
658: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
659: rec_num INTEGER := 0;
660: BEGIN
661: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
662: p_pkg_name => G_PKG_NAME,
663: p_init_msg_list => p_init_msg_list,
664: l_api_version => l_api_version,
665: p_api_version => p_api_version,

Line 691: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

687: RAISE G_EXCEPTION_ERROR;
688: END IF;
689:
690: END LOOP;
691: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
692: x_msg_data => x_msg_data);
693: x_return_status := l_return_status;
694: EXCEPTION
695: WHEN G_EXCEPTION_ERROR THEN

Line 696: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

692: x_msg_data => x_msg_data);
693: x_return_status := l_return_status;
694: EXCEPTION
695: WHEN G_EXCEPTION_ERROR THEN
696: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
697: p_pkg_name => G_PKG_NAME,
698: p_exc_name => G_EXC_NAME_ERROR,
699: x_msg_count => x_msg_count,
700: x_msg_data => x_msg_data,

Line 703: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

699: x_msg_count => x_msg_count,
700: x_msg_data => x_msg_data,
701: p_api_type => G_API_TYPE);
702: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
703: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
704: p_pkg_name => G_PKG_NAME,
705: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
706: x_msg_count => x_msg_count,
707: x_msg_data => x_msg_data,

Line 710: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

706: x_msg_count => x_msg_count,
707: x_msg_data => x_msg_data,
708: p_api_type => G_API_TYPE);
709: WHEN OTHERS THEN
710: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
711: p_pkg_name => G_PKG_NAME,
712: p_exc_name => G_EXC_NAME_OTHERS,
713: x_msg_count => x_msg_count,
714: x_msg_data => x_msg_data,

Line 734: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,

730: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
731: rec_num INTEGER := 0;
732: BEGIN
733:
734: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
735: p_pkg_name => G_PKG_NAME,
736: p_init_msg_list => p_init_msg_list,
737: l_api_version => l_api_version,
738: p_api_version => p_api_version,

Line 764: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

760: RAISE G_EXCEPTION_ERROR;
761: END IF;
762:
763: END LOOP;
764: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
765: x_msg_data => x_msg_data);
766: x_return_status := l_return_status;
767: EXCEPTION
768: WHEN G_EXCEPTION_ERROR THEN

Line 769: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

765: x_msg_data => x_msg_data);
766: x_return_status := l_return_status;
767: EXCEPTION
768: WHEN G_EXCEPTION_ERROR THEN
769: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
770: p_pkg_name => G_PKG_NAME,
771: p_exc_name => G_EXC_NAME_ERROR,
772: x_msg_count => x_msg_count,
773: x_msg_data => x_msg_data,

Line 776: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

772: x_msg_count => x_msg_count,
773: x_msg_data => x_msg_data,
774: p_api_type => G_API_TYPE);
775: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
776: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
777: p_pkg_name => G_PKG_NAME,
778: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
779: x_msg_count => x_msg_count,
780: x_msg_data => x_msg_data,

Line 783: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,

779: x_msg_count => x_msg_count,
780: x_msg_data => x_msg_data,
781: p_api_type => G_API_TYPE);
782: WHEN OTHERS THEN
783: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
784: p_pkg_name => G_PKG_NAME,
785: p_exc_name => G_EXC_NAME_OTHERS,
786: x_msg_count => x_msg_count,
787: x_msg_data => x_msg_data,