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_LGL_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_lgl_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_lgl_enty_rt_id => p_lgl_enty_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_lgl_enty_rt_id;
78: --
79: --

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

118: --
119:
120: Begin
121: --
122: hr_utility.set_location('Entering:'||l_proc, 5);
123: --
124: if p_organization_id is not null then
125: open c1;
126: fetch c1 into l_dummy;

Line 128: hr_utility.set_message(801,'Org_Id_not_exist');

124: if p_organization_id is not null then
125: open c1;
126: fetch c1 into l_dummy;
127: if c1%notfound then
128: hr_utility.set_message(801,'Org_Id_not_exist');
129: hr_utility.raise_error;
130: end if;
131: close c1;
132: end if;

Line 129: hr_utility.raise_error;

125: open c1;
126: fetch c1 into l_dummy;
127: if c1%notfound then
128: hr_utility.set_message(801,'Org_Id_not_exist');
129: hr_utility.raise_error;
130: end if;
131: close c1;
132: end if;
133: --

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

130: end if;
131: close c1;
132: end if;
133: --
134: hr_utility.set_location('Leaving:'||l_proc, 10);
135: --
136: End chk_organization_id;
137: --
138: --

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

192: and p_validation_end_date >= effective_start_date;
193: --
194: BEGIN
195: --
196: hr_utility.set_location('Entering:'||l_proc, 5);
197: --
198: l_api_updating := ben_lgl_shd.api_updating
199: (p_lgl_enty_rt_id => p_lgl_enty_rt_id,
200: p_effective_date => p_effective_date,

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

219: end if;
220: close c_dup;
221: --
222: end if;
223: hr_utility.set_location('Leaving:'||l_proc,10);
224: --
225: END chk_dup_record;
226:
227:

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

267: and business_group_id + 0 = p_business_group_id
268: and ordr_num = p_ordr_num;
269: --
270: Begin
271: hr_utility.set_location('Entering:'||l_proc, 5);
272:
273: --
274: open c1;
275: fetch c1 into l_dummy;

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

279: fnd_message.raise_error;
280: end if;
281: close c1;
282: --
283: hr_utility.set_location('Leaving:'||l_proc, 15);
284: End chk_duplicate_ordr_num;
285:
286: --
287: -- ----------------------------------------------------------------------------

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

319: l_api_updating boolean;
320: --
321: Begin
322: --
323: hr_utility.set_location('Entering:'||l_proc, 5);
324: --
325: l_api_updating := ben_lgl_shd.api_updating
326: (p_lgl_enty_rt_id => p_lgl_enty_rt_id,
327: p_effective_date => p_effective_date,

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

341: p_effective_date => p_effective_date) then
342: --
343: -- raise error as does not exist as lookup
344: --
345: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
346: hr_utility.raise_error;
347: --
348: end if;
349: --

Line 346: hr_utility.raise_error;

342: --
343: -- raise error as does not exist as lookup
344: --
345: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
346: hr_utility.raise_error;
347: --
348: end if;
349: --
350: end if;

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

348: end if;
349: --
350: end if;
351: --
352: hr_utility.set_location('Leaving:'||l_proc,10);
353: --
354: end chk_excld_flag;
355: --
356: -- ----------------------------------------------------------------------------

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

392: l_integrity_error Exception;
393: l_table_name all_tables.table_name%TYPE;
394: --
395: Begin
396: hr_utility.set_location('Entering:'||l_proc, 5);
397: --
398: -- Ensure that the p_datetrack_mode argument is not null
399: --
400: hr_api.mandatory_arg_error

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

431: End If;
432: --
433: End If;
434: --
435: hr_utility.set_location(' Leaving:'||l_proc, 10);
436: Exception
437: When l_integrity_error Then
438: --
439: -- A referential integrity check was violated therefore

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

445: --
446: -- An unhandled or unexpected error has occurred which
447: -- we must report
448: --
449: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
450: hr_utility.set_message_token('PROCEDURE', l_proc);
451: hr_utility.set_message_token('STEP','15');
452: hr_utility.raise_error;
453: End dt_update_validate;

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

446: -- An unhandled or unexpected error has occurred which
447: -- we must report
448: --
449: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
450: hr_utility.set_message_token('PROCEDURE', l_proc);
451: hr_utility.set_message_token('STEP','15');
452: hr_utility.raise_error;
453: End dt_update_validate;
454: --

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

447: -- we must report
448: --
449: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
450: hr_utility.set_message_token('PROCEDURE', l_proc);
451: hr_utility.set_message_token('STEP','15');
452: hr_utility.raise_error;
453: End dt_update_validate;
454: --
455: -- ----------------------------------------------------------------------------

Line 452: hr_utility.raise_error;

448: --
449: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
450: hr_utility.set_message_token('PROCEDURE', l_proc);
451: hr_utility.set_message_token('STEP','15');
452: hr_utility.raise_error;
453: End dt_update_validate;
454: --
455: -- ----------------------------------------------------------------------------
456: -- |--------------------------< dt_delete_validate >--------------------------|

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

497: l_rows_exist Exception;
498: l_table_name all_tables.table_name%TYPE;
499: --
500: Begin
501: hr_utility.set_location('Entering:'||l_proc, 5);
502: --
503: -- Ensure that the p_datetrack_mode argument is not null
504: --
505: hr_api.mandatory_arg_error

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

534: --
535: --
536: End If;
537: --
538: hr_utility.set_location(' Leaving:'||l_proc, 10);
539: Exception
540: When l_rows_exist Then
541: --
542: -- A referential integrity check was violated therefore

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

541: --
542: -- A referential integrity check was violated therefore
543: -- we must error
544: --
545: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
546: hr_utility.set_message_token('TABLE_NAME', l_table_name);
547: hr_utility.raise_error;
548: When Others Then
549: --

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

542: -- A referential integrity check was violated therefore
543: -- we must error
544: --
545: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
546: hr_utility.set_message_token('TABLE_NAME', l_table_name);
547: hr_utility.raise_error;
548: When Others Then
549: --
550: -- An unhandled or unexpected error has occurred which

Line 547: hr_utility.raise_error;

543: -- we must error
544: --
545: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
546: hr_utility.set_message_token('TABLE_NAME', l_table_name);
547: hr_utility.raise_error;
548: When Others Then
549: --
550: -- An unhandled or unexpected error has occurred which
551: -- we must report

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

549: --
550: -- An unhandled or unexpected error has occurred which
551: -- we must report
552: --
553: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
554: hr_utility.set_message_token('PROCEDURE', l_proc);
555: hr_utility.set_message_token('STEP','15');
556: hr_utility.raise_error;
557: End dt_delete_validate;

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

550: -- An unhandled or unexpected error has occurred which
551: -- we must report
552: --
553: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
554: hr_utility.set_message_token('PROCEDURE', l_proc);
555: hr_utility.set_message_token('STEP','15');
556: hr_utility.raise_error;
557: End dt_delete_validate;
558: --

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

551: -- we must report
552: --
553: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
554: hr_utility.set_message_token('PROCEDURE', l_proc);
555: hr_utility.set_message_token('STEP','15');
556: hr_utility.raise_error;
557: End dt_delete_validate;
558: --
559: -- ----------------------------------------------------------------------------

Line 556: hr_utility.raise_error;

552: --
553: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
554: hr_utility.set_message_token('PROCEDURE', l_proc);
555: hr_utility.set_message_token('STEP','15');
556: hr_utility.raise_error;
557: End dt_delete_validate;
558: --
559: -- ----------------------------------------------------------------------------
560: -- |---------------------------< insert_validate >----------------------------|

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

568: --
569: l_proc varchar2(72) := g_package||'insert_validate';
570: --
571: Begin
572: hr_utility.set_location('Entering:'||l_proc, 5);
573: --
574: -- Call all supporting business operations
575: --
576: --

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

608: ,p_effective_date => p_effective_date
609: ,p_business_group_id => p_rec.business_group_id
610: ,p_lgl_enty_rt_id => p_rec.lgl_enty_rt_id);
611: --
612: hr_utility.set_location(' Leaving:'||l_proc, 10);
613: End insert_validate;
614: --
615: -- ----------------------------------------------------------------------------
616: -- |---------------------------< update_validate >----------------------------|

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

624: --
625: l_proc varchar2(72) := g_package||'update_validate';
626: --
627: Begin
628: hr_utility.set_location('Entering:'||l_proc, 5);
629: --
630: -- Call all supporting business operations
631: --
632: --

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

672: ,p_effective_date => p_effective_date
673: ,p_business_group_id => p_rec.business_group_id
674: ,p_lgl_enty_rt_id => p_rec.lgl_enty_rt_id);
675: --
676: hr_utility.set_location(' Leaving:'||l_proc, 10);
677: End update_validate;
678: --
679: -- ----------------------------------------------------------------------------
680: -- |---------------------------< delete_validate >----------------------------|

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

688: --
689: l_proc varchar2(72) := g_package||'delete_validate';
690: --
691: Begin
692: hr_utility.set_location('Entering:'||l_proc, 5);
693: --
694: -- Call all supporting business operations
695: --
696: dt_delete_validate

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

698: p_validation_start_date => p_validation_start_date,
699: p_validation_end_date => p_validation_end_date,
700: p_lgl_enty_rt_id => p_rec.lgl_enty_rt_id);
701: --
702: hr_utility.set_location(' Leaving:'||l_proc, 10);
703: End delete_validate;
704: --
705: --
706: -- ---------------------------------------------------------------------------

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

725: l_proc varchar2(72) := g_package||'return_legislation_code';
726: --
727: begin
728: --
729: hr_utility.set_location('Entering:'|| l_proc, 10);
730: --
731: -- Ensure that all the mandatory parameter are not null
732: --
733: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

743: close csr_leg_code;
744: --
745: -- The primary key is invalid therefore we must error
746: --
747: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
748: hr_utility.raise_error;
749: --
750: end if;
751: --

Line 748: hr_utility.raise_error;

744: --
745: -- The primary key is invalid therefore we must error
746: --
747: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
748: hr_utility.raise_error;
749: --
750: end if;
751: --
752: close csr_leg_code;

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

750: end if;
751: --
752: close csr_leg_code;
753: --
754: hr_utility.set_location(' Leaving:'|| l_proc, 20);
755: --
756: return l_legislation_code;
757: --
758: end return_legislation_code;