DBA Data[Home] [Help]

APPS.WSH_PO_CMG_PVT dependencies on WSH_INBOUND_UTIL_PKG

Line 436: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.GET_PO_RCV_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);

432: --
433: -- Debug Statements
434: --
435: IF l_debug_on THEN
436: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.GET_PO_RCV_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
437: END IF;
438: --
439: -- Deriving the p_line_rec information.
440: WSH_INBOUND_UTIL_PKG.get_po_rcv_attributes(

Line 440: WSH_INBOUND_UTIL_PKG.get_po_rcv_attributes(

436: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.GET_PO_RCV_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
437: END IF;
438: --
439: -- Deriving the p_line_rec information.
440: WSH_INBOUND_UTIL_PKG.get_po_rcv_attributes(
441: p_po_line_location_id => p_dd_list.po_shipment_line_id(i),
442: p_rcv_shipment_line_id => l_rcv_shipment_line_id,
443: x_line_rec => p_line_rec,
444: x_return_status => l_return_status);

Line 899: l_rr_status:=WSH_INBOUND_UTIL_PKG.Is_Routing_Response_Send(V_dd_attr.delivery_detail_id,l_req_res_id);

895: IF (p_line_rec.ship_to_location_id(p_line_rec_index) IS NOT NULL AND
896: p_line_rec.ship_to_location_id(p_line_rec_index) <> v_dd_attr.ship_to_location_id) THEN
897:
898: IF (l_check_routing_res IS NULL) THEN
899: l_rr_status:=WSH_INBOUND_UTIL_PKG.Is_Routing_Response_Send(V_dd_attr.delivery_detail_id,l_req_res_id);
900: l_check_routing_res:='Y';
901: END IF;
902:
903: IF (l_rr_status) THEN

Line 1200: l_rr_status:=WSH_INBOUND_UTIL_PKG.Is_Routing_Response_Send(V_dd_attr.delivery_detail_id,l_req_res_id);

1196: IF (p_line_rec.request_date(p_line_rec_index) IS NOT NULL AND
1197: p_line_rec.request_date(p_line_rec_index) <> v_dd_attr.date_requested) THEN
1198:
1199: IF (l_check_routing_res IS NULL) THEN
1200: l_rr_status:=WSH_INBOUND_UTIL_PKG.Is_Routing_Response_Send(V_dd_attr.delivery_detail_id,l_req_res_id);
1201: l_check_routing_res:='Y';
1202: END IF;
1203:
1204: IF (l_rr_status) THEN

Line 2113: -- call the WSH_INBOUND_UTIL_PKG.convert_quantity API to find the actual qty

2109: p_line_rec.order_quantity_uom(i) <> l_src_qty_uom) THEN
2110: --HACMS {
2111: IF (l_inventory_item_id IS NOT NULL) THEN
2112: -- If qyt is different from src qty or uom is different from src_uom ,then
2113: -- call the WSH_INBOUND_UTIL_PKG.convert_quantity API to find the actual qty
2114: -- that needs to be chagned in ordered uom.
2115: -- This is done only if inventory item id is not null.
2116: IF l_debug_on THEN
2117: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.convert_quantity',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2117: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.convert_quantity',WSH_DEBUG_SV.C_PROC_LEVEL);

2113: -- call the WSH_INBOUND_UTIL_PKG.convert_quantity API to find the actual qty
2114: -- that needs to be chagned in ordered uom.
2115: -- This is done only if inventory item id is not null.
2116: IF l_debug_on THEN
2117: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.convert_quantity',WSH_DEBUG_SV.C_PROC_LEVEL);
2118: END IF;
2119:
2120: WSH_INBOUND_UTIL_PKG.convert_quantity(
2121: p_inv_item_id => p_line_rec.inventory_item_id(i),

Line 2120: WSH_INBOUND_UTIL_PKG.convert_quantity(

2116: IF l_debug_on THEN
2117: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.convert_quantity',WSH_DEBUG_SV.C_PROC_LEVEL);
2118: END IF;
2119:
2120: WSH_INBOUND_UTIL_PKG.convert_quantity(
2121: p_inv_item_id => p_line_rec.inventory_item_id(i),
2122: p_organization_id => p_line_rec.organization_id(i),
2123: p_primary_uom_code => p_line_rec.order_quantity_uom(i),
2124: p_quantity => l_src_qty,

Line 2144: -- Call WSH_INBOUND_UTIL_PKG.convert_quantity to convert the ordered qty to base uom .

2140: l_qty_to_change_ord_uom := abs(p_line_rec.ordered_quantity(i) - l_src_qty_to_change);
2141: IF l_debug_on THEN
2142: WSH_DEBUG_SV.log(l_module_name,'l_qty_to_change_ord_uom',l_qty_to_change_ord_uom);
2143: END IF;
2144: -- Call WSH_INBOUND_UTIL_PKG.convert_quantity to convert the ordered qty to base uom .
2145:
2146: IF l_debug_on THEN
2147: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.convert_quantity',WSH_DEBUG_SV.C_PROC_LEVEL);
2148: END IF;

Line 2147: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.convert_quantity',WSH_DEBUG_SV.C_PROC_LEVEL);

2143: END IF;
2144: -- Call WSH_INBOUND_UTIL_PKG.convert_quantity to convert the ordered qty to base uom .
2145:
2146: IF l_debug_on THEN
2147: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.convert_quantity',WSH_DEBUG_SV.C_PROC_LEVEL);
2148: END IF;
2149: WSH_INBOUND_UTIL_PKG.convert_quantity(
2150: p_inv_item_id => p_line_rec.inventory_item_id(i),
2151: p_organization_id => p_line_rec.organization_id(i),

Line 2149: WSH_INBOUND_UTIL_PKG.convert_quantity(

2145:
2146: IF l_debug_on THEN
2147: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.convert_quantity',WSH_DEBUG_SV.C_PROC_LEVEL);
2148: END IF;
2149: WSH_INBOUND_UTIL_PKG.convert_quantity(
2150: p_inv_item_id => p_line_rec.inventory_item_id(i),
2151: p_organization_id => p_line_rec.organization_id(i),
2152: p_primary_uom_code => l_requested_quantity_uom,
2153: p_quantity => l_qty_to_change_ord_uom,

Line 2178: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.convert_quantity',WSH_DEBUG_SV.C_PROC_LEVEL);

2174:
2175: ELSE
2176: --One time item i.e if inventory_item_id is null
2177: IF l_debug_on THEN
2178: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.convert_quantity',WSH_DEBUG_SV.C_PROC_LEVEL);
2179: END IF;
2180:
2181: WSH_INBOUND_UTIL_PKG.convert_quantity(
2182: p_inv_item_id => p_line_rec.inventory_item_id(i),

Line 2181: WSH_INBOUND_UTIL_PKG.convert_quantity(

2177: IF l_debug_on THEN
2178: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.convert_quantity',WSH_DEBUG_SV.C_PROC_LEVEL);
2179: END IF;
2180:
2181: WSH_INBOUND_UTIL_PKG.convert_quantity(
2182: p_inv_item_id => p_line_rec.inventory_item_id(i),
2183: p_organization_id => p_line_rec.organization_id(i),
2184: p_primary_uom_code => p_line_rec.order_quantity_uom(i),
2185: p_quantity => l_src_qty,

Line 2265: WSH_INBOUND_UTIL_PKG.convert_quantity(

2261: v_lines_without_rr.qty_uom <> p_line_rec.order_quantity_uom(i)) THEN
2262:
2263: l_new_req_qty_uom := p_line_rec.order_quantity_uom(i);
2264:
2265: WSH_INBOUND_UTIL_PKG.convert_quantity(
2266: p_inv_item_id => p_line_rec.inventory_item_id(i),
2267: p_organization_id => p_line_rec.organization_id(i),
2268: p_primary_uom_code => p_line_rec.order_quantity_uom(i),
2269: p_quantity => v_lines_without_rr.qty,

Line 2445: WSH_INBOUND_UTIL_PKG.convert_quantity(

2441: v_lines_with_rr.qty_uom <> p_line_rec.order_quantity_uom(i)) THEN
2442:
2443: l_new_req_qty_uom := p_line_rec.order_quantity_uom(i);
2444:
2445: WSH_INBOUND_UTIL_PKG.convert_quantity(
2446: p_inv_item_id => p_line_rec.inventory_item_id(i),
2447: p_organization_id => p_line_rec.organization_id(i),
2448: p_primary_uom_code => p_line_rec.order_quantity_uom(i),
2449: p_quantity => v_lines_with_rr.qty,

Line 2553: IF (WSH_INBOUND_UTIL_PKG.Is_Routing_Response_Send( v_lines_with_rr.delivery_detail_id,l_req_res_id) ) THEN

2549: IF l_sf_differs = '1' THEN
2550: -- if delivery details have different ship from location and routing response is send against
2551: -- these delivery details, then log exception against the delivery detail.
2552:
2553: IF (WSH_INBOUND_UTIL_PKG.Is_Routing_Response_Send( v_lines_with_rr.delivery_detail_id,l_req_res_id) ) THEN
2554:
2555: FND_MESSAGE.SET_NAME('WSH','WSH_IB_ST_LOC_CHANGE');
2556: FND_MESSAGE.SET_TOKEN('DETAIL', v_lines_with_rr.delivery_detail_id);
2557: FND_MESSAGE.SET_TOKEN('OLD_VALUE', v_lines_with_rr.ship_from_location_id);

Line 2611: WSH_INBOUND_UTIL_PKG.convert_quantity(

2607:
2608: IF (v_lines_with_rr.inventory_item_id IS NULL) THEN
2609: -- for one time items
2610:
2611: WSH_INBOUND_UTIL_PKG.convert_quantity(
2612: p_inv_item_id => NULL,
2613: p_organization_id => p_line_rec.organization_id(i),
2614: p_primary_uom_code => p_line_rec.requested_quantity_uom(i),
2615: p_quantity => v_lines_with_rr.pick_qty,

Line 2706: IF (WSH_INBOUND_UTIL_PKG.Is_Routing_Response_Send( v_lines_with_rr.delivery_detail_id,l_req_res_id)) THEN

2702:
2703: -- Bug 3395410 : Exception needs to be logged if the qty is decreased and the associated delivery is
2704: -- Contents Firm.Checking for the planned_flag for the same.
2705:
2706: IF (WSH_INBOUND_UTIL_PKG.Is_Routing_Response_Send( v_lines_with_rr.delivery_detail_id,l_req_res_id)) THEN
2707: l_routing_response_send := 'Y';
2708: ELSE
2709: l_routing_response_send := 'N';
2710: END IF;

Line 2868: WSH_INBOUND_UTIL_PKG.convert_quantity(

2864: l_requested_quantity_uom<> p_line_rec.order_quantity_uom(i)) THEN
2865:
2866: l_new_req_qty_uom := p_line_rec.order_quantity_uom(i);
2867:
2868: WSH_INBOUND_UTIL_PKG.convert_quantity(
2869: p_inv_item_id => p_line_rec.inventory_item_id(i),
2870: p_organization_id => p_line_rec.organization_id(i),
2871: p_primary_uom_code => p_line_rec.order_quantity_uom(i),
2872: p_quantity => l_requested_qty,

Line 3114: WSH_INBOUND_UTIL_PKG.convert_quantity(

3110: FOR v_lines IN c_lines_all(p_line_rec.po_shipment_line_id(i),p_line_rec.header_id(i),p_line_rec.line_id(i) )
3111: LOOP
3112:
3113: IF ( v_lines.qty_uom <> p_line_rec.requested_quantity_uom(i)) THEN --{
3114: WSH_INBOUND_UTIL_PKG.convert_quantity(
3115: p_inv_item_id => NULL,
3116: p_organization_id => p_line_rec.organization_id(i),
3117: p_primary_uom_code => p_line_rec.requested_quantity_uom(i),
3118: p_quantity => v_lines.qty,

Line 3134: WSH_INBOUND_UTIL_PKG.convert_quantity(

3130: x_num_errors => l_num_errors);
3131:
3132:
3133: IF (v_lines.pick_qty IS NOT NULL or v_lines.pick_qty <> 0) THEN
3134: WSH_INBOUND_UTIL_PKG.convert_quantity(
3135: p_inv_item_id => NULL,
3136: p_organization_id => p_line_rec.organization_id(i),
3137: p_primary_uom_code => p_line_rec.requested_quantity_uom(i),
3138: p_quantity => v_lines.pick_qty,