eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_COMPLAINT_ADRS_API dependencies on HR_UTILITY

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

32: l_proc varchar2(72) := g_package||'create_compl_adr';
33: l_compl_adr_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_adr;

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

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

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

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

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

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

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

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

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

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

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

150: --
151: rollback to create_compl_adr;
152: p_compl_adr_id := null;
153: p_object_version_number := null;
154: hr_utility.set_location(' Leaving:'||l_proc, 90);
155: raise;
156: end create_compl_adr;
157: --
158: --

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

180: l_proc varchar2(72) := g_package||'update_compl_adr';
181: l_compl_adr_id number;
182: l_object_version_number number;
183: begin
184: hr_utility.set_location('Entering:'|| l_proc, 5);
185: --
186: savepoint update_compl_adr;
187: -- Truncate the time portion from all IN date parameters
188: --

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

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

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

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

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

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

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

290: -- A validation or unexpected error has occured
291: --
292: rollback to update_compl_adr;
293: p_object_version_number := l_object_version_number;
294: hr_utility.set_location(' Leaving:'||l_proc, 90);
295: raise;
296:
297: end update_compl_adr;
298:

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

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

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

341: (p_compl_adr_id => p_compl_adr_id
342: ,p_object_version_number => p_object_version_number
343: );
344: --
345: hr_utility.set_location(l_proc, 8);
346: --
347: -- Call After Process User Hook
348: --
349: begin

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

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

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

375: When Others then
376: ROLLBACK TO delete_compl_adr;
377: raise;
378:
379: hr_utility.set_location(' Leaving:'||l_proc, 12);
380: end delete_compl_adr;
381: end ghr_complaint_adrs_api;