197: CLOSE c_trans_check;
198: ELSE
199: hr_utility.set_location (l_package_name,40);
200: CLOSE c_trans_check;
201: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
202: fnd_message.raise_error;
203: END IF;
204: ELSE
205: OPEN c_translation_exists(language, payment_type_name);
198: ELSE
199: hr_utility.set_location (l_package_name,40);
200: CLOSE c_trans_check;
201: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
202: fnd_message.raise_error;
203: END IF;
204: ELSE
205: OPEN c_translation_exists(language, payment_type_name);
206: hr_utility.set_location (l_package_name,50);
211: CLOSE c_translation_exists;
212: ELSE
213: hr_utility.set_location (l_package_name,70);
214: CLOSE c_translation_exists;
215: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
216: fnd_message.raise_error;
217: END IF;
218: END IF;
219: hr_utility.set_location ('Leaving:'||l_package_name,80);
212: ELSE
213: hr_utility.set_location (l_package_name,70);
214: CLOSE c_translation_exists;
215: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
216: fnd_message.raise_error;
217: END IF;
218: END IF;
219: hr_utility.set_location ('Leaving:'||l_package_name,80);
220:
288: -- OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
289: -- ) then
290: -- null;
291: -- else
292: -- fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
293: -- app_exception.raise_exception;
294: -- end if;
295: -- end if;
296: -- end loop;
352: AND (X_Validation_Value IS NULL)))
353: ) then
354: return;
355: else
356: FND_MESSAGE.Set_Name('FND', 'FORM_RECORD_CHANGED');
357: APP_EXCEPTION.RAISE_EXCEPTION;
358: end if;
359: END Lock_Row;
360: