[Home] [Help]
1737: l_line_tbl(I).change_comments := 'Set Action';
1738: -- bug 3692277 ends }
1739:
1740: IF (l_line_tbl(I).top_model_line_id <> l_line_tbl(I).line_id AND
1741: l_line_tbl(I).item_type_code <> 'STANDARD'
1742: AND
1743: nvl(l_line_tbl(I).model_remnant_flag,'N') <> 'Y') OR
1744: l_line_tbl(I).line_category_code = 'RETURN' OR
1745: l_line_tbl(I).source_type_code = 'EXTERNAL' OR
3323: */
3324:
3325:
3326: IF (l_line_tbl(I).item_type_code <> 'MODEL' AND
3327: l_line_tbl(I).item_type_code <> 'STANDARD' AND
3328: l_line_tbl(I).item_type_code <> 'KIT' AND
3329: l_line_tbl(I).item_type_code <> 'SERVICE' AND
3330: nvl(l_line_tbl(I).model_remnant_flag,'N') <> 'Y')
3331: OR (l_line_tbl(I).item_type_code = 'SERVICE'
4242: oe_debug_pub.add( 'SOURCE TYPE' || P_X_LINE_REC.SOURCE_TYPE_CODE , 1 ) ;
4243: END IF;
4244:
4245: -- Lines that are of type external(drop ships) or shipped or any line that
4246: -- is not model standard and kit are not allowed to have set operations.
4247: IF p_x_line_rec.shipped_quantity IS NULL OR
4248: p_x_line_rec.shipped_quantity = FND_API.G_MISS_NUM THEN
4249: lshpqty := 0;
4250: ELSIF p_x_line_rec.shipped_quantity > 0 THEN
4259:
4260: IF (p_x_line_rec.item_type_code = 'MODEL' AND
4261: p_x_line_rec.top_model_line_id =
4262: p_x_line_rec.line_id) OR
4263: (p_x_line_rec.item_type_code = 'STANDARD') OR
4264: (p_x_line_rec.item_type_code = 'SERVICE' AND
4265: p_x_line_rec.fulfillment_set IS NOT NULL AND
4266: p_x_line_rec.fulfillment_set <> FND_API.G_MISS_CHAR )
4267: OR
5090: END IF;
5091:
5092: END IF; -- name not null.
5093:
5094: END IF; -- Model And Standard
5095: ELSIF(p_x_line_rec.source_type_code = 'EXTERNAL') THEN
5096: -- Source type code is external
5097: p_x_line_rec.arrival_set_id := NULL;
5098: p_x_line_rec.ship_set_id := NULL;
5392: IF l_debug_level > 0 THEN
5393: oe_debug_pub.add( 'OPERATION' || P_X_LINE_TBL ( J ) .ITEM_TYPE_CODE ) ;
5394: END IF;
5395: IF p_x_line_tbl(J).item_type_code <> 'MODEL' AND
5396: p_x_line_tbl(J).item_type_code <> 'STANDARD' AND
5397: p_x_line_tbl(J).item_type_code <> 'KIT' THEN
5398: goto End_Psets;
5399: END IF;
5400: g_set_tbl(I).line_id := p_x_line_tbl(J).line_id;
5494:
5495: END IF;
5496:
5497: IF (l_line_rec.item_type_code <> 'MODEL' AND
5498: l_line_rec.item_type_code <> 'STANDARD' AND
5499: l_line_rec.item_type_code <> 'KIT' AND
5500: l_line_rec.item_type_code <> 'SERVICE' AND
5501: nvl(l_line_rec.model_remnant_flag,'N') <> 'Y')
5502: OR (l_line_rec.item_type_code = 'SERVICE'
5622: x_line_rec => l_line_rec);
5623:
5624:
5625: IF (l_line_rec.item_type_code <> 'MODEL' AND
5626: l_line_rec.item_type_code <> 'STANDARD' AND
5627: l_line_rec.item_type_code <> 'KIT' AND
5628: l_line_rec.item_type_code <> 'SERVICE' AND
5629: nvl(l_line_rec.model_remnant_flag,'N') <> 'Y')
5630: OR (l_line_rec.item_type_code = 'SERVICE'
6299: END IF;
6300:
6301: l_param := NVL(oe_sys_parameters.Value('ONT_LINE_SET_WH',p_x_line_rec.org_id),'N'); --2843738
6302:
6303: -- This will process only if the line is internal , standard and model and
6304: -- not shipped
6305:
6306: IF NOT g_old_arrival_set_path THEN
6307: IF NOT ((p_x_line_rec.split_action_code = 'SPLIT' and
6336: (nvl(p_x_line_rec.fulfilled_flag,'N') = 'Y'
6337: AND p_x_line_rec.ship_set_id is null
6338: AND p_x_line_rec.arrival_set is null)) AND
6339: nvl(p_x_line_rec.open_flag,'N') = 'Y' AND
6340: /*(p_x_line_rec.item_type_code = 'STANDARD' OR
6341: p_x_line_rec.top_model_line_id = p_x_line_rec.line_id OR
6342: OE_Quote_Util.G_COMPLETE_NEG = 'Y' ) AND --12955144 : Allow other child lines as well-- Bug 2843738*/
6343: p_x_line_rec.line_category_code <> 'RETURN' THEN
6344:
6361:
6362: OE_Order_Cache.Load_Order_Header(p_x_line_rec.header_id);
6363:
6364: -- 2843738
6365: IF (p_x_line_rec.item_type_code = 'STANDARD' OR
6366: p_x_line_rec.top_model_line_id = p_x_line_rec.line_id) THEN
6367: /*OPEN C10;
6368: FETCH C10 into l_set_id;
6369: close C10*/
6406: END IF;
6407:
6408: --2843738
6409: IF l_set_id IS NULL AND
6410: (p_x_line_rec.item_type_code = 'STANDARD' OR
6411: p_x_line_rec.top_model_line_id = p_x_line_rec.line_id) THEN
6412: IF NVL(FND_PROFILE.VALUE('ONT_SET_FOR_EACH_LINE'),'N') = 'Y' THEN
6413: OPEN C_profile;
6414: FETCH C_profile into l_set_id;
6503:
6504: END IF; -- lSet_id is not null
6505:
6506: IF l_set_id is null AND
6507: (p_x_line_rec.item_type_code = 'STANDARD' OR
6508: p_x_line_rec.top_model_line_id = p_x_line_rec.line_id) THEN
6509: IF NVL(FND_PROFILE.VALUE('ONT_SET_FOR_EACH_LINE'),'N') = 'N' AND NOT(l_param = 'Y' AND l_cust_pref='SHIP') THEN --2843738
6510: OPEN C1;
6511: FETCH C1 INTO lsettempname;
7575: OE_DEBUG_PUB.Add('Entering Validate Fulfillment Set');
7576:
7577: IF --p_x_line_rec.source_type_code <> 'EXTERNAL' AND --Bug #4537341
7578: p_x_line_rec.shipped_quantity IS NULL AND
7579: (p_x_line_rec.item_type_code = 'STANDARD' OR
7580: p_x_line_rec.top_model_line_id =
7581: p_x_line_rec.line_id OR
7582: p_x_line_rec.item_type_code = 'SERVICE') AND -- the following added for 3504787
7583: p_x_line_rec.open_flag = 'Y' and