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_TASK_ASSIGNMENTS_PUB dependencies on FND_API

Line 104: IF NVL(p_actual_start_date, fnd_api.g_miss_date) <> fnd_api.g_miss_date THEN

100:
101: BEGIN
102:
103: -- If Actuals are passed, then Trip has to be Queried based on the passed Actuals
104: IF NVL(p_actual_start_date, fnd_api.g_miss_date) <> fnd_api.g_miss_date THEN
105: l_new_start_date := p_actual_start_date;
106: l_new_end_date := p_actual_end_date;
107:
108: IF NVL(l_new_end_date, fnd_api.g_miss_date) = fnd_api.g_miss_date

Line 108: IF NVL(l_new_end_date, fnd_api.g_miss_date) = fnd_api.g_miss_date

104: IF NVL(p_actual_start_date, fnd_api.g_miss_date) <> fnd_api.g_miss_date THEN
105: l_new_start_date := p_actual_start_date;
106: l_new_end_date := p_actual_end_date;
107:
108: IF NVL(l_new_end_date, fnd_api.g_miss_date) = fnd_api.g_miss_date
109: AND NVL(p_actual_effort, fnd_api.g_miss_num) <> fnd_api.g_miss_num
110: THEN
111: l_new_end_date := l_new_start_date
112: + csf_util_pvt.convert_to_minutes(

Line 109: AND NVL(p_actual_effort, fnd_api.g_miss_num) <> fnd_api.g_miss_num

105: l_new_start_date := p_actual_start_date;
106: l_new_end_date := p_actual_end_date;
107:
108: IF NVL(l_new_end_date, fnd_api.g_miss_date) = fnd_api.g_miss_date
109: AND NVL(p_actual_effort, fnd_api.g_miss_num) <> fnd_api.g_miss_num
110: THEN
111: l_new_end_date := l_new_start_date
112: + csf_util_pvt.convert_to_minutes(
113: p_actual_effort

Line 142: IF NVL(p_old_trip_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num

138: END IF;
139: END IF;
140:
141: -- If the Caller wants to treat the given Old Trip Id as the Old Trip Id, then change it in our DataStructure.
142: IF NVL(p_old_trip_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
143: AND NVL(p_old_trip_ovn, fnd_api.g_miss_num) <> fnd_api.g_miss_num
144: THEN
145: l_task_info.old_trip_id := p_old_trip_id;
146: l_task_info.old_trip_ovn := p_old_trip_id;

Line 143: AND NVL(p_old_trip_ovn, fnd_api.g_miss_num) <> fnd_api.g_miss_num

139: END IF;
140:
141: -- If the Caller wants to treat the given Old Trip Id as the Old Trip Id, then change it in our DataStructure.
142: IF NVL(p_old_trip_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
143: AND NVL(p_old_trip_ovn, fnd_api.g_miss_num) <> fnd_api.g_miss_num
144: THEN
145: l_task_info.old_trip_id := p_old_trip_id;
146: l_task_info.old_trip_ovn := p_old_trip_id;
147: END IF;

Line 150: IF NVL(p_resource_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num

146: l_task_info.old_trip_ovn := p_old_trip_id;
147: END IF;
148:
149: -- If the Caller wants to treat the given Old Trip Id as the Old Trip Id, then change it in our DataStructure.
150: IF NVL(p_resource_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num
151: THEN
152: l_task_info.resource_id := p_resource_id;
153: l_task_info.resource_type_code := p_resource_type_code;
154: END IF;

Line 158: , p_init_msg_list => fnd_api.g_false

154: END IF;
155:
156: csf_trips_pub.find_trip(
157: p_api_version => 1
158: , p_init_msg_list => fnd_api.g_false
159: , x_return_status => x_return_status
160: , x_msg_data => x_msg_data
161: , x_msg_count => x_msg_count
162: , p_resource_id => l_task_info.resource_id

Line 166: , p_overtime_flag => fnd_api.g_true

162: , p_resource_id => l_task_info.resource_id
163: , p_resource_type => l_task_info.resource_type_code
164: , p_start_date_time => l_new_start_date
165: , p_end_date_time => l_new_end_date
166: , p_overtime_flag => fnd_api.g_true
167: , x_trip => l_trip
168: );
169:
170: -- Error would be returned only if there are no trips or multiple trips

Line 172: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

168: );
169:
170: -- Error would be returned only if there are no trips or multiple trips
171: -- found. We should continue in those cases.
172: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
173: RAISE fnd_api.g_exc_unexpected_error;
174: END IF;
175:
176: IF l_new_start_date IS NULL THEN

Line 173: RAISE fnd_api.g_exc_unexpected_error;

169:
170: -- Error would be returned only if there are no trips or multiple trips
171: -- found. We should continue in those cases.
172: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
173: RAISE fnd_api.g_exc_unexpected_error;
174: END IF;
175:
176: IF l_new_start_date IS NULL THEN
177: -- Start Date is NULL. That means there is no timings. Clear the Trip Id

Line 216: , p_init_msg_list => fnd_api.g_false

212:
213: IF l_task_info.old_trip_id <> NVL(l_trip.trip_id, -999) THEN
214: csf_trips_pub.update_trip(
215: p_api_version => 1
216: , p_init_msg_list => fnd_api.g_false
217: , x_return_status => x_return_status
218: , x_msg_data => x_msg_data
219: , x_msg_count => x_msg_count
220: , p_trip_id => l_task_info.old_trip_id

Line 223: , p_available_hours_before => fnd_api.g_miss_num

219: , x_msg_count => x_msg_count
220: , p_trip_id => l_task_info.old_trip_id
221: , p_object_version_number => l_task_info.old_trip_ovn
222: , p_upd_available_hours => l_old_booked_time
223: , p_available_hours_before => fnd_api.g_miss_num
224: , p_available_hours_after => fnd_api.g_miss_num
225: );
226:
227: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 224: , p_available_hours_after => fnd_api.g_miss_num

220: , p_trip_id => l_task_info.old_trip_id
221: , p_object_version_number => l_task_info.old_trip_ovn
222: , p_upd_available_hours => l_old_booked_time
223: , p_available_hours_before => fnd_api.g_miss_num
224: , p_available_hours_after => fnd_api.g_miss_num
225: );
226:
227: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
228: RAISE fnd_api.g_exc_unexpected_error;

Line 227: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

223: , p_available_hours_before => fnd_api.g_miss_num
224: , p_available_hours_after => fnd_api.g_miss_num
225: );
226:
227: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
228: RAISE fnd_api.g_exc_unexpected_error;
229: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
230: RAISE fnd_api.g_exc_error;
231: END IF;

Line 228: RAISE fnd_api.g_exc_unexpected_error;

224: , p_available_hours_after => fnd_api.g_miss_num
225: );
226:
227: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
228: RAISE fnd_api.g_exc_unexpected_error;
229: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
230: RAISE fnd_api.g_exc_error;
231: END IF;
232:

Line 229: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

225: );
226:
227: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
228: RAISE fnd_api.g_exc_unexpected_error;
229: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
230: RAISE fnd_api.g_exc_error;
231: END IF;
232:
233: l_old_booked_time := 0; -- Clear it so that it doesnt affect the new trip

Line 230: RAISE fnd_api.g_exc_error;

226:
227: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
228: RAISE fnd_api.g_exc_unexpected_error;
229: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
230: RAISE fnd_api.g_exc_error;
231: END IF;
232:
233: l_old_booked_time := 0; -- Clear it so that it doesnt affect the new trip
234: END IF;

Line 240: IF NVL(l_trip.trip_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

236:
237: --
238: -- Determine whether we have to update the availability of the New Trip
239: --
240: IF NVL(l_trip.trip_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
241: l_travel_time := 0;
242: IF NVL(p_actual_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
243: l_travel_time := csf_util_pvt.convert_to_minutes(p_actual_travel_duration, p_actual_travel_duration_uom);
244: ELSIF NVL(p_sched_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

Line 242: IF NVL(p_actual_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

238: -- Determine whether we have to update the availability of the New Trip
239: --
240: IF NVL(l_trip.trip_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
241: l_travel_time := 0;
242: IF NVL(p_actual_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
243: l_travel_time := csf_util_pvt.convert_to_minutes(p_actual_travel_duration, p_actual_travel_duration_uom);
244: ELSIF NVL(p_sched_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
245: l_travel_time := csf_util_pvt.convert_to_minutes(p_sched_travel_duration, p_sched_travel_duration);
246: ELSIF NVL(l_task_info.actual_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

Line 244: ELSIF NVL(p_sched_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

240: IF NVL(l_trip.trip_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
241: l_travel_time := 0;
242: IF NVL(p_actual_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
243: l_travel_time := csf_util_pvt.convert_to_minutes(p_actual_travel_duration, p_actual_travel_duration_uom);
244: ELSIF NVL(p_sched_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
245: l_travel_time := csf_util_pvt.convert_to_minutes(p_sched_travel_duration, p_sched_travel_duration);
246: ELSIF NVL(l_task_info.actual_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
247: l_travel_time := l_task_info.actual_travel_duration;
248: ELSIF NVL(l_task_info.sched_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

Line 246: ELSIF NVL(l_task_info.actual_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

242: IF NVL(p_actual_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
243: l_travel_time := csf_util_pvt.convert_to_minutes(p_actual_travel_duration, p_actual_travel_duration_uom);
244: ELSIF NVL(p_sched_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
245: l_travel_time := csf_util_pvt.convert_to_minutes(p_sched_travel_duration, p_sched_travel_duration);
246: ELSIF NVL(l_task_info.actual_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
247: l_travel_time := l_task_info.actual_travel_duration;
248: ELSIF NVL(l_task_info.sched_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
249: l_travel_time := l_task_info.sched_travel_duration;
250: END IF;

Line 248: ELSIF NVL(l_task_info.sched_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

244: ELSIF NVL(p_sched_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
245: l_travel_time := csf_util_pvt.convert_to_minutes(p_sched_travel_duration, p_sched_travel_duration);
246: ELSIF NVL(l_task_info.actual_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
247: l_travel_time := l_task_info.actual_travel_duration;
248: ELSIF NVL(l_task_info.sched_travel_duration, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
249: l_travel_time := l_task_info.sched_travel_duration;
250: END IF;
251:
252: l_new_booked_time := (l_new_end_date - l_new_start_date) * 24 -- Scheduled Dates

Line 259: , p_init_msg_list => fnd_api.g_false

255:
256: IF ROUND(l_new_booked_time, 5) <> 0 THEN
257: csf_trips_pub.update_trip(
258: p_api_version => 1
259: , p_init_msg_list => fnd_api.g_false
260: , x_return_status => x_return_status
261: , x_msg_data => x_msg_data
262: , x_msg_count => x_msg_count
263: , p_trip_id => l_trip.trip_id

Line 266: , p_available_hours_before => fnd_api.g_miss_num

262: , x_msg_count => x_msg_count
263: , p_trip_id => l_trip.trip_id
264: , p_object_version_number => l_trip.object_version_number
265: , p_upd_available_hours => - l_new_booked_time
266: , p_available_hours_before => fnd_api.g_miss_num
267: , p_available_hours_after => fnd_api.g_miss_num
268: );
269: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
270: RAISE fnd_api.g_exc_unexpected_error;

Line 267: , p_available_hours_after => fnd_api.g_miss_num

263: , p_trip_id => l_trip.trip_id
264: , p_object_version_number => l_trip.object_version_number
265: , p_upd_available_hours => - l_new_booked_time
266: , p_available_hours_before => fnd_api.g_miss_num
267: , p_available_hours_after => fnd_api.g_miss_num
268: );
269: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
270: RAISE fnd_api.g_exc_unexpected_error;
271: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

Line 269: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

265: , p_upd_available_hours => - l_new_booked_time
266: , p_available_hours_before => fnd_api.g_miss_num
267: , p_available_hours_after => fnd_api.g_miss_num
268: );
269: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
270: RAISE fnd_api.g_exc_unexpected_error;
271: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
272: RAISE fnd_api.g_exc_error;
273: END IF;

Line 270: RAISE fnd_api.g_exc_unexpected_error;

266: , p_available_hours_before => fnd_api.g_miss_num
267: , p_available_hours_after => fnd_api.g_miss_num
268: );
269: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
270: RAISE fnd_api.g_exc_unexpected_error;
271: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
272: RAISE fnd_api.g_exc_error;
273: END IF;
274: END IF;

Line 271: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

267: , p_available_hours_after => fnd_api.g_miss_num
268: );
269: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
270: RAISE fnd_api.g_exc_unexpected_error;
271: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
272: RAISE fnd_api.g_exc_error;
273: END IF;
274: END IF;
275:

Line 272: RAISE fnd_api.g_exc_error;

268: );
269: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
270: RAISE fnd_api.g_exc_unexpected_error;
271: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
272: RAISE fnd_api.g_exc_error;
273: END IF;
274: END IF;
275:
276: END IF;

Line 280: WHEN fnd_api.g_exc_error THEN

276: END IF;
277:
278: x_trip_id := l_trip.trip_id;
279: EXCEPTION
280: WHEN fnd_api.g_exc_error THEN
281: x_trip_id := NULL;
282: x_return_status := fnd_api.g_ret_sts_error;
283: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
284: WHEN fnd_api.g_exc_unexpected_error THEN

Line 282: x_return_status := fnd_api.g_ret_sts_error;

278: x_trip_id := l_trip.trip_id;
279: EXCEPTION
280: WHEN fnd_api.g_exc_error THEN
281: x_trip_id := NULL;
282: x_return_status := fnd_api.g_ret_sts_error;
283: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
284: WHEN fnd_api.g_exc_unexpected_error THEN
285: x_trip_id := NULL;
286: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 284: WHEN fnd_api.g_exc_unexpected_error THEN

280: WHEN fnd_api.g_exc_error THEN
281: x_trip_id := NULL;
282: x_return_status := fnd_api.g_ret_sts_error;
283: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
284: WHEN fnd_api.g_exc_unexpected_error THEN
285: x_trip_id := NULL;
286: x_return_status := fnd_api.g_ret_sts_unexp_error;
287: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
288: WHEN OTHERS THEN

Line 286: x_return_status := fnd_api.g_ret_sts_unexp_error;

282: x_return_status := fnd_api.g_ret_sts_error;
283: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
284: WHEN fnd_api.g_exc_unexpected_error THEN
285: x_trip_id := NULL;
286: x_return_status := fnd_api.g_ret_sts_unexp_error;
287: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
288: WHEN OTHERS THEN
289: x_return_status := fnd_api.g_ret_sts_unexp_error;
290: x_trip_id := NULL;

Line 289: x_return_status := fnd_api.g_ret_sts_unexp_error;

285: x_trip_id := NULL;
286: x_return_status := fnd_api.g_ret_sts_unexp_error;
287: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
288: WHEN OTHERS THEN
289: x_return_status := fnd_api.g_ret_sts_unexp_error;
290: x_trip_id := NULL;
291: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
292: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
293: END IF;

Line 370: x_return_status := fnd_api.g_ret_sts_success;

366: L_TASK NUMBER;
367: L_TRIP_START DATE;
368:
369: BEGIN
370: x_return_status := fnd_api.g_ret_sts_success;
371:
372: OPEN c_task_info;
373: FETCH c_task_info INTO l_task_info;
374: CLOSE c_task_info;

Line 381: IF p_update_task IS NULL OR p_update_task = fnd_api.g_true THEN

377: -- or Rejected Assignments), then the new Status should be propagated to Task also
378: -- for both of them to be in Sync.
379: x_task_object_version_number := l_task_info.object_version_number;
380: x_task_status_id := l_task_info.task_status_id;
381: IF p_update_task IS NULL OR p_update_task = fnd_api.g_true THEN
382: IF l_task_info.other_ta_exists = 'N' AND l_task_info.task_status_id <> p_new_assignment_status_id THEN
383: x_task_status_id := p_new_assignment_status_id;
384:
385: -- The Task is going to be cancelled... Clear the Scheduled Dates

Line 407: , p_enable_workflow => fnd_api.g_miss_char

403: , p_task_status_id => x_task_status_id
404: , p_object_version_number => x_task_object_version_number
405: , p_scheduled_start_date => l_scheduled_start
406: , p_scheduled_end_date => l_scheduled_end
407: , p_enable_workflow => fnd_api.g_miss_char
408: , p_abort_workflow => fnd_api.g_miss_char
409: );
410:
411: IF x_return_status = fnd_api.g_ret_sts_error THEN

Line 408: , p_abort_workflow => fnd_api.g_miss_char

404: , p_object_version_number => x_task_object_version_number
405: , p_scheduled_start_date => l_scheduled_start
406: , p_scheduled_end_date => l_scheduled_end
407: , p_enable_workflow => fnd_api.g_miss_char
408: , p_abort_workflow => fnd_api.g_miss_char
409: );
410:
411: IF x_return_status = fnd_api.g_ret_sts_error THEN
412: RAISE fnd_api.g_exc_error;

Line 411: IF x_return_status = fnd_api.g_ret_sts_error THEN

407: , p_enable_workflow => fnd_api.g_miss_char
408: , p_abort_workflow => fnd_api.g_miss_char
409: );
410:
411: IF x_return_status = fnd_api.g_ret_sts_error THEN
412: RAISE fnd_api.g_exc_error;
413: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
414: RAISE fnd_api.g_exc_unexpected_error;
415: END IF;

Line 412: RAISE fnd_api.g_exc_error;

408: , p_abort_workflow => fnd_api.g_miss_char
409: );
410:
411: IF x_return_status = fnd_api.g_ret_sts_error THEN
412: RAISE fnd_api.g_exc_error;
413: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
414: RAISE fnd_api.g_exc_unexpected_error;
415: END IF;
416: END IF;

Line 413: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

409: );
410:
411: IF x_return_status = fnd_api.g_ret_sts_error THEN
412: RAISE fnd_api.g_exc_error;
413: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
414: RAISE fnd_api.g_exc_unexpected_error;
415: END IF;
416: END IF;
417:

Line 414: RAISE fnd_api.g_exc_unexpected_error;

410:
411: IF x_return_status = fnd_api.g_ret_sts_error THEN
412: RAISE fnd_api.g_exc_error;
413: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
414: RAISE fnd_api.g_exc_unexpected_error;
415: END IF;
416: END IF;
417:
418: -- update the Parent Task so that it is having the correct Scheduled Dates.

Line 423: , p_init_msg_list => fnd_api.g_false

419: IF l_task_info.task_split_flag = 'D' THEN
420: -- Sync up the Parent and all the other Siblings
421: csf_tasks_pub.update_task_longer_than_shift(
422: p_api_version => 1.0
423: , p_init_msg_list => fnd_api.g_false
424: , p_commit => fnd_api.g_false
425: , x_return_status => x_return_status
426: , x_msg_count => x_msg_count
427: , x_msg_data => x_msg_data

Line 424: , p_commit => fnd_api.g_false

420: -- Sync up the Parent and all the other Siblings
421: csf_tasks_pub.update_task_longer_than_shift(
422: p_api_version => 1.0
423: , p_init_msg_list => fnd_api.g_false
424: , p_commit => fnd_api.g_false
425: , x_return_status => x_return_status
426: , x_msg_count => x_msg_count
427: , x_msg_data => x_msg_data
428: , p_task_id => l_task_info.parent_task_id

Line 432: IF x_return_status = fnd_api.g_ret_sts_error THEN

428: , p_task_id => l_task_info.parent_task_id
429: , p_object_version_number => l_task_info.parent_task_ovn
430: , p_action => csf_tasks_pub.g_action_normal_to_parent
431: );
432: IF x_return_status = fnd_api.g_ret_sts_error THEN
433: RAISE fnd_api.g_exc_error;
434: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
435: RAISE fnd_api.g_exc_unexpected_error;
436: END IF;

Line 433: RAISE fnd_api.g_exc_error;

429: , p_object_version_number => l_task_info.parent_task_ovn
430: , p_action => csf_tasks_pub.g_action_normal_to_parent
431: );
432: IF x_return_status = fnd_api.g_ret_sts_error THEN
433: RAISE fnd_api.g_exc_error;
434: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
435: RAISE fnd_api.g_exc_unexpected_error;
436: END IF;
437: END IF;

Line 434: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

430: , p_action => csf_tasks_pub.g_action_normal_to_parent
431: );
432: IF x_return_status = fnd_api.g_ret_sts_error THEN
433: RAISE fnd_api.g_exc_error;
434: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
435: RAISE fnd_api.g_exc_unexpected_error;
436: END IF;
437: END IF;
438: END IF;

Line 435: RAISE fnd_api.g_exc_unexpected_error;

431: );
432: IF x_return_status = fnd_api.g_ret_sts_error THEN
433: RAISE fnd_api.g_exc_error;
434: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
435: RAISE fnd_api.g_exc_unexpected_error;
436: END IF;
437: END IF;
438: END IF;
439:

Line 451: IF x_return_status = fnd_api.g_ret_sts_error THEN

447: , x_return_status => x_return_status
448: , x_msg_count => x_msg_count
449: , x_msg_data => x_msg_data
450: );
451: IF x_return_status = fnd_api.g_ret_sts_error THEN
452: RAISE fnd_api.g_exc_error;
453: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
454: RAISE fnd_api.g_exc_unexpected_error;
455: END IF;

Line 452: RAISE fnd_api.g_exc_error;

448: , x_msg_count => x_msg_count
449: , x_msg_data => x_msg_data
450: );
451: IF x_return_status = fnd_api.g_ret_sts_error THEN
452: RAISE fnd_api.g_exc_error;
453: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
454: RAISE fnd_api.g_exc_unexpected_error;
455: END IF;
456:

Line 453: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

449: , x_msg_data => x_msg_data
450: );
451: IF x_return_status = fnd_api.g_ret_sts_error THEN
452: RAISE fnd_api.g_exc_error;
453: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
454: RAISE fnd_api.g_exc_unexpected_error;
455: END IF;
456:
457: -- Assignment was previously linked to a trip. Increase its Availability

Line 454: RAISE fnd_api.g_exc_unexpected_error;

450: );
451: IF x_return_status = fnd_api.g_ret_sts_error THEN
452: RAISE fnd_api.g_exc_error;
453: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
454: RAISE fnd_api.g_exc_unexpected_error;
455: END IF;
456:
457: -- Assignment was previously linked to a trip. Increase its Availability
458: IF l_task_info.trip_id IS NOT NULL THEN

Line 473: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

469: , x_trip_id => l_task_info.trip_id
470: );
471:
472: -- Error out only when we have unexpected error.
473: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
474: RAISE fnd_api.g_exc_unexpected_error;
475: END IF;
476: END IF;
477: END IF;

Line 474: RAISE fnd_api.g_exc_unexpected_error;

470: );
471:
472: -- Error out only when we have unexpected error.
473: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
474: RAISE fnd_api.g_exc_unexpected_error;
475: END IF;
476: END IF;
477: END IF;
478: END propagate_status_change;

Line 487: * If the Trip ID corresponding to the Task Assignment is passed as FND_API.G_MISS_NUM

483: * If there exists any Cancelled Task Assignment for the Task with the given
484: * Resource Information, then that Task Assignment is reused rather than creating a
485: * new Task Assignment afresh.
486: *
487: * If the Trip ID corresponding to the Task Assignment is passed as FND_API.G_MISS_NUM
488: * then the user doesnt want to link the Assignment to any Trip. So the Trip ID will
489: * be saved as NULL corresponding to the Task Assignment.
490: * If Trip ID is passed as NULL or not passed at all, then the API will try to find a
491: * Trip corresponding to the Assignment. Since we are dependent on Trips Model, any

Line 495: * Trip ID should be passed as FND_API.G_MISS_NUM.

491: * Trip corresponding to the Assignment. Since we are dependent on Trips Model, any
492: * Assignment created for a Field Service Task should be linked to a Trip (based on
493: * Actual Date / Scheduled Dates). If there exists no Trip or there exists multiple trips,
494: * then the API will error out. If Assignment shouldnt be linked to any Trip, then
495: * Trip ID should be passed as FND_API.G_MISS_NUM.
496: *
497: * Except for Task ID, Resouce ID, Resource Type Code all other parameters are optional.
498: */
499: PROCEDURE create_task_assignment(

Line 588: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

584: l_end_date DATE;
585: BEGIN
586: SAVEPOINT csf_create_task_assignment_pub;
587:
588: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
589: RAISE fnd_api.g_exc_unexpected_error;
590: END IF;
591:
592: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 589: RAISE fnd_api.g_exc_unexpected_error;

585: BEGIN
586: SAVEPOINT csf_create_task_assignment_pub;
587:
588: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
589: RAISE fnd_api.g_exc_unexpected_error;
590: END IF;
591:
592: IF fnd_api.to_boolean(p_init_msg_list) THEN
593: fnd_msg_pub.initialize;

Line 592: IF fnd_api.to_boolean(p_init_msg_list) THEN

588: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
589: RAISE fnd_api.g_exc_unexpected_error;
590: END IF;
591:
592: IF fnd_api.to_boolean(p_init_msg_list) THEN
593: fnd_msg_pub.initialize;
594: END IF;
595:
596: x_return_status := fnd_api.g_ret_sts_success;

Line 596: x_return_status := fnd_api.g_ret_sts_success;

592: IF fnd_api.to_boolean(p_init_msg_list) THEN
593: fnd_msg_pub.initialize;
594: END IF;
595:
596: x_return_status := fnd_api.g_ret_sts_success;
597: l_trip_id := p_object_capacity_id;
598:
599: IF (p_validation_level IS NULL OR p_validation_level = fnd_api.g_valid_level_full) THEN
600: -- Validate Field Service status flow

Line 599: IF (p_validation_level IS NULL OR p_validation_level = fnd_api.g_valid_level_full) THEN

595:
596: x_return_status := fnd_api.g_ret_sts_success;
597: l_trip_id := p_object_capacity_id;
598:
599: IF (p_validation_level IS NULL OR p_validation_level = fnd_api.g_valid_level_full) THEN
600: -- Validate Field Service status flow
601: csf_tasks_pub.validate_status_change(NULL, p_assignment_status_id);
602:
603: -- Validate Trip ID passed. Trip ID has to a valid Trip given the Dates

Line 605: -- If FND_API.G_MISS_NUM, then the caller wants to make Trip ID as NULL in the DB.

601: csf_tasks_pub.validate_status_change(NULL, p_assignment_status_id);
602:
603: -- Validate Trip ID passed. Trip ID has to a valid Trip given the Dates
604: -- and Resource Critieria.
605: -- If FND_API.G_MISS_NUM, then the caller wants to make Trip ID as NULL in the DB.
606: IF l_trip_id = fnd_api.g_miss_num THEN
607: l_trip_id := NULL;
608: ELSE
609: update_trip_info(

Line 606: IF l_trip_id = fnd_api.g_miss_num THEN

602:
603: -- Validate Trip ID passed. Trip ID has to a valid Trip given the Dates
604: -- and Resource Critieria.
605: -- If FND_API.G_MISS_NUM, then the caller wants to make Trip ID as NULL in the DB.
606: IF l_trip_id = fnd_api.g_miss_num THEN
607: l_trip_id := NULL;
608: ELSE
609: update_trip_info(
610: x_return_status => x_return_status

Line 627: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

623: , p_sched_travel_duration => p_sched_travel_duration
624: , p_sched_travel_duration_uom => p_sched_travel_duration_uom
625: , x_trip_id => l_trip_id
626: );
627: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
628: RAISE fnd_api.g_exc_unexpected_error;
629: END IF;
630: END IF;
631: END IF;

Line 628: RAISE fnd_api.g_exc_unexpected_error;

624: , p_sched_travel_duration_uom => p_sched_travel_duration_uom
625: , x_trip_id => l_trip_id
626: );
627: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
628: RAISE fnd_api.g_exc_unexpected_error;
629: END IF;
630: END IF;
631: END IF;
632:

Line 644: , p_commit => fnd_api.g_false

640: x_task_assignment_id := l_cancelled_assignments.task_assignment_id;
641: update_task_assignment(
642: p_api_version => p_api_version
643: , p_init_msg_list => p_init_msg_list
644: , p_commit => fnd_api.g_false
645: , p_validation_level => fnd_api.g_valid_level_none
646: , x_return_status => x_return_status
647: , x_msg_count => x_msg_count
648: , x_msg_data => x_msg_data

Line 645: , p_validation_level => fnd_api.g_valid_level_none

641: update_task_assignment(
642: p_api_version => p_api_version
643: , p_init_msg_list => p_init_msg_list
644: , p_commit => fnd_api.g_false
645: , p_validation_level => fnd_api.g_valid_level_none
646: , x_return_status => x_return_status
647: , x_msg_count => x_msg_count
648: , x_msg_data => x_msg_data
649: , p_task_assignment_id => x_task_assignment_id

Line 718: , p_enable_workflow => fnd_api.g_miss_char

714: , p_device2_flag => p_device2_flag
715: , p_device3_flag => p_device3_flag
716: , p_resource_territory_id => p_resource_territory_id
717: , p_shift_construct_id => p_shift_construct_id
718: , p_enable_workflow => fnd_api.g_miss_char
719: , p_abort_workflow => fnd_api.g_miss_char
720: , p_attribute1 => p_attribute1
721: , p_attribute2 => p_attribute2
722: , p_attribute3 => p_attribute3

Line 719: , p_abort_workflow => fnd_api.g_miss_char

715: , p_device3_flag => p_device3_flag
716: , p_resource_territory_id => p_resource_territory_id
717: , p_shift_construct_id => p_shift_construct_id
718: , p_enable_workflow => fnd_api.g_miss_char
719: , p_abort_workflow => fnd_api.g_miss_char
720: , p_attribute1 => p_attribute1
721: , p_attribute2 => p_attribute2
722: , p_attribute3 => p_attribute3
723: , p_attribute4 => p_attribute4

Line 739: IF x_return_status = fnd_api.g_ret_sts_error THEN

735: , p_attribute_category => p_attribute_category
736: , x_task_assignment_id => x_task_assignment_id
737: );
738:
739: IF x_return_status = fnd_api.g_ret_sts_error THEN
740: RAISE fnd_api.g_exc_error;
741: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
742: RAISE fnd_api.g_exc_unexpected_error;
743: END IF;

Line 740: RAISE fnd_api.g_exc_error;

736: , x_task_assignment_id => x_task_assignment_id
737: );
738:
739: IF x_return_status = fnd_api.g_ret_sts_error THEN
740: RAISE fnd_api.g_exc_error;
741: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
742: RAISE fnd_api.g_exc_unexpected_error;
743: END IF;
744:

Line 741: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

737: );
738:
739: IF x_return_status = fnd_api.g_ret_sts_error THEN
740: RAISE fnd_api.g_exc_error;
741: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
742: RAISE fnd_api.g_exc_unexpected_error;
743: END IF;
744:
745: OPEN c_assignment_info;

Line 742: RAISE fnd_api.g_exc_unexpected_error;

738:
739: IF x_return_status = fnd_api.g_ret_sts_error THEN
740: RAISE fnd_api.g_exc_error;
741: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
742: RAISE fnd_api.g_exc_unexpected_error;
743: END IF;
744:
745: OPEN c_assignment_info;
746: FETCH c_assignment_info INTO x_ta_object_version_number;

Line 765: IF fnd_api.to_boolean(p_commit) THEN

761: );
762: END IF;
763:
764: -- Standard check of p_commit
765: IF fnd_api.to_boolean(p_commit) THEN
766: COMMIT WORK;
767: END IF;
768: EXCEPTION
769: WHEN fnd_api.g_exc_error THEN

Line 769: WHEN fnd_api.g_exc_error THEN

765: IF fnd_api.to_boolean(p_commit) THEN
766: COMMIT WORK;
767: END IF;
768: EXCEPTION
769: WHEN fnd_api.g_exc_error THEN
770: ROLLBACK TO csf_create_task_assignment_pub;
771: x_return_status := fnd_api.g_ret_sts_error;
772: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
773: WHEN fnd_api.g_exc_unexpected_error THEN

Line 771: x_return_status := fnd_api.g_ret_sts_error;

767: END IF;
768: EXCEPTION
769: WHEN fnd_api.g_exc_error THEN
770: ROLLBACK TO csf_create_task_assignment_pub;
771: x_return_status := fnd_api.g_ret_sts_error;
772: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
773: WHEN fnd_api.g_exc_unexpected_error THEN
774: ROLLBACK TO csf_create_task_assignment_pub;
775: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 773: WHEN fnd_api.g_exc_unexpected_error THEN

769: WHEN fnd_api.g_exc_error THEN
770: ROLLBACK TO csf_create_task_assignment_pub;
771: x_return_status := fnd_api.g_ret_sts_error;
772: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
773: WHEN fnd_api.g_exc_unexpected_error THEN
774: ROLLBACK TO csf_create_task_assignment_pub;
775: x_return_status := fnd_api.g_ret_sts_unexp_error;
776: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
777: WHEN OTHERS THEN

Line 775: x_return_status := fnd_api.g_ret_sts_unexp_error;

771: x_return_status := fnd_api.g_ret_sts_error;
772: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
773: WHEN fnd_api.g_exc_unexpected_error THEN
774: ROLLBACK TO csf_create_task_assignment_pub;
775: x_return_status := fnd_api.g_ret_sts_unexp_error;
776: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
777: WHEN OTHERS THEN
778: x_return_status := fnd_api.g_ret_sts_unexp_error;
779: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 778: x_return_status := fnd_api.g_ret_sts_unexp_error;

774: ROLLBACK TO csf_create_task_assignment_pub;
775: x_return_status := fnd_api.g_ret_sts_unexp_error;
776: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
777: WHEN OTHERS THEN
778: x_return_status := fnd_api.g_ret_sts_unexp_error;
779: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
780: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
781: END IF;
782: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 793: * 2. Updating the Task Assignment with the new Task Status (if not FND_API.G_MISS_NUM)

789: * Given the Task Assignment ID and Task Object Version Number, it calls
790: * JTF Task Assignment API to update the Task Assignment with the new Attributes.
791: * It is actually a two step process
792: * 1. Updating the Task Assignment with the new Task Attributes except Status
793: * 2. Updating the Task Assignment with the new Task Status (if not FND_API.G_MISS_NUM)
794: * by calling UPDATE_ASSIGNMENT_STATUS.
795: *
796: * Because of the two step process, the returned Task Assignment Object
797: * Version Number might be incremented by 2 when user might have expected an

Line 943: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

939:
940: BEGIN
941: SAVEPOINT csf_update_task_assignment_pub;
942:
943: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
944: RAISE fnd_api.g_exc_unexpected_error;
945: END IF;
946:
947: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 944: RAISE fnd_api.g_exc_unexpected_error;

940: BEGIN
941: SAVEPOINT csf_update_task_assignment_pub;
942:
943: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
944: RAISE fnd_api.g_exc_unexpected_error;
945: END IF;
946:
947: IF fnd_api.to_boolean(p_init_msg_list) THEN
948: fnd_msg_pub.initialize;

Line 947: IF fnd_api.to_boolean(p_init_msg_list) THEN

943: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
944: RAISE fnd_api.g_exc_unexpected_error;
945: END IF;
946:
947: IF fnd_api.to_boolean(p_init_msg_list) THEN
948: fnd_msg_pub.initialize;
949: END IF;
950:
951: x_return_status := fnd_api.g_ret_sts_success;

Line 951: x_return_status := fnd_api.g_ret_sts_success;

947: IF fnd_api.to_boolean(p_init_msg_list) THEN
948: fnd_msg_pub.initialize;
949: END IF;
950:
951: x_return_status := fnd_api.g_ret_sts_success;
952:
953: -- Fetch the Task Assignment Information
954: OPEN c_task_assignment_info;
955: FETCH c_task_assignment_info INTO l_old_assignment_status_id, l_task_id;

Line 961: IF p_task_id <> fnd_api.g_miss_num AND p_task_id IS NOT NULL THEN

957:
958: -- We require Task Id for computations. If the caller doesnt pass Task Id
959: -- lets retrieve it from JTF_TASK_ASSIGNMENTS. If the caller has indeeed
960: -- passed it, then use that value.
961: IF p_task_id <> fnd_api.g_miss_num AND p_task_id IS NOT NULL THEN
962: l_task_id := p_task_id;
963: END IF;
964:
965: l_trip_id := p_object_capacity_id;

Line 973: IF p_assignment_status_id <> fnd_api.g_miss_num THEN

969: l_distance := p_sched_travel_distance;
970: l_duration := p_sched_travel_duration;
971: l_duration_uom := p_sched_travel_duration_uom;
972: l_new_sts_cancelled_flag := 'N';
973: IF p_assignment_status_id <> fnd_api.g_miss_num THEN
974: OPEN c_task_status_info;
975: FETCH c_task_status_info INTO l_new_sts_cancelled_flag;
976: CLOSE c_task_status_info;
977:

Line 1018: raise fnd_api.g_exc_error;

1014: fnd_message.set_token('TASK_NUMBER',l_task_number);
1015: fnd_message.set_token('TASK_ASSIGNMENT_STATUS',l_task_name);
1016: --fnd_message.set_token('TRIP_START_DATE',TO_CHAR(L_TRIP_START,'DD/MM/YYYY HH24:MI:SS'));
1017: fnd_msg_pub.add;
1018: raise fnd_api.g_exc_error;
1019: END IF;
1020: END IF;
1021: END LOOP;
1022:

Line 1024: IF (p_validation_level IS NULL OR p_validation_level = fnd_api.g_valid_level_full) THEN

1020: END IF;
1021: END LOOP;
1022:
1023:
1024: IF (p_validation_level IS NULL OR p_validation_level = fnd_api.g_valid_level_full) THEN
1025:
1026: -- Validate Field Service status flow
1027: IF p_assignment_status_id <> fnd_api.g_miss_num
1028: AND NVL(l_old_assignment_status_id, -1) <> NVL(p_assignment_status_id, -1)

Line 1027: IF p_assignment_status_id <> fnd_api.g_miss_num

1023:
1024: IF (p_validation_level IS NULL OR p_validation_level = fnd_api.g_valid_level_full) THEN
1025:
1026: -- Validate Field Service status flow
1027: IF p_assignment_status_id <> fnd_api.g_miss_num
1028: AND NVL(l_old_assignment_status_id, -1) <> NVL(p_assignment_status_id, -1)
1029: THEN
1030: csf_tasks_pub.validate_status_change(l_old_assignment_status_id, p_assignment_status_id);
1031: END IF;

Line 1035: -- If Trip ID is passed as FND_API.G_MISS_NUM.. and Actuals are passed, we need to link

1031: END IF;
1032:
1033:
1034:
1035: -- If Trip ID is passed as FND_API.G_MISS_NUM.. and Actuals are passed, we need to link
1036: -- the Task Assignment to the correct Trip.
1037: IF l_trip_id IS NOT NULL AND l_new_sts_cancelled_flag = 'N' THEN
1038:
1039: update_trip_info(

Line 1057: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1053: , p_sched_travel_duration => p_sched_travel_duration
1054: , p_sched_travel_duration_uom => p_sched_travel_duration_uom
1055: , x_trip_id => l_trip_id
1056: );
1057: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1058: RAISE fnd_api.g_exc_unexpected_error;
1059: ELSIF x_return_status = fnd_api.g_ret_sts_success
1060: THEN
1061: open c_tasks;

Line 1058: RAISE fnd_api.g_exc_unexpected_error;

1054: , p_sched_travel_duration_uom => p_sched_travel_duration_uom
1055: , x_trip_id => l_trip_id
1056: );
1057: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1058: RAISE fnd_api.g_exc_unexpected_error;
1059: ELSIF x_return_status = fnd_api.g_ret_sts_success
1060: THEN
1061: open c_tasks;
1062: fetch c_tasks into l_sts,l_task,l_trip,l_modified_ver_no;

Line 1059: ELSIF x_return_status = fnd_api.g_ret_sts_success

1055: , x_trip_id => l_trip_id
1056: );
1057: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1058: RAISE fnd_api.g_exc_unexpected_error;
1059: ELSIF x_return_status = fnd_api.g_ret_sts_success
1060: THEN
1061: open c_tasks;
1062: fetch c_tasks into l_sts,l_task,l_trip,l_modified_ver_no;
1063: close c_tasks;

Line 1131: IF x_return_status = fnd_api.g_ret_sts_error THEN

1127: , p_enable_workflow => p_enable_workflow
1128: , p_abort_workflow => p_abort_workflow
1129: );
1130:
1131: IF x_return_status = fnd_api.g_ret_sts_error THEN
1132: RAISE fnd_api.g_exc_error;
1133: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1134: RAISE fnd_api.g_exc_unexpected_error;
1135: END IF;

Line 1132: RAISE fnd_api.g_exc_error;

1128: , p_abort_workflow => p_abort_workflow
1129: );
1130:
1131: IF x_return_status = fnd_api.g_ret_sts_error THEN
1132: RAISE fnd_api.g_exc_error;
1133: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1134: RAISE fnd_api.g_exc_unexpected_error;
1135: END IF;
1136:

Line 1133: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1129: );
1130:
1131: IF x_return_status = fnd_api.g_ret_sts_error THEN
1132: RAISE fnd_api.g_exc_error;
1133: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1134: RAISE fnd_api.g_exc_unexpected_error;
1135: END IF;
1136:
1137: -- We have JTF_TASK_ASSIGNMENT.UPDATE_TASK_ASSIGNMENT we are passing IN/OUT parameter

Line 1134: RAISE fnd_api.g_exc_unexpected_error;

1130:
1131: IF x_return_status = fnd_api.g_ret_sts_error THEN
1132: RAISE fnd_api.g_exc_error;
1133: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1134: RAISE fnd_api.g_exc_unexpected_error;
1135: END IF;
1136:
1137: -- We have JTF_TASK_ASSIGNMENT.UPDATE_TASK_ASSIGNMENT we are passing IN/OUT parameter
1138: -- as l_modified_ver_no. So when assignment is updated this variable will have incremented

Line 1145: IF p_assignment_status_id <> fnd_api.g_miss_num THEN

1141: -- so i am assigning l_modified_ver_no to p_object_version_number so that it has
1142: -- current object version number
1143: p_object_version_number:=l_modified_ver_no;
1144: -- If Assignment Status is updated, then propagate the status to other objects
1145: IF p_assignment_status_id <> fnd_api.g_miss_num THEN
1146: propagate_status_change(
1147: x_return_status => x_return_status
1148: , x_msg_count => x_msg_count
1149: , x_msg_data => x_msg_data

Line 1158: IF x_return_status = fnd_api.g_ret_sts_error THEN

1154: , p_new_sts_cancelled_flag => l_new_sts_cancelled_flag
1155: , x_task_object_version_number => x_task_object_version_number
1156: , x_task_status_id => x_task_status_id
1157: );
1158: IF x_return_status = fnd_api.g_ret_sts_error THEN
1159: RAISE fnd_api.g_exc_error;
1160: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1161: RAISE fnd_api.g_exc_unexpected_error;
1162: END IF;

Line 1159: RAISE fnd_api.g_exc_error;

1155: , x_task_object_version_number => x_task_object_version_number
1156: , x_task_status_id => x_task_status_id
1157: );
1158: IF x_return_status = fnd_api.g_ret_sts_error THEN
1159: RAISE fnd_api.g_exc_error;
1160: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1161: RAISE fnd_api.g_exc_unexpected_error;
1162: END IF;
1163: END IF;

Line 1160: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1156: , x_task_status_id => x_task_status_id
1157: );
1158: IF x_return_status = fnd_api.g_ret_sts_error THEN
1159: RAISE fnd_api.g_exc_error;
1160: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1161: RAISE fnd_api.g_exc_unexpected_error;
1162: END IF;
1163: END IF;
1164:

Line 1161: RAISE fnd_api.g_exc_unexpected_error;

1157: );
1158: IF x_return_status = fnd_api.g_ret_sts_error THEN
1159: RAISE fnd_api.g_exc_error;
1160: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1161: RAISE fnd_api.g_exc_unexpected_error;
1162: END IF;
1163: END IF;
1164:
1165: -- Standard check of p_commit

Line 1166: IF fnd_api.to_boolean(p_commit) THEN

1162: END IF;
1163: END IF;
1164:
1165: -- Standard check of p_commit
1166: IF fnd_api.to_boolean(p_commit) THEN
1167: COMMIT WORK;
1168: END IF;
1169:
1170: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1172: WHEN fnd_api.g_exc_error THEN

1168: END IF;
1169:
1170: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1171: EXCEPTION
1172: WHEN fnd_api.g_exc_error THEN
1173: ROLLBACK TO csf_update_task_assignment_pub;
1174: x_return_status := fnd_api.g_ret_sts_error;
1175: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1176: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1174: x_return_status := fnd_api.g_ret_sts_error;

1170: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1171: EXCEPTION
1172: WHEN fnd_api.g_exc_error THEN
1173: ROLLBACK TO csf_update_task_assignment_pub;
1174: x_return_status := fnd_api.g_ret_sts_error;
1175: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1176: WHEN fnd_api.g_exc_unexpected_error THEN
1177: ROLLBACK TO csf_update_task_assignment_pub;
1178: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1176: WHEN fnd_api.g_exc_unexpected_error THEN

1172: WHEN fnd_api.g_exc_error THEN
1173: ROLLBACK TO csf_update_task_assignment_pub;
1174: x_return_status := fnd_api.g_ret_sts_error;
1175: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1176: WHEN fnd_api.g_exc_unexpected_error THEN
1177: ROLLBACK TO csf_update_task_assignment_pub;
1178: x_return_status := fnd_api.g_ret_sts_unexp_error;
1179: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1180: WHEN OTHERS THEN

Line 1178: x_return_status := fnd_api.g_ret_sts_unexp_error;

1174: x_return_status := fnd_api.g_ret_sts_error;
1175: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1176: WHEN fnd_api.g_exc_unexpected_error THEN
1177: ROLLBACK TO csf_update_task_assignment_pub;
1178: x_return_status := fnd_api.g_ret_sts_unexp_error;
1179: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1180: WHEN OTHERS THEN
1181: x_return_status := fnd_api.g_ret_sts_unexp_error;
1182: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1181: x_return_status := fnd_api.g_ret_sts_unexp_error;

1177: ROLLBACK TO csf_update_task_assignment_pub;
1178: x_return_status := fnd_api.g_ret_sts_unexp_error;
1179: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1180: WHEN OTHERS THEN
1181: x_return_status := fnd_api.g_ret_sts_unexp_error;
1182: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1183: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1184: END IF;
1185: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1335: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

1331: BEGIN
1332: SAVEPOINT csf_update_assign_status_pub;
1333:
1334:
1335: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1336: RAISE fnd_api.g_exc_unexpected_error;
1337: END IF;
1338:
1339: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 1336: RAISE fnd_api.g_exc_unexpected_error;

1332: SAVEPOINT csf_update_assign_status_pub;
1333:
1334:
1335: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1336: RAISE fnd_api.g_exc_unexpected_error;
1337: END IF;
1338:
1339: IF fnd_api.to_boolean(p_init_msg_list) THEN
1340: fnd_msg_pub.initialize;

Line 1339: IF fnd_api.to_boolean(p_init_msg_list) THEN

1335: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1336: RAISE fnd_api.g_exc_unexpected_error;
1337: END IF;
1338:
1339: IF fnd_api.to_boolean(p_init_msg_list) THEN
1340: fnd_msg_pub.initialize;
1341: END IF;
1342:
1343: x_return_status := fnd_api.g_ret_sts_success;

Line 1343: x_return_status := fnd_api.g_ret_sts_success;

1339: IF fnd_api.to_boolean(p_init_msg_list) THEN
1340: fnd_msg_pub.initialize;
1341: END IF;
1342:
1343: x_return_status := fnd_api.g_ret_sts_success;
1344:
1345: -- Check whether there is anything update in Assignment Status.
1346: IF p_assignment_status_id = fnd_api.g_miss_num THEN
1347: RETURN;

Line 1346: IF p_assignment_status_id = fnd_api.g_miss_num THEN

1342:
1343: x_return_status := fnd_api.g_ret_sts_success;
1344:
1345: -- Check whether there is anything update in Assignment Status.
1346: IF p_assignment_status_id = fnd_api.g_miss_num THEN
1347: RETURN;
1348: END IF;
1349:
1350: OPEN c_task_assignment_info;

Line 1358: IF (p_validation_level IS NULL OR p_validation_level = fnd_api.g_valid_level_full) THEN

1354: IF l_old_assignment_status_id = p_assignment_status_id THEN
1355: RETURN;
1356: END IF;
1357:
1358: IF (p_validation_level IS NULL OR p_validation_level = fnd_api.g_valid_level_full) THEN
1359: -- Validate Field Service status flow
1360: csf_tasks_pub.validate_status_change(l_old_assignment_status_id, p_assignment_status_id);
1361: END IF;
1362:

Line 1409: raise fnd_api.g_exc_error;

1405: fnd_message.set_token('TASK_NUMBER',l_task_number);
1406: fnd_message.set_token('TASK_ASSIGNMENT_STATUS',l_task_name);
1407: --fnd_message.set_token('TRIP_START_DATE',TO_CHAR(L_TRIP_START,'DD/MM/YYYY HH24:MI:SS'));
1408: fnd_msg_pub.add;
1409: raise fnd_api.g_exc_error;
1410: END IF;
1411: END IF;
1412: END LOOP;
1413: -- Update the Task Assignment.

Line 1431: , p_enable_workflow => fnd_api.g_false

1427: , p_sched_travel_duration_uom => l_duration_uom
1428: , p_object_capacity_id => l_trip_id
1429: , p_show_on_calendar => p_show_on_calendar
1430: , p_category_id => NULL
1431: , p_enable_workflow => fnd_api.g_false
1432: , p_abort_workflow => fnd_api.g_false
1433: );
1434:
1435: IF x_return_status = fnd_api.g_ret_sts_error THEN

Line 1432: , p_abort_workflow => fnd_api.g_false

1428: , p_object_capacity_id => l_trip_id
1429: , p_show_on_calendar => p_show_on_calendar
1430: , p_category_id => NULL
1431: , p_enable_workflow => fnd_api.g_false
1432: , p_abort_workflow => fnd_api.g_false
1433: );
1434:
1435: IF x_return_status = fnd_api.g_ret_sts_error THEN
1436: RAISE fnd_api.g_exc_error;

Line 1435: IF x_return_status = fnd_api.g_ret_sts_error THEN

1431: , p_enable_workflow => fnd_api.g_false
1432: , p_abort_workflow => fnd_api.g_false
1433: );
1434:
1435: IF x_return_status = fnd_api.g_ret_sts_error THEN
1436: RAISE fnd_api.g_exc_error;
1437: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1438: RAISE fnd_api.g_exc_unexpected_error;
1439: END IF;

Line 1436: RAISE fnd_api.g_exc_error;

1432: , p_abort_workflow => fnd_api.g_false
1433: );
1434:
1435: IF x_return_status = fnd_api.g_ret_sts_error THEN
1436: RAISE fnd_api.g_exc_error;
1437: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1438: RAISE fnd_api.g_exc_unexpected_error;
1439: END IF;
1440:

Line 1437: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1433: );
1434:
1435: IF x_return_status = fnd_api.g_ret_sts_error THEN
1436: RAISE fnd_api.g_exc_error;
1437: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1438: RAISE fnd_api.g_exc_unexpected_error;
1439: END IF;
1440:
1441: -- Propagate the changes to Task, Parent Task, Child Tasks, Spares, etc.

Line 1438: RAISE fnd_api.g_exc_unexpected_error;

1434:
1435: IF x_return_status = fnd_api.g_ret_sts_error THEN
1436: RAISE fnd_api.g_exc_error;
1437: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1438: RAISE fnd_api.g_exc_unexpected_error;
1439: END IF;
1440:
1441: -- Propagate the changes to Task, Parent Task, Child Tasks, Spares, etc.
1442: propagate_status_change(

Line 1455: IF x_return_status = fnd_api.g_ret_sts_error THEN

1451: , x_task_object_version_number => x_task_object_version_number
1452: , x_task_status_id => x_task_status_id
1453: );
1454:
1455: IF x_return_status = fnd_api.g_ret_sts_error THEN
1456: RAISE fnd_api.g_exc_error;
1457: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1458: RAISE fnd_api.g_exc_unexpected_error;
1459: END IF;

Line 1456: RAISE fnd_api.g_exc_error;

1452: , x_task_status_id => x_task_status_id
1453: );
1454:
1455: IF x_return_status = fnd_api.g_ret_sts_error THEN
1456: RAISE fnd_api.g_exc_error;
1457: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1458: RAISE fnd_api.g_exc_unexpected_error;
1459: END IF;
1460:

Line 1457: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1453: );
1454:
1455: IF x_return_status = fnd_api.g_ret_sts_error THEN
1456: RAISE fnd_api.g_exc_error;
1457: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1458: RAISE fnd_api.g_exc_unexpected_error;
1459: END IF;
1460:
1461:

Line 1458: RAISE fnd_api.g_exc_unexpected_error;

1454:
1455: IF x_return_status = fnd_api.g_ret_sts_error THEN
1456: RAISE fnd_api.g_exc_error;
1457: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1458: RAISE fnd_api.g_exc_unexpected_error;
1459: END IF;
1460:
1461:
1462: IF fnd_api.to_boolean(p_commit) THEN

Line 1462: IF fnd_api.to_boolean(p_commit) THEN

1458: RAISE fnd_api.g_exc_unexpected_error;
1459: END IF;
1460:
1461:
1462: IF fnd_api.to_boolean(p_commit) THEN
1463: COMMIT WORK;
1464: END IF;
1465:
1466: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1468: WHEN fnd_api.g_exc_error THEN

1464: END IF;
1465:
1466: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1467: EXCEPTION
1468: WHEN fnd_api.g_exc_error THEN
1469: ROLLBACK TO csf_update_assign_status_pub;
1470: x_return_status := fnd_api.g_ret_sts_error;
1471: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1472: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1470: x_return_status := fnd_api.g_ret_sts_error;

1466: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1467: EXCEPTION
1468: WHEN fnd_api.g_exc_error THEN
1469: ROLLBACK TO csf_update_assign_status_pub;
1470: x_return_status := fnd_api.g_ret_sts_error;
1471: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1472: WHEN fnd_api.g_exc_unexpected_error THEN
1473: ROLLBACK TO csf_update_assign_status_pub;
1474: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1472: WHEN fnd_api.g_exc_unexpected_error THEN

1468: WHEN fnd_api.g_exc_error THEN
1469: ROLLBACK TO csf_update_assign_status_pub;
1470: x_return_status := fnd_api.g_ret_sts_error;
1471: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1472: WHEN fnd_api.g_exc_unexpected_error THEN
1473: ROLLBACK TO csf_update_assign_status_pub;
1474: x_return_status := fnd_api.g_ret_sts_unexp_error;
1475: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1476: WHEN OTHERS THEN

Line 1474: x_return_status := fnd_api.g_ret_sts_unexp_error;

1470: x_return_status := fnd_api.g_ret_sts_error;
1471: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1472: WHEN fnd_api.g_exc_unexpected_error THEN
1473: ROLLBACK TO csf_update_assign_status_pub;
1474: x_return_status := fnd_api.g_ret_sts_unexp_error;
1475: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1476: WHEN OTHERS THEN
1477: x_return_status := fnd_api.g_ret_sts_unexp_error;
1478: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1477: x_return_status := fnd_api.g_ret_sts_unexp_error;

1473: ROLLBACK TO csf_update_assign_status_pub;
1474: x_return_status := fnd_api.g_ret_sts_unexp_error;
1475: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1476: WHEN OTHERS THEN
1477: x_return_status := fnd_api.g_ret_sts_unexp_error;
1478: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1479: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1480: END IF;
1481: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1872: raise fnd_api.g_exc_error;

1868: fnd_message.set_token('TASK_NUMBER',l_task_number);
1869: fnd_message.set_token('TASK_ASSIGNMENT_STATUS',l_task_name);
1870: --fnd_message.set_token('TRIP_START_DATE',TO_CHAR(L_TRIP_START,'DD/MM/YYYY HH24:MI:SS'));
1871: fnd_msg_pub.add;
1872: raise fnd_api.g_exc_error;
1873: END IF;
1874: END IF;
1875: END LOOP;
1876: END IF;

Line 1878: x_return_status := fnd_api.g_ret_sts_success;

1874: END IF;
1875: END LOOP;
1876: END IF;
1877: close c_scheduled_dates;
1878: x_return_status := fnd_api.g_ret_sts_success;
1879: EXCEPTION
1880: WHEN others THEN
1881: x_return_status := fnd_api.g_ret_sts_unexp_error;
1882: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )

Line 1881: x_return_status := fnd_api.g_ret_sts_unexp_error;

1877: close c_scheduled_dates;
1878: x_return_status := fnd_api.g_ret_sts_success;
1879: EXCEPTION
1880: WHEN others THEN
1881: x_return_status := fnd_api.g_ret_sts_unexp_error;
1882: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error )
1883: THEN
1884: fnd_msg_pub.add_exc_msg ( g_pkg_name, l_api_name );
1885: END IF;