DBA Data[Home] [Help]

APPS.QP_PTE_UTIL dependencies on FND_MSG_PUB

Line 260: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

256: EXCEPTION
257:
258: WHEN OTHERS THEN
259:
260: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
261: THEN
262: FND_MSG_PUB.Add_Exc_Msg
263: ( G_PKG_NAME
264: , 'Update_Row'

Line 262: FND_MSG_PUB.Add_Exc_Msg

258: WHEN OTHERS THEN
259:
260: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
261: THEN
262: FND_MSG_PUB.Add_Exc_Msg
263: ( G_PKG_NAME
264: , 'Update_Row'
265: );
266: END IF;

Line 306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

302: EXCEPTION
303:
304: WHEN OTHERS THEN
305:
306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
307: THEN
308: FND_MSG_PUB.Add_Exc_Msg
309: ( G_PKG_NAME
310: , 'Insert_Row'

Line 308: FND_MSG_PUB.Add_Exc_Msg

304: WHEN OTHERS THEN
305:
306: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
307: THEN
308: FND_MSG_PUB.Add_Exc_Msg
309: ( G_PKG_NAME
310: , 'Insert_Row'
311: );
312: END IF;

Line 336: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

332: EXCEPTION
333:
334: WHEN OTHERS THEN
335:
336: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
337: THEN
338: FND_MSG_PUB.Add_Exc_Msg
339: ( G_PKG_NAME
340: , 'Delete_Row'

Line 338: FND_MSG_PUB.Add_Exc_Msg

334: WHEN OTHERS THEN
335:
336: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
337: THEN
338: FND_MSG_PUB.Add_Exc_Msg
339: ( G_PKG_NAME
340: , 'Delete_Row'
341: );
342: END IF;

Line 381: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

377: EXCEPTION
378:
379: WHEN OTHERS THEN
380:
381: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
382: THEN
383: FND_MSG_PUB.Add_Exc_Msg
384: ( G_PKG_NAME
385: , 'Query_Row'

Line 383: FND_MSG_PUB.Add_Exc_Msg

379: WHEN OTHERS THEN
380:
381: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
382: THEN
383: FND_MSG_PUB.Add_Exc_Msg
384: ( G_PKG_NAME
385: , 'Query_Row'
386: );
387: END IF;

Line 458: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

454:
455: x_return_status := FND_API.G_RET_STS_ERROR;
456: x_PTE_rec.return_status := FND_API.G_RET_STS_ERROR;
457:
458: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
459: THEN
460:
461: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
462: FND_MSG_PUB.Add;

Line 462: FND_MSG_PUB.Add;

458: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
459: THEN
460:
461: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_CHANGED');
462: FND_MSG_PUB.Add;
463:
464: END IF;
465:
466: END IF;

Line 475: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

471:
472: x_return_status := FND_API.G_RET_STS_ERROR;
473: x_PTE_rec.return_status := FND_API.G_RET_STS_ERROR;
474:
475: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
476: THEN
477:
478: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
479: FND_MSG_PUB.Add;

Line 479: FND_MSG_PUB.Add;

475: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
476: THEN
477:
478: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_DELETED');
479: FND_MSG_PUB.Add;
480:
481: END IF;
482: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
483:

Line 487: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

483:
484: x_return_status := FND_API.G_RET_STS_ERROR;
485: x_PTE_rec.return_status := FND_API.G_RET_STS_ERROR;
486:
487: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
488: THEN
489:
490: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
491: FND_MSG_PUB.Add;

Line 491: FND_MSG_PUB.Add;

487: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
488: THEN
489:
490: FND_MESSAGE.SET_NAME('QP','OE_LOCK_ROW_ALREADY_LOCKED');
491: FND_MSG_PUB.Add;
492:
493: END IF;
494: WHEN OTHERS THEN
495:

Line 499: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

495:
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: x_PTE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
498:
499: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
500: THEN
501: FND_MSG_PUB.Add_Exc_Msg
502: ( G_PKG_NAME
503: , 'Lock_Row'

Line 501: FND_MSG_PUB.Add_Exc_Msg

497: x_PTE_rec.return_status := FND_API.G_RET_STS_UNEXP_ERROR;
498:
499: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
500: THEN
501: FND_MSG_PUB.Add_Exc_Msg
502: ( G_PKG_NAME
503: , 'Lock_Row'
504: );
505: END IF;

Line 569: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

565: IF p_PTE_rec.enabled_flag <> FND_API.G_MISS_CHAR THEN
566:
567: l_PTE_rec.enabled_flag := p_PTE_rec.enabled_flag;
568:
569: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
570: THEN
571:
572: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
573: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','enabled');

Line 574: FND_MSG_PUB.Add;

570: THEN
571:
572: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
573: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','enabled');
574: FND_MSG_PUB.Add;
575:
576: END IF;
577:
578: ELSE

Line 599: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)

595: IF p_PTE_rec.lookup_code <> FND_API.G_MISS_CHAR THEN
596:
597: l_PTE_rec.lookup_code := p_PTE_rec.lookup_code;
598:
599: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
600: THEN
601:
602: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
603: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','lookup');

Line 604: FND_MSG_PUB.Add;

600: THEN
601:
602: FND_MESSAGE.SET_NAME('QP','FND_BOTH_VAL_AND_ID_EXIST');
603: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','lookup');
604: FND_MSG_PUB.Add;
605:
606: END IF;
607:
608: ELSE