DBA Data[Home] [Help]

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

203: p_rec.effective_start_date := p_validation_start_date;
204: p_rec.effective_end_date := p_validation_end_date;
205: End If;
206: --
207: hr_utility.set_location(' Leaving:'||l_proc, 15);
208: Exception
209: When hr_api.check_integrity_violated Then
210: -- A check constraint has been violated
211: ben_pgm_shd.g_api_dml := false; -- Unset the api dml status

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

261: --
262: l_proc varchar2(72) := g_package||'update_dml';
263: --
264: Begin
265: hr_utility.set_location('Entering:'||l_proc, 5);
266: --
267: dt_update_dml(p_rec => p_rec,
268: p_effective_date => p_effective_date,
269: p_datetrack_mode => p_datetrack_mode,

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

269: p_datetrack_mode => p_datetrack_mode,
270: p_validation_start_date => p_validation_start_date,
271: p_validation_end_date => p_validation_end_date);
272: --
273: hr_utility.set_location(' Leaving:'||l_proc, 10);
274: End update_dml;
275: --
276: -- ----------------------------------------------------------------------------
277: -- |----------------------------< dt_pre_update >-----------------------------|

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

326: l_proc varchar2(72) := g_package||'dt_pre_update';
327: l_dummy_version_number number;
328: --
329: Begin
330: hr_utility.set_location('Entering:'||l_proc, 5);
331: If (p_datetrack_mode <> 'CORRECTION') then
332: hr_utility.set_location(l_proc, 10);
333: --
334: -- Update the current effective end date

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

328: --
329: Begin
330: hr_utility.set_location('Entering:'||l_proc, 5);
331: If (p_datetrack_mode <> 'CORRECTION') then
332: hr_utility.set_location(l_proc, 10);
333: --
334: -- Update the current effective end date
335: --
336: ben_pgm_shd.upd_effective_end_date

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

341: p_validation_end_date => p_validation_end_date,
342: p_object_version_number => l_dummy_version_number);
343: --
344: If (p_datetrack_mode = 'UPDATE_OVERRIDE') then
345: hr_utility.set_location(l_proc, 15);
346: --
347: -- As the datetrack mode is 'UPDATE_OVERRIDE' then we must
348: -- delete any future rows
349: --

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

353: p_datetrack_mode => p_datetrack_mode,
354: p_validation_start_date => p_validation_start_date,
355: p_validation_end_date => p_validation_end_date);
356: End If;
357: hr_utility.set_location(l_proc, 20);
358: --
359: -- We must now insert the updated row
360: --
361: ben_pgm_ins.insert_dml

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

364: p_datetrack_mode => p_datetrack_mode,
365: p_validation_start_date => p_validation_start_date,
366: p_validation_end_date => p_validation_end_date);
367: End If;
368: hr_utility.set_location(' Leaving:'||l_proc, 20);
369: End dt_pre_update;
370: --
371: -- ----------------------------------------------------------------------------
372: -- |------------------------------< pre_update >------------------------------|

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

410: --
411: l_proc varchar2(72) := g_package||'pre_update';
412: --
413: Begin
414: hr_utility.set_location('Entering:'||l_proc, 5);
415: --
416: --
417: --
418: dt_pre_update

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

421: p_datetrack_mode => p_datetrack_mode,
422: p_validation_start_date => p_validation_start_date,
423: p_validation_end_date => p_validation_end_date);
424: --
425: hr_utility.set_location(' Leaving:'||l_proc, 10);
426: End pre_update;
427: --
428: -- ----------------------------------------------------------------------------
429: -- |-----------------------------< post_update >------------------------------|

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

466: --
467: l_proc varchar2(72) := g_package||'post_update';
468: --
469: Begin
470: hr_utility.set_location('Entering:'||l_proc, 5);
471: --
472: -- Added for GSP validations
473: pqh_gsp_ben_validations.pgm_validations
474: ( p_pgm_id => p_rec.pgm_id

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

484: , p_Acty_Ref_Perd_Cd => p_rec.Acty_Ref_Perd_Cd
485: , p_Pgm_Uom => p_rec.Pgm_Uom
486: );
487:
488: hr_utility.set_location(' Leaving:'||l_proc, 10);
489: End post_update;
490: -- ----------------------------------------------------------------------------
491: -- |-----------------------------< convert_defs >-----------------------------|
492: -- ----------------------------------------------------------------------------

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

536: l_proc varchar2(72) := g_package||'convert_defs';
537: --
538: Begin
539: --
540: hr_utility.set_location('Entering:'||l_proc, 5);
541: --
542: -- We must now examine each argument value in the
543: -- p_rec plsql record structure
544: -- to see if a system default is being used. If a system default

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

989: p_rec.pgm_attribute30 :=
990: ben_pgm_shd.g_old_rec.pgm_attribute30;
991: End If;
992: --
993: hr_utility.set_location(' Leaving:'||l_proc, 10);
994: --
995: End convert_defs;
996: --
997: -- ----------------------------------------------------------------------------

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

1008: l_validation_start_date date;
1009: l_validation_end_date date;
1010: --
1011: Begin
1012: hr_utility.set_location('Entering:'||l_proc, 5);
1013: --
1014: -- Ensure that the DateTrack update mode is valid
1015: --
1016: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);

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

1189: l_rec ben_pgm_shd.g_rec_type;
1190: l_proc varchar2(72) := g_package||'upd';
1191: --
1192: Begin
1193: hr_utility.set_location('Entering:'||l_proc, 5);
1194: --
1195: -- Call conversion function to turn arguments into the
1196: -- l_rec structure.
1197: --

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

1320: p_effective_start_date := l_rec.effective_start_date;
1321: p_effective_end_date := l_rec.effective_end_date;
1322: --
1323: --
1324: hr_utility.set_location(' Leaving:'||l_proc, 10);
1325: End upd;
1326: --
1327: end ben_pgm_upd;