eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_RULES dependencies on HR_UTILITY

Line 318: hr_utility.trace('Entering '||l_proc_name);

314:
315: BEGIN
316: l_pkg_name := 'pay_us_rules.';
317: l_proc_name := l_pkg_name||'default_jurisdiction';
318: hr_utility.trace('Entering '||l_proc_name);
319:
320: open csr_ele_classification;
321: fetch csr_ele_classification into l_ele_classification;
322: close csr_ele_classification;

Line 324: hr_utility.trace('Classification of element entry id '|| p_ee_id ||' is '||l_ele_classification);

320: open csr_ele_classification;
321: fetch csr_ele_classification into l_ele_classification;
322: close csr_ele_classification;
323:
324: hr_utility.trace('Classification of element entry id '|| p_ee_id ||' is '||l_ele_classification);
325:
326: if l_ele_classification = 'Involuntary Deductions' then
327: open csr_wrk_at_home;
328: fetch csr_wrk_at_home into l_asg_wrk_at_home;

Line 347: hr_utility.trace('Default jurisdiction code is '||p_jurisdiction);

343: p_jurisdiction := hr_us_ff_udfs.addr_val (l_override_adr_region_2,
344: l_override_adr_region_1,
345: l_override_adr_city,
346: l_override_adr_postal_code);
347: hr_utility.trace('Default jurisdiction code is '||p_jurisdiction);
348: end if;
349: hr_utility.trace('Leaving '||l_proc_name);
350: END get_default_jurisdiction;
351:

Line 349: hr_utility.trace('Leaving '||l_proc_name);

345: l_override_adr_city,
346: l_override_adr_postal_code);
347: hr_utility.trace('Default jurisdiction code is '||p_jurisdiction);
348: end if;
349: hr_utility.trace('Leaving '||l_proc_name);
350: END get_default_jurisdiction;
351:
352:
353: /****************************************************************************/

Line 360: hr_utility.TRACE ('Entering pay_us_rules.element_template_pre_process');

356:
357: FUNCTION element_template_pre_process (p_rec IN pay_ele_tmplt_obj)
358: RETURN pay_ele_tmplt_obj IS
359: BEGIN
360: hr_utility.TRACE ('Entering pay_us_rules.element_template_pre_process');
361: hr_utility.TRACE ('Legislation Code ' || lrec.legislation_code);
362: -- INITIALIZING THE GLOBAL VARIABLE
363: lrec := NULL;
364: -- DEFAULTING TO input VARIABLE

Line 361: hr_utility.TRACE ('Legislation Code ' || lrec.legislation_code);

357: FUNCTION element_template_pre_process (p_rec IN pay_ele_tmplt_obj)
358: RETURN pay_ele_tmplt_obj IS
359: BEGIN
360: hr_utility.TRACE ('Entering pay_us_rules.element_template_pre_process');
361: hr_utility.TRACE ('Legislation Code ' || lrec.legislation_code);
362: -- INITIALIZING THE GLOBAL VARIABLE
363: lrec := NULL;
364: -- DEFAULTING TO input VARIABLE
365: lrec := p_rec;

Line 691: hr_utility.trace('CONFIG1 = ' || lrec.configuration_information1);

687: ) THEN
688: lrec.configuration_information14 := 'Y';
689: END IF;
690:
691: hr_utility.trace('CONFIG1 = ' || lrec.configuration_information1);
692: hr_utility.trace('CONFIG2 = ' || lrec.configuration_information2);
693: hr_utility.trace('CONFIG3 = ' || lrec.configuration_information3);
694: hr_utility.trace('CONFIG4 = ' || lrec.configuration_information4);
695: hr_utility.trace('CONFIG5 = ' || lrec.configuration_information5);

Line 692: hr_utility.trace('CONFIG2 = ' || lrec.configuration_information2);

688: lrec.configuration_information14 := 'Y';
689: END IF;
690:
691: hr_utility.trace('CONFIG1 = ' || lrec.configuration_information1);
692: hr_utility.trace('CONFIG2 = ' || lrec.configuration_information2);
693: hr_utility.trace('CONFIG3 = ' || lrec.configuration_information3);
694: hr_utility.trace('CONFIG4 = ' || lrec.configuration_information4);
695: hr_utility.trace('CONFIG5 = ' || lrec.configuration_information5);
696: hr_utility.trace('CONFIG6 = ' || lrec.configuration_information6);

Line 693: hr_utility.trace('CONFIG3 = ' || lrec.configuration_information3);

689: END IF;
690:
691: hr_utility.trace('CONFIG1 = ' || lrec.configuration_information1);
692: hr_utility.trace('CONFIG2 = ' || lrec.configuration_information2);
693: hr_utility.trace('CONFIG3 = ' || lrec.configuration_information3);
694: hr_utility.trace('CONFIG4 = ' || lrec.configuration_information4);
695: hr_utility.trace('CONFIG5 = ' || lrec.configuration_information5);
696: hr_utility.trace('CONFIG6 = ' || lrec.configuration_information6);
697: hr_utility.trace('CONFIG7 = ' || lrec.configuration_information7);

Line 694: hr_utility.trace('CONFIG4 = ' || lrec.configuration_information4);

690:
691: hr_utility.trace('CONFIG1 = ' || lrec.configuration_information1);
692: hr_utility.trace('CONFIG2 = ' || lrec.configuration_information2);
693: hr_utility.trace('CONFIG3 = ' || lrec.configuration_information3);
694: hr_utility.trace('CONFIG4 = ' || lrec.configuration_information4);
695: hr_utility.trace('CONFIG5 = ' || lrec.configuration_information5);
696: hr_utility.trace('CONFIG6 = ' || lrec.configuration_information6);
697: hr_utility.trace('CONFIG7 = ' || lrec.configuration_information7);
698: hr_utility.trace('CONFIG8 = ' || lrec.configuration_information8);

Line 695: hr_utility.trace('CONFIG5 = ' || lrec.configuration_information5);

691: hr_utility.trace('CONFIG1 = ' || lrec.configuration_information1);
692: hr_utility.trace('CONFIG2 = ' || lrec.configuration_information2);
693: hr_utility.trace('CONFIG3 = ' || lrec.configuration_information3);
694: hr_utility.trace('CONFIG4 = ' || lrec.configuration_information4);
695: hr_utility.trace('CONFIG5 = ' || lrec.configuration_information5);
696: hr_utility.trace('CONFIG6 = ' || lrec.configuration_information6);
697: hr_utility.trace('CONFIG7 = ' || lrec.configuration_information7);
698: hr_utility.trace('CONFIG8 = ' || lrec.configuration_information8);
699: hr_utility.trace('CONFIG9 = ' || lrec.configuration_information9);

Line 696: hr_utility.trace('CONFIG6 = ' || lrec.configuration_information6);

692: hr_utility.trace('CONFIG2 = ' || lrec.configuration_information2);
693: hr_utility.trace('CONFIG3 = ' || lrec.configuration_information3);
694: hr_utility.trace('CONFIG4 = ' || lrec.configuration_information4);
695: hr_utility.trace('CONFIG5 = ' || lrec.configuration_information5);
696: hr_utility.trace('CONFIG6 = ' || lrec.configuration_information6);
697: hr_utility.trace('CONFIG7 = ' || lrec.configuration_information7);
698: hr_utility.trace('CONFIG8 = ' || lrec.configuration_information8);
699: hr_utility.trace('CONFIG9 = ' || lrec.configuration_information9);
700: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);

Line 697: hr_utility.trace('CONFIG7 = ' || lrec.configuration_information7);

693: hr_utility.trace('CONFIG3 = ' || lrec.configuration_information3);
694: hr_utility.trace('CONFIG4 = ' || lrec.configuration_information4);
695: hr_utility.trace('CONFIG5 = ' || lrec.configuration_information5);
696: hr_utility.trace('CONFIG6 = ' || lrec.configuration_information6);
697: hr_utility.trace('CONFIG7 = ' || lrec.configuration_information7);
698: hr_utility.trace('CONFIG8 = ' || lrec.configuration_information8);
699: hr_utility.trace('CONFIG9 = ' || lrec.configuration_information9);
700: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
701: hr_utility.trace('CONFIG11 = ' || lrec.configuration_information11);

Line 698: hr_utility.trace('CONFIG8 = ' || lrec.configuration_information8);

694: hr_utility.trace('CONFIG4 = ' || lrec.configuration_information4);
695: hr_utility.trace('CONFIG5 = ' || lrec.configuration_information5);
696: hr_utility.trace('CONFIG6 = ' || lrec.configuration_information6);
697: hr_utility.trace('CONFIG7 = ' || lrec.configuration_information7);
698: hr_utility.trace('CONFIG8 = ' || lrec.configuration_information8);
699: hr_utility.trace('CONFIG9 = ' || lrec.configuration_information9);
700: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
701: hr_utility.trace('CONFIG11 = ' || lrec.configuration_information11);
702: hr_utility.trace('CONFIG12 = ' || lrec.configuration_information12);

Line 699: hr_utility.trace('CONFIG9 = ' || lrec.configuration_information9);

695: hr_utility.trace('CONFIG5 = ' || lrec.configuration_information5);
696: hr_utility.trace('CONFIG6 = ' || lrec.configuration_information6);
697: hr_utility.trace('CONFIG7 = ' || lrec.configuration_information7);
698: hr_utility.trace('CONFIG8 = ' || lrec.configuration_information8);
699: hr_utility.trace('CONFIG9 = ' || lrec.configuration_information9);
700: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
701: hr_utility.trace('CONFIG11 = ' || lrec.configuration_information11);
702: hr_utility.trace('CONFIG12 = ' || lrec.configuration_information12);
703: hr_utility.trace('CONFIG13 = ' || lrec.configuration_information13);

Line 700: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);

696: hr_utility.trace('CONFIG6 = ' || lrec.configuration_information6);
697: hr_utility.trace('CONFIG7 = ' || lrec.configuration_information7);
698: hr_utility.trace('CONFIG8 = ' || lrec.configuration_information8);
699: hr_utility.trace('CONFIG9 = ' || lrec.configuration_information9);
700: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
701: hr_utility.trace('CONFIG11 = ' || lrec.configuration_information11);
702: hr_utility.trace('CONFIG12 = ' || lrec.configuration_information12);
703: hr_utility.trace('CONFIG13 = ' || lrec.configuration_information13);
704: hr_utility.trace('CONFIG14 = ' || lrec.configuration_information14);

Line 701: hr_utility.trace('CONFIG11 = ' || lrec.configuration_information11);

697: hr_utility.trace('CONFIG7 = ' || lrec.configuration_information7);
698: hr_utility.trace('CONFIG8 = ' || lrec.configuration_information8);
699: hr_utility.trace('CONFIG9 = ' || lrec.configuration_information9);
700: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
701: hr_utility.trace('CONFIG11 = ' || lrec.configuration_information11);
702: hr_utility.trace('CONFIG12 = ' || lrec.configuration_information12);
703: hr_utility.trace('CONFIG13 = ' || lrec.configuration_information13);
704: hr_utility.trace('CONFIG14 = ' || lrec.configuration_information14);
705: hr_utility.trace('CONFIG15 = ' || lrec.configuration_information15);

Line 702: hr_utility.trace('CONFIG12 = ' || lrec.configuration_information12);

698: hr_utility.trace('CONFIG8 = ' || lrec.configuration_information8);
699: hr_utility.trace('CONFIG9 = ' || lrec.configuration_information9);
700: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
701: hr_utility.trace('CONFIG11 = ' || lrec.configuration_information11);
702: hr_utility.trace('CONFIG12 = ' || lrec.configuration_information12);
703: hr_utility.trace('CONFIG13 = ' || lrec.configuration_information13);
704: hr_utility.trace('CONFIG14 = ' || lrec.configuration_information14);
705: hr_utility.trace('CONFIG15 = ' || lrec.configuration_information15);
706: hr_utility.trace('Priority = ' || lrec.processing_priority);

Line 703: hr_utility.trace('CONFIG13 = ' || lrec.configuration_information13);

699: hr_utility.trace('CONFIG9 = ' || lrec.configuration_information9);
700: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
701: hr_utility.trace('CONFIG11 = ' || lrec.configuration_information11);
702: hr_utility.trace('CONFIG12 = ' || lrec.configuration_information12);
703: hr_utility.trace('CONFIG13 = ' || lrec.configuration_information13);
704: hr_utility.trace('CONFIG14 = ' || lrec.configuration_information14);
705: hr_utility.trace('CONFIG15 = ' || lrec.configuration_information15);
706: hr_utility.trace('Priority = ' || lrec.processing_priority);
707:

Line 704: hr_utility.trace('CONFIG14 = ' || lrec.configuration_information14);

700: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
701: hr_utility.trace('CONFIG11 = ' || lrec.configuration_information11);
702: hr_utility.trace('CONFIG12 = ' || lrec.configuration_information12);
703: hr_utility.trace('CONFIG13 = ' || lrec.configuration_information13);
704: hr_utility.trace('CONFIG14 = ' || lrec.configuration_information14);
705: hr_utility.trace('CONFIG15 = ' || lrec.configuration_information15);
706: hr_utility.trace('Priority = ' || lrec.processing_priority);
707:
708: -- hr_utility.trace_off();

Line 705: hr_utility.trace('CONFIG15 = ' || lrec.configuration_information15);

701: hr_utility.trace('CONFIG11 = ' || lrec.configuration_information11);
702: hr_utility.trace('CONFIG12 = ' || lrec.configuration_information12);
703: hr_utility.trace('CONFIG13 = ' || lrec.configuration_information13);
704: hr_utility.trace('CONFIG14 = ' || lrec.configuration_information14);
705: hr_utility.trace('CONFIG15 = ' || lrec.configuration_information15);
706: hr_utility.trace('Priority = ' || lrec.processing_priority);
707:
708: -- hr_utility.trace_off();
709:

Line 706: hr_utility.trace('Priority = ' || lrec.processing_priority);

702: hr_utility.trace('CONFIG12 = ' || lrec.configuration_information12);
703: hr_utility.trace('CONFIG13 = ' || lrec.configuration_information13);
704: hr_utility.trace('CONFIG14 = ' || lrec.configuration_information14);
705: hr_utility.trace('CONFIG15 = ' || lrec.configuration_information15);
706: hr_utility.trace('Priority = ' || lrec.processing_priority);
707:
708: -- hr_utility.trace_off();
709:
710: END IF; /* IF (lrec.calculation_rule = 'US Earnings') */

Line 708: -- hr_utility.trace_off();

704: hr_utility.trace('CONFIG14 = ' || lrec.configuration_information14);
705: hr_utility.trace('CONFIG15 = ' || lrec.configuration_information15);
706: hr_utility.trace('Priority = ' || lrec.processing_priority);
707:
708: -- hr_utility.trace_off();
709:
710: END IF; /* IF (lrec.calculation_rule = 'US Earnings') */
711:
712: -----------------------------------------------------------------

Line 726: hr_utility.TRACE ('Leaving pay_us_rules.element_template_pre_process');

722: IF lrec.process_mode = 'N' THEN-- value sent as N for earnings
723: lrec.process_mode := 'S';
724: END IF;
725:
726: hr_utility.TRACE ('Leaving pay_us_rules.element_template_pre_process');
727: RETURN lrec;
728: END element_template_pre_process;
729:
730: /****************************************************************************/

Line 767: hr_utility.TRACE ('Entering pay_us_rules.element_template_upd_user_stru');

763: ln_sf_process_priority NUMBER(9);
764: ln_fc_process_priority NUMBER(9);
765: ln_fpa_process_priority NUMBER(9);
766: BEGIN
767: hr_utility.TRACE ('Entering pay_us_rules.element_template_upd_user_stru');
768: hr_utility.TRACE ('p_element_template_id ' || p_element_template_id);
769:
770: -----------------------------------------------------------
771: -- Update Base shadow Element with user-specified details

Line 768: hr_utility.TRACE ('p_element_template_id ' || p_element_template_id);

764: ln_fc_process_priority NUMBER(9);
765: ln_fpa_process_priority NUMBER(9);
766: BEGIN
767: hr_utility.TRACE ('Entering pay_us_rules.element_template_upd_user_stru');
768: hr_utility.TRACE ('p_element_template_id ' || p_element_template_id);
769:
770: -----------------------------------------------------------
771: -- Update Base shadow Element with user-specified details
772: -----------------------------------------------------------

Line 979: hr_utility.TRACE ('Leaving pay_us_rules.element_template_upd_user_stru');

975: ,p_object_version_number => l_ovn
976: );
977: END IF;
978:
979: hr_utility.TRACE ('Leaving pay_us_rules.element_template_upd_user_stru');
980: END element_template_upd_user_stru;
981:
982: /****************************************************************************/
983: /* PROCEDURE element_template_post_process */

Line 1146: hr_utility.TRACE ('Entering pay_us_rules.element_template_post_process');

1142: legislation_code will be present
1143: */
1144:
1145: BEGIN
1146: hr_utility.TRACE ('Entering pay_us_rules.element_template_post_process');
1147: hr_utility.TRACE ('p_element_template_id ' || p_element_template_id);
1148:
1149: -- FLSA Changes
1150: IF (lrec.calculation_rule = 'US ' || lrec.element_classification) THEN

Line 1147: hr_utility.TRACE ('p_element_template_id ' || p_element_template_id);

1143: */
1144:
1145: BEGIN
1146: hr_utility.TRACE ('Entering pay_us_rules.element_template_post_process');
1147: hr_utility.TRACE ('p_element_template_id ' || p_element_template_id);
1148:
1149: -- FLSA Changes
1150: IF (lrec.calculation_rule = 'US ' || lrec.element_classification) THEN
1151: lv_hoursXrate := 'N'; --lrec.configuration_information4;

Line 1507: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');

1503: ,p_effective_end_date => l_fc_eff_end_date
1504: ,p_object_version_number => l_fc_obj_ver_num
1505: );
1506: ELSE
1507: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');
1508: hr_utility.TRACE ('Error in fetching formula id for FLSA_PREMIUM_AMOUNT_CALCULATION');
1509: END IF;/*End of c_formula_id%FOUND*/
1510:
1511: CLOSE c_formula_id;

Line 1508: hr_utility.TRACE ('Error in fetching formula id for FLSA_PREMIUM_AMOUNT_CALCULATION');

1504: ,p_object_version_number => l_fc_obj_ver_num
1505: );
1506: ELSE
1507: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');
1508: hr_utility.TRACE ('Error in fetching formula id for FLSA_PREMIUM_AMOUNT_CALCULATION');
1509: END IF;/*End of c_formula_id%FOUND*/
1510:
1511: CLOSE c_formula_id;
1512:

Line 1523: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');

1519: SET proration_group_id = ln_proration_group_id
1520: WHERE business_group_id = ln_business_group_id
1521: AND element_type_id = l_fc_ele_type_id;
1522: ELSE
1523: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');
1524: hr_utility.TRACE ('Error in fetching proration group id for Entry Changes for Proration');
1525: END IF;
1526: CLOSE get_proration_group_id;
1527:

Line 1524: hr_utility.TRACE ('Error in fetching proration group id for Entry Changes for Proration');

1520: WHERE business_group_id = ln_business_group_id
1521: AND element_type_id = l_fc_ele_type_id;
1522: ELSE
1523: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');
1524: hr_utility.TRACE ('Error in fetching proration group id for Entry Changes for Proration');
1525: END IF;
1526: CLOSE get_proration_group_id;
1527:
1528:

Line 1560: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');

1556: ,p_replace_run_flag => 'N'
1557: ,p_use_override_dates => 'N'
1558: );
1559: ELSE
1560: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');
1561: hr_utility.TRACE ('Error in fetching retro component id');
1562: END IF;
1563: CLOSE get_retro_comp_id;
1564: ELSE

Line 1561: hr_utility.TRACE ('Error in fetching retro component id');

1557: ,p_use_override_dates => 'N'
1558: );
1559: ELSE
1560: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');
1561: hr_utility.TRACE ('Error in fetching retro component id');
1562: END IF;
1563: CLOSE get_retro_comp_id;
1564: ELSE
1565: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');

Line 1565: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');

1561: hr_utility.TRACE ('Error in fetching retro component id');
1562: END IF;
1563: CLOSE get_retro_comp_id;
1564: ELSE
1565: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');
1566: hr_utility.TRACE ('Error in fetching retro group id for Entry Changes');
1567: END IF;
1568: CLOSE get_proration_group_id;
1569:

Line 1566: hr_utility.TRACE ('Error in fetching retro group id for Entry Changes');

1562: END IF;
1563: CLOSE get_retro_comp_id;
1564: ELSE
1565: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');
1566: hr_utility.TRACE ('Error in fetching retro group id for Entry Changes');
1567: END IF;
1568: CLOSE get_proration_group_id;
1569:
1570:

Line 1653: hr_utility.trace('Calc Rule = ' || lrec.calculation_rule);

1649: -- FLSA Changes
1650: -- Modifying the TIME_DEFINTION_TYPE for FLSA elements to 'G'
1651: -- if the elements are created using FLSA template or the
1652: -- element has FLSA Earnings checked
1653: hr_utility.trace('Calc Rule = ' || lrec.calculation_rule);
1654: hr_utility.trace('Ele Class = ' || lrec.element_classification);
1655: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
1656: IF (lrec.calculation_rule = 'US FLSA ' || lrec.element_classification) THEN
1657: IF (lrec.configuration_information10 = 'N') then

Line 1654: hr_utility.trace('Ele Class = ' || lrec.element_classification);

1650: -- Modifying the TIME_DEFINTION_TYPE for FLSA elements to 'G'
1651: -- if the elements are created using FLSA template or the
1652: -- element has FLSA Earnings checked
1653: hr_utility.trace('Calc Rule = ' || lrec.calculation_rule);
1654: hr_utility.trace('Ele Class = ' || lrec.element_classification);
1655: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
1656: IF (lrec.calculation_rule = 'US FLSA ' || lrec.element_classification) THEN
1657: IF (lrec.configuration_information10 = 'N') then
1658: hr_utility.trace('1. Updating Time Definition Type to G');

Line 1655: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);

1651: -- if the elements are created using FLSA template or the
1652: -- element has FLSA Earnings checked
1653: hr_utility.trace('Calc Rule = ' || lrec.calculation_rule);
1654: hr_utility.trace('Ele Class = ' || lrec.element_classification);
1655: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
1656: IF (lrec.calculation_rule = 'US FLSA ' || lrec.element_classification) THEN
1657: IF (lrec.configuration_information10 = 'N') then
1658: hr_utility.trace('1. Updating Time Definition Type to G');
1659: UPDATE pay_element_types_f

Line 1658: hr_utility.trace('1. Updating Time Definition Type to G');

1654: hr_utility.trace('Ele Class = ' || lrec.element_classification);
1655: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
1656: IF (lrec.calculation_rule = 'US FLSA ' || lrec.element_classification) THEN
1657: IF (lrec.configuration_information10 = 'N') then
1658: hr_utility.trace('1. Updating Time Definition Type to G');
1659: UPDATE pay_element_types_f
1660: SET time_definition_type = 'G'
1661: WHERE business_group_id = ln_business_group_id
1662: AND element_type_id in ( pay_us_earn_templ_wrapper.g_ele_type_id

Line 1666: hr_utility.trace('2. Updating Time Definition Type to G');

1662: AND element_type_id in ( pay_us_earn_templ_wrapper.g_ele_type_id
1663: ,l_fpa_ele_type_id);
1664: END IF;
1665: ELSIF lrec.configuration_information7 = 'Y' THEN
1666: hr_utility.trace('2. Updating Time Definition Type to G');
1667: UPDATE pay_element_types_f
1668: SET time_definition_type = 'G'
1669: WHERE business_group_id = ln_business_group_id
1670: AND element_type_id = pay_us_earn_templ_wrapper.g_ele_type_id;

Line 1675: hr_utility.trace('2. Updating Time Definition Type to G');

1671: END IF;
1672:
1673: -- Modifying the TIME_DEFINTION_TYPE for Augment elements to 'G'
1674: IF ((lrec.calculation_rule = 'US ' || lrec.element_classification) AND lrec.configuration_information24 = 'Y') THEN
1675: hr_utility.trace('2. Updating Time Definition Type to G');
1676: UPDATE pay_element_types_f
1677: SET time_definition_type = 'G'
1678: WHERE business_group_id = ln_business_group_id
1679: AND element_type_id = l_fc_ele_type_id;

Line 1683: hr_utility.TRACE ('Leaving pay_us_rules.element_template_post_process');

1679: AND element_type_id = l_fc_ele_type_id;
1680: END IF;
1681:
1682:
1683: hr_utility.TRACE ('Leaving pay_us_rules.element_template_post_process');
1684: END element_template_post_process;
1685:
1686: /****************************************************************************/
1687: /* PROCEDURE delete_pre_process */

Line 1756: hr_utility.TRACE ('Entering pay_us_rules.delete_pre_process');

1752:
1753:
1754: BEGIN
1755:
1756: hr_utility.TRACE ('Entering pay_us_rules.delete_pre_process');
1757:
1758: OPEN c_ele_name(pay_us_earn_templ_wrapper.g_ele_type_id);
1759: FETCH c_ele_name INTO lv_ele_name
1760: , lv_business_group_id

Line 1809: hr_utility.TRACE ('pay_formula_result_rules_f does not return any row');

1805: ,p_effective_start_date => l_eff_start_date
1806: ,p_effective_end_date => l_eff_end_date
1807: );
1808: ELSE
1809: hr_utility.TRACE ('pay_formula_result_rules_f does not return any row');
1810: END IF;/*c_for_res_rule%FOUND*/
1811: CLOSE c_for_res_rule;
1812:
1813: pay_status_processing_rule_api.delete_status_process_rule

Line 1823: hr_utility.TRACE ('pay_status_processing_rules_f does not return any row');

1819: ,p_effective_start_date => l_eff_start_date
1820: ,p_effective_end_date => l_eff_end_date
1821: );
1822: ELSE
1823: hr_utility.TRACE ('pay_status_processing_rules_f does not return any row');
1824: END IF;/*c_stat_proc_rule%FOUND*/
1825: CLOSE c_stat_proc_rule;
1826:
1827: END IF;/*l_shadow_ele_type_id IS NOT NULL*/

Line 1831: hr_utility.TRACE ('Error in pay_us_rules.delete_pre_process');

1827: END IF;/*l_shadow_ele_type_id IS NOT NULL*/
1828: END LOOP;/*tshadoweledetails.FIRST .. tshadoweledetails.LAST*/
1829:
1830: ELSE
1831: hr_utility.TRACE ('Error in pay_us_rules.delete_pre_process');
1832: hr_utility.TRACE ('Element Type Id passed does not have a row in pay_element_types_f');
1833: END IF;/*c_ele_name%FOUND*/
1834: CLOSE c_ele_name;
1835:

Line 1832: hr_utility.TRACE ('Element Type Id passed does not have a row in pay_element_types_f');

1828: END LOOP;/*tshadoweledetails.FIRST .. tshadoweledetails.LAST*/
1829:
1830: ELSE
1831: hr_utility.TRACE ('Error in pay_us_rules.delete_pre_process');
1832: hr_utility.TRACE ('Element Type Id passed does not have a row in pay_element_types_f');
1833: END IF;/*c_ele_name%FOUND*/
1834: CLOSE c_ele_name;
1835:
1836: hr_utility.TRACE ('Leaving pay_us_rules.delete_pre_process');

Line 1836: hr_utility.TRACE ('Leaving pay_us_rules.delete_pre_process');

1832: hr_utility.TRACE ('Element Type Id passed does not have a row in pay_element_types_f');
1833: END IF;/*c_ele_name%FOUND*/
1834: CLOSE c_ele_name;
1835:
1836: hr_utility.TRACE ('Leaving pay_us_rules.delete_pre_process');
1837: END delete_pre_process;
1838:
1839: /****************************************************************************/
1840: /* PROCEDURE delete_post_process */

Line 1845: hr_utility.TRACE ('Entering pay_us_rules.delete_post_process');

1841: /****************************************************************************/
1842:
1843: PROCEDURE delete_post_process(p_element_template_id IN NUMBER) IS
1844: BEGIN
1845: hr_utility.TRACE ('Entering pay_us_rules.delete_post_process');
1846: NULL;
1847: hr_utility.TRACE ('Leaving pay_us_rules.delete_post_process');
1848: END delete_post_process;
1849:

Line 1847: hr_utility.TRACE ('Leaving pay_us_rules.delete_post_process');

1843: PROCEDURE delete_post_process(p_element_template_id IN NUMBER) IS
1844: BEGIN
1845: hr_utility.TRACE ('Entering pay_us_rules.delete_post_process');
1846: NULL;
1847: hr_utility.TRACE ('Leaving pay_us_rules.delete_post_process');
1848: END delete_post_process;
1849:
1850:
1851: --=======================================================================

Line 1892: hr_utility.set_location ('Entering: ' || l_proc, 10);

1888: p_business_group_id
1889: AND NVL (pbt.legislation_code, p_legislation_code) = p_legislation_code;
1890: --
1891: BEGIN
1892: hr_utility.set_location ('Entering: ' || l_proc, 10);
1893: l_proc := 'pay_us_earnings_template.get_obj_id';
1894: --
1895: IF p_object_type = 'ELE' THEN
1896: FOR c_rec IN c_element

Line 1912: hr_utility.set_location ('Leaving: ' || l_proc, 50);

1908: l_object_id := c_rec.input_value_id; -- input value id
1909: END LOOP;
1910: END IF;
1911:
1912: hr_utility.set_location ('Leaving: ' || l_proc, 50);
1913: --
1914: RETURN l_object_id;
1915: END get_obj_id;
1916: --

Line 1974: hr_utility.trace('Getting ID_FLEX_NUM for US legislation ');

1970: c_ws_tab_name := 'COMPANY WORK SCHEDULES';
1971:
1972: /* get ID FLEX NUM */
1973: --IF pay_us_rules.g_id_flex_num IS NULL THEN
1974: hr_utility.trace('Getting ID_FLEX_NUM for US legislation ');
1975: OPEN get_id_flex_num;
1976: FETCH get_id_flex_num INTO l_id_flex_num;
1977: -- pay_us_rules.g_id_flex_num := l_id_flex_num;
1978: CLOSE get_id_flex_num;

Line 1981: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);

1977: -- pay_us_rules.g_id_flex_num := l_id_flex_num;
1978: CLOSE get_id_flex_num;
1979: --END IF;
1980:
1981: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);
1982: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
1983: hr_utility.trace('assignment_action_id=' || assignment_action_id);
1984: hr_utility.trace('assignment_id=' || assignment_id);
1985: hr_utility.trace('business_group_id=' || p_bg_id);

Line 1982: hr_utility.trace('l_id_flex_num '||l_id_flex_num);

1978: CLOSE get_id_flex_num;
1979: --END IF;
1980:
1981: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);
1982: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
1983: hr_utility.trace('assignment_action_id=' || assignment_action_id);
1984: hr_utility.trace('assignment_id=' || assignment_id);
1985: hr_utility.trace('business_group_id=' || p_bg_id);
1986: hr_utility.trace('p_range_start=' || p_range_start);

Line 1983: hr_utility.trace('assignment_action_id=' || assignment_action_id);

1979: --END IF;
1980:
1981: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);
1982: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
1983: hr_utility.trace('assignment_action_id=' || assignment_action_id);
1984: hr_utility.trace('assignment_id=' || assignment_id);
1985: hr_utility.trace('business_group_id=' || p_bg_id);
1986: hr_utility.trace('p_range_start=' || p_range_start);
1987: hr_utility.trace('p_range_end=' || p_range_end);

Line 1984: hr_utility.trace('assignment_id=' || assignment_id);

1980:
1981: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);
1982: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
1983: hr_utility.trace('assignment_action_id=' || assignment_action_id);
1984: hr_utility.trace('assignment_id=' || assignment_id);
1985: hr_utility.trace('business_group_id=' || p_bg_id);
1986: hr_utility.trace('p_range_start=' || p_range_start);
1987: hr_utility.trace('p_range_end=' || p_range_end);
1988: hr_utility.trace('element_entry_id=' || element_entry_id);

Line 1985: hr_utility.trace('business_group_id=' || p_bg_id);

1981: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);
1982: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
1983: hr_utility.trace('assignment_action_id=' || assignment_action_id);
1984: hr_utility.trace('assignment_id=' || assignment_id);
1985: hr_utility.trace('business_group_id=' || p_bg_id);
1986: hr_utility.trace('p_range_start=' || p_range_start);
1987: hr_utility.trace('p_range_end=' || p_range_end);
1988: hr_utility.trace('element_entry_id=' || element_entry_id);
1989: hr_utility.trace('date_earned ' || date_earned);

Line 1986: hr_utility.trace('p_range_start=' || p_range_start);

1982: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
1983: hr_utility.trace('assignment_action_id=' || assignment_action_id);
1984: hr_utility.trace('assignment_id=' || assignment_id);
1985: hr_utility.trace('business_group_id=' || p_bg_id);
1986: hr_utility.trace('p_range_start=' || p_range_start);
1987: hr_utility.trace('p_range_end=' || p_range_end);
1988: hr_utility.trace('element_entry_id=' || element_entry_id);
1989: hr_utility.trace('date_earned ' || date_earned);
1990:

Line 1987: hr_utility.trace('p_range_end=' || p_range_end);

1983: hr_utility.trace('assignment_action_id=' || assignment_action_id);
1984: hr_utility.trace('assignment_id=' || assignment_id);
1985: hr_utility.trace('business_group_id=' || p_bg_id);
1986: hr_utility.trace('p_range_start=' || p_range_start);
1987: hr_utility.trace('p_range_end=' || p_range_end);
1988: hr_utility.trace('element_entry_id=' || element_entry_id);
1989: hr_utility.trace('date_earned ' || date_earned);
1990:
1991: /* get work schedule_name */

Line 1988: hr_utility.trace('element_entry_id=' || element_entry_id);

1984: hr_utility.trace('assignment_id=' || assignment_id);
1985: hr_utility.trace('business_group_id=' || p_bg_id);
1986: hr_utility.trace('p_range_start=' || p_range_start);
1987: hr_utility.trace('p_range_end=' || p_range_end);
1988: hr_utility.trace('element_entry_id=' || element_entry_id);
1989: hr_utility.trace('date_earned ' || date_earned);
1990:
1991: /* get work schedule_name */
1992: --IF pay_us_rules.g_id_flex_num IS NOT NULL THEN

Line 1989: hr_utility.trace('date_earned ' || date_earned);

1985: hr_utility.trace('business_group_id=' || p_bg_id);
1986: hr_utility.trace('p_range_start=' || p_range_start);
1987: hr_utility.trace('p_range_end=' || p_range_end);
1988: hr_utility.trace('element_entry_id=' || element_entry_id);
1989: hr_utility.trace('date_earned ' || date_earned);
1990:
1991: /* get work schedule_name */
1992: --IF pay_us_rules.g_id_flex_num IS NOT NULL THEN
1993: IF l_id_flex_num IS NOT NULL THEN

Line 1994: hr_utility.trace('getting work schedule name ');

1990:
1991: /* get work schedule_name */
1992: --IF pay_us_rules.g_id_flex_num IS NOT NULL THEN
1993: IF l_id_flex_num IS NOT NULL THEN
1994: hr_utility.trace('getting work schedule name ');
1995: OPEN get_ws_name (l_id_flex_num,--pay_us_rules.g_id_flex_num,
1996: date_earned,
1997: assignment_id);
1998: FETCH get_ws_name INTO p_ws_name;

Line 2003: hr_utility.trace('Work Schedule not found ');

1999: CLOSE get_ws_name;
2000: END IF;
2001:
2002: IF p_ws_name IS NULL THEN
2003: hr_utility.trace('Work Schedule not found ');
2004: p_wk_sch_found := 'FALSE';
2005: return 0;
2006: END IF;
2007:

Line 2008: hr_utility.trace('Work Schedule '||p_ws_name);

2004: p_wk_sch_found := 'FALSE';
2005: return 0;
2006: END IF;
2007:
2008: hr_utility.trace('Work Schedule '||p_ws_name);
2009:
2010: --changed to select the work schedule defined
2011: --at the business group level instead of
2012: --hardcoding the default work schedule

Line 2042: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');

2038: IF v_range_start > v_range_end THEN
2039: --
2040: p_wk_sch_found := 'FALSE';
2041: RETURN v_total_hours;
2042: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
2043: -- hr_utility.raise_error;
2044: --
2045: END IF;
2046:

Line 2043: -- hr_utility.raise_error;

2039: --
2040: p_wk_sch_found := 'FALSE';
2041: RETURN v_total_hours;
2042: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
2043: -- hr_utility.raise_error;
2044: --
2045: END IF;
2046:
2047: -- Get_Table_Value requires row in FND_SESSIONS. We must insert this

Line 2184: --hr_utility.trace_on(null, 'TIME');

2180: ln_def_time_def number;
2181:
2182: BEGIN
2183:
2184: --hr_utility.trace_on(null, 'TIME');
2185: hr_utility.trace('Entering PAY_US_RULES.get_time_def_for_entry');
2186: hr_utility.trace('p_assignment_id=' || p_assignment_id);
2187: hr_utility.trace('p_assignment_action_id='|| p_assignment_action_id);
2188: hr_utility.trace('p_business_group_id=' || p_business_group_id);

Line 2185: hr_utility.trace('Entering PAY_US_RULES.get_time_def_for_entry');

2181:
2182: BEGIN
2183:
2184: --hr_utility.trace_on(null, 'TIME');
2185: hr_utility.trace('Entering PAY_US_RULES.get_time_def_for_entry');
2186: hr_utility.trace('p_assignment_id=' || p_assignment_id);
2187: hr_utility.trace('p_assignment_action_id='|| p_assignment_action_id);
2188: hr_utility.trace('p_business_group_id=' || p_business_group_id);
2189: hr_utility.trace('p_element_entry_id=' || p_element_entry_id);

Line 2186: hr_utility.trace('p_assignment_id=' || p_assignment_id);

2182: BEGIN
2183:
2184: --hr_utility.trace_on(null, 'TIME');
2185: hr_utility.trace('Entering PAY_US_RULES.get_time_def_for_entry');
2186: hr_utility.trace('p_assignment_id=' || p_assignment_id);
2187: hr_utility.trace('p_assignment_action_id='|| p_assignment_action_id);
2188: hr_utility.trace('p_business_group_id=' || p_business_group_id);
2189: hr_utility.trace('p_element_entry_id=' || p_element_entry_id);
2190:

Line 2187: hr_utility.trace('p_assignment_action_id='|| p_assignment_action_id);

2183:
2184: --hr_utility.trace_on(null, 'TIME');
2185: hr_utility.trace('Entering PAY_US_RULES.get_time_def_for_entry');
2186: hr_utility.trace('p_assignment_id=' || p_assignment_id);
2187: hr_utility.trace('p_assignment_action_id='|| p_assignment_action_id);
2188: hr_utility.trace('p_business_group_id=' || p_business_group_id);
2189: hr_utility.trace('p_element_entry_id=' || p_element_entry_id);
2190:
2191: -- Check if it is the same assignment id, return the value already stored

Line 2188: hr_utility.trace('p_business_group_id=' || p_business_group_id);

2184: --hr_utility.trace_on(null, 'TIME');
2185: hr_utility.trace('Entering PAY_US_RULES.get_time_def_for_entry');
2186: hr_utility.trace('p_assignment_id=' || p_assignment_id);
2187: hr_utility.trace('p_assignment_action_id='|| p_assignment_action_id);
2188: hr_utility.trace('p_business_group_id=' || p_business_group_id);
2189: hr_utility.trace('p_element_entry_id=' || p_element_entry_id);
2190:
2191: -- Check if it is the same assignment id, return the value already stored
2192:

Line 2189: hr_utility.trace('p_element_entry_id=' || p_element_entry_id);

2185: hr_utility.trace('Entering PAY_US_RULES.get_time_def_for_entry');
2186: hr_utility.trace('p_assignment_id=' || p_assignment_id);
2187: hr_utility.trace('p_assignment_action_id='|| p_assignment_action_id);
2188: hr_utility.trace('p_business_group_id=' || p_business_group_id);
2189: hr_utility.trace('p_element_entry_id=' || p_element_entry_id);
2190:
2191: -- Check if it is the same assignment id, return the value already stored
2192:
2193: if g_current_asg_id = p_assignment_id then

Line 2233: hr_utility.trace('Finding Time Definition ID');

2229: else
2230: p_time_definition_id := g_current_time_def_id;
2231: end if;
2232: else
2233: hr_utility.trace('Finding Time Definition ID');
2234: -- find the Date Earned of the payroll period
2235: open get_date_earned (p_assignment_action_id);
2236: fetch get_date_earned into l_date_earned;
2237: close get_date_earned;

Line 2267: hr_utility.trace('p_time_definition_id = ' || p_time_definition_id);

2263: p_time_definition_id := l_time_definition_id;
2264: g_current_asg_id := p_assignment_id;
2265: end if;
2266:
2267: hr_utility.trace('p_time_definition_id = ' || p_time_definition_id);
2268: hr_utility.trace('Leaving PAY_US_RULES.get_time_def_for_entry');
2269: return;
2270: END;
2271:

Line 2268: hr_utility.trace('Leaving PAY_US_RULES.get_time_def_for_entry');

2264: g_current_asg_id := p_assignment_id;
2265: end if;
2266:
2267: hr_utility.trace('p_time_definition_id = ' || p_time_definition_id);
2268: hr_utility.trace('Leaving PAY_US_RULES.get_time_def_for_entry');
2269: return;
2270: END;
2271:
2272:

Line 2276: * or insert data into any database tables. No calls to hr_utility.trace *

2272:
2273: /*****************************************************************************
2274: * PROCEDURE get_time_def_for_entry_func *
2275: * This procedure has to maintain purity and not write into global variables *
2276: * or insert data into any database tables. No calls to hr_utility.trace *
2277: * should be made. *
2278: /****************************************************************************/
2279: FUNCTION get_time_def_for_entry_func(
2280: p_element_entry_id NUMBER,

Line 2721: hr_utility.trace ('Entering '|| 'pay_us_rules.add_custom_xml');

2717: lv_employer_zip_code pay_action_information.action_information12%type;
2718: lv_employer_country pay_action_information.action_information13%type;
2719:
2720: BEGIN
2721: hr_utility.trace ('Entering '|| 'pay_us_rules.add_custom_xml');
2722: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
2723: hr_utility.trace('p_action_information_category '|| p_action_information_category);
2724: hr_utility.trace('p_document_type '|| p_document_type);
2725:

Line 2722: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);

2718: lv_employer_country pay_action_information.action_information13%type;
2719:
2720: BEGIN
2721: hr_utility.trace ('Entering '|| 'pay_us_rules.add_custom_xml');
2722: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
2723: hr_utility.trace('p_action_information_category '|| p_action_information_category);
2724: hr_utility.trace('p_document_type '|| p_document_type);
2725:
2726: /* Added the code for US pdf payslip enhancement bug:9382065 */

Line 2723: hr_utility.trace('p_action_information_category '|| p_action_information_category);

2719:
2720: BEGIN
2721: hr_utility.trace ('Entering '|| 'pay_us_rules.add_custom_xml');
2722: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
2723: hr_utility.trace('p_action_information_category '|| p_action_information_category);
2724: hr_utility.trace('p_document_type '|| p_document_type);
2725:
2726: /* Added the code for US pdf payslip enhancement bug:9382065 */
2727: IF p_document_type = 'PAYSLIP'

Line 2724: hr_utility.trace('p_document_type '|| p_document_type);

2720: BEGIN
2721: hr_utility.trace ('Entering '|| 'pay_us_rules.add_custom_xml');
2722: hr_utility.trace('p_assignment_action_id '|| p_assignment_action_id);
2723: hr_utility.trace('p_action_information_category '|| p_action_information_category);
2724: hr_utility.trace('p_document_type '|| p_document_type);
2725:
2726: /* Added the code for US pdf payslip enhancement bug:9382065 */
2727: IF p_document_type = 'PAYSLIP'
2728: AND p_action_information_category IS NULL THEN

Line 2948: hr_utility.trace('exiting PAY_US_RULES.add_custom_xml');

2944: /* Put transit info here*/
2945:
2946: END IF;
2947: -- 13029999 end
2948: hr_utility.trace('exiting PAY_US_RULES.add_custom_xml');
2949: END add_custom_xml;
2950:
2951:
2952: FUNCTION CF_word_amountFormula(CP_LN_AMOUNT IN NUMBER) RETURN VARCHAR2 IS

Line 3116: hr_utility.trace('Entering pay_us_rules.payslip_range_cursor');

3112:
3113: lv_sqlstr VARCHAR2(32000);
3114:
3115: BEGIN
3116: hr_utility.trace('Entering pay_us_rules.payslip_range_cursor');
3117: lv_sqlstr := NULL;
3118: pay_us_deposit_advice_pkg.DAxml_range_cursor(pactid => p_pactid
3119: ,psqlstr => lv_sqlstr);
3120: hr_utility.trace('Returning lv_sqlstr := ' || lv_sqlstr);

Line 3120: hr_utility.trace('Returning lv_sqlstr := ' || lv_sqlstr);

3116: hr_utility.trace('Entering pay_us_rules.payslip_range_cursor');
3117: lv_sqlstr := NULL;
3118: pay_us_deposit_advice_pkg.DAxml_range_cursor(pactid => p_pactid
3119: ,psqlstr => lv_sqlstr);
3120: hr_utility.trace('Returning lv_sqlstr := ' || lv_sqlstr);
3121:
3122: p_sqlstr := lv_sqlstr;
3123:
3124: END payslip_range_cursor;