DBA Data[Home] [Help]

APPS.QP_PRICE_FORMULA_PUB dependencies on FND_API

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

43: -- End of Comments
44:
45: PROCEDURE Process_Price_Formula
46: ( p_api_version_number IN NUMBER
47: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
48: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
49: , p_commit IN VARCHAR2 := FND_API.G_FALSE
50: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
51: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

44:
45: PROCEDURE Process_Price_Formula
46: ( p_api_version_number IN NUMBER
47: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
48: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
49: , p_commit IN VARCHAR2 := FND_API.G_FALSE
50: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
51: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
52: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

45: PROCEDURE Process_Price_Formula
46: ( p_api_version_number IN NUMBER
47: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
48: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
49: , p_commit IN VARCHAR2 := FND_API.G_FALSE
50: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
51: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
52: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
53: , p_FORMULA_rec IN Formula_Rec_Type :=

Line 82: IF NOT FND_API.Compatible_API_Call

78: BEGIN
79: SAVEPOINT QP_PPF;
80: -- Standard call to check for call compatibility
81:
82: IF NOT FND_API.Compatible_API_Call
83: ( l_api_version_number
84: , p_api_version_number
85: , l_api_name
86: , G_PKG_NAME

Line 89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

85: , l_api_name
86: , G_PKG_NAME
87: )
88: THEN
89: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
90: END IF;
91:
92: l_qp_status := QP_UTIL.get_qp_status;
93:

Line 96: l_return_status := FND_API.G_RET_STS_ERROR;

92: l_qp_status := QP_UTIL.get_qp_status;
93:
94: IF l_qp_status = 'S' THEN -- Public API unavailable for Basic Pricing
95:
96: l_return_status := FND_API.G_RET_STS_ERROR;
97: FND_MESSAGE.SET_NAME('QP', 'QP_BASIC_PRICING_UNAVAILABLE');
98: OE_MSG_PUB.Add;
99: RAISE FND_API.G_EXC_ERROR;
100:

Line 99: RAISE FND_API.G_EXC_ERROR;

95:
96: l_return_status := FND_API.G_RET_STS_ERROR;
97: FND_MESSAGE.SET_NAME('QP', 'QP_BASIC_PRICING_UNAVAILABLE');
98: OE_MSG_PUB.Add;
99: RAISE FND_API.G_EXC_ERROR;
100:
101: ELSIF l_qp_status = 'N' THEN
102:
103: l_return_status := FND_API.G_RET_STS_ERROR;

Line 103: l_return_status := FND_API.G_RET_STS_ERROR;

99: RAISE FND_API.G_EXC_ERROR;
100:
101: ELSIF l_qp_status = 'N' THEN
102:
103: l_return_status := FND_API.G_RET_STS_ERROR;
104: FND_MESSAGE.SET_NAME('QP', 'QP_PRICING_NOT_INSTALLED');
105: OE_MSG_PUB.Add;
106: RAISE FND_API.G_EXC_ERROR;
107:

Line 106: RAISE FND_API.G_EXC_ERROR;

102:
103: l_return_status := FND_API.G_RET_STS_ERROR;
104: FND_MESSAGE.SET_NAME('QP', 'QP_PRICING_NOT_INSTALLED');
105: OE_MSG_PUB.Add;
106: RAISE FND_API.G_EXC_ERROR;
107:
108: END IF;
109:
110: -- Perform Value to Id conversion

Line 122: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

118: , x_FORMULA_rec => l_FORMULA_rec
119: , x_FORMULA_LINES_tbl => l_FORMULA_LINES_tbl
120: );
121:
122: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
124: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
125: RAISE FND_API.G_EXC_ERROR;
126: END IF;

Line 123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

119: , x_FORMULA_LINES_tbl => l_FORMULA_LINES_tbl
120: );
121:
122: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
124: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
125: RAISE FND_API.G_EXC_ERROR;
126: END IF;
127:

Line 124: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

120: );
121:
122: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
124: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
125: RAISE FND_API.G_EXC_ERROR;
126: END IF;
127:
128:

Line 125: RAISE FND_API.G_EXC_ERROR;

121:
122: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
124: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
125: RAISE FND_API.G_EXC_ERROR;
126: END IF;
127:
128:
129: -- Call QP_Price_Formula_PVT.Process_Price_Formula

Line 140: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

136:
137: QP_Price_Formula_PVT.Process_Price_Formula
138: ( p_api_version_number => 1.0
139: , p_init_msg_list => p_init_msg_list
140: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
141: , p_commit => p_commit
142: , x_return_status => x_return_status
143: , x_msg_count => x_msg_count
144: , x_msg_data => x_msg_data

Line 159: IF FND_API.to_Boolean(p_return_values) THEN

155: x_FORMULA_LINES_tbl := l_FORMULA_LINES_tbl;
156:
157: -- If p_return_values is TRUE then convert Ids to Values.
158:
159: IF FND_API.to_Boolean(p_return_values) THEN
160:
161: Id_To_Value
162: ( p_FORMULA_rec => l_FORMULA_rec
163: , p_FORMULA_LINES_tbl => l_FORMULA_LINES_tbl

Line 178: WHEN FND_API.G_EXC_ERROR THEN

174: END IF;
175:
176: EXCEPTION
177:
178: WHEN FND_API.G_EXC_ERROR THEN
179:
180: x_return_status := FND_API.G_RET_STS_ERROR;
181:
182: -- Get message count and data

Line 180: x_return_status := FND_API.G_RET_STS_ERROR;

176: EXCEPTION
177:
178: WHEN FND_API.G_EXC_ERROR THEN
179:
180: x_return_status := FND_API.G_RET_STS_ERROR;
181:
182: -- Get message count and data
183:
184: OE_MSG_PUB.Count_And_Get

Line 193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

189: If l_control_rec.called_from_ui='N' THEN
190: Rollback TO QP_PPF;
191: END IF;
192:
193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
194:
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
196:
197: -- Get message count and data

Line 195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

191: END IF;
192:
193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
194:
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
196:
197: -- Get message count and data
198:
199: OE_MSG_PUB.Count_And_Get

Line 210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

206: END IF;
207:
208: WHEN OTHERS THEN
209:
210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
211:
212: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
213: THEN
214: OE_MSG_PUB.Add_Exc_Msg

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

247: -- End of Comments
248:
249: PROCEDURE Lock_Price_Formula
250: ( p_api_version_number IN NUMBER
251: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
252: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
253: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
254: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
255: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

248:
249: PROCEDURE Lock_Price_Formula
250: ( p_api_version_number IN NUMBER
251: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
252: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
253: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
254: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
255: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
256: , p_FORMULA_rec IN Formula_Rec_Type :=

Line 283: IF NOT FND_API.Compatible_API_Call

279: BEGIN
280:
281: -- Standard call to check for call compatibility
282:
283: IF NOT FND_API.Compatible_API_Call
284: ( l_api_version_number
285: , p_api_version_number
286: , l_api_name
287: , G_PKG_NAME

Line 290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

286: , l_api_name
287: , G_PKG_NAME
288: )
289: THEN
290: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
291: END IF;
292:
293: -- Perform Value to Id conversion
294:

Line 305: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

301: , x_FORMULA_rec => l_FORMULA_rec
302: , x_FORMULA_LINES_tbl => l_FORMULA_LINES_tbl
303: );
304:
305: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
307: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
308: RAISE FND_API.G_EXC_ERROR;
309: END IF;

Line 306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

302: , x_FORMULA_LINES_tbl => l_FORMULA_LINES_tbl
303: );
304:
305: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
307: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
308: RAISE FND_API.G_EXC_ERROR;
309: END IF;
310:

Line 307: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

303: );
304:
305: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
307: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
308: RAISE FND_API.G_EXC_ERROR;
309: END IF;
310:
311:

Line 308: RAISE FND_API.G_EXC_ERROR;

304:
305: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
307: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
308: RAISE FND_API.G_EXC_ERROR;
309: END IF;
310:
311:
312: -- Call QP_Price_Formula_PVT.Lock_Price_Formula

Line 336: IF FND_API.to_Boolean(p_return_values) THEN

332: x_FORMULA_LINES_tbl := l_FORMULA_LINES_tbl;
333:
334: -- If p_return_values is TRUE then convert Ids to Values.
335:
336: IF FND_API.to_Boolean(p_return_values) THEN
337:
338: Id_To_Value
339: ( p_FORMULA_rec => l_FORMULA_rec
340: , p_FORMULA_LINES_tbl => l_FORMULA_LINES_tbl

Line 349: WHEN FND_API.G_EXC_ERROR THEN

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

Line 351: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

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

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

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

Line 416: FND_API.G_MISS_NUM

412: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
413: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
414: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
415: , p_price_formula_id IN NUMBER :=
416: FND_API.G_MISS_NUM
417: , p_price_formula IN VARCHAR2 :=
418: FND_API.G_MISS_CHAR
419: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ Formula_Rec_Type
420: , x_FORMULA_val_rec OUT NOCOPY /* file.sql.39 change */ Formula_Val_Rec_Type

Line 418: FND_API.G_MISS_CHAR

414: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
415: , p_price_formula_id IN NUMBER :=
416: FND_API.G_MISS_NUM
417: , p_price_formula IN VARCHAR2 :=
418: FND_API.G_MISS_CHAR
419: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ Formula_Rec_Type
420: , x_FORMULA_val_rec OUT NOCOPY /* file.sql.39 change */ Formula_Val_Rec_Type
421: , x_FORMULA_LINES_tbl OUT NOCOPY /* file.sql.39 change */ Formula_Lines_Tbl_Type
422: , x_FORMULA_LINES_val_tbl OUT NOCOPY /* file.sql.39 change */ Formula_Lines_Val_Tbl_Type

Line 434: IF NOT FND_API.Compatible_API_Call

430: BEGIN
431:
432: -- Standard call to check for call compatibility
433:
434: IF NOT FND_API.Compatible_API_Call
435: ( l_api_version_number
436: , p_api_version_number
437: , l_api_name
438: , G_PKG_NAME

Line 441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

437: , l_api_name
438: , G_PKG_NAME
439: )
440: THEN
441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
442: END IF;
443:
444: -- Standard check for Val/ID conversion
445:

Line 446: IF p_price_formula = FND_API.G_MISS_CHAR

442: END IF;
443:
444: -- Standard check for Val/ID conversion
445:
446: IF p_price_formula = FND_API.G_MISS_CHAR
447: THEN
448:
449: l_price_formula_id := p_price_formula_id;
450:

Line 451: ELSIF p_price_formula_id <> FND_API.G_MISS_NUM THEN

447: THEN
448:
449: l_price_formula_id := p_price_formula_id;
450:
451: ELSIF p_price_formula_id <> FND_API.G_MISS_NUM THEN
452:
453: l_price_formula_id := p_price_formula_id;
454:
455: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 472: IF l_price_formula_id = FND_API.G_MISS_NUM THEN

468: l_price_formula_id := QP_Value_To_Id.price_formula
469: ( p_price_formula => p_price_formula
470: );
471:
472: IF l_price_formula_id = FND_API.G_MISS_NUM THEN
473: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
474: THEN
475:
476: FND_MESSAGE.SET_NAME('QP','Invalid Business Object Value');

Line 483: RAISE FND_API.G_EXC_ERROR;

479:
480: END IF;
481: END IF;
482:
483: RAISE FND_API.G_EXC_ERROR;
484:
485: END IF;
486:
487:

Line 508: IF FND_API.TO_BOOLEAN(p_return_values) THEN

504: x_FORMULA_LINES_tbl := l_FORMULA_LINES_tbl;
505:
506: -- If p_return_values is TRUE then convert Ids to Values.
507:
508: IF FND_API.TO_BOOLEAN(p_return_values) THEN
509:
510: Id_To_Value
511: ( p_FORMULA_rec => l_FORMULA_rec
512: , p_FORMULA_LINES_tbl => l_FORMULA_LINES_tbl

Line 521: x_return_status := FND_API.G_RET_STS_SUCCESS;

517: END IF;
518:
519: -- Set return status
520:
521: x_return_status := FND_API.G_RET_STS_SUCCESS;
522:
523: -- Get message count and data
524:
525: OE_MSG_PUB.Count_And_Get

Line 533: WHEN FND_API.G_EXC_ERROR THEN

529:
530:
531: EXCEPTION
532:
533: WHEN FND_API.G_EXC_ERROR THEN
534:
535: x_return_status := FND_API.G_RET_STS_ERROR;
536:
537: -- Get message count and data

Line 535: x_return_status := FND_API.G_RET_STS_ERROR;

531: EXCEPTION
532:
533: WHEN FND_API.G_EXC_ERROR THEN
534:
535: x_return_status := FND_API.G_RET_STS_ERROR;
536:
537: -- Get message count and data
538:
539: OE_MSG_PUB.Count_And_Get

Line 544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

540: ( p_count => x_msg_count
541: , p_data => x_msg_data
542: );
543:
544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
545:
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
547:
548: -- Get message count and data

Line 546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

542: );
543:
544: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
545:
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
547:
548: -- Get message count and data
549:
550: OE_MSG_PUB.Count_And_Get

Line 557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

553: );
554:
555: WHEN OTHERS THEN
556:
557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
558:
559: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
560: THEN
561: OE_MSG_PUB.Add_Exc_Msg

Line 610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

606: , 'Id_To_Value'
607: );
608: END IF;
609:
610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
611:
612: END Id_To_Value;
613:
614: -- Procedure Value_To_Id

Line 633: x_return_status := FND_API.G_RET_STS_SUCCESS;

629: BEGIN
630:
631: -- Init x_return_status.
632:
633: x_return_status := FND_API.G_RET_STS_SUCCESS;
634:
635: -- Convert FORMULA
636:
637: l_FORMULA_rec := QP_Formula_Util.Get_Ids

Line 644: IF l_FORMULA_rec.return_status = FND_API.G_RET_STS_ERROR THEN

640: );
641:
642: x_FORMULA_rec := l_FORMULA_rec;
643:
644: IF l_FORMULA_rec.return_status = FND_API.G_RET_STS_ERROR THEN
645: x_return_status := FND_API.G_RET_STS_ERROR;
646: END IF;
647:
648: -- Convert FORMULA_LINES

Line 645: x_return_status := FND_API.G_RET_STS_ERROR;

641:
642: x_FORMULA_rec := l_FORMULA_rec;
643:
644: IF l_FORMULA_rec.return_status = FND_API.G_RET_STS_ERROR THEN
645: x_return_status := FND_API.G_RET_STS_ERROR;
646: END IF;
647:
648: -- Convert FORMULA_LINES
649:

Line 663: IF l_FORMULA_LINES_rec.return_status = FND_API.G_RET_STS_ERROR THEN

659: );
660:
661: x_FORMULA_LINES_tbl(l_index) := l_FORMULA_LINES_rec;
662:
663: IF l_FORMULA_LINES_rec.return_status = FND_API.G_RET_STS_ERROR THEN
664: x_return_status := FND_API.G_RET_STS_ERROR;
665: END IF;
666:
667: l_index := p_FORMULA_LINES_val_tbl.NEXT(l_index);

Line 664: x_return_status := FND_API.G_RET_STS_ERROR;

660:
661: x_FORMULA_LINES_tbl(l_index) := l_FORMULA_LINES_rec;
662:
663: IF l_FORMULA_LINES_rec.return_status = FND_API.G_RET_STS_ERROR THEN
664: x_return_status := FND_API.G_RET_STS_ERROR;
665: END IF;
666:
667: l_index := p_FORMULA_LINES_val_tbl.NEXT(l_index);
668:

Line 683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

679: , 'Value_To_Id'
680: );
681: END IF;
682:
683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
684:
685: END Value_To_Id;
686:
687: END QP_Price_Formula_PUB;