[Home] [Help]
192: x_return_status := fnd_api.g_ret_sts_success;
193:
194: -- First Clear the Message Stack if the API is given the permission to clear stack.
195: IF fnd_api.to_boolean(p_init_msg_list) THEN
196: fnd_msg_pub.initialize;
197: END IF;
198:
199: l_success := 0;
200: l_failed := 0;
222: IF g_messages(i).error_reason IS NOT NULL THEN
223: fnd_message.set_token('REASON', g_messages(i).error_reason);
224: END IF;
225:
226: fnd_msg_pub.ADD;
227:
228: IF g_messages(i).message_type = g_error_message THEN
229: l_failed := l_failed + 1;
230: ELSE
275: fnd_message.set_token('ACTION', l_action_name);
276: fnd_message.set_token('RESOURCE', l_res_name);
277: fnd_message.set_token('START_DATE', p_start_date);
278: fnd_message.set_token('END_DATE', p_end_date);
279: fnd_msg_pub.ADD;
280: END process_messages;
281:
282: PROCEDURE init_package IS
283: BEGIN
456: END IF;
457:
458: IF l_address.party_site_id IS NULL THEN
459: IF l_debug THEN
460: x_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
461: debug(' CSF_RESOURCE_ADDRESS_PVT failed to give Party Site ID' || x_msg_data, l_api_name, fnd_log.level_error);
462: END IF;
463: fnd_message.set_name('CSF', 'CSF_RESOURCE_NO_ACTIVE_PARTY');
464: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
462: END IF;
463: fnd_message.set_name('CSF', 'CSF_RESOURCE_NO_ACTIVE_PARTY');
464: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
465: fnd_message.set_token('DATE', format_date(p_start_date_time));
466: fnd_msg_pub.ADD;
467: RAISE fnd_api.g_exc_error;
468: END IF;
469:
470: -- Departure and Arrival Task Resource Assignment
500:
501: IF x_return_status <> fnd_api.g_ret_sts_success THEN
502: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
503: fnd_message.set_token('TASK_NAME', g_dep_task_name);
504: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
505: fnd_msg_pub.ADD;
506:
507: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
508: RAISE fnd_api.g_exc_unexpected_error;
501: IF x_return_status <> fnd_api.g_ret_sts_success THEN
502: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
503: fnd_message.set_token('TASK_NAME', g_dep_task_name);
504: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
505: fnd_msg_pub.ADD;
506:
507: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
508: RAISE fnd_api.g_exc_unexpected_error;
509: END IF;
543:
544: IF x_return_status <> fnd_api.g_ret_sts_success THEN
545: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
546: fnd_message.set_token('TASK_NAME', g_arr_task_name);
547: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
548: fnd_msg_pub.ADD;
549:
550: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
551: RAISE fnd_api.g_exc_unexpected_error;
544: IF x_return_status <> fnd_api.g_ret_sts_success THEN
545: fnd_message.set_name('CSF', 'CSF_TASK_CREATE_FAIL');
546: fnd_message.set_token('TASK_NAME', g_arr_task_name);
547: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
548: fnd_msg_pub.ADD;
549:
550: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
551: RAISE fnd_api.g_exc_unexpected_error;
552: END IF;
558: END IF;
559: EXCEPTION
560: WHEN fnd_api.g_exc_error THEN
561: x_return_status := fnd_api.g_ret_sts_error;
562: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
563: WHEN fnd_api.g_exc_unexpected_error THEN
564: x_return_status := fnd_api.g_ret_sts_unexp_error;
565: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
566: WHEN OTHERS THEN
561: x_return_status := fnd_api.g_ret_sts_error;
562: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
563: WHEN fnd_api.g_exc_unexpected_error THEN
564: x_return_status := fnd_api.g_ret_sts_unexp_error;
565: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
566: WHEN OTHERS THEN
567: x_return_status := fnd_api.g_ret_sts_unexp_error;
568: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
569: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
564: x_return_status := fnd_api.g_ret_sts_unexp_error;
565: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
566: WHEN OTHERS THEN
567: x_return_status := fnd_api.g_ret_sts_unexp_error;
568: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
569: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
570: END IF;
571: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
572: END create_shift_tasks;
565: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
566: WHEN OTHERS THEN
567: x_return_status := fnd_api.g_ret_sts_unexp_error;
568: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
569: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
570: END IF;
571: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
572: END create_shift_tasks;
573:
567: x_return_status := fnd_api.g_ret_sts_unexp_error;
568: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
569: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
570: END IF;
571: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
572: END create_shift_tasks;
573:
574: FUNCTION get_new_task_status(p_action VARCHAR2, p_current_status NUMBER)
575: RETURN NUMBER IS
671: IF l_debug THEN
672: debug(' The specified Trip Length is greater than one day', l_api_name, fnd_log.level_error);
673: END IF;
674: fnd_message.set_name('CSF', 'CSF_TRIP_LENGTH_MORE_THAN_DAY');
675: fnd_msg_pub.ADD;
676: RAISE fnd_api.g_exc_error;
677: END IF;
678:
679:
775: );
776:
777: IF x_return_status <> fnd_api.g_ret_sts_success THEN
778: IF l_debug THEN
779: x_msg_data := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
780: debug(' Unable to Create the Object Capacity: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
781: END IF;
782: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
783: RAISE fnd_api.g_exc_unexpected_error;
801: EXCEPTION
802: WHEN fnd_api.g_exc_error THEN
803: ROLLBACK TO csf_new_trip;
804: x_return_status := fnd_api.g_ret_sts_error;
805: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
806: WHEN fnd_api.g_exc_unexpected_error THEN
807: ROLLBACK TO csf_new_trip;
808: x_return_status := fnd_api.g_ret_sts_unexp_error;
809: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
805: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
806: WHEN fnd_api.g_exc_unexpected_error THEN
807: ROLLBACK TO csf_new_trip;
808: x_return_status := fnd_api.g_ret_sts_unexp_error;
809: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
810: WHEN OTHERS THEN
811: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
812: x_return_status := fnd_api.g_ret_sts_unexp_error;
813: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
809: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
810: WHEN OTHERS THEN
811: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
812: x_return_status := fnd_api.g_ret_sts_unexp_error;
813: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
814: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
815: END IF;
816: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
817: ROLLBACK TO csf_new_trip;
810: WHEN OTHERS THEN
811: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
812: x_return_status := fnd_api.g_ret_sts_unexp_error;
813: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
814: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
815: END IF;
816: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
817: ROLLBACK TO csf_new_trip;
818: END new_trip;
812: x_return_status := fnd_api.g_ret_sts_unexp_error;
813: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
814: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
815: END IF;
816: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
817: ROLLBACK TO csf_new_trip;
818: END new_trip;
819:
820: PROCEDURE change_trip(
908: fnd_message.set_name('CSF', 'CSF_TRIP_WRONG_AVAILABILITY');
909: fnd_message.set_token('AVAILABLE', l_available_hours);
910: fnd_message.set_token('AVLBEFORE', l_available_hours_before);
911: fnd_message.set_token('AVLAFTER', l_available_hours_after);
912: fnd_msg_pub.ADD;
913: RAISE fnd_api.g_exc_error;
914: END IF;
915:
916: IF l_available_hours = l_shift_length
926: fnd_message.set_name('CSF', 'CSF_TRIP_WRONG_AVL_BEFOREAFTER');
927: fnd_message.set_token('AVLBEFORE', l_available_hours_before);
928: fnd_message.set_token('AVLAFTER', l_available_hours_after);
929: fnd_message.set_token('AVAILABLE', l_available_hours);
930: fnd_msg_pub.ADD;
931: RAISE fnd_api.g_exc_error;
932: END IF;
933:
934: cac_sr_object_capacity_pub.update_object_capacity(
993: , x_task_status_id => v_task.task_status_id
994: );
995:
996: IF x_return_status <> fnd_api.g_ret_sts_success THEN
997: -- Somehow direct population of the Token using fnd_msg_pub is not working
998: -- Therefore populating it in x_msg_data and using it to populate the Token REASON.
999: x_msg_data := fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false);
1000: IF l_debug THEN
1001: debug(' Unable to update the Assignment: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
995:
996: IF x_return_status <> fnd_api.g_ret_sts_success THEN
997: -- Somehow direct population of the Token using fnd_msg_pub is not working
998: -- Therefore populating it in x_msg_data and using it to populate the Token REASON.
999: x_msg_data := fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false);
1000: IF l_debug THEN
1001: debug(' Unable to update the Assignment: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
1002: END IF;
1003: fnd_message.set_name('CSF', 'CSF_ASSIGNMENT_UPDATE_FAIL');
1002: END IF;
1003: fnd_message.set_name('CSF', 'CSF_ASSIGNMENT_UPDATE_FAIL');
1004: fnd_message.set_token('TASK', v_task.task_number);
1005: fnd_message.set_token('REASON', x_msg_data);
1006: fnd_msg_pub.ADD;
1007: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1008: RAISE fnd_api.g_exc_unexpected_error;
1009: END IF;
1010: RAISE fnd_api.g_exc_error;
1014: EXCEPTION
1015: WHEN fnd_api.g_exc_error THEN
1016: ROLLBACK TO csf_change_trip;
1017: x_return_status := fnd_api.g_ret_sts_error;
1018: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1019: WHEN fnd_api.g_exc_unexpected_error THEN
1020: ROLLBACK TO csf_change_trip;
1021: x_return_status := fnd_api.g_ret_sts_unexp_error;
1022: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1018: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1019: WHEN fnd_api.g_exc_unexpected_error THEN
1020: ROLLBACK TO csf_change_trip;
1021: x_return_status := fnd_api.g_ret_sts_unexp_error;
1022: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1023: WHEN OTHERS THEN
1024: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1025: x_return_status := fnd_api.g_ret_sts_unexp_error;
1026: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1022: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1023: WHEN OTHERS THEN
1024: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1025: x_return_status := fnd_api.g_ret_sts_unexp_error;
1026: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1027: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1028: END IF;
1029: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1030: ROLLBACK TO csf_change_trip;
1023: WHEN OTHERS THEN
1024: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1025: x_return_status := fnd_api.g_ret_sts_unexp_error;
1026: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1027: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1028: END IF;
1029: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1030: ROLLBACK TO csf_change_trip;
1031: END change_trip;
1025: x_return_status := fnd_api.g_ret_sts_unexp_error;
1026: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1027: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1028: END IF;
1029: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1030: ROLLBACK TO csf_change_trip;
1031: END change_trip;
1032:
1033: PROCEDURE remove_trip(
1073: debug(' The Trip is unavailable and so cant be deleted', l_api_name, fnd_log.level_error);
1074: END IF;
1075:
1076: fnd_message.set_name('CSF', 'CSF_TRIP_IS_BLOCKED');
1077: fnd_msg_pub.ADD;
1078: RAISE fnd_api.g_exc_error;
1079: END IF;
1080:
1081: -- Check whether there are active Task Assignments in the Trip
1086: debug(' Trip has active Tasks and so cant be deleted', l_api_name, fnd_log.level_error);
1087: END IF;
1088:
1089: fnd_message.set_name('CSF', 'CSF_TRIP_HAS_ACTIVE_TASKS');
1090: fnd_msg_pub.ADD;
1091: RAISE fnd_api.g_exc_error;
1092: END IF;
1093: END IF;
1094:
1111: END IF;
1112:
1113: fnd_message.set_name('CSF', 'CSF_TASK_DELETE_FAIL');
1114: fnd_message.set_token('TASK', v_shift_task.task_number);
1115: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1116: fnd_msg_pub.ADD;
1117: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1118: RAISE fnd_api.g_exc_unexpected_error;
1119: END IF;
1112:
1113: fnd_message.set_name('CSF', 'CSF_TASK_DELETE_FAIL');
1114: fnd_message.set_token('TASK', v_shift_task.task_number);
1115: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1116: fnd_msg_pub.ADD;
1117: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1118: RAISE fnd_api.g_exc_unexpected_error;
1119: END IF;
1120: RAISE fnd_api.g_exc_error;
1148: EXCEPTION
1149: WHEN fnd_api.g_exc_error THEN
1150: ROLLBACK TO csf_remove_trip;
1151: x_return_status := fnd_api.g_ret_sts_error;
1152: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1153: WHEN fnd_api.g_exc_unexpected_error THEN
1154: ROLLBACK TO csf_remove_trip;
1155: x_return_status := fnd_api.g_ret_sts_unexp_error;
1156: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1152: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1153: WHEN fnd_api.g_exc_unexpected_error THEN
1154: ROLLBACK TO csf_remove_trip;
1155: x_return_status := fnd_api.g_ret_sts_unexp_error;
1156: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1157: WHEN OTHERS THEN
1158: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1159: x_return_status := fnd_api.g_ret_sts_unexp_error;
1160: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1156: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1157: WHEN OTHERS THEN
1158: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1159: x_return_status := fnd_api.g_ret_sts_unexp_error;
1160: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1161: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1162: END IF;
1163: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1164: ROLLBACK TO csf_remove_trip;
1157: WHEN OTHERS THEN
1158: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1159: x_return_status := fnd_api.g_ret_sts_unexp_error;
1160: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1161: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1162: END IF;
1163: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1164: ROLLBACK TO csf_remove_trip;
1165: END remove_trip;
1159: x_return_status := fnd_api.g_ret_sts_unexp_error;
1160: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1161: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1162: END IF;
1163: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1164: ROLLBACK TO csf_remove_trip;
1165: END remove_trip;
1166:
1167: PROCEDURE correct_trip(
1302: END IF;
1303:
1304: fnd_message.set_name('CSF', 'CSF_TASK_DELETE_FAIL');
1305: fnd_message.set_token('TASK', v_shift_task.task_number);
1306: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1307: fnd_msg_pub.ADD;
1308: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1309: RAISE fnd_api.g_exc_unexpected_error;
1310: END IF;
1303:
1304: fnd_message.set_name('CSF', 'CSF_TASK_DELETE_FAIL');
1305: fnd_message.set_token('TASK', v_shift_task.task_number);
1306: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1307: fnd_msg_pub.ADD;
1308: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1309: RAISE fnd_api.g_exc_unexpected_error;
1310: END IF;
1311: RAISE fnd_api.g_exc_error;
1368:
1369: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1370: fnd_message.set_name('CSF', 'CSF_ASSIGNMENT_UPDATE_FAIL');
1371: fnd_message.set_token('TASK', v_task.task_number);
1372: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1373: fnd_msg_pub.ADD;
1374: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1375: RAISE fnd_api.g_exc_unexpected_error;
1376: END IF;
1369: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1370: fnd_message.set_name('CSF', 'CSF_ASSIGNMENT_UPDATE_FAIL');
1371: fnd_message.set_token('TASK', v_task.task_number);
1372: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
1373: fnd_msg_pub.ADD;
1374: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1375: RAISE fnd_api.g_exc_unexpected_error;
1376: END IF;
1377: RAISE fnd_api.g_exc_error;
1406: EXCEPTION
1407: WHEN fnd_api.g_exc_error THEN
1408: ROLLBACK TO csf_correct_trip;
1409: x_return_status := fnd_api.g_ret_sts_error;
1410: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1411: WHEN fnd_api.g_exc_unexpected_error THEN
1412: ROLLBACK TO csf_correct_trip;
1413: x_return_status := fnd_api.g_ret_sts_unexp_error;
1414: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1410: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1411: WHEN fnd_api.g_exc_unexpected_error THEN
1412: ROLLBACK TO csf_correct_trip;
1413: x_return_status := fnd_api.g_ret_sts_unexp_error;
1414: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1415: WHEN OTHERS THEN
1416: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1417: x_return_status := fnd_api.g_ret_sts_unexp_error;
1418: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1414: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1415: WHEN OTHERS THEN
1416: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1417: x_return_status := fnd_api.g_ret_sts_unexp_error;
1418: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1419: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1420: END IF;
1421: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1422: ROLLBACK TO csf_correct_trip;
1415: WHEN OTHERS THEN
1416: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1417: x_return_status := fnd_api.g_ret_sts_unexp_error;
1418: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1419: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1420: END IF;
1421: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1422: ROLLBACK TO csf_correct_trip;
1423: END correct_trip;
1417: x_return_status := fnd_api.g_ret_sts_unexp_error;
1418: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1419: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1420: END IF;
1421: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1422: ROLLBACK TO csf_correct_trip;
1423: END correct_trip;
1424:
1425:
1481:
1482: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1483: add_message(
1484: p_trip => p_trips(i)
1485: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
1486: , p_msg_name => 'CSF_TRIP_DELETE_FAIL_OTHER'
1487: , p_msg_type => g_error_message
1488: );
1489: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1495: END LOOP;
1496: EXCEPTION
1497: WHEN fnd_api.g_exc_error THEN
1498: x_return_status := fnd_api.g_ret_sts_error;
1499: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1500: WHEN fnd_api.g_exc_unexpected_error THEN
1501: x_return_status := fnd_api.g_ret_sts_unexp_error;
1502: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1503: WHEN OTHERS THEN
1498: x_return_status := fnd_api.g_ret_sts_error;
1499: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1500: WHEN fnd_api.g_exc_unexpected_error THEN
1501: x_return_status := fnd_api.g_ret_sts_unexp_error;
1502: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1503: WHEN OTHERS THEN
1504: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1505: x_return_status := fnd_api.g_ret_sts_unexp_error;
1506: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1502: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1503: WHEN OTHERS THEN
1504: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1505: x_return_status := fnd_api.g_ret_sts_unexp_error;
1506: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1507: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1508: END IF;
1509: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1510: END delete_trips;
1503: WHEN OTHERS THEN
1504: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1505: x_return_status := fnd_api.g_ret_sts_unexp_error;
1506: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1507: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1508: END IF;
1509: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1510: END delete_trips;
1511:
1505: x_return_status := fnd_api.g_ret_sts_unexp_error;
1506: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1507: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1508: END IF;
1509: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1510: END delete_trips;
1511:
1512: PROCEDURE fix_trips(
1513: x_return_status OUT NOCOPY VARCHAR2
1535:
1536: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1537: add_message(
1538: p_trip => p_trips(i)
1539: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
1540: , p_msg_name => 'CSF_TRIP_FIX_FAIL_OTHER'
1541: , p_msg_type => g_error_message
1542: );
1543: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1549: END LOOP;
1550: EXCEPTION
1551: WHEN fnd_api.g_exc_error THEN
1552: x_return_status := fnd_api.g_ret_sts_error;
1553: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1554: WHEN fnd_api.g_exc_unexpected_error THEN
1555: x_return_status := fnd_api.g_ret_sts_unexp_error;
1556: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1557: WHEN OTHERS THEN
1552: x_return_status := fnd_api.g_ret_sts_error;
1553: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1554: WHEN fnd_api.g_exc_unexpected_error THEN
1555: x_return_status := fnd_api.g_ret_sts_unexp_error;
1556: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1557: WHEN OTHERS THEN
1558: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1559: x_return_status := fnd_api.g_ret_sts_unexp_error;
1560: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1556: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1557: WHEN OTHERS THEN
1558: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1559: x_return_status := fnd_api.g_ret_sts_unexp_error;
1560: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1561: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1562: END IF;
1563: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1564: END fix_trips;
1557: WHEN OTHERS THEN
1558: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
1559: x_return_status := fnd_api.g_ret_sts_unexp_error;
1560: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1561: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1562: END IF;
1563: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1564: END fix_trips;
1565:
1559: x_return_status := fnd_api.g_ret_sts_unexp_error;
1560: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1561: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1562: END IF;
1563: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
1564: END fix_trips;
1565:
1566: PROCEDURE create_trips(
1567: x_return_status OUT NOCOPY VARCHAR2
1686: p_res_id => l_res_id
1687: , p_res_type => l_res_type
1688: , p_start => p_start_date
1689: , p_end => p_end_date
1690: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
1691: , p_msg_name => 'CSF_RETRIEVE_SHIFTS_FAIL'
1692: , p_msg_type => g_error_message
1693: );
1694: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1869: l_start := l_old_trips(l_trip_idx).start_date_time;
1870: l_end := l_old_trips(l_trip_idx).end_date_time;
1871: END IF;
1872: IF l_msg_name <> 'CSF_TRIP_CREATE_FAIL_DUP' THEN
1873: l_reason := fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false);
1874: ELSE
1875: l_reason := NULL;
1876: END IF;
1877:
1955: );
1956:
1957: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1958: IF l_debug THEN
1959: debug( ' Error updating Trip. ' || fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false), l_api_name, fnd_log.level_error);
1960: END IF;
1961: END IF;
1962:
1963: l_trip_length := 0;
1995: p_res_id => l_res_id
1996: , p_res_type => l_res_type
1997: , p_start => p_start_date
1998: , p_end => p_end_date
1999: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
2000: , p_msg_name => 'CSF_TRIP_REPLACE_FAIL_RELINK'
2001: , p_msg_type => g_error_message
2002: );
2003: RAISE fnd_api.g_exc_error;
2054: );
2055: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2056: add_message(
2057: p_trip => l_old_trips(l_trip_idx)
2058: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
2059: , p_msg_name => 'CSF_TRIP_DELETE_FAIL_OTHER'
2060: , p_msg_type => g_error_message
2061: );
2062: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2082: EXCEPTION
2083: WHEN fnd_api.g_exc_error THEN
2084: ROLLBACK TO csf_create_trips;
2085: x_return_status := fnd_api.g_ret_sts_error;
2086: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2087: WHEN fnd_api.g_exc_unexpected_error THEN
2088: ROLLBACK TO csf_create_trips;
2089: x_return_status := fnd_api.g_ret_sts_unexp_error;
2090: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2086: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2087: WHEN fnd_api.g_exc_unexpected_error THEN
2088: ROLLBACK TO csf_create_trips;
2089: x_return_status := fnd_api.g_ret_sts_unexp_error;
2090: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2091: WHEN OTHERS THEN
2092: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2093: x_return_status := fnd_api.g_ret_sts_unexp_error;
2094: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2090: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2091: WHEN OTHERS THEN
2092: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2093: x_return_status := fnd_api.g_ret_sts_unexp_error;
2094: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2095: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2096: END IF;
2097: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2098: ROLLBACK TO csf_create_trips;
2091: WHEN OTHERS THEN
2092: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2093: x_return_status := fnd_api.g_ret_sts_unexp_error;
2094: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2095: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2096: END IF;
2097: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2098: ROLLBACK TO csf_create_trips;
2099: END create_trips;
2093: x_return_status := fnd_api.g_ret_sts_unexp_error;
2094: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2095: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2096: END IF;
2097: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2098: ROLLBACK TO csf_create_trips;
2099: END create_trips;
2100:
2101: /**
2215: p_res_id => p_resource_tbl(1).resource_id
2216: , p_res_type => p_resource_tbl(1).resource_type
2217: , p_start => l_start_time_tbl(i)
2218: , p_end => l_end_time_tbl(i)
2219: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
2220: , p_msg_name => 'CSF_TRIP_CREATE_FAIL_OTHER'
2221: , p_msg_type => g_error_message
2222: );
2223: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2234: END LOOP;
2235: EXCEPTION
2236: WHEN fnd_api.g_exc_error THEN
2237: x_return_status := fnd_api.g_ret_sts_error;
2238: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2239: WHEN fnd_api.g_exc_unexpected_error THEN
2240: x_return_status := fnd_api.g_ret_sts_unexp_error;
2241: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2242: WHEN OTHERS THEN
2237: x_return_status := fnd_api.g_ret_sts_error;
2238: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2239: WHEN fnd_api.g_exc_unexpected_error THEN
2240: x_return_status := fnd_api.g_ret_sts_unexp_error;
2241: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2242: WHEN OTHERS THEN
2243: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2244: x_return_status := fnd_api.g_ret_sts_unexp_error;
2245: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2241: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2242: WHEN OTHERS THEN
2243: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2244: x_return_status := fnd_api.g_ret_sts_unexp_error;
2245: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2246: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2247: END IF;
2248: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2249: END upgrade_to_trips;
2242: WHEN OTHERS THEN
2243: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2244: x_return_status := fnd_api.g_ret_sts_unexp_error;
2245: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2246: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2247: END IF;
2248: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2249: END upgrade_to_trips;
2250:
2244: x_return_status := fnd_api.g_ret_sts_unexp_error;
2245: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2246: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2247: END IF;
2248: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2249: END upgrade_to_trips;
2250:
2251: PROCEDURE update_trip_status(
2252: x_return_status OUT NOCOPY VARCHAR2
2319:
2320: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2321: add_message(
2322: p_trip => p_trips(i)
2323: , p_reason => fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
2324: , p_msg_name => 'CSF_TRIP_UPDATE_FAIL_OTHER'
2325: , p_msg_type => g_error_message
2326: );
2327: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2336: END LOOP;
2337: EXCEPTION
2338: WHEN fnd_api.g_exc_error THEN
2339: x_return_status := fnd_api.g_ret_sts_error;
2340: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2341: WHEN fnd_api.g_exc_unexpected_error THEN
2342: x_return_status := fnd_api.g_ret_sts_unexp_error;
2343: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2344: WHEN OTHERS THEN
2339: x_return_status := fnd_api.g_ret_sts_error;
2340: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2341: WHEN fnd_api.g_exc_unexpected_error THEN
2342: x_return_status := fnd_api.g_ret_sts_unexp_error;
2343: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2344: WHEN OTHERS THEN
2345: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2346: x_return_status := fnd_api.g_ret_sts_unexp_error;
2347: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2343: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2344: WHEN OTHERS THEN
2345: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2346: x_return_status := fnd_api.g_ret_sts_unexp_error;
2347: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2348: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2349: END IF;
2350: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2351: END update_trip_status;
2344: WHEN OTHERS THEN
2345: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2346: x_return_status := fnd_api.g_ret_sts_unexp_error;
2347: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2348: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2349: END IF;
2350: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2351: END update_trip_status;
2352:
2346: x_return_status := fnd_api.g_ret_sts_unexp_error;
2347: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2348: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2349: END IF;
2350: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2351: END update_trip_status;
2352:
2353: /******************************************************************************************
2354: * *
2401: END IF;
2402:
2403: -- Initialize Message Stack if required
2404: IF p_init_msg_list = fnd_api.g_true THEN
2405: fnd_msg_pub.initialize;
2406: END IF;
2407:
2408: -- Initialize Return Status
2409: x_return_status := fnd_api.g_ret_sts_success;
2428: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_DUP');
2429: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2430: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2431: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2432: fnd_msg_pub.ADD;
2433: RAISE fnd_api.g_exc_error;
2434: END IF;
2435:
2436: -- Check#2 - No Shift Tasks in the Interval where the Trip is going to be created.
2452: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_ST_EXIST');
2453: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2454: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2455: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2456: fnd_msg_pub.ADD;
2457: RAISE fnd_api.g_exc_error;
2458: END IF;
2459:
2460: -- All validations passed. Create the Trip.
2476: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_OTHER');
2477: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2478: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2479: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2480: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2481: fnd_msg_pub.ADD;
2482: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2483: RAISE fnd_api.g_exc_unexpected_error;
2484: END IF;
2477: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2478: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2479: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2480: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2481: fnd_msg_pub.ADD;
2482: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2483: RAISE fnd_api.g_exc_unexpected_error;
2484: END IF;
2485: RAISE fnd_api.g_exc_error;
2493:
2494: EXCEPTION
2495: WHEN fnd_api.g_exc_error THEN
2496: x_return_status := fnd_api.g_ret_sts_error;
2497: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2498: WHEN fnd_api.g_exc_unexpected_error THEN
2499: x_return_status := fnd_api.g_ret_sts_unexp_error;
2500: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2501: WHEN OTHERS THEN
2496: x_return_status := fnd_api.g_ret_sts_error;
2497: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2498: WHEN fnd_api.g_exc_unexpected_error THEN
2499: x_return_status := fnd_api.g_ret_sts_unexp_error;
2500: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2501: WHEN OTHERS THEN
2502: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2503: x_return_status := fnd_api.g_ret_sts_unexp_error;
2504: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2500: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2501: WHEN OTHERS THEN
2502: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2503: x_return_status := fnd_api.g_ret_sts_unexp_error;
2504: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2505: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2506: END IF;
2507: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2508: END create_trip;
2501: WHEN OTHERS THEN
2502: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2503: x_return_status := fnd_api.g_ret_sts_unexp_error;
2504: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2505: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2506: END IF;
2507: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2508: END create_trip;
2509:
2503: x_return_status := fnd_api.g_ret_sts_unexp_error;
2504: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2505: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2506: END IF;
2507: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2508: END create_trip;
2509:
2510: /**
2511: * Refer to the Package Spec for documentation of this procedure
2537: END IF;
2538:
2539: -- Initialize Message Stack if required
2540: IF fnd_api.to_boolean(p_init_msg_list) THEN
2541: fnd_msg_pub.initialize;
2542: END IF;
2543:
2544: -- Initialize Return Status
2545: x_return_status := fnd_api.g_ret_sts_success;
2548: -- Invalid Trip ID passed.
2549: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2550: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2551: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
2552: fnd_msg_pub.ADD;
2553: RAISE fnd_api.g_exc_error;
2554: END IF;
2555:
2556: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
2557: -- Invalid Object Version Number passed.
2558: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2559: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2560: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
2561: fnd_msg_pub.ADD;
2562: RAISE fnd_api.g_exc_error;
2563: END IF;
2564:
2565: IF p_available_hours IS NOT NULL AND p_upd_available_hours IS NOT NULL THEN
2566: -- Error out as both cant be passed.
2567: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2568: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2569: fnd_message.set_token('PARAM_NAME', 'P_UPD_AVAILABLE_HOURS');
2570: fnd_msg_pub.ADD;
2571: RAISE fnd_api.g_exc_error;
2572: END IF;
2573:
2574: l_trip := get_trip(p_trip_id);
2574: l_trip := get_trip(p_trip_id);
2575: IF l_trip.trip_id IS NULL THEN
2576: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
2577: fnd_message.set_token('TRIP_ID', p_trip_id);
2578: fnd_msg_pub.ADD;
2579: RAISE fnd_api.g_exc_error;
2580: END IF;
2581:
2582: change_trip(
2596: fnd_message.set_name('CSF', 'CSF_TRIP_UPDATE_FAIL_OTHER');
2597: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2598: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2599: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2600: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2601: fnd_msg_pub.ADD;
2602: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2603: RAISE fnd_api.g_exc_unexpected_error;
2604: END IF;
2597: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2598: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2599: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2600: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2601: fnd_msg_pub.ADD;
2602: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2603: RAISE fnd_api.g_exc_unexpected_error;
2604: END IF;
2605: RAISE fnd_api.g_exc_error;
2611:
2612: EXCEPTION
2613: WHEN fnd_api.g_exc_error THEN
2614: x_return_status := fnd_api.g_ret_sts_error;
2615: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2616: WHEN fnd_api.g_exc_unexpected_error THEN
2617: x_return_status := fnd_api.g_ret_sts_unexp_error;
2618: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2619: WHEN OTHERS THEN
2614: x_return_status := fnd_api.g_ret_sts_error;
2615: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2616: WHEN fnd_api.g_exc_unexpected_error THEN
2617: x_return_status := fnd_api.g_ret_sts_unexp_error;
2618: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2619: WHEN OTHERS THEN
2620: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2621: x_return_status := fnd_api.g_ret_sts_unexp_error;
2622: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2618: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2619: WHEN OTHERS THEN
2620: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2621: x_return_status := fnd_api.g_ret_sts_unexp_error;
2622: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2623: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2624: END IF;
2625: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2626: END;
2619: WHEN OTHERS THEN
2620: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2621: x_return_status := fnd_api.g_ret_sts_unexp_error;
2622: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2623: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2624: END IF;
2625: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2626: END;
2627:
2621: x_return_status := fnd_api.g_ret_sts_unexp_error;
2622: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2623: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2624: END IF;
2625: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2626: END;
2627:
2628: /**
2629: * Refer to the Package Spec for documentation of this procedure
2651: END IF;
2652:
2653: -- Initialize Message Stack if required
2654: IF fnd_api.to_boolean(p_init_msg_list) THEN
2655: fnd_msg_pub.initialize;
2656: END IF;
2657:
2658: -- Initialize Return Status
2659: x_return_status := fnd_api.g_ret_sts_success;
2666: -- Invalid Trip ID passed.
2667: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2668: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2669: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
2670: fnd_msg_pub.ADD;
2671: RAISE fnd_api.g_exc_error;
2672: END IF;
2673:
2674: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
2675: -- Invalid Object Version Number passed.
2676: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2677: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2678: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
2679: fnd_msg_pub.ADD;
2680: RAISE fnd_api.g_exc_error;
2681: END IF;
2682:
2683: l_trip := get_trip(p_trip_id);
2684: -- No Trips found for the given Trip ID
2685: IF l_trip.trip_id IS NULL THEN
2686: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
2687: fnd_message.set_token('TRIP_ID', p_trip_id);
2688: fnd_msg_pub.ADD;
2689: RAISE fnd_api.g_exc_error;
2690: END IF;
2691:
2692: remove_trip(
2699:
2700: IF x_return_status <> fnd_api.g_ret_sts_success THEN
2701: IF l_debug THEN
2702: debug( ' Unable to delete the Trip: Error = '
2703: || fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false)
2704: , l_api_name, fnd_log.level_error);
2705: END IF;
2706: fnd_message.set_name('CSF', 'CSF_TRIP_DELETE_FAIL_OTHER');
2707: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2706: fnd_message.set_name('CSF', 'CSF_TRIP_DELETE_FAIL_OTHER');
2707: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2708: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2709: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2710: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2711: fnd_msg_pub.ADD;
2712: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2713: RAISE fnd_api.g_exc_unexpected_error;
2714: END IF;
2707: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2708: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2709: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2710: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2711: fnd_msg_pub.ADD;
2712: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2713: RAISE fnd_api.g_exc_unexpected_error;
2714: END IF;
2715: RAISE fnd_api.g_exc_error;
2721: EXCEPTION
2722: WHEN fnd_api.g_exc_error THEN
2723: ROLLBACK TO delete_trip;
2724: x_return_status := fnd_api.g_ret_sts_error;
2725: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2726: WHEN fnd_api.g_exc_unexpected_error THEN
2727: ROLLBACK TO delete_trip;
2728: x_return_status := fnd_api.g_ret_sts_unexp_error;
2729: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2725: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2726: WHEN fnd_api.g_exc_unexpected_error THEN
2727: ROLLBACK TO delete_trip;
2728: x_return_status := fnd_api.g_ret_sts_unexp_error;
2729: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2730: WHEN OTHERS THEN
2731: ROLLBACK TO delete_trip;
2732: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2733: x_return_status := fnd_api.g_ret_sts_unexp_error;
2730: WHEN OTHERS THEN
2731: ROLLBACK TO delete_trip;
2732: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2733: x_return_status := fnd_api.g_ret_sts_unexp_error;
2734: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2735: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2736: END IF;
2737: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2738: END delete_trip;
2731: ROLLBACK TO delete_trip;
2732: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2733: x_return_status := fnd_api.g_ret_sts_unexp_error;
2734: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2735: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2736: END IF;
2737: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2738: END delete_trip;
2739:
2733: x_return_status := fnd_api.g_ret_sts_unexp_error;
2734: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2735: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2736: END IF;
2737: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2738: END delete_trip;
2739:
2740: /**
2741: * Refer to the Package Spec for documentation of this procedure
2762: END IF;
2763:
2764: -- Initialize Message Stack if required
2765: IF fnd_api.to_boolean(p_init_msg_list) THEN
2766: fnd_msg_pub.initialize;
2767: END IF;
2768:
2769: -- Initialize Return Status
2770: x_return_status := fnd_api.g_ret_sts_success;
2777: -- Invalid Trip ID passed.
2778: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2779: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2780: fnd_message.set_token('PARAM_NAME', 'P_TRIP_ID');
2781: fnd_msg_pub.ADD;
2782: RAISE fnd_api.g_exc_error;
2783: END IF;
2784:
2785: IF p_object_version_number IS NULL OR p_object_version_number = fnd_api.g_miss_num THEN
2786: -- Invalid Object Version Number passed.
2787: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
2788: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
2789: fnd_message.set_token('PARAM_NAME', 'P_OBJECT_VERSION_NUMBER');
2790: fnd_msg_pub.ADD;
2791: RAISE fnd_api.g_exc_error;
2792: END IF;
2793:
2794: l_trip := get_trip(p_trip_id);
2794: l_trip := get_trip(p_trip_id);
2795: IF l_trip.trip_id IS NULL THEN
2796: fnd_message.set_name('CSF', 'CSF_INVALID_TRIP_ID');
2797: fnd_message.set_token('TRIP_ID', p_trip_id);
2798: fnd_msg_pub.ADD;
2799: RAISE fnd_api.g_exc_error;
2800: END IF;
2801:
2802: correct_trip(
2814: fnd_message.set_name('CSF', 'CSF_TRIP_FIX_FAIL_OTHER');
2815: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2816: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2817: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2818: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2819: fnd_msg_pub.ADD;
2820: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2821: RAISE fnd_api.g_exc_unexpected_error;
2822: END IF;
2815: fnd_message.set_token('RESOURCE', get_resource_info(l_trip.resource_id, l_trip.resource_type));
2816: fnd_message.set_token('START_TIME', format_date(l_trip.start_date_time));
2817: fnd_message.set_token('END_TIME', format_date(l_trip.end_date_time));
2818: fnd_message.set_token('REASON', fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false));
2819: fnd_msg_pub.ADD;
2820: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
2821: RAISE fnd_api.g_exc_unexpected_error;
2822: END IF;
2823: RAISE fnd_api.g_exc_error;
2828: END IF;
2829: EXCEPTION
2830: WHEN fnd_api.g_exc_error THEN
2831: x_return_status := fnd_api.g_ret_sts_error;
2832: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2833: WHEN fnd_api.g_exc_unexpected_error THEN
2834: x_return_status := fnd_api.g_ret_sts_unexp_error;
2835: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2836: WHEN OTHERS THEN
2831: x_return_status := fnd_api.g_ret_sts_error;
2832: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2833: WHEN fnd_api.g_exc_unexpected_error THEN
2834: x_return_status := fnd_api.g_ret_sts_unexp_error;
2835: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2836: WHEN OTHERS THEN
2837: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2838: x_return_status := fnd_api.g_ret_sts_unexp_error;
2839: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2835: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2836: WHEN OTHERS THEN
2837: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2838: x_return_status := fnd_api.g_ret_sts_unexp_error;
2839: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2840: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2841: END IF;
2842: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2843: END fix_trip;
2836: WHEN OTHERS THEN
2837: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2838: x_return_status := fnd_api.g_ret_sts_unexp_error;
2839: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2840: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2841: END IF;
2842: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2843: END fix_trip;
2844:
2838: x_return_status := fnd_api.g_ret_sts_unexp_error;
2839: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2840: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2841: END IF;
2842: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2843: END fix_trip;
2844:
2845: /******************************************************************************************
2846: * *
2876: END IF;
2877:
2878: -- Initialize Message Stack if required
2879: IF fnd_api.to_boolean(p_init_msg_list) THEN
2880: fnd_msg_pub.initialize;
2881: END IF;
2882:
2883: -- Initialize Return Status
2884: x_return_status := fnd_api.g_ret_sts_success;
2898: END IF;
2899: fnd_message.set_token('RESOURCE', get_resource_info(p_resource_id, p_resource_type));
2900: fnd_message.set_token('START_TIME', format_date(p_start_date_time));
2901: fnd_message.set_token('END_TIME', format_date(p_end_date_time));
2902: fnd_msg_pub.add;
2903: RAISE fnd_api.g_exc_error;
2904: END IF;
2905:
2906: x_trip := l_trips(l_trips.FIRST);
2906: x_trip := l_trips(l_trips.FIRST);
2907: EXCEPTION
2908: WHEN fnd_api.g_exc_error THEN
2909: x_return_status := fnd_api.g_ret_sts_error;
2910: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2911: WHEN fnd_api.g_exc_unexpected_error THEN
2912: x_return_status := fnd_api.g_ret_sts_unexp_error;
2913: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2914: WHEN OTHERS THEN
2909: x_return_status := fnd_api.g_ret_sts_error;
2910: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2911: WHEN fnd_api.g_exc_unexpected_error THEN
2912: x_return_status := fnd_api.g_ret_sts_unexp_error;
2913: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2914: WHEN OTHERS THEN
2915: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2916: x_return_status := fnd_api.g_ret_sts_unexp_error;
2917: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2913: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2914: WHEN OTHERS THEN
2915: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2916: x_return_status := fnd_api.g_ret_sts_unexp_error;
2917: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2918: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2919: END IF;
2920: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2921: END find_trip;
2914: WHEN OTHERS THEN
2915: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2916: x_return_status := fnd_api.g_ret_sts_unexp_error;
2917: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2918: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2919: END IF;
2920: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2921: END find_trip;
2922:
2916: x_return_status := fnd_api.g_ret_sts_unexp_error;
2917: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2918: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2919: END IF;
2920: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2921: END find_trip;
2922:
2923: /**
2924: * Refer to the Package Spec for documentation of this procedure
2947: END IF;
2948:
2949: -- Initialize Message Stack if required
2950: IF fnd_api.to_boolean(p_init_msg_list) THEN
2951: fnd_msg_pub.initialize;
2952: END IF;
2953:
2954: -- Initialize Return Status
2955: x_return_status := fnd_api.g_ret_sts_success;
2974:
2975: EXCEPTION
2976: WHEN fnd_api.g_exc_error THEN
2977: x_return_status := fnd_api.g_ret_sts_error;
2978: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2979: WHEN fnd_api.g_exc_unexpected_error THEN
2980: x_return_status := fnd_api.g_ret_sts_unexp_error;
2981: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2982: WHEN OTHERS THEN
2977: x_return_status := fnd_api.g_ret_sts_error;
2978: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2979: WHEN fnd_api.g_exc_unexpected_error THEN
2980: x_return_status := fnd_api.g_ret_sts_unexp_error;
2981: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2982: WHEN OTHERS THEN
2983: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2984: x_return_status := fnd_api.g_ret_sts_unexp_error;
2985: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2981: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2982: WHEN OTHERS THEN
2983: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2984: x_return_status := fnd_api.g_ret_sts_unexp_error;
2985: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2986: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2987: END IF;
2988: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2989: END find_trip;
2982: WHEN OTHERS THEN
2983: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
2984: x_return_status := fnd_api.g_ret_sts_unexp_error;
2985: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2986: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2987: END IF;
2988: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2989: END find_trip;
2990:
2984: x_return_status := fnd_api.g_ret_sts_unexp_error;
2985: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
2986: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2987: END IF;
2988: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
2989: END find_trip;
2990:
2991: /**
2992: * Refer to the Package Spec for documentation of this procedure
3013: END IF;
3014:
3015: -- Initialize Message Stack if required
3016: IF fnd_api.to_boolean(p_init_msg_list) THEN
3017: fnd_msg_pub.initialize;
3018: END IF;
3019:
3020: -- Initialize Return Status
3021: x_return_status := fnd_api.g_ret_sts_success;
3024:
3025: EXCEPTION
3026: WHEN fnd_api.g_exc_error THEN
3027: x_return_status := fnd_api.g_ret_sts_error;
3028: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3029: WHEN fnd_api.g_exc_unexpected_error THEN
3030: x_return_status := fnd_api.g_ret_sts_unexp_error;
3031: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3032: WHEN OTHERS THEN
3027: x_return_status := fnd_api.g_ret_sts_error;
3028: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3029: WHEN fnd_api.g_exc_unexpected_error THEN
3030: x_return_status := fnd_api.g_ret_sts_unexp_error;
3031: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3032: WHEN OTHERS THEN
3033: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
3034: x_return_status := fnd_api.g_ret_sts_unexp_error;
3035: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3031: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3032: WHEN OTHERS THEN
3033: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
3034: x_return_status := fnd_api.g_ret_sts_unexp_error;
3035: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3036: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3037: END IF;
3038: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3039: END find_trips;
3032: WHEN OTHERS THEN
3033: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
3034: x_return_status := fnd_api.g_ret_sts_unexp_error;
3035: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3036: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3037: END IF;
3038: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3039: END find_trips;
3040:
3034: x_return_status := fnd_api.g_ret_sts_unexp_error;
3035: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3036: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3037: END IF;
3038: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3039: END find_trips;
3040:
3041: /**
3042: * Refer to the Package Spec for documentation of this procedure
3069: END IF;
3070:
3071: -- Initialize Message Stack if required
3072: IF fnd_api.to_boolean(p_init_msg_list) THEN
3073: fnd_msg_pub.initialize;
3074: END IF;
3075:
3076: -- Initialize Return Status
3077: x_return_status := fnd_api.g_ret_sts_success;
3118: IF l_param_name IS NOT NULL THEN
3119: fnd_message.set_name('CSF', 'CSF_API_INVALID_PARAM');
3120: fnd_message.set_token('API_NAME', g_pkg_name || '.' || l_api_name);
3121: fnd_message.set_token('PARAM_NAME', l_param_name);
3122: fnd_msg_pub.ADD;
3123: RAISE fnd_api.g_exc_error;
3124: END IF;
3125:
3126: -- Getting the Trips only for actions like DELETE, FIX, BLOCK, UNBLOCK.
3145: END IF;
3146: fnd_message.set_token('START_TIME', format_date(p_start_date));
3147: fnd_message.set_token('END_TIME', format_date(p_end_date));
3148: END IF;
3149: fnd_msg_pub.add;
3150: RAISE fnd_api.g_exc_error;
3151: END IF;
3152: END IF;
3153:
3212: IF fnd_api.to_boolean(p_commit) THEN
3213: COMMIT;
3214: END IF;
3215:
3216: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3217: EXCEPTION
3218: WHEN fnd_api.g_exc_error THEN
3219: x_return_status := fnd_api.g_ret_sts_error;
3220: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3216: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3217: EXCEPTION
3218: WHEN fnd_api.g_exc_error THEN
3219: x_return_status := fnd_api.g_ret_sts_error;
3220: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3221: WHEN fnd_api.g_exc_unexpected_error THEN
3222: x_return_status := fnd_api.g_ret_sts_unexp_error;
3223: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3224: WHEN OTHERS THEN
3219: x_return_status := fnd_api.g_ret_sts_error;
3220: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3221: WHEN fnd_api.g_exc_unexpected_error THEN
3222: x_return_status := fnd_api.g_ret_sts_unexp_error;
3223: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3224: WHEN OTHERS THEN
3225: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
3226: x_return_status := fnd_api.g_ret_sts_unexp_error;
3227: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3223: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3224: WHEN OTHERS THEN
3225: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
3226: x_return_status := fnd_api.g_ret_sts_unexp_error;
3227: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3228: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3229: END IF;
3230: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3231: END process_action;
3224: WHEN OTHERS THEN
3225: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
3226: x_return_status := fnd_api.g_ret_sts_unexp_error;
3227: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3228: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3229: END IF;
3230: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3231: END process_action;
3232:
3226: x_return_status := fnd_api.g_ret_sts_unexp_error;
3227: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3228: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3229: END IF;
3230: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3231: END process_action;
3232:
3233: /******************************************************************************************
3234: * *
3367: );
3368:
3369: -- Print all the messages encountered
3370: FOR i IN 1..l_msg_count LOOP
3371: debug(' ' || fnd_msg_pub.get(i, fnd_api.g_false), l_api_name, g_level_cp_output);
3372: END LOOP;
3373: debug(' ', l_api_name, g_level_cp_output);
3374:
3375: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3412: debug(fnd_message.get, l_api_name, g_level_cp_output);
3413: EXCEPTION
3414: WHEN OTHERS THEN
3415: IF SQLERRM IS NOT NULL THEN
3416: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3417: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3418: debug(fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false), l_api_name, g_level_cp_output);
3419: END IF;
3420: END IF;
3413: EXCEPTION
3414: WHEN OTHERS THEN
3415: IF SQLERRM IS NOT NULL THEN
3416: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3417: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3418: debug(fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false), l_api_name, g_level_cp_output);
3419: END IF;
3420: END IF;
3421:
3414: WHEN OTHERS THEN
3415: IF SQLERRM IS NOT NULL THEN
3416: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3417: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3418: debug(fnd_msg_pub.get(fnd_msg_pub.g_last, fnd_api.g_false), l_api_name, g_level_cp_output);
3419: END IF;
3420: END IF;
3421:
3422: retcode := 2;
3454: END IF;
3455:
3456: -- Initialize Message Stack if required
3457: IF fnd_api.to_boolean(p_init_msg_list) THEN
3458: fnd_msg_pub.initialize;
3459: END IF;
3460:
3461: -- Initialize Return Status
3462: x_return_status := fnd_api.g_ret_sts_success;
3511:
3512: -- needed to submit the request properly
3513: COMMIT;
3514:
3515: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3516: EXCEPTION
3517: WHEN fnd_api.g_exc_error THEN
3518: ROLLBACK;
3519: x_return_status := fnd_api.g_ret_sts_error;
3516: EXCEPTION
3517: WHEN fnd_api.g_exc_error THEN
3518: ROLLBACK;
3519: x_return_status := fnd_api.g_ret_sts_error;
3520: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3521: WHEN fnd_api.g_exc_unexpected_error THEN
3522: ROLLBACK;
3523: x_return_status := fnd_api.g_ret_sts_unexp_error;
3524: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3520: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3521: WHEN fnd_api.g_exc_unexpected_error THEN
3522: ROLLBACK;
3523: x_return_status := fnd_api.g_ret_sts_unexp_error;
3524: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3525: WHEN OTHERS THEN
3526: ROLLBACK;
3527: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
3528: x_return_status := fnd_api.g_ret_sts_unexp_error;
3525: WHEN OTHERS THEN
3526: ROLLBACK;
3527: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
3528: x_return_status := fnd_api.g_ret_sts_unexp_error;
3529: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3530: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3531: END IF;
3532: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3533: END optimize_across_trips;
3526: ROLLBACK;
3527: debug('Fatal Exception occurred: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
3528: x_return_status := fnd_api.g_ret_sts_unexp_error;
3529: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3530: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3531: END IF;
3532: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3533: END optimize_across_trips;
3534:
3528: x_return_status := fnd_api.g_ret_sts_unexp_error;
3529: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
3530: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3531: END IF;
3532: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
3533: END optimize_across_trips;
3534:
3535: BEGIN
3536: -- Package Initialization