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.HR_US_REPORTS dependencies on HR_UTILITY

Line 227: hr_utility.set_location('hr_us_reports.get_salary',5);

223: l_frequency per_all_assignments_f.frequency%type;
224: --
225: Begin
226: --
227: hr_utility.set_location('hr_us_reports.get_salary',5);
228: hr_utility.trace('p_business_group_id ->'||to_char(p_business_group_id));
229: hr_utility.trace('p_assignment_id ->'||to_char(p_assignment_id));
230: hr_utility.trace('p_report_date ->'||p_report_date );
231: --

Line 228: hr_utility.trace('p_business_group_id ->'||to_char(p_business_group_id));

224: --
225: Begin
226: --
227: hr_utility.set_location('hr_us_reports.get_salary',5);
228: hr_utility.trace('p_business_group_id ->'||to_char(p_business_group_id));
229: hr_utility.trace('p_assignment_id ->'||to_char(p_assignment_id));
230: hr_utility.trace('p_report_date ->'||p_report_date );
231: --
232: Begin

Line 229: hr_utility.trace('p_assignment_id ->'||to_char(p_assignment_id));

225: Begin
226: --
227: hr_utility.set_location('hr_us_reports.get_salary',5);
228: hr_utility.trace('p_business_group_id ->'||to_char(p_business_group_id));
229: hr_utility.trace('p_assignment_id ->'||to_char(p_assignment_id));
230: hr_utility.trace('p_report_date ->'||p_report_date );
231: --
232: Begin
233: --

Line 230: hr_utility.trace('p_report_date ->'||p_report_date );

226: --
227: hr_utility.set_location('hr_us_reports.get_salary',5);
228: hr_utility.trace('p_business_group_id ->'||to_char(p_business_group_id));
229: hr_utility.trace('p_assignment_id ->'||to_char(p_assignment_id));
230: hr_utility.trace('p_report_date ->'||p_report_date );
231: --
232: Begin
233: --
234: Select

Line 276: hr_utility.trace('l_effective_start_date ->'||l_effective_start_date);

272: and asg.effective_end_date
273: And p_report_date between pee.effective_start_date
274: and pee.effective_end_date;
275: --
276: hr_utility.trace('l_effective_start_date ->'||l_effective_start_date);
277: hr_utility.trace('l_pay_basis ->'||l_pay_basis);
278: hr_utility.trace('l_normal_hours ->'||to_char(l_normal_hours));
279: hr_utility.trace('l_work_schedule ->'||l_work_schedule);
280: hr_utility.trace('l_salary ->'||to_char(l_salary));

Line 277: hr_utility.trace('l_pay_basis ->'||l_pay_basis);

273: And p_report_date between pee.effective_start_date
274: and pee.effective_end_date;
275: --
276: hr_utility.trace('l_effective_start_date ->'||l_effective_start_date);
277: hr_utility.trace('l_pay_basis ->'||l_pay_basis);
278: hr_utility.trace('l_normal_hours ->'||to_char(l_normal_hours));
279: hr_utility.trace('l_work_schedule ->'||l_work_schedule);
280: hr_utility.trace('l_salary ->'||to_char(l_salary));
281: --

Line 278: hr_utility.trace('l_normal_hours ->'||to_char(l_normal_hours));

274: and pee.effective_end_date;
275: --
276: hr_utility.trace('l_effective_start_date ->'||l_effective_start_date);
277: hr_utility.trace('l_pay_basis ->'||l_pay_basis);
278: hr_utility.trace('l_normal_hours ->'||to_char(l_normal_hours));
279: hr_utility.trace('l_work_schedule ->'||l_work_schedule);
280: hr_utility.trace('l_salary ->'||to_char(l_salary));
281: --
282: exception

Line 279: hr_utility.trace('l_work_schedule ->'||l_work_schedule);

275: --
276: hr_utility.trace('l_effective_start_date ->'||l_effective_start_date);
277: hr_utility.trace('l_pay_basis ->'||l_pay_basis);
278: hr_utility.trace('l_normal_hours ->'||to_char(l_normal_hours));
279: hr_utility.trace('l_work_schedule ->'||l_work_schedule);
280: hr_utility.trace('l_salary ->'||to_char(l_salary));
281: --
282: exception
283: when NO_DATA_FOUND then RETURN NULL;

Line 280: hr_utility.trace('l_salary ->'||to_char(l_salary));

276: hr_utility.trace('l_effective_start_date ->'||l_effective_start_date);
277: hr_utility.trace('l_pay_basis ->'||l_pay_basis);
278: hr_utility.trace('l_normal_hours ->'||to_char(l_normal_hours));
279: hr_utility.trace('l_work_schedule ->'||l_work_schedule);
280: hr_utility.trace('l_salary ->'||to_char(l_salary));
281: --
282: exception
283: when NO_DATA_FOUND then RETURN NULL;
284: when others then

Line 285: hr_utility.set_location('hr_us_reports.get_salary',10);

281: --
282: exception
283: when NO_DATA_FOUND then RETURN NULL;
284: when others then
285: hr_utility.set_location('hr_us_reports.get_salary',10);
286: RETURN NULL;
287: --
288: end;
289: --

Line 295: hr_utility.set_location('hr_us_reports.get_salary',15);

291: l_annual_salary := hr_us_ff_udfs.Convert_Period_Type
292: (p_business_group_id,null,l_work_schedule,l_normal_hours,l_salary,l_pay_basis,'Year',
293: null,null,l_frequency); -- Bug 3669973
294: --
295: hr_utility.set_location('hr_us_reports.get_salary',15);
296: hr_utility.trace('l_annual_salary ->'||to_char(l_annual_salary));
297: --
298: return (l_annual_salary);
299: --

Line 296: hr_utility.trace('l_annual_salary ->'||to_char(l_annual_salary));

292: (p_business_group_id,null,l_work_schedule,l_normal_hours,l_salary,l_pay_basis,'Year',
293: null,null,l_frequency); -- Bug 3669973
294: --
295: hr_utility.set_location('hr_us_reports.get_salary',15);
296: hr_utility.trace('l_annual_salary ->'||to_char(l_annual_salary));
297: --
298: return (l_annual_salary);
299: --
300: end get_salary;

Line 338: hr_utility.set_location('Entered hr_us_reports.get_new_hire_contact',5);

334:
335: --
336: begin
337: --
338: hr_utility.set_location('Entered hr_us_reports.get_new_hire_contact',5);
339: --
340: OPEN c_new_hire_record;
341:
342: --LOOP

Line 354: hr_utility.trace('Contact name : '||v_contact_name);

350: --END LOOP;
351:
352: CLOSE c_new_hire_record;
353: --
354: hr_utility.trace('Contact name : '||v_contact_name);
355: hr_utility.trace('Contact title : '||v_contact_title);
356: hr_utility.set_location('Leaving hr_us_reports.get_new_hire_contact',10);
357: --
358: exception

Line 355: hr_utility.trace('Contact title : '||v_contact_title);

351:
352: CLOSE c_new_hire_record;
353: --
354: hr_utility.trace('Contact name : '||v_contact_name);
355: hr_utility.trace('Contact title : '||v_contact_title);
356: hr_utility.set_location('Leaving hr_us_reports.get_new_hire_contact',10);
357: --
358: exception
359: when no_data_found then

Line 356: hr_utility.set_location('Leaving hr_us_reports.get_new_hire_contact',10);

352: CLOSE c_new_hire_record;
353: --
354: hr_utility.trace('Contact name : '||v_contact_name);
355: hr_utility.trace('Contact title : '||v_contact_title);
356: hr_utility.set_location('Leaving hr_us_reports.get_new_hire_contact',10);
357: --
358: exception
359: when no_data_found then
360: hr_utility.set_location('Error found in hr_us_reports.get_new_hire.contact',20);

Line 360: hr_utility.set_location('Error found in hr_us_reports.get_new_hire.contact',20);

356: hr_utility.set_location('Leaving hr_us_reports.get_new_hire_contact',10);
357: --
358: exception
359: when no_data_found then
360: hr_utility.set_location('Error found in hr_us_reports.get_new_hire.contact',20);
361: NULL;
362: when others then
363: hr_utility.set_location('Error found in hr_us_reports.get_new_hire_contact',15);
364: --

Line 363: hr_utility.set_location('Error found in hr_us_reports.get_new_hire_contact',15);

359: when no_data_found then
360: hr_utility.set_location('Error found in hr_us_reports.get_new_hire.contact',20);
361: NULL;
362: when others then
363: hr_utility.set_location('Error found in hr_us_reports.get_new_hire_contact',15);
364: --
365: end get_new_hire_contact;
366: --
367: --

Line 387: hr_utility.set_location('Entered hr_us_reports.get_address', 5);

383: where location_id = p_location_id;
384: --
385: begin
386: --
387: hr_utility.set_location('Entered hr_us_reports.get_address', 5);
388: --
389: open get_location_record;
390: --
391: fetch get_location_record into v_address_line_1, v_address_line_2,

Line 394: hr_utility.set_location('hr_us_reports.get_address', 10);

390: --
391: fetch get_location_record into v_address_line_1, v_address_line_2,
392: v_address_line_3, v_town_or_city, v_region_2, v_postal_code;
393: --
394: hr_utility.set_location('hr_us_reports.get_address', 10);
395: --
396: if get_location_record%found
397: then
398: --

Line 429: hr_utility.set_location('hr_us_reports.get_address', 15);

425: end if;
426: --
427: close get_location_record;
428: --
429: hr_utility.set_location('hr_us_reports.get_address', 15);
430: --
431: hr_utility.trace('location is '|| f_address);
432: p_address := f_address;
433: --

Line 431: hr_utility.trace('location is '|| f_address);

427: close get_location_record;
428: --
429: hr_utility.set_location('hr_us_reports.get_address', 15);
430: --
431: hr_utility.trace('location is '|| f_address);
432: p_address := f_address;
433: --
434: end if;
435: --

Line 438: hr_utility.trace('Error in hr_us_reports.get_address');

434: end if;
435: --
436: exception
437: when others then
438: hr_utility.trace('Error in hr_us_reports.get_address');
439: hr_utility.set_location('hr_us_reports.get_address', 20);
440: --
441: end get_address;
442: --

Line 439: hr_utility.set_location('hr_us_reports.get_address', 20);

435: --
436: exception
437: when others then
438: hr_utility.trace('Error in hr_us_reports.get_address');
439: hr_utility.set_location('hr_us_reports.get_address', 20);
440: --
441: end get_address;
442: --
443: --

Line 494: hr_utility.trace('location is '|| f_address);

490: substr(address_record.postal_code,1,12);
491: end if;
492: --
493: close get_location_record;
494: hr_utility.trace('location is '|| f_address);
495: p_address := f_address;
496: end if;
497: end get_address_31;
498: --

Line 537: hr_utility.trace('address is '|| f_addr_line1 );

533: --
534: p_addr_line1 := f_addr_line1;
535: p_addr_line2 := f_addr_line2;
536: p_city_state_zip := f_city_state_zip;
537: hr_utility.trace('address is '|| f_addr_line1 );
538: hr_utility.trace( f_addr_line2 );
539: hr_utility.trace( f_city_state_zip );
540: end if;
541: end get_address_3lines;

Line 538: hr_utility.trace( f_addr_line2 );

534: p_addr_line1 := f_addr_line1;
535: p_addr_line2 := f_addr_line2;
536: p_city_state_zip := f_city_state_zip;
537: hr_utility.trace('address is '|| f_addr_line1 );
538: hr_utility.trace( f_addr_line2 );
539: hr_utility.trace( f_city_state_zip );
540: end if;
541: end get_address_3lines;
542: --

Line 539: hr_utility.trace( f_city_state_zip );

535: p_addr_line2 := f_addr_line2;
536: p_city_state_zip := f_city_state_zip;
537: hr_utility.trace('address is '|| f_addr_line1 );
538: hr_utility.trace( f_addr_line2 );
539: hr_utility.trace( f_city_state_zip );
540: end if;
541: end get_address_3lines;
542: --
543:

Line 583: hr_utility.set_location('Entered hr_us_reports.get_employee_address', 0);

579: and nvl(date_to, sysdate) >= sysdate;
580: --
581: begin
582: --
583: hr_utility.set_location('Entered hr_us_reports.get_employee_address', 0);
584: --
585: open get_address_record;
586: --
587: fetch get_address_record into v_address_line1, v_address_line2,

Line 590: hr_utility.set_location('Entered hr_us_reports.get_employee_address', 5);

586: --
587: fetch get_address_record into v_address_line1, v_address_line2,
588: v_address_line3, v_town_or_city, v_region_2, v_postal_code;
589: --
590: hr_utility.set_location('Entered hr_us_reports.get_employee_address', 5);
591: --
592: if get_address_record%found
593: then
594: --

Line 625: hr_utility.set_location('hr_us_reports.get_employee_address', 10);

621: end if;
622: --
623: insert into pay_us_rpt_totals(ATTRIBUTE30,attribute1) values(f_address,'test1');
624: commit;
625: hr_utility.set_location('hr_us_reports.get_employee_address', 10);
626: close get_address_record;
627: --
628: hr_utility.trace('Person Address is '|| f_address);
629: --

Line 628: hr_utility.trace('Person Address is '|| f_address);

624: commit;
625: hr_utility.set_location('hr_us_reports.get_employee_address', 10);
626: close get_address_record;
627: --
628: hr_utility.trace('Person Address is '|| f_address);
629: --
630: p_address := f_address;
631: --
632: end if;

Line 634: hr_utility.set_location('Leaving hr_us_reports.get_employee_address', 15);

630: p_address := f_address;
631: --
632: end if;
633: --
634: hr_utility.set_location('Leaving hr_us_reports.get_employee_address', 15);
635: --
636: exception when NO_DATA_FOUND then NULL;
637: --
638: end get_employee_address;

Line 681: hr_utility.trace('location is '|| f_address);

677: f_address := f_address ||address_record.region_2||' '||
678: address_record.postal_code;
679: end if;
680: close get_location_record;
681: hr_utility.trace('location is '|| f_address);
682: p_address := f_address;
683: end if;
684: end get_county_address;
685: --

Line 720: hr_utility.trace('establishment activity is '|| f_activity);

716: f_activity := f_activity ||
717: rpad(activity_record.activity_line4,40,' ');
718: end if;
719: close get_establishment_record;
720: hr_utility.trace('establishment activity is '|| f_activity);
721: p_activity := f_activity;
722: end if;
723: end get_activity;
724: --

Line 733: hr_utility.trace('Entered Get_consolidation_set');

729: l_consolidation_set_name VARCHAR2(60);
730: --
731: begin
732: --
733: hr_utility.trace('Entered Get_consolidation_set');
734: --
735: begin
736: hr_utility.set_location('hr_us_reports.get_consolidation_set',5);
737: SELECT consolidation_set_name

Line 736: hr_utility.set_location('hr_us_reports.get_consolidation_set',5);

732: --
733: hr_utility.trace('Entered Get_consolidation_set');
734: --
735: begin
736: hr_utility.set_location('hr_us_reports.get_consolidation_set',5);
737: SELECT consolidation_set_name
738: INTO l_consolidation_set_name
739: FROM pay_consolidation_sets
740: WHERE consolidation_set_id = p_consolidation_set_id;

Line 758: hr_utility.trace('Entered Get_payment_type_name');

754: l_payment_type_name VARCHAR2(60);
755: --
756: begin
757: --
758: hr_utility.trace('Entered Get_payment_type_name');
759: --
760: begin
761: hr_utility.set_location('hr_us_reports.get_payment_type_name',5);
762: SELECT ppt_tl.payment_type_name

Line 761: hr_utility.set_location('hr_us_reports.get_payment_type_name',5);

757: --
758: hr_utility.trace('Entered Get_payment_type_name');
759: --
760: begin
761: hr_utility.set_location('hr_us_reports.get_payment_type_name',5);
762: SELECT ppt_tl.payment_type_name
763: INTO l_payment_type_name
764: FROM pay_payment_types_tl ppt_tl,
765: pay_payment_types ppt

Line 786: hr_utility.trace('Entered Get_element_type_name');

782: l_element_type_name VARCHAR2(60);
783: --
784: begin
785: --
786: hr_utility.trace('Entered Get_element_type_name');
787: --
788: begin
789: hr_utility.set_location('hr_us_reports.get_element_type_name',5);
790: SELECT pet_tl.element_name

Line 789: hr_utility.set_location('hr_us_reports.get_element_type_name',5);

785: --
786: hr_utility.trace('Entered Get_element_type_name');
787: --
788: begin
789: hr_utility.set_location('hr_us_reports.get_element_type_name',5);
790: SELECT pet_tl.element_name
791: INTO l_element_type_name
792: FROM pay_element_classifications pec,
793: pay_element_types_f_tl pet_tl,

Line 816: hr_utility.trace('Entered Get_tax_unit');

812: l_tax_unit_name VARCHAR2(240);
813: --
814: begin
815: --
816: hr_utility.trace('Entered Get_tax_unit');
817: --
818: begin
819: hr_utility.set_location('hr_us_reports.get_tax_unit',5);
820: SELECT name

Line 819: hr_utility.set_location('hr_us_reports.get_tax_unit',5);

815: --
816: hr_utility.trace('Entered Get_tax_unit');
817: --
818: begin
819: hr_utility.set_location('hr_us_reports.get_tax_unit',5);
820: SELECT name
821: INTO l_tax_unit_name
822: FROM hr_organization_units
823: WHERE organization_id = p_tax_unit_id;

Line 841: hr_utility.trace('Entered get_person_name');

837: l_person_name VARCHAR2(240);
838: --
839: begin
840: --
841: hr_utility.trace('Entered get_person_name');
842: --
843: begin
844: hr_utility.set_location('hr_us_reports.get_person_name',5);
845: SELECT distinct full_name

Line 844: hr_utility.set_location('hr_us_reports.get_person_name',5);

840: --
841: hr_utility.trace('Entered get_person_name');
842: --
843: begin
844: hr_utility.set_location('hr_us_reports.get_person_name',5);
845: SELECT distinct full_name
846: INTO l_person_name
847: FROM per_people_f ppf
848: WHERE person_id = p_person_id

Line 871: hr_utility.trace('Entered Get_payroll_action');

867: l_payroll_action_name VARCHAR2(60);
868: --
869: begin
870: --
871: hr_utility.trace('Entered Get_payroll_action');
872: --
873: begin
874: hr_utility.set_location('hr_us_reports.get_payroll_action',5);
875: SELECT action_type

Line 874: hr_utility.set_location('hr_us_reports.get_payroll_action',5);

870: --
871: hr_utility.trace('Entered Get_payroll_action');
872: --
873: begin
874: hr_utility.set_location('hr_us_reports.get_payroll_action',5);
875: SELECT action_type
876: INTO l_action_type
877: FROM pay_payroll_actions
878: WHERE payroll_action_id = p_payroll_action_id;

Line 884: hr_utility.set_location('hr_us_reports.get_payroll_action',10);

880: exception when NO_DATA_FOUND then RETURN NULL;
881: end;
882: if l_action_type = 'P' then
883: begin
884: hr_utility.set_location('hr_us_reports.get_payroll_action',10);
885: SELECT ppa.display_run_number || '-' || pcs.consolidation_set_name
886: || '-' || ppa.effective_date || '-' || ppa.payroll_action_id
887: INTO l_payroll_action_name
888: FROM pay_consolidation_sets pcs,

Line 897: hr_utility.set_location('hr_us_reports.get_payroll_action',15);

893: when no_data_found then RETURN NULL;
894: end;
895: elsif l_action_type = 'R' then
896: begin
897: hr_utility.set_location('hr_us_reports.get_payroll_action',15);
898: SELECT ppa.display_run_number || '-' || has.assignment_set_name
899: || '-' || pes.element_set_name
900: INTO l_payroll_action_name
901: FROM hr_assignment_sets has,

Line 944: hr_utility.trace('Entered Get_legislation_code');

940: l_legislation_code VARCHAR2(30);
941: --
942: begin
943: --
944: hr_utility.trace('Entered Get_legislation_code');
945: --
946: begin
947: hr_utility.set_location('hr_us_reports.get_legislation_code',5);
948: SELECT org_information9

Line 947: hr_utility.set_location('hr_us_reports.get_legislation_code',5);

943: --
944: hr_utility.trace('Entered Get_legislation_code');
945: --
946: begin
947: hr_utility.set_location('hr_us_reports.get_legislation_code',5);
948: SELECT org_information9
949: INTO l_legislation_code
950: FROM hr_organization_information
951: WHERE organization_id = p_business_group_id

Line 974: hr_utility.trace('Entered Get_defined_balance_id');

970: l_found BOOLEAN;
971: --
972: begin
973: --
974: hr_utility.trace('Entered Get_defined_balance_id');
975: --
976: -- Search for the defined balance in the Cache.
977: --
978: l_defbal_name := p_balance_name||p_dimension_suffix||p_business_group_id;

Line 993: hr_utility.set_location('hr_us_reports.get_defined_balance_id',5);

989: -- If the balance is not in the Cache get it from the database.
990: --
991: if (l_found = FALSE) then
992: begin
993: hr_utility.set_location('hr_us_reports.get_defined_balance_id',5);
994: /* Legislation code is added in this query so that it does not
995: fetch multiple values after Canadian Payroll is installed - mmukherj*/
996: SELECT pdb.defined_balance_id
997: INTO l_defined_balance_id

Line 1034: hr_utility.trace('Entered Get_startup_defined_balance');

1030: l_defined_balance_id NUMBER;
1031: --
1032: begin
1033: --
1034: hr_utility.trace('Entered Get_startup_defined_balance');
1035: --
1036: begin
1037: hr_utility.set_location('hr_us_reports.get_startup_defined_balance',5);
1038: SELECT pdb.defined_balance_id

Line 1037: hr_utility.set_location('hr_us_reports.get_startup_defined_balance',5);

1033: --
1034: hr_utility.trace('Entered Get_startup_defined_balance');
1035: --
1036: begin
1037: hr_utility.set_location('hr_us_reports.get_startup_defined_balance',5);
1038: SELECT pdb.defined_balance_id
1039: INTO l_defined_balance_id
1040: FROM pay_defined_balances pdb
1041: , pay_balance_dimensions pbd

Line 1068: hr_utility.trace('Entered Get_defined_balance_by_type');

1064: l_balance_type_name VARCHAR2(30);
1065: --
1066: begin
1067: --
1068: hr_utility.trace('Entered Get_defined_balance_by_type');
1069: --
1070: -- **NOTE** We do not yet have the 'US_TAX DEDUCTIONS' category seeded yet.
1071: --
1072: hr_utility.set_location('hr_us_reports.get_defined_balance_by_type',5);

Line 1072: hr_utility.set_location('hr_us_reports.get_defined_balance_by_type',5);

1068: hr_utility.trace('Entered Get_defined_balance_by_type');
1069: --
1070: -- **NOTE** We do not yet have the 'US_TAX DEDUCTIONS' category seeded yet.
1071: --
1072: hr_utility.set_location('hr_us_reports.get_defined_balance_by_type',5);
1073: --
1074: IF
1075: p_box_num = '10' THEN
1076: l_balance_type_name := 'Dependent Care'; -- *OK*

Line 1100: hr_utility.set_location('hr_us_reports.get_defined_balance_by_type',10);

1096: when NO_DATA_FOUND then RETURN NULL;
1097: end;
1098: --
1099: begin
1100: hr_utility.set_location('hr_us_reports.get_defined_balance_by_type',10);
1101: --
1102: SELECT pdb.defined_balance_id
1103: INTO l_defined_balance_id
1104: FROM pay_defined_balances pdb

Line 1128: hr_utility.trace('Entered hr_reports.get_ben_class_name');

1124: --
1125: v_benefit_class_name ben_benefit_classifications.benefit_classification_name%type;
1126: --
1127: begin
1128: hr_utility.trace('Entered hr_reports.get_ben_class_name');
1129: --
1130: hr_utility.set_location('hr_reports.get_ben_class_name',5);
1131: if p_benefit_classification_id is null then
1132: null;

Line 1130: hr_utility.set_location('hr_reports.get_ben_class_name',5);

1126: --
1127: begin
1128: hr_utility.trace('Entered hr_reports.get_ben_class_name');
1129: --
1130: hr_utility.set_location('hr_reports.get_ben_class_name',5);
1131: if p_benefit_classification_id is null then
1132: null;
1133: else
1134: begin

Line 1135: hr_utility.set_location('hr_reports.get_ben_class_name',10);

1131: if p_benefit_classification_id is null then
1132: null;
1133: else
1134: begin
1135: hr_utility.set_location('hr_reports.get_ben_class_name',10);
1136: select benefit_classification_name
1137: into v_benefit_class_name
1138: from ben_benefit_classifications
1139: where benefit_classification_id = p_benefit_classification_id;

Line 1145: hr_utility.trace('Leaving hr_reports.get_ben_class_name');

1141: when no_data_found then RETURN NULL;
1142: end;
1143: end if;
1144: --
1145: hr_utility.trace('Leaving hr_reports.get_ben_class_name');
1146: --
1147: return v_benefit_class_name;
1148: --
1149: end get_ben_class_name;

Line 1158: hr_utility.trace('Entered hr_reports.get_cobra_qualifying_event');

1154: --
1155: v_qualifying_event_meaning hr_lookups.meaning%type;
1156: --
1157: BEGIN
1158: hr_utility.trace('Entered hr_reports.get_cobra_qualifying_event');
1159: --
1160: hr_utility.set_location('hr_reports.get_cobra_qualifying_event',5);
1161: IF p_qualifying_event IS NULL
1162: THEN

Line 1160: hr_utility.set_location('hr_reports.get_cobra_qualifying_event',5);

1156: --
1157: BEGIN
1158: hr_utility.trace('Entered hr_reports.get_cobra_qualifying_event');
1159: --
1160: hr_utility.set_location('hr_reports.get_cobra_qualifying_event',5);
1161: IF p_qualifying_event IS NULL
1162: THEN
1163: NULL;
1164: ELSE

Line 1166: hr_utility.set_location('hr_reports.get_cobra_qualifying_event',10);

1162: THEN
1163: NULL;
1164: ELSE
1165: BEGIN
1166: hr_utility.set_location('hr_reports.get_cobra_qualifying_event',10);
1167: SELECT meaning
1168: INTO v_qualifying_event_meaning
1169: FROM hr_lookups
1170: WHERE lookup_type = 'US_COBRA_EVENT'

Line 1177: hr_utility.trace('Leaving hr_reports.get_cobra_qualifying_event');

1173: WHEN no_data_found THEN RETURN NULL;
1174: END;
1175: END IF;
1176: --
1177: hr_utility.trace('Leaving hr_reports.get_cobra_qualifying_event');
1178: --
1179: return v_qualifying_event_meaning;
1180: --
1181: END get_cobra_qualifying_event;

Line 1190: hr_utility.trace('Entered hr_reports.get_cobra_status');

1186: --
1187: v_cobra_status_meaning hr_lookups.meaning%type;
1188: --
1189: BEGIN
1190: hr_utility.trace('Entered hr_reports.get_cobra_status');
1191: --
1192: hr_utility.set_location('hr_reports.get_cobra_status',5);
1193: IF p_cobra_status IS NULL
1194: THEN

Line 1192: hr_utility.set_location('hr_reports.get_cobra_status',5);

1188: --
1189: BEGIN
1190: hr_utility.trace('Entered hr_reports.get_cobra_status');
1191: --
1192: hr_utility.set_location('hr_reports.get_cobra_status',5);
1193: IF p_cobra_status IS NULL
1194: THEN
1195: NULL;
1196: ELSE

Line 1198: hr_utility.set_location('hr_reports.get_cobra_status',10);

1194: THEN
1195: NULL;
1196: ELSE
1197: BEGIN
1198: hr_utility.set_location('hr_reports.get_cobra_status',10);
1199: SELECT meaning
1200: INTO v_cobra_status_meaning
1201: FROM hr_lookups
1202: WHERE lookup_type = 'US_COBRA_STATUS'

Line 1209: hr_utility.trace('Leaving hr_reports.get_cobra_status');

1205: WHEN no_data_found THEN RETURN NULL;
1206: END;
1207: END IF;
1208: --
1209: hr_utility.trace('Leaving hr_reports.get_cobra_status');
1210: --
1211: return v_cobra_status_meaning;
1212: --
1213: END get_cobra_status;

Line 1248: hr_utility.trace('Parent tax unit >'||parent_tax_unit_id);

1244: tax_unit_flag := 'N';
1245: OPEN get_parent;
1246: WHILE tax_unit_flag = 'N' LOOP
1247: FETCH get_parent INTO parent_tax_unit_id;
1248: hr_utility.trace('Parent tax unit >'||parent_tax_unit_id);
1249: EXIT WHEN get_parent%NOTFOUND;
1250: hr_utility.trace('Parent tax unit >'||parent_tax_unit_id);
1251: /* sackumar */
1252: begin

Line 1250: hr_utility.trace('Parent tax unit >'||parent_tax_unit_id);

1246: WHILE tax_unit_flag = 'N' LOOP
1247: FETCH get_parent INTO parent_tax_unit_id;
1248: hr_utility.trace('Parent tax unit >'||parent_tax_unit_id);
1249: EXIT WHEN get_parent%NOTFOUND;
1250: hr_utility.trace('Parent tax unit >'||parent_tax_unit_id);
1251: /* sackumar */
1252: begin
1253: SELECT 'Y'
1254: INTO tax_unit_flag

Line 1275: hr_utility.trace('Est tax unit >'||parent_tax_unit_id);

1271: */
1272: END LOOP;
1273: CLOSE get_parent;
1274: --
1275: hr_utility.trace('Est tax unit >'||parent_tax_unit_id);
1276: return (parent_tax_unit_id);
1277: --
1278: end get_est_tax_unit;
1279: --

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

1350: hr_tax_unit_flag := 'N';
1351: l_proc := 'get_hr_est_tax_unit';
1352:
1353: --
1354: hr_utility.set_location('Entering...' || l_proc,10);
1355: OPEN check_if_top_org;
1356: LOOP
1357: BEGIN
1358: FETCH check_if_top_org INTO hr_tax_unit_id;

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

1365: CLOSE check_if_top_org;
1366: --
1367: IF p_starting_org_id = hr_tax_unit_id
1368: THEN
1369: hr_utility.set_location(l_proc,20);
1370: parent_hr_tax_unit_id := p_starting_org_id;
1371: --
1372: ELSE
1373: --

Line 1379: --hr_utility.trace('Parent hr_tax unit >'||parent_hr_tax_unit_id);

1375: OPEN get_hr_parent;
1376: WHILE hr_tax_unit_flag = 'N'
1377: LOOP
1378: FETCH get_hr_parent INTO parent_hr_tax_unit_id;
1379: --hr_utility.trace('Parent hr_tax unit >'||parent_hr_tax_unit_id);
1380: EXIT WHEN get_hr_parent%NOTFOUND;
1381: hr_utility.trace('Parent hr_tax unit >'||parent_hr_tax_unit_id);
1382:
1383: /* commented out for BUG3141907

Line 1381: hr_utility.trace('Parent hr_tax unit >'||parent_hr_tax_unit_id);

1377: LOOP
1378: FETCH get_hr_parent INTO parent_hr_tax_unit_id;
1379: --hr_utility.trace('Parent hr_tax unit >'||parent_hr_tax_unit_id);
1380: EXIT WHEN get_hr_parent%NOTFOUND;
1381: hr_utility.trace('Parent hr_tax unit >'||parent_hr_tax_unit_id);
1382:
1383: /* commented out for BUG3141907
1384: --
1385: SELECT decode(hr_tax_unit_id,'','N','Y')

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

1391: */
1392: --
1393: -- BUG3141907
1394: --
1395: hr_utility.set_location(l_proc,30);
1396: open csr_tax_unit_flag(parent_hr_tax_unit_id);
1397: hr_utility.set_location(l_proc,31);
1398: fetch csr_tax_unit_flag into l_tax_unit_id;
1399: if csr_tax_unit_flag%found then

Line 1397: hr_utility.set_location(l_proc,31);

1393: -- BUG3141907
1394: --
1395: hr_utility.set_location(l_proc,30);
1396: open csr_tax_unit_flag(parent_hr_tax_unit_id);
1397: hr_utility.set_location(l_proc,31);
1398: fetch csr_tax_unit_flag into l_tax_unit_id;
1399: if csr_tax_unit_flag%found then
1400: hr_utility.set_location(l_proc,40);
1401: hr_tax_unit_flag := 'Y';

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

1396: open csr_tax_unit_flag(parent_hr_tax_unit_id);
1397: hr_utility.set_location(l_proc,31);
1398: fetch csr_tax_unit_flag into l_tax_unit_id;
1399: if csr_tax_unit_flag%found then
1400: hr_utility.set_location(l_proc,40);
1401: hr_tax_unit_flag := 'Y';
1402: else
1403: hr_utility.set_location(l_proc,50);
1404: hr_tax_unit_flag := 'N';

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

1399: if csr_tax_unit_flag%found then
1400: hr_utility.set_location(l_proc,40);
1401: hr_tax_unit_flag := 'Y';
1402: else
1403: hr_utility.set_location(l_proc,50);
1404: hr_tax_unit_flag := 'N';
1405: end if;
1406: close csr_tax_unit_flag;
1407:

Line 1408: hr_utility.trace('hr_tax_unit_flag > '||hr_tax_unit_flag);

1404: hr_tax_unit_flag := 'N';
1405: end if;
1406: close csr_tax_unit_flag;
1407:
1408: hr_utility.trace('hr_tax_unit_flag > '||hr_tax_unit_flag);
1409: hr_utility.set_location(l_proc,50);
1410: END LOOP;
1411: CLOSE get_hr_parent;
1412: --

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

1405: end if;
1406: close csr_tax_unit_flag;
1407:
1408: hr_utility.trace('hr_tax_unit_flag > '||hr_tax_unit_flag);
1409: hr_utility.set_location(l_proc,50);
1410: END LOOP;
1411: CLOSE get_hr_parent;
1412: --
1413: --

Line 1416: hr_utility.trace('Est hr_tax unit >'||parent_hr_tax_unit_id);

1412: --
1413: --
1414: END IF;
1415: --
1416: hr_utility.trace('Est hr_tax unit >'||parent_hr_tax_unit_id);
1417: hr_utility.set_location('Leaving...' || l_proc,100);
1418: return (parent_hr_tax_unit_id);
1419: --
1420: end get_hr_est_tax_unit;

Line 1417: hr_utility.set_location('Leaving...' || l_proc,100);

1413: --
1414: END IF;
1415: --
1416: hr_utility.trace('Est hr_tax unit >'||parent_hr_tax_unit_id);
1417: hr_utility.set_location('Leaving...' || l_proc,100);
1418: return (parent_hr_tax_unit_id);
1419: --
1420: end get_hr_est_tax_unit;
1421: --

Line 1454: hr_utility.set_location('Entered hr_us_reports.get_state_name',5);

1450: l_state_name VARCHAR2(60);
1451: --
1452: begin
1453: --
1454: hr_utility.set_location('Entered hr_us_reports.get_state_name',5);
1455: --
1456: SELECT state_name
1457: INTO l_state_name
1458: FROM pay_us_states

Line 1461: hr_utility.set_location('Leaving hr_us_reports.get_state_name',10);

1457: INTO l_state_name
1458: FROM pay_us_states
1459: WHERE state_abbrev = p_state_code;
1460: --
1461: hr_utility.set_location('Leaving hr_us_reports.get_state_name',10);
1462: --
1463: return l_state_name;
1464: --
1465: exception when NO_DATA_FOUND then RETURN NULL;

Line 1478: hr_utility.set_location('Entered hr_us_reports.get_org_name',5);

1474: l_org_name VARCHAR2(240);
1475: --
1476: begin
1477: --
1478: hr_utility.set_location('Entered hr_us_reports.get_org_name',5);
1479: --
1480: SELECT name
1481: INTO l_org_name
1482: FROM hr_organization_units

Line 1486: hr_utility.set_location('Leaving hr_us_reports.get_org_name',10);

1482: FROM hr_organization_units
1483: WHERE organization_id = p_organization_id
1484: AND business_group_id + 0 = p_business_group_id;
1485: --
1486: hr_utility.set_location('Leaving hr_us_reports.get_org_name',10);
1487: return l_org_name;
1488: --
1489: exception when NO_DATA_FOUND then RETURN NULL;
1490: when others then

Line 1491: hr_utility.set_location('Error found in hr_us_reports.get_org_name',15);

1487: return l_org_name;
1488: --
1489: exception when NO_DATA_FOUND then RETURN NULL;
1490: when others then
1491: hr_utility.set_location('Error found in hr_us_reports.get_org_name',15);
1492: RETURN NULL;
1493: --
1494: end get_org_name;
1495: --

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

1597: BEGIN
1598:
1599: l_proc := 'hr_us_reports.get_top_org_id';
1600:
1601: hr_utility.set_location('Entering...' || l_proc,10);
1602:
1603: open csr_get_element;
1604: fetch csr_get_element into l_exists;
1605: if csr_get_element%NOTFOUND then

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

1603: open csr_get_element;
1604: fetch csr_get_element into l_exists;
1605: if csr_get_element%NOTFOUND then
1606: close csr_get_element;
1607: hr_utility.set_location(l_proc,20);
1608: l_organization_id_child := p_business_group_id;
1609: else
1610: close csr_get_element;
1611: open csr_get_max_child_id;

Line 1614: hr_utility.trace('l_organization_id_child : ' || l_organization_id_child);

1610: close csr_get_element;
1611: open csr_get_max_child_id;
1612: fetch csr_get_max_child_id into l_organization_id_child;
1613: close csr_get_max_child_id;
1614: hr_utility.trace('l_organization_id_child : ' || l_organization_id_child);
1615: hr_utility.set_location(l_proc,30);
1616: loop
1617: open csr_get_parent(l_organization_id_child);
1618: fetch csr_get_parent into l_organization_id_parent;

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

1611: open csr_get_max_child_id;
1612: fetch csr_get_max_child_id into l_organization_id_child;
1613: close csr_get_max_child_id;
1614: hr_utility.trace('l_organization_id_child : ' || l_organization_id_child);
1615: hr_utility.set_location(l_proc,30);
1616: loop
1617: open csr_get_parent(l_organization_id_child);
1618: fetch csr_get_parent into l_organization_id_parent;
1619: exit when csr_get_parent%NOTFOUND;

Line 1621: hr_utility.trace('l_organization_id_patent : ' || l_organization_id_parent);

1617: open csr_get_parent(l_organization_id_child);
1618: fetch csr_get_parent into l_organization_id_parent;
1619: exit when csr_get_parent%NOTFOUND;
1620: close csr_get_parent;
1621: hr_utility.trace('l_organization_id_patent : ' || l_organization_id_parent);
1622: l_organization_id_child := l_organization_id_parent;
1623: end loop;
1624: close csr_get_parent;
1625: end if;

Line 1626: hr_utility.trace('top_org_id is ' || l_organization_id_child);

1622: l_organization_id_child := l_organization_id_parent;
1623: end loop;
1624: close csr_get_parent;
1625: end if;
1626: hr_utility.trace('top_org_id is ' || l_organization_id_child);
1627: hr_utility.set_location('Leaving...' || l_proc,40);
1628: return l_organization_id_child;
1629: --
1630: exception when NO_DATA_FOUND then RETURN p_business_group_id;

Line 1627: hr_utility.set_location('Leaving...' || l_proc,40);

1623: end loop;
1624: close csr_get_parent;
1625: end if;
1626: hr_utility.trace('top_org_id is ' || l_organization_id_child);
1627: hr_utility.set_location('Leaving...' || l_proc,40);
1628: return l_organization_id_child;
1629: --
1630: exception when NO_DATA_FOUND then RETURN p_business_group_id;
1631: --

Line 1779: hr_utility.set_location('Entered hr_us_reports.get_employee_address40', 0);

1775: --
1776: begin
1777: --
1778:
1779: hr_utility.set_location('Entered hr_us_reports.get_employee_address40', 0);
1780: --
1781: open get_address_record;
1782: --
1783: fetch get_address_record into v_address_line1, v_address_line2,

Line 1786: hr_utility.set_location('Entered hr_us_reports.get_employee_address40', 5);

1782: --
1783: fetch get_address_record into v_address_line1, v_address_line2,
1784: v_address_line3, v_town_or_city, v_region_2, v_postal_code;
1785: --
1786: hr_utility.set_location('Entered hr_us_reports.get_employee_address40', 5);
1787: --
1788: if get_address_record%found
1789: then
1790: --

Line 1819: hr_utility.set_location('hr_us_reports.get_employee_address40', 10);

1815: f_address := f_address ||v_region_2||' '||
1816: v_postal_code;
1817: end if;
1818: --
1819: hr_utility.set_location('hr_us_reports.get_employee_address40', 10);
1820: close get_address_record;
1821: --
1822: hr_utility.trace('Person Address is '|| f_address);
1823: --

Line 1822: hr_utility.trace('Person Address is '|| f_address);

1818: --
1819: hr_utility.set_location('hr_us_reports.get_employee_address40', 10);
1820: close get_address_record;
1821: --
1822: hr_utility.trace('Person Address is '|| f_address);
1823: --
1824: p_address := f_address;
1825: --
1826: end if;

Line 1828: hr_utility.set_location('Leaving hr_us_reports.get_employee_address40', 15);

1824: p_address := f_address;
1825: --
1826: end if;
1827: --
1828: hr_utility.set_location('Leaving hr_us_reports.get_employee_address40', 15);
1829: --
1830: exception when NO_DATA_FOUND then NULL;
1831: --
1832: end get_employee_address40;