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_PVT

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 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 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 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 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 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 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 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;