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 1608: x_return_status := fnd_api.g_ret_sts_success;

1604:
1605: IF task_id.COUNT IS NULL THEN
1606: l_return_status := 'E';
1607: ELSE
1608: x_return_status := fnd_api.g_ret_sts_success;
1609: END IF;
1610:
1611: IF NOT l_return_status = fnd_api.g_ret_sts_success THEN
1612: -- just return unexpected error, no message, does

Line 1611: IF NOT l_return_status = fnd_api.g_ret_sts_success THEN

1607: ELSE
1608: x_return_status := fnd_api.g_ret_sts_success;
1609: END IF;
1610:
1611: IF NOT l_return_status = fnd_api.g_ret_sts_success THEN
1612: -- just return unexpected error, no message, does
1613: -- not matter, SchedulerResource.java will just skip this resource
1614: -- without message, and only generate an error message
1615: -- when all resources have failed

Line 1616: x_return_status := fnd_api.g_ret_sts_unexp_error;

1612: -- just return unexpected error, no message, does
1613: -- not matter, SchedulerResource.java will just skip this resource
1614: -- without message, and only generate an error message
1615: -- when all resources have failed
1616: x_return_status := fnd_api.g_ret_sts_unexp_error;
1617: RAISE fnd_api.g_exc_unexpected_error;
1618: END IF;
1619:
1620: --standard call to get message count and the message information

Line 1617: RAISE fnd_api.g_exc_unexpected_error;

1613: -- not matter, SchedulerResource.java will just skip this resource
1614: -- without message, and only generate an error message
1615: -- when all resources have failed
1616: x_return_status := fnd_api.g_ret_sts_unexp_error;
1617: RAISE fnd_api.g_exc_unexpected_error;
1618: END IF;
1619:
1620: --standard call to get message count and the message information
1621: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1624: WHEN fnd_api.g_exc_error THEN

1620: --standard call to get message count and the message information
1621: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1622: --
1623: EXCEPTION
1624: WHEN fnd_api.g_exc_error THEN
1625: x_return_status := fnd_api.g_ret_sts_error;
1626: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1627: WHEN fnd_api.g_exc_unexpected_error THEN
1628: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1625: x_return_status := fnd_api.g_ret_sts_error;

1621: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1622: --
1623: EXCEPTION
1624: WHEN fnd_api.g_exc_error THEN
1625: x_return_status := fnd_api.g_ret_sts_error;
1626: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1627: WHEN fnd_api.g_exc_unexpected_error THEN
1628: x_return_status := fnd_api.g_ret_sts_unexp_error;
1629: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1627: WHEN fnd_api.g_exc_unexpected_error THEN

1623: EXCEPTION
1624: WHEN fnd_api.g_exc_error THEN
1625: x_return_status := fnd_api.g_ret_sts_error;
1626: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1627: WHEN fnd_api.g_exc_unexpected_error THEN
1628: x_return_status := fnd_api.g_ret_sts_unexp_error;
1629: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1630: WHEN OTHERS THEN
1631: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1628: x_return_status := fnd_api.g_ret_sts_unexp_error;

1624: WHEN fnd_api.g_exc_error THEN
1625: x_return_status := fnd_api.g_ret_sts_error;
1626: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1627: WHEN fnd_api.g_exc_unexpected_error THEN
1628: x_return_status := fnd_api.g_ret_sts_unexp_error;
1629: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1630: WHEN OTHERS THEN
1631: x_return_status := fnd_api.g_ret_sts_unexp_error;
1632:

Line 1631: x_return_status := fnd_api.g_ret_sts_unexp_error;

1627: WHEN fnd_api.g_exc_unexpected_error THEN
1628: x_return_status := fnd_api.g_ret_sts_unexp_error;
1629: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1630: WHEN OTHERS THEN
1631: x_return_status := fnd_api.g_ret_sts_unexp_error;
1632:
1633: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1634: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1635: END IF;

Line 2012: l_planned_effort NUMBER := fnd_api.g_miss_num;

2008: l_start_date DATE;
2009: l_end_date DATE;
2010: l_old_ta_obj_version NUMBER;
2011: l_obj_ver_number VARCHAR2(20);
2012: l_planned_effort NUMBER := fnd_api.g_miss_num;
2013: l_planned_effort_uom VARCHAR2(10) := fnd_api.g_miss_char;
2014: l_parent_task_id NUMBER;
2015:
2016: CURSOR c_task(p_task_id NUMBER) IS

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

2009: l_end_date DATE;
2010: l_old_ta_obj_version NUMBER;
2011: l_obj_ver_number VARCHAR2(20);
2012: l_planned_effort NUMBER := fnd_api.g_miss_num;
2013: l_planned_effort_uom VARCHAR2(10) := fnd_api.g_miss_char;
2014: l_parent_task_id NUMBER;
2015:
2016: CURSOR c_task(p_task_id NUMBER) IS
2017: SELECT object_version_number

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

2039: -- Standard start of API savepoint
2040: SAVEPOINT drag_n_drop;
2041:
2042: -- Standard call to check for call compatibility
2043: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name
2044: , 'csf_gantt_data_pkg') THEN
2045: RAISE fnd_api.g_exc_unexpected_error;
2046: END IF;
2047:

Line 2045: RAISE fnd_api.g_exc_unexpected_error;

2041:
2042: -- Standard call to check for call compatibility
2043: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name
2044: , 'csf_gantt_data_pkg') THEN
2045: RAISE fnd_api.g_exc_unexpected_error;
2046: END IF;
2047:
2048: -- Initialize message list if p_init_msg_list is set to TRUE
2049: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 2049: IF fnd_api.to_boolean(p_init_msg_list) THEN

2045: RAISE fnd_api.g_exc_unexpected_error;
2046: END IF;
2047:
2048: -- Initialize message list if p_init_msg_list is set to TRUE
2049: IF fnd_api.to_boolean(p_init_msg_list) THEN
2050: fnd_msg_pub.initialize;
2051: END IF;
2052:
2053: -- Initialize API return status to success

Line 2054: x_return_status := fnd_api.g_ret_sts_success;

2050: fnd_msg_pub.initialize;
2051: END IF;
2052:
2053: -- Initialize API return status to success
2054: x_return_status := fnd_api.g_ret_sts_success;
2055: IF p_task_changed OR p_assignment_changed THEN
2056: OPEN c_task(p_task_id);
2057:
2058: FETCH c_task

Line 2097: , p_init_msg_list => fnd_api.g_true

2093: END IF;
2094:
2095: csf_tasks_pub.update_task(
2096: p_api_version => 1.0
2097: , p_init_msg_list => fnd_api.g_true
2098: , p_commit => fnd_api.g_false
2099: , p_task_id => p_task_id
2100: , p_object_version_number => l_old_task_obj_ver_number
2101: , p_planned_start_date => nvl(p_planned_start_date,fnd_api.g_miss_date)

Line 2098: , p_commit => fnd_api.g_false

2094:
2095: csf_tasks_pub.update_task(
2096: p_api_version => 1.0
2097: , p_init_msg_list => fnd_api.g_true
2098: , p_commit => fnd_api.g_false
2099: , p_task_id => p_task_id
2100: , p_object_version_number => l_old_task_obj_ver_number
2101: , p_planned_start_date => nvl(p_planned_start_date,fnd_api.g_miss_date)
2102: , p_planned_end_date => nvl(p_planned_end_date,fnd_api.g_miss_date)

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

2097: , p_init_msg_list => fnd_api.g_true
2098: , p_commit => fnd_api.g_false
2099: , p_task_id => p_task_id
2100: , p_object_version_number => l_old_task_obj_ver_number
2101: , p_planned_start_date => nvl(p_planned_start_date,fnd_api.g_miss_date)
2102: , p_planned_end_date => nvl(p_planned_end_date,fnd_api.g_miss_date)
2103: , p_scheduled_start_date => p_new_sched_start_date
2104: , p_scheduled_end_date => p_new_sched_end_date
2105: , p_actual_start_date => fnd_api.g_miss_date

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

2098: , p_commit => fnd_api.g_false
2099: , p_task_id => p_task_id
2100: , p_object_version_number => l_old_task_obj_ver_number
2101: , p_planned_start_date => nvl(p_planned_start_date,fnd_api.g_miss_date)
2102: , p_planned_end_date => nvl(p_planned_end_date,fnd_api.g_miss_date)
2103: , p_scheduled_start_date => p_new_sched_start_date
2104: , p_scheduled_end_date => p_new_sched_end_date
2105: , p_actual_start_date => fnd_api.g_miss_date
2106: , p_actual_end_date => fnd_api.g_miss_date

Line 2105: , p_actual_start_date => fnd_api.g_miss_date

2101: , p_planned_start_date => nvl(p_planned_start_date,fnd_api.g_miss_date)
2102: , p_planned_end_date => nvl(p_planned_end_date,fnd_api.g_miss_date)
2103: , p_scheduled_start_date => p_new_sched_start_date
2104: , p_scheduled_end_date => p_new_sched_end_date
2105: , p_actual_start_date => fnd_api.g_miss_date
2106: , p_actual_end_date => fnd_api.g_miss_date
2107: , p_planned_effort => l_planned_effort
2108: , p_planned_effort_uom => l_planned_effort_uom
2109: , p_task_status_id => l_task_status_id

Line 2106: , p_actual_end_date => fnd_api.g_miss_date

2102: , p_planned_end_date => nvl(p_planned_end_date,fnd_api.g_miss_date)
2103: , p_scheduled_start_date => p_new_sched_start_date
2104: , p_scheduled_end_date => p_new_sched_end_date
2105: , p_actual_start_date => fnd_api.g_miss_date
2106: , p_actual_end_date => fnd_api.g_miss_date
2107: , p_planned_effort => l_planned_effort
2108: , p_planned_effort_uom => l_planned_effort_uom
2109: , p_task_status_id => l_task_status_id
2110: , x_return_status => x_return_status

Line 2115: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2111: , x_msg_count => x_msg_count
2112: , x_msg_data => x_msg_data
2113: );
2114:
2115: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2116: RAISE fnd_api.g_exc_error;
2117: END IF;
2118:
2119: END IF;

Line 2116: RAISE fnd_api.g_exc_error;

2112: , x_msg_data => x_msg_data
2113: );
2114:
2115: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2116: RAISE fnd_api.g_exc_error;
2117: END IF;
2118:
2119: END IF;
2120:

Line 2126: , p_init_msg_list => fnd_api.g_true

2122: OR l_start_date IS NOT NULL
2123: THEN
2124: csf_task_assignments_pub.create_task_assignment(
2125: p_api_version => 1.0
2126: , p_init_msg_list => fnd_api.g_true
2127: , p_commit => fnd_api.g_false
2128: , p_task_id => p_task_id
2129: , p_resource_type_code => p_new_resource_type_code
2130: , p_resource_id => p_new_resource_id

Line 2127: , p_commit => fnd_api.g_false

2123: THEN
2124: csf_task_assignments_pub.create_task_assignment(
2125: p_api_version => 1.0
2126: , p_init_msg_list => fnd_api.g_true
2127: , p_commit => fnd_api.g_false
2128: , p_task_id => p_task_id
2129: , p_resource_type_code => p_new_resource_type_code
2130: , p_resource_id => p_new_resource_id
2131: , p_assignment_status_id => p_assignment_status_id

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

2142: , x_task_object_version_number => x_task_object_version_number
2143: , x_task_status_id => x_task_status_id
2144: );
2145:
2146: IF NVL(x_return_status, 'S') = fnd_api.g_ret_sts_success THEN
2147: csf_task_assignments_pub.update_task_assignment(
2148: p_api_version => 1.0
2149: , p_init_msg_list => fnd_api.g_true
2150: , p_commit => fnd_api.g_false

Line 2149: , p_init_msg_list => fnd_api.g_true

2145:
2146: IF NVL(x_return_status, 'S') = fnd_api.g_ret_sts_success THEN
2147: csf_task_assignments_pub.update_task_assignment(
2148: p_api_version => 1.0
2149: , p_init_msg_list => fnd_api.g_true
2150: , p_commit => fnd_api.g_false
2151: , p_task_assignment_id => p_task_assignment_id
2152: , p_object_version_number => l_old_ta_obj_version
2153: , p_task_id => p_task_id

Line 2150: , p_commit => fnd_api.g_false

2146: IF NVL(x_return_status, 'S') = fnd_api.g_ret_sts_success THEN
2147: csf_task_assignments_pub.update_task_assignment(
2148: p_api_version => 1.0
2149: , p_init_msg_list => fnd_api.g_true
2150: , p_commit => fnd_api.g_false
2151: , p_task_assignment_id => p_task_assignment_id
2152: , p_object_version_number => l_old_ta_obj_version
2153: , p_task_id => p_task_id
2154: , p_resource_type_code => p_old_resource_type_code

Line 2156: , p_resource_territory_id => fnd_api.g_miss_num

2152: , p_object_version_number => l_old_ta_obj_version
2153: , p_task_id => p_task_id
2154: , p_resource_type_code => p_old_resource_type_code
2155: , p_resource_id => p_old_resource_id
2156: , p_resource_territory_id => fnd_api.g_miss_num
2157: , p_assignment_status_id => p_cancel_status_id
2158: , p_actual_start_date => fnd_api.g_miss_date
2159: , p_actual_end_date => fnd_api.g_miss_date
2160: , p_sched_travel_distance => fnd_api.g_miss_num

Line 2158: , p_actual_start_date => fnd_api.g_miss_date

2154: , p_resource_type_code => p_old_resource_type_code
2155: , p_resource_id => p_old_resource_id
2156: , p_resource_territory_id => fnd_api.g_miss_num
2157: , p_assignment_status_id => p_cancel_status_id
2158: , p_actual_start_date => fnd_api.g_miss_date
2159: , p_actual_end_date => fnd_api.g_miss_date
2160: , p_sched_travel_distance => fnd_api.g_miss_num
2161: , p_sched_travel_duration => fnd_api.g_miss_num
2162: , p_sched_travel_duration_uom => fnd_api.g_miss_char

Line 2159: , p_actual_end_date => fnd_api.g_miss_date

2155: , p_resource_id => p_old_resource_id
2156: , p_resource_territory_id => fnd_api.g_miss_num
2157: , p_assignment_status_id => p_cancel_status_id
2158: , p_actual_start_date => fnd_api.g_miss_date
2159: , p_actual_end_date => fnd_api.g_miss_date
2160: , p_sched_travel_distance => fnd_api.g_miss_num
2161: , p_sched_travel_duration => fnd_api.g_miss_num
2162: , p_sched_travel_duration_uom => fnd_api.g_miss_char
2163: , p_shift_construct_id => p_old_shift_construct_id

Line 2160: , p_sched_travel_distance => fnd_api.g_miss_num

2156: , p_resource_territory_id => fnd_api.g_miss_num
2157: , p_assignment_status_id => p_cancel_status_id
2158: , p_actual_start_date => fnd_api.g_miss_date
2159: , p_actual_end_date => fnd_api.g_miss_date
2160: , p_sched_travel_distance => fnd_api.g_miss_num
2161: , p_sched_travel_duration => fnd_api.g_miss_num
2162: , p_sched_travel_duration_uom => fnd_api.g_miss_char
2163: , p_shift_construct_id => p_old_shift_construct_id
2164: , p_object_capacity_id => p_old_object_capacity_id

Line 2161: , p_sched_travel_duration => fnd_api.g_miss_num

2157: , p_assignment_status_id => p_cancel_status_id
2158: , p_actual_start_date => fnd_api.g_miss_date
2159: , p_actual_end_date => fnd_api.g_miss_date
2160: , p_sched_travel_distance => fnd_api.g_miss_num
2161: , p_sched_travel_duration => fnd_api.g_miss_num
2162: , p_sched_travel_duration_uom => fnd_api.g_miss_char
2163: , p_shift_construct_id => p_old_shift_construct_id
2164: , p_object_capacity_id => p_old_object_capacity_id
2165: , x_return_status => x_return_status

Line 2162: , p_sched_travel_duration_uom => fnd_api.g_miss_char

2158: , p_actual_start_date => fnd_api.g_miss_date
2159: , p_actual_end_date => fnd_api.g_miss_date
2160: , p_sched_travel_distance => fnd_api.g_miss_num
2161: , p_sched_travel_duration => fnd_api.g_miss_num
2162: , p_sched_travel_duration_uom => fnd_api.g_miss_char
2163: , p_shift_construct_id => p_old_shift_construct_id
2164: , p_object_capacity_id => p_old_object_capacity_id
2165: , x_return_status => x_return_status
2166: , x_msg_count => x_msg_count

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

2167: , x_msg_data => x_msg_data
2168: , x_task_object_version_number => x_task_object_version_number
2169: , x_task_status_id => x_task_status_id
2170: );
2171: IF NVL(x_return_status, 'S') <> fnd_api.g_ret_sts_success THEN
2172: RAISE fnd_api.g_exc_error;
2173: END IF;
2174: ELSE
2175: RAISE fnd_api.g_exc_error;

Line 2172: RAISE fnd_api.g_exc_error;

2168: , x_task_object_version_number => x_task_object_version_number
2169: , x_task_status_id => x_task_status_id
2170: );
2171: IF NVL(x_return_status, 'S') <> fnd_api.g_ret_sts_success THEN
2172: RAISE fnd_api.g_exc_error;
2173: END IF;
2174: ELSE
2175: RAISE fnd_api.g_exc_error;
2176: END IF;

Line 2175: RAISE fnd_api.g_exc_error;

2171: IF NVL(x_return_status, 'S') <> fnd_api.g_ret_sts_success THEN
2172: RAISE fnd_api.g_exc_error;
2173: END IF;
2174: ELSE
2175: RAISE fnd_api.g_exc_error;
2176: END IF;
2177: ELSIF p_shift_changed THEN
2178: csf_task_assignments_pub.update_task_assignment(
2179: p_api_version => 1.0

Line 2180: , p_init_msg_list => fnd_api.g_true

2176: END IF;
2177: ELSIF p_shift_changed THEN
2178: csf_task_assignments_pub.update_task_assignment(
2179: p_api_version => 1.0
2180: , p_init_msg_list => fnd_api.g_true
2181: , p_commit => fnd_api.g_false
2182: , p_task_assignment_id => p_task_assignment_id
2183: , p_object_version_number => l_old_ta_obj_version
2184: , p_task_id => p_task_id

Line 2181: , p_commit => fnd_api.g_false

2177: ELSIF p_shift_changed THEN
2178: csf_task_assignments_pub.update_task_assignment(
2179: p_api_version => 1.0
2180: , p_init_msg_list => fnd_api.g_true
2181: , p_commit => fnd_api.g_false
2182: , p_task_assignment_id => p_task_assignment_id
2183: , p_object_version_number => l_old_ta_obj_version
2184: , p_task_id => p_task_id
2185: , p_resource_type_code => p_old_resource_type_code

Line 2187: , p_resource_territory_id => fnd_api.g_miss_num

2183: , p_object_version_number => l_old_ta_obj_version
2184: , p_task_id => p_task_id
2185: , p_resource_type_code => p_old_resource_type_code
2186: , p_resource_id => p_old_resource_id
2187: , p_resource_territory_id => fnd_api.g_miss_num
2188: , p_assignment_status_id => p_assignment_status_id
2189: , p_actual_start_date => fnd_api.g_miss_date
2190: , p_actual_end_date => fnd_api.g_miss_date
2191: , p_sched_travel_distance => p_sched_travel_distance

Line 2189: , p_actual_start_date => fnd_api.g_miss_date

2185: , p_resource_type_code => p_old_resource_type_code
2186: , p_resource_id => p_old_resource_id
2187: , p_resource_territory_id => fnd_api.g_miss_num
2188: , p_assignment_status_id => p_assignment_status_id
2189: , p_actual_start_date => fnd_api.g_miss_date
2190: , p_actual_end_date => fnd_api.g_miss_date
2191: , p_sched_travel_distance => p_sched_travel_distance
2192: , p_sched_travel_duration => p_sched_travel_duration
2193: , p_sched_travel_duration_uom => p_sched_travel_duration_uom

Line 2190: , p_actual_end_date => fnd_api.g_miss_date

2186: , p_resource_id => p_old_resource_id
2187: , p_resource_territory_id => fnd_api.g_miss_num
2188: , p_assignment_status_id => p_assignment_status_id
2189: , p_actual_start_date => fnd_api.g_miss_date
2190: , p_actual_end_date => fnd_api.g_miss_date
2191: , p_sched_travel_distance => p_sched_travel_distance
2192: , p_sched_travel_duration => p_sched_travel_duration
2193: , p_sched_travel_duration_uom => p_sched_travel_duration_uom
2194: , p_shift_construct_id => p_new_shift_construct_id

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

2198: , x_msg_data => x_msg_data
2199: , x_task_object_version_number => x_task_object_version_number
2200: , x_task_status_id => x_task_status_id
2201: );
2202: IF NVL(x_return_status, 'S') <> fnd_api.g_ret_sts_success THEN
2203: RAISE fnd_api.g_exc_error;
2204: END IF;
2205: ELSIF p_task_changed and l_parent_task_id IS NOT NULL
2206: THEN

Line 2203: RAISE fnd_api.g_exc_error;

2199: , x_task_object_version_number => x_task_object_version_number
2200: , x_task_status_id => x_task_status_id
2201: );
2202: IF NVL(x_return_status, 'S') <> fnd_api.g_ret_sts_success THEN
2203: RAISE fnd_api.g_exc_error;
2204: END IF;
2205: ELSIF p_task_changed and l_parent_task_id IS NOT NULL
2206: THEN
2207: OPEN c_parent_ovn(l_parent_task_id);

Line 2214: , p_init_msg_list => fnd_api.g_true

2210:
2211: -- Sync up the Parent and all the other Siblings
2212: csf_tasks_pub.update_task_longer_than_shift(
2213: p_api_version => 1.0
2214: , p_init_msg_list => fnd_api.g_true
2215: , p_commit => fnd_api.g_false
2216: , x_return_status => x_return_status
2217: , x_msg_count => x_msg_count
2218: , x_msg_data => x_msg_data

Line 2215: , p_commit => fnd_api.g_false

2211: -- Sync up the Parent and all the other Siblings
2212: csf_tasks_pub.update_task_longer_than_shift(
2213: p_api_version => 1.0
2214: , p_init_msg_list => fnd_api.g_true
2215: , p_commit => fnd_api.g_false
2216: , x_return_status => x_return_status
2217: , x_msg_count => x_msg_count
2218: , x_msg_data => x_msg_data
2219: , p_task_id => l_parent_task_id

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

2219: , p_task_id => l_parent_task_id
2220: , p_object_version_number => l_obj_ver_number
2221: , p_action => csf_tasks_pub.g_action_normal_to_parent
2222: );
2223: IF NVL(x_return_status, 'S') <> fnd_api.g_ret_sts_success THEN
2224: RAISE fnd_api.g_exc_error;
2225: END IF;
2226: END IF;
2227:

Line 2224: RAISE fnd_api.g_exc_error;

2220: , p_object_version_number => l_obj_ver_number
2221: , p_action => csf_tasks_pub.g_action_normal_to_parent
2222: );
2223: IF NVL(x_return_status, 'S') <> fnd_api.g_ret_sts_success THEN
2224: RAISE fnd_api.g_exc_error;
2225: END IF;
2226: END IF;
2227:
2228: -- Standard check of p_commit

Line 2229: IF fnd_api.to_boolean(p_commit) THEN

2225: END IF;
2226: END IF;
2227:
2228: -- Standard check of p_commit
2229: IF fnd_api.to_boolean(p_commit) THEN
2230: COMMIT WORK;
2231: END IF;
2232:
2233: -- Standard call to get message count and if count is 1, get message info

Line 2236: WHEN fnd_api.g_exc_error THEN

2232:
2233: -- Standard call to get message count and if count is 1, get message info
2234: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2235: EXCEPTION
2236: WHEN fnd_api.g_exc_error THEN
2237: ROLLBACK TO drag_n_drop;
2238: x_return_status := fnd_api.g_ret_sts_error;
2239: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2240: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2238: x_return_status := fnd_api.g_ret_sts_error;

2234: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2235: EXCEPTION
2236: WHEN fnd_api.g_exc_error THEN
2237: ROLLBACK TO drag_n_drop;
2238: x_return_status := fnd_api.g_ret_sts_error;
2239: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2240: WHEN fnd_api.g_exc_unexpected_error THEN
2241: ROLLBACK TO drag_n_drop;
2242: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2240: WHEN fnd_api.g_exc_unexpected_error THEN

2236: WHEN fnd_api.g_exc_error THEN
2237: ROLLBACK TO drag_n_drop;
2238: x_return_status := fnd_api.g_ret_sts_error;
2239: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2240: WHEN fnd_api.g_exc_unexpected_error THEN
2241: ROLLBACK TO drag_n_drop;
2242: x_return_status := fnd_api.g_ret_sts_unexp_error;
2243: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2244: WHEN OTHERS THEN

Line 2242: x_return_status := fnd_api.g_ret_sts_unexp_error;

2238: x_return_status := fnd_api.g_ret_sts_error;
2239: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2240: WHEN fnd_api.g_exc_unexpected_error THEN
2241: ROLLBACK TO drag_n_drop;
2242: x_return_status := fnd_api.g_ret_sts_unexp_error;
2243: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2244: WHEN OTHERS THEN
2245: ROLLBACK TO drag_n_drop;
2246: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2246: x_return_status := fnd_api.g_ret_sts_unexp_error;

2242: x_return_status := fnd_api.g_ret_sts_unexp_error;
2243: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2244: WHEN OTHERS THEN
2245: ROLLBACK TO drag_n_drop;
2246: x_return_status := fnd_api.g_ret_sts_unexp_error;
2247:
2248: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2249: fnd_msg_pub.add_exc_msg('csf_gantt_data_pkg', l_api_name);
2250: END IF;

Line 5392: x_return_status := fnd_api.g_ret_sts_success;

5388:
5389: IF trip_id.COUNT IS NULL THEN
5390: l_return_status := 'E';
5391: ELSE
5392: x_return_status := fnd_api.g_ret_sts_success;
5393: END IF;
5394: END get_schedule_advise_options;
5395: BEGIN
5396: -- package instantiation