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 813: hr_utility.set_location('Entering:'|| l_proc, 10);

809: l_gsp_post_process_warning2 varchar2(30);
810: --
811: l_proc VARCHAR2(72) := g_package||'insert_maintain_data';
812: BEGIN
813: hr_utility.set_location('Entering:'|| l_proc, 10);
814: --
815: SAVEPOINT insert_maintain_data;
816: -- support "future hires", especially necessary for HR Foundation.
817: l_cagr_grade_def_id:=p_cagr_grade_def_id; -- Bug 3484602

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

825: l_creation_date := nvl(p_placement_date_start,p_effective_date);
826: END IF;
827: --
828: IF p_system_person_type='EMP' THEN
829: hr_utility.set_location(l_proc, 30);
830: l_employee_number:=p_employee_number;
831: hr_employee_api.create_employee
832: (p_hire_date => l_creation_date --p_effective_date
833: ,p_business_group_id => p_business_group_id

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

1256: -- p_name_combination_warning:=l_name_combination_warning; - checked already
1257: p_assign_payroll_warning:=l_assign_payroll_warning;
1258: -- p_orig_hire_warning:=l_orig_hire_warning; - insert of person, so not applicable
1259: --
1260: hr_utility.set_location(l_proc, 50);
1261: --
1262: --
1263: -- Bug 3891200 Starts Here
1264: -- Desc: Modified the if condition.to replace address_line1 with style and date_from

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

1266: IF p_style is not null and p_adr_date_from is not null then
1267: -- Bug 3891200 Ends Here
1268: --
1269: --
1270: hr_utility.set_location(l_proc, 190);
1271: --
1272: hr_person_address_api.cre_or_upd_person_address
1273: (p_effective_date => l_creation_date --p_effective_date
1274: ,p_person_id => l_person_id

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

1331: --
1332: p_address_id:=l_address_id;
1333: p_addr_object_version_number:=l_addr_object_version_number;
1334: --
1335: hr_utility.set_location(l_proc, 200);
1336: --
1337: END IF;
1338: --
1339: --

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

1340: -- employee assignments
1341: --
1342: IF p_assignment_type='E' THEN
1343: --
1344: hr_utility.set_location(l_proc, 110);
1345: --
1346: hr_assignment_api.update_emp_asg
1347: (p_effective_date => l_creation_date --p_effective_date
1348: ,p_datetrack_update_mode => 'CORRECTION'

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

1456: ,p_hourly_salaried_warning => l_hourly_salaried_warning
1457: ,p_gsp_post_process_warning => l_gsp_post_process_warning
1458: );
1459: --
1460: hr_utility.set_location(l_proc,120);
1461: --
1462: hr_assignment_api.update_emp_asg_criteria
1463: (p_effective_date => l_creation_date --p_effective_date
1464: ,p_datetrack_update_mode => 'CORRECTION'

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

1517: ,p_concatenated_segments => l_concatenated_segments
1518: ,p_gsp_post_process_warning => l_gsp_post_process_warning2
1519: );
1520: --
1521: hr_utility.set_location(l_proc, 130);
1522: --
1523: IF l_no_managers_warning THEN
1524: l_org_now_no_manager_warning:=TRUE;
1525: END IF;

Line 1534: hr_utility.raise_error;

1530: --
1531: IF l_spp_delete_warning THEN
1532: --
1533: fnd_message.set_name('PER', 'HR_289828_INV_SPP_CHANGE');
1534: hr_utility.raise_error;
1535: --
1536: END IF;
1537: --
1538: hr_utility.set_location(l_proc, 140);

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

1534: hr_utility.raise_error;
1535: --
1536: END IF;
1537: --
1538: hr_utility.set_location(l_proc, 140);
1539: --
1540: ELSIF p_assignment_type='A' then
1541: --
1542: hr_utility.set_location(l_proc, 150);

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

1538: hr_utility.set_location(l_proc, 140);
1539: --
1540: ELSIF p_assignment_type='A' then
1541: --
1542: hr_utility.set_location(l_proc, 150);
1543: --
1544: hr_assignment_api.update_apl_asg
1545: (p_effective_date => l_creation_date --p_effective_date
1546: ,p_datetrack_update_mode => 'CORRECTION'

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

1694: ,p_effective_start_date => l_asg_effective_start_date
1695: ,p_effective_end_date => l_asg_effective_end_date
1696: );
1697: --
1698: hr_utility.set_location(l_proc, 160);
1699: --
1700: ELSIF p_assignment_type='C' then --CWK assignment
1701: --
1702: hr_utility.set_location(l_proc, 162);

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

1698: hr_utility.set_location(l_proc, 160);
1699: --
1700: ELSIF p_assignment_type='C' then --CWK assignment
1701: --
1702: hr_utility.set_location(l_proc, 162);
1703: hr_utility.set_location(to_char(p_projected_assignment_end,'DD-MON-YYYY'), 162);
1704:
1705: hr_assignment_api.update_cwk_asg
1706: (p_effective_date => l_creation_date --p_effective_date

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

1699: --
1700: ELSIF p_assignment_type='C' then --CWK assignment
1701: --
1702: hr_utility.set_location(l_proc, 162);
1703: hr_utility.set_location(to_char(p_projected_assignment_end,'DD-MON-YYYY'), 162);
1704:
1705: hr_assignment_api.update_cwk_asg
1706: (p_effective_date => l_creation_date --p_effective_date
1707: ,p_datetrack_update_mode => 'CORRECTION'

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

1803: ,p_concatenated_segments => l_concatenated_segments
1804: ,p_hourly_salaried_warning => l_hourly_salaried_warning
1805: );
1806: --
1807: hr_utility.set_location(l_proc, 163);
1808: --
1809: hr_assignment_api.update_cwk_asg_criteria
1810: (p_effective_date => l_creation_date --p_effective_date
1811: ,p_datetrack_update_mode => 'CORRECTION'

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

1858: ,p_entries_changed_warning => l_entries_changed_warning
1859: ,p_tax_district_changed_warning => l_tax_district_changed_warning
1860: );
1861: --
1862: hr_utility.set_location(l_proc, 164);
1863: --
1864: IF p_rate_id is not null then --an assignment rate has been entered for the CWK
1865: hr_rate_values_api.create_assignment_rate_value
1866: (p_effective_date => l_creation_date --p_effective_date

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

1902: --
1903: -- bug2999562 support gsp post process
1904: --
1905: if l_gsp_post_process_warning is not null then
1906: hr_utility.set_location(l_proc, 165);
1907: p_gsp_post_process_warning := l_gsp_post_process_warning;
1908: elsif l_gsp_post_process_warning2 is not null then
1909: hr_utility.set_location(l_proc, 166);
1910: p_gsp_post_process_warning := l_gsp_post_process_warning2;

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

1905: if l_gsp_post_process_warning is not null then
1906: hr_utility.set_location(l_proc, 165);
1907: p_gsp_post_process_warning := l_gsp_post_process_warning;
1908: elsif l_gsp_post_process_warning2 is not null then
1909: hr_utility.set_location(l_proc, 166);
1910: p_gsp_post_process_warning := l_gsp_post_process_warning2;
1911: else
1912: p_gsp_post_process_warning := null;
1913: end if;

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

1911: else
1912: p_gsp_post_process_warning := null;
1913: end if;
1914:
1915: hr_utility.set_location(l_proc, 167);
1916: --
1917: IF l_application_id IS NOT NULL AND
1918: (p_projected_hire_date IS NOT NULL
1919: OR p_appl_attribute_category IS NOT NULL

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

1940: OR p_current_employer IS NOT NULL
1941: OR p_termination_reason IS NOT NULL) THEN
1942: --
1943: --
1944: hr_utility.set_location(l_proc, 170);
1945: --
1946: hr_application_api.update_apl_details
1947: (p_application_id => l_application_id
1948: ,p_object_version_number => l_app_object_version_number

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

1972: ,p_appl_attribute19 => p_appl_attribute19
1973: ,p_appl_attribute20 => p_appl_attribute20
1974: );
1975: --
1976: hr_utility.set_location(l_proc, 180);
1977: --
1978: p_app_object_version_number:=l_app_object_version_number;
1979: p_application_id:=l_application_id;
1980: END IF;

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

1978: p_app_object_version_number:=l_app_object_version_number;
1979: p_application_id:=l_application_id;
1980: END IF;
1981: --
1982: hr_utility.set_location(l_proc, 185);
1983: --
1984: -- home phone
1985: --
1986: IF p_phn_h_phone_number IS NOT NULL THEN

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

3506: -- end of bug 4553630
3507:
3508: l_proc VARCHAR2(72) := g_package||'update_maintain_data';
3509: BEGIN
3510: hr_utility.set_location('Entering:'|| l_proc, 10);
3511: --
3512: SAVEPOINT update_maintain_data;
3513: --
3514: -- start of bug 4553630

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

3516: open chk_primary ;
3517: fetch chk_primary into l_check_primary;
3518: if chk_primary%found then
3519: close chk_primary;
3520: hr_utility.set_message(800, 'HR_449032_PRIMARY_ADDR_EXISTS');
3521: hr_utility.raise_error;
3522: else
3523: close chk_primary;
3524: end if;

Line 3521: hr_utility.raise_error;

3517: fetch chk_primary into l_check_primary;
3518: if chk_primary%found then
3519: close chk_primary;
3520: hr_utility.set_message(800, 'HR_449032_PRIMARY_ADDR_EXISTS');
3521: hr_utility.raise_error;
3522: else
3523: close chk_primary;
3524: end if;
3525: end if;

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

3575: l_grade_rule_id := p_grade_rule_id;
3576: l_rate_object_version_number:= p_rate_object_version_number;
3577: end if;
3578: --
3579: hr_utility.set_location(l_proc, 20);
3580: --
3581: lock_maintain_data
3582: (p_effective_date => p_effective_date
3583: ,p_datetrack_update_mode => p_datetrack_update_mode

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

3642: ,p_chk10_checklist_item_id => p_chk10_checklist_item_id
3643: ,p_chk10_object_version_number => p_chk10_object_version_number
3644: );
3645: --
3646: hr_utility.set_location(l_proc, 30);
3647: --
3648: -- check to see if the person fields have been changed
3649: --
3650: IF p_person_update_allowed='TRUE' AND

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

3900: OR NVL(per_per_shd.g_old_rec.country_of_birth,hr_api.g_varchar2)
3901: <>NVL(p_country_of_birth,hr_api.g_varchar2)
3902: ) THEN
3903: --
3904: hr_utility.set_location(l_proc, 40);
3905: --
3906: select party_id
3907: into l_party_id
3908: from per_all_people_f

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

4067: );
4068: p_full_name:=l_full_name;
4069: end if;
4070: --
4071: hr_utility.set_location(l_proc, 50);
4072: --
4073: --
4074: --removed clause which updated projected_placement_end on placement table
4075: --now that column is superceded by projected_assignment)_end on assignment

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

4173: <> NVL(p_add_information20,hr_api.g_varchar2)
4174: ) ) THEN
4175: --
4176: --
4177: hr_utility.set_location(l_proc, 190);
4178: --
4179: hr_person_address_api.cre_or_upd_person_address
4180: (p_effective_date => p_effective_date
4181: ,p_person_id => p_person_id

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

4236: ,p_object_version_number => l_addr_object_version_number
4237: );
4238: --
4239: --
4240: hr_utility.set_location(l_proc, 200);
4241: --
4242: END IF;
4243: --
4244: p_addr_object_version_number:=l_addr_object_version_number;

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

4251: -- check to see if the assignment data has changed
4252: --
4253: IF per_asg_shd.g_old_rec.people_group_id IS NOT NULL THEN
4254: --
4255: hr_utility.set_location(l_proc, 60);
4256: --
4257: OPEN csr_pgp_rec(per_asg_shd.g_old_rec.people_group_id);
4258: FETCH csr_pgp_rec INTO l_pgp_rec;
4259: CLOSE csr_pgp_rec;

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

4260: END IF;
4261: --
4262: IF per_asg_shd.g_old_rec.soft_coding_keyflex_id IS NOT NULL THEN
4263: --
4264: hr_utility.set_location(l_proc, 70);
4265: --
4266: OPEN csr_scl_rec(per_asg_shd.g_old_rec.soft_coding_keyflex_id);
4267: FETCH csr_scl_rec INTO l_scl_rec;
4268: CLOSE csr_scl_rec;

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

4267: FETCH csr_scl_rec INTO l_scl_rec;
4268: CLOSE csr_scl_rec;
4269: END IF;
4270: --
4271: hr_utility.set_location(l_proc, 80);
4272: --
4273: IF NVL(per_asg_shd.g_old_rec.recruiter_id,hr_api.g_number)
4274: <>NVL(p_recruiter_id,hr_api.g_number)
4275: OR NVL(per_asg_shd.g_old_rec.grade_id,hr_api.g_number)

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

4577: <>NVL(p_projected_assignment_end,hr_api.g_date)
4578:
4579: THEN
4580: --
4581: hr_utility.set_location(l_proc, 100);
4582: --
4583: --
4584: -- employee assignments
4585: --

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

4584: -- employee assignments
4585: --
4586: IF p_assignment_type='E' THEN
4587: --
4588: hr_utility.set_location(l_proc, 110);
4589: --
4590: --
4591: -- Bug 3174130 Start here
4592: -- Description : Swapped the two assignment update procedures ' hr_assignment_api.update_emp_asg'

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

4682: ,p_gsp_post_process_warning => l_gsp_post_process_warning -- bug2999562
4683: );
4684:
4685: --
4686: hr_utility.set_location(l_proc, 120);
4687: --
4688: hr_dflex_utility.remove_ignore_df_validation;
4689: hr_kflex_utility.remove_ignore_kf_validation;
4690:

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

4803: ,p_gsp_post_process_warning => l_gsp_post_process_warning2 -- bug2999562
4804: );
4805:
4806: --
4807: hr_utility.set_location(l_proc, 130);
4808: --
4809: --
4810: -- Bug 3174130 End here
4811: --

Line 4824: hr_utility.raise_error;

4820: --
4821: IF l_spp_delete_warning THEN
4822: --
4823: fnd_message.set_name('PER', 'HR_289828_INV_SPP_CHANGE');
4824: hr_utility.raise_error;
4825: --
4826: END IF;
4827: --
4828: hr_utility.set_location(l_proc, 140);

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

4824: hr_utility.raise_error;
4825: --
4826: END IF;
4827: --
4828: hr_utility.set_location(l_proc, 140);
4829: --
4830: ELSIF p_assignment_type = 'A' then
4831: --
4832: hr_utility.set_location(l_proc, 150);

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

4828: hr_utility.set_location(l_proc, 140);
4829: --
4830: ELSIF p_assignment_type = 'A' then
4831: --
4832: hr_utility.set_location(l_proc, 150);
4833: --
4834: hr_assignment_api.update_apl_asg
4835: (p_effective_date => p_effective_date
4836: ,p_datetrack_update_mode => l_asg_datetrack_update_mode

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

4984: ,p_effective_start_date => l_asg_effective_start_date
4985: ,p_effective_end_date => l_asg_effective_end_date
4986: );
4987: --
4988: hr_utility.set_location(l_proc, 160);
4989: --
4990: ELSIF p_assignment_type = 'C' then
4991: hr_assignment_api.update_cwk_asg_criteria
4992: (p_effective_date => p_effective_date

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

5040: ,p_entries_changed_warning => l_entries_changed_warning
5041: ,p_tax_district_changed_warning => l_tax_district_changed_warning
5042: );
5043: --
5044: hr_utility.set_location(l_proc, 163);
5045: --
5046: hr_assignment_api.update_cwk_asg
5047: (p_effective_date => p_effective_date
5048: ,p_datetrack_update_mode => 'CORRECTION'

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

5149: END IF; --is assignment_update_allowed
5150: IF p_assignment_type='C' THEN
5151: IF p_grade_rule_id is null
5152: AND p_rate_id is not null then --an assignment rate has been entered for the CWK
5153: hr_utility.set_location(l_proc, 1010);
5154: hr_rate_values_api.create_assignment_rate_value
5155: (p_effective_date => p_effective_date
5156: ,p_business_group_id => p_business_group_id
5157: ,p_rate_id => p_rate_id

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

5174: <>nvl(p_rate_currency_code,hr_api.g_varchar2)
5175: OR nvl(pay_pgr_shd.g_old_rec.value,hr_api.g_varchar2)
5176: <>nvl(p_rate_value,hr_api.g_varchar2) )
5177: THEN
5178: hr_utility.set_location(l_proc, 1020);
5179: hr_rate_values_api.update_assignment_rate_value
5180: (p_effective_date => p_effective_date
5181: ,p_grade_rule_id => l_grade_rule_id
5182: ,p_datetrack_mode => l_rate_datetrack_update_mode

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

5191: p_rate_effective_end_date := l_rate_effective_end_date;
5192: ELSE
5193: --special case: multiple rates, the query code has explicitly set grade_rule_id
5194: --but set rate_id null and the fields are not updateable anyway
5195: hr_utility.set_location(l_proc, 1030);
5196: END IF;
5197: END IF;
5198: ELSE -- we are entering a secondary assignment.
5199: IF p_assignment_type='E' THEN

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

5687: --
5688: -- bug2999562 support gsp post process
5689: --
5690: if l_gsp_post_process_warning is not null then
5691: hr_utility.set_location(l_proc, 162);
5692: p_gsp_post_process_warning := l_gsp_post_process_warning;
5693: elsif l_gsp_post_process_warning2 is not null then
5694: hr_utility.set_location(l_proc, 163);
5695: p_gsp_post_process_warning := l_gsp_post_process_warning2;

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

5690: if l_gsp_post_process_warning is not null then
5691: hr_utility.set_location(l_proc, 162);
5692: p_gsp_post_process_warning := l_gsp_post_process_warning;
5693: elsif l_gsp_post_process_warning2 is not null then
5694: hr_utility.set_location(l_proc, 163);
5695: p_gsp_post_process_warning := l_gsp_post_process_warning2;
5696: elsif l_gsp_post_process_warning3 is not null then
5697: hr_utility.set_location(l_proc, 164);
5698: p_gsp_post_process_warning := l_gsp_post_process_warning3;

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

5693: elsif l_gsp_post_process_warning2 is not null then
5694: hr_utility.set_location(l_proc, 163);
5695: p_gsp_post_process_warning := l_gsp_post_process_warning2;
5696: elsif l_gsp_post_process_warning3 is not null then
5697: hr_utility.set_location(l_proc, 164);
5698: p_gsp_post_process_warning := l_gsp_post_process_warning3;
5699: else
5700: p_gsp_post_process_warning := null;
5701: end if;

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

5699: else
5700: p_gsp_post_process_warning := null;
5701: end if;
5702: --
5703: hr_utility.set_location(l_proc, 165);
5704: --
5705: IF p_application_id IS NOT NULL AND (
5706: NVL(per_apl_shd.g_old_rec.projected_hire_date,hr_api.g_date)
5707: <> NVL(p_projected_hire_date,hr_api.g_date)

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

5752: OR NVL(per_apl_shd.g_old_rec.termination_reason,hr_api.g_varchar2)
5753: <> NVL(p_termination_reason,hr_api.g_varchar2)) THEN
5754: --
5755: --
5756: hr_utility.set_location(l_proc, 170);
5757: --
5758: hr_application_api.update_apl_details
5759: (p_application_id => p_application_id
5760: ,p_object_version_number => l_app_object_version_number

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

5784: ,p_appl_attribute19 => p_appl_attribute19
5785: ,p_appl_attribute20 => p_appl_attribute20
5786: );
5787: --
5788: hr_utility.set_location(l_proc, 180);
5789: --
5790: END IF;
5791: --
5792: p_app_object_version_number:=l_app_object_version_number;

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

5790: END IF;
5791: --
5792: p_app_object_version_number:=l_app_object_version_number;
5793: --
5794: hr_utility.set_location(l_proc, 185);
5795: -- home phone
5796: --
5797: IF p_phn_h_phone_id IS NOT NULL THEN
5798: per_phn_shd.lck

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

7085: WHERE person_id = p_person_id
7086: AND date_start = p_pds_hire_date;
7087: --
7088: BEGIN
7089: hr_utility.set_location('Entering:'|| l_proc, 10);
7090: --
7091: IF p_person_update_allowed='TRUE' THEN
7092: IF p_per_effective_start_date=p_effective_date THEN
7093: l_per_datetrack_update_mode:='CORRECTION';

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

7102: ,p_object_version_number => p_per_object_version_number
7103: ,p_validation_start_date => p_per_validation_start_date
7104: ,p_validation_end_date => p_per_validation_end_date
7105: );
7106: hr_utility.set_location(l_proc, 15);
7107: IF p_pdp_object_version_number IS NOT NULL then
7108: open csr_pdp_rec(p_person_id,p_placement_date_start);
7109: fetch csr_pdp_rec into l_period_of_placement_id;
7110: close csr_pdp_rec;

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

7124: );
7125: END IF;
7126: --
7127: IF p_assignment_id IS NOT NULL AND p_assignment_update_allowed='TRUE' THEN
7128: hr_utility.set_location(l_proc, 20);
7129: --
7130: IF p_asg_effective_start_date=p_effective_date THEN
7131: l_asg_datetrack_update_mode:='CORRECTION';
7132: ELSE

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

7147: END IF;
7148: --
7149: IF p_grade_rule_id is not null
7150: AND p_rate_object_version_number is not null THEN
7151: hr_utility.set_location(l_proc, 25);
7152: IF p_rate_effective_start_date=p_effective_date THEN
7153: l_rate_datetrack_update_mode:='CORRECTION';
7154: ELSE
7155: l_rate_datetrack_update_mode:=p_datetrack_update_mode;

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

7165: );
7166: END IF;
7167: --
7168: IF p_application_id IS NOT NULL THEN
7169: hr_utility.set_location(l_proc, 30);
7170: --
7171: per_apl_shd.lck
7172: (p_application_id => p_application_id
7173: ,p_object_version_number => p_app_object_version_number);

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

7173: ,p_object_version_number => p_app_object_version_number);
7174: END IF;
7175: --
7176: IF p_address_id IS NOT NULL THEN
7177: hr_utility.set_location(l_proc, 40);
7178: --
7179: per_add_shd.lck
7180: (p_address_id => p_address_id
7181: ,p_object_version_number => p_addr_object_version_number);

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

7181: ,p_object_version_number => p_addr_object_version_number);
7182: END IF;
7183: --
7184: IF p_phn_h_phone_id IS NOT NULL THEN
7185: hr_utility.set_location(l_proc, 50);
7186: --
7187: per_phn_shd.lck
7188: (p_phone_id => p_phn_h_phone_id
7189: ,p_object_version_number => p_phn_h_object_version_number);

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

7189: ,p_object_version_number => p_phn_h_object_version_number);
7190: END IF;
7191: --
7192: IF p_phn_w_phone_id IS NOT NULL THEN
7193: hr_utility.set_location(l_proc, 60);
7194: --
7195: per_phn_shd.lck
7196: (p_phone_id => p_phn_w_phone_id
7197: ,p_object_version_number => p_phn_w_object_version_number);

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

7197: ,p_object_version_number => p_phn_w_object_version_number);
7198: END IF;
7199: --
7200: IF p_phn_m_phone_id IS NOT NULL THEN
7201: hr_utility.set_location(l_proc, 70);
7202: --
7203: per_phn_shd.lck
7204: (p_phone_id => p_phn_m_phone_id
7205: ,p_object_version_number => p_phn_m_object_version_number);

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

7205: ,p_object_version_number => p_phn_m_object_version_number);
7206: END IF;
7207: --
7208: IF p_phn_hf_phone_id IS NOT NULL THEN
7209: hr_utility.set_location(l_proc, 80);
7210: --
7211: per_phn_shd.lck
7212: (p_phone_id => p_phn_hf_phone_id
7213: ,p_object_version_number => p_phn_hf_object_version_number);

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

7213: ,p_object_version_number => p_phn_hf_object_version_number);
7214: END IF;
7215: --
7216: IF p_phn_wf_phone_id IS NOT NULL THEN
7217: hr_utility.set_location(l_proc, 90);
7218: --
7219: per_phn_shd.lck
7220: (p_phone_id => p_phn_wf_phone_id
7221: ,p_object_version_number => p_phn_wf_object_version_number);

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

7221: ,p_object_version_number => p_phn_wf_object_version_number);
7222: END IF;
7223: --
7224: IF p_pay_proposal_id IS NOT NULL THEN
7225: hr_utility.set_location(l_proc, 100);
7226: --
7227: per_pyp_shd.lck
7228: (p_pay_proposal_id => p_pay_proposal_id
7229: ,p_object_version_number => p_pyp_object_version_number);

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

7229: ,p_object_version_number => p_pyp_object_version_number);
7230: END IF;
7231: --
7232: IF p_deployment_factor_id IS NOT NULL THEN
7233: hr_utility.set_location(l_proc, 110);
7234: --
7235: per_dpf_shd.lck
7236: (p_deployment_factor_id => p_deployment_factor_id
7237: ,p_object_version_number => p_dpf_object_version_number);

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

7237: ,p_object_version_number => p_dpf_object_version_number);
7238: END IF;
7239: --
7240: IF p_chk1_checklist_item_id IS NOT NULL THEN
7241: hr_utility.set_location(l_proc, 120);
7242: --
7243: per_chk_shd.lck
7244: (p_checklist_item_id => p_chk1_checklist_item_id
7245: ,p_object_version_number => p_chk1_object_version_number);

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

7245: ,p_object_version_number => p_chk1_object_version_number);
7246: END IF;
7247: --
7248: IF p_chk2_checklist_item_id IS NOT NULL THEN
7249: hr_utility.set_location(l_proc, 130);
7250: --
7251: per_chk_shd.lck
7252: (p_checklist_item_id => p_chk2_checklist_item_id
7253: ,p_object_version_number => p_chk2_object_version_number);

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

7253: ,p_object_version_number => p_chk2_object_version_number);
7254: END IF;
7255: --
7256: IF p_chk3_checklist_item_id IS NOT NULL THEN
7257: hr_utility.set_location(l_proc, 140);
7258: --
7259: per_chk_shd.lck
7260: (p_checklist_item_id => p_chk3_checklist_item_id
7261: ,p_object_version_number => p_chk3_object_version_number);

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

7261: ,p_object_version_number => p_chk3_object_version_number);
7262: END IF;
7263: --
7264: IF p_chk4_checklist_item_id IS NOT NULL THEN
7265: hr_utility.set_location(l_proc, 150);
7266: --
7267: per_chk_shd.lck
7268: (p_checklist_item_id => p_chk4_checklist_item_id
7269: ,p_object_version_number => p_chk4_object_version_number);

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

7269: ,p_object_version_number => p_chk4_object_version_number);
7270: END IF;
7271: --
7272: IF p_chk5_checklist_item_id IS NOT NULL THEN
7273: hr_utility.set_location(l_proc, 160);
7274: --
7275: per_chk_shd.lck
7276: (p_checklist_item_id => p_chk5_checklist_item_id
7277: ,p_object_version_number => p_chk5_object_version_number);

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

7277: ,p_object_version_number => p_chk5_object_version_number);
7278: END IF;
7279: --
7280: IF p_chk6_checklist_item_id IS NOT NULL THEN
7281: hr_utility.set_location(l_proc, 170);
7282: --
7283: per_chk_shd.lck
7284: (p_checklist_item_id => p_chk6_checklist_item_id
7285: ,p_object_version_number => p_chk6_object_version_number);

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

7285: ,p_object_version_number => p_chk6_object_version_number);
7286: END IF;
7287: --
7288: IF p_chk7_checklist_item_id IS NOT NULL THEN
7289: hr_utility.set_location(l_proc, 180);
7290: --
7291: per_chk_shd.lck
7292: (p_checklist_item_id => p_chk7_checklist_item_id
7293: ,p_object_version_number => p_chk7_object_version_number);

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

7293: ,p_object_version_number => p_chk7_object_version_number);
7294: END IF;
7295: --
7296: IF p_chk8_checklist_item_id IS NOT NULL THEN
7297: hr_utility.set_location(l_proc, 190);
7298: --
7299: per_chk_shd.lck
7300: (p_checklist_item_id => p_chk8_checklist_item_id
7301: ,p_object_version_number => p_chk8_object_version_number);

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

7301: ,p_object_version_number => p_chk8_object_version_number);
7302: END IF;
7303: --
7304: IF p_chk9_checklist_item_id IS NOT NULL THEN
7305: hr_utility.set_location(l_proc, 200);
7306: --
7307: per_chk_shd.lck
7308: (p_checklist_item_id => p_chk9_checklist_item_id
7309: ,p_object_version_number => p_chk9_object_version_number);

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

7309: ,p_object_version_number => p_chk9_object_version_number);
7310: END IF;
7311: --
7312: IF p_chk10_checklist_item_id IS NOT NULL THEN
7313: hr_utility.set_location(l_proc, 210);
7314: --
7315: per_chk_shd.lck
7316: (p_checklist_item_id => p_chk10_checklist_item_id
7317: ,p_object_version_number => p_chk10_object_version_number);

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

7316: (p_checklist_item_id => p_chk10_checklist_item_id
7317: ,p_object_version_number => p_chk10_object_version_number);
7318: END IF;
7319: --
7320: hr_utility.set_location('Leaving: '||l_proc, 220);
7321: --
7322: --Bugfix # 3888928 starts here
7323: EXCEPTION
7324: when app_exception.application_exception then