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_WV_UTILS dependencies on WSH_NEW_DELIVERIES

Line 826: l_shipment_direction wsh_new_deliveries.shipment_direction%TYPE;

822: l_wt_uom_code VARCHAR2(3);
823: l_vol_uom_code VARCHAR2(3);
824: l_status_code VARCHAR2(2);
825: l_shipment_type_flag VARCHAR2(1);
826: l_shipment_direction wsh_new_deliveries.shipment_direction%TYPE;
827: l_frozen_flag VARCHAR2(1);
828: l_inv_item_id number;
829: l_org_gross_wt number;
830: l_org_net_wt number;

Line 1158: FROM wsh_new_deliveries

1154: l_vol_uom_code,
1155: l_status_code,
1156: l_shipment_direction,
1157: l_frozen_flag
1158: FROM wsh_new_deliveries
1159: WHERE delivery_id = p_entity_id
1160: AND NVL(wv_frozen_flag, 'Y') <> 'Y' -- BugFix 3570954
1161: FOR UPDATE NOWAIT;
1162: EXCEPTION

Line 1229: update wsh_new_deliveries

1225: -- Update the new W/V on the delivery
1226: IF l_debug_on THEN
1227: WSH_DEBUG_SV.logmsg(l_module_name,'Updating '||p_entity_id||' with Gross '||l_gross_weight||' Net '||l_net_weight||' Vol '||l_volume);
1228: END IF;
1229: update wsh_new_deliveries
1230: set gross_weight = l_gross_weight,
1231: net_weight = l_net_weight,
1232: volume = l_volume,
1233: last_update_date = SYSDATE,

Line 1684: FROM wsh_new_deliveries

1680: CURSOR C5(c_delivery_id IN NUMBER) IS
1681: SELECT gross_weight,
1682: net_weight,
1683: volume
1684: FROM wsh_new_deliveries
1685: WHERE delivery_id = c_delivery_id
1686: FOR UPDATE NOWAIT; --BugFix 3570954;
1687:
1688: -- BugFix 3570954

Line 1940: UPDATE wsh_new_deliveries

1936: INTO l_tmp_gross_wt,
1937: l_tmp_net_wt,
1938: l_tmp_vol;
1939:
1940: UPDATE wsh_new_deliveries
1941: SET gross_weight = null,
1942: net_weight = null,
1943: volume = null,
1944: wv_frozen_flag = 'N',

Line 2156: l_shipment_direction wsh_new_deliveries.shipment_direction%TYPE;

2152: l_wt_uom_code VARCHAR2(3);
2153: l_vol_uom_code VARCHAR2(3);
2154: l_return_status VARCHAR2(100);
2155: l_status_code VARCHAR2(2);
2156: l_shipment_direction wsh_new_deliveries.shipment_direction%TYPE;
2157: l_frozen_flag VARCHAR2(1);
2158: l_dummy NUMBER;
2159: l_trip_empty BOOLEAN;
2160: l_parent_delivery_id NUMBER;

Line 2198: FROM wsh_new_deliveries

2194: l_vol_uom_code,
2195: l_status_code,
2196: l_shipment_direction,
2197: l_frozen_flag
2198: FROM wsh_new_deliveries
2199: WHERE delivery_id = p_delivery_id;
2200:
2201: EXCEPTION
2202: WHEN NO_DATA_FOUND THEN

Line 3885: WSH_NEW_DELIVERIES wnd

3881: -- OTM R12 : packing ECO
3882: CURSOR c_get_delivery_info(p_detail_id IN NUMBER) IS
3883: SELECT wda.delivery_id
3884: FROM WSH_DELIVERY_ASSIGNMENTS wda,
3885: WSH_NEW_DELIVERIES wnd
3886: WHERE wda.delivery_detail_id = p_detail_id
3887: AND wda.delivery_id = wnd.delivery_id
3888: AND wnd.tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
3889: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

Line 3888: AND wnd.tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

3884: FROM WSH_DELIVERY_ASSIGNMENTS wda,
3885: WSH_NEW_DELIVERIES wnd
3886: WHERE wda.delivery_detail_id = p_detail_id
3887: AND wda.delivery_id = wnd.delivery_id
3888: AND wnd.tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
3889: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
3890: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
3891: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)
3892: AND NVL(wnd.ignore_for_planning, 'N') = 'N';

Line 3889: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

3885: WSH_NEW_DELIVERIES wnd
3886: WHERE wda.delivery_detail_id = p_detail_id
3887: AND wda.delivery_id = wnd.delivery_id
3888: AND wnd.tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
3889: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
3890: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
3891: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)
3892: AND NVL(wnd.ignore_for_planning, 'N') = 'N';
3893:

Line 3890: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

3886: WHERE wda.delivery_detail_id = p_detail_id
3887: AND wda.delivery_id = wnd.delivery_id
3888: AND wnd.tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
3889: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
3890: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
3891: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)
3892: AND NVL(wnd.ignore_for_planning, 'N') = 'N';
3893:
3894: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;

Line 3891: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)

3887: AND wda.delivery_id = wnd.delivery_id
3888: AND wnd.tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
3889: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
3890: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
3891: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)
3892: AND NVL(wnd.ignore_for_planning, 'N') = 'N';
3893:
3894: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;
3895: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

Line 3894: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;

3890: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
3891: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)
3892: AND NVL(wnd.ignore_for_planning, 'N') = 'N';
3893:
3894: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;
3895: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
3896: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
3897: l_count NUMBER;
3898: l_return_status VARCHAR2(1);

Line 4020: l_interface_flag_tab(l_count) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

4016: l_delivery_id IS NOT NULL) THEN
4017:
4018: l_count := l_count + 1;
4019: l_delivery_id_tab(l_count) := l_delivery_id;
4020: l_interface_flag_tab(l_count) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
4021: IF l_debug_on THEN
4022: WSH_DEBUG_SV.log(l_module_name, 'l_count', l_count);
4023: WSH_DEBUG_SV.log(l_module_name, 'l_delivery_id_tab', l_delivery_id_tab(l_count));
4024: WSH_DEBUG_SV.log(l_module_name, 'l_interface_flag_tab', l_interface_flag_tab(l_count));

Line 4039: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(

4035:
4036: -- OTM R12 : packing ECO
4037: -- There can be the same delivery_id's in l_delivery_id_tab
4038: IF (l_count > 0) THEN
4039: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(
4040: p_delivery_id_tab => l_delivery_id_tab,
4041: p_tms_interface_flag_tab => l_interface_flag_tab,
4042: x_return_status => l_return_status);
4043:

Line 4989: FROM wsh_new_deliveries

4985: NVL(wv_frozen_flag,'Y'),
4986: delivery_type,
4987: NVL(ignore_for_planning, 'N'), -- OTM R12 : packing ECO
4988: tms_interface_flag -- OTM R12 : packing ECO
4989: FROM wsh_new_deliveries
4990: WHERE delivery_id = p_delivery_id;
4991:
4992:
4993: -- MDC: calculate the wt/vol of the child deliveries

Line 5001: wsh_new_deliveries d

4997: d.volume_uom_code vol_uom,
4998: d.delivery_id del_id
4999: FROM wsh_delivery_legs l1,
5000: wsh_delivery_legs l2,
5001: wsh_new_deliveries d
5002: WHERE l1.delivery_id = p_delivery_id
5003: AND l1.delivery_leg_id = l2.parent_delivery_leg_id
5004: AND l2.delivery_id = d.delivery_id;
5005:

Line 5080: l_ignore_for_planning WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;

5076:
5077: e_abort exception;
5078:
5079: -- OTM R12 : packing ECO
5080: l_ignore_for_planning WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
5081: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
5082: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
5083: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
5084: -- End of OTM R12 : packing ECO

Line 5081: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;

5077: e_abort exception;
5078:
5079: -- OTM R12 : packing ECO
5080: l_ignore_for_planning WSH_NEW_DELIVERIES.IGNORE_FOR_PLANNING%TYPE;
5081: l_tms_interface_flag WSH_NEW_DELIVERIES.TMS_INTERFACE_FLAG%TYPE;
5082: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
5083: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
5084: -- End of OTM R12 : packing ECO
5085:

Line 5175: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

5171: -- tms_interface_flag is in CP UP AW AR state, which will be set to UR
5172: IF (WSH_WV_UTILS.G_RESET_WV ='Y' AND
5173: l_ignore_for_planning = 'N' AND
5174: l_tms_interface_flag IN
5175: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
5176: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
5177: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
5178: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
5179: -- setting this will impact the detail_weight_volume,

Line 5176: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

5172: IF (WSH_WV_UTILS.G_RESET_WV ='Y' AND
5173: l_ignore_for_planning = 'N' AND
5174: l_tms_interface_flag IN
5175: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
5176: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
5177: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
5178: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
5179: -- setting this will impact the detail_weight_volume,
5180: -- container_weight_volume calls later

Line 5177: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

5173: l_ignore_for_planning = 'N' AND
5174: l_tms_interface_flag IN
5175: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
5176: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
5177: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
5178: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
5179: -- setting this will impact the detail_weight_volume,
5180: -- container_weight_volume calls later
5181: G_DELIVERY_TMS_IMPACT := 'N';

Line 5178: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN

5174: l_tms_interface_flag IN
5175: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
5176: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
5177: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
5178: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
5179: -- setting this will impact the detail_weight_volume,
5180: -- container_weight_volume calls later
5181: G_DELIVERY_TMS_IMPACT := 'N';
5182: END IF;

Line 5690: UPDATE wsh_new_deliveries

5686: IF l_debug_on THEN
5687: WSH_DEBUG_SV.logmsg(l_module_name,'Updating Del '||p_delivery_id||' With Gross '||x_gross_weight||' Net '||x_net_weight||' Vol '||x_volume);
5688: END IF;
5689:
5690: UPDATE wsh_new_deliveries
5691: SET net_weight = x_net_weight,
5692: gross_weight = x_gross_weight,
5693: volume = x_volume,
5694: wv_frozen_flag = 'N',

Line 5716: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

5712: -- for the given delivery_id, G_DELIVERY_TMS_IMPACT is changed from N to Y
5713: IF (WSH_WV_UTILS.G_RESET_WV ='Y' AND
5714: G_DELIVERY_TMS_IMPACT = 'Y' AND
5715: l_tms_interface_flag IN (
5716: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
5717: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
5718: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
5719: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED) AND
5720: l_ignore_for_planning = 'N') THEN

Line 5717: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

5713: IF (WSH_WV_UTILS.G_RESET_WV ='Y' AND
5714: G_DELIVERY_TMS_IMPACT = 'Y' AND
5715: l_tms_interface_flag IN (
5716: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
5717: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
5718: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
5719: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED) AND
5720: l_ignore_for_planning = 'N') THEN
5721: l_delivery_id_tab(1) := p_delivery_id;

Line 5718: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

5714: G_DELIVERY_TMS_IMPACT = 'Y' AND
5715: l_tms_interface_flag IN (
5716: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
5717: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
5718: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
5719: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED) AND
5720: l_ignore_for_planning = 'N') THEN
5721: l_delivery_id_tab(1) := p_delivery_id;
5722: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 5719: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED) AND

5715: l_tms_interface_flag IN (
5716: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
5717: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
5718: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
5719: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED) AND
5720: l_ignore_for_planning = 'N') THEN
5721: l_delivery_id_tab(1) := p_delivery_id;
5722: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
5723: IF l_debug_on THEN

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

5718: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
5719: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED) AND
5720: l_ignore_for_planning = 'N') THEN
5721: l_delivery_id_tab(1) := p_delivery_id;
5722: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
5723: IF l_debug_on THEN
5724: WSH_DEBUG_SV.log(l_module_name, 'l_delivery_id_tab', l_delivery_id_tab(1));
5725: WSH_DEBUG_SV.log(l_module_name, 'l_interface_flag_tab', l_interface_flag_tab(1));
5726: END IF;

Line 5728: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(

5724: WSH_DEBUG_SV.log(l_module_name, 'l_delivery_id_tab', l_delivery_id_tab(1));
5725: WSH_DEBUG_SV.log(l_module_name, 'l_interface_flag_tab', l_interface_flag_tab(1));
5726: END IF;
5727:
5728: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(
5729: p_delivery_id_tab => l_delivery_id_tab,
5730: p_tms_interface_flag_tab => l_interface_flag_tab,
5731: x_return_status => l_return_status);
5732:

Line 5825: l_status_code wsh_new_deliveries.status_code%TYPE;

5821: l_org_gross_wt number;
5822: l_org_net_wt number;
5823: l_org_vol number;
5824: l_organization_id number;
5825: l_status_code wsh_new_deliveries.status_code%TYPE;
5826: l_shipment_direction wsh_new_deliveries.shipment_direction%TYPE;
5827: l_wv_frozen_flag wsh_new_deliveries.wv_frozen_flag%TYPE;
5828:
5829: l_return_status VARCHAR2(100);

Line 5826: l_shipment_direction wsh_new_deliveries.shipment_direction%TYPE;

5822: l_org_net_wt number;
5823: l_org_vol number;
5824: l_organization_id number;
5825: l_status_code wsh_new_deliveries.status_code%TYPE;
5826: l_shipment_direction wsh_new_deliveries.shipment_direction%TYPE;
5827: l_wv_frozen_flag wsh_new_deliveries.wv_frozen_flag%TYPE;
5828:
5829: l_return_status VARCHAR2(100);
5830: l_debug_on BOOLEAN;

Line 5827: l_wv_frozen_flag wsh_new_deliveries.wv_frozen_flag%TYPE;

5823: l_org_vol number;
5824: l_organization_id number;
5825: l_status_code wsh_new_deliveries.status_code%TYPE;
5826: l_shipment_direction wsh_new_deliveries.shipment_direction%TYPE;
5827: l_wv_frozen_flag wsh_new_deliveries.wv_frozen_flag%TYPE;
5828:
5829: l_return_status VARCHAR2(100);
5830: l_debug_on BOOLEAN;
5831: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DELIVERY_WEIGHT_VOLUME';

Line 5865: FROM wsh_new_deliveries

5861: l_organization_id,
5862: l_status_code,
5863: l_shipment_direction,
5864: l_wv_frozen_flag
5865: FROM wsh_new_deliveries
5866: WHERE delivery_id = p_delivery_id;
5867:
5868: EXCEPTION
5869: WHEN NO_DATA_FOUND THEN

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

6042:
6043: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
6044: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_ERROR');
6045: IF l_debug_on THEN
6046: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6047: END IF;
6048: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
6049: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6050: wsh_util_core.add_message(x_return_status);

Line 6048: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));

6044: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_ERROR');
6045: IF l_debug_on THEN
6046: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6047: END IF;
6048: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
6049: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6050: wsh_util_core.add_message(x_return_status);
6051: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';
6052: l_num_error := l_num_error + 1;

Line 6210: WSH_NEW_DELIVERIES wnd

6206: CURSOR c_get_delivery_info_cont(p_detail_id IN NUMBER) IS
6207: SELECT wda.delivery_id,
6208: wnd.weight_uom_code
6209: FROM WSH_DELIVERY_ASSIGNMENTS wda,
6210: WSH_NEW_DELIVERIES wnd
6211: WHERE wda.delivery_detail_id = p_detail_id
6212: AND wda.delivery_id = wnd.delivery_id
6213: AND wda.delivery_id IS NOT NULL
6214: AND NVL(wnd.ignore_for_planning, 'N') = 'N'

Line 6215: AND NVL(wnd.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)

6211: WHERE wda.delivery_detail_id = p_detail_id
6212: AND wda.delivery_id = wnd.delivery_id
6213: AND wda.delivery_id IS NOT NULL
6214: AND NVL(wnd.ignore_for_planning, 'N') = 'N'
6215: AND NVL(wnd.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6216: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
6217: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
6218: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
6219: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);

Line 6216: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

6212: AND wda.delivery_id = wnd.delivery_id
6213: AND wda.delivery_id IS NOT NULL
6214: AND NVL(wnd.ignore_for_planning, 'N') = 'N'
6215: AND NVL(wnd.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6216: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
6217: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
6218: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
6219: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);
6220:

Line 6217: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

6213: AND wda.delivery_id IS NOT NULL
6214: AND NVL(wnd.ignore_for_planning, 'N') = 'N'
6215: AND NVL(wnd.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6216: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
6217: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
6218: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
6219: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);
6220:
6221: CURSOR c_get_delivery_info_del(p_delivery_id IN NUMBER) IS

Line 6218: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

6214: AND NVL(wnd.ignore_for_planning, 'N') = 'N'
6215: AND NVL(wnd.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6216: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
6217: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
6218: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
6219: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);
6220:
6221: CURSOR c_get_delivery_info_del(p_delivery_id IN NUMBER) IS
6222: SELECT delivery_id,

Line 6219: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);

6215: AND NVL(wnd.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6216: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
6217: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
6218: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
6219: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);
6220:
6221: CURSOR c_get_delivery_info_del(p_delivery_id IN NUMBER) IS
6222: SELECT delivery_id,
6223: weight_uom_code

Line 6224: FROM WSH_NEW_DELIVERIES

6220:
6221: CURSOR c_get_delivery_info_del(p_delivery_id IN NUMBER) IS
6222: SELECT delivery_id,
6223: weight_uom_code
6224: FROM WSH_NEW_DELIVERIES
6225: WHERE delivery_id = p_delivery_id
6226: AND NVL(ignore_for_planning, 'N') = 'N'
6227: AND NVL(tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6228: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

Line 6227: AND NVL(tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)

6223: weight_uom_code
6224: FROM WSH_NEW_DELIVERIES
6225: WHERE delivery_id = p_delivery_id
6226: AND NVL(ignore_for_planning, 'N') = 'N'
6227: AND NVL(tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6228: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
6229: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
6230: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
6231: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);

Line 6228: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

6224: FROM WSH_NEW_DELIVERIES
6225: WHERE delivery_id = p_delivery_id
6226: AND NVL(ignore_for_planning, 'N') = 'N'
6227: AND NVL(tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6228: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
6229: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
6230: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
6231: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);
6232:

Line 6229: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

6225: WHERE delivery_id = p_delivery_id
6226: AND NVL(ignore_for_planning, 'N') = 'N'
6227: AND NVL(tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6228: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
6229: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
6230: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
6231: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);
6232:
6233: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;

Line 6230: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

6226: AND NVL(ignore_for_planning, 'N') = 'N'
6227: AND NVL(tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6228: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
6229: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
6230: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
6231: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);
6232:
6233: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;
6234: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

Line 6231: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);

6227: AND NVL(tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6228: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
6229: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
6230: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
6231: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);
6232:
6233: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;
6234: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
6235: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

Line 6233: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;

6229: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
6230: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
6231: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);
6232:
6233: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;
6234: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
6235: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
6236: l_gc3_is_installed VARCHAR2(1);
6237: l_weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE;

Line 6237: l_weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE;

6233: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;
6234: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
6235: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;
6236: l_gc3_is_installed VARCHAR2(1);
6237: l_weight_uom_code WSH_NEW_DELIVERIES.WEIGHT_UOM_CODE%TYPE;
6238: api_return_fail EXCEPTION;
6239:
6240: l_return_status VARCHAR2(1);
6241: l_debug_on BOOLEAN;

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

6337: l_delivery_id_tab(1) := l_delivery_id;
6338: l_interface_flag_tab(1) := 'UR';
6339:
6340: IF l_debug_on THEN
6341: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
6342: END IF;
6343:
6344: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(
6345: p_delivery_id_tab => l_delivery_id_tab,

Line 6344: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(

6340: IF l_debug_on THEN
6341: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
6342: END IF;
6343:
6344: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(
6345: p_delivery_id_tab => l_delivery_id_tab,
6346: p_tms_interface_flag_tab => l_interface_flag_tab,
6347: x_return_status => l_return_status);
6348:

Line 6350: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG: ' || l_return_status);

6346: p_tms_interface_flag_tab => l_interface_flag_tab,
6347: x_return_status => l_return_status);
6348:
6349: IF l_debug_on THEN
6350: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG: ' || l_return_status);
6351: END IF;
6352:
6353: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
6354: RAISE api_return_fail;