DBA Data[Home] [Help]

APPS.PAY_US_TAXABILITY_RULES_PKG dependencies on HR_UTILITY

Line 27: Uses : hr_utility

23: Description : This package holds building blocks used in maintenace
24: of US taxability rule using PAY_TAXABILITY_RULES
25: table.
26:
27: Uses : hr_utility
28:
29: Change List
30: -----------
31: Date Name Vers Bug No Description

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

200: SYSDATE, P_user_id, P_Login_Id,
201: P_user_id, SYSDATE);
202:
203: IF SQL%NOTFOUND then
204: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
205: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
206: hr_utility.set_message_token('STEP','1');
207: hr_utility.raise_error;
208: end if;

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

201: P_user_id, SYSDATE);
202:
203: IF SQL%NOTFOUND then
204: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
205: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
206: hr_utility.set_message_token('STEP','1');
207: hr_utility.raise_error;
208: end if;
209: end if;

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

202:
203: IF SQL%NOTFOUND then
204: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
205: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
206: hr_utility.set_message_token('STEP','1');
207: hr_utility.raise_error;
208: end if;
209: end if;
210:

Line 207: hr_utility.raise_error;

203: IF SQL%NOTFOUND then
204: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
205: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.insert');
206: hr_utility.set_message_token('STEP','1');
207: hr_utility.raise_error;
208: end if;
209: end if;
210:
211: RETURN ret;

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

235: and classification_id = p_classification_id
236: and taxability_rules_date_id = P_taxability_rules_date_id;
237:
238: IF SQL%NOTFOUND then
239: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
240: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
241: hr_utility.set_message_token('STEP','1');
242: hr_utility.raise_error;
243: end if;

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

236: and taxability_rules_date_id = P_taxability_rules_date_id;
237:
238: IF SQL%NOTFOUND then
239: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
240: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
241: hr_utility.set_message_token('STEP','1');
242: hr_utility.raise_error;
243: end if;
244: --

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

237:
238: IF SQL%NOTFOUND then
239: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
240: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
241: hr_utility.set_message_token('STEP','1');
242: hr_utility.raise_error;
243: end if;
244: --
245: RETURN ret;

Line 242: hr_utility.raise_error;

238: IF SQL%NOTFOUND then
239: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
240: hr_utility.set_message_token('PROCEDURE','pay_us_taxability_rules_pkg.delete');
241: hr_utility.set_message_token('STEP','1');
242: hr_utility.raise_error;
243: end if;
244: --
245: RETURN ret;
246: --

Line 585: hr_utility.set_message(801, 'HR_50000_WC_ONLY_INC_ONE_OT');

581: p_tax_category => X_tax_cat,
582: p_tax_type => 'WC',
583: p_classification_id => X_classification_id ))
584: THEN
585: hr_utility.set_message(801, 'HR_50000_WC_ONLY_INC_ONE_OT');
586: hr_utility.raise_error;
587: END IF;
588: --
589: P_i := insert_rules(X_jurisdiction,'WC',X_tax_cat, X_classification_id, p_taxability_rules_date_id);

Line 586: hr_utility.raise_error;

582: p_tax_type => 'WC',
583: p_classification_id => X_classification_id ))
584: THEN
585: hr_utility.set_message(801, 'HR_50000_WC_ONLY_INC_ONE_OT');
586: hr_utility.raise_error;
587: END IF;
588: --
589: P_i := insert_rules(X_jurisdiction,'WC',X_tax_cat, X_classification_id, p_taxability_rules_date_id);
590: end if;

Line 795: hr_utility.trace('tax_type :'||p_tax_type);

791: ld_effective_date date;
792:
793:
794: Begin
795: hr_utility.trace('tax_type :'||p_tax_type);
796: hr_utility.trace('tax_category :'||p_tax_category);
797: hr_utility.trace('p_legislation_code :'||p_legislation_code);
798: hr_utility.trace('p_taxability_rules_date_id :'||to_char(p_taxability_rules_date_id));
799: hr_utility.trace('p_classification_id :'||to_char(p_classification_id));

Line 796: hr_utility.trace('tax_category :'||p_tax_category);

792:
793:
794: Begin
795: hr_utility.trace('tax_type :'||p_tax_type);
796: hr_utility.trace('tax_category :'||p_tax_category);
797: hr_utility.trace('p_legislation_code :'||p_legislation_code);
798: hr_utility.trace('p_taxability_rules_date_id :'||to_char(p_taxability_rules_date_id));
799: hr_utility.trace('p_classification_id :'||to_char(p_classification_id));
800:

Line 797: hr_utility.trace('p_legislation_code :'||p_legislation_code);

793:
794: Begin
795: hr_utility.trace('tax_type :'||p_tax_type);
796: hr_utility.trace('tax_category :'||p_tax_category);
797: hr_utility.trace('p_legislation_code :'||p_legislation_code);
798: hr_utility.trace('p_taxability_rules_date_id :'||to_char(p_taxability_rules_date_id));
799: hr_utility.trace('p_classification_id :'||to_char(p_classification_id));
800:
801:

Line 798: hr_utility.trace('p_taxability_rules_date_id :'||to_char(p_taxability_rules_date_id));

794: Begin
795: hr_utility.trace('tax_type :'||p_tax_type);
796: hr_utility.trace('tax_category :'||p_tax_category);
797: hr_utility.trace('p_legislation_code :'||p_legislation_code);
798: hr_utility.trace('p_taxability_rules_date_id :'||to_char(p_taxability_rules_date_id));
799: hr_utility.trace('p_classification_id :'||to_char(p_classification_id));
800:
801:
802: if p_legislation_code = 'US' then

Line 799: hr_utility.trace('p_classification_id :'||to_char(p_classification_id));

795: hr_utility.trace('tax_type :'||p_tax_type);
796: hr_utility.trace('tax_category :'||p_tax_category);
797: hr_utility.trace('p_legislation_code :'||p_legislation_code);
798: hr_utility.trace('p_taxability_rules_date_id :'||to_char(p_taxability_rules_date_id));
799: hr_utility.trace('p_classification_id :'||to_char(p_classification_id));
800:
801:
802: if p_legislation_code = 'US' then
803:

Line 818: hr_utility.trace('ld_effective_date :'||to_char(ld_effective_date));

814: fetch c_session into ld_effective_date ;
815: if c_session%notfound then ld_effective_date := trunc(sysdate,'Y') ;
816: end if;
817: close c_session ;
818: hr_utility.trace('ld_effective_date :'||to_char(ld_effective_date));
819:
820: open c_chk_element_taxcat(p_classification_id,
821: p_tax_category,
822: ld_effective_date);

Line 838: hr_utility.trace('balance_type_id :'||to_char(ln_balance_type_id));

834: loop
835: fetch c_get_balance_type into ln_balance_type_id
836: ,lv_balance_name;
837: exit when c_get_balance_type%notfound;
838: hr_utility.trace('balance_type_id :'||to_char(ln_balance_type_id));
839: hr_utility.trace('balance_name :'||lv_balance_name);
840:
841:
842:

Line 839: hr_utility.trace('balance_name :'||lv_balance_name);

835: fetch c_get_balance_type into ln_balance_type_id
836: ,lv_balance_name;
837: exit when c_get_balance_type%notfound;
838: hr_utility.trace('balance_type_id :'||to_char(ln_balance_type_id));
839: hr_utility.trace('balance_name :'||lv_balance_name);
840:
841:
842:
843: /* for each of balance fetched call the core

Line 866: --hr_utility.trace_on (null, 'XTR');

862:
863: end if; /* p_legislation_code = 'US' */
864: END;
865: --begin
866: --hr_utility.trace_on (null, 'XTR');
867:
868: END pay_us_taxability_rules_pkg;