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_PGR_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_pgr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ppl_grp_rt_id => p_ppl_grp_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_ppl_grp_rt_id;
78: -- ----------------------------------------------------------------------------
79: -- |------< chk_dup_record >------|

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

131: and p_validation_end_date >= effective_start_date;
132: --
133: BEGIN
134: --
135: hr_utility.set_location('Entering:'||l_proc, 5);
136: --
137: l_api_updating := ben_pgr_shd.api_updating
138: (p_ppl_grp_rt_id => p_ppl_grp_rt_id,
139: p_effective_date => p_effective_date,

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

158: end if;
159: close c_dup;
160: --
161: end if;
162: hr_utility.set_location('Leaving:'||l_proc,10);
163: --
164: END chk_dup_record;
165: --
166: -- |--------------------< chk_duplicate_ordr_num >----------------------------|

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

205: and business_group_id + 0 = p_business_group_id
206: and ordr_num = p_ordr_num;
207: --
208: Begin
209: hr_utility.set_location('Entering:'||l_proc, 5);
210:
211: --
212: open c1;
213: fetch c1 into l_dummy;

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

217: fnd_message.raise_error;
218: end if;
219: close c1;
220: --
221: hr_utility.set_location('Leaving:'||l_proc, 15);
222: End chk_duplicate_ordr_num;
223:
224: --
225: -- ----------------------------------------------------------------------------

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

257: l_api_updating boolean;
258: --
259: Begin
260: --
261: hr_utility.set_location('Entering:'||l_proc, 5);
262: --
263: l_api_updating := ben_pgr_shd.api_updating
264: (p_ppl_grp_rt_id => p_ppl_grp_rt_id,
265: p_effective_date => p_effective_date,

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

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

Line 284: hr_utility.raise_error;

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

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

286: end if;
287: --
288: end if;
289: --
290: hr_utility.set_location('Leaving:'||l_proc,10);
291: --
292: end chk_excld_flag;
293: --
294: -- ----------------------------------------------------------------------------

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

330: l_integrity_error Exception;
331: l_table_name all_tables.table_name%TYPE;
332: --
333: Begin
334: hr_utility.set_location('Entering:'||l_proc, 5);
335: --
336: -- Ensure that the p_datetrack_mode argument is not null
337: --
338: hr_api.mandatory_arg_error

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

369: End If;
370: --
371: End If;
372: --
373: hr_utility.set_location(' Leaving:'||l_proc, 10);
374: Exception
375: When l_integrity_error Then
376: --
377: -- A referential integrity check was violated therefore

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

376: --
377: -- A referential integrity check was violated therefore
378: -- we must error
379: --
380: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
381: hr_utility.set_message_token('TABLE_NAME', l_table_name);
382: hr_utility.raise_error;
383: When Others Then
384: --

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

377: -- A referential integrity check was violated therefore
378: -- we must error
379: --
380: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
381: hr_utility.set_message_token('TABLE_NAME', l_table_name);
382: hr_utility.raise_error;
383: When Others Then
384: --
385: -- An unhandled or unexpected error has occurred which

Line 382: hr_utility.raise_error;

378: -- we must error
379: --
380: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
381: hr_utility.set_message_token('TABLE_NAME', l_table_name);
382: hr_utility.raise_error;
383: When Others Then
384: --
385: -- An unhandled or unexpected error has occurred which
386: -- we must report

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

384: --
385: -- An unhandled or unexpected error has occurred which
386: -- we must report
387: --
388: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
389: hr_utility.set_message_token('PROCEDURE', l_proc);
390: hr_utility.set_message_token('STEP','15');
391: hr_utility.raise_error;
392: End dt_update_validate;

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

385: -- An unhandled or unexpected error has occurred which
386: -- we must report
387: --
388: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
389: hr_utility.set_message_token('PROCEDURE', l_proc);
390: hr_utility.set_message_token('STEP','15');
391: hr_utility.raise_error;
392: End dt_update_validate;
393: --

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

386: -- we must report
387: --
388: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
389: hr_utility.set_message_token('PROCEDURE', l_proc);
390: hr_utility.set_message_token('STEP','15');
391: hr_utility.raise_error;
392: End dt_update_validate;
393: --
394: -- ----------------------------------------------------------------------------

Line 391: hr_utility.raise_error;

387: --
388: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
389: hr_utility.set_message_token('PROCEDURE', l_proc);
390: hr_utility.set_message_token('STEP','15');
391: hr_utility.raise_error;
392: End dt_update_validate;
393: --
394: -- ----------------------------------------------------------------------------
395: -- |--------------------------< dt_delete_validate >--------------------------|

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

436: l_rows_exist Exception;
437: l_table_name all_tables.table_name%TYPE;
438: --
439: Begin
440: hr_utility.set_location('Entering:'||l_proc, 5);
441: --
442: -- Ensure that the p_datetrack_mode argument is not null
443: --
444: hr_api.mandatory_arg_error

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

473: --
474: --
475: End If;
476: --
477: hr_utility.set_location(' Leaving:'||l_proc, 10);
478: Exception
479: When l_rows_exist Then
480: --
481: -- A referential integrity check was violated therefore

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

480: --
481: -- A referential integrity check was violated therefore
482: -- we must error
483: --
484: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
485: hr_utility.set_message_token('TABLE_NAME', l_table_name);
486: hr_utility.raise_error;
487: When Others Then
488: --

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

481: -- A referential integrity check was violated therefore
482: -- we must error
483: --
484: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
485: hr_utility.set_message_token('TABLE_NAME', l_table_name);
486: hr_utility.raise_error;
487: When Others Then
488: --
489: -- An unhandled or unexpected error has occurred which

Line 486: hr_utility.raise_error;

482: -- we must error
483: --
484: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
485: hr_utility.set_message_token('TABLE_NAME', l_table_name);
486: hr_utility.raise_error;
487: When Others Then
488: --
489: -- An unhandled or unexpected error has occurred which
490: -- we must report

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

488: --
489: -- An unhandled or unexpected error has occurred which
490: -- we must report
491: --
492: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
493: hr_utility.set_message_token('PROCEDURE', l_proc);
494: hr_utility.set_message_token('STEP','15');
495: hr_utility.raise_error;
496: End dt_delete_validate;

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

489: -- An unhandled or unexpected error has occurred which
490: -- we must report
491: --
492: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
493: hr_utility.set_message_token('PROCEDURE', l_proc);
494: hr_utility.set_message_token('STEP','15');
495: hr_utility.raise_error;
496: End dt_delete_validate;
497: --

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

490: -- we must report
491: --
492: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
493: hr_utility.set_message_token('PROCEDURE', l_proc);
494: hr_utility.set_message_token('STEP','15');
495: hr_utility.raise_error;
496: End dt_delete_validate;
497: --
498: -- ----------------------------------------------------------------------------

Line 495: hr_utility.raise_error;

491: --
492: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
493: hr_utility.set_message_token('PROCEDURE', l_proc);
494: hr_utility.set_message_token('STEP','15');
495: hr_utility.raise_error;
496: End dt_delete_validate;
497: --
498: -- ----------------------------------------------------------------------------
499: -- |---------------------------< insert_validate >----------------------------|

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

507: --
508: l_proc varchar2(72) := g_package||'insert_validate';
509: --
510: Begin
511: hr_utility.set_location('Entering:'||l_proc, 5);
512: --
513: -- Call all supporting business operations
514: --
515: --

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

542: ,p_effective_date => p_effective_date
543: ,p_business_group_id => p_rec.business_group_id
544: ,p_ppl_grp_rt_id => p_rec.ppl_grp_rt_id);
545: --
546: hr_utility.set_location(' Leaving:'||l_proc, 10);
547: End insert_validate;
548: --
549: -- ----------------------------------------------------------------------------
550: -- |---------------------------< update_validate >----------------------------|

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

558: --
559: l_proc varchar2(72) := g_package||'update_validate';
560: --
561: Begin
562: hr_utility.set_location('Entering:'||l_proc, 5);
563: --
564: -- Call all supporting business operations
565: --
566: --

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

601: ,p_effective_date => p_effective_date
602: ,p_business_group_id => p_rec.business_group_id
603: ,p_ppl_grp_rt_id => p_rec.ppl_grp_rt_id);
604: --
605: hr_utility.set_location(' Leaving:'||l_proc, 10);
606: End update_validate;
607: --
608: -- ----------------------------------------------------------------------------
609: -- |---------------------------< delete_validate >----------------------------|

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

617: --
618: l_proc varchar2(72) := g_package||'delete_validate';
619: --
620: Begin
621: hr_utility.set_location('Entering:'||l_proc, 5);
622: --
623: -- Call all supporting business operations
624: --
625: dt_delete_validate

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

627: p_validation_start_date => p_validation_start_date,
628: p_validation_end_date => p_validation_end_date,
629: p_ppl_grp_rt_id => p_rec.ppl_grp_rt_id);
630: --
631: hr_utility.set_location(' Leaving:'||l_proc, 10);
632: End delete_validate;
633: --
634: --
635: -- ---------------------------------------------------------------------------

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

654: l_proc varchar2(72) := g_package||'return_legislation_code';
655: --
656: begin
657: --
658: hr_utility.set_location('Entering:'|| l_proc, 10);
659: --
660: -- Ensure that all the mandatory parameter are not null
661: --
662: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

672: close csr_leg_code;
673: --
674: -- The primary key is invalid therefore we must error
675: --
676: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
677: hr_utility.raise_error;
678: --
679: end if;
680: --

Line 677: hr_utility.raise_error;

673: --
674: -- The primary key is invalid therefore we must error
675: --
676: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
677: hr_utility.raise_error;
678: --
679: end if;
680: --
681: close csr_leg_code;

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

679: end if;
680: --
681: close csr_leg_code;
682: --
683: hr_utility.set_location(' Leaving:'|| l_proc, 20);
684: --
685: return l_legislation_code;
686: --
687: end return_legislation_code;