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.21 2008/01/23 15:19:43 sunilku 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 1446: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_ACTIONS_PVT.Split_Records_Int',l_module_name);

1442: EXCEPTION
1443: WHEN OTHERS THEN
1444: ROLLBACK TO before_splits;
1445: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1446: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_ACTIONS_PVT.Split_Records_Int',l_module_name);
1447: --
1448: IF l_debug_on THEN
1449: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1450: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

1610:
1611: EXCEPTION
1612:
1613: WHEN others THEN
1614: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_USA_ACTIONS_PVT.Split_records ');
1615: IF l_debug_on THEN
1616: WSH_DEBUG_SV.logmsg(l_module_name,SQLCODE || ' : ' || SQLERRM );
1617: END IF;
1618: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1695: WSH_USA_ACTIONS_PVT.Update_Attributes(

1691: --
1692: END IF; -- p_interface_flag = 'Y'
1693:
1694: IF l_update_allowed = 'Y' THEN
1695: WSH_USA_ACTIONS_PVT.Update_Attributes(
1696: p_source_code => p_source_code,
1697: p_attributes_rec => p_changed_attributes(l_counter),
1698: p_changed_detail => l_changed_detail,
1699: x_return_status => l_rs);

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

1702: EXIT records_loop;
1703: END IF;
1704: --
1705: IF l_debug_on THEN
1706: WSH_DEBUG_SV.logmsg(l_module_name, 'AFTER CALLING WSH_USA_ACTIONS_PVT.UPDATE_ATTRIBUTES ' || L_RS );
1707: END IF;
1708: --
1709: END IF; -- l_update_allowed = 'Y'
1710:

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

1721: --
1722: EXCEPTION
1723: WHEN OTHERS THEN
1724: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1725: wsh_util_core.default_handler('WSH_USA_ACTIONS_PVT.Update_Records',l_module_name);
1726: --
1727: IF l_debug_on THEN
1728: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1729: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

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

3846: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
3847: -- some one else is currently working on this line id
3848: --
3849: IF l_debug_on THEN
3850: WSH_DEBUG_SV.logmsg(l_module_name, 'IN LOCK LINE ID EXCEPTION: WSH_USA_ACTIONS_PVT.IMPORT_DELIVERY_DETAILS' );
3851: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION: ' || SQLERRM );
3852: END IF;
3853: --
3854: wsh_util_core.default_handler('WSH_USA_ACTIONS_PVT.IMPORT_DELIVERY_DETAILS',l_module_name);

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

3850: WSH_DEBUG_SV.logmsg(l_module_name, 'IN LOCK LINE ID EXCEPTION: WSH_USA_ACTIONS_PVT.IMPORT_DELIVERY_DETAILS' );
3851: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION: ' || SQLERRM );
3852: END IF;
3853: --
3854: wsh_util_core.default_handler('WSH_USA_ACTIONS_PVT.IMPORT_DELIVERY_DETAILS',l_module_name);
3855: IF C_OE_LINES_REC_LOCK%ISOPEN THEN
3856: CLOSE C_OE_LINES_REC_LOCK;
3857: END IF;
3858: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

3951: IF l_debug_on THEN
3952: WSH_DEBUG_SV.logmsg(l_module_name, 'EXCEPTION: OTHERS ' || SQLERRM );
3953: END IF;
3954: --
3955: wsh_util_core.default_handler('WSH_USA_ACTIONS_PVT.IMPORT_DELIVERY_DETAILS',l_module_name);
3956: IF C_OE_LINES_REC_LOCK%ISOPEN THEN
3957: CLOSE C_OE_LINES_REC_LOCK;
3958: END IF;
3959: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

4009: END IF;
4010: WSH_UTIL_CORE.add_message ('E',l_module_name);
4011: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4012: when others THEN
4013: wsh_util_core.default_handler('WSH_USA_ACTIONS_PVT.IMPORT_DELIVERY_DETAILS',l_module_name);
4014: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4015: --
4016: IF C_OE_LINES_REC_LOCK%ISOPEN THEN
4017: CLOSE C_OE_LINES_REC_LOCK;

Line 4034: END WSH_USA_ACTIONS_PVT;

4030: --
4031: END Import_Delivery_Details;
4032:
4033:
4034: END WSH_USA_ACTIONS_PVT;