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_WPN_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_wpn_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_wv_prtn_rsn_pl_id => p_wv_prtn_rsn_pl_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_pl_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_wpn_shd.api_updating
118: (p_wv_prtn_rsn_pl_id => p_wv_prtn_rsn_pl_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_wpn_shd.api_updating
187: (p_wv_prtn_rsn_pl_id => p_wv_prtn_rsn_pl_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 257: hr_utility.set_location('Entering:'||l_proc, 5);

253: l_integrity_error Exception;
254: l_table_name all_tables.table_name%TYPE;
255: --
256: Begin
257: hr_utility.set_location('Entering:'||l_proc, 5);
258: --
259: -- Ensure that the p_datetrack_mode argument is not null
260: --
261: hr_api.mandatory_arg_error

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

292: End If;
293: --
294: End If;
295: --
296: hr_utility.set_location(' Leaving:'||l_proc, 10);
297: Exception
298: When l_integrity_error Then
299: --
300: -- A referential integrity check was violated therefore

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

299: --
300: -- A referential integrity check was violated therefore
301: -- we must error
302: --
303: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
304: hr_utility.set_message_token('TABLE_NAME', l_table_name);
305: hr_utility.raise_error;
306: When Others Then
307: --

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

300: -- A referential integrity check was violated therefore
301: -- we must error
302: --
303: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
304: hr_utility.set_message_token('TABLE_NAME', l_table_name);
305: hr_utility.raise_error;
306: When Others Then
307: --
308: -- An unhandled or unexpected error has occurred which

Line 305: hr_utility.raise_error;

301: -- we must error
302: --
303: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
304: hr_utility.set_message_token('TABLE_NAME', l_table_name);
305: hr_utility.raise_error;
306: When Others Then
307: --
308: -- An unhandled or unexpected error has occurred which
309: -- we must report

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

307: --
308: -- An unhandled or unexpected error has occurred which
309: -- we must report
310: --
311: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
312: hr_utility.set_message_token('PROCEDURE', l_proc);
313: hr_utility.set_message_token('STEP','15');
314: hr_utility.raise_error;
315: End dt_update_validate;

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

308: -- An unhandled or unexpected error has occurred which
309: -- we must report
310: --
311: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
312: hr_utility.set_message_token('PROCEDURE', l_proc);
313: hr_utility.set_message_token('STEP','15');
314: hr_utility.raise_error;
315: End dt_update_validate;
316: --

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

309: -- we must report
310: --
311: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
312: hr_utility.set_message_token('PROCEDURE', l_proc);
313: hr_utility.set_message_token('STEP','15');
314: hr_utility.raise_error;
315: End dt_update_validate;
316: --
317: -- ----------------------------------------------------------------------------

Line 314: hr_utility.raise_error;

310: --
311: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
312: hr_utility.set_message_token('PROCEDURE', l_proc);
313: hr_utility.set_message_token('STEP','15');
314: hr_utility.raise_error;
315: End dt_update_validate;
316: --
317: -- ----------------------------------------------------------------------------
318: -- |--------------------------< dt_delete_validate >--------------------------|

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

359: l_rows_exist Exception;
360: l_table_name all_tables.table_name%TYPE;
361: --
362: Begin
363: hr_utility.set_location('Entering:'||l_proc, 5);
364: --
365: -- Ensure that the p_datetrack_mode argument is not null
366: --
367: hr_api.mandatory_arg_error

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

396: --
397: --
398: End If;
399: --
400: hr_utility.set_location(' Leaving:'||l_proc, 10);
401: Exception
402: When l_rows_exist Then
403: --
404: -- A referential integrity check was violated therefore

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

403: --
404: -- A referential integrity check was violated therefore
405: -- we must error
406: --
407: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
408: hr_utility.set_message_token('TABLE_NAME', l_table_name);
409: hr_utility.raise_error;
410: When Others Then
411: --

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

404: -- A referential integrity check was violated therefore
405: -- we must error
406: --
407: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
408: hr_utility.set_message_token('TABLE_NAME', l_table_name);
409: hr_utility.raise_error;
410: When Others Then
411: --
412: -- An unhandled or unexpected error has occurred which

Line 409: hr_utility.raise_error;

405: -- we must error
406: --
407: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
408: hr_utility.set_message_token('TABLE_NAME', l_table_name);
409: hr_utility.raise_error;
410: When Others Then
411: --
412: -- An unhandled or unexpected error has occurred which
413: -- we must report

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

411: --
412: -- An unhandled or unexpected error has occurred which
413: -- we must report
414: --
415: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
416: hr_utility.set_message_token('PROCEDURE', l_proc);
417: hr_utility.set_message_token('STEP','15');
418: hr_utility.raise_error;
419: End dt_delete_validate;

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

412: -- An unhandled or unexpected error has occurred which
413: -- we must report
414: --
415: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
416: hr_utility.set_message_token('PROCEDURE', l_proc);
417: hr_utility.set_message_token('STEP','15');
418: hr_utility.raise_error;
419: End dt_delete_validate;
420: --

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

413: -- we must report
414: --
415: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
416: hr_utility.set_message_token('PROCEDURE', l_proc);
417: hr_utility.set_message_token('STEP','15');
418: hr_utility.raise_error;
419: End dt_delete_validate;
420: --
421: -- ----------------------------------------------------------------------------

Line 418: hr_utility.raise_error;

414: --
415: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
416: hr_utility.set_message_token('PROCEDURE', l_proc);
417: hr_utility.set_message_token('STEP','15');
418: hr_utility.raise_error;
419: End dt_delete_validate;
420: --
421: -- ----------------------------------------------------------------------------
422: -- |---------------------------< insert_validate >----------------------------|

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

430: --
431: l_proc varchar2(72) := g_package||'insert_validate';
432: --
433: Begin
434: hr_utility.set_location('Entering:'||l_proc, 5);
435: --
436: -- Call all supporting business operations
437: --
438: --

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

454: p_dflt_flag => p_rec.dflt_flag,
455: p_effective_date => p_effective_date,
456: p_object_version_number => p_rec.object_version_number);
457: --
458: hr_utility.set_location(' Leaving:'||l_proc, 10);
459: End insert_validate;
460: --
461: -- ----------------------------------------------------------------------------
462: -- |---------------------------< update_validate >----------------------------|

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

470: --
471: l_proc varchar2(72) := g_package||'update_validate';
472: --
473: Begin
474: hr_utility.set_location('Entering:'||l_proc, 5);
475: --
476: -- Call all supporting business operations
477: --
478: --

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

502: p_datetrack_mode => p_datetrack_mode,
503: p_validation_start_date => p_validation_start_date,
504: p_validation_end_date => p_validation_end_date);
505: --
506: hr_utility.set_location(' Leaving:'||l_proc, 10);
507: End update_validate;
508: --
509: -- ----------------------------------------------------------------------------
510: -- |---------------------------< delete_validate >----------------------------|

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

518: --
519: l_proc varchar2(72) := g_package||'delete_validate';
520: --
521: Begin
522: hr_utility.set_location('Entering:'||l_proc, 5);
523: --
524: -- Call all supporting business operations
525: --
526: dt_delete_validate

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

528: p_validation_start_date => p_validation_start_date,
529: p_validation_end_date => p_validation_end_date,
530: p_wv_prtn_rsn_pl_id => p_rec.wv_prtn_rsn_pl_id);
531: --
532: hr_utility.set_location(' Leaving:'||l_proc, 10);
533: End delete_validate;
534: --
535: --
536: -- ---------------------------------------------------------------------------

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

555: l_proc varchar2(72) := g_package||'return_legislation_code';
556: --
557: begin
558: --
559: hr_utility.set_location('Entering:'|| l_proc, 10);
560: --
561: -- Ensure that all the mandatory parameter are not null
562: --
563: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

573: close csr_leg_code;
574: --
575: -- The primary key is invalid therefore we must error
576: --
577: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
578: hr_utility.raise_error;
579: --
580: end if;
581: --

Line 578: hr_utility.raise_error;

574: --
575: -- The primary key is invalid therefore we must error
576: --
577: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
578: hr_utility.raise_error;
579: --
580: end if;
581: --
582: close csr_leg_code;

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

580: end if;
581: --
582: close csr_leg_code;
583: --
584: hr_utility.set_location(' Leaving:'|| l_proc, 20);
585: --
586: return l_legislation_code;
587: --
588: end return_legislation_code;