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

Line 36: ( p_qualifier_rule_id IN NUMBER := FND_API.G_MISS_NUM

32: -- Procedure : Default_Attributes
33: --
34:
35: PROCEDURE Default_Attributes
36: ( p_qualifier_rule_id IN NUMBER := FND_API.G_MISS_NUM
37: , p_list_header_id IN NUMBER := FND_API.G_MISS_NUM
38: , p_qualifier_context IN VARCHAR2 := FND_API.G_MISS_CHAR
39: , p_qualifier_attribute IN VARCHAR2 := FND_API.G_MISS_CHAR
40: , p_qualifier_attr_value IN VARCHAR2 := FND_API.G_MISS_CHAR

Line 37: , p_list_header_id IN NUMBER := FND_API.G_MISS_NUM

33: --
34:
35: PROCEDURE Default_Attributes
36: ( p_qualifier_rule_id IN NUMBER := FND_API.G_MISS_NUM
37: , p_list_header_id IN NUMBER := FND_API.G_MISS_NUM
38: , p_qualifier_context IN VARCHAR2 := FND_API.G_MISS_CHAR
39: , p_qualifier_attribute IN VARCHAR2 := FND_API.G_MISS_CHAR
40: , p_qualifier_attr_value IN VARCHAR2 := FND_API.G_MISS_CHAR
41: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 38: , p_qualifier_context IN VARCHAR2 := FND_API.G_MISS_CHAR

34:
35: PROCEDURE Default_Attributes
36: ( p_qualifier_rule_id IN NUMBER := FND_API.G_MISS_NUM
37: , p_list_header_id IN NUMBER := FND_API.G_MISS_NUM
38: , p_qualifier_context IN VARCHAR2 := FND_API.G_MISS_CHAR
39: , p_qualifier_attribute IN VARCHAR2 := FND_API.G_MISS_CHAR
40: , p_qualifier_attr_value IN VARCHAR2 := FND_API.G_MISS_CHAR
41: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 39: , p_qualifier_attribute IN VARCHAR2 := FND_API.G_MISS_CHAR

35: PROCEDURE Default_Attributes
36: ( p_qualifier_rule_id IN NUMBER := FND_API.G_MISS_NUM
37: , p_list_header_id IN NUMBER := FND_API.G_MISS_NUM
38: , p_qualifier_context IN VARCHAR2 := FND_API.G_MISS_CHAR
39: , p_qualifier_attribute IN VARCHAR2 := FND_API.G_MISS_CHAR
40: , p_qualifier_attr_value IN VARCHAR2 := FND_API.G_MISS_CHAR
41: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
43: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 40: , p_qualifier_attr_value IN VARCHAR2 := FND_API.G_MISS_CHAR

36: ( p_qualifier_rule_id IN NUMBER := FND_API.G_MISS_NUM
37: , p_list_header_id IN NUMBER := FND_API.G_MISS_NUM
38: , p_qualifier_context IN VARCHAR2 := FND_API.G_MISS_CHAR
39: , p_qualifier_attribute IN VARCHAR2 := FND_API.G_MISS_CHAR
40: , p_qualifier_attr_value IN VARCHAR2 := FND_API.G_MISS_CHAR
41: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
42: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
43: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
44: , x_attribute1 OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 163: , p_init_msg_list => FND_API.G_TRUE

159: -- Call QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
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 178: , p_init_msg_list => FND_API.G_TRUE

174:
175: /*
176: QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
177: ( p_api_version_number => 1.0
178: , p_init_msg_list => FND_API.G_TRUE
179: , x_return_status => l_return_status
180: , x_msg_count => x_msg_count
181: , x_msg_data => x_msg_data
182: , p_control_rec => l_control_rec

Line 197: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

193: oe_debug_pub.add('return status is : ' || l_return_status);
194:
195: oe_debug_pub.add('ren : msg data is : ' || x_msg_data);
196:
197: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
200: RAISE FND_API.G_EXC_ERROR;
201: END IF;

Line 198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

194:
195: oe_debug_pub.add('ren : msg data is : ' || x_msg_data);
196:
197: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
200: RAISE FND_API.G_EXC_ERROR;
201: END IF;
202:

Line 199: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

195: oe_debug_pub.add('ren : msg data is : ' || x_msg_data);
196:
197: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
200: RAISE FND_API.G_EXC_ERROR;
201: END IF;
202:
203:

Line 200: RAISE FND_API.G_EXC_ERROR;

196:
197: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
198: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
199: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
200: RAISE FND_API.G_EXC_ERROR;
201: END IF;
202:
203:
204: -- Unload out tbl

Line 267: l_x_QUALIFIERS_rec.db_flag := FND_API.G_FALSE;

263:
264: -- Write to cache.
265: -- Set db_flag to False before writing to cache
266:
267: l_x_QUALIFIERS_rec.db_flag := FND_API.G_FALSE;
268:
269: oe_debug_pub.add('Ren: before write qualifiers');
270: oe_debug_pub.add('Ren: msg data 1 is :' || x_msg_data);
271:

Line 279: x_return_status := FND_API.G_RET_STS_SUCCESS;

275: oe_debug_pub.add('Ren: msg data 2 is :' || x_msg_data);
276:
277: -- Set return status.
278:
279: x_return_status := FND_API.G_RET_STS_SUCCESS;
280:
281: oe_debug_pub.add('Ren: msg data 2.5 is :' || x_msg_data);
282:
283: -- Get message count and data

Line 294: WHEN FND_API.G_EXC_ERROR THEN

290: oe_debug_pub.add('Ren: msg data 3 is :' || x_msg_data);
291:
292: EXCEPTION
293:
294: WHEN FND_API.G_EXC_ERROR THEN
295:
296: x_return_status := FND_API.G_RET_STS_ERROR;
297:
298: -- Get message count and data

Line 296: x_return_status := FND_API.G_RET_STS_ERROR;

292: EXCEPTION
293:
294: WHEN FND_API.G_EXC_ERROR THEN
295:
296: x_return_status := FND_API.G_RET_STS_ERROR;
297:
298: -- Get message count and data
299:
300: oe_msg_pub.Count_And_Get

Line 305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

301: ( p_count => x_msg_count
302: , p_data => x_msg_data
303: );
304:
305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
306:
307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
308:
309: -- Get message count and data

Line 307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

303: );
304:
305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
306:
307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
308:
309: -- Get message count and data
310:
311: oe_msg_pub.Count_And_Get

Line 318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

314: );
315:
316: WHEN OTHERS THEN
317:
318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
319:
320: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
321: THEN
322: oe_msg_pub.Add_Exc_Msg

Line 535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

531: , 'Unrecognized attribute'
532: );
533: END IF;
534:
535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
536:
537: END IF;
538:
539: -- Set Operation.

Line 541: IF FND_API.To_Boolean(l_QUALIFIERS_rec.db_flag) THEN

537: END IF;
538:
539: -- Set Operation.
540:
541: IF FND_API.To_Boolean(l_QUALIFIERS_rec.db_flag) THEN
542: l_QUALIFIERS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
543: ELSE
544: l_QUALIFIERS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
545: END IF;

Line 556: , p_init_msg_list => FND_API.G_TRUE

552: -- Call QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
553:
554: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
555: ( p_api_version_number => 1.0
556: , p_init_msg_list => FND_API.G_TRUE
557: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
558: , x_return_status => l_return_status
559: , x_msg_count => x_msg_count
560: , x_msg_data => x_msg_data

Line 557: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

553:
554: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
555: ( p_api_version_number => 1.0
556: , p_init_msg_list => FND_API.G_TRUE
557: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
558: , x_return_status => l_return_status
559: , x_msg_count => x_msg_count
560: , x_msg_data => x_msg_data
561: , p_control_rec => l_control_rec

Line 573: , p_init_msg_list => FND_API.G_TRUE

569:
570: /*
571: QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
572: ( p_api_version_number => 1.0
573: , p_init_msg_list => FND_API.G_TRUE
574: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
575: , x_return_status => l_return_status
576: , x_msg_count => x_msg_count
577: , x_msg_data => x_msg_data

Line 574: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

570: /*
571: QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
572: ( p_api_version_number => 1.0
573: , p_init_msg_list => FND_API.G_TRUE
574: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
575: , x_return_status => l_return_status
576: , x_msg_count => x_msg_count
577: , x_msg_data => x_msg_data
578: , p_control_rec => l_control_rec

Line 587: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

583: );
584:
585: */
586:
587: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
590: RAISE FND_API.G_EXC_ERROR;
591: END IF;

Line 588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

584:
585: */
586:
587: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
590: RAISE FND_API.G_EXC_ERROR;
591: END IF;
592:

Line 589: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

585: */
586:
587: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
590: RAISE FND_API.G_EXC_ERROR;
591: END IF;
592:
593:

Line 590: RAISE FND_API.G_EXC_ERROR;

586:
587: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
590: RAISE FND_API.G_EXC_ERROR;
591: END IF;
592:
593:
594: -- Unload out tbl

Line 600: x_attribute1 := FND_API.G_MISS_CHAR;

596: l_x_QUALIFIERS_rec := l_x_QUALIFIERS_tbl(1);
597:
598: -- Init OUT parameters to missing.
599:
600: x_attribute1 := FND_API.G_MISS_CHAR;
601: x_attribute10 := FND_API.G_MISS_CHAR;
602: x_attribute11 := FND_API.G_MISS_CHAR;
603: x_attribute12 := FND_API.G_MISS_CHAR;
604: x_attribute13 := FND_API.G_MISS_CHAR;

Line 601: x_attribute10 := FND_API.G_MISS_CHAR;

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

Line 602: x_attribute11 := FND_API.G_MISS_CHAR;

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

Line 603: x_attribute12 := FND_API.G_MISS_CHAR;

599:
600: x_attribute1 := FND_API.G_MISS_CHAR;
601: x_attribute10 := FND_API.G_MISS_CHAR;
602: x_attribute11 := FND_API.G_MISS_CHAR;
603: x_attribute12 := FND_API.G_MISS_CHAR;
604: x_attribute13 := FND_API.G_MISS_CHAR;
605: x_attribute14 := FND_API.G_MISS_CHAR;
606: x_attribute15 := FND_API.G_MISS_CHAR;
607: x_attribute2 := FND_API.G_MISS_CHAR;

Line 604: x_attribute13 := FND_API.G_MISS_CHAR;

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

Line 605: x_attribute14 := FND_API.G_MISS_CHAR;

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

Line 606: x_attribute15 := FND_API.G_MISS_CHAR;

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

Line 607: x_attribute2 := FND_API.G_MISS_CHAR;

603: x_attribute12 := FND_API.G_MISS_CHAR;
604: x_attribute13 := FND_API.G_MISS_CHAR;
605: x_attribute14 := FND_API.G_MISS_CHAR;
606: x_attribute15 := FND_API.G_MISS_CHAR;
607: x_attribute2 := FND_API.G_MISS_CHAR;
608: x_attribute3 := FND_API.G_MISS_CHAR;
609: x_attribute4 := FND_API.G_MISS_CHAR;
610: x_attribute5 := FND_API.G_MISS_CHAR;
611: x_attribute6 := FND_API.G_MISS_CHAR;

Line 608: x_attribute3 := FND_API.G_MISS_CHAR;

604: x_attribute13 := FND_API.G_MISS_CHAR;
605: x_attribute14 := FND_API.G_MISS_CHAR;
606: x_attribute15 := FND_API.G_MISS_CHAR;
607: x_attribute2 := FND_API.G_MISS_CHAR;
608: x_attribute3 := FND_API.G_MISS_CHAR;
609: x_attribute4 := FND_API.G_MISS_CHAR;
610: x_attribute5 := FND_API.G_MISS_CHAR;
611: x_attribute6 := FND_API.G_MISS_CHAR;
612: x_attribute7 := FND_API.G_MISS_CHAR;

Line 609: x_attribute4 := FND_API.G_MISS_CHAR;

605: x_attribute14 := FND_API.G_MISS_CHAR;
606: x_attribute15 := FND_API.G_MISS_CHAR;
607: x_attribute2 := FND_API.G_MISS_CHAR;
608: x_attribute3 := FND_API.G_MISS_CHAR;
609: x_attribute4 := FND_API.G_MISS_CHAR;
610: x_attribute5 := FND_API.G_MISS_CHAR;
611: x_attribute6 := FND_API.G_MISS_CHAR;
612: x_attribute7 := FND_API.G_MISS_CHAR;
613: x_attribute8 := FND_API.G_MISS_CHAR;

Line 610: x_attribute5 := FND_API.G_MISS_CHAR;

606: x_attribute15 := FND_API.G_MISS_CHAR;
607: x_attribute2 := FND_API.G_MISS_CHAR;
608: x_attribute3 := FND_API.G_MISS_CHAR;
609: x_attribute4 := FND_API.G_MISS_CHAR;
610: x_attribute5 := FND_API.G_MISS_CHAR;
611: x_attribute6 := FND_API.G_MISS_CHAR;
612: x_attribute7 := FND_API.G_MISS_CHAR;
613: x_attribute8 := FND_API.G_MISS_CHAR;
614: x_attribute9 := FND_API.G_MISS_CHAR;

Line 611: x_attribute6 := FND_API.G_MISS_CHAR;

607: x_attribute2 := FND_API.G_MISS_CHAR;
608: x_attribute3 := FND_API.G_MISS_CHAR;
609: x_attribute4 := FND_API.G_MISS_CHAR;
610: x_attribute5 := FND_API.G_MISS_CHAR;
611: x_attribute6 := FND_API.G_MISS_CHAR;
612: x_attribute7 := FND_API.G_MISS_CHAR;
613: x_attribute8 := FND_API.G_MISS_CHAR;
614: x_attribute9 := FND_API.G_MISS_CHAR;
615: x_comparison_operator_code := FND_API.G_MISS_CHAR;

Line 612: x_attribute7 := FND_API.G_MISS_CHAR;

608: x_attribute3 := FND_API.G_MISS_CHAR;
609: x_attribute4 := FND_API.G_MISS_CHAR;
610: x_attribute5 := FND_API.G_MISS_CHAR;
611: x_attribute6 := FND_API.G_MISS_CHAR;
612: x_attribute7 := FND_API.G_MISS_CHAR;
613: x_attribute8 := FND_API.G_MISS_CHAR;
614: x_attribute9 := FND_API.G_MISS_CHAR;
615: x_comparison_operator_code := FND_API.G_MISS_CHAR;
616: x_context := FND_API.G_MISS_CHAR;

Line 613: x_attribute8 := FND_API.G_MISS_CHAR;

609: x_attribute4 := FND_API.G_MISS_CHAR;
610: x_attribute5 := FND_API.G_MISS_CHAR;
611: x_attribute6 := FND_API.G_MISS_CHAR;
612: x_attribute7 := FND_API.G_MISS_CHAR;
613: x_attribute8 := FND_API.G_MISS_CHAR;
614: x_attribute9 := FND_API.G_MISS_CHAR;
615: x_comparison_operator_code := FND_API.G_MISS_CHAR;
616: x_context := FND_API.G_MISS_CHAR;
617: x_created_from_rule_id := FND_API.G_MISS_NUM;

Line 614: x_attribute9 := FND_API.G_MISS_CHAR;

610: x_attribute5 := FND_API.G_MISS_CHAR;
611: x_attribute6 := FND_API.G_MISS_CHAR;
612: x_attribute7 := FND_API.G_MISS_CHAR;
613: x_attribute8 := FND_API.G_MISS_CHAR;
614: x_attribute9 := FND_API.G_MISS_CHAR;
615: x_comparison_operator_code := FND_API.G_MISS_CHAR;
616: x_context := FND_API.G_MISS_CHAR;
617: x_created_from_rule_id := FND_API.G_MISS_NUM;
618: x_end_date_active := FND_API.G_MISS_DATE;

Line 615: x_comparison_operator_code := FND_API.G_MISS_CHAR;

611: x_attribute6 := FND_API.G_MISS_CHAR;
612: x_attribute7 := FND_API.G_MISS_CHAR;
613: x_attribute8 := FND_API.G_MISS_CHAR;
614: x_attribute9 := FND_API.G_MISS_CHAR;
615: x_comparison_operator_code := FND_API.G_MISS_CHAR;
616: x_context := FND_API.G_MISS_CHAR;
617: x_created_from_rule_id := FND_API.G_MISS_NUM;
618: x_end_date_active := FND_API.G_MISS_DATE;
619: x_excluder_flag := FND_API.G_MISS_CHAR;

Line 616: x_context := FND_API.G_MISS_CHAR;

612: x_attribute7 := FND_API.G_MISS_CHAR;
613: x_attribute8 := FND_API.G_MISS_CHAR;
614: x_attribute9 := FND_API.G_MISS_CHAR;
615: x_comparison_operator_code := FND_API.G_MISS_CHAR;
616: x_context := FND_API.G_MISS_CHAR;
617: x_created_from_rule_id := FND_API.G_MISS_NUM;
618: x_end_date_active := FND_API.G_MISS_DATE;
619: x_excluder_flag := FND_API.G_MISS_CHAR;
620: x_list_header_id := FND_API.G_MISS_NUM;

Line 617: x_created_from_rule_id := FND_API.G_MISS_NUM;

613: x_attribute8 := FND_API.G_MISS_CHAR;
614: x_attribute9 := FND_API.G_MISS_CHAR;
615: x_comparison_operator_code := FND_API.G_MISS_CHAR;
616: x_context := FND_API.G_MISS_CHAR;
617: x_created_from_rule_id := FND_API.G_MISS_NUM;
618: x_end_date_active := FND_API.G_MISS_DATE;
619: x_excluder_flag := FND_API.G_MISS_CHAR;
620: x_list_header_id := FND_API.G_MISS_NUM;
621: x_list_line_id := FND_API.G_MISS_NUM;

Line 618: x_end_date_active := FND_API.G_MISS_DATE;

614: x_attribute9 := FND_API.G_MISS_CHAR;
615: x_comparison_operator_code := FND_API.G_MISS_CHAR;
616: x_context := FND_API.G_MISS_CHAR;
617: x_created_from_rule_id := FND_API.G_MISS_NUM;
618: x_end_date_active := FND_API.G_MISS_DATE;
619: x_excluder_flag := FND_API.G_MISS_CHAR;
620: x_list_header_id := FND_API.G_MISS_NUM;
621: x_list_line_id := FND_API.G_MISS_NUM;
622: x_qualifier_attribute := FND_API.G_MISS_CHAR;

Line 619: x_excluder_flag := FND_API.G_MISS_CHAR;

615: x_comparison_operator_code := FND_API.G_MISS_CHAR;
616: x_context := FND_API.G_MISS_CHAR;
617: x_created_from_rule_id := FND_API.G_MISS_NUM;
618: x_end_date_active := FND_API.G_MISS_DATE;
619: x_excluder_flag := FND_API.G_MISS_CHAR;
620: x_list_header_id := FND_API.G_MISS_NUM;
621: x_list_line_id := FND_API.G_MISS_NUM;
622: x_qualifier_attribute := FND_API.G_MISS_CHAR;
623: x_qualifier_attr_value := FND_API.G_MISS_CHAR;

Line 620: x_list_header_id := FND_API.G_MISS_NUM;

616: x_context := FND_API.G_MISS_CHAR;
617: x_created_from_rule_id := FND_API.G_MISS_NUM;
618: x_end_date_active := FND_API.G_MISS_DATE;
619: x_excluder_flag := FND_API.G_MISS_CHAR;
620: x_list_header_id := FND_API.G_MISS_NUM;
621: x_list_line_id := FND_API.G_MISS_NUM;
622: x_qualifier_attribute := FND_API.G_MISS_CHAR;
623: x_qualifier_attr_value := FND_API.G_MISS_CHAR;
624: x_qualifier_attr_value_to := FND_API.G_MISS_CHAR;

Line 621: x_list_line_id := FND_API.G_MISS_NUM;

617: x_created_from_rule_id := FND_API.G_MISS_NUM;
618: x_end_date_active := FND_API.G_MISS_DATE;
619: x_excluder_flag := FND_API.G_MISS_CHAR;
620: x_list_header_id := FND_API.G_MISS_NUM;
621: x_list_line_id := FND_API.G_MISS_NUM;
622: x_qualifier_attribute := FND_API.G_MISS_CHAR;
623: x_qualifier_attr_value := FND_API.G_MISS_CHAR;
624: x_qualifier_attr_value_to := FND_API.G_MISS_CHAR;
625: x_qualifier_context := FND_API.G_MISS_CHAR;

Line 622: x_qualifier_attribute := FND_API.G_MISS_CHAR;

618: x_end_date_active := FND_API.G_MISS_DATE;
619: x_excluder_flag := FND_API.G_MISS_CHAR;
620: x_list_header_id := FND_API.G_MISS_NUM;
621: x_list_line_id := FND_API.G_MISS_NUM;
622: x_qualifier_attribute := FND_API.G_MISS_CHAR;
623: x_qualifier_attr_value := FND_API.G_MISS_CHAR;
624: x_qualifier_attr_value_to := FND_API.G_MISS_CHAR;
625: x_qualifier_context := FND_API.G_MISS_CHAR;
626: x_qualifier_datatype := FND_API.G_MISS_CHAR;

Line 623: x_qualifier_attr_value := FND_API.G_MISS_CHAR;

619: x_excluder_flag := FND_API.G_MISS_CHAR;
620: x_list_header_id := FND_API.G_MISS_NUM;
621: x_list_line_id := FND_API.G_MISS_NUM;
622: x_qualifier_attribute := FND_API.G_MISS_CHAR;
623: x_qualifier_attr_value := FND_API.G_MISS_CHAR;
624: x_qualifier_attr_value_to := FND_API.G_MISS_CHAR;
625: x_qualifier_context := FND_API.G_MISS_CHAR;
626: x_qualifier_datatype := FND_API.G_MISS_CHAR;
627: --x_qualifier_date_format := FND_API.G_MISS_CHAR;

Line 624: x_qualifier_attr_value_to := FND_API.G_MISS_CHAR;

620: x_list_header_id := FND_API.G_MISS_NUM;
621: x_list_line_id := FND_API.G_MISS_NUM;
622: x_qualifier_attribute := FND_API.G_MISS_CHAR;
623: x_qualifier_attr_value := FND_API.G_MISS_CHAR;
624: x_qualifier_attr_value_to := FND_API.G_MISS_CHAR;
625: x_qualifier_context := FND_API.G_MISS_CHAR;
626: x_qualifier_datatype := FND_API.G_MISS_CHAR;
627: --x_qualifier_date_format := FND_API.G_MISS_CHAR;
628: x_qualifier_grouping_no := FND_API.G_MISS_NUM;

Line 625: x_qualifier_context := FND_API.G_MISS_CHAR;

621: x_list_line_id := FND_API.G_MISS_NUM;
622: x_qualifier_attribute := FND_API.G_MISS_CHAR;
623: x_qualifier_attr_value := FND_API.G_MISS_CHAR;
624: x_qualifier_attr_value_to := FND_API.G_MISS_CHAR;
625: x_qualifier_context := FND_API.G_MISS_CHAR;
626: x_qualifier_datatype := FND_API.G_MISS_CHAR;
627: --x_qualifier_date_format := FND_API.G_MISS_CHAR;
628: x_qualifier_grouping_no := FND_API.G_MISS_NUM;
629: x_qualifier_id := FND_API.G_MISS_NUM;

Line 626: x_qualifier_datatype := FND_API.G_MISS_CHAR;

622: x_qualifier_attribute := FND_API.G_MISS_CHAR;
623: x_qualifier_attr_value := FND_API.G_MISS_CHAR;
624: x_qualifier_attr_value_to := FND_API.G_MISS_CHAR;
625: x_qualifier_context := FND_API.G_MISS_CHAR;
626: x_qualifier_datatype := FND_API.G_MISS_CHAR;
627: --x_qualifier_date_format := FND_API.G_MISS_CHAR;
628: x_qualifier_grouping_no := FND_API.G_MISS_NUM;
629: x_qualifier_id := FND_API.G_MISS_NUM;
630: --x_qualifier_number_format := FND_API.G_MISS_CHAR;

Line 627: --x_qualifier_date_format := FND_API.G_MISS_CHAR;

623: x_qualifier_attr_value := FND_API.G_MISS_CHAR;
624: x_qualifier_attr_value_to := FND_API.G_MISS_CHAR;
625: x_qualifier_context := FND_API.G_MISS_CHAR;
626: x_qualifier_datatype := FND_API.G_MISS_CHAR;
627: --x_qualifier_date_format := FND_API.G_MISS_CHAR;
628: x_qualifier_grouping_no := FND_API.G_MISS_NUM;
629: x_qualifier_id := FND_API.G_MISS_NUM;
630: --x_qualifier_number_format := FND_API.G_MISS_CHAR;
631: x_qualifier_precedence := FND_API.G_MISS_NUM;

Line 628: x_qualifier_grouping_no := FND_API.G_MISS_NUM;

624: x_qualifier_attr_value_to := FND_API.G_MISS_CHAR;
625: x_qualifier_context := FND_API.G_MISS_CHAR;
626: x_qualifier_datatype := FND_API.G_MISS_CHAR;
627: --x_qualifier_date_format := FND_API.G_MISS_CHAR;
628: x_qualifier_grouping_no := FND_API.G_MISS_NUM;
629: x_qualifier_id := FND_API.G_MISS_NUM;
630: --x_qualifier_number_format := FND_API.G_MISS_CHAR;
631: x_qualifier_precedence := FND_API.G_MISS_NUM;
632: x_qualifier_rule_id := FND_API.G_MISS_NUM;

Line 629: x_qualifier_id := FND_API.G_MISS_NUM;

625: x_qualifier_context := FND_API.G_MISS_CHAR;
626: x_qualifier_datatype := FND_API.G_MISS_CHAR;
627: --x_qualifier_date_format := FND_API.G_MISS_CHAR;
628: x_qualifier_grouping_no := FND_API.G_MISS_NUM;
629: x_qualifier_id := FND_API.G_MISS_NUM;
630: --x_qualifier_number_format := FND_API.G_MISS_CHAR;
631: x_qualifier_precedence := FND_API.G_MISS_NUM;
632: x_qualifier_rule_id := FND_API.G_MISS_NUM;
633: x_start_date_active := FND_API.G_MISS_DATE;

Line 630: --x_qualifier_number_format := FND_API.G_MISS_CHAR;

626: x_qualifier_datatype := FND_API.G_MISS_CHAR;
627: --x_qualifier_date_format := FND_API.G_MISS_CHAR;
628: x_qualifier_grouping_no := FND_API.G_MISS_NUM;
629: x_qualifier_id := FND_API.G_MISS_NUM;
630: --x_qualifier_number_format := FND_API.G_MISS_CHAR;
631: x_qualifier_precedence := FND_API.G_MISS_NUM;
632: x_qualifier_rule_id := FND_API.G_MISS_NUM;
633: x_start_date_active := FND_API.G_MISS_DATE;
634: --x_comparison_operator := FND_API.G_MISS_CHAR;

Line 631: x_qualifier_precedence := FND_API.G_MISS_NUM;

627: --x_qualifier_date_format := FND_API.G_MISS_CHAR;
628: x_qualifier_grouping_no := FND_API.G_MISS_NUM;
629: x_qualifier_id := FND_API.G_MISS_NUM;
630: --x_qualifier_number_format := FND_API.G_MISS_CHAR;
631: x_qualifier_precedence := FND_API.G_MISS_NUM;
632: x_qualifier_rule_id := FND_API.G_MISS_NUM;
633: x_start_date_active := FND_API.G_MISS_DATE;
634: --x_comparison_operator := FND_API.G_MISS_CHAR;
635: x_created_from_rule := FND_API.G_MISS_CHAR;

Line 632: x_qualifier_rule_id := FND_API.G_MISS_NUM;

628: x_qualifier_grouping_no := FND_API.G_MISS_NUM;
629: x_qualifier_id := FND_API.G_MISS_NUM;
630: --x_qualifier_number_format := FND_API.G_MISS_CHAR;
631: x_qualifier_precedence := FND_API.G_MISS_NUM;
632: x_qualifier_rule_id := FND_API.G_MISS_NUM;
633: x_start_date_active := FND_API.G_MISS_DATE;
634: --x_comparison_operator := FND_API.G_MISS_CHAR;
635: x_created_from_rule := FND_API.G_MISS_CHAR;
636: --x_excluder := FND_API.G_MISS_CHAR;

Line 633: x_start_date_active := FND_API.G_MISS_DATE;

629: x_qualifier_id := FND_API.G_MISS_NUM;
630: --x_qualifier_number_format := FND_API.G_MISS_CHAR;
631: x_qualifier_precedence := FND_API.G_MISS_NUM;
632: x_qualifier_rule_id := FND_API.G_MISS_NUM;
633: x_start_date_active := FND_API.G_MISS_DATE;
634: --x_comparison_operator := FND_API.G_MISS_CHAR;
635: x_created_from_rule := FND_API.G_MISS_CHAR;
636: --x_excluder := FND_API.G_MISS_CHAR;
637: x_list_header := FND_API.G_MISS_CHAR;

Line 634: --x_comparison_operator := FND_API.G_MISS_CHAR;

630: --x_qualifier_number_format := FND_API.G_MISS_CHAR;
631: x_qualifier_precedence := FND_API.G_MISS_NUM;
632: x_qualifier_rule_id := FND_API.G_MISS_NUM;
633: x_start_date_active := FND_API.G_MISS_DATE;
634: --x_comparison_operator := FND_API.G_MISS_CHAR;
635: x_created_from_rule := FND_API.G_MISS_CHAR;
636: --x_excluder := FND_API.G_MISS_CHAR;
637: x_list_header := FND_API.G_MISS_CHAR;
638: x_list_line := FND_API.G_MISS_CHAR;

Line 635: x_created_from_rule := FND_API.G_MISS_CHAR;

631: x_qualifier_precedence := FND_API.G_MISS_NUM;
632: x_qualifier_rule_id := FND_API.G_MISS_NUM;
633: x_start_date_active := FND_API.G_MISS_DATE;
634: --x_comparison_operator := FND_API.G_MISS_CHAR;
635: x_created_from_rule := FND_API.G_MISS_CHAR;
636: --x_excluder := FND_API.G_MISS_CHAR;
637: x_list_header := FND_API.G_MISS_CHAR;
638: x_list_line := FND_API.G_MISS_CHAR;
639: --x_qualifier := FND_API.G_MISS_CHAR;

Line 636: --x_excluder := FND_API.G_MISS_CHAR;

632: x_qualifier_rule_id := FND_API.G_MISS_NUM;
633: x_start_date_active := FND_API.G_MISS_DATE;
634: --x_comparison_operator := FND_API.G_MISS_CHAR;
635: x_created_from_rule := FND_API.G_MISS_CHAR;
636: --x_excluder := FND_API.G_MISS_CHAR;
637: x_list_header := FND_API.G_MISS_CHAR;
638: x_list_line := FND_API.G_MISS_CHAR;
639: --x_qualifier := FND_API.G_MISS_CHAR;
640: x_qualifier_rule := FND_API.G_MISS_CHAR;

Line 637: x_list_header := FND_API.G_MISS_CHAR;

633: x_start_date_active := FND_API.G_MISS_DATE;
634: --x_comparison_operator := FND_API.G_MISS_CHAR;
635: x_created_from_rule := FND_API.G_MISS_CHAR;
636: --x_excluder := FND_API.G_MISS_CHAR;
637: x_list_header := FND_API.G_MISS_CHAR;
638: x_list_line := FND_API.G_MISS_CHAR;
639: --x_qualifier := FND_API.G_MISS_CHAR;
640: x_qualifier_rule := FND_API.G_MISS_CHAR;
641: x_qualify_hier_descendent_flag := FND_API.G_MISS_CHAR; -- Added for TCA

Line 638: x_list_line := FND_API.G_MISS_CHAR;

634: --x_comparison_operator := FND_API.G_MISS_CHAR;
635: x_created_from_rule := FND_API.G_MISS_CHAR;
636: --x_excluder := FND_API.G_MISS_CHAR;
637: x_list_header := FND_API.G_MISS_CHAR;
638: x_list_line := FND_API.G_MISS_CHAR;
639: --x_qualifier := FND_API.G_MISS_CHAR;
640: x_qualifier_rule := FND_API.G_MISS_CHAR;
641: x_qualify_hier_descendent_flag := FND_API.G_MISS_CHAR; -- Added for TCA
642:

Line 639: --x_qualifier := FND_API.G_MISS_CHAR;

635: x_created_from_rule := FND_API.G_MISS_CHAR;
636: --x_excluder := FND_API.G_MISS_CHAR;
637: x_list_header := FND_API.G_MISS_CHAR;
638: x_list_line := FND_API.G_MISS_CHAR;
639: --x_qualifier := FND_API.G_MISS_CHAR;
640: x_qualifier_rule := FND_API.G_MISS_CHAR;
641: x_qualify_hier_descendent_flag := FND_API.G_MISS_CHAR; -- Added for TCA
642:
643: -- Load display out parameters if any

Line 640: x_qualifier_rule := FND_API.G_MISS_CHAR;

636: --x_excluder := FND_API.G_MISS_CHAR;
637: x_list_header := FND_API.G_MISS_CHAR;
638: x_list_line := FND_API.G_MISS_CHAR;
639: --x_qualifier := FND_API.G_MISS_CHAR;
640: x_qualifier_rule := FND_API.G_MISS_CHAR;
641: x_qualify_hier_descendent_flag := FND_API.G_MISS_CHAR; -- Added for TCA
642:
643: -- Load display out parameters if any
644:

Line 641: x_qualify_hier_descendent_flag := FND_API.G_MISS_CHAR; -- Added for TCA

637: x_list_header := FND_API.G_MISS_CHAR;
638: x_list_line := FND_API.G_MISS_CHAR;
639: --x_qualifier := FND_API.G_MISS_CHAR;
640: x_qualifier_rule := FND_API.G_MISS_CHAR;
641: x_qualify_hier_descendent_flag := FND_API.G_MISS_CHAR; -- Added for TCA
642:
643: -- Load display out parameters if any
644:
645: l_QUALIFIERS_val_rec := QP_Qualifiers_Util.Get_Values

Line 877: x_return_status := FND_API.G_RET_STS_SUCCESS;

873: );
874:
875: -- Set return status.
876:
877: x_return_status := FND_API.G_RET_STS_SUCCESS;
878:
879: -- Get message count and data
880:
881: oe_msg_pub.Count_And_Get

Line 889: WHEN FND_API.G_EXC_ERROR THEN

885:
886:
887: EXCEPTION
888:
889: WHEN FND_API.G_EXC_ERROR THEN
890:
891: x_return_status := FND_API.G_RET_STS_ERROR;
892:
893: -- Get message count and data

Line 891: x_return_status := FND_API.G_RET_STS_ERROR;

887: EXCEPTION
888:
889: WHEN FND_API.G_EXC_ERROR THEN
890:
891: x_return_status := FND_API.G_RET_STS_ERROR;
892:
893: -- Get message count and data
894:
895: oe_msg_pub.Count_And_Get

Line 900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

896: ( p_count => x_msg_count
897: , p_data => x_msg_data
898: );
899:
900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
901:
902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
903:
904: -- Get message count and data

Line 902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

898: );
899:
900: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
901:
902: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
903:
904: -- Get message count and data
905:
906: oe_msg_pub.Count_And_Get

Line 913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

909: );
910:
911: WHEN OTHERS THEN
912:
913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
914:
915: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
916: THEN
917: oe_msg_pub.Add_Exc_Msg

Line 1001: IF FND_API.To_Boolean(l_QUALIFIERS_rec.db_flag) THEN

997: oe_debug_pub.add('in v and write 4');
998:
999: -- Set Operation.
1000:
1001: IF FND_API.To_Boolean(l_QUALIFIERS_rec.db_flag) THEN
1002: l_QUALIFIERS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
1003: ELSE
1004: l_QUALIFIERS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
1005: END IF;

Line 1017: , p_init_msg_list => FND_API.G_TRUE

1013: oe_debug_pub.add('in v and write 5');
1014:
1015: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
1016: ( p_api_version_number => 1.0
1017: , p_init_msg_list => FND_API.G_TRUE
1018: , x_return_status => l_return_status
1019: , x_msg_count => x_msg_count
1020: , x_msg_data => x_msg_data
1021: , p_control_rec => l_control_rec

Line 1035: , p_init_msg_list => FND_API.G_TRUE

1031: /*
1032:
1033: QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
1034: ( p_api_version_number => 1.0
1035: , p_init_msg_list => FND_API.G_TRUE
1036: , x_return_status => l_return_status
1037: , x_msg_count => x_msg_count
1038: , x_msg_data => x_msg_data
1039: , p_control_rec => l_control_rec

Line 1048: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1044: );
1045:
1046: */
1047:
1048: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1049: oe_debug_pub.add('in v and write 7');
1050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1051: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1052: oe_debug_pub.add('in v and write 8');

Line 1050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1046: */
1047:
1048: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1049: oe_debug_pub.add('in v and write 7');
1050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1051: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1052: oe_debug_pub.add('in v and write 8');
1053: RAISE FND_API.G_EXC_ERROR;
1054: END IF;

Line 1051: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1047:
1048: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1049: oe_debug_pub.add('in v and write 7');
1050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1051: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1052: oe_debug_pub.add('in v and write 8');
1053: RAISE FND_API.G_EXC_ERROR;
1054: END IF;
1055:

Line 1053: RAISE FND_API.G_EXC_ERROR;

1049: oe_debug_pub.add('in v and write 7');
1050: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1051: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1052: oe_debug_pub.add('in v and write 8');
1053: RAISE FND_API.G_EXC_ERROR;
1054: END IF;
1055:
1056:
1057: -- Load OUT parameters.

Line 1083: x_return_status := FND_API.G_RET_STS_SUCCESS;

1079:
1080:
1081: -- Set return status.
1082:
1083: x_return_status := FND_API.G_RET_STS_SUCCESS;
1084:
1085: -- Get message count and data
1086: oe_debug_pub.add('in v and write 10; msg is : ' || x_msg_data);
1087:

Line 1097: WHEN FND_API.G_EXC_ERROR THEN

1093:
1094:
1095: EXCEPTION
1096:
1097: WHEN FND_API.G_EXC_ERROR THEN
1098:
1099: x_return_status := FND_API.G_RET_STS_ERROR;
1100:
1101: -- Get message count and data

Line 1099: x_return_status := FND_API.G_RET_STS_ERROR;

1095: EXCEPTION
1096:
1097: WHEN FND_API.G_EXC_ERROR THEN
1098:
1099: x_return_status := FND_API.G_RET_STS_ERROR;
1100:
1101: -- Get message count and data
1102:
1103: oe_msg_pub.Count_And_Get

Line 1108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1104: ( p_count => x_msg_count
1105: , p_data => x_msg_data
1106: );
1107:
1108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1109:
1110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1111:
1112: -- Get message count and data

Line 1110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1106: );
1107:
1108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1109:
1110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1111:
1112: -- Get message count and data
1113:
1114: oe_msg_pub.Count_And_Get

Line 1121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1117: );
1118:
1119: WHEN OTHERS THEN
1120:
1121: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1122:
1123: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1124: THEN
1125: oe_msg_pub.Add_Exc_Msg

Line 1198: , p_init_msg_list => FND_API.G_TRUE

1194: -- Call QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
1195:
1196: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
1197: ( p_api_version_number => 1.0
1198: , p_init_msg_list => FND_API.G_TRUE
1199: , x_return_status => l_return_status
1200: , x_msg_count => x_msg_count
1201: , x_msg_data => x_msg_data
1202: , p_control_rec => l_control_rec

Line 1214: , p_init_msg_list => FND_API.G_TRUE

1210: /*
1211:
1212: QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
1213: ( p_api_version_number => 1.0
1214: , p_init_msg_list => FND_API.G_TRUE
1215: , x_return_status => l_return_status
1216: , x_msg_count => x_msg_count
1217: , x_msg_data => x_msg_data
1218: , p_control_rec => l_control_rec

Line 1226: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1222: );
1223:
1224: */
1225:
1226: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1228: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1229: RAISE FND_API.G_EXC_ERROR;
1230: END IF;

Line 1227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1223:
1224: */
1225:
1226: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1228: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1229: RAISE FND_API.G_EXC_ERROR;
1230: END IF;
1231:

Line 1228: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1224: */
1225:
1226: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1228: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1229: RAISE FND_API.G_EXC_ERROR;
1230: END IF;
1231:
1232:

Line 1229: RAISE FND_API.G_EXC_ERROR;

1225:
1226: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1228: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1229: RAISE FND_API.G_EXC_ERROR;
1230: END IF;
1231:
1232:
1233: -- Clear QUALIFIERS record cache

Line 1239: x_return_status := FND_API.G_RET_STS_SUCCESS;

1235: Clear_QUALIFIERS;
1236:
1237: -- Set return status.
1238:
1239: x_return_status := FND_API.G_RET_STS_SUCCESS;
1240:
1241: -- Get message count and data
1242:
1243: oe_msg_pub.Count_And_Get

Line 1251: WHEN FND_API.G_EXC_ERROR THEN

1247:
1248:
1249: EXCEPTION
1250:
1251: WHEN FND_API.G_EXC_ERROR THEN
1252:
1253: x_return_status := FND_API.G_RET_STS_ERROR;
1254:
1255: -- Get message count and data

Line 1253: x_return_status := FND_API.G_RET_STS_ERROR;

1249: EXCEPTION
1250:
1251: WHEN FND_API.G_EXC_ERROR THEN
1252:
1253: x_return_status := FND_API.G_RET_STS_ERROR;
1254:
1255: -- Get message count and data
1256:
1257: oe_msg_pub.Count_And_Get

Line 1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1258: ( p_count => x_msg_count
1259: , p_data => x_msg_data
1260: );
1261:
1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1263:
1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1265:
1266: -- Get message count and data

Line 1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1260: );
1261:
1262: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1263:
1264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1265:
1266: -- Get message count and data
1267:
1268: oe_msg_pub.Count_And_Get

Line 1275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1271: );
1272:
1273: WHEN OTHERS THEN
1274:
1275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1276:
1277: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1278: THEN
1279: oe_msg_pub.Add_Exc_Msg

Line 1335: , p_init_msg_list => FND_API.G_TRUE

1331: -- Call QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
1332:
1333: QP_LIST_HEADERS_PVT.Process_PRICE_LIST
1334: ( p_api_version_number => 1.0
1335: , p_init_msg_list => FND_API.G_TRUE
1336: , x_return_status => l_return_status
1337: , x_msg_count => x_msg_count
1338: , x_msg_data => x_msg_data
1339: , p_control_rec => l_control_rec

Line 1350: , p_init_msg_list => FND_API.G_TRUE

1346: /*
1347:
1348: QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
1349: ( p_api_version_number => 1.0
1350: , p_init_msg_list => FND_API.G_TRUE
1351: , x_return_status => l_return_status
1352: , x_msg_count => x_msg_count
1353: , x_msg_data => x_msg_data
1354: , p_control_rec => l_control_rec

Line 1361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1357: );
1358:
1359: */
1360:
1361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1363: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1364: RAISE FND_API.G_EXC_ERROR;
1365: END IF;

Line 1362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1358:
1359: */
1360:
1361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1363: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1364: RAISE FND_API.G_EXC_ERROR;
1365: END IF;
1366:

Line 1363: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1359: */
1360:
1361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1363: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1364: RAISE FND_API.G_EXC_ERROR;
1365: END IF;
1366:
1367:

Line 1364: RAISE FND_API.G_EXC_ERROR;

1360:
1361: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1362: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1363: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1364: RAISE FND_API.G_EXC_ERROR;
1365: END IF;
1366:
1367:
1368: -- Set return status.

Line 1370: x_return_status := FND_API.G_RET_STS_SUCCESS;

1366:
1367:
1368: -- Set return status.
1369:
1370: x_return_status := FND_API.G_RET_STS_SUCCESS;
1371:
1372: -- Get message count and data
1373:
1374: oe_msg_pub.Count_And_Get

Line 1382: WHEN FND_API.G_EXC_ERROR THEN

1378:
1379:
1380: EXCEPTION
1381:
1382: WHEN FND_API.G_EXC_ERROR THEN
1383:
1384: x_return_status := FND_API.G_RET_STS_ERROR;
1385:
1386: -- Get message count and data

Line 1384: x_return_status := FND_API.G_RET_STS_ERROR;

1380: EXCEPTION
1381:
1382: WHEN FND_API.G_EXC_ERROR THEN
1383:
1384: x_return_status := FND_API.G_RET_STS_ERROR;
1385:
1386: -- Get message count and data
1387:
1388: oe_msg_pub.Count_And_Get

Line 1393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1389: ( p_count => x_msg_count
1390: , p_data => x_msg_data
1391: );
1392:
1393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1394:
1395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1396:
1397: -- Get message count and data

Line 1395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1391: );
1392:
1393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1394:
1395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1396:
1397: -- Get message count and data
1398:
1399: oe_msg_pub.Count_And_Get

Line 1406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1402: );
1403:
1404: WHEN OTHERS THEN
1405:
1406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1407:
1408: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1409: THEN
1410: oe_msg_pub.Add_Exc_Msg

Line 1547: , p_init_msg_list => FND_API.G_TRUE

1543: -- Call QP_Qualifier_Rules_PVT.Lock_QUALIFIER_RULES
1544:
1545: QP_LIST_HEADERS_PVT.Lock_PRICE_LIST
1546: ( p_api_version_number => 1.0
1547: , p_init_msg_list => FND_API.G_TRUE
1548: , x_return_status => l_return_status
1549: , x_msg_count => x_msg_count
1550: , x_msg_data => x_msg_data
1551: , p_QUALIFIERS_tbl => l_QUALIFIERS_tbl

Line 1562: , p_init_msg_list => FND_API.G_TRUE

1558: /*
1559:
1560: QP_Qualifier_Rules_PVT.Lock_QUALIFIER_RULES
1561: ( p_api_version_number => 1.0
1562: , p_init_msg_list => FND_API.G_TRUE
1563: , x_return_status => l_return_status
1564: , x_msg_count => x_msg_count
1565: , x_msg_data => x_msg_data
1566: , p_QUALIFIERS_tbl => l_QUALIFIERS_tbl

Line 1573: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1569: );
1570:
1571: */
1572:
1573: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1574:
1575: -- Set DB flag and write record to cache.
1576:
1577: l_x_QUALIFIERS_rec.db_flag := FND_API.G_TRUE;

Line 1577: l_x_QUALIFIERS_rec.db_flag := FND_API.G_TRUE;

1573: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1574:
1575: -- Set DB flag and write record to cache.
1576:
1577: l_x_QUALIFIERS_rec.db_flag := FND_API.G_TRUE;
1578:
1579: Write_QUALIFIERS
1580: ( p_QUALIFIERS_rec => l_x_QUALIFIERS_rec
1581: , p_db_record => TRUE

Line 1610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1606: , 'Lock_Row'
1607: );
1608: END IF;
1609:
1610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1611:
1612: -- Get message count and data
1613:
1614: oe_msg_pub.Count_And_Get

Line 1659: g_QUALIFIERS_rec.db_flag := FND_API.G_TRUE;

1655: g_QUALIFIERS_rec := QP_Qualifiers_Util.Query_Row
1656: ( p_qualifier_id => p_qualifier_id
1657: );
1658:
1659: g_QUALIFIERS_rec.db_flag := FND_API.G_TRUE;
1660:
1661: -- Load DB record
1662:
1663: g_db_QUALIFIERS_rec := g_QUALIFIERS_rec;

Line 1761: l_qualifiers_tbl(k).qualifier_id := FND_API.G_MISS_NUM;

1757: FOR k IN 1..l_qualifiers_tbl.COUNT LOOP
1758: l_qualifiers_tbl(k).list_header_id := l_list_header_id;
1759: l_qualifiers_tbl(k).list_line_id := l_list_line_id;
1760: l_qualifiers_tbl(k).qualifier_rule_id := NULL;
1761: l_qualifiers_tbl(k).qualifier_id := FND_API.G_MISS_NUM;
1762: l_qualifiers_tbl(k).created_from_rule_id := l_qualifier_rule_id;
1763:
1764: IF l_qualifiers_tbl(K).qualifier_grouping_no < 0 THEN
1765: IF l_qualifiers_tbl(K).qualifier_grouping_no = -1 THEN

Line 1811: l_qualifiers_tbl(k).qualifier_id := FND_API.G_MISS_NUM;

1807: FOR k IN 1..l_qualifiers_tbl.COUNT LOOP
1808: l_qualifiers_tbl(k).list_header_id := l_list_header_id;
1809: l_qualifiers_tbl(k).list_line_id := l_list_line_id;
1810: l_qualifiers_tbl(k).qualifier_rule_id := NULL;
1811: l_qualifiers_tbl(k).qualifier_id := FND_API.G_MISS_NUM;
1812: l_qualifiers_tbl(k).created_from_rule_id := l_qualifier_rule_id;
1813: IF NOT (l_list_type_code IN ('PRL','AGR') AND
1814: l_qualifiers_tbl(K).qualifier_context = 'VOLUME' AND
1815: l_qualifiers_tbl(K).qualifier_attribute = 'QUALIFIER_ATTRIBUTE10')

Line 1851: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1847:
1848: x_processed_qual_count := l_QUALIFIERS_tbl.COUNT;
1849: x_return_status := l_return_status;
1850:
1851: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1853: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1854: RAISE FND_API.G_EXC_ERROR;
1855: END IF;

Line 1852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1848: x_processed_qual_count := l_QUALIFIERS_tbl.COUNT;
1849: x_return_status := l_return_status;
1850:
1851: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1853: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1854: RAISE FND_API.G_EXC_ERROR;
1855: END IF;
1856:

Line 1853: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1849: x_return_status := l_return_status;
1850:
1851: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1853: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1854: RAISE FND_API.G_EXC_ERROR;
1855: END IF;
1856:
1857: EXCEPTION

Line 1854: RAISE FND_API.G_EXC_ERROR;

1850:
1851: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1852: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1853: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1854: RAISE FND_API.G_EXC_ERROR;
1855: END IF;
1856:
1857: EXCEPTION
1858:

Line 1859: WHEN FND_API.G_EXC_ERROR THEN

1855: END IF;
1856:
1857: EXCEPTION
1858:
1859: WHEN FND_API.G_EXC_ERROR THEN
1860:
1861: -- x_return_status := FND_API.G_RET_STS_ERROR;
1862:
1863: -- Get message count and data

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

1857: EXCEPTION
1858:
1859: WHEN FND_API.G_EXC_ERROR THEN
1860:
1861: -- x_return_status := FND_API.G_RET_STS_ERROR;
1862:
1863: -- Get message count and data
1864:
1865: oe_msg_pub.Count_And_Get

Line 1870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1866: ( p_count => x_msg_count
1867: , p_data => x_msg_data
1868: );
1869:
1870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1871:
1872: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1873:
1874: -- Get message count and data

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

1868: );
1869:
1870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1871:
1872: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1873:
1874: -- Get message count and data
1875:
1876: oe_msg_pub.Count_And_Get

Line 1883: x_return_status := FND_API.G_RET_STS_ERROR ;

1879: );
1880:
1881: WHEN OTHERS THEN
1882:
1883: x_return_status := FND_API.G_RET_STS_ERROR ;
1884:
1885: IF oe_msg_pub.Check_Msg_Level(oe_msg_pub.G_MSG_LVL_UNEXP_ERROR)
1886: THEN
1887: oe_msg_pub.Add_Exc_Msg

Line 1917: x_return_status := FND_API.G_RET_STS_SUCCESS;

1913: IS
1914: l_return_status Varchar2(30);
1915: BEGIN
1916: OE_MSG_PUB.initialize;
1917: x_return_status := FND_API.G_RET_STS_SUCCESS;
1918: QP_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
1919: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS
1920: ,p_entity_id => p_qualifier_id
1921: ,x_return_status => l_return_status);

Line 1945: x_return_status := FND_API.G_RET_STS_ERROR;

1941: OE_MSG_PUB.Count_And_Get
1942: ( p_count => x_msg_count
1943: , p_data => x_msg_data
1944: );
1945: x_return_status := FND_API.G_RET_STS_ERROR;
1946:
1947: END Clear_Record;
1948:
1949:

Line 1961: x_return_status := FND_API.G_RET_STS_SUCCESS;

1957: IS
1958: l_return_status Varchar2(30);
1959: BEGIN
1960: OE_MSG_PUB.initialize;
1961: x_return_status := FND_API.G_RET_STS_SUCCESS;
1962: QP_DELAYED_REQUESTS_PVT.Clear_Request(
1963: x_return_status => l_return_status);
1964:
1965: EXCEPTION

Line 1979: x_return_status := FND_API.G_RET_STS_ERROR;

1975: OE_MSG_PUB.Count_And_Get
1976: ( p_count => x_msg_count
1977: , p_data => x_msg_data
1978: );
1979: x_return_status := FND_API.G_RET_STS_ERROR;
1980:
1981: END Delete_All_Requests;
1982:
1983: