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

Line 116: IF p_convert_to_client_tz IS NULL OR p_convert_to_client_tz = fnd_api.g_true THEN

112: RETURN VARCHAR2 IS
113: l_date DATE;
114: BEGIN
115: l_date := p_date;
116: IF p_convert_to_client_tz IS NULL OR p_convert_to_client_tz = fnd_api.g_true THEN
117: -- AOL doesnt initialize FND_DATE package properly. Refer bugs 3183418 and 3115188.
118: -- Because of this, dates werent printed with TZ Conversion. Bypassing FND_DATE.
119: IF g_tz_enabled = 'Y' THEN
120: l_date := fnd_timezones_pvt.adjust_datetime(

Line 232: x_return_status := fnd_api.g_ret_sts_success;

228: AND s.flex_value_set_id = v.flex_value_set_id
229: AND v.flex_value = p_action;
230: BEGIN
231:
232: x_return_status := fnd_api.g_ret_sts_success;
233:
234: -- First Clear the Message Stack if the API is given the permission to clear stack.
235: IF fnd_api.to_boolean(p_init_msg_list) THEN
236: fnd_msg_pub.initialize;

Line 235: IF fnd_api.to_boolean(p_init_msg_list) THEN

231:
232: x_return_status := fnd_api.g_ret_sts_success;
233:
234: -- First Clear the Message Stack if the API is given the permission to clear stack.
235: IF fnd_api.to_boolean(p_init_msg_list) THEN
236: fnd_msg_pub.initialize;
237: END IF;
238:
239: l_success := 0;

Line 289: x_return_status := fnd_api.g_ret_sts_error;

285: END IF;
286: END LOOP;
287:
288: IF l_failed > 0 THEN
289: x_return_status := fnd_api.g_ret_sts_error;
290: END IF;
291:
292: -- There is only trip involved... and therefore no need to status message.
293: IF p_trip_id IS NOT NULL THEN

Line 407: IF p_overtime_flag IS NULL OR p_overtime_flag = fnd_api.g_true THEN

403: ORDER BY start_date_time, object_capacity_id;
404:
405: BEGIN
406: l_overtime := 0;
407: IF p_overtime_flag IS NULL OR p_overtime_flag = fnd_api.g_true THEN
408: l_overtime := g_overtime;
409: END IF;
410:
411: l_trips_count := 0;

Line 517: x_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

513: END IF;
514:
515: IF l_address.party_site_id IS NULL THEN
516: IF l_debug THEN
517: x_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
518: debug(' CSF_RESOURCE_ADDRESS_PVT failed to give Party Site ID' || x_msg_data, l_api_name, fnd_log.level_error);
519: END IF;
520: fnd_message.set_name('CSF', 'CSF_RESOURCE_NO_ACTIVE_PARTY');
521: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));

Line 524: RAISE fnd_api.g_exc_error;

520: fnd_message.set_name('CSF', 'CSF_RESOURCE_NO_ACTIVE_PARTY');
521: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
522: fnd_message.set_token('DATE', format_date(p_start_date_time));
523: fnd_msg_pub.ADD;
524: RAISE fnd_api.g_exc_error;
525: END IF;
526:
527: -- Departure and Arrival Task Resource Assignment
528: l_task_assign_tbl(1).resource_id := p_resource_id;

Line 568: IF x_return_status <> fnd_api.g_ret_sts_success THEN

564: , x_msg_data => x_msg_data
565: , x_task_id => x_dep_task_id
566: );
567:
568: IF x_return_status <> fnd_api.g_ret_sts_success THEN
569: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
570: fnd_message.set_token('TASK_NAME', g_dep_task_name);
571: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
572: fnd_msg_pub.ADD;

Line 571: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

567:
568: IF x_return_status <> fnd_api.g_ret_sts_success THEN
569: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
570: fnd_message.set_token('TASK_NAME', g_dep_task_name);
571: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
572: fnd_msg_pub.ADD;
573:
574: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
575: RAISE fnd_api.g_exc_unexpected_error;

Line 574: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

570: fnd_message.set_token('TASK_NAME', g_dep_task_name);
571: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
572: fnd_msg_pub.ADD;
573:
574: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
575: RAISE fnd_api.g_exc_unexpected_error;
576: END IF;
577: RAISE fnd_api.g_exc_error;
578: END IF;

Line 575: RAISE fnd_api.g_exc_unexpected_error;

571: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
572: fnd_msg_pub.ADD;
573:
574: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
575: RAISE fnd_api.g_exc_unexpected_error;
576: END IF;
577: RAISE fnd_api.g_exc_error;
578: END IF;
579:

Line 577: RAISE fnd_api.g_exc_error;

573:
574: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
575: RAISE fnd_api.g_exc_unexpected_error;
576: END IF;
577: RAISE fnd_api.g_exc_error;
578: END IF;
579:
580: IF l_debug THEN
581: debug(' Created Departure Task - Task ID = ' || x_dep_task_id, l_api_name, fnd_log.level_statement);

Line 620: IF x_return_status <> fnd_api.g_ret_sts_success THEN

616: , x_msg_data => x_msg_data
617: , x_task_id => x_arr_task_id
618: );
619:
620: IF x_return_status <> fnd_api.g_ret_sts_success THEN
621: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
622: fnd_message.set_token('TASK_NAME', g_arr_task_name);
623: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
624: fnd_msg_pub.ADD;

Line 623: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

619:
620: IF x_return_status <> fnd_api.g_ret_sts_success THEN
621: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
622: fnd_message.set_token('TASK_NAME', g_arr_task_name);
623: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
624: fnd_msg_pub.ADD;
625:
626: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
627: RAISE fnd_api.g_exc_unexpected_error;

Line 626: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

622: fnd_message.set_token('TASK_NAME', g_arr_task_name);
623: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
624: fnd_msg_pub.ADD;
625:
626: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
627: RAISE fnd_api.g_exc_unexpected_error;
628: END IF;
629: RAISE fnd_api.g_exc_error;
630: END IF;

Line 627: RAISE fnd_api.g_exc_unexpected_error;

623: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
624: fnd_msg_pub.ADD;
625:
626: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
627: RAISE fnd_api.g_exc_unexpected_error;
628: END IF;
629: RAISE fnd_api.g_exc_error;
630: END IF;
631:

Line 629: RAISE fnd_api.g_exc_error;

625:
626: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
627: RAISE fnd_api.g_exc_unexpected_error;
628: END IF;
629: RAISE fnd_api.g_exc_error;
630: END IF;
631:
632: IF l_debug THEN
633: debug(' Created Arrival Task - Task ID = ' || x_arr_task_id, l_api_name, fnd_log.level_statement);

Line 638: WHEN fnd_api.g_exc_error THEN

634: END IF;
635: END IF;-- end if for l_row_obj_cap
636: END IF;
637: EXCEPTION
638: WHEN fnd_api.g_exc_error THEN
639: x_return_status := fnd_api.g_ret_sts_error;
640: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
641: WHEN fnd_api.g_exc_unexpected_error THEN
642: if SQLCODE =1 then

Line 639: x_return_status := fnd_api.g_ret_sts_error;

635: END IF;-- end if for l_row_obj_cap
636: END IF;
637: EXCEPTION
638: WHEN fnd_api.g_exc_error THEN
639: x_return_status := fnd_api.g_ret_sts_error;
640: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
641: WHEN fnd_api.g_exc_unexpected_error THEN
642: if SQLCODE =1 then
643: x_return_status := fnd_api.g_ret_sts_error;

Line 641: WHEN fnd_api.g_exc_unexpected_error THEN

637: EXCEPTION
638: WHEN fnd_api.g_exc_error THEN
639: x_return_status := fnd_api.g_ret_sts_error;
640: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
641: WHEN fnd_api.g_exc_unexpected_error THEN
642: if SQLCODE =1 then
643: x_return_status := fnd_api.g_ret_sts_error;
644: else
645: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 643: x_return_status := fnd_api.g_ret_sts_error;

639: x_return_status := fnd_api.g_ret_sts_error;
640: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
641: WHEN fnd_api.g_exc_unexpected_error THEN
642: if SQLCODE =1 then
643: x_return_status := fnd_api.g_ret_sts_error;
644: else
645: x_return_status := fnd_api.g_ret_sts_unexp_error;
646: end if;
647: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 645: x_return_status := fnd_api.g_ret_sts_unexp_error;

641: WHEN fnd_api.g_exc_unexpected_error THEN
642: if SQLCODE =1 then
643: x_return_status := fnd_api.g_ret_sts_error;
644: else
645: x_return_status := fnd_api.g_ret_sts_unexp_error;
646: end if;
647: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
648: WHEN OTHERS THEN
649: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 649: x_return_status := fnd_api.g_ret_sts_unexp_error;

645: x_return_status := fnd_api.g_ret_sts_unexp_error;
646: end if;
647: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
648: WHEN OTHERS THEN
649: x_return_status := fnd_api.g_ret_sts_unexp_error;
650: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
651: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
652: END IF;
653: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 738: x_return_status := fnd_api.g_ret_sts_success;

734: l_object_tasks_tbl cac_sr_object_capacity_pub.object_tasks_tbl_type;
735: BEGIN
736: SAVEPOINT csf_new_trip;
737:
738: x_return_status := fnd_api.g_ret_sts_success;
739:
740: IF l_debug THEN
741: debug(' Creating Trip between ' || format_date(p_start_date_time) || ' and ' || format_date(p_end_date_time), l_api_name, fnd_log.level_statement);
742: END IF;

Line 756: RAISE fnd_api.g_exc_error;

752: debug(' The specified Trip Length is greater than one day', l_api_name, fnd_log.level_error);
753: END IF;
754: fnd_message.set_name('CSF', 'CSF_TRIP_LENGTH_MORE_THAN_DAY');
755: fnd_msg_pub.ADD;
756: RAISE fnd_api.g_exc_error;
757: END IF;
758:
759: END IF;
760:

Line 766: , p_init_msg_list => fnd_api.g_false

762: -- Create new Shift Tasks for the Trip to be created.
763: IF p_dep_task_id IS NULL OR p_arr_task_id IS NULL THEN
764: create_shift_tasks(
765: p_api_version => 1.0
766: , p_init_msg_list => fnd_api.g_false
767: , p_commit => fnd_api.g_false
768: , x_return_status => x_return_status
769: , x_msg_data => x_msg_data
770: , x_msg_count => x_msg_count

Line 767: , p_commit => fnd_api.g_false

763: IF p_dep_task_id IS NULL OR p_arr_task_id IS NULL THEN
764: create_shift_tasks(
765: p_api_version => 1.0
766: , p_init_msg_list => fnd_api.g_false
767: , p_commit => fnd_api.g_false
768: , x_return_status => x_return_status
769: , x_msg_data => x_msg_data
770: , x_msg_count => x_msg_count
771: , p_resource_id => p_resource_id

Line 781: IF x_return_status <> fnd_api.g_ret_sts_success THEN

777: , x_dep_task_id => l_dep_task_id
778: , x_arr_task_id => l_arr_task_id
779: );
780:
781: IF x_return_status <> fnd_api.g_ret_sts_success THEN
782: IF l_debug THEN
783: debug(' Unable to Create Shift Tasks: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
784: END IF;
785: IF x_return_status = fnd_api.g_ret_sts_error THEN

Line 785: IF x_return_status = fnd_api.g_ret_sts_error THEN

781: IF x_return_status <> fnd_api.g_ret_sts_success THEN
782: IF l_debug THEN
783: debug(' Unable to Create Shift Tasks: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
784: END IF;
785: IF x_return_status = fnd_api.g_ret_sts_error THEN
786: RAISE fnd_api.g_exc_error;
787: ELSE
788: RAISE fnd_api.g_exc_unexpected_error;
789: END IF;

Line 786: RAISE fnd_api.g_exc_error;

782: IF l_debug THEN
783: debug(' Unable to Create Shift Tasks: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
784: END IF;
785: IF x_return_status = fnd_api.g_ret_sts_error THEN
786: RAISE fnd_api.g_exc_error;
787: ELSE
788: RAISE fnd_api.g_exc_unexpected_error;
789: END IF;
790: END IF;

Line 788: RAISE fnd_api.g_exc_unexpected_error;

784: END IF;
785: IF x_return_status = fnd_api.g_ret_sts_error THEN
786: RAISE fnd_api.g_exc_error;
787: ELSE
788: RAISE fnd_api.g_exc_unexpected_error;
789: END IF;
790: END IF;
791: IF l_debug THEN
792: debug(' Created new Shift Tasks - Dep#' || l_dep_task_id || ' : Arr#' || l_arr_task_id, l_api_name, fnd_log.level_statement);

Line 806: IF p_find_tasks IS NULL OR p_find_tasks = fnd_api.g_true THEN

802: END IF;
803: END IF;
804: IF l_dep_task_id IS NOT NULL AND l_arr_task_id IS NOT NULL
805: THEN
806: IF p_find_tasks IS NULL OR p_find_tasks = fnd_api.g_true THEN
807: i := 1;
808: FOR v_task IN c_linkable_tasks LOOP
809: --l_time_occupied := v_task.booking_end_date - v_task.booking_start_date; -- Scheduled Task Duration
810: --l_time_occupied := l_time_occupied + NVL(v_task.travel_time, 0) / g_mins_in_day; -- Scheduled Travel Duration

Line 852: , p_init_msg_list => fnd_api.g_false

848:
849: -- Create the Trip by calling Object Capacity Table Handlers
850: cac_sr_object_capacity_pub.insert_object_capacity(
851: p_api_version => 1.0
852: , p_init_msg_list => fnd_api.g_false
853: , x_return_status => x_return_status
854: , x_msg_count => x_msg_count
855: , x_msg_data => x_msg_data
856: , p_object_capacity => l_object_capacity_tbl

Line 857: , p_update_tasks => fnd_api.g_true

853: , x_return_status => x_return_status
854: , x_msg_count => x_msg_count
855: , x_msg_data => x_msg_data
856: , p_object_capacity => l_object_capacity_tbl
857: , p_update_tasks => fnd_api.g_true
858: , p_object_tasks => l_object_tasks_tbl
859: );
860:
861: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 861: IF x_return_status <> fnd_api.g_ret_sts_success THEN

857: , p_update_tasks => fnd_api.g_true
858: , p_object_tasks => l_object_tasks_tbl
859: );
860:
861: IF x_return_status <> fnd_api.g_ret_sts_success THEN
862: IF l_debug THEN
863: x_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
864: debug(' Unable to Create the Object Capacity: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
865: END IF;

Line 863: x_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

859: );
860:
861: IF x_return_status <> fnd_api.g_ret_sts_success THEN
862: IF l_debug THEN
863: x_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
864: debug(' Unable to Create the Object Capacity: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
865: END IF;
866: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
867: RAISE fnd_api.g_exc_unexpected_error;

Line 866: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

862: IF l_debug THEN
863: x_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
864: debug(' Unable to Create the Object Capacity: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
865: END IF;
866: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
867: RAISE fnd_api.g_exc_unexpected_error;
868: END IF;
869: RAISE fnd_api.g_exc_error;
870: END IF;

Line 867: RAISE fnd_api.g_exc_unexpected_error;

863: x_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
864: debug(' Unable to Create the Object Capacity: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
865: END IF;
866: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
867: RAISE fnd_api.g_exc_unexpected_error;
868: END IF;
869: RAISE fnd_api.g_exc_error;
870: END IF;
871:

Line 869: RAISE fnd_api.g_exc_error;

865: END IF;
866: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
867: RAISE fnd_api.g_exc_unexpected_error;
868: END IF;
869: RAISE fnd_api.g_exc_error;
870: END IF;
871:
872: x_trip.trip_id := l_object_capacity_tbl(1).object_capacity_id;
873: x_trip.object_version_number := 1;

Line 894: WHEN fnd_api.g_exc_error THEN

890:
891: END IF; --END IF FOR l_dep_task_id is null
892:
893: EXCEPTION
894: WHEN fnd_api.g_exc_error THEN
895: ROLLBACK TO csf_new_trip;
896: x_return_status := fnd_api.g_ret_sts_error;
897: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
898: WHEN fnd_api.g_exc_unexpected_error THEN

Line 896: x_return_status := fnd_api.g_ret_sts_error;

892:
893: EXCEPTION
894: WHEN fnd_api.g_exc_error THEN
895: ROLLBACK TO csf_new_trip;
896: x_return_status := fnd_api.g_ret_sts_error;
897: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
898: WHEN fnd_api.g_exc_unexpected_error THEN
899: debug('Unepected error occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
900: ROLLBACK TO csf_new_trip;

Line 898: WHEN fnd_api.g_exc_unexpected_error THEN

894: WHEN fnd_api.g_exc_error THEN
895: ROLLBACK TO csf_new_trip;
896: x_return_status := fnd_api.g_ret_sts_error;
897: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
898: WHEN fnd_api.g_exc_unexpected_error THEN
899: debug('Unepected error occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
900: ROLLBACK TO csf_new_trip;
901: if SQLCODE =1 then
902: x_return_status := fnd_api.g_ret_sts_error;

Line 902: x_return_status := fnd_api.g_ret_sts_error;

898: WHEN fnd_api.g_exc_unexpected_error THEN
899: debug('Unepected error occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
900: ROLLBACK TO csf_new_trip;
901: if SQLCODE =1 then
902: x_return_status := fnd_api.g_ret_sts_error;
903: else
904: x_return_status := fnd_api.g_ret_sts_unexp_error;
905: end if;
906: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 904: x_return_status := fnd_api.g_ret_sts_unexp_error;

900: ROLLBACK TO csf_new_trip;
901: if SQLCODE =1 then
902: x_return_status := fnd_api.g_ret_sts_error;
903: else
904: x_return_status := fnd_api.g_ret_sts_unexp_error;
905: end if;
906: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
907: WHEN OTHERS THEN
908: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

Line 909: x_return_status := fnd_api.g_ret_sts_unexp_error;

905: end if;
906: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
907: WHEN OTHERS THEN
908: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
909: x_return_status := fnd_api.g_ret_sts_unexp_error;
910: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
911: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
912: END IF;
913: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 977: x_return_status := fnd_api.g_ret_sts_success;

973:
974: BEGIN
975: SAVEPOINT csf_change_trip;
976:
977: x_return_status := fnd_api.g_ret_sts_success;
978:
979: l_shift_length := (p_trip.end_date_time - p_trip.start_date_time) * g_hours_in_day;
980: l_available_hours := p_trip.available_hours;
981: l_available_hours_before := p_trip.available_hours_before;

Line 993: l_available_hours_before := NVL(p_available_hours_before, fnd_api.g_miss_num);

989:
990: -- If Available Hours (either as value or as inc/dec) is passed, and Avl Before/After
991: -- is not passed, they should be nulled out.
992: IF p_available_hours IS NOT NULL OR p_upd_available_hours IS NOT NULL THEN
993: l_available_hours_before := NVL(p_available_hours_before, fnd_api.g_miss_num);
994: l_available_hours_after := NVL(p_available_hours_after, fnd_api.g_miss_num);
995: ELSE
996: l_available_hours_before := p_available_hours_before;
997: l_available_hours_after := p_available_hours_after;

Line 994: l_available_hours_after := NVL(p_available_hours_after, fnd_api.g_miss_num);

990: -- If Available Hours (either as value or as inc/dec) is passed, and Avl Before/After
991: -- is not passed, they should be nulled out.
992: IF p_available_hours IS NOT NULL OR p_upd_available_hours IS NOT NULL THEN
993: l_available_hours_before := NVL(p_available_hours_before, fnd_api.g_miss_num);
994: l_available_hours_after := NVL(p_available_hours_after, fnd_api.g_miss_num);
995: ELSE
996: l_available_hours_before := p_available_hours_before;
997: l_available_hours_after := p_available_hours_after;
998: END IF;

Line 1001: OR (l_available_hours_before <> fnd_api.g_miss_num AND l_available_hours_before > l_shift_length)

997: l_available_hours_after := p_available_hours_after;
998: END IF;
999:
1000: /* IF l_available_hours > l_shift_length
1001: OR (l_available_hours_before <> fnd_api.g_miss_num AND l_available_hours_before > l_shift_length)
1002: OR (l_available_hours_after <> fnd_api.g_miss_num AND l_available_hours_after > l_shift_length)
1003: THEN
1004: -- Trip Availability is more than the Shift Length
1005: IF l_debug THEN

Line 1002: OR (l_available_hours_after <> fnd_api.g_miss_num AND l_available_hours_after > l_shift_length)

998: END IF;
999:
1000: /* IF l_available_hours > l_shift_length
1001: OR (l_available_hours_before <> fnd_api.g_miss_num AND l_available_hours_before > l_shift_length)
1002: OR (l_available_hours_after <> fnd_api.g_miss_num AND l_available_hours_after > l_shift_length)
1003: THEN
1004: -- Trip Availability is more than the Shift Length
1005: IF l_debug THEN
1006: debug(' Trip Availability is more than Shift Length', l_api_name, fnd_log.level_error);

Line 1014: RAISE fnd_api.g_exc_error;

1010: fnd_message.set_token('AVAILABLE', l_available_hours);
1011: fnd_message.set_token('AVLBEFORE', l_available_hours_before);
1012: fnd_message.set_token('AVLAFTER', l_available_hours_after);
1013: fnd_msg_pub.ADD;
1014: RAISE fnd_api.g_exc_error;
1015: END IF;*/
1016:
1017: IF l_available_hours = l_shift_length
1018: AND ( ( l_available_hours_before IS NOT NULL AND l_available_hours_before <> fnd_api.g_miss_num )

Line 1018: AND ( ( l_available_hours_before IS NOT NULL AND l_available_hours_before <> fnd_api.g_miss_num )

1014: RAISE fnd_api.g_exc_error;
1015: END IF;*/
1016:
1017: IF l_available_hours = l_shift_length
1018: AND ( ( l_available_hours_before IS NOT NULL AND l_available_hours_before <> fnd_api.g_miss_num )
1019: OR ( l_available_hours_after IS NOT NULL AND l_available_hours_after <> fnd_api.g_miss_num )
1020: )
1021: THEN
1022: -- Trip Availability is equal to the Shift Length and Before and Afters are not NULL

Line 1019: OR ( l_available_hours_after IS NOT NULL AND l_available_hours_after <> fnd_api.g_miss_num )

1015: END IF;*/
1016:
1017: IF l_available_hours = l_shift_length
1018: AND ( ( l_available_hours_before IS NOT NULL AND l_available_hours_before <> fnd_api.g_miss_num )
1019: OR ( l_available_hours_after IS NOT NULL AND l_available_hours_after <> fnd_api.g_miss_num )
1020: )
1021: THEN
1022: -- Trip Availability is equal to the Shift Length and Before and Afters are not NULL
1023: IF l_debug THEN

Line 1032: RAISE fnd_api.g_exc_error;

1028: fnd_message.set_token('AVLBEFORE', l_available_hours_before);
1029: fnd_message.set_token('AVLAFTER', l_available_hours_after);
1030: fnd_message.set_token('AVAILABLE', l_available_hours);
1031: fnd_msg_pub.ADD;
1032: RAISE fnd_api.g_exc_error;
1033: END IF;
1034:
1035: cac_sr_object_capacity_pub.update_object_capacity(
1036: p_api_version => 1.0

Line 1051: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1047: , p_start_date_time => p_start_date
1048: , p_end_date_time => p_end_date
1049: );
1050:
1051: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1052: IF l_debug THEN
1053: debug(' Unable to Update the Object Capacity', l_api_name, fnd_log.level_error);
1054: END IF;
1055: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1055: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1051: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1052: IF l_debug THEN
1053: debug(' Unable to Update the Object Capacity', l_api_name, fnd_log.level_error);
1054: END IF;
1055: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1056: RAISE fnd_api.g_exc_unexpected_error;
1057: END IF;
1058: RAISE fnd_api.g_exc_error;
1059: END IF;

Line 1056: RAISE fnd_api.g_exc_unexpected_error;

1052: IF l_debug THEN
1053: debug(' Unable to Update the Object Capacity', l_api_name, fnd_log.level_error);
1054: END IF;
1055: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1056: RAISE fnd_api.g_exc_unexpected_error;
1057: END IF;
1058: RAISE fnd_api.g_exc_error;
1059: END IF;
1060:

Line 1058: RAISE fnd_api.g_exc_error;

1054: END IF;
1055: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1056: RAISE fnd_api.g_exc_unexpected_error;
1057: END IF;
1058: RAISE fnd_api.g_exc_error;
1059: END IF;
1060:
1061: -- If Tasks need not be updated.... nothing more to be done. Exit
1062: IF p_update_tasks = fnd_api.g_false THEN

Line 1062: IF p_update_tasks = fnd_api.g_false THEN

1058: RAISE fnd_api.g_exc_error;
1059: END IF;
1060:
1061: -- If Tasks need not be updated.... nothing more to be done. Exit
1062: IF p_update_tasks = fnd_api.g_false THEN
1063: RETURN;
1064: END IF;
1065:
1066: -- If New Trip Status equals Old Trip Status.... nothing more to be done. Exit

Line 1072: l_validation_level := fnd_api.g_valid_level_none;

1068: RETURN;
1069: END IF;
1070:
1071: IF p_task_action = g_action_close_trip THEN
1072: l_validation_level := fnd_api.g_valid_level_none;
1073: l_task_type := 'SHIFTS';
1074: ELSE
1075: l_validation_level := fnd_api.g_valid_level_full;
1076: l_task_type := 'ALL';

Line 1075: l_validation_level := fnd_api.g_valid_level_full;

1071: IF p_task_action = g_action_close_trip THEN
1072: l_validation_level := fnd_api.g_valid_level_none;
1073: l_task_type := 'SHIFTS';
1074: ELSE
1075: l_validation_level := fnd_api.g_valid_level_full;
1076: l_task_type := 'ALL';
1077: END IF;
1078:
1079: FOR v_task IN c_tasks(l_task_type) LOOP

Line 1087: , p_init_msg_list => fnd_api.g_false

1083: debug(' Updating the Task - TaskID# ' || v_task.task_id, l_api_name, fnd_log.level_statement);
1084: END IF;
1085: csf_task_assignments_pub.update_assignment_status(
1086: p_api_version => 1.0
1087: , p_init_msg_list => fnd_api.g_false
1088: , p_validation_level => l_validation_level
1089: , p_commit => fnd_api.g_false
1090: , x_return_status => x_return_status
1091: , x_msg_count => x_msg_count

Line 1089: , p_commit => fnd_api.g_false

1085: csf_task_assignments_pub.update_assignment_status(
1086: p_api_version => 1.0
1087: , p_init_msg_list => fnd_api.g_false
1088: , p_validation_level => l_validation_level
1089: , p_commit => fnd_api.g_false
1090: , x_return_status => x_return_status
1091: , x_msg_count => x_msg_count
1092: , x_msg_data => x_msg_data
1093: , p_task_assignment_id => v_task.task_assignment_id

Line 1100: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1096: , x_task_object_version_number => v_task.task_ovn
1097: , x_task_status_id => v_task.task_status_id
1098: );
1099:
1100: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1101: -- Somehow direct population of the Token using fnd_msg_pub is not working
1102: -- Therefore populating it in x_msg_data and using it to populate the Token REASON.
1103: x_msg_data := fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false);
1104: IF l_debug THEN

Line 1103: x_msg_data := fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false);

1099:
1100: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1101: -- Somehow direct population of the Token using fnd_msg_pub is not working
1102: -- Therefore populating it in x_msg_data and using it to populate the Token REASON.
1103: x_msg_data := fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false);
1104: IF l_debug THEN
1105: debug(' Unable to update the Assignment: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
1106: END IF;
1107: fnd_message.set_name('CSF', 'CSF_ASSIGNMENT_UPDATE_FAIL');

Line 1111: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1107: fnd_message.set_name('CSF', 'CSF_ASSIGNMENT_UPDATE_FAIL');
1108: fnd_message.set_token('TASK', v_task.task_number);
1109: fnd_message.set_token('REASON', x_msg_data);
1110: fnd_msg_pub.ADD;
1111: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1112: RAISE fnd_api.g_exc_unexpected_error;
1113: END IF;
1114: RAISE fnd_api.g_exc_error;
1115: END IF;

Line 1112: RAISE fnd_api.g_exc_unexpected_error;

1108: fnd_message.set_token('TASK', v_task.task_number);
1109: fnd_message.set_token('REASON', x_msg_data);
1110: fnd_msg_pub.ADD;
1111: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1112: RAISE fnd_api.g_exc_unexpected_error;
1113: END IF;
1114: RAISE fnd_api.g_exc_error;
1115: END IF;
1116: END IF;

Line 1114: RAISE fnd_api.g_exc_error;

1110: fnd_msg_pub.ADD;
1111: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1112: RAISE fnd_api.g_exc_unexpected_error;
1113: END IF;
1114: RAISE fnd_api.g_exc_error;
1115: END IF;
1116: END IF;
1117: END LOOP;
1118: EXCEPTION

Line 1119: WHEN fnd_api.g_exc_error THEN

1115: END IF;
1116: END IF;
1117: END LOOP;
1118: EXCEPTION
1119: WHEN fnd_api.g_exc_error THEN
1120: ROLLBACK TO csf_change_trip;
1121: x_return_status := fnd_api.g_ret_sts_error;
1122: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1123: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1121: x_return_status := fnd_api.g_ret_sts_error;

1117: END LOOP;
1118: EXCEPTION
1119: WHEN fnd_api.g_exc_error THEN
1120: ROLLBACK TO csf_change_trip;
1121: x_return_status := fnd_api.g_ret_sts_error;
1122: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1123: WHEN fnd_api.g_exc_unexpected_error THEN
1124: ROLLBACK TO csf_change_trip;
1125: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1123: WHEN fnd_api.g_exc_unexpected_error THEN

1119: WHEN fnd_api.g_exc_error THEN
1120: ROLLBACK TO csf_change_trip;
1121: x_return_status := fnd_api.g_ret_sts_error;
1122: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1123: WHEN fnd_api.g_exc_unexpected_error THEN
1124: ROLLBACK TO csf_change_trip;
1125: x_return_status := fnd_api.g_ret_sts_unexp_error;
1126: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1127: WHEN OTHERS THEN

Line 1125: x_return_status := fnd_api.g_ret_sts_unexp_error;

1121: x_return_status := fnd_api.g_ret_sts_error;
1122: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1123: WHEN fnd_api.g_exc_unexpected_error THEN
1124: ROLLBACK TO csf_change_trip;
1125: x_return_status := fnd_api.g_ret_sts_unexp_error;
1126: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1127: WHEN OTHERS THEN
1128: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1129: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1129: x_return_status := fnd_api.g_ret_sts_unexp_error;

1125: x_return_status := fnd_api.g_ret_sts_unexp_error;
1126: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1127: WHEN OTHERS THEN
1128: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1129: x_return_status := fnd_api.g_ret_sts_unexp_error;
1130: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1131: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1132: END IF;
1133: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 1164: x_return_status := fnd_api.g_ret_sts_success;

1160:
1161: BEGIN
1162: SAVEPOINT csf_remove_trip;
1163:
1164: x_return_status := fnd_api.g_ret_sts_success;
1165:
1166: IF l_debug THEN
1167: debug( ' Deleting the Trip #' || p_trip.trip_id
1168: || ' between ' || format_date(p_trip.start_date_time)

Line 1182: RAISE fnd_api.g_exc_error;

1178: END IF;
1179:
1180: fnd_message.set_name('CSF', 'CSF_TRIP_IS_BLOCKED');
1181: fnd_msg_pub.ADD;
1182: RAISE fnd_api.g_exc_error;
1183: END IF;
1184:
1185: -- Check whether there are active Task Assignments in the Trip
1186: IF NVL(p_check_active_tasks, fnd_api.g_true) = fnd_api.g_true THEN

Line 1186: IF NVL(p_check_active_tasks, fnd_api.g_true) = fnd_api.g_true THEN

1182: RAISE fnd_api.g_exc_error;
1183: END IF;
1184:
1185: -- Check whether there are active Task Assignments in the Trip
1186: IF NVL(p_check_active_tasks, fnd_api.g_true) = fnd_api.g_true THEN
1187: IF trip_has_active_tasks(p_trip.trip_id) THEN
1188: -- There are Active Task Assignments for the Trip.
1189: IF l_debug THEN
1190: debug(' Trip has active Tasks and so cant be deleted', l_api_name, fnd_log.level_error);

Line 1195: RAISE fnd_api.g_exc_error;

1191: END IF;
1192:
1193: fnd_message.set_name('CSF', 'CSF_TRIP_HAS_ACTIVE_TASKS');
1194: fnd_msg_pub.ADD;
1195: RAISE fnd_api.g_exc_error;
1196: END IF;
1197: END IF;
1198:
1199: -- Delete the Shift Tasks

Line 1212: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1208: , x_msg_data => x_msg_data
1209: , p_task_id => v_shift_task.task_id
1210: , p_object_version_number => v_shift_task.object_version_number
1211: );
1212: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1213: IF l_debug THEN
1214: debug(' Unable to Delete the Shift Task id - ' || v_shift_task.task_id , l_api_name, fnd_log.level_error);
1215: END IF;
1216:

Line 1219: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

1215: END IF;
1216:
1217: fnd_message.set_name('CSF', 'CSF_TASK_DELETE_FAIL');
1218: fnd_message.set_token('TASK', v_shift_task.task_number);
1219: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1220: fnd_msg_pub.ADD;
1221: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1222: RAISE fnd_api.g_exc_unexpected_error;
1223: END IF;

Line 1221: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1217: fnd_message.set_name('CSF', 'CSF_TASK_DELETE_FAIL');
1218: fnd_message.set_token('TASK', v_shift_task.task_number);
1219: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1220: fnd_msg_pub.ADD;
1221: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1222: RAISE fnd_api.g_exc_unexpected_error;
1223: END IF;
1224: RAISE fnd_api.g_exc_error;
1225: END IF;

Line 1222: RAISE fnd_api.g_exc_unexpected_error;

1218: fnd_message.set_token('TASK', v_shift_task.task_number);
1219: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1220: fnd_msg_pub.ADD;
1221: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1222: RAISE fnd_api.g_exc_unexpected_error;
1223: END IF;
1224: RAISE fnd_api.g_exc_error;
1225: END IF;
1226: END LOOP;

Line 1224: RAISE fnd_api.g_exc_error;

1220: fnd_msg_pub.ADD;
1221: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1222: RAISE fnd_api.g_exc_unexpected_error;
1223: END IF;
1224: RAISE fnd_api.g_exc_error;
1225: END IF;
1226: END LOOP;
1227:
1228: -- Delete the Object Capacity

Line 1236: , p_update_tasks => fnd_api.g_false

1232: , x_msg_count => x_msg_count
1233: , x_msg_data => x_msg_data
1234: , p_object_capacity_id => p_trip.trip_id
1235: , p_object_version_number => p_object_version_number
1236: , p_update_tasks => fnd_api.g_false
1237: );
1238:
1239: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1240: IF l_debug THEN

Line 1239: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1235: , p_object_version_number => p_object_version_number
1236: , p_update_tasks => fnd_api.g_false
1237: );
1238:
1239: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1240: IF l_debug THEN
1241: debug(' Unable to Delete the Object Capacity', l_api_name, fnd_log.level_error);
1242: END IF;
1243: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1243: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1239: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1240: IF l_debug THEN
1241: debug(' Unable to Delete the Object Capacity', l_api_name, fnd_log.level_error);
1242: END IF;
1243: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1244: RAISE fnd_api.g_exc_unexpected_error;
1245: END IF;
1246: RAISE fnd_api.g_exc_error;
1247: END IF;

Line 1244: RAISE fnd_api.g_exc_unexpected_error;

1240: IF l_debug THEN
1241: debug(' Unable to Delete the Object Capacity', l_api_name, fnd_log.level_error);
1242: END IF;
1243: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1244: RAISE fnd_api.g_exc_unexpected_error;
1245: END IF;
1246: RAISE fnd_api.g_exc_error;
1247: END IF;
1248:

Line 1246: RAISE fnd_api.g_exc_error;

1242: END IF;
1243: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1244: RAISE fnd_api.g_exc_unexpected_error;
1245: END IF;
1246: RAISE fnd_api.g_exc_error;
1247: END IF;
1248:
1249: IF l_debug THEN
1250: debug(' Deleted the Trip', l_api_name, fnd_log.level_statement);

Line 1253: WHEN fnd_api.g_exc_error THEN

1249: IF l_debug THEN
1250: debug(' Deleted the Trip', l_api_name, fnd_log.level_statement);
1251: END IF;
1252: EXCEPTION
1253: WHEN fnd_api.g_exc_error THEN
1254: ROLLBACK TO csf_remove_trip;
1255: x_return_status := fnd_api.g_ret_sts_error;
1256: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1257: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1255: x_return_status := fnd_api.g_ret_sts_error;

1251: END IF;
1252: EXCEPTION
1253: WHEN fnd_api.g_exc_error THEN
1254: ROLLBACK TO csf_remove_trip;
1255: x_return_status := fnd_api.g_ret_sts_error;
1256: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1257: WHEN fnd_api.g_exc_unexpected_error THEN
1258: ROLLBACK TO csf_remove_trip;
1259: IF l_debug THEN

Line 1257: WHEN fnd_api.g_exc_unexpected_error THEN

1253: WHEN fnd_api.g_exc_error THEN
1254: ROLLBACK TO csf_remove_trip;
1255: x_return_status := fnd_api.g_ret_sts_error;
1256: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1257: WHEN fnd_api.g_exc_unexpected_error THEN
1258: ROLLBACK TO csf_remove_trip;
1259: IF l_debug THEN
1260: debug('Unable to Delete the Object Capacity: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1261: END IF;

Line 1263: x_return_status := fnd_api.g_ret_sts_error;

1259: IF l_debug THEN
1260: debug('Unable to Delete the Object Capacity: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1261: END IF;
1262: if SQLCODE =1 then
1263: x_return_status := fnd_api.g_ret_sts_error;
1264: else
1265: x_return_status := fnd_api.g_ret_sts_unexp_error;
1266: end if;
1267: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 1265: x_return_status := fnd_api.g_ret_sts_unexp_error;

1261: END IF;
1262: if SQLCODE =1 then
1263: x_return_status := fnd_api.g_ret_sts_error;
1264: else
1265: x_return_status := fnd_api.g_ret_sts_unexp_error;
1266: end if;
1267: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1268: WHEN OTHERS THEN
1269: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

Line 1270: x_return_status := fnd_api.g_ret_sts_unexp_error;

1266: end if;
1267: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1268: WHEN OTHERS THEN
1269: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1270: x_return_status := fnd_api.g_ret_sts_unexp_error;
1271: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1272: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1273: END IF;
1274: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 1386: x_return_status := fnd_api.g_ret_sts_success;

1382: AND t.task_type_id IN (20, 21);
1383: BEGIN
1384: SAVEPOINT csf_correct_trip;
1385:
1386: x_return_status := fnd_api.g_ret_sts_success;
1387:
1388: IF l_debug THEN
1389: debug(' Checking Shift Tasks', l_api_name, fnd_log.level_statement);
1390: END IF;

Line 1410: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1406: , p_task_id => v_shift_task.task_id
1407: , p_object_version_number => v_shift_task.object_version_number
1408: );
1409: END IF;
1410: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1411: IF l_debug THEN
1412: debug(' Unable to Delete the Task', l_api_name, fnd_log.level_error);
1413: END IF;
1414:

Line 1417: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

1413: END IF;
1414:
1415: fnd_message.set_name('CSF', 'CSF_TASK_DELETE_FAIL');
1416: fnd_message.set_token('TASK', v_shift_task.task_number);
1417: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1418: fnd_msg_pub.ADD;
1419: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1420: RAISE fnd_api.g_exc_unexpected_error;
1421: END IF;

Line 1419: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1415: fnd_message.set_name('CSF', 'CSF_TASK_DELETE_FAIL');
1416: fnd_message.set_token('TASK', v_shift_task.task_number);
1417: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1418: fnd_msg_pub.ADD;
1419: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1420: RAISE fnd_api.g_exc_unexpected_error;
1421: END IF;
1422: RAISE fnd_api.g_exc_error;
1423: END IF;

Line 1420: RAISE fnd_api.g_exc_unexpected_error;

1416: fnd_message.set_token('TASK', v_shift_task.task_number);
1417: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1418: fnd_msg_pub.ADD;
1419: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1420: RAISE fnd_api.g_exc_unexpected_error;
1421: END IF;
1422: RAISE fnd_api.g_exc_error;
1423: END IF;
1424:

Line 1422: RAISE fnd_api.g_exc_error;

1418: fnd_msg_pub.ADD;
1419: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1420: RAISE fnd_api.g_exc_unexpected_error;
1421: END IF;
1422: RAISE fnd_api.g_exc_error;
1423: END IF;
1424:
1425: IF v_shift_task.task_type_id = 20 THEN
1426: l_dep_task_exists := TRUE;

Line 1452: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1448: , x_dep_task_id => l_dep_task_id
1449: , x_arr_task_id => l_arr_task_id
1450: );
1451:
1452: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1453: IF l_debug THEN
1454: debug(' Creation of Shift Tasks failed', l_api_name, fnd_log.level_error);
1455: END IF;
1456: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1456: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1452: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1453: IF l_debug THEN
1454: debug(' Creation of Shift Tasks failed', l_api_name, fnd_log.level_error);
1455: END IF;
1456: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1457: RAISE fnd_api.g_exc_unexpected_error;
1458: END IF;
1459: RAISE fnd_api.g_exc_error;
1460: END IF;

Line 1457: RAISE fnd_api.g_exc_unexpected_error;

1453: IF l_debug THEN
1454: debug(' Creation of Shift Tasks failed', l_api_name, fnd_log.level_error);
1455: END IF;
1456: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1457: RAISE fnd_api.g_exc_unexpected_error;
1458: END IF;
1459: RAISE fnd_api.g_exc_error;
1460: END IF;
1461: END IF;

Line 1459: RAISE fnd_api.g_exc_error;

1455: END IF;
1456: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1457: RAISE fnd_api.g_exc_unexpected_error;
1458: END IF;
1459: RAISE fnd_api.g_exc_error;
1460: END IF;
1461: END IF;
1462:
1463: FOR v_task IN c_tasks LOOP

Line 1476: , p_enable_workflow => fnd_api.g_miss_char

1472: , x_msg_count => x_msg_count
1473: , p_task_assignment_id => v_task.task_assignment_id
1474: , p_object_version_number => v_task.object_version_number
1475: , p_object_capacity_id => v_task.correct_trip_id
1476: , p_enable_workflow => fnd_api.g_miss_char
1477: , p_abort_workflow => fnd_api.g_miss_char
1478: );
1479:
1480: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 1477: , p_abort_workflow => fnd_api.g_miss_char

1473: , p_task_assignment_id => v_task.task_assignment_id
1474: , p_object_version_number => v_task.object_version_number
1475: , p_object_capacity_id => v_task.correct_trip_id
1476: , p_enable_workflow => fnd_api.g_miss_char
1477: , p_abort_workflow => fnd_api.g_miss_char
1478: );
1479:
1480: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1481: fnd_message.set_name('CSF', 'CSF_ASSIGNMENT_UPDATE_FAIL');

Line 1480: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1476: , p_enable_workflow => fnd_api.g_miss_char
1477: , p_abort_workflow => fnd_api.g_miss_char
1478: );
1479:
1480: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1481: fnd_message.set_name('CSF', 'CSF_ASSIGNMENT_UPDATE_FAIL');
1482: fnd_message.set_token('TASK', v_task.task_number);
1483: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1484: fnd_msg_pub.ADD;

Line 1483: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

1479:
1480: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1481: fnd_message.set_name('CSF', 'CSF_ASSIGNMENT_UPDATE_FAIL');
1482: fnd_message.set_token('TASK', v_task.task_number);
1483: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1484: fnd_msg_pub.ADD;
1485: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1486: RAISE fnd_api.g_exc_unexpected_error;
1487: END IF;

Line 1485: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1481: fnd_message.set_name('CSF', 'CSF_ASSIGNMENT_UPDATE_FAIL');
1482: fnd_message.set_token('TASK', v_task.task_number);
1483: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1484: fnd_msg_pub.ADD;
1485: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1486: RAISE fnd_api.g_exc_unexpected_error;
1487: END IF;
1488: RAISE fnd_api.g_exc_error;
1489: END IF;

Line 1486: RAISE fnd_api.g_exc_unexpected_error;

1482: fnd_message.set_token('TASK', v_task.task_number);
1483: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1484: fnd_msg_pub.ADD;
1485: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1486: RAISE fnd_api.g_exc_unexpected_error;
1487: END IF;
1488: RAISE fnd_api.g_exc_error;
1489: END IF;
1490: END LOOP;

Line 1488: RAISE fnd_api.g_exc_error;

1484: fnd_msg_pub.ADD;
1485: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1486: RAISE fnd_api.g_exc_unexpected_error;
1487: END IF;
1488: RAISE fnd_api.g_exc_error;
1489: END IF;
1490: END LOOP;
1491:
1492: -- Update the Availability of the Trip.

Line 1510: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1506: , p_object_version_number => p_object_version_number
1507: , p_available_hours => l_available_hours * g_hours_in_day
1508: );
1509:
1510: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1511: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1512: RAISE fnd_api.g_exc_unexpected_error;
1513: END IF;
1514: RAISE fnd_api.g_exc_error;

Line 1511: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1507: , p_available_hours => l_available_hours * g_hours_in_day
1508: );
1509:
1510: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1511: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1512: RAISE fnd_api.g_exc_unexpected_error;
1513: END IF;
1514: RAISE fnd_api.g_exc_error;
1515: END IF;

Line 1512: RAISE fnd_api.g_exc_unexpected_error;

1508: );
1509:
1510: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1511: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1512: RAISE fnd_api.g_exc_unexpected_error;
1513: END IF;
1514: RAISE fnd_api.g_exc_error;
1515: END IF;
1516: EXCEPTION

Line 1514: RAISE fnd_api.g_exc_error;

1510: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1511: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1512: RAISE fnd_api.g_exc_unexpected_error;
1513: END IF;
1514: RAISE fnd_api.g_exc_error;
1515: END IF;
1516: EXCEPTION
1517: WHEN fnd_api.g_exc_error THEN
1518: ROLLBACK TO csf_correct_trip;

Line 1517: WHEN fnd_api.g_exc_error THEN

1513: END IF;
1514: RAISE fnd_api.g_exc_error;
1515: END IF;
1516: EXCEPTION
1517: WHEN fnd_api.g_exc_error THEN
1518: ROLLBACK TO csf_correct_trip;
1519: x_return_status := fnd_api.g_ret_sts_error;
1520: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1521: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1519: x_return_status := fnd_api.g_ret_sts_error;

1515: END IF;
1516: EXCEPTION
1517: WHEN fnd_api.g_exc_error THEN
1518: ROLLBACK TO csf_correct_trip;
1519: x_return_status := fnd_api.g_ret_sts_error;
1520: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1521: WHEN fnd_api.g_exc_unexpected_error THEN
1522: ROLLBACK TO csf_correct_trip;
1523: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1521: WHEN fnd_api.g_exc_unexpected_error THEN

1517: WHEN fnd_api.g_exc_error THEN
1518: ROLLBACK TO csf_correct_trip;
1519: x_return_status := fnd_api.g_ret_sts_error;
1520: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1521: WHEN fnd_api.g_exc_unexpected_error THEN
1522: ROLLBACK TO csf_correct_trip;
1523: x_return_status := fnd_api.g_ret_sts_unexp_error;
1524: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1525: WHEN OTHERS THEN

Line 1523: x_return_status := fnd_api.g_ret_sts_unexp_error;

1519: x_return_status := fnd_api.g_ret_sts_error;
1520: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1521: WHEN fnd_api.g_exc_unexpected_error THEN
1522: ROLLBACK TO csf_correct_trip;
1523: x_return_status := fnd_api.g_ret_sts_unexp_error;
1524: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1525: WHEN OTHERS THEN
1526: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1527: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1527: x_return_status := fnd_api.g_ret_sts_unexp_error;

1523: x_return_status := fnd_api.g_ret_sts_unexp_error;
1524: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1525: WHEN OTHERS THEN
1526: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1527: x_return_status := fnd_api.g_ret_sts_unexp_error;
1528: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1529: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1530: END IF;
1531: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 1577: x_return_status := fnd_api.g_ret_sts_success;

1573: )IS
1574: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TRIPS';
1575: l_debug CONSTANT BOOLEAN := g_debug = 'Y';
1576: BEGIN
1577: x_return_status := fnd_api.g_ret_sts_success;
1578:
1579: IF l_debug THEN
1580: debug('Deleting the given Trips', l_api_name, fnd_log.level_procedure);
1581: END IF;

Line 1594: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1590: , p_trip => p_trips(i)
1591: , p_object_version_number => p_trips(i).object_version_number
1592: );
1593:
1594: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1595: add_message(
1596: p_trip => p_trips(i)
1597: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
1598: , p_msg_name => 'CSF_TRIP_DELETE_FAIL_OTHER'

Line 1597: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)

1593:
1594: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1595: add_message(
1596: p_trip => p_trips(i)
1597: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
1598: , p_msg_name => 'CSF_TRIP_DELETE_FAIL_OTHER'
1599: , p_msg_type => g_error_message
1600: );
1601: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1601: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1597: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
1598: , p_msg_name => 'CSF_TRIP_DELETE_FAIL_OTHER'
1599: , p_msg_type => g_error_message
1600: );
1601: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1602: RAISE fnd_api.g_exc_unexpected_error;
1603: END IF;
1604: ELSE
1605: add_message(p_trips(i));

Line 1602: RAISE fnd_api.g_exc_unexpected_error;

1598: , p_msg_name => 'CSF_TRIP_DELETE_FAIL_OTHER'
1599: , p_msg_type => g_error_message
1600: );
1601: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1602: RAISE fnd_api.g_exc_unexpected_error;
1603: END IF;
1604: ELSE
1605: add_message(p_trips(i));
1606: END IF;

Line 1610: WHEN fnd_api.g_exc_error THEN

1606: END IF;
1607: END IF;
1608: END LOOP;
1609: EXCEPTION
1610: WHEN fnd_api.g_exc_error THEN
1611: x_return_status := fnd_api.g_ret_sts_error;
1612: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1613: WHEN fnd_api.g_exc_unexpected_error THEN
1614: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1611: x_return_status := fnd_api.g_ret_sts_error;

1607: END IF;
1608: END LOOP;
1609: EXCEPTION
1610: WHEN fnd_api.g_exc_error THEN
1611: x_return_status := fnd_api.g_ret_sts_error;
1612: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1613: WHEN fnd_api.g_exc_unexpected_error THEN
1614: x_return_status := fnd_api.g_ret_sts_unexp_error;
1615: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 1613: WHEN fnd_api.g_exc_unexpected_error THEN

1609: EXCEPTION
1610: WHEN fnd_api.g_exc_error THEN
1611: x_return_status := fnd_api.g_ret_sts_error;
1612: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1613: WHEN fnd_api.g_exc_unexpected_error THEN
1614: x_return_status := fnd_api.g_ret_sts_unexp_error;
1615: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1616: WHEN OTHERS THEN
1617: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

Line 1614: x_return_status := fnd_api.g_ret_sts_unexp_error;

1610: WHEN fnd_api.g_exc_error THEN
1611: x_return_status := fnd_api.g_ret_sts_error;
1612: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1613: WHEN fnd_api.g_exc_unexpected_error THEN
1614: x_return_status := fnd_api.g_ret_sts_unexp_error;
1615: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1616: WHEN OTHERS THEN
1617: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1618: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1618: x_return_status := fnd_api.g_ret_sts_unexp_error;

1614: x_return_status := fnd_api.g_ret_sts_unexp_error;
1615: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1616: WHEN OTHERS THEN
1617: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1618: x_return_status := fnd_api.g_ret_sts_unexp_error;
1619: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1620: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1621: END IF;
1622: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 1634: x_return_status := fnd_api.g_ret_sts_success;

1630: ) IS
1631: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_TRIPS';
1632: l_debug CONSTANT BOOLEAN := g_debug = 'Y';
1633: BEGIN
1634: x_return_status := fnd_api.g_ret_sts_success;
1635:
1636: IF l_debug THEN
1637: debug('Fixing the given Trips', l_api_name, fnd_log.level_procedure);
1638: END IF;

Line 1649: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1645: , p_trip => p_trips(i)
1646: , p_object_version_number => p_trips(i).object_version_number
1647: );
1648:
1649: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1650: add_message(
1651: p_trip => p_trips(i)
1652: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
1653: , p_msg_name => 'CSF_TRIP_FIX_FAIL_OTHER'

Line 1652: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)

1648:
1649: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1650: add_message(
1651: p_trip => p_trips(i)
1652: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
1653: , p_msg_name => 'CSF_TRIP_FIX_FAIL_OTHER'
1654: , p_msg_type => g_error_message
1655: );
1656: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1656: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1652: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
1653: , p_msg_name => 'CSF_TRIP_FIX_FAIL_OTHER'
1654: , p_msg_type => g_error_message
1655: );
1656: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1657: RAISE fnd_api.g_exc_unexpected_error;
1658: END IF;
1659: ELSE
1660: add_message(p_trips(i));

Line 1657: RAISE fnd_api.g_exc_unexpected_error;

1653: , p_msg_name => 'CSF_TRIP_FIX_FAIL_OTHER'
1654: , p_msg_type => g_error_message
1655: );
1656: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1657: RAISE fnd_api.g_exc_unexpected_error;
1658: END IF;
1659: ELSE
1660: add_message(p_trips(i));
1661: END IF;

Line 1664: WHEN fnd_api.g_exc_error THEN

1660: add_message(p_trips(i));
1661: END IF;
1662: END LOOP;
1663: EXCEPTION
1664: WHEN fnd_api.g_exc_error THEN
1665: x_return_status := fnd_api.g_ret_sts_error;
1666: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1667: WHEN fnd_api.g_exc_unexpected_error THEN
1668: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1665: x_return_status := fnd_api.g_ret_sts_error;

1661: END IF;
1662: END LOOP;
1663: EXCEPTION
1664: WHEN fnd_api.g_exc_error THEN
1665: x_return_status := fnd_api.g_ret_sts_error;
1666: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1667: WHEN fnd_api.g_exc_unexpected_error THEN
1668: x_return_status := fnd_api.g_ret_sts_unexp_error;
1669: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 1667: WHEN fnd_api.g_exc_unexpected_error THEN

1663: EXCEPTION
1664: WHEN fnd_api.g_exc_error THEN
1665: x_return_status := fnd_api.g_ret_sts_error;
1666: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1667: WHEN fnd_api.g_exc_unexpected_error THEN
1668: x_return_status := fnd_api.g_ret_sts_unexp_error;
1669: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1670: WHEN OTHERS THEN
1671: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

Line 1668: x_return_status := fnd_api.g_ret_sts_unexp_error;

1664: WHEN fnd_api.g_exc_error THEN
1665: x_return_status := fnd_api.g_ret_sts_error;
1666: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1667: WHEN fnd_api.g_exc_unexpected_error THEN
1668: x_return_status := fnd_api.g_ret_sts_unexp_error;
1669: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1670: WHEN OTHERS THEN
1671: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1672: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1672: x_return_status := fnd_api.g_ret_sts_unexp_error;

1668: x_return_status := fnd_api.g_ret_sts_unexp_error;
1669: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1670: WHEN OTHERS THEN
1671: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1672: x_return_status := fnd_api.g_ret_sts_unexp_error;
1673: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1674: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1675: END IF;
1676: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 1792: x_return_status := fnd_api.g_ret_sts_success;

1788:
1789: BEGIN
1790: SAVEPOINT csf_create_trips;
1791:
1792: x_return_status := fnd_api.g_ret_sts_success;
1793:
1794: l_res_id := p_resource_tbl(1).resource_id;
1795: l_res_type := p_resource_tbl(1).resource_type;
1796:

Line 1819: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1815: , p_shift_type => p_shift_type
1816: , x_shifts => l_shifts
1817: );
1818:
1819: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1820: IF l_debug THEN
1821: debug(' No Shifts were found for the resource between the timeframe', l_api_name, fnd_log.level_error);
1822: END IF;
1823: add_message(

Line 1828: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)

1824: p_res_id => l_res_id
1825: , p_res_type => l_res_type
1826: , p_start => p_start_date
1827: , p_end => p_end_date
1828: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
1829: , p_msg_name => 'CSF_RETRIEVE_SHIFTS_FAIL'
1830: , p_msg_type => g_error_message
1831: );
1832: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1832: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1828: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
1829: , p_msg_name => 'CSF_RETRIEVE_SHIFTS_FAIL'
1830: , p_msg_type => g_error_message
1831: );
1832: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1833: RAISE fnd_api.g_exc_unexpected_error;
1834: END IF;
1835: --RAISE fnd_api.g_exc_error;
1836: END IF;

Line 1833: RAISE fnd_api.g_exc_unexpected_error;

1829: , p_msg_name => 'CSF_RETRIEVE_SHIFTS_FAIL'
1830: , p_msg_type => g_error_message
1831: );
1832: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1833: RAISE fnd_api.g_exc_unexpected_error;
1834: END IF;
1835: --RAISE fnd_api.g_exc_error;
1836: END IF;
1837: if l_shifts.count >0 then

Line 1835: --RAISE fnd_api.g_exc_error;

1831: );
1832: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1833: RAISE fnd_api.g_exc_unexpected_error;
1834: END IF;
1835: --RAISE fnd_api.g_exc_error;
1836: END IF;
1837: if l_shifts.count >0 then
1838: -- Check whether Shift Tasks are already there between the given Time Frame.
1839: l_start := l_shifts(l_shifts.FIRST).start_datetime;

Line 1863: RAISE fnd_api.g_exc_error;

1859: , p_end => p_end_date
1860: , p_msg_name => 'CSF_USE_UPGRADE_TRIPS'
1861: , p_msg_type => g_error_message
1862: );
1863: RAISE fnd_api.g_exc_error;
1864: END IF;
1865:
1866: -- Get all the trips in the required interval
1867: l_start := LEAST(p_start_date, l_shifts(l_shifts.FIRST).start_datetime);

Line 1901: x_return_status := fnd_api.g_ret_sts_success;

1897: THEN
1898: BEGIN
1899: SAVEPOINT csf_process_shift;
1900: l_old_trips := find_trips(p_resource_tbl, l_shift_old_start, l_shift_old_end);
1901: x_return_status := fnd_api.g_ret_sts_success;
1902:
1903: l_start := l_shifts(l_shift_idx).start_datetime;
1904: l_end := l_shifts(l_shift_idx).end_datetime;
1905: g_shift_type := l_shifts(l_shift_idx).availability_type;

Line 1935: RAISE fnd_api.g_exc_error;

1931: IF l_debug THEN
1932: debug(' Error : CSF_TRIP_CREATE_FAIL_DUP ' , l_api_name, fnd_log.level_error);
1933: END IF;
1934: l_msg_name := 'CSF_TRIP_CREATE_FAIL_DUP';
1935: RAISE fnd_api.g_exc_error;
1936: END IF;
1937: IF l_debug THEN
1938: debug(' Time Overlaps so calling remove trip ' , l_api_name, fnd_log.level_statement);
1939: END IF;

Line 1946: , p_check_active_tasks => fnd_api.g_false

1942: , x_msg_data => x_msg_data
1943: , x_msg_count => x_msg_count
1944: , p_trip => l_old_trips(l_trip_idx)
1945: , p_object_version_number => l_old_trips(l_trip_idx).object_version_number
1946: , p_check_active_tasks => fnd_api.g_false
1947: );
1948:
1949: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1950: IF l_debug THEN

Line 1949: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1945: , p_object_version_number => l_old_trips(l_trip_idx).object_version_number
1946: , p_check_active_tasks => fnd_api.g_false
1947: );
1948:
1949: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1950: IF l_debug THEN
1951: debug(' remove_trip Error : CSF_TRIP_DELETE_FAIL_OTHER ' , l_api_name, fnd_log.level_error);
1952: END IF;
1953: l_msg_name := 'CSF_TRIP_DELETE_FAIL_OTHER';

Line 1954: RAISE fnd_api.g_exc_error;

1950: IF l_debug THEN
1951: debug(' remove_trip Error : CSF_TRIP_DELETE_FAIL_OTHER ' , l_api_name, fnd_log.level_error);
1952: END IF;
1953: l_msg_name := 'CSF_TRIP_DELETE_FAIL_OTHER';
1954: RAISE fnd_api.g_exc_error;
1955: END IF;
1956:
1957: -- Since Trip is not present in DB... it should be removed from memory too.
1958: l_temp_trip_tbl(l_temp_trip_tbl.COUNT+1) := l_old_trips(l_trip_idx).trip_id;

Line 1979: RAISE fnd_api.g_exc_error;

1975: , l_api_name, fnd_log.level_statement);
1976: END IF;
1977: IF time_overlaps(l_new_trips(l_trip_idx), l_shifts(l_shift_idx)) THEN
1978: l_msg_name := 'CSF_TRIP_CREATE_FAIL_DUP';
1979: RAISE fnd_api.g_exc_error;
1980: ELSIF (l_new_trips(l_trip_idx).end_date_time + g_overtime) < l_start THEN
1981: -- Since Trips and Shifts are ordered by time, there is no point in searching forward
1982: EXIT;
1983: END IF;

Line 1995: , p_find_tasks => fnd_api.g_true

1991: , p_resource_id => l_res_id
1992: , p_resource_type => l_res_type
1993: , p_start_date_time => l_start
1994: , p_end_date_time => l_end
1995: , p_find_tasks => fnd_api.g_true
1996: , x_trip => l_new_trip
1997: );
1998:
1999: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 1999: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1995: , p_find_tasks => fnd_api.g_true
1996: , x_trip => l_new_trip
1997: );
1998:
1999: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2000: l_msg_name := 'CSF_TRIP_CREATE_FAIL_OTHER';
2001: RAISE fnd_api.g_exc_error;
2002: END IF;
2003:

Line 2001: RAISE fnd_api.g_exc_error;

1997: );
1998:
1999: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2000: l_msg_name := 'CSF_TRIP_CREATE_FAIL_OTHER';
2001: RAISE fnd_api.g_exc_error;
2002: END IF;
2003:
2004: -- Since the Old Trips are removed from Database and there is no error
2005: -- encountered we can remove the Old Trips from Memory also

Line 2041: l_reason := fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false);

2037: l_start := l_old_trips(l_trip_idx).start_date_time;
2038: l_end := l_old_trips(l_trip_idx).end_date_time;
2039: END IF;
2040: IF l_msg_name <> 'CSF_TRIP_CREATE_FAIL_DUP' THEN
2041: l_reason := fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false);
2042: ELSE
2043: l_reason := NULL;
2044: END IF;
2045:

Line 2081: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2077: , p_reason => l_reason
2078: , p_msg_name => l_msg_name
2079: , p_msg_type => g_error_message
2080: );
2081: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2082: RAISE fnd_api.g_exc_unexpected_error;
2083: END IF;
2084: END;
2085: END IF;

Line 2082: RAISE fnd_api.g_exc_unexpected_error;

2078: , p_msg_name => l_msg_name
2079: , p_msg_type => g_error_message
2080: );
2081: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2082: RAISE fnd_api.g_exc_unexpected_error;
2083: END IF;
2084: END;
2085: END IF;
2086: l_shift_idx := l_shifts.NEXT(l_shift_idx);

Line 2125: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2121: , p_object_version_number => l_trip_info.object_version_number
2122: , p_available_hours => l_trip_info.available_hours
2123: );
2124:
2125: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2126: IF l_debug THEN
2127: debug( ' Error updating Trip. ' || fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false), l_api_name, fnd_log.level_error);
2128: END IF;
2129: END IF;

Line 2127: debug( ' Error updating Trip. ' || fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false), l_api_name, fnd_log.level_error);

2123: );
2124:
2125: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2126: IF l_debug THEN
2127: debug( ' Error updating Trip. ' || fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false), l_api_name, fnd_log.level_error);
2128: END IF;
2129: END IF;
2130:
2131: l_trip_length := 0;

Line 2154: , p_enable_workflow => fnd_api.g_miss_char

2150: , x_msg_count => x_msg_count
2151: , p_task_assignment_id => v_task.task_assignment_id
2152: , p_object_version_number => v_task.object_version_number
2153: , p_object_capacity_id => l_new_trips(l_trip_idx).trip_id
2154: , p_enable_workflow => fnd_api.g_miss_char
2155: , p_abort_workflow => fnd_api.g_miss_char
2156: );
2157:
2158: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 2155: , p_abort_workflow => fnd_api.g_miss_char

2151: , p_task_assignment_id => v_task.task_assignment_id
2152: , p_object_version_number => v_task.object_version_number
2153: , p_object_capacity_id => l_new_trips(l_trip_idx).trip_id
2154: , p_enable_workflow => fnd_api.g_miss_char
2155: , p_abort_workflow => fnd_api.g_miss_char
2156: );
2157:
2158: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2159: IF l_debug THEN

Line 2158: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2154: , p_enable_workflow => fnd_api.g_miss_char
2155: , p_abort_workflow => fnd_api.g_miss_char
2156: );
2157:
2158: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2159: IF l_debug THEN
2160: debug( ' Error updating Task Assignment', l_api_name, fnd_log.level_error);
2161: END IF;
2162: add_message(

Line 2167: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)

2163: p_res_id => l_res_id
2164: , p_res_type => l_res_type
2165: , p_start => p_start_date
2166: , p_end => p_end_date
2167: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
2168: , p_msg_name => 'CSF_TRIP_REPLACE_FAIL_RELINK'
2169: , p_msg_type => g_error_message
2170: );
2171: RAISE fnd_api.g_exc_error;

Line 2171: RAISE fnd_api.g_exc_error;

2167: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
2168: , p_msg_name => 'CSF_TRIP_REPLACE_FAIL_RELINK'
2169: , p_msg_type => g_error_message
2170: );
2171: RAISE fnd_api.g_exc_error;
2172: END IF;
2173:
2174: -- Moment we encounter a Task linked to old trip.. we have a conflict.
2175: IF l_prev_trip_id IS NULL OR l_prev_trip_id <> l_new_trips(l_trip_idx).trip_id THEN

Line 2226: , p_check_active_tasks => fnd_api.g_true

2222: , x_msg_data => x_msg_data
2223: , x_msg_count => x_msg_count
2224: , p_trip => l_old_trips_temp(l_trip_idx)
2225: , p_object_version_number => l_old_trips_temp(l_trip_idx).object_version_number
2226: , p_check_active_tasks => fnd_api.g_true
2227: );
2228:
2229: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2230: add_message(

Line 2229: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2225: , p_object_version_number => l_old_trips_temp(l_trip_idx).object_version_number
2226: , p_check_active_tasks => fnd_api.g_true
2227: );
2228:
2229: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2230: add_message(
2231: p_trip => l_old_trips_temp(l_trip_idx)
2232: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
2233: , p_msg_name => 'CSF_TRIP_DELETE_FAIL_OTHER'

Line 2232: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)

2228:
2229: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2230: add_message(
2231: p_trip => l_old_trips_temp(l_trip_idx)
2232: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
2233: , p_msg_name => 'CSF_TRIP_DELETE_FAIL_OTHER'
2234: , p_msg_type => g_error_message
2235: );
2236:

Line 2237: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2233: , p_msg_name => 'CSF_TRIP_DELETE_FAIL_OTHER'
2234: , p_msg_type => g_error_message
2235: );
2236:
2237: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2238: RAISE fnd_api.g_exc_unexpected_error;
2239: END IF;
2240: ELSE
2241: add_message(l_old_trips_temp(l_trip_idx));

Line 2238: RAISE fnd_api.g_exc_unexpected_error;

2234: , p_msg_type => g_error_message
2235: );
2236:
2237: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2238: RAISE fnd_api.g_exc_unexpected_error;
2239: END IF;
2240: ELSE
2241: add_message(l_old_trips_temp(l_trip_idx));
2242: END IF;

Line 2300: , p_check_active_tasks => fnd_api.g_true

2296: , x_msg_data => x_msg_data
2297: , x_msg_count => x_msg_count
2298: , p_trip => l_old_trips(l_trip_idx)
2299: , p_object_version_number => l_old_trips(l_trip_idx).object_version_number
2300: , p_check_active_tasks => fnd_api.g_true
2301: );
2302: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2303: add_message(
2304: p_trip => l_old_trips(l_trip_idx)

Line 2302: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2298: , p_trip => l_old_trips(l_trip_idx)
2299: , p_object_version_number => l_old_trips(l_trip_idx).object_version_number
2300: , p_check_active_tasks => fnd_api.g_true
2301: );
2302: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2303: add_message(
2304: p_trip => l_old_trips(l_trip_idx)
2305: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
2306: , p_msg_name => 'CSF_TRIP_DELETE_FAIL_OTHER'

Line 2305: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)

2301: );
2302: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2303: add_message(
2304: p_trip => l_old_trips(l_trip_idx)
2305: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
2306: , p_msg_name => 'CSF_TRIP_DELETE_FAIL_OTHER'
2307: , p_msg_type => g_error_message
2308: );
2309: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 2309: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2305: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
2306: , p_msg_name => 'CSF_TRIP_DELETE_FAIL_OTHER'
2307: , p_msg_type => g_error_message
2308: );
2309: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2310: RAISE fnd_api.g_exc_unexpected_error;
2311: END IF;
2312: ELSE
2313: add_message(

Line 2310: RAISE fnd_api.g_exc_unexpected_error;

2306: , p_msg_name => 'CSF_TRIP_DELETE_FAIL_OTHER'
2307: , p_msg_type => g_error_message
2308: );
2309: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2310: RAISE fnd_api.g_exc_unexpected_error;
2311: END IF;
2312: ELSE
2313: add_message(
2314: p_res_id => l_res_id

Line 2328: WHEN fnd_api.g_exc_error THEN

2324: l_trip_idx := l_old_trips.NEXT(l_trip_idx);
2325: END LOOP;
2326: end if;
2327: EXCEPTION
2328: WHEN fnd_api.g_exc_error THEN
2329: ROLLBACK TO csf_create_trips;
2330: x_return_status := fnd_api.g_ret_sts_error;
2331: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2332: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2330: x_return_status := fnd_api.g_ret_sts_error;

2326: end if;
2327: EXCEPTION
2328: WHEN fnd_api.g_exc_error THEN
2329: ROLLBACK TO csf_create_trips;
2330: x_return_status := fnd_api.g_ret_sts_error;
2331: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2332: WHEN fnd_api.g_exc_unexpected_error THEN
2333: ROLLBACK TO csf_create_trips;
2334: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2332: WHEN fnd_api.g_exc_unexpected_error THEN

2328: WHEN fnd_api.g_exc_error THEN
2329: ROLLBACK TO csf_create_trips;
2330: x_return_status := fnd_api.g_ret_sts_error;
2331: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2332: WHEN fnd_api.g_exc_unexpected_error THEN
2333: ROLLBACK TO csf_create_trips;
2334: x_return_status := fnd_api.g_ret_sts_unexp_error;
2335: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2336: WHEN OTHERS THEN

Line 2334: x_return_status := fnd_api.g_ret_sts_unexp_error;

2330: x_return_status := fnd_api.g_ret_sts_error;
2331: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2332: WHEN fnd_api.g_exc_unexpected_error THEN
2333: ROLLBACK TO csf_create_trips;
2334: x_return_status := fnd_api.g_ret_sts_unexp_error;
2335: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2336: WHEN OTHERS THEN
2337: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2338: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2338: x_return_status := fnd_api.g_ret_sts_unexp_error;

2334: x_return_status := fnd_api.g_ret_sts_unexp_error;
2335: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2336: WHEN OTHERS THEN
2337: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2338: x_return_status := fnd_api.g_ret_sts_unexp_error;
2339: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2340: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2341: END IF;
2342: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 2429: x_return_status := fnd_api.g_ret_sts_success;

2425: AND dta.shift_construct_id = ata.shift_construct_id
2426: ORDER BY d.planned_start_date;
2427:
2428: BEGIN
2429: x_return_status := fnd_api.g_ret_sts_success;
2430:
2431: IF l_debug THEN
2432: debug('Upgrading to Trips for Resource#' || p_resource_tbl(1).resource_id || ' between ' || p_start_date || ' and ' || p_end_date, l_api_name, fnd_log.level_procedure);
2433: END IF;

Line 2458: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2454: , p_arr_task_id => l_arr_task_tbl(i)
2455: , x_trip => l_new_trip
2456: );
2457:
2458: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2459: add_message(
2460: p_res_id => p_resource_tbl(1).resource_id
2461: , p_res_type => p_resource_tbl(1).resource_type
2462: , p_start => l_start_time_tbl(i)

Line 2464: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)

2460: p_res_id => p_resource_tbl(1).resource_id
2461: , p_res_type => p_resource_tbl(1).resource_type
2462: , p_start => l_start_time_tbl(i)
2463: , p_end => l_end_time_tbl(i)
2464: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
2465: , p_msg_name => 'CSF_TRIP_CREATE_FAIL_OTHER'
2466: , p_msg_type => g_error_message
2467: );
2468: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 2468: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2464: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
2465: , p_msg_name => 'CSF_TRIP_CREATE_FAIL_OTHER'
2466: , p_msg_type => g_error_message
2467: );
2468: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2469: RAISE fnd_api.g_exc_unexpected_error;
2470: END IF;
2471: ELSE
2472: add_message(

Line 2469: RAISE fnd_api.g_exc_unexpected_error;

2465: , p_msg_name => 'CSF_TRIP_CREATE_FAIL_OTHER'
2466: , p_msg_type => g_error_message
2467: );
2468: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2469: RAISE fnd_api.g_exc_unexpected_error;
2470: END IF;
2471: ELSE
2472: add_message(
2473: p_res_id => p_resource_tbl(1).resource_id

Line 2481: WHEN fnd_api.g_exc_error THEN

2477: );
2478: END IF;
2479: END LOOP;
2480: EXCEPTION
2481: WHEN fnd_api.g_exc_error THEN
2482: x_return_status := fnd_api.g_ret_sts_error;
2483: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2484: WHEN fnd_api.g_exc_unexpected_error THEN
2485: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2482: x_return_status := fnd_api.g_ret_sts_error;

2478: END IF;
2479: END LOOP;
2480: EXCEPTION
2481: WHEN fnd_api.g_exc_error THEN
2482: x_return_status := fnd_api.g_ret_sts_error;
2483: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2484: WHEN fnd_api.g_exc_unexpected_error THEN
2485: x_return_status := fnd_api.g_ret_sts_unexp_error;
2486: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 2484: WHEN fnd_api.g_exc_unexpected_error THEN

2480: EXCEPTION
2481: WHEN fnd_api.g_exc_error THEN
2482: x_return_status := fnd_api.g_ret_sts_error;
2483: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2484: WHEN fnd_api.g_exc_unexpected_error THEN
2485: x_return_status := fnd_api.g_ret_sts_unexp_error;
2486: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2487: WHEN OTHERS THEN
2488: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

Line 2485: x_return_status := fnd_api.g_ret_sts_unexp_error;

2481: WHEN fnd_api.g_exc_error THEN
2482: x_return_status := fnd_api.g_ret_sts_error;
2483: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2484: WHEN fnd_api.g_exc_unexpected_error THEN
2485: x_return_status := fnd_api.g_ret_sts_unexp_error;
2486: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2487: WHEN OTHERS THEN
2488: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2489: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2489: x_return_status := fnd_api.g_ret_sts_unexp_error;

2485: x_return_status := fnd_api.g_ret_sts_unexp_error;
2486: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2487: WHEN OTHERS THEN
2488: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2489: x_return_status := fnd_api.g_ret_sts_unexp_error;
2490: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2491: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2492: END IF;
2493: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 2509: x_return_status := fnd_api.g_ret_sts_success;

2505:
2506: l_new_trip_status NUMBER;
2507: l_trip_action VARCHAR2(30);
2508: BEGIN
2509: x_return_status := fnd_api.g_ret_sts_success;
2510:
2511: IF l_debug THEN
2512: debug('Updating the status of the given trips', l_api_name, fnd_log.level_procedure);
2513: END IF;

Line 2561: , p_update_tasks => fnd_api.g_true

2557: , x_msg_count => x_msg_count
2558: , p_trip => p_trips(i)
2559: , p_object_version_number => p_trips(i).object_version_number
2560: , p_status => l_new_trip_status
2561: , p_update_tasks => fnd_api.g_true
2562: , p_task_action => l_trip_action
2563: );
2564:
2565: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 2565: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2561: , p_update_tasks => fnd_api.g_true
2562: , p_task_action => l_trip_action
2563: );
2564:
2565: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2566: add_message(
2567: p_trip => p_trips(i)
2568: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
2569: , p_msg_name => 'CSF_TRIP_UPDATE_FAIL_OTHER'

Line 2568: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)

2564:
2565: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2566: add_message(
2567: p_trip => p_trips(i)
2568: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
2569: , p_msg_name => 'CSF_TRIP_UPDATE_FAIL_OTHER'
2570: , p_msg_type => g_error_message
2571: );
2572: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 2572: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2568: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
2569: , p_msg_name => 'CSF_TRIP_UPDATE_FAIL_OTHER'
2570: , p_msg_type => g_error_message
2571: );
2572: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2573: RAISE fnd_api.g_exc_unexpected_error;
2574: END IF;
2575: ELSE
2576: add_message(p_trips(i));

Line 2573: RAISE fnd_api.g_exc_unexpected_error;

2569: , p_msg_name => 'CSF_TRIP_UPDATE_FAIL_OTHER'
2570: , p_msg_type => g_error_message
2571: );
2572: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2573: RAISE fnd_api.g_exc_unexpected_error;
2574: END IF;
2575: ELSE
2576: add_message(p_trips(i));
2577: END IF;

Line 2583: WHEN fnd_api.g_exc_error THEN

2579: <>
2580: NULL;
2581: END LOOP;
2582: EXCEPTION
2583: WHEN fnd_api.g_exc_error THEN
2584: x_return_status := fnd_api.g_ret_sts_error;
2585: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2586: WHEN fnd_api.g_exc_unexpected_error THEN
2587: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2584: x_return_status := fnd_api.g_ret_sts_error;

2580: NULL;
2581: END LOOP;
2582: EXCEPTION
2583: WHEN fnd_api.g_exc_error THEN
2584: x_return_status := fnd_api.g_ret_sts_error;
2585: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2586: WHEN fnd_api.g_exc_unexpected_error THEN
2587: x_return_status := fnd_api.g_ret_sts_unexp_error;
2588: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 2586: WHEN fnd_api.g_exc_unexpected_error THEN

2582: EXCEPTION
2583: WHEN fnd_api.g_exc_error THEN
2584: x_return_status := fnd_api.g_ret_sts_error;
2585: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2586: WHEN fnd_api.g_exc_unexpected_error THEN
2587: x_return_status := fnd_api.g_ret_sts_unexp_error;
2588: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2589: WHEN OTHERS THEN
2590: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

Line 2587: x_return_status := fnd_api.g_ret_sts_unexp_error;

2583: WHEN fnd_api.g_exc_error THEN
2584: x_return_status := fnd_api.g_ret_sts_error;
2585: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2586: WHEN fnd_api.g_exc_unexpected_error THEN
2587: x_return_status := fnd_api.g_ret_sts_unexp_error;
2588: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2589: WHEN OTHERS THEN
2590: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2591: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2591: x_return_status := fnd_api.g_ret_sts_unexp_error;

2587: x_return_status := fnd_api.g_ret_sts_unexp_error;
2588: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2589: WHEN OTHERS THEN
2590: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2591: x_return_status := fnd_api.g_ret_sts_unexp_error;
2592: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2593: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2594: END IF;
2595: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

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

2640: AND NVL(t.deleted_flag, 'N') = 'N'
2641: AND ROWNUM = 1;
2642: BEGIN
2643: -- Check for API Compatibility
2644: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2645: RAISE fnd_api.g_exc_unexpected_error;
2646: END IF;
2647:
2648: -- Initialize Message Stack if required

Line 2645: RAISE fnd_api.g_exc_unexpected_error;

2641: AND ROWNUM = 1;
2642: BEGIN
2643: -- Check for API Compatibility
2644: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2645: RAISE fnd_api.g_exc_unexpected_error;
2646: END IF;
2647:
2648: -- Initialize Message Stack if required
2649: IF p_init_msg_list = fnd_api.g_true THEN

Line 2649: IF p_init_msg_list = fnd_api.g_true THEN

2645: RAISE fnd_api.g_exc_unexpected_error;
2646: END IF;
2647:
2648: -- Initialize Message Stack if required
2649: IF p_init_msg_list = fnd_api.g_true THEN
2650: fnd_msg_pub.initialize;
2651: END IF;
2652:
2653: -- Initialize Return Status

Line 2654: x_return_status := fnd_api.g_ret_sts_success;

2650: fnd_msg_pub.initialize;
2651: END IF;
2652:
2653: -- Initialize Return Status
2654: x_return_status := fnd_api.g_ret_sts_success;
2655:
2656: IF l_debug THEN
2657: debug('Creating a Trip for Resource#' || p_resource_id || ' between '
2658: || to_char(p_start_date_time, 'DD-MON-YYYY HH24:MI:SS') || ' and '

Line 2678: RAISE fnd_api.g_exc_error;

2674: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2675: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2676: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2677: fnd_msg_pub.ADD;
2678: RAISE fnd_api.g_exc_error;
2679: END IF;
2680:
2681: -- Check#2 - No Shift Tasks in the Interval where the Trip is going to be created.
2682: IF l_debug THEN

Line 2702: RAISE fnd_api.g_exc_error;

2698: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2699: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2700: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2701: fnd_msg_pub.ADD;
2702: RAISE fnd_api.g_exc_error;
2703: END IF;
2704:
2705: -- All validations passed. Create the Trip.
2706: new_trip(

Line 2720: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2716: , p_find_tasks => p_find_tasks
2717: , x_trip => l_new_trip
2718: );
2719:
2720: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2721: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
2722: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2723: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2724: fnd_message.set_token('END_TIME', format_date(p_end_date_time));

Line 2725: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

2721: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
2722: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2723: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2724: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2725: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2726: fnd_msg_pub.ADD;
2727: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2728: RAISE fnd_api.g_exc_unexpected_error;
2729: END IF;

Line 2727: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2723: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2724: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2725: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2726: fnd_msg_pub.ADD;
2727: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2728: RAISE fnd_api.g_exc_unexpected_error;
2729: END IF;
2730: RAISE fnd_api.g_exc_error;
2731: END IF;

Line 2728: RAISE fnd_api.g_exc_unexpected_error;

2724: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2725: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2726: fnd_msg_pub.ADD;
2727: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2728: RAISE fnd_api.g_exc_unexpected_error;
2729: END IF;
2730: RAISE fnd_api.g_exc_error;
2731: END IF;
2732:

Line 2730: RAISE fnd_api.g_exc_error;

2726: fnd_msg_pub.ADD;
2727: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2728: RAISE fnd_api.g_exc_unexpected_error;
2729: END IF;
2730: RAISE fnd_api.g_exc_error;
2731: END IF;
2732:
2733: x_trip_id := l_new_trip.trip_id;
2734:

Line 2735: IF fnd_api.to_boolean(p_commit) THEN

2731: END IF;
2732:
2733: x_trip_id := l_new_trip.trip_id;
2734:
2735: IF fnd_api.to_boolean(p_commit) THEN
2736: COMMIT;
2737: END IF;
2738:
2739: EXCEPTION

Line 2740: WHEN fnd_api.g_exc_error THEN

2736: COMMIT;
2737: END IF;
2738:
2739: EXCEPTION
2740: WHEN fnd_api.g_exc_error THEN
2741: x_return_status := fnd_api.g_ret_sts_error;
2742: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2743: WHEN fnd_api.g_exc_unexpected_error THEN
2744: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2741: x_return_status := fnd_api.g_ret_sts_error;

2737: END IF;
2738:
2739: EXCEPTION
2740: WHEN fnd_api.g_exc_error THEN
2741: x_return_status := fnd_api.g_ret_sts_error;
2742: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2743: WHEN fnd_api.g_exc_unexpected_error THEN
2744: x_return_status := fnd_api.g_ret_sts_unexp_error;
2745: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 2743: WHEN fnd_api.g_exc_unexpected_error THEN

2739: EXCEPTION
2740: WHEN fnd_api.g_exc_error THEN
2741: x_return_status := fnd_api.g_ret_sts_error;
2742: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2743: WHEN fnd_api.g_exc_unexpected_error THEN
2744: x_return_status := fnd_api.g_ret_sts_unexp_error;
2745: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2746: WHEN OTHERS THEN
2747: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

Line 2744: x_return_status := fnd_api.g_ret_sts_unexp_error;

2740: WHEN fnd_api.g_exc_error THEN
2741: x_return_status := fnd_api.g_ret_sts_error;
2742: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2743: WHEN fnd_api.g_exc_unexpected_error THEN
2744: x_return_status := fnd_api.g_ret_sts_unexp_error;
2745: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2746: WHEN OTHERS THEN
2747: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2748: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2748: x_return_status := fnd_api.g_ret_sts_unexp_error;

2744: x_return_status := fnd_api.g_ret_sts_unexp_error;
2745: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2746: WHEN OTHERS THEN
2747: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2748: x_return_status := fnd_api.g_ret_sts_unexp_error;
2749: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2750: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2751: END IF;
2752: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

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

2776:
2777: l_trip trip_rec_type;
2778: BEGIN
2779: -- Check for API Compatibility
2780: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2781: RAISE fnd_api.g_exc_unexpected_error;
2782: END IF;
2783:
2784: -- Initialize Message Stack if required

Line 2781: RAISE fnd_api.g_exc_unexpected_error;

2777: l_trip trip_rec_type;
2778: BEGIN
2779: -- Check for API Compatibility
2780: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2781: RAISE fnd_api.g_exc_unexpected_error;
2782: END IF;
2783:
2784: -- Initialize Message Stack if required
2785: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 2785: IF fnd_api.to_boolean(p_init_msg_list) THEN

2781: RAISE fnd_api.g_exc_unexpected_error;
2782: END IF;
2783:
2784: -- Initialize Message Stack if required
2785: IF fnd_api.to_boolean(p_init_msg_list) THEN
2786: fnd_msg_pub.initialize;
2787: END IF;
2788:
2789: -- Initialize Return Status

Line 2790: x_return_status := fnd_api.g_ret_sts_success;

2786: fnd_msg_pub.initialize;
2787: END IF;
2788:
2789: -- Initialize Return Status
2790: x_return_status := fnd_api.g_ret_sts_success;
2791:
2792: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
2793: -- Invalid Trip ID passed.
2794: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');

Line 2792: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN

2788:
2789: -- Initialize Return Status
2790: x_return_status := fnd_api.g_ret_sts_success;
2791:
2792: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
2793: -- Invalid Trip ID passed.
2794: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2795: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2796: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');

Line 2798: RAISE fnd_api.g_exc_error;

2794: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2795: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2796: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
2797: fnd_msg_pub.ADD;
2798: RAISE fnd_api.g_exc_error;
2799: END IF;
2800:
2801: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
2802: -- Invalid Object Version Number passed.

Line 2801: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN

2797: fnd_msg_pub.ADD;
2798: RAISE fnd_api.g_exc_error;
2799: END IF;
2800:
2801: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
2802: -- Invalid Object Version Number passed.
2803: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2804: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2805: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');

Line 2807: RAISE fnd_api.g_exc_error;

2803: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2804: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2805: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
2806: fnd_msg_pub.ADD;
2807: RAISE fnd_api.g_exc_error;
2808: END IF;
2809:
2810: IF p_available_hours IS NOT NULL AND p_upd_available_hours IS NOT NULL THEN
2811: -- Error out as both cant be passed.

Line 2816: RAISE fnd_api.g_exc_error;

2812: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2813: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2814: fnd_message.set_token('PARAM_NAME', 'P_UPD_AVAILABLE_HOURS');
2815: fnd_msg_pub.ADD;
2816: RAISE fnd_api.g_exc_error;
2817: END IF;
2818:
2819: l_trip := get_trip(p_trip_id);
2820: IF l_trip.trip_id IS NULL THEN

Line 2824: RAISE fnd_api.g_exc_error;

2820: IF l_trip.trip_id IS NULL THEN
2821: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
2822: fnd_message.set_token('TRIP_ID', p_trip_id);
2823: fnd_msg_pub.ADD;
2824: RAISE fnd_api.g_exc_error;
2825: END IF;
2826:
2827: change_trip(
2828: x_return_status => x_return_status

Line 2840: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2836: , p_available_hours_after => p_available_hours_after
2837: , p_status => p_status
2838: );
2839:
2840: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2841: fnd_message.set_name('CSF', 'CSF_TRIP_UPDATE_FAIL_OTHER');
2842: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2843: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2844: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));

Line 2845: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

2841: fnd_message.set_name('CSF', 'CSF_TRIP_UPDATE_FAIL_OTHER');
2842: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2843: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2844: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2845: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2846: fnd_msg_pub.ADD;
2847: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2848: RAISE fnd_api.g_exc_unexpected_error;
2849: END IF;

Line 2847: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2843: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2844: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2845: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2846: fnd_msg_pub.ADD;
2847: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2848: RAISE fnd_api.g_exc_unexpected_error;
2849: END IF;
2850: RAISE fnd_api.g_exc_error;
2851: END IF;

Line 2848: RAISE fnd_api.g_exc_unexpected_error;

2844: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2845: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2846: fnd_msg_pub.ADD;
2847: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2848: RAISE fnd_api.g_exc_unexpected_error;
2849: END IF;
2850: RAISE fnd_api.g_exc_error;
2851: END IF;
2852:

Line 2850: RAISE fnd_api.g_exc_error;

2846: fnd_msg_pub.ADD;
2847: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2848: RAISE fnd_api.g_exc_unexpected_error;
2849: END IF;
2850: RAISE fnd_api.g_exc_error;
2851: END IF;
2852:
2853: IF fnd_api.to_boolean(p_commit) THEN
2854: COMMIT;

Line 2853: IF fnd_api.to_boolean(p_commit) THEN

2849: END IF;
2850: RAISE fnd_api.g_exc_error;
2851: END IF;
2852:
2853: IF fnd_api.to_boolean(p_commit) THEN
2854: COMMIT;
2855: END IF;
2856:
2857: EXCEPTION

Line 2858: WHEN fnd_api.g_exc_error THEN

2854: COMMIT;
2855: END IF;
2856:
2857: EXCEPTION
2858: WHEN fnd_api.g_exc_error THEN
2859: x_return_status := fnd_api.g_ret_sts_error;
2860: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2861: WHEN fnd_api.g_exc_unexpected_error THEN
2862: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2859: x_return_status := fnd_api.g_ret_sts_error;

2855: END IF;
2856:
2857: EXCEPTION
2858: WHEN fnd_api.g_exc_error THEN
2859: x_return_status := fnd_api.g_ret_sts_error;
2860: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2861: WHEN fnd_api.g_exc_unexpected_error THEN
2862: x_return_status := fnd_api.g_ret_sts_unexp_error;
2863: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 2861: WHEN fnd_api.g_exc_unexpected_error THEN

2857: EXCEPTION
2858: WHEN fnd_api.g_exc_error THEN
2859: x_return_status := fnd_api.g_ret_sts_error;
2860: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2861: WHEN fnd_api.g_exc_unexpected_error THEN
2862: x_return_status := fnd_api.g_ret_sts_unexp_error;
2863: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2864: WHEN OTHERS THEN
2865: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

Line 2862: x_return_status := fnd_api.g_ret_sts_unexp_error;

2858: WHEN fnd_api.g_exc_error THEN
2859: x_return_status := fnd_api.g_ret_sts_error;
2860: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2861: WHEN fnd_api.g_exc_unexpected_error THEN
2862: x_return_status := fnd_api.g_ret_sts_unexp_error;
2863: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2864: WHEN OTHERS THEN
2865: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2866: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2866: x_return_status := fnd_api.g_ret_sts_unexp_error;

2862: x_return_status := fnd_api.g_ret_sts_unexp_error;
2863: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2864: WHEN OTHERS THEN
2865: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2866: x_return_status := fnd_api.g_ret_sts_unexp_error;
2867: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2868: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2869: END IF;
2870: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

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

2890: BEGIN
2891: SAVEPOINT delete_trip;
2892:
2893: -- Check for API Compatibility
2894: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2895: RAISE fnd_api.g_exc_unexpected_error;
2896: END IF;
2897:
2898: -- Initialize Message Stack if required

Line 2895: RAISE fnd_api.g_exc_unexpected_error;

2891: SAVEPOINT delete_trip;
2892:
2893: -- Check for API Compatibility
2894: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2895: RAISE fnd_api.g_exc_unexpected_error;
2896: END IF;
2897:
2898: -- Initialize Message Stack if required
2899: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 2899: IF fnd_api.to_boolean(p_init_msg_list) THEN

2895: RAISE fnd_api.g_exc_unexpected_error;
2896: END IF;
2897:
2898: -- Initialize Message Stack if required
2899: IF fnd_api.to_boolean(p_init_msg_list) THEN
2900: fnd_msg_pub.initialize;
2901: END IF;
2902:
2903: -- Initialize Return Status

Line 2904: x_return_status := fnd_api.g_ret_sts_success;

2900: fnd_msg_pub.initialize;
2901: END IF;
2902:
2903: -- Initialize Return Status
2904: x_return_status := fnd_api.g_ret_sts_success;
2905:
2906: IF l_debug THEN
2907: debug('Deleting the Trip #' || p_trip_id, l_api_name, fnd_log.level_procedure);
2908: END IF;

Line 2910: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN

2906: IF l_debug THEN
2907: debug('Deleting the Trip #' || p_trip_id, l_api_name, fnd_log.level_procedure);
2908: END IF;
2909:
2910: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
2911: -- Invalid Trip ID passed.
2912: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2913: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2914: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');

Line 2916: RAISE fnd_api.g_exc_error;

2912: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2913: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2914: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
2915: fnd_msg_pub.ADD;
2916: RAISE fnd_api.g_exc_error;
2917: END IF;
2918:
2919: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
2920: -- Invalid Object Version Number passed.

Line 2919: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN

2915: fnd_msg_pub.ADD;
2916: RAISE fnd_api.g_exc_error;
2917: END IF;
2918:
2919: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
2920: -- Invalid Object Version Number passed.
2921: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2922: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2923: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');

Line 2925: RAISE fnd_api.g_exc_error;

2921: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2922: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2923: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
2924: fnd_msg_pub.ADD;
2925: RAISE fnd_api.g_exc_error;
2926: END IF;
2927:
2928: l_trip := get_trip(p_trip_id);
2929: -- No Trips found for the given Trip ID

Line 2934: RAISE fnd_api.g_exc_error;

2930: IF l_trip.trip_id IS NULL THEN
2931: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
2932: fnd_message.set_token('TRIP_ID', p_trip_id);
2933: fnd_msg_pub.ADD;
2934: RAISE fnd_api.g_exc_error;
2935: END IF;
2936:
2937: remove_trip(
2938: x_return_status => x_return_status

Line 2945: IF x_return_status <> fnd_api.g_ret_sts_success THEN

2941: , p_trip => l_trip
2942: , p_object_version_number => p_object_version_number
2943: );
2944:
2945: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2946: IF l_debug THEN
2947: debug( ' Unable to delete the Trip: Error = '
2948: || fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
2949: , l_api_name, fnd_log.level_error);

Line 2948: || fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)

2944:
2945: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2946: IF l_debug THEN
2947: debug( ' Unable to delete the Trip: Error = '
2948: || fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
2949: , l_api_name, fnd_log.level_error);
2950: END IF;
2951: fnd_message.set_name('CSF', 'CSF_TRIP_DELETE_FAIL_OTHER');
2952: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));

Line 2955: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

2951: fnd_message.set_name('CSF', 'CSF_TRIP_DELETE_FAIL_OTHER');
2952: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2953: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2954: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2955: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2956: fnd_msg_pub.ADD;
2957: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2958: RAISE fnd_api.g_exc_unexpected_error;
2959: END IF;

Line 2957: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

2953: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2954: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2955: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2956: fnd_msg_pub.ADD;
2957: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2958: RAISE fnd_api.g_exc_unexpected_error;
2959: END IF;
2960: RAISE fnd_api.g_exc_error;
2961: END IF;

Line 2958: RAISE fnd_api.g_exc_unexpected_error;

2954: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2955: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2956: fnd_msg_pub.ADD;
2957: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2958: RAISE fnd_api.g_exc_unexpected_error;
2959: END IF;
2960: RAISE fnd_api.g_exc_error;
2961: END IF;
2962:

Line 2960: RAISE fnd_api.g_exc_error;

2956: fnd_msg_pub.ADD;
2957: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2958: RAISE fnd_api.g_exc_unexpected_error;
2959: END IF;
2960: RAISE fnd_api.g_exc_error;
2961: END IF;
2962:
2963: IF fnd_api.to_boolean(p_commit) THEN
2964: COMMIT;

Line 2963: IF fnd_api.to_boolean(p_commit) THEN

2959: END IF;
2960: RAISE fnd_api.g_exc_error;
2961: END IF;
2962:
2963: IF fnd_api.to_boolean(p_commit) THEN
2964: COMMIT;
2965: END IF;
2966: EXCEPTION
2967: WHEN fnd_api.g_exc_error THEN

Line 2967: WHEN fnd_api.g_exc_error THEN

2963: IF fnd_api.to_boolean(p_commit) THEN
2964: COMMIT;
2965: END IF;
2966: EXCEPTION
2967: WHEN fnd_api.g_exc_error THEN
2968: ROLLBACK TO delete_trip;
2969: x_return_status := fnd_api.g_ret_sts_error;
2970: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2971: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2969: x_return_status := fnd_api.g_ret_sts_error;

2965: END IF;
2966: EXCEPTION
2967: WHEN fnd_api.g_exc_error THEN
2968: ROLLBACK TO delete_trip;
2969: x_return_status := fnd_api.g_ret_sts_error;
2970: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2971: WHEN fnd_api.g_exc_unexpected_error THEN
2972: ROLLBACK TO delete_trip;
2973: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2971: WHEN fnd_api.g_exc_unexpected_error THEN

2967: WHEN fnd_api.g_exc_error THEN
2968: ROLLBACK TO delete_trip;
2969: x_return_status := fnd_api.g_ret_sts_error;
2970: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2971: WHEN fnd_api.g_exc_unexpected_error THEN
2972: ROLLBACK TO delete_trip;
2973: x_return_status := fnd_api.g_ret_sts_unexp_error;
2974: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2975: WHEN OTHERS THEN

Line 2973: x_return_status := fnd_api.g_ret_sts_unexp_error;

2969: x_return_status := fnd_api.g_ret_sts_error;
2970: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2971: WHEN fnd_api.g_exc_unexpected_error THEN
2972: ROLLBACK TO delete_trip;
2973: x_return_status := fnd_api.g_ret_sts_unexp_error;
2974: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2975: WHEN OTHERS THEN
2976: ROLLBACK TO delete_trip;
2977: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

Line 2978: x_return_status := fnd_api.g_ret_sts_unexp_error;

2974: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2975: WHEN OTHERS THEN
2976: ROLLBACK TO delete_trip;
2977: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2978: x_return_status := fnd_api.g_ret_sts_unexp_error;
2979: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2980: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2981: END IF;
2982: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

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

3001:
3002: l_trip trip_rec_type;
3003: BEGIN
3004: -- Check for API Compatibility
3005: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3006: RAISE fnd_api.g_exc_unexpected_error;
3007: END IF;
3008:
3009: -- Initialize Message Stack if required

Line 3006: RAISE fnd_api.g_exc_unexpected_error;

3002: l_trip trip_rec_type;
3003: BEGIN
3004: -- Check for API Compatibility
3005: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3006: RAISE fnd_api.g_exc_unexpected_error;
3007: END IF;
3008:
3009: -- Initialize Message Stack if required
3010: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 3010: IF fnd_api.to_boolean(p_init_msg_list) THEN

3006: RAISE fnd_api.g_exc_unexpected_error;
3007: END IF;
3008:
3009: -- Initialize Message Stack if required
3010: IF fnd_api.to_boolean(p_init_msg_list) THEN
3011: fnd_msg_pub.initialize;
3012: END IF;
3013:
3014: -- Initialize Return Status

Line 3015: x_return_status := fnd_api.g_ret_sts_success;

3011: fnd_msg_pub.initialize;
3012: END IF;
3013:
3014: -- Initialize Return Status
3015: x_return_status := fnd_api.g_ret_sts_success;
3016:
3017: IF l_debug THEN
3018: debug('Fixing the Trip #' || p_trip_id, l_api_name, fnd_log.level_procedure);
3019: END IF;

Line 3021: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN

3017: IF l_debug THEN
3018: debug('Fixing the Trip #' || p_trip_id, l_api_name, fnd_log.level_procedure);
3019: END IF;
3020:
3021: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
3022: -- Invalid Trip ID passed.
3023: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
3024: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
3025: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');

Line 3027: RAISE fnd_api.g_exc_error;

3023: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
3024: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
3025: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
3026: fnd_msg_pub.ADD;
3027: RAISE fnd_api.g_exc_error;
3028: END IF;
3029:
3030: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
3031: -- Invalid Object Version Number passed.

Line 3030: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN

3026: fnd_msg_pub.ADD;
3027: RAISE fnd_api.g_exc_error;
3028: END IF;
3029:
3030: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
3031: -- Invalid Object Version Number passed.
3032: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
3033: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
3034: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');

Line 3036: RAISE fnd_api.g_exc_error;

3032: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
3033: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
3034: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
3035: fnd_msg_pub.ADD;
3036: RAISE fnd_api.g_exc_error;
3037: END IF;
3038:
3039: l_trip := get_trip(p_trip_id);
3040: IF l_trip.trip_id IS NULL THEN

Line 3044: RAISE fnd_api.g_exc_error;

3040: IF l_trip.trip_id IS NULL THEN
3041: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
3042: fnd_message.set_token('TRIP_ID', p_trip_id);
3043: fnd_msg_pub.ADD;
3044: RAISE fnd_api.g_exc_error;
3045: END IF;
3046:
3047: correct_trip(
3048: x_return_status => x_return_status

Line 3055: IF x_return_status <> fnd_api.g_ret_sts_success THEN

3051: , p_trip => l_trip
3052: , p_object_version_number => p_object_version_number
3053: );
3054:
3055: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3056: IF l_debug THEN
3057: debug(' Unable to fix the Trip', l_api_name, fnd_log.level_error);
3058: END IF;
3059: fnd_message.set_name('CSF', 'CSF_TRIP_FIX_FAIL_OTHER');

Line 3063: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

3059: fnd_message.set_name('CSF', 'CSF_TRIP_FIX_FAIL_OTHER');
3060: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
3061: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
3062: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
3063: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
3064: fnd_msg_pub.ADD;
3065: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3066: RAISE fnd_api.g_exc_unexpected_error;
3067: END IF;

Line 3065: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3061: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
3062: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
3063: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
3064: fnd_msg_pub.ADD;
3065: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3066: RAISE fnd_api.g_exc_unexpected_error;
3067: END IF;
3068: RAISE fnd_api.g_exc_error;
3069: END IF;

Line 3066: RAISE fnd_api.g_exc_unexpected_error;

3062: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
3063: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
3064: fnd_msg_pub.ADD;
3065: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3066: RAISE fnd_api.g_exc_unexpected_error;
3067: END IF;
3068: RAISE fnd_api.g_exc_error;
3069: END IF;
3070:

Line 3068: RAISE fnd_api.g_exc_error;

3064: fnd_msg_pub.ADD;
3065: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3066: RAISE fnd_api.g_exc_unexpected_error;
3067: END IF;
3068: RAISE fnd_api.g_exc_error;
3069: END IF;
3070:
3071: IF fnd_api.to_boolean(p_commit) THEN
3072: COMMIT;

Line 3071: IF fnd_api.to_boolean(p_commit) THEN

3067: END IF;
3068: RAISE fnd_api.g_exc_error;
3069: END IF;
3070:
3071: IF fnd_api.to_boolean(p_commit) THEN
3072: COMMIT;
3073: END IF;
3074: EXCEPTION
3075: WHEN fnd_api.g_exc_error THEN

Line 3075: WHEN fnd_api.g_exc_error THEN

3071: IF fnd_api.to_boolean(p_commit) THEN
3072: COMMIT;
3073: END IF;
3074: EXCEPTION
3075: WHEN fnd_api.g_exc_error THEN
3076: x_return_status := fnd_api.g_ret_sts_error;
3077: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3078: WHEN fnd_api.g_exc_unexpected_error THEN
3079: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3076: x_return_status := fnd_api.g_ret_sts_error;

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

Line 3078: WHEN fnd_api.g_exc_unexpected_error THEN

3074: EXCEPTION
3075: WHEN fnd_api.g_exc_error THEN
3076: x_return_status := fnd_api.g_ret_sts_error;
3077: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3078: WHEN fnd_api.g_exc_unexpected_error THEN
3079: x_return_status := fnd_api.g_ret_sts_unexp_error;
3080: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3081: WHEN OTHERS THEN
3082: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

Line 3079: x_return_status := fnd_api.g_ret_sts_unexp_error;

3075: WHEN fnd_api.g_exc_error THEN
3076: x_return_status := fnd_api.g_ret_sts_error;
3077: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3078: WHEN fnd_api.g_exc_unexpected_error THEN
3079: x_return_status := fnd_api.g_ret_sts_unexp_error;
3080: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3081: WHEN OTHERS THEN
3082: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
3083: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3083: x_return_status := fnd_api.g_ret_sts_unexp_error;

3079: x_return_status := fnd_api.g_ret_sts_unexp_error;
3080: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3081: WHEN OTHERS THEN
3082: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
3083: x_return_status := fnd_api.g_ret_sts_unexp_error;
3084: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3085: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3086: END IF;
3087: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

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

3115: l_resource_tbl csf_resource_pub.resource_tbl_type;
3116: l_trips trip_tbl_type;
3117: BEGIN
3118: -- Check for API Compatibility
3119: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3120: RAISE fnd_api.g_exc_unexpected_error;
3121: END IF;
3122:
3123: -- Initialize Message Stack if required

Line 3120: RAISE fnd_api.g_exc_unexpected_error;

3116: l_trips trip_tbl_type;
3117: BEGIN
3118: -- Check for API Compatibility
3119: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3120: RAISE fnd_api.g_exc_unexpected_error;
3121: END IF;
3122:
3123: -- Initialize Message Stack if required
3124: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 3124: IF fnd_api.to_boolean(p_init_msg_list) THEN

3120: RAISE fnd_api.g_exc_unexpected_error;
3121: END IF;
3122:
3123: -- Initialize Message Stack if required
3124: IF fnd_api.to_boolean(p_init_msg_list) THEN
3125: fnd_msg_pub.initialize;
3126: END IF;
3127:
3128: -- Initialize Return Status

Line 3129: x_return_status := fnd_api.g_ret_sts_success;

3125: fnd_msg_pub.initialize;
3126: END IF;
3127:
3128: -- Initialize Return Status
3129: x_return_status := fnd_api.g_ret_sts_success;
3130:
3131: l_resource_tbl := csf_resource_pub.resource_tbl_type();
3132: l_resource_tbl.extend();
3133: l_resource_tbl(1).resource_id := p_resource_id;

Line 3148: RAISE fnd_api.g_exc_error;

3144: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
3145: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
3146: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
3147: fnd_msg_pub.add;
3148: RAISE fnd_api.g_exc_error;
3149: END IF;
3150:
3151: x_trip := l_trips(l_trips.FIRST);
3152: EXCEPTION

Line 3153: WHEN fnd_api.g_exc_error THEN

3149: END IF;
3150:
3151: x_trip := l_trips(l_trips.FIRST);
3152: EXCEPTION
3153: WHEN fnd_api.g_exc_error THEN
3154: x_return_status := fnd_api.g_ret_sts_error;
3155: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3156: WHEN fnd_api.g_exc_unexpected_error THEN
3157: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3154: x_return_status := fnd_api.g_ret_sts_error;

3150:
3151: x_trip := l_trips(l_trips.FIRST);
3152: EXCEPTION
3153: WHEN fnd_api.g_exc_error THEN
3154: x_return_status := fnd_api.g_ret_sts_error;
3155: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3156: WHEN fnd_api.g_exc_unexpected_error THEN
3157: x_return_status := fnd_api.g_ret_sts_unexp_error;
3158: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 3156: WHEN fnd_api.g_exc_unexpected_error THEN

3152: EXCEPTION
3153: WHEN fnd_api.g_exc_error THEN
3154: x_return_status := fnd_api.g_ret_sts_error;
3155: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3156: WHEN fnd_api.g_exc_unexpected_error THEN
3157: x_return_status := fnd_api.g_ret_sts_unexp_error;
3158: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3159: WHEN OTHERS THEN
3160: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

Line 3157: x_return_status := fnd_api.g_ret_sts_unexp_error;

3153: WHEN fnd_api.g_exc_error THEN
3154: x_return_status := fnd_api.g_ret_sts_error;
3155: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3156: WHEN fnd_api.g_exc_unexpected_error THEN
3157: x_return_status := fnd_api.g_ret_sts_unexp_error;
3158: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3159: WHEN OTHERS THEN
3160: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
3161: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3161: x_return_status := fnd_api.g_ret_sts_unexp_error;

3157: x_return_status := fnd_api.g_ret_sts_unexp_error;
3158: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3159: WHEN OTHERS THEN
3160: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
3161: x_return_status := fnd_api.g_ret_sts_unexp_error;
3162: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3163: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3164: END IF;
3165: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

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

3186: l_debug CONSTANT BOOLEAN := g_debug = 'Y';
3187: l_trip trip_rec_type;
3188: BEGIN
3189: -- Check for API Compatibility
3190: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3191: RAISE fnd_api.g_exc_unexpected_error;
3192: END IF;
3193:
3194: -- Initialize Message Stack if required

Line 3191: RAISE fnd_api.g_exc_unexpected_error;

3187: l_trip trip_rec_type;
3188: BEGIN
3189: -- Check for API Compatibility
3190: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3191: RAISE fnd_api.g_exc_unexpected_error;
3192: END IF;
3193:
3194: -- Initialize Message Stack if required
3195: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 3195: IF fnd_api.to_boolean(p_init_msg_list) THEN

3191: RAISE fnd_api.g_exc_unexpected_error;
3192: END IF;
3193:
3194: -- Initialize Message Stack if required
3195: IF fnd_api.to_boolean(p_init_msg_list) THEN
3196: fnd_msg_pub.initialize;
3197: END IF;
3198:
3199: -- Initialize Return Status

Line 3200: x_return_status := fnd_api.g_ret_sts_success;

3196: fnd_msg_pub.initialize;
3197: END IF;
3198:
3199: -- Initialize Return Status
3200: x_return_status := fnd_api.g_ret_sts_success;
3201:
3202: find_trip(
3203: p_api_version => p_api_version
3204: , p_init_msg_list => p_init_msg_list

Line 3216: IF x_return_status = fnd_api.g_ret_sts_success THEN

3212: , p_overtime_flag => p_overtime_flag
3213: , x_trip => l_trip
3214: );
3215:
3216: IF x_return_status = fnd_api.g_ret_sts_success THEN
3217: x_trip_id := l_trip.trip_id;
3218: END IF;
3219:
3220: EXCEPTION

Line 3221: WHEN fnd_api.g_exc_error THEN

3217: x_trip_id := l_trip.trip_id;
3218: END IF;
3219:
3220: EXCEPTION
3221: WHEN fnd_api.g_exc_error THEN
3222: x_return_status := fnd_api.g_ret_sts_error;
3223: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3224: WHEN fnd_api.g_exc_unexpected_error THEN
3225: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3222: x_return_status := fnd_api.g_ret_sts_error;

3218: END IF;
3219:
3220: EXCEPTION
3221: WHEN fnd_api.g_exc_error THEN
3222: x_return_status := fnd_api.g_ret_sts_error;
3223: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3224: WHEN fnd_api.g_exc_unexpected_error THEN
3225: x_return_status := fnd_api.g_ret_sts_unexp_error;
3226: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 3224: WHEN fnd_api.g_exc_unexpected_error THEN

3220: EXCEPTION
3221: WHEN fnd_api.g_exc_error THEN
3222: x_return_status := fnd_api.g_ret_sts_error;
3223: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3224: WHEN fnd_api.g_exc_unexpected_error THEN
3225: x_return_status := fnd_api.g_ret_sts_unexp_error;
3226: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3227: WHEN OTHERS THEN
3228: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

Line 3225: x_return_status := fnd_api.g_ret_sts_unexp_error;

3221: WHEN fnd_api.g_exc_error THEN
3222: x_return_status := fnd_api.g_ret_sts_error;
3223: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3224: WHEN fnd_api.g_exc_unexpected_error THEN
3225: x_return_status := fnd_api.g_ret_sts_unexp_error;
3226: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3227: WHEN OTHERS THEN
3228: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
3229: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3229: x_return_status := fnd_api.g_ret_sts_unexp_error;

3225: x_return_status := fnd_api.g_ret_sts_unexp_error;
3226: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3227: WHEN OTHERS THEN
3228: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
3229: x_return_status := fnd_api.g_ret_sts_unexp_error;
3230: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3231: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3232: END IF;
3233: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

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

3252: l_api_version CONSTANT NUMBER := 1.0;
3253: l_debug CONSTANT BOOLEAN := g_debug = 'Y';
3254: BEGIN
3255: -- Check for API Compatibility
3256: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3257: RAISE fnd_api.g_exc_unexpected_error;
3258: END IF;
3259:
3260: -- Initialize Message Stack if required

Line 3257: RAISE fnd_api.g_exc_unexpected_error;

3253: l_debug CONSTANT BOOLEAN := g_debug = 'Y';
3254: BEGIN
3255: -- Check for API Compatibility
3256: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3257: RAISE fnd_api.g_exc_unexpected_error;
3258: END IF;
3259:
3260: -- Initialize Message Stack if required
3261: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 3261: IF fnd_api.to_boolean(p_init_msg_list) THEN

3257: RAISE fnd_api.g_exc_unexpected_error;
3258: END IF;
3259:
3260: -- Initialize Message Stack if required
3261: IF fnd_api.to_boolean(p_init_msg_list) THEN
3262: fnd_msg_pub.initialize;
3263: END IF;
3264:
3265: -- Initialize Return Status

Line 3266: x_return_status := fnd_api.g_ret_sts_success;

3262: fnd_msg_pub.initialize;
3263: END IF;
3264:
3265: -- Initialize Return Status
3266: x_return_status := fnd_api.g_ret_sts_success;
3267:
3268: x_trips := find_trips(p_resource_tbl, p_start_date_time, p_end_date_time, p_overtime_flag);
3269:
3270: EXCEPTION

Line 3271: WHEN fnd_api.g_exc_error THEN

3267:
3268: x_trips := find_trips(p_resource_tbl, p_start_date_time, p_end_date_time, p_overtime_flag);
3269:
3270: EXCEPTION
3271: WHEN fnd_api.g_exc_error THEN
3272: x_return_status := fnd_api.g_ret_sts_error;
3273: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3274: WHEN fnd_api.g_exc_unexpected_error THEN
3275: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3272: x_return_status := fnd_api.g_ret_sts_error;

3268: x_trips := find_trips(p_resource_tbl, p_start_date_time, p_end_date_time, p_overtime_flag);
3269:
3270: EXCEPTION
3271: WHEN fnd_api.g_exc_error THEN
3272: x_return_status := fnd_api.g_ret_sts_error;
3273: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3274: WHEN fnd_api.g_exc_unexpected_error THEN
3275: x_return_status := fnd_api.g_ret_sts_unexp_error;
3276: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 3274: WHEN fnd_api.g_exc_unexpected_error THEN

3270: EXCEPTION
3271: WHEN fnd_api.g_exc_error THEN
3272: x_return_status := fnd_api.g_ret_sts_error;
3273: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3274: WHEN fnd_api.g_exc_unexpected_error THEN
3275: x_return_status := fnd_api.g_ret_sts_unexp_error;
3276: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3277: WHEN OTHERS THEN
3278: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

Line 3275: x_return_status := fnd_api.g_ret_sts_unexp_error;

3271: WHEN fnd_api.g_exc_error THEN
3272: x_return_status := fnd_api.g_ret_sts_error;
3273: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3274: WHEN fnd_api.g_exc_unexpected_error THEN
3275: x_return_status := fnd_api.g_ret_sts_unexp_error;
3276: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3277: WHEN OTHERS THEN
3278: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
3279: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3279: x_return_status := fnd_api.g_ret_sts_unexp_error;

3275: x_return_status := fnd_api.g_ret_sts_unexp_error;
3276: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3277: WHEN OTHERS THEN
3278: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
3279: x_return_status := fnd_api.g_ret_sts_unexp_error;
3280: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3281: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3282: END IF;
3283: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

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

3312:
3313:
3314: BEGIN
3315: -- Check for API Compatibility
3316: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3317: RAISE fnd_api.g_exc_unexpected_error;
3318: END IF;
3319:
3320: -- Initialize Message Stack if required

Line 3317: RAISE fnd_api.g_exc_unexpected_error;

3313:
3314: BEGIN
3315: -- Check for API Compatibility
3316: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3317: RAISE fnd_api.g_exc_unexpected_error;
3318: END IF;
3319:
3320: -- Initialize Message Stack if required
3321: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 3321: IF fnd_api.to_boolean(p_init_msg_list) THEN

3317: RAISE fnd_api.g_exc_unexpected_error;
3318: END IF;
3319:
3320: -- Initialize Message Stack if required
3321: IF fnd_api.to_boolean(p_init_msg_list) THEN
3322: fnd_msg_pub.initialize;
3323: END IF;
3324:
3325: -- Initialize Return Status

Line 3326: x_return_status := fnd_api.g_ret_sts_success;

3322: fnd_msg_pub.initialize;
3323: END IF;
3324:
3325: -- Initialize Return Status
3326: x_return_status := fnd_api.g_ret_sts_success;
3327: l_shift_type := p_shift_type;
3328: IF l_debug THEN
3329: debug('Generating Resource Trips for a Resource', l_api_name, fnd_log.level_procedure);
3330: debug(' Action = ' || p_action, l_api_name, fnd_log.level_statement);

Line 3372: RAISE fnd_api.g_exc_error;

3368: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
3369: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
3370: fnd_message.set_token('PARAM_NAME', l_param_name);
3371: fnd_msg_pub.ADD;
3372: RAISE fnd_api.g_exc_error;
3373: END IF;
3374:
3375: -- Getting the Trips only for actions like DELETE, FIX, BLOCK, UNBLOCK.
3376: IF p_action NOT IN (g_action_create_trip, g_action_upgrade_trip, g_action_replace_trip) THEN

Line 3409: RAISE fnd_api.g_exc_error;

3405: , x_msg_count => x_msg_count);
3406: END IF;
3407: END IF;
3408: fnd_msg_pub.add;
3409: RAISE fnd_api.g_exc_error;
3410: END IF;
3411: END IF;
3412: g_messages.DELETE;
3413: IF p_action IN (g_action_create_trip, g_action_replace_trip) THEN

Line 3459: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3455: , p_trips => l_trips
3456: );
3457: END IF;
3458:
3459: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3460: RAISE fnd_api.g_exc_unexpected_error;
3461: END IF;
3462: IF p_action NOT IN (g_action_block_trip, g_action_unblock_trip)
3463: THEN

Line 3460: RAISE fnd_api.g_exc_unexpected_error;

3456: );
3457: END IF;
3458:
3459: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3460: RAISE fnd_api.g_exc_unexpected_error;
3461: END IF;
3462: IF p_action NOT IN (g_action_block_trip, g_action_unblock_trip)
3463: THEN
3464: check_dangling_tasks(p_resource_tbl => p_resource_tbl

Line 3493: IF fnd_api.to_boolean(p_commit) THEN

3489: , p_end_date => p_end_date
3490: , p_resource_tbl => p_resource_tbl
3491: );
3492:
3493: IF fnd_api.to_boolean(p_commit) THEN
3494: COMMIT;
3495: END IF;
3496:
3497: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 3499: WHEN fnd_api.g_exc_error THEN

3495: END IF;
3496:
3497: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3498: EXCEPTION
3499: WHEN fnd_api.g_exc_error THEN
3500: x_return_status := fnd_api.g_ret_sts_error;
3501: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3502: WHEN fnd_api.g_exc_unexpected_error THEN
3503: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3500: x_return_status := fnd_api.g_ret_sts_error;

3496:
3497: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3498: EXCEPTION
3499: WHEN fnd_api.g_exc_error THEN
3500: x_return_status := fnd_api.g_ret_sts_error;
3501: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3502: WHEN fnd_api.g_exc_unexpected_error THEN
3503: x_return_status := fnd_api.g_ret_sts_unexp_error;
3504: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 3502: WHEN fnd_api.g_exc_unexpected_error THEN

3498: EXCEPTION
3499: WHEN fnd_api.g_exc_error THEN
3500: x_return_status := fnd_api.g_ret_sts_error;
3501: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3502: WHEN fnd_api.g_exc_unexpected_error THEN
3503: x_return_status := fnd_api.g_ret_sts_unexp_error;
3504: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3505: WHEN OTHERS THEN
3506: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

Line 3503: x_return_status := fnd_api.g_ret_sts_unexp_error;

3499: WHEN fnd_api.g_exc_error THEN
3500: x_return_status := fnd_api.g_ret_sts_error;
3501: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3502: WHEN fnd_api.g_exc_unexpected_error THEN
3503: x_return_status := fnd_api.g_ret_sts_unexp_error;
3504: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3505: WHEN OTHERS THEN
3506: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
3507: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3507: x_return_status := fnd_api.g_ret_sts_unexp_error;

3503: x_return_status := fnd_api.g_ret_sts_unexp_error;
3504: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3505: WHEN OTHERS THEN
3506: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
3507: x_return_status := fnd_api.g_ret_sts_unexp_error;
3508: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3509: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3510: END IF;
3511: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 3704: , p_init_msg_list => fnd_api.g_true

3700: ' Resource Type #'|| l_resource(1).resource_type, l_api_name, fnd_log.level_statement);
3701: END IF;
3702: process_action(
3703: p_api_version => 1.0
3704: , p_init_msg_list => fnd_api.g_true
3705: , p_commit => fnd_api.g_true
3706: , x_return_status => l_return_status
3707: , x_msg_data => l_msg_data
3708: , x_msg_count => l_msg_count

Line 3705: , p_commit => fnd_api.g_true

3701: END IF;
3702: process_action(
3703: p_api_version => 1.0
3704: , p_init_msg_list => fnd_api.g_true
3705: , p_commit => fnd_api.g_true
3706: , x_return_status => l_return_status
3707: , x_msg_data => l_msg_data
3708: , x_msg_count => l_msg_count
3709: , p_action => p_action

Line 3718: debug(' ' || fnd_msg_pub.get(i, fnd_api.g_false), l_api_name, g_level_cp_output);

3714: );
3715:
3716: -- Print all the messages encountered
3717: FOR i IN 1..l_msg_count LOOP
3718: debug(' ' || fnd_msg_pub.get(i, fnd_api.g_false), l_api_name, g_level_cp_output);
3719: END LOOP;
3720: debug(' ', l_api_name, g_level_cp_output);
3721:
3722: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 3722: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3718: debug(' ' || fnd_msg_pub.get(i, fnd_api.g_false), l_api_name, g_level_cp_output);
3719: END LOOP;
3720: debug(' ', l_api_name, g_level_cp_output);
3721:
3722: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3723: l_resources_failed := l_resources_failed + 1;
3724: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3725: RAISE fnd_api.g_exc_unexpected_error;
3726: END IF;

Line 3724: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

3720: debug(' ', l_api_name, g_level_cp_output);
3721:
3722: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3723: l_resources_failed := l_resources_failed + 1;
3724: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3725: RAISE fnd_api.g_exc_unexpected_error;
3726: END IF;
3727: ELSE
3728: l_resources_success := l_resources_success + 1;

Line 3725: RAISE fnd_api.g_exc_unexpected_error;

3721:
3722: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3723: l_resources_failed := l_resources_failed + 1;
3724: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
3725: RAISE fnd_api.g_exc_unexpected_error;
3726: END IF;
3727: ELSE
3728: l_resources_success := l_resources_success + 1;
3729: END IF;

Line 3766: debug(fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false), l_api_name, g_level_cp_output);

3762: IF SQLERRM IS NOT NULL THEN
3763:
3764: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3765: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3766: debug(fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false), l_api_name, g_level_cp_output);
3767: END IF;
3768: END IF;
3769:
3770: retcode := 2;

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

3796: --
3797: l_resources_tbl csf_requests_pvt.resource_tbl_type;
3798: BEGIN
3799: -- Check for API Compatibility
3800: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3801: RAISE fnd_api.g_exc_unexpected_error;
3802: END IF;
3803:
3804: -- Initialize Message Stack if required

Line 3801: RAISE fnd_api.g_exc_unexpected_error;

3797: l_resources_tbl csf_requests_pvt.resource_tbl_type;
3798: BEGIN
3799: -- Check for API Compatibility
3800: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3801: RAISE fnd_api.g_exc_unexpected_error;
3802: END IF;
3803:
3804: -- Initialize Message Stack if required
3805: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 3805: IF fnd_api.to_boolean(p_init_msg_list) THEN

3801: RAISE fnd_api.g_exc_unexpected_error;
3802: END IF;
3803:
3804: -- Initialize Message Stack if required
3805: IF fnd_api.to_boolean(p_init_msg_list) THEN
3806: fnd_msg_pub.initialize;
3807: END IF;
3808:
3809: -- Initialize Return Status

Line 3810: x_return_status := fnd_api.g_ret_sts_success;

3806: fnd_msg_pub.initialize;
3807: END IF;
3808:
3809: -- Initialize Return Status
3810: x_return_status := fnd_api.g_ret_sts_success;
3811:
3812: IF l_debug THEN
3813: debug('CSF_TRIPS_PUB.Optimize Across Trips', l_api_name, fnd_log.level_procedure);
3814: debug(' No of resources in list = ' || p_resource_tbl.COUNT, l_api_name, fnd_log.level_statement);

Line 3837: IF x_return_status = fnd_api.g_ret_sts_error THEN

3833: , x_request_id => l_sched_request_id
3834: );
3835:
3836: -- Standard check of the return status for the API call
3837: IF x_return_status = fnd_api.g_ret_sts_error THEN
3838: RAISE fnd_api.g_exc_error;
3839: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3840: RAISE fnd_api.g_exc_unexpected_error;
3841: END IF;

Line 3838: RAISE fnd_api.g_exc_error;

3834: );
3835:
3836: -- Standard check of the return status for the API call
3837: IF x_return_status = fnd_api.g_ret_sts_error THEN
3838: RAISE fnd_api.g_exc_error;
3839: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3840: RAISE fnd_api.g_exc_unexpected_error;
3841: END IF;
3842:

Line 3839: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

3835:
3836: -- Standard check of the return status for the API call
3837: IF x_return_status = fnd_api.g_ret_sts_error THEN
3838: RAISE fnd_api.g_exc_error;
3839: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3840: RAISE fnd_api.g_exc_unexpected_error;
3841: END IF;
3842:
3843: fnd_message.set_name('CSR','OPTIMIZE_ACROSS_TRIPS');

Line 3840: RAISE fnd_api.g_exc_unexpected_error;

3836: -- Standard check of the return status for the API call
3837: IF x_return_status = fnd_api.g_ret_sts_error THEN
3838: RAISE fnd_api.g_exc_error;
3839: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
3840: RAISE fnd_api.g_exc_unexpected_error;
3841: END IF;
3842:
3843: fnd_message.set_name('CSR','OPTIMIZE_ACROSS_TRIPS');
3844: l_oat_string := fnd_message.get;

Line 3856: x_return_status := fnd_api.g_ret_sts_error;

3852: );
3853:
3854: IF x_conc_request_id = 0 THEN
3855: -- FND_REQUEST.SUBMIT_REQUEST should have populated the Message Stack.
3856: x_return_status := fnd_api.g_ret_sts_error;
3857: RAISE fnd_api.g_exc_error;
3858: END IF;
3859:
3860: -- needed to submit the request properly

Line 3857: RAISE fnd_api.g_exc_error;

3853:
3854: IF x_conc_request_id = 0 THEN
3855: -- FND_REQUEST.SUBMIT_REQUEST should have populated the Message Stack.
3856: x_return_status := fnd_api.g_ret_sts_error;
3857: RAISE fnd_api.g_exc_error;
3858: END IF;
3859:
3860: -- needed to submit the request properly
3861: COMMIT;

Line 3865: WHEN fnd_api.g_exc_error THEN

3861: COMMIT;
3862:
3863: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3864: EXCEPTION
3865: WHEN fnd_api.g_exc_error THEN
3866: ROLLBACK;
3867: x_return_status := fnd_api.g_ret_sts_error;
3868: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3869: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3867: x_return_status := fnd_api.g_ret_sts_error;

3863: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3864: EXCEPTION
3865: WHEN fnd_api.g_exc_error THEN
3866: ROLLBACK;
3867: x_return_status := fnd_api.g_ret_sts_error;
3868: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3869: WHEN fnd_api.g_exc_unexpected_error THEN
3870: ROLLBACK;
3871: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3869: WHEN fnd_api.g_exc_unexpected_error THEN

3865: WHEN fnd_api.g_exc_error THEN
3866: ROLLBACK;
3867: x_return_status := fnd_api.g_ret_sts_error;
3868: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3869: WHEN fnd_api.g_exc_unexpected_error THEN
3870: ROLLBACK;
3871: x_return_status := fnd_api.g_ret_sts_unexp_error;
3872: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3873: WHEN OTHERS THEN

Line 3871: x_return_status := fnd_api.g_ret_sts_unexp_error;

3867: x_return_status := fnd_api.g_ret_sts_error;
3868: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3869: WHEN fnd_api.g_exc_unexpected_error THEN
3870: ROLLBACK;
3871: x_return_status := fnd_api.g_ret_sts_unexp_error;
3872: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3873: WHEN OTHERS THEN
3874: ROLLBACK;
3875: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

Line 3876: x_return_status := fnd_api.g_ret_sts_unexp_error;

3872: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3873: WHEN OTHERS THEN
3874: ROLLBACK;
3875: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
3876: x_return_status := fnd_api.g_ret_sts_unexp_error;
3877: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3878: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3879: END IF;
3880: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

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

3933: AND object_id=p_resource_id;
3934:
3935: BEGIN
3936: -- Check for API Compatibility
3937: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3938: RAISE fnd_api.g_exc_unexpected_error;
3939: END IF;
3940:
3941: -- Initialize Message Stack if required

Line 3938: RAISE fnd_api.g_exc_unexpected_error;

3934:
3935: BEGIN
3936: -- Check for API Compatibility
3937: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3938: RAISE fnd_api.g_exc_unexpected_error;
3939: END IF;
3940:
3941: -- Initialize Message Stack if required
3942: IF p_init_msg_list = fnd_api.g_true THEN

Line 3942: IF p_init_msg_list = fnd_api.g_true THEN

3938: RAISE fnd_api.g_exc_unexpected_error;
3939: END IF;
3940:
3941: -- Initialize Message Stack if required
3942: IF p_init_msg_list = fnd_api.g_true THEN
3943: fnd_msg_pub.initialize;
3944: END IF;
3945:
3946: -- Initialize Return Status

Line 3947: x_return_status := fnd_api.g_ret_sts_success;

3943: fnd_msg_pub.initialize;
3944: END IF;
3945:
3946: -- Initialize Return Status
3947: x_return_status := fnd_api.g_ret_sts_success;
3948:
3949:
3950:
3951: OPEN c_st_exist;

Line 3974: RAISE fnd_api.g_exc_error;

3970: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
3971: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
3972: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
3973: fnd_msg_pub.ADD;
3974: RAISE fnd_api.g_exc_error;
3975: END IF;
3976:
3977: -- All validations passed. Create the Trip.
3978: new_trip1(

Line 4009: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4005: , x_return_status => x_return_status
4006: , x_msg_data => x_msg_data
4007: , x_msg_count => x_msg_count);
4008:
4009: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4010: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
4011: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
4012: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
4013: fnd_message.set_token('END_TIME', format_date(p_end_date_time));

Line 4014: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

4010: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
4011: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
4012: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
4013: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
4014: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4015: fnd_msg_pub.ADD;
4016: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4017: RAISE fnd_api.g_exc_unexpected_error;
4018: END IF;

Line 4016: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4012: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
4013: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
4014: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4015: fnd_msg_pub.ADD;
4016: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4017: RAISE fnd_api.g_exc_unexpected_error;
4018: END IF;
4019: RAISE fnd_api.g_exc_error;
4020: END IF;

Line 4017: RAISE fnd_api.g_exc_unexpected_error;

4013: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
4014: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4015: fnd_msg_pub.ADD;
4016: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4017: RAISE fnd_api.g_exc_unexpected_error;
4018: END IF;
4019: RAISE fnd_api.g_exc_error;
4020: END IF;
4021:

Line 4019: RAISE fnd_api.g_exc_error;

4015: fnd_msg_pub.ADD;
4016: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4017: RAISE fnd_api.g_exc_unexpected_error;
4018: END IF;
4019: RAISE fnd_api.g_exc_error;
4020: END IF;
4021:
4022: x_trip_id := l_new_trip.trip_id;
4023:

Line 4024: IF fnd_api.to_boolean(p_commit) THEN

4020: END IF;
4021:
4022: x_trip_id := l_new_trip.trip_id;
4023:
4024: IF fnd_api.to_boolean(p_commit) THEN
4025: COMMIT;
4026: END IF;
4027:
4028: EXCEPTION

Line 4029: WHEN fnd_api.g_exc_error THEN

4025: COMMIT;
4026: END IF;
4027:
4028: EXCEPTION
4029: WHEN fnd_api.g_exc_error THEN
4030: x_return_status := fnd_api.g_ret_sts_error;
4031: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4032: WHEN fnd_api.g_exc_unexpected_error THEN
4033: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4030: x_return_status := fnd_api.g_ret_sts_error;

4026: END IF;
4027:
4028: EXCEPTION
4029: WHEN fnd_api.g_exc_error THEN
4030: x_return_status := fnd_api.g_ret_sts_error;
4031: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4032: WHEN fnd_api.g_exc_unexpected_error THEN
4033: x_return_status := fnd_api.g_ret_sts_unexp_error;
4034: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 4032: WHEN fnd_api.g_exc_unexpected_error THEN

4028: EXCEPTION
4029: WHEN fnd_api.g_exc_error THEN
4030: x_return_status := fnd_api.g_ret_sts_error;
4031: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4032: WHEN fnd_api.g_exc_unexpected_error THEN
4033: x_return_status := fnd_api.g_ret_sts_unexp_error;
4034: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4035: WHEN OTHERS THEN
4036: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

Line 4033: x_return_status := fnd_api.g_ret_sts_unexp_error;

4029: WHEN fnd_api.g_exc_error THEN
4030: x_return_status := fnd_api.g_ret_sts_error;
4031: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4032: WHEN fnd_api.g_exc_unexpected_error THEN
4033: x_return_status := fnd_api.g_ret_sts_unexp_error;
4034: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4035: WHEN OTHERS THEN
4036: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
4037: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4037: x_return_status := fnd_api.g_ret_sts_unexp_error;

4033: x_return_status := fnd_api.g_ret_sts_unexp_error;
4034: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4035: WHEN OTHERS THEN
4036: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
4037: x_return_status := fnd_api.g_ret_sts_unexp_error;
4038: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4039: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4040: END IF;
4041: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 4110: x_return_status := fnd_api.g_ret_sts_success;

4106:
4107: BEGIN
4108: SAVEPOINT csf_new_trip;
4109:
4110: x_return_status := fnd_api.g_ret_sts_success;
4111:
4112: IF l_debug THEN
4113: debug(' Creating Trip between ' || format_date(p_start_date_time) || ' and ' || format_date(p_end_date_time), l_api_name, fnd_log.level_statement);
4114: END IF;

Line 4128: RAISE fnd_api.g_exc_error;

4124: debug(' The specified Trip Length is greater than one day', l_api_name, fnd_log.level_error);
4125: END IF;
4126: fnd_message.set_name('CSF', 'CSF_TRIP_LENGTH_MORE_THAN_DAY');
4127: fnd_msg_pub.ADD;
4128: RAISE fnd_api.g_exc_error;
4129: END IF;
4130:
4131: END IF;
4132:

Line 4138: , p_init_msg_list => fnd_api.g_false

4134: -- Create new Shift Tasks for the Trip to be created.
4135: IF p_dep_task_id IS NULL OR p_arr_task_id IS NULL THEN
4136: create_shift_tasks1(
4137: p_api_version => 1.0
4138: , p_init_msg_list => fnd_api.g_false
4139: , p_commit => fnd_api.g_false
4140: , x_return_status => x_return_status
4141: , x_msg_data => x_msg_data
4142: , x_msg_count => x_msg_count

Line 4139: , p_commit => fnd_api.g_false

4135: IF p_dep_task_id IS NULL OR p_arr_task_id IS NULL THEN
4136: create_shift_tasks1(
4137: p_api_version => 1.0
4138: , p_init_msg_list => fnd_api.g_false
4139: , p_commit => fnd_api.g_false
4140: , x_return_status => x_return_status
4141: , x_msg_data => x_msg_data
4142: , x_msg_count => x_msg_count
4143: , p_resource_id => p_resource_id

Line 4157: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4153: , x_dep_task_id => l_dep_task_id
4154: , x_arr_task_id => l_arr_task_id
4155: );
4156:
4157: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4158: IF l_debug THEN
4159: debug(' Unable to Create Shift Tasks: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
4160: END IF;
4161: IF x_return_status = fnd_api.g_ret_sts_error THEN

Line 4161: IF x_return_status = fnd_api.g_ret_sts_error THEN

4157: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4158: IF l_debug THEN
4159: debug(' Unable to Create Shift Tasks: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
4160: END IF;
4161: IF x_return_status = fnd_api.g_ret_sts_error THEN
4162: RAISE fnd_api.g_exc_error;
4163: ELSE
4164: RAISE fnd_api.g_exc_unexpected_error;
4165: END IF;

Line 4162: RAISE fnd_api.g_exc_error;

4158: IF l_debug THEN
4159: debug(' Unable to Create Shift Tasks: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
4160: END IF;
4161: IF x_return_status = fnd_api.g_ret_sts_error THEN
4162: RAISE fnd_api.g_exc_error;
4163: ELSE
4164: RAISE fnd_api.g_exc_unexpected_error;
4165: END IF;
4166: END IF;

Line 4164: RAISE fnd_api.g_exc_unexpected_error;

4160: END IF;
4161: IF x_return_status = fnd_api.g_ret_sts_error THEN
4162: RAISE fnd_api.g_exc_error;
4163: ELSE
4164: RAISE fnd_api.g_exc_unexpected_error;
4165: END IF;
4166: END IF;
4167: IF l_debug THEN
4168: debug(' Created new Shift Tasks - Dep#' || l_dep_task_id || ' : Arr#' || l_arr_task_id, l_api_name, fnd_log.level_statement);

Line 4182: IF p_find_tasks IS NULL OR p_find_tasks = fnd_api.g_true THEN

4178: END IF;
4179: END IF;
4180:
4181: i := 0;
4182: IF p_find_tasks IS NULL OR p_find_tasks = fnd_api.g_true THEN
4183: FOR v_task IN c_linkable_tasks LOOP
4184: --l_time_occupied := v_task.booking_end_date - v_task.booking_start_date; -- Scheduled Task Duration
4185: --l_time_occupied := l_time_occupied + NVL(v_task.travel_time, 0) / g_mins_in_day; -- Scheduled Travel Duration
4186: --l_available_hours := l_available_hours - l_time_occupied * g_hours_in_day;

Line 4227: , p_init_msg_list => fnd_api.g_false

4223:
4224: -- Create the Trip by calling Object Capacity Table Handlers
4225: cac_sr_object_capacity_pub.insert_object_capacity(
4226: p_api_version => 1.0
4227: , p_init_msg_list => fnd_api.g_false
4228: , x_return_status => x_return_status
4229: , x_msg_count => x_msg_count
4230: , x_msg_data => x_msg_data
4231: , p_object_capacity => l_object_capacity_tbl

Line 4232: , p_update_tasks => fnd_api.g_true

4228: , x_return_status => x_return_status
4229: , x_msg_count => x_msg_count
4230: , x_msg_data => x_msg_data
4231: , p_object_capacity => l_object_capacity_tbl
4232: , p_update_tasks => fnd_api.g_true
4233: , p_object_tasks => l_object_tasks_tbl
4234: );
4235:
4236: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 4236: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4232: , p_update_tasks => fnd_api.g_true
4233: , p_object_tasks => l_object_tasks_tbl
4234: );
4235:
4236: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4237: IF l_debug THEN
4238: x_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
4239: debug(' Unable to Create the Object Capacity: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
4240: END IF;

Line 4238: x_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

4234: );
4235:
4236: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4237: IF l_debug THEN
4238: x_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
4239: debug(' Unable to Create the Object Capacity: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
4240: END IF;
4241: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4242: RAISE fnd_api.g_exc_unexpected_error;

Line 4241: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4237: IF l_debug THEN
4238: x_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
4239: debug(' Unable to Create the Object Capacity: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
4240: END IF;
4241: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4242: RAISE fnd_api.g_exc_unexpected_error;
4243: END IF;
4244: RAISE fnd_api.g_exc_error;
4245: END IF;

Line 4242: RAISE fnd_api.g_exc_unexpected_error;

4238: x_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
4239: debug(' Unable to Create the Object Capacity: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
4240: END IF;
4241: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4242: RAISE fnd_api.g_exc_unexpected_error;
4243: END IF;
4244: RAISE fnd_api.g_exc_error;
4245: END IF;
4246:

Line 4244: RAISE fnd_api.g_exc_error;

4240: END IF;
4241: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4242: RAISE fnd_api.g_exc_unexpected_error;
4243: END IF;
4244: RAISE fnd_api.g_exc_error;
4245: END IF;
4246:
4247: x_trip.trip_id := l_object_capacity_tbl(1).object_capacity_id;
4248: x_trip.object_version_number := 1;

Line 4261: WHEN fnd_api.g_exc_error THEN

4257: IF l_debug THEN
4258: debug(' Created Trip - TripID#' || x_trip.trip_id, l_api_name, fnd_log.level_statement);
4259: END IF;
4260: EXCEPTION
4261: WHEN fnd_api.g_exc_error THEN
4262: ROLLBACK TO csf_new_trip;
4263: x_return_status := fnd_api.g_ret_sts_error;
4264: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4265: WHEN fnd_api.g_exc_unexpected_error THEN

Line 4263: x_return_status := fnd_api.g_ret_sts_error;

4259: END IF;
4260: EXCEPTION
4261: WHEN fnd_api.g_exc_error THEN
4262: ROLLBACK TO csf_new_trip;
4263: x_return_status := fnd_api.g_ret_sts_error;
4264: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4265: WHEN fnd_api.g_exc_unexpected_error THEN
4266: ROLLBACK TO csf_new_trip;
4267: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4265: WHEN fnd_api.g_exc_unexpected_error THEN

4261: WHEN fnd_api.g_exc_error THEN
4262: ROLLBACK TO csf_new_trip;
4263: x_return_status := fnd_api.g_ret_sts_error;
4264: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4265: WHEN fnd_api.g_exc_unexpected_error THEN
4266: ROLLBACK TO csf_new_trip;
4267: x_return_status := fnd_api.g_ret_sts_unexp_error;
4268: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4269: WHEN OTHERS THEN

Line 4267: x_return_status := fnd_api.g_ret_sts_unexp_error;

4263: x_return_status := fnd_api.g_ret_sts_error;
4264: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4265: WHEN fnd_api.g_exc_unexpected_error THEN
4266: ROLLBACK TO csf_new_trip;
4267: x_return_status := fnd_api.g_ret_sts_unexp_error;
4268: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4269: WHEN OTHERS THEN
4270: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
4271: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4271: x_return_status := fnd_api.g_ret_sts_unexp_error;

4267: x_return_status := fnd_api.g_ret_sts_unexp_error;
4268: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4269: WHEN OTHERS THEN
4270: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
4271: x_return_status := fnd_api.g_ret_sts_unexp_error;
4272: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4273: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4274: END IF;
4275: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 4343: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4339: , x_msg_data => x_msg_data
4340: , x_task_id => x_dep_task_id
4341: );
4342:
4343: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4344: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
4345: fnd_message.set_token('TASK_NAME', g_dep_task_name);
4346: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4347: fnd_msg_pub.ADD;

Line 4346: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

4342:
4343: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4344: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
4345: fnd_message.set_token('TASK_NAME', g_dep_task_name);
4346: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4347: fnd_msg_pub.ADD;
4348:
4349: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4350: RAISE fnd_api.g_exc_unexpected_error;

Line 4349: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4345: fnd_message.set_token('TASK_NAME', g_dep_task_name);
4346: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4347: fnd_msg_pub.ADD;
4348:
4349: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4350: RAISE fnd_api.g_exc_unexpected_error;
4351: END IF;
4352: RAISE fnd_api.g_exc_error;
4353: END IF;

Line 4350: RAISE fnd_api.g_exc_unexpected_error;

4346: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4347: fnd_msg_pub.ADD;
4348:
4349: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4350: RAISE fnd_api.g_exc_unexpected_error;
4351: END IF;
4352: RAISE fnd_api.g_exc_error;
4353: END IF;
4354:

Line 4352: RAISE fnd_api.g_exc_error;

4348:
4349: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4350: RAISE fnd_api.g_exc_unexpected_error;
4351: END IF;
4352: RAISE fnd_api.g_exc_error;
4353: END IF;
4354:
4355: IF l_debug THEN
4356: debug(' Created Departure Task - Task ID = ' || x_dep_task_id, l_api_name, fnd_log.level_statement);

Line 4386: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4382: , x_msg_data => x_msg_data
4383: , x_task_id => x_arr_task_id
4384: );
4385:
4386: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4387: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
4388: fnd_message.set_token('TASK_NAME', g_arr_task_name);
4389: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4390: fnd_msg_pub.ADD;

Line 4389: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

4385:
4386: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4387: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
4388: fnd_message.set_token('TASK_NAME', g_arr_task_name);
4389: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4390: fnd_msg_pub.ADD;
4391:
4392: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4393: RAISE fnd_api.g_exc_unexpected_error;

Line 4392: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4388: fnd_message.set_token('TASK_NAME', g_arr_task_name);
4389: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4390: fnd_msg_pub.ADD;
4391:
4392: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4393: RAISE fnd_api.g_exc_unexpected_error;
4394: END IF;
4395: RAISE fnd_api.g_exc_error;
4396: END IF;

Line 4393: RAISE fnd_api.g_exc_unexpected_error;

4389: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4390: fnd_msg_pub.ADD;
4391:
4392: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4393: RAISE fnd_api.g_exc_unexpected_error;
4394: END IF;
4395: RAISE fnd_api.g_exc_error;
4396: END IF;
4397: IF l_debug THEN

Line 4395: RAISE fnd_api.g_exc_error;

4391:
4392: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4393: RAISE fnd_api.g_exc_unexpected_error;
4394: END IF;
4395: RAISE fnd_api.g_exc_error;
4396: END IF;
4397: IF l_debug THEN
4398: debug(' Created Arrival Task - Task ID = ' || x_arr_task_id, l_api_name, fnd_log.level_statement);
4399: END IF;

Line 4402: WHEN fnd_api.g_exc_error THEN

4398: debug(' Created Arrival Task - Task ID = ' || x_arr_task_id, l_api_name, fnd_log.level_statement);
4399: END IF;
4400: END IF;
4401: EXCEPTION
4402: WHEN fnd_api.g_exc_error THEN
4403: x_return_status := fnd_api.g_ret_sts_error;
4404: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4405: WHEN fnd_api.g_exc_unexpected_error THEN
4406: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4403: x_return_status := fnd_api.g_ret_sts_error;

4399: END IF;
4400: END IF;
4401: EXCEPTION
4402: WHEN fnd_api.g_exc_error THEN
4403: x_return_status := fnd_api.g_ret_sts_error;
4404: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4405: WHEN fnd_api.g_exc_unexpected_error THEN
4406: x_return_status := fnd_api.g_ret_sts_unexp_error;
4407: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 4405: WHEN fnd_api.g_exc_unexpected_error THEN

4401: EXCEPTION
4402: WHEN fnd_api.g_exc_error THEN
4403: x_return_status := fnd_api.g_ret_sts_error;
4404: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4405: WHEN fnd_api.g_exc_unexpected_error THEN
4406: x_return_status := fnd_api.g_ret_sts_unexp_error;
4407: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4408: WHEN OTHERS THEN
4409: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4406: x_return_status := fnd_api.g_ret_sts_unexp_error;

4402: WHEN fnd_api.g_exc_error THEN
4403: x_return_status := fnd_api.g_ret_sts_error;
4404: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4405: WHEN fnd_api.g_exc_unexpected_error THEN
4406: x_return_status := fnd_api.g_ret_sts_unexp_error;
4407: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4408: WHEN OTHERS THEN
4409: x_return_status := fnd_api.g_ret_sts_unexp_error;
4410: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 4409: x_return_status := fnd_api.g_ret_sts_unexp_error;

4405: WHEN fnd_api.g_exc_unexpected_error THEN
4406: x_return_status := fnd_api.g_ret_sts_unexp_error;
4407: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4408: WHEN OTHERS THEN
4409: x_return_status := fnd_api.g_ret_sts_unexp_error;
4410: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4411: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4412: END IF;
4413: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

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

4454: l_trip_exist VARCHAR2(1);
4455:
4456: BEGIN
4457: -- Check for API Compatibility
4458: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
4459: RAISE fnd_api.g_exc_unexpected_error;
4460: END IF;
4461:
4462: -- Initialize Message Stack if required

Line 4459: RAISE fnd_api.g_exc_unexpected_error;

4455:
4456: BEGIN
4457: -- Check for API Compatibility
4458: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
4459: RAISE fnd_api.g_exc_unexpected_error;
4460: END IF;
4461:
4462: -- Initialize Message Stack if required
4463: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 4463: IF fnd_api.to_boolean(p_init_msg_list) THEN

4459: RAISE fnd_api.g_exc_unexpected_error;
4460: END IF;
4461:
4462: -- Initialize Message Stack if required
4463: IF fnd_api.to_boolean(p_init_msg_list) THEN
4464: fnd_msg_pub.initialize;
4465: END IF;
4466:
4467: -- Initialize Return Status

Line 4468: x_return_status := fnd_api.g_ret_sts_success;

4464: fnd_msg_pub.initialize;
4465: END IF;
4466:
4467: -- Initialize Return Status
4468: x_return_status := fnd_api.g_ret_sts_success;
4469:
4470: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
4471: -- Invalid Trip ID passed.
4472: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');

Line 4470: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN

4466:
4467: -- Initialize Return Status
4468: x_return_status := fnd_api.g_ret_sts_success;
4469:
4470: IF p_trip_id IS NULL OR p_trip_id = fnd_api.g_miss_num THEN
4471: -- Invalid Trip ID passed.
4472: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
4473: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
4474: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');

Line 4476: RAISE fnd_api.g_exc_error;

4472: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
4473: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
4474: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
4475: fnd_msg_pub.ADD;
4476: RAISE fnd_api.g_exc_error;
4477: END IF;
4478:
4479: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
4480: -- Invalid Object Version Number passed.

Line 4479: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN

4475: fnd_msg_pub.ADD;
4476: RAISE fnd_api.g_exc_error;
4477: END IF;
4478:
4479: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
4480: -- Invalid Object Version Number passed.
4481: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
4482: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
4483: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');

Line 4485: RAISE fnd_api.g_exc_error;

4481: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
4482: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
4483: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
4484: fnd_msg_pub.ADD;
4485: RAISE fnd_api.g_exc_error;
4486: END IF;
4487:
4488: IF p_available_hours IS NOT NULL AND p_upd_available_hours IS NOT NULL THEN
4489: -- Error out as both cant be passed.

Line 4494: RAISE fnd_api.g_exc_error;

4490: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
4491: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
4492: fnd_message.set_token('PARAM_NAME', 'P_UPD_AVAILABLE_HOURS');
4493: fnd_msg_pub.ADD;
4494: RAISE fnd_api.g_exc_error;
4495: END IF;
4496:
4497:
4498:

Line 4504: RAISE fnd_api.g_exc_error;

4500: IF l_trip.trip_id IS NULL THEN
4501: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
4502: fnd_message.set_token('TRIP_ID', p_trip_id);
4503: fnd_msg_pub.ADD;
4504: RAISE fnd_api.g_exc_error;
4505: END IF;
4506:
4507:
4508:

Line 4525: RAISE fnd_api.g_exc_error;

4521: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id,l_trip.resource_type));
4522: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
4523: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
4524: fnd_msg_pub.ADD;
4525: RAISE fnd_api.g_exc_error;
4526: END IF;
4527:
4528: change_trip(
4529: x_return_status => x_return_status

Line 4544: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4540: , p_start_date => p_start_date_time
4541: , p_end_date => p_end_date_time
4542: );
4543:
4544: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4545: fnd_message.set_name('CSF', 'CSF_TRIP_UPDATE_FAIL_OTHER');
4546: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
4547: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
4548: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));

Line 4549: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

4545: fnd_message.set_name('CSF', 'CSF_TRIP_UPDATE_FAIL_OTHER');
4546: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
4547: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
4548: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
4549: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4550: fnd_msg_pub.ADD;
4551: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4552: RAISE fnd_api.g_exc_unexpected_error;
4553: END IF;

Line 4551: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4547: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
4548: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
4549: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4550: fnd_msg_pub.ADD;
4551: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4552: RAISE fnd_api.g_exc_unexpected_error;
4553: END IF;
4554: RAISE fnd_api.g_exc_error;
4555: END IF;

Line 4552: RAISE fnd_api.g_exc_unexpected_error;

4548: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
4549: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4550: fnd_msg_pub.ADD;
4551: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4552: RAISE fnd_api.g_exc_unexpected_error;
4553: END IF;
4554: RAISE fnd_api.g_exc_error;
4555: END IF;
4556:

Line 4554: RAISE fnd_api.g_exc_error;

4550: fnd_msg_pub.ADD;
4551: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4552: RAISE fnd_api.g_exc_unexpected_error;
4553: END IF;
4554: RAISE fnd_api.g_exc_error;
4555: END IF;
4556:
4557: IF fnd_api.to_boolean(p_commit) THEN
4558: COMMIT;

Line 4557: IF fnd_api.to_boolean(p_commit) THEN

4553: END IF;
4554: RAISE fnd_api.g_exc_error;
4555: END IF;
4556:
4557: IF fnd_api.to_boolean(p_commit) THEN
4558: COMMIT;
4559: END IF;
4560:
4561: EXCEPTION

Line 4562: WHEN fnd_api.g_exc_error THEN

4558: COMMIT;
4559: END IF;
4560:
4561: EXCEPTION
4562: WHEN fnd_api.g_exc_error THEN
4563: x_return_status := fnd_api.g_ret_sts_error;
4564: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4565: WHEN fnd_api.g_exc_unexpected_error THEN
4566: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4563: x_return_status := fnd_api.g_ret_sts_error;

4559: END IF;
4560:
4561: EXCEPTION
4562: WHEN fnd_api.g_exc_error THEN
4563: x_return_status := fnd_api.g_ret_sts_error;
4564: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4565: WHEN fnd_api.g_exc_unexpected_error THEN
4566: x_return_status := fnd_api.g_ret_sts_unexp_error;
4567: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 4565: WHEN fnd_api.g_exc_unexpected_error THEN

4561: EXCEPTION
4562: WHEN fnd_api.g_exc_error THEN
4563: x_return_status := fnd_api.g_ret_sts_error;
4564: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4565: WHEN fnd_api.g_exc_unexpected_error THEN
4566: x_return_status := fnd_api.g_ret_sts_unexp_error;
4567: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4568: WHEN OTHERS THEN
4569: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);

Line 4566: x_return_status := fnd_api.g_ret_sts_unexp_error;

4562: WHEN fnd_api.g_exc_error THEN
4563: x_return_status := fnd_api.g_ret_sts_error;
4564: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4565: WHEN fnd_api.g_exc_unexpected_error THEN
4566: x_return_status := fnd_api.g_ret_sts_unexp_error;
4567: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4568: WHEN OTHERS THEN
4569: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
4570: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4570: x_return_status := fnd_api.g_ret_sts_unexp_error;

4566: x_return_status := fnd_api.g_ret_sts_unexp_error;
4567: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4568: WHEN OTHERS THEN
4569: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
4570: x_return_status := fnd_api.g_ret_sts_unexp_error;
4571: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4572: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4573: END IF;
4574: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 4639: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4635: , x_msg_count => x_msg_count
4636: , x_msg_data => x_msg_data
4637: );
4638:
4639: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4640:
4641:
4642: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4643: RAISE fnd_api.g_exc_unexpected_error;

Line 4642: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4638:
4639: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4640:
4641:
4642: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4643: RAISE fnd_api.g_exc_unexpected_error;
4644: END IF;
4645: RAISE fnd_api.g_exc_error;
4646: END IF;

Line 4643: RAISE fnd_api.g_exc_unexpected_error;

4639: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4640:
4641:
4642: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4643: RAISE fnd_api.g_exc_unexpected_error;
4644: END IF;
4645: RAISE fnd_api.g_exc_error;
4646: END IF;
4647:

Line 4645: RAISE fnd_api.g_exc_error;

4641:
4642: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4643: RAISE fnd_api.g_exc_unexpected_error;
4644: END IF;
4645: RAISE fnd_api.g_exc_error;
4646: END IF;
4647:
4648:
4649: END IF;

Line 4676: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4672: , x_msg_count => x_msg_count
4673: , x_msg_data => x_msg_data
4674: );
4675:
4676: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4677:
4678:
4679: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4680: RAISE fnd_api.g_exc_unexpected_error;

Line 4679: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4675:
4676: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4677:
4678:
4679: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4680: RAISE fnd_api.g_exc_unexpected_error;
4681: END IF;
4682: RAISE fnd_api.g_exc_error;
4683: END IF;

Line 4680: RAISE fnd_api.g_exc_unexpected_error;

4676: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4677:
4678:
4679: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4680: RAISE fnd_api.g_exc_unexpected_error;
4681: END IF;
4682: RAISE fnd_api.g_exc_error;
4683: END IF;
4684:

Line 4682: RAISE fnd_api.g_exc_error;

4678:
4679: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4680: RAISE fnd_api.g_exc_unexpected_error;
4681: END IF;
4682: RAISE fnd_api.g_exc_error;
4683: END IF;
4684:
4685: END IF;
4686: IF fnd_api.to_boolean(p_commit) THEN

Line 4686: IF fnd_api.to_boolean(p_commit) THEN

4682: RAISE fnd_api.g_exc_error;
4683: END IF;
4684:
4685: END IF;
4686: IF fnd_api.to_boolean(p_commit) THEN
4687: COMMIT;
4688: END IF;
4689:
4690:

Line 4692: WHEN fnd_api.g_exc_error THEN

4688: END IF;
4689:
4690:
4691: EXCEPTION
4692: WHEN fnd_api.g_exc_error THEN
4693: x_return_status := fnd_api.g_ret_sts_error;
4694: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4695: WHEN fnd_api.g_exc_unexpected_error THEN
4696: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4693: x_return_status := fnd_api.g_ret_sts_error;

4689:
4690:
4691: EXCEPTION
4692: WHEN fnd_api.g_exc_error THEN
4693: x_return_status := fnd_api.g_ret_sts_error;
4694: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4695: WHEN fnd_api.g_exc_unexpected_error THEN
4696: x_return_status := fnd_api.g_ret_sts_unexp_error;
4697: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 4695: WHEN fnd_api.g_exc_unexpected_error THEN

4691: EXCEPTION
4692: WHEN fnd_api.g_exc_error THEN
4693: x_return_status := fnd_api.g_ret_sts_error;
4694: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4695: WHEN fnd_api.g_exc_unexpected_error THEN
4696: x_return_status := fnd_api.g_ret_sts_unexp_error;
4697: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4698: WHEN OTHERS THEN
4699: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4696: x_return_status := fnd_api.g_ret_sts_unexp_error;

4692: WHEN fnd_api.g_exc_error THEN
4693: x_return_status := fnd_api.g_ret_sts_error;
4694: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4695: WHEN fnd_api.g_exc_unexpected_error THEN
4696: x_return_status := fnd_api.g_ret_sts_unexp_error;
4697: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4698: WHEN OTHERS THEN
4699: x_return_status := fnd_api.g_ret_sts_unexp_error;
4700: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 4699: x_return_status := fnd_api.g_ret_sts_unexp_error;

4695: WHEN fnd_api.g_exc_unexpected_error THEN
4696: x_return_status := fnd_api.g_ret_sts_unexp_error;
4697: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4698: WHEN OTHERS THEN
4699: x_return_status := fnd_api.g_ret_sts_unexp_error;
4700: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4701: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4702: END IF;
4703: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

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

4718: l_api_version CONSTANT NUMBER := 1.0;
4719: BEGIN
4720: SAVEPOINT csf_dc_trip;
4721:
4722: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
4723: RAISE fnd_api.g_exc_unexpected_error;
4724: END IF;
4725:
4726: -- Initialize Message Stack if required

Line 4723: RAISE fnd_api.g_exc_unexpected_error;

4719: BEGIN
4720: SAVEPOINT csf_dc_trip;
4721:
4722: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
4723: RAISE fnd_api.g_exc_unexpected_error;
4724: END IF;
4725:
4726: -- Initialize Message Stack if required
4727: IF fnd_api.to_boolean(p_init_msg_list) THEN

Line 4727: IF fnd_api.to_boolean(p_init_msg_list) THEN

4723: RAISE fnd_api.g_exc_unexpected_error;
4724: END IF;
4725:
4726: -- Initialize Message Stack if required
4727: IF fnd_api.to_boolean(p_init_msg_list) THEN
4728: fnd_msg_pub.initialize;
4729: END IF;
4730:
4731: -- Initialize Return Status

Line 4732: x_return_status := fnd_api.g_ret_sts_success;

4728: fnd_msg_pub.initialize;
4729: END IF;
4730:
4731: -- Initialize Return Status
4732: x_return_status := fnd_api.g_ret_sts_success;
4733:
4734: create_trips(
4735: x_return_status => x_return_status
4736: , x_msg_data => x_msg_data

Line 4751: --IF x_return_status <> fnd_api.g_ret_sts_success THEN

4747: , x_return_status => x_return_status
4748: , x_msg_data => x_msg_data
4749: , x_msg_count => x_msg_count);
4750:
4751: --IF x_return_status <> fnd_api.g_ret_sts_success THEN
4752: --IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4753: --RAISE fnd_api.g_exc_unexpected_error;
4754: --END IF;
4755: --RAISE fnd_api.g_exc_error;

Line 4752: --IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4748: , x_msg_data => x_msg_data
4749: , x_msg_count => x_msg_count);
4750:
4751: --IF x_return_status <> fnd_api.g_ret_sts_success THEN
4752: --IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4753: --RAISE fnd_api.g_exc_unexpected_error;
4754: --END IF;
4755: --RAISE fnd_api.g_exc_error;
4756: --END IF;

Line 4753: --RAISE fnd_api.g_exc_unexpected_error;

4749: , x_msg_count => x_msg_count);
4750:
4751: --IF x_return_status <> fnd_api.g_ret_sts_success THEN
4752: --IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4753: --RAISE fnd_api.g_exc_unexpected_error;
4754: --END IF;
4755: --RAISE fnd_api.g_exc_error;
4756: --END IF;
4757:

Line 4755: --RAISE fnd_api.g_exc_error;

4751: --IF x_return_status <> fnd_api.g_ret_sts_success THEN
4752: --IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4753: --RAISE fnd_api.g_exc_unexpected_error;
4754: --END IF;
4755: --RAISE fnd_api.g_exc_error;
4756: --END IF;
4757:
4758: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4759: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');

Line 4758: IF x_return_status <> fnd_api.g_ret_sts_success THEN

4754: --END IF;
4755: --RAISE fnd_api.g_exc_error;
4756: --END IF;
4757:
4758: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4759: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
4760: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_tbl(1).resource_id, p_resource_tbl(1).resource_type));
4761: fnd_message.set_token('START_TIME', format_date(p_start_date));
4762: fnd_message.set_token('END_TIME', format_date(p_end_date));

Line 4763: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));

4759: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
4760: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_tbl(1).resource_id, p_resource_tbl(1).resource_type));
4761: fnd_message.set_token('START_TIME', format_date(p_start_date));
4762: fnd_message.set_token('END_TIME', format_date(p_end_date));
4763: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4764: fnd_msg_pub.ADD;
4765: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4766: RAISE fnd_api.g_exc_unexpected_error;
4767: END IF;

Line 4765: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

4761: fnd_message.set_token('START_TIME', format_date(p_start_date));
4762: fnd_message.set_token('END_TIME', format_date(p_end_date));
4763: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4764: fnd_msg_pub.ADD;
4765: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4766: RAISE fnd_api.g_exc_unexpected_error;
4767: END IF;
4768: RAISE fnd_api.g_exc_error;
4769: END IF;

Line 4766: RAISE fnd_api.g_exc_unexpected_error;

4762: fnd_message.set_token('END_TIME', format_date(p_end_date));
4763: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
4764: fnd_msg_pub.ADD;
4765: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4766: RAISE fnd_api.g_exc_unexpected_error;
4767: END IF;
4768: RAISE fnd_api.g_exc_error;
4769: END IF;
4770:

Line 4768: RAISE fnd_api.g_exc_error;

4764: fnd_msg_pub.ADD;
4765: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
4766: RAISE fnd_api.g_exc_unexpected_error;
4767: END IF;
4768: RAISE fnd_api.g_exc_error;
4769: END IF;
4770:
4771: IF fnd_api.to_boolean(p_commit) THEN
4772: COMMIT;

Line 4771: IF fnd_api.to_boolean(p_commit) THEN

4767: END IF;
4768: RAISE fnd_api.g_exc_error;
4769: END IF;
4770:
4771: IF fnd_api.to_boolean(p_commit) THEN
4772: COMMIT;
4773: END IF;
4774: EXCEPTION
4775: WHEN fnd_api.g_exc_error THEN

Line 4775: WHEN fnd_api.g_exc_error THEN

4771: IF fnd_api.to_boolean(p_commit) THEN
4772: COMMIT;
4773: END IF;
4774: EXCEPTION
4775: WHEN fnd_api.g_exc_error THEN
4776: ROLLBACK TO csf_dc_trip;
4777: x_return_status := fnd_api.g_ret_sts_error;
4778: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4779: WHEN fnd_api.g_exc_unexpected_error THEN

Line 4777: x_return_status := fnd_api.g_ret_sts_error;

4773: END IF;
4774: EXCEPTION
4775: WHEN fnd_api.g_exc_error THEN
4776: ROLLBACK TO csf_dc_trip;
4777: x_return_status := fnd_api.g_ret_sts_error;
4778: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4779: WHEN fnd_api.g_exc_unexpected_error THEN
4780: ROLLBACK TO csf_dc_trip;
4781: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4779: WHEN fnd_api.g_exc_unexpected_error THEN

4775: WHEN fnd_api.g_exc_error THEN
4776: ROLLBACK TO csf_dc_trip;
4777: x_return_status := fnd_api.g_ret_sts_error;
4778: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4779: WHEN fnd_api.g_exc_unexpected_error THEN
4780: ROLLBACK TO csf_dc_trip;
4781: x_return_status := fnd_api.g_ret_sts_unexp_error;
4782: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4783: WHEN OTHERS THEN

Line 4781: x_return_status := fnd_api.g_ret_sts_unexp_error;

4777: x_return_status := fnd_api.g_ret_sts_error;
4778: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4779: WHEN fnd_api.g_exc_unexpected_error THEN
4780: ROLLBACK TO csf_dc_trip;
4781: x_return_status := fnd_api.g_ret_sts_unexp_error;
4782: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4783: WHEN OTHERS THEN
4784: ROLLBACK TO csf_dc_trip;
4785: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4785: x_return_status := fnd_api.g_ret_sts_unexp_error;

4781: x_return_status := fnd_api.g_ret_sts_unexp_error;
4782: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
4783: WHEN OTHERS THEN
4784: ROLLBACK TO csf_dc_trip;
4785: x_return_status := fnd_api.g_ret_sts_unexp_error;
4786: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
4787: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4788: END IF;
4789: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);

Line 4818: IF NOT FND_API.Compatible_API_Call (l_api_version ,

4814: BEGIN
4815:
4816:
4817: -- Standard call to check for call compatibility.
4818: IF NOT FND_API.Compatible_API_Call (l_api_version ,
4819: p_api_version ,
4820: l_api_name ,
4821: G_PKG_NAME )
4822: THEN

Line 4823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4819: p_api_version ,
4820: l_api_name ,
4821: G_PKG_NAME )
4822: THEN
4823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4824: END IF;
4825:
4826: -- Initialize message list if p_init_msg_list is set to TRUE.
4827: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 4827: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4824: END IF;
4825:
4826: -- Initialize message list if p_init_msg_list is set to TRUE.
4827: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4828: FND_MSG_PUB.initialize;
4829: END IF;
4830:
4831: -- Initialize API return status to success

Line 4832: x_return_status := FND_API.G_RET_STS_SUCCESS;

4828: FND_MSG_PUB.initialize;
4829: END IF;
4830:
4831: -- Initialize API return status to success
4832: x_return_status := FND_API.G_RET_STS_SUCCESS;
4833: -- Get the dates in Server Timezone
4834: -- Calculate diff ,if greater than 24 convert back to Resoruce timezone.
4835: -- check the diff in Resource timezone
4836: -- if >24 error out else Convert back to Server timezone again and

Line 4864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4860: END IF;
4861: EXCEPTION
4862: when others then
4863:
4864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4865:
4866: FND_MSG_PUB.Count_And_Get
4867: ( p_count => x_msg_count,
4868: p_data => x_msg_data

Line 4890: IF NOT FND_API.Compatible_API_Call (l_api_version ,

4886:
4887: BEGIN
4888:
4889: -- Standard call to check for call compatibility.
4890: IF NOT FND_API.Compatible_API_Call (l_api_version ,
4891: p_api_version ,
4892: l_api_name ,
4893: G_PKG_NAME )
4894: THEN

Line 4895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4891: p_api_version ,
4892: l_api_name ,
4893: G_PKG_NAME )
4894: THEN
4895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4896: END IF;
4897:
4898: -- Initialize message list if p_init_msg_list is set to TRUE.
4899: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 4899: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4896: END IF;
4897:
4898: -- Initialize message list if p_init_msg_list is set to TRUE.
4899: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4900: FND_MSG_PUB.initialize;
4901: END IF;
4902:
4903: -- Initialize API return status to success

Line 4904: x_return_status := FND_API.G_RET_STS_SUCCESS;

4900: FND_MSG_PUB.initialize;
4901: END IF;
4902:
4903: -- Initialize API return status to success
4904: x_return_status := FND_API.G_RET_STS_SUCCESS;
4905:
4906: HZ_TIMEZONE_PUB.Get_Time( l_API_VERSION
4907: , l_INIT_MSG_LIST
4908: , P_Server_TZ_Id

Line 4919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4915:
4916: Return x_Server_time;
4917:
4918: EXCEPTION
4919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4921: FND_MSG_PUB.Count_And_Get
4922: ( p_count => x_msg_count,
4923: p_data => x_msg_data

Line 4920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4916: Return x_Server_time;
4917:
4918: EXCEPTION
4919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4921: FND_MSG_PUB.Count_And_Get
4922: ( p_count => x_msg_count,
4923: p_data => x_msg_data
4924: );

Line 4927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

4923: p_data => x_msg_data
4924: );
4925:
4926: WHEN OTHERS THEN
4927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4928:
4929: FND_MSG_PUB.Count_And_Get
4930: ( p_count => x_msg_count,
4931: p_data => x_msg_data

Line 5055: IF x_return_status <> fnd_api.g_ret_sts_success THEN

5051: , p_task_id => l_tasks.task_id
5052: , p_object_version_number => l_tasks.object_version_number
5053: );
5054:
5055: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5056: IF l_debug THEN
5057: debug(' Unable to Delete the dangling shift Task', l_api_name, fnd_log.level_error);
5058: END IF;
5059:

Line 5064: , fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)

5060: add_message( p_resource_tbl(i).resource_id
5061: , p_resource_tbl(i).resource_type
5062: , l_tasks.scheduled_start_date
5063: , l_tasks.scheduled_end_date
5064: , fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
5065: , 'CSF_TASK_DELETE_FAIL'
5066: , g_error_message );
5067:
5068: END IF;

Line 5149: IF x_return_status <> fnd_api.g_ret_sts_success THEN

5145: , p_task_id => l_tasks.task_id
5146: , p_object_version_number => l_tasks.object_version_number
5147: );
5148:
5149: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5150: IF l_debug THEN
5151: debug(' Unable to Delete the Duplicate shift Task', l_api_name, fnd_log.level_error);
5152: END IF;
5153:

Line 5158: , fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)

5154: add_message( p_resource_tbl(i).resource_id
5155: , p_resource_tbl(i).resource_type
5156: , null
5157: , null
5158: , fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
5159: , 'CSF_TASK_DELETE_FAIL'
5160: , g_error_message );
5161:
5162:

Line 5259: p_commit => fnd_api.G_FALSE,

5255: CLOSE c_trip_info;
5256:
5257: JTF_TASK_ASSIGNMENTS_PUB.UPDATE_TASK_ASSIGNMENT(
5258: p_api_version => 1.0,
5259: p_commit => fnd_api.G_FALSE,
5260: p_object_version_number => l_tasks.OBJECT_VERSION_NUMBER,
5261: p_task_assignment_id => l_tasks.TASK_ASSIGNMENT_ID,
5262: p_enable_workflow => NULL,
5263: p_abort_workflow => NULL,

Line 5270: IF x_return_status <> fnd_api.g_ret_sts_success THEN

5266: x_msg_count => x_msg_count,
5267: x_msg_data => x_msg_data
5268: );
5269:
5270: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5271: IF l_debug THEN
5272: debug('Unable to Update the Object Capacity Id for Task ' || l_tasks.task_id, l_api_name, fnd_log.level_error);
5273: END IF;
5274: END IF;

Line 5300: IF x_return_status <> fnd_api.g_ret_sts_success THEN

5296: , p_object_version_number => l_trip_info.object_version_number
5297: , p_available_hours => l_available_hours
5298: );
5299:
5300: IF x_return_status <> fnd_api.g_ret_sts_success THEN
5301: IF l_debug THEN
5302: debug('Unable to update the available hours for Object Capacity Id ' || l_tasks.task_id, l_api_name, fnd_log.level_error);
5303: END IF;
5304: END IF;