DBA Data[Home] [Help]

APPS.PER_ASS_STATUSES_PKG dependencies on HR_UTILITY

Line 167: hr_utility.set_message('801','HR_7602_DEF_STATUS_EXISTS');

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;

Line 168: hr_utility.raise_error;

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');

Line 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:

Line 173: 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:
177: PROCEDURE PRE_UPDATE(P_ACTIVE_FLAG VARCHAR2,

Line 360: hr_utility.set_message(801, 'HR_7214_ASS_STAT_ONE_ONLY_ONE');

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: --

Line 361: hr_utility.raise_error;

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

Line 372: hr_utility.set_message(801, 'HR_7214_ASS_STAT_ONE_ONLY_ONE');

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: --

Line 373: hr_utility.raise_error;

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;

Line 969: hr_utility.set_location (l_package_name,10);

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;

Line 972: hr_utility.set_location (l_package_name,50);

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);

Line 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;

Line 979: hr_utility.set_location (l_package_name,70);

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;

Line 984: hr_utility.set_location ('Leaving:'||l_package_name,80);

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;