APPS.HR_US_W2_REP dependencies on HR_UTILITY

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

1550: /* check if the state is 'CA'. If yes then we nned to check == first in the
1551: plsql table for the value else fetch the value and populate the table
1552: and return the value */
1553:
1554: hr_utility.trace('TUID is : '|| to_char(p_tax_unit_id));
1555: hr_utility.trace('State Abbrev is : '|| p_state_abbrev);
1556:
1557: if p_state_abbrev <> 'CA' then
1558:

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

1551: plsql table for the value else fetch the value and populate the table
1552: and return the value */
1553:
1554: hr_utility.trace('TUID is : '|| to_char(p_tax_unit_id));
1555: hr_utility.trace('State Abbrev is : '|| p_state_abbrev);
1556:
1557: if p_state_abbrev <> 'CA' then
1558:
1559: return ('SDI');

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

1561: else
1562:
1563: if hr_us_w2_rep.ltr_box17.exists(p_tax_unit_id) then
1564:
1565: hr_utility.trace('Value exists ');
1566: l_box17_label := hr_us_w2_rep.ltr_box17(p_tax_unit_id).value;
1567:
1568: else
1569:

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

1566: l_box17_label := hr_us_w2_rep.ltr_box17(p_tax_unit_id).value;
1567:
1568: else
1569:
1570: hr_utility.trace('Value does not exists ');
1571: open c_get_value_gre;
1572: fetch c_get_value_gre into l_box17_label;
1573: if c_get_value_gre%NOTFOUND then
1574: l_box17_label := 'SDI';

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

1574: l_box17_label := 'SDI';
1575: end if;
1576: close c_get_value_gre;
1577:
1578: hr_utility.trace('SQL Value is : '|| l_box17_label);
1579: hr_us_w2_rep.ltr_box17(p_tax_unit_id).state_abbrev := p_state_abbrev;
1580: hr_us_w2_rep.ltr_box17(p_tax_unit_id).value := l_box17_label;
1581:
1582: end if;

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

1580: hr_us_w2_rep.ltr_box17(p_tax_unit_id).value := l_box17_label;
1581:
1582: end if;
1583:
1584: hr_utility.trace('Return Value is : '|| l_box17_label);
1585: return (l_box17_label);
1586:
1587: end if;
1588: