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

Line 122: --hr_utility.trace_on(null,'pyus109r');

118: l_procedure_name VARCHAR2(100);
119: --
120: begin
121: l_procedure_name := g_package||'range_cursor';
122: --hr_utility.trace_on(null,'pyus109r');
123: hr_utility.trace('Before the range cursor');
124: hr_utility.trace('Entering :'||l_procedure_name);
125:
126: select pay_1099R_pkg.get_parameter('YEAR',ppa.legislative_parameters),

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

119: --
120: begin
121: l_procedure_name := g_package||'range_cursor';
122: --hr_utility.trace_on(null,'pyus109r');
123: hr_utility.trace('Before the range cursor');
124: hr_utility.trace('Entering :'||l_procedure_name);
125:
126: select pay_1099R_pkg.get_parameter('YEAR',ppa.legislative_parameters),
127: pay_1099R_pkg.get_parameter('TAX_ID',ppa.legislative_parameters),

Line 124: hr_utility.trace('Entering :'||l_procedure_name);

120: begin
121: l_procedure_name := g_package||'range_cursor';
122: --hr_utility.trace_on(null,'pyus109r');
123: hr_utility.trace('Before the range cursor');
124: hr_utility.trace('Entering :'||l_procedure_name);
125:
126: select pay_1099R_pkg.get_parameter('YEAR',ppa.legislative_parameters),
127: pay_1099R_pkg.get_parameter('TAX_ID',ppa.legislative_parameters),
128: pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa.legislative_parameters)

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

146: AND ppa_arch.action_status = ''C''
147: AND ppa_arch.payroll_action_id = paa_arch.payroll_action_id
148: order by to_number(paa_arch.serial_number) ';
149:
150: hr_utility.trace('After the range cursor');
151:
152: hr_utility.trace('Leaving :'||l_procedure_name);
153: end range_cursor;
154:

Line 152: hr_utility.trace('Leaving :'||l_procedure_name);

148: order by to_number(paa_arch.serial_number) ';
149:
150: hr_utility.trace('After the range cursor');
151:
152: hr_utility.trace('Leaving :'||l_procedure_name);
153: end range_cursor;
154:
155:
156:

Line 299: --hr_utility.trace_on(null,'pyus109r');

295: begin
296:
297: l_procedure_name := g_package||'action_creation';
298:
299: --hr_utility.trace_on(null,'pyus109r');
300: hr_utility.trace('Entering :'||l_procedure_name);
301: hr_utility.set_location('action_cursor',1);
302: hr_utility.trace('In the action cursor');
303:

Line 300: hr_utility.trace('Entering :'||l_procedure_name);

296:
297: l_procedure_name := g_package||'action_creation';
298:
299: --hr_utility.trace_on(null,'pyus109r');
300: hr_utility.trace('Entering :'||l_procedure_name);
301: hr_utility.set_location('action_cursor',1);
302: hr_utility.trace('In the action cursor');
303:
304: open c_payroll_param(pactid);

Line 301: hr_utility.set_location('action_cursor',1);

297: l_procedure_name := g_package||'action_creation';
298:
299: --hr_utility.trace_on(null,'pyus109r');
300: hr_utility.trace('Entering :'||l_procedure_name);
301: hr_utility.set_location('action_cursor',1);
302: hr_utility.trace('In the action cursor');
303:
304: open c_payroll_param(pactid);
305: fetch c_payroll_param into l_year,

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

298:
299: --hr_utility.trace_on(null,'pyus109r');
300: hr_utility.trace('Entering :'||l_procedure_name);
301: hr_utility.set_location('action_cursor',1);
302: hr_utility.trace('In the action cursor');
303:
304: open c_payroll_param(pactid);
305: fetch c_payroll_param into l_year,
306: l_gre_id,

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

333: When Others Then
334: l_report_format := Null ;
335: End ;
336:
337: hr_utility.set_location(l_procedure_name, 2);
338: l_range_person_on := pay_ac_utility.range_person_on
339: ( p_report_type => l_report_type,
340: p_report_format => l_report_format,
341: p_report_qualifier => l_report_qualifier,

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

347: (l_ssn is null ) and
348: (l_state_code is null ) and
349: (l_asg_set_id is null )) then
350:
351: hr_utility.set_location(l_procedure_name, 5);
352: if l_range_person_on = TRUE Then
353: hr_utility.set_location(l_procedure_name, 10);
354: hr_utility.trace('Range Person ID Functionality is enabled') ;
355: c_actions_no_selection_sql :=

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

349: (l_asg_set_id is null )) then
350:
351: hr_utility.set_location(l_procedure_name, 5);
352: if l_range_person_on = TRUE Then
353: hr_utility.set_location(l_procedure_name, 10);
354: hr_utility.trace('Range Person ID Functionality is enabled') ;
355: c_actions_no_selection_sql :=
356: 'SELECT paa_arch.assignment_action_id,
357: paa_arch.assignment_id,

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

350:
351: hr_utility.set_location(l_procedure_name, 5);
352: if l_range_person_on = TRUE Then
353: hr_utility.set_location(l_procedure_name, 10);
354: hr_utility.trace('Range Person ID Functionality is enabled') ;
355: c_actions_no_selection_sql :=
356: 'SELECT paa_arch.assignment_action_id,
357: paa_arch.assignment_id,
358: paa_arch.tax_unit_id,

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

375: AND ppr.chunk_number = ' || chunk || '
376: AND paf.person_id = ppr.person_id
377: and paf.person_id = to_number(paa_arch.serial_number)';
378: else
379: hr_utility.set_location(l_procedure_name, 15);
380: c_actions_no_selection_sql :=
381: 'SELECT paa_arch.assignment_action_id,
382: paa_arch.assignment_id,
383: paa_arch.tax_unit_id,

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

398: AND paf.person_id between ' || stperson || ' and ' || endperson || '
399: and paf.person_id = to_number(paa_arch.serial_number)';
400: end if ;
401:
402: hr_utility.set_location(l_procedure_name, 20);
403: OPEN c_actions_no_selection FOR c_actions_no_selection_sql;
404: num := 0;
405:
406: loop

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

406: loop
407: fetch c_actions_no_selection into lockedactid,assignid,greid,l_effective_end_date;
408: if c_actions_no_selection%found then
409: num := num + 1;
410: hr_utility.trace('In the c_actions_no_selection%found in action cursor');
411: else
412: hr_utility.trace('In the c_actions_no_selection%notfound in action cursor');
413: exit;
414: end if;

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

408: if c_actions_no_selection%found then
409: num := num + 1;
410: hr_utility.trace('In the c_actions_no_selection%found in action cursor');
411: else
412: hr_utility.trace('In the c_actions_no_selection%notfound in action cursor');
413: exit;
414: end if;
415:
416: ln_gross_bal := hr_us_w2_rep.get_w2_arch_bal(

Line 425: hr_utility.trace('Before IF Check for GROSS > 0 ');

421: 0);
422:
423: -- we need to create assignment_actions only if the GROSS
424: -- is greater than ZERO.
425: hr_utility.trace('Before IF Check for GROSS > 0 ');
426: if ln_gross_bal > 0 then
427:
428: -- we need to insert one action for each of the
429: -- rows that we return from the cursor (i.e. one

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

427:
428: -- we need to insert one action for each of the
429: -- rows that we return from the cursor (i.e. one
430: -- for each assignment/pre-payment/reversal).
431: hr_utility.set_location(l_procedure_name, 25);
432: hr_utility.trace('Before inserting the action record');
433:
434: select pay_assignment_actions_s.nextval
435: into lockingactid

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

428: -- we need to insert one action for each of the
429: -- rows that we return from the cursor (i.e. one
430: -- for each assignment/pre-payment/reversal).
431: hr_utility.set_location(l_procedure_name, 25);
432: hr_utility.trace('Before inserting the action record');
433:
434: select pay_assignment_actions_s.nextval
435: into lockingactid
436: from dual;

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

447: end loop;
448: close c_actions_no_selection;
449:
450: end if;
451: hr_utility.set_location(l_procedure_name, 30);
452:
453:
454: /* when location is entered */
455: if l_loc_id is not null then

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

453:
454: /* when location is entered */
455: if l_loc_id is not null then
456: if l_range_person_on = TRUE Then
457: hr_utility.set_location(l_procedure_name, 35);
458: c_actions_with_location_sql :=
459: 'SELECT paa_arch.assignment_action_id,
460: paa_arch.assignment_id,
461: paa_arch.tax_unit_id,

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

483: AND ppr.payroll_action_id = ' || pactid || '
484: AND ppr.chunk_number = ' || chunk || '
485: AND paf.person_id = ppr.person_id' ;
486: else
487: hr_utility.set_location(l_procedure_name, 40);
488: c_actions_with_location_sql :=
489: 'SELECT paa_arch.assignment_action_id,
490: paa_arch.assignment_id,
491: paa_arch.tax_unit_id,

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

511: AND pps.period_of_service_id = paf.period_of_service_id
512: AND paf.person_id between ' || stperson || ' and ' || endperson || '';
513: end if ;
514:
515: hr_utility.set_location(l_procedure_name, 40);
516: OPEN c_actions_with_location FOR c_actions_with_location_sql;
517: num := 0;
518:
519: loop

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

520: fetch c_actions_with_location into lockedactid,assignid,greid,l_effective_end_date;
521:
522: if c_actions_with_location%found then
523: num := num + 1;
524: hr_utility.trace('In the c_actions_with_location%found in action cursor');
525: else
526: hr_utility.trace('In the c_actions_with_location%notfound in action cursor');
527: exit;
528: end if;

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

522: if c_actions_with_location%found then
523: num := num + 1;
524: hr_utility.trace('In the c_actions_with_location%found in action cursor');
525: else
526: hr_utility.trace('In the c_actions_with_location%notfound in action cursor');
527: exit;
528: end if;
529:
530: ln_gross_bal := hr_us_w2_rep.get_w2_arch_bal(

Line 539: hr_utility.trace('Before IF Check for GROSS > 0 ');

535: 0);
536:
537: -- we need to create assignment_actions only if the GROSS
538: -- is greater than ZERO.
539: hr_utility.trace('Before IF Check for GROSS > 0 ');
540: if ln_gross_bal > 0 then
541:
542: hr_utility.set_location(l_procedure_name, 45);
543: hr_utility.trace('Before inserting the action record');

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

538: -- is greater than ZERO.
539: hr_utility.trace('Before IF Check for GROSS > 0 ');
540: if ln_gross_bal > 0 then
541:
542: hr_utility.set_location(l_procedure_name, 45);
543: hr_utility.trace('Before inserting the action record');
544:
545: select pay_assignment_actions_s.nextval
546: into lockingactid

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

539: hr_utility.trace('Before IF Check for GROSS > 0 ');
540: if ln_gross_bal > 0 then
541:
542: hr_utility.set_location(l_procedure_name, 45);
543: hr_utility.trace('Before inserting the action record');
544:
545: select pay_assignment_actions_s.nextval
546: into lockingactid
547: from dual;

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

558: end loop;
559: close c_actions_with_location;
560:
561: end if;
562: hr_utility.set_location(l_procedure_name, 50);
563:
564:
565: /* when org is entered */
566: if l_org_id is not null then

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

565: /* when org is entered */
566: if l_org_id is not null then
567:
568: if l_range_person_on = TRUE Then
569: hr_utility.set_location(l_procedure_name, 60);
570: hr_utility.trace('Range Person ID Functionality is enabled') ;
571: c_actions_with_org_sql :=
572: 'SELECT paa_arch.assignment_action_id,
573: paa_arch.assignment_id,

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

566: if l_org_id is not null then
567:
568: if l_range_person_on = TRUE Then
569: hr_utility.set_location(l_procedure_name, 60);
570: hr_utility.trace('Range Person ID Functionality is enabled') ;
571: c_actions_with_org_sql :=
572: 'SELECT paa_arch.assignment_action_id,
573: paa_arch.assignment_id,
574: paa_arch.tax_unit_id,

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

596: AND ppr.payroll_action_id = ' || pactid || '
597: AND ppr.chunk_number = ' || chunk || '
598: AND paf.person_id = ppr.person_id';
599: else
600: hr_utility.set_location(l_procedure_name, 70);
601: c_actions_with_org_sql :=
602: 'SELECT paa_arch.assignment_action_id,
603: paa_arch.assignment_id,
604: paa_arch.tax_unit_id,

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

624: AND pps.period_of_service_id = paf.period_of_service_id
625: AND paf.person_id between ' || stperson || ' and ' || endperson ||'';
626: end if ;
627:
628: hr_utility.set_location(l_procedure_name, 80);
629: OPEN c_actions_with_org FOR c_actions_with_org_sql;
630: num := 0;
631:
632: loop

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

633: fetch c_actions_with_org into lockedactid,assignid,greid,l_effective_end_date;
634:
635: if c_actions_with_org%found then
636: num := num + 1;
637: hr_utility.trace('In the c_actions_with_org%found in action cursor');
638: else
639: hr_utility.trace('In the c_actions_with_org%notfound in action cursor');
640: exit;
641: end if;

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

635: if c_actions_with_org%found then
636: num := num + 1;
637: hr_utility.trace('In the c_actions_with_org%found in action cursor');
638: else
639: hr_utility.trace('In the c_actions_with_org%notfound in action cursor');
640: exit;
641: end if;
642:
643:

Line 653: hr_utility.trace('Before IF Check for GROSS > 0 ');

649: 0);
650:
651: -- we need to create assignment_actions only if the GROSS
652: -- is greater than ZERO.
653: hr_utility.trace('Before IF Check for GROSS > 0 ');
654: if ln_gross_bal > 0 then
655:
656: hr_utility.set_location(l_procedure_name, 90);
657: hr_utility.trace('Before inserting the action record');

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

652: -- is greater than ZERO.
653: hr_utility.trace('Before IF Check for GROSS > 0 ');
654: if ln_gross_bal > 0 then
655:
656: hr_utility.set_location(l_procedure_name, 90);
657: hr_utility.trace('Before inserting the action record');
658:
659: select pay_assignment_actions_s.nextval
660: into lockingactid

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

653: hr_utility.trace('Before IF Check for GROSS > 0 ');
654: if ln_gross_bal > 0 then
655:
656: hr_utility.set_location(l_procedure_name, 90);
657: hr_utility.trace('Before inserting the action record');
658:
659: select pay_assignment_actions_s.nextval
660: into lockingactid
661: from dual;

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

673: close c_actions_with_org;
674:
675: end if;
676:
677: hr_utility.set_location(l_procedure_name, 100);
678:
679: /* when person or SSN is entered */
680:
681: if (l_ssn is not null and l_per_id is null ) then

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

689: if (l_per_id is not null ) then
690: open c_actions_with_person;
691: num := 0;
692: loop
693: hr_utility.set_location('procpyr',2);
694: hr_utility.trace('after the loop in c_actions_with_person');
695: fetch c_actions_with_person into lockedactid,assignid,greid,l_effective_end_date;
696:
697: if c_actions_with_person%found then

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

690: open c_actions_with_person;
691: num := 0;
692: loop
693: hr_utility.set_location('procpyr',2);
694: hr_utility.trace('after the loop in c_actions_with_person');
695: fetch c_actions_with_person into lockedactid,assignid,greid,l_effective_end_date;
696:
697: if c_actions_with_person%found then
698: num := num + 1;

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

695: fetch c_actions_with_person into lockedactid,assignid,greid,l_effective_end_date;
696:
697: if c_actions_with_person%found then
698: num := num + 1;
699: hr_utility.trace('In the c_actions_with_person%found in action cursor');
700: else
701: hr_utility.trace('In the c_actions_with_person%notfound in action cursor');
702: exit;
703: end if;

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

697: if c_actions_with_person%found then
698: num := num + 1;
699: hr_utility.trace('In the c_actions_with_person%found in action cursor');
700: else
701: hr_utility.trace('In the c_actions_with_person%notfound in action cursor');
702: exit;
703: end if;
704:
705: ln_gross_bal := hr_us_w2_rep.get_w2_arch_bal(

Line 714: hr_utility.trace('Before IF Check for GROSS > 0 ');

710: 0);
711:
712: -- we need to create assignment_actions only if the GROSS
713: -- is greater than ZERO.
714: hr_utility.trace('Before IF Check for GROSS > 0 ');
715: if ln_gross_bal > 0 then
716:
717: hr_utility.set_location(l_procedure_name, 110);
718: hr_utility.trace('Before inserting the action record');

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

713: -- is greater than ZERO.
714: hr_utility.trace('Before IF Check for GROSS > 0 ');
715: if ln_gross_bal > 0 then
716:
717: hr_utility.set_location(l_procedure_name, 110);
718: hr_utility.trace('Before inserting the action record');
719:
720: select pay_assignment_actions_s.nextval
721: into lockingactid

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

714: hr_utility.trace('Before IF Check for GROSS > 0 ');
715: if ln_gross_bal > 0 then
716:
717: hr_utility.set_location(l_procedure_name, 110);
718: hr_utility.trace('Before inserting the action record');
719:
720: select pay_assignment_actions_s.nextval
721: into lockingactid
722: from dual;

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

734: close c_actions_with_person;
735:
736: end if;
737:
738: hr_utility.set_location(l_procedure_name, 120);
739: /* when state is entered */
740: if l_state_code is not null then
741: hr_utility.set_location(l_procedure_name, 130);
742:

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

737:
738: hr_utility.set_location(l_procedure_name, 120);
739: /* when state is entered */
740: if l_state_code is not null then
741: hr_utility.set_location(l_procedure_name, 130);
742:
743: hr_utility.trace('l_state_code = ' || l_state_code);
744: open c_state_context('TAX_UNIT_ID');
745: fetch c_state_context into l_tuid_context;

Line 743: hr_utility.trace('l_state_code = ' || l_state_code);

739: /* when state is entered */
740: if l_state_code is not null then
741: hr_utility.set_location(l_procedure_name, 130);
742:
743: hr_utility.trace('l_state_code = ' || l_state_code);
744: open c_state_context('TAX_UNIT_ID');
745: fetch c_state_context into l_tuid_context;
746: close c_state_context;
747:

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

749: fetch c_state_context into l_juri_context;
750: close c_state_context;
751:
752: if l_range_person_on = TRUE Then
753: hr_utility.set_location(l_procedure_name, 140);
754: hr_utility.trace('Range Person ID Functionality is enabled') ;
755: c_actions_with_state_sql :=
756: 'SELECT paa_arch.assignment_action_id,
757: paa_arch.assignment_id,

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

750: close c_state_context;
751:
752: if l_range_person_on = TRUE Then
753: hr_utility.set_location(l_procedure_name, 140);
754: hr_utility.trace('Range Person ID Functionality is enabled') ;
755: c_actions_with_state_sql :=
756: 'SELECT paa_arch.assignment_action_id,
757: paa_arch.assignment_id,
758: paa_arch.tax_unit_id,

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

773: AND ppr.payroll_action_id = ' || pactid || '
774: AND ppr.chunk_number = ' || chunk || '
775: AND paf.person_id = ppr.person_id ';
776: else
777: hr_utility.set_location(l_procedure_name, 150);
778: c_actions_with_state_sql :=
779: 'SELECT paa_arch.assignment_action_id,
780: paa_arch.assignment_id,
781: paa_arch.tax_unit_id,

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

794: AND paf.assignment_type = ''E''
795: AND paf.person_id between ' || stperson || ' and ' || endperson;
796: end if;
797:
798: hr_utility.set_location(l_procedure_name, 160);
799:
800: open c_state_ueid('A_SIT_SUBJ_WHABLE_PER_JD_GRE_YTD');
801: fetch c_state_ueid into l_subj_whable;
802: close c_state_ueid;

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

804: open c_state_ueid('A_SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD');
805: fetch c_state_ueid into l_subj_nwhable;
806: close c_state_ueid;
807:
808: hr_utility.set_location(l_procedure_name, 170);
809: c_actions_with_state_sql := c_actions_with_state_sql ||
810: ' AND exists ( select 1 from dual
811: where 1 =
812: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)

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

822: and fai.archive_item_id = fic2.archive_item_id
823: and fic2.context_id = ' || l_juri_context || '
824: and substr(ltrim(rtrim(fic2.context)),1,2) = ' || l_state_code || ' ))';
825: --
826: hr_utility.set_location(l_procedure_name, 210);
827:
828:
829: num := 0;
830: OPEN c_actions_with_state FOR c_actions_with_state_sql;

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

832: fetch c_actions_with_state into lockedactid,assignid,greid,l_effective_end_date;
833:
834: if c_actions_with_state%found then
835: num := num + 1;
836: hr_utility.trace('In the c_actions_with_state%found in action cursor');
837: else
838: hr_utility.trace('In the c_actions_with_state%notfound in action cursor');
839: exit;
840: end if;

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

834: if c_actions_with_state%found then
835: num := num + 1;
836: hr_utility.trace('In the c_actions_with_state%found in action cursor');
837: else
838: hr_utility.trace('In the c_actions_with_state%notfound in action cursor');
839: exit;
840: end if;
841:
842:

Line 852: hr_utility.trace('Before IF Check for GROSS > 0 ');

848: 0);
849:
850: -- we need to create assignment_actions only if the GROSS
851: -- is greater than ZERO.
852: hr_utility.trace('Before IF Check for GROSS > 0 ');
853: if ln_gross_bal > 0 then
854:
855: hr_utility.set_location(l_procedure_name, 220);
856: hr_utility.trace('Before inserting the action record');

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

851: -- is greater than ZERO.
852: hr_utility.trace('Before IF Check for GROSS > 0 ');
853: if ln_gross_bal > 0 then
854:
855: hr_utility.set_location(l_procedure_name, 220);
856: hr_utility.trace('Before inserting the action record');
857:
858: select pay_assignment_actions_s.nextval
859: into lockingactid

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

852: hr_utility.trace('Before IF Check for GROSS > 0 ');
853: if ln_gross_bal > 0 then
854:
855: hr_utility.set_location(l_procedure_name, 220);
856: hr_utility.trace('Before inserting the action record');
857:
858: select pay_assignment_actions_s.nextval
859: into lockingactid
860: from dual;

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

871: end loop;
872: close c_actions_with_state;
873:
874: end if;
875: hr_utility.set_location(l_procedure_name, 230);
876:
877: /* when assignment set is entered */
878: if l_asg_set_id is not null then
879:

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

877: /* when assignment set is entered */
878: if l_asg_set_id is not null then
879:
880: if l_range_person_on = TRUE Then
881: hr_utility.set_location(l_procedure_name, 240);
882: hr_utility.trace('Range Person ID Functionality is enabled') ;
883: c_actions_with_assign_sql :=
884: 'SELECT paa_arch.assignment_action_id,
885: paa_arch.assignment_id,

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

878: if l_asg_set_id is not null then
879:
880: if l_range_person_on = TRUE Then
881: hr_utility.set_location(l_procedure_name, 240);
882: hr_utility.trace('Range Person ID Functionality is enabled') ;
883: c_actions_with_assign_sql :=
884: 'SELECT paa_arch.assignment_action_id,
885: paa_arch.assignment_id,
886: paa_arch.tax_unit_id,

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

905: where hasa.assignment_set_id = ' || l_asg_set_id || '
906: and hasa.assignment_id = paa_arch.assignment_id
907: and upper(hasa.include_or_exclude) = ''I'')';
908: else
909: hr_utility.set_location(l_procedure_name, 250);
910: c_actions_with_assign_sql :=
911: 'SELECT paa_arch.assignment_action_id,
912: paa_arch.assignment_id,
913: paa_arch.tax_unit_id,

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

930: and hasa.assignment_id = paa_arch.assignment_id
931: and upper(hasa.include_or_exclude) = ''I'')';
932: end if ;
933:
934: hr_utility.set_location(l_procedure_name, 260);
935: OPEN c_actions_with_assign_set FOR c_actions_with_assign_sql;
936: num := 0;
937:
938: loop

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

939: fetch c_actions_with_assign_set into lockedactid,assignid,greid,l_effective_end_date;
940:
941: if c_actions_with_assign_set%found then
942: num := num + 1;
943: hr_utility.trace('In the c_actions_with_assign_set%found in action cursor');
944: else
945: hr_utility.trace('In the c_actions_with_assign_set%notfound in action cursor');
946: exit;
947: end if;

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

941: if c_actions_with_assign_set%found then
942: num := num + 1;
943: hr_utility.trace('In the c_actions_with_assign_set%found in action cursor');
944: else
945: hr_utility.trace('In the c_actions_with_assign_set%notfound in action cursor');
946: exit;
947: end if;
948:
949:

Line 959: hr_utility.trace('Before IF Check for GROSS > 0 ');

955: 0);
956:
957: -- we need to create assignment_actions only if the GROSS
958: -- is greater than ZERO.
959: hr_utility.trace('Before IF Check for GROSS > 0 ');
960: if ln_gross_bal > 0 then
961:
962: hr_utility.set_location(l_procedure_name, 270);
963: hr_utility.trace('Before inserting the action record');

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

958: -- is greater than ZERO.
959: hr_utility.trace('Before IF Check for GROSS > 0 ');
960: if ln_gross_bal > 0 then
961:
962: hr_utility.set_location(l_procedure_name, 270);
963: hr_utility.trace('Before inserting the action record');
964:
965: hr_utility.set_location('procpyr',3);
966:

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

959: hr_utility.trace('Before IF Check for GROSS > 0 ');
960: if ln_gross_bal > 0 then
961:
962: hr_utility.set_location(l_procedure_name, 270);
963: hr_utility.trace('Before inserting the action record');
964:
965: hr_utility.set_location('procpyr',3);
966:
967: select pay_assignment_actions_s.nextval

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

961:
962: hr_utility.set_location(l_procedure_name, 270);
963: hr_utility.trace('Before inserting the action record');
964:
965: hr_utility.set_location('procpyr',3);
966:
967: select pay_assignment_actions_s.nextval
968: into lockingactid
969: from dual;

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

981: close c_actions_with_assign_set;
982:
983: end if;
984:
985: hr_utility.set_location(l_procedure_name, 300);
986: /* } 4946225 */
987:
988: hr_utility.trace('End of the action cursor');
989: hr_utility.trace('Leaving :'||l_procedure_name);

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

984:
985: hr_utility.set_location(l_procedure_name, 300);
986: /* } 4946225 */
987:
988: hr_utility.trace('End of the action cursor');
989: hr_utility.trace('Leaving :'||l_procedure_name);
990:
991: end action_creation;
992:

Line 989: hr_utility.trace('Leaving :'||l_procedure_name);

985: hr_utility.set_location(l_procedure_name, 300);
986: /* } 4946225 */
987:
988: hr_utility.trace('End of the action cursor');
989: hr_utility.trace('Leaving :'||l_procedure_name);
990:
991: end action_creation;
992:
993: ---------------------------------- sort_action ------------------------------

Line 1009: hr_utility.trace('Entering :'||l_procedure_name);

1005: l_procedure_name VARCHAR2(100);
1006:
1007: begin
1008: l_procedure_name := g_package||'sort_action';
1009: hr_utility.trace('Entering :'||l_procedure_name);
1010: hr_utility.trace('Beginning of the sort_action cursor');
1011: select to_char(ppa.effective_date, 'DD-MON-YYYY'),
1012: to_char(fnd_date.canonical_to_date(pay_1099R_pkg.get_parameter('EFFECTIVE_DATE',
1013: ppa.legislative_parameters)),'DD-MON-YYYY')

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

1006:
1007: begin
1008: l_procedure_name := g_package||'sort_action';
1009: hr_utility.trace('Entering :'||l_procedure_name);
1010: hr_utility.trace('Beginning of the sort_action cursor');
1011: select to_char(ppa.effective_date, 'DD-MON-YYYY'),
1012: to_char(fnd_date.canonical_to_date(pay_1099R_pkg.get_parameter('EFFECTIVE_DATE',
1013: ppa.legislative_parameters)),'DD-MON-YYYY')
1014: into l_effective_date, l_session_date

Line 1085: hr_utility.trace('length of Sort Cursor '||len);

1081: null, null,
1082: substr(hr_us_w2_rep.get_per_item(paa.assignment_action_id,''A_PER_MIDDLE_NAMES''),1,1)))';
1083:
1084: len := length(sqlstr); -- return the length of the string.
1085: hr_utility.trace('length of Sort Cursor '||len);
1086:
1087: hr_utility.trace('End of the sort_Action cursor');
1088: hr_utility.trace('Leaving :'||l_procedure_name);
1089: end sort_action;

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

1083:
1084: len := length(sqlstr); -- return the length of the string.
1085: hr_utility.trace('length of Sort Cursor '||len);
1086:
1087: hr_utility.trace('End of the sort_Action cursor');
1088: hr_utility.trace('Leaving :'||l_procedure_name);
1089: end sort_action;
1090: --
1091: ------------------------------ get_parameter -------------------------------

Line 1088: hr_utility.trace('Leaving :'||l_procedure_name);

1084: len := length(sqlstr); -- return the length of the string.
1085: hr_utility.trace('length of Sort Cursor '||len);
1086:
1087: hr_utility.trace('End of the sort_Action cursor');
1088: hr_utility.trace('Leaving :'||l_procedure_name);
1089: end sort_action;
1090: --
1091: ------------------------------ get_parameter -------------------------------
1092: function get_parameter(name in varchar2,

Line 1134: hr_utility.trace('Entering : '||l_proc_name);

1130: l_proc_name varchar2(100) := 'pay_1099r_pkg.load_xml';
1131: l_data varchar2(500);
1132: BEGIN
1133:
1134: hr_utility.trace('Entering : '||l_proc_name);
1135:
1136: IF p_node_type = 'CS' THEN
1137: pay_core_files.write_to_magtape_lob('<'||p_node||'>');
1138: ELSIF p_node_type = 'CE' THEN

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

1146: l_data := REPLACE (l_data, '"', '"');
1147: pay_core_files.write_to_magtape_lob('<'||p_node||'>'||l_data||'');
1148: END IF;
1149:
1150: hr_utility.trace('Leaving : '||l_proc_name);
1151:
1152: END LOAD_XML;
1153:
1154: ------------------------------ generate_header_xml -------------------------------

Line 1160: hr_utility.trace('Entering : '||l_proc_name);

1156:
1157: l_proc_name varchar2(50) := 'pay_1099r_pkg.generate_header_xml';
1158:
1159: BEGIN
1160: hr_utility.trace('Entering : '||l_proc_name);
1161:
1162: load_xml('CS','US_1099R','');
1163: load_xml('CE','US_1099R','');
1164:

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

1161:
1162: load_xml('CS','US_1099R','');
1163: load_xml('CE','US_1099R','');
1164:
1165: hr_utility.trace('Leaving : '||l_proc_name);
1166:
1167:
1168: END generate_header_xml;
1169:

Line 1176: hr_utility.trace('Entering : '||l_proc_name);

1172: PROCEDURE generate_footer_xml is
1173: l_proc_name varchar2(50) := 'pay_1099r_pkg.generate_footer_xml';
1174:
1175: BEGIN
1176: hr_utility.trace('Entering : '||l_proc_name);
1177:
1178: load_xml('CS','US_1099R','');
1179: load_xml('CE','US_1099R','');
1180:

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

1177:
1178: load_xml('CS','US_1099R','');
1179: load_xml('CE','US_1099R','');
1180:
1181: hr_utility.trace('Leaving : '||l_proc_name);
1182:
1183:
1184: END generate_footer_xml;
1185:

Line 1493: hr_utility.trace('1099r Archive Date : ' || l_corrected_date);

1489: pay_us_archive_util.get_archive_value(l_fed_aaid,
1490: 'A_ARCHIVE_DATE',
1491: l_tax_unit_id));
1492:
1493: hr_utility.trace('1099r Archive Date : ' || l_corrected_date);
1494:
1495: l_payroll_action_id := l_yrend_pactid;
1496:
1497: /* If live profile option is null then allow the view 1099R till end of time

Line 1503: hr_utility.trace('orig 1099R Profile date'||l_live_profile_option);

1499: profile option date else continue using the old logic of appending year,
1500:
1501: */
1502: l_live_profile_option := fnd_profile.value('HR_ORIG_1099R_BEF');
1503: hr_utility.trace('orig 1099R Profile date'||l_live_profile_option);
1504: hr_utility.trace('1099R-l_payroll_action_id '||l_payroll_action_id);
1505:
1506: IF (l_live_profile_option is null) or (l_live_profile_option = '') THEN
1507: l_profile_date := fnd_date.canonical_to_date('4712/12/31');

Line 1504: hr_utility.trace('1099R-l_payroll_action_id '||l_payroll_action_id);

1500:
1501: */
1502: l_live_profile_option := fnd_profile.value('HR_ORIG_1099R_BEF');
1503: hr_utility.trace('orig 1099R Profile date'||l_live_profile_option);
1504: hr_utility.trace('1099R-l_payroll_action_id '||l_payroll_action_id);
1505:
1506: IF (l_live_profile_option is null) or (l_live_profile_option = '') THEN
1507: l_profile_date := fnd_date.canonical_to_date('4712/12/31');
1508: ELSE

Line 1515: hr_utility.trace('l_profile_date '||l_profile_date_string);

1511: pay_us_archive_util.get_archive_value(l_payroll_action_id,
1512: 'A_HR_ORIG_1099R_BEF',
1513: l_tax_unit_id);
1514:
1515: hr_utility.trace('l_profile_date '||l_profile_date_string);
1516:
1517: IF (l_profile_date_string is null) or (l_profile_date_string = '') THEN
1518: l_profile_date := fnd_date.canonical_to_date(l_year+1||'/'||l_live_profile_option);
1519: hr_utility.trace('l_profile_date was null , setting to '||l_profile_date);

Line 1519: hr_utility.trace('l_profile_date was null , setting to '||l_profile_date);

1515: hr_utility.trace('l_profile_date '||l_profile_date_string);
1516:
1517: IF (l_profile_date_string is null) or (l_profile_date_string = '') THEN
1518: l_profile_date := fnd_date.canonical_to_date(l_year+1||'/'||l_live_profile_option);
1519: hr_utility.trace('l_profile_date was null , setting to '||l_profile_date);
1520: ELSE
1521: l_profile_date := fnd_date.canonical_to_date(l_profile_date_string);
1522:
1523: hr_utility.trace('l_profile_date was not null , setting to '||l_profile_date);

Line 1523: hr_utility.trace('l_profile_date was not null , setting to '||l_profile_date);

1519: hr_utility.trace('l_profile_date was null , setting to '||l_profile_date);
1520: ELSE
1521: l_profile_date := fnd_date.canonical_to_date(l_profile_date_string);
1522:
1523: hr_utility.trace('l_profile_date was not null , setting to '||l_profile_date);
1524:
1525: END IF;
1526: END IF;
1527:

Line 1532: hr_utility.trace('View Online W2 Profile date'||l_live_profile_option);

1528: l_1099r_corrected :=pay_us_archive_util.get_archive_value(l_assignment_action_id,
1529: 'A_1099R_CORRECTED',
1530: l_tax_unit_id);
1531:
1532: hr_utility.trace('View Online W2 Profile date'||l_live_profile_option);
1533:
1534: /* If the profile option is blank and archive
1535: item , A_1099R_CORRECTED is not archived for an employee then it
1536: will never print 'CORRECTED' which may be incorrect for W-2s which

Line 1663: --hr_utility.trace_on(null, 'pyus109r');

1659: END generate_detail_xml;
1660:
1661: --begin
1662:
1663: --hr_utility.trace_on(null, 'pyus109r');
1664:
1665: end pay_1099R_pkg;