433: open ac1;
434: fetch ac1 into l_legislation_code;
435: if ac1%notfound then
436: close ac1;
437: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
438: fnd_message.set_token('PROCEDURE',
439: 'PER_ASSIGNMENTS_F1_PKG.INSERT_ROW');
440: fnd_message.set_token('STEP', '0');
441: fnd_message.raise_error;
434: fetch ac1 into l_legislation_code;
435: if ac1%notfound then
436: close ac1;
437: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
438: fnd_message.set_token('PROCEDURE',
439: 'PER_ASSIGNMENTS_F1_PKG.INSERT_ROW');
440: fnd_message.set_token('STEP', '0');
441: fnd_message.raise_error;
442: end if;
436: close ac1;
437: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
438: fnd_message.set_token('PROCEDURE',
439: 'PER_ASSIGNMENTS_F1_PKG.INSERT_ROW');
440: fnd_message.set_token('STEP', '0');
441: fnd_message.raise_error;
442: end if;
443: close ac1;
444: hr_utility.set_location( l_proc, 60);
437: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
438: fnd_message.set_token('PROCEDURE',
439: 'PER_ASSIGNMENTS_F1_PKG.INSERT_ROW');
440: fnd_message.set_token('STEP', '0');
441: fnd_message.raise_error;
442: end if;
443: close ac1;
444: hr_utility.set_location( l_proc, 60);
445:
689: fetch ASS_CUR into ASS_REC;
690: --
691: if ASS_CUR%notfound then
692: close ASS_CUR;
693: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
694: fnd_message.set_token('PROCEDURE',
695: 'PER_ASSIGNMENTS_F_PKG.LOCK_ROW');
696: fnd_message.set_token('STEP', '1');
697: fnd_message.raise_error;
690: --
691: if ASS_CUR%notfound then
692: close ASS_CUR;
693: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
694: fnd_message.set_token('PROCEDURE',
695: 'PER_ASSIGNMENTS_F_PKG.LOCK_ROW');
696: fnd_message.set_token('STEP', '1');
697: fnd_message.raise_error;
698: end if;
692: close ASS_CUR;
693: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
694: fnd_message.set_token('PROCEDURE',
695: 'PER_ASSIGNMENTS_F_PKG.LOCK_ROW');
696: fnd_message.set_token('STEP', '1');
697: fnd_message.raise_error;
698: end if;
699: close ASS_CUR;
700: --
693: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
694: fnd_message.set_token('PROCEDURE',
695: 'PER_ASSIGNMENTS_F_PKG.LOCK_ROW');
696: fnd_message.set_token('STEP', '1');
697: fnd_message.raise_error;
698: end if;
699: close ASS_CUR;
700: --
701: ass_rec.assignment_type := rtrim(ass_rec.assignment_type);
1070: return; -- Row successfully locked, no changes
1071: end if;
1072: end if;
1073: --
1074: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1075: app_exception.raise_exception;
1076: --
1077: end lock_row;
1078: -----------------------------------------------------------------------------
1296: fetch csr_chk_loc_change into l_loc_id;
1297:
1298: if csr_chk_loc_change%NOTFOUND then
1299: close csr_chk_loc_change;
1300: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1301: fnd_message.set_token('PROCEDURE',
1302: 'per_assignments_f_pkg.update_row');
1303: fnd_message.set_token('STEP','1');
1304: fnd_message.raise_error;
1297:
1298: if csr_chk_loc_change%NOTFOUND then
1299: close csr_chk_loc_change;
1300: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1301: fnd_message.set_token('PROCEDURE',
1302: 'per_assignments_f_pkg.update_row');
1303: fnd_message.set_token('STEP','1');
1304: fnd_message.raise_error;
1305: else
1299: close csr_chk_loc_change;
1300: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1301: fnd_message.set_token('PROCEDURE',
1302: 'per_assignments_f_pkg.update_row');
1303: fnd_message.set_token('STEP','1');
1304: fnd_message.raise_error;
1305: else
1306: if l_loc_id <> p_location_id then
1307: l_location_id_changed := 1;
1300: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1301: fnd_message.set_token('PROCEDURE',
1302: 'per_assignments_f_pkg.update_row');
1303: fnd_message.set_token('STEP','1');
1304: fnd_message.raise_error;
1305: else
1306: if l_loc_id <> p_location_id then
1307: l_location_id_changed := 1;
1308: close csr_chk_loc_change;
1321: hr_utility.set_location('per_assignments_f_pkg.update_row',10);
1322: fetch c_pay_proposals into l_change_date;
1323: if c_pay_proposals%FOUND then
1324: if l_change_date < p_session_date then
1325: fnd_message.set_name('PER','HR_289767_SALARY_BASIS_IS_NULL');
1326: fnd_message.raise_error;
1327: end if;
1328: hr_utility.set_location('per_assignments_f_pkg.update_row',20);
1329: end if;
1322: fetch c_pay_proposals into l_change_date;
1323: if c_pay_proposals%FOUND then
1324: if l_change_date < p_session_date then
1325: fnd_message.set_name('PER','HR_289767_SALARY_BASIS_IS_NULL');
1326: fnd_message.raise_error;
1327: end if;
1328: hr_utility.set_location('per_assignments_f_pkg.update_row',20);
1329: end if;
1330: hr_utility.set_location('per_assignments_f_pkg.update_row',30);
1340: fetch perav1 into l_organization_id, l_legislation_code,
1341: l_location_id;
1342: if perav1%notfound then
1343: close perav1;
1344: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1345: fnd_message.set_token('PROCEDURE',
1346: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_ROW');
1347: fnd_message.set_token('STEP', '1');
1348: fnd_message.raise_error;
1341: l_location_id;
1342: if perav1%notfound then
1343: close perav1;
1344: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1345: fnd_message.set_token('PROCEDURE',
1346: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_ROW');
1347: fnd_message.set_token('STEP', '1');
1348: fnd_message.raise_error;
1349: end if;
1343: close perav1;
1344: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1345: fnd_message.set_token('PROCEDURE',
1346: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_ROW');
1347: fnd_message.set_token('STEP', '1');
1348: fnd_message.raise_error;
1349: end if;
1350: close perav1;
1351:
1344: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1345: fnd_message.set_token('PROCEDURE',
1346: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_ROW');
1347: fnd_message.set_token('STEP', '1');
1348: fnd_message.raise_error;
1349: end if;
1350: close perav1;
1351:
1352: -- start code for bug 6961562