DBA Data[Home] [Help]

APPS.BEN_PSTN_RT_API dependencies on HR_UTILITY

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

63: l_object_version_number ben_PSTN_RT_f.object_version_number%TYPE;
64: --
65: begin
66: --
67: hr_utility.set_location('Entering:'|| l_proc, 10);
68: --
69: -- Issue a savepoint if operating in validation only mode
70: --
71: savepoint create_PSTN_RT;

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

69: -- Issue a savepoint if operating in validation only mode
70: --
71: savepoint create_PSTN_RT;
72: --
73: hr_utility.set_location(l_proc, 20);
74: --
75: -- Process Logic
76: --
77: begin

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

129: -- End of API User Hook for the before hook of create_PSTN_RT
130: --
131: end;
132: --
133: hr_utility.set_location(l_proc, 30);
134: ben_pst_ins.ins
135: (
136: p_PSTN_RT_id => l_PSTN_RT_id
137: ,p_effective_start_date => l_effective_start_date

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

175: ,p_object_version_number => l_object_version_number
176: ,p_effective_date => trunc(p_effective_date)
177: );
178: --
179: hr_utility.set_location(l_proc, 40);
180: begin
181: --
182: -- Start of API User Hook for the after hook of create_PSTN_RT
183: --

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

234: --
235: -- End of API User Hook for the after hook of create_PSTN_RT
236: --
237: end;
238: hr_utility.set_location(l_proc, 50);
239: --
240: ben_profile_handler.event_handler
241: (p_event => 'CREATE',
242: p_base_table => 'BEN_VRBL_RT_PRFL_F',

Line 249: hr_utility.set_location(l_proc, 60);

245: p_base_table_reference_column => 'RT_PSTN_FLAG',
246: p_reference_table => 'BEN_PSTN_RT_F',
247: p_reference_table_column => 'VRBL_RT_PRFL_ID');
248: --
249: hr_utility.set_location(l_proc, 60);
250: --
251: -- When in validation only mode raise the Validate_Enabled exception
252: --
253: if p_validate then

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

260: p_effective_start_date := l_effective_start_date;
261: p_effective_end_date := l_effective_end_date;
262: p_object_version_number := l_object_version_number;
263: --
264: hr_utility.set_location(' Leaving:'||l_proc, 70);
265: --
266: exception
267: --
268: when hr_api.validate_enabled then

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

279: p_PSTN_RT_id := null;
280: p_effective_start_date := null;
281: p_effective_end_date := null;
282: p_object_version_number := null;
283: hr_utility.set_location(' Leaving:'||l_proc, 80);
284: --
285: when others then
286: --
287: -- A validation or unexpected error has occured

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

355: l_effective_end_date ben_PSTN_RT_f.effective_end_date%TYPE;
356: --
357: begin
358: --
359: hr_utility.set_location('Entering:'|| l_proc, 10);
360: --
361: -- Issue a savepoint if operating in validation only mode
362: --
363: savepoint update_PSTN_RT;

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

361: -- Issue a savepoint if operating in validation only mode
362: --
363: savepoint update_PSTN_RT;
364: --
365: hr_utility.set_location(l_proc, 20);
366: --
367: -- Process Logic
368: --
369: l_object_version_number := p_object_version_number;

Line 535: hr_utility.set_location(l_proc, 60);

531: -- End of API User Hook for the after hook of update_PSTN_RT
532: --
533: end;
534: --
535: hr_utility.set_location(l_proc, 60);
536: --
537: -- When in validation only mode raise the Validate_Enabled exception
538: --
539: if p_validate then

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

545: p_object_version_number := l_object_version_number;
546: p_effective_start_date := l_effective_start_date;
547: p_effective_end_date := l_effective_end_date;
548: --
549: hr_utility.set_location(' Leaving:'||l_proc, 70);
550: --
551: exception
552: --
553: when hr_api.validate_enabled then

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

560: -- Only set output warning arguments
561: -- (Any key or derived arguments must be set to null
562: -- when validation only mode is being used.)
563: --
564: hr_utility.set_location(' Leaving:'||l_proc, 80);
565: --
566: when others then
567: --
568: -- A validation or unexpected error has occured

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

601: l_effective_end_date ben_PSTN_RT_f.effective_end_date%TYPE;
602: --
603: begin
604: --
605: hr_utility.set_location('Entering:'|| l_proc, 10);
606: --
607: -- Issue a savepoint if operating in validation only mode
608: --
609: savepoint delete_PSTN_RT;

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

607: -- Issue a savepoint if operating in validation only mode
608: --
609: savepoint delete_PSTN_RT;
610: --
611: hr_utility.set_location(l_proc, 20);
612: --
613: -- Process Logic
614: --
615: l_object_version_number := p_object_version_number;

Line 683: hr_utility.set_location(l_proc, 60);

679: p_base_table_reference_column => 'RT_PSTN_FLAG',
680: p_reference_table => 'BEN_PSTN_RT_F',
681: p_reference_table_column => 'VRBL_RT_PRFL_ID');
682: --
683: hr_utility.set_location(l_proc, 60);
684: --
685: -- When in validation only mode raise the Validate_Enabled exception
686: --
687: if p_validate then

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

687: if p_validate then
688: raise hr_api.validate_enabled;
689: end if;
690: --
691: hr_utility.set_location(' Leaving:'||l_proc, 70);
692: --
693: exception
694: --
695: when hr_api.validate_enabled then

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

742: l_validation_end_date date;
743: --
744: begin
745: --
746: hr_utility.set_location('Entering:'|| l_proc, 10);
747: --
748: ben_pst_shd.lck
749: (
750: p_PSTN_RT_id => p_PSTN_RT_id

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

754: ,p_effective_date => p_effective_date
755: ,p_datetrack_mode => p_datetrack_mode
756: );
757: --
758: hr_utility.set_location(' Leaving:'||l_proc, 70);
759: --
760: end lck;
761: --
762: end ben_PSTN_RT_api;