165: ,precedence =>l_precedence
166: ,error_code =>l_error_code
167: );
168:
169: oe_debug_pub.add('error code = '|| to_char(l_error_code));
170: IF l_error_code = 0
171: THEN
172:
173: RETURN l_datatype;
207: ,precedence =>l_precedence
208: ,error_code =>l_error_code
209: );
210:
211: oe_debug_pub.add('error code = '|| to_char(l_error_code));
212:
213: IF l_error_code = 0
214: THEN
215:
274: where list_line_id = g_Pricing_Attr_rec.from_rltd_modifier_id
275: and excluder_flag = 'N'
276: and rownum < 2;
277:
278: oe_debug_pub.add('prod attr 3 : ' || l_prod_attr );
279:
280: ELSIF ( g_Pricing_Attr_rec.list_line_id is not null
281: and g_Pricing_Attr_rec.list_line_id <> FND_API.G_MISS_NUM) THEN
282:
302: IS
303: l_prod_attr_cont VARCHAR2(30) := NULL;
304: BEGIN
305:
306: oe_debug_pub.add('parent line id 1 :' || g_PRICING_ATTR_REC.FROM_RLTD_MODIFIER_ID );
307:
308: IF ( g_Pricing_Attr_rec.from_rltd_modifier_id is not null
309: and g_Pricing_Attr_rec.from_rltd_modifier_id <> FND_API.G_MISS_NUM) THEN
310:
314: where list_line_id = g_Pricing_Attr_rec.from_rltd_modifier_id
315: and excluder_flag = 'N'
316: and rownum < 2;
317:
318: oe_debug_pub.add('prod attr cont 1 : ' || l_prod_attr_cont );
319:
320: ELSIF ( g_Pricing_Attr_rec.list_line_id is not null
321: and g_Pricing_Attr_rec.list_line_id <> FND_API.G_MISS_NUM) THEN
322:
352: where list_line_id = g_Pricing_Attr_rec.from_rltd_modifier_id
353: and excluder_flag = 'N'
354: and rownum < 2;
355:
356: oe_debug_pub.add('prod attr value 2 : ' || l_prod_attr_value );
357:
358: ELSIF ( g_Pricing_Attr_rec.list_line_id is not null
359: and g_Pricing_Attr_rec.list_line_id <> FND_API.G_MISS_NUM) THEN
360:
390: where list_line_id = g_Pricing_Attr_rec.from_rltd_modifier_id
391: and excluder_flag = 'N'
392: and rownum < 2;
393:
394: oe_debug_pub.add('uom 4: ' || l_prod_uom );
395:
396: ELSIF ( g_Pricing_Attr_rec.list_line_id is not null
397: and g_Pricing_Attr_rec.list_line_id <> FND_API.G_MISS_NUM) THEN
398:
820: IF g_PRICING_ATTR_rec.from_rltd_modifier_id = FND_API.G_MISS_NUM THEN
821:
822: g_PRICING_ATTR_rec.from_rltd_modifier_id := Get_From_Rltd_Modifier_Id;
823:
824: oe_debug_pub.add('get rltd modifier');
825:
826: /*
827:
828: IF g_PRICING_ATTR_rec.from_rltd_modifier_id IS NOT NULL THEN
936: END IF;
937:
938: END IF;
939:
940: oe_debug_pub.add('product attr datatype is : ' || g_PRICING_ATTR_rec.product_attribute_datatype);
941:
942: IF g_PRICING_ATTR_rec.product_uom_code = FND_API.G_MISS_CHAR THEN
943:
944: g_PRICING_ATTR_rec.product_uom_code := Get_Product_Uom;