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_EARNINGS_TEMPLATE dependencies on HR_UTILITY

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

165: ------------------------------------------------------------------------------
166: -- MAIN FUNCTION
167: ------------------------------------------------------------------------------
168: BEGIN
169: hr_utility.set_location('Entering : '||l_proc, 10);
170: --
171: -- Set the global variables
172: --
173: g_bg_id := p_bg_id;

Line 175: hr_utility.set_location(l_proc, 20);

171: -- Set the global variables
172: --
173: g_bg_id := p_bg_id;
174: g_legislation_code := p_legislation_code;
175: hr_utility.set_location(l_proc, 20);
176: -------------------
177: -- Set session date
178: -------------------
179: pay_db_pay_setup.set_session_date(nvl(p_ele_eff_start_date, sysdate));

Line 180: hr_utility.set_location(l_proc, 30);

176: -------------------
177: -- Set session date
178: -------------------
179: pay_db_pay_setup.set_session_date(nvl(p_ele_eff_start_date, sysdate));
180: hr_utility.set_location(l_proc, 30);
181: -- IMPORTANT NOTE :
182: -- The skip rules are removed from all the earnings. This have been
183: -- replaced with entry in pay_element_type_usages table and c code
184: -- changes.This Changes are made to imporve the performance of the payroll

Line 226: hr_utility.set_location(l_proc, 40);

222: END IF;
223: IF p_ele_priority IS NOT NULL THEN
224: l_element_priority := p_ele_priority;
225: END IF;
226: hr_utility.set_location(l_proc, 40);
227: --------------------------------------------
228: -- set the appropriate exclusion rules
229: --------------------------------------------
230: -- The Configuration Flex segments for the Exclusion Rules are as follows:

Line 276: hr_utility.set_location(l_proc, 50);

272: l_config5_hrm := 'N';
273: l_calc_type := 'HOURS_X_RATE';
274: END IF;
275:
276: hr_utility.set_location(l_proc, 50);
277:
278: l_si_flag := 'Y';
279: IF ((p_ele_processing_type = 'N'
280: -- AND p_termination_rule <> 'L'

Line 306: hr_utility.set_location(l_proc, 60);

302: END IF;
303: IF (p_stop_reach_rule = 'Y') THEN
304: l_stop_reach_flag := 'Y';
305: END IF;
306: hr_utility.set_location(l_proc, 60);
307:
308: l_config2_NR_amt := 'N';
309: l_config2_RSI_amt := 'N';
310: l_config3_NR_perc := 'N';

Line 344: hr_utility.set_location(l_proc, 70);

340: IF (p_reduce_regular = 'Y') THEN
341: l_red_reg_hour_xrule_flag := 'N';
342: END IF;
343:
344: hr_utility.set_location(l_proc, 70);
345: ----------------------
346: -- get the template id
347: ----------------------
348: l_template_name := 'US Earnings';

Line 355: hr_utility.set_location(l_proc, 70);

351: FOR c_rec IN c_template(l_template_name) LOOP
352: l_source_template_id := c_rec.template_id;
353: END LOOP;
354:
355: hr_utility.set_location(l_proc, 70);
356:
357: pay_element_template_api.create_user_structure
358: (p_validate => FALSE
359: ,p_effective_date => p_ele_eff_start_date

Line 391: hr_utility.set_location(l_proc, 80);

387: ,p_configuration_information23 => p_ele_processing_type
388: ,p_template_id => l_template_id
389: ,p_object_version_number => l_ovn );
390:
391: hr_utility.set_location(l_proc, 80);
392: -----------------------------------------------------------
393: -- Update Base shadow Element with user-specified details
394: -----------------------------------------------------------
395: FOR c_rec IN c_element(l_temp_ele_name,

Line 404: hr_utility.set_location(l_proc, 90);

400: END LOOP;
401: IF p_ele_processing_type = 'N' THEN
402: l_multiple_entries := 'Y';
403: END IF;
404: hr_utility.set_location(l_proc, 90);
405:
406: pay_shadow_element_api.update_shadow_element
407: (p_validate => FALSE
408: ,p_effective_date => p_ele_eff_start_date

Line 431: hr_utility.set_location(l_proc, 100);

427: ,p_element_information15 => NVL(p_stop_reach_rule, hr_api.g_varchar2)
428: ,p_object_version_number => l_ovn
429: );
430:
431: hr_utility.set_location(l_proc, 100);
432: -------------------------------------------------------------------
433: -- Update user-specified details on Special Features Element.
434: -------------------------------------------------------------------
435: IF (l_sf_flag = 'Y') THEN

Line 457: hr_utility.set_location(l_proc, 110);

453: ,p_object_version_number => l_ovn
454: );
455: END LOOP;
456: END IF;
457: hr_utility.set_location(l_proc, 110);
458: --------------------------------------------------------------------
459: -- Update user-specified Classification Special Inputs IF it exists.
460: --------------------------------------------------------------------
461: IF (l_si_flag = 'Y') THEN

Line 482: hr_utility.set_location(l_proc, 120);

478: ,p_element_information8 => NVL(p_ele_ot_base, hr_api.g_varchar2)
479: ,p_object_version_number => l_ovn
480: );
481: END IF;
482: hr_utility.set_location(l_proc, 120);
483: ------------------------------------------------------------
484: -- Generate Core Objects
485: ------------------------------------------------------------
486: pay_element_template_api.generate_part1

Line 493: hr_utility.set_location(l_proc, 130);

489: ,p_hr_only => FALSE
490: ,p_hr_to_payroll => FALSE
491: ,p_template_id => l_template_id);
492: --
493: hr_utility.set_location(l_proc, 130);
494: --
495: -- Add logic to generate part2 only IF payroll is installed
496: --
497: pay_element_template_api.generate_part2

Line 501: hr_utility.set_location(l_proc, 140);

497: pay_element_template_api.generate_part2
498: (p_validate => FALSE
499: ,p_effective_date => p_ele_eff_start_date
500: ,p_template_id => l_template_id);
501: hr_utility.set_location(l_proc, 140);
502: --
503: -------------------------------------------------------------------
504: -- Get Element and Balance Id's to update the Further Information
505: -------------------------------------------------------------------

Line 515: hr_utility.set_location(l_proc, 150);

511: l_pri_ele_type_id := get_obj_id('ELE', p_ele_name);
512: l_si_ele_type_id := get_obj_id('ELE', p_ele_name||' Special Inputs');
513: l_sf_ele_type_id := get_obj_id('ELE', p_ele_name||' Speacial Features');
514:
515: hr_utility.set_location(l_proc, 150);
516:
517: UPDATE pay_element_types_f
518: SET element_name = p_ele_name
519: ,element_information10 = l_pri_bal_id

Line 524: hr_utility.set_location(l_proc, 160);

520: ,element_information12 = l_hours_bal_id
521: WHERE element_type_id = l_pri_ele_type_id
522: AND business_group_id = p_bg_id;
523:
524: hr_utility.set_location(l_proc, 160);
525:
526: -------------------------------------------------------------------
527: -- Update Input values with default values, validation formula etc.
528: -------------------------------------------------------------------

Line 537: hr_utility.set_location(l_proc, 170);

533: t_form_id(2) := NULL;
534: t_we_flag(2) := NULL;
535: t_def_val(2) := p_sep_check_option;
536: --
537: hr_utility.set_location(l_proc, 170);
538: FOR i in 1..2 LOOP
539: UPDATE pay_input_values_f
540: SET formula_id = t_form_id(i)
541: ,warning_or_error = t_we_flag(i)

Line 557: hr_utility.set_location(l_proc, 175);

553: LOOP
554: l_asg_gre_run_dim_id := crec.balance_dimension_id;
555: END LOOP;
556: --
557: hr_utility.set_location(l_proc, 175);
558:
559: FOR c_rec IN c_ele('Hours by Rate')
560: LOOP
561: l_hr_ele_id := c_rec.element_type_id;

Line 567: hr_utility.set_location(l_proc, 180);

563: FOR c_rec IN c_inp_val('Element Type Id', l_hr_ele_id)
564: LOOP
565: l_hr_iv_id := c_rec.input_value_id;
566: END LOOP;
567: hr_utility.set_location(l_proc, 180);
568: IF (l_config4_hr = 'Y') THEN
569: FOR c_rec IN c_pspr(p_element_type_id => l_pri_ele_type_id,
570: p_bg_id => p_bg_id ,
571: p_assgn_status_id => NULL)

Line 575: hr_utility.set_location(l_proc, 190);

571: p_assgn_status_id => NULL)
572: LOOP
573: l_stat_proc_rule_id := c_rec.status_processing_rule_id;
574: END LOOP;
575: hr_utility.set_location(l_proc, 190);
576: l_rr_id := pay_formula_results.ins_form_res_rule (
577: p_business_group_id => p_bg_id,
578: p_legislation_code => NULL,
579: p_effective_start_date => p_ele_eff_start_date,

Line 587: hr_utility.set_location(l_proc, 200);

583: p_input_value_id => l_hr_iv_id,
584: p_result_name => 'ELEMENT_TYPE_ID_PASSED',
585: p_result_rule_type => 'I',
586: p_severity_level => NULL);
587: hr_utility.set_location(l_proc, 200);
588: FOR c_rec IN c_inp_val('Hours', l_hr_ele_id)
589: LOOP
590: l_hr_iv_id := c_rec.input_value_id;
591: END LOOP;

Line 592: hr_utility.set_location(l_proc, 210);

588: FOR c_rec IN c_inp_val('Hours', l_hr_ele_id)
589: LOOP
590: l_hr_iv_id := c_rec.input_value_id;
591: END LOOP;
592: hr_utility.set_location(l_proc, 210);
593: l_rr_id := pay_formula_results.ins_form_res_rule (
594: p_business_group_id => p_bg_id,
595: p_legislation_code => NULL,
596: p_effective_start_date => p_ele_eff_start_date,

Line 604: hr_utility.set_location(l_proc, 220);

600: p_input_value_id => l_hr_iv_id,
601: p_result_name => 'HOURS_PASSED',
602: p_result_rule_type => 'I',
603: p_severity_level => NULL);
604: hr_utility.set_location(l_proc, 220);
605: IF (l_config5_hrm = 'Y') THEN
606: FOR c_rec IN c_inp_val('Multiple', l_hr_ele_id)
607: LOOP
608: l_hr_iv_id := c_rec.input_value_id;

Line 610: hr_utility.set_location(l_proc, 230);

606: FOR c_rec IN c_inp_val('Multiple', l_hr_ele_id)
607: LOOP
608: l_hr_iv_id := c_rec.input_value_id;
609: END LOOP;
610: hr_utility.set_location(l_proc, 230);
611:
612: l_rr_id := pay_formula_results.ins_form_res_rule (
613: p_business_group_id => p_bg_id,
614: p_legislation_code => NULL,

Line 624: hr_utility.set_location(l_proc, 240);

620: p_result_name => 'MULTIPLE_PASSED',
621: p_result_rule_type => 'I',
622: p_severity_level => NULL);
623: END IF;
624: hr_utility.set_location(l_proc, 240);
625: FOR c_rec IN c_inp_val('Rate', l_hr_ele_id)
626: LOOP
627: l_hr_iv_id := c_rec.input_value_id;
628: END LOOP;

Line 629: hr_utility.set_location(l_proc, 250);

625: FOR c_rec IN c_inp_val('Rate', l_hr_ele_id)
626: LOOP
627: l_hr_iv_id := c_rec.input_value_id;
628: END LOOP;
629: hr_utility.set_location(l_proc, 250);
630: l_rr_id := pay_formula_results.ins_form_res_rule (
631: p_business_group_id => p_bg_id,
632: p_legislation_code => NULL,
633: p_effective_start_date => p_ele_eff_start_date,

Line 641: hr_utility.set_location(l_proc, 260);

637: p_input_value_id => l_hr_iv_id,
638: p_result_name => 'RATE_PASSED',
639: p_result_rule_type => 'I',
640: p_severity_level => NULL);
641: hr_utility.set_location(l_proc, 260);
642: END IF;
643: hr_utility.set_location('Leaving : '||l_proc, 290);
644: -------------------------
645: RETURN l_pri_ele_type_id;

Line 643: hr_utility.set_location('Leaving : '||l_proc, 290);

639: p_result_rule_type => 'I',
640: p_severity_level => NULL);
641: hr_utility.set_location(l_proc, 260);
642: END IF;
643: hr_utility.set_location('Leaving : '||l_proc, 290);
644: -------------------------
645: RETURN l_pri_ele_type_id;
646: -------------------------
647: END create_ele_template_objects;

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

676: AND NVL(pbt.business_group_id, g_bg_id) = g_bg_id
677: AND NVL(pbt.legislation_code, g_legislation_code) = g_legislation_code;
678: --
679: BEGIN
680: hr_utility.set_location('Entering: '||l_proc, 10);
681: --
682: IF p_object_type = 'ELE' THEN
683: FOR c_rec IN c_element LOOP
684: l_object_id := c_rec.element_type_id; -- element id

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

691: FOR c_rec IN c_get_ipv_id LOOP
692: l_object_id := c_rec.input_value_id; -- input value id
693: END LOOP;
694: END IF;
695: hr_utility.set_location('Leaving: '||l_proc, 50);
696: --
697: RETURN l_object_id;
698: END get_obj_id;
699: --===========================================================================

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

718: AND template_type = 'U';
719: --
720: BEGIN
721: --
722: hr_utility.set_location('Entering :'||l_proc, 10);
723: FOR c1_rec IN c1 LOOP
724: l_template_id := c1_rec.template_id;
725: END LOOP;
726: --

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

727: pay_element_template_api.delete_user_structure
728: (p_validate => FALSE
729: ,p_drop_formula_packages => TRUE
730: ,p_template_id => l_template_id);
731: hr_utility.set_location('Leaving :'||l_proc, 50);
732: --
733: END delete_ele_template_objects;
734: END pay_us_earnings_template;