DBA Data[Home] [Help]

APPS.WSH_USA_QUANTITY_PVT dependencies on FND_API

Line 132: FND_API.G_MISS_NUM , wdd.delivery_detail_id ,

128: AND wda.delivery_id = wnd.delivery_id (+)
129: AND wdd.source_line_id = p_changed_attribute.source_line_id
130: AND wdd.source_code = p_source_code
131: AND wdd.delivery_detail_id = decode (p_changed_attribute.delivery_detail_id,
132: FND_API.G_MISS_NUM , wdd.delivery_detail_id ,
133: p_changed_attribute.delivery_detail_id)
134: AND wdd.container_flag = 'N'
135: AND wdd.released_status <> 'D' -- New
136: AND DECODE(p_context, 'OVERPICK',wdd.requested_quantity,1) > 0 -- bug 2941581. Skip the 0 requested quantities for overpick normalization.

Line 197: FND_API.G_MISS_NUM , wdd.delivery_detail_id ,

193: AND wda.delivery_id = wnd.delivery_id (+)
194: AND wdd.source_line_id = p_changed_attribute.source_line_id
195: AND wdd.source_code = p_source_code
196: AND wdd.delivery_detail_id = decode (p_changed_attribute.delivery_detail_id,
197: FND_API.G_MISS_NUM , wdd.delivery_detail_id ,
198: p_changed_attribute.delivery_detail_id)
199: AND wdd.container_flag = 'N'
200: AND wdd.released_status <> 'D'
201: AND wdd.transaction_temp_id = msnt.transaction_temp_id(+)

Line 518: IF ( (p_changed_attribute.ship_from_org_id <> FND_API.G_MISS_NUM)

514: -- There is a possibility of having quantity change on delivery lines when there is a change in org
515: -- value on sales order line and item's primary uom is different in old and new orgs.
516: --BUG#11893915
517:
518: IF ( (p_changed_attribute.ship_from_org_id <> FND_API.G_MISS_NUM)
519: AND (p_changed_attribute.ship_from_org_id <> l_organization_id) )
520: and ((p_changed_attribute.inventory_item_id = FND_API.G_MISS_NUM ) OR (p_changed_attribute.inventory_item_id = l_inventory_item_id)) THEN
521: --{
522: IF l_debug_on THEN

Line 520: and ((p_changed_attribute.inventory_item_id = FND_API.G_MISS_NUM ) OR (p_changed_attribute.inventory_item_id = l_inventory_item_id)) THEN

516: --BUG#11893915
517:
518: IF ( (p_changed_attribute.ship_from_org_id <> FND_API.G_MISS_NUM)
519: AND (p_changed_attribute.ship_from_org_id <> l_organization_id) )
520: and ((p_changed_attribute.inventory_item_id = FND_API.G_MISS_NUM ) OR (p_changed_attribute.inventory_item_id = l_inventory_item_id)) THEN
521: --{
522: IF l_debug_on THEN
523: WSH_DEBUG_SV.log(l_module_name,'inside primary UOM change checking.');
524: END IF;

Line 623: IF ( p_changed_attribute.ordered_quantity2 = FND_API.G_MISS_NUM ) THEN

619: END IF;
620: --
621: -- HW OPMCONV - Removed code forking
622:
623: IF ( p_changed_attribute.ordered_quantity2 = FND_API.G_MISS_NUM ) THEN
624: l_new_requested_quantity2 := null ;
625: ELSE
626: l_new_requested_quantity2 := p_changed_attribute.ordered_quantity2 ;
627: END IF;

Line 887: ( nvl(l_wh_type, FND_API.G_MISS_CHAR) <> 'TW2' OR

883: -- Case I : Delvry Stat = OP/Unassigned Packed = N Planned = N Released Status = N/R/X
884: --bug# 6689448 (replenishment project): Should not allow to add the qty on replenishment requested and replenishment completed details.
885: IF ( ((old_delivery_detail_rec.status_code IN ('OP', 'SA', 'NO'))) AND -- sperera 940/945
886: -- TPW - Distributed Organization Changes - Start
887: ( nvl(l_wh_type, FND_API.G_MISS_CHAR) <> 'TW2' OR
888: ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'TW2' AND
889: old_delivery_detail_rec.shipment_batch_id is null ) ) AND
890: -- TPW - Distributed Organization Changes - End
891: (old_delivery_detail_rec.parent_delivery_detail_id IS NULL) AND

Line 888: ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'TW2' AND

884: --bug# 6689448 (replenishment project): Should not allow to add the qty on replenishment requested and replenishment completed details.
885: IF ( ((old_delivery_detail_rec.status_code IN ('OP', 'SA', 'NO'))) AND -- sperera 940/945
886: -- TPW - Distributed Organization Changes - Start
887: ( nvl(l_wh_type, FND_API.G_MISS_CHAR) <> 'TW2' OR
888: ( nvl(l_wh_type, FND_API.G_MISS_CHAR) = 'TW2' AND
889: old_delivery_detail_rec.shipment_batch_id is null ) ) AND
890: -- TPW - Distributed Organization Changes - End
891: (old_delivery_detail_rec.parent_delivery_detail_id IS NULL) AND
892: (NVL(old_delivery_detail_rec.planned_flag,'N') = 'N') AND

Line 1126: IF ( old_delivery_detail_rec.requested_quantity2 <> FND_API.G_MISS_NUM

1122: --
1123: -- Bug 2754311
1124: --
1125: -- HW OPMCONV - Removed code forking and fixed the condition
1126: IF ( old_delivery_detail_rec.requested_quantity2 <> FND_API.G_MISS_NUM
1127: OR old_delivery_detail_rec.requested_quantity2 IS NOT NULL )
1128: THEN
1129: l_delivery_detail_rec.requested_quantity2 := l_changed_detail_quantity2;
1130: IF l_debug_on THEN

Line 1135: l_delivery_Detail_rec.requested_quantity2 := FND_API.G_MISS_NUM;

1131: WSH_DEBUG_SV.log(l_module_name,'l_changed_detail_quantity2', l_changed_detail_quantity2);
1132: WSH_DEBUG_SV.log(l_module_name,'New_DD.req_qty2', l_delivery_detail_rec.requested_quantity2);
1133: END IF;
1134: ELSE
1135: l_delivery_Detail_rec.requested_quantity2 := FND_API.G_MISS_NUM;
1136: IF l_debug_on THEN
1137: WSH_DEBUG_SV.log(l_module_name,'IN ELSE AND l_changed_detail_quantity2', l_changed_detail_quantity2);
1138: END IF;
1139: END IF;

Line 1161: l_delivery_detail_rec.picked_quantity := FND_API.G_MISS_NUM;

1157: l_delivery_detail_rec.requested_quantity := l_changed_detail_quantity;
1158: END IF;
1159: END IF; -- end muom
1160: --
1161: l_delivery_detail_rec.picked_quantity := FND_API.G_MISS_NUM;
1162: l_delivery_detail_rec.picked_quantity2 := FND_API.G_MISS_NUM;
1163: l_delivery_detail_rec.cancelled_quantity := FND_API.G_MISS_NUM;
1164: l_delivery_detail_rec.cancelled_quantity2 := FND_API.G_MISS_NUM;
1165: l_delivery_detail_rec.move_order_line_id := FND_API.G_MISS_NUM;

Line 1162: l_delivery_detail_rec.picked_quantity2 := FND_API.G_MISS_NUM;

1158: END IF;
1159: END IF; -- end muom
1160: --
1161: l_delivery_detail_rec.picked_quantity := FND_API.G_MISS_NUM;
1162: l_delivery_detail_rec.picked_quantity2 := FND_API.G_MISS_NUM;
1163: l_delivery_detail_rec.cancelled_quantity := FND_API.G_MISS_NUM;
1164: l_delivery_detail_rec.cancelled_quantity2 := FND_API.G_MISS_NUM;
1165: l_delivery_detail_rec.move_order_line_id := FND_API.G_MISS_NUM;
1166: l_delivery_detail_rec.shipped_quantity := FND_API.G_MISS_NUM;

Line 1163: l_delivery_detail_rec.cancelled_quantity := FND_API.G_MISS_NUM;

1159: END IF; -- end muom
1160: --
1161: l_delivery_detail_rec.picked_quantity := FND_API.G_MISS_NUM;
1162: l_delivery_detail_rec.picked_quantity2 := FND_API.G_MISS_NUM;
1163: l_delivery_detail_rec.cancelled_quantity := FND_API.G_MISS_NUM;
1164: l_delivery_detail_rec.cancelled_quantity2 := FND_API.G_MISS_NUM;
1165: l_delivery_detail_rec.move_order_line_id := FND_API.G_MISS_NUM;
1166: l_delivery_detail_rec.shipped_quantity := FND_API.G_MISS_NUM;
1167: l_delivery_detail_rec.shipped_quantity2 := FND_API.G_MISS_NUM;

Line 1164: l_delivery_detail_rec.cancelled_quantity2 := FND_API.G_MISS_NUM;

1160: --
1161: l_delivery_detail_rec.picked_quantity := FND_API.G_MISS_NUM;
1162: l_delivery_detail_rec.picked_quantity2 := FND_API.G_MISS_NUM;
1163: l_delivery_detail_rec.cancelled_quantity := FND_API.G_MISS_NUM;
1164: l_delivery_detail_rec.cancelled_quantity2 := FND_API.G_MISS_NUM;
1165: l_delivery_detail_rec.move_order_line_id := FND_API.G_MISS_NUM;
1166: l_delivery_detail_rec.shipped_quantity := FND_API.G_MISS_NUM;
1167: l_delivery_detail_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
1168: l_delivery_detail_rec.delivered_quantity := FND_API.G_MISS_NUM;

Line 1165: l_delivery_detail_rec.move_order_line_id := FND_API.G_MISS_NUM;

1161: l_delivery_detail_rec.picked_quantity := FND_API.G_MISS_NUM;
1162: l_delivery_detail_rec.picked_quantity2 := FND_API.G_MISS_NUM;
1163: l_delivery_detail_rec.cancelled_quantity := FND_API.G_MISS_NUM;
1164: l_delivery_detail_rec.cancelled_quantity2 := FND_API.G_MISS_NUM;
1165: l_delivery_detail_rec.move_order_line_id := FND_API.G_MISS_NUM;
1166: l_delivery_detail_rec.shipped_quantity := FND_API.G_MISS_NUM;
1167: l_delivery_detail_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
1168: l_delivery_detail_rec.delivered_quantity := FND_API.G_MISS_NUM;
1169: l_delivery_detail_rec.delivered_quantity2 := FND_API.G_MISS_NUM;

Line 1166: l_delivery_detail_rec.shipped_quantity := FND_API.G_MISS_NUM;

1162: l_delivery_detail_rec.picked_quantity2 := FND_API.G_MISS_NUM;
1163: l_delivery_detail_rec.cancelled_quantity := FND_API.G_MISS_NUM;
1164: l_delivery_detail_rec.cancelled_quantity2 := FND_API.G_MISS_NUM;
1165: l_delivery_detail_rec.move_order_line_id := FND_API.G_MISS_NUM;
1166: l_delivery_detail_rec.shipped_quantity := FND_API.G_MISS_NUM;
1167: l_delivery_detail_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
1168: l_delivery_detail_rec.delivered_quantity := FND_API.G_MISS_NUM;
1169: l_delivery_detail_rec.delivered_quantity2 := FND_API.G_MISS_NUM;
1170: l_delivery_detail_rec.quality_control_quantity := FND_API.G_MISS_NUM;

Line 1167: l_delivery_detail_rec.shipped_quantity2 := FND_API.G_MISS_NUM;

1163: l_delivery_detail_rec.cancelled_quantity := FND_API.G_MISS_NUM;
1164: l_delivery_detail_rec.cancelled_quantity2 := FND_API.G_MISS_NUM;
1165: l_delivery_detail_rec.move_order_line_id := FND_API.G_MISS_NUM;
1166: l_delivery_detail_rec.shipped_quantity := FND_API.G_MISS_NUM;
1167: l_delivery_detail_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
1168: l_delivery_detail_rec.delivered_quantity := FND_API.G_MISS_NUM;
1169: l_delivery_detail_rec.delivered_quantity2 := FND_API.G_MISS_NUM;
1170: l_delivery_detail_rec.quality_control_quantity := FND_API.G_MISS_NUM;
1171: l_delivery_detail_rec.quality_control_quantity2 := FND_API.G_MISS_NUM;

Line 1168: l_delivery_detail_rec.delivered_quantity := FND_API.G_MISS_NUM;

1164: l_delivery_detail_rec.cancelled_quantity2 := FND_API.G_MISS_NUM;
1165: l_delivery_detail_rec.move_order_line_id := FND_API.G_MISS_NUM;
1166: l_delivery_detail_rec.shipped_quantity := FND_API.G_MISS_NUM;
1167: l_delivery_detail_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
1168: l_delivery_detail_rec.delivered_quantity := FND_API.G_MISS_NUM;
1169: l_delivery_detail_rec.delivered_quantity2 := FND_API.G_MISS_NUM;
1170: l_delivery_detail_rec.quality_control_quantity := FND_API.G_MISS_NUM;
1171: l_delivery_detail_rec.quality_control_quantity2 := FND_API.G_MISS_NUM;
1172: l_delivery_detail_rec.cycle_count_quantity := FND_API.G_MISS_NUM;

Line 1169: l_delivery_detail_rec.delivered_quantity2 := FND_API.G_MISS_NUM;

1165: l_delivery_detail_rec.move_order_line_id := FND_API.G_MISS_NUM;
1166: l_delivery_detail_rec.shipped_quantity := FND_API.G_MISS_NUM;
1167: l_delivery_detail_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
1168: l_delivery_detail_rec.delivered_quantity := FND_API.G_MISS_NUM;
1169: l_delivery_detail_rec.delivered_quantity2 := FND_API.G_MISS_NUM;
1170: l_delivery_detail_rec.quality_control_quantity := FND_API.G_MISS_NUM;
1171: l_delivery_detail_rec.quality_control_quantity2 := FND_API.G_MISS_NUM;
1172: l_delivery_detail_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
1173: l_delivery_detail_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;

Line 1170: l_delivery_detail_rec.quality_control_quantity := FND_API.G_MISS_NUM;

1166: l_delivery_detail_rec.shipped_quantity := FND_API.G_MISS_NUM;
1167: l_delivery_detail_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
1168: l_delivery_detail_rec.delivered_quantity := FND_API.G_MISS_NUM;
1169: l_delivery_detail_rec.delivered_quantity2 := FND_API.G_MISS_NUM;
1170: l_delivery_detail_rec.quality_control_quantity := FND_API.G_MISS_NUM;
1171: l_delivery_detail_rec.quality_control_quantity2 := FND_API.G_MISS_NUM;
1172: l_delivery_detail_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
1173: l_delivery_detail_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
1174: l_delivery_detail_rec.subinventory := FND_API.G_MISS_CHAR;

Line 1171: l_delivery_detail_rec.quality_control_quantity2 := FND_API.G_MISS_NUM;

1167: l_delivery_detail_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
1168: l_delivery_detail_rec.delivered_quantity := FND_API.G_MISS_NUM;
1169: l_delivery_detail_rec.delivered_quantity2 := FND_API.G_MISS_NUM;
1170: l_delivery_detail_rec.quality_control_quantity := FND_API.G_MISS_NUM;
1171: l_delivery_detail_rec.quality_control_quantity2 := FND_API.G_MISS_NUM;
1172: l_delivery_detail_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
1173: l_delivery_detail_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
1174: l_delivery_detail_rec.subinventory := FND_API.G_MISS_CHAR;
1175: l_delivery_detail_rec.revision := FND_API.G_MISS_CHAR;

Line 1172: l_delivery_detail_rec.cycle_count_quantity := FND_API.G_MISS_NUM;

1168: l_delivery_detail_rec.delivered_quantity := FND_API.G_MISS_NUM;
1169: l_delivery_detail_rec.delivered_quantity2 := FND_API.G_MISS_NUM;
1170: l_delivery_detail_rec.quality_control_quantity := FND_API.G_MISS_NUM;
1171: l_delivery_detail_rec.quality_control_quantity2 := FND_API.G_MISS_NUM;
1172: l_delivery_detail_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
1173: l_delivery_detail_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
1174: l_delivery_detail_rec.subinventory := FND_API.G_MISS_CHAR;
1175: l_delivery_detail_rec.revision := FND_API.G_MISS_CHAR;
1176: l_delivery_detail_rec.lot_number := FND_API.G_MISS_CHAR;

Line 1173: l_delivery_detail_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;

1169: l_delivery_detail_rec.delivered_quantity2 := FND_API.G_MISS_NUM;
1170: l_delivery_detail_rec.quality_control_quantity := FND_API.G_MISS_NUM;
1171: l_delivery_detail_rec.quality_control_quantity2 := FND_API.G_MISS_NUM;
1172: l_delivery_detail_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
1173: l_delivery_detail_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
1174: l_delivery_detail_rec.subinventory := FND_API.G_MISS_CHAR;
1175: l_delivery_detail_rec.revision := FND_API.G_MISS_CHAR;
1176: l_delivery_detail_rec.lot_number := FND_API.G_MISS_CHAR;
1177: l_delivery_detail_rec.locator_id := FND_API.G_MISS_NUM;

Line 1174: l_delivery_detail_rec.subinventory := FND_API.G_MISS_CHAR;

1170: l_delivery_detail_rec.quality_control_quantity := FND_API.G_MISS_NUM;
1171: l_delivery_detail_rec.quality_control_quantity2 := FND_API.G_MISS_NUM;
1172: l_delivery_detail_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
1173: l_delivery_detail_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
1174: l_delivery_detail_rec.subinventory := FND_API.G_MISS_CHAR;
1175: l_delivery_detail_rec.revision := FND_API.G_MISS_CHAR;
1176: l_delivery_detail_rec.lot_number := FND_API.G_MISS_CHAR;
1177: l_delivery_detail_rec.locator_id := FND_API.G_MISS_NUM;
1178:

Line 1175: l_delivery_detail_rec.revision := FND_API.G_MISS_CHAR;

1171: l_delivery_detail_rec.quality_control_quantity2 := FND_API.G_MISS_NUM;
1172: l_delivery_detail_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
1173: l_delivery_detail_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
1174: l_delivery_detail_rec.subinventory := FND_API.G_MISS_CHAR;
1175: l_delivery_detail_rec.revision := FND_API.G_MISS_CHAR;
1176: l_delivery_detail_rec.lot_number := FND_API.G_MISS_CHAR;
1177: l_delivery_detail_rec.locator_id := FND_API.G_MISS_NUM;
1178:
1179: l_delivery_detail_rec.master_serial_number := FND_API.G_MISS_CHAR;

Line 1176: l_delivery_detail_rec.lot_number := FND_API.G_MISS_CHAR;

1172: l_delivery_detail_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
1173: l_delivery_detail_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
1174: l_delivery_detail_rec.subinventory := FND_API.G_MISS_CHAR;
1175: l_delivery_detail_rec.revision := FND_API.G_MISS_CHAR;
1176: l_delivery_detail_rec.lot_number := FND_API.G_MISS_CHAR;
1177: l_delivery_detail_rec.locator_id := FND_API.G_MISS_NUM;
1178:
1179: l_delivery_detail_rec.master_serial_number := FND_API.G_MISS_CHAR;
1180: l_delivery_detail_rec.serial_number := FND_API.G_MISS_CHAR;

Line 1177: l_delivery_detail_rec.locator_id := FND_API.G_MISS_NUM;

1173: l_delivery_detail_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
1174: l_delivery_detail_rec.subinventory := FND_API.G_MISS_CHAR;
1175: l_delivery_detail_rec.revision := FND_API.G_MISS_CHAR;
1176: l_delivery_detail_rec.lot_number := FND_API.G_MISS_CHAR;
1177: l_delivery_detail_rec.locator_id := FND_API.G_MISS_NUM;
1178:
1179: l_delivery_detail_rec.master_serial_number := FND_API.G_MISS_CHAR;
1180: l_delivery_detail_rec.serial_number := FND_API.G_MISS_CHAR;
1181: l_delivery_detail_rec.to_serial_number := FND_API.G_MISS_CHAR;

Line 1179: l_delivery_detail_rec.master_serial_number := FND_API.G_MISS_CHAR;

1175: l_delivery_detail_rec.revision := FND_API.G_MISS_CHAR;
1176: l_delivery_detail_rec.lot_number := FND_API.G_MISS_CHAR;
1177: l_delivery_detail_rec.locator_id := FND_API.G_MISS_NUM;
1178:
1179: l_delivery_detail_rec.master_serial_number := FND_API.G_MISS_CHAR;
1180: l_delivery_detail_rec.serial_number := FND_API.G_MISS_CHAR;
1181: l_delivery_detail_rec.to_serial_number := FND_API.G_MISS_CHAR;
1182: l_delivery_detail_rec.transaction_temp_id := FND_API.G_MISS_NUM;
1183: l_delivery_detail_rec.transaction_id := FND_API.G_MISS_NUM; -- 2803570

Line 1180: l_delivery_detail_rec.serial_number := FND_API.G_MISS_CHAR;

1176: l_delivery_detail_rec.lot_number := FND_API.G_MISS_CHAR;
1177: l_delivery_detail_rec.locator_id := FND_API.G_MISS_NUM;
1178:
1179: l_delivery_detail_rec.master_serial_number := FND_API.G_MISS_CHAR;
1180: l_delivery_detail_rec.serial_number := FND_API.G_MISS_CHAR;
1181: l_delivery_detail_rec.to_serial_number := FND_API.G_MISS_CHAR;
1182: l_delivery_detail_rec.transaction_temp_id := FND_API.G_MISS_NUM;
1183: l_delivery_detail_rec.transaction_id := FND_API.G_MISS_NUM; -- 2803570
1184:

Line 1181: l_delivery_detail_rec.to_serial_number := FND_API.G_MISS_CHAR;

1177: l_delivery_detail_rec.locator_id := FND_API.G_MISS_NUM;
1178:
1179: l_delivery_detail_rec.master_serial_number := FND_API.G_MISS_CHAR;
1180: l_delivery_detail_rec.serial_number := FND_API.G_MISS_CHAR;
1181: l_delivery_detail_rec.to_serial_number := FND_API.G_MISS_CHAR;
1182: l_delivery_detail_rec.transaction_temp_id := FND_API.G_MISS_NUM;
1183: l_delivery_detail_rec.transaction_id := FND_API.G_MISS_NUM; -- 2803570
1184:
1185: -- TPW - Distributed Organization Changes - Start

Line 1182: l_delivery_detail_rec.transaction_temp_id := FND_API.G_MISS_NUM;

1178:
1179: l_delivery_detail_rec.master_serial_number := FND_API.G_MISS_CHAR;
1180: l_delivery_detail_rec.serial_number := FND_API.G_MISS_CHAR;
1181: l_delivery_detail_rec.to_serial_number := FND_API.G_MISS_CHAR;
1182: l_delivery_detail_rec.transaction_temp_id := FND_API.G_MISS_NUM;
1183: l_delivery_detail_rec.transaction_id := FND_API.G_MISS_NUM; -- 2803570
1184:
1185: -- TPW - Distributed Organization Changes - Start
1186: l_delivery_detail_rec.shipment_batch_id := FND_API.G_MISS_NUM;

Line 1183: l_delivery_detail_rec.transaction_id := FND_API.G_MISS_NUM; -- 2803570

1179: l_delivery_detail_rec.master_serial_number := FND_API.G_MISS_CHAR;
1180: l_delivery_detail_rec.serial_number := FND_API.G_MISS_CHAR;
1181: l_delivery_detail_rec.to_serial_number := FND_API.G_MISS_CHAR;
1182: l_delivery_detail_rec.transaction_temp_id := FND_API.G_MISS_NUM;
1183: l_delivery_detail_rec.transaction_id := FND_API.G_MISS_NUM; -- 2803570
1184:
1185: -- TPW - Distributed Organization Changes - Start
1186: l_delivery_detail_rec.shipment_batch_id := FND_API.G_MISS_NUM;
1187: l_delivery_detail_rec.shipment_line_number := FND_API.G_MISS_NUM;

Line 1186: l_delivery_detail_rec.shipment_batch_id := FND_API.G_MISS_NUM;

1182: l_delivery_detail_rec.transaction_temp_id := FND_API.G_MISS_NUM;
1183: l_delivery_detail_rec.transaction_id := FND_API.G_MISS_NUM; -- 2803570
1184:
1185: -- TPW - Distributed Organization Changes - Start
1186: l_delivery_detail_rec.shipment_batch_id := FND_API.G_MISS_NUM;
1187: l_delivery_detail_rec.shipment_line_number := FND_API.G_MISS_NUM;
1188: l_delivery_detail_rec.reference_line_id := FND_API.G_MISS_NUM;
1189: -- TPW - Distributed Organization Changes - End
1190:

Line 1187: l_delivery_detail_rec.shipment_line_number := FND_API.G_MISS_NUM;

1183: l_delivery_detail_rec.transaction_id := FND_API.G_MISS_NUM; -- 2803570
1184:
1185: -- TPW - Distributed Organization Changes - Start
1186: l_delivery_detail_rec.shipment_batch_id := FND_API.G_MISS_NUM;
1187: l_delivery_detail_rec.shipment_line_number := FND_API.G_MISS_NUM;
1188: l_delivery_detail_rec.reference_line_id := FND_API.G_MISS_NUM;
1189: -- TPW - Distributed Organization Changes - End
1190:
1191: -- bug # 6719369 (replenishment project)

Line 1188: l_delivery_detail_rec.reference_line_id := FND_API.G_MISS_NUM;

1184:
1185: -- TPW - Distributed Organization Changes - Start
1186: l_delivery_detail_rec.shipment_batch_id := FND_API.G_MISS_NUM;
1187: l_delivery_detail_rec.shipment_line_number := FND_API.G_MISS_NUM;
1188: l_delivery_detail_rec.reference_line_id := FND_API.G_MISS_NUM;
1189: -- TPW - Distributed Organization Changes - End
1190:
1191: -- bug # 6719369 (replenishment project)
1192: l_delivery_detail_rec.replenishment_status := FND_API.G_MISS_CHAR;

Line 1192: l_delivery_detail_rec.replenishment_status := FND_API.G_MISS_CHAR;

1188: l_delivery_detail_rec.reference_line_id := FND_API.G_MISS_NUM;
1189: -- TPW - Distributed Organization Changes - End
1190:
1191: -- bug # 6719369 (replenishment project)
1192: l_delivery_detail_rec.replenishment_status := FND_API.G_MISS_CHAR;
1193:
1194:
1195: --
1196: -- Debug Statements

Line 1444: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1440: -- muom
1441: WSH_DEBUG_SV.logmsg(l_module_name, 'CQ1 l_return_status '||l_return_status||' l_requested_adj_quantity '||l_requested_adj_quantity);
1442: END IF;
1443:
1444: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1445: --
1446: -- Debug Statements
1447: --
1448: IF l_debug_on THEN

Line 1453: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1449: WSH_DEBUG_SV.logmsg(l_module_name, 'CANCELLING QUANTITY FAILED FOR DETAIL '||OLD_DELIVERY_DETAIL_REC.DELIVERY_DETAIL_ID );
1450: END IF;
1451: --
1452: x_return_status := l_return_status;
1453: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1454: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1455: ELSE
1456: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.cancel_quantity',l_module_name);
1457: END IF;

Line 1516: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1512: x_return_status => l_return_status);
1513: IF l_debug_on THEN
1514: WSH_DEBUG_SV.log(l_module_name,'Handle_Overpick_cancelled l_return_status',l_return_status);
1515: END IF;
1516: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1517: --
1518: -- Debug Statements
1519: --
1520: IF l_debug_on THEN

Line 1598: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1594: IF l_debug_on THEN
1595: WSH_DEBUG_SV.log(l_module_name,'log_exception l_return_status',l_return_status);
1596: END IF;
1597:
1598: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1599: --
1600: -- Debug Statements
1601: --
1602: IF l_debug_on THEN

Line 1607: IF (l_return_status IN (FND_API.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

1603: WSH_DEBUG_SV.logmsg(l_module_name, 'LOGGING EXCEPTION FAILED WITH '||L_RETURN_STATUS );
1604: END IF;
1605: --
1606: x_return_status := l_return_status;
1607: IF (l_return_status IN (FND_API.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1608: FND_MESSAGE.SET_NAME('WSH', 'Error in logging exception');
1609: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1610: ELSE
1611: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.log_exception',l_module_name);

Line 1673: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1669: IF l_debug_on THEN
1670: -- muom
1671: WSH_DEBUG_SV.logmsg(l_module_name, 'CQ2 l_return_status '||l_return_status||' l_requested_adj_quantity '||l_requested_adj_quantity);
1672: END IF;
1673: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1674: --
1675: -- Debug Statements
1676: --
1677: IF l_debug_on THEN

Line 1682: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1678: WSH_DEBUG_SV.logmsg(l_module_name, 'CANCELLING QUANTITY FAILED FOR DETAIL '||OLD_DELIVERY_DETAIL_REC.DELIVERY_DETAIL_ID );
1679: END IF;
1680: --
1681: x_return_status := l_return_status;
1682: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1683: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1684: ELSE
1685: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.cancel_quantity',l_module_name);
1686: END IF;

Line 1725: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1721: IF l_debug_on THEN
1722: WSH_DEBUG_SV.log(l_module_name,'Handle_Overpick_cancelled l_return_status',l_return_status);
1723: END IF;
1724:
1725: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1726: --
1727: -- Debug Statements
1728: --
1729: IF l_debug_on THEN

Line 1855: p_lock_records => fnd_api.g_true,

1851: p_source_code => p_source_code,
1852: p_source_header_id => p_changed_attribute.source_header_id,
1853: p_source_line_id => p_changed_attribute.source_line_id,
1854: p_organization_id => old_delivery_detail_rec.organization_id,
1855: p_lock_records => fnd_api.g_true,
1856: p_cancel_order_mode => inv_reservation_global.g_cancel_order_yes,
1857: p_delivery_detail_id => null, -- X-dock
1858: x_mtl_reservation_tbl => l_rsv_array,
1859: x_mtl_reservation_tbl_count => l_size,

Line 1884: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1880: IF l_debug_on THEN
1881: WSH_DEBUG_SV.log(l_module_name,'delete_reservation l_return_status',l_return_status);
1882: END IF;
1883:
1884: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1885: --
1886: -- Debug Statements
1887: --
1888: IF l_debug_on THEN

Line 1892: x_return_status := FND_API.G_RET_STS_ERROR;

1888: IF l_debug_on THEN
1889: WSH_DEBUG_SV.logmsg(l_module_name, 'DELETE RESERVATION FAILED FOR SOURCE LINE '||P_CHANGED_ATTRIBUTE.SOURCE_LINE_ID );
1890: END IF;
1891: --
1892: x_return_status := FND_API.G_RET_STS_ERROR;
1893: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1894: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1895: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1896: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.delete_reservation',l_module_name);

Line 1893: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1889: WSH_DEBUG_SV.logmsg(l_module_name, 'DELETE RESERVATION FAILED FOR SOURCE LINE '||P_CHANGED_ATTRIBUTE.SOURCE_LINE_ID );
1890: END IF;
1891: --
1892: x_return_status := FND_API.G_RET_STS_ERROR;
1893: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1894: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1895: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1896: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.delete_reservation',l_module_name);
1897: --END IF;

Line 1895: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1891: --
1892: x_return_status := FND_API.G_RET_STS_ERROR;
1893: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1894: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1895: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1896: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.delete_reservation',l_module_name);
1897: --END IF;
1898: --
1899: -- Debug Statements

Line 1933: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1929: IF l_debug_on THEN
1930: WSH_DEBUG_SV.log(l_module_name,'cancel_nonstaged_reservation l_return_status',l_return_status);
1931: END IF;
1932:
1933: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1934: --
1935: -- Debug Statements
1936: --
1937: IF l_debug_on THEN

Line 1941: x_return_status := FND_API.G_RET_STS_ERROR;

1937: IF l_debug_on THEN
1938: WSH_DEBUG_SV.logmsg(l_module_name, 'CANCELLING NON STAGED RESERVATION FAILED FOR SOURCE LINE '||P_CHANGED_ATTRIBUTE.SOURCE_LINE_ID );
1939: END IF;
1940: --
1941: x_return_status := FND_API.G_RET_STS_ERROR;
1942: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1943: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1944: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1945: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.cancel_nonstaged_reservation',l_module_name);

Line 1942: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1938: WSH_DEBUG_SV.logmsg(l_module_name, 'CANCELLING NON STAGED RESERVATION FAILED FOR SOURCE LINE '||P_CHANGED_ATTRIBUTE.SOURCE_LINE_ID );
1939: END IF;
1940: --
1941: x_return_status := FND_API.G_RET_STS_ERROR;
1942: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1943: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1944: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1945: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.cancel_nonstaged_reservation',l_module_name);
1946: --END IF;

Line 1944: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1940: --
1941: x_return_status := FND_API.G_RET_STS_ERROR;
1942: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1943: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1944: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1945: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.cancel_nonstaged_reservation',l_module_name);
1946: --END IF;
1947: --
1948: -- Debug Statements

Line 2205: x_return_status := FND_API.G_RET_STS_SUCCESS;

2201: WSH_DEBUG_SV.log(l_module_name,'P_CONTEXT',P_CONTEXT);
2202: WSH_DEBUG_SV.log(l_module_name,'P_FULFILLMENT_BASE',P_FULFILLMENT_BASE);
2203: END IF;
2204: --
2205: x_return_status := FND_API.G_RET_STS_SUCCESS;
2206:
2207: -- bug 2942655 / 2936559
2208: -- overpick normalization should skip the lines pending overpick
2209: -- because their requested quantities (0) are not taken.

Line 2268: IF x_return_status IN (fnd_api.g_ret_sts_error,

2264:
2265: IF l_debug_on THEN
2266: WSH_DEBUG_SV.log(l_module_name,'WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION',x_return_status);
2267: END IF;
2268: IF x_return_status IN (fnd_api.g_ret_sts_error,
2269: fnd_api.g_ret_sts_unexp_error) THEN
2270: IF l_debug_on THEN
2271: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION ') ;
2272: END IF;

Line 2269: fnd_api.g_ret_sts_unexp_error) THEN

2265: IF l_debug_on THEN
2266: WSH_DEBUG_SV.log(l_module_name,'WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION',x_return_status);
2267: END IF;
2268: IF x_return_status IN (fnd_api.g_ret_sts_error,
2269: fnd_api.g_ret_sts_unexp_error) THEN
2270: IF l_debug_on THEN
2271: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION ') ;
2272: END IF;
2273:

Line 2274: x_return_status := FND_API.G_RET_STS_ERROR;

2270: IF l_debug_on THEN
2271: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION ') ;
2272: END IF;
2273:
2274: x_return_status := FND_API.G_RET_STS_ERROR;
2275: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2276:
2277: IF l_debug_on THEN
2278: WSH_DEBUG_SV.pop(l_module_name);

Line 2308: IF x_return_status = fnd_api.g_ret_sts_success THEN

2304: IF l_debug_on THEN
2305: WSH_DEBUG_SV.log(l_module_name,'Cancel_Move_Order_Line x_return_status',x_return_status);
2306: END IF;
2307: --HW OPMCONV - Removed branching
2308: IF x_return_status = fnd_api.g_ret_sts_success THEN
2309: --
2310: -- Debug Statements
2311: --
2312: IF l_debug_on THEN

Line 2349: x_return_status := FND_API.G_RET_STS_ERROR;

2345: END LOOP;
2346: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
2347: l_error_text := '';
2348: END IF;
2349: x_return_status := FND_API.G_RET_STS_ERROR;
2350: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2351: --
2352: -- Debug Statements
2353: --

Line 2374: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2370: x_return_status => x_return_status);
2371: IF l_debug_on THEN
2372: WSH_DEBUG_SV.log(l_module_name,'update_serial_numbers x_return_status',x_return_status);
2373: END IF;
2374: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2375: x_return_status := FND_API.G_RET_STS_ERROR;
2376: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2377: --
2378: -- Debug Statements

Line 2375: x_return_status := FND_API.G_RET_STS_ERROR;

2371: IF l_debug_on THEN
2372: WSH_DEBUG_SV.log(l_module_name,'update_serial_numbers x_return_status',x_return_status);
2373: END IF;
2374: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2375: x_return_status := FND_API.G_RET_STS_ERROR;
2376: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2377: --
2378: -- Debug Statements
2379: --

Line 2513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2509: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
2510: END IF;
2511: --
2512: WHEN OTHERS THEN
2513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2514: WSH_UTIL_CORE.default_handler('WSH_INTERFACE.Handle_Overpick_cancelled',l_module_name);
2515:
2516: --
2517: -- Debug Statements

Line 2573: x_return_status := FND_API.G_RET_STS_SUCCESS;

2569: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2570: WSH_DEBUG_SV.log(l_module_name,'P_REASON',P_REASON);
2571: END IF;
2572:
2573: x_return_status := FND_API.G_RET_STS_SUCCESS;
2574:
2575: -- Get p_reason here which is passed as the message name
2576: FND_MESSAGE.SET_NAME('WSH',p_reason);
2577: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID',p_delivery_detail_id);

Line 2621: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2617: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION ID: '|| L_DUMMY_EXCEPTION_ID );
2618: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION MSG DATA: '|| L_EXCEPTION_MSG_DATA );
2619: END IF;
2620:
2621: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2622: RAISE logging_exception_failure;
2623: END IF;
2624:
2625: IF l_debug_on THEN

Line 2631: x_return_status := FND_API.G_RET_STS_ERROR;

2627: END IF;
2628: --
2629: EXCEPTION
2630: WHEN logging_exception_failure THEN
2631: x_return_status := FND_API.G_RET_STS_ERROR;
2632: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2633: --
2634: -- Debug Statements
2635: --

Line 2642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2638: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:LOGGING_EXCEPTION_FAILURE');
2639: END IF;
2640: --
2641: WHEN others THEN
2642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2643: --
2644: -- Debug Statements
2645: --
2646: IF l_debug_on THEN

Line 2819: x_return_status := FND_API.G_RET_STS_SUCCESS;

2815: IF l_debug_on THEN
2816: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_QUANTITY_PVT.CANCEL_QUANTITY ' );
2817: END IF;
2818: --
2819: x_return_status := FND_API.G_RET_STS_SUCCESS;
2820:
2821: -- OTM R12
2822: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
2823:

Line 2854: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2850:
2851: IF l_debug_on THEN
2852: WSH_DEBUG_SV.log(l_module_name,'unreserve_delivery_detail x_return_status',x_return_status);
2853: END IF;
2854: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2855: x_return_status := FND_API.G_RET_STS_ERROR;
2856: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2857: --
2858: -- Debug Statements

Line 2855: x_return_status := FND_API.G_RET_STS_ERROR;

2851: IF l_debug_on THEN
2852: WSH_DEBUG_SV.log(l_module_name,'unreserve_delivery_detail x_return_status',x_return_status);
2853: END IF;
2854: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2855: x_return_status := FND_API.G_RET_STS_ERROR;
2856: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2857: --
2858: -- Debug Statements
2859: --

Line 3215: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3211: IF l_debug_on THEN
3212: WSH_DEBUG_SV.log(l_module_name,'Reduce_Move_Order_Quantity x_return_status',x_return_status);
3213: END IF;
3214:
3215: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3216: FND_MESSAGE.Set_Name('WSH', 'WSH_REDUCE_MO_QUANTITY');
3217: IF l_msg_count = 1 THEN
3218: --
3219: -- Debug Statements

Line 3241: x_return_status := FND_API.G_RET_STS_ERROR;

3237: END LOOP;
3238: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
3239: l_error_text := '';
3240: END IF;
3241: x_return_status := FND_API.G_RET_STS_ERROR;
3242: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3243: --
3244: -- Debug Statements
3245: --

Line 3440: IF x_return_status = fnd_api.g_ret_sts_success THEN

3436: IF l_debug_on THEN
3437: WSH_DEBUG_SV.log(l_module_name,'INV_MO_Cancel_PVT.Cancel_Move_Order_Line x_return_status',x_return_status);
3438: END IF;
3439: --HW OPMCONV. Removed code forking
3440: IF x_return_status = fnd_api.g_ret_sts_success THEN
3441: --
3442: -- Debug Statements
3443: --
3444: IF l_debug_on THEN

Line 3481: x_return_status := FND_API.G_RET_STS_ERROR;

3477: END LOOP;
3478: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
3479: l_error_text := '';
3480: END IF;
3481: x_return_status := FND_API.G_RET_STS_ERROR;
3482: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3483: --
3484: -- Debug Statements
3485: --

Line 3517: IF x_return_status = fnd_api.g_ret_sts_success THEN

3513: WSH_DEBUG_SV.log(l_module_name,'INV_MO_Cancel_PVT.Cancel_Move_Order_Line x_return_status',x_return_status);
3514: END IF;
3515: --HW OPMCONV - Removed code forking
3516:
3517: IF x_return_status = fnd_api.g_ret_sts_success THEN
3518: --
3519: -- Debug Statements
3520: --
3521: IF l_debug_on THEN

Line 3557: x_return_status := FND_API.G_RET_STS_ERROR;

3553: l_error_text := l_error_text || l_msg_data;
3554: END LOOP;
3555: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
3556: END IF;
3557: x_return_status := FND_API.G_RET_STS_ERROR;
3558: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3559: --
3560: -- Debug Statements
3561: --

Line 3598: IF x_return_status = fnd_api.g_ret_sts_success THEN

3594: IF l_debug_on THEN
3595: WSH_DEBUG_SV.log(l_module_name,'WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION',x_return_status);
3596: END IF;
3597:
3598: IF x_return_status = fnd_api.g_ret_sts_success THEN
3599: --
3600: -- Debug Statements
3601: --
3602: IF l_debug_on THEN

Line 3614: x_return_status := FND_API.G_RET_STS_ERROR;

3610: IF l_debug_on THEN
3611: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION ' );
3612: END IF;
3613: --
3614: x_return_status := FND_API.G_RET_STS_ERROR;
3615: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3616: --
3617: -- Debug Statements
3618: --

Line 3663: x_return_status := FND_API.G_RET_STS_ERROR;

3659: --
3660: FND_MESSAGE.SET_NAME('WSH','WSH_STAGED_SERIAL_EXISTS');
3661: FND_MESSAGE.SET_TOKEN('SERIAL_QUANTITY',l_serial_quantity);
3662: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID',p_delivery_detail_id);
3663: x_return_status := FND_API.G_RET_STS_ERROR;
3664: return;
3665:
3666: ELSIF (p_serial_number IS NOT NULL ) AND (p_requested_quantity - ABS(p_changed_detail_quantity) <= 0) THEN
3667: l_serial_quantity := 1;

Line 3679: x_return_status := FND_API.G_RET_STS_ERROR;

3675: --
3676: FND_MESSAGE.SET_NAME('WSH','WSH_STAGED_SERIAL_EXISTS');
3677: FND_MESSAGE.SET_TOKEN('SERIAL_QUANTITY',l_serial_quantity);
3678: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID',p_delivery_detail_id);
3679: x_return_status := FND_API.G_RET_STS_ERROR;
3680: return;
3681: END IF;
3682:
3683: ELSIF p_ordered_quantity = 0 AND (p_transaction_temp_id IS NOT NULL OR p_serial_number IS NOT NULL ) THEN

Line 3698: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3694: x_return_status => x_return_status);
3695: IF l_debug_on THEN
3696: WSH_DEBUG_SV.log(l_module_name,'Update_Serial_Numbers x_return_status',x_return_status);
3697: END IF;
3698: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3699: x_return_status := FND_API.G_RET_STS_ERROR;
3700: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3701: --
3702: -- Debug Statements

Line 3699: x_return_status := FND_API.G_RET_STS_ERROR;

3695: IF l_debug_on THEN
3696: WSH_DEBUG_SV.log(l_module_name,'Update_Serial_Numbers x_return_status',x_return_status);
3697: END IF;
3698: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3699: x_return_status := FND_API.G_RET_STS_ERROR;
3700: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3701: --
3702: -- Debug Statements
3703: --

Line 3757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3753: WHEN others THEN
3754: IF c_check_del_assign%ISOPEN THEN
3755: CLOSE c_check_del_assign;
3756: END IF;
3757: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3758: --
3759: -- Debug Statements
3760: --
3761: IF l_debug_on THEN