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 306: WSH_UTIL_CORE.OpenDynamicCursor(c_trips, l_trips_sql, bind_col_tab);

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

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

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

Line 351: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 529: ELSIF l_return_status=WSH_UTIL_CORE.G_RET_STS_WARNING THEN

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

Line 636: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then

632: --Bug 7408338 Added trip_id parameter
633: 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,
634: x_otm_pwd,x_server_tz_code, l_dlv_tab,x_error_dlv_id_tab,x_return_status);
635:
636: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then
637: --{
638: IF l_debug_on THEN
639: WSH_DEBUG_SV.log(l_sub_module_name,'failed in Get_Delivery_objects' ,x_return_status);
640: END IF;

Line 740: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

Line 771: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then

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

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

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

Line 796: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

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

Line 869: c_deliveries WSH_UTIL_CORE.RefCurType;

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

Line 870: bind_col_tab WSH_UTIL_CORE.tbl_varchar;

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

Line 871: otm_uom_tab WSH_UTIL_CORE.tbl_varchar;

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

Line 924: l_upd_tms_interface_flags WSH_UTIL_CORE.COLUMN_TAB_TYPE;

920: -- Bug 7207835
921: l_p_caller VARCHAR2(10);
922: -- 6922924
923: l_good_dlv_tab wsh_otm_dlv_tab;
924: l_upd_tms_interface_flags WSH_UTIL_CORE.COLUMN_TAB_TYPE;
925: l_upd_err_dlvys WSH_UTIL_CORE.ID_TAB_TYPE;
926:
927: --Bug#11695906 - customer id fetched depending upon ship to site use
928: CURSOR get_customer_id (p_delivery_id NUMBER) IS

Line 925: l_upd_err_dlvys WSH_UTIL_CORE.ID_TAB_TYPE;

921: l_p_caller VARCHAR2(10);
922: -- 6922924
923: l_good_dlv_tab wsh_otm_dlv_tab;
924: l_upd_tms_interface_flags WSH_UTIL_CORE.COLUMN_TAB_TYPE;
925: l_upd_err_dlvys WSH_UTIL_CORE.ID_TAB_TYPE;
926:
927: --Bug#11695906 - customer id fetched depending upon ship to site use
928: CURSOR get_customer_id (p_delivery_id NUMBER) IS
929: SELECT ca.cust_account_id customer_id, count(*) cnt

Line 972: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

968: begin
969: --{
970: -- Initialize API return status to success
971:
972: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
973:
974: -- Debug
975: --
976: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

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

1094: 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';
1095:
1096: i:=1;
1097:
1098: WSH_UTIL_CORE.OpenDynamicCursor(c_deliveries, l_deliveries_sql, bind_col_tab);
1099: l_count := 1;
1100: l_dlv_tab := wsh_otm_dlv_tab();
1101: --l_all_details - contains the delivery details of all the deliveries queried.
1102: l_all_details := wsh_otm_det_tab();

Line 1165: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then

1161: p_location_id => l_dropoff_location_id,
1162: x_location_xid => l_internal_org_location_id,
1163: x_return_status =>l_return_status);
1164:
1165: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then
1166: raise CONVERT_INT_LOC_FALIED;
1167: END IF;
1168: IF l_internal_org_location_id is NOT NULL THEN
1169: l_dlv_tab(i).ULTIMATE_DROPOFF_LOCATION_ID := l_internal_org_location_id;

Line 1185: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then

1181: --}
1182: END IF;
1183:
1184: WSH_WV_UTILS.GET_DEFAULT_UOMS(l_organization_id, x_base_wt_uom, x_base_vol_uom, x_return_status);
1185: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then
1186: raise GET_DEAFULT_UOMS_FAILED;
1187: END IF;
1188:
1189: IF l_dlv_tab(i).WEIGHT_UOM_CODE is null THEN

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

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

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

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

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

1209: WSH_OTM_RIQ_XML.Get_EBS_To_OTM_UOM(
1210: p_uom=>l_dlv_tab(i).VOLUME_UOM_CODE,
1211: x_uom=>l_dlv_tab(i).VOLUME_UOM_CODE,
1212: x_return_status=>l_return_status);
1213: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
1214: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1215: IF l_debug_on
1216: THEN
1217: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');

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

1210: p_uom=>l_dlv_tab(i).VOLUME_UOM_CODE,
1211: x_uom=>l_dlv_tab(i).VOLUME_UOM_CODE,
1212: x_return_status=>l_return_status);
1213: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
1214: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1215: IF l_debug_on
1216: THEN
1217: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
1218: END IF;

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

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

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

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

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

1267: WSH_OTM_RIQ_XML.Get_EBS_To_OTM_UOM(
1268: p_uom=>l_del_details(i).VOLUME_UOM_CODE,
1269: x_uom=>l_del_details(i).VOLUME_UOM_CODE,
1270: x_return_status=>l_return_status);
1271: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
1272: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1273: IF l_debug_on
1274: THEN
1275: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');

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

1268: p_uom=>l_del_details(i).VOLUME_UOM_CODE,
1269: x_uom=>l_del_details(i).VOLUME_UOM_CODE,
1270: x_return_status=>l_return_status);
1271: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
1272: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1273: IF l_debug_on
1274: THEN
1275: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
1276: END IF;

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

1324: WSH_OTM_RIQ_XML.Get_EBS_To_OTM_UOM(
1325: p_uom=>l_uom,
1326: x_uom=>l_otm_dimen_uom ,
1327: x_return_status=>l_return_status);
1328: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
1329: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1330: IF l_debug_on
1331: THEN
1332: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed for Loose Item');

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

1325: p_uom=>l_uom,
1326: x_uom=>l_otm_dimen_uom ,
1327: x_return_status=>l_return_status);
1328: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
1329: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1330: IF l_debug_on
1331: THEN
1332: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed for Loose Item');
1333: END IF;

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

1383: WSH_OTM_RIQ_XML.Get_EBS_To_OTM_UOM(
1384: p_uom=>l_uom,
1385: x_uom=>l_otm_dimen_uom ,
1386: x_return_status=>l_return_status);
1387: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
1388: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1389: IF l_debug_on
1390: THEN
1391: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');

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

1384: p_uom=>l_uom,
1385: x_uom=>l_otm_dimen_uom ,
1386: x_return_status=>l_return_status);
1387: IF((l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) AND
1388: (l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)) THEN
1389: IF l_debug_on
1390: THEN
1391: WSH_DEBUG_SV.log(l_sub_module_name,'Get_EBS_To_OTM_UOM Weight Failed');
1392: END IF;

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

1474: WSH_DEBUG_SV.log(l_sub_module_name,'Delivery id: '||l_delivery_id);
1475: END IF;
1476:
1477: WHEN OTHERS THEN
1478: wsh_util_core.default_handler('WSH_OTM_OUTBOUND.GET_DELIVERY_OBJECTS',l_sub_module_name);
1479: -- 6922924 Note : Removed all ref: to x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1480: -- in this Exception and above Exceptions
1481: IF l_debug_on
1482: THEN

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

1475: END IF;
1476:
1477: WHEN OTHERS THEN
1478: wsh_util_core.default_handler('WSH_OTM_OUTBOUND.GET_DELIVERY_OBJECTS',l_sub_module_name);
1479: -- 6922924 Note : Removed all ref: to x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1480: -- in this Exception and above Exceptions
1481: IF l_debug_on
1482: THEN
1483: WSH_DEBUG_SV.log(l_sub_module_name,'WHEN OTHERS inside Get Delivery Loop',sqlerrm);

Line 1559: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then

1555: ( p_delivery_id_tab => l_upd_err_dlvys,
1556: p_tms_interface_flag_tab => l_upd_tms_interface_flags,
1557: x_return_status => l_return_status );
1558: --
1559: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then
1560: IF l_debug_on THEN
1561: WSH_DEBUG_SV.log(l_sub_module_name,'failed in WND_PVT.UPDATE_TMS_INTERFACE_FLAG');
1562: END IF;
1563: -- 6830854 raise FND_API.G_EXC_ERROR;

Line 1599: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1595: END LOOP;
1596: --}
1597: END IF;
1598: --------- End of Printing the complete structure------------
1599: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1600: --
1601: ELSE
1602: IF l_debug_on THEN
1603: WSH_DEBUG_SV.log(l_sub_module_name,'Else error');

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

1617: --
1618: EXCEPTION
1619: -- 6922924 removeing all Exceptions to Inside the Loop as in above
1620: WHEN OTHERS THEN
1621: wsh_util_core.default_handler('WSH_OTM_OUTBOUND.GET_DELIVERY_OBJECTS',l_sub_module_name);
1622: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1623: IF get_customer_id%ISOPEN THEN
1624: CLOSE get_customer_id;
1625: END IF;

Line 1622: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

1618: EXCEPTION
1619: -- 6922924 removeing all Exceptions to Inside the Loop as in above
1620: WHEN OTHERS THEN
1621: wsh_util_core.default_handler('WSH_OTM_OUTBOUND.GET_DELIVERY_OBJECTS',l_sub_module_name);
1622: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1623: IF get_customer_id%ISOPEN THEN
1624: CLOSE get_customer_id;
1625: END IF;
1626: IF get_container_details%ISOPEN THEN

Line 1696: l_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

1692:
1693: l_sub_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_ENTITY_INTF_STATUS';
1694: l_entity_id_out_tab WSH_OTM_ID_TAB :=WSH_OTM_ID_TAB();
1695: l_error_id_out_tab WSH_OTM_ID_TAB := WSH_OTM_ID_TAB();
1696: l_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1697: l_status_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1698: l_del_current_status varchar2(3);
1699: l_del_id_error_flag VARCHAR2(1) := 'N';
1700: l_stop_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

Line 1697: l_status_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

1693: l_sub_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'UPDATE_ENTITY_INTF_STATUS';
1694: l_entity_id_out_tab WSH_OTM_ID_TAB :=WSH_OTM_ID_TAB();
1695: l_error_id_out_tab WSH_OTM_ID_TAB := WSH_OTM_ID_TAB();
1696: l_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1697: l_status_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1698: l_del_current_status varchar2(3);
1699: l_del_id_error_flag VARCHAR2(1) := 'N';
1700: l_stop_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1701: l_stop_status_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

Line 1700: l_stop_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

1696: l_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1697: l_status_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1698: l_del_current_status varchar2(3);
1699: l_del_id_error_flag VARCHAR2(1) := 'N';
1700: l_stop_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1701: l_stop_status_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1702: l_return_status VARCHAR2(1);
1703: l_del_status_code varchar2(30);
1704: l_ignore_for_planning VARCHAR2(1);

Line 1701: l_stop_status_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

1697: l_status_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1698: l_del_current_status varchar2(3);
1699: l_del_id_error_flag VARCHAR2(1) := 'N';
1700: l_stop_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1701: l_stop_status_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1702: l_return_status VARCHAR2(1);
1703: l_del_status_code varchar2(30);
1704: l_ignore_for_planning VARCHAR2(1);
1705: l_is_delivery_empty VARCHAR2(1);

Line 1730: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

1726: -- save point
1727: SAVEPOINT UPDATE_ENTITY_INTF_STATUS;
1728:
1729: -- Initialize API return status to success
1730: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1731:
1732: -- Debug
1733: --
1734: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;

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

1861: -- set status to "CR"
1862: elsif (l_del_status_code = 'OP' and l_ignore_for_planning = 'N') then
1863: -- check if the delivery is empty or not. If it not empty, set the status to "CR"
1864: l_is_delivery_empty := WSH_NEW_DELIVERY_ACTIONS.IS_DELIVERY_EMPTY(p_entity_id_tab(i));
1865: IF (l_is_delivery_empty = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
1866: IF l_debug_on THEN
1867: 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));
1868: END IF;
1869: -- Setting this delivery to Error List since it is failed to process

Line 1921: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then

1917: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG
1918: (P_DELIVERY_ID_TAB=>l_id_tab,
1919: P_TMS_INTERFACE_FLAG_TAB =>l_status_tab,
1920: X_RETURN_STATUS =>l_return_status);
1921: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then
1922: raise UPD_DEL_INTF_FLAG_API_FALIED;
1923: END IF;
1924: IF l_debug_on THEN
1925: WSH_DEBUG_SV.log(l_sub_module_name,'Processing Delivery Calling WSH API to update status-Success-Del-Count',l_id_tab.COUNT);

Line 2023: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then

2019: WSH_TRIP_STOPS_PVT.UPDATE_TMS_INTERFACE_FLAG
2020: (P_STOP_ID_TAB=>l_id_tab,
2021: P_TMS_INTERFACE_FLAG_TAB =>l_status_tab,
2022: X_RETURN_STATUS =>l_return_status);
2023: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS then
2024: raise UPD_STOP_INTF_FLAG_API_FALIED;
2025: END IF;
2026: IF l_debug_on THEN
2027: 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 2092: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

2088: END IF;
2089: ROLLBACK TO UPDATE_ENTITY_INTF_STATUS;
2090: -- returning all entitiy id to error id table
2091: p_error_id_tab := p_entity_id_tab;
2092: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2093: WHEN OTHERS then
2094: IF l_debug_on THEN
2095: WSH_DEBUG_SV.log(l_sub_module_name,'OTHERS - ERROR',sqlerrm);
2096: END IF;

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

2096: END IF;
2097: -- returning all entitiy id to error id table
2098: p_error_id_tab := p_entity_id_tab;
2099: x_return_status := FND_API.G_RET_STS_ERROR;
2100: wsh_util_core.default_handler('WSH_OTM_OUTBOUND.UPDATE_ENTITY_INTF_STATUS');
2101: END;
2102:
2103: -- +======================================================================+
2104: -- Procedure : WSH_OTM_APPS_INITIALIZE

Line 2162: wsh_util_core.default_handler('WSH_OTM_OUTBOUND.WSH_OTM_APPS_INITIALIZE',l_sub_module_name);

2158: END IF;
2159:
2160: EXCEPTION
2161: WHEN OTHERS THEN
2162: wsh_util_core.default_handler('WSH_OTM_OUTBOUND.WSH_OTM_APPS_INITIALIZE',l_sub_module_name);
2163: IF l_debug_on THEN
2164: WSH_DEBUG_SV.log(l_sub_module_name,'OTHERS - ERROR',sqlerrm);
2165: END IF;
2166: END;