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_INBOUND_UTIL_PKG dependencies on WSH_INBOUND_UTIL_PKG

Line 1: PACKAGE BODY WSH_INBOUND_UTIL_PKG as

1: PACKAGE BODY WSH_INBOUND_UTIL_PKG as
2: /* $Header: WSHIBUTB.pls 120.6 2005/09/13 17:20:27 rvishnuv noship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_INBOUND_UTIL_PKG';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_INBOUND_UTIL_PKG';

1: PACKAGE BODY WSH_INBOUND_UTIL_PKG as
2: /* $Header: WSHIBUTB.pls 120.6 2005/09/13 17:20:27 rvishnuv noship $ */
3:
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_INBOUND_UTIL_PKG';
6:
7: --========================================================================
8: -- PROCEDURE : Copy_Po_Rec_To_Line_Rec This procedure is used to copy
9: -- all the attributes into x_line_rec

Line 530: wsh_util_core.default_handler('WSH_INBOUND_UTIL_PKG.COPY_PO_REC_TO_LINE_REC');

526: END IF;
527: --
528: WHEN OTHERS THEN
529: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
530: wsh_util_core.default_handler('WSH_INBOUND_UTIL_PKG.COPY_PO_REC_TO_LINE_REC');
531: --}
532: --
533: -- Debug Statements
534: --

Line 724: wsh_util_core.default_handler('WSH_INBOUND_UTIL_PKG.GET_RCV_LINE_ATTRIBS');

720: END IF;
721: --
722: WHEN OTHERS THEN
723: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
724: wsh_util_core.default_handler('WSH_INBOUND_UTIL_PKG.GET_RCV_LINE_ATTRIBS');
725: --}
726: --
727: -- Debug Statements
728: --

Line 954: wsh_util_core.default_handler('WSH_INBOUND_UTIL_PKG.GET_PO_RCV_ATTRIBUTES');

950: END IF;
951: --
952: WHEN OTHERS THEN
953: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
954: wsh_util_core.default_handler('WSH_INBOUND_UTIL_PKG.GET_PO_RCV_ATTRIBUTES');
955: --}
956: --
957: -- Debug Statements
958: --

Line 1810: -- by the Global variable WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE.

1806: -- when the Receipt of the input Delivery was matched automatically.
1807: -- Rating is done asynchronoulsy (by FND_REQUEST.SUBMIT_REQUEST)
1808: -- when the Receipt of the input Delivery was matched Manually.
1809: -- This (inline Rating or asynchronous rating) is determined
1810: -- by the Global variable WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE.
1811: --
1812: -- Hence forth (R12 onwards) if a new Exception Handler is added for this API
1813: -- or any other new return points are added, then care should be taken
1814: -- to set Global variable WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE

Line 1814: -- to set Global variable WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE

1810: -- by the Global variable WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE.
1811: --
1812: -- Hence forth (R12 onwards) if a new Exception Handler is added for this API
1813: -- or any other new return points are added, then care should be taken
1814: -- to set Global variable WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE
1815: -- to null.
1816: --========================================================================
1817: --
1818: PROCEDURE reRateDeliveries

Line 1889: IF nvl(WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE,'MANUAL') = 'MANUAL'

1885: l_num_errors := 0;
1886: --
1887: --
1888: -- { IB-Phase-2
1889: IF nvl(WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE,'MANUAL') = 'MANUAL'
1890: THEN
1891: --{
1892: l_index := p_delivery_id_tab.FIRST;
1893: --

Line 2017: ELSE -- IF WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE = 'AUTO'

2013: --}
2014: END IF;
2015: --}
2016: --
2017: ELSE -- IF WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE = 'AUTO'
2018: --{
2019: l_index := p_delivery_id_tab.FIRST;
2020: --
2021: WHILE l_index IS NOT NULL

Line 2142: WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE := null;

2138: END IF;
2139:
2140: END IF;
2141: --
2142: WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE := null;
2143: -- } IB-Phase-2
2144: --
2145: IF l_num_errors > 0
2146: THEN

Line 2170: WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE := null; -- IB-Phase-2

2166: WHEN FND_API.G_EXC_ERROR THEN
2167:
2168: --ROLLBACK TO open_stop_begin_sp;
2169: --
2170: WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE := null; -- IB-Phase-2
2171: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
2172: --
2173: IF l_debug_on THEN
2174: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2182: WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE := null; -- IB-Phase-2

2178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2179:
2180: --ROLLBACK TO open_stop_begin_sp;
2181: --
2182: WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE := null; -- IB-Phase-2
2183: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2184: --
2185: IF l_debug_on THEN
2186: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2191: WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE := null; -- IB-Phase-2

2187: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2188: END IF;
2189: --
2190: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2191: WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE := null; -- IB-Phase-2
2192: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2193: --
2194: IF l_debug_on THEN
2195: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 2199: wsh_util_core.default_handler('WSH_INBOUND_UTIL_PKG.reRateDeliveries',l_module_name);

2195: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2196: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2197: END IF;
2198: WHEN others THEN
2199: wsh_util_core.default_handler('WSH_INBOUND_UTIL_PKG.reRateDeliveries',l_module_name);
2200: --
2201: --ROLLBACK TO open_stop_begin_sp;
2202: --
2203: WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE := null; -- IB-Phase-2

Line 2203: WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE := null; -- IB-Phase-2

2199: wsh_util_core.default_handler('WSH_INBOUND_UTIL_PKG.reRateDeliveries',l_module_name);
2200: --
2201: --ROLLBACK TO open_stop_begin_sp;
2202: --
2203: WSH_INBOUND_UTIL_PKG.G_ASN_RECEIPT_MATCH_TYPE := null; -- IB-Phase-2
2204: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2205: --
2206: -- Debug Statements
2207: --

Line 2441: wsh_util_core.default_handler('WSH_INBOUND_UTIL_PKG.processStop',l_module_name);

2437: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2438: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2439: END IF;
2440: WHEN others THEN
2441: wsh_util_core.default_handler('WSH_INBOUND_UTIL_PKG.processStop',l_module_name);
2442: --
2443: --ROLLBACK TO open_stop_begin_sp;
2444: --
2445: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2715: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.processStop',WSH_DEBUG_SV.C_PROC_LEVEL);

2711: END IF;
2712: --
2713: --
2714: IF l_debug_on THEN
2715: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.processStop',WSH_DEBUG_SV.C_PROC_LEVEL);
2716: END IF;
2717: --
2718: --
2719: WSH_INBOUND_UTIL_PKG.processStop

Line 2719: WSH_INBOUND_UTIL_PKG.processStop

2715: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.processStop',WSH_DEBUG_SV.C_PROC_LEVEL);
2716: END IF;
2717: --
2718: --
2719: WSH_INBOUND_UTIL_PKG.processStop
2720: (
2721: p_stop_id => first_leg_rec.pu_stop_id,
2722: p_status_code => first_leg_rec.pu_stop_statusCode,
2723: p_shipements_type_flag => first_leg_rec.pu_stop_shipTypeFlag,

Line 2755: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.processStop',WSH_DEBUG_SV.C_PROC_LEVEL);

2751: IF l_stop_processed = 'Y'
2752: THEN
2753: --{
2754: IF l_debug_on THEN
2755: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.processStop',WSH_DEBUG_SV.C_PROC_LEVEL);
2756: END IF;
2757: --
2758: --
2759: WSH_INBOUND_UTIL_PKG.processStop

Line 2759: WSH_INBOUND_UTIL_PKG.processStop

2755: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.processStop',WSH_DEBUG_SV.C_PROC_LEVEL);
2756: END IF;
2757: --
2758: --
2759: WSH_INBOUND_UTIL_PKG.processStop
2760: (
2761: p_stop_id => first_leg_rec.do_stop_id,
2762: p_status_code => first_leg_rec.do_stop_statusCode,
2763: p_shipements_type_flag => first_leg_rec.do_stop_shipTypeFlag,

Line 2823: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.processStop',WSH_DEBUG_SV.C_PROC_LEVEL);

2819:
2820: --Bug 3410681 fixed
2821:
2822: IF l_debug_on THEN
2823: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.processStop',WSH_DEBUG_SV.C_PROC_LEVEL);
2824: END IF;
2825: --
2826: --
2827: WSH_INBOUND_UTIL_PKG.processStop

Line 2827: WSH_INBOUND_UTIL_PKG.processStop

2823: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.processStop',WSH_DEBUG_SV.C_PROC_LEVEL);
2824: END IF;
2825: --
2826: --
2827: WSH_INBOUND_UTIL_PKG.processStop
2828: (
2829: p_stop_id => next_leg_rec.pu_stop_id,
2830: p_status_code => next_leg_rec.pu_stop_statusCode,
2831: p_shipements_type_flag => next_leg_rec.pu_stop_shipTypeFlag,

Line 2862: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.processStop',WSH_DEBUG_SV.C_PROC_LEVEL);

2858: IF l_stop_processed = 'Y'
2859: THEN
2860: --{
2861: IF l_debug_on THEN
2862: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.processStop',WSH_DEBUG_SV.C_PROC_LEVEL);
2863: END IF;
2864: --
2865: --
2866: WSH_INBOUND_UTIL_PKG.processStop

Line 2866: WSH_INBOUND_UTIL_PKG.processStop

2862: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.processStop',WSH_DEBUG_SV.C_PROC_LEVEL);
2863: END IF;
2864: --
2865: --
2866: WSH_INBOUND_UTIL_PKG.processStop
2867: (
2868: p_stop_id => next_leg_rec.do_stop_id,
2869: p_status_code => next_leg_rec.do_stop_statusCode,
2870: p_shipements_type_flag => next_leg_rec.do_stop_shipTypeFlag,

Line 2987: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.reRateDeliveries',WSH_DEBUG_SV.C_PROC_LEVEL);

2983: END IF;
2984: --
2985: --
2986: IF l_debug_on THEN
2987: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.reRateDeliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
2988: END IF;
2989: --
2990: --
2991: WSH_INBOUND_UTIL_PKG.reRateDeliveries

Line 2991: WSH_INBOUND_UTIL_PKG.reRateDeliveries

2987: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_INBOUND_UTIL_PKG.reRateDeliveries',WSH_DEBUG_SV.C_PROC_LEVEL);
2988: END IF;
2989: --
2990: --
2991: WSH_INBOUND_UTIL_PKG.reRateDeliveries
2992: (
2993: p_delivery_id_tab => p_delivery_id_tab,
2994: x_return_status => l_return_status
2995: );

Line 3121: wsh_util_core.default_handler('WSH_INBOUND_UTIL_PKG.setTripStopStatus',l_module_name);

3117: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
3118: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
3119: END IF;
3120: WHEN others THEN
3121: wsh_util_core.default_handler('WSH_INBOUND_UTIL_PKG.setTripStopStatus',l_module_name);
3122: --
3123: --ROLLBACK TO open_stop_begin_sp;
3124: --
3125: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 3267: WSH_UTIL_CORE.Default_Handler('WSH_INBOUND_UTIL_PKG.convert_quantity',l_module_name);

3263:
3264: EXCEPTION
3265: WHEN OTHERS THEN
3266: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3267: WSH_UTIL_CORE.Default_Handler('WSH_INBOUND_UTIL_PKG.convert_quantity',l_module_name);
3268: IF l_debug_on THEN
3269: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3270: END IF;
3271:

Line 3393: WSH_UTIL_CORE.Default_Handler('WSH_INBOUND_UTIL_PKG.GET_OUTERMOST_LPN',l_module_name);

3389:
3390: EXCEPTION
3391: WHEN OTHERS THEN
3392: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3393: WSH_UTIL_CORE.Default_Handler('WSH_INBOUND_UTIL_PKG.GET_OUTERMOST_LPN',l_module_name);
3394: IF l_debug_on THEN
3395: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3396: END IF;
3397:

Line 3454: END WSH_INBOUND_UTIL_PKG;

3450: RETURN false;
3451: END Is_Routing_Response_Send;
3452: --HACMS }
3453:
3454: END WSH_INBOUND_UTIL_PKG;