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

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

60: --
61: l_proc varchar2(72) := g_package||'dt_delete_dml';
62: --
63: Begin
64: hr_utility.set_location('Entering:'||l_proc, 5);
65: If (p_datetrack_mode = hr_api.g_delete_next_change) then
66: per_sps_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal

Line 89: hr_utility.set_location(' Leaving:'||l_proc, 20);

85: --
86: per_sps_shd.g_api_dml := false; -- Unset the api dml status
87: End If;
88: --
89: hr_utility.set_location(' Leaving:'||l_proc, 20);
90: --
91: Exception
92: When Others Then
93: per_sps_shd.g_api_dml := false; -- Unset the api dml status

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

108: --
109: l_proc varchar2(72) := g_package||'delete_dml';
110: --
111: Begin
112: hr_utility.set_location('Entering:'||l_proc, 5);
113: --
114: per_sps_del.dt_delete_dml
115: (p_rec => p_rec
116: ,p_effective_date => p_effective_date

Line 122: hr_utility.set_location(' Leaving:'||l_proc, 10);

118: ,p_validation_start_date => p_validation_start_date
119: ,p_validation_end_date => p_validation_end_date
120: );
121: --
122: hr_utility.set_location(' Leaving:'||l_proc, 10);
123: End delete_dml;
124: --
125: -- ----------------------------------------------------------------------------
126: -- |----------------------------< dt_pre_delete >-----------------------------|

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

181: and p_effective_date between
182: spine.effective_start_date and spine.effective_end_date;
183:
184: Begin
185: hr_utility.set_location('Entering:'||l_proc, 5);
186: --
187: --
188: -- Call pqh_gsp_sync_compensation_obj.delete_oipl_for_step
189: --

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

191: open csr_get_grade_id;
192: fetch csr_get_grade_id into l_grade_id,l_spinal_point_id;
193: if csr_get_grade_id%notfound then
194: close csr_get_grade_id;
195: hr_utility.set_location(l_proc, 40);
196: else
197: close csr_get_grade_id;
198: l_return := pqh_gsp_sync_compensation_obj.delete_oipl_for_step
199: (p_grade_id => l_grade_id

Line 206: hr_utility.trace('pqh_gsp_sync_compensation_obj.delete_oipl_for_step : '

202: ,p_effective_date => p_effective_date
203: ,p_datetrack_mode => p_datetrack_mode
204: );
205: --
206: hr_utility.trace('pqh_gsp_sync_compensation_obj.delete_oipl_for_step : '
207: || l_return);
208: if l_return <> 'SUCCESS' Then
209: l_message := fnd_message.get;
210: hr_utility.trace('error message : ' || l_message);

Line 210: hr_utility.trace('error message : ' || l_message);

206: hr_utility.trace('pqh_gsp_sync_compensation_obj.delete_oipl_for_step : '
207: || l_return);
208: if l_return <> 'SUCCESS' Then
209: l_message := fnd_message.get;
210: hr_utility.trace('error message : ' || l_message);
211: fnd_message.set_name('PER','HR_289570_DEL_OPTION_IN_PLAN');
212: if l_message is not null then
213: fnd_message.set_token('ERR_CODE',l_message);
214: else

Line 247: hr_utility.set_location(' Leaving:'||l_proc, 10);

243: Else
244: p_rec.effective_start_date := null;
245: p_rec.effective_end_date := null;
246: End If;
247: hr_utility.set_location(' Leaving:'||l_proc, 10);
248: End dt_pre_delete;
249: --
250: -- ----------------------------------------------------------------------------
251: -- |------------------------------< pre_delete >------------------------------|

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

292: --
293: --
294: --
295: Begin
296: hr_utility.set_location('Entering:'||l_proc, 5);
297: --
298: --
299: --
300: per_sps_del.dt_pre_delete

Line 308: hr_utility.set_location(' Leaving:'||l_proc, 10);

304: ,p_validation_start_date => p_validation_start_date
305: ,p_validation_end_date => p_validation_end_date
306: );
307: --
308: hr_utility.set_location(' Leaving:'||l_proc, 10);
309: End pre_delete;
310: --
311: -- ----------------------------------------------------------------------------
312: -- |----------------------------< post_delete >-------------------------------|

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

350: --
351: l_proc varchar2(72) := g_package||'post_delete';
352: --
353: Begin
354: hr_utility.set_location('Entering:'||l_proc, 5);
355: begin
356: --
357: per_sps_rkd.after_delete
358: (p_effective_date

Line 468: hr_utility.set_location(' Leaving:'||l_proc, 10);

464: ,p_hook_type => 'AD');
465: --
466: end;
467: --
468: hr_utility.set_location(' Leaving:'||l_proc, 10);
469: End post_delete;
470: --
471: -- ----------------------------------------------------------------------------
472: -- |---------------------------------< del >----------------------------------|

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

482: l_validation_start_date date;
483: l_validation_end_date date;
484: --
485: Begin
486: hr_utility.set_location('Entering:' || l_proc, 10);
487: --
488: -- Ensure that the DateTrack delete mode is valid
489: --
490: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);

Line 557: hr_utility.set_location(' Leaving:' || l_proc, 20);

553: --
554: -- Call to raise any errors on multi-message list
555: hr_multi_message.end_validation_set;
556: --
557: hr_utility.set_location(' Leaving:' || l_proc, 20);
558: End del;
559: --
560: -- ----------------------------------------------------------------------------
561: -- |--------------------------------< del >-----------------------------------|

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

573: l_rec per_sps_shd.g_rec_type;
574: l_proc varchar2(72) := g_package||'del';
575: --
576: Begin
577: hr_utility.set_location('Entering:' || l_proc, 5);
578: --
579: -- As the delete procedure accepts a plsql record structure we do need to
580: -- convert the arguments into the record structure.
581: -- We don't need to call the supplied conversion argument routine as we

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

601: p_object_version_number := l_rec.object_version_number;
602: p_effective_start_date := l_rec.effective_start_date;
603: p_effective_end_date := l_rec.effective_end_date;
604: --
605: hr_utility.set_location(' Leaving:' || l_proc, 10);
606: End del;
607: --
608: end per_sps_del;