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_MODIFIERS_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_Modifiers
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_Modifiers
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_Modifiers
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_MODIFIER_LIST_rec IN Modifier_List_Rec_Type :=

Line 112: IF NOT FND_API.Compatible_API_Call

108: --dbms_output.put_line('BEGIN process_modifiers in Public');
109:
110: -- Standard call to check for call compatibility
111:
112: IF NOT FND_API.Compatible_API_Call
113: ( l_api_version_number
114: , p_api_version_number
115: , l_api_name
116: , G_PKG_NAME

Line 119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

115: , l_api_name
116: , G_PKG_NAME
117: )
118: THEN
119: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
120: END IF;
121:
122: -- BOI not available when QP not installed
123:

Line 134: l_return_status := FND_API.G_RET_STS_ERROR;

130:
131: IF l_qp_status = 'N' AND l_request_type_code <> 'FTE' -- shulin, 'FTE' should pass this exception
132: THEN
133:
134: l_return_status := FND_API.G_RET_STS_ERROR;
135: FND_MESSAGE.SET_NAME('QP','QP_PRICING_NOT_INSTALLED');
136: OE_MSG_PUB.Add;
137: RAISE FND_API.G_EXC_ERROR;
138:

Line 137: RAISE FND_API.G_EXC_ERROR;

133:
134: l_return_status := FND_API.G_RET_STS_ERROR;
135: FND_MESSAGE.SET_NAME('QP','QP_PRICING_NOT_INSTALLED');
136: OE_MSG_PUB.Add;
137: RAISE FND_API.G_EXC_ERROR;
138:
139: END IF;
140:
141: --added for moac

Line 152: p_MODIFIERS_tbl(1).list_header_id <> FND_API.G_MISS_NUM THEN

148:
149: -- bug#3599792/bug#3888568/#bug4261021
150: IF p_MODIFIERS_tbl.COUNT <> 0 THEN
151: IF p_MODIFIERS_tbl(1).list_header_id IS NOT NULL AND
152: p_MODIFIERS_tbl(1).list_header_id <> FND_API.G_MISS_NUM THEN
153: BEGIN
154: select list_source_code into l_list_source_code
155: from qp_list_headers_b
156: where list_header_id = p_MODIFIERS_tbl(1).list_header_id;

Line 161: AND p_MODIFIER_LIST_rec.list_source_code <> FND_API.G_MISS_CHAR

157: EXCEPTION
158: WHEN OTHERS THEN
159: oe_debug_pub.add('MODIFIERS list_header_id : '||p_MODIFIERS_tbl(1).list_header_id);
160: IF p_MODIFIER_LIST_rec.list_source_code IS NOT NULL
161: AND p_MODIFIER_LIST_rec.list_source_code <> FND_API.G_MISS_CHAR
162: THEN
163: l_list_source_code := p_MODIFIER_LIST_rec.list_source_code;
164: END IF;
165: END;

Line 167: p_MODIFIERS_tbl(1).list_line_id <> FND_API.G_MISS_NUM THEN

163: l_list_source_code := p_MODIFIER_LIST_rec.list_source_code;
164: END IF;
165: END;
166: ELSIF p_MODIFIERS_tbl(1).list_line_id IS NOT NULL AND
167: p_MODIFIERS_tbl(1).list_line_id <> FND_API.G_MISS_NUM THEN
168: BEGIN
169: select list_source_code into l_list_source_code
170: from qp_list_headers_b
171: where list_header_id = (select list_header_id from qp_list_lines

Line 177: AND p_MODIFIER_LIST_rec.list_source_code <> FND_API.G_MISS_CHAR

173: EXCEPTION
174: WHEN OTHERS THEN
175: oe_debug_pub.add('MODIFIERS list_line_id : '|| p_MODIFIERS_tbl(1).list_line_id);
176: IF p_MODIFIER_LIST_rec.list_source_code IS NOT NULL
177: AND p_MODIFIER_LIST_rec.list_source_code <> FND_API.G_MISS_CHAR
178: THEN
179: l_list_source_code := p_MODIFIER_LIST_rec.list_source_code;
180: END IF;
181: END;

Line 184: AND p_MODIFIER_LIST_rec.list_source_code <> FND_API.G_MISS_CHAR

180: END IF;
181: END;
182: ELSE
183: IF p_MODIFIER_LIST_rec.list_source_code IS NOT NULL
184: AND p_MODIFIER_LIST_rec.list_source_code <> FND_API.G_MISS_CHAR
185: THEN
186: l_list_source_code := p_MODIFIER_LIST_rec.list_source_code;
187: END IF;
188: END IF;

Line 191: AND p_MODIFIER_LIST_rec.list_source_code <> FND_API.G_MISS_CHAR

187: END IF;
188: END IF;
189: ELSE
190: IF p_MODIFIER_LIST_rec.list_source_code IS NOT NULL
191: AND p_MODIFIER_LIST_rec.list_source_code <> FND_API.G_MISS_CHAR
192: THEN
193: l_list_source_code := p_MODIFIER_LIST_rec.list_source_code;
194: END IF;
195: END IF;

Line 203: l_return_status := FND_API.G_RET_STS_ERROR;

199: IF l_qp_status = 'S' AND l_request_type_code <> 'FTE' -- shulin, 'FTE' should pass this exception
200: AND nvl(l_list_source_code,'NULL') <> QP_GLOBALS.G_ENTITY_BSO --Bug3385041
201: THEN
202:
203: l_return_status := FND_API.G_RET_STS_ERROR;
204: FND_MESSAGE.SET_NAME('QP','QP_BASIC_PRICING_UNAVAILABLE');
205: OE_MSG_PUB.Add;
206: RAISE FND_API.G_EXC_ERROR;
207:

Line 206: RAISE FND_API.G_EXC_ERROR;

202:
203: l_return_status := FND_API.G_RET_STS_ERROR;
204: FND_MESSAGE.SET_NAME('QP','QP_BASIC_PRICING_UNAVAILABLE');
205: OE_MSG_PUB.Add;
206: RAISE FND_API.G_EXC_ERROR;
207:
208: END IF;
209:
210: -- Perform Value to Id conversion

Line 229: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

225: , x_QUALIFIERS_tbl => l_QUALIFIERS_tbl
226: , x_PRICING_ATTR_tbl => l_PRICING_ATTR_tbl
227: );
228:
229: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
231: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
232: RAISE FND_API.G_EXC_ERROR;
233: END IF;

Line 230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

226: , x_PRICING_ATTR_tbl => l_PRICING_ATTR_tbl
227: );
228:
229: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
231: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
232: RAISE FND_API.G_EXC_ERROR;
233: END IF;
234:

Line 231: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

227: );
228:
229: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
231: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
232: RAISE FND_API.G_EXC_ERROR;
233: END IF;
234:
235: --bug#5154678 Continuous Price Break Changes

Line 232: RAISE FND_API.G_EXC_ERROR;

228:
229: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
230: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
231: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
232: RAISE FND_API.G_EXC_ERROR;
233: END IF;
234:
235: --bug#5154678 Continuous Price Break Changes
236: FOR i in 1..l_MODIFIERS_tbl.COUNT

Line 260: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

256: l_p_PRICING_ATTR_tbl := l_PRICING_ATTR_tbl;
257: QP_Modifiers_PVT.Process_Modifiers
258: ( p_api_version_number => 1.0
259: , p_init_msg_list => p_init_msg_list
260: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
261: , p_commit => p_commit
262: , x_return_status => x_return_status
263: , x_msg_count => x_msg_count
264: , x_msg_data => x_msg_data

Line 287: IF FND_API.to_Boolean(p_return_values) THEN

283: x_PRICING_ATTR_tbl := l_PRICING_ATTR_tbl;
284:
285: -- If p_return_values is TRUE then convert Ids to Values.
286:
287: IF FND_API.to_Boolean(p_return_values) THEN
288:
289: Id_To_Value
290: ( p_MODIFIER_LIST_rec => l_MODIFIER_LIST_rec
291: , p_MODIFIERS_tbl => l_MODIFIERS_tbl

Line 312: WHEN FND_API.G_EXC_ERROR THEN

308: oe_debug_pub.add('END process_modifiers in Public');
309: --dbms_output.put_line('END process_modifiers in Public');
310: EXCEPTION
311:
312: WHEN FND_API.G_EXC_ERROR THEN
313:
314: x_return_status := FND_API.G_RET_STS_ERROR;
315:
316: -- Get message count and data

Line 314: x_return_status := FND_API.G_RET_STS_ERROR;

310: EXCEPTION
311:
312: WHEN FND_API.G_EXC_ERROR THEN
313:
314: x_return_status := FND_API.G_RET_STS_ERROR;
315:
316: -- Get message count and data
317:
318: OE_MSG_PUB.Count_And_Get

Line 329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

325: Rollback TO QP_Process_Modifiers;
326: END IF;
327:
328:
329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
330:
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
332:
333: -- Get message count and data

Line 331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

327:
328:
329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
330:
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
332:
333: -- Get message count and data
334:
335: OE_MSG_PUB.Count_And_Get

Line 347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

343: END IF;
344:
345: WHEN OTHERS THEN
346:
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
348:
349: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
350: THEN
351: OE_MSG_PUB.Add_Exc_Msg

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

385: -- End of Comments
386:
387: PROCEDURE Lock_Modifiers
388: ( p_api_version_number IN NUMBER
389: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
390: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
391: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
392: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
393: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

386:
387: PROCEDURE Lock_Modifiers
388: ( p_api_version_number IN NUMBER
389: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
390: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
391: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
392: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
393: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
394: , p_MODIFIER_LIST_rec IN Modifier_List_Rec_Type :=

Line 436: IF NOT FND_API.Compatible_API_Call

432:
433: oe_debug_pub.add('BEGIN lock_modifiers in Public');
434: -- Standard call to check for call compatibility
435:
436: IF NOT FND_API.Compatible_API_Call
437: ( l_api_version_number
438: , p_api_version_number
439: , l_api_name
440: , G_PKG_NAME

Line 443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

439: , l_api_name
440: , G_PKG_NAME
441: )
442: THEN
443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444: END IF;
445:
446: --added for moac
447: --Initialize MOAC and set org context to Multiple

Line 474: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

470: , x_QUALIFIERS_tbl => l_QUALIFIERS_tbl
471: , x_PRICING_ATTR_tbl => l_PRICING_ATTR_tbl
472: );
473:
474: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
476: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
477: RAISE FND_API.G_EXC_ERROR;
478: END IF;

Line 475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

471: , x_PRICING_ATTR_tbl => l_PRICING_ATTR_tbl
472: );
473:
474: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
476: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
477: RAISE FND_API.G_EXC_ERROR;
478: END IF;
479:

Line 476: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

472: );
473:
474: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
476: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
477: RAISE FND_API.G_EXC_ERROR;
478: END IF;
479:
480:

Line 477: RAISE FND_API.G_EXC_ERROR;

473:
474: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
476: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
477: RAISE FND_API.G_EXC_ERROR;
478: END IF;
479:
480:
481: -- Call QP_Modifiers_PVT.Lock_Modifiers

Line 511: IF FND_API.to_Boolean(p_return_values) THEN

507: x_PRICING_ATTR_tbl := l_PRICING_ATTR_tbl;
508:
509: -- If p_return_values is TRUE then convert Ids to Values.
510:
511: IF FND_API.to_Boolean(p_return_values) THEN
512:
513: Id_To_Value
514: ( p_MODIFIER_LIST_rec => l_MODIFIER_LIST_rec
515: , p_MODIFIERS_tbl => l_MODIFIERS_tbl

Line 528: WHEN FND_API.G_EXC_ERROR THEN

524: END IF;
525:
526: EXCEPTION
527:
528: WHEN FND_API.G_EXC_ERROR THEN
529:
530: x_return_status := FND_API.G_RET_STS_ERROR;
531:
532: -- Get message count and data

Line 530: x_return_status := FND_API.G_RET_STS_ERROR;

526: EXCEPTION
527:
528: WHEN FND_API.G_EXC_ERROR THEN
529:
530: x_return_status := FND_API.G_RET_STS_ERROR;
531:
532: -- Get message count and data
533:
534: OE_MSG_PUB.Count_And_Get

Line 539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

535: ( p_count => x_msg_count
536: , p_data => x_msg_data
537: );
538:
539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
540:
541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
542:
543: -- Get message count and data

Line 541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

537: );
538:
539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
540:
541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
542:
543: -- Get message count and data
544:
545: OE_MSG_PUB.Count_And_Get

Line 552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

548: );
549:
550: WHEN OTHERS THEN
551:
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
553:
554: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
555: THEN
556: OE_MSG_PUB.Add_Exc_Msg

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

586: -- End of Comments
587:
588: PROCEDURE Get_Modifiers
589: ( p_api_version_number IN NUMBER
590: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
591: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
592: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
593: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
594: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

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

587:
588: PROCEDURE Get_Modifiers
589: ( p_api_version_number IN NUMBER
590: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
591: , p_return_values IN VARCHAR2 := FND_API.G_FALSE
592: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
593: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
594: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
595: , p_list_header_id IN NUMBER :=

Line 596: FND_API.G_MISS_NUM

592: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
593: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
594: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
595: , p_list_header_id IN NUMBER :=
596: FND_API.G_MISS_NUM
597: , p_list_header IN VARCHAR2 :=
598: FND_API.G_MISS_CHAR
599: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Rec_Type
600: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type

Line 598: FND_API.G_MISS_CHAR

594: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
595: , p_list_header_id IN NUMBER :=
596: FND_API.G_MISS_NUM
597: , p_list_header IN VARCHAR2 :=
598: FND_API.G_MISS_CHAR
599: , x_MODIFIER_LIST_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Rec_Type
600: , x_MODIFIER_LIST_val_rec OUT NOCOPY /* file.sql.39 change */ Modifier_List_Val_Rec_Type
601: , x_MODIFIERS_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Tbl_Type
602: , x_MODIFIERS_val_tbl OUT NOCOPY /* file.sql.39 change */ Modifiers_Val_Tbl_Type

Line 621: IF NOT FND_API.Compatible_API_Call

617:
618: oe_debug_pub.add('BEGIN get_modifiers in Public');
619: -- Standard call to check for call compatibility
620:
621: IF NOT FND_API.Compatible_API_Call
622: ( l_api_version_number
623: , p_api_version_number
624: , l_api_name
625: , G_PKG_NAME

Line 628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

624: , l_api_name
625: , G_PKG_NAME
626: )
627: THEN
628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
629: END IF;
630:
631: --added for moac
632: --Initialize MOAC and set org context to Multiple

Line 643: IF p_list_header = FND_API.G_MISS_CHAR

639:
640:
641: -- Standard check for Val/ID conversion
642:
643: IF p_list_header = FND_API.G_MISS_CHAR
644: THEN
645:
646: l_list_header_id := p_list_header_id;
647:

Line 648: ELSIF p_list_header_id <> FND_API.G_MISS_NUM THEN

644: THEN
645:
646: l_list_header_id := p_list_header_id;
647:
648: ELSIF p_list_header_id <> FND_API.G_MISS_NUM THEN
649:
650: l_list_header_id := p_list_header_id;
651:
652: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)

Line 669: IF l_list_header_id = FND_API.G_MISS_NUM THEN

665: l_list_header_id := QP_Value_To_Id.list_header
666: ( p_list_header => p_list_header
667: );
668:
669: IF l_list_header_id = FND_API.G_MISS_NUM THEN
670: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_ERROR)
671: THEN
672:
673: FND_MESSAGE.SET_NAME('QP','Invalid Business Object Value');

Line 680: RAISE FND_API.G_EXC_ERROR;

676:
677: END IF;
678: END IF;
679:
680: RAISE FND_API.G_EXC_ERROR;
681:
682: END IF;
683:
684:

Line 709: IF FND_API.TO_BOOLEAN(p_return_values) THEN

705: x_PRICING_ATTR_tbl := l_PRICING_ATTR_tbl;
706:
707: -- If p_return_values is TRUE then convert Ids to Values.
708:
709: IF FND_API.TO_BOOLEAN(p_return_values) THEN
710:
711: Id_To_Value
712: ( p_MODIFIER_LIST_rec => l_MODIFIER_LIST_rec
713: , p_MODIFIERS_tbl => l_MODIFIERS_tbl

Line 726: x_return_status := FND_API.G_RET_STS_SUCCESS;

722: END IF;
723:
724: -- Set return status
725:
726: x_return_status := FND_API.G_RET_STS_SUCCESS;
727:
728: -- Get message count and data
729:
730: OE_MSG_PUB.Count_And_Get

Line 738: WHEN FND_API.G_EXC_ERROR THEN

734:
735:
736: EXCEPTION
737:
738: WHEN FND_API.G_EXC_ERROR THEN
739:
740: x_return_status := FND_API.G_RET_STS_ERROR;
741:
742: -- Get message count and data

Line 740: x_return_status := FND_API.G_RET_STS_ERROR;

736: EXCEPTION
737:
738: WHEN FND_API.G_EXC_ERROR THEN
739:
740: x_return_status := FND_API.G_RET_STS_ERROR;
741:
742: -- Get message count and data
743:
744: OE_MSG_PUB.Count_And_Get

Line 749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

745: ( p_count => x_msg_count
746: , p_data => x_msg_data
747: );
748:
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750:
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
752:
753: -- Get message count and data

Line 751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

747: );
748:
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750:
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
752:
753: -- Get message count and data
754:
755: OE_MSG_PUB.Count_And_Get

Line 762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

758: );
759:
760: WHEN OTHERS THEN
761:
762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
763:
764: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
765: THEN
766: OE_MSG_PUB.Add_Exc_Msg

Line 835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

831: , 'Id_To_Value'
832: );
833: END IF;
834:
835: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
836:
837: oe_debug_pub.add('END id_to_value in Public');
838: END Id_To_Value;
839:

Line 868: x_return_status := FND_API.G_RET_STS_SUCCESS;

864:
865: oe_debug_pub.add('START value_to_id in Public');
866:
867: -- Init x_return_status.
868: x_return_status := FND_API.G_RET_STS_SUCCESS;
869:
870:
871: -- Convert MODIFIER_LIST
872:

Line 880: IF l_MODIFIER_LIST_rec.return_status = FND_API.G_RET_STS_ERROR THEN

876: );
877:
878: x_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
879:
880: IF l_MODIFIER_LIST_rec.return_status = FND_API.G_RET_STS_ERROR THEN
881: x_return_status := FND_API.G_RET_STS_ERROR;
882: END IF;
883:
884: -- Convert MODIFIERS

Line 881: x_return_status := FND_API.G_RET_STS_ERROR;

877:
878: x_MODIFIER_LIST_rec := l_MODIFIER_LIST_rec;
879:
880: IF l_MODIFIER_LIST_rec.return_status = FND_API.G_RET_STS_ERROR THEN
881: x_return_status := FND_API.G_RET_STS_ERROR;
882: END IF;
883:
884: -- Convert MODIFIERS
885:

Line 899: IF l_MODIFIERS_rec.return_status = FND_API.G_RET_STS_ERROR THEN

895: );
896:
897: x_MODIFIERS_tbl(l_index) := l_MODIFIERS_rec;
898:
899: IF l_MODIFIERS_rec.return_status = FND_API.G_RET_STS_ERROR THEN
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: END IF;
902:
903: l_index := p_MODIFIERS_val_tbl.NEXT(l_index);

Line 900: x_return_status := FND_API.G_RET_STS_ERROR;

896:
897: x_MODIFIERS_tbl(l_index) := l_MODIFIERS_rec;
898:
899: IF l_MODIFIERS_rec.return_status = FND_API.G_RET_STS_ERROR THEN
900: x_return_status := FND_API.G_RET_STS_ERROR;
901: END IF;
902:
903: l_index := p_MODIFIERS_val_tbl.NEXT(l_index);
904:

Line 922: IF l_QUALIFIERS_rec.return_status = FND_API.G_RET_STS_ERROR THEN

918: );
919:
920: x_QUALIFIERS_tbl(l_index) := l_QUALIFIERS_rec;
921:
922: IF l_QUALIFIERS_rec.return_status = FND_API.G_RET_STS_ERROR THEN
923: x_return_status := FND_API.G_RET_STS_ERROR;
924: END IF;
925:
926: l_index := p_QUALIFIERS_val_tbl.NEXT(l_index);

Line 923: x_return_status := FND_API.G_RET_STS_ERROR;

919:
920: x_QUALIFIERS_tbl(l_index) := l_QUALIFIERS_rec;
921:
922: IF l_QUALIFIERS_rec.return_status = FND_API.G_RET_STS_ERROR THEN
923: x_return_status := FND_API.G_RET_STS_ERROR;
924: END IF;
925:
926: l_index := p_QUALIFIERS_val_tbl.NEXT(l_index);
927:

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

941: );
942:
943: x_PRICING_ATTR_tbl(l_index) := l_PRICING_ATTR_rec;
944:
945: IF l_PRICING_ATTR_rec.return_status = FND_API.G_RET_STS_ERROR THEN
946: x_return_status := FND_API.G_RET_STS_ERROR;
947: END IF;
948:
949: l_index := p_PRICING_ATTR_val_tbl.NEXT(l_index);

Line 946: x_return_status := FND_API.G_RET_STS_ERROR;

942:
943: x_PRICING_ATTR_tbl(l_index) := l_PRICING_ATTR_rec;
944:
945: IF l_PRICING_ATTR_rec.return_status = FND_API.G_RET_STS_ERROR THEN
946: x_return_status := FND_API.G_RET_STS_ERROR;
947: END IF;
948:
949: l_index := p_PRICING_ATTR_val_tbl.NEXT(l_index);
950:

Line 966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

962: , 'Value_To_Id'
963: );
964: END IF;
965:
966: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
967:
968: END Value_To_Id;
969:
970: END QP_Modifiers_PUB;