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.WSH_USA_QUANTITY_PVT dependencies on FND_API

Line 121: FND_API.G_MISS_NUM , wdd.delivery_detail_id ,

117: AND wda.delivery_id = wnd.delivery_id (+)
118: AND wdd.source_line_id = p_changed_attribute.source_line_id
119: AND wdd.source_code = p_source_code
120: AND wdd.delivery_detail_id = decode (p_changed_attribute.delivery_detail_id,
121: FND_API.G_MISS_NUM , wdd.delivery_detail_id ,
122: p_changed_attribute.delivery_detail_id)
123: AND wdd.container_flag = 'N'
124: AND wdd.released_status <> 'D' -- New
125: AND DECODE(p_context, 'OVERPICK',wdd.requested_quantity,1) > 0 -- bug 2941581. Skip the 0 requested quantities for overpick normalization.

Line 180: FND_API.G_MISS_NUM , wdd.delivery_detail_id ,

176: AND wda.delivery_id = wnd.delivery_id (+)
177: AND wdd.source_line_id = p_changed_attribute.source_line_id
178: AND wdd.source_code = p_source_code
179: AND wdd.delivery_detail_id = decode (p_changed_attribute.delivery_detail_id,
180: FND_API.G_MISS_NUM , wdd.delivery_detail_id ,
181: p_changed_attribute.delivery_detail_id)
182: AND wdd.container_flag = 'N'
183: AND wdd.released_status <> 'D'
184: AND wdd.transaction_temp_id = msnt.transaction_temp_id(+)

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

454: --bug#6407943: begin.
455: -- There is a possibility of having quantity change on delivery lines when there is a change in org
456: -- value on sales order line and item's primary uom is different in old and new orgs.
457:
458: IF ( (p_changed_attribute.ship_from_org_id <> FND_API.G_MISS_NUM)
459: AND (p_changed_attribute.ship_from_org_id <> l_organization_id) )
460: and (p_changed_attribute.inventory_item_id = FND_API.G_MISS_NUM ) THEN
461: --{
462: IF l_debug_on THEN

Line 460: and (p_changed_attribute.inventory_item_id = FND_API.G_MISS_NUM ) THEN

456: -- value on sales order line and item's primary uom is different in old and new orgs.
457:
458: IF ( (p_changed_attribute.ship_from_org_id <> FND_API.G_MISS_NUM)
459: AND (p_changed_attribute.ship_from_org_id <> l_organization_id) )
460: and (p_changed_attribute.inventory_item_id = FND_API.G_MISS_NUM ) THEN
461: --{
462: IF l_debug_on THEN
463: WSH_DEBUG_SV.log(l_module_name,'inside primary UOM change checking.');
464: END IF;

Line 563: if ( p_changed_attribute.ordered_quantity2 = FND_API.G_MISS_NUM ) then

559: END IF;
560: --
561: -- HW OPMCONV - Removed code forking
562:
563: if ( p_changed_attribute.ordered_quantity2 = FND_API.G_MISS_NUM ) then
564: l_new_requested_quantity2 := null ;
565: else
566: l_new_requested_quantity2 := p_changed_attribute.ordered_quantity2 ;
567: end if ;

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

974: --
975: -- Bug 2754311
976: --
977: -- HW OPMCONV - Removed code forking and fixed the condition
978: IF ( old_delivery_detail_rec.requested_quantity2 <> FND_API.G_MISS_NUM
979: OR old_delivery_detail_rec.requested_quantity2 IS NOT NULL ) THEN
980: l_delivery_detail_rec.requested_quantity2 := l_changed_detail_quantity2;
981: IF l_debug_on THEN
982: WSH_DEBUG_SV.log(l_module_name,'l_changed_detail_quantity2', l_changed_detail_quantity2);

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

982: WSH_DEBUG_SV.log(l_module_name,'l_changed_detail_quantity2', l_changed_detail_quantity2);
983: WSH_DEBUG_SV.log(l_module_name,'New_DD.req_qty2', l_delivery_detail_rec.requested_quantity2);
984: END IF;
985: ELSE
986: l_delivery_Detail_rec.requested_quantity2 := FND_API.G_MISS_NUM;
987: IF l_debug_on THEN
988: WSH_DEBUG_SV.log(l_module_name,'IN ELSE AND l_changed_detail_quantity2', l_changed_detail_quantity2);
989: END IF;
990: END IF;

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

988: WSH_DEBUG_SV.log(l_module_name,'IN ELSE AND l_changed_detail_quantity2', l_changed_detail_quantity2);
989: END IF;
990: END IF;
991: --
992: l_delivery_detail_rec.picked_quantity := FND_API.G_MISS_NUM;
993: l_delivery_detail_rec.picked_quantity2 := FND_API.G_MISS_NUM;
994: l_delivery_detail_rec.cancelled_quantity := FND_API.G_MISS_NUM;
995: l_delivery_detail_rec.cancelled_quantity2 := FND_API.G_MISS_NUM;
996: l_delivery_detail_rec.move_order_line_id := FND_API.G_MISS_NUM;

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

989: END IF;
990: END IF;
991: --
992: l_delivery_detail_rec.picked_quantity := FND_API.G_MISS_NUM;
993: l_delivery_detail_rec.picked_quantity2 := FND_API.G_MISS_NUM;
994: l_delivery_detail_rec.cancelled_quantity := FND_API.G_MISS_NUM;
995: l_delivery_detail_rec.cancelled_quantity2 := FND_API.G_MISS_NUM;
996: l_delivery_detail_rec.move_order_line_id := FND_API.G_MISS_NUM;
997: l_delivery_detail_rec.shipped_quantity := FND_API.G_MISS_NUM;

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

990: END IF;
991: --
992: l_delivery_detail_rec.picked_quantity := FND_API.G_MISS_NUM;
993: l_delivery_detail_rec.picked_quantity2 := FND_API.G_MISS_NUM;
994: l_delivery_detail_rec.cancelled_quantity := FND_API.G_MISS_NUM;
995: l_delivery_detail_rec.cancelled_quantity2 := FND_API.G_MISS_NUM;
996: l_delivery_detail_rec.move_order_line_id := FND_API.G_MISS_NUM;
997: l_delivery_detail_rec.shipped_quantity := FND_API.G_MISS_NUM;
998: l_delivery_detail_rec.shipped_quantity2 := FND_API.G_MISS_NUM;

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

991: --
992: l_delivery_detail_rec.picked_quantity := FND_API.G_MISS_NUM;
993: l_delivery_detail_rec.picked_quantity2 := FND_API.G_MISS_NUM;
994: l_delivery_detail_rec.cancelled_quantity := FND_API.G_MISS_NUM;
995: l_delivery_detail_rec.cancelled_quantity2 := FND_API.G_MISS_NUM;
996: l_delivery_detail_rec.move_order_line_id := FND_API.G_MISS_NUM;
997: l_delivery_detail_rec.shipped_quantity := FND_API.G_MISS_NUM;
998: l_delivery_detail_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
999: l_delivery_detail_rec.delivered_quantity := FND_API.G_MISS_NUM;

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

992: l_delivery_detail_rec.picked_quantity := FND_API.G_MISS_NUM;
993: l_delivery_detail_rec.picked_quantity2 := FND_API.G_MISS_NUM;
994: l_delivery_detail_rec.cancelled_quantity := FND_API.G_MISS_NUM;
995: l_delivery_detail_rec.cancelled_quantity2 := FND_API.G_MISS_NUM;
996: l_delivery_detail_rec.move_order_line_id := FND_API.G_MISS_NUM;
997: l_delivery_detail_rec.shipped_quantity := FND_API.G_MISS_NUM;
998: l_delivery_detail_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
999: l_delivery_detail_rec.delivered_quantity := FND_API.G_MISS_NUM;
1000: l_delivery_detail_rec.delivered_quantity2 := FND_API.G_MISS_NUM;

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

993: l_delivery_detail_rec.picked_quantity2 := FND_API.G_MISS_NUM;
994: l_delivery_detail_rec.cancelled_quantity := FND_API.G_MISS_NUM;
995: l_delivery_detail_rec.cancelled_quantity2 := FND_API.G_MISS_NUM;
996: l_delivery_detail_rec.move_order_line_id := FND_API.G_MISS_NUM;
997: l_delivery_detail_rec.shipped_quantity := FND_API.G_MISS_NUM;
998: l_delivery_detail_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
999: l_delivery_detail_rec.delivered_quantity := FND_API.G_MISS_NUM;
1000: l_delivery_detail_rec.delivered_quantity2 := FND_API.G_MISS_NUM;
1001: l_delivery_detail_rec.quality_control_quantity := FND_API.G_MISS_NUM;

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

994: l_delivery_detail_rec.cancelled_quantity := FND_API.G_MISS_NUM;
995: l_delivery_detail_rec.cancelled_quantity2 := FND_API.G_MISS_NUM;
996: l_delivery_detail_rec.move_order_line_id := FND_API.G_MISS_NUM;
997: l_delivery_detail_rec.shipped_quantity := FND_API.G_MISS_NUM;
998: l_delivery_detail_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
999: l_delivery_detail_rec.delivered_quantity := FND_API.G_MISS_NUM;
1000: l_delivery_detail_rec.delivered_quantity2 := FND_API.G_MISS_NUM;
1001: l_delivery_detail_rec.quality_control_quantity := FND_API.G_MISS_NUM;
1002: l_delivery_detail_rec.quality_control_quantity2 := FND_API.G_MISS_NUM;

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

995: l_delivery_detail_rec.cancelled_quantity2 := FND_API.G_MISS_NUM;
996: l_delivery_detail_rec.move_order_line_id := FND_API.G_MISS_NUM;
997: l_delivery_detail_rec.shipped_quantity := FND_API.G_MISS_NUM;
998: l_delivery_detail_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
999: l_delivery_detail_rec.delivered_quantity := FND_API.G_MISS_NUM;
1000: l_delivery_detail_rec.delivered_quantity2 := FND_API.G_MISS_NUM;
1001: l_delivery_detail_rec.quality_control_quantity := FND_API.G_MISS_NUM;
1002: l_delivery_detail_rec.quality_control_quantity2 := FND_API.G_MISS_NUM;
1003: l_delivery_detail_rec.cycle_count_quantity := FND_API.G_MISS_NUM;

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

996: l_delivery_detail_rec.move_order_line_id := FND_API.G_MISS_NUM;
997: l_delivery_detail_rec.shipped_quantity := FND_API.G_MISS_NUM;
998: l_delivery_detail_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
999: l_delivery_detail_rec.delivered_quantity := FND_API.G_MISS_NUM;
1000: l_delivery_detail_rec.delivered_quantity2 := FND_API.G_MISS_NUM;
1001: l_delivery_detail_rec.quality_control_quantity := FND_API.G_MISS_NUM;
1002: l_delivery_detail_rec.quality_control_quantity2 := FND_API.G_MISS_NUM;
1003: l_delivery_detail_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
1004: l_delivery_detail_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;

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

997: l_delivery_detail_rec.shipped_quantity := FND_API.G_MISS_NUM;
998: l_delivery_detail_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
999: l_delivery_detail_rec.delivered_quantity := FND_API.G_MISS_NUM;
1000: l_delivery_detail_rec.delivered_quantity2 := FND_API.G_MISS_NUM;
1001: l_delivery_detail_rec.quality_control_quantity := FND_API.G_MISS_NUM;
1002: l_delivery_detail_rec.quality_control_quantity2 := FND_API.G_MISS_NUM;
1003: l_delivery_detail_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
1004: l_delivery_detail_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
1005: l_delivery_detail_rec.subinventory := FND_API.G_MISS_CHAR;

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

998: l_delivery_detail_rec.shipped_quantity2 := FND_API.G_MISS_NUM;
999: l_delivery_detail_rec.delivered_quantity := FND_API.G_MISS_NUM;
1000: l_delivery_detail_rec.delivered_quantity2 := FND_API.G_MISS_NUM;
1001: l_delivery_detail_rec.quality_control_quantity := FND_API.G_MISS_NUM;
1002: l_delivery_detail_rec.quality_control_quantity2 := FND_API.G_MISS_NUM;
1003: l_delivery_detail_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
1004: l_delivery_detail_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
1005: l_delivery_detail_rec.subinventory := FND_API.G_MISS_CHAR;
1006: l_delivery_detail_rec.revision := FND_API.G_MISS_CHAR;

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

999: l_delivery_detail_rec.delivered_quantity := FND_API.G_MISS_NUM;
1000: l_delivery_detail_rec.delivered_quantity2 := FND_API.G_MISS_NUM;
1001: l_delivery_detail_rec.quality_control_quantity := FND_API.G_MISS_NUM;
1002: l_delivery_detail_rec.quality_control_quantity2 := FND_API.G_MISS_NUM;
1003: l_delivery_detail_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
1004: l_delivery_detail_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
1005: l_delivery_detail_rec.subinventory := FND_API.G_MISS_CHAR;
1006: l_delivery_detail_rec.revision := FND_API.G_MISS_CHAR;
1007: l_delivery_detail_rec.lot_number := FND_API.G_MISS_CHAR;

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

1000: l_delivery_detail_rec.delivered_quantity2 := FND_API.G_MISS_NUM;
1001: l_delivery_detail_rec.quality_control_quantity := FND_API.G_MISS_NUM;
1002: l_delivery_detail_rec.quality_control_quantity2 := FND_API.G_MISS_NUM;
1003: l_delivery_detail_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
1004: l_delivery_detail_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
1005: l_delivery_detail_rec.subinventory := FND_API.G_MISS_CHAR;
1006: l_delivery_detail_rec.revision := FND_API.G_MISS_CHAR;
1007: l_delivery_detail_rec.lot_number := FND_API.G_MISS_CHAR;
1008: l_delivery_detail_rec.locator_id := FND_API.G_MISS_NUM;

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

1001: l_delivery_detail_rec.quality_control_quantity := FND_API.G_MISS_NUM;
1002: l_delivery_detail_rec.quality_control_quantity2 := FND_API.G_MISS_NUM;
1003: l_delivery_detail_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
1004: l_delivery_detail_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
1005: l_delivery_detail_rec.subinventory := FND_API.G_MISS_CHAR;
1006: l_delivery_detail_rec.revision := FND_API.G_MISS_CHAR;
1007: l_delivery_detail_rec.lot_number := FND_API.G_MISS_CHAR;
1008: l_delivery_detail_rec.locator_id := FND_API.G_MISS_NUM;
1009:

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

1002: l_delivery_detail_rec.quality_control_quantity2 := FND_API.G_MISS_NUM;
1003: l_delivery_detail_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
1004: l_delivery_detail_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
1005: l_delivery_detail_rec.subinventory := FND_API.G_MISS_CHAR;
1006: l_delivery_detail_rec.revision := FND_API.G_MISS_CHAR;
1007: l_delivery_detail_rec.lot_number := FND_API.G_MISS_CHAR;
1008: l_delivery_detail_rec.locator_id := FND_API.G_MISS_NUM;
1009:
1010: l_delivery_detail_rec.master_serial_number := FND_API.G_MISS_CHAR;

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

1003: l_delivery_detail_rec.cycle_count_quantity := FND_API.G_MISS_NUM;
1004: l_delivery_detail_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
1005: l_delivery_detail_rec.subinventory := FND_API.G_MISS_CHAR;
1006: l_delivery_detail_rec.revision := FND_API.G_MISS_CHAR;
1007: l_delivery_detail_rec.lot_number := FND_API.G_MISS_CHAR;
1008: l_delivery_detail_rec.locator_id := FND_API.G_MISS_NUM;
1009:
1010: l_delivery_detail_rec.master_serial_number := FND_API.G_MISS_CHAR;
1011: l_delivery_detail_rec.serial_number := FND_API.G_MISS_CHAR;

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

1004: l_delivery_detail_rec.cycle_count_quantity2 := FND_API.G_MISS_NUM;
1005: l_delivery_detail_rec.subinventory := FND_API.G_MISS_CHAR;
1006: l_delivery_detail_rec.revision := FND_API.G_MISS_CHAR;
1007: l_delivery_detail_rec.lot_number := FND_API.G_MISS_CHAR;
1008: l_delivery_detail_rec.locator_id := FND_API.G_MISS_NUM;
1009:
1010: l_delivery_detail_rec.master_serial_number := FND_API.G_MISS_CHAR;
1011: l_delivery_detail_rec.serial_number := FND_API.G_MISS_CHAR;
1012: l_delivery_detail_rec.to_serial_number := FND_API.G_MISS_CHAR;

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

1006: l_delivery_detail_rec.revision := FND_API.G_MISS_CHAR;
1007: l_delivery_detail_rec.lot_number := FND_API.G_MISS_CHAR;
1008: l_delivery_detail_rec.locator_id := FND_API.G_MISS_NUM;
1009:
1010: l_delivery_detail_rec.master_serial_number := FND_API.G_MISS_CHAR;
1011: l_delivery_detail_rec.serial_number := FND_API.G_MISS_CHAR;
1012: l_delivery_detail_rec.to_serial_number := FND_API.G_MISS_CHAR;
1013: l_delivery_detail_rec.transaction_temp_id := FND_API.G_MISS_NUM;
1014: l_delivery_detail_rec.transaction_id := FND_API.G_MISS_NUM; -- 2803570

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

1007: l_delivery_detail_rec.lot_number := FND_API.G_MISS_CHAR;
1008: l_delivery_detail_rec.locator_id := FND_API.G_MISS_NUM;
1009:
1010: l_delivery_detail_rec.master_serial_number := FND_API.G_MISS_CHAR;
1011: l_delivery_detail_rec.serial_number := FND_API.G_MISS_CHAR;
1012: l_delivery_detail_rec.to_serial_number := FND_API.G_MISS_CHAR;
1013: l_delivery_detail_rec.transaction_temp_id := FND_API.G_MISS_NUM;
1014: l_delivery_detail_rec.transaction_id := FND_API.G_MISS_NUM; -- 2803570
1015: -- bug # 6719369 (replenishment project)

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

1008: l_delivery_detail_rec.locator_id := FND_API.G_MISS_NUM;
1009:
1010: l_delivery_detail_rec.master_serial_number := FND_API.G_MISS_CHAR;
1011: l_delivery_detail_rec.serial_number := FND_API.G_MISS_CHAR;
1012: l_delivery_detail_rec.to_serial_number := FND_API.G_MISS_CHAR;
1013: l_delivery_detail_rec.transaction_temp_id := FND_API.G_MISS_NUM;
1014: l_delivery_detail_rec.transaction_id := FND_API.G_MISS_NUM; -- 2803570
1015: -- bug # 6719369 (replenishment project)
1016: l_delivery_detail_rec.replenishment_status := FND_API.G_MISS_CHAR;

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

1009:
1010: l_delivery_detail_rec.master_serial_number := FND_API.G_MISS_CHAR;
1011: l_delivery_detail_rec.serial_number := FND_API.G_MISS_CHAR;
1012: l_delivery_detail_rec.to_serial_number := FND_API.G_MISS_CHAR;
1013: l_delivery_detail_rec.transaction_temp_id := FND_API.G_MISS_NUM;
1014: l_delivery_detail_rec.transaction_id := FND_API.G_MISS_NUM; -- 2803570
1015: -- bug # 6719369 (replenishment project)
1016: l_delivery_detail_rec.replenishment_status := FND_API.G_MISS_CHAR;
1017:

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

1010: l_delivery_detail_rec.master_serial_number := FND_API.G_MISS_CHAR;
1011: l_delivery_detail_rec.serial_number := FND_API.G_MISS_CHAR;
1012: l_delivery_detail_rec.to_serial_number := FND_API.G_MISS_CHAR;
1013: l_delivery_detail_rec.transaction_temp_id := FND_API.G_MISS_NUM;
1014: l_delivery_detail_rec.transaction_id := FND_API.G_MISS_NUM; -- 2803570
1015: -- bug # 6719369 (replenishment project)
1016: l_delivery_detail_rec.replenishment_status := FND_API.G_MISS_CHAR;
1017:
1018:

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

1012: l_delivery_detail_rec.to_serial_number := FND_API.G_MISS_CHAR;
1013: l_delivery_detail_rec.transaction_temp_id := FND_API.G_MISS_NUM;
1014: l_delivery_detail_rec.transaction_id := FND_API.G_MISS_NUM; -- 2803570
1015: -- bug # 6719369 (replenishment project)
1016: l_delivery_detail_rec.replenishment_status := FND_API.G_MISS_CHAR;
1017:
1018:
1019: --
1020: -- Debug Statements

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

1250: IF l_debug_on THEN
1251: WSH_DEBUG_SV.log(l_module_name, 'l_return_status',l_return_status);
1252: END IF;
1253:
1254: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1255: --
1256: -- Debug Statements
1257: --
1258: IF l_debug_on THEN

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

1259: WSH_DEBUG_SV.logmsg(l_module_name, 'CANCELLING QUANTITY FAILED FOR DETAIL '||OLD_DELIVERY_DETAIL_REC.DELIVERY_DETAIL_ID );
1260: END IF;
1261: --
1262: x_return_status := l_return_status;
1263: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1264: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1265: ELSE
1266: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.cancel_quantity',l_module_name);
1267: END IF;

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

1309: x_return_status => l_return_status);
1310: IF l_debug_on THEN
1311: WSH_DEBUG_SV.log(l_module_name,'Handle_Overpick_cancelled l_return_status',l_return_status);
1312: END IF;
1313: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1314: --
1315: -- Debug Statements
1316: --
1317: IF l_debug_on THEN

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

1380: IF l_debug_on THEN
1381: WSH_DEBUG_SV.log(l_module_name,'log_exception l_return_status',l_return_status);
1382: END IF;
1383:
1384: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1385: --
1386: -- Debug Statements
1387: --
1388: IF l_debug_on THEN

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

1389: WSH_DEBUG_SV.logmsg(l_module_name, 'LOGGING EXCEPTION FAILED WITH '||L_RETURN_STATUS );
1390: END IF;
1391: --
1392: x_return_status := l_return_status;
1393: IF (l_return_status IN (FND_API.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1394: FND_MESSAGE.SET_NAME('WSH', 'Error in logging exception');
1395: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1396: ELSE
1397: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.log_exception',l_module_name);

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

1445: x_return_status => l_return_status);
1446: IF l_debug_on THEN
1447: WSH_DEBUG_SV.log(l_module_name,'cancel_quantity l_return_status',l_return_status);
1448: END IF;
1449: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1450: --
1451: -- Debug Statements
1452: --
1453: IF l_debug_on THEN

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

1454: WSH_DEBUG_SV.logmsg(l_module_name, 'CANCELLING QUANTITY FAILED FOR DETAIL '||OLD_DELIVERY_DETAIL_REC.DELIVERY_DETAIL_ID );
1455: END IF;
1456: --
1457: x_return_status := l_return_status;
1458: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1459: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1460: ELSE
1461: wsh_util_core.default_handler('WSH_USA_QUANTITY_PVT.cancel_quantity',l_module_name);
1462: END IF;

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

1492: IF l_debug_on THEN
1493: WSH_DEBUG_SV.log(l_module_name,'Handle_Overpick_cancelled l_return_status',l_return_status);
1494: END IF;
1495:
1496: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1497: --
1498: -- Debug Statements
1499: --
1500: IF l_debug_on THEN

Line 1596: p_lock_records => fnd_api.g_true,

1592: p_source_code => p_source_code,
1593: p_source_header_id => p_changed_attribute.source_header_id,
1594: p_source_line_id => p_changed_attribute.source_line_id,
1595: p_organization_id => old_delivery_detail_rec.organization_id,
1596: p_lock_records => fnd_api.g_true,
1597: p_cancel_order_mode => inv_reservation_global.g_cancel_order_yes,
1598: p_delivery_detail_id => null, -- X-dock
1599: x_mtl_reservation_tbl => l_rsv_array,
1600: x_mtl_reservation_tbl_count => l_size,

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

1621: IF l_debug_on THEN
1622: WSH_DEBUG_SV.log(l_module_name,'delete_reservation l_return_status',l_return_status);
1623: END IF;
1624:
1625: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1626: --
1627: -- Debug Statements
1628: --
1629: IF l_debug_on THEN

Line 1633: x_return_status := FND_API.G_RET_STS_ERROR;

1629: IF l_debug_on THEN
1630: WSH_DEBUG_SV.logmsg(l_module_name, 'DELETE RESERVATION FAILED FOR SOURCE LINE '||P_CHANGED_ATTRIBUTE.SOURCE_LINE_ID );
1631: END IF;
1632: --
1633: x_return_status := FND_API.G_RET_STS_ERROR;
1634: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1635: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1636: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1637: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.delete_reservation',l_module_name);

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

1630: WSH_DEBUG_SV.logmsg(l_module_name, 'DELETE RESERVATION FAILED FOR SOURCE LINE '||P_CHANGED_ATTRIBUTE.SOURCE_LINE_ID );
1631: END IF;
1632: --
1633: x_return_status := FND_API.G_RET_STS_ERROR;
1634: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1635: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1636: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1637: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.delete_reservation',l_module_name);
1638: --END IF;

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

1632: --
1633: x_return_status := FND_API.G_RET_STS_ERROR;
1634: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1635: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1636: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1637: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.delete_reservation',l_module_name);
1638: --END IF;
1639: --
1640: -- Debug Statements

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

1670: IF l_debug_on THEN
1671: WSH_DEBUG_SV.log(l_module_name,'cancel_nonstaged_reservation l_return_status',l_return_status);
1672: END IF;
1673:
1674: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1675: --
1676: -- Debug Statements
1677: --
1678: IF l_debug_on THEN

Line 1682: x_return_status := FND_API.G_RET_STS_ERROR;

1678: IF l_debug_on THEN
1679: WSH_DEBUG_SV.logmsg(l_module_name, 'CANCELLING NON STAGED RESERVATION FAILED FOR SOURCE LINE '||P_CHANGED_ATTRIBUTE.SOURCE_LINE_ID );
1680: END IF;
1681: --
1682: x_return_status := FND_API.G_RET_STS_ERROR;
1683: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1684: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1685: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1686: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.cancel_nonstaged_reservation',l_module_name);

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

1679: WSH_DEBUG_SV.logmsg(l_module_name, 'CANCELLING NON STAGED RESERVATION FAILED FOR SOURCE LINE '||P_CHANGED_ATTRIBUTE.SOURCE_LINE_ID );
1680: END IF;
1681: --
1682: x_return_status := FND_API.G_RET_STS_ERROR;
1683: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1684: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1685: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1686: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.cancel_nonstaged_reservation',l_module_name);
1687: --END IF;

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

1681: --
1682: x_return_status := FND_API.G_RET_STS_ERROR;
1683: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1684: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1685: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1686: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.cancel_nonstaged_reservation',l_module_name);
1687: --END IF;
1688: --
1689: -- Debug Statements

Line 1940: x_return_status := FND_API.G_RET_STS_SUCCESS;

1936: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_CODE',P_SOURCE_CODE);
1937: WSH_DEBUG_SV.log(l_module_name,'P_CONTEXT',P_CONTEXT);
1938: END IF;
1939: --
1940: x_return_status := FND_API.G_RET_STS_SUCCESS;
1941:
1942: -- bug 2942655 / 2936559
1943: -- overpick normalization should skip the lines pending overpick
1944: -- because their requested quantities (0) are not taken.

Line 2003: IF x_return_status IN (fnd_api.g_ret_sts_error,

1999:
2000: IF l_debug_on THEN
2001: WSH_DEBUG_SV.log(l_module_name,'WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION',x_return_status);
2002: END IF;
2003: IF x_return_status IN (fnd_api.g_ret_sts_error,
2004: fnd_api.g_ret_sts_unexp_error) THEN
2005: IF l_debug_on THEN
2006: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION ') ;
2007: END IF;

Line 2004: fnd_api.g_ret_sts_unexp_error) THEN

2000: IF l_debug_on THEN
2001: WSH_DEBUG_SV.log(l_module_name,'WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION',x_return_status);
2002: END IF;
2003: IF x_return_status IN (fnd_api.g_ret_sts_error,
2004: fnd_api.g_ret_sts_unexp_error) THEN
2005: IF l_debug_on THEN
2006: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION ') ;
2007: END IF;
2008:

Line 2009: x_return_status := FND_API.G_RET_STS_ERROR;

2005: IF l_debug_on THEN
2006: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION ') ;
2007: END IF;
2008:
2009: x_return_status := FND_API.G_RET_STS_ERROR;
2010: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2011:
2012: IF l_debug_on THEN
2013: WSH_DEBUG_SV.pop(l_module_name);

Line 2043: IF x_return_status = fnd_api.g_ret_sts_success THEN

2039: IF l_debug_on THEN
2040: WSH_DEBUG_SV.log(l_module_name,'Cancel_Move_Order_Line x_return_status',x_return_status);
2041: END IF;
2042: --HW OPMCONV - Removed branching
2043: IF x_return_status = fnd_api.g_ret_sts_success THEN
2044: --
2045: -- Debug Statements
2046: --
2047: IF l_debug_on THEN

Line 2084: x_return_status := FND_API.G_RET_STS_ERROR;

2080: END LOOP;
2081: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
2082: l_error_text := '';
2083: END IF;
2084: x_return_status := FND_API.G_RET_STS_ERROR;
2085: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2086: --
2087: -- Debug Statements
2088: --

Line 2109: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2105: x_return_status => x_return_status);
2106: IF l_debug_on THEN
2107: WSH_DEBUG_SV.log(l_module_name,'update_serial_numbers x_return_status',x_return_status);
2108: END IF;
2109: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2110: x_return_status := FND_API.G_RET_STS_ERROR;
2111: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2112: --
2113: -- Debug Statements

Line 2110: x_return_status := FND_API.G_RET_STS_ERROR;

2106: IF l_debug_on THEN
2107: WSH_DEBUG_SV.log(l_module_name,'update_serial_numbers x_return_status',x_return_status);
2108: END IF;
2109: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2110: x_return_status := FND_API.G_RET_STS_ERROR;
2111: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2112: --
2113: -- Debug Statements
2114: --

Line 2248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2244: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
2245: END IF;
2246: --
2247: WHEN OTHERS THEN
2248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2249: WSH_UTIL_CORE.default_handler('WSH_INTERFACE.Handle_Overpick_cancelled',l_module_name);
2250:
2251: --
2252: -- Debug Statements

Line 2308: x_return_status := FND_API.G_RET_STS_SUCCESS;

2304: WSH_DEBUG_SV.log(l_module_name,'P_INVENTORY_ITEM_ID',P_INVENTORY_ITEM_ID);
2305: WSH_DEBUG_SV.log(l_module_name,'P_REASON',P_REASON);
2306: END IF;
2307:
2308: x_return_status := FND_API.G_RET_STS_SUCCESS;
2309:
2310: -- Get p_reason here which is passed as the message name
2311: FND_MESSAGE.SET_NAME('WSH',p_reason);
2312: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID',p_delivery_detail_id);

Line 2356: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2352: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION ID: '|| L_DUMMY_EXCEPTION_ID );
2353: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION MSG DATA: '|| L_EXCEPTION_MSG_DATA );
2354: END IF;
2355:
2356: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2357: RAISE logging_exception_failure;
2358: END IF;
2359:
2360: IF l_debug_on THEN

Line 2366: x_return_status := FND_API.G_RET_STS_ERROR;

2362: END IF;
2363: --
2364: EXCEPTION
2365: WHEN logging_exception_failure THEN
2366: x_return_status := FND_API.G_RET_STS_ERROR;
2367: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2368: --
2369: -- Debug Statements
2370: --

Line 2377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2373: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:LOGGING_EXCEPTION_FAILURE');
2374: END IF;
2375: --
2376: WHEN others THEN
2377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2378: --
2379: -- Debug Statements
2380: --
2381: IF l_debug_on THEN

Line 2532: x_return_status := FND_API.G_RET_STS_SUCCESS;

2528: IF l_debug_on THEN
2529: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_QUANTITY_PVT.CANCEL_QUANTITY ' );
2530: END IF;
2531: --
2532: x_return_status := FND_API.G_RET_STS_SUCCESS;
2533:
2534: -- OTM R12
2535: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
2536:

Line 2566: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2562:
2563: IF l_debug_on THEN
2564: WSH_DEBUG_SV.log(l_module_name,'unreserve_delivery_detail x_return_status',x_return_status);
2565: END IF;
2566: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2567: x_return_status := FND_API.G_RET_STS_ERROR;
2568: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2569: --
2570: -- Debug Statements

Line 2567: x_return_status := FND_API.G_RET_STS_ERROR;

2563: IF l_debug_on THEN
2564: WSH_DEBUG_SV.log(l_module_name,'unreserve_delivery_detail x_return_status',x_return_status);
2565: END IF;
2566: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2567: x_return_status := FND_API.G_RET_STS_ERROR;
2568: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2569: --
2570: -- Debug Statements
2571: --

Line 2806: IF x_return_status = fnd_api.g_ret_sts_success THEN

2802:
2803: IF l_debug_on THEN
2804: WSH_DEBUG_SV.log(l_module_name,'Reduce_Move_Order_Quantity x_return_status',x_return_status);
2805: END IF;
2806: IF x_return_status = fnd_api.g_ret_sts_success THEN
2807: --
2808: -- Debug Statements
2809: --
2810: IF l_debug_on THEN

Line 2841: x_return_status := FND_API.G_RET_STS_ERROR;

2837: END LOOP;
2838: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
2839: l_error_text := '';
2840: END IF;
2841: x_return_status := FND_API.G_RET_STS_ERROR;
2842: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
2843: --
2844: -- Debug Statements
2845: --

Line 3040: IF x_return_status = fnd_api.g_ret_sts_success THEN

3036: IF l_debug_on THEN
3037: WSH_DEBUG_SV.log(l_module_name,'INV_MO_Cancel_PVT.Cancel_Move_Order_Line x_return_status',x_return_status);
3038: END IF;
3039: --HW OPMCONV. Removed code forking
3040: IF x_return_status = fnd_api.g_ret_sts_success THEN
3041: --
3042: -- Debug Statements
3043: --
3044: IF l_debug_on THEN

Line 3081: x_return_status := FND_API.G_RET_STS_ERROR;

3077: END LOOP;
3078: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
3079: l_error_text := '';
3080: END IF;
3081: x_return_status := FND_API.G_RET_STS_ERROR;
3082: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3083: --
3084: -- Debug Statements
3085: --

Line 3117: IF x_return_status = fnd_api.g_ret_sts_success THEN

3113: WSH_DEBUG_SV.log(l_module_name,'INV_MO_Cancel_PVT.Cancel_Move_Order_Line x_return_status',x_return_status);
3114: END IF;
3115: --HW OPMCONV - Removed code forking
3116:
3117: IF x_return_status = fnd_api.g_ret_sts_success THEN
3118: --
3119: -- Debug Statements
3120: --
3121: IF l_debug_on THEN

Line 3157: x_return_status := FND_API.G_RET_STS_ERROR;

3153: l_error_text := l_error_text || l_msg_data;
3154: END LOOP;
3155: FND_MESSAGE.Set_Token('ERROR_TEXT',l_error_text);
3156: END IF;
3157: x_return_status := FND_API.G_RET_STS_ERROR;
3158: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3159: --
3160: -- Debug Statements
3161: --

Line 3196: IF x_return_status = fnd_api.g_ret_sts_success THEN

3192: IF l_debug_on THEN
3193: WSH_DEBUG_SV.log(l_module_name,'WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION',x_return_status);
3194: END IF;
3195:
3196: IF x_return_status = fnd_api.g_ret_sts_success THEN
3197: --
3198: -- Debug Statements
3199: --
3200: IF l_debug_on THEN

Line 3212: x_return_status := FND_API.G_RET_STS_ERROR;

3208: IF l_debug_on THEN
3209: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION ' );
3210: END IF;
3211: --
3212: x_return_status := FND_API.G_RET_STS_ERROR;
3213: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3214: --
3215: -- Debug Statements
3216: --

Line 3261: x_return_status := FND_API.G_RET_STS_ERROR;

3257: --
3258: FND_MESSAGE.SET_NAME('WSH','WSH_STAGED_SERIAL_EXISTS');
3259: FND_MESSAGE.SET_TOKEN('SERIAL_QUANTITY',l_serial_quantity);
3260: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID',p_delivery_detail_id);
3261: x_return_status := FND_API.G_RET_STS_ERROR;
3262: return;
3263:
3264: ELSIF (p_serial_number IS NOT NULL ) AND (p_requested_quantity - ABS(p_changed_detail_quantity) <= 0) THEN
3265: l_serial_quantity := 1;

Line 3277: x_return_status := FND_API.G_RET_STS_ERROR;

3273: --
3274: FND_MESSAGE.SET_NAME('WSH','WSH_STAGED_SERIAL_EXISTS');
3275: FND_MESSAGE.SET_TOKEN('SERIAL_QUANTITY',l_serial_quantity);
3276: FND_MESSAGE.SET_TOKEN('DELIVERY_DETAIL_ID',p_delivery_detail_id);
3277: x_return_status := FND_API.G_RET_STS_ERROR;
3278: return;
3279: END IF;
3280:
3281: ELSIF p_ordered_quantity = 0 AND (p_transaction_temp_id IS NOT NULL OR p_serial_number IS NOT NULL ) THEN

Line 3296: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3292: x_return_status => x_return_status);
3293: IF l_debug_on THEN
3294: WSH_DEBUG_SV.log(l_module_name,'Update_Serial_Numbers x_return_status',x_return_status);
3295: END IF;
3296: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3297: x_return_status := FND_API.G_RET_STS_ERROR;
3298: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3299: --
3300: -- Debug Statements

Line 3297: x_return_status := FND_API.G_RET_STS_ERROR;

3293: IF l_debug_on THEN
3294: WSH_DEBUG_SV.log(l_module_name,'Update_Serial_Numbers x_return_status',x_return_status);
3295: END IF;
3296: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3297: x_return_status := FND_API.G_RET_STS_ERROR;
3298: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
3299: --
3300: -- Debug Statements
3301: --

Line 3355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3351: WHEN others THEN
3352: IF c_check_del_assign%ISOPEN THEN
3353: CLOSE c_check_del_assign;
3354: END IF;
3355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3356: --
3357: -- Debug Statements
3358: --
3359: IF l_debug_on THEN