471: IF x_return_status = FND_API.G_FALSE THEN
472: -- add message to fnd_stack
473: fnd_message.Set_Name('EGO','EGO_GENERIC_MSG_TEXT');
474: fnd_message.set_token('MESSAGE', l_msg_data);
475: fnd_msg_pub.Add;
476: END IF;
477: END IF;
478: ELSE
479: -- add message to fnd_stack for Bug 3352200
476: END IF;
477: END IF;
478: ELSE
479: -- add message to fnd_stack for Bug 3352200
480: FND_MSG_PUB.INITIALIZE;
481: fnd_message.Set_Name('EGO','EGO_DUPLICATE_ROLE_FOR_GRANTEE');
482: fnd_msg_pub.Add;
483: -- end add message to fnd_stack for Bug 3352200
484: x_return_status:='F';
478: ELSE
479: -- add message to fnd_stack for Bug 3352200
480: FND_MSG_PUB.INITIALIZE;
481: fnd_message.Set_Name('EGO','EGO_DUPLICATE_ROLE_FOR_GRANTEE');
482: fnd_msg_pub.Add;
483: -- end add message to fnd_stack for Bug 3352200
484: x_return_status:='F';
485: END IF;
486:
1569: RETURN FND_API.G_TRUE;
1570: END IF;
1571: EXCEPTION
1572: WHEN OTHERS THEN
1573: IF FND_MSG_PUB.Check_Msg_Level
1574: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1575: THEN
1576: FND_MSG_PUB.Add_Exc_Msg
1577: ( G_PKG_NAME ,
1570: END IF;
1571: EXCEPTION
1572: WHEN OTHERS THEN
1573: IF FND_MSG_PUB.Check_Msg_Level
1574: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1575: THEN
1576: FND_MSG_PUB.Add_Exc_Msg
1577: ( G_PKG_NAME ,
1578: l_api_name
1572: WHEN OTHERS THEN
1573: IF FND_MSG_PUB.Check_Msg_Level
1574: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1575: THEN
1576: FND_MSG_PUB.Add_Exc_Msg
1577: ( G_PKG_NAME ,
1578: l_api_name
1579: );
1580: END IF;
2005: END IF;
2006:
2007: EXCEPTION
2008: WHEN OTHERS THEN
2009: IF FND_MSG_PUB.Check_Msg_Level
2010: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2011: THEN
2012: FND_MSG_PUB.Add_Exc_Msg
2013: ( G_PKG_NAME ,
2006:
2007: EXCEPTION
2008: WHEN OTHERS THEN
2009: IF FND_MSG_PUB.Check_Msg_Level
2010: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2011: THEN
2012: FND_MSG_PUB.Add_Exc_Msg
2013: ( G_PKG_NAME ,
2014: l_api_name
2008: WHEN OTHERS THEN
2009: IF FND_MSG_PUB.Check_Msg_Level
2010: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2011: THEN
2012: FND_MSG_PUB.Add_Exc_Msg
2013: ( G_PKG_NAME ,
2014: l_api_name
2015: );
2016: END IF;