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

Line 137: l_otm_installed := WSH_UTIL_CORE.GC3_Is_Installed;

133: ELSIF ( p_organization_id IS NULL ) THEN
134: RAISE wsh_org_event_key_null;
135: ELSE
136: --bugfix 7190832
137: l_otm_installed := WSH_UTIL_CORE.GC3_Is_Installed;
138: --
139: IF l_otm_installed = 'Y' THEN
140:
141: WSH_SHIPPING_PARAMS_PVT.Get(

Line 153: IF (x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

149: WSH_DEBUG_SV.log(l_module_name,'After call to WSH_SHIPPING_PARAMS_PVT.Get x_return_status ',x_return_status);
150: WSH_DEBUG_SV.log(l_module_name,'l_shipping_param_info.otm_enabled',l_shipping_param_info.otm_enabled);
151: END IF;
152: --
153: IF (x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
154: Raise wsh_ship_param_failed;
155: END IF;
156: --
157: l_warehouse_type := NULL;

Line 206: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

202: IF (p_msg_display = 'Y' ) THEN
203: FND_MESSAGE.Set_Name('WSH', 'WSH_CARR_NOT_MANIFEST_ENABLED');
204: FND_MESSAGE.Set_Token('ENTITY_NAME', l_entity_name);
205: FND_MESSAGE.Set_Token('ENTITY_ID', l_entity_id);
206: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
207: END IF;
208: END IF;
209: END IF ;
210: ELSE

Line 215: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

211: l_warehouse_type := NULL;
212: END IF;
213: END IF;
214:
215: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
216:
217: IF l_debug_on THEN
218: wsh_debug_sv.log (l_module_name, 'Warehouse Type' , l_warehouse_type);
219: wsh_debug_sv.pop (l_module_name);

Line 225: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

221:
222: RETURN l_warehouse_type;
223: EXCEPTION
224: WHEN wsh_org_event_key_null THEN
225: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
226: IF l_debug_on THEN
227: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_org_event_key_null exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
228: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_org_event_key_null');
229: END IF;

Line 232: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

228: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_org_event_key_null');
229: END IF;
230: RETURN l_warehouse_type;
231: WHEN wsh_ship_param_failed THEN
232: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
233: IF l_debug_on THEN
234: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_ship_param_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
235: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_ship_param_failed');
236: END IF;

Line 240: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

236: END IF;
237: RETURN l_warehouse_type;
238:
239: WHEN OTHERS THEN
240: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
241: IF l_debug_on THEN
242: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
243: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
244: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 347: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

343: WSH_DEBUG_SV.log(l_module_name,'event_key',P_txn_hist_record.event_key);
344: WSH_DEBUG_SV.log(l_module_name,'item_type',P_txn_hist_record.item_type);
345: WSH_DEBUG_SV.log(l_module_name,'internal_control_number',P_txn_hist_record.internal_control_number);
346: END IF;
347: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
348:
349: l_txn_hist_record := P_txn_hist_record;
350:
351: -- Get the event name from the Transaction History Table.

Line 389: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN

385: IF l_debug_on THEN
386: wsh_debug_sv.log (l_module_name, 'Return status after get_event_key' , l_Return_Status);
387: END IF;
388:
389: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
390: RAISE wsh_get_event_key_error;
391: END IF;
392: -- Assign the value to the Transaction History record.
393: l_txn_hist_record.Event_Key := l_Event_Key;

Line 573: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN

569: wsh_debug_sv.log (l_module_name, 'Transaction History return status ' , l_Return_Status);
570: wsh_debug_sv.log (l_module_name, 'Transaction History ID' , l_txns_id);
571: END IF;
572:
573: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
574: RAISE wsh_update_history;
575: END IF;
576: -- Commit the data into the Transaction History table for the views.
577: COMMIT;

Line 603: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

599: wsh_debug_sv.pop(l_module_name);
600: END IF;
601: EXCEPTION
602: WHEN wsh_invalid_event_name THEN
603: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
604: IF l_debug_on THEN
605: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_event_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
606: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_event_name');
607: END IF;

Line 610: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

606: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_event_name');
607: END IF;
608:
609: WHEN wsh_get_event_key_error THEN
610: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
611: IF l_debug_on THEN
612: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_get_event_key_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
613: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_get_event_key_error');
614: END IF;

Line 617: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

613: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_get_event_key_error');
614: END IF;
615:
616: WHEN wsh_invalid_delivery_no THEN
617: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
618: IF l_debug_on THEN
619: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_delivery_no exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
620: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_no');
621: END IF;

Line 624: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

620: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_no');
621: END IF;
622:
623: WHEN wsh_update_history THEN
624: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
625: IF l_debug_on THEN
626: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_update_history exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
627: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_update_history');
628: END IF;

Line 631: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

627: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_update_history');
628: END IF;
629:
630: WHEN OTHERS THEN
631: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
632: IF l_debug_on THEN
633: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
634: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
635: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 677: x_return_status := wsh_util_core.g_ret_sts_error;

673: open get_item_id_cur;
674: Fetch get_item_id_cur into x_inventory_item_id;
675:
676: IF get_item_id_cur%NOTFOUND THEN
677: x_return_status := wsh_util_core.g_ret_sts_error;
678: ELSE
679: x_return_status := wsh_util_core.g_ret_sts_success;
680: END IF;
681: close get_item_id_cur;

Line 679: x_return_status := wsh_util_core.g_ret_sts_success;

675:
676: IF get_item_id_cur%NOTFOUND THEN
677: x_return_status := wsh_util_core.g_ret_sts_error;
678: ELSE
679: x_return_status := wsh_util_core.g_ret_sts_success;
680: END IF;
681: close get_item_id_cur;
682: ELSE
683: x_return_status := wsh_util_core.g_ret_sts_success;

Line 683: x_return_status := wsh_util_core.g_ret_sts_success;

679: x_return_status := wsh_util_core.g_ret_sts_success;
680: END IF;
681: close get_item_id_cur;
682: ELSE
683: x_return_status := wsh_util_core.g_ret_sts_success;
684: END IF;
685:
686: IF l_debug_on THEN
687: wsh_debug_sv.pop (l_module_name);

Line 691: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

687: wsh_debug_sv.pop (l_module_name);
688: END IF;
689: EXCEPTION
690: WHEN OTHERS THEN
691: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
692: IF get_item_id_cur%ISOPEN THEN
693: close get_item_id_cur;
694: END IF;
695: IF l_debug_on THEN

Line 845: IF l_return_status NOT IN(wsh_util_core.g_ret_sts_success, wsh_util_core.g_ret_sts_warning) THEN

841: x_return_status => l_return_status);
842:
843: -- Success or Warning to be treated as success
844: -- Since warning of transfer location not to be treated as invalid ship to
845: IF l_return_status NOT IN(wsh_util_core.g_ret_sts_success, wsh_util_core.g_ret_sts_warning) THEN
846: raise fnd_api.g_exc_error;
847: END IF;
848: x_location_id := l_loc_rec.WSH_LOCATION_ID;
849: x_return_status := wsh_util_core.g_ret_sts_success;

Line 849: x_return_status := wsh_util_core.g_ret_sts_success;

845: IF l_return_status NOT IN(wsh_util_core.g_ret_sts_success, wsh_util_core.g_ret_sts_warning) THEN
846: raise fnd_api.g_exc_error;
847: END IF;
848: x_location_id := l_loc_rec.WSH_LOCATION_ID;
849: x_return_status := wsh_util_core.g_ret_sts_success;
850: END IF; --}
851: -- close get_loc_id_cur; bug 3920178
852: ELSE
853: x_return_status := wsh_util_core.g_ret_sts_success;

Line 853: x_return_status := wsh_util_core.g_ret_sts_success;

849: x_return_status := wsh_util_core.g_ret_sts_success;
850: END IF; --}
851: -- close get_loc_id_cur; bug 3920178
852: ELSE
853: x_return_status := wsh_util_core.g_ret_sts_success;
854: END IF;
855:
856: IF l_debug_on THEN
857: wsh_debug_sv.log(l_module_name, 'Location Id', x_location_id);

Line 864: x_return_status := wsh_util_core.g_ret_sts_error;

860: wsh_debug_sv.pop (l_module_name);
861: END IF;
862: EXCEPTION
863: WHEN fnd_api.g_exc_error THEN
864: x_return_status := wsh_util_core.g_ret_sts_error;
865: IF get_loc_id_cur%ISOPEN THEN
866: close get_loc_id_cur;
867: END IF;
868: IF l_debug_on THEN

Line 873: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

869: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
870: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
871: END IF;
872: WHEN OTHERS THEN
873: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
874: IF get_loc_id_cur%ISOPEN THEN
875: close get_loc_id_cur;
876: END IF;
877: IF l_debug_on THEN