APPS.ASO_QUOTE_PUB dependencies on ASO_UTILITY_PVT

Line 39: ASO_UTILITY_PVT.Set_Message(

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);

Line 93: ASO_UTILITY_PVT.Set_Message(

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);

Line 667: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 678: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 688: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 691: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

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);

Line 692: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

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:

Line 796: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 806: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 816: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 819: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

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);

Line 820: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

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;

Line 899: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 909: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 919: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 922: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

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);

Line 923: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

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;

Line 1103: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 1113: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 1123: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 1126: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

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);

Line 1127: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

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;

Line 1353: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 1363: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 1373: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 1376: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

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);

Line 1377: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

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;

Line 2284: -- P_Validation_Level => ASO_UTILITY_PVT.G_VALID_LEVEL_ITEM,

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 ,

Line 2442: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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

Line 2454: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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

Line 2466: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 2469: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

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

Line 2470: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

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

Line 2864: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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

Line 2876: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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

Line 2888: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 2891: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

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

Line 2892: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

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

Line 3117: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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

Line 3129: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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

Line 3141: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 3144: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

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

Line 3145: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

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

Line 3378: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 3388: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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:

Line 3398: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 3401: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

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);

Line 3402: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

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:

Line 3601: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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,

Line 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,

Line 3614: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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,

Line 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,

Line 3627: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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,

Line 3630: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

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,

Line 3631: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB,

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,

Line 4292: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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

Line 4304: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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

Line 4316: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 4319: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

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

Line 4320: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

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

Line 4860: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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

Line 4872: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 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

Line 4884: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

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

Line 4887: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

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

Line 4888: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

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