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

Line 95: FND_MSG_PUB.initialize;

91: END IF;
92:
93: -- Initialize message list if p_init_msg_list is set to TRUE.
94: IF FND_API.to_Boolean( p_init_msg_list ) THEN
95: FND_MSG_PUB.initialize;
96: END IF;
97:
98: -- Initialize API return status to success
99: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 138: FND_MSG_PUB.Count_And_Get

134: COMMIT WORK;
135: END IF;
136:
137: -- Standard call to get message count and if count is 1, get message info.
138: FND_MSG_PUB.Count_And_Get
139: (p_count => x_msg_count ,
140: p_data => x_msg_data );
141:
142: EXCEPTION

Line 146: FND_MSG_PUB.Count_And_Get

142: EXCEPTION
143: WHEN FND_API.G_EXC_ERROR THEN
144: ROLLBACK TO get_ancestor_group;
145: x_return_status := FND_API.G_RET_STS_ERROR ;
146: FND_MSG_PUB.Count_And_Get
147: (p_count => x_msg_count ,
148: p_data => x_msg_data );
149:
150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 153: FND_MSG_PUB.Count_And_Get

149:
150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
151: ROLLBACK TO get_ancestor_group;
152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
153: FND_MSG_PUB.Count_And_Get
154: (p_count => x_msg_count ,
155: p_data => x_msg_data );
156:
157: WHEN OTHERS THEN

Line 160: IF FND_MSG_PUB.Check_Msg_Level

156:
157: WHEN OTHERS THEN
158: ROLLBACK TO get_ancestor_group;
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
160: IF FND_MSG_PUB.Check_Msg_Level
161: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
162: THEN
163: FND_MSG_PUB.Add_Exc_Msg
164: (G_PKG_NAME ,

Line 161: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

157: WHEN OTHERS THEN
158: ROLLBACK TO get_ancestor_group;
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
160: IF FND_MSG_PUB.Check_Msg_Level
161: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
162: THEN
163: FND_MSG_PUB.Add_Exc_Msg
164: (G_PKG_NAME ,
165: l_api_name );

Line 163: FND_MSG_PUB.Add_Exc_Msg

159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
160: IF FND_MSG_PUB.Check_Msg_Level
161: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
162: THEN
163: FND_MSG_PUB.Add_Exc_Msg
164: (G_PKG_NAME ,
165: l_api_name );
166: END IF;
167: FND_MSG_PUB.Count_And_Get

Line 167: FND_MSG_PUB.Count_And_Get

163: FND_MSG_PUB.Add_Exc_Msg
164: (G_PKG_NAME ,
165: l_api_name );
166: END IF;
167: FND_MSG_PUB.Count_And_Get
168: (p_count => x_msg_count ,
169: p_data => x_msg_data );
170:
171: END get_ancestor_group;

Line 245: FND_MSG_PUB.initialize;

241: END IF;
242:
243: -- Initialize message list if p_init_msg_list is set to TRUE.
244: IF FND_API.to_Boolean( p_init_msg_list ) THEN
245: FND_MSG_PUB.initialize;
246: END IF;
247:
248: -- Initialize API return status to success
249: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 288: FND_MSG_PUB.Count_And_Get

284: COMMIT WORK;
285: END IF;
286:
287: -- Standard call to get message count and if count is 1, get message info.
288: FND_MSG_PUB.Count_And_Get
289: (p_count => x_msg_count ,
290: p_data => x_msg_data );
291:
292: EXCEPTION

Line 296: FND_MSG_PUB.Count_And_Get

292: EXCEPTION
293: WHEN FND_API.G_EXC_ERROR THEN
294: ROLLBACK TO get_descendant_group;
295: x_return_status := FND_API.G_RET_STS_ERROR ;
296: FND_MSG_PUB.Count_And_Get
297: (p_count => x_msg_count ,
298: p_data => x_msg_data );
299:
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 303: FND_MSG_PUB.Count_And_Get

299:
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
301: ROLLBACK TO get_descendant_group;
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
303: FND_MSG_PUB.Count_And_Get
304: (p_count => x_msg_count ,
305: p_data => x_msg_data );
306:
307: WHEN OTHERS THEN

Line 310: IF FND_MSG_PUB.Check_Msg_Level

306:
307: WHEN OTHERS THEN
308: ROLLBACK TO get_descendant_group;
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: IF FND_MSG_PUB.Check_Msg_Level
311: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
312: THEN
313: FND_MSG_PUB.Add_Exc_Msg
314: (G_PKG_NAME ,

Line 311: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

307: WHEN OTHERS THEN
308: ROLLBACK TO get_descendant_group;
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: IF FND_MSG_PUB.Check_Msg_Level
311: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
312: THEN
313: FND_MSG_PUB.Add_Exc_Msg
314: (G_PKG_NAME ,
315: l_api_name );

Line 313: FND_MSG_PUB.Add_Exc_Msg

309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
310: IF FND_MSG_PUB.Check_Msg_Level
311: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
312: THEN
313: FND_MSG_PUB.Add_Exc_Msg
314: (G_PKG_NAME ,
315: l_api_name );
316: END IF;
317: FND_MSG_PUB.Count_And_Get

Line 317: FND_MSG_PUB.Count_And_Get

313: FND_MSG_PUB.Add_Exc_Msg
314: (G_PKG_NAME ,
315: l_api_name );
316: END IF;
317: FND_MSG_PUB.Count_And_Get
318: (p_count => x_msg_count ,
319: p_data => x_msg_data );
320:
321: END get_descendant_group;

Line 418: FND_MSG_PUB.initialize;

414: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
415: END IF;
416: -- Initialize message list if p_init_msg_list is set to TRUE.
417: IF FND_API.to_Boolean( p_init_msg_list ) THEN
418: FND_MSG_PUB.initialize;
419: END IF;
420: -- Initialize API return status to success
421: x_return_status := FND_API.G_RET_STS_SUCCESS;
422: -- API body

Line 491: FND_MSG_PUB.Count_And_Get

487: IF FND_API.To_Boolean( p_commit ) THEN
488: COMMIT WORK;
489: END IF;
490: -- Standard call to get message count and if count is 1, get message info.
491: FND_MSG_PUB.Count_And_Get
492: (p_count => x_msg_count ,
493: p_data => x_msg_data ,
494: p_encoded => FND_API.G_FALSE );
495: EXCEPTION

Line 499: FND_MSG_PUB.Count_And_Get

495: EXCEPTION
496: WHEN FND_API.G_EXC_ERROR THEN
497: ROLLBACK TO get_managers_pvt;
498: x_return_status := FND_API.G_RET_STS_ERROR ;
499: FND_MSG_PUB.Count_And_Get
500: (p_count => x_msg_count ,
501: p_data => x_msg_data ,
502: p_encoded => FND_API.G_FALSE );
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 506: FND_MSG_PUB.Count_And_Get

502: p_encoded => FND_API.G_FALSE );
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
504: ROLLBACK TO get_managers_pvt;
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
506: FND_MSG_PUB.Count_And_Get
507: (p_count => x_msg_count ,
508: p_data => x_msg_data ,
509: p_encoded => FND_API.G_FALSE );
510: WHEN OTHERS THEN

Line 513: IF FND_MSG_PUB.Check_Msg_Level

509: p_encoded => FND_API.G_FALSE );
510: WHEN OTHERS THEN
511: ROLLBACK TO get_managers_pvt;
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
513: IF FND_MSG_PUB.Check_Msg_Level
514: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
515: THEN
516: FND_MSG_PUB.Add_Exc_Msg
517: (G_PKG_NAME ,

Line 514: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

510: WHEN OTHERS THEN
511: ROLLBACK TO get_managers_pvt;
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
513: IF FND_MSG_PUB.Check_Msg_Level
514: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
515: THEN
516: FND_MSG_PUB.Add_Exc_Msg
517: (G_PKG_NAME ,
518: l_api_name );

Line 516: FND_MSG_PUB.Add_Exc_Msg

512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
513: IF FND_MSG_PUB.Check_Msg_Level
514: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
515: THEN
516: FND_MSG_PUB.Add_Exc_Msg
517: (G_PKG_NAME ,
518: l_api_name );
519: END IF;
520: FND_MSG_PUB.Count_And_Get

Line 520: FND_MSG_PUB.Count_And_Get

516: FND_MSG_PUB.Add_Exc_Msg
517: (G_PKG_NAME ,
518: l_api_name );
519: END IF;
520: FND_MSG_PUB.Count_And_Get
521: (p_count => x_msg_count ,
522: p_data => x_msg_data ,
523: p_encoded => FND_API.G_FALSE );
524: END Get_Managers;

Line 603: FND_MSG_PUB.initialize;

599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
600: END IF;
601: -- Initialize message list if p_init_msg_list is set to TRUE.
602: IF FND_API.to_Boolean( p_init_msg_list ) THEN
603: FND_MSG_PUB.initialize;
604: END IF;
605: -- Initialize API return status to success
606: x_return_status := FND_API.G_RET_STS_SUCCESS;
607: -- API body

Line 647: FND_MSG_PUB.Count_And_Get

643: IF FND_API.To_Boolean( p_commit ) THEN
644: COMMIT WORK;
645: END IF;
646: -- Standard call to get message count and if count is 1, get message info.
647: FND_MSG_PUB.Count_And_Get
648: (p_count => x_msg_count ,
649: p_data => x_msg_data ,
650: p_encoded => FND_API.G_FALSE );
651: EXCEPTION

Line 655: FND_MSG_PUB.Count_And_Get

651: EXCEPTION
652: WHEN FND_API.G_EXC_ERROR THEN
653: ROLLBACK TO get_salesreps_pvt;
654: x_return_status := FND_API.G_RET_STS_ERROR ;
655: FND_MSG_PUB.Count_And_Get
656: (p_count => x_msg_count ,
657: p_data => x_msg_data ,
658: p_encoded => FND_API.G_FALSE );
659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 662: FND_MSG_PUB.Count_And_Get

658: p_encoded => FND_API.G_FALSE );
659: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
660: ROLLBACK TO get_salesreps_pvt;
661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
662: FND_MSG_PUB.Count_And_Get
663: (p_count => x_msg_count ,
664: p_data => x_msg_data ,
665: p_encoded => FND_API.G_FALSE );
666: WHEN OTHERS THEN

Line 669: IF FND_MSG_PUB.Check_Msg_Level

665: p_encoded => FND_API.G_FALSE );
666: WHEN OTHERS THEN
667: ROLLBACK TO get_salesreps_pvt;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
669: IF FND_MSG_PUB.Check_Msg_Level
670: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
671: THEN
672: FND_MSG_PUB.Add_Exc_Msg
673: (G_PKG_NAME ,

Line 670: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

666: WHEN OTHERS THEN
667: ROLLBACK TO get_salesreps_pvt;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
669: IF FND_MSG_PUB.Check_Msg_Level
670: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
671: THEN
672: FND_MSG_PUB.Add_Exc_Msg
673: (G_PKG_NAME ,
674: l_api_name );

Line 672: FND_MSG_PUB.Add_Exc_Msg

668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
669: IF FND_MSG_PUB.Check_Msg_Level
670: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
671: THEN
672: FND_MSG_PUB.Add_Exc_Msg
673: (G_PKG_NAME ,
674: l_api_name );
675: END IF;
676: FND_MSG_PUB.Count_And_Get

Line 676: FND_MSG_PUB.Count_And_Get

672: FND_MSG_PUB.Add_Exc_Msg
673: (G_PKG_NAME ,
674: l_api_name );
675: END IF;
676: FND_MSG_PUB.Count_And_Get
677: (p_count => x_msg_count ,
678: p_data => x_msg_data ,
679: p_encoded => FND_API.G_FALSE );
680: END Get_Salesreps;

Line 763: FND_MSG_PUB.initialize;

759: END IF;
760:
761: -- Initialize message list if p_init_msg_list is set to TRUE.
762: IF FND_API.to_Boolean( p_init_msg_list ) THEN
763: FND_MSG_PUB.initialize;
764: END IF;
765:
766: -- Initialize API return status to success
767: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 876: FND_MSG_PUB.Count_And_Get

872: COMMIT WORK;
873: END IF;
874:
875: -- Standard call to get message count and if count is 1, get message info.
876: FND_MSG_PUB.Count_And_Get
877: (p_count => x_msg_count ,
878: p_data => x_msg_data );
879:
880: EXCEPTION

Line 884: FND_MSG_PUB.Count_And_Get

880: EXCEPTION
881: WHEN FND_API.G_EXC_ERROR THEN
882: ROLLBACK TO get_ancestor_salesrep;
883: x_return_status := FND_API.G_RET_STS_ERROR ;
884: FND_MSG_PUB.Count_And_Get
885: (p_count => x_msg_count ,
886: p_data => x_msg_data );
887:
888: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 891: FND_MSG_PUB.Count_And_Get

887:
888: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
889: ROLLBACK TO get_ancestor_salesrep;
890: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
891: FND_MSG_PUB.Count_And_Get
892: (p_count => x_msg_count ,
893: p_data => x_msg_data );
894:
895: WHEN OTHERS THEN

Line 898: IF FND_MSG_PUB.Check_Msg_Level

894:
895: WHEN OTHERS THEN
896: ROLLBACK TO get_ancestor_salesrep;
897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
898: IF FND_MSG_PUB.Check_Msg_Level
899: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
900: THEN
901: FND_MSG_PUB.Add_Exc_Msg
902: (G_PKG_NAME ,

Line 899: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

895: WHEN OTHERS THEN
896: ROLLBACK TO get_ancestor_salesrep;
897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
898: IF FND_MSG_PUB.Check_Msg_Level
899: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
900: THEN
901: FND_MSG_PUB.Add_Exc_Msg
902: (G_PKG_NAME ,
903: l_api_name );

Line 901: FND_MSG_PUB.Add_Exc_Msg

897: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
898: IF FND_MSG_PUB.Check_Msg_Level
899: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
900: THEN
901: FND_MSG_PUB.Add_Exc_Msg
902: (G_PKG_NAME ,
903: l_api_name );
904: END IF;
905: FND_MSG_PUB.Count_And_Get

Line 905: FND_MSG_PUB.Count_And_Get

901: FND_MSG_PUB.Add_Exc_Msg
902: (G_PKG_NAME ,
903: l_api_name );
904: END IF;
905: FND_MSG_PUB.Count_And_Get
906: (p_count => x_msg_count ,
907: p_data => x_msg_data );
908:
909: END Get_Ancestor_Salesreps;

Line 995: FND_MSG_PUB.initialize;

991: END IF;
992:
993: -- Initialize message list if p_init_msg_list is set to TRUE.
994: IF FND_API.to_Boolean( p_init_msg_list ) THEN
995: FND_MSG_PUB.initialize;
996: END IF;
997:
998: -- Initialize API return status to success
999: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1096: FND_MSG_PUB.Count_And_Get

1092: COMMIT WORK;
1093: END IF;
1094:
1095: -- Standard call to get message count and if count is 1, get message info.
1096: FND_MSG_PUB.Count_And_Get
1097: (p_count => x_msg_count ,
1098: p_data => x_msg_data );
1099:
1100: EXCEPTION

Line 1104: FND_MSG_PUB.Count_And_Get

1100: EXCEPTION
1101: WHEN FND_API.G_EXC_ERROR THEN
1102: ROLLBACK TO get_descendant_salesreps;
1103: x_return_status := FND_API.G_RET_STS_ERROR ;
1104: FND_MSG_PUB.Count_And_Get
1105: (p_count => x_msg_count ,
1106: p_data => x_msg_data );
1107:
1108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1111: FND_MSG_PUB.Count_And_Get

1107:
1108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1109: ROLLBACK TO get_descendant_salesreps;
1110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1111: FND_MSG_PUB.Count_And_Get
1112: (p_count => x_msg_count ,
1113: p_data => x_msg_data );
1114:
1115: WHEN OTHERS THEN

Line 1118: IF FND_MSG_PUB.Check_Msg_Level

1114:
1115: WHEN OTHERS THEN
1116: ROLLBACK TO get_descendant_salesreps;
1117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1118: IF FND_MSG_PUB.Check_Msg_Level
1119: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1120: THEN
1121: FND_MSG_PUB.Add_Exc_Msg
1122: (G_PKG_NAME ,

Line 1119: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1115: WHEN OTHERS THEN
1116: ROLLBACK TO get_descendant_salesreps;
1117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1118: IF FND_MSG_PUB.Check_Msg_Level
1119: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1120: THEN
1121: FND_MSG_PUB.Add_Exc_Msg
1122: (G_PKG_NAME ,
1123: l_api_name );

Line 1121: FND_MSG_PUB.Add_Exc_Msg

1117: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1118: IF FND_MSG_PUB.Check_Msg_Level
1119: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1120: THEN
1121: FND_MSG_PUB.Add_Exc_Msg
1122: (G_PKG_NAME ,
1123: l_api_name );
1124: END IF;
1125: FND_MSG_PUB.Count_And_Get

Line 1125: FND_MSG_PUB.Count_And_Get

1121: FND_MSG_PUB.Add_Exc_Msg
1122: (G_PKG_NAME ,
1123: l_api_name );
1124: END IF;
1125: FND_MSG_PUB.Count_And_Get
1126: (p_count => x_msg_count ,
1127: p_data => x_msg_data );
1128:
1129: END Get_Descendant_Salesreps;

Line 1255: FND_MSG_PUB.initialize;

1251: END IF;
1252:
1253: -- Initialize message list if p_init_msg_list is set to TRUE.
1254: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1255: FND_MSG_PUB.initialize;
1256: END IF;
1257:
1258: -- Initialize API return status to success
1259: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1348: FND_MSG_PUB.Count_And_Get

1344: COMMIT WORK;
1345: END IF;
1346:
1347: -- Standard call to get message count and if count is 1, get message info.
1348: FND_MSG_PUB.Count_And_Get
1349: (p_count => x_msg_count ,
1350: p_data => x_msg_data );
1351:
1352: EXCEPTION

Line 1356: FND_MSG_PUB.Count_And_Get

1352: EXCEPTION
1353: WHEN FND_API.G_EXC_ERROR THEN
1354: ROLLBACK TO Get_Descendant_group_mbrs;
1355: x_return_status := FND_API.G_RET_STS_ERROR ;
1356: FND_MSG_PUB.Count_And_Get
1357: (p_count => x_msg_count ,
1358: p_data => x_msg_data );
1359:
1360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1363: FND_MSG_PUB.Count_And_Get

1359:
1360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1361: ROLLBACK TO Get_Descendant_group_mbrs;
1362: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1363: FND_MSG_PUB.Count_And_Get
1364: (p_count => x_msg_count ,
1365: p_data => x_msg_data );
1366:
1367: WHEN OTHERS THEN

Line 1370: IF FND_MSG_PUB.Check_Msg_Level

1366:
1367: WHEN OTHERS THEN
1368: ROLLBACK TO Get_Descendant_group_mbrs;
1369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1370: IF FND_MSG_PUB.Check_Msg_Level
1371: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1372: THEN
1373: FND_MSG_PUB.Add_Exc_Msg
1374: (G_PKG_NAME ,

Line 1371: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1367: WHEN OTHERS THEN
1368: ROLLBACK TO Get_Descendant_group_mbrs;
1369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1370: IF FND_MSG_PUB.Check_Msg_Level
1371: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1372: THEN
1373: FND_MSG_PUB.Add_Exc_Msg
1374: (G_PKG_NAME ,
1375: l_api_name );

Line 1373: FND_MSG_PUB.Add_Exc_Msg

1369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1370: IF FND_MSG_PUB.Check_Msg_Level
1371: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1372: THEN
1373: FND_MSG_PUB.Add_Exc_Msg
1374: (G_PKG_NAME ,
1375: l_api_name );
1376: END IF;
1377: FND_MSG_PUB.Count_And_Get

Line 1377: FND_MSG_PUB.Count_And_Get

1373: FND_MSG_PUB.Add_Exc_Msg
1374: (G_PKG_NAME ,
1375: l_api_name );
1376: END IF;
1377: FND_MSG_PUB.Count_And_Get
1378: (p_count => x_msg_count ,
1379: p_data => x_msg_data );
1380:
1381: END Get_Descendant_group_mbrs;

Line 1541: FND_MSG_PUB.initialize;

1537: END IF;
1538:
1539: -- Initialize message list if p_init_msg_list is set to TRUE.
1540: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1541: FND_MSG_PUB.initialize;
1542: END IF;
1543:
1544: -- Initialize API return status to success
1545: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1714: FND_MSG_PUB.Count_And_Get

1710: COMMIT WORK;
1711: END IF;
1712:
1713: -- Standard call to get message count and if count is 1, get message info.
1714: FND_MSG_PUB.Count_And_Get
1715: (p_count => x_msg_count ,
1716: p_data => x_msg_data );
1717:
1718: EXCEPTION

Line 1722: FND_MSG_PUB.Count_And_Get

1718: EXCEPTION
1719: WHEN FND_API.G_EXC_ERROR THEN
1720: ROLLBACK TO Get_MO_Descendant_group_mbrs;
1721: x_return_status := FND_API.G_RET_STS_ERROR ;
1722: FND_MSG_PUB.Count_And_Get
1723: (p_count => x_msg_count ,
1724: p_data => x_msg_data );
1725:
1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1729: FND_MSG_PUB.Count_And_Get

1725:
1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1727: ROLLBACK TO Get_MO_Descendant_group_mbrs;
1728: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1729: FND_MSG_PUB.Count_And_Get
1730: (p_count => x_msg_count ,
1731: p_data => x_msg_data );
1732:
1733: WHEN OTHERS THEN

Line 1736: IF FND_MSG_PUB.Check_Msg_Level

1732:
1733: WHEN OTHERS THEN
1734: ROLLBACK TO Get_MO_Descendant_group_mbrs;
1735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1736: IF FND_MSG_PUB.Check_Msg_Level
1737: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1738: THEN
1739: FND_MSG_PUB.Add_Exc_Msg
1740: (G_PKG_NAME ,

Line 1737: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1733: WHEN OTHERS THEN
1734: ROLLBACK TO Get_MO_Descendant_group_mbrs;
1735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1736: IF FND_MSG_PUB.Check_Msg_Level
1737: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1738: THEN
1739: FND_MSG_PUB.Add_Exc_Msg
1740: (G_PKG_NAME ,
1741: l_api_name );

Line 1739: FND_MSG_PUB.Add_Exc_Msg

1735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1736: IF FND_MSG_PUB.Check_Msg_Level
1737: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1738: THEN
1739: FND_MSG_PUB.Add_Exc_Msg
1740: (G_PKG_NAME ,
1741: l_api_name );
1742: END IF;
1743: FND_MSG_PUB.Count_And_Get

Line 1743: FND_MSG_PUB.Count_And_Get

1739: FND_MSG_PUB.Add_Exc_Msg
1740: (G_PKG_NAME ,
1741: l_api_name );
1742: END IF;
1743: FND_MSG_PUB.Count_And_Get
1744: (p_count => x_msg_count ,
1745: p_data => x_msg_data );
1746:
1747: END Get_MO_Descendant_group_mbrs;

Line 1844: FND_MSG_PUB.initialize;

1840: END IF;
1841:
1842: -- Initialize message list if p_init_msg_list is set to TRUE.
1843: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1844: FND_MSG_PUB.initialize;
1845: END IF;
1846:
1847: -- Initialize API return status to success
1848: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1961: FND_MSG_PUB.Count_And_Get

1957: COMMIT WORK;
1958: END IF;
1959:
1960: -- Standard call to get message count and if count is 1, get message info.
1961: FND_MSG_PUB.Count_And_Get
1962: (p_count => x_msg_count ,
1963: p_data => x_msg_data );
1964:
1965: EXCEPTION

Line 1969: FND_MSG_PUB.Count_And_Get

1965: EXCEPTION
1966: WHEN FND_API.G_EXC_ERROR THEN
1967: ROLLBACK TO get_desc_role_info;
1968: x_return_status := FND_API.G_RET_STS_ERROR ;
1969: FND_MSG_PUB.Count_And_Get
1970: (p_count => x_msg_count ,
1971: p_data => x_msg_data );
1972:
1973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1976: FND_MSG_PUB.Count_And_Get

1972:
1973: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1974: ROLLBACK TO get_desc_role_info;
1975: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1976: FND_MSG_PUB.Count_And_Get
1977: (p_count => x_msg_count ,
1978: p_data => x_msg_data );
1979:
1980: WHEN OTHERS THEN

Line 1983: IF FND_MSG_PUB.Check_Msg_Level

1979:
1980: WHEN OTHERS THEN
1981: ROLLBACK TO get_desc_role_info;
1982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1983: IF FND_MSG_PUB.Check_Msg_Level
1984: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1985: THEN
1986: FND_MSG_PUB.Add_Exc_Msg
1987: (G_PKG_NAME ,

Line 1984: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1980: WHEN OTHERS THEN
1981: ROLLBACK TO get_desc_role_info;
1982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1983: IF FND_MSG_PUB.Check_Msg_Level
1984: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1985: THEN
1986: FND_MSG_PUB.Add_Exc_Msg
1987: (G_PKG_NAME ,
1988: l_api_name );

Line 1986: FND_MSG_PUB.Add_Exc_Msg

1982: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1983: IF FND_MSG_PUB.Check_Msg_Level
1984: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1985: THEN
1986: FND_MSG_PUB.Add_Exc_Msg
1987: (G_PKG_NAME ,
1988: l_api_name );
1989: END IF;
1990: FND_MSG_PUB.Count_And_Get

Line 1990: FND_MSG_PUB.Count_And_Get

1986: FND_MSG_PUB.Add_Exc_Msg
1987: (G_PKG_NAME ,
1988: l_api_name );
1989: END IF;
1990: FND_MSG_PUB.Count_And_Get
1991: (p_count => x_msg_count ,
1992: p_data => x_msg_data );
1993:
1994: END Get_Desc_role_info;

Line 2135: FND_MSG_PUB.initialize;

2131: END IF;
2132:
2133: -- Initialize message list if p_init_msg_list is set to TRUE.
2134: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2135: FND_MSG_PUB.initialize;
2136: END IF;
2137:
2138: -- Initialize API return status to success
2139: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2396: FND_MSG_PUB.Count_And_Get

2392: COMMIT WORK;
2393: END IF;
2394:
2395: -- Standard call to get message count and if count is 1, get message info.
2396: FND_MSG_PUB.Count_And_Get
2397: (p_count => x_msg_count ,
2398: p_data => x_msg_data );
2399:
2400: EXCEPTION

Line 2404: FND_MSG_PUB.Count_And_Get

2400: EXCEPTION
2401: WHEN FND_API.G_EXC_ERROR THEN
2402: ROLLBACK TO Get_MO_desc_role_info;
2403: x_return_status := FND_API.G_RET_STS_ERROR ;
2404: FND_MSG_PUB.Count_And_Get
2405: (p_count => x_msg_count ,
2406: p_data => x_msg_data );
2407:
2408: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2411: FND_MSG_PUB.Count_And_Get

2407:
2408: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2409: ROLLBACK TO Get_MO_desc_role_info;
2410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2411: FND_MSG_PUB.Count_And_Get
2412: (p_count => x_msg_count ,
2413: p_data => x_msg_data );
2414:
2415: WHEN OTHERS THEN

Line 2418: IF FND_MSG_PUB.Check_Msg_Level

2414:
2415: WHEN OTHERS THEN
2416: ROLLBACK TO Get_MO_desc_role_info;
2417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2418: IF FND_MSG_PUB.Check_Msg_Level
2419: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2420: THEN
2421: FND_MSG_PUB.Add_Exc_Msg
2422: (G_PKG_NAME ,

Line 2419: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2415: WHEN OTHERS THEN
2416: ROLLBACK TO Get_MO_desc_role_info;
2417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2418: IF FND_MSG_PUB.Check_Msg_Level
2419: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2420: THEN
2421: FND_MSG_PUB.Add_Exc_Msg
2422: (G_PKG_NAME ,
2423: l_api_name );

Line 2421: FND_MSG_PUB.Add_Exc_Msg

2417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2418: IF FND_MSG_PUB.Check_Msg_Level
2419: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2420: THEN
2421: FND_MSG_PUB.Add_Exc_Msg
2422: (G_PKG_NAME ,
2423: l_api_name );
2424: END IF;
2425: FND_MSG_PUB.Count_And_Get

Line 2425: FND_MSG_PUB.Count_And_Get

2421: FND_MSG_PUB.Add_Exc_Msg
2422: (G_PKG_NAME ,
2423: l_api_name );
2424: END IF;
2425: FND_MSG_PUB.Count_And_Get
2426: (p_count => x_msg_count ,
2427: p_data => x_msg_data );
2428:
2429: END Get_MO_desc_role_info;

Line 2522: FND_MSG_PUB.initialize;

2518: END IF;
2519:
2520: -- Initialize message list if p_init_msg_list is set to TRUE.
2521: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2522: FND_MSG_PUB.initialize;
2523: END IF;
2524:
2525: -- Initialize API return status to success
2526: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2621: FND_MSG_PUB.Count_And_Get

2617: COMMIT WORK;
2618: END IF;
2619:
2620: -- Standard call to get message count and if count is 1, get message info.
2621: FND_MSG_PUB.Count_And_Get
2622: (p_count => x_msg_count ,
2623: p_data => x_msg_data );
2624:
2625: EXCEPTION

Line 2629: FND_MSG_PUB.Count_And_Get

2625: EXCEPTION
2626: WHEN FND_API.G_EXC_ERROR THEN
2627: ROLLBACK TO get_all_managers;
2628: x_return_status := FND_API.G_RET_STS_ERROR ;
2629: FND_MSG_PUB.Count_And_Get
2630: (p_count => x_msg_count ,
2631: p_data => x_msg_data );
2632:
2633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2636: FND_MSG_PUB.Count_And_Get

2632:
2633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2634: ROLLBACK TO get_all_managers;
2635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2636: FND_MSG_PUB.Count_And_Get
2637: (p_count => x_msg_count ,
2638: p_data => x_msg_data );
2639:
2640: WHEN OTHERS THEN

Line 2643: IF FND_MSG_PUB.Check_Msg_Level

2639:
2640: WHEN OTHERS THEN
2641: ROLLBACK TO get_all_managers;
2642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2643: IF FND_MSG_PUB.Check_Msg_Level
2644: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2645: THEN
2646: FND_MSG_PUB.Add_Exc_Msg
2647: (G_PKG_NAME ,

Line 2644: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

2640: WHEN OTHERS THEN
2641: ROLLBACK TO get_all_managers;
2642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2643: IF FND_MSG_PUB.Check_Msg_Level
2644: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2645: THEN
2646: FND_MSG_PUB.Add_Exc_Msg
2647: (G_PKG_NAME ,
2648: l_api_name );

Line 2646: FND_MSG_PUB.Add_Exc_Msg

2642: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2643: IF FND_MSG_PUB.Check_Msg_Level
2644: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2645: THEN
2646: FND_MSG_PUB.Add_Exc_Msg
2647: (G_PKG_NAME ,
2648: l_api_name );
2649: END IF;
2650: FND_MSG_PUB.Count_And_Get

Line 2650: FND_MSG_PUB.Count_And_Get

2646: FND_MSG_PUB.Add_Exc_Msg
2647: (G_PKG_NAME ,
2648: l_api_name );
2649: END IF;
2650: FND_MSG_PUB.Count_And_Get
2651: (p_count => x_msg_count ,
2652: p_data => x_msg_data );
2653:
2654: END Get_All_Managers;