[Home] [Help]
96: l_lead_id :=null;
97:
98:
99: -- Standard call to check for call compatibility.
100: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
101: 1.0,
102: l_api_name,
103: G_PKG_NAME)
104: THEN
101: 1.0,
102: l_api_name,
103: G_PKG_NAME)
104: THEN
105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
106: END IF;
107:
108: -- Initialize message list if p_init_msg_list is set to TRUE.
109: IF FND_API.to_Boolean( p_init_msg_list )
105: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
106: END IF;
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:
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;
116:
117: -----------------------Code------------------------
118: /* dbms_output.put_line('In getWork ');
119: dbms_output.put_line('In getWork : Email Account ID '||p_email_account_id);
140: x_msg_count => l_msg_count,
141: x_msg_data => l_msg_data);
142:
143: -- Check return status; Proceed on success Or report back in case of error.
144: IF (l_status = FND_API.G_RET_STS_SUCCESS) THEN
145: -- Success.
146: -- Get the name of the route classification from the ID returned above.
147: -- This is the name of the folder where the inbound message exists on the
148: -- master account.
261:
262: END IF;
263: -------------------End Code------------------------
264: -- Standard Check Of p_commit.
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
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: );
274: EXCEPTION
271: p_count => x_msg_count,
272: p_data => x_msg_data
273: );
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,
273: );
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);
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:
283: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
279: p_encoded => FND_API.G_TRUE,
280: p_count => x_msg_count,
281: p_data => x_msg_data);
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,
281: p_data => x_msg_data);
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);
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:
291: WHEN OTHERS THEN
289: p_data => x_msg_data);
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;
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:
396: l_customer_id := 0;
397: l_found := 0;
398:
399: -- Standard call to check for call compatibility.
400: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
401: 1.0,
402: l_api_name,
403: G_PKG_NAME)
404: THEN
401: 1.0,
402: l_api_name,
403: G_PKG_NAME)
404: THEN
405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
406: END IF;
407:
408: -- Initialize message list if p_init_msg_list is set to TRUE.
409: IF FND_API.to_Boolean( p_init_msg_list )
405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
406: END IF;
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:
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;
416:
417: -----------------------Code------------------------
418: -- Do a query anyway to get media details of the specified rt_media_item.
419: BEGIN
523: -------------------End Code------------------------
524: EXCEPTION
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,
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
535: ROLLBACK TO getMediaDetails_pvt;
532: p_count => x_msg_count,
533: p_data => x_msg_data);
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,
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;
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;
544: x_return_status := FND_API.G_RET_STS_ERROR ;
545: FND_MSG_PUB.Count_And_Get(
546: 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;
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);
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:
550: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: p_encoded => FND_API.G_TRUE,
547: p_count => x_msg_count,
548: p_data => x_msg_data);
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,
548: p_data => x_msg_data);
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);
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:
558: WHEN OTHERS THEN
556: p_data => x_msg_data);
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;
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:
641: l_oes_id := 0;
642: l_customer_id := 0;
643:
644: -- Standard call to check for call compatibility.
645: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
646: 1.0,
647: l_api_name,
648: G_PKG_NAME)
649: THEN
646: 1.0,
647: l_api_name,
648: G_PKG_NAME)
649: THEN
650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
651: END IF;
652:
653: -- Initialize message list if p_init_msg_list is set to TRUE.
654: IF FND_API.to_Boolean( p_init_msg_list )
650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
651: END IF;
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:
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;
661:
662: -----------------------Code------------------------
663: BEGIN
664: -- Account id is always agent_account_id. Do not pass email_account_ids
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
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
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
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,
729: p_data => x_msg_data);
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);
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:
739: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
735: p_encoded => FND_API.G_TRUE,
736: p_count => x_msg_count,
737: p_data => x_msg_data);
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,
737: p_data => x_msg_data);
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);
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:
747: WHEN OTHERS THEN
745: p_data => x_msg_data);
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;
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;
868: l_customer_id := 0;
869:
870:
871: -- Standard call to check for call compatibility.
872: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
873: 1.0,
874: l_api_name,
875: G_PKG_NAME)
876: THEN
873: 1.0,
874: l_api_name,
875: G_PKG_NAME)
876: THEN
877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
878: END IF;
879:
880: -- Initialize message list if p_init_msg_list is set to TRUE.
881: IF FND_API.to_Boolean( p_init_msg_list )
877: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
878: END IF;
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:
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;
888:
889: -----------------------Code------------------------
890:
891: -- Standard Check Of p_commit.
888:
889: -----------------------Code------------------------
890:
891: -- Standard Check Of p_commit.
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
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: );
901:
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
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
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,
909: p_data => x_msg_data);
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);
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:
919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
915: p_encoded => FND_API.G_TRUE,
916: p_count => x_msg_count,
917: p_data => x_msg_data);
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,
917: p_data => x_msg_data);
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);
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:
927: WHEN OTHERS THEN
925: p_data => x_msg_data);
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;
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: */
1013: l_email_type := '';
1014: l_ib_media_id := -1;
1015:
1016: -- Standard call to check for call compatibility.
1017: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1018: 1.0,
1019: l_api_name,
1020: G_PKG_NAME)
1021: THEN
1018: 1.0,
1019: l_api_name,
1020: G_PKG_NAME)
1021: THEN
1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1023: END IF;
1024:
1025: -- Initialize message list if p_init_msg_list is set to TRUE.
1026: IF FND_API.to_Boolean( p_init_msg_list )
1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1023: END IF;
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:
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;
1033:
1034: -----------------------Code------------------------
1035: l_db_server_id := -1;
1036: -- Detemine the type of email account, master or agent
1087: x_msg_data => l_msg_data,
1088: p_media_rec => l_media_rec,
1089: x_media_id => l_media_id
1090: );
1091: IF ( l_status = FND_API.G_RET_STS_SUCCESS ) THEN
1092: l_ob_media_id := l_media_id;
1093: ELSE
1094: l_ob_media_id := null;
1095: END IF;
1093: ELSE
1094: l_ob_media_id := null;
1095: END IF;
1096:
1097: IF (p_rt_media_item_id = G_NUM_NOP2 OR p_rt_media_item_id = fnd_api.g_miss_num
1098: OR p_rt_media_item_id is null) THEN
1099:
1100: -- Pure outbound message as there is no associated rt_media_item_id.
1101: -- Insert into rt tables.
1178: x_rt_media_item_id := l_m_sequence;
1179: x_rt_interaction_id := l_rt_interaction_id;
1180: ELSE
1181: -- Outbound Media Item. Cannot create a reply.
1182: x_return_status := FND_API.G_RET_STS_ERROR ;
1183: l_ib_media_id := -1;
1184: END IF;
1185: END IF;
1186:
1184: END IF;
1185: END IF;
1186:
1187: -- Write statistics data
1188: if ( l_ob_media_id is not null AND x_return_status = FND_API.G_RET_STS_SUCCESS) then
1189: IEM_MSG_STAT_PUB.createMSGStat(
1190: p_api_version_number => 1.0,
1191: p_init_msg_list => fnd_api.g_false,
1192: p_commit => fnd_api.g_false,
1187: -- Write statistics data
1188: if ( l_ob_media_id is not null AND x_return_status = FND_API.G_RET_STS_SUCCESS) then
1189: IEM_MSG_STAT_PUB.createMSGStat(
1190: p_api_version_number => 1.0,
1191: p_init_msg_list => fnd_api.g_false,
1192: p_commit => fnd_api.g_false,
1193: p_outBoundMediaID => l_ob_media_id,
1194: p_inBoundMediaID => l_ib_media_id,
1195: x_return_status => l_status,
1188: if ( l_ob_media_id is not null AND x_return_status = FND_API.G_RET_STS_SUCCESS) then
1189: IEM_MSG_STAT_PUB.createMSGStat(
1190: p_api_version_number => 1.0,
1191: p_init_msg_list => fnd_api.g_false,
1192: p_commit => fnd_api.g_false,
1193: p_outBoundMediaID => l_ob_media_id,
1194: p_inBoundMediaID => l_ib_media_id,
1195: x_return_status => l_status,
1196: x_msg_count => l_msg_count,
1200: -------------------End Code------------------------
1201: EXCEPTION
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,
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
1209: p_data => x_msg_data);
1210:
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,
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
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
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,
1218: p_data => x_msg_data);
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);
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:
1228: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1224: p_encoded => FND_API.G_TRUE,
1225: p_count => x_msg_count,
1226: p_data => x_msg_data);
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,
1226: p_data => x_msg_data);
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);
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:
1236: WHEN OTHERS THEN
1234: p_data => x_msg_data);
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;
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:
1338: l_ib_media_id := -1;
1339: l_ob_media_id := null;
1340:
1341: -- Standard call to check for call compatibility.
1342: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1343: 1.0,
1344: l_api_name,
1345: G_PKG_NAME)
1346: THEN
1343: 1.0,
1344: l_api_name,
1345: G_PKG_NAME)
1346: THEN
1347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1348: END IF;
1349:
1350: -- Initialize message list if p_init_msg_list is set to TRUE.
1351: IF FND_API.to_Boolean( p_init_msg_list )
1347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1348: END IF;
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:
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;
1358:
1359: -----------------------Code------------------------
1360: /* dbms_output.put_line('In getWork ');
1361: dbms_output.put_line('In getWork : Resource ID '||p_resource_id);
1477: l_version := p_version + 1;
1478: end if;
1479:
1480: -- BEGIN
1481: if ( p_edit_mode is null OR p_edit_mode = fnd_api.g_miss_char ) then
1482: l_edit_mode := G_CHAR_NOP;
1483: else
1484: l_edit_mode := p_edit_mode;
1485: end if;
1574: exception
1575: when others then
1576: null;
1577: end;
1578: if (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_ob_media_id is not null) then
1579:
1580: if ( p_status = 'V' OR p_status = 'C') then
1581: l_rt_media_item_id_ib := null;
1582: begin
1590: end if;
1591: if ( p_status = 'V') then
1592: IEM_MSG_STAT_PUB.saveMSGStat(
1593: p_api_version_number => 1.0,
1594: p_init_msg_list => fnd_api.g_false,
1595: p_commit => fnd_api.g_false,
1596: p_outBoundMediaID => l_ob_media_id,
1597: p_inBoundMediaID => nvl(l_ib_media_id, -1),
1598: x_return_status => l_ret_status,
1591: if ( p_status = 'V') then
1592: IEM_MSG_STAT_PUB.saveMSGStat(
1593: p_api_version_number => 1.0,
1594: p_init_msg_list => fnd_api.g_false,
1595: p_commit => fnd_api.g_false,
1596: p_outBoundMediaID => l_ob_media_id,
1597: p_inBoundMediaID => nvl(l_ib_media_id, -1),
1598: x_return_status => l_ret_status,
1599: x_msg_count => l_count,
1603: if ( p_status = 'C') then
1604: if ( l_rt_media_item_id_ib is null ) then -- pure outbound
1605: IEM_MSG_STAT_PUB.deleteMSGStat(
1606: p_api_version_number => 1.0,
1607: p_init_msg_list => fnd_api.g_false,
1608: p_commit => fnd_api.g_false,
1609: p_outBoundMediaID => l_ob_media_id,
1610: p_inBoundMediaID => -1,
1611: x_return_status => l_ret_status,
1604: if ( l_rt_media_item_id_ib is null ) then -- pure outbound
1605: IEM_MSG_STAT_PUB.deleteMSGStat(
1606: p_api_version_number => 1.0,
1607: p_init_msg_list => fnd_api.g_false,
1608: p_commit => fnd_api.g_false,
1609: p_outBoundMediaID => l_ob_media_id,
1610: p_inBoundMediaID => -1,
1611: x_return_status => l_ret_status,
1612: x_msg_count => l_count,
1614: );
1615: else
1616: IEM_MSG_STAT_PUB.cancelMSGStat(
1617: p_api_version_number => 1.0,
1618: p_init_msg_list => fnd_api.g_false,
1619: p_commit => fnd_api.g_false,
1620: p_outBoundMediaID => l_ob_media_id,
1621: p_inBoundMediaID => nvl(l_ib_media_id, -1),
1622: x_return_status => l_ret_status,
1615: else
1616: IEM_MSG_STAT_PUB.cancelMSGStat(
1617: p_api_version_number => 1.0,
1618: p_init_msg_list => fnd_api.g_false,
1619: p_commit => fnd_api.g_false,
1620: p_outBoundMediaID => l_ob_media_id,
1621: p_inBoundMediaID => nvl(l_ib_media_id, -1),
1622: x_return_status => l_ret_status,
1623: x_msg_count => l_count,
1650:
1651: EXCEPTION
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,
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;
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;
1662: x_return_status := FND_API.G_RET_STS_ERROR ;
1663: FND_MSG_PUB.Count_And_Get(
1664: 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;
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);
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:
1668: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1664: p_encoded => FND_API.G_TRUE,
1665: p_count => x_msg_count,
1666: p_data => x_msg_data);
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,
1666: p_data => x_msg_data);
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);
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:
1676: WHEN OTHERS THEN
1674: p_data => x_msg_data);
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;
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:
1751: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1752: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
1753:
1754: -- Standard call to check for call compatibility.
1755: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1756: 1.0,
1757: l_api_name,
1758: G_PKG_NAME)
1759: THEN
1756: 1.0,
1757: l_api_name,
1758: G_PKG_NAME)
1759: THEN
1760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1761: END IF;
1762:
1763: -- Initialize message list if p_init_msg_list is set to TRUE.
1764: IF FND_API.to_Boolean( p_init_msg_list )
1760: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1761: END IF;
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:
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;
1771:
1772: -----------------------Code------------------------
1773: -- Check if we already have an Interaction opened, if so return it
1774: SELECT a.rt_interaction_id, decode(a.interaction_id, -1, NULL, a.interaction_id),
1772: -----------------------Code------------------------
1773: -- Check if we already have an Interaction opened, if so return it
1774: SELECT a.rt_interaction_id, decode(a.interaction_id, -1, NULL, a.interaction_id),
1775: a.resource_id, a.creation_date,
1776: decode(a.parent_interaction_id, NULL, fnd_api.g_miss_num, a.parent_interaction_id),
1777: a.service_request_id, a.lead_id, a.contact_id, a.relationship_id
1778: INTO l_rt_interaction_id, l_interaction_id, l_resource_id, l_start_date,
1779: l_parent_ih_id, x_sr_id, x_lead_id, l_contact_id, l_relationship_id
1780: FROM iem_rt_interactions a, iem_rt_media_items b
1847: x_interaction_id => l_interaction_id,
1848: p_interaction_rec => l_interaction_rec
1849: );
1850:
1851: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
1852: raise IHError;
1853: end if;
1854:
1855: UPDATE iem_rt_interactions set interaction_id = l_interaction_id,
1860: x_interaction_id := l_interaction_id;
1861:
1862: -------------------End Code------------------------
1863: -- Standard Check Of p_commit.
1864: IF FND_API.To_Boolean(p_commit) THEN
1865: COMMIT WORK;
1866: END IF;
1867:
1868: EXCEPTION
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
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
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,
1874: p_data => x_msg_data);
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);
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:
1884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1880: p_encoded => FND_API.G_TRUE,
1881: p_count => x_msg_count,
1882: p_data => x_msg_data);
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,
1882: p_data => x_msg_data);
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);
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
1892: ROLLBACK TO getIHID_pvt;
1889: p_count => x_msg_count,
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;
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:
2044: l_reroute_to_classi := null;
2045: l_mc_param_action := ' ';
2046:
2047: -- Standard call to check for call compatibility.
2048: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
2049: 1.0,
2050: l_api_name,
2051: G_PKG_NAME)
2052: THEN
2049: 1.0,
2050: l_api_name,
2051: G_PKG_NAME)
2052: THEN
2053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2054: END IF;
2055:
2056: -- Initialize message list if p_init_msg_list is set to TRUE.
2057: IF FND_API.to_Boolean( p_init_msg_list )
2053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2054: END IF;
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:
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;
2064:
2065: -----------------------Code------------------------
2066:
2067: --- truncate to 80 characters
2097: -- for redirect wrapup is just to call redirect API then expire the rt items.
2098: if (p_action = G_REDIRECT) then
2099: IEM_REROUTE_PUB.IEM_MAIL_REDIRECT_ACCOUNT(
2100: p_api_version_number =>1.0,
2101: p_init_msg_list => FND_API.G_FALSE,
2102: p_commit => FND_API.G_FALSE,
2103: p_msgid => l_mdt_message_id,
2104: p_email_account_id => l_email_account_id,
2105: p_uid => l_uid,
2098: if (p_action = G_REDIRECT) then
2099: IEM_REROUTE_PUB.IEM_MAIL_REDIRECT_ACCOUNT(
2100: p_api_version_number =>1.0,
2101: p_init_msg_list => FND_API.G_FALSE,
2102: p_commit => FND_API.G_FALSE,
2103: p_msgid => l_mdt_message_id,
2104: p_email_account_id => l_email_account_id,
2105: p_uid => l_uid,
2106: x_msg_count => l_msg_count,
2106: x_msg_count => l_msg_count,
2107: x_return_status => l_status,
2108: x_msg_data => l_msg_data
2109: );
2110: if ( l_status = FND_API.G_RET_STS_ERROR ) then
2111: raise IEM_REDIRECT_EX;
2112: end if;
2113:
2114: UPDATE iem_outbox_errors SET expire = G_EXPIRE
2127:
2128: BEGIN
2129: SELECT decode(interaction_id, -1, null, interaction_id),
2130: ih_creator, service_request_id, service_request_action,
2131: decode(parent_interaction_id, NULL, fnd_api.g_miss_num, parent_interaction_id),
2132: lead_id, nvl(action_id, -1), nvl(contact_id, -1), nvl(to_resource_id, -1),
2133: relationship_id, status, mc_parameter_id
2134: INTO l_interaction_id, l_ih_creator, l_sr_id, l_sr_action, l_parent_ih_id,
2135: l_lead_id, l_action_id, l_contact_id, l_to_resource_id, l_relationship_id,
2334:
2335: UPDATE iem_rt_interactions set IH_CREATOR = 'Y', interaction_id = l_interaction_id
2336: WHERE rt_interaction_id = l_rt_interaction_id;
2337:
2338: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2339: raise IHError;
2340: end if;
2341: END IF;
2342:
2381: x_msg_data => l_msg_data,
2382: p_media_rec => l_media_rec,
2383: x_media_id => l_ob_media_id
2384: );
2385: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2386: raise IHError;
2387: end if;
2388:
2389: end if;
2407: x_msg_data => l_msg_data,
2408: x_milcs_id => x_milcs_id,
2409: p_media_lc_rec => l_media_lc_rec);
2410:
2411: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2412: raise IHError;
2413: end if;
2414: end if;
2415: -- close o/b
2430: x_msg_data => l_msg_data,
2431: p_media_rec => l_media_rec
2432: );
2433:
2434: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2435: raise IHError;
2436: end if;
2437:
2438: -- Add MLCS only for action not equals to 'Resolve ' p_action!='V' Ranjan 10/31/2007
2454: x_msg_count => l_msg_count,
2455: x_msg_data => l_msg_data,
2456: x_milcs_id => x_milcs_id,
2457: p_media_lc_rec => l_media_lc_rec);
2458: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2459: raise IHError;
2460: end if;
2461: end if;
2462: END IF ; -- End if for p_action<>'V' Ranjan 10/31/07
2502: p_activity_rec => l_activity_rec,
2503: x_activity_id => x_activity_id_i
2504: );
2505:
2506: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2507: raise IHError;
2508: end if;
2509: end if;
2510:
2535: p_activity_rec => l_activity_rec,
2536: x_activity_id => x_activity_id_o
2537: );
2538:
2539: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2540: raise IHError;
2541: end if;
2542: end if;
2543:
2574: p_activity_rec => l_activity_rec,
2575: x_activity_id => x_activity_id_o
2576: );
2577:
2578: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2579: raise IHError;
2580: end if;
2581: END IF;
2582:
2614: p_activity_rec => l_activity_rec,
2615: x_activity_id => x_activity_id_o
2616: );
2617:
2618: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2619: raise IHError;
2620: end if;
2621: END IF;
2622:
2647: x_msg_data => l_msg_data,
2648: p_interaction_rec => l_interaction_rec
2649: );
2650:
2651: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2652: raise IHError;
2653: end if;
2654: END IF;
2655:
2689: X_RETURN_STATUS => l_status,
2690: X_MSG_DATA => l_msg_data);
2691: end if;
2692:
2693: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2694: raise RerouteError;
2695: end if;
2696: end;
2697: END IF;
2791: x_msg_count => l_msg_count,
2792: x_msg_data => l_msg_data,
2793: x_milcs_id => x_milcs_id,
2794: p_media_lc_rec => l_media_lc_rec);
2795: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2796: raise IHError;
2797: end if;
2798: end if; -- MLCS second agent
2799:
2897:
2898:
2899: IEM_MSG_STAT_PUB.sendMSGStat(
2900: p_api_version_number => 1.0,
2901: p_init_msg_list => fnd_api.g_false,
2902: p_commit => fnd_api.g_false,
2903: p_outBoundMediaID => l_ob_media_id,
2904: p_inBoundMediaID => nvl(l_ib_media_id, -1),
2905: p_autoReplied => l_autoReplied,
2898:
2899: IEM_MSG_STAT_PUB.sendMSGStat(
2900: p_api_version_number => 1.0,
2901: p_init_msg_list => fnd_api.g_false,
2902: p_commit => fnd_api.g_false,
2903: p_outBoundMediaID => l_ob_media_id,
2904: p_inBoundMediaID => nvl(l_ib_media_id, -1),
2905: p_autoReplied => l_autoReplied,
2906: p_agentID => l_resource_id,
2916:
2917: if (UPPER(p_action) = 'D') then
2918: IEM_MSG_STAT_PUB.deleteMSGStat(
2919: p_api_version_number => 1.0,
2920: p_init_msg_list => fnd_api.g_false,
2921: p_commit => fnd_api.g_false,
2922: p_outBoundMediaID => l_ob_media_id,
2923: p_inBoundMediaID => nvl(l_ib_media_id, -1),
2924: x_return_status => l_ret_status,
2917: if (UPPER(p_action) = 'D') then
2918: IEM_MSG_STAT_PUB.deleteMSGStat(
2919: p_api_version_number => 1.0,
2920: p_init_msg_list => fnd_api.g_false,
2921: p_commit => fnd_api.g_false,
2922: p_outBoundMediaID => l_ob_media_id,
2923: p_inBoundMediaID => nvl(l_ib_media_id, -1),
2924: x_return_status => l_ret_status,
2925: x_msg_count => l_count,
2929:
2930: -------------------End Code------------------------
2931: <
2932: -- Standard Check Of p_commit.
2933: IF FND_API.To_Boolean(p_commit) THEN
2934: COMMIT WORK;
2935: END IF;
2936:
2937: EXCEPTION
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;
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;
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;
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;
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;
2978: x_return_status := FND_API.G_RET_STS_ERROR ;
2979: FND_MSG_PUB.Count_And_Get(
2980: 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;
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);
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:
2984: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2980: p_encoded => FND_API.G_TRUE,
2981: p_count => x_msg_count,
2982: p_data => x_msg_data);
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,
2982: p_data => x_msg_data);
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);
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
2992: ROLLBACK TO wrapUp_pvt;
2989: p_count => x_msg_count,
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;
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:
3061: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3062: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3063:
3064: -- Standard call to check for call compatibility.
3065: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3066: 1.0,
3067: l_api_name,
3068: G_PKG_NAME)
3069: THEN
3066: 1.0,
3067: l_api_name,
3068: G_PKG_NAME)
3069: THEN
3070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3071: END IF;
3072:
3073: -- Initialize message list if p_init_msg_list is set to TRUE.
3074: IF FND_API.to_Boolean( p_init_msg_list )
3070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3071: END IF;
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:
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;
3081:
3082: -----------------------Code------------------------
3083: /* dbms_output.put_line('In getWork ');
3084: dbms_output.put_line('In getWork : Resource ID '||p_resource_id);
3110: x_oes_id := cr_rec.DB_SERVER_ID;
3111: x_folder_name := cr_rec.FOLDER_NAME;
3112: x_folder_uid := cr_rec.FOLDER_UID;
3113: x_customer_id := cr_rec.CUSTOMER_ID;
3114: x_return_status := FND_API.G_RET_STS_SUCCESS;
3115:
3116: exit; -- get the first record.
3117:
3118: END LOOP;
3120:
3121: EXCEPTION
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,
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;
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;
3132: x_return_status := FND_API.G_RET_STS_ERROR ;
3133: FND_MSG_PUB.Count_And_Get(
3134: 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;
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);
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:
3138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3134: p_encoded => FND_API.G_TRUE,
3135: p_count => x_msg_count,
3136: p_data => x_msg_data);
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,
3136: p_data => x_msg_data);
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);
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:
3146: WHEN OTHERS THEN
3144: p_data => x_msg_data);
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;
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:
3184: l_api_name :='getAccountDelStatus';
3185: l_api_version_number :=1.0;
3186:
3187: -- Standard call to check for call compatibility.
3188: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3189: p_api_version_number,
3190: l_api_name,
3191: G_PKG_NAME)
3192: THEN
3189: p_api_version_number,
3190: l_api_name,
3191: G_PKG_NAME)
3192: THEN
3193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3194: END IF;
3195:
3196: -- Initialize message list if p_init_msg_list is set to TRUE.
3197: IF FND_API.to_Boolean( p_init_msg_list )
3193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3194: END IF;
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:
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;
3204:
3205: ----------------------------------------CODE-----------------------------------
3206: l_data := 0;
3207: x_status := 0;
3232: END LOOP;
3233: END IF;
3234: ----------------------------------------CODE-----------------------------------
3235: -- Standard Check Of p_commit.
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
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: );
3245: EXCEPTION
3242: p_count => x_msg_count,
3243: p_data => x_msg_data
3244: );
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,
3244: );
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
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: );
3254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3250: ( p_encoded => FND_API.G_TRUE,
3251: p_count => x_msg_count,
3252: p_data => x_msg_data
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,
3252: p_data => x_msg_data
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
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: );
3262: WHEN OTHERS THEN
3260: p_data => x_msg_data
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
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: );
3278:
3336: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3337: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3338:
3339: -- Standard call to check for call compatibility.
3340: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3341: 1.0,
3342: l_api_name,
3343: G_PKG_NAME)
3344: THEN
3341: 1.0,
3342: l_api_name,
3343: G_PKG_NAME)
3344: THEN
3345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3346: END IF;
3347:
3348: -- Initialize message list if p_init_msg_list is set to TRUE.
3349: IF FND_API.to_Boolean( p_init_msg_list )
3345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3346: END IF;
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:
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;
3356:
3357: -----------------------Code------------------------
3358: BEGIN
3359:
3511:
3512:
3513: EXCEPTION
3514: WHEN OTHERS THEN
3515: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3516: END;
3517:
3518: -------------------End Code------------------------
3519: -- Standard Check Of p_commit.
3516: END;
3517:
3518: -------------------End Code------------------------
3519: -- Standard Check Of p_commit.
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
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: );
3529: EXCEPTION
3526: p_count => x_msg_count,
3527: p_data => x_msg_data
3528: );
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,
3528: );
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);
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:
3538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3534: p_encoded => FND_API.G_TRUE,
3535: p_count => x_msg_count,
3536: p_data => x_msg_data);
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,
3536: p_data => x_msg_data);
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);
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:
3546: WHEN OTHERS THEN
3544: p_data => x_msg_data);
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;
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:
3631: l_milcs_id :=null;
3632:
3633:
3634: -- Standard call to check for call compatibility.
3635: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3636: 1.0,
3637: l_api_name,
3638: G_PKG_NAME)
3639: THEN
3636: 1.0,
3637: l_api_name,
3638: G_PKG_NAME)
3639: THEN
3640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3641: END IF;
3642:
3643: -- Initialize message list if p_init_msg_list is set to TRUE.
3644: IF FND_API.to_Boolean( p_init_msg_list )
3640: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3641: END IF;
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:
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;
3651:
3652: -----------------------Code------------------------
3653:
3654: -- if assign to herself, this will be recorded as a 'fetch'
3673: x_msg_count => l_msg_count,
3674: x_msg_data => l_msg_data);
3675:
3676: -- Check return status; Proceed on success Or report back in case of error.
3677: IF (l_status = FND_API.G_RET_STS_SUCCESS) THEN
3678: -- Success.
3679: -- Get the name of the route classification from the ID returned above.
3680: -- This is the name of the folder where the inbound message exists on the
3681: -- master account.
3836:
3837:
3838: -------------------End Code------------------------
3839: -- Standard Check Of p_commit.
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
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: );
3849: EXCEPTION
3846: p_count => x_msg_count,
3847: p_data => x_msg_data
3848: );
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,
3848: );
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);
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:
3858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3854: p_encoded => FND_API.G_TRUE,
3855: p_count => x_msg_count,
3856: p_data => x_msg_data);
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,
3856: p_data => x_msg_data);
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:
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
3863: p_data => x_msg_data);
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;
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:
3937: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3938: l_noop := 0;
3939:
3940: -- Standard call to check for call compatibility.
3941: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3942: 1.0,
3943: l_api_name,
3944: G_PKG_NAME)
3945: THEN
3942: 1.0,
3943: l_api_name,
3944: G_PKG_NAME)
3945: THEN
3946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3947: END IF;
3948:
3949: -- Initialize message list if p_init_msg_list is set to TRUE.
3950: IF FND_API.to_Boolean( p_init_msg_list )
3946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3947: END IF;
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:
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;
3957:
3958: -----------------------Code------------------------
3959:
3960: -- Get the values that are needed later.
3984: (p_action = 'T' OR p_action = 'H' OR p_action = 'E') ) THEN
3985: l_noop := 1;
3986: END IF;
3987:
3988: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS AND l_noop = 0) THEN
3989:
3990: BEGIN
3991: l_message_id := null;
3992: SELECT message_id INTO l_message_id FROM iem_rt_media_items
4029: END IF;
4030:
4031: -------------------End Code------------------------
4032: -- Standard Check Of p_commit.
4033: IF FND_API.To_Boolean(p_commit) THEN
4034: COMMIT WORK;
4035: END IF;
4036:
4037: EXCEPTION
4036:
4037: EXCEPTION
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,
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
4045: p_data => x_msg_data);
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:
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
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
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,
4052: p_data => x_msg_data);
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:
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
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
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,
4059: p_data => x_msg_data);
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
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;
4065: p_count => x_msg_count,
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;
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:
4149: l_email_account_id := 0;
4150: l_agent_account_id := 0;
4151:
4152: -- Standard call to check for call compatibility.
4153: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4154: 1.0,
4155: l_api_name,
4156: G_PKG_NAME)
4157: THEN
4154: 1.0,
4155: l_api_name,
4156: G_PKG_NAME)
4157: THEN
4158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4159: END IF;
4160:
4161: -- Initialize message list if p_init_msg_list is set to TRUE.
4162: IF FND_API.to_Boolean( p_init_msg_list )
4158: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4159: END IF;
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:
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;
4169:
4170: -----------------------Code------------------------
4171: IF ( p_failed = 'T' ) THEN
4172: -- Get the item that is failed at last attempt to process
4191: x_return_status => x_return_status,
4192: x_msg_count => x_msg_count,
4193: x_msg_data => x_msg_data );
4194:
4195: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
4196: l_max_try := 3;
4197: x_return_status := FND_API.G_RET_STS_SUCCESS;
4198: ELSE
4199: l_max_try := TO_NUMBER(l_max_try_val);
4193: x_msg_data => x_msg_data );
4194:
4195: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
4196: l_max_try := 3;
4197: x_return_status := FND_API.G_RET_STS_SUCCESS;
4198: ELSE
4199: l_max_try := TO_NUMBER(l_max_try_val);
4200: END IF;
4201:
4342: -------------------End Code------------------------
4343: EXCEPTION
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,
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;
4350: -- p_count => x_msg_count,
4351: -- p_data => x_msg_data);
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,
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;
4358: p_count => x_msg_count,
4359: p_data => x_msg_data);
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,
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;
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;
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,
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;
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:
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
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
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,
4373: p_data => x_msg_data);
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:
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
4380: p_data => x_msg_data);
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;
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:
4450: l_contact_id :=null;
4451: l_lead_id :=null;
4452:
4453: -- Standard call to check for call compatibility.
4454: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4455: 1.0,
4456: l_api_name,
4457: G_PKG_NAME)
4458: THEN
4455: 1.0,
4456: l_api_name,
4457: G_PKG_NAME)
4458: THEN
4459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4460: END IF;
4461:
4462: -- Initialize message list if p_init_msg_list is set to TRUE.
4463: IF FND_API.to_Boolean( p_init_msg_list )
4459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4460: END IF;
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:
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;
4470:
4471: -----------------------Code------------------------
4472:
4473: -- Update IEM_RT_PROC_EMAILS with to_agent_id, from_agent_id and p_status
4485: x_msg_count => l_msg_count,
4486: x_msg_data => l_msg_data);
4487:
4488: -- Check return status; Proceed on success Or report back in case of error.
4489: IF (l_status = FND_API.G_RET_STS_SUCCESS) THEN
4490: -- Success.
4491: -- Get the name of the route classification from the ID returned above.
4492: -- This is the name of the folder where the inbound message exists on the
4493: -- master account.
4592: END IF;
4593:
4594: -------------------End Code------------------------
4595: -- Standard Check Of p_commit.
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
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: -- );
4605:
4603: -- p_data => x_msg_data
4604: -- );
4605:
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,
4605:
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:
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
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
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,
4612: p_data => x_msg_data);
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:
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
4619: p_data => x_msg_data);
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;
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;
4665: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4666: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4667:
4668: -- Standard call to check for call compatibility.
4669: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4670: 1.0,
4671: l_api_name,
4672: G_PKG_NAME)
4673: THEN
4670: 1.0,
4671: l_api_name,
4672: G_PKG_NAME)
4673: THEN
4674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4675: END IF;
4676:
4677: -- Initialize message list if p_init_msg_list is set to TRUE.
4678: IF FND_API.to_Boolean( p_init_msg_list )
4674: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4675: END IF;
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:
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;
4685:
4686: -----------------------Code------------------------
4687: x_is_clean := false;
4688:
4720: x_is_clean := true;
4721: end if;
4722: -------------------End Code------------------------
4723: -- Standard Check Of p_commit.
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
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: -- );
4733:
4733:
4734: EXCEPTION
4735: WHEN IEM_NO_AGENT_ACCT THEN
4736: ROLLBACK TO isAgentInboxClean_pvt;
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;
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:
4747: WHEN FND_API.G_EXC_ERROR THEN
4743: p_encoded => FND_API.G_TRUE,
4744: p_count => x_msg_count,
4745: p_data => x_msg_data);
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,
4745: p_data => x_msg_data);
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:
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
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
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,
4752: p_data => x_msg_data);
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:
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
4759: p_data => x_msg_data);
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;
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;
4798: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4799: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4800:
4801: -- Standard call to check for call compatibility.
4802: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4803: 1.0,
4804: l_api_name,
4805: G_PKG_NAME)
4806: THEN
4803: 1.0,
4804: l_api_name,
4805: G_PKG_NAME)
4806: THEN
4807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4808: END IF;
4809:
4810: -- Initialize message list if p_init_msg_list is set to TRUE.
4811: IF FND_API.to_Boolean( p_init_msg_list )
4807: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4808: END IF;
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:
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;
4818:
4819: -----------------------Code------------------------
4820:
4821: begin
4827: end;
4828:
4829: -------------------End Code------------------------
4830: -- Standard Check Of p_commit.
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
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: -- );
4840:
4838: -- p_data => x_msg_data
4839: -- );
4840:
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,
4840:
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:
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
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
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,
4847: p_data => x_msg_data);
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:
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
4854: p_data => x_msg_data);
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;
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;