1: PACKAGE BODY WSH_TRIP_CONSOLIDATION as
2: /* $Header: WSHTRCOB.pls 120.3 2010/08/06 16:07:00 anvarshn ship $ */
3:
4: /**
5: * This is a private procedure that loops through the input table of
47: EXCEPTION
48: --
49: WHEN OTHERS THEN
50: --
51: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.BuildDeliveryTable');
52: --
53: IF l_debugOn THEN
54: wsh_debug_sv.log(l_moduleName, 'Unexpected error',
55: SUBSTRB(SQLERRM, 1, 200));
374: ELSE
375: x_return_status := WSH_UTIL_CORE.g_RET_STS_WARNING;
376: END IF;
377: --
378: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.CREATE_CONSOLIDATED_TRIPS');
379: --
380: IF l_debugOn THEN
381: wsh_debug_sv.pop(l_moduleName || ' - Unknown error - ' || SQLERRM);
382: END IF;
574: --
575: x_Query := NULL;
576: x_return_status := WSH_UTIL_CORE.g_RET_STS_UNEXP_ERROR;
577: --
578: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.CREATE_CONSOLIDATED_TRIPS');
579: --
580: IF l_debugOn THEN
581: wsh_debug_sv.log(l_moduleName, 'Unexpected error', SUBSTRB(SQLERRM, 1, 200));
582: wsh_debug_sv.pop(l_moduleName);
748: WHEN OTHERS THEN
749: --
750: x_RetSts := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
751: --
752: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.CreateAssignHashValue');
753: --
754: IF l_debugOn THEN
755: wsh_debug_sv.log(l_moduleName, 'Unexpected Error', SUBSTRB(SQLERRM,1,200));
756: wsh_debug_sv.pop(l_moduleName);
811: EXCEPTION
812: --
813: WHEN OTHERS THEN
814: --
815: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.FetchDelivery');
816: --
817: IF l_debugOn THEN
818: wsh_debug_sv.logmsg(l_moduleName, 'Unexpected Error in FetchDelivery');
819: wsh_debug_sv.pop(l_moduleName);
875: WHEN OTHERS THEN
876: --
877: x_RetSts := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
878: --
879: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.BuildDelivRec');
880: --
881: IF l_debugOn THEN
882: wsh_debug_sv.log(l_moduleName, 'Unexpected error', SUBSTRB(SQLERRM,1,200));
883: wsh_debug_sv.pop(l_moduleName);
1121: WHEN OTHERS THEN
1122: --
1123: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1124: --
1125: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.GroupDelivsIntoTrips');
1126: --
1127: IF l_debugOn THEN
1128: wsh_Debug_sv.logmsg(l_moduleName, 'Unexpected error in GroupDelivsIntoTrips' || SQLERRM);
1129: wsh_debug_sv.pop(l_moduleName);
1134: END GroupDelivsIntoTrips;
1135:
1136:
1137:
1138: END WSH_TRIP_CONSOLIDATION;