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 144: l_otm_installed := WSH_UTIL_CORE.GC3_Is_Installed;

140: ELSIF ( p_organization_id IS NULL ) THEN
141: RAISE wsh_org_event_key_null;
142: ELSE --{
143: --bugfix 7190832
144: l_otm_installed := WSH_UTIL_CORE.GC3_Is_Installed;
145: --
146: IF l_otm_installed = 'Y' THEN
147:
148: WSH_SHIPPING_PARAMS_PVT.Get(

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

156: WSH_DEBUG_SV.log(l_module_name,'After call to WSH_SHIPPING_PARAMS_PVT.Get x_return_status ',x_return_status);
157: WSH_DEBUG_SV.log(l_module_name,'l_shipping_param_info.otm_enabled',l_shipping_param_info.otm_enabled);
158: END IF;
159: --
160: IF (x_return_status in (WSH_UTIL_CORE.G_RET_STS_ERROR,WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
161: Raise wsh_ship_param_failed;
162: END IF;
163: --
164: l_warehouse_type := NULL;

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

219: IF (p_msg_display = 'Y' ) THEN
220: FND_MESSAGE.Set_Name('WSH', 'WSH_CARR_NOT_MANIFEST_ENABLED');
221: FND_MESSAGE.Set_Token('ENTITY_NAME', l_entity_name);
222: FND_MESSAGE.Set_Token('ENTITY_ID', l_entity_id);
223: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
224: END IF;
225: END IF;
226: END IF ;
227: ELSE

Line 232: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

228: l_warehouse_type := NULL;
229: END IF;
230: END IF; --}
231:
232: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
233:
234: IF l_debug_on THEN
235: wsh_debug_sv.log (l_module_name, 'Warehouse Type' , l_warehouse_type);
236: wsh_debug_sv.pop (l_module_name);

Line 242: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

238:
239: RETURN l_warehouse_type;
240: EXCEPTION
241: WHEN wsh_org_event_key_null THEN
242: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
243: IF l_debug_on THEN
244: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_org_event_key_null exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
245: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_org_event_key_null');
246: END IF;

Line 249: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

245: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_org_event_key_null');
246: END IF;
247: RETURN l_warehouse_type;
248: WHEN wsh_ship_param_failed THEN
249: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
250: IF l_debug_on THEN
251: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_ship_param_failed exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
252: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_ship_param_failed');
253: END IF;

Line 257: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

253: END IF;
254: RETURN l_warehouse_type;
255:
256: WHEN OTHERS THEN
257: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
258: IF l_debug_on THEN
259: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
260: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
261: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 381: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

377: WSH_DEBUG_SV.log(l_module_name,'item_type',P_txn_hist_record.item_type);
378: WSH_DEBUG_SV.log(l_module_name,'internal_control_number',P_txn_hist_record.internal_control_number);
379: WSH_DEBUG_SV.log(l_module_name,'client_code',P_txn_hist_record.client_code);
380: END IF;
381: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;
382:
383: l_txn_hist_record := P_txn_hist_record;
384:
385: -- Get the event name from the Transaction History Table.

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

425: IF l_debug_on THEN
426: wsh_debug_sv.log (l_module_name, 'Return status after get_event_key' , l_Return_Status);
427: END IF;
428:
429: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
430: RAISE wsh_get_event_key_error;
431: END IF;
432: -- Assign the value to the Transaction History record.
433: l_txn_hist_record.Event_Key := l_Event_Key;

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

682: wsh_debug_sv.log (l_module_name, 'Transaction History return status ' , l_Return_Status);
683: wsh_debug_sv.log (l_module_name, 'Transaction History ID' , l_txns_id);
684: END IF;
685:
686: IF ( l_Return_Status <> WSH_UTIL_CORE.g_ret_sts_success ) THEN
687: RAISE wsh_update_history;
688: END IF;
689: -- Commit the data into the Transaction History table for the views.
690: COMMIT;

Line 716: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

712: wsh_debug_sv.pop(l_module_name);
713: END IF;
714: EXCEPTION
715: WHEN wsh_invalid_event_name THEN
716: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
717: IF l_debug_on THEN
718: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_event_name exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
719: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_event_name');
720: END IF;

Line 723: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

719: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_event_name');
720: END IF;
721:
722: WHEN wsh_get_event_key_error THEN
723: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
724: IF l_debug_on THEN
725: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_get_event_key_error exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
726: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_get_event_key_error');
727: END IF;

Line 730: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

726: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_get_event_key_error');
727: END IF;
728:
729: WHEN wsh_invalid_delivery_no THEN
730: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
731: IF l_debug_on THEN
732: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_delivery_no exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
733: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_no');
734: END IF;

Line 737: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

733: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_delivery_no');
734: END IF;
735:
736: WHEN wsh_invalid_batch_no THEN --Fulfillment Batch XML Project
737: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
738: IF l_debug_on THEN
739: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_invalid_batch_no exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
740: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_batch_no');
741: END IF; --

Line 744: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;

740: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_invalid_batch_no');
741: END IF; --
742:
743: WHEN wsh_update_history THEN
744: x_return_status := WSH_UTIL_CORE.g_ret_sts_error;
745: IF l_debug_on THEN
746: WSH_DEBUG_SV.logmsg(l_module_name,'wsh_update_history exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
747: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_update_history');
748: END IF;

Line 751: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

747: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:wsh_update_history');
748: END IF;
749:
750: WHEN OTHERS THEN
751: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
752: IF l_debug_on THEN
753: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,
754: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
755: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 797: x_return_status := wsh_util_core.g_ret_sts_error;

793: open get_item_id_cur;
794: Fetch get_item_id_cur into x_inventory_item_id;
795:
796: IF get_item_id_cur%NOTFOUND THEN
797: x_return_status := wsh_util_core.g_ret_sts_error;
798: ELSE
799: x_return_status := wsh_util_core.g_ret_sts_success;
800: END IF;
801: close get_item_id_cur;

Line 799: x_return_status := wsh_util_core.g_ret_sts_success;

795:
796: IF get_item_id_cur%NOTFOUND THEN
797: x_return_status := wsh_util_core.g_ret_sts_error;
798: ELSE
799: x_return_status := wsh_util_core.g_ret_sts_success;
800: END IF;
801: close get_item_id_cur;
802: ELSE
803: x_return_status := wsh_util_core.g_ret_sts_success;

Line 803: x_return_status := wsh_util_core.g_ret_sts_success;

799: x_return_status := wsh_util_core.g_ret_sts_success;
800: END IF;
801: close get_item_id_cur;
802: ELSE
803: x_return_status := wsh_util_core.g_ret_sts_success;
804: END IF;
805:
806: IF l_debug_on THEN
807: wsh_debug_sv.pop (l_module_name);

Line 811: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

807: wsh_debug_sv.pop (l_module_name);
808: END IF;
809: EXCEPTION
810: WHEN OTHERS THEN
811: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
812: IF get_item_id_cur%ISOPEN THEN
813: close get_item_id_cur;
814: END IF;
815: IF l_debug_on THEN

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

961: x_return_status => l_return_status);
962:
963: -- Success or Warning to be treated as success
964: -- Since warning of transfer location not to be treated as invalid ship to
965: IF l_return_status NOT IN(wsh_util_core.g_ret_sts_success, wsh_util_core.g_ret_sts_warning) THEN
966: raise fnd_api.g_exc_error;
967: END IF;
968: x_location_id := l_loc_rec.WSH_LOCATION_ID;
969: x_return_status := wsh_util_core.g_ret_sts_success;

Line 969: x_return_status := wsh_util_core.g_ret_sts_success;

965: IF l_return_status NOT IN(wsh_util_core.g_ret_sts_success, wsh_util_core.g_ret_sts_warning) THEN
966: raise fnd_api.g_exc_error;
967: END IF;
968: x_location_id := l_loc_rec.WSH_LOCATION_ID;
969: x_return_status := wsh_util_core.g_ret_sts_success;
970: END IF; --}
971: -- close get_loc_id_cur; bug 3920178
972: ELSE
973: x_return_status := wsh_util_core.g_ret_sts_success;

Line 973: x_return_status := wsh_util_core.g_ret_sts_success;

969: x_return_status := wsh_util_core.g_ret_sts_success;
970: END IF; --}
971: -- close get_loc_id_cur; bug 3920178
972: ELSE
973: x_return_status := wsh_util_core.g_ret_sts_success;
974: END IF;
975:
976: IF l_debug_on THEN
977: wsh_debug_sv.log(l_module_name, 'Location Id', x_location_id);

Line 984: x_return_status := wsh_util_core.g_ret_sts_error;

980: wsh_debug_sv.pop (l_module_name);
981: END IF;
982: EXCEPTION
983: WHEN fnd_api.g_exc_error THEN
984: x_return_status := wsh_util_core.g_ret_sts_error;
985: IF get_loc_id_cur%ISOPEN THEN
986: close get_loc_id_cur;
987: END IF;
988: IF l_debug_on THEN

Line 993: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;

989: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
990: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
991: END IF;
992: WHEN OTHERS THEN
993: x_return_status := WSH_UTIL_CORE.g_ret_sts_unexp_error;
994: IF get_loc_id_cur%ISOPEN THEN
995: close get_loc_id_cur;
996: END IF;
997: IF l_debug_on THEN