DBA Data[Home] [Help]

APPS.PER_ASSIGNMENTS_F_PKG dependencies on FND_MESSAGE

Line 437: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 438: fnd_message.set_token('PROCEDURE',

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;

Line 440: fnd_message.set_token('STEP', '0');

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);

Line 441: fnd_message.raise_error;

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:

Line 693: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 694: fnd_message.set_token('PROCEDURE',

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;

Line 696: fnd_message.set_token('STEP', '1');

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: --

Line 697: fnd_message.raise_error;

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);

Line 1074: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

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: -----------------------------------------------------------------------------

Line 1300: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 1301: fnd_message.set_token('PROCEDURE',

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

Line 1303: fnd_message.set_token('STEP','1');

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;

Line 1304: fnd_message.raise_error;

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;

Line 1325: fnd_message.set_name('PER','HR_289767_SALARY_BASIS_IS_NULL');

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;

Line 1326: fnd_message.raise_error;

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);

Line 1344: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 1345: fnd_message.set_token('PROCEDURE',

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;

Line 1347: fnd_message.set_token('STEP', '1');

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:

Line 1348: fnd_message.raise_error;

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