DBA Data[Home] [Help]

APPS.GHR_COMPL_AGENCY_COSTS_API dependencies on HR_UTILITY

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

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

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

36: --
37: -- Issue a savepoint
38: --
39: savepoint create_agency_costs;
40: hr_utility.set_location(l_proc, 20);
41: --
42: -- Truncate the time portion from all IN date parameters
43: --
44: --

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

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

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

83: ,p_description => p_description
84: ,p_compl_agency_cost_id => l_compl_agency_cost_id
85: ,p_object_version_number => l_object_version_number
86: );
87: hr_utility.set_location(l_proc, 50);
88: --
89: --
90: -- Call After Process User Hook
91: --

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

120: --
121: p_compl_agency_cost_id := l_compl_agency_cost_id;
122: p_object_version_number := l_object_version_number;
123: --
124: hr_utility.set_location(' Leaving:'||l_proc, 70);
125: exception
126: when hr_api.validate_enabled then
127: --
128: -- As the Validate_Enabled exception has been raised

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

135: -- when validation only mode is being used.)
136: --
137: p_compl_agency_cost_id := null;
138: p_object_version_number := null;
139: hr_utility.set_location(' Leaving:'||l_proc, 80);
140: when others then
141: --
142: -- A validation or unexpected error has occured
143: --

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

146: -- Reset IN OUT parameters and set OUT parameters
147: --
148: p_compl_agency_cost_id := null;
149: p_object_version_number := null;
150: hr_utility.set_location(' Leaving:'||l_proc, 90);
151: raise;
152: end create_agency_costs;
153: --
154:

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

172: l_object_version_number number;
173: -- Initial OVN.
174: l_i_object_version_number number;
175: begin
176: hr_utility.set_location('Entering:'|| l_proc, 5);
177: --
178: savepoint update_agency_costs;
179: --
180: -- Remember IN OUT parameter IN values

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

212: -- Store the original ovn in case we rollback when p_validate is true
213: --
214: l_object_version_number := p_object_version_number;
215:
216: hr_utility.set_location(l_proc, 6);
217:
218: ghr_cst_upd.upd
219: (p_effective_date => p_effective_date
220: ,p_complaint_id => p_complaint_id

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

260: -- Set all output arguments
261: --
262: p_object_version_number := l_object_version_number;
263: --
264: hr_utility.set_location(' Leaving:'||l_proc, 70);
265: exception
266: when hr_api.validate_enabled then
267: --
268: -- As the Validate_Enabled exception has been raised

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

274: -- (Any key or derived arguments must be set to null
275: -- when validation only mode is being used.)
276: --
277: p_object_version_number := l_i_object_version_number;
278: hr_utility.set_location(' Leaving:'||l_proc, 80);
279: when others then
280: --
281: -- A validation or unexpected error has occured
282: --

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

284: --
285: -- Reset IN OUT parameters and set OUT parameters
286: --
287: p_object_version_number := l_i_object_version_number;
288: hr_utility.set_location(' Leaving:'||l_proc, 90);
289: raise;
290:
291: end update_agency_costs;
292:

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

305: l_proc varchar2(72) := g_package||'delete_agency_costs';
306: l_exists boolean := false;
307:
308: begin
309: hr_utility.set_location('Entering:'|| l_proc, 5);
310: --
311: --
312: savepoint delete_agency_costs;
313: --

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

337: (p_compl_agency_cost_id => p_compl_agency_cost_id
338: ,p_object_version_number => p_object_version_number
339: );
340: --
341: hr_utility.set_location(l_proc, 8);
342: --
343: -- Call After Process User Hook
344: --
345: begin

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

360: if p_validate then
361: raise hr_api.validate_enabled;
362: end if;
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 11);
365: exception
366: when hr_api.validate_enabled then
367: -- we must rollback to the savepoint
368: --

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

371: When Others then
372: ROLLBACK TO delete_agency_costs;
373: raise;
374:
375: hr_utility.set_location(' Leaving:'||l_proc, 12);
376: end delete_agency_costs;
377: end ghr_compl_agency_costs_api;
378: