[Home] [Help]
759: -- Get the value for the profile option 'Service : Apply State Restriction on Tasks'
760: -- to decide the enabling/disabling of task state restrictions
761:
762: -- in order to fix 4477767, task restriction can not be applied to auto tasks
763: -- FND_PROFILE.Get('CS_SR_ENABLE_TASK_STATE_RESTRICTIONS',l_prof_val);
764:
765: -- end of simplex
766:
767:
1019: p_commit => cs_core_util.get_g_false,
1020: p_task_id => l_task_id,
1021: p_resource_type_code => l_task_rec_tbl(l_indx).assignee_type_code,
1022: p_resource_id => l_task_rec_tbl(l_indx).assignee_id,
1023: p_assignment_status_id => fnd_profile.value('JTF_TASK_DEFAULT_ASSIGNEE_STATUS'),
1024: x_return_status => x_return_status,
1025: x_msg_count => x_msg_count,
1026: x_msg_data => x_msg_data,
1027: x_task_assignment_id => l_task_assignment_id);
1159: x_msg_data OUT NOCOPY varchar2,
1160: x_auto_task_gen_attempted OUT NOCOPY varchar2,
1161: x_field_service_Task_created OUT NOCOPY varchar2) is
1162: i number;
1163: l_prof_value fnd_profile_option_values.profile_option_value % type;
1164: l_err varchar2(4000);
1165: l_msg_index_out number;
1166: l_msg_data varchar2(2000);
1167: l_note_id number;
1173: cursor c_sr is
1174: select * from cs_incidents_all_b
1175: where incident_id = p_request_id;
1176: begin
1177: l_prof_value := fnd_profile.value('AUTO GENERATE TASKS ON SR CREATE');
1178: if (l_prof_value = 'Task type Attribute configuration' or 1 =1) then
1179: for l_rec in c_sr loop
1180: l_sr_rec.type_id := l_rec.incident_type_id;
1181: l_sr_rec.status_id := l_rec.incident_status_id;
1402: p_data=>l_msg_data,
1403: p_msg_index_out=>l_msg_index_out);
1404: l_err := l_err || l_msg_data || ',';
1405: end loop;
1406: l_note_type := fnd_profile.value('CS_SR_TASK_ERROR_NOTE_TYPE');
1407: if (l_note_type is null) then
1408: fnd_message.set_name ('CS', 'CS_EA_NULL_NOTE_TYPE');
1409: fnd_msg_pub.add;
1410: raise fnd_api.g_exc_unexpected_error;