[Home] [Help]
1199:
1200: IF p_new_sts_cancelled_flag = 'Y' THEN
1201: -- Cancel all the Open Task Assignments
1202: FOR v_task_assignment IN c_cancel_task_assignments LOOP
1203: csf_task_assignments_pub.update_assignment_status(
1204: p_api_version => 1.0
1205: , x_return_status => x_return_status
1206: , x_msg_count => x_msg_count
1207: , x_msg_data => x_msg_data
1688: l_trip_id := NULL;
1689: END IF;
1690:
1691: IF NVL(l_trip_id, -1) <> NVL(l_task_info.object_capacity_id,-1) THEN
1692: csf_task_assignments_pub.update_task_assignment(
1693: p_api_version => p_api_version
1694: , p_init_msg_list => p_init_msg_list
1695: , p_commit => fnd_api.g_false
1696: , p_validation_level => fnd_api.g_valid_level_none
2041: fnd_msg_pub.ADD;
2042: RAISE fnd_api.g_exc_error;
2043: END IF;
2044:
2045: csf_task_assignments_pub.update_assignment_status(
2046: p_api_version => 1.0
2047: , p_validation_level => fnd_api.g_valid_level_none
2048: , p_init_msg_list => fnd_api.g_false
2049: , p_commit => fnd_api.g_false
2979: l_assignment_status_id := p_assignment_status_id;
2980: x_task_assignment_id := p_old_task_assignment_id;
2981: END IF;
2982:
2983: csf_task_assignments_pub.update_task_assignment (
2984: p_api_version => 1.0
2985: , p_validation_level => fnd_api.g_valid_level_none
2986: , x_return_status => x_return_status
2987: , x_msg_count => x_msg_count
3037: END IF;
3038:
3039: -- Create the Task Assignment
3040: IF l_create_assignment THEN
3041: csf_task_assignments_pub.create_task_assignment(
3042: p_api_version => 1.0
3043: , p_validation_level => fnd_api.g_valid_level_none
3044: , x_return_status => x_return_status
3045: , x_msg_count => x_msg_count
3153: -- Cancel the Task Assignment
3154: -- P_OBJECT_CAPACITY_ID is passed as NULL so that when UPDATE_ASSIGNMENT_STATUS
3155: -- Queries the Task Information, there will not be any Trip Information and
3156: -- Update is avoided as Scheduler will take care of the update.
3157: csf_task_assignments_pub.update_task_assignment (
3158: p_api_version => 1.0
3159: , p_validation_level => fnd_api.g_valid_level_none
3160: , x_return_status => x_return_status
3161: , x_msg_count => x_msg_count
4463: END IF;
4464:
4465: l_task_id := x_task_id;
4466:
4467: csf_task_assignments_pub.create_task_assignment(
4468: p_api_version => p_api_version
4469: , p_init_msg_list =>p_init_msg_list
4470: , p_commit =>p_commit
4471: , x_return_status =>x_return_status
4627: fetch c_task_ass into l_task_assignment_id;
4628: close c_task_ass;
4629:
4630:
4631: csf_task_assignments_pub.update_task_assignment(
4632: p_api_version =>p_api_version
4633: , p_init_msg_list => p_init_msg_list
4634: , p_commit =>p_commit
4635: , x_return_status =>x_return_status