DBA Data[Home] [Help]

APPS.PAY_CA_TAXABILITY_RULES_PKG dependencies on HR_UTILITY

Line 30: Uses : hr_utility

26: Description : This package holds building blocks used in maintenace
27: of Canadian taxability rules using PAY_TAXABILITY_RULES
28: table.
29:
30: Uses : hr_utility
31:
32: Change List
33: -----------
34: Date Name Vers Bug No Description

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

155: P_Login_Id,
156: P_user_id,
157: SYSDATE);
158: IF SQL%NOTFOUND then
159: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
160: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
161: hr_utility.set_message_token('STEP','1');
162: hr_utility.raise_error;
163: end if;

Line 160: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');

156: P_user_id,
157: SYSDATE);
158: IF SQL%NOTFOUND then
159: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
160: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
161: hr_utility.set_message_token('STEP','1');
162: hr_utility.raise_error;
163: end if;
164: --

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

157: SYSDATE);
158: IF SQL%NOTFOUND then
159: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
160: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
161: hr_utility.set_message_token('STEP','1');
162: hr_utility.raise_error;
163: end if;
164: --
165: END insert_rules;

Line 162: hr_utility.raise_error;

158: IF SQL%NOTFOUND then
159: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
160: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
161: hr_utility.set_message_token('STEP','1');
162: hr_utility.raise_error;
163: end if;
164: --
165: END insert_rules;
166: --

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

178: and tax_category = P_category
179: and classification_id = p_classification_id
180: and taxability_rules_date_id = P_taxability_rules_date_id;
181: IF SQL%NOTFOUND then
182: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
183: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
184: hr_utility.set_message_token('STEP','1');
185: hr_utility.raise_error;
186: end if;

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

179: and classification_id = p_classification_id
180: and taxability_rules_date_id = P_taxability_rules_date_id;
181: IF SQL%NOTFOUND then
182: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
183: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
184: hr_utility.set_message_token('STEP','1');
185: hr_utility.raise_error;
186: end if;
187: --

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

180: and taxability_rules_date_id = P_taxability_rules_date_id;
181: IF SQL%NOTFOUND then
182: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
183: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
184: hr_utility.set_message_token('STEP','1');
185: hr_utility.raise_error;
186: end if;
187: --
188: --

Line 185: hr_utility.raise_error;

181: IF SQL%NOTFOUND then
182: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
183: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
184: hr_utility.set_message_token('STEP','1');
185: hr_utility.raise_error;
186: end if;
187: --
188: --
189: END delete_rules;