[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;
1160: AND
1161: (p_old_line_rec.line_id IS NOT NULL OR p_initial_line_rec.RETURN_CONTEXT IS NOT NULL))
1162: ) -- the AND condition above added to fix 3098878
1163: THEN
1164: oe_debug_pub.add('RMA:Clearing Return Attrs',1);
1165:
1166: p_x_line_rec.RETURN_CONTEXT := FND_API.G_MISS_CHAR;
1167: p_x_line_rec.RETURN_ATTRIBUTE1 := FND_API.G_MISS_CHAR;
1168: p_x_line_rec.RETURN_ATTRIBUTE2 := FND_API.G_MISS_CHAR;
1275: p_source_attr_tbl => p_src_attr_tbl,
1276: p_dep_attr_tbl => l_dep_attr_tbl);
1277:
1278: FOR I IN 1..l_dep_attr_tbl.COUNT LOOP
1279: oe_debug_pub.add('Dep. attr :'||l_dep_attr_tbl(I));
1280:
1281: -- Bug fix 1131529: clear the dependent attribute ONLY if attribute
1282: -- did not have a user-specified value (attribute is not user specified
1283: -- if value is missing or old value is same as the initial value)
2539: l_src_attr_tbl OE_GLOBALS.NUMBER_Tbl_Type;
2540: l_dep_attr_exists VARCHAR2(1);
2541: BEGIN
2542:
2543: oe_debug_pub.add('Entering OE_LINE_UTIL.CLEAR_DEPENDENT_ATTR', 1);
2544: oe_debug_pub.add('Attr Id: '||p_attr_id);
2545:
2546:
2547: IF p_attr_id <> FND_API.G_MISS_NUM THEN
2540: l_dep_attr_exists VARCHAR2(1);
2541: BEGIN
2542:
2543: oe_debug_pub.add('Entering OE_LINE_UTIL.CLEAR_DEPENDENT_ATTR', 1);
2544: oe_debug_pub.add('Attr Id: '||p_attr_id);
2545:
2546:
2547: IF p_attr_id <> FND_API.G_MISS_NUM THEN
2548:
2717: ,p_old_line_rec => p_old_line_rec
2718: ,p_x_line_rec => p_x_line_rec
2719: ,x_dep_attr_exists => l_dep_attr_exists);
2720:
2721: oe_debug_pub.add('Exiting OE_LINE_UTIL.CLEAR_DEPENDENT_ATTR', 1);
2722:
2723: EXCEPTION
2724: WHEN FND_API.G_EXC_ERROR THEN
2725: RAISE FND_API.G_EXC_ERROR;
2811: , x_dep_attr_exists => l_dep_attr_exists
2812: );
2813:
2814: IF l_dep_attr_exists = 'N' THEN
2815: oe_debug_pub.add('No Dep Attributes');
2816: RETURN;
2817: END IF;
2818:
2819: RowType_Rec_To_API_Rec(l_line_rec, p_x_line_rec);