DBA Data[Home] [Help]

APPS.PER_SUCCESSOR_IN_PLAN_API dependencies on HR_UTILITY

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

77: l_proc varchar2(72) := g_package||'create_successor_in_plan';
78: l_successor_in_plan_id per_sp_successor_in_plan.successor_in_plan_id%TYPE;
79: l_object_version_number per_sp_successor_in_plan.object_version_number%TYPE;
80: begin
81: hr_utility.set_location('Entering:'|| l_proc, 10);
82: --
83: -- Issue a savepoint
84: --
85: savepoint create_successor_in_plan;

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

87: --
88: -- Truncate the time portion from all IN date parameters
89: --
90: l_effective_date := trunc(p_effective_date);
91: hr_utility.set_location(l_proc, 20);
92:
93: --
94: -- Call Before Process User Hook
95: --

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

162: -- Validation in addition to Row Handlers
163: --
164:
165:
166: hr_utility.set_location(l_proc, 30);
167:
168: --
169: -- Process Logic
170: --

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

168: --
169: -- Process Logic
170: --
171:
172: hr_utility.set_location(l_proc, 40);
173: per_sip_ins.ins( p_effective_date => l_effective_date
174: ,p_successor_in_plan_id => l_successor_in_plan_id
175: ,p_plan_id => p_plan_id
176: ,p_successor_id => p_successor_id

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

299: (p_module_name => 'create_successor_in_plan_b'
300: ,p_hook_type => 'AP'
301: );
302: end;
303: hr_utility.set_location(l_proc, 50);
304:
305: --
306: -- When in validation only mode raise the Validate_Enabled exception
307: --

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

313: --
314: p_successor_in_plan_id := l_successor_in_plan_id;
315: p_object_version_number := l_object_version_number;
316: --
317: hr_utility.set_location(' Leaving:'||l_proc, 70);
318: exception
319: when hr_api.validate_enabled then
320: --
321: -- As the Validate_Enabled exception has been raised

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

328: -- when validation only mode is being used.)
329: --
330: p_successor_in_plan_id := null;
331: p_object_version_number := null;
332: hr_utility.set_location(' Leaving:'||l_proc, 80);
333: when others then
334: --
335: -- A validation or unexpected error has occured
336: --

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

340: -- OUT parameters, including warnings, to null
341: --
342: p_successor_in_plan_id := null;
343: p_object_version_number := null;
344: hr_utility.set_location(' Leaving:'||l_proc, 90);
345: raise;
346: end create_successor_in_plan;
347: --
348: --

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

417: l_effective_date date;
418: l_proc varchar2(72) := g_package||'update_successor_in_plan';
419: l_object_version_number per_sp_successor_in_plan.object_version_number%TYPE;
420: begin
421: hr_utility.set_location('Entering:'|| l_proc, 10);
422: --
423: -- Issue a savepoint
424: --
425: savepoint update_successor_in_plan;

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

429: --
430: -- Truncate the time portion from all IN date parameters
431: --
432: l_effective_date := trunc(p_effective_date);
433: hr_utility.set_location(l_proc, 20);
434:
435: --
436: -- Call Before Process User Hook
437: --

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

505: -- Validation in addition to Row Handlers
506: --
507:
508:
509: hr_utility.set_location(l_proc, 30);
510:
511: --
512: -- Process Logic
513: --

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

511: --
512: -- Process Logic
513: --
514:
515: hr_utility.set_location(l_proc, 40);
516: per_sip_upd.upd( p_effective_date => l_effective_date
517: ,p_successor_in_plan_id => p_successor_in_plan_id
518: ,p_plan_id => p_plan_id
519: ,p_successor_id => p_successor_id

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

640: (p_module_name => 'update_successor_in_plan_b'
641: ,p_hook_type => 'AP'
642: );
643: end;
644: hr_utility.set_location(l_proc, 50);
645:
646: --
647: -- When in validation only mode raise the Validate_Enabled exception
648: --

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

653: -- Set all IN OUT and OUT parameters with out values
654: --
655: p_object_version_number := l_object_version_number;
656: --
657: hr_utility.set_location(' Leaving:'||l_proc, 70);
658: exception
659: when hr_api.validate_enabled then
660: --
661: -- As the Validate_Enabled exception has been raised

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

667: -- (Any key or derived arguments must be set to null
668: -- when validation only mode is being used.)
669: --
670: p_object_version_number := l_object_version_number;
671: hr_utility.set_location(' Leaving:'||l_proc, 80);
672: when others then
673: --
674: -- A validation or unexpected error has occured
675: --

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

678: -- Reset IN OUT parameters and set all
679: -- OUT parameters, including warnings, to null
680: --
681: p_object_version_number := l_object_version_number;
682: hr_utility.set_location(' Leaving:'||l_proc, 90);
683: raise;
684: end update_successor_in_plan;
685: --
686: --

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

692: -- Declare cursors and local variables
693: --
694: l_proc varchar2(72) := g_package||'delete_successor_in_plan';
695: begin
696: hr_utility.set_location('Entering:'|| l_proc, 5);
697: --
698: -- Issue a savepoint.
699: --
700: savepoint delete_successor_in_plan;

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

697: --
698: -- Issue a savepoint.
699: --
700: savepoint delete_successor_in_plan;
701: hr_utility.set_location(l_proc, 10);
702: per_successor_in_plan_bk3.delete_successor_in_plan_b(p_successor_in_plan_id => p_successor_in_plan_id);
703: hr_utility.set_location(l_proc, 20);
704: per_sip_del.del(p_successor_in_plan_id => p_successor_in_plan_id
705: ,p_object_version_number => p_object_version_number);

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

699: --
700: savepoint delete_successor_in_plan;
701: hr_utility.set_location(l_proc, 10);
702: per_successor_in_plan_bk3.delete_successor_in_plan_b(p_successor_in_plan_id => p_successor_in_plan_id);
703: hr_utility.set_location(l_proc, 20);
704: per_sip_del.del(p_successor_in_plan_id => p_successor_in_plan_id
705: ,p_object_version_number => p_object_version_number);
706: hr_utility.set_location(l_proc, 30);
707: per_successor_in_plan_bk3.delete_successor_in_plan_a(p_successor_in_plan_id => p_successor_in_plan_id);

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

702: per_successor_in_plan_bk3.delete_successor_in_plan_b(p_successor_in_plan_id => p_successor_in_plan_id);
703: hr_utility.set_location(l_proc, 20);
704: per_sip_del.del(p_successor_in_plan_id => p_successor_in_plan_id
705: ,p_object_version_number => p_object_version_number);
706: hr_utility.set_location(l_proc, 30);
707: per_successor_in_plan_bk3.delete_successor_in_plan_a(p_successor_in_plan_id => p_successor_in_plan_id);
708: hr_utility.set_location(l_proc, 50);
709: --
710: -- When in validation only mode raise the Validate_Enabled exception

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

704: per_sip_del.del(p_successor_in_plan_id => p_successor_in_plan_id
705: ,p_object_version_number => p_object_version_number);
706: hr_utility.set_location(l_proc, 30);
707: per_successor_in_plan_bk3.delete_successor_in_plan_a(p_successor_in_plan_id => p_successor_in_plan_id);
708: hr_utility.set_location(l_proc, 50);
709: --
710: -- When in validation only mode raise the Validate_Enabled exception
711: --
712: if p_validate then

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

715: --
716: -- Set all IN OUT and OUT parameters with out values
717: --
718: --
719: hr_utility.set_location(' Leaving:'||l_proc, 70);
720: exception
721: when hr_api.validate_enabled then
722: --
723: -- As the Validate_Enabled exception has been raised

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

728: -- Reset IN OUT parameters and set OUT parameters
729: -- (Any key or derived arguments must be set to null
730: -- when validation only mode is being used.)
731: --
732: hr_utility.set_location(' Leaving:'||l_proc, 80);
733: when others then
734: --
735: -- A validation or unexpected error has occured
736: --

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

738: --
739: -- Reset IN OUT parameters and set all
740: -- OUT parameters, including warnings, to null
741: --
742: hr_utility.set_location(' Leaving:'||l_proc, 90);
743: raise;
744:
745: end delete_successor_in_plan;
746: --