[Home] [Help]
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;
240: l_failed := 0;
262: IF g_messages(i).error_reason IS NOT NULL THEN
263: fnd_message.set_token('REASON', g_messages(i).error_reason);
264: END IF;
265:
266: fnd_msg_pub.ADD;
267:
268: IF g_messages(i).message_type = g_error_message THEN
269: l_failed := l_failed + 1;
270: ELSE
315: fnd_message.set_token('ACTION', l_action_name);
316: fnd_message.set_token('RESOURCE', l_res_name);
317: fnd_message.set_token('START_DATE', p_start_date);
318: fnd_message.set_token('END_DATE', p_end_date);
319: fnd_msg_pub.ADD;
320: END process_messages;
321:
322: PROCEDURE init_package IS
323: BEGIN
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));
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));
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
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;
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;
576: END IF;
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;
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;
628: END IF;
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;
644: else
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;
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);
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);
654: END create_shift_tasks;
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);
654: END create_shift_tasks;
655:
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);
654: END create_shift_tasks;
655:
656: FUNCTION get_new_task_status(p_action VARCHAR2, p_current_status NUMBER)
657: RETURN NUMBER IS
751: IF l_debug THEN
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;
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;
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;
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);
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
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);
914: ROLLBACK TO csf_new_trip;
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);
914: ROLLBACK TO csf_new_trip;
915: END new_trip;
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);
914: ROLLBACK TO csf_new_trip;
915: END new_trip;
916:
917: PROCEDURE change_trip(
1009: fnd_message.set_name('CSF', 'CSF_TRIP_WRONG_AVAILABILITY');
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
1027: fnd_message.set_name('CSF', 'CSF_TRIP_WRONG_AVL_BEFOREAFTER');
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(
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
1105: debug(' Unable to update the Assignment: Error = ' || x_msg_data, l_api_name, fnd_log.level_error);
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');
1106: END IF;
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;
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;
1126: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
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;
1130: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
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);
1134: ROLLBACK TO csf_change_trip;
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);
1134: ROLLBACK TO csf_change_trip;
1135: END change_trip;
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);
1134: ROLLBACK TO csf_change_trip;
1135: END change_trip;
1136:
1137: PROCEDURE remove_trip(
1177: debug(' The Trip is unavailable and so cant be deleted', l_api_name, fnd_log.level_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
1190: debug(' Trip has active Tasks and so cant be deleted', l_api_name, fnd_log.level_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:
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;
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;
1224: RAISE fnd_api.g_exc_error;
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
1260: debug('Unable to Delete the Object Capacity: Code = ' || SQLCODE || ' Error = ' || SQLERRM, l_api_name, fnd_log.level_unexpected);
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);
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
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);
1275: ROLLBACK TO csf_remove_trip;
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);
1275: ROLLBACK TO csf_remove_trip;
1276: END remove_trip;
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);
1275: ROLLBACK TO csf_remove_trip;
1276: END remove_trip;
1277:
1278: PROCEDURE correct_trip(
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;
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;
1422: RAISE fnd_api.g_exc_error;
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;
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;
1488: RAISE fnd_api.g_exc_error;
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;
1524: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
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;
1528: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
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);
1532: ROLLBACK TO csf_correct_trip;
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);
1532: ROLLBACK TO csf_correct_trip;
1533: END correct_trip;
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);
1532: ROLLBACK TO csf_correct_trip;
1533: END correct_trip;
1534:
1535:
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
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);
1616: WHEN OTHERS 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;
1619: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
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);
1623: END delete_trips;
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);
1623: END delete_trips;
1624:
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);
1623: END delete_trips;
1624:
1625: PROCEDURE fix_trips(
1626: x_return_status OUT NOCOPY VARCHAR2
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
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);
1670: WHEN OTHERS 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;
1673: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
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);
1677: END fix_trips;
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);
1677: END fix_trips;
1678:
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);
1677: END fix_trips;
1678:
1679: PROCEDURE create_trips(
1680: x_return_status OUT NOCOPY VARCHAR2
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
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:
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;
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;
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:
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
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;
2335: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
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;
2339: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
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);
2343: ROLLBACK TO csf_create_trips;
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);
2343: ROLLBACK TO csf_create_trips;
2344: END create_trips;
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);
2343: ROLLBACK TO csf_create_trips;
2344: END create_trips;
2345:
2346: /**
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
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);
2487: WHEN OTHERS 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;
2490: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
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);
2494: END upgrade_to_trips;
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);
2494: END upgrade_to_trips;
2495:
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);
2494: END upgrade_to_trips;
2495:
2496: PROCEDURE update_trip_status(
2497: x_return_status OUT NOCOPY VARCHAR2
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
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);
2589: WHEN OTHERS 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;
2592: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
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);
2596: END update_trip_status;
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);
2596: END update_trip_status;
2597:
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);
2596: END update_trip_status;
2597:
2598: /******************************************************************************************
2599: * *
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
2654: x_return_status := fnd_api.g_ret_sts_success;
2673: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_DUP');
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.
2697: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_ST_EXIST');
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.
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;
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;
2730: RAISE fnd_api.g_exc_error;
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);
2746: WHEN OTHERS 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;
2749: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
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);
2753: END create_trip;
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);
2753: END create_trip;
2754:
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);
2753: END create_trip;
2754:
2755: /**
2756: * Refer to the Package Spec for documentation of this procedure
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
2790: x_return_status := fnd_api.g_ret_sts_success;
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');
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');
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.
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);
2819: l_trip := get_trip(p_trip_id);
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(
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;
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;
2850: RAISE fnd_api.g_exc_error;
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);
2864: WHEN OTHERS 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;
2867: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
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);
2871: END;
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);
2871: END;
2872:
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);
2871: END;
2872:
2873: /**
2874: * Refer to the Package Spec for documentation of this procedure
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
2904: x_return_status := fnd_api.g_ret_sts_success;
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');
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');
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
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(
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));
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;
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;
2960: RAISE fnd_api.g_exc_error;
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;
2974: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
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);
2978: x_return_status := fnd_api.g_ret_sts_unexp_error;
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);
2983: END delete_trip;
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);
2983: END delete_trip;
2984:
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);
2983: END delete_trip;
2984:
2985: /**
2986: * Refer to the Package Spec for documentation of this procedure
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
3015: x_return_status := fnd_api.g_ret_sts_success;
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');
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');
3035: fnd_msg_pub.ADD;
3036: RAISE fnd_api.g_exc_error;
3037: END IF;
3038:
3039: l_trip := get_trip(p_trip_id);
3039: l_trip := get_trip(p_trip_id);
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(
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;
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;
3068: RAISE fnd_api.g_exc_error;
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);
3081: WHEN OTHERS 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;
3084: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
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);
3088: END fix_trip;
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);
3088: END fix_trip;
3089:
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);
3088: END fix_trip;
3089:
3090: /******************************************************************************************
3091: * *
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
3129: x_return_status := fnd_api.g_ret_sts_success;
3143: END IF;
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);
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);
3159: WHEN OTHERS 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;
3162: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
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);
3166: END find_trip;
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);
3166: END find_trip;
3167:
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);
3166: END find_trip;
3167:
3168: /**
3169: * Refer to the Package Spec for documentation of this procedure
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
3200: x_return_status := fnd_api.g_ret_sts_success;
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);
3227: WHEN OTHERS 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;
3230: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
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);
3234: END find_trip;
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);
3234: END find_trip;
3235:
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);
3234: END find_trip;
3235:
3236: /**
3237: * Refer to the Package Spec for documentation of this procedure
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
3266: x_return_status := fnd_api.g_ret_sts_success;
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);
3277: WHEN OTHERS 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;
3280: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
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);
3284: END find_trips;
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);
3284: END find_trips;
3285:
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);
3284: END find_trips;
3285:
3286: /**
3287: * Refer to the Package Spec for documentation of this procedure
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
3326: x_return_status := fnd_api.g_ret_sts_success;
3367: IF l_param_name IS NOT NULL THEN
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.
3393: ));
3394: END IF;
3395: fnd_message.set_token('START_TIME', format_date(p_start_date));
3396: fnd_message.set_token('END_TIME', format_date(p_end_date));
3397: fnd_msg_pub.add;
3398: IF p_action = g_action_delete_trip
3399: THEN
3400: check_dangling_tasks(p_resource_tbl => p_resource_tbl
3401: , p_start => p_start_date
3404: , x_msg_data => x_msg_data
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;
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);
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);
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);
3505: WHEN OTHERS 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;
3508: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
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);
3512: END process_action;
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);
3512: END process_action;
3513:
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);
3512: END process_action;
3513:
3514: /******************************************************************************************
3515: * *
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
3760: EXCEPTION
3761: WHEN OTHERS THEN
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;
3761: WHEN OTHERS THEN
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:
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;
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
3810: x_return_status := fnd_api.g_ret_sts_success;
3859:
3860: -- needed to submit the request properly
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;
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;
3872: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
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);
3876: x_return_status := fnd_api.g_ret_sts_unexp_error;
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);
3881: END optimize_across_trips;
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);
3881: END optimize_across_trips;
3882:
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);
3881: END optimize_across_trips;
3882:
3883: PROCEDURE create_trip1(
3884: p_api_version IN NUMBER
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
3947: x_return_status := fnd_api.g_ret_sts_success;
3969: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_ST_EXIST');
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.
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;
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;
4019: RAISE fnd_api.g_exc_error;
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);
4035: WHEN OTHERS 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;
4038: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
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);
4042: END create_trip1;
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);
4042: END create_trip1;
4043:
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);
4042: END create_trip1;
4043:
4044:
4045: PROCEDURE new_trip1(
4123: IF l_debug THEN
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;
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;
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;
4268: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
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;
4272: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
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);
4276: ROLLBACK TO csf_new_trip;
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);
4276: ROLLBACK TO csf_new_trip;
4277: END new_trip1;
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);
4276: ROLLBACK TO csf_new_trip;
4277: END new_trip1;
4278:
4279:
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;
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;
4351: END IF;
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;
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;
4394: 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);
4408: WHEN OTHERS 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
4411: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
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);
4414: END create_shift_tasks1;
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);
4414: END create_shift_tasks1;
4415:
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);
4414: END create_shift_tasks1;
4415:
4416: PROCEDURE update_dc_trip(
4417: p_api_version IN NUMBER
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
4468: x_return_status := fnd_api.g_ret_sts_success;
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');
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');
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.
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:
4499: l_trip := get_trip(p_trip_id);
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:
4520: fnd_message.set_name('CSF', 'CSF_TRIP_CREATE_FAIL_ST_EXIST');
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(
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;
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;
4554: RAISE fnd_api.g_exc_error;
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);
4568: WHEN OTHERS 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;
4571: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
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);
4575: END;
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);
4575: END;
4576:
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);
4575: END;
4576:
4577: PROCEDURE update_shift_tasks(
4578: p_api_version IN NUMBER
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);
4698: WHEN OTHERS 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
4701: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
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);
4704: END update_shift_tasks;
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);
4704: END update_shift_tasks;
4705:
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);
4704: END update_shift_tasks;
4705:
4706: PROCEDURE create_dc_trip( p_api_version IN NUMBER
4707: , p_init_msg_list IN VARCHAR2
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
4732: x_return_status := fnd_api.g_ret_sts_success;
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;
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;
4768: RAISE fnd_api.g_exc_error;
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;
4782: fnd_msg_pub.count_and_get(p_data => x_msg_data, p_count => x_msg_count);
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;
4786: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
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);
4790: END create_dc_trip;
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);
4790: END create_dc_trip;
4791:
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);
4790: END create_dc_trip;
4791:
4792:
4793: FUNCTION check_dst(p_resource_id IN number ,p_start_server IN date,p_end_server IN date)
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
4832: x_return_status := FND_API.G_RET_STS_SUCCESS;
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
4869: );
4870: RETURN 'FALSE';
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
4904: x_return_status := FND_API.G_RET_STS_SUCCESS;
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: );
4925:
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
4932: );
4933:
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;
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: