APPS.HR_US_W2_REP dependencies on HR_UTILITY

Line 368: hr_utility.trace('Year from Assignment Action ID: '||l_year);

364: open get_reporting_year(w2_asg_act_id);
365: fetch get_reporting_year INTO l_year;
366: close get_reporting_year;
367:
368: hr_utility.trace('Year from Assignment Action ID: '||l_year);
369:
370: l_direct_bal_year := NVL(fnd_profile.value('PAY_US_DIRECT_BALANCE_START_YEAR'),'0001');
371:
372: hr_utility.trace('Starting Year for Direct US Federal Balances: '||l_direct_bal_year);

Line 372: hr_utility.trace('Starting Year for Direct US Federal Balances: '||l_direct_bal_year);

368: hr_utility.trace('Year from Assignment Action ID: '||l_year);
369:
370: l_direct_bal_year := NVL(fnd_profile.value('PAY_US_DIRECT_BALANCE_START_YEAR'),'0001');
371:
372: hr_utility.trace('Starting Year for Direct US Federal Balances: '||l_direct_bal_year);
373:
374: if l_direct_bal_year > l_year THEN
375:
376: l_direct_fed_bal_call := 'N';

Line 1669: hr_utility.trace('TUID is : '|| to_char(p_tax_unit_id));

1665: /* check if the state is 'CA'. If yes then we nned to check == first in the
1666: plsql table for the value else fetch the value and populate the table
1667: and return the value */
1668:
1669: hr_utility.trace('TUID is : '|| to_char(p_tax_unit_id));
1670: hr_utility.trace('State Abbrev is : '|| p_state_abbrev);
1671:
1672: if p_state_abbrev <> 'CA' then
1673:

Line 1670: hr_utility.trace('State Abbrev is : '|| p_state_abbrev);

1666: plsql table for the value else fetch the value and populate the table
1667: and return the value */
1668:
1669: hr_utility.trace('TUID is : '|| to_char(p_tax_unit_id));
1670: hr_utility.trace('State Abbrev is : '|| p_state_abbrev);
1671:
1672: if p_state_abbrev <> 'CA' then
1673:
1674: return ('SDI');

Line 1680: hr_utility.trace('Value exists ');

1676: else
1677:
1678: if hr_us_w2_rep.ltr_box17.exists(p_tax_unit_id) then
1679:
1680: hr_utility.trace('Value exists ');
1681: l_box17_label := hr_us_w2_rep.ltr_box17(p_tax_unit_id).value;
1682:
1683: else
1684:

Line 1685: hr_utility.trace('Value does not exists ');

1681: l_box17_label := hr_us_w2_rep.ltr_box17(p_tax_unit_id).value;
1682:
1683: else
1684:
1685: hr_utility.trace('Value does not exists ');
1686: open c_get_value_gre;
1687: fetch c_get_value_gre into l_box17_label;
1688: if c_get_value_gre%NOTFOUND then
1689: l_box17_label := 'SDI';

Line 1693: hr_utility.trace('SQL Value is : '|| l_box17_label);

1689: l_box17_label := 'SDI';
1690: end if;
1691: close c_get_value_gre;
1692:
1693: hr_utility.trace('SQL Value is : '|| l_box17_label);
1694: hr_us_w2_rep.ltr_box17(p_tax_unit_id).state_abbrev := p_state_abbrev;
1695: hr_us_w2_rep.ltr_box17(p_tax_unit_id).value := l_box17_label;
1696:
1697: end if;

Line 1699: hr_utility.trace('Return Value is : '|| l_box17_label);

1695: hr_us_w2_rep.ltr_box17(p_tax_unit_id).value := l_box17_label;
1696:
1697: end if;
1698:
1699: hr_utility.trace('Return Value is : '|| l_box17_label);
1700: return (l_box17_label);
1701:
1702: end if;
1703: