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

Line 125: , p_init_msg_list => FND_API.G_TRUE

121:
122:
123: QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
124: ( p_api_version_number => 1.0
125: , p_init_msg_list => FND_API.G_TRUE
126: , x_return_status => l_return_status
127: , x_msg_count => x_msg_count
128: , x_msg_data => x_msg_data
129: , p_control_rec => l_control_rec

Line 135: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

131: , x_QUALIFIER_RULES_rec => l_x_QUALIFIER_RULES_rec
132: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
133: );
134:
135: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
138: RAISE FND_API.G_EXC_ERROR;
139: END IF;

Line 136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

132: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
133: );
134:
135: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
138: RAISE FND_API.G_EXC_ERROR;
139: END IF;
140:

Line 137: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

133: );
134:
135: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
138: RAISE FND_API.G_EXC_ERROR;
139: END IF;
140:
141:

Line 138: RAISE FND_API.G_EXC_ERROR;

134:
135: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
138: RAISE FND_API.G_EXC_ERROR;
139: END IF;
140:
141:
142: -- Load OUT parameters.

Line 174: l_x_QUALIFIER_RULES_rec.db_flag := FND_API.G_FALSE;

170:
171: -- Write to cache.
172: -- Set db_flag to False before writing to cache
173:
174: l_x_QUALIFIER_RULES_rec.db_flag := FND_API.G_FALSE;
175:
176: Write_QUALIFIER_RULES
177: ( p_QUALIFIER_RULES_rec => l_x_QUALIFIER_RULES_rec
178: );

Line 182: x_return_status := FND_API.G_RET_STS_SUCCESS;

178: );
179:
180: -- Set return status.
181:
182: x_return_status := FND_API.G_RET_STS_SUCCESS;
183:
184: -- Get message count and data
185:
186: OE_MSG_PUB.Count_And_Get

Line 197: WHEN FND_API.G_EXC_ERROR THEN

193:
194:
195: EXCEPTION
196:
197: WHEN FND_API.G_EXC_ERROR THEN
198:
199: x_return_status := FND_API.G_RET_STS_ERROR;
200:
201: -- Get message count and data

Line 199: x_return_status := FND_API.G_RET_STS_ERROR;

195: EXCEPTION
196:
197: WHEN FND_API.G_EXC_ERROR THEN
198:
199: x_return_status := FND_API.G_RET_STS_ERROR;
200:
201: -- Get message count and data
202:
203: OE_MSG_PUB.Count_And_Get

Line 208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

204: ( p_count => x_msg_count
205: , p_data => x_msg_data
206: );
207:
208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
209:
210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
211:
212: -- Get message count and data

Line 210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

206: );
207:
208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
209:
210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
211:
212: -- Get message count and data
213:
214: OE_MSG_PUB.Count_And_Get

Line 221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

217: );
218:
219: WHEN OTHERS THEN
220:
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
222:
223: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
224: THEN
225: OE_MSG_PUB.Add_Exc_Msg

Line 380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

376: , 'Unrecognized attribute'
377: );
378: END IF;
379:
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381:
382: END IF;
383:
384: -- Set Operation.

Line 386: IF FND_API.To_Boolean(l_QUALIFIER_RULES_rec.db_flag) THEN

382: END IF;
383:
384: -- Set Operation.
385:
386: IF FND_API.To_Boolean(l_QUALIFIER_RULES_rec.db_flag) THEN
387: l_QUALIFIER_RULES_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
388: ELSE
389: l_QUALIFIER_RULES_rec.operation := QP_GLOBALS.G_OPR_CREATE;
390: END IF;

Line 396: , p_init_msg_list => FND_API.G_TRUE

392: -- Call QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
393:
394: QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
395: ( p_api_version_number => 1.0
396: , p_init_msg_list => FND_API.G_TRUE
397: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
398: , x_return_status => l_return_status
399: , x_msg_count => x_msg_count
400: , x_msg_data => x_msg_data

Line 397: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

393:
394: QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
395: ( p_api_version_number => 1.0
396: , p_init_msg_list => FND_API.G_TRUE
397: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
398: , x_return_status => l_return_status
399: , x_msg_count => x_msg_count
400: , x_msg_data => x_msg_data
401: , p_control_rec => l_control_rec

Line 408: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

404: , x_QUALIFIER_RULES_rec => l_x_QUALIFIER_RULES_rec
405: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
406: );
407:
408: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
410: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
411: RAISE FND_API.G_EXC_ERROR;
412: END IF;

Line 409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

405: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
406: );
407:
408: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
410: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
411: RAISE FND_API.G_EXC_ERROR;
412: END IF;
413:

Line 410: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

406: );
407:
408: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
410: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
411: RAISE FND_API.G_EXC_ERROR;
412: END IF;
413:
414:

Line 411: RAISE FND_API.G_EXC_ERROR;

407:
408: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
409: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
410: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
411: RAISE FND_API.G_EXC_ERROR;
412: END IF;
413:
414:
415: -- Init OUT parameters to missing.

Line 417: x_attribute1 := FND_API.G_MISS_CHAR;

413:
414:
415: -- Init OUT parameters to missing.
416:
417: x_attribute1 := FND_API.G_MISS_CHAR;
418: x_attribute10 := FND_API.G_MISS_CHAR;
419: x_attribute11 := FND_API.G_MISS_CHAR;
420: x_attribute12 := FND_API.G_MISS_CHAR;
421: x_attribute13 := FND_API.G_MISS_CHAR;

Line 418: x_attribute10 := FND_API.G_MISS_CHAR;

414:
415: -- Init OUT parameters to missing.
416:
417: x_attribute1 := FND_API.G_MISS_CHAR;
418: x_attribute10 := FND_API.G_MISS_CHAR;
419: x_attribute11 := FND_API.G_MISS_CHAR;
420: x_attribute12 := FND_API.G_MISS_CHAR;
421: x_attribute13 := FND_API.G_MISS_CHAR;
422: x_attribute14 := FND_API.G_MISS_CHAR;

Line 419: x_attribute11 := FND_API.G_MISS_CHAR;

415: -- Init OUT parameters to missing.
416:
417: x_attribute1 := FND_API.G_MISS_CHAR;
418: x_attribute10 := FND_API.G_MISS_CHAR;
419: x_attribute11 := FND_API.G_MISS_CHAR;
420: x_attribute12 := FND_API.G_MISS_CHAR;
421: x_attribute13 := FND_API.G_MISS_CHAR;
422: x_attribute14 := FND_API.G_MISS_CHAR;
423: x_attribute15 := FND_API.G_MISS_CHAR;

Line 420: x_attribute12 := FND_API.G_MISS_CHAR;

416:
417: x_attribute1 := FND_API.G_MISS_CHAR;
418: x_attribute10 := FND_API.G_MISS_CHAR;
419: x_attribute11 := FND_API.G_MISS_CHAR;
420: x_attribute12 := FND_API.G_MISS_CHAR;
421: x_attribute13 := FND_API.G_MISS_CHAR;
422: x_attribute14 := FND_API.G_MISS_CHAR;
423: x_attribute15 := FND_API.G_MISS_CHAR;
424: x_attribute2 := FND_API.G_MISS_CHAR;

Line 421: x_attribute13 := FND_API.G_MISS_CHAR;

417: x_attribute1 := FND_API.G_MISS_CHAR;
418: x_attribute10 := FND_API.G_MISS_CHAR;
419: x_attribute11 := FND_API.G_MISS_CHAR;
420: x_attribute12 := FND_API.G_MISS_CHAR;
421: x_attribute13 := FND_API.G_MISS_CHAR;
422: x_attribute14 := FND_API.G_MISS_CHAR;
423: x_attribute15 := FND_API.G_MISS_CHAR;
424: x_attribute2 := FND_API.G_MISS_CHAR;
425: x_attribute3 := FND_API.G_MISS_CHAR;

Line 422: x_attribute14 := FND_API.G_MISS_CHAR;

418: x_attribute10 := FND_API.G_MISS_CHAR;
419: x_attribute11 := FND_API.G_MISS_CHAR;
420: x_attribute12 := FND_API.G_MISS_CHAR;
421: x_attribute13 := FND_API.G_MISS_CHAR;
422: x_attribute14 := FND_API.G_MISS_CHAR;
423: x_attribute15 := FND_API.G_MISS_CHAR;
424: x_attribute2 := FND_API.G_MISS_CHAR;
425: x_attribute3 := FND_API.G_MISS_CHAR;
426: x_attribute4 := FND_API.G_MISS_CHAR;

Line 423: x_attribute15 := FND_API.G_MISS_CHAR;

419: x_attribute11 := FND_API.G_MISS_CHAR;
420: x_attribute12 := FND_API.G_MISS_CHAR;
421: x_attribute13 := FND_API.G_MISS_CHAR;
422: x_attribute14 := FND_API.G_MISS_CHAR;
423: x_attribute15 := FND_API.G_MISS_CHAR;
424: x_attribute2 := FND_API.G_MISS_CHAR;
425: x_attribute3 := FND_API.G_MISS_CHAR;
426: x_attribute4 := FND_API.G_MISS_CHAR;
427: x_attribute5 := FND_API.G_MISS_CHAR;

Line 424: x_attribute2 := FND_API.G_MISS_CHAR;

420: x_attribute12 := FND_API.G_MISS_CHAR;
421: x_attribute13 := FND_API.G_MISS_CHAR;
422: x_attribute14 := FND_API.G_MISS_CHAR;
423: x_attribute15 := FND_API.G_MISS_CHAR;
424: x_attribute2 := FND_API.G_MISS_CHAR;
425: x_attribute3 := FND_API.G_MISS_CHAR;
426: x_attribute4 := FND_API.G_MISS_CHAR;
427: x_attribute5 := FND_API.G_MISS_CHAR;
428: x_attribute6 := FND_API.G_MISS_CHAR;

Line 425: x_attribute3 := FND_API.G_MISS_CHAR;

421: x_attribute13 := FND_API.G_MISS_CHAR;
422: x_attribute14 := FND_API.G_MISS_CHAR;
423: x_attribute15 := FND_API.G_MISS_CHAR;
424: x_attribute2 := FND_API.G_MISS_CHAR;
425: x_attribute3 := FND_API.G_MISS_CHAR;
426: x_attribute4 := FND_API.G_MISS_CHAR;
427: x_attribute5 := FND_API.G_MISS_CHAR;
428: x_attribute6 := FND_API.G_MISS_CHAR;
429: x_attribute7 := FND_API.G_MISS_CHAR;

Line 426: x_attribute4 := FND_API.G_MISS_CHAR;

422: x_attribute14 := FND_API.G_MISS_CHAR;
423: x_attribute15 := FND_API.G_MISS_CHAR;
424: x_attribute2 := FND_API.G_MISS_CHAR;
425: x_attribute3 := FND_API.G_MISS_CHAR;
426: x_attribute4 := FND_API.G_MISS_CHAR;
427: x_attribute5 := FND_API.G_MISS_CHAR;
428: x_attribute6 := FND_API.G_MISS_CHAR;
429: x_attribute7 := FND_API.G_MISS_CHAR;
430: x_attribute8 := FND_API.G_MISS_CHAR;

Line 427: x_attribute5 := FND_API.G_MISS_CHAR;

423: x_attribute15 := FND_API.G_MISS_CHAR;
424: x_attribute2 := FND_API.G_MISS_CHAR;
425: x_attribute3 := FND_API.G_MISS_CHAR;
426: x_attribute4 := FND_API.G_MISS_CHAR;
427: x_attribute5 := FND_API.G_MISS_CHAR;
428: x_attribute6 := FND_API.G_MISS_CHAR;
429: x_attribute7 := FND_API.G_MISS_CHAR;
430: x_attribute8 := FND_API.G_MISS_CHAR;
431: x_attribute9 := FND_API.G_MISS_CHAR;

Line 428: x_attribute6 := FND_API.G_MISS_CHAR;

424: x_attribute2 := FND_API.G_MISS_CHAR;
425: x_attribute3 := FND_API.G_MISS_CHAR;
426: x_attribute4 := FND_API.G_MISS_CHAR;
427: x_attribute5 := FND_API.G_MISS_CHAR;
428: x_attribute6 := FND_API.G_MISS_CHAR;
429: x_attribute7 := FND_API.G_MISS_CHAR;
430: x_attribute8 := FND_API.G_MISS_CHAR;
431: x_attribute9 := FND_API.G_MISS_CHAR;
432: x_context := FND_API.G_MISS_CHAR;

Line 429: x_attribute7 := FND_API.G_MISS_CHAR;

425: x_attribute3 := FND_API.G_MISS_CHAR;
426: x_attribute4 := FND_API.G_MISS_CHAR;
427: x_attribute5 := FND_API.G_MISS_CHAR;
428: x_attribute6 := FND_API.G_MISS_CHAR;
429: x_attribute7 := FND_API.G_MISS_CHAR;
430: x_attribute8 := FND_API.G_MISS_CHAR;
431: x_attribute9 := FND_API.G_MISS_CHAR;
432: x_context := FND_API.G_MISS_CHAR;
433: x_description := FND_API.G_MISS_CHAR;

Line 430: x_attribute8 := FND_API.G_MISS_CHAR;

426: x_attribute4 := FND_API.G_MISS_CHAR;
427: x_attribute5 := FND_API.G_MISS_CHAR;
428: x_attribute6 := FND_API.G_MISS_CHAR;
429: x_attribute7 := FND_API.G_MISS_CHAR;
430: x_attribute8 := FND_API.G_MISS_CHAR;
431: x_attribute9 := FND_API.G_MISS_CHAR;
432: x_context := FND_API.G_MISS_CHAR;
433: x_description := FND_API.G_MISS_CHAR;
434: x_name := FND_API.G_MISS_CHAR;

Line 431: x_attribute9 := FND_API.G_MISS_CHAR;

427: x_attribute5 := FND_API.G_MISS_CHAR;
428: x_attribute6 := FND_API.G_MISS_CHAR;
429: x_attribute7 := FND_API.G_MISS_CHAR;
430: x_attribute8 := FND_API.G_MISS_CHAR;
431: x_attribute9 := FND_API.G_MISS_CHAR;
432: x_context := FND_API.G_MISS_CHAR;
433: x_description := FND_API.G_MISS_CHAR;
434: x_name := FND_API.G_MISS_CHAR;
435: x_qualifier_rule_id := FND_API.G_MISS_NUM;

Line 432: x_context := FND_API.G_MISS_CHAR;

428: x_attribute6 := FND_API.G_MISS_CHAR;
429: x_attribute7 := FND_API.G_MISS_CHAR;
430: x_attribute8 := FND_API.G_MISS_CHAR;
431: x_attribute9 := FND_API.G_MISS_CHAR;
432: x_context := FND_API.G_MISS_CHAR;
433: x_description := FND_API.G_MISS_CHAR;
434: x_name := FND_API.G_MISS_CHAR;
435: x_qualifier_rule_id := FND_API.G_MISS_NUM;
436: x_qualifier_rule := FND_API.G_MISS_CHAR;

Line 433: x_description := FND_API.G_MISS_CHAR;

429: x_attribute7 := FND_API.G_MISS_CHAR;
430: x_attribute8 := FND_API.G_MISS_CHAR;
431: x_attribute9 := FND_API.G_MISS_CHAR;
432: x_context := FND_API.G_MISS_CHAR;
433: x_description := FND_API.G_MISS_CHAR;
434: x_name := FND_API.G_MISS_CHAR;
435: x_qualifier_rule_id := FND_API.G_MISS_NUM;
436: x_qualifier_rule := FND_API.G_MISS_CHAR;
437:

Line 434: x_name := FND_API.G_MISS_CHAR;

430: x_attribute8 := FND_API.G_MISS_CHAR;
431: x_attribute9 := FND_API.G_MISS_CHAR;
432: x_context := FND_API.G_MISS_CHAR;
433: x_description := FND_API.G_MISS_CHAR;
434: x_name := FND_API.G_MISS_CHAR;
435: x_qualifier_rule_id := FND_API.G_MISS_NUM;
436: x_qualifier_rule := FND_API.G_MISS_CHAR;
437:
438: -- Load display out parameters if any

Line 435: x_qualifier_rule_id := FND_API.G_MISS_NUM;

431: x_attribute9 := FND_API.G_MISS_CHAR;
432: x_context := FND_API.G_MISS_CHAR;
433: x_description := FND_API.G_MISS_CHAR;
434: x_name := FND_API.G_MISS_CHAR;
435: x_qualifier_rule_id := FND_API.G_MISS_NUM;
436: x_qualifier_rule := FND_API.G_MISS_CHAR;
437:
438: -- Load display out parameters if any
439:

Line 436: x_qualifier_rule := FND_API.G_MISS_CHAR;

432: x_context := FND_API.G_MISS_CHAR;
433: x_description := FND_API.G_MISS_CHAR;
434: x_name := FND_API.G_MISS_CHAR;
435: x_qualifier_rule_id := FND_API.G_MISS_NUM;
436: x_qualifier_rule := FND_API.G_MISS_CHAR;
437:
438: -- Load display out parameters if any
439:
440: l_QUALIFIER_RULES_val_rec := QP_Qualifier_Rules_Util.Get_Values

Line 571: x_return_status := FND_API.G_RET_STS_SUCCESS;

567: );
568:
569: -- Set return status.
570:
571: x_return_status := FND_API.G_RET_STS_SUCCESS;
572:
573: -- Get message count and data
574:
575: OE_MSG_PUB.Count_And_Get

Line 584: WHEN FND_API.G_EXC_ERROR THEN

580:
581: oe_debug_pub.add('leaving forms change attributes');
582: EXCEPTION
583:
584: WHEN FND_API.G_EXC_ERROR THEN
585:
586: x_return_status := FND_API.G_RET_STS_ERROR;
587:
588: -- Get message count and data

Line 586: x_return_status := FND_API.G_RET_STS_ERROR;

582: EXCEPTION
583:
584: WHEN FND_API.G_EXC_ERROR THEN
585:
586: x_return_status := FND_API.G_RET_STS_ERROR;
587:
588: -- Get message count and data
589:
590: OE_MSG_PUB.Count_And_Get

Line 595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

591: ( p_count => x_msg_count
592: , p_data => x_msg_data
593: );
594:
595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
596:
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
598:
599: -- Get message count and data

Line 597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

593: );
594:
595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
596:
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
598:
599: -- Get message count and data
600:
601: OE_MSG_PUB.Count_And_Get

Line 608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

604: );
605:
606: WHEN OTHERS THEN
607:
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
609:
610: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
611: THEN
612: OE_MSG_PUB.Add_Exc_Msg

Line 688: IF FND_API.To_Boolean(l_QUALIFIER_RULES_rec.db_flag) THEN

684: );
685:
686: -- Set Operation.
687:
688: IF FND_API.To_Boolean(l_QUALIFIER_RULES_rec.db_flag) THEN
689: l_QUALIFIER_RULES_rec.operation := QP_GLOBALS.G_OPR_UPDATE;
690: ELSE
691: l_QUALIFIER_RULES_rec.operation := QP_GLOBALS.G_OPR_CREATE;
692: END IF;

Line 703: , p_init_msg_list => FND_API.G_TRUE

699:
700:
701: QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
702: ( p_api_version_number => 1.0
703: , p_init_msg_list => FND_API.G_TRUE
704: , x_return_status => l_return_status
705: , x_msg_count => x_msg_count
706: , x_msg_data => x_msg_data
707: , p_control_rec => l_control_rec

Line 714: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

710: , x_QUALIFIER_RULES_rec => l_x_QUALIFIER_RULES_rec
711: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
712: );
713:
714: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
716: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
717: RAISE FND_API.G_EXC_ERROR;
718: END IF;

Line 715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

711: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
712: );
713:
714: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
716: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
717: RAISE FND_API.G_EXC_ERROR;
718: END IF;
719:

Line 716: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

712: );
713:
714: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
716: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
717: RAISE FND_API.G_EXC_ERROR;
718: END IF;
719:
720:

Line 717: RAISE FND_API.G_EXC_ERROR;

713:
714: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
715: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
716: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
717: RAISE FND_API.G_EXC_ERROR;
718: END IF;
719:
720:
721: -- Load OUT parameters.

Line 741: x_return_status := FND_API.G_RET_STS_SUCCESS;

737:
738:
739: -- Set return status.
740:
741: x_return_status := FND_API.G_RET_STS_SUCCESS;
742:
743: -- Get message count and data
744:
745: OE_MSG_PUB.Count_And_Get

Line 755: WHEN FND_API.G_EXC_ERROR THEN

751:
752:
753: EXCEPTION
754:
755: WHEN FND_API.G_EXC_ERROR THEN
756:
757: x_return_status := FND_API.G_RET_STS_ERROR;
758:
759: -- Get message count and data

Line 757: x_return_status := FND_API.G_RET_STS_ERROR;

753: EXCEPTION
754:
755: WHEN FND_API.G_EXC_ERROR THEN
756:
757: x_return_status := FND_API.G_RET_STS_ERROR;
758:
759: -- Get message count and data
760:
761: OE_MSG_PUB.Count_And_Get

Line 766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

762: ( p_count => x_msg_count
763: , p_data => x_msg_data
764: );
765:
766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
767:
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
769:
770: -- Get message count and data

Line 768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

764: );
765:
766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
767:
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
769:
770: -- Get message count and data
771:
772: OE_MSG_PUB.Count_And_Get

Line 779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

775: );
776:
777: WHEN OTHERS THEN
778:
779: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
780:
781: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
782: THEN
783: OE_MSG_PUB.Add_Exc_Msg

Line 846: , p_init_msg_list => FND_API.G_TRUE

842: -- Call QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
843:
844: QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
845: ( p_api_version_number => 1.0
846: , p_init_msg_list => FND_API.G_TRUE
847: , x_return_status => l_return_status
848: , x_msg_count => x_msg_count
849: , x_msg_data => x_msg_data
850: , p_control_rec => l_control_rec

Line 856: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

852: , x_QUALIFIER_RULES_rec => l_x_QUALIFIER_RULES_rec
853: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
854: );
855:
856: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
858: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
859: RAISE FND_API.G_EXC_ERROR;
860: END IF;

Line 857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

853: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
854: );
855:
856: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
858: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
859: RAISE FND_API.G_EXC_ERROR;
860: END IF;
861:

Line 858: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

854: );
855:
856: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
858: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
859: RAISE FND_API.G_EXC_ERROR;
860: END IF;
861:
862:

Line 859: RAISE FND_API.G_EXC_ERROR;

855:
856: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
857: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
858: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
859: RAISE FND_API.G_EXC_ERROR;
860: END IF;
861:
862:
863: -- Clear QUALIFIER_RULES record cache

Line 869: x_return_status := FND_API.G_RET_STS_SUCCESS;

865: Clear_QUALIFIER_RULES;
866:
867: -- Set return status.
868:
869: x_return_status := FND_API.G_RET_STS_SUCCESS;
870:
871: -- Get message count and data
872:
873: OE_MSG_PUB.Count_And_Get

Line 881: WHEN FND_API.G_EXC_ERROR THEN

877:
878:
879: EXCEPTION
880:
881: WHEN FND_API.G_EXC_ERROR THEN
882:
883: x_return_status := FND_API.G_RET_STS_ERROR;
884:
885: -- Get message count and data

Line 883: x_return_status := FND_API.G_RET_STS_ERROR;

879: EXCEPTION
880:
881: WHEN FND_API.G_EXC_ERROR THEN
882:
883: x_return_status := FND_API.G_RET_STS_ERROR;
884:
885: -- Get message count and data
886:
887: OE_MSG_PUB.Count_And_Get

Line 892: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

888: ( p_count => x_msg_count
889: , p_data => x_msg_data
890: );
891:
892: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
893:
894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
895:
896: -- Get message count and data

Line 894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

890: );
891:
892: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
893:
894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
895:
896: -- Get message count and data
897:
898: OE_MSG_PUB.Count_And_Get

Line 905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

901: );
902:
903: WHEN OTHERS THEN
904:
905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
906:
907: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
908: THEN
909: OE_MSG_PUB.Add_Exc_Msg

Line 960: , p_init_msg_list => FND_API.G_TRUE

956: -- Call QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
957:
958: QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
959: ( p_api_version_number => 1.0
960: , p_init_msg_list => FND_API.G_TRUE
961: , x_return_status => l_return_status
962: , x_msg_count => x_msg_count
963: , x_msg_data => x_msg_data
964: , p_control_rec => l_control_rec

Line 969: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

965: , x_QUALIFIER_RULES_rec => l_x_QUALIFIER_RULES_rec
966: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
967: );
968:
969: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
971: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
972: RAISE FND_API.G_EXC_ERROR;
973: END IF;

Line 970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

966: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
967: );
968:
969: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
971: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
972: RAISE FND_API.G_EXC_ERROR;
973: END IF;
974:

Line 971: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

967: );
968:
969: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
971: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
972: RAISE FND_API.G_EXC_ERROR;
973: END IF;
974:
975:

Line 972: RAISE FND_API.G_EXC_ERROR;

968:
969: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
971: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
972: RAISE FND_API.G_EXC_ERROR;
973: END IF;
974:
975:
976: -- Set return status.

Line 978: x_return_status := FND_API.G_RET_STS_SUCCESS;

974:
975:
976: -- Set return status.
977:
978: x_return_status := FND_API.G_RET_STS_SUCCESS;
979:
980: -- Get message count and data
981:
982: OE_MSG_PUB.Count_And_Get

Line 990: WHEN FND_API.G_EXC_ERROR THEN

986:
987:
988: EXCEPTION
989:
990: WHEN FND_API.G_EXC_ERROR THEN
991:
992: x_return_status := FND_API.G_RET_STS_ERROR;
993:
994: -- Get message count and data

Line 992: x_return_status := FND_API.G_RET_STS_ERROR;

988: EXCEPTION
989:
990: WHEN FND_API.G_EXC_ERROR THEN
991:
992: x_return_status := FND_API.G_RET_STS_ERROR;
993:
994: -- Get message count and data
995:
996: OE_MSG_PUB.Count_And_Get

Line 1001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

997: ( p_count => x_msg_count
998: , p_data => x_msg_data
999: );
1000:
1001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1002:
1003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1004:
1005: -- Get message count and data

Line 1003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

999: );
1000:
1001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1002:
1003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1004:
1005: -- Get message count and data
1006:
1007: OE_MSG_PUB.Count_And_Get

Line 1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1010: );
1011:
1012: WHEN OTHERS THEN
1013:
1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1015:
1016: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1017: THEN
1018: OE_MSG_PUB.Add_Exc_Msg

Line 1069: , p_init_msg_list => FND_API.G_TRUE

1065: -- Call QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
1066:
1067: QP_Qualifier_Rules_PVT.Process_QUALIFIER_RULES
1068: ( p_api_version_number => 1.0
1069: , p_init_msg_list => FND_API.G_TRUE
1070: , x_return_status => l_return_status
1071: , x_msg_count => x_msg_count
1072: , x_msg_data => x_msg_data
1073: , p_control_rec => l_control_rec

Line 1078: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1074: , x_QUALIFIER_RULES_rec => l_x_QUALIFIER_RULES_rec
1075: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1076: );
1077:
1078: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1080: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1081: RAISE FND_API.G_EXC_ERROR;
1082: END IF;

Line 1079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1075: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1076: );
1077:
1078: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1080: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1081: RAISE FND_API.G_EXC_ERROR;
1082: END IF;
1083:

Line 1080: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1076: );
1077:
1078: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1080: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1081: RAISE FND_API.G_EXC_ERROR;
1082: END IF;
1083:
1084:

Line 1081: RAISE FND_API.G_EXC_ERROR;

1077:
1078: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1080: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1081: RAISE FND_API.G_EXC_ERROR;
1082: END IF;
1083:
1084:
1085: -- Set return status.

Line 1087: x_return_status := FND_API.G_RET_STS_SUCCESS;

1083:
1084:
1085: -- Set return status.
1086:
1087: x_return_status := FND_API.G_RET_STS_SUCCESS;
1088:
1089: -- Get message count and data
1090:
1091: OE_MSG_PUB.Count_And_Get

Line 1099: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1101: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1110: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1119: );
1120:
1121: WHEN OTHERS THEN
1122:
1123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1124:
1125: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1126: THEN
1127: OE_MSG_PUB.Add_Exc_Msg

Line 1226: , p_init_msg_list => FND_API.G_TRUE

1222: l_QUALIFIER_RULES_rec.operation := QP_GLOBALS.G_OPR_LOCK;
1223:
1224: QP_Qualifier_Rules_PVT.Lock_QUALIFIER_RULES
1225: ( p_api_version_number => 1.0
1226: , p_init_msg_list => FND_API.G_TRUE
1227: , x_return_status => l_return_status
1228: , x_msg_count => x_msg_count
1229: , x_msg_data => x_msg_data
1230: , p_QUALIFIER_RULES_rec => l_QUALIFIER_RULES_rec

Line 1235: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1231: , x_QUALIFIER_RULES_rec => l_x_QUALIFIER_RULES_rec
1232: , x_QUALIFIERS_tbl => l_x_QUALIFIERS_tbl
1233: );
1234:
1235: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1236:
1237: -- Set DB flag and write record to cache.
1238:
1239: l_x_QUALIFIER_RULES_rec.db_flag := FND_API.G_TRUE;

Line 1239: l_x_QUALIFIER_RULES_rec.db_flag := FND_API.G_TRUE;

1235: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1236:
1237: -- Set DB flag and write record to cache.
1238:
1239: l_x_QUALIFIER_RULES_rec.db_flag := FND_API.G_TRUE;
1240:
1241: Write_QUALIFIER_RULES
1242: ( p_QUALIFIER_RULES_rec => l_x_QUALIFIER_RULES_rec
1243: , p_db_record => TRUE

Line 1272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1268: , 'Lock_Row'
1269: );
1270: END IF;
1271:
1272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1273:
1274: -- Get message count and data
1275:
1276: OE_MSG_PUB.Count_And_Get

Line 1326: g_QUALIFIER_RULES_rec.db_flag := FND_API.G_TRUE;

1322: g_QUALIFIER_RULES_rec := QP_Qualifier_Rules_Util.Query_Row
1323: ( p_qualifier_rule_id => p_qualifier_rule_id
1324: );
1325:
1326: g_QUALIFIER_RULES_rec.db_flag := FND_API.G_TRUE;
1327:
1328: -- Load DB record
1329:
1330: g_db_QUALIFIER_RULES_rec := g_QUALIFIER_RULES_rec;

Line 1384: x_return_status := FND_API.G_RET_STS_SUCCESS;

1380: IS
1381: l_return_status Varchar2(30);
1382: BEGIN
1383: OE_MSG_PUB.initialize;
1384: x_return_status := FND_API.G_RET_STS_SUCCESS;
1385: QP_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
1386: p_entity_code => QP_GLOBALS.G_ENTITY_QUALIFIER_RULES
1387: ,p_entity_id => p_qualifier_rule_id
1388: ,x_return_status => l_return_status);

Line 1412: x_return_status := FND_API.G_RET_STS_ERROR;

1408: OE_MSG_PUB.Count_And_Get
1409: ( p_count => x_msg_count
1410: , p_data => x_msg_data
1411: );
1412: x_return_status := FND_API.G_RET_STS_ERROR;
1413:
1414: END Clear_Record;
1415:
1416: