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

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

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

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

Line 156: wsh_util_core.api_post_call(

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

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

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

Line 189: wsh_util_core.api_post_call(

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

Line 227: wsh_util_core.api_post_call(

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

Line 232: IF v_RetSts = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

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

Line 270: wsh_util_core.api_post_call(

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

Line 309: x_return_status := WSH_UTIL_CORE.g_RET_STS_SUCCESS;

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

Line 311: x_return_status := WSH_UTIL_CORE.g_RET_STS_ERROR;

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

Line 313: x_return_status := WSH_UTIL_CORE.g_RET_STS_WARNING;

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

Line 333: x_return_status := WSH_UTIL_CORE.g_RET_STS_SUCCESS;

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

Line 335: x_return_status := WSH_UTIL_CORE.g_RET_STS_ERROR;

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

Line 337: x_return_status := WSH_UTIL_CORE.g_RET_STS_WARNING;

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

Line 351: x_return_status := WSH_UTIL_CORE.g_RET_STS_SUCCESS;

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

Line 353: x_return_status := WSH_UTIL_CORE.g_RET_STS_ERROR;

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

Line 355: x_return_status := WSH_UTIL_CORE.g_RET_STS_WARNING;

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

Line 369: x_return_status := WSH_UTIL_CORE.g_RET_STS_SUCCESS;

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

Line 371: x_return_status := WSH_UTIL_CORE.g_RET_STS_ERROR;

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

Line 373: x_return_status := WSH_UTIL_CORE.g_RET_STS_WARNING;

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

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

516: END IF;
517: --
518:
519: --OTM R12, glog proj, use Global Variable
520: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
521:
522: -- If null, call the function
523: IF l_gc3_is_installed IS NULL THEN
524: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;

Line 524: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;

520: l_gc3_is_installed := WSH_UTIL_CORE.G_GC3_IS_INSTALLED;
521:
522: -- If null, call the function
523: IF l_gc3_is_installed IS NULL THEN
524: l_gc3_is_installed := WSH_UTIL_CORE.GC3_IS_INSTALLED;
525: END IF;
526: -- end of OTM R12, glog proj
527:
528: IF l_gc3_is_installed = 'Y' THEN

Line 539: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

535:
536: v_OrderBy := ' ORDER BY wnd.status_code, wnd.organization_id, wnd.ship_method_code';
537: --
538: x_Query := v_select || v_from || v_where || v_OrderBy;
539: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
540: --
541: IF l_debugOn THEN
542: wsh_debug_sv.log(l_moduleName, 'v_Select', v_Select);
543: wsh_debug_sv.log(l_moduleName, 'v_From', v_From);

Line 556: x_return_status := WSH_UTIL_CORE.g_RET_STS_UNEXP_ERROR;

552: --
553: WHEN OTHERS THEN
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

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

592: --
593: BEGIN
594: --
595: l_debugOn := WSH_DEBUG_INTERFACE.g_debug;
596: x_RetSts := WSH_UTIL_CORE.g_RET_STS_SUCCESS;
597: x_UseDeliv := 'Y';
598: b_exists := FALSE;
599: l_exists := FALSE;
600: l_separator := '-';

Line 624: wsh_util_core.api_post_call(

620: IF l_debugOn THEN
621: wsh_debug_sv.log(l_moduleName, 'Org Type', l_orgType);
622: END IF;
623: --
624: wsh_util_core.api_post_call(
625: p_return_status => v_RetSts,
626: x_num_warnings => l_num_warnings,
627: x_num_errors => l_num_errors);
628: --

Line 730: x_RetSts := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

726: EXCEPTION
727: --
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

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

814: --
815: BEGIN
816: --
817: l_debugOn := WSH_DEBUG_INTERFACE.g_debug;
818: x_RetSts := WSH_UTIL_CORE.g_RET_STS_SUCCESS;
819: --
820: IF l_debugOn IS NULL THEN
821: l_debugOn := wsh_debug_sv.is_debug_enabled;
822: END IF;

Line 857: x_RetSts := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

853: EXCEPTION
854: --
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

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

879: j NUMBER;
880: k NUMBER;
881: m NUMBER;
882: l_return_status VARCHAR2(1);
883: l_trip_name_tab wsh_util_core.column_tab_type;
884: l_num_warnings NUMBER;
885: l_num_errors NUMBER;
886: l_delivery_tab WSH_UTIL_CORE.ID_TAB_TYPE;
887: l_trip_tab WSH_UTIL_CORE.ID_TAB_TYPE;

Line 886: l_delivery_tab WSH_UTIL_CORE.ID_TAB_TYPE;

882: l_return_status VARCHAR2(1);
883: l_trip_name_tab wsh_util_core.column_tab_type;
884: l_num_warnings NUMBER;
885: l_num_errors NUMBER;
886: l_delivery_tab WSH_UTIL_CORE.ID_TAB_TYPE;
887: l_trip_tab WSH_UTIL_CORE.ID_TAB_TYPE;
888: v_Index NUMBER;
889: v_DelCount NUMBER;
890: v_TotalDelCount NUMBER;

Line 887: l_trip_tab WSH_UTIL_CORE.ID_TAB_TYPE;

883: l_trip_name_tab wsh_util_core.column_tab_type;
884: l_num_warnings NUMBER;
885: l_num_errors NUMBER;
886: l_delivery_tab WSH_UTIL_CORE.ID_TAB_TYPE;
887: l_trip_tab WSH_UTIL_CORE.ID_TAB_TYPE;
888: v_Index NUMBER;
889: v_DelCount NUMBER;
890: v_TotalDelCount NUMBER;
891: v_numCalls NUMBER;

Line 906: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

902: --
903: BEGIN
904: --
905: l_debugOn := WSH_DEBUG_INTERFACE.g_debug;
906: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
907: v_DelCount := 0;
908: v_TotalDelCount := 0;
909: v_numCalls := 0;
910: l_num_errors := 0;

Line 976: wsh_util_core.api_post_call(

972: x_trip_ids => l_trip_tab,
973: x_trip_names => l_trip_name_tab,
974: x_return_status => l_return_status);
975: --
976: wsh_util_core.api_post_call(
977: p_return_status => l_return_status,
978: x_num_warnings => l_num_warnings,
979: x_num_errors => l_num_errors);
980: --

Line 990: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

986: wsh_debug_sv.log(l_moduleName, 'Index k', k);
987: wsh_debug_sv.log(l_moduleName, 'Trip ID', x_delOutRec.result_id_tab(k));
988: END IF;
989: --
990: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
991: --{
992: v_DelCount := 0;
993: OPEN c_DeliveryCount(x_delOutRec.result_id_tab(k));
994: FETCH c_DeliveryCount INTO v_DelCount;

Line 1066: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1062: wsh_debug_sv.log(l_moduleName, '# warnings from these calls', l_num_warnings);
1063: END IF;
1064: --
1065: IF l_num_errors > 0 AND l_num_errors = v_numCalls THEN
1066: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1067: ELSIF ((l_num_errors > 0 AND l_num_errors < v_numCalls) OR
1068: l_num_warnings > 0) THEN
1069: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1070: ELSE

Line 1069: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

1065: IF l_num_errors > 0 AND l_num_errors = v_numCalls THEN
1066: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1067: ELSIF ((l_num_errors > 0 AND l_num_errors < v_numCalls) OR
1068: l_num_warnings > 0) THEN
1069: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1070: ELSE
1071: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1072: END IF;
1073: --

Line 1071: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1067: ELSIF ((l_num_errors > 0 AND l_num_errors < v_numCalls) OR
1068: l_num_warnings > 0) THEN
1069: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1070: ELSE
1071: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1072: END IF;
1073: --
1074: IF l_debugOn THEN
1075: wsh_debug_sv.log(l_moduleName, 'x_return_status', x_return_status);

Line 1083: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_ERROR;

1079: EXCEPTION
1080: --
1081: WHEN FND_API.G_EXC_ERROR THEN
1082: --
1083: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1084: --
1085: IF l_debugOn THEN
1086: wsh_debug_sv.pop(l_moduleName || ' - FND_API.G_EXC_ERROR');
1087: END IF;

Line 1093: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1089: RAISE;
1090: --
1091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1092: --
1093: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1094: --
1095: IF l_debugOn THEN
1096: wsh_debug_sv.pop(l_moduleName || ' - FND_API.G_EXC_UNEXPECTED_ERROR');
1097: END IF;

Line 1103: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1099: RAISE;
1100: --
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

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