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

Line 81: RETURN fnd_api.g_true;

77: AND NVL (schedule_flag, 'N') = 'Y'
78: AND task_type_id = p_task_type_id;
79: BEGIN
80: FOR v_task_type IN c_task_type LOOP
81: RETURN fnd_api.g_true;
82: END LOOP;
83: RETURN fnd_api.g_false;
84: END has_field_service_rule;
85:

Line 83: RETURN fnd_api.g_false;

79: BEGIN
80: FOR v_task_type IN c_task_type LOOP
81: RETURN fnd_api.g_true;
82: END LOOP;
83: RETURN fnd_api.g_false;
84: END has_field_service_rule;
85:
86: FUNCTION has_schedulable_status (p_task_status_id NUMBER)
87: RETURN BOOLEAN IS

Line 142: ELSIF has_field_service_rule (p_task_type_id) = fnd_api.g_false THEN

138: BEGIN
139: x_reason_code := NULL;
140: IF p_deleted_flag = 'Y' THEN
141: x_reason_code := 'CSF_DELETED_TASK';
142: ELSIF has_field_service_rule (p_task_type_id) = fnd_api.g_false THEN
143: x_reason_code := 'CSF_NON_FS_TASK';
144: ELSIF (p_planned_start_date IS NULL OR p_planned_end_date IS NULL) THEN
145: x_reason_code := 'CSF_PLANNED_DATE_NOT_SET';
146: ELSIF p_planned_effort IS NULL THEN

Line 220: l_transition_valid := fnd_api.g_false;

216:
217: l_dummy VARCHAR2(1);
218: l_transition_valid VARCHAR2(1);
219: BEGIN
220: l_transition_valid := fnd_api.g_false;
221:
222: -- If the new Status eqauls the old Status... return Valid.
223: IF p_new_status_id = p_old_status_id THEN
224: l_transition_valid := fnd_api.g_true;

Line 224: l_transition_valid := fnd_api.g_true;

220: l_transition_valid := fnd_api.g_false;
221:
222: -- If the new Status eqauls the old Status... return Valid.
223: IF p_new_status_id = p_old_status_id THEN
224: l_transition_valid := fnd_api.g_true;
225: ELSIF p_old_status_id IS NULL THEN
226: OPEN c_valid_new_trans;
227: FETCH c_valid_new_trans INTO l_dummy;
228: IF c_valid_new_trans%FOUND THEN

Line 229: l_transition_valid := fnd_api.g_true;

225: ELSIF p_old_status_id IS NULL THEN
226: OPEN c_valid_new_trans;
227: FETCH c_valid_new_trans INTO l_dummy;
228: IF c_valid_new_trans%FOUND THEN
229: l_transition_valid := fnd_api.g_true;
230: END IF;
231: CLOSE c_valid_new_trans;
232: ELSE
233: OPEN c_valid_existing_trans;

Line 236: l_transition_valid := fnd_api.g_true;

232: ELSE
233: OPEN c_valid_existing_trans;
234: FETCH c_valid_existing_trans INTO l_dummy;
235: IF c_valid_existing_trans%FOUND THEN
236: l_transition_valid := fnd_api.g_true;
237: END IF;
238: CLOSE c_valid_existing_trans;
239: END IF;
240: RETURN l_transition_valid;

Line 312: IF l_trans_valid = fnd_api.g_false THEN

308: RETURN;
309: END IF;
310:
311: l_trans_valid := validate_state_transition ('TASK_STATUS', p_old_status_id, p_new_status_id);
312: IF l_trans_valid = fnd_api.g_false THEN
313: l_valid_statuses := get_valid_statuses ('TASK_STATUS', p_old_status_id);
314: IF l_valid_statuses IS NULL THEN
315: fnd_message.set_name ('CSF', 'CSF_NO_STATE_TRANSITION');
316: ELSE

Line 322: RAISE fnd_api.g_exc_error;

318: fnd_message.set_token ('P_VALID_STATUSES', l_valid_statuses);
319: END IF;
320: fnd_message.set_token ('P_NEW_STATUS', get_task_status_name (p_new_status_id));
321: fnd_msg_pub.ADD;
322: RAISE fnd_api.g_exc_error;
323: END IF;
324: END validate_status_change;
325:
326: /**

Line 365: x_return_status := fnd_api.g_ret_sts_success;

361: l_valid_statuses VARCHAR2 (2000);
362: l_update_schedulable_task VARCHAR2(3);
363: BEGIN
364: -- Initialize API return status to success
365: x_return_status := fnd_api.g_ret_sts_success;
366:
367: OPEN c_task_details;
368: FETCH c_task_details INTO l_old_status_id;
369: IF c_task_details%NOTFOUND THEN

Line 379: IF validate_state_transition ('TASK_STATUS', l_old_status_id, l_close_status_id) = fnd_api.g_false THEN

375: -- Before a Task can be closed, there are some checks that needs to be done
376:
377: -- Check whether the State Transition is valid.
378: l_close_status_id := fnd_profile.VALUE ('CSF_DFLT_AUTO_CLOSE_TASK_STATUS');
379: IF validate_state_transition ('TASK_STATUS', l_old_status_id, l_close_status_id) = fnd_api.g_false THEN
380: l_valid_statuses := get_valid_statuses ('TASK_STATUS', l_old_status_id);
381: IF l_valid_statuses IS NULL THEN
382: fnd_message.set_name ('CSF', 'CSF_NO_STATE_TRANSITION');
383: ELSE

Line 389: RAISE fnd_api.g_exc_error;

385: fnd_message.set_token ('P_VALID_STATUSES', l_valid_statuses);
386: END IF;
387: fnd_message.set_token ('P_NEW_STATUS', get_task_status_name (l_close_status_id));
388: fnd_msg_pub.ADD;
389: RAISE fnd_api.g_exc_error;
390: END IF;
391:
392: -- Check whether the Assignments and the associated Debriefs have been closed
393: l_update_schedulable_task := NVL(fnd_profile.value('CSFW_UPD_SCHEDULABLE'), 'NO');

Line 403: RAISE fnd_api.g_exc_error;

399: AND v_task_assignment.completed_flag = 'N'
400: AND v_task_assignment.rejected_flag = 'N' THEN
401: fnd_message.set_name('CSF', 'CSF_CLOSED_TASK');
402: fnd_msg_pub.ADD;
403: RAISE fnd_api.g_exc_error;
404: END IF;
405:
406: -- Check whether the Debrief is closed if Task Assignment is not open
407: -- and only when the profile "CSFW: Update Schedulable Task" is set to Yes

Line 412: RAISE fnd_api.g_exc_error;

408: IF l_update_schedulable_task = 'YES' THEN
409: IF NOT is_debrief_closed(v_task_assignment.task_assignment_id) THEN
410: fnd_message.set_name('CSF', 'CSF_DEBRIEF_PENDING');
411: fnd_msg_pub.ADD;
412: RAISE fnd_api.g_exc_error;
413: END IF;
414: END IF;
415: END LOOP;
416:

Line 419: WHEN fnd_api.g_exc_error THEN

415: END LOOP;
416:
417: RETURN TRUE;
418: EXCEPTION
419: WHEN fnd_api.g_exc_error THEN
420: x_return_status := fnd_api.g_ret_sts_error;
421: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
422: RETURN FALSE;
423: WHEN fnd_api.g_exc_unexpected_error THEN

Line 420: x_return_status := fnd_api.g_ret_sts_error;

416:
417: RETURN TRUE;
418: EXCEPTION
419: WHEN fnd_api.g_exc_error THEN
420: x_return_status := fnd_api.g_ret_sts_error;
421: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
422: RETURN FALSE;
423: WHEN fnd_api.g_exc_unexpected_error THEN
424: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 423: WHEN fnd_api.g_exc_unexpected_error THEN

419: WHEN fnd_api.g_exc_error THEN
420: x_return_status := fnd_api.g_ret_sts_error;
421: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
422: RETURN FALSE;
423: WHEN fnd_api.g_exc_unexpected_error THEN
424: x_return_status := fnd_api.g_ret_sts_unexp_error;
425: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
426: RETURN FALSE;
427: WHEN OTHERS THEN

Line 424: x_return_status := fnd_api.g_ret_sts_unexp_error;

420: x_return_status := fnd_api.g_ret_sts_error;
421: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
422: RETURN FALSE;
423: WHEN fnd_api.g_exc_unexpected_error THEN
424: x_return_status := fnd_api.g_ret_sts_unexp_error;
425: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
426: RETURN FALSE;
427: WHEN OTHERS THEN
428: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 428: x_return_status := fnd_api.g_ret_sts_unexp_error;

424: x_return_status := fnd_api.g_ret_sts_unexp_error;
425: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
426: RETURN FALSE;
427: WHEN OTHERS THEN
428: x_return_status := fnd_api.g_ret_sts_unexp_error;
429: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
430: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
431: END IF;
432: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 484: x_return_status := fnd_api.g_ret_sts_success;

480: l_schedulable BOOLEAN;
481: l_message_name VARCHAR2(100);
482: BEGIN
483: -- Initialize API return status to success
484: x_return_status := fnd_api.g_ret_sts_success;
485:
486: -- Fetching the Task Details
487: OPEN c_task_details;
488: FETCH c_task_details INTO l_task_details;

Line 508: RAISE fnd_api.g_exc_error;

504:
505: IF NOT l_schedulable THEN
506: fnd_message.set_name('CSF', l_message_name);
507: fnd_msg_pub.ADD;
508: RAISE fnd_api.g_exc_error;
509: END IF;
510:
511: RETURN TRUE;
512: EXCEPTION

Line 513: WHEN fnd_api.g_exc_error THEN

509: END IF;
510:
511: RETURN TRUE;
512: EXCEPTION
513: WHEN fnd_api.g_exc_error THEN
514: x_return_status := fnd_api.g_ret_sts_error;
515: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
516: RETURN FALSE;
517: WHEN fnd_api.g_exc_unexpected_error THEN

Line 514: x_return_status := fnd_api.g_ret_sts_error;

510:
511: RETURN TRUE;
512: EXCEPTION
513: WHEN fnd_api.g_exc_error THEN
514: x_return_status := fnd_api.g_ret_sts_error;
515: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
516: RETURN FALSE;
517: WHEN fnd_api.g_exc_unexpected_error THEN
518: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 517: WHEN fnd_api.g_exc_unexpected_error THEN

513: WHEN fnd_api.g_exc_error THEN
514: x_return_status := fnd_api.g_ret_sts_error;
515: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
516: RETURN FALSE;
517: WHEN fnd_api.g_exc_unexpected_error THEN
518: x_return_status := fnd_api.g_ret_sts_unexp_error;
519: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
520: RETURN FALSE;
521: WHEN OTHERS THEN

Line 518: x_return_status := fnd_api.g_ret_sts_unexp_error;

514: x_return_status := fnd_api.g_ret_sts_error;
515: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
516: RETURN FALSE;
517: WHEN fnd_api.g_exc_unexpected_error THEN
518: x_return_status := fnd_api.g_ret_sts_unexp_error;
519: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
520: RETURN FALSE;
521: WHEN OTHERS THEN
522: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 522: x_return_status := fnd_api.g_ret_sts_unexp_error;

518: x_return_status := fnd_api.g_ret_sts_unexp_error;
519: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
520: RETURN FALSE;
521: WHEN OTHERS THEN
522: x_return_status := fnd_api.g_ret_sts_unexp_error;
523: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
524: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
525: END IF;
526: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 555: x_return_status := fnd_api.g_ret_sts_success;

551: l_split_flag jtf_tasks_b.task_split_flag%TYPE;
552: l_status_id jtf_task_statuses_b.task_status_id%TYPE;
553: BEGIN
554: -- Initialize API return status to success
555: x_return_status := fnd_api.g_ret_sts_success;
556:
557: OPEN c_task_ta_det;
558: FETCH c_task_ta_det
559: INTO l_sched_start, l_sched_end, l_split_flag, l_status_id, l_resource_id;

Line 579: x_return_status := fnd_api.g_ret_sts_unexp_error;

575: END IF;
576: RETURN FALSE;
577: EXCEPTION
578: WHEN OTHERS THEN
579: x_return_status := fnd_api.g_ret_sts_unexp_error;
580: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
581: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
582: END IF;
583: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

656: -- Standard start of API savepoint
657: SAVEPOINT close_task_pub;
658:
659: -- Standard call to check for call compatibility
660: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
661: RAISE fnd_api.g_exc_unexpected_error;
662: END IF;
663:
664: -- Initialize message list if p_init_msg_list is set to TRUE

Line 661: RAISE fnd_api.g_exc_unexpected_error;

657: SAVEPOINT close_task_pub;
658:
659: -- Standard call to check for call compatibility
660: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
661: RAISE fnd_api.g_exc_unexpected_error;
662: END IF;
663:
664: -- Initialize message list if p_init_msg_list is set to TRUE
665: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 665: IF fnd_api.to_boolean (p_init_msg_list) THEN

661: RAISE fnd_api.g_exc_unexpected_error;
662: END IF;
663:
664: -- Initialize message list if p_init_msg_list is set to TRUE
665: IF fnd_api.to_boolean (p_init_msg_list) THEN
666: fnd_msg_pub.initialize;
667: END IF;
668:
669: -- Initialize API return status to success

Line 670: x_return_status := fnd_api.g_ret_sts_success;

666: fnd_msg_pub.initialize;
667: END IF;
668:
669: -- Initialize API return status to success
670: x_return_status := fnd_api.g_ret_sts_success;
671:
672: l_close_status_id := fnd_profile.VALUE ('CSF_DFLT_AUTO_CLOSE_TASK_STATUS');
673: update_task_status (
674: p_api_version => 1.0

Line 683: IF x_return_status = fnd_api.g_ret_sts_error THEN

679: , p_task_status_id => l_close_status_id
680: , p_object_version_number => l_object_version_number
681: );
682:
683: IF x_return_status = fnd_api.g_ret_sts_error THEN
684: RAISE fnd_api.g_exc_error;
685: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
686: RAISE fnd_api.g_exc_unexpected_error;
687: END IF;

Line 684: RAISE fnd_api.g_exc_error;

680: , p_object_version_number => l_object_version_number
681: );
682:
683: IF x_return_status = fnd_api.g_ret_sts_error THEN
684: RAISE fnd_api.g_exc_error;
685: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
686: RAISE fnd_api.g_exc_unexpected_error;
687: END IF;
688:

Line 685: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

681: );
682:
683: IF x_return_status = fnd_api.g_ret_sts_error THEN
684: RAISE fnd_api.g_exc_error;
685: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
686: RAISE fnd_api.g_exc_unexpected_error;
687: END IF;
688:
689: -- Standard check of p_commit

Line 686: RAISE fnd_api.g_exc_unexpected_error;

682:
683: IF x_return_status = fnd_api.g_ret_sts_error THEN
684: RAISE fnd_api.g_exc_error;
685: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
686: RAISE fnd_api.g_exc_unexpected_error;
687: END IF;
688:
689: -- Standard check of p_commit
690: IF fnd_api.to_boolean (p_commit) THEN

Line 690: IF fnd_api.to_boolean (p_commit) THEN

686: RAISE fnd_api.g_exc_unexpected_error;
687: END IF;
688:
689: -- Standard check of p_commit
690: IF fnd_api.to_boolean (p_commit) THEN
691: COMMIT WORK;
692: END IF;
693: -- Standard call to get message count and if count is 1, get message info
694: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 696: WHEN fnd_api.g_exc_error THEN

692: END IF;
693: -- Standard call to get message count and if count is 1, get message info
694: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
695: EXCEPTION
696: WHEN fnd_api.g_exc_error THEN
697: ROLLBACK TO close_task_pub;
698: x_return_status := fnd_api.g_ret_sts_error;
699: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
700: WHEN fnd_api.g_exc_unexpected_error THEN

Line 698: x_return_status := fnd_api.g_ret_sts_error;

694: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
695: EXCEPTION
696: WHEN fnd_api.g_exc_error THEN
697: ROLLBACK TO close_task_pub;
698: x_return_status := fnd_api.g_ret_sts_error;
699: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
700: WHEN fnd_api.g_exc_unexpected_error THEN
701: ROLLBACK TO close_task_pub;
702: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 700: WHEN fnd_api.g_exc_unexpected_error THEN

696: WHEN fnd_api.g_exc_error THEN
697: ROLLBACK TO close_task_pub;
698: x_return_status := fnd_api.g_ret_sts_error;
699: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
700: WHEN fnd_api.g_exc_unexpected_error THEN
701: ROLLBACK TO close_task_pub;
702: x_return_status := fnd_api.g_ret_sts_unexp_error;
703: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
704: WHEN OTHERS THEN

Line 702: x_return_status := fnd_api.g_ret_sts_unexp_error;

698: x_return_status := fnd_api.g_ret_sts_error;
699: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
700: WHEN fnd_api.g_exc_unexpected_error THEN
701: ROLLBACK TO close_task_pub;
702: x_return_status := fnd_api.g_ret_sts_unexp_error;
703: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
704: WHEN OTHERS THEN
705: x_return_status := fnd_api.g_ret_sts_unexp_error;
706: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 705: x_return_status := fnd_api.g_ret_sts_unexp_error;

701: ROLLBACK TO close_task_pub;
702: x_return_status := fnd_api.g_ret_sts_unexp_error;
703: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
704: WHEN OTHERS THEN
705: x_return_status := fnd_api.g_ret_sts_unexp_error;
706: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
707: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
708: END IF;
709: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

747:
748: l_task_info c_task_info%ROWTYPE;
749: BEGIN
750: -- standard call to check for call compatibility
751: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
752: RAISE fnd_api.g_exc_unexpected_error;
753: END IF;
754:
755: -- initialize message list if p_init_msg_list is set to true

Line 752: RAISE fnd_api.g_exc_unexpected_error;

748: l_task_info c_task_info%ROWTYPE;
749: BEGIN
750: -- standard call to check for call compatibility
751: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
752: RAISE fnd_api.g_exc_unexpected_error;
753: END IF;
754:
755: -- initialize message list if p_init_msg_list is set to true
756: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 756: IF fnd_api.to_boolean (p_init_msg_list) THEN

752: RAISE fnd_api.g_exc_unexpected_error;
753: END IF;
754:
755: -- initialize message list if p_init_msg_list is set to true
756: IF fnd_api.to_boolean (p_init_msg_list) THEN
757: fnd_msg_pub.initialize;
758: END IF;
759:
760: -- initialize api return status to success

Line 761: x_return_status := fnd_api.g_ret_sts_success;

757: fnd_msg_pub.initialize;
758: END IF;
759:
760: -- initialize api return status to success
761: x_return_status := fnd_api.g_ret_sts_success;
762:
763: -- start processing
764: x_count := 0;
765: l_idx := x_collection.FIRST;

Line 807: x_return_status := fnd_api.g_ret_sts_unexp_error;

803: -- standard call to get message count and if count is 1, get message info
804: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
805: EXCEPTION
806: WHEN OTHERS THEN
807: x_return_status := fnd_api.g_ret_sts_unexp_error;
808: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
809: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
810: END IF;
811: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

954: l_reason_code VARCHAR2(100);
955: BEGIN
956: SAVEPOINT csf_create_task_pub;
957:
958: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
959: RAISE fnd_api.g_exc_unexpected_error;
960: END IF;
961:
962: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 959: RAISE fnd_api.g_exc_unexpected_error;

955: BEGIN
956: SAVEPOINT csf_create_task_pub;
957:
958: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
959: RAISE fnd_api.g_exc_unexpected_error;
960: END IF;
961:
962: IF fnd_api.to_boolean (p_init_msg_list) THEN
963: fnd_msg_pub.initialize;

Line 962: IF fnd_api.to_boolean (p_init_msg_list) THEN

958: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
959: RAISE fnd_api.g_exc_unexpected_error;
960: END IF;
961:
962: IF fnd_api.to_boolean (p_init_msg_list) THEN
963: fnd_msg_pub.initialize;
964: END IF;
965:
966: x_return_status := fnd_api.g_ret_sts_success;

Line 966: x_return_status := fnd_api.g_ret_sts_success;

962: IF fnd_api.to_boolean (p_init_msg_list) THEN
963: fnd_msg_pub.initialize;
964: END IF;
965:
966: x_return_status := fnd_api.g_ret_sts_success;
967:
968: l_task_schedulable := check_schedulable(
969: p_deleted_flag => 'N'
970: , p_planned_start_date => p_planned_start_date

Line 979: IF l_task_schedulable = FALSE OR x_return_status <> fnd_api.g_ret_sts_success THEN

975: , x_reason_code => l_reason_code
976: );
977:
978: -- Task is not schedulable.
979: IF l_task_schedulable = FALSE OR x_return_status <> fnd_api.g_ret_sts_success THEN
980: fnd_message.set_name ('CSF', l_reason_code);
981: fnd_msg_pub.ADD;
982: RAISE fnd_api.g_exc_error;
983: END IF;

Line 982: RAISE fnd_api.g_exc_error;

978: -- Task is not schedulable.
979: IF l_task_schedulable = FALSE OR x_return_status <> fnd_api.g_ret_sts_success THEN
980: fnd_message.set_name ('CSF', l_reason_code);
981: fnd_msg_pub.ADD;
982: RAISE fnd_api.g_exc_error;
983: END IF;
984:
985: jtf_tasks_pub.create_task (
986: p_api_version => p_api_version

Line 987: , p_init_msg_list => fnd_api.g_false

983: END IF;
984:
985: jtf_tasks_pub.create_task (
986: p_api_version => p_api_version
987: , p_init_msg_list => fnd_api.g_false
988: , p_commit => fnd_api.g_false
989: , x_return_status => x_return_status
990: , x_msg_count => x_msg_count
991: , x_msg_data => x_msg_data

Line 988: , p_commit => fnd_api.g_false

984:
985: jtf_tasks_pub.create_task (
986: p_api_version => p_api_version
987: , p_init_msg_list => fnd_api.g_false
988: , p_commit => fnd_api.g_false
989: , x_return_status => x_return_status
990: , x_msg_count => x_msg_count
991: , x_msg_data => x_msg_data
992: , p_task_id => p_task_id

Line 1101: IF x_return_status = fnd_api.g_ret_sts_error THEN

1097: , p_child_sequence_num => p_child_sequence_num
1098: , x_task_id => x_task_id
1099: );
1100:
1101: IF x_return_status = fnd_api.g_ret_sts_error THEN
1102: RAISE fnd_api.g_exc_error;
1103: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1104: RAISE fnd_api.g_exc_unexpected_error;
1105: END IF;

Line 1102: RAISE fnd_api.g_exc_error;

1098: , x_task_id => x_task_id
1099: );
1100:
1101: IF x_return_status = fnd_api.g_ret_sts_error THEN
1102: RAISE fnd_api.g_exc_error;
1103: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1104: RAISE fnd_api.g_exc_unexpected_error;
1105: END IF;
1106: EXCEPTION

Line 1103: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1099: );
1100:
1101: IF x_return_status = fnd_api.g_ret_sts_error THEN
1102: RAISE fnd_api.g_exc_error;
1103: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1104: RAISE fnd_api.g_exc_unexpected_error;
1105: END IF;
1106: EXCEPTION
1107: WHEN fnd_api.g_exc_error THEN

Line 1104: RAISE fnd_api.g_exc_unexpected_error;

1100:
1101: IF x_return_status = fnd_api.g_ret_sts_error THEN
1102: RAISE fnd_api.g_exc_error;
1103: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1104: RAISE fnd_api.g_exc_unexpected_error;
1105: END IF;
1106: EXCEPTION
1107: WHEN fnd_api.g_exc_error THEN
1108: ROLLBACK TO csf_create_task_pub;

Line 1107: WHEN fnd_api.g_exc_error THEN

1103: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1104: RAISE fnd_api.g_exc_unexpected_error;
1105: END IF;
1106: EXCEPTION
1107: WHEN fnd_api.g_exc_error THEN
1108: ROLLBACK TO csf_create_task_pub;
1109: x_return_status := fnd_api.g_ret_sts_error;
1110: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1111: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1109: x_return_status := fnd_api.g_ret_sts_error;

1105: END IF;
1106: EXCEPTION
1107: WHEN fnd_api.g_exc_error THEN
1108: ROLLBACK TO csf_create_task_pub;
1109: x_return_status := fnd_api.g_ret_sts_error;
1110: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1111: WHEN fnd_api.g_exc_unexpected_error THEN
1112: ROLLBACK TO csf_create_task_pub;
1113: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1111: WHEN fnd_api.g_exc_unexpected_error THEN

1107: WHEN fnd_api.g_exc_error THEN
1108: ROLLBACK TO csf_create_task_pub;
1109: x_return_status := fnd_api.g_ret_sts_error;
1110: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1111: WHEN fnd_api.g_exc_unexpected_error THEN
1112: ROLLBACK TO csf_create_task_pub;
1113: x_return_status := fnd_api.g_ret_sts_unexp_error;
1114: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1115: WHEN OTHERS THEN

Line 1113: x_return_status := fnd_api.g_ret_sts_unexp_error;

1109: x_return_status := fnd_api.g_ret_sts_error;
1110: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1111: WHEN fnd_api.g_exc_unexpected_error THEN
1112: ROLLBACK TO csf_create_task_pub;
1113: x_return_status := fnd_api.g_ret_sts_unexp_error;
1114: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1115: WHEN OTHERS THEN
1116: x_return_status := fnd_api.g_ret_sts_unexp_error;
1117: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1116: x_return_status := fnd_api.g_ret_sts_unexp_error;

1112: ROLLBACK TO csf_create_task_pub;
1113: x_return_status := fnd_api.g_ret_sts_unexp_error;
1114: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1115: WHEN OTHERS THEN
1116: x_return_status := fnd_api.g_ret_sts_unexp_error;
1117: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1118: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1119: END IF;
1120: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 1198: x_return_status := fnd_api.g_ret_sts_success;

1194:
1195: l_task_status_id NUMBER;
1196: l_task_ovn NUMBER;
1197: BEGIN
1198: x_return_status := fnd_api.g_ret_sts_success;
1199:
1200: IF p_new_sts_cancelled_flag = 'Y' THEN
1201: -- Cancel all the Open Task Assignments
1202: FOR v_task_assignment IN c_cancel_task_assignments LOOP

Line 1211: , p_update_task => fnd_api.g_false

1207: , x_msg_data => x_msg_data
1208: , p_task_assignment_id => v_task_assignment.task_assignment_id
1209: , p_object_version_number => v_task_assignment.object_version_number
1210: , p_assignment_status_id => p_new_task_status_id
1211: , p_update_task => fnd_api.g_false
1212: , x_task_object_version_number => l_task_ovn
1213: , x_task_status_id => l_task_status_id
1214: );
1215:

Line 1216: IF x_return_status = fnd_api.g_ret_sts_error THEN

1212: , x_task_object_version_number => l_task_ovn
1213: , x_task_status_id => l_task_status_id
1214: );
1215:
1216: IF x_return_status = fnd_api.g_ret_sts_error THEN
1217: RAISE fnd_api.g_exc_error;
1218: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1219: RAISE fnd_api.g_exc_unexpected_error;
1220: END IF;

Line 1217: RAISE fnd_api.g_exc_error;

1213: , x_task_status_id => l_task_status_id
1214: );
1215:
1216: IF x_return_status = fnd_api.g_ret_sts_error THEN
1217: RAISE fnd_api.g_exc_error;
1218: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1219: RAISE fnd_api.g_exc_unexpected_error;
1220: END IF;
1221: END LOOP;

Line 1218: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1214: );
1215:
1216: IF x_return_status = fnd_api.g_ret_sts_error THEN
1217: RAISE fnd_api.g_exc_error;
1218: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1219: RAISE fnd_api.g_exc_unexpected_error;
1220: END IF;
1221: END LOOP;
1222: ELSIF p_new_sts_closed_flag = 'Y' THEN

Line 1219: RAISE fnd_api.g_exc_unexpected_error;

1215:
1216: IF x_return_status = fnd_api.g_ret_sts_error THEN
1217: RAISE fnd_api.g_exc_error;
1218: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1219: RAISE fnd_api.g_exc_unexpected_error;
1220: END IF;
1221: END LOOP;
1222: ELSIF p_new_sts_closed_flag = 'Y' THEN
1223: FOR v_task_assignment IN c_closed_task_assignments LOOP

Line 1241: RAISE fnd_api.g_exc_error;

1237: AND v_task_assignment.rejected_flag = 'N' )
1238: THEN
1239: fnd_message.set_name ('CSF', 'CSF_CLOSED_TASK');
1240: fnd_msg_pub.ADD;
1241: RAISE fnd_api.g_exc_error;
1242: END IF;
1243:
1244: -- Task Assignment is not open. Check for Debrief
1245: IF NOT is_debrief_closed(v_task_assignment.task_assignment_id) THEN

Line 1248: RAISE fnd_api.g_exc_error;

1244: -- Task Assignment is not open. Check for Debrief
1245: IF NOT is_debrief_closed(v_task_assignment.task_assignment_id) THEN
1246: fnd_message.set_name('CSF', 'CSF_DEBRIEF_PENDING');
1247: fnd_msg_pub.ADD;
1248: RAISE fnd_api.g_exc_error;
1249: END IF;
1250:
1251: -- All validations done. Close the Task Assignment
1252: jtf_task_assignments_pub.update_task_assignment(

Line 1261: IF x_return_status = fnd_api.g_ret_sts_error THEN

1257: , p_task_assignment_id => v_task_assignment.task_assignment_id
1258: , p_object_version_number => v_task_assignment.object_version_number
1259: , p_assignment_status_id => p_new_task_status_id
1260: );
1261: IF x_return_status = fnd_api.g_ret_sts_error THEN
1262: RAISE fnd_api.g_exc_error;
1263: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1264: RAISE fnd_api.g_exc_unexpected_error;
1265: END IF;

Line 1262: RAISE fnd_api.g_exc_error;

1258: , p_object_version_number => v_task_assignment.object_version_number
1259: , p_assignment_status_id => p_new_task_status_id
1260: );
1261: IF x_return_status = fnd_api.g_ret_sts_error THEN
1262: RAISE fnd_api.g_exc_error;
1263: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1264: RAISE fnd_api.g_exc_unexpected_error;
1265: END IF;
1266: END LOOP;

Line 1263: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1259: , p_assignment_status_id => p_new_task_status_id
1260: );
1261: IF x_return_status = fnd_api.g_ret_sts_error THEN
1262: RAISE fnd_api.g_exc_error;
1263: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1264: RAISE fnd_api.g_exc_unexpected_error;
1265: END IF;
1266: END LOOP;
1267: END IF;

Line 1264: RAISE fnd_api.g_exc_unexpected_error;

1260: );
1261: IF x_return_status = fnd_api.g_ret_sts_error THEN
1262: RAISE fnd_api.g_exc_error;
1263: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1264: RAISE fnd_api.g_exc_unexpected_error;
1265: END IF;
1266: END LOOP;
1267: END IF;
1268: END propagate_status_change;

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

1322: -- Standard start of API savepoint
1323: SAVEPOINT update_task_status_pub;
1324:
1325: -- Standard call to check for call compatibility
1326: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1327: RAISE fnd_api.g_exc_unexpected_error;
1328: END IF;
1329:
1330: -- Initialize message list if p_init_msg_list is set to TRUE

Line 1327: RAISE fnd_api.g_exc_unexpected_error;

1323: SAVEPOINT update_task_status_pub;
1324:
1325: -- Standard call to check for call compatibility
1326: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1327: RAISE fnd_api.g_exc_unexpected_error;
1328: END IF;
1329:
1330: -- Initialize message list if p_init_msg_list is set to TRUE
1331: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 1331: IF fnd_api.to_boolean (p_init_msg_list) THEN

1327: RAISE fnd_api.g_exc_unexpected_error;
1328: END IF;
1329:
1330: -- Initialize message list if p_init_msg_list is set to TRUE
1331: IF fnd_api.to_boolean (p_init_msg_list) THEN
1332: fnd_msg_pub.initialize;
1333: END IF;
1334:
1335: -- Initialize API return status to success

Line 1336: x_return_status := fnd_api.g_ret_sts_success;

1332: fnd_msg_pub.initialize;
1333: END IF;
1334:
1335: -- Initialize API return status to success
1336: x_return_status := fnd_api.g_ret_sts_success;
1337:
1338: -- Validate if update in necessary and get old status_id just in case
1339: IF p_task_status_id = fnd_api.g_miss_num THEN
1340: RETURN;

Line 1339: IF p_task_status_id = fnd_api.g_miss_num THEN

1335: -- Initialize API return status to success
1336: x_return_status := fnd_api.g_ret_sts_success;
1337:
1338: -- Validate if update in necessary and get old status_id just in case
1339: IF p_task_status_id = fnd_api.g_miss_num THEN
1340: RETURN;
1341: END IF;
1342:
1343: OPEN c_task_info;

Line 1352: IF p_validation_level IS NULL OR p_validation_level = fnd_api.g_valid_level_full THEN

1348: IF p_task_status_id = l_task_info.task_status_id THEN
1349: RETURN;
1350: END IF;
1351:
1352: IF p_validation_level IS NULL OR p_validation_level = fnd_api.g_valid_level_full THEN
1353: validate_status_change(l_task_info.task_status_id, p_task_status_id);
1354: END IF;
1355:
1356: OPEN c_task_status_info;

Line 1378: IF x_return_status = fnd_api.g_ret_sts_error THEN

1374: , p_scheduled_start_date => l_task_info.scheduled_start_date
1375: , p_scheduled_end_date => l_task_info.scheduled_end_date
1376: );
1377:
1378: IF x_return_status = fnd_api.g_ret_sts_error THEN
1379: RAISE fnd_api.g_exc_error;
1380: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1381: RAISE fnd_api.g_exc_unexpected_error;
1382: END IF;

Line 1379: RAISE fnd_api.g_exc_error;

1375: , p_scheduled_end_date => l_task_info.scheduled_end_date
1376: );
1377:
1378: IF x_return_status = fnd_api.g_ret_sts_error THEN
1379: RAISE fnd_api.g_exc_error;
1380: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1381: RAISE fnd_api.g_exc_unexpected_error;
1382: END IF;
1383:

Line 1380: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1376: );
1377:
1378: IF x_return_status = fnd_api.g_ret_sts_error THEN
1379: RAISE fnd_api.g_exc_error;
1380: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1381: RAISE fnd_api.g_exc_unexpected_error;
1382: END IF;
1383:
1384: -- Propagate the change to other dependent objects

Line 1381: RAISE fnd_api.g_exc_unexpected_error;

1377:
1378: IF x_return_status = fnd_api.g_ret_sts_error THEN
1379: RAISE fnd_api.g_exc_error;
1380: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1381: RAISE fnd_api.g_exc_unexpected_error;
1382: END IF;
1383:
1384: -- Propagate the change to other dependent objects
1385: propagate_status_change(

Line 1396: IF x_return_status = fnd_api.g_ret_sts_error THEN

1392: , p_new_sts_cancelled_flag => l_task_status_info.cancelled_flag
1393: , p_new_sts_closed_flag => l_task_status_info.closed_flag
1394: );
1395:
1396: IF x_return_status = fnd_api.g_ret_sts_error THEN
1397: RAISE fnd_api.g_exc_error;
1398: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1399: RAISE fnd_api.g_exc_unexpected_error;
1400: END IF;

Line 1397: RAISE fnd_api.g_exc_error;

1393: , p_new_sts_closed_flag => l_task_status_info.closed_flag
1394: );
1395:
1396: IF x_return_status = fnd_api.g_ret_sts_error THEN
1397: RAISE fnd_api.g_exc_error;
1398: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1399: RAISE fnd_api.g_exc_unexpected_error;
1400: END IF;
1401:

Line 1398: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1394: );
1395:
1396: IF x_return_status = fnd_api.g_ret_sts_error THEN
1397: RAISE fnd_api.g_exc_error;
1398: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1399: RAISE fnd_api.g_exc_unexpected_error;
1400: END IF;
1401:
1402: -- Standard check of p_commit

Line 1399: RAISE fnd_api.g_exc_unexpected_error;

1395:
1396: IF x_return_status = fnd_api.g_ret_sts_error THEN
1397: RAISE fnd_api.g_exc_error;
1398: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1399: RAISE fnd_api.g_exc_unexpected_error;
1400: END IF;
1401:
1402: -- Standard check of p_commit
1403: IF fnd_api.to_boolean (p_commit) THEN

Line 1403: IF fnd_api.to_boolean (p_commit) THEN

1399: RAISE fnd_api.g_exc_unexpected_error;
1400: END IF;
1401:
1402: -- Standard check of p_commit
1403: IF fnd_api.to_boolean (p_commit) THEN
1404: COMMIT WORK;
1405: END IF;
1406:
1407: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 1409: WHEN fnd_api.g_exc_error THEN

1405: END IF;
1406:
1407: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1408: EXCEPTION
1409: WHEN fnd_api.g_exc_error THEN
1410: ROLLBACK TO update_task_status_pub;
1411: x_return_status := fnd_api.g_ret_sts_error;
1412: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1413: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1411: x_return_status := fnd_api.g_ret_sts_error;

1407: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1408: EXCEPTION
1409: WHEN fnd_api.g_exc_error THEN
1410: ROLLBACK TO update_task_status_pub;
1411: x_return_status := fnd_api.g_ret_sts_error;
1412: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1413: WHEN fnd_api.g_exc_unexpected_error THEN
1414: ROLLBACK TO update_task_status_pub;
1415: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1413: WHEN fnd_api.g_exc_unexpected_error THEN

1409: WHEN fnd_api.g_exc_error THEN
1410: ROLLBACK TO update_task_status_pub;
1411: x_return_status := fnd_api.g_ret_sts_error;
1412: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1413: WHEN fnd_api.g_exc_unexpected_error THEN
1414: ROLLBACK TO update_task_status_pub;
1415: x_return_status := fnd_api.g_ret_sts_unexp_error;
1416: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1417: WHEN OTHERS THEN

Line 1415: x_return_status := fnd_api.g_ret_sts_unexp_error;

1411: x_return_status := fnd_api.g_ret_sts_error;
1412: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1413: WHEN fnd_api.g_exc_unexpected_error THEN
1414: ROLLBACK TO update_task_status_pub;
1415: x_return_status := fnd_api.g_ret_sts_unexp_error;
1416: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1417: WHEN OTHERS THEN
1418: x_return_status := fnd_api.g_ret_sts_unexp_error;
1419: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1418: x_return_status := fnd_api.g_ret_sts_unexp_error;

1414: ROLLBACK TO update_task_status_pub;
1415: x_return_status := fnd_api.g_ret_sts_unexp_error;
1416: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1417: WHEN OTHERS THEN
1418: x_return_status := fnd_api.g_ret_sts_unexp_error;
1419: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1420: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1421: END IF;
1422: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1599:
1600: BEGIN
1601: SAVEPOINT csf_update_task;
1602:
1603: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1604: RAISE fnd_api.g_exc_unexpected_error;
1605: END IF;
1606:
1607: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 1604: RAISE fnd_api.g_exc_unexpected_error;

1600: BEGIN
1601: SAVEPOINT csf_update_task;
1602:
1603: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1604: RAISE fnd_api.g_exc_unexpected_error;
1605: END IF;
1606:
1607: IF fnd_api.to_boolean (p_init_msg_list) THEN
1608: fnd_msg_pub.initialize;

Line 1607: IF fnd_api.to_boolean (p_init_msg_list) THEN

1603: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1604: RAISE fnd_api.g_exc_unexpected_error;
1605: END IF;
1606:
1607: IF fnd_api.to_boolean (p_init_msg_list) THEN
1608: fnd_msg_pub.initialize;
1609: END IF;
1610:
1611: x_return_status := fnd_api.g_ret_sts_success;

Line 1611: x_return_status := fnd_api.g_ret_sts_success;

1607: IF fnd_api.to_boolean (p_init_msg_list) THEN
1608: fnd_msg_pub.initialize;
1609: END IF;
1610:
1611: x_return_status := fnd_api.g_ret_sts_success;
1612:
1613: OPEN c_task_info;
1614: FETCH c_task_info INTO l_task_info;
1615: CLOSE c_task_info;

Line 1620: IF p_validation_level = fnd_api.g_valid_level_full AND p_validation_level IS NULL THEN

1616:
1617: l_new_start_date := p_scheduled_start_date;
1618: l_new_end_date := p_scheduled_end_date;
1619:
1620: IF p_validation_level = fnd_api.g_valid_level_full AND p_validation_level IS NULL THEN
1621:
1622: -- Validate Task Status Change
1623: IF p_task_status_id <> fnd_api.g_miss_num THEN
1624: validate_status_change(l_task_info.task_status_id, p_task_status_id);

Line 1623: IF p_task_status_id <> fnd_api.g_miss_num THEN

1619:
1620: IF p_validation_level = fnd_api.g_valid_level_full AND p_validation_level IS NULL THEN
1621:
1622: -- Validate Task Status Change
1623: IF p_task_status_id <> fnd_api.g_miss_num THEN
1624: validate_status_change(l_task_info.task_status_id, p_task_status_id);
1625: END IF;
1626:
1627: -- Validate Trip Information corresponding to new Scheduled Dates

Line 1628: IF NVL(l_new_start_date,fnd_api.g_miss_date) <> fnd_api.g_miss_date

1624: validate_status_change(l_task_info.task_status_id, p_task_status_id);
1625: END IF;
1626:
1627: -- Validate Trip Information corresponding to new Scheduled Dates
1628: IF NVL(l_new_start_date,fnd_api.g_miss_date) <> fnd_api.g_miss_date
1629: OR NVL(l_new_end_date,fnd_api.g_miss_date) <> fnd_api.g_miss_date
1630: THEN
1631:
1632: l_planned_effort := p_planned_effort;

Line 1629: OR NVL(l_new_end_date,fnd_api.g_miss_date) <> fnd_api.g_miss_date

1625: END IF;
1626:
1627: -- Validate Trip Information corresponding to new Scheduled Dates
1628: IF NVL(l_new_start_date,fnd_api.g_miss_date) <> fnd_api.g_miss_date
1629: OR NVL(l_new_end_date,fnd_api.g_miss_date) <> fnd_api.g_miss_date
1630: THEN
1631:
1632: l_planned_effort := p_planned_effort;
1633: l_planned_effort_uom := p_planned_effort_uom;

Line 1635: IF l_planned_effort IS NULL OR l_planned_effort = fnd_api.g_miss_num THEN

1631:
1632: l_planned_effort := p_planned_effort;
1633: l_planned_effort_uom := p_planned_effort_uom;
1634:
1635: IF l_planned_effort IS NULL OR l_planned_effort = fnd_api.g_miss_num THEN
1636: l_planned_effort := l_task_info.planned_effort;
1637: END IF;
1638: IF l_planned_effort_uom IS NULL OR l_planned_effort_uom = fnd_api.g_miss_char THEN
1639: l_planned_effort_uom := l_task_info.planned_effort_uom;

Line 1638: IF l_planned_effort_uom IS NULL OR l_planned_effort_uom = fnd_api.g_miss_char THEN

1634:
1635: IF l_planned_effort IS NULL OR l_planned_effort = fnd_api.g_miss_num THEN
1636: l_planned_effort := l_task_info.planned_effort;
1637: END IF;
1638: IF l_planned_effort_uom IS NULL OR l_planned_effort_uom = fnd_api.g_miss_char THEN
1639: l_planned_effort_uom := l_task_info.planned_effort_uom;
1640: END IF;
1641:
1642: l_planned_effort_minutes := csf_util_pvt.convert_to_minutes(

Line 1655: RAISE fnd_api.g_exc_error;

1651: THEN
1652: fnd_message.set_name ('CSF', 'CSF_TASK_UPDATE_NOT_ALLOWED');
1653: fnd_message.set_token('TASK_NUMBER',l_task_number);
1654: fnd_msg_pub.add;
1655: RAISE fnd_api.g_exc_error;
1656: END IF;
1657:
1658: IF l_task_info.task_assignment_id IS NOT NULL
1659: AND l_task_info.is_visited = 'N'

Line 1660: AND ( l_task_info.scheduled_start_date <> nvl(l_new_start_date,fnd_api.g_miss_date)

1656: END IF;
1657:
1658: IF l_task_info.task_assignment_id IS NOT NULL
1659: AND l_task_info.is_visited = 'N'
1660: AND ( l_task_info.scheduled_start_date <> nvl(l_new_start_date,fnd_api.g_miss_date)
1661: OR l_task_info.scheduled_end_date <> nvl(l_new_end_date,fnd_api.g_miss_date) )
1662: THEN
1663: IF l_new_start_date IS NULL OR l_new_start_date = fnd_api.g_miss_date THEN
1664: l_new_start_date := l_new_end_date - l_planned_effort_minutes / (24 * 60);

Line 1661: OR l_task_info.scheduled_end_date <> nvl(l_new_end_date,fnd_api.g_miss_date) )

1657:
1658: IF l_task_info.task_assignment_id IS NOT NULL
1659: AND l_task_info.is_visited = 'N'
1660: AND ( l_task_info.scheduled_start_date <> nvl(l_new_start_date,fnd_api.g_miss_date)
1661: OR l_task_info.scheduled_end_date <> nvl(l_new_end_date,fnd_api.g_miss_date) )
1662: THEN
1663: IF l_new_start_date IS NULL OR l_new_start_date = fnd_api.g_miss_date THEN
1664: l_new_start_date := l_new_end_date - l_planned_effort_minutes / (24 * 60);
1665: END IF;

Line 1663: IF l_new_start_date IS NULL OR l_new_start_date = fnd_api.g_miss_date THEN

1659: AND l_task_info.is_visited = 'N'
1660: AND ( l_task_info.scheduled_start_date <> nvl(l_new_start_date,fnd_api.g_miss_date)
1661: OR l_task_info.scheduled_end_date <> nvl(l_new_end_date,fnd_api.g_miss_date) )
1662: THEN
1663: IF l_new_start_date IS NULL OR l_new_start_date = fnd_api.g_miss_date THEN
1664: l_new_start_date := l_new_end_date - l_planned_effort_minutes / (24 * 60);
1665: END IF;
1666: IF l_new_end_date IS NULL OR l_new_end_date = fnd_api.g_miss_date THEN
1667: l_new_end_date := l_new_start_date + l_planned_effort_minutes / (24 * 60);

Line 1666: IF l_new_end_date IS NULL OR l_new_end_date = fnd_api.g_miss_date THEN

1662: THEN
1663: IF l_new_start_date IS NULL OR l_new_start_date = fnd_api.g_miss_date THEN
1664: l_new_start_date := l_new_end_date - l_planned_effort_minutes / (24 * 60);
1665: END IF;
1666: IF l_new_end_date IS NULL OR l_new_end_date = fnd_api.g_miss_date THEN
1667: l_new_end_date := l_new_start_date + l_planned_effort_minutes / (24 * 60);
1668: END IF;
1669:
1670: csf_trips_pub.find_trip(

Line 1672: , p_init_msg_list => fnd_api.g_false

1668: END IF;
1669:
1670: csf_trips_pub.find_trip(
1671: p_api_version => 1
1672: , p_init_msg_list => fnd_api.g_false
1673: , x_return_status => x_return_status
1674: , x_msg_data => x_msg_data
1675: , x_msg_count => x_msg_count
1676: , p_resource_id => l_task_info.resource_id

Line 1680: , p_overtime_flag => fnd_api.g_true

1676: , p_resource_id => l_task_info.resource_id
1677: , p_resource_type => l_task_info.resource_type_code
1678: , p_start_date_time => l_new_start_date
1679: , p_end_date_time => l_new_end_date
1680: , p_overtime_flag => fnd_api.g_true
1681: , x_trip_id => l_trip_id
1682: );
1683:
1684: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1684: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1680: , p_overtime_flag => fnd_api.g_true
1681: , x_trip_id => l_trip_id
1682: );
1683:
1684: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1685: RAISE fnd_api.g_exc_unexpected_error;
1686: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1687: -- No Trip or Multiple Trips found for the given dates. Make Trip as NULL
1688: l_trip_id := NULL;

Line 1685: RAISE fnd_api.g_exc_unexpected_error;

1681: , x_trip_id => l_trip_id
1682: );
1683:
1684: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1685: RAISE fnd_api.g_exc_unexpected_error;
1686: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1687: -- No Trip or Multiple Trips found for the given dates. Make Trip as NULL
1688: l_trip_id := NULL;
1689: END IF;

Line 1686: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

1682: );
1683:
1684: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1685: RAISE fnd_api.g_exc_unexpected_error;
1686: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
1687: -- No Trip or Multiple Trips found for the given dates. Make Trip as NULL
1688: l_trip_id := NULL;
1689: END IF;
1690:

Line 1695: , p_commit => fnd_api.g_false

1691: IF NVL(l_trip_id, -1) <> NVL(l_task_info.object_capacity_id,-1) THEN
1692: csf_task_assignments_pub.update_task_assignment(
1693: p_api_version => p_api_version
1694: , p_init_msg_list => p_init_msg_list
1695: , p_commit => fnd_api.g_false
1696: , p_validation_level => fnd_api.g_valid_level_none
1697: , x_return_status => x_return_status
1698: , x_msg_count => x_msg_count
1699: , x_msg_data => x_msg_data

Line 1696: , p_validation_level => fnd_api.g_valid_level_none

1692: csf_task_assignments_pub.update_task_assignment(
1693: p_api_version => p_api_version
1694: , p_init_msg_list => p_init_msg_list
1695: , p_commit => fnd_api.g_false
1696: , p_validation_level => fnd_api.g_valid_level_none
1697: , x_return_status => x_return_status
1698: , x_msg_count => x_msg_count
1699: , x_msg_data => x_msg_data
1700: , p_task_assignment_id => l_task_info.task_assignment_id

Line 1703: , p_update_task => fnd_api.g_false

1699: , x_msg_data => x_msg_data
1700: , p_task_assignment_id => l_task_info.task_assignment_id
1701: , p_object_version_number => l_task_info.object_version_number
1702: , p_object_capacity_id => l_trip_id
1703: , p_update_task => fnd_api.g_false
1704: , x_task_object_version_number => l_task_object_version
1705: , x_task_status_id => l_task_status_id
1706: );
1707:

Line 1708: IF x_return_status = fnd_api.g_ret_sts_error THEN

1704: , x_task_object_version_number => l_task_object_version
1705: , x_task_status_id => l_task_status_id
1706: );
1707:
1708: IF x_return_status = fnd_api.g_ret_sts_error THEN
1709: RAISE fnd_api.g_exc_error;
1710: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1711: RAISE fnd_api.g_exc_unexpected_error;
1712: END IF;

Line 1709: RAISE fnd_api.g_exc_error;

1705: , x_task_status_id => l_task_status_id
1706: );
1707:
1708: IF x_return_status = fnd_api.g_ret_sts_error THEN
1709: RAISE fnd_api.g_exc_error;
1710: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1711: RAISE fnd_api.g_exc_unexpected_error;
1712: END IF;
1713: END IF;

Line 1710: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1706: );
1707:
1708: IF x_return_status = fnd_api.g_ret_sts_error THEN
1709: RAISE fnd_api.g_exc_error;
1710: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1711: RAISE fnd_api.g_exc_unexpected_error;
1712: END IF;
1713: END IF;
1714:

Line 1711: RAISE fnd_api.g_exc_unexpected_error;

1707:
1708: IF x_return_status = fnd_api.g_ret_sts_error THEN
1709: RAISE fnd_api.g_exc_error;
1710: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1711: RAISE fnd_api.g_exc_unexpected_error;
1712: END IF;
1713: END IF;
1714:
1715: IF fnd_api.to_boolean(p_find_overlap) THEN

Line 1715: IF fnd_api.to_boolean(p_find_overlap) THEN

1711: RAISE fnd_api.g_exc_unexpected_error;
1712: END IF;
1713: END IF;
1714:
1715: IF fnd_api.to_boolean(p_find_overlap) THEN
1716: FOR v_overlap_tasks IN c_overlap_tasks(l_trip_id,l_new_start_date,l_new_end_date) LOOP
1717: l_overlap_tasks := l_overlap_tasks || fnd_global.local_chr(10) || v_overlap_tasks.overlap_task_num;
1718: END LOOP;
1719: END IF;

Line 1724: IF p_task_status_id <> fnd_api.g_miss_num AND l_task_info.task_status_id <> p_task_status_id THEN

1720: END IF;
1721: END IF;
1722: END IF;
1723:
1724: IF p_task_status_id <> fnd_api.g_miss_num AND l_task_info.task_status_id <> p_task_status_id THEN
1725: -- Clear the Scheduled Dates if the Task is Cancelled
1726: OPEN c_task_status_info;
1727: FETCH c_task_status_info INTO l_task_status_info;
1728: CLOSE c_task_status_info;

Line 1739: , p_commit => fnd_api.g_false

1735:
1736: jtf_tasks_pub.update_task(
1737: p_api_version => p_api_version
1738: , p_init_msg_list => p_init_msg_list
1739: , p_commit => fnd_api.g_false
1740: , x_return_status => x_return_status
1741: , x_msg_count => x_msg_count
1742: , x_msg_data => x_msg_data
1743: , p_task_id => p_task_id

Line 1835: IF x_return_status = fnd_api.g_ret_sts_error THEN

1831: , p_enable_workflow => p_enable_workflow
1832: , p_abort_workflow => p_abort_workflow
1833: );
1834:
1835: IF x_return_status = fnd_api.g_ret_sts_error THEN
1836: RAISE fnd_api.g_exc_error;
1837: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1838: RAISE fnd_api.g_exc_unexpected_error;
1839: END IF;

Line 1836: RAISE fnd_api.g_exc_error;

1832: , p_abort_workflow => p_abort_workflow
1833: );
1834:
1835: IF x_return_status = fnd_api.g_ret_sts_error THEN
1836: RAISE fnd_api.g_exc_error;
1837: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1838: RAISE fnd_api.g_exc_unexpected_error;
1839: END IF;
1840:

Line 1837: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1833: );
1834:
1835: IF x_return_status = fnd_api.g_ret_sts_error THEN
1836: RAISE fnd_api.g_exc_error;
1837: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1838: RAISE fnd_api.g_exc_unexpected_error;
1839: END IF;
1840:
1841: -- Propagate the Task Status Change to other dependent Objects.

Line 1838: RAISE fnd_api.g_exc_unexpected_error;

1834:
1835: IF x_return_status = fnd_api.g_ret_sts_error THEN
1836: RAISE fnd_api.g_exc_error;
1837: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1838: RAISE fnd_api.g_exc_unexpected_error;
1839: END IF;
1840:
1841: -- Propagate the Task Status Change to other dependent Objects.
1842: IF p_task_status_id <> fnd_api.g_miss_num THEN

Line 1842: IF p_task_status_id <> fnd_api.g_miss_num THEN

1838: RAISE fnd_api.g_exc_unexpected_error;
1839: END IF;
1840:
1841: -- Propagate the Task Status Change to other dependent Objects.
1842: IF p_task_status_id <> fnd_api.g_miss_num THEN
1843: propagate_status_change(
1844: x_return_status => x_return_status
1845: , x_msg_count => x_msg_count
1846: , x_msg_data => x_msg_data

Line 1853: IF x_return_status = fnd_api.g_ret_sts_error THEN

1849: , p_new_task_status_id => p_task_status_id
1850: , p_new_sts_cancelled_flag => l_task_status_info.cancelled_flag
1851: , p_new_sts_closed_flag => l_task_status_info.closed_flag
1852: );
1853: IF x_return_status = fnd_api.g_ret_sts_error THEN
1854: RAISE fnd_api.g_exc_error;
1855: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1856: RAISE fnd_api.g_exc_unexpected_error;
1857: END IF;

Line 1854: RAISE fnd_api.g_exc_error;

1850: , p_new_sts_cancelled_flag => l_task_status_info.cancelled_flag
1851: , p_new_sts_closed_flag => l_task_status_info.closed_flag
1852: );
1853: IF x_return_status = fnd_api.g_ret_sts_error THEN
1854: RAISE fnd_api.g_exc_error;
1855: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1856: RAISE fnd_api.g_exc_unexpected_error;
1857: END IF;
1858: END IF;

Line 1855: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1851: , p_new_sts_closed_flag => l_task_status_info.closed_flag
1852: );
1853: IF x_return_status = fnd_api.g_ret_sts_error THEN
1854: RAISE fnd_api.g_exc_error;
1855: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1856: RAISE fnd_api.g_exc_unexpected_error;
1857: END IF;
1858: END IF;
1859:

Line 1856: RAISE fnd_api.g_exc_unexpected_error;

1852: );
1853: IF x_return_status = fnd_api.g_ret_sts_error THEN
1854: RAISE fnd_api.g_exc_error;
1855: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1856: RAISE fnd_api.g_exc_unexpected_error;
1857: END IF;
1858: END IF;
1859:
1860: IF fnd_api.to_boolean (p_commit) THEN

Line 1860: IF fnd_api.to_boolean (p_commit) THEN

1856: RAISE fnd_api.g_exc_unexpected_error;
1857: END IF;
1858: END IF;
1859:
1860: IF fnd_api.to_boolean (p_commit) THEN
1861: COMMIT WORK;
1862: END IF;
1863:
1864: IF l_overlap_tasks IS NOT NULL THEN

Line 1873: WHEN fnd_api.g_exc_error THEN

1869: END IF;
1870:
1871: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1872: EXCEPTION
1873: WHEN fnd_api.g_exc_error THEN
1874: ROLLBACK TO csf_update_task;
1875: x_return_status := fnd_api.g_ret_sts_error;
1876: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1877: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1875: x_return_status := fnd_api.g_ret_sts_error;

1871: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1872: EXCEPTION
1873: WHEN fnd_api.g_exc_error THEN
1874: ROLLBACK TO csf_update_task;
1875: x_return_status := fnd_api.g_ret_sts_error;
1876: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1877: WHEN fnd_api.g_exc_unexpected_error THEN
1878: ROLLBACK TO csf_update_task;
1879: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1877: WHEN fnd_api.g_exc_unexpected_error THEN

1873: WHEN fnd_api.g_exc_error THEN
1874: ROLLBACK TO csf_update_task;
1875: x_return_status := fnd_api.g_ret_sts_error;
1876: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1877: WHEN fnd_api.g_exc_unexpected_error THEN
1878: ROLLBACK TO csf_update_task;
1879: x_return_status := fnd_api.g_ret_sts_unexp_error;
1880: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1881: WHEN OTHERS THEN

Line 1879: x_return_status := fnd_api.g_ret_sts_unexp_error;

1875: x_return_status := fnd_api.g_ret_sts_error;
1876: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1877: WHEN fnd_api.g_exc_unexpected_error THEN
1878: ROLLBACK TO csf_update_task;
1879: x_return_status := fnd_api.g_ret_sts_unexp_error;
1880: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1881: WHEN OTHERS THEN
1882: x_return_status := fnd_api.g_ret_sts_unexp_error;
1883: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 1882: x_return_status := fnd_api.g_ret_sts_unexp_error;

1878: ROLLBACK TO csf_update_task;
1879: x_return_status := fnd_api.g_ret_sts_unexp_error;
1880: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
1881: WHEN OTHERS THEN
1882: x_return_status := fnd_api.g_ret_sts_unexp_error;
1883: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1884: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1885: END IF;
1886: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

1965: l_valid_statuses VARCHAR2(2000);
1966: BEGIN
1967: SAVEPOINT csf_commit_task;
1968:
1969: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1970: RAISE fnd_api.g_exc_unexpected_error;
1971: END IF;
1972:
1973: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 1970: RAISE fnd_api.g_exc_unexpected_error;

1966: BEGIN
1967: SAVEPOINT csf_commit_task;
1968:
1969: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1970: RAISE fnd_api.g_exc_unexpected_error;
1971: END IF;
1972:
1973: IF fnd_api.to_boolean (p_init_msg_list) THEN
1974: fnd_msg_pub.initialize;

Line 1973: IF fnd_api.to_boolean (p_init_msg_list) THEN

1969: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1970: RAISE fnd_api.g_exc_unexpected_error;
1971: END IF;
1972:
1973: IF fnd_api.to_boolean (p_init_msg_list) THEN
1974: fnd_msg_pub.initialize;
1975: END IF;
1976:
1977: x_return_status := fnd_api.g_ret_sts_success;

Line 1977: x_return_status := fnd_api.g_ret_sts_success;

1973: IF fnd_api.to_boolean (p_init_msg_list) THEN
1974: fnd_msg_pub.initialize;
1975: END IF;
1976:
1977: x_return_status := fnd_api.g_ret_sts_success;
1978:
1979: -- Fetch the Task Information
1980:
1981: IF p_resource_id is null or p_resource_type is null --condition added for bug 6647019

Line 1990: RAISE fnd_api.g_exc_error;

1986: CLOSE c_task_details;
1987: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_TASK_STATUS');
1988: fnd_message.set_token ('P_TASK_NUMBER', task_number(p_task_id));
1989: fnd_msg_pub.ADD;
1990: RAISE fnd_api.g_exc_error;
1991: END IF;
1992: CLOSE c_task_details;
1993: ELSE
1994: OPEN c_task_details_1;

Line 2001: RAISE fnd_api.g_exc_error;

1997: CLOSE c_task_details_1;
1998: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_TASK_STATUS');
1999: fnd_message.set_token ('P_TASK_NUMBER', task_number(p_task_id));
2000: fnd_msg_pub.ADD;
2001: RAISE fnd_api.g_exc_error;
2002: END IF;
2003: CLOSE c_task_details_1;
2004: END IF;
2005:

Line 2011: RAISE fnd_api.g_exc_error;

2007: IF l_task_details.trip_status = csf_trips_pub.g_trip_unavailable THEN
2008: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_TRIP_BLOCK');
2009: fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);
2010: fnd_msg_pub.ADD;
2011: RAISE fnd_api.g_exc_error;
2012: END IF;
2013:
2014: -- Validate Status Transition
2015: l_trans_valid := validate_state_transition ('TASK_STATUS', l_task_details.assignment_status_id, l_new_status_id);

Line 2016: IF l_trans_valid = fnd_api.g_false THEN

2012: END IF;
2013:
2014: -- Validate Status Transition
2015: l_trans_valid := validate_state_transition ('TASK_STATUS', l_task_details.assignment_status_id, l_new_status_id);
2016: IF l_trans_valid = fnd_api.g_false THEN
2017: l_valid_statuses := get_valid_statuses ('TASK_STATUS', l_task_details.assignment_status_id);
2018: IF l_valid_statuses IS NULL THEN
2019: fnd_message.set_name ('CSF', 'CSF_NO_STATE_TRANSITION');
2020: ELSE

Line 2026: RAISE fnd_api.g_exc_error;

2022: fnd_message.set_token ('P_VALID_STATUSES', l_valid_statuses);
2023: END IF;
2024: fnd_message.set_token ('P_NEW_STATUS', get_task_status_name (l_new_status_id));
2025: fnd_msg_pub.ADD;
2026: RAISE fnd_api.g_exc_error;
2027: END IF;
2028:
2029: -- Check the Customer Confirmation Status - Should be either No or Received
2030: IF l_task_details.task_confirmation_status = 'R' THEN

Line 2034: RAISE fnd_api.g_exc_error;

2030: IF l_task_details.task_confirmation_status = 'R' THEN
2031: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_CUST_CONF');
2032: fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);
2033: fnd_msg_pub.ADD;
2034: RAISE fnd_api.g_exc_error;
2035: END IF;
2036:
2037: -- Check for Scheduled Dates
2038: IF l_task_details.scheduled_start_date IS NULL THEN

Line 2042: RAISE fnd_api.g_exc_error;

2038: IF l_task_details.scheduled_start_date IS NULL THEN
2039: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_TASK_SCHE');
2040: fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);
2041: fnd_msg_pub.ADD;
2042: RAISE fnd_api.g_exc_error;
2043: END IF;
2044:
2045: csf_task_assignments_pub.update_assignment_status(
2046: p_api_version => 1.0

Line 2047: , p_validation_level => fnd_api.g_valid_level_none

2043: END IF;
2044:
2045: csf_task_assignments_pub.update_assignment_status(
2046: p_api_version => 1.0
2047: , p_validation_level => fnd_api.g_valid_level_none
2048: , p_init_msg_list => fnd_api.g_false
2049: , p_commit => fnd_api.g_false
2050: , x_return_status => x_return_status
2051: , x_msg_count => x_msg_count

Line 2048: , p_init_msg_list => fnd_api.g_false

2044:
2045: csf_task_assignments_pub.update_assignment_status(
2046: p_api_version => 1.0
2047: , p_validation_level => fnd_api.g_valid_level_none
2048: , p_init_msg_list => fnd_api.g_false
2049: , p_commit => fnd_api.g_false
2050: , x_return_status => x_return_status
2051: , x_msg_count => x_msg_count
2052: , x_msg_data => x_msg_data

Line 2049: , p_commit => fnd_api.g_false

2045: csf_task_assignments_pub.update_assignment_status(
2046: p_api_version => 1.0
2047: , p_validation_level => fnd_api.g_valid_level_none
2048: , p_init_msg_list => fnd_api.g_false
2049: , p_commit => fnd_api.g_false
2050: , x_return_status => x_return_status
2051: , x_msg_count => x_msg_count
2052: , x_msg_data => x_msg_data
2053: , p_task_assignment_id => l_task_details.task_assignment_id

Line 2060: IF x_return_status = fnd_api.g_ret_sts_success THEN

2056: , x_task_object_version_number => l_task_details.object_version_number
2057: , x_task_status_id => l_task_details.task_status_id
2058: );
2059:
2060: IF x_return_status = fnd_api.g_ret_sts_success THEN
2061: -- commented for the bug 6801965
2062: -- Committed Task Message is added to the message stack
2063: -- fnd_message.set_name ('CSF', 'CSF_AUTO_COMMITTED');
2064: -- fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);

Line 2067: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

2063: -- fnd_message.set_name ('CSF', 'CSF_AUTO_COMMITTED');
2064: -- fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);
2065: -- fnd_msg_pub.ADD;
2066: RETURN;
2067: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2068: RAISE fnd_api.g_exc_error;
2069: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2070: RAISE fnd_api.g_exc_unexpected_error;
2071: END IF;

Line 2068: RAISE fnd_api.g_exc_error;

2064: -- fnd_message.set_token ('P_TASK_NUMBER', l_task_details.task_number);
2065: -- fnd_msg_pub.ADD;
2066: RETURN;
2067: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2068: RAISE fnd_api.g_exc_error;
2069: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2070: RAISE fnd_api.g_exc_unexpected_error;
2071: END IF;
2072:

Line 2069: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2065: -- fnd_msg_pub.ADD;
2066: RETURN;
2067: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2068: RAISE fnd_api.g_exc_error;
2069: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2070: RAISE fnd_api.g_exc_unexpected_error;
2071: END IF;
2072:
2073: -- Standard check of p_commit

Line 2070: RAISE fnd_api.g_exc_unexpected_error;

2066: RETURN;
2067: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
2068: RAISE fnd_api.g_exc_error;
2069: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2070: RAISE fnd_api.g_exc_unexpected_error;
2071: END IF;
2072:
2073: -- Standard check of p_commit
2074: IF fnd_api.to_boolean (p_commit) THEN

Line 2074: IF fnd_api.to_boolean (p_commit) THEN

2070: RAISE fnd_api.g_exc_unexpected_error;
2071: END IF;
2072:
2073: -- Standard check of p_commit
2074: IF fnd_api.to_boolean (p_commit) THEN
2075: COMMIT WORK;
2076: END IF;
2077:
2078: EXCEPTION

Line 2079: WHEN fnd_api.g_exc_error THEN

2075: COMMIT WORK;
2076: END IF;
2077:
2078: EXCEPTION
2079: WHEN fnd_api.g_exc_error THEN
2080: ROLLBACK TO csf_commit_task;
2081: x_return_status := fnd_api.g_ret_sts_error;
2082: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2083: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2081: x_return_status := fnd_api.g_ret_sts_error;

2077:
2078: EXCEPTION
2079: WHEN fnd_api.g_exc_error THEN
2080: ROLLBACK TO csf_commit_task;
2081: x_return_status := fnd_api.g_ret_sts_error;
2082: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2083: WHEN fnd_api.g_exc_unexpected_error THEN
2084: ROLLBACK TO csf_commit_task;
2085: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2083: WHEN fnd_api.g_exc_unexpected_error THEN

2079: WHEN fnd_api.g_exc_error THEN
2080: ROLLBACK TO csf_commit_task;
2081: x_return_status := fnd_api.g_ret_sts_error;
2082: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2083: WHEN fnd_api.g_exc_unexpected_error THEN
2084: ROLLBACK TO csf_commit_task;
2085: x_return_status := fnd_api.g_ret_sts_unexp_error;
2086: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2087: WHEN OTHERS THEN

Line 2085: x_return_status := fnd_api.g_ret_sts_unexp_error;

2081: x_return_status := fnd_api.g_ret_sts_error;
2082: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2083: WHEN fnd_api.g_exc_unexpected_error THEN
2084: ROLLBACK TO csf_commit_task;
2085: x_return_status := fnd_api.g_ret_sts_unexp_error;
2086: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2087: WHEN OTHERS THEN
2088: x_return_status := fnd_api.g_ret_sts_unexp_error;
2089: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 2088: x_return_status := fnd_api.g_ret_sts_unexp_error;

2084: ROLLBACK TO csf_commit_task;
2085: x_return_status := fnd_api.g_ret_sts_unexp_error;
2086: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2087: WHEN OTHERS THEN
2088: x_return_status := fnd_api.g_ret_sts_unexp_error;
2089: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2090: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2091: END IF;
2092: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2167:
2168: BEGIN
2169: SAVEPOINT csf_commit_schedule;
2170:
2171: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2172: RAISE fnd_api.g_exc_unexpected_error;
2173: END IF;
2174:
2175: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 2172: RAISE fnd_api.g_exc_unexpected_error;

2168: BEGIN
2169: SAVEPOINT csf_commit_schedule;
2170:
2171: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2172: RAISE fnd_api.g_exc_unexpected_error;
2173: END IF;
2174:
2175: IF fnd_api.to_boolean (p_init_msg_list) THEN
2176: fnd_msg_pub.initialize;

Line 2175: IF fnd_api.to_boolean (p_init_msg_list) THEN

2171: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2172: RAISE fnd_api.g_exc_unexpected_error;
2173: END IF;
2174:
2175: IF fnd_api.to_boolean (p_init_msg_list) THEN
2176: fnd_msg_pub.initialize;
2177: END IF;
2178:
2179: x_return_status := fnd_api.g_ret_sts_success;

Line 2179: x_return_status := fnd_api.g_ret_sts_success;

2175: IF fnd_api.to_boolean (p_init_msg_list) THEN
2176: fnd_msg_pub.initialize;
2177: END IF;
2178:
2179: x_return_status := fnd_api.g_ret_sts_success;
2180:
2181: -- Check whether the required parameters are passed.
2182: IF p_query_id IS NULL AND p_resource_id IS NULL AND p_task_id IS NULL AND p_trip_id IS NULL THEN
2183: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');

Line 2187: RAISE fnd_api.g_exc_error;

2183: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2184: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2185: fnd_message.set_token('PARAM_NAME', 'P_QUERY_ID');
2186: fnd_msg_pub.ADD;
2187: RAISE fnd_api.g_exc_error;
2188: END IF;
2189:
2190: IF p_query_id IS NOT NULL THEN
2191: -- Query will be passed when Commit Schedule Functionality is called from

Line 2336: IF x_return_status = fnd_api.g_ret_sts_error THEN

2332: , x_msg_data => x_msg_data
2333: , x_msg_count => x_msg_count
2334: , p_task_id => l_child_task_id_tbl(j)
2335: );
2336: IF x_return_status = fnd_api.g_ret_sts_error THEN
2337: l_all_passed := FALSE;
2338: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2339: RAISE fnd_api.g_exc_unexpected_error;
2340: END IF;

Line 2338: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2334: , p_task_id => l_child_task_id_tbl(j)
2335: );
2336: IF x_return_status = fnd_api.g_ret_sts_error THEN
2337: l_all_passed := FALSE;
2338: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2339: RAISE fnd_api.g_exc_unexpected_error;
2340: END IF;
2341: END LOOP;
2342: END IF;

Line 2339: RAISE fnd_api.g_exc_unexpected_error;

2335: );
2336: IF x_return_status = fnd_api.g_ret_sts_error THEN
2337: l_all_passed := FALSE;
2338: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2339: RAISE fnd_api.g_exc_unexpected_error;
2340: END IF;
2341: END LOOP;
2342: END IF;
2343: ELSE

Line 2353: IF x_return_status = fnd_api.g_ret_sts_error THEN

2349: , p_task_id => l_task_id_tbl(i)
2350: , p_resource_id => p_resource_id --bug 6647019
2351: , p_resource_type => p_resource_type
2352: );
2353: IF x_return_status = fnd_api.g_ret_sts_error THEN
2354: l_all_passed := FALSE;
2355: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2356: RAISE fnd_api.g_exc_unexpected_error;
2357: ELSE --ADDED code for the bug 6801965

Line 2355: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2351: , p_resource_type => p_resource_type
2352: );
2353: IF x_return_status = fnd_api.g_ret_sts_error THEN
2354: l_all_passed := FALSE;
2355: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2356: RAISE fnd_api.g_exc_unexpected_error;
2357: ELSE --ADDED code for the bug 6801965
2358: l_task_num_tbl.extend;
2359: l_task_num_tbl(l_task_num_tbl.last) := l_task_id_tbl(i);

Line 2356: RAISE fnd_api.g_exc_unexpected_error;

2352: );
2353: IF x_return_status = fnd_api.g_ret_sts_error THEN
2354: l_all_passed := FALSE;
2355: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2356: RAISE fnd_api.g_exc_unexpected_error;
2357: ELSE --ADDED code for the bug 6801965
2358: l_task_num_tbl.extend;
2359: l_task_num_tbl(l_task_num_tbl.last) := l_task_id_tbl(i);
2360: END IF;

Line 2372: x_return_status := fnd_api.g_ret_sts_error;

2368:
2369: IF l_processed_count = 0 AND p_query_id IS NOT NULL THEN
2370: fnd_message.set_name ('CSF', 'CSF_AUTO_COMMIT_NO_TASK');
2371: fnd_msg_pub.ADD;
2372: x_return_status := fnd_api.g_ret_sts_error;
2373: END IF;
2374:
2375: IF NOT l_all_passed THEN
2376: x_return_status := fnd_api.g_ret_sts_error;

Line 2376: x_return_status := fnd_api.g_ret_sts_error;

2372: x_return_status := fnd_api.g_ret_sts_error;
2373: END IF;
2374:
2375: IF NOT l_all_passed THEN
2376: x_return_status := fnd_api.g_ret_sts_error;
2377: END IF;
2378: -- added code for the bug 6801965
2379: IF l_task_num_tbl.count > 0 THEN
2380: FOR i in 1..l_task_num_tbl.count

Line 2390: IF fnd_api.to_boolean (p_commit) THEN

2386: END IF;
2387: -- end of code for the bug 6801965
2388: CLOSE c_task_list;
2389: -- Standard check of p_commit
2390: IF fnd_api.to_boolean (p_commit) THEN
2391: COMMIT WORK;
2392: END IF;
2393:
2394: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

Line 2396: WHEN fnd_api.g_exc_error THEN

2392: END IF;
2393:
2394: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2395: EXCEPTION
2396: WHEN fnd_api.g_exc_error THEN
2397: ROLLBACK TO csf_commit_schedule;
2398: x_return_status := fnd_api.g_ret_sts_error;
2399: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2400: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2398: x_return_status := fnd_api.g_ret_sts_error;

2394: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2395: EXCEPTION
2396: WHEN fnd_api.g_exc_error THEN
2397: ROLLBACK TO csf_commit_schedule;
2398: x_return_status := fnd_api.g_ret_sts_error;
2399: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2400: WHEN fnd_api.g_exc_unexpected_error THEN
2401: ROLLBACK TO csf_commit_schedule;
2402: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2400: WHEN fnd_api.g_exc_unexpected_error THEN

2396: WHEN fnd_api.g_exc_error THEN
2397: ROLLBACK TO csf_commit_schedule;
2398: x_return_status := fnd_api.g_ret_sts_error;
2399: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2400: WHEN fnd_api.g_exc_unexpected_error THEN
2401: ROLLBACK TO csf_commit_schedule;
2402: x_return_status := fnd_api.g_ret_sts_unexp_error;
2403: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2404: WHEN OTHERS THEN

Line 2402: x_return_status := fnd_api.g_ret_sts_unexp_error;

2398: x_return_status := fnd_api.g_ret_sts_error;
2399: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2400: WHEN fnd_api.g_exc_unexpected_error THEN
2401: ROLLBACK TO csf_commit_schedule;
2402: x_return_status := fnd_api.g_ret_sts_unexp_error;
2403: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2404: WHEN OTHERS THEN
2405: x_return_status := fnd_api.g_ret_sts_unexp_error;
2406: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 2405: x_return_status := fnd_api.g_ret_sts_unexp_error;

2401: ROLLBACK TO csf_commit_schedule;
2402: x_return_status := fnd_api.g_ret_sts_unexp_error;
2403: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2404: WHEN OTHERS THEN
2405: x_return_status := fnd_api.g_ret_sts_unexp_error;
2406: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2407: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2408: END IF;
2409: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2601: END get_status_bitcode;
2602: BEGIN
2603: SAVEPOINT csf_sync_parent_with_child;
2604:
2605: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2606: RAISE fnd_api.g_exc_unexpected_error;
2607: END IF;
2608:
2609: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 2606: RAISE fnd_api.g_exc_unexpected_error;

2602: BEGIN
2603: SAVEPOINT csf_sync_parent_with_child;
2604:
2605: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2606: RAISE fnd_api.g_exc_unexpected_error;
2607: END IF;
2608:
2609: IF fnd_api.to_boolean (p_init_msg_list) THEN
2610: fnd_msg_pub.initialize;

Line 2609: IF fnd_api.to_boolean (p_init_msg_list) THEN

2605: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2606: RAISE fnd_api.g_exc_unexpected_error;
2607: END IF;
2608:
2609: IF fnd_api.to_boolean (p_init_msg_list) THEN
2610: fnd_msg_pub.initialize;
2611: END IF;
2612:
2613: x_return_status := fnd_api.g_ret_sts_success;

Line 2613: x_return_status := fnd_api.g_ret_sts_success;

2609: IF fnd_api.to_boolean (p_init_msg_list) THEN
2610: fnd_msg_pub.initialize;
2611: END IF;
2612:
2613: x_return_status := fnd_api.g_ret_sts_success;
2614:
2615: OPEN c_curr_parent_info;
2616: FETCH c_curr_parent_info INTO l_curr_parent_info;
2617: CLOSE c_curr_parent_info;

Line 2685: OR ( NVL(l_curr_parent_info.scheduled_start_date, fnd_api.g_miss_date)

2681: * Finding out whether Parent's Data has Changed *
2682: *****************************************************************************/
2683: l_update_parent :=
2684: l_curr_parent_info.task_status_id <> l_new_parent_info.task_status_id
2685: OR ( NVL(l_curr_parent_info.scheduled_start_date, fnd_api.g_miss_date)
2686: <> NVL(l_new_parent_info.scheduled_start_date, fnd_api.g_miss_date) )
2687: OR ( NVL(l_curr_parent_info.scheduled_end_date, fnd_api.g_miss_date)
2688: <> NVL(l_new_parent_info.scheduled_end_date, fnd_api.g_miss_date) )
2689: OR ( NVL(l_curr_parent_info.actual_start_date, fnd_api.g_miss_date)

Line 2686: <> NVL(l_new_parent_info.scheduled_start_date, fnd_api.g_miss_date) )

2682: *****************************************************************************/
2683: l_update_parent :=
2684: l_curr_parent_info.task_status_id <> l_new_parent_info.task_status_id
2685: OR ( NVL(l_curr_parent_info.scheduled_start_date, fnd_api.g_miss_date)
2686: <> NVL(l_new_parent_info.scheduled_start_date, fnd_api.g_miss_date) )
2687: OR ( NVL(l_curr_parent_info.scheduled_end_date, fnd_api.g_miss_date)
2688: <> NVL(l_new_parent_info.scheduled_end_date, fnd_api.g_miss_date) )
2689: OR ( NVL(l_curr_parent_info.actual_start_date, fnd_api.g_miss_date)
2690: <> NVL(l_new_parent_info.actual_start_date, fnd_api.g_miss_date) )

Line 2687: OR ( NVL(l_curr_parent_info.scheduled_end_date, fnd_api.g_miss_date)

2683: l_update_parent :=
2684: l_curr_parent_info.task_status_id <> l_new_parent_info.task_status_id
2685: OR ( NVL(l_curr_parent_info.scheduled_start_date, fnd_api.g_miss_date)
2686: <> NVL(l_new_parent_info.scheduled_start_date, fnd_api.g_miss_date) )
2687: OR ( NVL(l_curr_parent_info.scheduled_end_date, fnd_api.g_miss_date)
2688: <> NVL(l_new_parent_info.scheduled_end_date, fnd_api.g_miss_date) )
2689: OR ( NVL(l_curr_parent_info.actual_start_date, fnd_api.g_miss_date)
2690: <> NVL(l_new_parent_info.actual_start_date, fnd_api.g_miss_date) )
2691: OR ( NVL(l_curr_parent_info.actual_end_date, fnd_api.g_miss_date)

Line 2688: <> NVL(l_new_parent_info.scheduled_end_date, fnd_api.g_miss_date) )

2684: l_curr_parent_info.task_status_id <> l_new_parent_info.task_status_id
2685: OR ( NVL(l_curr_parent_info.scheduled_start_date, fnd_api.g_miss_date)
2686: <> NVL(l_new_parent_info.scheduled_start_date, fnd_api.g_miss_date) )
2687: OR ( NVL(l_curr_parent_info.scheduled_end_date, fnd_api.g_miss_date)
2688: <> NVL(l_new_parent_info.scheduled_end_date, fnd_api.g_miss_date) )
2689: OR ( NVL(l_curr_parent_info.actual_start_date, fnd_api.g_miss_date)
2690: <> NVL(l_new_parent_info.actual_start_date, fnd_api.g_miss_date) )
2691: OR ( NVL(l_curr_parent_info.actual_end_date, fnd_api.g_miss_date)
2692: <> NVL(l_new_parent_info.actual_end_date, fnd_api.g_miss_date) )

Line 2689: OR ( NVL(l_curr_parent_info.actual_start_date, fnd_api.g_miss_date)

2685: OR ( NVL(l_curr_parent_info.scheduled_start_date, fnd_api.g_miss_date)
2686: <> NVL(l_new_parent_info.scheduled_start_date, fnd_api.g_miss_date) )
2687: OR ( NVL(l_curr_parent_info.scheduled_end_date, fnd_api.g_miss_date)
2688: <> NVL(l_new_parent_info.scheduled_end_date, fnd_api.g_miss_date) )
2689: OR ( NVL(l_curr_parent_info.actual_start_date, fnd_api.g_miss_date)
2690: <> NVL(l_new_parent_info.actual_start_date, fnd_api.g_miss_date) )
2691: OR ( NVL(l_curr_parent_info.actual_end_date, fnd_api.g_miss_date)
2692: <> NVL(l_new_parent_info.actual_end_date, fnd_api.g_miss_date) )
2693: OR ( NVL(l_curr_parent_info.planned_start_date, fnd_api.g_miss_date)

Line 2690: <> NVL(l_new_parent_info.actual_start_date, fnd_api.g_miss_date) )

2686: <> NVL(l_new_parent_info.scheduled_start_date, fnd_api.g_miss_date) )
2687: OR ( NVL(l_curr_parent_info.scheduled_end_date, fnd_api.g_miss_date)
2688: <> NVL(l_new_parent_info.scheduled_end_date, fnd_api.g_miss_date) )
2689: OR ( NVL(l_curr_parent_info.actual_start_date, fnd_api.g_miss_date)
2690: <> NVL(l_new_parent_info.actual_start_date, fnd_api.g_miss_date) )
2691: OR ( NVL(l_curr_parent_info.actual_end_date, fnd_api.g_miss_date)
2692: <> NVL(l_new_parent_info.actual_end_date, fnd_api.g_miss_date) )
2693: OR ( NVL(l_curr_parent_info.planned_start_date, fnd_api.g_miss_date)
2694: <> NVL(p_planned_start_date, fnd_api.g_miss_date) )

Line 2691: OR ( NVL(l_curr_parent_info.actual_end_date, fnd_api.g_miss_date)

2687: OR ( NVL(l_curr_parent_info.scheduled_end_date, fnd_api.g_miss_date)
2688: <> NVL(l_new_parent_info.scheduled_end_date, fnd_api.g_miss_date) )
2689: OR ( NVL(l_curr_parent_info.actual_start_date, fnd_api.g_miss_date)
2690: <> NVL(l_new_parent_info.actual_start_date, fnd_api.g_miss_date) )
2691: OR ( NVL(l_curr_parent_info.actual_end_date, fnd_api.g_miss_date)
2692: <> NVL(l_new_parent_info.actual_end_date, fnd_api.g_miss_date) )
2693: OR ( NVL(l_curr_parent_info.planned_start_date, fnd_api.g_miss_date)
2694: <> NVL(p_planned_start_date, fnd_api.g_miss_date) )
2695: OR ( NVL(l_curr_parent_info.planned_end_date, fnd_api.g_miss_date)

Line 2692: <> NVL(l_new_parent_info.actual_end_date, fnd_api.g_miss_date) )

2688: <> NVL(l_new_parent_info.scheduled_end_date, fnd_api.g_miss_date) )
2689: OR ( NVL(l_curr_parent_info.actual_start_date, fnd_api.g_miss_date)
2690: <> NVL(l_new_parent_info.actual_start_date, fnd_api.g_miss_date) )
2691: OR ( NVL(l_curr_parent_info.actual_end_date, fnd_api.g_miss_date)
2692: <> NVL(l_new_parent_info.actual_end_date, fnd_api.g_miss_date) )
2693: OR ( NVL(l_curr_parent_info.planned_start_date, fnd_api.g_miss_date)
2694: <> NVL(p_planned_start_date, fnd_api.g_miss_date) )
2695: OR ( NVL(l_curr_parent_info.planned_end_date, fnd_api.g_miss_date)
2696: <> NVL(p_planned_end_date, fnd_api.g_miss_date) )

Line 2693: OR ( NVL(l_curr_parent_info.planned_start_date, fnd_api.g_miss_date)

2689: OR ( NVL(l_curr_parent_info.actual_start_date, fnd_api.g_miss_date)
2690: <> NVL(l_new_parent_info.actual_start_date, fnd_api.g_miss_date) )
2691: OR ( NVL(l_curr_parent_info.actual_end_date, fnd_api.g_miss_date)
2692: <> NVL(l_new_parent_info.actual_end_date, fnd_api.g_miss_date) )
2693: OR ( NVL(l_curr_parent_info.planned_start_date, fnd_api.g_miss_date)
2694: <> NVL(p_planned_start_date, fnd_api.g_miss_date) )
2695: OR ( NVL(l_curr_parent_info.planned_end_date, fnd_api.g_miss_date)
2696: <> NVL(p_planned_end_date, fnd_api.g_miss_date) )
2697: OR ( NVL(l_curr_parent_info.actual_effort, -1)

Line 2694: <> NVL(p_planned_start_date, fnd_api.g_miss_date) )

2690: <> NVL(l_new_parent_info.actual_start_date, fnd_api.g_miss_date) )
2691: OR ( NVL(l_curr_parent_info.actual_end_date, fnd_api.g_miss_date)
2692: <> NVL(l_new_parent_info.actual_end_date, fnd_api.g_miss_date) )
2693: OR ( NVL(l_curr_parent_info.planned_start_date, fnd_api.g_miss_date)
2694: <> NVL(p_planned_start_date, fnd_api.g_miss_date) )
2695: OR ( NVL(l_curr_parent_info.planned_end_date, fnd_api.g_miss_date)
2696: <> NVL(p_planned_end_date, fnd_api.g_miss_date) )
2697: OR ( NVL(l_curr_parent_info.actual_effort, -1)
2698: <> NVL(l_new_parent_info.actual_effort, -1) );

Line 2695: OR ( NVL(l_curr_parent_info.planned_end_date, fnd_api.g_miss_date)

2691: OR ( NVL(l_curr_parent_info.actual_end_date, fnd_api.g_miss_date)
2692: <> NVL(l_new_parent_info.actual_end_date, fnd_api.g_miss_date) )
2693: OR ( NVL(l_curr_parent_info.planned_start_date, fnd_api.g_miss_date)
2694: <> NVL(p_planned_start_date, fnd_api.g_miss_date) )
2695: OR ( NVL(l_curr_parent_info.planned_end_date, fnd_api.g_miss_date)
2696: <> NVL(p_planned_end_date, fnd_api.g_miss_date) )
2697: OR ( NVL(l_curr_parent_info.actual_effort, -1)
2698: <> NVL(l_new_parent_info.actual_effort, -1) );
2699:

Line 2696: <> NVL(p_planned_end_date, fnd_api.g_miss_date) )

2692: <> NVL(l_new_parent_info.actual_end_date, fnd_api.g_miss_date) )
2693: OR ( NVL(l_curr_parent_info.planned_start_date, fnd_api.g_miss_date)
2694: <> NVL(p_planned_start_date, fnd_api.g_miss_date) )
2695: OR ( NVL(l_curr_parent_info.planned_end_date, fnd_api.g_miss_date)
2696: <> NVL(p_planned_end_date, fnd_api.g_miss_date) )
2697: OR ( NVL(l_curr_parent_info.actual_effort, -1)
2698: <> NVL(l_new_parent_info.actual_effort, -1) );
2699:
2700:

Line 2712: , p_commit => fnd_api.g_false

2708:
2709: jtf_tasks_pub.update_task (
2710: p_api_version => 1.0
2711: , p_init_msg_list => p_init_msg_list
2712: , p_commit => fnd_api.g_false
2713: , x_return_status => x_return_status
2714: , x_msg_count => x_msg_count
2715: , x_msg_data => x_msg_data
2716: , p_task_id => p_parent_task_id

Line 2728: , p_enable_workflow => fnd_api.g_miss_char

2724: , p_actual_end_date => l_new_parent_info.actual_end_date
2725: , p_actual_effort => l_new_parent_info.actual_effort
2726: , p_actual_effort_uom => l_actual_effort_uom
2727: , p_task_split_flag => 'M'
2728: , p_enable_workflow => fnd_api.g_miss_char
2729: , p_abort_workflow => fnd_api.g_miss_char
2730: );
2731:
2732: IF x_return_status = fnd_api.g_ret_sts_error THEN

Line 2729: , p_abort_workflow => fnd_api.g_miss_char

2725: , p_actual_effort => l_new_parent_info.actual_effort
2726: , p_actual_effort_uom => l_actual_effort_uom
2727: , p_task_split_flag => 'M'
2728: , p_enable_workflow => fnd_api.g_miss_char
2729: , p_abort_workflow => fnd_api.g_miss_char
2730: );
2731:
2732: IF x_return_status = fnd_api.g_ret_sts_error THEN
2733: RAISE fnd_api.g_exc_error;

Line 2732: IF x_return_status = fnd_api.g_ret_sts_error THEN

2728: , p_enable_workflow => fnd_api.g_miss_char
2729: , p_abort_workflow => fnd_api.g_miss_char
2730: );
2731:
2732: IF x_return_status = fnd_api.g_ret_sts_error THEN
2733: RAISE fnd_api.g_exc_error;
2734: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2735: RAISE fnd_api.g_exc_unexpected_error;
2736: END IF;

Line 2733: RAISE fnd_api.g_exc_error;

2729: , p_abort_workflow => fnd_api.g_miss_char
2730: );
2731:
2732: IF x_return_status = fnd_api.g_ret_sts_error THEN
2733: RAISE fnd_api.g_exc_error;
2734: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2735: RAISE fnd_api.g_exc_unexpected_error;
2736: END IF;
2737: END IF;

Line 2734: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2730: );
2731:
2732: IF x_return_status = fnd_api.g_ret_sts_error THEN
2733: RAISE fnd_api.g_exc_error;
2734: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2735: RAISE fnd_api.g_exc_unexpected_error;
2736: END IF;
2737: END IF;
2738:

Line 2735: RAISE fnd_api.g_exc_unexpected_error;

2731:
2732: IF x_return_status = fnd_api.g_ret_sts_error THEN
2733: RAISE fnd_api.g_exc_error;
2734: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2735: RAISE fnd_api.g_exc_unexpected_error;
2736: END IF;
2737: END IF;
2738:
2739: -- Standard check of p_commit

Line 2740: IF fnd_api.to_boolean (p_commit) THEN

2736: END IF;
2737: END IF;
2738:
2739: -- Standard check of p_commit
2740: IF fnd_api.to_boolean (p_commit) THEN
2741: COMMIT WORK;
2742: END IF;
2743: EXCEPTION
2744: WHEN fnd_api.g_exc_error THEN

Line 2744: WHEN fnd_api.g_exc_error THEN

2740: IF fnd_api.to_boolean (p_commit) THEN
2741: COMMIT WORK;
2742: END IF;
2743: EXCEPTION
2744: WHEN fnd_api.g_exc_error THEN
2745: ROLLBACK TO csf_sync_parent_with_child;
2746: x_return_status := fnd_api.g_ret_sts_error;
2747: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2748: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2746: x_return_status := fnd_api.g_ret_sts_error;

2742: END IF;
2743: EXCEPTION
2744: WHEN fnd_api.g_exc_error THEN
2745: ROLLBACK TO csf_sync_parent_with_child;
2746: x_return_status := fnd_api.g_ret_sts_error;
2747: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2748: WHEN fnd_api.g_exc_unexpected_error THEN
2749: ROLLBACK TO csf_sync_parent_with_child;
2750: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2748: WHEN fnd_api.g_exc_unexpected_error THEN

2744: WHEN fnd_api.g_exc_error THEN
2745: ROLLBACK TO csf_sync_parent_with_child;
2746: x_return_status := fnd_api.g_ret_sts_error;
2747: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2748: WHEN fnd_api.g_exc_unexpected_error THEN
2749: ROLLBACK TO csf_sync_parent_with_child;
2750: x_return_status := fnd_api.g_ret_sts_unexp_error;
2751: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2752: WHEN OTHERS THEN

Line 2750: x_return_status := fnd_api.g_ret_sts_unexp_error;

2746: x_return_status := fnd_api.g_ret_sts_error;
2747: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2748: WHEN fnd_api.g_exc_unexpected_error THEN
2749: ROLLBACK TO csf_sync_parent_with_child;
2750: x_return_status := fnd_api.g_ret_sts_unexp_error;
2751: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2752: WHEN OTHERS THEN
2753: x_return_status := fnd_api.g_ret_sts_unexp_error;
2754: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 2753: x_return_status := fnd_api.g_ret_sts_unexp_error;

2749: ROLLBACK TO csf_sync_parent_with_child;
2750: x_return_status := fnd_api.g_ret_sts_unexp_error;
2751: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2752: WHEN OTHERS THEN
2753: x_return_status := fnd_api.g_ret_sts_unexp_error;
2754: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2755: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2756: END IF;
2757: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2797: l_child_position jtf_tasks_b.child_position%TYPE;
2798: BEGIN
2799: SAVEPOINT csf_sync_child_from_parent;
2800:
2801: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2802: RAISE fnd_api.g_exc_unexpected_error;
2803: END IF;
2804:
2805: IF fnd_api.to_boolean (p_init_msg_list) THEN

Line 2802: RAISE fnd_api.g_exc_unexpected_error;

2798: BEGIN
2799: SAVEPOINT csf_sync_child_from_parent;
2800:
2801: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2802: RAISE fnd_api.g_exc_unexpected_error;
2803: END IF;
2804:
2805: IF fnd_api.to_boolean (p_init_msg_list) THEN
2806: fnd_msg_pub.initialize;

Line 2805: IF fnd_api.to_boolean (p_init_msg_list) THEN

2801: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2802: RAISE fnd_api.g_exc_unexpected_error;
2803: END IF;
2804:
2805: IF fnd_api.to_boolean (p_init_msg_list) THEN
2806: fnd_msg_pub.initialize;
2807: END IF;
2808:
2809: x_return_status := fnd_api.g_ret_sts_success;

Line 2809: x_return_status := fnd_api.g_ret_sts_success;

2805: IF fnd_api.to_boolean (p_init_msg_list) THEN
2806: fnd_msg_pub.initialize;
2807: END IF;
2808:
2809: x_return_status := fnd_api.g_ret_sts_success;
2810:
2811: l_child_position := 'F';
2812: FOR v_child_task IN c_child_tasks LOOP
2813: IF v_child_task.next_task_id IS NULL AND v_child_task.correct_seq_num <> 1 THEN

Line 2827: , p_task_split_flag => fnd_api.g_miss_char

2823: , x_return_status => x_return_status
2824: , x_msg_count => x_msg_count
2825: , x_msg_data => x_msg_data
2826: , p_task_id => v_child_task.task_id
2827: , p_task_split_flag => fnd_api.g_miss_char
2828: , p_object_version_number => v_child_task.object_version_number
2829: , p_child_sequence_num => v_child_task.correct_seq_num
2830: , p_child_position => l_child_position
2831: , p_enable_workflow => fnd_api.g_miss_char

Line 2831: , p_enable_workflow => fnd_api.g_miss_char

2827: , p_task_split_flag => fnd_api.g_miss_char
2828: , p_object_version_number => v_child_task.object_version_number
2829: , p_child_sequence_num => v_child_task.correct_seq_num
2830: , p_child_position => l_child_position
2831: , p_enable_workflow => fnd_api.g_miss_char
2832: , p_abort_workflow => fnd_api.g_miss_char
2833: );
2834:
2835: IF x_return_status = fnd_api.g_ret_sts_error THEN

Line 2832: , p_abort_workflow => fnd_api.g_miss_char

2828: , p_object_version_number => v_child_task.object_version_number
2829: , p_child_sequence_num => v_child_task.correct_seq_num
2830: , p_child_position => l_child_position
2831: , p_enable_workflow => fnd_api.g_miss_char
2832: , p_abort_workflow => fnd_api.g_miss_char
2833: );
2834:
2835: IF x_return_status = fnd_api.g_ret_sts_error THEN
2836: RAISE fnd_api.g_exc_error;

Line 2835: IF x_return_status = fnd_api.g_ret_sts_error THEN

2831: , p_enable_workflow => fnd_api.g_miss_char
2832: , p_abort_workflow => fnd_api.g_miss_char
2833: );
2834:
2835: IF x_return_status = fnd_api.g_ret_sts_error THEN
2836: RAISE fnd_api.g_exc_error;
2837: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2838: RAISE fnd_api.g_exc_unexpected_error;
2839: END IF;

Line 2836: RAISE fnd_api.g_exc_error;

2832: , p_abort_workflow => fnd_api.g_miss_char
2833: );
2834:
2835: IF x_return_status = fnd_api.g_ret_sts_error THEN
2836: RAISE fnd_api.g_exc_error;
2837: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2838: RAISE fnd_api.g_exc_unexpected_error;
2839: END IF;
2840: END IF;

Line 2837: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2833: );
2834:
2835: IF x_return_status = fnd_api.g_ret_sts_error THEN
2836: RAISE fnd_api.g_exc_error;
2837: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2838: RAISE fnd_api.g_exc_unexpected_error;
2839: END IF;
2840: END IF;
2841:

Line 2838: RAISE fnd_api.g_exc_unexpected_error;

2834:
2835: IF x_return_status = fnd_api.g_ret_sts_error THEN
2836: RAISE fnd_api.g_exc_error;
2837: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2838: RAISE fnd_api.g_exc_unexpected_error;
2839: END IF;
2840: END IF;
2841:
2842: l_child_position := 'M';

Line 2846: IF fnd_api.to_boolean (p_commit) THEN

2842: l_child_position := 'M';
2843: END LOOP;
2844:
2845: -- Standard check of p_commit
2846: IF fnd_api.to_boolean (p_commit) THEN
2847: COMMIT WORK;
2848: END IF;
2849: EXCEPTION
2850: WHEN fnd_api.g_exc_error THEN

Line 2850: WHEN fnd_api.g_exc_error THEN

2846: IF fnd_api.to_boolean (p_commit) THEN
2847: COMMIT WORK;
2848: END IF;
2849: EXCEPTION
2850: WHEN fnd_api.g_exc_error THEN
2851: ROLLBACK TO csf_sync_child_from_parent;
2852: x_return_status := fnd_api.g_ret_sts_error;
2853: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2854: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2852: x_return_status := fnd_api.g_ret_sts_error;

2848: END IF;
2849: EXCEPTION
2850: WHEN fnd_api.g_exc_error THEN
2851: ROLLBACK TO csf_sync_child_from_parent;
2852: x_return_status := fnd_api.g_ret_sts_error;
2853: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2854: WHEN fnd_api.g_exc_unexpected_error THEN
2855: ROLLBACK TO csf_sync_child_from_parent;
2856: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2854: WHEN fnd_api.g_exc_unexpected_error THEN

2850: WHEN fnd_api.g_exc_error THEN
2851: ROLLBACK TO csf_sync_child_from_parent;
2852: x_return_status := fnd_api.g_ret_sts_error;
2853: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2854: WHEN fnd_api.g_exc_unexpected_error THEN
2855: ROLLBACK TO csf_sync_child_from_parent;
2856: x_return_status := fnd_api.g_ret_sts_unexp_error;
2857: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2858: WHEN OTHERS THEN

Line 2856: x_return_status := fnd_api.g_ret_sts_unexp_error;

2852: x_return_status := fnd_api.g_ret_sts_error;
2853: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2854: WHEN fnd_api.g_exc_unexpected_error THEN
2855: ROLLBACK TO csf_sync_child_from_parent;
2856: x_return_status := fnd_api.g_ret_sts_unexp_error;
2857: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2858: WHEN OTHERS THEN
2859: x_return_status := fnd_api.g_ret_sts_unexp_error;
2860: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 2859: x_return_status := fnd_api.g_ret_sts_unexp_error;

2855: ROLLBACK TO csf_sync_child_from_parent;
2856: x_return_status := fnd_api.g_ret_sts_unexp_error;
2857: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
2858: WHEN OTHERS THEN
2859: x_return_status := fnd_api.g_ret_sts_unexp_error;
2860: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2861: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2862: END IF;
2863: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

2927: l_assignment_status_id NUMBER;
2928: BEGIN
2929: SAVEPOINT csf_assign_task;
2930:
2931: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2932: RAISE fnd_api.g_exc_unexpected_error;
2933: END IF;
2934:
2935: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 2932: RAISE fnd_api.g_exc_unexpected_error;

2928: BEGIN
2929: SAVEPOINT csf_assign_task;
2930:
2931: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2932: RAISE fnd_api.g_exc_unexpected_error;
2933: END IF;
2934:
2935: IF fnd_api.to_boolean(p_init_msg_list) THEN
2936: fnd_msg_pub.initialize;

Line 2935: IF fnd_api.to_boolean(p_init_msg_list) THEN

2931: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2932: RAISE fnd_api.g_exc_unexpected_error;
2933: END IF;
2934:
2935: IF fnd_api.to_boolean(p_init_msg_list) THEN
2936: fnd_msg_pub.initialize;
2937: END IF;
2938:
2939: x_return_status := fnd_api.g_ret_sts_success;

Line 2939: x_return_status := fnd_api.g_ret_sts_success;

2935: IF fnd_api.to_boolean(p_init_msg_list) THEN
2936: fnd_msg_pub.initialize;
2937: END IF;
2938:
2939: x_return_status := fnd_api.g_ret_sts_success;
2940:
2941: -- Get the Task Information
2942: OPEN c_task_info;
2943: FETCH c_task_info INTO l_task_info;

Line 2948: RAISE fnd_api.g_exc_unexpected_error;

2944: CLOSE c_task_info;
2945:
2946: IF l_task_info.task_id IS NULL THEN
2947: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'NO_DATA_FOUND JTF_TASKS_B.TASK_ID = ' || p_task_id);
2948: RAISE fnd_api.g_exc_unexpected_error;
2949: END IF;
2950:
2951: -- If the Task is already Scheduled, then the Task Should be treated to be
2952: -- in Unscheduled Task Status as the task should have been unscheduled

Line 2985: , p_validation_level => fnd_api.g_valid_level_none

2981: END IF;
2982:
2983: csf_task_assignments_pub.update_task_assignment (
2984: p_api_version => 1.0
2985: , p_validation_level => fnd_api.g_valid_level_none
2986: , x_return_status => x_return_status
2987: , x_msg_count => x_msg_count
2988: , x_msg_data => x_msg_data
2989: , p_task_assignment_id => p_old_task_assignment_id

Line 2996: , p_update_task => fnd_api.g_false

2992: , p_object_capacity_id => p_object_capacity_id
2993: , p_sched_travel_distance => p_sched_travel_distance
2994: , p_sched_travel_duration => p_sched_travel_duration
2995: , p_sched_travel_duration_uom => p_sched_travel_duration_uom
2996: , p_update_task => fnd_api.g_false
2997: , x_task_object_version_number => l_task_info.object_version_number
2998: , x_task_status_id => l_task_info.task_status_id
2999: );
3000: IF x_return_status = fnd_api.g_ret_sts_error THEN

Line 3000: IF x_return_status = fnd_api.g_ret_sts_error THEN

2996: , p_update_task => fnd_api.g_false
2997: , x_task_object_version_number => l_task_info.object_version_number
2998: , x_task_status_id => l_task_info.task_status_id
2999: );
3000: IF x_return_status = fnd_api.g_ret_sts_error THEN
3001: RAISE fnd_api.g_exc_error;
3002: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3003: RAISE fnd_api.g_exc_unexpected_error;
3004: END IF;

Line 3001: RAISE fnd_api.g_exc_error;

2997: , x_task_object_version_number => l_task_info.object_version_number
2998: , x_task_status_id => l_task_info.task_status_id
2999: );
3000: IF x_return_status = fnd_api.g_ret_sts_error THEN
3001: RAISE fnd_api.g_exc_error;
3002: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3003: RAISE fnd_api.g_exc_unexpected_error;
3004: END IF;
3005: END IF;

Line 3002: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2998: , x_task_status_id => l_task_info.task_status_id
2999: );
3000: IF x_return_status = fnd_api.g_ret_sts_error THEN
3001: RAISE fnd_api.g_exc_error;
3002: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3003: RAISE fnd_api.g_exc_unexpected_error;
3004: END IF;
3005: END IF;
3006:

Line 3003: RAISE fnd_api.g_exc_unexpected_error;

2999: );
3000: IF x_return_status = fnd_api.g_ret_sts_error THEN
3001: RAISE fnd_api.g_exc_error;
3002: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3003: RAISE fnd_api.g_exc_unexpected_error;
3004: END IF;
3005: END IF;
3006:
3007: l_planned_effort := fnd_api.g_miss_num;

Line 3007: l_planned_effort := fnd_api.g_miss_num;

3003: RAISE fnd_api.g_exc_unexpected_error;
3004: END IF;
3005: END IF;
3006:
3007: l_planned_effort := fnd_api.g_miss_num;
3008: l_planned_effort_uom := fnd_api.g_miss_char;
3009:
3010: IF (l_task_info.task_split_flag = 'D') THEN
3011: l_planned_effort := p_planned_effort;

Line 3008: l_planned_effort_uom := fnd_api.g_miss_char;

3004: END IF;
3005: END IF;
3006:
3007: l_planned_effort := fnd_api.g_miss_num;
3008: l_planned_effort_uom := fnd_api.g_miss_char;
3009:
3010: IF (l_task_info.task_split_flag = 'D') THEN
3011: l_planned_effort := p_planned_effort;
3012: l_planned_effort_uom := p_planned_effort_uom;

Line 3030: , p_enable_workflow => fnd_api.g_miss_char

3026: , p_planned_start_date => p_planned_start_date
3027: , p_planned_end_date => p_planned_end_date
3028: , p_planned_effort => l_planned_effort
3029: , p_planned_effort_uom => l_planned_effort_uom
3030: , p_enable_workflow => fnd_api.g_miss_char
3031: , p_abort_workflow => fnd_api.g_miss_char
3032: );
3033: IF x_return_status = fnd_api.g_ret_sts_error THEN
3034: RAISE fnd_api.g_exc_error;

Line 3031: , p_abort_workflow => fnd_api.g_miss_char

3027: , p_planned_end_date => p_planned_end_date
3028: , p_planned_effort => l_planned_effort
3029: , p_planned_effort_uom => l_planned_effort_uom
3030: , p_enable_workflow => fnd_api.g_miss_char
3031: , p_abort_workflow => fnd_api.g_miss_char
3032: );
3033: IF x_return_status = fnd_api.g_ret_sts_error THEN
3034: RAISE fnd_api.g_exc_error;
3035: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 3033: IF x_return_status = fnd_api.g_ret_sts_error THEN

3029: , p_planned_effort_uom => l_planned_effort_uom
3030: , p_enable_workflow => fnd_api.g_miss_char
3031: , p_abort_workflow => fnd_api.g_miss_char
3032: );
3033: IF x_return_status = fnd_api.g_ret_sts_error THEN
3034: RAISE fnd_api.g_exc_error;
3035: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3036: RAISE fnd_api.g_exc_unexpected_error;
3037: END IF;

Line 3034: RAISE fnd_api.g_exc_error;

3030: , p_enable_workflow => fnd_api.g_miss_char
3031: , p_abort_workflow => fnd_api.g_miss_char
3032: );
3033: IF x_return_status = fnd_api.g_ret_sts_error THEN
3034: RAISE fnd_api.g_exc_error;
3035: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3036: RAISE fnd_api.g_exc_unexpected_error;
3037: END IF;
3038:

Line 3035: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3031: , p_abort_workflow => fnd_api.g_miss_char
3032: );
3033: IF x_return_status = fnd_api.g_ret_sts_error THEN
3034: RAISE fnd_api.g_exc_error;
3035: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3036: RAISE fnd_api.g_exc_unexpected_error;
3037: END IF;
3038:
3039: -- Create the Task Assignment

Line 3036: RAISE fnd_api.g_exc_unexpected_error;

3032: );
3033: IF x_return_status = fnd_api.g_ret_sts_error THEN
3034: RAISE fnd_api.g_exc_error;
3035: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3036: RAISE fnd_api.g_exc_unexpected_error;
3037: END IF;
3038:
3039: -- Create the Task Assignment
3040: IF l_create_assignment THEN

Line 3043: , p_validation_level => fnd_api.g_valid_level_none

3039: -- Create the Task Assignment
3040: IF l_create_assignment THEN
3041: csf_task_assignments_pub.create_task_assignment(
3042: p_api_version => 1.0
3043: , p_validation_level => fnd_api.g_valid_level_none
3044: , x_return_status => x_return_status
3045: , x_msg_count => x_msg_count
3046: , x_msg_data => x_msg_data
3047: , p_task_id => p_task_id

Line 3055: , p_update_task => fnd_api.g_false

3051: , p_object_capacity_id => p_object_capacity_id
3052: , p_sched_travel_distance => p_sched_travel_distance
3053: , p_sched_travel_duration => p_sched_travel_duration
3054: , p_sched_travel_duration_uom => p_sched_travel_duration_uom
3055: , p_update_task => fnd_api.g_false
3056: , x_task_assignment_id => x_task_assignment_id
3057: , x_ta_object_version_number => x_ta_object_version_number
3058: , x_task_object_version_number => p_object_version_number
3059: , x_task_status_id => l_task_info.task_status_id

Line 3062: IF x_return_status = fnd_api.g_ret_sts_error THEN

3058: , x_task_object_version_number => p_object_version_number
3059: , x_task_status_id => l_task_info.task_status_id
3060: );
3061:
3062: IF x_return_status = fnd_api.g_ret_sts_error THEN
3063: RAISE fnd_api.g_exc_error;
3064: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3065: RAISE fnd_api.g_exc_unexpected_error;
3066: END IF;

Line 3063: RAISE fnd_api.g_exc_error;

3059: , x_task_status_id => l_task_info.task_status_id
3060: );
3061:
3062: IF x_return_status = fnd_api.g_ret_sts_error THEN
3063: RAISE fnd_api.g_exc_error;
3064: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3065: RAISE fnd_api.g_exc_unexpected_error;
3066: END IF;
3067: END IF;

Line 3064: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3060: );
3061:
3062: IF x_return_status = fnd_api.g_ret_sts_error THEN
3063: RAISE fnd_api.g_exc_error;
3064: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3065: RAISE fnd_api.g_exc_unexpected_error;
3066: END IF;
3067: END IF;
3068:

Line 3065: RAISE fnd_api.g_exc_unexpected_error;

3061:
3062: IF x_return_status = fnd_api.g_ret_sts_error THEN
3063: RAISE fnd_api.g_exc_error;
3064: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3065: RAISE fnd_api.g_exc_unexpected_error;
3066: END IF;
3067: END IF;
3068:
3069: IF fnd_api.to_boolean(p_commit) THEN

Line 3069: IF fnd_api.to_boolean(p_commit) THEN

3065: RAISE fnd_api.g_exc_unexpected_error;
3066: END IF;
3067: END IF;
3068:
3069: IF fnd_api.to_boolean(p_commit) THEN
3070: COMMIT WORK;
3071: END IF;
3072:
3073: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 3076: WHEN fnd_api.g_exc_error THEN

3072:
3073: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3074:
3075: EXCEPTION
3076: WHEN fnd_api.g_exc_error THEN
3077: ROLLBACK TO csf_assign_task;
3078: x_return_status := fnd_api.g_ret_sts_error;
3079: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3080: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3078: x_return_status := fnd_api.g_ret_sts_error;

3074:
3075: EXCEPTION
3076: WHEN fnd_api.g_exc_error THEN
3077: ROLLBACK TO csf_assign_task;
3078: x_return_status := fnd_api.g_ret_sts_error;
3079: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3080: WHEN fnd_api.g_exc_unexpected_error THEN
3081: ROLLBACK TO csf_assign_task;
3082: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3080: WHEN fnd_api.g_exc_unexpected_error THEN

3076: WHEN fnd_api.g_exc_error THEN
3077: ROLLBACK TO csf_assign_task;
3078: x_return_status := fnd_api.g_ret_sts_error;
3079: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3080: WHEN fnd_api.g_exc_unexpected_error THEN
3081: ROLLBACK TO csf_assign_task;
3082: x_return_status := fnd_api.g_ret_sts_unexp_error;
3083: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3084: WHEN OTHERS THEN

Line 3082: x_return_status := fnd_api.g_ret_sts_unexp_error;

3078: x_return_status := fnd_api.g_ret_sts_error;
3079: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3080: WHEN fnd_api.g_exc_unexpected_error THEN
3081: ROLLBACK TO csf_assign_task;
3082: x_return_status := fnd_api.g_ret_sts_unexp_error;
3083: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3084: WHEN OTHERS THEN
3085: x_return_status := fnd_api.g_ret_sts_unexp_error;
3086: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 3085: x_return_status := fnd_api.g_ret_sts_unexp_error;

3081: ROLLBACK TO csf_assign_task;
3082: x_return_status := fnd_api.g_ret_sts_unexp_error;
3083: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3084: WHEN OTHERS THEN
3085: x_return_status := fnd_api.g_ret_sts_unexp_error;
3086: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3087: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3088: END IF;
3089: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

3133: l_task_status_id NUMBER;
3134: BEGIN
3135: SAVEPOINT csf_unassign_task;
3136:
3137: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3138: RAISE fnd_api.g_exc_unexpected_error;
3139: END IF;
3140:
3141: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 3138: RAISE fnd_api.g_exc_unexpected_error;

3134: BEGIN
3135: SAVEPOINT csf_unassign_task;
3136:
3137: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3138: RAISE fnd_api.g_exc_unexpected_error;
3139: END IF;
3140:
3141: IF fnd_api.to_boolean(p_init_msg_list) THEN
3142: fnd_msg_pub.initialize;

Line 3141: IF fnd_api.to_boolean(p_init_msg_list) THEN

3137: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3138: RAISE fnd_api.g_exc_unexpected_error;
3139: END IF;
3140:
3141: IF fnd_api.to_boolean(p_init_msg_list) THEN
3142: fnd_msg_pub.initialize;
3143: END IF;
3144:
3145: x_return_status := fnd_api.g_ret_sts_success;

Line 3145: x_return_status := fnd_api.g_ret_sts_success;

3141: IF fnd_api.to_boolean(p_init_msg_list) THEN
3142: fnd_msg_pub.initialize;
3143: END IF;
3144:
3145: x_return_status := fnd_api.g_ret_sts_success;
3146:
3147: OPEN c_task_info;
3148: FETCH c_task_info INTO l_task_info;
3149: CLOSE c_task_info;

Line 3159: , p_validation_level => fnd_api.g_valid_level_none

3155: -- Queries the Task Information, there will not be any Trip Information and
3156: -- Update is avoided as Scheduler will take care of the update.
3157: csf_task_assignments_pub.update_task_assignment (
3158: p_api_version => 1.0
3159: , p_validation_level => fnd_api.g_valid_level_none
3160: , x_return_status => x_return_status
3161: , x_msg_count => x_msg_count
3162: , x_msg_data => x_msg_data
3163: , p_task_assignment_id => p_task_assignment_id

Line 3167: , p_update_task => fnd_api.g_false

3163: , p_task_assignment_id => p_task_assignment_id
3164: , p_assignment_status_id => NVL(p_assignment_status_id, g_cancelled)
3165: , p_object_version_number => p_ta_object_version_number
3166: , p_object_capacity_id => NULL
3167: , p_update_task => fnd_api.g_false
3168: , x_task_object_version_number => p_object_version_number
3169: , x_task_status_id => l_task_status_id
3170: );
3171: IF x_return_status = fnd_api.g_ret_sts_error THEN

Line 3171: IF x_return_status = fnd_api.g_ret_sts_error THEN

3167: , p_update_task => fnd_api.g_false
3168: , x_task_object_version_number => p_object_version_number
3169: , x_task_status_id => l_task_status_id
3170: );
3171: IF x_return_status = fnd_api.g_ret_sts_error THEN
3172: RAISE fnd_api.g_exc_error;
3173: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3174: RAISE fnd_api.g_exc_unexpected_error;
3175: END IF;

Line 3172: RAISE fnd_api.g_exc_error;

3168: , x_task_object_version_number => p_object_version_number
3169: , x_task_status_id => l_task_status_id
3170: );
3171: IF x_return_status = fnd_api.g_ret_sts_error THEN
3172: RAISE fnd_api.g_exc_error;
3173: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3174: RAISE fnd_api.g_exc_unexpected_error;
3175: END IF;
3176: END IF;

Line 3173: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3169: , x_task_status_id => l_task_status_id
3170: );
3171: IF x_return_status = fnd_api.g_ret_sts_error THEN
3172: RAISE fnd_api.g_exc_error;
3173: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3174: RAISE fnd_api.g_exc_unexpected_error;
3175: END IF;
3176: END IF;
3177:

Line 3174: RAISE fnd_api.g_exc_unexpected_error;

3170: );
3171: IF x_return_status = fnd_api.g_ret_sts_error THEN
3172: RAISE fnd_api.g_exc_error;
3173: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3174: RAISE fnd_api.g_exc_unexpected_error;
3175: END IF;
3176: END IF;
3177:
3178: IF NVL(p_task_status_id,-1) <> nvl(l_task_info.task_status_id,-1)

Line 3202: , p_enable_workflow => fnd_api.g_miss_char

3198: , p_object_version_number => p_object_version_number
3199: , p_task_status_id => p_task_status_id
3200: , p_scheduled_start_date => l_task_info.scheduled_start_date
3201: , p_scheduled_end_date => l_task_info.scheduled_end_date
3202: , p_enable_workflow => fnd_api.g_miss_char
3203: , p_abort_workflow => fnd_api.g_miss_char
3204: );
3205: IF x_return_status = fnd_api.g_ret_sts_error THEN
3206: RAISE fnd_api.g_exc_error;

Line 3203: , p_abort_workflow => fnd_api.g_miss_char

3199: , p_task_status_id => p_task_status_id
3200: , p_scheduled_start_date => l_task_info.scheduled_start_date
3201: , p_scheduled_end_date => l_task_info.scheduled_end_date
3202: , p_enable_workflow => fnd_api.g_miss_char
3203: , p_abort_workflow => fnd_api.g_miss_char
3204: );
3205: IF x_return_status = fnd_api.g_ret_sts_error THEN
3206: RAISE fnd_api.g_exc_error;
3207: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 3205: IF x_return_status = fnd_api.g_ret_sts_error THEN

3201: , p_scheduled_end_date => l_task_info.scheduled_end_date
3202: , p_enable_workflow => fnd_api.g_miss_char
3203: , p_abort_workflow => fnd_api.g_miss_char
3204: );
3205: IF x_return_status = fnd_api.g_ret_sts_error THEN
3206: RAISE fnd_api.g_exc_error;
3207: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3208: RAISE fnd_api.g_exc_unexpected_error;
3209: END IF;

Line 3206: RAISE fnd_api.g_exc_error;

3202: , p_enable_workflow => fnd_api.g_miss_char
3203: , p_abort_workflow => fnd_api.g_miss_char
3204: );
3205: IF x_return_status = fnd_api.g_ret_sts_error THEN
3206: RAISE fnd_api.g_exc_error;
3207: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3208: RAISE fnd_api.g_exc_unexpected_error;
3209: END IF;
3210: END IF;

Line 3207: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3203: , p_abort_workflow => fnd_api.g_miss_char
3204: );
3205: IF x_return_status = fnd_api.g_ret_sts_error THEN
3206: RAISE fnd_api.g_exc_error;
3207: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3208: RAISE fnd_api.g_exc_unexpected_error;
3209: END IF;
3210: END IF;
3211:

Line 3208: RAISE fnd_api.g_exc_unexpected_error;

3204: );
3205: IF x_return_status = fnd_api.g_ret_sts_error THEN
3206: RAISE fnd_api.g_exc_error;
3207: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3208: RAISE fnd_api.g_exc_unexpected_error;
3209: END IF;
3210: END IF;
3211:
3212: -- if the task is a child task and is being cancelled, delete(logically) the task

Line 3229: IF x_return_status = fnd_api.g_ret_sts_error THEN

3225: , p_task_id => p_task_id
3226: , p_object_version_number => p_object_version_number
3227: );
3228:
3229: IF x_return_status = fnd_api.g_ret_sts_error THEN
3230: RAISE fnd_api.g_exc_error;
3231: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3232: RAISE fnd_api.g_exc_unexpected_error;
3233: END IF;

Line 3230: RAISE fnd_api.g_exc_error;

3226: , p_object_version_number => p_object_version_number
3227: );
3228:
3229: IF x_return_status = fnd_api.g_ret_sts_error THEN
3230: RAISE fnd_api.g_exc_error;
3231: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3232: RAISE fnd_api.g_exc_unexpected_error;
3233: END IF;
3234: END IF;

Line 3231: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3227: );
3228:
3229: IF x_return_status = fnd_api.g_ret_sts_error THEN
3230: RAISE fnd_api.g_exc_error;
3231: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3232: RAISE fnd_api.g_exc_unexpected_error;
3233: END IF;
3234: END IF;
3235: END IF;

Line 3232: RAISE fnd_api.g_exc_unexpected_error;

3228:
3229: IF x_return_status = fnd_api.g_ret_sts_error THEN
3230: RAISE fnd_api.g_exc_error;
3231: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3232: RAISE fnd_api.g_exc_unexpected_error;
3233: END IF;
3234: END IF;
3235: END IF;
3236:

Line 3237: IF fnd_api.to_boolean(p_commit) THEN

3233: END IF;
3234: END IF;
3235: END IF;
3236:
3237: IF fnd_api.to_boolean(p_commit) THEN
3238: COMMIT WORK;
3239: END IF;
3240: EXCEPTION
3241: WHEN fnd_api.g_exc_error THEN

Line 3241: WHEN fnd_api.g_exc_error THEN

3237: IF fnd_api.to_boolean(p_commit) THEN
3238: COMMIT WORK;
3239: END IF;
3240: EXCEPTION
3241: WHEN fnd_api.g_exc_error THEN
3242: ROLLBACK TO csf_unassign_task;
3243: x_return_status := fnd_api.g_ret_sts_error;
3244: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3245: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3243: x_return_status := fnd_api.g_ret_sts_error;

3239: END IF;
3240: EXCEPTION
3241: WHEN fnd_api.g_exc_error THEN
3242: ROLLBACK TO csf_unassign_task;
3243: x_return_status := fnd_api.g_ret_sts_error;
3244: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3245: WHEN fnd_api.g_exc_unexpected_error THEN
3246: ROLLBACK TO csf_unassign_task;
3247: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3245: WHEN fnd_api.g_exc_unexpected_error THEN

3241: WHEN fnd_api.g_exc_error THEN
3242: ROLLBACK TO csf_unassign_task;
3243: x_return_status := fnd_api.g_ret_sts_error;
3244: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3245: WHEN fnd_api.g_exc_unexpected_error THEN
3246: ROLLBACK TO csf_unassign_task;
3247: x_return_status := fnd_api.g_ret_sts_unexp_error;
3248: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3249: WHEN OTHERS THEN

Line 3247: x_return_status := fnd_api.g_ret_sts_unexp_error;

3243: x_return_status := fnd_api.g_ret_sts_error;
3244: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3245: WHEN fnd_api.g_exc_unexpected_error THEN
3246: ROLLBACK TO csf_unassign_task;
3247: x_return_status := fnd_api.g_ret_sts_unexp_error;
3248: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3249: WHEN OTHERS THEN
3250: x_return_status := fnd_api.g_ret_sts_unexp_error;
3251: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 3250: x_return_status := fnd_api.g_ret_sts_unexp_error;

3246: ROLLBACK TO csf_unassign_task;
3247: x_return_status := fnd_api.g_ret_sts_unexp_error;
3248: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3249: WHEN OTHERS THEN
3250: x_return_status := fnd_api.g_ret_sts_unexp_error;
3251: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3252: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3253: END IF;
3254: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

3282:
3283: BEGIN
3284: SAVEPOINT csf_update_task_and_assignment;
3285:
3286: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3287: RAISE fnd_api.g_exc_unexpected_error;
3288: END IF;
3289:
3290: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 3287: RAISE fnd_api.g_exc_unexpected_error;

3283: BEGIN
3284: SAVEPOINT csf_update_task_and_assignment;
3285:
3286: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3287: RAISE fnd_api.g_exc_unexpected_error;
3288: END IF;
3289:
3290: IF fnd_api.to_boolean(p_init_msg_list) THEN
3291: fnd_msg_pub.initialize;

Line 3290: IF fnd_api.to_boolean(p_init_msg_list) THEN

3286: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3287: RAISE fnd_api.g_exc_unexpected_error;
3288: END IF;
3289:
3290: IF fnd_api.to_boolean(p_init_msg_list) THEN
3291: fnd_msg_pub.initialize;
3292: END IF;
3293:
3294: x_return_status := fnd_api.g_ret_sts_success;

Line 3294: x_return_status := fnd_api.g_ret_sts_success;

3290: IF fnd_api.to_boolean(p_init_msg_list) THEN
3291: fnd_msg_pub.initialize;
3292: END IF;
3293:
3294: x_return_status := fnd_api.g_ret_sts_success;
3295:
3296: -- Update the Task Assignment if any columns are changing
3297: IF p_sched_travel_distance IS NOT NULL
3298: OR p_sched_travel_duration IS NOT NULL

Line 3311: , p_enable_workflow => fnd_api.g_miss_char

3307: , p_object_version_number => p_ta_object_version_number
3308: , p_sched_travel_distance => p_sched_travel_distance
3309: , p_sched_travel_duration => p_sched_travel_duration
3310: , p_sched_travel_duration_uom => p_sched_travel_duration_uom
3311: , p_enable_workflow => fnd_api.g_miss_char
3312: , p_abort_workflow => fnd_api.g_miss_char
3313: );
3314: IF x_return_status = fnd_api.g_ret_sts_error THEN
3315: RAISE fnd_api.g_exc_error;

Line 3312: , p_abort_workflow => fnd_api.g_miss_char

3308: , p_sched_travel_distance => p_sched_travel_distance
3309: , p_sched_travel_duration => p_sched_travel_duration
3310: , p_sched_travel_duration_uom => p_sched_travel_duration_uom
3311: , p_enable_workflow => fnd_api.g_miss_char
3312: , p_abort_workflow => fnd_api.g_miss_char
3313: );
3314: IF x_return_status = fnd_api.g_ret_sts_error THEN
3315: RAISE fnd_api.g_exc_error;
3316: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 3314: IF x_return_status = fnd_api.g_ret_sts_error THEN

3310: , p_sched_travel_duration_uom => p_sched_travel_duration_uom
3311: , p_enable_workflow => fnd_api.g_miss_char
3312: , p_abort_workflow => fnd_api.g_miss_char
3313: );
3314: IF x_return_status = fnd_api.g_ret_sts_error THEN
3315: RAISE fnd_api.g_exc_error;
3316: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3317: RAISE fnd_api.g_exc_unexpected_error;
3318: END IF;

Line 3315: RAISE fnd_api.g_exc_error;

3311: , p_enable_workflow => fnd_api.g_miss_char
3312: , p_abort_workflow => fnd_api.g_miss_char
3313: );
3314: IF x_return_status = fnd_api.g_ret_sts_error THEN
3315: RAISE fnd_api.g_exc_error;
3316: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3317: RAISE fnd_api.g_exc_unexpected_error;
3318: END IF;
3319: END IF;

Line 3316: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3312: , p_abort_workflow => fnd_api.g_miss_char
3313: );
3314: IF x_return_status = fnd_api.g_ret_sts_error THEN
3315: RAISE fnd_api.g_exc_error;
3316: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3317: RAISE fnd_api.g_exc_unexpected_error;
3318: END IF;
3319: END IF;
3320:

Line 3317: RAISE fnd_api.g_exc_unexpected_error;

3313: );
3314: IF x_return_status = fnd_api.g_ret_sts_error THEN
3315: RAISE fnd_api.g_exc_error;
3316: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3317: RAISE fnd_api.g_exc_unexpected_error;
3318: END IF;
3319: END IF;
3320:
3321: -- Update the Task if any columns are changing

Line 3332: , p_enable_workflow => fnd_api.g_miss_char

3328: , p_task_id => p_task_id
3329: , p_object_version_number => p_object_version_number
3330: , p_scheduled_start_date => p_scheduled_start_date
3331: , p_scheduled_end_date => p_scheduled_end_date
3332: , p_enable_workflow => fnd_api.g_miss_char
3333: , p_abort_workflow => fnd_api.g_miss_char
3334: );
3335:
3336: IF x_return_status = fnd_api.g_ret_sts_error THEN

Line 3333: , p_abort_workflow => fnd_api.g_miss_char

3329: , p_object_version_number => p_object_version_number
3330: , p_scheduled_start_date => p_scheduled_start_date
3331: , p_scheduled_end_date => p_scheduled_end_date
3332: , p_enable_workflow => fnd_api.g_miss_char
3333: , p_abort_workflow => fnd_api.g_miss_char
3334: );
3335:
3336: IF x_return_status = fnd_api.g_ret_sts_error THEN
3337: RAISE fnd_api.g_exc_error;

Line 3336: IF x_return_status = fnd_api.g_ret_sts_error THEN

3332: , p_enable_workflow => fnd_api.g_miss_char
3333: , p_abort_workflow => fnd_api.g_miss_char
3334: );
3335:
3336: IF x_return_status = fnd_api.g_ret_sts_error THEN
3337: RAISE fnd_api.g_exc_error;
3338: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3339: RAISE fnd_api.g_exc_unexpected_error;
3340: END IF;

Line 3337: RAISE fnd_api.g_exc_error;

3333: , p_abort_workflow => fnd_api.g_miss_char
3334: );
3335:
3336: IF x_return_status = fnd_api.g_ret_sts_error THEN
3337: RAISE fnd_api.g_exc_error;
3338: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3339: RAISE fnd_api.g_exc_unexpected_error;
3340: END IF;
3341: END IF;

Line 3338: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3334: );
3335:
3336: IF x_return_status = fnd_api.g_ret_sts_error THEN
3337: RAISE fnd_api.g_exc_error;
3338: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3339: RAISE fnd_api.g_exc_unexpected_error;
3340: END IF;
3341: END IF;
3342:

Line 3339: RAISE fnd_api.g_exc_unexpected_error;

3335:
3336: IF x_return_status = fnd_api.g_ret_sts_error THEN
3337: RAISE fnd_api.g_exc_error;
3338: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3339: RAISE fnd_api.g_exc_unexpected_error;
3340: END IF;
3341: END IF;
3342:
3343: IF fnd_api.to_boolean(p_commit) THEN

Line 3343: IF fnd_api.to_boolean(p_commit) THEN

3339: RAISE fnd_api.g_exc_unexpected_error;
3340: END IF;
3341: END IF;
3342:
3343: IF fnd_api.to_boolean(p_commit) THEN
3344: COMMIT WORK;
3345: END IF;
3346: EXCEPTION
3347: WHEN fnd_api.g_exc_error THEN

Line 3347: WHEN fnd_api.g_exc_error THEN

3343: IF fnd_api.to_boolean(p_commit) THEN
3344: COMMIT WORK;
3345: END IF;
3346: EXCEPTION
3347: WHEN fnd_api.g_exc_error THEN
3348: ROLLBACK TO csf_update_task_and_assignment;
3349: x_return_status := fnd_api.g_ret_sts_error;
3350: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3351: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3349: x_return_status := fnd_api.g_ret_sts_error;

3345: END IF;
3346: EXCEPTION
3347: WHEN fnd_api.g_exc_error THEN
3348: ROLLBACK TO csf_update_task_and_assignment;
3349: x_return_status := fnd_api.g_ret_sts_error;
3350: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3351: WHEN fnd_api.g_exc_unexpected_error THEN
3352: ROLLBACK TO csf_update_task_and_assignment;
3353: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3351: WHEN fnd_api.g_exc_unexpected_error THEN

3347: WHEN fnd_api.g_exc_error THEN
3348: ROLLBACK TO csf_update_task_and_assignment;
3349: x_return_status := fnd_api.g_ret_sts_error;
3350: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3351: WHEN fnd_api.g_exc_unexpected_error THEN
3352: ROLLBACK TO csf_update_task_and_assignment;
3353: x_return_status := fnd_api.g_ret_sts_unexp_error;
3354: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3355: WHEN OTHERS THEN

Line 3353: x_return_status := fnd_api.g_ret_sts_unexp_error;

3349: x_return_status := fnd_api.g_ret_sts_error;
3350: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3351: WHEN fnd_api.g_exc_unexpected_error THEN
3352: ROLLBACK TO csf_update_task_and_assignment;
3353: x_return_status := fnd_api.g_ret_sts_unexp_error;
3354: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3355: WHEN OTHERS THEN
3356: x_return_status := fnd_api.g_ret_sts_unexp_error;
3357: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 3356: x_return_status := fnd_api.g_ret_sts_unexp_error;

3352: ROLLBACK TO csf_update_task_and_assignment;
3353: x_return_status := fnd_api.g_ret_sts_unexp_error;
3354: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3355: WHEN OTHERS THEN
3356: x_return_status := fnd_api.g_ret_sts_unexp_error;
3357: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3358: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3359: END IF;
3360: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

3410: l_task_split_flag VARCHAR2(1);
3411: BEGIN
3412: SAVEPOINT update_task_longer_than_shift;
3413:
3414: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3415: RAISE fnd_api.g_exc_unexpected_error;
3416: END IF;
3417:
3418: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 3415: RAISE fnd_api.g_exc_unexpected_error;

3411: BEGIN
3412: SAVEPOINT update_task_longer_than_shift;
3413:
3414: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3415: RAISE fnd_api.g_exc_unexpected_error;
3416: END IF;
3417:
3418: IF fnd_api.to_boolean(p_init_msg_list) THEN
3419: fnd_msg_pub.initialize;

Line 3418: IF fnd_api.to_boolean(p_init_msg_list) THEN

3414: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3415: RAISE fnd_api.g_exc_unexpected_error;
3416: END IF;
3417:
3418: IF fnd_api.to_boolean(p_init_msg_list) THEN
3419: fnd_msg_pub.initialize;
3420: END IF;
3421:
3422: x_return_status := fnd_api.g_ret_sts_success;

Line 3422: x_return_status := fnd_api.g_ret_sts_success;

3418: IF fnd_api.to_boolean(p_init_msg_list) THEN
3419: fnd_msg_pub.initialize;
3420: END IF;
3421:
3422: x_return_status := fnd_api.g_ret_sts_success;
3423:
3424: -- Get the Task Information
3425: OPEN c_parent_task_info;
3426: FETCH c_parent_task_info INTO l_parent_task_info;

Line 3431: RAISE fnd_api.g_exc_unexpected_error;

3427: CLOSE c_parent_task_info;
3428:
3429: IF l_parent_task_info.task_id IS NULL THEN
3430: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'NO_DATA_FOUND JTF_TASKS_B.TASK_ID = ' || p_task_id);
3431: RAISE fnd_api.g_exc_unexpected_error;
3432: END IF;
3433:
3434: -- Find out whether the new Task Status is valid.
3435: IF p_task_status_id <> fnd_api.g_miss_num THEN

Line 3435: IF p_task_status_id <> fnd_api.g_miss_num THEN

3431: RAISE fnd_api.g_exc_unexpected_error;
3432: END IF;
3433:
3434: -- Find out whether the new Task Status is valid.
3435: IF p_task_status_id <> fnd_api.g_miss_num THEN
3436: validate_status_change(l_parent_task_info.task_status_id, p_task_status_id);
3437: END IF;
3438:
3439: IF p_action = g_action_normal_to_parent THEN

Line 3443: , p_init_msg_list => fnd_api.g_false

3439: IF p_action = g_action_normal_to_parent THEN
3440: -- Correct the Parent Task Information based on current Child Tasks
3441: sync_parent_with_child(
3442: p_api_version => 1.0
3443: , p_init_msg_list => fnd_api.g_false
3444: , p_commit => fnd_api.g_false
3445: , x_return_status => x_return_status
3446: , x_msg_count => x_msg_count
3447: , x_msg_data => x_msg_data

Line 3444: , p_commit => fnd_api.g_false

3440: -- Correct the Parent Task Information based on current Child Tasks
3441: sync_parent_with_child(
3442: p_api_version => 1.0
3443: , p_init_msg_list => fnd_api.g_false
3444: , p_commit => fnd_api.g_false
3445: , x_return_status => x_return_status
3446: , x_msg_count => x_msg_count
3447: , x_msg_data => x_msg_data
3448: , p_parent_task_id => p_task_id

Line 3453: IF x_return_status = fnd_api.g_ret_sts_error THEN

3449: , p_parent_version_number => p_object_version_number
3450: , p_planned_start_date => p_planned_start_date
3451: , p_planned_end_date => p_planned_end_date
3452: );
3453: IF x_return_status = fnd_api.g_ret_sts_error THEN
3454: RAISE fnd_api.g_exc_error;
3455: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3456: RAISE fnd_api.g_exc_unexpected_error;
3457: END IF;

Line 3454: RAISE fnd_api.g_exc_error;

3450: , p_planned_start_date => p_planned_start_date
3451: , p_planned_end_date => p_planned_end_date
3452: );
3453: IF x_return_status = fnd_api.g_ret_sts_error THEN
3454: RAISE fnd_api.g_exc_error;
3455: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3456: RAISE fnd_api.g_exc_unexpected_error;
3457: END IF;
3458:

Line 3455: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3451: , p_planned_end_date => p_planned_end_date
3452: );
3453: IF x_return_status = fnd_api.g_ret_sts_error THEN
3454: RAISE fnd_api.g_exc_error;
3455: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3456: RAISE fnd_api.g_exc_unexpected_error;
3457: END IF;
3458:
3459: -- Correct the Child Task's Information

Line 3456: RAISE fnd_api.g_exc_unexpected_error;

3452: );
3453: IF x_return_status = fnd_api.g_ret_sts_error THEN
3454: RAISE fnd_api.g_exc_error;
3455: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3456: RAISE fnd_api.g_exc_unexpected_error;
3457: END IF;
3458:
3459: -- Correct the Child Task's Information
3460: sync_child_from_parent(

Line 3462: , p_init_msg_list => fnd_api.g_false

3458:
3459: -- Correct the Child Task's Information
3460: sync_child_from_parent(
3461: p_api_version => 1.0
3462: , p_init_msg_list => fnd_api.g_false
3463: , p_commit => fnd_api.g_false
3464: , x_return_status => x_return_status
3465: , x_msg_count => x_msg_count
3466: , x_msg_data => x_msg_data

Line 3463: , p_commit => fnd_api.g_false

3459: -- Correct the Child Task's Information
3460: sync_child_from_parent(
3461: p_api_version => 1.0
3462: , p_init_msg_list => fnd_api.g_false
3463: , p_commit => fnd_api.g_false
3464: , x_return_status => x_return_status
3465: , x_msg_count => x_msg_count
3466: , x_msg_data => x_msg_data
3467: , p_parent_task_id => p_task_id

Line 3469: IF x_return_status = fnd_api.g_ret_sts_error THEN

3465: , x_msg_count => x_msg_count
3466: , x_msg_data => x_msg_data
3467: , p_parent_task_id => p_task_id
3468: );
3469: IF x_return_status = fnd_api.g_ret_sts_error THEN
3470: RAISE fnd_api.g_exc_error;
3471: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3472: RAISE fnd_api.g_exc_unexpected_error;
3473: END IF;

Line 3470: RAISE fnd_api.g_exc_error;

3466: , x_msg_data => x_msg_data
3467: , p_parent_task_id => p_task_id
3468: );
3469: IF x_return_status = fnd_api.g_ret_sts_error THEN
3470: RAISE fnd_api.g_exc_error;
3471: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3472: RAISE fnd_api.g_exc_unexpected_error;
3473: END IF;
3474: ELSIF p_action = g_action_parent_to_normal THEN

Line 3471: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3467: , p_parent_task_id => p_task_id
3468: );
3469: IF x_return_status = fnd_api.g_ret_sts_error THEN
3470: RAISE fnd_api.g_exc_error;
3471: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3472: RAISE fnd_api.g_exc_unexpected_error;
3473: END IF;
3474: ELSIF p_action = g_action_parent_to_normal THEN
3475: jtf_tasks_pub.update_task(

Line 3472: RAISE fnd_api.g_exc_unexpected_error;

3468: );
3469: IF x_return_status = fnd_api.g_ret_sts_error THEN
3470: RAISE fnd_api.g_exc_error;
3471: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3472: RAISE fnd_api.g_exc_unexpected_error;
3473: END IF;
3474: ELSIF p_action = g_action_parent_to_normal THEN
3475: jtf_tasks_pub.update_task(
3476: p_api_version => 1.0

Line 3490: , p_enable_workflow => fnd_api.g_miss_char

3486: , p_actual_start_date => NULL
3487: , p_actual_end_date => NULL
3488: , p_actual_effort => NULL
3489: , p_actual_effort_uom => NULL
3490: , p_enable_workflow => fnd_api.g_miss_char
3491: , p_abort_workflow => fnd_api.g_miss_char
3492: );
3493:
3494: IF x_return_status = fnd_api.g_ret_sts_error THEN

Line 3491: , p_abort_workflow => fnd_api.g_miss_char

3487: , p_actual_end_date => NULL
3488: , p_actual_effort => NULL
3489: , p_actual_effort_uom => NULL
3490: , p_enable_workflow => fnd_api.g_miss_char
3491: , p_abort_workflow => fnd_api.g_miss_char
3492: );
3493:
3494: IF x_return_status = fnd_api.g_ret_sts_error THEN
3495: RAISE fnd_api.g_exc_error;

Line 3494: IF x_return_status = fnd_api.g_ret_sts_error THEN

3490: , p_enable_workflow => fnd_api.g_miss_char
3491: , p_abort_workflow => fnd_api.g_miss_char
3492: );
3493:
3494: IF x_return_status = fnd_api.g_ret_sts_error THEN
3495: RAISE fnd_api.g_exc_error;
3496: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3497: RAISE fnd_api.g_exc_unexpected_error;
3498: END IF;

Line 3495: RAISE fnd_api.g_exc_error;

3491: , p_abort_workflow => fnd_api.g_miss_char
3492: );
3493:
3494: IF x_return_status = fnd_api.g_ret_sts_error THEN
3495: RAISE fnd_api.g_exc_error;
3496: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3497: RAISE fnd_api.g_exc_unexpected_error;
3498: END IF;
3499:

Line 3496: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3492: );
3493:
3494: IF x_return_status = fnd_api.g_ret_sts_error THEN
3495: RAISE fnd_api.g_exc_error;
3496: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3497: RAISE fnd_api.g_exc_unexpected_error;
3498: END IF;
3499:
3500: -- cancel all children if parent is changed back to normal.

Line 3497: RAISE fnd_api.g_exc_unexpected_error;

3493:
3494: IF x_return_status = fnd_api.g_ret_sts_error THEN
3495: RAISE fnd_api.g_exc_error;
3496: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3497: RAISE fnd_api.g_exc_unexpected_error;
3498: END IF;
3499:
3500: -- cancel all children if parent is changed back to normal.
3501: FOR child_task IN c_child_tasks LOOP

Line 3504: , p_init_msg_list => fnd_api.g_false

3500: -- cancel all children if parent is changed back to normal.
3501: FOR child_task IN c_child_tasks LOOP
3502: unassign_task(
3503: p_api_version => 1.0
3504: , p_init_msg_list => fnd_api.g_false
3505: , p_commit => fnd_api.g_false
3506: , x_return_status => x_return_status
3507: , x_msg_count => x_msg_count
3508: , x_msg_data => x_msg_data

Line 3505: , p_commit => fnd_api.g_false

3501: FOR child_task IN c_child_tasks LOOP
3502: unassign_task(
3503: p_api_version => 1.0
3504: , p_init_msg_list => fnd_api.g_false
3505: , p_commit => fnd_api.g_false
3506: , x_return_status => x_return_status
3507: , x_msg_count => x_msg_count
3508: , x_msg_data => x_msg_data
3509: , p_task_id => child_task.task_id

Line 3516: IF x_return_status = fnd_api.g_ret_sts_error THEN

3512: , p_task_assignment_id => child_task.task_assignment_id
3513: , p_ta_object_version_number => child_task.task_assignment_ovn
3514: , p_assignment_status_id => g_cancelled
3515: );
3516: IF x_return_status = fnd_api.g_ret_sts_error THEN
3517: RAISE fnd_api.g_exc_error;
3518: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3519: RAISE fnd_api.g_exc_unexpected_error;
3520: END IF;

Line 3517: RAISE fnd_api.g_exc_error;

3513: , p_ta_object_version_number => child_task.task_assignment_ovn
3514: , p_assignment_status_id => g_cancelled
3515: );
3516: IF x_return_status = fnd_api.g_ret_sts_error THEN
3517: RAISE fnd_api.g_exc_error;
3518: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3519: RAISE fnd_api.g_exc_unexpected_error;
3520: END IF;
3521: END LOOP;

Line 3518: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3514: , p_assignment_status_id => g_cancelled
3515: );
3516: IF x_return_status = fnd_api.g_ret_sts_error THEN
3517: RAISE fnd_api.g_exc_error;
3518: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3519: RAISE fnd_api.g_exc_unexpected_error;
3520: END IF;
3521: END LOOP;
3522: END IF;

Line 3519: RAISE fnd_api.g_exc_unexpected_error;

3515: );
3516: IF x_return_status = fnd_api.g_ret_sts_error THEN
3517: RAISE fnd_api.g_exc_error;
3518: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3519: RAISE fnd_api.g_exc_unexpected_error;
3520: END IF;
3521: END LOOP;
3522: END IF;
3523:

Line 3524: IF fnd_api.to_boolean(p_commit) THEN

3520: END IF;
3521: END LOOP;
3522: END IF;
3523:
3524: IF fnd_api.to_boolean(p_commit) THEN
3525: COMMIT WORK;
3526: END IF;
3527: EXCEPTION
3528: WHEN fnd_api.g_exc_error THEN

Line 3528: WHEN fnd_api.g_exc_error THEN

3524: IF fnd_api.to_boolean(p_commit) THEN
3525: COMMIT WORK;
3526: END IF;
3527: EXCEPTION
3528: WHEN fnd_api.g_exc_error THEN
3529: ROLLBACK TO update_task_longer_than_shift;
3530: x_return_status := fnd_api.g_ret_sts_error;
3531: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3532: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3530: x_return_status := fnd_api.g_ret_sts_error;

3526: END IF;
3527: EXCEPTION
3528: WHEN fnd_api.g_exc_error THEN
3529: ROLLBACK TO update_task_longer_than_shift;
3530: x_return_status := fnd_api.g_ret_sts_error;
3531: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3532: WHEN fnd_api.g_exc_unexpected_error THEN
3533: ROLLBACK TO update_task_longer_than_shift;
3534: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3532: WHEN fnd_api.g_exc_unexpected_error THEN

3528: WHEN fnd_api.g_exc_error THEN
3529: ROLLBACK TO update_task_longer_than_shift;
3530: x_return_status := fnd_api.g_ret_sts_error;
3531: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3532: WHEN fnd_api.g_exc_unexpected_error THEN
3533: ROLLBACK TO update_task_longer_than_shift;
3534: x_return_status := fnd_api.g_ret_sts_unexp_error;
3535: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3536: WHEN OTHERS THEN

Line 3534: x_return_status := fnd_api.g_ret_sts_unexp_error;

3530: x_return_status := fnd_api.g_ret_sts_error;
3531: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3532: WHEN fnd_api.g_exc_unexpected_error THEN
3533: ROLLBACK TO update_task_longer_than_shift;
3534: x_return_status := fnd_api.g_ret_sts_unexp_error;
3535: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3536: WHEN OTHERS THEN
3537: x_return_status := fnd_api.g_ret_sts_unexp_error;
3538: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 3537: x_return_status := fnd_api.g_ret_sts_unexp_error;

3533: ROLLBACK TO update_task_longer_than_shift;
3534: x_return_status := fnd_api.g_ret_sts_unexp_error;
3535: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3536: WHEN OTHERS THEN
3537: x_return_status := fnd_api.g_ret_sts_unexp_error;
3538: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3539: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3540: END IF;
3541: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

3595: l_parent_task_info c_parent_task_info%ROWTYPE;
3596: BEGIN
3597: SAVEPOINT csf_create_child_task;
3598:
3599: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3600: RAISE fnd_api.g_exc_unexpected_error;
3601: END IF;
3602:
3603: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 3600: RAISE fnd_api.g_exc_unexpected_error;

3596: BEGIN
3597: SAVEPOINT csf_create_child_task;
3598:
3599: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3600: RAISE fnd_api.g_exc_unexpected_error;
3601: END IF;
3602:
3603: IF fnd_api.to_boolean(p_init_msg_list) THEN
3604: fnd_msg_pub.initialize;

Line 3603: IF fnd_api.to_boolean(p_init_msg_list) THEN

3599: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3600: RAISE fnd_api.g_exc_unexpected_error;
3601: END IF;
3602:
3603: IF fnd_api.to_boolean(p_init_msg_list) THEN
3604: fnd_msg_pub.initialize;
3605: END IF;
3606:
3607: x_return_status := fnd_api.g_ret_sts_success;

Line 3607: x_return_status := fnd_api.g_ret_sts_success;

3603: IF fnd_api.to_boolean(p_init_msg_list) THEN
3604: fnd_msg_pub.initialize;
3605: END IF;
3606:
3607: x_return_status := fnd_api.g_ret_sts_success;
3608:
3609: -- Get the Parent Task Information
3610: OPEN c_parent_task_info;
3611: FETCH c_parent_task_info INTO l_parent_task_info;

Line 3615: RAISE fnd_api.g_exc_unexpected_error;

3611: FETCH c_parent_task_info INTO l_parent_task_info;
3612: IF c_parent_task_info%NOTFOUND THEN
3613: CLOSE c_parent_task_info;
3614: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name, 'NO_DATA_FOUND JTF_TASKS_B.TASK_ID = ' || p_parent_task_id);
3615: RAISE fnd_api.g_exc_unexpected_error;
3616: END IF;
3617: CLOSE c_parent_task_info;
3618:
3619: -- Create the Child Task using Parent Task Information

Line 3623: , p_init_msg_list => fnd_api.g_false

3619: -- Create the Child Task using Parent Task Information
3620: -- (Set Zero Length Planned Window at Scheduled Start, Bound Mode code in BTS)
3621: jtf_tasks_pub.create_task(
3622: p_api_version => 1.0
3623: , p_init_msg_list => fnd_api.g_false
3624: , p_commit => fnd_api.g_false
3625: , x_return_status => x_return_status
3626: , x_msg_count => x_msg_count
3627: , x_msg_data => x_msg_data

Line 3624: , p_commit => fnd_api.g_false

3620: -- (Set Zero Length Planned Window at Scheduled Start, Bound Mode code in BTS)
3621: jtf_tasks_pub.create_task(
3622: p_api_version => 1.0
3623: , p_init_msg_list => fnd_api.g_false
3624: , p_commit => fnd_api.g_false
3625: , x_return_status => x_return_status
3626: , x_msg_count => x_msg_count
3627: , x_msg_data => x_msg_data
3628: , p_task_name => l_parent_task_info.task_name

Line 3657: IF x_return_status = fnd_api.g_ret_sts_error THEN

3653: , p_child_position => NVL(p_child_position, 'N')
3654: , p_child_sequence_num => p_child_sequence_num
3655: , x_task_id => x_task_id
3656: );
3657: IF x_return_status = fnd_api.g_ret_sts_error THEN
3658: RAISE fnd_api.g_exc_error;
3659: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3660: RAISE fnd_api.g_exc_unexpected_error;
3661: END IF;

Line 3658: RAISE fnd_api.g_exc_error;

3654: , p_child_sequence_num => p_child_sequence_num
3655: , x_task_id => x_task_id
3656: );
3657: IF x_return_status = fnd_api.g_ret_sts_error THEN
3658: RAISE fnd_api.g_exc_error;
3659: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3660: RAISE fnd_api.g_exc_unexpected_error;
3661: END IF;
3662: x_object_version_number := 1;

Line 3659: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3655: , x_task_id => x_task_id
3656: );
3657: IF x_return_status = fnd_api.g_ret_sts_error THEN
3658: RAISE fnd_api.g_exc_error;
3659: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3660: RAISE fnd_api.g_exc_unexpected_error;
3661: END IF;
3662: x_object_version_number := 1;
3663:

Line 3660: RAISE fnd_api.g_exc_unexpected_error;

3656: );
3657: IF x_return_status = fnd_api.g_ret_sts_error THEN
3658: RAISE fnd_api.g_exc_error;
3659: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3660: RAISE fnd_api.g_exc_unexpected_error;
3661: END IF;
3662: x_object_version_number := 1;
3663:
3664: -- Copy Task Confirmation Values.

Line 3672: , p_init_msg_list => fnd_api.g_false

3668: -- Counter as ZERO. Thus there is no need for another uncessary update.
3669: ELSIF l_parent_task_info.task_confirmation_status = 'R' THEN
3670: jtf_task_confirmation_pub.set_confirmation_required(
3671: p_api_version => 1.0
3672: , p_init_msg_list => fnd_api.g_false
3673: , p_commit => fnd_api.g_false
3674: , x_return_status => x_return_status
3675: , x_msg_count => x_msg_count
3676: , x_msg_data => x_msg_data

Line 3673: , p_commit => fnd_api.g_false

3669: ELSIF l_parent_task_info.task_confirmation_status = 'R' THEN
3670: jtf_task_confirmation_pub.set_confirmation_required(
3671: p_api_version => 1.0
3672: , p_init_msg_list => fnd_api.g_false
3673: , p_commit => fnd_api.g_false
3674: , x_return_status => x_return_status
3675: , x_msg_count => x_msg_count
3676: , x_msg_data => x_msg_data
3677: , p_task_id => x_task_id

Line 3680: IF x_return_status = fnd_api.g_ret_sts_error THEN

3676: , x_msg_data => x_msg_data
3677: , p_task_id => x_task_id
3678: , p_object_version_number => x_object_version_number
3679: );
3680: IF x_return_status = fnd_api.g_ret_sts_error THEN
3681: RAISE fnd_api.g_exc_error;
3682: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3683: RAISE fnd_api.g_exc_unexpected_error;
3684: END IF;

Line 3681: RAISE fnd_api.g_exc_error;

3677: , p_task_id => x_task_id
3678: , p_object_version_number => x_object_version_number
3679: );
3680: IF x_return_status = fnd_api.g_ret_sts_error THEN
3681: RAISE fnd_api.g_exc_error;
3682: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3683: RAISE fnd_api.g_exc_unexpected_error;
3684: END IF;
3685: ELSIF l_parent_task_info.task_confirmation_status = 'C' THEN

Line 3682: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3678: , p_object_version_number => x_object_version_number
3679: );
3680: IF x_return_status = fnd_api.g_ret_sts_error THEN
3681: RAISE fnd_api.g_exc_error;
3682: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3683: RAISE fnd_api.g_exc_unexpected_error;
3684: END IF;
3685: ELSIF l_parent_task_info.task_confirmation_status = 'C' THEN
3686: jtf_task_confirmation_pub.set_confirmation_confirmed(

Line 3683: RAISE fnd_api.g_exc_unexpected_error;

3679: );
3680: IF x_return_status = fnd_api.g_ret_sts_error THEN
3681: RAISE fnd_api.g_exc_error;
3682: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3683: RAISE fnd_api.g_exc_unexpected_error;
3684: END IF;
3685: ELSIF l_parent_task_info.task_confirmation_status = 'C' THEN
3686: jtf_task_confirmation_pub.set_confirmation_confirmed(
3687: p_api_version => 1.0

Line 3688: , p_init_msg_list => fnd_api.g_false

3684: END IF;
3685: ELSIF l_parent_task_info.task_confirmation_status = 'C' THEN
3686: jtf_task_confirmation_pub.set_confirmation_confirmed(
3687: p_api_version => 1.0
3688: , p_init_msg_list => fnd_api.g_false
3689: , p_commit => fnd_api.g_false
3690: , x_return_status => x_return_status
3691: , x_msg_count => x_msg_count
3692: , x_msg_data => x_msg_data

Line 3689: , p_commit => fnd_api.g_false

3685: ELSIF l_parent_task_info.task_confirmation_status = 'C' THEN
3686: jtf_task_confirmation_pub.set_confirmation_confirmed(
3687: p_api_version => 1.0
3688: , p_init_msg_list => fnd_api.g_false
3689: , p_commit => fnd_api.g_false
3690: , x_return_status => x_return_status
3691: , x_msg_count => x_msg_count
3692: , x_msg_data => x_msg_data
3693: , p_task_id => x_task_id

Line 3696: IF x_return_status = fnd_api.g_ret_sts_error THEN

3692: , x_msg_data => x_msg_data
3693: , p_task_id => x_task_id
3694: , p_object_version_number => x_object_version_number
3695: );
3696: IF x_return_status = fnd_api.g_ret_sts_error THEN
3697: RAISE fnd_api.g_exc_error;
3698: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3699: RAISE fnd_api.g_exc_unexpected_error;
3700: END IF;

Line 3697: RAISE fnd_api.g_exc_error;

3693: , p_task_id => x_task_id
3694: , p_object_version_number => x_object_version_number
3695: );
3696: IF x_return_status = fnd_api.g_ret_sts_error THEN
3697: RAISE fnd_api.g_exc_error;
3698: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3699: RAISE fnd_api.g_exc_unexpected_error;
3700: END IF;
3701: IF l_parent_task_info.task_confirmation_counter > 0 THEN

Line 3698: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3694: , p_object_version_number => x_object_version_number
3695: );
3696: IF x_return_status = fnd_api.g_ret_sts_error THEN
3697: RAISE fnd_api.g_exc_error;
3698: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3699: RAISE fnd_api.g_exc_unexpected_error;
3700: END IF;
3701: IF l_parent_task_info.task_confirmation_counter > 0 THEN
3702: -- This is one horrible way of incrementing the counter. JTF has not given

Line 3699: RAISE fnd_api.g_exc_unexpected_error;

3695: );
3696: IF x_return_status = fnd_api.g_ret_sts_error THEN
3697: RAISE fnd_api.g_exc_error;
3698: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3699: RAISE fnd_api.g_exc_unexpected_error;
3700: END IF;
3701: IF l_parent_task_info.task_confirmation_counter > 0 THEN
3702: -- This is one horrible way of incrementing the counter. JTF has not given
3703: -- a API to set it directly. This way will increase the Object Version

Line 3708: , p_init_msg_list => fnd_api.g_false

3704: -- Number for each increase..
3705: FOR k IN 1 .. l_parent_task_info.task_confirmation_counter LOOP
3706: jtf_task_confirmation_pub.increase_counter(
3707: p_api_version => 1.0
3708: , p_init_msg_list => fnd_api.g_false
3709: , p_commit => fnd_api.g_false
3710: , x_return_status => x_return_status
3711: , x_msg_count => x_msg_count
3712: , x_msg_data => x_msg_data

Line 3709: , p_commit => fnd_api.g_false

3705: FOR k IN 1 .. l_parent_task_info.task_confirmation_counter LOOP
3706: jtf_task_confirmation_pub.increase_counter(
3707: p_api_version => 1.0
3708: , p_init_msg_list => fnd_api.g_false
3709: , p_commit => fnd_api.g_false
3710: , x_return_status => x_return_status
3711: , x_msg_count => x_msg_count
3712: , x_msg_data => x_msg_data
3713: , p_task_id => x_task_id

Line 3716: IF x_return_status = fnd_api.g_ret_sts_error THEN

3712: , x_msg_data => x_msg_data
3713: , p_task_id => x_task_id
3714: , p_object_version_number => x_object_version_number
3715: );
3716: IF x_return_status = fnd_api.g_ret_sts_error THEN
3717: RAISE fnd_api.g_exc_error;
3718: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3719: RAISE fnd_api.g_exc_unexpected_error;
3720: END IF;

Line 3717: RAISE fnd_api.g_exc_error;

3713: , p_task_id => x_task_id
3714: , p_object_version_number => x_object_version_number
3715: );
3716: IF x_return_status = fnd_api.g_ret_sts_error THEN
3717: RAISE fnd_api.g_exc_error;
3718: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3719: RAISE fnd_api.g_exc_unexpected_error;
3720: END IF;
3721: END LOOP;

Line 3718: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3714: , p_object_version_number => x_object_version_number
3715: );
3716: IF x_return_status = fnd_api.g_ret_sts_error THEN
3717: RAISE fnd_api.g_exc_error;
3718: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3719: RAISE fnd_api.g_exc_unexpected_error;
3720: END IF;
3721: END LOOP;
3722: END IF;

Line 3719: RAISE fnd_api.g_exc_unexpected_error;

3715: );
3716: IF x_return_status = fnd_api.g_ret_sts_error THEN
3717: RAISE fnd_api.g_exc_error;
3718: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3719: RAISE fnd_api.g_exc_unexpected_error;
3720: END IF;
3721: END LOOP;
3722: END IF;
3723: END IF;

Line 3745: IF x_return_status = fnd_api.g_ret_sts_error THEN

3741: , p_free_busy_type => NULL
3742: , x_task_assignment_id => x_task_assignment_id
3743: );
3744:
3745: IF x_return_status = fnd_api.g_ret_sts_error THEN
3746: RAISE fnd_api.g_exc_error;
3747: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3748: RAISE fnd_api.g_exc_unexpected_error;
3749: END IF;

Line 3746: RAISE fnd_api.g_exc_error;

3742: , x_task_assignment_id => x_task_assignment_id
3743: );
3744:
3745: IF x_return_status = fnd_api.g_ret_sts_error THEN
3746: RAISE fnd_api.g_exc_error;
3747: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3748: RAISE fnd_api.g_exc_unexpected_error;
3749: END IF;
3750:

Line 3747: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3743: );
3744:
3745: IF x_return_status = fnd_api.g_ret_sts_error THEN
3746: RAISE fnd_api.g_exc_error;
3747: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3748: RAISE fnd_api.g_exc_unexpected_error;
3749: END IF;
3750:
3751: IF fnd_api.to_boolean(p_commit) THEN

Line 3748: RAISE fnd_api.g_exc_unexpected_error;

3744:
3745: IF x_return_status = fnd_api.g_ret_sts_error THEN
3746: RAISE fnd_api.g_exc_error;
3747: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3748: RAISE fnd_api.g_exc_unexpected_error;
3749: END IF;
3750:
3751: IF fnd_api.to_boolean(p_commit) THEN
3752: COMMIT WORK;

Line 3751: IF fnd_api.to_boolean(p_commit) THEN

3747: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3748: RAISE fnd_api.g_exc_unexpected_error;
3749: END IF;
3750:
3751: IF fnd_api.to_boolean(p_commit) THEN
3752: COMMIT WORK;
3753: END IF;
3754:
3755: EXCEPTION

Line 3756: WHEN fnd_api.g_exc_error THEN

3752: COMMIT WORK;
3753: END IF;
3754:
3755: EXCEPTION
3756: WHEN fnd_api.g_exc_error THEN
3757: ROLLBACK TO csf_create_child_task;
3758: x_return_status := fnd_api.g_ret_sts_error;
3759: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3760: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3758: x_return_status := fnd_api.g_ret_sts_error;

3754:
3755: EXCEPTION
3756: WHEN fnd_api.g_exc_error THEN
3757: ROLLBACK TO csf_create_child_task;
3758: x_return_status := fnd_api.g_ret_sts_error;
3759: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3760: WHEN fnd_api.g_exc_unexpected_error THEN
3761: ROLLBACK TO csf_create_child_task;
3762: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3760: WHEN fnd_api.g_exc_unexpected_error THEN

3756: WHEN fnd_api.g_exc_error THEN
3757: ROLLBACK TO csf_create_child_task;
3758: x_return_status := fnd_api.g_ret_sts_error;
3759: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3760: WHEN fnd_api.g_exc_unexpected_error THEN
3761: ROLLBACK TO csf_create_child_task;
3762: x_return_status := fnd_api.g_ret_sts_unexp_error;
3763: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3764: WHEN OTHERS THEN

Line 3762: x_return_status := fnd_api.g_ret_sts_unexp_error;

3758: x_return_status := fnd_api.g_ret_sts_error;
3759: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3760: WHEN fnd_api.g_exc_unexpected_error THEN
3761: ROLLBACK TO csf_create_child_task;
3762: x_return_status := fnd_api.g_ret_sts_unexp_error;
3763: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3764: WHEN OTHERS THEN
3765: x_return_status := fnd_api.g_ret_sts_unexp_error;
3766: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 3765: x_return_status := fnd_api.g_ret_sts_unexp_error;

3761: ROLLBACK TO csf_create_child_task;
3762: x_return_status := fnd_api.g_ret_sts_unexp_error;
3763: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3764: WHEN OTHERS THEN
3765: x_return_status := fnd_api.g_ret_sts_unexp_error;
3766: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3767: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3768: END IF;
3769: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 3839: x_return_status := fnd_api.g_ret_sts_success;

3835: l_task_info c_task_info%ROWTYPE;
3836: BEGIN
3837: SAVEPOINT csf_update_cust_confirmation;
3838:
3839: x_return_status := fnd_api.g_ret_sts_success;
3840:
3841: IF fnd_api.to_boolean (p_init_msg_list) THEN
3842: fnd_msg_pub.initialize;
3843: END IF;

Line 3841: IF fnd_api.to_boolean (p_init_msg_list) THEN

3837: SAVEPOINT csf_update_cust_confirmation;
3838:
3839: x_return_status := fnd_api.g_ret_sts_success;
3840:
3841: IF fnd_api.to_boolean (p_init_msg_list) THEN
3842: fnd_msg_pub.initialize;
3843: END IF;
3844:
3845: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

3841: IF fnd_api.to_boolean (p_init_msg_list) THEN
3842: fnd_msg_pub.initialize;
3843: END IF;
3844:
3845: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3846: RAISE fnd_api.g_exc_unexpected_error;
3847: END IF;
3848:
3849: OPEN c_task_info(p_task_id);

Line 3846: RAISE fnd_api.g_exc_unexpected_error;

3842: fnd_msg_pub.initialize;
3843: END IF;
3844:
3845: IF NOT fnd_api.compatible_api_call (l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3846: RAISE fnd_api.g_exc_unexpected_error;
3847: END IF;
3848:
3849: OPEN c_task_info(p_task_id);
3850: FETCH c_task_info INTO l_task_info;

Line 3874: , p_init_msg_list => fnd_api.g_false

3870: LOOP
3871: IF p_action = csf_tasks_pub.g_action_conf_to_received THEN
3872: jtf_task_confirmation_pub.set_confirmation_confirmed(
3873: p_api_version => 1.0
3874: , p_init_msg_list => fnd_api.g_false
3875: , p_commit => fnd_api.g_false
3876: , x_return_status => x_return_status
3877: , x_msg_count => x_msg_count
3878: , x_msg_data => x_msg_data

Line 3875: , p_commit => fnd_api.g_false

3871: IF p_action = csf_tasks_pub.g_action_conf_to_received THEN
3872: jtf_task_confirmation_pub.set_confirmation_confirmed(
3873: p_api_version => 1.0
3874: , p_init_msg_list => fnd_api.g_false
3875: , p_commit => fnd_api.g_false
3876: , x_return_status => x_return_status
3877: , x_msg_count => x_msg_count
3878: , x_msg_data => x_msg_data
3879: , p_task_id => l_cust_task_tbl(i)

Line 3885: , p_init_msg_list => fnd_api.g_false

3881: );
3882: ELSIF p_action = csf_tasks_pub.g_action_conf_to_required THEN
3883: jtf_task_confirmation_pub.set_confirmation_required(
3884: p_api_version => 1.0
3885: , p_init_msg_list => fnd_api.g_false
3886: , p_commit => fnd_api.g_false
3887: , x_return_status => x_return_status
3888: , x_msg_count => x_msg_count
3889: , x_msg_data => x_msg_data

Line 3886: , p_commit => fnd_api.g_false

3882: ELSIF p_action = csf_tasks_pub.g_action_conf_to_required THEN
3883: jtf_task_confirmation_pub.set_confirmation_required(
3884: p_api_version => 1.0
3885: , p_init_msg_list => fnd_api.g_false
3886: , p_commit => fnd_api.g_false
3887: , x_return_status => x_return_status
3888: , x_msg_count => x_msg_count
3889: , x_msg_data => x_msg_data
3890: , p_task_id => l_cust_task_tbl(i)

Line 3893: IF x_return_status = fnd_api.g_ret_sts_success THEN

3889: , x_msg_data => x_msg_data
3890: , p_task_id => l_cust_task_tbl(i)
3891: , p_object_version_number => l_cust_objver_tbl(i)
3892: );
3893: IF x_return_status = fnd_api.g_ret_sts_success THEN
3894: IF l_task_info.task_confirmation_status = 'C' THEN
3895: IF p_initiated = csf_tasks_pub.g_dispatcher_initiated THEN
3896: jtf_task_confirmation_pub.increase_counter(
3897: p_api_version => 1.0

Line 3898: , p_init_msg_list => fnd_api.g_false

3894: IF l_task_info.task_confirmation_status = 'C' THEN
3895: IF p_initiated = csf_tasks_pub.g_dispatcher_initiated THEN
3896: jtf_task_confirmation_pub.increase_counter(
3897: p_api_version => 1.0
3898: , p_init_msg_list => fnd_api.g_false
3899: , p_commit => fnd_api.g_false
3900: , x_return_status => x_return_status
3901: , x_msg_count => x_msg_count
3902: , x_msg_data => x_msg_data

Line 3899: , p_commit => fnd_api.g_false

3895: IF p_initiated = csf_tasks_pub.g_dispatcher_initiated THEN
3896: jtf_task_confirmation_pub.increase_counter(
3897: p_api_version => 1.0
3898: , p_init_msg_list => fnd_api.g_false
3899: , p_commit => fnd_api.g_false
3900: , x_return_status => x_return_status
3901: , x_msg_count => x_msg_count
3902: , x_msg_data => x_msg_data
3903: , p_task_id => l_cust_task_tbl(i)

Line 3909: , p_commit => fnd_api.g_false

3905: );
3906: ELSIF p_initiated = csf_tasks_pub.g_customer_initiated THEN
3907: jtf_task_confirmation_pub.reset_counter(
3908: p_api_version => 1.0
3909: , p_commit => fnd_api.g_false
3910: , p_init_msg_list => fnd_api.g_false
3911: , p_object_version_number => l_cust_objver_tbl(i)
3912: , p_task_id => l_cust_task_tbl(i)
3913: , x_return_status => x_return_status

Line 3910: , p_init_msg_list => fnd_api.g_false

3906: ELSIF p_initiated = csf_tasks_pub.g_customer_initiated THEN
3907: jtf_task_confirmation_pub.reset_counter(
3908: p_api_version => 1.0
3909: , p_commit => fnd_api.g_false
3910: , p_init_msg_list => fnd_api.g_false
3911: , p_object_version_number => l_cust_objver_tbl(i)
3912: , p_task_id => l_cust_task_tbl(i)
3913: , x_return_status => x_return_status
3914: , x_msg_count => x_msg_count

Line 3923: , p_init_msg_list => fnd_api.g_false

3919: END IF;
3920: ELSIF p_action = csf_tasks_pub.g_action_conf_not_required THEN
3921: jtf_task_confirmation_pub.reset_confirmation_status(
3922: p_api_version => 1.0
3923: , p_init_msg_list => fnd_api.g_false
3924: , p_commit => fnd_api.g_false
3925: , x_return_status => x_return_status
3926: , x_msg_count => x_msg_count
3927: , x_msg_data => x_msg_data

Line 3924: , p_commit => fnd_api.g_false

3920: ELSIF p_action = csf_tasks_pub.g_action_conf_not_required THEN
3921: jtf_task_confirmation_pub.reset_confirmation_status(
3922: p_api_version => 1.0
3923: , p_init_msg_list => fnd_api.g_false
3924: , p_commit => fnd_api.g_false
3925: , x_return_status => x_return_status
3926: , x_msg_count => x_msg_count
3927: , x_msg_data => x_msg_data
3928: , p_task_id => l_cust_task_tbl(i)

Line 3933: IF x_return_status = fnd_api.g_ret_sts_error THEN

3929: , p_object_version_number => l_cust_objver_tbl(i)
3930: );
3931: END IF;
3932:
3933: IF x_return_status = fnd_api.g_ret_sts_error THEN
3934: RAISE fnd_api.g_exc_error;
3935: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3936: RAISE fnd_api.g_exc_unexpected_error;
3937: END IF;

Line 3934: RAISE fnd_api.g_exc_error;

3930: );
3931: END IF;
3932:
3933: IF x_return_status = fnd_api.g_ret_sts_error THEN
3934: RAISE fnd_api.g_exc_error;
3935: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3936: RAISE fnd_api.g_exc_unexpected_error;
3937: END IF;
3938:

Line 3935: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3931: END IF;
3932:
3933: IF x_return_status = fnd_api.g_ret_sts_error THEN
3934: RAISE fnd_api.g_exc_error;
3935: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3936: RAISE fnd_api.g_exc_unexpected_error;
3937: END IF;
3938:
3939: IF ( p_task_id = l_cust_task_tbl(i) ) THEN

Line 3936: RAISE fnd_api.g_exc_unexpected_error;

3932:
3933: IF x_return_status = fnd_api.g_ret_sts_error THEN
3934: RAISE fnd_api.g_exc_error;
3935: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3936: RAISE fnd_api.g_exc_unexpected_error;
3937: END IF;
3938:
3939: IF ( p_task_id = l_cust_task_tbl(i) ) THEN
3940: p_object_version_number := l_cust_objver_tbl(i);

Line 3947: IF fnd_api.to_boolean (p_commit) THEN

3943: i := l_cust_task_tbl.next(i);
3944: END LOOP;
3945:
3946: -- Standard check of p_commit
3947: IF fnd_api.to_boolean (p_commit) THEN
3948: COMMIT WORK;
3949: END IF;
3950:
3951: EXCEPTION

Line 3952: WHEN fnd_api.g_exc_error THEN

3948: COMMIT WORK;
3949: END IF;
3950:
3951: EXCEPTION
3952: WHEN fnd_api.g_exc_error THEN
3953: ROLLBACK TO csf_update_cust_confirmation;
3954: x_return_status := fnd_api.g_ret_sts_error;
3955: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3956: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3954: x_return_status := fnd_api.g_ret_sts_error;

3950:
3951: EXCEPTION
3952: WHEN fnd_api.g_exc_error THEN
3953: ROLLBACK TO csf_update_cust_confirmation;
3954: x_return_status := fnd_api.g_ret_sts_error;
3955: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3956: WHEN fnd_api.g_exc_unexpected_error THEN
3957: ROLLBACK TO csf_update_cust_confirmation;
3958: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3956: WHEN fnd_api.g_exc_unexpected_error THEN

3952: WHEN fnd_api.g_exc_error THEN
3953: ROLLBACK TO csf_update_cust_confirmation;
3954: x_return_status := fnd_api.g_ret_sts_error;
3955: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3956: WHEN fnd_api.g_exc_unexpected_error THEN
3957: ROLLBACK TO csf_update_cust_confirmation;
3958: x_return_status := fnd_api.g_ret_sts_unexp_error;
3959: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3960: WHEN OTHERS THEN

Line 3958: x_return_status := fnd_api.g_ret_sts_unexp_error;

3954: x_return_status := fnd_api.g_ret_sts_error;
3955: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3956: WHEN fnd_api.g_exc_unexpected_error THEN
3957: ROLLBACK TO csf_update_cust_confirmation;
3958: x_return_status := fnd_api.g_ret_sts_unexp_error;
3959: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3960: WHEN OTHERS THEN
3961: x_return_status := fnd_api.g_ret_sts_unexp_error;
3962: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 3961: x_return_status := fnd_api.g_ret_sts_unexp_error;

3957: ROLLBACK TO csf_update_cust_confirmation;
3958: x_return_status := fnd_api.g_ret_sts_unexp_error;
3959: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3960: WHEN OTHERS THEN
3961: x_return_status := fnd_api.g_ret_sts_unexp_error;
3962: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3963: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3964: END IF;
3965: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 4149: * to take place for all Tasks, pass p_always_convert as FND_API.G_TRUE

4145: * in Minutes by Scheduler and therefore it is incumbent upon us to represent
4146: * them in a proper UOM. Thus this API will convert the Planned Effort to the default
4147: * UOM only for Child Tasks and will merely act as a Concatenation Operator for
4148: * other Tasks. If you want to overrule this and want conversion to Default UOM
4149: * to take place for all Tasks, pass p_always_convert as FND_API.G_TRUE
4150: *
4151: * Also refer to the documentation on CSF_UTIL_PVT.GET_EFFORT_IN_DEFAULT_UOM.
4152: *
4153: *

Line 4188: OR ( l_task_split_flag = '@' AND NVL(p_always_convert, fnd_api.g_false) = fnd_api.g_false)

4184: l_task_split_flag := p_task_split_flag;
4185:
4186: IF l_effort IS NULL
4187: OR l_effort_uom IS NULL
4188: OR ( l_task_split_flag = '@' AND NVL(p_always_convert, fnd_api.g_false) = fnd_api.g_false)
4189: THEN
4190: IF p_task_id IS NOT NULL THEN
4191: OPEN c_task_info;
4192: FETCH c_task_info INTO l_effort, l_effort_uom, l_task_split_flag;

Line 4202: AND NVL(p_always_convert, fnd_api.g_false) = fnd_api.g_false

4198: RETURN NULL;
4199: END IF;
4200:
4201: IF NVL(l_task_split_flag, 'M') IN ('M', '@')
4202: AND NVL(p_always_convert, fnd_api.g_false) = fnd_api.g_false
4203: THEN
4204: RETURN l_effort || ' ' || csf_util_pvt.get_uom(l_effort_uom);
4205: END IF;
4206:

Line 4416: x_return_status := fnd_api.g_ret_sts_success;

4412:
4413: begin
4414: SAVEPOINT csf_create_per_task;
4415:
4416: x_return_status := fnd_api.g_ret_sts_success;
4417:
4418: IF fnd_api.to_boolean (p_init_msg_list) THEN
4419: fnd_msg_pub.initialize;
4420: END IF;

Line 4418: IF fnd_api.to_boolean (p_init_msg_list) THEN

4414: SAVEPOINT csf_create_per_task;
4415:
4416: x_return_status := fnd_api.g_ret_sts_success;
4417:
4418: IF fnd_api.to_boolean (p_init_msg_list) THEN
4419: fnd_msg_pub.initialize;
4420: END IF;
4421:
4422: if p_type = 'ONETIME'

Line 4459: IF x_return_status = fnd_api.g_ret_sts_error THEN

4455: , x_msg_count => x_msg_count
4456: , x_msg_data => x_msg_data
4457: , x_task_id => x_task_id
4458: );
4459: IF x_return_status = fnd_api.g_ret_sts_error THEN
4460: RAISE fnd_api.g_exc_error;
4461: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4462: RAISE fnd_api.g_exc_unexpected_error;
4463: END IF;

Line 4460: RAISE fnd_api.g_exc_error;

4456: , x_msg_data => x_msg_data
4457: , x_task_id => x_task_id
4458: );
4459: IF x_return_status = fnd_api.g_ret_sts_error THEN
4460: RAISE fnd_api.g_exc_error;
4461: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4462: RAISE fnd_api.g_exc_unexpected_error;
4463: END IF;
4464:

Line 4461: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4457: , x_task_id => x_task_id
4458: );
4459: IF x_return_status = fnd_api.g_ret_sts_error THEN
4460: RAISE fnd_api.g_exc_error;
4461: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4462: RAISE fnd_api.g_exc_unexpected_error;
4463: END IF;
4464:
4465: l_task_id := x_task_id;

Line 4462: RAISE fnd_api.g_exc_unexpected_error;

4458: );
4459: IF x_return_status = fnd_api.g_ret_sts_error THEN
4460: RAISE fnd_api.g_exc_error;
4461: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4462: RAISE fnd_api.g_exc_unexpected_error;
4463: END IF;
4464:
4465: l_task_id := x_task_id;
4466:

Line 4487: IF x_return_status = fnd_api.g_ret_sts_error THEN

4483: , x_ta_object_version_number =>l_obj_number
4484: , x_task_object_version_number => l_task_ovn
4485: , x_task_status_id => l_ts);
4486:
4487: IF x_return_status = fnd_api.g_ret_sts_error THEN
4488: RAISE fnd_api.g_exc_error;
4489: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4490: RAISE fnd_api.g_exc_unexpected_error;
4491: END IF;

Line 4488: RAISE fnd_api.g_exc_error;

4484: , x_task_object_version_number => l_task_ovn
4485: , x_task_status_id => l_ts);
4486:
4487: IF x_return_status = fnd_api.g_ret_sts_error THEN
4488: RAISE fnd_api.g_exc_error;
4489: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4490: RAISE fnd_api.g_exc_unexpected_error;
4491: END IF;
4492:

Line 4489: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4485: , x_task_status_id => l_ts);
4486:
4487: IF x_return_status = fnd_api.g_ret_sts_error THEN
4488: RAISE fnd_api.g_exc_error;
4489: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4490: RAISE fnd_api.g_exc_unexpected_error;
4491: END IF;
4492:
4493: IF fnd_api.to_boolean (p_commit) THEN

Line 4490: RAISE fnd_api.g_exc_unexpected_error;

4486:
4487: IF x_return_status = fnd_api.g_ret_sts_error THEN
4488: RAISE fnd_api.g_exc_error;
4489: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4490: RAISE fnd_api.g_exc_unexpected_error;
4491: END IF;
4492:
4493: IF fnd_api.to_boolean (p_commit) THEN
4494: COMMIT WORK;

Line 4493: IF fnd_api.to_boolean (p_commit) THEN

4489: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4490: RAISE fnd_api.g_exc_unexpected_error;
4491: END IF;
4492:
4493: IF fnd_api.to_boolean (p_commit) THEN
4494: COMMIT WORK;
4495: END IF;
4496:
4497: Exception

Line 4498: WHEN fnd_api.g_exc_error THEN

4494: COMMIT WORK;
4495: END IF;
4496:
4497: Exception
4498: WHEN fnd_api.g_exc_error THEN
4499: ROLLBACK TO csf_create_per_task;
4500: x_return_status := fnd_api.g_ret_sts_error;
4501: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4502: WHEN fnd_api.g_exc_unexpected_error THEN

Line 4500: x_return_status := fnd_api.g_ret_sts_error;

4496:
4497: Exception
4498: WHEN fnd_api.g_exc_error THEN
4499: ROLLBACK TO csf_create_per_task;
4500: x_return_status := fnd_api.g_ret_sts_error;
4501: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4502: WHEN fnd_api.g_exc_unexpected_error THEN
4503: ROLLBACK TO csf_create_per_task;
4504: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4502: WHEN fnd_api.g_exc_unexpected_error THEN

4498: WHEN fnd_api.g_exc_error THEN
4499: ROLLBACK TO csf_create_per_task;
4500: x_return_status := fnd_api.g_ret_sts_error;
4501: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4502: WHEN fnd_api.g_exc_unexpected_error THEN
4503: ROLLBACK TO csf_create_per_task;
4504: x_return_status := fnd_api.g_ret_sts_unexp_error;
4505: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4506: WHEN OTHERS THEN

Line 4504: x_return_status := fnd_api.g_ret_sts_unexp_error;

4500: x_return_status := fnd_api.g_ret_sts_error;
4501: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4502: WHEN fnd_api.g_exc_unexpected_error THEN
4503: ROLLBACK TO csf_create_per_task;
4504: x_return_status := fnd_api.g_ret_sts_unexp_error;
4505: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4506: WHEN OTHERS THEN
4507: x_return_status := fnd_api.g_ret_sts_unexp_error;
4508: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 4507: x_return_status := fnd_api.g_ret_sts_unexp_error;

4503: ROLLBACK TO csf_create_per_task;
4504: x_return_status := fnd_api.g_ret_sts_unexp_error;
4505: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4506: WHEN OTHERS THEN
4507: x_return_status := fnd_api.g_ret_sts_unexp_error;
4508: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4509: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4510: END IF;
4511: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 4576: x_return_status := fnd_api.g_ret_sts_success;

4572: begin
4573:
4574: SAVEPOINT csf_update_per_task;
4575:
4576: x_return_status := fnd_api.g_ret_sts_success;
4577:
4578: IF fnd_api.to_boolean (p_init_msg_list) THEN
4579: fnd_msg_pub.initialize;
4580: END IF;

Line 4578: IF fnd_api.to_boolean (p_init_msg_list) THEN

4574: SAVEPOINT csf_update_per_task;
4575:
4576: x_return_status := fnd_api.g_ret_sts_success;
4577:
4578: IF fnd_api.to_boolean (p_init_msg_list) THEN
4579: fnd_msg_pub.initialize;
4580: END IF;
4581:
4582: open c_obj(p_task_id);

Line 4620: IF x_return_status = fnd_api.g_ret_sts_error THEN

4616: , x_return_status => x_return_status
4617: , x_msg_count => x_msg_count
4618: , x_msg_data => x_msg_data
4619: );
4620: IF x_return_status = fnd_api.g_ret_sts_error THEN
4621: RAISE fnd_api.g_exc_error;
4622: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4623: RAISE fnd_api.g_exc_unexpected_error;
4624: END IF;

Line 4621: RAISE fnd_api.g_exc_error;

4617: , x_msg_count => x_msg_count
4618: , x_msg_data => x_msg_data
4619: );
4620: IF x_return_status = fnd_api.g_ret_sts_error THEN
4621: RAISE fnd_api.g_exc_error;
4622: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4623: RAISE fnd_api.g_exc_unexpected_error;
4624: END IF;
4625:

Line 4622: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4618: , x_msg_data => x_msg_data
4619: );
4620: IF x_return_status = fnd_api.g_ret_sts_error THEN
4621: RAISE fnd_api.g_exc_error;
4622: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4623: RAISE fnd_api.g_exc_unexpected_error;
4624: END IF;
4625:
4626: open c_task_ass(p_task_id);

Line 4623: RAISE fnd_api.g_exc_unexpected_error;

4619: );
4620: IF x_return_status = fnd_api.g_ret_sts_error THEN
4621: RAISE fnd_api.g_exc_error;
4622: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4623: RAISE fnd_api.g_exc_unexpected_error;
4624: END IF;
4625:
4626: open c_task_ass(p_task_id);
4627: fetch c_task_ass into l_task_assignment_id;

Line 4651: IF x_return_status = fnd_api.g_ret_sts_error THEN

4647: , p_task_name =>p_task_name
4648: , x_task_object_version_number => l_obj_task
4649: , x_task_status_id =>l_ts);
4650:
4651: IF x_return_status = fnd_api.g_ret_sts_error THEN
4652: RAISE fnd_api.g_exc_error;
4653: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4654: RAISE fnd_api.g_exc_unexpected_error;
4655: END IF;

Line 4652: RAISE fnd_api.g_exc_error;

4648: , x_task_object_version_number => l_obj_task
4649: , x_task_status_id =>l_ts);
4650:
4651: IF x_return_status = fnd_api.g_ret_sts_error THEN
4652: RAISE fnd_api.g_exc_error;
4653: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4654: RAISE fnd_api.g_exc_unexpected_error;
4655: END IF;
4656:

Line 4653: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4649: , x_task_status_id =>l_ts);
4650:
4651: IF x_return_status = fnd_api.g_ret_sts_error THEN
4652: RAISE fnd_api.g_exc_error;
4653: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4654: RAISE fnd_api.g_exc_unexpected_error;
4655: END IF;
4656:
4657: IF fnd_api.to_boolean (p_commit) THEN

Line 4654: RAISE fnd_api.g_exc_unexpected_error;

4650:
4651: IF x_return_status = fnd_api.g_ret_sts_error THEN
4652: RAISE fnd_api.g_exc_error;
4653: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4654: RAISE fnd_api.g_exc_unexpected_error;
4655: END IF;
4656:
4657: IF fnd_api.to_boolean (p_commit) THEN
4658: COMMIT WORK;

Line 4657: IF fnd_api.to_boolean (p_commit) THEN

4653: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4654: RAISE fnd_api.g_exc_unexpected_error;
4655: END IF;
4656:
4657: IF fnd_api.to_boolean (p_commit) THEN
4658: COMMIT WORK;
4659: END IF;
4660:
4661: Exception

Line 4662: WHEN fnd_api.g_exc_error THEN

4658: COMMIT WORK;
4659: END IF;
4660:
4661: Exception
4662: WHEN fnd_api.g_exc_error THEN
4663: ROLLBACK TO csf_update_per_task;
4664: x_return_status := fnd_api.g_ret_sts_error;
4665: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4666: WHEN fnd_api.g_exc_unexpected_error THEN

Line 4664: x_return_status := fnd_api.g_ret_sts_error;

4660:
4661: Exception
4662: WHEN fnd_api.g_exc_error THEN
4663: ROLLBACK TO csf_update_per_task;
4664: x_return_status := fnd_api.g_ret_sts_error;
4665: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4666: WHEN fnd_api.g_exc_unexpected_error THEN
4667: ROLLBACK TO csf_update_per_task;
4668: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4666: WHEN fnd_api.g_exc_unexpected_error THEN

4662: WHEN fnd_api.g_exc_error THEN
4663: ROLLBACK TO csf_update_per_task;
4664: x_return_status := fnd_api.g_ret_sts_error;
4665: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4666: WHEN fnd_api.g_exc_unexpected_error THEN
4667: ROLLBACK TO csf_update_per_task;
4668: x_return_status := fnd_api.g_ret_sts_unexp_error;
4669: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4670: WHEN OTHERS THEN

Line 4668: x_return_status := fnd_api.g_ret_sts_unexp_error;

4664: x_return_status := fnd_api.g_ret_sts_error;
4665: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4666: WHEN fnd_api.g_exc_unexpected_error THEN
4667: ROLLBACK TO csf_update_per_task;
4668: x_return_status := fnd_api.g_ret_sts_unexp_error;
4669: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4670: WHEN OTHERS THEN
4671: x_return_status := fnd_api.g_ret_sts_unexp_error;
4672: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 4671: x_return_status := fnd_api.g_ret_sts_unexp_error;

4667: ROLLBACK TO csf_update_per_task;
4668: x_return_status := fnd_api.g_ret_sts_unexp_error;
4669: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
4670: WHEN OTHERS THEN
4671: x_return_status := fnd_api.g_ret_sts_unexp_error;
4672: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4673: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4674: END IF;
4675: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);