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
665: x_return_status := FND_API.G_RET_STS_ERROR;
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');
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);
670: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
671:
672: WHEN FND_API.G_EXC_ERROR 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);
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;
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
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:
678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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
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:
684: WHEN OTHERS THEN
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
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
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:
690: -- Get message count and data
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:
690: -- Get message count and data
691: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
687: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Retrieve_Msg_Mapping');
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
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: (
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;
724: x_notif_setup_id := l_notif_setup_id;
725: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
726:
727: EXCEPTION
728: when NO_DATA_FOUND then
729: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_NAME_NOT_FOUND');
727: EXCEPTION
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:
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:
737: END IBE_WF_MSG_MAPPING_PVT;