77: THEN
78:
79: --calling the package to insert records into CSM_GROUPS table
80:
81: csm_group_download_pvt.insert_my_group
82: ( P_USER_ID => l_owner_id,
83: X_RETURN_STATUS => l_return_status,
84: X_ERROR_MESSAGE => l_error_message);
85:
88: THEN
89:
90: --calling the package to delete records from CSM_GROUPS table
91:
92: csm_group_download_pvt.delete_my_group
93: ( P_USER_ID => l_owner_id,
94: X_RETURN_STATUS => l_return_status,
95: X_ERROR_MESSAGE => l_error_message);
96:
119: THEN
120:
121: --calling the package to insert Related groups records into CSM_GROUPS table
122:
123: csm_group_download_pvt.insert_group_acc
124: ( P_USER_ID => l_rel_user_id,
125: P_GROUP_ID => p_related_group_id,
126: P_OWNER_ID => l_rel_owner_id,
127: P_GROUP_TYPE => l_rel_grp_type,
133: THEN
134:
135: --calling the package to insert Related groups records into CSM_GROUPS table
136:
137: csm_group_download_pvt.delete_group_acc
138: ( P_USER_ID => l_rel_user_id,
139: P_GROUP_ID => p_related_group_id,
140: X_RETURN_STATUS => l_rel_return_status,
141: X_ERROR_MESSAGE => l_rel_error_message);
178: END IF;
179:
180: x_return_status := FND_API.G_RET_STS_SUCCESS;
181: x_msg_count := 0;
182: x_error_message := 'Downloading related group to a group through CSM_GROUP_DOWNLOAD_PVT is done successfully';
183: CSM_UTIL_PKG.LOG('Leaving CSM_GROUP_DOWNLOAD_PUB.ASSIGN_RELATED_GROUP Package ', 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_RELATED_GROUP ',FND_LOG.LEVEL_EXCEPTION);
184:
185: EXCEPTION
186:
292: THEN
293:
294: --calling the package to insert records into CSM_GROUPS table
295:
296: csm_group_download_pvt.insert_my_group
297: ( P_USER_ID => l_owner_id,
298: X_RETURN_STATUS => l_return_status,
299: X_ERROR_MESSAGE => l_error_message);
300:
303: THEN
304:
305: --calling the package to delete records from CSM_GROUPS table
306:
307: csm_group_download_pvt.delete_my_group
308: ( P_USER_ID => l_owner_id,
309: X_RETURN_STATUS => l_return_status,
310: X_ERROR_MESSAGE => l_error_message);
311:
348: THEN
349:
350: --calling the package to insert Related groups records into CSM_GROUPS table
351:
352: csm_group_download_pvt.insert_group_acc
353: ( P_USER_ID => l_rel_user_id,
354: P_GROUP_ID => l_rel_group_id,
355: P_OWNER_ID => l_rel_owner_id,
356: P_GROUP_TYPE => l_rel_grp_type,
362: THEN
363:
364: --calling the package to insert Related groups records into CSM_GROUPS table
365:
366: csm_group_download_pvt.delete_group_acc
367: ( P_USER_ID => l_rel_user_id,
368: P_GROUP_ID => l_rel_group_id,
369: X_RETURN_STATUS => l_rel_return_status,
370: X_ERROR_MESSAGE => l_rel_error_message);
410: END IF;
411:
412: x_return_status := FND_API.G_RET_STS_SUCCESS;
413: x_msg_count := 0;
414: x_error_message := 'Downloading related group to a group through CSM_GROUP_DOWNLOAD_PVT is done successfully';
415: CSM_UTIL_PKG.LOG('Leaving CSM_GROUP_DOWNLOAD_PUB.ASSIGN_MUTIPLE_RELATED_GROUPS Package ', 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_MUTIPLE_RELATED_GROUPS ',FND_LOG.LEVEL_EXCEPTION);
416:
417: EXCEPTION
418: