[Home] [Help]
460: RETURN;
461:
462: ELSIF l_assigned_to_trip = 'Y' THEN
463: FND_MESSAGE.SET_NAME('WSH','WSH_DEL_ASSIGNED_ERROR');
464: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(p_delivery_info.delivery_id));
465: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
466: wsh_util_core.add_message(x_return_status);
467: RETURN;
468: END IF;
478:
479: /* I Harmonization -- rvishnuv */
480: PROCEDURE map_pub_to_pvt(
481: p_pub_rec IN delivery_pub_rec_type,
482: x_pvt_rec OUT NOCOPY wsh_new_deliveries_pvt.delivery_rec_type,
483: x_return_status OUT NOCOPY VARCHAR2)
484: IS
485: --
486: l_debug_on BOOLEAN;
681: -- x_delivery_id - delivery_Id of new delivery,
682: -- x_name - Name of delivery
683: -- VERSION : current version 1.0
684: -- initial version 1.0
685: -- COMMENT : Creates or updates a record in wsh_new_deliveries table
686: -- with information specified in p_delivery_info
687: --========================================================================
688:
689: PROCEDURE Create_Update_Delivery(
706: --
707: l_message VARCHAR2(50);
708: l_num_errors NUMBER;
709: l_num_warnings NUMBER;
710: l_rec_attr_tab wsh_new_deliveries_pvt.delivery_attr_tbl_type;
711: l_delivery_in_rec wsh_deliveries_grp.Del_In_Rec_Type;
712: l_del_out_rec_tab wsh_deliveries_grp.Del_Out_Tbl_Type;
713: l_return_status VARCHAR2(1);
714: l_commit VARCHAR2(100) := FND_API.G_FALSE;
1167: -- Local Variables
1168: l_delivery_count NUMBER;
1169: l_count NUMBER;
1170: l_delivery_id NUMBER;
1171: l_delivery_name WSH_NEW_DELIVERIES.Name%TYPE;
1172: l_num_errors NUMBER;
1173: l_num_warnings NUMBER;
1174:
1175: -- Debug Variables