117:
118:
119: EXCEPTION
120: WHEN FND_API.G_EXC_ERROR THEN
121: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
122: P_API_NAME => L_API_NAME
123: ,P_PKG_NAME => G_PKG_NAME
124: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
125: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
121: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
122: P_API_NAME => L_API_NAME
123: ,P_PKG_NAME => G_PKG_NAME
124: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
125: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
126: ,X_MSG_COUNT => X_MSG_COUNT
127: ,X_MSG_DATA => X_MSG_DATA
128: ,X_RETURN_STATUS => X_RETURN_STATUS);
129:
127: ,X_MSG_DATA => X_MSG_DATA
128: ,X_RETURN_STATUS => X_RETURN_STATUS);
129:
130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
131: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
132: P_API_NAME => L_API_NAME
133: ,P_PKG_NAME => G_PKG_NAME
134: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
135: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
131: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
132: P_API_NAME => L_API_NAME
133: ,P_PKG_NAME => G_PKG_NAME
134: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
135: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
136: ,X_MSG_COUNT => X_MSG_COUNT
137: ,X_MSG_DATA => X_MSG_DATA
138: ,X_RETURN_STATUS => X_RETURN_STATUS);
139:
137: ,X_MSG_DATA => X_MSG_DATA
138: ,X_RETURN_STATUS => X_RETURN_STATUS);
139:
140: WHEN OTHERS THEN
141: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
142: P_API_NAME => L_API_NAME
143: ,P_PKG_NAME => G_PKG_NAME
144: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
145: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
140: WHEN OTHERS THEN
141: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
142: P_API_NAME => L_API_NAME
143: ,P_PKG_NAME => G_PKG_NAME
144: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
145: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
146: ,X_MSG_COUNT => X_MSG_COUNT
147: ,X_MSG_DATA => X_MSG_DATA
148: ,X_RETURN_STATUS => X_RETURN_STATUS);
141: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
142: P_API_NAME => L_API_NAME
143: ,P_PKG_NAME => G_PKG_NAME
144: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
145: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
146: ,X_MSG_COUNT => X_MSG_COUNT
147: ,X_MSG_DATA => X_MSG_DATA
148: ,X_RETURN_STATUS => X_RETURN_STATUS);
149:
253:
254:
255: EXCEPTION
256: WHEN FND_API.G_EXC_ERROR THEN
257: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
258: P_API_NAME => L_API_NAME
259: ,P_PKG_NAME => G_PKG_NAME
260: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
261: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
257: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
258: P_API_NAME => L_API_NAME
259: ,P_PKG_NAME => G_PKG_NAME
260: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
261: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
262: ,X_MSG_COUNT => X_MSG_COUNT
263: ,X_MSG_DATA => X_MSG_DATA
264: ,X_RETURN_STATUS => X_RETURN_STATUS);
265:
263: ,X_MSG_DATA => X_MSG_DATA
264: ,X_RETURN_STATUS => X_RETURN_STATUS);
265:
266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
267: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
268: P_API_NAME => L_API_NAME
269: ,P_PKG_NAME => G_PKG_NAME
270: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
271: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
267: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
268: P_API_NAME => L_API_NAME
269: ,P_PKG_NAME => G_PKG_NAME
270: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
271: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
272: ,X_MSG_COUNT => X_MSG_COUNT
273: ,X_MSG_DATA => X_MSG_DATA
274: ,X_RETURN_STATUS => X_RETURN_STATUS);
275:
273: ,X_MSG_DATA => X_MSG_DATA
274: ,X_RETURN_STATUS => X_RETURN_STATUS);
275:
276: WHEN OTHERS THEN
277: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
278: P_API_NAME => L_API_NAME
279: ,P_PKG_NAME => G_PKG_NAME
280: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
281: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
276: WHEN OTHERS THEN
277: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
278: P_API_NAME => L_API_NAME
279: ,P_PKG_NAME => G_PKG_NAME
280: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
281: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
282: ,X_MSG_COUNT => X_MSG_COUNT
283: ,X_MSG_DATA => X_MSG_DATA
284: ,X_RETURN_STATUS => X_RETURN_STATUS);
277: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
278: P_API_NAME => L_API_NAME
279: ,P_PKG_NAME => G_PKG_NAME
280: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
281: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
282: ,X_MSG_COUNT => X_MSG_COUNT
283: ,X_MSG_DATA => X_MSG_DATA
284: ,X_RETURN_STATUS => X_RETURN_STATUS);
285:
391:
392:
393: EXCEPTION
394: WHEN FND_API.G_EXC_ERROR THEN
395: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
396: P_API_NAME => L_API_NAME
397: ,P_PKG_NAME => G_PKG_NAME
398: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
399: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
395: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
396: P_API_NAME => L_API_NAME
397: ,P_PKG_NAME => G_PKG_NAME
398: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
399: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
400: ,P_SQLCODE => SQLCODE
401: ,P_SQLERRM => SQLERRM
402: ,X_MSG_COUNT => X_MSG_COUNT
403: ,X_MSG_DATA => X_MSG_DATA
403: ,X_MSG_DATA => X_MSG_DATA
404: ,X_RETURN_STATUS => X_RETURN_STATUS);
405:
406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
407: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
408: P_API_NAME => L_API_NAME
409: ,P_PKG_NAME => G_PKG_NAME
410: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
411: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
407: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
408: P_API_NAME => L_API_NAME
409: ,P_PKG_NAME => G_PKG_NAME
410: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
411: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
412: ,P_SQLCODE => SQLCODE
413: ,P_SQLERRM => SQLERRM
414: ,X_MSG_COUNT => X_MSG_COUNT
415: ,X_MSG_DATA => X_MSG_DATA
415: ,X_MSG_DATA => X_MSG_DATA
416: ,X_RETURN_STATUS => X_RETURN_STATUS);
417:
418: WHEN OTHERS THEN
419: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
420: P_API_NAME => L_API_NAME
421: ,P_PKG_NAME => G_PKG_NAME
422: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
423: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
418: WHEN OTHERS THEN
419: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
420: P_API_NAME => L_API_NAME
421: ,P_PKG_NAME => G_PKG_NAME
422: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
423: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
424: ,P_SQLCODE => SQLCODE
425: ,P_SQLERRM => SQLERRM
426: ,X_MSG_COUNT => X_MSG_COUNT
419: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
420: P_API_NAME => L_API_NAME
421: ,P_PKG_NAME => G_PKG_NAME
422: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
423: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
424: ,P_SQLCODE => SQLCODE
425: ,P_SQLERRM => SQLERRM
426: ,X_MSG_COUNT => X_MSG_COUNT
427: ,X_MSG_DATA => X_MSG_DATA
530:
531:
532: EXCEPTION
533: WHEN FND_API.G_EXC_ERROR THEN
534: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
535: P_API_NAME => L_API_NAME
536: ,P_PKG_NAME => G_PKG_NAME
537: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
538: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
534: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
535: P_API_NAME => L_API_NAME
536: ,P_PKG_NAME => G_PKG_NAME
537: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
538: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
539: ,P_SQLCODE => SQLCODE
540: ,P_SQLERRM => SQLERRM
541: ,X_MSG_COUNT => X_MSG_COUNT
542: ,X_MSG_DATA => X_MSG_DATA
542: ,X_MSG_DATA => X_MSG_DATA
543: ,X_RETURN_STATUS => X_RETURN_STATUS);
544:
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
547: P_API_NAME => L_API_NAME
548: ,P_PKG_NAME => G_PKG_NAME
549: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
550: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
546: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
547: P_API_NAME => L_API_NAME
548: ,P_PKG_NAME => G_PKG_NAME
549: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
550: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
551: ,P_SQLCODE => SQLCODE
552: ,P_SQLERRM => SQLERRM
553: ,X_MSG_COUNT => X_MSG_COUNT
554: ,X_MSG_DATA => X_MSG_DATA
554: ,X_MSG_DATA => X_MSG_DATA
555: ,X_RETURN_STATUS => X_RETURN_STATUS);
556:
557: WHEN OTHERS THEN
558: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
559: P_API_NAME => L_API_NAME
560: ,P_PKG_NAME => G_PKG_NAME
561: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
562: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
557: WHEN OTHERS THEN
558: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
559: P_API_NAME => L_API_NAME
560: ,P_PKG_NAME => G_PKG_NAME
561: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
562: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
563: ,P_SQLCODE => SQLCODE
564: ,P_SQLERRM => SQLERRM
565: ,X_MSG_COUNT => X_MSG_COUNT
558: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
559: P_API_NAME => L_API_NAME
560: ,P_PKG_NAME => G_PKG_NAME
561: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
562: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
563: ,P_SQLCODE => SQLCODE
564: ,P_SQLERRM => SQLERRM
565: ,X_MSG_COUNT => X_MSG_COUNT
566: ,X_MSG_DATA => X_MSG_DATA
671: );
672:
673: EXCEPTION
674: WHEN FND_API.G_EXC_ERROR THEN
675: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
676: P_API_NAME => L_API_NAME
677: ,P_PKG_NAME => G_PKG_NAME
678: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
679: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
675: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
676: P_API_NAME => L_API_NAME
677: ,P_PKG_NAME => G_PKG_NAME
678: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
679: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
680: ,P_SQLCODE => SQLCODE
681: ,P_SQLERRM => SQLERRM
682: ,X_MSG_COUNT => X_MSG_COUNT
683: ,X_MSG_DATA => X_MSG_DATA
683: ,X_MSG_DATA => X_MSG_DATA
684: ,X_RETURN_STATUS => X_RETURN_STATUS);
685:
686: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
687: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
688: P_API_NAME => L_API_NAME
689: ,P_PKG_NAME => G_PKG_NAME
690: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
691: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
687: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
688: P_API_NAME => L_API_NAME
689: ,P_PKG_NAME => G_PKG_NAME
690: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
691: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
692: ,P_SQLCODE => SQLCODE
693: ,P_SQLERRM => SQLERRM
694: ,X_MSG_COUNT => X_MSG_COUNT
695: ,X_MSG_DATA => X_MSG_DATA
695: ,X_MSG_DATA => X_MSG_DATA
696: ,X_RETURN_STATUS => X_RETURN_STATUS);
697:
698: WHEN OTHERS THEN
699: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
700: P_API_NAME => L_API_NAME
701: ,P_PKG_NAME => G_PKG_NAME
702: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
703: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
698: WHEN OTHERS THEN
699: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
700: P_API_NAME => L_API_NAME
701: ,P_PKG_NAME => G_PKG_NAME
702: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
703: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
704: ,P_SQLCODE => SQLCODE
705: ,P_SQLERRM => SQLERRM
706: ,X_MSG_COUNT => X_MSG_COUNT
699: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
700: P_API_NAME => L_API_NAME
701: ,P_PKG_NAME => G_PKG_NAME
702: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
703: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
704: ,P_SQLCODE => SQLCODE
705: ,P_SQLERRM => SQLERRM
706: ,X_MSG_COUNT => X_MSG_COUNT
707: ,X_MSG_DATA => X_MSG_DATA
814: );
815:
816: EXCEPTION
817: WHEN FND_API.G_EXC_ERROR THEN
818: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
819: P_API_NAME => L_API_NAME
820: ,P_PKG_NAME => G_PKG_NAME
821: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
822: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
818: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
819: P_API_NAME => L_API_NAME
820: ,P_PKG_NAME => G_PKG_NAME
821: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
822: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
823: ,X_MSG_COUNT => X_MSG_COUNT
824: ,X_MSG_DATA => X_MSG_DATA
825: ,X_RETURN_STATUS => X_RETURN_STATUS);
826:
824: ,X_MSG_DATA => X_MSG_DATA
825: ,X_RETURN_STATUS => X_RETURN_STATUS);
826:
827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
828: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
829: P_API_NAME => L_API_NAME
830: ,P_PKG_NAME => G_PKG_NAME
831: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
832: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
828: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
829: P_API_NAME => L_API_NAME
830: ,P_PKG_NAME => G_PKG_NAME
831: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
832: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
833: ,X_MSG_COUNT => X_MSG_COUNT
834: ,X_MSG_DATA => X_MSG_DATA
835: ,X_RETURN_STATUS => X_RETURN_STATUS);
836:
834: ,X_MSG_DATA => X_MSG_DATA
835: ,X_RETURN_STATUS => X_RETURN_STATUS);
836:
837: WHEN OTHERS THEN
838: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
839: P_API_NAME => L_API_NAME
840: ,P_PKG_NAME => G_PKG_NAME
841: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
842: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
837: WHEN OTHERS THEN
838: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
839: P_API_NAME => L_API_NAME
840: ,P_PKG_NAME => G_PKG_NAME
841: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
842: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
843: ,X_MSG_COUNT => X_MSG_COUNT
844: ,X_MSG_DATA => X_MSG_DATA
845: ,X_RETURN_STATUS => X_RETURN_STATUS);
838: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
839: P_API_NAME => L_API_NAME
840: ,P_PKG_NAME => G_PKG_NAME
841: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
842: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
843: ,X_MSG_COUNT => X_MSG_COUNT
844: ,X_MSG_DATA => X_MSG_DATA
845: ,X_RETURN_STATUS => X_RETURN_STATUS);
846:
937: );
938:
939: EXCEPTION
940: WHEN FND_API.G_EXC_ERROR THEN
941: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
942: P_API_NAME => L_API_NAME
943: ,P_PKG_NAME => G_PKG_NAME
944: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
945: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
941: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
942: P_API_NAME => L_API_NAME
943: ,P_PKG_NAME => G_PKG_NAME
944: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
945: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
946: ,X_MSG_COUNT => X_MSG_COUNT
947: ,X_MSG_DATA => X_MSG_DATA
948: ,X_RETURN_STATUS => X_RETURN_STATUS);
949:
947: ,X_MSG_DATA => X_MSG_DATA
948: ,X_RETURN_STATUS => X_RETURN_STATUS);
949:
950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
951: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
952: P_API_NAME => L_API_NAME
953: ,P_PKG_NAME => G_PKG_NAME
954: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
955: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
951: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
952: P_API_NAME => L_API_NAME
953: ,P_PKG_NAME => G_PKG_NAME
954: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
955: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
956: ,X_MSG_COUNT => X_MSG_COUNT
957: ,X_MSG_DATA => X_MSG_DATA
958: ,X_RETURN_STATUS => X_RETURN_STATUS);
959:
957: ,X_MSG_DATA => X_MSG_DATA
958: ,X_RETURN_STATUS => X_RETURN_STATUS);
959:
960: WHEN OTHERS THEN
961: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
962: P_API_NAME => L_API_NAME
963: ,P_PKG_NAME => G_PKG_NAME
964: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
965: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
960: WHEN OTHERS THEN
961: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
962: P_API_NAME => L_API_NAME
963: ,P_PKG_NAME => G_PKG_NAME
964: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
965: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
966: ,X_MSG_COUNT => X_MSG_COUNT
967: ,X_MSG_DATA => X_MSG_DATA
968: ,X_RETURN_STATUS => X_RETURN_STATUS);
961: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
962: P_API_NAME => L_API_NAME
963: ,P_PKG_NAME => G_PKG_NAME
964: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
965: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
966: ,X_MSG_COUNT => X_MSG_COUNT
967: ,X_MSG_DATA => X_MSG_DATA
968: ,X_RETURN_STATUS => X_RETURN_STATUS);
969:
1066: );
1067:
1068: EXCEPTION
1069: WHEN FND_API.G_EXC_ERROR THEN
1070: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1071: P_API_NAME => L_API_NAME
1072: ,P_PKG_NAME => G_PKG_NAME
1073: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1074: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1070: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1071: P_API_NAME => L_API_NAME
1072: ,P_PKG_NAME => G_PKG_NAME
1073: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1074: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1075: ,X_MSG_COUNT => X_MSG_COUNT
1076: ,X_MSG_DATA => X_MSG_DATA
1077: ,X_RETURN_STATUS => X_RETURN_STATUS);
1078:
1076: ,X_MSG_DATA => X_MSG_DATA
1077: ,X_RETURN_STATUS => X_RETURN_STATUS);
1078:
1079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1080: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1081: P_API_NAME => L_API_NAME
1082: ,P_PKG_NAME => G_PKG_NAME
1083: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1084: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1080: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1081: P_API_NAME => L_API_NAME
1082: ,P_PKG_NAME => G_PKG_NAME
1083: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1084: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1085: ,X_MSG_COUNT => X_MSG_COUNT
1086: ,X_MSG_DATA => X_MSG_DATA
1087: ,X_RETURN_STATUS => X_RETURN_STATUS);
1088:
1086: ,X_MSG_DATA => X_MSG_DATA
1087: ,X_RETURN_STATUS => X_RETURN_STATUS);
1088:
1089: WHEN OTHERS THEN
1090: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1091: P_API_NAME => L_API_NAME
1092: ,P_PKG_NAME => G_PKG_NAME
1093: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1094: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1089: WHEN OTHERS THEN
1090: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1091: P_API_NAME => L_API_NAME
1092: ,P_PKG_NAME => G_PKG_NAME
1093: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1094: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1095: ,X_MSG_COUNT => X_MSG_COUNT
1096: ,X_MSG_DATA => X_MSG_DATA
1097: ,X_RETURN_STATUS => X_RETURN_STATUS);
1090: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1091: P_API_NAME => L_API_NAME
1092: ,P_PKG_NAME => G_PKG_NAME
1093: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1094: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1095: ,X_MSG_COUNT => X_MSG_COUNT
1096: ,X_MSG_DATA => X_MSG_DATA
1097: ,X_RETURN_STATUS => X_RETURN_STATUS);
1098:
1197: );
1198:
1199: EXCEPTION
1200: WHEN FND_API.G_EXC_ERROR THEN
1201: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1202: P_API_NAME => L_API_NAME
1203: ,P_PKG_NAME => G_PKG_NAME
1204: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1205: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1201: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1202: P_API_NAME => L_API_NAME
1203: ,P_PKG_NAME => G_PKG_NAME
1204: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1205: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1206: ,X_MSG_COUNT => X_MSG_COUNT
1207: ,X_MSG_DATA => X_MSG_DATA
1208: ,X_RETURN_STATUS => X_RETURN_STATUS);
1209:
1207: ,X_MSG_DATA => X_MSG_DATA
1208: ,X_RETURN_STATUS => X_RETURN_STATUS);
1209:
1210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1211: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1212: P_API_NAME => L_API_NAME
1213: ,P_PKG_NAME => G_PKG_NAME
1214: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1215: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1211: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1212: P_API_NAME => L_API_NAME
1213: ,P_PKG_NAME => G_PKG_NAME
1214: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1215: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1216: ,X_MSG_COUNT => X_MSG_COUNT
1217: ,X_MSG_DATA => X_MSG_DATA
1218: ,X_RETURN_STATUS => X_RETURN_STATUS);
1219:
1217: ,X_MSG_DATA => X_MSG_DATA
1218: ,X_RETURN_STATUS => X_RETURN_STATUS);
1219:
1220: WHEN OTHERS THEN
1221: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1222: P_API_NAME => L_API_NAME
1223: ,P_PKG_NAME => G_PKG_NAME
1224: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1225: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1220: WHEN OTHERS THEN
1221: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1222: P_API_NAME => L_API_NAME
1223: ,P_PKG_NAME => G_PKG_NAME
1224: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1225: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1226: ,X_MSG_COUNT => X_MSG_COUNT
1227: ,X_MSG_DATA => X_MSG_DATA
1228: ,X_RETURN_STATUS => X_RETURN_STATUS);
1221: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1222: P_API_NAME => L_API_NAME
1223: ,P_PKG_NAME => G_PKG_NAME
1224: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1225: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1226: ,X_MSG_COUNT => X_MSG_COUNT
1227: ,X_MSG_DATA => X_MSG_DATA
1228: ,X_RETURN_STATUS => X_RETURN_STATUS);
1229:
1333:
1334:
1335: EXCEPTION
1336: WHEN FND_API.G_EXC_ERROR THEN
1337: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1338: P_API_NAME => L_API_NAME
1339: ,P_PKG_NAME => G_PKG_NAME
1340: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1341: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1337: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1338: P_API_NAME => L_API_NAME
1339: ,P_PKG_NAME => G_PKG_NAME
1340: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1341: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1342: ,P_SQLCODE => SQLCODE
1343: ,P_SQLERRM => SQLERRM
1344: ,X_MSG_COUNT => X_MSG_COUNT
1345: ,X_MSG_DATA => X_MSG_DATA
1345: ,X_MSG_DATA => X_MSG_DATA
1346: ,X_RETURN_STATUS => X_RETURN_STATUS);
1347:
1348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1349: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1350: P_API_NAME => L_API_NAME
1351: ,P_PKG_NAME => G_PKG_NAME
1352: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1353: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1349: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1350: P_API_NAME => L_API_NAME
1351: ,P_PKG_NAME => G_PKG_NAME
1352: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1353: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1354: ,P_SQLCODE => SQLCODE
1355: ,P_SQLERRM => SQLERRM
1356: ,X_MSG_COUNT => X_MSG_COUNT
1357: ,X_MSG_DATA => X_MSG_DATA
1357: ,X_MSG_DATA => X_MSG_DATA
1358: ,X_RETURN_STATUS => X_RETURN_STATUS);
1359:
1360: WHEN OTHERS THEN
1361: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1362: P_API_NAME => L_API_NAME
1363: ,P_PKG_NAME => G_PKG_NAME
1364: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1365: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1360: WHEN OTHERS THEN
1361: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1362: P_API_NAME => L_API_NAME
1363: ,P_PKG_NAME => G_PKG_NAME
1364: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1365: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1366: ,P_SQLCODE => SQLCODE
1367: ,P_SQLERRM => SQLERRM
1368: ,X_MSG_COUNT => X_MSG_COUNT
1361: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1362: P_API_NAME => L_API_NAME
1363: ,P_PKG_NAME => G_PKG_NAME
1364: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1365: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1366: ,P_SQLCODE => SQLCODE
1367: ,P_SQLERRM => SQLERRM
1368: ,X_MSG_COUNT => X_MSG_COUNT
1369: ,X_MSG_DATA => X_MSG_DATA
1483:
1484:
1485: EXCEPTION
1486: WHEN FND_API.G_EXC_ERROR THEN
1487: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1488: P_API_NAME => L_API_NAME
1489: ,P_PKG_NAME => G_PKG_NAME
1490: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1491: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1487: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1488: P_API_NAME => L_API_NAME
1489: ,P_PKG_NAME => G_PKG_NAME
1490: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1491: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1492: ,P_SQLCODE => SQLCODE
1493: ,P_SQLERRM => SQLERRM
1494: ,X_MSG_COUNT => X_MSG_COUNT
1495: ,X_MSG_DATA => X_MSG_DATA
1495: ,X_MSG_DATA => X_MSG_DATA
1496: ,X_RETURN_STATUS => X_RETURN_STATUS);
1497:
1498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1499: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1500: P_API_NAME => L_API_NAME
1501: ,P_PKG_NAME => G_PKG_NAME
1502: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1503: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1499: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1500: P_API_NAME => L_API_NAME
1501: ,P_PKG_NAME => G_PKG_NAME
1502: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1503: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1504: ,P_SQLCODE => SQLCODE
1505: ,P_SQLERRM => SQLERRM
1506: ,X_MSG_COUNT => X_MSG_COUNT
1507: ,X_MSG_DATA => X_MSG_DATA
1507: ,X_MSG_DATA => X_MSG_DATA
1508: ,X_RETURN_STATUS => X_RETURN_STATUS);
1509:
1510: WHEN OTHERS THEN
1511: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1512: P_API_NAME => L_API_NAME
1513: ,P_PKG_NAME => G_PKG_NAME
1514: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1515: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1510: WHEN OTHERS THEN
1511: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1512: P_API_NAME => L_API_NAME
1513: ,P_PKG_NAME => G_PKG_NAME
1514: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1515: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1516: ,P_SQLCODE => SQLCODE
1517: ,P_SQLERRM => SQLERRM
1518: ,X_MSG_COUNT => X_MSG_COUNT
1511: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1512: P_API_NAME => L_API_NAME
1513: ,P_PKG_NAME => G_PKG_NAME
1514: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1515: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1516: ,P_SQLCODE => SQLCODE
1517: ,P_SQLERRM => SQLERRM
1518: ,X_MSG_COUNT => X_MSG_COUNT
1519: ,X_MSG_DATA => X_MSG_DATA
1629: p_data => x_msg_data);
1630:
1631: EXCEPTION
1632: WHEN FND_API.G_EXC_ERROR THEN
1633: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1634: P_API_NAME => L_API_NAME
1635: ,P_PKG_NAME => G_PKG_NAME
1636: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1637: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1633: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1634: P_API_NAME => L_API_NAME
1635: ,P_PKG_NAME => G_PKG_NAME
1636: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1637: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1638: ,P_SQLCODE => SQLCODE
1639: ,P_SQLERRM => SQLERRM
1640: ,X_MSG_COUNT => X_MSG_COUNT
1641: ,X_MSG_DATA => X_MSG_DATA
1641: ,X_MSG_DATA => X_MSG_DATA
1642: ,X_RETURN_STATUS => X_RETURN_STATUS);
1643:
1644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1645: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1646: P_API_NAME => L_API_NAME
1647: ,P_PKG_NAME => G_PKG_NAME
1648: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1649: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1645: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1646: P_API_NAME => L_API_NAME
1647: ,P_PKG_NAME => G_PKG_NAME
1648: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1649: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1650: ,P_SQLCODE => SQLCODE
1651: ,P_SQLERRM => SQLERRM
1652: ,X_MSG_COUNT => X_MSG_COUNT
1653: ,X_MSG_DATA => X_MSG_DATA
1653: ,X_MSG_DATA => X_MSG_DATA
1654: ,X_RETURN_STATUS => X_RETURN_STATUS);
1655:
1656: WHEN OTHERS THEN
1657: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1658: P_API_NAME => L_API_NAME
1659: ,P_PKG_NAME => G_PKG_NAME
1660: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1661: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1656: WHEN OTHERS THEN
1657: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1658: P_API_NAME => L_API_NAME
1659: ,P_PKG_NAME => G_PKG_NAME
1660: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1661: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1662: ,P_SQLCODE => SQLCODE
1663: ,P_SQLERRM => SQLERRM
1664: ,X_MSG_COUNT => X_MSG_COUNT
1657: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1658: P_API_NAME => L_API_NAME
1659: ,P_PKG_NAME => G_PKG_NAME
1660: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1661: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1662: ,P_SQLCODE => SQLCODE
1663: ,P_SQLERRM => SQLERRM
1664: ,X_MSG_COUNT => X_MSG_COUNT
1665: ,X_MSG_DATA => X_MSG_DATA
1770:
1771:
1772: EXCEPTION
1773: WHEN FND_API.G_EXC_ERROR THEN
1774: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1775: P_API_NAME => L_API_NAME
1776: ,P_PKG_NAME => G_PKG_NAME
1777: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1778: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1774: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1775: P_API_NAME => L_API_NAME
1776: ,P_PKG_NAME => G_PKG_NAME
1777: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1778: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1779: ,X_MSG_COUNT => X_MSG_COUNT
1780: ,X_MSG_DATA => X_MSG_DATA
1781: ,X_RETURN_STATUS => X_RETURN_STATUS);
1782:
1780: ,X_MSG_DATA => X_MSG_DATA
1781: ,X_RETURN_STATUS => X_RETURN_STATUS);
1782:
1783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1784: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1785: P_API_NAME => L_API_NAME
1786: ,P_PKG_NAME => G_PKG_NAME
1787: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1788: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1784: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1785: P_API_NAME => L_API_NAME
1786: ,P_PKG_NAME => G_PKG_NAME
1787: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1788: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1789: ,X_MSG_COUNT => X_MSG_COUNT
1790: ,X_MSG_DATA => X_MSG_DATA
1791: ,X_RETURN_STATUS => X_RETURN_STATUS);
1792:
1790: ,X_MSG_DATA => X_MSG_DATA
1791: ,X_RETURN_STATUS => X_RETURN_STATUS);
1792:
1793: WHEN OTHERS THEN
1794: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1795: P_API_NAME => L_API_NAME
1796: ,P_PKG_NAME => G_PKG_NAME
1797: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1798: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1793: WHEN OTHERS THEN
1794: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1795: P_API_NAME => L_API_NAME
1796: ,P_PKG_NAME => G_PKG_NAME
1797: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1798: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1799: ,X_MSG_COUNT => X_MSG_COUNT
1800: ,X_MSG_DATA => X_MSG_DATA
1801: ,X_RETURN_STATUS => X_RETURN_STATUS);
1794: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1795: P_API_NAME => L_API_NAME
1796: ,P_PKG_NAME => G_PKG_NAME
1797: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1798: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1799: ,X_MSG_COUNT => X_MSG_COUNT
1800: ,X_MSG_DATA => X_MSG_DATA
1801: ,X_RETURN_STATUS => X_RETURN_STATUS);
1802:
1903:
1904:
1905: EXCEPTION
1906: WHEN FND_API.G_EXC_ERROR THEN
1907: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1908: P_API_NAME => L_API_NAME
1909: ,P_PKG_NAME => G_PKG_NAME
1910: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1911: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1907: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1908: P_API_NAME => L_API_NAME
1909: ,P_PKG_NAME => G_PKG_NAME
1910: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1911: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1912: ,X_MSG_COUNT => X_MSG_COUNT
1913: ,X_MSG_DATA => X_MSG_DATA
1914: ,X_RETURN_STATUS => X_RETURN_STATUS);
1915:
1913: ,X_MSG_DATA => X_MSG_DATA
1914: ,X_RETURN_STATUS => X_RETURN_STATUS);
1915:
1916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1917: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1918: P_API_NAME => L_API_NAME
1919: ,P_PKG_NAME => G_PKG_NAME
1920: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1921: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1917: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1918: P_API_NAME => L_API_NAME
1919: ,P_PKG_NAME => G_PKG_NAME
1920: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1921: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1922: ,X_MSG_COUNT => X_MSG_COUNT
1923: ,X_MSG_DATA => X_MSG_DATA
1924: ,X_RETURN_STATUS => X_RETURN_STATUS);
1925:
1923: ,X_MSG_DATA => X_MSG_DATA
1924: ,X_RETURN_STATUS => X_RETURN_STATUS);
1925:
1926: WHEN OTHERS THEN
1927: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1928: P_API_NAME => L_API_NAME
1929: ,P_PKG_NAME => G_PKG_NAME
1930: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1931: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1926: WHEN OTHERS THEN
1927: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1928: P_API_NAME => L_API_NAME
1929: ,P_PKG_NAME => G_PKG_NAME
1930: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1931: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1932: ,X_MSG_COUNT => X_MSG_COUNT
1933: ,X_MSG_DATA => X_MSG_DATA
1934: ,X_RETURN_STATUS => X_RETURN_STATUS);
1927: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1928: P_API_NAME => L_API_NAME
1929: ,P_PKG_NAME => G_PKG_NAME
1930: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1931: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1932: ,X_MSG_COUNT => X_MSG_COUNT
1933: ,X_MSG_DATA => X_MSG_DATA
1934: ,X_RETURN_STATUS => X_RETURN_STATUS);
1935:
2036:
2037:
2038: EXCEPTION
2039: WHEN FND_API.G_EXC_ERROR THEN
2040: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2041: P_API_NAME => L_API_NAME
2042: ,P_PKG_NAME => G_PKG_NAME
2043: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2044: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2040: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2041: P_API_NAME => L_API_NAME
2042: ,P_PKG_NAME => G_PKG_NAME
2043: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2044: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2045: ,X_MSG_COUNT => X_MSG_COUNT
2046: ,X_MSG_DATA => X_MSG_DATA
2047: ,X_RETURN_STATUS => X_RETURN_STATUS);
2048:
2046: ,X_MSG_DATA => X_MSG_DATA
2047: ,X_RETURN_STATUS => X_RETURN_STATUS);
2048:
2049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2050: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2051: P_API_NAME => L_API_NAME
2052: ,P_PKG_NAME => G_PKG_NAME
2053: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2054: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2050: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2051: P_API_NAME => L_API_NAME
2052: ,P_PKG_NAME => G_PKG_NAME
2053: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2054: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2055: ,X_MSG_COUNT => X_MSG_COUNT
2056: ,X_MSG_DATA => X_MSG_DATA
2057: ,X_RETURN_STATUS => X_RETURN_STATUS);
2058:
2056: ,X_MSG_DATA => X_MSG_DATA
2057: ,X_RETURN_STATUS => X_RETURN_STATUS);
2058:
2059: WHEN OTHERS THEN
2060: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2061: P_API_NAME => L_API_NAME
2062: ,P_PKG_NAME => G_PKG_NAME
2063: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2064: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2059: WHEN OTHERS THEN
2060: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2061: P_API_NAME => L_API_NAME
2062: ,P_PKG_NAME => G_PKG_NAME
2063: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2064: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2065: ,X_MSG_COUNT => X_MSG_COUNT
2066: ,X_MSG_DATA => X_MSG_DATA
2067: ,X_RETURN_STATUS => X_RETURN_STATUS);
2060: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2061: P_API_NAME => L_API_NAME
2062: ,P_PKG_NAME => G_PKG_NAME
2063: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2064: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2065: ,X_MSG_COUNT => X_MSG_COUNT
2066: ,X_MSG_DATA => X_MSG_DATA
2067: ,X_RETURN_STATUS => X_RETURN_STATUS);
2068: