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_CPO_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_cpo_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_popl_org_id => p_popl_org_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_popl_org_id;
78: --
79: -- ----------------------------------------------------------------------------

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

117: where a.organization_id = p_organization_id;
118: --
119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: l_api_updating := ben_cpo_shd.api_updating
124: (p_popl_org_id => p_popl_org_id,
125: p_effective_date => p_effective_date,

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

149: close c1;
150: --
151: end if;
152: --
153: hr_utility.set_location('Leaving:'||l_proc,10);
154: --
155: End chk_organization_id;
156: --
157: -- ----------------------------------------------------------------------------

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

184: l_proc varchar2(72) := g_package||'chk_pgm_pl_id';
185: --
186: Begin
187: --
188: hr_utility.set_location('Entering:'||l_proc,5);
189: --
190: -- check that only one of the foreign keys is populated.
191: --
192: if p_pgm_id is not null and

Line 195: hr_utility.set_message(801,'PGM_OR_PL_ID_SET');

191: --
192: if p_pgm_id is not null and
193: p_pl_id is not null then
194: --
195: hr_utility.set_message(801,'PGM_OR_PL_ID_SET');
196: hr_utility.raise_error;
197: --
198: elsif p_pgm_id is null and
199: p_pl_id is null then

Line 196: hr_utility.raise_error;

192: if p_pgm_id is not null and
193: p_pl_id is not null then
194: --
195: hr_utility.set_message(801,'PGM_OR_PL_ID_SET');
196: hr_utility.raise_error;
197: --
198: elsif p_pgm_id is null and
199: p_pl_id is null then
200: --

Line 201: hr_utility.set_message(801,'PGM_OR_PL_ID_SET');

197: --
198: elsif p_pgm_id is null and
199: p_pl_id is null then
200: --
201: hr_utility.set_message(801,'PGM_OR_PL_ID_SET');
202: hr_utility.raise_error;
203: --
204: end if;
205: --

Line 202: hr_utility.raise_error;

198: elsif p_pgm_id is null and
199: p_pl_id is null then
200: --
201: hr_utility.set_message(801,'PGM_OR_PL_ID_SET');
202: hr_utility.raise_error;
203: --
204: end if;
205: --
206: hr_utility.set_location('Leaving:'||l_proc,10);

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

202: hr_utility.raise_error;
203: --
204: end if;
205: --
206: hr_utility.set_location('Leaving:'||l_proc,10);
207: --
208: End chk_pgm_pl_id;
209:
210: -- ----------------------------------------------------------------------------

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

247: l_integrity_error Exception;
248: l_table_name all_tables.table_name%TYPE;
249: --
250: Begin
251: hr_utility.set_location('Entering:'||l_proc, 5);
252: --
253: -- Ensure that the p_datetrack_mode argument is not null
254: --
255: hr_api.mandatory_arg_error

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

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

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

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

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

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

Line 309: hr_utility.raise_error;

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

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

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

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

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

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

313: -- we must report
314: --
315: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
316: hr_utility.set_message_token('PROCEDURE', l_proc);
317: hr_utility.set_message_token('STEP','15');
318: hr_utility.raise_error;
319: End dt_update_validate;
320: --
321: -- ----------------------------------------------------------------------------

Line 318: hr_utility.raise_error;

314: --
315: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
316: hr_utility.set_message_token('PROCEDURE', l_proc);
317: hr_utility.set_message_token('STEP','15');
318: hr_utility.raise_error;
319: End dt_update_validate;
320: --
321: -- ----------------------------------------------------------------------------
322: -- |--------------------------< dt_delete_validate >--------------------------|

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

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

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

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

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

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

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

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

Line 413: hr_utility.raise_error;

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

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

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

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

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

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

417: -- we must report
418: --
419: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
420: hr_utility.set_message_token('PROCEDURE', l_proc);
421: hr_utility.set_message_token('STEP','15');
422: hr_utility.raise_error;
423: End dt_delete_validate;
424: --
425: -- ----------------------------------------------------------------------------

Line 422: hr_utility.raise_error;

418: --
419: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
420: hr_utility.set_message_token('PROCEDURE', l_proc);
421: hr_utility.set_message_token('STEP','15');
422: hr_utility.raise_error;
423: End dt_delete_validate;
424: --
425: -- ----------------------------------------------------------------------------
426: -- |---------------------------< insert_validate >----------------------------|

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

434: --
435: l_proc varchar2(72) := g_package||'insert_validate';
436: --
437: Begin
438: hr_utility.set_location('Entering:'||l_proc, 5);
439: --
440: -- Call all supporting business operations
441: --
442: --

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

457: (p_pgm_id => p_rec.pgm_id,
458: p_pl_id => p_rec.pl_id);
459: --
460:
461: hr_utility.set_location(' Leaving:'||l_proc, 10);
462: End insert_validate;
463: --
464: -- ----------------------------------------------------------------------------
465: -- |---------------------------< update_validate >----------------------------|

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

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

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

506: p_validation_start_date => p_validation_start_date,
507: p_validation_end_date => p_validation_end_date);
508: --
509:
510: hr_utility.set_location(' Leaving:'||l_proc, 10);
511: End update_validate;
512: --
513: -- ----------------------------------------------------------------------------
514: -- |---------------------------< delete_validate >----------------------------|

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

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

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

532: p_validation_start_date => p_validation_start_date,
533: p_validation_end_date => p_validation_end_date,
534: p_popl_org_id => p_rec.popl_org_id);
535: --
536: hr_utility.set_location(' Leaving:'||l_proc, 10);
537: End delete_validate;
538: --
539: -- ---------------------------------------------------------------------------
540: -- |---------------------< return_legislation_code >-------------------------|

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

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

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

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

Line 581: hr_utility.raise_error;

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

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

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