DBA Data[Home] [Help]

APPS.QP_QP_FORM_MODIFIER_LIST dependencies on FND_API

Line 160: , p_init_msg_list => FND_API.G_TRUE

156: -- Call QP_Modifiers_PVT.Process_MODIFIERS
157:
158: QP_Modifiers_PVT.Process_MODIFIERS
159: ( p_api_version_number => 1.0
160: , p_init_msg_list => FND_API.G_TRUE
161: , x_return_status => l_return_status
162: , x_msg_count => x_msg_count
163: , x_msg_data => x_msg_data
164: , p_control_rec => l_control_rec

Line 172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

168: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
169: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
170: );
171:
172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
174: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
175: RAISE FND_API.G_EXC_ERROR;
176: END IF;

Line 173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

169: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
170: );
171:
172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
174: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
175: RAISE FND_API.G_EXC_ERROR;
176: END IF;
177:

Line 174: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

170: );
171:
172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
174: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
175: RAISE FND_API.G_EXC_ERROR;
176: END IF;
177:
178:

Line 175: RAISE FND_API.G_EXC_ERROR;

171:
172: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
174: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
175: RAISE FND_API.G_EXC_ERROR;
176: END IF;
177:
178:
179: -- Load OUT parameters.

Line 251: l_x_MODIFIER_LIST_rec.db_flag := FND_API.G_FALSE;

247:
248: -- Write to cache.
249: -- Set db_flag to False before writing to cache
250:
251: l_x_MODIFIER_LIST_rec.db_flag := FND_API.G_FALSE;
252:
253: Write_MODIFIER_LIST
254: ( p_MODIFIER_LIST_rec => l_x_MODIFIER_LIST_rec
255: );

Line 259: x_return_status := FND_API.G_RET_STS_SUCCESS;

255: );
256:
257: -- Set return status.
258:
259: x_return_status := FND_API.G_RET_STS_SUCCESS;
260:
261: -- Get message count and data
262:
263: OE_MSG_PUB.Count_And_Get

Line 271: WHEN FND_API.G_EXC_ERROR THEN

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

Line 273: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

291: );
292:
293: WHEN OTHERS THEN
294:
295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
296:
297: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
298: THEN
299: OE_MSG_PUB.Add_Exc_Msg

Line 559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

555: , 'Unrecognized attribute'
556: );
557: END IF;
558:
559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560:
561: END IF;
562:
563: -- Set Operation.

Line 565: IF FND_API.To_Boolean(l_MODIFIER_LIST_rec.db_flag) THEN

561: END IF;
562:
563: -- Set Operation.
564:
565: IF FND_API.To_Boolean(l_MODIFIER_LIST_rec.db_flag) THEN
566: l_MODIFIER_LIST_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
567: ELSE
568: l_MODIFIER_LIST_rec.operation := QP_GLOBALS.G_OPR_CREATE;
569: END IF;

Line 578: , p_init_msg_list => FND_API.G_TRUE

574: oe_debug_pub.add('curr in QPXF = ' || l_MODIFIER_LIST_rec.currency_code);
575:
576: QP_Modifiers_PVT.Process_MODIFIERS
577: ( p_api_version_number => 1.0
578: , p_init_msg_list => FND_API.G_TRUE
579: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
580: , x_return_status => l_return_status
581: , x_msg_count => x_msg_count
582: , x_msg_data => x_msg_data

Line 579: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

575:
576: QP_Modifiers_PVT.Process_MODIFIERS
577: ( p_api_version_number => 1.0
578: , p_init_msg_list => FND_API.G_TRUE
579: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
580: , x_return_status => l_return_status
581: , x_msg_count => x_msg_count
582: , x_msg_data => x_msg_data
583: , p_control_rec => l_control_rec

Line 595: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

591:
592: oe_debug_pub.add('name after QPXF = ' || l_x_MODIFIER_LIST_rec.name);
593: oe_debug_pub.add('curr after QPXF = ' || l_x_MODIFIER_LIST_rec.currency_code);
594:
595: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
597: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
598: RAISE FND_API.G_EXC_ERROR;
599: END IF;

Line 596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

592: oe_debug_pub.add('name after QPXF = ' || l_x_MODIFIER_LIST_rec.name);
593: oe_debug_pub.add('curr after QPXF = ' || l_x_MODIFIER_LIST_rec.currency_code);
594:
595: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
597: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
598: RAISE FND_API.G_EXC_ERROR;
599: END IF;
600:

Line 597: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

593: oe_debug_pub.add('curr after QPXF = ' || l_x_MODIFIER_LIST_rec.currency_code);
594:
595: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
596: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
597: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
598: RAISE FND_API.G_EXC_ERROR;
599: END IF;
600:
601:

Line 598: RAISE FND_API.G_EXC_ERROR;

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

Line 604: x_attribute1 := FND_API.G_MISS_CHAR;

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

Line 605: x_attribute10 := FND_API.G_MISS_CHAR;

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

Line 606: x_attribute11 := FND_API.G_MISS_CHAR;

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

Line 607: x_attribute12 := FND_API.G_MISS_CHAR;

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

Line 608: x_attribute13 := FND_API.G_MISS_CHAR;

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

Line 609: x_attribute14 := FND_API.G_MISS_CHAR;

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

Line 610: x_attribute15 := FND_API.G_MISS_CHAR;

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

Line 611: x_attribute2 := FND_API.G_MISS_CHAR;

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

Line 612: x_attribute3 := FND_API.G_MISS_CHAR;

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

Line 613: x_attribute4 := FND_API.G_MISS_CHAR;

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

Line 614: x_attribute5 := FND_API.G_MISS_CHAR;

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

Line 615: x_attribute6 := FND_API.G_MISS_CHAR;

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

Line 616: x_attribute7 := FND_API.G_MISS_CHAR;

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

Line 617: x_attribute8 := FND_API.G_MISS_CHAR;

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

Line 618: x_attribute9 := FND_API.G_MISS_CHAR;

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

Line 619: x_automatic_flag := FND_API.G_MISS_CHAR;

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

Line 620: x_comments := FND_API.G_MISS_CHAR;

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

Line 621: x_context := FND_API.G_MISS_CHAR;

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

Line 622: x_currency_code := FND_API.G_MISS_CHAR;

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

Line 623: x_discount_lines_flag := FND_API.G_MISS_CHAR;

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

Line 624: x_end_date_active := FND_API.G_MISS_DATE;

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

Line 625: x_freight_terms_code := FND_API.G_MISS_CHAR;

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

Line 626: x_gsa_indicator := FND_API.G_MISS_CHAR;

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

Line 627: x_list_header_id := FND_API.G_MISS_NUM;

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

Line 628: x_list_type_code := FND_API.G_MISS_CHAR;

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

Line 629: x_prorate_flag := FND_API.G_MISS_CHAR;

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

Line 630: x_rounding_factor := FND_API.G_MISS_NUM;

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

Line 631: x_ship_method_code := FND_API.G_MISS_CHAR;

627: x_list_header_id := FND_API.G_MISS_NUM;
628: x_list_type_code := FND_API.G_MISS_CHAR;
629: x_prorate_flag := FND_API.G_MISS_CHAR;
630: x_rounding_factor := FND_API.G_MISS_NUM;
631: x_ship_method_code := FND_API.G_MISS_CHAR;
632: x_start_date_active := FND_API.G_MISS_DATE;
633: x_terms_id := FND_API.G_MISS_NUM;
634: x_source_system_code := FND_API.G_MISS_CHAR;
635: x_pte_code := FND_API.G_MISS_CHAR;

Line 632: x_start_date_active := FND_API.G_MISS_DATE;

628: x_list_type_code := FND_API.G_MISS_CHAR;
629: x_prorate_flag := FND_API.G_MISS_CHAR;
630: x_rounding_factor := FND_API.G_MISS_NUM;
631: x_ship_method_code := FND_API.G_MISS_CHAR;
632: x_start_date_active := FND_API.G_MISS_DATE;
633: x_terms_id := FND_API.G_MISS_NUM;
634: x_source_system_code := FND_API.G_MISS_CHAR;
635: x_pte_code := FND_API.G_MISS_CHAR;
636: x_active_flag := FND_API.G_MISS_CHAR;

Line 633: x_terms_id := FND_API.G_MISS_NUM;

629: x_prorate_flag := FND_API.G_MISS_CHAR;
630: x_rounding_factor := FND_API.G_MISS_NUM;
631: x_ship_method_code := FND_API.G_MISS_CHAR;
632: x_start_date_active := FND_API.G_MISS_DATE;
633: x_terms_id := FND_API.G_MISS_NUM;
634: x_source_system_code := FND_API.G_MISS_CHAR;
635: x_pte_code := FND_API.G_MISS_CHAR;
636: x_active_flag := FND_API.G_MISS_CHAR;
637: x_parent_list_header_id := FND_API.G_MISS_NUM;

Line 634: x_source_system_code := FND_API.G_MISS_CHAR;

630: x_rounding_factor := FND_API.G_MISS_NUM;
631: x_ship_method_code := FND_API.G_MISS_CHAR;
632: x_start_date_active := FND_API.G_MISS_DATE;
633: x_terms_id := FND_API.G_MISS_NUM;
634: x_source_system_code := FND_API.G_MISS_CHAR;
635: x_pte_code := FND_API.G_MISS_CHAR;
636: x_active_flag := FND_API.G_MISS_CHAR;
637: x_parent_list_header_id := FND_API.G_MISS_NUM;
638: x_start_date_active_first := FND_API.G_MISS_DATE;

Line 635: x_pte_code := FND_API.G_MISS_CHAR;

631: x_ship_method_code := FND_API.G_MISS_CHAR;
632: x_start_date_active := FND_API.G_MISS_DATE;
633: x_terms_id := FND_API.G_MISS_NUM;
634: x_source_system_code := FND_API.G_MISS_CHAR;
635: x_pte_code := FND_API.G_MISS_CHAR;
636: x_active_flag := FND_API.G_MISS_CHAR;
637: x_parent_list_header_id := FND_API.G_MISS_NUM;
638: x_start_date_active_first := FND_API.G_MISS_DATE;
639: x_end_date_active_first := FND_API.G_MISS_DATE;

Line 636: x_active_flag := FND_API.G_MISS_CHAR;

632: x_start_date_active := FND_API.G_MISS_DATE;
633: x_terms_id := FND_API.G_MISS_NUM;
634: x_source_system_code := FND_API.G_MISS_CHAR;
635: x_pte_code := FND_API.G_MISS_CHAR;
636: x_active_flag := FND_API.G_MISS_CHAR;
637: x_parent_list_header_id := FND_API.G_MISS_NUM;
638: x_start_date_active_first := FND_API.G_MISS_DATE;
639: x_end_date_active_first := FND_API.G_MISS_DATE;
640: x_active_date_first_type := FND_API.G_MISS_CHAR;

Line 637: x_parent_list_header_id := FND_API.G_MISS_NUM;

633: x_terms_id := FND_API.G_MISS_NUM;
634: x_source_system_code := FND_API.G_MISS_CHAR;
635: x_pte_code := FND_API.G_MISS_CHAR;
636: x_active_flag := FND_API.G_MISS_CHAR;
637: x_parent_list_header_id := FND_API.G_MISS_NUM;
638: x_start_date_active_first := FND_API.G_MISS_DATE;
639: x_end_date_active_first := FND_API.G_MISS_DATE;
640: x_active_date_first_type := FND_API.G_MISS_CHAR;
641: x_start_date_active_second := FND_API.G_MISS_DATE;

Line 638: x_start_date_active_first := FND_API.G_MISS_DATE;

634: x_source_system_code := FND_API.G_MISS_CHAR;
635: x_pte_code := FND_API.G_MISS_CHAR;
636: x_active_flag := FND_API.G_MISS_CHAR;
637: x_parent_list_header_id := FND_API.G_MISS_NUM;
638: x_start_date_active_first := FND_API.G_MISS_DATE;
639: x_end_date_active_first := FND_API.G_MISS_DATE;
640: x_active_date_first_type := FND_API.G_MISS_CHAR;
641: x_start_date_active_second := FND_API.G_MISS_DATE;
642: x_global_flag := FND_API.G_MISS_CHAR;

Line 639: x_end_date_active_first := FND_API.G_MISS_DATE;

635: x_pte_code := FND_API.G_MISS_CHAR;
636: x_active_flag := FND_API.G_MISS_CHAR;
637: x_parent_list_header_id := FND_API.G_MISS_NUM;
638: x_start_date_active_first := FND_API.G_MISS_DATE;
639: x_end_date_active_first := FND_API.G_MISS_DATE;
640: x_active_date_first_type := FND_API.G_MISS_CHAR;
641: x_start_date_active_second := FND_API.G_MISS_DATE;
642: x_global_flag := FND_API.G_MISS_CHAR;
643: x_end_date_active_second := FND_API.G_MISS_DATE;

Line 640: x_active_date_first_type := FND_API.G_MISS_CHAR;

636: x_active_flag := FND_API.G_MISS_CHAR;
637: x_parent_list_header_id := FND_API.G_MISS_NUM;
638: x_start_date_active_first := FND_API.G_MISS_DATE;
639: x_end_date_active_first := FND_API.G_MISS_DATE;
640: x_active_date_first_type := FND_API.G_MISS_CHAR;
641: x_start_date_active_second := FND_API.G_MISS_DATE;
642: x_global_flag := FND_API.G_MISS_CHAR;
643: x_end_date_active_second := FND_API.G_MISS_DATE;
644: x_active_date_second_type := FND_API.G_MISS_CHAR;

Line 641: x_start_date_active_second := FND_API.G_MISS_DATE;

637: x_parent_list_header_id := FND_API.G_MISS_NUM;
638: x_start_date_active_first := FND_API.G_MISS_DATE;
639: x_end_date_active_first := FND_API.G_MISS_DATE;
640: x_active_date_first_type := FND_API.G_MISS_CHAR;
641: x_start_date_active_second := FND_API.G_MISS_DATE;
642: x_global_flag := FND_API.G_MISS_CHAR;
643: x_end_date_active_second := FND_API.G_MISS_DATE;
644: x_active_date_second_type := FND_API.G_MISS_CHAR;
645: x_automatic := FND_API.G_MISS_CHAR;

Line 642: x_global_flag := FND_API.G_MISS_CHAR;

638: x_start_date_active_first := FND_API.G_MISS_DATE;
639: x_end_date_active_first := FND_API.G_MISS_DATE;
640: x_active_date_first_type := FND_API.G_MISS_CHAR;
641: x_start_date_active_second := FND_API.G_MISS_DATE;
642: x_global_flag := FND_API.G_MISS_CHAR;
643: x_end_date_active_second := FND_API.G_MISS_DATE;
644: x_active_date_second_type := FND_API.G_MISS_CHAR;
645: x_automatic := FND_API.G_MISS_CHAR;
646: x_currency := FND_API.G_MISS_CHAR;

Line 643: x_end_date_active_second := FND_API.G_MISS_DATE;

639: x_end_date_active_first := FND_API.G_MISS_DATE;
640: x_active_date_first_type := FND_API.G_MISS_CHAR;
641: x_start_date_active_second := FND_API.G_MISS_DATE;
642: x_global_flag := FND_API.G_MISS_CHAR;
643: x_end_date_active_second := FND_API.G_MISS_DATE;
644: x_active_date_second_type := FND_API.G_MISS_CHAR;
645: x_automatic := FND_API.G_MISS_CHAR;
646: x_currency := FND_API.G_MISS_CHAR;
647: x_discount_lines := FND_API.G_MISS_CHAR;

Line 644: x_active_date_second_type := FND_API.G_MISS_CHAR;

640: x_active_date_first_type := FND_API.G_MISS_CHAR;
641: x_start_date_active_second := FND_API.G_MISS_DATE;
642: x_global_flag := FND_API.G_MISS_CHAR;
643: x_end_date_active_second := FND_API.G_MISS_DATE;
644: x_active_date_second_type := FND_API.G_MISS_CHAR;
645: x_automatic := FND_API.G_MISS_CHAR;
646: x_currency := FND_API.G_MISS_CHAR;
647: x_discount_lines := FND_API.G_MISS_CHAR;
648: x_freight_terms := FND_API.G_MISS_CHAR;

Line 645: x_automatic := FND_API.G_MISS_CHAR;

641: x_start_date_active_second := FND_API.G_MISS_DATE;
642: x_global_flag := FND_API.G_MISS_CHAR;
643: x_end_date_active_second := FND_API.G_MISS_DATE;
644: x_active_date_second_type := FND_API.G_MISS_CHAR;
645: x_automatic := FND_API.G_MISS_CHAR;
646: x_currency := FND_API.G_MISS_CHAR;
647: x_discount_lines := FND_API.G_MISS_CHAR;
648: x_freight_terms := FND_API.G_MISS_CHAR;
649: x_list_header := FND_API.G_MISS_CHAR;

Line 646: x_currency := FND_API.G_MISS_CHAR;

642: x_global_flag := FND_API.G_MISS_CHAR;
643: x_end_date_active_second := FND_API.G_MISS_DATE;
644: x_active_date_second_type := FND_API.G_MISS_CHAR;
645: x_automatic := FND_API.G_MISS_CHAR;
646: x_currency := FND_API.G_MISS_CHAR;
647: x_discount_lines := FND_API.G_MISS_CHAR;
648: x_freight_terms := FND_API.G_MISS_CHAR;
649: x_list_header := FND_API.G_MISS_CHAR;
650: x_list_type := FND_API.G_MISS_CHAR;

Line 647: x_discount_lines := FND_API.G_MISS_CHAR;

643: x_end_date_active_second := FND_API.G_MISS_DATE;
644: x_active_date_second_type := FND_API.G_MISS_CHAR;
645: x_automatic := FND_API.G_MISS_CHAR;
646: x_currency := FND_API.G_MISS_CHAR;
647: x_discount_lines := FND_API.G_MISS_CHAR;
648: x_freight_terms := FND_API.G_MISS_CHAR;
649: x_list_header := FND_API.G_MISS_CHAR;
650: x_list_type := FND_API.G_MISS_CHAR;
651: x_prorate := FND_API.G_MISS_CHAR;

Line 648: x_freight_terms := FND_API.G_MISS_CHAR;

644: x_active_date_second_type := FND_API.G_MISS_CHAR;
645: x_automatic := FND_API.G_MISS_CHAR;
646: x_currency := FND_API.G_MISS_CHAR;
647: x_discount_lines := FND_API.G_MISS_CHAR;
648: x_freight_terms := FND_API.G_MISS_CHAR;
649: x_list_header := FND_API.G_MISS_CHAR;
650: x_list_type := FND_API.G_MISS_CHAR;
651: x_prorate := FND_API.G_MISS_CHAR;
652: x_ship_method := FND_API.G_MISS_CHAR;

Line 649: x_list_header := FND_API.G_MISS_CHAR;

645: x_automatic := FND_API.G_MISS_CHAR;
646: x_currency := FND_API.G_MISS_CHAR;
647: x_discount_lines := FND_API.G_MISS_CHAR;
648: x_freight_terms := FND_API.G_MISS_CHAR;
649: x_list_header := FND_API.G_MISS_CHAR;
650: x_list_type := FND_API.G_MISS_CHAR;
651: x_prorate := FND_API.G_MISS_CHAR;
652: x_ship_method := FND_API.G_MISS_CHAR;
653: x_terms := FND_API.G_MISS_CHAR;

Line 650: x_list_type := FND_API.G_MISS_CHAR;

646: x_currency := FND_API.G_MISS_CHAR;
647: x_discount_lines := FND_API.G_MISS_CHAR;
648: x_freight_terms := FND_API.G_MISS_CHAR;
649: x_list_header := FND_API.G_MISS_CHAR;
650: x_list_type := FND_API.G_MISS_CHAR;
651: x_prorate := FND_API.G_MISS_CHAR;
652: x_ship_method := FND_API.G_MISS_CHAR;
653: x_terms := FND_API.G_MISS_CHAR;
654: x_ask_for_flag := FND_API.G_MISS_CHAR;

Line 651: x_prorate := FND_API.G_MISS_CHAR;

647: x_discount_lines := FND_API.G_MISS_CHAR;
648: x_freight_terms := FND_API.G_MISS_CHAR;
649: x_list_header := FND_API.G_MISS_CHAR;
650: x_list_type := FND_API.G_MISS_CHAR;
651: x_prorate := FND_API.G_MISS_CHAR;
652: x_ship_method := FND_API.G_MISS_CHAR;
653: x_terms := FND_API.G_MISS_CHAR;
654: x_ask_for_flag := FND_API.G_MISS_CHAR;
655: x_name := FND_API.G_MISS_CHAR;

Line 652: x_ship_method := FND_API.G_MISS_CHAR;

648: x_freight_terms := FND_API.G_MISS_CHAR;
649: x_list_header := FND_API.G_MISS_CHAR;
650: x_list_type := FND_API.G_MISS_CHAR;
651: x_prorate := FND_API.G_MISS_CHAR;
652: x_ship_method := FND_API.G_MISS_CHAR;
653: x_terms := FND_API.G_MISS_CHAR;
654: x_ask_for_flag := FND_API.G_MISS_CHAR;
655: x_name := FND_API.G_MISS_CHAR;
656: x_description := FND_API.G_MISS_CHAR;

Line 653: x_terms := FND_API.G_MISS_CHAR;

649: x_list_header := FND_API.G_MISS_CHAR;
650: x_list_type := FND_API.G_MISS_CHAR;
651: x_prorate := FND_API.G_MISS_CHAR;
652: x_ship_method := FND_API.G_MISS_CHAR;
653: x_terms := FND_API.G_MISS_CHAR;
654: x_ask_for_flag := FND_API.G_MISS_CHAR;
655: x_name := FND_API.G_MISS_CHAR;
656: x_description := FND_API.G_MISS_CHAR;
657: x_version_no := FND_API.G_MISS_CHAR;

Line 654: x_ask_for_flag := FND_API.G_MISS_CHAR;

650: x_list_type := FND_API.G_MISS_CHAR;
651: x_prorate := FND_API.G_MISS_CHAR;
652: x_ship_method := FND_API.G_MISS_CHAR;
653: x_terms := FND_API.G_MISS_CHAR;
654: x_ask_for_flag := FND_API.G_MISS_CHAR;
655: x_name := FND_API.G_MISS_CHAR;
656: x_description := FND_API.G_MISS_CHAR;
657: x_version_no := FND_API.G_MISS_CHAR;
658: x_list_source_code := FND_API.G_MISS_CHAR;

Line 655: x_name := FND_API.G_MISS_CHAR;

651: x_prorate := FND_API.G_MISS_CHAR;
652: x_ship_method := FND_API.G_MISS_CHAR;
653: x_terms := FND_API.G_MISS_CHAR;
654: x_ask_for_flag := FND_API.G_MISS_CHAR;
655: x_name := FND_API.G_MISS_CHAR;
656: x_description := FND_API.G_MISS_CHAR;
657: x_version_no := FND_API.G_MISS_CHAR;
658: x_list_source_code := FND_API.G_MISS_CHAR;
659: x_orig_system_header_ref := FND_API.G_MISS_CHAR;

Line 656: x_description := FND_API.G_MISS_CHAR;

652: x_ship_method := FND_API.G_MISS_CHAR;
653: x_terms := FND_API.G_MISS_CHAR;
654: x_ask_for_flag := FND_API.G_MISS_CHAR;
655: x_name := FND_API.G_MISS_CHAR;
656: x_description := FND_API.G_MISS_CHAR;
657: x_version_no := FND_API.G_MISS_CHAR;
658: x_list_source_code := FND_API.G_MISS_CHAR;
659: x_orig_system_header_ref := FND_API.G_MISS_CHAR;
660: x_shareable_flag := FND_API.G_MISS_CHAR;

Line 657: x_version_no := FND_API.G_MISS_CHAR;

653: x_terms := FND_API.G_MISS_CHAR;
654: x_ask_for_flag := FND_API.G_MISS_CHAR;
655: x_name := FND_API.G_MISS_CHAR;
656: x_description := FND_API.G_MISS_CHAR;
657: x_version_no := FND_API.G_MISS_CHAR;
658: x_list_source_code := FND_API.G_MISS_CHAR;
659: x_orig_system_header_ref := FND_API.G_MISS_CHAR;
660: x_shareable_flag := FND_API.G_MISS_CHAR;
661: --added for MOAC

Line 658: x_list_source_code := FND_API.G_MISS_CHAR;

654: x_ask_for_flag := FND_API.G_MISS_CHAR;
655: x_name := FND_API.G_MISS_CHAR;
656: x_description := FND_API.G_MISS_CHAR;
657: x_version_no := FND_API.G_MISS_CHAR;
658: x_list_source_code := FND_API.G_MISS_CHAR;
659: x_orig_system_header_ref := FND_API.G_MISS_CHAR;
660: x_shareable_flag := FND_API.G_MISS_CHAR;
661: --added for MOAC
662: x_org_id := FND_API.G_MISS_NUM;

Line 659: x_orig_system_header_ref := FND_API.G_MISS_CHAR;

655: x_name := FND_API.G_MISS_CHAR;
656: x_description := FND_API.G_MISS_CHAR;
657: x_version_no := FND_API.G_MISS_CHAR;
658: x_list_source_code := FND_API.G_MISS_CHAR;
659: x_orig_system_header_ref := FND_API.G_MISS_CHAR;
660: x_shareable_flag := FND_API.G_MISS_CHAR;
661: --added for MOAC
662: x_org_id := FND_API.G_MISS_NUM;
663:

Line 660: x_shareable_flag := FND_API.G_MISS_CHAR;

656: x_description := FND_API.G_MISS_CHAR;
657: x_version_no := FND_API.G_MISS_CHAR;
658: x_list_source_code := FND_API.G_MISS_CHAR;
659: x_orig_system_header_ref := FND_API.G_MISS_CHAR;
660: x_shareable_flag := FND_API.G_MISS_CHAR;
661: --added for MOAC
662: x_org_id := FND_API.G_MISS_NUM;
663:
664: -- Load display out parameters if any

Line 662: x_org_id := FND_API.G_MISS_NUM;

658: x_list_source_code := FND_API.G_MISS_CHAR;
659: x_orig_system_header_ref := FND_API.G_MISS_CHAR;
660: x_shareable_flag := FND_API.G_MISS_CHAR;
661: --added for MOAC
662: x_org_id := FND_API.G_MISS_NUM;
663:
664: -- Load display out parameters if any
665:
666: l_MODIFIER_LIST_val_rec := QP_Modifier_List_Util.Get_Values

Line 986: x_return_status := FND_API.G_RET_STS_SUCCESS;

982: );
983:
984: -- Set return status.
985:
986: x_return_status := FND_API.G_RET_STS_SUCCESS;
987:
988: -- Get message count and data
989:
990: OE_MSG_PUB.Count_And_Get

Line 999: WHEN FND_API.G_EXC_ERROR THEN

995: oe_debug_pub.add('End change_attibutes in QPXFMLHB');
996:
997: EXCEPTION
998:
999: WHEN FND_API.G_EXC_ERROR THEN
1000:
1001: x_return_status := FND_API.G_RET_STS_ERROR;
1002:
1003: -- Get message count and data

Line 1001: x_return_status := FND_API.G_RET_STS_ERROR;

997: EXCEPTION
998:
999: WHEN FND_API.G_EXC_ERROR THEN
1000:
1001: x_return_status := FND_API.G_RET_STS_ERROR;
1002:
1003: -- Get message count and data
1004:
1005: OE_MSG_PUB.Count_And_Get

Line 1010: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1006: ( p_count => x_msg_count
1007: , p_data => x_msg_data
1008: );
1009:
1010: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1011:
1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1013:
1014: -- Get message count and data

Line 1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1008: );
1009:
1010: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1011:
1012: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1013:
1014: -- Get message count and data
1015:
1016: OE_MSG_PUB.Count_And_Get

Line 1023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1019: );
1020:
1021: WHEN OTHERS THEN
1022:
1023: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1024:
1025: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1026: THEN
1027: OE_MSG_PUB.Add_Exc_Msg

Line 1101: IF FND_API.To_Boolean(l_MODIFIER_LIST_rec.db_flag) THEN

1097: );
1098:
1099: -- Set Operation.
1100:
1101: IF FND_API.To_Boolean(l_MODIFIER_LIST_rec.db_flag) THEN
1102: l_MODIFIER_LIST_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
1103: ELSE
1104: l_MODIFIER_LIST_rec.operation := QP_GLOBALS.G_OPR_CREATE;
1105: END IF;

Line 1111: , p_init_msg_list => FND_API.G_TRUE

1107: -- Call QP_Modifiers_PVT.Process_MODIFIERS
1108:
1109: QP_Modifiers_PVT.Process_MODIFIERS
1110: ( p_api_version_number => 1.0
1111: , p_init_msg_list => FND_API.G_TRUE
1112: , x_return_status => l_return_status
1113: , x_msg_count => x_msg_count
1114: , x_msg_data => x_msg_data
1115: , p_control_rec => l_control_rec

Line 1124: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1120: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1121: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1122: );
1123:
1124: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1127: RAISE FND_API.G_EXC_ERROR;
1128: END IF;

Line 1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1121: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1122: );
1123:
1124: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1127: RAISE FND_API.G_EXC_ERROR;
1128: END IF;
1129:

Line 1126: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1122: );
1123:
1124: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1127: RAISE FND_API.G_EXC_ERROR;
1128: END IF;
1129:
1130:

Line 1127: RAISE FND_API.G_EXC_ERROR;

1123:
1124: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1126: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1127: RAISE FND_API.G_EXC_ERROR;
1128: END IF;
1129:
1130:
1131: -- Load OUT parameters.

Line 1151: x_return_status := FND_API.G_RET_STS_SUCCESS;

1147:
1148:
1149: -- Set return status.
1150:
1151: x_return_status := FND_API.G_RET_STS_SUCCESS;
1152:
1153: -- Get message count and data
1154:
1155: OE_MSG_PUB.Count_And_Get

Line 1163: WHEN FND_API.G_EXC_ERROR THEN

1159:
1160:
1161: EXCEPTION
1162:
1163: WHEN FND_API.G_EXC_ERROR THEN
1164:
1165: x_return_status := FND_API.G_RET_STS_ERROR;
1166:
1167: -- Get message count and data

Line 1165: x_return_status := FND_API.G_RET_STS_ERROR;

1161: EXCEPTION
1162:
1163: WHEN FND_API.G_EXC_ERROR THEN
1164:
1165: x_return_status := FND_API.G_RET_STS_ERROR;
1166:
1167: -- Get message count and data
1168:
1169: OE_MSG_PUB.Count_And_Get

Line 1174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1170: ( p_count => x_msg_count
1171: , p_data => x_msg_data
1172: );
1173:
1174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1175:
1176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1177:
1178: -- Get message count and data

Line 1176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1172: );
1173:
1174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1175:
1176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1177:
1178: -- Get message count and data
1179:
1180: OE_MSG_PUB.Count_And_Get

Line 1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1183: );
1184:
1185: WHEN OTHERS THEN
1186:
1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1188:
1189: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1190: THEN
1191: OE_MSG_PUB.Add_Exc_Msg

Line 1260: , p_init_msg_list => FND_API.G_TRUE

1256: -- Call QP_Modifiers_PVT.Process_MODIFIERS
1257:
1258: QP_Modifiers_PVT.Process_MODIFIERS
1259: ( p_api_version_number => 1.0
1260: , p_init_msg_list => FND_API.G_TRUE
1261: , x_return_status => l_return_status
1262: , x_msg_count => x_msg_count
1263: , x_msg_data => x_msg_data
1264: , p_control_rec => l_control_rec

Line 1272: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1268: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1269: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1270: );
1271:
1272: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1274: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1275: RAISE FND_API.G_EXC_ERROR;
1276: END IF;

Line 1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1269: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1270: );
1271:
1272: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1274: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1275: RAISE FND_API.G_EXC_ERROR;
1276: END IF;
1277:

Line 1274: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1270: );
1271:
1272: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1274: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1275: RAISE FND_API.G_EXC_ERROR;
1276: END IF;
1277:
1278:

Line 1275: RAISE FND_API.G_EXC_ERROR;

1271:
1272: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1273: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1274: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1275: RAISE FND_API.G_EXC_ERROR;
1276: END IF;
1277:
1278:
1279: -- Clear MODIFIER_LIST record cache

Line 1285: x_return_status := FND_API.G_RET_STS_SUCCESS;

1281: Clear_MODIFIER_LIST;
1282:
1283: -- Set return status.
1284:
1285: x_return_status := FND_API.G_RET_STS_SUCCESS;
1286:
1287: -- Get message count and data
1288:
1289: OE_MSG_PUB.Count_And_Get

Line 1297: WHEN FND_API.G_EXC_ERROR THEN

1293:
1294:
1295: EXCEPTION
1296:
1297: WHEN FND_API.G_EXC_ERROR THEN
1298:
1299: x_return_status := FND_API.G_RET_STS_ERROR;
1300:
1301: -- Get message count and data

Line 1299: x_return_status := FND_API.G_RET_STS_ERROR;

1295: EXCEPTION
1296:
1297: WHEN FND_API.G_EXC_ERROR THEN
1298:
1299: x_return_status := FND_API.G_RET_STS_ERROR;
1300:
1301: -- Get message count and data
1302:
1303: OE_MSG_PUB.Count_And_Get

Line 1308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1304: ( p_count => x_msg_count
1305: , p_data => x_msg_data
1306: );
1307:
1308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1309:
1310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1311:
1312: -- Get message count and data

Line 1310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1306: );
1307:
1308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1309:
1310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1311:
1312: -- Get message count and data
1313:
1314: OE_MSG_PUB.Count_And_Get

Line 1321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1317: );
1318:
1319: WHEN OTHERS THEN
1320:
1321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1322:
1323: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1324: THEN
1325: OE_MSG_PUB.Add_Exc_Msg

Line 1382: , p_init_msg_list => FND_API.G_TRUE

1378: -- Call QP_Modifiers_PVT.Process_MODIFIERS
1379:
1380: QP_Modifiers_PVT.Process_MODIFIERS
1381: ( p_api_version_number => 1.0
1382: , p_init_msg_list => FND_API.G_TRUE
1383: , x_return_status => l_return_status
1384: , x_msg_count => x_msg_count
1385: , x_msg_data => x_msg_data
1386: , p_control_rec => l_control_rec

Line 1393: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1389: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1390: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1391: );
1392:
1393: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1395: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1396: RAISE FND_API.G_EXC_ERROR;
1397: END IF;

Line 1394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1390: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1391: );
1392:
1393: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1395: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1396: RAISE FND_API.G_EXC_ERROR;
1397: END IF;
1398:

Line 1395: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1391: );
1392:
1393: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1395: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1396: RAISE FND_API.G_EXC_ERROR;
1397: END IF;
1398:
1399:

Line 1396: RAISE FND_API.G_EXC_ERROR;

1392:
1393: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1394: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1395: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1396: RAISE FND_API.G_EXC_ERROR;
1397: END IF;
1398:
1399:
1400: -- Set return status.

Line 1402: x_return_status := FND_API.G_RET_STS_SUCCESS;

1398:
1399:
1400: -- Set return status.
1401:
1402: x_return_status := FND_API.G_RET_STS_SUCCESS;
1403:
1404: -- Get message count and data
1405:
1406: OE_MSG_PUB.Count_And_Get

Line 1414: WHEN FND_API.G_EXC_ERROR THEN

1410:
1411:
1412: EXCEPTION
1413:
1414: WHEN FND_API.G_EXC_ERROR THEN
1415:
1416: x_return_status := FND_API.G_RET_STS_ERROR;
1417:
1418: -- Get message count and data

Line 1416: x_return_status := FND_API.G_RET_STS_ERROR;

1412: EXCEPTION
1413:
1414: WHEN FND_API.G_EXC_ERROR THEN
1415:
1416: x_return_status := FND_API.G_RET_STS_ERROR;
1417:
1418: -- Get message count and data
1419:
1420: OE_MSG_PUB.Count_And_Get

Line 1425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1421: ( p_count => x_msg_count
1422: , p_data => x_msg_data
1423: );
1424:
1425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1426:
1427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1428:
1429: -- Get message count and data

Line 1427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1423: );
1424:
1425: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1426:
1427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1428:
1429: -- Get message count and data
1430:
1431: OE_MSG_PUB.Count_And_Get

Line 1438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1434: );
1435:
1436: WHEN OTHERS THEN
1437:
1438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1439:
1440: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1441: THEN
1442: OE_MSG_PUB.Add_Exc_Msg

Line 1499: , p_init_msg_list => FND_API.G_TRUE

1495: -- Call QP_Modifiers_PVT.Process_MODIFIERS
1496:
1497: QP_Modifiers_PVT.Process_MODIFIERS
1498: ( p_api_version_number => 1.0
1499: , p_init_msg_list => FND_API.G_TRUE
1500: , x_return_status => l_return_status
1501: , x_msg_count => x_msg_count
1502: , x_msg_data => x_msg_data
1503: , p_control_rec => l_control_rec

Line 1510: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1506: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1507: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1508: );
1509:
1510: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1512: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1513: RAISE FND_API.G_EXC_ERROR;
1514: END IF;

Line 1511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1507: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1508: );
1509:
1510: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1512: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1513: RAISE FND_API.G_EXC_ERROR;
1514: END IF;
1515:

Line 1512: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1508: );
1509:
1510: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1512: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1513: RAISE FND_API.G_EXC_ERROR;
1514: END IF;
1515:
1516:

Line 1513: RAISE FND_API.G_EXC_ERROR;

1509:
1510: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1512: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1513: RAISE FND_API.G_EXC_ERROR;
1514: END IF;
1515:
1516:
1517: -- Set return status.

Line 1519: x_return_status := FND_API.G_RET_STS_SUCCESS;

1515:
1516:
1517: -- Set return status.
1518:
1519: x_return_status := FND_API.G_RET_STS_SUCCESS;
1520:
1521: -- Get message count and data
1522:
1523: OE_MSG_PUB.Count_And_Get

Line 1531: WHEN FND_API.G_EXC_ERROR THEN

1527:
1528:
1529: EXCEPTION
1530:
1531: WHEN FND_API.G_EXC_ERROR THEN
1532:
1533: x_return_status := FND_API.G_RET_STS_ERROR;
1534:
1535: -- Get message count and data

Line 1533: x_return_status := FND_API.G_RET_STS_ERROR;

1529: EXCEPTION
1530:
1531: WHEN FND_API.G_EXC_ERROR THEN
1532:
1533: x_return_status := FND_API.G_RET_STS_ERROR;
1534:
1535: -- Get message count and data
1536:
1537: OE_MSG_PUB.Count_And_Get

Line 1542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1538: ( p_count => x_msg_count
1539: , p_data => x_msg_data
1540: );
1541:
1542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1543:
1544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1545:
1546: -- Get message count and data

Line 1544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1540: );
1541:
1542: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1543:
1544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1545:
1546: -- Get message count and data
1547:
1548: OE_MSG_PUB.Count_And_Get

Line 1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1551: );
1552:
1553: WHEN OTHERS THEN
1554:
1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1556:
1557: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1558: THEN
1559: OE_MSG_PUB.Add_Exc_Msg

Line 1714: , p_init_msg_list => FND_API.G_FALSE

1710:
1711: /*
1712: QP_Modifiers_PUB.Process_Modifiers
1713: ( p_api_version_number => 1.0
1714: , p_init_msg_list => FND_API.G_FALSE
1715: , p_return_values => FND_API.G_FALSE
1716: , p_commit => FND_API.G_FALSE
1717: , x_return_status => x_return_status
1718: , x_msg_count =>x_msg_count

Line 1715: , p_return_values => FND_API.G_FALSE

1711: /*
1712: QP_Modifiers_PUB.Process_Modifiers
1713: ( p_api_version_number => 1.0
1714: , p_init_msg_list => FND_API.G_FALSE
1715: , p_return_values => FND_API.G_FALSE
1716: , p_commit => FND_API.G_FALSE
1717: , x_return_status => x_return_status
1718: , x_msg_count =>x_msg_count
1719: , x_msg_data =>x_msg_data

Line 1716: , p_commit => FND_API.G_FALSE

1712: QP_Modifiers_PUB.Process_Modifiers
1713: ( p_api_version_number => 1.0
1714: , p_init_msg_list => FND_API.G_FALSE
1715: , p_return_values => FND_API.G_FALSE
1716: , p_commit => FND_API.G_FALSE
1717: , x_return_status => x_return_status
1718: , x_msg_count =>x_msg_count
1719: , x_msg_data =>x_msg_data
1720: -- ,p_MODIFIER_LIST_rec => l_MODIFIER_LIST_rec

Line 1738: , p_init_msg_list => FND_API.G_FALSE

1734: */
1735:
1736: QP_Modifiers_PVT.Process_Modifiers
1737: ( p_api_version_number => 1.0
1738: , p_init_msg_list => FND_API.G_FALSE
1739: , p_commit => FND_API.G_FALSE
1740: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1741: , p_control_rec => l_control_rec
1742: , x_return_status => x_return_status

Line 1739: , p_commit => FND_API.G_FALSE

1735:
1736: QP_Modifiers_PVT.Process_Modifiers
1737: ( p_api_version_number => 1.0
1738: , p_init_msg_list => FND_API.G_FALSE
1739: , p_commit => FND_API.G_FALSE
1740: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1741: , p_control_rec => l_control_rec
1742: , x_return_status => x_return_status
1743: , x_msg_count =>x_msg_count

Line 1740: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

1736: QP_Modifiers_PVT.Process_Modifiers
1737: ( p_api_version_number => 1.0
1738: , p_init_msg_list => FND_API.G_FALSE
1739: , p_commit => FND_API.G_FALSE
1740: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1741: , p_control_rec => l_control_rec
1742: , x_return_status => x_return_status
1743: , x_msg_count =>x_msg_count
1744: , x_msg_data =>x_msg_data

Line 1758: WHEN FND_API.G_EXC_ERROR THEN

1754:
1755:
1756: EXCEPTION
1757:
1758: WHEN FND_API.G_EXC_ERROR THEN
1759:
1760: x_return_status := FND_API.G_RET_STS_ERROR;
1761:
1762: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');

Line 1760: x_return_status := FND_API.G_RET_STS_ERROR;

1756: EXCEPTION
1757:
1758: WHEN FND_API.G_EXC_ERROR THEN
1759:
1760: x_return_status := FND_API.G_RET_STS_ERROR;
1761:
1762: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
1763: OE_MSG_PUB.Add;
1764:

Line 1780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1776: , 'QP_QP_FORM_MODIFIER_LIST'
1777: );
1778: END IF;
1779:
1780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1781:
1782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1783:
1784: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');

Line 1782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1778: END IF;
1779:
1780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1781:
1782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1783:
1784: FND_MESSAGE.SET_NAME('QP','QP_PE_QUALIFIERS');
1785: OE_MSG_PUB.Add;
1786: -- Get message count and data

Line 1811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1807: , 'QP_QP_FORM_MODIFIER_LIST'
1808: );
1809: END IF;
1810:
1811: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1812:
1813: -- Get message count and data
1814:
1815: OE_MSG_PUB.Count_And_Get

Line 1968: , p_init_msg_list => FND_API.G_TRUE

1964: -- Call QP_Modifiers_PVT.Lock_MODIFIERS
1965:
1966: QP_Modifiers_PVT.Lock_MODIFIERS
1967: ( p_api_version_number => 1.0
1968: , p_init_msg_list => FND_API.G_TRUE
1969: , x_return_status => l_return_status
1970: , x_msg_count => x_msg_count
1971: , x_msg_data => x_msg_data
1972: , p_MODIFIER_LIST_rec => l_MODIFIER_LIST_rec

Line 1979: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1975: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1976: , x_PRICING_ATTR_tbl => l_x_PRICING_ATTR_tbl
1977: );
1978:
1979: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1980:
1981: -- Set DB flag and write record to cache.
1982:
1983: l_x_MODIFIER_LIST_rec.db_flag := FND_API.G_TRUE;

Line 1983: l_x_MODIFIER_LIST_rec.db_flag := FND_API.G_TRUE;

1979: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1980:
1981: -- Set DB flag and write record to cache.
1982:
1983: l_x_MODIFIER_LIST_rec.db_flag := FND_API.G_TRUE;
1984:
1985: Write_MODIFIER_LIST
1986: ( p_MODIFIER_LIST_rec => l_x_MODIFIER_LIST_rec
1987: , p_db_record => TRUE

Line 2016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2012: , 'Lock_Row'
2013: );
2014: END IF;
2015:
2016: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2017:
2018: -- Get message count and data
2019:
2020: OE_MSG_PUB.Count_And_Get

Line 2069: g_MODIFIER_LIST_rec.db_flag := FND_API.G_TRUE;

2065: g_MODIFIER_LIST_rec := QP_Modifier_List_Util.Query_Row
2066: ( p_list_header_id => p_list_header_id
2067: );
2068:
2069: g_MODIFIER_LIST_rec.db_flag := FND_API.G_TRUE;
2070:
2071: -- Load DB record
2072:
2073: g_db_MODIFIER_LIST_rec := g_MODIFIER_LIST_rec;

Line 2115: x_return_status := FND_API.G_RET_STS_SUCCESS;

2111: IS
2112: l_return_status Varchar2(30);
2113: BEGIN
2114: OE_MSG_PUB.initialize;
2115: x_return_status := FND_API.G_RET_STS_SUCCESS;
2116: QP_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
2117: p_entity_code => QP_GLOBALS.G_ENTITY_MODIFIER_LIST
2118: ,p_entity_id => p_list_header_id
2119: ,x_return_status => l_return_status);

Line 2143: x_return_status := FND_API.G_RET_STS_ERROR;

2139: OE_MSG_PUB.Count_And_Get
2140: ( p_count => x_msg_count
2141: , p_data => x_msg_data
2142: );
2143: x_return_status := FND_API.G_RET_STS_ERROR;
2144:
2145: END Clear_Record;
2146:
2147:

Line 2159: x_return_status := FND_API.G_RET_STS_SUCCESS;

2155: IS
2156: l_return_status Varchar2(30);
2157: BEGIN
2158: OE_MSG_PUB.initialize;
2159: x_return_status := FND_API.G_RET_STS_SUCCESS;
2160: QP_DELAYED_REQUESTS_PVT.Clear_Request(
2161: x_return_status => l_return_status);
2162:
2163: EXCEPTION

Line 2177: x_return_status := FND_API.G_RET_STS_ERROR;

2173: OE_MSG_PUB.Count_And_Get
2174: ( p_count => x_msg_count
2175: , p_data => x_msg_data
2176: );
2177: x_return_status := FND_API.G_RET_STS_ERROR;
2178:
2179: END Delete_All_Requests;
2180:
2181: