533: x_msite_id_flag => l_msite_id_flag,
534: x_user_type_flag => l_user_type_flag,
535: x_enabled_flag => l_menabled_flag);
536:
537: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
538: raise FND_API.G_EXC_ERROR;
539: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
540: raise FND_API.G_EXC_UNEXPECTED_ERROR;
541: end if;
534: x_user_type_flag => l_user_type_flag,
535: x_enabled_flag => l_menabled_flag);
536:
537: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
538: raise FND_API.G_EXC_ERROR;
539: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
540: raise FND_API.G_EXC_UNEXPECTED_ERROR;
541: end if;
542:
535: x_enabled_flag => l_menabled_flag);
536:
537: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
538: raise FND_API.G_EXC_ERROR;
539: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
540: raise FND_API.G_EXC_UNEXPECTED_ERROR;
541: end if;
542:
543: debug('retrieve_msg_mapping 2');
536:
537: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
538: raise FND_API.G_EXC_ERROR;
539: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
540: raise FND_API.G_EXC_UNEXPECTED_ERROR;
541: end if;
542:
543: debug('retrieve_msg_mapping 2');
544:
656: END;
657: end if;
658: x_wf_message_name := l_wf_msg_name;
659: x_enabled_flag := l_enabled_flag;
660: x_return_status := FND_API.G_RET_STS_SUCCESS;
661: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
662: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
663: EXCEPTION
664: WHEN NO_DATA_FOUND THEN
658: x_wf_message_name := l_wf_msg_name;
659: x_enabled_flag := l_enabled_flag;
660: x_return_status := FND_API.G_RET_STS_SUCCESS;
661: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
662: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
663: EXCEPTION
664: WHEN NO_DATA_FOUND THEN
665: x_return_status := FND_API.G_RET_STS_ERROR;
666: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_MSG_MAP_NOT_FOUND');
661: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
662: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
663: EXCEPTION
664: WHEN NO_DATA_FOUND THEN
665: x_return_status := FND_API.G_RET_STS_ERROR;
666: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_MSG_MAP_NOT_FOUND');
667: FND_MESSAGE.SET_TOKEN('NOTIF', p_notif_name);
668: FND_MSG_PUB.ADD;
669: FND_MSG_PUB.Count_And_Get(p_count=> x_msg_count, p_data => x_msg_data);
666: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_MSG_MAP_NOT_FOUND');
667: FND_MESSAGE.SET_TOKEN('NOTIF', p_notif_name);
668: FND_MSG_PUB.ADD;
669: FND_MSG_PUB.Count_And_Get(p_count=> x_msg_count, p_data => x_msg_data);
670: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
671:
672: WHEN FND_API.G_EXC_ERROR THEN
673: x_return_status := FND_API.G_RET_STS_ERROR;
674: -- Get message count and data
668: FND_MSG_PUB.ADD;
669: FND_MSG_PUB.Count_And_Get(p_count=> x_msg_count, p_data => x_msg_data);
670: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
671:
672: WHEN FND_API.G_EXC_ERROR THEN
673: x_return_status := FND_API.G_RET_STS_ERROR;
674: -- Get message count and data
675: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
676: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
669: FND_MSG_PUB.Count_And_Get(p_count=> x_msg_count, p_data => x_msg_data);
670: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
671:
672: WHEN FND_API.G_EXC_ERROR THEN
673: x_return_status := FND_API.G_RET_STS_ERROR;
674: -- Get message count and data
675: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
676: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
677:
672: WHEN FND_API.G_EXC_ERROR THEN
673: x_return_status := FND_API.G_RET_STS_ERROR;
674: -- Get message count and data
675: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
676: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
677:
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
680: -- Get message count and data
674: -- Get message count and data
675: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
676: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
677:
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
680: -- Get message count and data
681: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
682: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
675: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
676: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
677:
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
680: -- Get message count and data
681: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
682: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
683:
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
680: -- Get message count and data
681: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
682: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
683:
684: WHEN OTHERS THEN
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
686: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
681: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
682: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
683:
684: WHEN OTHERS THEN
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
686: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
687: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Retrieve_Msg_Mapping');
688: END IF;
689:
688: END IF;
689:
690: -- Get message count and data
691: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
692: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
693: END Retrieve_Msg_Mapping;
694:
695: procedure Get_Notif_Metadata
696: (
715: into l_org_id_flag, l_msite_id_flag, l_enabled_flag, l_notif_setup_id, l_user_type_flag
716: from ibe_wf_notif_setup
717: where notification_name = p_notification_name;
718:
719: x_return_status := FND_API.G_RET_STS_SUCCESS;
720: x_org_id_flag := l_org_id_flag;
721: x_msite_id_flag := l_msite_id_flag;
722: x_user_type_flag := l_user_type_flag;
723: x_enabled_flag := l_enabled_flag;
728: when NO_DATA_FOUND then
729: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_NAME_NOT_FOUND');
730: FND_MESSAGE.SET_TOKEN('NAME', p_notification_name);
731: FND_MSG_PUB.ADD;
732: x_return_status := FND_API.G_RET_STS_ERROR;
733: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
734: END Get_Notif_Metadata;
735:
736: