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_QP_FORM_PRICING_ATTR dependencies on FND_API

Line 147: , p_init_msg_list => FND_API.G_TRUE

143: -- Call QP_Modifiers_PVT.Process_MODIFIERS
144:
145: QP_Modifiers_PVT.Process_MODIFIERS
146: ( p_api_version_number => 1.0
147: , p_init_msg_list => FND_API.G_TRUE
148: , x_return_status => l_return_status
149: , x_msg_count => x_msg_count
150: , x_msg_data => x_msg_data
151: , p_control_rec => l_control_rec

Line 159: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

155: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
156: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
157: );
158:
159: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
161: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
162: RAISE FND_API.G_EXC_ERROR;
163: END IF;

Line 160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

156: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
157: );
158:
159: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
161: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
162: RAISE FND_API.G_EXC_ERROR;
163: END IF;
164:

Line 161: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

157: );
158:
159: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
161: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
162: RAISE FND_API.G_EXC_ERROR;
163: END IF;
164:
165:

Line 162: RAISE FND_API.G_EXC_ERROR;

158:
159: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
161: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
162: RAISE FND_API.G_EXC_ERROR;
163: END IF;
164:
165:
166: -- Unload out tbl

Line 218: l_x_PRICING_ATTR_rec.db_flag := FND_API.G_FALSE;

214:
215: -- Write to cache.
216: -- Set db_flag to False before writing to cache
217:
218: l_x_PRICING_ATTR_rec.db_flag := FND_API.G_FALSE;
219:
220: Write_PRICING_ATTR
221: ( p_PRICING_ATTR_rec => l_x_PRICING_ATTR_rec
222: );

Line 226: x_return_status := FND_API.G_RET_STS_SUCCESS;

222: );
223:
224: -- Set return status.
225:
226: x_return_status := FND_API.G_RET_STS_SUCCESS;
227:
228: -- Get message count and data
229:
230: OE_MSG_PUB.Count_And_Get

Line 240: WHEN FND_API.G_EXC_ERROR THEN

236: oe_debug_pub.add('END Default_Attributes in QPXFPRAB');
237:
238: EXCEPTION
239:
240: WHEN FND_API.G_EXC_ERROR THEN
241:
242: x_return_status := FND_API.G_RET_STS_ERROR;
243:
244: -- Get message count and data

Line 242: x_return_status := FND_API.G_RET_STS_ERROR;

238: EXCEPTION
239:
240: WHEN FND_API.G_EXC_ERROR THEN
241:
242: x_return_status := FND_API.G_RET_STS_ERROR;
243:
244: -- Get message count and data
245:
246: OE_MSG_PUB.Count_And_Get

Line 251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

247: ( p_count => x_msg_count
248: , p_data => x_msg_data
249: );
250:
251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
252:
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
254:
255: -- Get message count and data

Line 253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

249: );
250:
251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
252:
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
254:
255: -- Get message count and data
256:
257: OE_MSG_PUB.Count_And_Get

Line 264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

260: );
261:
262: WHEN OTHERS THEN
263:
264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
265:
266: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
267: THEN
268: OE_MSG_PUB.Add_Exc_Msg

Line 473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

469: , 'Unrecognized attribute'
470: );
471: END IF;
472:
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474:
475: END IF;
476:
477: OE_Debug_PUB.add('operation');

Line 480: IF FND_API.To_Boolean(l_PRICING_ATTR_rec.db_flag) THEN

476:
477: OE_Debug_PUB.add('operation');
478: -- Set Operation.
479:
480: IF FND_API.To_Boolean(l_PRICING_ATTR_rec.db_flag) THEN
481: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
482: ELSE
483: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_CREATE;
484: END IF;

Line 496: , p_init_msg_list => FND_API.G_TRUE

492:
493: OE_Debug_PUB.add('process mod');
494: QP_Modifiers_PVT.Process_MODIFIERS
495: ( p_api_version_number => 1.0
496: , p_init_msg_list => FND_API.G_TRUE
497: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
498: , x_return_status => l_return_status
499: , x_msg_count => x_msg_count
500: , x_msg_data => x_msg_data

Line 497: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

493: OE_Debug_PUB.add('process mod');
494: QP_Modifiers_PVT.Process_MODIFIERS
495: ( p_api_version_number => 1.0
496: , p_init_msg_list => FND_API.G_TRUE
497: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
498: , x_return_status => l_return_status
499: , x_msg_count => x_msg_count
500: , x_msg_data => x_msg_data
501: , p_control_rec => l_control_rec

Line 510: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

506: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
507: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
508: );
509:
510: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
512: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
513: RAISE FND_API.G_EXC_ERROR;
514: END IF;

Line 511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

507: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
508: );
509:
510: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
512: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
513: RAISE FND_API.G_EXC_ERROR;
514: END IF;
515:

Line 512: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

508: );
509:
510: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
512: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
513: RAISE FND_API.G_EXC_ERROR;
514: END IF;
515:
516:

Line 513: RAISE FND_API.G_EXC_ERROR;

509:
510: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
512: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
513: RAISE FND_API.G_EXC_ERROR;
514: END IF;
515:
516:
517: OE_Debug_PUB.add('after process mod');

Line 524: x_accumulate_flag := FND_API.G_MISS_CHAR;

520: l_x_PRICING_ATTR_rec := l_x_PRICING_ATTR_tbl(1);
521:
522: -- Init OUT parameters to missing.
523:
524: x_accumulate_flag := FND_API.G_MISS_CHAR;
525: x_attribute1 := FND_API.G_MISS_CHAR;
526: x_attribute10 := FND_API.G_MISS_CHAR;
527: x_attribute11 := FND_API.G_MISS_CHAR;
528: x_attribute12 := FND_API.G_MISS_CHAR;

Line 525: x_attribute1 := FND_API.G_MISS_CHAR;

521:
522: -- Init OUT parameters to missing.
523:
524: x_accumulate_flag := FND_API.G_MISS_CHAR;
525: x_attribute1 := FND_API.G_MISS_CHAR;
526: x_attribute10 := FND_API.G_MISS_CHAR;
527: x_attribute11 := FND_API.G_MISS_CHAR;
528: x_attribute12 := FND_API.G_MISS_CHAR;
529: x_attribute13 := FND_API.G_MISS_CHAR;

Line 526: x_attribute10 := FND_API.G_MISS_CHAR;

522: -- Init OUT parameters to missing.
523:
524: x_accumulate_flag := FND_API.G_MISS_CHAR;
525: x_attribute1 := FND_API.G_MISS_CHAR;
526: x_attribute10 := FND_API.G_MISS_CHAR;
527: x_attribute11 := FND_API.G_MISS_CHAR;
528: x_attribute12 := FND_API.G_MISS_CHAR;
529: x_attribute13 := FND_API.G_MISS_CHAR;
530: x_attribute14 := FND_API.G_MISS_CHAR;

Line 527: x_attribute11 := FND_API.G_MISS_CHAR;

523:
524: x_accumulate_flag := FND_API.G_MISS_CHAR;
525: x_attribute1 := FND_API.G_MISS_CHAR;
526: x_attribute10 := FND_API.G_MISS_CHAR;
527: x_attribute11 := FND_API.G_MISS_CHAR;
528: x_attribute12 := FND_API.G_MISS_CHAR;
529: x_attribute13 := FND_API.G_MISS_CHAR;
530: x_attribute14 := FND_API.G_MISS_CHAR;
531: x_attribute15 := FND_API.G_MISS_CHAR;

Line 528: x_attribute12 := FND_API.G_MISS_CHAR;

524: x_accumulate_flag := FND_API.G_MISS_CHAR;
525: x_attribute1 := FND_API.G_MISS_CHAR;
526: x_attribute10 := FND_API.G_MISS_CHAR;
527: x_attribute11 := FND_API.G_MISS_CHAR;
528: x_attribute12 := FND_API.G_MISS_CHAR;
529: x_attribute13 := FND_API.G_MISS_CHAR;
530: x_attribute14 := FND_API.G_MISS_CHAR;
531: x_attribute15 := FND_API.G_MISS_CHAR;
532: x_attribute2 := FND_API.G_MISS_CHAR;

Line 529: x_attribute13 := FND_API.G_MISS_CHAR;

525: x_attribute1 := FND_API.G_MISS_CHAR;
526: x_attribute10 := FND_API.G_MISS_CHAR;
527: x_attribute11 := FND_API.G_MISS_CHAR;
528: x_attribute12 := FND_API.G_MISS_CHAR;
529: x_attribute13 := FND_API.G_MISS_CHAR;
530: x_attribute14 := FND_API.G_MISS_CHAR;
531: x_attribute15 := FND_API.G_MISS_CHAR;
532: x_attribute2 := FND_API.G_MISS_CHAR;
533: x_attribute3 := FND_API.G_MISS_CHAR;

Line 530: x_attribute14 := FND_API.G_MISS_CHAR;

526: x_attribute10 := FND_API.G_MISS_CHAR;
527: x_attribute11 := FND_API.G_MISS_CHAR;
528: x_attribute12 := FND_API.G_MISS_CHAR;
529: x_attribute13 := FND_API.G_MISS_CHAR;
530: x_attribute14 := FND_API.G_MISS_CHAR;
531: x_attribute15 := FND_API.G_MISS_CHAR;
532: x_attribute2 := FND_API.G_MISS_CHAR;
533: x_attribute3 := FND_API.G_MISS_CHAR;
534: x_attribute4 := FND_API.G_MISS_CHAR;

Line 531: x_attribute15 := FND_API.G_MISS_CHAR;

527: x_attribute11 := FND_API.G_MISS_CHAR;
528: x_attribute12 := FND_API.G_MISS_CHAR;
529: x_attribute13 := FND_API.G_MISS_CHAR;
530: x_attribute14 := FND_API.G_MISS_CHAR;
531: x_attribute15 := FND_API.G_MISS_CHAR;
532: x_attribute2 := FND_API.G_MISS_CHAR;
533: x_attribute3 := FND_API.G_MISS_CHAR;
534: x_attribute4 := FND_API.G_MISS_CHAR;
535: x_attribute5 := FND_API.G_MISS_CHAR;

Line 532: x_attribute2 := FND_API.G_MISS_CHAR;

528: x_attribute12 := FND_API.G_MISS_CHAR;
529: x_attribute13 := FND_API.G_MISS_CHAR;
530: x_attribute14 := FND_API.G_MISS_CHAR;
531: x_attribute15 := FND_API.G_MISS_CHAR;
532: x_attribute2 := FND_API.G_MISS_CHAR;
533: x_attribute3 := FND_API.G_MISS_CHAR;
534: x_attribute4 := FND_API.G_MISS_CHAR;
535: x_attribute5 := FND_API.G_MISS_CHAR;
536: x_attribute6 := FND_API.G_MISS_CHAR;

Line 533: x_attribute3 := FND_API.G_MISS_CHAR;

529: x_attribute13 := FND_API.G_MISS_CHAR;
530: x_attribute14 := FND_API.G_MISS_CHAR;
531: x_attribute15 := FND_API.G_MISS_CHAR;
532: x_attribute2 := FND_API.G_MISS_CHAR;
533: x_attribute3 := FND_API.G_MISS_CHAR;
534: x_attribute4 := FND_API.G_MISS_CHAR;
535: x_attribute5 := FND_API.G_MISS_CHAR;
536: x_attribute6 := FND_API.G_MISS_CHAR;
537: x_attribute7 := FND_API.G_MISS_CHAR;

Line 534: x_attribute4 := FND_API.G_MISS_CHAR;

530: x_attribute14 := FND_API.G_MISS_CHAR;
531: x_attribute15 := FND_API.G_MISS_CHAR;
532: x_attribute2 := FND_API.G_MISS_CHAR;
533: x_attribute3 := FND_API.G_MISS_CHAR;
534: x_attribute4 := FND_API.G_MISS_CHAR;
535: x_attribute5 := FND_API.G_MISS_CHAR;
536: x_attribute6 := FND_API.G_MISS_CHAR;
537: x_attribute7 := FND_API.G_MISS_CHAR;
538: x_attribute8 := FND_API.G_MISS_CHAR;

Line 535: x_attribute5 := FND_API.G_MISS_CHAR;

531: x_attribute15 := FND_API.G_MISS_CHAR;
532: x_attribute2 := FND_API.G_MISS_CHAR;
533: x_attribute3 := FND_API.G_MISS_CHAR;
534: x_attribute4 := FND_API.G_MISS_CHAR;
535: x_attribute5 := FND_API.G_MISS_CHAR;
536: x_attribute6 := FND_API.G_MISS_CHAR;
537: x_attribute7 := FND_API.G_MISS_CHAR;
538: x_attribute8 := FND_API.G_MISS_CHAR;
539: x_attribute9 := FND_API.G_MISS_CHAR;

Line 536: x_attribute6 := FND_API.G_MISS_CHAR;

532: x_attribute2 := FND_API.G_MISS_CHAR;
533: x_attribute3 := FND_API.G_MISS_CHAR;
534: x_attribute4 := FND_API.G_MISS_CHAR;
535: x_attribute5 := FND_API.G_MISS_CHAR;
536: x_attribute6 := FND_API.G_MISS_CHAR;
537: x_attribute7 := FND_API.G_MISS_CHAR;
538: x_attribute8 := FND_API.G_MISS_CHAR;
539: x_attribute9 := FND_API.G_MISS_CHAR;
540: x_attribute_grouping_no := FND_API.G_MISS_NUM;

Line 537: x_attribute7 := FND_API.G_MISS_CHAR;

533: x_attribute3 := FND_API.G_MISS_CHAR;
534: x_attribute4 := FND_API.G_MISS_CHAR;
535: x_attribute5 := FND_API.G_MISS_CHAR;
536: x_attribute6 := FND_API.G_MISS_CHAR;
537: x_attribute7 := FND_API.G_MISS_CHAR;
538: x_attribute8 := FND_API.G_MISS_CHAR;
539: x_attribute9 := FND_API.G_MISS_CHAR;
540: x_attribute_grouping_no := FND_API.G_MISS_NUM;
541: x_context := FND_API.G_MISS_CHAR;

Line 538: x_attribute8 := FND_API.G_MISS_CHAR;

534: x_attribute4 := FND_API.G_MISS_CHAR;
535: x_attribute5 := FND_API.G_MISS_CHAR;
536: x_attribute6 := FND_API.G_MISS_CHAR;
537: x_attribute7 := FND_API.G_MISS_CHAR;
538: x_attribute8 := FND_API.G_MISS_CHAR;
539: x_attribute9 := FND_API.G_MISS_CHAR;
540: x_attribute_grouping_no := FND_API.G_MISS_NUM;
541: x_context := FND_API.G_MISS_CHAR;
542: x_excluder_flag := FND_API.G_MISS_CHAR;

Line 539: x_attribute9 := FND_API.G_MISS_CHAR;

535: x_attribute5 := FND_API.G_MISS_CHAR;
536: x_attribute6 := FND_API.G_MISS_CHAR;
537: x_attribute7 := FND_API.G_MISS_CHAR;
538: x_attribute8 := FND_API.G_MISS_CHAR;
539: x_attribute9 := FND_API.G_MISS_CHAR;
540: x_attribute_grouping_no := FND_API.G_MISS_NUM;
541: x_context := FND_API.G_MISS_CHAR;
542: x_excluder_flag := FND_API.G_MISS_CHAR;
543: x_list_line_id := FND_API.G_MISS_NUM;

Line 540: x_attribute_grouping_no := FND_API.G_MISS_NUM;

536: x_attribute6 := FND_API.G_MISS_CHAR;
537: x_attribute7 := FND_API.G_MISS_CHAR;
538: x_attribute8 := FND_API.G_MISS_CHAR;
539: x_attribute9 := FND_API.G_MISS_CHAR;
540: x_attribute_grouping_no := FND_API.G_MISS_NUM;
541: x_context := FND_API.G_MISS_CHAR;
542: x_excluder_flag := FND_API.G_MISS_CHAR;
543: x_list_line_id := FND_API.G_MISS_NUM;
544: x_pricing_attribute := FND_API.G_MISS_CHAR;

Line 541: x_context := FND_API.G_MISS_CHAR;

537: x_attribute7 := FND_API.G_MISS_CHAR;
538: x_attribute8 := FND_API.G_MISS_CHAR;
539: x_attribute9 := FND_API.G_MISS_CHAR;
540: x_attribute_grouping_no := FND_API.G_MISS_NUM;
541: x_context := FND_API.G_MISS_CHAR;
542: x_excluder_flag := FND_API.G_MISS_CHAR;
543: x_list_line_id := FND_API.G_MISS_NUM;
544: x_pricing_attribute := FND_API.G_MISS_CHAR;
545: x_pricing_attribute_context := FND_API.G_MISS_CHAR;

Line 542: x_excluder_flag := FND_API.G_MISS_CHAR;

538: x_attribute8 := FND_API.G_MISS_CHAR;
539: x_attribute9 := FND_API.G_MISS_CHAR;
540: x_attribute_grouping_no := FND_API.G_MISS_NUM;
541: x_context := FND_API.G_MISS_CHAR;
542: x_excluder_flag := FND_API.G_MISS_CHAR;
543: x_list_line_id := FND_API.G_MISS_NUM;
544: x_pricing_attribute := FND_API.G_MISS_CHAR;
545: x_pricing_attribute_context := FND_API.G_MISS_CHAR;
546: x_pricing_attribute_id := FND_API.G_MISS_NUM;

Line 543: x_list_line_id := FND_API.G_MISS_NUM;

539: x_attribute9 := FND_API.G_MISS_CHAR;
540: x_attribute_grouping_no := FND_API.G_MISS_NUM;
541: x_context := FND_API.G_MISS_CHAR;
542: x_excluder_flag := FND_API.G_MISS_CHAR;
543: x_list_line_id := FND_API.G_MISS_NUM;
544: x_pricing_attribute := FND_API.G_MISS_CHAR;
545: x_pricing_attribute_context := FND_API.G_MISS_CHAR;
546: x_pricing_attribute_id := FND_API.G_MISS_NUM;
547: x_pricing_attr_value_from := FND_API.G_MISS_CHAR;

Line 544: x_pricing_attribute := FND_API.G_MISS_CHAR;

540: x_attribute_grouping_no := FND_API.G_MISS_NUM;
541: x_context := FND_API.G_MISS_CHAR;
542: x_excluder_flag := FND_API.G_MISS_CHAR;
543: x_list_line_id := FND_API.G_MISS_NUM;
544: x_pricing_attribute := FND_API.G_MISS_CHAR;
545: x_pricing_attribute_context := FND_API.G_MISS_CHAR;
546: x_pricing_attribute_id := FND_API.G_MISS_NUM;
547: x_pricing_attr_value_from := FND_API.G_MISS_CHAR;
548: x_pricing_attr_value_to := FND_API.G_MISS_CHAR;

Line 545: x_pricing_attribute_context := FND_API.G_MISS_CHAR;

541: x_context := FND_API.G_MISS_CHAR;
542: x_excluder_flag := FND_API.G_MISS_CHAR;
543: x_list_line_id := FND_API.G_MISS_NUM;
544: x_pricing_attribute := FND_API.G_MISS_CHAR;
545: x_pricing_attribute_context := FND_API.G_MISS_CHAR;
546: x_pricing_attribute_id := FND_API.G_MISS_NUM;
547: x_pricing_attr_value_from := FND_API.G_MISS_CHAR;
548: x_pricing_attr_value_to := FND_API.G_MISS_CHAR;
549: x_product_attribute := FND_API.G_MISS_CHAR;

Line 546: x_pricing_attribute_id := FND_API.G_MISS_NUM;

542: x_excluder_flag := FND_API.G_MISS_CHAR;
543: x_list_line_id := FND_API.G_MISS_NUM;
544: x_pricing_attribute := FND_API.G_MISS_CHAR;
545: x_pricing_attribute_context := FND_API.G_MISS_CHAR;
546: x_pricing_attribute_id := FND_API.G_MISS_NUM;
547: x_pricing_attr_value_from := FND_API.G_MISS_CHAR;
548: x_pricing_attr_value_to := FND_API.G_MISS_CHAR;
549: x_product_attribute := FND_API.G_MISS_CHAR;
550: x_product_attribute_context := FND_API.G_MISS_CHAR;

Line 547: x_pricing_attr_value_from := FND_API.G_MISS_CHAR;

543: x_list_line_id := FND_API.G_MISS_NUM;
544: x_pricing_attribute := FND_API.G_MISS_CHAR;
545: x_pricing_attribute_context := FND_API.G_MISS_CHAR;
546: x_pricing_attribute_id := FND_API.G_MISS_NUM;
547: x_pricing_attr_value_from := FND_API.G_MISS_CHAR;
548: x_pricing_attr_value_to := FND_API.G_MISS_CHAR;
549: x_product_attribute := FND_API.G_MISS_CHAR;
550: x_product_attribute_context := FND_API.G_MISS_CHAR;
551: x_product_attr_value := FND_API.G_MISS_CHAR;

Line 548: x_pricing_attr_value_to := FND_API.G_MISS_CHAR;

544: x_pricing_attribute := FND_API.G_MISS_CHAR;
545: x_pricing_attribute_context := FND_API.G_MISS_CHAR;
546: x_pricing_attribute_id := FND_API.G_MISS_NUM;
547: x_pricing_attr_value_from := FND_API.G_MISS_CHAR;
548: x_pricing_attr_value_to := FND_API.G_MISS_CHAR;
549: x_product_attribute := FND_API.G_MISS_CHAR;
550: x_product_attribute_context := FND_API.G_MISS_CHAR;
551: x_product_attr_value := FND_API.G_MISS_CHAR;
552: x_product_uom_code := FND_API.G_MISS_CHAR;

Line 549: x_product_attribute := FND_API.G_MISS_CHAR;

545: x_pricing_attribute_context := FND_API.G_MISS_CHAR;
546: x_pricing_attribute_id := FND_API.G_MISS_NUM;
547: x_pricing_attr_value_from := FND_API.G_MISS_CHAR;
548: x_pricing_attr_value_to := FND_API.G_MISS_CHAR;
549: x_product_attribute := FND_API.G_MISS_CHAR;
550: x_product_attribute_context := FND_API.G_MISS_CHAR;
551: x_product_attr_value := FND_API.G_MISS_CHAR;
552: x_product_uom_code := FND_API.G_MISS_CHAR;
553: x_accumulate := FND_API.G_MISS_CHAR;

Line 550: x_product_attribute_context := FND_API.G_MISS_CHAR;

546: x_pricing_attribute_id := FND_API.G_MISS_NUM;
547: x_pricing_attr_value_from := FND_API.G_MISS_CHAR;
548: x_pricing_attr_value_to := FND_API.G_MISS_CHAR;
549: x_product_attribute := FND_API.G_MISS_CHAR;
550: x_product_attribute_context := FND_API.G_MISS_CHAR;
551: x_product_attr_value := FND_API.G_MISS_CHAR;
552: x_product_uom_code := FND_API.G_MISS_CHAR;
553: x_accumulate := FND_API.G_MISS_CHAR;
554: x_excluder := FND_API.G_MISS_CHAR;

Line 551: x_product_attr_value := FND_API.G_MISS_CHAR;

547: x_pricing_attr_value_from := FND_API.G_MISS_CHAR;
548: x_pricing_attr_value_to := FND_API.G_MISS_CHAR;
549: x_product_attribute := FND_API.G_MISS_CHAR;
550: x_product_attribute_context := FND_API.G_MISS_CHAR;
551: x_product_attr_value := FND_API.G_MISS_CHAR;
552: x_product_uom_code := FND_API.G_MISS_CHAR;
553: x_accumulate := FND_API.G_MISS_CHAR;
554: x_excluder := FND_API.G_MISS_CHAR;
555: x_list_line := FND_API.G_MISS_CHAR;

Line 552: x_product_uom_code := FND_API.G_MISS_CHAR;

548: x_pricing_attr_value_to := FND_API.G_MISS_CHAR;
549: x_product_attribute := FND_API.G_MISS_CHAR;
550: x_product_attribute_context := FND_API.G_MISS_CHAR;
551: x_product_attr_value := FND_API.G_MISS_CHAR;
552: x_product_uom_code := FND_API.G_MISS_CHAR;
553: x_accumulate := FND_API.G_MISS_CHAR;
554: x_excluder := FND_API.G_MISS_CHAR;
555: x_list_line := FND_API.G_MISS_CHAR;
556: x_product_uom := FND_API.G_MISS_CHAR;

Line 553: x_accumulate := FND_API.G_MISS_CHAR;

549: x_product_attribute := FND_API.G_MISS_CHAR;
550: x_product_attribute_context := FND_API.G_MISS_CHAR;
551: x_product_attr_value := FND_API.G_MISS_CHAR;
552: x_product_uom_code := FND_API.G_MISS_CHAR;
553: x_accumulate := FND_API.G_MISS_CHAR;
554: x_excluder := FND_API.G_MISS_CHAR;
555: x_list_line := FND_API.G_MISS_CHAR;
556: x_product_uom := FND_API.G_MISS_CHAR;
557: x_product_attribute_datatype := FND_API.G_MISS_CHAR;

Line 554: x_excluder := FND_API.G_MISS_CHAR;

550: x_product_attribute_context := FND_API.G_MISS_CHAR;
551: x_product_attr_value := FND_API.G_MISS_CHAR;
552: x_product_uom_code := FND_API.G_MISS_CHAR;
553: x_accumulate := FND_API.G_MISS_CHAR;
554: x_excluder := FND_API.G_MISS_CHAR;
555: x_list_line := FND_API.G_MISS_CHAR;
556: x_product_uom := FND_API.G_MISS_CHAR;
557: x_product_attribute_datatype := FND_API.G_MISS_CHAR;
558: x_pricing_attribute_datatype := FND_API.G_MISS_CHAR;

Line 555: x_list_line := FND_API.G_MISS_CHAR;

551: x_product_attr_value := FND_API.G_MISS_CHAR;
552: x_product_uom_code := FND_API.G_MISS_CHAR;
553: x_accumulate := FND_API.G_MISS_CHAR;
554: x_excluder := FND_API.G_MISS_CHAR;
555: x_list_line := FND_API.G_MISS_CHAR;
556: x_product_uom := FND_API.G_MISS_CHAR;
557: x_product_attribute_datatype := FND_API.G_MISS_CHAR;
558: x_pricing_attribute_datatype := FND_API.G_MISS_CHAR;
559: x_comparison_operator_code := FND_API.G_MISS_CHAR;

Line 556: x_product_uom := FND_API.G_MISS_CHAR;

552: x_product_uom_code := FND_API.G_MISS_CHAR;
553: x_accumulate := FND_API.G_MISS_CHAR;
554: x_excluder := FND_API.G_MISS_CHAR;
555: x_list_line := FND_API.G_MISS_CHAR;
556: x_product_uom := FND_API.G_MISS_CHAR;
557: x_product_attribute_datatype := FND_API.G_MISS_CHAR;
558: x_pricing_attribute_datatype := FND_API.G_MISS_CHAR;
559: x_comparison_operator_code := FND_API.G_MISS_CHAR;
560:

Line 557: x_product_attribute_datatype := FND_API.G_MISS_CHAR;

553: x_accumulate := FND_API.G_MISS_CHAR;
554: x_excluder := FND_API.G_MISS_CHAR;
555: x_list_line := FND_API.G_MISS_CHAR;
556: x_product_uom := FND_API.G_MISS_CHAR;
557: x_product_attribute_datatype := FND_API.G_MISS_CHAR;
558: x_pricing_attribute_datatype := FND_API.G_MISS_CHAR;
559: x_comparison_operator_code := FND_API.G_MISS_CHAR;
560:
561: -- Load display out parameters if any

Line 558: x_pricing_attribute_datatype := FND_API.G_MISS_CHAR;

554: x_excluder := FND_API.G_MISS_CHAR;
555: x_list_line := FND_API.G_MISS_CHAR;
556: x_product_uom := FND_API.G_MISS_CHAR;
557: x_product_attribute_datatype := FND_API.G_MISS_CHAR;
558: x_pricing_attribute_datatype := FND_API.G_MISS_CHAR;
559: x_comparison_operator_code := FND_API.G_MISS_CHAR;
560:
561: -- Load display out parameters if any
562:

Line 559: x_comparison_operator_code := FND_API.G_MISS_CHAR;

555: x_list_line := FND_API.G_MISS_CHAR;
556: x_product_uom := FND_API.G_MISS_CHAR;
557: x_product_attribute_datatype := FND_API.G_MISS_CHAR;
558: x_pricing_attribute_datatype := FND_API.G_MISS_CHAR;
559: x_comparison_operator_code := FND_API.G_MISS_CHAR;
560:
561: -- Load display out parameters if any
562:
563: l_PRICING_ATTR_val_rec := QP_Pricing_Attr_Util.Get_Values

Line 776: x_return_status := FND_API.G_RET_STS_SUCCESS;

772: );
773:
774: -- Set return status.
775:
776: x_return_status := FND_API.G_RET_STS_SUCCESS;
777:
778: -- Get message count and data
779:
780: OE_MSG_PUB.Count_And_Get

Line 789: WHEN FND_API.G_EXC_ERROR THEN

785: oe_debug_pub.add('END Change_Attribute in QPXFPRAB');
786:
787: EXCEPTION
788:
789: WHEN FND_API.G_EXC_ERROR THEN
790:
791: x_return_status := FND_API.G_RET_STS_ERROR;
792:
793: -- Get message count and data

Line 791: x_return_status := FND_API.G_RET_STS_ERROR;

787: EXCEPTION
788:
789: WHEN FND_API.G_EXC_ERROR THEN
790:
791: x_return_status := FND_API.G_RET_STS_ERROR;
792:
793: -- Get message count and data
794:
795: OE_MSG_PUB.Count_And_Get

Line 800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

796: ( p_count => x_msg_count
797: , p_data => x_msg_data
798: );
799:
800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
801:
802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
803:
804: -- Get message count and data

Line 802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

798: );
799:
800: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
801:
802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
803:
804: -- Get message count and data
805:
806: OE_MSG_PUB.Count_And_Get

Line 813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

809: );
810:
811: WHEN OTHERS THEN
812:
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
814:
815: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
816: THEN
817: OE_MSG_PUB.Add_Exc_Msg

Line 893: IF FND_API.To_Boolean(l_PRICING_ATTR_rec.db_flag) THEN

889: );
890:
891: -- Set Operation.
892:
893: IF FND_API.To_Boolean(l_PRICING_ATTR_rec.db_flag) THEN
894: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
895: ELSE
896: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_CREATE;
897: END IF;

Line 908: , p_init_msg_list => FND_API.G_TRUE

904: -- Call QP_Modifiers_PVT.Process_MODIFIERS
905:
906: QP_Modifiers_PVT.Process_MODIFIERS
907: ( p_api_version_number => 1.0
908: , p_init_msg_list => FND_API.G_TRUE
909: , x_return_status => l_return_status
910: , x_msg_count => x_msg_count
911: , x_msg_data => x_msg_data
912: , p_control_rec => l_control_rec

Line 921: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

917: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
918: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
919: );
920:
921: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
923: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
924: RAISE FND_API.G_EXC_ERROR;
925: END IF;

Line 922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

918: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
919: );
920:
921: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
923: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
924: RAISE FND_API.G_EXC_ERROR;
925: END IF;
926:

Line 923: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

919: );
920:
921: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
923: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
924: RAISE FND_API.G_EXC_ERROR;
925: END IF;
926:
927:

Line 924: RAISE FND_API.G_EXC_ERROR;

920:
921: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
923: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
924: RAISE FND_API.G_EXC_ERROR;
925: END IF;
926:
927:
928: -- Load OUT parameters.

Line 949: x_return_status := FND_API.G_RET_STS_SUCCESS;

945:
946:
947: -- Set return status.
948:
949: x_return_status := FND_API.G_RET_STS_SUCCESS;
950:
951: -- Get message count and data
952:
953: OE_MSG_PUB.Count_And_Get

Line 962: WHEN FND_API.G_EXC_ERROR THEN

958: oe_debug_pub.add('END Validate_And_Write in QPXFPRAB');
959:
960: EXCEPTION
961:
962: WHEN FND_API.G_EXC_ERROR THEN
963:
964: x_return_status := FND_API.G_RET_STS_ERROR;
965:
966: -- Get message count and data

Line 964: x_return_status := FND_API.G_RET_STS_ERROR;

960: EXCEPTION
961:
962: WHEN FND_API.G_EXC_ERROR THEN
963:
964: x_return_status := FND_API.G_RET_STS_ERROR;
965:
966: -- Get message count and data
967:
968: OE_MSG_PUB.Count_And_Get

Line 973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

969: ( p_count => x_msg_count
970: , p_data => x_msg_data
971: );
972:
973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
974:
975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
976:
977: -- Get message count and data

Line 975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

971: );
972:
973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
974:
975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
976:
977: -- Get message count and data
978:
979: OE_MSG_PUB.Count_And_Get

Line 986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

982: );
983:
984: WHEN OTHERS THEN
985:
986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
987:
988: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
989: THEN
990: OE_MSG_PUB.Add_Exc_Msg

Line 1069: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1065: p_requesting_entity_id => l_PRICING_ATTR_rec.list_line_id,
1066: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
1067: x_return_status => l_return_status);
1068:
1069: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1070:
1071: oe_debug_pub.add('failed in logging a delayed request in delete_row ');
1072:
1073: RAISE FND_API.G_EXC_ERROR;

Line 1073: RAISE FND_API.G_EXC_ERROR;

1069: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1070:
1071: oe_debug_pub.add('failed in logging a delayed request in delete_row ');
1072:
1073: RAISE FND_API.G_EXC_ERROR;
1074:
1075: END IF;
1076:
1077:

Line 1080: , p_init_msg_list => FND_API.G_TRUE

1076:
1077:
1078: QP_Modifiers_PVT.Process_MODIFIERS
1079: ( p_api_version_number => 1.0
1080: , p_init_msg_list => FND_API.G_TRUE
1081: , x_return_status => l_return_status
1082: , x_msg_count => x_msg_count
1083: , x_msg_data => x_msg_data
1084: , p_control_rec => l_control_rec

Line 1092: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1088: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1089: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1090: );
1091:
1092: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1094: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1095: RAISE FND_API.G_EXC_ERROR;
1096: END IF;

Line 1093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1089: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1090: );
1091:
1092: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1094: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1095: RAISE FND_API.G_EXC_ERROR;
1096: END IF;
1097:

Line 1094: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1090: );
1091:
1092: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1094: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1095: RAISE FND_API.G_EXC_ERROR;
1096: END IF;
1097:
1098:

Line 1095: RAISE FND_API.G_EXC_ERROR;

1091:
1092: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1093: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1094: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1095: RAISE FND_API.G_EXC_ERROR;
1096: END IF;
1097:
1098:
1099: -- Clear PRICING_ATTR record cache

Line 1105: x_return_status := FND_API.G_RET_STS_SUCCESS;

1101: Clear_PRICING_ATTR;
1102:
1103: -- Set return status.
1104:
1105: x_return_status := FND_API.G_RET_STS_SUCCESS;
1106:
1107: -- Get message count and data
1108:
1109: OE_MSG_PUB.Count_And_Get

Line 1118: WHEN FND_API.G_EXC_ERROR THEN

1114: oe_debug_pub.add('END Delete_Row in QPXFPRAB');
1115:
1116: EXCEPTION
1117:
1118: WHEN FND_API.G_EXC_ERROR THEN
1119:
1120: x_return_status := FND_API.G_RET_STS_ERROR;
1121:
1122: -- Get message count and data

Line 1120: x_return_status := FND_API.G_RET_STS_ERROR;

1116: EXCEPTION
1117:
1118: WHEN FND_API.G_EXC_ERROR THEN
1119:
1120: x_return_status := FND_API.G_RET_STS_ERROR;
1121:
1122: -- Get message count and data
1123:
1124: OE_MSG_PUB.Count_And_Get

Line 1129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1125: ( p_count => x_msg_count
1126: , p_data => x_msg_data
1127: );
1128:
1129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1130:
1131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1132:
1133: -- Get message count and data

Line 1131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1127: );
1128:
1129: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1130:
1131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1132:
1133: -- Get message count and data
1134:
1135: OE_MSG_PUB.Count_And_Get

Line 1142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1138: );
1139:
1140: WHEN OTHERS THEN
1141:
1142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1143:
1144: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1145: THEN
1146: OE_MSG_PUB.Add_Exc_Msg

Line 1203: , p_init_msg_list => FND_API.G_TRUE

1199: -- Call QP_Modifiers_PVT.Process_MODIFIERS
1200:
1201: QP_Modifiers_PVT.Process_MODIFIERS
1202: ( p_api_version_number => 1.0
1203: , p_init_msg_list => FND_API.G_TRUE
1204: , x_return_status => l_return_status
1205: , x_msg_count => x_msg_count
1206: , x_msg_data => x_msg_data
1207: , p_control_rec => l_control_rec

Line 1214: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1210: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1211: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1212: );
1213:
1214: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1216: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1217: RAISE FND_API.G_EXC_ERROR;
1218: END IF;

Line 1215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1211: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1212: );
1213:
1214: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1216: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1217: RAISE FND_API.G_EXC_ERROR;
1218: END IF;
1219:

Line 1216: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1212: );
1213:
1214: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1216: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1217: RAISE FND_API.G_EXC_ERROR;
1218: END IF;
1219:
1220:

Line 1217: RAISE FND_API.G_EXC_ERROR;

1213:
1214: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1216: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1217: RAISE FND_API.G_EXC_ERROR;
1218: END IF;
1219:
1220:
1221: -- Set return status.

Line 1223: x_return_status := FND_API.G_RET_STS_SUCCESS;

1219:
1220:
1221: -- Set return status.
1222:
1223: x_return_status := FND_API.G_RET_STS_SUCCESS;
1224:
1225: -- Get message count and data
1226:
1227: OE_MSG_PUB.Count_And_Get

Line 1236: WHEN FND_API.G_EXC_ERROR THEN

1232: oe_debug_pub.add('END Process_Entity in QPXFPRAB');
1233:
1234: EXCEPTION
1235:
1236: WHEN FND_API.G_EXC_ERROR THEN
1237:
1238: x_return_status := FND_API.G_RET_STS_ERROR;
1239:
1240: -- Get message count and data

Line 1238: x_return_status := FND_API.G_RET_STS_ERROR;

1234: EXCEPTION
1235:
1236: WHEN FND_API.G_EXC_ERROR THEN
1237:
1238: x_return_status := FND_API.G_RET_STS_ERROR;
1239:
1240: -- Get message count and data
1241:
1242: OE_MSG_PUB.Count_And_Get

Line 1247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1243: ( p_count => x_msg_count
1244: , p_data => x_msg_data
1245: );
1246:
1247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1248:
1249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1250:
1251: -- Get message count and data

Line 1249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1245: );
1246:
1247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1248:
1249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1250:
1251: -- Get message count and data
1252:
1253: OE_MSG_PUB.Count_And_Get

Line 1260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1256: );
1257:
1258: WHEN OTHERS THEN
1259:
1260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1261:
1262: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1263: THEN
1264: OE_MSG_PUB.Add_Exc_Msg

Line 1397: , p_init_msg_list => FND_API.G_TRUE

1393: -- Call QP_Modifiers_PVT.Lock_MODIFIERS
1394:
1395: QP_Modifiers_PVT.Lock_MODIFIERS
1396: ( p_api_version_number => 1.0
1397: , p_init_msg_list => FND_API.G_TRUE
1398: , x_return_status => l_return_status
1399: , x_msg_count => x_msg_count
1400: , x_msg_data => x_msg_data
1401: , p_PRICING_ATTR_tbl => l_PRICING_ATTR_tbl

Line 1408: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1404: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1405: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1406: );
1407:
1408: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1409:
1410: -- Set DB flag and write record to cache.
1411:
1412: l_x_PRICING_ATTR_rec.db_flag := FND_API.G_TRUE;

Line 1412: l_x_PRICING_ATTR_rec.db_flag := FND_API.G_TRUE;

1408: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1409:
1410: -- Set DB flag and write record to cache.
1411:
1412: l_x_PRICING_ATTR_rec.db_flag := FND_API.G_TRUE;
1413:
1414: Write_PRICING_ATTR
1415: ( p_PRICING_ATTR_rec => l_x_PRICING_ATTR_rec
1416: , p_db_record => TRUE

Line 1447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1443: , 'Lock_Row'
1444: );
1445: END IF;
1446:
1447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1448:
1449: -- Get message count and data
1450:
1451: OE_MSG_PUB.Count_And_Get

Line 1501: g_PRICING_ATTR_rec.db_flag := FND_API.G_TRUE;

1497: g_PRICING_ATTR_rec := QP_Pricing_Attr_Util.Query_Row
1498: ( p_pricing_attribute_id => p_pricing_attribute_id
1499: );
1500:
1501: g_PRICING_ATTR_rec.db_flag := FND_API.G_TRUE;
1502:
1503: -- Load DB record
1504:
1505: g_db_PRICING_ATTR_rec := g_PRICING_ATTR_rec;

Line 2768: x_return_status := FND_API.G_RET_STS_SUCCESS;

2764: IS
2765: l_return_status Varchar2(30);
2766: BEGIN
2767: OE_MSG_PUB.initialize;
2768: x_return_status := FND_API.G_RET_STS_SUCCESS;
2769: QP_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
2770: p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
2771: ,p_entity_id => p_list_line_id
2772: ,x_return_status => l_return_status);

Line 2796: x_return_status := FND_API.G_RET_STS_ERROR;

2792: OE_MSG_PUB.Count_And_Get
2793: ( p_count => x_msg_count
2794: , p_data => x_msg_data
2795: );
2796: x_return_status := FND_API.G_RET_STS_ERROR;
2797:
2798: END Clear_Record;
2799:
2800: