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

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

68:
69:
70: BEGIN
71:
72: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
73: p_pkg_name => G_PKG_NAME,
74: p_init_msg_list => p_init_msg_list,
75: l_api_version => l_api_version,
76: p_api_version => p_api_version,

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

145: l_sirv_rec := x_sirv_rec;
146:
147:
148:
149: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
150: x_msg_data => x_msg_data);
151: x_return_status := l_return_status;
152: EXCEPTION
153: WHEN G_EXCEPTION_ERROR THEN

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

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

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

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

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

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

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

203:
204:
205: BEGIN
206:
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 => l_init_msg_list,
210: l_api_version => l_api_version,
211: p_api_version => l_api_version,

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

280: l_sirv_rec := x_sirv_rec;
281:
282:
283:
284: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
285: x_msg_data => x_msg_data);
286: x_return_status := l_return_status;
287: EXCEPTION
288: WHEN G_EXCEPTION_ERROR THEN

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

285: x_msg_data => x_msg_data);
286: x_return_status := l_return_status;
287: EXCEPTION
288: WHEN G_EXCEPTION_ERROR THEN
289: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
290: p_pkg_name => G_PKG_NAME,
291: p_exc_name => G_EXC_NAME_ERROR,
292: x_msg_count => x_msg_count,
293: x_msg_data => x_msg_data,

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

292: x_msg_count => x_msg_count,
293: x_msg_data => x_msg_data,
294: p_api_type => G_API_TYPE);
295: WHEN G_EXCEPTION_UNEXPECTED_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_UNEXP_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 OTHERS 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_OTHERS,
306: x_msg_count => x_msg_count,
307: x_msg_data => x_msg_data,

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

337:
338:
339: BEGIN
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 422: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

418: l_sirv_rec := x_sirv_rec;
419:
420:
421:
422: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
423: x_msg_data => x_msg_data);
424: x_return_status := l_return_status;
425: EXCEPTION
426: WHEN G_EXCEPTION_ERROR THEN

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

423: x_msg_data => x_msg_data);
424: x_return_status := l_return_status;
425: EXCEPTION
426: WHEN G_EXCEPTION_ERROR THEN
427: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
428: p_pkg_name => G_PKG_NAME,
429: p_exc_name => G_EXC_NAME_ERROR,
430: x_msg_count => x_msg_count,
431: x_msg_data => x_msg_data,

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

430: x_msg_count => x_msg_count,
431: x_msg_data => x_msg_data,
432: p_api_type => G_API_TYPE);
433: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
434: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
435: p_pkg_name => G_PKG_NAME,
436: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
437: x_msg_count => x_msg_count,
438: x_msg_data => x_msg_data,

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

437: x_msg_count => x_msg_count,
438: x_msg_data => x_msg_data,
439: p_api_type => G_API_TYPE);
440: WHEN OTHERS THEN
441: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
442: p_pkg_name => G_PKG_NAME,
443: p_exc_name => G_EXC_NAME_OTHERS,
444: x_msg_count => x_msg_count,
445: x_msg_data => x_msg_data,

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

475:
476:
477: BEGIN
478:
479: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
480: p_pkg_name => G_PKG_NAME,
481: p_init_msg_list => l_init_msg_list,
482: l_api_version => l_api_version,
483: p_api_version => l_api_version,

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

556: l_sirv_rec := x_sirv_rec;
557:
558:
559:
560: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
561: x_msg_data => x_msg_data);
562: x_return_status := l_return_status;
563: EXCEPTION
564: WHEN G_EXCEPTION_ERROR THEN

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

561: x_msg_data => x_msg_data);
562: x_return_status := l_return_status;
563: EXCEPTION
564: WHEN G_EXCEPTION_ERROR THEN
565: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
566: p_pkg_name => G_PKG_NAME,
567: p_exc_name => G_EXC_NAME_ERROR,
568: x_msg_count => x_msg_count,
569: x_msg_data => x_msg_data,

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

568: x_msg_count => x_msg_count,
569: x_msg_data => x_msg_data,
570: p_api_type => G_API_TYPE);
571: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
572: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
573: p_pkg_name => G_PKG_NAME,
574: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
575: x_msg_count => x_msg_count,
576: x_msg_data => x_msg_data,

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

575: x_msg_count => x_msg_count,
576: x_msg_data => x_msg_data,
577: p_api_type => G_API_TYPE);
578: WHEN OTHERS THEN
579: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
580: p_pkg_name => G_PKG_NAME,
581: p_exc_name => G_EXC_NAME_OTHERS,
582: x_msg_count => x_msg_count,
583: x_msg_data => x_msg_data,

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

606:
607:
608: BEGIN
609:
610: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
611: p_pkg_name => G_PKG_NAME,
612: p_init_msg_list => p_init_msg_list,
613: l_api_version => l_api_version,
614: p_api_version => p_api_version,

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

643: -- Assign record returned by private api to local record
644: l_sirv_rec := x_sirv_rec;
645:
646:
647: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
648: x_msg_data => x_msg_data);
649: x_return_status := l_return_status;
650: EXCEPTION
651: WHEN G_EXCEPTION_ERROR THEN

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

648: x_msg_data => x_msg_data);
649: x_return_status := l_return_status;
650: EXCEPTION
651: WHEN G_EXCEPTION_ERROR THEN
652: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
653: p_pkg_name => G_PKG_NAME,
654: p_exc_name => G_EXC_NAME_ERROR,
655: x_msg_count => x_msg_count,
656: x_msg_data => x_msg_data,

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

655: x_msg_count => x_msg_count,
656: x_msg_data => x_msg_data,
657: p_api_type => G_API_TYPE);
658: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
659: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
660: p_pkg_name => G_PKG_NAME,
661: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
662: x_msg_count => x_msg_count,
663: x_msg_data => x_msg_data,

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

662: x_msg_count => x_msg_count,
663: x_msg_data => x_msg_data,
664: p_api_type => G_API_TYPE);
665: WHEN OTHERS THEN
666: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
667: p_pkg_name => G_PKG_NAME,
668: p_exc_name => G_EXC_NAME_OTHERS,
669: x_msg_count => x_msg_count,
670: x_msg_data => x_msg_data,

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

688: l_api_version CONSTANT NUMBER := 1;
689:
690: BEGIN
691:
692: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
693: p_pkg_name => G_PKG_NAME,
694: p_init_msg_list => l_init_msg_list,
695: l_api_version => l_api_version,
696: p_api_version => l_api_version,

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

725: -- Assign record returned by private api to local record
726: l_sirv_rec := x_sirv_rec;
727:
728:
729: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
730: x_msg_data => x_msg_data);
731: x_return_status := l_return_status;
732: EXCEPTION
733: WHEN G_EXCEPTION_ERROR THEN

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

730: x_msg_data => x_msg_data);
731: x_return_status := l_return_status;
732: EXCEPTION
733: WHEN G_EXCEPTION_ERROR THEN
734: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
735: p_pkg_name => G_PKG_NAME,
736: p_exc_name => G_EXC_NAME_ERROR,
737: x_msg_count => x_msg_count,
738: x_msg_data => x_msg_data,

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

737: x_msg_count => x_msg_count,
738: x_msg_data => x_msg_data,
739: p_api_type => G_API_TYPE);
740: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
741: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
742: p_pkg_name => G_PKG_NAME,
743: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
744: x_msg_count => x_msg_count,
745: x_msg_data => x_msg_data,

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

744: x_msg_count => x_msg_count,
745: x_msg_data => x_msg_data,
746: p_api_type => G_API_TYPE);
747: WHEN OTHERS THEN
748: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
749: p_pkg_name => G_PKG_NAME,
750: p_exc_name => G_EXC_NAME_OTHERS,
751: x_msg_count => x_msg_count,
752: x_msg_data => x_msg_data,

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

773: lx_msg_count NUMBER ;
774:
775: BEGIN
776:
777: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
778: p_pkg_name => G_PKG_NAME,
779: p_init_msg_list => p_init_msg_list,
780: l_api_version => l_api_version,
781: p_api_version => p_api_version,

Line 815: OKL_API.END_ACTIVITY(x_msg_count => lx_msg_count,

811: -- Assign record returned by private api to local record
812: l_sirv_rec := lx_sirv_rec;
813:
814:
815: OKL_API.END_ACTIVITY(x_msg_count => lx_msg_count,
816: x_msg_data => lx_msg_data);
817: x_return_status := l_return_status;
818: EXCEPTION
819: WHEN G_EXCEPTION_ERROR THEN

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

816: x_msg_data => lx_msg_data);
817: x_return_status := l_return_status;
818: EXCEPTION
819: WHEN G_EXCEPTION_ERROR THEN
820: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
821: p_pkg_name => G_PKG_NAME,
822: p_exc_name => G_EXC_NAME_ERROR,
823: x_msg_count => lx_msg_count,
824: x_msg_data => lx_msg_data,

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

823: x_msg_count => lx_msg_count,
824: x_msg_data => lx_msg_data,
825: p_api_type => G_API_TYPE);
826: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
827: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
828: p_pkg_name => G_PKG_NAME,
829: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
830: x_msg_count => lx_msg_count,
831: x_msg_data => lx_msg_data,

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

830: x_msg_count => lx_msg_count,
831: x_msg_data => lx_msg_data,
832: p_api_type => G_API_TYPE);
833: WHEN OTHERS THEN
834: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
835: p_pkg_name => G_PKG_NAME,
836: p_exc_name => G_EXC_NAME_OTHERS,
837: x_msg_count => lx_msg_count,
838: x_msg_data => lx_msg_data,

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

860:
861:
862: BEGIN
863:
864: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
865: p_pkg_name => G_PKG_NAME,
866: p_init_msg_list => l_init_msg_list,
867: l_api_version => l_api_version,
868: p_api_version => l_api_version,

Line 902: OKL_API.END_ACTIVITY(x_msg_count => lx_msg_count,

898: -- Assign record returned by private api to local record
899: l_sirv_rec := lx_sirv_rec;
900:
901:
902: OKL_API.END_ACTIVITY(x_msg_count => lx_msg_count,
903: x_msg_data => lx_msg_data);
904: x_return_status := l_return_status;
905: EXCEPTION
906: WHEN G_EXCEPTION_ERROR THEN

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

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

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

910: x_msg_count => lx_msg_count,
911: x_msg_data => lx_msg_data,
912: p_api_type => G_API_TYPE);
913: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
914: x_return_status := OKL_API.HANDLE_EXCEPTIONS(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 => lx_msg_count,
918: x_msg_data => lx_msg_data,

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

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

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

957: l_sre_date VARCHAR2(30);
958:
959: BEGIN
960: --dbms_output.put_line('populate_sif_ret_strms start pub');
961: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
962: p_pkg_name => G_PKG_NAME,
963: p_init_msg_list => p_init_msg_list,
964: l_api_version => l_api_version,
965: p_api_version => p_api_version,

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

1042: -- Assign record returned by private api to local record
1043: l_srsv_rec := x_srsv_rec;
1044:
1045:
1046: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1047: x_msg_data => x_msg_data);
1048: x_return_status := l_return_status;
1049: EXCEPTION
1050: WHEN G_EXCEPTION_ERROR THEN

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

1047: x_msg_data => x_msg_data);
1048: x_return_status := l_return_status;
1049: EXCEPTION
1050: WHEN G_EXCEPTION_ERROR THEN
1051: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1052: p_pkg_name => G_PKG_NAME,
1053: p_exc_name => G_EXC_NAME_ERROR,
1054: x_msg_count => x_msg_count,
1055: x_msg_data => x_msg_data,

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

1054: x_msg_count => x_msg_count,
1055: x_msg_data => x_msg_data,
1056: p_api_type => G_API_TYPE);
1057: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1058: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1059: p_pkg_name => G_PKG_NAME,
1060: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
1061: x_msg_count => x_msg_count,
1062: x_msg_data => x_msg_data,

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

1061: x_msg_count => x_msg_count,
1062: x_msg_data => x_msg_data,
1063: p_api_type => G_API_TYPE);
1064: WHEN OTHERS THEN
1065: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1066: p_pkg_name => G_PKG_NAME,
1067: p_exc_name => G_EXC_NAME_OTHERS,
1068: x_msg_count => x_msg_count,
1069: x_msg_data => x_msg_data,

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

1098: l_sre_date VARCHAR2(30);
1099:
1100: BEGIN
1101: --dbms_output.put_line('populate_sif_ret_strms start pub');
1102: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
1103: p_pkg_name => G_PKG_NAME,
1104: p_init_msg_list => p_init_msg_list,
1105: l_api_version => l_api_version,
1106: p_api_version => p_api_version,

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

1183: -- Assign record returned by private api to local record
1184: l_srsv_rec := x_srsv_rec;
1185:
1186:
1187: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1188: x_msg_data => x_msg_data);
1189: x_return_status := l_return_status;
1190: EXCEPTION
1191: WHEN G_EXCEPTION_ERROR THEN

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

1188: x_msg_data => x_msg_data);
1189: x_return_status := l_return_status;
1190: EXCEPTION
1191: WHEN G_EXCEPTION_ERROR THEN
1192: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1193: p_pkg_name => G_PKG_NAME,
1194: p_exc_name => G_EXC_NAME_ERROR,
1195: x_msg_count => x_msg_count,
1196: x_msg_data => x_msg_data,

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

1195: x_msg_count => x_msg_count,
1196: x_msg_data => x_msg_data,
1197: p_api_type => G_API_TYPE);
1198: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1199: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1200: p_pkg_name => G_PKG_NAME,
1201: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
1202: x_msg_count => x_msg_count,
1203: x_msg_data => x_msg_data,

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

1202: x_msg_count => x_msg_count,
1203: x_msg_data => x_msg_data,
1204: p_api_type => G_API_TYPE);
1205: WHEN OTHERS THEN
1206: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1207: p_pkg_name => G_PKG_NAME,
1208: p_exc_name => G_EXC_NAME_OTHERS,
1209: x_msg_count => x_msg_count,
1210: x_msg_data => x_msg_data,

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

1237: x_msg_count NUMBER ;
1238:
1239: BEGIN
1240: --DBMS_OUTPUT.PUT_LINE('INSIDE PUB Procedure ');
1241: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
1242: p_pkg_name => G_PKG_NAME,
1243: p_init_msg_list => p_init_msg_list,
1244: l_api_version => l_api_version,
1245: p_api_version => p_api_version,

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

1292: -- Assign record returned by private api to local record
1293: l_srsv_rec := x_srsv_rec;
1294:
1295:
1296: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1297: x_msg_data => x_msg_data);
1298: x_return_status := l_return_status;
1299: EXCEPTION
1300: WHEN G_EXCEPTION_ERROR THEN

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

1297: x_msg_data => x_msg_data);
1298: x_return_status := l_return_status;
1299: EXCEPTION
1300: WHEN G_EXCEPTION_ERROR THEN
1301: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1302: p_pkg_name => G_PKG_NAME,
1303: p_exc_name => G_EXC_NAME_ERROR,
1304: x_msg_count => x_msg_count,
1305: x_msg_data => x_msg_data,

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

1304: x_msg_count => x_msg_count,
1305: x_msg_data => x_msg_data,
1306: p_api_type => G_API_TYPE);
1307: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1308: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1309: p_pkg_name => G_PKG_NAME,
1310: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
1311: x_msg_count => x_msg_count,
1312: x_msg_data => x_msg_data,

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

1311: x_msg_count => x_msg_count,
1312: x_msg_data => x_msg_data,
1313: p_api_type => G_API_TYPE);
1314: WHEN OTHERS THEN
1315: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1316: p_pkg_name => G_PKG_NAME,
1317: p_exc_name => G_EXC_NAME_OTHERS,
1318: x_msg_count => x_msg_count,
1319: x_msg_data => x_msg_data,

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

1347: x_msg_data VARCHAR2(400);
1348: x_msg_count NUMBER ;
1349:
1350: BEGIN
1351: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
1352: p_pkg_name => G_PKG_NAME,
1353: p_init_msg_list => p_init_msg_list,
1354: l_api_version => l_api_version,
1355: p_api_version => p_api_version,

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

1405: -- Assign record returned by private api to local record
1406: l_srmv_rec := x_srmv_rec;
1407:
1408:
1409: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1410: x_msg_data => x_msg_data);
1411: x_return_status := l_return_status;
1412: EXCEPTION
1413: WHEN G_EXCEPTION_ERROR THEN

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

1410: x_msg_data => x_msg_data);
1411: x_return_status := l_return_status;
1412: EXCEPTION
1413: WHEN G_EXCEPTION_ERROR THEN
1414: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1415: p_pkg_name => G_PKG_NAME,
1416: p_exc_name => G_EXC_NAME_ERROR,
1417: x_msg_count => x_msg_count,
1418: x_msg_data => x_msg_data,

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

1417: x_msg_count => x_msg_count,
1418: x_msg_data => x_msg_data,
1419: p_api_type => G_API_TYPE);
1420: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1421: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1422: p_pkg_name => G_PKG_NAME,
1423: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
1424: x_msg_count => x_msg_count,
1425: x_msg_data => x_msg_data,

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

1424: x_msg_count => x_msg_count,
1425: x_msg_data => x_msg_data,
1426: p_api_type => G_API_TYPE);
1427: WHEN OTHERS THEN
1428: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1429: p_pkg_name => G_PKG_NAME,
1430: p_exc_name => G_EXC_NAME_OTHERS,
1431: x_msg_count => x_msg_count,
1432: x_msg_data => x_msg_data,

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

1459: l_init_msg_list VARCHAR2(1) := 'F';
1460:
1461:
1462: BEGIN
1463: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
1464: p_pkg_name => G_PKG_NAME,
1465: p_init_msg_list => l_init_msg_list,
1466: l_api_version => l_api_version,
1467: p_api_version => l_api_version,

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

1517: -- Assign record returned by private api to local record
1518: l_srmv_rec := x_srmv_rec;
1519:
1520:
1521: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
1522: x_msg_data => x_msg_data);
1523: x_return_status := l_return_status;
1524: EXCEPTION
1525: WHEN G_EXCEPTION_ERROR THEN

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

1522: x_msg_data => x_msg_data);
1523: x_return_status := l_return_status;
1524: EXCEPTION
1525: WHEN G_EXCEPTION_ERROR THEN
1526: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1527: p_pkg_name => G_PKG_NAME,
1528: p_exc_name => G_EXC_NAME_ERROR,
1529: x_msg_count => x_msg_count,
1530: x_msg_data => x_msg_data,

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

1529: x_msg_count => x_msg_count,
1530: x_msg_data => x_msg_data,
1531: p_api_type => G_API_TYPE);
1532: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1533: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1534: p_pkg_name => G_PKG_NAME,
1535: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
1536: x_msg_count => x_msg_count,
1537: x_msg_data => x_msg_data,

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

1536: x_msg_count => x_msg_count,
1537: x_msg_data => x_msg_data,
1538: p_api_type => G_API_TYPE);
1539: WHEN OTHERS THEN
1540: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1541: p_pkg_name => G_PKG_NAME,
1542: p_exc_name => G_EXC_NAME_OTHERS,
1543: x_msg_count => x_msg_count,
1544: x_msg_data => x_msg_data,

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

1583: WHERE id = khr_id;
1584:
1585: BEGIN
1586:
1587: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
1588: p_pkg_name => G_PKG_NAME,
1589: p_init_msg_list => p_init_msg_list,
1590: l_api_version => l_api_version,
1591: p_api_version => p_api_version,

Line 1649: OKL_API.END_ACTIVITY(x_msg_count => lx_msg_count,

1645: RAISE G_EXCEPTION_ERROR;
1646: END IF;
1647:
1648:
1649: OKL_API.END_ACTIVITY(x_msg_count => lx_msg_count,
1650: x_msg_data => lx_msg_data);
1651:
1652: x_return_status := l_return_status;
1653: EXCEPTION

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

1651:
1652: x_return_status := l_return_status;
1653: EXCEPTION
1654: WHEN G_EXCEPTION_ERROR THEN
1655: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1656: p_pkg_name => G_PKG_NAME,
1657: p_exc_name => G_EXC_NAME_ERROR,
1658: x_msg_count => lx_msg_count,
1659: x_msg_data => lx_msg_data,

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

1658: x_msg_count => lx_msg_count,
1659: x_msg_data => lx_msg_data,
1660: p_api_type => G_API_TYPE);
1661: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1662: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1663: p_pkg_name => G_PKG_NAME,
1664: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
1665: x_msg_count => lx_msg_count,
1666: x_msg_data => lx_msg_data,

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

1665: x_msg_count => lx_msg_count,
1666: x_msg_data => lx_msg_data,
1667: p_api_type => G_API_TYPE);
1668: WHEN OTHERS THEN
1669: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1670: p_pkg_name => G_PKG_NAME,
1671: p_exc_name => G_EXC_NAME_OTHERS,
1672: x_msg_count => lx_msg_count,
1673: x_msg_data => lx_msg_data,

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

1711:
1712:
1713: BEGIN
1714:
1715: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
1716: p_pkg_name => G_PKG_NAME,
1717: p_init_msg_list => l_init_msg_list,
1718: l_api_version => l_api_version,
1719: p_api_version => l_api_version,

Line 1777: OKL_API.END_ACTIVITY(x_msg_count => lx_msg_count,

1773: RAISE G_EXCEPTION_ERROR;
1774: END IF;
1775:
1776:
1777: OKL_API.END_ACTIVITY(x_msg_count => lx_msg_count,
1778: x_msg_data => lx_msg_data);
1779:
1780: x_return_status := l_return_status;
1781: EXCEPTION

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

1779:
1780: x_return_status := l_return_status;
1781: EXCEPTION
1782: WHEN G_EXCEPTION_ERROR THEN
1783: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1784: p_pkg_name => G_PKG_NAME,
1785: p_exc_name => G_EXC_NAME_ERROR,
1786: x_msg_count => lx_msg_count,
1787: x_msg_data => lx_msg_data,

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

1786: x_msg_count => lx_msg_count,
1787: x_msg_data => lx_msg_data,
1788: p_api_type => G_API_TYPE);
1789: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
1790: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1791: p_pkg_name => G_PKG_NAME,
1792: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
1793: x_msg_count => lx_msg_count,
1794: x_msg_data => lx_msg_data,

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

1793: x_msg_count => lx_msg_count,
1794: x_msg_data => lx_msg_data,
1795: p_api_type => G_API_TYPE);
1796: WHEN OTHERS THEN
1797: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
1798: p_pkg_name => G_PKG_NAME,
1799: p_exc_name => G_EXC_NAME_OTHERS,
1800: x_msg_count => lx_msg_count,
1801: x_msg_data => lx_msg_data,

Line 1821: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1817: ID,ORP_CODE
1818: FROM Okl_Stream_Interfaces
1819: WHERE okl_stream_interfaces.transaction_number = trx_number;
1820:
1821: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1822: lp_sifv_rec sifv_rec_type;
1823: lx_sifv_rec sifv_rec_type;
1824: lx_msg_count NUMBER;
1825: lx_msg_data VARCHAR2(100);

Line 1885: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1881: ID
1882: FROM Okl_Sif_Rets
1883: WHERE okl_sif_rets.transaction_number = trx_number;
1884:
1885: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1886: lp_sifv_rec sifv_rec_type;
1887: lx_sifv_rec sifv_rec_type;
1888: lp_sirv_rec sirv_rec_type;
1889: lx_sirv_rec sirv_rec_type;

Line 1977: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

1973: ID
1974: FROM Okl_Sif_Rets
1975: WHERE okl_sif_rets.transaction_number = trx_number;
1976:
1977: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1978: lp_sifv_rec sifv_rec_type;
1979: lx_sifv_rec sifv_rec_type;
1980: lp_sirv_rec sirv_rec_type;
1981: lx_sirv_rec sirv_rec_type;

Line 2066: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2062: ) IS
2063:
2064: l_api_name CONSTANT VARCHAR2(30) := 'populate_sif_rets';
2065: l_api_version CONSTANT NUMBER := 1;
2066: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2067:
2068: CURSOR sif_data_csr (trx_number IN NUMBER) IS
2069: SELECT
2070: SIS_CODE

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

2165: x_msg_data VARCHAR2(400);
2166: x_msg_count NUMBER ;
2167:
2168: BEGIN
2169: l_return_status := OKL_API.START_ACTIVITY(p_api_name => l_api_name,
2170: p_pkg_name => G_PKG_NAME,
2171: p_init_msg_list => l_init_msg_list,
2172: l_api_version => l_api_version,
2173: p_api_version => l_api_version,

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

2215: -- Assign record returned by private api to local record
2216: l_srlv_rec := x_srlv_rec;
2217:
2218:
2219: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2220: x_msg_data => x_msg_data);
2221: x_return_status := l_return_status;
2222: EXCEPTION
2223: WHEN G_EXCEPTION_ERROR THEN

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

2220: x_msg_data => x_msg_data);
2221: x_return_status := l_return_status;
2222: EXCEPTION
2223: WHEN G_EXCEPTION_ERROR THEN
2224: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2225: p_pkg_name => G_PKG_NAME,
2226: p_exc_name => G_EXC_NAME_ERROR,
2227: x_msg_count => x_msg_count,
2228: x_msg_data => x_msg_data,

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

2227: x_msg_count => x_msg_count,
2228: x_msg_data => x_msg_data,
2229: p_api_type => G_API_TYPE);
2230: WHEN G_EXCEPTION_UNEXPECTED_ERROR THEN
2231: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2232: p_pkg_name => G_PKG_NAME,
2233: p_exc_name => G_EXC_NAME_UNEXP_ERROR,
2234: x_msg_count => x_msg_count,
2235: x_msg_data => x_msg_data,

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

2234: x_msg_count => x_msg_count,
2235: x_msg_data => x_msg_data,
2236: p_api_type => G_API_TYPE);
2237: WHEN OTHERS THEN
2238: x_return_status := OKL_API.HANDLE_EXCEPTIONS(p_api_name => l_api_name,
2239: p_pkg_name => G_PKG_NAME,
2240: p_exc_name => G_EXC_NAME_OTHERS,
2241: x_msg_count => x_msg_count,
2242: x_msg_data => x_msg_data,