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

Line 163: , p_init_msg_list => FND_API.G_TRUE

159: -- Call QP_LIST_HEADERS_PVT.Process_PRICE_LIST
160:
161: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
162: ( p_api_version_number => 1.0
163: , p_init_msg_list => FND_API.G_TRUE
164: , x_return_status => l_return_status
165: , x_msg_count => x_msg_count
166: , x_msg_data => x_msg_data
167: , p_control_rec => l_control_rec

Line 177: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

173: );
174:
175: oe_debug_pub.add('return status after proc_price_list ' || l_return_status);
176:
177: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
180: RAISE FND_API.G_EXC_ERROR;
181: END IF;

Line 178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

174:
175: oe_debug_pub.add('return status after proc_price_list ' || l_return_status);
176:
177: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
180: RAISE FND_API.G_EXC_ERROR;
181: END IF;
182:

Line 179: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

175: oe_debug_pub.add('return status after proc_price_list ' || l_return_status);
176:
177: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
180: RAISE FND_API.G_EXC_ERROR;
181: END IF;
182:
183: oe_debug_Pub.add('msg count 1 : ' || x_msg_count);

Line 180: RAISE FND_API.G_EXC_ERROR;

176:
177: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
178: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
179: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
180: RAISE FND_API.G_EXC_ERROR;
181: END IF;
182:
183: oe_debug_Pub.add('msg count 1 : ' || x_msg_count);
184: oe_debug_Pub.add('msg data 1 : ' || x_msg_data);

Line 261: l_x_PRICE_LIST_rec.db_flag := FND_API.G_FALSE;

257: -- Write to cache.
258: -- Set db_flag to False before writing to cache
259: oe_debug_Pub.add('msg data 3 : ' || x_msg_data);
260:
261: l_x_PRICE_LIST_rec.db_flag := FND_API.G_FALSE;
262:
263: Write_PRICE_LIST
264: ( p_PRICE_LIST_rec => l_x_PRICE_LIST_rec
265: );

Line 269: x_return_status := FND_API.G_RET_STS_SUCCESS;

265: );
266:
267: -- Set return status.
268:
269: x_return_status := FND_API.G_RET_STS_SUCCESS;
270:
271: -- Get message count and data
272:
273: oe_msg_pub.Count_And_Get

Line 284: WHEN FND_API.G_EXC_ERROR THEN

280:
281:
282: EXCEPTION
283:
284: WHEN FND_API.G_EXC_ERROR THEN
285:
286: x_return_status := FND_API.G_RET_STS_ERROR;
287:
288: -- Get message count and data

Line 286: x_return_status := FND_API.G_RET_STS_ERROR;

282: EXCEPTION
283:
284: WHEN FND_API.G_EXC_ERROR THEN
285:
286: x_return_status := FND_API.G_RET_STS_ERROR;
287:
288: -- Get message count and data
289:
290: oe_msg_pub.Count_And_Get

Line 295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

291: ( p_count => x_msg_count
292: , p_data => x_msg_data
293: );
294:
295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
296:
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
298:
299: -- Get message count and data

Line 297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

293: );
294:
295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
296:
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
298:
299: -- Get message count and data
300:
301: oe_msg_pub.Count_And_Get

Line 310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

306: oe_debug_pub.add('msg data 5 : ' || x_msg_data);
307:
308: WHEN OTHERS THEN
309:
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
311:
312: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
313: THEN
314: oe_msg_pub.Add_Exc_Msg

Line 564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

560: , 'Unrecognized attribute'
561: );
562: END IF;
563:
564: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
565:
566: END IF;
567:
568: -- Set Operation.

Line 570: IF FND_API.To_Boolean(l_PRICE_LIST_rec.db_flag) THEN

566: END IF;
567:
568: -- Set Operation.
569:
570: IF FND_API.To_Boolean(l_PRICE_LIST_rec.db_flag) THEN
571: l_PRICE_LIST_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
572: ELSE
573: l_PRICE_LIST_rec.operation := QP_GLOBALS.G_OPR_CREATE;
574: END IF;

Line 580: , p_init_msg_list => FND_API.G_TRUE

576: -- Call QP_LIST_HEADERS_PVT.Process_PRICE_LIST
577:
578: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
579: ( p_api_version_number => 1.0
580: , p_init_msg_list => FND_API.G_TRUE
581: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
582: , x_return_status => l_return_status
583: , x_msg_count => x_msg_count
584: , x_msg_data => x_msg_data

Line 581: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

577:
578: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
579: ( p_api_version_number => 1.0
580: , p_init_msg_list => FND_API.G_TRUE
581: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
582: , x_return_status => l_return_status
583: , x_msg_count => x_msg_count
584: , x_msg_data => x_msg_data
585: , p_control_rec => l_control_rec

Line 594: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

590: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
591: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
592: );
593:
594: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
596: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
597: RAISE FND_API.G_EXC_ERROR;
598: END IF;

Line 595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

591: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
592: );
593:
594: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
596: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
597: RAISE FND_API.G_EXC_ERROR;
598: END IF;
599:

Line 596: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

592: );
593:
594: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
596: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
597: RAISE FND_API.G_EXC_ERROR;
598: END IF;
599:
600:

Line 597: RAISE FND_API.G_EXC_ERROR;

593:
594: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
596: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
597: RAISE FND_API.G_EXC_ERROR;
598: END IF;
599:
600:
601: -- Init OUT parameters to missing.

Line 603: x_attribute1 := FND_API.G_MISS_CHAR;

599:
600:
601: -- Init OUT parameters to missing.
602:
603: x_attribute1 := FND_API.G_MISS_CHAR;
604: x_attribute10 := FND_API.G_MISS_CHAR;
605: x_attribute11 := FND_API.G_MISS_CHAR;
606: x_attribute12 := FND_API.G_MISS_CHAR;
607: x_attribute13 := FND_API.G_MISS_CHAR;

Line 604: x_attribute10 := FND_API.G_MISS_CHAR;

600:
601: -- Init OUT parameters to missing.
602:
603: x_attribute1 := FND_API.G_MISS_CHAR;
604: x_attribute10 := FND_API.G_MISS_CHAR;
605: x_attribute11 := FND_API.G_MISS_CHAR;
606: x_attribute12 := FND_API.G_MISS_CHAR;
607: x_attribute13 := FND_API.G_MISS_CHAR;
608: x_attribute14 := FND_API.G_MISS_CHAR;

Line 605: x_attribute11 := FND_API.G_MISS_CHAR;

601: -- Init OUT parameters to missing.
602:
603: x_attribute1 := FND_API.G_MISS_CHAR;
604: x_attribute10 := FND_API.G_MISS_CHAR;
605: x_attribute11 := FND_API.G_MISS_CHAR;
606: x_attribute12 := FND_API.G_MISS_CHAR;
607: x_attribute13 := FND_API.G_MISS_CHAR;
608: x_attribute14 := FND_API.G_MISS_CHAR;
609: x_attribute15 := FND_API.G_MISS_CHAR;

Line 606: x_attribute12 := FND_API.G_MISS_CHAR;

602:
603: x_attribute1 := FND_API.G_MISS_CHAR;
604: x_attribute10 := FND_API.G_MISS_CHAR;
605: x_attribute11 := FND_API.G_MISS_CHAR;
606: x_attribute12 := FND_API.G_MISS_CHAR;
607: x_attribute13 := FND_API.G_MISS_CHAR;
608: x_attribute14 := FND_API.G_MISS_CHAR;
609: x_attribute15 := FND_API.G_MISS_CHAR;
610: x_attribute2 := FND_API.G_MISS_CHAR;

Line 607: x_attribute13 := FND_API.G_MISS_CHAR;

603: x_attribute1 := FND_API.G_MISS_CHAR;
604: x_attribute10 := FND_API.G_MISS_CHAR;
605: x_attribute11 := FND_API.G_MISS_CHAR;
606: x_attribute12 := FND_API.G_MISS_CHAR;
607: x_attribute13 := FND_API.G_MISS_CHAR;
608: x_attribute14 := FND_API.G_MISS_CHAR;
609: x_attribute15 := FND_API.G_MISS_CHAR;
610: x_attribute2 := FND_API.G_MISS_CHAR;
611: x_attribute3 := FND_API.G_MISS_CHAR;

Line 608: x_attribute14 := FND_API.G_MISS_CHAR;

604: x_attribute10 := FND_API.G_MISS_CHAR;
605: x_attribute11 := FND_API.G_MISS_CHAR;
606: x_attribute12 := FND_API.G_MISS_CHAR;
607: x_attribute13 := FND_API.G_MISS_CHAR;
608: x_attribute14 := FND_API.G_MISS_CHAR;
609: x_attribute15 := FND_API.G_MISS_CHAR;
610: x_attribute2 := FND_API.G_MISS_CHAR;
611: x_attribute3 := FND_API.G_MISS_CHAR;
612: x_attribute4 := FND_API.G_MISS_CHAR;

Line 609: x_attribute15 := FND_API.G_MISS_CHAR;

605: x_attribute11 := FND_API.G_MISS_CHAR;
606: x_attribute12 := FND_API.G_MISS_CHAR;
607: x_attribute13 := FND_API.G_MISS_CHAR;
608: x_attribute14 := FND_API.G_MISS_CHAR;
609: x_attribute15 := FND_API.G_MISS_CHAR;
610: x_attribute2 := FND_API.G_MISS_CHAR;
611: x_attribute3 := FND_API.G_MISS_CHAR;
612: x_attribute4 := FND_API.G_MISS_CHAR;
613: x_attribute5 := FND_API.G_MISS_CHAR;

Line 610: x_attribute2 := FND_API.G_MISS_CHAR;

606: x_attribute12 := FND_API.G_MISS_CHAR;
607: x_attribute13 := FND_API.G_MISS_CHAR;
608: x_attribute14 := FND_API.G_MISS_CHAR;
609: x_attribute15 := FND_API.G_MISS_CHAR;
610: x_attribute2 := FND_API.G_MISS_CHAR;
611: x_attribute3 := FND_API.G_MISS_CHAR;
612: x_attribute4 := FND_API.G_MISS_CHAR;
613: x_attribute5 := FND_API.G_MISS_CHAR;
614: x_attribute6 := FND_API.G_MISS_CHAR;

Line 611: x_attribute3 := FND_API.G_MISS_CHAR;

607: x_attribute13 := FND_API.G_MISS_CHAR;
608: x_attribute14 := FND_API.G_MISS_CHAR;
609: x_attribute15 := FND_API.G_MISS_CHAR;
610: x_attribute2 := FND_API.G_MISS_CHAR;
611: x_attribute3 := FND_API.G_MISS_CHAR;
612: x_attribute4 := FND_API.G_MISS_CHAR;
613: x_attribute5 := FND_API.G_MISS_CHAR;
614: x_attribute6 := FND_API.G_MISS_CHAR;
615: x_attribute7 := FND_API.G_MISS_CHAR;

Line 612: x_attribute4 := FND_API.G_MISS_CHAR;

608: x_attribute14 := FND_API.G_MISS_CHAR;
609: x_attribute15 := FND_API.G_MISS_CHAR;
610: x_attribute2 := FND_API.G_MISS_CHAR;
611: x_attribute3 := FND_API.G_MISS_CHAR;
612: x_attribute4 := FND_API.G_MISS_CHAR;
613: x_attribute5 := FND_API.G_MISS_CHAR;
614: x_attribute6 := FND_API.G_MISS_CHAR;
615: x_attribute7 := FND_API.G_MISS_CHAR;
616: x_attribute8 := FND_API.G_MISS_CHAR;

Line 613: x_attribute5 := FND_API.G_MISS_CHAR;

609: x_attribute15 := FND_API.G_MISS_CHAR;
610: x_attribute2 := FND_API.G_MISS_CHAR;
611: x_attribute3 := FND_API.G_MISS_CHAR;
612: x_attribute4 := FND_API.G_MISS_CHAR;
613: x_attribute5 := FND_API.G_MISS_CHAR;
614: x_attribute6 := FND_API.G_MISS_CHAR;
615: x_attribute7 := FND_API.G_MISS_CHAR;
616: x_attribute8 := FND_API.G_MISS_CHAR;
617: x_attribute9 := FND_API.G_MISS_CHAR;

Line 614: x_attribute6 := FND_API.G_MISS_CHAR;

610: x_attribute2 := FND_API.G_MISS_CHAR;
611: x_attribute3 := FND_API.G_MISS_CHAR;
612: x_attribute4 := FND_API.G_MISS_CHAR;
613: x_attribute5 := FND_API.G_MISS_CHAR;
614: x_attribute6 := FND_API.G_MISS_CHAR;
615: x_attribute7 := FND_API.G_MISS_CHAR;
616: x_attribute8 := FND_API.G_MISS_CHAR;
617: x_attribute9 := FND_API.G_MISS_CHAR;
618: x_automatic_flag := FND_API.G_MISS_CHAR;

Line 615: x_attribute7 := FND_API.G_MISS_CHAR;

611: x_attribute3 := FND_API.G_MISS_CHAR;
612: x_attribute4 := FND_API.G_MISS_CHAR;
613: x_attribute5 := FND_API.G_MISS_CHAR;
614: x_attribute6 := FND_API.G_MISS_CHAR;
615: x_attribute7 := FND_API.G_MISS_CHAR;
616: x_attribute8 := FND_API.G_MISS_CHAR;
617: x_attribute9 := FND_API.G_MISS_CHAR;
618: x_automatic_flag := FND_API.G_MISS_CHAR;
619: x_comments := FND_API.G_MISS_CHAR;

Line 616: x_attribute8 := FND_API.G_MISS_CHAR;

612: x_attribute4 := FND_API.G_MISS_CHAR;
613: x_attribute5 := FND_API.G_MISS_CHAR;
614: x_attribute6 := FND_API.G_MISS_CHAR;
615: x_attribute7 := FND_API.G_MISS_CHAR;
616: x_attribute8 := FND_API.G_MISS_CHAR;
617: x_attribute9 := FND_API.G_MISS_CHAR;
618: x_automatic_flag := FND_API.G_MISS_CHAR;
619: x_comments := FND_API.G_MISS_CHAR;
620: x_context := FND_API.G_MISS_CHAR;

Line 617: x_attribute9 := FND_API.G_MISS_CHAR;

613: x_attribute5 := FND_API.G_MISS_CHAR;
614: x_attribute6 := FND_API.G_MISS_CHAR;
615: x_attribute7 := FND_API.G_MISS_CHAR;
616: x_attribute8 := FND_API.G_MISS_CHAR;
617: x_attribute9 := FND_API.G_MISS_CHAR;
618: x_automatic_flag := FND_API.G_MISS_CHAR;
619: x_comments := FND_API.G_MISS_CHAR;
620: x_context := FND_API.G_MISS_CHAR;
621: x_currency_code := FND_API.G_MISS_CHAR;

Line 618: x_automatic_flag := FND_API.G_MISS_CHAR;

614: x_attribute6 := FND_API.G_MISS_CHAR;
615: x_attribute7 := FND_API.G_MISS_CHAR;
616: x_attribute8 := FND_API.G_MISS_CHAR;
617: x_attribute9 := FND_API.G_MISS_CHAR;
618: x_automatic_flag := FND_API.G_MISS_CHAR;
619: x_comments := FND_API.G_MISS_CHAR;
620: x_context := FND_API.G_MISS_CHAR;
621: x_currency_code := FND_API.G_MISS_CHAR;
622: x_discount_lines_flag := FND_API.G_MISS_CHAR;

Line 619: x_comments := FND_API.G_MISS_CHAR;

615: x_attribute7 := FND_API.G_MISS_CHAR;
616: x_attribute8 := FND_API.G_MISS_CHAR;
617: x_attribute9 := FND_API.G_MISS_CHAR;
618: x_automatic_flag := FND_API.G_MISS_CHAR;
619: x_comments := FND_API.G_MISS_CHAR;
620: x_context := FND_API.G_MISS_CHAR;
621: x_currency_code := FND_API.G_MISS_CHAR;
622: x_discount_lines_flag := FND_API.G_MISS_CHAR;
623: x_end_date_active := FND_API.G_MISS_DATE;

Line 620: x_context := FND_API.G_MISS_CHAR;

616: x_attribute8 := FND_API.G_MISS_CHAR;
617: x_attribute9 := FND_API.G_MISS_CHAR;
618: x_automatic_flag := FND_API.G_MISS_CHAR;
619: x_comments := FND_API.G_MISS_CHAR;
620: x_context := FND_API.G_MISS_CHAR;
621: x_currency_code := FND_API.G_MISS_CHAR;
622: x_discount_lines_flag := FND_API.G_MISS_CHAR;
623: x_end_date_active := FND_API.G_MISS_DATE;
624: x_freight_terms_code := FND_API.G_MISS_CHAR;

Line 621: x_currency_code := FND_API.G_MISS_CHAR;

617: x_attribute9 := FND_API.G_MISS_CHAR;
618: x_automatic_flag := FND_API.G_MISS_CHAR;
619: x_comments := FND_API.G_MISS_CHAR;
620: x_context := FND_API.G_MISS_CHAR;
621: x_currency_code := FND_API.G_MISS_CHAR;
622: x_discount_lines_flag := FND_API.G_MISS_CHAR;
623: x_end_date_active := FND_API.G_MISS_DATE;
624: x_freight_terms_code := FND_API.G_MISS_CHAR;
625: x_gsa_indicator := FND_API.G_MISS_CHAR;

Line 622: x_discount_lines_flag := FND_API.G_MISS_CHAR;

618: x_automatic_flag := FND_API.G_MISS_CHAR;
619: x_comments := FND_API.G_MISS_CHAR;
620: x_context := FND_API.G_MISS_CHAR;
621: x_currency_code := FND_API.G_MISS_CHAR;
622: x_discount_lines_flag := FND_API.G_MISS_CHAR;
623: x_end_date_active := FND_API.G_MISS_DATE;
624: x_freight_terms_code := FND_API.G_MISS_CHAR;
625: x_gsa_indicator := FND_API.G_MISS_CHAR;
626: x_list_header_id := FND_API.G_MISS_NUM;

Line 623: x_end_date_active := FND_API.G_MISS_DATE;

619: x_comments := FND_API.G_MISS_CHAR;
620: x_context := FND_API.G_MISS_CHAR;
621: x_currency_code := FND_API.G_MISS_CHAR;
622: x_discount_lines_flag := FND_API.G_MISS_CHAR;
623: x_end_date_active := FND_API.G_MISS_DATE;
624: x_freight_terms_code := FND_API.G_MISS_CHAR;
625: x_gsa_indicator := FND_API.G_MISS_CHAR;
626: x_list_header_id := FND_API.G_MISS_NUM;
627: x_list_type_code := FND_API.G_MISS_CHAR;

Line 624: x_freight_terms_code := FND_API.G_MISS_CHAR;

620: x_context := FND_API.G_MISS_CHAR;
621: x_currency_code := FND_API.G_MISS_CHAR;
622: x_discount_lines_flag := FND_API.G_MISS_CHAR;
623: x_end_date_active := FND_API.G_MISS_DATE;
624: x_freight_terms_code := FND_API.G_MISS_CHAR;
625: x_gsa_indicator := FND_API.G_MISS_CHAR;
626: x_list_header_id := FND_API.G_MISS_NUM;
627: x_list_type_code := FND_API.G_MISS_CHAR;
628: x_prorate_flag := FND_API.G_MISS_CHAR;

Line 625: x_gsa_indicator := FND_API.G_MISS_CHAR;

621: x_currency_code := FND_API.G_MISS_CHAR;
622: x_discount_lines_flag := FND_API.G_MISS_CHAR;
623: x_end_date_active := FND_API.G_MISS_DATE;
624: x_freight_terms_code := FND_API.G_MISS_CHAR;
625: x_gsa_indicator := FND_API.G_MISS_CHAR;
626: x_list_header_id := FND_API.G_MISS_NUM;
627: x_list_type_code := FND_API.G_MISS_CHAR;
628: x_prorate_flag := FND_API.G_MISS_CHAR;
629: x_rounding_factor := FND_API.G_MISS_NUM;

Line 626: x_list_header_id := FND_API.G_MISS_NUM;

622: x_discount_lines_flag := FND_API.G_MISS_CHAR;
623: x_end_date_active := FND_API.G_MISS_DATE;
624: x_freight_terms_code := FND_API.G_MISS_CHAR;
625: x_gsa_indicator := FND_API.G_MISS_CHAR;
626: x_list_header_id := FND_API.G_MISS_NUM;
627: x_list_type_code := FND_API.G_MISS_CHAR;
628: x_prorate_flag := FND_API.G_MISS_CHAR;
629: x_rounding_factor := FND_API.G_MISS_NUM;
630: x_ship_method_code := FND_API.G_MISS_CHAR;

Line 627: x_list_type_code := FND_API.G_MISS_CHAR;

623: x_end_date_active := FND_API.G_MISS_DATE;
624: x_freight_terms_code := FND_API.G_MISS_CHAR;
625: x_gsa_indicator := FND_API.G_MISS_CHAR;
626: x_list_header_id := FND_API.G_MISS_NUM;
627: x_list_type_code := FND_API.G_MISS_CHAR;
628: x_prorate_flag := FND_API.G_MISS_CHAR;
629: x_rounding_factor := FND_API.G_MISS_NUM;
630: x_ship_method_code := FND_API.G_MISS_CHAR;
631: x_start_date_active := FND_API.G_MISS_DATE;

Line 628: x_prorate_flag := FND_API.G_MISS_CHAR;

624: x_freight_terms_code := FND_API.G_MISS_CHAR;
625: x_gsa_indicator := FND_API.G_MISS_CHAR;
626: x_list_header_id := FND_API.G_MISS_NUM;
627: x_list_type_code := FND_API.G_MISS_CHAR;
628: x_prorate_flag := FND_API.G_MISS_CHAR;
629: x_rounding_factor := FND_API.G_MISS_NUM;
630: x_ship_method_code := FND_API.G_MISS_CHAR;
631: x_start_date_active := FND_API.G_MISS_DATE;
632: x_terms_id := FND_API.G_MISS_NUM;

Line 629: x_rounding_factor := FND_API.G_MISS_NUM;

625: x_gsa_indicator := FND_API.G_MISS_CHAR;
626: x_list_header_id := FND_API.G_MISS_NUM;
627: x_list_type_code := FND_API.G_MISS_CHAR;
628: x_prorate_flag := FND_API.G_MISS_CHAR;
629: x_rounding_factor := FND_API.G_MISS_NUM;
630: x_ship_method_code := FND_API.G_MISS_CHAR;
631: x_start_date_active := FND_API.G_MISS_DATE;
632: x_terms_id := FND_API.G_MISS_NUM;
633: x_automatic := FND_API.G_MISS_CHAR;

Line 630: x_ship_method_code := FND_API.G_MISS_CHAR;

626: x_list_header_id := FND_API.G_MISS_NUM;
627: x_list_type_code := FND_API.G_MISS_CHAR;
628: x_prorate_flag := FND_API.G_MISS_CHAR;
629: x_rounding_factor := FND_API.G_MISS_NUM;
630: x_ship_method_code := FND_API.G_MISS_CHAR;
631: x_start_date_active := FND_API.G_MISS_DATE;
632: x_terms_id := FND_API.G_MISS_NUM;
633: x_automatic := FND_API.G_MISS_CHAR;
634: x_currency := FND_API.G_MISS_CHAR;

Line 631: x_start_date_active := FND_API.G_MISS_DATE;

627: x_list_type_code := FND_API.G_MISS_CHAR;
628: x_prorate_flag := FND_API.G_MISS_CHAR;
629: x_rounding_factor := FND_API.G_MISS_NUM;
630: x_ship_method_code := FND_API.G_MISS_CHAR;
631: x_start_date_active := FND_API.G_MISS_DATE;
632: x_terms_id := FND_API.G_MISS_NUM;
633: x_automatic := FND_API.G_MISS_CHAR;
634: x_currency := FND_API.G_MISS_CHAR;
635: x_discount_lines := FND_API.G_MISS_CHAR;

Line 632: x_terms_id := FND_API.G_MISS_NUM;

628: x_prorate_flag := FND_API.G_MISS_CHAR;
629: x_rounding_factor := FND_API.G_MISS_NUM;
630: x_ship_method_code := FND_API.G_MISS_CHAR;
631: x_start_date_active := FND_API.G_MISS_DATE;
632: x_terms_id := FND_API.G_MISS_NUM;
633: x_automatic := FND_API.G_MISS_CHAR;
634: x_currency := FND_API.G_MISS_CHAR;
635: x_discount_lines := FND_API.G_MISS_CHAR;
636: x_freight_terms := FND_API.G_MISS_CHAR;

Line 633: x_automatic := FND_API.G_MISS_CHAR;

629: x_rounding_factor := FND_API.G_MISS_NUM;
630: x_ship_method_code := FND_API.G_MISS_CHAR;
631: x_start_date_active := FND_API.G_MISS_DATE;
632: x_terms_id := FND_API.G_MISS_NUM;
633: x_automatic := FND_API.G_MISS_CHAR;
634: x_currency := FND_API.G_MISS_CHAR;
635: x_discount_lines := FND_API.G_MISS_CHAR;
636: x_freight_terms := FND_API.G_MISS_CHAR;
637: x_list_header := FND_API.G_MISS_CHAR;

Line 634: x_currency := FND_API.G_MISS_CHAR;

630: x_ship_method_code := FND_API.G_MISS_CHAR;
631: x_start_date_active := FND_API.G_MISS_DATE;
632: x_terms_id := FND_API.G_MISS_NUM;
633: x_automatic := FND_API.G_MISS_CHAR;
634: x_currency := FND_API.G_MISS_CHAR;
635: x_discount_lines := FND_API.G_MISS_CHAR;
636: x_freight_terms := FND_API.G_MISS_CHAR;
637: x_list_header := FND_API.G_MISS_CHAR;
638: x_list_type := FND_API.G_MISS_CHAR;

Line 635: x_discount_lines := FND_API.G_MISS_CHAR;

631: x_start_date_active := FND_API.G_MISS_DATE;
632: x_terms_id := FND_API.G_MISS_NUM;
633: x_automatic := FND_API.G_MISS_CHAR;
634: x_currency := FND_API.G_MISS_CHAR;
635: x_discount_lines := FND_API.G_MISS_CHAR;
636: x_freight_terms := FND_API.G_MISS_CHAR;
637: x_list_header := FND_API.G_MISS_CHAR;
638: x_list_type := FND_API.G_MISS_CHAR;
639: x_prorate := FND_API.G_MISS_CHAR;

Line 636: x_freight_terms := FND_API.G_MISS_CHAR;

632: x_terms_id := FND_API.G_MISS_NUM;
633: x_automatic := FND_API.G_MISS_CHAR;
634: x_currency := FND_API.G_MISS_CHAR;
635: x_discount_lines := FND_API.G_MISS_CHAR;
636: x_freight_terms := FND_API.G_MISS_CHAR;
637: x_list_header := FND_API.G_MISS_CHAR;
638: x_list_type := FND_API.G_MISS_CHAR;
639: x_prorate := FND_API.G_MISS_CHAR;
640: x_ship_method := FND_API.G_MISS_CHAR;

Line 637: x_list_header := FND_API.G_MISS_CHAR;

633: x_automatic := FND_API.G_MISS_CHAR;
634: x_currency := FND_API.G_MISS_CHAR;
635: x_discount_lines := FND_API.G_MISS_CHAR;
636: x_freight_terms := FND_API.G_MISS_CHAR;
637: x_list_header := FND_API.G_MISS_CHAR;
638: x_list_type := FND_API.G_MISS_CHAR;
639: x_prorate := FND_API.G_MISS_CHAR;
640: x_ship_method := FND_API.G_MISS_CHAR;
641: x_terms := FND_API.G_MISS_CHAR;

Line 638: x_list_type := FND_API.G_MISS_CHAR;

634: x_currency := FND_API.G_MISS_CHAR;
635: x_discount_lines := FND_API.G_MISS_CHAR;
636: x_freight_terms := FND_API.G_MISS_CHAR;
637: x_list_header := FND_API.G_MISS_CHAR;
638: x_list_type := FND_API.G_MISS_CHAR;
639: x_prorate := FND_API.G_MISS_CHAR;
640: x_ship_method := FND_API.G_MISS_CHAR;
641: x_terms := FND_API.G_MISS_CHAR;
642: x_name := FND_API.G_MISS_CHAR;

Line 639: x_prorate := FND_API.G_MISS_CHAR;

635: x_discount_lines := FND_API.G_MISS_CHAR;
636: x_freight_terms := FND_API.G_MISS_CHAR;
637: x_list_header := FND_API.G_MISS_CHAR;
638: x_list_type := FND_API.G_MISS_CHAR;
639: x_prorate := FND_API.G_MISS_CHAR;
640: x_ship_method := FND_API.G_MISS_CHAR;
641: x_terms := FND_API.G_MISS_CHAR;
642: x_name := FND_API.G_MISS_CHAR;
643: x_description := FND_API.G_MISS_CHAR;

Line 640: x_ship_method := FND_API.G_MISS_CHAR;

636: x_freight_terms := FND_API.G_MISS_CHAR;
637: x_list_header := FND_API.G_MISS_CHAR;
638: x_list_type := FND_API.G_MISS_CHAR;
639: x_prorate := FND_API.G_MISS_CHAR;
640: x_ship_method := FND_API.G_MISS_CHAR;
641: x_terms := FND_API.G_MISS_CHAR;
642: x_name := FND_API.G_MISS_CHAR;
643: x_description := FND_API.G_MISS_CHAR;
644: x_version_no := FND_API.G_MISS_CHAR;

Line 641: x_terms := FND_API.G_MISS_CHAR;

637: x_list_header := FND_API.G_MISS_CHAR;
638: x_list_type := FND_API.G_MISS_CHAR;
639: x_prorate := FND_API.G_MISS_CHAR;
640: x_ship_method := FND_API.G_MISS_CHAR;
641: x_terms := FND_API.G_MISS_CHAR;
642: x_name := FND_API.G_MISS_CHAR;
643: x_description := FND_API.G_MISS_CHAR;
644: x_version_no := FND_API.G_MISS_CHAR;
645: x_active_flag :=FND_API.G_MISS_CHAR;

Line 642: x_name := FND_API.G_MISS_CHAR;

638: x_list_type := FND_API.G_MISS_CHAR;
639: x_prorate := FND_API.G_MISS_CHAR;
640: x_ship_method := FND_API.G_MISS_CHAR;
641: x_terms := FND_API.G_MISS_CHAR;
642: x_name := FND_API.G_MISS_CHAR;
643: x_description := FND_API.G_MISS_CHAR;
644: x_version_no := FND_API.G_MISS_CHAR;
645: x_active_flag :=FND_API.G_MISS_CHAR;
646: x_mobile_download :=FND_API.G_MISS_CHAR; -- mkarya for bug 1944882

Line 643: x_description := FND_API.G_MISS_CHAR;

639: x_prorate := FND_API.G_MISS_CHAR;
640: x_ship_method := FND_API.G_MISS_CHAR;
641: x_terms := FND_API.G_MISS_CHAR;
642: x_name := FND_API.G_MISS_CHAR;
643: x_description := FND_API.G_MISS_CHAR;
644: x_version_no := FND_API.G_MISS_CHAR;
645: x_active_flag :=FND_API.G_MISS_CHAR;
646: x_mobile_download :=FND_API.G_MISS_CHAR; -- mkarya for bug 1944882
647: x_currency_header :=FND_API.G_MISS_CHAR; -- Multi-Currency SunilPandey

Line 644: x_version_no := FND_API.G_MISS_CHAR;

640: x_ship_method := FND_API.G_MISS_CHAR;
641: x_terms := FND_API.G_MISS_CHAR;
642: x_name := FND_API.G_MISS_CHAR;
643: x_description := FND_API.G_MISS_CHAR;
644: x_version_no := FND_API.G_MISS_CHAR;
645: x_active_flag :=FND_API.G_MISS_CHAR;
646: x_mobile_download :=FND_API.G_MISS_CHAR; -- mkarya for bug 1944882
647: x_currency_header :=FND_API.G_MISS_CHAR; -- Multi-Currency SunilPandey
648: x_currency_header_id :=FND_API.G_MISS_NUM; -- Multi-Currency SunilPandey

Line 645: x_active_flag :=FND_API.G_MISS_CHAR;

641: x_terms := FND_API.G_MISS_CHAR;
642: x_name := FND_API.G_MISS_CHAR;
643: x_description := FND_API.G_MISS_CHAR;
644: x_version_no := FND_API.G_MISS_CHAR;
645: x_active_flag :=FND_API.G_MISS_CHAR;
646: x_mobile_download :=FND_API.G_MISS_CHAR; -- mkarya for bug 1944882
647: x_currency_header :=FND_API.G_MISS_CHAR; -- Multi-Currency SunilPandey
648: x_currency_header_id :=FND_API.G_MISS_NUM; -- Multi-Currency SunilPandey
649: x_pte_code :=FND_API.G_MISS_CHAR; -- Attribute Manager Giri

Line 646: x_mobile_download :=FND_API.G_MISS_CHAR; -- mkarya for bug 1944882

642: x_name := FND_API.G_MISS_CHAR;
643: x_description := FND_API.G_MISS_CHAR;
644: x_version_no := FND_API.G_MISS_CHAR;
645: x_active_flag :=FND_API.G_MISS_CHAR;
646: x_mobile_download :=FND_API.G_MISS_CHAR; -- mkarya for bug 1944882
647: x_currency_header :=FND_API.G_MISS_CHAR; -- Multi-Currency SunilPandey
648: x_currency_header_id :=FND_API.G_MISS_NUM; -- Multi-Currency SunilPandey
649: x_pte_code :=FND_API.G_MISS_CHAR; -- Attribute Manager Giri
650: x_pte :=FND_API.G_MISS_CHAR; -- Attribute Manager Giri

Line 647: x_currency_header :=FND_API.G_MISS_CHAR; -- Multi-Currency SunilPandey

643: x_description := FND_API.G_MISS_CHAR;
644: x_version_no := FND_API.G_MISS_CHAR;
645: x_active_flag :=FND_API.G_MISS_CHAR;
646: x_mobile_download :=FND_API.G_MISS_CHAR; -- mkarya for bug 1944882
647: x_currency_header :=FND_API.G_MISS_CHAR; -- Multi-Currency SunilPandey
648: x_currency_header_id :=FND_API.G_MISS_NUM; -- Multi-Currency SunilPandey
649: x_pte_code :=FND_API.G_MISS_CHAR; -- Attribute Manager Giri
650: x_pte :=FND_API.G_MISS_CHAR; -- Attribute Manager Giri
651: x_list_source_code :=FND_API.G_MISS_CHAR; -- Blanket Sales Order

Line 648: x_currency_header_id :=FND_API.G_MISS_NUM; -- Multi-Currency SunilPandey

644: x_version_no := FND_API.G_MISS_CHAR;
645: x_active_flag :=FND_API.G_MISS_CHAR;
646: x_mobile_download :=FND_API.G_MISS_CHAR; -- mkarya for bug 1944882
647: x_currency_header :=FND_API.G_MISS_CHAR; -- Multi-Currency SunilPandey
648: x_currency_header_id :=FND_API.G_MISS_NUM; -- Multi-Currency SunilPandey
649: x_pte_code :=FND_API.G_MISS_CHAR; -- Attribute Manager Giri
650: x_pte :=FND_API.G_MISS_CHAR; -- Attribute Manager Giri
651: x_list_source_code :=FND_API.G_MISS_CHAR; -- Blanket Sales Order
652: x_orig_system_header_ref :=FND_API.G_MISS_CHAR; -- Blanket Sales Order

Line 649: x_pte_code :=FND_API.G_MISS_CHAR; -- Attribute Manager Giri

645: x_active_flag :=FND_API.G_MISS_CHAR;
646: x_mobile_download :=FND_API.G_MISS_CHAR; -- mkarya for bug 1944882
647: x_currency_header :=FND_API.G_MISS_CHAR; -- Multi-Currency SunilPandey
648: x_currency_header_id :=FND_API.G_MISS_NUM; -- Multi-Currency SunilPandey
649: x_pte_code :=FND_API.G_MISS_CHAR; -- Attribute Manager Giri
650: x_pte :=FND_API.G_MISS_CHAR; -- Attribute Manager Giri
651: x_list_source_code :=FND_API.G_MISS_CHAR; -- Blanket Sales Order
652: x_orig_system_header_ref :=FND_API.G_MISS_CHAR; -- Blanket Sales Order
653: x_global_flag :=FND_API.G_MISS_CHAR; -- Pricing Security gtippire

Line 650: x_pte :=FND_API.G_MISS_CHAR; -- Attribute Manager Giri

646: x_mobile_download :=FND_API.G_MISS_CHAR; -- mkarya for bug 1944882
647: x_currency_header :=FND_API.G_MISS_CHAR; -- Multi-Currency SunilPandey
648: x_currency_header_id :=FND_API.G_MISS_NUM; -- Multi-Currency SunilPandey
649: x_pte_code :=FND_API.G_MISS_CHAR; -- Attribute Manager Giri
650: x_pte :=FND_API.G_MISS_CHAR; -- Attribute Manager Giri
651: x_list_source_code :=FND_API.G_MISS_CHAR; -- Blanket Sales Order
652: x_orig_system_header_ref :=FND_API.G_MISS_CHAR; -- Blanket Sales Order
653: x_global_flag :=FND_API.G_MISS_CHAR; -- Pricing Security gtippire
654: x_source_system_code := FND_API.G_MISS_CHAR;

Line 651: x_list_source_code :=FND_API.G_MISS_CHAR; -- Blanket Sales Order

647: x_currency_header :=FND_API.G_MISS_CHAR; -- Multi-Currency SunilPandey
648: x_currency_header_id :=FND_API.G_MISS_NUM; -- Multi-Currency SunilPandey
649: x_pte_code :=FND_API.G_MISS_CHAR; -- Attribute Manager Giri
650: x_pte :=FND_API.G_MISS_CHAR; -- Attribute Manager Giri
651: x_list_source_code :=FND_API.G_MISS_CHAR; -- Blanket Sales Order
652: x_orig_system_header_ref :=FND_API.G_MISS_CHAR; -- Blanket Sales Order
653: x_global_flag :=FND_API.G_MISS_CHAR; -- Pricing Security gtippire
654: x_source_system_code := FND_API.G_MISS_CHAR;
655: x_shareable_flag := FND_API.G_MISS_CHAR;

Line 652: x_orig_system_header_ref :=FND_API.G_MISS_CHAR; -- Blanket Sales Order

648: x_currency_header_id :=FND_API.G_MISS_NUM; -- Multi-Currency SunilPandey
649: x_pte_code :=FND_API.G_MISS_CHAR; -- Attribute Manager Giri
650: x_pte :=FND_API.G_MISS_CHAR; -- Attribute Manager Giri
651: x_list_source_code :=FND_API.G_MISS_CHAR; -- Blanket Sales Order
652: x_orig_system_header_ref :=FND_API.G_MISS_CHAR; -- Blanket Sales Order
653: x_global_flag :=FND_API.G_MISS_CHAR; -- Pricing Security gtippire
654: x_source_system_code := FND_API.G_MISS_CHAR;
655: x_shareable_flag := FND_API.G_MISS_CHAR;
656: x_sold_to_org_id := FND_API.G_MISS_NUM;

Line 653: x_global_flag :=FND_API.G_MISS_CHAR; -- Pricing Security gtippire

649: x_pte_code :=FND_API.G_MISS_CHAR; -- Attribute Manager Giri
650: x_pte :=FND_API.G_MISS_CHAR; -- Attribute Manager Giri
651: x_list_source_code :=FND_API.G_MISS_CHAR; -- Blanket Sales Order
652: x_orig_system_header_ref :=FND_API.G_MISS_CHAR; -- Blanket Sales Order
653: x_global_flag :=FND_API.G_MISS_CHAR; -- Pricing Security gtippire
654: x_source_system_code := FND_API.G_MISS_CHAR;
655: x_shareable_flag := FND_API.G_MISS_CHAR;
656: x_sold_to_org_id := FND_API.G_MISS_NUM;
657: x_locked_from_list_header_id := FND_API.G_MISS_NUM;

Line 654: x_source_system_code := FND_API.G_MISS_CHAR;

650: x_pte :=FND_API.G_MISS_CHAR; -- Attribute Manager Giri
651: x_list_source_code :=FND_API.G_MISS_CHAR; -- Blanket Sales Order
652: x_orig_system_header_ref :=FND_API.G_MISS_CHAR; -- Blanket Sales Order
653: x_global_flag :=FND_API.G_MISS_CHAR; -- Pricing Security gtippire
654: x_source_system_code := FND_API.G_MISS_CHAR;
655: x_shareable_flag := FND_API.G_MISS_CHAR;
656: x_sold_to_org_id := FND_API.G_MISS_NUM;
657: x_locked_from_list_header_id := FND_API.G_MISS_NUM;
658: --added for MOAC

Line 655: x_shareable_flag := FND_API.G_MISS_CHAR;

651: x_list_source_code :=FND_API.G_MISS_CHAR; -- Blanket Sales Order
652: x_orig_system_header_ref :=FND_API.G_MISS_CHAR; -- Blanket Sales Order
653: x_global_flag :=FND_API.G_MISS_CHAR; -- Pricing Security gtippire
654: x_source_system_code := FND_API.G_MISS_CHAR;
655: x_shareable_flag := FND_API.G_MISS_CHAR;
656: x_sold_to_org_id := FND_API.G_MISS_NUM;
657: x_locked_from_list_header_id := FND_API.G_MISS_NUM;
658: --added for MOAC
659: x_org_id := FND_API.G_MISS_NUM;

Line 656: x_sold_to_org_id := FND_API.G_MISS_NUM;

652: x_orig_system_header_ref :=FND_API.G_MISS_CHAR; -- Blanket Sales Order
653: x_global_flag :=FND_API.G_MISS_CHAR; -- Pricing Security gtippire
654: x_source_system_code := FND_API.G_MISS_CHAR;
655: x_shareable_flag := FND_API.G_MISS_CHAR;
656: x_sold_to_org_id := FND_API.G_MISS_NUM;
657: x_locked_from_list_header_id := FND_API.G_MISS_NUM;
658: --added for MOAC
659: x_org_id := FND_API.G_MISS_NUM;
660:

Line 657: x_locked_from_list_header_id := FND_API.G_MISS_NUM;

653: x_global_flag :=FND_API.G_MISS_CHAR; -- Pricing Security gtippire
654: x_source_system_code := FND_API.G_MISS_CHAR;
655: x_shareable_flag := FND_API.G_MISS_CHAR;
656: x_sold_to_org_id := FND_API.G_MISS_NUM;
657: x_locked_from_list_header_id := FND_API.G_MISS_NUM;
658: --added for MOAC
659: x_org_id := FND_API.G_MISS_NUM;
660:
661: -- Load display out parameters if any

Line 659: x_org_id := FND_API.G_MISS_NUM;

655: x_shareable_flag := FND_API.G_MISS_CHAR;
656: x_sold_to_org_id := FND_API.G_MISS_NUM;
657: x_locked_from_list_header_id := FND_API.G_MISS_NUM;
658: --added for MOAC
659: x_org_id := FND_API.G_MISS_NUM;
660:
661: -- Load display out parameters if any
662:
663: l_PRICE_LIST_val_rec := QP_Price_List_Util.Get_Values

Line 961: x_return_status := FND_API.G_RET_STS_SUCCESS;

957: );
958:
959: -- Set return status.
960:
961: x_return_status := FND_API.G_RET_STS_SUCCESS;
962:
963: -- Get message count and data
964:
965: oe_msg_pub.Count_And_Get

Line 973: WHEN FND_API.G_EXC_ERROR THEN

969:
970:
971: EXCEPTION
972:
973: WHEN FND_API.G_EXC_ERROR THEN
974:
975: x_return_status := FND_API.G_RET_STS_ERROR;
976:
977: -- Get message count and data

Line 975: x_return_status := FND_API.G_RET_STS_ERROR;

971: EXCEPTION
972:
973: WHEN FND_API.G_EXC_ERROR THEN
974:
975: x_return_status := FND_API.G_RET_STS_ERROR;
976:
977: -- Get message count and data
978:
979: oe_msg_pub.Count_And_Get

Line 984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

980: ( p_count => x_msg_count
981: , p_data => x_msg_data
982: );
983:
984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
985:
986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
987:
988: -- Get message count and data

Line 986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

982: );
983:
984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
985:
986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
987:
988: -- Get message count and data
989:
990: oe_msg_pub.Count_And_Get

Line 997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

993: );
994:
995: WHEN OTHERS THEN
996:
997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
998:
999: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1000: THEN
1001: oe_msg_pub.Add_Exc_Msg

Line 1077: IF FND_API.To_Boolean(l_PRICE_LIST_rec.db_flag) THEN

1073: );
1074:
1075: -- Set Operation.
1076:
1077: IF FND_API.To_Boolean(l_PRICE_LIST_rec.db_flag) THEN
1078: l_PRICE_LIST_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
1079: ELSE
1080: l_PRICE_LIST_rec.operation := QP_GLOBALS.G_OPR_CREATE;
1081: END IF;

Line 1087: , p_init_msg_list => FND_API.G_TRUE

1083: -- Call QP_LIST_HEADERS_PVT.Process_PRICE_LIST
1084:
1085: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
1086: ( p_api_version_number => 1.0
1087: , p_init_msg_list => FND_API.G_TRUE
1088: , x_return_status => l_return_status
1089: , x_msg_count => x_msg_count
1090: , x_msg_data => x_msg_data
1091: , p_control_rec => l_control_rec

Line 1100: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1096: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1097: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1098: );
1099:
1100: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1102: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1103: RAISE FND_API.G_EXC_ERROR;
1104: END IF;

Line 1101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1097: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1098: );
1099:
1100: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1102: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1103: RAISE FND_API.G_EXC_ERROR;
1104: END IF;
1105:

Line 1102: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1098: );
1099:
1100: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1102: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1103: RAISE FND_API.G_EXC_ERROR;
1104: END IF;
1105:
1106:

Line 1103: RAISE FND_API.G_EXC_ERROR;

1099:
1100: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1101: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1102: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1103: RAISE FND_API.G_EXC_ERROR;
1104: END IF;
1105:
1106:
1107: -- Load OUT parameters.

Line 1131: x_return_status := FND_API.G_RET_STS_SUCCESS;

1127:
1128:
1129: -- Set return status.
1130:
1131: x_return_status := FND_API.G_RET_STS_SUCCESS;
1132:
1133: -- Get message count and data
1134:
1135: oe_msg_pub.Count_And_Get

Line 1143: WHEN FND_API.G_EXC_ERROR THEN

1139:
1140:
1141: EXCEPTION
1142:
1143: WHEN FND_API.G_EXC_ERROR THEN
1144:
1145: x_return_status := FND_API.G_RET_STS_ERROR;
1146:
1147: -- Get message count and data

Line 1145: x_return_status := FND_API.G_RET_STS_ERROR;

1141: EXCEPTION
1142:
1143: WHEN FND_API.G_EXC_ERROR THEN
1144:
1145: x_return_status := FND_API.G_RET_STS_ERROR;
1146:
1147: -- Get message count and data
1148:
1149: oe_msg_pub.Count_And_Get

Line 1154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1150: ( p_count => x_msg_count
1151: , p_data => x_msg_data
1152: );
1153:
1154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1155:
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1157:
1158: -- Get message count and data

Line 1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1152: );
1153:
1154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1155:
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1157:
1158: -- Get message count and data
1159:
1160: oe_msg_pub.Count_And_Get

Line 1167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1163: );
1164:
1165: WHEN OTHERS THEN
1166:
1167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1168:
1169: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1170: THEN
1171: oe_msg_pub.Add_Exc_Msg

Line 1238: , p_init_msg_list => FND_API.G_TRUE

1234: -- Call QP_LIST_HEADERS_PVT.Process_PRICE_LIST
1235:
1236: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
1237: ( p_api_version_number => 1.0
1238: , p_init_msg_list => FND_API.G_TRUE
1239: , x_return_status => l_return_status
1240: , x_msg_count => x_msg_count
1241: , x_msg_data => x_msg_data
1242: , p_control_rec => l_control_rec

Line 1250: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1246: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1247: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1248: );
1249:
1250: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1252: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1253: RAISE FND_API.G_EXC_ERROR;
1254: END IF;

Line 1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1247: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1248: );
1249:
1250: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1252: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1253: RAISE FND_API.G_EXC_ERROR;
1254: END IF;
1255:

Line 1252: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1248: );
1249:
1250: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1252: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1253: RAISE FND_API.G_EXC_ERROR;
1254: END IF;
1255:
1256:

Line 1253: RAISE FND_API.G_EXC_ERROR;

1249:
1250: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1251: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1252: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1253: RAISE FND_API.G_EXC_ERROR;
1254: END IF;
1255:
1256:
1257: -- Clear PRICE_LIST record cache

Line 1263: x_return_status := FND_API.G_RET_STS_SUCCESS;

1259: Clear_PRICE_LIST;
1260:
1261: -- Set return status.
1262:
1263: x_return_status := FND_API.G_RET_STS_SUCCESS;
1264:
1265: -- Get message count and data
1266:
1267: oe_msg_pub.Count_And_Get

Line 1275: WHEN FND_API.G_EXC_ERROR THEN

1271:
1272:
1273: EXCEPTION
1274:
1275: WHEN FND_API.G_EXC_ERROR THEN
1276:
1277: x_return_status := FND_API.G_RET_STS_ERROR;
1278:
1279: -- Get message count and data

Line 1277: x_return_status := FND_API.G_RET_STS_ERROR;

1273: EXCEPTION
1274:
1275: WHEN FND_API.G_EXC_ERROR THEN
1276:
1277: x_return_status := FND_API.G_RET_STS_ERROR;
1278:
1279: -- Get message count and data
1280:
1281: oe_msg_pub.Count_And_Get

Line 1286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1282: ( p_count => x_msg_count
1283: , p_data => x_msg_data
1284: );
1285:
1286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1287:
1288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1289:
1290: -- Get message count and data

Line 1288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1284: );
1285:
1286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1287:
1288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1289:
1290: -- Get message count and data
1291:
1292: oe_msg_pub.Count_And_Get

Line 1299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1295: );
1296:
1297: WHEN OTHERS THEN
1298:
1299: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1300:
1301: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1302: THEN
1303: oe_msg_pub.Add_Exc_Msg

Line 1358: , p_init_msg_list => FND_API.G_TRUE

1354: -- Call QP_LIST_HEADERS_PVT.Process_PRICE_LIST
1355:
1356: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
1357: ( p_api_version_number => 1.0
1358: , p_init_msg_list => FND_API.G_TRUE
1359: , x_return_status => l_return_status
1360: , x_msg_count => x_msg_count
1361: , x_msg_data => x_msg_data
1362: , p_control_rec => l_control_rec

Line 1369: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1365: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1366: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1367: );
1368:
1369: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1371: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1372: RAISE FND_API.G_EXC_ERROR;
1373: END IF;

Line 1370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1366: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1367: );
1368:
1369: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1371: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1372: RAISE FND_API.G_EXC_ERROR;
1373: END IF;
1374:

Line 1371: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1367: );
1368:
1369: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1371: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1372: RAISE FND_API.G_EXC_ERROR;
1373: END IF;
1374:
1375:

Line 1372: RAISE FND_API.G_EXC_ERROR;

1368:
1369: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1371: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1372: RAISE FND_API.G_EXC_ERROR;
1373: END IF;
1374:
1375:
1376: -- Set return status.

Line 1378: x_return_status := FND_API.G_RET_STS_SUCCESS;

1374:
1375:
1376: -- Set return status.
1377:
1378: x_return_status := FND_API.G_RET_STS_SUCCESS;
1379:
1380: -- Get message count and data
1381:
1382: oe_msg_pub.Count_And_Get

Line 1390: WHEN FND_API.G_EXC_ERROR THEN

1386:
1387:
1388: EXCEPTION
1389:
1390: WHEN FND_API.G_EXC_ERROR THEN
1391:
1392: x_return_status := FND_API.G_RET_STS_ERROR;
1393:
1394: -- Get message count and data

Line 1392: x_return_status := FND_API.G_RET_STS_ERROR;

1388: EXCEPTION
1389:
1390: WHEN FND_API.G_EXC_ERROR THEN
1391:
1392: x_return_status := FND_API.G_RET_STS_ERROR;
1393:
1394: -- Get message count and data
1395:
1396: oe_msg_pub.Count_And_Get

Line 1401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1397: ( p_count => x_msg_count
1398: , p_data => x_msg_data
1399: );
1400:
1401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1402:
1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1404:
1405: -- Get message count and data

Line 1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1399: );
1400:
1401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1402:
1403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1404:
1405: -- Get message count and data
1406:
1407: oe_msg_pub.Count_And_Get

Line 1414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1410: );
1411:
1412: WHEN OTHERS THEN
1413:
1414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1415:
1416: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1417: THEN
1418: oe_msg_pub.Add_Exc_Msg

Line 1473: , p_init_msg_list => FND_API.G_TRUE

1469: -- Call QP_LIST_HEADERS_PVT.Process_PRICE_LIST
1470:
1471: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
1472: ( p_api_version_number => 1.0
1473: , p_init_msg_list => FND_API.G_TRUE
1474: , x_return_status => l_return_status
1475: , x_msg_count => x_msg_count
1476: , x_msg_data => x_msg_data
1477: , p_control_rec => l_control_rec

Line 1484: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1480: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1481: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1482: );
1483:
1484: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1486: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1487: RAISE FND_API.G_EXC_ERROR;
1488: END IF;

Line 1485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1481: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1482: );
1483:
1484: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1486: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1487: RAISE FND_API.G_EXC_ERROR;
1488: END IF;
1489:

Line 1486: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1482: );
1483:
1484: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1486: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1487: RAISE FND_API.G_EXC_ERROR;
1488: END IF;
1489:
1490:

Line 1487: RAISE FND_API.G_EXC_ERROR;

1483:
1484: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1486: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1487: RAISE FND_API.G_EXC_ERROR;
1488: END IF;
1489:
1490:
1491: -- Set return status.

Line 1493: x_return_status := FND_API.G_RET_STS_SUCCESS;

1489:
1490:
1491: -- Set return status.
1492:
1493: x_return_status := FND_API.G_RET_STS_SUCCESS;
1494:
1495: -- Get message count and data
1496:
1497: oe_msg_pub.Count_And_Get

Line 1505: WHEN FND_API.G_EXC_ERROR THEN

1501:
1502:
1503: EXCEPTION
1504:
1505: WHEN FND_API.G_EXC_ERROR THEN
1506:
1507: x_return_status := FND_API.G_RET_STS_ERROR;
1508:
1509: -- Get message count and data

Line 1507: x_return_status := FND_API.G_RET_STS_ERROR;

1503: EXCEPTION
1504:
1505: WHEN FND_API.G_EXC_ERROR THEN
1506:
1507: x_return_status := FND_API.G_RET_STS_ERROR;
1508:
1509: -- Get message count and data
1510:
1511: oe_msg_pub.Count_And_Get

Line 1516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1512: ( p_count => x_msg_count
1513: , p_data => x_msg_data
1514: );
1515:
1516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1517:
1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1519:
1520: -- Get message count and data

Line 1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1514: );
1515:
1516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1517:
1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1519:
1520: -- Get message count and data
1521:
1522: oe_msg_pub.Count_And_Get

Line 1529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1525: );
1526:
1527: WHEN OTHERS THEN
1528:
1529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1530:
1531: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1532: THEN
1533: oe_msg_pub.Add_Exc_Msg

Line 1601: , p_list_source_code IN VARCHAR2 := NULL--FND_API.G_MISS_CHAR--NULL -- Blanket Sales Order

1597: , p_active_flag IN VARCHAR2
1598: , p_mobile_download IN VARCHAR2 -- mkarya for bug 1944882
1599: , p_currency_header_id IN NUMBER -- Multi-Currency SunilPandey
1600: , p_pte_code IN VARCHAR2 := NULL -- Attribute Manager Giri
1601: , p_list_source_code IN VARCHAR2 := NULL--FND_API.G_MISS_CHAR--NULL -- Blanket Sales Order
1602: , p_orig_system_header_ref IN VARCHAR2 := NULL--FND_API.G_MISS_CHAR--NULL -- Blanket Sales Order
1603: , p_global_flag IN VARCHAR2 -- Pricing Security gtippire
1604: , p_source_system_code IN VARCHAR2
1605: , p_shareable_flag IN VARCHAR2 := NULL

Line 1602: , p_orig_system_header_ref IN VARCHAR2 := NULL--FND_API.G_MISS_CHAR--NULL -- Blanket Sales Order

1598: , p_mobile_download IN VARCHAR2 -- mkarya for bug 1944882
1599: , p_currency_header_id IN NUMBER -- Multi-Currency SunilPandey
1600: , p_pte_code IN VARCHAR2 := NULL -- Attribute Manager Giri
1601: , p_list_source_code IN VARCHAR2 := NULL--FND_API.G_MISS_CHAR--NULL -- Blanket Sales Order
1602: , p_orig_system_header_ref IN VARCHAR2 := NULL--FND_API.G_MISS_CHAR--NULL -- Blanket Sales Order
1603: , p_global_flag IN VARCHAR2 -- Pricing Security gtippire
1604: , p_source_system_code IN VARCHAR2
1605: , p_shareable_flag IN VARCHAR2 := NULL
1606: , p_sold_to_org_id IN NUMBER := NULL

Line 1692: , p_init_msg_list => FND_API.G_TRUE

1688: -- Call QP_LIST_HEADERS_PVT.Lock_PRICE_LIST
1689:
1690: QP_LIST_HEADERS_PVT.Lock_PRICE_LIST
1691: ( p_api_version_number => 1.0
1692: , p_init_msg_list => FND_API.G_TRUE
1693: , x_return_status => l_return_status
1694: , x_msg_count => x_msg_count
1695: , x_msg_data => x_msg_data
1696: , p_PRICE_LIST_rec => l_PRICE_LIST_rec

Line 1703: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1699: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1700: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1701: );
1702:
1703: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1704:
1705: -- Set DB flag and write record to cache.
1706:
1707: l_x_PRICE_LIST_rec.db_flag := FND_API.G_TRUE;

Line 1707: l_x_PRICE_LIST_rec.db_flag := FND_API.G_TRUE;

1703: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1704:
1705: -- Set DB flag and write record to cache.
1706:
1707: l_x_PRICE_LIST_rec.db_flag := FND_API.G_TRUE;
1708:
1709: Write_PRICE_LIST
1710: ( p_PRICE_LIST_rec => l_x_PRICE_LIST_rec
1711: , p_db_record => TRUE

Line 1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1736: , 'Lock_Row'
1737: );
1738: END IF;
1739:
1740: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1741:
1742: -- Get message count and data
1743:
1744: oe_msg_pub.Count_And_Get

Line 1789: g_PRICE_LIST_rec.db_flag := FND_API.G_TRUE;

1785: g_PRICE_LIST_rec := QP_Price_List_Util.Query_Row
1786: ( p_list_header_id => p_list_header_id
1787: );
1788:
1789: g_PRICE_LIST_rec.db_flag := FND_API.G_TRUE;
1790:
1791: -- Load DB record
1792:
1793: g_db_PRICE_LIST_rec := g_PRICE_LIST_rec;

Line 1828: x_return_status := FND_API.G_RET_STS_SUCCESS;

1824: IS
1825: l_return_status Varchar2(30);
1826: BEGIN
1827: OE_MSG_PUB.initialize;
1828: x_return_status := FND_API.G_RET_STS_SUCCESS;
1829: QP_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
1830: p_entity_code => QP_GLOBALS.G_ENTITY_PRICE_LIST
1831: ,p_entity_id => p_list_header_id
1832: ,x_return_status => l_return_status);

Line 1856: x_return_status := FND_API.G_RET_STS_ERROR;

1852: OE_MSG_PUB.Count_And_Get
1853: ( p_count => x_msg_count
1854: , p_data => x_msg_data
1855: );
1856: x_return_status := FND_API.G_RET_STS_ERROR;
1857:
1858: END Clear_Record;
1859:
1860:

Line 1873: x_return_status := FND_API.G_RET_STS_SUCCESS;

1869: IS
1870: l_return_status Varchar2(30);
1871: BEGIN
1872: OE_MSG_PUB.initialize;
1873: x_return_status := FND_API.G_RET_STS_SUCCESS;
1874: QP_DELAYED_REQUESTS_PVT.Clear_Request(
1875: x_return_status => l_return_status);
1876:
1877: EXCEPTION

Line 1891: x_return_status := FND_API.G_RET_STS_ERROR;

1887: OE_MSG_PUB.Count_And_Get
1888: ( p_count => x_msg_count
1889: , p_data => x_msg_data
1890: );
1891: x_return_status := FND_API.G_RET_STS_ERROR;
1892:
1893: END Delete_All_Requests;
1894:
1895: