[Home] [Help]
1701: l_line_tbl(I).change_comments := 'Set Action';
1702: -- bug 3692277 ends }
1703:
1704: IF (l_line_tbl(I).top_model_line_id <> l_line_tbl(I).line_id AND
1705: l_line_tbl(I).item_type_code <> 'STANDARD'
1706: AND
1707: nvl(l_line_tbl(I).model_remnant_flag,'N') <> 'Y') OR
1708: l_line_tbl(I).line_category_code = 'RETURN' OR
1709: l_line_tbl(I).source_type_code = 'EXTERNAL' OR
3266: */
3267:
3268:
3269: IF (l_line_tbl(I).item_type_code <> 'MODEL' AND
3270: l_line_tbl(I).item_type_code <> 'STANDARD' AND
3271: l_line_tbl(I).item_type_code <> 'KIT' AND
3272: l_line_tbl(I).item_type_code <> 'SERVICE' AND
3273: nvl(l_line_tbl(I).model_remnant_flag,'N') <> 'Y')
3274: OR (l_line_tbl(I).item_type_code = 'SERVICE'
4185: oe_debug_pub.add( 'SOURCE TYPE' || P_X_LINE_REC.SOURCE_TYPE_CODE , 1 ) ;
4186: END IF;
4187:
4188: -- Lines that are of type external(drop ships) or shipped or any line that
4189: -- is not model standard and kit are not allowed to have set operations.
4190: IF p_x_line_rec.shipped_quantity IS NULL OR
4191: p_x_line_rec.shipped_quantity = FND_API.G_MISS_NUM THEN
4192: lshpqty := 0;
4193: ELSIF p_x_line_rec.shipped_quantity > 0 THEN
4202:
4203: IF (p_x_line_rec.item_type_code = 'MODEL' AND
4204: p_x_line_rec.top_model_line_id =
4205: p_x_line_rec.line_id) OR
4206: (p_x_line_rec.item_type_code = 'STANDARD') OR
4207: (p_x_line_rec.item_type_code = 'SERVICE' AND
4208: p_x_line_rec.fulfillment_set IS NOT NULL AND
4209: p_x_line_rec.fulfillment_set <> FND_API.G_MISS_CHAR )
4210: OR
5033: END IF;
5034:
5035: END IF; -- name not null.
5036:
5037: END IF; -- Model And Standard
5038: ELSIF(p_x_line_rec.source_type_code = 'EXTERNAL') THEN
5039: -- Source type code is external
5040: p_x_line_rec.arrival_set_id := NULL;
5041: p_x_line_rec.ship_set_id := NULL;
5335: IF l_debug_level > 0 THEN
5336: oe_debug_pub.add( 'OPERATION' || P_X_LINE_TBL ( J ) .ITEM_TYPE_CODE ) ;
5337: END IF;
5338: IF p_x_line_tbl(J).item_type_code <> 'MODEL' AND
5339: p_x_line_tbl(J).item_type_code <> 'STANDARD' AND
5340: p_x_line_tbl(J).item_type_code <> 'KIT' THEN
5341: goto End_Psets;
5342: END IF;
5343: g_set_tbl(I).line_id := p_x_line_tbl(J).line_id;
5437:
5438: END IF;
5439:
5440: IF (l_line_rec.item_type_code <> 'MODEL' AND
5441: l_line_rec.item_type_code <> 'STANDARD' AND
5442: l_line_rec.item_type_code <> 'KIT' AND
5443: l_line_rec.item_type_code <> 'SERVICE' AND
5444: nvl(l_line_rec.model_remnant_flag,'N') <> 'Y')
5445: OR (l_line_rec.item_type_code = 'SERVICE'
5565: x_line_rec => l_line_rec);
5566:
5567:
5568: IF (l_line_rec.item_type_code <> 'MODEL' AND
5569: l_line_rec.item_type_code <> 'STANDARD' AND
5570: l_line_rec.item_type_code <> 'KIT' AND
5571: l_line_rec.item_type_code <> 'SERVICE' AND
5572: nvl(l_line_rec.model_remnant_flag,'N') <> 'Y')
5573: OR (l_line_rec.item_type_code = 'SERVICE'
6193: IF l_debug_level > 0 THEN
6194: oe_debug_pub.add( 'ENTER PROCEDURE DEFAULT LINE SET' , 1 ) ;
6195: END IF;
6196:
6197: -- This will process only if the line is internal , standard and model and
6198: -- not shipped
6199:
6200: IF NOT g_old_arrival_set_path THEN
6201: IF NOT ((p_x_line_rec.split_action_code = 'SPLIT' and
6230: (nvl(p_x_line_rec.fulfilled_flag,'N') = 'Y'
6231: AND p_x_line_rec.ship_set_id is null
6232: AND p_x_line_rec.arrival_set is null)) AND
6233: nvl(p_x_line_rec.open_flag,'N') = 'Y' AND
6234: (p_x_line_rec.item_type_code = 'STANDARD' OR
6235: p_x_line_rec.top_model_line_id = p_x_line_rec.line_id ) AND
6236: p_x_line_rec.line_category_code <> 'RETURN' THEN
6237:
6238: IF l_debug_level > 0 THEN
7093: OE_DEBUG_PUB.Add('Entering Validate Fulfillment Set');
7094:
7095: IF --p_x_line_rec.source_type_code <> 'EXTERNAL' AND --Bug #4537341
7096: p_x_line_rec.shipped_quantity IS NULL AND
7097: (p_x_line_rec.item_type_code = 'STANDARD' OR
7098: p_x_line_rec.top_model_line_id =
7099: p_x_line_rec.line_id OR
7100: p_x_line_rec.item_type_code = 'SERVICE') AND -- the following added for 3504787
7101: p_x_line_rec.open_flag = 'Y' and