635: FND_MSG_PUB.initialize;
636: END IF;
637:
638: -- Debug Message
639: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
640:
641: -- Initialize API return status to SUCCESS
642: x_return_status := FND_API.G_RET_STS_SUCCESS;
643:
723:
724: EXCEPTION
725: WHEN FND_API.G_EXC_ERROR THEN
726: null;
727: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
728: P_API_NAME => L_API_NAME
729: ,P_PKG_NAME => G_PKG_NAME
730: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
731: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
727: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
728: P_API_NAME => L_API_NAME
729: ,P_PKG_NAME => G_PKG_NAME
730: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
731: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
732: ,X_MSG_COUNT => X_MSG_COUNT
733: ,X_MSG_DATA => X_MSG_DATA
734: ,X_RETURN_STATUS => X_RETURN_STATUS);
735:
734: ,X_RETURN_STATUS => X_RETURN_STATUS);
735:
736: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
737: null;
738: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
739: P_API_NAME => L_API_NAME
740: ,P_PKG_NAME => G_PKG_NAME
741: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
742: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
738: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
739: P_API_NAME => L_API_NAME
740: ,P_PKG_NAME => G_PKG_NAME
741: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
742: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
743: ,X_MSG_COUNT => X_MSG_COUNT
744: ,X_MSG_DATA => X_MSG_DATA
745: ,X_RETURN_STATUS => X_RETURN_STATUS);
746: WHEN OTHERS THEN
744: ,X_MSG_DATA => X_MSG_DATA
745: ,X_RETURN_STATUS => X_RETURN_STATUS);
746: WHEN OTHERS THEN
747: null;
748: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
749: P_API_NAME => L_API_NAME
750: ,P_PKG_NAME => G_PKG_NAME
751: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
752: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
748: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
749: P_API_NAME => L_API_NAME
750: ,P_PKG_NAME => G_PKG_NAME
751: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
752: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
753: ,X_MSG_COUNT => X_MSG_COUNT
754: ,X_MSG_DATA => X_MSG_DATA
755: ,X_RETURN_STATUS => X_RETURN_STATUS);
756:
844: FND_MSG_PUB.initialize;
845: END IF;
846:
847: -- Debug Message
848: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
849:
850: -- Initialize API return status to SUCCESS
851: x_return_status := FND_API.G_RET_STS_SUCCESS;
852:
935:
936: EXCEPTION
937: WHEN FND_API.G_EXC_ERROR THEN
938: null;
939: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
940: P_API_NAME => L_API_NAME
941: ,P_PKG_NAME => G_PKG_NAME
942: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
943: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
939: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
940: P_API_NAME => L_API_NAME
941: ,P_PKG_NAME => G_PKG_NAME
942: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
943: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
944: ,X_MSG_COUNT => X_MSG_COUNT
945: ,X_MSG_DATA => X_MSG_DATA
946: ,X_RETURN_STATUS => X_RETURN_STATUS);
947:
946: ,X_RETURN_STATUS => X_RETURN_STATUS);
947:
948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
949: null;
950: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
951: P_API_NAME => L_API_NAME
952: ,P_PKG_NAME => G_PKG_NAME
953: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
954: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
950: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
951: P_API_NAME => L_API_NAME
952: ,P_PKG_NAME => G_PKG_NAME
953: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
954: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
955: ,X_MSG_COUNT => X_MSG_COUNT
956: ,X_MSG_DATA => X_MSG_DATA
957: ,X_RETURN_STATUS => X_RETURN_STATUS);
958: WHEN OTHERS THEN
956: ,X_MSG_DATA => X_MSG_DATA
957: ,X_RETURN_STATUS => X_RETURN_STATUS);
958: WHEN OTHERS THEN
959: null;
960: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
961: P_API_NAME => L_API_NAME
962: ,P_PKG_NAME => G_PKG_NAME
963: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
964: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
960: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
961: P_API_NAME => L_API_NAME
962: ,P_PKG_NAME => G_PKG_NAME
963: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
964: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
965: ,X_MSG_COUNT => X_MSG_COUNT
966: ,X_MSG_DATA => X_MSG_DATA
967: ,X_RETURN_STATUS => X_RETURN_STATUS);
968:
1004: FND_MSG_PUB.initialize;
1005: END IF;
1006:
1007: -- Debug Message
1008: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
1009:
1010: -- Initialize API return status to SUCCESS
1011: x_return_status := FND_API.G_RET_STS_SUCCESS;
1012:
1064:
1065: EXCEPTION
1066: WHEN FND_API.G_EXC_ERROR THEN
1067: null;
1068: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1069: P_API_NAME => L_API_NAME
1070: ,P_PKG_NAME => G_PKG_NAME
1071: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1072: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1068: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1069: P_API_NAME => L_API_NAME
1070: ,P_PKG_NAME => G_PKG_NAME
1071: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1072: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1073: ,X_MSG_COUNT => X_MSG_COUNT
1074: ,X_MSG_DATA => X_MSG_DATA
1075: ,X_RETURN_STATUS => X_RETURN_STATUS);
1076:
1075: ,X_RETURN_STATUS => X_RETURN_STATUS);
1076:
1077: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1078: null;
1079: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1080: P_API_NAME => L_API_NAME
1081: ,P_PKG_NAME => G_PKG_NAME
1082: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1083: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1079: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1080: P_API_NAME => L_API_NAME
1081: ,P_PKG_NAME => G_PKG_NAME
1082: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1083: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1084: ,X_MSG_COUNT => X_MSG_COUNT
1085: ,X_MSG_DATA => X_MSG_DATA
1086: ,X_RETURN_STATUS => X_RETURN_STATUS);
1087: WHEN OTHERS THEN
1085: ,X_MSG_DATA => X_MSG_DATA
1086: ,X_RETURN_STATUS => X_RETURN_STATUS);
1087: WHEN OTHERS THEN
1088: null;
1089: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1090: P_API_NAME => L_API_NAME
1091: ,P_PKG_NAME => G_PKG_NAME
1092: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1093: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1089: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1090: P_API_NAME => L_API_NAME
1091: ,P_PKG_NAME => G_PKG_NAME
1092: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1093: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1094: ,X_MSG_COUNT => X_MSG_COUNT
1095: ,X_MSG_DATA => X_MSG_DATA
1096: ,X_RETURN_STATUS => X_RETURN_STATUS);
1097: END Delete_order;
1190: FND_MSG_PUB.initialize;
1191: END IF;
1192:
1193: -- Debug Message
1194: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
1195:
1196: -- Initialize API return status to SUCCESS
1197: x_return_status := FND_API.G_RET_STS_SUCCESS;
1198:
1299: END IF;
1300:
1301:
1302: -- Debug Message
1303: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
1304:
1305:
1306: -- Standard call to get message count and if count is 1, get message info.
1307: FND_MSG_PUB.Count_And_Get
1310: );
1311:
1312: EXCEPTION
1313: WHEN FND_API.G_EXC_ERROR THEN
1314: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1315: P_API_NAME => L_API_NAME
1316: ,P_PKG_NAME => G_PKG_NAME
1317: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1318: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1314: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1315: P_API_NAME => L_API_NAME
1316: ,P_PKG_NAME => G_PKG_NAME
1317: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1318: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1319: ,X_MSG_COUNT => X_MSG_COUNT
1320: ,X_MSG_DATA => X_MSG_DATA
1321: ,X_RETURN_STATUS => X_RETURN_STATUS);
1322:
1320: ,X_MSG_DATA => X_MSG_DATA
1321: ,X_RETURN_STATUS => X_RETURN_STATUS);
1322:
1323: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1324: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1325: P_API_NAME => L_API_NAME
1326: ,P_PKG_NAME => G_PKG_NAME
1327: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1328: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1324: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1325: P_API_NAME => L_API_NAME
1326: ,P_PKG_NAME => G_PKG_NAME
1327: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1328: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1329: ,X_MSG_COUNT => X_MSG_COUNT
1330: ,X_MSG_DATA => X_MSG_DATA
1331: ,X_RETURN_STATUS => X_RETURN_STATUS);
1332:
1330: ,X_MSG_DATA => X_MSG_DATA
1331: ,X_RETURN_STATUS => X_RETURN_STATUS);
1332:
1333: WHEN OTHERS THEN
1334: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1335: P_API_NAME => L_API_NAME
1336: ,P_PKG_NAME => G_PKG_NAME
1337: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1338: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1333: WHEN OTHERS THEN
1334: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1335: P_API_NAME => L_API_NAME
1336: ,P_PKG_NAME => G_PKG_NAME
1337: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1338: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1339: ,X_MSG_COUNT => X_MSG_COUNT
1340: ,X_MSG_DATA => X_MSG_DATA
1341: ,X_RETURN_STATUS => X_RETURN_STATUS);
1334: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1335: P_API_NAME => L_API_NAME
1336: ,P_PKG_NAME => G_PKG_NAME
1337: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1338: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1339: ,X_MSG_COUNT => X_MSG_COUNT
1340: ,X_MSG_DATA => X_MSG_DATA
1341: ,X_RETURN_STATUS => X_RETURN_STATUS);
1342:
1442: FND_MSG_PUB.initialize;
1443: END IF;
1444:
1445: -- Debug Message
1446: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
1447:
1448: -- Initialize API return status to SUCCESS
1449: x_return_status := FND_API.G_RET_STS_SUCCESS;
1450:
1541: END IF;
1542:
1543:
1544: -- Debug Message
1545: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Public API: ' || l_api_name || 'end');
1546:
1547:
1548: -- Standard call to get message count and if count is 1, get message info.
1549: FND_MSG_PUB.Count_And_Get
1552: );
1553:
1554: EXCEPTION
1555: WHEN FND_API.G_EXC_ERROR THEN
1556: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1557: P_API_NAME => L_API_NAME
1558: ,P_PKG_NAME => G_PKG_NAME
1559: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1560: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1556: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1557: P_API_NAME => L_API_NAME
1558: ,P_PKG_NAME => G_PKG_NAME
1559: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1560: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1561: ,X_MSG_COUNT => X_MSG_COUNT
1562: ,X_MSG_DATA => X_MSG_DATA
1563: ,X_RETURN_STATUS => X_RETURN_STATUS);
1564:
1562: ,X_MSG_DATA => X_MSG_DATA
1563: ,X_RETURN_STATUS => X_RETURN_STATUS);
1564:
1565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1566: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1567: P_API_NAME => L_API_NAME
1568: ,P_PKG_NAME => G_PKG_NAME
1569: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1570: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1566: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1567: P_API_NAME => L_API_NAME
1568: ,P_PKG_NAME => G_PKG_NAME
1569: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1570: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1571: ,X_MSG_COUNT => X_MSG_COUNT
1572: ,X_MSG_DATA => X_MSG_DATA
1573: ,X_RETURN_STATUS => X_RETURN_STATUS);
1574:
1572: ,X_MSG_DATA => X_MSG_DATA
1573: ,X_RETURN_STATUS => X_RETURN_STATUS);
1574:
1575: WHEN OTHERS THEN
1576: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1577: P_API_NAME => L_API_NAME
1578: ,P_PKG_NAME => G_PKG_NAME
1579: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1580: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1575: WHEN OTHERS THEN
1576: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1577: P_API_NAME => L_API_NAME
1578: ,P_PKG_NAME => G_PKG_NAME
1579: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1580: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1581: ,X_MSG_COUNT => X_MSG_COUNT
1582: ,X_MSG_DATA => X_MSG_DATA
1583: ,X_RETURN_STATUS => X_RETURN_STATUS);
1576: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1577: P_API_NAME => L_API_NAME
1578: ,P_PKG_NAME => G_PKG_NAME
1579: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
1580: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
1581: ,X_MSG_COUNT => X_MSG_COUNT
1582: ,X_MSG_DATA => X_MSG_DATA
1583: ,X_RETURN_STATUS => X_RETURN_STATUS);
1584:
1776: FND_MSG_PUB.initialize;
1777: END IF;
1778:
1779: -- Debug Message
1780: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
1781:
1782: -- Initialize API return status to SUCCESS
1783: x_return_status := FND_API.G_RET_STS_SUCCESS;
1784:
1983: END IF; -- l_CC_Auth_Prof
1984:
1985: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1986: aso_debug_pub.add('Create_Order: Before Proc_Order: ', 1, 'N');
1987: aso_utility_pvt.print_login_info();
1988: END IF;
1989:
1990: -- added new debug messages
1991: IF l_line_tbl.count > 0 then
2078:
2079:
2080: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2081: aso_debug_pub.add('Create_Order: After Proc_Order: x_return_status: '||x_return_status, 1, 'N');
2082: aso_utility_pvt.print_login_info();
2083: END IF;
2084:
2085: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2086: -- retrieve_oe_messages;
2201:
2202: EXCEPTION
2203: WHEN FND_API.G_EXC_ERROR THEN
2204: null;
2205: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2206: P_API_NAME => L_API_NAME
2207: ,P_PKG_NAME => G_PKG_NAME
2208: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2209: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2205: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2206: P_API_NAME => L_API_NAME
2207: ,P_PKG_NAME => G_PKG_NAME
2208: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2209: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2210: ,X_MSG_COUNT => X_MSG_COUNT
2211: ,X_MSG_DATA => X_MSG_DATA
2212: ,X_RETURN_STATUS => X_RETURN_STATUS);
2213:
2212: ,X_RETURN_STATUS => X_RETURN_STATUS);
2213:
2214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2215: null;
2216: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2217: P_API_NAME => L_API_NAME
2218: ,P_PKG_NAME => G_PKG_NAME
2219: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2220: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2216: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2217: P_API_NAME => L_API_NAME
2218: ,P_PKG_NAME => G_PKG_NAME
2219: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2220: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2221: ,X_MSG_COUNT => X_MSG_COUNT
2222: ,X_MSG_DATA => X_MSG_DATA
2223: ,X_RETURN_STATUS => X_RETURN_STATUS);
2224: WHEN OTHERS THEN
2222: ,X_MSG_DATA => X_MSG_DATA
2223: ,X_RETURN_STATUS => X_RETURN_STATUS);
2224: WHEN OTHERS THEN
2225: null;
2226: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2227: P_API_NAME => L_API_NAME
2228: ,P_PKG_NAME => G_PKG_NAME
2229: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2230: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2226: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2227: P_API_NAME => L_API_NAME
2228: ,P_PKG_NAME => G_PKG_NAME
2229: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2230: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2231: ,X_MSG_COUNT => X_MSG_COUNT
2232: ,X_MSG_DATA => X_MSG_DATA
2233: ,X_RETURN_STATUS => X_RETURN_STATUS);
2234:
2410: FND_MSG_PUB.initialize;
2411: END IF;
2412:
2413: -- Debug Message
2414: ASO_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
2415:
2416: -- Initialize API return status to SUCCESS
2417: x_return_status := FND_API.G_RET_STS_SUCCESS;
2418:
2635: END LOOP;
2636:
2637: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2638: aso_debug_pub.add('Update_Order: Before Process_order',1,'Y');
2639: aso_utility_pvt.print_login_info();
2640: END IF;
2641:
2642: -- bug# 1927450
2643: OE_STANDARD_WF.SAVE_MESSAGES_OFF;
2717: l_request_tbl := lx_request_tbl;
2718:
2719: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2720: aso_debug_pub.add('Update_Order: After Process_Order: x_return_status'||x_return_status,1,'Y');
2721: aso_utility_pvt.print_login_info();
2722: END IF;
2723:
2724: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2725: IF x_msg_count > 0 THEN
2789:
2790: EXCEPTION
2791: WHEN FND_API.G_EXC_ERROR THEN
2792: null;
2793: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2794: P_API_NAME => L_API_NAME
2795: ,P_PKG_NAME => G_PKG_NAME
2796: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2797: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2793: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2794: P_API_NAME => L_API_NAME
2795: ,P_PKG_NAME => G_PKG_NAME
2796: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2797: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2798: ,X_MSG_COUNT => X_MSG_COUNT
2799: ,X_MSG_DATA => X_MSG_DATA
2800: ,X_RETURN_STATUS => X_RETURN_STATUS);
2801:
2800: ,X_RETURN_STATUS => X_RETURN_STATUS);
2801:
2802: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2803: null;
2804: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2805: P_API_NAME => L_API_NAME
2806: ,P_PKG_NAME => G_PKG_NAME
2807: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2808: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2804: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2805: P_API_NAME => L_API_NAME
2806: ,P_PKG_NAME => G_PKG_NAME
2807: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2808: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2809: ,X_MSG_COUNT => X_MSG_COUNT
2810: ,X_MSG_DATA => X_MSG_DATA
2811: ,X_RETURN_STATUS => X_RETURN_STATUS);
2812: WHEN OTHERS THEN
2810: ,X_MSG_DATA => X_MSG_DATA
2811: ,X_RETURN_STATUS => X_RETURN_STATUS);
2812: WHEN OTHERS THEN
2813: null;
2814: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2815: P_API_NAME => L_API_NAME
2816: ,P_PKG_NAME => G_PKG_NAME
2817: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2818: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2814: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2815: P_API_NAME => L_API_NAME
2816: ,P_PKG_NAME => G_PKG_NAME
2817: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
2818: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
2819: ,X_MSG_COUNT => X_MSG_COUNT
2820: ,X_MSG_DATA => X_MSG_DATA
2821: ,X_RETURN_STATUS => X_RETURN_STATUS);
2822: