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_PAP_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_pap_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_prtt_anthr_pl_rt_id => p_prtt_anthr_pl_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_prtt_anthr_pl_rt_id;
78:
79: -- ----------------------------------------------------------------------------

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

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

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

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

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

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

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

223: p_effective_date => p_effective_date) then
224: --
225: -- raise error as does not exist as lookup
226: --
227: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
228: hr_utility.raise_error;
229: --
230: end if;
231: --

Line 228: hr_utility.raise_error;

224: --
225: -- raise error as does not exist as lookup
226: --
227: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
228: hr_utility.raise_error;
229: --
230: end if;
231: --
232: end if;

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

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

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

287: and business_group_id + 0 = p_business_group_id
288: and ordr_num = p_ordr_num;
289: --
290: Begin
291: hr_utility.set_location('Entering:'||l_proc, 5);
292:
293: --
294: open c1;
295: fetch c1 into l_dummy;

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

299: fnd_message.raise_error;
300: end if;
301: close c1;
302: --
303: hr_utility.set_location('Leaving:'||l_proc, 15);
304: End chk_duplicate_ordr_num;
305:
306:
307:

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

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

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

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

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

390: --
391: -- A referential integrity check was violated therefore
392: -- we must error
393: --
394: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
395: hr_utility.set_message_token('TABLE_NAME', l_table_name);
396: hr_utility.raise_error;
397: When Others Then
398: --

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

391: -- A referential integrity check was violated therefore
392: -- we must error
393: --
394: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
395: hr_utility.set_message_token('TABLE_NAME', l_table_name);
396: hr_utility.raise_error;
397: When Others Then
398: --
399: -- An unhandled or unexpected error has occurred which

Line 396: hr_utility.raise_error;

392: -- we must error
393: --
394: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
395: hr_utility.set_message_token('TABLE_NAME', l_table_name);
396: hr_utility.raise_error;
397: When Others Then
398: --
399: -- An unhandled or unexpected error has occurred which
400: -- we must report

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

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

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

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

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

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

Line 405: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

Line 500: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 509: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

645: p_validation_start_date => p_validation_start_date,
646: p_validation_end_date => p_validation_end_date,
647: p_prtt_anthr_pl_rt_id => p_rec.prtt_anthr_pl_rt_id);
648: --
649: hr_utility.set_location(' Leaving:'||l_proc, 10);
650: End delete_validate;
651: --
652: --
653: -- ---------------------------------------------------------------------------

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

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

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

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

Line 695: hr_utility.raise_error;

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

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

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