DBA Data[Home] [Help]

APPS.PER_ABS_ATTENDANCE_REASONS_PKG dependencies on HR_UTILITY

Line 183: hr_utility.set_location('per_abs_attendance_reasons_pkg.Get_Name',1);

179: where lookup_code = X_CODE
180: and lookup_type = 'ABSENCE_REASON';
181: --
182: begin
183: hr_utility.set_location('per_abs_attendance_reasons_pkg.Get_Name',1);
184: OPEN C;
185: FETCH C INTO X_MEANING;
186: CLOSE C;
187: end Get_Name;

Line 198: hr_utility.set_location('per_abs_attendance_reasons_pkg.abr_del_validation',1);

194: where ABS_ATTENDANCE_REASON_ID =p_abs_attendance_reason_id;
195: abs_rec c%rowtype;
196: --
197: begin
198: hr_utility.set_location('per_abs_attendance_reasons_pkg.abr_del_validation',1);
199: OPEN C;
200: FETCH C INTO abs_rec;
201: if (C%FOUND) then
202: CLOSE C;

Line 203: hr_utility.set_message(801,'PER_7060_EMP_ABS_DEL_REAS');

199: OPEN C;
200: FETCH C INTO abs_rec;
201: if (C%FOUND) then
202: CLOSE C;
203: hr_utility.set_message(801,'PER_7060_EMP_ABS_DEL_REAS');
204: hr_utility.raise_error;
205: end if;
206: CLOSE C;
207: end;

Line 204: hr_utility.raise_error;

200: FETCH C INTO abs_rec;
201: if (C%FOUND) then
202: CLOSE C;
203: hr_utility.set_message(801,'PER_7060_EMP_ABS_DEL_REAS');
204: hr_utility.raise_error;
205: end if;
206: CLOSE C;
207: end;
208: --

Line 225: hr_utility.set_location('per_abs_attendance_reasons_pkg.check_unique_reason',1);

221: and rowid = chartorowid(p_rowid)));
222: abr_rec c%rowtype;
223: --
224: begin
225: hr_utility.set_location('per_abs_attendance_reasons_pkg.check_unique_reason',1);
226: OPEN C;
227: FETCH C INTO abr_rec;
228: if (C%FOUND) then
229: CLOSE C;

Line 230: hr_utility.set_message(801,'PER_7807_DEF_ABS_REASON_EXIST');

226: OPEN C;
227: FETCH C INTO abr_rec;
228: if (C%FOUND) then
229: CLOSE C;
230: hr_utility.set_message(801,'PER_7807_DEF_ABS_REASON_EXIST');
231: hr_utility.raise_error;
232: end if;
233: CLOSE C;
234: end check_unique_reason;

Line 231: hr_utility.raise_error;

227: FETCH C INTO abr_rec;
228: if (C%FOUND) then
229: CLOSE C;
230: hr_utility.set_message(801,'PER_7807_DEF_ABS_REASON_EXIST');
231: hr_utility.raise_error;
232: end if;
233: CLOSE C;
234: end check_unique_reason;
235: --