35: x_party_id := p_party_id;
36: x_return_status := FND_API.G_RET_STS_SUCCESS;
37: IF (p_party_id IS NOT NULL
38: AND p_party_id <> FND_API.G_MISS_NUM) THEN
39: ASO_UTILITY_PVT.Set_Message(
40: p_msg_level => FND_MSG_PUB.G_MSG_LVL_SUCCESS,
41: p_msg_name => 'ASO_API_ATTRIBUTE_IGNORED',
42: p_token1 => 'COLUMN',
43: p_token1_value => p_column_name);
89: x_party_site_id := p_party_site_id;
90: x_return_status := FND_API.G_RET_STS_SUCCESS;
91: IF (p_party_site_id IS NOT NULL
92: AND p_party_site_id <> FND_API.G_MISS_NUM) THEN
93: ASO_UTILITY_PVT.Set_Message(
94: p_msg_level => FND_MSG_PUB.G_MSG_LVL_SUCCESS,
95: p_msg_name => 'ASO_API_ATTRIBUTE_IGNORED',
96: p_token1 => 'COLUMN',
97: p_token1_value => p_column_name);
663: EXCEPTION
664:
665: WHEN FND_API.G_EXC_ERROR THEN
666:
667: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
668: P_API_NAME => L_API_NAME
669: ,P_PKG_NAME => G_PKG_NAME
670: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
671: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
667: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
668: P_API_NAME => L_API_NAME
669: ,P_PKG_NAME => G_PKG_NAME
670: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
671: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
672: ,X_MSG_COUNT => X_MSG_COUNT
673: ,X_MSG_DATA => X_MSG_DATA
674: ,X_RETURN_STATUS => X_RETURN_STATUS);
675:
674: ,X_RETURN_STATUS => X_RETURN_STATUS);
675:
676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
677:
678: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
679: P_API_NAME => L_API_NAME
680: ,P_PKG_NAME => G_PKG_NAME
681: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
682: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
678: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
679: P_API_NAME => L_API_NAME
680: ,P_PKG_NAME => G_PKG_NAME
681: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
682: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
683: ,X_MSG_COUNT => X_MSG_COUNT
684: ,X_MSG_DATA => X_MSG_DATA
685: ,X_RETURN_STATUS => X_RETURN_STATUS);
686:
684: ,X_MSG_DATA => X_MSG_DATA
685: ,X_RETURN_STATUS => X_RETURN_STATUS);
686:
687: WHEN OTHERS THEN
688: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
689: P_API_NAME => L_API_NAME
690: ,P_PKG_NAME => G_PKG_NAME
691: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
692: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
687: WHEN OTHERS THEN
688: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
689: P_API_NAME => L_API_NAME
690: ,P_PKG_NAME => G_PKG_NAME
691: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
692: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
693: ,X_MSG_COUNT => X_MSG_COUNT
694: ,X_MSG_DATA => X_MSG_DATA
695: ,X_RETURN_STATUS => X_RETURN_STATUS);
688: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
689: P_API_NAME => L_API_NAME
690: ,P_PKG_NAME => G_PKG_NAME
691: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
692: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
693: ,X_MSG_COUNT => X_MSG_COUNT
694: ,X_MSG_DATA => X_MSG_DATA
695: ,X_RETURN_STATUS => X_RETURN_STATUS);
696:
792: );
793:
794: EXCEPTION
795: WHEN FND_API.G_EXC_ERROR THEN
796: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
797: P_API_NAME => L_API_NAME
798: ,P_PKG_NAME => G_PKG_NAME
799: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
800: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
796: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
797: P_API_NAME => L_API_NAME
798: ,P_PKG_NAME => G_PKG_NAME
799: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
800: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
801: ,X_MSG_COUNT => X_MSG_COUNT
802: ,X_MSG_DATA => X_MSG_DATA
803: ,X_RETURN_STATUS => X_RETURN_STATUS);
804:
802: ,X_MSG_DATA => X_MSG_DATA
803: ,X_RETURN_STATUS => X_RETURN_STATUS);
804:
805: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
806: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
807: P_API_NAME => L_API_NAME
808: ,P_PKG_NAME => G_PKG_NAME
809: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
810: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
806: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
807: P_API_NAME => L_API_NAME
808: ,P_PKG_NAME => G_PKG_NAME
809: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
810: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
811: ,X_MSG_COUNT => X_MSG_COUNT
812: ,X_MSG_DATA => X_MSG_DATA
813: ,X_RETURN_STATUS => X_RETURN_STATUS);
814:
812: ,X_MSG_DATA => X_MSG_DATA
813: ,X_RETURN_STATUS => X_RETURN_STATUS);
814:
815: WHEN OTHERS THEN
816: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
817: P_API_NAME => L_API_NAME
818: ,P_PKG_NAME => G_PKG_NAME
819: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
820: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
815: WHEN OTHERS THEN
816: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
817: P_API_NAME => L_API_NAME
818: ,P_PKG_NAME => G_PKG_NAME
819: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
820: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
821: ,X_MSG_COUNT => X_MSG_COUNT
822: ,X_MSG_DATA => X_MSG_DATA
823: ,X_RETURN_STATUS => X_RETURN_STATUS);
816: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
817: P_API_NAME => L_API_NAME
818: ,P_PKG_NAME => G_PKG_NAME
819: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
820: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
821: ,X_MSG_COUNT => X_MSG_COUNT
822: ,X_MSG_DATA => X_MSG_DATA
823: ,X_RETURN_STATUS => X_RETURN_STATUS);
824: End Get_quote;
895: );
896:
897: EXCEPTION
898: WHEN FND_API.G_EXC_ERROR THEN
899: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
900: P_API_NAME => L_API_NAME
901: ,P_PKG_NAME => G_PKG_NAME
902: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
903: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
899: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
900: P_API_NAME => L_API_NAME
901: ,P_PKG_NAME => G_PKG_NAME
902: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
903: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
904: ,X_MSG_COUNT => X_MSG_COUNT
905: ,X_MSG_DATA => X_MSG_DATA
906: ,X_RETURN_STATUS => X_RETURN_STATUS);
907:
905: ,X_MSG_DATA => X_MSG_DATA
906: ,X_RETURN_STATUS => X_RETURN_STATUS);
907:
908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
909: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
910: P_API_NAME => L_API_NAME
911: ,P_PKG_NAME => G_PKG_NAME
912: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
913: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
909: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
910: P_API_NAME => L_API_NAME
911: ,P_PKG_NAME => G_PKG_NAME
912: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
913: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
914: ,X_MSG_COUNT => X_MSG_COUNT
915: ,X_MSG_DATA => X_MSG_DATA
916: ,X_RETURN_STATUS => X_RETURN_STATUS);
917:
915: ,X_MSG_DATA => X_MSG_DATA
916: ,X_RETURN_STATUS => X_RETURN_STATUS);
917:
918: WHEN OTHERS THEN
919: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
920: P_API_NAME => L_API_NAME
921: ,P_PKG_NAME => G_PKG_NAME
922: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
923: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
918: WHEN OTHERS THEN
919: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
920: P_API_NAME => L_API_NAME
921: ,P_PKG_NAME => G_PKG_NAME
922: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
923: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
924: ,X_MSG_COUNT => X_MSG_COUNT
925: ,X_MSG_DATA => X_MSG_DATA
926: ,X_RETURN_STATUS => X_RETURN_STATUS);
919: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
920: P_API_NAME => L_API_NAME
921: ,P_PKG_NAME => G_PKG_NAME
922: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
923: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
924: ,X_MSG_COUNT => X_MSG_COUNT
925: ,X_MSG_DATA => X_MSG_DATA
926: ,X_RETURN_STATUS => X_RETURN_STATUS);
927: END Validate_Quote;
1099: );
1100:
1101: EXCEPTION
1102: WHEN FND_API.G_EXC_ERROR THEN
1103: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1104: P_API_NAME => L_API_NAME
1105: ,P_PKG_NAME => G_PKG_NAME
1106: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1107: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1103: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1104: P_API_NAME => L_API_NAME
1105: ,P_PKG_NAME => G_PKG_NAME
1106: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1107: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1108: ,X_MSG_COUNT => X_MSG_COUNT
1109: ,X_MSG_DATA => X_MSG_DATA
1110: ,X_RETURN_STATUS => X_RETURN_STATUS);
1111:
1109: ,X_MSG_DATA => X_MSG_DATA
1110: ,X_RETURN_STATUS => X_RETURN_STATUS);
1111:
1112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1113: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1114: P_API_NAME => L_API_NAME
1115: ,P_PKG_NAME => G_PKG_NAME
1116: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1117: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1113: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1114: P_API_NAME => L_API_NAME
1115: ,P_PKG_NAME => G_PKG_NAME
1116: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1117: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1118: ,X_MSG_COUNT => X_MSG_COUNT
1119: ,X_MSG_DATA => X_MSG_DATA
1120: ,X_RETURN_STATUS => X_RETURN_STATUS);
1121:
1119: ,X_MSG_DATA => X_MSG_DATA
1120: ,X_RETURN_STATUS => X_RETURN_STATUS);
1121:
1122: WHEN OTHERS THEN
1123: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1124: P_API_NAME => L_API_NAME
1125: ,P_PKG_NAME => G_PKG_NAME
1126: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1127: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1122: WHEN OTHERS THEN
1123: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1124: P_API_NAME => L_API_NAME
1125: ,P_PKG_NAME => G_PKG_NAME
1126: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1127: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1128: ,X_MSG_COUNT => X_MSG_COUNT
1129: ,X_MSG_DATA => X_MSG_DATA
1130: ,X_RETURN_STATUS => X_RETURN_STATUS);
1123: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1124: P_API_NAME => L_API_NAME
1125: ,P_PKG_NAME => G_PKG_NAME
1126: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1127: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1128: ,X_MSG_COUNT => X_MSG_COUNT
1129: ,X_MSG_DATA => X_MSG_DATA
1130: ,X_RETURN_STATUS => X_RETURN_STATUS);
1131: END Submit_Quote;
1349: );
1350:
1351: EXCEPTION
1352: WHEN FND_API.G_EXC_ERROR THEN
1353: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1354: P_API_NAME => L_API_NAME
1355: ,P_PKG_NAME => G_PKG_NAME
1356: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1357: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1353: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1354: P_API_NAME => L_API_NAME
1355: ,P_PKG_NAME => G_PKG_NAME
1356: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1357: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1358: ,X_MSG_COUNT => X_MSG_COUNT
1359: ,X_MSG_DATA => X_MSG_DATA
1360: ,X_RETURN_STATUS => X_RETURN_STATUS);
1361:
1359: ,X_MSG_DATA => X_MSG_DATA
1360: ,X_RETURN_STATUS => X_RETURN_STATUS);
1361:
1362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1363: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1364: P_API_NAME => L_API_NAME
1365: ,P_PKG_NAME => G_PKG_NAME
1366: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1367: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1363: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1364: P_API_NAME => L_API_NAME
1365: ,P_PKG_NAME => G_PKG_NAME
1366: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1367: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1368: ,X_MSG_COUNT => X_MSG_COUNT
1369: ,X_MSG_DATA => X_MSG_DATA
1370: ,X_RETURN_STATUS => X_RETURN_STATUS);
1371:
1369: ,X_MSG_DATA => X_MSG_DATA
1370: ,X_RETURN_STATUS => X_RETURN_STATUS);
1371:
1372: WHEN OTHERS THEN
1373: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1374: P_API_NAME => L_API_NAME
1375: ,P_PKG_NAME => G_PKG_NAME
1376: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1377: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1372: WHEN OTHERS THEN
1373: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1374: P_API_NAME => L_API_NAME
1375: ,P_PKG_NAME => G_PKG_NAME
1376: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1377: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1378: ,X_MSG_COUNT => X_MSG_COUNT
1379: ,X_MSG_DATA => X_MSG_DATA
1380: ,X_RETURN_STATUS => X_RETURN_STATUS);
1373: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1374: P_API_NAME => L_API_NAME
1375: ,P_PKG_NAME => G_PKG_NAME
1376: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1377: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1378: ,X_MSG_COUNT => X_MSG_COUNT
1379: ,X_MSG_DATA => X_MSG_DATA
1380: ,X_RETURN_STATUS => X_RETURN_STATUS);
1381: END Copy_Quote;
2280: ASO_QUOTE_LINES_PVT.Create_Quote_Lines(
2281: P_Api_Version_Number => 1.0,
2282: P_Init_Msg_List => p_init_msg_list,
2283: P_Commit => p_commit,
2284: -- P_Validation_Level => ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM,
2285: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
2286: p_qte_header_rec => p_qte_header_rec,
2287: P_Qte_Line_Rec => l_qte_line_rec,
2288: P_Control_REC => l_control_rec ,
2438: );
2439:
2440: EXCEPTION
2441: WHEN FND_API.G_EXC_ERROR THEN
2442: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2443: P_API_NAME => L_API_NAME
2444: ,P_PKG_NAME => G_PKG_NAME
2445: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2446: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2442: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2443: P_API_NAME => L_API_NAME
2444: ,P_PKG_NAME => G_PKG_NAME
2445: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2446: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2447: ,P_SQLCODE => SQLCODE
2448: ,P_SQLERRM => SQLERRM
2449: ,X_MSG_COUNT => X_MSG_COUNT
2450: ,X_MSG_DATA => X_MSG_DATA
2450: ,X_MSG_DATA => X_MSG_DATA
2451: ,X_RETURN_STATUS => X_RETURN_STATUS);
2452:
2453: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2454: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2455: P_API_NAME => L_API_NAME
2456: ,P_PKG_NAME => G_PKG_NAME
2457: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2458: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2454: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2455: P_API_NAME => L_API_NAME
2456: ,P_PKG_NAME => G_PKG_NAME
2457: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2458: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2459: ,P_SQLCODE => SQLCODE
2460: ,P_SQLERRM => SQLERRM
2461: ,X_MSG_COUNT => X_MSG_COUNT
2462: ,X_MSG_DATA => X_MSG_DATA
2462: ,X_MSG_DATA => X_MSG_DATA
2463: ,X_RETURN_STATUS => X_RETURN_STATUS);
2464:
2465: WHEN OTHERS THEN
2466: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2467: P_API_NAME => L_API_NAME
2468: ,P_PKG_NAME => G_PKG_NAME
2469: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2470: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2465: WHEN OTHERS THEN
2466: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2467: P_API_NAME => L_API_NAME
2468: ,P_PKG_NAME => G_PKG_NAME
2469: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2470: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2471: ,P_SQLCODE => SQLCODE
2472: ,P_SQLERRM => SQLERRM
2473: ,X_MSG_COUNT => X_MSG_COUNT
2466: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2467: P_API_NAME => L_API_NAME
2468: ,P_PKG_NAME => G_PKG_NAME
2469: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2470: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2471: ,P_SQLCODE => SQLCODE
2472: ,P_SQLERRM => SQLERRM
2473: ,X_MSG_COUNT => X_MSG_COUNT
2474: ,X_MSG_DATA => X_MSG_DATA
2860: );
2861:
2862: EXCEPTION
2863: WHEN FND_API.G_EXC_ERROR THEN
2864: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2865: P_API_NAME => L_API_NAME
2866: ,P_PKG_NAME => G_PKG_NAME
2867: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2868: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2864: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2865: P_API_NAME => L_API_NAME
2866: ,P_PKG_NAME => G_PKG_NAME
2867: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2868: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2869: ,P_SQLCODE => SQLCODE
2870: ,P_SQLERRM => SQLERRM
2871: ,X_MSG_COUNT => X_MSG_COUNT
2872: ,X_MSG_DATA => X_MSG_DATA
2872: ,X_MSG_DATA => X_MSG_DATA
2873: ,X_RETURN_STATUS => X_RETURN_STATUS);
2874:
2875: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2876: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2877: P_API_NAME => L_API_NAME
2878: ,P_PKG_NAME => G_PKG_NAME
2879: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2880: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2876: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2877: P_API_NAME => L_API_NAME
2878: ,P_PKG_NAME => G_PKG_NAME
2879: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
2880: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2881: ,P_SQLCODE => SQLCODE
2882: ,P_SQLERRM => SQLERRM
2883: ,X_MSG_COUNT => X_MSG_COUNT
2884: ,X_MSG_DATA => X_MSG_DATA
2884: ,X_MSG_DATA => X_MSG_DATA
2885: ,X_RETURN_STATUS => X_RETURN_STATUS);
2886:
2887: WHEN OTHERS THEN
2888: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2889: P_API_NAME => L_API_NAME
2890: ,P_PKG_NAME => G_PKG_NAME
2891: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2892: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2887: WHEN OTHERS THEN
2888: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2889: P_API_NAME => L_API_NAME
2890: ,P_PKG_NAME => G_PKG_NAME
2891: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2892: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2893: ,P_SQLCODE => SQLCODE
2894: ,P_SQLERRM => SQLERRM
2895: ,X_MSG_COUNT => X_MSG_COUNT
2888: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2889: P_API_NAME => L_API_NAME
2890: ,P_PKG_NAME => G_PKG_NAME
2891: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
2892: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
2893: ,P_SQLCODE => SQLCODE
2894: ,P_SQLERRM => SQLERRM
2895: ,X_MSG_COUNT => X_MSG_COUNT
2896: ,X_MSG_DATA => X_MSG_DATA
3113: );
3114:
3115: EXCEPTION
3116: WHEN FND_API.G_EXC_ERROR THEN
3117: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3118: P_API_NAME => L_API_NAME
3119: ,P_PKG_NAME => G_PKG_NAME
3120: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3121: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
3117: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3118: P_API_NAME => L_API_NAME
3119: ,P_PKG_NAME => G_PKG_NAME
3120: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3121: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
3122: ,P_SQLCODE => SQLCODE
3123: ,P_SQLERRM => SQLERRM
3124: ,X_MSG_COUNT => X_MSG_COUNT
3125: ,X_MSG_DATA => X_MSG_DATA
3125: ,X_MSG_DATA => X_MSG_DATA
3126: ,X_RETURN_STATUS => X_RETURN_STATUS);
3127:
3128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3129: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3130: P_API_NAME => L_API_NAME
3131: ,P_PKG_NAME => G_PKG_NAME
3132: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3133: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
3129: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3130: P_API_NAME => L_API_NAME
3131: ,P_PKG_NAME => G_PKG_NAME
3132: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3133: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
3134: ,P_SQLCODE => SQLCODE
3135: ,P_SQLERRM => SQLERRM
3136: ,X_MSG_COUNT => X_MSG_COUNT
3137: ,X_MSG_DATA => X_MSG_DATA
3137: ,X_MSG_DATA => X_MSG_DATA
3138: ,X_RETURN_STATUS => X_RETURN_STATUS);
3139:
3140: WHEN OTHERS THEN
3141: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3142: P_API_NAME => L_API_NAME
3143: ,P_PKG_NAME => G_PKG_NAME
3144: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3145: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
3140: WHEN OTHERS THEN
3141: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3142: P_API_NAME => L_API_NAME
3143: ,P_PKG_NAME => G_PKG_NAME
3144: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3145: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
3146: ,P_SQLCODE => SQLCODE
3147: ,P_SQLERRM => SQLERRM
3148: ,X_MSG_COUNT => X_MSG_COUNT
3141: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3142: P_API_NAME => L_API_NAME
3143: ,P_PKG_NAME => G_PKG_NAME
3144: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3145: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
3146: ,P_SQLCODE => SQLCODE
3147: ,P_SQLERRM => SQLERRM
3148: ,X_MSG_COUNT => X_MSG_COUNT
3149: ,X_MSG_DATA => X_MSG_DATA
3374: );
3375:
3376: EXCEPTION
3377: WHEN FND_API.G_EXC_ERROR THEN
3378: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3379: P_API_NAME => L_API_NAME
3380: ,P_PKG_NAME => G_PKG_NAME
3381: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3382: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
3378: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3379: P_API_NAME => L_API_NAME
3380: ,P_PKG_NAME => G_PKG_NAME
3381: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3382: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
3383: ,X_MSG_COUNT => X_MSG_COUNT
3384: ,X_MSG_DATA => X_MSG_DATA
3385: ,X_RETURN_STATUS => X_RETURN_STATUS);
3386:
3384: ,X_MSG_DATA => X_MSG_DATA
3385: ,X_RETURN_STATUS => X_RETURN_STATUS);
3386:
3387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3388: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3389: P_API_NAME => L_API_NAME
3390: ,P_PKG_NAME => G_PKG_NAME
3391: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3392: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
3388: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3389: P_API_NAME => L_API_NAME
3390: ,P_PKG_NAME => G_PKG_NAME
3391: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3392: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
3393: ,X_MSG_COUNT => X_MSG_COUNT
3394: ,X_MSG_DATA => X_MSG_DATA
3395: ,X_RETURN_STATUS => X_RETURN_STATUS);
3396:
3394: ,X_MSG_DATA => X_MSG_DATA
3395: ,X_RETURN_STATUS => X_RETURN_STATUS);
3396:
3397: WHEN OTHERS THEN
3398: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3399: P_API_NAME => L_API_NAME
3400: ,P_PKG_NAME => G_PKG_NAME
3401: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3402: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
3397: WHEN OTHERS THEN
3398: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3399: P_API_NAME => L_API_NAME
3400: ,P_PKG_NAME => G_PKG_NAME
3401: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3402: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
3403: ,X_MSG_COUNT => X_MSG_COUNT
3404: ,X_MSG_DATA => X_MSG_DATA
3405: ,X_RETURN_STATUS => X_RETURN_STATUS);
3398: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3399: P_API_NAME => L_API_NAME
3400: ,P_PKG_NAME => G_PKG_NAME
3401: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3402: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
3403: ,X_MSG_COUNT => X_MSG_COUNT
3404: ,X_MSG_DATA => X_MSG_DATA
3405: ,X_RETURN_STATUS => X_RETURN_STATUS);
3406:
3597:
3598: EXCEPTION
3599:
3600: WHEN FND_API.G_EXC_ERROR THEN
3601: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3602: P_API_NAME => L_API_NAME,
3603: P_PKG_NAME => G_PKG_NAME,
3604: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
3605: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB,
3601: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3602: P_API_NAME => L_API_NAME,
3603: P_PKG_NAME => G_PKG_NAME,
3604: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
3605: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB,
3606: P_SQLCODE => SQLCODE,
3607: P_SQLERRM => SQLERRM,
3608: X_MSG_COUNT => X_MSG_COUNT,
3609: X_MSG_DATA => X_MSG_DATA,
3610: X_RETURN_STATUS => X_RETURN_STATUS
3611: );
3612:
3613: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3614: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3615: P_API_NAME => L_API_NAME,
3616: P_PKG_NAME => G_PKG_NAME,
3617: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
3618: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB,
3614: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3615: P_API_NAME => L_API_NAME,
3616: P_PKG_NAME => G_PKG_NAME,
3617: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
3618: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB,
3619: P_SQLCODE => SQLCODE,
3620: P_SQLERRM => SQLERRM,
3621: X_MSG_COUNT => X_MSG_COUNT,
3622: X_MSG_DATA => X_MSG_DATA,
3623: X_RETURN_STATUS => X_RETURN_STATUS
3624: );
3625:
3626: WHEN OTHERS THEN
3627: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3628: P_API_NAME => L_API_NAME,
3629: P_PKG_NAME => G_PKG_NAME,
3630: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
3631: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB,
3626: WHEN OTHERS THEN
3627: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3628: P_API_NAME => L_API_NAME,
3629: P_PKG_NAME => G_PKG_NAME,
3630: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
3631: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB,
3632: P_SQLCODE => SQLCODE,
3633: P_SQLERRM => SQLERRM,
3634: X_MSG_COUNT => X_MSG_COUNT,
3627: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3628: P_API_NAME => L_API_NAME,
3629: P_PKG_NAME => G_PKG_NAME,
3630: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
3631: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB,
3632: P_SQLCODE => SQLCODE,
3633: P_SQLERRM => SQLERRM,
3634: X_MSG_COUNT => X_MSG_COUNT,
3635: X_MSG_DATA => X_MSG_DATA,
4288:
4289: EXCEPTION
4290:
4291: WHEN FND_API.G_EXC_ERROR THEN
4292: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4293: P_API_NAME => L_API_NAME
4294: ,P_PKG_NAME => G_PKG_NAME
4295: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4296: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
4292: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4293: P_API_NAME => L_API_NAME
4294: ,P_PKG_NAME => G_PKG_NAME
4295: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4296: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
4297: ,P_SQLCODE => SQLCODE
4298: ,P_SQLERRM => SQLERRM
4299: ,X_MSG_COUNT => X_MSG_COUNT
4300: ,X_MSG_DATA => X_MSG_DATA
4300: ,X_MSG_DATA => X_MSG_DATA
4301: ,X_RETURN_STATUS => X_RETURN_STATUS);
4302:
4303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4304: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4305: P_API_NAME => L_API_NAME
4306: ,P_PKG_NAME => G_PKG_NAME
4307: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4308: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
4304: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4305: P_API_NAME => L_API_NAME
4306: ,P_PKG_NAME => G_PKG_NAME
4307: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4308: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
4309: ,P_SQLCODE => SQLCODE
4310: ,P_SQLERRM => SQLERRM
4311: ,X_MSG_COUNT => X_MSG_COUNT
4312: ,X_MSG_DATA => X_MSG_DATA
4312: ,X_MSG_DATA => X_MSG_DATA
4313: ,X_RETURN_STATUS => X_RETURN_STATUS);
4314:
4315: WHEN OTHERS THEN
4316: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4317: P_API_NAME => L_API_NAME
4318: ,P_PKG_NAME => G_PKG_NAME
4319: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
4320: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
4315: WHEN OTHERS THEN
4316: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4317: P_API_NAME => L_API_NAME
4318: ,P_PKG_NAME => G_PKG_NAME
4319: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
4320: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
4321: ,P_SQLCODE => SQLCODE
4322: ,P_SQLERRM => SQLERRM
4323: ,X_MSG_COUNT => X_MSG_COUNT
4316: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4317: P_API_NAME => L_API_NAME
4318: ,P_PKG_NAME => G_PKG_NAME
4319: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
4320: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
4321: ,P_SQLCODE => SQLCODE
4322: ,P_SQLERRM => SQLERRM
4323: ,X_MSG_COUNT => X_MSG_COUNT
4324: ,X_MSG_DATA => X_MSG_DATA
4856:
4857: EXCEPTION
4858:
4859: WHEN FND_API.G_EXC_ERROR THEN
4860: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4861: P_API_NAME => L_API_NAME
4862: ,P_PKG_NAME => G_PKG_NAME
4863: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4864: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
4860: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4861: P_API_NAME => L_API_NAME
4862: ,P_PKG_NAME => G_PKG_NAME
4863: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4864: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
4865: ,P_SQLCODE => SQLCODE
4866: ,P_SQLERRM => SQLERRM
4867: ,X_MSG_COUNT => X_MSG_COUNT
4868: ,X_MSG_DATA => X_MSG_DATA
4868: ,X_MSG_DATA => X_MSG_DATA
4869: ,X_RETURN_STATUS => X_RETURN_STATUS);
4870:
4871: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4872: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4873: P_API_NAME => L_API_NAME
4874: ,P_PKG_NAME => G_PKG_NAME
4875: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4876: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
4872: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4873: P_API_NAME => L_API_NAME
4874: ,P_PKG_NAME => G_PKG_NAME
4875: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4876: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
4877: ,P_SQLCODE => SQLCODE
4878: ,P_SQLERRM => SQLERRM
4879: ,X_MSG_COUNT => X_MSG_COUNT
4880: ,X_MSG_DATA => X_MSG_DATA
4880: ,X_MSG_DATA => X_MSG_DATA
4881: ,X_RETURN_STATUS => X_RETURN_STATUS);
4882:
4883: WHEN OTHERS THEN
4884: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4885: P_API_NAME => L_API_NAME
4886: ,P_PKG_NAME => G_PKG_NAME
4887: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
4888: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
4883: WHEN OTHERS THEN
4884: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4885: P_API_NAME => L_API_NAME
4886: ,P_PKG_NAME => G_PKG_NAME
4887: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
4888: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
4889: ,P_SQLCODE => SQLCODE
4890: ,P_SQLERRM => SQLERRM
4891: ,X_MSG_COUNT => X_MSG_COUNT
4884: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4885: P_API_NAME => L_API_NAME
4886: ,P_PKG_NAME => G_PKG_NAME
4887: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
4888: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
4889: ,P_SQLCODE => SQLCODE
4890: ,P_SQLERRM => SQLERRM
4891: ,X_MSG_COUNT => X_MSG_COUNT
4892: ,X_MSG_DATA => X_MSG_DATA