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 2313: l_inv_controls WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

2309: l_item_id NUMBER;
2310: l_pickable_flag VARCHAR2(1);
2311: l_subinventory VARCHAR2(30);
2312: l_line_direction VARCHAR2(30);
2313: l_inv_controls WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
2314:
2315: -- BUG FIX 2887330
2316: l_inventory_item_id NUMBER;
2317: l_reservable_flag VARCHAR2(1);

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

2414: -- J-IB-NPARIKH-}
2415: --
2416:
2417: IF l_debug_on THEN
2418: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_RESERVABLE_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
2419: END IF;
2420:
2421: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(
2422: x_item_id => l_inventory_item_id,

Line 2421: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(

2417: IF l_debug_on THEN
2418: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.GET_RESERVABLE_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
2419: END IF;
2420:
2421: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(
2422: x_item_id => l_inventory_item_id,
2423: x_organization_id => l_organization_id,
2424: x_pickable_flag => l_pickable_flag);
2425: if l_debug_on then

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

2701: i := x_disabled_list.COUNT;
2702:
2703: IF (l_released_status = 'Y') THEN
2704:
2705: IF (WSH_DELIVERY_DETAILS_INV.get_reservable_flag(x_item_id => l_item_id,
2706: x_organization_id => l_organization_id,
2707: x_pickable_flag => l_pickable_flag) = 'Y')
2708: THEN
2709:

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

2724: G_SUBINVENTORY := NULL;
2725: END IF;
2726:
2727:
2728: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(p_delivery_detail_id => p_delivery_detail_id,
2729: p_inventory_item_id => l_item_id,
2730: p_organization_id => l_organization_id,
2731: p_subinventory => l_subinventory,
2732: x_inv_controls_rec => l_inv_controls,

Line 5205: l_inv_controls WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;

5201: l_status_code VARCHAR2(3);
5202: l_released_status VARCHAR2(1);
5203: l_lpn_id NUMBER;
5204: l_all_disabled VARCHAR2(1):='N';
5205: l_inv_controls WSH_DELIVERY_DETAILS_INV.inv_control_flag_rec;
5206: l_inventory_item_id NUMBER;
5207: l_organization_id NUMBER;
5208: l_pickable_flag VARCHAR2(1);
5209: l_subinventory VARCHAR2(30);

Line 5628: WSH_DELIVERY_DETAILS_INV.get_reservable_flag (

5624: l_disabled_list(i) = 'LOCATOR_NAME' and
5625: l_db_col_rec.locator_id is not null and
5626: --Modified for bug 4560576, 4701803
5627: l_db_col_rec.released_status = 'Y' and
5628: WSH_DELIVERY_DETAILS_INV.get_reservable_flag (
5629: x_item_id => l_inventory_item_id,
5630: x_organization_id => l_organization_id,
5631: x_pickable_flag => l_pickable_flag ) = 'N' )
5632: THEN

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

5764: -- Subinventory should be updateable during inbound processing
5765: j:=j+1; l_disabled_list(j) := 'FULL';
5766: j:=j+1; l_disabled_list(j) := 'SUBINVENTORY';
5767: --Bugfix 6939348 start
5768: WSH_DELIVERY_DETAILS_INV.Fetch_Inv_Controls(p_delivery_detail_id => x_delivery_detail_rec.delivery_detail_id,
5769: p_inventory_item_id => x_delivery_detail_rec.inventory_item_id,
5770: p_organization_id => x_delivery_detail_rec.organization_id,
5771: p_subinventory => x_delivery_detail_rec.subinventory,
5772: x_inv_controls_rec => l_inv_controls,

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

6431:
6432: IF x_det_rec.serial_quantity > 0 AND x_det_rec.unmark_serial_server = 'Y' THEN
6433:
6434: IF l_debug_on THEN
6435: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
6436: END IF;
6437: wsh_delivery_details_inv.unmark_serial_number(
6438: p_delivery_detail_id => x_det_rec.delivery_detail_id,
6439: p_serial_number_code => x_det_rec.inv_ser_control_code,

Line 6437: wsh_delivery_details_inv.unmark_serial_number(

6433:
6434: IF l_debug_on THEN
6435: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
6436: END IF;
6437: wsh_delivery_details_inv.unmark_serial_number(
6438: p_delivery_detail_id => x_det_rec.delivery_detail_id,
6439: p_serial_number_code => x_det_rec.inv_ser_control_code,
6440: p_serial_number => x_det_rec.serial_number,
6441: p_transaction_temp_id => x_det_rec.transaction_temp_id,

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

6473: wsh_util_core.add_message(wsh_util_core.g_ret_sts_warning);
6474: l_number_of_warnings := l_number_of_warnings + 1;
6475:
6476: IF l_debug_on THEN
6477: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
6478: END IF;
6479:
6480: IF x_det_rec.unmark_serial_server = 'Y' THEN
6481: wsh_delivery_details_inv.unmark_serial_number(

Line 6481: wsh_delivery_details_inv.unmark_serial_number(

6477: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
6478: END IF;
6479:
6480: IF x_det_rec.unmark_serial_server = 'Y' THEN
6481: wsh_delivery_details_inv.unmark_serial_number(
6482: p_delivery_detail_id => x_det_rec.delivery_detail_id,
6483: p_serial_number_code => x_det_rec.inv_ser_control_code,
6484: p_serial_number => x_det_rec.serial_number,
6485: p_transaction_temp_id => x_det_rec.transaction_temp_id,

Line 7014: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

7010: l_msg_data VARCHAR2(32767);
7011: l_return_status VARCHAR2(32767);
7012: --
7013: -- HW OPMCONV - New variables
7014: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
7015: INVALID_LOT EXCEPTION;
7016: e_end_of_api EXCEPTION;
7017: --}
7018: BEGIN

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

7106: -- HW OPMCONV - No need to call OPM APIS
7107:
7108: -- HW OPMCONV - Call API to get item info
7109: IF l_debug_on THEN
7110: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Get_item_information',WSH_DEBUG_SV.C_PROC_LEVEL);
7111: END IF;
7112:
7113: WSH_DELIVERY_DETAILS_INV.Get_item_information
7114: (

Line 7113: WSH_DELIVERY_DETAILS_INV.Get_item_information

7109: IF l_debug_on THEN
7110: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.Get_item_information',WSH_DEBUG_SV.C_PROC_LEVEL);
7111: END IF;
7112:
7113: WSH_DELIVERY_DETAILS_INV.Get_item_information
7114: (
7115: p_organization_id => l_line_rec.organization_id
7116: , p_inventory_item_id => l_line_rec.inventory_item_id
7117: , x_mtl_system_items_rec => l_item_info

Line 8681: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

8677: p_released_status IN VARCHAR2)
8678: RETURN BOOLEAN
8679: IS
8680:
8681: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
8682: l_released_status VARCHAR2(1);
8683: l_debug_on BOOLEAN;
8684: l_return_status VARCHAR2(1);
8685: l_number_of_errors NUMBER ;

Line 8722: WSH_DELIVERY_DETAILS_INV.Get_item_information

8718: wsh_debug_sv.LOG(l_module_name, 'p_inventory_item_id', p_inventory_item_id);
8719: END IF;
8720: --
8721:
8722: WSH_DELIVERY_DETAILS_INV.Get_item_information
8723: (
8724: p_organization_id => p_organization_id,
8725: p_inventory_item_id => p_inventory_item_id,
8726: x_mtl_system_items_rec => l_item_info,

Line 8816: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;

8812: p_cycle_qty IN NUMBER)
8813: RETURN BOOLEAN
8814: IS
8815:
8816: l_item_info WSH_DELIVERY_DETAILS_INV.mtl_system_items_rec;
8817: l_released_status VARCHAR2(1);
8818: l_debug_on BOOLEAN;
8819: l_return_status VARCHAR2(1);
8820: l_number_of_errors NUMBER ;

Line 8850: WSH_DELIVERY_DETAILS_INV.Get_item_information

8846: wsh_debug_sv.LOG(l_module_name, 'p_inventory_item_id', p_inventory_item_id);
8847: END IF;
8848: --
8849:
8850: WSH_DELIVERY_DETAILS_INV.Get_item_information
8851: (
8852: p_organization_id => p_organization_id,
8853: p_inventory_item_id => p_inventory_item_id,
8854: x_mtl_system_items_rec => l_item_info,