DBA Data[Home] [Help]

APPS.BEN_PEN_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: ben_pen_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: ben_pen_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: ben_pen_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: ben_pen_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 90: hr_utility.set_location(' Leaving:'||l_proc, 20);

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

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

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

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

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

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

161: --
162: l_proc varchar2(72) := g_package||'dt_pre_delete';
163: --
164: Begin
165: hr_utility.set_location('Entering:'||l_proc, 5);
166: --
167: If (p_datetrack_mode <> 'ZAP') then
168: --
169: p_rec.effective_start_date := ben_pen_shd.g_old_rec.effective_start_date;

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

186: Else
187: p_rec.effective_start_date := null;
188: p_rec.effective_end_date := null;
189: End If;
190: hr_utility.set_location(' Leaving:'||l_proc, 10);
191: End dt_pre_delete;
192: --
193: -- ----------------------------------------------------------------------------
194: -- |------------------------------< pre_delete >------------------------------|

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

234: --
235: --
236: --
237: Begin
238: hr_utility.set_location('Entering:'||l_proc, 5);
239: --
240: --
241: --
242: dt_pre_delete

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

245: p_datetrack_mode => p_datetrack_mode,
246: p_validation_start_date => p_validation_start_date,
247: p_validation_end_date => p_validation_end_date);
248: --
249: hr_utility.set_location(' Leaving:'||l_proc, 10);
250: End pre_delete;
251: --
252: -- ----------------------------------------------------------------------------
253: -- |-----------------------------< post_delete >------------------------------|

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

290: --
291: l_proc varchar2(72) := g_package||'post_delete';
292: --
293: Begin
294: hr_utility.set_location('Entering:'||l_proc, 5);
295: --
296: --
297: -- Start of API User Hook for post_delete.
298: --

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

391: --
392: -- End of API User Hook for post_delete.
393: --
394: --
395: hr_utility.set_location(' Leaving:'||l_proc, 10);
396: End post_delete;
397: --
398: -- ----------------------------------------------------------------------------
399: -- |---------------------------------< del >----------------------------------|

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

409: l_validation_start_date date;
410: l_validation_end_date date;
411: --
412: Begin
413: hr_utility.set_location('Entering:'||l_proc, 5);
414: --
415: -- Ensure that the DateTrack delete mode is valid
416: --
417: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);

Line 483: hr_utility.set_location('Logging PEN delete event'||l_proc, 5);

479: /* Commented. Need to uncomment when DBI goes into mainline
480: 5554590 : Enabled DBI logging into mainline */
481: -- Bug 12939188
482: /* if HRI_BPL_BEN_UTIL.enable_ben_col_evt_que then
483: hr_utility.set_location('Logging PEN delete event'||l_proc, 5);
484: hri_opl_ben_elig_enrl_eq.delete_event (
485: p_rec => ben_pen_shd.g_old_rec ,
486: p_effective_date => p_effective_date,
487: p_datetrack_mode => p_datetrack_mode );

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

505: l_rec ben_pen_shd.g_rec_type;
506: l_proc varchar2(72) := g_package||'del';
507: --
508: Begin
509: hr_utility.set_location('Entering:'||l_proc, 5);
510: --
511: -- As the delete procedure accepts a plsql record structure we do need to
512: -- convert the arguments into the record structure.
513: -- We don't need to call the supplied conversion argument routine as we

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

527: p_object_version_number := l_rec.object_version_number;
528: p_effective_start_date := l_rec.effective_start_date;
529: p_effective_end_date := l_rec.effective_end_date;
530: --
531: hr_utility.set_location(' Leaving:'||l_proc, 10);
532: End del;
533: --
534: end ben_pen_del;