DBA Data[Home] [Help]

APPS.CSM_GROUP_DOWNLOAD_PUB dependencies on FND_LOG

Line 46: CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PUB.ASSIGN_RELATED_GROUP Package ', 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_RELATED_GROUP',FND_LOG.LEVEL_EXCEPTION);

42: AND au.enabled = 'Y';
43:
44: BEGIN
45:
46: CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PUB.ASSIGN_RELATED_GROUP Package ', 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_RELATED_GROUP',FND_LOG.LEVEL_EXCEPTION);
47:
48: IF FND_API.TO_BOOLEAN (p_init_msg_list)
49:
50: THEN

Line 159: CSM_UTIL_PKG.LOG('Value for p_operation is NULL', 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_RELATED_GROUP',FND_LOG.LEVEL_EXCEPTION);

155: IF p_operation IS NULL
156:
157: THEN
158:
159: CSM_UTIL_PKG.LOG('Value for p_operation is NULL', 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_RELATED_GROUP',FND_LOG.LEVEL_EXCEPTION);
160:
161: END IF;
162:
163:

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

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:
187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 196: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_RELATED_GROUP',FND_LOG.LEVEL_EXCEPTION);

192: ( p_count => x_msg_count,
193: p_data => l_msg_data );
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
195: x_error_message := x_error_message || ' - the error message is :'||l_msg_data;
196: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_RELATED_GROUP',FND_LOG.LEVEL_EXCEPTION);
197:
198: WHEN OTHERS
199:
200: THEN

Line 213: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_RELATED_GROUP',FND_LOG.LEVEL_EXCEPTION);

209: ( p_count => x_msg_count,
210: p_data => l_msg_data );
211: x_error_message := 'Exception in CSM_GROUP_DOWNLOAD_PUB.ASSIGN_RELATED_GROUP Procedure :'||'while processing the group -'
212: ||p_group_id|| 'and related group:'||p_related_group_id||':' || l_sqlerrno || ':' || l_sqlerrmsg ||'the error message is :' || l_msg_data;
213: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_RELATED_GROUP',FND_LOG.LEVEL_EXCEPTION);
214:
215: END assign_related_group;
216:
217: PROCEDURE assign_mutiple_related_groups

Line 261: CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PUB.ASSIGN_MUTIPLE_RELATED_GROUPS Package ', 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_RELATED_GROUP',FND_LOG.LEVEL_EXCEPTION);

257: AND au.enabled = 'Y';
258:
259: BEGIN
260:
261: CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PUB.ASSIGN_MUTIPLE_RELATED_GROUPS Package ', 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_RELATED_GROUP',FND_LOG.LEVEL_EXCEPTION);
262:
263: IF FND_API.TO_BOOLEAN (p_init_msg_list)
264:
265: THEN

Line 392: CSM_UTIL_PKG.LOG('Value for p_operation is NULL', 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_MUTIPLE_RELATED_GROUPS',FND_LOG.LEVEL_EXCEPTION);

388: IF p_operation IS NULL
389:
390: THEN
391:
392: CSM_UTIL_PKG.LOG('Value for p_operation is NULL', 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_MUTIPLE_RELATED_GROUPS',FND_LOG.LEVEL_EXCEPTION);
393:
394: END IF;
395:
396: IF (csr_grp_owner_id%ISOPEN)

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

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:
419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 429: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_MUTIPLE_RELATED_GROUPS',FND_LOG.LEVEL_EXCEPTION);

425: p_data => l_msg_data );
426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
427: ROLLBACK;
428: x_error_message := x_error_message || ' - the error message is :'||l_msg_data;
429: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_MUTIPLE_RELATED_GROUPS',FND_LOG.LEVEL_EXCEPTION);
430:
431: WHEN OTHERS
432:
433: THEN

Line 447: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_MUTIPLE_RELATED_GROUPS',FND_LOG.LEVEL_EXCEPTION);

443: ( p_count => x_msg_count,
444: p_data => l_msg_data );
445: x_error_message := 'Exception in CSM_GROUP_DOWNLOAD_PUB.ASSIGN_MUTIPLE_RELATED_GROUPS Procedure :'||'while processing the group -'
446: ||p_group_id|| 'and related group:'||l_rel_group_id|| ':' || l_sqlerrno || ':' || l_sqlerrmsg ||'the error message is :' || l_msg_data;
447: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_GROUP_DOWNLOAD_PUB.ASSIGN_MUTIPLE_RELATED_GROUPS',FND_LOG.LEVEL_EXCEPTION);
448:
449: END assign_mutiple_related_groups;
450:
451: PROCEDURE get_related_groups

Line 487: CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PUB.GET_RELATED_GROUPS PACKAGE ', 'CSM_GROUP_DOWNLOAD_PUB.GET_RELATED_GROUPS',FND_LOG.LEVEL_EXCEPTION);

483: AND acc.group_owner_id <> acc.user_id;
484:
485: BEGIN
486:
487: CSM_UTIL_PKG.LOG('Entering CSM_GROUP_DOWNLOAD_PUB.GET_RELATED_GROUPS PACKAGE ', 'CSM_GROUP_DOWNLOAD_PUB.GET_RELATED_GROUPS',FND_LOG.LEVEL_EXCEPTION);
488:
489: IF FND_API.TO_BOOLEAN (p_init_msg_list)
490:
491: THEN

Line 564: CSM_UTIL_PKG.LOG('Leaving CSM_GROUP_DOWNLOAD_PUB.GET_RELATED_GROUPS Package ', 'CSM_GROUP_DOWNLOAD_PUB.GET_RELATED_GROUPS',FND_LOG.LEVEL_EXCEPTION);

560:
561: x_return_status := FND_API.G_RET_STS_SUCCESS;
562: x_msg_count := 0;
563: x_error_message := 'The related groups for the group id are fetched successfully';
564: CSM_UTIL_PKG.LOG('Leaving CSM_GROUP_DOWNLOAD_PUB.GET_RELATED_GROUPS Package ', 'CSM_GROUP_DOWNLOAD_PUB.GET_RELATED_GROUPS',FND_LOG.LEVEL_EXCEPTION);
565:
566: EXCEPTION
567:
568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 578: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_GROUP_DOWNLOAD_PUB.GET_RELATED_GROUPS',FND_LOG.LEVEL_EXCEPTION);

574: p_count => x_msg_count,
575: p_data => l_msg_data );
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
577: x_error_message := l_error_message || ' - the error message is :'||l_msg_data;
578: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_GROUP_DOWNLOAD_PUB.GET_RELATED_GROUPS',FND_LOG.LEVEL_EXCEPTION);
579:
580: WHEN OTHERS
581:
582: THEN

Line 595: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_GROUP_DOWNLOAD_PUB.GET_RELATED_GROUPS',FND_LOG.LEVEL_EXCEPTION);

591: ( p_count => x_msg_count,
592: p_data => l_msg_data );
593: x_error_message := 'Exception in CSM_GROUP_DOWNLOAD_PUB.GET_RELATED_GROUPS Procedure :'||'while fetching the related groups for the group -'
594: ||p_group_id ||':' || l_sqlerrno || ':' || l_sqlerrmsg ||'the error message is :' || l_msg_data;
595: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_GROUP_DOWNLOAD_PUB.GET_RELATED_GROUPS',FND_LOG.LEVEL_EXCEPTION);
596:
597: END get_related_groups;
598:
599: END CSM_GROUP_DOWNLOAD_PUB;