29: l_compl_incident_id number;
30: l_object_version_number number;
31:
32: begin
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --
35: -- Issue a savepoint
36: --
37: savepoint create_compl_incident;
34: --
35: -- Issue a savepoint
36: --
37: savepoint create_compl_incident;
38: hr_utility.set_location(l_proc, 20);
39: --
40: -- Truncate the time portion from all IN date parameters
41: --
42: --
60: end;
61: --
62: -- Validation in addition to Row Handlers
63: --
64: hr_utility.set_location(l_proc, 40);
65: --
66: -- Process Logic
67: --
68: ghr_cin_ins.ins
74: ,p_date_acknowledged => p_date_acknowledged
75: ,p_compl_incident_id => l_compl_incident_id
76: ,p_object_version_number => l_object_version_number
77: );
78: hr_utility.set_location(l_proc, 50);
79: --
80: -- Call After Process User Hook
81: --
82: begin
108: --
109: p_compl_incident_id := l_compl_incident_id;
110: p_object_version_number := l_object_version_number;
111: --
112: hr_utility.set_location(' Leaving:'||l_proc, 70);
113: exception
114: when hr_api.validate_enabled then
115: --
116: -- As the Validate_Enabled exception has been raised
123: -- when validation only mode is being used.)
124: --
125: p_compl_incident_id := null;
126: p_object_version_number := null;
127: hr_utility.set_location(' Leaving:'||l_proc, 80);
128: when others then
129: --
130: -- A validation or unexpected error has occured
131: --
132: rollback to create_compl_incident;
133: --RESET In/Out Params and SET Out Params
134: p_compl_incident_id := null;
135: p_object_version_number := null;
136: hr_utility.set_location(' Leaving:'||l_proc, 90);
137: raise;
138: end create_compl_incident;
139: --
140: -- ----------------------------------------------------------------------------
157: is
158: l_proc varchar2(72) := g_package||'update_compl_incident';
159: l_object_version_number number;
160: begin
161: hr_utility.set_location('Entering:'|| l_proc, 5);
162: --
163: savepoint update_compl_incident;
164: --
165: -- Truncate the time portion from all IN date parameters
192: -- Store the original ovn in case we rollback when p_validate is true
193: --
194: l_object_version_number := p_object_version_number;
195:
196: hr_utility.set_location(l_proc, 6);
197:
198: ghr_cin_upd.upd
199: (p_effective_date => p_effective_date
200: ,p_compl_claim_id => p_compl_claim_id
236: -- Set all output arguments
237: --
238: p_object_version_number := l_object_version_number;
239: --
240: hr_utility.set_location(' Leaving:'||l_proc, 70);
241: exception
242: when hr_api.validate_enabled then
243: --
244: -- As the Validate_Enabled exception has been raised
250: -- (Any key or derived arguments must be set to null
251: -- when validation only mode is being used.)
252: --
253: p_object_version_number := l_object_version_number;
254: hr_utility.set_location(' Leaving:'||l_proc, 80);
255: when others then
256: --
257: -- A validation or unexpected error has occured
258: --
258: --
259: rollback to update_compl_incident;
260: --RESET In/Out Params and SET Out Params
261: p_object_version_number := l_object_version_number;
262: hr_utility.set_location(' Leaving:'||l_proc, 90);
263: raise;
264:
265: end update_compl_incident;
266:
279: l_proc varchar2(72) := g_package||'delete_compl_incident';
280: l_exists boolean := false;
281:
282: begin
283: hr_utility.set_location('Entering:'|| l_proc, 5);
284: --
285: --
286: savepoint delete_compl_incident;
287: --
311: (p_compl_incident_id => p_compl_incident_id
312: ,p_object_version_number => p_object_version_number
313: );
314: --
315: hr_utility.set_location(l_proc, 8);
316: --
317: -- Call After Process User Hook
318: --
319: begin
334: if p_validate then
335: raise hr_api.validate_enabled;
336: end if;
337: --
338: hr_utility.set_location(' Leaving:'||l_proc, 11);
339: exception
340: when hr_api.validate_enabled then
341: -- we must rollback to the savepoint
342: --
345: When Others then
346: ROLLBACK TO delete_compl_incident;
347: raise;
348:
349: hr_utility.set_location(' Leaving:'||l_proc, 12);
350: end delete_compl_incident;
351:
352: end ghr_complaint_incidents_api;