[Home] [Help]
3153: IF p_line_rec.ato_line_id = p_line_rec.line_id
3154: AND p_line_rec.item_type_code in ('STANDARD','OPTION')
3155: AND fnd_profile.value('INV_CTP') = '5' THEN
3156:
3157: l_org_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
3158:
3159: -- Added code to fix bug 2156268
3160: BEGIN
3161:
3343:
3344: BEGIN
3345: -- Added code to fix bug 2111470
3346: IF p_org_id is null THEN
3347: l_org_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
3348: END IF;
3349:
3350: SELECT msi.lot_control_code
3351: INTO l_lot_control_code
3496: -- l_rsv_time_fence_profile :=
3497: -- FND_PROFILE.VALUE('ONT_RESERVATION_TIME_FENCE');
3498:
3499: -- Moac. Fetching the reservation time fence from system parameter.
3500: l_rsv_time_fence_profile := OE_Sys_Parameters.VALUE('ONT_RESERVATION_TIME_FENCE');
3501:
3502: BEGIN
3503: l_rsv_time_fence := to_number(l_rsv_time_fence_profile);
3504: EXCEPTION
5346: -- Since we do not have MRP API currently, the following
5347: -- line is a kludge to get the ship_from_org_id
5348:
5349: l_out_line_rec.ship_from_org_id :=
5350: OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
5351:
5352: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5353: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5354: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
7651: l_atp_rec.ship_set := l_ship_set_name;
7652: l_atp_rec.arrival_set := l_arrival_set_name;
7653:
7654: ---------------------- Changes for Bug-2316250 ---------------------------
7655: l_organization_id := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID');
7656: --to fix bug 2795033,passing below l_line_rec.ordered_item instead of
7657: --l_line_rec.Original_ordered_item
7658:
7659: OE_ID_TO_VALUE.Ordered_Item