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.QP_LIMITS_PUB dependencies on FND_API

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

48: -- End of Comments
49:
50: PROCEDURE Process_Limits
51: ( p_api_version_number IN NUMBER
52: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
53: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
54: , p_commit IN VARCHAR2 := FND_API.G_FALSE
55: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
56: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

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

49:
50: PROCEDURE Process_Limits
51: ( p_api_version_number IN NUMBER
52: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
53: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
54: , p_commit IN VARCHAR2 := FND_API.G_FALSE
55: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
56: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
57: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

50: PROCEDURE Process_Limits
51: ( p_api_version_number IN NUMBER
52: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
53: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
54: , p_commit IN VARCHAR2 := FND_API.G_FALSE
55: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
56: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
57: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
58: , p_LIMITS_rec IN Limits_Rec_Type :=

Line 94: IF NOT FND_API.Compatible_API_Call

90:
91: SAVEPOINT QP_Process_Limits;
92: -- Standard call to check for call compatibility
93:
94: IF NOT FND_API.Compatible_API_Call
95: ( l_api_version_number
96: , p_api_version_number
97: , l_api_name
98: , G_PKG_NAME

Line 101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

97: , l_api_name
98: , G_PKG_NAME
99: )
100: THEN
101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
102: END IF;
103:
104: -- BOI not available when QP not installed
105:

Line 111: l_return_status := FND_API.G_RET_STS_ERROR;

107:
108: IF l_qp_status = 'N'
109: THEN
110:
111: l_return_status := FND_API.G_RET_STS_ERROR;
112: FND_MESSAGE.SET_NAME('QP','QP_PRICING_NOT_INSTALLED');
113: OE_MSG_PUB.Add;
114: RAISE FND_API.G_EXC_ERROR;
115:

Line 114: RAISE FND_API.G_EXC_ERROR;

110:
111: l_return_status := FND_API.G_RET_STS_ERROR;
112: FND_MESSAGE.SET_NAME('QP','QP_PRICING_NOT_INSTALLED');
113: OE_MSG_PUB.Add;
114: RAISE FND_API.G_EXC_ERROR;
115:
116: END IF;
117:
118: -- Perform Value to Id conversion

Line 133: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

129: , x_LIMIT_ATTRS_tbl => l_LIMIT_ATTRS_tbl
130: , x_LIMIT_BALANCES_tbl => l_LIMIT_BALANCES_tbl
131: );
132:
133: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
135: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
136: RAISE FND_API.G_EXC_ERROR;
137: END IF;

Line 134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

130: , x_LIMIT_BALANCES_tbl => l_LIMIT_BALANCES_tbl
131: );
132:
133: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
135: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
136: RAISE FND_API.G_EXC_ERROR;
137: END IF;
138:

Line 135: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

131: );
132:
133: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
135: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
136: RAISE FND_API.G_EXC_ERROR;
137: END IF;
138:
139:

Line 136: RAISE FND_API.G_EXC_ERROR;

132:
133: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
134: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
135: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
136: RAISE FND_API.G_EXC_ERROR;
137: END IF;
138:
139:
140: -- Call QP_Limits_PVT.Process_Limits

Line 151: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

147: l_p_LIMIT_BALANCES_tbl := l_LIMIT_BALANCES_tbl;
148: QP_Limits_PVT.Process_Limits
149: ( p_api_version_number => 1.0
150: , p_init_msg_list => p_init_msg_list
151: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
152: , p_commit => p_commit
153: , x_return_status => x_return_status
154: , x_msg_count => x_msg_count
155: , x_msg_data => x_msg_data

Line 173: IF FND_API.to_Boolean(p_return_values) THEN

169: x_LIMIT_BALANCES_tbl := l_LIMIT_BALANCES_tbl;
170:
171: -- If p_return_values is TRUE then convert Ids to Values.
172:
173: IF FND_API.to_Boolean(p_return_values) THEN
174:
175: Id_To_Value
176: ( p_LIMITS_rec => l_LIMITS_rec
177: , p_LIMIT_ATTRS_tbl => l_LIMIT_ATTRS_tbl

Line 195: WHEN FND_API.G_EXC_ERROR THEN

191:
192:
193: EXCEPTION
194:
195: WHEN FND_API.G_EXC_ERROR THEN
196:
197: x_return_status := FND_API.G_RET_STS_ERROR;
198:
199: -- Get message count and data

Line 197: x_return_status := FND_API.G_RET_STS_ERROR;

193: EXCEPTION
194:
195: WHEN FND_API.G_EXC_ERROR THEN
196:
197: x_return_status := FND_API.G_RET_STS_ERROR;
198:
199: -- Get message count and data
200:
201: OE_MSG_PUB.Count_And_Get

Line 210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

206: If l_control_rec.called_from_ui='N' THEN
207: Rollback TO QP_Process_Limits;
208: END IF;
209:
210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
211:
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
213:
214: -- Get message count and data

Line 212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

208: END IF;
209:
210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
211:
212: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
213:
214: -- Get message count and data
215:
216: OE_MSG_PUB.Count_And_Get

Line 227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

223: END IF;
224:
225: WHEN OTHERS THEN
226:
227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
228:
229: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
230: THEN
231: OE_MSG_PUB.Add_Exc_Msg

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

264: -- End of Comments
265:
266: PROCEDURE Lock_Limits
267: ( p_api_version_number IN NUMBER
268: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
269: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
270: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
271: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
272: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

265:
266: PROCEDURE Lock_Limits
267: ( p_api_version_number IN NUMBER
268: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
269: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
270: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
271: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
272: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
273: , p_LIMITS_rec IN Limits_Rec_Type :=

Line 306: IF NOT FND_API.Compatible_API_Call

302: BEGIN
303:
304: -- Standard call to check for call compatibility
305:
306: IF NOT FND_API.Compatible_API_Call
307: ( l_api_version_number
308: , p_api_version_number
309: , l_api_name
310: , G_PKG_NAME

Line 313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

309: , l_api_name
310: , G_PKG_NAME
311: )
312: THEN
313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
314: END IF;
315:
316: -- Perform Value to Id conversion
317:

Line 331: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

327: , x_LIMIT_ATTRS_tbl => l_LIMIT_ATTRS_tbl
328: , x_LIMIT_BALANCES_tbl => l_LIMIT_BALANCES_tbl
329: );
330:
331: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
333: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
334: RAISE FND_API.G_EXC_ERROR;
335: END IF;

Line 332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

328: , x_LIMIT_BALANCES_tbl => l_LIMIT_BALANCES_tbl
329: );
330:
331: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
333: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
334: RAISE FND_API.G_EXC_ERROR;
335: END IF;
336:

Line 333: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

329: );
330:
331: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
333: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
334: RAISE FND_API.G_EXC_ERROR;
335: END IF;
336:
337:

Line 334: RAISE FND_API.G_EXC_ERROR;

330:
331: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
333: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
334: RAISE FND_API.G_EXC_ERROR;
335: END IF;
336:
337:
338: -- Call QP_Limits_PVT.Lock_Limits

Line 364: IF FND_API.to_Boolean(p_return_values) THEN

360: x_LIMIT_BALANCES_tbl := l_LIMIT_BALANCES_tbl;
361:
362: -- If p_return_values is TRUE then convert Ids to Values.
363:
364: IF FND_API.to_Boolean(p_return_values) THEN
365:
366: Id_To_Value
367: ( p_LIMITS_rec => l_LIMITS_rec
368: , p_LIMIT_ATTRS_tbl => l_LIMIT_ATTRS_tbl

Line 379: WHEN FND_API.G_EXC_ERROR THEN

375: END IF;
376:
377: EXCEPTION
378:
379: WHEN FND_API.G_EXC_ERROR THEN
380:
381: x_return_status := FND_API.G_RET_STS_ERROR;
382:
383: -- Get message count and data

Line 381: x_return_status := FND_API.G_RET_STS_ERROR;

377: EXCEPTION
378:
379: WHEN FND_API.G_EXC_ERROR THEN
380:
381: x_return_status := FND_API.G_RET_STS_ERROR;
382:
383: -- Get message count and data
384:
385: OE_MSG_PUB.Count_And_Get

Line 390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

386: ( p_count => x_msg_count
387: , p_data => x_msg_data
388: );
389:
390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
391:
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
393:
394: -- Get message count and data

Line 392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

388: );
389:
390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
391:
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
393:
394: -- Get message count and data
395:
396: OE_MSG_PUB.Count_And_Get

Line 403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

399: );
400:
401: WHEN OTHERS THEN
402:
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
404:
405: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
406: THEN
407: OE_MSG_PUB.Add_Exc_Msg

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

436: -- End of Comments
437:
438: PROCEDURE Get_Limits
439: ( p_api_version_number IN NUMBER
440: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
441: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
442: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
443: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
444: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

437:
438: PROCEDURE Get_Limits
439: ( p_api_version_number IN NUMBER
440: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
441: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
442: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
443: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
444: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
445: , p_limit_id IN NUMBER :=

Line 446: FND_API.G_MISS_NUM

442: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
443: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
444: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
445: , p_limit_id IN NUMBER :=
446: FND_API.G_MISS_NUM
447: , p_limit IN VARCHAR2 :=
448: FND_API.G_MISS_CHAR
449: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ Limits_Rec_Type
450: , x_LIMITS_val_rec OUT NOCOPY /* file.sql.39 change */ Limits_Val_Rec_Type

Line 448: FND_API.G_MISS_CHAR

444: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
445: , p_limit_id IN NUMBER :=
446: FND_API.G_MISS_NUM
447: , p_limit IN VARCHAR2 :=
448: FND_API.G_MISS_CHAR
449: , x_LIMITS_rec OUT NOCOPY /* file.sql.39 change */ Limits_Rec_Type
450: , x_LIMITS_val_rec OUT NOCOPY /* file.sql.39 change */ Limits_Val_Rec_Type
451: , x_LIMIT_ATTRS_tbl OUT NOCOPY /* file.sql.39 change */ Limit_Attrs_Tbl_Type
452: , x_LIMIT_ATTRS_val_tbl OUT NOCOPY /* file.sql.39 change */ Limit_Attrs_Val_Tbl_Type

Line 467: IF NOT FND_API.Compatible_API_Call

463: BEGIN
464:
465: -- Standard call to check for call compatibility
466:
467: IF NOT FND_API.Compatible_API_Call
468: ( l_api_version_number
469: , p_api_version_number
470: , l_api_name
471: , G_PKG_NAME

Line 474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

470: , l_api_name
471: , G_PKG_NAME
472: )
473: THEN
474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
475: END IF;
476:
477: -- Standard check for Val/ID conversion
478:

Line 479: IF p_limit = FND_API.G_MISS_CHAR

475: END IF;
476:
477: -- Standard check for Val/ID conversion
478:
479: IF p_limit = FND_API.G_MISS_CHAR
480: THEN
481:
482: l_limit_id := p_limit_id;
483:

Line 484: ELSIF p_limit_id <> FND_API.G_MISS_NUM THEN

480: THEN
481:
482: l_limit_id := p_limit_id;
483:
484: ELSIF p_limit_id <> FND_API.G_MISS_NUM THEN
485:
486: l_limit_id := p_limit_id;
487:
488: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 505: IF l_limit_id = FND_API.G_MISS_NUM THEN

501: l_limit_id := QP_Value_To_Id.limit
502: ( p_limit => p_limit
503: );
504:
505: IF l_limit_id = FND_API.G_MISS_NUM THEN
506: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
507: THEN
508:
509: FND_MESSAGE.SET_NAME('QP','Invalid Business Object Value');

Line 516: RAISE FND_API.G_EXC_ERROR;

512:
513: END IF;
514: END IF;
515:
516: RAISE FND_API.G_EXC_ERROR;
517:
518: END IF;
519:
520:

Line 543: IF FND_API.TO_BOOLEAN(p_return_values) THEN

539: x_LIMIT_BALANCES_tbl := l_LIMIT_BALANCES_tbl;
540:
541: -- If p_return_values is TRUE then convert Ids to Values.
542:
543: IF FND_API.TO_BOOLEAN(p_return_values) THEN
544:
545: Id_To_Value
546: ( p_LIMITS_rec => l_LIMITS_rec
547: , p_LIMIT_ATTRS_tbl => l_LIMIT_ATTRS_tbl

Line 558: x_return_status := FND_API.G_RET_STS_SUCCESS;

554: END IF;
555:
556: -- Set return status
557:
558: x_return_status := FND_API.G_RET_STS_SUCCESS;
559:
560: -- Get message count and data
561:
562: OE_MSG_PUB.Count_And_Get

Line 570: WHEN FND_API.G_EXC_ERROR THEN

566:
567:
568: EXCEPTION
569:
570: WHEN FND_API.G_EXC_ERROR THEN
571:
572: x_return_status := FND_API.G_RET_STS_ERROR;
573:
574: -- Get message count and data

Line 572: x_return_status := FND_API.G_RET_STS_ERROR;

568: EXCEPTION
569:
570: WHEN FND_API.G_EXC_ERROR THEN
571:
572: x_return_status := FND_API.G_RET_STS_ERROR;
573:
574: -- Get message count and data
575:
576: OE_MSG_PUB.Count_And_Get

Line 581: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

577: ( p_count => x_msg_count
578: , p_data => x_msg_data
579: );
580:
581: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
582:
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
584:
585: -- Get message count and data

Line 583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

579: );
580:
581: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
582:
583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
584:
585: -- Get message count and data
586:
587: OE_MSG_PUB.Count_And_Get

Line 594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

590: );
591:
592: WHEN OTHERS THEN
593:
594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
595:
596: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
597: THEN
598: OE_MSG_PUB.Add_Exc_Msg

Line 656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

652: , 'Id_To_Value'
653: );
654: END IF;
655:
656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
657:
658: END Id_To_Value;
659:
660: -- Procedure Value_To_Id

Line 683: x_return_status := FND_API.G_RET_STS_SUCCESS;

679: BEGIN
680:
681: -- Init x_return_status.
682:
683: x_return_status := FND_API.G_RET_STS_SUCCESS;
684:
685: -- Convert LIMITS
686:
687: l_LIMITS_rec := QP_Limits_Util.Get_Ids

Line 694: IF l_LIMITS_rec.return_status = FND_API.G_RET_STS_ERROR THEN

690: );
691:
692: x_LIMITS_rec := l_LIMITS_rec;
693:
694: IF l_LIMITS_rec.return_status = FND_API.G_RET_STS_ERROR THEN
695: x_return_status := FND_API.G_RET_STS_ERROR;
696: END IF;
697:
698: -- Convert LIMIT_ATTRS

Line 695: x_return_status := FND_API.G_RET_STS_ERROR;

691:
692: x_LIMITS_rec := l_LIMITS_rec;
693:
694: IF l_LIMITS_rec.return_status = FND_API.G_RET_STS_ERROR THEN
695: x_return_status := FND_API.G_RET_STS_ERROR;
696: END IF;
697:
698: -- Convert LIMIT_ATTRS
699:

Line 713: IF l_LIMIT_ATTRS_rec.return_status = FND_API.G_RET_STS_ERROR THEN

709: );
710:
711: x_LIMIT_ATTRS_tbl(l_index) := l_LIMIT_ATTRS_rec;
712:
713: IF l_LIMIT_ATTRS_rec.return_status = FND_API.G_RET_STS_ERROR THEN
714: x_return_status := FND_API.G_RET_STS_ERROR;
715: END IF;
716:
717: l_index := p_LIMIT_ATTRS_val_tbl.NEXT(l_index);

Line 714: x_return_status := FND_API.G_RET_STS_ERROR;

710:
711: x_LIMIT_ATTRS_tbl(l_index) := l_LIMIT_ATTRS_rec;
712:
713: IF l_LIMIT_ATTRS_rec.return_status = FND_API.G_RET_STS_ERROR THEN
714: x_return_status := FND_API.G_RET_STS_ERROR;
715: END IF;
716:
717: l_index := p_LIMIT_ATTRS_val_tbl.NEXT(l_index);
718:

Line 736: IF l_LIMIT_BALANCES_rec.return_status = FND_API.G_RET_STS_ERROR THEN

732: );
733:
734: x_LIMIT_BALANCES_tbl(l_index) := l_LIMIT_BALANCES_rec;
735:
736: IF l_LIMIT_BALANCES_rec.return_status = FND_API.G_RET_STS_ERROR THEN
737: x_return_status := FND_API.G_RET_STS_ERROR;
738: END IF;
739:
740: l_index := p_LIMIT_BALANCES_val_tbl.NEXT(l_index);

Line 737: x_return_status := FND_API.G_RET_STS_ERROR;

733:
734: x_LIMIT_BALANCES_tbl(l_index) := l_LIMIT_BALANCES_rec;
735:
736: IF l_LIMIT_BALANCES_rec.return_status = FND_API.G_RET_STS_ERROR THEN
737: x_return_status := FND_API.G_RET_STS_ERROR;
738: END IF;
739:
740: l_index := p_LIMIT_BALANCES_val_tbl.NEXT(l_index);
741:

Line 756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

752: , 'Value_To_Id'
753: );
754: END IF;
755:
756: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
757:
758: END Value_To_Id;
759:
760: END QP_Limits_PUB;