eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.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 4293: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

4289:
4290: EXCEPTION
4291:
4292: WHEN FND_API.G_EXC_ERROR THEN
4293: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4294: P_API_NAME => L_API_NAME
4295: ,P_PKG_NAME => G_PKG_NAME
4296: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4297: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 4297: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

4293: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4294: P_API_NAME => L_API_NAME
4295: ,P_PKG_NAME => G_PKG_NAME
4296: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
4297: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
4298: ,P_SQLCODE => SQLCODE
4299: ,P_SQLERRM => SQLERRM
4300: ,X_MSG_COUNT => X_MSG_COUNT
4301: ,X_MSG_DATA => X_MSG_DATA

Line 4305: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

4301: ,X_MSG_DATA => X_MSG_DATA
4302: ,X_RETURN_STATUS => X_RETURN_STATUS);
4303:
4304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4305: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4306: P_API_NAME => L_API_NAME
4307: ,P_PKG_NAME => G_PKG_NAME
4308: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4309: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 4309: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

4305: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4306: P_API_NAME => L_API_NAME
4307: ,P_PKG_NAME => G_PKG_NAME
4308: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
4309: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
4310: ,P_SQLCODE => SQLCODE
4311: ,P_SQLERRM => SQLERRM
4312: ,X_MSG_COUNT => X_MSG_COUNT
4313: ,X_MSG_DATA => X_MSG_DATA

Line 4317: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

4313: ,X_MSG_DATA => X_MSG_DATA
4314: ,X_RETURN_STATUS => X_RETURN_STATUS);
4315:
4316: WHEN OTHERS THEN
4317: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4318: P_API_NAME => L_API_NAME
4319: ,P_PKG_NAME => G_PKG_NAME
4320: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
4321: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 4320: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

4316: WHEN OTHERS THEN
4317: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4318: P_API_NAME => L_API_NAME
4319: ,P_PKG_NAME => G_PKG_NAME
4320: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
4321: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
4322: ,P_SQLCODE => SQLCODE
4323: ,P_SQLERRM => SQLERRM
4324: ,X_MSG_COUNT => X_MSG_COUNT

Line 4321: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

4317: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4318: P_API_NAME => L_API_NAME
4319: ,P_PKG_NAME => G_PKG_NAME
4320: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
4321: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
4322: ,P_SQLCODE => SQLCODE
4323: ,P_SQLERRM => SQLERRM
4324: ,X_MSG_COUNT => X_MSG_COUNT
4325: ,X_MSG_DATA => X_MSG_DATA

Line 4420: lx_qte_header_rec Qte_Header_Rec_Type := ASO_UTILITY_PVT.Get_Qte_Header_Rec;

4416: l_hd_Payment_Tbl Payment_Tbl_Type;
4417: l_hd_payment_rec Payment_Rec_Type :=G_MISS_PAYMENT_REC;
4418: l_hd_Tax_Detail_Tbl Tax_Detail_Tbl_Type;
4419: l_hd_tax_rec Tax_Detail_Rec_Type :=G_MiSS_TAX_DETAIL_REC;
4420: lx_qte_header_rec Qte_Header_Rec_Type := ASO_UTILITY_PVT.Get_Qte_Header_Rec;
4421: lx_hd_shipment_rec Shipment_Rec_Type := ASO_UTILITY_PVT.Get_Shipment_Rec;
4422: lx_hd_payment_rec Payment_Rec_Type := ASO_UTILITY_PVT.Get_Payment_Rec;
4423: lx_hd_tax_rec TAX_DETAIL_REC_TYPE:= aso_utility_pvt.get_Tax_detail_rec;
4424:

Line 4421: lx_hd_shipment_rec Shipment_Rec_Type := ASO_UTILITY_PVT.Get_Shipment_Rec;

4417: l_hd_payment_rec Payment_Rec_Type :=G_MISS_PAYMENT_REC;
4418: l_hd_Tax_Detail_Tbl Tax_Detail_Tbl_Type;
4419: l_hd_tax_rec Tax_Detail_Rec_Type :=G_MiSS_TAX_DETAIL_REC;
4420: lx_qte_header_rec Qte_Header_Rec_Type := ASO_UTILITY_PVT.Get_Qte_Header_Rec;
4421: lx_hd_shipment_rec Shipment_Rec_Type := ASO_UTILITY_PVT.Get_Shipment_Rec;
4422: lx_hd_payment_rec Payment_Rec_Type := ASO_UTILITY_PVT.Get_Payment_Rec;
4423: lx_hd_tax_rec TAX_DETAIL_REC_TYPE:= aso_utility_pvt.get_Tax_detail_rec;
4424:
4425: l_Qte_Line_Tbl Qte_Line_Tbl_Type;

Line 4422: lx_hd_payment_rec Payment_Rec_Type := ASO_UTILITY_PVT.Get_Payment_Rec;

4418: l_hd_Tax_Detail_Tbl Tax_Detail_Tbl_Type;
4419: l_hd_tax_rec Tax_Detail_Rec_Type :=G_MiSS_TAX_DETAIL_REC;
4420: lx_qte_header_rec Qte_Header_Rec_Type := ASO_UTILITY_PVT.Get_Qte_Header_Rec;
4421: lx_hd_shipment_rec Shipment_Rec_Type := ASO_UTILITY_PVT.Get_Shipment_Rec;
4422: lx_hd_payment_rec Payment_Rec_Type := ASO_UTILITY_PVT.Get_Payment_Rec;
4423: lx_hd_tax_rec TAX_DETAIL_REC_TYPE:= aso_utility_pvt.get_Tax_detail_rec;
4424:
4425: l_Qte_Line_Tbl Qte_Line_Tbl_Type;
4426: l_Qte_Line_rec Qte_Line_Rec_Type := G_MISS_QTE_LINE_REC;

Line 4423: lx_hd_tax_rec TAX_DETAIL_REC_TYPE:= aso_utility_pvt.get_Tax_detail_rec;

4419: l_hd_tax_rec Tax_Detail_Rec_Type :=G_MiSS_TAX_DETAIL_REC;
4420: lx_qte_header_rec Qte_Header_Rec_Type := ASO_UTILITY_PVT.Get_Qte_Header_Rec;
4421: lx_hd_shipment_rec Shipment_Rec_Type := ASO_UTILITY_PVT.Get_Shipment_Rec;
4422: lx_hd_payment_rec Payment_Rec_Type := ASO_UTILITY_PVT.Get_Payment_Rec;
4423: lx_hd_tax_rec TAX_DETAIL_REC_TYPE:= aso_utility_pvt.get_Tax_detail_rec;
4424:
4425: l_Qte_Line_Tbl Qte_Line_Tbl_Type;
4426: l_Qte_Line_rec Qte_Line_Rec_Type := G_MISS_QTE_LINE_REC;
4427: l_ln_shipment_rec Shipment_Rec_Type := G_MISS_SHIPMENT_REC;

Line 4434: lx_qte_line_rec QTE_LINE_REC_TYPE :=ASO_UTILITY_PVT.Get_Qte_Line_Rec;

4430: l_ln_Payment_Tbl Payment_Tbl_Type;
4431: l_ln_tax_rec Tax_Detail_Rec_Type :=G_MISS_TAX_DETAIL_REC;
4432: l_ln_Tax_Detail_Tbl Tax_Detail_Tbl_Type;
4433:
4434: lx_qte_line_rec QTE_LINE_REC_TYPE :=ASO_UTILITY_PVT.Get_Qte_Line_Rec;
4435: lx_ln_shipment_rec Shipment_rec_type := ASO_UTILITY_PVT.Get_Shipment_Rec;
4436: lx_ln_payment_rec Payment_Rec_Type := ASO_UTILITY_PVT.Get_Payment_Rec;
4437: lx_ln_tax_rec TAX_DETAIL_REC_TYPE :=aso_utility_pvt.get_tax_detail_rec;
4438:

Line 4435: lx_ln_shipment_rec Shipment_rec_type := ASO_UTILITY_PVT.Get_Shipment_Rec;

4431: l_ln_tax_rec Tax_Detail_Rec_Type :=G_MISS_TAX_DETAIL_REC;
4432: l_ln_Tax_Detail_Tbl Tax_Detail_Tbl_Type;
4433:
4434: lx_qte_line_rec QTE_LINE_REC_TYPE :=ASO_UTILITY_PVT.Get_Qte_Line_Rec;
4435: lx_ln_shipment_rec Shipment_rec_type := ASO_UTILITY_PVT.Get_Shipment_Rec;
4436: lx_ln_payment_rec Payment_Rec_Type := ASO_UTILITY_PVT.Get_Payment_Rec;
4437: lx_ln_tax_rec TAX_DETAIL_REC_TYPE :=aso_utility_pvt.get_tax_detail_rec;
4438:
4439: l_ln_misc_rec ASO_DEFAULTING_INT.LINE_MISC_REC_TYPE :=ASO_utility_pvt.get_line_misc_rec;

Line 4436: lx_ln_payment_rec Payment_Rec_Type := ASO_UTILITY_PVT.Get_Payment_Rec;

4432: l_ln_Tax_Detail_Tbl Tax_Detail_Tbl_Type;
4433:
4434: lx_qte_line_rec QTE_LINE_REC_TYPE :=ASO_UTILITY_PVT.Get_Qte_Line_Rec;
4435: lx_ln_shipment_rec Shipment_rec_type := ASO_UTILITY_PVT.Get_Shipment_Rec;
4436: lx_ln_payment_rec Payment_Rec_Type := ASO_UTILITY_PVT.Get_Payment_Rec;
4437: lx_ln_tax_rec TAX_DETAIL_REC_TYPE :=aso_utility_pvt.get_tax_detail_rec;
4438:
4439: l_ln_misc_rec ASO_DEFAULTING_INT.LINE_MISC_REC_TYPE :=ASO_utility_pvt.get_line_misc_rec;
4440: l_hd_misc_rec ASO_DEFAULTING_INT.HEADER_MISC_REC_TYPE:=ASO_utility_pvt.get_header_misc_rec;

Line 4437: lx_ln_tax_rec TAX_DETAIL_REC_TYPE :=aso_utility_pvt.get_tax_detail_rec;

4433:
4434: lx_qte_line_rec QTE_LINE_REC_TYPE :=ASO_UTILITY_PVT.Get_Qte_Line_Rec;
4435: lx_ln_shipment_rec Shipment_rec_type := ASO_UTILITY_PVT.Get_Shipment_Rec;
4436: lx_ln_payment_rec Payment_Rec_Type := ASO_UTILITY_PVT.Get_Payment_Rec;
4437: lx_ln_tax_rec TAX_DETAIL_REC_TYPE :=aso_utility_pvt.get_tax_detail_rec;
4438:
4439: l_ln_misc_rec ASO_DEFAULTING_INT.LINE_MISC_REC_TYPE :=ASO_utility_pvt.get_line_misc_rec;
4440: l_hd_misc_rec ASO_DEFAULTING_INT.HEADER_MISC_REC_TYPE:=ASO_utility_pvt.get_header_misc_rec;
4441: lx_ln_misc_rec ASO_DEFAULTING_INT.LINE_MISC_REC_TYPE :=ASO_utility_pvt.get_line_misc_rec;

Line 4439: l_ln_misc_rec ASO_DEFAULTING_INT.LINE_MISC_REC_TYPE :=ASO_utility_pvt.get_line_misc_rec;

4435: lx_ln_shipment_rec Shipment_rec_type := ASO_UTILITY_PVT.Get_Shipment_Rec;
4436: lx_ln_payment_rec Payment_Rec_Type := ASO_UTILITY_PVT.Get_Payment_Rec;
4437: lx_ln_tax_rec TAX_DETAIL_REC_TYPE :=aso_utility_pvt.get_tax_detail_rec;
4438:
4439: l_ln_misc_rec ASO_DEFAULTING_INT.LINE_MISC_REC_TYPE :=ASO_utility_pvt.get_line_misc_rec;
4440: l_hd_misc_rec ASO_DEFAULTING_INT.HEADER_MISC_REC_TYPE:=ASO_utility_pvt.get_header_misc_rec;
4441: lx_ln_misc_rec ASO_DEFAULTING_INT.LINE_MISC_REC_TYPE :=ASO_utility_pvt.get_line_misc_rec;
4442: lx_hd_misc_rec ASO_DEFAULTING_INT.HEADER_MISC_REC_TYPE:=ASO_utility_pvt.get_header_misc_rec;
4443:

Line 4440: l_hd_misc_rec ASO_DEFAULTING_INT.HEADER_MISC_REC_TYPE:=ASO_utility_pvt.get_header_misc_rec;

4436: lx_ln_payment_rec Payment_Rec_Type := ASO_UTILITY_PVT.Get_Payment_Rec;
4437: lx_ln_tax_rec TAX_DETAIL_REC_TYPE :=aso_utility_pvt.get_tax_detail_rec;
4438:
4439: l_ln_misc_rec ASO_DEFAULTING_INT.LINE_MISC_REC_TYPE :=ASO_utility_pvt.get_line_misc_rec;
4440: l_hd_misc_rec ASO_DEFAULTING_INT.HEADER_MISC_REC_TYPE:=ASO_utility_pvt.get_header_misc_rec;
4441: lx_ln_misc_rec ASO_DEFAULTING_INT.LINE_MISC_REC_TYPE :=ASO_utility_pvt.get_line_misc_rec;
4442: lx_hd_misc_rec ASO_DEFAULTING_INT.HEADER_MISC_REC_TYPE:=ASO_utility_pvt.get_header_misc_rec;
4443:
4444: l_opp_qte_in_rec ASO_OPP_QTE_PUB.OPP_QTE_IN_REC_TYPE := ASO_OPP_QTE_PUB.G_MISS_OPP_QTE_IN_REC;

Line 4441: lx_ln_misc_rec ASO_DEFAULTING_INT.LINE_MISC_REC_TYPE :=ASO_utility_pvt.get_line_misc_rec;

4437: lx_ln_tax_rec TAX_DETAIL_REC_TYPE :=aso_utility_pvt.get_tax_detail_rec;
4438:
4439: l_ln_misc_rec ASO_DEFAULTING_INT.LINE_MISC_REC_TYPE :=ASO_utility_pvt.get_line_misc_rec;
4440: l_hd_misc_rec ASO_DEFAULTING_INT.HEADER_MISC_REC_TYPE:=ASO_utility_pvt.get_header_misc_rec;
4441: lx_ln_misc_rec ASO_DEFAULTING_INT.LINE_MISC_REC_TYPE :=ASO_utility_pvt.get_line_misc_rec;
4442: lx_hd_misc_rec ASO_DEFAULTING_INT.HEADER_MISC_REC_TYPE:=ASO_utility_pvt.get_header_misc_rec;
4443:
4444: l_opp_qte_in_rec ASO_OPP_QTE_PUB.OPP_QTE_IN_REC_TYPE := ASO_OPP_QTE_PUB.G_MISS_OPP_QTE_IN_REC;
4445: -- defaulting related parameters

Line 4442: lx_hd_misc_rec ASO_DEFAULTING_INT.HEADER_MISC_REC_TYPE:=ASO_utility_pvt.get_header_misc_rec;

4438:
4439: l_ln_misc_rec ASO_DEFAULTING_INT.LINE_MISC_REC_TYPE :=ASO_utility_pvt.get_line_misc_rec;
4440: l_hd_misc_rec ASO_DEFAULTING_INT.HEADER_MISC_REC_TYPE:=ASO_utility_pvt.get_header_misc_rec;
4441: lx_ln_misc_rec ASO_DEFAULTING_INT.LINE_MISC_REC_TYPE :=ASO_utility_pvt.get_line_misc_rec;
4442: lx_hd_misc_rec ASO_DEFAULTING_INT.HEADER_MISC_REC_TYPE:=ASO_utility_pvt.get_header_misc_rec;
4443:
4444: l_opp_qte_in_rec ASO_OPP_QTE_PUB.OPP_QTE_IN_REC_TYPE := ASO_OPP_QTE_PUB.G_MISS_OPP_QTE_IN_REC;
4445: -- defaulting related parameters
4446: l_trigger_attribute_tbl ASO_Defaulting_Int.Attribute_codes_tbl_type := ASO_Defaulting_Int.G_MISS_ATTRIBUTE_CODES_TBL;

Line 4997: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

4993:
4994: EXCEPTION
4995:
4996: WHEN FND_API.G_EXC_ERROR THEN
4997: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4998: P_API_NAME => L_API_NAME
4999: ,P_PKG_NAME => G_PKG_NAME
5000: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5001: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 5001: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

4997: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
4998: P_API_NAME => L_API_NAME
4999: ,P_PKG_NAME => G_PKG_NAME
5000: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5001: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
5002: ,P_SQLCODE => SQLCODE
5003: ,P_SQLERRM => SQLERRM
5004: ,X_MSG_COUNT => X_MSG_COUNT
5005: ,X_MSG_DATA => X_MSG_DATA

Line 5009: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

5005: ,X_MSG_DATA => X_MSG_DATA
5006: ,X_RETURN_STATUS => X_RETURN_STATUS);
5007:
5008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5009: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
5010: P_API_NAME => L_API_NAME
5011: ,P_PKG_NAME => G_PKG_NAME
5012: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5013: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 5013: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

5009: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
5010: P_API_NAME => L_API_NAME
5011: ,P_PKG_NAME => G_PKG_NAME
5012: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5013: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
5014: ,P_SQLCODE => SQLCODE
5015: ,P_SQLERRM => SQLERRM
5016: ,X_MSG_COUNT => X_MSG_COUNT
5017: ,X_MSG_DATA => X_MSG_DATA

Line 5021: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

5017: ,X_MSG_DATA => X_MSG_DATA
5018: ,X_RETURN_STATUS => X_RETURN_STATUS);
5019:
5020: WHEN OTHERS THEN
5021: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
5022: P_API_NAME => L_API_NAME
5023: ,P_PKG_NAME => G_PKG_NAME
5024: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
5025: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 5024: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

5020: WHEN OTHERS THEN
5021: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
5022: P_API_NAME => L_API_NAME
5023: ,P_PKG_NAME => G_PKG_NAME
5024: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
5025: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
5026: ,P_SQLCODE => SQLCODE
5027: ,P_SQLERRM => SQLERRM
5028: ,X_MSG_COUNT => X_MSG_COUNT

Line 5025: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

5021: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
5022: P_API_NAME => L_API_NAME
5023: ,P_PKG_NAME => G_PKG_NAME
5024: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
5025: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
5026: ,P_SQLCODE => SQLCODE
5027: ,P_SQLERRM => SQLERRM
5028: ,X_MSG_COUNT => X_MSG_COUNT
5029: ,X_MSG_DATA => X_MSG_DATA

Line 5579: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

5575:
5576: EXCEPTION
5577:
5578: WHEN FND_API.G_EXC_ERROR THEN
5579: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
5580: P_API_NAME => L_API_NAME
5581: ,P_PKG_NAME => G_PKG_NAME
5582: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5583: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 5583: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

5579: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
5580: P_API_NAME => L_API_NAME
5581: ,P_PKG_NAME => G_PKG_NAME
5582: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
5583: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
5584: ,P_SQLCODE => SQLCODE
5585: ,P_SQLERRM => SQLERRM
5586: ,X_MSG_COUNT => X_MSG_COUNT
5587: ,X_MSG_DATA => X_MSG_DATA

Line 5591: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

5587: ,X_MSG_DATA => X_MSG_DATA
5588: ,X_RETURN_STATUS => X_RETURN_STATUS);
5589:
5590: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5591: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
5592: P_API_NAME => L_API_NAME
5593: ,P_PKG_NAME => G_PKG_NAME
5594: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5595: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 5595: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

5591: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
5592: P_API_NAME => L_API_NAME
5593: ,P_PKG_NAME => G_PKG_NAME
5594: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
5595: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
5596: ,P_SQLCODE => SQLCODE
5597: ,P_SQLERRM => SQLERRM
5598: ,X_MSG_COUNT => X_MSG_COUNT
5599: ,X_MSG_DATA => X_MSG_DATA

Line 5603: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

5599: ,X_MSG_DATA => X_MSG_DATA
5600: ,X_RETURN_STATUS => X_RETURN_STATUS);
5601:
5602: WHEN OTHERS THEN
5603: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
5604: P_API_NAME => L_API_NAME
5605: ,P_PKG_NAME => G_PKG_NAME
5606: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
5607: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 5606: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

5602: WHEN OTHERS THEN
5603: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
5604: P_API_NAME => L_API_NAME
5605: ,P_PKG_NAME => G_PKG_NAME
5606: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
5607: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
5608: ,P_SQLCODE => SQLCODE
5609: ,P_SQLERRM => SQLERRM
5610: ,X_MSG_COUNT => X_MSG_COUNT

Line 5607: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

5603: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
5604: P_API_NAME => L_API_NAME
5605: ,P_PKG_NAME => G_PKG_NAME
5606: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
5607: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
5608: ,P_SQLCODE => SQLCODE
5609: ,P_SQLERRM => SQLERRM
5610: ,X_MSG_COUNT => X_MSG_COUNT
5611: ,X_MSG_DATA => X_MSG_DATA

Line 5714: l_qte_line_rec:=ASO_UTILITY_PVT.Query_Qte_Line_Row(p_Quote_line_id);

5710: -- dbms_output.put_line('Entered quote line id in Progress'||p_Quote_line_id);
5711:
5712: if (p_Quote_line_id <> FND_API.G_MISS_NUM) then -- Model line id is being sent
5713: -- dbms_output.put_line('Entered quote line id in Progress');
5714: l_qte_line_rec:=ASO_UTILITY_PVT.Query_Qte_Line_Row(p_Quote_line_id);
5715: l_model_qte_line_tbl(1) :=l_qte_line_rec;
5716: l_qte_line_dtl_tbl:= ASO_UTILITY_PVT.Query_Line_Dtl_Rows(p_Quote_line_id);
5717: l_model_qte_line_dtl_tbl(1).config_header_id:= l_qte_line_dtl_tbl(1).config_header_id;
5718: l_model_qte_line_dtl_tbl(1).config_revision_num:= l_qte_line_dtl_tbl(1).config_revision_num;

Line 5716: l_qte_line_dtl_tbl:= ASO_UTILITY_PVT.Query_Line_Dtl_Rows(p_Quote_line_id);

5712: if (p_Quote_line_id <> FND_API.G_MISS_NUM) then -- Model line id is being sent
5713: -- dbms_output.put_line('Entered quote line id in Progress');
5714: l_qte_line_rec:=ASO_UTILITY_PVT.Query_Qte_Line_Row(p_Quote_line_id);
5715: l_model_qte_line_tbl(1) :=l_qte_line_rec;
5716: l_qte_line_dtl_tbl:= ASO_UTILITY_PVT.Query_Line_Dtl_Rows(p_Quote_line_id);
5717: l_model_qte_line_dtl_tbl(1).config_header_id:= l_qte_line_dtl_tbl(1).config_header_id;
5718: l_model_qte_line_dtl_tbl(1).config_revision_num:= l_qte_line_dtl_tbl(1).config_revision_num;
5719: else
5720: -- dbms_output.put_line('Entered else in Progress');

Line 5721: l_qte_line_tbl:=ASO_UTILITY_PVT.Query_Qte_Line_Rows(P_Quote_header_id);

5717: l_model_qte_line_dtl_tbl(1).config_header_id:= l_qte_line_dtl_tbl(1).config_header_id;
5718: l_model_qte_line_dtl_tbl(1).config_revision_num:= l_qte_line_dtl_tbl(1).config_revision_num;
5719: else
5720: -- dbms_output.put_line('Entered else in Progress');
5721: l_qte_line_tbl:=ASO_UTILITY_PVT.Query_Qte_Line_Rows(P_Quote_header_id);
5722: for i in 1..l_qte_line_tbl.count loop
5723: -- query the quote for all the models and populate the model line id and details table
5724: if l_qte_line_tbl(i).item_type_code='MDL' then
5725: l_qte_line_dtl_tbl:= ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_tbl(i).quote_line_id);

Line 5725: l_qte_line_dtl_tbl:= ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_tbl(i).quote_line_id);

5721: l_qte_line_tbl:=ASO_UTILITY_PVT.Query_Qte_Line_Rows(P_Quote_header_id);
5722: for i in 1..l_qte_line_tbl.count loop
5723: -- query the quote for all the models and populate the model line id and details table
5724: if l_qte_line_tbl(i).item_type_code='MDL' then
5725: l_qte_line_dtl_tbl:= ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_qte_line_tbl(i).quote_line_id);
5726: IF aso_debug_pub.g_debug_flag = 'Y' THEN
5727: aso_debug_pub.add('Validate_model_configuration detail table count l_qte_line_dtl_tbl'||l_qte_line_dtl_tbl.count, 1, 'Y');
5728: End if;
5729:

Line 5775: l_send_qte_line_tbl(1):=ASO_UTILITY_PVT.Query_Qte_Line_Row(l_model_qte_line_tbl(i).quote_line_id);

5771: -- Discussed with CZ we need not send the line and details tables
5772:
5773: l_send_qte_line_tbl := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
5774: l_send_qte_line_dtl_tbl := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
5775: l_send_qte_line_tbl(1):=ASO_UTILITY_PVT.Query_Qte_Line_Row(l_model_qte_line_tbl(i).quote_line_id);
5776: l_send_qte_line_tbl(1).operation_code:='UPDATE';
5777: l_send_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_model_qte_line_tbl(i).quote_line_id);
5778: */
5779: l_control_rec_bv.header_pricing_event := null;

Line 5777: l_send_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_model_qte_line_tbl(i).quote_line_id);

5773: l_send_qte_line_tbl := ASO_QUOTE_PUB.G_MISS_QTE_LINE_TBL;
5774: l_send_qte_line_dtl_tbl := ASO_QUOTE_PUB.G_MISS_QTE_LINE_DTL_TBL;
5775: l_send_qte_line_tbl(1):=ASO_UTILITY_PVT.Query_Qte_Line_Row(l_model_qte_line_tbl(i).quote_line_id);
5776: l_send_qte_line_tbl(1).operation_code:='UPDATE';
5777: l_send_qte_line_dtl_tbl := ASO_UTILITY_PVT.Query_Line_Dtl_Rows(l_model_qte_line_tbl(i).quote_line_id);
5778: */
5779: l_control_rec_bv.header_pricing_event := null;
5780: l_control_rec_bv.calculate_tax_flag := 'N';
5781: l_control_rec_bv.defaulting_fwk_flag := 'N';

Line 6071: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

6067: ( p_count => x_msg_count
6068: , p_data => x_msg_data);
6069:
6070: WHEN FND_API.G_EXC_ERROR THEN
6071: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6072: P_API_NAME => L_API_NAME
6073: ,P_PKG_NAME => G_PKG_NAME
6074: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
6075: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 6075: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

6071: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6072: P_API_NAME => L_API_NAME
6073: ,P_PKG_NAME => G_PKG_NAME
6074: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
6075: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
6076: ,X_MSG_COUNT => X_MSG_COUNT
6077: ,X_MSG_DATA => X_MSG_DATA
6078: ,X_RETURN_STATUS => X_RETURN_STATUS);
6079:

Line 6081: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

6077: ,X_MSG_DATA => X_MSG_DATA
6078: ,X_RETURN_STATUS => X_RETURN_STATUS);
6079:
6080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6081: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6082: P_API_NAME => L_API_NAME
6083: ,P_PKG_NAME => G_PKG_NAME
6084: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6085: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 6085: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

6081: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6082: P_API_NAME => L_API_NAME
6083: ,P_PKG_NAME => G_PKG_NAME
6084: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
6085: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
6086: ,X_MSG_COUNT => X_MSG_COUNT
6087: ,X_MSG_DATA => X_MSG_DATA
6088: ,X_RETURN_STATUS => X_RETURN_STATUS);
6089:

Line 6091: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

6087: ,X_MSG_DATA => X_MSG_DATA
6088: ,X_RETURN_STATUS => X_RETURN_STATUS);
6089:
6090: WHEN OTHERS THEN
6091: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6092: P_API_NAME => L_API_NAME
6093: ,P_PKG_NAME => G_PKG_NAME
6094: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
6095: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 6094: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

6090: WHEN OTHERS THEN
6091: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6092: P_API_NAME => L_API_NAME
6093: ,P_PKG_NAME => G_PKG_NAME
6094: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
6095: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
6096: ,X_MSG_COUNT => X_MSG_COUNT
6097: ,X_MSG_DATA => X_MSG_DATA
6098: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 6095: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

6091: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
6092: P_API_NAME => L_API_NAME
6093: ,P_PKG_NAME => G_PKG_NAME
6094: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
6095: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
6096: ,X_MSG_COUNT => X_MSG_COUNT
6097: ,X_MSG_DATA => X_MSG_DATA
6098: ,X_RETURN_STATUS => X_RETURN_STATUS);
6099: