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.PSB_ELEMENT_DISTRIBUTIONS_PVT dependencies on FND_MSG_PUB

Line 93: FND_MSG_PUB.initialize;

89:
90: -- Initialize message list if p_init_msg_list is set to TRUE.
91:
92: if FND_API.to_Boolean (p_init_msg_list) then
93: FND_MSG_PUB.initialize;
94: end if;
95:
96: -- Initialize API return status to success
97:

Line 213: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

209: end if;
210:
211: -- Standard call to get message count and if count is 1, get message info.
212:
213: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
214: p_data => p_msg_data);
215:
216: EXCEPTION
217:

Line 224: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

220: rollback to INSERT_ROW_PVT;
221:
222: p_return_status := FND_API.G_RET_STS_ERROR;
223:
224: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
225: p_data => p_msg_data);
226:
227:
228: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 234: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

230: rollback to INSERT_ROW_PVT;
231:
232: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
233:
234: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
235: p_data => p_msg_data);
236:
237:
238: when OTHERS then

Line 244: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

240: rollback to INSERT_ROW_PVT;
241:
242: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
243:
244: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
245:
246: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
247: l_api_name);
248: end if;

Line 246: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

242: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
243:
244: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
245:
246: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
247: l_api_name);
248: end if;
249:
250: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 250: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

246: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
247: l_api_name);
248: end if;
249:
250: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
251: p_data => p_msg_data);
252:
253: END INSERT_ROW;
254:

Line 330: FND_MSG_PUB.initialize;

326:
327: -- Initialize message list if p_init_msg_list is set to TRUE.
328:
329: if FND_API.to_Boolean (p_init_msg_list) then
330: FND_MSG_PUB.initialize;
331: end if;
332:
333: -- Initialize API return status to success
334:

Line 396: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

392: end if;
393:
394: -- Standard call to get message count and if count is 1, get message info.
395:
396: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
397: p_data => p_msg_data);
398:
399: EXCEPTION
400:

Line 407: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

403: rollback to UPDATE_ROW_PVT;
404:
405: p_return_status := FND_API.G_RET_STS_ERROR;
406:
407: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
408: p_data => p_msg_data);
409:
410:
411: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 417: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

413: rollback to UPDATE_ROW_PVT;
414:
415: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416:
417: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
418: p_data => p_msg_data);
419:
420:
421: when OTHERS then

Line 427: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

423: rollback to UPDATE_ROW_PVT;
424:
425: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
426:
427: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
428:
429: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
430: l_api_name);
431: end if;

Line 429: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

425: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
426:
427: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
428:
429: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
430: l_api_name);
431: end if;
432:
433: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 433: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

429: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
430: l_api_name);
431: end if;
432:
433: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
434: p_data => p_msg_data);
435:
436: END UPDATE_ROW;
437:

Line 476: FND_MSG_PUB.initialize;

472:
473: -- Initialize message list if p_init_msg_list is set to TRUE.
474:
475: if FND_API.to_Boolean (p_init_msg_list) then
476: FND_MSG_PUB.initialize;
477: end if;
478:
479:
480: --Delete the record in the table

Line 494: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

490: end if;
491:
492: -- Standard call to get message count and if count is 1, get message info.
493:
494: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
495: p_data => p_msg_data);
496:
497: -- Standard check of p_commit.
498:

Line 512: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

508: rollback to DELETE_ROW_PVT;
509:
510: p_return_status := FND_API.G_RET_STS_ERROR;
511:
512: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
513: p_data => p_msg_data);
514:
515:
516: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 522: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

518: rollback to DELETE_ROW_PVT;
519:
520: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
521:
522: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
523: p_data => p_msg_data);
524:
525:
526: when OTHERS then

Line 532: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

528: rollback to DELETE_ROW_PVT;
529:
530: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
531:
532: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
533:
534: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
535: l_api_name);
536: end if;

Line 534: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

530: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
531:
532: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
533:
534: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
535: l_api_name);
536: end if;
537:
538: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

Line 538: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

534: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
535: l_api_name);
536: end if;
537:
538: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
539: p_data => p_msg_data);
540: END DELETE_ROW;
541:
542: PROCEDURE LOCK_ROW(

Line 618: FND_MSG_PUB.initialize ;

614: END IF;
615: --
616:
617: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
618: FND_MSG_PUB.initialize ;
619: END IF;
620:
621: --
622: p_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 631: FND_MSG_PUB.Add;

627: FETCH C INTO Recinfo;
628: IF (C%NOTFOUND) then
629: CLOSE C;
630: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_DELETED');
631: FND_MSG_PUB.Add;
632: RAISE FND_API.G_EXC_ERROR ;
633: END IF;
634:
635: IF

Line 753: FND_MSG_PUB.Add;

749: THEN
750: Null;
751: ELSE
752: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
753: FND_MSG_PUB.Add;
754: RAISE FND_API.G_EXC_ERROR ;
755: END IF;
756:
757: --

Line 762: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

758: IF FND_API.To_Boolean ( p_commit ) THEN
759: COMMIT WORK;
760: END iF;
761: --
762: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
763: p_data => p_msg_data );
764: --
765: EXCEPTION
766: --

Line 772: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

768: --
769: ROLLBACK TO Lock_Row_Pvt ;
770: p_row_locked := FND_API.G_FALSE;
771: p_return_status := FND_API.G_RET_STS_ERROR;
772: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
773: p_data => p_msg_data );
774: --
775: WHEN FND_API.G_EXC_ERROR THEN
776: --

Line 779: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

775: WHEN FND_API.G_EXC_ERROR THEN
776: --
777: ROLLBACK TO Lock_Row_Pvt ;
778: p_return_status := FND_API.G_RET_STS_ERROR;
779: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
780: p_data => p_msg_data );
781: --
782: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
783: --

Line 786: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

782: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
783: --
784: ROLLBACK TO Lock_Row_Pvt ;
785: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
786: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
787: p_data => p_msg_data );
788: --
789: WHEN OTHERS THEN
790: --

Line 794: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

790: --
791: ROLLBACK TO Lock_Row_Pvt ;
792: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
793: --
794: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
795: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
796: l_api_name);
797: END if;
798: --

Line 795: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

791: ROLLBACK TO Lock_Row_Pvt ;
792: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
793: --
794: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
795: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
796: l_api_name);
797: END if;
798: --
799: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 799: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

795: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
796: l_api_name);
797: END if;
798: --
799: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
800: p_data => p_msg_data );
801: END LOCK_ROW;
802:
803:

Line 863: FND_MSG_PUB.initialize ;

859: END IF;
860: --
861:
862: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
863: FND_MSG_PUB.initialize ;
864: END IF;
865: --
866: p_return_status := FND_API.G_RET_STS_SUCCESS ;
867: --

Line 898: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

894: IF FND_API.To_Boolean ( p_commit ) THEN
895: COMMIT WORK;
896: END iF;
897: --
898: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
899: p_data => p_msg_data );
900: --
901: EXCEPTION
902: --

Line 907: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

903: WHEN FND_API.G_EXC_ERROR THEN
904: --
905: ROLLBACK TO Check_Unique_Pvt ;
906: p_return_status := FND_API.G_RET_STS_ERROR;
907: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
908: p_data => p_msg_data );
909: --
910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
911: --

Line 914: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

910: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
911: --
912: ROLLBACK TO Check_Unique_Pvt ;
913: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
914: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
915: p_data => p_msg_data );
916: --
917: WHEN OTHERS THEN
918: --

Line 922: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

918: --
919: ROLLBACK TO Check_Unique_Pvt ;
920: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
921: --
922: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
923: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
924: l_api_name);
925: END if;
926: --

Line 923: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,

919: ROLLBACK TO Check_Unique_Pvt ;
920: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
921: --
922: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
923: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
924: l_api_name);
925: END if;
926: --
927: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

Line 927: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,

923: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME,
924: l_api_name);
925: END if;
926: --
927: FND_MSG_PUB.Count_And_Get ( p_count => p_msg_count,
928: p_data => p_msg_data );
929: --
930: END Check_Unique;
931: