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 7538: l_inv_controls wsh_delivery_details_inv.inv_control_flag_rec;

7534: -- HW OPMCONV - Increased length to 80
7535: l_lot VARCHAR2(80);
7536: l_result BOOLEAN;
7537: l_quantity NUMBER;
7538: l_inv_controls wsh_delivery_details_inv.inv_control_flag_rec;
7539: l_ship_method_name VARCHAR2(32767);
7540: -- HW Harmonization project for OPM. Added l_process flag variable
7541: -- HW OPMCONV - Removed OPM variables
7542:

Line 7736: WSH_DELIVERY_DETAILS_INV.get_trx_type_id(

7732:
7733: l_org_id := p_original_rec.organization_id;
7734:
7735: /***************Material Status Impact***********/
7736: WSH_DELIVERY_DETAILS_INV.get_trx_type_id(
7737: p_source_line_id => x_detail_rec.source_line_id, --RTV changes
7738: p_source_code => x_detail_rec.source_code, --RTV changes
7739: x_transaction_type_id => l_trx_type_id,
7740: x_return_status => l_return_status);

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

7787: OR p_validation_tab(wsh_actions_levels.c_serial_num_lvl) = 1
7788: THEN
7789: --(
7790: IF l_debug_on THEN
7791: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS', WSH_DEBUG_SV.c_proc_level);
7792: END IF;
7793:
7794: wsh_delivery_details_inv.fetch_inv_controls(
7795: p_delivery_detail_id => x_detail_rec.delivery_detail_id,

Line 7794: wsh_delivery_details_inv.fetch_inv_controls(

7790: IF l_debug_on THEN
7791: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.FETCH_INV_CONTROLS', WSH_DEBUG_SV.c_proc_level);
7792: END IF;
7793:
7794: wsh_delivery_details_inv.fetch_inv_controls(
7795: p_delivery_detail_id => x_detail_rec.delivery_detail_id,
7796: p_inventory_item_id => p_original_rec.inventory_item_id,
7797: p_organization_id => l_org_id,
7798: p_subinventory => l_subinventory,

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

8147: IF (p_validation_tab(wsh_actions_levels.c_sub_inv_lvl) = 1) THEN
8148: IF (x_detail_rec.subinventory <> fnd_api.g_miss_char) THEN
8149: IF l_debug_on THEN
8150: WSH_DEBUG_SV.log(l_module_name, 'Subinventory', x_detail_rec.subinventory);
8151: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SUBINVENTORY', WSH_DEBUG_SV.c_proc_level);
8152: END IF;
8153:
8154: --
8155: wsh_delivery_details_inv.validate_subinventory(

Line 8155: wsh_delivery_details_inv.validate_subinventory(

8151: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SUBINVENTORY', WSH_DEBUG_SV.c_proc_level);
8152: END IF;
8153:
8154: --
8155: wsh_delivery_details_inv.validate_subinventory(
8156: p_subinventory => x_detail_rec.subinventory,
8157: p_organization_id => l_org_id,
8158: p_inventory_item_id => p_original_rec.inventory_item_id,
8159: p_transaction_type_id => l_trx_type_id,

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

8208: END IF;
8209: ELSE
8210: IF l_debug_on THEN
8211: WSH_DEBUG_SV.log(l_module_name, 'Revision', x_detail_rec.revision);
8212: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_REVISION', WSH_DEBUG_SV.c_proc_level);
8213: END IF;
8214:
8215: wsh_delivery_details_inv.validate_revision(
8216: p_revision => x_detail_rec.revision,

Line 8215: wsh_delivery_details_inv.validate_revision(

8211: WSH_DEBUG_SV.log(l_module_name, 'Revision', x_detail_rec.revision);
8212: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_REVISION', WSH_DEBUG_SV.c_proc_level);
8213: END IF;
8214:
8215: wsh_delivery_details_inv.validate_revision(
8216: p_revision => x_detail_rec.revision,
8217: p_organization_id => l_org_id,
8218: p_inventory_item_id => p_original_rec.inventory_item_id,
8219: x_return_status => l_return_status,

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

8269: ELSE
8270:
8271: IF l_debug_on THEN
8272: WSH_DEBUG_SV.log(l_module_name, 'Locator Id', x_detail_rec.locator_id);
8273: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_LOCATOR', WSH_DEBUG_SV.c_proc_level);
8274: END IF;
8275: wsh_delivery_details_inv.validate_locator(
8276: p_locator_id => x_detail_rec.locator_id,
8277: p_organization_id => l_org_id,

Line 8275: wsh_delivery_details_inv.validate_locator(

8271: IF l_debug_on THEN
8272: WSH_DEBUG_SV.log(l_module_name, 'Locator Id', x_detail_rec.locator_id);
8273: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_LOCATOR', WSH_DEBUG_SV.c_proc_level);
8274: END IF;
8275: wsh_delivery_details_inv.validate_locator(
8276: p_locator_id => x_detail_rec.locator_id,
8277: p_organization_id => l_org_id,
8278: p_inventory_item_id => p_original_rec.inventory_item_id,
8279: p_subinventory => l_subinventory,

Line 8339: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(

8335: END IF;
8336: ELSE
8337: -- bug 4766908 get the reservable_flag
8338: IF p_original_rec.released_status = 'Y' THEN
8339: l_reservable_flag := WSH_DELIVERY_DETAILS_INV.get_reservable_flag(
8340: x_item_id => p_original_rec.inventory_item_id,
8341: x_organization_id => p_original_rec.organization_id,
8342: x_pickable_flag => p_original_rec.pickable_flag);
8343: END IF;

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

8342: x_pickable_flag => p_original_rec.pickable_flag);
8343: END IF;
8344: IF (nvl(l_reservable_flag, 'Y') = 'Y') THEN
8345: IF l_debug_on THEN
8346: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_LOT_NUMBER', WSH_DEBUG_SV.c_proc_level);
8347: END IF;
8348:
8349: wsh_delivery_details_inv.validate_lot_number(
8350: p_lot_number => x_detail_rec.lot_number,

Line 8349: wsh_delivery_details_inv.validate_lot_number(

8345: IF l_debug_on THEN
8346: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_LOT_NUMBER', WSH_DEBUG_SV.c_proc_level);
8347: END IF;
8348:
8349: wsh_delivery_details_inv.validate_lot_number(
8350: p_lot_number => x_detail_rec.lot_number,
8351: p_organization_id => l_org_id,
8352: p_inventory_item_id => p_original_rec.inventory_item_id,
8353: p_revision => l_revision,

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

8827: -- x_detail_rec.serial_number <> p_original_rec.serial_number)
8828: THEN
8829:
8830: IF l_debug_on THEN
8831: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
8832: WSH_DEBUG_SV.log(l_module_name,'Case1',p_original_rec.serial_number);
8833: END IF;
8834: wsh_delivery_details_inv.unmark_serial_number(
8835: p_delivery_detail_id => p_in_detail_rec.delivery_detail_id,

Line 8834: wsh_delivery_details_inv.unmark_serial_number(

8830: IF l_debug_on THEN
8831: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
8832: WSH_DEBUG_SV.log(l_module_name,'Case1',p_original_rec.serial_number);
8833: END IF;
8834: wsh_delivery_details_inv.unmark_serial_number(
8835: p_delivery_detail_id => p_in_detail_rec.delivery_detail_id,
8836: p_serial_number_code => l_inv_controls.serial_code,
8837: p_serial_number => p_original_rec.serial_number,
8838: p_transaction_temp_id => NULL,

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

8860: -- derive serial number from MSNT for this transaction temp id
8861: -- compare with x_detail_rec.serial_number
8862:
8863: IF l_debug_on THEN
8864: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
8865: WSH_DEBUG_SV.log(l_module_name,'Case2',p_original_rec.transaction_temp_id);
8866: END IF;
8867: wsh_delivery_details_inv.unmark_serial_number(
8868: p_delivery_detail_id => p_in_detail_rec.delivery_detail_id,

Line 8867: wsh_delivery_details_inv.unmark_serial_number(

8863: IF l_debug_on THEN
8864: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UNMARK_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
8865: WSH_DEBUG_SV.log(l_module_name,'Case2',p_original_rec.transaction_temp_id);
8866: END IF;
8867: wsh_delivery_details_inv.unmark_serial_number(
8868: p_delivery_detail_id => p_in_detail_rec.delivery_detail_id,
8869: p_serial_number_code => l_inv_controls.serial_code,
8870: p_serial_number => NULL,
8871: p_transaction_temp_id => p_original_rec.transaction_temp_id,

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

8897: IF l_det_ser_range_tab(l_det_index).to_serial_number IS NOT NULL THEN -- bug 1578114 condition added
8898: IF l_debug_on THEN
8899: WSH_DEBUG_SV.log(l_module_name, 'To Serial Number', l_det_ser_range_tab(l_det_index).to_serial_number);
8900: WSH_DEBUG_SV.log(l_module_name, 'Transaction Id', l_transaction_id);
8901: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SERIAL_RANGE', WSH_DEBUG_SV.c_proc_level);
8902: END IF;
8903:
8904: --
8905: -- Validates the Range of Serial Number

Line 8906: wsh_delivery_details_inv.validate_serial_range(

8902: END IF;
8903:
8904: --
8905: -- Validates the Range of Serial Number
8906: wsh_delivery_details_inv.validate_serial_range(
8907: p_from_serial_number => l_det_ser_range_tab(l_det_index).from_serial_number,
8908: p_to_serial_number => l_det_ser_range_tab(l_det_index).to_serial_number,
8909: p_lot_number => l_lot,
8910: p_organization_id => l_org_id,

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

8938: p_msg_data => l_msg_data
8939: );
8940: ELSE
8941: IF l_debug_on THEN
8942: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SERIAL', WSH_DEBUG_SV.c_proc_level);
8943: END IF;
8944:
8945: --
8946: wsh_delivery_details_inv.validate_serial(

Line 8946: wsh_delivery_details_inv.validate_serial(

8942: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.VALIDATE_SERIAL', WSH_DEBUG_SV.c_proc_level);
8943: END IF;
8944:
8945: --
8946: wsh_delivery_details_inv.validate_serial(
8947: p_serial_number => l_det_ser_range_tab(l_det_index).from_serial_number,
8948: p_lot_number => l_lot,
8949: p_organization_id => l_org_id,
8950: p_inventory_item_id => p_original_rec.inventory_item_id,

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

8986: )
8987: AND l_det_ser_range_tab(l_det_index).to_serial_number IS NOT NULL THEN -- bug 1578114 condition added
8988: IF l_debug_on THEN
8989: WSH_DEBUG_SV.log(l_module_name, 'Transaction id created', l_transaction_id);
8990: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.CREATE_DYNAMIC_SERIAL_RANGE', WSH_DEBUG_SV.c_proc_level);
8991: END IF;
8992:
8993: --
8994: -- Creates/Validates the Range of Serial Number

Line 8995: wsh_delivery_details_inv.create_dynamic_serial_range(

8991: END IF;
8992:
8993: --
8994: -- Creates/Validates the Range of Serial Number
8995: wsh_delivery_details_inv.create_dynamic_serial_range(
8996: p_from_number => l_det_ser_range_tab(l_det_index).from_serial_number,
8997: p_to_number => l_det_ser_range_tab(l_det_index).to_serial_number,
8998: -- Earlier l_transaction_id was being passed to p_delivery_detail below (frontport from 1159) - jckwok
8999: p_delivery_detail_id => x_detail_rec.delivery_detail_id,

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

9016: p_msg_data => l_msg_data
9017: );
9018: ELSE
9019: IF l_debug_on THEN
9020: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.CREATE_DYNAMIC_SERIAL', WSH_DEBUG_SV.c_proc_level);
9021: END IF;
9022:
9023: --
9024: wsh_delivery_details_inv.create_dynamic_serial(

Line 9024: wsh_delivery_details_inv.create_dynamic_serial(

9020: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.CREATE_DYNAMIC_SERIAL', WSH_DEBUG_SV.c_proc_level);
9021: END IF;
9022:
9023: --
9024: wsh_delivery_details_inv.create_dynamic_serial(
9025: p_from_number => l_det_ser_range_tab(l_det_index).from_serial_number,
9026: p_to_number => l_det_ser_range_tab(l_det_index).from_serial_number,
9027: p_delivery_detail_id => x_detail_rec.delivery_detail_id,
9028: p_source_line_id => p_original_rec.source_line_id,

Line 9187: wsh_delivery_details_inv.mark_serial_number(

9183: --{
9184: IF l_transaction_id IS NOT NULL
9185: THEN
9186: -- (
9187: wsh_delivery_details_inv.mark_serial_number(
9188: p_delivery_detail_id => x_detail_rec.delivery_detail_id,
9189: p_serial_number => NULL,
9190: p_transaction_temp_id => l_transaction_id,
9191: x_return_status => l_return_status

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

9200: AND p_in_detail_rec.serial_number <> FND_API.G_MISS_CHAR
9201: THEN
9202: --
9203: IF l_debug_on THEN
9204: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.MARK_SERIAL_NUMBER', WSH_DEBUG_SV.c_proc_level);
9205: END IF;
9206:
9207: --
9208: wsh_delivery_details_inv.mark_serial_number(

Line 9208: wsh_delivery_details_inv.mark_serial_number(

9204: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling program unit WSH_DELIVERY_DETAILS_INV.MARK_SERIAL_NUMBER', WSH_DEBUG_SV.c_proc_level);
9205: END IF;
9206:
9207: --
9208: wsh_delivery_details_inv.mark_serial_number(
9209: p_delivery_detail_id => x_detail_rec.delivery_detail_id,
9210: p_serial_number => p_in_detail_rec.serial_number,
9211: p_transaction_temp_id => l_transaction_id,
9212: x_return_status => l_return_status

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

9228: -- newly generated transaction_temp_id in the scenario where
9229: -- only the serial attributes are updated and not the serial #
9230: --
9231: IF l_debug_on THEN
9232: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UPDATE_MARKED_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
9233: END IF;
9234: --
9235: WSH_DELIVERY_DETAILS_INV.Update_Marked_Serial(
9236: p_from_serial_number => p_original_rec.serial_number,

Line 9235: WSH_DELIVERY_DETAILS_INV.Update_Marked_Serial(

9231: IF l_debug_on THEN
9232: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_INV.UPDATE_MARKED_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
9233: END IF;
9234: --
9235: WSH_DELIVERY_DETAILS_INV.Update_Marked_Serial(
9236: p_from_serial_number => p_original_rec.serial_number,
9237: p_to_serial_number => NULL, -- always pass NULL for single serial number
9238: p_inventory_item_id => p_original_rec.inventory_item_id,
9239: p_organization_id => l_org_id,