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_CMR_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_cmr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_cmbn_age_los_rt_id => p_cmbn_age_los_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_cmbn_age_los_rt_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_cmr_shd.api_updating
118: (p_cmbn_age_los_rt_id => p_cmbn_age_los_rt_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_excld_flag;
147: --
148: -- ----------------------------------------------------------------------------

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

182: --
183:
184: Begin
185: --
186: hr_utility.set_location('Entering:'||l_proc, 5);
187: --
188: if p_cmbn_age_los_fctr_id is not null then
189: open c1;
190: fetch c1 into l_dummy;

Line 192: hr_utility.set_message(801,'Cmbn_age_los_fctr');

188: if p_cmbn_age_los_fctr_id is not null then
189: open c1;
190: fetch c1 into l_dummy;
191: if c1%notfound then
192: hr_utility.set_message(801,'Cmbn_age_los_fctr');
193: hr_utility.raise_error;
194: end if;
195: close c1;
196: end if;

Line 193: hr_utility.raise_error;

189: open c1;
190: fetch c1 into l_dummy;
191: if c1%notfound then
192: hr_utility.set_message(801,'Cmbn_age_los_fctr');
193: hr_utility.raise_error;
194: end if;
195: close c1;
196: end if;
197: --

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

194: end if;
195: close c1;
196: end if;
197: --
198: hr_utility.set_location('Leaving:'||l_proc, 10);
199: --
200: End chk_cmbn_age_los_fctr_id;
201: --
202: -- ----------------------------------------------------------------------------

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

255: and p_validation_end_date >= effective_start_date;
256: --
257: BEGIN
258: --
259: hr_utility.set_location('Entering:'||l_proc, 5);
260: --
261: l_api_updating := ben_cmr_shd.api_updating
262: (p_cmbn_age_los_rt_id => p_cmbn_age_los_rt_id,
263: p_effective_date => p_effective_date,

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

282: end if;
283: close c_dup;
284: --
285: end if;
286: hr_utility.set_location('Leaving:'||l_proc,10);
287: --
288: END chk_dup_record;
289: --
290: -- added for Bug 5078478 .. add this procedure to check the duplicate seq no

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

338: and business_group_id + 0 = p_business_group_id
339: and ordr_num = p_ordr_num;
340: --
341: Begin
342: hr_utility.set_location('Entering:'||l_proc, 5);
343:
344: --
345: open c1;
346: fetch c1 into l_dummy;

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

350: fnd_message.raise_error;
351: end if;
352: close c1;
353: --
354: hr_utility.set_location('Leaving:'||l_proc, 15);
355: End chk_duplicate_ordr_num;
356: --
357: -- ----------------------------------------------------------------------------
358: -- |--------------------------< dt_update_validate >--------------------------|

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

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

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

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

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

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

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

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

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

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

Line 453: hr_utility.raise_error;

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

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

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

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

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

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 613: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 749: hr_utility.raise_error;

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

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

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