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