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

Line 1945: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

1941: l_return_status VARCHAR2(1);
1942: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
1943: l_is_delivery_empty VARCHAR2(1);
1944: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
1945: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
1946: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
1947: l_num_warnings NUMBER;
1948: l_debug_on BOOLEAN;
1949: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.'||G_PACKAGE_NAME||'.'||'Post_Otm_Assign_Del_Detail';

Line 2000: l_tms_interface_flag := nvl(l_delivery_info.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT);

1996: raise FND_API.G_EXC_ERROR;
1997: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
1998: l_num_warnings := l_num_warnings + 1;
1999: END IF;
2000: l_tms_interface_flag := nvl(l_delivery_info.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT);
2001:
2002: END IF;
2003:
2004: IF l_debug_on THEN

Line 2008: IF (l_tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN

2004: IF l_debug_on THEN
2005: WSH_DEBUG_SV.log(l_module_name, 'P_DELIVERY_WAS_EMPTY - L_TMS_INTERFACE_FLAG', l_tms_interface_flag);
2006: END IF;
2007:
2008: IF (l_tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN
2009: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED;
2010: ELSIF (l_tms_interface_flag in
2011: (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
2012: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN

Line 2009: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED;

2005: WSH_DEBUG_SV.log(l_module_name, 'P_DELIVERY_WAS_EMPTY - L_TMS_INTERFACE_FLAG', l_tms_interface_flag);
2006: END IF;
2007:
2008: IF (l_tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN
2009: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED;
2010: ELSIF (l_tms_interface_flag in
2011: (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
2012: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN
2013: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 2011: (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

2007:
2008: IF (l_tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN
2009: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED;
2010: ELSIF (l_tms_interface_flag in
2011: (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
2012: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN
2013: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
2014: ELSE
2015: l_call_update := 'N';

Line 2012: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN

2008: IF (l_tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN
2009: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED;
2010: ELSIF (l_tms_interface_flag in
2011: (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
2012: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN
2013: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
2014: ELSE
2015: l_call_update := 'N';
2016: END IF;

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

2009: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED;
2010: ELSIF (l_tms_interface_flag in
2011: (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
2012: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN
2013: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
2014: ELSE
2015: l_call_update := 'N';
2016: END IF;
2017: END IF;

Line 2031: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

2027: END IF;
2028: END IF;
2029:
2030: IF (l_call_update = 'Y') THEN
2031: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(
2032: p_delivery_id_tab => l_delivery_id_tab,
2033: p_tms_interface_flag_tab => l_interface_flag_tab,
2034: x_return_status => l_return_status);
2035:

Line 2038: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);

2034: x_return_status => l_return_status);
2035:
2036: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
2037: IF l_debug_on THEN
2038: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);
2039: END IF;
2040: raise FND_API.G_EXC_ERROR;
2041: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
2042: l_num_warnings := l_num_warnings + 1;

Line 2181: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

2177: l_operation_type VARCHAR2(100);
2178: -- K LPN CONV. rv
2179:
2180: -- OTM R12 : update delivery
2181: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2182: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
2183: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2184: l_tms_update VARCHAR2(1);
2185: l_trip_not_found VARCHAR2(1);

Line 2182: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

2178: -- K LPN CONV. rv
2179:
2180: -- OTM R12 : update delivery
2181: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2182: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
2183: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2184: l_tms_update VARCHAR2(1);
2185: l_trip_not_found VARCHAR2(1);
2186: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

Line 2893: wsh_new_deliveries_pvt.lock_dlvy_no_compare(p_delivery_id => l_del_id_for_container.delivery_id);

2889: -- Lock the delivery before update.
2890:
2891: BEGIN
2892:
2893: wsh_new_deliveries_pvt.lock_dlvy_no_compare(p_delivery_id => l_del_id_for_container.delivery_id);
2894:
2895: EXCEPTION
2896:
2897: WHEN OTHERS THEN

Line 2969: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,

2965: nvl(l_group_tab(l_group_index).carrier_id, -1)) <>
2966: nvl(l_delivery_info.carrier_id, -1)) THEN
2967:
2968: IF (l_delivery_info.tms_interface_flag NOT IN
2969: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
2970: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
2971: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
2972: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
2973: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN

Line 2970: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,

2966: nvl(l_delivery_info.carrier_id, -1)) THEN
2967:
2968: IF (l_delivery_info.tms_interface_flag NOT IN
2969: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
2970: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
2971: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
2972: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
2973: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
2974: l_tms_update := 'Y';

Line 2971: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

2967:
2968: IF (l_delivery_info.tms_interface_flag NOT IN
2969: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
2970: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
2971: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
2972: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
2973: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
2974: l_tms_update := 'Y';
2975: l_delivery_info_tab(1) := l_delivery_info;

Line 2972: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

2968: IF (l_delivery_info.tms_interface_flag NOT IN
2969: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
2970: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
2971: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
2972: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
2973: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
2974: l_tms_update := 'Y';
2975: l_delivery_info_tab(1) := l_delivery_info;
2976: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 2973: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN

2969: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
2970: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
2971: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
2972: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
2973: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
2974: l_tms_update := 'Y';
2975: l_delivery_info_tab(1) := l_delivery_info;
2976: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
2977: l_tms_version_number := nvl(l_delivery_info.tms_version_number, 1) + 1;

Line 2976: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

2972: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
2973: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
2974: l_tms_update := 'Y';
2975: l_delivery_info_tab(1) := l_delivery_info;
2976: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
2977: l_tms_version_number := nvl(l_delivery_info.tms_version_number, 1) + 1;
2978: END IF;
2979: END IF; -- checking the value differences
2980: END IF; -- IF ((l_trip_not_found = 'N' AND

Line 3000: TMS_INTERFACE_FLAG = decode(l_tms_update, 'Y', l_new_interface_flag_tab(1), nvl(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),

2996: service_level = NVL(service_level,l_group_tab(l_group_index).service_level),
2997: mode_of_transport = NVL(mode_of_transport, l_group_tab(l_group_index).mode_of_transport),
2998: carrier_id = NVL(carrier_id, l_group_tab(l_group_index).carrier_id),
2999: -- OTM R12
3000: TMS_INTERFACE_FLAG = decode(l_tms_update, 'Y', l_new_interface_flag_tab(1), nvl(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
3001: TMS_VERSION_NUMBER = decode(l_tms_update, 'Y', l_tms_version_number, nvl(tms_version_number, 1)),
3002: -- End of OTM R12
3003: last_update_date = SYSDATE,
3004: last_updated_by = FND_GLOBAL.USER_ID,

Line 3091: l_tms_interface_flag := nvl(l_delivery_info.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT);

3087: IF (l_tms_update = 'Y') THEN
3088: l_tms_interface_flag := l_new_interface_flag_tab(1);
3089: ELSIF (l_trip_info_rec.status_code = 'OP' OR
3090: l_trip_not_found = 'Y') THEN
3091: l_tms_interface_flag := nvl(l_delivery_info.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT);
3092: ELSE
3093: l_tms_interface_flag := NULL;
3094: END IF;
3095:

Line 4095: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

4091: l_num_warnings NUMBER := 0;
4092: -- K LPN CONV. rv
4093:
4094: -- OTM R12 : update delivery
4095: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
4096: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
4097: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4098: l_tms_update VARCHAR2(1);
4099: l_trip_not_found VARCHAR2(1);

Line 4096: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

4092: -- K LPN CONV. rv
4093:
4094: -- OTM R12 : update delivery
4095: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
4096: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
4097: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4098: l_tms_update VARCHAR2(1);
4099: l_trip_not_found VARCHAR2(1);
4100: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

Line 4264: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

4260: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4261: END IF;
4262: fnd_message.set_token('ENTITY1',nvl(wsh_container_utilities.get_cont_name(p_detail_id), p_detail_id));
4263: IF l_debug_on THEN
4264: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4265: END IF;
4266: fnd_message.set_token('ENTITY2',wsh_new_deliveries_pvt.get_name(p_delivery_id));
4267: END IF;
4268: END LOOP;

Line 4266: fnd_message.set_token('ENTITY2',wsh_new_deliveries_pvt.get_name(p_delivery_id));

4262: fnd_message.set_token('ENTITY1',nvl(wsh_container_utilities.get_cont_name(p_detail_id), p_detail_id));
4263: IF l_debug_on THEN
4264: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4265: END IF;
4266: fnd_message.set_token('ENTITY2',wsh_new_deliveries_pvt.get_name(p_delivery_id));
4267: END IF;
4268: END LOOP;
4269:
4270: OPEN c_all_details_below;

Line 4595: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,

4591: nvl(l_ship_method, '@@')) <>
4592: nvl(l_delivery_info.ship_method_code, '@@')) THEN
4593:
4594: IF (l_delivery_info.tms_interface_flag NOT IN
4595: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
4596: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
4597: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
4598: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
4599: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN

Line 4596: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,

4592: nvl(l_delivery_info.ship_method_code, '@@')) THEN
4593:
4594: IF (l_delivery_info.tms_interface_flag NOT IN
4595: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
4596: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
4597: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
4598: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
4599: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
4600: l_tms_update := 'Y';

Line 4597: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

4593:
4594: IF (l_delivery_info.tms_interface_flag NOT IN
4595: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
4596: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
4597: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
4598: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
4599: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
4600: l_tms_update := 'Y';
4601: l_delivery_info_tab(1) := l_delivery_info;

Line 4598: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

4594: IF (l_delivery_info.tms_interface_flag NOT IN
4595: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
4596: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
4597: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
4598: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
4599: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
4600: l_tms_update := 'Y';
4601: l_delivery_info_tab(1) := l_delivery_info;
4602: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 4599: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN

4595: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
4596: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
4597: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
4598: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
4599: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
4600: l_tms_update := 'Y';
4601: l_delivery_info_tab(1) := l_delivery_info;
4602: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
4603: l_tms_version_number := nvl(l_delivery_info.tms_version_number, 1) + 1;

Line 4602: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

4598: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
4599: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
4600: l_tms_update := 'Y';
4601: l_delivery_info_tab(1) := l_delivery_info;
4602: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
4603: l_tms_version_number := nvl(l_delivery_info.tms_version_number, 1) + 1;
4604: END IF;
4605: END IF; -- checking the value differences
4606: END IF; -- IF ((l_trip_not_found = 'N' AND

Line 4627: TMS_INTERFACE_FLAG = decode(l_tms_update, 'Y', l_new_interface_flag_tab(1), nvl(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),

4623: CARRIER_ID = decode(carrier_id, NULL, l_carrier_id, carrier_id),
4624: SHIP_METHOD_CODE = decode(ship_method_code, NULL, l_ship_method, ship_method_code),
4625: SHIPMENT_DIRECTION = l_detail.line_direction,
4626: -- OTM R12
4627: TMS_INTERFACE_FLAG = decode(l_tms_update, 'Y', l_new_interface_flag_tab(1), nvl(TMS_INTERFACE_FLAG, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)),
4628: TMS_VERSION_NUMBER = decode(l_tms_update, 'Y', l_tms_version_number, nvl(tms_version_number, 1))
4629: -- End of OTM R12
4630: WHERE delivery_id = p_delivery_id;
4631:

Line 4890: l_tms_interface_flag := nvl(l_delivery_info.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT);

4886: IF (l_tms_update = 'Y') THEN
4887: l_tms_interface_flag := l_new_interface_flag_tab(1);
4888: ELSIF (l_trip_info_rec.status_code = 'OP' OR
4889: l_trip_not_found = 'Y') THEN
4890: l_tms_interface_flag := nvl(l_delivery_info.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT);
4891: ELSE
4892: l_tms_interface_flag := NULL;
4893: END IF;
4894:

Line 7215: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;

7211: WSH_DEBUG_SV.log(l_module_name,'error from wsh_new_delivery_actions.is_delivery_empty');
7212: END IF;
7213: raise FND_API.G_EXC_ERROR;
7214: ELSIF (l_is_delivery_empty = 'Y') THEN
7215: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;
7216: ELSIF (l_is_delivery_empty = 'N') THEN
7217: IF (l_gross_weight = 0) THEN
7218: -- do not update if assign/unassign 0/NULL weight line/LPN
7219: -- to nonempty delivery

Line 7229: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

7225: END IF;
7226: END IF;
7227:
7228: IF l_call_update = 'Y' THEN
7229: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(
7230: p_delivery_id_tab => l_delivery_id_tab,
7231: p_tms_interface_flag_tab => l_interface_flag_tab,
7232: x_return_status => l_return_status);
7233:

Line 7237: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);

7233:
7234: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
7235: x_return_status := l_return_status;
7236: IF l_debug_on THEN
7237: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);
7238: WSH_DEBUG_SV.pop(l_module_name);
7239: END IF;
7240: RETURN;
7241: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

Line 11712: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id)); -- Bug#3542095

11708: --
11709: -- Check if the Parent Container is empty, if yes, recursivelly call this API
11710: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
11711: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_DET_ERROR');
11712: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id)); -- Bug#3542095
11713: FND_MESSAGE.SET_TOKEN('DET_NAME',p_ids_tobe_unassigned(i));
11714: x_return_status := l_return_status;
11715: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
11716: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN