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 CSM_PARTY_DOWNLOAD_PUB

Line 1: PACKAGE BODY CSM_PARTY_DOWNLOAD_PUB AS

1: PACKAGE BODY CSM_PARTY_DOWNLOAD_PUB AS
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,

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

29: AND au.enabled = 'Y';
30:
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

Line 104: CSM_UTIL_PKG.LOG('Value for p_operation is NULL', 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_TO_USER',FND_LOG.LEVEL_EXCEPTION);

100: IF p_operation IS NULL
101:
102: THEN
103:
104: CSM_UTIL_PKG.LOG('Value for p_operation is NULL', 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_TO_USER',FND_LOG.LEVEL_EXCEPTION);
105:
106: END IF;
107:
108: IF (csr_owner_id%ISOPEN)

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

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:
121: EXCEPTION
122:
123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 132: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_TO_USER',FND_LOG.LEVEL_EXCEPTION);

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
135:
136: THEN

Line 147: x_error_message := 'Exception in CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_TO_USER Procedure :'||'while processing the party -'

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;
149: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_TO_USER',FND_LOG.LEVEL_EXCEPTION);
150:
151: END assign_cust_to_user;

Line 149: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_TO_USER',FND_LOG.LEVEL_EXCEPTION);

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;
149: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_TO_USER',FND_LOG.LEVEL_EXCEPTION);
150:
151: END assign_cust_to_user;
152:
153: PROCEDURE assign_mul_cust_to_users

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

182: AND au.enabled = 'Y';
183:
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

Line 289: CSM_UTIL_PKG.LOG('Value for p_operation is NULL', 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_TO_USERS',FND_LOG.LEVEL_EXCEPTION);

285: IF p_operation IS NULL
286:
287: THEN
288:
289: CSM_UTIL_PKG.LOG('Value for p_operation is NULL', 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_TO_USERS',FND_LOG.LEVEL_EXCEPTION);
290:
291: END IF;
292:
293: IF (csr_owner_id%ISOPEN)

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

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:
306: EXCEPTION
307:
308: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 318: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_TO_USERS',FND_LOG.LEVEL_EXCEPTION);

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:
320: WHEN OTHERS
321:
322: THEN

Line 334: x_error_message := 'Exception in CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_TO_USERS Procedure :'||'while processing the party -'

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;
336: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_TO_USERS',FND_LOG.LEVEL_EXCEPTION);
337:
338: END assign_mul_cust_to_users;

Line 336: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_TO_USERS',FND_LOG.LEVEL_EXCEPTION);

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;
336: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_TO_USERS',FND_LOG.LEVEL_EXCEPTION);
337:
338: END assign_mul_cust_to_users;
339:
340: PROCEDURE assign_cust_loc_to_user

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

365: AND au.enabled = 'Y';
366:
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

Line 440: CSM_UTIL_PKG.LOG('Value for p_operation is NULL', 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_LOC_TO_USER',FND_LOG.LEVEL_EXCEPTION);

436: IF p_operation IS NULL
437:
438: THEN
439:
440: CSM_UTIL_PKG.LOG('Value for p_operation is NULL', 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_LOC_TO_USER',FND_LOG.LEVEL_EXCEPTION);
441:
442: END IF;
443:
444: IF (csr_owner_id%ISOPEN)

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

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:
457: EXCEPTION
458:
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 468: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_LOC_TO_USER',FND_LOG.LEVEL_EXCEPTION);

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
471:
472: THEN

Line 483: x_error_message := 'Exception in CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_LOC_TO_USER Procedure :'||'while processing the party -'

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;
485: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_LOC_TO_USER',FND_LOG.LEVEL_EXCEPTION);
486:
487: END assign_cust_loc_to_user;

Line 485: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_LOC_TO_USER',FND_LOG.LEVEL_EXCEPTION);

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;
485: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_CUST_LOC_TO_USER',FND_LOG.LEVEL_EXCEPTION);
486:
487: END assign_cust_loc_to_user;
488:
489: PROCEDURE assign_mul_cust_loc_to_users

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

521: AND au.enabled = 'Y';
522:
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

Line 630: CSM_UTIL_PKG.LOG('Value for p_operation is NULL', 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_LOC_TO_USER',FND_LOG.LEVEL_EXCEPTION);

626: IF p_operation IS NULL
627:
628: THEN
629:
630: CSM_UTIL_PKG.LOG('Value for p_operation is NULL', 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_LOC_TO_USER',FND_LOG.LEVEL_EXCEPTION);
631:
632: END IF;
633:
634: IF (csr_owner_id%ISOPEN)

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

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:
647: EXCEPTION
648:
649: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 659: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_LOC_TO_USER',FND_LOG.LEVEL_EXCEPTION);

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:
661: WHEN OTHERS
662:
663: THEN

Line 675: x_error_message := 'Exception in CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_LOC_TO_USER Procedure :'||'while processing the party -'

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;
677: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_LOC_TO_USER',FND_LOG.LEVEL_EXCEPTION);
678:
679: END assign_mul_cust_loc_to_users;

Line 677: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_LOC_TO_USER',FND_LOG.LEVEL_EXCEPTION);

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;
677: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.ASSIGN_MUL_CUST_LOC_TO_USER',FND_LOG.LEVEL_EXCEPTION);
678:
679: END assign_mul_cust_loc_to_users;
680:
681: PROCEDURE get_parties_for_user

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

707: AND cpa.deleted_flag = 'N';
708:
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

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

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:
764: EXCEPTION
765:
766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 776: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.GET_PARTIES_FOR_USER',FND_LOG.LEVEL_EXCEPTION);

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
779:
780: THEN

Line 791: x_error_message := 'Exception in CSM_PARTY_DOWNLOAD_PUB.GET_PARTIES_FOR_USER Procedure :'||'while fetching the parties for the user -'

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;
793: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.GET_PARTIES_FOR_USER',FND_LOG.LEVEL_EXCEPTION);
794:
795: END get_parties_for_user;

Line 793: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.GET_PARTIES_FOR_USER',FND_LOG.LEVEL_EXCEPTION);

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;
793: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.GET_PARTIES_FOR_USER',FND_LOG.LEVEL_EXCEPTION);
794:
795: END get_parties_for_user;
796:
797: PROCEDURE get_party_locations_for_user

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

826: AND cpa.deleted_flag = 'N';
827:
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

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

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:
883: EXCEPTION
884:
885: WHEN FND_API.G_EXC_UNEXPECTED_ERROR

Line 894: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.GET_PARTY_LOCATIONS_FOR_USER',FND_LOG.LEVEL_EXCEPTION);

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
897:
898: THEN

Line 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 -'

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;
911: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.GET_PARTY_LOCATIONS_FOR_USER',FND_LOG.LEVEL_EXCEPTION);
912:
913: END get_party_locations_for_user;

Line 911: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.GET_PARTY_LOCATIONS_FOR_USER',FND_LOG.LEVEL_EXCEPTION);

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;
911: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.GET_PARTY_LOCATIONS_FOR_USER',FND_LOG.LEVEL_EXCEPTION);
912:
913: END get_party_locations_for_user;
914:
915: END CSM_PARTY_DOWNLOAD_PUB;

Line 915: END CSM_PARTY_DOWNLOAD_PUB;

911: CSM_UTIL_PKG.LOG(x_error_message, 'CSM_PARTY_DOWNLOAD_PUB.GET_PARTY_LOCATIONS_FOR_USER',FND_LOG.LEVEL_EXCEPTION);
912:
913: END get_party_locations_for_user;
914:
915: END CSM_PARTY_DOWNLOAD_PUB;