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_LMM_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_lmm_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_lbr_mmbr_rt_id => p_lbr_mmbr_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_lbr_mmbr_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_lmm_shd.api_updating
118: (p_lbr_mmbr_rt_id => p_lbr_mmbr_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_lbr_mmbr_flag;
147:
148: --

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

202: and p_validation_end_date >= effective_start_date;
203: --
204: BEGIN
205: --
206: hr_utility.set_location('Entering:'||l_proc, 5);
207: --
208: l_api_updating := ben_lmm_shd.api_updating
209: (p_lbr_mmbr_rt_id => p_lbr_mmbr_rt_id,
210: p_effective_date => p_effective_date,

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

229: end if;
230: close c_dup;
231: --
232: end if;
233: hr_utility.set_location('Leaving:'||l_proc,10);
234: --
235: END chk_dup_record;
236:
237: --

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

277: and business_group_id + 0 = p_business_group_id
278: and ordr_num = p_ordr_num;
279: --
280: Begin
281: hr_utility.set_location('Entering:'||l_proc, 5);
282:
283: --
284: open c1;
285: fetch c1 into l_dummy;

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

289: fnd_message.raise_error;
290: end if;
291: close c1;
292: --
293: hr_utility.set_location('Leaving:'||l_proc, 15);
294: End chk_duplicate_ordr_num;
295:
296: -- ----------------------------------------------------------------------------
297: -- |------< chk_excld_flag >------|

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

328: l_api_updating boolean;
329: --
330: Begin
331: --
332: hr_utility.set_location('Entering:'||l_proc, 5);
333: --
334: l_api_updating := ben_lmm_shd.api_updating
335: (p_lbr_mmbr_rt_id => p_lbr_mmbr_rt_id,
336: p_effective_date => p_effective_date,

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

350: p_effective_date => p_effective_date) then
351: --
352: -- raise error as does not exist as lookup
353: --
354: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
355: hr_utility.raise_error;
356: --
357: end if;
358: --

Line 355: hr_utility.raise_error;

351: --
352: -- raise error as does not exist as lookup
353: --
354: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
355: hr_utility.raise_error;
356: --
357: end if;
358: --
359: end if;

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

357: end if;
358: --
359: end if;
360: --
361: hr_utility.set_location('Leaving:'||l_proc,10);
362: --
363: end chk_excld_flag;
364: --
365: -- ----------------------------------------------------------------------------

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

401: l_integrity_error Exception;
402: l_table_name all_tables.table_name%TYPE;
403: --
404: Begin
405: hr_utility.set_location('Entering:'||l_proc, 5);
406: --
407: -- Ensure that the p_datetrack_mode argument is not null
408: --
409: hr_api.mandatory_arg_error

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

440: End If;
441: --
442: End If;
443: --
444: hr_utility.set_location(' Leaving:'||l_proc, 10);
445: Exception
446: When l_integrity_error Then
447: --
448: -- A referential integrity check was violated therefore

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

453: --
454: -- An unhandled or unexpected error has occurred which
455: -- we must report
456: --
457: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
458: hr_utility.set_message_token('PROCEDURE', l_proc);
459: hr_utility.set_message_token('STEP','15');
460: hr_utility.raise_error;
461: End dt_update_validate;

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

454: -- An unhandled or unexpected error has occurred which
455: -- we must report
456: --
457: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
458: hr_utility.set_message_token('PROCEDURE', l_proc);
459: hr_utility.set_message_token('STEP','15');
460: hr_utility.raise_error;
461: End dt_update_validate;
462: --

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

455: -- we must report
456: --
457: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
458: hr_utility.set_message_token('PROCEDURE', l_proc);
459: hr_utility.set_message_token('STEP','15');
460: hr_utility.raise_error;
461: End dt_update_validate;
462: --
463: -- ----------------------------------------------------------------------------

Line 460: hr_utility.raise_error;

456: --
457: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
458: hr_utility.set_message_token('PROCEDURE', l_proc);
459: hr_utility.set_message_token('STEP','15');
460: hr_utility.raise_error;
461: End dt_update_validate;
462: --
463: -- ----------------------------------------------------------------------------
464: -- |--------------------------< dt_delete_validate >--------------------------|

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

505: l_rows_exist Exception;
506: l_table_name all_tables.table_name%TYPE;
507: --
508: Begin
509: hr_utility.set_location('Entering:'||l_proc, 5);
510: --
511: -- Ensure that the p_datetrack_mode argument is not null
512: --
513: hr_api.mandatory_arg_error

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

542: --
543: --
544: End If;
545: --
546: hr_utility.set_location(' Leaving:'||l_proc, 10);
547: Exception
548: When l_rows_exist Then
549: --
550: -- A referential integrity check was violated therefore

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

549: --
550: -- A referential integrity check was violated therefore
551: -- we must error
552: --
553: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
554: hr_utility.set_message_token('TABLE_NAME', l_table_name);
555: hr_utility.raise_error;
556: When Others Then
557: --

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

550: -- A referential integrity check was violated therefore
551: -- we must error
552: --
553: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
554: hr_utility.set_message_token('TABLE_NAME', l_table_name);
555: hr_utility.raise_error;
556: When Others Then
557: --
558: -- An unhandled or unexpected error has occurred which

Line 555: hr_utility.raise_error;

551: -- we must error
552: --
553: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
554: hr_utility.set_message_token('TABLE_NAME', l_table_name);
555: hr_utility.raise_error;
556: When Others Then
557: --
558: -- An unhandled or unexpected error has occurred which
559: -- we must report

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

557: --
558: -- An unhandled or unexpected error has occurred which
559: -- we must report
560: --
561: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
562: hr_utility.set_message_token('PROCEDURE', l_proc);
563: hr_utility.set_message_token('STEP','15');
564: hr_utility.raise_error;
565: End dt_delete_validate;

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

558: -- An unhandled or unexpected error has occurred which
559: -- we must report
560: --
561: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
562: hr_utility.set_message_token('PROCEDURE', l_proc);
563: hr_utility.set_message_token('STEP','15');
564: hr_utility.raise_error;
565: End dt_delete_validate;
566: --

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

559: -- we must report
560: --
561: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
562: hr_utility.set_message_token('PROCEDURE', l_proc);
563: hr_utility.set_message_token('STEP','15');
564: hr_utility.raise_error;
565: End dt_delete_validate;
566: --
567: -- ----------------------------------------------------------------------------

Line 564: hr_utility.raise_error;

560: --
561: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
562: hr_utility.set_message_token('PROCEDURE', l_proc);
563: hr_utility.set_message_token('STEP','15');
564: hr_utility.raise_error;
565: End dt_delete_validate;
566: --
567: -- ----------------------------------------------------------------------------
568: -- |---------------------------< insert_validate >----------------------------|

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

576: --
577: l_proc varchar2(72) := g_package||'insert_validate';
578: --
579: Begin
580: hr_utility.set_location('Entering:'||l_proc, 5);
581: --
582: -- Call all supporting business operations
583: --
584: --

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

617: ,p_effective_date => p_effective_date
618: ,p_business_group_id => p_rec.business_group_id
619: ,p_lbr_mmbr_rt_id => p_rec.lbr_mmbr_rt_id);
620: --
621: hr_utility.set_location(' Leaving:'||l_proc, 10);
622: End insert_validate;
623: --
624: -- ----------------------------------------------------------------------------
625: -- |---------------------------< update_validate >----------------------------|

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

633: --
634: l_proc varchar2(72) := g_package||'update_validate';
635: --
636: Begin
637: hr_utility.set_location('Entering:'||l_proc, 5);
638: --
639: -- Call all supporting business operations
640: --
641: --

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

682: ,p_effective_date => p_effective_date
683: ,p_business_group_id => p_rec.business_group_id
684: ,p_lbr_mmbr_rt_id => p_rec.lbr_mmbr_rt_id);
685: --
686: hr_utility.set_location(' Leaving:'||l_proc, 10);
687: End update_validate;
688: --
689: -- ----------------------------------------------------------------------------
690: -- |---------------------------< delete_validate >----------------------------|

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

698: --
699: l_proc varchar2(72) := g_package||'delete_validate';
700: --
701: Begin
702: hr_utility.set_location('Entering:'||l_proc, 5);
703: --
704: -- Call all supporting business operations
705: --
706: dt_delete_validate

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

708: p_validation_start_date => p_validation_start_date,
709: p_validation_end_date => p_validation_end_date,
710: p_lbr_mmbr_rt_id => p_rec.lbr_mmbr_rt_id);
711: --
712: hr_utility.set_location(' Leaving:'||l_proc, 10);
713: End delete_validate;
714: --
715: --
716: -- ---------------------------------------------------------------------------

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

735: l_proc varchar2(72) := g_package||'return_legislation_code';
736: --
737: begin
738: --
739: hr_utility.set_location('Entering:'|| l_proc, 10);
740: --
741: -- Ensure that all the mandatory parameter are not null
742: --
743: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

753: close csr_leg_code;
754: --
755: -- The primary key is invalid therefore we must error
756: --
757: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
758: hr_utility.raise_error;
759: --
760: end if;
761: --

Line 758: hr_utility.raise_error;

754: --
755: -- The primary key is invalid therefore we must error
756: --
757: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
758: hr_utility.raise_error;
759: --
760: end if;
761: --
762: close csr_leg_code;

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

760: end if;
761: --
762: close csr_leg_code;
763: --
764: hr_utility.set_location(' Leaving:'|| l_proc, 20);
765: --
766: return l_legislation_code;
767: --
768: end return_legislation_code;