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.HR_APPLICANT_API dependencies on HR_UTILITY

Line 7: g_debug constant boolean := hr_utility.debug_enabled;

3: --
4: -- Package Variables
5: --
6: g_package constant varchar2(33) := 'hr_applicant_api.';
7: g_debug constant boolean := hr_utility.debug_enabled;
8: --
9: -- Package cursor
10: --
11: CURSOR csr_future_asgs

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

63: l_future_asgs_count INTEGER := 0;
64: --
65: BEGIN
66: --
67: hr_utility.set_location('Entering:'||l_proc,10);
68: --
69: FOR l_future_asgs_rec IN
70: csr_future_asgs
71: (p_person_id => p_person_id

Line 78: hr_utility.set_location(' Leaving:'||l_proc,100);

74: LOOP
75: l_future_asgs_count := l_future_asgs_count + 1;
76: END LOOP;
77: --
78: hr_utility.set_location(' Leaving:'||l_proc,100);
79: --
80: RETURN(l_future_asgs_count);
81: --
82: EXCEPTION

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

267: --
268: lv_applicant_number varchar2(2000) := p_applicant_number ;
269: --
270: begin
271: hr_utility.set_location('Entering:'|| l_proc, 5);
272: --
273: -- Issue a savepoint.
274: --
275: savepoint create_applicant;

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

292: 'APL');
293: l_applicant_number := p_applicant_number;
294: l_npw_number := null;
295: --
296: hr_utility.set_location(l_proc, 10);
297: --
298: -- Perform Business Process additional validation, if required derive
299: -- the person_type_id value.
300: --

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

566: ,p_name_combination_warning => l_name_combination_warning
567: ,p_dob_null_warning => l_dob_null_warning
568: ,p_orig_hire_warning => l_orig_hire_warning
569: );
570: hr_utility.set_location(l_proc, 20);
571: --
572: -- add the new applicant to the security lists
573: --
574: hr_security_internal.populate_new_person(p_business_group_id,l_person_id);

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

572: -- add the new applicant to the security lists
573: --
574: hr_security_internal.populate_new_person(p_business_group_id,l_person_id);
575: --
576: hr_utility.set_location(l_proc, 25);
577: --
578: -- Insert the application using the application RH...
579: --
580: per_apl_ins.ins(p_application_id => l_application_id

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

584: ,p_object_version_number => p_apl_object_version_number
585: ,p_effective_date => l_date_received
586: ,p_validate => FALSE
587: );
588: hr_utility.set_location(l_proc, 30);
589: --
590: -- Insert the default applicant assignment using the business support layer
591: -- process create_default_apl_asg.
592: --

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

610: ,p_assignment_id => l_assignment_id
611: ,p_object_version_number => l_asg_object_version_number
612: ,p_assignment_sequence => l_assignment_sequence
613: );
614: hr_utility.set_location(l_proc, 40);
615: --
616: -- Create a phone row using the newly created person as the parent row.
617: -- This phone row replaces the work_telephone column on the person.
618: --

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

809: p_orig_hire_warning := l_orig_hire_warning;
810: -- Added for Bug 1275358
811: p_applicant_number := l_applicant_number;
812:
813: hr_utility.set_location(' Leaving:'||l_proc, 50);
814: exception
815: when hr_api.validate_enabled then
816: --
817: -- As the Validate_Enabled exception has been raised

Line 842: hr_utility.set_location(' Leaving:'||l_proc, 35);

838: p_name_combination_warning := l_name_combination_warning;
839: p_orig_hire_warning := l_orig_hire_warning;
840:
841: --
842: hr_utility.set_location(' Leaving:'||l_proc, 35);
843: when others then
844: --
845: -- A validation or unexpected error has occurred
846: --

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

991: from per_business_groups pbg
992: where pbg.business_group_id = p_business_group_id;
993: --
994: begin
995: hr_utility.set_location('Entering:'|| l_proc, 5);
996: --
997: -- Validation in addition to Table Handlers
998: --
999: -- Check that the specified business group is valid.

Line 1006: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');

1002: fetch csr_bg
1003: into l_legislation_code;
1004: if csr_bg%notfound then
1005: close csr_bg;
1006: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
1007: hr_utility.raise_error;
1008: end if;
1009: close csr_bg;
1010: --

Line 1007: hr_utility.raise_error;

1003: into l_legislation_code;
1004: if csr_bg%notfound then
1005: close csr_bg;
1006: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
1007: hr_utility.raise_error;
1008: end if;
1009: close csr_bg;
1010: --
1011: -- Check that the legislation of the specified business group is 'GB'.

Line 1014: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');

1010: --
1011: -- Check that the legislation of the specified business group is 'GB'.
1012: --
1013: if l_legislation_code <> 'GB' then
1014: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
1015: hr_utility.set_message_token('LEG_CODE','GB');
1016: hr_utility.raise_error;
1017: end if;
1018:

Line 1015: hr_utility.set_message_token('LEG_CODE','GB');

1011: -- Check that the legislation of the specified business group is 'GB'.
1012: --
1013: if l_legislation_code <> 'GB' then
1014: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
1015: hr_utility.set_message_token('LEG_CODE','GB');
1016: hr_utility.raise_error;
1017: end if;
1018:
1019: hr_utility.set_location(l_proc, 6);

Line 1016: hr_utility.raise_error;

1012: --
1013: if l_legislation_code <> 'GB' then
1014: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
1015: hr_utility.set_message_token('LEG_CODE','GB');
1016: hr_utility.raise_error;
1017: end if;
1018:
1019: hr_utility.set_location(l_proc, 6);
1020: --

Line 1019: hr_utility.set_location(l_proc, 6);

1015: hr_utility.set_message_token('LEG_CODE','GB');
1016: hr_utility.raise_error;
1017: end if;
1018:
1019: hr_utility.set_location(l_proc, 6);
1020: --
1021: -- Call the person business process
1022: --
1023: hr_applicant_api.create_applicant

Line 1132: hr_utility.set_location(' Leaving:'||l_proc, 7);

1128: ,p_name_combination_warning => p_name_combination_warning
1129: ,p_orig_hire_warning => p_orig_hire_warning
1130: );
1131: --
1132: hr_utility.set_location(' Leaving:'||l_proc, 7);
1133: end create_gb_applicant;
1134: --
1135: -- ----------------------------------------------------------------------------
1136: -- |-------------------------< create_us_applicant >--------------------------|

Line 1262: /* hr_utility.set_location('Entering:'|| l_proc, 5);

1258: where pbg.business_group_id = p_business_group_id;
1259: */
1260: --
1261: begin
1262: /* hr_utility.set_location('Entering:'|| l_proc, 5);
1263: --
1264: -- Validation in addition to Table Handlers
1265: --
1266: -- Check that the specified business group is valid.

Line 1273: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');

1269: fetch csr_bg
1270: into l_legislation_code;
1271: if csr_bg%notfound then
1272: close csr_bg;
1273: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
1274: hr_utility.raise_error;
1275: end if;
1276: close csr_bg;
1277: --

Line 1274: hr_utility.raise_error;

1270: into l_legislation_code;
1271: if csr_bg%notfound then
1272: close csr_bg;
1273: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
1274: hr_utility.raise_error;
1275: end if;
1276: close csr_bg;
1277: --
1278: -- Check that the legislation of the specified business group is 'US'.

Line 1281: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');

1277: --
1278: -- Check that the legislation of the specified business group is 'US'.
1279: --
1280: if l_legislation_code <> 'US' then
1281: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
1282: hr_utility.set_message_token('LEG_CODE','US');
1283: hr_utility.raise_error;
1284: end if;
1285:

Line 1282: hr_utility.set_message_token('LEG_CODE','US');

1278: -- Check that the legislation of the specified business group is 'US'.
1279: --
1280: if l_legislation_code <> 'US' then
1281: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
1282: hr_utility.set_message_token('LEG_CODE','US');
1283: hr_utility.raise_error;
1284: end if;
1285:
1286: hr_utility.set_location(l_proc, 6);

Line 1283: hr_utility.raise_error;

1279: --
1280: if l_legislation_code <> 'US' then
1281: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
1282: hr_utility.set_message_token('LEG_CODE','US');
1283: hr_utility.raise_error;
1284: end if;
1285:
1286: hr_utility.set_location(l_proc, 6);
1287: */

Line 1286: hr_utility.set_location(l_proc, 6);

1282: hr_utility.set_message_token('LEG_CODE','US');
1283: hr_utility.raise_error;
1284: end if;
1285:
1286: hr_utility.set_location(l_proc, 6);
1287: */
1288: --
1289: -- Call the person business process
1290: --

Line 1402: -- hr_utility.set_location(' Leaving:'||l_proc, 7);

1398: ,p_name_combination_warning => p_name_combination_warning
1399: ,p_orig_hire_warning => p_orig_hire_warning
1400: );
1401: --
1402: -- hr_utility.set_location(' Leaving:'||l_proc, 7);
1403: end create_us_applicant;
1404: --
1405:
1406: -- Overloaded the function Create_US_employee for bug 8277596

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

1525: from per_business_groups pbg
1526: where pbg.business_group_id = p_business_group_id;
1527: --
1528: begin
1529: hr_utility.set_location('Entering:'|| l_proc, 5);
1530: --
1531: -- Validation in addition to Table Handlers
1532: --
1533: -- Check that the specified business group is valid.

Line 1540: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');

1536: fetch csr_bg
1537: into l_legislation_code;
1538: if csr_bg%notfound then
1539: close csr_bg;
1540: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
1541: hr_utility.raise_error;
1542: end if;
1543: close csr_bg;
1544: --

Line 1541: hr_utility.raise_error;

1537: into l_legislation_code;
1538: if csr_bg%notfound then
1539: close csr_bg;
1540: hr_utility.set_message(801, 'HR_7208_API_BUS_GRP_INVALID');
1541: hr_utility.raise_error;
1542: end if;
1543: close csr_bg;
1544: --
1545: -- Check that the legislation of the specified business group is 'US'.

Line 1548: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');

1544: --
1545: -- Check that the legislation of the specified business group is 'US'.
1546: --
1547: if l_legislation_code <> 'US' then
1548: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
1549: hr_utility.set_message_token('LEG_CODE','US');
1550: hr_utility.raise_error;
1551: end if;
1552:

Line 1549: hr_utility.set_message_token('LEG_CODE','US');

1545: -- Check that the legislation of the specified business group is 'US'.
1546: --
1547: if l_legislation_code <> 'US' then
1548: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
1549: hr_utility.set_message_token('LEG_CODE','US');
1550: hr_utility.raise_error;
1551: end if;
1552:
1553: hr_utility.set_location(l_proc, 6);

Line 1550: hr_utility.raise_error;

1546: --
1547: if l_legislation_code <> 'US' then
1548: hr_utility.set_message(801, 'HR_7961_PER_BUS_GRP_INVALID');
1549: hr_utility.set_message_token('LEG_CODE','US');
1550: hr_utility.raise_error;
1551: end if;
1552:
1553: hr_utility.set_location(l_proc, 6);
1554: --

Line 1553: hr_utility.set_location(l_proc, 6);

1549: hr_utility.set_message_token('LEG_CODE','US');
1550: hr_utility.raise_error;
1551: end if;
1552:
1553: hr_utility.set_location(l_proc, 6);
1554: --
1555: -- Call the person business process
1556: --
1557: hr_applicant_api.create_applicant

Line 1668: hr_utility.set_location(' Leaving:'||l_proc, 7);

1664: ,p_name_combination_warning => p_name_combination_warning
1665: ,p_orig_hire_warning => p_orig_hire_warning
1666: );
1667: --
1668: hr_utility.set_location(' Leaving:'||l_proc, 7);
1669: end create_us_applicant;
1670:
1671: -- ---------------------------------------------------------------------------
1672: -- |-----------------------------< hire_applicant >---------------------------|

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

1705: -- l_original_date_of_hire date;
1706: --
1707: begin
1708: --
1709: hr_utility.set_location('Entering:'|| l_proc, 10);
1710: --
1711: l_per_object_version_number:=p_per_object_version_number;
1712: l_employee_number:=p_employee_number;
1713: --

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

1735: p_per_effective_end_date := l_per_effective_end_date;
1736: p_unaccepted_asg_del_warning := l_unaccepted_asg_del_warning;
1737: p_assign_payroll_warning := l_assign_payroll_warning;
1738: --
1739: hr_utility.set_location('Leaving:'|| l_proc, 20);
1740: --
1741: end hire_applicant;
1742: --
1743:

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

1768: is
1769: l_proc varchar2(72) := g_package||'hire_applicant';
1770: begin
1771: --
1772: hr_utility.set_location('Entering:'|| l_proc, 10);
1773: --
1774: hr_applicant_api.hire_applicant
1775: (p_validate => p_validate
1776: ,p_hire_date => p_hire_date

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

1789: ,p_source => p_source
1790: ,p_upload_irec_docs => 'N'
1791: );
1792: --
1793: hr_utility.set_location('Leaving:'|| l_proc, 20);
1794: --
1795: end hire_applicant;
1796: -- End changes for bug 9879782
1797: --

Line 2315: hr_utility.set_location(l_proc, 32);

2311: ---- Fix For ER: 6136609 Starts ----
2312:
2313: l_autoApprove:=fnd_profile.value('HR_AUTO_APPROVE_FIRST_PROPOSAL');
2314: if(l_autoApprove is null or l_autoApprove ='Y') then
2315: hr_utility.set_location(l_proc, 32);
2316: l_approved_flag:='Y';
2317: end if;
2318:
2319: ---- Fix For ER: 6136609 Ends ----

Line 2383: hr_utility.set_location('l_date_probation_end :'||l_date_probation_end,10);

2379: ,p_probation_unit => l_probation_unit
2380: ,p_start_date => p_hire_date
2381: ,p_date_probation_end => l_date_probation_end
2382: );
2383: hr_utility.set_location('l_date_probation_end :'||l_date_probation_end,10);
2384: return l_date_probation_end;
2385: end if;
2386: -- end if;
2387: return x_date_probation_end;

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

2390:
2391:
2392:
2393: begin
2394: hr_utility.set_location('Entering:'|| l_proc, 10);
2395:
2396: -- Start chagnes for bug 9879782
2397: if p_upload_irec_docs = 'Y' and p_validate = false then
2398:

Line 2399: hr_utility.set_location(' p_assignment_id :'|| p_assignment_id, 10);

2395:
2396: -- Start chagnes for bug 9879782
2397: if p_upload_irec_docs = 'Y' and p_validate = false then
2398:
2399: hr_utility.set_location(' p_assignment_id :'|| p_assignment_id, 10);
2400:
2401: open csr_get_appl_id(p_assignment_id);
2402: fetch csr_get_appl_id into l_appl_id;
2403: close csr_get_appl_id;

Line 2405: hr_utility.set_location(' l_application_id :'|| l_application_id, 10);

2401: open csr_get_appl_id(p_assignment_id);
2402: fetch csr_get_appl_id into l_appl_id;
2403: close csr_get_appl_id;
2404:
2405: hr_utility.set_location(' l_application_id :'|| l_application_id, 10);
2406:
2407: per_fnd_attachment_pkg.upload_irec_docs(
2408: p_person_id => p_PERSON_ID,
2409: p_assignment_id => p_assignment_id,

Line 2439: hr_utility.set_location(l_proc,11);

2435: fetch csr_pps_ended_ystrdy into l_pps;
2436: --
2437: if csr_pps_ended_ystrdy%found then
2438: --
2439: hr_utility.set_location(l_proc,11);
2440: l_datetrack_mode:='CORRECTION';
2441: --bug no 12320120
2442: else
2443: open csr_ppp_ended_ystrdy;

Line 2446: hr_utility.set_location(l_proc,12);

2442: else
2443: open csr_ppp_ended_ystrdy;
2444: fetch csr_ppp_ended_ystrdy into l_ppp;
2445: if csr_ppp_ended_ystrdy%found then
2446: hr_utility.set_location(l_proc,12);
2447: l_datetrack_mode:='CORRECTION';
2448: l_emp_ptu_code := 'Y'; --bug no 12693283
2449: end if;
2450: close csr_ppp_ended_ystrdy;

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

2453: close csr_pps_ended_ystrdy;
2454: --bug no 5105005
2455: savepoint hire_applicant;
2456: --
2457: hr_utility.set_location(l_proc, 80);
2458:
2459: -- Bug 8831084 Fix Starts
2460:
2461: if p_assignment_id is null then

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

2484: -- #2978566
2485: --
2486: -- Get the derived details for the person DT instance
2487: --
2488: hr_utility.set_location(l_proc,40);
2489:
2490: open csr_get_devived_details;
2491: fetch csr_get_devived_details
2492: into l_system_person_type,

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

2499: l_original_date_of_hire;
2500: if csr_get_devived_details%NOTFOUND
2501: then
2502: --
2503: hr_utility.set_location(l_proc,50);
2504: --
2505: close csr_get_devived_details;
2506: --
2507: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');

Line 2507: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');

2503: hr_utility.set_location(l_proc,50);
2504: --
2505: close csr_get_devived_details;
2506: --
2507: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
2508: hr_utility.raise_error;
2509: --
2510: end if;
2511: close csr_get_devived_details;

Line 2508: hr_utility.raise_error;

2504: --
2505: close csr_get_devived_details;
2506: --
2507: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
2508: hr_utility.raise_error;
2509: --
2510: end if;
2511: close csr_get_devived_details;
2512: --

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

2554: fetch csr_future_asg_changes into l_exists;
2555: --
2556: if csr_future_asg_changes%FOUND then
2557: --
2558: hr_utility.set_location(l_proc,40);
2559: if (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') then
2560: -- Checking for future 'E' asg changes when the profile option is set
2561: open fpt_future_asg_changes;
2562: fetch fpt_future_asg_changes into l_exists;

Line 2564: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');

2560: -- Checking for future 'E' asg changes when the profile option is set
2561: open fpt_future_asg_changes;
2562: fetch fpt_future_asg_changes into l_exists;
2563: if fpt_future_asg_changes%found then
2564: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
2565: hr_utility.raise_error;
2566: end if;
2567: close fpt_future_asg_changes;
2568: else

Line 2565: hr_utility.raise_error;

2561: open fpt_future_asg_changes;
2562: fetch fpt_future_asg_changes into l_exists;
2563: if fpt_future_asg_changes%found then
2564: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
2565: hr_utility.raise_error;
2566: end if;
2567: close fpt_future_asg_changes;
2568: else
2569: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');

Line 2569: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');

2565: hr_utility.raise_error;
2566: end if;
2567: close fpt_future_asg_changes;
2568: else
2569: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
2570: hr_utility.raise_error;
2571: end if;
2572: end if;
2573: close csr_future_asg_changes;

Line 2570: hr_utility.raise_error;

2566: end if;
2567: close fpt_future_asg_changes;
2568: else
2569: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
2570: hr_utility.raise_error;
2571: end if;
2572: end if;
2573: close csr_future_asg_changes;
2574: --

Line 2576: hr_utility.set_location(l_proc,270);

2572: end if;
2573: close csr_future_asg_changes;
2574: --
2575: --
2576: hr_utility.set_location(l_proc,270);
2577: --
2578: -- Validation in addition to Row Handlers
2579: --
2580: -- If the specified person type id is not null then check that it

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

2587: ,p_business_group_id => l_business_group_id
2588: ,p_expected_sys_type => 'EMP'
2589: );
2590: --
2591: hr_utility.set_location(l_proc,60);
2592: --
2593: -- Check that corresponding person is of 'APL', 'APL_EX_APL' or 'EX_EMP_APL'
2594: -- system person type.
2595: --

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

2597: l_system_person_type <> 'APL_EX_APL' and
2598: l_system_person_type <> 'EX_EMP_APL'
2599: then
2600: --
2601: hr_utility.set_location(l_proc,70);
2602: --
2603: hr_utility.set_message(800,'PER_52096_APL_INV_PERSON_TYPE');
2604: hr_utility.raise_error;
2605: end if;

Line 2603: hr_utility.set_message(800,'PER_52096_APL_INV_PERSON_TYPE');

2599: then
2600: --
2601: hr_utility.set_location(l_proc,70);
2602: --
2603: hr_utility.set_message(800,'PER_52096_APL_INV_PERSON_TYPE');
2604: hr_utility.raise_error;
2605: end if;
2606: --
2607: hr_utility.set_location(l_proc,80);

Line 2604: hr_utility.raise_error;

2600: --
2601: hr_utility.set_location(l_proc,70);
2602: --
2603: hr_utility.set_message(800,'PER_52096_APL_INV_PERSON_TYPE');
2604: hr_utility.raise_error;
2605: end if;
2606: --
2607: hr_utility.set_location(l_proc,80);
2608: --

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

2603: hr_utility.set_message(800,'PER_52096_APL_INV_PERSON_TYPE');
2604: hr_utility.raise_error;
2605: end if;
2606: --
2607: hr_utility.set_location(l_proc,80);
2608: --
2609: -- Bug# 2273304 Start Here
2610: --
2611: open csr_date_of_birth;

Line 2623: hr_utility.set_message(801, 'HR_7426_EMP_AGE_ILLEGAL');

2619: close csr_bg_age_range;
2620:
2621: if l_age not between nvl(l_minimum_age,l_age) and
2622: nvl(l_maximum_age,l_age) then
2623: hr_utility.set_message(801, 'HR_7426_EMP_AGE_ILLEGAL');
2624: hr_utility.set_message_token('MIN',to_char(l_minimum_age));
2625: hr_utility.set_message_token('MAX',to_char(l_maximum_age));
2626: hr_utility.raise_error;
2627: end if;

Line 2624: hr_utility.set_message_token('MIN',to_char(l_minimum_age));

2620:
2621: if l_age not between nvl(l_minimum_age,l_age) and
2622: nvl(l_maximum_age,l_age) then
2623: hr_utility.set_message(801, 'HR_7426_EMP_AGE_ILLEGAL');
2624: hr_utility.set_message_token('MIN',to_char(l_minimum_age));
2625: hr_utility.set_message_token('MAX',to_char(l_maximum_age));
2626: hr_utility.raise_error;
2627: end if;
2628: hr_utility.set_location('age:'||l_age||'min:'||l_minimum_age||'max:'||l_maximum_age,91);

Line 2625: hr_utility.set_message_token('MAX',to_char(l_maximum_age));

2621: if l_age not between nvl(l_minimum_age,l_age) and
2622: nvl(l_maximum_age,l_age) then
2623: hr_utility.set_message(801, 'HR_7426_EMP_AGE_ILLEGAL');
2624: hr_utility.set_message_token('MIN',to_char(l_minimum_age));
2625: hr_utility.set_message_token('MAX',to_char(l_maximum_age));
2626: hr_utility.raise_error;
2627: end if;
2628: hr_utility.set_location('age:'||l_age||'min:'||l_minimum_age||'max:'||l_maximum_age,91);
2629:

Line 2626: hr_utility.raise_error;

2622: nvl(l_maximum_age,l_age) then
2623: hr_utility.set_message(801, 'HR_7426_EMP_AGE_ILLEGAL');
2624: hr_utility.set_message_token('MIN',to_char(l_minimum_age));
2625: hr_utility.set_message_token('MAX',to_char(l_maximum_age));
2626: hr_utility.raise_error;
2627: end if;
2628: hr_utility.set_location('age:'||l_age||'min:'||l_minimum_age||'max:'||l_maximum_age,91);
2629:
2630: --

Line 2628: hr_utility.set_location('age:'||l_age||'min:'||l_minimum_age||'max:'||l_maximum_age,91);

2624: hr_utility.set_message_token('MIN',to_char(l_minimum_age));
2625: hr_utility.set_message_token('MAX',to_char(l_maximum_age));
2626: hr_utility.raise_error;
2627: end if;
2628: hr_utility.set_location('age:'||l_age||'min:'||l_minimum_age||'max:'||l_maximum_age,91);
2629:
2630: --
2631: -- Bug# 2273304 End Here
2632: --

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

2637: open csr_chk_asg_status;
2638: fetch csr_chk_asg_status into l_count;
2639: if l_count = 0 then
2640: --
2641: hr_utility.set_location(l_proc,90);
2642: --
2643: close csr_chk_asg_status;
2644: --
2645: hr_utility.set_message(800,'PER_52098_APL_INV_ASG_STATUS');

Line 2645: hr_utility.set_message(800,'PER_52098_APL_INV_ASG_STATUS');

2641: hr_utility.set_location(l_proc,90);
2642: --
2643: close csr_chk_asg_status;
2644: --
2645: hr_utility.set_message(800,'PER_52098_APL_INV_ASG_STATUS');
2646: hr_utility.raise_error;
2647: --
2648: end if;
2649: --

Line 2646: hr_utility.raise_error;

2642: --
2643: close csr_chk_asg_status;
2644: --
2645: hr_utility.set_message(800,'PER_52098_APL_INV_ASG_STATUS');
2646: hr_utility.raise_error;
2647: --
2648: end if;
2649: --
2650: -- If the accepted assignment record is multiple, ASSIGNMENT_ID

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

2651: -- must be not null.
2652: --
2653: if l_count > 1 then
2654: --
2655: hr_utility.set_location(l_proc,100);
2656: --
2657: --close csr_chk_asg_status;
2658: --
2659: hr_api.mandatory_arg_error

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

2661: ,p_argument => 'assignment_id'
2662: ,p_argument_value => p_assignment_id
2663: );
2664: --
2665: hr_utility.set_location(l_proc,110);
2666: --
2667: l_multi_flag := TRUE;
2668: --
2669: end if;

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

2669: end if;
2670: --
2671: close csr_chk_asg_status;
2672: --
2673: hr_utility.set_location(l_proc,120);
2674: --
2675: -- Check p_assignment is corresponding data.
2676: -- The assignment record specified by P_ASSIGNMENT_ID on the hire
2677: -- date in the PER_ASSIGNMENTS_F table has assignment status

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

2678: -- 'ACCEPTED'.
2679: --
2680: if p_assignment_id is not null then
2681: --
2682: hr_utility.set_location(l_proc,130);
2683: --
2684: open csr_chk_assignment_id;
2685: fetch csr_chk_assignment_id
2686: into l_chk_person_id,

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

2686: into l_chk_person_id,
2687: l_chk_system_status;
2688: if csr_chk_assignment_id%NOTFOUND then
2689: --
2690: hr_utility.set_location(l_proc,140);
2691: --
2692: close csr_chk_assignment_id;
2693: --
2694: hr_utility.set_message(800,'PER_52099_ASG_INV_ASG_ID');

Line 2694: hr_utility.set_message(800,'PER_52099_ASG_INV_ASG_ID');

2690: hr_utility.set_location(l_proc,140);
2691: --
2692: close csr_chk_assignment_id;
2693: --
2694: hr_utility.set_message(800,'PER_52099_ASG_INV_ASG_ID');
2695: hr_utility.raise_error;
2696: --
2697: end if;
2698: --

Line 2695: hr_utility.raise_error;

2691: --
2692: close csr_chk_assignment_id;
2693: --
2694: hr_utility.set_message(800,'PER_52099_ASG_INV_ASG_ID');
2695: hr_utility.raise_error;
2696: --
2697: end if;
2698: --
2699: if l_chk_person_id <> p_person_id then

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

2697: end if;
2698: --
2699: if l_chk_person_id <> p_person_id then
2700: --
2701: hr_utility.set_location(l_proc,150);
2702: --
2703: close csr_chk_assignment_id;
2704: --
2705: hr_utility.set_message(800,'PER_52101_ASG_INV_PER_ID_COMB');

Line 2705: hr_utility.set_message(800,'PER_52101_ASG_INV_PER_ID_COMB');

2701: hr_utility.set_location(l_proc,150);
2702: --
2703: close csr_chk_assignment_id;
2704: --
2705: hr_utility.set_message(800,'PER_52101_ASG_INV_PER_ID_COMB');
2706: hr_utility.raise_error;
2707: --
2708: end if;
2709: --

Line 2706: hr_utility.raise_error;

2702: --
2703: close csr_chk_assignment_id;
2704: --
2705: hr_utility.set_message(800,'PER_52101_ASG_INV_PER_ID_COMB');
2706: hr_utility.raise_error;
2707: --
2708: end if;
2709: --
2710: if l_chk_system_status <> 'ACCEPTED' then

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

2708: end if;
2709: --
2710: if l_chk_system_status <> 'ACCEPTED' then
2711: --
2712: hr_utility.set_location(l_proc,150);
2713: --
2714: close csr_chk_assignment_id;
2715: --
2716: hr_utility.set_message(800,'PER_52100_ASG_INV_PER_TYPE');

Line 2716: hr_utility.set_message(800,'PER_52100_ASG_INV_PER_TYPE');

2712: hr_utility.set_location(l_proc,150);
2713: --
2714: close csr_chk_assignment_id;
2715: --
2716: hr_utility.set_message(800,'PER_52100_ASG_INV_PER_TYPE');
2717: hr_utility.raise_error;
2718: --
2719: end if;
2720: --

Line 2717: hr_utility.raise_error;

2713: --
2714: close csr_chk_assignment_id;
2715: --
2716: hr_utility.set_message(800,'PER_52100_ASG_INV_PER_TYPE');
2717: hr_utility.raise_error;
2718: --
2719: end if;
2720: --
2721: hr_utility.set_location(l_proc,160);

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

2717: hr_utility.raise_error;
2718: --
2719: end if;
2720: --
2721: hr_utility.set_location(l_proc,160);
2722: --
2723: close csr_chk_assignment_id;
2724: --
2725: end if;

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

2732: fetch csr_pps_not_ended into l_pps;
2733: --
2734: if csr_pps_not_ended%found then
2735: --
2736: hr_utility.set_location(l_proc,165);
2737: close csr_pps_not_ended;
2738: --
2739: -- Fix 5196352 - Now we allow rehire before FPD
2740: -- hence do not throw error PER_289308_FUTURE_ENDED_FPD

Line 2744: hr_utility.set_message('800','HR_449756_FPD_PREV_PDS');

2740: -- hence do not throw error PER_289308_FUTURE_ENDED_FPD
2741: -- Here we just check FPD should never be null.
2742:
2743: if l_pps is null then
2744: hr_utility.set_message('800','HR_449756_FPD_PREV_PDS');
2745: hr_utility.raise_error;
2746: end if;
2747: end if;
2748: --

Line 2745: hr_utility.raise_error;

2741: -- Here we just check FPD should never be null.
2742:
2743: if l_pps is null then
2744: hr_utility.set_message('800','HR_449756_FPD_PREV_PDS');
2745: hr_utility.raise_error;
2746: end if;
2747: end if;
2748: --
2749: -- Fix for bug 2881076 end.

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

2746: end if;
2747: end if;
2748: --
2749: -- Fix for bug 2881076 end.
2750: hr_utility.set_location(l_proc,170);
2751: -- bug 14523339
2752: open chk_hire_date;
2753: fetch chk_hire_date into l_dummy_char;
2754: if chk_hire_date%found then

Line 2759: hr_utility.set_location(l_proc,175);

2755: l_datetrack_mode:='CORRECTION';
2756: end if;
2757: close chk_hire_date;
2758: -- bug 14523339
2759: hr_utility.set_location(l_proc,175);
2760: --
2761: -- Lock the person record in PER_ALL_PEOPLE_F ready for UPDATE at a later point.
2762: -- (Note: This is necessary because calling the table handlers in locking
2763: -- ladder order invokes an error in per_apl_upd.upd due to the person

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

2772: ,p_validation_start_date => l_validation_start_date
2773: ,p_validation_end_date => l_validation_end_date
2774: );
2775: --
2776: hr_utility.set_location(l_proc,180);
2777: --
2778: --start changes for i-rec enhancement ww bug # 2675202
2779: --
2780: if (p_migrate) then

Line 2790: hr_utility.set_location(l_proc,181);

2786: ,p_object_version_number => l_add_ovn
2787: ,p_effective_date => l_hire_date);
2788: end loop;
2789: --
2790: hr_utility.set_location(l_proc,181);
2791: --
2792: for phn_rec in csr_phn(per_per_shd.g_old_rec.party_id) loop
2793: l_phn_ovn:=phn_rec.object_version_number;
2794: l_parent_table := 'PER_ALL_PEOPLE_F';

Line 2802: hr_utility.set_location(l_proc,182);

2798: ,p_object_version_number => l_phn_ovn
2799: ,p_effective_date => l_hire_date);
2800: end loop;
2801: --
2802: hr_utility.set_location(l_proc,182);
2803: --
2804: for pem_rec in csr_pem(per_per_shd.g_old_rec.party_id) loop
2805: l_pem_ovn:=pem_rec.object_version_number;
2806: per_pem_upd.upd(p_previous_employer_id => pem_rec.previous_employer_id

Line 2813: hr_utility.set_location(l_proc,183);

2809: ,p_object_version_number => l_pem_ovn
2810: ,p_effective_date => l_hire_date);
2811: end loop;
2812: --
2813: hr_utility.set_location(l_proc,183);
2814: --
2815: for qua_rec in csr_qua(per_per_shd.g_old_rec.party_id) loop
2816: l_qua_ovn:=qua_rec.object_version_number;
2817: per_qua_upd.upd(p_qualification_id => qua_rec.qualification_id

Line 2824: hr_utility.set_location(l_proc,184);

2820: ,p_object_version_number => l_qua_ovn
2821: ,p_effective_date => l_hire_date);
2822: end loop;
2823: --
2824: hr_utility.set_location(l_proc,184);
2825: --
2826: for esa_rec in csr_esa(per_per_shd.g_old_rec.party_id) loop
2827: l_esa_ovn:=esa_rec.object_version_number;
2828: per_esa_upd.upd(p_attendance_id => esa_rec.attendance_id

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

2831: ,p_object_version_number => l_esa_ovn
2832: ,p_effective_date => l_hire_date);
2833: end loop;
2834: --
2835: hr_utility.set_location(l_proc,185);
2836: --
2837: end if;
2838: --
2839: --End changes for i-rec enhancement ww bug # 2675202

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

2848: ,p_object_version_number => l_apl_object_version_number
2849: ,p_effective_date => l_hire_date
2850: ,p_validate => false
2851: );
2852: hr_utility.set_location(l_proc,190);
2853:
2854: -- ER FPT
2855: -- loop through the future asg records
2856: for apl in csr_fut_asg_rec

Line 2858: hr_utility.set_location('Processing Assignment ID = '||apl.assignment_id,195);

2854: -- ER FPT
2855: -- loop through the future asg records
2856: for apl in csr_fut_asg_rec
2857: loop
2858: hr_utility.set_location('Processing Assignment ID = '||apl.assignment_id,195);
2859:
2860: l_fpt_hire_flag :='Y';
2861:
2862: -- retrieve the max end date of the ASG to update the APLN date_end

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

2936: fetch csr_get_un_accepted
2937: into l_assignment_id,
2938: l_asg_object_version_number;
2939: exit when csr_get_un_accepted%NOTFOUND;
2940: hr_utility.set_location(l_proc,210);
2941: -- ER FPT
2942: -- Future asg changes for unaccepted applications as of hire date are not allowed
2943: open chk_future_changes(l_assignment_id);
2944: fetch chk_future_changes into l_exists;

Line 2947: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');

2943: open chk_future_changes(l_assignment_id);
2944: fetch chk_future_changes into l_exists;
2945: if chk_future_changes%found then
2946: close chk_future_changes;
2947: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
2948: hr_utility.raise_error;
2949: end if;
2950: close chk_future_changes;
2951: --

Line 2948: hr_utility.raise_error;

2944: fetch chk_future_changes into l_exists;
2945: if chk_future_changes%found then
2946: close chk_future_changes;
2947: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
2948: hr_utility.raise_error;
2949: end if;
2950: close chk_future_changes;
2951: --
2952: -- ER FPT

Line 2954: hr_utility.set_location(l_proc,240);

2950: close chk_future_changes;
2951: --
2952: -- ER FPT
2953: --
2954: hr_utility.set_location(l_proc,240);
2955: --
2956: per_asg_del.del
2957: (p_assignment_id => l_assignment_id
2958: ,p_effective_start_date => l_effective_start_date

Line 3003: hr_utility.set_location('l_assignment_id :'||l_assignment_id,10);

2999: from PER_VAC_LINKED_ASSIGNMENTS
3000: where tgt_apl_asg_id = l_assignment_id
3001: and sysdate between nvl(start_date,sysdate) and nvl(end_date,sysdate) ;
3002:
3003: hr_utility.set_location('l_assignment_id :'||l_assignment_id,10);
3004: hr_utility.set_location('l_irc_link_exists :'||l_irc_link_exists,10);
3005:
3006: if l_irc_link_exists <> -1 then
3007:

Line 3004: hr_utility.set_location('l_irc_link_exists :'||l_irc_link_exists,10);

3000: where tgt_apl_asg_id = l_assignment_id
3001: and sysdate between nvl(start_date,sysdate) and nvl(end_date,sysdate) ;
3002:
3003: hr_utility.set_location('l_assignment_id :'||l_assignment_id,10);
3004: hr_utility.set_location('l_irc_link_exists :'||l_irc_link_exists,10);
3005:
3006: if l_irc_link_exists <> -1 then
3007:
3008: select assignment_status_type_id into l_irc_spl_status

Line 3013: hr_utility.set_location('l_irc_spl_status :'||l_irc_spl_status,10);

3009: from per_assignment_status_types
3010: where PER_SYSTEM_STATUS= 'ACTIVE_ASG_IN_OTH_BG'
3011: and ACTIVE_FLAG ='Y' and DEFAULT_FLAG='Y';
3012:
3013: hr_utility.set_location('l_irc_spl_status :'||l_irc_spl_status,10);
3014:
3015: IRC_ASG_STATUS_API.create_irc_asg_status
3016: (p_assignment_id => l_assignment_id
3017: , p_assignment_status_type_id => l_irc_spl_status

Line 3053: hr_utility.set_location(l_proc,250);

3049: ----------------------
3050: -- IRC FIX 11853433
3051: ----------------------
3052:
3053: hr_utility.set_location(l_proc,250);
3054: --
3055: -- Added the below api call for bug 7540870.
3056: IRC_OFFERS_API.close_offer
3057: ( p_validate => false

Line 3073: hr_utility.set_location(l_proc, 260);

3069: end loop;
3070: --
3071: close csr_get_un_accepted;
3072: --
3073: hr_utility.set_location(l_proc, 260);
3074:
3075: -- bug3572499
3076: open csr_get_legislation_code;
3077: fetch csr_get_legislation_code into l_legislation_code;

Line 3092: hr_utility.set_location(l_proc, 270);

3088: ,'EMP');
3089:
3090:
3091: if (l_legislation_code <> 'US') then
3092: hr_utility.set_location(l_proc, 270);
3093: per_per_upd.upd(p_person_id => p_person_id
3094: ,p_effective_date => l_hire_date
3095: ,p_applicant_number => l_applicant_number
3096: ,p_person_type_id => l_person_type_id1

Line 3116: hr_utility.set_location(l_proc, 272);

3112: ,p_npw_number => l_npw_number
3113: ,p_original_date_of_hire => l_original_date_of_hire
3114: );
3115: else
3116: hr_utility.set_location(l_proc, 272);
3117: -- start of bug3572499
3118: --
3119: -- US legislation specific
3120: --

Line 3137: hr_utility.set_location(l_proc,274);

3133:
3134: --Fix For Bug 5749371 Ends
3135:
3136: if (l_new_hire_code is NULL) then
3137: hr_utility.set_location(l_proc,274);
3138: l_new_hire_code := 'INCL';
3139: end if;
3140: per_per_upd.upd(p_person_id => p_person_id
3141: ,p_effective_date => l_hire_date

Line 3165: hr_utility.set_location(l_proc,284);

3161: );
3162: end if;
3163: -- end of bug3572499
3164: --
3165: hr_utility.set_location(l_proc,284);
3166: --
3167: -- PTU : Following Code has been added
3168:
3169: --bug no 12693283

Line 3184: hr_utility.set_location(l_proc,286);

3180: ,p_datetrack_update_mode=> l_datetrack_mode
3181: --bug no 5105005
3182: );
3183: --
3184: hr_utility.set_location(l_proc,286);
3185: --
3186: l_person_type_id1 :=
3187: hr_person_type_usage_info.get_default_person_type_id
3188: (l_business_group_id

Line 3191: hr_utility.set_location(l_proc,288);

3187: hr_person_type_usage_info.get_default_person_type_id
3188: (l_business_group_id
3189: ,'EX_APL');
3190:
3191: hr_utility.set_location(l_proc,288);
3192: --
3193: hr_per_type_usage_internal.maintain_person_type_usage
3194: (p_effective_date => l_hire_date
3195: ,p_person_id => p_person_id

Line 3199: hr_utility.set_location(l_proc,290);

3195: ,p_person_id => p_person_id
3196: ,p_person_type_id => l_person_type_id1
3197: );
3198:
3199: hr_utility.set_location(l_proc,290);
3200:
3201: -- ER FPT
3202:
3203: if l_fpt_hire_flag ='Y' then

Line 3204: hr_utility.set_location(l_proc,295);

3200:
3201: -- ER FPT
3202:
3203: if l_fpt_hire_flag ='Y' then
3204: hr_utility.set_location(l_proc,295);
3205: -- loop through the future APLN records
3206: open csr_get_apln_details;
3207: loop
3208: fetch csr_get_apln_details into l_apln_date_start,l_apln_date_to;

Line 3331: hr_utility.set_location(l_proc,310);

3327: ,p_object_version_number => l_pds_object_version_number
3328: ,p_validate_df_flex => false
3329: );
3330: --
3331: hr_utility.set_location(l_proc,310);
3332: -- -----------------------------------------------------------------------+
3333: -- Processing ACCEPTED APL ASG +
3334: -- -----------------------------------------------------------------------+
3335: --

Line 3355: hr_utility.set_location(l_proc,320);

3351: ,p_legislation_code => l_legislation_code
3352: ,p_expected_system_status => 'ACTIVE_ASSIGN'
3353: );
3354: --
3355: hr_utility.set_location(l_proc,320);
3356: l_oversubscribed_vacancy_id:=null;
3357: --
3358: --
3359: -- start of bug 4681211

Line 3366: hr_utility.set_location(l_proc,321);

3362: if p_assignment_id is not null then
3363: -- first process the primary assignment id
3364: -- so that it can generate the assignment Number correctly.
3365: -- bug 4681211 added
3366: hr_utility.set_location(l_proc,321);
3367: open csr_get_accepted_pmry;
3368: fetch csr_get_accepted_pmry
3369: into l_assignment_id,
3370: l_asg_object_version_number,

Line 3379: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');

3375: open chk_future_changes(l_assignment_id);
3376: fetch chk_future_changes into l_exists;
3377: if chk_future_changes%found then
3378: close chk_future_changes;
3379: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
3380: hr_utility.raise_error;
3381: end if;
3382: close chk_future_changes;
3383: hr_utility.set_location(l_proc,340);

Line 3380: hr_utility.raise_error;

3376: fetch chk_future_changes into l_exists;
3377: if chk_future_changes%found then
3378: close chk_future_changes;
3379: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
3380: hr_utility.raise_error;
3381: end if;
3382: close chk_future_changes;
3383: hr_utility.set_location(l_proc,340);
3384: --

Line 3383: hr_utility.set_location(l_proc,340);

3379: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
3380: hr_utility.raise_error;
3381: end if;
3382: close chk_future_changes;
3383: hr_utility.set_location(l_proc,340);
3384: --
3385: l_primary_flag := 'Y';
3386: --
3387: if l_multi_flag = TRUE then

Line 3391: hr_utility.set_location(l_proc,360);

3387: if l_multi_flag = TRUE then
3388: --
3389: if l_assignment_id <> p_assignment_id then
3390: --
3391: hr_utility.set_location(l_proc,360);
3392: --
3393: l_primary_flag := 'N';
3394: --
3395: end if;

Line 3397: hr_utility.set_location(l_proc,370);

3393: l_primary_flag := 'N';
3394: --
3395: end if;
3396: --
3397: hr_utility.set_location(l_proc,370);
3398: --
3399: end if;
3400: --
3401: hr_utility.set_location(l_proc,380);

Line 3401: hr_utility.set_location(l_proc,380);

3397: hr_utility.set_location(l_proc,370);
3398: --
3399: end if;
3400: --
3401: hr_utility.set_location(l_proc,380);
3402: --
3403:
3404: --Fix For Bug 5749371 Starts
3405:

Line 3449: hr_utility.set_location(l_proc,385);

3445: --
3446: --
3447: -- 115.71 (START)
3448: --
3449: hr_utility.set_location(l_proc,385);
3450: --
3451: -- Handle potentially overlapping PDS due to rehire before FPD
3452: --
3453: hr_employee_api.manage_rehire_primary_asgs

Line 3472: hr_utility.set_location(' l_assignment_id :'||l_assignment_id,10);

3468: from PER_VAC_LINKED_ASSIGNMENTS
3469: where tgt_apl_asg_id = l_assignment_id
3470: and sysdate between nvl(start_date,sysdate) and nvl(end_date,sysdate);
3471:
3472: hr_utility.set_location(' l_assignment_id :'||l_assignment_id,10);
3473: hr_utility.set_location('l_irc_link_exists :'||l_irc_link_exists,10);
3474:
3475:
3476: if l_irc_link_exists <> -1 then

Line 3473: hr_utility.set_location('l_irc_link_exists :'||l_irc_link_exists,10);

3469: where tgt_apl_asg_id = l_assignment_id
3470: and sysdate between nvl(start_date,sysdate) and nvl(end_date,sysdate);
3471:
3472: hr_utility.set_location(' l_assignment_id :'||l_assignment_id,10);
3473: hr_utility.set_location('l_irc_link_exists :'||l_irc_link_exists,10);
3474:
3475:
3476: if l_irc_link_exists <> -1 then
3477:

Line 3483: hr_utility.set_location('l_irc_spl_status :'||l_irc_spl_status,10);

3479: from per_assignment_status_types
3480: where PER_SYSTEM_STATUS= 'ACTIVE_ASG_IN_OTH_BG'
3481: and ACTIVE_FLAG ='Y' and DEFAULT_FLAG='Y';
3482:
3483: hr_utility.set_location('l_irc_spl_status :'||l_irc_spl_status,10);
3484:
3485: IRC_ASG_STATUS_API.create_irc_asg_status
3486: (p_assignment_id => l_assignment_id
3487: , p_assignment_status_type_id => l_irc_spl_status

Line 3543: hr_utility.set_location(l_proc,390);

3539: l_oversubscribed_vacancy_id:=l_vacancy_id;
3540: else
3541: close csr_vacs;
3542: end if;
3543: hr_utility.set_location(l_proc,390);
3544: --bug 14457125 move maintain_entries_asg before salary maintenance
3545: -- alus need to be created for hired assignments before salary entry
3546: --Bug 8831084 Fix Starts
3547:

Line 3581: hr_utility.set_location(l_proc,395);

3577: if p_source = false then
3578: update_salary_proposal(l_assignment_id, l_hire_date);
3579: end if;--fix for bug 5354681
3580: --
3581: hr_utility.set_location(l_proc,395);
3582: --
3583: hr_utility.set_location(l_proc,410);
3584: --
3585: close csr_get_accepted_pmry;

Line 3583: hr_utility.set_location(l_proc,410);

3579: end if;--fix for bug 5354681
3580: --
3581: hr_utility.set_location(l_proc,395);
3582: --
3583: hr_utility.set_location(l_proc,410);
3584: --
3585: close csr_get_accepted_pmry;
3586: else
3587: close csr_get_accepted_pmry;

Line 3590: hr_utility.set_location(l_proc,322);

3586: else
3587: close csr_get_accepted_pmry;
3588: end if;
3589:
3590: hr_utility.set_location(l_proc,322);
3591: open csr_get_accepted_non;
3592: loop
3593: fetch csr_get_accepted_non
3594: into l_assignment_id,

Line 3604: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');

3600: open chk_future_changes(l_assignment_id);
3601: fetch chk_future_changes into l_exists;
3602: if chk_future_changes%found then
3603: close chk_future_changes;
3604: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
3605: hr_utility.raise_error;
3606: end if;
3607: close chk_future_changes;
3608:

Line 3605: hr_utility.raise_error;

3601: fetch chk_future_changes into l_exists;
3602: if chk_future_changes%found then
3603: close chk_future_changes;
3604: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
3605: hr_utility.raise_error;
3606: end if;
3607: close chk_future_changes;
3608:
3609: hr_utility.set_location(l_proc,340);

Line 3609: hr_utility.set_location(l_proc,340);

3605: hr_utility.raise_error;
3606: end if;
3607: close chk_future_changes;
3608:
3609: hr_utility.set_location(l_proc,340);
3610: --
3611: l_primary_flag := 'Y';
3612: --
3613: if l_multi_flag = TRUE then

Line 3617: hr_utility.set_location(l_proc,360);

3613: if l_multi_flag = TRUE then
3614: --
3615: if l_assignment_id <> p_assignment_id then
3616: --
3617: hr_utility.set_location(l_proc,360);
3618: --
3619: l_primary_flag := 'N';
3620: --
3621: end if;

Line 3623: hr_utility.set_location(l_proc,370);

3619: l_primary_flag := 'N';
3620: --
3621: end if;
3622: --
3623: hr_utility.set_location(l_proc,370);
3624: --
3625: end if;
3626: --
3627: hr_utility.set_location(l_proc,380);

Line 3627: hr_utility.set_location(l_proc,380);

3623: hr_utility.set_location(l_proc,370);
3624: --
3625: end if;
3626: --
3627: hr_utility.set_location(l_proc,380);
3628: --
3629:
3630: --Fix For Bug 5749371 Starts
3631:

Line 3675: hr_utility.set_location(l_proc,385);

3671: --
3672: --
3673: -- 115.71 (START)
3674: --
3675: hr_utility.set_location(l_proc,385);
3676: --
3677: -- Handle potentially overlapping PDS due to rehire before FPD
3678: --
3679: hr_employee_api.manage_rehire_primary_asgs

Line 3699: hr_utility.set_location(' l_assignment_id :'||l_assignment_id,10);

3695: from PER_VAC_LINKED_ASSIGNMENTS
3696: where tgt_apl_asg_id = l_assignment_id
3697: and sysdate between nvl(start_date,sysdate) and nvl(end_date,sysdate);
3698:
3699: hr_utility.set_location(' l_assignment_id :'||l_assignment_id,10);
3700: hr_utility.set_location('l_irc_link_exists :'||l_irc_link_exists,10);
3701:
3702:
3703: if l_irc_link_exists <> -1 then

Line 3700: hr_utility.set_location('l_irc_link_exists :'||l_irc_link_exists,10);

3696: where tgt_apl_asg_id = l_assignment_id
3697: and sysdate between nvl(start_date,sysdate) and nvl(end_date,sysdate);
3698:
3699: hr_utility.set_location(' l_assignment_id :'||l_assignment_id,10);
3700: hr_utility.set_location('l_irc_link_exists :'||l_irc_link_exists,10);
3701:
3702:
3703: if l_irc_link_exists <> -1 then
3704:

Line 3710: hr_utility.set_location('l_irc_spl_status :'||l_irc_spl_status,10);

3706: from per_assignment_status_types
3707: where PER_SYSTEM_STATUS= 'ACTIVE_ASG_IN_OTH_BG'
3708: and ACTIVE_FLAG ='Y' and DEFAULT_FLAG='Y';
3709:
3710: hr_utility.set_location('l_irc_spl_status :'||l_irc_spl_status,10);
3711:
3712: IRC_ASG_STATUS_API.create_irc_asg_status
3713: (p_assignment_id => l_assignment_id
3714: , p_assignment_status_type_id => l_irc_spl_status

Line 3767: hr_utility.set_location(l_proc,390);

3763: l_oversubscribed_vacancy_id:=l_vacancy_id;
3764: else
3765: close csr_vacs;
3766: end if;
3767: hr_utility.set_location(l_proc,390);
3768: --
3769: -- 2833630: Any salary proposals attached to the APL assignment should have
3770: -- the salary change date updated to be >= the hire date.
3771: --

Line 3776: hr_utility.set_location(l_proc,395);

3772: if p_source = false then
3773: update_salary_proposal(l_assignment_id, l_hire_date);
3774: end if;--fix for bug 5354681
3775: --
3776: hr_utility.set_location(l_proc,395);
3777: end loop;
3778: --
3779: hr_utility.set_location(l_proc,410);
3780: --

Line 3779: hr_utility.set_location(l_proc,410);

3775: --
3776: hr_utility.set_location(l_proc,395);
3777: end loop;
3778: --
3779: hr_utility.set_location(l_proc,410);
3780: --
3781: close csr_get_accepted_non;
3782:
3783: else

Line 3786: hr_utility.set_location(l_proc,323);

3782:
3783: else
3784: -- case when p_assignment_id is null
3785: -- this works as how it was previoulsy
3786: hr_utility.set_location(l_proc,323);
3787: hr_utility.set_location('inside the else part',910);
3788: open csr_get_accepted;
3789: loop
3790: fetch csr_get_accepted

Line 3787: hr_utility.set_location('inside the else part',910);

3783: else
3784: -- case when p_assignment_id is null
3785: -- this works as how it was previoulsy
3786: hr_utility.set_location(l_proc,323);
3787: hr_utility.set_location('inside the else part',910);
3788: open csr_get_accepted;
3789: loop
3790: fetch csr_get_accepted
3791: into l_assignment_id,

Line 3801: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');

3797: open chk_future_changes(l_assignment_id);
3798: fetch chk_future_changes into l_exists;
3799: if chk_future_changes%found then
3800: close chk_future_changes;
3801: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
3802: hr_utility.raise_error;
3803: end if;
3804: close chk_future_changes;
3805:

Line 3802: hr_utility.raise_error;

3798: fetch chk_future_changes into l_exists;
3799: if chk_future_changes%found then
3800: close chk_future_changes;
3801: hr_utility.set_message(801,'HR_7975_ASG_INV_FUTURE_ASA');
3802: hr_utility.raise_error;
3803: end if;
3804: close chk_future_changes;
3805:
3806: hr_utility.set_location(l_proc,340);

Line 3806: hr_utility.set_location(l_proc,340);

3802: hr_utility.raise_error;
3803: end if;
3804: close chk_future_changes;
3805:
3806: hr_utility.set_location(l_proc,340);
3807: --
3808: l_primary_flag := 'Y';
3809: --
3810: if l_multi_flag = TRUE then

Line 3814: hr_utility.set_location(l_proc,360);

3810: if l_multi_flag = TRUE then
3811: --
3812: if l_assignment_id <> p_assignment_id then
3813: --
3814: hr_utility.set_location(l_proc,360);
3815: --
3816: l_primary_flag := 'N';
3817: --
3818: end if;

Line 3820: hr_utility.set_location(l_proc,370);

3816: l_primary_flag := 'N';
3817: --
3818: end if;
3819: --
3820: hr_utility.set_location(l_proc,370);
3821: --
3822: end if;
3823: --
3824: hr_utility.set_location(l_proc,380);

Line 3824: hr_utility.set_location(l_proc,380);

3820: hr_utility.set_location(l_proc,370);
3821: --
3822: end if;
3823: --
3824: hr_utility.set_location(l_proc,380);
3825: --
3826: per_asg_upd.upd
3827: (p_assignment_id => l_assignment_id,
3828: p_object_version_number => l_asg_object_version_number,

Line 3856: hr_utility.set_location(l_proc,385);

3852: --
3853: --
3854: -- 115.71 (START)
3855: --
3856: hr_utility.set_location(l_proc,385);
3857: --
3858: -- Handle potentially overlapping PDS due to rehire before FPD
3859: --
3860: hr_employee_api.manage_rehire_primary_asgs

Line 3880: hr_utility.set_location(' l_assignment_id :'||l_assignment_id,10);

3876: from PER_VAC_LINKED_ASSIGNMENTS
3877: where tgt_apl_asg_id = l_assignment_id
3878: and sysdate between nvl(start_date,sysdate) and nvl(end_date,sysdate);
3879:
3880: hr_utility.set_location(' l_assignment_id :'||l_assignment_id,10);
3881: hr_utility.set_location('l_irc_link_exists :'||l_irc_link_exists,10);
3882:
3883:
3884: if l_irc_link_exists <> -1 then

Line 3881: hr_utility.set_location('l_irc_link_exists :'||l_irc_link_exists,10);

3877: where tgt_apl_asg_id = l_assignment_id
3878: and sysdate between nvl(start_date,sysdate) and nvl(end_date,sysdate);
3879:
3880: hr_utility.set_location(' l_assignment_id :'||l_assignment_id,10);
3881: hr_utility.set_location('l_irc_link_exists :'||l_irc_link_exists,10);
3882:
3883:
3884: if l_irc_link_exists <> -1 then
3885:

Line 3891: hr_utility.set_location('l_irc_spl_status :'||l_irc_spl_status,10);

3887: from per_assignment_status_types
3888: where PER_SYSTEM_STATUS= 'ACTIVE_ASG_IN_OTH_BG'
3889: and ACTIVE_FLAG ='Y' and DEFAULT_FLAG='Y';
3890:
3891: hr_utility.set_location('l_irc_spl_status :'||l_irc_spl_status,10);
3892:
3893: IRC_ASG_STATUS_API.create_irc_asg_status
3894: (p_assignment_id => l_assignment_id
3895: , p_assignment_status_type_id => l_irc_spl_status

Line 3938: hr_utility.set_location(l_proc,386);

3934: ,p_applicant_assignment_id => l_assignment_id
3935: ,p_change_reason => 'APL_HIRED'
3936: );
3937:
3938: hr_utility.set_location(l_proc,386);
3939:
3940: if per_otherbg_apl_api.isMultiRegVac(l_assignment_id) then
3941: per_otherbg_apl_api.close_otherbg_applications(l_assignment_id,l_hire_date-1,'HIRE_CLOSE');
3942: end if;

Line 3952: hr_utility.set_location(l_proc,390);

3948: l_oversubscribed_vacancy_id:=l_vacancy_id;
3949: else
3950: close csr_vacs;
3951: end if;
3952: hr_utility.set_location(l_proc,390);
3953: --
3954: -- 2833630: Any salary proposals attached to the APL assignment should have
3955: -- the salary change date updated to be >= the hire date.
3956: --

Line 3961: hr_utility.set_location(l_proc,395);

3957: if p_source = false then
3958: update_salary_proposal(l_assignment_id, l_hire_date);
3959: end if;--fix for bug 5354681
3960: --
3961: hr_utility.set_location(l_proc,395);
3962: end loop;
3963: --
3964: hr_utility.set_location(l_proc,410);
3965: --

Line 3964: hr_utility.set_location(l_proc,410);

3960: --
3961: hr_utility.set_location(l_proc,395);
3962: end loop;
3963: --
3964: hr_utility.set_location(l_proc,410);
3965: --
3966: close csr_get_accepted;
3967:
3968: end if;

Line 4053: hr_utility.set_location(' Leaving:'||l_proc, 250);

4049: p_unaccepted_asg_del_warning := l_unaccepted_asg_del_warning;
4050: p_assign_payroll_warning := l_assign_payroll_warning;
4051: p_oversubscribed_vacancy_id := l_oversubscribed_vacancy_id;
4052: --
4053: hr_utility.set_location(' Leaving:'||l_proc, 250);
4054: --
4055: exception
4056: when hr_api.validate_enabled then
4057: --

Line 4076: hr_utility.set_location(' Leaving:'||l_proc, 250);

4072: p_unaccepted_asg_del_warning := l_unaccepted_asg_del_warning;
4073: p_assign_payroll_warning := l_assign_payroll_warning;
4074: p_oversubscribed_vacancy_id := l_oversubscribed_vacancy_id;
4075: --
4076: hr_utility.set_location(' Leaving:'||l_proc, 250);
4077: --
4078: when others then
4079: --
4080: -- A validation or unexpected error has occurred

Line 4096: hr_utility.set_location(' Leaving:'||l_proc, 255);

4092:
4093: ROLLBACK TO hire_applicant;
4094:
4095: --
4096: hr_utility.set_location(' Leaving:'||l_proc, 255);
4097: raise;
4098: -- End of fix.
4099: --
4100: end hire_applicant;

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

4345: -- <<
4346: --
4347: BEGIN
4348: --
4349: hr_utility.set_location('Entering:'||l_proc,10);
4350: --
4351: -- Ensure mandatory arguments have been passed
4352: --
4353: hr_api.mandatory_arg_error

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

4369: -- Issue savepoint
4370: --
4371: SAVEPOINT terminate_applicant;
4372: --
4373: hr_utility.set_location(l_proc,20);
4374: --
4375: -- Call Before Process User Hook
4376: --
4377: BEGIN

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

4390: ,p_hook_type => 'B'
4391: );
4392: END;
4393: --
4394: hr_utility.set_location(l_proc,30);
4395: --
4396: -- Derive application details
4397: --
4398: OPEN csr_applications

Line 4406: hr_utility.set_message(801,'HR_51011_PER_NOT_EXIST_DATE');

4402: FETCH csr_applications INTO l_application;
4403: IF (csr_applications%NOTFOUND)
4404: THEN
4405: CLOSE csr_applications;
4406: hr_utility.set_message(801,'HR_51011_PER_NOT_EXIST_DATE');
4407: hr_utility.raise_error;
4408: END IF;
4409: CLOSE csr_applications;
4410: --

Line 4407: hr_utility.raise_error;

4403: IF (csr_applications%NOTFOUND)
4404: THEN
4405: CLOSE csr_applications;
4406: hr_utility.set_message(801,'HR_51011_PER_NOT_EXIST_DATE');
4407: hr_utility.raise_error;
4408: END IF;
4409: CLOSE csr_applications;
4410: --
4411: hr_utility.set_location(l_proc,40);

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

4407: hr_utility.raise_error;
4408: END IF;
4409: CLOSE csr_applications;
4410: --
4411: hr_utility.set_location(l_proc,40);
4412: --
4413: -- If person_type_id is not null check it corresponds to the correct type
4414: -- of ex-applicant is currently active and in the correct business group,
4415: -- otherwise set the person type id the active default for 'ex-applicant'

Line 4429: -- hr_utility.set_location(l_proc,42);

4425: --
4426: -- IF l_application.system_person_type = 'EMP_APL'
4427: -- THEN
4428: -- l_system_person_type := 'EMP';
4429: -- hr_utility.set_location(l_proc,42);
4430: -- ELSIF l_application.system_person_type = 'EX_EMP_APL'
4431: -- THEN
4432: -- l_system_person_type := 'EX_EMP';
4433: -- hr_utility.set_location(l_proc,44);

Line 4433: -- hr_utility.set_location(l_proc,44);

4429: -- hr_utility.set_location(l_proc,42);
4430: -- ELSIF l_application.system_person_type = 'EX_EMP_APL'
4431: -- THEN
4432: -- l_system_person_type := 'EX_EMP';
4433: -- hr_utility.set_location(l_proc,44);
4434: -- ELSE
4435: -- l_system_person_type := 'EX_APL';
4436: -- hr_utility.set_location(l_proc,46);
4437: -- END IF;

Line 4436: -- hr_utility.set_location(l_proc,46);

4432: -- l_system_person_type := 'EX_EMP';
4433: -- hr_utility.set_location(l_proc,44);
4434: -- ELSE
4435: -- l_system_person_type := 'EX_APL';
4436: -- hr_utility.set_location(l_proc,46);
4437: -- END IF;
4438: --
4439: -- End of Bug 2929504.
4440: --

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

4443: ,p_business_group_id => l_application.business_group_id
4444: ,p_expected_sys_type => 'EX_APL'
4445: );
4446: --
4447: hr_utility.set_location(l_proc,50);
4448: --
4449: --
4450: -- Lock person record
4451: --

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

4466: ,p_validation_end_date => l_validation_end_date
4467: );
4468: */
4469: --
4470: hr_utility.set_location(l_proc,60);
4471: --
4472: -- Lock application record
4473: --
4474: per_apl_shd.lck

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

4475: (p_application_id => l_application.application_id
4476: ,p_object_version_number => l_application.object_version_number
4477: );
4478: --
4479: hr_utility.set_location(l_proc,70);
4480: --
4481: -- Terminate all applicant assignments for person
4482: --
4483: -- Remove future-dated assignments

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

4640: else
4641: l_remove_future_asg_warning := FALSE;
4642: end if;
4643: --
4644: hr_utility.set_location(l_proc,80);
4645: --
4646: -- Update person and ptu records
4647: --
4648: hr_applicant_internal.Update_PER_PTU_To_EX_APL

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

4653: ,p_per_effective_start_date => l_effective_start_date
4654: ,p_per_effective_end_date => l_effective_end_date
4655: );
4656: --
4657: hr_utility.set_location(l_proc,90);
4658: --
4659: -- End the application
4660: --
4661: UPDATE per_applications

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

4672: ,p_termination_reason => p_termination_reason
4673: );
4674: */
4675: --
4676: hr_utility.set_location(l_proc,100);
4677:
4678: -- PTU : Added
4679: -- l_person_type_id1 :=
4680: -- hr_person_type_usage_info.get_default_person_type_id

Line 4723: -- hr_utility.set_location(l_proc,100);

4719: -- );
4720: --
4721: -- PTU : Following Code has been added
4722: --
4723: -- hr_utility.set_location(l_proc,100);
4724: --
4725: -- hr_per_type_usage_internal.maintain_person_type_usage
4726: -- (p_effective_date => l_effective_date + 1
4727: -- ,p_person_id => p_person_id

Line 4733: -- hr_utility.set_location(l_proc,110);

4729: -- );
4730:
4731: -- PTU : End of changes
4732:
4733: -- hr_utility.set_location(l_proc,110);
4734: --
4735: -- Call After Process User Hook
4736: --
4737: BEGIN

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

4753: ,p_hook_type => 'A'
4754: );
4755: END;
4756: --
4757: hr_utility.set_location(l_proc,120);
4758: --
4759: -- When in validation only mode raise validate enabled exception
4760: --
4761: IF p_validate

Line 4772: hr_utility.set_location(' Leaving:'||l_proc,1000);

4768: p_effective_start_date := l_effective_start_date;
4769: p_effective_end_date := l_effective_end_date;
4770: p_remove_fut_asg_warning := l_remove_future_asg_warning;
4771: --
4772: hr_utility.set_location(' Leaving:'||l_proc,1000);
4773: --
4774: EXCEPTION
4775: WHEN hr_api.validate_enabled
4776: THEN

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

4918: l_per_details_rec csr_per_details%ROWTYPE;
4919: --
4920: BEGIN
4921: --
4922: hr_utility.set_location('Entering:'||l_proc,10);
4923: --
4924: -- Ensure mandatory arguments have been passed
4925: --
4926: hr_api.mandatory_arg_error

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

4942: -- Issue savepoint
4943: --
4944: SAVEPOINT convert_to_applicant;
4945: --
4946: hr_utility.set_location(l_proc,20);
4947: --
4948: -- Get dervied details for person on effective date
4949: --
4950: OPEN csr_per_details

Line 4958: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');

4954: FETCH csr_per_details INTO l_per_details_rec;
4955: IF csr_per_details%NOTFOUND
4956: THEN
4957: CLOSE csr_per_details;
4958: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
4959: hr_utility.raise_error;
4960: END IF;
4961: CLOSE csr_per_details;
4962: --

Line 4959: hr_utility.raise_error;

4955: IF csr_per_details%NOTFOUND
4956: THEN
4957: CLOSE csr_per_details;
4958: hr_utility.set_message(800,'PER_52097_APL_INV_PERSON_ID');
4959: hr_utility.raise_error;
4960: END IF;
4961: CLOSE csr_per_details;
4962: --
4963: hr_utility.set_location(l_proc,30);

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

4959: hr_utility.raise_error;
4960: END IF;
4961: CLOSE csr_per_details;
4962: --
4963: hr_utility.set_location(l_proc,30);
4964: --
4965: -- Call Before Process User Hook
4966: --
4967: BEGIN

Line 4985: -- hr_utility.set_location(l_proc,40);

4981: ,p_hook_type => 'BP'
4982: );
4983: END;
4984: --
4985: -- hr_utility.set_location(l_proc,40);
4986: --
4987: -- Check the person is of a correct system person type
4988: --
4989: IF l_per_details_rec.system_person_type NOT IN ('EX_APL','EX_EMP','OTHER')

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

4987: -- Check the person is of a correct system person type
4988: --
4989: IF l_per_details_rec.system_person_type NOT IN ('EX_APL','EX_EMP','OTHER')
4990: THEN
4991: hr_utility.set_location(l_proc,50);
4992: hr_utility.set_message(800,'PER_52096_APL_INV_PERSON_TYPE');
4993: hr_utility.raise_error;
4994: END IF;
4995: --

Line 4992: hr_utility.set_message(800,'PER_52096_APL_INV_PERSON_TYPE');

4988: --
4989: IF l_per_details_rec.system_person_type NOT IN ('EX_APL','EX_EMP','OTHER')
4990: THEN
4991: hr_utility.set_location(l_proc,50);
4992: hr_utility.set_message(800,'PER_52096_APL_INV_PERSON_TYPE');
4993: hr_utility.raise_error;
4994: END IF;
4995: --
4996: hr_utility.set_location(l_proc,60);

Line 4993: hr_utility.raise_error;

4989: IF l_per_details_rec.system_person_type NOT IN ('EX_APL','EX_EMP','OTHER')
4990: THEN
4991: hr_utility.set_location(l_proc,50);
4992: hr_utility.set_message(800,'PER_52096_APL_INV_PERSON_TYPE');
4993: hr_utility.raise_error;
4994: END IF;
4995: --
4996: hr_utility.set_location(l_proc,60);
4997: --

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

4992: hr_utility.set_message(800,'PER_52096_APL_INV_PERSON_TYPE');
4993: hr_utility.raise_error;
4994: END IF;
4995: --
4996: hr_utility.set_location(l_proc,60);
4997: --
4998: -- Ensure the applicant number will not be changed if it exists
4999: --
5000: IF l_per_details_rec.applicant_number IS NOT NULL

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

4999: --
5000: IF l_per_details_rec.applicant_number IS NOT NULL
5001: AND NVL(p_applicant_number,hr_api.g_number) <> l_per_details_rec.applicant_number
5002: THEN
5003: hr_utility.set_location(l_proc,70);
5004: p_applicant_number := l_per_details_rec.applicant_number;
5005: END IF;
5006: --
5007: hr_utility.set_location(l_proc,80);

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

5003: hr_utility.set_location(l_proc,70);
5004: p_applicant_number := l_per_details_rec.applicant_number;
5005: END IF;
5006: --
5007: hr_utility.set_location(l_proc,80);
5008: --
5009: -- 3652025: Create an applicant, generate the application and
5010: -- the applicant assignment
5011: --

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

5025: ,p_per_effective_start_date => l_effective_start_date
5026: ,p_per_effective_end_date => l_effective_end_date
5027: ,p_appl_override_warning => l_appl_override_warning);
5028: --
5029: hr_utility.set_location(l_proc,90);
5030: --
5031: -- Update the security lists
5032: --
5033: hr_security_internal.populate_new_person(l_per_details_rec.business_group_id,p_person_id);

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

5031: -- Update the security lists
5032: --
5033: hr_security_internal.populate_new_person(l_per_details_rec.business_group_id,p_person_id);
5034: --
5035: hr_utility.set_location(l_proc,100);
5036: --
5037: -- Call After Process User Hook
5038: --
5039: BEGIN

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

5056: ,p_hook_type => 'AP'
5057: );
5058: END;
5059: --
5060: hr_utility.set_location(l_proc,180);
5061: --
5062: -- When in validation only mode raise validate_enabled exception
5063: --
5064: IF p_validate

Line 5075: hr_utility.set_location(' Leaving:'||l_proc,1000);

5071: p_effective_start_date := l_effective_start_date;
5072: p_effective_end_date := l_effective_end_date;
5073: p_appl_override_warning := l_appl_override_warning;
5074: --
5075: hr_utility.set_location(' Leaving:'||l_proc,1000);
5076: --
5077: EXCEPTION
5078: --
5079: WHEN hr_api.validate_enabled

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

5269: savepoint apply_for_job_anytime;
5270: end if;
5271: --
5272: if g_debug then
5273: hr_utility.set_location('Entering:'|| l_proc, 5);
5274: end if;
5275: --
5276: -- Truncate p_effective_date
5277: --

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

5292: ,p_argument => 'person id'
5293: ,p_argument_value => p_person_id);
5294: --
5295: if g_debug then
5296: hr_utility.set_location(' Leaving:'||l_proc, 10);
5297: end if;
5298: --
5299: -- Check that this person (p_person_id) exists as of l_effective_date
5300: -- the current person type (per_people_f.person_type_id)

Line 5310: hr_utility.set_message(800, 'HR_51011_PER_NOT_EXIST_DATE');

5306: ,l_npw_number
5307: ,l_system_person_type;
5308: if csr_chk_person_exists%notfound then
5309: close csr_chk_person_exists;
5310: hr_utility.set_message(800, 'HR_51011_PER_NOT_EXIST_DATE');
5311: hr_utility.raise_error;
5312: end if;
5313: close csr_chk_person_exists;
5314: --

Line 5311: hr_utility.raise_error;

5307: ,l_system_person_type;
5308: if csr_chk_person_exists%notfound then
5309: close csr_chk_person_exists;
5310: hr_utility.set_message(800, 'HR_51011_PER_NOT_EXIST_DATE');
5311: hr_utility.raise_error;
5312: end if;
5313: close csr_chk_person_exists;
5314: --
5315: --

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

5313: close csr_chk_person_exists;
5314: --
5315: --
5316: if g_debug then
5317: hr_utility.set_location(l_proc, 15);
5318: end if;
5319:
5320: --
5321: -- Initialise local variables

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

5350: end;
5351: -- processing logic
5352: --
5353: if g_debug then
5354: hr_utility.set_location(l_proc, 20);
5355: end if;
5356: --
5357:
5358: -- Validate that the person_type_id passed is a flavour of 'APL' or derive the default

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

5362: p_business_group_id => l_business_group_id,
5363: p_expected_sys_type => 'APL');
5364: --
5365: if g_debug then
5366: hr_utility.set_location(l_proc, 25);
5367: end if;
5368: --
5369: hr_applicant_internal.create_applicant_anytime
5370: (p_effective_date => l_effective_date

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

5385: --
5386: hr_security_internal.add_to_person_list(l_effective_date,l_assignment_id);
5387: --
5388: if g_debug then
5389: hr_utility.set_location(l_proc, 30);
5390: end if;
5391: --
5392: --
5393: begin

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

5447: raise hr_api.validate_enabled;
5448: end if;
5449: --
5450: if g_debug then
5451: hr_utility.set_location(' Leaving:'||l_proc, 50);
5452: end if;
5453: exception
5454: when hr_api.validate_enabled then
5455: --

Line 5478: hr_utility.set_location(' Leaving:'||l_proc, 55);

5474: p_per_effective_end_date := null;
5475: p_appl_override_warning := null;
5476: --
5477: if g_debug then
5478: hr_utility.set_location(' Leaving:'||l_proc, 55);
5479: end if;
5480: --
5481: end apply_for_job_anytime;
5482: --