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_API

Line 414: x_return_status := FND_API.G_RET_STS_ERROR;

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';
416: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);
417: RETURN;
418: END IF;

Line 426: x_return_status := FND_API.G_RET_STS_ERROR;

422: OPEN c_get_query_id (l_command_name);
423: FETCH c_get_query_id INTO l_query_id, l_restricted_flag, l_disabled_flag, l_level_id, l_level_value;
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;

Line 433: x_return_status := FND_API.G_RET_STS_ERROR;

429: RETURN;
430: END IF;
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;

Line 442: x_return_status := FND_API.G_RET_STS_ERROR;

438:
439: IF l_restricted_flag = 'Y' THEN
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;

Line 452: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 464: x_return_status := FND_API.G_RET_STS_ERROR;

460: FETCH c_get_reqd_vars INTO l_reqd_var_count;
461: CLOSE c_get_reqd_vars;
462:
463: IF l_reqd_var_count <> p_var_value_lst.count THEN
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);

Line 520: p_commit => fnd_api.G_TRUE,

516: p_INSTANCE_NAME => NULL,
517: p_VARIABLE_ID => l_variable_id_lst,
518: p_VARIABLE_VALUE_CHAR => l_var_value_lst,
519: p_VARIABLE_VALUE_DATE => l_var_value_date_lst,
520: p_commit => fnd_api.G_TRUE,
521: x_INSTANCE_ID => p_instance_id,
522: x_return_status => x_return_status,
523: x_error_message => x_error_message
524: );

Line 526: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

522: x_return_status => x_return_status,
523: x_error_message => x_error_message
524: );
525:
526: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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;

Line 527: x_return_status := FND_API.G_RET_STS_ERROR;

523: x_error_message => x_error_message
524: );
525:
526: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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);

Line 541: p_commit => fnd_api.G_TRUE,

537: p_QUERY_ID => l_query_id,
538: p_INSTANCE_ID => p_instance_id,
539: x_return_status => x_return_status,
540: x_error_message => x_error_message,
541: p_commit => fnd_api.G_TRUE,
542: p_source_module => 'EMAIL');
543:
544: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
545: x_return_status := FND_API.G_RET_STS_ERROR;

Line 544: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

540: x_error_message => x_error_message,
541: p_commit => fnd_api.G_TRUE,
542: p_source_module => 'EMAIL');
543:
544: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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;

Line 545: x_return_status := FND_API.G_RET_STS_ERROR;

541: p_commit => fnd_api.G_TRUE,
542: p_source_module => 'EMAIL');
543:
544: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
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);

Line 565: x_return_status := fnd_api.g_ret_sts_error;

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

Line 694: x_return_status := FND_API.G_RET_STS_ERROR;

690:
691: l_user_id := IS_FND_USER(p_email_id);
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;

Line 787: x_return_status := FND_API.G_RET_STS_ERROR;

783: END IF;
784: END LOOP;
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;

Line 794: x_return_status := FND_API.G_RET_STS_ERROR;

790: RETURN;
791: END IF;
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;

Line 802: x_return_status := FND_API.G_RET_STS_ERROR;

798: END IF;
799: ELSE
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

Line 807: 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.';
809: CSM_UTIL_PKG.LOG(x_error_message, g_object_name, FND_LOG.LEVEL_PROCEDURE);
810: RETURN;
811: END IF;

Line 912: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 985: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 995: , p_init_msg_list => FND_API.G_TRUE

991: FOR r_task_assignments IN c_task_assignments(p_task_number, l_resource_id) LOOP
992:
993: csf_task_assignments_pub.update_assignment_status
994: ( p_api_version => 1.0
995: , p_init_msg_list => FND_API.G_TRUE
996: , p_commit => FND_API.G_TRUE
997: -- Bug 101406041 , p_validation_level => FND_API.G_VALID_LEVEL_NONE
998: -- Validate task status transitions.
999: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

Line 996: , p_commit => FND_API.G_TRUE

992:
993: csf_task_assignments_pub.update_assignment_status
994: ( p_api_version => 1.0
995: , p_init_msg_list => FND_API.G_TRUE
996: , p_commit => FND_API.G_TRUE
997: -- Bug 101406041 , p_validation_level => FND_API.G_VALID_LEVEL_NONE
998: -- Validate task status transitions.
999: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1000: , x_return_status => x_return_status

Line 997: -- Bug 101406041 , p_validation_level => FND_API.G_VALID_LEVEL_NONE

993: csf_task_assignments_pub.update_assignment_status
994: ( p_api_version => 1.0
995: , p_init_msg_list => FND_API.G_TRUE
996: , p_commit => FND_API.G_TRUE
997: -- Bug 101406041 , p_validation_level => FND_API.G_VALID_LEVEL_NONE
998: -- Validate task status transitions.
999: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1000: , x_return_status => x_return_status
1001: , x_msg_count => l_msg_count

Line 999: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

995: , p_init_msg_list => FND_API.G_TRUE
996: , p_commit => FND_API.G_TRUE
997: -- Bug 101406041 , p_validation_level => FND_API.G_VALID_LEVEL_NONE
998: -- Validate task status transitions.
999: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1000: , x_return_status => x_return_status
1001: , x_msg_count => l_msg_count
1002: , x_msg_data => l_msg_data
1003: , p_task_assignment_id => r_task_assignments.task_assignment_id

Line 1011: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1007: , x_task_object_version_number => l_task_object_version_number
1008: , x_task_status_id => l_task_status_id
1009: );
1010:
1011: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1012: x_return_status := FND_API.G_RET_STS_ERROR;
1013: l_msg_data := replace(l_msg_data,fnd_global.local_chr(10), ' ');
1014: x_error_message := 'Error in UPDATE_TASK :'
1015: || ' ROOT ERROR: csf_task_assignments_pub.update_assignment_status'

Line 1012: x_return_status := FND_API.G_RET_STS_ERROR;

1008: , x_task_status_id => l_task_status_id
1009: );
1010:
1011: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1012: x_return_status := FND_API.G_RET_STS_ERROR;
1013: l_msg_data := replace(l_msg_data,fnd_global.local_chr(10), ' ');
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

Line 1029: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1049: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1066: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1086: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1103: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1124: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1141: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1164: x_return_status := FND_API.G_RET_STS_ERROR;

1160:
1161: l_profile_value := TO_NUMBER(fnd_profile.value('CSF_DEFAULT_TRAVELING_STATUS'));
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;

Line 1181: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1201: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1218: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1250: x_return_status := FND_API.G_RET_STS_ERROR;

1246:
1247: l_profile_value := TO_NUMBER(fnd_profile.value('CSF_DEFAULT_COMPLETED_STATUS'));
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;

Line 1267: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1313: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1328: x_return_status := FND_API.G_RET_STS_ERROR;

1324: FETCH c_note_status INTO l_note_status;
1325: CLOSE c_note_status;
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;

Line 1346: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

1342:
1343: IF LENGTH(l_notes) > 2000 THEN
1344: jtf_notes_pub.create_note
1345: ( p_api_version => 1.0
1346: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1347: , p_init_msg_list => FND_API.G_TRUE
1348: , p_commit => FND_API.G_TRUE
1349: , x_return_status => x_return_status
1350: , x_msg_count => l_msg_count

Line 1347: , p_init_msg_list => FND_API.G_TRUE

1343: IF LENGTH(l_notes) > 2000 THEN
1344: jtf_notes_pub.create_note
1345: ( p_api_version => 1.0
1346: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1347: , p_init_msg_list => FND_API.G_TRUE
1348: , p_commit => FND_API.G_TRUE
1349: , x_return_status => x_return_status
1350: , x_msg_count => l_msg_count
1351: , x_msg_data => x_error_message

Line 1348: , p_commit => FND_API.G_TRUE

1344: jtf_notes_pub.create_note
1345: ( p_api_version => 1.0
1346: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1347: , p_init_msg_list => FND_API.G_TRUE
1348: , p_commit => FND_API.G_TRUE
1349: , x_return_status => x_return_status
1350: , x_msg_count => l_msg_count
1351: , x_msg_data => x_error_message
1352: , p_source_object_id => l_task_id

Line 1370: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

1366: );
1367: ELSE
1368: jtf_notes_pub.create_note
1369: ( p_api_version => 1.0
1370: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1371: , p_init_msg_list => FND_API.G_TRUE
1372: , p_commit => FND_API.G_TRUE
1373: , x_return_status => x_return_status
1374: , x_msg_count => l_msg_count

Line 1371: , p_init_msg_list => FND_API.G_TRUE

1367: ELSE
1368: jtf_notes_pub.create_note
1369: ( p_api_version => 1.0
1370: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1371: , p_init_msg_list => FND_API.G_TRUE
1372: , p_commit => FND_API.G_TRUE
1373: , x_return_status => x_return_status
1374: , x_msg_count => l_msg_count
1375: , x_msg_data => x_error_message

Line 1372: , p_commit => FND_API.G_TRUE

1368: jtf_notes_pub.create_note
1369: ( p_api_version => 1.0
1370: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
1371: , p_init_msg_list => FND_API.G_TRUE
1372: , p_commit => FND_API.G_TRUE
1373: , x_return_status => x_return_status
1374: , x_msg_count => l_msg_count
1375: , x_msg_data => x_error_message
1376: , p_source_object_id => l_task_id

Line 1393: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1389: , x_jtf_note_id => l_jtf_note_id
1390: );
1391: END IF;
1392:
1393: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1394: x_return_status := FND_API.G_RET_STS_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

Line 1394: x_return_status := FND_API.G_RET_STS_ERROR;

1390: );
1391: END IF;
1392:
1393: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1394: x_return_status := FND_API.G_RET_STS_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;

Line 1408: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1545: x_return_status := FND_API.G_RET_STS_ERROR;

1541:
1542: l_task_access_flag := CHECK_TASK_ACCESS(g_user_id, p_task_number);
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;

Line 1613: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1754: x_return_status := FND_API.G_RET_STS_ERROR;

1750: END IF;
1751: END LOOP;
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;

Line 1832: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1955: p_init_msg_list => fnd_api.g_true,

1951: l_inp_rec.validate_flag := 'N';
1952:
1953: oks_entitlements_pub.get_contracts
1954: ( p_api_version => 1.0,
1955: p_init_msg_list => fnd_api.g_true,
1956: p_inp_rec => l_inp_rec,
1957: x_return_status => x_return_status,
1958: x_msg_count => l_msg_count,
1959: x_msg_data => l_msg_data,

Line 1963: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1959: x_msg_data => l_msg_data,
1960: x_ent_contracts => l_ent_contracts
1961: );
1962:
1963: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1964: x_return_status := FND_API.G_RET_STS_ERROR;
1965: x_error_message := 'Error in GET_ENTITLEMENTS :'
1966: || ' ROOT ERROR: oks_entitlements_pub.get_contracts'
1967: || ' for serial number : ' || p_serial_number

Line 1964: x_return_status := FND_API.G_RET_STS_ERROR;

1960: x_ent_contracts => l_ent_contracts
1961: );
1962:
1963: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1964: x_return_status := FND_API.G_RET_STS_ERROR;
1965: x_error_message := 'Error in GET_ENTITLEMENTS :'
1966: || ' ROOT ERROR: oks_entitlements_pub.get_contracts'
1967: || ' for serial number : ' || p_serial_number
1968: || ' Details:' || l_msg_data;

Line 2002: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2040: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2097: x_return_status := fnd_api.g_ret_sts_error;

2093:
2094: l_user_id := IS_FND_USER(p_email_id);
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;

Line 2138: x_return_status := fnd_api.g_ret_sts_success;

2134: , p_subject
2135: );
2136:
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:

Line 2145: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2245: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2241: FETCH C_GET_ITEM BULK COLLECT INTO LST_ITEM_ATTR;
2242: CLOSE C_GET_ITEM;
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;

Line 2278: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2379: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2375: FETCH C_GET_ITEM INTO L_GIVEN_ITEM_ID,L_GIVEN_ITEM_NAME,L_GIVEN_ITEM_DESC;
2376: CLOSE C_GET_ITEM;
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;

Line 2391: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2387: FETCH c_get_sub BULK COLLECT INTO LST_PART_SUBS;
2388: CLOSE c_get_sub;
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;

Line 2442: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2538: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2534: FETCH C_GET_ITEM INTO L_GIVEN_ITEM_ID,L_GIVEN_ITEM_NAME,L_GIVEN_ITEM_DESC;
2535: CLOSE C_GET_ITEM;
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;

Line 2623: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 2731: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

2727: FETCH C_GET_ITEM INTO L_GIVEN_ITEM_ID,L_GIVEN_ITEM_NAME,L_GIVEN_ITEM_DESC;
2728: CLOSE C_GET_ITEM;
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;

Line 2831: x_return_status := FND_API.G_RET_STS_ERROR;

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