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_PZR_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_pzr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_pstl_zip_rt_id => p_pstl_zip_rt_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_pstl_zip_rt_id;
78:
79:

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

142: --
143: --
144: Begin
145: --
146: hr_utility.set_location('Entering:'||l_proc,5);
147: --
148: l_api_updating := ben_pzr_shd.api_updating
149: (p_pstl_zip_rt_id => p_pstl_zip_rt_id,
150: p_effective_date => p_effective_date,

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

190: --
191: --
192: end if;
193: --
194: hr_utility.set_location('Leaving:'||l_proc,10);
195: --
196: End chk_pstl_zip_rng_id;
197: --
198:

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

239: and business_group_id + 0 = p_business_group_id
240: and ordr_num = p_ordr_num;
241: --
242: Begin
243: hr_utility.set_location('Entering:'||l_proc, 5);
244:
245: --
246: open c1;
247: fetch c1 into l_dummy;

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

251: fnd_message.raise_error;
252: end if;
253: close c1;
254: --
255: hr_utility.set_location('Leaving:'||l_proc, 15);
256: End chk_duplicate_ordr_num;
257:
258: --
259: -- ----------------------------------------------------------------------------

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

291: l_api_updating boolean;
292: --
293: Begin
294: --
295: hr_utility.set_location('Entering:'||l_proc, 5);
296: --
297: l_api_updating := ben_pzr_shd.api_updating
298: (p_pstl_zip_rt_id => p_pstl_zip_rt_id,
299: p_effective_date => p_effective_date,

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

313: p_effective_date => p_effective_date) then
314: --
315: -- raise error as does not exist as lookup
316: --
317: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
318: hr_utility.raise_error;
319: --
320: end if;
321: --

Line 318: hr_utility.raise_error;

314: --
315: -- raise error as does not exist as lookup
316: --
317: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
318: hr_utility.raise_error;
319: --
320: end if;
321: --
322: end if;

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

320: end if;
321: --
322: end if;
323: --
324: hr_utility.set_location('Leaving:'||l_proc,10);
325: --
326: end chk_excld_flag;
327: --
328: -- ----------------------------------------------------------------------------

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

365: l_integrity_error Exception;
366: l_table_name all_tables.table_name%TYPE;
367: --
368: Begin
369: hr_utility.set_location('Entering:'||l_proc, 5);
370: --
371: -- Ensure that the p_datetrack_mode argument is not null
372: --
373: hr_api.mandatory_arg_error

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

414: End If;
415: --
416: End If;
417: --
418: hr_utility.set_location(' Leaving:'||l_proc, 10);
419: Exception
420: When l_integrity_error Then
421: --
422: -- A referential integrity check was violated therefore

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

421: --
422: -- A referential integrity check was violated therefore
423: -- we must error
424: --
425: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
426: hr_utility.set_message_token('TABLE_NAME', l_table_name);
427: hr_utility.raise_error;
428: When Others Then
429: --

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

422: -- A referential integrity check was violated therefore
423: -- we must error
424: --
425: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
426: hr_utility.set_message_token('TABLE_NAME', l_table_name);
427: hr_utility.raise_error;
428: When Others Then
429: --
430: -- An unhandled or unexpected error has occurred which

Line 427: hr_utility.raise_error;

423: -- we must error
424: --
425: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
426: hr_utility.set_message_token('TABLE_NAME', l_table_name);
427: hr_utility.raise_error;
428: When Others Then
429: --
430: -- An unhandled or unexpected error has occurred which
431: -- we must report

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

429: --
430: -- An unhandled or unexpected error has occurred which
431: -- we must report
432: --
433: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
434: hr_utility.set_message_token('PROCEDURE', l_proc);
435: hr_utility.set_message_token('STEP','15');
436: hr_utility.raise_error;
437: End dt_update_validate;

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

430: -- An unhandled or unexpected error has occurred which
431: -- we must report
432: --
433: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
434: hr_utility.set_message_token('PROCEDURE', l_proc);
435: hr_utility.set_message_token('STEP','15');
436: hr_utility.raise_error;
437: End dt_update_validate;
438: --

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

431: -- we must report
432: --
433: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
434: hr_utility.set_message_token('PROCEDURE', l_proc);
435: hr_utility.set_message_token('STEP','15');
436: hr_utility.raise_error;
437: End dt_update_validate;
438: --
439: -- ----------------------------------------------------------------------------

Line 436: hr_utility.raise_error;

432: --
433: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
434: hr_utility.set_message_token('PROCEDURE', l_proc);
435: hr_utility.set_message_token('STEP','15');
436: hr_utility.raise_error;
437: End dt_update_validate;
438: --
439: -- ----------------------------------------------------------------------------
440: -- |--------------------------< dt_delete_validate >--------------------------|

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

481: l_rows_exist Exception;
482: l_table_name all_tables.table_name%TYPE;
483: --
484: Begin
485: hr_utility.set_location('Entering:'||l_proc, 5);
486: --
487: -- Ensure that the p_datetrack_mode argument is not null
488: --
489: hr_api.mandatory_arg_error

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

518: --
519: --
520: End If;
521: --
522: hr_utility.set_location(' Leaving:'||l_proc, 10);
523: Exception
524: When l_rows_exist Then
525: --
526: -- A referential integrity check was violated therefore

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

525: --
526: -- A referential integrity check was violated therefore
527: -- we must error
528: --
529: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
530: hr_utility.set_message_token('TABLE_NAME', l_table_name);
531: hr_utility.raise_error;
532: When Others Then
533: --

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

526: -- A referential integrity check was violated therefore
527: -- we must error
528: --
529: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
530: hr_utility.set_message_token('TABLE_NAME', l_table_name);
531: hr_utility.raise_error;
532: When Others Then
533: --
534: -- An unhandled or unexpected error has occurred which

Line 531: hr_utility.raise_error;

527: -- we must error
528: --
529: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
530: hr_utility.set_message_token('TABLE_NAME', l_table_name);
531: hr_utility.raise_error;
532: When Others Then
533: --
534: -- An unhandled or unexpected error has occurred which
535: -- we must report

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

533: --
534: -- An unhandled or unexpected error has occurred which
535: -- we must report
536: --
537: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
538: hr_utility.set_message_token('PROCEDURE', l_proc);
539: hr_utility.set_message_token('STEP','15');
540: hr_utility.raise_error;
541: End dt_delete_validate;

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

534: -- An unhandled or unexpected error has occurred which
535: -- we must report
536: --
537: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
538: hr_utility.set_message_token('PROCEDURE', l_proc);
539: hr_utility.set_message_token('STEP','15');
540: hr_utility.raise_error;
541: End dt_delete_validate;
542: --

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

535: -- we must report
536: --
537: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
538: hr_utility.set_message_token('PROCEDURE', l_proc);
539: hr_utility.set_message_token('STEP','15');
540: hr_utility.raise_error;
541: End dt_delete_validate;
542: --
543: -- ----------------------------------------------------------------------------

Line 540: hr_utility.raise_error;

536: --
537: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
538: hr_utility.set_message_token('PROCEDURE', l_proc);
539: hr_utility.set_message_token('STEP','15');
540: hr_utility.raise_error;
541: End dt_delete_validate;
542: --
543: -- ----------------------------------------------------------------------------
544: -- |---------------------------< insert_validate >----------------------------|

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

552: --
553: l_proc varchar2(72) := g_package||'insert_validate';
554: --
555: Begin
556: hr_utility.set_location('Entering:'||l_proc, 5);
557: --
558: -- Call all supporting business operations
559: --
560: --

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

587: ,p_effective_date => p_effective_date
588: ,p_business_group_id => p_rec.business_group_id
589: ,p_pstl_zip_rt_id => p_rec.pstl_zip_rt_id);
590: --
591: hr_utility.set_location(' Leaving:'||l_proc, 10);
592: End insert_validate;
593: --
594: -- ----------------------------------------------------------------------------
595: -- |---------------------------< update_validate >----------------------------|

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

603: --
604: l_proc varchar2(72) := g_package||'update_validate';
605: --
606: Begin
607: hr_utility.set_location('Entering:'||l_proc, 5);
608: --
609: -- Call all supporting business operations
610: --
611: --

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

647: ,p_effective_date => p_effective_date
648: ,p_business_group_id => p_rec.business_group_id
649: ,p_pstl_zip_rt_id => p_rec.pstl_zip_rt_id);
650: --
651: hr_utility.set_location(' Leaving:'||l_proc, 10);
652: End update_validate;
653: --
654: -- ----------------------------------------------------------------------------
655: -- |---------------------------< delete_validate >----------------------------|

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

663: --
664: l_proc varchar2(72) := g_package||'delete_validate';
665: --
666: Begin
667: hr_utility.set_location('Entering:'||l_proc, 5);
668: --
669: -- Call all supporting business operations
670: --
671: dt_delete_validate

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

673: p_validation_start_date => p_validation_start_date,
674: p_validation_end_date => p_validation_end_date,
675: p_pstl_zip_rt_id => p_rec.pstl_zip_rt_id);
676: --
677: hr_utility.set_location(' Leaving:'||l_proc, 10);
678: End delete_validate;
679: --
680: --
681: -- ---------------------------------------------------------------------------

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

700: l_proc varchar2(72) := g_package||'return_legislation_code';
701: --
702: begin
703: --
704: hr_utility.set_location('Entering:'|| l_proc, 10);
705: --
706: -- Ensure that all the mandatory parameter are not null
707: --
708: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

718: close csr_leg_code;
719: --
720: -- The primary key is invalid therefore we must error
721: --
722: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
723: hr_utility.raise_error;
724: --
725: end if;
726: --

Line 723: hr_utility.raise_error;

719: --
720: -- The primary key is invalid therefore we must error
721: --
722: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
723: hr_utility.raise_error;
724: --
725: end if;
726: --
727: close csr_leg_code;

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

725: end if;
726: --
727: close csr_leg_code;
728: --
729: hr_utility.set_location(' Leaving:'|| l_proc, 20);
730: --
731: return l_legislation_code;
732: --
733: end return_legislation_code;