98:
99: x_return_status := FND_API.G_RET_STS_SUCCESS;
100:
101:
102: FND_MSG_PUB.Count_And_Get
103: ( p_count => x_msg_count,
104: p_data => x_msg_data
105: );
106: EXCEPTION
126: WHEN FND_API.G_EXC_ERROR THEN
127: ROLLBACK TO DOM_ADD_OFO_GROUP_MEMBER;
128: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_ERROR''');
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: FND_MSG_PUB.Count_And_Get
131: ( p_count => x_msg_count,
132: p_data => x_msg_data
133: );
134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
135: ROLLBACK TO EGO_CREATE_RELATIONSHIP;
136: mdebug('. CREATE_RELATIONSHIP: Ending : Returning ''FND_API.G_EXC_UNEXPECTED_ERROR''');
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
138: FND_MSG_PUB.Count_And_Get
139: ( p_count => x_msg_count,
140: p_data => x_msg_data
141: );
142: WHEN OTHERS THEN
140: p_data => x_msg_data
141: );
142: WHEN OTHERS THEN
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
144: IF FND_MSG_PUB.Check_Msg_Level
145: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
146: THEN
147: FND_MSG_PUB.Add_Exc_Msg
148: ( G_PKG_NAME,
141: );
142: WHEN OTHERS THEN
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
144: IF FND_MSG_PUB.Check_Msg_Level
145: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
146: THEN
147: FND_MSG_PUB.Add_Exc_Msg
148: ( G_PKG_NAME,
149: l_api_name
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
144: IF FND_MSG_PUB.Check_Msg_Level
145: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
146: THEN
147: FND_MSG_PUB.Add_Exc_Msg
148: ( G_PKG_NAME,
149: l_api_name
150: );
151: END IF;
148: ( G_PKG_NAME,
149: l_api_name
150: );
151: END IF;
152: FND_MSG_PUB.Count_And_Get
153: ( p_count => x_msg_count,
154: p_data => x_msg_data
155: );
156: mdebug (SQLERRM);
257: END IF;
258: -- Initialize API message list if necessary.
259: -- Initialize message list if p_init_msg_list is set to TRUE.
260: IF FND_API.to_Boolean( NVL(p_init_msg_list, 'F') ) THEN
261: FND_MSG_PUB.initialize;
262: END IF;
263:
264: mdebug(' in DOM WS interface ' || p_group_id || ' ' || p_member_id);
265: