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 263: hr_utility.trace('Entering '||l_proc_name);

259:
260: BEGIN
261: l_pkg_name := 'pay_us_rules.';
262: l_proc_name := l_pkg_name||'default_jurisdiction';
263: hr_utility.trace('Entering '||l_proc_name);
264:
265: open csr_ele_classification;
266: fetch csr_ele_classification into l_ele_classification;
267: close csr_ele_classification;

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

265: open csr_ele_classification;
266: fetch csr_ele_classification into l_ele_classification;
267: close csr_ele_classification;
268:
269: hr_utility.trace('Classification of element entry id '|| p_ee_id ||' is '||l_ele_classification);
270:
271: if l_ele_classification = 'Involuntary Deductions' then
272: open csr_wrk_at_home;
273: fetch csr_wrk_at_home into l_asg_wrk_at_home;

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

288: p_jurisdiction := hr_us_ff_udfs.addr_val (l_override_adr_region_2,
289: l_override_adr_region_1,
290: l_override_adr_city,
291: l_override_adr_postal_code);
292: hr_utility.trace('Default jurisdiction code is '||p_jurisdiction);
293: end if;
294: hr_utility.trace('Leaving '||l_proc_name);
295: END get_default_jurisdiction;
296:

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

290: l_override_adr_city,
291: l_override_adr_postal_code);
292: hr_utility.trace('Default jurisdiction code is '||p_jurisdiction);
293: end if;
294: hr_utility.trace('Leaving '||l_proc_name);
295: END get_default_jurisdiction;
296:
297:
298: /****************************************************************************/

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

301:
302: FUNCTION element_template_pre_process (p_rec IN pay_ele_tmplt_obj)
303: RETURN pay_ele_tmplt_obj IS
304: BEGIN
305: hr_utility.TRACE ('Entering pay_us_rules.element_template_pre_process');
306: hr_utility.TRACE ('Legislation Code ' || lrec.legislation_code);
307: -- INITIALIZING THE GLOBAL VARIABLE
308: lrec := NULL;
309: -- DEFAULTING TO input VARIABLE

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

302: FUNCTION element_template_pre_process (p_rec IN pay_ele_tmplt_obj)
303: RETURN pay_ele_tmplt_obj IS
304: BEGIN
305: hr_utility.TRACE ('Entering pay_us_rules.element_template_pre_process');
306: hr_utility.TRACE ('Legislation Code ' || lrec.legislation_code);
307: -- INITIALIZING THE GLOBAL VARIABLE
308: lrec := NULL;
309: -- DEFAULTING TO input VARIABLE
310: lrec := p_rec;

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

632: ) THEN
633: lrec.configuration_information14 := 'Y';
634: END IF;
635:
636: hr_utility.trace('CONFIG1 = ' || lrec.configuration_information1);
637: hr_utility.trace('CONFIG2 = ' || lrec.configuration_information2);
638: hr_utility.trace('CONFIG3 = ' || lrec.configuration_information3);
639: hr_utility.trace('CONFIG4 = ' || lrec.configuration_information4);
640: hr_utility.trace('CONFIG5 = ' || lrec.configuration_information5);

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

633: lrec.configuration_information14 := 'Y';
634: END IF;
635:
636: hr_utility.trace('CONFIG1 = ' || lrec.configuration_information1);
637: hr_utility.trace('CONFIG2 = ' || lrec.configuration_information2);
638: hr_utility.trace('CONFIG3 = ' || lrec.configuration_information3);
639: hr_utility.trace('CONFIG4 = ' || lrec.configuration_information4);
640: hr_utility.trace('CONFIG5 = ' || lrec.configuration_information5);
641: hr_utility.trace('CONFIG6 = ' || lrec.configuration_information6);

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

634: END IF;
635:
636: hr_utility.trace('CONFIG1 = ' || lrec.configuration_information1);
637: hr_utility.trace('CONFIG2 = ' || lrec.configuration_information2);
638: hr_utility.trace('CONFIG3 = ' || lrec.configuration_information3);
639: hr_utility.trace('CONFIG4 = ' || lrec.configuration_information4);
640: hr_utility.trace('CONFIG5 = ' || lrec.configuration_information5);
641: hr_utility.trace('CONFIG6 = ' || lrec.configuration_information6);
642: hr_utility.trace('CONFIG7 = ' || lrec.configuration_information7);

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

635:
636: hr_utility.trace('CONFIG1 = ' || lrec.configuration_information1);
637: hr_utility.trace('CONFIG2 = ' || lrec.configuration_information2);
638: hr_utility.trace('CONFIG3 = ' || lrec.configuration_information3);
639: hr_utility.trace('CONFIG4 = ' || lrec.configuration_information4);
640: hr_utility.trace('CONFIG5 = ' || lrec.configuration_information5);
641: hr_utility.trace('CONFIG6 = ' || lrec.configuration_information6);
642: hr_utility.trace('CONFIG7 = ' || lrec.configuration_information7);
643: hr_utility.trace('CONFIG8 = ' || lrec.configuration_information8);

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

636: hr_utility.trace('CONFIG1 = ' || lrec.configuration_information1);
637: hr_utility.trace('CONFIG2 = ' || lrec.configuration_information2);
638: hr_utility.trace('CONFIG3 = ' || lrec.configuration_information3);
639: hr_utility.trace('CONFIG4 = ' || lrec.configuration_information4);
640: hr_utility.trace('CONFIG5 = ' || lrec.configuration_information5);
641: hr_utility.trace('CONFIG6 = ' || lrec.configuration_information6);
642: hr_utility.trace('CONFIG7 = ' || lrec.configuration_information7);
643: hr_utility.trace('CONFIG8 = ' || lrec.configuration_information8);
644: hr_utility.trace('CONFIG9 = ' || lrec.configuration_information9);

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

637: hr_utility.trace('CONFIG2 = ' || lrec.configuration_information2);
638: hr_utility.trace('CONFIG3 = ' || lrec.configuration_information3);
639: hr_utility.trace('CONFIG4 = ' || lrec.configuration_information4);
640: hr_utility.trace('CONFIG5 = ' || lrec.configuration_information5);
641: hr_utility.trace('CONFIG6 = ' || lrec.configuration_information6);
642: hr_utility.trace('CONFIG7 = ' || lrec.configuration_information7);
643: hr_utility.trace('CONFIG8 = ' || lrec.configuration_information8);
644: hr_utility.trace('CONFIG9 = ' || lrec.configuration_information9);
645: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);

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

638: hr_utility.trace('CONFIG3 = ' || lrec.configuration_information3);
639: hr_utility.trace('CONFIG4 = ' || lrec.configuration_information4);
640: hr_utility.trace('CONFIG5 = ' || lrec.configuration_information5);
641: hr_utility.trace('CONFIG6 = ' || lrec.configuration_information6);
642: hr_utility.trace('CONFIG7 = ' || lrec.configuration_information7);
643: hr_utility.trace('CONFIG8 = ' || lrec.configuration_information8);
644: hr_utility.trace('CONFIG9 = ' || lrec.configuration_information9);
645: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
646: hr_utility.trace('CONFIG11 = ' || lrec.configuration_information11);

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

639: hr_utility.trace('CONFIG4 = ' || lrec.configuration_information4);
640: hr_utility.trace('CONFIG5 = ' || lrec.configuration_information5);
641: hr_utility.trace('CONFIG6 = ' || lrec.configuration_information6);
642: hr_utility.trace('CONFIG7 = ' || lrec.configuration_information7);
643: hr_utility.trace('CONFIG8 = ' || lrec.configuration_information8);
644: hr_utility.trace('CONFIG9 = ' || lrec.configuration_information9);
645: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
646: hr_utility.trace('CONFIG11 = ' || lrec.configuration_information11);
647: hr_utility.trace('CONFIG12 = ' || lrec.configuration_information12);

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

640: hr_utility.trace('CONFIG5 = ' || lrec.configuration_information5);
641: hr_utility.trace('CONFIG6 = ' || lrec.configuration_information6);
642: hr_utility.trace('CONFIG7 = ' || lrec.configuration_information7);
643: hr_utility.trace('CONFIG8 = ' || lrec.configuration_information8);
644: hr_utility.trace('CONFIG9 = ' || lrec.configuration_information9);
645: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
646: hr_utility.trace('CONFIG11 = ' || lrec.configuration_information11);
647: hr_utility.trace('CONFIG12 = ' || lrec.configuration_information12);
648: hr_utility.trace('CONFIG13 = ' || lrec.configuration_information13);

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

641: hr_utility.trace('CONFIG6 = ' || lrec.configuration_information6);
642: hr_utility.trace('CONFIG7 = ' || lrec.configuration_information7);
643: hr_utility.trace('CONFIG8 = ' || lrec.configuration_information8);
644: hr_utility.trace('CONFIG9 = ' || lrec.configuration_information9);
645: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
646: hr_utility.trace('CONFIG11 = ' || lrec.configuration_information11);
647: hr_utility.trace('CONFIG12 = ' || lrec.configuration_information12);
648: hr_utility.trace('CONFIG13 = ' || lrec.configuration_information13);
649: hr_utility.trace('CONFIG14 = ' || lrec.configuration_information14);

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

642: hr_utility.trace('CONFIG7 = ' || lrec.configuration_information7);
643: hr_utility.trace('CONFIG8 = ' || lrec.configuration_information8);
644: hr_utility.trace('CONFIG9 = ' || lrec.configuration_information9);
645: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
646: hr_utility.trace('CONFIG11 = ' || lrec.configuration_information11);
647: hr_utility.trace('CONFIG12 = ' || lrec.configuration_information12);
648: hr_utility.trace('CONFIG13 = ' || lrec.configuration_information13);
649: hr_utility.trace('CONFIG14 = ' || lrec.configuration_information14);
650: hr_utility.trace('CONFIG15 = ' || lrec.configuration_information15);

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

643: hr_utility.trace('CONFIG8 = ' || lrec.configuration_information8);
644: hr_utility.trace('CONFIG9 = ' || lrec.configuration_information9);
645: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
646: hr_utility.trace('CONFIG11 = ' || lrec.configuration_information11);
647: hr_utility.trace('CONFIG12 = ' || lrec.configuration_information12);
648: hr_utility.trace('CONFIG13 = ' || lrec.configuration_information13);
649: hr_utility.trace('CONFIG14 = ' || lrec.configuration_information14);
650: hr_utility.trace('CONFIG15 = ' || lrec.configuration_information15);
651: hr_utility.trace('Priority = ' || lrec.processing_priority);

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

644: hr_utility.trace('CONFIG9 = ' || lrec.configuration_information9);
645: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
646: hr_utility.trace('CONFIG11 = ' || lrec.configuration_information11);
647: hr_utility.trace('CONFIG12 = ' || lrec.configuration_information12);
648: hr_utility.trace('CONFIG13 = ' || lrec.configuration_information13);
649: hr_utility.trace('CONFIG14 = ' || lrec.configuration_information14);
650: hr_utility.trace('CONFIG15 = ' || lrec.configuration_information15);
651: hr_utility.trace('Priority = ' || lrec.processing_priority);
652:

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

645: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
646: hr_utility.trace('CONFIG11 = ' || lrec.configuration_information11);
647: hr_utility.trace('CONFIG12 = ' || lrec.configuration_information12);
648: hr_utility.trace('CONFIG13 = ' || lrec.configuration_information13);
649: hr_utility.trace('CONFIG14 = ' || lrec.configuration_information14);
650: hr_utility.trace('CONFIG15 = ' || lrec.configuration_information15);
651: hr_utility.trace('Priority = ' || lrec.processing_priority);
652:
653: -- hr_utility.trace_off();

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

646: hr_utility.trace('CONFIG11 = ' || lrec.configuration_information11);
647: hr_utility.trace('CONFIG12 = ' || lrec.configuration_information12);
648: hr_utility.trace('CONFIG13 = ' || lrec.configuration_information13);
649: hr_utility.trace('CONFIG14 = ' || lrec.configuration_information14);
650: hr_utility.trace('CONFIG15 = ' || lrec.configuration_information15);
651: hr_utility.trace('Priority = ' || lrec.processing_priority);
652:
653: -- hr_utility.trace_off();
654:

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

647: hr_utility.trace('CONFIG12 = ' || lrec.configuration_information12);
648: hr_utility.trace('CONFIG13 = ' || lrec.configuration_information13);
649: hr_utility.trace('CONFIG14 = ' || lrec.configuration_information14);
650: hr_utility.trace('CONFIG15 = ' || lrec.configuration_information15);
651: hr_utility.trace('Priority = ' || lrec.processing_priority);
652:
653: -- hr_utility.trace_off();
654:
655: END IF; /* IF (lrec.calculation_rule = 'US Earnings') */

Line 653: -- hr_utility.trace_off();

649: hr_utility.trace('CONFIG14 = ' || lrec.configuration_information14);
650: hr_utility.trace('CONFIG15 = ' || lrec.configuration_information15);
651: hr_utility.trace('Priority = ' || lrec.processing_priority);
652:
653: -- hr_utility.trace_off();
654:
655: END IF; /* IF (lrec.calculation_rule = 'US Earnings') */
656:
657: -----------------------------------------------------------------

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

667: IF lrec.process_mode = 'N' THEN-- value sent as N for earnings
668: lrec.process_mode := 'S';
669: END IF;
670:
671: hr_utility.TRACE ('Leaving pay_us_rules.element_template_pre_process');
672: RETURN lrec;
673: END element_template_pre_process;
674:
675: /****************************************************************************/

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

708: ln_sf_process_priority NUMBER(9);
709: ln_fc_process_priority NUMBER(9);
710: ln_fpa_process_priority NUMBER(9);
711: BEGIN
712: hr_utility.TRACE ('Entering pay_us_rules.element_template_upd_user_stru');
713: hr_utility.TRACE ('p_element_template_id ' || p_element_template_id);
714:
715: -----------------------------------------------------------
716: -- Update Base shadow Element with user-specified details

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

709: ln_fc_process_priority NUMBER(9);
710: ln_fpa_process_priority NUMBER(9);
711: BEGIN
712: hr_utility.TRACE ('Entering pay_us_rules.element_template_upd_user_stru');
713: hr_utility.TRACE ('p_element_template_id ' || p_element_template_id);
714:
715: -----------------------------------------------------------
716: -- Update Base shadow Element with user-specified details
717: -----------------------------------------------------------

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

920: ,p_object_version_number => l_ovn
921: );
922: END IF;
923:
924: hr_utility.TRACE ('Leaving pay_us_rules.element_template_upd_user_stru');
925: END element_template_upd_user_stru;
926:
927: /****************************************************************************/
928: /* PROCEDURE element_template_post_process */

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

1087: legislation_code will be present
1088: */
1089:
1090: BEGIN
1091: hr_utility.TRACE ('Entering pay_us_rules.element_template_post_process');
1092: hr_utility.TRACE ('p_element_template_id ' || p_element_template_id);
1093:
1094: -- FLSA Changes
1095: IF (lrec.calculation_rule = 'US ' || lrec.element_classification) THEN

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

1088: */
1089:
1090: BEGIN
1091: hr_utility.TRACE ('Entering pay_us_rules.element_template_post_process');
1092: hr_utility.TRACE ('p_element_template_id ' || p_element_template_id);
1093:
1094: -- FLSA Changes
1095: IF (lrec.calculation_rule = 'US ' || lrec.element_classification) THEN
1096: lv_hoursXrate := 'N'; --lrec.configuration_information4;

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

1448: ,p_effective_end_date => l_fc_eff_end_date
1449: ,p_object_version_number => l_fc_obj_ver_num
1450: );
1451: ELSE
1452: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');
1453: hr_utility.TRACE ('Error in fetching formula id for FLSA_PREMIUM_AMOUNT_CALCULATION');
1454: END IF;/*End of c_formula_id%FOUND*/
1455:
1456: CLOSE c_formula_id;

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

1449: ,p_object_version_number => l_fc_obj_ver_num
1450: );
1451: ELSE
1452: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');
1453: hr_utility.TRACE ('Error in fetching formula id for FLSA_PREMIUM_AMOUNT_CALCULATION');
1454: END IF;/*End of c_formula_id%FOUND*/
1455:
1456: CLOSE c_formula_id;
1457:

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

1464: SET proration_group_id = ln_proration_group_id
1465: WHERE business_group_id = ln_business_group_id
1466: AND element_type_id = l_fc_ele_type_id;
1467: ELSE
1468: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');
1469: hr_utility.TRACE ('Error in fetching proration group id for Entry Changes for Proration');
1470: END IF;
1471: CLOSE get_proration_group_id;
1472:

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

1465: WHERE business_group_id = ln_business_group_id
1466: AND element_type_id = l_fc_ele_type_id;
1467: ELSE
1468: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');
1469: hr_utility.TRACE ('Error in fetching proration group id for Entry Changes for Proration');
1470: END IF;
1471: CLOSE get_proration_group_id;
1472:
1473:

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

1501: ,p_replace_run_flag => 'N'
1502: ,p_use_override_dates => 'N'
1503: );
1504: ELSE
1505: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');
1506: hr_utility.TRACE ('Error in fetching retro component id');
1507: END IF;
1508: CLOSE get_retro_comp_id;
1509: ELSE

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

1502: ,p_use_override_dates => 'N'
1503: );
1504: ELSE
1505: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');
1506: hr_utility.TRACE ('Error in fetching retro component id');
1507: END IF;
1508: CLOSE get_retro_comp_id;
1509: ELSE
1510: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');

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

1506: hr_utility.TRACE ('Error in fetching retro component id');
1507: END IF;
1508: CLOSE get_retro_comp_id;
1509: ELSE
1510: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');
1511: hr_utility.TRACE ('Error in fetching retro group id for Entry Changes');
1512: END IF;
1513: CLOSE get_proration_group_id;
1514:

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

1507: END IF;
1508: CLOSE get_retro_comp_id;
1509: ELSE
1510: hr_utility.TRACE ('Error in pay_us_rules.element_template_post_process');
1511: hr_utility.TRACE ('Error in fetching retro group id for Entry Changes');
1512: END IF;
1513: CLOSE get_proration_group_id;
1514:
1515:

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

1594: -- FLSA Changes
1595: -- Modifying the TIME_DEFINTION_TYPE for FLSA elements to 'G'
1596: -- if the elements are created using FLSA template or the
1597: -- element has FLSA Earnings checked
1598: hr_utility.trace('Calc Rule = ' || lrec.calculation_rule);
1599: hr_utility.trace('Ele Class = ' || lrec.element_classification);
1600: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
1601: IF (lrec.calculation_rule = 'US FLSA ' || lrec.element_classification) THEN
1602: IF (lrec.configuration_information10 = 'N') then

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

1595: -- Modifying the TIME_DEFINTION_TYPE for FLSA elements to 'G'
1596: -- if the elements are created using FLSA template or the
1597: -- element has FLSA Earnings checked
1598: hr_utility.trace('Calc Rule = ' || lrec.calculation_rule);
1599: hr_utility.trace('Ele Class = ' || lrec.element_classification);
1600: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
1601: IF (lrec.calculation_rule = 'US FLSA ' || lrec.element_classification) THEN
1602: IF (lrec.configuration_information10 = 'N') then
1603: hr_utility.trace('1. Updating Time Definition Type to G');

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

1596: -- if the elements are created using FLSA template or the
1597: -- element has FLSA Earnings checked
1598: hr_utility.trace('Calc Rule = ' || lrec.calculation_rule);
1599: hr_utility.trace('Ele Class = ' || lrec.element_classification);
1600: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
1601: IF (lrec.calculation_rule = 'US FLSA ' || lrec.element_classification) THEN
1602: IF (lrec.configuration_information10 = 'N') then
1603: hr_utility.trace('1. Updating Time Definition Type to G');
1604: UPDATE pay_element_types_f

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

1599: hr_utility.trace('Ele Class = ' || lrec.element_classification);
1600: hr_utility.trace('CONFIG10 = ' || lrec.configuration_information10);
1601: IF (lrec.calculation_rule = 'US FLSA ' || lrec.element_classification) THEN
1602: IF (lrec.configuration_information10 = 'N') then
1603: hr_utility.trace('1. Updating Time Definition Type to G');
1604: UPDATE pay_element_types_f
1605: SET time_definition_type = 'G'
1606: WHERE business_group_id = ln_business_group_id
1607: AND element_type_id in ( pay_us_earn_templ_wrapper.g_ele_type_id

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

1607: AND element_type_id in ( pay_us_earn_templ_wrapper.g_ele_type_id
1608: ,l_fpa_ele_type_id);
1609: END IF;
1610: ELSIF lrec.configuration_information7 = 'Y' THEN
1611: hr_utility.trace('2. Updating Time Definition Type to G');
1612: UPDATE pay_element_types_f
1613: SET time_definition_type = 'G'
1614: WHERE business_group_id = ln_business_group_id
1615: AND element_type_id = pay_us_earn_templ_wrapper.g_ele_type_id;

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

1616: END IF;
1617:
1618: -- Modifying the TIME_DEFINTION_TYPE for Augment elements to 'G'
1619: IF ((lrec.calculation_rule = 'US ' || lrec.element_classification) AND lrec.configuration_information24 = 'Y') THEN
1620: hr_utility.trace('2. Updating Time Definition Type to G');
1621: UPDATE pay_element_types_f
1622: SET time_definition_type = 'G'
1623: WHERE business_group_id = ln_business_group_id
1624: AND element_type_id = l_fc_ele_type_id;

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

1624: AND element_type_id = l_fc_ele_type_id;
1625: END IF;
1626:
1627:
1628: hr_utility.TRACE ('Leaving pay_us_rules.element_template_post_process');
1629: END element_template_post_process;
1630:
1631: /****************************************************************************/
1632: /* PROCEDURE delete_pre_process */

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

1697:
1698:
1699: BEGIN
1700:
1701: hr_utility.TRACE ('Entering pay_us_rules.delete_pre_process');
1702:
1703: OPEN c_ele_name(pay_us_earn_templ_wrapper.g_ele_type_id);
1704: FETCH c_ele_name INTO lv_ele_name
1705: , lv_business_group_id

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

1750: ,p_effective_start_date => l_eff_start_date
1751: ,p_effective_end_date => l_eff_end_date
1752: );
1753: ELSE
1754: hr_utility.TRACE ('pay_formula_result_rules_f does not return any row');
1755: END IF;/*c_for_res_rule%FOUND*/
1756: CLOSE c_for_res_rule;
1757:
1758: pay_status_processing_rule_api.delete_status_process_rule

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

1764: ,p_effective_start_date => l_eff_start_date
1765: ,p_effective_end_date => l_eff_end_date
1766: );
1767: ELSE
1768: hr_utility.TRACE ('pay_status_processing_rules_f does not return any row');
1769: END IF;/*c_stat_proc_rule%FOUND*/
1770: CLOSE c_stat_proc_rule;
1771:
1772: END IF;/*l_shadow_ele_type_id IS NOT NULL*/

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

1772: END IF;/*l_shadow_ele_type_id IS NOT NULL*/
1773: END LOOP;/*tshadoweledetails.FIRST .. tshadoweledetails.LAST*/
1774:
1775: ELSE
1776: hr_utility.TRACE ('Error in pay_us_rules.delete_pre_process');
1777: hr_utility.TRACE ('Element Type Id passed does not have a row in pay_element_types_f');
1778: END IF;/*c_ele_name%FOUND*/
1779: CLOSE c_ele_name;
1780:

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

1773: END LOOP;/*tshadoweledetails.FIRST .. tshadoweledetails.LAST*/
1774:
1775: ELSE
1776: hr_utility.TRACE ('Error in pay_us_rules.delete_pre_process');
1777: hr_utility.TRACE ('Element Type Id passed does not have a row in pay_element_types_f');
1778: END IF;/*c_ele_name%FOUND*/
1779: CLOSE c_ele_name;
1780:
1781: hr_utility.TRACE ('Leaving pay_us_rules.delete_pre_process');

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

1777: hr_utility.TRACE ('Element Type Id passed does not have a row in pay_element_types_f');
1778: END IF;/*c_ele_name%FOUND*/
1779: CLOSE c_ele_name;
1780:
1781: hr_utility.TRACE ('Leaving pay_us_rules.delete_pre_process');
1782: END delete_pre_process;
1783:
1784: /****************************************************************************/
1785: /* PROCEDURE delete_post_process */

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

1786: /****************************************************************************/
1787:
1788: PROCEDURE delete_post_process(p_element_template_id IN NUMBER) IS
1789: BEGIN
1790: hr_utility.TRACE ('Entering pay_us_rules.delete_post_process');
1791: NULL;
1792: hr_utility.TRACE ('Leaving pay_us_rules.delete_post_process');
1793: END delete_post_process;
1794:

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

1788: PROCEDURE delete_post_process(p_element_template_id IN NUMBER) IS
1789: BEGIN
1790: hr_utility.TRACE ('Entering pay_us_rules.delete_post_process');
1791: NULL;
1792: hr_utility.TRACE ('Leaving pay_us_rules.delete_post_process');
1793: END delete_post_process;
1794:
1795:
1796: --=======================================================================

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

1833: p_business_group_id
1834: AND NVL (pbt.legislation_code, p_legislation_code) = p_legislation_code;
1835: --
1836: BEGIN
1837: hr_utility.set_location ('Entering: ' || l_proc, 10);
1838: l_proc := 'pay_us_earnings_template.get_obj_id';
1839: --
1840: IF p_object_type = 'ELE' THEN
1841: FOR c_rec IN c_element

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

1853: l_object_id := c_rec.input_value_id; -- input value id
1854: END LOOP;
1855: END IF;
1856:
1857: hr_utility.set_location ('Leaving: ' || l_proc, 50);
1858: --
1859: RETURN l_object_id;
1860: END get_obj_id;
1861: --

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

1914: c_ws_tab_name := 'COMPANY WORK SCHEDULES';
1915:
1916: /* get ID FLEX NUM */
1917: --IF pay_us_rules.g_id_flex_num IS NULL THEN
1918: hr_utility.trace('Getting ID_FLEX_NUM for US legislation ');
1919: OPEN get_id_flex_num;
1920: FETCH get_id_flex_num INTO l_id_flex_num;
1921: -- pay_us_rules.g_id_flex_num := l_id_flex_num;
1922: CLOSE get_id_flex_num;

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

1921: -- pay_us_rules.g_id_flex_num := l_id_flex_num;
1922: CLOSE get_id_flex_num;
1923: --END IF;
1924:
1925: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);
1926: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
1927: hr_utility.trace('assignment_action_id=' || assignment_action_id);
1928: hr_utility.trace('assignment_id=' || assignment_id);
1929: hr_utility.trace('business_group_id=' || p_bg_id);

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

1922: CLOSE get_id_flex_num;
1923: --END IF;
1924:
1925: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);
1926: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
1927: hr_utility.trace('assignment_action_id=' || assignment_action_id);
1928: hr_utility.trace('assignment_id=' || assignment_id);
1929: hr_utility.trace('business_group_id=' || p_bg_id);
1930: hr_utility.trace('p_range_start=' || p_range_start);

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

1923: --END IF;
1924:
1925: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);
1926: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
1927: hr_utility.trace('assignment_action_id=' || assignment_action_id);
1928: hr_utility.trace('assignment_id=' || assignment_id);
1929: hr_utility.trace('business_group_id=' || p_bg_id);
1930: hr_utility.trace('p_range_start=' || p_range_start);
1931: hr_utility.trace('p_range_end=' || p_range_end);

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

1924:
1925: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);
1926: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
1927: hr_utility.trace('assignment_action_id=' || assignment_action_id);
1928: hr_utility.trace('assignment_id=' || assignment_id);
1929: hr_utility.trace('business_group_id=' || p_bg_id);
1930: hr_utility.trace('p_range_start=' || p_range_start);
1931: hr_utility.trace('p_range_end=' || p_range_end);
1932: hr_utility.trace('element_entry_id=' || element_entry_id);

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

1925: -- hr_utility.trace('pay_us_rules.g_id_flex_num '||pay_us_rules.g_id_flex_num);
1926: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
1927: hr_utility.trace('assignment_action_id=' || assignment_action_id);
1928: hr_utility.trace('assignment_id=' || assignment_id);
1929: hr_utility.trace('business_group_id=' || p_bg_id);
1930: hr_utility.trace('p_range_start=' || p_range_start);
1931: hr_utility.trace('p_range_end=' || p_range_end);
1932: hr_utility.trace('element_entry_id=' || element_entry_id);
1933: hr_utility.trace('date_earned ' || date_earned);

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

1926: hr_utility.trace('l_id_flex_num '||l_id_flex_num);
1927: hr_utility.trace('assignment_action_id=' || assignment_action_id);
1928: hr_utility.trace('assignment_id=' || assignment_id);
1929: hr_utility.trace('business_group_id=' || p_bg_id);
1930: hr_utility.trace('p_range_start=' || p_range_start);
1931: hr_utility.trace('p_range_end=' || p_range_end);
1932: hr_utility.trace('element_entry_id=' || element_entry_id);
1933: hr_utility.trace('date_earned ' || date_earned);
1934:

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

1927: hr_utility.trace('assignment_action_id=' || assignment_action_id);
1928: hr_utility.trace('assignment_id=' || assignment_id);
1929: hr_utility.trace('business_group_id=' || p_bg_id);
1930: hr_utility.trace('p_range_start=' || p_range_start);
1931: hr_utility.trace('p_range_end=' || p_range_end);
1932: hr_utility.trace('element_entry_id=' || element_entry_id);
1933: hr_utility.trace('date_earned ' || date_earned);
1934:
1935: /* get work schedule_name */

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

1928: hr_utility.trace('assignment_id=' || assignment_id);
1929: hr_utility.trace('business_group_id=' || p_bg_id);
1930: hr_utility.trace('p_range_start=' || p_range_start);
1931: hr_utility.trace('p_range_end=' || p_range_end);
1932: hr_utility.trace('element_entry_id=' || element_entry_id);
1933: hr_utility.trace('date_earned ' || date_earned);
1934:
1935: /* get work schedule_name */
1936: --IF pay_us_rules.g_id_flex_num IS NOT NULL THEN

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

1929: hr_utility.trace('business_group_id=' || p_bg_id);
1930: hr_utility.trace('p_range_start=' || p_range_start);
1931: hr_utility.trace('p_range_end=' || p_range_end);
1932: hr_utility.trace('element_entry_id=' || element_entry_id);
1933: hr_utility.trace('date_earned ' || date_earned);
1934:
1935: /* get work schedule_name */
1936: --IF pay_us_rules.g_id_flex_num IS NOT NULL THEN
1937: IF l_id_flex_num IS NOT NULL THEN

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

1934:
1935: /* get work schedule_name */
1936: --IF pay_us_rules.g_id_flex_num IS NOT NULL THEN
1937: IF l_id_flex_num IS NOT NULL THEN
1938: hr_utility.trace('getting work schedule name ');
1939: OPEN get_ws_name (l_id_flex_num,--pay_us_rules.g_id_flex_num,
1940: date_earned,
1941: assignment_id);
1942: FETCH get_ws_name INTO p_ws_name;

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

1943: CLOSE get_ws_name;
1944: END IF;
1945:
1946: IF p_ws_name IS NULL THEN
1947: hr_utility.trace('Work Schedule not found ');
1948: return 0;
1949: END IF;
1950:
1951: hr_utility.trace('Work Schedule '||p_ws_name);

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

1947: hr_utility.trace('Work Schedule not found ');
1948: return 0;
1949: END IF;
1950:
1951: hr_utility.trace('Work Schedule '||p_ws_name);
1952:
1953: --changed to select the work schedule defined
1954: --at the business group level instead of
1955: --hardcoding the default work schedule

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

1980: -- Check for valid range
1981: IF v_range_start > v_range_end THEN
1982: --
1983: RETURN v_total_hours;
1984: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
1985: -- hr_utility.raise_error;
1986: --
1987: END IF;
1988:

Line 1985: -- hr_utility.raise_error;

1981: IF v_range_start > v_range_end THEN
1982: --
1983: RETURN v_total_hours;
1984: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
1985: -- hr_utility.raise_error;
1986: --
1987: END IF;
1988:
1989: -- Get_Table_Value requires row in FND_SESSIONS. We must insert this

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

2120: ln_def_time_def number;
2121:
2122: BEGIN
2123:
2124: --hr_utility.trace_on(null, 'TIME');
2125: hr_utility.trace('Entering PAY_US_RULES.get_time_def_for_entry');
2126: hr_utility.trace('p_assignment_id=' || p_assignment_id);
2127: hr_utility.trace('p_assignment_action_id='|| p_assignment_action_id);
2128: hr_utility.trace('p_business_group_id=' || p_business_group_id);

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

2121:
2122: BEGIN
2123:
2124: --hr_utility.trace_on(null, 'TIME');
2125: hr_utility.trace('Entering PAY_US_RULES.get_time_def_for_entry');
2126: hr_utility.trace('p_assignment_id=' || p_assignment_id);
2127: hr_utility.trace('p_assignment_action_id='|| p_assignment_action_id);
2128: hr_utility.trace('p_business_group_id=' || p_business_group_id);
2129: hr_utility.trace('p_element_entry_id=' || p_element_entry_id);

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

2122: BEGIN
2123:
2124: --hr_utility.trace_on(null, 'TIME');
2125: hr_utility.trace('Entering PAY_US_RULES.get_time_def_for_entry');
2126: hr_utility.trace('p_assignment_id=' || p_assignment_id);
2127: hr_utility.trace('p_assignment_action_id='|| p_assignment_action_id);
2128: hr_utility.trace('p_business_group_id=' || p_business_group_id);
2129: hr_utility.trace('p_element_entry_id=' || p_element_entry_id);
2130:

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

2123:
2124: --hr_utility.trace_on(null, 'TIME');
2125: hr_utility.trace('Entering PAY_US_RULES.get_time_def_for_entry');
2126: hr_utility.trace('p_assignment_id=' || p_assignment_id);
2127: hr_utility.trace('p_assignment_action_id='|| p_assignment_action_id);
2128: hr_utility.trace('p_business_group_id=' || p_business_group_id);
2129: hr_utility.trace('p_element_entry_id=' || p_element_entry_id);
2130:
2131: -- Check if it is the same assignment id, return the value already stored

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

2124: --hr_utility.trace_on(null, 'TIME');
2125: hr_utility.trace('Entering PAY_US_RULES.get_time_def_for_entry');
2126: hr_utility.trace('p_assignment_id=' || p_assignment_id);
2127: hr_utility.trace('p_assignment_action_id='|| p_assignment_action_id);
2128: hr_utility.trace('p_business_group_id=' || p_business_group_id);
2129: hr_utility.trace('p_element_entry_id=' || p_element_entry_id);
2130:
2131: -- Check if it is the same assignment id, return the value already stored
2132:

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

2125: hr_utility.trace('Entering PAY_US_RULES.get_time_def_for_entry');
2126: hr_utility.trace('p_assignment_id=' || p_assignment_id);
2127: hr_utility.trace('p_assignment_action_id='|| p_assignment_action_id);
2128: hr_utility.trace('p_business_group_id=' || p_business_group_id);
2129: hr_utility.trace('p_element_entry_id=' || p_element_entry_id);
2130:
2131: -- Check if it is the same assignment id, return the value already stored
2132:
2133: if g_current_asg_id = p_assignment_id then

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

2169: else
2170: p_time_definition_id := g_current_time_def_id;
2171: end if;
2172: else
2173: hr_utility.trace('Finding Time Definition ID');
2174: -- find the Date Earned of the payroll period
2175: open get_date_earned (p_assignment_action_id);
2176: fetch get_date_earned into l_date_earned;
2177: close get_date_earned;

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

2203: p_time_definition_id := l_time_definition_id;
2204: g_current_asg_id := p_assignment_id;
2205: end if;
2206:
2207: hr_utility.trace('p_time_definition_id = ' || p_time_definition_id);
2208: hr_utility.trace('Leaving PAY_US_RULES.get_time_def_for_entry');
2209: return;
2210: END;
2211:

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

2204: g_current_asg_id := p_assignment_id;
2205: end if;
2206:
2207: hr_utility.trace('p_time_definition_id = ' || p_time_definition_id);
2208: hr_utility.trace('Leaving PAY_US_RULES.get_time_def_for_entry');
2209: return;
2210: END;
2211:
2212:

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

2212:
2213: /*****************************************************************************
2214: * PROCEDURE get_time_def_for_entry_func *
2215: * This procedure has to maintain purity and not write into global variables *
2216: * or insert data into any database tables. No calls to hr_utility.trace *
2217: * should be made. *
2218: /****************************************************************************/
2219: FUNCTION get_time_def_for_entry_func(
2220: p_element_entry_id NUMBER,

Line 2543: --hr_utility.trace ('Entering '|| 'pay_us_rules. _xml');

2539: lv_category varchar2(200) := 'DA';
2540: ln_account_number1 number ;
2541:
2542: BEGIN
2543: --hr_utility.trace ('Entering '|| 'pay_us_rules. _xml');
2544:
2545: IF p_action_information_category = 'EMPLOYEE DETAILS' THEN
2546:
2547:

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

2645:
2646: pay_payroll_xml_extract_pkg.load_xml_data('D','NET_PAY',ln_amount);
2647:
2648: END IF;
2649: hr_utility.trace('exiting PAY_US_RULES.add_custom_xml');
2650: END add_custom_xml;
2651:
2652: FUNCTION CF_word_amountFormula(CP_LN_AMOUNT IN NUMBER) RETURN VARCHAR2 IS
2653: