[Home] [Help]
48: l_tax_district_changed_warning BOOLEAN;
49: --
50: BEGIN
51: --
52: hr_utility.set_location('Entering : '||l_proc,10);
53: --
54: -- Issue a savepoint for rollbacks
55: --
56: SAVEPOINT move_cwk_asg;
75: ,p_spp_delete_warning => l_spp_delete_warning
76: ,p_entries_changed_warning => l_entries_changed_warning
77: ,p_tax_district_changed_warning => l_tax_district_changed_warning);
78: --
79: hr_utility.set_location(' Leaving:'||l_proc, 997);
80: --
81: EXCEPTION
82: --
83: WHEN hr_api.validate_enabled THEN
101: p_spp_delete_warning := l_spp_delete_warning;
102: p_entries_changed_warning := l_entries_changed_warning;
103: p_tax_district_changed_warning := l_tax_district_changed_warning;
104: --
105: hr_utility.set_location(' Leaving:'||l_proc, 998);
106: --
107: WHEN OTHERS THEN
108: --
109: -- A validation or unexpected error has occurred
122: p_spp_delete_warning := FALSE;
123: p_entries_changed_warning := NULL;
124: p_tax_district_changed_warning := FALSE;
125: --
126: hr_utility.set_location(' Leaving:'||l_proc, 999);
127: --
128: RAISE;
129: --
130: END move_cwk_asg;
227: and asg2.effective_start_date < p_effective_date);
228: --
229: begin
230: --
231: hr_utility.set_location('Entering:'|| l_proc, 10);
232: --
233: -- Issue a savepoint
234: --
235: savepoint move_emp_asg;
242: (p_assignment_id => p_assignment_id
243: ,p_effective_date => p_effective_date
244: ,p_object_version_number => l_object_version_number);
245: --
246: hr_utility.set_location(l_proc, 20);
247: --
248: -- Validate that at least one of P_POSITION_ID, P_ORGANIZATION_ID,P_GRADE or
249: -- P_LOCATION_ID is being updated.
250: --
260: and nvl(per_asg_shd.g_old_rec.location_id, hr_api.g_number) <>
261: nvl(p_location_id, hr_api.g_number) ) ) then
262: null;
263: else
264: hr_utility.set_message(801, 'HR_51104_MMV_MUST_UPD_ASG');
265: hr_utility.raise_error;
266: end if;
267: --
268: hr_utility.set_location( l_proc, 30 );
261: nvl(p_location_id, hr_api.g_number) ) ) then
262: null;
263: else
264: hr_utility.set_message(801, 'HR_51104_MMV_MUST_UPD_ASG');
265: hr_utility.raise_error;
266: end if;
267: --
268: hr_utility.set_location( l_proc, 30 );
269: --
264: hr_utility.set_message(801, 'HR_51104_MMV_MUST_UPD_ASG');
265: hr_utility.raise_error;
266: end if;
267: --
268: hr_utility.set_location( l_proc, 30 );
269: --
270: -- Call the pre-core move assignment customer stub
271: --
272: hr_mass_move_cus.pre_move_emp_asg
312: ,p_segment29 => p_segment29
313: ,p_segment30 => p_segment30
314: );
315: --
316: hr_utility.set_location( l_proc, 40 );
317: --
318: hr_assignment_api.update_emp_asg_criteria
319: (p_validate => FALSE
320: ,p_effective_date => p_effective_date
337: ,p_entries_changed_warning => l_entries_changed_warning
338: ,p_tax_district_changed_warning => l_tax_district_changed_warning
339: );
340: --
341: hr_utility.set_location( l_proc, 45 );
342: --
343: -- Save the object version number and effective start date as of this update
344: -- so that they may be passed to the post_move_emp_asg stub package, where
345: -- the customer can do further corrections if necessary.
343: -- Save the object version number and effective start date as of this update
344: -- so that they may be passed to the post_move_emp_asg stub package, where
345: -- the customer can do further corrections if necessary.
346: --
347: hr_utility.trace('p_effective_date '|| p_effective_date);
348: --
349: open csr_get_old_asg_data;
350: fetch csr_get_old_asg_data
351: into l_old_asg_eff_start_date
350: fetch csr_get_old_asg_data
351: into l_old_asg_eff_start_date
352: , l_old_asg_object_version_num;
353: if csr_get_old_asg_data%notfound then
354: hr_utility.set_location( l_proc, 47 );
355: l_old_asg_eff_start_date := p_effective_date;
356: l_old_asg_object_version_num := l_object_version_number;
357: end if;
358: close csr_get_old_asg_data;
356: l_old_asg_object_version_num := l_object_version_number;
357: end if;
358: close csr_get_old_asg_data;
359: --
360: hr_utility.set_location( l_proc, 50 );
361: --
362: -- If the assignment currently has SCL information :
363: --
364: if per_asg_shd.g_old_rec.soft_coding_keyflex_id is not null then
361: --
362: -- If the assignment currently has SCL information :
363: --
364: if per_asg_shd.g_old_rec.soft_coding_keyflex_id is not null then
365: hr_utility.set_location( l_proc, 55 );
366: --
367: l_scl_api_updating := hr_scl_shd.api_updating
368: (p_soft_coding_keyflex_id =>
369: per_asg_shd.g_old_rec.soft_coding_keyflex_id);
461: and nvl(hr_scl_shd.g_old_rec.segment30, hr_api.g_varchar2) <>
462: nvl(p_segment30, hr_api.g_varchar2) )
463: ) then
464: --
465: hr_utility.set_location( l_proc, 60 );
466: --
467: l_scl_updated_flag := TRUE;
468: --
469: else
467: l_scl_updated_flag := TRUE;
468: --
469: else
470: --
471: hr_utility.set_location( l_proc, 65 );
472: --
473: l_scl_updated_flag := FALSE;
474: --
475: end if;
477: --
478: -- Otherwise, if the assignment does not currently have SCL information
479: -- check whether any of the SCL segments are being set for the first time
480: --
481: hr_utility.set_location( l_proc, 70 );
482: --
483: if nvl(p_segment1, hr_api.g_varchar2) <> hr_api.g_varchar2
484: or nvl(p_segment2, hr_api.g_varchar2) <> hr_api.g_varchar2
485: or nvl(p_segment3, hr_api.g_varchar2) <> hr_api.g_varchar2
510: or nvl(p_segment28, hr_api.g_varchar2) <> hr_api.g_varchar2
511: or nvl(p_segment29, hr_api.g_varchar2) <> hr_api.g_varchar2
512: or nvl(p_segment30, hr_api.g_varchar2) <> hr_api.g_varchar2 then
513: --
514: hr_utility.set_location( l_proc, 75 );
515: --
516: l_scl_updated_flag := TRUE;
517: --
518: else
516: l_scl_updated_flag := TRUE;
517: --
518: else
519: --
520: hr_utility.set_location( l_proc, 80 );
521: --
522: l_scl_updated_flag := FALSE;
523: --
524: end if;
538: and nvl(per_asg_shd.g_old_rec.time_normal_start, hr_api.g_varchar2) <>
539: nvl(p_time_normal_start, hr_api.g_varchar2) )
540: ) then
541: --
542: hr_utility.set_location( l_proc, 85 );
543: --
544: hr_assignment_api.update_emp_asg
545: (p_validate => FALSE
546: ,p_effective_date => p_effective_date
589: ,p_no_managers_warning => l_no_managers_warning
590: ,p_other_manager_warning => l_other_manager_warning );
591: end if;
592: --
593: hr_utility.set_location( l_proc, 87 );
594: --
595: -- Call the post-core move assignment customer stub
596: -- NOTE : if l_effective_start_date is null assign l_old_asg_eff_start_date
597: -- to the p_new_asg_eff_start_date. l_effective_start_date will be null,
625: p_other_manager_warning := l_other_manager_warning;
626: p_entries_changed_warning := l_entries_changed_warning;
627: p_spp_delete_warning := l_spp_delete_warning;
628: --
629: hr_utility.set_location(' Leaving:'||l_proc, 997);
630: --
631: exception
632: --
633: when hr_api.validate_enabled then
650: p_other_manager_warning := l_other_manager_warning;
651: p_entries_changed_warning := l_entries_changed_warning;
652: p_spp_delete_warning := l_spp_delete_warning;
653: --
654: hr_utility.set_location(' Leaving:'||l_proc, 998);
655: --
656: when others then
657: --
658: -- A validation or unexpected error has occurred
672: p_other_manager_warning := false;
673: p_entries_changed_warning := null;
674: p_spp_delete_warning := false;
675: --
676: hr_utility.set_location(' Leaving:'||l_proc, 999);
677: --
678: raise;
679: --
680: end move_emp_asg;
1099: l_pos_dt_mode varchar2(30);
1100: --
1101: begin
1102: --
1103: hr_utility.set_location('Entering:'|| l_proc, 5);
1104: --
1105: -- Issue a savepoint
1106: --
1107: savepoint move_position;
1115: p_argument_value => p_position_id);
1116: --
1117: -- Get business_group_id, and all attributes of 'old' position.
1118: --
1119: hr_utility.set_location(l_proc, 10);
1120: --
1121: open csr_old_pos;
1122: fetch csr_old_pos
1123: into
1195: ,p_supervisor_id;
1196: --
1197: if csr_old_pos%notfound then
1198: --
1199: hr_utility.set_location(l_proc, 20);
1200: --
1201: close csr_old_pos;
1202: hr_utility.set_message(801, 'HR_51093_POS_NOT_EXIST');
1203: hr_utility.raise_error;
1198: --
1199: hr_utility.set_location(l_proc, 20);
1200: --
1201: close csr_old_pos;
1202: hr_utility.set_message(801, 'HR_51093_POS_NOT_EXIST');
1203: hr_utility.raise_error;
1204: --
1205: else
1206: close csr_old_pos;
1199: hr_utility.set_location(l_proc, 20);
1200: --
1201: close csr_old_pos;
1202: hr_utility.set_message(801, 'HR_51093_POS_NOT_EXIST');
1203: hr_utility.raise_error;
1204: --
1205: else
1206: close csr_old_pos;
1207: end if;
1205: else
1206: close csr_old_pos;
1207: end if;
1208: --
1209: hr_utility.set_location(l_proc, 30);
1210:
1211: open isdel;
1212: fetch isdel into l_flex_num;
1213: if isdel%notfound then
1214: close isdel;
1215: --
1216: -- the flex structure has not been found
1217: --
1218: hr_utility.set_message(801, 'HR_7471_FLEX_POS_INVLALID_ID');
1219: hr_utility.raise_error;
1220: end if;
1221: close isdel;
1222: hr_utility.set_location(l_proc, 40);
1215: --
1216: -- the flex structure has not been found
1217: --
1218: hr_utility.set_message(801, 'HR_7471_FLEX_POS_INVLALID_ID');
1219: hr_utility.raise_error;
1220: end if;
1221: close isdel;
1222: hr_utility.set_location(l_proc, 40);
1223: --
1218: hr_utility.set_message(801, 'HR_7471_FLEX_POS_INVLALID_ID');
1219: hr_utility.raise_error;
1220: end if;
1221: close isdel;
1222: hr_utility.set_location(l_proc, 40);
1223: --
1224: -- Determine if the 'new' position exists by calling ins_or_sel
1225: -- to get position definition id
1226: --
1264: );
1265: --
1266: -- Check if 'new' position already exists within date range
1267: --
1268: hr_utility.set_location(l_proc, 50);
1269: --
1270: open csr_new_pos;
1271: fetch csr_new_pos into
1272: l_new_position_id
1277: ,l_new_pos_org;
1278: --
1279: if csr_new_pos%found then
1280: -- Check if 'new' position exists but in a different organization
1281: hr_utility.set_location(l_proc, 60);
1282: --
1283: -- Warn if 'new' position exists but in a different organization
1284: --
1285: if l_new_pos_org <> p_organization_id then
1318: close csr_pos_vacancy;
1319: --
1320: -- Call the pre_move_position stub for any customer specific processing
1321: --
1322: hr_utility.set_location(l_proc, 70);
1323: --
1324: hr_mass_move_cus.pre_move_position
1325: (p_position_id => p_position_id
1326: ,p_object_version_number => l_object_version_number
1364: -- If the 'new' position did not exist then create the 'new' position
1365: --
1366: if l_new_position_id is null then
1367: --
1368: hr_utility.set_location(l_proc, 80);
1369: --
1370: hr_position_api.create_position
1371: (p_validate => FALSE
1372: ,p_position_id => l_new_position_id
1617: -- job requirements from the 'old' position. If the 'new' position
1618: -- already existed, only create job requirements from the old position
1619: -- that the 'new' position doesn't already have defined.
1620: --
1621: hr_utility.set_location(l_proc, 90);
1622: --
1623: for csr_jbr_rec in csr_jbr loop
1624: --
1625: -- fixed error in call: changed call from
1696: -- valid grades will be inserted into per valid grades.
1697: --
1698: for csr_vgr_rec in csr_vgr loop
1699: --
1700: hr_utility.set_location(l_proc, 100);
1701: --
1702: hr_valid_grade_api.create_valid_grade
1703: (p_grade_id => csr_vgr_rec.target_grade_id
1704: ,p_date_from => p_date_effective
1732: --
1733: -- If deactivate_old_position is true then close down the 'old'
1734: -- position
1735: --
1736: hr_utility.set_location(l_proc, 110);
1737: --
1738: -- If the old position is to be deactivated then
1739: -- determine the availability status
1740: --
1739: -- determine the availability status
1740: --
1741: if p_deactivate_old_position then
1742: --
1743: hr_utility.set_location(l_proc, 120);
1744: --
1745: l_date_end := p_date_effective - 1;
1746: --
1747: -- Added as part of fix for bug 2943725
1752: open csr_current_status;
1753: fetch csr_current_status into l_current_system_type_cd;
1754: close csr_current_status;
1755: --
1756: hr_utility.set_location(l_proc||'/'||l_current_system_type_cd, 130);
1757: hr_utility.set_location(l_proc||'/'||p_position_id, 131);
1758: hr_utility.set_location(l_proc||'/'||p_date_effective, 132);
1759: --
1760: -- If the status is Active then change the status to Eliminated
1753: fetch csr_current_status into l_current_system_type_cd;
1754: close csr_current_status;
1755: --
1756: hr_utility.set_location(l_proc||'/'||l_current_system_type_cd, 130);
1757: hr_utility.set_location(l_proc||'/'||p_position_id, 131);
1758: hr_utility.set_location(l_proc||'/'||p_date_effective, 132);
1759: --
1760: -- If the status is Active then change the status to Eliminated
1761: --
1754: close csr_current_status;
1755: --
1756: hr_utility.set_location(l_proc||'/'||l_current_system_type_cd, 130);
1757: hr_utility.set_location(l_proc||'/'||p_position_id, 131);
1758: hr_utility.set_location(l_proc||'/'||p_date_effective, 132);
1759: --
1760: -- If the status is Active then change the status to Eliminated
1761: --
1762: if l_current_system_type_cd = 'ACTIVE' then
1760: -- If the status is Active then change the status to Eliminated
1761: --
1762: if l_current_system_type_cd = 'ACTIVE' then
1763: --
1764: hr_utility.set_location(l_proc, 140);
1765: --
1766: l_system_type_cd := 'ELIMINATED';
1767: --
1768: -- Else if the status is Proposed then the status will
1769: -- become Deleted.
1770: --
1771: elsif l_current_system_type_cd = 'PROPOSED' then
1772: --
1773: hr_utility.set_location(l_proc, 150);
1774: --
1775: l_system_type_cd := 'DELETED';
1776: --
1777: end if;
1781: open csr_avail_status(p_system_type_cd => l_system_type_cd);
1782: fetch csr_avail_status into p_availability_status_id;
1783: close csr_avail_status;
1784: --
1785: hr_utility.set_location(l_proc||'/'||l_system_type_cd, 160);
1786: --
1787: -- End of fix for bug 2943725
1788: --
1789: l_pos_dt_mode := 'UPDATE';
1815: ,p_valid_grades_changed_warning => l_valid_grades_changed_warning
1816: );
1817: */
1818: --
1819: hr_utility.set_location(l_proc, 170);
1820: --
1821: end if;
1822: --
1823: -- This is customer specific processing
1853: p_pos_pending_close_warning := l_pos_pending_close_warning;
1854: p_pos_jbe_not_moved_warning := l_pos_jbe_not_moved_warning;
1855: p_pos_vac_not_moved_warning := l_pos_vac_not_moved_warning;
1856: --
1857: hr_utility.set_location(' Leaving:'||l_proc, 997);
1858: --
1859: exception
1860: --
1861: when hr_api.validate_enabled then
1880: p_pos_pending_close_warning := l_pos_pending_close_warning;
1881: p_pos_jbe_not_moved_warning := l_pos_jbe_not_moved_warning;
1882: p_pos_vac_not_moved_warning := l_pos_vac_not_moved_warning;
1883: --
1884: hr_utility.set_location(' Leaving:'||l_proc, 998);
1885: --
1886: when others then
1887: --
1888: hr_utility.set_location(' Leaving:'||l_proc, 999);
1884: hr_utility.set_location(' Leaving:'||l_proc, 998);
1885: --
1886: when others then
1887: --
1888: hr_utility.set_location(' Leaving:'||l_proc, 999);
1889: --
1890: -- if it is an business rule violation error then only rollback
1891: -- this positon record.
1892: --
2052: and select_assignment = 'Y';
2053: --
2054: begin
2055: --
2056: hr_utility.set_location('Entering:'|| l_proc, 10);
2057: --
2058: -- Issue a savepoint
2059: --
2060: savepoint move_assignment;
2065: begin
2066: --
2067: savepoint move_asg;
2068: --
2069: hr_utility.set_location(l_proc||'/'||mmasgrec.assignment_id, 20);
2070: --
2071: -- GRE/Legal Entity will only move for US legislation.
2072: --
2073: if p_legislation_code = 'US' then
2081: end if;
2082: --
2083: if mmasgrec.default_from = 'B' then
2084: --
2085: hr_utility.set_location(l_proc, 30);
2086: --
2087: l_location_id := p_bg_location_id;
2088: l_frequency := p_bg_frequency;
2089: l_normal_hours := p_bg_normal_hours;
2091: l_time_normal_start := p_bg_time_normal_start;
2092: --
2093: elsif mmasgrec.default_from = 'O' then
2094: --
2095: hr_utility.set_location(l_proc, 40);
2096: --
2097: l_location_id := p_org_location_id;
2098: l_frequency := p_org_frequency;
2099: l_normal_hours := p_org_normal_hours;
2101: l_time_normal_start := p_org_time_normal_start;
2102: --
2103: elsif mmasgrec.default_from = 'P' then
2104: --
2105: hr_utility.set_location(l_proc, 50);
2106: --
2107: l_location_id := p_pos_location_id;
2108: l_frequency := p_pos_frequency;
2109: l_normal_hours := p_pos_normal_hours;
2111: l_time_normal_start := p_pos_time_normal_start;
2112: --
2113: elsif mmasgrec.default_from = 'A' then
2114: --
2115: hr_utility.set_location(l_proc, 60);
2116: --
2117: l_location_id := mmasgrec.location_id;
2118: l_frequency := mmasgrec.frequency;
2119: l_normal_hours := mmasgrec.normal_hours;
2123: end if;
2124: --
2125: if mmasgrec.vacancy_id is not null then
2126: --
2127: hr_utility.set_location(l_proc, 70);
2128: --
2129: raise asg_vacancy_warning;
2130: --
2131: end if;
2136: l_mm_assignment_id := mmasgrec.assignment_id;
2137: --
2138: if csr_future_asg_changes%found then
2139: --
2140: hr_utility.set_location(l_proc, 80);
2141: close csr_future_asg_changes;
2142: raise future_asg_warning;
2143: --
2144: end if;
2146: close csr_future_asg_changes;
2147: --
2148: if mmasgrec.assignment_type = 'A' then
2149: --
2150: hr_utility.set_location(l_proc, 90);
2151: --
2152: hr_assignment_api.update_apl_asg
2153: (p_validate => FALSE
2154: ,p_effective_date => p_effective_date
2180: -- Assignment is for a Contingent Worker
2181: --
2182: elsif mmasgrec.assignment_type = 'C' then
2183: --
2184: hr_utility.set_location(l_proc, 95);
2185: --
2186: hr_mass_move_api.move_cwk_asg
2187: (p_validate => p_validate
2188: ,p_effective_date => p_effective_date
2205: ,p_tax_district_changed_warning => l_tax_district_changed_warning);
2206: --
2207: else -- assignment_type = 'E'
2208: --
2209: hr_utility.set_location(l_proc, 100);
2210: --
2211: hr_mass_move_api.move_emp_asg
2212: (p_validate => FALSE
2213: ,p_mass_move_id => p_mass_move_id
2236: end if; /* if assignment type = 'E' */
2237: --
2238: if l_spp_delete_warning then
2239: --
2240: hr_utility.set_message(800,'HR_289826_SPP_DELETE_WARN_API');
2241: --
2242: hr_batch_message_line_api.create_message_line
2243: (p_validate => FALSE
2244: ,p_batch_run_number => p_batch_run_number
2244: ,p_batch_run_number => p_batch_run_number
2245: ,p_api_name => 'hr_mass_move_api.move_emp_asg'
2246: ,p_status => 'S'
2247: ,p_error_number => '289286'
2248: ,p_error_message => hr_utility.get_message
2249: ,p_extended_error_message => fnd_message.get
2250: ,p_source_row_information => mmasgrec.full_name
2251: ,p_line_id => l_dummy_line_id);
2252: --
2253: end if;
2254: --
2255: if l_org_now_no_manager_warning then
2256: --
2257: hr_utility.set_message(801,'HR_51124_MMV_NO_MGR_EXIST_ORG');
2258: --
2259: hr_batch_message_line_api.create_message_line
2260: (p_validate => FALSE
2261: ,p_batch_run_number => p_batch_run_number
2261: ,p_batch_run_number => p_batch_run_number
2262: ,p_api_name => 'hr_mass_move_api.move_emp_asg'
2263: ,p_status => 'S'
2264: ,p_error_number => '51124'
2265: ,p_error_message => hr_utility.get_message
2266: ,p_extended_error_message => fnd_message.get
2267: ,p_source_row_information => mmasgrec.full_name
2268: ,p_line_id => l_dummy_line_id);
2269: --
2270: end if;
2271: --
2272: if l_other_manager_warning then
2273: --
2274: hr_utility.set_message(801,'HR_51125_MMV_MRE_MGR_EXIST_ORG');
2275: --
2276: hr_batch_message_line_api.create_message_line
2277: (p_validate => FALSE
2278: ,p_batch_run_number => p_batch_run_number
2278: ,p_batch_run_number => p_batch_run_number
2279: ,p_api_name => 'hr_mass_move_api.move_emp_asg'
2280: ,p_status => 'S'
2281: ,p_error_number => '51125'
2282: ,p_error_message => hr_utility.get_message
2283: ,p_extended_error_message => fnd_message.get
2284: ,p_source_row_information => mmasgrec.full_name
2285: ,p_line_id => l_dummy_line_id);
2286: --
2287: end if;
2288: --
2289: if l_entries_changed_warning = 'S' then
2290: --
2291: hr_utility.set_message(801,'HR_51126_MMV_SAL_ENT_ALTERED');
2292: --
2293: hr_batch_message_line_api.create_message_line
2294: (p_validate => FALSE
2295: ,p_batch_run_number => p_batch_run_number
2295: ,p_batch_run_number => p_batch_run_number
2296: ,p_api_name => 'hr_mass_move_api.move_emp_asg'
2297: ,p_status => 'S'
2298: ,p_error_number => '51126'
2299: ,p_error_message => hr_utility.get_message
2300: ,p_extended_error_message => fnd_message.get
2301: ,p_source_row_information => mmasgrec.full_name
2302: ,p_line_id => l_dummy_line_id);
2303: --
2304: end if;
2305: --
2306: if l_entries_changed_warning = 'Y' then
2307: --
2308: hr_utility.set_message(801,'HR_51127_MMV_NON_SAL_ENT_ALR');
2309: --
2310: hr_batch_message_line_api.create_message_line
2311: (p_validate => FALSE
2312: ,p_batch_run_number => p_batch_run_number
2312: ,p_batch_run_number => p_batch_run_number
2313: ,p_api_name => 'hr_mass_move_api.move_emp_asg'
2314: ,p_status => 'S'
2315: ,p_error_number => '51127'
2316: ,p_error_message => hr_utility.get_message
2317: ,p_extended_error_message => fnd_message.get
2318: ,p_source_row_information => mmasgrec.full_name
2319: ,p_line_id => l_dummy_line_id);
2320: --
2319: ,p_line_id => l_dummy_line_id);
2320: --
2321: end if;
2322: --
2323: hr_utility.set_location(l_proc, 110);
2324: --
2325: --
2326: -- if it has made it this far, the applicant/employee assignment was moved
2327: --
2334: when asg_vacancy_warning then
2335: --
2336: rollback to move_asg;
2337: --
2338: hr_utility.set_message(801,'HR_51129_MMV_ASG_NOT_MOVED');
2339: --
2340: hr_batch_message_line_api.create_message_line
2341: (p_validate => FALSE
2342: ,p_batch_run_number => p_batch_run_number
2342: ,p_batch_run_number => p_batch_run_number
2343: ,p_api_name => 'hr_mass_move_api.move_assignment'
2344: ,p_status => 'S'
2345: ,p_error_number => '51129'
2346: ,p_error_message => hr_utility.get_message
2347: ,p_extended_error_message => fnd_message.get
2348: ,p_source_row_information => mmasgrec.full_name
2349: ,p_line_id => l_dummy_line_id);
2350: --
2351: when future_asg_warning then
2352: --
2353: rollback to move_asg;
2354: --
2355: hr_utility.set_message(801,'HR_51103_MMV_ASG_FUTURE_CHG');
2356: --
2357: hr_batch_message_line_api.create_message_line
2358: (p_validate => FALSE
2359: ,p_batch_run_number => p_batch_run_number
2359: ,p_batch_run_number => p_batch_run_number
2360: ,p_api_name => 'hr_mass_move_api.move_assignment'
2361: ,p_status => 'S'
2362: ,p_error_number => '51103'
2363: ,p_error_message => hr_utility.get_message
2364: ,p_extended_error_message => fnd_message.get
2365: ,p_source_row_information => mmasgrec.full_name
2366: ,p_line_id => l_dummy_line_id);
2367: --
2366: ,p_line_id => l_dummy_line_id);
2367: --
2368: when others then
2369: --
2370: hr_utility.set_location(l_proc, 120);
2371: --
2372: if sqlcode = -20001 then
2373: --
2374: rollback to move_asg;
2397: if p_validate then
2398: raise hr_api.validate_enabled;
2399: end if;
2400: --
2401: hr_utility.set_location(' Leaving:'||l_proc, 997);
2402: --
2403: exception
2404: --
2405: when hr_api.validate_enabled then
2408: -- we must rollback to the savepoint
2409: --
2410: ROLLBACK TO move_assignment;
2411: --
2412: hr_utility.set_location(' Leaving:'||l_proc, 998);
2413: --
2414: when others then
2415: --
2416: -- A validation or unexpected error has occurred
2418: -- Added as part of the fix to bug 632479
2419: --
2420: ROLLBACK TO move_assignment;
2421: --
2422: hr_utility.set_location(' Leaving:'||l_proc, 999);
2423: --
2424: raise;
2425: --
2426: end move_assignments;
2663: and status = 'S';
2664: --
2665: begin
2666: --
2667: hr_utility.set_location('Entering:'|| l_proc, 10);
2668: --
2669: -- Issue a savepoint.
2670: --
2671: savepoint activate_mass_move;
2681: -- and is valid.
2682: --
2683: if p_mass_move_id is not null then
2684: --
2685: hr_utility.set_location(l_proc, 20);
2686: --
2687: open csr_get_mass_move_info;
2688: fetch csr_get_mass_move_info into l_new_organization_id,
2689: l_effective_date;
2691: if csr_get_mass_move_info%notfound then
2692: --
2693: close csr_get_mass_move_info;
2694: --
2695: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
2696: hr_utility.raise_error;
2697: --
2698: end if;
2699: --
2692: --
2693: close csr_get_mass_move_info;
2694: --
2695: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
2696: hr_utility.raise_error;
2697: --
2698: end if;
2699: --
2700: close csr_get_mass_move_info;
2700: close csr_get_mass_move_info;
2701: --
2702: else
2703: --
2704: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
2705: hr_utility.raise_error;
2706: --
2707: end if;
2708: --
2701: --
2702: else
2703: --
2704: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
2705: hr_utility.raise_error;
2706: --
2707: end if;
2708: --
2709: -- Issue a savepoint
2722: close csr_lock_per_mm_valid_grades;
2723: open csr_lock_per_mm_job_reqts;
2724: close csr_lock_per_mm_job_reqts;
2725: --
2726: hr_utility.set_location(l_proc, 30);
2727: --
2728: -- Get default location and working conditions from the new
2729: -- organization
2730: --
2738: l_org_location_id;
2739: --
2740: close csr_get_org_defaults;
2741: --
2742: hr_utility.set_location(l_proc, 40);
2743: --
2744: -- Get default location and working conditions from the
2745: -- business group
2746: --
2754: l_bg_location_id;
2755: --
2756: close csr_get_busgrp_defaults;
2757: --
2758: hr_utility.set_location(l_proc, 50);
2759: --
2760: begin
2761: --
2762: -- Start of API User Hook for the before hook of mass_move
2782: --
2783: hr_mass_move_cus.pre_mass_move
2784: (p_mass_move_id => p_mass_move_id);
2785: --
2786: hr_utility.set_location(l_proc, 60);
2787: --
2788: -- Loop through the position records in per_mm_positions, and
2789: -- process the position, applicant assignments, and employee
2790: -- assignment records.
2797: --
2798: l_position_name := mmposrec.name;
2799: l_position_id := mmposrec.position_id;
2800: --
2801: hr_utility.set_location(l_proc||'/'||
2802: l_position_name||'/'||
2803: l_position_id, 70);
2804: --
2805: if mmposrec.deactivate_old_position = 'Y' then
2811: l_deactivate_boolean := FALSE;
2812: --
2813: end if;
2814: --
2815: hr_utility.set_location(l_proc, 80);
2816: --
2817: -- Get default location and working conditions from the
2818: -- old position business group
2819: --
2826: l_old_pos_location_id;
2827: --
2828: close csr_get_old_pos_defaults;
2829: --
2830: hr_utility.set_location(l_proc, 90);
2831: --
2832: if mmposrec.default_from = 'B' then
2833: --
2834: hr_utility.set_location(l_proc, 100);
2830: hr_utility.set_location(l_proc, 90);
2831: --
2832: if mmposrec.default_from = 'B' then
2833: --
2834: hr_utility.set_location(l_proc, 100);
2835: --
2836: l_location_id := l_bg_location_id;
2837: l_frequency := l_bg_frequency;
2838: l_normal_hours := l_bg_normal_hours;
2840: l_time_normal_start := l_bg_time_normal_start;
2841: --
2842: elsif mmposrec.default_from = 'O' then
2843: --
2844: hr_utility.set_location(l_proc, 110);
2845: --
2846: l_location_id := l_org_location_id;
2847: l_frequency := l_org_frequency;
2848: l_normal_hours := l_org_normal_hours;
2850: l_time_normal_start := l_org_time_normal_start;
2851: --
2852: elsif mmposrec.default_from = 'P' then
2853: --
2854: hr_utility.set_location(l_proc, 120);
2855: --
2856: l_location_id := l_old_pos_location_id;
2857: l_frequency := l_old_pos_frequency;
2858: l_normal_hours := l_old_pos_normal_hours;
2864: -- Call the move position process to create the new position
2865: --
2866: if mmposrec.position_moved = 'N' then
2867: --
2868: hr_utility.set_location(l_proc, 130);
2869: --
2870: hr_mass_move_api.move_position
2871: (p_validate => FALSE
2872: ,p_batch_run_number => l_batch_run_number
2922: ,p_pos_jbe_not_moved_warning => l_pos_jbe_not_moved_warning --out
2923: ,p_pos_vac_not_moved_warning => l_pos_vac_not_moved_warning --out
2924: );
2925: --
2926: hr_utility.set_location(l_proc, 140);
2927: --
2928: if (l_new_position_id is not null) then
2929: --
2930: -- If it made it this far, update the position to 'moved'
2937: and mass_move_id = p_mass_move_id;
2938: --
2939: end if;
2940: --
2941: hr_utility.set_location(l_proc, 150);
2942: --
2943: -- in the case of a reexecution, set the vals from the table.
2944: --
2945: else
2943: -- in the case of a reexecution, set the vals from the table.
2944: --
2945: else
2946: --
2947: hr_utility.set_location(l_proc, 160);
2948: --
2949: l_new_position_id := mmposrec.new_position_id;
2950: l_new_job_id := mmposrec.target_job_id;
2951: --
2963: l_new_pos_location_id;
2964: --
2965: close csr_get_new_pos_defaults;
2966: --
2967: hr_utility.set_location(l_proc, 170);
2968: --
2969:
2970: if (l_new_position_id is not null) then -- fix for bug#10311425
2971:
2996:
2997: end if; -- fix for bug#10311425
2998:
2999: --
3000: hr_utility.set_location(l_proc, 180);
3001: --
3002: -- Check for position warning messages
3003: --
3004: if l_pos_exists_warning = TRUE then
3002: -- Check for position warning messages
3003: --
3004: if l_pos_exists_warning = TRUE then
3005: --
3006: hr_utility.set_location(l_proc, 190);
3007: --
3008: ROLLBACK TO move_position;
3009: --
3010: hr_utility.set_message(801,'HR_51330_MMV_POS_EXISTS');
3006: hr_utility.set_location(l_proc, 190);
3007: --
3008: ROLLBACK TO move_position;
3009: --
3010: hr_utility.set_message(801,'HR_51330_MMV_POS_EXISTS');
3011: --
3012: hr_batch_message_line_api.create_message_line
3013: (p_validate => FALSE
3014: ,p_batch_run_number => l_batch_run_number
3014: ,p_batch_run_number => l_batch_run_number
3015: ,p_api_name => 'hr_mass_move_api.move_position'
3016: ,p_status => 'S'
3017: ,p_error_number => '51130'
3018: ,p_error_message => hr_utility.get_message
3019: ,p_extended_error_message => fnd_message.get
3020: ,p_source_row_information => l_position_name
3021: ,p_line_id => l_dummy_line_id);
3022: --
3023: end if;
3024: --
3025: if l_pos_date_range_warning = TRUE then
3026: --
3027: hr_utility.set_location(l_proc, 200);
3028: --
3029: ROLLBACK TO move_position;
3030: --
3031: hr_utility.set_message(801,'HR_51331_MMV_POS_INVALID_DATE');
3027: hr_utility.set_location(l_proc, 200);
3028: --
3029: ROLLBACK TO move_position;
3030: --
3031: hr_utility.set_message(801,'HR_51331_MMV_POS_INVALID_DATE');
3032: --
3033: hr_batch_message_line_api.create_message_line
3034: (p_validate => FALSE
3035: ,p_batch_run_number => l_batch_run_number
3035: ,p_batch_run_number => l_batch_run_number
3036: ,p_api_name => 'hr_mass_move_api.move_position'
3037: ,p_status => 'S'
3038: ,p_error_number => '51331'
3039: ,p_error_message => hr_utility.get_message
3040: ,p_extended_error_message => fnd_message.get
3041: ,p_source_row_information => l_position_name
3042: ,p_line_id => l_dummy_line_id);
3043: --
3044: end if;
3045: --
3046: if l_pos_pending_close_warning = TRUE then
3047: --
3048: hr_utility.set_location(l_proc, 210);
3049: --
3050: hr_utility.set_message(801,'HR_51335_MMV_POS_CLOSED');
3051: --
3052: hr_batch_message_line_api.create_message_line
3046: if l_pos_pending_close_warning = TRUE then
3047: --
3048: hr_utility.set_location(l_proc, 210);
3049: --
3050: hr_utility.set_message(801,'HR_51335_MMV_POS_CLOSED');
3051: --
3052: hr_batch_message_line_api.create_message_line
3053: (p_validate => FALSE
3054: ,p_batch_run_number => l_batch_run_number
3054: ,p_batch_run_number => l_batch_run_number
3055: ,p_api_name => 'hr_mass_move_api.move_position'
3056: ,p_status => 'S'
3057: ,p_error_number => '51335'
3058: ,p_error_message => hr_utility.get_message
3059: ,p_extended_error_message => fnd_message.get
3060: ,p_source_row_information => l_position_name
3061: ,p_line_id => l_dummy_line_id);
3062: --
3063: end if;
3064: --
3065: if l_valid_grades_changed_warning = TRUE then
3066: --
3067: hr_utility.set_location(l_proc, 220);
3068: --
3069: hr_utility.set_message(801,'HR_51128_MMV_VGR_ALTERED');
3070: --
3071: hr_batch_message_line_api.create_message_line
3065: if l_valid_grades_changed_warning = TRUE then
3066: --
3067: hr_utility.set_location(l_proc, 220);
3068: --
3069: hr_utility.set_message(801,'HR_51128_MMV_VGR_ALTERED');
3070: --
3071: hr_batch_message_line_api.create_message_line
3072: (p_validate => FALSE
3073: ,p_batch_run_number => l_batch_run_number
3073: ,p_batch_run_number => l_batch_run_number
3074: ,p_api_name => 'hr_mass_move_api.move_position'
3075: ,p_status => 'S'
3076: ,p_error_number => '51128'
3077: ,p_error_message => hr_utility.get_message
3078: ,p_extended_error_message => fnd_message.get
3079: ,p_source_row_information => l_position_name
3080: ,p_line_id => l_dummy_line_id);
3081: --
3082: end if;
3083: --
3084: if l_pos_jbe_not_moved_warning = TRUE then
3085: --
3086: hr_utility.set_location(l_proc, 230);
3087: --
3088: hr_utility.set_message(801,'HR_51334_MMV_POS_JBE_NOT_MOVED');
3089: --
3090: hr_batch_message_line_api.create_message_line
3084: if l_pos_jbe_not_moved_warning = TRUE then
3085: --
3086: hr_utility.set_location(l_proc, 230);
3087: --
3088: hr_utility.set_message(801,'HR_51334_MMV_POS_JBE_NOT_MOVED');
3089: --
3090: hr_batch_message_line_api.create_message_line
3091: (p_validate => FALSE
3092: ,p_batch_run_number => l_batch_run_number
3092: ,p_batch_run_number => l_batch_run_number
3093: ,p_api_name => 'hr_mass_move_api.move_position'
3094: ,p_status => 'S'
3095: ,p_error_number => '51334'
3096: ,p_error_message => hr_utility.get_message
3097: ,p_extended_error_message => fnd_message.get
3098: ,p_source_row_information => l_position_name
3099: ,p_line_id => l_dummy_line_id);
3100: --
3101: end if;
3102: --
3103: if l_pos_vac_not_moved_warning = TRUE then
3104: --
3105: hr_utility.set_location(l_proc, 240);
3106: --
3107: hr_utility.set_message(801,'HR_51333_MMV_POS_VAC_NOT_MOVED');
3108: --
3109: hr_batch_message_line_api.create_message_line
3103: if l_pos_vac_not_moved_warning = TRUE then
3104: --
3105: hr_utility.set_location(l_proc, 240);
3106: --
3107: hr_utility.set_message(801,'HR_51333_MMV_POS_VAC_NOT_MOVED');
3108: --
3109: hr_batch_message_line_api.create_message_line
3110: (p_validate => FALSE
3111: ,p_batch_run_number => l_batch_run_number
3111: ,p_batch_run_number => l_batch_run_number
3112: ,p_api_name => 'hr_mass_move_api.move_position'
3113: ,p_status => 'S'
3114: ,p_error_number => '51333'
3115: ,p_error_message => hr_utility.get_message
3116: ,p_extended_error_message => fnd_message.get
3117: ,p_source_row_information => l_position_name
3118: ,p_line_id => l_dummy_line_id);
3119: --
3122: end; --begin
3123: --
3124: end loop; /* end loop through positions in per_mm_positions */
3125: --
3126: hr_utility.set_location(l_proc, 250);
3127: --
3128: -- Call Customer-Specific stub to handle post-mass move validation
3129: --
3130: hr_mass_move_cus.post_mass_move
3136: open csr_chk_errors;
3137: fetch csr_chk_errors into l_errors_exist;
3138: close csr_chk_errors;
3139: --
3140: hr_utility.set_location(l_proc, 260);
3141: --
3142: l_warnings_exist := 'N';
3143: open csr_chk_warnings;
3144: fetch csr_chk_warnings into l_warnings_exist;
3145: close csr_chk_warnings;
3146: --
3147: if l_errors_exist = 'Y' then
3148: --
3149: hr_utility.set_location(l_proc, 270);
3150: --
3151: rollback to massmove;
3152: --
3153: update per_mass_moves
3156: where mass_move_id = p_mass_move_id;
3157: --
3158: elsif l_warnings_exist = 'Y' then
3159: --
3160: hr_utility.set_location(l_proc, 280);
3161: --
3162: update per_mass_moves
3163: set batch_run_number = l_batch_run_number,
3164: status = 'WA'
3165: where mass_move_id = p_mass_move_id;
3166: --
3167: else
3168: --
3169: hr_utility.set_location(l_proc, 290);
3170: --
3171: update per_mass_moves
3172: set batch_run_number = l_batch_run_number,
3173: status = 'CO'
3202: raise hr_api.validate_enabled;
3203: --
3204: end if;
3205: --
3206: hr_utility.set_location(' Leaving:'||l_proc, 997);
3207: --
3208: exception
3209: --
3210: when hr_api.validate_enabled then
3208: exception
3209: --
3210: when hr_api.validate_enabled then
3211: --
3212: hr_utility.set_location(' Leaving:'||l_proc, 998);
3213: --
3214: -- As the Validate_Enabled exception has been raised
3215: -- we must rollback to the savepoint
3216: --
3217: ROLLBACK TO activate_mass_move;
3218: --
3219: when others then
3220: --
3221: hr_utility.set_location(' Leaving:'||l_proc, 999);
3222: --
3223: rollback to massmove;
3224: --
3225: hr_batch_message_line_api.create_message_line