eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QP_QP_FORM_QUALIFIERS dependencies on FND_API

Line 144: , p_init_msg_list => FND_API.G_TRUE

140: -- Call QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
141:
142: QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
143: ( p_api_version_number => 1.0
144: , p_init_msg_list => FND_API.G_TRUE
145: , x_return_status => l_return_status
146: , x_msg_count => x_msg_count
147: , x_msg_data => x_msg_data
148: , p_control_rec => l_control_rec

Line 154: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

150: , x_QUALIFIER_RULES_rec => l_x_QUALIFIER_RULES_rec
151: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
152: );
153:
154: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;

Line 155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

151: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
152: );
153:
154: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:

Line 156: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

152: );
153:
154: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160:

Line 157: RAISE FND_API.G_EXC_ERROR;

153:
154: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
155: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
156: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159:
160:
161: -- Unload out tbl

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

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

Line 226: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 238: WHEN FND_API.G_EXC_ERROR THEN

234:
235:
236: EXCEPTION
237:
238: WHEN FND_API.G_EXC_ERROR THEN
239:
240: x_return_status := FND_API.G_RET_STS_ERROR;
241:
242: -- Get message count and data

Line 240: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

466: , 'Unrecognized attribute'
467: );
468: END IF;
469:
470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
471:
472: END IF;
473:
474: -- Set Operation.

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

472: END IF;
473:
474: -- Set Operation.
475:
476: IF FND_API.To_Boolean(l_QUALIFIERS_rec.db_flag) THEN
477: l_QUALIFIERS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
478: ELSE
479: l_QUALIFIERS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
480: END IF;

Line 503: , p_init_msg_list => FND_API.G_TRUE

499:
500:
501: QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
502: ( p_api_version_number => 1.0
503: , p_init_msg_list => FND_API.G_TRUE
504: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
505: , x_return_status => l_return_status
506: , x_msg_count => x_msg_count
507: , x_msg_data => x_msg_data

Line 504: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

500:
501: QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
502: ( p_api_version_number => 1.0
503: , p_init_msg_list => FND_API.G_TRUE
504: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
505: , x_return_status => l_return_status
506: , x_msg_count => x_msg_count
507: , x_msg_data => x_msg_data
508: , p_control_rec => l_control_rec

Line 515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

511: , x_QUALIFIER_RULES_rec => l_x_QUALIFIER_RULES_rec
512: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
513: );
514:
515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
517: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
518: RAISE FND_API.G_EXC_ERROR;
519: END IF;

Line 516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

512: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
513: );
514:
515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
517: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
518: RAISE FND_API.G_EXC_ERROR;
519: END IF;
520:

Line 517: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

513: );
514:
515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
517: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
518: RAISE FND_API.G_EXC_ERROR;
519: END IF;
520:
521:

Line 518: RAISE FND_API.G_EXC_ERROR;

514:
515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
516: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
517: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
518: RAISE FND_API.G_EXC_ERROR;
519: END IF;
520:
521:
522: -- Unload out tbl

Line 528: x_attribute1 := FND_API.G_MISS_CHAR;

524: l_x_QUALIFIERS_rec := l_x_QUALIFIERS_tbl(1);
525:
526: -- Init OUT parameters to missing.
527:
528: x_attribute1 := FND_API.G_MISS_CHAR;
529: x_attribute10 := FND_API.G_MISS_CHAR;
530: x_attribute11 := FND_API.G_MISS_CHAR;
531: x_attribute12 := FND_API.G_MISS_CHAR;
532: x_attribute13 := FND_API.G_MISS_CHAR;

Line 529: x_attribute10 := FND_API.G_MISS_CHAR;

525:
526: -- Init OUT parameters to missing.
527:
528: x_attribute1 := FND_API.G_MISS_CHAR;
529: x_attribute10 := FND_API.G_MISS_CHAR;
530: x_attribute11 := FND_API.G_MISS_CHAR;
531: x_attribute12 := FND_API.G_MISS_CHAR;
532: x_attribute13 := FND_API.G_MISS_CHAR;
533: x_attribute14 := FND_API.G_MISS_CHAR;

Line 530: x_attribute11 := FND_API.G_MISS_CHAR;

526: -- Init OUT parameters to missing.
527:
528: x_attribute1 := FND_API.G_MISS_CHAR;
529: x_attribute10 := FND_API.G_MISS_CHAR;
530: x_attribute11 := FND_API.G_MISS_CHAR;
531: x_attribute12 := FND_API.G_MISS_CHAR;
532: x_attribute13 := FND_API.G_MISS_CHAR;
533: x_attribute14 := FND_API.G_MISS_CHAR;
534: x_attribute15 := FND_API.G_MISS_CHAR;

Line 531: x_attribute12 := FND_API.G_MISS_CHAR;

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

Line 532: x_attribute13 := FND_API.G_MISS_CHAR;

528: x_attribute1 := FND_API.G_MISS_CHAR;
529: x_attribute10 := FND_API.G_MISS_CHAR;
530: x_attribute11 := FND_API.G_MISS_CHAR;
531: x_attribute12 := FND_API.G_MISS_CHAR;
532: x_attribute13 := FND_API.G_MISS_CHAR;
533: x_attribute14 := FND_API.G_MISS_CHAR;
534: x_attribute15 := FND_API.G_MISS_CHAR;
535: x_attribute2 := FND_API.G_MISS_CHAR;
536: x_attribute3 := FND_API.G_MISS_CHAR;

Line 533: x_attribute14 := FND_API.G_MISS_CHAR;

529: x_attribute10 := FND_API.G_MISS_CHAR;
530: x_attribute11 := FND_API.G_MISS_CHAR;
531: x_attribute12 := FND_API.G_MISS_CHAR;
532: x_attribute13 := FND_API.G_MISS_CHAR;
533: x_attribute14 := FND_API.G_MISS_CHAR;
534: x_attribute15 := FND_API.G_MISS_CHAR;
535: x_attribute2 := FND_API.G_MISS_CHAR;
536: x_attribute3 := FND_API.G_MISS_CHAR;
537: x_attribute4 := FND_API.G_MISS_CHAR;

Line 534: x_attribute15 := FND_API.G_MISS_CHAR;

530: x_attribute11 := FND_API.G_MISS_CHAR;
531: x_attribute12 := FND_API.G_MISS_CHAR;
532: x_attribute13 := FND_API.G_MISS_CHAR;
533: x_attribute14 := FND_API.G_MISS_CHAR;
534: x_attribute15 := FND_API.G_MISS_CHAR;
535: x_attribute2 := FND_API.G_MISS_CHAR;
536: x_attribute3 := FND_API.G_MISS_CHAR;
537: x_attribute4 := FND_API.G_MISS_CHAR;
538: x_attribute5 := FND_API.G_MISS_CHAR;

Line 535: x_attribute2 := FND_API.G_MISS_CHAR;

531: x_attribute12 := FND_API.G_MISS_CHAR;
532: x_attribute13 := FND_API.G_MISS_CHAR;
533: x_attribute14 := FND_API.G_MISS_CHAR;
534: x_attribute15 := FND_API.G_MISS_CHAR;
535: x_attribute2 := FND_API.G_MISS_CHAR;
536: x_attribute3 := FND_API.G_MISS_CHAR;
537: x_attribute4 := FND_API.G_MISS_CHAR;
538: x_attribute5 := FND_API.G_MISS_CHAR;
539: x_attribute6 := FND_API.G_MISS_CHAR;

Line 536: x_attribute3 := FND_API.G_MISS_CHAR;

532: x_attribute13 := FND_API.G_MISS_CHAR;
533: x_attribute14 := FND_API.G_MISS_CHAR;
534: x_attribute15 := FND_API.G_MISS_CHAR;
535: x_attribute2 := FND_API.G_MISS_CHAR;
536: x_attribute3 := FND_API.G_MISS_CHAR;
537: x_attribute4 := FND_API.G_MISS_CHAR;
538: x_attribute5 := FND_API.G_MISS_CHAR;
539: x_attribute6 := FND_API.G_MISS_CHAR;
540: x_attribute7 := FND_API.G_MISS_CHAR;

Line 537: x_attribute4 := FND_API.G_MISS_CHAR;

533: x_attribute14 := FND_API.G_MISS_CHAR;
534: x_attribute15 := FND_API.G_MISS_CHAR;
535: x_attribute2 := FND_API.G_MISS_CHAR;
536: x_attribute3 := FND_API.G_MISS_CHAR;
537: x_attribute4 := FND_API.G_MISS_CHAR;
538: x_attribute5 := FND_API.G_MISS_CHAR;
539: x_attribute6 := FND_API.G_MISS_CHAR;
540: x_attribute7 := FND_API.G_MISS_CHAR;
541: x_attribute8 := FND_API.G_MISS_CHAR;

Line 538: x_attribute5 := FND_API.G_MISS_CHAR;

534: x_attribute15 := FND_API.G_MISS_CHAR;
535: x_attribute2 := FND_API.G_MISS_CHAR;
536: x_attribute3 := FND_API.G_MISS_CHAR;
537: x_attribute4 := FND_API.G_MISS_CHAR;
538: x_attribute5 := FND_API.G_MISS_CHAR;
539: x_attribute6 := FND_API.G_MISS_CHAR;
540: x_attribute7 := FND_API.G_MISS_CHAR;
541: x_attribute8 := FND_API.G_MISS_CHAR;
542: x_attribute9 := FND_API.G_MISS_CHAR;

Line 539: x_attribute6 := FND_API.G_MISS_CHAR;

535: x_attribute2 := FND_API.G_MISS_CHAR;
536: x_attribute3 := FND_API.G_MISS_CHAR;
537: x_attribute4 := FND_API.G_MISS_CHAR;
538: x_attribute5 := FND_API.G_MISS_CHAR;
539: x_attribute6 := FND_API.G_MISS_CHAR;
540: x_attribute7 := FND_API.G_MISS_CHAR;
541: x_attribute8 := FND_API.G_MISS_CHAR;
542: x_attribute9 := FND_API.G_MISS_CHAR;
543: x_comparison_operator_code := FND_API.G_MISS_CHAR;

Line 540: x_attribute7 := FND_API.G_MISS_CHAR;

536: x_attribute3 := FND_API.G_MISS_CHAR;
537: x_attribute4 := FND_API.G_MISS_CHAR;
538: x_attribute5 := FND_API.G_MISS_CHAR;
539: x_attribute6 := FND_API.G_MISS_CHAR;
540: x_attribute7 := FND_API.G_MISS_CHAR;
541: x_attribute8 := FND_API.G_MISS_CHAR;
542: x_attribute9 := FND_API.G_MISS_CHAR;
543: x_comparison_operator_code := FND_API.G_MISS_CHAR;
544: x_context := FND_API.G_MISS_CHAR;

Line 541: x_attribute8 := FND_API.G_MISS_CHAR;

537: x_attribute4 := FND_API.G_MISS_CHAR;
538: x_attribute5 := FND_API.G_MISS_CHAR;
539: x_attribute6 := FND_API.G_MISS_CHAR;
540: x_attribute7 := FND_API.G_MISS_CHAR;
541: x_attribute8 := FND_API.G_MISS_CHAR;
542: x_attribute9 := FND_API.G_MISS_CHAR;
543: x_comparison_operator_code := FND_API.G_MISS_CHAR;
544: x_context := FND_API.G_MISS_CHAR;
545: x_created_from_rule_id := FND_API.G_MISS_NUM;

Line 542: x_attribute9 := FND_API.G_MISS_CHAR;

538: x_attribute5 := FND_API.G_MISS_CHAR;
539: x_attribute6 := FND_API.G_MISS_CHAR;
540: x_attribute7 := FND_API.G_MISS_CHAR;
541: x_attribute8 := FND_API.G_MISS_CHAR;
542: x_attribute9 := FND_API.G_MISS_CHAR;
543: x_comparison_operator_code := FND_API.G_MISS_CHAR;
544: x_context := FND_API.G_MISS_CHAR;
545: x_created_from_rule_id := FND_API.G_MISS_NUM;
546: x_end_date_active := FND_API.G_MISS_DATE;

Line 543: x_comparison_operator_code := FND_API.G_MISS_CHAR;

539: x_attribute6 := FND_API.G_MISS_CHAR;
540: x_attribute7 := FND_API.G_MISS_CHAR;
541: x_attribute8 := FND_API.G_MISS_CHAR;
542: x_attribute9 := FND_API.G_MISS_CHAR;
543: x_comparison_operator_code := FND_API.G_MISS_CHAR;
544: x_context := FND_API.G_MISS_CHAR;
545: x_created_from_rule_id := FND_API.G_MISS_NUM;
546: x_end_date_active := FND_API.G_MISS_DATE;
547: x_excluder_flag := FND_API.G_MISS_CHAR;

Line 544: x_context := FND_API.G_MISS_CHAR;

540: x_attribute7 := FND_API.G_MISS_CHAR;
541: x_attribute8 := FND_API.G_MISS_CHAR;
542: x_attribute9 := FND_API.G_MISS_CHAR;
543: x_comparison_operator_code := FND_API.G_MISS_CHAR;
544: x_context := FND_API.G_MISS_CHAR;
545: x_created_from_rule_id := FND_API.G_MISS_NUM;
546: x_end_date_active := FND_API.G_MISS_DATE;
547: x_excluder_flag := FND_API.G_MISS_CHAR;
548: x_list_header_id := FND_API.G_MISS_NUM;

Line 545: x_created_from_rule_id := FND_API.G_MISS_NUM;

541: x_attribute8 := FND_API.G_MISS_CHAR;
542: x_attribute9 := FND_API.G_MISS_CHAR;
543: x_comparison_operator_code := FND_API.G_MISS_CHAR;
544: x_context := FND_API.G_MISS_CHAR;
545: x_created_from_rule_id := FND_API.G_MISS_NUM;
546: x_end_date_active := FND_API.G_MISS_DATE;
547: x_excluder_flag := FND_API.G_MISS_CHAR;
548: x_list_header_id := FND_API.G_MISS_NUM;
549: x_list_line_id := FND_API.G_MISS_NUM;

Line 546: x_end_date_active := FND_API.G_MISS_DATE;

542: x_attribute9 := FND_API.G_MISS_CHAR;
543: x_comparison_operator_code := FND_API.G_MISS_CHAR;
544: x_context := FND_API.G_MISS_CHAR;
545: x_created_from_rule_id := FND_API.G_MISS_NUM;
546: x_end_date_active := FND_API.G_MISS_DATE;
547: x_excluder_flag := FND_API.G_MISS_CHAR;
548: x_list_header_id := FND_API.G_MISS_NUM;
549: x_list_line_id := FND_API.G_MISS_NUM;
550: x_qualifier_attribute := FND_API.G_MISS_CHAR;

Line 547: x_excluder_flag := FND_API.G_MISS_CHAR;

543: x_comparison_operator_code := FND_API.G_MISS_CHAR;
544: x_context := FND_API.G_MISS_CHAR;
545: x_created_from_rule_id := FND_API.G_MISS_NUM;
546: x_end_date_active := FND_API.G_MISS_DATE;
547: x_excluder_flag := FND_API.G_MISS_CHAR;
548: x_list_header_id := FND_API.G_MISS_NUM;
549: x_list_line_id := FND_API.G_MISS_NUM;
550: x_qualifier_attribute := FND_API.G_MISS_CHAR;
551: x_qualifier_attr_value := FND_API.G_MISS_CHAR;

Line 548: x_list_header_id := FND_API.G_MISS_NUM;

544: x_context := FND_API.G_MISS_CHAR;
545: x_created_from_rule_id := FND_API.G_MISS_NUM;
546: x_end_date_active := FND_API.G_MISS_DATE;
547: x_excluder_flag := FND_API.G_MISS_CHAR;
548: x_list_header_id := FND_API.G_MISS_NUM;
549: x_list_line_id := FND_API.G_MISS_NUM;
550: x_qualifier_attribute := FND_API.G_MISS_CHAR;
551: x_qualifier_attr_value := FND_API.G_MISS_CHAR;
552: x_qualifier_attr_value_to := FND_API.G_MISS_CHAR;

Line 549: x_list_line_id := FND_API.G_MISS_NUM;

545: x_created_from_rule_id := FND_API.G_MISS_NUM;
546: x_end_date_active := FND_API.G_MISS_DATE;
547: x_excluder_flag := FND_API.G_MISS_CHAR;
548: x_list_header_id := FND_API.G_MISS_NUM;
549: x_list_line_id := FND_API.G_MISS_NUM;
550: x_qualifier_attribute := FND_API.G_MISS_CHAR;
551: x_qualifier_attr_value := FND_API.G_MISS_CHAR;
552: x_qualifier_attr_value_to := FND_API.G_MISS_CHAR;
553: x_qualifier_context := FND_API.G_MISS_CHAR;

Line 550: x_qualifier_attribute := FND_API.G_MISS_CHAR;

546: x_end_date_active := FND_API.G_MISS_DATE;
547: x_excluder_flag := FND_API.G_MISS_CHAR;
548: x_list_header_id := FND_API.G_MISS_NUM;
549: x_list_line_id := FND_API.G_MISS_NUM;
550: x_qualifier_attribute := FND_API.G_MISS_CHAR;
551: x_qualifier_attr_value := FND_API.G_MISS_CHAR;
552: x_qualifier_attr_value_to := FND_API.G_MISS_CHAR;
553: x_qualifier_context := FND_API.G_MISS_CHAR;
554: x_qualifier_datatype := FND_API.G_MISS_CHAR;

Line 551: x_qualifier_attr_value := FND_API.G_MISS_CHAR;

547: x_excluder_flag := FND_API.G_MISS_CHAR;
548: x_list_header_id := FND_API.G_MISS_NUM;
549: x_list_line_id := FND_API.G_MISS_NUM;
550: x_qualifier_attribute := FND_API.G_MISS_CHAR;
551: x_qualifier_attr_value := FND_API.G_MISS_CHAR;
552: x_qualifier_attr_value_to := FND_API.G_MISS_CHAR;
553: x_qualifier_context := FND_API.G_MISS_CHAR;
554: x_qualifier_datatype := FND_API.G_MISS_CHAR;
555: --x_qualifier_date_format := FND_API.G_MISS_CHAR;

Line 552: x_qualifier_attr_value_to := FND_API.G_MISS_CHAR;

548: x_list_header_id := FND_API.G_MISS_NUM;
549: x_list_line_id := FND_API.G_MISS_NUM;
550: x_qualifier_attribute := FND_API.G_MISS_CHAR;
551: x_qualifier_attr_value := FND_API.G_MISS_CHAR;
552: x_qualifier_attr_value_to := FND_API.G_MISS_CHAR;
553: x_qualifier_context := FND_API.G_MISS_CHAR;
554: x_qualifier_datatype := FND_API.G_MISS_CHAR;
555: --x_qualifier_date_format := FND_API.G_MISS_CHAR;
556: x_qualifier_grouping_no := FND_API.G_MISS_NUM;

Line 553: x_qualifier_context := FND_API.G_MISS_CHAR;

549: x_list_line_id := FND_API.G_MISS_NUM;
550: x_qualifier_attribute := FND_API.G_MISS_CHAR;
551: x_qualifier_attr_value := FND_API.G_MISS_CHAR;
552: x_qualifier_attr_value_to := FND_API.G_MISS_CHAR;
553: x_qualifier_context := FND_API.G_MISS_CHAR;
554: x_qualifier_datatype := FND_API.G_MISS_CHAR;
555: --x_qualifier_date_format := FND_API.G_MISS_CHAR;
556: x_qualifier_grouping_no := FND_API.G_MISS_NUM;
557: x_qualifier_id := FND_API.G_MISS_NUM;

Line 554: x_qualifier_datatype := FND_API.G_MISS_CHAR;

550: x_qualifier_attribute := FND_API.G_MISS_CHAR;
551: x_qualifier_attr_value := FND_API.G_MISS_CHAR;
552: x_qualifier_attr_value_to := FND_API.G_MISS_CHAR;
553: x_qualifier_context := FND_API.G_MISS_CHAR;
554: x_qualifier_datatype := FND_API.G_MISS_CHAR;
555: --x_qualifier_date_format := FND_API.G_MISS_CHAR;
556: x_qualifier_grouping_no := FND_API.G_MISS_NUM;
557: x_qualifier_id := FND_API.G_MISS_NUM;
558: --x_qualifier_number_format := FND_API.G_MISS_CHAR;

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

551: x_qualifier_attr_value := FND_API.G_MISS_CHAR;
552: x_qualifier_attr_value_to := FND_API.G_MISS_CHAR;
553: x_qualifier_context := FND_API.G_MISS_CHAR;
554: x_qualifier_datatype := FND_API.G_MISS_CHAR;
555: --x_qualifier_date_format := FND_API.G_MISS_CHAR;
556: x_qualifier_grouping_no := FND_API.G_MISS_NUM;
557: x_qualifier_id := FND_API.G_MISS_NUM;
558: --x_qualifier_number_format := FND_API.G_MISS_CHAR;
559: x_qualifier_precedence := FND_API.G_MISS_NUM;

Line 556: x_qualifier_grouping_no := FND_API.G_MISS_NUM;

552: x_qualifier_attr_value_to := FND_API.G_MISS_CHAR;
553: x_qualifier_context := FND_API.G_MISS_CHAR;
554: x_qualifier_datatype := FND_API.G_MISS_CHAR;
555: --x_qualifier_date_format := FND_API.G_MISS_CHAR;
556: x_qualifier_grouping_no := FND_API.G_MISS_NUM;
557: x_qualifier_id := FND_API.G_MISS_NUM;
558: --x_qualifier_number_format := FND_API.G_MISS_CHAR;
559: x_qualifier_precedence := FND_API.G_MISS_NUM;
560: x_qualifier_rule_id := FND_API.G_MISS_NUM;

Line 557: x_qualifier_id := FND_API.G_MISS_NUM;

553: x_qualifier_context := FND_API.G_MISS_CHAR;
554: x_qualifier_datatype := FND_API.G_MISS_CHAR;
555: --x_qualifier_date_format := FND_API.G_MISS_CHAR;
556: x_qualifier_grouping_no := FND_API.G_MISS_NUM;
557: x_qualifier_id := FND_API.G_MISS_NUM;
558: --x_qualifier_number_format := FND_API.G_MISS_CHAR;
559: x_qualifier_precedence := FND_API.G_MISS_NUM;
560: x_qualifier_rule_id := FND_API.G_MISS_NUM;
561: x_start_date_active := FND_API.G_MISS_DATE;

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

554: x_qualifier_datatype := FND_API.G_MISS_CHAR;
555: --x_qualifier_date_format := FND_API.G_MISS_CHAR;
556: x_qualifier_grouping_no := FND_API.G_MISS_NUM;
557: x_qualifier_id := FND_API.G_MISS_NUM;
558: --x_qualifier_number_format := FND_API.G_MISS_CHAR;
559: x_qualifier_precedence := FND_API.G_MISS_NUM;
560: x_qualifier_rule_id := FND_API.G_MISS_NUM;
561: x_start_date_active := FND_API.G_MISS_DATE;
562: --x_comparison_operator := FND_API.G_MISS_CHAR;

Line 559: x_qualifier_precedence := FND_API.G_MISS_NUM;

555: --x_qualifier_date_format := FND_API.G_MISS_CHAR;
556: x_qualifier_grouping_no := FND_API.G_MISS_NUM;
557: x_qualifier_id := FND_API.G_MISS_NUM;
558: --x_qualifier_number_format := FND_API.G_MISS_CHAR;
559: x_qualifier_precedence := FND_API.G_MISS_NUM;
560: x_qualifier_rule_id := FND_API.G_MISS_NUM;
561: x_start_date_active := FND_API.G_MISS_DATE;
562: --x_comparison_operator := FND_API.G_MISS_CHAR;
563: x_created_from_rule := FND_API.G_MISS_CHAR;

Line 560: x_qualifier_rule_id := FND_API.G_MISS_NUM;

556: x_qualifier_grouping_no := FND_API.G_MISS_NUM;
557: x_qualifier_id := FND_API.G_MISS_NUM;
558: --x_qualifier_number_format := FND_API.G_MISS_CHAR;
559: x_qualifier_precedence := FND_API.G_MISS_NUM;
560: x_qualifier_rule_id := FND_API.G_MISS_NUM;
561: x_start_date_active := FND_API.G_MISS_DATE;
562: --x_comparison_operator := FND_API.G_MISS_CHAR;
563: x_created_from_rule := FND_API.G_MISS_CHAR;
564: --x_excluder := FND_API.G_MISS_CHAR;

Line 561: x_start_date_active := FND_API.G_MISS_DATE;

557: x_qualifier_id := FND_API.G_MISS_NUM;
558: --x_qualifier_number_format := FND_API.G_MISS_CHAR;
559: x_qualifier_precedence := FND_API.G_MISS_NUM;
560: x_qualifier_rule_id := FND_API.G_MISS_NUM;
561: x_start_date_active := FND_API.G_MISS_DATE;
562: --x_comparison_operator := FND_API.G_MISS_CHAR;
563: x_created_from_rule := FND_API.G_MISS_CHAR;
564: --x_excluder := FND_API.G_MISS_CHAR;
565: x_list_header := FND_API.G_MISS_CHAR;

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

558: --x_qualifier_number_format := FND_API.G_MISS_CHAR;
559: x_qualifier_precedence := FND_API.G_MISS_NUM;
560: x_qualifier_rule_id := FND_API.G_MISS_NUM;
561: x_start_date_active := FND_API.G_MISS_DATE;
562: --x_comparison_operator := FND_API.G_MISS_CHAR;
563: x_created_from_rule := FND_API.G_MISS_CHAR;
564: --x_excluder := FND_API.G_MISS_CHAR;
565: x_list_header := FND_API.G_MISS_CHAR;
566: x_list_line := FND_API.G_MISS_CHAR;

Line 563: x_created_from_rule := FND_API.G_MISS_CHAR;

559: x_qualifier_precedence := FND_API.G_MISS_NUM;
560: x_qualifier_rule_id := FND_API.G_MISS_NUM;
561: x_start_date_active := FND_API.G_MISS_DATE;
562: --x_comparison_operator := FND_API.G_MISS_CHAR;
563: x_created_from_rule := FND_API.G_MISS_CHAR;
564: --x_excluder := FND_API.G_MISS_CHAR;
565: x_list_header := FND_API.G_MISS_CHAR;
566: x_list_line := FND_API.G_MISS_CHAR;
567: --x_qualifier := FND_API.G_MISS_CHAR;

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

560: x_qualifier_rule_id := FND_API.G_MISS_NUM;
561: x_start_date_active := FND_API.G_MISS_DATE;
562: --x_comparison_operator := FND_API.G_MISS_CHAR;
563: x_created_from_rule := FND_API.G_MISS_CHAR;
564: --x_excluder := FND_API.G_MISS_CHAR;
565: x_list_header := FND_API.G_MISS_CHAR;
566: x_list_line := FND_API.G_MISS_CHAR;
567: --x_qualifier := FND_API.G_MISS_CHAR;
568: x_qualifier_rule := FND_API.G_MISS_CHAR;

Line 565: x_list_header := FND_API.G_MISS_CHAR;

561: x_start_date_active := FND_API.G_MISS_DATE;
562: --x_comparison_operator := FND_API.G_MISS_CHAR;
563: x_created_from_rule := FND_API.G_MISS_CHAR;
564: --x_excluder := FND_API.G_MISS_CHAR;
565: x_list_header := FND_API.G_MISS_CHAR;
566: x_list_line := FND_API.G_MISS_CHAR;
567: --x_qualifier := FND_API.G_MISS_CHAR;
568: x_qualifier_rule := FND_API.G_MISS_CHAR;
569:

Line 566: x_list_line := FND_API.G_MISS_CHAR;

562: --x_comparison_operator := FND_API.G_MISS_CHAR;
563: x_created_from_rule := FND_API.G_MISS_CHAR;
564: --x_excluder := FND_API.G_MISS_CHAR;
565: x_list_header := FND_API.G_MISS_CHAR;
566: x_list_line := FND_API.G_MISS_CHAR;
567: --x_qualifier := FND_API.G_MISS_CHAR;
568: x_qualifier_rule := FND_API.G_MISS_CHAR;
569:
570: -- Load display out parameters if any

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

563: x_created_from_rule := FND_API.G_MISS_CHAR;
564: --x_excluder := FND_API.G_MISS_CHAR;
565: x_list_header := FND_API.G_MISS_CHAR;
566: x_list_line := FND_API.G_MISS_CHAR;
567: --x_qualifier := FND_API.G_MISS_CHAR;
568: x_qualifier_rule := FND_API.G_MISS_CHAR;
569:
570: -- Load display out parameters if any
571:

Line 568: x_qualifier_rule := FND_API.G_MISS_CHAR;

564: --x_excluder := FND_API.G_MISS_CHAR;
565: x_list_header := FND_API.G_MISS_CHAR;
566: x_list_line := FND_API.G_MISS_CHAR;
567: --x_qualifier := FND_API.G_MISS_CHAR;
568: x_qualifier_rule := FND_API.G_MISS_CHAR;
569:
570: -- Load display out parameters if any
571:
572: l_QUALIFIERS_val_rec := QP_Qualifiers_Util.Get_Values

Line 798: x_return_status := FND_API.G_RET_STS_SUCCESS;

794: );
795:
796: -- Set return status.
797:
798: x_return_status := FND_API.G_RET_STS_SUCCESS;
799:
800: -- Get message count and data
801:
802: OE_MSG_PUB.Count_And_Get

Line 810: WHEN FND_API.G_EXC_ERROR THEN

806:
807:
808: EXCEPTION
809:
810: WHEN FND_API.G_EXC_ERROR THEN
811:
812: x_return_status := FND_API.G_RET_STS_ERROR;
813:
814: -- Get message count and data

Line 812: x_return_status := FND_API.G_RET_STS_ERROR;

808: EXCEPTION
809:
810: WHEN FND_API.G_EXC_ERROR THEN
811:
812: x_return_status := FND_API.G_RET_STS_ERROR;
813:
814: -- Get message count and data
815:
816: OE_MSG_PUB.Count_And_Get

Line 821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

817: ( p_count => x_msg_count
818: , p_data => x_msg_data
819: );
820:
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
822:
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
824:
825: -- Get message count and data

Line 823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

819: );
820:
821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
822:
823: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
824:
825: -- Get message count and data
826:
827: OE_MSG_PUB.Count_And_Get

Line 834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

830: );
831:
832: WHEN OTHERS THEN
833:
834: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
835:
836: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
837: THEN
838: OE_MSG_PUB.Add_Exc_Msg

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

904: );
905:
906: -- Set Operation.
907:
908: IF FND_API.To_Boolean(l_QUALIFIERS_rec.db_flag) THEN
909: l_QUALIFIERS_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
910: ELSE
911: l_QUALIFIERS_rec.operation := QP_GLOBALS.G_OPR_CREATE;
912: END IF;

Line 933: , p_init_msg_list => FND_API.G_TRUE

929:
930:
931: QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
932: ( p_api_version_number => 1.0
933: , p_init_msg_list => FND_API.G_TRUE
934: , x_return_status => l_return_status
935: , x_msg_count => x_msg_count
936: , x_msg_data => x_msg_data
937: , p_control_rec => l_control_rec

Line 944: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

940: , x_QUALIFIER_RULES_rec => l_x_QUALIFIER_RULES_rec
941: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
942: );
943:
944: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
946: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
947: RAISE FND_API.G_EXC_ERROR;
948: END IF;

Line 945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

941: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
942: );
943:
944: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
946: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
947: RAISE FND_API.G_EXC_ERROR;
948: END IF;
949:

Line 946: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

942: );
943:
944: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
946: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
947: RAISE FND_API.G_EXC_ERROR;
948: END IF;
949:
950:

Line 947: RAISE FND_API.G_EXC_ERROR;

943:
944: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
945: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
946: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
947: RAISE FND_API.G_EXC_ERROR;
948: END IF;
949:
950:
951: -- Load OUT parameters.

Line 972: x_return_status := FND_API.G_RET_STS_SUCCESS;

968:
969:
970: -- Set return status.
971:
972: x_return_status := FND_API.G_RET_STS_SUCCESS;
973:
974: -- Get message count and data
975:
976: OE_MSG_PUB.Count_And_Get

Line 984: WHEN FND_API.G_EXC_ERROR THEN

980:
981:
982: EXCEPTION
983:
984: WHEN FND_API.G_EXC_ERROR THEN
985:
986: x_return_status := FND_API.G_RET_STS_ERROR;
987:
988: -- Get message count and data

Line 986: x_return_status := FND_API.G_RET_STS_ERROR;

982: EXCEPTION
983:
984: WHEN FND_API.G_EXC_ERROR THEN
985:
986: x_return_status := FND_API.G_RET_STS_ERROR;
987:
988: -- Get message count and data
989:
990: OE_MSG_PUB.Count_And_Get

Line 995: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

991: ( p_count => x_msg_count
992: , p_data => x_msg_data
993: );
994:
995: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
996:
997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
998:
999: -- Get message count and data

Line 997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

993: );
994:
995: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
996:
997: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
998:
999: -- Get message count and data
1000:
1001: OE_MSG_PUB.Count_And_Get

Line 1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1004: );
1005:
1006: WHEN OTHERS THEN
1007:
1008: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1009:
1010: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1011: THEN
1012: OE_MSG_PUB.Add_Exc_Msg

Line 1080: , p_init_msg_list => FND_API.G_TRUE

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

Line 1090: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1086: , x_QUALIFIER_RULES_rec => l_x_QUALIFIER_RULES_rec
1087: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1088: );
1089:
1090: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1092: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1093: RAISE FND_API.G_EXC_ERROR;
1094: END IF;

Line 1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1092: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1093: RAISE FND_API.G_EXC_ERROR;

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

Line 1103: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1115: WHEN FND_API.G_EXC_ERROR THEN

1111:
1112:
1113: EXCEPTION
1114:
1115: WHEN FND_API.G_EXC_ERROR THEN
1116:
1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118:
1119: -- Get message count and data

Line 1117: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1135: );
1136:
1137: WHEN OTHERS THEN
1138:
1139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1140:
1141: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1142: THEN
1143: OE_MSG_PUB.Add_Exc_Msg

Line 1194: , p_init_msg_list => FND_API.G_TRUE

1190: -- Call QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
1191:
1192: QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
1193: ( p_api_version_number => 1.0
1194: , p_init_msg_list => FND_API.G_TRUE
1195: , x_return_status => l_return_status
1196: , x_msg_count => x_msg_count
1197: , x_msg_data => x_msg_data
1198: , p_control_rec => l_control_rec

Line 1203: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1199: , x_QUALIFIER_RULES_rec => l_x_QUALIFIER_RULES_rec
1200: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1201: );
1202:
1203: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1205: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;

Line 1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1200: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1201: );
1202:
1203: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1205: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208:

Line 1205: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1201: );
1202:
1203: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1205: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208:
1209:

Line 1206: RAISE FND_API.G_EXC_ERROR;

1202:
1203: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1205: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208:
1209:
1210: -- Set return status.

Line 1212: x_return_status := FND_API.G_RET_STS_SUCCESS;

1208:
1209:
1210: -- Set return status.
1211:
1212: x_return_status := FND_API.G_RET_STS_SUCCESS;
1213:
1214: -- Get message count and data
1215:
1216: OE_MSG_PUB.Count_And_Get

Line 1224: WHEN FND_API.G_EXC_ERROR THEN

1220:
1221:
1222: EXCEPTION
1223:
1224: WHEN FND_API.G_EXC_ERROR THEN
1225:
1226: x_return_status := FND_API.G_RET_STS_ERROR;
1227:
1228: -- Get message count and data

Line 1226: x_return_status := FND_API.G_RET_STS_ERROR;

1222: EXCEPTION
1223:
1224: WHEN FND_API.G_EXC_ERROR THEN
1225:
1226: x_return_status := FND_API.G_RET_STS_ERROR;
1227:
1228: -- Get message count and data
1229:
1230: OE_MSG_PUB.Count_And_Get

Line 1235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1231: ( p_count => x_msg_count
1232: , p_data => x_msg_data
1233: );
1234:
1235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1236:
1237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1238:
1239: -- Get message count and data

Line 1237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1233: );
1234:
1235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1236:
1237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1238:
1239: -- Get message count and data
1240:
1241: OE_MSG_PUB.Count_And_Get

Line 1248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1244: );
1245:
1246: WHEN OTHERS THEN
1247:
1248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1249:
1250: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1251: THEN
1252: OE_MSG_PUB.Add_Exc_Msg

Line 1387: , p_init_msg_list => FND_API.G_TRUE

1383: oe_debug_pub.add('calling privates lock row from QPXFQPQB.pls');
1384:
1385: QP_Qualifier_Rules_PVT.Lock_QUALIFIER_RULES
1386: ( p_api_version_number => 1.0
1387: , p_init_msg_list => FND_API.G_TRUE
1388: , x_return_status => l_return_status
1389: , x_msg_count => x_msg_count
1390: , x_msg_data => x_msg_data
1391: , p_QUALIFIERS_tbl => l_QUALIFIERS_tbl

Line 1396: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1392: , x_QUALIFIER_RULES_rec => l_x_QUALIFIER_RULES_rec
1393: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1394: );
1395:
1396: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1397:
1398: -- Set DB flag and write record to cache.
1399:
1400: l_x_QUALIFIERS_rec.db_flag := FND_API.G_TRUE;

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

1396: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1397:
1398: -- Set DB flag and write record to cache.
1399:
1400: l_x_QUALIFIERS_rec.db_flag := FND_API.G_TRUE;
1401:
1402: Write_QUALIFIERS
1403: ( p_QUALIFIERS_rec => l_x_QUALIFIERS_rec
1404: , p_db_record => TRUE

Line 1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1429: , 'Lock_Row'
1430: );
1431: END IF;
1432:
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1434:
1435: -- Get message count and data
1436:
1437: OE_MSG_PUB.Count_And_Get

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

1480: g_QUALIFIERS_rec := QP_Qualifiers_Util.Query_Row
1481: ( p_qualifier_id => p_qualifier_id
1482: );
1483:
1484: g_QUALIFIERS_rec.db_flag := FND_API.G_TRUE;
1485:
1486: -- Load DB record
1487:
1488: g_db_QUALIFIERS_rec := g_QUALIFIERS_rec;

Line 1532: x_return_status := FND_API.G_RET_STS_SUCCESS;

1528: IS
1529: l_return_status Varchar2(30);
1530: BEGIN
1531: OE_MSG_PUB.initialize;
1532: x_return_status := FND_API.G_RET_STS_SUCCESS;
1533: QP_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
1534: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIERS
1535: ,p_entity_id => p_qualifier_id
1536: ,x_return_status => l_return_status);

Line 1560: x_return_status := FND_API.G_RET_STS_ERROR;

1556: OE_MSG_PUB.Count_And_Get
1557: ( p_count => x_msg_count
1558: , p_data => x_msg_data
1559: );
1560: x_return_status := FND_API.G_RET_STS_ERROR;
1561:
1562: END Clear_Record;
1563:
1564:

Line 1576: x_return_status := FND_API.G_RET_STS_SUCCESS;

1572: IS
1573: l_return_status Varchar2(30);
1574: BEGIN
1575: OE_MSG_PUB.initialize;
1576: x_return_status := FND_API.G_RET_STS_SUCCESS;
1577: QP_DELAYED_REQUESTS_PVT.Clear_Request(
1578: x_return_status => l_return_status);
1579:
1580: EXCEPTION

Line 1594: x_return_status := FND_API.G_RET_STS_ERROR;

1590: OE_MSG_PUB.Count_And_Get
1591: ( p_count => x_msg_count
1592: , p_data => x_msg_data
1593: );
1594: x_return_status := FND_API.G_RET_STS_ERROR;
1595:
1596: END Delete_All_Requests;
1597:
1598: