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_OSE_BUS dependencies on HR_UTILITY

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

36: l_proc varchar2(72) := g_package||'set_security_group_id';
37: --
38: begin
39: --
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: --
42: -- Ensure that all the mandatory parameter are not null
43: --
44: hr_api.mandatory_arg_error

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

67: hr_api.set_security_group_id
68: (p_security_group_id => l_security_group_id
69: );
70: --
71: hr_utility.set_location(' Leaving:'|| l_proc, 20);
72: --
73: end set_security_group_id;
74: --
75: -- ---------------------------------------------------------------------------

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

96: l_proc varchar2(72) := g_package||'return_legislation_code';
97: --
98: Begin
99: --
100: hr_utility.set_location('Entering:'|| l_proc, 10);
101: --
102: -- Ensure that all the mandatory parameter are not null
103: --
104: hr_api.mandatory_arg_error

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

114: -- call to this function. Just return the value in the global
115: -- variable.
116: --
117: l_legislation_code := per_ose_bus.g_legislation_code;
118: hr_utility.set_location(l_proc, 20);
119: else
120: --
121: -- The ID is different to the last call to this function
122: -- or this is the first call to this function.

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

131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are
138: -- available for the next call to this function.
139: --

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

140: close csr_leg_code;
141: per_ose_bus.g_org_structure_element_id := p_org_structure_element_id;
142: per_ose_bus.g_legislation_code := l_legislation_code;
143: end if;
144: hr_utility.set_location(' Leaving:'|| l_proc, 40);
145: return l_legislation_code;
146: end return_legislation_code;
147: --
148: -- ----------------------------------------------------------------------------

Line 280: hr_utility.set_message('801','HR_6190_ORG_CHILDREN_EXIST');

276: p_org_structure_version_id
277: and ose.organization_id_parent =
278: p_organization_id_child);
279: --
280: hr_utility.set_message('801','HR_6190_ORG_CHILDREN_EXIST');
281: hr_utility.raise_error;
282: --
283: exception
284: when no_data_found then

Line 281: hr_utility.raise_error;

277: and ose.organization_id_parent =
278: p_organization_id_child);
279: --
280: hr_utility.set_message('801','HR_6190_ORG_CHILDREN_EXIST');
281: hr_utility.raise_error;
282: --
283: exception
284: when no_data_found then
285: null;

Line 351: hr_utility.set_message('801','HR_6753_ORG_HIER_SP_DEL');

347: )
348: )
349: ) );
350: --
351: hr_utility.set_message('801','HR_6753_ORG_HIER_SP_DEL');
352: hr_utility.raise_error;
353: --
354: exception
355: when no_data_found then

Line 352: hr_utility.raise_error;

348: )
349: ) );
350: --
351: hr_utility.set_message('801','HR_6753_ORG_HIER_SP_DEL');
352: hr_utility.raise_error;
353: --
354: exception
355: when no_data_found then
356: null;

Line 408: hr_utility.set_message('800','PER_50055_NON_POS_CTRL_STRUCT');

404: --
405: if l_result <> 'Y' then
406: --
407: close c1;
408: hr_utility.set_message('800','PER_50055_NON_POS_CTRL_STRUCT');
409: hr_utility.raise_error;
410: --
411: end if;
412: --

Line 409: hr_utility.raise_error;

405: if l_result <> 'Y' then
406: --
407: close c1;
408: hr_utility.set_message('800','PER_50055_NON_POS_CTRL_STRUCT');
409: hr_utility.raise_error;
410: --
411: end if;
412: --
413: end if;

Line 465: hr_utility.set_location('Entering:'||l_proc, 1);

461: l_dummy varchar2(1);
462: l_proc varchar2(100) := g_package||'chk_org_structure_version_id';
463:
464: begin
465: hr_utility.set_location('Entering:'||l_proc, 1);
466: --
467: -- Check mandatory parameters have been set
468: --
469: /* -- Bug fix 3065432

Line 481: hr_utility.set_message(800,'HR_289731_ORG_VER_NULL');

477: );
478: --
479: --
480: if p_org_structure_version_id is null then
481: hr_utility.set_message(800,'HR_289731_ORG_VER_NULL');
482: hr_utility.raise_error;
483: else
484: --
485: hr_utility.set_location(l_proc, 5);

Line 482: hr_utility.raise_error;

478: --
479: --
480: if p_org_structure_version_id is null then
481: hr_utility.set_message(800,'HR_289731_ORG_VER_NULL');
482: hr_utility.raise_error;
483: else
484: --
485: hr_utility.set_location(l_proc, 5);
486: --

Line 485: hr_utility.set_location(l_proc, 5);

481: hr_utility.set_message(800,'HR_289731_ORG_VER_NULL');
482: hr_utility.raise_error;
483: else
484: --
485: hr_utility.set_location(l_proc, 5);
486: --
487: -- Only proceed with validation if :
488: -- a) Inserting (org_structure_version_id is non updateable)
489: --

Line 496: hr_utility.set_message(800,'HR_289732_ORG_VER_INV');

492: open csr_org_structure_versions;
493: fetch csr_org_structure_versions into l_dummy;
494: if csr_org_structure_versions%notfound then
495: close csr_org_structure_versions;
496: hr_utility.set_message(800,'HR_289732_ORG_VER_INV');
497: hr_utility.raise_error;
498: end if;
499: close csr_org_structure_versions;
500:

Line 497: hr_utility.raise_error;

493: fetch csr_org_structure_versions into l_dummy;
494: if csr_org_structure_versions%notfound then
495: close csr_org_structure_versions;
496: hr_utility.set_message(800,'HR_289732_ORG_VER_INV');
497: hr_utility.raise_error;
498: end if;
499: close csr_org_structure_versions;
500:
501: end if;

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

499: close csr_org_structure_versions;
500:
501: end if;
502: end if;
503: hr_utility.set_location('Leaving:'||l_proc, 10);
504:
505: end chk_org_structure_version_id;
506:
507: -- -----------------------------------------------------------------------------

Line 574: hr_utility.set_location('Entering:'||l_proc, 1);

570: l_dummy varchar2(1);
571: l_proc varchar2(100) := g_package||'chk_parent_child_organization_id';
572:
573: begin
574: hr_utility.set_location('Entering:'||l_proc, 1);
575: --
576: -- Check mandatory parameters have been set
577: --
578: /* -- Bug fix 3065432

Line 589: hr_utility.set_message(800,'HR_289733_ORG_NULL');

585: );
586: --
587: --
588: if p_organization_id_parent is null or p_organization_id_child IS null then
589: hr_utility.set_message(800,'HR_289733_ORG_NULL');
590: hr_utility.raise_error;
591: else
592: --
593: --

Line 590: hr_utility.raise_error;

586: --
587: --
588: if p_organization_id_parent is null or p_organization_id_child IS null then
589: hr_utility.set_message(800,'HR_289733_ORG_NULL');
590: hr_utility.raise_error;
591: else
592: --
593: --
594: hr_utility.set_location(l_proc, 5);

Line 594: hr_utility.set_location(l_proc, 5);

590: hr_utility.raise_error;
591: else
592: --
593: --
594: hr_utility.set_location(l_proc, 5);
595: --
596: -- Only proceed with validation if :
597: -- a) Inserting (parent or child org id are non-updateable)
598: --

Line 605: hr_utility.set_message(800,'HR_289734_PARENT_ORG_INV');

601: open csr_org(p_org_id => p_organization_id_parent);
602: fetch csr_org into l_dummy;
603: if csr_org%notfound then
604: close csr_org;
605: hr_utility.set_message(800,'HR_289734_PARENT_ORG_INV');
606: hr_utility.raise_error;
607: end if;
608: close csr_org;
609:

Line 606: hr_utility.raise_error;

602: fetch csr_org into l_dummy;
603: if csr_org%notfound then
604: close csr_org;
605: hr_utility.set_message(800,'HR_289734_PARENT_ORG_INV');
606: hr_utility.raise_error;
607: end if;
608: close csr_org;
609:
610: hr_utility.set_location(l_proc, 20);

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

606: hr_utility.raise_error;
607: end if;
608: close csr_org;
609:
610: hr_utility.set_location(l_proc, 20);
611: -- check child org exists
612: open csr_org(p_organization_id_child);
613: fetch csr_org into l_dummy;
614: if csr_org%notfound then

Line 616: hr_utility.set_message(800,'HR_289735_CHILD_ORG_INV');

612: open csr_org(p_organization_id_child);
613: fetch csr_org into l_dummy;
614: if csr_org%notfound then
615: close csr_org;
616: hr_utility.set_message(800,'HR_289735_CHILD_ORG_INV');
617: hr_utility.raise_error;
618: end if;
619: close csr_org;
620: ---

Line 617: hr_utility.raise_error;

613: fetch csr_org into l_dummy;
614: if csr_org%notfound then
615: close csr_org;
616: hr_utility.set_message(800,'HR_289735_CHILD_ORG_INV');
617: hr_utility.raise_error;
618: end if;
619: close csr_org;
620: ---
621: --- bug fix 3820767 starts here

Line 625: hr_utility.set_message(800,'HR_449550_ORG_PAR_CHILD_EQUAL');

621: --- bug fix 3820767 starts here
622: ---
623: -- check if child is the same as parent
624: if p_organization_id_child =p_organization_id_parent then
625: hr_utility.set_message(800,'HR_449550_ORG_PAR_CHILD_EQUAL');
626: hr_utility.raise_error;
627: end if;
628: ---
629: hr_utility.set_location(l_proc, 25);

Line 626: hr_utility.raise_error;

622: ---
623: -- check if child is the same as parent
624: if p_organization_id_child =p_organization_id_parent then
625: hr_utility.set_message(800,'HR_449550_ORG_PAR_CHILD_EQUAL');
626: hr_utility.raise_error;
627: end if;
628: ---
629: hr_utility.set_location(l_proc, 25);
630: -- check for circular hierarchies

Line 629: hr_utility.set_location(l_proc, 25);

625: hr_utility.set_message(800,'HR_449550_ORG_PAR_CHILD_EQUAL');
626: hr_utility.raise_error;
627: end if;
628: ---
629: hr_utility.set_location(l_proc, 25);
630: -- check for circular hierarchies
631: for c_rec in csr_chk_circular
632: loop
633: if c_rec.organization_id_parent = p_organization_id_child

Line 636: hr_utility.set_message(800,'HR_449549_CIRCULAR_HIER');

632: loop
633: if c_rec.organization_id_parent = p_organization_id_child
634: then
635: -- This will cause circular hierarchies
636: hr_utility.set_message(800,'HR_449549_CIRCULAR_HIER');
637: hr_utility.raise_error;
638: end if;
639: end loop;
640: --

Line 637: hr_utility.raise_error;

633: if c_rec.organization_id_parent = p_organization_id_child
634: then
635: -- This will cause circular hierarchies
636: hr_utility.set_message(800,'HR_449549_CIRCULAR_HIER');
637: hr_utility.raise_error;
638: end if;
639: end loop;
640: --
641: -- bug fix 3820767 ends here

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

639: end loop;
640: --
641: -- bug fix 3820767 ends here
642: --
643: hr_utility.set_location(l_proc, 30);
644: -- check child is unique within the structure
645: open csr_ele;
646: fetch csr_ele into l_dummy;
647: if csr_ele%found then

Line 649: hr_utility.set_message(800,'HR_289736_CHILD_ORG_EXISTS');

645: open csr_ele;
646: fetch csr_ele into l_dummy;
647: if csr_ele%found then
648: close csr_ele;
649: hr_utility.set_message(800,'HR_289736_CHILD_ORG_EXISTS');
650: hr_utility.raise_error;
651: end if;
652: close csr_ele;
653:

Line 650: hr_utility.raise_error;

646: fetch csr_ele into l_dummy;
647: if csr_ele%found then
648: close csr_ele;
649: hr_utility.set_message(800,'HR_289736_CHILD_ORG_EXISTS');
650: hr_utility.raise_error;
651: end if;
652: close csr_ele;
653:
654: end if;

Line 657: hr_utility.set_location('Leaving:'||l_proc, 50);

653:
654: end if;
655: end if;
656:
657: hr_utility.set_location('Leaving:'||l_proc, 50);
658: --
659: end chk_parent_child_org_id;
660: --
661: --

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

670: l_proc varchar2(72) := g_package||'insert_validate';
671: l_exists_in_hierarchy varchar2(1);
672: --
673: Begin
674: hr_utility.set_location('Entering:'||l_proc, 5);
675: --
676: -- Call all supporting business operations
677: --
678: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id

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

719: fnd_message.set_name('PER', 'HR_289572_EXISTS_IN_HIERARCHY');
720: fnd_message.raise_error;
721: end if;
722: --
723: hr_utility.set_location(' Leaving:'||l_proc, 10);
724: End insert_validate;
725: --
726: -- ----------------------------------------------------------------------------
727: -- |---------------------------< update_validate >----------------------------|

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

734: l_proc varchar2(72) := g_package||'update_validate';
735: l_exists_in_hierarchy varchar2(1);
736: --
737: Begin
738: hr_utility.set_location('Entering:'||l_proc, 5);
739: --
740: -- Call all supporting business operations
741: --
742: -- EDIT_HERE: The following call to hr_api.validate_bus_grp_id

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

781: fnd_message.raise_error;
782: end if;
783: */
784:
785: hr_utility.set_location(' Leaving:'||l_proc, 10);
786: End update_validate;
787: --
788: -- ----------------------------------------------------------------------------
789: -- |---------------------------< 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: if p_chk_children_exist = 'Y' then

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

823: (p_org_structure_element_id => p_rec.org_structure_element_id
824: );
825: end if;
826: --
827: hr_utility.set_location(' Leaving:'||l_proc, 10);
828: End delete_validate;
829: --
830: end per_ose_bus;