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_SAZ_BUS dependencies on HR_UTILITY

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

42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_saz_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_svc_area_pstl_zip_rng_id => p_svc_area_pstl_zip_rng_id,

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

71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_svc_area_pstl_zip_rng_id;
78: --
79: -- ----------------------------------------------------------------------------

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

116: l_integrity_error Exception;
117: l_table_name all_tables.table_name%TYPE;
118: --
119: Begin
120: hr_utility.set_location('Entering:'||l_proc, 5);
121: --
122: -- Ensure that the p_datetrack_mode argument is not null
123: --
124: hr_api.mandatory_arg_error

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

165: End If;
166: --
167: End If;
168: --
169: hr_utility.set_location(' Leaving:'||l_proc, 10);
170: Exception
171: When l_integrity_error Then
172: --
173: -- A referential integrity check was violated therefore

Line 182: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

178: --
179: -- An unhandled or unexpected error has occurred which
180: -- we must report
181: --
182: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
183: hr_utility.set_message_token('PROCEDURE', l_proc);
184: hr_utility.set_message_token('STEP','15');
185: hr_utility.raise_error;
186: End dt_update_validate;

Line 183: hr_utility.set_message_token('PROCEDURE', l_proc);

179: -- An unhandled or unexpected error has occurred which
180: -- we must report
181: --
182: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
183: hr_utility.set_message_token('PROCEDURE', l_proc);
184: hr_utility.set_message_token('STEP','15');
185: hr_utility.raise_error;
186: End dt_update_validate;
187: --

Line 184: hr_utility.set_message_token('STEP','15');

180: -- we must report
181: --
182: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
183: hr_utility.set_message_token('PROCEDURE', l_proc);
184: hr_utility.set_message_token('STEP','15');
185: hr_utility.raise_error;
186: End dt_update_validate;
187: --
188: -- ----------------------------------------------------------------------------

Line 185: hr_utility.raise_error;

181: --
182: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
183: hr_utility.set_message_token('PROCEDURE', l_proc);
184: hr_utility.set_message_token('STEP','15');
185: hr_utility.raise_error;
186: End dt_update_validate;
187: --
188: -- ----------------------------------------------------------------------------
189: -- |--------------------------< dt_delete_validate >--------------------------|

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

230: l_rows_exist Exception;
231: l_table_name all_tables.table_name%TYPE;
232: --
233: Begin
234: hr_utility.set_location('Entering:'||l_proc, 5);
235: --
236: -- Ensure that the p_datetrack_mode argument is not null
237: --
238: hr_api.mandatory_arg_error

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

267: --
268: --
269: End If;
270: --
271: hr_utility.set_location(' Leaving:'||l_proc, 10);
272: Exception
273: When l_rows_exist Then
274: --
275: -- A referential integrity check was violated therefore

Line 284: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

280: --
281: -- An unhandled or unexpected error has occurred which
282: -- we must report
283: --
284: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
285: hr_utility.set_message_token('PROCEDURE', l_proc);
286: hr_utility.set_message_token('STEP','15');
287: hr_utility.raise_error;
288: End dt_delete_validate;

Line 285: hr_utility.set_message_token('PROCEDURE', l_proc);

281: -- An unhandled or unexpected error has occurred which
282: -- we must report
283: --
284: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
285: hr_utility.set_message_token('PROCEDURE', l_proc);
286: hr_utility.set_message_token('STEP','15');
287: hr_utility.raise_error;
288: End dt_delete_validate;
289: --

Line 286: hr_utility.set_message_token('STEP','15');

282: -- we must report
283: --
284: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
285: hr_utility.set_message_token('PROCEDURE', l_proc);
286: hr_utility.set_message_token('STEP','15');
287: hr_utility.raise_error;
288: End dt_delete_validate;
289: --
290: -- ----------------------------------------------------------------------------

Line 287: hr_utility.raise_error;

283: --
284: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
285: hr_utility.set_message_token('PROCEDURE', l_proc);
286: hr_utility.set_message_token('STEP','15');
287: hr_utility.raise_error;
288: End dt_delete_validate;
289: --
290: -- ----------------------------------------------------------------------------
291: -- |---------------------------< insert_validate >----------------------------|

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

299: --
300: l_proc varchar2(72) := g_package||'insert_validate';
301: --
302: Begin
303: hr_utility.set_location('Entering:'||l_proc, 5);
304: --
305: -- Call all supporting business operations
306: --
307: --

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

311: (p_svc_area_pstl_zip_rng_id => p_rec.svc_area_pstl_zip_rng_id,
312: p_effective_date => p_effective_date,
313: p_object_version_number => p_rec.object_version_number);
314: --
315: hr_utility.set_location(' Leaving:'||l_proc, 10);
316: End insert_validate;
317: --
318: -- ----------------------------------------------------------------------------
319: -- |---------------------------< update_validate >----------------------------|

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

327: --
328: l_proc varchar2(72) := g_package||'update_validate';
329: --
330: Begin
331: hr_utility.set_location('Entering:'||l_proc, 5);
332: --
333: -- Call all supporting business operations
334: --
335: --

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

348: p_datetrack_mode => p_datetrack_mode,
349: p_validation_start_date => p_validation_start_date,
350: p_validation_end_date => p_validation_end_date);
351: --
352: hr_utility.set_location(' Leaving:'||l_proc, 10);
353: End update_validate;
354: --
355: -- ----------------------------------------------------------------------------
356: -- |---------------------------< delete_validate >----------------------------|

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

364: --
365: l_proc varchar2(72) := g_package||'delete_validate';
366: --
367: Begin
368: hr_utility.set_location('Entering:'||l_proc, 5);
369: --
370: -- Call all supporting business operations
371: --
372: dt_delete_validate

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

374: p_validation_start_date => p_validation_start_date,
375: p_validation_end_date => p_validation_end_date,
376: p_svc_area_pstl_zip_rng_id => p_rec.svc_area_pstl_zip_rng_id);
377: --
378: hr_utility.set_location(' Leaving:'||l_proc, 10);
379: End delete_validate;
380: --
381: --
382: -- ---------------------------------------------------------------------------

Line 405: hr_utility.set_location('Entering:'|| l_proc, 10);

401: l_proc varchar2(72) := g_package||'return_legislation_code';
402: --
403: begin
404: --
405: hr_utility.set_location('Entering:'|| l_proc, 10);
406: --
407: -- Ensure that all the mandatory parameter are not null
408: --
409: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 423: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

419: close csr_leg_code;
420: --
421: -- The primary key is invalid therefore we must error
422: --
423: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
424: hr_utility.raise_error;
425: --
426: end if;
427: --

Line 424: hr_utility.raise_error;

420: --
421: -- The primary key is invalid therefore we must error
422: --
423: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
424: hr_utility.raise_error;
425: --
426: end if;
427: --
428: close csr_leg_code;

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

426: end if;
427: --
428: close csr_leg_code;
429: --
430: hr_utility.set_location(' Leaving:'|| l_proc, 20);
431: --
432: return l_legislation_code;
433: --
434: end return_legislation_code;