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

Line 187: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

183:
184: EXCEPTION
185: WHEN OTHERS THEN
186: ROLLBACK TO WSH_ITM_EXPORT_COMPLIANCE;
187: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
188: IF l_debug_on THEN
189: WSH_DEBUG_SV.log(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);
190: WSH_DEBUG_SV.pop(l_module_name);
191: END IF;

Line 322: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

318:
319: EXCEPTION
320: WHEN OTHERS THEN
321: ROLLBACK TO WSH_ITM_EXPORT_COMPLIANCE;
322: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
323: IF l_debug_on THEN
324: WSH_DEBUG_SV.log(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);
325: WSH_DEBUG_SV.pop(l_module_name);
326: END IF;

Line 467: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

463: l_Delivery_Condn8Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
464: l_Delivery_Condn9Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
465: BEGIN
466:
467: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
468: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
469:
470: IF l_debug_on IS NULL
471: THEN

Line 632: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

628: );
629:
630: -- Error Handling Section
631:
632: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
633: IF l_debug_on THEN
634: WSH_DEBUG_SV.log(l_module_name,' Error Handling the exception for Delivery Id : '||l_num_delivery_id_tab(j));
635: END IF;
636:

Line 638: WSH_UTIL_CORE.Add_Message(l_return_status);

634: WSH_DEBUG_SV.log(l_module_name,' Error Handling the exception for Delivery Id : '||l_num_delivery_id_tab(j));
635: END IF;
636:
637: IF l_msg_count IS NOT NULL THEN
638: WSH_UTIL_CORE.Add_Message(l_return_status);
639: FOR i IN 1 ..l_msg_count LOOP
640: l_msg_data := FND_MSG_PUB.get
641: (
642: p_msg_index => i,

Line 704: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

700: p_delivery_id => l_num_delivery_id_tab(j),
701: p_delivery_name => l_varchar_delivery_name_tab(j)
702: );
703:
704: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
705:
706: IF l_debug_on THEN
707: WSH_DEBUG_SV.log(l_module_name,' Error Logging the exception for Delivery Id : ',l_num_delivery_id_tab(j));
708: END IF;

Line 711: WSH_UTIL_CORE.Add_Message(l_return_status);

707: WSH_DEBUG_SV.log(l_module_name,' Error Logging the exception for Delivery Id : ',l_num_delivery_id_tab(j));
708: END IF;
709:
710: IF l_msg_count IS NOT NULL THEN
711: WSH_UTIL_CORE.Add_Message(l_return_status);
712: FOR i in 1 ..l_msg_count LOOP
713: l_msg_data := FND_MSG_PUB.get
714: (
715: p_msg_index => i,

Line 814: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

810: l_tranx_history_rec,
811: x_txns_id,
812: x_return_status
813: );
814: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
815: ROLLBACK TO WSH_ITM_EXPORT_COMPLIANCE;
816: IF l_debug_on THEN
817: WSH_DEBUG_SV.log(l_module_name,'Create_Update_Txns_History failed ' || x_return_status);
818: WSH_DEBUG_SV.pop(l_module_name);

Line 877: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

873: WSH_ITM_EXPORT_SCREENING.POPULATE_SERIAL_NUMBERS(l_request_control_id_s
874: ,l_num_delivery_id_tab(k)
875: , x_return_status);
876:
877: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
878: ROLLBACK TO WSH_ITM_EXPORT_COMPLIANCE;
879: IF l_debug_on THEN
880: WSH_DEBUG_SV.log(l_module_name,'Create_Serial_numbers_failed ' || x_return_status);
881: WSH_DEBUG_SV.pop(l_module_name);

Line 908: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

904: WHEN OTHERS THEN
905:
906:
907: ROLLBACK TO WSH_ITM_EXPORT_COMPLIANCE;
908: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
909: IF l_debug_on THEN
910: WSH_DEBUG_SV.log(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);
911: WSH_DEBUG_SV.pop(l_module_name);
912: END IF;

Line 1068: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1064:
1065: WSH_ITM_EXPORT_SCREENING.SCREEN_EVENT_DELIVERIES(l_return_status,p_organization_id,p_delivery_from_id,p_delivery_to_id,G_PICK_RELEASE_EVENT,p_ship_method_code,p_pickup_date_from,p_pickup_date_to);
1066:
1067:
1068: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1069: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error in procedure WSH_ITM_EXPORT_SCREENING.SCREEN_DELIVERIES for Pick Release event ');
1070: retcode := 2;
1071: IF l_debug_on THEN
1072: WSH_DEBUG_SV.pop(l_module_name);

Line 1084: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1080: l_return_status := NULL;
1081:
1082: WSH_ITM_EXPORT_SCREENING.SCREEN_EVENT_DELIVERIES(l_return_status,p_organization_id,p_delivery_from_id,p_delivery_to_id,G_SHIP_CONFIRM_EVENT,p_ship_method_code,p_pickup_date_from,p_pickup_date_to);
1083:
1084: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1085: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error in procedure WSH_ITM_EXPORT_SCREENING.SCREEN_DELIVERIES for Ship Confirm event ');
1086: retcode := 2;
1087: IF l_debug_on THEN
1088: WSH_DEBUG_SV.pop(l_module_name);