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.32.12010000.5 2008/10/20 04:45:02 brana 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.32.12010000.5 2008/10/20 04:45:02 brana 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 538: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.unassign_backordered_details');

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

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

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

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

847: EXCEPTION
848:
849: WHEN OTHERS THEN
850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
851: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.backorder_delivery_detail');
852: IF l_debug_on THEN
853: WSH_DEBUG_SV.logmsg(l_module_name,'BACKORDER_DELIVERY_DETAIL_FAILED exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
854: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:BACKORDER_DELIVERY_DETAIL');
855: END IF;

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

957: END IF;
958:
959: WHEN OTHERS THEN
960: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
961: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.Get_total_Reserved_quantity');
962: IF l_debug_on THEN
963: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
964: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
965: END IF;

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

1025: --
1026: -- Debug Statements
1027: --
1028: IF l_debug_on THEN
1029: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.QUERY_RESERVATIONS ORDER LINE = '|| P_SOURCE_LINE_ID );
1030: END IF;
1031: --
1032: --
1033: -- Debug Statements

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

1166: END IF;
1167: --
1168: IF l_debug_on THEN
1169: WSH_DEBUG_SV.push(l_module_name);
1170: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.DELETE_RESERVATION ORDER LINE = '|| P_QUERY_INPUT.DEMAND_SOURCE_LINE_ID );
1171: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit INV_RESERVATION_PUB.DELETE_RESERVATION',WSH_DEBUG_SV.C_PROC_LEVEL);
1172: END IF;
1173:
1174: INV_RESERVATION_PUB.delete_reservation

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

1302: --
1303: -- Debug Statements
1304: --
1305: IF l_debug_on THEN
1306: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.CREATE_RESERVATION ' );
1307: END IF;
1308: --
1309:
1310: --

Line 1661: 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 );

1657: -- Debug Statements
1658: --
1659: IF l_debug_on THEN
1660: -- HW BUG#:3456926 - Removed OPM debugging msg and kept WSH
1661: 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 );
1662: END IF;
1663: --
1664:
1665: -- 3012297 (initializing l_process_flag)

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

1842: --
1843: -- Debug Statements
1844: --
1845: IF l_debug_on THEN
1846: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION QUANTITY : '|| P_CANCELLATION_QUANTITY );
1847: END IF;
1848: --
1849:
1850: --X-dock, conditionally populate delivery_detail_id

Line 1851: WSH_USA_INV_PVT.get_putaway_detail_id

1847: END IF;
1848: --
1849:
1850: --X-dock, conditionally populate delivery_detail_id
1851: WSH_USA_INV_PVT.get_putaway_detail_id
1852: (p_detail_id => p_delivery_detail_split_rec.delivery_detail_id,
1853: p_released_status => p_delivery_detail_split_rec.released_status,
1854: p_move_order_line_id => p_delivery_detail_split_rec.move_order_line_id,
1855: x_detail_id => l_delivery_detail_id,

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

2052: END IF;
2053: --
2054: WHEN others THEN
2055: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2056: wsh_util_core.default_handler('WSH_USA_INV_PVT.cancel_staged_reservation',l_module_name);
2057:
2058: IF l_debug_on THEN
2059: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2060: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2163: WSH_USA_INV_PVT.get_putaway_detail_id

2159: END IF;
2160:
2161: --X-dock, conditionally populate delivery_detail_id
2162: -- released-status and MOL are passed as null and will be derived within the API
2163: WSH_USA_INV_PVT.get_putaway_detail_id
2164: (p_detail_id => p_delivery_detail_id,
2165: p_released_status => null,
2166: p_move_order_line_id => null,
2167: x_detail_id => l_delivery_detail_id,

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

2543: END IF;
2544: --
2545: WHEN others THEN
2546: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2547: wsh_util_core.default_handler('WSH_USA_INV_PVT.cancel_nonstaged_reservation',l_module_name);
2548:
2549: --
2550: -- Debug Statements
2551: --

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

2696: END IF;
2697: -- KYH INVCONV END
2698:
2699: IF l_debug_on THEN
2700: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.RESERVATION_SPLIT_ACTION TO SPLIT : '|| L_QUANTITY_TO_SPLIT );
2701: END IF;
2702: --
2703: -- 2847687 : No More performing Update_Reservations per INV advice,
2704: -- So always calling Transfer Rsvtns.

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

2878: END IF;
2879: --
2880: WHEN others THEN
2881: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2882: wsh_util_core.default_handler('WSH_USA_INV_PVT.reservation_split_action',l_module_name);
2883: IF l_debug_on THEN
2884: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2885: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2886: END IF;

Line 2971: WSH_USA_INV_PVT.get_putaway_detail_id

2967: -- Debug Statements
2968: -- HW OPMCONV. Removed checking for OPM org
2969:
2970: --X-dock,split
2971: WSH_USA_INV_PVT.get_putaway_detail_id
2972: (p_detail_id => p_delivery_detail_split_rec.delivery_detail_id,
2973: p_released_status => p_delivery_detail_split_rec.released_status,
2974: p_move_order_line_id => p_delivery_detail_split_rec.move_order_line_id,
2975: x_detail_id => l_delivery_detail_id,

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

2988: --
2989: -- Debug Statements
2990: --
2991: IF l_debug_on THEN
2992: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.SPLIT_RESERVATION TO SPLIT : '|| P_SPLIT_QUANTITY );
2993: END IF;
2994: --
2995: --{
2996: IF p_delivery_detail_split_rec.released_status = 'S' THEN

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

3297: --
3298: -- bug 5226867
3299: WHEN others THEN
3300: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3301: wsh_util_core.default_handler('WSH_USA_INV_PVT.split_reservation',l_module_name);
3302:
3303: --
3304: -- Debug Statements
3305: --

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

3356: --
3357: -- Debug Statements
3358: --
3359: IF l_debug_on THEN
3360: WSH_DEBUG_SV.logmsg(l_module_name, 'IN WSH_USA_INV_PVT.UPDATE_SERIAL_NUMBERS' );
3361: END IF;
3362: --
3363: IF (p_serial_number IS NULL) AND (p_transaction_temp_id IS NULL) THEN
3364: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

3427: EXCEPTION
3428:
3429: WHEN OTHERS THEN
3430: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3431: WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.update_serial_numbers',l_module_name);
3432:
3433: --
3434: -- Debug Statements
3435: --

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

4424: --
4425: -- Debug Statements
4426: --
4427: IF l_debug_on THEN
4428: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_INV_PVT. BACKORDERED_DELIVERY_DETAIL' ,WSH_DEBUG_SV.C_PROC_LEVEL);
4429: END IF;
4430: --
4431: backorder_delivery_detail(
4432: p_delivery_detail_id => l_dummy_detail_id ,

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

5083: -- Debug Statements
5084: --
5085:
5086: IF l_debug_on THEN
5087: WSH_DEBUG_SV.log(l_module_name,'Calling program unit WSH_USA_INV_PVT. BACKORDERED_DELIVERY_DETAIL' ,WSH_DEBUG_SV.C_PROC_LEVEL);
5088: END IF;
5089: --
5090: --
5091: backorder_delivery_detail(

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

6078: --
6079: -- Debug Statements
6080: --
6081: IF l_debug_on THEN
6082: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_INV_PVT. BACKORDERED_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
6083: END IF;
6084: --
6085: --Bug# 5436033
6086: --do not calculate the qty2 convert from bo_Qty Cause this is like entering a new line

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

6418: --
6419:
6420: WHEN others THEN
6421: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6422: wsh_util_core.default_handler('WSH_USA_INV_PVT.Update_Inventory_Info',l_module_name);
6423: --
6424: -- LPN CONV rv
6425: WSH_WMS_LPN_GRP.g_caller := l_original_caller;
6426: WSH_WMS_LPN_GRP.g_callback_required := l_orig_callback_reqd;

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

6533: IF l_debug_on THEN
6534: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6535: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
6536: END IF;
6537: wsh_util_core.default_handler('WSH_USA_INV_PVT.get_detailed_quantity',l_module_name);
6538:
6539: END get_detailed_quantity;
6540:
6541: --

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

6593: IF l_debug_on THEN
6594: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6595: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
6596: END IF;
6597: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_INV_PVT.is_mo_type_putaway',l_module_name);
6598: RETURN 'N';
6599:
6600: END is_mo_type_putaway;
6601:

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

6666: --Check only for line with released_status = 'S' and MOL is not null and MO type = PUTAWAY
6667: IF p_detail_id IS NOT NULL AND
6668: l_released_status = WSH_DELIVERY_DETAILS_PKG.C_RELEASED_TO_WAREHOUSE AND
6669: l_move_order_line_id IS NOT NULL AND
6670: wsh_usa_inv_pvt.is_mo_type_putaway (l_move_order_line_id) = 'Y' THEN
6671: x_detail_id := p_detail_id;
6672: END IF;
6673:
6674: IF l_debug_on THEN

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

6682: IF c_get_line_details%ISOPEN THEN
6683: CLOSE c_get_line_details;
6684: END IF;
6685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6686: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_INV_PVT.get_putaway_detail_id',l_module_name);
6687: IF l_debug_on THEN
6688: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6689: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
6690: END IF;

Line 6693: END WSH_USA_INV_PVT;

6689: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
6690: END IF;
6691: END get_putaway_detail_id;
6692:
6693: END WSH_USA_INV_PVT;