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_HWR_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_hwr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_hrs_wkd_in_perd_rt_id => p_hrs_wkd_in_perd_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_hrs_wkd_in_perd_rt_id;
78: --
79: -- ----------------------------------------------------------------------------

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

117: where a.hrs_wkd_in_perd_fctr_id = p_hrs_wkd_in_perd_fctr_id;
118: --
119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: l_api_updating := ben_hwr_shd.api_updating
124: (p_hrs_wkd_in_perd_rt_id => p_hrs_wkd_in_perd_rt_id,
125: p_effective_date => p_effective_date,

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

150: close c1;
151: --
152: end if;
153: --
154: hr_utility.set_location('Leaving:'||l_proc,10);
155: --
156: End chk_hrs_wkd_in_perd_fctr_id;
157: -- ----------------------------------------------------------------------------
158: -- |------< chk_dup_record >------|

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

210: and p_validation_end_date >= effective_start_date;
211: --
212: BEGIN
213: --
214: hr_utility.set_location('Entering:'||l_proc, 5);
215: --
216: l_api_updating := ben_hwr_shd.api_updating
217: (p_hrs_wkd_in_perd_rt_id => p_hrs_wkd_in_perd_rt_id,
218: p_effective_date => p_effective_date,

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

237: end if;
238: close c_dup;
239: --
240: end if;
241: hr_utility.set_location('Leaving:'||l_proc,10);
242: --
243: END chk_dup_record;
244:
245: --

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

290: and business_group_id + 0 = p_business_group_id
291: and ordr_num = p_ordr_num;
292: --
293: Begin
294: hr_utility.set_location('Entering:'||l_proc, 5);
295:
296: --
297: open c1;
298: fetch c1 into l_dummy;

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

302: fnd_message.raise_error;
303: end if;
304: close c1;
305: --
306: hr_utility.set_location('Leaving:'||l_proc, 15);
307: End chk_duplicate_ordr_num;
308:
309: --
310: -- ----------------------------------------------------------------------------

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

342: l_api_updating boolean;
343: --
344: Begin
345: --
346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: l_api_updating := ben_hwr_shd.api_updating
349: (p_hrs_wkd_in_perd_rt_id => p_hrs_wkd_in_perd_rt_id,
350: p_effective_date => p_effective_date,

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

364: p_effective_date => p_effective_date) then
365: --
366: -- raise error as does not exist as lookup
367: --
368: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
369: hr_utility.raise_error;
370: --
371: end if;
372: --

Line 369: hr_utility.raise_error;

365: --
366: -- raise error as does not exist as lookup
367: --
368: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
369: hr_utility.raise_error;
370: --
371: end if;
372: --
373: end if;

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

371: end if;
372: --
373: end if;
374: --
375: hr_utility.set_location('Leaving:'||l_proc,10);
376: --
377: end chk_excld_flag;
378: --
379: -- ----------------------------------------------------------------------------

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

413: --
414:
415: Begin
416: --
417: hr_utility.set_location('Entering:'||l_proc, 5);
418: --
419: if p_hrs_wkd_in_perd_fctr_id is not null then
420: open c1;
421: fetch c1 into l_dummy;

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

419: if p_hrs_wkd_in_perd_fctr_id is not null then
420: open c1;
421: fetch c1 into l_dummy;
422: if c1%notfound then
423: hr_utility.set_message(801,'Hrs_Wkd_NotExist');
424: hr_utility.raise_error;
425: end if;
426: close c1;
427: end if;

Line 424: hr_utility.raise_error;

420: open c1;
421: fetch c1 into l_dummy;
422: if c1%notfound then
423: hr_utility.set_message(801,'Hrs_Wkd_NotExist');
424: hr_utility.raise_error;
425: end if;
426: close c1;
427: end if;
428: --

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

425: end if;
426: close c1;
427: end if;
428: --
429: hr_utility.set_location('Leaving:'||l_proc, 10);
430: --
431: End chk_hrs_wkd_in_perd_fctr_id;
432: --
433: -- ----------------------------------------------------------------------------

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

469: l_integrity_error Exception;
470: l_table_name all_tables.table_name%TYPE;
471: --
472: Begin
473: hr_utility.set_location('Entering:'||l_proc, 5);
474: --
475: -- Ensure that the p_datetrack_mode argument is not null
476: --
477: hr_api.mandatory_arg_error

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

508: End If;
509: --
510: End If;
511: --
512: hr_utility.set_location(' Leaving:'||l_proc, 10);
513: Exception
514: When l_integrity_error Then
515: --
516: -- A referential integrity check was violated therefore

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

522: --
523: -- An unhandled or unexpected error has occurred which
524: -- we must report
525: --
526: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
527: hr_utility.set_message_token('PROCEDURE', l_proc);
528: hr_utility.set_message_token('STEP','15');
529: hr_utility.raise_error;
530: End dt_update_validate;

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

523: -- An unhandled or unexpected error has occurred which
524: -- we must report
525: --
526: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
527: hr_utility.set_message_token('PROCEDURE', l_proc);
528: hr_utility.set_message_token('STEP','15');
529: hr_utility.raise_error;
530: End dt_update_validate;
531: --

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

524: -- we must report
525: --
526: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
527: hr_utility.set_message_token('PROCEDURE', l_proc);
528: hr_utility.set_message_token('STEP','15');
529: hr_utility.raise_error;
530: End dt_update_validate;
531: --
532: -- ----------------------------------------------------------------------------

Line 529: hr_utility.raise_error;

525: --
526: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
527: hr_utility.set_message_token('PROCEDURE', l_proc);
528: hr_utility.set_message_token('STEP','15');
529: hr_utility.raise_error;
530: End dt_update_validate;
531: --
532: -- ----------------------------------------------------------------------------
533: -- |--------------------------< dt_delete_validate >--------------------------|

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

574: l_rows_exist Exception;
575: l_table_name all_tables.table_name%TYPE;
576: --
577: Begin
578: hr_utility.set_location('Entering:'||l_proc, 5);
579: --
580: -- Ensure that the p_datetrack_mode argument is not null
581: --
582: hr_api.mandatory_arg_error

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

611: --
612: --
613: End If;
614: --
615: hr_utility.set_location(' Leaving:'||l_proc, 10);
616: Exception
617: When l_rows_exist Then
618: --
619: -- A referential integrity check was violated therefore

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

618: --
619: -- A referential integrity check was violated therefore
620: -- we must error
621: --
622: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
623: hr_utility.set_message_token('TABLE_NAME', l_table_name);
624: hr_utility.raise_error;
625: When Others Then
626: --

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

619: -- A referential integrity check was violated therefore
620: -- we must error
621: --
622: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
623: hr_utility.set_message_token('TABLE_NAME', l_table_name);
624: hr_utility.raise_error;
625: When Others Then
626: --
627: -- An unhandled or unexpected error has occurred which

Line 624: hr_utility.raise_error;

620: -- we must error
621: --
622: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
623: hr_utility.set_message_token('TABLE_NAME', l_table_name);
624: hr_utility.raise_error;
625: When Others Then
626: --
627: -- An unhandled or unexpected error has occurred which
628: -- we must report

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

626: --
627: -- An unhandled or unexpected error has occurred which
628: -- we must report
629: --
630: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
631: hr_utility.set_message_token('PROCEDURE', l_proc);
632: hr_utility.set_message_token('STEP','15');
633: hr_utility.raise_error;
634: End dt_delete_validate;

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

627: -- An unhandled or unexpected error has occurred which
628: -- we must report
629: --
630: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
631: hr_utility.set_message_token('PROCEDURE', l_proc);
632: hr_utility.set_message_token('STEP','15');
633: hr_utility.raise_error;
634: End dt_delete_validate;
635: --

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

628: -- we must report
629: --
630: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
631: hr_utility.set_message_token('PROCEDURE', l_proc);
632: hr_utility.set_message_token('STEP','15');
633: hr_utility.raise_error;
634: End dt_delete_validate;
635: --
636: -- ----------------------------------------------------------------------------

Line 633: hr_utility.raise_error;

629: --
630: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
631: hr_utility.set_message_token('PROCEDURE', l_proc);
632: hr_utility.set_message_token('STEP','15');
633: hr_utility.raise_error;
634: End dt_delete_validate;
635: --
636: -- ----------------------------------------------------------------------------
637: -- |---------------------------< insert_validate >----------------------------|

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

645: --
646: l_proc varchar2(72) := g_package||'insert_validate';
647: --
648: Begin
649: hr_utility.set_location('Entering:'||l_proc, 5);
650: --
651: -- Call all supporting business operations
652: --
653: --

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

691: ,p_validation_end_date => p_validation_end_date
692: ,p_business_group_id => p_rec.business_group_id
693: ,p_hrs_wkd_in_perd_rt_id => p_rec.hrs_wkd_in_perd_rt_id);
694: --
695: hr_utility.set_location(' Leaving:'||l_proc, 10);
696: End insert_validate;
697: --
698: -- ----------------------------------------------------------------------------
699: -- |---------------------------< update_validate >----------------------------|

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

707: --
708: l_proc varchar2(72) := g_package||'update_validate';
709: --
710: Begin
711: hr_utility.set_location('Entering:'||l_proc, 5);
712: --
713: -- Call all supporting business operations
714: --
715: --

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

761: ,p_validation_end_date => p_validation_end_date
762: ,p_business_group_id => p_rec.business_group_id
763: ,p_hrs_wkd_in_perd_rt_id => p_rec.hrs_wkd_in_perd_rt_id);
764: --
765: hr_utility.set_location(' Leaving:'||l_proc, 10);
766: End update_validate;
767: --
768: -- ----------------------------------------------------------------------------
769: -- |---------------------------< delete_validate >----------------------------|

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

777: --
778: l_proc varchar2(72) := g_package||'delete_validate';
779: --
780: Begin
781: hr_utility.set_location('Entering:'||l_proc, 5);
782: --
783: -- Call all supporting business operations
784: --
785: dt_delete_validate

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

787: p_validation_start_date => p_validation_start_date,
788: p_validation_end_date => p_validation_end_date,
789: p_hrs_wkd_in_perd_rt_id => p_rec.hrs_wkd_in_perd_rt_id);
790: --
791: hr_utility.set_location(' Leaving:'||l_proc, 10);
792: End delete_validate;
793: --
794: --
795: -- ---------------------------------------------------------------------------

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

814: l_proc varchar2(72) := g_package||'return_legislation_code';
815: --
816: begin
817: --
818: hr_utility.set_location('Entering:'|| l_proc, 10);
819: --
820: -- Ensure that all the mandatory parameter are not null
821: --
822: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

832: close csr_leg_code;
833: --
834: -- The primary key is invalid therefore we must error
835: --
836: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
837: hr_utility.raise_error;
838: --
839: end if;
840: --

Line 837: hr_utility.raise_error;

833: --
834: -- The primary key is invalid therefore we must error
835: --
836: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
837: hr_utility.raise_error;
838: --
839: end if;
840: --
841: close csr_leg_code;

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

839: end if;
840: --
841: close csr_leg_code;
842: --
843: hr_utility.set_location(' Leaving:'|| l_proc, 20);
844: --
845: return l_legislation_code;
846: --
847: end return_legislation_code;