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

Line 4155: -- 5.Updates wsh_new_deliveries with delivery level attributes of routing request.

4151: -- 1.Auto create delivery by calling api WSH_INTERFACE_GRP.Delivery_Detail_Action.
4152: -- 2.If delivery create is more than one than error out.
4153: -- 3.Delivery created is one, than go through details line to verify delivery associated is same with newly created delivery.
4154: -- 4.Plan the newly created delivery.
4155: -- 5.Updates wsh_new_deliveries with delivery level attributes of routing request.
4156: -- 6.If weight and volume is passed set the wv_frozen_flag to 'Y'.
4157: -- 7.Calculate the weight and volume.
4158: -- Parameters :
4159: -- IN:

Line 4193: FROM wsh_new_deliveries

4189: l_delivery_UOM_code VARCHAR2(3);
4190:
4191: CURSOR c_get_delivery_weight(p_deliveryid NUMBER) IS
4192: SELECT net_weight, gross_weight, weight_uom_code
4193: FROM wsh_new_deliveries
4194: WHERE delivery_id = p_deliveryid;
4195: --Proration
4196:
4197: --Cursor to get the PO and delivery information.

Line 4296: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_info.delivery_id));

4292:
4293: -- Scan through details line, delivery associated is same for all lines.
4294: IF (l_prev_delivery_id IS NOT NULL AND l_prev_delivery_id <> l_del_info.delivery_id) THEN
4295: FND_MESSAGE.SET_NAME('WSH','WSH_RR_PO_GROUP_NOT_MATCH');
4296: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_info.delivery_id));
4297: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_del_info.source_header_number);
4298: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM', l_del_info.source_line_number);
4299: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM', l_del_info.po_shipment_line_number);
4300: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_del_info.source_blanket_reference_num);

Line 4334: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_info.delivery_id));

4330: END IF;
4331:
4332:
4333: FND_MESSAGE.SET_NAME('WSH','WSH_RR_PO_GROUP_NOT_MATCH');
4334: FND_MESSAGE.SET_TOKEN('DEL_NAME',wsh_new_deliveries_pvt.get_name(l_del_info.delivery_id));
4335: FND_MESSAGE.SET_TOKEN('PO_HEADER_NUM',l_del_info.source_header_number);
4336: FND_MESSAGE.SET_TOKEN('PO_LINE_NUM', l_del_info.source_line_number);
4337: FND_MESSAGE.SET_TOKEN('PO_SHIPMENT_LINE_NUM', l_del_info.po_shipment_line_number);
4338: FND_MESSAGE.SET_TOKEN('PO_RELEASE_NUM',l_del_info.source_blanket_reference_num);

Line 4382: UPDATE wsh_new_deliveries

4378:
4379: IF (x_new_deliveries.count > 0 ) THEN
4380: --Update the created delivery with delivery attributes of routing request.
4381: FORALL i IN x_new_deliveries.first..x_new_deliveries.last
4382: UPDATE wsh_new_deliveries
4383: SET number_of_lpn = p_delivery.number_of_containers(p_delivery_index),
4384: net_weight = nvl(p_delivery.total_weight(p_delivery_index),net_weight),
4385: gross_weight = nvl(p_delivery.total_weight(p_delivery_index),gross_weight),
4386: weight_uom_code = nvl(p_delivery.weight_uom(p_delivery_index),weight_uom_code),

Line 5094: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(l_new_deliveries(l_del_new_index)));

5090: ELSE
5091: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
5092: l_warn_count:=l_warn_count + 1;
5093: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_WSH_DEL_WARN');
5094: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(l_new_deliveries(l_del_new_index)));
5095: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_prev_delivery_index);
5096: fnd_msg_pub.add;
5097: ELSE
5098: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_WSH_DEL_SUCCESS');

Line 5099: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(l_new_deliveries(l_del_new_index)));

5095: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_prev_delivery_index);
5096: fnd_msg_pub.add;
5097: ELSE
5098: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_WSH_DEL_SUCCESS');
5099: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(l_new_deliveries(l_del_new_index)));
5100: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_prev_delivery_index);
5101: END IF;
5102: END IF;
5103:

Line 5628: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(l_new_deliveries(l_del_new_index)));

5624: ELSE
5625: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING) THEN
5626: l_warn_count:=l_warn_count + 1;
5627: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_WSH_DEL_WARN');
5628: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(l_new_deliveries(l_del_new_index)));
5629: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_delivery_index);
5630: fnd_msg_pub.add;
5631: ELSE
5632: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_WSH_DEL_SUCCESS');

Line 5633: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(l_new_deliveries(l_del_new_index)));

5629: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_delivery_index);
5630: fnd_msg_pub.add;
5631: ELSE
5632: FND_MESSAGE.SET_NAME('WSH', 'WSH_RR_WSH_DEL_SUCCESS');
5633: FND_MESSAGE.SET_TOKEN('DEL_NAME', wsh_new_deliveries_pvt.get_name(l_new_deliveries(l_del_new_index)));
5634: FND_MESSAGE.SET_TOKEN('LINE_NUMBER', l_delivery_index);
5635: END IF;
5636: END IF;
5637: