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,
356: -- Make sure that the number of personnel system statuses is matched by the
357: -- number of active default assignment statuses.
358: --
359: if system_status_count <> user_status_count then
360: hr_utility.set_message(801, 'HR_7214_ASS_STAT_ONE_ONLY_ONE');
361: hr_utility.raise_error;
362: end if;
363: --
364: --
357: -- number of active default assignment statuses.
358: --
359: if system_status_count <> user_status_count then
360: hr_utility.set_message(801, 'HR_7214_ASS_STAT_ONE_ONLY_ONE');
361: hr_utility.raise_error;
362: end if;
363: --
364: --
365: -- Compare the list of personnel system statuses with the user defined
368: -- active default.
369: --
370: for i in 1..system_status_count loop
371: if system_statuses(i) <> user_statuses(i) then
372: hr_utility.set_message(801, 'HR_7214_ASS_STAT_ONE_ONLY_ONE');
373: hr_utility.raise_error;
374: end if;
375: end loop;
376: --
369: --
370: for i in 1..system_status_count loop
371: if system_statuses(i) <> user_statuses(i) then
372: hr_utility.set_message(801, 'HR_7214_ASS_STAT_ONE_ONLY_ONE');
373: hr_utility.raise_error;
374: end if;
375: end loop;
376: --
377: end chk_dflt_per_sys_statuses;
965: l_package_name VARCHAR2(80) := 'PER_ASS_STATUSES_PKG.VALIDATE_TRANSLATION';
966: l_business_group_id NUMBER := nvl(p_business_group_id, g_business_group_id);
967:
968: BEGIN
969: hr_utility.set_location (l_package_name,10);
970: OPEN c_translation(language, user_status,assignment_status_type_id,
971: l_business_group_id);
972: hr_utility.set_location (l_package_name,50);
973: FETCH c_translation INTO g_dummy;
968: BEGIN
969: hr_utility.set_location (l_package_name,10);
970: OPEN c_translation(language, user_status,assignment_status_type_id,
971: l_business_group_id);
972: hr_utility.set_location (l_package_name,50);
973: FETCH c_translation INTO g_dummy;
974:
975: IF c_translation%NOTFOUND THEN
976: hr_utility.set_location (l_package_name,60);
972: hr_utility.set_location (l_package_name,50);
973: FETCH c_translation INTO g_dummy;
974:
975: IF c_translation%NOTFOUND THEN
976: hr_utility.set_location (l_package_name,60);
977: CLOSE c_translation;
978: ELSE
979: hr_utility.set_location (l_package_name,70);
980: CLOSE c_translation;
975: IF c_translation%NOTFOUND THEN
976: hr_utility.set_location (l_package_name,60);
977: CLOSE c_translation;
978: ELSE
979: hr_utility.set_location (l_package_name,70);
980: CLOSE c_translation;
981: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
982: fnd_message.raise_error;
983: END IF;
980: CLOSE c_translation;
981: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
982: fnd_message.raise_error;
983: END IF;
984: hr_utility.set_location ('Leaving:'||l_package_name,80);
985: END validate_translation;
986: --------------------------------------------------------------------------------
987:
988: END PER_ASS_STATUSES_PKG;