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_ACTIONS_PVT dependencies on WSH_USA_ACTIONS_PVT

Line 1: PACKAGE BODY WSH_USA_ACTIONS_PVT as

1: PACKAGE BODY WSH_USA_ACTIONS_PVT as
2: /* $Header: WSHUSAAB.pls 120.38.12020000.6 2013/05/30 13:28:25 skanduku ship $ */
3:
4: -- Start of body implementations
5:

Line 8: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_USA_ACTIONS_PVT';

4: -- Start of body implementations
5:
6:
7: --
8: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_USA_ACTIONS_PVT';
9: --
10: PROCEDURE Import_Records(
11: p_source_code IN VARCHAR2,
12: p_changed_attributes IN WSH_INTERFACE.ChangedAttributeTabType,

Line 131: wsh_util_core.default_handler('WSH_USA_ACTIONS_PVT.Import_Records',l_module_name);

127: --
128: EXCEPTION
129: WHEN OTHERS THEN
130: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
131: wsh_util_core.default_handler('WSH_USA_ACTIONS_PVT.Import_Records',l_module_name);
132: --
133: IF l_debug_on THEN
134: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
135: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 315: p_split_lines IN WSH_USA_ACTIONS_PVT.split_Table_Tab_type ,

311: p_source_code IN VARCHAR2,
312: p_changed_attributes IN WSH_INTERFACE.ChangedAttributeTabType,
313: p_interface_flag IN VARCHAR2,
314: p_index_tab IN WSH_UTIL_CORE.ID_Tab_Type ,
315: p_split_lines IN WSH_USA_ACTIONS_PVT.split_Table_Tab_type ,
316: x_return_status OUT NOCOPY VARCHAR2
317: ) IS
318:
319: -- cursor to calculate the total requested quantity for the original source_line_id .

Line 457: l_cancel_Reservation_Tab_Type WSH_USA_ACTIONS_PVT.Cancel_Reservation_Tab_Type; --bugfix 8915868

453:
454: l_detail_inv_rec WSH_USA_INV_PVT.DeliveryDetailInvRecType;
455: l_detail_info WSH_DELIVERY_DETAILS_ACTIONS.SplitDetailRecType;
456:
457: l_cancel_Reservation_Tab_Type WSH_USA_ACTIONS_PVT.Cancel_Reservation_Tab_Type; --bugfix 8915868
458: l_cancel_counter NUMBER :=0 ; --bugfix 8915868
459:
460: l_uom_converted BOOLEAN;
461: l_counter NUMBER;

Line 1732: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_ACTIONS_PVT.Split_Records_Int',l_module_name);

1728: EXCEPTION
1729: WHEN OTHERS THEN
1730: ROLLBACK TO before_splits;
1731: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1732: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_ACTIONS_PVT.Split_Records_Int',l_module_name);
1733: --
1734: IF l_debug_on THEN
1735: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1736: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1906: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_ACTIONS_PVT.Split_records ');

1902: --
1903: EXCEPTION
1904:
1905: WHEN others THEN
1906: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_ACTIONS_PVT.Split_records ');
1907: IF l_debug_on THEN
1908: WSH_DEBUG_SV.logmsg(l_module_name,SQLCODE || ' : ' || SQLERRM );
1909: END IF;
1910: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1987: WSH_USA_ACTIONS_PVT.Update_Attributes(

1983: --
1984: END IF; -- p_interface_flag = 'Y'
1985:
1986: IF l_update_allowed = 'Y' THEN
1987: WSH_USA_ACTIONS_PVT.Update_Attributes(
1988: p_source_code => p_source_code,
1989: p_attributes_rec => p_changed_attributes(l_counter),
1990: p_changed_detail => l_changed_detail,
1991: p_interface_flag => p_interface_flag, --bugfix 10175902

Line 1999: WSH_DEBUG_SV.logmsg(l_module_name, 'AFTER CALLING WSH_USA_ACTIONS_PVT.UPDATE_ATTRIBUTES ' || L_RS );

1995: EXIT records_loop;
1996: END IF;
1997: --
1998: IF l_debug_on THEN
1999: WSH_DEBUG_SV.logmsg(l_module_name, 'AFTER CALLING WSH_USA_ACTIONS_PVT.UPDATE_ATTRIBUTES ' || L_RS );
2000: END IF;
2001: --
2002: END IF; -- l_update_allowed = 'Y'
2003:

Line 2018: wsh_util_core.default_handler('WSH_USA_ACTIONS_PVT.Update_Records',l_module_name);

2014: --
2015: EXCEPTION
2016: WHEN OTHERS THEN
2017: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2018: wsh_util_core.default_handler('WSH_USA_ACTIONS_PVT.Update_Records',l_module_name);
2019: --
2020: IF l_debug_on THEN
2021: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2022: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4166: WSH_DEBUG_SV.logmsg(l_module_name, 'IN LOCK LINE ID EXCEPTION: WSH_USA_ACTIONS_PVT.IMPORT_DELIVERY_DETAILS' );

4162: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
4163: -- some one else is currently working on this line id
4164: --
4165: IF l_debug_on THEN
4166: WSH_DEBUG_SV.logmsg(l_module_name, 'IN LOCK LINE ID EXCEPTION: WSH_USA_ACTIONS_PVT.IMPORT_DELIVERY_DETAILS' );
4167: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION: ' || SQLERRM );
4168: END IF;
4169: --
4170: wsh_util_core.default_handler('WSH_USA_ACTIONS_PVT.IMPORT_DELIVERY_DETAILS',l_module_name);

Line 4170: wsh_util_core.default_handler('WSH_USA_ACTIONS_PVT.IMPORT_DELIVERY_DETAILS',l_module_name);

4166: WSH_DEBUG_SV.logmsg(l_module_name, 'IN LOCK LINE ID EXCEPTION: WSH_USA_ACTIONS_PVT.IMPORT_DELIVERY_DETAILS' );
4167: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION: ' || SQLERRM );
4168: END IF;
4169: --
4170: wsh_util_core.default_handler('WSH_USA_ACTIONS_PVT.IMPORT_DELIVERY_DETAILS',l_module_name);
4171: IF C_OE_LINES_REC_LOCK%ISOPEN THEN
4172: CLOSE C_OE_LINES_REC_LOCK;
4173: END IF;
4174: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 4271: wsh_util_core.default_handler('WSH_USA_ACTIONS_PVT.IMPORT_DELIVERY_DETAILS',l_module_name);

4267: IF l_debug_on THEN
4268: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION: OTHERS ' || SQLERRM );
4269: END IF;
4270: --
4271: wsh_util_core.default_handler('WSH_USA_ACTIONS_PVT.IMPORT_DELIVERY_DETAILS',l_module_name);
4272: IF C_OE_LINES_REC_LOCK%ISOPEN THEN
4273: CLOSE C_OE_LINES_REC_LOCK;
4274: END IF;
4275: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 4329: wsh_util_core.default_handler('WSH_USA_ACTIONS_PVT.IMPORT_DELIVERY_DETAILS',l_module_name);

4325: END IF;
4326: WSH_UTIL_CORE.add_message ('E',l_module_name);
4327: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4328: when others THEN
4329: wsh_util_core.default_handler('WSH_USA_ACTIONS_PVT.IMPORT_DELIVERY_DETAILS',l_module_name);
4330: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4331: --
4332: IF C_OE_LINES_REC_LOCK%ISOPEN THEN
4333: CLOSE C_OE_LINES_REC_LOCK;

Line 4350: END WSH_USA_ACTIONS_PVT;

4346: --
4347: END Import_Delivery_Details;
4348:
4349:
4350: END WSH_USA_ACTIONS_PVT;