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

Line 111: FND_MSG_PUB.initialize;

107:
108: -- Initialize message list if p_init_msg_list is set to TRUE.
109: IF FND_API.to_Boolean( p_init_msg_list )
110: THEN
111: FND_MSG_PUB.initialize;
112: END IF;
113:
114: -- Initialize API return status to SUCCESS
115: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 269: FND_MSG_PUB.Count_And_Get

265: IF FND_API.To_Boolean(p_commit) THEN
266: COMMIT WORK;
267: END IF;
268: -- Standard callto get message count and if count is 1, get message info.
269: FND_MSG_PUB.Count_And_Get
270: ( p_encoded => FND_API.G_TRUE,
271: p_count => x_msg_count,
272: p_data => x_msg_data
273: );

Line 278: FND_MSG_PUB.Count_And_Get(

274: EXCEPTION
275: WHEN FND_API.G_EXC_ERROR THEN
276: ROLLBACK TO getWork_pvt;
277: x_return_status := FND_API.G_RET_STS_ERROR ;
278: FND_MSG_PUB.Count_And_Get(
279: p_encoded => FND_API.G_TRUE,
280: p_count => x_msg_count,
281: p_data => x_msg_data);
282:

Line 286: FND_MSG_PUB.Count_And_Get(

282:
283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
284: ROLLBACK TO getWork_pvt;
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
286: FND_MSG_PUB.Count_And_Get(
287: p_encoded => FND_API.G_TRUE,
288: p_count => x_msg_count,
289: p_data => x_msg_data);
290:

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

290:
291: WHEN OTHERS THEN
292: ROLLBACK TO getWork_pvt;
293: x_return_status := FND_API.G_RET_STS_ERROR;
294: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
295: THEN
296: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
297: END IF;
298: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

Line 296: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

292: ROLLBACK TO getWork_pvt;
293: x_return_status := FND_API.G_RET_STS_ERROR;
294: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
295: THEN
296: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
297: END IF;
298: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
299: p_count => x_msg_count,
300: p_data => x_msg_data);

Line 298: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

294: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
295: THEN
296: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
297: END IF;
298: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
299: p_count => x_msg_count,
300: p_data => x_msg_data);
301: END getWork;
302:

Line 411: FND_MSG_PUB.initialize;

407:
408: -- Initialize message list if p_init_msg_list is set to TRUE.
409: IF FND_API.to_Boolean( p_init_msg_list )
410: THEN
411: FND_MSG_PUB.initialize;
412: END IF;
413:
414: -- Initialize API return status to SUCCESS
415: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 529: FND_MSG_PUB.ADD;

525: WHEN IEM_NO_DATA THEN
526: ROLLBACK TO getMediaDetails_pvt;
527: x_return_status := FND_API.G_RET_STS_ERROR ;
528: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_DATA');
529: FND_MSG_PUB.ADD;
530: FND_MSG_PUB.Count_And_Get(
531: p_encoded => FND_API.G_TRUE,
532: p_count => x_msg_count,
533: p_data => x_msg_data);

Line 530: FND_MSG_PUB.Count_And_Get(

526: ROLLBACK TO getMediaDetails_pvt;
527: x_return_status := FND_API.G_RET_STS_ERROR ;
528: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_DATA');
529: FND_MSG_PUB.ADD;
530: FND_MSG_PUB.Count_And_Get(
531: p_encoded => FND_API.G_TRUE,
532: p_count => x_msg_count,
533: p_data => x_msg_data);
534: WHEN badAccountType THEN

Line 538: FND_MSG_PUB.ADD;

534: WHEN badAccountType THEN
535: ROLLBACK TO getMediaDetails_pvt;
536: x_return_status := FND_API.G_RET_STS_ERROR ;
537: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_ACCOUNT_TYPE');
538: FND_MSG_PUB.ADD;
539: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
540: p_count => x_msg_count,
541: p_data => x_msg_data);
542: WHEN FND_API.G_EXC_ERROR THEN

Line 539: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

535: ROLLBACK TO getMediaDetails_pvt;
536: x_return_status := FND_API.G_RET_STS_ERROR ;
537: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_ACCOUNT_TYPE');
538: FND_MSG_PUB.ADD;
539: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
540: p_count => x_msg_count,
541: p_data => x_msg_data);
542: WHEN FND_API.G_EXC_ERROR THEN
543: ROLLBACK TO getMediaDetails_pvt;

Line 545: FND_MSG_PUB.Count_And_Get(

541: p_data => x_msg_data);
542: WHEN FND_API.G_EXC_ERROR THEN
543: ROLLBACK TO getMediaDetails_pvt;
544: x_return_status := FND_API.G_RET_STS_ERROR ;
545: FND_MSG_PUB.Count_And_Get(
546: p_encoded => FND_API.G_TRUE,
547: p_count => x_msg_count,
548: p_data => x_msg_data);
549:

Line 553: FND_MSG_PUB.Count_And_Get(

549:
550: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
551: ROLLBACK TO getMediaDetails_pvt;
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
553: FND_MSG_PUB.Count_And_Get(
554: p_encoded => FND_API.G_TRUE,
555: p_count => x_msg_count,
556: p_data => x_msg_data);
557:

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

557:
558: WHEN OTHERS THEN
559: ROLLBACK TO getMediaDetails_pvt;
560: x_return_status := FND_API.G_RET_STS_ERROR;
561: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
562: THEN
563: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
564: END IF;
565: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

Line 563: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

559: ROLLBACK TO getMediaDetails_pvt;
560: x_return_status := FND_API.G_RET_STS_ERROR;
561: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
562: THEN
563: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
564: END IF;
565: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
566: p_count => x_msg_count,
567: p_data => x_msg_data);

Line 565: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

561: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
562: THEN
563: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
564: END IF;
565: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
566: p_count => x_msg_count,
567: p_data => x_msg_data);
568: END getMediaDetails;
569:

Line 656: FND_MSG_PUB.initialize;

652:
653: -- Initialize message list if p_init_msg_list is set to TRUE.
654: IF FND_API.to_Boolean( p_init_msg_list )
655: THEN
656: FND_MSG_PUB.initialize;
657: END IF;
658:
659: -- Initialize API return status to SUCCESS
660: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 717: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

713: -- Please keep this special status. Do not change it.
714: -- This is all thats required to inform JSPs that the email
715: -- does not exist.
716: x_return_status := 'N';
717: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
718: p_count => x_msg_count,
719: p_data => x_msg_data);
720:
721: WHEN ExQ THEN

Line 727: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

723: -- Please keep this special status. Do not change it.
724: -- This is all thats required to inform JSPs that the email
725: -- is in pre-transfer condition.
726: x_return_status := 'Q';
727: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
728: p_count => x_msg_count,
729: p_data => x_msg_data);
730:
731: WHEN FND_API.G_EXC_ERROR THEN

Line 734: FND_MSG_PUB.Count_And_Get(

730:
731: WHEN FND_API.G_EXC_ERROR THEN
732: ROLLBACK TO getSearchDetails_pvt;
733: x_return_status := FND_API.G_RET_STS_ERROR ;
734: FND_MSG_PUB.Count_And_Get(
735: p_encoded => FND_API.G_TRUE,
736: p_count => x_msg_count,
737: p_data => x_msg_data);
738:

Line 742: FND_MSG_PUB.Count_And_Get(

738:
739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
740: ROLLBACK TO getSearchDetails_pvt;
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
742: FND_MSG_PUB.Count_And_Get(
743: p_encoded => FND_API.G_TRUE,
744: p_count => x_msg_count,
745: p_data => x_msg_data);
746:

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

746:
747: WHEN OTHERS THEN
748: ROLLBACK TO getSearchDetails_pvt;
749: x_return_status := FND_API.G_RET_STS_ERROR;
750: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
751: THEN
752: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
753: END IF;
754: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

Line 752: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

748: ROLLBACK TO getSearchDetails_pvt;
749: x_return_status := FND_API.G_RET_STS_ERROR;
750: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
751: THEN
752: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
753: END IF;
754: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
755: p_count => x_msg_count,
756: p_data => x_msg_data);

Line 754: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

750: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
751: THEN
752: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
753: END IF;
754: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
755: p_count => x_msg_count,
756: p_data => x_msg_data);
757:
758: END getSearchDetails;

Line 883: FND_MSG_PUB.initialize;

879:
880: -- Initialize message list if p_init_msg_list is set to TRUE.
881: IF FND_API.to_Boolean( p_init_msg_list )
882: THEN
883: FND_MSG_PUB.initialize;
884: END IF;
885:
886: -- Initialize API return status to SUCCESS
887: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 896: FND_MSG_PUB.Count_And_Get

892: IF FND_API.To_Boolean(p_commit) THEN
893: COMMIT WORK;
894: END IF;
895: -- Standard callto get message count and if count is 1, get message info.
896: FND_MSG_PUB.Count_And_Get
897: ( p_encoded => FND_API.G_TRUE,
898: p_count => x_msg_count,
899: p_data => x_msg_data
900: );

Line 907: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

903: EXCEPTION
904: WHEN IHError THEN
905: ROLLBACK TO createUnprocMediaItm_pvt;
906: x_return_status := l_status;
907: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
908: p_count => x_msg_count,
909: p_data => x_msg_data);
910:
911: WHEN FND_API.G_EXC_ERROR THEN

Line 914: FND_MSG_PUB.Count_And_Get(

910:
911: WHEN FND_API.G_EXC_ERROR THEN
912: ROLLBACK TO createUnprocMediaItm_pvt;
913: x_return_status := FND_API.G_RET_STS_ERROR ;
914: FND_MSG_PUB.Count_And_Get(
915: p_encoded => FND_API.G_TRUE,
916: p_count => x_msg_count,
917: p_data => x_msg_data);
918:

Line 922: FND_MSG_PUB.Count_And_Get(

918:
919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
920: ROLLBACK TO createUnprocMediaItm_pvt;
921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
922: FND_MSG_PUB.Count_And_Get(
923: p_encoded => FND_API.G_TRUE,
924: p_count => x_msg_count,
925: p_data => x_msg_data);
926:

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

926:
927: WHEN OTHERS THEN
928: ROLLBACK TO createUnprocMediaItm_pvt;
929: x_return_status := FND_API.G_RET_STS_ERROR;
930: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
931: THEN
932: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
933: END IF;
934: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

Line 932: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

928: ROLLBACK TO createUnprocMediaItm_pvt;
929: x_return_status := FND_API.G_RET_STS_ERROR;
930: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
931: THEN
932: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
933: END IF;
934: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
935: p_count => x_msg_count,
936: p_data => x_msg_data);

Line 934: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

930: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
931: THEN
932: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
933: END IF;
934: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
935: p_count => x_msg_count,
936: p_data => x_msg_data);
937: END createUnprocMediaItm;
938: */

Line 1028: FND_MSG_PUB.initialize;

1024:
1025: -- Initialize message list if p_init_msg_list is set to TRUE.
1026: IF FND_API.to_Boolean( p_init_msg_list )
1027: THEN
1028: FND_MSG_PUB.initialize;
1029: END IF;
1030:
1031: -- Initialize API return status to SUCCESS
1032: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1206: FND_MSG_PUB.ADD;

1202: WHEN badAccount THEN
1203: ROLLBACK TO createMediaDetails_pvt;
1204: x_return_status := FND_API.G_RET_STS_ERROR ;
1205: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_ACCOUNT');
1206: FND_MSG_PUB.ADD;
1207: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
1208: p_count => x_msg_count,
1209: p_data => x_msg_data);
1210:

Line 1207: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

1203: ROLLBACK TO createMediaDetails_pvt;
1204: x_return_status := FND_API.G_RET_STS_ERROR ;
1205: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_ACCOUNT');
1206: FND_MSG_PUB.ADD;
1207: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
1208: p_count => x_msg_count,
1209: p_data => x_msg_data);
1210:
1211: WHEN badAccountType THEN

Line 1215: FND_MSG_PUB.ADD;

1211: WHEN badAccountType THEN
1212: ROLLBACK TO createMediaDetails_pvt;
1213: x_return_status := FND_API.G_RET_STS_ERROR ;
1214: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_ACCOUNT_TYPE');
1215: FND_MSG_PUB.ADD;
1216: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
1217: p_count => x_msg_count,
1218: p_data => x_msg_data);
1219:

Line 1216: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

1212: ROLLBACK TO createMediaDetails_pvt;
1213: x_return_status := FND_API.G_RET_STS_ERROR ;
1214: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_ACCOUNT_TYPE');
1215: FND_MSG_PUB.ADD;
1216: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
1217: p_count => x_msg_count,
1218: p_data => x_msg_data);
1219:
1220: WHEN FND_API.G_EXC_ERROR THEN

Line 1223: FND_MSG_PUB.Count_And_Get(

1219:
1220: WHEN FND_API.G_EXC_ERROR THEN
1221: ROLLBACK TO createMediaDetails_pvt;
1222: x_return_status := FND_API.G_RET_STS_ERROR ;
1223: FND_MSG_PUB.Count_And_Get(
1224: p_encoded => FND_API.G_TRUE,
1225: p_count => x_msg_count,
1226: p_data => x_msg_data);
1227:

Line 1231: FND_MSG_PUB.Count_And_Get(

1227:
1228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1229: ROLLBACK TO createMediaDetails_pvt;
1230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1231: FND_MSG_PUB.Count_And_Get(
1232: p_encoded => FND_API.G_TRUE,
1233: p_count => x_msg_count,
1234: p_data => x_msg_data);
1235:

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

1235:
1236: WHEN OTHERS THEN
1237: ROLLBACK TO createMediaDetails_pvt;
1238: x_return_status := FND_API.G_RET_STS_ERROR;
1239: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1240: THEN
1241: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1242: END IF;
1243: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

Line 1241: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

1237: ROLLBACK TO createMediaDetails_pvt;
1238: x_return_status := FND_API.G_RET_STS_ERROR;
1239: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1240: THEN
1241: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1242: END IF;
1243: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
1244: p_count => x_msg_count,
1245: p_data => x_msg_data);

Line 1243: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

1239: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1240: THEN
1241: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1242: END IF;
1243: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
1244: p_count => x_msg_count,
1245: p_data => x_msg_data);
1246: END createMediaDetails;
1247:

Line 1353: FND_MSG_PUB.initialize;

1349:
1350: -- Initialize message list if p_init_msg_list is set to TRUE.
1351: IF FND_API.to_Boolean( p_init_msg_list )
1352: THEN
1353: FND_MSG_PUB.initialize;
1354: END IF;
1355:
1356: -- Initialize API return status to SUCCESS
1357: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1656: FND_MSG_PUB.ADD;

1652: WHEN badAccountType THEN
1653: ROLLBACK TO updateMediaDetails_pvt;
1654: x_return_status := FND_API.G_RET_STS_ERROR ;
1655: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_ACCOUNT_TYPE');
1656: FND_MSG_PUB.ADD;
1657: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
1658: p_count => x_msg_count,
1659: p_data => x_msg_data);
1660: WHEN FND_API.G_EXC_ERROR THEN

Line 1657: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

1653: ROLLBACK TO updateMediaDetails_pvt;
1654: x_return_status := FND_API.G_RET_STS_ERROR ;
1655: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_ACCOUNT_TYPE');
1656: FND_MSG_PUB.ADD;
1657: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
1658: p_count => x_msg_count,
1659: p_data => x_msg_data);
1660: WHEN FND_API.G_EXC_ERROR THEN
1661: ROLLBACK TO updateMediaDetails_pvt;

Line 1663: FND_MSG_PUB.Count_And_Get(

1659: p_data => x_msg_data);
1660: WHEN FND_API.G_EXC_ERROR THEN
1661: ROLLBACK TO updateMediaDetails_pvt;
1662: x_return_status := FND_API.G_RET_STS_ERROR ;
1663: FND_MSG_PUB.Count_And_Get(
1664: p_encoded => FND_API.G_TRUE,
1665: p_count => x_msg_count,
1666: p_data => x_msg_data);
1667:

Line 1671: FND_MSG_PUB.Count_And_Get(

1667:
1668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1669: ROLLBACK TO updateMediaDetails_pvt;
1670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1671: FND_MSG_PUB.Count_And_Get(
1672: p_encoded => FND_API.G_TRUE,
1673: p_count => x_msg_count,
1674: p_data => x_msg_data);
1675:

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

1675:
1676: WHEN OTHERS THEN
1677: ROLLBACK TO updateMediaDetails_pvt;
1678: x_return_status := FND_API.G_RET_STS_ERROR;
1679: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1680: THEN
1681: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1682: END IF;
1683: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

Line 1681: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

1677: ROLLBACK TO updateMediaDetails_pvt;
1678: x_return_status := FND_API.G_RET_STS_ERROR;
1679: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1680: THEN
1681: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1682: END IF;
1683: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
1684: p_count => x_msg_count,
1685: p_data => x_msg_data);

Line 1683: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

1679: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1680: THEN
1681: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1682: END IF;
1683: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
1684: p_count => x_msg_count,
1685: p_data => x_msg_data);
1686: END updateMediaDetails;
1687:

Line 1766: FND_MSG_PUB.initialize;

1762:
1763: -- Initialize message list if p_init_msg_list is set to TRUE.
1764: IF FND_API.to_Boolean( p_init_msg_list )
1765: THEN
1766: FND_MSG_PUB.initialize;
1767: END IF;
1768:
1769: -- Initialize API return status to SUCCESS
1770: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1872: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

1868: EXCEPTION
1869: WHEN IHError THEN
1870: ROLLBACK TO getIHID_pvt;
1871: x_return_status := l_status;
1872: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
1873: p_count => x_msg_count,
1874: p_data => x_msg_data);
1875:
1876: WHEN FND_API.G_EXC_ERROR THEN

Line 1879: FND_MSG_PUB.Count_And_Get(

1875:
1876: WHEN FND_API.G_EXC_ERROR THEN
1877: ROLLBACK TO getIHID_pvt;
1878: x_return_status := FND_API.G_RET_STS_ERROR ;
1879: FND_MSG_PUB.Count_And_Get(
1880: p_encoded => FND_API.G_TRUE,
1881: p_count => x_msg_count,
1882: p_data => x_msg_data);
1883:

Line 1887: FND_MSG_PUB.Count_And_Get(

1883:
1884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1885: ROLLBACK TO getIHID_pvt;
1886: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1887: FND_MSG_PUB.Count_And_Get(
1888: p_encoded => FND_API.G_TRUE,
1889: p_count => x_msg_count,
1890: p_data => x_msg_data);
1891: WHEN OTHERS THEN

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

1890: p_data => x_msg_data);
1891: WHEN OTHERS THEN
1892: ROLLBACK TO getIHID_pvt;
1893: x_return_status := FND_API.G_RET_STS_ERROR;
1894: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1895: THEN
1896: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1897: END IF;
1898: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

Line 1896: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

1892: ROLLBACK TO getIHID_pvt;
1893: x_return_status := FND_API.G_RET_STS_ERROR;
1894: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1895: THEN
1896: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1897: END IF;
1898: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
1899: p_count => x_msg_count,
1900: p_data => x_msg_data);

Line 1898: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

1894: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1895: THEN
1896: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
1897: END IF;
1898: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
1899: p_count => x_msg_count,
1900: p_data => x_msg_data);
1901: END getIHID;
1902:

Line 2059: FND_MSG_PUB.initialize;

2055:
2056: -- Initialize message list if p_init_msg_list is set to TRUE.
2057: IF FND_API.to_Boolean( p_init_msg_list )
2058: THEN
2059: FND_MSG_PUB.initialize;
2060: END IF;
2061:
2062: -- Initialize API return status to SUCCESS
2063: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2954: FND_MSG_PUB.ADD;

2950: WHEN badResourceId THEN
2951: ROLLBACK TO wrapUp_pvt;
2952: x_return_status := l_status;
2953: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_RESOURCE_ID');
2954: FND_MSG_PUB.ADD;
2955: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
2956: p_count => x_msg_count,
2957: p_data => x_msg_data);
2958: WHEN IHError THEN

Line 2955: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

2951: ROLLBACK TO wrapUp_pvt;
2952: x_return_status := l_status;
2953: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_RESOURCE_ID');
2954: FND_MSG_PUB.ADD;
2955: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
2956: p_count => x_msg_count,
2957: p_data => x_msg_data);
2958: WHEN IHError THEN
2959: ROLLBACK TO wrapUp_pvt;

Line 2961: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

2957: p_data => x_msg_data);
2958: WHEN IHError THEN
2959: ROLLBACK TO wrapUp_pvt;
2960: x_return_status := l_status;
2961: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
2962: p_count => x_msg_count,
2963: p_data => x_msg_data);
2964: WHEN RTError THEN
2965: ROLLBACK TO wrapUp_pvt;

Line 2967: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

2963: p_data => x_msg_data);
2964: WHEN RTError THEN
2965: ROLLBACK TO wrapUp_pvt;
2966: x_return_status := l_status;
2967: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
2968: p_count => x_msg_count,
2969: p_data => x_msg_data);
2970: WHEN MDTError THEN
2971: ROLLBACK TO wrapUp_pvt;

Line 2973: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

2969: p_data => x_msg_data);
2970: WHEN MDTError THEN
2971: ROLLBACK TO wrapUp_pvt;
2972: x_return_status := l_status;
2973: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
2974: p_count => x_msg_count,
2975: p_data => x_msg_data);
2976: WHEN FND_API.G_EXC_ERROR THEN
2977: ROLLBACK TO wrapUp_pvt;

Line 2979: FND_MSG_PUB.Count_And_Get(

2975: p_data => x_msg_data);
2976: WHEN FND_API.G_EXC_ERROR THEN
2977: ROLLBACK TO wrapUp_pvt;
2978: x_return_status := FND_API.G_RET_STS_ERROR ;
2979: FND_MSG_PUB.Count_And_Get(
2980: p_encoded => FND_API.G_TRUE,
2981: p_count => x_msg_count,
2982: p_data => x_msg_data);
2983:

Line 2987: FND_MSG_PUB.Count_And_Get(

2983:
2984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2985: ROLLBACK TO wrapUp_pvt;
2986: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2987: FND_MSG_PUB.Count_And_Get(
2988: p_encoded => FND_API.G_TRUE,
2989: p_count => x_msg_count,
2990: p_data => x_msg_data);
2991: WHEN OTHERS THEN

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

2990: p_data => x_msg_data);
2991: WHEN OTHERS THEN
2992: ROLLBACK TO wrapUp_pvt;
2993: x_return_status := FND_API.G_RET_STS_ERROR;
2994: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2995: THEN
2996: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
2997: END IF;
2998: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

Line 2996: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

2992: ROLLBACK TO wrapUp_pvt;
2993: x_return_status := FND_API.G_RET_STS_ERROR;
2994: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2995: THEN
2996: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
2997: END IF;
2998: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
2999: p_count => x_msg_count,
3000: p_data => x_msg_data);

Line 2998: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

2994: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2995: THEN
2996: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
2997: END IF;
2998: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
2999: p_count => x_msg_count,
3000: p_data => x_msg_data);
3001: END wrapUp;
3002:

Line 3076: FND_MSG_PUB.initialize;

3072:
3073: -- Initialize message list if p_init_msg_list is set to TRUE.
3074: IF FND_API.to_Boolean( p_init_msg_list )
3075: THEN
3076: FND_MSG_PUB.initialize;
3077: END IF;
3078:
3079: -- Initialize API return status to SUCCESS
3080: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3126: FND_MSG_PUB.ADD;

3122: WHEN badAccountType THEN
3123: ROLLBACK TO recoverCompose_pvt;
3124: x_return_status := FND_API.G_RET_STS_ERROR ;
3125: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_ACCOUNT_TYPE');
3126: FND_MSG_PUB.ADD;
3127: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
3128: p_count => x_msg_count,
3129: p_data => x_msg_data);
3130: WHEN FND_API.G_EXC_ERROR THEN

Line 3127: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

3123: ROLLBACK TO recoverCompose_pvt;
3124: x_return_status := FND_API.G_RET_STS_ERROR ;
3125: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_ACCOUNT_TYPE');
3126: FND_MSG_PUB.ADD;
3127: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
3128: p_count => x_msg_count,
3129: p_data => x_msg_data);
3130: WHEN FND_API.G_EXC_ERROR THEN
3131: ROLLBACK TO recoverCompose_pvt;

Line 3133: FND_MSG_PUB.Count_And_Get(

3129: p_data => x_msg_data);
3130: WHEN FND_API.G_EXC_ERROR THEN
3131: ROLLBACK TO recoverCompose_pvt;
3132: x_return_status := FND_API.G_RET_STS_ERROR ;
3133: FND_MSG_PUB.Count_And_Get(
3134: p_encoded => FND_API.G_TRUE,
3135: p_count => x_msg_count,
3136: p_data => x_msg_data);
3137:

Line 3141: FND_MSG_PUB.Count_And_Get(

3137:
3138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3139: ROLLBACK TO recoverCompose_pvt;
3140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3141: FND_MSG_PUB.Count_And_Get(
3142: p_encoded => FND_API.G_TRUE,
3143: p_count => x_msg_count,
3144: p_data => x_msg_data);
3145:

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

3145:
3146: WHEN OTHERS THEN
3147: ROLLBACK TO recoverCompose_pvt;
3148: x_return_status := FND_API.G_RET_STS_ERROR;
3149: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3150: THEN
3151: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
3152: END IF;
3153: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

Line 3151: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

3147: ROLLBACK TO recoverCompose_pvt;
3148: x_return_status := FND_API.G_RET_STS_ERROR;
3149: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3150: THEN
3151: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
3152: END IF;
3153: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
3154: p_count => x_msg_count,
3155: p_data => x_msg_data);

Line 3153: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

3149: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3150: THEN
3151: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
3152: END IF;
3153: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
3154: p_count => x_msg_count,
3155: p_data => x_msg_data);
3156: END recoverCompose;
3157:

Line 3199: FND_MSG_PUB.initialize;

3195:
3196: -- Initialize message list if p_init_msg_list is set to TRUE.
3197: IF FND_API.to_Boolean( p_init_msg_list )
3198: THEN
3199: FND_MSG_PUB.initialize;
3200: END IF;
3201:
3202: -- Initialize API return status to SUCCESS
3203: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3240: FND_MSG_PUB.Count_And_Get

3236: IF FND_API.To_Boolean(p_commit) THEN
3237: COMMIT WORK;
3238: END IF;
3239: -- Standard callto get message count and if count is 1, get message info.
3240: FND_MSG_PUB.Count_And_Get
3241: ( p_encoded => FND_API.G_TRUE,
3242: p_count => x_msg_count,
3243: p_data => x_msg_data
3244: );

Line 3249: FND_MSG_PUB.Count_And_Get

3245: EXCEPTION
3246: WHEN FND_API.G_EXC_ERROR THEN
3247: ROLLBACK TO getAccountDelStatus_pvt;
3248: x_return_status := FND_API.G_RET_STS_ERROR ;
3249: FND_MSG_PUB.Count_And_Get
3250: ( p_encoded => FND_API.G_TRUE,
3251: p_count => x_msg_count,
3252: p_data => x_msg_data
3253: );

Line 3257: FND_MSG_PUB.Count_And_Get

3253: );
3254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3255: ROLLBACK TO getAccountDelStatus_pvt;
3256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3257: FND_MSG_PUB.Count_And_Get
3258: ( p_encoded => FND_API.G_TRUE,
3259: p_count => x_msg_count,
3260: p_data => x_msg_data
3261: );

Line 3265: IF FND_MSG_PUB.Check_Msg_Level

3261: );
3262: WHEN OTHERS THEN
3263: ROLLBACK TO getAccountDelStatus_pvt;
3264: x_return_status := FND_API.G_RET_STS_ERROR;
3265: IF FND_MSG_PUB.Check_Msg_Level
3266: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3267: THEN
3268: FND_MSG_PUB.Add_Exc_Msg
3269: ( G_PKG_NAME ,

Line 3266: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3262: WHEN OTHERS THEN
3263: ROLLBACK TO getAccountDelStatus_pvt;
3264: x_return_status := FND_API.G_RET_STS_ERROR;
3265: IF FND_MSG_PUB.Check_Msg_Level
3266: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3267: THEN
3268: FND_MSG_PUB.Add_Exc_Msg
3269: ( G_PKG_NAME ,
3270: l_api_name

Line 3268: FND_MSG_PUB.Add_Exc_Msg

3264: x_return_status := FND_API.G_RET_STS_ERROR;
3265: IF FND_MSG_PUB.Check_Msg_Level
3266: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3267: THEN
3268: FND_MSG_PUB.Add_Exc_Msg
3269: ( G_PKG_NAME ,
3270: l_api_name
3271: );
3272: END IF;

Line 3273: FND_MSG_PUB.Count_And_Get

3269: ( G_PKG_NAME ,
3270: l_api_name
3271: );
3272: END IF;
3273: FND_MSG_PUB.Count_And_Get
3274: ( p_encoded => FND_API.G_TRUE,
3275: p_count => x_msg_count ,
3276: p_data => x_msg_data
3277: );

Line 3351: FND_MSG_PUB.initialize;

3347:
3348: -- Initialize message list if p_init_msg_list is set to TRUE.
3349: IF FND_API.to_Boolean( p_init_msg_list )
3350: THEN
3351: FND_MSG_PUB.initialize;
3352: END IF;
3353:
3354: -- Initialize API return status to SUCCESS
3355: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3524: FND_MSG_PUB.Count_And_Get

3520: IF FND_API.To_Boolean(p_commit) THEN
3521: COMMIT WORK;
3522: END IF;
3523: -- Standard callto get message count and if count is 1, get message info.
3524: FND_MSG_PUB.Count_And_Get
3525: ( p_encoded => FND_API.G_TRUE,
3526: p_count => x_msg_count,
3527: p_data => x_msg_data
3528: );

Line 3533: FND_MSG_PUB.Count_And_Get(

3529: EXCEPTION
3530: WHEN FND_API.G_EXC_ERROR THEN
3531: ROLLBACK TO purgeOutbound_pvt;
3532: x_return_status := FND_API.G_RET_STS_ERROR ;
3533: FND_MSG_PUB.Count_And_Get(
3534: p_encoded => FND_API.G_TRUE,
3535: p_count => x_msg_count,
3536: p_data => x_msg_data);
3537:

Line 3541: FND_MSG_PUB.Count_And_Get(

3537:
3538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3539: ROLLBACK TO purgeOutbound_pvt;
3540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3541: FND_MSG_PUB.Count_And_Get(
3542: p_encoded => FND_API.G_TRUE,
3543: p_count => x_msg_count,
3544: p_data => x_msg_data);
3545:

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

3545:
3546: WHEN OTHERS THEN
3547: ROLLBACK TO purgeOutbound_pvt;
3548: x_return_status := FND_API.G_RET_STS_ERROR;
3549: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3550: THEN
3551: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
3552: END IF;
3553: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

Line 3551: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

3547: ROLLBACK TO purgeOutbound_pvt;
3548: x_return_status := FND_API.G_RET_STS_ERROR;
3549: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3550: THEN
3551: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
3552: END IF;
3553: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
3554: p_count => x_msg_count,
3555: p_data => x_msg_data);

Line 3553: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

3549: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3550: THEN
3551: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
3552: END IF;
3553: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
3554: p_count => x_msg_count,
3555: p_data => x_msg_data);
3556: END purgeOutbound;
3557:

Line 3646: FND_MSG_PUB.initialize;

3642:
3643: -- Initialize message list if p_init_msg_list is set to TRUE.
3644: IF FND_API.to_Boolean( p_init_msg_list )
3645: THEN
3646: FND_MSG_PUB.initialize;
3647: END IF;
3648:
3649: -- Initialize API return status to SUCCESS
3650: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3844: FND_MSG_PUB.Count_And_Get

3840: IF FND_API.To_Boolean(p_commit) THEN
3841: COMMIT WORK;
3842: END IF;
3843: -- Standard callto get message count and if count is 1, get message info.
3844: FND_MSG_PUB.Count_And_Get
3845: ( p_encoded => FND_API.G_TRUE,
3846: p_count => x_msg_count,
3847: p_data => x_msg_data
3848: );

Line 3853: FND_MSG_PUB.Count_And_Get(

3849: EXCEPTION
3850: WHEN FND_API.G_EXC_ERROR THEN
3851: ROLLBACK TO assignMsg_pvt;
3852: x_return_status := FND_API.G_RET_STS_ERROR ;
3853: FND_MSG_PUB.Count_And_Get(
3854: p_encoded => FND_API.G_TRUE,
3855: p_count => x_msg_count,
3856: p_data => x_msg_data);
3857:

Line 3861: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

3857:
3858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3859: ROLLBACK TO assignMsg_pvt;
3860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3861: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
3862: p_count => x_msg_count,
3863: p_data => x_msg_data);
3864:
3865: WHEN OTHERS THEN

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

3864:
3865: WHEN OTHERS THEN
3866: ROLLBACK TO assignMsg_pvt;
3867: x_return_status := FND_API.G_RET_STS_ERROR;
3868: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3869: THEN
3870: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
3871: END IF;
3872: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

Line 3870: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

3866: ROLLBACK TO assignMsg_pvt;
3867: x_return_status := FND_API.G_RET_STS_ERROR;
3868: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3869: THEN
3870: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
3871: END IF;
3872: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
3873: p_count => x_msg_count,
3874: p_data => x_msg_data);

Line 3872: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

3868: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3869: THEN
3870: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
3871: END IF;
3872: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
3873: p_count => x_msg_count,
3874: p_data => x_msg_data);
3875: END assignMsg;
3876:

Line 3952: FND_MSG_PUB.initialize;

3948:
3949: -- Initialize message list if p_init_msg_list is set to TRUE.
3950: IF FND_API.to_Boolean( p_init_msg_list )
3951: THEN
3952: FND_MSG_PUB.initialize;
3953: END IF;
3954:
3955: -- Initialize API return status to SUCCESS
3956: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4042: FND_MSG_PUB.ADD;

4038: WHEN IEM_NO_DATA THEN
4039: ROLLBACK TO queueToOutbox_pvt;
4040: x_return_status := FND_API.G_RET_STS_ERROR ;
4041: FND_MESSAGE.SET_NAME('IEM', 'IEM_MSG_INTERCEPTED');
4042: FND_MSG_PUB.ADD;
4043: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4044: p_count => x_msg_count,
4045: p_data => x_msg_data);
4046:

Line 4043: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

4039: ROLLBACK TO queueToOutbox_pvt;
4040: x_return_status := FND_API.G_RET_STS_ERROR ;
4041: FND_MESSAGE.SET_NAME('IEM', 'IEM_MSG_INTERCEPTED');
4042: FND_MSG_PUB.ADD;
4043: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4044: p_count => x_msg_count,
4045: p_data => x_msg_data);
4046:
4047: WHEN RTError THEN

Line 4050: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

4046:
4047: WHEN RTError THEN
4048: ROLLBACK TO queueToOutbox_pvt;
4049: x_return_status := FND_API.G_RET_STS_ERROR;
4050: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
4051: p_count => x_msg_count,
4052: p_data => x_msg_data);
4053:
4054: WHEN FND_API.G_EXC_ERROR THEN

Line 4057: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

4053:
4054: WHEN FND_API.G_EXC_ERROR THEN
4055: ROLLBACK TO queueToOutbox_pvt;
4056: x_return_status := FND_API.G_RET_STS_ERROR ;
4057: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4058: p_count => x_msg_count,
4059: p_data => x_msg_data);
4060:
4061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4064: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

4060:
4061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4062: ROLLBACK TO queueToOutbox_pvt;
4063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4064: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4065: p_count => x_msg_count,
4066: p_data => x_msg_data);
4067: WHEN OTHERS THEN
4068: ROLLBACK TO queueToOutbox_pvt;

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

4066: p_data => x_msg_data);
4067: WHEN OTHERS THEN
4068: ROLLBACK TO queueToOutbox_pvt;
4069: x_return_status := FND_API.G_RET_STS_ERROR;
4070: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4071: THEN
4072: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4073: END IF;
4074: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

Line 4072: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

4068: ROLLBACK TO queueToOutbox_pvt;
4069: x_return_status := FND_API.G_RET_STS_ERROR;
4070: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4071: THEN
4072: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4073: END IF;
4074: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
4075: p_count => x_msg_count,
4076: p_data => x_msg_data);

Line 4074: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

4070: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4071: THEN
4072: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4073: END IF;
4074: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
4075: p_count => x_msg_count,
4076: p_data => x_msg_data);
4077: END queueToOutbox;
4078:

Line 4164: FND_MSG_PUB.initialize;

4160:
4161: -- Initialize message list if p_init_msg_list is set to TRUE.
4162: IF FND_API.to_Boolean( p_init_msg_list )
4163: THEN
4164: FND_MSG_PUB.initialize;
4165: END IF;
4166:
4167: -- Initialize API return status to SUCCESS
4168: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4348: --FND_MSG_PUB.ADD;

4344: --WHEN IEM_NO_DATA THEN
4345: --ROLLBACK TO getNextOutboxItem_pvt;
4346: --x_return_status := FND_API.G_RET_STS_ERROR ;
4347: --FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_DATA');
4348: --FND_MSG_PUB.ADD;
4349: --FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4350: -- p_count => x_msg_count,
4351: -- p_data => x_msg_data);
4352: WHEN InteractnComplt THEN

Line 4349: --FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

4345: --ROLLBACK TO getNextOutboxItem_pvt;
4346: --x_return_status := FND_API.G_RET_STS_ERROR ;
4347: --FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_DATA');
4348: --FND_MSG_PUB.ADD;
4349: --FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4350: -- p_count => x_msg_count,
4351: -- p_data => x_msg_data);
4352: WHEN InteractnComplt THEN
4353: ROLLBACK TO getNextOutboxItem_pvt;

Line 4356: FND_MSG_PUB.ADD;

4352: WHEN InteractnComplt THEN
4353: ROLLBACK TO getNextOutboxItem_pvt;
4354: x_return_status := FND_API.G_RET_STS_ERROR ;
4355: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_RT_REC');
4356: FND_MSG_PUB.ADD;
4357: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4358: p_count => x_msg_count,
4359: p_data => x_msg_data);
4360: WHEN badAccountType THEN

Line 4357: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

4353: ROLLBACK TO getNextOutboxItem_pvt;
4354: x_return_status := FND_API.G_RET_STS_ERROR ;
4355: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_RT_REC');
4356: FND_MSG_PUB.ADD;
4357: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4358: p_count => x_msg_count,
4359: p_data => x_msg_data);
4360: WHEN badAccountType THEN
4361: ROLLBACK TO getNextOutboxItem_pvt;

Line 4364: FND_MSG_PUB.ADD;

4360: WHEN badAccountType THEN
4361: ROLLBACK TO getNextOutboxItem_pvt;
4362: x_return_status := FND_API.G_RET_STS_ERROR ;
4363: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_ACCOUNT_TYPE');
4364: FND_MSG_PUB.ADD;
4365: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4366: p_count => x_msg_count,
4367: p_data => x_msg_data);
4368: WHEN FND_API.G_EXC_ERROR THEN

Line 4365: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

4361: ROLLBACK TO getNextOutboxItem_pvt;
4362: x_return_status := FND_API.G_RET_STS_ERROR ;
4363: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_ACCOUNT_TYPE');
4364: FND_MSG_PUB.ADD;
4365: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4366: p_count => x_msg_count,
4367: p_data => x_msg_data);
4368: WHEN FND_API.G_EXC_ERROR THEN
4369: ROLLBACK TO getNextOutboxItem_pvt;

Line 4371: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

4367: p_data => x_msg_data);
4368: WHEN FND_API.G_EXC_ERROR THEN
4369: ROLLBACK TO getNextOutboxItem_pvt;
4370: x_return_status := FND_API.G_RET_STS_ERROR ;
4371: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4372: p_count => x_msg_count,
4373: p_data => x_msg_data);
4374:
4375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4378: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

4374:
4375: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4376: ROLLBACK TO getNextOutboxItem_pvt;
4377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4378: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4379: p_count => x_msg_count,
4380: p_data => x_msg_data);
4381:
4382: WHEN OTHERS THEN

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

4381:
4382: WHEN OTHERS THEN
4383: ROLLBACK TO getNextOutboxItem_pvt;
4384: x_return_status := FND_API.G_RET_STS_ERROR;
4385: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4386: THEN
4387: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4388: END IF;
4389: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

Line 4387: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

4383: ROLLBACK TO getNextOutboxItem_pvt;
4384: x_return_status := FND_API.G_RET_STS_ERROR;
4385: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4386: THEN
4387: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4388: END IF;
4389: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
4390: p_count => x_msg_count,
4391: p_data => x_msg_data);

Line 4389: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

4385: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4386: THEN
4387: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4388: END IF;
4389: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
4390: p_count => x_msg_count,
4391: p_data => x_msg_data);
4392: END getNextOutboxItem;
4393:

Line 4465: FND_MSG_PUB.initialize;

4461:
4462: -- Initialize message list if p_init_msg_list is set to TRUE.
4463: IF FND_API.to_Boolean( p_init_msg_list )
4464: THEN
4465: FND_MSG_PUB.initialize;
4466: END IF;
4467:
4468: -- Initialize API return status to SUCCESS
4469: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4600: -- FND_MSG_PUB.Count_And_Get

4596: IF FND_API.To_Boolean(p_commit) THEN
4597: COMMIT WORK;
4598: END IF;
4599: -- Standard callto get message count and if count is 1, get message info.
4600: -- FND_MSG_PUB.Count_And_Get
4601: -- ( p_encoded => FND_API.G_TRUE,
4602: -- p_count => x_msg_count,
4603: -- p_data => x_msg_data
4604: -- );

Line 4610: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

4606: EXCEPTION
4607: WHEN FND_API.G_EXC_ERROR THEN
4608: ROLLBACK TO createRTItem_pvt;
4609: x_return_status := FND_API.G_RET_STS_ERROR ;
4610: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4611: p_count => x_msg_count,
4612: p_data => x_msg_data);
4613:
4614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4617: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

4613:
4614: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4615: ROLLBACK TO createRTItem_pvt;
4616: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4617: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4618: p_count => x_msg_count,
4619: p_data => x_msg_data);
4620:
4621: WHEN OTHERS THEN

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

4620:
4621: WHEN OTHERS THEN
4622: ROLLBACK TO createRTItem_pvt;
4623: x_return_status := FND_API.G_RET_STS_ERROR;
4624: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4625: THEN
4626: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4627: END IF;
4628: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

Line 4626: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

4622: ROLLBACK TO createRTItem_pvt;
4623: x_return_status := FND_API.G_RET_STS_ERROR;
4624: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4625: THEN
4626: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4627: END IF;
4628: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
4629: p_count => x_msg_count,
4630: p_data => x_msg_data);

Line 4628: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

4624: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4625: THEN
4626: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4627: END IF;
4628: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
4629: p_count => x_msg_count,
4630: p_data => x_msg_data);
4631:
4632: END createRTItem;

Line 4680: FND_MSG_PUB.initialize;

4676:
4677: -- Initialize message list if p_init_msg_list is set to TRUE.
4678: IF FND_API.to_Boolean( p_init_msg_list )
4679: THEN
4680: FND_MSG_PUB.initialize;
4681: END IF;
4682:
4683: -- Initialize API return status to SUCCESS
4684: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4728: -- FND_MSG_PUB.Count_And_Get

4724: IF FND_API.To_Boolean(p_commit) THEN
4725: COMMIT WORK;
4726: END IF;
4727: -- Standard callto get message count and if count is 1, get message info.
4728: -- FND_MSG_PUB.Count_And_Get
4729: -- ( p_encoded => FND_API.G_TRUE,
4730: -- p_count => x_msg_count,
4731: -- p_data => x_msg_data
4732: -- );

Line 4741: FND_MSG_PUB.ADD;

4737: x_return_status := FND_API.G_RET_STS_ERROR ;
4738: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_AGENT_ACCT');
4739: FND_MESSAGE.SET_TOKEN('ARG1', l_user_name);
4740: FND_MESSAGE.SET_TOKEN('ARG2', to_char(p_email_account_id));
4741: FND_MSG_PUB.ADD;
4742: FND_MSG_PUB.Count_And_Get(
4743: p_encoded => FND_API.G_TRUE,
4744: p_count => x_msg_count,
4745: p_data => x_msg_data);

Line 4742: FND_MSG_PUB.Count_And_Get(

4738: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_AGENT_ACCT');
4739: FND_MESSAGE.SET_TOKEN('ARG1', l_user_name);
4740: FND_MESSAGE.SET_TOKEN('ARG2', to_char(p_email_account_id));
4741: FND_MSG_PUB.ADD;
4742: FND_MSG_PUB.Count_And_Get(
4743: p_encoded => FND_API.G_TRUE,
4744: p_count => x_msg_count,
4745: p_data => x_msg_data);
4746:

Line 4750: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

4746:
4747: WHEN FND_API.G_EXC_ERROR THEN
4748: ROLLBACK TO isAgentInboxClean_pvt;
4749: x_return_status := FND_API.G_RET_STS_ERROR ;
4750: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4751: p_count => x_msg_count,
4752: p_data => x_msg_data);
4753:
4754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4757: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

4753:
4754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4755: ROLLBACK TO isAgentInboxClean_pvt;
4756: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4757: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4758: p_count => x_msg_count,
4759: p_data => x_msg_data);
4760:
4761: WHEN OTHERS THEN

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

4760:
4761: WHEN OTHERS THEN
4762: ROLLBACK TO isAgentInboxClean_pvt;
4763: x_return_status := FND_API.G_RET_STS_ERROR;
4764: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4765: THEN
4766: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4767: END IF;
4768: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

Line 4766: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

4762: ROLLBACK TO isAgentInboxClean_pvt;
4763: x_return_status := FND_API.G_RET_STS_ERROR;
4764: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4765: THEN
4766: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4767: END IF;
4768: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
4769: p_count => x_msg_count,
4770: p_data => x_msg_data);

Line 4768: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

4764: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4765: THEN
4766: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4767: END IF;
4768: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
4769: p_count => x_msg_count,
4770: p_data => x_msg_data);
4771:
4772: END isAgentInboxClean;

Line 4813: FND_MSG_PUB.initialize;

4809:
4810: -- Initialize message list if p_init_msg_list is set to TRUE.
4811: IF FND_API.to_Boolean( p_init_msg_list )
4812: THEN
4813: FND_MSG_PUB.initialize;
4814: END IF;
4815:
4816: -- Initialize API return status to SUCCESS
4817: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4835: -- FND_MSG_PUB.Count_And_Get

4831: IF FND_API.To_Boolean(p_commit) THEN
4832: COMMIT WORK;
4833: END IF;
4834: -- Standard callto get message count and if count is 1, get message info.
4835: -- FND_MSG_PUB.Count_And_Get
4836: -- ( p_encoded => FND_API.G_TRUE,
4837: -- p_count => x_msg_count,
4838: -- p_data => x_msg_data
4839: -- );

Line 4845: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

4841: EXCEPTION
4842: WHEN FND_API.G_EXC_ERROR THEN
4843: ROLLBACK TO updateOutboundMessageID_pvt;
4844: x_return_status := FND_API.G_RET_STS_ERROR ;
4845: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4846: p_count => x_msg_count,
4847: p_data => x_msg_data);
4848:
4849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4852: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,

4848:
4849: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4850: ROLLBACK TO updateOutboundMessageID_pvt;
4851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4852: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4853: p_count => x_msg_count,
4854: p_data => x_msg_data);
4855:
4856: WHEN OTHERS THEN

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

4855:
4856: WHEN OTHERS THEN
4857: ROLLBACK TO updateOutboundMessageID_pvt;
4858: x_return_status := FND_API.G_RET_STS_ERROR;
4859: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4860: THEN
4861: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4862: END IF;
4863: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

Line 4861: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);

4857: ROLLBACK TO updateOutboundMessageID_pvt;
4858: x_return_status := FND_API.G_RET_STS_ERROR;
4859: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4860: THEN
4861: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4862: END IF;
4863: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
4864: p_count => x_msg_count,
4865: p_data => x_msg_data);

Line 4863: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

4859: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4860: THEN
4861: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4862: END IF;
4863: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
4864: p_count => x_msg_count,
4865: p_data => x_msg_data);
4866:
4867: END updateOutboundMessageID;