DBA Data[Home] [Help]

APPS.WSH_TRIP_CONSOLIDATION dependencies on WSH_TRIP_CONSOLIDATION

Line 1: PACKAGE BODY WSH_TRIP_CONSOLIDATION as

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

Line 51: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.BuildDeliveryTable');

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

Line 378: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.CREATE_CONSOLIDATED_TRIPS');

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;

Line 578: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.CREATE_CONSOLIDATED_TRIPS');

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

Line 752: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.CreateAssignHashValue');

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

Line 815: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.FetchDelivery');

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

Line 879: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.BuildDelivRec');

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

Line 1125: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.GroupDelivsIntoTrips');

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

Line 1138: END WSH_TRIP_CONSOLIDATION;

1134: END GroupDelivsIntoTrips;
1135:
1136:
1137:
1138: END WSH_TRIP_CONSOLIDATION;