139: --
140: -- call_error_message( p_error_appl => 'OTA'
141: -- , p_error_txt => 'OTA_13331_TAD_DUPLICATE'
142: -- );
143: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
144: fnd_message.raise_error;
145: --
146: end if;
147: --
140: -- call_error_message( p_error_appl => 'OTA'
141: -- , p_error_txt => 'OTA_13331_TAD_DUPLICATE'
142: -- );
143: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
144: fnd_message.raise_error;
145: --
146: end if;
147: --
148: close csr_unique_name;
243: close csr_sec_grp;
244: --
245: -- The primary key is invalid therefore we must error
246: --
247: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
248: hr_multi_message.add
249: (p_associated_column1
250: => nvl(p_associated_column1,'ACTIVITY_ID')
251: );
328: --
329: -- The primary key is invalid therefore we must error
330: --
331: close csr_leg_code;
332: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
333: fnd_message.raise_error;
334: end if;
335: hr_utility.set_location(l_proc,30);
336: --
329: -- The primary key is invalid therefore we must error
330: --
331: close csr_leg_code;
332: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
333: fnd_message.raise_error;
334: end if;
335: hr_utility.set_location(l_proc,30);
336: --
337: -- Set the global variables so the values are
388: IF NOT ota_adt_shd.api_updating
389: (p_activity_id => p_rec.activity_id
390: ,p_language => p_rec.language
391: ) THEN
392: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
393: fnd_message.set_token('PROCEDURE ', l_proc);
394: fnd_message.set_token('STEP ', '5');
395: fnd_message.raise_error;
396: END IF;
389: (p_activity_id => p_rec.activity_id
390: ,p_language => p_rec.language
391: ) THEN
392: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
393: fnd_message.set_token('PROCEDURE ', l_proc);
394: fnd_message.set_token('STEP ', '5');
395: fnd_message.raise_error;
396: END IF;
397: --
390: ,p_language => p_rec.language
391: ) THEN
392: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
393: fnd_message.set_token('PROCEDURE ', l_proc);
394: fnd_message.set_token('STEP ', '5');
395: fnd_message.raise_error;
396: END IF;
397: --
398: --
391: ) THEN
392: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
393: fnd_message.set_token('PROCEDURE ', l_proc);
394: fnd_message.set_token('STEP ', '5');
395: fnd_message.raise_error;
396: END IF;
397: --
398: --
399: End chk_non_updateable_args;