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_ELN_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_eln_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_lgl_enty_prte_id => p_elig_lgl_enty_prte_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_elig_lgl_enty_prte_id;
78: --
79: -- ----------------------------------------------------------------------------

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

134: --
135: --
136: Begin
137: --
138: hr_utility.set_location('Entering:'||l_proc,5);
139: --
140: l_api_updating := ben_eln_shd.api_updating
141: (p_elig_lgl_enty_prte_id => p_elig_lgl_enty_prte_id,
142: p_effective_date => p_effective_date,

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

181: close c3;
182: --
183: end if;
184: --
185: hr_utility.set_location('Leaving:'||l_proc,10);
186: --
187: End chk_organization_id;
188: --
189: -- ----------------------------------------------------------------------------

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

221: l_api_updating boolean;
222: --
223: Begin
224: --
225: hr_utility.set_location('Entering:'||l_proc, 5);
226: --
227: l_api_updating := ben_eln_shd.api_updating
228: (p_elig_lgl_enty_prte_id => p_elig_lgl_enty_prte_id,
229: p_effective_date => p_effective_date,

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

243: p_effective_date => p_effective_date) then
244: --
245: -- raise error as does not exist as lookup
246: --
247: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
248: hr_utility.raise_error;
249: --
250: end if;
251: --

Line 248: hr_utility.raise_error;

244: --
245: -- raise error as does not exist as lookup
246: --
247: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
248: hr_utility.raise_error;
249: --
250: end if;
251: --
252: end if;

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

250: end if;
251: --
252: end if;
253: --
254: hr_utility.set_location('Leaving:'||l_proc,10);
255: --
256: end chk_excld_flag;
257: --
258: --Bug:5054189

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

299: and ordr_num = p_ordr_num
300: and business_group_id = p_business_group_id;
301: --
302: Begin
303: hr_utility.set_location('Entering:'||l_proc, 5);
304: --
305: open c1;
306: fetch c1 into l_dummy;
307: if c1%found then

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

310: fnd_message.raise_error;
311: end if;
312: close c1;
313: --
314: hr_utility.set_location('Leaving:'||l_proc, 15);
315: End chk_duplicate_ordr_num;
316: -- ----------------------------------------------------------------------------
317: -- |--------------------------< dt_update_validate >--------------------------|
318: -- ----------------------------------------------------------------------------

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

352: l_integrity_error Exception;
353: l_table_name all_tables.table_name%TYPE;
354: --
355: Begin
356: hr_utility.set_location('Entering:'||l_proc, 5);
357: --
358: -- Ensure that the p_datetrack_mode argument is not null
359: --
360: hr_api.mandatory_arg_error

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

391: End If;
392: --
393: End If;
394: --
395: hr_utility.set_location(' Leaving:'||l_proc, 10);
396: Exception
397: When l_integrity_error Then
398: --
399: -- A referential integrity check was violated therefore

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

398: --
399: -- A referential integrity check was violated therefore
400: -- we must error
401: --
402: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
403: hr_utility.set_message_token('TABLE_NAME', l_table_name);
404: hr_utility.raise_error;
405: When Others Then
406: --

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

399: -- A referential integrity check was violated therefore
400: -- we must error
401: --
402: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
403: hr_utility.set_message_token('TABLE_NAME', l_table_name);
404: hr_utility.raise_error;
405: When Others Then
406: --
407: -- An unhandled or unexpected error has occurred which

Line 404: hr_utility.raise_error;

400: -- we must error
401: --
402: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
403: hr_utility.set_message_token('TABLE_NAME', l_table_name);
404: hr_utility.raise_error;
405: When Others Then
406: --
407: -- An unhandled or unexpected error has occurred which
408: -- we must report

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

406: --
407: -- An unhandled or unexpected error has occurred which
408: -- we must report
409: --
410: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
411: hr_utility.set_message_token('PROCEDURE', l_proc);
412: hr_utility.set_message_token('STEP','15');
413: hr_utility.raise_error;
414: End dt_update_validate;

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

407: -- An unhandled or unexpected error has occurred which
408: -- we must report
409: --
410: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
411: hr_utility.set_message_token('PROCEDURE', l_proc);
412: hr_utility.set_message_token('STEP','15');
413: hr_utility.raise_error;
414: End dt_update_validate;
415: --

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

408: -- we must report
409: --
410: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
411: hr_utility.set_message_token('PROCEDURE', l_proc);
412: hr_utility.set_message_token('STEP','15');
413: hr_utility.raise_error;
414: End dt_update_validate;
415: --
416: -- ----------------------------------------------------------------------------

Line 413: hr_utility.raise_error;

409: --
410: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
411: hr_utility.set_message_token('PROCEDURE', l_proc);
412: hr_utility.set_message_token('STEP','15');
413: hr_utility.raise_error;
414: End dt_update_validate;
415: --
416: -- ----------------------------------------------------------------------------
417: -- |--------------------------< dt_delete_validate >--------------------------|

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

458: l_rows_exist Exception;
459: l_table_name all_tables.table_name%TYPE;
460: --
461: Begin
462: hr_utility.set_location('Entering:'||l_proc, 5);
463: --
464: -- Ensure that the p_datetrack_mode argument is not null
465: --
466: hr_api.mandatory_arg_error

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

495: --
496: --
497: End If;
498: --
499: hr_utility.set_location(' Leaving:'||l_proc, 10);
500: Exception
501: When l_rows_exist Then
502: --
503: -- A referential integrity check was violated therefore

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

502: --
503: -- A referential integrity check was violated therefore
504: -- we must error
505: --
506: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
507: hr_utility.set_message_token('TABLE_NAME', l_table_name);
508: hr_utility.raise_error;
509: When Others Then
510: --

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

503: -- A referential integrity check was violated therefore
504: -- we must error
505: --
506: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
507: hr_utility.set_message_token('TABLE_NAME', l_table_name);
508: hr_utility.raise_error;
509: When Others Then
510: --
511: -- An unhandled or unexpected error has occurred which

Line 508: hr_utility.raise_error;

504: -- we must error
505: --
506: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
507: hr_utility.set_message_token('TABLE_NAME', l_table_name);
508: hr_utility.raise_error;
509: When Others Then
510: --
511: -- An unhandled or unexpected error has occurred which
512: -- we must report

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

510: --
511: -- An unhandled or unexpected error has occurred which
512: -- we must report
513: --
514: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
515: hr_utility.set_message_token('PROCEDURE', l_proc);
516: hr_utility.set_message_token('STEP','15');
517: hr_utility.raise_error;
518: End dt_delete_validate;

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

511: -- An unhandled or unexpected error has occurred which
512: -- we must report
513: --
514: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
515: hr_utility.set_message_token('PROCEDURE', l_proc);
516: hr_utility.set_message_token('STEP','15');
517: hr_utility.raise_error;
518: End dt_delete_validate;
519: --

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

512: -- we must report
513: --
514: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
515: hr_utility.set_message_token('PROCEDURE', l_proc);
516: hr_utility.set_message_token('STEP','15');
517: hr_utility.raise_error;
518: End dt_delete_validate;
519: --
520: -- ----------------------------------------------------------------------------

Line 517: hr_utility.raise_error;

513: --
514: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
515: hr_utility.set_message_token('PROCEDURE', l_proc);
516: hr_utility.set_message_token('STEP','15');
517: hr_utility.raise_error;
518: End dt_delete_validate;
519: --
520: -- ----------------------------------------------------------------------------
521: -- |---------------------------< insert_validate >----------------------------|

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

529: --
530: l_proc varchar2(72) := g_package||'insert_validate';
531: --
532: Begin
533: hr_utility.set_location('Entering:'||l_proc, 5);
534: --
535: -- Call all supporting business operations
536: --
537: --

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

563: ,p_eligy_prfl_id => p_rec.eligy_prfl_id
564: ,p_ordr_num => p_rec.ordr_num
565: ,p_business_group_id => p_rec.business_group_id);
566: --
567: hr_utility.set_location(' Leaving:'||l_proc, 10);
568: End insert_validate;
569: --
570: -- ----------------------------------------------------------------------------
571: -- |---------------------------< update_validate >----------------------------|

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

579: --
580: l_proc varchar2(72) := g_package||'update_validate';
581: --
582: Begin
583: hr_utility.set_location('Entering:'||l_proc, 5);
584: --
585: -- Call all supporting business operations
586: --
587: --

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

621: p_datetrack_mode => p_datetrack_mode,
622: p_validation_start_date => p_validation_start_date,
623: p_validation_end_date => p_validation_end_date);
624: --
625: hr_utility.set_location(' Leaving:'||l_proc, 10);
626: End update_validate;
627: --
628: -- ----------------------------------------------------------------------------
629: -- |---------------------------< delete_validate >----------------------------|

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

637: --
638: l_proc varchar2(72) := g_package||'delete_validate';
639: --
640: Begin
641: hr_utility.set_location('Entering:'||l_proc, 5);
642: --
643: -- Call all supporting business operations
644: --
645: dt_delete_validate

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

647: p_validation_start_date => p_validation_start_date,
648: p_validation_end_date => p_validation_end_date,
649: p_elig_lgl_enty_prte_id => p_rec.elig_lgl_enty_prte_id);
650: --
651: hr_utility.set_location(' Leaving:'||l_proc, 10);
652: End delete_validate;
653: --
654: --
655: -- ---------------------------------------------------------------------------

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

674: l_proc varchar2(72) := g_package||'return_legislation_code';
675: --
676: begin
677: --
678: hr_utility.set_location('Entering:'|| l_proc, 10);
679: --
680: -- Ensure that all the mandatory parameter are not null
681: --
682: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

692: close csr_leg_code;
693: --
694: -- The primary key is invalid therefore we must error
695: --
696: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
697: hr_utility.raise_error;
698: --
699: end if;
700: --

Line 697: hr_utility.raise_error;

693: --
694: -- The primary key is invalid therefore we must error
695: --
696: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
697: hr_utility.raise_error;
698: --
699: end if;
700: --
701: close csr_leg_code;

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

699: end if;
700: --
701: close csr_leg_code;
702: --
703: hr_utility.set_location(' Leaving:'|| l_proc, 20);
704: --
705: return l_legislation_code;
706: --
707: end return_legislation_code;