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.CSF_GANTT_DATA_PKG dependencies on FND_API

Line 4117: x_return_status := fnd_api.g_ret_sts_success;

4113:
4114: IF task_id.COUNT IS NULL THEN
4115: l_return_status := 'E';
4116: ELSE
4117: x_return_status := fnd_api.g_ret_sts_success;
4118: END IF;
4119:
4120: IF NOT l_return_status = fnd_api.g_ret_sts_success THEN
4121: -- just return unexpected error, no message, does

Line 4120: IF NOT l_return_status = fnd_api.g_ret_sts_success THEN

4116: ELSE
4117: x_return_status := fnd_api.g_ret_sts_success;
4118: END IF;
4119:
4120: IF NOT l_return_status = fnd_api.g_ret_sts_success THEN
4121: -- just return unexpected error, no message, does
4122: -- not matter, SchedulerResource.java will just skip this resource
4123: -- without message, and only generate an error message
4124: -- when all resources have failed

Line 4125: x_return_status := fnd_api.g_ret_sts_unexp_error;

4121: -- just return unexpected error, no message, does
4122: -- not matter, SchedulerResource.java will just skip this resource
4123: -- without message, and only generate an error message
4124: -- when all resources have failed
4125: x_return_status := fnd_api.g_ret_sts_unexp_error;
4126: RAISE fnd_api.g_exc_unexpected_error;
4127: END IF;
4128:
4129: --standard call to get message count and the message information

Line 4126: RAISE fnd_api.g_exc_unexpected_error;

4122: -- not matter, SchedulerResource.java will just skip this resource
4123: -- without message, and only generate an error message
4124: -- when all resources have failed
4125: x_return_status := fnd_api.g_ret_sts_unexp_error;
4126: RAISE fnd_api.g_exc_unexpected_error;
4127: END IF;
4128:
4129: --standard call to get message count and the message information
4130: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 4133: WHEN fnd_api.g_exc_error THEN

4129: --standard call to get message count and the message information
4130: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4131: --
4132: EXCEPTION
4133: WHEN fnd_api.g_exc_error THEN
4134: x_return_status := fnd_api.g_ret_sts_error;
4135: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4136: WHEN fnd_api.g_exc_unexpected_error THEN
4137: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4134: x_return_status := fnd_api.g_ret_sts_error;

4130: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4131: --
4132: EXCEPTION
4133: WHEN fnd_api.g_exc_error THEN
4134: x_return_status := fnd_api.g_ret_sts_error;
4135: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4136: WHEN fnd_api.g_exc_unexpected_error THEN
4137: x_return_status := fnd_api.g_ret_sts_unexp_error;
4138: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 4136: WHEN fnd_api.g_exc_unexpected_error THEN

4132: EXCEPTION
4133: WHEN fnd_api.g_exc_error THEN
4134: x_return_status := fnd_api.g_ret_sts_error;
4135: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4136: WHEN fnd_api.g_exc_unexpected_error THEN
4137: x_return_status := fnd_api.g_ret_sts_unexp_error;
4138: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4139: WHEN OTHERS THEN
4140: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4137: x_return_status := fnd_api.g_ret_sts_unexp_error;

4133: WHEN fnd_api.g_exc_error THEN
4134: x_return_status := fnd_api.g_ret_sts_error;
4135: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4136: WHEN fnd_api.g_exc_unexpected_error THEN
4137: x_return_status := fnd_api.g_ret_sts_unexp_error;
4138: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4139: WHEN OTHERS THEN
4140: x_return_status := fnd_api.g_ret_sts_unexp_error;
4141:

Line 4140: x_return_status := fnd_api.g_ret_sts_unexp_error;

4136: WHEN fnd_api.g_exc_unexpected_error THEN
4137: x_return_status := fnd_api.g_ret_sts_unexp_error;
4138: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4139: WHEN OTHERS THEN
4140: x_return_status := fnd_api.g_ret_sts_unexp_error;
4141:
4142: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4143: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4144: END IF;

Line 4597: l_planned_effort NUMBER := fnd_api.g_miss_num;

4593: l_start_date DATE;
4594: l_end_date DATE;
4595: l_old_ta_obj_version NUMBER;
4596: l_obj_ver_number VARCHAR2(20);
4597: l_planned_effort NUMBER := fnd_api.g_miss_num;
4598: l_planned_effort_uom VARCHAR2(10) := fnd_api.g_miss_char;
4599:
4600: l_sched_travel_duration NUMBER:=30 ;
4601: l_sched_travel_duration_uom VARCHAR2(10);

Line 4598: l_planned_effort_uom VARCHAR2(10) := fnd_api.g_miss_char;

4594: l_end_date DATE;
4595: l_old_ta_obj_version NUMBER;
4596: l_obj_ver_number VARCHAR2(20);
4597: l_planned_effort NUMBER := fnd_api.g_miss_num;
4598: l_planned_effort_uom VARCHAR2(10) := fnd_api.g_miss_char;
4599:
4600: l_sched_travel_duration NUMBER:=30 ;
4601: l_sched_travel_duration_uom VARCHAR2(10);
4602:

Line 4631: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name

4627: -- Standard start of API savepoint
4628: SAVEPOINT drag_n_drop;
4629:
4630: -- Standard call to check for call compatibility
4631: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name
4632: , 'csf_gantt_data_pkg') THEN
4633: RAISE fnd_api.g_exc_unexpected_error;
4634: END IF;
4635:

Line 4633: RAISE fnd_api.g_exc_unexpected_error;

4629:
4630: -- Standard call to check for call compatibility
4631: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name
4632: , 'csf_gantt_data_pkg') THEN
4633: RAISE fnd_api.g_exc_unexpected_error;
4634: END IF;
4635:
4636: -- Initialize message list if p_init_msg_list is set to TRUE
4637: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 4637: IF fnd_api.to_boolean(p_init_msg_list) THEN

4633: RAISE fnd_api.g_exc_unexpected_error;
4634: END IF;
4635:
4636: -- Initialize message list if p_init_msg_list is set to TRUE
4637: IF fnd_api.to_boolean(p_init_msg_list) THEN
4638: fnd_msg_pub.initialize;
4639: END IF;
4640:
4641: -- Initialize API return status to success

Line 4642: x_return_status := fnd_api.g_ret_sts_success;

4638: fnd_msg_pub.initialize;
4639: END IF;
4640:
4641: -- Initialize API return status to success
4642: x_return_status := fnd_api.g_ret_sts_success;
4643: IF p_task_changed OR p_assignment_changed THEN
4644: OPEN c_task(p_task_id);
4645:
4646: FETCH c_task

Line 4690: l_sched_travel_duration := fnd_api.g_miss_num;

4686: l_sched_travel_duration := p_sched_travel_duration;
4687: l_sched_travel_duration_uom := p_sched_travel_duration_uom;
4688: ELSIF
4689: p_sched_travel_duration_uom IS NULL then
4690: l_sched_travel_duration := fnd_api.g_miss_num;
4691: END IF;
4692:
4693: /*test('Updating Task ');
4694: test('Updating Task p_task_id :'||p_task_id);

Line 4707: , p_init_msg_list => fnd_api.g_true

4703: */
4704:
4705: csf_tasks_pub.update_task(
4706: p_api_version => 1.0
4707: , p_init_msg_list => fnd_api.g_true
4708: , p_commit => fnd_api.g_false
4709: , p_task_id => p_task_id
4710: , p_object_version_number => l_old_task_obj_ver_number
4711: , p_planned_start_date => nvl(p_planned_start_date,fnd_api.g_miss_date)

Line 4708: , p_commit => fnd_api.g_false

4704:
4705: csf_tasks_pub.update_task(
4706: p_api_version => 1.0
4707: , p_init_msg_list => fnd_api.g_true
4708: , p_commit => fnd_api.g_false
4709: , p_task_id => p_task_id
4710: , p_object_version_number => l_old_task_obj_ver_number
4711: , p_planned_start_date => nvl(p_planned_start_date,fnd_api.g_miss_date)
4712: , p_planned_end_date => nvl(p_planned_end_date,fnd_api.g_miss_date)

Line 4711: , p_planned_start_date => nvl(p_planned_start_date,fnd_api.g_miss_date)

4707: , p_init_msg_list => fnd_api.g_true
4708: , p_commit => fnd_api.g_false
4709: , p_task_id => p_task_id
4710: , p_object_version_number => l_old_task_obj_ver_number
4711: , p_planned_start_date => nvl(p_planned_start_date,fnd_api.g_miss_date)
4712: , p_planned_end_date => nvl(p_planned_end_date,fnd_api.g_miss_date)
4713: , p_scheduled_start_date => p_new_sched_start_date
4714: , p_scheduled_end_date => p_new_sched_end_date
4715: , p_actual_start_date => fnd_api.g_miss_date

Line 4712: , p_planned_end_date => nvl(p_planned_end_date,fnd_api.g_miss_date)

4708: , p_commit => fnd_api.g_false
4709: , p_task_id => p_task_id
4710: , p_object_version_number => l_old_task_obj_ver_number
4711: , p_planned_start_date => nvl(p_planned_start_date,fnd_api.g_miss_date)
4712: , p_planned_end_date => nvl(p_planned_end_date,fnd_api.g_miss_date)
4713: , p_scheduled_start_date => p_new_sched_start_date
4714: , p_scheduled_end_date => p_new_sched_end_date
4715: , p_actual_start_date => fnd_api.g_miss_date
4716: , p_actual_end_date => fnd_api.g_miss_date

Line 4715: , p_actual_start_date => fnd_api.g_miss_date

4711: , p_planned_start_date => nvl(p_planned_start_date,fnd_api.g_miss_date)
4712: , p_planned_end_date => nvl(p_planned_end_date,fnd_api.g_miss_date)
4713: , p_scheduled_start_date => p_new_sched_start_date
4714: , p_scheduled_end_date => p_new_sched_end_date
4715: , p_actual_start_date => fnd_api.g_miss_date
4716: , p_actual_end_date => fnd_api.g_miss_date
4717: , p_planned_effort => l_planned_effort
4718: , p_planned_effort_uom => l_planned_effort_uom
4719: , p_task_status_id => l_task_status_id

Line 4716: , p_actual_end_date => fnd_api.g_miss_date

4712: , p_planned_end_date => nvl(p_planned_end_date,fnd_api.g_miss_date)
4713: , p_scheduled_start_date => p_new_sched_start_date
4714: , p_scheduled_end_date => p_new_sched_end_date
4715: , p_actual_start_date => fnd_api.g_miss_date
4716: , p_actual_end_date => fnd_api.g_miss_date
4717: , p_planned_effort => l_planned_effort
4718: , p_planned_effort_uom => l_planned_effort_uom
4719: , p_task_status_id => l_task_status_id
4720: , x_return_status => x_return_status

Line 4725: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4721: , x_msg_count => x_msg_count
4722: , x_msg_data => x_msg_data
4723: );
4724:
4725: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4726: RAISE fnd_api.g_exc_error;
4727: END IF;
4728:
4729: END IF;

Line 4726: RAISE fnd_api.g_exc_error;

4722: , x_msg_data => x_msg_data
4723: );
4724:
4725: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4726: RAISE fnd_api.g_exc_error;
4727: END IF;
4728:
4729: END IF;
4730:

Line 4750: , p_init_msg_list => fnd_api.g_true

4746:
4747:
4748: csf_task_assignments_pub.create_task_assignment(
4749: p_api_version => 1.0
4750: , p_init_msg_list => fnd_api.g_true
4751: , p_commit => fnd_api.g_false
4752: , p_task_id => p_task_id
4753: , p_resource_type_code => p_new_resource_type_code
4754: , p_resource_id => p_new_resource_id

Line 4751: , p_commit => fnd_api.g_false

4747:
4748: csf_task_assignments_pub.create_task_assignment(
4749: p_api_version => 1.0
4750: , p_init_msg_list => fnd_api.g_true
4751: , p_commit => fnd_api.g_false
4752: , p_task_id => p_task_id
4753: , p_resource_type_code => p_new_resource_type_code
4754: , p_resource_id => p_new_resource_id
4755: , p_assignment_status_id => p_assignment_status_id

Line 4772: IF NVL(x_return_status, 'S') = fnd_api.g_ret_sts_success THEN

4768: );
4769:
4770:
4771:
4772: IF NVL(x_return_status, 'S') = fnd_api.g_ret_sts_success THEN
4773: /*test('After Creating Assignment ..');
4774: test('Assignment Changed x_task_assignment_id :'||x_task_assignment_id);
4775: test('Assignment Changed p_object_version_number :'||p_object_version_number);
4776: test('Assignment Changed x_task_object_version_number :'||x_task_object_version_number);

Line 4799: , p_init_msg_list => fnd_api.g_true

4795: END IF;
4796: CLOSE c_assign_obj_ver;
4797: csf_task_assignments_pub.update_task_assignment(
4798: p_api_version => 1.0
4799: , p_init_msg_list => fnd_api.g_true
4800: , p_commit => fnd_api.g_false
4801: , p_task_assignment_id => p_task_assignment_id
4802: , p_object_version_number => l_old_ta_obj_version
4803: , p_task_id => p_task_id

Line 4800: , p_commit => fnd_api.g_false

4796: CLOSE c_assign_obj_ver;
4797: csf_task_assignments_pub.update_task_assignment(
4798: p_api_version => 1.0
4799: , p_init_msg_list => fnd_api.g_true
4800: , p_commit => fnd_api.g_false
4801: , p_task_assignment_id => p_task_assignment_id
4802: , p_object_version_number => l_old_ta_obj_version
4803: , p_task_id => p_task_id
4804: , p_resource_type_code => p_old_resource_type_code

Line 4806: , p_resource_territory_id => fnd_api.g_miss_num

4802: , p_object_version_number => l_old_ta_obj_version
4803: , p_task_id => p_task_id
4804: , p_resource_type_code => p_old_resource_type_code
4805: , p_resource_id => p_old_resource_id
4806: , p_resource_territory_id => fnd_api.g_miss_num
4807: , p_assignment_status_id => p_cancel_status_id
4808: , p_actual_start_date => fnd_api.g_miss_date
4809: , p_actual_end_date => fnd_api.g_miss_date
4810: , p_sched_travel_distance => fnd_api.g_miss_num

Line 4808: , p_actual_start_date => fnd_api.g_miss_date

4804: , p_resource_type_code => p_old_resource_type_code
4805: , p_resource_id => p_old_resource_id
4806: , p_resource_territory_id => fnd_api.g_miss_num
4807: , p_assignment_status_id => p_cancel_status_id
4808: , p_actual_start_date => fnd_api.g_miss_date
4809: , p_actual_end_date => fnd_api.g_miss_date
4810: , p_sched_travel_distance => fnd_api.g_miss_num
4811: , p_sched_travel_duration => fnd_api.g_miss_num
4812: , p_sched_travel_duration_uom => fnd_api.g_miss_char

Line 4809: , p_actual_end_date => fnd_api.g_miss_date

4805: , p_resource_id => p_old_resource_id
4806: , p_resource_territory_id => fnd_api.g_miss_num
4807: , p_assignment_status_id => p_cancel_status_id
4808: , p_actual_start_date => fnd_api.g_miss_date
4809: , p_actual_end_date => fnd_api.g_miss_date
4810: , p_sched_travel_distance => fnd_api.g_miss_num
4811: , p_sched_travel_duration => fnd_api.g_miss_num
4812: , p_sched_travel_duration_uom => fnd_api.g_miss_char
4813: , p_shift_construct_id => p_old_shift_construct_id

Line 4810: , p_sched_travel_distance => fnd_api.g_miss_num

4806: , p_resource_territory_id => fnd_api.g_miss_num
4807: , p_assignment_status_id => p_cancel_status_id
4808: , p_actual_start_date => fnd_api.g_miss_date
4809: , p_actual_end_date => fnd_api.g_miss_date
4810: , p_sched_travel_distance => fnd_api.g_miss_num
4811: , p_sched_travel_duration => fnd_api.g_miss_num
4812: , p_sched_travel_duration_uom => fnd_api.g_miss_char
4813: , p_shift_construct_id => p_old_shift_construct_id
4814: , p_object_capacity_id => p_old_object_capacity_id

Line 4811: , p_sched_travel_duration => fnd_api.g_miss_num

4807: , p_assignment_status_id => p_cancel_status_id
4808: , p_actual_start_date => fnd_api.g_miss_date
4809: , p_actual_end_date => fnd_api.g_miss_date
4810: , p_sched_travel_distance => fnd_api.g_miss_num
4811: , p_sched_travel_duration => fnd_api.g_miss_num
4812: , p_sched_travel_duration_uom => fnd_api.g_miss_char
4813: , p_shift_construct_id => p_old_shift_construct_id
4814: , p_object_capacity_id => p_old_object_capacity_id
4815: , x_return_status => x_return_status

Line 4812: , p_sched_travel_duration_uom => fnd_api.g_miss_char

4808: , p_actual_start_date => fnd_api.g_miss_date
4809: , p_actual_end_date => fnd_api.g_miss_date
4810: , p_sched_travel_distance => fnd_api.g_miss_num
4811: , p_sched_travel_duration => fnd_api.g_miss_num
4812: , p_sched_travel_duration_uom => fnd_api.g_miss_char
4813: , p_shift_construct_id => p_old_shift_construct_id
4814: , p_object_capacity_id => p_old_object_capacity_id
4815: , x_return_status => x_return_status
4816: , x_msg_count => x_msg_count

Line 4821: IF NVL(x_return_status, 'S') <> fnd_api.g_ret_sts_success THEN

4817: , x_msg_data => x_msg_data
4818: , x_task_object_version_number => x_task_object_version_number
4819: , x_task_status_id => x_task_status_id
4820: );
4821: IF NVL(x_return_status, 'S') <> fnd_api.g_ret_sts_success THEN
4822: RAISE fnd_api.g_exc_error;
4823: END IF;
4824: ELSE
4825: /*test('Now After Updating Assignment ..');

Line 4822: RAISE fnd_api.g_exc_error;

4818: , x_task_object_version_number => x_task_object_version_number
4819: , x_task_status_id => x_task_status_id
4820: );
4821: IF NVL(x_return_status, 'S') <> fnd_api.g_ret_sts_success THEN
4822: RAISE fnd_api.g_exc_error;
4823: END IF;
4824: ELSE
4825: /*test('Now After Updating Assignment ..');
4826: test('Now After Updating Assignment x_task_object_version_number :'||x_task_object_version_number);

Line 4831: RAISE fnd_api.g_exc_error;

4827: test('Now After Updating Assignment x_task_status_id :'||x_task_status_id);
4828: test('Now After Updating Assignment x_return_status :'||x_return_status);
4829: test('Now After Updating Assignment x_msg_data :'||x_msg_data);
4830: */
4831: RAISE fnd_api.g_exc_error;
4832: END IF;
4833: ELSIF p_shift_changed THEN
4834: OPEN c_assign_obj_ver;
4835: FETCH c_assign_obj_ver

Line 4844: , p_init_msg_list => fnd_api.g_true

4840: END IF;
4841: CLOSE c_assign_obj_ver;
4842: csf_task_assignments_pub.update_task_assignment(
4843: p_api_version => 1.0
4844: , p_init_msg_list => fnd_api.g_true
4845: , p_commit => fnd_api.g_false
4846: , p_task_assignment_id => p_task_assignment_id
4847: , p_object_version_number => l_old_ta_obj_version
4848: , p_task_id => p_task_id

Line 4845: , p_commit => fnd_api.g_false

4841: CLOSE c_assign_obj_ver;
4842: csf_task_assignments_pub.update_task_assignment(
4843: p_api_version => 1.0
4844: , p_init_msg_list => fnd_api.g_true
4845: , p_commit => fnd_api.g_false
4846: , p_task_assignment_id => p_task_assignment_id
4847: , p_object_version_number => l_old_ta_obj_version
4848: , p_task_id => p_task_id
4849: , p_resource_type_code => p_old_resource_type_code

Line 4851: , p_resource_territory_id => fnd_api.g_miss_num

4847: , p_object_version_number => l_old_ta_obj_version
4848: , p_task_id => p_task_id
4849: , p_resource_type_code => p_old_resource_type_code
4850: , p_resource_id => p_old_resource_id
4851: , p_resource_territory_id => fnd_api.g_miss_num
4852: , p_assignment_status_id => p_assignment_status_id
4853: , p_actual_start_date => fnd_api.g_miss_date
4854: , p_actual_end_date => fnd_api.g_miss_date
4855: , p_sched_travel_distance => p_sched_travel_distance

Line 4853: , p_actual_start_date => fnd_api.g_miss_date

4849: , p_resource_type_code => p_old_resource_type_code
4850: , p_resource_id => p_old_resource_id
4851: , p_resource_territory_id => fnd_api.g_miss_num
4852: , p_assignment_status_id => p_assignment_status_id
4853: , p_actual_start_date => fnd_api.g_miss_date
4854: , p_actual_end_date => fnd_api.g_miss_date
4855: , p_sched_travel_distance => p_sched_travel_distance
4856: , p_sched_travel_duration => l_sched_travel_duration
4857: , p_sched_travel_duration_uom => p_sched_travel_duration_uom

Line 4854: , p_actual_end_date => fnd_api.g_miss_date

4850: , p_resource_id => p_old_resource_id
4851: , p_resource_territory_id => fnd_api.g_miss_num
4852: , p_assignment_status_id => p_assignment_status_id
4853: , p_actual_start_date => fnd_api.g_miss_date
4854: , p_actual_end_date => fnd_api.g_miss_date
4855: , p_sched_travel_distance => p_sched_travel_distance
4856: , p_sched_travel_duration => l_sched_travel_duration
4857: , p_sched_travel_duration_uom => p_sched_travel_duration_uom
4858: , p_shift_construct_id => p_new_shift_construct_id

Line 4866: IF NVL(x_return_status, 'S') <> fnd_api.g_ret_sts_success THEN

4862: , x_msg_data => x_msg_data
4863: , x_task_object_version_number => x_task_object_version_number
4864: , x_task_status_id => x_task_status_id
4865: );
4866: IF NVL(x_return_status, 'S') <> fnd_api.g_ret_sts_success THEN
4867: RAISE fnd_api.g_exc_error;
4868: END IF;
4869: ELSIF p_task_changed and l_parent_task_id IS NOT NULL
4870: THEN

Line 4867: RAISE fnd_api.g_exc_error;

4863: , x_task_object_version_number => x_task_object_version_number
4864: , x_task_status_id => x_task_status_id
4865: );
4866: IF NVL(x_return_status, 'S') <> fnd_api.g_ret_sts_success THEN
4867: RAISE fnd_api.g_exc_error;
4868: END IF;
4869: ELSIF p_task_changed and l_parent_task_id IS NOT NULL
4870: THEN
4871: OPEN c_parent_ovn(l_parent_task_id);

Line 4878: , p_init_msg_list => fnd_api.g_true

4874:
4875: -- Sync up the Parent and all the other Siblings
4876: csf_tasks_pub.update_task_longer_than_shift(
4877: p_api_version => 1.0
4878: , p_init_msg_list => fnd_api.g_true
4879: , p_commit => fnd_api.g_false
4880: , x_return_status => x_return_status
4881: , x_msg_count => x_msg_count
4882: , x_msg_data => x_msg_data

Line 4879: , p_commit => fnd_api.g_false

4875: -- Sync up the Parent and all the other Siblings
4876: csf_tasks_pub.update_task_longer_than_shift(
4877: p_api_version => 1.0
4878: , p_init_msg_list => fnd_api.g_true
4879: , p_commit => fnd_api.g_false
4880: , x_return_status => x_return_status
4881: , x_msg_count => x_msg_count
4882: , x_msg_data => x_msg_data
4883: , p_task_id => l_parent_task_id

Line 4887: IF NVL(x_return_status, 'S') <> fnd_api.g_ret_sts_success THEN

4883: , p_task_id => l_parent_task_id
4884: , p_object_version_number => l_obj_ver_number
4885: , p_action => csf_tasks_pub.g_action_normal_to_parent
4886: );
4887: IF NVL(x_return_status, 'S') <> fnd_api.g_ret_sts_success THEN
4888: RAISE fnd_api.g_exc_error;
4889: END IF;
4890: END IF;
4891:

Line 4888: RAISE fnd_api.g_exc_error;

4884: , p_object_version_number => l_obj_ver_number
4885: , p_action => csf_tasks_pub.g_action_normal_to_parent
4886: );
4887: IF NVL(x_return_status, 'S') <> fnd_api.g_ret_sts_success THEN
4888: RAISE fnd_api.g_exc_error;
4889: END IF;
4890: END IF;
4891:
4892: -- Standard check of p_commit

Line 4893: IF fnd_api.to_boolean(p_commit) THEN

4889: END IF;
4890: END IF;
4891:
4892: -- Standard check of p_commit
4893: IF fnd_api.to_boolean(p_commit) THEN
4894: COMMIT WORK;
4895: END IF;
4896:
4897: -- Standard call to get message count and if count is 1, get message info

Line 4900: WHEN fnd_api.g_exc_error THEN

4896:
4897: -- Standard call to get message count and if count is 1, get message info
4898: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4899: EXCEPTION
4900: WHEN fnd_api.g_exc_error THEN
4901: ROLLBACK TO drag_n_drop;
4902: x_return_status := fnd_api.g_ret_sts_error;
4903: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4904: WHEN fnd_api.g_exc_unexpected_error THEN

Line 4902: x_return_status := fnd_api.g_ret_sts_error;

4898: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4899: EXCEPTION
4900: WHEN fnd_api.g_exc_error THEN
4901: ROLLBACK TO drag_n_drop;
4902: x_return_status := fnd_api.g_ret_sts_error;
4903: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4904: WHEN fnd_api.g_exc_unexpected_error THEN
4905: ROLLBACK TO drag_n_drop;
4906: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4904: WHEN fnd_api.g_exc_unexpected_error THEN

4900: WHEN fnd_api.g_exc_error THEN
4901: ROLLBACK TO drag_n_drop;
4902: x_return_status := fnd_api.g_ret_sts_error;
4903: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4904: WHEN fnd_api.g_exc_unexpected_error THEN
4905: ROLLBACK TO drag_n_drop;
4906: x_return_status := fnd_api.g_ret_sts_unexp_error;
4907: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4908: WHEN OTHERS THEN

Line 4906: x_return_status := fnd_api.g_ret_sts_unexp_error;

4902: x_return_status := fnd_api.g_ret_sts_error;
4903: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4904: WHEN fnd_api.g_exc_unexpected_error THEN
4905: ROLLBACK TO drag_n_drop;
4906: x_return_status := fnd_api.g_ret_sts_unexp_error;
4907: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4908: WHEN OTHERS THEN
4909: ROLLBACK TO drag_n_drop;
4910: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4910: x_return_status := fnd_api.g_ret_sts_unexp_error;

4906: x_return_status := fnd_api.g_ret_sts_unexp_error;
4907: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4908: WHEN OTHERS THEN
4909: ROLLBACK TO drag_n_drop;
4910: x_return_status := fnd_api.g_ret_sts_unexp_error;
4911:
4912: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4913: fnd_msg_pub.add_exc_msg('csf_gantt_data_pkg', l_api_name);
4914: END IF;

Line 8657: x_return_status := fnd_api.g_ret_sts_success;

8653:
8654: IF trip_id.COUNT IS NULL THEN
8655: l_return_status := 'E';
8656: ELSE
8657: x_return_status := fnd_api.g_ret_sts_success;
8658: END IF;
8659: END get_schedule_advise_options;
8660:
8661: