DBA Data[Home] [Help]

APPS.WSH_FREIGHT_COST_TYPES_PVT dependencies on WSH_FREIGHT_COST_TYPES_PVT

Line 1: PACKAGE BODY WSH_FREIGHT_COST_TYPES_PVT AS

1: PACKAGE BODY WSH_FREIGHT_COST_TYPES_PVT AS
2: /* $Header: WSHFCTPB.pls 115.3 2002/11/13 20:08:08 nparikh ship $ */
3: -- Package internal global variables
4: g_Return_Status VARCHAR2(1);
5:

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

3: -- Package internal global variables
4: g_Return_Status VARCHAR2(1);
5:
6: --
7: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_FREIGHT_COST_TYPES_PVT';
8: --
9: PROCEDURE Create_Freight_Cost_Type(
10: p_freight_cost_type_info IN Freight_Cost_Type_Rec_Type
11: , x_rowid OUT NOCOPY VARCHAR2

Line 171: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.CREATE_FREIGHT_COST_TYPE');

167: END IF;
168: --
169: EXCEPTION
170: WHEN create_failure THEN
171: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.CREATE_FREIGHT_COST_TYPE');
172: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
173:
174: --
175: -- Debug Statements

Line 183: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.CREATE_FREIGHT_COST_TYPE');

179: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:CREATE_FAILURE');
180: END IF;
181: --
182: WHEN others THEN
183: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.CREATE_FREIGHT_COST_TYPE');
184: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
185:
186: --
187: -- Debug Statements

Line 282: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.UPDATE_FREIGHT_COST_TYPE');

278: END IF;
279: --
280: EXCEPTION
281: WHEN others THEN
282: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.UPDATE_FREIGHT_COST_TYPE');
283: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
284: --
285: -- Debug Statements
286: --

Line 433: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.LOCK_FREIGHT_COST_TYPE');

429: END IF;
430: --
431: EXCEPTION
432: WHEN others THEN
433: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.LOCK_FREIGHT_COST_TYPE');
434: --
435: -- Debug Statements
436: --
437: IF l_debug_on THEN

Line 517: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.DELETE_FREIGHT_COST_TYPE');

513: END IF;
514: --
515: EXCEPTION
516: WHEN row_not_found THEN
517: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.DELETE_FREIGHT_COST_TYPE');
518: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
519: --
520: -- Debug Statements
521: --

Line 528: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.DELETE_FREIGHT_COST_TYPE');

524: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:ROW_NOT_FOUND');
525: END IF;
526: --
527: WHEN others THEN
528: wsh_util_core.default_handler('WSH_FREIGHT_COST_TYPES_PVT.DELETE_FREIGHT_COST_TYPE');
529: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
530: --
531: -- Debug Statements
532: --

Line 540: END WSH_FREIGHT_COST_TYPES_PVT;

536: END IF;
537: --
538: END Delete_Freight_Cost_Type;
539:
540: END WSH_FREIGHT_COST_TYPES_PVT;