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 176: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

172:
173: EXCEPTION
174: WHEN OTHERS THEN
175: ROLLBACK TO WSH_ITM_EXPORT_COMPLIANCE;
176: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
177: IF l_debug_on THEN
178: WSH_DEBUG_SV.log(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);
179: WSH_DEBUG_SV.pop(l_module_name);
180: END IF;

Line 309: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

305:
306: EXCEPTION
307: WHEN OTHERS THEN
308: ROLLBACK TO WSH_ITM_EXPORT_COMPLIANCE;
309: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
310: IF l_debug_on THEN
311: WSH_DEBUG_SV.log(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);
312: WSH_DEBUG_SV.pop(l_module_name);
313: END IF;

Line 454: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

450: l_Delivery_Condn8Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
451: l_Delivery_Condn9Tab WSH_ITM_QUERY_CUSTOM.g_ValueTableType;
452: BEGIN
453:
454: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
455: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
456:
457: IF l_debug_on IS NULL
458: THEN

Line 619: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

615: );
616:
617: -- Error Handling Section
618:
619: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
620: IF l_debug_on THEN
621: WSH_DEBUG_SV.log(l_module_name,' Error Handling the exception for Delivery Id : '||l_num_delivery_id_tab(j));
622: END IF;
623:

Line 625: WSH_UTIL_CORE.Add_Message(l_return_status);

621: WSH_DEBUG_SV.log(l_module_name,' Error Handling the exception for Delivery Id : '||l_num_delivery_id_tab(j));
622: END IF;
623:
624: IF l_msg_count IS NOT NULL THEN
625: WSH_UTIL_CORE.Add_Message(l_return_status);
626: FOR i IN 1 ..l_msg_count LOOP
627: l_msg_data := FND_MSG_PUB.get
628: (
629: p_msg_index => i,

Line 691: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

687: p_delivery_id => l_num_delivery_id_tab(j),
688: p_delivery_name => l_varchar_delivery_name_tab(j)
689: );
690:
691: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
692:
693: IF l_debug_on THEN
694: WSH_DEBUG_SV.log(l_module_name,' Error Logging the exception for Delivery Id : ',l_num_delivery_id_tab(j));
695: END IF;

Line 698: WSH_UTIL_CORE.Add_Message(l_return_status);

694: WSH_DEBUG_SV.log(l_module_name,' Error Logging the exception for Delivery Id : ',l_num_delivery_id_tab(j));
695: END IF;
696:
697: IF l_msg_count IS NOT NULL THEN
698: WSH_UTIL_CORE.Add_Message(l_return_status);
699: FOR i in 1 ..l_msg_count LOOP
700: l_msg_data := FND_MSG_PUB.get
701: (
702: p_msg_index => i,

Line 801: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

797: l_tranx_history_rec,
798: x_txns_id,
799: x_return_status
800: );
801: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
802: ROLLBACK TO WSH_ITM_EXPORT_COMPLIANCE;
803: IF l_debug_on THEN
804: WSH_DEBUG_SV.log(l_module_name,'Create_Update_Txns_History failed ' || x_return_status);
805: WSH_DEBUG_SV.pop(l_module_name);

Line 864: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

860: WSH_ITM_EXPORT_SCREENING.POPULATE_SERIAL_NUMBERS(l_request_control_id_s
861: ,l_num_delivery_id_tab(k)
862: , x_return_status);
863:
864: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
865: ROLLBACK TO WSH_ITM_EXPORT_COMPLIANCE;
866: IF l_debug_on THEN
867: WSH_DEBUG_SV.log(l_module_name,'Create_Serial_numbers_failed ' || x_return_status);
868: WSH_DEBUG_SV.pop(l_module_name);

Line 895: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

891: WHEN OTHERS THEN
892:
893:
894: ROLLBACK TO WSH_ITM_EXPORT_COMPLIANCE;
895: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
896: IF l_debug_on THEN
897: WSH_DEBUG_SV.log(l_module_name,'The unexpected Error Code ' || SQLCODE || ' : ' || SQLERRM);
898: WSH_DEBUG_SV.pop(l_module_name);
899: END IF;

Line 1048: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1044:
1045: 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);
1046:
1047:
1048: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1049: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error in procedure WSH_ITM_EXPORT_SCREENING.SCREEN_DELIVERIES for Pick Release event ');
1050: retcode := 2;
1051: IF l_debug_on THEN
1052: WSH_DEBUG_SV.pop(l_module_name);

Line 1064: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

1060: l_return_status := NULL;
1061:
1062: 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);
1063:
1064: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1065: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error in procedure WSH_ITM_EXPORT_SCREENING.SCREEN_DELIVERIES for Ship Confirm event ');
1066: retcode := 2;
1067: IF l_debug_on THEN
1068: WSH_DEBUG_SV.pop(l_module_name);