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_USA_INV_PVT dependencies on WSH_USA_INV_PVT

Line 1: PACKAGE BODY WSH_USA_INV_PVT as

1: PACKAGE BODY WSH_USA_INV_PVT as
2: /* $Header: WSHUSAIB.pls 120.46.12020000.10 2013/05/30 13:31:02 skanduku ship $ */
3:
4: --G_PACKAGE_NAME CONSTANT VARCHAR2(50) := 'WSH_USA_INV_PVT';
5:

Line 4: --G_PACKAGE_NAME CONSTANT VARCHAR2(50) := 'WSH_USA_INV_PVT';

1: PACKAGE BODY WSH_USA_INV_PVT as
2: /* $Header: WSHUSAIB.pls 120.46.12020000.10 2013/05/30 13:31:02 skanduku ship $ */
3:
4: --G_PACKAGE_NAME CONSTANT VARCHAR2(50) := 'WSH_USA_INV_PVT';
5:
6:
7: -- declare the private function (Bug3012297)
8: FUNCTION check_inv_info (

Line 540: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.unassign_backordered_details');

536: END IF;
537:
538: WHEN e_return THEN
539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
540: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.unassign_backordered_details');
541: -- OTM R12 : unassign delivery detail
542: IF (c_detail_cont_planning_cur%ISOPEN) THEN
543: CLOSE c_detail_cont_planning_cur;
544: END IF;

Line 553: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.unassign_backordered_details');

549: END IF;
550:
551: WHEN OTHERS THEN
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
553: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.unassign_backordered_details');
554: -- OTM R12 : unassign delivery detail
555: IF (c_detail_cont_planning_cur%ISOPEN) THEN
556: CLOSE c_detail_cont_planning_cur;
557: END IF;

Line 864: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.backorder_delivery_detail');

860: EXCEPTION
861:
862: WHEN OTHERS THEN
863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
864: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.backorder_delivery_detail');
865: IF l_debug_on THEN
866: WSH_DEBUG_SV.logmsg(l_module_name,'BACKORDER_DELIVERY_DETAIL_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
867: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:BACKORDER_DELIVERY_DETAIL');
868: END IF;

Line 974: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.Get_total_Reserved_quantity');

970: END IF;
971:
972: WHEN OTHERS THEN
973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
974: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.Get_total_Reserved_quantity');
975: IF l_debug_on THEN
976: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
977: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
978: END IF;

Line 1042: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.QUERY_RESERVATIONS ORDER LINE = '|| P_SOURCE_LINE_ID );

1038: --
1039: -- Debug Statements
1040: --
1041: IF l_debug_on THEN
1042: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.QUERY_RESERVATIONS ORDER LINE = '|| P_SOURCE_LINE_ID );
1043: END IF;
1044: --
1045: --
1046: -- Debug Statements

Line 1183: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.DELETE_RESERVATION ORDER LINE = '|| P_QUERY_INPUT.DEMAND_SOURCE_LINE_ID );

1179: END IF;
1180: --
1181: IF l_debug_on THEN
1182: WSH_DEBUG_SV.push(l_module_name);
1183: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.DELETE_RESERVATION ORDER LINE = '|| P_QUERY_INPUT.DEMAND_SOURCE_LINE_ID );
1184: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_RESERVATION_PUB.DELETE_RESERVATION',WSH_DEBUG_SV.C_PROC_LEVEL);
1185: END IF;
1186:
1187: INV_RESERVATION_PUB.delete_reservation

Line 1319: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.CREATE_RESERVATION ' );

1315: --
1316: -- Debug Statements
1317: --
1318: IF l_debug_on THEN
1319: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.CREATE_RESERVATION ' );
1320: END IF;
1321: --
1322:
1323: --

Line 1674: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.CHECK_INV_INFO FOR DETAIL : '|| P_DELIVERY_DETAIL_SPLIT_REC.DELIVERY_DETAIL_ID||' REL STAT : '||P_DELIVERY_DETAIL_SPLIT_REC.RELEASED_STATUS );

1670: -- Debug Statements
1671: --
1672: IF l_debug_on THEN
1673: -- HW BUG#:3456926 - Removed OPM debugging msg and kept WSH
1674: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.CHECK_INV_INFO FOR DETAIL : '|| P_DELIVERY_DETAIL_SPLIT_REC.DELIVERY_DETAIL_ID||' REL STAT : '||P_DELIVERY_DETAIL_SPLIT_REC.RELEASED_STATUS );
1675: END IF;
1676: --
1677:
1678: -- 3012297 (initializing l_process_flag)

Line 1859: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION QUANTITY : '|| P_CANCELLATION_QUANTITY );

1855: --
1856: -- Debug Statements
1857: --
1858: IF l_debug_on THEN
1859: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION QUANTITY : '|| P_CANCELLATION_QUANTITY );
1860: END IF;
1861: --
1862:
1863: --X-dock, conditionally populate delivery_detail_id

Line 1864: WSH_USA_INV_PVT.get_putaway_detail_id

1860: END IF;
1861: --
1862:
1863: --X-dock, conditionally populate delivery_detail_id
1864: WSH_USA_INV_PVT.get_putaway_detail_id
1865: (p_detail_id => p_delivery_detail_split_rec.delivery_detail_id,
1866: p_released_status => p_delivery_detail_split_rec.released_status,
1867: p_move_order_line_id => p_delivery_detail_split_rec.move_order_line_id,
1868: x_detail_id => l_delivery_detail_id,

Line 2069: wsh_util_core.default_handler('WSH_USA_INV_PVT.cancel_staged_reservation',l_module_name);

2065: END IF;
2066: --
2067: WHEN others THEN
2068: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2069: wsh_util_core.default_handler('WSH_USA_INV_PVT.cancel_staged_reservation',l_module_name);
2070:
2071: IF l_debug_on THEN
2072: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2073: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2178: WSH_USA_INV_PVT.get_putaway_detail_id

2174: END IF;
2175:
2176: --X-dock, conditionally populate delivery_detail_id
2177: -- released-status and MOL are passed as null and will be derived within the API
2178: WSH_USA_INV_PVT.get_putaway_detail_id
2179: (p_detail_id => p_delivery_detail_id,
2180: p_released_status => null,
2181: p_move_order_line_id => null,
2182: x_detail_id => l_delivery_detail_id,

Line 2706: wsh_util_core.default_handler('WSH_USA_INV_PVT.cancel_nonstaged_reservation',l_module_name);

2702: END IF;
2703: --
2704: WHEN others THEN
2705: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2706: wsh_util_core.default_handler('WSH_USA_INV_PVT.cancel_nonstaged_reservation',l_module_name);
2707:
2708: --
2709: -- Debug Statements
2710: --

Line 2965: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.RESERVATION_SPLIT_ACTION TO SPLIT : '|| L_QUANTITY_TO_SPLIT );

2961: END IF;
2962: -- KYH INVCONV END
2963:
2964: IF l_debug_on THEN
2965: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.RESERVATION_SPLIT_ACTION TO SPLIT : '|| L_QUANTITY_TO_SPLIT );
2966: END IF;
2967: --
2968: -- 2847687 : No More performing Update_Reservations per INV advice,
2969: -- So always calling Transfer Rsvtns.

Line 3155: wsh_util_core.default_handler('WSH_USA_INV_PVT.reservation_split_action',l_module_name);

3151: END IF;
3152: --
3153: WHEN others THEN
3154: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3155: wsh_util_core.default_handler('WSH_USA_INV_PVT.reservation_split_action',l_module_name);
3156: IF l_debug_on THEN
3157: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3158: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3159: END IF;

Line 3261: WSH_USA_INV_PVT.get_putaway_detail_id

3257: -- Debug Statements
3258: -- HW OPMCONV. Removed checking for OPM org
3259:
3260: --X-dock,split
3261: WSH_USA_INV_PVT.get_putaway_detail_id
3262: (p_detail_id => p_delivery_detail_split_rec.delivery_detail_id,
3263: p_released_status => p_delivery_detail_split_rec.released_status,
3264: p_move_order_line_id => p_delivery_detail_split_rec.move_order_line_id,
3265: x_detail_id => l_delivery_detail_id,

Line 3282: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.SPLIT_RESERVATION TO SPLIT : '|| P_SPLIT_QUANTITY );

3278: --
3279: -- Debug Statements
3280: --
3281: IF l_debug_on THEN
3282: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.SPLIT_RESERVATION TO SPLIT : '|| P_SPLIT_QUANTITY );
3283: END IF;
3284: --
3285: --{
3286: IF p_delivery_detail_split_rec.released_status = 'S' THEN

Line 3691: wsh_util_core.default_handler('WSH_USA_INV_PVT.split_reservation',l_module_name);

3687: --
3688: -- bug 5226867
3689: WHEN others THEN
3690: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3691: wsh_util_core.default_handler('WSH_USA_INV_PVT.split_reservation',l_module_name);
3692:
3693: --
3694: -- Debug Statements
3695: --

Line 3750: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.UPDATE_SERIAL_NUMBERS' );

3746: --
3747: -- Debug Statements
3748: --
3749: IF l_debug_on THEN
3750: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.UPDATE_SERIAL_NUMBERS' );
3751: END IF;
3752: --
3753: IF (p_serial_number IS NULL) AND (p_transaction_temp_id IS NULL) THEN
3754: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3821: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.update_serial_numbers',l_module_name);

3817: EXCEPTION
3818:
3819: WHEN OTHERS THEN
3820: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3821: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.update_serial_numbers',l_module_name);
3822:
3823: --
3824: -- Debug Statements
3825: --

Line 4962: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_INV_PVT. BACKORDERED_DELIVERY_DETAIL' ,WSH_DEBUG_SV.C_PROC_LEVEL);

4958: --
4959: -- Debug Statements
4960: --
4961: IF l_debug_on THEN
4962: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_INV_PVT. BACKORDERED_DELIVERY_DETAIL' ,WSH_DEBUG_SV.C_PROC_LEVEL);
4963: END IF;
4964: --
4965: backorder_delivery_detail(
4966: p_delivery_detail_id => l_dummy_detail_id ,

Line 5648: WSH_DEBUG_SV.log(l_module_name,'Calling program unit WSH_USA_INV_PVT. BACKORDERED_DELIVERY_DETAIL' ,WSH_DEBUG_SV.C_PROC_LEVEL);

5644: -- Debug Statements
5645: --
5646:
5647: IF l_debug_on THEN
5648: WSH_DEBUG_SV.log(l_module_name,'Calling program unit WSH_USA_INV_PVT. BACKORDERED_DELIVERY_DETAIL' ,WSH_DEBUG_SV.C_PROC_LEVEL);
5649: END IF;
5650: --
5651: --
5652: backorder_delivery_detail(

Line 6713: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_INV_PVT. BACKORDERED_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

6709: --
6710: -- Debug Statements
6711: --
6712: IF l_debug_on THEN
6713: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_INV_PVT. BACKORDERED_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
6714: END IF;
6715: --
6716: --Bug# 5436033
6717: --do not calculate the qty2 convert from bo_Qty Cause this is like entering a new line

Line 7128: wsh_util_core.default_handler('WSH_USA_INV_PVT.Update_Inventory_Info',l_module_name);

7124: --
7125:
7126: WHEN others THEN
7127: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
7128: wsh_util_core.default_handler('WSH_USA_INV_PVT.Update_Inventory_Info',l_module_name);
7129: --
7130: -- LPN CONV rv
7131: WSH_WMS_LPN_GRP.g_caller := l_original_caller;
7132: WSH_WMS_LPN_GRP.g_callback_required := l_orig_callback_reqd;

Line 7243: wsh_util_core.default_handler('WSH_USA_INV_PVT.get_detailed_quantity',l_module_name);

7239: IF l_debug_on THEN
7240: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
7241: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
7242: END IF;
7243: wsh_util_core.default_handler('WSH_USA_INV_PVT.get_detailed_quantity',l_module_name);
7244:
7245: END get_detailed_quantity;
7246:
7247: --

Line 7303: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_INV_PVT.is_mo_type_putaway',l_module_name);

7299: IF l_debug_on THEN
7300: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
7301: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
7302: END IF;
7303: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_INV_PVT.is_mo_type_putaway',l_module_name);
7304: RETURN 'N';
7305:
7306: END is_mo_type_putaway;
7307:

Line 7376: wsh_usa_inv_pvt.is_mo_type_putaway (l_move_order_line_id) = 'Y' THEN

7372: --Check only for line with released_status = 'S' and MOL is not null and MO type = PUTAWAY
7373: IF p_detail_id IS NOT NULL AND
7374: l_released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE AND
7375: l_move_order_line_id IS NOT NULL AND
7376: wsh_usa_inv_pvt.is_mo_type_putaway (l_move_order_line_id) = 'Y' THEN
7377: x_detail_id := p_detail_id;
7378: END IF;
7379:
7380: IF l_debug_on THEN

Line 7392: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_INV_PVT.get_putaway_detail_id',l_module_name);

7388: IF c_get_line_details%ISOPEN THEN
7389: CLOSE c_get_line_details;
7390: END IF;
7391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7392: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_INV_PVT.get_putaway_detail_id',l_module_name);
7393: IF l_debug_on THEN
7394: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
7395: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
7396: END IF;

Line 7399: END WSH_USA_INV_PVT;

7395: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
7396: END IF;
7397: END get_putaway_detail_id;
7398:
7399: END WSH_USA_INV_PVT;