DBA Data[Home] [Help]

APPS.WSH_CARRIER_SHIP_METHODS_PKG dependencies on WSH_CARRIER_SHIP_METHODS_PKG

Line 1: PACKAGE BODY WSH_CARRIER_SHIP_METHODS_PKG as

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

Line 4: --- Package Name: WSH_CARRIER_SHIP_METHODS_PKG

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: --

Line 9: G_PKG_NAME CONSTANT VARCHAR2(50) := '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: --
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

Line 193: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Update_Carrier_Ship_Method', l_module_name);

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');

Line 418: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Lock_Carrier_Ship_Method',l_module_name);

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');

Line 559: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Update_Carrier_Ship_Method', l_module_name);

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);

Line 634: WSH_UTIL_CORE.Default_Handler('WSH_CARRIER_SHIP_METHODS_PKG.Delete_Carrier_Ship_Method',l_module_name);

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);

Line 645: END WSH_CARRIER_SHIP_METHODS_PKG;

641: --
642: END Delete_Carrier_Ship_Method;
643:
644:
645: END WSH_CARRIER_SHIP_METHODS_PKG;