DBA Data[Home] [Help]

APPS.WSH_BULK_PROCESS_PVT dependencies on WSH_BULK_PROCESS_PVT

Line 1: PACKAGE BODY WSH_BULK_PROCESS_PVT as

1: PACKAGE BODY WSH_BULK_PROCESS_PVT as
2: /* $Header: WSHBLPRB.pls 120.3.12000000.5 2007/01/23 19:27:27 rvishnuv ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_BULK_PROCESS_PVT';
5: l_vendor_party_id NUMBER;

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

1: PACKAGE BODY WSH_BULK_PROCESS_PVT as
2: /* $Header: WSHBLPRB.pls 120.3.12000000.5 2007/01/23 19:27:27 rvishnuv ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_BULK_PROCESS_PVT';
5: l_vendor_party_id NUMBER;
6:
7:
8: --========================================================================

Line 167: wsh_util_core.default_handler('WSH_BULK_PROCESS_PVT.clear_wsh_prev_tabs');

163:
164: EXCEPTION
165: WHEN OTHERS THEN
166: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
167: wsh_util_core.default_handler('WSH_BULK_PROCESS_PVT.clear_wsh_prev_tabs');
168: --
169: IF l_debug_on THEN
170: WSH_DEBUG_SV.log(l_module_name,'i ',i);
171: WSH_DEBUG_SV.log(l_module_name,'l_debug_num ',l_debug_num);

Line 315: wsh_util_core.default_handler('WSH_BULK_PROCESS_PVT.calc_service_mode');

311: EXCEPTION
312:
313: WHEN OTHERS THEN
314: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
315: wsh_util_core.default_handler('WSH_BULK_PROCESS_PVT.calc_service_mode');
316: --
317: IF l_debug_on THEN
318: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
319: 'Oracle error message is '||

Line 441: wsh_util_core.default_handler('WSH_BULK_PROCESS_PVT.check_null_fields');

437: EXCEPTION
438:
439: WHEN OTHERS THEN
440: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
441: wsh_util_core.default_handler('WSH_BULK_PROCESS_PVT.check_null_fields');
442: --
443: IF l_debug_on THEN
444: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
445: 'Oracle error message is '||

Line 680: wsh_util_core.default_handler('WSH_BULK_PROCESS_PVT.Calc_wt_vol_qty');

676: --
677:
678: WHEN OTHERS THEN
679: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
680: wsh_util_core.default_handler('WSH_BULK_PROCESS_PVT.Calc_wt_vol_qty');
681: --
682: IF l_debug_on THEN
683: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
684: 'Oracle error message is '||

Line 1029: wsh_util_core.default_handler('WSH_BULK_PROCESS_PVT.Create_delivery_details');

1025: --
1026:
1027: WHEN OTHERS THEN
1028: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1029: wsh_util_core.default_handler('WSH_BULK_PROCESS_PVT.Create_delivery_details');
1030: --
1031: IF l_debug_on THEN
1032: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
1033: 'Oracle error message is '||

Line 2982: wsh_util_core.default_handler('WSH_BULK_PROCESS_PVT.Extend_tables');

2978: --
2979:
2980: WHEN OTHERS THEN
2981: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
2982: wsh_util_core.default_handler('WSH_BULK_PROCESS_PVT.Extend_tables');
2983: --
2984: IF l_debug_on THEN
2985: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
2986: 'Oracle error message is '||

Line 3752: wsh_util_core.default_handler('WSH_BULK_PROCESS_PVT.Validate_lines');

3748: --
3749:
3750: WHEN OTHERS THEN
3751: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3752: wsh_util_core.default_handler('WSH_BULK_PROCESS_PVT.Validate_lines');
3753: --
3754: IF l_debug_on THEN
3755: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
3756: 'Oracle error message is '||

Line 4496: wsh_util_core.default_handler('WSH_BULK_PROCESS_PVT.bulk_insert_details');

4492: IF l_debug_on THEN
4493: WSH_DEBUG_SV.log(l_module_name,'inside when others - count of p_line_recs p_del det id ', p_line_rec.delivery_detail_id.count);
4494: END IF;
4495: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4496: wsh_util_core.default_handler('WSH_BULK_PROCESS_PVT.bulk_insert_details');
4497: --
4498: IF l_debug_on THEN
4499: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4500: 'Oracle error message is '||

Line 4621: wsh_util_core.default_handler('WSH_BULK_PROCESS_PVT.Set_message');

4617: EXCEPTION
4618:
4619: WHEN OTHERS THEN
4620: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4621: wsh_util_core.default_handler('WSH_BULK_PROCESS_PVT.Set_message');
4622: --
4623: IF l_debug_on THEN
4624: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '||
4625: 'Oracle error message is '||

Line 4895: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_BULK_PROCESS_PVT.validate_mandatory_info',l_module_name);

4891: END IF;
4892: --
4893: WHEN OTHERS THEN
4894: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
4895: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_BULK_PROCESS_PVT.validate_mandatory_info',l_module_name);
4896:
4897: --
4898: -- Debug Statements
4899: --

Line 4908: END WSH_BULK_PROCESS_PVT;

4904: --
4905: END validate_mandatory_info;
4906:
4907:
4908: END WSH_BULK_PROCESS_PVT;
4909: