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_FREIGHT_COSTS_PVT dependencies on WSH_FREIGHT_COSTS_PVT

Line 1: PACKAGE BODY WSH_FREIGHT_COSTS_PVT AS

1: PACKAGE BODY WSH_FREIGHT_COSTS_PVT AS
2: /* $Header: WSHFCTHB.pls 120.2 2007/12/17 06:52:21 brana noship $ */
3: -- Package internal global variables
4: g_Return_Status VARCHAR2(1);
5:

Line 7: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_FREIGHT_COSTS_PVT';

3: -- Package internal global variables
4: g_Return_Status VARCHAR2(1);
5:
6: --
7: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_FREIGHT_COSTS_PVT';
8: --
9:
10: PROCEDURE Create_Freight_Cost(
11: p_freight_cost_info IN Freight_Cost_Rec_Type

Line 199: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_PVT.CREATE_FREIGHT_COST');

195: END IF;
196: --
197: EXCEPTION
198: WHEN create_failure THEN
199: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_PVT.CREATE_FREIGHT_COST');
200: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
201:
202: --
203: -- Debug Statements

Line 370: wsh_util_core.default_handler ('WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost');

366: --
367: EXCEPTION
368: WHEN OTHERS THEN
369: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
370: wsh_util_core.default_handler ('WSH_FREIGHT_COSTS_PVT.Update_Freight_Cost');
371: IF l_debug_on THEN
372: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
373: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
374: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 735: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_PVT.DELETE_FREIGHT_COST');

731: END IF;
732: --
733: EXCEPTION
734: WHEN others THEN
735: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_PVT.DELETE_FREIGHT_COST');
736: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
737: --
738: -- Debug Statements
739: --

Line 955: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_PVT.SPLIT_FREIGHT_COST');

951: --
952: EXCEPTION
953:
954: WHEN WSH_FC_NOT_FOUND THEN
955: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_PVT.SPLIT_FREIGHT_COST');
956: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
957:
958: --
959: -- Debug Statements

Line 1140: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Total_Freight_Cost');

1136:
1137: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1138:
1139: x_total_amount := NULL;
1140: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Total_Freight_Cost');
1141:
1142: IF l_debug_on THEN
1143: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
1144: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1272: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_detail_Freight_Cost');

1268:
1269: WHEN OTHERS THEN
1270: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1271: x_detail_amount := NULL;
1272: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_detail_Freight_Cost');
1273: IF l_debug_on THEN
1274: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1275: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1276: END IF;

Line 1436: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_LPN_Freight_Cost');

1432: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1433: x_main_lpn_amount := NULL;
1434: x_lpn_amount := NULL;
1435: x_detail_amount := NULL;
1436: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_LPN_Freight_Cost');
1437: IF l_debug_on THEN
1438: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1439: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1440: END IF;

Line 1654: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_delivery_Freight_Cost');

1650: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1651: x_delivery_amount := NULL;
1652: x_lpn_amount := NULL;
1653: x_detail_amount := NULL;
1654: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_delivery_Freight_Cost');
1655: IF l_debug_on THEN
1656: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1657: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1658: END IF;

Line 1801: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_stop_Freight_Cost');

1797:
1798: WHEN OTHERS THEN
1799: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1800: x_stop_amount := NULL;
1801: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_stop_Freight_Cost');
1802: IF l_debug_on THEN
1803: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1804: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1805: END IF;

Line 2034: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Trip_Freight_Cost');

2030: x_stop_amount := NULL;
2031: x_delivery_amount := NULL;
2032: x_lpn_amount := NULL;
2033: x_detail_amount := NULL;
2034: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Trip_Freight_Cost');
2035: IF l_debug_on THEN
2036: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2037: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2038: END IF;

Line 2186: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Total_Freight_Cost');

2182: x_stop_amount := NULL;
2183: x_delivery_amount := NULL;
2184: x_lpn_amount := NULL;
2185: x_detail_amount := NULL;
2186: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Total_Freight_Cost');
2187:
2188: IF l_debug_on THEN
2189: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2190: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2344: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Summary_Freight_Cost');

2340:
2341: WHEN OTHERS THEN
2342:
2343: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2344: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Summary_Freight_Cost');
2345:
2346: IF l_debug_on THEN
2347: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2348: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2603: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Convert_Amount');

2599: IF l_debug_on THEN
2600: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||
2601: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2602: END IF;
2603: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Convert_Amount');
2604:
2605: END Convert_Amount;
2606:
2607:

Line 2684: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_PVT.Remove_FTE_Freight_Costs',l_module_name);

2680:
2681: WHEN OTHERS THEN
2682:
2683: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2684: wsh_util_core.default_handler('WSH_FREIGHT_COSTS_PVT.Remove_FTE_Freight_Costs',l_module_name);
2685: ROLLBACK TO before_delete;
2686: --
2687: IF l_debug_on THEN
2688: WSH_DEBUG_SV.logmsg(l_module_name,'Cannot lock the fright cost records '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2815: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Trip_Freight_Cost');

2811:
2812: WHEN OTHERS THEN
2813: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2814: x_trip_amount := NULL;
2815: WSH_UTIL_CORE.Default_Handler('WSH_FREIGHT_COSTS_PVT.Get_Trip_Freight_Cost');
2816: IF l_debug_on THEN
2817: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2818: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2819: END IF;

Line 2825: END WSH_FREIGHT_COSTS_PVT;

2821: END Get_Trip_Manual_Freight_Cost;
2822:
2823: /************************************************************************/
2824:
2825: END WSH_FREIGHT_COSTS_PVT;