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_DETAILS_VALIDATIONS dependencies on WSH_DELIVERY_DETAILS_INV

Line 2423: l_inv_controls WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

2419: l_item_id NUMBER;
2420: l_pickable_flag VARCHAR2(1);
2421: l_subinventory VARCHAR2(30);
2422: l_line_direction VARCHAR2(30);
2423: l_inv_controls WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
2424: -- BUG FIX 2887330
2425: l_inventory_item_id NUMBER;
2426: l_reservable_flag VARCHAR2(1);
2427: l_source_code VARCHAR2(30);

Line 2527: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_RESERVABLE_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);

2523: -- J-IB-NPARIKH-}
2524: --
2525:
2526: IF l_debug_on THEN
2527: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_RESERVABLE_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
2528: END IF;
2529:
2530: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(
2531: x_item_id => l_inventory_item_id,

Line 2530: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(

2526: IF l_debug_on THEN
2527: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_RESERVABLE_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
2528: END IF;
2529:
2530: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(
2531: x_item_id => l_inventory_item_id,
2532: x_organization_id => l_organization_id,
2533: x_pickable_flag => l_pickable_flag);
2534: if l_debug_on then

Line 2822: IF (WSH_DELIVERY_DETAILS_INV.get_reservable_flag(x_item_id => l_item_id,

2818: i := x_disabled_list.COUNT;
2819:
2820: IF (l_released_status = 'Y') THEN
2821:
2822: IF (WSH_DELIVERY_DETAILS_INV.get_reservable_flag(x_item_id => l_item_id,
2823: x_organization_id => l_organization_id,
2824: x_pickable_flag => l_pickable_flag) = 'Y')
2825: THEN
2826:

Line 2845: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(p_delivery_detail_id => p_delivery_detail_id,

2841: G_SUBINVENTORY := NULL;
2842: END IF;
2843:
2844:
2845: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(p_delivery_detail_id => p_delivery_detail_id,
2846: p_inventory_item_id => l_item_id,
2847: p_organization_id => l_organization_id,
2848: p_subinventory => l_subinventory,
2849: x_inv_controls_rec => l_inv_controls,

Line 5392: l_inv_controls WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

5388: l_status_code VARCHAR2(3);
5389: l_released_status VARCHAR2(1);
5390: l_lpn_id NUMBER;
5391: l_all_disabled VARCHAR2(1):='N';
5392: l_inv_controls WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
5393: l_inventory_item_id NUMBER;
5394: l_organization_id NUMBER;
5395: l_pickable_flag VARCHAR2(1);
5396: l_subinventory VARCHAR2(30);

Line 5832: WSH_DELIVERY_DETAILS_INV.get_reservable_flag (

5828: l_disabled_list(i) = 'LOCATOR_NAME' and
5829: l_db_col_rec.locator_id is not null and
5830: --Modified for bug 4560576, 4701803
5831: l_db_col_rec.released_status = 'Y' and
5832: WSH_DELIVERY_DETAILS_INV.get_reservable_flag (
5833: x_item_id => l_inventory_item_id,
5834: x_organization_id => l_organization_id,
5835: x_pickable_flag => l_pickable_flag ) = 'N' )
5836: THEN

Line 5985: WSH_DEBUG_SV.log(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls',WSH_DEBUG_SV.C_PROC_LEVEL);

5981: j:=j+1; l_disabled_list(j) := 'FULL';
5982: j:=j+1; l_disabled_list(j) := 'SUBINVENTORY';
5983: --Bugfix 6939348 start
5984: IF l_debug_on THEN
5985: WSH_DEBUG_SV.log(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls',WSH_DEBUG_SV.C_PROC_LEVEL);
5986: END IF;
5987:
5988: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(p_delivery_detail_id => x_delivery_detail_rec.delivery_detail_id,
5989: p_inventory_item_id => x_delivery_detail_rec.inventory_item_id,

Line 5988: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(p_delivery_detail_id => x_delivery_detail_rec.delivery_detail_id,

5984: IF l_debug_on THEN
5985: WSH_DEBUG_SV.log(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls',WSH_DEBUG_SV.C_PROC_LEVEL);
5986: END IF;
5987:
5988: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(p_delivery_detail_id => x_delivery_detail_rec.delivery_detail_id,
5989: p_inventory_item_id => x_delivery_detail_rec.inventory_item_id,
5990: p_organization_id => x_delivery_detail_rec.organization_id,
5991: p_subinventory => nvl(x_delivery_detail_rec.subinventory,p_delivery_detail_rec.subinventory), -- bug 8303281
5992: x_inv_controls_rec => l_inv_controls,

Line 6707: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);

6703:
6704: IF x_det_rec.serial_quantity > 0 AND x_det_rec.unmark_serial_server = 'Y' THEN
6705:
6706: IF l_debug_on THEN
6707: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
6708: END IF;
6709: wsh_delivery_details_inv.unmark_serial_number(
6710: p_delivery_detail_id => x_det_rec.delivery_detail_id,
6711: p_serial_number_code => x_det_rec.inv_ser_control_code,

Line 6709: wsh_delivery_details_inv.unmark_serial_number(

6705:
6706: IF l_debug_on THEN
6707: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
6708: END IF;
6709: wsh_delivery_details_inv.unmark_serial_number(
6710: p_delivery_detail_id => x_det_rec.delivery_detail_id,
6711: p_serial_number_code => x_det_rec.inv_ser_control_code,
6712: p_serial_number => x_det_rec.serial_number,
6713: p_transaction_temp_id => x_det_rec.transaction_temp_id,

Line 6749: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);

6745: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning);
6746: l_number_of_warnings := l_number_of_warnings + 1;
6747:
6748: IF l_debug_on THEN
6749: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
6750: END IF;
6751:
6752: IF x_det_rec.unmark_serial_server = 'Y' THEN
6753: wsh_delivery_details_inv.unmark_serial_number(

Line 6753: wsh_delivery_details_inv.unmark_serial_number(

6749: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
6750: END IF;
6751:
6752: IF x_det_rec.unmark_serial_server = 'Y' THEN
6753: wsh_delivery_details_inv.unmark_serial_number(
6754: p_delivery_detail_id => x_det_rec.delivery_detail_id,
6755: p_serial_number_code => x_det_rec.inv_ser_control_code,
6756: p_serial_number => x_det_rec.serial_number,
6757: p_transaction_temp_id => x_det_rec.transaction_temp_id,

Line 7304: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

7300: l_msg_data VARCHAR2(32767);
7301: l_return_status VARCHAR2(32767);
7302: --
7303: -- HW OPMCONV - New variables
7304: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
7305: INVALID_LOT EXCEPTION;
7306: e_end_of_api EXCEPTION;
7307: --}
7308: BEGIN

Line 7400: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Get_item_information',WSH_DEBUG_SV.C_PROC_LEVEL);

7396: -- HW OPMCONV - No need to call OPM APIS
7397:
7398: -- HW OPMCONV - Call API to get item info
7399: IF l_debug_on THEN
7400: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Get_item_information',WSH_DEBUG_SV.C_PROC_LEVEL);
7401: END IF;
7402:
7403: WSH_DELIVERY_DETAILS_INV.Get_item_information
7404: (

Line 7403: WSH_DELIVERY_DETAILS_INV.Get_item_information

7399: IF l_debug_on THEN
7400: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Get_item_information',WSH_DEBUG_SV.C_PROC_LEVEL);
7401: END IF;
7402:
7403: WSH_DELIVERY_DETAILS_INV.Get_item_information
7404: (
7405: p_organization_id => l_line_rec.organization_id
7406: , p_inventory_item_id => l_line_rec.inventory_item_id
7407: , x_mtl_system_items_rec => l_item_info

Line 8971: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

8967: p_released_status IN VARCHAR2)
8968: RETURN BOOLEAN
8969: IS
8970:
8971: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
8972: l_released_status VARCHAR2(1);
8973: l_debug_on BOOLEAN;
8974: l_return_status VARCHAR2(1);
8975: l_number_of_errors NUMBER ;

Line 9019: WSH_DELIVERY_DETAILS_INV.Get_item_information

9015: wsh_debug_sv.LOG(l_module_name, 'p_inventory_item_id', p_inventory_item_id);
9016: END IF;
9017: --
9018:
9019: WSH_DELIVERY_DETAILS_INV.Get_item_information
9020: (
9021: p_organization_id => p_organization_id,
9022: p_inventory_item_id => p_inventory_item_id,
9023: x_mtl_system_items_rec => l_item_info,

Line 9121: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

9117: p_cycle_qty IN NUMBER)
9118: RETURN BOOLEAN
9119: IS
9120:
9121: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
9122: l_released_status VARCHAR2(1);
9123: l_debug_on BOOLEAN;
9124: l_return_status VARCHAR2(1);
9125: l_number_of_errors NUMBER ;

Line 9155: WSH_DELIVERY_DETAILS_INV.Get_item_information

9151: wsh_debug_sv.LOG(l_module_name, 'p_inventory_item_id', p_inventory_item_id);
9152: END IF;
9153: --
9154:
9155: WSH_DELIVERY_DETAILS_INV.Get_item_information
9156: (
9157: p_organization_id => p_organization_id,
9158: p_inventory_item_id => p_inventory_item_id,
9159: x_mtl_system_items_rec => l_item_info,