108: l_effective_end_date date;
109:
110: --
111: begin
112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Issue a savepoint
115: --
116: savepoint create_assignment_attribute;
426: p_effective_start_date := l_effective_start_date;
427: p_effective_end_date := l_effective_end_date;
428:
429: --
430: hr_utility.set_location(' Leaving:'||l_proc, 70);
431: exception
432: when hr_api.validate_enabled then
433: --
434: -- As the Validate_Enabled exception has been raised
444: p_object_version_number := null;
445: p_effective_start_date := null;
446: p_effective_end_date := null;
447:
448: hr_utility.set_location(' Leaving:'||l_proc, 80);
449: when others then
450: --
451: -- A validation or unexpected error has occured
452: --
454: p_assignment_attribute_id := null;
455: p_object_version_number := null;
456: p_effective_start_date := null;
457: p_effective_end_date := null;
458: hr_utility.set_location(' Leaving:'||l_proc, 90);
459: raise;
460: end create_assignment_attribute;
461: --
462: --
560: l_effective_date date;
561: l_effective_start_date date;
562: l_effective_end_date date;
563: begin
564: hr_utility.set_location('Entering:'|| l_proc, 10);
565: --
566: -- Issue a savepoint
567: --
568: savepoint update_assignment_attribute;
883: p_effective_start_date := l_effective_start_date;
884: p_effective_end_date := l_effective_end_date;
885:
886: --
887: hr_utility.set_location(' Leaving:'||l_proc, 70);
888: exception
889: when hr_api.validate_enabled then
890: --
891: -- As the Validate_Enabled exception has been raised
900: p_object_version_number := null;
901: p_effective_start_date := null;
902: p_effective_end_date := null;
903:
904: hr_utility.set_location(' Leaving:'||l_proc, 80);
905: when others then
906: --
907: -- A validation or unexpected error has occured
908: --
909: rollback to update_assignment_attribute;
910: p_object_version_number := l_object_version_number;
911: p_effective_start_date := null;
912: p_effective_end_date := null;
913: hr_utility.set_location(' Leaving:'||l_proc, 90);
914: raise;
915: end update_assignment_attribute;
916: --
917: --
939: l_effective_end_date date;
940: l_object_version_number number;
941:
942: begin
943: hr_utility.set_location('Entering:'|| l_proc, 10);
944: --
945: -- Issue a savepoint
946: --
947: savepoint delete_assignment_attribute;
1024: p_object_version_number := l_object_version_number;
1025: p_effective_start_date := l_effective_start_date;
1026: p_effective_end_date := l_effective_end_date;
1027: --
1028: hr_utility.set_location(' Leaving:'||l_proc, 70);
1029: exception
1030: when hr_api.validate_enabled then
1031: --
1032: -- As the Validate_Enabled exception has been raised
1040: p_object_version_number := null;
1041: p_effective_start_date := null;
1042: p_effective_end_date := null;
1043: --
1044: hr_utility.set_location(' Leaving:'||l_proc, 80);
1045: when others then
1046: --
1047: -- A validation or unexpected error has occured
1048: --
1049: rollback to delete_assignment_attribute;
1050: p_object_version_number := l_object_version_number;
1051: p_effective_start_date := null;
1052: p_effective_end_date := null;
1053: hr_utility.set_location(' Leaving:'||l_proc, 90);
1054: raise;
1055: end delete_assignment_attribute;
1056:
1057: --