DBA Data[Home] [Help]

APPS.GHR_COMPLAINT_CLAIMS_API dependencies on HR_UTILITY

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

32: l_proc varchar2(72) := g_package||'create_compl_claim';
33: l_compl_claim_id number;
34: l_object_version_number number;
35: begin
36: hr_utility.set_location('Entering:'|| l_proc, 10);
37: --
38: -- Issue a savepoint
39: --
40: savepoint create_compl_claim;

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

37: --
38: -- Issue a savepoint
39: --
40: savepoint create_compl_claim;
41: hr_utility.set_location(l_proc, 20);
42: --
43: -- Truncate the time portion from all IN date parameters
44: --
45: -- Call Before Process User Hook

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

69: --
70: -- Validation in addition to Row Handlers
71: --
72:
73: hr_utility.set_location(l_proc, 40);
74: --
75: -- Process Logic
76: --
77: ghr_ccl_ins.ins

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

88: ,p_agency_appeal => p_agency_appeal
89: ,p_compl_claim_id => l_compl_claim_id
90: ,p_object_version_number => l_object_version_number
91: );
92: hr_utility.set_location(l_proc, 50);
93: --
94: -- Call After Process User Hook
95: --
96: begin

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

126: --
127: p_compl_claim_id := l_compl_claim_id;
128: p_object_version_number := l_object_version_number;
129: --
130: hr_utility.set_location(' Leaving:'||l_proc, 70);
131: exception
132: when hr_api.validate_enabled then
133: --
134: -- As the Validate_Enabled exception has been raised

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

141: -- when validation only mode is being used.)
142: --
143: p_compl_claim_id := null;
144: p_object_version_number := null;
145: hr_utility.set_location(' Leaving:'||l_proc, 80);
146: when others then
147: --
148: -- A validation or unexpected error has occured
149: --

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

150: rollback to create_compl_claim;
151: --RESET In/Out Params and SET Out Params
152: p_compl_claim_id := null;
153: p_object_version_number := null;
154: hr_utility.set_location(' Leaving:'||l_proc, 90);
155: raise;
156: end create_compl_claim;
157: --
158:

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

175: is
176: l_proc varchar2(72) := g_package||'update_compl_claim';
177: l_object_version_number number;
178: begin
179: hr_utility.set_location('Entering:'|| l_proc, 5);
180: --
181: savepoint update_compl_claim;
182:
183: --

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

218: -- Store the original ovn in case we rollback when p_validate is true
219: --
220: l_object_version_number := p_object_version_number;
221:
222: hr_utility.set_location(l_proc, 6);
223:
224: ghr_ccl_upd.upd
225: (p_effective_date => p_effective_date
226: ,p_compl_claim_id => p_compl_claim_id

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

270: -- Set all output arguments
271: --
272: p_object_version_number := l_object_version_number;
273: --
274: hr_utility.set_location(' Leaving:'||l_proc, 70);
275: exception
276: when hr_api.validate_enabled then
277: --
278: -- As the Validate_Enabled exception has been raised

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

284: -- (Any key or derived arguments must be set to null
285: -- when validation only mode is being used.)
286: --
287: p_object_version_number := l_object_version_number;
288: hr_utility.set_location(' Leaving:'||l_proc, 80);
289: when others then
290: --
291: -- A validation or unexpected error has occured
292: --

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

292: --
293: rollback to update_compl_claim;
294: --RESET In/Out Params and SET Out Params
295: p_object_version_number := l_object_version_number;
296: hr_utility.set_location(' Leaving:'||l_proc, 90);
297: raise;
298:
299: end update_compl_claim;
300:

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

313: l_proc varchar2(72) := g_package||'delete_compl_claim';
314: l_exists boolean := false;
315:
316: begin
317: hr_utility.set_location('Entering:'|| l_proc, 5);
318: --
319: --
320: savepoint delete_compl_claim;
321: --

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

345: (p_compl_claim_id => p_compl_claim_id
346: ,p_object_version_number => p_object_version_number
347: );
348: --
349: hr_utility.set_location(l_proc, 8);
350: --
351: -- Call After Process User Hook
352: --
353: begin

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

371: if p_validate then
372: raise hr_api.validate_enabled;
373: end if;
374: --
375: hr_utility.set_location(' Leaving:'||l_proc, 11);
376: exception
377: when hr_api.validate_enabled then
378: -- we must rollback to the savepoint
379: --

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

382: When Others then
383: ROLLBACK TO delete_compl_claim;
384: raise;
385:
386: hr_utility.set_location(' Leaving:'||l_proc, 12);
387: end delete_compl_claim;
388: end ghr_complaint_claims_api;
389: