DBA Data[Home] [Help]

APPS.IBE_WF_MSG_MAPPING_PVT dependencies on FND_API

Line 537: if( l_return_status = FND_API.G_RET_STS_ERROR ) then

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;

Line 538: raise FND_API.G_EXC_ERROR;

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:

Line 539: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then

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');

Line 540: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 660: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 662: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

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');

Line 665: x_return_status := FND_API.G_RET_STS_ERROR;

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);

Line 670: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

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

Line 672: WHEN FND_API.G_EXC_ERROR THEN

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);

Line 673: x_return_status := FND_API.G_RET_STS_ERROR;

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:

Line 676: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

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

Line 678: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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);

Line 679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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:

Line 682: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

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

Line 685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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:

Line 692: x_msg_data := FND_MSG_PUB.GET(1, FND_API.G_FALSE);

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: (

Line 719: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;

Line 732: x_return_status := FND_API.G_RET_STS_ERROR;

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: