179: WSH_DEBUG_SV.log(l_module_name,'P_ENTITY_ID',P_ENTITY_ID);
180: END IF;
181: --
182: IF p_entity_name IS NOT NULL THEN
183: FND_MESSAGE.SET_NAME('WSH',p_entity_name);
184: l_entity := FND_MESSAGE.GET;
185: END IF;
186:
187: FND_MESSAGE.SET_NAME('WSH',p_exception_name);
180: END IF;
181: --
182: IF p_entity_name IS NOT NULL THEN
183: FND_MESSAGE.SET_NAME('WSH',p_entity_name);
184: l_entity := FND_MESSAGE.GET;
185: END IF;
186:
187: FND_MESSAGE.SET_NAME('WSH',p_exception_name);
188: FND_MESSAGE.SET_TOKEN('DETAIL',p_delivery_detail_id);
183: FND_MESSAGE.SET_NAME('WSH',p_entity_name);
184: l_entity := FND_MESSAGE.GET;
185: END IF;
186:
187: FND_MESSAGE.SET_NAME('WSH',p_exception_name);
188: FND_MESSAGE.SET_TOKEN('DETAIL',p_delivery_detail_id);
189:
190: --Bug 2834274
191: --{
184: l_entity := FND_MESSAGE.GET;
185: END IF;
186:
187: FND_MESSAGE.SET_NAME('WSH',p_exception_name);
188: FND_MESSAGE.SET_TOKEN('DETAIL',p_delivery_detail_id);
189:
190: --Bug 2834274
191: --{
192: IF p_entity_name IS NOT NULL THEN
189:
190: --Bug 2834274
191: --{
192: IF p_entity_name IS NOT NULL THEN
193: FND_MESSAGE.SET_TOKEN('ENTITY_NAME',l_entity);
194: IF p_entity_id IS NOT NULL THEN --{
195:
196: IF p_entity_name = 'WSH_DELIVERY' THEN
197: l_name_of_delivery := WSH_NEW_DELIVERIES_PVT.Get_Name(p_entity_id);
195:
196: IF p_entity_name = 'WSH_DELIVERY' THEN
197: l_name_of_delivery := WSH_NEW_DELIVERIES_PVT.Get_Name(p_entity_id);
198: IF l_name_of_delivery IS NOT NULL THEN
199: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_name_of_delivery);
200: ELSE
201: FND_MESSAGE.SET_TOKEN('ENTITY_ID',p_entity_id);
202: END IF;
203: ELSIF p_entity_name = 'WSH_CONTAINER' THEN
197: l_name_of_delivery := WSH_NEW_DELIVERIES_PVT.Get_Name(p_entity_id);
198: IF l_name_of_delivery IS NOT NULL THEN
199: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_name_of_delivery);
200: ELSE
201: FND_MESSAGE.SET_TOKEN('ENTITY_ID',p_entity_id);
202: END IF;
203: ELSIF p_entity_name = 'WSH_CONTAINER' THEN
204: l_name_of_container := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_entity_id);
205: IF l_name_of_container IS NOT NULL THEN
202: END IF;
203: ELSIF p_entity_name = 'WSH_CONTAINER' THEN
204: l_name_of_container := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_entity_id);
205: IF l_name_of_container IS NOT NULL THEN
206: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_name_of_container);
207: ELSE
208: FND_MESSAGE.SET_TOKEN('ENTITY_ID',p_entity_id);
209: END IF;
210: ELSE
204: l_name_of_container := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_entity_id);
205: IF l_name_of_container IS NOT NULL THEN
206: FND_MESSAGE.SET_TOKEN('ENTITY_ID',l_name_of_container);
207: ELSE
208: FND_MESSAGE.SET_TOKEN('ENTITY_ID',p_entity_id);
209: END IF;
210: ELSE
211: FND_MESSAGE.SET_TOKEN('ENTITY_ID',p_entity_id);
212: END IF;
207: ELSE
208: FND_MESSAGE.SET_TOKEN('ENTITY_ID',p_entity_id);
209: END IF;
210: ELSE
211: FND_MESSAGE.SET_TOKEN('ENTITY_ID',p_entity_id);
212: END IF;
213:
214: END IF; --}
215: END IF;
214: END IF; --}
215: END IF;
216: --}
217:
218: l_msg := FND_MESSAGE.GET;
219: wsh_xc_util.log_exception(
220: p_api_version => 1.0,
221: x_return_status => x_return_status,
222: x_msg_count => l_exception_msg_count,
305: OPEN c_cache_attributes_2(p_source_line_id, p_delivery_detail_id, p_source_code);
306: FETCH c_cache_attributes_2 INTO g_cache_detail_rec;
307: IF c_cache_attributes_2%NOTFOUND THEN
308: CLOSE c_cache_attributes_2;
309: FND_MESSAGE.SET_NAME('WSH', 'WSH_NO_DATA_FOUND');
310: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
311: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
312: --
313: IF l_debug_on THEN
1341: IF l_status = 'Y' AND p_wms_flag = 'Y' THEN
1342: IF l_debug_on THEN
1343: WSH_DEBUG_SV.log(l_module_name,'l_status is set to Y');
1344: END IF;
1345: FND_MESSAGE.SET_NAME('WSH', 'WSH_WMS_UPDATE_NOT_ALLOWED');
1346: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1347: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
1348: RAISE update_not_allowed;
1349: exit; -- exit loop if action breaks WMS.
1767: END IF;
1768: --Intialize the message and location id
1769: IF ( l_del_planned_tab.count > 0) THEN
1770: --{
1771: FND_MESSAGE.SET_NAME('WSH','WSH_ITEM_SUBSTITUTED');
1772: FND_MESSAGE.SET_TOKEN('ITEM1',WSH_UTIL_CORE.Get_Item_Name(p_attributes_rec.inventory_item_id,
1773: l_final_org_id));
1774: FND_MESSAGE.SET_TOKEN('ITEM2',WSH_UTIL_CORE.Get_Item_Name(g_cache_detail_rec.inventory_item_id,
1775: l_final_org_id));
1768: --Intialize the message and location id
1769: IF ( l_del_planned_tab.count > 0) THEN
1770: --{
1771: FND_MESSAGE.SET_NAME('WSH','WSH_ITEM_SUBSTITUTED');
1772: FND_MESSAGE.SET_TOKEN('ITEM1',WSH_UTIL_CORE.Get_Item_Name(p_attributes_rec.inventory_item_id,
1773: l_final_org_id));
1774: FND_MESSAGE.SET_TOKEN('ITEM2',WSH_UTIL_CORE.Get_Item_Name(g_cache_detail_rec.inventory_item_id,
1775: l_final_org_id));
1776: l_msg := FND_MESSAGE.GET;
1770: --{
1771: FND_MESSAGE.SET_NAME('WSH','WSH_ITEM_SUBSTITUTED');
1772: FND_MESSAGE.SET_TOKEN('ITEM1',WSH_UTIL_CORE.Get_Item_Name(p_attributes_rec.inventory_item_id,
1773: l_final_org_id));
1774: FND_MESSAGE.SET_TOKEN('ITEM2',WSH_UTIL_CORE.Get_Item_Name(g_cache_detail_rec.inventory_item_id,
1775: l_final_org_id));
1776: l_msg := FND_MESSAGE.GET;
1777: l_exception_location_id := l_location_id;
1778: --}
1772: FND_MESSAGE.SET_TOKEN('ITEM1',WSH_UTIL_CORE.Get_Item_Name(p_attributes_rec.inventory_item_id,
1773: l_final_org_id));
1774: FND_MESSAGE.SET_TOKEN('ITEM2',WSH_UTIL_CORE.Get_Item_Name(g_cache_detail_rec.inventory_item_id,
1775: l_final_org_id));
1776: l_msg := FND_MESSAGE.GET;
1777: l_exception_location_id := l_location_id;
1778: --}
1779: END IF;
1780: i := l_del_planned_tab.FIRST;
2066: WHEN item_update_not_allowed THEN
2067: x_update_allowed := 'N';
2068: --
2069: -- For item change case, enter both item names.
2070: FND_MESSAGE.SET_NAME('WSH','WSH_ITEM_SUB_NOT_ALLOWED');
2071: FND_MESSAGE.SET_TOKEN('ITEM1',WSH_UTIL_CORE.Get_Item_Name(g_cache_detail_rec.inventory_item_id,l_final_org_id));
2072: FND_MESSAGE.SET_TOKEN('ITEM2',WSH_UTIL_CORE.Get_Item_Name(p_attributes_rec.inventory_item_id,l_final_org_id));
2073: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2074: IF l_debug_on THEN
2067: x_update_allowed := 'N';
2068: --
2069: -- For item change case, enter both item names.
2070: FND_MESSAGE.SET_NAME('WSH','WSH_ITEM_SUB_NOT_ALLOWED');
2071: FND_MESSAGE.SET_TOKEN('ITEM1',WSH_UTIL_CORE.Get_Item_Name(g_cache_detail_rec.inventory_item_id,l_final_org_id));
2072: FND_MESSAGE.SET_TOKEN('ITEM2',WSH_UTIL_CORE.Get_Item_Name(p_attributes_rec.inventory_item_id,l_final_org_id));
2073: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2074: IF l_debug_on THEN
2075: WSH_DEBUG_SV.logmsg(l_module_name,'UPDATE_NOT_ALLOWED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2068: --
2069: -- For item change case, enter both item names.
2070: FND_MESSAGE.SET_NAME('WSH','WSH_ITEM_SUB_NOT_ALLOWED');
2071: FND_MESSAGE.SET_TOKEN('ITEM1',WSH_UTIL_CORE.Get_Item_Name(g_cache_detail_rec.inventory_item_id,l_final_org_id));
2072: FND_MESSAGE.SET_TOKEN('ITEM2',WSH_UTIL_CORE.Get_Item_Name(p_attributes_rec.inventory_item_id,l_final_org_id));
2073: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2074: IF l_debug_on THEN
2075: WSH_DEBUG_SV.logmsg(l_module_name,'UPDATE_NOT_ALLOWED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2076: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:UPDATE_NOT_ALLOWED');
2085: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:UPDATE_NOT_ALLOWED');
2086: END IF;
2087: --
2088: WHEN mark_reprice_error THEN
2089: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
2090: x_return_status := l_return_status;
2091: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2092: IF l_debug_on THEN
2093: WSH_DEBUG_SV.logmsg(l_module_name,'MARK_REPRICE_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2094: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:MARK_REPRICE_ERROR');
2095: END IF;
2096: --
2097: WHEN Adjust_Planned_Flag_Err THEN
2098: FND_MESSAGE.SET_NAME('WSH', 'WSH_ADJUST_PLANNED_FLAG_ERR');
2099: WSH_UTIL_CORE.add_message(l_return_status,l_module_name);
2100: x_return_status := l_return_status;
2101:
2102: IF l_debug_on THEN
2239: END IF;
2240: --
2241: RETURN;
2242: WHEN mark_reprice_error THEN
2243: FND_MESSAGE.Set_Name('WSH', 'WSH_REPRICE_REQUIRED_ERR');
2244: x_return_status := l_return_status;
2245: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2246: --
2247: IF l_debug_on THEN
2372: AND p_attributes_rec.ship_set_id <> NVL(g_cache_detail_rec.ship_set_id, FND_API.G_MISS_NUM) THEN
2373:
2374: -- Planned for Crossdocking scenario, ECO 4497224
2375: IF l_status = 'S' AND l_mo_line_id IS NULL THEN
2376: FND_MESSAGE.SET_NAME('WSH','WSH_CHANGE_SET_XDOCK_ERROR');
2377: FND_MESSAGE.SET_TOKEN('DETAIL', l_del_det);
2378: IF l_debug_on THEN
2379: WSH_DEBUG_SV.logmsg(l_module_name, 'CANNOT CHANGE_SETS : LINE IX CROSSDOCKED' );
2380: END IF;
2373:
2374: -- Planned for Crossdocking scenario, ECO 4497224
2375: IF l_status = 'S' AND l_mo_line_id IS NULL THEN
2376: FND_MESSAGE.SET_NAME('WSH','WSH_CHANGE_SET_XDOCK_ERROR');
2377: FND_MESSAGE.SET_TOKEN('DETAIL', l_del_det);
2378: IF l_debug_on THEN
2379: WSH_DEBUG_SV.logmsg(l_module_name, 'CANNOT CHANGE_SETS : LINE IX CROSSDOCKED' );
2380: END IF;
2381: RAISE update_not_allowed;
2391: -- HW OPMCONV. Removed branching
2392:
2393: l_mo_line_rec := INV_Trolin_Util.Query_Row(p_line_id => l_mo_line_id);
2394: IF l_mo_line_rec.quantity_detailed > 0 THEN
2395: FND_MESSAGE.SET_NAME('WSH','WSH_CHANGE_SET_ERROR');
2396: FND_MESSAGE.SET_TOKEN('DETAIL', l_del_det);
2397: IF l_debug_on THEN
2398: WSH_DEBUG_SV.logmsg(l_module_name, 'CANNOT CHANGE_SETS : ALLOCATIONS CREATED' );
2399: END IF;
2392:
2393: l_mo_line_rec := INV_Trolin_Util.Query_Row(p_line_id => l_mo_line_id);
2394: IF l_mo_line_rec.quantity_detailed > 0 THEN
2395: FND_MESSAGE.SET_NAME('WSH','WSH_CHANGE_SET_ERROR');
2396: FND_MESSAGE.SET_TOKEN('DETAIL', l_del_det);
2397: IF l_debug_on THEN
2398: WSH_DEBUG_SV.logmsg(l_module_name, 'CANNOT CHANGE_SETS : ALLOCATIONS CREATED' );
2399: END IF;
2400: Raise update_not_allowed;
2821: IF p_wms_flag = 'Y' THEN
2822:
2823: IF dd.released_status = 'Y' THEN
2824:
2825: FND_MESSAGE.SET_NAME('WSH', 'WSH_WMS_UPDATE_NOT_ALLOWED');
2826: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2827: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2828: RAISE update_not_allowed;
2829:
3237:
3238: CLOSE c_get_released_status;
3239:
3240: IF l_delivery_detail_id IS NOT NULL THEN
3241: FND_MESSAGE.SET_NAME('WSH', 'WSH_UPDATE_TOL_NOT_ALLOWED');
3242: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3243: WSH_UTIL_CORE.Add_Message(x_return_status);
3244: RAISE update_not_allowed;
3245: END IF;