eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_PRICING_CONT_PUB dependencies on FND_API

Line 57: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

53: -- End of Comments
54:
55: PROCEDURE Process_Agreement
56: ( p_api_version_number IN NUMBER
57: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
58: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
59: , p_commit IN VARCHAR2 := FND_API.G_FALSE
60: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
61: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 58: , p_return_values IN VARCHAR2 := FND_API.G_FALSE

54:
55: PROCEDURE Process_Agreement
56: ( p_api_version_number IN NUMBER
57: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
58: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
59: , p_commit IN VARCHAR2 := FND_API.G_FALSE
60: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
61: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
62: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 59: , p_commit IN VARCHAR2 := FND_API.G_FALSE

55: PROCEDURE Process_Agreement
56: ( p_api_version_number IN NUMBER
57: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
58: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
59: , p_commit IN VARCHAR2 := FND_API.G_FALSE
60: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
61: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
62: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
63: , p_Agreement_rec IN Agreement_Rec_Type :=

Line 131: IF NOT FND_API.Compatible_API_Call

127: QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES := p_check_duplicate_lines;
128: oe_debug_pub.add('G_CHECK_DUP_PRICELIST_LINES '||QP_GLOBALS.G_CHECK_DUP_PRICELIST_LINES);
129: -- Standard call to check for call compatibility
130:
131: IF NOT FND_API.Compatible_API_Call
132: ( l_api_version_number
133: , p_api_version_number
134: , l_api_name
135: , G_PKG_NAME

Line 138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

134: , l_api_name
135: , G_PKG_NAME
136: )
137: THEN
138: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
139: END IF;
140:
141:
142: /* check for installation status ; if it's basic then this api

Line 148: l_return_status := FND_API.G_RET_STS_ERROR;

144:
145: l_installed_status := QP_UTIL.get_qp_status;
146:
147: IF l_installed_status IN ('S', 'N') THEN
148: l_return_status := FND_API.G_RET_STS_ERROR;
149: FND_MESSAGE.SET_NAME('QP', 'QP_BASIC_PRICING_UNAVAILABLE');
150: OE_MSG_PUB.Add;
151: RAISE FND_API.G_EXC_ERROR;
152: END IF;

Line 151: RAISE FND_API.G_EXC_ERROR;

147: IF l_installed_status IN ('S', 'N') THEN
148: l_return_status := FND_API.G_RET_STS_ERROR;
149: FND_MESSAGE.SET_NAME('QP', 'QP_BASIC_PRICING_UNAVAILABLE');
150: OE_MSG_PUB.Add;
151: RAISE FND_API.G_EXC_ERROR;
152: END IF;
153:
154: --added for moac
155: --Initialize MOAC and set org context to Multiple

Line 181: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

177: , x_Price_LLine_tbl => l_Price_LLine_tbl
178: , x_Pricing_Attr_tbl => l_Pricing_Attr_tbl
179: );
180:
181: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
183: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
184: RAISE FND_API.G_EXC_ERROR;
185: END IF;

Line 182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

178: , x_Pricing_Attr_tbl => l_Pricing_Attr_tbl
179: );
180:
181: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
183: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
184: RAISE FND_API.G_EXC_ERROR;
185: END IF;
186:

Line 183: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

179: );
180:
181: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
183: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
184: RAISE FND_API.G_EXC_ERROR;
185: END IF;
186:
187:

Line 184: RAISE FND_API.G_EXC_ERROR;

180:
181: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
183: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
184: RAISE FND_API.G_EXC_ERROR;
185: END IF;
186:
187:
188: /* First we will process the price list associated with the agreement

Line 194: if l_Price_LHeader_rec.operation <> FND_API.G_MISS_CHAR then

190:
191: -- Call the Process_Price_List PRIVATE API
192: oe_debug_pub.add('operation='||NVL(l_Price_LHeader_rec.operation,'MYNAME'));
193:
194: if l_Price_LHeader_rec.operation <> FND_API.G_MISS_CHAR then
195:
196: -- Call the process_price_list only when a price list record has been passed
197:
198: oe_debug_pub.add('Calling the process_price_list API');

Line 208: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

204:
205: QP_LIST_HEADERS_PVT.Process_Price_List
206: ( p_api_version_number => 1.0
207: , p_init_msg_list => p_init_msg_list
208: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
209: , p_commit => p_commit
210: , x_return_status => x_return_status
211: , x_msg_count => x_msg_count
212: , x_msg_data => x_msg_data

Line 240: IF FND_API.to_Boolean(p_return_values) THEN

236: /*
237:
238: -- If p_return_values is TRUE then convert Ids to Values.
239:
240: IF FND_API.to_Boolean(p_return_values) THEN
241: Id_To_Value
242: ( p_PRICE_LIST_rec => l_Price_LHeader_rec
243: , p_PRICE_LIST_LINE_tbl => l_Price_LLine_tbl
244: , p_PRICING_ATTR_tbl => l_Pricing_Attr_tbl

Line 283: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

279:
280: OE_Pricing_Cont_PVT.Process_Pricing_Cont
281: ( p_api_version_number => 1.0
282: , p_init_msg_list => p_init_msg_list
283: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
284: , p_commit => p_commit
285: , x_return_status => x_return_status
286: , x_msg_count => x_msg_count
287: , x_msg_data => x_msg_data

Line 331: IF FND_API.to_Boolean(p_return_values) THEN

327:
328:
329: -- If p_return_values is TRUE then convert Ids to Values.
330:
331: IF FND_API.to_Boolean(p_return_values) THEN
332:
333: Id_To_Value
334: ( p_Agreement_rec => l_Agreement_rec
335: , p_Price_LHeader_rec => l_Price_LHeader_rec

Line 348: WHEN FND_API.G_EXC_ERROR THEN

344: END IF;
345:
346: EXCEPTION
347:
348: WHEN FND_API.G_EXC_ERROR THEN
349:
350: x_return_status := FND_API.G_RET_STS_ERROR;
351:
352: -- Get message count and data

Line 350: x_return_status := FND_API.G_RET_STS_ERROR;

346: EXCEPTION
347:
348: WHEN FND_API.G_EXC_ERROR THEN
349:
350: x_return_status := FND_API.G_RET_STS_ERROR;
351:
352: -- Get message count and data
353:
354: OE_MSG_PUB.Count_And_Get

Line 359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

355: ( p_count => x_msg_count
356: , p_data => x_msg_data
357: );
358:
359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
360:
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
362:
363: -- Get message count and data

Line 361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

357: );
358:
359: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
360:
361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
362:
363: -- Get message count and data
364:
365: OE_MSG_PUB.Count_And_Get

Line 372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

368: );
369:
370: WHEN OTHERS THEN
371:
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
373:
374: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
375: THEN
376: OE_MSG_PUB.Add_Exc_Msg

Line 409: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

405: -- End of Comments
406:
407: PROCEDURE Lock_Agreement
408: ( p_api_version_number IN NUMBER
409: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
410: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
411: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
412: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
413: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 410: , p_return_values IN VARCHAR2 := FND_API.G_FALSE

406:
407: PROCEDURE Lock_Agreement
408: ( p_api_version_number IN NUMBER
409: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
410: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
411: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
412: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
413: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
414: , p_Agreement_rec IN Agreement_Rec_Type :=

Line 476: IF NOT FND_API.Compatible_API_Call

472: /* In the Beta Version of the PUBLIC API, Lock( ) functionality is not delivered */
473:
474: -- Standard call to check for call compatibility
475:
476: IF NOT FND_API.Compatible_API_Call
477: ( l_api_version_number
478: , p_api_version_number
479: , l_api_name
480: , G_PKG_NAME

Line 483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

479: , l_api_name
480: , G_PKG_NAME
481: )
482: THEN
483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
484: END IF;
485:
486: --added for moac
487: --Initialize MOAC and set org context to Multiple

Line 515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

511: );
512:
513:
514:
515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
517: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
518: RAISE FND_API.G_EXC_ERROR;
519: END IF;

Line 516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

512:
513:
514:
515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
517: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
518: RAISE FND_API.G_EXC_ERROR;
519: END IF;
520:

Line 517: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

513:
514:
515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
517: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
518: RAISE FND_API.G_EXC_ERROR;
519: END IF;
520:
521:

Line 518: RAISE FND_API.G_EXC_ERROR;

514:
515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
517: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
518: RAISE FND_API.G_EXC_ERROR;
519: END IF;
520:
521:
522: -- Call OE_Pricing_Cont_PVT.Lock_Pricing_Cont

Line 572: IF FND_API.to_Boolean(p_return_values) THEN

568: --x_Price_Break_tbl := l_Price_Break_tbl;
569:
570: -- If p_return_values is TRUE then convert Ids to Values.
571:
572: IF FND_API.to_Boolean(p_return_values) THEN
573:
574: Id_To_Value
575: ( p_Agreement_rec => l_Agreement_rec
576: , p_Price_LHeader_rec => l_Price_LHeader_rec

Line 590: WHEN FND_API.G_EXC_ERROR THEN

586: END IF;
587:
588: EXCEPTION
589:
590: WHEN FND_API.G_EXC_ERROR THEN
591:
592: x_return_status := FND_API.G_RET_STS_ERROR;
593:
594: -- Get message count and data

Line 592: x_return_status := FND_API.G_RET_STS_ERROR;

588: EXCEPTION
589:
590: WHEN FND_API.G_EXC_ERROR THEN
591:
592: x_return_status := FND_API.G_RET_STS_ERROR;
593:
594: -- Get message count and data
595:
596: OE_MSG_PUB.Count_And_Get

Line 601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

597: ( p_count => x_msg_count
598: , p_data => x_msg_data
599: );
600:
601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
602:
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
604:
605: -- Get message count and data

Line 603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

599: );
600:
601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
602:
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
604:
605: -- Get message count and data
606:
607: OE_MSG_PUB.Count_And_Get

Line 614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

610: );
611:
612: WHEN OTHERS THEN
613:
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
615:
616: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
617: THEN
618: OE_MSG_PUB.Add_Exc_Msg

Line 651: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

647: -- End of Comments
648:
649: PROCEDURE Get_Agreement
650: ( p_api_version_number IN NUMBER
651: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
652: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
653: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
654: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
655: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 652: , p_return_values IN VARCHAR2 := FND_API.G_FALSE

648:
649: PROCEDURE Get_Agreement
650: ( p_api_version_number IN NUMBER
651: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
652: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
653: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
654: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
655: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
656: , p_agreement_id IN NUMBER := FND_API.G_MISS_NUM

Line 656: , p_agreement_id IN NUMBER := FND_API.G_MISS_NUM

652: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
653: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
654: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
655: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
656: , p_agreement_id IN NUMBER := FND_API.G_MISS_NUM
657: /*, p_agreement IN VARCHAR2 := FND_API.G_MISS_CHAR
658: , p_revision IN VARCHAR2 := FND_API.G_MISS_CHAR */
659: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
660: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type

Line 657: /*, p_agreement IN VARCHAR2 := FND_API.G_MISS_CHAR

653: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
654: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
655: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
656: , p_agreement_id IN NUMBER := FND_API.G_MISS_NUM
657: /*, p_agreement IN VARCHAR2 := FND_API.G_MISS_CHAR
658: , p_revision IN VARCHAR2 := FND_API.G_MISS_CHAR */
659: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
660: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
661: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type

Line 658: , p_revision IN VARCHAR2 := FND_API.G_MISS_CHAR */

654: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
655: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
656: , p_agreement_id IN NUMBER := FND_API.G_MISS_NUM
657: /*, p_agreement IN VARCHAR2 := FND_API.G_MISS_CHAR
658: , p_revision IN VARCHAR2 := FND_API.G_MISS_CHAR */
659: , x_Agreement_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Rec_Type
660: , x_Agreement_val_rec OUT NOCOPY /* file.sql.39 change */ Agreement_Val_Rec_Type
661: , x_Price_LHeader_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Rec_Type
662: , x_Price_LHeader_val_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_List_PUB.Price_List_Val_Rec_Type

Line 687: IF NOT FND_API.Compatible_API_Call

683:
684:
685: -- Standard call to check for call compatibility
686:
687: IF NOT FND_API.Compatible_API_Call
688: ( l_api_version_number
689: , p_api_version_number
690: , l_api_name
691: , G_PKG_NAME

Line 694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

690: , l_api_name
691: , G_PKG_NAME
692: )
693: THEN
694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
695: END IF;
696:
697: -- Standard check for Val/ID conversion
698:

Line 731: IF FND_API.TO_BOOLEAN(p_return_values) THEN

727:
728: -- If p_return_values is TRUE then convert Ids to Values.
729:
730: /* Commenting as of now since we do not have any logic for id_to_value conversion
731: IF FND_API.TO_BOOLEAN(p_return_values) THEN
732:
733: Id_To_Value
734: ( p_Agreement_rec => l_Agreement_rec
735: , p_Price_LHeader_rec => l_Price_LHeader_rec

Line 749: x_return_status := FND_API.G_RET_STS_SUCCESS;

745: */
746:
747: -- Set return status
748:
749: x_return_status := FND_API.G_RET_STS_SUCCESS;
750:
751: -- Get message count and data
752:
753: OE_MSG_PUB.Count_And_Get

Line 761: WHEN FND_API.G_EXC_ERROR THEN

757:
758:
759: EXCEPTION
760:
761: WHEN FND_API.G_EXC_ERROR THEN
762:
763: x_return_status := FND_API.G_RET_STS_ERROR;
764:
765: -- Get message count and data

Line 763: x_return_status := FND_API.G_RET_STS_ERROR;

759: EXCEPTION
760:
761: WHEN FND_API.G_EXC_ERROR THEN
762:
763: x_return_status := FND_API.G_RET_STS_ERROR;
764:
765: -- Get message count and data
766:
767: OE_MSG_PUB.Count_And_Get

Line 772: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

768: ( p_count => x_msg_count
769: , p_data => x_msg_data
770: );
771:
772: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
773:
774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
775:
776: -- Get message count and data

Line 774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

770: );
771:
772: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
773:
774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
775:
776: -- Get message count and data
777:
778: OE_MSG_PUB.Count_And_Get

Line 785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

781: );
782:
783: WHEN OTHERS THEN
784:
785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
786:
787: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
788: THEN
789: OE_MSG_PUB.Add_Exc_Msg

Line 856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

852: , 'Id_To_Value'
853: );
854: END IF;
855:
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857:
858: END Id_To_Value;
859:
860: -- Procedure Value_To_Id

Line 889: x_return_status := FND_API.G_RET_STS_SUCCESS;

885: BEGIN
886:
887: -- Init x_return_status.
888:
889: x_return_status := FND_API.G_RET_STS_SUCCESS;
890:
891: -- Convert Agreement
892:
893: l_Agreement_rec := OE_Agreement_Util.Get_Ids

Line 900: IF l_Agreement_rec.return_status = FND_API.G_RET_STS_ERROR THEN

896: );
897:
898: x_Agreement_rec := l_Agreement_rec;
899:
900: IF l_Agreement_rec.return_status = FND_API.G_RET_STS_ERROR THEN
901: x_return_status := FND_API.G_RET_STS_ERROR;
902: END IF;
903:
904: -- Convert Price_LHeader

Line 901: x_return_status := FND_API.G_RET_STS_ERROR;

897:
898: x_Agreement_rec := l_Agreement_rec;
899:
900: IF l_Agreement_rec.return_status = FND_API.G_RET_STS_ERROR THEN
901: x_return_status := FND_API.G_RET_STS_ERROR;
902: END IF;
903:
904: -- Convert Price_LHeader
905:

Line 913: IF l_Price_LHeader_rec.return_status = FND_API.G_RET_STS_ERROR THEN

909: );
910:
911: x_Price_LHeader_rec := l_Price_LHeader_rec;
912:
913: IF l_Price_LHeader_rec.return_status = FND_API.G_RET_STS_ERROR THEN
914: x_return_status := FND_API.G_RET_STS_ERROR;
915: END IF;
916:
917:

Line 914: x_return_status := FND_API.G_RET_STS_ERROR;

910:
911: x_Price_LHeader_rec := l_Price_LHeader_rec;
912:
913: IF l_Price_LHeader_rec.return_status = FND_API.G_RET_STS_ERROR THEN
914: x_return_status := FND_API.G_RET_STS_ERROR;
915: END IF;
916:
917:
918: -- Convert Price_LLine

Line 933: IF l_Price_LLine_rec.return_status = FND_API.G_RET_STS_ERROR THEN

929: );
930:
931: x_Price_LLine_tbl(l_index) := l_Price_LLine_rec;
932:
933: IF l_Price_LLine_rec.return_status = FND_API.G_RET_STS_ERROR THEN
934: x_return_status := FND_API.G_RET_STS_ERROR;
935: END IF;
936:
937: l_index := p_Price_LLine_val_tbl.NEXT(l_index);

Line 934: x_return_status := FND_API.G_RET_STS_ERROR;

930:
931: x_Price_LLine_tbl(l_index) := l_Price_LLine_rec;
932:
933: IF l_Price_LLine_rec.return_status = FND_API.G_RET_STS_ERROR THEN
934: x_return_status := FND_API.G_RET_STS_ERROR;
935: END IF;
936:
937: l_index := p_Price_LLine_val_tbl.NEXT(l_index);
938:

Line 956: IF l_PRICING_ATTR_rec.return_status = FND_API.G_RET_STS_ERROR THEN

952: );
953:
954: x_Pricing_Attr_tbl(l_index) := l_Pricing_Attr_rec;
955:
956: IF l_PRICING_ATTR_rec.return_status = FND_API.G_RET_STS_ERROR THEN
957: x_return_status := FND_API.G_RET_STS_ERROR;
958: END IF;
959:
960: l_index := p_Pricing_Attr_val_tbl.NEXT(l_index);

Line 957: x_return_status := FND_API.G_RET_STS_ERROR;

953:
954: x_Pricing_Attr_tbl(l_index) := l_Pricing_Attr_rec;
955:
956: IF l_PRICING_ATTR_rec.return_status = FND_API.G_RET_STS_ERROR THEN
957: x_return_status := FND_API.G_RET_STS_ERROR;
958: END IF;
959:
960: l_index := p_Pricing_Attr_val_tbl.NEXT(l_index);
961: END LOOP;

Line 968: x_return_status := FND_API.G_RET_STS_ERROR; /* file.sql.39 change */

964: EXCEPTION
965:
966: WHEN OTHERS THEN
967:
968: x_return_status := FND_API.G_RET_STS_ERROR; /* file.sql.39 change */
969:
970: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
971: THEN
972: OE_MSG_PUB.Add_Exc_Msg

Line 978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

974: , 'Value_To_Id'
975: );
976: END IF;
977:
978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
979:
980: END Value_To_Id;
981:
982: END OE_Pricing_Cont_PUB;