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_AGENCY_APPEALS_API dependencies on HR_UTILITY

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

50: l_proc varchar2(72) := g_package||'create_agency_appeal';
51: l_compl_agency_appeal_id number;
52: l_object_version_number number;
53: begin
54: hr_utility.set_location('Entering:'|| l_proc, 10);
55: --
56: -- Issue a savepoint
57: --
58: savepoint create_agency_appeal;

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

55: --
56: -- Issue a savepoint
57: --
58: savepoint create_agency_appeal;
59: hr_utility.set_location(l_proc, 20);
60: --
61: -- Truncate the time portion from all IN date parameters
62: --
63: --

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

104: --
105: -- Validation in addition to Row Handlers
106: --
107:
108: hr_utility.set_location(l_proc, 40);
109: --
110: -- Process Logic
111: --
112: ghr_caa_ins.ins

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

142: ,p_compl_agency_appeal_id => l_compl_agency_appeal_id
143: ,p_object_version_number => l_object_version_number
144: );
145:
146: hr_utility.set_location(l_proc, 50);
147: --
148: -- Call After Process User Hook
149: --
150: begin

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

201: --
202: p_compl_agency_appeal_id := l_compl_agency_appeal_id;
203: p_object_version_number := l_object_version_number;
204: --
205: hr_utility.set_location(' Leaving:'||l_proc, 70);
206: exception
207: when hr_api.validate_enabled then
208: --
209: -- As the Validate_Enabled exception has been raised

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

216: -- when validation only mode is being used.)
217: --
218: p_compl_agency_appeal_id := null;
219: p_object_version_number := null;
220: hr_utility.set_location(' Leaving:'||l_proc, 80);
221: when others then
222: --
223: -- A validation or unexpected error has occured
224: --

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

224: --
225: rollback to create_agency_appeal;
226: p_compl_agency_appeal_id := null;
227: p_object_version_number := null;
228: hr_utility.set_location(' Leaving:'||l_proc, 90);
229: raise;
230: end create_agency_appeal;
231: --
232:

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

268: is
269: l_proc varchar2(72) := g_package||'update_agency_appeal';
270: l_object_version_number number;
271: begin
272: hr_utility.set_location('Entering:'|| l_proc, 5);
273: --
274: savepoint update_agency_appeal;
275: --
276: -- Truncate the time portion from all IN date parameters

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

324: -- Store the original ovn in case we rollback when p_validate is true
325: --
326: l_object_version_number := p_object_version_number;
327:
328: hr_utility.set_location(l_proc, 6);
329:
330: ghr_caa_upd.upd
331: (p_effective_date => p_effective_date
332: ,p_compl_agency_appeal_id => p_compl_agency_appeal_id

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

412: -- Set all output arguments
413: --
414: p_object_version_number := l_object_version_number;
415: --
416: hr_utility.set_location(' Leaving:'||l_proc, 70);
417: exception
418: when hr_api.validate_enabled then
419: --
420: -- As the Validate_Enabled exception has been raised

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

426: -- (Any key or derived arguments must be set to null
427: -- when validation only mode is being used.)
428: --
429: p_object_version_number := l_object_version_number;
430: hr_utility.set_location(' Leaving:'||l_proc, 80);
431: when others then
432: --
433: -- A validation or unexpected error has occured
434: --

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

433: -- A validation or unexpected error has occured
434: --
435: rollback to update_agency_appeal;
436: p_object_version_number := l_object_version_number;
437: hr_utility.set_location(' Leaving:'||l_proc, 90);
438: raise;
439:
440: end update_agency_appeal;
441:

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

454: l_proc varchar2(72) := g_package||'delete_agency_appeal';
455: l_exists boolean := false;
456:
457: begin
458: hr_utility.set_location('Entering:'|| l_proc, 5);
459: --
460: --
461: savepoint delete_agency_appeal;
462: --

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

486: (p_compl_agency_appeal_id => p_compl_agency_appeal_id
487: ,p_object_version_number => p_object_version_number
488: );
489: --
490: hr_utility.set_location(l_proc, 8);
491: --
492: -- Call After Process User Hook
493: --
494: begin

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

509: if p_validate then
510: raise hr_api.validate_enabled;
511: end if;
512: --
513: hr_utility.set_location(' Leaving:'||l_proc, 11);
514: exception
515: when hr_api.validate_enabled then
516: -- we must rollback to the savepoint
517: --

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

520: When Others then
521: ROLLBACK TO delete_agency_appeal;
522: raise;
523:
524: hr_utility.set_location(' Leaving:'||l_proc, 12);
525: end delete_agency_appeal;
526:
527: end ghr_agency_appeals_api;