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_GNR_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_gnr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_gndr_rt_id => p_gndr_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_gndr_rt_id;
78: --
79: -- |--------------------< chk_duplicate_ordr_num >----------------------------|

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

118: and business_group_id + 0 = p_business_group_id
119: and ordr_num = p_ordr_num;
120: --
121: Begin
122: hr_utility.set_location('Entering:'||l_proc, 5);
123:
124: --
125: open c1;
126: fetch c1 into l_dummy;

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

130: fnd_message.raise_error;
131: end if;
132: close c1;
133: --
134: hr_utility.set_location('Leaving:'||l_proc, 15);
135: End chk_duplicate_ordr_num;
136:
137: --
138: -- ----------------------------------------------------------------------------

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

170: l_api_updating boolean;
171: --
172: Begin
173: --
174: hr_utility.set_location('Entering:'||l_proc, 5);
175: --
176: l_api_updating := ben_gnr_shd.api_updating
177: (p_gndr_rt_id => p_gndr_rt_id,
178: p_effective_date => p_effective_date,

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

192: p_effective_date => p_effective_date) then
193: --
194: -- raise error as does not exist as lookup
195: --
196: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
197: hr_utility.raise_error;
198: --
199: end if;
200: --

Line 197: hr_utility.raise_error;

193: --
194: -- raise error as does not exist as lookup
195: --
196: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
197: hr_utility.raise_error;
198: --
199: end if;
200: --
201: end if;

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

199: end if;
200: --
201: end if;
202: --
203: hr_utility.set_location('Leaving:'||l_proc,10);
204: --
205: end chk_excld_flag;
206: --
207: -- ----------------------------------------------------------------------------

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

256: and p_validation_end_date >= effective_start_date;
257: -- end bug # 2452735
258: Begin
259: --
260: hr_utility.set_location('Entering:'||l_proc, 5);
261: --
262: l_api_updating := ben_gnr_shd.api_updating
263: (p_gndr_rt_id => p_gndr_rt_id,
264: p_effective_date => p_effective_date,

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

278: p_effective_date => p_effective_date) then
279: --
280: -- raise error as does not exist as lookup
281: --
282: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
283: hr_utility.raise_error;
284: --
285: end if;
286: --

Line 283: hr_utility.raise_error;

279: --
280: -- raise error as does not exist as lookup
281: --
282: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
283: hr_utility.raise_error;
284: --
285: end if;
286: --
287: end if;

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

302: end if;
303: close c_dup;
304: -- end bug # 2452735
305:
306: hr_utility.set_location('Leaving:'||l_proc,10);
307: --
308: end chk_gndr_cd;
309: --
310: -- ----------------------------------------------------------------------------

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

346: l_integrity_error Exception;
347: l_table_name all_tables.table_name%TYPE;
348: --
349: Begin
350: hr_utility.set_location('Entering:'||l_proc, 5);
351: --
352: -- Ensure that the p_datetrack_mode argument is not null
353: --
354: hr_api.mandatory_arg_error

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

385: End If;
386: --
387: End If;
388: --
389: hr_utility.set_location(' Leaving:'||l_proc, 10);
390: Exception
391: When l_integrity_error Then
392: --
393: -- A referential integrity check was violated therefore

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

399: --
400: -- An unhandled or unexpected error has occurred which
401: -- we must report
402: --
403: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
404: hr_utility.set_message_token('PROCEDURE', l_proc);
405: hr_utility.set_message_token('STEP','15');
406: hr_utility.raise_error;
407: End dt_update_validate;

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

400: -- An unhandled or unexpected error has occurred which
401: -- we must report
402: --
403: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
404: hr_utility.set_message_token('PROCEDURE', l_proc);
405: hr_utility.set_message_token('STEP','15');
406: hr_utility.raise_error;
407: End dt_update_validate;
408: --

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

401: -- we must report
402: --
403: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
404: hr_utility.set_message_token('PROCEDURE', l_proc);
405: hr_utility.set_message_token('STEP','15');
406: hr_utility.raise_error;
407: End dt_update_validate;
408: --
409: -- ----------------------------------------------------------------------------

Line 406: hr_utility.raise_error;

402: --
403: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
404: hr_utility.set_message_token('PROCEDURE', l_proc);
405: hr_utility.set_message_token('STEP','15');
406: hr_utility.raise_error;
407: End dt_update_validate;
408: --
409: -- ----------------------------------------------------------------------------
410: -- |--------------------------< dt_delete_validate >--------------------------|

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

451: l_rows_exist Exception;
452: l_table_name all_tables.table_name%TYPE;
453: --
454: Begin
455: hr_utility.set_location('Entering:'||l_proc, 5);
456: --
457: -- Ensure that the p_datetrack_mode argument is not null
458: --
459: hr_api.mandatory_arg_error

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

488: --
489: --
490: End If;
491: --
492: hr_utility.set_location(' Leaving:'||l_proc, 10);
493: Exception
494: When l_rows_exist Then
495: --
496: -- A referential integrity check was violated therefore

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

495: --
496: -- A referential integrity check was violated therefore
497: -- we must error
498: --
499: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
500: hr_utility.set_message_token('TABLE_NAME', l_table_name);
501: hr_utility.raise_error;
502: When Others Then
503: --

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

496: -- A referential integrity check was violated therefore
497: -- we must error
498: --
499: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
500: hr_utility.set_message_token('TABLE_NAME', l_table_name);
501: hr_utility.raise_error;
502: When Others Then
503: --
504: -- An unhandled or unexpected error has occurred which

Line 501: hr_utility.raise_error;

497: -- we must error
498: --
499: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
500: hr_utility.set_message_token('TABLE_NAME', l_table_name);
501: hr_utility.raise_error;
502: When Others Then
503: --
504: -- An unhandled or unexpected error has occurred which
505: -- we must report

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

503: --
504: -- An unhandled or unexpected error has occurred which
505: -- we must report
506: --
507: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
508: hr_utility.set_message_token('PROCEDURE', l_proc);
509: hr_utility.set_message_token('STEP','15');
510: hr_utility.raise_error;
511: End dt_delete_validate;

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

504: -- An unhandled or unexpected error has occurred which
505: -- we must report
506: --
507: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
508: hr_utility.set_message_token('PROCEDURE', l_proc);
509: hr_utility.set_message_token('STEP','15');
510: hr_utility.raise_error;
511: End dt_delete_validate;
512: --

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

505: -- we must report
506: --
507: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
508: hr_utility.set_message_token('PROCEDURE', l_proc);
509: hr_utility.set_message_token('STEP','15');
510: hr_utility.raise_error;
511: End dt_delete_validate;
512: --
513: -- ----------------------------------------------------------------------------

Line 510: hr_utility.raise_error;

506: --
507: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
508: hr_utility.set_message_token('PROCEDURE', l_proc);
509: hr_utility.set_message_token('STEP','15');
510: hr_utility.raise_error;
511: End dt_delete_validate;
512: --
513: -- ----------------------------------------------------------------------------
514: -- |---------------------------< insert_validate >----------------------------|

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

522: --
523: l_proc varchar2(72) := g_package||'insert_validate';
524: --
525: Begin
526: hr_utility.set_location('Entering:'||l_proc, 5);
527: --
528: -- Call all supporting business operations
529: --
530: --

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

557: ,p_effective_date => p_effective_date
558: ,p_business_group_id => p_rec.business_group_id
559: ,p_gndr_rt_id => p_rec.gndr_rt_id);
560: --
561: hr_utility.set_location(' Leaving:'||l_proc, 10);
562: End insert_validate;
563: --
564: -- ----------------------------------------------------------------------------
565: -- |---------------------------< update_validate >----------------------------|

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

573: --
574: l_proc varchar2(72) := g_package||'update_validate';
575: --
576: Begin
577: hr_utility.set_location('Entering:'||l_proc, 5);
578: --
579: -- Call all supporting business operations
580: --
581: --

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

616: ,p_effective_date => p_effective_date
617: ,p_business_group_id => p_rec.business_group_id
618: ,p_gndr_rt_id => p_rec.gndr_rt_id);
619: --
620: hr_utility.set_location(' Leaving:'||l_proc, 10);
621: End update_validate;
622: --
623: -- ----------------------------------------------------------------------------
624: -- |---------------------------< delete_validate >----------------------------|

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

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

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

642: p_validation_start_date => p_validation_start_date,
643: p_validation_end_date => p_validation_end_date,
644: p_gndr_rt_id => p_rec.gndr_rt_id);
645: --
646: hr_utility.set_location(' Leaving:'||l_proc, 10);
647: End delete_validate;
648: --
649: --
650: -- ---------------------------------------------------------------------------

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

669: l_proc varchar2(72) := g_package||'return_legislation_code';
670: --
671: begin
672: --
673: hr_utility.set_location('Entering:'|| l_proc, 10);
674: --
675: -- Ensure that all the mandatory parameter are not null
676: --
677: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

687: close csr_leg_code;
688: --
689: -- The primary key is invalid therefore we must error
690: --
691: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
692: hr_utility.raise_error;
693: --
694: end if;
695: --

Line 692: hr_utility.raise_error;

688: --
689: -- The primary key is invalid therefore we must error
690: --
691: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
692: hr_utility.raise_error;
693: --
694: end if;
695: --
696: close csr_leg_code;

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

694: end if;
695: --
696: close csr_leg_code;
697: --
698: hr_utility.set_location(' Leaving:'|| l_proc, 20);
699: --
700: return l_legislation_code;
701: --
702: end return_legislation_code;