DBA Data[Home] [Help]

APPS.PAY_CUST_RESTRICTIONS_PKG dependencies on PAY_CUST_RESTRICTIONS_PKG

Line 1: PACKAGE BODY PAY_CUST_RESTRICTIONS_PKG as

1: PACKAGE BODY PAY_CUST_RESTRICTIONS_PKG as
2: /* $Header: pypcr01t.pkb 115.8 2003/07/02 05:56:37 tvankayl ship $ */
3: --
4: procedure unique_chk(x_form_name in VARCHAR2, x_name in VARCHAR2,X_LEGISLATION_CODE in VARCHAR2)
5: is

Line 17: hr_utility.set_message_token('PROCEDURE','PAY_CUST_RESTRICTIONS_PKG.UNIQUE_CHK');

13: and nvl(LEGISLATION_CODE,'~null~') = nvl(X_LEGISLATION_CODE,'~null~');
14: --
15: IF (result>1) THEN
16: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
17: hr_utility.set_message_token('PROCEDURE','PAY_CUST_RESTRICTIONS_PKG.UNIQUE_CHK');
18: hr_utility.set_message_token('STEP','1');
19: hr_utility.raise_error;
20: END IF;
21: EXCEPTION

Line 39: l_proc VARCHAR2(61) := 'PAY_CUST_RESTRICTIONS_PKG.LOAD_ROW';

35: X_QUERY_FORM_TITLE VARCHAR2,
36: X_STANDARD_FORM_TITLE VARCHAR2
37: )
38: is
39: l_proc VARCHAR2(61) := 'PAY_CUST_RESTRICTIONS_PKG.LOAD_ROW';
40: l_rowid rowid;
41: l_created_by PAY_CUSTOMIZED_RESTRICTIONS.created_by%TYPE := 0;
42: l_creation_date PAY_CUSTOMIZED_RESTRICTIONS.creation_date%TYPE := SYSDATE;
43: l_last_update_date PAY_CUSTOMIZED_RESTRICTIONS.last_update_date%TYPE := SYSDATE;

Line 177: -- hr_utility.set_message_token ('PROCEDURE','PAY_CUST_RESTRICTIONS_PKG.TRANSLATE_ROW');

173:
174: --
175: if (sql%notfound) then -- trap system errors during update
176: -- hr_utility.set_message (801,'HR_6153_ALL_PROCEDURE_FAIL');
177: -- hr_utility.set_message_token ('PROCEDURE','PAY_CUST_RESTRICTIONS_PKG.TRANSLATE_ROW');
178: -- hr_utility.set_message_token('STEP','1');
179: -- hr_utility.raise_error;
180: null;
181: end if;

Line 185: END PAY_CUST_RESTRICTIONS_PKG;

181: end if;
182: end TRANSLATE_ROW;
183:
184: -----------------------------------------------------------------------------
185: END PAY_CUST_RESTRICTIONS_PKG;