DBA Data[Home] [Help]

APPS.PER_SPP_BUS dependencies on FND_MESSAGE

Line 115: fnd_message.set_name('PER', 'HR_289224_SPP_ASSIGNMENT_CHK');

111: fetch csr_valid_assignment_id into l_assignment_id;
112: if csr_valid_assignment_id%notfound then
113: --
114: close csr_valid_assignment_id;
115: fnd_message.set_name('PER', 'HR_289224_SPP_ASSIGNMENT_CHK');
116: hr_utility.raise_error;
117: --
118: else
119: close csr_valid_assignment_id;

Line 126: fnd_message.set_name('PER', 'HR_289225_SPP_PLACEMENT_EXIST');

122: fetch csr_placement_exists into l_placement_id;
123: if csr_placement_exists%found then
124: --
125: close csr_placement_exists;
126: fnd_message.set_name('PER', 'HR_289225_SPP_PLACEMENT_EXIST');
127: hr_utility.raise_error;
128: --
129: else
130: close csr_placement_exists;

Line 290: fnd_message.set_name('PER', 'HR_289276_SPP_CEILING_CHK');

286: -- --------------------------------------------------------------------------
287: -- compare the two ceiling step_id's to the passed step_id
288: -- --------------------------------------------------------------------------
289: if (l_step_number > max_ceiling_number) then
290: fnd_message.set_name('PER', 'HR_289276_SPP_CEILING_CHK');
291: hr_utility.raise_error;
292: end if;
293: --
294: hr_utility.set_location(' Leaving:'|| l_proc, 999);

Line 355: fnd_message.set_name('PER', 'HR_289266_SPP_INVAL_REASON');

351: ,p_lookup_code => p_reason) THEN
352: --
353: hr_utility.set_location(l_proc, 30);
354: --
355: fnd_message.set_name('PER', 'HR_289266_SPP_INVAL_REASON');
356: hr_utility.raise_error;
357: --
358: END IF;
359: --

Line 446: fnd_message.set_name('PER', 'HR_289256_SPP_OBJECT_VER_NUM');

442: fetch csr_valid_ovn into l_object_version_number;
443: if csr_valid_ovn%notfound then
444: --
445: close csr_valid_ovn;
446: fnd_message.set_name('PER', 'HR_289256_SPP_OBJECT_VER_NUM');
447: hr_utility.raise_error;
448: --
449: else
450: close csr_valid_ovn;

Line 541: fnd_message.set_name('PER', 'HR_289223_SPP_AUTO_INC_FLG_CHK');

537: If (p_auto_increment_flag not in ('Y','N') )
538: --
539: then
540: hr_utility.set_location(l_proc, 35);
541: fnd_message.set_name('PER', 'HR_289223_SPP_AUTO_INC_FLG_CHK');
542: hr_utility.raise_error;
543: --
544: hr_utility.set_location(l_proc, 22);
545: elsif (p_auto_increment_flag = 'Y') then

Line 549: fnd_message.set_name('PER', 'HR_289243_SPP_INCREMENT_NUMBER');

545: elsif (p_auto_increment_flag = 'Y') then
546: hr_utility.set_location(l_proc, 23);
547: if (NVL(p_increment_number,0) <= 0) then
548: hr_utility.set_location(l_proc, 36);
549: fnd_message.set_name('PER', 'HR_289243_SPP_INCREMENT_NUMBER');
550: hr_utility.raise_error;
551: end if;
552: hr_utility.set_location(l_proc, 40);
553: end if;

Line 832: fnd_message.set_name('PER', 'HR_289226_SPP_PARENT_SPINE');

828: open csr_valid_parent_spine;
829: fetch csr_valid_parent_spine into l_parent_spine_id;
830: if csr_valid_parent_spine%notfound then
831:
832: fnd_message.set_name('PER', 'HR_289226_SPP_PARENT_SPINE');
833:
834: else
835:
836: -- If parent spine is valid the step must be invalid

Line 838: fnd_message.set_name('PER', 'HR_289227_SPP_STEP_ID');

834: else
835:
836: -- If parent spine is valid the step must be invalid
837:
838: fnd_message.set_name('PER', 'HR_289227_SPP_STEP_ID');
839:
840: end if;
841:
842: close csr_valid_parent_spine;

Line 989: fnd_message.set_name (800,'PER_449912_FUT_GRD_CHG');

985: if g_debug then
986: hr_utility.set_location( l_proc ||'raise error', 60);
987: end if;
988:
989: fnd_message.set_name (800,'PER_449912_FUT_GRD_CHG');
990: fnd_message.raise_error;
991:
992: end if ;
993:

Line 990: fnd_message.raise_error;

986: hr_utility.set_location( l_proc ||'raise error', 60);
987: end if;
988:
989: fnd_message.set_name (800,'PER_449912_FUT_GRD_CHG');
990: fnd_message.raise_error;
991:
992: end if ;
993:
994: if c_future_grade_chg%isopen then

Line 1048: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

1044: close csr_sec_grp;
1045: --
1046: -- The primary key is invalid therefore we must error
1047: --
1048: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1049: fnd_message.raise_error;
1050: --
1051: end if;
1052: close csr_sec_grp;

Line 1049: fnd_message.raise_error;

1045: --
1046: -- The primary key is invalid therefore we must error
1047: --
1048: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1049: fnd_message.raise_error;
1050: --
1051: end if;
1052: close csr_sec_grp;
1053: --

Line 1121: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

1117: --
1118: -- The primary key is invalid therefore we must error
1119: --
1120: close csr_leg_code;
1121: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1122: fnd_message.raise_error;
1123: end if;
1124: hr_utility.set_location(l_proc,30);
1125: --

Line 1122: fnd_message.raise_error;

1118: -- The primary key is invalid therefore we must error
1119: --
1120: close csr_leg_code;
1121: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1122: fnd_message.raise_error;
1123: end if;
1124: hr_utility.set_location(l_proc,30);
1125: --
1126: -- Set the global variables so the values are

Line 1184: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

1180: (p_placement_id => p_rec.placement_id
1181: ,p_effective_date => p_effective_date
1182: ,p_object_version_number => p_rec.object_version_number
1183: ) THEN
1184: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1185: fnd_message.set_token('PROCEDURE ', l_proc);
1186: fnd_message.set_token('STEP ', '5');
1187: fnd_message.raise_error;
1188: END IF;

Line 1185: fnd_message.set_token('PROCEDURE ', l_proc);

1181: ,p_effective_date => p_effective_date
1182: ,p_object_version_number => p_rec.object_version_number
1183: ) THEN
1184: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1185: fnd_message.set_token('PROCEDURE ', l_proc);
1186: fnd_message.set_token('STEP ', '5');
1187: fnd_message.raise_error;
1188: END IF;
1189: --

Line 1186: fnd_message.set_token('STEP ', '5');

1182: ,p_object_version_number => p_rec.object_version_number
1183: ) THEN
1184: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1185: fnd_message.set_token('PROCEDURE ', l_proc);
1186: fnd_message.set_token('STEP ', '5');
1187: fnd_message.raise_error;
1188: END IF;
1189: --
1190: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 1187: fnd_message.raise_error;

1183: ) THEN
1184: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1185: fnd_message.set_token('PROCEDURE ', l_proc);
1186: fnd_message.set_token('STEP ', '5');
1187: fnd_message.raise_error;
1188: END IF;
1189: --
1190: -- EDIT_HERE: Add checks to ensure non-updateable args have
1191: -- not been updated.

Line 1304: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');

1300: --
1301: -- A referential integrity check was violated therefore
1302: -- we must error
1303: --
1304: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
1305: fnd_message.set_token('TABLE_NAME', l_table_name);
1306: fnd_message.raise_error;
1307: When Others Then
1308: --

Line 1305: fnd_message.set_token('TABLE_NAME', l_table_name);

1301: -- A referential integrity check was violated therefore
1302: -- we must error
1303: --
1304: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
1305: fnd_message.set_token('TABLE_NAME', l_table_name);
1306: fnd_message.raise_error;
1307: When Others Then
1308: --
1309: -- An unhandled or unexpected error has occurred which

Line 1306: fnd_message.raise_error;

1302: -- we must error
1303: --
1304: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
1305: fnd_message.set_token('TABLE_NAME', l_table_name);
1306: fnd_message.raise_error;
1307: When Others Then
1308: --
1309: -- An unhandled or unexpected error has occurred which
1310: -- we must report

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

1308: --
1309: -- An unhandled or unexpected error has occurred which
1310: -- we must report
1311: --
1312: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1313: fnd_message.set_token('PROCEDURE', l_proc);
1314: fnd_message.set_token('STEP','15');
1315: fnd_message.raise_error;
1316: End dt_update_validate;

Line 1313: fnd_message.set_token('PROCEDURE', l_proc);

1309: -- An unhandled or unexpected error has occurred which
1310: -- we must report
1311: --
1312: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1313: fnd_message.set_token('PROCEDURE', l_proc);
1314: fnd_message.set_token('STEP','15');
1315: fnd_message.raise_error;
1316: End dt_update_validate;
1317: --

Line 1314: fnd_message.set_token('STEP','15');

1310: -- we must report
1311: --
1312: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1313: fnd_message.set_token('PROCEDURE', l_proc);
1314: fnd_message.set_token('STEP','15');
1315: fnd_message.raise_error;
1316: End dt_update_validate;
1317: --
1318: -- ----------------------------------------------------------------------------

Line 1315: fnd_message.raise_error;

1311: --
1312: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1313: fnd_message.set_token('PROCEDURE', l_proc);
1314: fnd_message.set_token('STEP','15');
1315: fnd_message.raise_error;
1316: End dt_update_validate;
1317: --
1318: -- ----------------------------------------------------------------------------
1319: -- |--------------------------< dt_delete_validate >--------------------------|

Line 1411: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

1407: --
1408: -- A referential integrity check was violated therefore
1409: -- we must error
1410: --
1411: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1412: fnd_message.set_token('TABLE_NAME', l_table_name);
1413: fnd_message.raise_error;
1414: When Others Then
1415: --

Line 1412: fnd_message.set_token('TABLE_NAME', l_table_name);

1408: -- A referential integrity check was violated therefore
1409: -- we must error
1410: --
1411: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1412: fnd_message.set_token('TABLE_NAME', l_table_name);
1413: fnd_message.raise_error;
1414: When Others Then
1415: --
1416: -- An unhandled or unexpected error has occurred which

Line 1413: fnd_message.raise_error;

1409: -- we must error
1410: --
1411: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
1412: fnd_message.set_token('TABLE_NAME', l_table_name);
1413: fnd_message.raise_error;
1414: When Others Then
1415: --
1416: -- An unhandled or unexpected error has occurred which
1417: -- we must report

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

1415: --
1416: -- An unhandled or unexpected error has occurred which
1417: -- we must report
1418: --
1419: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1420: fnd_message.set_token('PROCEDURE', l_proc);
1421: fnd_message.set_token('STEP','15');
1422: fnd_message.raise_error;
1423: --

Line 1420: fnd_message.set_token('PROCEDURE', l_proc);

1416: -- An unhandled or unexpected error has occurred which
1417: -- we must report
1418: --
1419: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1420: fnd_message.set_token('PROCEDURE', l_proc);
1421: fnd_message.set_token('STEP','15');
1422: fnd_message.raise_error;
1423: --
1424: End dt_delete_validate;

Line 1421: fnd_message.set_token('STEP','15');

1417: -- we must report
1418: --
1419: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1420: fnd_message.set_token('PROCEDURE', l_proc);
1421: fnd_message.set_token('STEP','15');
1422: fnd_message.raise_error;
1423: --
1424: End dt_delete_validate;
1425: --

Line 1422: fnd_message.raise_error;

1418: --
1419: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1420: fnd_message.set_token('PROCEDURE', l_proc);
1421: fnd_message.set_token('STEP','15');
1422: fnd_message.raise_error;
1423: --
1424: End dt_delete_validate;
1425: --
1426: -- ----------------------------------------------------------------------------

Line 1538: fnd_message.set_name('PER', 'HR_289229_SPP_DATE_ERROR');

1534: fetch csr_start_end_date into l_effective_start_date, l_effective_end_date;
1535: if csr_start_end_date%notfound then
1536: --
1537: close csr_start_end_date;
1538: fnd_message.set_name('PER', 'HR_289229_SPP_DATE_ERROR');
1539: hr_utility.raise_error;
1540: --
1541: else
1542: close csr_start_end_date;