DBA Data[Home] [Help]

APPS.PER_SPS_BUS dependencies on FND_MESSAGE

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

59: close csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: hr_multi_message.add
65: (p_associated_column1
66: => nvl(p_associated_column1,'STEP_ID')
67: );

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

140: --
141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --

Line 145: fnd_message.raise_error;

141: -- The primary key is invalid therefore we must error
142: --
143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are

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

1052: (p_step_id => p_rec.step_id
1053: ,p_effective_date => p_effective_date
1054: ,p_object_version_number => p_rec.object_version_number
1055: ) THEN
1056: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1057: fnd_message.set_token('PROCEDURE ', l_proc);
1058: fnd_message.set_token('STEP ', '5');
1059: fnd_message.raise_error;
1060: END IF;

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

1053: ,p_effective_date => p_effective_date
1054: ,p_object_version_number => p_rec.object_version_number
1055: ) THEN
1056: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1057: fnd_message.set_token('PROCEDURE ', l_proc);
1058: fnd_message.set_token('STEP ', '5');
1059: fnd_message.raise_error;
1060: END IF;
1061:

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

1054: ,p_object_version_number => p_rec.object_version_number
1055: ) THEN
1056: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1057: fnd_message.set_token('PROCEDURE ', l_proc);
1058: fnd_message.set_token('STEP ', '5');
1059: fnd_message.raise_error;
1060: END IF;
1061:
1062: --

Line 1059: fnd_message.raise_error;

1055: ) THEN
1056: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
1057: fnd_message.set_token('PROCEDURE ', l_proc);
1058: fnd_message.set_token('STEP ', '5');
1059: fnd_message.raise_error;
1060: END IF;
1061:
1062: --
1063: -- Check business_group_id is not updated

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

1179: ,p_base_key_column => 'GRADE_SPINE_ID'
1180: ,p_base_key_value => p_grade_spine_id
1181: ,p_from_date => p_validation_start_date
1182: ,p_to_date => p_validation_end_date))) Then
1183: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
1184: fnd_message.set_token('TABLE_NAME','grade spines');
1185: hr_multi_message.add
1186: (p_associated_column1 => per_sps_shd.g_tab_nam || '.GRADE_SPINE_ID');
1187: End If;

Line 1184: fnd_message.set_token('TABLE_NAME','grade spines');

1180: ,p_base_key_value => p_grade_spine_id
1181: ,p_from_date => p_validation_start_date
1182: ,p_to_date => p_validation_end_date))) Then
1183: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
1184: fnd_message.set_token('TABLE_NAME','grade spines');
1185: hr_multi_message.add
1186: (p_associated_column1 => per_sps_shd.g_tab_nam || '.GRADE_SPINE_ID');
1187: End If;
1188: --

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

1191: --
1192: -- An unhandled or unexpected error has occurred which
1193: -- we must report
1194: --
1195: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1196: fnd_message.set_token('PROCEDURE', l_proc);
1197: fnd_message.set_token('STEP','15');
1198: fnd_message.raise_error;
1199: End dt_update_validate;

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

1192: -- An unhandled or unexpected error has occurred which
1193: -- we must report
1194: --
1195: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1196: fnd_message.set_token('PROCEDURE', l_proc);
1197: fnd_message.set_token('STEP','15');
1198: fnd_message.raise_error;
1199: End dt_update_validate;
1200: --

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

1193: -- we must report
1194: --
1195: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1196: fnd_message.set_token('PROCEDURE', l_proc);
1197: fnd_message.set_token('STEP','15');
1198: fnd_message.raise_error;
1199: End dt_update_validate;
1200: --
1201: -- ----------------------------------------------------------------------------

Line 1198: fnd_message.raise_error;

1194: --
1195: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1196: fnd_message.set_token('PROCEDURE', l_proc);
1197: fnd_message.set_token('STEP','15');
1198: fnd_message.raise_error;
1199: End dt_update_validate;
1200: --
1201: -- ----------------------------------------------------------------------------
1202: -- |--------------------------< dt_delete_validate >--------------------------|

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

1290: ,p_base_key_value => p_step_id
1291: ,p_from_date => p_validation_start_date
1292: ,p_to_date => p_validation_end_date
1293: )) Then
1294: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
1295: fnd_message.set_token('TABLE_NAME','cagr entitlement lines');
1296: hr_multi_message.add;
1297: End If;
1298:

Line 1295: fnd_message.set_token('TABLE_NAME','cagr entitlement lines');

1291: ,p_from_date => p_validation_start_date
1292: ,p_to_date => p_validation_end_date
1293: )) Then
1294: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
1295: fnd_message.set_token('TABLE_NAME','cagr entitlement lines');
1296: hr_multi_message.add;
1297: End If;
1298:
1299: hr_utility.set_location(l_proc, 30);

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

1304: ,p_base_key_value => p_step_id
1305: ,p_from_date => p_validation_start_date
1306: ,p_to_date => p_validation_end_date
1307: )) Then
1308: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
1309: fnd_message.set_token('TABLE_NAME','all positions');
1310: hr_multi_message.add;
1311: End If;
1312: --

Line 1309: fnd_message.set_token('TABLE_NAME','all positions');

1305: ,p_from_date => p_validation_start_date
1306: ,p_to_date => p_validation_end_date
1307: )) Then
1308: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
1309: fnd_message.set_token('TABLE_NAME','all positions');
1310: hr_multi_message.add;
1311: End If;
1312: --
1313: End If;

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

1319: --
1320: -- An unhandled or unexpected error has occurred which
1321: -- we must report
1322: --
1323: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1324: fnd_message.set_token('PROCEDURE', l_proc);
1325: fnd_message.set_token('STEP','15');
1326: fnd_message.raise_error;
1327: --

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

1320: -- An unhandled or unexpected error has occurred which
1321: -- we must report
1322: --
1323: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1324: fnd_message.set_token('PROCEDURE', l_proc);
1325: fnd_message.set_token('STEP','15');
1326: fnd_message.raise_error;
1327: --
1328: End dt_delete_validate;

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

1321: -- we must report
1322: --
1323: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1324: fnd_message.set_token('PROCEDURE', l_proc);
1325: fnd_message.set_token('STEP','15');
1326: fnd_message.raise_error;
1327: --
1328: End dt_delete_validate;
1329: --

Line 1326: fnd_message.raise_error;

1322: --
1323: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1324: fnd_message.set_token('PROCEDURE', l_proc);
1325: fnd_message.set_token('STEP','15');
1326: fnd_message.raise_error;
1327: --
1328: End dt_delete_validate;
1329: --
1330: -- ----------------------------------------------------------------------------