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

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(3000);
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(3000);
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(3000);
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 119: -- l_dummy_line_ids WSH_UTIL_CORE.Id_Tab_Type;

115: l_autocreate_trip_flag varchar2(1);
116: l_defer_interface_flag varchar2(1);
117: l_del_orgaization_id NUMBER;
118:
119: -- l_dummy_line_ids WSH_UTIL_CORE.Id_Tab_Type;
120:
121: --exceptions
122: process_delivery_failed exception;
123: create_update_trip_failed exception;

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

129: others_update_dlvy_det exception;
130: others_create_update_trip exception;
131: others_ship_confirm exception;
132:
133: l_detail_tab WSH_UTIL_CORE.id_tab_type; -- DBI Project
134: l_dbi_rs VARCHAR2(1); -- Return Status from DBI API
135: --
136: l_debug_on BOOLEAN;
137: --

Line 155: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

151: wsh_debug_sv.log (l_module_name, 'Delivery Interface Id', p_delivery_interface_id);
152: wsh_debug_sv.log (l_module_name, 'Event Key', p_event_key);
153: END IF;
154:
155: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
156:
157: IF(p_delivery_interface_id IS NULL) THEN
158: raise invalid_input;
159: END IF;

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

202: IF l_debug_on THEN
203: wsh_debug_sv.log (l_module_name, 'Return status from Validate Deliveries', l_return_status);
204: END IF;
205:
206: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
207: raise validate_delivery_failed;
208: END IF;
209:
210: -- check for warehouse type

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

217: wsh_debug_sv.log (l_module_name, 'Return status from get warehouse type', l_return_status);
218: wsh_debug_sv.log (l_module_name, 'Warehouse type ', l_warehouse_type);
219: END IF;
220:
221: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
222: raise get_warehouse_type_failed;
223: END IF;
224:
225: G_WAREHOUSE_TYPE := l_warehouse_type;

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

236: IF l_debug_on THEN
237: wsh_debug_sv.log (l_module_name, 'Return status from compare procedure', l_return_status);
238: END IF;
239:
240: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
241: raise validate_delivery_failed;
242: END IF;
243: END IF; */
244:

Line 303: --IF (l_wf_rs <>WSH_UTIL_CORE.G_RET_STS_SUCCESS ) then

299: WSH_DEBUG_SV.log(l_module_name,'Delivery Detail Id is ',l_detail_tab(i) );
300: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_WF_STD.Raise_Event',l_wf_rs);
301: END IF;
302: --Even if raising of event fails the flow continues.
303: --IF (l_wf_rs <>WSH_UTIL_CORE.G_RET_STS_SUCCESS ) then
304: --No Action
305: --END IF;
306: END IF;
307: END LOOP;

Line 325: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN

321:
322: IF l_debug_on THEN
323: WSH_DEBUG_SV.log(l_module_name,'Return Status after DBI Call-',l_dbi_rs);
324: END IF;
325: IF l_dbi_rs = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
326: -- just pass this return status to caller API
327: -- this is a pre-defined exception handled in parent EXCEPTIONS block
328: -- x_return_status is set as Unexpected in exceptions handler
329: RAISE others_update_dlvy_det;

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

343: IF l_debug_on THEN
344: wsh_debug_sv.log (l_module_name, 'Return status from Dlvy Wrapper', l_return_status);
345: END IF;
346:
347: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
348: raise process_delivery_failed;
349: ELSE
350: IF (nvl(l_warehouse_type, '!') = 'CMS') THEN
351: -- If the inbound from CMS does not have a container that was sent in

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

432: IF l_debug_on THEN
433: wsh_debug_sv.log (l_module_name, 'Return status from create-update-trip', l_return_status);
434: END IF;
435:
436: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
437: raise create_update_trip_failed;
438: ELSE
439: -- Return status success
440: -- 1. Need to update the txn. history record to success

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

527: p_autocreate_trip_flag => l_autocreate_trip_flag,
528: x_return_status => l_return_status,
529: p_caller => 'WSH_IB');
530:
531: wsh_util_core.get_messages('Y', l_msg_data, l_msg_details, l_msg_count);
532: IF l_debug_on THEN
533: wsh_debug_sv.log (l_module_name, 'Return status from ship confirm', l_return_status);
534: wsh_debug_sv.log (l_module_name, 'Ship confirm message count',l_msg_count);
535: wsh_debug_sv.log (l_module_name, 'Ship confirm messages', l_msg_data);

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

535: wsh_debug_sv.log (l_module_name, 'Ship confirm messages', l_msg_data);
536: wsh_debug_sv.log (l_module_name, 'Ship confirm message details', l_msg_details);
537: END IF;
538:
539: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
540: IF(l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
541: -- If Ship confirm completes with warning and if the global variable is set to 'E'
542: -- Then need to raise the exception
543: -- Otherwise, i.e if the global variable is not 'E' then it means the warning

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

536: wsh_debug_sv.log (l_module_name, 'Ship confirm message details', l_msg_details);
537: END IF;
538:
539: IF(l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
540: IF(l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
541: -- If Ship confirm completes with warning and if the global variable is set to 'E'
542: -- Then need to raise the exception
543: -- Otherwise, i.e if the global variable is not 'E' then it means the warning
544: -- can be ignored and hence no need to raise the exception

Line 574: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

Line 582: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

578: END IF;
579: WHEN validate_delivery_failed THEN
580: FND_MESSAGE.SET_NAME('WSH','WSH_VALIDATE_DLVY_ERROR');
581: FND_MESSAGE.SET_TOKEN('DLVY', l_delivery_id);
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,'validate_delivery_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
585: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:validate_delivery_failed');
586: END IF;

Line 588: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

Line 598: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

594: WHEN create_update_trip_failed THEN
595: FND_MESSAGE.SET_NAME('WSH', 'WSH_TRIP_PROCESS_ERROR');
596: FND_MESSAGE.SET_TOKEN('DLVY',l_delivery_id);
597: ROLLBACK TO before_update_dlvy_det;
598: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
599: IF l_debug_on THEN
600: WSH_DEBUG_SV.logmsg(l_module_name,'create_update_trip_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
601: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:create_update_trip_failed');
602: END IF;

Line 607: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

603: WHEN ship_confirm_failed THEN
604: FND_MESSAGE.SET_NAME('WSH','WSH_TXN_SHIP_CONFIRM_ERROR');
605: FND_MESSAGE.SET_TOKEN('DLVY',l_delivery_id);
606: ROLLBACK TO before_ship_confirm;
607: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
608: IF l_debug_on THEN
609: WSH_DEBUG_SV.logmsg(l_module_name,'ship_confirm_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
610: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:ship_confirm_failed');
611: END IF;

Line 613: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

609: WSH_DEBUG_SV.logmsg(l_module_name,'ship_confirm_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
610: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:ship_confirm_failed');
611: END IF;
612: WHEN update_dlvy_status_failed THEN
613: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
614: ROLLBACK TO before_update_dlvy_det;
615: IF l_debug_on THEN
616: WSH_DEBUG_SV.logmsg(l_module_name,'update_dlvy_status_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
617: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:update_dlvy_status_failed');

Line 620: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

616: WSH_DEBUG_SV.logmsg(l_module_name,'update_dlvy_status_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
617: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:update_dlvy_status_failed');
618: END IF;
619: WHEN get_warehouse_type_failed THEN
620: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
621: IF l_debug_on THEN
622: WSH_DEBUG_SV.logmsg(l_module_name,'get_warehouse_type_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
623: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:get_warehouse_type_failed');
624: END IF;

Line 626: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

622: WSH_DEBUG_SV.logmsg(l_module_name,'get_warehouse_type_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
623: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:get_warehouse_type_failed');
624: END IF;
625: WHEN others_update_dlvy_det THEN
626: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
627: ROLLBACK TO before_update_dlvy_det;
628: IF l_debug_on THEN
629: WSH_DEBUG_SV.logmsg(l_module_name,'others_update_dlvy_det exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
630: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:others_update_dlvy_det');

Line 633: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

629: WSH_DEBUG_SV.logmsg(l_module_name,'others_update_dlvy_det exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
630: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:others_update_dlvy_det');
631: END IF;
632: WHEN others_create_update_trip THEN
633: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
634: ROLLBACK TO before_update_dlvy_det;
635: IF l_debug_on THEN
636: WSH_DEBUG_SV.logmsg(l_module_name,'others_create_update_trip exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
637: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:others_create_update_trip');

Line 640: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

636: WSH_DEBUG_SV.logmsg(l_module_name,'others_create_update_trip exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
637: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:others_create_update_trip');
638: END IF;
639: WHEN others_ship_confirm THEN
640: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
641: ROLLBACK TO before_ship_confirm;
642: IF l_debug_on THEN
643: WSH_DEBUG_SV.logmsg(l_module_name,'others_ship_confirm exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
644: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:others_ship_confirm');

Line 647: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

643: WSH_DEBUG_SV.logmsg(l_module_name,'others_ship_confirm exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
644: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:others_ship_confirm');
645: END IF;
646: WHEN OTHERS THEN
647: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
648: IF l_debug_on THEN
649: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
650: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
651: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');