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 402: hr_utility.set_message(801, 'HR_7214_ASS_STAT_ONE_ONLY_ONE');

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

Line 403: hr_utility.raise_error;

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

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

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

Line 415: hr_utility.raise_error;

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;

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

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;

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

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

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

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

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;

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

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;