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_USA_QUANTITY_PVT dependencies on WSH_NEW_DELIVERIES_PVT

Line 927: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,

923: l_delivery_id_tab(1) := old_delivery_detail_rec.delivery_id;
924:
925: -- calculate the interface flag to be updated
926: IF old_delivery_detail_rec.tms_interface_flag IN
927: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
928: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
929: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
930: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
931: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 928: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

924:
925: -- calculate the interface flag to be updated
926: IF old_delivery_detail_rec.tms_interface_flag IN
927: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
928: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
929: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
930: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
931: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
932: IF l_debug_on THEN

Line 929: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

925: -- calculate the interface flag to be updated
926: IF old_delivery_detail_rec.tms_interface_flag IN
927: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
928: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
929: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
930: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
931: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
932: IF l_debug_on THEN
933: WSH_DEBUG_SV.log(l_module_name, 'l_delivery_id_tab', l_delivery_id_tab(1));

Line 930: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN

926: IF old_delivery_detail_rec.tms_interface_flag IN
927: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
928: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
929: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
930: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
931: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
932: IF l_debug_on THEN
933: WSH_DEBUG_SV.log(l_module_name, 'l_delivery_id_tab', l_delivery_id_tab(1));
934: WSH_DEBUG_SV.log(l_module_name, 'l_interface_flag_tab', l_interface_flag_tab(1));

Line 931: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

927: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
928: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
929: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
930: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
931: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
932: IF l_debug_on THEN
933: WSH_DEBUG_SV.log(l_module_name, 'l_delivery_id_tab', l_delivery_id_tab(1));
934: WSH_DEBUG_SV.log(l_module_name, 'l_interface_flag_tab', l_interface_flag_tab(1));
935: END IF;

Line 942: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

938: END IF;
939:
940:
941: IF (l_call_update = 'Y') THEN
942: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(
943: p_delivery_id_tab => l_delivery_id_tab,
944: p_tms_interface_flag_tab => l_interface_flag_tab,
945: x_return_status => l_return_status);
946:

Line 950: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');

946:
947: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
948: x_return_status := l_return_status;
949: IF l_debug_on THEN
950: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG');
951: WSH_DEBUG_SV.pop(l_module_name);
952: END IF;
953: RETURN;
954: END IF;

Line 2682: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,

2678: l_delivery_id_tab(1) := l_delivery_id;
2679:
2680: --calculate the interface flag to be updated
2681: IF l_tms_interface_flag IN
2682: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
2683: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
2684: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
2685: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
2686: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 2683: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

2679:
2680: --calculate the interface flag to be updated
2681: IF l_tms_interface_flag IN
2682: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
2683: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
2684: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
2685: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
2686: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
2687: ELSE

Line 2684: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

2680: --calculate the interface flag to be updated
2681: IF l_tms_interface_flag IN
2682: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
2683: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
2684: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
2685: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
2686: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
2687: ELSE
2688: l_call_update := 'N';

Line 2685: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN

2681: IF l_tms_interface_flag IN
2682: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
2683: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
2684: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
2685: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
2686: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
2687: ELSE
2688: l_call_update := 'N';
2689: END IF;

Line 2686: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

2682: (WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED,
2683: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
2684: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
2685: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS) THEN
2686: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
2687: ELSE
2688: l_call_update := 'N';
2689: END IF;
2690:

Line 2692: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

2688: l_call_update := 'N';
2689: END IF;
2690:
2691: IF (l_call_update = 'Y') THEN
2692: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(
2693: p_delivery_id_tab => l_delivery_id_tab,
2694: p_tms_interface_flag_tab => l_interface_flag_tab,
2695: x_return_status => l_return_status);
2696: