654: end if;
655: x_wf_message_name := l_wf_msg_name;
656: x_enabled_flag := l_enabled_flag;
657: x_return_status := FND_API.G_RET_STS_SUCCESS;
658: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
659: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
660: EXCEPTION
661: WHEN NO_DATA_FOUND THEN
662: x_return_status := FND_API.G_RET_STS_ERROR;
655: x_wf_message_name := l_wf_msg_name;
656: x_enabled_flag := l_enabled_flag;
657: x_return_status := FND_API.G_RET_STS_SUCCESS;
658: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
659: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
660: EXCEPTION
661: WHEN NO_DATA_FOUND THEN
662: x_return_status := FND_API.G_RET_STS_ERROR;
663: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_MSG_MAP_NOT_FOUND');
661: WHEN NO_DATA_FOUND THEN
662: x_return_status := FND_API.G_RET_STS_ERROR;
663: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_MSG_MAP_NOT_FOUND');
664: FND_MESSAGE.SET_TOKEN('NOTIF', p_notif_name);
665: FND_MSG_PUB.ADD;
666: FND_MSG_PUB.Count_And_Get(p_count=> x_msg_count, p_data => x_msg_data);
667: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
668:
669: WHEN FND_API.G_EXC_ERROR THEN
662: x_return_status := FND_API.G_RET_STS_ERROR;
663: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_MSG_MAP_NOT_FOUND');
664: FND_MESSAGE.SET_TOKEN('NOTIF', p_notif_name);
665: FND_MSG_PUB.ADD;
666: FND_MSG_PUB.Count_And_Get(p_count=> x_msg_count, p_data => x_msg_data);
667: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
668:
669: WHEN FND_API.G_EXC_ERROR THEN
670: x_return_status := FND_API.G_RET_STS_ERROR;
663: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_MSG_MAP_NOT_FOUND');
664: FND_MESSAGE.SET_TOKEN('NOTIF', p_notif_name);
665: FND_MSG_PUB.ADD;
666: FND_MSG_PUB.Count_And_Get(p_count=> x_msg_count, p_data => x_msg_data);
667: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
668:
669: WHEN FND_API.G_EXC_ERROR THEN
670: x_return_status := FND_API.G_RET_STS_ERROR;
671: -- Get message count and data
668:
669: WHEN FND_API.G_EXC_ERROR THEN
670: x_return_status := FND_API.G_RET_STS_ERROR;
671: -- Get message count and data
672: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
673: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
674:
675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
669: WHEN FND_API.G_EXC_ERROR THEN
670: x_return_status := FND_API.G_RET_STS_ERROR;
671: -- Get message count and data
672: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
673: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
674:
675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
677: -- Get message count and data
674:
675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
677: -- Get message count and data
678: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
679: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
680:
681: WHEN OTHERS THEN
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
677: -- Get message count and data
678: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
679: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
680:
681: WHEN OTHERS THEN
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
683: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
679: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
680:
681: WHEN OTHERS THEN
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
683: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
684: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Retrieve_Msg_Mapping');
685: END IF;
686:
687: -- Get message count and data
680:
681: WHEN OTHERS THEN
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
683: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
684: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Retrieve_Msg_Mapping');
685: END IF;
686:
687: -- Get message count and data
688: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
684: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Retrieve_Msg_Mapping');
685: END IF;
686:
687: -- Get message count and data
688: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
689: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
690: END Retrieve_Msg_Mapping;
691:
692: procedure Get_Notif_Metadata
685: END IF;
686:
687: -- Get message count and data
688: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
689: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);
690: END Retrieve_Msg_Mapping;
691:
692: procedure Get_Notif_Metadata
693: (
718: x_msite_id_flag := l_msite_id_flag;
719: x_user_type_flag := l_user_type_flag;
720: x_enabled_flag := l_enabled_flag;
721: x_notif_setup_id := l_notif_setup_id;
722: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
723:
724: EXCEPTION
725: when NO_DATA_FOUND then
726: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_NAME_NOT_FOUND');
724: EXCEPTION
725: when NO_DATA_FOUND then
726: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_NAME_NOT_FOUND');
727: FND_MESSAGE.SET_TOKEN('NAME', p_notification_name);
728: FND_MSG_PUB.ADD;
729: x_return_status := FND_API.G_RET_STS_ERROR;
730: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
731: END Get_Notif_Metadata;
732:
726: FND_MESSAGE.SET_NAME('IBE', 'IBE_WF_NOTIF_NAME_NOT_FOUND');
727: FND_MESSAGE.SET_TOKEN('NAME', p_notification_name);
728: FND_MSG_PUB.ADD;
729: x_return_status := FND_API.G_RET_STS_ERROR;
730: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
731: END Get_Notif_Metadata;
732:
733:
734: END IBE_WF_MSG_MAPPING_PVT;