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_PARTY_DOWNLOAD_PUB dependencies on FND_MSG_PUB

Line 39: FND_MSG_PUB.INITIALIZE;

35: IF FND_API.TO_BOOLEAN (p_init_msg_list)
36:
37: THEN
38:
39: FND_MSG_PUB.INITIALIZE;
40:
41: END IF;
42:
43: OPEN csr_owner_id (p_user_id);

Line 52: FND_MSG_PUB.ADD;

48: THEN
49:
50: FND_MESSAGE.SET_NAME ('CSM', 'CSM_OWNER_NOT_FOUND');
51:
52: FND_MSG_PUB.ADD;
53:
54: l_error_message := 'NO owner found for the given user - '||p_user_id;
55:
56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 127: FND_MSG_PUB.COUNT_AND_GET

123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
124:
125: THEN
126:
127: FND_MSG_PUB.COUNT_AND_GET
128: ( p_count => x_msg_count,
129: p_data => l_msg_data );
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131: x_error_message := l_error_message || ' - the error message is :'||l_msg_data;

Line 140: FND_MSG_PUB.ADD;

136: THEN
137:
138: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_UNKNOWN_ERROR');
139: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
140: FND_MSG_PUB.ADD;
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: l_sqlerrno := TO_CHAR(SQLCODE);
143: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
144: FND_MSG_PUB.COUNT_AND_GET

Line 144: FND_MSG_PUB.COUNT_AND_GET

140: FND_MSG_PUB.ADD;
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: l_sqlerrno := TO_CHAR(SQLCODE);
143: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
144: FND_MSG_PUB.COUNT_AND_GET
145: ( p_count => x_msg_count,
146: p_data => l_msg_data );
147: x_error_message := 'Exception in CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_TO_USER Procedure :'||'while processing the party -'
148: ||p_party_id|| 'for the user -'||p_user_id ||':' || l_sqlerrno || ':' || l_sqlerrmsg ||'the error message is :' || l_msg_data;

Line 192: FND_MSG_PUB.INITIALIZE;

188: IF FND_API.TO_BOOLEAN (p_init_msg_list)
189:
190: THEN
191:
192: FND_MSG_PUB.INITIALIZE;
193:
194: END IF;
195:
196: IF l_party_id_tbl.COUNT > 0

Line 233: FND_MSG_PUB.ADD;

229: THEN
230:
231: FND_MESSAGE.SET_NAME ('CSM', 'CSM_OWNER_NOT_FOUND');
232:
233: FND_MSG_PUB.ADD;
234:
235: l_error_message := 'NO owner found for the given user - '||l_user_id;
236:
237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 312: FND_MSG_PUB.COUNT_AND_GET

308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
309:
310: THEN
311:
312: FND_MSG_PUB.COUNT_AND_GET
313: ( p_count => x_msg_count,
314: p_data => l_msg_data );
315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
316: x_error_message := l_error_message || ' - the error message is :'||l_msg_data;

Line 326: FND_MSG_PUB.ADD;

322: THEN
323:
324: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_UNKNOWN_ERROR');
325: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
326: FND_MSG_PUB.ADD;
327: ROLLBACK;
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
329: l_sqlerrno := TO_CHAR(SQLCODE);
330: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);

Line 331: FND_MSG_PUB.COUNT_AND_GET

327: ROLLBACK;
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
329: l_sqlerrno := TO_CHAR(SQLCODE);
330: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
331: FND_MSG_PUB.COUNT_AND_GET
332: ( p_count => x_msg_count,
333: p_data => l_msg_data );
334: x_error_message := 'Exception in CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_TO_USERS Procedure :'||'while processing the party -'
335: ||l_party_id|| 'for the user -'||l_user_id ||':' || l_sqlerrno || ':' || l_sqlerrmsg ||'the error message is :' || l_msg_data;

Line 375: FND_MSG_PUB.INITIALIZE;

371: IF FND_API.TO_BOOLEAN (p_init_msg_list)
372:
373: THEN
374:
375: FND_MSG_PUB.INITIALIZE;
376:
377: END IF;
378:
379: OPEN csr_owner_id (p_user_id);

Line 388: FND_MSG_PUB.ADD;

384: THEN
385:
386: FND_MESSAGE.SET_NAME ('CSM', 'CSM_OWNER_NOT_FOUND');
387:
388: FND_MSG_PUB.ADD;
389:
390: l_error_message := 'NO owner found for the given user - '||p_user_id;
391:
392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 463: FND_MSG_PUB.COUNT_AND_GET

459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
460:
461: THEN
462:
463: FND_MSG_PUB.COUNT_AND_GET
464: ( p_count => x_msg_count,
465: p_data => l_msg_data );
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
467: x_error_message := l_error_message || ' - the error message is :'||l_msg_data;

Line 476: FND_MSG_PUB.ADD;

472: THEN
473:
474: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_UNKNOWN_ERROR');
475: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
476: FND_MSG_PUB.ADD;
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: l_sqlerrno := TO_CHAR(SQLCODE);
479: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
480: FND_MSG_PUB.COUNT_AND_GET

Line 480: FND_MSG_PUB.COUNT_AND_GET

476: FND_MSG_PUB.ADD;
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: l_sqlerrno := TO_CHAR(SQLCODE);
479: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
480: FND_MSG_PUB.COUNT_AND_GET
481: ( p_count => x_msg_count,
482: p_data => l_msg_data );
483: x_error_message := 'Exception in CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_LOC_TO_USER Procedure :'||'while processing the party -'
484: ||p_party_id|| 'for the user -'||p_user_id ||':' || l_sqlerrno || ':' || l_sqlerrmsg ||'the error message is :' || l_msg_data;

Line 531: FND_MSG_PUB.INITIALIZE;

527: IF FND_API.TO_BOOLEAN (p_init_msg_list)
528:
529: THEN
530:
531: FND_MSG_PUB.INITIALIZE;
532:
533: END IF;
534:
535: IF l_party_site_id_tbl.COUNT > 0

Line 574: FND_MSG_PUB.ADD;

570: THEN
571:
572: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_OWNER_NOT_FOUND');
573:
574: FND_MSG_PUB.ADD;
575:
576: l_error_message := 'NO owner found for the given user - '||l_user_id;
577:
578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 653: FND_MSG_PUB.COUNT_AND_GET

649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
650:
651: THEN
652:
653: FND_MSG_PUB.COUNT_AND_GET
654: ( p_count => x_msg_count,
655: p_data => l_msg_data );
656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
657: x_error_message := l_error_message || ' - the error message is :'||l_msg_data;

Line 667: FND_MSG_PUB.ADD;

663: THEN
664:
665: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_UNKNOWN_ERROR');
666: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
667: FND_MSG_PUB.ADD;
668: ROLLBACK;
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: l_sqlerrno := TO_CHAR(SQLCODE);
671: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);

Line 672: FND_MSG_PUB.COUNT_AND_GET

668: ROLLBACK;
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: l_sqlerrno := TO_CHAR(SQLCODE);
671: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
672: FND_MSG_PUB.COUNT_AND_GET
673: ( p_count => x_msg_count,
674: p_data => l_msg_data );
675: x_error_message := 'Exception in CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_LOC_TO_USER Procedure :'||'while processing the party -'
676: ||l_party_id|| 'for the user -'||l_user_id ||':' || l_sqlerrno || ':' || l_sqlerrmsg ||'the error message is :' || l_msg_data;

Line 717: FND_MSG_PUB.INITIALIZE;

713: IF FND_API.TO_BOOLEAN (p_init_msg_list)
714:
715: THEN
716:
717: FND_MSG_PUB.INITIALIZE;
718:
719: END IF;
720:
721: OPEN csr_get_party_id (p_user_id);

Line 739: FND_MSG_PUB.ADD;

735: THEN
736:
737: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_FOR_USER_NOT_FOUND');
738:
739: FND_MSG_PUB.ADD;
740:
741: l_error_message := 'NO Data found for the given user - '||p_user_id;
742:
743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 770: FND_MSG_PUB.COUNT_AND_GET

766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
767:
768: THEN
769:
770: FND_MSG_PUB.COUNT_AND_GET
771: ( p_encoded => 'T',
772: p_count => x_msg_count,
773: p_data => l_msg_data );
774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 784: FND_MSG_PUB.ADD;

780: THEN
781:
782: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_UNKNOWN_ERROR');
783: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
784: FND_MSG_PUB.ADD;
785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
786: l_sqlerrno := TO_CHAR(SQLCODE);
787: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
788: FND_MSG_PUB.COUNT_AND_GET

Line 788: FND_MSG_PUB.COUNT_AND_GET

784: FND_MSG_PUB.ADD;
785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
786: l_sqlerrno := TO_CHAR(SQLCODE);
787: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
788: FND_MSG_PUB.COUNT_AND_GET
789: ( p_count => x_msg_count,
790: p_data => l_msg_data );
791: x_error_message := 'Exception in CSM_PARTY_DOWNLOAD_PUB.GET_PARTIES_FOR_USER Procedure :'||'while fetching the parties for the user -'
792: ||p_user_id ||':' || l_sqlerrno || ':' || l_sqlerrmsg ||'the error message is :' || l_msg_data;

Line 836: FND_MSG_PUB.INITIALIZE;

832: IF FND_API.TO_BOOLEAN (p_init_msg_list)
833:
834: THEN
835:
836: FND_MSG_PUB.INITIALIZE;
837:
838: END IF;
839:
840: OPEN csr_get_party_site_id (p_user_id, p_party_id);

Line 858: FND_MSG_PUB.ADD;

854: THEN
855:
856: FND_MESSAGE.SET_NAME ('CSM', 'CSM_SITE_FOR_USER_NOT_FOUND');
857:
858: FND_MSG_PUB.ADD;
859:
860: l_error_message := 'NO Data found for the given user - '||p_user_id;
861:
862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 889: FND_MSG_PUB.COUNT_AND_GET

885: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
886:
887: THEN
888:
889: FND_MSG_PUB.COUNT_AND_GET
890: ( p_count => x_msg_count,
891: p_data => l_msg_data );
892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
893: x_error_message := l_error_message || ' - the error message is :'||l_msg_data;

Line 902: FND_MSG_PUB.ADD;

898: THEN
899:
900: FND_MESSAGE.SET_NAME ('CSM', 'CSM_PARTY_ASSIGN_UNKNOWN_ERROR');
901: FND_MESSAGE.SET_TOKEN ('P_TEXT', SQLCODE || SQLERRM);
902: FND_MSG_PUB.ADD;
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
904: l_sqlerrno := TO_CHAR(SQLCODE);
905: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
906: FND_MSG_PUB.COUNT_AND_GET

Line 906: FND_MSG_PUB.COUNT_AND_GET

902: FND_MSG_PUB.ADD;
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
904: l_sqlerrno := TO_CHAR(SQLCODE);
905: l_sqlerrmsg := SUBSTR(SQLERRM, 1,2000);
906: FND_MSG_PUB.COUNT_AND_GET
907: ( p_count => x_msg_count,
908: p_data => l_msg_data );
909: x_error_message := 'Exception in CSM_PARTY_DOWNLOAD_PUB.GET_PARTY_LOCATIONS_FOR_USER Procedure :'||'while fetching the parties and party sites for the user -'
910: ||p_user_id ||':' || l_sqlerrno || ':' || l_sqlerrmsg ||'the error message is :' || l_msg_data;