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

Line 29: hr_utility.set_location('pay_db_pay_us_gross.create_vertex_element_names',1);

25: --
26: procedure create_vertex_element_names IS
27: --
28: begin
29: hr_utility.set_location('pay_db_pay_us_gross.create_vertex_element_names',1);
30: --
31: -- Create a table for the VERTEX element names. The name will be suffixed with
32: -- '_%elname%' to create the actual element name. e.g. 'VERTEX_WORK_bonus'.
33: -- When creating the Vertex Tax elements; The first element will be the

Line 88: hr_utility.set_location('pay_db_pay_us_gross.create_vertex_element_names',2);

84: g_vtx_result_name(17) := 'WK_COUNTY_RETURN';
85: g_vtx_result_name(18) := 'RS_CITY_RETURN';
86: g_vtx_result_name(19) := 'RS_COUNTY_RETURN';
87: --
88: hr_utility.set_location('pay_db_pay_us_gross.create_vertex_element_names',2);
89: --
90: end create_vertex_element_names;
91: --
92: --

Line 124: hr_utility.set_location('pay_db_pay_us_gross.delete_gross_up', 1);

120: AND pet.element_name like v_element_name;
121: --
122: begin
123: --
124: hr_utility.set_location('pay_db_pay_us_gross.delete_gross_up', 1);
125: v_element_name := 'VERTEX%' || p_element_name;
126: --
127: FOR elem_rec IN elements LOOP
128: --

Line 129: hr_utility.set_location('pay_db_pay_us_gross.delete_gross_up', 2);

125: v_element_name := 'VERTEX%' || p_element_name;
126: --
127: FOR elem_rec IN elements LOOP
128: --
129: hr_utility.set_location('pay_db_pay_us_gross.delete_gross_up', 2);
130: hr_user_init_earn.do_deletions (
131: p_business_group_id=>p_business_group_id,
132: p_ele_type_id=>elem_rec.element_type_id,
133: p_ele_name=>elem_rec.element_name,

Line 144: hr_utility.set_location('pay_db_pay_us_gross.delete_gross_up', 3);

140: );
141: --
142: END LOOP;
143: --
144: hr_utility.set_location('pay_db_pay_us_gross.delete_gross_up', 3);
145: --
146: end delete_gross_up;
147: --
148: --

Line 182: hr_utility.set_location('pay_db_pay_us_gross.create_gross_up', 1);

178: v_piv_name PAY_INPUT_VALUES_F.NAME%TYPE;
179: --
180: begin
181: --
182: hr_utility.set_location('pay_db_pay_us_gross.create_gross_up', 1);
183: --
184: -- Find the Business_group_id for the parameter
185: IF p_business_group_name is NOT NULL THEN
186: SELECT business_group_id

Line 206: hr_utility.set_location('pay_db_pay_us_gross.create_gross_up', 2);

202: END IF;
203: --
204: -- Get the Element_type_id and Formula_id for the existing %elname% element
205: --
206: hr_utility.set_location('pay_db_pay_us_gross.create_gross_up', 2);
207: --
208: SELECT type.element_type_id
209: INTO v_element_type_id
210: FROM pay_element_types_f_tl type_tl,

Line 217: hr_utility.set_location('pay_db_pay_us_gross.create_gross_up', 3);

213: and userenv('LANG') = type_tl.language
214: AND nvl(business_group_id, -1) = nvl(g_business_group_ID, -1)
215: AND type_tl.element_name = p_element_name;
216: --
217: hr_utility.set_location('pay_db_pay_us_gross.create_gross_up', 3);
218: --
219: SELECT formula_id
220: INTO v_formula_id
221: FROM ff_formulas_f ff,

Line 227: hr_utility.set_location('pay_db_pay_us_gross.create_gross_up', 4);

223: WHERE ft.formula_type_name = 'Oracle Payroll'
224: AND ff.formula_type_id = ft.formula_type_id
225: AND ff.formula_name = p_formula_name;
226: --
227: hr_utility.set_location('pay_db_pay_us_gross.create_gross_up', 4);
228: --
229: -- Create the chain of Vertex elements ;
230: -- VERTEX--->VERTEX2--->VERTEX_WORK--->VERTEX_WORK2-->
231: -- VERTEX_HOME-->VERTEX_SUI-->VERTEX_RESULTS

Line 244: hr_utility.set_location('pay_db_pay_us_gross.create_gross_up', 5);

240: p_start_date=>v_start_date,
241: p_end_date=>v_end_date
242: );
243: --
244: hr_utility.set_location('pay_db_pay_us_gross.create_gross_up', 5);
245: --
246: -- Create the final element '%elname%_GROSSUP'
247: --
248: v_element_name := p_element_name || g_vtx_elem_tab(g_max_elnum);

Line 250: hr_utility.trace('** Creating Element ' || v_element_name);

246: -- Create the final element '%elname%_GROSSUP'
247: --
248: v_element_name := p_element_name || g_vtx_elem_tab(g_max_elnum);
249: --
250: hr_utility.trace('** Creating Element ' || v_element_name);
251: --
252: v_element_type_ID := pay_db_pay_setup.create_element (
253: p_element_name=>v_element_name,
254: p_description=>'Gross up element for ' || p_element_name,

Line 269: hr_utility.set_location('pay_db_pay_us_gross.create_gross_up', 6);

265: p_business_group_name=>p_business_group_name,
266: p_legislation_code=>'US'
267: );
268: --
269: hr_utility.set_location('pay_db_pay_us_gross.create_gross_up', 6);
270: --
271: -- Get the input_value_id for the 'Pay Value' input value that was created
272: -- for the '%elname%_GROSSUP' element.
273: --

Line 291: hr_utility.set_location('pay_db_pay_us_gross.create_gross_up',7);

287: AND nvl(piv.business_group_id, -1) = nvl(g_business_group_ID, -1)
288: AND pet.element_type_id = piv.element_type_id
289: AND pet_tl.element_name = v_element_name;
290: --
291: hr_utility.set_location('pay_db_pay_us_gross.create_gross_up',7);
292: --
293: -- Create the Result rule from VERTEX_RESULTS to feed the
294: -- 'Pay Value' input value.
295: --

Line 304: hr_utility.set_location('pay_db_pay_us_gross.create_gross_up', 8);

300: p_effective_start_date=>v_start_date,
301: p_effective_end_date=>v_end_date
302: );
303: --
304: hr_utility.set_location('pay_db_pay_us_gross.create_gross_up', 8);
305: --
306: -- Get the input_value_id for the 'Pay Value' input value that was created
307: -- for the FIT_GROSSUP_ADJUSTMENT element.
308: --

Line 321: hr_utility.set_location('pay_db_pay_us_gross.create_gross_up', 10);

317: AND piv.business_group_id is null
318: AND pet.element_type_id = piv.element_type_id
319: AND pet.element_name = 'FIT_GROSSUP_ADJUSTMENT';
320: --
321: hr_utility.set_location('pay_db_pay_us_gross.create_gross_up', 10);
322: --
323: -- Create the the result rule to feed the FIT_GROSSUP_ADJUSTMENT tax element
324: --
325: v_result_rule_id := create_result_rule (

Line 333: hr_utility.set_location('pay_db_pay_us_gross.create_gross_up', 11);

329: p_effective_start_date=>v_start_date,
330: p_effective_end_date=>v_end_date
331: );
332: --
333: hr_utility.set_location('pay_db_pay_us_gross.create_gross_up', 11);
334: --
335: return v_element_type_ID;
336: --
337: EXCEPTION

Line 381: hr_utility.set_location('pay_db_pay_us_gross.create_linked_elements', 1);

377: v_msg_num NUMBER;
378: v_processing_priority NUMBER;
379: --
380: begin
381: hr_utility.set_location('pay_db_pay_us_gross.create_linked_elements', 1);
382: --
383: v_formula_ID := p_formula_id;
384: v_element_type_ID := p_element_type_id;
385: --

Line 401: hr_utility.set_location('pay_db_pay_us_gross.create_linked_elements', 2);

397: INTO v_prev_proc_rule_id
398: FROM PAY_STATUS_PROCESSING_RULES_F
399: WHERE ELEMENT_TYPE_ID = v_element_type_ID;
400: --
401: hr_utility.set_location('pay_db_pay_us_gross.create_linked_elements', 2);
402: --
403: ELSE
404: v_priority_incr := 10;
405: v_processing_priority := p_priority - v_priority_incr;

Line 420: hr_utility.set_location('pay_db_pay_us_gross.create_linked_elements', 3);

416: p_formula_id=>v_formula_ID,
417: p_element_type_id=>v_element_type_ID
418: );
419: --
420: hr_utility.set_location('pay_db_pay_us_gross.create_linked_elements', 3);
421: --
422: END IF;
423: --
424: begin

Line 427: hr_utility.set_location('pay_db_pay_us_gross.create_linked_elements', 4);

423: --
424: begin
425: FOR v_element_num in v_start_elnum..g_max_elnum - 1 LOOP
426: --
427: hr_utility.set_location('pay_db_pay_us_gross.create_linked_elements', 4);
428: --
429: -- Find the formula...
430: --
431: --

Line 440: hr_utility.set_location('pay_db_pay_us_gross.create_linked_elements', 5);

436: WHERE ft.formula_type_name = 'Oracle Payroll'
437: AND ff.formula_type_id = ft.formula_type_id
438: AND ff.formula_name = g_vtx_elem_tab(v_element_num);
439: --
440: hr_utility.set_location('pay_db_pay_us_gross.create_linked_elements', 5);
441: --
442: -- Create the element...
443: --
444: IF p_mode = 'Grossup' THEN

Line 451: hr_utility.trace('** Creating Element ' || v_element_name);

447: ELSE
448: v_element_name := g_vtx_elem_tab(v_element_num);
449: END IF;
450: --
451: hr_utility.trace('** Creating Element ' || v_element_name);
452: --
453: v_element_type_ID := pay_db_pay_setup.create_element (
454: p_element_name=>v_element_name,
455: p_description=>v_description,

Line 471: hr_utility.set_location('pay_db_pay_us_gross.create_linked_elements', 6);

467: p_business_group_name=>p_business_group_name,
468: p_legislation_code=>'US'
469: );
470: --
471: hr_utility.set_location('pay_db_pay_us_gross.create_linked_elements', 6);
472: --
473: IF (p_mode = 'Grossup') THEN
474: --
475: -- Create the 'Pay Value' input as this is an Information element

Line 520: hr_utility.set_location(

516: p_effective_start_date=>p_start_date,
517: p_effective_end_date=>p_end_date
518: );
519: --
520: hr_utility.set_location(
521: 'pay_db_pay_us_gross.create_linked_elements', 7);
522: --
523: v_linknum := v_linknum + 1;
524: --

Line 532: hr_utility.set_location('pay_db_pay_us_gross.create_linked_elements', 8);

528: WHEN NO_DATA_FOUND THEN
529: null;
530: end;
531: --
532: hr_utility.set_location('pay_db_pay_us_gross.create_linked_elements', 8);
533: --
534: -- Create the (fatal) message result for the previous element
535: --
536: v_result_rule_id := create_result_rule (

Line 545: hr_utility.set_location('pay_db_pay_us_gross.create_linked_elements', 9);

541: p_effective_start_date=>p_start_date,
542: p_effective_end_date=>p_end_date
543: );
544: --
545: hr_utility.set_location('pay_db_pay_us_gross.create_linked_elements', 9);
546: --
547: --
548: -- Create the Status Processing Rule for the previous element
549: --

Line 557: hr_utility.set_location('pay_db_pay_us_gross.create_linked_elements', 10);

553: p_formula_id=>v_formula_ID,
554: p_element_type_id=>v_element_type_ID
555: );
556: --
557: hr_utility.set_location('pay_db_pay_us_gross.create_linked_elements', 10);
558: --
559: END LOOP;
560: --
561: EXCEPTION

Line 571: hr_utility.set_location('pay_db_pay_us_gross.create_linked_elements', 11);

567: -- values and status processing rule. It now needs :
568: -- 1) The Fatal Message Result.
569: -- 2) the Warning Message results.
570: --
571: hr_utility.set_location('pay_db_pay_us_gross.create_linked_elements', 11);
572: --
573: /* Create the Fatal message result rule */
574: --
575: v_result_rule_id := create_result_rule (

Line 594: hr_utility.trace('** Cr. Rslt Rule ' || g_vtx_result_name(v_msg_num));

590: */
591: begin
592: LOOP
593: --
594: hr_utility.trace('** Cr. Rslt Rule ' || g_vtx_result_name(v_msg_num));
595: --
596: v_result_rule_ID := pay_db_pay_us_gross.create_result_rule (
597: p_result_name=>g_vtx_result_name(v_msg_num),
598: p_result_type=>'M', -- 'M'essage

Line 607: hr_utility.set_location('pay_db_pay_us_gross.create_linked_elements', 12);

603: );
604: --
605: v_msg_num := v_msg_num + 1;
606: --
607: hr_utility.set_location('pay_db_pay_us_gross.create_linked_elements', 12);
608: --
609: END LOOP;
610: --
611: EXCEPTION

Line 648: hr_utility.set_location('pay_db_pay_us_gross.create_indirect_link', 1);

644: v_result_rule_ID NUMBER;
645: --
646: begin
647: --
648: hr_utility.set_location('pay_db_pay_us_gross.create_indirect_link', 1);
649: --
650: hr_utility.trace('** Creating Input Value ' || p_name);
651: --
652: v_input_value_ID := pay_db_pay_setup.create_input_value (

Line 650: hr_utility.trace('** Creating Input Value ' || p_name);

646: begin
647: --
648: hr_utility.set_location('pay_db_pay_us_gross.create_indirect_link', 1);
649: --
650: hr_utility.trace('** Creating Input Value ' || p_name);
651: --
652: v_input_value_ID := pay_db_pay_setup.create_input_value (
653: p_element_name=>p_element_name,
654: p_uom=>p_uom,

Line 663: hr_utility.set_location('pay_db_pay_us_gross.create_indirect_link', 2);

659: p_effective_start_date=>p_effective_start_date,
660: p_effective_end_date=>p_effective_end_date
661: );
662: --
663: hr_utility.set_location('pay_db_pay_us_gross.create_indirect_link', 2);
664: --
665: v_result_rule_id := create_result_rule (
666: p_result_name=>p_name,
667: p_stat_proc_id=>p_stat_proc_ID,

Line 673: hr_utility.set_location('pay_db_pay_us_gross.create_indirect_link', 3);

669: p_effective_start_date=>p_effective_start_date,
670: p_effective_end_date=>p_effective_end_date
671: );
672: --
673: hr_utility.set_location('pay_db_pay_us_gross.create_indirect_link', 3);
674: --
675: end create_indirect_link;
676: --
677: --

Line 701: hr_utility.set_location('pay_db_pay_us_gross.create_status_proc_rule', 1);

697: v_rule_ID NUMBER; -- status processing rule ID
698: --
699: begin
700: --
701: hr_utility.set_location('pay_db_pay_us_gross.create_status_proc_rule', 1);
702: -- Create the status_processing_rule_id
703: --
704: SELECT pay_status_processing_rules_s.nextval
705: INTO v_rule_ID

Line 708: hr_utility.set_location('pay_db_pay_us_gross.create_status_proc_rule', 2);

704: SELECT pay_status_processing_rules_s.nextval
705: INTO v_rule_ID
706: FROM sys.dual;
707: --
708: hr_utility.set_location('pay_db_pay_us_gross.create_status_proc_rule', 2);
709: --
710: INSERT INTO PAY_STATUS_PROCESSING_RULES_F
711: (
712: STATUS_PROCESSING_RULE_ID,

Line 749: hr_utility.set_location('pay_db_pay_us_gross.create_status_proc_rule', 3);

745: g_todays_date
746: from per_assignment_status_types
747: where USER_STATUS = 'Active Assignment';
748: --
749: hr_utility.set_location('pay_db_pay_us_gross.create_status_proc_rule', 3);
750: --
751: return v_rule_ID;
752: --
753: end create_status_proc_rule;

Line 783: hr_utility.set_location('pay_db_pay_us_gross.create_result_rule', 1);

779: -- Local Variables
780: v_rule_ID NUMBER;
781: --
782: begin
783: hr_utility.set_location('pay_db_pay_us_gross.create_result_rule', 1);
784: --
785: -- Select the next sequence number for PAY_FORMULA_RESULT_RULES
786: SELECT pay_formula_result_rules_s.nextval
787: INTO v_rule_ID

Line 790: hr_utility.set_location('pay_db_pay_us_gross.create_result_rule', 2);

786: SELECT pay_formula_result_rules_s.nextval
787: INTO v_rule_ID
788: FROM sys.dual;
789: --
790: hr_utility.set_location('pay_db_pay_us_gross.create_result_rule', 2);
791: --
792: hr_utility.trace('** Creating Result Rule ' || p_result_name);
793: --
794: -- Now do the INSERT into the PAY_FORMULA_RESULT_RULES_F table

Line 792: hr_utility.trace('** Creating Result Rule ' || p_result_name);

788: FROM sys.dual;
789: --
790: hr_utility.set_location('pay_db_pay_us_gross.create_result_rule', 2);
791: --
792: hr_utility.trace('** Creating Result Rule ' || p_result_name);
793: --
794: -- Now do the INSERT into the PAY_FORMULA_RESULT_RULES_F table
795: INSERT INTO pay_formula_result_rules_f
796: (

Line 834: hr_utility.set_location('pay_db_pay_us_gross.create_result_rule', 3);

830: -1,
831: g_todays_date
832: );
833: --
834: hr_utility.set_location('pay_db_pay_us_gross.create_result_rule', 3);
835: --
836: return v_rule_ID;
837: --
838: end create_result_rule;

Line 842: hr_utility.set_location('pay_db_pay_us_gross.initialization', 1);

838: end create_result_rule;
839: --
840: --
841: begin -- Initialization
842: hr_utility.set_location('pay_db_pay_us_gross.initialization', 1);
843: create_vertex_element_names;
844: hr_utility.set_location('pay_db_pay_us_gross.initialization', 2);
845: end pay_db_pay_us_gross;

Line 844: hr_utility.set_location('pay_db_pay_us_gross.initialization', 2);

840: --
841: begin -- Initialization
842: hr_utility.set_location('pay_db_pay_us_gross.initialization', 1);
843: create_vertex_element_names;
844: hr_utility.set_location('pay_db_pay_us_gross.initialization', 2);
845: end pay_db_pay_us_gross;