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

Line 201: hr_utility.trace('Legislative parameters not found for pactid '||to_char(pactid));

197: hr_us_w2_mt.get_parameter
198: ('TRANSFER_GRE',ppa.legislative_parameters);
199: exception
200: when others then
201: hr_utility.trace('Legislative parameters not found for pactid '||to_char(pactid));
202: raise;
203: end;
204:
205: -- If it is not a PR W2 Report then only do the preprocess Agent GRE check

Line 207: hr_utility.trace('Checking for Preprocess Agent GRE setup');

203: end;
204:
205: -- If it is not a PR W2 Report then only do the preprocess Agent GRE check
206: if l_report_type <> 'PRW2PAPER' then
207: hr_utility.trace('Checking for Preprocess Agent GRE setup');
208: hr_us_w2_rep.get_agent_tax_unit_id ( l_business_group_id
209: ,l_year
210: ,l_agent_tax_unit_id
211: ,l_error_mesg ) ;

Line 241: hr_utility.raise_error;

237: pay_core_utils.push_token('record_name',' ');
238: pay_core_utils.push_token('description',substr(l_error_mesg,136,45));
239: end if;
240:
241: hr_utility.raise_error;
242: end if;
243:
244: end if;
245:

Line 247: hr_utility.trace('Before the range cursor');

243:
244: end if;
245:
246:
247: hr_utility.trace('Before the range cursor');
248: hr_utility.trace('EOY Payroll action id = '||l_eoy_payroll_action_id);
249:
250: sqlstr :=
251:

Line 248: hr_utility.trace('EOY Payroll action id = '||l_eoy_payroll_action_id);

244: end if;
245:
246:
247: hr_utility.trace('Before the range cursor');
248: hr_utility.trace('EOY Payroll action id = '||l_eoy_payroll_action_id);
249:
250: sqlstr :=
251:
252: 'SELECT

Line 261: hr_utility.trace('After the range cursor');

257: ' AND :payroll_action_id is not null
258: AND paa_arch.action_status = ''C''
259: order by to_number(paa_arch.serial_number) ';
260:
261: hr_utility.trace('After the range cursor');
262:
263: end range_cursor;
264:
265:

Line 393: hr_utility.set_location(l_procedure_name, 1);

389: c_actions_where varchar2(10000);
390:
391: begin
392: l_procedure_name := 'action_creation_for_ee';
393: hr_utility.set_location(l_procedure_name, 1);
394: /* 4152323 { */
395: select effective_date,
396: report_type,
397: report_qualifier,

Line 420: hr_utility.set_location(l_procedure_name, 2);

416: When Others Then
417: l_report_format := Null ;
418: End ;
419:
420: hr_utility.set_location(l_procedure_name, 2);
421: l_range_person_on := pay_ac_utility.range_person_on
422: ( p_report_type => l_report_type,
423: p_report_format => l_report_format,
424: p_report_qualifier => l_report_qualifier,

Line 437: hr_utility.set_location(l_procedure_name, 5);

433: (p_ssn is null ) and
434: (p_state_code is null ) and
435: (p_asg_set_id is null )) then
436:
437: hr_utility.set_location(l_procedure_name, 5);
438: if l_range_person_on = TRUE Then
439: hr_utility.set_location(l_procedure_name, 10);
440: hr_utility.trace('Range Person ID Functionality is enabled') ;
441: c_actions_no_selection_sql :=

Line 439: hr_utility.set_location(l_procedure_name, 10);

435: (p_asg_set_id is null )) then
436:
437: hr_utility.set_location(l_procedure_name, 5);
438: if l_range_person_on = TRUE Then
439: hr_utility.set_location(l_procedure_name, 10);
440: hr_utility.trace('Range Person ID Functionality is enabled') ;
441: c_actions_no_selection_sql :=
442: 'SELECT paa_arch.assignment_action_id,
443: paa_arch.assignment_id,

Line 440: hr_utility.trace('Range Person ID Functionality is enabled') ;

436:
437: hr_utility.set_location(l_procedure_name, 5);
438: if l_range_person_on = TRUE Then
439: hr_utility.set_location(l_procedure_name, 10);
440: hr_utility.trace('Range Person ID Functionality is enabled') ;
441: c_actions_no_selection_sql :=
442: 'SELECT paa_arch.assignment_action_id,
443: paa_arch.assignment_id,
444: paa_arch.tax_unit_id,

Line 486: hr_utility.trace(' c_actions_no_selection_sql' ||c_actions_no_selection_sql);

482: END IF;
483:
484:
485: -- c_actions_no_selection_sql := c_actions_no_selection_sql || c_actions_where;
486: hr_utility.trace(' c_actions_no_selection_sql' ||c_actions_no_selection_sql);
487: else
488: hr_utility.set_location(l_procedure_name, 15);
489: c_actions_no_selection_sql :=
490: 'SELECT paa_arch.assignment_action_id,

Line 488: hr_utility.set_location(l_procedure_name, 15);

484:
485: -- c_actions_no_selection_sql := c_actions_no_selection_sql || c_actions_where;
486: hr_utility.trace(' c_actions_no_selection_sql' ||c_actions_no_selection_sql);
487: else
488: hr_utility.set_location(l_procedure_name, 15);
489: c_actions_no_selection_sql :=
490: 'SELECT paa_arch.assignment_action_id,
491: paa_arch.assignment_id,
492: paa_arch.tax_unit_id,

Line 519: hr_utility.trace(' c_actions_no_selection_sql' ||c_actions_no_selection_sql);

515: p_session_date);
516: ELSE
517: c_actions_no_selection_sql := c_actions_no_selection_sql || c_actions_where;
518: END IF;
519: hr_utility.trace(' c_actions_no_selection_sql' ||c_actions_no_selection_sql);
520:
521: end if ;
522:
523: hr_utility.set_location(l_procedure_name, 20);

Line 523: hr_utility.set_location(l_procedure_name, 20);

519: hr_utility.trace(' c_actions_no_selection_sql' ||c_actions_no_selection_sql);
520:
521: end if ;
522:
523: hr_utility.set_location(l_procedure_name, 20);
524: OPEN c_actions_no_selection FOR c_actions_no_selection_sql;
525: num := 0;
526:
527: loop

Line 531: hr_utility.trace('In the c_actions_no_selection%found in action cursor');

527: loop
528: fetch c_actions_no_selection into lockedactid,assignid,greid,l_effective_end_date;
529: if c_actions_no_selection%found then
530: num := num + 1;
531: hr_utility.trace('In the c_actions_no_selection%found in action cursor');
532: else
533: hr_utility.trace('In the c_actions_no_selection%notfound in action cursor');
534: exit;
535: end if;

Line 533: hr_utility.trace('In the c_actions_no_selection%notfound in action cursor');

529: if c_actions_no_selection%found then
530: num := num + 1;
531: hr_utility.trace('In the c_actions_no_selection%found in action cursor');
532: else
533: hr_utility.trace('In the c_actions_no_selection%notfound in action cursor');
534: exit;
535: end if;
536:
537: if pay_us_employee_payslip_web.get_doc_eit('W-2',

Line 546: hr_utility.set_location(l_procedure_name, 25);

542:
543: -- we need to insert one action for each of the
544: -- rows that we return from the cursor (i.e. one
545: -- for each assignment/pre-payment/reversal).
546: hr_utility.set_location(l_procedure_name, 25);
547: hr_utility.trace('Before inserting the action record');
548:
549: select pay_assignment_actions_s.nextval
550: into lockingactid

Line 547: hr_utility.trace('Before inserting the action record');

543: -- we need to insert one action for each of the
544: -- rows that we return from the cursor (i.e. one
545: -- for each assignment/pre-payment/reversal).
546: hr_utility.set_location(l_procedure_name, 25);
547: hr_utility.trace('Before inserting the action record');
548:
549: select pay_assignment_actions_s.nextval
550: into lockingactid
551: from dual;

Line 566: hr_utility.set_location(l_procedure_name, 30);

562: end loop;
563: close c_actions_no_selection;
564:
565: end if;
566: hr_utility.set_location(l_procedure_name, 30);
567:
568: /* when location is entered */
569: if p_loc_id is not null then
570: if l_range_person_on = TRUE Then

Line 571: hr_utility.set_location(l_procedure_name, 35);

567:
568: /* when location is entered */
569: if p_loc_id is not null then
570: if l_range_person_on = TRUE Then
571: hr_utility.set_location(l_procedure_name, 35);
572: c_actions_with_location_sql :=
573: 'SELECT paa_arch.assignment_action_id,
574: paa_arch.assignment_id,
575: paa_arch.tax_unit_id,

Line 603: hr_utility.set_location(l_procedure_name, 40);

599: AND ppr.chunk_number = ' || chunk || '
600: AND paf.person_id = ppr.person_id ' ;
601:
602: else
603: hr_utility.set_location(l_procedure_name, 40);
604: c_actions_with_location_sql :=
605: 'SELECT paa_arch.assignment_action_id,
606: paa_arch.assignment_id,
607: paa_arch.tax_unit_id,

Line 641: hr_utility.trace(' c_actions_with_location_sql ' ||c_actions_with_location_sql);

637: p_session_date);
638: ELSE
639: c_actions_with_location_sql := c_actions_with_location_sql || c_actions_where;
640: END IF;
641: hr_utility.trace(' c_actions_with_location_sql ' ||c_actions_with_location_sql);
642:
643:
644: hr_utility.set_location(l_procedure_name, 40);
645: OPEN c_actions_with_location FOR c_actions_with_location_sql;

Line 644: hr_utility.set_location(l_procedure_name, 40);

640: END IF;
641: hr_utility.trace(' c_actions_with_location_sql ' ||c_actions_with_location_sql);
642:
643:
644: hr_utility.set_location(l_procedure_name, 40);
645: OPEN c_actions_with_location FOR c_actions_with_location_sql;
646: num := 0;
647:
648: loop

Line 653: hr_utility.trace('In the c_actions_with_location%found in action cursor');

649: fetch c_actions_with_location into lockedactid,assignid,greid,l_effective_end_date;
650:
651: if c_actions_with_location%found then
652: num := num + 1;
653: hr_utility.trace('In the c_actions_with_location%found in action cursor');
654: else
655: hr_utility.trace('In the c_actions_with_location%notfound in action cursor');
656: exit;
657: end if;

Line 655: hr_utility.trace('In the c_actions_with_location%notfound in action cursor');

651: if c_actions_with_location%found then
652: num := num + 1;
653: hr_utility.trace('In the c_actions_with_location%found in action cursor');
654: else
655: hr_utility.trace('In the c_actions_with_location%notfound in action cursor');
656: exit;
657: end if;
658:
659: if pay_us_employee_payslip_web.get_doc_eit('W-2',

Line 668: hr_utility.set_location(l_procedure_name, 45);

664:
665: -- we need to insert one action for each of the
666: -- rows that we return from the cursor (i.e. one
667: -- for each assignment/pre-payment/reversal).
668: hr_utility.set_location(l_procedure_name, 45);
669: hr_utility.trace('Before inserting the action record');
670:
671: select pay_assignment_actions_s.nextval
672: into lockingactid

Line 669: hr_utility.trace('Before inserting the action record');

665: -- we need to insert one action for each of the
666: -- rows that we return from the cursor (i.e. one
667: -- for each assignment/pre-payment/reversal).
668: hr_utility.set_location(l_procedure_name, 45);
669: hr_utility.trace('Before inserting the action record');
670:
671: select pay_assignment_actions_s.nextval
672: into lockingactid
673: from dual;

Line 688: hr_utility.set_location(l_procedure_name, 50);

684: end loop;
685: close c_actions_with_location;
686:
687: end if;
688: hr_utility.set_location(l_procedure_name, 50);
689:
690:
691: /* when org is entered */
692: if p_org_id is not null then

Line 695: hr_utility.set_location(l_procedure_name, 60);

691: /* when org is entered */
692: if p_org_id is not null then
693:
694: if l_range_person_on = TRUE Then
695: hr_utility.set_location(l_procedure_name, 60);
696: hr_utility.trace('Range Person ID Functionality is enabled') ;
697: c_actions_with_org_sql :=
698: 'SELECT paa_arch.assignment_action_id,
699: paa_arch.assignment_id,

Line 696: hr_utility.trace('Range Person ID Functionality is enabled') ;

692: if p_org_id is not null then
693:
694: if l_range_person_on = TRUE Then
695: hr_utility.set_location(l_procedure_name, 60);
696: hr_utility.trace('Range Person ID Functionality is enabled') ;
697: c_actions_with_org_sql :=
698: 'SELECT paa_arch.assignment_action_id,
699: paa_arch.assignment_id,
700: paa_arch.tax_unit_id,

Line 729: hr_utility.set_location(l_procedure_name, 70);

725: AND paf.person_id = ppr.person_id ';
726:
727:
728: else
729: hr_utility.set_location(l_procedure_name, 70);
730: c_actions_with_org_sql :=
731: 'SELECT paa_arch.assignment_action_id,
732: paa_arch.assignment_id,
733: paa_arch.tax_unit_id,

Line 766: hr_utility.trace(' c_actions_with_org_sql ' ||c_actions_with_org_sql);

762: p_session_date);
763: ELSE
764: c_actions_with_org_sql := c_actions_with_org_sql || c_actions_where;
765: END IF;
766: hr_utility.trace(' c_actions_with_org_sql ' ||c_actions_with_org_sql);
767:
768:
769: hr_utility.set_location(l_procedure_name, 80);
770: OPEN c_actions_with_org FOR c_actions_with_org_sql;

Line 769: hr_utility.set_location(l_procedure_name, 80);

765: END IF;
766: hr_utility.trace(' c_actions_with_org_sql ' ||c_actions_with_org_sql);
767:
768:
769: hr_utility.set_location(l_procedure_name, 80);
770: OPEN c_actions_with_org FOR c_actions_with_org_sql;
771: num := 0;
772:
773: loop

Line 778: hr_utility.trace('In the c_actions_with_org%found in action cursor');

774: fetch c_actions_with_org into lockedactid,assignid,greid,l_effective_end_date;
775:
776: if c_actions_with_org%found then
777: num := num + 1;
778: hr_utility.trace('In the c_actions_with_org%found in action cursor');
779: else
780: hr_utility.trace('In the c_actions_with_org%notfound in action cursor');
781: exit;
782: end if;

Line 780: hr_utility.trace('In the c_actions_with_org%notfound in action cursor');

776: if c_actions_with_org%found then
777: num := num + 1;
778: hr_utility.trace('In the c_actions_with_org%found in action cursor');
779: else
780: hr_utility.trace('In the c_actions_with_org%notfound in action cursor');
781: exit;
782: end if;
783:
784: if pay_us_employee_payslip_web.get_doc_eit('W-2',

Line 793: hr_utility.set_location(l_procedure_name, 90);

789:
790: -- we need to insert one action for each of the
791: -- rows that we return from the cursor (i.e. one
792: -- for each assignment/pre-payment/reversal).
793: hr_utility.set_location(l_procedure_name, 90);
794: hr_utility.trace('Before inserting the action record');
795:
796: select pay_assignment_actions_s.nextval
797: into lockingactid

Line 794: hr_utility.trace('Before inserting the action record');

790: -- we need to insert one action for each of the
791: -- rows that we return from the cursor (i.e. one
792: -- for each assignment/pre-payment/reversal).
793: hr_utility.set_location(l_procedure_name, 90);
794: hr_utility.trace('Before inserting the action record');
795:
796: select pay_assignment_actions_s.nextval
797: into lockingactid
798: from dual;

Line 814: hr_utility.set_location(l_procedure_name, 100);

810: close c_actions_with_org;
811:
812: end if;
813:
814: hr_utility.set_location(l_procedure_name, 100);
815: /* when person or SSN is entered */
816: if (p_per_id is not null OR p_ssn is not null ) then
817:
818: /* Bug# 5513289: If p_print_term is set to 'Y' then assignment_action_ids

Line 848: hr_utility.trace(' c_actions_with_person_sql ' ||c_actions_with_person_sql);

844: p_session_date);
845: ELSE
846: c_actions_with_person_sql := c_actions_with_person_sql || c_actions_where;
847: END IF;
848: hr_utility.trace(' c_actions_with_person_sql ' ||c_actions_with_person_sql);
849:
850:
851: open c_actions_with_person for c_actions_with_person_sql;
852: /* Bug# 5513289 :Ending here */

Line 855: hr_utility.set_location('procpyr',2);

851: open c_actions_with_person for c_actions_with_person_sql;
852: /* Bug# 5513289 :Ending here */
853: num := 0;
854: loop
855: hr_utility.set_location('procpyr',2);
856: hr_utility.trace('after the loop in c_actions_with_person');
857: fetch c_actions_with_person into lockedactid,assignid,greid,l_effective_end_date;
858:
859: if c_actions_with_person%found then

Line 856: hr_utility.trace('after the loop in c_actions_with_person');

852: /* Bug# 5513289 :Ending here */
853: num := 0;
854: loop
855: hr_utility.set_location('procpyr',2);
856: hr_utility.trace('after the loop in c_actions_with_person');
857: fetch c_actions_with_person into lockedactid,assignid,greid,l_effective_end_date;
858:
859: if c_actions_with_person%found then
860: num := num + 1;

Line 861: hr_utility.trace('In the c_actions_with_person%found in action cursor');

857: fetch c_actions_with_person into lockedactid,assignid,greid,l_effective_end_date;
858:
859: if c_actions_with_person%found then
860: num := num + 1;
861: hr_utility.trace('In the c_actions_with_person%found in action cursor');
862: else
863: hr_utility.trace('In the c_actions_with_person%notfound in action cursor');
864: exit;
865: end if;

Line 863: hr_utility.trace('In the c_actions_with_person%notfound in action cursor');

859: if c_actions_with_person%found then
860: num := num + 1;
861: hr_utility.trace('In the c_actions_with_person%found in action cursor');
862: else
863: hr_utility.trace('In the c_actions_with_person%notfound in action cursor');
864: exit;
865: end if;
866:
867: if pay_us_employee_payslip_web.get_doc_eit('W-2',

Line 876: hr_utility.set_location(l_procedure_name, 110);

872:
873: -- we need to insert one action for each of the
874: -- rows that we return from the cursor (i.e. one
875: -- for each assignment/pre-payment/reversal).
876: hr_utility.set_location(l_procedure_name, 110);
877: hr_utility.trace('Before inserting the action record');
878:
879: select pay_assignment_actions_s.nextval
880: into lockingactid

Line 877: hr_utility.trace('Before inserting the action record');

873: -- we need to insert one action for each of the
874: -- rows that we return from the cursor (i.e. one
875: -- for each assignment/pre-payment/reversal).
876: hr_utility.set_location(l_procedure_name, 110);
877: hr_utility.trace('Before inserting the action record');
878:
879: select pay_assignment_actions_s.nextval
880: into lockingactid
881: from dual;

Line 897: hr_utility.set_location(l_procedure_name, 120);

893: close c_actions_with_person;
894:
895: end if;
896:
897: hr_utility.set_location(l_procedure_name, 120);
898: /* when state is entered */
899: if p_state_code is not null then
900: hr_utility.set_location(l_procedure_name, 130);
901:

Line 900: hr_utility.set_location(l_procedure_name, 130);

896:
897: hr_utility.set_location(l_procedure_name, 120);
898: /* when state is entered */
899: if p_state_code is not null then
900: hr_utility.set_location(l_procedure_name, 130);
901:
902: hr_utility.trace('p_state_code = ' || p_state_code);
903: open c_state_context('TAX_UNIT_ID');
904: fetch c_state_context into l_tuid_context;

Line 902: hr_utility.trace('p_state_code = ' || p_state_code);

898: /* when state is entered */
899: if p_state_code is not null then
900: hr_utility.set_location(l_procedure_name, 130);
901:
902: hr_utility.trace('p_state_code = ' || p_state_code);
903: open c_state_context('TAX_UNIT_ID');
904: fetch c_state_context into l_tuid_context;
905: close c_state_context;
906:

Line 912: hr_utility.set_location(l_procedure_name, 140);

908: fetch c_state_context into l_juri_context;
909: close c_state_context;
910:
911: if l_range_person_on = TRUE Then
912: hr_utility.set_location(l_procedure_name, 140);
913: hr_utility.trace('Range Person ID Functionality is enabled') ;
914: c_actions_with_state_sql :=
915: 'SELECT paa_arch.assignment_action_id,
916: paa_arch.assignment_id,

Line 913: hr_utility.trace('Range Person ID Functionality is enabled') ;

909: close c_state_context;
910:
911: if l_range_person_on = TRUE Then
912: hr_utility.set_location(l_procedure_name, 140);
913: hr_utility.trace('Range Person ID Functionality is enabled') ;
914: c_actions_with_state_sql :=
915: 'SELECT paa_arch.assignment_action_id,
916: paa_arch.assignment_id,
917: paa_arch.tax_unit_id,

Line 937: hr_utility.set_location(l_procedure_name, 150);

933: AND ppr.payroll_action_id = ' || pactid || '
934: AND ppr.chunk_number = ' || chunk || '
935: AND paf.person_id = ppr.person_id ';
936: else
937: hr_utility.set_location(l_procedure_name, 150);
938: c_actions_with_state_sql :=
939: 'SELECT paa_arch.assignment_action_id,
940: paa_arch.assignment_id,
941: paa_arch.tax_unit_id,

Line 967: hr_utility.trace(' c_actions_with_state_sql ' ||c_actions_with_state_sql);

963: p_session_date);
964: ELSE
965: c_actions_with_state_sql := c_actions_with_state_sql || c_actions_where;
966: END IF;
967: hr_utility.trace(' c_actions_with_state_sql ' ||c_actions_with_state_sql);
968:
969:
970: hr_utility.set_location(l_procedure_name, 160);
971: if p_locality_code is null then

Line 970: hr_utility.set_location(l_procedure_name, 160);

966: END IF;
967: hr_utility.trace(' c_actions_with_state_sql ' ||c_actions_with_state_sql);
968:
969:
970: hr_utility.set_location(l_procedure_name, 160);
971: if p_locality_code is null then
972: open c_state_ueid('A_SIT_SUBJ_WHABLE_PER_JD_GRE_YTD');
973: fetch c_state_ueid into l_subj_whable;
974: close c_state_ueid;

Line 980: hr_utility.set_location(l_procedure_name, 170);

976: open c_state_ueid('A_SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD');
977: fetch c_state_ueid into l_subj_nwhable;
978: close c_state_ueid;
979:
980: hr_utility.set_location(l_procedure_name, 170);
981: c_actions_with_state_sql := c_actions_with_state_sql ||
982: ' AND exists ( select 1 from dual
983: where 1 =
984: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)

Line 1002: hr_utility.set_location(l_procedure_name, 180);

998: -- County
999: --
1000: elsif length(p_locality_code) = 11 and
1001: substr(p_locality_code, 8,4) = '0000' then
1002: hr_utility.set_location(l_procedure_name, 180);
1003: --Bug #4886044
1004: -- Added the check for the User Entity 'A_COUNTY_WITHHELD_PER_JD_GRE_YTD'
1005: -- Only employees who have both Wages and Taxes withheld
1006: -- from the specified locality shoule be reported for that

Line 1058: hr_utility.set_location(l_procedure_name, 190);

1054: -- City
1055: --
1056: elsif length(p_locality_code) = 11 and
1057: substr(p_locality_code, 8,4) <> '0000' then
1058: hr_utility.set_location(l_procedure_name, 190);
1059:
1060: -- Bug 4645408
1061: -- Added the check for the User Entity 'A_CITY_WK_WITHHELD_PER_JD_GRE_YTD'
1062: -- Only employees who have both Wages and Taxes withheld

Line 1071: hr_utility.set_location(l_procedure_name, 170);

1067: open c_state_ueid('A_CITY_WITHHELD_PER_JD_GRE_YTD'); /* 6909926 */
1068: fetch c_state_ueid into l_city_wk_whld;
1069: close c_state_ueid;
1070:
1071: hr_utility.set_location(l_procedure_name, 170);
1072: c_actions_with_state_sql := c_actions_with_state_sql ||
1073: ' AND exists ( select 1 from dual
1074: where 1 =
1075: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)

Line 1116: hr_utility.set_location(l_procedure_name, 200);

1112: --
1113: -- School District
1114: --
1115: elsif length(p_locality_code) = 8 then
1116: hr_utility.set_location(l_procedure_name, 200);
1117: --Bug #4886044
1118: -- Added the check for the User Entity 'A_SCHOOL_WITHHELD_PER_JD_GRE_YTD'
1119: -- Only employees who have both Wages and Taxes withheld
1120: -- from the specified locality shoule be reported for that

Line 1168: hr_utility.set_location(l_procedure_name, 210);

1164: and fai.archive_item_id = fic2.archive_item_id
1165: and fic2.context_id = ' || l_juri_context || '
1166: and substr(ltrim(rtrim(fic2.context)),1,8) = ''' || p_locality_code || '''))';
1167: end if;
1168: hr_utility.set_location(l_procedure_name, 210);
1169:
1170:
1171: num := 0;
1172: OPEN c_actions_with_state FOR c_actions_with_state_sql;

Line 1178: hr_utility.trace('In the c_actions_with_state%found in action cursor');

1174: fetch c_actions_with_state into lockedactid,assignid,greid,l_effective_end_date;
1175:
1176: if c_actions_with_state%found then
1177: num := num + 1;
1178: hr_utility.trace('In the c_actions_with_state%found in action cursor');
1179: else
1180: hr_utility.trace('In the c_actions_with_state%notfound in action cursor');
1181: exit;
1182: end if;

Line 1180: hr_utility.trace('In the c_actions_with_state%notfound in action cursor');

1176: if c_actions_with_state%found then
1177: num := num + 1;
1178: hr_utility.trace('In the c_actions_with_state%found in action cursor');
1179: else
1180: hr_utility.trace('In the c_actions_with_state%notfound in action cursor');
1181: exit;
1182: end if;
1183:
1184: if pay_us_employee_payslip_web.get_doc_eit('W-2',

Line 1193: hr_utility.set_location(l_procedure_name, 220);

1189:
1190: -- we need to insert one action for each of the
1191: -- rows that we return from the cursor (i.e. one
1192: -- for each assignment/pre-payment/reversal).
1193: hr_utility.set_location(l_procedure_name, 220);
1194: hr_utility.trace('Before inserting the action record');
1195:
1196: select pay_assignment_actions_s.nextval
1197: into lockingactid

Line 1194: hr_utility.trace('Before inserting the action record');

1190: -- we need to insert one action for each of the
1191: -- rows that we return from the cursor (i.e. one
1192: -- for each assignment/pre-payment/reversal).
1193: hr_utility.set_location(l_procedure_name, 220);
1194: hr_utility.trace('Before inserting the action record');
1195:
1196: select pay_assignment_actions_s.nextval
1197: into lockingactid
1198: from dual;

Line 1213: hr_utility.set_location(l_procedure_name, 230);

1209: end loop;
1210: close c_actions_with_state;
1211:
1212: end if;
1213: hr_utility.set_location(l_procedure_name, 230);
1214:
1215: /* when assignment set is entered */
1216: if p_asg_set_id is not null then
1217:

Line 1219: hr_utility.set_location(l_procedure_name, 240);

1215: /* when assignment set is entered */
1216: if p_asg_set_id is not null then
1217:
1218: if l_range_person_on = TRUE Then
1219: hr_utility.set_location(l_procedure_name, 240);
1220: hr_utility.trace('Range Person ID Functionality is enabled') ;
1221: c_actions_with_assign_sql :=
1222: 'SELECT paa_arch.assignment_action_id,
1223: paa_arch.assignment_id,

Line 1220: hr_utility.trace('Range Person ID Functionality is enabled') ;

1216: if p_asg_set_id is not null then
1217:
1218: if l_range_person_on = TRUE Then
1219: hr_utility.set_location(l_procedure_name, 240);
1220: hr_utility.trace('Range Person ID Functionality is enabled') ;
1221: c_actions_with_assign_sql :=
1222: 'SELECT paa_arch.assignment_action_id,
1223: paa_arch.assignment_id,
1224: paa_arch.tax_unit_id,

Line 1248: hr_utility.set_location(l_procedure_name, 250);

1244: where hasa.assignment_set_id = ' || p_asg_set_id || '
1245: and hasa.assignment_id = paa_arch.assignment_id
1246: and upper(hasa.include_or_exclude) = ''I'') ';
1247: else
1248: hr_utility.set_location(l_procedure_name, 250);
1249: c_actions_with_assign_sql :=
1250: 'SELECT paa_arch.assignment_action_id,
1251: paa_arch.assignment_id,
1252: paa_arch.tax_unit_id,

Line 1282: hr_utility.trace(' c_actions_with_assign_sql ' ||c_actions_with_assign_sql);

1278: p_session_date);
1279: ELSE
1280: c_actions_with_assign_sql := c_actions_with_assign_sql || c_actions_where;
1281: END IF;
1282: hr_utility.trace(' c_actions_with_assign_sql ' ||c_actions_with_assign_sql);
1283:
1284: hr_utility.set_location(l_procedure_name, 260);
1285: OPEN c_actions_with_assign_set FOR c_actions_with_assign_sql;
1286: num := 0;

Line 1284: hr_utility.set_location(l_procedure_name, 260);

1280: c_actions_with_assign_sql := c_actions_with_assign_sql || c_actions_where;
1281: END IF;
1282: hr_utility.trace(' c_actions_with_assign_sql ' ||c_actions_with_assign_sql);
1283:
1284: hr_utility.set_location(l_procedure_name, 260);
1285: OPEN c_actions_with_assign_set FOR c_actions_with_assign_sql;
1286: num := 0;
1287:
1288: loop

Line 1293: hr_utility.trace('In the c_actions_with_assign_set%found in action cursor');

1289: fetch c_actions_with_assign_set into lockedactid,assignid,greid,l_effective_end_date;
1290:
1291: if c_actions_with_assign_set%found then
1292: num := num + 1;
1293: hr_utility.trace('In the c_actions_with_assign_set%found in action cursor');
1294: else
1295: hr_utility.trace('In the c_actions_with_assign_set%notfound in action cursor');
1296: exit;
1297: end if;

Line 1295: hr_utility.trace('In the c_actions_with_assign_set%notfound in action cursor');

1291: if c_actions_with_assign_set%found then
1292: num := num + 1;
1293: hr_utility.trace('In the c_actions_with_assign_set%found in action cursor');
1294: else
1295: hr_utility.trace('In the c_actions_with_assign_set%notfound in action cursor');
1296: exit;
1297: end if;
1298:
1299: if pay_us_employee_payslip_web.get_doc_eit('W-2',

Line 1308: hr_utility.set_location(l_procedure_name, 270);

1304:
1305: -- we need to insert one action for each of the
1306: -- rows that we return from the cursor (i.e. one
1307: -- for each assignment/pre-payment/reversal).
1308: hr_utility.set_location(l_procedure_name, 270);
1309: hr_utility.trace('Before inserting the action record');
1310:
1311: hr_utility.set_location('procpyr',3);
1312:

Line 1309: hr_utility.trace('Before inserting the action record');

1305: -- we need to insert one action for each of the
1306: -- rows that we return from the cursor (i.e. one
1307: -- for each assignment/pre-payment/reversal).
1308: hr_utility.set_location(l_procedure_name, 270);
1309: hr_utility.trace('Before inserting the action record');
1310:
1311: hr_utility.set_location('procpyr',3);
1312:
1313: select pay_assignment_actions_s.nextval

Line 1311: hr_utility.set_location('procpyr',3);

1307: -- for each assignment/pre-payment/reversal).
1308: hr_utility.set_location(l_procedure_name, 270);
1309: hr_utility.trace('Before inserting the action record');
1310:
1311: hr_utility.set_location('procpyr',3);
1312:
1313: select pay_assignment_actions_s.nextval
1314: into lockingactid
1315: from dual;

Line 1330: hr_utility.set_location(l_procedure_name, 300);

1326: end loop;
1327: close c_actions_with_assign_set;
1328:
1329: end if;
1330: hr_utility.set_location(l_procedure_name, 300);
1331: hr_utility.trace('End of the action cursor');
1332:
1333: end action_creation_for_ee;
1334:

Line 1331: hr_utility.trace('End of the action cursor');

1327: close c_actions_with_assign_set;
1328:
1329: end if;
1330: hr_utility.set_location(l_procedure_name, 300);
1331: hr_utility.trace('End of the action cursor');
1332:
1333: end action_creation_for_ee;
1334:
1335: ---------------------------------- action_creation_for_er -----------------------------

Line 1438: hr_utility.set_location('procpyr',1);

1434: c_actions_with_org_sql varchar2(10000);
1435: c_actions_with_assign_sql varchar2(10000);
1436:
1437: begin
1438: hr_utility.set_location('procpyr',1);
1439: hr_utility.trace('In the ER action cursor');
1440:
1441: /* 4152323 { */
1442: select effective_date,

Line 1439: hr_utility.trace('In the ER action cursor');

1435: c_actions_with_assign_sql varchar2(10000);
1436:
1437: begin
1438: hr_utility.set_location('procpyr',1);
1439: hr_utility.trace('In the ER action cursor');
1440:
1441: /* 4152323 { */
1442: select effective_date,
1443: report_type,

Line 1503: hr_utility.trace('Range Person ID Functionality is enabled') ;

1499: (p_ssn is null ) and
1500: (p_asg_set_id is null )) then
1501:
1502: if l_range_person_on = TRUE Then
1503: hr_utility.trace('Range Person ID Functionality is enabled') ;
1504: c_actions_no_selection_sql :=
1505: 'SELECT paa_arch.assignment_action_id,
1506: paa_arch.assignment_id,
1507: paa_arch.tax_unit_id,

Line 1586: hr_utility.set_location('procpyr',2);

1582: OPEN c_actions_no_selection for c_actions_no_selection_sql;
1583: num := 0;
1584:
1585: loop
1586: hr_utility.set_location('procpyr',2);
1587: hr_utility.trace('after the loop in action cursor');
1588: fetch c_actions_no_selection into lockedactid,assignid,greid,l_effective_end_date;
1589:
1590: if c_actions_no_selection%found then

Line 1587: hr_utility.trace('after the loop in action cursor');

1583: num := 0;
1584:
1585: loop
1586: hr_utility.set_location('procpyr',2);
1587: hr_utility.trace('after the loop in action cursor');
1588: fetch c_actions_no_selection into lockedactid,assignid,greid,l_effective_end_date;
1589:
1590: if c_actions_no_selection%found then
1591: num := num + 1;

Line 1592: hr_utility.trace('In the c_actions_no_selection%found in action cursor');

1588: fetch c_actions_no_selection into lockedactid,assignid,greid,l_effective_end_date;
1589:
1590: if c_actions_no_selection%found then
1591: num := num + 1;
1592: hr_utility.trace('In the c_actions_no_selection%found in action cursor');
1593: else
1594: hr_utility.trace('In the c_actions_no_selection%notfound in action cursor');
1595: exit;
1596: end if;

Line 1594: hr_utility.trace('In the c_actions_no_selection%notfound in action cursor');

1590: if c_actions_no_selection%found then
1591: num := num + 1;
1592: hr_utility.trace('In the c_actions_no_selection%found in action cursor');
1593: else
1594: hr_utility.trace('In the c_actions_no_selection%notfound in action cursor');
1595: exit;
1596: end if;
1597: -- we need to insert one action for each of the
1598: -- rows that we return from the cursor (i.e. one

Line 1600: hr_utility.trace('Before inserting the action record');

1596: end if;
1597: -- we need to insert one action for each of the
1598: -- rows that we return from the cursor (i.e. one
1599: -- for each assignment/pre-payment/reversal).
1600: hr_utility.trace('Before inserting the action record');
1601:
1602: hr_utility.set_location('procpyr',3);
1603:
1604: select pay_assignment_actions_s.nextval

Line 1602: hr_utility.set_location('procpyr',3);

1598: -- rows that we return from the cursor (i.e. one
1599: -- for each assignment/pre-payment/reversal).
1600: hr_utility.trace('Before inserting the action record');
1601:
1602: hr_utility.set_location('procpyr',3);
1603:
1604: select pay_assignment_actions_s.nextval
1605: into lockingactid
1606: from dual;

Line 1626: hr_utility.trace('Range Person ID Functionality is enabled') ;

1622:
1623: if p_loc_id is not null then
1624:
1625: if l_range_person_on = TRUE Then
1626: hr_utility.trace('Range Person ID Functionality is enabled') ;
1627: c_actions_with_location_sql :=
1628: 'SELECT paa_arch.assignment_action_id,
1629: paa_arch.assignment_id,
1630: paa_arch.tax_unit_id,

Line 1719: hr_utility.set_location('procpyr',2);

1715: OPEN c_actions_with_location for c_actions_with_location_sql;
1716: num := 0;
1717:
1718: loop
1719: hr_utility.set_location('procpyr',2);
1720: hr_utility.trace('after the loop in action cursor');
1721: fetch c_actions_with_location into lockedactid,assignid,greid,l_effective_end_date;
1722:
1723: if c_actions_with_location%found then

Line 1720: hr_utility.trace('after the loop in action cursor');

1716: num := 0;
1717:
1718: loop
1719: hr_utility.set_location('procpyr',2);
1720: hr_utility.trace('after the loop in action cursor');
1721: fetch c_actions_with_location into lockedactid,assignid,greid,l_effective_end_date;
1722:
1723: if c_actions_with_location%found then
1724: num := num + 1;

Line 1725: hr_utility.trace('In the c_actions_with_location%found in action cursor');

1721: fetch c_actions_with_location into lockedactid,assignid,greid,l_effective_end_date;
1722:
1723: if c_actions_with_location%found then
1724: num := num + 1;
1725: hr_utility.trace('In the c_actions_with_location%found in action cursor');
1726: else
1727: hr_utility.trace('In the c_actions_with_location%notfound in action cursor');
1728: exit;
1729: end if;

Line 1727: hr_utility.trace('In the c_actions_with_location%notfound in action cursor');

1723: if c_actions_with_location%found then
1724: num := num + 1;
1725: hr_utility.trace('In the c_actions_with_location%found in action cursor');
1726: else
1727: hr_utility.trace('In the c_actions_with_location%notfound in action cursor');
1728: exit;
1729: end if;
1730:
1731:

Line 1735: hr_utility.trace('Before inserting the action record');

1731:
1732: -- we need to insert one action for each of the
1733: -- rows that we return from the cursor (i.e. one
1734: -- for each assignment/pre-payment/reversal).
1735: hr_utility.trace('Before inserting the action record');
1736:
1737: hr_utility.set_location('procpyr',3);
1738:
1739: select pay_assignment_actions_s.nextval

Line 1737: hr_utility.set_location('procpyr',3);

1733: -- rows that we return from the cursor (i.e. one
1734: -- for each assignment/pre-payment/reversal).
1735: hr_utility.trace('Before inserting the action record');
1736:
1737: hr_utility.set_location('procpyr',3);
1738:
1739: select pay_assignment_actions_s.nextval
1740: into lockingactid
1741: from dual;

Line 1762: hr_utility.trace('Range Person ID Functionality is enabled') ;

1758:
1759: if p_org_id is not null then
1760:
1761: if l_range_person_on = TRUE Then
1762: hr_utility.trace('Range Person ID Functionality is enabled') ;
1763: c_actions_with_org_sql :=
1764: 'SELECT paa_arch.assignment_action_id,
1765: paa_arch.assignment_id,
1766: paa_arch.tax_unit_id,

Line 1855: hr_utility.set_location('procpyr',2);

1851: OPEN c_actions_with_org for c_actions_with_org_sql;
1852: num := 0;
1853:
1854: loop
1855: hr_utility.set_location('procpyr',2);
1856: hr_utility.trace('after the loop in c_actions_with_org');
1857: fetch c_actions_with_org into lockedactid,assignid,greid,l_effective_end_date;
1858:
1859: if c_actions_with_org%found then

Line 1856: hr_utility.trace('after the loop in c_actions_with_org');

1852: num := 0;
1853:
1854: loop
1855: hr_utility.set_location('procpyr',2);
1856: hr_utility.trace('after the loop in c_actions_with_org');
1857: fetch c_actions_with_org into lockedactid,assignid,greid,l_effective_end_date;
1858:
1859: if c_actions_with_org%found then
1860: num := num + 1;

Line 1861: hr_utility.trace('In the c_actions_with_org%found in action cursor');

1857: fetch c_actions_with_org into lockedactid,assignid,greid,l_effective_end_date;
1858:
1859: if c_actions_with_org%found then
1860: num := num + 1;
1861: hr_utility.trace('In the c_actions_with_org%found in action cursor');
1862: else
1863: hr_utility.trace('In the c_actions_with_org%notfound in action cursor');
1864: exit;
1865: end if;

Line 1863: hr_utility.trace('In the c_actions_with_org%notfound in action cursor');

1859: if c_actions_with_org%found then
1860: num := num + 1;
1861: hr_utility.trace('In the c_actions_with_org%found in action cursor');
1862: else
1863: hr_utility.trace('In the c_actions_with_org%notfound in action cursor');
1864: exit;
1865: end if;
1866:
1867:

Line 1871: hr_utility.trace('Before inserting the action record');

1867:
1868: -- we need to insert one action for each of the
1869: -- rows that we return from the cursor (i.e. one
1870: -- for each assignment/pre-payment/reversal).
1871: hr_utility.trace('Before inserting the action record');
1872:
1873: hr_utility.set_location('procpyr',3);
1874:
1875: select pay_assignment_actions_s.nextval

Line 1873: hr_utility.set_location('procpyr',3);

1869: -- rows that we return from the cursor (i.e. one
1870: -- for each assignment/pre-payment/reversal).
1871: hr_utility.trace('Before inserting the action record');
1872:
1873: hr_utility.set_location('procpyr',3);
1874:
1875: select pay_assignment_actions_s.nextval
1876: into lockingactid
1877: from dual;

Line 1899: hr_utility.set_location('procpyr',2);

1895: open c_actions_with_person;
1896: num := 0;
1897:
1898: loop
1899: hr_utility.set_location('procpyr',2);
1900: hr_utility.trace('after the loop in c_actions_with_person');
1901: fetch c_actions_with_person into lockedactid,assignid,greid,l_effective_end_date;
1902:
1903: if c_actions_with_person%found then

Line 1900: hr_utility.trace('after the loop in c_actions_with_person');

1896: num := 0;
1897:
1898: loop
1899: hr_utility.set_location('procpyr',2);
1900: hr_utility.trace('after the loop in c_actions_with_person');
1901: fetch c_actions_with_person into lockedactid,assignid,greid,l_effective_end_date;
1902:
1903: if c_actions_with_person%found then
1904: num := num + 1;

Line 1905: hr_utility.trace('In the c_actions_with_person%found in action cursor');

1901: fetch c_actions_with_person into lockedactid,assignid,greid,l_effective_end_date;
1902:
1903: if c_actions_with_person%found then
1904: num := num + 1;
1905: hr_utility.trace('In the c_actions_with_person%found in action cursor');
1906: else
1907: hr_utility.trace('In the c_actions_with_person%notfound in action cursor');
1908: exit;
1909: end if;

Line 1907: hr_utility.trace('In the c_actions_with_person%notfound in action cursor');

1903: if c_actions_with_person%found then
1904: num := num + 1;
1905: hr_utility.trace('In the c_actions_with_person%found in action cursor');
1906: else
1907: hr_utility.trace('In the c_actions_with_person%notfound in action cursor');
1908: exit;
1909: end if;
1910:
1911: -- we need to insert one action for each of the

Line 1914: hr_utility.trace('Before inserting the action record');

1910:
1911: -- we need to insert one action for each of the
1912: -- rows that we return from the cursor (i.e. one
1913: -- for each assignment/pre-payment/reversal).
1914: hr_utility.trace('Before inserting the action record');
1915:
1916: hr_utility.set_location('procpyr',3);
1917:
1918: select pay_assignment_actions_s.nextval

Line 1916: hr_utility.set_location('procpyr',3);

1912: -- rows that we return from the cursor (i.e. one
1913: -- for each assignment/pre-payment/reversal).
1914: hr_utility.trace('Before inserting the action record');
1915:
1916: hr_utility.set_location('procpyr',3);
1917:
1918: select pay_assignment_actions_s.nextval
1919: into lockingactid
1920: from dual;

Line 1940: hr_utility.trace('Range Person ID Functionality is enabled') ;

1936:
1937: if p_asg_set_id is not null then
1938:
1939: if l_range_person_on = TRUE Then
1940: hr_utility.trace('Range Person ID Functionality is enabled') ;
1941: c_actions_with_assign_sql :=
1942: 'SELECT paa_arch.assignment_action_id,
1943: paa_arch.assignment_id,
1944: paa_arch.tax_unit_id,

Line 2029: hr_utility.set_location('procpyr',2);

2025: OPEN c_actions_with_assign_set for c_actions_with_assign_sql;
2026: num := 0;
2027:
2028: loop
2029: hr_utility.set_location('procpyr',2);
2030: hr_utility.trace('after the loop in c_actions_with_assign_set');
2031: fetch c_actions_with_assign_set into lockedactid,assignid,greid,l_effective_end_date;
2032:
2033: if c_actions_with_assign_set%found then

Line 2030: hr_utility.trace('after the loop in c_actions_with_assign_set');

2026: num := 0;
2027:
2028: loop
2029: hr_utility.set_location('procpyr',2);
2030: hr_utility.trace('after the loop in c_actions_with_assign_set');
2031: fetch c_actions_with_assign_set into lockedactid,assignid,greid,l_effective_end_date;
2032:
2033: if c_actions_with_assign_set%found then
2034: num := num + 1;

Line 2035: hr_utility.trace('In the c_actions_with_assign_set%found in action cursor');

2031: fetch c_actions_with_assign_set into lockedactid,assignid,greid,l_effective_end_date;
2032:
2033: if c_actions_with_assign_set%found then
2034: num := num + 1;
2035: hr_utility.trace('In the c_actions_with_assign_set%found in action cursor');
2036: else
2037: hr_utility.trace('In the c_actions_with_assign_set%notfound in action cursor');
2038: exit;
2039: end if;

Line 2037: hr_utility.trace('In the c_actions_with_assign_set%notfound in action cursor');

2033: if c_actions_with_assign_set%found then
2034: num := num + 1;
2035: hr_utility.trace('In the c_actions_with_assign_set%found in action cursor');
2036: else
2037: hr_utility.trace('In the c_actions_with_assign_set%notfound in action cursor');
2038: exit;
2039: end if;
2040:
2041: -- we need to insert one action for each of the

Line 2044: hr_utility.trace('Before inserting the action record');

2040:
2041: -- we need to insert one action for each of the
2042: -- rows that we return from the cursor (i.e. one
2043: -- for each assignment/pre-payment/reversal).
2044: hr_utility.trace('Before inserting the action record');
2045:
2046: hr_utility.set_location('procpyr',3);
2047:
2048: select pay_assignment_actions_s.nextval

Line 2046: hr_utility.set_location('procpyr',3);

2042: -- rows that we return from the cursor (i.e. one
2043: -- for each assignment/pre-payment/reversal).
2044: hr_utility.trace('Before inserting the action record');
2045:
2046: hr_utility.set_location('procpyr',3);
2047:
2048: select pay_assignment_actions_s.nextval
2049: into lockingactid
2050: from dual;

Line 2064: hr_utility.trace('End of the action cursor');

2060: end loop;
2061: close c_actions_with_assign_set;
2062:
2063: end if;
2064: hr_utility.trace('End of the action cursor');
2065:
2066: end action_creation_for_er;
2067:
2068: ---------------------------------- action_creation -----------------------------

Line 2101: -- hr_utility.trace_on(null,'ORACLE');

2097:
2098: l_report_type pay_payroll_actions.report_type%TYPE;
2099:
2100: begin
2101: -- hr_utility.trace_on(null,'ORACLE');
2102: hr_utility.set_location('procpyr',1);
2103: hr_utility.trace('In the action cursor');
2104: Begin
2105: select to_number(hr_us_w2_mt.get_parameter('Year',ppa1.legislative_parameters)),

Line 2102: hr_utility.set_location('procpyr',1);

2098: l_report_type pay_payroll_actions.report_type%TYPE;
2099:
2100: begin
2101: -- hr_utility.trace_on(null,'ORACLE');
2102: hr_utility.set_location('procpyr',1);
2103: hr_utility.trace('In the action cursor');
2104: Begin
2105: select to_number(hr_us_w2_mt.get_parameter('Year',ppa1.legislative_parameters)),
2106: to_number(hr_us_w2_mt.get_parameter('GRE_ID',ppa1.legislative_parameters)),

Line 2103: hr_utility.trace('In the action cursor');

2099:
2100: begin
2101: -- hr_utility.trace_on(null,'ORACLE');
2102: hr_utility.set_location('procpyr',1);
2103: hr_utility.trace('In the action cursor');
2104: Begin
2105: select to_number(hr_us_w2_mt.get_parameter('Year',ppa1.legislative_parameters)),
2106: to_number(hr_us_w2_mt.get_parameter('GRE_ID',ppa1.legislative_parameters)),
2107: to_number(hr_us_w2_mt.get_parameter('ORG_ID',ppa1.legislative_parameters)),

Line 2145: hr_utility.trace('Legislative parameters not found for pactid '||to_char(pactid));

2141: hr_us_w2_mt.get_parameter
2142: ('TRANSFER_GRE',ppa.legislative_parameters);
2143: Exception
2144: when no_data_found then
2145: hr_utility.trace('Legislative parameters not found for pactid '||to_char(pactid));
2146: raise;
2147: End ;
2148: hr_utility.trace('report_type = '||l_report_type);
2149: hr_utility.trace('l_locality_code = '||l_locality_code);

Line 2148: hr_utility.trace('report_type = '||l_report_type);

2144: when no_data_found then
2145: hr_utility.trace('Legislative parameters not found for pactid '||to_char(pactid));
2146: raise;
2147: End ;
2148: hr_utility.trace('report_type = '||l_report_type);
2149: hr_utility.trace('l_locality_code = '||l_locality_code);
2150:
2151:
2152: /* Now the SSN value set return person_id. Since the submittion is based on

Line 2149: hr_utility.trace('l_locality_code = '||l_locality_code);

2145: hr_utility.trace('Legislative parameters not found for pactid '||to_char(pactid));
2146: raise;
2147: End ;
2148: hr_utility.trace('report_type = '||l_report_type);
2149: hr_utility.trace('l_locality_code = '||l_locality_code);
2150:
2151:
2152: /* Now the SSN value set return person_id. Since the submittion is based on
2153: selection citeria only only value can be entered so in case l_ssn is not

Line 2183: hr_utility.trace('Action creation for Puerto Rico Employee W2');

2179: elsif l_report_type = 'PRW2PAPER' then /*Puerto Rico Employee W2*/
2180:
2181: l_state_code :=null;
2182:
2183: hr_utility.trace('Action creation for Puerto Rico Employee W2');
2184: hr_utility.trace('stperson ' ||to_char(stperson));
2185: hr_utility.trace('endperson ' ||to_char(endperson));
2186: hr_utility.trace('l_eoy_payroll_action_id = '||to_char(l_eoy_payroll_action_id));
2187:

Line 2184: hr_utility.trace('stperson ' ||to_char(stperson));

2180:
2181: l_state_code :=null;
2182:
2183: hr_utility.trace('Action creation for Puerto Rico Employee W2');
2184: hr_utility.trace('stperson ' ||to_char(stperson));
2185: hr_utility.trace('endperson ' ||to_char(endperson));
2186: hr_utility.trace('l_eoy_payroll_action_id = '||to_char(l_eoy_payroll_action_id));
2187:
2188: hr_utility.trace('pactid = '||to_char(pactid));

Line 2185: hr_utility.trace('endperson ' ||to_char(endperson));

2181: l_state_code :=null;
2182:
2183: hr_utility.trace('Action creation for Puerto Rico Employee W2');
2184: hr_utility.trace('stperson ' ||to_char(stperson));
2185: hr_utility.trace('endperson ' ||to_char(endperson));
2186: hr_utility.trace('l_eoy_payroll_action_id = '||to_char(l_eoy_payroll_action_id));
2187:
2188: hr_utility.trace('pactid = '||to_char(pactid));
2189: action_creation_for_ee(pactid,stperson,endperson,chunk,l_year,

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

2182:
2183: hr_utility.trace('Action creation for Puerto Rico Employee W2');
2184: hr_utility.trace('stperson ' ||to_char(stperson));
2185: hr_utility.trace('endperson ' ||to_char(endperson));
2186: hr_utility.trace('l_eoy_payroll_action_id = '||to_char(l_eoy_payroll_action_id));
2187:
2188: hr_utility.trace('pactid = '||to_char(pactid));
2189: action_creation_for_ee(pactid,stperson,endperson,chunk,l_year,
2190: l_gre_id,l_org_id,l_loc_id,l_per_id,

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

2184: hr_utility.trace('stperson ' ||to_char(stperson));
2185: hr_utility.trace('endperson ' ||to_char(endperson));
2186: hr_utility.trace('l_eoy_payroll_action_id = '||to_char(l_eoy_payroll_action_id));
2187:
2188: hr_utility.trace('pactid = '||to_char(pactid));
2189: action_creation_for_ee(pactid,stperson,endperson,chunk,l_year,
2190: l_gre_id,l_org_id,l_loc_id,l_per_id,
2191: l_ssn,l_state_code,l_asg_set_id,
2192: l_session_date,l_eoy_payroll_action_id,

Line 2257: hr_utility.trace('Error in Sort Procedure - getting legislative param');

2253: from pay_payroll_actions ppa
2254: where ppa.payroll_action_id = payactid;
2255:
2256: exception when no_data_found then
2257: hr_utility.trace('Error in Sort Procedure - getting legislative param');
2258: raise;
2259: end;
2260: /* changed this with the if statement below
2261: begin

Line 2282: hr_utility.trace('Beginning of the sort_action cursor');

2278: if l_year_end > l_dt then
2279: l_dt := l_year_end;
2280: end if;
2281:
2282: hr_utility.trace('Beginning of the sort_action cursor');
2283:
2284: sqlstr :=
2285: 'select mt.rowid
2286: from hr_organization_units hou, hr_locations_all hl, per_periods_of_service pps, per_assignments_f paf,

Line 2333: hr_utility.trace('End of the sort_Action cursor');

2329: -- changed on 11sep02
2330: -- for update of paf.assignment_id';
2331:
2332: len := length(sqlstr); -- return the length of the string.
2333: hr_utility.trace('End of the sort_Action cursor');
2334: end sort_action;
2335: --
2336: ------------------------------ get_parameter -------------------------------
2337: function get_parameter(name in varchar2,