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_EMAIL_QUERY_PKG dependencies on FND_LOG

Line 38: CSM_UTIL_PKG.LOG('Entering GET_RESOURCE_ID: ' || p_user_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);

34: WHERE USER_ID = p_user_id;
35:
36: l_resource_id NUMBER := NULL;
37: BEGIN
38: CSM_UTIL_PKG.LOG('Entering GET_RESOURCE_ID: ' || p_user_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
39:
40: OPEN c_get_resource(p_user_id);
41: FETCH c_get_resource INTO l_resource_id;
42: CLOSE c_get_resource;

Line 44: CSM_UTIL_PKG.LOG('Leaving GET_RESOURCE_ID: ' || l_resource_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);

40: OPEN c_get_resource(p_user_id);
41: FETCH c_get_resource INTO l_resource_id;
42: CLOSE c_get_resource;
43:
44: CSM_UTIL_PKG.LOG('Leaving GET_RESOURCE_ID: ' || l_resource_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
45: RETURN l_resource_id;
46:
47: END GET_RESOURCE_ID;
48:

Line 70: CSM_UTIL_PKG.LOG('Entering GET_ADMIN_GROUPS: ' || p_user_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);

66:
67: l_resource_id NUMBER := NULL;
68: l_groups VARCHAR2(4000);
69: BEGIN
70: CSM_UTIL_PKG.LOG('Entering GET_ADMIN_GROUPS: ' || p_user_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
71: l_resource_id := GET_RESOURCE_ID( p_user_id);
72:
73: FOR r_get_group in c_get_groups(l_resource_id) LOOP
74: l_groups := l_groups || r_get_group.GROUP_ID || ',';

Line 84: CSM_UTIL_PKG.LOG('Leaving GET_ADMIN_GROUPS: ' || p_user_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);

80: RETURN NULL;
81: ELSE
82: RETURN l_groups;
83: END IF;
84: CSM_UTIL_PKG.LOG('Leaving GET_ADMIN_GROUPS: ' || p_user_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
85: END GET_ADMIN_GROUPS;
86:
87: /*Function to get FND_USER for the email address
88: If there is a unique valid user associated to this email address

Line 108: CSM_UTIL_PKG.LOG('Entering IS_FND_USER: ' || p_email_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);

104: l_count NUMBER;
105:
106: BEGIN
107: l_fnd_user_id := -1;
108: CSM_UTIL_PKG.LOG('Entering IS_FND_USER: ' || p_email_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
109:
110: OPEN c_fnd_user(UPPER(p_email_id));
111: FETCH c_fnd_user INTO l_fnd_user_id, l_count;
112: CLOSE c_fnd_user;

Line 115: CSM_UTIL_PKG.LOG('EMAIL_ID: ' || p_email_id || ' is associated to more than one users', g_object_name, FND_LOG.LEVEL_PROCEDURE);

111: FETCH c_fnd_user INTO l_fnd_user_id, l_count;
112: CLOSE c_fnd_user;
113:
114: IF l_count > 1 THEN
115: CSM_UTIL_PKG.LOG('EMAIL_ID: ' || p_email_id || ' is associated to more than one users', g_object_name, FND_LOG.LEVEL_PROCEDURE);
116: l_fnd_user_id := -1;
117: ELSE
118: SELECT user_name INTO g_user_name
119: FROM FND_USER

Line 123: CSM_UTIL_PKG.LOG('Leaving IS_FND_USER: ' || l_fnd_user_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);

119: FROM FND_USER
120: WHERE user_id = l_fnd_user_id;
121: END IF;
122:
123: CSM_UTIL_PKG.LOG('Leaving IS_FND_USER: ' || l_fnd_user_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
124: RETURN l_fnd_user_id;
125:
126: END IS_FND_USER;
127:

Line 139: CSM_UTIL_PKG.LOG('Entering GET_EMAIL_PREF email_id: ' || p_email_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);

135: l_fnd_user_name VARCHAR2(240);
136:
137: BEGIN
138:
139: CSM_UTIL_PKG.LOG('Entering GET_EMAIL_PREF email_id: ' || p_email_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
140: l_user_id := IS_FND_USER(p_email_id);
141:
142: IF l_user_id = -1 THEN
143: l_email_format := 'MAILHTM2';

Line 144: CSM_UTIL_PKG.LOG('Not a valid FND_USER will use default: ' || l_email_format, g_object_name, FND_LOG.LEVEL_PROCEDURE);

140: l_user_id := IS_FND_USER(p_email_id);
141:
142: IF l_user_id = -1 THEN
143: l_email_format := 'MAILHTM2';
144: CSM_UTIL_PKG.LOG('Not a valid FND_USER will use default: ' || l_email_format, g_object_name, FND_LOG.LEVEL_PROCEDURE);
145: ELSE
146: CSM_UTIL_PKG.LOG('A valid FND_USER name : ' || g_user_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);
147: l_email_format := fnd_preference.get(g_user_name,'WF','MAILTYPE');
148: END IF;

Line 146: CSM_UTIL_PKG.LOG('A valid FND_USER name : ' || g_user_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);

142: IF l_user_id = -1 THEN
143: l_email_format := 'MAILHTM2';
144: CSM_UTIL_PKG.LOG('Not a valid FND_USER will use default: ' || l_email_format, g_object_name, FND_LOG.LEVEL_PROCEDURE);
145: ELSE
146: CSM_UTIL_PKG.LOG('A valid FND_USER name : ' || g_user_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);
147: l_email_format := fnd_preference.get(g_user_name,'WF','MAILTYPE');
148: END IF;
149:
150: CSM_UTIL_PKG.LOG('Entering GET_EMAIL_PREF format: ' || l_email_format, g_object_name, FND_LOG.LEVEL_PROCEDURE);

Line 150: CSM_UTIL_PKG.LOG('Entering GET_EMAIL_PREF format: ' || l_email_format, g_object_name, FND_LOG.LEVEL_PROCEDURE);

146: CSM_UTIL_PKG.LOG('A valid FND_USER name : ' || g_user_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);
147: l_email_format := fnd_preference.get(g_user_name,'WF','MAILTYPE');
148: END IF;
149:
150: CSM_UTIL_PKG.LOG('Entering GET_EMAIL_PREF format: ' || l_email_format, g_object_name, FND_LOG.LEVEL_PROCEDURE);
151: RETURN l_email_format;
152:
153: END GET_EMAIL_PREF;
154:

Line 187: CSM_UTIL_PKG.LOG('Entering CHECK_USER_ACCESS user_id: ' || p_user_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);

183: l_responsibility_id NUMBER;
184: l_is_user_access VARCHAR2(1);
185:
186: BEGIN
187: CSM_UTIL_PKG.LOG('Entering CHECK_USER_ACCESS user_id: ' || p_user_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
188: l_is_user_access := 'N';
189: l_responsibility_id := -1;
190:
191: IF p_level_id = 10003 THEN

Line 203: CSM_UTIL_PKG.LOG('USER_ID: ' || p_user_id || ' have access to responsibility_id :' || p_level_value, g_object_name, FND_LOG.LEVEL_PROCEDURE);

199: END IF;
200:
201: IF l_responsibility_id > 0 THEN
202: l_is_user_access := 'Y';
203: CSM_UTIL_PKG.LOG('USER_ID: ' || p_user_id || ' have access to responsibility_id :' || p_level_value, g_object_name, FND_LOG.LEVEL_PROCEDURE);
204: ELSE
205: CSM_UTIL_PKG.LOG('USER_ID: ' || p_user_id || ' does not have access to responsibility_id: ' || p_level_value, g_object_name, FND_LOG.LEVEL_PROCEDURE);
206: END IF;
207:

Line 205: CSM_UTIL_PKG.LOG('USER_ID: ' || p_user_id || ' does not have access to responsibility_id: ' || p_level_value, g_object_name, FND_LOG.LEVEL_PROCEDURE);

201: IF l_responsibility_id > 0 THEN
202: l_is_user_access := 'Y';
203: CSM_UTIL_PKG.LOG('USER_ID: ' || p_user_id || ' have access to responsibility_id :' || p_level_value, g_object_name, FND_LOG.LEVEL_PROCEDURE);
204: ELSE
205: CSM_UTIL_PKG.LOG('USER_ID: ' || p_user_id || ' does not have access to responsibility_id: ' || p_level_value, g_object_name, FND_LOG.LEVEL_PROCEDURE);
206: END IF;
207:
208: CSM_UTIL_PKG.LOG('Leaving CHECK_USER_ACCESS: ' || l_is_user_access, g_object_name, FND_LOG.LEVEL_PROCEDURE);
209:

Line 208: CSM_UTIL_PKG.LOG('Leaving CHECK_USER_ACCESS: ' || l_is_user_access, g_object_name, FND_LOG.LEVEL_PROCEDURE);

204: ELSE
205: CSM_UTIL_PKG.LOG('USER_ID: ' || p_user_id || ' does not have access to responsibility_id: ' || p_level_value, g_object_name, FND_LOG.LEVEL_PROCEDURE);
206: END IF;
207:
208: CSM_UTIL_PKG.LOG('Leaving CHECK_USER_ACCESS: ' || l_is_user_access, g_object_name, FND_LOG.LEVEL_PROCEDURE);
209:
210: RETURN l_is_user_access;
211:
212: END CHECK_USER_ACCESS;

Line 281: CSM_UTIL_PKG.LOG( 'Entering CHECK_TASK_ACCESS for USER_ID : ' || p_user_id ||' and TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);

277: BEGIN
278: l_task_access_flag := 'N';
279: l_resource_id := GET_RESOURCE_ID(p_user_id);
280:
281: CSM_UTIL_PKG.LOG( 'Entering CHECK_TASK_ACCESS for USER_ID : ' || p_user_id ||' and TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
282:
283: IF l_resource_id IS NOT NULL THEN
284: OPEN c_task_assignment(l_resource_id, p_task_number);
285: FETCH c_task_assignment INTO l_count;

Line 312: CSM_UTIL_PKG.LOG( 'Leaving CHECK_TASK_ACCESS for USER_ID : ' || p_user_id ||' and TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);

308:
309:
310: END IF;--valid resource id
311:
312: CSM_UTIL_PKG.LOG( 'Leaving CHECK_TASK_ACCESS for USER_ID : ' || p_user_id ||' and TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
313:
314: RETURN l_task_access_flag;
315:
316: END CHECK_TASK_ACCESS;

Line 336: ' Converted Time : ' || to_char(l_adj_date, 'DD-MM-YYYY HH24:MI:SS'),g_object_name, FND_LOG.LEVEL_PROCEDURE);

332:
333: CSM_UTIL_PKG.LOG( 'Client Timezone : ' || l_client_tz ||
334: ' Server Timezone : ' || l_server_tz ||
335: ' Actual Time : ' || to_char(p_date_time, 'DD-MM-YYYY HH24:MI:SS') ||
336: ' Converted Time : ' || to_char(l_adj_date, 'DD-MM-YYYY HH24:MI:SS'),g_object_name, FND_LOG.LEVEL_PROCEDURE);
337:
338: RETURN l_adj_date;
339:
340: END ADJUST_TIME;

Line 411: CSM_UTIL_PKG.LOG( 'Entering EXECUTE_COMMAND for EMAIL_ID : ' || p_email_id ||' and COMMAND_NAME: ' || p_command_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);

407: l_old_user_id NUMBER;
408: l_old_resp_id NUMBER;
409: l_old_appl_id NUMBER;
410: BEGIN
411: CSM_UTIL_PKG.LOG( 'Entering EXECUTE_COMMAND for EMAIL_ID : ' || p_email_id ||' and COMMAND_NAME: ' || p_command_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);
412:
413: IF p_email_id IS NULL OR p_command_name IS NULL THEN
414: x_return_status := FND_API.G_RET_STS_ERROR;
415: x_error_message := 'Email address : ' || p_email_id || ' or Command Name: ' || p_command_name || 'cannot be blank';

Line 416: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);

412:
413: IF p_email_id IS NULL OR p_command_name IS NULL THEN
414: x_return_status := FND_API.G_RET_STS_ERROR;
415: x_error_message := 'Email address : ' || p_email_id || ' or Command Name: ' || p_command_name || 'cannot be blank';
416: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);
417: RETURN;
418: END IF;
419:
420: l_command_name := UPPER(TRIM(p_command_name));

Line 428: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);

424: CLOSE c_get_query_id;
425: IF l_query_id IS NULL THEN
426: x_return_status := FND_API.G_RET_STS_ERROR;
427: x_error_message := 'Error: Invalid Query Name: '|| l_command_name;
428: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);
429: RETURN;
430: END IF;
431:
432: IF l_disabled_flag = 'Y' THEN

Line 435: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);

431:
432: IF l_disabled_flag = 'Y' THEN
433: x_return_status := FND_API.G_RET_STS_ERROR;
434: x_error_message := 'Query Name: '|| l_command_name || ' is disabled.';
435: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);
436: RETURN;
437: END IF;
438:
439: IF l_restricted_flag = 'Y' THEN

Line 444: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);

440: g_user_id := IS_FND_USER(p_email_id);
441: IF g_user_id = -1 THEN
442: x_return_status := FND_API.G_RET_STS_ERROR;
443: x_error_message := 'Invalid FND_USER for EMAIL_ID: ' || p_email_id;
444: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);
445: RETURN;
446: END IF;
447:
448: CSM_UTIL_PKG.LOG('EMAIL_ID: ' || p_email_id || ' associated to FND_USER_ID: ' || g_user_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);

Line 448: CSM_UTIL_PKG.LOG('EMAIL_ID: ' || p_email_id || ' associated to FND_USER_ID: ' || g_user_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);

444: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);
445: RETURN;
446: END IF;
447:
448: CSM_UTIL_PKG.LOG('EMAIL_ID: ' || p_email_id || ' associated to FND_USER_ID: ' || g_user_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
449:
450: l_access_flag := CHECK_USER_ACCESS(g_user_id,l_level_id, l_level_value);
451: IF l_access_flag = 'N' THEN
452: x_return_status := FND_API.G_RET_STS_ERROR;

Line 454: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);

450: l_access_flag := CHECK_USER_ACCESS(g_user_id,l_level_id, l_level_value);
451: IF l_access_flag = 'N' THEN
452: x_return_status := FND_API.G_RET_STS_ERROR;
453: x_error_message := 'User: '|| g_user_name ||' does not have access to execute mobile query: ' || l_command_name;
454: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);
455: RETURN;
456: END IF;
457: END IF;
458:

Line 468: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);

464: x_return_status := FND_API.G_RET_STS_ERROR;
465: x_error_message := 'Incorrect number of parameters for Query Name: '|| l_command_name
466: || ' Required: '|| l_reqd_var_count
467: || ' Passed: ' || p_var_value_lst.count;
468: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);
469: RETURN;
470: END IF;
471:
472: l_old_user_id := fnd_global.user_id;

Line 481: CSM_UTIL_PKG.LOG('Set Application Context to user_id : ' || g_user_id || ' resp_id :' || l_resp_id || ' appl_id :' || l_application_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);

477: FETCH c_get_appl_resp_id INTO l_application_id, l_resp_id;
478: CLOSE c_get_appl_resp_id;
479:
480: IF l_level_id = 10001 THEN
481: CSM_UTIL_PKG.LOG('Set Application Context to user_id : ' || g_user_id || ' resp_id :' || l_resp_id || ' appl_id :' || l_application_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
482: fnd_global.apps_initialize(g_user_id, l_resp_id, l_application_id);
483: ELSE
484: CSM_UTIL_PKG.LOG('Set Application Context to user_id : ' || g_user_id || ' resp_id :' || l_level_value || ' appl_id :' || l_application_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
485: fnd_global.apps_initialize(g_user_id, l_level_value, l_application_id);

Line 484: CSM_UTIL_PKG.LOG('Set Application Context to user_id : ' || g_user_id || ' resp_id :' || l_level_value || ' appl_id :' || l_application_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);

480: IF l_level_id = 10001 THEN
481: CSM_UTIL_PKG.LOG('Set Application Context to user_id : ' || g_user_id || ' resp_id :' || l_resp_id || ' appl_id :' || l_application_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
482: fnd_global.apps_initialize(g_user_id, l_resp_id, l_application_id);
483: ELSE
484: CSM_UTIL_PKG.LOG('Set Application Context to user_id : ' || g_user_id || ' resp_id :' || l_level_value || ' appl_id :' || l_application_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
485: fnd_global.apps_initialize(g_user_id, l_level_value, l_application_id);
486: END IF;
487:
488: g_date_format_mask := TO_CHAR(fnd_profile.value_specific('ICX_DATE_FORMAT_MASK')) || ' ' ||g_time_stamp;

Line 531: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);

527: x_return_status := FND_API.G_RET_STS_ERROR;
528: x_error_message := 'Error in EXECUTE_COMMAND :'
529: || ' ROOT ERROR: CSM_QUERY_PKG.INSERT_INSTANCE '
530: || ' for QUERY_ID ' || l_query_id || ' Detail: ' || x_error_message;
531: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);
532: RETURN ;
533: END IF;
534:
535: CSM_QUERY_PKG.EXECUTE_QUERY(

Line 549: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);

545: x_return_status := FND_API.G_RET_STS_ERROR;
546: x_error_message := 'Error in EXECUTE_COMMAND :'
547: || ' ROOT ERROR: CSM_QUERY_PKG.EXECUTE_QUERY '
548: || ' for INSTANCE_ID ' || p_instance_id || ' Detail: ' || x_error_message;
549: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);
550: RETURN ;
551: END IF;
552:
553: UPDATE csm_query_results_acc

Line 558: CSM_UTIL_PKG.LOG('Reset Application Context to user_id : ' || l_old_user_id || ' resp_id :' || l_old_resp_id || ' appl_id :' || l_old_appl_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);

554: SET user_email_id = p_email_id
555: WHERE instance_id = p_instance_id;
556: COMMIT;
557:
558: CSM_UTIL_PKG.LOG('Reset Application Context to user_id : ' || l_old_user_id || ' resp_id :' || l_old_resp_id || ' appl_id :' || l_old_appl_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
559: fnd_global.apps_initialize(l_old_user_id, l_old_resp_id, l_old_appl_id);
560:
561: CSM_UTIL_PKG.LOG( 'Leaving EXECUTE_COMMAND for EMAIL_ID : ' || p_email_id ||' and COMMAND_NAME: ' || p_command_name,g_object_name, FND_LOG.LEVEL_PROCEDURE);
562:

Line 561: CSM_UTIL_PKG.LOG( 'Leaving EXECUTE_COMMAND for EMAIL_ID : ' || p_email_id ||' and COMMAND_NAME: ' || p_command_name,g_object_name, FND_LOG.LEVEL_PROCEDURE);

557:
558: CSM_UTIL_PKG.LOG('Reset Application Context to user_id : ' || l_old_user_id || ' resp_id :' || l_old_resp_id || ' appl_id :' || l_old_appl_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
559: fnd_global.apps_initialize(l_old_user_id, l_old_resp_id, l_old_appl_id);
560:
561: CSM_UTIL_PKG.LOG( 'Leaving EXECUTE_COMMAND for EMAIL_ID : ' || p_email_id ||' and COMMAND_NAME: ' || p_command_name,g_object_name, FND_LOG.LEVEL_PROCEDURE);
562:
563: EXCEPTION
564: WHEN others THEN
565: x_return_status := fnd_api.g_ret_sts_error;

Line 567: CSM_UTIL_PKG.LOG(x_error_message,g_object_name, FND_LOG.LEVEL_EXCEPTION);

563: EXCEPTION
564: WHEN others THEN
565: x_return_status := fnd_api.g_ret_sts_error;
566: x_error_message := 'Exception occurred in EXECUTE_COMMAND for Query Id : ' || sqlerrm;
567: CSM_UTIL_PKG.LOG(x_error_message,g_object_name, FND_LOG.LEVEL_EXCEPTION);
568: END EXECUTE_COMMAND;
569:
570: /**/
571: PROCEDURE GET_TASKS

Line 689: CSM_UTIL_PKG.LOG('Entering GET_TASKS for EMAIL_ID: ' || p_email_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);

685: l_group_lst VARCHAR2(32767);
686: l_is_3rdparty NUMBER := 0;
687: BEGIN
688:
689: CSM_UTIL_PKG.LOG('Entering GET_TASKS for EMAIL_ID: ' || p_email_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
690:
691: l_user_id := IS_FND_USER(p_email_id);
692:
693: IF l_user_id = -1 THEN

Line 696: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);

692:
693: IF l_user_id = -1 THEN
694: x_return_status := FND_API.G_RET_STS_ERROR;
695: x_error_message := 'Invalid user for EMAIL_ID: ' || p_email_id;
696: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);
697: RETURN;
698: END IF;
699:
700: -- g_user_id is Sender

Line 712: CSM_UTIL_PKG.LOG('Default: Sender is a Group Administrator in group: ' || r_groups.group_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);

708: -- Has Email param: A-A, M-M
709: i := 0;
710: FOR r_groups IN c_groups(g_user_id) LOOP
711: -- A-A: Sender is Group Administrator
712: CSM_UTIL_PKG.LOG('Default: Sender is a Group Administrator in group: ' || r_groups.group_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);
713: --check if the Group has third party role to it
714: OPEN c_third_party_group (r_groups.group_id);
715: FETCH c_third_party_group INTO l_is_3rdparty;
716: CLOSE c_third_party_group;

Line 767: CSM_UTIL_PKG.LOG('Has Email ID: Sender is a Group Administrator in group: ' || r_groups.group_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);

763: --A-M1
764: i := 0;
765: FOR r_groups IN c_groups(g_user_id) LOOP
766: -- A-M1; If member M1 belongs to same group of A, add to user list
767: CSM_UTIL_PKG.LOG('Has Email ID: Sender is a Group Administrator in group: ' || r_groups.group_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);
768: --check if the Group has third party role to it
769: OPEN c_third_party_group (r_groups.group_id);
770: FETCH c_third_party_group INTO l_is_3rdparty;
771: CLOSE c_third_party_group;

Line 780: CSM_UTIL_PKG.LOG('Has Email ID: Sender and User belong to same group: ' || r_groups.group_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);

776: END IF;
777:
778: FOR r_group_members IN c_group_members(r_groups.group_id) LOOP
779: IF l_user_id = r_group_members.user_id THEN
780: CSM_UTIL_PKG.LOG('Has Email ID: Sender and User belong to same group: ' || r_groups.group_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);
781: l_user_lst := l_user_lst || r_group_members.user_id || ',';
782: i := i + 1;
783: END IF;
784: END LOOP;

Line 789: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);

785: END LOOP;
786: IF i=0 THEN
787: x_return_status := FND_API.G_RET_STS_ERROR;
788: x_error_message := 'User: '|| g_user_name ||' doesnot belong to same group.';
789: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);
790: RETURN;
791: END IF;
792: ELSE
793: -- M-M1

Line 796: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);

792: ELSE
793: -- M-M1
794: x_return_status := FND_API.G_RET_STS_ERROR;
795: x_error_message := 'A group member cannot query for another group member.';
796: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);
797: RETURN;
798: END IF;
799: ELSE
800: --M-A1 or A-A1

Line 804: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);

800: --M-A1 or A-A1
801: IF l_is_sender_admin THEN
802: x_return_status := FND_API.G_RET_STS_ERROR;
803: x_error_message := 'Group administrator cannot query for another group administator';
804: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);
805: RETURN;
806: ELSE
807: x_return_status := FND_API.G_RET_STS_ERROR;
808: x_error_message := 'Group member cannot query for group administator.';

Line 809: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);

805: RETURN;
806: ELSE
807: x_return_status := FND_API.G_RET_STS_ERROR;
808: x_error_message := 'Group member cannot query for group administator.';
809: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);
810: RETURN;
811: END IF;
812: END IF;
813: END IF;

Line 818: CSM_UTIL_PKG.LOG('Query for task for Users: ' || i, g_object_name, FND_LOG.LEVEL_PROCEDURE);

814:
815: l_str_length := LENGTH(l_user_lst);
816: l_user_lst := SUBSTR(l_user_lst, 1, l_str_length - 1) || ')';
817:
818: CSM_UTIL_PKG.LOG('Query for task for Users: ' || i, g_object_name, FND_LOG.LEVEL_PROCEDURE);
819:
820: l_query_text := ' SELECT cia.incident_number service_request,
821: hzp.party_name customer,
822: res.source_name assignee,

Line 859: CSM_UTIL_PKG.LOG('Query for task for group: ' || l_group_lst, g_object_name, FND_LOG.LEVEL_PROCEDURE);

855: AND jtstl.LANGUAGE = USERENV(''LANG'') ';
856:
857: IF l_group_lst IS NOT NULL THEN
858:
859: CSM_UTIL_PKG.LOG('Query for task for group: ' || l_group_lst, g_object_name, FND_LOG.LEVEL_PROCEDURE);
860:
861: l_group_lst := '(' || SUBSTR(l_group_lst, 1, LENGTH(l_group_lst) - 1) || ')';
862:
863: l_query_text := l_query_text || ' UNION ALL SELECT cia.incident_number service_request,

Line 908: CSM_UTIL_PKG.LOG('Leaving GET_TASKS for EMAIL Id: ' || p_email_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);

904: qrycontext := DBMS_XMLGEN.newcontext(l_query_text) ;
905: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
906: p_result := DBMS_XMLGEN.getxml (qrycontext);
907:
908: CSM_UTIL_PKG.LOG('Leaving GET_TASKS for EMAIL Id: ' || p_email_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
909:
910: EXCEPTION
911: WHEN OTHERS THEN
912: x_return_status := FND_API.G_RET_STS_ERROR;

Line 914: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);

910: EXCEPTION
911: WHEN OTHERS THEN
912: x_return_status := FND_API.G_RET_STS_ERROR;
913: x_error_message := 'Exception occurred in GET_TASKS: ' || sqlerrm;
914: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);
915:
916: END GET_TASKS;
917:
918: PROCEDURE UPDATE_TASK

Line 980: CSM_UTIL_PKG.LOG('Entering UPDATE_TASK for TASK_NUMBER: ' || p_task_number || ' STATUS_ID is : ' || p_task_status_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);

976: l_task_type_id NUMBER;
977: l_resource_id NUMBER;
978:
979: BEGIN
980: CSM_UTIL_PKG.LOG('Entering UPDATE_TASK for TASK_NUMBER: ' || p_task_number || ' STATUS_ID is : ' || p_task_status_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
981: l_resource_id := GET_RESOURCE_ID(g_user_id);
982: l_task_access_flag := CHECK_TASK_ACCESS(g_user_id, p_task_number);
983:
984: IF l_task_access_flag = 'N' THEN

Line 987: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);

983:
984: IF l_task_access_flag = 'N' THEN
985: x_return_status := FND_API.G_RET_STS_ERROR;
986: x_error_message := 'Task Number: ' || p_task_number || ' has no assignment for user: ' || g_user_name;
987: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);
988: RETURN;
989: END IF;
990:
991: FOR r_task_assignments IN c_task_assignments(p_task_number, l_resource_id) LOOP

Line 1018: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);

1014: x_error_message := 'Error in UPDATE_TASK :'
1015: || ' ROOT ERROR: csf_task_assignments_pub.update_assignment_status'
1016: || ' for PK : ' || r_task_assignments.task_assignment_id
1017: || ' Details:' || l_msg_data ;
1018: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);
1019: RETURN ;
1020: END IF;
1021: END LOOP;
1022:

Line 1025: CSM_UTIL_PKG.LOG('Leaving UPDATE_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);

1021: END LOOP;
1022:
1023: p_result := TO_CLOB('');
1024:
1025: CSM_UTIL_PKG.LOG('Leaving UPDATE_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1026:
1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1031: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);

1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: x_return_status := FND_API.G_RET_STS_ERROR;
1030: x_error_message := 'Exception occurred in UPDATE_TASK: ' || sqlerrm;
1031: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);
1032:
1033: END UPDATE_TASK;
1034:
1035: PROCEDURE ACCEPT_TASK

Line 1045: CSM_UTIL_PKG.LOG('Entering ACCEPT_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);

1041: AS
1042: l_profile_value NUMBER;
1043: BEGIN
1044:
1045: CSM_UTIL_PKG.LOG('Entering ACCEPT_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1046: l_profile_value := TO_NUMBER(fnd_profile.value('CSF_DEFAULT_ACCEPTED_STATUS'));
1047:
1048: IF l_profile_value IS NULL THEN
1049: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1051: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);

1047:
1048: IF l_profile_value IS NULL THEN
1049: x_return_status := FND_API.G_RET_STS_ERROR;
1050: x_error_message := 'Please set the Profile option CSF_DEFAULT_ACCEPTED_STATUS value.';
1051: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);
1052: RETURN ;
1053: END IF;
1054:
1055: UPDATE_TASK

Line 1062: CSM_UTIL_PKG.LOG('Leaving ACCEPT_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);

1058: p_result => p_result,
1059: x_return_status => x_return_status,
1060: x_error_message => x_error_message);
1061:
1062: CSM_UTIL_PKG.LOG('Leaving ACCEPT_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1063:
1064: EXCEPTION
1065: WHEN OTHERS THEN
1066: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1068: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);

1064: EXCEPTION
1065: WHEN OTHERS THEN
1066: x_return_status := FND_API.G_RET_STS_ERROR;
1067: x_error_message := 'Exception occurred in ACCEPT_TASK: ' || sqlerrm;
1068: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);
1069:
1070: END ACCEPT_TASK;
1071:
1072: PROCEDURE CANCEL_TASK

Line 1082: CSM_UTIL_PKG.LOG('Entering CANCEL_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);

1078: AS
1079: l_profile_value NUMBER;
1080: BEGIN
1081:
1082: CSM_UTIL_PKG.LOG('Entering CANCEL_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1083: l_profile_value := TO_NUMBER(fnd_profile.value('CSF_DEFAULT_TASK_CANCELLED_STATUS'));
1084:
1085: IF l_profile_value IS NULL THEN
1086: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1088: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);

1084:
1085: IF l_profile_value IS NULL THEN
1086: x_return_status := FND_API.G_RET_STS_ERROR;
1087: x_error_message := 'Please set the Profile option CSF_DEFAULT_TASK_CANCELLED_STATUS value.';
1088: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);
1089: RETURN ;
1090: END IF;
1091:
1092: UPDATE_TASK

Line 1099: CSM_UTIL_PKG.LOG('Leaving CANCEL_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);

1095: p_result => p_result,
1096: x_return_status => x_return_status,
1097: x_error_message => x_error_message);
1098:
1099: CSM_UTIL_PKG.LOG('Leaving CANCEL_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1100:
1101: EXCEPTION
1102: WHEN OTHERS THEN
1103: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1105: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);

1101: EXCEPTION
1102: WHEN OTHERS THEN
1103: x_return_status := FND_API.G_RET_STS_ERROR;
1104: x_error_message := 'Exception occurred in CANCEL_TASK: ' || sqlerrm;
1105: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);
1106:
1107: END CANCEL_TASK;
1108:
1109: PROCEDURE CLOSE_TASK

Line 1119: CSM_UTIL_PKG.LOG('Entering CLOSE_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);

1115: AS
1116: l_profile_value NUMBER;
1117: BEGIN
1118:
1119: CSM_UTIL_PKG.LOG('Entering CLOSE_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1120:
1121: l_profile_value := TO_NUMBER(fnd_profile.value('CSF_DFLT_AUTO_CLOSE_TASK_STATUS'));
1122:
1123: IF l_profile_value IS NULL THEN

Line 1126: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);

1122:
1123: IF l_profile_value IS NULL THEN
1124: x_return_status := FND_API.G_RET_STS_ERROR;
1125: x_error_message := 'Please set the Profile option CSF_DFLT_AUTO_CLOSE_TASK_STATUS value.';
1126: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);
1127: RETURN ;
1128: END IF;
1129:
1130: UPDATE_TASK

Line 1137: CSM_UTIL_PKG.LOG('Leaving CLOSE_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);

1133: p_result => p_result,
1134: x_return_status => x_return_status,
1135: x_error_message => x_error_message);
1136:
1137: CSM_UTIL_PKG.LOG('Leaving CLOSE_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1138:
1139: EXCEPTION
1140: WHEN OTHERS THEN
1141: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1143: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);

1139: EXCEPTION
1140: WHEN OTHERS THEN
1141: x_return_status := FND_API.G_RET_STS_ERROR;
1142: x_error_message := 'Exception occurred in CLOSE_TASK: ' || sqlerrm;
1143: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);
1144:
1145: END CLOSE_TASK;
1146:
1147: /*Procedure to update task statu to Travelling*/

Line 1159: CSM_UTIL_PKG.LOG('Entering TRAVELING_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);

1155:
1156: l_profile_value NUMBER;
1157:
1158: BEGIN
1159: CSM_UTIL_PKG.LOG('Entering TRAVELING_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1160:
1161: l_profile_value := TO_NUMBER(fnd_profile.value('CSF_DEFAULT_TRAVELING_STATUS'));
1162:
1163: IF l_profile_value IS NULL THEN

Line 1166: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);

1162:
1163: IF l_profile_value IS NULL THEN
1164: x_return_status := FND_API.G_RET_STS_ERROR;
1165: x_error_message := 'Please set the Profile option CSF_DEFAULT_TRAVELING_STATUS value.';
1166: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);
1167: RETURN ;
1168: END IF;
1169:
1170: UPDATE_TASK

Line 1177: CSM_UTIL_PKG.LOG('Leaving TRAVELING_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);

1173: p_result => p_result,
1174: x_return_status => x_return_status,
1175: x_error_message => x_error_message);
1176:
1177: CSM_UTIL_PKG.LOG('Leaving TRAVELING_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1178:
1179: EXCEPTION
1180: WHEN OTHERS THEN
1181: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1183: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);

1179: EXCEPTION
1180: WHEN OTHERS THEN
1181: x_return_status := FND_API.G_RET_STS_ERROR;
1182: x_error_message := 'Exception occurred in TRAVELING_TASK: ' || sqlerrm;
1183: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);
1184:
1185: END TRAVELING_TASK;
1186:
1187: /*Procedure to update task statu to Working*/

Line 1197: CSM_UTIL_PKG.LOG('Entering WORKING_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);

1193: )
1194: AS
1195: l_profile_value NUMBER;
1196: BEGIN
1197: CSM_UTIL_PKG.LOG('Entering WORKING_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1198: l_profile_value := TO_NUMBER(fnd_profile.value('CSF_DEFAULT_TASK_WORKING_STATUS'));
1199:
1200: IF l_profile_value IS NULL THEN
1201: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1203: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);

1199:
1200: IF l_profile_value IS NULL THEN
1201: x_return_status := FND_API.G_RET_STS_ERROR;
1202: x_error_message := 'Please set the Profile option CSF_DEFAULT_TASK_WORKING_STATUS value.';
1203: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);
1204: RETURN ;
1205: END IF;
1206:
1207: UPDATE_TASK

Line 1214: CSM_UTIL_PKG.LOG('Leaving WORKING_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);

1210: p_result => p_result,
1211: x_return_status => x_return_status,
1212: x_error_message => x_error_message);
1213:
1214: CSM_UTIL_PKG.LOG('Leaving WORKING_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1215:
1216: EXCEPTION
1217: WHEN OTHERS THEN
1218: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1220: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);

1216: EXCEPTION
1217: WHEN OTHERS THEN
1218: x_return_status := FND_API.G_RET_STS_ERROR;
1219: x_error_message := 'Exception occurred in WORKING_TASK: ' || sqlerrm;
1220: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);
1221:
1222: END WORKING_TASK;
1223:
1224: /*Procedure to update task statu to Completed*/

Line 1245: CSM_UTIL_PKG.LOG('Entering COMPLETED_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);

1241:
1242: l_profile_value NUMBER;
1243:
1244: BEGIN
1245: CSM_UTIL_PKG.LOG('Entering COMPLETED_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1246:
1247: l_profile_value := TO_NUMBER(fnd_profile.value('CSF_DEFAULT_COMPLETED_STATUS'));
1248:
1249: IF l_profile_value IS NULL THEN

Line 1252: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);

1248:
1249: IF l_profile_value IS NULL THEN
1250: x_return_status := FND_API.G_RET_STS_ERROR;
1251: x_error_message := 'Please set the Profile option CSF_DEFAULT_COMPLETED_STATUS value.';
1252: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);
1253: RETURN ;
1254: END IF;
1255:
1256: UPDATE_TASK

Line 1263: CSM_UTIL_PKG.LOG('Leaving COMPLETED_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);

1259: p_result => p_result,
1260: x_return_status => x_return_status,
1261: x_error_message => x_error_message);
1262:
1263: CSM_UTIL_PKG.LOG('Leaving COMPLETED_TASK for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1264:
1265: EXCEPTION
1266: WHEN OTHERS THEN
1267: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1269: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);

1265: EXCEPTION
1266: WHEN OTHERS THEN
1267: x_return_status := FND_API.G_RET_STS_ERROR;
1268: x_error_message := 'Exception occurred in COMPLETED_TASK: ' || sqlerrm;
1269: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);
1270:
1271: END COMPLETED_TASK;
1272:
1273: PROCEDURE ADD_TASK_NOTE

Line 1309: CSM_UTIL_PKG.LOG('Entering ADD_TASK_NOTE for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);

1305: l_sig_pos NUMBER;
1306: l_note_type VARCHAR2(30);
1307: BEGIN
1308:
1309: CSM_UTIL_PKG.LOG('Entering ADD_TASK_NOTE for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1310: l_task_access_flag := CHECK_TASK_ACCESS(g_user_id, p_task_number);
1311:
1312: IF l_task_access_flag = 'N' THEN
1313: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1315: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);

1311:
1312: IF l_task_access_flag = 'N' THEN
1313: x_return_status := FND_API.G_RET_STS_ERROR;
1314: x_error_message := 'Task Number: ' || p_task_number || ' has no assignment for user: ' || g_user_name;
1315: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);
1316: RETURN ;
1317: END IF;
1318:
1319: OPEN c_task(p_task_number,g_user_id);

Line 1330: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);

1326:
1327: IF l_note_status IS NULL THEN
1328: x_return_status := FND_API.G_RET_STS_ERROR;
1329: x_error_message := 'Command Parameter NOTE_VISIBILITY: ' || p_note_visibility || ' is not a valid Note Status';
1330: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);
1331: RETURN ;
1332: END IF;
1333:
1334: l_notes := p_note_text1 || p_note_text2;

Line 1399: CSM_UTIL_PKG.LOG( x_error_message,g_object_name, FND_LOG.LEVEL_ERROR);

1395: x_error_message := 'Error in ADD_TASK_NOTE :'
1396: || ' ROOT ERROR: jtf_notes_pub.Create_note'
1397: || ' for PK TASK_NUMBER: ' || p_task_number
1398: || ' Details:' || x_error_message;
1399: CSM_UTIL_PKG.LOG( x_error_message,g_object_name, FND_LOG.LEVEL_ERROR);
1400: RETURN ;
1401: END IF;
1402:
1403: p_result := TO_CLOB('');

Line 1404: CSM_UTIL_PKG.LOG('Leaving ADD_TASK_NOTE for TASK_NUMBER: ' || p_task_number || ' JTF_NOTE_ID: ' || l_jtf_note_id , g_object_name, FND_LOG.LEVEL_PROCEDURE);

1400: RETURN ;
1401: END IF;
1402:
1403: p_result := TO_CLOB('');
1404: CSM_UTIL_PKG.LOG('Leaving ADD_TASK_NOTE for TASK_NUMBER: ' || p_task_number || ' JTF_NOTE_ID: ' || l_jtf_note_id , g_object_name, FND_LOG.LEVEL_PROCEDURE);
1405:
1406: EXCEPTION
1407: WHEN OTHERS THEN
1408: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1410: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);

1406: EXCEPTION
1407: WHEN OTHERS THEN
1408: x_return_status := FND_API.G_RET_STS_ERROR;
1409: x_error_message := 'Exception occurred in ADD_TASK_NOTE: ' || sqlerrm;
1410: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);
1411:
1412: END ADD_TASK_NOTE;
1413:
1414: PROCEDURE GET_TASK_DETAILS

Line 1540: CSM_UTIL_PKG.LOG('Entering GET_TASK_DETAILS for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);

1536: l_email_format VARCHAR2(240);
1537: l_xml_result LONG;
1538:
1539: BEGIN
1540: CSM_UTIL_PKG.LOG('Entering GET_TASK_DETAILS for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1541:
1542: l_task_access_flag := CHECK_TASK_ACCESS(g_user_id, p_task_number);
1543:
1544: IF l_task_access_flag = 'N' THEN

Line 1547: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);

1543:
1544: IF l_task_access_flag = 'N' THEN
1545: x_return_status := FND_API.G_RET_STS_ERROR;
1546: x_error_message := 'Task Number: ' || p_task_number || ' has no assignment for user: ' || g_user_name;
1547: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);
1548: RETURN;
1549: END IF;
1550:
1551: OPEN c_task_details(p_task_number);

Line 1609: CSM_UTIL_PKG.LOG('Leaving GET_TASK_DETAILS for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);

1605: l_xml_result := l_xml_result || ' ';
1606:
1607: p_result := TO_CLOB(l_xml_result);
1608:
1609: CSM_UTIL_PKG.LOG('Leaving GET_TASK_DETAILS for TASK_NUMBER: ' || p_task_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1610:
1611: EXCEPTION
1612: WHEN OTHERS THEN
1613: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1615: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);

1611: EXCEPTION
1612: WHEN OTHERS THEN
1613: x_return_status := FND_API.G_RET_STS_ERROR;
1614: x_error_message := 'Exception occurred in GET_TASK_DETAILS: ' || sqlerrm;
1615: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);
1616:
1617: END GET_TASK_DETAILS;
1618:
1619: PROCEDURE GET_SR_DETAILS

Line 1740: CSM_UTIL_PKG.LOG('Entering GET_SR_DETAILS for SR_NUMBER: ' || p_sr_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);

1736: l_xml_result CLOB;
1737: l_resource_id NUMBER;
1738: l_task_access_flag VARCHAR2(1) := 'N';
1739: BEGIN
1740: CSM_UTIL_PKG.LOG('Entering GET_SR_DETAILS for SR_NUMBER: ' || p_sr_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1741:
1742: --Get the Resource id
1743: l_resource_id := GET_RESOURCE_ID( g_user_id);
1744:

Line 1756: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);

1752:
1753: IF l_task_access_flag = 'N' THEN
1754: x_return_status := FND_API.G_RET_STS_ERROR;
1755: x_error_message := 'Service Request Number: ' || p_sr_number || ' has no assignment for user: ' || g_user_name;
1756: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);
1757: RETURN;
1758: END IF;
1759:
1760: OPEN c_incident_details(l_incident_id);

Line 1828: CSM_UTIL_PKG.LOG('Leaving GET_SR_DETAILS for SR_NUMBER: ' || p_sr_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);

1824: l_xml_result := l_xml_result || ' ';
1825:
1826: p_result := TO_CLOB(l_xml_result);
1827:
1828: CSM_UTIL_PKG.LOG('Leaving GET_SR_DETAILS for SR_NUMBER: ' || p_sr_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1829:
1830: EXCEPTION
1831: WHEN OTHERS THEN
1832: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1834: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);

1830: EXCEPTION
1831: WHEN OTHERS THEN
1832: x_return_status := FND_API.G_RET_STS_ERROR;
1833: x_error_message := 'Exception occurred in GET_SR_DETAILS: ' || sqlerrm;
1834: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);
1835:
1836: END GET_SR_DETAILS;
1837:
1838: /**/

Line 1929: CSM_UTIL_PKG.LOG('Entering GET_ENTITLEMENTS for SERIAL_NUMBER: ' || p_serial_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);

1925: l_xml_result CLOB;
1926: l_resource_id NUMBER;
1927:
1928: BEGIN
1929: CSM_UTIL_PKG.LOG('Entering GET_ENTITLEMENTS for SERIAL_NUMBER: ' || p_serial_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1930:
1931: --Get the Resource id
1932: l_resource_id := GET_RESOURCE_ID( g_user_id);
1933:

Line 1944: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);

1940: FETCH c_inst_contracts_group INTO l_instance_id, l_cont_serive_id;
1941: CLOSE c_inst_contracts_group;
1942: IF l_instance_id IS NULL THEN
1943: x_error_message := 'User: ' || g_user_name || ' has no task for serial number: ' || p_serial_number;
1944: CSM_UTIL_PKG.LOG( x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);
1945: RETURN;
1946: END IF;
1947: END IF;
1948:

Line 1970: CSM_UTIL_PKG.LOG( x_error_message,g_object_name, FND_LOG.LEVEL_ERROR);

1966: || ' ROOT ERROR: oks_entitlements_pub.get_contracts'
1967: || ' for serial number : ' || p_serial_number
1968: || ' Details:' || l_msg_data;
1969:
1970: CSM_UTIL_PKG.LOG( x_error_message,g_object_name, FND_LOG.LEVEL_ERROR);
1971: RETURN ;
1972: END IF;
1973:
1974: l_xml_result := ''

Line 1998: CSM_UTIL_PKG.LOG('Leaving GET_ENTITLEMENTS for SERIAL_NUMBER: ' || p_serial_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);

1994: || '';
1995:
1996: p_result := l_xml_result;
1997:
1998: CSM_UTIL_PKG.LOG('Leaving GET_ENTITLEMENTS for SERIAL_NUMBER: ' || p_serial_number, g_object_name, FND_LOG.LEVEL_PROCEDURE);
1999:
2000: EXCEPTION
2001: WHEN OTHERS THEN
2002: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2004: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);

2000: EXCEPTION
2001: WHEN OTHERS THEN
2002: x_return_status := FND_API.G_RET_STS_ERROR;
2003: x_error_message := 'Exception occurred in GET_ENTITLEMENTS: ' || sqlerrm;
2004: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);
2005:
2006: END GET_ENTITLEMENTS;
2007:
2008: /*Procedure to get the information of mobile query command*/

Line 2020: CSM_UTIL_PKG.LOG('Entering HELP_QUERY for query_name: ' || p_query_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);

2016: l_query_text VARCHAR2(4000);
2017: qrycontext DBMS_XMLGEN.ctxHandle;
2018:
2019: BEGIN
2020: CSM_UTIL_PKG.LOG('Entering HELP_QUERY for query_name: ' || p_query_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);
2021:
2022: l_query_text := 'SELECT query_name command_name,
2023: description
2024: FROM csm_query_tl qtl,

Line 2036: CSM_UTIL_PKG.LOG('Leaving HELP_QUERY for query_name: ' || p_query_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);

2032: qrycontext := DBMS_XMLGEN.newcontext(l_query_text) ;
2033: DBMS_XMLGEN.setnullhandling (qrycontext, DBMS_XMLGEN.empty_tag);
2034: p_result := DBMS_XMLGEN.getxml (qrycontext);
2035:
2036: CSM_UTIL_PKG.LOG('Leaving HELP_QUERY for query_name: ' || p_query_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);
2037:
2038: EXCEPTION
2039: WHEN OTHERS THEN
2040: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2042: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);

2038: EXCEPTION
2039: WHEN OTHERS THEN
2040: x_return_status := FND_API.G_RET_STS_ERROR;
2041: x_error_message := 'Exception occurred in HELP_QUERY: ' || sqlerrm;
2042: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);
2043:
2044: END HELP_QUERY;
2045:
2046:

Line 2055: CSM_UTIL_PKG.LOG('Entering SET_PROFILE for p_profile_name: ' || p_profile_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);

2051: IS
2052: l_return_stat boolean;
2053: l_return_flag VARCHAR2(1);
2054: BEGIN
2055: CSM_UTIL_PKG.LOG('Entering SET_PROFILE for p_profile_name: ' || p_profile_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);
2056: l_return_flag := 'N';
2057:
2058: l_return_stat := fnd_profile.save(p_profile_name, p_profile_value, 'SITE');
2059: IF l_return_stat THEN

Line 2064: CSM_UTIL_PKG.LOG('Leaving SET_PROFILE for p_profile_name: ' || p_profile_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);

2060: l_return_flag := 'Y';
2061: COMMIT;
2062: END IF;
2063:
2064: CSM_UTIL_PKG.LOG('Leaving SET_PROFILE for p_profile_name: ' || p_profile_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);
2065: RETURN l_return_flag;
2066: END set_profile;
2067:
2068: PROCEDURE NOTIFY_EMAIL_EXCEPTION

Line 2092: CSM_UTIL_PKG.LOG('Entering NOTIFY_EMAIL_EXCEPTION for EMAIL_ID: ' || p_email_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);

2088: l_user_name fnd_user.user_name%type;
2089: l_user_id NUMBER;
2090: BEGIN
2091:
2092: CSM_UTIL_PKG.LOG('Entering NOTIFY_EMAIL_EXCEPTION for EMAIL_ID: ' || p_email_id, g_object_name, FND_LOG.LEVEL_PROCEDURE);
2093:
2094: l_user_id := IS_FND_USER(p_email_id);
2095:
2096: IF l_user_id = -1 THEN

Line 2099: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);

2095:
2096: IF l_user_id = -1 THEN
2097: x_return_status := fnd_api.g_ret_sts_error;
2098: x_error_message := 'EMAIL_ID: ' || p_email_id || ' is not accosiated to a valid FND_USER';
2099: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_ERROR);
2100: RETURN;
2101: END IF;
2102:
2103: OPEN c_role(p_email_id, l_user_id);

Line 2116: CSM_UTIL_PKG.LOG('Created Role : ' || l_role_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);

2112: display_name => l_user_name,
2113: notification_preference => 'MAILTEXT',
2114: email_address =>p_email_id);
2115:
2116: CSM_UTIL_PKG.LOG('Created Role : ' || l_role_name, g_object_name, FND_LOG.LEVEL_PROCEDURE);
2117:
2118: END IF;
2119:
2120: l_nid := wf_notification.Send

Line 2141: CSM_UTIL_PKG.LOG('Leaving NOTIFY_EMAIL_EXECPTION for EMAIL_ID: ' || p_email_id || ' NID: ' || l_nid, g_object_name, FND_LOG.LEVEL_PROCEDURE);

2137: wf_notification.denormalize_notification(l_nid);
2138: x_return_status := fnd_api.g_ret_sts_success;
2139: x_error_message := 'Successfully send notification id: ' || l_nid || ' to role: ' || l_role_name;
2140:
2141: CSM_UTIL_PKG.LOG('Leaving NOTIFY_EMAIL_EXECPTION for EMAIL_ID: ' || p_email_id || ' NID: ' || l_nid, g_object_name, FND_LOG.LEVEL_PROCEDURE);
2142:
2143: EXCEPTION
2144: WHEN OTHERS THEN
2145: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2147: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);

2143: EXCEPTION
2144: WHEN OTHERS THEN
2145: x_return_status := FND_API.G_RET_STS_ERROR;
2146: x_error_message := 'Exception occurred in NOTIFY_EMAIL_EXCEPTION: ' || sqlerrm;
2147: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);
2148:
2149: END NOTIFY_EMAIL_EXCEPTION;
2150:
2151: /*Get item information for a given item*/

Line 2231: CSM_UTIL_PKG.LOG('Entering GET_ITEM_DETAILS for Item : ' || p_item, g_object_name, FND_LOG.LEVEL_PROCEDURE);

2227: l_profile_value NUMBER;
2228: L_ORG_NAME VARCHAR2(2000);
2229:
2230: BEGIN
2231: CSM_UTIL_PKG.LOG('Entering GET_ITEM_DETAILS for Item : ' || p_item, g_object_name, FND_LOG.LEVEL_PROCEDURE);
2232:
2233: l_profile_value := TO_NUMBER(fnd_profile.value_specific('CS_INV_VALIDATION_ORG',G_USER_ID,NULL,NULL));
2234:
2235: --get org name for display

Line 2247: CSM_UTIL_PKG.LOG( x_error_message,g_object_name, FND_LOG.LEVEL_ERROR);

2243:
2244: IF LST_ITEM_ATTR.COUNT = 0 THEN
2245: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2246: x_error_message := 'The Item ' ||P_ITEM || 'is not present in the Organization ' || l_profile_value;
2247: CSM_UTIL_PKG.LOG( x_error_message,g_object_name, FND_LOG.LEVEL_ERROR);
2248: RETURN ;
2249: END IF;
2250:
2251: L_XML_RESULT := ''

Line 2274: CSM_UTIL_PKG.LOG('Leaving GET_ITEM_DETAILS for Item Name : ' || p_item, g_object_name, FND_LOG.LEVEL_PROCEDURE);

2270:
2271: l_xml_result := l_xml_result || '';
2272:
2273: p_result := l_xml_result;
2274: CSM_UTIL_PKG.LOG('Leaving GET_ITEM_DETAILS for Item Name : ' || p_item, g_object_name, FND_LOG.LEVEL_PROCEDURE);
2275:
2276: EXCEPTION
2277: WHEN OTHERS THEN
2278: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2280: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);

2276: EXCEPTION
2277: WHEN OTHERS THEN
2278: x_return_status := FND_API.G_RET_STS_ERROR;
2279: x_error_message := 'Exception occurred in GET_ITEM_DETAILS: ' || sqlerrm;
2280: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);
2281:
2282: END GET_ITEM_DETAILS;
2283:
2284: /*Procedure to get the Available Substitutes or Supersessions*/

Line 2364: CSM_UTIL_PKG.LOG('Entering GET_PART_SUB for Item : ' || p_item, g_object_name, FND_LOG.LEVEL_PROCEDURE);

2360: L_GIVEN_ITEM_NAME VARCHAR2(40);
2361: L_GIVEN_ITEM_DESC VARCHAR2(240);
2362: L_ORG_NAME VARCHAR2(2000);
2363: BEGIN
2364: CSM_UTIL_PKG.LOG('Entering GET_PART_SUB for Item : ' || p_item, g_object_name, FND_LOG.LEVEL_PROCEDURE);
2365:
2366: l_profile_value := TO_NUMBER(fnd_profile.value_specific('CS_INV_VALIDATION_ORG',G_USER_ID,NULL,NULL));
2367:
2368: --get org name for display

Line 2381: CSM_UTIL_PKG.LOG( x_error_message,g_object_name, FND_LOG.LEVEL_ERROR);

2377:
2378: IF L_GIVEN_ITEM_ID IS NULL THEN
2379: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2380: x_error_message := 'The given Item ' ||P_ITEM || 'is not present in the Organization ' || l_profile_value;
2381: CSM_UTIL_PKG.LOG( x_error_message,g_object_name, FND_LOG.LEVEL_ERROR);
2382: RETURN ;
2383: END IF;
2384:
2385: --get the substitutes

Line 2393: CSM_UTIL_PKG.LOG( x_error_message,g_object_name, FND_LOG.LEVEL_ERROR);

2389:
2390: IF LST_PART_SUBS.COUNT = 0 THEN
2391: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2392: x_error_message := 'There is no Valid Substitue found for the Item ' ||P_ITEM || 'in the Organization ' || l_profile_value;
2393: CSM_UTIL_PKG.LOG( x_error_message,g_object_name, FND_LOG.LEVEL_ERROR);
2394: RETURN ;
2395: END IF;
2396:
2397:

Line 2438: CSM_UTIL_PKG.LOG('Leaving GET_PART_SUB for Item Name : ' || p_item, g_object_name, FND_LOG.LEVEL_PROCEDURE);

2434: l_xml_result := l_xml_result || '';
2435:
2436: p_result := l_xml_result;
2437:
2438: CSM_UTIL_PKG.LOG('Leaving GET_PART_SUB for Item Name : ' || p_item, g_object_name, FND_LOG.LEVEL_PROCEDURE);
2439:
2440: EXCEPTION
2441: WHEN OTHERS THEN
2442: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2444: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);

2440: EXCEPTION
2441: WHEN OTHERS THEN
2442: x_return_status := FND_API.G_RET_STS_ERROR;
2443: x_error_message := 'Exception occurred in GET_PART_SUB: ' || sqlerrm;
2444: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);
2445:
2446: END GET_PART_SUB;
2447:
2448: /*Procedure to get the Available Ohq*/

Line 2523: CSM_UTIL_PKG.LOG('Entering GET_PART_AVAIL for Item : ' || p_item, g_object_name, FND_LOG.LEVEL_PROCEDURE);

2519: l_count NUMBER;
2520: l_resource_id NUMBER;
2521:
2522: BEGIN
2523: CSM_UTIL_PKG.LOG('Entering GET_PART_AVAIL for Item : ' || p_item, g_object_name, FND_LOG.LEVEL_PROCEDURE);
2524:
2525: l_profile_value := TO_NUMBER(fnd_profile.value_specific('CS_INV_VALIDATION_ORG',G_USER_ID,NULL,NULL));
2526:
2527: --get org name for display

Line 2540: CSM_UTIL_PKG.LOG( x_error_message,g_object_name, FND_LOG.LEVEL_ERROR);

2536:
2537: IF L_GIVEN_ITEM_ID IS NULL THEN
2538: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2539: x_error_message := 'The given Item ' ||P_ITEM || 'is not present in the Organization ' || l_profile_value;
2540: CSM_UTIL_PKG.LOG( x_error_message,g_object_name, FND_LOG.LEVEL_ERROR);
2541: RETURN ;
2542: END IF;
2543:
2544: --Set the item parameter

Line 2619: CSM_UTIL_PKG.LOG('Leaving GET_PART_AVAIL for Item Name : ' || p_item, g_object_name, FND_LOG.LEVEL_PROCEDURE);

2615: l_xml_result := l_xml_result || '';
2616:
2617: p_result := l_xml_result;
2618:
2619: CSM_UTIL_PKG.LOG('Leaving GET_PART_AVAIL for Item Name : ' || p_item, g_object_name, FND_LOG.LEVEL_PROCEDURE);
2620:
2621: EXCEPTION
2622: WHEN OTHERS THEN
2623: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2625: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);

2621: EXCEPTION
2622: WHEN OTHERS THEN
2623: x_return_status := FND_API.G_RET_STS_ERROR;
2624: x_error_message := 'Exception occurred in GET_PART_AVAIL: ' || sqlerrm;
2625: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);
2626:
2627: END GET_PART_AVAIL;
2628:
2629: /*Procedure to get the Part Return Information*/

Line 2716: CSM_UTIL_PKG.LOG('Entering GET_PART_RETURN_INFO for Item : ' || p_item, g_object_name, FND_LOG.LEVEL_PROCEDURE);

2712: l_resource_id NUMBER;
2713: L_CONDITION_CODE VARCHAR2(1000);
2714:
2715: BEGIN
2716: CSM_UTIL_PKG.LOG('Entering GET_PART_RETURN_INFO for Item : ' || p_item, g_object_name, FND_LOG.LEVEL_PROCEDURE);
2717:
2718: l_profile_value := TO_NUMBER(fnd_profile.value_specific('CS_INV_VALIDATION_ORG',G_USER_ID,NULL,NULL));
2719: l_resource_id := GET_RESOURCE_ID( G_USER_ID);
2720: --get org name for display

Line 2733: CSM_UTIL_PKG.LOG( x_error_message,g_object_name, FND_LOG.LEVEL_ERROR);

2729:
2730: IF L_GIVEN_ITEM_ID IS NULL THEN
2731: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
2732: x_error_message := 'The given Item ' ||P_ITEM || 'is not present in the Organization ' || l_profile_value;
2733: CSM_UTIL_PKG.LOG( x_error_message,g_object_name, FND_LOG.LEVEL_ERROR);
2734: RETURN ;
2735: END IF;
2736:
2737: L_XML_RESULT := ''

Line 2827: CSM_UTIL_PKG.LOG('Leaving GET_PART_RETURN_INFO for Item Name : ' || p_item, g_object_name, FND_LOG.LEVEL_PROCEDURE);

2823:
2824: l_xml_result := l_xml_result || '';
2825: p_result := l_xml_result;
2826:
2827: CSM_UTIL_PKG.LOG('Leaving GET_PART_RETURN_INFO for Item Name : ' || p_item, g_object_name, FND_LOG.LEVEL_PROCEDURE);
2828:
2829: EXCEPTION
2830: WHEN OTHERS THEN
2831: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2833: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);

2829: EXCEPTION
2830: WHEN OTHERS THEN
2831: x_return_status := FND_API.G_RET_STS_ERROR;
2832: x_error_message := 'Exception occurred in GET_PART_RETURN_INFO: ' || sqlerrm;
2833: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_EXCEPTION);
2834:
2835: END GET_PART_RETURN_INFO;
2836:
2837: