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_PAT_BUS dependencies on HR_UTILITY

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

43: l_api_updating boolean;
44: --
45: Begin
46: --
47: hr_utility.set_location('Entering:'||l_proc, 5);
48: --
49: l_api_updating := ben_pat_shd.api_updating
50: (p_effective_date => p_effective_date,
51: p_popl_actn_typ_id => p_popl_actn_typ_id,

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

72: end if;
73: --
74: end if;
75: --
76: hr_utility.set_location('Leaving:'||l_proc, 10);
77: --
78: End chk_popl_actn_typ_id;
79: --
80: -- ----------------------------------------------------------------------------

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

123: and ff.effective_end_date;
124: --
125: Begin
126: --
127: hr_utility.set_location('Entering:'||l_proc, 5);
128: --
129: l_api_updating := ben_pat_shd.api_updating
130: (p_popl_actn_typ_id => p_popl_actn_typ_id,
131: p_effective_date => p_effective_date,

Line 154: hr_utility.set_message(801,'FORMULA_DOES_NOT_EXIST');

150: close c1;
151: --
152: -- raise error
153: --
154: hr_utility.set_message(801,'FORMULA_DOES_NOT_EXIST');
155: hr_utility.raise_error;
156: --
157: end if;
158: --

Line 155: hr_utility.raise_error;

151: --
152: -- raise error
153: --
154: hr_utility.set_message(801,'FORMULA_DOES_NOT_EXIST');
155: hr_utility.raise_error;
156: --
157: end if;
158: --
159: close c1;

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

159: close c1;
160: --
161: end if;
162: --
163: hr_utility.set_location('Leaving:'||l_proc,10);
164: --
165: end chk_actn_typ_due_dt_rl;
166: --
167: -- ----------------------------------------------------------------------------

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

200: l_api_updating boolean;
201: --
202: Begin
203: --
204: hr_utility.set_location('Entering:'||l_proc, 5);
205: --
206: l_api_updating := ben_pat_shd.api_updating
207: (p_popl_actn_typ_id => p_popl_actn_typ_id,
208: p_effective_date => p_effective_date,

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

231: end if;
232: --
233: end if;
234: --
235: hr_utility.set_location('Leaving:'||l_proc,10);
236: --
237: end chk_actn_typ_due_dt_cd;
238: --
239: -- ----------------------------------------------------------------------------

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

276: l_api_updating boolean;
277: --
278: Begin
279: --
280: hr_utility.set_location('Entering:'||l_proc, 5);
281: --
282: l_api_updating := ben_pat_shd.api_updating
283: (p_popl_actn_typ_id => p_popl_actn_typ_id,
284: p_effective_date => p_effective_date,

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

307: end if;
308: --
309: end if;
310: --
311: hr_utility.set_location('Leaving:'||l_proc,10);
312: --
313: end chk_actn_typ_due_dt_dpndcy;
314: --
315: -- ----------------------------------------------------------------------------

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

401: End If;
402: --
403: End If;
404: --
405: hr_utility.set_location(' Leaving:'||l_proc, 10);
406: Exception
407: When l_integrity_error Then
408: --
409: -- A referential integrity check was violated therefore

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

408: --
409: -- A referential integrity check was violated therefore
410: -- we must error
411: --
412: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
413: hr_utility.set_message_token('TABLE_NAME', l_table_name);
414: hr_utility.raise_error;
415: When Others Then
416: --

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

409: -- A referential integrity check was violated therefore
410: -- we must error
411: --
412: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
413: hr_utility.set_message_token('TABLE_NAME', l_table_name);
414: hr_utility.raise_error;
415: When Others Then
416: --
417: -- An unhandled or unexpected error has occurred which

Line 414: hr_utility.raise_error;

410: -- we must error
411: --
412: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
413: hr_utility.set_message_token('TABLE_NAME', l_table_name);
414: hr_utility.raise_error;
415: When Others Then
416: --
417: -- An unhandled or unexpected error has occurred which
418: -- we must report

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

416: --
417: -- An unhandled or unexpected error has occurred which
418: -- we must report
419: --
420: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
421: hr_utility.set_message_token('PROCEDURE', l_proc);
422: hr_utility.set_message_token('STEP','15');
423: hr_utility.raise_error;
424: End dt_update_validate;

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

417: -- An unhandled or unexpected error has occurred which
418: -- we must report
419: --
420: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
421: hr_utility.set_message_token('PROCEDURE', l_proc);
422: hr_utility.set_message_token('STEP','15');
423: hr_utility.raise_error;
424: End dt_update_validate;
425: --

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

418: -- we must report
419: --
420: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
421: hr_utility.set_message_token('PROCEDURE', l_proc);
422: hr_utility.set_message_token('STEP','15');
423: hr_utility.raise_error;
424: End dt_update_validate;
425: --
426: -- ----------------------------------------------------------------------------

Line 423: hr_utility.raise_error;

419: --
420: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
421: hr_utility.set_message_token('PROCEDURE', l_proc);
422: hr_utility.set_message_token('STEP','15');
423: hr_utility.raise_error;
424: End dt_update_validate;
425: --
426: -- ----------------------------------------------------------------------------
427: -- |--------------------------< dt_delete_validate >--------------------------|

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

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

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

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

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

512: --
513: -- A referential integrity check was violated therefore
514: -- we must error
515: --
516: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
517: hr_utility.set_message_token('TABLE_NAME', l_table_name);
518: hr_utility.raise_error;
519: When Others Then
520: --

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

513: -- A referential integrity check was violated therefore
514: -- we must error
515: --
516: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
517: hr_utility.set_message_token('TABLE_NAME', l_table_name);
518: hr_utility.raise_error;
519: When Others Then
520: --
521: -- An unhandled or unexpected error has occurred which

Line 518: hr_utility.raise_error;

514: -- we must error
515: --
516: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
517: hr_utility.set_message_token('TABLE_NAME', l_table_name);
518: hr_utility.raise_error;
519: When Others Then
520: --
521: -- An unhandled or unexpected error has occurred which
522: -- we must report

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

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

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

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

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

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

Line 527: hr_utility.raise_error;

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

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

539: --
540: l_proc varchar2(72) := g_package||'insert_validate';
541: --
542: Begin
543: hr_utility.set_location('Entering:'||l_proc, 5);
544: --
545: -- Call all supporting business operations
546: --
547: --

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

570: p_actn_typ_due_dt_rl => p_rec.actn_typ_due_dt_rl,
571: p_effective_date => p_effective_date,
572: p_object_version_number => p_rec.object_version_number);
573: --
574: hr_utility.set_location(' Leaving:'||l_proc, 10);
575: End insert_validate;
576: --
577: -- ----------------------------------------------------------------------------
578: -- |---------------------------< update_validate >----------------------------|

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

586: --
587: l_proc varchar2(72) := g_package||'update_validate';
588: --
589: Begin
590: hr_utility.set_location('Entering:'||l_proc, 5);
591: --
592: -- Call all supporting business operations
593: --
594: --

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

626: p_datetrack_mode => p_datetrack_mode,
627: p_validation_start_date => p_validation_start_date,
628: p_validation_end_date => p_validation_end_date);
629: --
630: hr_utility.set_location(' Leaving:'||l_proc, 10);
631: End update_validate;
632: --
633: -- ----------------------------------------------------------------------------
634: -- |---------------------------< delete_validate >----------------------------|

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

642: --
643: l_proc varchar2(72) := g_package||'delete_validate';
644: --
645: Begin
646: hr_utility.set_location('Entering:'||l_proc, 5);
647: --
648: -- Call all supporting business operations
649: --
650: dt_delete_validate

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

652: p_validation_start_date => p_validation_start_date,
653: p_validation_end_date => p_validation_end_date,
654: p_popl_actn_typ_id => p_rec.popl_actn_typ_id);
655: --
656: hr_utility.set_location(' Leaving:'||l_proc, 10);
657: End delete_validate;
658: --
659: --
660: -- ---------------------------------------------------------------------------

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

679: l_proc varchar2(72) := g_package||'return_legislation_code';
680: --
681: begin
682: --
683: hr_utility.set_location('Entering:'|| l_proc, 10);
684: --
685: -- Ensure that all the mandatory parameter are not null
686: --
687: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

697: close csr_leg_code;
698: --
699: -- The primary key is invalid therefore we must error
700: --
701: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
702: hr_utility.raise_error;
703: --
704: end if;
705: --

Line 702: hr_utility.raise_error;

698: --
699: -- The primary key is invalid therefore we must error
700: --
701: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
702: hr_utility.raise_error;
703: --
704: end if;
705: --
706: close csr_leg_code;

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

704: end if;
705: --
706: close csr_leg_code;
707: --
708: hr_utility.set_location(' Leaving:'|| l_proc, 20);
709: --
710: return l_legislation_code;
711: --
712: end return_legislation_code;