DBA Data[Home] [Help]

APPS.PAY_PAYMENT_METHODS_PKG dependencies on HR_UTILITY

Line 182: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

178: OPEN C;
179: FETCH C INTO P_Rowid;
180: if (C%NOTFOUND) then
181: CLOSE C;
182: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
183: hr_utility.set_message_token('PROCEDURE','Insert_row');
184: hr_utility.set_message_token('STEP','1');
185: hr_utility.raise_error;
186: end if;

Line 183: hr_utility.set_message_token('PROCEDURE','Insert_row');

179: FETCH C INTO P_Rowid;
180: if (C%NOTFOUND) then
181: CLOSE C;
182: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
183: hr_utility.set_message_token('PROCEDURE','Insert_row');
184: hr_utility.set_message_token('STEP','1');
185: hr_utility.raise_error;
186: end if;
187: CLOSE C;

Line 184: hr_utility.set_message_token('STEP','1');

180: if (C%NOTFOUND) then
181: CLOSE C;
182: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
183: hr_utility.set_message_token('PROCEDURE','Insert_row');
184: hr_utility.set_message_token('STEP','1');
185: hr_utility.raise_error;
186: end if;
187: CLOSE C;
188: --

Line 185: hr_utility.raise_error;

181: CLOSE C;
182: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
183: hr_utility.set_message_token('PROCEDURE','Insert_row');
184: hr_utility.set_message_token('STEP','1');
185: hr_utility.raise_error;
186: end if;
187: CLOSE C;
188: --
189: IF (P_EXTERNAL_ACCOUNT_ID IS NOT NULL) AND (P_PRENOTE_DATE IS NOT NULL) THEN

Line 410: hr_utility.set_message('801', 'HR_7790_PAY_DEL_ENTRIES');

406: fetch el_ent_check into l_dummy;
407: --
408: IF el_ent_check%FOUND THEN
409: close el_ent_check;
410: hr_utility.set_message('801', 'HR_7790_PAY_DEL_ENTRIES');
411: hr_utility.raise_error;
412: ELSE
413: close el_ent_check;
414: END IF;

Line 411: hr_utility.raise_error;

407: --
408: IF el_ent_check%FOUND THEN
409: close el_ent_check;
410: hr_utility.set_message('801', 'HR_7790_PAY_DEL_ENTRIES');
411: hr_utility.raise_error;
412: ELSE
413: close el_ent_check;
414: END IF;
415: END IF;

Line 423: hr_utility.set_message('801', 'HR_6498_PAY_DEL_PREPAY');

419: IF hr_payments.check_pp (to_char (P_PPM_ID), l_after_this_date) THEN
420: DELETE FROM PAY_PERSONAL_PAYMENT_METHODS_F
421: WHERE ROWID = P_ROWID;
422: ELSE
423: hr_utility.set_message('801', 'HR_6498_PAY_DEL_PREPAY');
424: hr_utility.raise_error;
425: END IF;
426: END DELETE_ROW;
427: --

Line 424: hr_utility.raise_error;

420: DELETE FROM PAY_PERSONAL_PAYMENT_METHODS_F
421: WHERE ROWID = P_ROWID;
422: ELSE
423: hr_utility.set_message('801', 'HR_6498_PAY_DEL_PREPAY');
424: hr_utility.raise_error;
425: END IF;
426: END DELETE_ROW;
427: --
428: PROCEDURE LOCK_ROW(P_ROWID VARCHAR2,

Line 801: hr_utility.set_message('801', 'HR_51029_ASG_NO_PAYROLL');

797: -- check for the case that the asg simply doesn't exist at the date
798: --
799: if payroll_on_new_date%notfound then
800: close payroll_on_new_date;
801: hr_utility.set_message('801', 'HR_51029_ASG_NO_PAYROLL');
802: hr_utility.raise_error;
803: else
804: close payroll_on_new_date;
805: --

Line 802: hr_utility.raise_error;

798: --
799: if payroll_on_new_date%notfound then
800: close payroll_on_new_date;
801: hr_utility.set_message('801', 'HR_51029_ASG_NO_PAYROLL');
802: hr_utility.raise_error;
803: else
804: close payroll_on_new_date;
805: --
806: -- the asg exists: now check for a null payroll

Line 809: hr_utility.set_message('801', 'HR_51029_ASG_NO_PAYROLL');

805: --
806: -- the asg exists: now check for a null payroll
807: --
808: if l_payroll_id is null then
809: hr_utility.set_message('801', 'HR_51029_ASG_NO_PAYROLL');
810: hr_utility.raise_error;
811: end if;
812: end if;
813: end check_asg_on_payroll;

Line 810: hr_utility.raise_error;

806: -- the asg exists: now check for a null payroll
807: --
808: if l_payroll_id is null then
809: hr_utility.set_message('801', 'HR_51029_ASG_NO_PAYROLL');
810: hr_utility.raise_error;
811: end if;
812: end if;
813: end check_asg_on_payroll;
814: --