[Home] [Help]
577:
578: -- OPM Bug3016136
579: PROCEDURE ORDERED_QUANTITY2 IS
580: BEGIN
581: OE_DEBUG_PUB.add('OPM Procedure ordered_quantity2',1);
582: IF (p_initial_line_rec.ORDERED_QUANTITY2 = FND_API.G_MISS_NUM OR
583: (OE_GLOBALS.Equal(p_initial_line_rec.ORDERED_QUANTITY2, p_old_line_rec.ORDERED_QUANTITY2)
584: AND
585: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.ORDERED_QUANTITY2 IS NOT NULL))
646: --retro{For a retrobill line if price increases the line category and line_type are changed.
647: --This causes the price list also to be defaulted, but it shouldn't happen,
648: --So the following if with null for retrobill lines
649: IF( p_x_line_rec.retrobill_request_id is NOT NULL) THEN
650: oe_debug_pub.add('Retro:Pricelist not defaulted');
651: oe_debug_pub.add('Pricelist Id:'||p_x_line_rec.PRICE_LIST_ID);
652: Else
653: oe_debug_pub.add('Retro:Reseting price list to missnum');
654: p_x_line_rec.PRICE_LIST_ID := FND_API.G_MISS_NUM;
647: --This causes the price list also to be defaulted, but it shouldn't happen,
648: --So the following if with null for retrobill lines
649: IF( p_x_line_rec.retrobill_request_id is NOT NULL) THEN
650: oe_debug_pub.add('Retro:Pricelist not defaulted');
651: oe_debug_pub.add('Pricelist Id:'||p_x_line_rec.PRICE_LIST_ID);
652: Else
653: oe_debug_pub.add('Retro:Reseting price list to missnum');
654: p_x_line_rec.PRICE_LIST_ID := FND_API.G_MISS_NUM;
655: x_dep_attr_exists := 'Y';
649: IF( p_x_line_rec.retrobill_request_id is NOT NULL) THEN
650: oe_debug_pub.add('Retro:Pricelist not defaulted');
651: oe_debug_pub.add('Pricelist Id:'||p_x_line_rec.PRICE_LIST_ID);
652: Else
653: oe_debug_pub.add('Retro:Reseting price list to missnum');
654: p_x_line_rec.PRICE_LIST_ID := FND_API.G_MISS_NUM;
655: x_dep_attr_exists := 'Y';
656: END IF; --End of Retrobill check
657: END IF;
1249: AND
1250: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.RETURN_CONTEXT IS NOT NULL))
1251: ) -- the AND condition above added to fix 3098878
1252: THEN
1253: oe_debug_pub.add('RMA:Clearing Return Attrs',1);
1254:
1255: p_x_line_rec.RETURN_CONTEXT := FND_API.G_MISS_CHAR;
1256: p_x_line_rec.RETURN_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1257: p_x_line_rec.RETURN_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1361: -- Bug 2843738
1362: PROCEDURE ship_set IS
1363: l_set_status VARCHAR2(1);
1364: BEGIN
1365: OE_DEBUG_PUB.add('Procedure ship set',1);
1366: OE_Order_Cache.Load_Order_Header(p_initial_line_rec.header_id); -- 13706641
1367: -- Bug 13730871
1368: BEGIN
1369: SELECT set_status INTO l_set_status
1406: p_source_attr_tbl => p_src_attr_tbl,
1407: p_dep_attr_tbl => l_dep_attr_tbl);
1408:
1409: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP
1410: oe_debug_pub.add('Dep. attr :'||l_dep_attr_tbl(I));
1411:
1412: -- Bug fix 1131529: clear the dependent attribute ONLY if attribute
1413: -- did not have a user-specified value (attribute is not user specified
1414: -- if value is missing or old value is same as the initial value)
2710: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
2711: l_dep_attr_exists VARCHAR2(1);
2712: BEGIN
2713:
2714: oe_debug_pub.add('Entering OE_LINE_UTIL.CLEAR_DEPENDENT_ATTR', 1);
2715: oe_debug_pub.add('Attr Id: '||p_attr_id);
2716:
2717:
2718: IF p_attr_id <> FND_API.G_MISS_NUM THEN
2711: l_dep_attr_exists VARCHAR2(1);
2712: BEGIN
2713:
2714: oe_debug_pub.add('Entering OE_LINE_UTIL.CLEAR_DEPENDENT_ATTR', 1);
2715: oe_debug_pub.add('Attr Id: '||p_attr_id);
2716:
2717:
2718: IF p_attr_id <> FND_API.G_MISS_NUM THEN
2719:
2902: ,p_old_line_rec => p_old_line_rec
2903: ,p_x_line_rec => p_x_line_rec
2904: ,x_dep_attr_exists => l_dep_attr_exists);
2905:
2906: oe_debug_pub.add('Exiting OE_LINE_UTIL.CLEAR_DEPENDENT_ATTR', 1);
2907:
2908: EXCEPTION
2909: WHEN FND_API.G_EXC_ERROR THEN
2910: RAISE FND_API.G_EXC_ERROR;
2996: , x_dep_attr_exists => l_dep_attr_exists
2997: );
2998:
2999: IF l_dep_attr_exists = 'N' THEN
3000: oe_debug_pub.add('No Dep Attributes');
3001: RETURN;
3002: END IF;
3003:
3004: RowType_Rec_To_API_Rec(l_line_rec, p_x_line_rec);