[Home] [Help]
1499: oe_debug_pub.add('Entering Tax line',1);
1500:
1501: BEGIN
1502:
1503: OE_LINE_UTIL.Query_Row(p_line_id => l_line_id,
1504: x_line_rec => l_line_rec);
1505: l_old_line_rec := l_line_rec;
1506:
1507: EXCEPTION
2831: l_group_req_rec.old_ship_from_org_id := p_request_rec.param7;
2832: l_group_req_rec.old_ship_set_number := p_request_rec.param9;
2833: l_group_req_rec.old_arrival_set_number := p_request_rec.param10;
2834:
2835: OE_LINE_UTIL.Query_Row(p_line_id => p_request_rec.entity_id
2836: ,x_line_rec => l_line_rec);
2837:
2838: IF NVL(p_request_rec.param11,'N') = 'Y' THEN
2839:
3024: x_return_status := FND_API.G_RET_STS_SUCCESS;
3025:
3026: BEGIN
3027: -- query the return line and to see if it's a referenced line
3028: OE_Line_Util.query_row(p_line_id => p_line_id,
3029: x_line_rec => l_orig_line_rec);
3030: EXCEPTION
3031: WHEN NO_DATA_FOUND THEN
3032: RETURN;
3033: END;
3034:
3035: IF l_orig_line_rec.return_context is NOT NULL THEN
3036:
3037: OE_Line_Util.query_row(p_line_id => l_orig_line_rec.reference_line_id
3038: ,x_line_rec => l_reference_line_rec);
3039:
3040: IF l_reference_line_rec.item_type_code in ('STANDARD','OPTION',
3041: 'INCLUDED','CONFIG','SERVICE') THEN
3099: -- If COPY is calling and DFF is to be copied over
3100: IF OE_ORDER_COPY_UTIL.CALL_DFF_COPY_EXTN_API(l_orig_line_rec.org_id) AND
3101: l_copy_call
3102: THEN
3103: OE_Line_Util.query_row(p_line_id => l_child.line_id,
3104: x_line_rec => l_child_line_rec);
3105:
3106: IF OE_ORDER_COPY_UTIL.G_COPY_REC.line_descflex = FND_API.G_TRUE THEN
3107: -- Pre populate the DFF info from reference line
3359:
3360: x_return_status := FND_API.G_RET_STS_SUCCESS;
3361:
3362: BEGIN
3363: OE_Line_Util.query_row(p_line_id => p_line_id
3364: ,x_line_rec => l_orig_line_rec);
3365: EXCEPTION
3366: WHEN NO_DATA_FOUND THEN
3367: Return;
3414: IF l_reference_line_id IS NOT NULL AND
3415: l_reference_line_id <> FND_API.G_MISS_NUM THEN
3416:
3417: OE_DEBUG_PUB.ADD(' There is a reference Line',1);
3418: OE_Line_Util.query_row(p_line_id => l_reference_line_id,
3419: x_line_rec => l_reference_line_rec);
3420: l_inventory_item_id := l_reference_line_rec.inventory_item_id;
3421: l_ship_from_org_id := l_reference_line_rec.ship_from_org_id;
3422: oe_debug_pub.add(to_char(l_inventory_item_id)||':'||to_char(l_ship_from_org_id),2);
3632: l_lin_line_id NUMBER; -- Bug 5754554
3633:
3634: BEGIN
3635: oe_debug_pub.add('Entering oe_delayed_requests_util.Validate_Line_Set',1);
3636: oe_line_util.query_rows(p_line_set_id => p_line_set_id,
3637: x_line_tbl => l_line_tbl);
3638:
3639: -- Start for bug 5754554
3640: IF l_line_tbl.count > 0 THEN
4021: END IF;
4022: oe_debug_pub.add('Do cascade services', 2);
4023:
4024: -- query the service line and to see if it's a referenced line
4025: OE_Line_Util.query_row(p_line_id => p_serviced_line_id,
4026: x_line_rec => l_orig_line_rec);
4027:
4028: SELECT /* MOAC_SQL_CHANGE */ h.order_number
4029: INTO l_order_number
4034:
4035:
4036:
4037: IF l_orig_line_rec.service_reference_type_code is NOT NULL THEN
4038: OE_Line_Util.query_row(p_line_id => l_orig_line_rec.service_reference_line_id,
4039: x_line_rec => l_reference_line_rec);
4040: l_service_reference_line_id := l_orig_line_rec.service_reference_line_id;
4041: oe_debug_pub.add('JPN: Service Reference Line is' || l_service_reference_line_id,2);
4042:
4338: END IF;
4339: oe_debug_pub.add('Do cascade services', 2);
4340:
4341: -- query the option line
4342: OE_Line_Util.query_row(p_line_id => p_option_line_id,
4343: x_line_rec => l_orig_line_rec);
4344:
4345: SELECT /* MOAC_SQL_CHANGE */ h.order_number
4346: INTO l_order_number
4622: l_request_rec := p_sch_set_tbl(I);
4623: -- Assiging miss rec.
4624: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
4625:
4626: OE_LINE_UTIL.Lock_Row(p_line_id => l_request_rec.entity_id,
4627: p_x_line_rec => l_line_rec,
4628: x_return_status => l_return_status);
4629:
4630: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN