163: CLOSE C2;
164: NULL;
165: ELSE
166: CLOSE C2;
167: hr_utility.set_message('801','HR_7602_DEF_STATUS_EXISTS');
168: hr_utility.raise_error;
169: END IF;
170: ELSE
171: CLOSE C1;
164: NULL;
165: ELSE
166: CLOSE C2;
167: hr_utility.set_message('801','HR_7602_DEF_STATUS_EXISTS');
168: hr_utility.raise_error;
169: END IF;
170: ELSE
171: CLOSE C1;
172: hr_utility.set_message('801','HR_7602_DEF_STATUS_EXISTS');
168: hr_utility.raise_error;
169: END IF;
170: ELSE
171: CLOSE C1;
172: hr_utility.set_message('801','HR_7602_DEF_STATUS_EXISTS');
173: hr_utility.raise_error;
174: END IF;
175: END UNIQUENESS_CHECK;
176:
169: END IF;
170: ELSE
171: CLOSE C1;
172: hr_utility.set_message('801','HR_7602_DEF_STATUS_EXISTS');
173: hr_utility.raise_error;
174: END IF;
175: END UNIQUENESS_CHECK;
176:
177: PROCEDURE PRE_UPDATE(P_ACTIVE_FLAG VARCHAR2,
398: -- Make sure that the number of personnel system statuses is matched by the
399: -- number of active default assignment statuses.
400: --
401: if system_status_count <> user_status_count then
402: hr_utility.set_message(801, 'HR_7214_ASS_STAT_ONE_ONLY_ONE');
403: hr_utility.raise_error;
404: end if;
405: --
406: --
399: -- number of active default assignment statuses.
400: --
401: if system_status_count <> user_status_count then
402: hr_utility.set_message(801, 'HR_7214_ASS_STAT_ONE_ONLY_ONE');
403: hr_utility.raise_error;
404: end if;
405: --
406: --
407: -- Compare the list of personnel system statuses with the user defined
410: -- active default.
411: --
412: for i in 1..system_status_count loop
413: if system_statuses(i) <> user_statuses(i) then
414: hr_utility.set_message(801, 'HR_7214_ASS_STAT_ONE_ONLY_ONE');
415: hr_utility.raise_error;
416: end if;
417: end loop;
418: --
411: --
412: for i in 1..system_status_count loop
413: if system_statuses(i) <> user_statuses(i) then
414: hr_utility.set_message(801, 'HR_7214_ASS_STAT_ONE_ONLY_ONE');
415: hr_utility.raise_error;
416: end if;
417: end loop;
418: --
419: end chk_dflt_per_sys_statuses;
1052: l_package_name VARCHAR2(80) := 'PER_ASS_STATUSES_PKG.VALIDATE_TRANSLATION';
1053: l_business_group_id NUMBER := nvl(p_business_group_id, g_business_group_id);
1054:
1055: BEGIN
1056: hr_utility.set_location (l_package_name,10);
1057: OPEN c_translation(language, user_status,assignment_status_type_id,
1058: l_business_group_id);
1059: hr_utility.set_location (l_package_name,50);
1060: FETCH c_translation INTO g_dummy;
1055: BEGIN
1056: hr_utility.set_location (l_package_name,10);
1057: OPEN c_translation(language, user_status,assignment_status_type_id,
1058: l_business_group_id);
1059: hr_utility.set_location (l_package_name,50);
1060: FETCH c_translation INTO g_dummy;
1061:
1062: IF c_translation%NOTFOUND THEN
1063: hr_utility.set_location (l_package_name,60);
1059: hr_utility.set_location (l_package_name,50);
1060: FETCH c_translation INTO g_dummy;
1061:
1062: IF c_translation%NOTFOUND THEN
1063: hr_utility.set_location (l_package_name,60);
1064: CLOSE c_translation;
1065: ELSE
1066: hr_utility.set_location (l_package_name,70);
1067: CLOSE c_translation;
1062: IF c_translation%NOTFOUND THEN
1063: hr_utility.set_location (l_package_name,60);
1064: CLOSE c_translation;
1065: ELSE
1066: hr_utility.set_location (l_package_name,70);
1067: CLOSE c_translation;
1068: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
1069: fnd_message.raise_error;
1070: END IF;
1067: CLOSE c_translation;
1068: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
1069: fnd_message.raise_error;
1070: END IF;
1071: hr_utility.set_location ('Leaving:'||l_package_name,80);
1072: END validate_translation;
1073: --------------------------------------------------------------------------------
1074:
1075: END PER_ASS_STATUSES_PKG;