111: CLOSE c_translation;
112: ELSE
113: hr_utility.set_location (l_package_name,70);
114: CLOSE c_translation;
115: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
116: fnd_message.raise_error;
117: END IF;
118: hr_utility.set_location ('Leaving:'||l_package_name,80);
119: END validate_translation;
112: ELSE
113: hr_utility.set_location (l_package_name,70);
114: CLOSE c_translation;
115: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
116: fnd_message.raise_error;
117: END IF;
118: hr_utility.set_location ('Leaving:'||l_package_name,80);
119: END validate_translation;
120: --------------------------------------------------------------------------------
505: open c;
506: fetch c into recinfo;
507: if (c%notfound) then
508: close c;
509: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
510: app_exception.raise_exception;
511: end if;
512: close c;
513: if ( ((recinfo.BUSINESS_GROUP_ID = X_BUSINESS_GROUP_ID)
542: OR ((recinfo.FREQ_RULE_ENABLED is null) AND (X_FREQ_RULE_ENABLED is null)))
543: ) then
544: null;
545: else
546: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
547: app_exception.raise_exception;
548: end if;
549:
550: for tlinfo in c1 loop
554: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
555: ) then
556: null;
557: else
558: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
559: app_exception.raise_exception;
560: end if;
561: end if;
562: end loop;