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_EPZ_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 85: hr_utility.set_location('********right before the actual update',10);

81: ben_epz_shd.g_api_dml := true; -- Set the api dml status
82: --
83: -- Update the ben_elig_pstl_cd_r_rng_prte_f Row
84: --
85: hr_utility.set_location('********right before the actual update',10);
86: hr_utility.set_location('********pstl zip rng: '||
87: to_char(p_rec.pstl_zip_rng_id),10);
88: hr_utility.set_location('********eligy_prfl_id : '||
89: to_char(p_rec.eligy_prfl_id),10);

Line 86: hr_utility.set_location('********pstl zip rng: '||

82: --
83: -- Update the ben_elig_pstl_cd_r_rng_prte_f Row
84: --
85: hr_utility.set_location('********right before the actual update',10);
86: hr_utility.set_location('********pstl zip rng: '||
87: to_char(p_rec.pstl_zip_rng_id),10);
88: hr_utility.set_location('********eligy_prfl_id : '||
89: to_char(p_rec.eligy_prfl_id),10);
90: hr_utility.set_location('********excld_flag : '||

Line 88: hr_utility.set_location('********eligy_prfl_id : '||

84: --
85: hr_utility.set_location('********right before the actual update',10);
86: hr_utility.set_location('********pstl zip rng: '||
87: to_char(p_rec.pstl_zip_rng_id),10);
88: hr_utility.set_location('********eligy_prfl_id : '||
89: to_char(p_rec.eligy_prfl_id),10);
90: hr_utility.set_location('********excld_flag : '||
91: p_rec.excld_flag,10);
92:

Line 90: hr_utility.set_location('********excld_flag : '||

86: hr_utility.set_location('********pstl zip rng: '||
87: to_char(p_rec.pstl_zip_rng_id),10);
88: hr_utility.set_location('********eligy_prfl_id : '||
89: to_char(p_rec.eligy_prfl_id),10);
90: hr_utility.set_location('********excld_flag : '||
91: p_rec.excld_flag,10);
92:
93: update ben_elig_pstl_cd_r_rng_prte_f
94: set

Line 138: hr_utility.set_location('********right after the actual update',10);

134: criteria_weight = p_rec.criteria_weight
135: where elig_pstl_cd_r_rng_prte_id = p_rec.elig_pstl_cd_r_rng_prte_id
136: and effective_start_date = p_validation_start_date
137: and effective_end_date = p_validation_end_date;
138: hr_utility.set_location('********right after the actual update',10);
139: --
140: ben_epz_shd.g_api_dml := false; -- Unset the api dml status
141: --
142: -- Set the effective start and end dates

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

351: --
352: l_proc varchar2(72) := g_package||'pre_update';
353: --
354: Begin
355: hr_utility.set_location('Entering:'||l_proc, 5);
356: --
357: --
358: --
359: dt_pre_update

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

362: p_datetrack_mode => p_datetrack_mode,
363: p_validation_start_date => p_validation_start_date,
364: p_validation_end_date => p_validation_end_date);
365: --
366: hr_utility.set_location(' Leaving:'||l_proc, 10);
367: End pre_update;
368: --
369: -- ----------------------------------------------------------------------------
370: -- |-----------------------------< post_update >------------------------------|

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

407: --
408: l_proc varchar2(72) := g_package||'post_update';
409: --
410: Begin
411: hr_utility.set_location('Entering:'||l_proc, 5);
412: --
413: --
414: -- Start of API User Hook for post_update.
415: --

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

518: --
519: -- End of API User Hook for post_update.
520: --
521: --
522: hr_utility.set_location(' Leaving:'||l_proc, 10);
523: End post_update;
524: --
525: -- ----------------------------------------------------------------------------
526: -- |-----------------------------< convert_defs >-----------------------------|

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

570: l_proc varchar2(72) := g_package||'convert_defs';
571: --
572: Begin
573: --
574: hr_utility.set_location('Entering:'||l_proc, 5);
575: --
576: -- We must now examine each argument value in the
577: -- p_rec plsql record structure
578: -- to see if a system default is being used. If a system default

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

731: ben_epz_shd.g_old_rec.criteria_weight;
732: End If;
733:
734: --
735: hr_utility.set_location(' Leaving:'||l_proc, 10);
736: --
737: End convert_defs;
738: --
739: -- ----------------------------------------------------------------------------

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

750: l_validation_start_date date;
751: l_validation_end_date date;
752: --
753: Begin
754: hr_utility.set_location('Entering:'||l_proc, 5);
755: --
756: -- Ensure that the DateTrack update mode is valid
757: --
758: dt_api.validate_dt_upd_mode(p_datetrack_mode => p_datetrack_mode);

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

863: l_rec ben_epz_shd.g_rec_type;
864: l_proc varchar2(72) := g_package||'upd';
865: --
866: Begin
867: hr_utility.set_location('Entering:'||l_proc, 5);
868: --
869: -- Call conversion function to turn arguments into the
870: -- l_rec structure.
871: --

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

925: p_effective_start_date := l_rec.effective_start_date;
926: p_effective_end_date := l_rec.effective_end_date;
927: --
928: --
929: hr_utility.set_location(' Leaving:'||l_proc, 10);
930: End upd;
931: --
932: end ben_epz_upd;