DBA Data[Home] [Help]

APPS.PAY_PPM_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_ppm_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_ppm_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_ppm_shd.g_api_dml := false; -- Unset the api dml status
76: Else
77: hr_utility.set_location(l_proc, 15);
78: pay_ppm_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 93: hr_utility.set_location(' Leaving:'||l_proc, 20);

89: --
90: -- If we are doing a 'ZAP' then we must set the effective start and end
91: -- dates to null
92: --
93: hr_utility.set_location(' Leaving:'||l_proc, 20);
94: --
95: Exception
96: When Others Then
97: pay_ppm_shd.g_api_dml := false; -- Unset the api dml status

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

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

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

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

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

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

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

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

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

258: or t2.effective_end_date < p_validation_start_date));
259: --
260: --
261: Begin
262: hr_utility.set_location('Entering:'||l_proc, 5);
263: --
264: -- Bug 9358415-- Only delete comments when datetrack mode is ZAP
265: -- Delete any possible comments
266: --

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

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

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

321: --
322: l_proc varchar2(72) := g_package||'post_delete';
323: --
324: Begin
325: hr_utility.set_location('Entering:'||l_proc, 5);
326: --
327: -- Start of API User Hook for post_delete.
328: begin
329: pay_ppm_rkd.after_delete

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

474: );
475: end;
476: -- End of API User Hook for post_delete.
477: --
478: hr_utility.set_location(' Leaving:'||l_proc, 10);
479: End post_delete;
480: --
481: -- ----------------------------------------------------------------------------
482: -- |---------------------------------< del >----------------------------------|

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

493: l_validation_start_date date;
494: l_validation_end_date date;
495: --
496: Begin
497: hr_utility.set_location('Entering:'||l_proc, 5);
498: --
499: -- Ensure that the DateTrack delete mode is valid
500: --
501: dt_api.validate_dt_del_mode(p_datetrack_mode => p_datetrack_mode);

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

581: If p_validate then
582: Raise HR_Api.Validate_Enabled;
583: End If;
584: --
585: hr_utility.set_location(' Leaving:'||l_proc, 10);
586: Exception
587: When HR_Api.Validate_Enabled Then
588: --
589: -- As the Validate_Enabled exception has been raised

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

609: l_rec pay_ppm_shd.g_rec_type;
610: l_proc varchar2(72) := g_package||'del';
611: --
612: Begin
613: hr_utility.set_location('Entering:'||l_proc, 5);
614: --
615: -- As the delete procedure accepts a plsql record structure we do need to
616: -- convert the arguments into the record structure.
617: -- We don't need to call the supplied conversion argument routine as we

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

631: p_object_version_number := l_rec.object_version_number;
632: p_effective_start_date := l_rec.effective_start_date;
633: p_effective_end_date := l_rec.effective_end_date;
634: --
635: hr_utility.set_location(' Leaving:'||l_proc, 10);
636: End del;
637: --
638: end pay_ppm_del;