DBA Data[Home] [Help]

APPS.GHR_COMPLAINT_INCIDENTS_API dependencies on HR_UTILITY

Line 33: hr_utility.set_location('Entering:'|| l_proc, 10);

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;

Line 38: hr_utility.set_location(l_proc, 20);

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: --

Line 64: hr_utility.set_location(l_proc, 40);

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

Line 78: hr_utility.set_location(l_proc, 50);

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

Line 112: hr_utility.set_location(' Leaving:'||l_proc, 70);

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

Line 127: hr_utility.set_location(' Leaving:'||l_proc, 80);

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: --

Line 136: hr_utility.set_location(' Leaving:'||l_proc, 90);

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: -- ----------------------------------------------------------------------------

Line 161: hr_utility.set_location('Entering:'|| l_proc, 5);

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

Line 196: hr_utility.set_location(l_proc, 6);

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

Line 240: hr_utility.set_location(' Leaving:'||l_proc, 70);

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

Line 254: hr_utility.set_location(' Leaving:'||l_proc, 80);

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: --

Line 262: hr_utility.set_location(' Leaving:'||l_proc, 90);

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:

Line 283: hr_utility.set_location('Entering:'|| l_proc, 5);

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: --

Line 315: hr_utility.set_location(l_proc, 8);

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

Line 338: hr_utility.set_location(' Leaving:'||l_proc, 11);

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: --

Line 349: hr_utility.set_location(' Leaving:'||l_proc, 12);

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;