[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:
2050: l_reroute_to_classi := null;
2051: l_mc_param_action := ' ';
2052:
2053: -- Standard call to check for call compatibility.
2054: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
2055: 1.0,
2056: l_api_name,
2057: G_PKG_NAME)
2058: THEN
2055: 1.0,
2056: l_api_name,
2057: G_PKG_NAME)
2058: THEN
2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2060: END IF;
2061:
2062: -- Initialize message list if p_init_msg_list is set to TRUE.
2063: IF FND_API.to_Boolean( p_init_msg_list )
2059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2060: END IF;
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:
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;
2070:
2071: -----------------------Code------------------------
2072:
2073:
2115: -- for redirect wrapup is just to call redirect API then expire the rt items.
2116: if (p_action = G_REDIRECT) then
2117: IEM_REROUTE_PUB.IEM_MAIL_REDIRECT_ACCOUNT(
2118: p_api_version_number =>1.0,
2119: p_init_msg_list => FND_API.G_FALSE,
2120: p_commit => FND_API.G_FALSE,
2121: p_msgid => l_mdt_message_id,
2122: p_email_account_id => l_email_account_id,
2123: p_uid => l_uid,
2116: if (p_action = G_REDIRECT) then
2117: IEM_REROUTE_PUB.IEM_MAIL_REDIRECT_ACCOUNT(
2118: p_api_version_number =>1.0,
2119: p_init_msg_list => FND_API.G_FALSE,
2120: p_commit => FND_API.G_FALSE,
2121: p_msgid => l_mdt_message_id,
2122: p_email_account_id => l_email_account_id,
2123: p_uid => l_uid,
2124: x_msg_count => l_msg_count,
2124: x_msg_count => l_msg_count,
2125: x_return_status => l_status,
2126: x_msg_data => l_msg_data
2127: );
2128: if ( l_status = FND_API.G_RET_STS_ERROR ) then
2129: raise IEM_REDIRECT_EX;
2130: end if;
2131:
2132: UPDATE iem_outbox_errors SET expire = G_EXPIRE
2145:
2146: BEGIN
2147: SELECT decode(interaction_id, -1, null, interaction_id),
2148: ih_creator, service_request_id, service_request_action,
2149: decode(parent_interaction_id, NULL, fnd_api.g_miss_num, parent_interaction_id),
2150: lead_id, nvl(action_id, -1), nvl(contact_id, -1), nvl(to_resource_id, -1),
2151: relationship_id, status, mc_parameter_id
2152: INTO l_interaction_id, l_ih_creator, l_sr_id, l_sr_action, l_parent_ih_id,
2153: l_lead_id, l_action_id, l_contact_id, l_to_resource_id, l_relationship_id,
2360:
2361: UPDATE iem_rt_interactions set IH_CREATOR = 'Y', interaction_id = l_interaction_id
2362: WHERE rt_interaction_id = l_rt_interaction_id;
2363:
2364: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2365: raise IHError;
2366: end if;
2367: -- following ELSE added for 11737525 ,FP of bug 9791525
2368: ELSE --lkullamb interaction_id is present already. Not a pure outbound.Fix for bug 12746288, change jtf_ih_interactions_vl to jtf_ih_interactions
2435: x_msg_data => l_msg_data,
2436: p_media_rec => l_media_rec,
2437: x_media_id => l_ob_media_id
2438: );
2439: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2440: raise IHError;
2441: end if;
2442:
2443: end if;
2461: x_msg_data => l_msg_data,
2462: x_milcs_id => x_milcs_id,
2463: p_media_lc_rec => l_media_lc_rec);
2464:
2465: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2466: raise IHError;
2467: end if;
2468: end if;
2469: -- close o/b
2484: x_msg_data => l_msg_data,
2485: p_media_rec => l_media_rec
2486: );
2487:
2488: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2489: raise IHError;
2490: end if;
2491:
2492: -- Add MLCS only for action not equals to 'Resolve ' p_action!='V' Ranjan 10/31/2007
2508: x_msg_count => l_msg_count,
2509: x_msg_data => l_msg_data,
2510: x_milcs_id => x_milcs_id,
2511: p_media_lc_rec => l_media_lc_rec);
2512: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2513: raise IHError;
2514: end if;
2515: end if;
2516: END IF ; -- End if for p_action<>'V' Ranjan 10/31/07
2556: p_activity_rec => l_activity_rec,
2557: x_activity_id => x_activity_id_i
2558: );
2559:
2560: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2561: raise IHError;
2562: end if;
2563: end if;
2564:
2589: p_activity_rec => l_activity_rec,
2590: x_activity_id => x_activity_id_o
2591: );
2592:
2593: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2594: raise IHError;
2595: end if;
2596: end if;
2597:
2632: p_activity_rec => l_activity_rec,
2633: x_activity_id => x_activity_id_o
2634: );
2635:
2636: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2637: raise IHError;
2638: end if;
2639: END IF;
2640:
2673: p_activity_rec => l_activity_rec,
2674: x_activity_id => x_activity_id_o
2675: );
2676:
2677: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2678: raise IHError;
2679: end if;
2680: END IF;
2681:
2709: x_msg_data => l_msg_data,
2710: p_interaction_rec => l_interaction_rec
2711: );
2712:
2713: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2714: raise IHError;
2715: end if;
2716: END IF;
2717:
2751: X_RETURN_STATUS => l_status,
2752: X_MSG_DATA => l_msg_data);
2753: end if;
2754:
2755: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2756: raise RerouteError;
2757: end if;
2758: end;
2759: END IF;
2853: x_msg_count => l_msg_count,
2854: x_msg_data => l_msg_data,
2855: x_milcs_id => x_milcs_id,
2856: p_media_lc_rec => l_media_lc_rec);
2857: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
2858: raise IHError;
2859: end if;
2860: end if; -- MLCS second agent
2861:
2959:
2960:
2961: IEM_MSG_STAT_PUB.sendMSGStat(
2962: p_api_version_number => 1.0,
2963: p_init_msg_list => fnd_api.g_false,
2964: p_commit => fnd_api.g_false,
2965: p_outBoundMediaID => l_ob_media_id,
2966: p_inBoundMediaID => nvl(l_ib_media_id, -1),
2967: p_autoReplied => l_autoReplied,
2960:
2961: IEM_MSG_STAT_PUB.sendMSGStat(
2962: p_api_version_number => 1.0,
2963: p_init_msg_list => fnd_api.g_false,
2964: p_commit => fnd_api.g_false,
2965: p_outBoundMediaID => l_ob_media_id,
2966: p_inBoundMediaID => nvl(l_ib_media_id, -1),
2967: p_autoReplied => l_autoReplied,
2968: p_agentID => l_resource_id,
2978:
2979: if (UPPER(p_action) = 'D') then
2980: IEM_MSG_STAT_PUB.deleteMSGStat(
2981: p_api_version_number => 1.0,
2982: p_init_msg_list => fnd_api.g_false,
2983: p_commit => fnd_api.g_false,
2984: p_outBoundMediaID => l_ob_media_id,
2985: p_inBoundMediaID => nvl(l_ib_media_id, -1),
2986: x_return_status => l_ret_status,
2979: if (UPPER(p_action) = 'D') then
2980: IEM_MSG_STAT_PUB.deleteMSGStat(
2981: p_api_version_number => 1.0,
2982: p_init_msg_list => fnd_api.g_false,
2983: p_commit => fnd_api.g_false,
2984: p_outBoundMediaID => l_ob_media_id,
2985: p_inBoundMediaID => nvl(l_ib_media_id, -1),
2986: x_return_status => l_ret_status,
2987: x_msg_count => l_count,
2991:
2992: -------------------End Code------------------------
2993: <
2994: -- Standard Check Of p_commit.
2995: IF FND_API.To_Boolean(p_commit) THEN
2996: COMMIT WORK;
2997: END IF;
2998:
2999: EXCEPTION
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;
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;
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;
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;
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;
3040: x_return_status := FND_API.G_RET_STS_ERROR ;
3041: FND_MSG_PUB.Count_And_Get(
3042: 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;
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);
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:
3046: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3042: p_encoded => FND_API.G_TRUE,
3043: p_count => x_msg_count,
3044: p_data => x_msg_data);
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,
3044: p_data => x_msg_data);
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);
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
3054: ROLLBACK TO wrapUp_pvt;
3051: p_count => x_msg_count,
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;
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:
3123: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3124: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3125:
3126: -- Standard call to check for call compatibility.
3127: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3128: 1.0,
3129: l_api_name,
3130: G_PKG_NAME)
3131: THEN
3128: 1.0,
3129: l_api_name,
3130: G_PKG_NAME)
3131: THEN
3132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3133: END IF;
3134:
3135: -- Initialize message list if p_init_msg_list is set to TRUE.
3136: IF FND_API.to_Boolean( p_init_msg_list )
3132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3133: END IF;
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:
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;
3143:
3144: -----------------------Code------------------------
3145: /* dbms_output.put_line('In getWork ');
3146: dbms_output.put_line('In getWork : Resource ID '||p_resource_id);
3172: x_oes_id := cr_rec.DB_SERVER_ID;
3173: x_folder_name := cr_rec.FOLDER_NAME;
3174: x_folder_uid := cr_rec.FOLDER_UID;
3175: x_customer_id := cr_rec.CUSTOMER_ID;
3176: x_return_status := FND_API.G_RET_STS_SUCCESS;
3177:
3178: exit; -- get the first record.
3179:
3180: END LOOP;
3182:
3183: EXCEPTION
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,
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;
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;
3194: x_return_status := FND_API.G_RET_STS_ERROR ;
3195: FND_MSG_PUB.Count_And_Get(
3196: 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;
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);
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:
3200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3196: p_encoded => FND_API.G_TRUE,
3197: p_count => x_msg_count,
3198: p_data => x_msg_data);
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,
3198: p_data => x_msg_data);
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);
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:
3208: WHEN OTHERS THEN
3206: p_data => x_msg_data);
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;
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:
3246: l_api_name :='getAccountDelStatus';
3247: l_api_version_number :=1.0;
3248:
3249: -- Standard call to check for call compatibility.
3250: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3251: p_api_version_number,
3252: l_api_name,
3253: G_PKG_NAME)
3254: THEN
3251: p_api_version_number,
3252: l_api_name,
3253: G_PKG_NAME)
3254: THEN
3255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3256: END IF;
3257:
3258: -- Initialize message list if p_init_msg_list is set to TRUE.
3259: IF FND_API.to_Boolean( p_init_msg_list )
3255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3256: END IF;
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:
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;
3266:
3267: ----------------------------------------CODE-----------------------------------
3268: l_data := 0;
3269: x_status := 0;
3294: END LOOP;
3295: END IF;
3296: ----------------------------------------CODE-----------------------------------
3297: -- Standard Check Of p_commit.
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
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: );
3307: EXCEPTION
3304: p_count => x_msg_count,
3305: p_data => x_msg_data
3306: );
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,
3306: );
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
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: );
3316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3312: ( p_encoded => FND_API.G_TRUE,
3313: p_count => x_msg_count,
3314: p_data => x_msg_data
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,
3314: p_data => x_msg_data
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
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: );
3324: WHEN OTHERS THEN
3322: p_data => x_msg_data
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
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: );
3340:
3398: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3399: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3400:
3401: -- Standard call to check for call compatibility.
3402: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3403: 1.0,
3404: l_api_name,
3405: G_PKG_NAME)
3406: THEN
3403: 1.0,
3404: l_api_name,
3405: G_PKG_NAME)
3406: THEN
3407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3408: END IF;
3409:
3410: -- Initialize message list if p_init_msg_list is set to TRUE.
3411: IF FND_API.to_Boolean( p_init_msg_list )
3407: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3408: END IF;
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:
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;
3418:
3419: -----------------------Code------------------------
3420: BEGIN
3421:
3573:
3574:
3575: EXCEPTION
3576: WHEN OTHERS THEN
3577: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3578: END;
3579:
3580: -------------------End Code------------------------
3581: -- Standard Check Of p_commit.
3578: END;
3579:
3580: -------------------End Code------------------------
3581: -- Standard Check Of p_commit.
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
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: );
3591: EXCEPTION
3588: p_count => x_msg_count,
3589: p_data => x_msg_data
3590: );
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,
3590: );
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);
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:
3600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3596: p_encoded => FND_API.G_TRUE,
3597: p_count => x_msg_count,
3598: p_data => x_msg_data);
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,
3598: p_data => x_msg_data);
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);
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:
3608: WHEN OTHERS THEN
3606: p_data => x_msg_data);
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;
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:
3695: l_milcs_id :=null;
3696:
3697:
3698: -- Standard call to check for call compatibility.
3699: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3700: 1.0,
3701: l_api_name,
3702: G_PKG_NAME)
3703: THEN
3700: 1.0,
3701: l_api_name,
3702: G_PKG_NAME)
3703: THEN
3704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3705: END IF;
3706:
3707: -- Initialize message list if p_init_msg_list is set to TRUE.
3708: IF FND_API.to_Boolean( p_init_msg_list )
3704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3705: END IF;
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:
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;
3715:
3716: -----------------------Code------------------------
3717:
3718: -- if assign to herself, this will be recorded as a 'fetch'
3737: x_msg_count => l_msg_count,
3738: x_msg_data => l_msg_data);
3739:
3740: -- Check return status; Proceed on success Or report back in case of error.
3741: IF (l_status = FND_API.G_RET_STS_SUCCESS) THEN
3742: -- Success.
3743: -- Get the name of the route classification from the ID returned above.
3744: -- This is the name of the folder where the inbound message exists on the
3745: -- master account.
3911:
3912:
3913: -------------------End Code------------------------
3914: -- Standard Check Of p_commit.
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
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: );
3924: EXCEPTION
3921: p_count => x_msg_count,
3922: p_data => x_msg_data
3923: );
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,
3923: );
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);
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:
3933: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3929: p_encoded => FND_API.G_TRUE,
3930: p_count => x_msg_count,
3931: p_data => x_msg_data);
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,
3931: p_data => x_msg_data);
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:
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
3938: p_data => x_msg_data);
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;
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:
4012: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4013: l_noop := 0;
4014:
4015: -- Standard call to check for call compatibility.
4016: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4017: 1.0,
4018: l_api_name,
4019: G_PKG_NAME)
4020: THEN
4017: 1.0,
4018: l_api_name,
4019: G_PKG_NAME)
4020: THEN
4021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4022: END IF;
4023:
4024: -- Initialize message list if p_init_msg_list is set to TRUE.
4025: IF FND_API.to_Boolean( p_init_msg_list )
4021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4022: END IF;
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:
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;
4032:
4033: -----------------------Code------------------------
4034:
4035: -- Get the values that are needed later.
4059: (p_action = 'T' OR p_action = 'H' OR p_action = 'E') ) THEN
4060: l_noop := 1;
4061: END IF;
4062:
4063: IF ( x_return_status = FND_API.G_RET_STS_SUCCESS AND l_noop = 0) THEN
4064:
4065: BEGIN
4066: l_message_id := null;
4067: SELECT message_id INTO l_message_id FROM iem_rt_media_items
4104: END IF;
4105:
4106: -------------------End Code------------------------
4107: -- Standard Check Of p_commit.
4108: IF FND_API.To_Boolean(p_commit) THEN
4109: COMMIT WORK;
4110: END IF;
4111:
4112: EXCEPTION
4111:
4112: EXCEPTION
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,
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
4120: p_data => x_msg_data);
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:
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
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
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,
4127: p_data => x_msg_data);
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:
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
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
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,
4134: p_data => x_msg_data);
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
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;
4140: p_count => x_msg_count,
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;
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:
4224: l_email_account_id := 0;
4225: l_agent_account_id := 0;
4226:
4227: -- Standard call to check for call compatibility.
4228: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4229: 1.0,
4230: l_api_name,
4231: G_PKG_NAME)
4232: THEN
4229: 1.0,
4230: l_api_name,
4231: G_PKG_NAME)
4232: THEN
4233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4234: END IF;
4235:
4236: -- Initialize message list if p_init_msg_list is set to TRUE.
4237: IF FND_API.to_Boolean( p_init_msg_list )
4233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4234: END IF;
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:
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;
4244:
4245: -----------------------Code------------------------
4246: IF ( p_failed = 'T' ) THEN
4247: -- Get the item that is failed at last attempt to process
4266: x_return_status => x_return_status,
4267: x_msg_count => x_msg_count,
4268: x_msg_data => x_msg_data );
4269:
4270: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
4271: l_max_try := 3;
4272: x_return_status := FND_API.G_RET_STS_SUCCESS;
4273: ELSE
4274: l_max_try := TO_NUMBER(l_max_try_val);
4268: x_msg_data => x_msg_data );
4269:
4270: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
4271: l_max_try := 3;
4272: x_return_status := FND_API.G_RET_STS_SUCCESS;
4273: ELSE
4274: l_max_try := TO_NUMBER(l_max_try_val);
4275: END IF;
4276:
4417: -------------------End Code------------------------
4418: EXCEPTION
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,
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;
4425: -- p_count => x_msg_count,
4426: -- p_data => x_msg_data);
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,
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;
4433: p_count => x_msg_count,
4434: p_data => x_msg_data);
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,
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;
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;
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,
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;
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:
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
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
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,
4448: p_data => x_msg_data);
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:
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
4455: p_data => x_msg_data);
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;
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:
4525: l_contact_id :=null;
4526: l_lead_id :=null;
4527:
4528: -- Standard call to check for call compatibility.
4529: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4530: 1.0,
4531: l_api_name,
4532: G_PKG_NAME)
4533: THEN
4530: 1.0,
4531: l_api_name,
4532: G_PKG_NAME)
4533: THEN
4534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4535: END IF;
4536:
4537: -- Initialize message list if p_init_msg_list is set to TRUE.
4538: IF FND_API.to_Boolean( p_init_msg_list )
4534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4535: END IF;
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:
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;
4545:
4546: -----------------------Code------------------------
4547:
4548: -- Update IEM_RT_PROC_EMAILS with to_agent_id, from_agent_id and p_status
4560: x_msg_count => l_msg_count,
4561: x_msg_data => l_msg_data);
4562:
4563: -- Check return status; Proceed on success Or report back in case of error.
4564: IF (l_status = FND_API.G_RET_STS_SUCCESS) THEN
4565: -- Success.
4566: -- Get the name of the route classification from the ID returned above.
4567: -- This is the name of the folder where the inbound message exists on the
4568: -- master account.
4667: END IF;
4668:
4669: -------------------End Code------------------------
4670: -- Standard Check Of p_commit.
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
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: -- );
4680:
4678: -- p_data => x_msg_data
4679: -- );
4680:
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,
4680:
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:
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
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
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,
4687: p_data => x_msg_data);
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:
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
4694: p_data => x_msg_data);
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;
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;
4740: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4741: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4742:
4743: -- Standard call to check for call compatibility.
4744: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4745: 1.0,
4746: l_api_name,
4747: G_PKG_NAME)
4748: THEN
4745: 1.0,
4746: l_api_name,
4747: G_PKG_NAME)
4748: THEN
4749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4750: END IF;
4751:
4752: -- Initialize message list if p_init_msg_list is set to TRUE.
4753: IF FND_API.to_Boolean( p_init_msg_list )
4749: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4750: END IF;
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:
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;
4760:
4761: -----------------------Code------------------------
4762: x_is_clean := false;
4763:
4795: x_is_clean := true;
4796: end if;
4797: -------------------End Code------------------------
4798: -- Standard Check Of p_commit.
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
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: -- );
4808:
4808:
4809: EXCEPTION
4810: WHEN IEM_NO_AGENT_ACCT THEN
4811: ROLLBACK TO isAgentInboxClean_pvt;
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;
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:
4822: WHEN FND_API.G_EXC_ERROR THEN
4818: p_encoded => FND_API.G_TRUE,
4819: p_count => x_msg_count,
4820: p_data => x_msg_data);
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,
4820: p_data => x_msg_data);
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:
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
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
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,
4827: p_data => x_msg_data);
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:
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
4834: p_data => x_msg_data);
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;
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;
4873: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4874: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4875:
4876: -- Standard call to check for call compatibility.
4877: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4878: 1.0,
4879: l_api_name,
4880: G_PKG_NAME)
4881: THEN
4878: 1.0,
4879: l_api_name,
4880: G_PKG_NAME)
4881: THEN
4882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4883: END IF;
4884:
4885: -- Initialize message list if p_init_msg_list is set to TRUE.
4886: IF FND_API.to_Boolean( p_init_msg_list )
4882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4883: END IF;
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:
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;
4893:
4894: -----------------------Code------------------------
4895:
4896: begin
4902: end;
4903:
4904: -------------------End Code------------------------
4905: -- Standard Check Of p_commit.
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
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: -- );
4915:
4913: -- p_data => x_msg_data
4914: -- );
4915:
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,
4915:
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:
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
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
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,
4922: p_data => x_msg_data);
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:
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
4929: p_data => x_msg_data);
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;
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;