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_WORKSHEET_PVT dependencies on FND_MSG_PUB

Line 43: FND_MSG_PUB.initialize;

39:
40: -- Initialize message list if p_init_msg_list is set to TRUE.
41:
42: if FND_API.to_Boolean (p_init_msg_list) then
43: FND_MSG_PUB.initialize;
44: end if;
45:
46:
47: -- Call Private Function

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

60:
61:
62: -- Standard call to get message count and if count is 1, get message info.
63:
64: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
65: p_data => p_msg_data);
66:
67: EXCEPTION
68:

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

69: when FND_API.G_EXC_ERROR then
70: rollback to Create_WS_Line_Items_Pvt;
71: p_return_status := FND_API.G_RET_STS_ERROR;
72:
73: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
74: p_data => p_msg_data);
75:
76: when FND_API.G_EXC_UNEXPECTED_ERROR then
77: rollback to Create_WS_Line_Items_Pvt;

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

76: when FND_API.G_EXC_UNEXPECTED_ERROR then
77: rollback to Create_WS_Line_Items_Pvt;
78: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
79:
80: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
81: p_data => p_msg_data);
82:
83: when OTHERS then
84: rollback to Create_WS_Line_Items_Pvt;

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

83: when OTHERS then
84: rollback to Create_WS_Line_Items_Pvt;
85: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
86:
87: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
88: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
89: l_api_name);
90: end if;
91:

Line 88: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

84: rollback to Create_WS_Line_Items_Pvt;
85: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
86:
87: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
88: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
89: l_api_name);
90: end if;
91:
92: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

88: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
89: l_api_name);
90: end if;
91:
92: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
93: p_data => p_msg_data);
94:
95: END Create_WS_Line_Items;
96:

Line 135: FND_MSG_PUB.initialize;

131:
132: -- Initialize message list if p_init_msg_list is set to TRUE.
133:
134: if FND_API.to_Boolean (p_init_msg_list) then
135: FND_MSG_PUB.initialize;
136: end if;
137:
138:
139: -- Call Private Function

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

153:
154:
155: -- Standard call to get message count and if count is 1, get message info.
156:
157: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
158: p_data => p_msg_data);
159:
160: EXCEPTION
161:

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

162: when FND_API.G_EXC_ERROR then
163: rollback to Delete_WS_Line_Items_Pvt;
164: p_return_status := FND_API.G_RET_STS_ERROR;
165:
166: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
167: p_data => p_msg_data);
168:
169: when FND_API.G_EXC_UNEXPECTED_ERROR then
170: rollback to Delete_WS_Line_Items_Pvt;

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

169: when FND_API.G_EXC_UNEXPECTED_ERROR then
170: rollback to Delete_WS_Line_Items_Pvt;
171: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172:
173: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
174: p_data => p_msg_data);
175:
176: when OTHERS then
177: rollback to Delete_WS_Line_Items_Pvt;

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

176: when OTHERS then
177: rollback to Delete_WS_Line_Items_Pvt;
178: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
179:
180: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
181: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
182: l_api_name);
183: end if;
184:

Line 181: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

177: rollback to Delete_WS_Line_Items_Pvt;
178: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
179:
180: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
181: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
182: l_api_name);
183: end if;
184:
185: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

181: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
182: l_api_name);
183: end if;
184:
185: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
186: p_data => p_msg_data);
187:
188: END Delete_WS_Line_Items;
189:

Line 285: FND_MSG_PUB.initialize;

281:
282: -- Initialize message list if p_init_msg_list is set to TRUE.
283:
284: if FND_API.to_Boolean (p_init_msg_list) then
285: FND_MSG_PUB.initialize;
286: end if;
287:
288:
289: -- Call Private Function

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

361:
362:
363: -- Standard call to get message count and if count is 1, get message info.
364:
365: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
366: p_data => p_msg_data);
367:
368: EXCEPTION
369:

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

370: when FND_API.G_EXC_ERROR then
371: rollback to Create_Worksheet_Pvt;
372: p_return_status := FND_API.G_RET_STS_ERROR;
373:
374: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
375: p_data => p_msg_data);
376:
377: when FND_API.G_EXC_UNEXPECTED_ERROR then
378: rollback to Create_Worksheet_Pvt;

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

377: when FND_API.G_EXC_UNEXPECTED_ERROR then
378: rollback to Create_Worksheet_Pvt;
379: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380:
381: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
382: p_data => p_msg_data);
383:
384: when OTHERS then
385: rollback to Create_Worksheet_Pvt;

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

384: when OTHERS then
385: rollback to Create_Worksheet_Pvt;
386: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387:
388: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
389: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
390: l_api_name);
391: end if;
392:

Line 389: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

385: rollback to Create_Worksheet_Pvt;
386: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
387:
388: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
389: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
390: l_api_name);
391: end if;
392:
393: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

389: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
390: l_api_name);
391: end if;
392:
393: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
394: p_data => p_msg_data);
395:
396: END Create_Worksheet;
397:

Line 480: FND_MSG_PUB.initialize;

476:
477: -- Initialize message list if p_init_msg_list is set to TRUE.
478:
479: if FND_API.to_Boolean (p_init_msg_list) then
480: FND_MSG_PUB.initialize;
481: end if;
482:
483:
484: -- Call Private Function

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

544:
545:
546: -- Standard call to get message count and if count is 1, get message info.
547:
548: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
549: p_data => p_msg_data);
550:
551: EXCEPTION
552:

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

553: when FND_API.G_EXC_ERROR then
554: rollback to Update_Worksheet_Pvt;
555: p_return_status := FND_API.G_RET_STS_ERROR;
556:
557: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
558: p_data => p_msg_data);
559:
560: when FND_API.G_EXC_UNEXPECTED_ERROR then
561: rollback to Update_Worksheet_Pvt;

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

560: when FND_API.G_EXC_UNEXPECTED_ERROR then
561: rollback to Update_Worksheet_Pvt;
562: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563:
564: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
565: p_data => p_msg_data);
566:
567: when OTHERS then
568: rollback to Update_Worksheet_Pvt;

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

567: when OTHERS then
568: rollback to Update_Worksheet_Pvt;
569: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570:
571: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
572: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
573: l_api_name);
574: end if;
575:

Line 572: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

568: rollback to Update_Worksheet_Pvt;
569: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
570:
571: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
572: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
573: l_api_name);
574: end if;
575:
576: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

572: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
573: l_api_name);
574: end if;
575:
576: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
577: p_data => p_msg_data);
578:
579: END Update_Worksheet;
580:

Line 617: FND_MSG_PUB.initialize;

613:
614: -- Initialize message list if p_init_msg_list is set to TRUE.
615:
616: if FND_API.to_Boolean (p_init_msg_list) then
617: FND_MSG_PUB.initialize;
618: end if;
619:
620:
621: -- Call Private Function

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

634:
635:
636: -- Standard call to get message count and if count is 1, get message info.
637:
638: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
639: p_data => p_msg_data);
640:
641: EXCEPTION
642:

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

643: when FND_API.G_EXC_ERROR then
644: rollback to Delete_Worksheet_Pvt;
645: p_return_status := FND_API.G_RET_STS_ERROR;
646:
647: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
648: p_data => p_msg_data);
649:
650:
651: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

651: when FND_API.G_EXC_UNEXPECTED_ERROR then
652: rollback to Delete_Worksheet_Pvt;
653: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
654:
655: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
656: p_data => p_msg_data);
657:
658:
659: when OTHERS then

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

659: when OTHERS then
660: rollback to Delete_Worksheet_Pvt;
661: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662:
663: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
664: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
665: l_api_name);
666: end if;
667:

Line 664: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

660: rollback to Delete_Worksheet_Pvt;
661: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
662:
663: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
664: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
665: l_api_name);
666: end if;
667:
668: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

664: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
665: l_api_name);
666: end if;
667:
668: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
669: p_data => p_msg_data);
670:
671:
672: END Delete_Worksheet;

Line 724: FND_MSG_PUB.initialize;

720:
721: -- Initialize message list if p_init_msg_list is set to TRUE.
722:
723: if FND_API.to_Boolean (p_init_msg_list) then
724: FND_MSG_PUB.initialize;
725: end if;
726:
727:
728: -- Call Private Function

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

754:
755:
756: -- Standard call to get message count and if count is 1, get message info.
757:
758: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
759: p_data => p_msg_data);
760:
761: EXCEPTION
762:

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

763: when FND_API.G_EXC_ERROR then
764: rollback to Apply_Constraints_Pvt;
765: p_return_status := FND_API.G_RET_STS_ERROR;
766:
767: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
768: p_data => p_msg_data);
769:
770:
771: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

771: when FND_API.G_EXC_UNEXPECTED_ERROR then
772: rollback to Apply_Constraints_Pvt;
773: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
774:
775: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
776: p_data => p_msg_data);
777:
778:
779: when OTHERS then

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

779: when OTHERS then
780: rollback to Apply_Constraints_Pvt;
781: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782:
783: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
784: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
785: l_api_name);
786: end if;
787:

Line 784: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

780: rollback to Apply_Constraints_Pvt;
781: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
782:
783: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
784: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
785: l_api_name);
786: end if;
787:
788: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

784: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
785: l_api_name);
786: end if;
787:
788: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
789: p_data => p_msg_data);
790:
791:
792: END Apply_Constraints;

Line 828: FND_MSG_PUB.initialize;

824:
825: -- Initialize message list if p_init_msg_list is set to TRUE.
826:
827: if FND_API.to_Boolean (p_init_msg_list) then
828: FND_MSG_PUB.initialize;
829: end if;
830:
831:
832: -- Call Private Function

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

841:
842:
843: -- Standard call to get message count and if count is 1, get message info.
844:
845: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
846: p_data => p_msg_data);
847:
848: EXCEPTION
849:

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

849:
850: when FND_API.G_EXC_ERROR then
851: p_return_status := FND_API.G_RET_STS_ERROR;
852:
853: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
854: p_data => p_msg_data);
855:
856:
857: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

856:
857: when FND_API.G_EXC_UNEXPECTED_ERROR then
858: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
859:
860: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
861: p_data => p_msg_data);
862:
863:
864: when OTHERS then

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

863:
864: when OTHERS then
865: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866:
867: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
868: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
869: l_api_name);
870: end if;
871:

Line 868: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

864: when OTHERS then
865: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
866:
867: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
868: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
869: l_api_name);
870: end if;
871:
872: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

868: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
869: l_api_name);
870: end if;
871:
872: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
873: p_data => p_msg_data);
874:
875:
876: END Validate_Entity_Set;

Line 915: FND_MSG_PUB.initialize;

911:
912: -- Initialize message list if p_init_msg_list is set to TRUE.
913:
914: if FND_API.to_Boolean (p_init_msg_list) then
915: FND_MSG_PUB.initialize;
916: end if;
917:
918:
919: -- Call Private Function

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

927:
928:
929: -- Standard call to get message count and if count is 1, get message info.
930:
931: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
932: p_data => p_msg_data);
933:
934: EXCEPTION
935:

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

936: when FND_API.G_EXC_ERROR then
937: rollback to Delete_WPL_Pvt;
938: p_return_status := FND_API.G_RET_STS_ERROR;
939:
940: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
941: p_data => p_msg_data);
942:
943:
944: when FND_API.G_EXC_UNEXPECTED_ERROR then

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

944: when FND_API.G_EXC_UNEXPECTED_ERROR then
945: rollback to Delete_WPL_Pvt;
946: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
947:
948: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
949: p_data => p_msg_data);
950:
951:
952: when OTHERS then

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

952: when OTHERS then
953: rollback to Delete_WPL_Pvt;
954: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
955:
956: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
957: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
958: l_api_name);
959: end if;
960:

Line 957: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

953: rollback to Delete_WPL_Pvt;
954: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
955:
956: if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
957: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
958: l_api_name);
959: end if;
960:
961: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,

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

957: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
958: l_api_name);
959: end if;
960:
961: FND_MSG_PUB.Count_And_Get (p_count => p_msg_count,
962: p_data => p_msg_data);
963:
964:
965: END Delete_WPL;

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

1147: COMMIT WORK ;
1148: --
1149: WHEN OTHERS THEN
1150: --
1151: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1152: --
1153: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1154: l_api_name ) ;
1155: END IF ;

Line 1153: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

1149: WHEN OTHERS THEN
1150: --
1151: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1152: --
1153: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1154: l_api_name ) ;
1155: END IF ;
1156: --
1157: l_return_status := FND_API.G_RET_STS_ERROR;

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

1257: --
1258: WHEN OTHERS THEN
1259:
1260: --
1261: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1262: --
1263: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1264: l_api_name ) ;
1265: END IF ;

Line 1263: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

1259:
1260: --
1261: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1262: --
1263: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1264: l_api_name ) ;
1265: END IF ;
1266: --
1267: l_return_status := FND_API.G_RET_STS_ERROR;

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

1326: --
1327: WHEN OTHERS THEN
1328:
1329: --
1330: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1331: --
1332: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1333: l_api_name ) ;
1334: END IF ;

Line 1332: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

1328:
1329: --
1330: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1331: --
1332: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1333: l_api_name ) ;
1334: END IF ;
1335: --
1336: l_return_status := FND_API.G_RET_STS_ERROR;

Line 1396: l_msg_count := FND_MSG_PUB.Count_Msg;

1392: END IF;
1393:
1394: /* Bug No 2550186 Start */
1395: -- Count total number of messages.
1396: l_msg_count := FND_MSG_PUB.Count_Msg;
1397:
1398: if l_msg_count > 0 then
1399: FND_MESSAGE.Set_Name('PSB', 'PSB_PROGRAM_WARNING_HEADER');
1400: l_msg_buf := FND_Message.Get;

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

1435: --
1436: WHEN OTHERS THEN
1437:
1438: --
1439: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1440: --
1441: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1442: l_api_name ) ;
1443: END IF ;

Line 1441: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

1437:
1438: --
1439: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1440: --
1441: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1442: l_api_name ) ;
1443: END IF ;
1444: --
1445: l_return_status := FND_API.G_RET_STS_ERROR;

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

1513: --
1514: WHEN OTHERS THEN
1515:
1516: --
1517: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1518: --
1519: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1520: l_api_name ) ;
1521: END IF ;

Line 1519: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

1515:
1516: --
1517: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1518: --
1519: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1520: l_api_name ) ;
1521: END IF ;
1522: --
1523: l_return_status := FND_API.G_RET_STS_ERROR;

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

1593: --
1594: WHEN OTHERS THEN
1595:
1596: --
1597: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1598: --
1599: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1600: l_api_name ) ;
1601: END IF ;

Line 1599: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

1595:
1596: --
1597: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1598: --
1599: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1600: l_api_name ) ;
1601: END IF ;
1602: --
1603: l_return_status := FND_API.G_RET_STS_ERROR;

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

1673: --
1674: WHEN OTHERS THEN
1675:
1676: --
1677: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1678: --
1679: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1680: l_api_name ) ;
1681: END IF ;

Line 1679: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

1675:
1676: --
1677: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1678: --
1679: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1680: l_api_name ) ;
1681: END IF ;
1682: --
1683: l_return_status := FND_API.G_RET_STS_ERROR;

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

1754: --
1755: WHEN OTHERS THEN
1756:
1757: --
1758: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1759: --
1760: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1761: l_api_name ) ;
1762: END IF ;

Line 1760: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

1756:
1757: --
1758: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1759: --
1760: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1761: l_api_name ) ;
1762: END IF ;
1763: --
1764: l_return_status := FND_API.G_RET_STS_ERROR;

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

1823: --
1824: WHEN OTHERS THEN
1825:
1826: --
1827: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1828: --
1829: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1830: l_api_name ) ;
1831: END IF ;

Line 1829: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,

1825:
1826: --
1827: IF FND_MSG_PUB.Check_Msg_Level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR ) THEN
1828: --
1829: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME ,
1830: l_api_name ) ;
1831: END IF ;
1832: --
1833: l_return_status := FND_API.G_RET_STS_ERROR;