DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_UPDATE dependencies on FND_PROFILE

Line 816: hr_utility.set_location('Insert Enter:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);

812: l_proc VARCHAR2(72) := g_package||'insert_maintain_data';
813: BEGIN
814: hr_utility.set_location('Entering:'|| l_proc, 10);
815: --
816: hr_utility.set_location('Insert Enter:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);
817: per_qh_maintain_update.p_qh_organization_id := NULL; --- Added For Bug # 6706502
818:
819: SAVEPOINT insert_maintain_data;
820: -- support "future hires", especially necessary for HR Foundation.

Line 834: hr_utility.set_location('Insert EMP Before:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);

830: END IF;
831: --
832: IF p_system_person_type='EMP' THEN
833: hr_utility.set_location(l_proc, 30);
834: hr_utility.set_location('Insert EMP Before:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);
835: l_employee_number:=p_employee_number;
836: hr_employee_api.create_employee
837: (p_hire_date => l_creation_date --p_effective_date
838: ,p_business_group_id => p_business_group_id

Line 968: hr_utility.set_location('Insert EMP After:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);

964: ,p_assign_payroll_warning => l_assign_payroll_warning
965: ,p_orig_hire_warning => l_orig_hire_warning
966: );
967: p_hire_date := l_creation_date; -- Bug 3975241
968: hr_utility.set_location('Insert EMP After:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);
969: begin
970:
971: -- get the pds id id and ovn
972: SELECT asg.period_of_service_id,

Line 1277: hr_utility.set_location('Insert Add Before:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);

1273: -- Bug 3891200 Ends Here
1274: --
1275: --
1276: hr_utility.set_location(l_proc, 190);
1277: hr_utility.set_location('Insert Add Before:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);
1278: --
1279: hr_person_address_api.cre_or_upd_person_address
1280: (p_effective_date => l_creation_date --p_effective_date
1281: ,p_person_id => l_person_id

Line 1344: hr_utility.set_location('Insert Add After:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);

1340: p_addr_object_version_number:=l_addr_object_version_number;
1341: --
1342: hr_utility.set_location(l_proc, 200);
1343: --
1344: hr_utility.set_location('Insert Add After:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);
1345:
1346: END IF;
1347:
1348: ---- Fix For Bug # 6827296 Starts ----

Line 1361: hr_utility.set_location('Insert Asg Before:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);

1357: --
1358: IF p_assignment_type='E' THEN
1359: --
1360: hr_utility.set_location(l_proc, 110);
1361: hr_utility.set_location('Insert Asg Before:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);
1362: hr_utility.set_location('Insert Asg p_organization_id:' || p_organization_id, 13163);
1363: --
1364: -- Fix For Bug 6706502 Starts--
1365:

Line 1491: hr_utility.set_location('Insert Asg After:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);

1487: --
1488: hr_utility.set_location(l_proc,120);
1489: --
1490: per_qh_maintain_update.p_qh_organization_id := NULL; --- Added For Bug # 6706502
1491: hr_utility.set_location('Insert Asg After:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);
1492:
1493: hr_assignment_api.update_emp_asg_criteria
1494: (p_effective_date => l_creation_date --p_effective_date
1495: ,p_datetrack_update_mode => 'CORRECTION'

Line 1554: hr_utility.set_location('Insert Asg Cr After:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);

1550: );
1551: --
1552: hr_utility.set_location(l_proc, 130);
1553: --
1554: hr_utility.set_location('Insert Asg Cr After:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);
1555:
1556: IF l_no_managers_warning THEN
1557: l_org_now_no_manager_warning:=TRUE;
1558: END IF;

Line 2701: hr_utility.set_location('Insert After:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);

2697: --
2698: p_asg_object_version_number := l_asg_object_version_number;
2699: end if;
2700: --
2701: hr_utility.set_location('Insert After:' || fnd_profile.value('PER_ORGANIZATION_ID'), 13163);
2702: EXCEPTION
2703: WHEN OTHERS THEN
2704: ROLLBACK TO insert_maintain_data;
2705: RAISE;