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

Line 35: l_PTE_rec.return_status := FND_API.G_RET_STS_SUCCESS;

31: );
32:
33: -- Set record return status.
34:
35: l_PTE_rec.return_status := FND_API.G_RET_STS_SUCCESS;
36:
37: -- Prepare record.
38:
39: IF l_PTE_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

Line 41: l_PTE_rec.db_flag := FND_API.G_FALSE;

37: -- Prepare record.
38:
39: IF l_PTE_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
40:
41: l_PTE_rec.db_flag := FND_API.G_FALSE;
42:
43: -- Set missing old record elements to NULL.
44:
45: l_old_PTE_rec :=

Line 52: l_PTE_rec.db_flag := FND_API.G_TRUE;

48: ELSIF l_PTE_rec.operation = QP_GLOBALS.G_OPR_UPDATE
49: OR l_PTE_rec.operation = QP_GLOBALS.G_OPR_DELETE
50: THEN
51:
52: l_PTE_rec.db_flag := FND_API.G_TRUE;
53:
54: -- Query Old if missing
55:
56: IF l_old_PTE_rec.lookup_code = FND_API.G_MISS_CHAR

Line 56: IF l_old_PTE_rec.lookup_code = FND_API.G_MISS_CHAR

52: l_PTE_rec.db_flag := FND_API.G_TRUE;
53:
54: -- Query Old if missing
55:
56: IF l_old_PTE_rec.lookup_code = FND_API.G_MISS_CHAR
57: THEN
58:
59: l_old_PTE_rec := QP_Pte_Util.Query_Row
60: ( p_lookup_code => l_PTE_rec.lookup_code

Line 87: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

83: IF l_control_rec.default_attributes
84: OR l_control_rec.change_attributes
85: THEN
86:
87: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
88:
89: QP_Validate_Pte.Attributes
90: ( x_return_status => l_return_status
91: , p_PTE_rec => l_PTE_rec

Line 95: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

91: , p_PTE_rec => l_PTE_rec
92: , p_old_PTE_rec => l_old_PTE_rec
93: );
94:
95: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
97: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
98: RAISE FND_API.G_EXC_ERROR;
99: END IF;

Line 96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

92: , p_old_PTE_rec => l_old_PTE_rec
93: );
94:
95: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
97: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
98: RAISE FND_API.G_EXC_ERROR;
99: END IF;
100:

Line 97: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

93: );
94:
95: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
97: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
98: RAISE FND_API.G_EXC_ERROR;
99: END IF;
100:
101: END IF;

Line 98: RAISE FND_API.G_EXC_ERROR;

94:
95: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
97: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
98: RAISE FND_API.G_EXC_ERROR;
99: END IF;
100:
101: END IF;
102:

Line 165: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

161: );
162:
163: END IF;
164:
165: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
168: RAISE FND_API.G_EXC_ERROR;
169: END IF;

Line 166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

162:
163: END IF;
164:
165: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
168: RAISE FND_API.G_EXC_ERROR;
169: END IF;
170:

Line 167: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

163: END IF;
164:
165: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
168: RAISE FND_API.G_EXC_ERROR;
169: END IF;
170:
171: END IF;

Line 168: RAISE FND_API.G_EXC_ERROR;

164:
165: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
166: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
167: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
168: RAISE FND_API.G_EXC_ERROR;
169: END IF;
170:
171: END IF;
172:

Line 215: WHEN FND_API.G_EXC_ERROR THEN

211: x_old_PTE_rec := l_old_PTE_rec;
212:
213: EXCEPTION
214:
215: WHEN FND_API.G_EXC_ERROR THEN
216:
217: l_PTE_rec.return_status := FND_API.G_RET_STS_ERROR;
218: x_PTE_rec := l_PTE_rec;
219: x_old_PTE_rec := l_old_PTE_rec;

Line 217: l_PTE_rec.return_status := FND_API.G_RET_STS_ERROR;

213: EXCEPTION
214:
215: WHEN FND_API.G_EXC_ERROR THEN
216:
217: l_PTE_rec.return_status := FND_API.G_RET_STS_ERROR;
218: x_PTE_rec := l_PTE_rec;
219: x_old_PTE_rec := l_old_PTE_rec;
220: RAISE;
221:

Line 222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

218: x_PTE_rec := l_PTE_rec;
219: x_old_PTE_rec := l_old_PTE_rec;
220: RAISE;
221:
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223:
224: l_PTE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
225: x_PTE_rec := l_PTE_rec;
226: x_old_PTE_rec := l_old_PTE_rec;

Line 224: l_PTE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

220: RAISE;
221:
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223:
224: l_PTE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
225: x_PTE_rec := l_PTE_rec;
226: x_old_PTE_rec := l_old_PTE_rec;
227:
228: RAISE;

Line 240: l_PTE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

236: , 'Pte'
237: );
238: END IF;
239:
240: l_PTE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
241: x_PTE_rec := l_PTE_rec;
242: x_old_PTE_rec := l_old_PTE_rec;
243:
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

240: l_PTE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
241: x_PTE_rec := l_PTE_rec;
242: x_old_PTE_rec := l_old_PTE_rec;
243:
244: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
245:
246: END Pte;
247:
248: -- Rqts

Line 295: l_RQT_rec.return_status := FND_API.G_RET_STS_SUCCESS;

291: );
292:
293: -- Set record return status.
294:
295: l_RQT_rec.return_status := FND_API.G_RET_STS_SUCCESS;
296:
297: -- Prepare record.
298:
299: IF l_RQT_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

Line 301: l_RQT_rec.db_flag := FND_API.G_FALSE;

297: -- Prepare record.
298:
299: IF l_RQT_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
300:
301: l_RQT_rec.db_flag := FND_API.G_FALSE;
302:
303: -- Set missing old record elements to NULL.
304:
305: l_old_RQT_rec :=

Line 312: l_RQT_rec.db_flag := FND_API.G_TRUE;

308: ELSIF l_RQT_rec.operation = QP_GLOBALS.G_OPR_UPDATE
309: OR l_RQT_rec.operation = QP_GLOBALS.G_OPR_DELETE
310: THEN
311:
312: l_RQT_rec.db_flag := FND_API.G_TRUE;
313:
314: -- Query Old if missing
315:
316: IF l_old_RQT_rec.request_type_code = FND_API.G_MISS_CHAR

Line 316: IF l_old_RQT_rec.request_type_code = FND_API.G_MISS_CHAR

312: l_RQT_rec.db_flag := FND_API.G_TRUE;
313:
314: -- Query Old if missing
315:
316: IF l_old_RQT_rec.request_type_code = FND_API.G_MISS_CHAR
317: THEN
318:
319: l_old_RQT_rec := QP_Rqt_Util.Query_Row
320: ( p_request_type_code => l_RQT_rec.request_type_code

Line 347: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

343: IF l_control_rec.default_attributes
344: OR l_control_rec.change_attributes
345: THEN
346:
347: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
348:
349: QP_Validate_Rqt.Attributes
350: ( x_return_status => l_return_status
351: , p_RQT_rec => l_RQT_rec

Line 355: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

351: , p_RQT_rec => l_RQT_rec
352: , p_old_RQT_rec => l_old_RQT_rec
353: );
354:
355: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
357: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
358: RAISE FND_API.G_EXC_ERROR;
359: END IF;

Line 356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

352: , p_old_RQT_rec => l_old_RQT_rec
353: );
354:
355: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
357: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
358: RAISE FND_API.G_EXC_ERROR;
359: END IF;
360:

Line 357: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

353: );
354:
355: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
357: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
358: RAISE FND_API.G_EXC_ERROR;
359: END IF;
360:
361: END IF;

Line 358: RAISE FND_API.G_EXC_ERROR;

354:
355: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
357: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
358: RAISE FND_API.G_EXC_ERROR;
359: END IF;
360:
361: END IF;
362:

Line 426: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

422: );
423:
424: END IF;
425:
426: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
429: RAISE FND_API.G_EXC_ERROR;
430: END IF;

Line 427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

423:
424: END IF;
425:
426: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
429: RAISE FND_API.G_EXC_ERROR;
430: END IF;
431:

Line 428: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

424: END IF;
425:
426: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
429: RAISE FND_API.G_EXC_ERROR;
430: END IF;
431:
432: END IF;

Line 429: RAISE FND_API.G_EXC_ERROR;

425:
426: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
429: RAISE FND_API.G_EXC_ERROR;
430: END IF;
431:
432: END IF;
433:

Line 479: WHEN FND_API.G_EXC_ERROR THEN

475:
476:
477: EXCEPTION
478:
479: WHEN FND_API.G_EXC_ERROR THEN
480:
481: l_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;
482: l_RQT_tbl(I) := l_RQT_rec;
483: l_old_RQT_tbl(I) := l_old_RQT_rec;

Line 481: l_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;

477: EXCEPTION
478:
479: WHEN FND_API.G_EXC_ERROR THEN
480:
481: l_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;
482: l_RQT_tbl(I) := l_RQT_rec;
483: l_old_RQT_tbl(I) := l_old_RQT_rec;
484:
485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

481: l_RQT_rec.return_status := FND_API.G_RET_STS_ERROR;
482: l_RQT_tbl(I) := l_RQT_rec;
483: l_old_RQT_tbl(I) := l_old_RQT_rec;
484:
485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
486:
487: l_RQT_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
488: l_RQT_tbl(I) := l_RQT_rec;
489: l_old_RQT_tbl(I) := l_old_RQT_rec;

Line 487: l_RQT_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

483: l_old_RQT_tbl(I) := l_old_RQT_rec;
484:
485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
486:
487: l_RQT_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
488: l_RQT_tbl(I) := l_RQT_rec;
489: l_old_RQT_tbl(I) := l_old_RQT_rec;
490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
491:

Line 490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

486:
487: l_RQT_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
488: l_RQT_tbl(I) := l_RQT_rec;
489: l_old_RQT_tbl(I) := l_old_RQT_rec;
490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
491:
492: WHEN OTHERS THEN
493:
494: l_RQT_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 494: l_RQT_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

490: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
491:
492: WHEN OTHERS THEN
493:
494: l_RQT_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
495: l_RQT_tbl(I) := l_RQT_rec;
496: l_old_RQT_tbl(I) := l_old_RQT_rec;
497:
498: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

502: , 'Rqts'
503: );
504: END IF;
505:
506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
507:
508: END;
509: END LOOP;
510:

Line 518: WHEN FND_API.G_EXC_ERROR THEN

514: x_old_RQT_tbl := l_old_RQT_tbl;
515:
516: EXCEPTION
517:
518: WHEN FND_API.G_EXC_ERROR THEN
519:
520: RAISE;
521:
522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

518: WHEN FND_API.G_EXC_ERROR THEN
519:
520: RAISE;
521:
522: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
523:
524:
525: RAISE;
526:

Line 538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

534: );
535: END IF;
536:
537:
538: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
539:
540: END Rqts;
541:
542: -- Sscs

Line 589: l_SSC_rec.return_status := FND_API.G_RET_STS_SUCCESS;

585: );
586:
587: -- Set record return status.
588:
589: l_SSC_rec.return_status := FND_API.G_RET_STS_SUCCESS;
590:
591: -- Prepare record.
592:
593: IF l_SSC_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

Line 595: l_SSC_rec.db_flag := FND_API.G_FALSE;

591: -- Prepare record.
592:
593: IF l_SSC_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
594:
595: l_SSC_rec.db_flag := FND_API.G_FALSE;
596:
597: -- Set missing old record elements to NULL.
598:
599: l_old_SSC_rec :=

Line 606: l_SSC_rec.db_flag := FND_API.G_TRUE;

602: ELSIF l_SSC_rec.operation = QP_GLOBALS.G_OPR_UPDATE
603: OR l_SSC_rec.operation = QP_GLOBALS.G_OPR_DELETE
604: THEN
605:
606: l_SSC_rec.db_flag := FND_API.G_TRUE;
607:
608: -- Query Old if missing
609:
610: IF l_old_SSC_rec.pte_source_system_id = FND_API.G_MISS_NUM

Line 610: IF l_old_SSC_rec.pte_source_system_id = FND_API.G_MISS_NUM

606: l_SSC_rec.db_flag := FND_API.G_TRUE;
607:
608: -- Query Old if missing
609:
610: IF l_old_SSC_rec.pte_source_system_id = FND_API.G_MISS_NUM
611: THEN
612:
613: l_old_SSC_rec := QP_Ssc_Util.Query_Row
614: ( p_pte_source_system_id => l_SSC_rec.pte_source_system_id

Line 641: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

637: IF l_control_rec.default_attributes
638: OR l_control_rec.change_attributes
639: THEN
640:
641: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
642:
643: QP_Validate_Ssc.Attributes
644: ( x_return_status => l_return_status
645: , p_SSC_rec => l_SSC_rec

Line 649: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

645: , p_SSC_rec => l_SSC_rec
646: , p_old_SSC_rec => l_old_SSC_rec
647: );
648:
649: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
651: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
652: RAISE FND_API.G_EXC_ERROR;
653: END IF;

Line 650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

646: , p_old_SSC_rec => l_old_SSC_rec
647: );
648:
649: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
651: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
652: RAISE FND_API.G_EXC_ERROR;
653: END IF;
654:

Line 651: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

647: );
648:
649: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
651: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
652: RAISE FND_API.G_EXC_ERROR;
653: END IF;
654:
655: END IF;

Line 652: RAISE FND_API.G_EXC_ERROR;

648:
649: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
651: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
652: RAISE FND_API.G_EXC_ERROR;
653: END IF;
654:
655: END IF;
656:

Line 719: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

715: );
716:
717: END IF;
718:
719: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
721: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
722: RAISE FND_API.G_EXC_ERROR;
723: END IF;

Line 720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

716:
717: END IF;
718:
719: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
721: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
722: RAISE FND_API.G_EXC_ERROR;
723: END IF;
724:

Line 721: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

717: END IF;
718:
719: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
721: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
722: RAISE FND_API.G_EXC_ERROR;
723: END IF;
724:
725: END IF;

Line 722: RAISE FND_API.G_EXC_ERROR;

718:
719: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
721: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
722: RAISE FND_API.G_EXC_ERROR;
723: END IF;
724:
725: END IF;
726:

Line 772: WHEN FND_API.G_EXC_ERROR THEN

768:
769:
770: EXCEPTION
771:
772: WHEN FND_API.G_EXC_ERROR THEN
773:
774: l_SSC_rec.return_status := FND_API.G_RET_STS_ERROR;
775: l_SSC_tbl(I) := l_SSC_rec;
776: l_old_SSC_tbl(I) := l_old_SSC_rec;

Line 774: l_SSC_rec.return_status := FND_API.G_RET_STS_ERROR;

770: EXCEPTION
771:
772: WHEN FND_API.G_EXC_ERROR THEN
773:
774: l_SSC_rec.return_status := FND_API.G_RET_STS_ERROR;
775: l_SSC_tbl(I) := l_SSC_rec;
776: l_old_SSC_tbl(I) := l_old_SSC_rec;
777:
778: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 778: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

774: l_SSC_rec.return_status := FND_API.G_RET_STS_ERROR;
775: l_SSC_tbl(I) := l_SSC_rec;
776: l_old_SSC_tbl(I) := l_old_SSC_rec;
777:
778: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
779:
780: l_SSC_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
781: l_SSC_tbl(I) := l_SSC_rec;
782: l_old_SSC_tbl(I) := l_old_SSC_rec;

Line 780: l_SSC_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

776: l_old_SSC_tbl(I) := l_old_SSC_rec;
777:
778: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
779:
780: l_SSC_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
781: l_SSC_tbl(I) := l_SSC_rec;
782: l_old_SSC_tbl(I) := l_old_SSC_rec;
783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
784:

Line 783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

779:
780: l_SSC_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
781: l_SSC_tbl(I) := l_SSC_rec;
782: l_old_SSC_tbl(I) := l_old_SSC_rec;
783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
784:
785: WHEN OTHERS THEN
786:
787: l_SSC_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 787: l_SSC_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

783: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
784:
785: WHEN OTHERS THEN
786:
787: l_SSC_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
788: l_SSC_tbl(I) := l_SSC_rec;
789: l_old_SSC_tbl(I) := l_old_SSC_rec;
790:
791: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

795: , 'Sscs'
796: );
797: END IF;
798:
799: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
800:
801: END;
802: END LOOP;
803:

Line 811: WHEN FND_API.G_EXC_ERROR THEN

807: x_old_SSC_tbl := l_old_SSC_tbl;
808:
809: EXCEPTION
810:
811: WHEN FND_API.G_EXC_ERROR THEN
812:
813: RAISE;
814:
815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

811: WHEN FND_API.G_EXC_ERROR THEN
812:
813: RAISE;
814:
815: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
816:
817:
818: RAISE;
819:

Line 831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

827: );
828: END IF;
829:
830:
831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
832:
833: END Sscs;
834:
835: -- Psgs

Line 882: l_PSG_rec.return_status := FND_API.G_RET_STS_SUCCESS;

878: );
879:
880: -- Set record return status.
881:
882: l_PSG_rec.return_status := FND_API.G_RET_STS_SUCCESS;
883:
884: -- Prepare record.
885:
886: IF l_PSG_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

Line 888: l_PSG_rec.db_flag := FND_API.G_FALSE;

884: -- Prepare record.
885:
886: IF l_PSG_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
887:
888: l_PSG_rec.db_flag := FND_API.G_FALSE;
889:
890: -- Set missing old record elements to NULL.
891:
892: l_old_PSG_rec :=

Line 899: l_PSG_rec.db_flag := FND_API.G_TRUE;

895: ELSIF l_PSG_rec.operation = QP_GLOBALS.G_OPR_UPDATE
896: OR l_PSG_rec.operation = QP_GLOBALS.G_OPR_DELETE
897: THEN
898:
899: l_PSG_rec.db_flag := FND_API.G_TRUE;
900:
901: -- Query Old if missing
902:
903: IF l_old_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM

Line 903: IF l_old_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM

899: l_PSG_rec.db_flag := FND_API.G_TRUE;
900:
901: -- Query Old if missing
902:
903: IF l_old_PSG_rec.segment_pte_id = FND_API.G_MISS_NUM
904: THEN
905:
906: l_old_PSG_rec := QP_Psg_Util.Query_Row
907: ( p_segment_pte_id => l_PSG_rec.segment_pte_id

Line 934: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

930: IF l_control_rec.default_attributes
931: OR l_control_rec.change_attributes
932: THEN
933:
934: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
935:
936: QP_Validate_Psg.Attributes
937: ( x_return_status => l_return_status
938: , p_PSG_rec => l_PSG_rec

Line 942: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

938: , p_PSG_rec => l_PSG_rec
939: , p_old_PSG_rec => l_old_PSG_rec
940: );
941:
942: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
944: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
945: RAISE FND_API.G_EXC_ERROR;
946: END IF;

Line 943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

939: , p_old_PSG_rec => l_old_PSG_rec
940: );
941:
942: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
943: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
944: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
945: RAISE FND_API.G_EXC_ERROR;
946: END IF;
947:

Line 944: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 945: RAISE FND_API.G_EXC_ERROR;

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

Line 1012: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1008: );
1009:
1010: END IF;
1011:
1012: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1014: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1015: RAISE FND_API.G_EXC_ERROR;
1016: END IF;

Line 1013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1009:
1010: END IF;
1011:
1012: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1014: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1015: RAISE FND_API.G_EXC_ERROR;
1016: END IF;
1017:

Line 1014: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1010: END IF;
1011:
1012: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1014: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1015: RAISE FND_API.G_EXC_ERROR;
1016: END IF;
1017:
1018: END IF;

Line 1015: RAISE FND_API.G_EXC_ERROR;

1011:
1012: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1014: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1015: RAISE FND_API.G_EXC_ERROR;
1016: END IF;
1017:
1018: END IF;
1019:

Line 1065: WHEN FND_API.G_EXC_ERROR THEN

1061:
1062:
1063: EXCEPTION
1064:
1065: WHEN FND_API.G_EXC_ERROR THEN
1066:
1067: l_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;
1068: l_PSG_tbl(I) := l_PSG_rec;
1069: l_old_PSG_tbl(I) := l_old_PSG_rec;

Line 1067: l_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;

1063: EXCEPTION
1064:
1065: WHEN FND_API.G_EXC_ERROR THEN
1066:
1067: l_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;
1068: l_PSG_tbl(I) := l_PSG_rec;
1069: l_old_PSG_tbl(I) := l_old_PSG_rec;
1070:
1071: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1071: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1067: l_PSG_rec.return_status := FND_API.G_RET_STS_ERROR;
1068: l_PSG_tbl(I) := l_PSG_rec;
1069: l_old_PSG_tbl(I) := l_old_PSG_rec;
1070:
1071: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1072:
1073: l_PSG_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1074: l_PSG_tbl(I) := l_PSG_rec;
1075: l_old_PSG_tbl(I) := l_old_PSG_rec;

Line 1073: l_PSG_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1069: l_old_PSG_tbl(I) := l_old_PSG_rec;
1070:
1071: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1072:
1073: l_PSG_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1074: l_PSG_tbl(I) := l_PSG_rec;
1075: l_old_PSG_tbl(I) := l_old_PSG_rec;
1076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1077:

Line 1076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1072:
1073: l_PSG_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1074: l_PSG_tbl(I) := l_PSG_rec;
1075: l_old_PSG_tbl(I) := l_old_PSG_rec;
1076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1077:
1078: WHEN OTHERS THEN
1079:
1080: l_PSG_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1080: l_PSG_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1077:
1078: WHEN OTHERS THEN
1079:
1080: l_PSG_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1081: l_PSG_tbl(I) := l_PSG_rec;
1082: l_old_PSG_tbl(I) := l_old_PSG_rec;
1083:
1084: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1088: , 'Psgs'
1089: );
1090: END IF;
1091:
1092: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1093:
1094: END;
1095: END LOOP;
1096:

Line 1104: WHEN FND_API.G_EXC_ERROR THEN

1100: x_old_PSG_tbl := l_old_PSG_tbl;
1101:
1102: EXCEPTION
1103:
1104: WHEN FND_API.G_EXC_ERROR THEN
1105:
1106: RAISE;
1107:
1108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1104: WHEN FND_API.G_EXC_ERROR THEN
1105:
1106: RAISE;
1107:
1108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1109:
1110:
1111: RAISE;
1112:

Line 1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1120: );
1121: END IF;
1122:
1123:
1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1125:
1126: END Psgs;
1127:
1128: -- Sous

Line 1175: l_SOU_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1171: );
1172:
1173: -- Set record return status.
1174:
1175: l_SOU_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1176:
1177: -- Prepare record.
1178:
1179: IF l_SOU_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

Line 1181: l_SOU_rec.db_flag := FND_API.G_FALSE;

1177: -- Prepare record.
1178:
1179: IF l_SOU_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1180:
1181: l_SOU_rec.db_flag := FND_API.G_FALSE;
1182:
1183: -- Set missing old record elements to NULL.
1184:
1185: l_old_SOU_rec :=

Line 1192: l_SOU_rec.db_flag := FND_API.G_TRUE;

1188: ELSIF l_SOU_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1189: OR l_SOU_rec.operation = QP_GLOBALS.G_OPR_DELETE
1190: THEN
1191:
1192: l_SOU_rec.db_flag := FND_API.G_TRUE;
1193:
1194: -- Query Old if missing
1195:
1196: IF l_old_SOU_rec.attribute_sourcing_id = FND_API.G_MISS_NUM

Line 1196: IF l_old_SOU_rec.attribute_sourcing_id = FND_API.G_MISS_NUM

1192: l_SOU_rec.db_flag := FND_API.G_TRUE;
1193:
1194: -- Query Old if missing
1195:
1196: IF l_old_SOU_rec.attribute_sourcing_id = FND_API.G_MISS_NUM
1197: THEN
1198:
1199: oe_debug_pub.add('attribute_sou is missing');
1200: l_old_SOU_rec := QP_Sou_Util.Query_Row

Line 1228: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

1224: IF l_control_rec.default_attributes
1225: OR l_control_rec.change_attributes
1226: THEN
1227:
1228: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
1229:
1230: QP_Validate_Sou.Attributes
1231: ( x_return_status => l_return_status
1232: , p_SOU_rec => l_SOU_rec

Line 1236: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1232: , p_SOU_rec => l_SOU_rec
1233: , p_old_SOU_rec => l_old_SOU_rec
1234: );
1235:
1236: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1238: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1239: RAISE FND_API.G_EXC_ERROR;
1240: END IF;

Line 1237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1233: , p_old_SOU_rec => l_old_SOU_rec
1234: );
1235:
1236: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1238: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1239: RAISE FND_API.G_EXC_ERROR;
1240: END IF;
1241:

Line 1238: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1234: );
1235:
1236: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1238: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1239: RAISE FND_API.G_EXC_ERROR;
1240: END IF;
1241:
1242: END IF;

Line 1239: RAISE FND_API.G_EXC_ERROR;

1235:
1236: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1238: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1239: RAISE FND_API.G_EXC_ERROR;
1240: END IF;
1241:
1242: END IF;
1243:

Line 1306: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1302: );
1303:
1304: END IF;
1305:
1306: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1308: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1309: RAISE FND_API.G_EXC_ERROR;
1310: END IF;

Line 1307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1303:
1304: END IF;
1305:
1306: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1308: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1309: RAISE FND_API.G_EXC_ERROR;
1310: END IF;
1311:

Line 1308: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1304: END IF;
1305:
1306: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1308: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1309: RAISE FND_API.G_EXC_ERROR;
1310: END IF;
1311:
1312: END IF;

Line 1309: RAISE FND_API.G_EXC_ERROR;

1305:
1306: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1307: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1308: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1309: RAISE FND_API.G_EXC_ERROR;
1310: END IF;
1311:
1312: END IF;
1313:

Line 1359: WHEN FND_API.G_EXC_ERROR THEN

1355:
1356:
1357: EXCEPTION
1358:
1359: WHEN FND_API.G_EXC_ERROR THEN
1360:
1361: l_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;
1362: l_SOU_tbl(I) := l_SOU_rec;
1363: l_old_SOU_tbl(I) := l_old_SOU_rec;

Line 1361: l_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;

1357: EXCEPTION
1358:
1359: WHEN FND_API.G_EXC_ERROR THEN
1360:
1361: l_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;
1362: l_SOU_tbl(I) := l_SOU_rec;
1363: l_old_SOU_tbl(I) := l_old_SOU_rec;
1364:
1365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1361: l_SOU_rec.return_status := FND_API.G_RET_STS_ERROR;
1362: l_SOU_tbl(I) := l_SOU_rec;
1363: l_old_SOU_tbl(I) := l_old_SOU_rec;
1364:
1365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1366:
1367: l_SOU_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1368: l_SOU_tbl(I) := l_SOU_rec;
1369: l_old_SOU_tbl(I) := l_old_SOU_rec;

Line 1367: l_SOU_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1363: l_old_SOU_tbl(I) := l_old_SOU_rec;
1364:
1365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1366:
1367: l_SOU_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1368: l_SOU_tbl(I) := l_SOU_rec;
1369: l_old_SOU_tbl(I) := l_old_SOU_rec;
1370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1371:

Line 1370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1366:
1367: l_SOU_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1368: l_SOU_tbl(I) := l_SOU_rec;
1369: l_old_SOU_tbl(I) := l_old_SOU_rec;
1370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1371:
1372: WHEN OTHERS THEN
1373:
1374: l_SOU_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1374: l_SOU_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1370: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1371:
1372: WHEN OTHERS THEN
1373:
1374: l_SOU_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1375: l_SOU_tbl(I) := l_SOU_rec;
1376: l_old_SOU_tbl(I) := l_old_SOU_rec;
1377:
1378: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1382: , 'Sous'
1383: );
1384: END IF;
1385:
1386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1387:
1388: END;
1389: END LOOP;
1390:

Line 1398: WHEN FND_API.G_EXC_ERROR THEN

1394: x_old_SOU_tbl := l_old_SOU_tbl;
1395:
1396: EXCEPTION
1397:
1398: WHEN FND_API.G_EXC_ERROR THEN
1399:
1400: RAISE;
1401:
1402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1398: WHEN FND_API.G_EXC_ERROR THEN
1399:
1400: RAISE;
1401:
1402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1403:
1404:
1405: RAISE;
1406:

Line 1418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1414: );
1415: END IF;
1416:
1417:
1418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1419:
1420: END Sous;
1421:
1422: -- Fnas

Line 1469: l_FNA_rec.return_status := FND_API.G_RET_STS_SUCCESS;

1465: );
1466:
1467: -- Set record return status.
1468:
1469: l_FNA_rec.return_status := FND_API.G_RET_STS_SUCCESS;
1470:
1471: -- Prepare record.
1472:
1473: IF l_FNA_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN

Line 1475: l_FNA_rec.db_flag := FND_API.G_FALSE;

1471: -- Prepare record.
1472:
1473: IF l_FNA_rec.operation = QP_GLOBALS.G_OPR_CREATE THEN
1474:
1475: l_FNA_rec.db_flag := FND_API.G_FALSE;
1476:
1477: -- Set missing old record elements to NULL.
1478:
1479: l_old_FNA_rec :=

Line 1486: l_FNA_rec.db_flag := FND_API.G_TRUE;

1482: ELSIF l_FNA_rec.operation = QP_GLOBALS.G_OPR_UPDATE
1483: OR l_FNA_rec.operation = QP_GLOBALS.G_OPR_DELETE
1484: THEN
1485:
1486: l_FNA_rec.db_flag := FND_API.G_TRUE;
1487:
1488: -- Query Old if missing
1489:
1490: IF l_old_FNA_rec.pte_sourcesystem_fnarea_id = FND_API.G_MISS_NUM

Line 1490: IF l_old_FNA_rec.pte_sourcesystem_fnarea_id = FND_API.G_MISS_NUM

1486: l_FNA_rec.db_flag := FND_API.G_TRUE;
1487:
1488: -- Query Old if missing
1489:
1490: IF l_old_FNA_rec.pte_sourcesystem_fnarea_id = FND_API.G_MISS_NUM
1491: THEN
1492:
1493: l_old_FNA_rec := QP_Fna_Util.Query_Row
1494: ( p_pte_sourcesystem_fnarea_id => l_FNA_rec.pte_sourcesystem_fnarea_id

Line 1520: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN

1516: IF l_control_rec.default_attributes
1517: OR l_control_rec.change_attributes
1518: THEN
1519:
1520: IF p_validation_level > FND_API.G_VALID_LEVEL_NONE THEN
1521:
1522: QP_Validate_Fna.Attributes
1523: ( x_return_status => l_return_status
1524: , p_FNA_rec => l_FNA_rec

Line 1528: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1524: , p_FNA_rec => l_FNA_rec
1525: , p_old_FNA_rec => l_old_FNA_rec
1526: );
1527:
1528: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1530: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1531: RAISE FND_API.G_EXC_ERROR;
1532: END IF;

Line 1529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1525: , p_old_FNA_rec => l_old_FNA_rec
1526: );
1527:
1528: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1530: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1531: RAISE FND_API.G_EXC_ERROR;
1532: END IF;
1533:

Line 1530: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1526: );
1527:
1528: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1530: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1531: RAISE FND_API.G_EXC_ERROR;
1532: END IF;
1533:
1534: END IF;

Line 1531: RAISE FND_API.G_EXC_ERROR;

1527:
1528: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1529: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1530: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1531: RAISE FND_API.G_EXC_ERROR;
1532: END IF;
1533:
1534: END IF;
1535:

Line 1598: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1594: );
1595:
1596: END IF;
1597:
1598: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1600: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1601: RAISE FND_API.G_EXC_ERROR;
1602: END IF;

Line 1599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1595:
1596: END IF;
1597:
1598: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1600: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1601: RAISE FND_API.G_EXC_ERROR;
1602: END IF;
1603:

Line 1600: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1596: END IF;
1597:
1598: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1600: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1601: RAISE FND_API.G_EXC_ERROR;
1602: END IF;
1603:
1604: END IF;

Line 1601: RAISE FND_API.G_EXC_ERROR;

1597:
1598: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1600: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1601: RAISE FND_API.G_EXC_ERROR;
1602: END IF;
1603:
1604: END IF;
1605:

Line 1667: WHEN FND_API.G_EXC_ERROR THEN

1663: -- For loop exception handler.
1664:
1665: EXCEPTION
1666:
1667: WHEN FND_API.G_EXC_ERROR THEN
1668:
1669: l_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;
1670: l_FNA_tbl(I) := l_FNA_rec;
1671: l_old_FNA_tbl(I) := l_old_FNA_rec;

Line 1669: l_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;

1665: EXCEPTION
1666:
1667: WHEN FND_API.G_EXC_ERROR THEN
1668:
1669: l_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;
1670: l_FNA_tbl(I) := l_FNA_rec;
1671: l_old_FNA_tbl(I) := l_old_FNA_rec;
1672:
1673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1669: l_FNA_rec.return_status := FND_API.G_RET_STS_ERROR;
1670: l_FNA_tbl(I) := l_FNA_rec;
1671: l_old_FNA_tbl(I) := l_old_FNA_rec;
1672:
1673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1674:
1675: l_FNA_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1676: l_FNA_tbl(I) := l_FNA_rec;
1677: l_old_FNA_tbl(I) := l_old_FNA_rec;

Line 1675: l_FNA_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1671: l_old_FNA_tbl(I) := l_old_FNA_rec;
1672:
1673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1674:
1675: l_FNA_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1676: l_FNA_tbl(I) := l_FNA_rec;
1677: l_old_FNA_tbl(I) := l_old_FNA_rec;
1678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1679:

Line 1678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1674:
1675: l_FNA_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1676: l_FNA_tbl(I) := l_FNA_rec;
1677: l_old_FNA_tbl(I) := l_old_FNA_rec;
1678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1679:
1680: WHEN OTHERS THEN
1681:
1682: l_FNA_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1682: l_FNA_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1678: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1679:
1680: WHEN OTHERS THEN
1681:
1682: l_FNA_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1683: l_FNA_tbl(I) := l_FNA_rec;
1684: l_old_FNA_tbl(I) := l_old_FNA_rec;
1685:
1686: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1690: , 'Fnas'
1691: );
1692: END IF;
1693:
1694: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1695:
1696: END;
1697: END LOOP;
1698:

Line 1706: WHEN FND_API.G_EXC_ERROR THEN

1702: x_old_FNA_tbl := l_old_FNA_tbl;
1703:
1704: EXCEPTION
1705:
1706: WHEN FND_API.G_EXC_ERROR THEN
1707:
1708: if l_control_rec.called_from_ui = 'N' then
1709: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity
1710: (p_entity_code => QP_GLOBALS.G_ENTITY_FNA,

Line 1717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1713: end if;
1714:
1715: RAISE;
1716:
1717: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1718:
1719:
1720: if l_control_rec.called_from_ui = 'N' then
1721: qp_delayed_requests_pvt.delete_reqs_for_deleted_entity

Line 1747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1743: p_entity_id => l_FNA_rec.pte_source_system_id,
1744: x_return_status => l_return_status );
1745: end if;
1746:
1747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1748:
1749: END Fnas;
1750:
1751: -- Start of Comments

Line 1769: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

1765: -- End of Comments
1766:
1767: PROCEDURE Process_Attr_Mapping
1768: ( p_api_version_number IN NUMBER
1769: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1770: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1771: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1772: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
1773: QP_GLOBALS.G_MISS_CONTROL_REC

Line 1770: , p_commit IN VARCHAR2 := FND_API.G_FALSE

1766:
1767: PROCEDURE Process_Attr_Mapping
1768: ( p_api_version_number IN NUMBER
1769: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1770: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1771: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1772: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
1773: QP_GLOBALS.G_MISS_CONTROL_REC
1774: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1771: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

1767: PROCEDURE Process_Attr_Mapping
1768: ( p_api_version_number IN NUMBER
1769: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
1770: , p_commit IN VARCHAR2 := FND_API.G_FALSE
1771: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
1772: , p_control_rec IN QP_GLOBALS.Control_Rec_Type :=
1773: QP_GLOBALS.G_MISS_CONTROL_REC
1774: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1775: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 1852: IF NOT FND_API.Compatible_API_Call

1848: oe_debug_pub.add('Entered process_attr_mapping.........................');
1849:
1850: -- Standard call to check for call compatibility
1851:
1852: IF NOT FND_API.Compatible_API_Call
1853: ( l_api_version_number
1854: , p_api_version_number
1855: , l_api_name
1856: , G_PKG_NAME

Line 1859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1855: , l_api_name
1856: , G_PKG_NAME
1857: )
1858: THEN
1859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1860: END IF;
1861:
1862: -- Initialize message list.
1863:

Line 1864: IF FND_API.to_Boolean(p_init_msg_list) THEN

1860: END IF;
1861:
1862: -- Initialize message list.
1863:
1864: IF FND_API.to_Boolean(p_init_msg_list) THEN
1865: OE_MSG_PUB.initialize;
1866: END IF;
1867:
1868: -- Init local table variables.

Line 1925: --** l_RQT_rec.lookup_code = FND_API.G_MISS_CHAR)

1921:
1922: IF l_RQT_rec.operation = QP_GLOBALS.G_OPR_CREATE
1923: --**AND (l_RQT_rec.lookup_code IS NULL OR
1924: AND (l_RQT_rec.pte_code IS NULL OR
1925: --** l_RQT_rec.lookup_code = FND_API.G_MISS_CHAR)
1926: l_RQT_rec.pte_code = FND_API.G_MISS_CHAR)
1927: THEN
1928:
1929: -- Copy parent_id.

Line 1926: l_RQT_rec.pte_code = FND_API.G_MISS_CHAR)

1922: IF l_RQT_rec.operation = QP_GLOBALS.G_OPR_CREATE
1923: --**AND (l_RQT_rec.lookup_code IS NULL OR
1924: AND (l_RQT_rec.pte_code IS NULL OR
1925: --** l_RQT_rec.lookup_code = FND_API.G_MISS_CHAR)
1926: l_RQT_rec.pte_code = FND_API.G_MISS_CHAR)
1927: THEN
1928:
1929: -- Copy parent_id.
1930:

Line 1968: --**l_SSC_rec.lookup_code = FND_API.G_MISS_CHAR)

1964:
1965: IF l_SSC_rec.operation = QP_GLOBALS.G_OPR_CREATE
1966: --**AND (l_SSC_rec.lookup_code IS NULL OR
1967: AND (l_SSC_rec.pte_code IS NULL OR
1968: --**l_SSC_rec.lookup_code = FND_API.G_MISS_CHAR)
1969: l_SSC_rec.pte_code = FND_API.G_MISS_CHAR)
1970: THEN
1971:
1972: -- Copy parent_id.

Line 1969: l_SSC_rec.pte_code = FND_API.G_MISS_CHAR)

1965: IF l_SSC_rec.operation = QP_GLOBALS.G_OPR_CREATE
1966: --**AND (l_SSC_rec.lookup_code IS NULL OR
1967: AND (l_SSC_rec.pte_code IS NULL OR
1968: --**l_SSC_rec.lookup_code = FND_API.G_MISS_CHAR)
1969: l_SSC_rec.pte_code = FND_API.G_MISS_CHAR)
1970: THEN
1971:
1972: -- Copy parent_id.
1973:

Line 2011: --**l_PSG_rec.lookup_code = FND_API.G_MISS_CHAR)

2007:
2008: IF l_PSG_rec.operation = QP_GLOBALS.G_OPR_CREATE
2009: --**AND (l_PSG_rec.lookup_code IS NULL OR
2010: AND (l_PSG_rec.pte_code IS NULL OR
2011: --**l_PSG_rec.lookup_code = FND_API.G_MISS_CHAR)
2012: l_PSG_rec.pte_code = FND_API.G_MISS_CHAR)
2013: THEN
2014:
2015: -- Copy parent_id.

Line 2012: l_PSG_rec.pte_code = FND_API.G_MISS_CHAR)

2008: IF l_PSG_rec.operation = QP_GLOBALS.G_OPR_CREATE
2009: --**AND (l_PSG_rec.lookup_code IS NULL OR
2010: AND (l_PSG_rec.pte_code IS NULL OR
2011: --**l_PSG_rec.lookup_code = FND_API.G_MISS_CHAR)
2012: l_PSG_rec.pte_code = FND_API.G_MISS_CHAR)
2013: THEN
2014:
2015: -- Copy parent_id.
2016:

Line 2058: --**l_SOU_rec.segment_pte_id = FND_API.G_MISS_NUM)

2054: --dbms_output.put_line('in qp_qttr_mapping_pvt 21 ............................');
2055: IF l_SOU_rec.operation = QP_GLOBALS.G_OPR_CREATE
2056: --**AND (l_SOU_rec.segment_pte_id IS NULL OR
2057: AND (l_SOU_rec.segment_id IS NULL OR
2058: --**l_SOU_rec.segment_pte_id = FND_API.G_MISS_NUM)
2059: l_SOU_rec.segment_id = FND_API.G_MISS_NUM)
2060: THEN
2061: --dbms_output.put_line('in qp_qttr_mapping_pvt inside 21 ............................');
2062: --dbms_output.put_line('l_sou_rec.psg_index='||l_sou_rec.psg_index);

Line 2059: l_SOU_rec.segment_id = FND_API.G_MISS_NUM)

2055: IF l_SOU_rec.operation = QP_GLOBALS.G_OPR_CREATE
2056: --**AND (l_SOU_rec.segment_pte_id IS NULL OR
2057: AND (l_SOU_rec.segment_id IS NULL OR
2058: --**l_SOU_rec.segment_pte_id = FND_API.G_MISS_NUM)
2059: l_SOU_rec.segment_id = FND_API.G_MISS_NUM)
2060: THEN
2061: --dbms_output.put_line('in qp_qttr_mapping_pvt inside 21 ............................');
2062: --dbms_output.put_line('l_sou_rec.psg_index='||l_sou_rec.psg_index);
2063:

Line 2129: l_FNA_rec.pte_source_system_id = FND_API.G_MISS_NUM)

2125: l_FNA_rec := l_FNA_tbl(I);
2126:
2127: IF l_FNA_rec.operation = QP_GLOBALS.G_OPR_CREATE
2128: AND (l_FNA_rec.pte_source_system_id IS NULL OR
2129: l_FNA_rec.pte_source_system_id = FND_API.G_MISS_NUM)
2130: THEN
2131:
2132: -- Copy parent_id.
2133: l_FNA_tbl(I).pte_source_system_id := l_SSC_rec.pte_source_system_id;

Line 2199: x_return_status := FND_API.G_RET_STS_SUCCESS;

2195: END IF;
2196:
2197: -- Derive return status.
2198:
2199: x_return_status := FND_API.G_RET_STS_SUCCESS;
2200:
2201: IF l_PTE_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2202: x_return_status := FND_API.G_RET_STS_ERROR;
2203: END IF;

Line 2201: IF l_PTE_rec.return_status = FND_API.G_RET_STS_ERROR THEN

2197: -- Derive return status.
2198:
2199: x_return_status := FND_API.G_RET_STS_SUCCESS;
2200:
2201: IF l_PTE_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2202: x_return_status := FND_API.G_RET_STS_ERROR;
2203: END IF;
2204:
2205: FOR I IN 1..l_RQT_tbl.COUNT LOOP

Line 2202: x_return_status := FND_API.G_RET_STS_ERROR;

2198:
2199: x_return_status := FND_API.G_RET_STS_SUCCESS;
2200:
2201: IF l_PTE_rec.return_status = FND_API.G_RET_STS_ERROR THEN
2202: x_return_status := FND_API.G_RET_STS_ERROR;
2203: END IF;
2204:
2205: FOR I IN 1..l_RQT_tbl.COUNT LOOP
2206:

Line 2207: IF l_RQT_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN

2203: END IF;
2204:
2205: FOR I IN 1..l_RQT_tbl.COUNT LOOP
2206:
2207: IF l_RQT_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
2208: x_return_status := FND_API.G_RET_STS_ERROR;
2209: END IF;
2210:
2211: END LOOP;

Line 2208: x_return_status := FND_API.G_RET_STS_ERROR;

2204:
2205: FOR I IN 1..l_RQT_tbl.COUNT LOOP
2206:
2207: IF l_RQT_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
2208: x_return_status := FND_API.G_RET_STS_ERROR;
2209: END IF;
2210:
2211: END LOOP;
2212:

Line 2215: IF l_SSC_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN

2211: END LOOP;
2212:
2213: FOR I IN 1..l_SSC_tbl.COUNT LOOP
2214:
2215: IF l_SSC_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
2216: x_return_status := FND_API.G_RET_STS_ERROR;
2217: END IF;
2218:
2219: END LOOP;

Line 2216: x_return_status := FND_API.G_RET_STS_ERROR;

2212:
2213: FOR I IN 1..l_SSC_tbl.COUNT LOOP
2214:
2215: IF l_SSC_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
2216: x_return_status := FND_API.G_RET_STS_ERROR;
2217: END IF;
2218:
2219: END LOOP;
2220:

Line 2223: IF l_PSG_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN

2219: END LOOP;
2220:
2221: FOR I IN 1..l_PSG_tbl.COUNT LOOP
2222:
2223: IF l_PSG_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
2224: x_return_status := FND_API.G_RET_STS_ERROR;
2225: END IF;
2226:
2227: END LOOP;

Line 2224: x_return_status := FND_API.G_RET_STS_ERROR;

2220:
2221: FOR I IN 1..l_PSG_tbl.COUNT LOOP
2222:
2223: IF l_PSG_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
2224: x_return_status := FND_API.G_RET_STS_ERROR;
2225: END IF;
2226:
2227: END LOOP;
2228:

Line 2231: IF l_SOU_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN

2227: END LOOP;
2228:
2229: FOR I IN 1..l_SOU_tbl.COUNT LOOP
2230:
2231: IF l_SOU_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
2232: x_return_status := FND_API.G_RET_STS_ERROR;
2233: END IF;
2234:
2235: END LOOP;

Line 2232: x_return_status := FND_API.G_RET_STS_ERROR;

2228:
2229: FOR I IN 1..l_SOU_tbl.COUNT LOOP
2230:
2231: IF l_SOU_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
2232: x_return_status := FND_API.G_RET_STS_ERROR;
2233: END IF;
2234:
2235: END LOOP;
2236:

Line 2239: IF l_FNA_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN

2235: END LOOP;
2236:
2237: FOR I IN 1..l_FNA_tbl.COUNT LOOP
2238:
2239: IF l_FNA_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
2240: x_return_status := FND_API.G_RET_STS_ERROR;
2241: END IF;
2242:
2243: END LOOP;

Line 2240: x_return_status := FND_API.G_RET_STS_ERROR;

2236:
2237: FOR I IN 1..l_FNA_tbl.COUNT LOOP
2238:
2239: IF l_FNA_tbl(I).return_status = FND_API.G_RET_STS_ERROR THEN
2240: x_return_status := FND_API.G_RET_STS_ERROR;
2241: END IF;
2242:
2243: END LOOP;
2244:

Line 2255: WHEN FND_API.G_EXC_ERROR THEN

2251:
2252:
2253: EXCEPTION
2254:
2255: WHEN FND_API.G_EXC_ERROR THEN
2256:
2257: x_return_status := FND_API.G_RET_STS_ERROR;
2258:
2259: if p_control_rec.called_from_ui = 'N' then

Line 2257: x_return_status := FND_API.G_RET_STS_ERROR;

2253: EXCEPTION
2254:
2255: WHEN FND_API.G_EXC_ERROR THEN
2256:
2257: x_return_status := FND_API.G_RET_STS_ERROR;
2258:
2259: if p_control_rec.called_from_ui = 'N' then
2260: qp_delayed_requests_pvt.Clear_Request
2261: (x_return_status => l_return_status);

Line 2271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2267: ( p_count => x_msg_count
2268: , p_data => x_msg_data
2269: );
2270:
2271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2272:
2273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2274:
2275: if p_control_rec.called_from_ui = 'N' then

Line 2273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2269: );
2270:
2271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2272:
2273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2274:
2275: if p_control_rec.called_from_ui = 'N' then
2276: qp_delayed_requests_pvt.Clear_Request
2277: (x_return_status => l_return_status);

Line 2289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2285: );
2286:
2287: WHEN OTHERS THEN
2288:
2289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2290:
2291: if p_control_rec.called_from_ui = 'N' then
2292: qp_delayed_requests_pvt.Clear_Request
2293: (x_return_status => l_return_status);

Line 2331: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2327: -- End of Comments
2328:
2329: PROCEDURE Lock_Attr_Mapping
2330: ( p_api_version_number IN NUMBER
2331: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2332: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2333: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2334: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2335: , p_PTE_rec IN QP_Attr_Map_PUB.Pte_Rec_Type :=

Line 2357: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2353: )
2354: IS
2355: l_api_version_number CONSTANT NUMBER := 1.0;
2356: l_api_name CONSTANT VARCHAR2(30):= 'Lock_Attr_Mapping';
2357: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2358: l_RQT_rec QP_Attr_Map_PUB.Rqt_Rec_Type;
2359: l_SSC_rec QP_Attr_Map_PUB.Ssc_Rec_Type;
2360: l_PSG_rec QP_Attr_Map_PUB.Psg_Rec_Type;
2361: l_SOU_rec QP_Attr_Map_PUB.Sou_Rec_Type;

Line 2367: IF NOT FND_API.Compatible_API_Call

2363: BEGIN
2364:
2365: -- Standard call to check for call compatibility
2366:
2367: IF NOT FND_API.Compatible_API_Call
2368: ( l_api_version_number
2369: , p_api_version_number
2370: , l_api_name
2371: , G_PKG_NAME

Line 2374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2370: , l_api_name
2371: , G_PKG_NAME
2372: )
2373: THEN
2374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2375: END IF;
2376:
2377: -- Initialize message list.
2378:

Line 2379: IF FND_API.to_Boolean(p_init_msg_list) THEN

2375: END IF;
2376:
2377: -- Initialize message list.
2378:
2379: IF FND_API.to_Boolean(p_init_msg_list) THEN
2380: OE_MSG_PUB.initialize;
2381: END IF;
2382:
2383: -- Set Savepoint

Line 2397: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2393: , x_PTE_rec => x_PTE_rec
2394: , x_return_status => l_return_status
2395: );
2396:
2397: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2399: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2400: RAISE FND_API.G_EXC_ERROR;
2401: END IF;

Line 2398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2394: , x_return_status => l_return_status
2395: );
2396:
2397: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2399: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2400: RAISE FND_API.G_EXC_ERROR;
2401: END IF;
2402:

Line 2399: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2395: );
2396:
2397: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2399: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2400: RAISE FND_API.G_EXC_ERROR;
2401: END IF;
2402:
2403:

Line 2400: RAISE FND_API.G_EXC_ERROR;

2396:
2397: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2399: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2400: RAISE FND_API.G_EXC_ERROR;
2401: END IF;
2402:
2403:
2404: END IF;

Line 2418: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2414: , x_RQT_rec => l_RQT_rec
2415: , x_return_status => l_return_status
2416: );
2417:
2418: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2420: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2421: RAISE FND_API.G_EXC_ERROR;
2422: END IF;

Line 2419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2415: , x_return_status => l_return_status
2416: );
2417:
2418: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2420: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2421: RAISE FND_API.G_EXC_ERROR;
2422: END IF;
2423:

Line 2420: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2416: );
2417:
2418: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2420: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2421: RAISE FND_API.G_EXC_ERROR;
2422: END IF;
2423:
2424: x_RQT_tbl(I) := l_RQT_rec;

Line 2421: RAISE FND_API.G_EXC_ERROR;

2417:
2418: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2420: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2421: RAISE FND_API.G_EXC_ERROR;
2422: END IF;
2423:
2424: x_RQT_tbl(I) := l_RQT_rec;
2425:

Line 2442: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2438: , x_SSC_rec => l_SSC_rec
2439: , x_return_status => l_return_status
2440: );
2441:
2442: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2444: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2445: RAISE FND_API.G_EXC_ERROR;
2446: END IF;

Line 2443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2439: , x_return_status => l_return_status
2440: );
2441:
2442: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2444: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2445: RAISE FND_API.G_EXC_ERROR;
2446: END IF;
2447:

Line 2444: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2440: );
2441:
2442: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2444: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2445: RAISE FND_API.G_EXC_ERROR;
2446: END IF;
2447:
2448: x_SSC_tbl(I) := l_SSC_rec;

Line 2445: RAISE FND_API.G_EXC_ERROR;

2441:
2442: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2444: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2445: RAISE FND_API.G_EXC_ERROR;
2446: END IF;
2447:
2448: x_SSC_tbl(I) := l_SSC_rec;
2449:

Line 2466: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2462: , x_PSG_rec => l_PSG_rec
2463: , x_return_status => l_return_status
2464: );
2465:
2466: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2468: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2469: RAISE FND_API.G_EXC_ERROR;
2470: END IF;

Line 2467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2463: , x_return_status => l_return_status
2464: );
2465:
2466: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2468: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2469: RAISE FND_API.G_EXC_ERROR;
2470: END IF;
2471:

Line 2468: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2464: );
2465:
2466: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2468: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2469: RAISE FND_API.G_EXC_ERROR;
2470: END IF;
2471:
2472: x_PSG_tbl(I) := l_PSG_rec;

Line 2469: RAISE FND_API.G_EXC_ERROR;

2465:
2466: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2468: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2469: RAISE FND_API.G_EXC_ERROR;
2470: END IF;
2471:
2472: x_PSG_tbl(I) := l_PSG_rec;
2473:

Line 2490: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2486: , x_SOU_rec => l_SOU_rec
2487: , x_return_status => l_return_status
2488: );
2489:
2490: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2492: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2493: RAISE FND_API.G_EXC_ERROR;
2494: END IF;

Line 2491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2487: , x_return_status => l_return_status
2488: );
2489:
2490: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2492: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2493: RAISE FND_API.G_EXC_ERROR;
2494: END IF;
2495:

Line 2492: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2488: );
2489:
2490: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2492: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2493: RAISE FND_API.G_EXC_ERROR;
2494: END IF;
2495:
2496: x_SOU_tbl(I) := l_SOU_rec;

Line 2493: RAISE FND_API.G_EXC_ERROR;

2489:
2490: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2492: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2493: RAISE FND_API.G_EXC_ERROR;
2494: END IF;
2495:
2496: x_SOU_tbl(I) := l_SOU_rec;
2497:

Line 2514: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2510: , x_FNA_rec => l_FNA_rec
2511: , x_return_status => l_return_status
2512: );
2513:
2514: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2516: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2517: RAISE FND_API.G_EXC_ERROR;
2518: END IF;

Line 2515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2511: , x_return_status => l_return_status
2512: );
2513:
2514: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2516: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2517: RAISE FND_API.G_EXC_ERROR;
2518: END IF;
2519:

Line 2516: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2512: );
2513:
2514: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2516: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2517: RAISE FND_API.G_EXC_ERROR;
2518: END IF;
2519:
2520: x_FNA_tbl(I) := l_FNA_rec;

Line 2517: RAISE FND_API.G_EXC_ERROR;

2513:
2514: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2516: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2517: RAISE FND_API.G_EXC_ERROR;
2518: END IF;
2519:
2520: x_FNA_tbl(I) := l_FNA_rec;
2521:

Line 2528: x_return_status := FND_API.G_RET_STS_SUCCESS;

2524: END LOOP;
2525:
2526: -- Set return status
2527:
2528: x_return_status := FND_API.G_RET_STS_SUCCESS;
2529:
2530: -- Get message count and data
2531:
2532: OE_MSG_PUB.Count_And_Get

Line 2540: WHEN FND_API.G_EXC_ERROR THEN

2536:
2537:
2538: EXCEPTION
2539:
2540: WHEN FND_API.G_EXC_ERROR THEN
2541:
2542: x_return_status := FND_API.G_RET_STS_ERROR;
2543:
2544: -- Get message count and data

Line 2542: x_return_status := FND_API.G_RET_STS_ERROR;

2538: EXCEPTION
2539:
2540: WHEN FND_API.G_EXC_ERROR THEN
2541:
2542: x_return_status := FND_API.G_RET_STS_ERROR;
2543:
2544: -- Get message count and data
2545:
2546: OE_MSG_PUB.Count_And_Get

Line 2555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2551: -- Rollback
2552:
2553: ROLLBACK TO Lock_Attr_Mapping_PVT;
2554:
2555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2556:
2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2558:
2559: -- Get message count and data

Line 2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2553: ROLLBACK TO Lock_Attr_Mapping_PVT;
2554:
2555: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2556:
2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2558:
2559: -- Get message count and data
2560:
2561: OE_MSG_PUB.Count_And_Get

Line 2572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2568: ROLLBACK TO Lock_Attr_Mapping_PVT;
2569:
2570: WHEN OTHERS THEN
2571:
2572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2573:
2574: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2575: THEN
2576: OE_MSG_PUB.Add_Exc_Msg

Line 2613: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2609: -- End of Comments
2610:
2611: PROCEDURE Get_Attr_Mapping
2612: ( p_api_version_number IN NUMBER
2613: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2614: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2615: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
2616: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
2617: , p_lookup_code IN VARCHAR2

Line 2640: IF NOT FND_API.Compatible_API_Call

2636: BEGIN
2637:
2638: -- Standard call to check for call compatibility
2639:
2640: IF NOT FND_API.Compatible_API_Call
2641: ( l_api_version_number
2642: , p_api_version_number
2643: , l_api_name
2644: , G_PKG_NAME

Line 2647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2643: , l_api_name
2644: , G_PKG_NAME
2645: )
2646: THEN
2647: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2648: END IF;
2649:
2650: -- Initialize message list.
2651:

Line 2652: IF FND_API.to_Boolean(p_init_msg_list) THEN

2648: END IF;
2649:
2650: -- Initialize message list.
2651:
2652: IF FND_API.to_Boolean(p_init_msg_list) THEN
2653: OE_MSG_PUB.initialize;
2654: END IF;
2655:
2656: -- Get PTE ( parent = PTE )

Line 2733: x_return_status := FND_API.G_RET_STS_SUCCESS;

2729: x_FNA_tbl := l_x_FNA_tbl;
2730:
2731: -- Set return status
2732:
2733: x_return_status := FND_API.G_RET_STS_SUCCESS;
2734:
2735: -- Get message count and data
2736:
2737: OE_MSG_PUB.Count_And_Get

Line 2745: WHEN FND_API.G_EXC_ERROR THEN

2741:
2742:
2743: EXCEPTION
2744:
2745: WHEN FND_API.G_EXC_ERROR THEN
2746:
2747: x_return_status := FND_API.G_RET_STS_ERROR;
2748:
2749: -- Get message count and data

Line 2747: x_return_status := FND_API.G_RET_STS_ERROR;

2743: EXCEPTION
2744:
2745: WHEN FND_API.G_EXC_ERROR THEN
2746:
2747: x_return_status := FND_API.G_RET_STS_ERROR;
2748:
2749: -- Get message count and data
2750:
2751: OE_MSG_PUB.Count_And_Get

Line 2756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2752: ( p_count => x_msg_count
2753: , p_data => x_msg_data
2754: );
2755:
2756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2757:
2758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2759:
2760: -- Get message count and data

Line 2758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2754: );
2755:
2756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2757:
2758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2759:
2760: -- Get message count and data
2761:
2762: OE_MSG_PUB.Count_And_Get

Line 2769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2765: );
2766:
2767: WHEN OTHERS THEN
2768:
2769: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2770:
2771: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2772: THEN
2773: OE_MSG_PUB.Add_Exc_Msg

Line 2817: ,p_delete => FND_API.G_TRUE

2813:
2814: -- Execute FNA delayed request to check for enabled functional areas
2815: QP_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
2816: (p_entity_code => QP_GLOBALS.G_ENTITY_FNA
2817: ,p_delete => FND_API.G_TRUE
2818: ,x_return_status => x_return_status
2819: );
2820:
2821: oe_msg_pub.Count_And_Get