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.PER_SPH_BUS dependencies on HR_UTILITY

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

39: l_legislation_code varchar2(150);
40: --
41: begin
42: --
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error

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

79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --
85: end set_security_group_id;
86: --
87: -- ---------------------------------------------------------------------------

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

108: l_proc varchar2(72) := g_package||'return_legislation_code';
109: --
110: Begin
111: --
112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error

Line 130: hr_utility.set_location(l_proc, 20);

126: -- call to this function. Just return the value in the global
127: -- variable.
128: --
129: l_legislation_code := per_sph_bus.g_legislation_code;
130: hr_utility.set_location(l_proc, 20);
131: else
132: --
133: -- The ID is different to the last call to this function
134: -- or this is the first call to this function.

Line 147: hr_utility.set_location(l_proc,30);

143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
150: -- available for the next call to this function.
151: --

Line 156: hr_utility.set_location(' Leaving:'|| l_proc, 40);

152: close csr_leg_code;
153: per_sph_bus.g_plan_id := p_plan_id;
154: per_sph_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;
159: --
160: -- ----------------------------------------------------------------------------

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

191: --
192: l_proc varchar2(72) := g_package || 'chk_df';
193: --
194: begin
195: hr_utility.set_location('Entering:'||l_proc,10);
196: --
197: if ((p_rec.plan_id is not null) and (
198: nvl(per_sph_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

290: ,p_attribute20_value => p_rec.attribute20
291: );
292: end if;
293: --
294: hr_utility.set_location(' Leaving:'||l_proc,20);
295: end chk_df;
296: --
297: -- ----------------------------------------------------------------------------
298: -- |-----------------------< chk_non_updateable_args >------------------------|

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

363:
364:
365: --
366: Begin
367: hr_utility.set_location('Entering:'||l_proc, 5);
368:
369: hr_api.mandatory_arg_error
370: (p_api_name => l_proc
371: ,p_argument => 'start_date'

Line 377: hr_utility.set_location(l_proc, 20);

373: );
374:
375: if p_start_date is not null and p_end_date is not null and p_start_date > p_end_date
376: then
377: hr_utility.set_location(l_proc, 20);
378: hr_utility.set_message (800, 'PER_33885_SP_PL_ENDDT_STRTDT');
379: fnd_msg_pub.add;
380: end if;
381:

Line 378: hr_utility.set_message (800, 'PER_33885_SP_PL_ENDDT_STRTDT');

374:
375: if p_start_date is not null and p_end_date is not null and p_start_date > p_end_date
376: then
377: hr_utility.set_location(l_proc, 20);
378: hr_utility.set_message (800, 'PER_33885_SP_PL_ENDDT_STRTDT');
379: fnd_msg_pub.add;
380: end if;
381:
382: if p_start_date is not null and (p_rvw_date <= p_start_date or p_rvw_date > nvl(p_end_date, p_rvw_date) )

Line 384: hr_utility.set_location(l_proc, 30);

380: end if;
381:
382: if p_start_date is not null and (p_rvw_date <= p_start_date or p_rvw_date > nvl(p_end_date, p_rvw_date) )
383: then
384: hr_utility.set_location(l_proc, 30);
385: hr_utility.set_message (800, 'PER_33886_SP_RVWDT_LESS_STRTDT');
386: fnd_msg_pub.add;
387: end if;
388:

Line 385: hr_utility.set_message (800, 'PER_33886_SP_RVWDT_LESS_STRTDT');

381:
382: if p_start_date is not null and (p_rvw_date <= p_start_date or p_rvw_date > nvl(p_end_date, p_rvw_date) )
383: then
384: hr_utility.set_location(l_proc, 30);
385: hr_utility.set_message (800, 'PER_33886_SP_RVWDT_LESS_STRTDT');
386: fnd_msg_pub.add;
387: end if;
388:
389: if p_filled_on is not null and (p_filled_on < p_start_date or p_filled_on > nvl(p_end_date,p_filled_on) )

Line 391: hr_utility.set_location(l_proc, 40);

387: end if;
388:
389: if p_filled_on is not null and (p_filled_on < p_start_date or p_filled_on > nvl(p_end_date,p_filled_on) )
390: then
391: hr_utility.set_location(l_proc, 40);
392: hr_utility.set_message (800, 'PER_33889_SP_FILLED_ON_DT_VAL');
393: fnd_msg_pub.add;
394:
395: end if;

Line 392: hr_utility.set_message (800, 'PER_33889_SP_FILLED_ON_DT_VAL');

388:
389: if p_filled_on is not null and (p_filled_on < p_start_date or p_filled_on > nvl(p_end_date,p_filled_on) )
390: then
391: hr_utility.set_location(l_proc, 40);
392: hr_utility.set_message (800, 'PER_33889_SP_FILLED_ON_DT_VAL');
393: fnd_msg_pub.add;
394:
395: end if;
396:

Line 398: hr_utility.set_location(' Leaving:'||l_proc, 99);

394:
395: end if;
396:
397: --
398: hr_utility.set_location(' Leaving:'||l_proc, 99);
399: End chkDates;
400:
401: --
402: -- ----------------------------------------------------------------------------

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

416: where dtls.successee_id=p_successee_id
417: and dtls.successee_type=p_successee_type;
418: --
419: Begin
420: hr_utility.set_location('Entering:'||l_proc, 5);
421:
422: open csrSuccesseeDtls(p_successee_id, p_successee_type);
423: fetch csrSuccesseeDtls into l_max_plans;
424: if csrSuccesseeDtls%notfound

Line 426: hr_utility.set_location(l_proc, 30);

422: open csrSuccesseeDtls(p_successee_id, p_successee_type);
423: fetch csrSuccesseeDtls into l_max_plans;
424: if csrSuccesseeDtls%notfound
425: then
426: hr_utility.set_location(l_proc, 30);
427: close csrSuccesseeDtls;
428: return;
429: end if;
430: close csrSuccesseeDtls;

Line 432: hr_utility.set_location('l_max_plans :'||l_max_plans, 40);

428: return;
429: end if;
430: close csrSuccesseeDtls;
431:
432: hr_utility.set_location('l_max_plans :'||l_max_plans, 40);
433:
434: select count(*) into l_plan_count
435: from per_sp_plan
436: where successee_id=p_successee_id

Line 440: hr_utility.set_location('l_plan_count :'||l_plan_count, 50);

436: where successee_id=p_successee_id
437: and plan_type=p_successee_type
438: and status='A';
439:
440: hr_utility.set_location('l_plan_count :'||l_plan_count, 50);
441:
442: if l_plan_count >= l_max_plans
443: then
444: hr_utility.set_location(l_proc, 80);

Line 444: hr_utility.set_location(l_proc, 80);

440: hr_utility.set_location('l_plan_count :'||l_plan_count, 50);
441:
442: if l_plan_count >= l_max_plans
443: then
444: hr_utility.set_location(l_proc, 80);
445: hr_utility.set_message (800, 'PER_33887_SP_MAX_PLANS');
446: fnd_msg_pub.add;
447: end if;
448: --

Line 445: hr_utility.set_message (800, 'PER_33887_SP_MAX_PLANS');

441:
442: if l_plan_count >= l_max_plans
443: then
444: hr_utility.set_location(l_proc, 80);
445: hr_utility.set_message (800, 'PER_33887_SP_MAX_PLANS');
446: fnd_msg_pub.add;
447: end if;
448: --
449: hr_utility.set_location(' Leaving:'||l_proc, 99);

Line 449: hr_utility.set_location(' Leaving:'||l_proc, 99);

445: hr_utility.set_message (800, 'PER_33887_SP_MAX_PLANS');
446: fnd_msg_pub.add;
447: end if;
448: --
449: hr_utility.set_location(' Leaving:'||l_proc, 99);
450: End chkMaxPlans;
451:
452: --
453: -- ----------------------------------------------------------------------------

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

460: --
461: l_proc varchar2(72) := g_package||'insert_validate';
462: --
463: Begin
464: hr_utility.set_location('Entering:'||l_proc, 5);
465: --
466: -- Call all supporting business operations
467: --
468: hr_api.validate_bus_grp_id

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

485: --
486: --
487: per_sph_bus.chk_df(p_rec);
488: --
489: hr_utility.set_location(' Leaving:'||l_proc, 10);
490: End insert_validate;
491: --
492: -- ----------------------------------------------------------------------------
493: -- |---------------------------< update_validate >----------------------------|

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

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

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

527: --
528: --
529: per_sph_bus.chk_df(p_rec);
530: --
531: hr_utility.set_location(' Leaving:'||l_proc, 10);
532: End update_validate;
533: --
534: -- ----------------------------------------------------------------------------
535: -- |---------------------------< delete_validate >----------------------------|

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

540: --
541: l_proc varchar2(72) := g_package||'delete_validate';
542: --
543: Begin
544: hr_utility.set_location('Entering:'||l_proc, 5);
545: --
546: -- Call all supporting business operations
547: --
548: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

544: hr_utility.set_location('Entering:'||l_proc, 5);
545: --
546: -- Call all supporting business operations
547: --
548: hr_utility.set_location(' Leaving:'||l_proc, 10);
549: End delete_validate;
550: --
551: end per_sph_bus;