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 2056: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

2052: l_return_status VARCHAR2(1);
2053: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
2054: l_is_delivery_empty VARCHAR2(1);
2055: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2056: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
2057: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
2058: l_num_warnings NUMBER;
2059: l_debug_on BOOLEAN;
2060: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.'||G_PACKAGE_NAME||'.'||'Post_Otm_Assign_Del_Detail';

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

2107: raise FND_API.G_EXC_ERROR;
2108: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
2109: l_num_warnings := l_num_warnings + 1;
2110: END IF;
2111: l_tms_interface_flag := nvl(l_delivery_info.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT);
2112:
2113: END IF;
2114:
2115: IF l_debug_on THEN

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

2115: IF l_debug_on THEN
2116: WSH_DEBUG_SV.log(l_module_name, 'P_DELIVERY_WAS_EMPTY - L_TMS_INTERFACE_FLAG', l_tms_interface_flag);
2117: END IF;
2118:
2119: IF (l_tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN
2120: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED;
2121: ELSIF (l_tms_interface_flag in
2122: (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
2123: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN

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

2116: WSH_DEBUG_SV.log(l_module_name, 'P_DELIVERY_WAS_EMPTY - L_TMS_INTERFACE_FLAG', l_tms_interface_flag);
2117: END IF;
2118:
2119: IF (l_tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN
2120: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED;
2121: ELSIF (l_tms_interface_flag in
2122: (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
2123: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN
2124: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 2122: (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

2118:
2119: IF (l_tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN
2120: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED;
2121: ELSIF (l_tms_interface_flag in
2122: (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
2123: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN
2124: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
2125: ELSE
2126: l_call_update := 'N';

Line 2123: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN

2119: IF (l_tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT) THEN
2120: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED;
2121: ELSIF (l_tms_interface_flag in
2122: (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
2123: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN
2124: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
2125: ELSE
2126: l_call_update := 'N';
2127: END IF;

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

2120: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED;
2121: ELSIF (l_tms_interface_flag in
2122: (WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
2123: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS)) THEN
2124: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
2125: ELSE
2126: l_call_update := 'N';
2127: END IF;
2128: END IF;

Line 2137: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

2133: --now irrespective of gross weight UPDATE_TMS_INTERFACE_FLAG will be called
2134: END IF;
2135:
2136: IF (l_call_update = 'Y') THEN
2137: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(
2138: p_delivery_id_tab => l_delivery_id_tab,
2139: p_tms_interface_flag_tab => l_interface_flag_tab,
2140: x_return_status => l_return_status);
2141:

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

2140: x_return_status => l_return_status);
2141:
2142: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
2143: IF l_debug_on THEN
2144: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);
2145: END IF;
2146: raise FND_API.G_EXC_ERROR;
2147: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
2148: l_num_warnings := l_num_warnings + 1;

Line 2287: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

2283: l_operation_type VARCHAR2(100);
2284: -- K LPN CONV. rv
2285:
2286: -- OTM R12 : update delivery
2287: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2288: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
2289: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2290: l_tms_update VARCHAR2(1);
2291: l_trip_not_found VARCHAR2(1);

Line 2288: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

2284: -- K LPN CONV. rv
2285:
2286: -- OTM R12 : update delivery
2287: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
2288: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
2289: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
2290: l_tms_update VARCHAR2(1);
2291: l_trip_not_found VARCHAR2(1);
2292: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

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

3034: -- Lock the delivery before update.
3035:
3036: BEGIN
3037:
3038: wsh_new_deliveries_pvt.lock_dlvy_no_compare(p_delivery_id => l_del_id_for_container.delivery_id);
3039:
3040: EXCEPTION
3041:
3042: WHEN OTHERS THEN

Line 3114: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,

3110: nvl(l_group_tab(l_group_index).carrier_id, -1)) <>
3111: nvl(l_delivery_info.carrier_id, -1)) THEN
3112:
3113: IF (l_delivery_info.tms_interface_flag NOT IN
3114: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
3115: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
3116: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
3117: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
3118: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN

Line 3115: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,

3111: nvl(l_delivery_info.carrier_id, -1)) THEN
3112:
3113: IF (l_delivery_info.tms_interface_flag NOT IN
3114: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
3115: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
3116: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
3117: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
3118: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
3119: l_tms_update := 'Y';

Line 3116: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

3112:
3113: IF (l_delivery_info.tms_interface_flag NOT IN
3114: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
3115: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
3116: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
3117: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
3118: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
3119: l_tms_update := 'Y';
3120: l_delivery_info_tab(1) := l_delivery_info;

Line 3117: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

3113: IF (l_delivery_info.tms_interface_flag NOT IN
3114: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
3115: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
3116: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
3117: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
3118: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
3119: l_tms_update := 'Y';
3120: l_delivery_info_tab(1) := l_delivery_info;
3121: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 3118: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN

3114: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
3115: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
3116: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
3117: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
3118: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
3119: l_tms_update := 'Y';
3120: l_delivery_info_tab(1) := l_delivery_info;
3121: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
3122: l_tms_version_number := nvl(l_delivery_info.tms_version_number, 1) + 1;

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

3117: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
3118: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
3119: l_tms_update := 'Y';
3120: l_delivery_info_tab(1) := l_delivery_info;
3121: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
3122: l_tms_version_number := nvl(l_delivery_info.tms_version_number, 1) + 1;
3123: END IF;
3124: END IF; -- checking the value differences
3125: END IF; -- IF ((l_trip_not_found = 'N' AND

Line 3145: 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)),

3141: service_level = NVL(service_level,l_group_tab(l_group_index).service_level),
3142: mode_of_transport = NVL(mode_of_transport, l_group_tab(l_group_index).mode_of_transport),
3143: carrier_id = NVL(carrier_id, l_group_tab(l_group_index).carrier_id),
3144: -- OTM R12
3145: 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)),
3146: TMS_VERSION_NUMBER = decode(l_tms_update, 'Y', l_tms_version_number, nvl(tms_version_number, 1)),
3147: -- End of OTM R12
3148: last_update_date = SYSDATE,
3149: last_updated_by = FND_GLOBAL.USER_ID,

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

3232: IF (l_tms_update = 'Y') THEN
3233: l_tms_interface_flag := l_new_interface_flag_tab(1);
3234: ELSIF (l_trip_info_rec.status_code = 'OP' OR
3235: l_trip_not_found = 'Y') THEN
3236: l_tms_interface_flag := nvl(l_delivery_info.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT);
3237: ELSE
3238: l_tms_interface_flag := NULL;
3239: END IF;
3240:

Line 4242: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;

4238: l_num_warnings NUMBER := 0;
4239: -- K LPN CONV. rv
4240:
4241: -- OTM R12 : update delivery
4242: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
4243: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
4244: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4245: l_tms_update VARCHAR2(1);
4246: l_trip_not_found VARCHAR2(1);

Line 4243: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;

4239: -- K LPN CONV. rv
4240:
4241: -- OTM R12 : update delivery
4242: l_delivery_info_tab WSH_NEW_DELIVERIES_PVT.Delivery_Attr_Tbl_Type;
4243: l_delivery_info WSH_NEW_DELIVERIES_PVT.Delivery_Rec_Type;
4244: l_new_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
4245: l_tms_update VARCHAR2(1);
4246: l_trip_not_found VARCHAR2(1);
4247: l_trip_info_rec WSH_DELIVERY_VALIDATIONS.trip_info_rec_type;

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

4408: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4409: END IF;
4410: fnd_message.set_token('ENTITY1',nvl(wsh_container_utilities.get_cont_name(p_detail_id), p_detail_id));
4411: IF l_debug_on THEN
4412: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4413: END IF;
4414: fnd_message.set_token('ENTITY2',wsh_new_deliveries_pvt.get_name(p_delivery_id));
4415: END IF;
4416: END LOOP;

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

4410: fnd_message.set_token('ENTITY1',nvl(wsh_container_utilities.get_cont_name(p_detail_id), p_detail_id));
4411: IF l_debug_on THEN
4412: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4413: END IF;
4414: fnd_message.set_token('ENTITY2',wsh_new_deliveries_pvt.get_name(p_delivery_id));
4415: END IF;
4416: END LOOP;
4417:
4418: OPEN c_all_details_below;

Line 4745: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,

4741: nvl(l_ship_method, '@@')) <>
4742: nvl(l_delivery_info.ship_method_code, '@@')) THEN
4743:
4744: IF (l_delivery_info.tms_interface_flag NOT IN
4745: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
4746: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
4747: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
4748: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
4749: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN

Line 4746: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,

4742: nvl(l_delivery_info.ship_method_code, '@@')) THEN
4743:
4744: IF (l_delivery_info.tms_interface_flag NOT IN
4745: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
4746: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
4747: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
4748: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
4749: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
4750: l_tms_update := 'Y';

Line 4747: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,

4743:
4744: IF (l_delivery_info.tms_interface_flag NOT IN
4745: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
4746: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
4747: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
4748: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
4749: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
4750: l_tms_update := 'Y';
4751: l_delivery_info_tab(1) := l_delivery_info;

Line 4748: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,

4744: IF (l_delivery_info.tms_interface_flag NOT IN
4745: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
4746: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
4747: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
4748: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
4749: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
4750: l_tms_update := 'Y';
4751: l_delivery_info_tab(1) := l_delivery_info;
4752: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 4749: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN

4745: (WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT,
4746: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_REQUIRED,
4747: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED,
4748: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
4749: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
4750: l_tms_update := 'Y';
4751: l_delivery_info_tab(1) := l_delivery_info;
4752: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
4753: l_tms_version_number := nvl(l_delivery_info.tms_version_number, 1) + 1;

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

4748: WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS,
4749: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED)) THEN
4750: l_tms_update := 'Y';
4751: l_delivery_info_tab(1) := l_delivery_info;
4752: l_new_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
4753: l_tms_version_number := nvl(l_delivery_info.tms_version_number, 1) + 1;
4754: END IF;
4755: END IF; -- checking the value differences
4756: END IF; -- IF ((l_trip_not_found = 'N' AND

Line 4777: 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)),

4773: CARRIER_ID = decode(carrier_id, NULL, l_carrier_id, carrier_id),
4774: SHIP_METHOD_CODE = decode(ship_method_code, NULL, l_ship_method, ship_method_code),
4775: SHIPMENT_DIRECTION = l_detail.line_direction,
4776: -- OTM R12
4777: 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)),
4778: TMS_VERSION_NUMBER = decode(l_tms_update, 'Y', l_tms_version_number, nvl(tms_version_number, 1)),
4779: -- End of OTM R12
4780: client_id = decode(client_id,NULL,l_client_id,client_id) -- LSP PROJECT
4781: WHERE delivery_id = p_delivery_id;

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

5039: IF (l_tms_update = 'Y') THEN
5040: l_tms_interface_flag := l_new_interface_flag_tab(1);
5041: ELSIF (l_trip_info_rec.status_code = 'OP' OR
5042: l_trip_not_found = 'Y') THEN
5043: l_tms_interface_flag := nvl(l_delivery_info.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT);
5044: ELSE
5045: l_tms_interface_flag := NULL;
5046: END IF;
5047:

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

7380: WSH_DEBUG_SV.log(l_module_name,'error from wsh_new_delivery_actions.is_delivery_empty');
7381: END IF;
7382: raise FND_API.G_EXC_ERROR;
7383: ELSIF (l_is_delivery_empty = 'Y') THEN
7384: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_REQUIRED;
7385: ELSIF (l_is_delivery_empty = 'N') THEN
7386: l_interface_flag_tab(1) := NULL;
7387: --Bug7608629
7388: --removed code which checked for gross weight

Line 7393: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(

7389: --now irrespective of gross weight UPDATE_TMS_INTERFACE_FLAG will be called
7390: END IF;
7391:
7392: IF l_call_update = 'Y' THEN
7393: WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG(
7394: p_delivery_id_tab => l_delivery_id_tab,
7395: p_tms_interface_flag_tab => l_interface_flag_tab,
7396: x_return_status => l_return_status);
7397:

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

7397:
7398: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR, WSH_UTIL_CORE.G_RET_STS_ERROR)) THEN
7399: x_return_status := l_return_status;
7400: IF l_debug_on THEN
7401: WSH_DEBUG_SV.logmsg(l_module_name,'Error in WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG '||l_return_status);
7402: WSH_DEBUG_SV.pop(l_module_name);
7403: END IF;
7404: RETURN;
7405: ELSIF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN

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

12173: --
12174: -- Check if the Parent Container is empty, if yes, recursivelly call this API
12175: IF ( l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS ) THEN
12176: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_UNASSIGN_DET_ERROR');
12177: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_delivery_id)); -- Bug#3542095
12178: FND_MESSAGE.SET_TOKEN('DET_NAME',p_ids_tobe_unassigned(i));
12179: x_return_status := l_return_status;
12180: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
12181: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING THEN