DBA Data[Home] [Help]

APPS.PER_ASSIGNMENTS_F_PKG dependencies on FND_MESSAGE

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

452: open ac1;
453: fetch ac1 into l_legislation_code;
454: if ac1%notfound then
455: close ac1;
456: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
457: fnd_message.set_token('PROCEDURE',
458: 'PER_ASSIGNMENTS_F1_PKG.INSERT_ROW');
459: fnd_message.set_token('STEP', '0');
460: fnd_message.raise_error;

Line 457: fnd_message.set_token('PROCEDURE',

453: fetch ac1 into l_legislation_code;
454: if ac1%notfound then
455: close ac1;
456: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
457: fnd_message.set_token('PROCEDURE',
458: 'PER_ASSIGNMENTS_F1_PKG.INSERT_ROW');
459: fnd_message.set_token('STEP', '0');
460: fnd_message.raise_error;
461: end if;

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

455: close ac1;
456: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
457: fnd_message.set_token('PROCEDURE',
458: 'PER_ASSIGNMENTS_F1_PKG.INSERT_ROW');
459: fnd_message.set_token('STEP', '0');
460: fnd_message.raise_error;
461: end if;
462: close ac1;
463: hr_utility.set_location( l_proc, 60);

Line 460: fnd_message.raise_error;

456: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
457: fnd_message.set_token('PROCEDURE',
458: 'PER_ASSIGNMENTS_F1_PKG.INSERT_ROW');
459: fnd_message.set_token('STEP', '0');
460: fnd_message.raise_error;
461: end if;
462: close ac1;
463: hr_utility.set_location( l_proc, 60);
464:

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

770: fetch ASS_CUR into ASS_REC;
771: --
772: if ASS_CUR%notfound then
773: close ASS_CUR;
774: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
775: fnd_message.set_token('PROCEDURE',
776: 'PER_ASSIGNMENTS_F_PKG.LOCK_ROW');
777: fnd_message.set_token('STEP', '1');
778: fnd_message.raise_error;

Line 775: fnd_message.set_token('PROCEDURE',

771: --
772: if ASS_CUR%notfound then
773: close ASS_CUR;
774: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
775: fnd_message.set_token('PROCEDURE',
776: 'PER_ASSIGNMENTS_F_PKG.LOCK_ROW');
777: fnd_message.set_token('STEP', '1');
778: fnd_message.raise_error;
779: end if;

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

773: close ASS_CUR;
774: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
775: fnd_message.set_token('PROCEDURE',
776: 'PER_ASSIGNMENTS_F_PKG.LOCK_ROW');
777: fnd_message.set_token('STEP', '1');
778: fnd_message.raise_error;
779: end if;
780: close ASS_CUR;
781: --

Line 778: fnd_message.raise_error;

774: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
775: fnd_message.set_token('PROCEDURE',
776: 'PER_ASSIGNMENTS_F_PKG.LOCK_ROW');
777: fnd_message.set_token('STEP', '1');
778: fnd_message.raise_error;
779: end if;
780: close ASS_CUR;
781: --
782: ass_rec.assignment_type := rtrim(ass_rec.assignment_type);

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

1151: return; -- Row successfully locked, no changes
1152: end if;
1153: end if;
1154: --
1155: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1156: app_exception.raise_exception;
1157: --
1158: end lock_row;
1159: -----------------------------------------------------------------------------

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

1440: fetch ASS_CUR into ass_rec;
1441: --
1442: if ASS_CUR%notfound then
1443: close ASS_CUR;
1444: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1445: fnd_message.set_token('PROCEDURE','PER_ASSIGNMENTS_F_PKG.LOCK_ROW');
1446: fnd_message.set_token('STEP', '1');
1447: fnd_message.raise_error;
1448: end if;

Line 1445: fnd_message.set_token('PROCEDURE','PER_ASSIGNMENTS_F_PKG.LOCK_ROW');

1441: --
1442: if ASS_CUR%notfound then
1443: close ASS_CUR;
1444: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1445: fnd_message.set_token('PROCEDURE','PER_ASSIGNMENTS_F_PKG.LOCK_ROW');
1446: fnd_message.set_token('STEP', '1');
1447: fnd_message.raise_error;
1448: end if;
1449: --

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

1442: if ASS_CUR%notfound then
1443: close ASS_CUR;
1444: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1445: fnd_message.set_token('PROCEDURE','PER_ASSIGNMENTS_F_PKG.LOCK_ROW');
1446: fnd_message.set_token('STEP', '1');
1447: fnd_message.raise_error;
1448: end if;
1449: --
1450: close ASS_CUR;

Line 1447: fnd_message.raise_error;

1443: close ASS_CUR;
1444: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1445: fnd_message.set_token('PROCEDURE','PER_ASSIGNMENTS_F_PKG.LOCK_ROW');
1446: fnd_message.set_token('STEP', '1');
1447: fnd_message.raise_error;
1448: end if;
1449: --
1450: close ASS_CUR;
1451:

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

1464: fetch csr_chk_loc_change into l_loc_id;
1465:
1466: if csr_chk_loc_change%NOTFOUND then
1467: close csr_chk_loc_change;
1468: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1469: fnd_message.set_token('PROCEDURE',
1470: 'per_assignments_f_pkg.update_row');
1471: fnd_message.set_token('STEP','1');
1472: fnd_message.raise_error;

Line 1469: fnd_message.set_token('PROCEDURE',

1465:
1466: if csr_chk_loc_change%NOTFOUND then
1467: close csr_chk_loc_change;
1468: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1469: fnd_message.set_token('PROCEDURE',
1470: 'per_assignments_f_pkg.update_row');
1471: fnd_message.set_token('STEP','1');
1472: fnd_message.raise_error;
1473: else

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

1467: close csr_chk_loc_change;
1468: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1469: fnd_message.set_token('PROCEDURE',
1470: 'per_assignments_f_pkg.update_row');
1471: fnd_message.set_token('STEP','1');
1472: fnd_message.raise_error;
1473: else
1474: if l_loc_id <> p_location_id then
1475: l_location_id_changed := 1;

Line 1472: fnd_message.raise_error;

1468: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1469: fnd_message.set_token('PROCEDURE',
1470: 'per_assignments_f_pkg.update_row');
1471: fnd_message.set_token('STEP','1');
1472: fnd_message.raise_error;
1473: else
1474: if l_loc_id <> p_location_id then
1475: l_location_id_changed := 1;
1476: close csr_chk_loc_change;

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

1489: hr_utility.set_location('per_assignments_f_pkg.update_row',10);
1490: fetch c_pay_proposals into l_change_date;
1491: if c_pay_proposals%FOUND then
1492: if l_change_date < p_session_date then
1493: fnd_message.set_name('PER','HR_289767_SALARY_BASIS_IS_NULL');
1494: fnd_message.raise_error;
1495: end if;
1496: hr_utility.set_location('per_assignments_f_pkg.update_row',20);
1497: end if;

Line 1494: fnd_message.raise_error;

1490: fetch c_pay_proposals into l_change_date;
1491: if c_pay_proposals%FOUND then
1492: if l_change_date < p_session_date then
1493: fnd_message.set_name('PER','HR_289767_SALARY_BASIS_IS_NULL');
1494: fnd_message.raise_error;
1495: end if;
1496: hr_utility.set_location('per_assignments_f_pkg.update_row',20);
1497: end if;
1498: hr_utility.set_location('per_assignments_f_pkg.update_row',30);

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

1508: fetch perav1 into l_organization_id, l_legislation_code,
1509: l_location_id;
1510: if perav1%notfound then
1511: close perav1;
1512: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1513: fnd_message.set_token('PROCEDURE',
1514: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_ROW');
1515: fnd_message.set_token('STEP', '1');
1516: fnd_message.raise_error;

Line 1513: fnd_message.set_token('PROCEDURE',

1509: l_location_id;
1510: if perav1%notfound then
1511: close perav1;
1512: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1513: fnd_message.set_token('PROCEDURE',
1514: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_ROW');
1515: fnd_message.set_token('STEP', '1');
1516: fnd_message.raise_error;
1517: end if;

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

1511: close perav1;
1512: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1513: fnd_message.set_token('PROCEDURE',
1514: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_ROW');
1515: fnd_message.set_token('STEP', '1');
1516: fnd_message.raise_error;
1517: end if;
1518: close perav1;
1519:

Line 1516: fnd_message.raise_error;

1512: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1513: fnd_message.set_token('PROCEDURE',
1514: 'PER_ASSIGNMENTS_F1_PKG.UPDATE_ROW');
1515: fnd_message.set_token('STEP', '1');
1516: fnd_message.raise_error;
1517: end if;
1518: close perav1;
1519:
1520: -- start code for bug 6961562