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_WPT_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_wpt_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_wv_prtn_rsn_ptip_id => p_wv_prtn_rsn_ptip_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_wv_prtn_rsn_ptip_id;
78: --
79: -- ----------------------------------------------------------------------------

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

111: l_api_updating boolean;
112: --
113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_wpt_shd.api_updating
118: (p_wv_prtn_rsn_ptip_id => p_wv_prtn_rsn_ptip_id,
119: p_effective_date => p_effective_date,

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

133: p_effective_date => p_effective_date) then
134: --
135: -- raise error as does not exist as lookup
136: --
137: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
138: hr_utility.raise_error;
139: --
140: end if;
141: --

Line 138: hr_utility.raise_error;

134: --
135: -- raise error as does not exist as lookup
136: --
137: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
138: hr_utility.raise_error;
139: --
140: end if;
141: --
142: end if;

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

140: end if;
141: --
142: end if;
143: --
144: hr_utility.set_location('Leaving:'||l_proc,10);
145: --
146: end chk_wv_prtn_rsn_cd;
147: --
148: -- ----------------------------------------------------------------------------

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

180: l_api_updating boolean;
181: --
182: Begin
183: --
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: l_api_updating := ben_wpt_shd.api_updating
187: (p_wv_prtn_rsn_ptip_id => p_wv_prtn_rsn_ptip_id,
188: p_effective_date => p_effective_date,

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

202: p_effective_date => p_effective_date) then
203: --
204: -- raise error as does not exist as lookup
205: --
206: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
207: hr_utility.raise_error;
208: --
209: end if;
210: --

Line 207: hr_utility.raise_error;

203: --
204: -- raise error as does not exist as lookup
205: --
206: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
207: hr_utility.raise_error;
208: --
209: end if;
210: --
211: end if;

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

209: end if;
210: --
211: end if;
212: --
213: hr_utility.set_location('Leaving:'||l_proc,10);
214: --
215: end chk_dflt_flag;
216:
217:

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

259: and p_effective_date between effective_start_date and effective_end_date
260: and business_group_id = p_business_group_id;
261: --
262: Begin
263: hr_utility.set_location('Entering:'||l_proc, 5);
264: --
265: open c1;
266: fetch c1 into l_dummy;
267: if c1%found then

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

271: fnd_message.raise_error;
272: end if;
273: end if;
274: --
275: hr_utility.set_location('Leaving:'||l_proc, 15);
276: End chk_only_default_one;
277: --
278: -- ----------------------------------------------------------------------------
279: -- |--------------------------< dt_update_validate >--------------------------|

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

314: l_integrity_error Exception;
315: l_table_name all_tables.table_name%TYPE;
316: --
317: Begin
318: hr_utility.set_location('Entering:'||l_proc, 5);
319: --
320: -- Ensure that the p_datetrack_mode argument is not null
321: --
322: hr_api.mandatory_arg_error

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

353: End If;
354: --
355: End If;
356: --
357: hr_utility.set_location(' Leaving:'||l_proc, 10);
358: Exception
359: When l_integrity_error Then
360: --
361: -- A referential integrity check was violated therefore

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

360: --
361: -- A referential integrity check was violated therefore
362: -- we must error
363: --
364: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
365: hr_utility.set_message_token('TABLE_NAME', l_table_name);
366: hr_utility.raise_error;
367: When Others Then
368: --

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

361: -- A referential integrity check was violated therefore
362: -- we must error
363: --
364: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
365: hr_utility.set_message_token('TABLE_NAME', l_table_name);
366: hr_utility.raise_error;
367: When Others Then
368: --
369: -- An unhandled or unexpected error has occurred which

Line 366: hr_utility.raise_error;

362: -- we must error
363: --
364: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
365: hr_utility.set_message_token('TABLE_NAME', l_table_name);
366: hr_utility.raise_error;
367: When Others Then
368: --
369: -- An unhandled or unexpected error has occurred which
370: -- we must report

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

368: --
369: -- An unhandled or unexpected error has occurred which
370: -- we must report
371: --
372: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
373: hr_utility.set_message_token('PROCEDURE', l_proc);
374: hr_utility.set_message_token('STEP','15');
375: hr_utility.raise_error;
376: End dt_update_validate;

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

369: -- An unhandled or unexpected error has occurred which
370: -- we must report
371: --
372: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
373: hr_utility.set_message_token('PROCEDURE', l_proc);
374: hr_utility.set_message_token('STEP','15');
375: hr_utility.raise_error;
376: End dt_update_validate;
377: --

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

370: -- we must report
371: --
372: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
373: hr_utility.set_message_token('PROCEDURE', l_proc);
374: hr_utility.set_message_token('STEP','15');
375: hr_utility.raise_error;
376: End dt_update_validate;
377: --
378: -- ----------------------------------------------------------------------------

Line 375: hr_utility.raise_error;

371: --
372: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
373: hr_utility.set_message_token('PROCEDURE', l_proc);
374: hr_utility.set_message_token('STEP','15');
375: hr_utility.raise_error;
376: End dt_update_validate;
377: --
378: -- ----------------------------------------------------------------------------
379: -- |--------------------------< dt_delete_validate >--------------------------|

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

420: l_rows_exist Exception;
421: l_table_name all_tables.table_name%TYPE;
422: --
423: Begin
424: hr_utility.set_location('Entering:'||l_proc, 5);
425: --
426: -- Ensure that the p_datetrack_mode argument is not null
427: --
428: hr_api.mandatory_arg_error

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

465: End If;
466: --
467: End If;
468: --
469: hr_utility.set_location(' Leaving:'||l_proc, 10);
470: Exception
471: When l_rows_exist Then
472: --
473: -- A referential integrity check was violated therefore

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

472: --
473: -- A referential integrity check was violated therefore
474: -- we must error
475: --
476: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
477: hr_utility.set_message_token('TABLE_NAME', l_table_name);
478: hr_utility.raise_error;
479: When Others Then
480: --

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

473: -- A referential integrity check was violated therefore
474: -- we must error
475: --
476: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
477: hr_utility.set_message_token('TABLE_NAME', l_table_name);
478: hr_utility.raise_error;
479: When Others Then
480: --
481: -- An unhandled or unexpected error has occurred which

Line 478: hr_utility.raise_error;

474: -- we must error
475: --
476: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
477: hr_utility.set_message_token('TABLE_NAME', l_table_name);
478: hr_utility.raise_error;
479: When Others Then
480: --
481: -- An unhandled or unexpected error has occurred which
482: -- we must report

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

480: --
481: -- An unhandled or unexpected error has occurred which
482: -- we must report
483: --
484: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
485: hr_utility.set_message_token('PROCEDURE', l_proc);
486: hr_utility.set_message_token('STEP','15');
487: hr_utility.raise_error;
488: End dt_delete_validate;

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

481: -- An unhandled or unexpected error has occurred which
482: -- we must report
483: --
484: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
485: hr_utility.set_message_token('PROCEDURE', l_proc);
486: hr_utility.set_message_token('STEP','15');
487: hr_utility.raise_error;
488: End dt_delete_validate;
489: --

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

482: -- we must report
483: --
484: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
485: hr_utility.set_message_token('PROCEDURE', l_proc);
486: hr_utility.set_message_token('STEP','15');
487: hr_utility.raise_error;
488: End dt_delete_validate;
489: --
490: -- ----------------------------------------------------------------------------

Line 487: hr_utility.raise_error;

483: --
484: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
485: hr_utility.set_message_token('PROCEDURE', l_proc);
486: hr_utility.set_message_token('STEP','15');
487: hr_utility.raise_error;
488: End dt_delete_validate;
489: --
490: -- ----------------------------------------------------------------------------
491: -- |---------------------------< insert_validate >----------------------------|

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

499: --
500: l_proc varchar2(72) := g_package||'insert_validate';
501: --
502: Begin
503: hr_utility.set_location('Entering:'||l_proc, 5);
504: --
505: -- Call all supporting business operations
506: --
507: --

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

530: ,p_dflt_flag => p_rec.dflt_flag
531: ,p_effective_date => p_effective_date
532: ,p_business_group_id => p_rec.business_group_id);
533: --
534: hr_utility.set_location(' Leaving:'||l_proc, 10);
535: End insert_validate;
536: --
537: -- ----------------------------------------------------------------------------
538: -- |---------------------------< update_validate >----------------------------|

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

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

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

585: p_datetrack_mode => p_datetrack_mode,
586: p_validation_start_date => p_validation_start_date,
587: p_validation_end_date => p_validation_end_date);
588: --
589: hr_utility.set_location(' Leaving:'||l_proc, 10);
590: End update_validate;
591: --
592: -- ----------------------------------------------------------------------------
593: -- |---------------------------< delete_validate >----------------------------|

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

601: --
602: l_proc varchar2(72) := g_package||'delete_validate';
603: --
604: Begin
605: hr_utility.set_location('Entering:'||l_proc, 5);
606: --
607: -- Call all supporting business operations
608: --
609: dt_delete_validate

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

611: p_validation_start_date => p_validation_start_date,
612: p_validation_end_date => p_validation_end_date,
613: p_wv_prtn_rsn_ptip_id => p_rec.wv_prtn_rsn_ptip_id);
614: --
615: hr_utility.set_location(' Leaving:'||l_proc, 10);
616: End delete_validate;
617: --
618: --
619: -- ---------------------------------------------------------------------------

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

638: l_proc varchar2(72) := g_package||'return_legislation_code';
639: --
640: begin
641: --
642: hr_utility.set_location('Entering:'|| l_proc, 10);
643: --
644: -- Ensure that all the mandatory parameter are not null
645: --
646: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

656: close csr_leg_code;
657: --
658: -- The primary key is invalid therefore we must error
659: --
660: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
661: hr_utility.raise_error;
662: --
663: end if;
664: --

Line 661: hr_utility.raise_error;

657: --
658: -- The primary key is invalid therefore we must error
659: --
660: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
661: hr_utility.raise_error;
662: --
663: end if;
664: --
665: close csr_leg_code;

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

663: end if;
664: --
665: close csr_leg_code;
666: --
667: hr_utility.set_location(' Leaving:'|| l_proc, 20);
668: --
669: return l_legislation_code;
670: --
671: end return_legislation_code;