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

Line 156: , p_init_msg_list => FND_API.G_TRUE

152: -- Call QP_LIST_HEADERS_PVT.Process_PRICE_LIST
153:
154: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
155: ( p_api_version_number => 1.0
156: , p_init_msg_list => FND_API.G_TRUE
157: , x_return_status => l_return_status
158: , x_msg_count => x_msg_count
159: , x_msg_data => x_msg_data
160: , p_control_rec => l_control_rec

Line 174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

170: oe_debug_pub.add('return status is : ' || l_return_status);
171:
172: oe_debug_pub.add('ren: msg data 1 is : ' || x_msg_data);
173:
174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
177: RAISE FND_API.G_EXC_ERROR;
178: END IF;

Line 175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

171:
172: oe_debug_pub.add('ren: msg data 1 is : ' || x_msg_data);
173:
174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
177: RAISE FND_API.G_EXC_ERROR;
178: END IF;
179:

Line 176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

172: oe_debug_pub.add('ren: msg data 1 is : ' || x_msg_data);
173:
174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
177: RAISE FND_API.G_EXC_ERROR;
178: END IF;
179:
180:

Line 177: RAISE FND_API.G_EXC_ERROR;

173:
174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
177: RAISE FND_API.G_EXC_ERROR;
178: END IF;
179:
180:
181: -- Unload out tbl

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

236:
237: -- Write to cache.
238: -- Set db_flag to False before writing to cache
239:
240: l_x_PRICING_ATTR_rec.db_flag := FND_API.G_FALSE;
241:
242: oe_debug_pub.add('Ren: before write prc attr 1');
243: oe_debug_pub.add('Ren: msg data 1 is :' || x_msg_data);
244:

Line 253: x_return_status := FND_API.G_RET_STS_SUCCESS;

249: oe_debug_pub.add('Ren: msg data 2 is :' || x_msg_data);
250:
251: -- Set return status.
252:
253: x_return_status := FND_API.G_RET_STS_SUCCESS;
254:
255: -- Get message count and data
256:
257: oe_msg_pub.Count_And_Get

Line 269: WHEN FND_API.G_EXC_ERROR THEN

265:
266:
267: EXCEPTION
268:
269: WHEN FND_API.G_EXC_ERROR THEN
270:
271: x_return_status := FND_API.G_RET_STS_ERROR;
272:
273: -- Get message count and data

Line 271: x_return_status := FND_API.G_RET_STS_ERROR;

267: EXCEPTION
268:
269: WHEN FND_API.G_EXC_ERROR THEN
270:
271: x_return_status := FND_API.G_RET_STS_ERROR;
272:
273: -- Get message count and data
274:
275: oe_msg_pub.Count_And_Get

Line 280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

276: ( p_count => x_msg_count
277: , p_data => x_msg_data
278: );
279:
280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
281:
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
283:
284: -- Get message count and data

Line 282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

278: );
279:
280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
281:
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
283:
284: -- Get message count and data
285:
286: oe_msg_pub.Count_And_Get

Line 293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

289: );
290:
291: WHEN OTHERS THEN
292:
293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
294:
295: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
296: THEN
297: oe_msg_pub.Add_Exc_Msg

Line 500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

496: , 'Unrecognized attribute'
497: );
498: END IF;
499:
500: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
501:
502: END IF;
503:
504: -- Set Operation.

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

502: END IF;
503:
504: -- Set Operation.
505:
506: IF FND_API.To_Boolean(l_PRICING_ATTR_rec.db_flag) THEN
507: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
508: ELSE
509: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_CREATE;
510: END IF;

Line 521: , p_init_msg_list => FND_API.G_TRUE

517: -- Call QP_LIST_HEADERS_PVT.Process_PRICE_LIST
518:
519: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
520: ( p_api_version_number => 1.0
521: , p_init_msg_list => FND_API.G_TRUE
522: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
523: , x_return_status => l_return_status
524: , x_msg_count => x_msg_count
525: , x_msg_data => x_msg_data

Line 522: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

518:
519: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
520: ( p_api_version_number => 1.0
521: , p_init_msg_list => FND_API.G_TRUE
522: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
523: , x_return_status => l_return_status
524: , x_msg_count => x_msg_count
525: , x_msg_data => x_msg_data
526: , p_control_rec => l_control_rec

Line 535: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

531: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
532: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
533: );
534:
535: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
538: RAISE FND_API.G_EXC_ERROR;
539: END IF;

Line 536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

532: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
533: );
534:
535: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
538: RAISE FND_API.G_EXC_ERROR;
539: END IF;
540:

Line 537: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

533: );
534:
535: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
538: RAISE FND_API.G_EXC_ERROR;
539: END IF;
540:
541:

Line 538: RAISE FND_API.G_EXC_ERROR;

534:
535: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
536: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
537: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
538: RAISE FND_API.G_EXC_ERROR;
539: END IF;
540:
541:
542: -- Unload out tbl

Line 548: x_accumulate_flag := FND_API.G_MISS_CHAR;

544: l_x_PRICING_ATTR_rec := l_x_PRICING_ATTR_tbl(1);
545:
546: -- Init OUT parameters to missing.
547:
548: x_accumulate_flag := FND_API.G_MISS_CHAR;
549: x_attribute1 := FND_API.G_MISS_CHAR;
550: x_attribute10 := FND_API.G_MISS_CHAR;
551: x_attribute11 := FND_API.G_MISS_CHAR;
552: x_attribute12 := FND_API.G_MISS_CHAR;

Line 549: x_attribute1 := FND_API.G_MISS_CHAR;

545:
546: -- Init OUT parameters to missing.
547:
548: x_accumulate_flag := FND_API.G_MISS_CHAR;
549: x_attribute1 := FND_API.G_MISS_CHAR;
550: x_attribute10 := FND_API.G_MISS_CHAR;
551: x_attribute11 := FND_API.G_MISS_CHAR;
552: x_attribute12 := FND_API.G_MISS_CHAR;
553: x_attribute13 := FND_API.G_MISS_CHAR;

Line 550: x_attribute10 := FND_API.G_MISS_CHAR;

546: -- Init OUT parameters to missing.
547:
548: x_accumulate_flag := FND_API.G_MISS_CHAR;
549: x_attribute1 := FND_API.G_MISS_CHAR;
550: x_attribute10 := FND_API.G_MISS_CHAR;
551: x_attribute11 := FND_API.G_MISS_CHAR;
552: x_attribute12 := FND_API.G_MISS_CHAR;
553: x_attribute13 := FND_API.G_MISS_CHAR;
554: x_attribute14 := FND_API.G_MISS_CHAR;

Line 551: x_attribute11 := FND_API.G_MISS_CHAR;

547:
548: x_accumulate_flag := FND_API.G_MISS_CHAR;
549: x_attribute1 := FND_API.G_MISS_CHAR;
550: x_attribute10 := FND_API.G_MISS_CHAR;
551: x_attribute11 := FND_API.G_MISS_CHAR;
552: x_attribute12 := FND_API.G_MISS_CHAR;
553: x_attribute13 := FND_API.G_MISS_CHAR;
554: x_attribute14 := FND_API.G_MISS_CHAR;
555: x_attribute15 := FND_API.G_MISS_CHAR;

Line 552: x_attribute12 := FND_API.G_MISS_CHAR;

548: x_accumulate_flag := FND_API.G_MISS_CHAR;
549: x_attribute1 := FND_API.G_MISS_CHAR;
550: x_attribute10 := FND_API.G_MISS_CHAR;
551: x_attribute11 := FND_API.G_MISS_CHAR;
552: x_attribute12 := FND_API.G_MISS_CHAR;
553: x_attribute13 := FND_API.G_MISS_CHAR;
554: x_attribute14 := FND_API.G_MISS_CHAR;
555: x_attribute15 := FND_API.G_MISS_CHAR;
556: x_attribute2 := FND_API.G_MISS_CHAR;

Line 553: x_attribute13 := FND_API.G_MISS_CHAR;

549: x_attribute1 := FND_API.G_MISS_CHAR;
550: x_attribute10 := FND_API.G_MISS_CHAR;
551: x_attribute11 := FND_API.G_MISS_CHAR;
552: x_attribute12 := FND_API.G_MISS_CHAR;
553: x_attribute13 := FND_API.G_MISS_CHAR;
554: x_attribute14 := FND_API.G_MISS_CHAR;
555: x_attribute15 := FND_API.G_MISS_CHAR;
556: x_attribute2 := FND_API.G_MISS_CHAR;
557: x_attribute3 := FND_API.G_MISS_CHAR;

Line 554: x_attribute14 := FND_API.G_MISS_CHAR;

550: x_attribute10 := FND_API.G_MISS_CHAR;
551: x_attribute11 := FND_API.G_MISS_CHAR;
552: x_attribute12 := FND_API.G_MISS_CHAR;
553: x_attribute13 := FND_API.G_MISS_CHAR;
554: x_attribute14 := FND_API.G_MISS_CHAR;
555: x_attribute15 := FND_API.G_MISS_CHAR;
556: x_attribute2 := FND_API.G_MISS_CHAR;
557: x_attribute3 := FND_API.G_MISS_CHAR;
558: x_attribute4 := FND_API.G_MISS_CHAR;

Line 555: x_attribute15 := FND_API.G_MISS_CHAR;

551: x_attribute11 := FND_API.G_MISS_CHAR;
552: x_attribute12 := FND_API.G_MISS_CHAR;
553: x_attribute13 := FND_API.G_MISS_CHAR;
554: x_attribute14 := FND_API.G_MISS_CHAR;
555: x_attribute15 := FND_API.G_MISS_CHAR;
556: x_attribute2 := FND_API.G_MISS_CHAR;
557: x_attribute3 := FND_API.G_MISS_CHAR;
558: x_attribute4 := FND_API.G_MISS_CHAR;
559: x_attribute5 := FND_API.G_MISS_CHAR;

Line 556: x_attribute2 := FND_API.G_MISS_CHAR;

552: x_attribute12 := FND_API.G_MISS_CHAR;
553: x_attribute13 := FND_API.G_MISS_CHAR;
554: x_attribute14 := FND_API.G_MISS_CHAR;
555: x_attribute15 := FND_API.G_MISS_CHAR;
556: x_attribute2 := FND_API.G_MISS_CHAR;
557: x_attribute3 := FND_API.G_MISS_CHAR;
558: x_attribute4 := FND_API.G_MISS_CHAR;
559: x_attribute5 := FND_API.G_MISS_CHAR;
560: x_attribute6 := FND_API.G_MISS_CHAR;

Line 557: x_attribute3 := FND_API.G_MISS_CHAR;

553: x_attribute13 := FND_API.G_MISS_CHAR;
554: x_attribute14 := FND_API.G_MISS_CHAR;
555: x_attribute15 := FND_API.G_MISS_CHAR;
556: x_attribute2 := FND_API.G_MISS_CHAR;
557: x_attribute3 := FND_API.G_MISS_CHAR;
558: x_attribute4 := FND_API.G_MISS_CHAR;
559: x_attribute5 := FND_API.G_MISS_CHAR;
560: x_attribute6 := FND_API.G_MISS_CHAR;
561: x_attribute7 := FND_API.G_MISS_CHAR;

Line 558: x_attribute4 := FND_API.G_MISS_CHAR;

554: x_attribute14 := FND_API.G_MISS_CHAR;
555: x_attribute15 := FND_API.G_MISS_CHAR;
556: x_attribute2 := FND_API.G_MISS_CHAR;
557: x_attribute3 := FND_API.G_MISS_CHAR;
558: x_attribute4 := FND_API.G_MISS_CHAR;
559: x_attribute5 := FND_API.G_MISS_CHAR;
560: x_attribute6 := FND_API.G_MISS_CHAR;
561: x_attribute7 := FND_API.G_MISS_CHAR;
562: x_attribute8 := FND_API.G_MISS_CHAR;

Line 559: x_attribute5 := FND_API.G_MISS_CHAR;

555: x_attribute15 := FND_API.G_MISS_CHAR;
556: x_attribute2 := FND_API.G_MISS_CHAR;
557: x_attribute3 := FND_API.G_MISS_CHAR;
558: x_attribute4 := FND_API.G_MISS_CHAR;
559: x_attribute5 := FND_API.G_MISS_CHAR;
560: x_attribute6 := FND_API.G_MISS_CHAR;
561: x_attribute7 := FND_API.G_MISS_CHAR;
562: x_attribute8 := FND_API.G_MISS_CHAR;
563: x_attribute9 := FND_API.G_MISS_CHAR;

Line 560: x_attribute6 := FND_API.G_MISS_CHAR;

556: x_attribute2 := FND_API.G_MISS_CHAR;
557: x_attribute3 := FND_API.G_MISS_CHAR;
558: x_attribute4 := FND_API.G_MISS_CHAR;
559: x_attribute5 := FND_API.G_MISS_CHAR;
560: x_attribute6 := FND_API.G_MISS_CHAR;
561: x_attribute7 := FND_API.G_MISS_CHAR;
562: x_attribute8 := FND_API.G_MISS_CHAR;
563: x_attribute9 := FND_API.G_MISS_CHAR;
564: x_attribute_grouping_no := FND_API.G_MISS_NUM;

Line 561: x_attribute7 := FND_API.G_MISS_CHAR;

557: x_attribute3 := FND_API.G_MISS_CHAR;
558: x_attribute4 := FND_API.G_MISS_CHAR;
559: x_attribute5 := FND_API.G_MISS_CHAR;
560: x_attribute6 := FND_API.G_MISS_CHAR;
561: x_attribute7 := FND_API.G_MISS_CHAR;
562: x_attribute8 := FND_API.G_MISS_CHAR;
563: x_attribute9 := FND_API.G_MISS_CHAR;
564: x_attribute_grouping_no := FND_API.G_MISS_NUM;
565: x_context := FND_API.G_MISS_CHAR;

Line 562: x_attribute8 := FND_API.G_MISS_CHAR;

558: x_attribute4 := FND_API.G_MISS_CHAR;
559: x_attribute5 := FND_API.G_MISS_CHAR;
560: x_attribute6 := FND_API.G_MISS_CHAR;
561: x_attribute7 := FND_API.G_MISS_CHAR;
562: x_attribute8 := FND_API.G_MISS_CHAR;
563: x_attribute9 := FND_API.G_MISS_CHAR;
564: x_attribute_grouping_no := FND_API.G_MISS_NUM;
565: x_context := FND_API.G_MISS_CHAR;
566: x_excluder_flag := FND_API.G_MISS_CHAR;

Line 563: x_attribute9 := FND_API.G_MISS_CHAR;

559: x_attribute5 := FND_API.G_MISS_CHAR;
560: x_attribute6 := FND_API.G_MISS_CHAR;
561: x_attribute7 := FND_API.G_MISS_CHAR;
562: x_attribute8 := FND_API.G_MISS_CHAR;
563: x_attribute9 := FND_API.G_MISS_CHAR;
564: x_attribute_grouping_no := FND_API.G_MISS_NUM;
565: x_context := FND_API.G_MISS_CHAR;
566: x_excluder_flag := FND_API.G_MISS_CHAR;
567: x_list_line_id := FND_API.G_MISS_NUM;

Line 564: x_attribute_grouping_no := FND_API.G_MISS_NUM;

560: x_attribute6 := FND_API.G_MISS_CHAR;
561: x_attribute7 := FND_API.G_MISS_CHAR;
562: x_attribute8 := FND_API.G_MISS_CHAR;
563: x_attribute9 := FND_API.G_MISS_CHAR;
564: x_attribute_grouping_no := FND_API.G_MISS_NUM;
565: x_context := FND_API.G_MISS_CHAR;
566: x_excluder_flag := FND_API.G_MISS_CHAR;
567: x_list_line_id := FND_API.G_MISS_NUM;
568: x_pricing_attribute := FND_API.G_MISS_CHAR;

Line 565: x_context := FND_API.G_MISS_CHAR;

561: x_attribute7 := FND_API.G_MISS_CHAR;
562: x_attribute8 := FND_API.G_MISS_CHAR;
563: x_attribute9 := FND_API.G_MISS_CHAR;
564: x_attribute_grouping_no := FND_API.G_MISS_NUM;
565: x_context := FND_API.G_MISS_CHAR;
566: x_excluder_flag := FND_API.G_MISS_CHAR;
567: x_list_line_id := FND_API.G_MISS_NUM;
568: x_pricing_attribute := FND_API.G_MISS_CHAR;
569: x_pricing_attribute_context := FND_API.G_MISS_CHAR;

Line 566: x_excluder_flag := FND_API.G_MISS_CHAR;

562: x_attribute8 := FND_API.G_MISS_CHAR;
563: x_attribute9 := FND_API.G_MISS_CHAR;
564: x_attribute_grouping_no := FND_API.G_MISS_NUM;
565: x_context := FND_API.G_MISS_CHAR;
566: x_excluder_flag := FND_API.G_MISS_CHAR;
567: x_list_line_id := FND_API.G_MISS_NUM;
568: x_pricing_attribute := FND_API.G_MISS_CHAR;
569: x_pricing_attribute_context := FND_API.G_MISS_CHAR;
570: x_pricing_attribute_id := FND_API.G_MISS_NUM;

Line 567: x_list_line_id := FND_API.G_MISS_NUM;

563: x_attribute9 := FND_API.G_MISS_CHAR;
564: x_attribute_grouping_no := FND_API.G_MISS_NUM;
565: x_context := FND_API.G_MISS_CHAR;
566: x_excluder_flag := FND_API.G_MISS_CHAR;
567: x_list_line_id := FND_API.G_MISS_NUM;
568: x_pricing_attribute := FND_API.G_MISS_CHAR;
569: x_pricing_attribute_context := FND_API.G_MISS_CHAR;
570: x_pricing_attribute_id := FND_API.G_MISS_NUM;
571: x_pricing_attr_value_from := FND_API.G_MISS_CHAR;

Line 568: x_pricing_attribute := FND_API.G_MISS_CHAR;

564: x_attribute_grouping_no := FND_API.G_MISS_NUM;
565: x_context := FND_API.G_MISS_CHAR;
566: x_excluder_flag := FND_API.G_MISS_CHAR;
567: x_list_line_id := FND_API.G_MISS_NUM;
568: x_pricing_attribute := FND_API.G_MISS_CHAR;
569: x_pricing_attribute_context := FND_API.G_MISS_CHAR;
570: x_pricing_attribute_id := FND_API.G_MISS_NUM;
571: x_pricing_attr_value_from := FND_API.G_MISS_CHAR;
572: x_pricing_attr_value_to := FND_API.G_MISS_CHAR;

Line 569: x_pricing_attribute_context := FND_API.G_MISS_CHAR;

565: x_context := FND_API.G_MISS_CHAR;
566: x_excluder_flag := FND_API.G_MISS_CHAR;
567: x_list_line_id := FND_API.G_MISS_NUM;
568: x_pricing_attribute := FND_API.G_MISS_CHAR;
569: x_pricing_attribute_context := FND_API.G_MISS_CHAR;
570: x_pricing_attribute_id := FND_API.G_MISS_NUM;
571: x_pricing_attr_value_from := FND_API.G_MISS_CHAR;
572: x_pricing_attr_value_to := FND_API.G_MISS_CHAR;
573: x_product_attribute := FND_API.G_MISS_CHAR;

Line 570: x_pricing_attribute_id := FND_API.G_MISS_NUM;

566: x_excluder_flag := FND_API.G_MISS_CHAR;
567: x_list_line_id := FND_API.G_MISS_NUM;
568: x_pricing_attribute := FND_API.G_MISS_CHAR;
569: x_pricing_attribute_context := FND_API.G_MISS_CHAR;
570: x_pricing_attribute_id := FND_API.G_MISS_NUM;
571: x_pricing_attr_value_from := FND_API.G_MISS_CHAR;
572: x_pricing_attr_value_to := FND_API.G_MISS_CHAR;
573: x_product_attribute := FND_API.G_MISS_CHAR;
574: x_product_attribute_context := FND_API.G_MISS_CHAR;

Line 571: x_pricing_attr_value_from := FND_API.G_MISS_CHAR;

567: x_list_line_id := FND_API.G_MISS_NUM;
568: x_pricing_attribute := FND_API.G_MISS_CHAR;
569: x_pricing_attribute_context := FND_API.G_MISS_CHAR;
570: x_pricing_attribute_id := FND_API.G_MISS_NUM;
571: x_pricing_attr_value_from := FND_API.G_MISS_CHAR;
572: x_pricing_attr_value_to := FND_API.G_MISS_CHAR;
573: x_product_attribute := FND_API.G_MISS_CHAR;
574: x_product_attribute_context := FND_API.G_MISS_CHAR;
575: x_product_attr_value := FND_API.G_MISS_CHAR;

Line 572: x_pricing_attr_value_to := FND_API.G_MISS_CHAR;

568: x_pricing_attribute := FND_API.G_MISS_CHAR;
569: x_pricing_attribute_context := FND_API.G_MISS_CHAR;
570: x_pricing_attribute_id := FND_API.G_MISS_NUM;
571: x_pricing_attr_value_from := FND_API.G_MISS_CHAR;
572: x_pricing_attr_value_to := FND_API.G_MISS_CHAR;
573: x_product_attribute := FND_API.G_MISS_CHAR;
574: x_product_attribute_context := FND_API.G_MISS_CHAR;
575: x_product_attr_value := FND_API.G_MISS_CHAR;
576: x_product_uom_code := FND_API.G_MISS_CHAR;

Line 573: x_product_attribute := FND_API.G_MISS_CHAR;

569: x_pricing_attribute_context := FND_API.G_MISS_CHAR;
570: x_pricing_attribute_id := FND_API.G_MISS_NUM;
571: x_pricing_attr_value_from := FND_API.G_MISS_CHAR;
572: x_pricing_attr_value_to := FND_API.G_MISS_CHAR;
573: x_product_attribute := FND_API.G_MISS_CHAR;
574: x_product_attribute_context := FND_API.G_MISS_CHAR;
575: x_product_attr_value := FND_API.G_MISS_CHAR;
576: x_product_uom_code := FND_API.G_MISS_CHAR;
577: x_accumulate := FND_API.G_MISS_CHAR;

Line 574: x_product_attribute_context := FND_API.G_MISS_CHAR;

570: x_pricing_attribute_id := FND_API.G_MISS_NUM;
571: x_pricing_attr_value_from := FND_API.G_MISS_CHAR;
572: x_pricing_attr_value_to := FND_API.G_MISS_CHAR;
573: x_product_attribute := FND_API.G_MISS_CHAR;
574: x_product_attribute_context := FND_API.G_MISS_CHAR;
575: x_product_attr_value := FND_API.G_MISS_CHAR;
576: x_product_uom_code := FND_API.G_MISS_CHAR;
577: x_accumulate := FND_API.G_MISS_CHAR;
578: x_excluder := FND_API.G_MISS_CHAR;

Line 575: x_product_attr_value := FND_API.G_MISS_CHAR;

571: x_pricing_attr_value_from := FND_API.G_MISS_CHAR;
572: x_pricing_attr_value_to := FND_API.G_MISS_CHAR;
573: x_product_attribute := FND_API.G_MISS_CHAR;
574: x_product_attribute_context := FND_API.G_MISS_CHAR;
575: x_product_attr_value := FND_API.G_MISS_CHAR;
576: x_product_uom_code := FND_API.G_MISS_CHAR;
577: x_accumulate := FND_API.G_MISS_CHAR;
578: x_excluder := FND_API.G_MISS_CHAR;
579: x_list_line := FND_API.G_MISS_CHAR;

Line 576: x_product_uom_code := FND_API.G_MISS_CHAR;

572: x_pricing_attr_value_to := FND_API.G_MISS_CHAR;
573: x_product_attribute := FND_API.G_MISS_CHAR;
574: x_product_attribute_context := FND_API.G_MISS_CHAR;
575: x_product_attr_value := FND_API.G_MISS_CHAR;
576: x_product_uom_code := FND_API.G_MISS_CHAR;
577: x_accumulate := FND_API.G_MISS_CHAR;
578: x_excluder := FND_API.G_MISS_CHAR;
579: x_list_line := FND_API.G_MISS_CHAR;
580: x_product_uom := FND_API.G_MISS_CHAR;

Line 577: x_accumulate := FND_API.G_MISS_CHAR;

573: x_product_attribute := FND_API.G_MISS_CHAR;
574: x_product_attribute_context := FND_API.G_MISS_CHAR;
575: x_product_attr_value := FND_API.G_MISS_CHAR;
576: x_product_uom_code := FND_API.G_MISS_CHAR;
577: x_accumulate := FND_API.G_MISS_CHAR;
578: x_excluder := FND_API.G_MISS_CHAR;
579: x_list_line := FND_API.G_MISS_CHAR;
580: x_product_uom := FND_API.G_MISS_CHAR;
581: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;

Line 578: x_excluder := FND_API.G_MISS_CHAR;

574: x_product_attribute_context := FND_API.G_MISS_CHAR;
575: x_product_attr_value := FND_API.G_MISS_CHAR;
576: x_product_uom_code := FND_API.G_MISS_CHAR;
577: x_accumulate := FND_API.G_MISS_CHAR;
578: x_excluder := FND_API.G_MISS_CHAR;
579: x_list_line := FND_API.G_MISS_CHAR;
580: x_product_uom := FND_API.G_MISS_CHAR;
581: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
582: x_comparison_operator_code := FND_API.G_MISS_CHAR;

Line 579: x_list_line := FND_API.G_MISS_CHAR;

575: x_product_attr_value := FND_API.G_MISS_CHAR;
576: x_product_uom_code := FND_API.G_MISS_CHAR;
577: x_accumulate := FND_API.G_MISS_CHAR;
578: x_excluder := FND_API.G_MISS_CHAR;
579: x_list_line := FND_API.G_MISS_CHAR;
580: x_product_uom := FND_API.G_MISS_CHAR;
581: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
582: x_comparison_operator_code := FND_API.G_MISS_CHAR;
583: x_pricing_attribute_datatype := FND_API.G_MISS_CHAR;

Line 580: x_product_uom := FND_API.G_MISS_CHAR;

576: x_product_uom_code := FND_API.G_MISS_CHAR;
577: x_accumulate := FND_API.G_MISS_CHAR;
578: x_excluder := FND_API.G_MISS_CHAR;
579: x_list_line := FND_API.G_MISS_CHAR;
580: x_product_uom := FND_API.G_MISS_CHAR;
581: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
582: x_comparison_operator_code := FND_API.G_MISS_CHAR;
583: x_pricing_attribute_datatype := FND_API.G_MISS_CHAR;
584: x_product_attribute_datatype := FND_API.G_MISS_CHAR;

Line 581: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;

577: x_accumulate := FND_API.G_MISS_CHAR;
578: x_excluder := FND_API.G_MISS_CHAR;
579: x_list_line := FND_API.G_MISS_CHAR;
580: x_product_uom := FND_API.G_MISS_CHAR;
581: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
582: x_comparison_operator_code := FND_API.G_MISS_CHAR;
583: x_pricing_attribute_datatype := FND_API.G_MISS_CHAR;
584: x_product_attribute_datatype := FND_API.G_MISS_CHAR;
585:

Line 582: x_comparison_operator_code := FND_API.G_MISS_CHAR;

578: x_excluder := FND_API.G_MISS_CHAR;
579: x_list_line := FND_API.G_MISS_CHAR;
580: x_product_uom := FND_API.G_MISS_CHAR;
581: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
582: x_comparison_operator_code := FND_API.G_MISS_CHAR;
583: x_pricing_attribute_datatype := FND_API.G_MISS_CHAR;
584: x_product_attribute_datatype := FND_API.G_MISS_CHAR;
585:
586: -- Load display out parameters if any

Line 583: x_pricing_attribute_datatype := FND_API.G_MISS_CHAR;

579: x_list_line := FND_API.G_MISS_CHAR;
580: x_product_uom := FND_API.G_MISS_CHAR;
581: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
582: x_comparison_operator_code := FND_API.G_MISS_CHAR;
583: x_pricing_attribute_datatype := FND_API.G_MISS_CHAR;
584: x_product_attribute_datatype := FND_API.G_MISS_CHAR;
585:
586: -- Load display out parameters if any
587:

Line 584: x_product_attribute_datatype := FND_API.G_MISS_CHAR;

580: x_product_uom := FND_API.G_MISS_CHAR;
581: x_from_rltd_modifier_id := FND_API.G_MISS_NUM;
582: x_comparison_operator_code := FND_API.G_MISS_CHAR;
583: x_pricing_attribute_datatype := FND_API.G_MISS_CHAR;
584: x_product_attribute_datatype := FND_API.G_MISS_CHAR;
585:
586: -- Load display out parameters if any
587:
588: l_PRICING_ATTR_val_rec := Qp_pll_pricing_attr_Util.Get_Values

Line 808: x_return_status := FND_API.G_RET_STS_SUCCESS;

804: );
805:
806: -- Set return status.
807:
808: x_return_status := FND_API.G_RET_STS_SUCCESS;
809:
810: -- Get message count and data
811:
812: oe_msg_pub.Count_And_Get

Line 820: WHEN FND_API.G_EXC_ERROR THEN

816:
817:
818: EXCEPTION
819:
820: WHEN FND_API.G_EXC_ERROR THEN
821:
822: x_return_status := FND_API.G_RET_STS_ERROR;
823:
824: -- Get message count and data

Line 822: x_return_status := FND_API.G_RET_STS_ERROR;

818: EXCEPTION
819:
820: WHEN FND_API.G_EXC_ERROR THEN
821:
822: x_return_status := FND_API.G_RET_STS_ERROR;
823:
824: -- Get message count and data
825:
826: oe_msg_pub.Count_And_Get

Line 831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

827: ( p_count => x_msg_count
828: , p_data => x_msg_data
829: );
830:
831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
832:
833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
834:
835: -- Get message count and data

Line 833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

829: );
830:
831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
832:
833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
834:
835: -- Get message count and data
836:
837: oe_msg_pub.Count_And_Get

Line 844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

840: );
841:
842: WHEN OTHERS THEN
843:
844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
845:
846: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
847: THEN
848: oe_msg_pub.Add_Exc_Msg

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

923: );
924:
925: -- Set Operation.
926:
927: IF FND_API.To_Boolean(l_PRICING_ATTR_rec.db_flag) THEN
928: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
929: ELSE
930: l_PRICING_ATTR_rec.operation := QP_GLOBALS.G_OPR_CREATE;
931: END IF;

Line 942: , p_init_msg_list => FND_API.G_TRUE

938: -- Call QP_LIST_HEADERS_PVT.Process_PRICE_LIST
939:
940: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
941: ( p_api_version_number => 1.0
942: , p_init_msg_list => FND_API.G_TRUE
943: , x_return_status => l_return_status
944: , x_msg_count => x_msg_count
945: , x_msg_data => x_msg_data
946: , p_control_rec => l_control_rec

Line 955: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

951: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
952: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
953: );
954:
955: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
957: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
958: RAISE FND_API.G_EXC_ERROR;
959: END IF;

Line 956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

952: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
953: );
954:
955: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
957: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
958: RAISE FND_API.G_EXC_ERROR;
959: END IF;
960:

Line 957: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

953: );
954:
955: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
957: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
958: RAISE FND_API.G_EXC_ERROR;
959: END IF;
960:
961:

Line 958: RAISE FND_API.G_EXC_ERROR;

954:
955: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
957: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
958: RAISE FND_API.G_EXC_ERROR;
959: END IF;
960:
961:
962: -- Load OUT parameters.

Line 987: x_return_status := FND_API.G_RET_STS_SUCCESS;

983:
984:
985: -- Set return status.
986:
987: x_return_status := FND_API.G_RET_STS_SUCCESS;
988:
989: -- Get message count and data
990:
991: oe_debug_pub.add('Ren: msg data in val_and_write of attr 1 is :' || x_msg_data);

Line 1003: WHEN FND_API.G_EXC_ERROR THEN

999: oe_debug_pub.add('exiting validate_and_write');
1000:
1001: EXCEPTION
1002:
1003: WHEN FND_API.G_EXC_ERROR THEN
1004:
1005: x_return_status := FND_API.G_RET_STS_ERROR;
1006:
1007: -- Get message count and data

Line 1005: x_return_status := FND_API.G_RET_STS_ERROR;

1001: EXCEPTION
1002:
1003: WHEN FND_API.G_EXC_ERROR THEN
1004:
1005: x_return_status := FND_API.G_RET_STS_ERROR;
1006:
1007: -- Get message count and data
1008:
1009: oe_msg_pub.Count_And_Get

Line 1015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1011: , p_data => x_msg_data
1012: );
1013: oe_debug_pub.add('Ren: msg data in val_and_write of attr 10 is :' || x_msg_data);
1014:
1015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1016:
1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1018:
1019: -- Get message count and data

Line 1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1013: oe_debug_pub.add('Ren: msg data in val_and_write of attr 10 is :' || x_msg_data);
1014:
1015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1016:
1017: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1018:
1019: -- Get message count and data
1020:
1021: oe_msg_pub.Count_And_Get

Line 1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1025: oe_debug_pub.add('Ren: msg data in val_and_write of attr 11 is :' || x_msg_data);
1026:
1027: WHEN OTHERS THEN
1028:
1029: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1030:
1031: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1032: THEN
1033: oe_msg_pub.Add_Exc_Msg

Line 1135: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1131: , p_param4 => l_revision
1132: , x_return_status => l_return_status
1133: );
1134:
1135: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1136:
1137: oe_debug_pub.add('failed in logging a delayed request in delete_row ');
1138:
1139: RAISE FND_API.G_EXC_ERROR;

Line 1139: RAISE FND_API.G_EXC_ERROR;

1135: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1136:
1137: oe_debug_pub.add('failed in logging a delayed request in delete_row ');
1138:
1139: RAISE FND_API.G_EXC_ERROR;
1140:
1141: END IF;
1142:
1143: oe_debug_pub.add('after logging delayed request ');

Line 1157: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1153: p_requesting_entity_id => l_PRICING_ATTR_rec.list_line_id,
1154: p_request_type =>QP_GLOBALS.G_UPDATE_LINE_QUAL_IND,
1155: x_return_status => l_return_status);
1156:
1157: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1158:
1159: oe_debug_pub.add('failed in logging a delayed request in delete_row ');
1160:
1161: RAISE FND_API.G_EXC_ERROR;

Line 1161: RAISE FND_API.G_EXC_ERROR;

1157: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1158:
1159: oe_debug_pub.add('failed in logging a delayed request in delete_row ');
1160:
1161: RAISE FND_API.G_EXC_ERROR;
1162:
1163: END IF;
1164:
1165: QP_LIST_HEADERS_PVT.Process_PRICE_LIST

Line 1167: , p_init_msg_list => FND_API.G_TRUE

1163: END IF;
1164:
1165: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
1166: ( p_api_version_number => 1.0
1167: , p_init_msg_list => FND_API.G_TRUE
1168: , x_return_status => l_return_status
1169: , x_msg_count => x_msg_count
1170: , x_msg_data => x_msg_data
1171: , p_control_rec => l_control_rec

Line 1179: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1175: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1176: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1177: );
1178:
1179: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1181: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1182: RAISE FND_API.G_EXC_ERROR;
1183: END IF;

Line 1180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1176: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1177: );
1178:
1179: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1181: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1182: RAISE FND_API.G_EXC_ERROR;
1183: END IF;
1184:

Line 1181: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1177: );
1178:
1179: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1181: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1182: RAISE FND_API.G_EXC_ERROR;
1183: END IF;
1184:
1185:

Line 1182: RAISE FND_API.G_EXC_ERROR;

1178:
1179: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1180: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1181: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1182: RAISE FND_API.G_EXC_ERROR;
1183: END IF;
1184:
1185:
1186: -- Clear PRICING_ATTR record cache

Line 1192: x_return_status := FND_API.G_RET_STS_SUCCESS;

1188: Clear_PRICING_ATTR;
1189:
1190: -- Set return status.
1191:
1192: x_return_status := FND_API.G_RET_STS_SUCCESS;
1193:
1194: -- Get message count and data
1195:
1196: oe_msg_pub.Count_And_Get

Line 1204: WHEN FND_API.G_EXC_ERROR THEN

1200:
1201:
1202: EXCEPTION
1203:
1204: WHEN FND_API.G_EXC_ERROR THEN
1205:
1206: x_return_status := FND_API.G_RET_STS_ERROR;
1207:
1208: -- Get message count and data

Line 1206: x_return_status := FND_API.G_RET_STS_ERROR;

1202: EXCEPTION
1203:
1204: WHEN FND_API.G_EXC_ERROR THEN
1205:
1206: x_return_status := FND_API.G_RET_STS_ERROR;
1207:
1208: -- Get message count and data
1209:
1210: oe_msg_pub.Count_And_Get

Line 1215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1211: ( p_count => x_msg_count
1212: , p_data => x_msg_data
1213: );
1214:
1215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1216:
1217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1218:
1219: -- Get message count and data

Line 1217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1213: );
1214:
1215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1216:
1217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1218:
1219: -- Get message count and data
1220:
1221: oe_msg_pub.Count_And_Get

Line 1228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1224: );
1225:
1226: WHEN OTHERS THEN
1227:
1228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1229:
1230: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1231: THEN
1232: oe_msg_pub.Add_Exc_Msg

Line 1287: , p_init_msg_list => FND_API.G_TRUE

1283: -- Call QP_LIST_HEADERS_PVT.Process_PRICE_LIST
1284:
1285: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
1286: ( p_api_version_number => 1.0
1287: , p_init_msg_list => FND_API.G_TRUE
1288: , x_return_status => l_return_status
1289: , x_msg_count => x_msg_count
1290: , x_msg_data => x_msg_data
1291: , p_control_rec => l_control_rec

Line 1298: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1294: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1295: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1296: );
1297:
1298: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1300: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1301: RAISE FND_API.G_EXC_ERROR;
1302: END IF;

Line 1299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1295: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1296: );
1297:
1298: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1300: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1301: RAISE FND_API.G_EXC_ERROR;
1302: END IF;
1303:

Line 1300: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1296: );
1297:
1298: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1300: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1301: RAISE FND_API.G_EXC_ERROR;
1302: END IF;
1303:
1304:

Line 1301: RAISE FND_API.G_EXC_ERROR;

1297:
1298: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1300: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1301: RAISE FND_API.G_EXC_ERROR;
1302: END IF;
1303:
1304:
1305: -- Set return status.

Line 1307: x_return_status := FND_API.G_RET_STS_SUCCESS;

1303:
1304:
1305: -- Set return status.
1306:
1307: x_return_status := FND_API.G_RET_STS_SUCCESS;
1308:
1309: -- Get message count and data
1310:
1311: oe_msg_pub.Count_And_Get

Line 1319: WHEN FND_API.G_EXC_ERROR THEN

1315:
1316:
1317: EXCEPTION
1318:
1319: WHEN FND_API.G_EXC_ERROR THEN
1320:
1321: x_return_status := FND_API.G_RET_STS_ERROR;
1322:
1323: -- Get message count and data

Line 1321: x_return_status := FND_API.G_RET_STS_ERROR;

1317: EXCEPTION
1318:
1319: WHEN FND_API.G_EXC_ERROR THEN
1320:
1321: x_return_status := FND_API.G_RET_STS_ERROR;
1322:
1323: -- Get message count and data
1324:
1325: oe_msg_pub.Count_And_Get

Line 1330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1326: ( p_count => x_msg_count
1327: , p_data => x_msg_data
1328: );
1329:
1330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1331:
1332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1333:
1334: -- Get message count and data

Line 1332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1328: );
1329:
1330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1331:
1332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1333:
1334: -- Get message count and data
1335:
1336: oe_msg_pub.Count_And_Get

Line 1343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1339: );
1340:
1341: WHEN OTHERS THEN
1342:
1343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1344:
1345: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1346: THEN
1347: oe_msg_pub.Add_Exc_Msg

Line 1477: , p_init_msg_list => FND_API.G_TRUE

1473: -- Call QP_LIST_HEADERS_PVT.Lock_PRICE_LIST
1474:
1475: QP_LIST_HEADERS_PVT.Lock_PRICE_LIST
1476: ( p_api_version_number => 1.0
1477: , p_init_msg_list => FND_API.G_TRUE
1478: , x_return_status => l_return_status
1479: , x_msg_count => x_msg_count
1480: , x_msg_data => x_msg_data
1481: , p_PRICING_ATTR_tbl => l_PRICING_ATTR_tbl

Line 1488: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1484: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1485: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1486: );
1487:
1488: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1489:
1490: -- Set DB flag and write record to cache.
1491:
1492: l_x_PRICING_ATTR_rec.db_flag := FND_API.G_TRUE;

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

1488: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1489:
1490: -- Set DB flag and write record to cache.
1491:
1492: l_x_PRICING_ATTR_rec.db_flag := FND_API.G_TRUE;
1493:
1494: Write_PRICING_ATTR
1495: ( p_PRICING_ATTR_rec => l_x_PRICING_ATTR_rec
1496: , p_db_record => TRUE

Line 1525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1521: , 'Lock_Row'
1522: );
1523: END IF;
1524:
1525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1526:
1527: -- Get message count and data
1528:
1529: oe_msg_pub.Count_And_Get

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

1570: g_PRICING_ATTR_rec := Qp_pll_pricing_attr_Util.Query_Row
1571: ( p_pricing_attribute_id => p_pricing_attribute_id
1572: );
1573:
1574: g_PRICING_ATTR_rec.db_flag := FND_API.G_TRUE;
1575:
1576: -- Load DB record
1577:
1578: g_db_PRICING_ATTR_rec := g_PRICING_ATTR_rec;

Line 1616: x_return_status := FND_API.G_RET_STS_SUCCESS;

1612: IS
1613: l_return_status Varchar2(30);
1614: BEGIN
1615: OE_MSG_PUB.initialize;
1616: x_return_status := FND_API.G_RET_STS_SUCCESS;
1617: QP_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
1618: p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
1619: ,p_entity_id => p_pricing_attribute_id
1620: ,x_return_status => l_return_status);

Line 1644: x_return_status := FND_API.G_RET_STS_ERROR;

1640: OE_MSG_PUB.Count_And_Get
1641: ( p_count => x_msg_count
1642: , p_data => x_msg_data
1643: );
1644: x_return_status := FND_API.G_RET_STS_ERROR;
1645:
1646: END Clear_Record;
1647:
1648:

Line 1660: x_return_status := FND_API.G_RET_STS_SUCCESS;

1656: IS
1657: l_return_status Varchar2(30);
1658: BEGIN
1659: OE_MSG_PUB.initialize;
1660: x_return_status := FND_API.G_RET_STS_SUCCESS;
1661: QP_DELAYED_REQUESTS_PVT.Clear_Request(
1662: x_return_status => l_return_status);
1663:
1664: EXCEPTION

Line 1678: x_return_status := FND_API.G_RET_STS_ERROR;

1674: OE_MSG_PUB.Count_And_Get
1675: ( p_count => x_msg_count
1676: , p_data => x_msg_data
1677: );
1678: x_return_status := FND_API.G_RET_STS_ERROR;
1679:
1680: END Delete_All_Requests;
1681:
1682: Procedure Dup_record

Line 2053: l_PRICE_LIST_LINE_rec.db_flag := FND_API.G_TRUE;

2049: l_PRICE_LIST_LINE_rec.customer_item_id := l_implicit_rec.CUSTOMER_ITEM_ID;
2050: l_PRICE_LIST_LINE_rec.break_uom_code := l_implicit_rec.BREAK_UOM_CODE;
2051: l_PRICE_LIST_LINE_rec.break_uom_context := l_implicit_rec.BREAK_UOM_CONTEXT;
2052: l_PRICE_LIST_LINE_rec.break_uom_attribute := l_implicit_rec.BREAK_UOM_ATTRIBUTE;
2053: l_PRICE_LIST_LINE_rec.db_flag := FND_API.G_TRUE;
2054: l_PRICE_LIST_LINE_rec.operation := QP_GLOBALS.G_OPR_CREATE;
2055:
2056:
2057: l_PRICE_LIST_LINE_tbl(l_PRICE_LIST_LINE_tbl.COUNT + 1) := l_PRICE_LIST_LINE_rec;

Line 2142: , p_init_msg_list => FND_API.G_TRUE

2138:
2139:
2140: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
2141: ( p_api_version_number => 1.0
2142: , p_init_msg_list => FND_API.G_TRUE
2143: , x_return_status => l_return_status
2144: , x_msg_count => x_msg_count
2145: , x_msg_data => x_msg_data
2146: , p_control_rec => l_control_rec

Line 2174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2170: ( p_entity_code => QP_GLOBALS.G_ENTITY_PRICING_ATTR
2171: , x_return_status => l_return_status);
2172: END IF;
2173: oe_debug_pub.add('QPXFPLAB - l_return_status = ' || l_return_status);
2174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2177: RAISE FND_API.G_EXC_ERROR;
2178: END IF;

Line 2175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2171: , x_return_status => l_return_status);
2172: END IF;
2173: oe_debug_pub.add('QPXFPLAB - l_return_status = ' || l_return_status);
2174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2177: RAISE FND_API.G_EXC_ERROR;
2178: END IF;
2179: END IF;

Line 2176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2172: END IF;
2173: oe_debug_pub.add('QPXFPLAB - l_return_status = ' || l_return_status);
2174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2177: RAISE FND_API.G_EXC_ERROR;
2178: END IF;
2179: END IF;
2180:

Line 2177: RAISE FND_API.G_EXC_ERROR;

2173: oe_debug_pub.add('QPXFPLAB - l_return_status = ' || l_return_status);
2174: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2176: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2177: RAISE FND_API.G_EXC_ERROR;
2178: END IF;
2179: END IF;
2180:
2181: -- Added following 3 lines to avoid NullPointerException when called from Mass Maintenance

Line 2188: WHEN FND_API.G_EXC_ERROR THEN

2184: end if;
2185:
2186: EXCEPTION
2187:
2188: WHEN FND_API.G_EXC_ERROR THEN
2189:
2190: -- x_return_status := FND_API.G_RET_STS_ERROR;
2191:
2192: -- Get message count and data

Line 2190: -- x_return_status := FND_API.G_RET_STS_ERROR;

2186: EXCEPTION
2187:
2188: WHEN FND_API.G_EXC_ERROR THEN
2189:
2190: -- x_return_status := FND_API.G_RET_STS_ERROR;
2191:
2192: -- Get message count and data
2193:
2194: oe_msg_pub.Count_And_Get

Line 2199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2195: ( p_count => x_msg_count
2196: , p_data => x_msg_data
2197: );
2198:
2199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2200:
2201: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2202:
2203: -- Get message count and data

Line 2201: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2197: );
2198:
2199: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2200:
2201: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2202:
2203: -- Get message count and data
2204:
2205: oe_msg_pub.Count_And_Get

Line 2212: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2208: );
2209:
2210: WHEN OTHERS THEN
2211:
2212: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2213:
2214: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
2215: THEN
2216: oe_msg_pub.Add_Exc_Msg