DBA Data[Home] [Help]

APPS.WSH_FREIGHT_COST_TYPES_PVT dependencies on WSH_UTIL_CORE

Line 55: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

51: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.CURRENCY_CODE',p_freight_cost_type_info.currency_code);
52: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.CHARGE_MAP_FLAG',p_freight_cost_type_info.charge_map_flag);
53: END IF;
54: --
55: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
56:
57: x_freight_cost_type_id := p_freight_cost_type_info.freight_cost_type_id;
58: IF (x_freight_cost_type_id IS NULL) THEN
59: LOOP

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 172: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

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 184: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 230: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

226: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.NAME',p_freight_cost_type_info.name);
227: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_INFO.FREIGHT_COST_TYPE_CODE',p_freight_cost_type_info.freight_cost_type_code);
228: END IF;
229: --
230: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
231:
232: UPDATE wsh_freight_cost_types
233: SET
234: name = p_freight_cost_type_info.name,

Line 271: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

267: WHERE freight_cost_type_id = p_freight_cost_type_info.freight_cost_type_id;
268:
269: IF (SQL%NOTFOUND) THEN
270: RAISE NO_DATA_FOUND;
271: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
272: END IF;
273: --
274: -- Debug Statements
275: --

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 283: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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: --
287: IF l_debug_on THEN

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 492: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

488: WSH_DEBUG_SV.log(l_module_name,'P_ROWID',P_ROWID);
489: WSH_DEBUG_SV.log(l_module_name,'P_FREIGHT_COST_TYPE_ID',P_FREIGHT_COST_TYPE_ID);
490: END IF;
491: --
492: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
493: l_freight_cost_type_id := p_freight_cost_type_id;
494:
495: IF (p_rowid IS NOT NULL) THEN
496: OPEN C_Get_freight_cost_type_id;

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 518: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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: --
522: IF l_debug_on THEN

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 529: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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: --
533: IF l_debug_on THEN