eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PDP_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 145: hr_utility.set_location(' Leaving:'||l_proc, 15);

141: p_rec.effective_start_date := p_validation_start_date;
142: p_rec.effective_end_date := p_validation_end_date;
143: End If;
144: --
145: hr_utility.set_location(' Leaving:'||l_proc, 15);
146: Exception
147: When hr_api.check_integrity_violated Then
148: -- A check constraint has been violated
149: ben_pdp_shd.g_api_dml := false; -- Unset the api dml status

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

199: --
200: l_proc varchar2(72) := g_package||'update_dml';
201: --
202: Begin
203: hr_utility.set_location('Entering:'||l_proc, 5);
204: --
205: dt_update_dml(p_rec => p_rec,
206: p_effective_date => p_effective_date,
207: p_datetrack_mode => p_datetrack_mode,

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

207: p_datetrack_mode => p_datetrack_mode,
208: p_validation_start_date => p_validation_start_date,
209: p_validation_end_date => p_validation_end_date);
210: --
211: hr_utility.set_location(' Leaving:'||l_proc, 10);
212: End update_dml;
213: --
214: -- ----------------------------------------------------------------------------
215: -- |----------------------------< dt_pre_update >-----------------------------|

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

264: l_proc varchar2(72) := g_package||'dt_pre_update';
265: l_dummy_version_number number;
266: --
267: Begin
268: hr_utility.set_location('Entering:'||l_proc, 5);
269: If (p_datetrack_mode <> 'CORRECTION') then
270: hr_utility.set_location(l_proc, 10);
271: --
272: -- Update the current effective end date

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

266: --
267: Begin
268: hr_utility.set_location('Entering:'||l_proc, 5);
269: If (p_datetrack_mode <> 'CORRECTION') then
270: hr_utility.set_location(l_proc, 10);
271: --
272: -- Update the current effective end date
273: --
274: ben_pdp_shd.upd_effective_end_date

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

279: p_validation_end_date => p_validation_end_date,
280: p_object_version_number => l_dummy_version_number);
281: --
282: If (p_datetrack_mode = 'UPDATE_OVERRIDE') then
283: hr_utility.set_location(l_proc, 15);
284: --
285: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
286: -- delete any future rows
287: --

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

291: p_datetrack_mode => p_datetrack_mode,
292: p_validation_start_date => p_validation_start_date,
293: p_validation_end_date => p_validation_end_date);
294: End If;
295: hr_utility.set_location(l_proc, 20);
296: --
297: -- We must now insert the updated row
298: --
299: ben_pdp_ins.insert_dml

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

302: p_datetrack_mode => p_datetrack_mode,
303: p_validation_start_date => p_validation_start_date,
304: p_validation_end_date => p_validation_end_date);
305: End If;
306: hr_utility.set_location(' Leaving:'||l_proc, 20);
307: End dt_pre_update;
308: --
309: -- ----------------------------------------------------------------------------
310: -- |------------------------------< pre_update >------------------------------|

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

365: and p_effective_date -1 between
366: effective_start_date and effective_end_date;
367: --
368: Begin
369: hr_utility.set_location('Entering:'||l_proc, 5);
370: --
371: --
372: --
373: dt_pre_update

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

376: p_datetrack_mode => p_datetrack_mode,
377: p_validation_start_date => p_validation_start_date,
378: p_validation_end_date => p_validation_end_date);
379: --
380: hr_utility.set_location(' Leaving:'||l_proc, 10);
381: --
382: if p_datetrack_mode <> 'CORRECTION' then
383: open csr_rowid_u;
384: fetch csr_rowid_u into l_rowid;

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

390: fetch csr_rowid into l_rowid, l_esd, l_eed;
391: close csr_rowid;
392: end if;
393: --
394: hr_utility.set_location(' pdp rhi esd:'||p_rec.effective_start_date, 10);
395: hr_utility.set_location(' pdp rhi eed:'||p_rec.effective_end_date, 10);
396: hr_utility.set_location(' pdp rhi l_esd:'||l_esd, 10);
397: hr_utility.set_location(' pdp rhi l_eed:'||l_eed, 10);
398: --

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

391: close csr_rowid;
392: end if;
393: --
394: hr_utility.set_location(' pdp rhi esd:'||p_rec.effective_start_date, 10);
395: hr_utility.set_location(' pdp rhi eed:'||p_rec.effective_end_date, 10);
396: hr_utility.set_location(' pdp rhi l_esd:'||l_esd, 10);
397: hr_utility.set_location(' pdp rhi l_eed:'||l_eed, 10);
398: --
399: --Bug 4390330 fix

Line 396: hr_utility.set_location(' pdp rhi l_esd:'||l_esd, 10);

392: end if;
393: --
394: hr_utility.set_location(' pdp rhi esd:'||p_rec.effective_start_date, 10);
395: hr_utility.set_location(' pdp rhi eed:'||p_rec.effective_end_date, 10);
396: hr_utility.set_location(' pdp rhi l_esd:'||l_esd, 10);
397: hr_utility.set_location(' pdp rhi l_eed:'||l_eed, 10);
398: --
399: --Bug 4390330 fix
400: --

Line 397: hr_utility.set_location(' pdp rhi l_eed:'||l_eed, 10);

393: --
394: hr_utility.set_location(' pdp rhi esd:'||p_rec.effective_start_date, 10);
395: hr_utility.set_location(' pdp rhi eed:'||p_rec.effective_end_date, 10);
396: hr_utility.set_location(' pdp rhi l_esd:'||l_esd, 10);
397: hr_utility.set_location(' pdp rhi l_eed:'||l_eed, 10);
398: --
399: --Bug 4390330 fix
400: --
401: ben_dt_trgr_handle.elig_cvrd_dpnt

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

455: --
456: l_proc varchar2(72) := g_package||'post_update';
457: --
458: Begin
459: hr_utility.set_location('Entering:'||l_proc, 5);
460: --
461: -- Bug 3756863 : Moved here from UPDATE_VALIDATE
462: ben_pdp_bus.crt_ordr_warning
463: (p_prtt_enrt_rslt_id => p_rec.prtt_enrt_rslt_id,

Line 470: hr_utility.set_location('new update in update rhi :'||l_proc, 5);

466: --
467: -- Start of API User Hook for post_update.
468: --
469: if p_rec.cvg_strt_dt > p_rec.cvg_thru_dt then
470: hr_utility.set_location('new update in update rhi :'||l_proc, 5);
471: update ben_elig_dpnt
472: set elig_cvrd_dpnt_id = null
473: where elig_cvrd_dpnt_id = p_rec.elig_cvrd_dpnt_id
474: and dpnt_person_id = p_rec.dpnt_person_id

Line 476: hr_utility.set_location('rowcount in update rhi :'||sql%rowcount, 5);

472: set elig_cvrd_dpnt_id = null
473: where elig_cvrd_dpnt_id = p_rec.elig_cvrd_dpnt_id
474: and dpnt_person_id = p_rec.dpnt_person_id
475: and per_in_ler_id = p_rec.per_in_ler_id;
476: hr_utility.set_location('rowcount in update rhi :'||sql%rowcount, 5);
477: end if;
478:
479:
480: begin

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

594: --
595: -- End of API User Hook for post_update.
596: --
597: --
598: hr_utility.set_location(' Leaving:'||l_proc, 10);
599: End post_update;
600: --
601: -- ----------------------------------------------------------------------------
602: -- |-----------------------------< convert_defs >-----------------------------|

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

646: l_proc varchar2(72) := g_package||'convert_defs';
647: --
648: Begin
649: --
650: hr_utility.set_location('Entering:'||l_proc, 5);
651: --
652: -- We must now examine each argument value in the
653: -- p_rec plsql record structure
654: -- to see if a system default is being used. If a system default

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

830: p_rec.ovrdn_thru_dt :=
831: ben_pdp_shd.g_old_rec.ovrdn_thru_dt;
832: End If;
833: --
834: hr_utility.set_location(' Leaving:'||l_proc, 10);
835: --
836: End convert_defs;
837: --
838: -- ----------------------------------------------------------------------------

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

849: l_validation_start_date date;
850: l_validation_end_date date;
851: --
852: Begin
853: hr_utility.set_location('Entering:'||l_proc, 5);
854: --
855: -- Ensure that the DateTrack update mode is valid
856: --
857: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);

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

968: l_rec ben_pdp_shd.g_rec_type;
969: l_proc varchar2(72) := g_package||'upd';
970: --
971: Begin
972: hr_utility.set_location('Entering:'||l_proc, 5);
973: --
974: -- Call conversion function to turn arguments into the
975: -- l_rec structure.
976: --

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

1036: p_effective_start_date := l_rec.effective_start_date;
1037: p_effective_end_date := l_rec.effective_end_date;
1038: --
1039: --
1040: hr_utility.set_location(' Leaving:'||l_proc, 10);
1041: End upd;
1042: --
1043: end ben_pdp_upd;