DBA Data[Home] [Help]

APPS.OE_OE_FORM_PRICE_LLINE dependencies on FND_API

Line 173: , p_init_msg_list => FND_API.G_TRUE

169: oe_debug_pub.add('before process_pricing_cont in list lines ');
170:
171: OE_Pricing_Cont_PVT.Process_Pricing_Cont
172: ( p_api_version_number => 1.0
173: , p_init_msg_list => FND_API.G_TRUE
174: , x_return_status => l_return_status
175: , x_msg_count => x_msg_count
176: , x_msg_data => x_msg_data
177: , p_control_rec => l_control_rec

Line 189: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

185: , x_Discount_Line_tbl => l_x_Discount_Line_tbl
186: , x_Price_Break_tbl => l_x_Price_Break_tbl
187: );
188:
189: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
192: RAISE FND_API.G_EXC_ERROR;
193: END IF;

Line 190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

186: , x_Price_Break_tbl => l_x_Price_Break_tbl
187: );
188:
189: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
192: RAISE FND_API.G_EXC_ERROR;
193: END IF;
194:

Line 191: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

187: );
188:
189: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
192: RAISE FND_API.G_EXC_ERROR;
193: END IF;
194:
195: oe_debug_pub.add('after calling process_pricing_cont for lines ');

Line 192: RAISE FND_API.G_EXC_ERROR;

188:
189: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
192: RAISE FND_API.G_EXC_ERROR;
193: END IF;
194:
195: oe_debug_pub.add('after calling process_pricing_cont for lines ');
196:

Line 277: l_x_Price_LLine_rec.db_flag := FND_API.G_FALSE;

273:
274: -- Write to cache.
275: -- Set db_flag to False before writing to cache
276:
277: l_x_Price_LLine_rec.db_flag := FND_API.G_FALSE;
278:
279: oe_debug_pub.add('after display values');
280:
281: Write_Price_LLine

Line 289: x_return_status := FND_API.G_RET_STS_SUCCESS;

285: oe_debug_pub.add('after writing to cache ');
286:
287: -- Set return status.
288:
289: x_return_status := FND_API.G_RET_STS_SUCCESS;
290:
291: -- Get message count and data
292:
293: OE_MSG_PUB.Count_And_Get

Line 302: WHEN FND_API.G_EXC_ERROR THEN

298: oe_debug_pub.add('Exiting OE_OE_Form_Price_Lline.Default_Attributes');
299:
300: EXCEPTION
301:
302: WHEN FND_API.G_EXC_ERROR THEN
303:
304: x_return_status := FND_API.G_RET_STS_ERROR;
305:
306: -- Get message count and data

Line 304: x_return_status := FND_API.G_RET_STS_ERROR;

300: EXCEPTION
301:
302: WHEN FND_API.G_EXC_ERROR THEN
303:
304: x_return_status := FND_API.G_RET_STS_ERROR;
305:
306: -- Get message count and data
307:
308: OE_MSG_PUB.Count_And_Get

Line 313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

309: ( p_count => x_msg_count
310: , p_data => x_msg_data
311: );
312:
313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
314:
315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
316:
317: -- Get message count and data

Line 315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

311: );
312:
313: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
314:
315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
316:
317: -- Get message count and data
318:
319: OE_MSG_PUB.Count_And_Get

Line 326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

322: );
323:
324: WHEN OTHERS THEN
325:
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
327:
328: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
329: THEN
330: OE_MSG_PUB.Add_Exc_Msg

Line 642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

638: , 'Unrecognized attribute'
639: );
640: END IF;
641:
642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
643:
644: END IF;
645:
646: -- Set Operation.

Line 649: IF (l_Price_LLine_rec.db_flag = FND_API.G_MISS_CHAR ) THEN

645:
646: -- Set Operation.
647:
648:
649: IF (l_Price_LLine_rec.db_flag = FND_API.G_MISS_CHAR ) THEN
650:
651: l_Price_LLine_rec.db_flag := NULL;
652:
653: END IF;

Line 656: IF FND_API.To_Boolean(l_Price_LLine_rec.db_flag) THEN

652:
653: END IF;
654: oe_debug_pub.add('price list line id 5555 is : ');
655:
656: IF FND_API.To_Boolean(l_Price_LLine_rec.db_flag) THEN
657: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
658: ELSE
659: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_CREATE;
660: END IF;

Line 673: , p_init_msg_list => FND_API.G_TRUE

669:
670: oe_debug_pub.add('price list line id 7777 is : ');
671: OE_Pricing_Cont_PVT.Process_Pricing_Cont
672: ( p_api_version_number => 1.0
673: , p_init_msg_list => FND_API.G_TRUE
674: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
675: , x_return_status => l_return_status
676: , x_msg_count => x_msg_count
677: , x_msg_data => x_msg_data

Line 674: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

670: oe_debug_pub.add('price list line id 7777 is : ');
671: OE_Pricing_Cont_PVT.Process_Pricing_Cont
672: ( p_api_version_number => 1.0
673: , p_init_msg_list => FND_API.G_TRUE
674: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
675: , x_return_status => l_return_status
676: , x_msg_count => x_msg_count
677: , x_msg_data => x_msg_data
678: , p_control_rec => l_control_rec

Line 691: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

687: , x_Discount_Line_tbl => l_x_Discount_Line_tbl
688: , x_Price_Break_tbl => l_x_Price_Break_tbl
689: );
690:
691: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
693: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
694: RAISE FND_API.G_EXC_ERROR;
695: END IF;

Line 692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

688: , x_Price_Break_tbl => l_x_Price_Break_tbl
689: );
690:
691: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
693: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
694: RAISE FND_API.G_EXC_ERROR;
695: END IF;
696:

Line 693: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

689: );
690:
691: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
693: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
694: RAISE FND_API.G_EXC_ERROR;
695: END IF;
696:
697:

Line 694: RAISE FND_API.G_EXC_ERROR;

690:
691: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
693: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
694: RAISE FND_API.G_EXC_ERROR;
695: END IF;
696:
697:
698: -- Unload out tbl

Line 705: x_attribute1 := FND_API.G_MISS_CHAR;

701:
702:
703: -- Init OUT parameters to missing.
704:
705: x_attribute1 := FND_API.G_MISS_CHAR;
706: x_attribute10 := FND_API.G_MISS_CHAR;
707: x_attribute11 := FND_API.G_MISS_CHAR;
708: x_attribute12 := FND_API.G_MISS_CHAR;
709: x_attribute13 := FND_API.G_MISS_CHAR;

Line 706: x_attribute10 := FND_API.G_MISS_CHAR;

702:
703: -- Init OUT parameters to missing.
704:
705: x_attribute1 := FND_API.G_MISS_CHAR;
706: x_attribute10 := FND_API.G_MISS_CHAR;
707: x_attribute11 := FND_API.G_MISS_CHAR;
708: x_attribute12 := FND_API.G_MISS_CHAR;
709: x_attribute13 := FND_API.G_MISS_CHAR;
710: x_attribute14 := FND_API.G_MISS_CHAR;

Line 707: x_attribute11 := FND_API.G_MISS_CHAR;

703: -- Init OUT parameters to missing.
704:
705: x_attribute1 := FND_API.G_MISS_CHAR;
706: x_attribute10 := FND_API.G_MISS_CHAR;
707: x_attribute11 := FND_API.G_MISS_CHAR;
708: x_attribute12 := FND_API.G_MISS_CHAR;
709: x_attribute13 := FND_API.G_MISS_CHAR;
710: x_attribute14 := FND_API.G_MISS_CHAR;
711: x_attribute15 := FND_API.G_MISS_CHAR;

Line 708: x_attribute12 := FND_API.G_MISS_CHAR;

704:
705: x_attribute1 := FND_API.G_MISS_CHAR;
706: x_attribute10 := FND_API.G_MISS_CHAR;
707: x_attribute11 := FND_API.G_MISS_CHAR;
708: x_attribute12 := FND_API.G_MISS_CHAR;
709: x_attribute13 := FND_API.G_MISS_CHAR;
710: x_attribute14 := FND_API.G_MISS_CHAR;
711: x_attribute15 := FND_API.G_MISS_CHAR;
712: x_attribute2 := FND_API.G_MISS_CHAR;

Line 709: x_attribute13 := FND_API.G_MISS_CHAR;

705: x_attribute1 := FND_API.G_MISS_CHAR;
706: x_attribute10 := FND_API.G_MISS_CHAR;
707: x_attribute11 := FND_API.G_MISS_CHAR;
708: x_attribute12 := FND_API.G_MISS_CHAR;
709: x_attribute13 := FND_API.G_MISS_CHAR;
710: x_attribute14 := FND_API.G_MISS_CHAR;
711: x_attribute15 := FND_API.G_MISS_CHAR;
712: x_attribute2 := FND_API.G_MISS_CHAR;
713: x_attribute3 := FND_API.G_MISS_CHAR;

Line 710: x_attribute14 := FND_API.G_MISS_CHAR;

706: x_attribute10 := FND_API.G_MISS_CHAR;
707: x_attribute11 := FND_API.G_MISS_CHAR;
708: x_attribute12 := FND_API.G_MISS_CHAR;
709: x_attribute13 := FND_API.G_MISS_CHAR;
710: x_attribute14 := FND_API.G_MISS_CHAR;
711: x_attribute15 := FND_API.G_MISS_CHAR;
712: x_attribute2 := FND_API.G_MISS_CHAR;
713: x_attribute3 := FND_API.G_MISS_CHAR;
714: x_attribute4 := FND_API.G_MISS_CHAR;

Line 711: x_attribute15 := FND_API.G_MISS_CHAR;

707: x_attribute11 := FND_API.G_MISS_CHAR;
708: x_attribute12 := FND_API.G_MISS_CHAR;
709: x_attribute13 := FND_API.G_MISS_CHAR;
710: x_attribute14 := FND_API.G_MISS_CHAR;
711: x_attribute15 := FND_API.G_MISS_CHAR;
712: x_attribute2 := FND_API.G_MISS_CHAR;
713: x_attribute3 := FND_API.G_MISS_CHAR;
714: x_attribute4 := FND_API.G_MISS_CHAR;
715: x_attribute5 := FND_API.G_MISS_CHAR;

Line 712: x_attribute2 := FND_API.G_MISS_CHAR;

708: x_attribute12 := FND_API.G_MISS_CHAR;
709: x_attribute13 := FND_API.G_MISS_CHAR;
710: x_attribute14 := FND_API.G_MISS_CHAR;
711: x_attribute15 := FND_API.G_MISS_CHAR;
712: x_attribute2 := FND_API.G_MISS_CHAR;
713: x_attribute3 := FND_API.G_MISS_CHAR;
714: x_attribute4 := FND_API.G_MISS_CHAR;
715: x_attribute5 := FND_API.G_MISS_CHAR;
716: x_attribute6 := FND_API.G_MISS_CHAR;

Line 713: x_attribute3 := FND_API.G_MISS_CHAR;

709: x_attribute13 := FND_API.G_MISS_CHAR;
710: x_attribute14 := FND_API.G_MISS_CHAR;
711: x_attribute15 := FND_API.G_MISS_CHAR;
712: x_attribute2 := FND_API.G_MISS_CHAR;
713: x_attribute3 := FND_API.G_MISS_CHAR;
714: x_attribute4 := FND_API.G_MISS_CHAR;
715: x_attribute5 := FND_API.G_MISS_CHAR;
716: x_attribute6 := FND_API.G_MISS_CHAR;
717: x_attribute7 := FND_API.G_MISS_CHAR;

Line 714: x_attribute4 := FND_API.G_MISS_CHAR;

710: x_attribute14 := FND_API.G_MISS_CHAR;
711: x_attribute15 := FND_API.G_MISS_CHAR;
712: x_attribute2 := FND_API.G_MISS_CHAR;
713: x_attribute3 := FND_API.G_MISS_CHAR;
714: x_attribute4 := FND_API.G_MISS_CHAR;
715: x_attribute5 := FND_API.G_MISS_CHAR;
716: x_attribute6 := FND_API.G_MISS_CHAR;
717: x_attribute7 := FND_API.G_MISS_CHAR;
718: x_attribute8 := FND_API.G_MISS_CHAR;

Line 715: x_attribute5 := FND_API.G_MISS_CHAR;

711: x_attribute15 := FND_API.G_MISS_CHAR;
712: x_attribute2 := FND_API.G_MISS_CHAR;
713: x_attribute3 := FND_API.G_MISS_CHAR;
714: x_attribute4 := FND_API.G_MISS_CHAR;
715: x_attribute5 := FND_API.G_MISS_CHAR;
716: x_attribute6 := FND_API.G_MISS_CHAR;
717: x_attribute7 := FND_API.G_MISS_CHAR;
718: x_attribute8 := FND_API.G_MISS_CHAR;
719: x_attribute9 := FND_API.G_MISS_CHAR;

Line 716: x_attribute6 := FND_API.G_MISS_CHAR;

712: x_attribute2 := FND_API.G_MISS_CHAR;
713: x_attribute3 := FND_API.G_MISS_CHAR;
714: x_attribute4 := FND_API.G_MISS_CHAR;
715: x_attribute5 := FND_API.G_MISS_CHAR;
716: x_attribute6 := FND_API.G_MISS_CHAR;
717: x_attribute7 := FND_API.G_MISS_CHAR;
718: x_attribute8 := FND_API.G_MISS_CHAR;
719: x_attribute9 := FND_API.G_MISS_CHAR;
720: x_comments := FND_API.G_MISS_CHAR;

Line 717: x_attribute7 := FND_API.G_MISS_CHAR;

713: x_attribute3 := FND_API.G_MISS_CHAR;
714: x_attribute4 := FND_API.G_MISS_CHAR;
715: x_attribute5 := FND_API.G_MISS_CHAR;
716: x_attribute6 := FND_API.G_MISS_CHAR;
717: x_attribute7 := FND_API.G_MISS_CHAR;
718: x_attribute8 := FND_API.G_MISS_CHAR;
719: x_attribute9 := FND_API.G_MISS_CHAR;
720: x_comments := FND_API.G_MISS_CHAR;
721: x_context := FND_API.G_MISS_CHAR;

Line 718: x_attribute8 := FND_API.G_MISS_CHAR;

714: x_attribute4 := FND_API.G_MISS_CHAR;
715: x_attribute5 := FND_API.G_MISS_CHAR;
716: x_attribute6 := FND_API.G_MISS_CHAR;
717: x_attribute7 := FND_API.G_MISS_CHAR;
718: x_attribute8 := FND_API.G_MISS_CHAR;
719: x_attribute9 := FND_API.G_MISS_CHAR;
720: x_comments := FND_API.G_MISS_CHAR;
721: x_context := FND_API.G_MISS_CHAR;
722: x_customer_item_id := FND_API.G_MISS_NUM;

Line 719: x_attribute9 := FND_API.G_MISS_CHAR;

715: x_attribute5 := FND_API.G_MISS_CHAR;
716: x_attribute6 := FND_API.G_MISS_CHAR;
717: x_attribute7 := FND_API.G_MISS_CHAR;
718: x_attribute8 := FND_API.G_MISS_CHAR;
719: x_attribute9 := FND_API.G_MISS_CHAR;
720: x_comments := FND_API.G_MISS_CHAR;
721: x_context := FND_API.G_MISS_CHAR;
722: x_customer_item_id := FND_API.G_MISS_NUM;
723: x_end_date_active := FND_API.G_MISS_DATE;

Line 720: x_comments := FND_API.G_MISS_CHAR;

716: x_attribute6 := FND_API.G_MISS_CHAR;
717: x_attribute7 := FND_API.G_MISS_CHAR;
718: x_attribute8 := FND_API.G_MISS_CHAR;
719: x_attribute9 := FND_API.G_MISS_CHAR;
720: x_comments := FND_API.G_MISS_CHAR;
721: x_context := FND_API.G_MISS_CHAR;
722: x_customer_item_id := FND_API.G_MISS_NUM;
723: x_end_date_active := FND_API.G_MISS_DATE;
724: x_inventory_item_id := FND_API.G_MISS_NUM;

Line 721: x_context := FND_API.G_MISS_CHAR;

717: x_attribute7 := FND_API.G_MISS_CHAR;
718: x_attribute8 := FND_API.G_MISS_CHAR;
719: x_attribute9 := FND_API.G_MISS_CHAR;
720: x_comments := FND_API.G_MISS_CHAR;
721: x_context := FND_API.G_MISS_CHAR;
722: x_customer_item_id := FND_API.G_MISS_NUM;
723: x_end_date_active := FND_API.G_MISS_DATE;
724: x_inventory_item_id := FND_API.G_MISS_NUM;
725: x_list_price := FND_API.G_MISS_NUM;

Line 722: x_customer_item_id := FND_API.G_MISS_NUM;

718: x_attribute8 := FND_API.G_MISS_CHAR;
719: x_attribute9 := FND_API.G_MISS_CHAR;
720: x_comments := FND_API.G_MISS_CHAR;
721: x_context := FND_API.G_MISS_CHAR;
722: x_customer_item_id := FND_API.G_MISS_NUM;
723: x_end_date_active := FND_API.G_MISS_DATE;
724: x_inventory_item_id := FND_API.G_MISS_NUM;
725: x_list_price := FND_API.G_MISS_NUM;
726: x_method_code := FND_API.G_MISS_CHAR;

Line 723: x_end_date_active := FND_API.G_MISS_DATE;

719: x_attribute9 := FND_API.G_MISS_CHAR;
720: x_comments := FND_API.G_MISS_CHAR;
721: x_context := FND_API.G_MISS_CHAR;
722: x_customer_item_id := FND_API.G_MISS_NUM;
723: x_end_date_active := FND_API.G_MISS_DATE;
724: x_inventory_item_id := FND_API.G_MISS_NUM;
725: x_list_price := FND_API.G_MISS_NUM;
726: x_method_code := FND_API.G_MISS_CHAR;
727: x_price_list_id := FND_API.G_MISS_NUM;

Line 724: x_inventory_item_id := FND_API.G_MISS_NUM;

720: x_comments := FND_API.G_MISS_CHAR;
721: x_context := FND_API.G_MISS_CHAR;
722: x_customer_item_id := FND_API.G_MISS_NUM;
723: x_end_date_active := FND_API.G_MISS_DATE;
724: x_inventory_item_id := FND_API.G_MISS_NUM;
725: x_list_price := FND_API.G_MISS_NUM;
726: x_method_code := FND_API.G_MISS_CHAR;
727: x_price_list_id := FND_API.G_MISS_NUM;
728: x_price_list_line_id := FND_API.G_MISS_NUM;

Line 725: x_list_price := FND_API.G_MISS_NUM;

721: x_context := FND_API.G_MISS_CHAR;
722: x_customer_item_id := FND_API.G_MISS_NUM;
723: x_end_date_active := FND_API.G_MISS_DATE;
724: x_inventory_item_id := FND_API.G_MISS_NUM;
725: x_list_price := FND_API.G_MISS_NUM;
726: x_method_code := FND_API.G_MISS_CHAR;
727: x_price_list_id := FND_API.G_MISS_NUM;
728: x_price_list_line_id := FND_API.G_MISS_NUM;
729: x_pricing_attribute1 := FND_API.G_MISS_CHAR;

Line 726: x_method_code := FND_API.G_MISS_CHAR;

722: x_customer_item_id := FND_API.G_MISS_NUM;
723: x_end_date_active := FND_API.G_MISS_DATE;
724: x_inventory_item_id := FND_API.G_MISS_NUM;
725: x_list_price := FND_API.G_MISS_NUM;
726: x_method_code := FND_API.G_MISS_CHAR;
727: x_price_list_id := FND_API.G_MISS_NUM;
728: x_price_list_line_id := FND_API.G_MISS_NUM;
729: x_pricing_attribute1 := FND_API.G_MISS_CHAR;
730: x_pricing_attribute10 := FND_API.G_MISS_CHAR;

Line 727: x_price_list_id := FND_API.G_MISS_NUM;

723: x_end_date_active := FND_API.G_MISS_DATE;
724: x_inventory_item_id := FND_API.G_MISS_NUM;
725: x_list_price := FND_API.G_MISS_NUM;
726: x_method_code := FND_API.G_MISS_CHAR;
727: x_price_list_id := FND_API.G_MISS_NUM;
728: x_price_list_line_id := FND_API.G_MISS_NUM;
729: x_pricing_attribute1 := FND_API.G_MISS_CHAR;
730: x_pricing_attribute10 := FND_API.G_MISS_CHAR;
731: x_pricing_attribute11 := FND_API.G_MISS_CHAR;

Line 728: x_price_list_line_id := FND_API.G_MISS_NUM;

724: x_inventory_item_id := FND_API.G_MISS_NUM;
725: x_list_price := FND_API.G_MISS_NUM;
726: x_method_code := FND_API.G_MISS_CHAR;
727: x_price_list_id := FND_API.G_MISS_NUM;
728: x_price_list_line_id := FND_API.G_MISS_NUM;
729: x_pricing_attribute1 := FND_API.G_MISS_CHAR;
730: x_pricing_attribute10 := FND_API.G_MISS_CHAR;
731: x_pricing_attribute11 := FND_API.G_MISS_CHAR;
732: x_pricing_attribute12 := FND_API.G_MISS_CHAR;

Line 729: x_pricing_attribute1 := FND_API.G_MISS_CHAR;

725: x_list_price := FND_API.G_MISS_NUM;
726: x_method_code := FND_API.G_MISS_CHAR;
727: x_price_list_id := FND_API.G_MISS_NUM;
728: x_price_list_line_id := FND_API.G_MISS_NUM;
729: x_pricing_attribute1 := FND_API.G_MISS_CHAR;
730: x_pricing_attribute10 := FND_API.G_MISS_CHAR;
731: x_pricing_attribute11 := FND_API.G_MISS_CHAR;
732: x_pricing_attribute12 := FND_API.G_MISS_CHAR;
733: x_pricing_attribute13 := FND_API.G_MISS_CHAR;

Line 730: x_pricing_attribute10 := FND_API.G_MISS_CHAR;

726: x_method_code := FND_API.G_MISS_CHAR;
727: x_price_list_id := FND_API.G_MISS_NUM;
728: x_price_list_line_id := FND_API.G_MISS_NUM;
729: x_pricing_attribute1 := FND_API.G_MISS_CHAR;
730: x_pricing_attribute10 := FND_API.G_MISS_CHAR;
731: x_pricing_attribute11 := FND_API.G_MISS_CHAR;
732: x_pricing_attribute12 := FND_API.G_MISS_CHAR;
733: x_pricing_attribute13 := FND_API.G_MISS_CHAR;
734: x_pricing_attribute14 := FND_API.G_MISS_CHAR;

Line 731: x_pricing_attribute11 := FND_API.G_MISS_CHAR;

727: x_price_list_id := FND_API.G_MISS_NUM;
728: x_price_list_line_id := FND_API.G_MISS_NUM;
729: x_pricing_attribute1 := FND_API.G_MISS_CHAR;
730: x_pricing_attribute10 := FND_API.G_MISS_CHAR;
731: x_pricing_attribute11 := FND_API.G_MISS_CHAR;
732: x_pricing_attribute12 := FND_API.G_MISS_CHAR;
733: x_pricing_attribute13 := FND_API.G_MISS_CHAR;
734: x_pricing_attribute14 := FND_API.G_MISS_CHAR;
735: x_pricing_attribute15 := FND_API.G_MISS_CHAR;

Line 732: x_pricing_attribute12 := FND_API.G_MISS_CHAR;

728: x_price_list_line_id := FND_API.G_MISS_NUM;
729: x_pricing_attribute1 := FND_API.G_MISS_CHAR;
730: x_pricing_attribute10 := FND_API.G_MISS_CHAR;
731: x_pricing_attribute11 := FND_API.G_MISS_CHAR;
732: x_pricing_attribute12 := FND_API.G_MISS_CHAR;
733: x_pricing_attribute13 := FND_API.G_MISS_CHAR;
734: x_pricing_attribute14 := FND_API.G_MISS_CHAR;
735: x_pricing_attribute15 := FND_API.G_MISS_CHAR;
736: x_pricing_attribute2 := FND_API.G_MISS_CHAR;

Line 733: x_pricing_attribute13 := FND_API.G_MISS_CHAR;

729: x_pricing_attribute1 := FND_API.G_MISS_CHAR;
730: x_pricing_attribute10 := FND_API.G_MISS_CHAR;
731: x_pricing_attribute11 := FND_API.G_MISS_CHAR;
732: x_pricing_attribute12 := FND_API.G_MISS_CHAR;
733: x_pricing_attribute13 := FND_API.G_MISS_CHAR;
734: x_pricing_attribute14 := FND_API.G_MISS_CHAR;
735: x_pricing_attribute15 := FND_API.G_MISS_CHAR;
736: x_pricing_attribute2 := FND_API.G_MISS_CHAR;
737: x_pricing_attribute3 := FND_API.G_MISS_CHAR;

Line 734: x_pricing_attribute14 := FND_API.G_MISS_CHAR;

730: x_pricing_attribute10 := FND_API.G_MISS_CHAR;
731: x_pricing_attribute11 := FND_API.G_MISS_CHAR;
732: x_pricing_attribute12 := FND_API.G_MISS_CHAR;
733: x_pricing_attribute13 := FND_API.G_MISS_CHAR;
734: x_pricing_attribute14 := FND_API.G_MISS_CHAR;
735: x_pricing_attribute15 := FND_API.G_MISS_CHAR;
736: x_pricing_attribute2 := FND_API.G_MISS_CHAR;
737: x_pricing_attribute3 := FND_API.G_MISS_CHAR;
738: x_pricing_attribute4 := FND_API.G_MISS_CHAR;

Line 735: x_pricing_attribute15 := FND_API.G_MISS_CHAR;

731: x_pricing_attribute11 := FND_API.G_MISS_CHAR;
732: x_pricing_attribute12 := FND_API.G_MISS_CHAR;
733: x_pricing_attribute13 := FND_API.G_MISS_CHAR;
734: x_pricing_attribute14 := FND_API.G_MISS_CHAR;
735: x_pricing_attribute15 := FND_API.G_MISS_CHAR;
736: x_pricing_attribute2 := FND_API.G_MISS_CHAR;
737: x_pricing_attribute3 := FND_API.G_MISS_CHAR;
738: x_pricing_attribute4 := FND_API.G_MISS_CHAR;
739: x_pricing_attribute5 := FND_API.G_MISS_CHAR;

Line 736: x_pricing_attribute2 := FND_API.G_MISS_CHAR;

732: x_pricing_attribute12 := FND_API.G_MISS_CHAR;
733: x_pricing_attribute13 := FND_API.G_MISS_CHAR;
734: x_pricing_attribute14 := FND_API.G_MISS_CHAR;
735: x_pricing_attribute15 := FND_API.G_MISS_CHAR;
736: x_pricing_attribute2 := FND_API.G_MISS_CHAR;
737: x_pricing_attribute3 := FND_API.G_MISS_CHAR;
738: x_pricing_attribute4 := FND_API.G_MISS_CHAR;
739: x_pricing_attribute5 := FND_API.G_MISS_CHAR;
740: x_pricing_attribute6 := FND_API.G_MISS_CHAR;

Line 737: x_pricing_attribute3 := FND_API.G_MISS_CHAR;

733: x_pricing_attribute13 := FND_API.G_MISS_CHAR;
734: x_pricing_attribute14 := FND_API.G_MISS_CHAR;
735: x_pricing_attribute15 := FND_API.G_MISS_CHAR;
736: x_pricing_attribute2 := FND_API.G_MISS_CHAR;
737: x_pricing_attribute3 := FND_API.G_MISS_CHAR;
738: x_pricing_attribute4 := FND_API.G_MISS_CHAR;
739: x_pricing_attribute5 := FND_API.G_MISS_CHAR;
740: x_pricing_attribute6 := FND_API.G_MISS_CHAR;
741: x_pricing_attribute7 := FND_API.G_MISS_CHAR;

Line 738: x_pricing_attribute4 := FND_API.G_MISS_CHAR;

734: x_pricing_attribute14 := FND_API.G_MISS_CHAR;
735: x_pricing_attribute15 := FND_API.G_MISS_CHAR;
736: x_pricing_attribute2 := FND_API.G_MISS_CHAR;
737: x_pricing_attribute3 := FND_API.G_MISS_CHAR;
738: x_pricing_attribute4 := FND_API.G_MISS_CHAR;
739: x_pricing_attribute5 := FND_API.G_MISS_CHAR;
740: x_pricing_attribute6 := FND_API.G_MISS_CHAR;
741: x_pricing_attribute7 := FND_API.G_MISS_CHAR;
742: x_pricing_attribute8 := FND_API.G_MISS_CHAR;

Line 739: x_pricing_attribute5 := FND_API.G_MISS_CHAR;

735: x_pricing_attribute15 := FND_API.G_MISS_CHAR;
736: x_pricing_attribute2 := FND_API.G_MISS_CHAR;
737: x_pricing_attribute3 := FND_API.G_MISS_CHAR;
738: x_pricing_attribute4 := FND_API.G_MISS_CHAR;
739: x_pricing_attribute5 := FND_API.G_MISS_CHAR;
740: x_pricing_attribute6 := FND_API.G_MISS_CHAR;
741: x_pricing_attribute7 := FND_API.G_MISS_CHAR;
742: x_pricing_attribute8 := FND_API.G_MISS_CHAR;
743: x_pricing_attribute9 := FND_API.G_MISS_CHAR;

Line 740: x_pricing_attribute6 := FND_API.G_MISS_CHAR;

736: x_pricing_attribute2 := FND_API.G_MISS_CHAR;
737: x_pricing_attribute3 := FND_API.G_MISS_CHAR;
738: x_pricing_attribute4 := FND_API.G_MISS_CHAR;
739: x_pricing_attribute5 := FND_API.G_MISS_CHAR;
740: x_pricing_attribute6 := FND_API.G_MISS_CHAR;
741: x_pricing_attribute7 := FND_API.G_MISS_CHAR;
742: x_pricing_attribute8 := FND_API.G_MISS_CHAR;
743: x_pricing_attribute9 := FND_API.G_MISS_CHAR;
744: x_pricing_context := FND_API.G_MISS_CHAR;

Line 741: x_pricing_attribute7 := FND_API.G_MISS_CHAR;

737: x_pricing_attribute3 := FND_API.G_MISS_CHAR;
738: x_pricing_attribute4 := FND_API.G_MISS_CHAR;
739: x_pricing_attribute5 := FND_API.G_MISS_CHAR;
740: x_pricing_attribute6 := FND_API.G_MISS_CHAR;
741: x_pricing_attribute7 := FND_API.G_MISS_CHAR;
742: x_pricing_attribute8 := FND_API.G_MISS_CHAR;
743: x_pricing_attribute9 := FND_API.G_MISS_CHAR;
744: x_pricing_context := FND_API.G_MISS_CHAR;
745: x_pricing_rule_id := FND_API.G_MISS_NUM;

Line 742: x_pricing_attribute8 := FND_API.G_MISS_CHAR;

738: x_pricing_attribute4 := FND_API.G_MISS_CHAR;
739: x_pricing_attribute5 := FND_API.G_MISS_CHAR;
740: x_pricing_attribute6 := FND_API.G_MISS_CHAR;
741: x_pricing_attribute7 := FND_API.G_MISS_CHAR;
742: x_pricing_attribute8 := FND_API.G_MISS_CHAR;
743: x_pricing_attribute9 := FND_API.G_MISS_CHAR;
744: x_pricing_context := FND_API.G_MISS_CHAR;
745: x_pricing_rule_id := FND_API.G_MISS_NUM;
746: x_reprice_flag := FND_API.G_MISS_CHAR;

Line 743: x_pricing_attribute9 := FND_API.G_MISS_CHAR;

739: x_pricing_attribute5 := FND_API.G_MISS_CHAR;
740: x_pricing_attribute6 := FND_API.G_MISS_CHAR;
741: x_pricing_attribute7 := FND_API.G_MISS_CHAR;
742: x_pricing_attribute8 := FND_API.G_MISS_CHAR;
743: x_pricing_attribute9 := FND_API.G_MISS_CHAR;
744: x_pricing_context := FND_API.G_MISS_CHAR;
745: x_pricing_rule_id := FND_API.G_MISS_NUM;
746: x_reprice_flag := FND_API.G_MISS_CHAR;
747: x_revision := FND_API.G_MISS_CHAR;

Line 744: x_pricing_context := FND_API.G_MISS_CHAR;

740: x_pricing_attribute6 := FND_API.G_MISS_CHAR;
741: x_pricing_attribute7 := FND_API.G_MISS_CHAR;
742: x_pricing_attribute8 := FND_API.G_MISS_CHAR;
743: x_pricing_attribute9 := FND_API.G_MISS_CHAR;
744: x_pricing_context := FND_API.G_MISS_CHAR;
745: x_pricing_rule_id := FND_API.G_MISS_NUM;
746: x_reprice_flag := FND_API.G_MISS_CHAR;
747: x_revision := FND_API.G_MISS_CHAR;
748: x_revision_date := FND_API.G_MISS_DATE;

Line 745: x_pricing_rule_id := FND_API.G_MISS_NUM;

741: x_pricing_attribute7 := FND_API.G_MISS_CHAR;
742: x_pricing_attribute8 := FND_API.G_MISS_CHAR;
743: x_pricing_attribute9 := FND_API.G_MISS_CHAR;
744: x_pricing_context := FND_API.G_MISS_CHAR;
745: x_pricing_rule_id := FND_API.G_MISS_NUM;
746: x_reprice_flag := FND_API.G_MISS_CHAR;
747: x_revision := FND_API.G_MISS_CHAR;
748: x_revision_date := FND_API.G_MISS_DATE;
749: x_revision_reason_code := FND_API.G_MISS_CHAR;

Line 746: x_reprice_flag := FND_API.G_MISS_CHAR;

742: x_pricing_attribute8 := FND_API.G_MISS_CHAR;
743: x_pricing_attribute9 := FND_API.G_MISS_CHAR;
744: x_pricing_context := FND_API.G_MISS_CHAR;
745: x_pricing_rule_id := FND_API.G_MISS_NUM;
746: x_reprice_flag := FND_API.G_MISS_CHAR;
747: x_revision := FND_API.G_MISS_CHAR;
748: x_revision_date := FND_API.G_MISS_DATE;
749: x_revision_reason_code := FND_API.G_MISS_CHAR;
750: x_start_date_active := FND_API.G_MISS_DATE;

Line 747: x_revision := FND_API.G_MISS_CHAR;

743: x_pricing_attribute9 := FND_API.G_MISS_CHAR;
744: x_pricing_context := FND_API.G_MISS_CHAR;
745: x_pricing_rule_id := FND_API.G_MISS_NUM;
746: x_reprice_flag := FND_API.G_MISS_CHAR;
747: x_revision := FND_API.G_MISS_CHAR;
748: x_revision_date := FND_API.G_MISS_DATE;
749: x_revision_reason_code := FND_API.G_MISS_CHAR;
750: x_start_date_active := FND_API.G_MISS_DATE;
751: x_unit_code := FND_API.G_MISS_CHAR;

Line 748: x_revision_date := FND_API.G_MISS_DATE;

744: x_pricing_context := FND_API.G_MISS_CHAR;
745: x_pricing_rule_id := FND_API.G_MISS_NUM;
746: x_reprice_flag := FND_API.G_MISS_CHAR;
747: x_revision := FND_API.G_MISS_CHAR;
748: x_revision_date := FND_API.G_MISS_DATE;
749: x_revision_reason_code := FND_API.G_MISS_CHAR;
750: x_start_date_active := FND_API.G_MISS_DATE;
751: x_unit_code := FND_API.G_MISS_CHAR;
752: x_customer_item := FND_API.G_MISS_CHAR;

Line 749: x_revision_reason_code := FND_API.G_MISS_CHAR;

745: x_pricing_rule_id := FND_API.G_MISS_NUM;
746: x_reprice_flag := FND_API.G_MISS_CHAR;
747: x_revision := FND_API.G_MISS_CHAR;
748: x_revision_date := FND_API.G_MISS_DATE;
749: x_revision_reason_code := FND_API.G_MISS_CHAR;
750: x_start_date_active := FND_API.G_MISS_DATE;
751: x_unit_code := FND_API.G_MISS_CHAR;
752: x_customer_item := FND_API.G_MISS_CHAR;
753: x_inventory_item := FND_API.G_MISS_CHAR;

Line 750: x_start_date_active := FND_API.G_MISS_DATE;

746: x_reprice_flag := FND_API.G_MISS_CHAR;
747: x_revision := FND_API.G_MISS_CHAR;
748: x_revision_date := FND_API.G_MISS_DATE;
749: x_revision_reason_code := FND_API.G_MISS_CHAR;
750: x_start_date_active := FND_API.G_MISS_DATE;
751: x_unit_code := FND_API.G_MISS_CHAR;
752: x_customer_item := FND_API.G_MISS_CHAR;
753: x_inventory_item := FND_API.G_MISS_CHAR;
754: x_method := FND_API.G_MISS_CHAR;

Line 751: x_unit_code := FND_API.G_MISS_CHAR;

747: x_revision := FND_API.G_MISS_CHAR;
748: x_revision_date := FND_API.G_MISS_DATE;
749: x_revision_reason_code := FND_API.G_MISS_CHAR;
750: x_start_date_active := FND_API.G_MISS_DATE;
751: x_unit_code := FND_API.G_MISS_CHAR;
752: x_customer_item := FND_API.G_MISS_CHAR;
753: x_inventory_item := FND_API.G_MISS_CHAR;
754: x_method := FND_API.G_MISS_CHAR;
755: x_price_list := FND_API.G_MISS_CHAR;

Line 752: x_customer_item := FND_API.G_MISS_CHAR;

748: x_revision_date := FND_API.G_MISS_DATE;
749: x_revision_reason_code := FND_API.G_MISS_CHAR;
750: x_start_date_active := FND_API.G_MISS_DATE;
751: x_unit_code := FND_API.G_MISS_CHAR;
752: x_customer_item := FND_API.G_MISS_CHAR;
753: x_inventory_item := FND_API.G_MISS_CHAR;
754: x_method := FND_API.G_MISS_CHAR;
755: x_price_list := FND_API.G_MISS_CHAR;
756: x_price_list_line := FND_API.G_MISS_CHAR;

Line 753: x_inventory_item := FND_API.G_MISS_CHAR;

749: x_revision_reason_code := FND_API.G_MISS_CHAR;
750: x_start_date_active := FND_API.G_MISS_DATE;
751: x_unit_code := FND_API.G_MISS_CHAR;
752: x_customer_item := FND_API.G_MISS_CHAR;
753: x_inventory_item := FND_API.G_MISS_CHAR;
754: x_method := FND_API.G_MISS_CHAR;
755: x_price_list := FND_API.G_MISS_CHAR;
756: x_price_list_line := FND_API.G_MISS_CHAR;
757: x_pricing_rule := FND_API.G_MISS_CHAR;

Line 754: x_method := FND_API.G_MISS_CHAR;

750: x_start_date_active := FND_API.G_MISS_DATE;
751: x_unit_code := FND_API.G_MISS_CHAR;
752: x_customer_item := FND_API.G_MISS_CHAR;
753: x_inventory_item := FND_API.G_MISS_CHAR;
754: x_method := FND_API.G_MISS_CHAR;
755: x_price_list := FND_API.G_MISS_CHAR;
756: x_price_list_line := FND_API.G_MISS_CHAR;
757: x_pricing_rule := FND_API.G_MISS_CHAR;
758: x_reprice := FND_API.G_MISS_CHAR;

Line 755: x_price_list := FND_API.G_MISS_CHAR;

751: x_unit_code := FND_API.G_MISS_CHAR;
752: x_customer_item := FND_API.G_MISS_CHAR;
753: x_inventory_item := FND_API.G_MISS_CHAR;
754: x_method := FND_API.G_MISS_CHAR;
755: x_price_list := FND_API.G_MISS_CHAR;
756: x_price_list_line := FND_API.G_MISS_CHAR;
757: x_pricing_rule := FND_API.G_MISS_CHAR;
758: x_reprice := FND_API.G_MISS_CHAR;
759: x_revision_reason := FND_API.G_MISS_CHAR;

Line 756: x_price_list_line := FND_API.G_MISS_CHAR;

752: x_customer_item := FND_API.G_MISS_CHAR;
753: x_inventory_item := FND_API.G_MISS_CHAR;
754: x_method := FND_API.G_MISS_CHAR;
755: x_price_list := FND_API.G_MISS_CHAR;
756: x_price_list_line := FND_API.G_MISS_CHAR;
757: x_pricing_rule := FND_API.G_MISS_CHAR;
758: x_reprice := FND_API.G_MISS_CHAR;
759: x_revision_reason := FND_API.G_MISS_CHAR;
760: x_unit := FND_API.G_MISS_CHAR;

Line 757: x_pricing_rule := FND_API.G_MISS_CHAR;

753: x_inventory_item := FND_API.G_MISS_CHAR;
754: x_method := FND_API.G_MISS_CHAR;
755: x_price_list := FND_API.G_MISS_CHAR;
756: x_price_list_line := FND_API.G_MISS_CHAR;
757: x_pricing_rule := FND_API.G_MISS_CHAR;
758: x_reprice := FND_API.G_MISS_CHAR;
759: x_revision_reason := FND_API.G_MISS_CHAR;
760: x_unit := FND_API.G_MISS_CHAR;
761: x_primary := FND_API.G_MISS_CHAR;

Line 758: x_reprice := FND_API.G_MISS_CHAR;

754: x_method := FND_API.G_MISS_CHAR;
755: x_price_list := FND_API.G_MISS_CHAR;
756: x_price_list_line := FND_API.G_MISS_CHAR;
757: x_pricing_rule := FND_API.G_MISS_CHAR;
758: x_reprice := FND_API.G_MISS_CHAR;
759: x_revision_reason := FND_API.G_MISS_CHAR;
760: x_unit := FND_API.G_MISS_CHAR;
761: x_primary := FND_API.G_MISS_CHAR;
762: x_creation_date := FND_API.G_MISS_DATE;

Line 759: x_revision_reason := FND_API.G_MISS_CHAR;

755: x_price_list := FND_API.G_MISS_CHAR;
756: x_price_list_line := FND_API.G_MISS_CHAR;
757: x_pricing_rule := FND_API.G_MISS_CHAR;
758: x_reprice := FND_API.G_MISS_CHAR;
759: x_revision_reason := FND_API.G_MISS_CHAR;
760: x_unit := FND_API.G_MISS_CHAR;
761: x_primary := FND_API.G_MISS_CHAR;
762: x_creation_date := FND_API.G_MISS_DATE;
763: x_list_line_type_code := FND_API.G_MISS_CHAR;

Line 760: x_unit := FND_API.G_MISS_CHAR;

756: x_price_list_line := FND_API.G_MISS_CHAR;
757: x_pricing_rule := FND_API.G_MISS_CHAR;
758: x_reprice := FND_API.G_MISS_CHAR;
759: x_revision_reason := FND_API.G_MISS_CHAR;
760: x_unit := FND_API.G_MISS_CHAR;
761: x_primary := FND_API.G_MISS_CHAR;
762: x_creation_date := FND_API.G_MISS_DATE;
763: x_list_line_type_code := FND_API.G_MISS_CHAR;
764:

Line 761: x_primary := FND_API.G_MISS_CHAR;

757: x_pricing_rule := FND_API.G_MISS_CHAR;
758: x_reprice := FND_API.G_MISS_CHAR;
759: x_revision_reason := FND_API.G_MISS_CHAR;
760: x_unit := FND_API.G_MISS_CHAR;
761: x_primary := FND_API.G_MISS_CHAR;
762: x_creation_date := FND_API.G_MISS_DATE;
763: x_list_line_type_code := FND_API.G_MISS_CHAR;
764:
765: -- Load display out parameters if any

Line 762: x_creation_date := FND_API.G_MISS_DATE;

758: x_reprice := FND_API.G_MISS_CHAR;
759: x_revision_reason := FND_API.G_MISS_CHAR;
760: x_unit := FND_API.G_MISS_CHAR;
761: x_primary := FND_API.G_MISS_CHAR;
762: x_creation_date := FND_API.G_MISS_DATE;
763: x_list_line_type_code := FND_API.G_MISS_CHAR;
764:
765: -- Load display out parameters if any
766:

Line 763: x_list_line_type_code := FND_API.G_MISS_CHAR;

759: x_revision_reason := FND_API.G_MISS_CHAR;
760: x_unit := FND_API.G_MISS_CHAR;
761: x_primary := FND_API.G_MISS_CHAR;
762: x_creation_date := FND_API.G_MISS_DATE;
763: x_list_line_type_code := FND_API.G_MISS_CHAR;
764:
765: -- Load display out parameters if any
766:
767: l_Price_LLine_val_rec := OE_Price_List_Line_Util.Get_Values

Line 1099: x_return_status := FND_API.G_RET_STS_SUCCESS;

1095: );
1096:
1097: -- Set return status.
1098:
1099: x_return_status := FND_API.G_RET_STS_SUCCESS;
1100:
1101: -- Get message count and data
1102:
1103: OE_MSG_PUB.Count_And_Get

Line 1114: WHEN FND_API.G_EXC_ERROR THEN

1110: oe_debug_pub.add('Exiting OE_OE_Form_Price_Lline.Change_Attribute');
1111:
1112: EXCEPTION
1113:
1114: WHEN FND_API.G_EXC_ERROR THEN
1115:
1116: x_return_status := FND_API.G_RET_STS_ERROR;
1117:
1118: -- Get message count and data

Line 1116: x_return_status := FND_API.G_RET_STS_ERROR;

1112: EXCEPTION
1113:
1114: WHEN FND_API.G_EXC_ERROR THEN
1115:
1116: x_return_status := FND_API.G_RET_STS_ERROR;
1117:
1118: -- Get message count and data
1119:
1120: OE_MSG_PUB.Count_And_Get

Line 1125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1121: ( p_count => x_msg_count
1122: , p_data => x_msg_data
1123: );
1124:
1125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1126:
1127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1128:
1129: -- Get message count and data

Line 1127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1123: );
1124:
1125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1126:
1127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1128:
1129: -- Get message count and data
1130:
1131: OE_MSG_PUB.Count_And_Get

Line 1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1134: );
1135:
1136: WHEN OTHERS THEN
1137:
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1139:
1140: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1141: THEN
1142: OE_MSG_PUB.Add_Exc_Msg

Line 1227: IF FND_API.To_Boolean(l_Price_LLine_rec.db_flag) THEN

1223: oe_debug_pub.add('Price_List_Id: ' || l_Price_LLine_rec.price_list_id ||
1224: 'Price_List_Line_Id: ' || l_Price_LLine_rec.price_list_line_id);
1225: -- Set Operation.
1226:
1227: IF FND_API.To_Boolean(l_Price_LLine_rec.db_flag) THEN
1228: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1229: ELSE
1230: oe_debug_pub.add('create price list line');
1231: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_CREATE;

Line 1235: IF ( ( l_old_Price_LLine_rec.revision <> FND_API.G_MISS_CHAR )

1231: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1232: END IF;
1233:
1234: --Revision Control S
1235: IF ( ( l_old_Price_LLine_rec.revision <> FND_API.G_MISS_CHAR )
1236: AND (l_old_Price_LLine_rec.revision <> l_Price_LLine_rec.revision) )
1237: THEN
1238: oe_debug_pub.add('incrementing price list line id');
1239: oe_debug_pub.add('old rev is: ' || l_old_Price_LLine_rec.revision);

Line 1252: l_Price_LLine_rec.db_flag := FND_API.G_FALSE;

1248: END IF;
1249:
1250: select qp_list_lines_s.nextval into l_Price_LLine_rec.price_list_line_id from dual;
1251: l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1252: l_Price_LLine_rec.db_flag := FND_API.G_FALSE;
1253: END IF;
1254: --Revision Control E
1255:
1256: -- Populate Price_LLine table

Line 1265: , p_init_msg_list => FND_API.G_TRUE

1261: -- Call OE_Pricing_Cont_PVT.Process_Pricing_Cont
1262:
1263: OE_Pricing_Cont_PVT.Process_Pricing_Cont
1264: ( p_api_version_number => 1.0
1265: , p_init_msg_list => FND_API.G_TRUE
1266: , x_return_status => l_return_status
1267: , x_msg_count => x_msg_count
1268: , x_msg_data => x_msg_data
1269: , p_control_rec => l_control_rec

Line 1282: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1278: , x_Discount_Line_tbl => l_x_Discount_Line_tbl
1279: , x_Price_Break_tbl => l_x_Price_Break_tbl
1280: );
1281:
1282: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1284: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1285: RAISE FND_API.G_EXC_ERROR;
1286: END IF;

Line 1283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1279: , x_Price_Break_tbl => l_x_Price_Break_tbl
1280: );
1281:
1282: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1284: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1285: RAISE FND_API.G_EXC_ERROR;
1286: END IF;
1287:

Line 1284: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1280: );
1281:
1282: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1284: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1285: RAISE FND_API.G_EXC_ERROR;
1286: END IF;
1287:
1288:

Line 1285: RAISE FND_API.G_EXC_ERROR;

1281:
1282: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1284: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1285: RAISE FND_API.G_EXC_ERROR;
1286: END IF;
1287:
1288:
1289: -- Load OUT parameters.

Line 1310: x_return_status := FND_API.G_RET_STS_SUCCESS;

1306:
1307:
1308: -- Set return status.
1309:
1310: x_return_status := FND_API.G_RET_STS_SUCCESS;
1311:
1312: -- Get message count and data
1313:
1314: OE_MSG_PUB.Count_And_Get

Line 1323: WHEN FND_API.G_EXC_ERROR THEN

1319: oe_debug_pub.add('Exiting OE_OE_Form_Price_Lline.Validate_And_Write');
1320:
1321: EXCEPTION
1322:
1323: WHEN FND_API.G_EXC_ERROR THEN
1324:
1325: x_return_status := FND_API.G_RET_STS_ERROR;
1326:
1327: -- Get message count and data

Line 1325: x_return_status := FND_API.G_RET_STS_ERROR;

1321: EXCEPTION
1322:
1323: WHEN FND_API.G_EXC_ERROR THEN
1324:
1325: x_return_status := FND_API.G_RET_STS_ERROR;
1326:
1327: -- Get message count and data
1328:
1329: OE_MSG_PUB.Count_And_Get

Line 1334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1330: ( p_count => x_msg_count
1331: , p_data => x_msg_data
1332: );
1333:
1334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1335:
1336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1337:
1338: -- Get message count and data

Line 1336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1332: );
1333:
1334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1335:
1336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1337:
1338: -- Get message count and data
1339:
1340: OE_MSG_PUB.Count_And_Get

Line 1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1343: );
1344:
1345: WHEN OTHERS THEN
1346:
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1348:
1349: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1350: THEN
1351: OE_MSG_PUB.Add_Exc_Msg

Line 1428: , p_init_msg_list => FND_API.G_TRUE

1424: -- Call OE_Pricing_Cont_PVT.Process_Pricing_Cont
1425:
1426: OE_Pricing_Cont_PVT.Process_Pricing_Cont
1427: ( p_api_version_number => 1.0
1428: , p_init_msg_list => FND_API.G_TRUE
1429: , x_return_status => l_return_status
1430: , x_msg_count => x_msg_count
1431: , x_msg_data => x_msg_data
1432: , p_control_rec => l_control_rec

Line 1444: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1440: , x_Discount_Line_tbl => l_x_Discount_Line_tbl
1441: , x_Price_Break_tbl => l_x_Price_Break_tbl
1442: );
1443:
1444: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1446: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1447: RAISE FND_API.G_EXC_ERROR;
1448: END IF;

Line 1445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1441: , x_Price_Break_tbl => l_x_Price_Break_tbl
1442: );
1443:
1444: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1446: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1447: RAISE FND_API.G_EXC_ERROR;
1448: END IF;
1449:

Line 1446: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1442: );
1443:
1444: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1446: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1447: RAISE FND_API.G_EXC_ERROR;
1448: END IF;
1449:
1450:

Line 1447: RAISE FND_API.G_EXC_ERROR;

1443:
1444: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1446: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1447: RAISE FND_API.G_EXC_ERROR;
1448: END IF;
1449:
1450:
1451: -- Clear Price_LLine record cache

Line 1457: x_return_status := FND_API.G_RET_STS_SUCCESS;

1453: Clear_Price_LLine;
1454:
1455: -- Set return status.
1456:
1457: x_return_status := FND_API.G_RET_STS_SUCCESS;
1458:
1459: -- Get message count and data
1460:
1461: OE_MSG_PUB.Count_And_Get

Line 1469: WHEN FND_API.G_EXC_ERROR THEN

1465:
1466:
1467: EXCEPTION
1468:
1469: WHEN FND_API.G_EXC_ERROR THEN
1470:
1471: x_return_status := FND_API.G_RET_STS_ERROR;
1472:
1473: -- Get message count and data

Line 1471: x_return_status := FND_API.G_RET_STS_ERROR;

1467: EXCEPTION
1468:
1469: WHEN FND_API.G_EXC_ERROR THEN
1470:
1471: x_return_status := FND_API.G_RET_STS_ERROR;
1472:
1473: -- Get message count and data
1474:
1475: OE_MSG_PUB.Count_And_Get

Line 1480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1476: ( p_count => x_msg_count
1477: , p_data => x_msg_data
1478: );
1479:
1480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1481:
1482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1483:
1484: -- Get message count and data

Line 1482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1478: );
1479:
1480: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1481:
1482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1483:
1484: -- Get message count and data
1485:
1486: OE_MSG_PUB.Count_And_Get

Line 1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1489: );
1490:
1491: WHEN OTHERS THEN
1492:
1493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1494:
1495: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1496: THEN
1497: OE_MSG_PUB.Add_Exc_Msg

Line 1559: , p_init_msg_list => FND_API.G_TRUE

1555: -- Call OE_Pricing_Cont_PVT.Process_Pricing_Cont
1556:
1557: OE_Pricing_Cont_PVT.Process_Pricing_Cont
1558: ( p_api_version_number => 1.0
1559: , p_init_msg_list => FND_API.G_TRUE
1560: , x_return_status => l_return_status
1561: , x_msg_count => x_msg_count
1562: , x_msg_data => x_msg_data
1563: , p_control_rec => l_control_rec

Line 1574: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1570: , x_Discount_Line_tbl => l_x_Discount_Line_tbl
1571: , x_Price_Break_tbl => l_x_Price_Break_tbl
1572: );
1573:
1574: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1576: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1577: RAISE FND_API.G_EXC_ERROR;
1578: END IF;

Line 1575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1571: , x_Price_Break_tbl => l_x_Price_Break_tbl
1572: );
1573:
1574: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1576: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1577: RAISE FND_API.G_EXC_ERROR;
1578: END IF;
1579:

Line 1576: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1572: );
1573:
1574: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1576: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1577: RAISE FND_API.G_EXC_ERROR;
1578: END IF;
1579:
1580:

Line 1577: RAISE FND_API.G_EXC_ERROR;

1573:
1574: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1576: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1577: RAISE FND_API.G_EXC_ERROR;
1578: END IF;
1579:
1580:
1581: -- Set return status.

Line 1583: x_return_status := FND_API.G_RET_STS_SUCCESS;

1579:
1580:
1581: -- Set return status.
1582:
1583: x_return_status := FND_API.G_RET_STS_SUCCESS;
1584:
1585: -- Get message count and data
1586:
1587: OE_MSG_PUB.Count_And_Get

Line 1596: WHEN FND_API.G_EXC_ERROR THEN

1592: oe_debug_pub.add('Exiting OE_OE_Form_Price_Lline.Process_Entity');
1593:
1594: EXCEPTION
1595:
1596: WHEN FND_API.G_EXC_ERROR THEN
1597:
1598: x_return_status := FND_API.G_RET_STS_ERROR;
1599:
1600: -- Get message count and data

Line 1598: x_return_status := FND_API.G_RET_STS_ERROR;

1594: EXCEPTION
1595:
1596: WHEN FND_API.G_EXC_ERROR THEN
1597:
1598: x_return_status := FND_API.G_RET_STS_ERROR;
1599:
1600: -- Get message count and data
1601:
1602: OE_MSG_PUB.Count_And_Get

Line 1607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1603: ( p_count => x_msg_count
1604: , p_data => x_msg_data
1605: );
1606:
1607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1608:
1609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1610:
1611: -- Get message count and data

Line 1609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1605: );
1606:
1607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1608:
1609: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1610:
1611: -- Get message count and data
1612:
1613: OE_MSG_PUB.Count_And_Get

Line 1620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1616: );
1617:
1618: WHEN OTHERS THEN
1619:
1620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1621:
1622: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1623: THEN
1624: OE_MSG_PUB.Add_Exc_Msg

Line 1798: , p_init_msg_list => FND_API.G_TRUE

1794: -- Call OE_Pricing_Cont_PVT.Lock_Pricing_Cont
1795:
1796: OE_Pricing_Cont_PVT.Lock_Pricing_Cont
1797: ( p_api_version_number => 1.0
1798: , p_init_msg_list => FND_API.G_TRUE
1799: , x_return_status => l_return_status
1800: , x_msg_count => x_msg_count
1801: , x_msg_data => x_msg_data
1802: , p_Price_LLine_tbl => l_Price_LLine_tbl

Line 1815: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1811: );
1812:
1813: oe_debug_pub.add('price list id 3 is : ' || to_char(p_price_list_id));
1814:
1815: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1816:
1817: -- Set DB flag and write record to cache.
1818:
1819: l_x_Price_LLine_rec.db_flag := FND_API.G_TRUE;

Line 1819: l_x_Price_LLine_rec.db_flag := FND_API.G_TRUE;

1815: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1816:
1817: -- Set DB flag and write record to cache.
1818:
1819: l_x_Price_LLine_rec.db_flag := FND_API.G_TRUE;
1820:
1821: Write_Price_LLine
1822: ( p_Price_LLine_rec => l_x_Price_LLine_rec
1823: , p_db_record => TRUE

Line 1852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1848: , 'Lock_Row'
1849: );
1850: END IF;
1851:
1852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1853:
1854: -- Get message count and data
1855:
1856: OE_MSG_PUB.Count_And_Get

Line 1906: g_Price_LLine_rec.db_flag := FND_API.G_TRUE;

1902: ( p_price_list_line_id => p_price_list_line_id
1903: , p_price_list_id => g_Price_LLine_rec.price_list_id
1904: );
1905:
1906: g_Price_LLine_rec.db_flag := FND_API.G_TRUE;
1907:
1908: -- Load DB record
1909:
1910: g_db_Price_LLine_rec := g_Price_LLine_rec;