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_OTM_OUTBOUND dependencies on WSH_UTIL_CORE

Line 64: wsh_util_core.default_handler('WSH_OTM_OUTBOUND.GET_DEL_DETAILS',l_sub_module_name);

60: WSH_DEBUG_SV.log(l_sub_module_name,' FND_API.G_EXC_UNEXPECTED_ERROR',sqlerrm);
61: WSH_DEBUG_SV.pop(l_sub_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
62: END IF;
63: WHEN OTHERS THEN
64: wsh_util_core.default_handler('WSH_OTM_OUTBOUND.GET_DEL_DETAILS',l_sub_module_name);
65: IF l_debug_on THEN
66: WSH_DEBUG_SV.log(l_sub_module_name,' OTHERS',sqlerrm);
67: WSH_DEBUG_SV.pop(l_sub_module_name,'EXCEPTION:OTHERS');
68: END IF;

Line 136: c_trips WSH_UTIL_CORE.RefCurType;

132: l_drop_off_flag VARCHAR2(1);
133: l_trips_sql VARCHAR2(2000);
134: l_trip_obj WSH_OTM_TRIP_OBJ;
135: l_stop_obj WSH_OTM_STOP_OBJ;
136: c_trips WSH_UTIL_CORE.RefCurType;
137: bind_col_tab WSH_UTIL_CORE.tbl_varchar;
138: i NUMBER;
139: i1 NUMBER;
140: l_lpn_tab WSH_OTM_LPN_TAB;

Line 137: bind_col_tab WSH_UTIL_CORE.tbl_varchar;

133: l_trips_sql VARCHAR2(2000);
134: l_trip_obj WSH_OTM_TRIP_OBJ;
135: l_stop_obj WSH_OTM_STOP_OBJ;
136: c_trips WSH_UTIL_CORE.RefCurType;
137: bind_col_tab WSH_UTIL_CORE.tbl_varchar;
138: i NUMBER;
139: i1 NUMBER;
140: l_lpn_tab WSH_OTM_LPN_TAB;
141: l_organization_id NUMBER;

Line 170: l_upd_trip_stops WSH_UTIL_CORE.ID_TAB_TYPE;

166: FROM wsh_trip_stops
167: WHERE trip_id = c_trip_id;
168:
169: x_error_dlv_id_tab WSH_OTM_ID_TAB;
170: l_upd_trip_stops WSH_UTIL_CORE.ID_TAB_TYPE;
171: l_upd_tms_interface_flags WSH_UTIL_CORE.COLUMN_TAB_TYPE;
172: l_old_trip_id NUMBER;
173: l_del_trip_rec NUMBER := NULL;
174: l_num_error NUMBER;

Line 171: l_upd_tms_interface_flags WSH_UTIL_CORE.COLUMN_TAB_TYPE;

167: WHERE trip_id = c_trip_id;
168:
169: x_error_dlv_id_tab WSH_OTM_ID_TAB;
170: l_upd_trip_stops WSH_UTIL_CORE.ID_TAB_TYPE;
171: l_upd_tms_interface_flags WSH_UTIL_CORE.COLUMN_TAB_TYPE;
172: l_old_trip_id NUMBER;
173: l_del_trip_rec NUMBER := NULL;
174: l_num_error NUMBER;
175: --bug# 6497991 (end)

Line 189: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

185:
186:
187: -- Initialize API return status to success
188:
189: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
190:
191: -- Debug
192: --
193: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line 305: WSH_UTIL_CORE.OpenDynamicCursor(c_trips, l_trips_sql, bind_col_tab);

301: l_trips_sql := l_trips_sql || ' ORDER BY WT.TRIP_ID,WTS.STOP_SEQUENCE_NUMBER'; --bug#5975661 : order by sequence num.
302:
303: i:=1;
304:
305: WSH_UTIL_CORE.OpenDynamicCursor(c_trips, l_trips_sql, bind_col_tab);
306: x_trip_tab := WSH_OTM_TRIP_TAB();
307: l_trip_tab := WSH_OTM_TRIP_TAB();
308: l_stops_tab := WSH_OTM_STOP_TAB();
309: l_stop_details := WSH_OTM_STOP_DET_TAB();

Line 336: l_organization_id := WSH_UTIL_CORE.GET_TRIP_ORGANIZATION_ID(l_trip_obj.trip_id);

332: END IF;
333:
334:
335: -- Get the OrganizationId of Trip
336: l_organization_id := WSH_UTIL_CORE.GET_TRIP_ORGANIZATION_ID(l_trip_obj.trip_id);
337: IF l_debug_on
338: THEN
339: WSH_DEBUG_SV.log(l_sub_module_name,' Organization Id after calling GET_TRIP_ORGANIZATION_ID ' ,
340: l_organization_id);

Line 350: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then

346:
347:
348: -- Get the Default UOMS based on the Organization Id
349: wsh_wv_utils.get_default_uoms(l_organization_id, x_base_wt_uom, x_base_vol_uom, x_return_status);
350: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then
351: --{
352: -- Bug 6497991: Deleting the trip record before raising exception
353: IF l_debug_on THEN
354: WSH_DEBUG_SV.log(l_sub_module_name,'failed in get_default_uoms' ,x_return_status);

Line 368: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

364: p_uom=>x_base_wt_uom,
365: x_uom=>l_trip_tab(l_trip_tab.COUNT).WEIGHT_UOM_XID ,
366: x_return_status=>l_return_status);
367:
368: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
369: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
370: --{
371: IF l_debug_on THEN
372: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');

Line 369: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

365: x_uom=>l_trip_tab(l_trip_tab.COUNT).WEIGHT_UOM_XID ,
366: x_return_status=>l_return_status);
367:
368: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
369: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
370: --{
371: IF l_debug_on THEN
372: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
373: END IF;

Line 388: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

384: p_uom=>x_base_vol_uom,
385: x_uom=>l_trip_tab(l_trip_tab.COUNT).VOLUME_UOM_XID ,
386: x_return_status=>l_return_status);
387:
388: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
389: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
390: IF l_debug_on THEN
391: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
392: END IF;

Line 389: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

385: x_uom=>l_trip_tab(l_trip_tab.COUNT).VOLUME_UOM_XID ,
386: x_return_status=>l_return_status);
387:
388: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
389: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
390: IF l_debug_on THEN
391: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
392: END IF;
393: -- Bug 6497991: Deleting the trip record before raising exception

Line 501: l_trip_tab(i).EQUIPMENT_XID := wsh_util_core.get_item_name(

497: l_trip_tab(i).SERVICE_PROVIDER_XID := l_car_type || l_trip_tab(i).SERVICE_PROVIDER_XID;
498: END IF;
499:
500: IF l_trip_tab(i).EQUIPMENT_XID IS NOT NULL THEN
501: l_trip_tab(i).EQUIPMENT_XID := wsh_util_core.get_item_name(
502: p_item_id =>to_number(l_trip_tab(i).EQUIPMENT_XID),
503: p_organization_id =>l_trip_tab(i).EQUIPMENT_GROUP_XID);
504: END IF;
505:

Line 518: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

514: l_currency_code,
515: l_total_freight_cost,
516: l_return_status);
517:
518: IF l_return_status NOT IN (WSH_UTIL_CORE.G_RET_STS_SUCCESS,WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
519: --{
520: -- Bug 6497991: Deleting the trip record before raising exception
521: IF l_debug_on THEN
522: WSH_DEBUG_SV.log(l_sub_module_name,'Get_Trip_Manual_Freight_Cost Failed');

Line 528: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN

524: x_error_trip_id_tab.extend;
525: x_error_trip_id_tab(x_error_trip_id_tab.COUNT) := l_trip_tab(i).trip_id;
526: l_trip_tab.delete(i);
527: raise GET_FREIGHT_COST_ERROR;
528: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN
529: x_return_status:=l_return_status;
530: --}
531: END IF;
532:

Line 635: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then

631: --Bug 7408338 Added trip_id parameter
632: Get_Delivery_objects(l_dlv_ids,p_user_id,p_resp_id, p_resp_appl_id,'A',l_trip_tab(i).trip_id,x_domain_name,x_otm_user_name,
633: x_otm_pwd,x_server_tz_code, l_dlv_tab,x_error_dlv_id_tab,x_return_status);
634:
635: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then
636: --{
637: IF l_debug_on THEN
638: WSH_DEBUG_SV.log(l_sub_module_name,'failed in Get_Delivery_objects' ,x_return_status);
639: END IF;

Line 739: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

735: --}
736: END IF;
737: -- Bug 6497991(end):
738:
739: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
740: --}
741: ELSE
742: --{
743: x_return_status := FND_API.G_RET_STS_ERROR;

Line 770: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then

766: WSH_TRIP_STOPS_PVT.UPDATE_TMS_INTERFACE_FLAG
767: (P_STOP_ID_TAB=>l_upd_trip_stops,
768: P_TMS_INTERFACE_FLAG_TAB =>l_upd_tms_interface_flags,
769: X_RETURN_STATUS =>l_return_status);
770: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then
771: IF l_debug_on THEN
772: WSH_DEBUG_SV.log(l_sub_module_name,'failed in UPDATE_TMS_INTERFACE_FLAG');
773: END IF;
774: raise FND_API.G_EXC_ERROR;

Line 794: wsh_util_core.default_handler('WSH_OTM_OUTBOUND.GET_TRIP_OBJECTS',l_sub_module_name);

790: --
791: EXCEPTION
792: -- Bug 6497991: Defined exceptions to be handled inside the LOOP
793: WHEN OTHERS THEN
794: wsh_util_core.default_handler('WSH_OTM_OUTBOUND.GET_TRIP_OBJECTS',l_sub_module_name);
795: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
796: IF get_deliveries_picked%ISOPEN THEN
797: CLOSE get_deliveries_picked;
798: END IF;

Line 795: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

791: EXCEPTION
792: -- Bug 6497991: Defined exceptions to be handled inside the LOOP
793: WHEN OTHERS THEN
794: wsh_util_core.default_handler('WSH_OTM_OUTBOUND.GET_TRIP_OBJECTS',l_sub_module_name);
795: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
796: IF get_deliveries_picked%ISOPEN THEN
797: CLOSE get_deliveries_picked;
798: END IF;
799: IF get_deliveries_dropped%ISOPEN THEN

Line 868: c_deliveries WSH_UTIL_CORE.RefCurType;

864: l_dlv_id_tab WSH_OTM_ID_TAB;
865: l_error_dlv_id_tab WSH_OTM_ID_TAB;
866:
867:
868: c_deliveries WSH_UTIL_CORE.RefCurType;
869: bind_col_tab WSH_UTIL_CORE.tbl_varchar;
870: otm_uom_tab WSH_UTIL_CORE.tbl_varchar;
871: l_deliveries_sql VARCHAR2(2000);
872: l_count NUMBER;

Line 869: bind_col_tab WSH_UTIL_CORE.tbl_varchar;

865: l_error_dlv_id_tab WSH_OTM_ID_TAB;
866:
867:
868: c_deliveries WSH_UTIL_CORE.RefCurType;
869: bind_col_tab WSH_UTIL_CORE.tbl_varchar;
870: otm_uom_tab WSH_UTIL_CORE.tbl_varchar;
871: l_deliveries_sql VARCHAR2(2000);
872: l_count NUMBER;
873: l_customer_id NUMBER;

Line 870: otm_uom_tab WSH_UTIL_CORE.tbl_varchar;

866:
867:
868: c_deliveries WSH_UTIL_CORE.RefCurType;
869: bind_col_tab WSH_UTIL_CORE.tbl_varchar;
870: otm_uom_tab WSH_UTIL_CORE.tbl_varchar;
871: l_deliveries_sql VARCHAR2(2000);
872: l_count NUMBER;
873: l_customer_id NUMBER;
874: l_cnt NUMBER;

Line 923: l_upd_tms_interface_flags WSH_UTIL_CORE.COLUMN_TAB_TYPE;

919: -- Bug 7207835
920: l_p_caller VARCHAR2(10);
921: -- 6922924
922: l_good_dlv_tab wsh_otm_dlv_tab;
923: l_upd_tms_interface_flags WSH_UTIL_CORE.COLUMN_TAB_TYPE;
924: l_upd_err_dlvys WSH_UTIL_CORE.ID_TAB_TYPE;
925:
926:
927: CURSOR get_customer_id (p_delivery_id NUMBER) IS

Line 924: l_upd_err_dlvys WSH_UTIL_CORE.ID_TAB_TYPE;

920: l_p_caller VARCHAR2(10);
921: -- 6922924
922: l_good_dlv_tab wsh_otm_dlv_tab;
923: l_upd_tms_interface_flags WSH_UTIL_CORE.COLUMN_TAB_TYPE;
924: l_upd_err_dlvys WSH_UTIL_CORE.ID_TAB_TYPE;
925:
926:
927: CURSOR get_customer_id (p_delivery_id NUMBER) IS
928: SELECT wdd.customer_id, count(*) cnt

Line 967: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

963: begin
964: --{
965: -- Initialize API return status to success
966:
967: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
968:
969: -- Debug
970: --
971: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line 1087: WSH_UTIL_CORE.OpenDynamicCursor(c_deliveries, l_deliveries_sql, bind_col_tab);

1083: l_deliveries_sql := l_deliveries_sql || 'order by decode(wnd.tms_interface_flag,''CP'',''3'',''UP'',''2'',''DP'',''1''),wda.delivery_id, wdd.container_flag desc';
1084:
1085: i:=1;
1086:
1087: WSH_UTIL_CORE.OpenDynamicCursor(c_deliveries, l_deliveries_sql, bind_col_tab);
1088: l_count := 1;
1089: l_dlv_tab := wsh_otm_dlv_tab();
1090: --l_all_details - contains the delivery details of all the deliveries queried.
1091: l_all_details := wsh_otm_det_tab();

Line 1154: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then

1150: p_location_id => l_dropoff_location_id,
1151: x_location_xid => l_internal_org_location_id,
1152: x_return_status =>l_return_status);
1153:
1154: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then
1155: raise CONVERT_INT_LOC_FALIED;
1156: END IF;
1157: IF l_internal_org_location_id is NOT NULL THEN
1158: l_dlv_tab(i).ULTIMATE_DROPOFF_LOCATION_ID := l_internal_org_location_id;

Line 1174: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then

1170: --}
1171: END IF;
1172:
1173: WSH_WV_UTILS.GET_DEFAULT_UOMS(l_organization_id, x_base_wt_uom, x_base_vol_uom, x_return_status);
1174: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then
1175: raise GET_DEAFULT_UOMS_FAILED;
1176: END IF;
1177:
1178: IF l_dlv_tab(i).WEIGHT_UOM_CODE is null THEN

Line 1189: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

1185: WSH_OTM_RIQ_XML.Get_EBS_To_OTM_UOM(
1186: p_uom=>l_dlv_tab(i).WEIGHT_UOM_CODE,
1187: x_uom=>l_dlv_tab(i).WEIGHT_UOM_CODE,
1188: x_return_status=>l_return_status);
1189: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
1190: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1191: IF l_debug_on
1192: THEN
1193: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');

Line 1190: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

1186: p_uom=>l_dlv_tab(i).WEIGHT_UOM_CODE,
1187: x_uom=>l_dlv_tab(i).WEIGHT_UOM_CODE,
1188: x_return_status=>l_return_status);
1189: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
1190: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1191: IF l_debug_on
1192: THEN
1193: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
1194: END IF;

Line 1202: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

1198: WSH_OTM_RIQ_XML.Get_EBS_To_OTM_UOM(
1199: p_uom=>l_dlv_tab(i).VOLUME_UOM_CODE,
1200: x_uom=>l_dlv_tab(i).VOLUME_UOM_CODE,
1201: x_return_status=>l_return_status);
1202: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
1203: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1204: IF l_debug_on
1205: THEN
1206: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');

Line 1203: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

1199: p_uom=>l_dlv_tab(i).VOLUME_UOM_CODE,
1200: x_uom=>l_dlv_tab(i).VOLUME_UOM_CODE,
1201: x_return_status=>l_return_status);
1202: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
1203: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1204: IF l_debug_on
1205: THEN
1206: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
1207: END IF;

Line 1247: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

1243: WSH_OTM_RIQ_XML.Get_EBS_To_OTM_UOM(
1244: p_uom=>l_del_details(i).WEIGHT_UOM_CODE,
1245: x_uom=>l_del_details(i).WEIGHT_UOM_CODE,
1246: x_return_status=>l_return_status);
1247: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
1248: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1249: IF l_debug_on
1250: THEN
1251: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');

Line 1248: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

1244: p_uom=>l_del_details(i).WEIGHT_UOM_CODE,
1245: x_uom=>l_del_details(i).WEIGHT_UOM_CODE,
1246: x_return_status=>l_return_status);
1247: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
1248: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1249: IF l_debug_on
1250: THEN
1251: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
1252: END IF;

Line 1260: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

1256: WSH_OTM_RIQ_XML.Get_EBS_To_OTM_UOM(
1257: p_uom=>l_del_details(i).VOLUME_UOM_CODE,
1258: x_uom=>l_del_details(i).VOLUME_UOM_CODE,
1259: x_return_status=>l_return_status);
1260: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
1261: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1262: IF l_debug_on
1263: THEN
1264: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');

Line 1261: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

1257: p_uom=>l_del_details(i).VOLUME_UOM_CODE,
1258: x_uom=>l_del_details(i).VOLUME_UOM_CODE,
1259: x_return_status=>l_return_status);
1260: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
1261: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1262: IF l_debug_on
1263: THEN
1264: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
1265: END IF;

Line 1317: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

1313: WSH_OTM_RIQ_XML.Get_EBS_To_OTM_UOM(
1314: p_uom=>l_uom,
1315: x_uom=>l_otm_dimen_uom ,
1316: x_return_status=>l_return_status);
1317: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
1318: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1319: IF l_debug_on
1320: THEN
1321: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed for Loose Item');

Line 1318: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

1314: p_uom=>l_uom,
1315: x_uom=>l_otm_dimen_uom ,
1316: x_return_status=>l_return_status);
1317: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
1318: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1319: IF l_debug_on
1320: THEN
1321: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed for Loose Item');
1322: END IF;

Line 1376: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND

1372: WSH_OTM_RIQ_XML.Get_EBS_To_OTM_UOM(
1373: p_uom=>l_uom,
1374: x_uom=>l_otm_dimen_uom ,
1375: x_return_status=>l_return_status);
1376: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
1377: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1378: IF l_debug_on
1379: THEN
1380: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');

Line 1377: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN

1373: p_uom=>l_uom,
1374: x_uom=>l_otm_dimen_uom ,
1375: x_return_status=>l_return_status);
1376: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
1377: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1378: IF l_debug_on
1379: THEN
1380: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
1381: END IF;

Line 1467: wsh_util_core.default_handler('WSH_OTM_OUTBOUND.GET_DELIVERY_OBJECTS',l_sub_module_name);

1463: WSH_DEBUG_SV.log(l_sub_module_name,'Delivery id: '||l_delivery_id);
1464: END IF;
1465:
1466: WHEN OTHERS THEN
1467: wsh_util_core.default_handler('WSH_OTM_OUTBOUND.GET_DELIVERY_OBJECTS',l_sub_module_name);
1468: -- 6922924 Note : Removed all ref: to x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1469: -- in this Exception and above Exceptions
1470: IF l_debug_on
1471: THEN

Line 1468: -- 6922924 Note : Removed all ref: to x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1464: END IF;
1465:
1466: WHEN OTHERS THEN
1467: wsh_util_core.default_handler('WSH_OTM_OUTBOUND.GET_DELIVERY_OBJECTS',l_sub_module_name);
1468: -- 6922924 Note : Removed all ref: to x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1469: -- in this Exception and above Exceptions
1470: IF l_debug_on
1471: THEN
1472: WSH_DEBUG_SV.log(l_sub_module_name,'WHEN OTHERS inside Get Delivery Loop',sqlerrm);

Line 1548: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then

1544: ( p_delivery_id_tab => l_upd_err_dlvys,
1545: p_tms_interface_flag_tab => l_upd_tms_interface_flags,
1546: x_return_status => l_return_status );
1547: --
1548: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then
1549: IF l_debug_on THEN
1550: WSH_DEBUG_SV.log(l_sub_module_name,'failed in WND_PVT.UPDATE_TMS_INTERFACE_FLAG');
1551: END IF;
1552: -- 6830854 raise FND_API.G_EXC_ERROR;

Line 1588: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1584: END LOOP;
1585: --}
1586: END IF;
1587: --------- End of Printing the complete structure------------
1588: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1589: --
1590: ELSE
1591: IF l_debug_on THEN
1592: WSH_DEBUG_SV.log(l_sub_module_name,'Else error');

Line 1610: wsh_util_core.default_handler('WSH_OTM_OUTBOUND.GET_DELIVERY_OBJECTS',l_sub_module_name);

1606: --
1607: EXCEPTION
1608: -- 6922924 removeing all Exceptions to Inside the Loop as in above
1609: WHEN OTHERS THEN
1610: wsh_util_core.default_handler('WSH_OTM_OUTBOUND.GET_DELIVERY_OBJECTS',l_sub_module_name);
1611: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1612: IF get_customer_id%ISOPEN THEN
1613: CLOSE get_customer_id;
1614: END IF;

Line 1611: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1607: EXCEPTION
1608: -- 6922924 removeing all Exceptions to Inside the Loop as in above
1609: WHEN OTHERS THEN
1610: wsh_util_core.default_handler('WSH_OTM_OUTBOUND.GET_DELIVERY_OBJECTS',l_sub_module_name);
1611: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1612: IF get_customer_id%ISOPEN THEN
1613: CLOSE get_customer_id;
1614: END IF;
1615: IF get_container_details%ISOPEN THEN

Line 1685: l_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

1681:
1682: l_sub_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_ENTITY_INTF_STATUS';
1683: l_entity_id_out_tab WSH_OTM_ID_TAB :=WSH_OTM_ID_TAB();
1684: l_error_id_out_tab WSH_OTM_ID_TAB := WSH_OTM_ID_TAB();
1685: l_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1686: l_status_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1687: l_del_current_status varchar2(3);
1688: l_del_id_error_flag VARCHAR2(1) := 'N';
1689: l_stop_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

Line 1686: l_status_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

1682: l_sub_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_ENTITY_INTF_STATUS';
1683: l_entity_id_out_tab WSH_OTM_ID_TAB :=WSH_OTM_ID_TAB();
1684: l_error_id_out_tab WSH_OTM_ID_TAB := WSH_OTM_ID_TAB();
1685: l_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1686: l_status_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1687: l_del_current_status varchar2(3);
1688: l_del_id_error_flag VARCHAR2(1) := 'N';
1689: l_stop_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1690: l_stop_status_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

Line 1689: l_stop_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

1685: l_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1686: l_status_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1687: l_del_current_status varchar2(3);
1688: l_del_id_error_flag VARCHAR2(1) := 'N';
1689: l_stop_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1690: l_stop_status_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1691: l_return_status VARCHAR2(1);
1692: l_del_status_code varchar2(30);
1693: l_ignore_for_planning VARCHAR2(1);

Line 1690: l_stop_status_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

1686: l_status_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1687: l_del_current_status varchar2(3);
1688: l_del_id_error_flag VARCHAR2(1) := 'N';
1689: l_stop_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1690: l_stop_status_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1691: l_return_status VARCHAR2(1);
1692: l_del_status_code varchar2(30);
1693: l_ignore_for_planning VARCHAR2(1);
1694: l_is_delivery_empty VARCHAR2(1);

Line 1719: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1715: -- save point
1716: SAVEPOINT UPDATE_ENTITY_INTF_STATUS;
1717:
1718: -- Initialize API return status to success
1719: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1720:
1721: -- Debug
1722: --
1723: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

Line 1853: IF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN

1849: -- set status to "CR"
1850: elsif (l_del_status_code = 'OP' and l_ignore_for_planning = 'N') then
1851: -- check if the delivery is empty or not. If it not empty, set the status to "CR"
1852: l_is_delivery_empty := WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(p_entity_id_tab(i));
1853: IF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
1854: IF l_debug_on THEN
1855: WSH_DEBUG_SV.log(l_sub_module_name,'Error from wsh_new_delivery_actions.is_delivery_empty API for Delivery '||p_entity_id_tab(i));
1856: END IF;
1857: -- Setting this delivery to Error List since it is failed to process

Line 1909: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then

1905: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG
1906: (P_DELIVERY_ID_TAB=>l_id_tab,
1907: P_TMS_INTERFACE_FLAG_TAB =>l_status_tab,
1908: X_RETURN_STATUS =>l_return_status);
1909: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then
1910: raise UPD_DEL_INTF_FLAG_API_FALIED;
1911: END IF;
1912: IF l_debug_on THEN
1913: WSH_DEBUG_SV.log(l_sub_module_name,'Processing Delivery Calling WSH API to update status-Success-Del-Count',l_id_tab.COUNT);

Line 2011: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then

2007: WSH_TRIP_STOPS_PVT.UPDATE_TMS_INTERFACE_FLAG
2008: (P_STOP_ID_TAB=>l_id_tab,
2009: P_TMS_INTERFACE_FLAG_TAB =>l_status_tab,
2010: X_RETURN_STATUS =>l_return_status);
2011: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then
2012: raise UPD_STOP_INTF_FLAG_API_FALIED;
2013: END IF;
2014: IF l_debug_on THEN
2015: WSH_DEBUG_SV.log(l_sub_module_name,'Processing Trip Calling WSH API to update status-Success-Trip-Stops-Count',l_id_tab.COUNT);

Line 2080: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2076: END IF;
2077: ROLLBACK TO UPDATE_ENTITY_INTF_STATUS;
2078: -- returning all entitiy id to error id table
2079: p_error_id_tab := p_entity_id_tab;
2080: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2081: WHEN OTHERS then
2082: IF l_debug_on THEN
2083: WSH_DEBUG_SV.log(l_sub_module_name,'OTHERS - ERROR',sqlerrm);
2084: END IF;

Line 2088: wsh_util_core.default_handler('WSH_OTM_OUTBOUND.UPDATE_ENTITY_INTF_STATUS');

2084: END IF;
2085: -- returning all entitiy id to error id table
2086: p_error_id_tab := p_entity_id_tab;
2087: x_return_status := FND_API.G_RET_STS_ERROR;
2088: wsh_util_core.default_handler('WSH_OTM_OUTBOUND.UPDATE_ENTITY_INTF_STATUS');
2089: END;
2090:
2091:
2092: