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 2065: FND_MSG_PUB.initialize;

2061:
2062: -- Initialize message list if p_init_msg_list is set to TRUE.
2063: IF FND_API.to_Boolean( p_init_msg_list )
2064: THEN
2065: FND_MSG_PUB.initialize;
2066: END IF;
2067:
2068: -- Initialize API return status to SUCCESS
2069: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3016: FND_MSG_PUB.ADD;

3012: WHEN badResourceId THEN
3013: ROLLBACK TO wrapUp_pvt;
3014: x_return_status := l_status;
3015: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_RESOURCE_ID');
3016: FND_MSG_PUB.ADD;
3017: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
3018: p_count => x_msg_count,
3019: p_data => x_msg_data);
3020: WHEN IHError THEN

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

3013: ROLLBACK TO wrapUp_pvt;
3014: x_return_status := l_status;
3015: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_RESOURCE_ID');
3016: FND_MSG_PUB.ADD;
3017: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
3018: p_count => x_msg_count,
3019: p_data => x_msg_data);
3020: WHEN IHError THEN
3021: ROLLBACK TO wrapUp_pvt;

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

3019: p_data => x_msg_data);
3020: WHEN IHError THEN
3021: ROLLBACK TO wrapUp_pvt;
3022: x_return_status := l_status;
3023: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
3024: p_count => x_msg_count,
3025: p_data => x_msg_data);
3026: WHEN RTError THEN
3027: ROLLBACK TO wrapUp_pvt;

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

3025: p_data => x_msg_data);
3026: WHEN RTError THEN
3027: ROLLBACK TO wrapUp_pvt;
3028: x_return_status := l_status;
3029: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
3030: p_count => x_msg_count,
3031: p_data => x_msg_data);
3032: WHEN MDTError THEN
3033: ROLLBACK TO wrapUp_pvt;

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

3031: p_data => x_msg_data);
3032: WHEN MDTError THEN
3033: ROLLBACK TO wrapUp_pvt;
3034: x_return_status := l_status;
3035: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
3036: p_count => x_msg_count,
3037: p_data => x_msg_data);
3038: WHEN FND_API.G_EXC_ERROR THEN
3039: ROLLBACK TO wrapUp_pvt;

Line 3041: FND_MSG_PUB.Count_And_Get(

3037: p_data => x_msg_data);
3038: WHEN FND_API.G_EXC_ERROR THEN
3039: ROLLBACK TO wrapUp_pvt;
3040: x_return_status := FND_API.G_RET_STS_ERROR ;
3041: FND_MSG_PUB.Count_And_Get(
3042: p_encoded => FND_API.G_TRUE,
3043: p_count => x_msg_count,
3044: p_data => x_msg_data);
3045:

Line 3049: FND_MSG_PUB.Count_And_Get(

3045:
3046: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3047: ROLLBACK TO wrapUp_pvt;
3048: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3049: FND_MSG_PUB.Count_And_Get(
3050: p_encoded => FND_API.G_TRUE,
3051: p_count => x_msg_count,
3052: p_data => x_msg_data);
3053: WHEN OTHERS THEN

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

3052: p_data => x_msg_data);
3053: WHEN OTHERS THEN
3054: ROLLBACK TO wrapUp_pvt;
3055: x_return_status := FND_API.G_RET_STS_ERROR;
3056: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3057: THEN
3058: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
3059: END IF;
3060: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

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

3054: ROLLBACK TO wrapUp_pvt;
3055: x_return_status := FND_API.G_RET_STS_ERROR;
3056: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3057: THEN
3058: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
3059: END IF;
3060: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
3061: p_count => x_msg_count,
3062: p_data => x_msg_data);

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

3056: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3057: THEN
3058: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
3059: END IF;
3060: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
3061: p_count => x_msg_count,
3062: p_data => x_msg_data);
3063: END wrapUp;
3064:

Line 3138: FND_MSG_PUB.initialize;

3134:
3135: -- Initialize message list if p_init_msg_list is set to TRUE.
3136: IF FND_API.to_Boolean( p_init_msg_list )
3137: THEN
3138: FND_MSG_PUB.initialize;
3139: END IF;
3140:
3141: -- Initialize API return status to SUCCESS
3142: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3188: FND_MSG_PUB.ADD;

3184: WHEN badAccountType THEN
3185: ROLLBACK TO recoverCompose_pvt;
3186: x_return_status := FND_API.G_RET_STS_ERROR ;
3187: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_ACCOUNT_TYPE');
3188: FND_MSG_PUB.ADD;
3189: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
3190: p_count => x_msg_count,
3191: p_data => x_msg_data);
3192: WHEN FND_API.G_EXC_ERROR THEN

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

3185: ROLLBACK TO recoverCompose_pvt;
3186: x_return_status := FND_API.G_RET_STS_ERROR ;
3187: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_ACCOUNT_TYPE');
3188: FND_MSG_PUB.ADD;
3189: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
3190: p_count => x_msg_count,
3191: p_data => x_msg_data);
3192: WHEN FND_API.G_EXC_ERROR THEN
3193: ROLLBACK TO recoverCompose_pvt;

Line 3195: FND_MSG_PUB.Count_And_Get(

3191: p_data => x_msg_data);
3192: WHEN FND_API.G_EXC_ERROR THEN
3193: ROLLBACK TO recoverCompose_pvt;
3194: x_return_status := FND_API.G_RET_STS_ERROR ;
3195: FND_MSG_PUB.Count_And_Get(
3196: p_encoded => FND_API.G_TRUE,
3197: p_count => x_msg_count,
3198: p_data => x_msg_data);
3199:

Line 3203: FND_MSG_PUB.Count_And_Get(

3199:
3200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3201: ROLLBACK TO recoverCompose_pvt;
3202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3203: FND_MSG_PUB.Count_And_Get(
3204: p_encoded => FND_API.G_TRUE,
3205: p_count => x_msg_count,
3206: p_data => x_msg_data);
3207:

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

3207:
3208: WHEN OTHERS THEN
3209: ROLLBACK TO recoverCompose_pvt;
3210: x_return_status := FND_API.G_RET_STS_ERROR;
3211: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3212: THEN
3213: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
3214: END IF;
3215: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

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

3209: ROLLBACK TO recoverCompose_pvt;
3210: x_return_status := FND_API.G_RET_STS_ERROR;
3211: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3212: THEN
3213: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
3214: END IF;
3215: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
3216: p_count => x_msg_count,
3217: p_data => x_msg_data);

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

3211: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3212: THEN
3213: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
3214: END IF;
3215: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
3216: p_count => x_msg_count,
3217: p_data => x_msg_data);
3218: END recoverCompose;
3219:

Line 3261: FND_MSG_PUB.initialize;

3257:
3258: -- Initialize message list if p_init_msg_list is set to TRUE.
3259: IF FND_API.to_Boolean( p_init_msg_list )
3260: THEN
3261: FND_MSG_PUB.initialize;
3262: END IF;
3263:
3264: -- Initialize API return status to SUCCESS
3265: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3302: FND_MSG_PUB.Count_And_Get

3298: IF FND_API.To_Boolean(p_commit) THEN
3299: COMMIT WORK;
3300: END IF;
3301: -- Standard callto get message count and if count is 1, get message info.
3302: FND_MSG_PUB.Count_And_Get
3303: ( p_encoded => FND_API.G_TRUE,
3304: p_count => x_msg_count,
3305: p_data => x_msg_data
3306: );

Line 3311: FND_MSG_PUB.Count_And_Get

3307: EXCEPTION
3308: WHEN FND_API.G_EXC_ERROR THEN
3309: ROLLBACK TO getAccountDelStatus_pvt;
3310: x_return_status := FND_API.G_RET_STS_ERROR ;
3311: FND_MSG_PUB.Count_And_Get
3312: ( p_encoded => FND_API.G_TRUE,
3313: p_count => x_msg_count,
3314: p_data => x_msg_data
3315: );

Line 3319: FND_MSG_PUB.Count_And_Get

3315: );
3316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3317: ROLLBACK TO getAccountDelStatus_pvt;
3318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3319: FND_MSG_PUB.Count_And_Get
3320: ( p_encoded => FND_API.G_TRUE,
3321: p_count => x_msg_count,
3322: p_data => x_msg_data
3323: );

Line 3327: IF FND_MSG_PUB.Check_Msg_Level

3323: );
3324: WHEN OTHERS THEN
3325: ROLLBACK TO getAccountDelStatus_pvt;
3326: x_return_status := FND_API.G_RET_STS_ERROR;
3327: IF FND_MSG_PUB.Check_Msg_Level
3328: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3329: THEN
3330: FND_MSG_PUB.Add_Exc_Msg
3331: ( G_PKG_NAME ,

Line 3328: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

3324: WHEN OTHERS THEN
3325: ROLLBACK TO getAccountDelStatus_pvt;
3326: x_return_status := FND_API.G_RET_STS_ERROR;
3327: IF FND_MSG_PUB.Check_Msg_Level
3328: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3329: THEN
3330: FND_MSG_PUB.Add_Exc_Msg
3331: ( G_PKG_NAME ,
3332: l_api_name

Line 3330: FND_MSG_PUB.Add_Exc_Msg

3326: x_return_status := FND_API.G_RET_STS_ERROR;
3327: IF FND_MSG_PUB.Check_Msg_Level
3328: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3329: THEN
3330: FND_MSG_PUB.Add_Exc_Msg
3331: ( G_PKG_NAME ,
3332: l_api_name
3333: );
3334: END IF;

Line 3335: FND_MSG_PUB.Count_And_Get

3331: ( G_PKG_NAME ,
3332: l_api_name
3333: );
3334: END IF;
3335: FND_MSG_PUB.Count_And_Get
3336: ( p_encoded => FND_API.G_TRUE,
3337: p_count => x_msg_count ,
3338: p_data => x_msg_data
3339: );

Line 3413: FND_MSG_PUB.initialize;

3409:
3410: -- Initialize message list if p_init_msg_list is set to TRUE.
3411: IF FND_API.to_Boolean( p_init_msg_list )
3412: THEN
3413: FND_MSG_PUB.initialize;
3414: END IF;
3415:
3416: -- Initialize API return status to SUCCESS
3417: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3586: FND_MSG_PUB.Count_And_Get

3582: IF FND_API.To_Boolean(p_commit) THEN
3583: COMMIT WORK;
3584: END IF;
3585: -- Standard callto get message count and if count is 1, get message info.
3586: FND_MSG_PUB.Count_And_Get
3587: ( p_encoded => FND_API.G_TRUE,
3588: p_count => x_msg_count,
3589: p_data => x_msg_data
3590: );

Line 3595: FND_MSG_PUB.Count_And_Get(

3591: EXCEPTION
3592: WHEN FND_API.G_EXC_ERROR THEN
3593: ROLLBACK TO purgeOutbound_pvt;
3594: x_return_status := FND_API.G_RET_STS_ERROR ;
3595: FND_MSG_PUB.Count_And_Get(
3596: p_encoded => FND_API.G_TRUE,
3597: p_count => x_msg_count,
3598: p_data => x_msg_data);
3599:

Line 3603: FND_MSG_PUB.Count_And_Get(

3599:
3600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3601: ROLLBACK TO purgeOutbound_pvt;
3602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3603: FND_MSG_PUB.Count_And_Get(
3604: p_encoded => FND_API.G_TRUE,
3605: p_count => x_msg_count,
3606: p_data => x_msg_data);
3607:

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

3607:
3608: WHEN OTHERS THEN
3609: ROLLBACK TO purgeOutbound_pvt;
3610: x_return_status := FND_API.G_RET_STS_ERROR;
3611: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3612: THEN
3613: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
3614: END IF;
3615: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

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

3609: ROLLBACK TO purgeOutbound_pvt;
3610: x_return_status := FND_API.G_RET_STS_ERROR;
3611: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3612: THEN
3613: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
3614: END IF;
3615: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
3616: p_count => x_msg_count,
3617: p_data => x_msg_data);

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

3611: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3612: THEN
3613: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
3614: END IF;
3615: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
3616: p_count => x_msg_count,
3617: p_data => x_msg_data);
3618: END purgeOutbound;
3619:

Line 3710: FND_MSG_PUB.initialize;

3706:
3707: -- Initialize message list if p_init_msg_list is set to TRUE.
3708: IF FND_API.to_Boolean( p_init_msg_list )
3709: THEN
3710: FND_MSG_PUB.initialize;
3711: END IF;
3712:
3713: -- Initialize API return status to SUCCESS
3714: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3919: FND_MSG_PUB.Count_And_Get

3915: IF FND_API.To_Boolean(p_commit) THEN
3916: COMMIT WORK;
3917: END IF;
3918: -- Standard callto get message count and if count is 1, get message info.
3919: FND_MSG_PUB.Count_And_Get
3920: ( p_encoded => FND_API.G_TRUE,
3921: p_count => x_msg_count,
3922: p_data => x_msg_data
3923: );

Line 3928: FND_MSG_PUB.Count_And_Get(

3924: EXCEPTION
3925: WHEN FND_API.G_EXC_ERROR THEN
3926: ROLLBACK TO assignMsg_pvt;
3927: x_return_status := FND_API.G_RET_STS_ERROR ;
3928: FND_MSG_PUB.Count_And_Get(
3929: p_encoded => FND_API.G_TRUE,
3930: p_count => x_msg_count,
3931: p_data => x_msg_data);
3932:

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

3932:
3933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3934: ROLLBACK TO assignMsg_pvt;
3935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3936: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
3937: p_count => x_msg_count,
3938: p_data => x_msg_data);
3939:
3940: WHEN OTHERS THEN

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

3939:
3940: WHEN OTHERS THEN
3941: ROLLBACK TO assignMsg_pvt;
3942: x_return_status := FND_API.G_RET_STS_ERROR;
3943: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3944: THEN
3945: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
3946: END IF;
3947: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

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

3941: ROLLBACK TO assignMsg_pvt;
3942: x_return_status := FND_API.G_RET_STS_ERROR;
3943: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3944: THEN
3945: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
3946: END IF;
3947: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
3948: p_count => x_msg_count,
3949: p_data => x_msg_data);

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

3943: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
3944: THEN
3945: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
3946: END IF;
3947: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
3948: p_count => x_msg_count,
3949: p_data => x_msg_data);
3950: END assignMsg;
3951:

Line 4027: FND_MSG_PUB.initialize;

4023:
4024: -- Initialize message list if p_init_msg_list is set to TRUE.
4025: IF FND_API.to_Boolean( p_init_msg_list )
4026: THEN
4027: FND_MSG_PUB.initialize;
4028: END IF;
4029:
4030: -- Initialize API return status to SUCCESS
4031: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4117: FND_MSG_PUB.ADD;

4113: WHEN IEM_NO_DATA THEN
4114: ROLLBACK TO queueToOutbox_pvt;
4115: x_return_status := FND_API.G_RET_STS_ERROR ;
4116: FND_MESSAGE.SET_NAME('IEM', 'IEM_MSG_INTERCEPTED');
4117: FND_MSG_PUB.ADD;
4118: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4119: p_count => x_msg_count,
4120: p_data => x_msg_data);
4121:

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

4114: ROLLBACK TO queueToOutbox_pvt;
4115: x_return_status := FND_API.G_RET_STS_ERROR ;
4116: FND_MESSAGE.SET_NAME('IEM', 'IEM_MSG_INTERCEPTED');
4117: FND_MSG_PUB.ADD;
4118: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4119: p_count => x_msg_count,
4120: p_data => x_msg_data);
4121:
4122: WHEN RTError THEN

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

4121:
4122: WHEN RTError THEN
4123: ROLLBACK TO queueToOutbox_pvt;
4124: x_return_status := FND_API.G_RET_STS_ERROR;
4125: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
4126: p_count => x_msg_count,
4127: p_data => x_msg_data);
4128:
4129: WHEN FND_API.G_EXC_ERROR THEN

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

4128:
4129: WHEN FND_API.G_EXC_ERROR THEN
4130: ROLLBACK TO queueToOutbox_pvt;
4131: x_return_status := FND_API.G_RET_STS_ERROR ;
4132: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4133: p_count => x_msg_count,
4134: p_data => x_msg_data);
4135:
4136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

4135:
4136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4137: ROLLBACK TO queueToOutbox_pvt;
4138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4139: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4140: p_count => x_msg_count,
4141: p_data => x_msg_data);
4142: WHEN OTHERS THEN
4143: ROLLBACK TO queueToOutbox_pvt;

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

4141: p_data => x_msg_data);
4142: WHEN OTHERS THEN
4143: ROLLBACK TO queueToOutbox_pvt;
4144: x_return_status := FND_API.G_RET_STS_ERROR;
4145: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4146: THEN
4147: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4148: END IF;
4149: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

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

4143: ROLLBACK TO queueToOutbox_pvt;
4144: x_return_status := FND_API.G_RET_STS_ERROR;
4145: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4146: THEN
4147: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4148: END IF;
4149: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
4150: p_count => x_msg_count,
4151: p_data => x_msg_data);

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

4145: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4146: THEN
4147: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4148: END IF;
4149: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
4150: p_count => x_msg_count,
4151: p_data => x_msg_data);
4152: END queueToOutbox;
4153:

Line 4239: FND_MSG_PUB.initialize;

4235:
4236: -- Initialize message list if p_init_msg_list is set to TRUE.
4237: IF FND_API.to_Boolean( p_init_msg_list )
4238: THEN
4239: FND_MSG_PUB.initialize;
4240: END IF;
4241:
4242: -- Initialize API return status to SUCCESS
4243: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4423: --FND_MSG_PUB.ADD;

4419: --WHEN IEM_NO_DATA THEN
4420: --ROLLBACK TO getNextOutboxItem_pvt;
4421: --x_return_status := FND_API.G_RET_STS_ERROR ;
4422: --FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_DATA');
4423: --FND_MSG_PUB.ADD;
4424: --FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4425: -- p_count => x_msg_count,
4426: -- p_data => x_msg_data);
4427: WHEN InteractnComplt THEN

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

4420: --ROLLBACK TO getNextOutboxItem_pvt;
4421: --x_return_status := FND_API.G_RET_STS_ERROR ;
4422: --FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_DATA');
4423: --FND_MSG_PUB.ADD;
4424: --FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4425: -- p_count => x_msg_count,
4426: -- p_data => x_msg_data);
4427: WHEN InteractnComplt THEN
4428: ROLLBACK TO getNextOutboxItem_pvt;

Line 4431: FND_MSG_PUB.ADD;

4427: WHEN InteractnComplt THEN
4428: ROLLBACK TO getNextOutboxItem_pvt;
4429: x_return_status := FND_API.G_RET_STS_ERROR ;
4430: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_RT_REC');
4431: FND_MSG_PUB.ADD;
4432: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4433: p_count => x_msg_count,
4434: p_data => x_msg_data);
4435: WHEN badAccountType THEN

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

4428: ROLLBACK TO getNextOutboxItem_pvt;
4429: x_return_status := FND_API.G_RET_STS_ERROR ;
4430: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_RT_REC');
4431: FND_MSG_PUB.ADD;
4432: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4433: p_count => x_msg_count,
4434: p_data => x_msg_data);
4435: WHEN badAccountType THEN
4436: ROLLBACK TO getNextOutboxItem_pvt;

Line 4439: FND_MSG_PUB.ADD;

4435: WHEN badAccountType THEN
4436: ROLLBACK TO getNextOutboxItem_pvt;
4437: x_return_status := FND_API.G_RET_STS_ERROR ;
4438: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_ACCOUNT_TYPE');
4439: FND_MSG_PUB.ADD;
4440: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4441: p_count => x_msg_count,
4442: p_data => x_msg_data);
4443: WHEN FND_API.G_EXC_ERROR THEN

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

4436: ROLLBACK TO getNextOutboxItem_pvt;
4437: x_return_status := FND_API.G_RET_STS_ERROR ;
4438: FND_MESSAGE.SET_NAME('IEM', 'IEM_BAD_ACCOUNT_TYPE');
4439: FND_MSG_PUB.ADD;
4440: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4441: p_count => x_msg_count,
4442: p_data => x_msg_data);
4443: WHEN FND_API.G_EXC_ERROR THEN
4444: ROLLBACK TO getNextOutboxItem_pvt;

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

4442: p_data => x_msg_data);
4443: WHEN FND_API.G_EXC_ERROR THEN
4444: ROLLBACK TO getNextOutboxItem_pvt;
4445: x_return_status := FND_API.G_RET_STS_ERROR ;
4446: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4447: p_count => x_msg_count,
4448: p_data => x_msg_data);
4449:
4450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

4449:
4450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4451: ROLLBACK TO getNextOutboxItem_pvt;
4452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4453: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4454: p_count => x_msg_count,
4455: p_data => x_msg_data);
4456:
4457: WHEN OTHERS THEN

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

4456:
4457: WHEN OTHERS THEN
4458: ROLLBACK TO getNextOutboxItem_pvt;
4459: x_return_status := FND_API.G_RET_STS_ERROR;
4460: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4461: THEN
4462: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4463: END IF;
4464: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

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

4458: ROLLBACK TO getNextOutboxItem_pvt;
4459: x_return_status := FND_API.G_RET_STS_ERROR;
4460: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4461: THEN
4462: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4463: END IF;
4464: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
4465: p_count => x_msg_count,
4466: p_data => x_msg_data);

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

4460: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4461: THEN
4462: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4463: END IF;
4464: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
4465: p_count => x_msg_count,
4466: p_data => x_msg_data);
4467: END getNextOutboxItem;
4468:

Line 4540: FND_MSG_PUB.initialize;

4536:
4537: -- Initialize message list if p_init_msg_list is set to TRUE.
4538: IF FND_API.to_Boolean( p_init_msg_list )
4539: THEN
4540: FND_MSG_PUB.initialize;
4541: END IF;
4542:
4543: -- Initialize API return status to SUCCESS
4544: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4675: -- FND_MSG_PUB.Count_And_Get

4671: IF FND_API.To_Boolean(p_commit) THEN
4672: COMMIT WORK;
4673: END IF;
4674: -- Standard callto get message count and if count is 1, get message info.
4675: -- FND_MSG_PUB.Count_And_Get
4676: -- ( p_encoded => FND_API.G_TRUE,
4677: -- p_count => x_msg_count,
4678: -- p_data => x_msg_data
4679: -- );

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

4681: EXCEPTION
4682: WHEN FND_API.G_EXC_ERROR THEN
4683: ROLLBACK TO createRTItem_pvt;
4684: x_return_status := FND_API.G_RET_STS_ERROR ;
4685: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4686: p_count => x_msg_count,
4687: p_data => x_msg_data);
4688:
4689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

4688:
4689: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4690: ROLLBACK TO createRTItem_pvt;
4691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4692: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4693: p_count => x_msg_count,
4694: p_data => x_msg_data);
4695:
4696: WHEN OTHERS THEN

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

4695:
4696: WHEN OTHERS THEN
4697: ROLLBACK TO createRTItem_pvt;
4698: x_return_status := FND_API.G_RET_STS_ERROR;
4699: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4700: THEN
4701: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4702: END IF;
4703: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

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

4697: ROLLBACK TO createRTItem_pvt;
4698: x_return_status := FND_API.G_RET_STS_ERROR;
4699: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4700: THEN
4701: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4702: END IF;
4703: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
4704: p_count => x_msg_count,
4705: p_data => x_msg_data);

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

4699: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4700: THEN
4701: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4702: END IF;
4703: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
4704: p_count => x_msg_count,
4705: p_data => x_msg_data);
4706:
4707: END createRTItem;

Line 4755: FND_MSG_PUB.initialize;

4751:
4752: -- Initialize message list if p_init_msg_list is set to TRUE.
4753: IF FND_API.to_Boolean( p_init_msg_list )
4754: THEN
4755: FND_MSG_PUB.initialize;
4756: END IF;
4757:
4758: -- Initialize API return status to SUCCESS
4759: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4803: -- FND_MSG_PUB.Count_And_Get

4799: IF FND_API.To_Boolean(p_commit) THEN
4800: COMMIT WORK;
4801: END IF;
4802: -- Standard callto get message count and if count is 1, get message info.
4803: -- FND_MSG_PUB.Count_And_Get
4804: -- ( p_encoded => FND_API.G_TRUE,
4805: -- p_count => x_msg_count,
4806: -- p_data => x_msg_data
4807: -- );

Line 4816: FND_MSG_PUB.ADD;

4812: x_return_status := FND_API.G_RET_STS_ERROR ;
4813: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_AGENT_ACCT');
4814: FND_MESSAGE.SET_TOKEN('ARG1', l_user_name);
4815: FND_MESSAGE.SET_TOKEN('ARG2', to_char(p_email_account_id));
4816: FND_MSG_PUB.ADD;
4817: FND_MSG_PUB.Count_And_Get(
4818: p_encoded => FND_API.G_TRUE,
4819: p_count => x_msg_count,
4820: p_data => x_msg_data);

Line 4817: FND_MSG_PUB.Count_And_Get(

4813: FND_MESSAGE.SET_NAME('IEM', 'IEM_NO_AGENT_ACCT');
4814: FND_MESSAGE.SET_TOKEN('ARG1', l_user_name);
4815: FND_MESSAGE.SET_TOKEN('ARG2', to_char(p_email_account_id));
4816: FND_MSG_PUB.ADD;
4817: FND_MSG_PUB.Count_And_Get(
4818: p_encoded => FND_API.G_TRUE,
4819: p_count => x_msg_count,
4820: p_data => x_msg_data);
4821:

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

4821:
4822: WHEN FND_API.G_EXC_ERROR THEN
4823: ROLLBACK TO isAgentInboxClean_pvt;
4824: x_return_status := FND_API.G_RET_STS_ERROR ;
4825: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4826: p_count => x_msg_count,
4827: p_data => x_msg_data);
4828:
4829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

4828:
4829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4830: ROLLBACK TO isAgentInboxClean_pvt;
4831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4832: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4833: p_count => x_msg_count,
4834: p_data => x_msg_data);
4835:
4836: WHEN OTHERS THEN

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

4835:
4836: WHEN OTHERS THEN
4837: ROLLBACK TO isAgentInboxClean_pvt;
4838: x_return_status := FND_API.G_RET_STS_ERROR;
4839: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4840: THEN
4841: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4842: END IF;
4843: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

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

4837: ROLLBACK TO isAgentInboxClean_pvt;
4838: x_return_status := FND_API.G_RET_STS_ERROR;
4839: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4840: THEN
4841: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4842: END IF;
4843: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
4844: p_count => x_msg_count,
4845: p_data => x_msg_data);

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

4839: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4840: THEN
4841: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4842: END IF;
4843: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
4844: p_count => x_msg_count,
4845: p_data => x_msg_data);
4846:
4847: END isAgentInboxClean;

Line 4888: FND_MSG_PUB.initialize;

4884:
4885: -- Initialize message list if p_init_msg_list is set to TRUE.
4886: IF FND_API.to_Boolean( p_init_msg_list )
4887: THEN
4888: FND_MSG_PUB.initialize;
4889: END IF;
4890:
4891: -- Initialize API return status to SUCCESS
4892: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4910: -- FND_MSG_PUB.Count_And_Get

4906: IF FND_API.To_Boolean(p_commit) THEN
4907: COMMIT WORK;
4908: END IF;
4909: -- Standard callto get message count and if count is 1, get message info.
4910: -- FND_MSG_PUB.Count_And_Get
4911: -- ( p_encoded => FND_API.G_TRUE,
4912: -- p_count => x_msg_count,
4913: -- p_data => x_msg_data
4914: -- );

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

4916: EXCEPTION
4917: WHEN FND_API.G_EXC_ERROR THEN
4918: ROLLBACK TO updateOutboundMessageID_pvt;
4919: x_return_status := FND_API.G_RET_STS_ERROR ;
4920: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4921: p_count => x_msg_count,
4922: p_data => x_msg_data);
4923:
4924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

4923:
4924: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4925: ROLLBACK TO updateOutboundMessageID_pvt;
4926: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4927: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_TRUE,
4928: p_count => x_msg_count,
4929: p_data => x_msg_data);
4930:
4931: WHEN OTHERS THEN

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

4930:
4931: WHEN OTHERS THEN
4932: ROLLBACK TO updateOutboundMessageID_pvt;
4933: x_return_status := FND_API.G_RET_STS_ERROR;
4934: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4935: THEN
4936: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4937: END IF;
4938: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,

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

4932: ROLLBACK TO updateOutboundMessageID_pvt;
4933: x_return_status := FND_API.G_RET_STS_ERROR;
4934: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4935: THEN
4936: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4937: END IF;
4938: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
4939: p_count => x_msg_count,
4940: p_data => x_msg_data);

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

4934: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4935: THEN
4936: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
4937: END IF;
4938: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_TRUE,
4939: p_count => x_msg_count,
4940: p_data => x_msg_data);
4941:
4942: END updateOutboundMessageID;