DBA Data[Home] [Help]

APPS.IBE_WF_MSG_MAPPING_PVT dependencies on FND_API

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

530: x_msite_id_flag => l_msite_id_flag,
531: x_user_type_flag => l_user_type_flag,
532: x_enabled_flag => l_menabled_flag);
533:
534: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
535: raise FND_API.G_EXC_ERROR;
536: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
537: raise FND_API.G_EXC_UNEXPECTED_ERROR;
538: end if;

Line 535: raise FND_API.G_EXC_ERROR;

531: x_user_type_flag => l_user_type_flag,
532: x_enabled_flag => l_menabled_flag);
533:
534: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
535: raise FND_API.G_EXC_ERROR;
536: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
537: raise FND_API.G_EXC_UNEXPECTED_ERROR;
538: end if;
539:

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

532: x_enabled_flag => l_menabled_flag);
533:
534: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
535: raise FND_API.G_EXC_ERROR;
536: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
537: raise FND_API.G_EXC_UNEXPECTED_ERROR;
538: end if;
539:
540: debug('retrieve_msg_mapping 2');

Line 537: raise FND_API.G_EXC_UNEXPECTED_ERROR;

533:
534: if( l_return_status = FND_API.G_RET_STS_ERROR ) then
535: raise FND_API.G_EXC_ERROR;
536: elsif( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) then
537: raise FND_API.G_EXC_UNEXPECTED_ERROR;
538: end if;
539:
540: debug('retrieve_msg_mapping 2');
541:

Line 657: x_return_status := FND_API.G_RET_STS_SUCCESS;

653: END;
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

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

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

Line 662: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 669: WHEN FND_API.G_EXC_ERROR THEN

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

Line 670: x_return_status := FND_API.G_RET_STS_ERROR;

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

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

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

Line 675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 676: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

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

Line 682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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
684: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,'Retrieve_Msg_Mapping');
685: END IF;
686:

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

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

Line 716: x_return_status := FND_API.G_RET_STS_SUCCESS;

712: into l_org_id_flag, l_msite_id_flag, l_enabled_flag, l_notif_setup_id, l_user_type_flag
713: from ibe_wf_notif_setup
714: where notification_name = p_notification_name;
715:
716: x_return_status := FND_API.G_RET_STS_SUCCESS;
717: x_org_id_flag := l_org_id_flag;
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;

Line 729: x_return_status := FND_API.G_RET_STS_ERROR;

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