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

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

28: l_api_name VARCHAR2(30):= 'create_strm_gen_template';
29: l_api_version NUMBER := 1.0;
30: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
31: BEGIN
32: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
33: p_pkg_name => G_PKG_NAME,
34: p_init_msg_list => p_init_msg_list,
35: l_api_version => l_api_version,
36: p_api_version => p_api_version,

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

60: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
61: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
62: END IF;
63:
64: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
65: x_msg_data => x_msg_data);
66: x_return_status := l_return_status;
67: EXCEPTION
68: WHEN G_EXCEPTION_ERROR THEN

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

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

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

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

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

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

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

116: l_api_name VARCHAR2(30):= 'update_strm_gen_template';
117: l_api_version NUMBER := 1.0;
118: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
119: BEGIN
120: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
121: p_pkg_name => G_PKG_NAME,
122: p_init_msg_list => p_init_msg_list,
123: l_api_version => l_api_version,
124: p_api_version => p_api_version,

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

147: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
148: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
149: END IF;
150:
151: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
152: x_msg_data => x_msg_data);
153: x_return_status := l_return_status;
154: EXCEPTION
155: WHEN G_EXCEPTION_ERROR THEN

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

152: x_msg_data => x_msg_data);
153: x_return_status := l_return_status;
154: EXCEPTION
155: WHEN G_EXCEPTION_ERROR THEN
156: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
157: p_pkg_name => G_PKG_NAME,
158: p_exc_name => G_EXC_NAME_ERROR,
159: x_msg_count => x_msg_count,
160: x_msg_data => x_msg_data,

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

159: x_msg_count => x_msg_count,
160: x_msg_data => x_msg_data,
161: p_api_type => '_PUB');
162: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
163: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
164: p_pkg_name => G_PKG_NAME,
165: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
166: x_msg_count => x_msg_count,
167: x_msg_data => x_msg_data,

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

166: x_msg_count => x_msg_count,
167: x_msg_data => x_msg_data,
168: p_api_type => '_PUB');
169: WHEN OTHERS THEN
170: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
171: p_pkg_name => G_PKG_NAME,
172: p_exc_name => G_EXC_NAME_OTHERS,
173: x_msg_count => x_msg_count,
174: x_msg_data => x_msg_data,

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

203: l_api_name VARCHAR2(30):= 'update_dep_strms';
204: l_api_version NUMBER := 1.0;
205: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
206: BEGIN
207: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
208: p_pkg_name => G_PKG_NAME,
209: p_init_msg_list => p_init_msg_list,
210: l_api_version => l_api_version,
211: p_api_version => p_api_version,

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

234: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
235: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
236: END IF;
237:
238: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
239: x_msg_data => x_msg_data);
240: x_return_status := l_return_status;
241: EXCEPTION
242: WHEN G_EXCEPTION_ERROR THEN

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

239: x_msg_data => x_msg_data);
240: x_return_status := l_return_status;
241: EXCEPTION
242: WHEN G_EXCEPTION_ERROR THEN
243: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
244: p_pkg_name => G_PKG_NAME,
245: p_exc_name => G_EXC_NAME_ERROR,
246: x_msg_count => x_msg_count,
247: x_msg_data => x_msg_data,

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

246: x_msg_count => x_msg_count,
247: x_msg_data => x_msg_data,
248: p_api_type => '_PUB');
249: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
250: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
251: p_pkg_name => G_PKG_NAME,
252: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
253: x_msg_count => x_msg_count,
254: x_msg_data => x_msg_data,

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

253: x_msg_count => x_msg_count,
254: x_msg_data => x_msg_data,
255: p_api_type => '_PUB');
256: WHEN OTHERS THEN
257: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
258: p_pkg_name => G_PKG_NAME,
259: p_exc_name => G_EXC_NAME_OTHERS,
260: x_msg_count => x_msg_count,
261: x_msg_data => x_msg_data,

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

289: l_api_name VARCHAR2(30):= 'create_version_duplicate';
290: l_api_version NUMBER := 1.0;
291: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
292: BEGIN
293: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
294: p_pkg_name => G_PKG_NAME,
295: p_init_msg_list => p_init_msg_list,
296: l_api_version => l_api_version,
297: p_api_version => p_api_version,

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

319: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
320: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
321: END IF;
322:
323: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
324: x_msg_data => x_msg_data);
325: x_return_status := l_return_status;
326: EXCEPTION
327: WHEN G_EXCEPTION_ERROR THEN

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

324: x_msg_data => x_msg_data);
325: x_return_status := l_return_status;
326: EXCEPTION
327: WHEN G_EXCEPTION_ERROR THEN
328: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
329: p_pkg_name => G_PKG_NAME,
330: p_exc_name => G_EXC_NAME_ERROR,
331: x_msg_count => x_msg_count,
332: x_msg_data => x_msg_data,

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

331: x_msg_count => x_msg_count,
332: x_msg_data => x_msg_data,
333: p_api_type => '_PUB');
334: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
335: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
336: p_pkg_name => G_PKG_NAME,
337: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
338: x_msg_count => x_msg_count,
339: x_msg_data => x_msg_data,

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

338: x_msg_count => x_msg_count,
339: x_msg_data => x_msg_data,
340: p_api_type => '_PUB');
341: WHEN OTHERS THEN
342: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
343: p_pkg_name => G_PKG_NAME,
344: p_exc_name => G_EXC_NAME_OTHERS,
345: x_msg_count => x_msg_count,
346: x_msg_data => x_msg_data,

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

372: l_api_name VARCHAR2(30):= 'delete_tmpt_prc_params';
373: l_api_version NUMBER := 1.0;
374: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
375: BEGIN
376: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
377: p_pkg_name => G_PKG_NAME,
378: p_init_msg_list => p_init_msg_list,
379: l_api_version => l_api_version,
380: p_api_version => p_api_version,

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

400: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
401: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
402: END IF;
403:
404: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
405: x_msg_data => x_msg_data);
406: x_return_status := l_return_status;
407: EXCEPTION
408: WHEN G_EXCEPTION_ERROR THEN

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

405: x_msg_data => x_msg_data);
406: x_return_status := l_return_status;
407: EXCEPTION
408: WHEN G_EXCEPTION_ERROR THEN
409: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
410: p_pkg_name => G_PKG_NAME,
411: p_exc_name => G_EXC_NAME_ERROR,
412: x_msg_count => x_msg_count,
413: x_msg_data => x_msg_data,

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

412: x_msg_count => x_msg_count,
413: x_msg_data => x_msg_data,
414: p_api_type => '_PUB');
415: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
416: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
417: p_pkg_name => G_PKG_NAME,
418: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
419: x_msg_count => x_msg_count,
420: x_msg_data => x_msg_data,

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

419: x_msg_count => x_msg_count,
420: x_msg_data => x_msg_data,
421: p_api_type => '_PUB');
422: WHEN OTHERS THEN
423: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
424: p_pkg_name => G_PKG_NAME,
425: p_exc_name => G_EXC_NAME_OTHERS,
426: x_msg_count => x_msg_count,
427: x_msg_data => x_msg_data,

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

453: l_api_version NUMBER := 1.0;
454: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
455: BEGIN
456:
457: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
458: p_pkg_name => G_PKG_NAME,
459: p_init_msg_list => p_init_msg_list,
460: l_api_version => l_api_version,
461: p_api_version => p_api_version,

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

481: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
482: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
483: END IF;
484:
485: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
486: x_msg_data => x_msg_data);
487: x_return_status := l_return_status;
488: EXCEPTION
489: WHEN G_EXCEPTION_ERROR THEN

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

486: x_msg_data => x_msg_data);
487: x_return_status := l_return_status;
488: EXCEPTION
489: WHEN G_EXCEPTION_ERROR THEN
490: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
491: p_pkg_name => G_PKG_NAME,
492: p_exc_name => G_EXC_NAME_ERROR,
493: x_msg_count => x_msg_count,
494: x_msg_data => x_msg_data,

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

493: x_msg_count => x_msg_count,
494: x_msg_data => x_msg_data,
495: p_api_type => '_PUB');
496: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
497: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
498: p_pkg_name => G_PKG_NAME,
499: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
500: x_msg_count => x_msg_count,
501: x_msg_data => x_msg_data,

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

500: x_msg_count => x_msg_count,
501: x_msg_data => x_msg_data,
502: p_api_type => '_PUB');
503: WHEN OTHERS THEN
504: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
505: p_pkg_name => G_PKG_NAME,
506: p_exc_name => G_EXC_NAME_OTHERS,
507: x_msg_count => x_msg_count,
508: x_msg_data => x_msg_data,

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

534: l_api_version NUMBER := 1.0;
535: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
536: BEGIN
537:
538: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
539: p_pkg_name => G_PKG_NAME,
540: p_init_msg_list => p_init_msg_list,
541: l_api_version => l_api_version,
542: p_api_version => p_api_version,

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

562: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
563: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
564: END IF;
565:
566: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
567: x_msg_data => x_msg_data);
568: x_return_status := l_return_status;
569: EXCEPTION
570: WHEN G_EXCEPTION_ERROR THEN

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

567: x_msg_data => x_msg_data);
568: x_return_status := l_return_status;
569: EXCEPTION
570: WHEN G_EXCEPTION_ERROR THEN
571: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
572: p_pkg_name => G_PKG_NAME,
573: p_exc_name => G_EXC_NAME_ERROR,
574: x_msg_count => x_msg_count,
575: x_msg_data => x_msg_data,

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

574: x_msg_count => x_msg_count,
575: x_msg_data => x_msg_data,
576: p_api_type => '_PUB');
577: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
578: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
579: p_pkg_name => G_PKG_NAME,
580: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
581: x_msg_count => x_msg_count,
582: x_msg_data => x_msg_data,

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

581: x_msg_count => x_msg_count,
582: x_msg_data => x_msg_data,
583: p_api_type => '_PUB');
584: WHEN OTHERS THEN
585: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
586: p_pkg_name => G_PKG_NAME,
587: p_exc_name => G_EXC_NAME_OTHERS,
588: x_msg_count => x_msg_count,
589: x_msg_data => x_msg_data,

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

618: l_api_name VARCHAR2(30):= 'validate_template';
619: l_api_version NUMBER := 1.0;
620: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
621: BEGIN
622: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
623: p_pkg_name => G_PKG_NAME,
624: p_init_msg_list => p_init_msg_list,
625: l_api_version => l_api_version,
626: p_api_version => p_api_version,

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

649: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
650: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
651: END IF;
652:
653: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
654: x_msg_data => x_msg_data);
655: x_return_status := l_return_status;
656: EXCEPTION
657: WHEN G_EXCEPTION_ERROR THEN

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

654: x_msg_data => x_msg_data);
655: x_return_status := l_return_status;
656: EXCEPTION
657: WHEN G_EXCEPTION_ERROR THEN
658: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
659: p_pkg_name => G_PKG_NAME,
660: p_exc_name => G_EXC_NAME_ERROR,
661: x_msg_count => x_msg_count,
662: x_msg_data => x_msg_data,

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

661: x_msg_count => x_msg_count,
662: x_msg_data => x_msg_data,
663: p_api_type => '_PUB');
664: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
665: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
666: p_pkg_name => G_PKG_NAME,
667: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
668: x_msg_count => x_msg_count,
669: x_msg_data => x_msg_data,

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

668: x_msg_count => x_msg_count,
669: x_msg_data => x_msg_data,
670: p_api_type => '_PUB');
671: WHEN OTHERS THEN
672: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
673: p_pkg_name => G_PKG_NAME,
674: p_exc_name => G_EXC_NAME_OTHERS,
675: x_msg_count => x_msg_count,
676: x_msg_data => x_msg_data,

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

701: l_api_name VARCHAR2(30):= 'activate_template';
702: l_api_version NUMBER := 1.0;
703: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
704: BEGIN
705: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
706: p_pkg_name => G_PKG_NAME,
707: p_init_msg_list => p_init_msg_list,
708: l_api_version => l_api_version,
709: p_api_version => p_api_version,

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

729: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
730: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
731: END IF;
732:
733: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
734: x_msg_data => x_msg_data);
735: x_return_status := l_return_status;
736: EXCEPTION
737: WHEN G_EXCEPTION_ERROR THEN

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

734: x_msg_data => x_msg_data);
735: x_return_status := l_return_status;
736: EXCEPTION
737: WHEN G_EXCEPTION_ERROR THEN
738: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
739: p_pkg_name => G_PKG_NAME,
740: p_exc_name => G_EXC_NAME_ERROR,
741: x_msg_count => x_msg_count,
742: x_msg_data => x_msg_data,

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

741: x_msg_count => x_msg_count,
742: x_msg_data => x_msg_data,
743: p_api_type => '_PUB');
744: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
745: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
746: p_pkg_name => G_PKG_NAME,
747: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
748: x_msg_count => x_msg_count,
749: x_msg_data => x_msg_data,

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

748: x_msg_count => x_msg_count,
749: x_msg_data => x_msg_data,
750: p_api_type => '_PUB');
751: WHEN OTHERS THEN
752: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
753: p_pkg_name => G_PKG_NAME,
754: p_exc_name => G_EXC_NAME_OTHERS,
755: x_msg_count => x_msg_count,
756: x_msg_data => x_msg_data,

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

784: l_api_name VARCHAR2(30):= 'validate_for_warnings';
785: l_api_version NUMBER := 1.0;
786: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
787: BEGIN
788: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
789: p_pkg_name => G_PKG_NAME,
790: p_init_msg_list => p_init_msg_list,
791: l_api_version => l_api_version,
792: p_api_version => p_api_version,

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

815: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR THEN
816: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
817: END IF;
818:
819: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
820: x_msg_data => x_msg_data);
821: x_return_status := l_return_status;
822: EXCEPTION
823: WHEN G_EXCEPTION_ERROR THEN

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

820: x_msg_data => x_msg_data);
821: x_return_status := l_return_status;
822: EXCEPTION
823: WHEN G_EXCEPTION_ERROR THEN
824: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
825: p_pkg_name => G_PKG_NAME,
826: p_exc_name => G_EXC_NAME_ERROR,
827: x_msg_count => x_msg_count,
828: x_msg_data => x_msg_data,

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

827: x_msg_count => x_msg_count,
828: x_msg_data => x_msg_data,
829: p_api_type => '_PUB');
830: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
831: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
832: p_pkg_name => G_PKG_NAME,
833: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
834: x_msg_count => x_msg_count,
835: x_msg_data => x_msg_data,

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

834: x_msg_count => x_msg_count,
835: x_msg_data => x_msg_data,
836: p_api_type => '_PUB');
837: WHEN OTHERS THEN
838: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
839: p_pkg_name => G_PKG_NAME,
840: p_exc_name => G_EXC_NAME_OTHERS,
841: x_msg_count => x_msg_count,
842: x_msg_data => x_msg_data,

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

862: l_api_name VARCHAR2(30):= 'update_pri_dep_of_sgt';
863: l_api_version NUMBER := 1.0;
864: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
865: BEGIN
866: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
867: p_pkg_name => G_PKG_NAME,
868: p_init_msg_list => p_init_msg_list,
869: l_api_version => l_api_version,
870: p_api_version => p_api_version,

Line 899: OKL_API.END_ACTIVITY(

895: ELSIF l_return_status = G_RET_STS_UNEXP_ERROR
896: THEN
897: RAISE G_EXCEPTION_UNEXPECTED_ERROR;
898: END IF;
899: OKL_API.END_ACTIVITY(
900: x_msg_count => x_msg_count,
901: x_msg_data => x_msg_data);
902: x_return_status := l_return_status;
903: EXCEPTION

Line 905: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

901: x_msg_data => x_msg_data);
902: x_return_status := l_return_status;
903: EXCEPTION
904: WHEN G_EXCEPTION_ERROR THEN
905: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
906: p_api_name => l_api_name,
907: p_pkg_name => G_PKG_NAME,
908: p_exc_name => G_EXC_NAME_ERROR,
909: x_msg_count => x_msg_count,

Line 913: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

909: x_msg_count => x_msg_count,
910: x_msg_data => x_msg_data,
911: p_api_type => '_PUB');
912: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
913: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
914: p_api_name => l_api_name,
915: p_pkg_name => G_PKG_NAME,
916: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
917: x_msg_count => x_msg_count,

Line 921: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

917: x_msg_count => x_msg_count,
918: x_msg_data => x_msg_data,
919: p_api_type => '_PUB');
920: WHEN OTHERS THEN
921: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
922: p_api_name => l_api_name,
923: p_pkg_name => G_PKG_NAME,
924: p_exc_name => G_EXC_NAME_OTHERS,
925: x_msg_count => x_msg_count,