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

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

810: --
811: l_work_at_home per_all_assignments_f.work_at_home%TYPE; --Fix for bug9215178
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:

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 833: hr_utility.set_location(l_proc, 30);

829: l_creation_date := nvl(p_placement_date_start,p_effective_date);
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

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 1266: hr_utility.set_location(l_proc, 50);

1262: -- p_name_combination_warning:=l_name_combination_warning; - checked already
1263: p_assign_payroll_warning:=l_assign_payroll_warning;
1264: -- p_orig_hire_warning:=l_orig_hire_warning; - insert of person, so not applicable
1265: --
1266: hr_utility.set_location(l_proc, 50);
1267: --
1268: --
1269: -- Bug 3891200 Starts Here
1270: -- Desc: Modified the if condition.to replace address_line1 with style and date_from

Line 1276: hr_utility.set_location(l_proc, 190);

1272: IF p_style is not null and p_adr_date_from is not null then
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

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 1342: hr_utility.set_location(l_proc, 200);

1338: --
1339: p_address_id:=l_address_id;
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;

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 1360: hr_utility.set_location(l_proc, 110);

1356: -- employee assignments
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--

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 1362: hr_utility.set_location('Insert Asg p_organization_id:' || p_organization_id, 13163);

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:
1366: per_qh_maintain_update.p_qh_organization_id := p_organization_id;

Line 1372: hr_utility.set_location(l_proc, 110);

1368: -- Fix For Bug 6706502 Ends--
1369:
1370: l_work_at_home:=nvl (p_work_at_home,'N');--FIX FOR BUG 9215178
1371:
1372: hr_utility.set_location(l_proc, 110);
1373: --
1374: hr_assignment_api.update_emp_asg
1375: (p_effective_date => l_creation_date --p_effective_date
1376: ,p_datetrack_update_mode => 'CORRECTION'

Line 1488: hr_utility.set_location(l_proc,120);

1484: ,p_hourly_salaried_warning => l_hourly_salaried_warning
1485: ,p_gsp_post_process_warning => l_gsp_post_process_warning
1486: );
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:

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 1552: hr_utility.set_location(l_proc, 130);

1548: ,p_concatenated_segments => l_concatenated_segments
1549: ,p_gsp_post_process_warning => l_gsp_post_process_warning2
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

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 1567: hr_utility.raise_error;

1563: --
1564: IF l_spp_delete_warning THEN
1565: --
1566: fnd_message.set_name('PER', 'HR_289828_INV_SPP_CHANGE');
1567: hr_utility.raise_error;
1568: --
1569: END IF;
1570: --
1571: hr_utility.set_location(l_proc, 140);

Line 1571: hr_utility.set_location(l_proc, 140);

1567: hr_utility.raise_error;
1568: --
1569: END IF;
1570: --
1571: hr_utility.set_location(l_proc, 140);
1572: --
1573: ELSIF p_assignment_type='A' then
1574: --
1575: hr_utility.set_location(l_proc, 150);

Line 1575: hr_utility.set_location(l_proc, 150);

1571: hr_utility.set_location(l_proc, 140);
1572: --
1573: ELSIF p_assignment_type='A' then
1574: --
1575: hr_utility.set_location(l_proc, 150);
1576: --
1577: hr_assignment_api.update_apl_asg
1578: (p_effective_date => l_creation_date --p_effective_date
1579: ,p_datetrack_update_mode => 'CORRECTION'

Line 1731: hr_utility.set_location(l_proc, 160);

1727: ,p_effective_start_date => l_asg_effective_start_date
1728: ,p_effective_end_date => l_asg_effective_end_date
1729: );
1730: --
1731: hr_utility.set_location(l_proc, 160);
1732: --
1733: ELSIF p_assignment_type='C' then --CWK assignment
1734: --
1735: hr_utility.set_location(l_proc, 162);

Line 1735: hr_utility.set_location(l_proc, 162);

1731: hr_utility.set_location(l_proc, 160);
1732: --
1733: ELSIF p_assignment_type='C' then --CWK assignment
1734: --
1735: hr_utility.set_location(l_proc, 162);
1736: hr_utility.set_location(to_char(p_projected_assignment_end,'DD-MON-YYYY'), 162);
1737:
1738: hr_assignment_api.update_cwk_asg
1739: (p_effective_date => l_creation_date --p_effective_date

Line 1736: hr_utility.set_location(to_char(p_projected_assignment_end,'DD-MON-YYYY'), 162);

1732: --
1733: ELSIF p_assignment_type='C' then --CWK assignment
1734: --
1735: hr_utility.set_location(l_proc, 162);
1736: hr_utility.set_location(to_char(p_projected_assignment_end,'DD-MON-YYYY'), 162);
1737:
1738: hr_assignment_api.update_cwk_asg
1739: (p_effective_date => l_creation_date --p_effective_date
1740: ,p_datetrack_update_mode => 'CORRECTION'

Line 1840: hr_utility.set_location(l_proc, 163);

1836: ,p_concatenated_segments => l_concatenated_segments
1837: ,p_hourly_salaried_warning => l_hourly_salaried_warning
1838: );
1839: --
1840: hr_utility.set_location(l_proc, 163);
1841: --
1842: hr_assignment_api.update_cwk_asg_criteria
1843: (p_effective_date => l_creation_date --p_effective_date
1844: ,p_datetrack_update_mode => 'CORRECTION'

Line 1895: hr_utility.set_location(l_proc, 164);

1891: ,p_entries_changed_warning => l_entries_changed_warning
1892: ,p_tax_district_changed_warning => l_tax_district_changed_warning
1893: );
1894: --
1895: hr_utility.set_location(l_proc, 164);
1896: --
1897: IF p_rate_id is not null then --an assignment rate has been entered for the CWK
1898: hr_rate_values_api.create_assignment_rate_value
1899: (p_effective_date => l_creation_date --p_effective_date

Line 1939: hr_utility.set_location(l_proc, 165);

1935: --
1936: -- bug2999562 support gsp post process
1937: --
1938: if l_gsp_post_process_warning is not null then
1939: hr_utility.set_location(l_proc, 165);
1940: p_gsp_post_process_warning := l_gsp_post_process_warning;
1941: elsif l_gsp_post_process_warning2 is not null then
1942: hr_utility.set_location(l_proc, 166);
1943: p_gsp_post_process_warning := l_gsp_post_process_warning2;

Line 1942: hr_utility.set_location(l_proc, 166);

1938: if l_gsp_post_process_warning is not null then
1939: hr_utility.set_location(l_proc, 165);
1940: p_gsp_post_process_warning := l_gsp_post_process_warning;
1941: elsif l_gsp_post_process_warning2 is not null then
1942: hr_utility.set_location(l_proc, 166);
1943: p_gsp_post_process_warning := l_gsp_post_process_warning2;
1944: else
1945: p_gsp_post_process_warning := null;
1946: end if;

Line 1948: hr_utility.set_location(l_proc, 167);

1944: else
1945: p_gsp_post_process_warning := null;
1946: end if;
1947:
1948: hr_utility.set_location(l_proc, 167);
1949: --
1950: IF l_application_id IS NOT NULL AND
1951: (p_projected_hire_date IS NOT NULL
1952: OR p_appl_attribute_category IS NOT NULL

Line 1977: hr_utility.set_location(l_proc, 170);

1973: OR p_current_employer IS NOT NULL
1974: OR p_termination_reason IS NOT NULL) THEN
1975: --
1976: --
1977: hr_utility.set_location(l_proc, 170);
1978: --
1979: hr_application_api.update_apl_details
1980: (p_application_id => l_application_id
1981: ,p_object_version_number => l_app_object_version_number

Line 2009: hr_utility.set_location(l_proc, 180);

2005: ,p_appl_attribute19 => p_appl_attribute19
2006: ,p_appl_attribute20 => p_appl_attribute20
2007: );
2008: --
2009: hr_utility.set_location(l_proc, 180);
2010: --
2011: p_app_object_version_number:=l_app_object_version_number;
2012: p_application_id:=l_application_id;
2013: END IF;

Line 2015: hr_utility.set_location(l_proc, 185);

2011: p_app_object_version_number:=l_app_object_version_number;
2012: p_application_id:=l_application_id;
2013: END IF;
2014: --
2015: hr_utility.set_location(l_proc, 185);
2016: --
2017: -- home phone
2018: --
2019: IF p_phn_h_phone_number IS NOT NULL THEN

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;

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

3540: -- end of bug 4553630
3541:
3542: l_proc VARCHAR2(72) := g_package||'update_maintain_data';
3543: BEGIN
3544: hr_utility.set_location('Entering:'|| l_proc, 10);
3545: --
3546: per_qh_maintain_update.p_qh_organization_id := NULL; --- Added For Bug # 6706502
3547:
3548: SAVEPOINT update_maintain_data;

Line 3556: hr_utility.set_message(800, 'HR_449032_PRIMARY_ADDR_EXISTS');

3552: open chk_primary ;
3553: fetch chk_primary into l_check_primary;
3554: if chk_primary%found then
3555: close chk_primary;
3556: hr_utility.set_message(800, 'HR_449032_PRIMARY_ADDR_EXISTS');
3557: hr_utility.raise_error;
3558: else
3559: close chk_primary;
3560: end if;

Line 3557: hr_utility.raise_error;

3553: fetch chk_primary into l_check_primary;
3554: if chk_primary%found then
3555: close chk_primary;
3556: hr_utility.set_message(800, 'HR_449032_PRIMARY_ADDR_EXISTS');
3557: hr_utility.raise_error;
3558: else
3559: close chk_primary;
3560: end if;
3561: end if;

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

3611: l_grade_rule_id := p_grade_rule_id;
3612: l_rate_object_version_number:= p_rate_object_version_number;
3613: end if;
3614: --
3615: hr_utility.set_location(l_proc, 20);
3616: --
3617: lock_maintain_data
3618: (p_effective_date => p_effective_date
3619: ,p_datetrack_update_mode => p_datetrack_update_mode

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

3678: ,p_chk10_checklist_item_id => p_chk10_checklist_item_id
3679: ,p_chk10_object_version_number => p_chk10_object_version_number
3680: );
3681: --
3682: hr_utility.set_location(l_proc, 30);
3683: --
3684: -- check to see if the person fields have been changed
3685: --
3686: IF p_person_update_allowed='TRUE' AND

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

3936: OR NVL(per_per_shd.g_old_rec.country_of_birth,hr_api.g_varchar2)
3937: <>NVL(p_country_of_birth,hr_api.g_varchar2)
3938: ) THEN
3939: --
3940: hr_utility.set_location(l_proc, 40);
3941: --
3942: select party_id
3943: into l_party_id
3944: from per_all_people_f

Line 4107: hr_utility.set_location(l_proc, 50);

4103: );
4104: p_full_name:=l_full_name;
4105: end if;
4106: --
4107: hr_utility.set_location(l_proc, 50);
4108: --
4109: --
4110: --removed clause which updated projected_placement_end on placement table
4111: --now that column is superceded by projected_assignment)_end on assignment

Line 4213: hr_utility.set_location(l_proc, 190);

4209: <> NVL(p_add_information20,hr_api.g_varchar2)
4210: ) ) THEN
4211: --
4212: --
4213: hr_utility.set_location(l_proc, 190);
4214: --
4215: hr_person_address_api.cre_or_upd_person_address
4216: (p_effective_date => p_effective_date
4217: ,p_person_id => p_person_id

Line 4276: hr_utility.set_location(l_proc, 200);

4272: ,p_object_version_number => l_addr_object_version_number
4273: );
4274: --
4275: --
4276: hr_utility.set_location(l_proc, 200);
4277: --
4278: END IF;
4279: --
4280: p_addr_object_version_number:=l_addr_object_version_number;

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

4287: -- check to see if the assignment data has changed
4288: --
4289: IF per_asg_shd.g_old_rec.people_group_id IS NOT NULL THEN
4290: --
4291: hr_utility.set_location(l_proc, 60);
4292: --
4293: OPEN csr_pgp_rec(per_asg_shd.g_old_rec.people_group_id);
4294: FETCH csr_pgp_rec INTO l_pgp_rec;
4295: CLOSE csr_pgp_rec;

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

4296: END IF;
4297: --
4298: IF per_asg_shd.g_old_rec.soft_coding_keyflex_id IS NOT NULL THEN
4299: --
4300: hr_utility.set_location(l_proc, 70);
4301: --
4302: OPEN csr_scl_rec(per_asg_shd.g_old_rec.soft_coding_keyflex_id);
4303: FETCH csr_scl_rec INTO l_scl_rec;
4304: CLOSE csr_scl_rec;

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

4303: FETCH csr_scl_rec INTO l_scl_rec;
4304: CLOSE csr_scl_rec;
4305: END IF;
4306: --
4307: hr_utility.set_location(l_proc, 80);
4308: --
4309: IF NVL(per_asg_shd.g_old_rec.recruiter_id,hr_api.g_number)
4310: <>NVL(p_recruiter_id,hr_api.g_number)
4311: OR NVL(per_asg_shd.g_old_rec.grade_id,hr_api.g_number)

Line 4617: hr_utility.set_location(l_proc, 100);

4613: <>NVL(p_projected_assignment_end,hr_api.g_date)
4614:
4615: THEN
4616: --
4617: hr_utility.set_location(l_proc, 100);
4618: --
4619: --
4620: -- employee assignments
4621: --

Line 4624: hr_utility.set_location(l_proc, 110);

4620: -- employee assignments
4621: --
4622: IF p_assignment_type='E' THEN
4623: --
4624: hr_utility.set_location(l_proc, 110);
4625: --
4626: --
4627: -- Bug 3174130 Start here
4628: -- Description : Swapped the two assignment update procedures ' hr_assignment_api.update_emp_asg'

Line 4726: hr_utility.set_location(l_proc, 120);

4722: ,p_gsp_post_process_warning => l_gsp_post_process_warning -- bug2999562
4723: );
4724:
4725: --
4726: hr_utility.set_location(l_proc, 120);
4727: --
4728: hr_dflex_utility.remove_ignore_df_validation;
4729: hr_kflex_utility.remove_ignore_kf_validation;
4730:

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

4843: ,p_gsp_post_process_warning => l_gsp_post_process_warning2 -- bug2999562
4844: );
4845:
4846: --
4847: hr_utility.set_location(l_proc, 130);
4848: --
4849: --
4850: -- Bug 3174130 End here
4851: --

Line 4864: hr_utility.raise_error;

4860: --
4861: IF l_spp_delete_warning THEN
4862: --
4863: fnd_message.set_name('PER', 'HR_289828_INV_SPP_CHANGE');
4864: hr_utility.raise_error;
4865: --
4866: END IF;
4867: --
4868: hr_utility.set_location(l_proc, 140);

Line 4868: hr_utility.set_location(l_proc, 140);

4864: hr_utility.raise_error;
4865: --
4866: END IF;
4867: --
4868: hr_utility.set_location(l_proc, 140);
4869: --
4870: ELSIF p_assignment_type = 'A' then
4871: --
4872: hr_utility.set_location(l_proc, 150);

Line 4872: hr_utility.set_location(l_proc, 150);

4868: hr_utility.set_location(l_proc, 140);
4869: --
4870: ELSIF p_assignment_type = 'A' then
4871: --
4872: hr_utility.set_location(l_proc, 150);
4873: --
4874: hr_assignment_api.update_apl_asg
4875: (p_effective_date => p_effective_date
4876: ,p_datetrack_update_mode => l_asg_datetrack_update_mode

Line 5028: hr_utility.set_location(l_proc, 160);

5024: ,p_effective_start_date => l_asg_effective_start_date
5025: ,p_effective_end_date => l_asg_effective_end_date
5026: );
5027: --
5028: hr_utility.set_location(l_proc, 160);
5029: --
5030: ELSIF p_assignment_type = 'C' then
5031: hr_assignment_api.update_cwk_asg_criteria
5032: (p_effective_date => p_effective_date

Line 5084: hr_utility.set_location(l_proc, 163);

5080: ,p_entries_changed_warning => l_entries_changed_warning
5081: ,p_tax_district_changed_warning => l_tax_district_changed_warning
5082: );
5083: --
5084: hr_utility.set_location(l_proc, 163);
5085: --
5086: hr_assignment_api.update_cwk_asg
5087: (p_effective_date => p_effective_date
5088: ,p_datetrack_update_mode => 'CORRECTION'

Line 5193: hr_utility.set_location(l_proc, 1010);

5189: END IF; --is assignment_update_allowed
5190: IF p_assignment_type='C' THEN
5191: IF p_grade_rule_id is null
5192: AND p_rate_id is not null then --an assignment rate has been entered for the CWK
5193: hr_utility.set_location(l_proc, 1010);
5194: hr_rate_values_api.create_assignment_rate_value
5195: (p_effective_date => p_effective_date
5196: ,p_business_group_id => p_business_group_id
5197: ,p_rate_id => p_rate_id

Line 5218: hr_utility.set_location(l_proc, 1020);

5214: <>nvl(p_rate_currency_code,hr_api.g_varchar2)
5215: OR nvl(pay_pgr_shd.g_old_rec.value,hr_api.g_varchar2)
5216: <>nvl(p_rate_value,hr_api.g_varchar2) )
5217: THEN
5218: hr_utility.set_location(l_proc, 1020);
5219: hr_rate_values_api.update_assignment_rate_value
5220: (p_effective_date => p_effective_date
5221: ,p_grade_rule_id => l_grade_rule_id
5222: ,p_datetrack_mode => l_rate_datetrack_update_mode

Line 5235: hr_utility.set_location(l_proc, 1030);

5231: p_rate_effective_end_date := l_rate_effective_end_date;
5232: ELSE
5233: --special case: multiple rates, the query code has explicitly set grade_rule_id
5234: --but set rate_id null and the fields are not updateable anyway
5235: hr_utility.set_location(l_proc, 1030);
5236: END IF;
5237: END IF;
5238: ELSE -- we are entering a secondary assignment.
5239: IF p_assignment_type='E' THEN

Line 5731: hr_utility.set_location(l_proc, 162);

5727: --
5728: -- bug2999562 support gsp post process
5729: --
5730: if l_gsp_post_process_warning is not null then
5731: hr_utility.set_location(l_proc, 162);
5732: p_gsp_post_process_warning := l_gsp_post_process_warning;
5733: elsif l_gsp_post_process_warning2 is not null then
5734: hr_utility.set_location(l_proc, 163);
5735: p_gsp_post_process_warning := l_gsp_post_process_warning2;

Line 5734: hr_utility.set_location(l_proc, 163);

5730: if l_gsp_post_process_warning is not null then
5731: hr_utility.set_location(l_proc, 162);
5732: p_gsp_post_process_warning := l_gsp_post_process_warning;
5733: elsif l_gsp_post_process_warning2 is not null then
5734: hr_utility.set_location(l_proc, 163);
5735: p_gsp_post_process_warning := l_gsp_post_process_warning2;
5736: elsif l_gsp_post_process_warning3 is not null then
5737: hr_utility.set_location(l_proc, 164);
5738: p_gsp_post_process_warning := l_gsp_post_process_warning3;

Line 5737: hr_utility.set_location(l_proc, 164);

5733: elsif l_gsp_post_process_warning2 is not null then
5734: hr_utility.set_location(l_proc, 163);
5735: p_gsp_post_process_warning := l_gsp_post_process_warning2;
5736: elsif l_gsp_post_process_warning3 is not null then
5737: hr_utility.set_location(l_proc, 164);
5738: p_gsp_post_process_warning := l_gsp_post_process_warning3;
5739: else
5740: p_gsp_post_process_warning := null;
5741: end if;

Line 5743: hr_utility.set_location(l_proc, 165);

5739: else
5740: p_gsp_post_process_warning := null;
5741: end if;
5742: --
5743: hr_utility.set_location(l_proc, 165);
5744: --
5745: IF p_application_id IS NOT NULL AND (
5746: NVL(per_apl_shd.g_old_rec.projected_hire_date,hr_api.g_date)
5747: <> NVL(p_projected_hire_date,hr_api.g_date)

Line 5796: hr_utility.set_location(l_proc, 170);

5792: OR NVL(per_apl_shd.g_old_rec.termination_reason,hr_api.g_varchar2)
5793: <> NVL(p_termination_reason,hr_api.g_varchar2)) THEN
5794: --
5795: --
5796: hr_utility.set_location(l_proc, 170);
5797: --
5798: hr_application_api.update_apl_details
5799: (p_application_id => p_application_id
5800: ,p_object_version_number => l_app_object_version_number

Line 5828: hr_utility.set_location(l_proc, 180);

5824: ,p_appl_attribute19 => p_appl_attribute19
5825: ,p_appl_attribute20 => p_appl_attribute20
5826: );
5827: --
5828: hr_utility.set_location(l_proc, 180);
5829: --
5830: END IF;
5831: --
5832: p_app_object_version_number:=l_app_object_version_number;

Line 5834: hr_utility.set_location(l_proc, 185);

5830: END IF;
5831: --
5832: p_app_object_version_number:=l_app_object_version_number;
5833: --
5834: hr_utility.set_location(l_proc, 185);
5835: -- home phone
5836: --
5837: IF p_phn_h_phone_id IS NOT NULL THEN
5838: per_phn_shd.lck

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

7125: WHERE person_id = p_person_id
7126: AND date_start = p_pds_hire_date;
7127: --
7128: BEGIN
7129: hr_utility.set_location('Entering:'|| l_proc, 10);
7130: --
7131: IF p_person_update_allowed='TRUE' THEN
7132: IF p_per_effective_start_date=p_effective_date THEN
7133: l_per_datetrack_update_mode:='CORRECTION';

Line 7146: hr_utility.set_location(l_proc, 15);

7142: ,p_object_version_number => p_per_object_version_number
7143: ,p_validation_start_date => p_per_validation_start_date
7144: ,p_validation_end_date => p_per_validation_end_date
7145: );
7146: hr_utility.set_location(l_proc, 15);
7147: IF p_pdp_object_version_number IS NOT NULL then
7148: open csr_pdp_rec(p_person_id,p_placement_date_start);
7149: fetch csr_pdp_rec into l_period_of_placement_id;
7150: close csr_pdp_rec;

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

7164: );
7165: END IF;
7166: --
7167: IF p_assignment_id IS NOT NULL AND p_assignment_update_allowed='TRUE' THEN
7168: hr_utility.set_location(l_proc, 20);
7169: --
7170: IF p_asg_effective_start_date=p_effective_date THEN
7171: l_asg_datetrack_update_mode:='CORRECTION';
7172: ELSE

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

7187: END IF;
7188: --
7189: IF p_grade_rule_id is not null
7190: AND p_rate_object_version_number is not null THEN
7191: hr_utility.set_location(l_proc, 25);
7192: IF p_rate_effective_start_date=p_effective_date THEN
7193: l_rate_datetrack_update_mode:='CORRECTION';
7194: ELSE
7195: l_rate_datetrack_update_mode:=p_datetrack_update_mode;

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

7205: );
7206: END IF;
7207: --
7208: IF p_application_id IS NOT NULL THEN
7209: hr_utility.set_location(l_proc, 30);
7210: --
7211: per_apl_shd.lck
7212: (p_application_id => p_application_id
7213: ,p_object_version_number => p_app_object_version_number);

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

7213: ,p_object_version_number => p_app_object_version_number);
7214: END IF;
7215: --
7216: IF p_address_id IS NOT NULL THEN
7217: hr_utility.set_location(l_proc, 40);
7218: --
7219: per_add_shd.lck
7220: (p_address_id => p_address_id
7221: ,p_object_version_number => p_addr_object_version_number);

Line 7225: hr_utility.set_location(l_proc, 50);

7221: ,p_object_version_number => p_addr_object_version_number);
7222: END IF;
7223: --
7224: IF p_phn_h_phone_id IS NOT NULL THEN
7225: hr_utility.set_location(l_proc, 50);
7226: --
7227: per_phn_shd.lck
7228: (p_phone_id => p_phn_h_phone_id
7229: ,p_object_version_number => p_phn_h_object_version_number);

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

7229: ,p_object_version_number => p_phn_h_object_version_number);
7230: END IF;
7231: --
7232: IF p_phn_w_phone_id IS NOT NULL THEN
7233: hr_utility.set_location(l_proc, 60);
7234: --
7235: per_phn_shd.lck
7236: (p_phone_id => p_phn_w_phone_id
7237: ,p_object_version_number => p_phn_w_object_version_number);

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

7237: ,p_object_version_number => p_phn_w_object_version_number);
7238: END IF;
7239: --
7240: IF p_phn_m_phone_id IS NOT NULL THEN
7241: hr_utility.set_location(l_proc, 70);
7242: --
7243: per_phn_shd.lck
7244: (p_phone_id => p_phn_m_phone_id
7245: ,p_object_version_number => p_phn_m_object_version_number);

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

7245: ,p_object_version_number => p_phn_m_object_version_number);
7246: END IF;
7247: --
7248: IF p_phn_hf_phone_id IS NOT NULL THEN
7249: hr_utility.set_location(l_proc, 80);
7250: --
7251: per_phn_shd.lck
7252: (p_phone_id => p_phn_hf_phone_id
7253: ,p_object_version_number => p_phn_hf_object_version_number);

Line 7257: hr_utility.set_location(l_proc, 90);

7253: ,p_object_version_number => p_phn_hf_object_version_number);
7254: END IF;
7255: --
7256: IF p_phn_wf_phone_id IS NOT NULL THEN
7257: hr_utility.set_location(l_proc, 90);
7258: --
7259: per_phn_shd.lck
7260: (p_phone_id => p_phn_wf_phone_id
7261: ,p_object_version_number => p_phn_wf_object_version_number);

Line 7265: hr_utility.set_location(l_proc, 100);

7261: ,p_object_version_number => p_phn_wf_object_version_number);
7262: END IF;
7263: --
7264: IF p_pay_proposal_id IS NOT NULL THEN
7265: hr_utility.set_location(l_proc, 100);
7266: --
7267: per_pyp_shd.lck
7268: (p_pay_proposal_id => p_pay_proposal_id
7269: ,p_object_version_number => p_pyp_object_version_number);

Line 7273: hr_utility.set_location(l_proc, 110);

7269: ,p_object_version_number => p_pyp_object_version_number);
7270: END IF;
7271: --
7272: IF p_deployment_factor_id IS NOT NULL THEN
7273: hr_utility.set_location(l_proc, 110);
7274: --
7275: per_dpf_shd.lck
7276: (p_deployment_factor_id => p_deployment_factor_id
7277: ,p_object_version_number => p_dpf_object_version_number);

Line 7281: hr_utility.set_location(l_proc, 120);

7277: ,p_object_version_number => p_dpf_object_version_number);
7278: END IF;
7279: --
7280: IF p_chk1_checklist_item_id IS NOT NULL THEN
7281: hr_utility.set_location(l_proc, 120);
7282: --
7283: per_chk_shd.lck
7284: (p_checklist_item_id => p_chk1_checklist_item_id
7285: ,p_object_version_number => p_chk1_object_version_number);

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

7285: ,p_object_version_number => p_chk1_object_version_number);
7286: END IF;
7287: --
7288: IF p_chk2_checklist_item_id IS NOT NULL THEN
7289: hr_utility.set_location(l_proc, 130);
7290: --
7291: per_chk_shd.lck
7292: (p_checklist_item_id => p_chk2_checklist_item_id
7293: ,p_object_version_number => p_chk2_object_version_number);

Line 7297: hr_utility.set_location(l_proc, 140);

7293: ,p_object_version_number => p_chk2_object_version_number);
7294: END IF;
7295: --
7296: IF p_chk3_checklist_item_id IS NOT NULL THEN
7297: hr_utility.set_location(l_proc, 140);
7298: --
7299: per_chk_shd.lck
7300: (p_checklist_item_id => p_chk3_checklist_item_id
7301: ,p_object_version_number => p_chk3_object_version_number);

Line 7305: hr_utility.set_location(l_proc, 150);

7301: ,p_object_version_number => p_chk3_object_version_number);
7302: END IF;
7303: --
7304: IF p_chk4_checklist_item_id IS NOT NULL THEN
7305: hr_utility.set_location(l_proc, 150);
7306: --
7307: per_chk_shd.lck
7308: (p_checklist_item_id => p_chk4_checklist_item_id
7309: ,p_object_version_number => p_chk4_object_version_number);

Line 7313: hr_utility.set_location(l_proc, 160);

7309: ,p_object_version_number => p_chk4_object_version_number);
7310: END IF;
7311: --
7312: IF p_chk5_checklist_item_id IS NOT NULL THEN
7313: hr_utility.set_location(l_proc, 160);
7314: --
7315: per_chk_shd.lck
7316: (p_checklist_item_id => p_chk5_checklist_item_id
7317: ,p_object_version_number => p_chk5_object_version_number);

Line 7321: hr_utility.set_location(l_proc, 170);

7317: ,p_object_version_number => p_chk5_object_version_number);
7318: END IF;
7319: --
7320: IF p_chk6_checklist_item_id IS NOT NULL THEN
7321: hr_utility.set_location(l_proc, 170);
7322: --
7323: per_chk_shd.lck
7324: (p_checklist_item_id => p_chk6_checklist_item_id
7325: ,p_object_version_number => p_chk6_object_version_number);

Line 7329: hr_utility.set_location(l_proc, 180);

7325: ,p_object_version_number => p_chk6_object_version_number);
7326: END IF;
7327: --
7328: IF p_chk7_checklist_item_id IS NOT NULL THEN
7329: hr_utility.set_location(l_proc, 180);
7330: --
7331: per_chk_shd.lck
7332: (p_checklist_item_id => p_chk7_checklist_item_id
7333: ,p_object_version_number => p_chk7_object_version_number);

Line 7337: hr_utility.set_location(l_proc, 190);

7333: ,p_object_version_number => p_chk7_object_version_number);
7334: END IF;
7335: --
7336: IF p_chk8_checklist_item_id IS NOT NULL THEN
7337: hr_utility.set_location(l_proc, 190);
7338: --
7339: per_chk_shd.lck
7340: (p_checklist_item_id => p_chk8_checklist_item_id
7341: ,p_object_version_number => p_chk8_object_version_number);

Line 7345: hr_utility.set_location(l_proc, 200);

7341: ,p_object_version_number => p_chk8_object_version_number);
7342: END IF;
7343: --
7344: IF p_chk9_checklist_item_id IS NOT NULL THEN
7345: hr_utility.set_location(l_proc, 200);
7346: --
7347: per_chk_shd.lck
7348: (p_checklist_item_id => p_chk9_checklist_item_id
7349: ,p_object_version_number => p_chk9_object_version_number);

Line 7353: hr_utility.set_location(l_proc, 210);

7349: ,p_object_version_number => p_chk9_object_version_number);
7350: END IF;
7351: --
7352: IF p_chk10_checklist_item_id IS NOT NULL THEN
7353: hr_utility.set_location(l_proc, 210);
7354: --
7355: per_chk_shd.lck
7356: (p_checklist_item_id => p_chk10_checklist_item_id
7357: ,p_object_version_number => p_chk10_object_version_number);

Line 7360: hr_utility.set_location('Leaving: '||l_proc, 220);

7356: (p_checklist_item_id => p_chk10_checklist_item_id
7357: ,p_object_version_number => p_chk10_object_version_number);
7358: END IF;
7359: --
7360: hr_utility.set_location('Leaving: '||l_proc, 220);
7361: --
7362: --Bugfix # 3888928 starts here
7363: EXCEPTION
7364: when app_exception.application_exception then