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_API

Line 6: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,

2: /* $Header: csmpptdb.pls 120.7 2008/02/29 09:06:26 anaraman noship $*/
3:
4: PROCEDURE assign_cust_to_user
5: ( p_api_version_number IN NUMBER,
6: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
7: p_user_id IN NUMBER,
8: p_party_id IN NUMBER,
9: p_operation IN VARCHAR2,
10: x_msg_count OUT NOCOPY NUMBER,

Line 35: IF FND_API.TO_BOOLEAN (p_init_msg_list)

31: BEGIN
32:
33: CSM_UTIL_PKG.LOG('Entering CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_TO_USER Package ', 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_TO_USER',FND_LOG.LEVEL_EXCEPTION);
34:
35: IF FND_API.TO_BOOLEAN (p_init_msg_list)
36:
37: THEN
38:
39: FND_MSG_PUB.INITIALIZE;

Line 56: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
57:
58: END IF;
59:
60: CLOSE csr_owner_id;

Line 92: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS)

88: X_ERROR_MESSAGE => l_error_message);
89:
90: END IF;
91:
92: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS)
93:
94: THEN
95:
96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

92: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS)
93:
94: THEN
95:
96: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
97:
98: END IF;
99:
100: IF p_operation IS NULL

Line 116: x_return_status := FND_API.G_RET_STS_SUCCESS;

112: CLOSE csr_owner_id;
113:
114: END IF;
115:
116: x_return_status := FND_API.G_RET_STS_SUCCESS;
117: x_msg_count := 0;
118: x_error_message := 'Assigning customer to single user through CSM_PARTY_ASSIGNMENT_PKG is done successfully';
119: CSM_UTIL_PKG.LOG('Leaving CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_TO_USER Package ', 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_TO_USER ',FND_LOG.LEVEL_EXCEPTION);
120:

Line 123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

119: CSM_UTIL_PKG.LOG('Leaving CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_TO_USER Package ', 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_TO_USER ',FND_LOG.LEVEL_EXCEPTION);
120:
121: EXCEPTION
122:
123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
124:
125: THEN
126:
127: FND_MSG_PUB.COUNT_AND_GET

Line 130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
132: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_TO_USER',FND_LOG.LEVEL_EXCEPTION);
133:
134: WHEN OTHERS

Line 141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
145: ( p_count => x_msg_count,

Line 155: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,

151: END assign_cust_to_user;
152:
153: PROCEDURE assign_mul_cust_to_users
154: ( p_api_version_number IN NUMBER,
155: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
156: p_user_id_lst IN l_user_id_tbl_type,
157: p_party_id_lst IN l_party_id_tbl_type,
158: p_operation IN VARCHAR2,
159: x_msg_count OUT NOCOPY NUMBER,

Line 188: IF FND_API.TO_BOOLEAN (p_init_msg_list)

184: BEGIN
185:
186: CSM_UTIL_PKG.LOG('Entering CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_TO_USERS Package ', 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_TO_USERS',FND_LOG.LEVEL_EXCEPTION);
187:
188: IF FND_API.TO_BOOLEAN (p_init_msg_list)
189:
190: THEN
191:
192: FND_MSG_PUB.INITIALIZE;

Line 237: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
238:
239: END IF;
240:
241: CLOSE csr_owner_id;

Line 273: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS)

269: X_ERROR_MESSAGE => l_error_message);
270:
271: END IF;
272:
273: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS)
274:
275: THEN
276:
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

273: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS)
274:
275: THEN
276:
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
278:
279: END IF;
280:
281: END LOOP;

Line 301: x_return_status := FND_API.G_RET_STS_SUCCESS;

297: CLOSE csr_owner_id;
298:
299: END IF;
300:
301: x_return_status := FND_API.G_RET_STS_SUCCESS;
302: x_msg_count := 0;
303: x_error_message := 'Assigning multiple customers to multiple users through CSM_PARTY_ASSIGNMENT_PKG is done successfully';
304: CSM_UTIL_PKG.LOG('Leaving CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_TO_USERS Package ', 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_TO_USERS ',FND_LOG.LEVEL_EXCEPTION);
305:

Line 308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

304: CSM_UTIL_PKG.LOG('Leaving CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_TO_USERS Package ', 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_TO_USERS ',FND_LOG.LEVEL_EXCEPTION);
305:
306: EXCEPTION
307:
308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
309:
310: THEN
311:
312: FND_MSG_PUB.COUNT_AND_GET

Line 315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
317: ROLLBACK;
318: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_TO_USERS',FND_LOG.LEVEL_EXCEPTION);
319:

Line 328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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);
331: FND_MSG_PUB.COUNT_AND_GET
332: ( p_count => x_msg_count,

Line 342: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,

338: END assign_mul_cust_to_users;
339:
340: PROCEDURE assign_cust_loc_to_user
341: ( p_api_version_number IN NUMBER,
342: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
343: p_user_id IN NUMBER,
344: p_party_id IN NUMBER,
345: p_location_id IN NUMBER,
346: p_operation IN VARCHAR2,

Line 371: IF FND_API.TO_BOOLEAN (p_init_msg_list)

367: BEGIN
368:
369: CSM_UTIL_PKG.LOG('Entering CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_LOC_TO_USER Package ', 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_LOC_TO_USER',FND_LOG.LEVEL_EXCEPTION);
370:
371: IF FND_API.TO_BOOLEAN (p_init_msg_list)
372:
373: THEN
374:
375: FND_MSG_PUB.INITIALIZE;

Line 392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
393:
394: END IF;
395:
396: CLOSE csr_owner_id;

Line 428: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS)

424: X_ERROR_MESSAGE => l_error_message);
425:
426: END IF;
427:
428: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS)
429:
430: THEN
431:
432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

428: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS)
429:
430: THEN
431:
432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
433:
434: END IF;
435:
436: IF p_operation IS NULL

Line 452: x_return_status := FND_API.G_RET_STS_SUCCESS;

448: CLOSE csr_owner_id;
449:
450: END IF;
451:
452: x_return_status := FND_API.G_RET_STS_SUCCESS;
453: x_msg_count := 0;
454: x_error_message := 'Assigning customer with a location to single user through CSM_PARTY_ASSIGNMENT_PKG is done successfully';
455: CSM_UTIL_PKG.LOG('Leaving CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_LOC_TO_USER Package ', 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_LOC_TO_USER',FND_LOG.LEVEL_EXCEPTION);
456:

Line 459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

455: CSM_UTIL_PKG.LOG('Leaving CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_LOC_TO_USER Package ', 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_LOC_TO_USER',FND_LOG.LEVEL_EXCEPTION);
456:
457: EXCEPTION
458:
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
460:
461: THEN
462:
463: FND_MSG_PUB.COUNT_AND_GET

Line 466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
468: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_LOC_TO_USER',FND_LOG.LEVEL_EXCEPTION);
469:
470: WHEN OTHERS

Line 477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
481: ( p_count => x_msg_count,

Line 491: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,

487: END assign_cust_loc_to_user;
488:
489: PROCEDURE assign_mul_cust_loc_to_users
490: ( p_api_version_number IN NUMBER,
491: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
492: p_user_id_lst IN l_user_id_tbl_type,
493: p_party_id IN NUMBER,
494: p_location_id_lst IN l_party_id_tbl_type,
495: p_operation IN VARCHAR2,

Line 527: IF FND_API.TO_BOOLEAN (p_init_msg_list)

523: BEGIN
524:
525: CSM_UTIL_PKG.LOG('Entering CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_LOC_TO_USERS Package ', 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_LOC_TO_USERS',FND_LOG.LEVEL_EXCEPTION);
526:
527: IF FND_API.TO_BOOLEAN (p_init_msg_list)
528:
529: THEN
530:
531: FND_MSG_PUB.INITIALIZE;

Line 578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
579:
580: END IF;
581:
582: CLOSE csr_owner_id;

Line 614: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS)

610: X_ERROR_MESSAGE => l_error_message);
611:
612: END IF;
613:
614: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS)
615:
616: THEN
617:
618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

614: IF NOT (l_return_status = FND_API.G_RET_STS_SUCCESS)
615:
616: THEN
617:
618: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
619:
620: END IF;
621:
622: END LOOP;

Line 642: x_return_status := FND_API.G_RET_STS_SUCCESS;

638: CLOSE csr_owner_id;
639:
640: END IF;
641:
642: x_return_status := FND_API.G_RET_STS_SUCCESS;
643: x_msg_count := 0;
644: x_error_message := 'Assigning customer with multiple locations to multiple users through CSM_PARTY_ASSIGNMENT_PKG is done successfully';
645: CSM_UTIL_PKG.LOG('Leaving CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_LOC_TO_USER Package ', 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_LOC_TO_USER',FND_LOG.LEVEL_EXCEPTION);
646:

Line 649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

645: CSM_UTIL_PKG.LOG('Leaving CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_LOC_TO_USER Package ', 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_LOC_TO_USER',FND_LOG.LEVEL_EXCEPTION);
646:
647: EXCEPTION
648:
649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
650:
651: THEN
652:
653: FND_MSG_PUB.COUNT_AND_GET

Line 656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
658: ROLLBACK;
659: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_LOC_TO_USER',FND_LOG.LEVEL_EXCEPTION);
660:

Line 669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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);
672: FND_MSG_PUB.COUNT_AND_GET
673: ( p_count => x_msg_count,

Line 683: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,

679: END assign_mul_cust_loc_to_users;
680:
681: PROCEDURE get_parties_for_user
682: ( p_api_version_number IN NUMBER,
683: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
684: p_user_id IN NUMBER,
685: p_party_id_lst OUT NOCOPY l_party_id_tbl_type,
686: p_operation IN VARCHAR2,
687: x_msg_count OUT NOCOPY NUMBER,

Line 713: IF FND_API.TO_BOOLEAN (p_init_msg_list)

709: BEGIN
710:
711: CSM_UTIL_PKG.LOG('Entering CSM_PARTY_DOWNLOAD_PUB.GET_PARTIES_FOR_USER Package ', 'CSM_PARTY_DOWNLOAD_PUB.GET_PARTIES_FOR_USER',FND_LOG.LEVEL_EXCEPTION);
712:
713: IF FND_API.TO_BOOLEAN (p_init_msg_list)
714:
715: THEN
716:
717: FND_MSG_PUB.INITIALIZE;

Line 743: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
744:
745: END IF;
746:
747: CLOSE csr_get_party_id;

Line 759: x_return_status := FND_API.G_RET_STS_SUCCESS;

755: END IF;
756:
757: p_party_id_lst := l_party_id_tbl;
758:
759: x_return_status := FND_API.G_RET_STS_SUCCESS;
760: x_msg_count := 0;
761: x_error_message := 'The party records for the user are fetched successfully';
762: CSM_UTIL_PKG.LOG('Leaving CSM_PARTY_DOWNLOAD_PUB.GET_PARTIES_FOR_USER Package ', 'CSM_PARTY_DOWNLOAD_PUB.GET_PARTIES_FOR_USER',FND_LOG.LEVEL_EXCEPTION);
763:

Line 766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

762: CSM_UTIL_PKG.LOG('Leaving CSM_PARTY_DOWNLOAD_PUB.GET_PARTIES_FOR_USER Package ', 'CSM_PARTY_DOWNLOAD_PUB.GET_PARTIES_FOR_USER',FND_LOG.LEVEL_EXCEPTION);
763:
764: EXCEPTION
765:
766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
767:
768: THEN
769:
770: FND_MSG_PUB.COUNT_AND_GET

Line 774: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
775: x_error_message := l_error_message || ' - the error message is :'||l_msg_data;
776: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.GET_PARTIES_FOR_USER',FND_LOG.LEVEL_EXCEPTION);
777:
778: WHEN OTHERS

Line 785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
789: ( p_count => x_msg_count,

Line 799: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,

795: END get_parties_for_user;
796:
797: PROCEDURE get_party_locations_for_user
798: ( p_api_version_number IN NUMBER,
799: p_init_msg_list IN VARCHAR2 :=FND_API.G_FALSE,
800: p_user_id IN NUMBER,
801: p_party_id IN NUMBER,
802: p_location_id OUT NOCOPY l_party_id_tbl_type,
803: p_operation IN VARCHAR2,

Line 832: IF FND_API.TO_BOOLEAN (p_init_msg_list)

828: BEGIN
829:
830: CSM_UTIL_PKG.LOG('Entering CSM_PARTY_DOWNLOAD_PUB.GET_PARTY_LOCATIONS_FOR_USER Package ', 'CSM_PARTY_DOWNLOAD_PUB.GET_PARTY_LOCATIONS_FOR_USER',FND_LOG.LEVEL_EXCEPTION);
831:
832: IF FND_API.TO_BOOLEAN (p_init_msg_list)
833:
834: THEN
835:
836: FND_MSG_PUB.INITIALIZE;

Line 862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
863:
864: END IF;
865:
866: CLOSE csr_get_party_site_id ;

Line 878: x_return_status := FND_API.G_RET_STS_SUCCESS;

874: CLOSE csr_get_party_site_id;
875:
876: END IF;
877:
878: x_return_status := FND_API.G_RET_STS_SUCCESS;
879: x_msg_count := 0;
880: x_error_message := 'The party locations records for the user are fetched successfully';
881: CSM_UTIL_PKG.LOG('Leaving CSM_PARTY_DOWNLOAD_PUB.GET_PARTY_LOCATIONS_FOR_USER Package ', 'CSM_PARTY_DOWNLOAD_PUB.GET_PARTY_LOCATIONS_FOR_USER',FND_LOG.LEVEL_EXCEPTION);
882:

Line 885: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

881: CSM_UTIL_PKG.LOG('Leaving CSM_PARTY_DOWNLOAD_PUB.GET_PARTY_LOCATIONS_FOR_USER Package ', 'CSM_PARTY_DOWNLOAD_PUB.GET_PARTY_LOCATIONS_FOR_USER',FND_LOG.LEVEL_EXCEPTION);
882:
883: EXCEPTION
884:
885: WHEN FND_API.G_EXC_UNEXPECTED_ERROR
886:
887: THEN
888:
889: FND_MSG_PUB.COUNT_AND_GET

Line 892: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
894: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.GET_PARTY_LOCATIONS_FOR_USER',FND_LOG.LEVEL_EXCEPTION);
895:
896: WHEN OTHERS

Line 903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
907: ( p_count => x_msg_count,