[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
1694: -- valid grades will be inserted into per valid grades.
1695: --
1696: for csr_vgr_rec in csr_vgr loop
1697: --
1698: hr_utility.set_location(l_proc, 100);
1699: --
1700: hr_valid_grade_api.create_valid_grade
1701: (p_grade_id => csr_vgr_rec.target_grade_id
1702: ,p_date_from => p_date_effective
1730: --
1731: -- If deactivate_old_position is true then close down the 'old'
1732: -- position
1733: --
1734: hr_utility.set_location(l_proc, 110);
1735: --
1736: -- If the old position is to be deactivated then
1737: -- determine the availability status
1738: --
1737: -- determine the availability status
1738: --
1739: if p_deactivate_old_position then
1740: --
1741: hr_utility.set_location(l_proc, 120);
1742: --
1743: l_date_end := p_date_effective - 1;
1744: --
1745: -- Added as part of fix for bug 2943725
1750: open csr_current_status;
1751: fetch csr_current_status into l_current_system_type_cd;
1752: close csr_current_status;
1753: --
1754: hr_utility.set_location(l_proc||'/'||l_current_system_type_cd, 130);
1755: hr_utility.set_location(l_proc||'/'||p_position_id, 131);
1756: hr_utility.set_location(l_proc||'/'||p_date_effective, 132);
1757: --
1758: -- If the status is Active then change the status to Eliminated
1751: fetch csr_current_status into l_current_system_type_cd;
1752: close csr_current_status;
1753: --
1754: hr_utility.set_location(l_proc||'/'||l_current_system_type_cd, 130);
1755: hr_utility.set_location(l_proc||'/'||p_position_id, 131);
1756: hr_utility.set_location(l_proc||'/'||p_date_effective, 132);
1757: --
1758: -- If the status is Active then change the status to Eliminated
1759: --
1752: close csr_current_status;
1753: --
1754: hr_utility.set_location(l_proc||'/'||l_current_system_type_cd, 130);
1755: hr_utility.set_location(l_proc||'/'||p_position_id, 131);
1756: hr_utility.set_location(l_proc||'/'||p_date_effective, 132);
1757: --
1758: -- If the status is Active then change the status to Eliminated
1759: --
1760: if l_current_system_type_cd = 'ACTIVE' then
1758: -- If the status is Active then change the status to Eliminated
1759: --
1760: if l_current_system_type_cd = 'ACTIVE' then
1761: --
1762: hr_utility.set_location(l_proc, 140);
1763: --
1764: l_system_type_cd := 'ELIMINATED';
1765: --
1766: -- Else if the status is Proposed then the status will
1767: -- become Deleted.
1768: --
1769: elsif l_current_system_type_cd = 'PROPOSED' then
1770: --
1771: hr_utility.set_location(l_proc, 150);
1772: --
1773: l_system_type_cd := 'DELETED';
1774: --
1775: end if;
1779: open csr_avail_status(p_system_type_cd => l_system_type_cd);
1780: fetch csr_avail_status into p_availability_status_id;
1781: close csr_avail_status;
1782: --
1783: hr_utility.set_location(l_proc||'/'||l_system_type_cd, 160);
1784: --
1785: -- End of fix for bug 2943725
1786: --
1787: l_pos_dt_mode := 'UPDATE';
1813: ,p_valid_grades_changed_warning => l_valid_grades_changed_warning
1814: );
1815: */
1816: --
1817: hr_utility.set_location(l_proc, 170);
1818: --
1819: end if;
1820: --
1821: -- This is customer specific processing
1851: p_pos_pending_close_warning := l_pos_pending_close_warning;
1852: p_pos_jbe_not_moved_warning := l_pos_jbe_not_moved_warning;
1853: p_pos_vac_not_moved_warning := l_pos_vac_not_moved_warning;
1854: --
1855: hr_utility.set_location(' Leaving:'||l_proc, 997);
1856: --
1857: exception
1858: --
1859: when hr_api.validate_enabled then
1878: p_pos_pending_close_warning := l_pos_pending_close_warning;
1879: p_pos_jbe_not_moved_warning := l_pos_jbe_not_moved_warning;
1880: p_pos_vac_not_moved_warning := l_pos_vac_not_moved_warning;
1881: --
1882: hr_utility.set_location(' Leaving:'||l_proc, 998);
1883: --
1884: when others then
1885: --
1886: hr_utility.set_location(' Leaving:'||l_proc, 999);
1882: hr_utility.set_location(' Leaving:'||l_proc, 998);
1883: --
1884: when others then
1885: --
1886: hr_utility.set_location(' Leaving:'||l_proc, 999);
1887: --
1888: -- if it is an business rule violation error then only rollback
1889: -- this positon record.
1890: --
2050: and select_assignment = 'Y';
2051: --
2052: begin
2053: --
2054: hr_utility.set_location('Entering:'|| l_proc, 10);
2055: --
2056: -- Issue a savepoint
2057: --
2058: savepoint move_assignment;
2063: begin
2064: --
2065: savepoint move_asg;
2066: --
2067: hr_utility.set_location(l_proc||'/'||mmasgrec.assignment_id, 20);
2068: --
2069: -- GRE/Legal Entity will only move for US legislation.
2070: --
2071: if p_legislation_code = 'US' then
2079: end if;
2080: --
2081: if mmasgrec.default_from = 'B' then
2082: --
2083: hr_utility.set_location(l_proc, 30);
2084: --
2085: l_location_id := p_bg_location_id;
2086: l_frequency := p_bg_frequency;
2087: l_normal_hours := p_bg_normal_hours;
2089: l_time_normal_start := p_bg_time_normal_start;
2090: --
2091: elsif mmasgrec.default_from = 'O' then
2092: --
2093: hr_utility.set_location(l_proc, 40);
2094: --
2095: l_location_id := p_org_location_id;
2096: l_frequency := p_org_frequency;
2097: l_normal_hours := p_org_normal_hours;
2099: l_time_normal_start := p_org_time_normal_start;
2100: --
2101: elsif mmasgrec.default_from = 'P' then
2102: --
2103: hr_utility.set_location(l_proc, 50);
2104: --
2105: l_location_id := p_pos_location_id;
2106: l_frequency := p_pos_frequency;
2107: l_normal_hours := p_pos_normal_hours;
2109: l_time_normal_start := p_pos_time_normal_start;
2110: --
2111: elsif mmasgrec.default_from = 'A' then
2112: --
2113: hr_utility.set_location(l_proc, 60);
2114: --
2115: l_location_id := mmasgrec.location_id;
2116: l_frequency := mmasgrec.frequency;
2117: l_normal_hours := mmasgrec.normal_hours;
2121: end if;
2122: --
2123: if mmasgrec.vacancy_id is not null then
2124: --
2125: hr_utility.set_location(l_proc, 70);
2126: --
2127: raise asg_vacancy_warning;
2128: --
2129: end if;
2134: l_mm_assignment_id := mmasgrec.assignment_id;
2135: --
2136: if csr_future_asg_changes%found then
2137: --
2138: hr_utility.set_location(l_proc, 80);
2139: close csr_future_asg_changes;
2140: raise future_asg_warning;
2141: --
2142: end if;
2144: close csr_future_asg_changes;
2145: --
2146: if mmasgrec.assignment_type = 'A' then
2147: --
2148: hr_utility.set_location(l_proc, 90);
2149: --
2150: hr_assignment_api.update_apl_asg
2151: (p_validate => FALSE
2152: ,p_effective_date => p_effective_date
2178: -- Assignment is for a Contingent Worker
2179: --
2180: elsif mmasgrec.assignment_type = 'C' then
2181: --
2182: hr_utility.set_location(l_proc, 95);
2183: --
2184: hr_mass_move_api.move_cwk_asg
2185: (p_validate => p_validate
2186: ,p_effective_date => p_effective_date
2203: ,p_tax_district_changed_warning => l_tax_district_changed_warning);
2204: --
2205: else -- assignment_type = 'E'
2206: --
2207: hr_utility.set_location(l_proc, 100);
2208: --
2209: hr_mass_move_api.move_emp_asg
2210: (p_validate => FALSE
2211: ,p_mass_move_id => p_mass_move_id
2234: end if; /* if assignment type = 'E' */
2235: --
2236: if l_spp_delete_warning then
2237: --
2238: hr_utility.set_message(800,'HR_289826_SPP_DELETE_WARN_API');
2239: --
2240: hr_batch_message_line_api.create_message_line
2241: (p_validate => FALSE
2242: ,p_batch_run_number => p_batch_run_number
2242: ,p_batch_run_number => p_batch_run_number
2243: ,p_api_name => 'hr_mass_move_api.move_emp_asg'
2244: ,p_status => 'S'
2245: ,p_error_number => '289286'
2246: ,p_error_message => hr_utility.get_message
2247: ,p_extended_error_message => fnd_message.get
2248: ,p_source_row_information => mmasgrec.full_name
2249: ,p_line_id => l_dummy_line_id);
2250: --
2251: end if;
2252: --
2253: if l_org_now_no_manager_warning then
2254: --
2255: hr_utility.set_message(801,'HR_51124_MMV_NO_MGR_EXIST_ORG');
2256: --
2257: hr_batch_message_line_api.create_message_line
2258: (p_validate => FALSE
2259: ,p_batch_run_number => p_batch_run_number
2259: ,p_batch_run_number => p_batch_run_number
2260: ,p_api_name => 'hr_mass_move_api.move_emp_asg'
2261: ,p_status => 'S'
2262: ,p_error_number => '51124'
2263: ,p_error_message => hr_utility.get_message
2264: ,p_extended_error_message => fnd_message.get
2265: ,p_source_row_information => mmasgrec.full_name
2266: ,p_line_id => l_dummy_line_id);
2267: --
2268: end if;
2269: --
2270: if l_other_manager_warning then
2271: --
2272: hr_utility.set_message(801,'HR_51125_MMV_MRE_MGR_EXIST_ORG');
2273: --
2274: hr_batch_message_line_api.create_message_line
2275: (p_validate => FALSE
2276: ,p_batch_run_number => p_batch_run_number
2276: ,p_batch_run_number => p_batch_run_number
2277: ,p_api_name => 'hr_mass_move_api.move_emp_asg'
2278: ,p_status => 'S'
2279: ,p_error_number => '51125'
2280: ,p_error_message => hr_utility.get_message
2281: ,p_extended_error_message => fnd_message.get
2282: ,p_source_row_information => mmasgrec.full_name
2283: ,p_line_id => l_dummy_line_id);
2284: --
2285: end if;
2286: --
2287: if l_entries_changed_warning = 'S' then
2288: --
2289: hr_utility.set_message(801,'HR_51126_MMV_SAL_ENT_ALTERED');
2290: --
2291: hr_batch_message_line_api.create_message_line
2292: (p_validate => FALSE
2293: ,p_batch_run_number => p_batch_run_number
2293: ,p_batch_run_number => p_batch_run_number
2294: ,p_api_name => 'hr_mass_move_api.move_emp_asg'
2295: ,p_status => 'S'
2296: ,p_error_number => '51126'
2297: ,p_error_message => hr_utility.get_message
2298: ,p_extended_error_message => fnd_message.get
2299: ,p_source_row_information => mmasgrec.full_name
2300: ,p_line_id => l_dummy_line_id);
2301: --
2302: end if;
2303: --
2304: if l_entries_changed_warning = 'Y' then
2305: --
2306: hr_utility.set_message(801,'HR_51127_MMV_NON_SAL_ENT_ALR');
2307: --
2308: hr_batch_message_line_api.create_message_line
2309: (p_validate => FALSE
2310: ,p_batch_run_number => p_batch_run_number
2310: ,p_batch_run_number => p_batch_run_number
2311: ,p_api_name => 'hr_mass_move_api.move_emp_asg'
2312: ,p_status => 'S'
2313: ,p_error_number => '51127'
2314: ,p_error_message => hr_utility.get_message
2315: ,p_extended_error_message => fnd_message.get
2316: ,p_source_row_information => mmasgrec.full_name
2317: ,p_line_id => l_dummy_line_id);
2318: --
2317: ,p_line_id => l_dummy_line_id);
2318: --
2319: end if;
2320: --
2321: hr_utility.set_location(l_proc, 110);
2322: --
2323: --
2324: -- if it has made it this far, the applicant/employee assignment was moved
2325: --
2332: when asg_vacancy_warning then
2333: --
2334: rollback to move_asg;
2335: --
2336: hr_utility.set_message(801,'HR_51129_MMV_ASG_NOT_MOVED');
2337: --
2338: hr_batch_message_line_api.create_message_line
2339: (p_validate => FALSE
2340: ,p_batch_run_number => p_batch_run_number
2340: ,p_batch_run_number => p_batch_run_number
2341: ,p_api_name => 'hr_mass_move_api.move_assignment'
2342: ,p_status => 'S'
2343: ,p_error_number => '51129'
2344: ,p_error_message => hr_utility.get_message
2345: ,p_extended_error_message => fnd_message.get
2346: ,p_source_row_information => mmasgrec.full_name
2347: ,p_line_id => l_dummy_line_id);
2348: --
2349: when future_asg_warning then
2350: --
2351: rollback to move_asg;
2352: --
2353: hr_utility.set_message(801,'HR_51103_MMV_ASG_FUTURE_CHG');
2354: --
2355: hr_batch_message_line_api.create_message_line
2356: (p_validate => FALSE
2357: ,p_batch_run_number => p_batch_run_number
2357: ,p_batch_run_number => p_batch_run_number
2358: ,p_api_name => 'hr_mass_move_api.move_assignment'
2359: ,p_status => 'S'
2360: ,p_error_number => '51103'
2361: ,p_error_message => hr_utility.get_message
2362: ,p_extended_error_message => fnd_message.get
2363: ,p_source_row_information => mmasgrec.full_name
2364: ,p_line_id => l_dummy_line_id);
2365: --
2364: ,p_line_id => l_dummy_line_id);
2365: --
2366: when others then
2367: --
2368: hr_utility.set_location(l_proc, 120);
2369: --
2370: if sqlcode = -20001 then
2371: --
2372: rollback to move_asg;
2395: if p_validate then
2396: raise hr_api.validate_enabled;
2397: end if;
2398: --
2399: hr_utility.set_location(' Leaving:'||l_proc, 997);
2400: --
2401: exception
2402: --
2403: when hr_api.validate_enabled then
2406: -- we must rollback to the savepoint
2407: --
2408: ROLLBACK TO move_assignment;
2409: --
2410: hr_utility.set_location(' Leaving:'||l_proc, 998);
2411: --
2412: when others then
2413: --
2414: -- A validation or unexpected error has occurred
2416: -- Added as part of the fix to bug 632479
2417: --
2418: ROLLBACK TO move_assignment;
2419: --
2420: hr_utility.set_location(' Leaving:'||l_proc, 999);
2421: --
2422: raise;
2423: --
2424: end move_assignments;
2661: and status = 'S';
2662: --
2663: begin
2664: --
2665: hr_utility.set_location('Entering:'|| l_proc, 10);
2666: --
2667: -- Issue a savepoint.
2668: --
2669: savepoint activate_mass_move;
2679: -- and is valid.
2680: --
2681: if p_mass_move_id is not null then
2682: --
2683: hr_utility.set_location(l_proc, 20);
2684: --
2685: open csr_get_mass_move_info;
2686: fetch csr_get_mass_move_info into l_new_organization_id,
2687: l_effective_date;
2689: if csr_get_mass_move_info%notfound then
2690: --
2691: close csr_get_mass_move_info;
2692: --
2693: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
2694: hr_utility.raise_error;
2695: --
2696: end if;
2697: --
2690: --
2691: close csr_get_mass_move_info;
2692: --
2693: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
2694: hr_utility.raise_error;
2695: --
2696: end if;
2697: --
2698: close csr_get_mass_move_info;
2698: close csr_get_mass_move_info;
2699: --
2700: else
2701: --
2702: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
2703: hr_utility.raise_error;
2704: --
2705: end if;
2706: --
2699: --
2700: else
2701: --
2702: hr_utility.set_message(801, 'HR_7207_API_MANDATORY_ARG');
2703: hr_utility.raise_error;
2704: --
2705: end if;
2706: --
2707: -- Issue a savepoint
2720: close csr_lock_per_mm_valid_grades;
2721: open csr_lock_per_mm_job_reqts;
2722: close csr_lock_per_mm_job_reqts;
2723: --
2724: hr_utility.set_location(l_proc, 30);
2725: --
2726: -- Get default location and working conditions from the new
2727: -- organization
2728: --
2736: l_org_location_id;
2737: --
2738: close csr_get_org_defaults;
2739: --
2740: hr_utility.set_location(l_proc, 40);
2741: --
2742: -- Get default location and working conditions from the
2743: -- business group
2744: --
2752: l_bg_location_id;
2753: --
2754: close csr_get_busgrp_defaults;
2755: --
2756: hr_utility.set_location(l_proc, 50);
2757: --
2758: begin
2759: --
2760: -- Start of API User Hook for the before hook of mass_move
2780: --
2781: hr_mass_move_cus.pre_mass_move
2782: (p_mass_move_id => p_mass_move_id);
2783: --
2784: hr_utility.set_location(l_proc, 60);
2785: --
2786: -- Loop through the position records in per_mm_positions, and
2787: -- process the position, applicant assignments, and employee
2788: -- assignment records.
2795: --
2796: l_position_name := mmposrec.name;
2797: l_position_id := mmposrec.position_id;
2798: --
2799: hr_utility.set_location(l_proc||'/'||
2800: l_position_name||'/'||
2801: l_position_id, 70);
2802: --
2803: if mmposrec.deactivate_old_position = 'Y' then
2809: l_deactivate_boolean := FALSE;
2810: --
2811: end if;
2812: --
2813: hr_utility.set_location(l_proc, 80);
2814: --
2815: -- Get default location and working conditions from the
2816: -- old position business group
2817: --
2824: l_old_pos_location_id;
2825: --
2826: close csr_get_old_pos_defaults;
2827: --
2828: hr_utility.set_location(l_proc, 90);
2829: --
2830: if mmposrec.default_from = 'B' then
2831: --
2832: hr_utility.set_location(l_proc, 100);
2828: hr_utility.set_location(l_proc, 90);
2829: --
2830: if mmposrec.default_from = 'B' then
2831: --
2832: hr_utility.set_location(l_proc, 100);
2833: --
2834: l_location_id := l_bg_location_id;
2835: l_frequency := l_bg_frequency;
2836: l_normal_hours := l_bg_normal_hours;
2838: l_time_normal_start := l_bg_time_normal_start;
2839: --
2840: elsif mmposrec.default_from = 'O' then
2841: --
2842: hr_utility.set_location(l_proc, 110);
2843: --
2844: l_location_id := l_org_location_id;
2845: l_frequency := l_org_frequency;
2846: l_normal_hours := l_org_normal_hours;
2848: l_time_normal_start := l_org_time_normal_start;
2849: --
2850: elsif mmposrec.default_from = 'P' then
2851: --
2852: hr_utility.set_location(l_proc, 120);
2853: --
2854: l_location_id := l_old_pos_location_id;
2855: l_frequency := l_old_pos_frequency;
2856: l_normal_hours := l_old_pos_normal_hours;
2862: -- Call the move position process to create the new position
2863: --
2864: if mmposrec.position_moved = 'N' then
2865: --
2866: hr_utility.set_location(l_proc, 130);
2867: --
2868: hr_mass_move_api.move_position
2869: (p_validate => FALSE
2870: ,p_batch_run_number => l_batch_run_number
2920: ,p_pos_jbe_not_moved_warning => l_pos_jbe_not_moved_warning --out
2921: ,p_pos_vac_not_moved_warning => l_pos_vac_not_moved_warning --out
2922: );
2923: --
2924: hr_utility.set_location(l_proc, 140);
2925: --
2926: if (l_new_position_id is not null) then
2927: --
2928: -- If it made it this far, update the position to 'moved'
2935: and mass_move_id = p_mass_move_id;
2936: --
2937: end if;
2938: --
2939: hr_utility.set_location(l_proc, 150);
2940: --
2941: -- in the case of a reexecution, set the vals from the table.
2942: --
2943: else
2941: -- in the case of a reexecution, set the vals from the table.
2942: --
2943: else
2944: --
2945: hr_utility.set_location(l_proc, 160);
2946: --
2947: l_new_position_id := mmposrec.new_position_id;
2948: l_new_job_id := mmposrec.target_job_id;
2949: --
2961: l_new_pos_location_id;
2962: --
2963: close csr_get_new_pos_defaults;
2964: --
2965: hr_utility.set_location(l_proc, 170);
2966: --
2967: move_assignments
2968: (p_mass_move_id => p_mass_move_id
2969: ,p_old_position_id => mmposrec.position_id
2988: ,p_bg_frequency => l_bg_frequency
2989: ,p_bg_location_id => l_bg_location_id
2990: ,p_batch_run_number => l_batch_run_number);
2991: --
2992: hr_utility.set_location(l_proc, 180);
2993: --
2994: -- Check for position warning messages
2995: --
2996: if l_pos_exists_warning = TRUE then
2994: -- Check for position warning messages
2995: --
2996: if l_pos_exists_warning = TRUE then
2997: --
2998: hr_utility.set_location(l_proc, 190);
2999: --
3000: ROLLBACK TO move_position;
3001: --
3002: hr_utility.set_message(801,'HR_51330_MMV_POS_EXISTS');
2998: hr_utility.set_location(l_proc, 190);
2999: --
3000: ROLLBACK TO move_position;
3001: --
3002: hr_utility.set_message(801,'HR_51330_MMV_POS_EXISTS');
3003: --
3004: hr_batch_message_line_api.create_message_line
3005: (p_validate => FALSE
3006: ,p_batch_run_number => l_batch_run_number
3006: ,p_batch_run_number => l_batch_run_number
3007: ,p_api_name => 'hr_mass_move_api.move_position'
3008: ,p_status => 'S'
3009: ,p_error_number => '51130'
3010: ,p_error_message => hr_utility.get_message
3011: ,p_extended_error_message => fnd_message.get
3012: ,p_source_row_information => l_position_name
3013: ,p_line_id => l_dummy_line_id);
3014: --
3015: end if;
3016: --
3017: if l_pos_date_range_warning = TRUE then
3018: --
3019: hr_utility.set_location(l_proc, 200);
3020: --
3021: ROLLBACK TO move_position;
3022: --
3023: hr_utility.set_message(801,'HR_51331_MMV_POS_INVALID_DATE');
3019: hr_utility.set_location(l_proc, 200);
3020: --
3021: ROLLBACK TO move_position;
3022: --
3023: hr_utility.set_message(801,'HR_51331_MMV_POS_INVALID_DATE');
3024: --
3025: hr_batch_message_line_api.create_message_line
3026: (p_validate => FALSE
3027: ,p_batch_run_number => l_batch_run_number
3027: ,p_batch_run_number => l_batch_run_number
3028: ,p_api_name => 'hr_mass_move_api.move_position'
3029: ,p_status => 'S'
3030: ,p_error_number => '51331'
3031: ,p_error_message => hr_utility.get_message
3032: ,p_extended_error_message => fnd_message.get
3033: ,p_source_row_information => l_position_name
3034: ,p_line_id => l_dummy_line_id);
3035: --
3036: end if;
3037: --
3038: if l_pos_pending_close_warning = TRUE then
3039: --
3040: hr_utility.set_location(l_proc, 210);
3041: --
3042: hr_utility.set_message(801,'HR_51335_MMV_POS_CLOSED');
3043: --
3044: hr_batch_message_line_api.create_message_line
3038: if l_pos_pending_close_warning = TRUE then
3039: --
3040: hr_utility.set_location(l_proc, 210);
3041: --
3042: hr_utility.set_message(801,'HR_51335_MMV_POS_CLOSED');
3043: --
3044: hr_batch_message_line_api.create_message_line
3045: (p_validate => FALSE
3046: ,p_batch_run_number => l_batch_run_number
3046: ,p_batch_run_number => l_batch_run_number
3047: ,p_api_name => 'hr_mass_move_api.move_position'
3048: ,p_status => 'S'
3049: ,p_error_number => '51335'
3050: ,p_error_message => hr_utility.get_message
3051: ,p_extended_error_message => fnd_message.get
3052: ,p_source_row_information => l_position_name
3053: ,p_line_id => l_dummy_line_id);
3054: --
3055: end if;
3056: --
3057: if l_valid_grades_changed_warning = TRUE then
3058: --
3059: hr_utility.set_location(l_proc, 220);
3060: --
3061: hr_utility.set_message(801,'HR_51128_MMV_VGR_ALTERED');
3062: --
3063: hr_batch_message_line_api.create_message_line
3057: if l_valid_grades_changed_warning = TRUE then
3058: --
3059: hr_utility.set_location(l_proc, 220);
3060: --
3061: hr_utility.set_message(801,'HR_51128_MMV_VGR_ALTERED');
3062: --
3063: hr_batch_message_line_api.create_message_line
3064: (p_validate => FALSE
3065: ,p_batch_run_number => l_batch_run_number
3065: ,p_batch_run_number => l_batch_run_number
3066: ,p_api_name => 'hr_mass_move_api.move_position'
3067: ,p_status => 'S'
3068: ,p_error_number => '51128'
3069: ,p_error_message => hr_utility.get_message
3070: ,p_extended_error_message => fnd_message.get
3071: ,p_source_row_information => l_position_name
3072: ,p_line_id => l_dummy_line_id);
3073: --
3074: end if;
3075: --
3076: if l_pos_jbe_not_moved_warning = TRUE then
3077: --
3078: hr_utility.set_location(l_proc, 230);
3079: --
3080: hr_utility.set_message(801,'HR_51334_MMV_POS_JBE_NOT_MOVED');
3081: --
3082: hr_batch_message_line_api.create_message_line
3076: if l_pos_jbe_not_moved_warning = TRUE then
3077: --
3078: hr_utility.set_location(l_proc, 230);
3079: --
3080: hr_utility.set_message(801,'HR_51334_MMV_POS_JBE_NOT_MOVED');
3081: --
3082: hr_batch_message_line_api.create_message_line
3083: (p_validate => FALSE
3084: ,p_batch_run_number => l_batch_run_number
3084: ,p_batch_run_number => l_batch_run_number
3085: ,p_api_name => 'hr_mass_move_api.move_position'
3086: ,p_status => 'S'
3087: ,p_error_number => '51334'
3088: ,p_error_message => hr_utility.get_message
3089: ,p_extended_error_message => fnd_message.get
3090: ,p_source_row_information => l_position_name
3091: ,p_line_id => l_dummy_line_id);
3092: --
3093: end if;
3094: --
3095: if l_pos_vac_not_moved_warning = TRUE then
3096: --
3097: hr_utility.set_location(l_proc, 240);
3098: --
3099: hr_utility.set_message(801,'HR_51333_MMV_POS_VAC_NOT_MOVED');
3100: --
3101: hr_batch_message_line_api.create_message_line
3095: if l_pos_vac_not_moved_warning = TRUE then
3096: --
3097: hr_utility.set_location(l_proc, 240);
3098: --
3099: hr_utility.set_message(801,'HR_51333_MMV_POS_VAC_NOT_MOVED');
3100: --
3101: hr_batch_message_line_api.create_message_line
3102: (p_validate => FALSE
3103: ,p_batch_run_number => l_batch_run_number
3103: ,p_batch_run_number => l_batch_run_number
3104: ,p_api_name => 'hr_mass_move_api.move_position'
3105: ,p_status => 'S'
3106: ,p_error_number => '51333'
3107: ,p_error_message => hr_utility.get_message
3108: ,p_extended_error_message => fnd_message.get
3109: ,p_source_row_information => l_position_name
3110: ,p_line_id => l_dummy_line_id);
3111: --
3114: end; --begin
3115: --
3116: end loop; /* end loop through positions in per_mm_positions */
3117: --
3118: hr_utility.set_location(l_proc, 250);
3119: --
3120: -- Call Customer-Specific stub to handle post-mass move validation
3121: --
3122: hr_mass_move_cus.post_mass_move
3128: open csr_chk_errors;
3129: fetch csr_chk_errors into l_errors_exist;
3130: close csr_chk_errors;
3131: --
3132: hr_utility.set_location(l_proc, 260);
3133: --
3134: l_warnings_exist := 'N';
3135: open csr_chk_warnings;
3136: fetch csr_chk_warnings into l_warnings_exist;
3137: close csr_chk_warnings;
3138: --
3139: if l_errors_exist = 'Y' then
3140: --
3141: hr_utility.set_location(l_proc, 270);
3142: --
3143: rollback to massmove;
3144: --
3145: update per_mass_moves
3148: where mass_move_id = p_mass_move_id;
3149: --
3150: elsif l_warnings_exist = 'Y' then
3151: --
3152: hr_utility.set_location(l_proc, 280);
3153: --
3154: update per_mass_moves
3155: set batch_run_number = l_batch_run_number,
3156: status = 'WA'
3157: where mass_move_id = p_mass_move_id;
3158: --
3159: else
3160: --
3161: hr_utility.set_location(l_proc, 290);
3162: --
3163: update per_mass_moves
3164: set batch_run_number = l_batch_run_number,
3165: status = 'CO'
3194: raise hr_api.validate_enabled;
3195: --
3196: end if;
3197: --
3198: hr_utility.set_location(' Leaving:'||l_proc, 997);
3199: --
3200: exception
3201: --
3202: when hr_api.validate_enabled then
3200: exception
3201: --
3202: when hr_api.validate_enabled then
3203: --
3204: hr_utility.set_location(' Leaving:'||l_proc, 998);
3205: --
3206: -- As the Validate_Enabled exception has been raised
3207: -- we must rollback to the savepoint
3208: --
3209: ROLLBACK TO activate_mass_move;
3210: --
3211: when others then
3212: --
3213: hr_utility.set_location(' Leaving:'||l_proc, 999);
3214: --
3215: rollback to massmove;
3216: --
3217: hr_batch_message_line_api.create_message_line