DBA Data[Home] [Help]

APPS.PAY_OPM_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: pay_opm_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: pay_opm_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: pay_opm_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: pay_opm_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 169: hr_utility.set_location('Entering:'||l_proc, 5);

165: --
166: l_proc varchar2(72) := g_package||'dt_pre_delete';
167: --
168: Begin
169: hr_utility.set_location('Entering:'||l_proc, 5);
170: --
171: If (p_datetrack_mode <> hr_api.g_zap) then
172: --
173: p_rec.effective_start_date

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

192: Else
193: p_rec.effective_start_date := null;
194: p_rec.effective_end_date := null;
195: End If;
196: hr_utility.set_location(' Leaving:'||l_proc, 10);
197: End dt_pre_delete;
198: --
199: -- ----------------------------------------------------------------------------
200: -- |------------------------------< pre_delete >------------------------------|

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

257: or t2.effective_end_date < p_validation_start_date));
258: --
259: --
260: Begin
261: hr_utility.set_location('Entering:'||l_proc, 5);
262: --
263: --
264: -- Delete any possible comments
265: --

Line 266: hr_utility.set_location('Start:'||to_char(p_validation_start_date),6);

262: --
263: --
264: -- Delete any possible comments
265: --
266: hr_utility.set_location('Start:'||to_char(p_validation_start_date),6);
267: hr_utility.set_location('End:'||to_char(p_validation_end_date),7);
268: --
269: For Comm_Del In C_Sel1 Loop
270: hr_utility.set_location('Comment ID:'||Comm_Del.comment_id,7);

Line 267: hr_utility.set_location('End:'||to_char(p_validation_end_date),7);

263: --
264: -- Delete any possible comments
265: --
266: hr_utility.set_location('Start:'||to_char(p_validation_start_date),6);
267: hr_utility.set_location('End:'||to_char(p_validation_end_date),7);
268: --
269: For Comm_Del In C_Sel1 Loop
270: hr_utility.set_location('Comment ID:'||Comm_Del.comment_id,7);
271: hr_comm_api.del(p_comment_id => Comm_Del.comment_id);

Line 270: hr_utility.set_location('Comment ID:'||Comm_Del.comment_id,7);

266: hr_utility.set_location('Start:'||to_char(p_validation_start_date),6);
267: hr_utility.set_location('End:'||to_char(p_validation_end_date),7);
268: --
269: For Comm_Del In C_Sel1 Loop
270: hr_utility.set_location('Comment ID:'||Comm_Del.comment_id,7);
271: hr_comm_api.del(p_comment_id => Comm_Del.comment_id);
272: End Loop;
273: --
274: --

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

279: ,p_validation_start_date => p_validation_start_date
280: ,p_validation_end_date => p_validation_end_date
281: );
282: --
283: hr_utility.set_location(' Leaving:'||l_proc, 10);
284: End pre_delete;
285: --
286: -- ----------------------------------------------------------------------------
287: -- |----------------------------< post_delete >-------------------------------|

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

325: --
326: l_proc varchar2(72) := g_package||'post_delete';
327: --
328: Begin
329: hr_utility.set_location('Entering:'||l_proc, 5);
330: begin
331: --
332: pay_opm_rkd.after_delete
333: (p_effective_date

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

471: ,p_hook_type => 'AD');
472: --
473: end;
474: --
475: hr_utility.set_location(' Leaving:'||l_proc, 10);
476: End post_delete;
477: --
478: -- ----------------------------------------------------------------------------
479: -- |---------------------------------< del >----------------------------------|

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

488: l_validation_start_date date;
489: l_validation_end_date date;
490: --
491: Begin
492: hr_utility.set_location('Entering:'||l_proc, 5);
493: --
494: -- Ensure that the DateTrack delete mode is valid
495: --
496: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);

Line 548: hr_utility.set_location(' Leaving:'||l_proc, 5);

544: ,p_validation_start_date => l_validation_start_date
545: ,p_validation_end_date => l_validation_end_date
546: );
547: --
548: hr_utility.set_location(' Leaving:'||l_proc, 5);
549: End del;
550: --
551: -- ----------------------------------------------------------------------------
552: -- |--------------------------------< del >-----------------------------------|

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

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

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

608: p_object_version_number := l_rec.object_version_number;
609: p_effective_start_date := l_rec.effective_start_date;
610: p_effective_end_date := l_rec.effective_end_date;
611: --
612: hr_utility.set_location(' Leaving:'||l_proc, 10);
613: End del;
614: --
615: end pay_opm_del;