206: , p_show_on_calendar => p_show_on_calendar
207: , p_owner_status_id => p_owner_status_id
208: , p_template_id => p_template_id
209: , p_template_group_id => p_template_group_id
210: , p_enable_workflow => fnd_profile.VALUE('JTF_TASK_ENABLE_WORKFLOW')
211: , p_abort_workflow => fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
212: , p_entity => g_entity
213: , p_free_busy_type => NULL
214: , p_task_confirmation_status => 'N'
207: , p_owner_status_id => p_owner_status_id
208: , p_template_id => p_template_id
209: , p_template_group_id => p_template_group_id
210: , p_enable_workflow => fnd_profile.VALUE('JTF_TASK_ENABLE_WORKFLOW')
211: , p_abort_workflow => fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
212: , p_entity => g_entity
213: , p_free_busy_type => NULL
214: , p_task_confirmation_status => 'N'
215: , p_task_confirmation_counter => NULL
1512: -- Set owner_status_id from profile if not supplied
1513: -- ------------------------------------------------------------------------
1514: IF p_owner_status_id IS NULL OR p_owner_status_id = fnd_api.g_miss_num THEN
1515: -- Added NVL on 04/08/2006 for bug# 5408967
1516: l_owner_status_id := NVL(fnd_profile.VALUE(NAME => 'JTF_TASK_DEFAULT_ASSIGNEE_STATUS'), 3);
1517: ELSE
1518: l_owner_status_id := p_owner_status_id;
1519: END IF;
1520:
1890: , p_date_selected => p_date_selected
1891: , p_category_id => p_category_id
1892: , p_show_on_calendar => p_show_on_calendar
1893: , p_owner_status_id => p_owner_status_id
1894: , p_enable_workflow => fnd_profile.VALUE('JTF_TASK_ENABLE_WORKFLOW')
1895: , p_abort_workflow => fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
1896: , p_change_mode => jtf_task_repeat_appt_pvt.g_one
1897: , p_free_busy_type => jtf_task_utl.g_miss_char
1898: );
1891: , p_category_id => p_category_id
1892: , p_show_on_calendar => p_show_on_calendar
1893: , p_owner_status_id => p_owner_status_id
1894: , p_enable_workflow => fnd_profile.VALUE('JTF_TASK_ENABLE_WORKFLOW')
1895: , p_abort_workflow => fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
1896: , p_change_mode => jtf_task_repeat_appt_pvt.g_one
1897: , p_free_busy_type => jtf_task_utl.g_miss_char
1898: );
1899:
3949:
3950: IF c_owner_status_id%NOTFOUND THEN
3951: CLOSE c_owner_status_id;
3952: /*Modified for Bug# 8574559 */
3953: l_owner_status_id := NVL(fnd_profile.VALUE(NAME => 'JTF_TASK_DEFAULT_ASSIGNEE_STATUS'), 3);
3954: ELSE
3955: CLOSE c_owner_status_id;
3956: END IF;
3957: ELSE
3955: CLOSE c_owner_status_id;
3956: END IF;
3957: ELSE
3958: -- Added NVL on 08/08/2006 for bug# 5452407
3959: l_owner_status_id := NVL(fnd_profile.VALUE(NAME => 'JTF_TASK_DEFAULT_ASSIGNEE_STATUS'), 3);
3960: END IF;
3961:
3962: -- ------------------------------------------------------------------------
3963: -- Update task assignment for Owner if changed
4163:
4164: l_name := null;
4165: l_name := JTF_TASK_UTL.get_owner(task_ass_orig_rec.resource_type_code, task_ass_orig_rec.resource_id);
4166: l_date := l_booking_start_date;
4167: IF(fnd_profile.Value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y') THEN
4168: l_date := To_Char(CAC_AVLBLTY_PVT.ADJUST_FOR_TIMEZONE(fnd_profile.value('SERVER_TIMEZONE_ID'),
4169: fnd_profile.value('CLIENT_TIMEZONE_ID'),
4170: l_booking_start_date),
4171: fnd_profile.Value('ICX_DATE_FORMAT_MASK')||' HH:MI:SS AM');
4164: l_name := null;
4165: l_name := JTF_TASK_UTL.get_owner(task_ass_orig_rec.resource_type_code, task_ass_orig_rec.resource_id);
4166: l_date := l_booking_start_date;
4167: IF(fnd_profile.Value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y') THEN
4168: l_date := To_Char(CAC_AVLBLTY_PVT.ADJUST_FOR_TIMEZONE(fnd_profile.value('SERVER_TIMEZONE_ID'),
4169: fnd_profile.value('CLIENT_TIMEZONE_ID'),
4170: l_booking_start_date),
4171: fnd_profile.Value('ICX_DATE_FORMAT_MASK')||' HH:MI:SS AM');
4172: END IF;
4165: l_name := JTF_TASK_UTL.get_owner(task_ass_orig_rec.resource_type_code, task_ass_orig_rec.resource_id);
4166: l_date := l_booking_start_date;
4167: IF(fnd_profile.Value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y') THEN
4168: l_date := To_Char(CAC_AVLBLTY_PVT.ADJUST_FOR_TIMEZONE(fnd_profile.value('SERVER_TIMEZONE_ID'),
4169: fnd_profile.value('CLIENT_TIMEZONE_ID'),
4170: l_booking_start_date),
4171: fnd_profile.Value('ICX_DATE_FORMAT_MASK')||' HH:MI:SS AM');
4172: END IF;
4173:
4167: IF(fnd_profile.Value('ENABLE_TIMEZONE_CONVERSIONS') = 'Y') THEN
4168: l_date := To_Char(CAC_AVLBLTY_PVT.ADJUST_FOR_TIMEZONE(fnd_profile.value('SERVER_TIMEZONE_ID'),
4169: fnd_profile.value('CLIENT_TIMEZONE_ID'),
4170: l_booking_start_date),
4171: fnd_profile.Value('ICX_DATE_FORMAT_MASK')||' HH:MI:SS AM');
4172: END IF;
4173:
4174: fnd_message.set_name ('JTF', 'JTF_APPT_RES_NOT_AVAILABLE');
4175: fnd_message.set_token ('RES', l_name );
4365: , p_delete_future_recurrences => p_delete_future_recurrences
4366: , x_return_status => x_return_status
4367: , x_msg_count => x_msg_count
4368: , x_msg_data => x_msg_data
4369: , p_enable_workflow => fnd_profile.VALUE('JTF_TASK_ENABLE_WORKFLOW')
4370: , p_abort_workflow => fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
4371: );
4372:
4373: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
4366: , x_return_status => x_return_status
4367: , x_msg_count => x_msg_count
4368: , x_msg_data => x_msg_data
4369: , p_enable_workflow => fnd_profile.VALUE('JTF_TASK_ENABLE_WORKFLOW')
4370: , p_abort_workflow => fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
4371: );
4372:
4373: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
4374: x_return_status := fnd_api.g_ret_sts_unexp_error;
4841: , p_task_assignment_id => c.task_assignment_id
4842: , x_return_status => x_return_status
4843: , x_msg_count => x_msg_count
4844: , x_msg_data => x_msg_data
4845: , p_enable_workflow => fnd_profile.VALUE('JTF_TASK_ENABLE_WORKFLOW')
4846: , p_abort_workflow => fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
4847: , p_delete_option => jtf_task_repeat_appt_pvt.g_skip
4848: );
4849:
4842: , x_return_status => x_return_status
4843: , x_msg_count => x_msg_count
4844: , x_msg_data => x_msg_data
4845: , p_enable_workflow => fnd_profile.VALUE('JTF_TASK_ENABLE_WORKFLOW')
4846: , p_abort_workflow => fnd_profile.VALUE('JTF_TASK_ABORT_PREV_WF')
4847: , p_delete_option => jtf_task_repeat_appt_pvt.g_skip
4848: );
4849:
4850: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN