DBA Data[Home] [Help]

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

165: p_rec.effective_start_date := p_validation_start_date;
166: p_rec.effective_end_date := p_validation_end_date;
167: End If;
168: --
169: hr_utility.set_location(' Leaving:'||l_proc, 15);
170: Exception
171: When hr_api.check_integrity_violated Then
172: -- A check constraint has been violated
173: ben_pen_shd.g_api_dml := false; -- Unset the api dml status

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

223: --
224: l_proc varchar2(72) := g_package||'update_dml';
225: --
226: Begin
227: hr_utility.set_location('Entering:'||l_proc, 5);
228: --
229: dt_update_dml(p_rec => p_rec,
230: p_effective_date => p_effective_date,
231: p_datetrack_mode => p_datetrack_mode,

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

231: p_datetrack_mode => p_datetrack_mode,
232: p_validation_start_date => p_validation_start_date,
233: p_validation_end_date => p_validation_end_date);
234: --
235: hr_utility.set_location(' Leaving:'||l_proc, 10);
236: End update_dml;
237: --
238: -- ----------------------------------------------------------------------------
239: -- |----------------------------< dt_pre_update >-----------------------------|

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

288: l_proc varchar2(72) := g_package||'dt_pre_update';
289: l_dummy_version_number number;
290: --
291: Begin
292: hr_utility.set_location('Entering:'||l_proc, 5);
293: If (p_datetrack_mode <> 'CORRECTION') then
294: hr_utility.set_location(l_proc, 10);
295: --
296: -- Update the current effective end date

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

290: --
291: Begin
292: hr_utility.set_location('Entering:'||l_proc, 5);
293: If (p_datetrack_mode <> 'CORRECTION') then
294: hr_utility.set_location(l_proc, 10);
295: --
296: -- Update the current effective end date
297: --
298: -- 3843657: When PEN record is date-track VOID-ed,

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

323: --
324: end if;
325: --
326: If (p_datetrack_mode = 'UPDATE_OVERRIDE') then
327: hr_utility.set_location(l_proc, 15);
328: --
329: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
330: -- delete any future rows
331: --

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

335: p_datetrack_mode => p_datetrack_mode,
336: p_validation_start_date => p_validation_start_date,
337: p_validation_end_date => p_validation_end_date);
338: End If;
339: hr_utility.set_location(l_proc, 20);
340: --
341: -- We must now insert the updated row
342: --
343: ben_pen_ins.insert_dml

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

346: p_datetrack_mode => p_datetrack_mode,
347: p_validation_start_date => p_validation_start_date,
348: p_validation_end_date => p_validation_end_date);
349: End If;
350: hr_utility.set_location(' Leaving:'||l_proc, 20);
351: End dt_pre_update;
352: --
353: -- ----------------------------------------------------------------------------
354: -- |------------------------------< pre_update >------------------------------|

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

417: and p_effective_date -1 between
418: effective_start_date and effective_end_date;
419: --
420: Begin
421: hr_utility.set_location('Entering:'||l_proc, 5);
422:
423: if p_rec.enrt_cvg_strt_dt >
424: nvl(p_rec.enrt_cvg_thru_dt, p_rec.enrt_cvg_strt_dt)
425: and NVL(p_rec.prtt_enrt_rslt_stat_cd,'VOIDD') <> 'BCKDT' then -- BUG 4739922 / 5360430

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

461: fetch csr_rowid into l_rowid, l_esd, l_eed;
462: close csr_rowid;
463: end if;
464: --
465: hr_utility.set_location(' pen rhi esd:'||p_rec.effective_start_date, 10);
466: hr_utility.set_location(' pen rhi eed:'||p_rec.effective_end_date, 10);
467: hr_utility.set_location(' pen rhi l_esd:'||l_esd, 10);
468: hr_utility.set_location(' pen rhi l_eed:'||l_eed, 10);
469:

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

462: close csr_rowid;
463: end if;
464: --
465: hr_utility.set_location(' pen rhi esd:'||p_rec.effective_start_date, 10);
466: hr_utility.set_location(' pen rhi eed:'||p_rec.effective_end_date, 10);
467: hr_utility.set_location(' pen rhi l_esd:'||l_esd, 10);
468: hr_utility.set_location(' pen rhi l_eed:'||l_eed, 10);
469:
470: ben_dt_trgr_handle.prtt_enrt_rslt

Line 467: hr_utility.set_location(' pen rhi l_esd:'||l_esd, 10);

463: end if;
464: --
465: hr_utility.set_location(' pen rhi esd:'||p_rec.effective_start_date, 10);
466: hr_utility.set_location(' pen rhi eed:'||p_rec.effective_end_date, 10);
467: hr_utility.set_location(' pen rhi l_esd:'||l_esd, 10);
468: hr_utility.set_location(' pen rhi l_eed:'||l_eed, 10);
469:
470: ben_dt_trgr_handle.prtt_enrt_rslt
471: (p_rowid => l_rowid

Line 468: hr_utility.set_location(' pen rhi l_eed:'||l_eed, 10);

464: --
465: hr_utility.set_location(' pen rhi esd:'||p_rec.effective_start_date, 10);
466: hr_utility.set_location(' pen rhi eed:'||p_rec.effective_end_date, 10);
467: hr_utility.set_location(' pen rhi l_esd:'||l_esd, 10);
468: hr_utility.set_location(' pen rhi l_eed:'||l_eed, 10);
469:
470: ben_dt_trgr_handle.prtt_enrt_rslt
471: (p_rowid => l_rowid
472: ,p_prtt_enrt_rslt_id => p_rec.prtt_enrt_rslt_id

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

478: ,p_effective_start_date => l_esd
479: ,p_effective_end_date => l_eed
480: );
481:
482: hr_utility.set_location(' Leaving:'||l_proc, 10);
483: End pre_update;
484: --
485: -- ----------------------------------------------------------------------------
486: -- |-----------------------------< post_update >------------------------------|

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

523: --
524: l_proc varchar2(72) := g_package||'post_update';
525: --
526: Begin
527: hr_utility.set_location('Entering:'||l_proc, 5);
528: --
529: --
530: -- Start of API User Hook for post_update.
531: --

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

690: --
691: -- End of API User Hook for post_update.
692: --
693: --
694: hr_utility.set_location(' Leaving:'||l_proc, 10);
695: End post_update;
696: --
697: -- ----------------------------------------------------------------------------
698: -- |-----------------------------< convert_defs >-----------------------------|

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

742: l_proc varchar2(72) := g_package||'convert_defs';
743: --
744: Begin
745: --
746: hr_utility.set_location('Entering:'||l_proc, 5);
747: --
748: -- We must now examine each argument value in the
749: -- p_rec plsql record structure
750: -- to see if a system default is being used. If a system default

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

1023: ben_pen_shd.g_old_rec.comp_lvl_cd;
1024: End If;
1025:
1026: --
1027: hr_utility.set_location(' Leaving:'||l_proc, 10);
1028: --
1029: End convert_defs;
1030: --
1031: -- ----------------------------------------------------------------------------

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

1042: l_validation_start_date date;
1043: l_validation_end_date date;
1044: --
1045: Begin
1046: hr_utility.set_location('Entering:'||l_proc, 5);
1047: --
1048: -- Ensure that the DateTrack update mode is valid
1049: --
1050: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);

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

1115: -- DBI - Added DBI Event Logging Hooks
1116: /* Commented. Need to uncomment when DBI goes into mainline
1117: 5554590 : Enabled DBI logging into mainline */
1118: if HRI_BPL_BEN_UTIL.enable_ben_col_evt_que then
1119: hr_utility.set_location(' Logging PEN update event'||l_proc, 5);
1120: hri_opl_ben_elig_enrl_eq.update_event (
1121: p_rec => p_rec ,
1122: p_effective_date => p_effective_date,
1123: p_datetrack_mode => p_datetrack_mode );

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

1209: l_rec ben_pen_shd.g_rec_type;
1210: l_proc varchar2(72) := g_package||'upd';
1211: --
1212: Begin
1213: hr_utility.set_location('Entering:'||l_proc, 5);
1214: --
1215: -- Call conversion function to turn arguments into the
1216: -- l_rec structure.
1217: --

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

1301: p_effective_start_date := l_rec.effective_start_date;
1302: p_effective_end_date := l_rec.effective_end_date;
1303: --
1304: --
1305: hr_utility.set_location(' Leaving:'||l_proc, 10);
1306: End upd;
1307: --
1308: end ben_pen_upd;