eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_GROUP_DOWNLOAD_PUB dependencies on FND_MSG_PUB

Line 52: FND_MSG_PUB.INITIALIZE;

48: IF FND_API.TO_BOOLEAN (p_init_msg_list)
49:
50: THEN
51:
52: FND_MSG_PUB.INITIALIZE;
53:
54: END IF;
55:
56: OPEN csr_grp_owner_id (p_group_id);

Line 65: FND_MSG_PUB.ADD;

61: THEN
62:
63: FND_MESSAGE.SET_NAME ('CSM', 'CSM_OWNER_NOT_FOUND');
64:
65: FND_MSG_PUB.ADD;
66:
67: x_error_message := 'NO owner found for the given group - '||p_group_id;
68:
69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 191: FND_MSG_PUB.COUNT_AND_GET

187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
188:
189: THEN
190:
191: FND_MSG_PUB.COUNT_AND_GET
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;

Line 204: FND_MSG_PUB.ADD;

200: THEN
201:
202: FND_MESSAGE.SET_NAME ('CSM', 'CSM_GROUP_DWNLD_UNKNOWN_ERROR');
203: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
204: FND_MSG_PUB.ADD;
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
206: l_sqlerrno := TO_CHAR(SQLCODE);
207: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
208: FND_MSG_PUB.COUNT_AND_GET

Line 208: FND_MSG_PUB.COUNT_AND_GET

204: FND_MSG_PUB.ADD;
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
206: l_sqlerrno := TO_CHAR(SQLCODE);
207: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
208: FND_MSG_PUB.COUNT_AND_GET
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;

Line 267: FND_MSG_PUB.INITIALIZE;

263: IF FND_API.TO_BOOLEAN (p_init_msg_list)
264:
265: THEN
266:
267: FND_MSG_PUB.INITIALIZE;
268:
269: END IF;
270:
271: OPEN csr_grp_owner_id (p_group_id);

Line 280: FND_MSG_PUB.ADD;

276: THEN
277:
278: FND_MESSAGE.SET_NAME ('CSM', 'CSM_OWNER_NOT_FOUND');
279:
280: FND_MSG_PUB.ADD;
281:
282: x_error_message := 'NO owner found for the given group - '||p_group_id;
283:
284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 423: FND_MSG_PUB.COUNT_AND_GET

419: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
420:
421: THEN
422:
423: FND_MSG_PUB.COUNT_AND_GET
424: ( p_count => x_msg_count,
425: p_data => l_msg_data );
426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
427: ROLLBACK;

Line 437: FND_MSG_PUB.ADD;

433: THEN
434:
435: FND_MESSAGE.SET_NAME ('CSM', 'CSM_GROUP_DWNLD_UNKNOWN_ERROR');
436: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
437: FND_MSG_PUB.ADD;
438: ROLLBACK;
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440: l_sqlerrno := TO_CHAR(SQLCODE);
441: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);

Line 442: FND_MSG_PUB.COUNT_AND_GET

438: ROLLBACK;
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440: l_sqlerrno := TO_CHAR(SQLCODE);
441: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
442: FND_MSG_PUB.COUNT_AND_GET
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;

Line 493: FND_MSG_PUB.INITIALIZE;

489: IF FND_API.TO_BOOLEAN (p_init_msg_list)
490:
491: THEN
492:
493: FND_MSG_PUB.INITIALIZE;
494:
495: END IF;
496:
497: OPEN csr_get_owner_id (p_group_id);

Line 506: FND_MSG_PUB.ADD;

502: THEN
503:
504: FND_MESSAGE.SET_NAME ('CSM', 'CSM_OWNER_NOT_FOUND');
505:
506: FND_MSG_PUB.ADD;
507:
508: l_error_message := 'NO Data found for the given group - '||p_group_id;
509:
510: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 533: FND_MSG_PUB.ADD;

529: THEN
530:
531: FND_MESSAGE.SET_NAME ('CSM', 'CSM_REL_GROUPS_NOT_FOUND');
532:
533: FND_MSG_PUB.ADD;
534:
535: x_error_message := 'NO related groups for the given group id - '||p_group_id;
536:
537: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 572: FND_MSG_PUB.COUNT_AND_GET

568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
569:
570: THEN
571:
572: FND_MSG_PUB.COUNT_AND_GET
573: ( p_encoded => 'T',
574: p_count => x_msg_count,
575: p_data => l_msg_data );
576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 586: FND_MSG_PUB.ADD;

582: THEN
583:
584: FND_MESSAGE.SET_NAME ('CSM', 'CSM_GROUP_UNKNOWN_ERROR');
585: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
586: FND_MSG_PUB.ADD;
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: l_sqlerrno := TO_CHAR(SQLCODE);
589: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
590: FND_MSG_PUB.COUNT_AND_GET

Line 590: FND_MSG_PUB.COUNT_AND_GET

586: FND_MSG_PUB.ADD;
587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
588: l_sqlerrno := TO_CHAR(SQLCODE);
589: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
590: FND_MSG_PUB.COUNT_AND_GET
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;