201: IF l_member_already_exists THEN
202: x_relationship_id := l_relationship_id;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: x_msg_count := 1;
205: fnd_message.set_name('EGO','EGO_RELATION_EXISTS');
206: fnd_msg_pub.add;
207: ELSE
208: -- Standard Start of API savepoint
209: IF FND_API.TO_BOOLEAN(p_commit) THEN
620: OR p_group_name IS NULL
621: OR p_group_type IS NULL
622: OR p_creator_person_id IS NULL
623: ) THEN
624: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
625: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
626: fnd_msg_pub.add;
627: x_return_status := FND_API.G_RET_STS_ERROR;
628: x_msg_count := 1;
621: OR p_group_type IS NULL
622: OR p_creator_person_id IS NULL
623: ) THEN
624: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
625: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
626: fnd_msg_pub.add;
627: x_return_status := FND_API.G_RET_STS_ERROR;
628: x_msg_count := 1;
629: fnd_msg_pub.Count_And_Get
982: -- OR p_owner_person_id IS NULL
983: OR p_object_version_no_group IS NULL
984: -- OR p_object_version_no_owner_rel IS NULL
985: ) THEN
986: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
987: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
988: fnd_msg_pub.add;
989: x_return_status := FND_API.G_RET_STS_ERROR;
990: x_msg_count := 1;
983: OR p_object_version_no_group IS NULL
984: -- OR p_object_version_no_owner_rel IS NULL
985: ) THEN
986: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
987: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
988: fnd_msg_pub.add;
989: x_return_status := FND_API.G_RET_STS_ERROR;
990: x_msg_count := 1;
991: fnd_msg_pub.Count_And_Get
1390: IF (p_api_version IS NULL
1391: OR p_group_id IS NULL
1392: OR p_object_version_no_group IS NULL
1393: ) THEN
1394: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
1395: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
1396: fnd_msg_pub.add;
1397: x_return_status := FND_API.G_RET_STS_ERROR;
1398: x_msg_count := 1;
1391: OR p_group_id IS NULL
1392: OR p_object_version_no_group IS NULL
1393: ) THEN
1394: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
1395: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
1396: fnd_msg_pub.add;
1397: x_return_status := FND_API.G_RET_STS_ERROR;
1398: x_msg_count := 1;
1399: fnd_msg_pub.Count_And_Get
1660: -- check if all required parameters are passed to the procedure
1661: IF (p_api_version IS NULL
1662: OR p_group_id IS NULL
1663: OR p_member_id IS NULL) THEN
1664: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
1665: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
1666: fnd_msg_pub.add;
1667: x_return_status := FND_API.G_RET_STS_ERROR;
1668: x_msg_count := 1;
1661: IF (p_api_version IS NULL
1662: OR p_group_id IS NULL
1663: OR p_member_id IS NULL) THEN
1664: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
1665: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
1666: fnd_msg_pub.add;
1667: x_return_status := FND_API.G_RET_STS_ERROR;
1668: x_msg_count := 1;
1669: fnd_msg_pub.Count_And_Get
1898: IF (p_api_version IS NULL
1899: OR p_relationship_id IS NULL
1900: OR p_object_version_no_rel IS NULL
1901: ) THEN
1902: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
1903: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
1904: fnd_msg_pub.add;
1905: x_return_status := FND_API.G_RET_STS_ERROR;
1906: x_msg_count := 1;
1899: OR p_relationship_id IS NULL
1900: OR p_object_version_no_rel IS NULL
1901: ) THEN
1902: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
1903: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
1904: fnd_msg_pub.add;
1905: x_return_status := FND_API.G_RET_STS_ERROR;
1906: x_msg_count := 1;
1907: fnd_msg_pub.Count_And_Get
1956: RETURN;
1957: END IF;
1958: ELSE
1959: mdebug('No member id provided!');
1960: FND_MESSAGE.Set_Name('EGO', 'EGO_GRP_MEMB_CANNOT_DELETE');
1961: FND_MSG_PUB.Add;
1962: RAISE fnd_api.g_EXC_ERROR;
1963: END IF;
1964: OPEN get_grant_guid_cur (cp_party_id => l_member_id,
2121: -- check if all required parameters are passed to the procedure
2122: IF (p_api_version IS NULL
2123: OR p_party_id IS NULL
2124: ) THEN
2125: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
2126: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
2127: fnd_msg_pub.add;
2128: x_return_status := FND_API.G_RET_STS_ERROR;
2129: x_msg_count := 1;
2122: IF (p_api_version IS NULL
2123: OR p_party_id IS NULL
2124: ) THEN
2125: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
2126: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
2127: fnd_msg_pub.add;
2128: x_return_status := FND_API.G_RET_STS_ERROR;
2129: x_msg_count := 1;
2130: fnd_msg_pub.Count_And_Get
2184: 1,
2185: Length(l_concat_email_addresses)-2
2186: );
2187: ELSE -- neither PERSON nor GROUP
2188: FND_MESSAGE.Set_Name('EGO', 'EGO_INVALID_PARTY_TYPE');
2189: FND_MSG_PUB.Add;
2190: RAISE fnd_api.g_EXC_ERROR;
2191: END IF;
2192:
2303: -- check if all required parameters are passed to the procedure
2304: IF (p_api_version IS NULL
2305: OR p_party_id IS NULL
2306: ) THEN
2307: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
2308: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
2309: fnd_msg_pub.add;
2310: x_return_status := FND_API.G_RET_STS_ERROR;
2311: x_msg_count := 1;
2304: IF (p_api_version IS NULL
2305: OR p_party_id IS NULL
2306: ) THEN
2307: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
2308: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
2309: fnd_msg_pub.add;
2310: x_return_status := FND_API.G_RET_STS_ERROR;
2311: x_msg_count := 1;
2312: fnd_msg_pub.Count_And_Get
2423: -- check if all required parameters are passed to the procedure
2424: IF (p_api_version IS NULL
2425: OR p_party_id IS NULL
2426: ) THEN
2427: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
2428: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
2429: fnd_msg_pub.add;
2430: x_return_status := FND_API.G_RET_STS_ERROR;
2431: x_msg_count := 1;
2424: IF (p_api_version IS NULL
2425: OR p_party_id IS NULL
2426: ) THEN
2427: fnd_message.set_name('EGO','EGO_MAND_PARAM_MISSING');
2428: fnd_message.set_token('PROGRAM', G_PKG_NAME || l_api_name);
2429: fnd_msg_pub.add;
2430: x_return_status := FND_API.G_RET_STS_ERROR;
2431: x_msg_count := 1;
2432: fnd_msg_pub.Count_And_Get