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

Line 7451: l_inv_controls wsh_delivery_details_inv.inv_control_flag_rec;

7447: -- HW OPMCONV - Increased length to 80
7448: l_lot VARCHAR2(80);
7449: l_result BOOLEAN;
7450: l_quantity NUMBER;
7451: l_inv_controls wsh_delivery_details_inv.inv_control_flag_rec;
7452: l_ship_method_name VARCHAR2(32767);
7453: -- HW Harmonization project for OPM. Added l_process flag variable
7454: -- HW OPMCONV - Removed OPM variables
7455:

Line 7619: WSH_DELIVERY_DETAILS_INV.get_trx_type_id(

7615:
7616: l_org_id := p_original_rec.organization_id;
7617:
7618: /***************Material Status Impact***********/
7619: WSH_DELIVERY_DETAILS_INV.get_trx_type_id(
7620: p_source_line_id => p_in_detail_rec.source_line_id,
7621: p_source_code => p_in_detail_rec.source_code,
7622: x_transaction_type_id => l_trx_type_id,
7623: x_return_status => l_return_status);

Line 7674: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS', WSH_DEBUG_SV.c_proc_level);

7670: OR p_validation_tab(wsh_actions_levels.c_serial_num_lvl) = 1
7671: THEN
7672: --(
7673: IF l_debug_on THEN
7674: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS', WSH_DEBUG_SV.c_proc_level);
7675: END IF;
7676:
7677: wsh_delivery_details_inv.fetch_inv_controls(
7678: p_delivery_detail_id => x_detail_rec.delivery_detail_id,

Line 7677: wsh_delivery_details_inv.fetch_inv_controls(

7673: IF l_debug_on THEN
7674: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS', WSH_DEBUG_SV.c_proc_level);
7675: END IF;
7676:
7677: wsh_delivery_details_inv.fetch_inv_controls(
7678: p_delivery_detail_id => x_detail_rec.delivery_detail_id,
7679: p_inventory_item_id => p_original_rec.inventory_item_id,
7680: p_organization_id => l_org_id,
7681: p_subinventory => l_subinventory,

Line 8034: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SUBINVENTORY', WSH_DEBUG_SV.c_proc_level);

8030: IF (p_validation_tab(wsh_actions_levels.c_sub_inv_lvl) = 1) THEN
8031: IF (x_detail_rec.subinventory <> fnd_api.g_miss_char) THEN
8032: IF l_debug_on THEN
8033: WSH_DEBUG_SV.log(l_module_name, 'Subinventory', x_detail_rec.subinventory);
8034: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SUBINVENTORY', WSH_DEBUG_SV.c_proc_level);
8035: END IF;
8036:
8037: --
8038: wsh_delivery_details_inv.validate_subinventory(

Line 8038: wsh_delivery_details_inv.validate_subinventory(

8034: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SUBINVENTORY', WSH_DEBUG_SV.c_proc_level);
8035: END IF;
8036:
8037: --
8038: wsh_delivery_details_inv.validate_subinventory(
8039: p_subinventory => x_detail_rec.subinventory,
8040: p_organization_id => l_org_id,
8041: p_inventory_item_id => p_original_rec.inventory_item_id,
8042: p_transaction_type_id => l_trx_type_id,

Line 8095: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_REVISION', WSH_DEBUG_SV.c_proc_level);

8091: END IF;
8092: ELSE
8093: IF l_debug_on THEN
8094: WSH_DEBUG_SV.log(l_module_name, 'Revision', x_detail_rec.revision);
8095: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_REVISION', WSH_DEBUG_SV.c_proc_level);
8096: END IF;
8097:
8098: wsh_delivery_details_inv.validate_revision(
8099: p_revision => x_detail_rec.revision,

Line 8098: wsh_delivery_details_inv.validate_revision(

8094: WSH_DEBUG_SV.log(l_module_name, 'Revision', x_detail_rec.revision);
8095: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_REVISION', WSH_DEBUG_SV.c_proc_level);
8096: END IF;
8097:
8098: wsh_delivery_details_inv.validate_revision(
8099: p_revision => x_detail_rec.revision,
8100: p_organization_id => l_org_id,
8101: p_inventory_item_id => p_original_rec.inventory_item_id,
8102: x_return_status => l_return_status,

Line 8156: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_LOCATOR', WSH_DEBUG_SV.c_proc_level);

8152: ELSE
8153:
8154: IF l_debug_on THEN
8155: WSH_DEBUG_SV.log(l_module_name, 'Locator Id', x_detail_rec.locator_id);
8156: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_LOCATOR', WSH_DEBUG_SV.c_proc_level);
8157: END IF;
8158: wsh_delivery_details_inv.validate_locator(
8159: p_locator_id => x_detail_rec.locator_id,
8160: p_organization_id => l_org_id,

Line 8158: wsh_delivery_details_inv.validate_locator(

8154: IF l_debug_on THEN
8155: WSH_DEBUG_SV.log(l_module_name, 'Locator Id', x_detail_rec.locator_id);
8156: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_LOCATOR', WSH_DEBUG_SV.c_proc_level);
8157: END IF;
8158: wsh_delivery_details_inv.validate_locator(
8159: p_locator_id => x_detail_rec.locator_id,
8160: p_organization_id => l_org_id,
8161: p_inventory_item_id => p_original_rec.inventory_item_id,
8162: p_subinventory => l_subinventory,

Line 8221: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(

8217: END IF;
8218: ELSE
8219: -- bug 4766908 get the reservable_flag
8220: IF p_original_rec.released_status = 'Y' THEN
8221: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(
8222: x_item_id => p_original_rec.inventory_item_id,
8223: x_organization_id => p_original_rec.organization_id,
8224: x_pickable_flag => p_original_rec.pickable_flag);
8225: END IF;

Line 8228: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_LOT_NUMBER', WSH_DEBUG_SV.c_proc_level);

8224: x_pickable_flag => p_original_rec.pickable_flag);
8225: END IF;
8226: IF (nvl(l_reservable_flag, 'Y') = 'Y') THEN
8227: IF l_debug_on THEN
8228: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_LOT_NUMBER', WSH_DEBUG_SV.c_proc_level);
8229: END IF;
8230:
8231: wsh_delivery_details_inv.validate_lot_number(
8232: p_lot_number => x_detail_rec.lot_number,

Line 8231: wsh_delivery_details_inv.validate_lot_number(

8227: IF l_debug_on THEN
8228: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_LOT_NUMBER', WSH_DEBUG_SV.c_proc_level);
8229: END IF;
8230:
8231: wsh_delivery_details_inv.validate_lot_number(
8232: p_lot_number => x_detail_rec.lot_number,
8233: p_organization_id => l_org_id,
8234: p_inventory_item_id => p_original_rec.inventory_item_id,
8235: p_revision => l_revision,

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

8708: -- x_detail_rec.serial_number <> p_original_rec.serial_number)
8709: THEN
8710:
8711: IF l_debug_on THEN
8712: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
8713: WSH_DEBUG_SV.log(l_module_name,'Case1',p_original_rec.serial_number);
8714: END IF;
8715: wsh_delivery_details_inv.unmark_serial_number(
8716: p_delivery_detail_id => p_in_detail_rec.delivery_detail_id,

Line 8715: wsh_delivery_details_inv.unmark_serial_number(

8711: IF l_debug_on THEN
8712: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
8713: WSH_DEBUG_SV.log(l_module_name,'Case1',p_original_rec.serial_number);
8714: END IF;
8715: wsh_delivery_details_inv.unmark_serial_number(
8716: p_delivery_detail_id => p_in_detail_rec.delivery_detail_id,
8717: p_serial_number_code => l_inv_controls.serial_code,
8718: p_serial_number => p_original_rec.serial_number,
8719: p_transaction_temp_id => NULL,

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

8741: -- derive serial number from MSNT for this transaction temp id
8742: -- compare with x_detail_rec.serial_number
8743:
8744: IF l_debug_on THEN
8745: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
8746: WSH_DEBUG_SV.log(l_module_name,'Case2',p_original_rec.transaction_temp_id);
8747: END IF;
8748: wsh_delivery_details_inv.unmark_serial_number(
8749: p_delivery_detail_id => p_in_detail_rec.delivery_detail_id,

Line 8748: wsh_delivery_details_inv.unmark_serial_number(

8744: IF l_debug_on THEN
8745: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
8746: WSH_DEBUG_SV.log(l_module_name,'Case2',p_original_rec.transaction_temp_id);
8747: END IF;
8748: wsh_delivery_details_inv.unmark_serial_number(
8749: p_delivery_detail_id => p_in_detail_rec.delivery_detail_id,
8750: p_serial_number_code => l_inv_controls.serial_code,
8751: p_serial_number => NULL,
8752: p_transaction_temp_id => p_original_rec.transaction_temp_id,

Line 8782: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SERIAL_RANGE', WSH_DEBUG_SV.c_proc_level);

8778: IF l_det_ser_range_tab(l_det_index).to_serial_number IS NOT NULL THEN -- bug 1578114 condition added
8779: IF l_debug_on THEN
8780: WSH_DEBUG_SV.log(l_module_name, 'To Serial Number', l_det_ser_range_tab(l_det_index).to_serial_number);
8781: WSH_DEBUG_SV.log(l_module_name, 'Transaction Id', l_transaction_id);
8782: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SERIAL_RANGE', WSH_DEBUG_SV.c_proc_level);
8783: END IF;
8784:
8785: --
8786: -- Validates the Range of Serial Number

Line 8787: wsh_delivery_details_inv.validate_serial_range(

8783: END IF;
8784:
8785: --
8786: -- Validates the Range of Serial Number
8787: wsh_delivery_details_inv.validate_serial_range(
8788: p_from_serial_number => l_det_ser_range_tab(l_det_index).from_serial_number,
8789: p_to_serial_number => l_det_ser_range_tab(l_det_index).to_serial_number,
8790: p_lot_number => l_lot,
8791: p_organization_id => l_org_id,

Line 8823: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SERIAL', WSH_DEBUG_SV.c_proc_level);

8819: p_msg_data => l_msg_data
8820: );
8821: ELSE
8822: IF l_debug_on THEN
8823: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SERIAL', WSH_DEBUG_SV.c_proc_level);
8824: END IF;
8825:
8826: --
8827: wsh_delivery_details_inv.validate_serial(

Line 8827: wsh_delivery_details_inv.validate_serial(

8823: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SERIAL', WSH_DEBUG_SV.c_proc_level);
8824: END IF;
8825:
8826: --
8827: wsh_delivery_details_inv.validate_serial(
8828: p_serial_number => l_det_ser_range_tab(l_det_index).from_serial_number,
8829: p_lot_number => l_lot,
8830: p_organization_id => l_org_id,
8831: p_inventory_item_id => p_original_rec.inventory_item_id,

Line 8871: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.CREATE_DYNAMIC_SERIAL_RANGE', WSH_DEBUG_SV.c_proc_level);

8867: )
8868: AND l_det_ser_range_tab(l_det_index).to_serial_number IS NOT NULL THEN -- bug 1578114 condition added
8869: IF l_debug_on THEN
8870: WSH_DEBUG_SV.log(l_module_name, 'Transaction id created', l_transaction_id);
8871: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.CREATE_DYNAMIC_SERIAL_RANGE', WSH_DEBUG_SV.c_proc_level);
8872: END IF;
8873:
8874: --
8875: -- Creates/Validates the Range of Serial Number

Line 8876: wsh_delivery_details_inv.create_dynamic_serial_range(

8872: END IF;
8873:
8874: --
8875: -- Creates/Validates the Range of Serial Number
8876: wsh_delivery_details_inv.create_dynamic_serial_range(
8877: p_from_number => l_det_ser_range_tab(l_det_index).from_serial_number,
8878: p_to_number => l_det_ser_range_tab(l_det_index).to_serial_number,
8879: -- Earlier l_transaction_id was being passed to p_delivery_detail below (frontport from 1159) - jckwok
8880: p_delivery_detail_id => x_detail_rec.delivery_detail_id,

Line 8901: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.CREATE_DYNAMIC_SERIAL', WSH_DEBUG_SV.c_proc_level);

8897: p_msg_data => l_msg_data
8898: );
8899: ELSE
8900: IF l_debug_on THEN
8901: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.CREATE_DYNAMIC_SERIAL', WSH_DEBUG_SV.c_proc_level);
8902: END IF;
8903:
8904: --
8905: wsh_delivery_details_inv.create_dynamic_serial(

Line 8905: wsh_delivery_details_inv.create_dynamic_serial(

8901: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.CREATE_DYNAMIC_SERIAL', WSH_DEBUG_SV.c_proc_level);
8902: END IF;
8903:
8904: --
8905: wsh_delivery_details_inv.create_dynamic_serial(
8906: p_from_number => l_det_ser_range_tab(l_det_index).from_serial_number,
8907: p_to_number => l_det_ser_range_tab(l_det_index).from_serial_number,
8908: p_delivery_detail_id => x_detail_rec.delivery_detail_id,
8909: p_source_line_id => p_original_rec.source_line_id,

Line 9068: wsh_delivery_details_inv.mark_serial_number(

9064: --{
9065: IF l_transaction_id IS NOT NULL
9066: THEN
9067: -- (
9068: wsh_delivery_details_inv.mark_serial_number(
9069: p_delivery_detail_id => x_detail_rec.delivery_detail_id,
9070: p_serial_number => NULL,
9071: p_transaction_temp_id => l_transaction_id,
9072: x_return_status => l_return_status

Line 9085: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.MARK_SERIAL_NUMBER', WSH_DEBUG_SV.c_proc_level);

9081: AND p_in_detail_rec.serial_number <> FND_API.G_MISS_CHAR
9082: THEN
9083: --
9084: IF l_debug_on THEN
9085: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.MARK_SERIAL_NUMBER', WSH_DEBUG_SV.c_proc_level);
9086: END IF;
9087:
9088: --
9089: wsh_delivery_details_inv.mark_serial_number(

Line 9089: wsh_delivery_details_inv.mark_serial_number(

9085: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.MARK_SERIAL_NUMBER', WSH_DEBUG_SV.c_proc_level);
9086: END IF;
9087:
9088: --
9089: wsh_delivery_details_inv.mark_serial_number(
9090: p_delivery_detail_id => x_detail_rec.delivery_detail_id,
9091: p_serial_number => p_in_detail_rec.serial_number,
9092: p_transaction_temp_id => l_transaction_id,
9093: x_return_status => l_return_status

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

9109: -- newly generated transaction_temp_id in the scenario where
9110: -- only the serial attributes are updated and not the serial #
9111: --
9112: IF l_debug_on THEN
9113: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UPDATE_MARKED_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
9114: END IF;
9115: --
9116: WSH_DELIVERY_DETAILS_INV.Update_Marked_Serial(
9117: p_from_serial_number => p_original_rec.serial_number,

Line 9116: WSH_DELIVERY_DETAILS_INV.Update_Marked_Serial(

9112: IF l_debug_on THEN
9113: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UPDATE_MARKED_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
9114: END IF;
9115: --
9116: WSH_DELIVERY_DETAILS_INV.Update_Marked_Serial(
9117: p_from_serial_number => p_original_rec.serial_number,
9118: p_to_serial_number => NULL, -- always pass NULL for single serial number
9119: p_inventory_item_id => p_original_rec.inventory_item_id,
9120: p_organization_id => l_org_id,