DBA Data[Home] [Help]

APPS.BEN_PBB_UPD dependencies on HR_UTILITY

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

63: --
64: l_proc varchar2(72) := g_package||'dt_update_dml';
65: --
66: Begin
67: hr_utility.set_location('Entering:'||l_proc, 5);
68: --
69: If (p_datetrack_mode = 'CORRECTION') then
70: hr_utility.set_location(l_proc, 10);
71: --

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

66: Begin
67: hr_utility.set_location('Entering:'||l_proc, 5);
68: --
69: If (p_datetrack_mode = 'CORRECTION') then
70: hr_utility.set_location(l_proc, 10);
71: --
72: -- Because we are updating a row we must get the next object
73: -- version number.
74: --

Line 136: hr_utility.set_location(' Leaving:'||l_proc, 15);

132: p_rec.effective_start_date := p_validation_start_date;
133: p_rec.effective_end_date := p_validation_end_date;
134: End If;
135: --
136: hr_utility.set_location(' Leaving:'||l_proc, 15);
137: Exception
138: When hr_api.check_integrity_violated Then
139: -- A check constraint has been violated
140: ben_pbb_shd.g_api_dml := false; -- Unset the api dml status

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

190: --
191: l_proc varchar2(72) := g_package||'update_dml';
192: --
193: Begin
194: hr_utility.set_location('Entering:'||l_proc, 5);
195: --
196: dt_update_dml(p_rec => p_rec,
197: p_effective_date => p_effective_date,
198: p_datetrack_mode => p_datetrack_mode,

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

198: p_datetrack_mode => p_datetrack_mode,
199: p_validation_start_date => p_validation_start_date,
200: p_validation_end_date => p_validation_end_date);
201: --
202: hr_utility.set_location(' Leaving:'||l_proc, 10);
203: End update_dml;
204: --
205: -- ----------------------------------------------------------------------------
206: -- |----------------------------< dt_pre_update >-----------------------------|

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

255: l_proc varchar2(72) := g_package||'dt_pre_update';
256: l_dummy_version_number number;
257: --
258: Begin
259: hr_utility.set_location('Entering:'||l_proc, 5);
260: If (p_datetrack_mode <> 'CORRECTION') then
261: hr_utility.set_location(l_proc, 10);
262: --
263: -- Update the current effective end date

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

257: --
258: Begin
259: hr_utility.set_location('Entering:'||l_proc, 5);
260: If (p_datetrack_mode <> 'CORRECTION') then
261: hr_utility.set_location(l_proc, 10);
262: --
263: -- Update the current effective end date
264: --
265: ben_pbb_shd.upd_effective_end_date

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

270: p_validation_end_date => p_validation_end_date,
271: p_object_version_number => l_dummy_version_number);
272: --
273: If (p_datetrack_mode = 'UPDATE_OVERRIDE') then
274: hr_utility.set_location(l_proc, 15);
275: --
276: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
277: -- delete any future rows
278: --

Line 286: hr_utility.set_location(l_proc, 20);

282: p_datetrack_mode => p_datetrack_mode,
283: p_validation_start_date => p_validation_start_date,
284: p_validation_end_date => p_validation_end_date);
285: End If;
286: hr_utility.set_location(l_proc, 20);
287: --
288: -- We must now insert the updated row
289: --
290: ben_pbb_ins.insert_dml

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

293: p_datetrack_mode => p_datetrack_mode,
294: p_validation_start_date => p_validation_start_date,
295: p_validation_end_date => p_validation_end_date);
296: End If;
297: hr_utility.set_location(' Leaving:'||l_proc, 20);
298: End dt_pre_update;
299: --
300: -- ----------------------------------------------------------------------------
301: -- |------------------------------< pre_update >------------------------------|

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

356: and p_effective_date -1 between
357: effective_start_date and effective_end_date;
358: --
359: Begin
360: hr_utility.set_location('Entering:'||l_proc, 5);
361: --
362: --
363: --
364: dt_pre_update

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

367: p_datetrack_mode => p_datetrack_mode,
368: p_validation_start_date => p_validation_start_date,
369: p_validation_end_date => p_validation_end_date);
370: --
371: hr_utility.set_location(' Leaving:'||l_proc, 10);
372: --
373: if p_datetrack_mode <> 'CORRECTION' then
374: open csr_rowid_u;
375: fetch csr_rowid_u into l_rowid;

Line 385: hr_utility.set_location(' pbb rhi esd:'||p_rec.effective_start_date, 10);

381: fetch csr_rowid into l_rowid, l_esd, l_eed;
382: close csr_rowid;
383: end if;
384: --
385: hr_utility.set_location(' pbb rhi esd:'||p_rec.effective_start_date, 10);
386: hr_utility.set_location(' pbb rhi eed:'||p_rec.effective_end_date, 10);
387: hr_utility.set_location(' pbb rhi l_esd:'||l_esd, 10);
388: hr_utility.set_location(' pbb rhi l_eed:'||l_eed, 10);
389:

Line 386: hr_utility.set_location(' pbb rhi eed:'||p_rec.effective_end_date, 10);

382: close csr_rowid;
383: end if;
384: --
385: hr_utility.set_location(' pbb rhi esd:'||p_rec.effective_start_date, 10);
386: hr_utility.set_location(' pbb rhi eed:'||p_rec.effective_end_date, 10);
387: hr_utility.set_location(' pbb rhi l_esd:'||l_esd, 10);
388: hr_utility.set_location(' pbb rhi l_eed:'||l_eed, 10);
389:
390: ben_dt_trgr_handle.bnfts_bal

Line 387: hr_utility.set_location(' pbb rhi l_esd:'||l_esd, 10);

383: end if;
384: --
385: hr_utility.set_location(' pbb rhi esd:'||p_rec.effective_start_date, 10);
386: hr_utility.set_location(' pbb rhi eed:'||p_rec.effective_end_date, 10);
387: hr_utility.set_location(' pbb rhi l_esd:'||l_esd, 10);
388: hr_utility.set_location(' pbb rhi l_eed:'||l_eed, 10);
389:
390: ben_dt_trgr_handle.bnfts_bal
391: (p_rowid => l_rowid

Line 388: hr_utility.set_location(' pbb rhi l_eed:'||l_eed, 10);

384: --
385: hr_utility.set_location(' pbb rhi esd:'||p_rec.effective_start_date, 10);
386: hr_utility.set_location(' pbb rhi eed:'||p_rec.effective_end_date, 10);
387: hr_utility.set_location(' pbb rhi l_esd:'||l_esd, 10);
388: hr_utility.set_location(' pbb rhi l_eed:'||l_eed, 10);
389:
390: ben_dt_trgr_handle.bnfts_bal
391: (p_rowid => l_rowid
392: ,p_per_bnfts_bal_id => p_rec.per_bnfts_bal_id

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

441: --
442: l_proc varchar2(72) := g_package||'post_update';
443: --
444: Begin
445: hr_utility.set_location('Entering:'||l_proc, 5);
446: --
447: --
448: -- Start of API User Hook for post_update.
449: --

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

546: --
547: -- End of API User Hook for post_update.
548: --
549: --
550: hr_utility.set_location(' Leaving:'||l_proc, 10);
551: End post_update;
552: --
553: -- ----------------------------------------------------------------------------
554: -- |-----------------------------< convert_defs >-----------------------------|

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

598: l_proc varchar2(72) := g_package||'convert_defs';
599: --
600: Begin
601: --
602: hr_utility.set_location('Entering:'||l_proc, 5);
603: --
604: -- We must now examine each argument value in the
605: -- p_rec plsql record structure
606: -- to see if a system default is being used. If a system default

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

747: ben_pbb_shd.g_old_rec.pbb_attribute30;
748: End If;
749:
750: --
751: hr_utility.set_location(' Leaving:'||l_proc, 10);
752: --
753: End convert_defs;
754: --
755: -- ----------------------------------------------------------------------------

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

766: l_validation_start_date date;
767: l_validation_end_date date;
768: --
769: Begin
770: hr_utility.set_location('Entering:'||l_proc, 5);
771: --
772: -- Ensure that the DateTrack update mode is valid
773: --
774: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);

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

876: l_rec ben_pbb_shd.g_rec_type;
877: l_proc varchar2(72) := g_package||'upd';
878: --
879: Begin
880: hr_utility.set_location('Entering:'||l_proc, 5);
881: --
882: -- Call conversion function to turn arguments into the
883: -- l_rec structure.
884: --

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

935: p_effective_start_date := l_rec.effective_start_date;
936: p_effective_end_date := l_rec.effective_end_date;
937: --
938: --
939: hr_utility.set_location(' Leaving:'||l_proc, 10);
940: End upd;
941: --
942: end ben_pbb_upd;