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_PTR_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_ptr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_per_typ_rt_id => p_per_typ_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_per_typ_rt_id;
78: --
79: -- ----------------------------------------------------------------------------

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

137: l_person_type_id c_person_type_id%rowtype;
138: --
139: Begin
140: --
141: hr_utility.set_location('Entering:'||l_proc, 5);
142: --
143: l_api_updating := ben_ptr_shd.api_updating
144: (p_per_typ_rt_id => p_per_typ_rt_id,
145: p_effective_date => p_effective_date,

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

170: close c_person_type_id;
171: --
172: -- raise error as does not exist as lookup
173: --
174: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
175: hr_utility.raise_error;
176: --
177: end if;
178: close c_person_type_id;

Line 175: hr_utility.raise_error;

171: --
172: -- raise error as does not exist as lookup
173: --
174: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
175: hr_utility.raise_error;
176: --
177: end if;
178: close c_person_type_id;
179: --

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

196: end if;
197: -- end bug # 2375772
198:
199: --
200: hr_utility.set_location('Leaving:'||l_proc,10);
201: --
202: end chk_per_typ_cd;
203: --
204: -- |--------------------< chk_duplicate_ordr_num >----------------------------|

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

243: and business_group_id + 0 = p_business_group_id
244: and ordr_num = p_ordr_num;
245: --
246: Begin
247: hr_utility.set_location('Entering:'||l_proc, 5);
248:
249: --
250: open c1;
251: fetch c1 into l_dummy;

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

255: fnd_message.raise_error;
256: end if;
257: close c1;
258: --
259: hr_utility.set_location('Leaving:'||l_proc, 15);
260: End chk_duplicate_ordr_num;
261:
262: --
263: -- ----------------------------------------------------------------------------

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

295: l_api_updating boolean;
296: --
297: Begin
298: --
299: hr_utility.set_location('Entering:'||l_proc, 5);
300: --
301: l_api_updating := ben_ptr_shd.api_updating
302: (p_per_typ_rt_id => p_per_typ_rt_id,
303: p_effective_date => p_effective_date,

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

317: p_effective_date => p_effective_date) then
318: --
319: -- raise error as does not exist as lookup
320: --
321: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
322: hr_utility.raise_error;
323: --
324: end if;
325: --

Line 322: hr_utility.raise_error;

318: --
319: -- raise error as does not exist as lookup
320: --
321: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
322: hr_utility.raise_error;
323: --
324: end if;
325: --
326: end if;

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

324: end if;
325: --
326: end if;
327: --
328: hr_utility.set_location('Leaving:'||l_proc,10);
329: --
330: end chk_excld_flag;
331: --
332: -- ----------------------------------------------------------------------------

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

368: l_integrity_error Exception;
369: l_table_name all_tables.table_name%TYPE;
370: --
371: Begin
372: hr_utility.set_location('Entering:'||l_proc, 5);
373: --
374: -- Ensure that the p_datetrack_mode argument is not null
375: --
376: hr_api.mandatory_arg_error

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

407: End If;
408: --
409: End If;
410: --
411: hr_utility.set_location(' Leaving:'||l_proc, 10);
412: Exception
413: When l_integrity_error Then
414: --
415: -- A referential integrity check was violated therefore

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

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

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

422: -- An unhandled or unexpected error has occurred which
423: -- we must report
424: --
425: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
426: hr_utility.set_message_token('PROCEDURE', l_proc);
427: hr_utility.set_message_token('STEP','15');
428: hr_utility.raise_error;
429: End dt_update_validate;
430: --

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

423: -- we must report
424: --
425: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
426: hr_utility.set_message_token('PROCEDURE', l_proc);
427: hr_utility.set_message_token('STEP','15');
428: hr_utility.raise_error;
429: End dt_update_validate;
430: --
431: -- ----------------------------------------------------------------------------

Line 428: hr_utility.raise_error;

424: --
425: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
426: hr_utility.set_message_token('PROCEDURE', l_proc);
427: hr_utility.set_message_token('STEP','15');
428: hr_utility.raise_error;
429: End dt_update_validate;
430: --
431: -- ----------------------------------------------------------------------------
432: -- |--------------------------< dt_delete_validate >--------------------------|

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

473: l_rows_exist Exception;
474: l_table_name all_tables.table_name%TYPE;
475: --
476: Begin
477: hr_utility.set_location('Entering:'||l_proc, 5);
478: --
479: -- Ensure that the p_datetrack_mode argument is not null
480: --
481: hr_api.mandatory_arg_error

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

510: --
511: --
512: End If;
513: --
514: hr_utility.set_location(' Leaving:'||l_proc, 10);
515: Exception
516: When l_rows_exist Then
517: --
518: -- A referential integrity check was violated therefore

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

517: --
518: -- A referential integrity check was violated therefore
519: -- we must error
520: --
521: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
522: hr_utility.set_message_token('TABLE_NAME', l_table_name);
523: hr_utility.raise_error;
524: When Others Then
525: --

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

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

Line 523: hr_utility.raise_error;

519: -- we must error
520: --
521: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
522: hr_utility.set_message_token('TABLE_NAME', l_table_name);
523: hr_utility.raise_error;
524: When Others Then
525: --
526: -- An unhandled or unexpected error has occurred which
527: -- we must report

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

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

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

526: -- An unhandled or unexpected error has occurred which
527: -- we must report
528: --
529: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
530: hr_utility.set_message_token('PROCEDURE', l_proc);
531: hr_utility.set_message_token('STEP','15');
532: hr_utility.raise_error;
533: End dt_delete_validate;
534: --

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

527: -- we must report
528: --
529: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
530: hr_utility.set_message_token('PROCEDURE', l_proc);
531: hr_utility.set_message_token('STEP','15');
532: hr_utility.raise_error;
533: End dt_delete_validate;
534: --
535: -- ----------------------------------------------------------------------------

Line 532: hr_utility.raise_error;

528: --
529: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
530: hr_utility.set_message_token('PROCEDURE', l_proc);
531: hr_utility.set_message_token('STEP','15');
532: hr_utility.raise_error;
533: End dt_delete_validate;
534: --
535: -- ----------------------------------------------------------------------------
536: -- |---------------------------< insert_validate >----------------------------|

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

544: --
545: l_proc varchar2(72) := g_package||'insert_validate';
546: --
547: Begin
548: hr_utility.set_location('Entering:'||l_proc, 5);
549: --
550: -- Call all supporting business operations
551: --
552: --

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

580: ,p_ordr_num => p_rec.ordr_num
581: -- ,p_effective_date => p_effective_date
582: ,p_business_group_id => p_rec.business_group_id);
583: --
584: hr_utility.set_location(' Leaving:'||l_proc, 10);
585: End insert_validate;
586: --
587: -- ----------------------------------------------------------------------------
588: -- |---------------------------< update_validate >----------------------------|

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

596: --
597: l_proc varchar2(72) := g_package||'update_validate';
598: --
599: Begin
600: hr_utility.set_location('Entering:'||l_proc, 5);
601: --
602: -- Call all supporting business operations
603: --
604: --

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

640: ,p_ordr_num => p_rec.ordr_num
641: -- ,p_effective_date => p_effective_date
642: ,p_business_group_id => p_rec.business_group_id);
643: --
644: hr_utility.set_location(' Leaving:'||l_proc, 10);
645: End update_validate;
646: --
647: -- ----------------------------------------------------------------------------
648: -- |---------------------------< delete_validate >----------------------------|

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

656: --
657: l_proc varchar2(72) := g_package||'delete_validate';
658: --
659: Begin
660: hr_utility.set_location('Entering:'||l_proc, 5);
661: --
662: -- Call all supporting business operations
663: --
664: dt_delete_validate

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

666: p_validation_start_date => p_validation_start_date,
667: p_validation_end_date => p_validation_end_date,
668: p_per_typ_rt_id => p_rec.per_typ_rt_id);
669: --
670: hr_utility.set_location(' Leaving:'||l_proc, 10);
671: End delete_validate;
672: --
673: --
674: -- ---------------------------------------------------------------------------

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

693: l_proc varchar2(72) := g_package||'return_legislation_code';
694: --
695: begin
696: --
697: hr_utility.set_location('Entering:'|| l_proc, 10);
698: --
699: -- Ensure that all the mandatory parameter are not null
700: --
701: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

711: close csr_leg_code;
712: --
713: -- The primary key is invalid therefore we must error
714: --
715: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
716: hr_utility.raise_error;
717: --
718: end if;
719: --

Line 716: hr_utility.raise_error;

712: --
713: -- The primary key is invalid therefore we must error
714: --
715: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
716: hr_utility.raise_error;
717: --
718: end if;
719: --
720: close csr_leg_code;

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

718: end if;
719: --
720: close csr_leg_code;
721: --
722: hr_utility.set_location(' Leaving:'|| l_proc, 20);
723: --
724: return l_legislation_code;
725: --
726: end return_legislation_code;