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.1 2007/01/05 00:18:12 anxsharm noship $ */
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 376: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.CREATE_CONSOLIDATED_TRIPS');

372: ELSE
373: x_return_status := WSH_UTIL_CORE.g_RET_STS_WARNING;
374: END IF;
375: --
376: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.CREATE_CONSOLIDATED_TRIPS');
377: --
378: IF l_debugOn THEN
379: wsh_debug_sv.pop(l_moduleName || ' - Unknown error - ' || SQLERRM);
380: END IF;

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

554: --
555: x_Query := NULL;
556: x_return_status := WSH_UTIL_CORE.g_RET_STS_UNEXP_ERROR;
557: --
558: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.CREATE_CONSOLIDATED_TRIPS');
559: --
560: IF l_debugOn THEN
561: wsh_debug_sv.log(l_moduleName, 'Unexpected error', SUBSTRB(SQLERRM, 1, 200));
562: wsh_debug_sv.pop(l_moduleName);

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

728: WHEN OTHERS THEN
729: --
730: x_RetSts := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
731: --
732: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.CreateAssignHashValue');
733: --
734: IF l_debugOn THEN
735: wsh_debug_sv.log(l_moduleName, 'Unexpected Error', SUBSTRB(SQLERRM,1,200));
736: wsh_debug_sv.pop(l_moduleName);

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

791: EXCEPTION
792: --
793: WHEN OTHERS THEN
794: --
795: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.FetchDelivery');
796: --
797: IF l_debugOn THEN
798: wsh_debug_sv.logmsg(l_moduleName, 'Unexpected Error in FetchDelivery');
799: wsh_debug_sv.pop(l_moduleName);

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

855: WHEN OTHERS THEN
856: --
857: x_RetSts := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
858: --
859: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.BuildDelivRec');
860: --
861: IF l_debugOn THEN
862: wsh_debug_sv.log(l_moduleName, 'Unexpected error', SUBSTRB(SQLERRM,1,200));
863: wsh_debug_sv.pop(l_moduleName);

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

1101: WHEN OTHERS THEN
1102: --
1103: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1104: --
1105: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.GroupDelivsIntoTrips');
1106: --
1107: IF l_debugOn THEN
1108: wsh_Debug_sv.logmsg(l_moduleName, 'Unexpected error in GroupDelivsIntoTrips' || SQLERRM);
1109: wsh_debug_sv.pop(l_moduleName);

Line 1118: END WSH_TRIP_CONSOLIDATION;

1114: END GroupDelivsIntoTrips;
1115:
1116:
1117:
1118: END WSH_TRIP_CONSOLIDATION;