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_SIP_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_sip_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_sip_bus.g_successor_in_plan_id := p_successor_in_plan_id;
154: per_sip_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.successor_in_plan_id is not null) and (
198: nvl(per_sip_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 371: hr_utility.set_location('Entering:'||l_proc, 5);

367: where person_id=p_successor_id
368: and trunc(sysdate) between effective_start_date and effective_end_date;
369: --
370: Begin
371: hr_utility.set_location('Entering:'||l_proc, 5);
372:
373: l_max_plans := fnd_profile.value('PER_SP_MAX_PLANS_FOR_SCSR');
374:
375: if l_max_plans is not null and l_max_plans >=0

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

374:
375: if l_max_plans is not null and l_max_plans >=0
376: then
377:
378: hr_utility.set_location('l_max_plans :'||l_max_plans, 40);
379:
380: select count(*) into l_plan_count
381: from per_sp_successor_in_plan scsr,
382: per_sp_plan pl

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

384: and scsr.status='A'
385: and scsr.plan_id=pl.plan_id
386: and pl.status='A';
387:
388: hr_utility.set_location('l_plan_count :'||l_plan_count, 50);
389:
390: if l_plan_count >= l_max_plans
391: then
392: open csrPersonName;

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

392: open csrPersonName;
393: fetch csrPersonName into l_name;
394: close csrPersonName;
395:
396: hr_utility.set_location(l_proc, 80);
397: hr_utility.set_message (800, 'PER_33888_SP_SCSR_MAX_PLANS');
398: hr_utility.set_message_token('SCSR',l_name);
399: fnd_msg_pub.add;
400: end if;

Line 397: hr_utility.set_message (800, 'PER_33888_SP_SCSR_MAX_PLANS');

393: fetch csrPersonName into l_name;
394: close csrPersonName;
395:
396: hr_utility.set_location(l_proc, 80);
397: hr_utility.set_message (800, 'PER_33888_SP_SCSR_MAX_PLANS');
398: hr_utility.set_message_token('SCSR',l_name);
399: fnd_msg_pub.add;
400: end if;
401: end if;

Line 398: hr_utility.set_message_token('SCSR',l_name);

394: close csrPersonName;
395:
396: hr_utility.set_location(l_proc, 80);
397: hr_utility.set_message (800, 'PER_33888_SP_SCSR_MAX_PLANS');
398: hr_utility.set_message_token('SCSR',l_name);
399: fnd_msg_pub.add;
400: end if;
401: end if;
402: --

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

399: fnd_msg_pub.add;
400: end if;
401: end if;
402: --
403: hr_utility.set_location(' Leaving:'||l_proc, 99);
404: End chkMaxPlans;
405:
406: -- ----------------------------------------------------------------------------
407: -- |---------------------------< chkPlanStatus >----------------------------|

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

419: where plan_id=p_plan_id;
420:
421: --
422: Begin
423: hr_utility.set_location('Entering:'||l_proc, 5);
424:
425: open csrPlanStatus;
426: fetch csrPlanStatus into l_plan_status;
427: close csrPlanStatus;

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

427: close csrPlanStatus;
428:
429: if (l_plan_status = 'I')
430: then
431: hr_utility.set_location(l_proc, 80);
432: hr_utility.set_message (800, 'PER_ADD_DEL_SCRS_INA_PLAN');
433: fnd_msg_pub.add;
434: end if;
435: --

Line 432: hr_utility.set_message (800, 'PER_ADD_DEL_SCRS_INA_PLAN');

428:
429: if (l_plan_status = 'I')
430: then
431: hr_utility.set_location(l_proc, 80);
432: hr_utility.set_message (800, 'PER_ADD_DEL_SCRS_INA_PLAN');
433: fnd_msg_pub.add;
434: end if;
435: --
436: hr_utility.set_location(' Leaving:'||l_proc, 99);

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

432: hr_utility.set_message (800, 'PER_ADD_DEL_SCRS_INA_PLAN');
433: fnd_msg_pub.add;
434: end if;
435: --
436: hr_utility.set_location(' Leaving:'||l_proc, 99);
437: End chkPlanStatus;
438:
439: --
440: -- ----------------------------------------------------------------------------

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

487: and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date;
488:
489: --
490: Begin
491: hr_utility.set_location('Entering:'||l_proc, 5);
492:
493: open csrPersonType;
494: loop
495: fetch csrPersonType into l_person_type;

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

497: then
498: exit;
499: end if;
500:
501: hr_utility.set_location(l_proc, 20);
502:
503: if l_person_type = 'EMP'
504: then
505: l_emp :='Y';

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

515: end loop;
516: close csrPersonType;
517:
518: if l_emp = 'Y' then
519: hr_utility.set_location(l_proc, 40);
520: return ;
521: end if;
522:
523:

Line 525: hr_utility.set_location(l_proc, 55);

521: end if;
522:
523:
524:
525: hr_utility.set_location(l_proc, 55);
526:
527: open csrPlanDtls;
528: fetch csrPlanDtls into l_successee_id, l_type;
529: close csrPlanDtls;

Line 534: hr_utility.set_location(l_proc, 60);

530:
531: if l_successee_id is not null
532: then
533:
534: hr_utility.set_location(l_proc, 60);
535:
536: open csrSuccesseeDtls(l_successee_id, l_type);
537: fetch csrSuccesseeDtls into l_alw_npws, l_alw_applicants;
538: if csrSuccesseeDtls%notfound

Line 540: hr_utility.set_location(l_proc, 70);

536: open csrSuccesseeDtls(l_successee_id, l_type);
537: fetch csrSuccesseeDtls into l_alw_npws, l_alw_applicants;
538: if csrSuccesseeDtls%notfound
539: then
540: hr_utility.set_location(l_proc, 70);
541: close csrSuccesseeDtls;
542: return;
543: end if;
544: close csrSuccesseeDtls;

Line 549: hr_utility.set_location(l_proc, 75);

545:
546: if (l_alw_npws = 'Y' and l_npw = 'Y') or
547: (l_alw_applicants = 'Y' and l_appl = 'Y')
548: then
549: hr_utility.set_location(l_proc, 75);
550: return ;
551: else
552: open csrPersonName;
553: fetch csrPersonName into l_name;

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

551: else
552: open csrPersonName;
553: fetch csrPersonName into l_name;
554: close csrPersonName;
555: hr_utility.set_location(l_proc, 80);
556: hr_utility.set_message (800, 'PER_33881_SP_INV_PERSON_TYPE');
557: hr_utility.set_message_token('Invalid Successor Name',l_name);
558: fnd_msg_pub.add;
559: end if;

Line 556: hr_utility.set_message (800, 'PER_33881_SP_INV_PERSON_TYPE');

552: open csrPersonName;
553: fetch csrPersonName into l_name;
554: close csrPersonName;
555: hr_utility.set_location(l_proc, 80);
556: hr_utility.set_message (800, 'PER_33881_SP_INV_PERSON_TYPE');
557: hr_utility.set_message_token('Invalid Successor Name',l_name);
558: fnd_msg_pub.add;
559: end if;
560:

Line 557: hr_utility.set_message_token('Invalid Successor Name',l_name);

553: fetch csrPersonName into l_name;
554: close csrPersonName;
555: hr_utility.set_location(l_proc, 80);
556: hr_utility.set_message (800, 'PER_33881_SP_INV_PERSON_TYPE');
557: hr_utility.set_message_token('Invalid Successor Name',l_name);
558: fnd_msg_pub.add;
559: end if;
560:
561: end if;

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

561: end if;
562:
563:
564: --
565: hr_utility.set_location(' Leaving:'||l_proc, 99);
566: End chkPersonType;
567:
568: --
569: -- ----------------------------------------------------------------------------

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

595: --
596:
597: begin
598:
599: hr_utility.set_location('Entering:'||l_proc, 5);
600:
601: open csrPlanDtls;
602: fetch csrPlanDtls into l_successee_id, l_type;
603: close csrPlanDtls;

Line 608: hr_utility.set_location(l_proc, 60);

604:
605: if l_successee_id is not null
606: then
607:
608: hr_utility.set_location(l_proc, 60);
609:
610: open csrSuccesseeDtls(l_successee_id, l_type);
611: fetch csrSuccesseeDtls into l_max_successors;
612: if csrSuccesseeDtls%notfound

Line 614: hr_utility.set_location(l_proc, 70);

610: open csrSuccesseeDtls(l_successee_id, l_type);
611: fetch csrSuccesseeDtls into l_max_successors;
612: if csrSuccesseeDtls%notfound
613: then
614: hr_utility.set_location(l_proc, 70);
615: close csrSuccesseeDtls;
616: return;
617: end if;
618: close csrSuccesseeDtls;

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

622: WHERE plan_id = p_plan_id
623: AND status='A';
624: if l_scsr_count >= l_max_successors
625: then
626: hr_utility.set_location(l_proc, 80);
627: fnd_msg_pub.set_search_name(800, 'PER_33882_SP_MAX_SCSRS');
628: fnd_msg_pub.Delete_Msg;
629: hr_utility.set_message (800, 'PER_33882_SP_MAX_SCSRS');
630: fnd_msg_pub.add;

Line 629: hr_utility.set_message (800, 'PER_33882_SP_MAX_SCSRS');

625: then
626: hr_utility.set_location(l_proc, 80);
627: fnd_msg_pub.set_search_name(800, 'PER_33882_SP_MAX_SCSRS');
628: fnd_msg_pub.Delete_Msg;
629: hr_utility.set_message (800, 'PER_33882_SP_MAX_SCSRS');
630: fnd_msg_pub.add;
631: end if;
632:
633: end if;

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

632:
633: end if;
634:
635: --
636: hr_utility.set_location(' Leaving:'||l_proc, 99);
637: End chkMaxSuccessors;
638: --
639: -- ----------------------------------------------------------------------------
640: -- |---------------------------< chkDates >----------------------------|

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

663: where pl.plan_id=p_plan_id;
664:
665: --
666: Begin
667: hr_utility.set_location('Entering:'||l_proc, 5);
668:
669: open csrPlanDtls;
670: fetch csrPlanDtls into l_pl_strt_date, l_pl_end_date;
671: close csrPlanDtls;

Line 679: hr_utility.set_location(l_proc, 10);

675: close csrPersonName;
676:
677: if p_start_date is not null and p_end_date is not null and p_start_date > p_end_date
678: then
679: hr_utility.set_location(l_proc, 10);
680: hr_utility.set_message (800, 'PER_33883_SP_ENDDT_LESS_STRTDT');
681: hr_utility.set_message_token('SCSR',l_name);
682: fnd_msg_pub.add;
683: end if;

Line 680: hr_utility.set_message (800, 'PER_33883_SP_ENDDT_LESS_STRTDT');

676:
677: if p_start_date is not null and p_end_date is not null and p_start_date > p_end_date
678: then
679: hr_utility.set_location(l_proc, 10);
680: hr_utility.set_message (800, 'PER_33883_SP_ENDDT_LESS_STRTDT');
681: hr_utility.set_message_token('SCSR',l_name);
682: fnd_msg_pub.add;
683: end if;
684:

Line 681: hr_utility.set_message_token('SCSR',l_name);

677: if p_start_date is not null and p_end_date is not null and p_start_date > p_end_date
678: then
679: hr_utility.set_location(l_proc, 10);
680: hr_utility.set_message (800, 'PER_33883_SP_ENDDT_LESS_STRTDT');
681: hr_utility.set_message_token('SCSR',l_name);
682: fnd_msg_pub.add;
683: end if;
684:
685: if (p_start_date is not null and (p_start_date < l_pl_strt_date or p_start_date > l_pl_end_date)) or

Line 688: hr_utility.set_location(l_proc, 10);

684:
685: if (p_start_date is not null and (p_start_date < l_pl_strt_date or p_start_date > l_pl_end_date)) or
686: (p_end_date is not null and (p_end_date > l_pl_end_date or p_end_date < l_pl_strt_date))
687: then
688: hr_utility.set_location(l_proc, 10);
689: hr_utility.set_message (800, 'PER_33884_SP_SCSR_DT_BTW_PL_DT');
690: hr_utility.set_message_token('SCSR',l_name);
691: fnd_msg_pub.add;
692: end if;

Line 689: hr_utility.set_message (800, 'PER_33884_SP_SCSR_DT_BTW_PL_DT');

685: if (p_start_date is not null and (p_start_date < l_pl_strt_date or p_start_date > l_pl_end_date)) or
686: (p_end_date is not null and (p_end_date > l_pl_end_date or p_end_date < l_pl_strt_date))
687: then
688: hr_utility.set_location(l_proc, 10);
689: hr_utility.set_message (800, 'PER_33884_SP_SCSR_DT_BTW_PL_DT');
690: hr_utility.set_message_token('SCSR',l_name);
691: fnd_msg_pub.add;
692: end if;
693:

Line 690: hr_utility.set_message_token('SCSR',l_name);

686: (p_end_date is not null and (p_end_date > l_pl_end_date or p_end_date < l_pl_strt_date))
687: then
688: hr_utility.set_location(l_proc, 10);
689: hr_utility.set_message (800, 'PER_33884_SP_SCSR_DT_BTW_PL_DT');
690: hr_utility.set_message_token('SCSR',l_name);
691: fnd_msg_pub.add;
692: end if;
693:
694:

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

693:
694:
695:
696: --
697: hr_utility.set_location(' Leaving:'||l_proc, 10);
698: End chkDates;
699:
700: --
701: -- ----------------------------------------------------------------------------

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

708: --
709: l_proc varchar2(72) := g_package||'insert_validate';
710: --
711: Begin
712: hr_utility.set_location('Entering:'||l_proc, 5);
713: --
714: -- Call all supporting business operations
715: --
716: hr_api.validate_bus_grp_id

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

740: --
741: --
742: per_sip_bus.chk_df(p_rec);
743: --
744: hr_utility.set_location(' Leaving:'||l_proc, 10);
745: End insert_validate;
746: --
747: -- ----------------------------------------------------------------------------
748: -- |---------------------------< update_validate >----------------------------|

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

754: --
755: l_proc varchar2(72) := g_package||'update_validate';
756: --
757: Begin
758: hr_utility.set_location('Entering:'||l_proc, 5);
759: --
760: -- Call all supporting business operations
761: --
762: hr_api.validate_bus_grp_id

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

784: --
785: --
786: per_sip_bus.chk_df(p_rec);
787: --
788: hr_utility.set_location(' Leaving:'||l_proc, 10);
789: End update_validate;
790: --
791: -- ----------------------------------------------------------------------------
792: -- |---------------------------< delete_validate >----------------------------|

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

797: --
798: l_proc varchar2(72) := g_package||'delete_validate';
799: --
800: Begin
801: hr_utility.set_location('Entering:'||l_proc, 5);
802: --
803: -- Call all supporting business operations
804: --
805: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

801: hr_utility.set_location('Entering:'||l_proc, 5);
802: --
803: -- Call all supporting business operations
804: --
805: hr_utility.set_location(' Leaving:'||l_proc, 10);
806: End delete_validate;
807: --
808: end per_sip_bus;