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_ETW_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_etw_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_per_wv_pl_typ_id => p_elig_per_wv_pl_typ_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_elig_per_wv_pl_typ_id;
78: --
79: -- ----------------------------------------------------------------------------

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

111: l_api_updating boolean;
112: --
113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_etw_shd.api_updating
118: (p_elig_per_wv_pl_typ_id => p_elig_per_wv_pl_typ_id,
119: p_effective_date => p_effective_date,

Line 137: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

133: p_effective_date => p_effective_date) then
134: --
135: -- raise error as does not exist as lookup
136: --
137: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
138: hr_utility.raise_error;
139: --
140: end if;
141: --

Line 138: hr_utility.raise_error;

134: --
135: -- raise error as does not exist as lookup
136: --
137: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
138: hr_utility.raise_error;
139: --
140: end if;
141: --
142: end if;

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

140: end if;
141: --
142: end if;
143: --
144: hr_utility.set_location('Leaving:'||l_proc,10);
145: --
146: end chk_wvd_flag;
147: --
148: -- ----------------------------------------------------------------------------

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

180: l_api_updating boolean;
181: --
182: Begin
183: --
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: l_api_updating := ben_etw_shd.api_updating
187: (p_elig_per_wv_pl_typ_id => p_elig_per_wv_pl_typ_id,
188: p_effective_date => p_effective_date,

Line 206: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

202: p_effective_date => p_effective_date) then
203: --
204: -- raise error as does not exist as lookup
205: --
206: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
207: hr_utility.raise_error;
208: --
209: end if;
210: --

Line 207: hr_utility.raise_error;

203: --
204: -- raise error as does not exist as lookup
205: --
206: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
207: hr_utility.raise_error;
208: --
209: end if;
210: --
211: end if;

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

209: end if;
210: --
211: end if;
212: --
213: hr_utility.set_location('Leaving:'||l_proc,10);
214: --
215: end chk_wv_prtn_rsn_cd;
216: --
217: -- ----------------------------------------------------------------------------

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

249: l_api_updating boolean;
250: --
251: Begin
252: --
253: hr_utility.set_location('Entering:'||l_proc, 5);
254: --
255: l_api_updating := ben_etw_shd.api_updating
256: (p_elig_per_wv_pl_typ_id => p_elig_per_wv_pl_typ_id,
257: p_effective_date => p_effective_date,

Line 275: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

271: p_effective_date => p_effective_date) then
272: --
273: -- raise error as does not exist as lookup
274: --
275: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
276: hr_utility.raise_error;
277: --
278: end if;
279: --

Line 276: hr_utility.raise_error;

272: --
273: -- raise error as does not exist as lookup
274: --
275: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
276: hr_utility.raise_error;
277: --
278: end if;
279: --
280: end if;

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

278: end if;
279: --
280: end if;
281: --
282: hr_utility.set_location('Leaving:'||l_proc,10);
283: --
284: end chk_wv_cftn_typ_cd;
285: --
286: -- ----------------------------------------------------------------------------

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

323: l_integrity_error Exception;
324: l_table_name all_tables.table_name%TYPE;
325: --
326: Begin
327: hr_utility.set_location('Entering:'||l_proc, 5);
328: --
329: -- Ensure that the p_datetrack_mode argument is not null
330: --
331: hr_api.mandatory_arg_error

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

372: End If;
373: --
374: End If;
375: --
376: hr_utility.set_location(' Leaving:'||l_proc, 10);
377: Exception
378: When l_integrity_error Then
379: --
380: -- A referential integrity check was violated therefore

Line 383: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');

379: --
380: -- A referential integrity check was violated therefore
381: -- we must error
382: --
383: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
384: hr_utility.set_message_token('TABLE_NAME', l_table_name);
385: hr_utility.raise_error;
386: When Others Then
387: --

Line 384: hr_utility.set_message_token('TABLE_NAME', l_table_name);

380: -- A referential integrity check was violated therefore
381: -- we must error
382: --
383: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
384: hr_utility.set_message_token('TABLE_NAME', l_table_name);
385: hr_utility.raise_error;
386: When Others Then
387: --
388: -- An unhandled or unexpected error has occurred which

Line 385: hr_utility.raise_error;

381: -- we must error
382: --
383: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
384: hr_utility.set_message_token('TABLE_NAME', l_table_name);
385: hr_utility.raise_error;
386: When Others Then
387: --
388: -- An unhandled or unexpected error has occurred which
389: -- we must report

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

387: --
388: -- An unhandled or unexpected error has occurred which
389: -- we must report
390: --
391: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
392: hr_utility.set_message_token('PROCEDURE', l_proc);
393: hr_utility.set_message_token('STEP','15');
394: hr_utility.raise_error;
395: End dt_update_validate;

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

388: -- An unhandled or unexpected error has occurred which
389: -- we must report
390: --
391: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
392: hr_utility.set_message_token('PROCEDURE', l_proc);
393: hr_utility.set_message_token('STEP','15');
394: hr_utility.raise_error;
395: End dt_update_validate;
396: --

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

389: -- we must report
390: --
391: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
392: hr_utility.set_message_token('PROCEDURE', l_proc);
393: hr_utility.set_message_token('STEP','15');
394: hr_utility.raise_error;
395: End dt_update_validate;
396: --
397: -- ----------------------------------------------------------------------------

Line 394: hr_utility.raise_error;

390: --
391: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
392: hr_utility.set_message_token('PROCEDURE', l_proc);
393: hr_utility.set_message_token('STEP','15');
394: hr_utility.raise_error;
395: End dt_update_validate;
396: --
397: -- ----------------------------------------------------------------------------
398: -- |--------------------------< dt_delete_validate >--------------------------|

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

439: l_rows_exist Exception;
440: l_table_name all_tables.table_name%TYPE;
441: --
442: Begin
443: hr_utility.set_location('Entering:'||l_proc, 5);
444: --
445: -- Ensure that the p_datetrack_mode argument is not null
446: --
447: hr_api.mandatory_arg_error

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

476: --
477: --
478: End If;
479: --
480: hr_utility.set_location(' Leaving:'||l_proc, 10);
481: Exception
482: When l_rows_exist Then
483: --
484: -- A referential integrity check was violated therefore

Line 487: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');

483: --
484: -- A referential integrity check was violated therefore
485: -- we must error
486: --
487: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
488: hr_utility.set_message_token('TABLE_NAME', l_table_name);
489: hr_utility.raise_error;
490: When Others Then
491: --

Line 488: hr_utility.set_message_token('TABLE_NAME', l_table_name);

484: -- A referential integrity check was violated therefore
485: -- we must error
486: --
487: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
488: hr_utility.set_message_token('TABLE_NAME', l_table_name);
489: hr_utility.raise_error;
490: When Others Then
491: --
492: -- An unhandled or unexpected error has occurred which

Line 489: hr_utility.raise_error;

485: -- we must error
486: --
487: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
488: hr_utility.set_message_token('TABLE_NAME', l_table_name);
489: hr_utility.raise_error;
490: When Others Then
491: --
492: -- An unhandled or unexpected error has occurred which
493: -- we must report

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

491: --
492: -- An unhandled or unexpected error has occurred which
493: -- we must report
494: --
495: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
496: hr_utility.set_message_token('PROCEDURE', l_proc);
497: hr_utility.set_message_token('STEP','15');
498: hr_utility.raise_error;
499: End dt_delete_validate;

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

492: -- An unhandled or unexpected error has occurred which
493: -- we must report
494: --
495: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
496: hr_utility.set_message_token('PROCEDURE', l_proc);
497: hr_utility.set_message_token('STEP','15');
498: hr_utility.raise_error;
499: End dt_delete_validate;
500: --

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

493: -- we must report
494: --
495: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
496: hr_utility.set_message_token('PROCEDURE', l_proc);
497: hr_utility.set_message_token('STEP','15');
498: hr_utility.raise_error;
499: End dt_delete_validate;
500: --
501: -- ----------------------------------------------------------------------------

Line 498: hr_utility.raise_error;

494: --
495: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
496: hr_utility.set_message_token('PROCEDURE', l_proc);
497: hr_utility.set_message_token('STEP','15');
498: hr_utility.raise_error;
499: End dt_delete_validate;
500: --
501: -- ----------------------------------------------------------------------------
502: -- |---------------------------< insert_validate >----------------------------|

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

510: --
511: l_proc varchar2(72) := g_package||'insert_validate';
512: --
513: Begin
514: hr_utility.set_location('Entering:'||l_proc, 5);
515: --
516: -- Call all supporting business operations
517: --
518: --

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

540: p_wv_cftn_typ_cd => p_rec.wv_cftn_typ_cd,
541: p_effective_date => p_effective_date,
542: p_object_version_number => p_rec.object_version_number);
543: --
544: hr_utility.set_location(' Leaving:'||l_proc, 10);
545: End insert_validate;
546: --
547: -- ----------------------------------------------------------------------------
548: -- |---------------------------< update_validate >----------------------------|

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

556: --
557: l_proc varchar2(72) := g_package||'update_validate';
558: --
559: Begin
560: hr_utility.set_location('Entering:'||l_proc, 5);
561: --
562: -- Call all supporting business operations
563: --
564: --

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

595: p_datetrack_mode => p_datetrack_mode,
596: p_validation_start_date => p_validation_start_date,
597: p_validation_end_date => p_validation_end_date);
598: --
599: hr_utility.set_location(' Leaving:'||l_proc, 10);
600: End update_validate;
601: --
602: -- ----------------------------------------------------------------------------
603: -- |---------------------------< delete_validate >----------------------------|

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

611: --
612: l_proc varchar2(72) := g_package||'delete_validate';
613: --
614: Begin
615: hr_utility.set_location('Entering:'||l_proc, 5);
616: --
617: -- Call all supporting business operations
618: --
619: dt_delete_validate

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

621: p_validation_start_date => p_validation_start_date,
622: p_validation_end_date => p_validation_end_date,
623: p_elig_per_wv_pl_typ_id => p_rec.elig_per_wv_pl_typ_id);
624: --
625: hr_utility.set_location(' Leaving:'||l_proc, 10);
626: End delete_validate;
627: --
628: --
629: -- ---------------------------------------------------------------------------

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

648: l_proc varchar2(72) := g_package||'return_legislation_code';
649: --
650: begin
651: --
652: hr_utility.set_location('Entering:'|| l_proc, 10);
653: --
654: -- Ensure that all the mandatory parameter are not null
655: --
656: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

666: close csr_leg_code;
667: --
668: -- The primary key is invalid therefore we must error
669: --
670: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
671: hr_utility.raise_error;
672: --
673: end if;
674: --

Line 671: hr_utility.raise_error;

667: --
668: -- The primary key is invalid therefore we must error
669: --
670: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
671: hr_utility.raise_error;
672: --
673: end if;
674: --
675: close csr_leg_code;

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

673: end if;
674: --
675: close csr_leg_code;
676: --
677: hr_utility.set_location(' Leaving:'|| l_proc, 20);
678: --
679: return l_legislation_code;
680: --
681: end return_legislation_code;