613:
614: BEGIN
615:
616:
617: -- Standard Start of API savepoint
618: SAVEPOINT CREATE_ORDER_PVT;
619:
620: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
621:
618: SAVEPOINT CREATE_ORDER_PVT;
619:
620: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
621:
622: -- Standard call to check for call compatibility.
623: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
624: p_api_version_number,
625: l_api_name,
626: G_PKG_NAME)
706:
707: -- End of API body
708: --
709:
710: -- Standard check for p_commit
711: IF FND_API.to_Boolean( p_commit )
712: THEN
713: COMMIT WORK;
714: END IF;
714: END IF;
715:
716:
717:
718: -- Standard call to get message count and if count is 1, get message info.
719: FND_MSG_PUB.Count_And_Get
720: ( p_count => x_msg_count,
721: p_data => x_msg_data
722: );
822: l_Line_sales_credit_TBL ASO_QUOTE_PUB.Sales_credit_tbl_type := ASO_QUOTE_PUB.G_MISS_sales_credit_TBL;
823: l_Lot_Serial_Tbl ASO_QUOTE_PUB.Lot_Serial_Tbl_Type := ASO_QUOTE_PUB.G_MISS_Lot_Serial_Tbl;
824:
825: BEGIN
826: -- Standard Start of API savepoint
827: SAVEPOINT UPDATE_order_PVT;
828:
829: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
830:
827: SAVEPOINT UPDATE_order_PVT;
828:
829: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
830:
831: -- Standard call to check for call compatibility.
832: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
833: p_api_version_number,
834: l_api_name,
835: G_PKG_NAME)
918: --
919: -- End of API body
920: --
921:
922: -- Standard check for p_commit
923: IF FND_API.to_Boolean( p_commit )
924: THEN
925: COMMIT WORK;
926: END IF;
926: END IF;
927:
928:
929:
930: -- Standard call to get message count and if count is 1, get message info.
931: FND_MSG_PUB.Count_And_Get
932: ( p_count => x_msg_count,
933: p_data => x_msg_data
934: );
984: l_api_name CONSTANT VARCHAR2(30):= 'DELETE_ORDER';
985: BEGIN
986:
987:
988: -- Standard Start of API savepoint
989: SAVEPOINT Delete_Order_PVT;
990:
991: -- Standard call to check for call compatibility.
992: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
987:
988: -- Standard Start of API savepoint
989: SAVEPOINT Delete_Order_PVT;
990:
991: -- Standard call to check for call compatibility.
992: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
993: p_api_version_number,
994: l_api_name,
995: G_PKG_NAME)
1047: --
1048: -- End of API body
1049: --
1050:
1051: -- Standard check for p_commit
1052: IF FND_API.to_Boolean( p_commit )
1053: THEN
1054: COMMIT WORK;
1055: END IF;
1055: END IF;
1056:
1057:
1058:
1059: -- Standard call to get message count and if count is 1, get message info.
1060: FND_MSG_PUB.Count_And_Get
1061: ( p_count => x_msg_count,
1062: p_data => x_msg_data
1063: );
1170: -- hyang: 2692785
1171: lx_header_rec OE_Order_PUB.Header_Rec_Type;
1172:
1173: BEGIN
1174: -- Standard Start of API savepoint
1175: SAVEPOINT Book_Order_PUB;
1176:
1177: -- Standard call to check for call compatibility.
1178: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1173: BEGIN
1174: -- Standard Start of API savepoint
1175: SAVEPOINT Book_Order_PUB;
1176:
1177: -- Standard call to check for call compatibility.
1178: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1179: p_api_version_number,
1180: l_api_name,
1181: G_PKG_NAME)
1241: l_header_rec.header_id := p_order_header_id;
1242: -- l_header_rec.operation := OE_Globals.G_OPR_UPDATE;
1243:
1244: -- bug# 1927450
1245: OE_STANDARD_WF.SAVE_MESSAGES_OFF;
1246:
1247: OE_Order_GRP.Process_Order
1248: ( p_api_version_number => 1.0
1249: , p_init_msg_list => FND_API.G_TRUE
1291: --
1292: -- End of API body.
1293: --
1294:
1295: -- Standard check for p_commit
1296: IF FND_API.to_Boolean( p_commit )
1297: THEN
1298: COMMIT WORK;
1299: END IF;
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
1308: ( p_count => x_msg_count,
1309: p_data => x_msg_data
1310: );
1422: from oe_lookups
1423: WHERE lookup_type = 'CANCEL_CODE'
1424: AND lookup_code = 'Not provided';
1425: BEGIN
1426: -- Standard Start of API savepoint
1427: SAVEPOINT CANCEL_Order_PUB;
1428:
1429: -- Standard call to check for call compatibility.
1430: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1425: BEGIN
1426: -- Standard Start of API savepoint
1427: SAVEPOINT CANCEL_Order_PUB;
1428:
1429: -- Standard call to check for call compatibility.
1430: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1431: p_api_version_number,
1432: l_api_name,
1433: G_PKG_NAME)
1484:
1485: l_header_rec.operation := OE_Globals.G_OPR_UPDATE;
1486:
1487: -- bug# 1927450
1488: OE_STANDARD_WF.SAVE_MESSAGES_OFF;
1489:
1490: OE_Order_GRP.Process_Order
1491: ( p_api_version_number => 1.0
1492: , p_init_msg_list => FND_API.G_TRUE
1533: --
1534: -- End of API body.
1535: --
1536:
1537: -- Standard check for p_commit
1538: IF FND_API.to_Boolean( p_commit )
1539: THEN
1540: COMMIT WORK;
1541: END IF;
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
1550: ( p_count => x_msg_count,
1551: p_data => x_msg_data
1552: );
1783:
1784: /*** End : Code change done for Bug 14358079 ***/
1785:
1786: BEGIN
1787: -- Standard Start of API savepoint
1788: SAVEPOINT CREATE_ORDER_PVT;
1789:
1790: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1791:
1788: SAVEPOINT CREATE_ORDER_PVT;
1789:
1790: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1791:
1792: -- Standard call to check for call compatibility.
1793: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1794: p_api_version,
1795: l_api_name,
1796: G_PKG_NAME)
2036: END IF;
2037: end if;
2038:
2039: -- bug# 1927450
2040: OE_STANDARD_WF.SAVE_MESSAGES_OFF;
2041:
2042: /* P:=FND_GLOBAL.APPLICATION_SHORT_NAME;
2043: aso_debug_pub.add('Create_Order: Before OE_Order_GRP.Process_Order vs value of p' || P ,1,'N');
2044: --Start Fix for Bug bug 12775283
2339:
2340: --
2341: -- End of API body
2342: --
2343: -- Standard check for p_commit
2344: IF FND_API.to_Boolean( p_commit )
2345: THEN
2346: COMMIT WORK;
2347: END IF;
2347: END IF;
2348:
2349:
2350:
2351: -- Standard call to get message count and if count is 1, get message info.
2352: FND_MSG_PUB.Count_And_Get
2353: ( p_count => x_msg_count,
2354: p_data => x_msg_data
2355: );
2552: l_Risk_Mgmt_Failure_Prof VARCHAR2(20);
2553:
2554: i NUMBER := 1;
2555: BEGIN
2556: -- Standard Start of API savepoint
2557: SAVEPOINT UPDATE_order_PVT;
2558:
2559: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2560:
2557: SAVEPOINT UPDATE_order_PVT;
2558:
2559: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
2560:
2561: -- Standard call to check for call compatibility.
2562: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2563: p_api_version ,
2564: l_api_name,
2565: G_PKG_NAME)
2805: aso_utility_pvt.print_login_info();
2806: END IF;
2807:
2808: -- bug# 1927450
2809: OE_STANDARD_WF.SAVE_MESSAGES_OFF;
2810:
2811: OE_Order_GRP.Process_Order
2812: ( p_api_version_number => l_api_version_number
2813: , p_init_msg_list => FND_API.G_TRUE
2938: --
2939: -- End of API body
2940: --
2941:
2942: -- Standard check for p_commit
2943: IF FND_API.to_Boolean( p_commit )
2944: THEN
2945: COMMIT WORK;
2946: END IF;
2946: END IF;
2947:
2948:
2949:
2950: -- Standard call to get message count and if count is 1, get message info.
2951: FND_MSG_PUB.Count_And_Get
2952: ( p_count => x_msg_count,
2953: p_data => x_msg_data
2954: );