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 3901: AND wnd.tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

3897: FROM WSH_DELIVERY_ASSIGNMENTS wda,
3898: WSH_NEW_DELIVERIES wnd
3899: WHERE wda.delivery_detail_id = p_detail_id
3900: AND wda.delivery_id = wnd.delivery_id
3901: AND wnd.tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
3902: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
3903: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
3904: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)
3905: AND NVL(wnd.ignore_for_planning, 'N') = 'N';

Line 3902: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

3898: WSH_NEW_DELIVERIES wnd
3899: WHERE wda.delivery_detail_id = p_detail_id
3900: AND wda.delivery_id = wnd.delivery_id
3901: AND wnd.tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
3902: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
3903: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
3904: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)
3905: AND NVL(wnd.ignore_for_planning, 'N') = 'N';
3906:

Line 3903: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

3899: WHERE wda.delivery_detail_id = p_detail_id
3900: AND wda.delivery_id = wnd.delivery_id
3901: AND wnd.tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
3902: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
3903: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
3904: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)
3905: AND NVL(wnd.ignore_for_planning, 'N') = 'N';
3906:
3907: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;

Line 3904: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)

3900: AND wda.delivery_id = wnd.delivery_id
3901: AND wnd.tms_interface_flag IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
3902: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
3903: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
3904: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)
3905: AND NVL(wnd.ignore_for_planning, 'N') = 'N';
3906:
3907: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;
3908: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

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

4029: l_delivery_id IS NOT NULL) THEN
4030:
4031: l_count := l_count + 1;
4032: l_delivery_id_tab(l_count) := l_delivery_id;
4033: l_interface_flag_tab(l_count) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
4034: IF l_debug_on THEN
4035: WSH_DEBUG_SV.log(l_module_name, 'l_count', l_count);
4036: WSH_DEBUG_SV.log(l_module_name, 'l_delivery_id_tab', l_delivery_id_tab(l_count));
4037: WSH_DEBUG_SV.log(l_module_name, 'l_interface_flag_tab', l_interface_flag_tab(l_count));

Line 4052: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(

4048:
4049: -- OTM R12 : packing ECO
4050: -- There can be the same delivery_id's in l_delivery_id_tab
4051: IF (l_count > 0) THEN
4052: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(
4053: p_delivery_id_tab => l_delivery_id_tab,
4054: p_tms_interface_flag_tab => l_interface_flag_tab,
4055: x_return_status => l_return_status);
4056:

Line 5188: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

5184: -- tms_interface_flag is in CP UP AW AR state, which will be set to UR
5185: IF (WSH_WV_UTILS.G_RESET_WV ='Y' AND
5186: l_ignore_for_planning = 'N' AND
5187: l_tms_interface_flag IN
5188: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
5189: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
5190: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
5191: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
5192: -- setting this will impact the detail_weight_volume,

Line 5189: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

5185: IF (WSH_WV_UTILS.G_RESET_WV ='Y' AND
5186: l_ignore_for_planning = 'N' AND
5187: l_tms_interface_flag IN
5188: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
5189: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
5190: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
5191: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
5192: -- setting this will impact the detail_weight_volume,
5193: -- container_weight_volume calls later

Line 5190: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

5186: l_ignore_for_planning = 'N' AND
5187: l_tms_interface_flag IN
5188: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
5189: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
5190: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
5191: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
5192: -- setting this will impact the detail_weight_volume,
5193: -- container_weight_volume calls later
5194: G_DELIVERY_TMS_IMPACT := 'N';

Line 5191: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN

5187: l_tms_interface_flag IN
5188: (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
5189: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
5190: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
5191: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED)) THEN
5192: -- setting this will impact the detail_weight_volume,
5193: -- container_weight_volume calls later
5194: G_DELIVERY_TMS_IMPACT := 'N';
5195: END IF;

Line 5729: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

5725: -- for the given delivery_id, G_DELIVERY_TMS_IMPACT is changed from N to Y
5726: IF (WSH_WV_UTILS.G_RESET_WV ='Y' AND
5727: G_DELIVERY_TMS_IMPACT = 'Y' AND
5728: l_tms_interface_flag IN (
5729: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
5730: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
5731: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
5732: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED) AND
5733: l_ignore_for_planning = 'N') THEN

Line 5730: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

5726: IF (WSH_WV_UTILS.G_RESET_WV ='Y' AND
5727: G_DELIVERY_TMS_IMPACT = 'Y' AND
5728: l_tms_interface_flag IN (
5729: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
5730: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
5731: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
5732: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED) AND
5733: l_ignore_for_planning = 'N') THEN
5734: l_delivery_id_tab(1) := p_delivery_id;

Line 5731: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

5727: G_DELIVERY_TMS_IMPACT = 'Y' AND
5728: l_tms_interface_flag IN (
5729: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
5730: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
5731: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
5732: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED) AND
5733: l_ignore_for_planning = 'N') THEN
5734: l_delivery_id_tab(1) := p_delivery_id;
5735: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;

Line 5732: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED) AND

5728: l_tms_interface_flag IN (
5729: WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
5730: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
5731: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
5732: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED) AND
5733: l_ignore_for_planning = 'N') THEN
5734: l_delivery_id_tab(1) := p_delivery_id;
5735: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
5736: IF l_debug_on THEN

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

5731: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
5732: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED) AND
5733: l_ignore_for_planning = 'N') THEN
5734: l_delivery_id_tab(1) := p_delivery_id;
5735: l_interface_flag_tab(1) := WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_REQUIRED;
5736: IF l_debug_on THEN
5737: WSH_DEBUG_SV.log(l_module_name, 'l_delivery_id_tab', l_delivery_id_tab(1));
5738: WSH_DEBUG_SV.log(l_module_name, 'l_interface_flag_tab', l_interface_flag_tab(1));
5739: END IF;

Line 5741: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(

5737: WSH_DEBUG_SV.log(l_module_name, 'l_delivery_id_tab', l_delivery_id_tab(1));
5738: WSH_DEBUG_SV.log(l_module_name, 'l_interface_flag_tab', l_interface_flag_tab(1));
5739: END IF;
5740:
5741: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(
5742: p_delivery_id_tab => l_delivery_id_tab,
5743: p_tms_interface_flag_tab => l_interface_flag_tab,
5744: x_return_status => l_return_status);
5745:

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

6055:
6056: IF (x_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
6057: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_ERROR');
6058: IF l_debug_on THEN
6059: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6060: END IF;
6061: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
6062: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6063: wsh_util_core.add_message(x_return_status);

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

6057: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_WT_VOL_ERROR');
6058: IF l_debug_on THEN
6059: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
6060: END IF;
6061: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_del_rows(i)));
6062: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
6063: wsh_util_core.add_message(x_return_status);
6064: WSH_NEW_DELIVERY_ACTIONS.g_error_level := 'E';
6065: l_num_error := l_num_error + 1;

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

6243: WHERE wda.delivery_detail_id = p_detail_id
6244: AND wda.delivery_id = wnd.delivery_id
6245: AND wda.delivery_id IS NOT NULL
6246: AND NVL(wnd.ignore_for_planning, 'N') = 'N'
6247: AND NVL(wnd.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6248: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
6249: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
6250: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
6251: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);

Line 6248: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

6244: AND wda.delivery_id = wnd.delivery_id
6245: AND wda.delivery_id IS NOT NULL
6246: AND NVL(wnd.ignore_for_planning, 'N') = 'N'
6247: AND NVL(wnd.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6248: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
6249: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
6250: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
6251: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);
6252:

Line 6249: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

6245: AND wda.delivery_id IS NOT NULL
6246: AND NVL(wnd.ignore_for_planning, 'N') = 'N'
6247: AND NVL(wnd.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6248: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
6249: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
6250: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
6251: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);
6252:
6253: CURSOR c_get_delivery_info_del(p_delivery_id IN NUMBER) IS

Line 6250: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

6246: AND NVL(wnd.ignore_for_planning, 'N') = 'N'
6247: AND NVL(wnd.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6248: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
6249: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
6250: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
6251: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);
6252:
6253: CURSOR c_get_delivery_info_del(p_delivery_id IN NUMBER) IS
6254: SELECT delivery_id,

Line 6251: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);

6247: AND NVL(wnd.tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6248: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
6249: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
6250: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
6251: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);
6252:
6253: CURSOR c_get_delivery_info_del(p_delivery_id IN NUMBER) IS
6254: SELECT delivery_id,
6255: weight_uom_code

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

6255: weight_uom_code
6256: FROM WSH_NEW_DELIVERIES
6257: WHERE delivery_id = p_delivery_id
6258: AND NVL(ignore_for_planning, 'N') = 'N'
6259: AND NVL(tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6260: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
6261: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
6262: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
6263: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);

Line 6260: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,

6256: FROM WSH_NEW_DELIVERIES
6257: WHERE delivery_id = p_delivery_id
6258: AND NVL(ignore_for_planning, 'N') = 'N'
6259: AND NVL(tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6260: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
6261: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
6262: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
6263: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);
6264:

Line 6261: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,

6257: WHERE delivery_id = p_delivery_id
6258: AND NVL(ignore_for_planning, 'N') = 'N'
6259: AND NVL(tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6260: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
6261: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
6262: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
6263: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);
6264:
6265: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;

Line 6262: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,

6258: AND NVL(ignore_for_planning, 'N') = 'N'
6259: AND NVL(tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6260: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
6261: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
6262: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
6263: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);
6264:
6265: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;
6266: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;

Line 6263: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);

6259: AND NVL(tms_interface_flag, WSH_NEW_DELIVERIES_PVT.C_TMS_NOT_TO_BE_SENT)
6260: IN (WSH_NEW_DELIVERIES_PVT.C_TMS_CREATE_IN_PROCESS,
6261: WSH_NEW_DELIVERIES_PVT.C_TMS_UPDATE_IN_PROCESS,
6262: WSH_NEW_DELIVERIES_PVT.C_TMS_AWAITING_ANSWER,
6263: WSH_NEW_DELIVERIES_PVT.C_TMS_ANSWER_RECEIVED);
6264:
6265: l_delivery_id WSH_NEW_DELIVERIES.DELIVERY_ID%TYPE;
6266: l_delivery_id_tab WSH_UTIL_CORE.ID_TAB_TYPE;
6267: l_interface_flag_tab WSH_UTIL_CORE.COLUMN_TAB_TYPE;

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

6369: l_delivery_id_tab(1) := l_delivery_id;
6370: l_interface_flag_tab(1) := 'UR';
6371:
6372: IF l_debug_on THEN
6373: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
6374: END IF;
6375:
6376: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(
6377: p_delivery_id_tab => l_delivery_id_tab,

Line 6376: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(

6372: IF l_debug_on THEN
6373: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG',WSH_DEBUG_SV.C_PROC_LEVEL);
6374: END IF;
6375:
6376: WSH_NEW_DELIVERIES_PVT.update_tms_interface_flag(
6377: p_delivery_id_tab => l_delivery_id_tab,
6378: p_tms_interface_flag_tab => l_interface_flag_tab,
6379: x_return_status => l_return_status);
6380:

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

6378: p_tms_interface_flag_tab => l_interface_flag_tab,
6379: x_return_status => l_return_status);
6380:
6381: IF l_debug_on THEN
6382: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_NEW_DELIVERIES_PVT.UPDATE_TMS_INTERFACE_FLAG: ' || l_return_status);
6383: END IF;
6384:
6385: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
6386: RAISE api_return_fail;