[Home] [Help]
474: RETURN;
475:
476: ELSIF l_assigned_to_trip = 'Y' THEN
477: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGNED_ERROR');
478: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_info.delivery_id));
479: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
480: wsh_util_core.add_message(x_return_status);
481: RETURN;
482: END IF;
493:
494: /* I Harmonization -- rvishnuv */
495: PROCEDURE map_pub_to_pvt(
496: p_pub_rec IN delivery_pub_rec_type,
497: x_pvt_rec OUT NOCOPY wsh_new_deliveries_pvt.delivery_rec_type,
498: x_return_status OUT NOCOPY VARCHAR2)
499: IS
500: --
501: l_debug_on BOOLEAN;
703: -- x_delivery_id - delivery_Id of new delivery,
704: -- x_name - Name of delivery
705: -- VERSION : current version 1.0
706: -- initial version 1.0
707: -- COMMENT : Creates or updates a record in wsh_new_deliveries table
708: -- with information specified in p_delivery_info
709: --========================================================================
710:
711: PROCEDURE Create_Update_Delivery(
728: --
729: l_message VARCHAR2(50);
730: l_num_errors NUMBER;
731: l_num_warnings NUMBER;
732: l_rec_attr_tab wsh_new_deliveries_pvt.delivery_attr_tbl_type;
733: l_delivery_in_rec wsh_deliveries_grp.Del_In_Rec_Type;
734: l_del_out_rec_tab wsh_deliveries_grp.Del_Out_Tbl_Type;
735: l_return_status VARCHAR2(1);
736: l_commit VARCHAR2(100) := FND_API.G_FALSE;
816: IF l_debug_on THEN
817: wsh_debug_sv.log(l_module_name,'Locking del ',l_rec_attr_tab(1).delivery_id);
818: END IF;
819: BEGIN
820: WSH_NEW_DELIVERIES_PVT.Lock_Dlvy_No_Compare(l_rec_attr_tab(1).delivery_id);
821: EXCEPTION
822:
823: WHEN OTHERS THEN
824: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1254: -- Local Variables
1255: l_delivery_count NUMBER;
1256: l_count NUMBER;
1257: l_delivery_id NUMBER;
1258: l_delivery_name WSH_NEW_DELIVERIES.Name%TYPE;
1259: l_num_errors NUMBER;
1260: l_num_warnings NUMBER;
1261:
1262: -- Debug Variables