[Home] [Help]
64: l_object_version_number ben_per_cm_trgr_f.object_version_number%TYPE;
65: --
66: begin
67: --
68: hr_utility.set_location('Entering:'|| l_proc, 10);
69: --
70: -- Issue a savepoint if operating in validation only mode
71: --
72: savepoint create_PER_CM_TRGR;
70: -- Issue a savepoint if operating in validation only mode
71: --
72: savepoint create_PER_CM_TRGR;
73: --
74: hr_utility.set_location(l_proc, 20);
75: --
76: -- Process Logic
77: --
78: begin
237: -- End of API User Hook for the after hook of create_PER_CM_TRGR
238: --
239: end;
240: --
241: hr_utility.set_location(l_proc, 60);
242: --
243: -- When in validation only mode raise the Validate_Enabled exception
244: --
245: if p_validate then
252: p_effective_start_date := l_effective_start_date;
253: p_effective_end_date := l_effective_end_date;
254: p_object_version_number := l_object_version_number;
255: --
256: hr_utility.set_location(' Leaving:'||l_proc, 70);
257: --
258: exception
259: --
260: when hr_api.validate_enabled then
271: p_per_cm_trgr_id := null;
272: p_effective_start_date := null;
273: p_effective_end_date := null;
274: p_object_version_number := null;
275: hr_utility.set_location(' Leaving:'||l_proc, 80);
276: --
277: when others then
278: --
279: -- A validation or unexpected error has occured
282: p_per_cm_trgr_id := null;
283: p_effective_start_date := null;
284: p_effective_end_date := null;
285: p_object_version_number := null;
286: hr_utility.set_location(' Leaving:'||l_proc, 90);
287: raise;
288: --
289: end create_PER_CM_TRGR;
290: -- ----------------------------------------------------------------------------
683: p_per_cm_trgr_id := null;
684: p_effective_start_date := null;
685: p_effective_end_date := null;
686: p_object_version_number := null;
687: hr_utility.set_location(' Leaving:'||l_proc, 80);
688: --
689: when others then
690: --
691: -- A validation or unexpected error has occured
689: when others then
690: --
691: -- A validation or unexpected error has occured
692: --
693: hr_utility.set_location(sqlerrm,10);
694: ROLLBACK TO create_PER_CM_TRGR;
695: p_per_cm_trgr_id := null;
696: p_effective_start_date := null;
697: p_effective_end_date := null;
695: p_per_cm_trgr_id := null;
696: p_effective_start_date := null;
697: p_effective_end_date := null;
698: p_object_version_number := null;
699: hr_utility.set_location(' Leaving:'||l_proc, 90);
700: raise;
701: --
702: end create_PER_CM_TRGR_perf;
703: -- ----------------------------------------------------------------------------
759: l_effective_end_date ben_per_cm_trgr_f.effective_end_date%TYPE;
760: --
761: begin
762: --
763: hr_utility.set_location('Entering:'|| l_proc, 10);
764: --
765: -- Issue a savepoint if operating in validation only mode
766: --
767: savepoint update_PER_CM_TRGR;
765: -- Issue a savepoint if operating in validation only mode
766: --
767: savepoint update_PER_CM_TRGR;
768: --
769: hr_utility.set_location(l_proc, 20);
770: --
771: -- Process Logic
772: --
773: l_object_version_number := p_object_version_number;
938: -- End of API User Hook for the after hook of update_PER_CM_TRGR
939: --
940: end;
941: --
942: hr_utility.set_location(l_proc, 60);
943: --
944: -- When in validation only mode raise the Validate_Enabled exception
945: --
946: if p_validate then
952: p_object_version_number := l_object_version_number;
953: p_effective_start_date := l_effective_start_date;
954: p_effective_end_date := l_effective_end_date;
955: --
956: hr_utility.set_location(' Leaving:'||l_proc, 70);
957: --
958: exception
959: --
960: when hr_api.validate_enabled then
967: -- Only set output warning arguments
968: -- (Any key or derived arguments must be set to null
969: -- when validation only mode is being used.)
970: --
971: hr_utility.set_location(' Leaving:'||l_proc, 80);
972: --
973: when others then
974: --
975: -- A validation or unexpected error has occured
976: --
977: ROLLBACK TO update_PER_CM_TRGR;
978: p_effective_start_date := null;
979: p_effective_end_date := null;
980: hr_utility.set_location(' Leaving:'||l_proc, 90);
981: raise;
982: --
983: end update_PER_CM_TRGR;
984: -- ----------------------------------------------------------------------------
1002: l_effective_end_date ben_per_cm_trgr_f.effective_end_date%TYPE;
1003: --
1004: begin
1005: --
1006: hr_utility.set_location('Entering:'|| l_proc, 10);
1007: --
1008: -- Issue a savepoint if operating in validation only mode
1009: --
1010: savepoint delete_PER_CM_TRGR;
1008: -- Issue a savepoint if operating in validation only mode
1009: --
1010: savepoint delete_PER_CM_TRGR;
1011: --
1012: hr_utility.set_location(l_proc, 20);
1013: --
1014: -- Process Logic
1015: --
1016: l_object_version_number := p_object_version_number;
1069: -- End of API User Hook for the after hook of delete_PER_CM_TRGR
1070: --
1071: end;
1072: --
1073: hr_utility.set_location(l_proc, 60);
1074: --
1075: -- When in validation only mode raise the Validate_Enabled exception
1076: --
1077: if p_validate then
1077: if p_validate then
1078: raise hr_api.validate_enabled;
1079: end if;
1080: --
1081: hr_utility.set_location(' Leaving:'||l_proc, 70);
1082: --
1083: exception
1084: --
1085: when hr_api.validate_enabled then
1102: --
1103: ROLLBACK TO delete_PER_CM_TRGR;
1104: p_effective_start_date := null;
1105: p_effective_end_date := null;
1106: hr_utility.set_location(' Leaving:'||l_proc, 90);
1107: raise;
1108: --
1109: end delete_PER_CM_TRGR;
1110: --
1128: l_validation_end_date date;
1129: --
1130: begin
1131: --
1132: hr_utility.set_location('Entering:'|| l_proc, 10);
1133: --
1134: ben_pcr_shd.lck
1135: (p_per_cm_trgr_id => p_per_cm_trgr_id
1136: ,p_validation_start_date => l_validation_start_date
1138: ,p_object_version_number => p_object_version_number
1139: ,p_effective_date => p_effective_date
1140: ,p_datetrack_mode => p_datetrack_mode);
1141: --
1142: hr_utility.set_location(' Leaving:'||l_proc, 70);
1143: --
1144: end lck;
1145: --
1146: end ben_PER_CM_TRGR_api;