1: PACKAGE BODY WSH_CARRIER_SHIP_METHODS_PKG as
2: /* $Header: WSHCSTHB.pls 115.14 2002/11/18 20:12:26 nparikh ship $ */
3:
4: --- Package Name: WSH_CARRIER_SHIP_METHODS_PKG
5: --- Pupose: Table Handlers for table WSH_CARRIER_SHIP_METHODS
1: PACKAGE BODY WSH_CARRIER_SHIP_METHODS_PKG as
2: /* $Header: WSHCSTHB.pls 115.14 2002/11/18 20:12:26 nparikh ship $ */
3:
4: --- Package Name: WSH_CARRIER_SHIP_METHODS_PKG
5: --- Pupose: Table Handlers for table WSH_CARRIER_SHIP_METHODS
6: --- Note: Please set tabstop=3 to read file with proper alignment
7:
8: --
5: --- Pupose: Table Handlers for table WSH_CARRIER_SHIP_METHODS
6: --- Note: Please set tabstop=3 to read file with proper alignment
7:
8: --
9: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_CARRIER_SHIP_METHODS_PKG';
10: --
11: PROCEDURE Create_Carrier_Ship_Method(
12: p_Carrier_Ship_Method_Info IN CSMRecType
13: , x_Rowid OUT NOCOPY VARCHAR2
189: --
190: EXCEPTION
191: WHEN others THEN
192: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
193: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Update_Carrier_Ship_Method', l_module_name);
194: --
195: IF l_debug_on THEN
196: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
197: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
414: --
415: EXCEPTION
416: WHEN others THEN
417: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
418: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Lock_Carrier_Ship_Method',l_module_name);
419: --
420: IF l_debug_on THEN
421: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
422: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
555: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
556: END IF;
557: --
558: WHEN others THEN
559: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Update_Carrier_Ship_Method', l_module_name);
560: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
561: --
562: IF l_debug_on THEN
563: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
630: END IF;
631: --
632: EXCEPTION
633: WHEN others THEN
634: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Delete_Carrier_Ship_Method',l_module_name);
635: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
636: --
637: IF l_debug_on THEN
638: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
641: --
642: END Delete_Carrier_Ship_Method;
643:
644:
645: END WSH_CARRIER_SHIP_METHODS_PKG;