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.PER_SP_PLAN_API dependencies on HR_UTILITY

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

56: l_proc varchar2(72) := g_package||'create_sp_plan';
57: l_plan_id per_sp_plan.plan_id%TYPE;
58: l_object_version_number per_sp_plan.object_version_number%TYPE;
59: begin
60: hr_utility.set_location('Entering:'|| l_proc, 10);
61: --
62: -- Issue a savepoint
63: --
64: savepoint create_sp_plan;

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

66: --
67: -- Truncate the time portion from all IN date parameters
68: --
69: l_effective_date := trunc(p_effective_date);
70: hr_utility.set_location(l_proc, 20);
71:
72: --
73: -- Call Before Process User Hook
74: --

Line 125: hr_utility.set_location(l_proc, 30);

121: -- Validation in addition to Row Handlers
122: --
123:
124:
125: hr_utility.set_location(l_proc, 30);
126:
127: --
128: -- Process Logic
129: --

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

127: --
128: -- Process Logic
129: --
130:
131: hr_utility.set_location(l_proc, 40);
132: per_sph_ins.ins(p_effective_date => l_effective_date
133: ,p_plan_id => l_plan_id
134: ,p_plan_type => p_plan_type
135: ,p_plan_name => p_plan_name

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

216: (p_module_name => 'create_sp_plan_b'
217: ,p_hook_type => 'AP'
218: );
219: end;
220: hr_utility.set_location(l_proc, 50);
221:
222: --
223: -- When in validation only mode raise the Validate_Enabled exception
224: --

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

230: --
231: p_plan_id := l_plan_id;
232: p_object_version_number := l_object_version_number;
233: --
234: hr_utility.set_location(' Leaving:'||l_proc, 70);
235: exception
236: when hr_api.validate_enabled then
237: --
238: -- As the Validate_Enabled exception has been raised

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

245: -- when validation only mode is being used.)
246: --
247: p_plan_id := null;
248: p_object_version_number := null;
249: hr_utility.set_location(' Leaving:'||l_proc, 80);
250: when others then
251: --
252: -- A validation or unexpected error has occured
253: --

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

257: -- OUT parameters, including warnings, to null
258: --
259: p_plan_id := null;
260: p_object_version_number := null;
261: hr_utility.set_location(' Leaving:'||l_proc, 90);
262: raise;
263: end create_sp_plan;
264: --
265: --

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

313: l_effective_date date;
314: l_proc varchar2(72) := g_package||'update_sp_plan';
315: l_object_version_number per_sp_plan.object_version_number%TYPE;
316: begin
317: hr_utility.set_location('Entering:'|| l_proc, 10);
318: --
319: -- Issue a savepoint
320: --
321: savepoint update_sp_plan;

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

325: --
326: -- Truncate the time portion from all IN date parameters
327: --
328: l_effective_date := trunc(p_effective_date);
329: hr_utility.set_location(l_proc, 20);
330:
331: --
332: -- Call Before Process User Hook
333: --

Line 385: hr_utility.set_location(l_proc, 30);

381: -- Validation in addition to Row Handlers
382: --
383:
384:
385: hr_utility.set_location(l_proc, 30);
386:
387: --
388: -- Process Logic
389: --

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

387: --
388: -- Process Logic
389: --
390:
391: hr_utility.set_location(l_proc, 40);
392: per_sph_upd.upd(p_effective_date => l_effective_date
393: ,p_plan_id => p_plan_id
394: ,p_plan_type => p_plan_type
395: ,p_plan_name => p_plan_name

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

476: (p_module_name => 'update_sp_plan_b'
477: ,p_hook_type => 'AP'
478: );
479: end;
480: hr_utility.set_location(l_proc, 50);
481:
482: --
483: -- When in validation only mode raise the Validate_Enabled exception
484: --

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

489: -- Set all IN OUT and OUT parameters with out values
490: --
491: p_object_version_number := l_object_version_number;
492: --
493: hr_utility.set_location(' Leaving:'||l_proc, 70);
494: exception
495: when hr_api.validate_enabled then
496: --
497: -- As the Validate_Enabled exception has been raised

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

503: -- (Any key or derived arguments must be set to null
504: -- when validation only mode is being used.)
505: --
506: p_object_version_number := l_object_version_number;
507: hr_utility.set_location(' Leaving:'||l_proc, 80);
508: when others then
509: --
510: -- A validation or unexpected error has occured
511: --

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

514: -- Reset IN OUT parameters and set all
515: -- OUT parameters, including warnings, to null
516: --
517: p_object_version_number := l_object_version_number;
518: hr_utility.set_location(' Leaving:'||l_proc, 90);
519: raise;
520: end update_sp_plan;
521: --
522: --

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

528: -- Declare cursors and local variables
529: --
530: l_proc varchar2(72) := g_package||'delete_sp_plan';
531: begin
532: hr_utility.set_location('Entering:'|| l_proc, 5);
533: --
534: -- Issue a savepoint.
535: --
536: savepoint delete_sp_plan;

Line 537: hr_utility.set_location(l_proc, 10);

533: --
534: -- Issue a savepoint.
535: --
536: savepoint delete_sp_plan;
537: hr_utility.set_location(l_proc, 10);
538: per_sp_plan_bk3.delete_sp_plan_b(p_plan_id => p_plan_id);
539: hr_utility.set_location(l_proc, 20);
540: per_sph_del.del(p_plan_id => p_plan_id
541: ,p_object_version_number => p_object_version_number);

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

535: --
536: savepoint delete_sp_plan;
537: hr_utility.set_location(l_proc, 10);
538: per_sp_plan_bk3.delete_sp_plan_b(p_plan_id => p_plan_id);
539: hr_utility.set_location(l_proc, 20);
540: per_sph_del.del(p_plan_id => p_plan_id
541: ,p_object_version_number => p_object_version_number);
542: hr_utility.set_location(l_proc, 30);
543: per_sp_plan_bk3.delete_sp_plan_a(p_plan_id => p_plan_id);

Line 542: hr_utility.set_location(l_proc, 30);

538: per_sp_plan_bk3.delete_sp_plan_b(p_plan_id => p_plan_id);
539: hr_utility.set_location(l_proc, 20);
540: per_sph_del.del(p_plan_id => p_plan_id
541: ,p_object_version_number => p_object_version_number);
542: hr_utility.set_location(l_proc, 30);
543: per_sp_plan_bk3.delete_sp_plan_a(p_plan_id => p_plan_id);
544: hr_utility.set_location(l_proc, 50);
545: --
546: -- When in validation only mode raise the Validate_Enabled exception

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

540: per_sph_del.del(p_plan_id => p_plan_id
541: ,p_object_version_number => p_object_version_number);
542: hr_utility.set_location(l_proc, 30);
543: per_sp_plan_bk3.delete_sp_plan_a(p_plan_id => p_plan_id);
544: hr_utility.set_location(l_proc, 50);
545: --
546: -- When in validation only mode raise the Validate_Enabled exception
547: --
548: if p_validate then

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

551: --
552: -- Set all IN OUT and OUT parameters with out values
553: --
554: --
555: hr_utility.set_location(' Leaving:'||l_proc, 70);
556: exception
557: when hr_api.validate_enabled then
558: --
559: -- As the Validate_Enabled exception has been raised

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

564: -- Reset IN OUT parameters and set OUT parameters
565: -- (Any key or derived arguments must be set to null
566: -- when validation only mode is being used.)
567: --
568: hr_utility.set_location(' Leaving:'||l_proc, 80);
569: when others then
570: --
571: -- A validation or unexpected error has occured
572: --

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

574: --
575: -- Reset IN OUT parameters and set all
576: -- OUT parameters, including warnings, to null
577: --
578: hr_utility.set_location(' Leaving:'||l_proc, 90);
579: raise;
580:
581: end delete_sp_plan;
582: --