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_SHIPMENT_REQUEST_PKG dependencies on WSH_SHIPMENT_REQUEST_PKG

Line 1: PACKAGE BODY WSH_SHIPMENT_REQUEST_PKG AS

1: PACKAGE BODY WSH_SHIPMENT_REQUEST_PKG AS
2: /* $Header: WSHSRPKB.pls 120.7 2010/09/06 09:58:45 selsubra noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_SHIPMENT_REQUEST_PKG';
5: g_interface_action_code WSH_NEW_DEL_INTERFACE.INTERFACE_ACTION_CODE%TYPE;

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_SHIPMENT_REQUEST_PKG';

1: PACKAGE BODY WSH_SHIPMENT_REQUEST_PKG AS
2: /* $Header: WSHSRPKB.pls 120.7 2010/09/06 09:58:45 selsubra noship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_SHIPMENT_REQUEST_PKG';
5: g_interface_action_code WSH_NEW_DEL_INTERFACE.INTERFACE_ACTION_CODE%TYPE;
6: g_po_total_time NUMBER := 0;
7: g_sold_to_ref VARCHAR2(50) := 'CUST-SOLD-TO-REF';
8: g_ship_to_ref VARCHAR2(50) := 'CUST-SHIP-TO-REF';

Line 2774: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Get_Standalone_Defaults');

2770: --
2771: EXCEPTION
2772: WHEN OTHERS THEN
2773: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2774: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Get_Standalone_Defaults');
2775: IF c_delivery_interface_rec%ISOPEN THEN
2776: close c_delivery_interface_rec;
2777: END IF;
2778: --

Line 2883: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Check_Header_Exists');

2879: --
2880: EXCEPTION
2881: WHEN OTHERS THEN
2882: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2883: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Check_Header_Exists');
2884: IF c_order_info%ISOPEN THEN
2885: close c_order_info;
2886: END IF;
2887: --

Line 3019: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Check_Line_Exists');

3015: --
3016: EXCEPTION
3017: WHEN OTHERS THEN
3018: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3019: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Check_Line_Exists');
3020: --
3021: IF l_debug_on THEN
3022: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3023: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3191: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Lock_SR_Lines');

3187: END IF;
3188: --
3189: WHEN OTHERS THEN
3190: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3191: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Lock_SR_Lines');
3192: WSH_UTIL_CORE.add_message (x_return_status);
3193: --
3194: IF l_debug_on THEN
3195: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3766: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Validate_Delivery_Line');

3762: --
3763: EXCEPTION
3764: WHEN OTHERS THEN
3765: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3766: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Validate_Delivery_Line');
3767: --
3768: IF l_debug_on THEN
3769: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3770: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3981: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Print_OE_Header_Record');

3977: END IF;
3978: --
3979: EXCEPTION
3980: WHEN OTHERS THEN
3981: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Print_OE_Header_Record');
3982: --
3983: IF l_debug_on THEN
3984: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3985: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4126: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Print_OE_Line_Record');

4122: END IF;
4123: --
4124: EXCEPTION
4125: WHEN OTHERS THEN
4126: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Print_OE_Line_Record');
4127: --
4128: IF l_debug_on THEN
4129: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4130: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 4838: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Check_Header_Attr_Changed');

4834: --
4835: EXCEPTION
4836: WHEN OTHERS THEN
4837: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4838: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Check_Header_Attr_Changed');
4839: --
4840: IF l_debug_on THEN
4841: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4842: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5335: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Populate_OM_Common_Attr');

5331: --
5332: EXCEPTION
5333: WHEN OTHERS THEN
5334: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5335: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Populate_OM_Common_Attr');
5336: --
5337: IF l_debug_on THEN
5338: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5339: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5480: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Populate_Header_Rec');

5476: --
5477: EXCEPTION
5478: WHEN OTHERS THEN
5479: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5480: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Populate_Header_Rec');
5481: --
5482: IF l_debug_on THEN
5483: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5484: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5876: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Derive_Header_Rec');

5872: --
5873: EXCEPTION
5874: WHEN OTHERS THEN
5875: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5876: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Derive_Header_Rec');
5877: --
5878: IF l_debug_on THEN
5879: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
5880: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 6331: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Derive_Line_Rec');

6327: IF c_del_details_interface_rec%ISOPEN THEN
6328: close c_del_details_interface_rec;
6329: END IF;
6330: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6331: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Derive_Line_Rec');
6332: --
6333: IF l_debug_on THEN
6334: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6335: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 6631: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Populate_Line_Records');

6627: --
6628: EXCEPTION
6629: WHEN OTHERS THEN
6630: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6631: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Populate_Line_Records');
6632: --
6633: IF l_debug_on THEN
6634: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6635: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 6754: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Validate_Organization');

6750: --
6751: EXCEPTION
6752: WHEN OTHERS THEN
6753: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6754: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Validate_Organization');
6755: --
6756: IF l_debug_on THEN
6757: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6758: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 6898: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Validate_Ship_Method');

6894: --
6895: EXCEPTION
6896: WHEN OTHERS THEN
6897: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6898: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Validate_Ship_Method');
6899: --
6900: IF l_debug_on THEN
6901: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6902: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 6982: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Populate_Error_Records');

6978: --
6979: EXCEPTION
6980: WHEN OTHERS THEN
6981: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6982: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Populate_Error_Records');
6983: --
6984: IF l_debug_on THEN
6985: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6986: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 7396: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Validate_Interface_Details');

7392: CLOSE c_delivery_details_info;
7393: END IF;
7394:
7395: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
7396: WSH_UTIL_CORE.Default_Handler('WSH_SHIPMENT_REQUEST_PKG.Validate_Interface_Details');
7397: --
7398: IF l_debug_on THEN
7399: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
7400: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 7405: END WSH_SHIPMENT_REQUEST_PKG;

7401: END IF;
7402: --
7403: END Validate_Interface_Details;
7404:
7405: END WSH_SHIPMENT_REQUEST_PKG;