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

Line 16: l_del_rows wsh_util_core.id_tab_type;

12: l_delivery_id NUMBER;
13: l_delivery_name VARCHAR2(30);
14: l_organization_id NUMBER := NULL;
15: l_return_status VARCHAR2(30);
16: l_del_rows wsh_util_core.id_tab_type;
17: l_unplan_del_rows wsh_util_core.id_tab_type;
18: l_warehouse_type VARCHAR2(30);
19: l_dummy NUMBER;
20: l_not_recv_count NUMBER;

Line 17: l_unplan_del_rows wsh_util_core.id_tab_type;

13: l_delivery_name VARCHAR2(30);
14: l_organization_id NUMBER := NULL;
15: l_return_status VARCHAR2(30);
16: l_del_rows wsh_util_core.id_tab_type;
17: l_unplan_del_rows wsh_util_core.id_tab_type;
18: l_warehouse_type VARCHAR2(30);
19: l_dummy NUMBER;
20: l_not_recv_count NUMBER;
21: -- ship confirm variables

Line 36: l_stop_rows wsh_util_core.id_tab_type;

32: l_pickup_stop_id NUMBER;
33: l_dropoff_stop_id NUMBER;
34: l_trip_id NUMBER;
35: l_actual_dep_date DATE;
36: l_stop_rows wsh_util_core.id_tab_type;
37:
38: l_msg_count NUMBER;
39: l_msg_data VARCHAR2(4000);
40: l_msg_details VARCHAR2(4000);

Line 42: l_bo_rows wsh_util_core.id_tab_type; -- list of details to Backorder

38: l_msg_count NUMBER;
39: l_msg_data VARCHAR2(4000);
40: l_msg_details VARCHAR2(4000);
41:
42: l_bo_rows wsh_util_core.id_tab_type; -- list of details to Backorder
43: l_bo_qtys wsh_util_core.id_tab_type; -- list of details BO qty
44: l_bo_qtys2 wsh_util_core.id_tab_type; -- list of details BO qty2
45: l_req_qtys wsh_util_core.id_tab_type; -- list of details req qty
46: l_overpick_qtys wsh_util_core.id_tab_type; -- list of details overpick qty

Line 43: l_bo_qtys wsh_util_core.id_tab_type; -- list of details BO qty

39: l_msg_data VARCHAR2(4000);
40: l_msg_details VARCHAR2(4000);
41:
42: l_bo_rows wsh_util_core.id_tab_type; -- list of details to Backorder
43: l_bo_qtys wsh_util_core.id_tab_type; -- list of details BO qty
44: l_bo_qtys2 wsh_util_core.id_tab_type; -- list of details BO qty2
45: l_req_qtys wsh_util_core.id_tab_type; -- list of details req qty
46: l_overpick_qtys wsh_util_core.id_tab_type; -- list of details overpick qty
47: l_overpick_qtys2 wsh_util_core.id_tab_type; --list of details overpick qty2

Line 44: l_bo_qtys2 wsh_util_core.id_tab_type; -- list of details BO qty2

40: l_msg_details VARCHAR2(4000);
41:
42: l_bo_rows wsh_util_core.id_tab_type; -- list of details to Backorder
43: l_bo_qtys wsh_util_core.id_tab_type; -- list of details BO qty
44: l_bo_qtys2 wsh_util_core.id_tab_type; -- list of details BO qty2
45: l_req_qtys wsh_util_core.id_tab_type; -- list of details req qty
46: l_overpick_qtys wsh_util_core.id_tab_type; -- list of details overpick qty
47: l_overpick_qtys2 wsh_util_core.id_tab_type; --list of details overpick qty2
48: l_cc_ids wsh_util_core.id_tab_type;

Line 45: l_req_qtys wsh_util_core.id_tab_type; -- list of details req qty

41:
42: l_bo_rows wsh_util_core.id_tab_type; -- list of details to Backorder
43: l_bo_qtys wsh_util_core.id_tab_type; -- list of details BO qty
44: l_bo_qtys2 wsh_util_core.id_tab_type; -- list of details BO qty2
45: l_req_qtys wsh_util_core.id_tab_type; -- list of details req qty
46: l_overpick_qtys wsh_util_core.id_tab_type; -- list of details overpick qty
47: l_overpick_qtys2 wsh_util_core.id_tab_type; --list of details overpick qty2
48: l_cc_ids wsh_util_core.id_tab_type;
49:

Line 46: l_overpick_qtys wsh_util_core.id_tab_type; -- list of details overpick qty

42: l_bo_rows wsh_util_core.id_tab_type; -- list of details to Backorder
43: l_bo_qtys wsh_util_core.id_tab_type; -- list of details BO qty
44: l_bo_qtys2 wsh_util_core.id_tab_type; -- list of details BO qty2
45: l_req_qtys wsh_util_core.id_tab_type; -- list of details req qty
46: l_overpick_qtys wsh_util_core.id_tab_type; -- list of details overpick qty
47: l_overpick_qtys2 wsh_util_core.id_tab_type; --list of details overpick qty2
48: l_cc_ids wsh_util_core.id_tab_type;
49:
50: l_det_rq NUMBER;

Line 47: l_overpick_qtys2 wsh_util_core.id_tab_type; --list of details overpick qty2

43: l_bo_qtys wsh_util_core.id_tab_type; -- list of details BO qty
44: l_bo_qtys2 wsh_util_core.id_tab_type; -- list of details BO qty2
45: l_req_qtys wsh_util_core.id_tab_type; -- list of details req qty
46: l_overpick_qtys wsh_util_core.id_tab_type; -- list of details overpick qty
47: l_overpick_qtys2 wsh_util_core.id_tab_type; --list of details overpick qty2
48: l_cc_ids wsh_util_core.id_tab_type;
49:
50: l_det_rq NUMBER;
51: l_det_pq NUMBER;

Line 48: l_cc_ids wsh_util_core.id_tab_type;

44: l_bo_qtys2 wsh_util_core.id_tab_type; -- list of details BO qty2
45: l_req_qtys wsh_util_core.id_tab_type; -- list of details req qty
46: l_overpick_qtys wsh_util_core.id_tab_type; -- list of details overpick qty
47: l_overpick_qtys2 wsh_util_core.id_tab_type; --list of details overpick qty2
48: l_cc_ids wsh_util_core.id_tab_type;
49:
50: l_det_rq NUMBER;
51: l_det_pq NUMBER;
52: l_overpick_qty NUMBER;

Line 124: -- l_dummy_line_ids WSH_UTIL_CORE.Id_Tab_Type;

120: l_autocreate_trip_flag varchar2(1);
121: l_defer_interface_flag varchar2(1);
122: l_del_orgaization_id NUMBER;
123:
124: -- l_dummy_line_ids WSH_UTIL_CORE.Id_Tab_Type;
125:
126: --exceptions
127: process_delivery_failed exception;
128: create_update_trip_failed exception;

Line 138: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project

134: others_update_dlvy_det exception;
135: others_create_update_trip exception;
136: others_ship_confirm exception;
137:
138: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
139: l_dbi_rs VARCHAR2(1); -- Return Status from DBI API
140: --
141: l_debug_on BOOLEAN;
142: --

Line 160: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

156: wsh_debug_sv.log (l_module_name, 'Delivery Interface Id', p_delivery_interface_id);
157: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
158: END IF;
159:
160: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
161:
162: IF(p_delivery_interface_id IS NULL) THEN
163: raise invalid_input;
164: END IF;

Line 205: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

201: wsh_debug_sv.log (l_module_name, 'Return status from get warehouse type', l_return_status);
202: wsh_debug_sv.log (l_module_name, 'Warehouse type ', l_warehouse_type);
203: END IF;
204:
205: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
206: raise get_warehouse_type_failed;
207: END IF;
208:
209: G_WAREHOUSE_TYPE := l_warehouse_type;

Line 227: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

223: IF l_debug_on THEN
224: wsh_debug_sv.log (l_module_name, 'Return status from Validate Delivery Details', l_return_status);
225: END IF;
226:
227: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
228: raise validate_delivery_failed;
229: END IF;
230: ELSE
231: WSH_INTERFACE_VALIDATIONS_PKG.Validate_Deliveries

Line 238: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

234: IF l_debug_on THEN
235: wsh_debug_sv.log (l_module_name, 'Return status from Validate Deliveries', l_return_status);
236: END IF;
237:
238: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
239: raise validate_delivery_failed;
240: END IF;
241: END IF;
242:

Line 257: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

253: IF l_debug_on THEN
254: wsh_debug_sv.log (l_module_name, 'Return status from compare procedure', l_return_status);
255: END IF;
256:
257: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
258: raise validate_delivery_failed;
259: END IF;
260: END IF; */
261:

Line 291: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

287: IF l_debug_on THEN
288: wsh_debug_sv.log (l_module_name, 'Return status from Dlvy Wrapper', l_return_status);
289: END IF;
290:
291: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
292: raise process_delivery_failed;
293: ELSE
294: IF (nvl(l_warehouse_type, '!') = 'CMS') THEN
295: -- If the inbound from CMS does not have a container that was sent in

Line 380: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

376: IF l_debug_on THEN
377: wsh_debug_sv.log (l_module_name, 'Return status from create-update-trip', l_return_status);
378: END IF;
379:
380: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
381: raise create_update_trip_failed;
382: ELSE
383: -- Return status success
384:

Line 486: wsh_util_core.get_messages('Y', l_msg_data, l_msg_details, l_msg_count);

482: p_autocreate_trip_flag => l_autocreate_trip_flag,
483: x_return_status => l_return_status,
484: p_caller => 'WSH_IB');
485:
486: wsh_util_core.get_messages('Y', l_msg_data, l_msg_details, l_msg_count);
487: IF l_debug_on THEN
488: wsh_debug_sv.log (l_module_name, 'Return status from ship confirm', l_return_status);
489: wsh_debug_sv.log (l_module_name, 'Ship confirm message count',l_msg_count);
490: wsh_debug_sv.log (l_module_name, 'Ship confirm messages', l_msg_data);

Line 494: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN

490: wsh_debug_sv.log (l_module_name, 'Ship confirm messages', l_msg_data);
491: wsh_debug_sv.log (l_module_name, 'Ship confirm message details', l_msg_details);
492: END IF;
493:
494: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
495: IF(l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
496: -- If Ship confirm completes with warning and if the global variable is set to 'E'
497: -- Then need to raise the exception
498: -- Otherwise, i.e if the global variable is not 'E' then it means the warning

Line 495: IF(l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

491: wsh_debug_sv.log (l_module_name, 'Ship confirm message details', l_msg_details);
492: END IF;
493:
494: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
495: IF(l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
496: -- If Ship confirm completes with warning and if the global variable is set to 'E'
497: -- Then need to raise the exception
498: -- Otherwise, i.e if the global variable is not 'E' then it means the warning
499: -- can be ignored and hence no need to raise the exception

Line 529: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

525: END IF;
526:
527: EXCEPTION
528: WHEN invalid_input THEN
529: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
530: IF l_debug_on THEN
531: WSH_DEBUG_SV.logmsg(l_module_name,'invalid_input exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
532: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:invalid_input');
533: END IF;

Line 537: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

533: END IF;
534: WHEN validate_delivery_failed THEN
535: FND_MESSAGE.SET_NAME('WSH','WSH_VALIDATE_DLVY_ERROR');
536: FND_MESSAGE.SET_TOKEN('DLVY', l_delivery_id);
537: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
538: IF l_debug_on THEN
539: WSH_DEBUG_SV.logmsg(l_module_name,'validate_delivery_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
540: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:validate_delivery_failed');
541: END IF;

Line 543: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

539: WSH_DEBUG_SV.logmsg(l_module_name,'validate_delivery_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
540: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:validate_delivery_failed');
541: END IF;
542: WHEN process_delivery_failed THEN
543: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
544: ROLLBACK TO before_update_dlvy_det;
545: IF l_debug_on THEN
546: WSH_DEBUG_SV.logmsg(l_module_name,'process_delivery_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
547: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:process_delivery_failed');

Line 553: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

549: WHEN create_update_trip_failed THEN
550: FND_MESSAGE.SET_NAME('WSH', 'WSH_TRIP_PROCESS_ERROR');
551: FND_MESSAGE.SET_TOKEN('DLVY',l_delivery_id);
552: ROLLBACK TO before_update_dlvy_det;
553: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
554: IF l_debug_on THEN
555: WSH_DEBUG_SV.logmsg(l_module_name,'create_update_trip_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
556: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:create_update_trip_failed');
557: END IF;

Line 562: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

558: WHEN ship_confirm_failed THEN
559: FND_MESSAGE.SET_NAME('WSH','WSH_TXN_SHIP_CONFIRM_ERROR');
560: FND_MESSAGE.SET_TOKEN('DLVY',l_delivery_id);
561: ROLLBACK TO before_ship_confirm;
562: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
563: --Fulfillment Batch XML Project
564: --When Shipconfirm errors out, the workflow(WSHBATI) should
565: --get closed and the delivery should remain in status 'SA'.
566: --Hence setting the x_return_status is being set to success.

Line 568: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

564: --When Shipconfirm errors out, the workflow(WSHBATI) should
565: --get closed and the delivery should remain in status 'SA'.
566: --Hence setting the x_return_status is being set to success.
567: IF l_warehouse_type ='TW2' THEN
568: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
569: END IF;
570: IF l_debug_on THEN
571: WSH_DEBUG_SV.logmsg(l_module_name,'ship_confirm_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
572: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:ship_confirm_failed');

Line 575: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

571: WSH_DEBUG_SV.logmsg(l_module_name,'ship_confirm_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
572: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:ship_confirm_failed');
573: END IF;
574: WHEN update_dlvy_status_failed THEN
575: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
576: ROLLBACK TO before_update_dlvy_det;
577: IF l_debug_on THEN
578: WSH_DEBUG_SV.logmsg(l_module_name,'update_dlvy_status_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
579: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:update_dlvy_status_failed');

Line 582: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

578: WSH_DEBUG_SV.logmsg(l_module_name,'update_dlvy_status_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
579: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:update_dlvy_status_failed');
580: END IF;
581: WHEN get_warehouse_type_failed THEN
582: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
583: IF l_debug_on THEN
584: WSH_DEBUG_SV.logmsg(l_module_name,'get_warehouse_type_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
585: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:get_warehouse_type_failed');
586: END IF;

Line 588: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

584: WSH_DEBUG_SV.logmsg(l_module_name,'get_warehouse_type_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
585: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:get_warehouse_type_failed');
586: END IF;
587: WHEN others_update_dlvy_det THEN
588: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
589: ROLLBACK TO before_update_dlvy_det;
590: IF l_debug_on THEN
591: WSH_DEBUG_SV.logmsg(l_module_name,'others_update_dlvy_det exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
592: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:others_update_dlvy_det');

Line 595: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

591: WSH_DEBUG_SV.logmsg(l_module_name,'others_update_dlvy_det exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
592: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:others_update_dlvy_det');
593: END IF;
594: WHEN others_create_update_trip THEN
595: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
596: ROLLBACK TO before_update_dlvy_det;
597: IF l_debug_on THEN
598: WSH_DEBUG_SV.logmsg(l_module_name,'others_create_update_trip exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
599: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:others_create_update_trip');

Line 602: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

598: WSH_DEBUG_SV.logmsg(l_module_name,'others_create_update_trip exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
599: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:others_create_update_trip');
600: END IF;
601: WHEN others_ship_confirm THEN
602: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
603: --Fulfillment Batch XML Project
604: --When Shipconfirm errors out, the workflow(WSHBATI) should
605: --get closed and the delivery should remain in status 'SA'.
606: --Hence setting the x_return_status is being set to success.

Line 608: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

604: --When Shipconfirm errors out, the workflow(WSHBATI) should
605: --get closed and the delivery should remain in status 'SA'.
606: --Hence setting the x_return_status is being set to success.
607: IF l_warehouse_type ='TW2' THEN
608: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
609: END IF;
610: ROLLBACK TO before_ship_confirm;
611: IF l_debug_on THEN
612: WSH_DEBUG_SV.logmsg(l_module_name,'others_ship_confirm exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 616: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

612: WSH_DEBUG_SV.logmsg(l_module_name,'others_ship_confirm exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
613: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:others_ship_confirm');
614: END IF;
615: WHEN OTHERS THEN
616: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
617: IF l_debug_on THEN
618: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
619: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
620: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');