DBA Data[Home] [Help]

APPS.PAY_GRR_DEL dependencies on HR_UTILITY

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

59: --
60: l_proc varchar2(72) := g_package||'dt_delete_dml';
61: --
62: Begin
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
65: hr_utility.set_location(l_proc, 10);
66: pay_grr_shd.g_api_dml := true; -- Set the api dml status
67: --

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

61: --
62: Begin
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: If (p_datetrack_mode = 'DELETE_NEXT_CHANGE') then
65: hr_utility.set_location(l_proc, 10);
66: pay_grr_shd.g_api_dml := true; -- Set the api dml status
67: --
68: -- Delete the where the effective start date is equal
69: -- to the validation end date.

Line 77: hr_utility.set_location(l_proc, 15);

73: and effective_start_date = p_validation_start_date;
74: --
75: pay_grr_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: pay_grr_shd.g_api_dml := true; -- Set the api dml status
79: --
80: -- Delete the row(s) where the effective start date is greater than
81: -- or equal to the validation start date.

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

92: -- Moved 'ZAP' effective_[start|end]_date processing to dt_pre_delete.
93: --
94: -- 40.1 change a end.
95: --
96: hr_utility.set_location(' Leaving:'||l_proc, 20);
97: --
98: Exception
99: When Others Then
100: pay_grr_shd.g_api_dml := false; -- Unset the api dml status

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

113: --
114: l_proc varchar2(72) := g_package||'delete_dml';
115: --
116: Begin
117: hr_utility.set_location('Entering:'||l_proc, 5);
118: --
119: dt_delete_dml(p_rec => p_rec,
120: p_effective_date => p_effective_date,
121: p_datetrack_mode => p_datetrack_mode,

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

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

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

167: --
168: l_proc varchar2(72) := g_package||'dt_pre_delete';
169: --
170: Begin
171: hr_utility.set_location('Entering:'||l_proc, 5);
172: --
173: If (p_datetrack_mode <> 'ZAP') then
174: --
175: --

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

203: --
204: -- 40.1 change a end.
205: --
206: End If;
207: hr_utility.set_location(' Leaving:'||l_proc, 10);
208: End dt_pre_delete;
209: --
210: -- ----------------------------------------------------------------------------
211: -- |------------------------------< pre_delete >------------------------------|

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

251: --
252: --
253: --
254: Begin
255: hr_utility.set_location('Entering:'||l_proc, 5);
256: --
257: --
258: --
259: dt_pre_delete

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

262: p_datetrack_mode => p_datetrack_mode,
263: p_validation_start_date => p_validation_start_date,
264: p_validation_end_date => p_validation_end_date);
265: --
266: hr_utility.set_location(' Leaving:'||l_proc, 10);
267: End pre_delete;
268: --
269: -- ----------------------------------------------------------------------------
270: -- |-----------------------------< post_delete >------------------------------|

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

307: --
308: l_proc varchar2(72) := g_package||'post_delete';
309: --
310: Begin
311: hr_utility.set_location('Entering:'||l_proc, 5);
312: --
313: hr_utility.set_location(' Leaving:'||l_proc, 10);
314: End post_delete;
315: --

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

309: --
310: Begin
311: hr_utility.set_location('Entering:'||l_proc, 5);
312: --
313: hr_utility.set_location(' Leaving:'||l_proc, 10);
314: End post_delete;
315: --
316: -- ----------------------------------------------------------------------------
317: -- |---------------------------------< del >----------------------------------|

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

328: l_validation_start_date date;
329: l_validation_end_date date;
330: --
331: Begin
332: hr_utility.set_location('Entering:'||l_proc, 5);
333: --
334: -- Ensure that the DateTrack delete mode is valid
335: --
336: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);

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

395: If p_validate then
396: Raise HR_Api.Validate_Enabled;
397: End If;
398: --
399: hr_utility.set_location(' Leaving:'||l_proc, 10);
400: Exception
401: When HR_Api.Validate_Enabled Then
402: --
403: -- As the Validate_Enabled exception has been raised

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

423: l_rec pay_grr_shd.g_rec_type;
424: l_proc varchar2(72) := g_package||'del';
425: --
426: Begin
427: hr_utility.set_location('Entering:'||l_proc, 5);
428: --
429: -- As the delete procedure accepts a plsql record structure we do need to
430: -- convert the arguments into the record structure.
431: -- We don't need to call the supplied conversion argument routine as we

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

445: p_object_version_number := l_rec.object_version_number;
446: p_effective_start_date := l_rec.effective_start_date;
447: p_effective_end_date := l_rec.effective_end_date;
448: --
449: hr_utility.set_location(' Leaving:'||l_proc, 10);
450: End del;
451: --
452: end pay_grr_del;