eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_TRIP_CONSOLIDATION dependencies on WSH_UTIL_CORE

Line 9: PROCEDURE BuildDeliveryTable(p_IndexTab IN WSH_UTIL_CORE.ID_TAB_TYPE,

5: * This is a private procedure that loops through the input table of
6: * delivery records and selects only those whose indexes exist in
7: * p_IndexTab table
8: **/
9: PROCEDURE BuildDeliveryTable(p_IndexTab IN WSH_UTIL_CORE.ID_TAB_TYPE,
10: p_DeliveryTab IN WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type,
11: x_deliveryTab IN OUT NOCOPY WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type) IS
12: --
13: l_debugOn BOOLEAN;

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 139: wsh_util_core.api_post_call(

135: IF l_debugOn THEN
136: wsh_debug_sv.logmsg(l_moduleName, 'After build query');
137: END IF;
138: --
139: wsh_util_core.api_post_call(
140: p_return_status => v_RetSts,
141: x_num_warnings => l_num_warnings,
142: x_num_errors => l_num_errors);
143: --

Line 144: WSH_UTIL_CORE.OpenDynamicCursor(c_Deliv, v_Query, g_BindVarTab);

140: p_return_status => v_RetSts,
141: x_num_warnings => l_num_warnings,
142: x_num_errors => l_num_errors);
143: --
144: WSH_UTIL_CORE.OpenDynamicCursor(c_Deliv, v_Query, g_BindVarTab);
145: --
146: i := 1;
147: --
148: WHILE FetchDelivery(c_Deliv, v_delivRec) LOOP

Line 158: wsh_util_core.api_post_call(

154: x_HashTable => v_HashTab,
155: x_RetSts => v_RetSts,
156: x_UseDeliv => l_useDeliv);
157: --
158: wsh_util_core.api_post_call(
159: p_return_status => v_RetSts,
160: x_num_warnings => l_num_warnings,
161: x_num_errors => l_num_errors);
162: --

Line 163: IF v_RetSts = WSH_UTIL_CORE.g_RET_STS_SUCCESS AND l_useDeliv = 'Y' THEN

159: p_return_status => v_RetSts,
160: x_num_warnings => l_num_warnings,
161: x_num_errors => l_num_errors);
162: --
163: IF v_RetSts = WSH_UTIL_CORE.g_RET_STS_SUCCESS AND l_useDeliv = 'Y' THEN
164: v_DelivTab(i) := v_DelivRec;
165: i := i + 1;
166: END IF;
167: --}

Line 191: wsh_util_core.api_post_call(

187: IF v_DelivTab(j).hash_value = i THEN
188: --
189: BuildDelivRec(v_DelivTab(j), v_DelRec, v_RetSts);
190: --
191: wsh_util_core.api_post_call(
192: p_return_status => v_RetSts,
193: x_num_warnings => l_num_warnings,
194: x_num_errors => l_num_errors);
195: --

Line 229: wsh_util_core.api_post_call(

225: x_return_status => v_RetSts,
226: x_msg_count => l_msg_count,
227: x_msg_data => l_msg_data);
228: --
229: wsh_util_core.api_post_call(
230: p_return_status => v_RetSts,
231: x_num_warnings => l_num_warnings,
232: x_num_errors => l_num_errors);
233: --

Line 234: IF v_RetSts = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

230: p_return_status => v_RetSts,
231: x_num_warnings => l_num_warnings,
232: x_num_errors => l_num_errors);
233: --
234: IF v_RetSts = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
235: --{
236: IF l_debugOn THEN
237: wsh_debug_sv.logmsg(l_moduleName, 'Delivery_Action - warning');
238: wsh_debug_sv.log(l_moduleName, 'l_deliv_out_rec.valid_ids_tab.COUNT',

Line 272: wsh_util_core.api_post_call(

268: x_msg_count => l_msg_count,
269: x_msg_data => l_msg_data
270: );
271: --
272: wsh_util_core.api_post_call(
273: p_return_status => v_RetSts,
274: x_num_warnings => l_num_warnings,
275: x_num_errors => l_num_errors);
276: --}

Line 311: x_return_status := WSH_UTIL_CORE.g_RET_STS_SUCCESS;

307: x_SuccessDeliv := g_SuccDelivs;
308: x_Trips := g_Trips;
309: --
310: IF NVL(x_SuccessDeliv,0) = NVL(x_TotDeliveries,0) THEN
311: x_return_status := WSH_UTIL_CORE.g_RET_STS_SUCCESS;
312: ELSIF NVL(x_SuccessDeliv,0) = 0 THEN
313: x_return_status := WSH_UTIL_CORE.g_RET_STS_ERROR;
314: ELSE
315: x_return_status := WSH_UTIL_CORE.g_RET_STS_WARNING;

Line 313: x_return_status := WSH_UTIL_CORE.g_RET_STS_ERROR;

309: --
310: IF NVL(x_SuccessDeliv,0) = NVL(x_TotDeliveries,0) THEN
311: x_return_status := WSH_UTIL_CORE.g_RET_STS_SUCCESS;
312: ELSIF NVL(x_SuccessDeliv,0) = 0 THEN
313: x_return_status := WSH_UTIL_CORE.g_RET_STS_ERROR;
314: ELSE
315: x_return_status := WSH_UTIL_CORE.g_RET_STS_WARNING;
316: END IF;
317: --

Line 315: x_return_status := WSH_UTIL_CORE.g_RET_STS_WARNING;

311: x_return_status := WSH_UTIL_CORE.g_RET_STS_SUCCESS;
312: ELSIF NVL(x_SuccessDeliv,0) = 0 THEN
313: x_return_status := WSH_UTIL_CORE.g_RET_STS_ERROR;
314: ELSE
315: x_return_status := WSH_UTIL_CORE.g_RET_STS_WARNING;
316: END IF;
317: --
318: IF l_debugOn THEN
319: wsh_Debug_sv.log(l_moduleName, 'Total deliveries', NVL(x_TotDeliveries, 0));

Line 335: x_return_status := WSH_UTIL_CORE.g_RET_STS_SUCCESS;

331: x_SuccessDeliv := NVL(g_SuccDelivs, 0);
332: x_Trips := NVL(g_Trips, 0);
333: --
334: IF x_SuccessDeliv = x_TotDeliveries THEN
335: x_return_status := WSH_UTIL_CORE.g_RET_STS_SUCCESS;
336: ELSIF x_SuccessDeliv = 0 THEN
337: x_return_status := WSH_UTIL_CORE.g_RET_STS_ERROR;
338: ELSE
339: x_return_status := WSH_UTIL_CORE.g_RET_STS_WARNING;

Line 337: x_return_status := WSH_UTIL_CORE.g_RET_STS_ERROR;

333: --
334: IF x_SuccessDeliv = x_TotDeliveries THEN
335: x_return_status := WSH_UTIL_CORE.g_RET_STS_SUCCESS;
336: ELSIF x_SuccessDeliv = 0 THEN
337: x_return_status := WSH_UTIL_CORE.g_RET_STS_ERROR;
338: ELSE
339: x_return_status := WSH_UTIL_CORE.g_RET_STS_WARNING;
340: END IF;
341: --

Line 339: x_return_status := WSH_UTIL_CORE.g_RET_STS_WARNING;

335: x_return_status := WSH_UTIL_CORE.g_RET_STS_SUCCESS;
336: ELSIF x_SuccessDeliv = 0 THEN
337: x_return_status := WSH_UTIL_CORE.g_RET_STS_ERROR;
338: ELSE
339: x_return_status := WSH_UTIL_CORE.g_RET_STS_WARNING;
340: END IF;
341: --
342: IF l_debugOn THEN
343: wsh_debug_sv.pop(l_moduleName || ' - FND_API.G_EXC_ERROR');

Line 353: x_return_status := WSH_UTIL_CORE.g_RET_STS_SUCCESS;

349: x_SuccessDeliv := NVL(g_SuccDelivs, 0);
350: x_Trips := NVL(g_Trips, 0);
351: --
352: IF x_SuccessDeliv = x_TotDeliveries THEN
353: x_return_status := WSH_UTIL_CORE.g_RET_STS_SUCCESS;
354: ELSIF x_SuccessDeliv = 0 THEN
355: x_return_status := WSH_UTIL_CORE.g_RET_STS_ERROR;
356: ELSE
357: x_return_status := WSH_UTIL_CORE.g_RET_STS_WARNING;

Line 355: x_return_status := WSH_UTIL_CORE.g_RET_STS_ERROR;

351: --
352: IF x_SuccessDeliv = x_TotDeliveries THEN
353: x_return_status := WSH_UTIL_CORE.g_RET_STS_SUCCESS;
354: ELSIF x_SuccessDeliv = 0 THEN
355: x_return_status := WSH_UTIL_CORE.g_RET_STS_ERROR;
356: ELSE
357: x_return_status := WSH_UTIL_CORE.g_RET_STS_WARNING;
358: END IF;
359: --

Line 357: x_return_status := WSH_UTIL_CORE.g_RET_STS_WARNING;

353: x_return_status := WSH_UTIL_CORE.g_RET_STS_SUCCESS;
354: ELSIF x_SuccessDeliv = 0 THEN
355: x_return_status := WSH_UTIL_CORE.g_RET_STS_ERROR;
356: ELSE
357: x_return_status := WSH_UTIL_CORE.g_RET_STS_WARNING;
358: END IF;
359: --
360: IF l_debugOn THEN
361: wsh_debug_sv.pop(l_moduleName || ' - FND_API.G_EXC_UNEXP_ERROR');

Line 371: x_return_status := WSH_UTIL_CORE.g_RET_STS_SUCCESS;

367: x_SuccessDeliv := NVL(g_SuccDelivs, 0);
368: x_Trips := NVL(g_Trips, 0);
369: --
370: IF x_SuccessDeliv = x_TotDeliveries THEN
371: x_return_status := WSH_UTIL_CORE.g_RET_STS_SUCCESS;
372: ELSIF x_SuccessDeliv = 0 THEN
373: x_return_status := WSH_UTIL_CORE.g_RET_STS_ERROR;
374: ELSE
375: x_return_status := WSH_UTIL_CORE.g_RET_STS_WARNING;

Line 373: x_return_status := WSH_UTIL_CORE.g_RET_STS_ERROR;

369: --
370: IF x_SuccessDeliv = x_TotDeliveries THEN
371: x_return_status := WSH_UTIL_CORE.g_RET_STS_SUCCESS;
372: ELSIF x_SuccessDeliv = 0 THEN
373: x_return_status := WSH_UTIL_CORE.g_RET_STS_ERROR;
374: ELSE
375: x_return_status := WSH_UTIL_CORE.g_RET_STS_WARNING;
376: END IF;
377: --

Line 375: x_return_status := WSH_UTIL_CORE.g_RET_STS_WARNING;

371: x_return_status := WSH_UTIL_CORE.g_RET_STS_SUCCESS;
372: ELSIF x_SuccessDeliv = 0 THEN
373: x_return_status := WSH_UTIL_CORE.g_RET_STS_ERROR;
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: --

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 540: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;

536: END IF;
537: --
538:
539: --OTM R12, glog proj, use Global Variable
540: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
541:
542: -- If null, call the function
543: IF l_gc3_is_installed IS NULL THEN
544: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;

Line 544: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;

540: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
541:
542: -- If null, call the function
543: IF l_gc3_is_installed IS NULL THEN
544: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
545: END IF;
546: -- end of OTM R12, glog proj
547:
548: IF l_gc3_is_installed = 'Y' THEN

Line 559: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

555:
556: v_OrderBy := ' ORDER BY wnd.status_code, wnd.organization_id, wnd.ship_method_code';
557: --
558: x_Query := v_select || v_from || v_where || v_OrderBy;
559: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
560: --
561: IF l_debugOn THEN
562: wsh_debug_sv.log(l_moduleName, 'v_Select', v_Select);
563: wsh_debug_sv.log(l_moduleName, 'v_From', v_From);

Line 576: x_return_status := WSH_UTIL_CORE.g_RET_STS_UNEXP_ERROR;

572: --
573: WHEN OTHERS THEN
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

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 616: x_RetSts := WSH_UTIL_CORE.g_RET_STS_SUCCESS;

612: --
613: BEGIN
614: --
615: l_debugOn := WSH_DEBUG_INTERFACE.g_debug;
616: x_RetSts := WSH_UTIL_CORE.g_RET_STS_SUCCESS;
617: x_UseDeliv := 'Y';
618: b_exists := FALSE;
619: l_exists := FALSE;
620: l_separator := '-';

Line 644: wsh_util_core.api_post_call(

640: IF l_debugOn THEN
641: wsh_debug_sv.log(l_moduleName, 'Org Type', l_orgType);
642: END IF;
643: --
644: wsh_util_core.api_post_call(
645: p_return_status => v_RetSts,
646: x_num_warnings => l_num_warnings,
647: x_num_errors => l_num_errors);
648: --

Line 750: x_RetSts := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

746: EXCEPTION
747: --
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

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 838: x_RetSts := WSH_UTIL_CORE.g_RET_STS_SUCCESS;

834: --
835: BEGIN
836: --
837: l_debugOn := WSH_DEBUG_INTERFACE.g_debug;
838: x_RetSts := WSH_UTIL_CORE.g_RET_STS_SUCCESS;
839: --
840: IF l_debugOn IS NULL THEN
841: l_debugOn := wsh_debug_sv.is_debug_enabled;
842: END IF;

Line 877: x_RetSts := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

873: EXCEPTION
874: --
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

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 903: l_trip_name_tab wsh_util_core.column_tab_type;

899: j NUMBER;
900: k NUMBER;
901: m NUMBER;
902: l_return_status VARCHAR2(1);
903: l_trip_name_tab wsh_util_core.column_tab_type;
904: l_num_warnings NUMBER;
905: l_num_errors NUMBER;
906: l_delivery_tab WSH_UTIL_CORE.ID_TAB_TYPE;
907: l_trip_tab WSH_UTIL_CORE.ID_TAB_TYPE;

Line 906: l_delivery_tab WSH_UTIL_CORE.ID_TAB_TYPE;

902: l_return_status VARCHAR2(1);
903: l_trip_name_tab wsh_util_core.column_tab_type;
904: l_num_warnings NUMBER;
905: l_num_errors NUMBER;
906: l_delivery_tab WSH_UTIL_CORE.ID_TAB_TYPE;
907: l_trip_tab WSH_UTIL_CORE.ID_TAB_TYPE;
908: v_Index NUMBER;
909: v_DelCount NUMBER;
910: v_TotalDelCount NUMBER;

Line 907: l_trip_tab WSH_UTIL_CORE.ID_TAB_TYPE;

903: l_trip_name_tab wsh_util_core.column_tab_type;
904: l_num_warnings NUMBER;
905: l_num_errors NUMBER;
906: l_delivery_tab WSH_UTIL_CORE.ID_TAB_TYPE;
907: l_trip_tab WSH_UTIL_CORE.ID_TAB_TYPE;
908: v_Index NUMBER;
909: v_DelCount NUMBER;
910: v_TotalDelCount NUMBER;
911: v_numCalls NUMBER;

Line 926: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

922: --
923: BEGIN
924: --
925: l_debugOn := WSH_DEBUG_INTERFACE.g_debug;
926: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
927: v_DelCount := 0;
928: v_TotalDelCount := 0;
929: v_numCalls := 0;
930: l_num_errors := 0;

Line 996: wsh_util_core.api_post_call(

992: x_trip_ids => l_trip_tab,
993: x_trip_names => l_trip_name_tab,
994: x_return_status => l_return_status);
995: --
996: wsh_util_core.api_post_call(
997: p_return_status => l_return_status,
998: x_num_warnings => l_num_warnings,
999: x_num_errors => l_num_errors);
1000: --

Line 1010: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

1006: wsh_debug_sv.log(l_moduleName, 'Index k', k);
1007: wsh_debug_sv.log(l_moduleName, 'Trip ID', x_delOutRec.result_id_tab(k));
1008: END IF;
1009: --
1010: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1011: --{
1012: v_DelCount := 0;
1013: OPEN c_DeliveryCount(x_delOutRec.result_id_tab(k));
1014: FETCH c_DeliveryCount INTO v_DelCount;

Line 1086: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1082: wsh_debug_sv.log(l_moduleName, '# warnings from these calls', l_num_warnings);
1083: END IF;
1084: --
1085: IF l_num_errors > 0 AND l_num_errors = v_numCalls THEN
1086: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1087: ELSIF ((l_num_errors > 0 AND l_num_errors < v_numCalls) OR
1088: l_num_warnings > 0) THEN
1089: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1090: ELSE

Line 1089: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1085: IF l_num_errors > 0 AND l_num_errors = v_numCalls THEN
1086: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1087: ELSIF ((l_num_errors > 0 AND l_num_errors < v_numCalls) OR
1088: l_num_warnings > 0) THEN
1089: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1090: ELSE
1091: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1092: END IF;
1093: --

Line 1091: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1087: ELSIF ((l_num_errors > 0 AND l_num_errors < v_numCalls) OR
1088: l_num_warnings > 0) THEN
1089: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1090: ELSE
1091: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1092: END IF;
1093: --
1094: IF l_debugOn THEN
1095: wsh_debug_sv.log(l_moduleName, 'x_return_status', x_return_status);

Line 1103: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1099: EXCEPTION
1100: --
1101: WHEN FND_API.G_EXC_ERROR THEN
1102: --
1103: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1104: --
1105: IF l_debugOn THEN
1106: wsh_debug_sv.pop(l_moduleName || ' - FND_API.G_EXC_ERROR');
1107: END IF;

Line 1113: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1109: RAISE;
1110: --
1111: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1112: --
1113: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1114: --
1115: IF l_debugOn THEN
1116: wsh_debug_sv.pop(l_moduleName || ' - FND_API.G_EXC_UNEXPECTED_ERROR');
1117: END IF;

Line 1123: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1119: RAISE;
1120: --
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

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