69: close csr_sec_grp;
70: --
71: -- The primary key is invalid therefore we must error
72: --
73: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
74: hr_multi_message.add
75: (p_associated_column1
76: => nvl(p_associated_column1,'ACTIVITY_VERSION_ID')
77: );
158: --
159: -- The primary key is invalid therefore we must error
160: --
161: close csr_leg_code;
162: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
163: fnd_message.raise_error;
164: end if;
165: hr_utility.set_location(l_proc,30);
166: --
159: -- The primary key is invalid therefore we must error
160: --
161: close csr_leg_code;
162: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
163: fnd_message.raise_error;
164: end if;
165: hr_utility.set_location(l_proc,30);
166: --
167: -- Set the global variables so the values are
218: IF NOT ota_avt_shd.api_updating
219: (p_activity_version_id => p_rec.activity_version_id
220: ,p_language => p_rec.language
221: ) THEN
222: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
223: fnd_message.set_token('PROCEDURE ', l_proc);
224: fnd_message.set_token('STEP ', '5');
225: fnd_message.raise_error;
226: END IF;
219: (p_activity_version_id => p_rec.activity_version_id
220: ,p_language => p_rec.language
221: ) THEN
222: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
223: fnd_message.set_token('PROCEDURE ', l_proc);
224: fnd_message.set_token('STEP ', '5');
225: fnd_message.raise_error;
226: END IF;
227: --
220: ,p_language => p_rec.language
221: ) THEN
222: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
223: fnd_message.set_token('PROCEDURE ', l_proc);
224: fnd_message.set_token('STEP ', '5');
225: fnd_message.raise_error;
226: END IF;
227: --
228: --
221: ) THEN
222: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
223: fnd_message.set_token('PROCEDURE ', l_proc);
224: fnd_message.set_token('STEP ', '5');
225: fnd_message.raise_error;
226: END IF;
227: --
228: --
229: End chk_non_updateable_args;
458: --
459: --call_error_message( p_error_appl => 'OTA'
460: -- , p_error_txt => 'OTA_13301_TAV_DUPLICATE'
461: -- );
462: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
463: fnd_message.raise_error;
464: --
465: end if;
466: --
459: --call_error_message( p_error_appl => 'OTA'
460: -- , p_error_txt => 'OTA_13301_TAV_DUPLICATE'
461: -- );
462: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
463: fnd_message.raise_error;
464: --
465: end if;
466: --
467: close sel_unique_key;