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 106: --hr_utility.trace_on(null,'pyus109r');

102: l_procedure_name VARCHAR2(100);
103: --
104: begin
105: l_procedure_name := g_package||'range_cursor';
106: --hr_utility.trace_on(null,'pyus109r');
107: hr_utility.trace('Before the range cursor');
108: hr_utility.trace('Entering :'||l_procedure_name);
109:
110: select pay_1099R_pkg.get_parameter('YEAR',ppa.legislative_parameters),

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

103: --
104: begin
105: l_procedure_name := g_package||'range_cursor';
106: --hr_utility.trace_on(null,'pyus109r');
107: hr_utility.trace('Before the range cursor');
108: hr_utility.trace('Entering :'||l_procedure_name);
109:
110: select pay_1099R_pkg.get_parameter('YEAR',ppa.legislative_parameters),
111: pay_1099R_pkg.get_parameter('TAX_ID',ppa.legislative_parameters),

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

104: begin
105: l_procedure_name := g_package||'range_cursor';
106: --hr_utility.trace_on(null,'pyus109r');
107: hr_utility.trace('Before the range cursor');
108: hr_utility.trace('Entering :'||l_procedure_name);
109:
110: select pay_1099R_pkg.get_parameter('YEAR',ppa.legislative_parameters),
111: pay_1099R_pkg.get_parameter('TAX_ID',ppa.legislative_parameters),
112: pay_1099R_pkg.get_parameter('ASSIGN_SET',ppa.legislative_parameters)

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

130: AND ppa_arch.action_status = ''C''
131: AND ppa_arch.payroll_action_id = paa_arch.payroll_action_id
132: order by to_number(paa_arch.serial_number) ';
133:
134: hr_utility.trace('After the range cursor');
135:
136: hr_utility.trace('Leaving :'||l_procedure_name);
137: end range_cursor;
138:

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

132: order by to_number(paa_arch.serial_number) ';
133:
134: hr_utility.trace('After the range cursor');
135:
136: hr_utility.trace('Leaving :'||l_procedure_name);
137: end range_cursor;
138:
139:
140:

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

279: begin
280:
281: l_procedure_name := g_package||'action_creation';
282:
283: --hr_utility.trace_on(null,'pyus109r');
284: hr_utility.trace('Entering :'||l_procedure_name);
285: hr_utility.set_location('action_cursor',1);
286: hr_utility.trace('In the action cursor');
287:

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

280:
281: l_procedure_name := g_package||'action_creation';
282:
283: --hr_utility.trace_on(null,'pyus109r');
284: hr_utility.trace('Entering :'||l_procedure_name);
285: hr_utility.set_location('action_cursor',1);
286: hr_utility.trace('In the action cursor');
287:
288: open c_payroll_param(pactid);

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

281: l_procedure_name := g_package||'action_creation';
282:
283: --hr_utility.trace_on(null,'pyus109r');
284: hr_utility.trace('Entering :'||l_procedure_name);
285: hr_utility.set_location('action_cursor',1);
286: hr_utility.trace('In the action cursor');
287:
288: open c_payroll_param(pactid);
289: fetch c_payroll_param into l_year,

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

282:
283: --hr_utility.trace_on(null,'pyus109r');
284: hr_utility.trace('Entering :'||l_procedure_name);
285: hr_utility.set_location('action_cursor',1);
286: hr_utility.trace('In the action cursor');
287:
288: open c_payroll_param(pactid);
289: fetch c_payroll_param into l_year,
290: l_gre_id,

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

317: When Others Then
318: l_report_format := Null ;
319: End ;
320:
321: hr_utility.set_location(l_procedure_name, 2);
322: l_range_person_on := pay_ac_utility.range_person_on
323: ( p_report_type => l_report_type,
324: p_report_format => l_report_format,
325: p_report_qualifier => l_report_qualifier,

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

331: (l_ssn is null ) and
332: (l_state_code is null ) and
333: (l_asg_set_id is null )) then
334:
335: hr_utility.set_location(l_procedure_name, 5);
336: if l_range_person_on = TRUE Then
337: hr_utility.set_location(l_procedure_name, 10);
338: hr_utility.trace('Range Person ID Functionality is enabled') ;
339: c_actions_no_selection_sql :=

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

333: (l_asg_set_id is null )) then
334:
335: hr_utility.set_location(l_procedure_name, 5);
336: if l_range_person_on = TRUE Then
337: hr_utility.set_location(l_procedure_name, 10);
338: hr_utility.trace('Range Person ID Functionality is enabled') ;
339: c_actions_no_selection_sql :=
340: 'SELECT paa_arch.assignment_action_id,
341: paa_arch.assignment_id,

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

334:
335: hr_utility.set_location(l_procedure_name, 5);
336: if l_range_person_on = TRUE Then
337: hr_utility.set_location(l_procedure_name, 10);
338: hr_utility.trace('Range Person ID Functionality is enabled') ;
339: c_actions_no_selection_sql :=
340: 'SELECT paa_arch.assignment_action_id,
341: paa_arch.assignment_id,
342: paa_arch.tax_unit_id,

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

359: AND ppr.chunk_number = ' || chunk || '
360: AND paf.person_id = ppr.person_id
361: and paf.person_id = to_number(paa_arch.serial_number)';
362: else
363: hr_utility.set_location(l_procedure_name, 15);
364: c_actions_no_selection_sql :=
365: 'SELECT paa_arch.assignment_action_id,
366: paa_arch.assignment_id,
367: paa_arch.tax_unit_id,

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

382: AND paf.person_id between ' || stperson || ' and ' || endperson || '
383: and paf.person_id = to_number(paa_arch.serial_number)';
384: end if ;
385:
386: hr_utility.set_location(l_procedure_name, 20);
387: OPEN c_actions_no_selection FOR c_actions_no_selection_sql;
388: num := 0;
389:
390: loop

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

390: loop
391: fetch c_actions_no_selection into lockedactid,assignid,greid,l_effective_end_date;
392: if c_actions_no_selection%found then
393: num := num + 1;
394: hr_utility.trace('In the c_actions_no_selection%found in action cursor');
395: else
396: hr_utility.trace('In the c_actions_no_selection%notfound in action cursor');
397: exit;
398: end if;

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

392: if c_actions_no_selection%found then
393: num := num + 1;
394: hr_utility.trace('In the c_actions_no_selection%found in action cursor');
395: else
396: hr_utility.trace('In the c_actions_no_selection%notfound in action cursor');
397: exit;
398: end if;
399:
400: ln_gross_bal := hr_us_w2_rep.get_w2_arch_bal(

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

405: 0);
406:
407: -- we need to create assignment_actions only if the GROSS
408: -- is greater than ZERO.
409: hr_utility.trace('Before IF Check for GROSS > 0 ');
410: if ln_gross_bal > 0 then
411:
412: -- we need to insert one action for each of the
413: -- rows that we return from the cursor (i.e. one

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

411:
412: -- we need to insert one action for each of the
413: -- rows that we return from the cursor (i.e. one
414: -- for each assignment/pre-payment/reversal).
415: hr_utility.set_location(l_procedure_name, 25);
416: hr_utility.trace('Before inserting the action record');
417:
418: select pay_assignment_actions_s.nextval
419: into lockingactid

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

412: -- we need to insert one action for each of the
413: -- rows that we return from the cursor (i.e. one
414: -- for each assignment/pre-payment/reversal).
415: hr_utility.set_location(l_procedure_name, 25);
416: hr_utility.trace('Before inserting the action record');
417:
418: select pay_assignment_actions_s.nextval
419: into lockingactid
420: from dual;

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

431: end loop;
432: close c_actions_no_selection;
433:
434: end if;
435: hr_utility.set_location(l_procedure_name, 30);
436:
437:
438: /* when location is entered */
439: if l_loc_id is not null then

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

437:
438: /* when location is entered */
439: if l_loc_id is not null then
440: if l_range_person_on = TRUE Then
441: hr_utility.set_location(l_procedure_name, 35);
442: c_actions_with_location_sql :=
443: 'SELECT paa_arch.assignment_action_id,
444: paa_arch.assignment_id,
445: paa_arch.tax_unit_id,

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

467: AND ppr.payroll_action_id = ' || pactid || '
468: AND ppr.chunk_number = ' || chunk || '
469: AND paf.person_id = ppr.person_id' ;
470: else
471: hr_utility.set_location(l_procedure_name, 40);
472: c_actions_with_location_sql :=
473: 'SELECT paa_arch.assignment_action_id,
474: paa_arch.assignment_id,
475: paa_arch.tax_unit_id,

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

495: AND pps.period_of_service_id = paf.period_of_service_id
496: AND paf.person_id between ' || stperson || ' and ' || endperson || '';
497: end if ;
498:
499: hr_utility.set_location(l_procedure_name, 40);
500: OPEN c_actions_with_location FOR c_actions_with_location_sql;
501: num := 0;
502:
503: loop

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

504: fetch c_actions_with_location into lockedactid,assignid,greid,l_effective_end_date;
505:
506: if c_actions_with_location%found then
507: num := num + 1;
508: hr_utility.trace('In the c_actions_with_location%found in action cursor');
509: else
510: hr_utility.trace('In the c_actions_with_location%notfound in action cursor');
511: exit;
512: end if;

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

506: if c_actions_with_location%found then
507: num := num + 1;
508: hr_utility.trace('In the c_actions_with_location%found in action cursor');
509: else
510: hr_utility.trace('In the c_actions_with_location%notfound in action cursor');
511: exit;
512: end if;
513:
514: ln_gross_bal := hr_us_w2_rep.get_w2_arch_bal(

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

519: 0);
520:
521: -- we need to create assignment_actions only if the GROSS
522: -- is greater than ZERO.
523: hr_utility.trace('Before IF Check for GROSS > 0 ');
524: if ln_gross_bal > 0 then
525:
526: hr_utility.set_location(l_procedure_name, 45);
527: hr_utility.trace('Before inserting the action record');

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

522: -- is greater than ZERO.
523: hr_utility.trace('Before IF Check for GROSS > 0 ');
524: if ln_gross_bal > 0 then
525:
526: hr_utility.set_location(l_procedure_name, 45);
527: hr_utility.trace('Before inserting the action record');
528:
529: select pay_assignment_actions_s.nextval
530: into lockingactid

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

523: hr_utility.trace('Before IF Check for GROSS > 0 ');
524: if ln_gross_bal > 0 then
525:
526: hr_utility.set_location(l_procedure_name, 45);
527: hr_utility.trace('Before inserting the action record');
528:
529: select pay_assignment_actions_s.nextval
530: into lockingactid
531: from dual;

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

542: end loop;
543: close c_actions_with_location;
544:
545: end if;
546: hr_utility.set_location(l_procedure_name, 50);
547:
548:
549: /* when org is entered */
550: if l_org_id is not null then

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

549: /* when org is entered */
550: if l_org_id is not null then
551:
552: if l_range_person_on = TRUE Then
553: hr_utility.set_location(l_procedure_name, 60);
554: hr_utility.trace('Range Person ID Functionality is enabled') ;
555: c_actions_with_org_sql :=
556: 'SELECT paa_arch.assignment_action_id,
557: paa_arch.assignment_id,

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

550: if l_org_id is not null then
551:
552: if l_range_person_on = TRUE Then
553: hr_utility.set_location(l_procedure_name, 60);
554: hr_utility.trace('Range Person ID Functionality is enabled') ;
555: c_actions_with_org_sql :=
556: 'SELECT paa_arch.assignment_action_id,
557: paa_arch.assignment_id,
558: paa_arch.tax_unit_id,

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

580: AND ppr.payroll_action_id = ' || pactid || '
581: AND ppr.chunk_number = ' || chunk || '
582: AND paf.person_id = ppr.person_id';
583: else
584: hr_utility.set_location(l_procedure_name, 70);
585: c_actions_with_org_sql :=
586: 'SELECT paa_arch.assignment_action_id,
587: paa_arch.assignment_id,
588: paa_arch.tax_unit_id,

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

608: AND pps.period_of_service_id = paf.period_of_service_id
609: AND paf.person_id between ' || stperson || ' and ' || endperson ||'';
610: end if ;
611:
612: hr_utility.set_location(l_procedure_name, 80);
613: OPEN c_actions_with_org FOR c_actions_with_org_sql;
614: num := 0;
615:
616: loop

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

617: fetch c_actions_with_org into lockedactid,assignid,greid,l_effective_end_date;
618:
619: if c_actions_with_org%found then
620: num := num + 1;
621: hr_utility.trace('In the c_actions_with_org%found in action cursor');
622: else
623: hr_utility.trace('In the c_actions_with_org%notfound in action cursor');
624: exit;
625: end if;

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

619: if c_actions_with_org%found then
620: num := num + 1;
621: hr_utility.trace('In the c_actions_with_org%found in action cursor');
622: else
623: hr_utility.trace('In the c_actions_with_org%notfound in action cursor');
624: exit;
625: end if;
626:
627:

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

633: 0);
634:
635: -- we need to create assignment_actions only if the GROSS
636: -- is greater than ZERO.
637: hr_utility.trace('Before IF Check for GROSS > 0 ');
638: if ln_gross_bal > 0 then
639:
640: hr_utility.set_location(l_procedure_name, 90);
641: hr_utility.trace('Before inserting the action record');

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

636: -- is greater than ZERO.
637: hr_utility.trace('Before IF Check for GROSS > 0 ');
638: if ln_gross_bal > 0 then
639:
640: hr_utility.set_location(l_procedure_name, 90);
641: hr_utility.trace('Before inserting the action record');
642:
643: select pay_assignment_actions_s.nextval
644: into lockingactid

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

637: hr_utility.trace('Before IF Check for GROSS > 0 ');
638: if ln_gross_bal > 0 then
639:
640: hr_utility.set_location(l_procedure_name, 90);
641: hr_utility.trace('Before inserting the action record');
642:
643: select pay_assignment_actions_s.nextval
644: into lockingactid
645: from dual;

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

657: close c_actions_with_org;
658:
659: end if;
660:
661: hr_utility.set_location(l_procedure_name, 100);
662:
663: /* when person or SSN is entered */
664:
665: if (l_ssn is not null and l_per_id is null ) then

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

673: if (l_per_id is not null ) then
674: open c_actions_with_person;
675: num := 0;
676: loop
677: hr_utility.set_location('procpyr',2);
678: hr_utility.trace('after the loop in c_actions_with_person');
679: fetch c_actions_with_person into lockedactid,assignid,greid,l_effective_end_date;
680:
681: if c_actions_with_person%found then

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

674: open c_actions_with_person;
675: num := 0;
676: loop
677: hr_utility.set_location('procpyr',2);
678: hr_utility.trace('after the loop in c_actions_with_person');
679: fetch c_actions_with_person into lockedactid,assignid,greid,l_effective_end_date;
680:
681: if c_actions_with_person%found then
682: num := num + 1;

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

679: fetch c_actions_with_person into lockedactid,assignid,greid,l_effective_end_date;
680:
681: if c_actions_with_person%found then
682: num := num + 1;
683: hr_utility.trace('In the c_actions_with_person%found in action cursor');
684: else
685: hr_utility.trace('In the c_actions_with_person%notfound in action cursor');
686: exit;
687: end if;

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

681: if c_actions_with_person%found then
682: num := num + 1;
683: hr_utility.trace('In the c_actions_with_person%found in action cursor');
684: else
685: hr_utility.trace('In the c_actions_with_person%notfound in action cursor');
686: exit;
687: end if;
688:
689: ln_gross_bal := hr_us_w2_rep.get_w2_arch_bal(

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

694: 0);
695:
696: -- we need to create assignment_actions only if the GROSS
697: -- is greater than ZERO.
698: hr_utility.trace('Before IF Check for GROSS > 0 ');
699: if ln_gross_bal > 0 then
700:
701: hr_utility.set_location(l_procedure_name, 110);
702: hr_utility.trace('Before inserting the action record');

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

697: -- is greater than ZERO.
698: hr_utility.trace('Before IF Check for GROSS > 0 ');
699: if ln_gross_bal > 0 then
700:
701: hr_utility.set_location(l_procedure_name, 110);
702: hr_utility.trace('Before inserting the action record');
703:
704: select pay_assignment_actions_s.nextval
705: into lockingactid

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

698: hr_utility.trace('Before IF Check for GROSS > 0 ');
699: if ln_gross_bal > 0 then
700:
701: hr_utility.set_location(l_procedure_name, 110);
702: hr_utility.trace('Before inserting the action record');
703:
704: select pay_assignment_actions_s.nextval
705: into lockingactid
706: from dual;

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

718: close c_actions_with_person;
719:
720: end if;
721:
722: hr_utility.set_location(l_procedure_name, 120);
723: /* when state is entered */
724: if l_state_code is not null then
725: hr_utility.set_location(l_procedure_name, 130);
726:

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

721:
722: hr_utility.set_location(l_procedure_name, 120);
723: /* when state is entered */
724: if l_state_code is not null then
725: hr_utility.set_location(l_procedure_name, 130);
726:
727: hr_utility.trace('l_state_code = ' || l_state_code);
728: open c_state_context('TAX_UNIT_ID');
729: fetch c_state_context into l_tuid_context;

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

723: /* when state is entered */
724: if l_state_code is not null then
725: hr_utility.set_location(l_procedure_name, 130);
726:
727: hr_utility.trace('l_state_code = ' || l_state_code);
728: open c_state_context('TAX_UNIT_ID');
729: fetch c_state_context into l_tuid_context;
730: close c_state_context;
731:

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

733: fetch c_state_context into l_juri_context;
734: close c_state_context;
735:
736: if l_range_person_on = TRUE Then
737: hr_utility.set_location(l_procedure_name, 140);
738: hr_utility.trace('Range Person ID Functionality is enabled') ;
739: c_actions_with_state_sql :=
740: 'SELECT paa_arch.assignment_action_id,
741: paa_arch.assignment_id,

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

734: close c_state_context;
735:
736: if l_range_person_on = TRUE Then
737: hr_utility.set_location(l_procedure_name, 140);
738: hr_utility.trace('Range Person ID Functionality is enabled') ;
739: c_actions_with_state_sql :=
740: 'SELECT paa_arch.assignment_action_id,
741: paa_arch.assignment_id,
742: paa_arch.tax_unit_id,

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

757: AND ppr.payroll_action_id = ' || pactid || '
758: AND ppr.chunk_number = ' || chunk || '
759: AND paf.person_id = ppr.person_id ';
760: else
761: hr_utility.set_location(l_procedure_name, 150);
762: c_actions_with_state_sql :=
763: 'SELECT paa_arch.assignment_action_id,
764: paa_arch.assignment_id,
765: paa_arch.tax_unit_id,

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

778: AND paf.assignment_type = ''E''
779: AND paf.person_id between ' || stperson || ' and ' || endperson;
780: end if;
781:
782: hr_utility.set_location(l_procedure_name, 160);
783:
784: open c_state_ueid('A_SIT_SUBJ_WHABLE_PER_JD_GRE_YTD');
785: fetch c_state_ueid into l_subj_whable;
786: close c_state_ueid;

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

788: open c_state_ueid('A_SIT_SUBJ_NWHABLE_PER_JD_GRE_YTD');
789: fetch c_state_ueid into l_subj_nwhable;
790: close c_state_ueid;
791:
792: hr_utility.set_location(l_procedure_name, 170);
793: c_actions_with_state_sql := c_actions_with_state_sql ||
794: ' AND exists ( select 1 from dual
795: where 1 =
796: (select decode(sign(nvl(sum(to_number(fai.value)),0)),-1,1,0,0,1)

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

806: and fai.archive_item_id = fic2.archive_item_id
807: and fic2.context_id = ' || l_juri_context || '
808: and substr(ltrim(rtrim(fic2.context)),1,2) = ' || l_state_code || ' ))';
809: --
810: hr_utility.set_location(l_procedure_name, 210);
811:
812:
813: num := 0;
814: OPEN c_actions_with_state FOR c_actions_with_state_sql;

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

816: fetch c_actions_with_state into lockedactid,assignid,greid,l_effective_end_date;
817:
818: if c_actions_with_state%found then
819: num := num + 1;
820: hr_utility.trace('In the c_actions_with_state%found in action cursor');
821: else
822: hr_utility.trace('In the c_actions_with_state%notfound in action cursor');
823: exit;
824: end if;

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

818: if c_actions_with_state%found then
819: num := num + 1;
820: hr_utility.trace('In the c_actions_with_state%found in action cursor');
821: else
822: hr_utility.trace('In the c_actions_with_state%notfound in action cursor');
823: exit;
824: end if;
825:
826:

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

832: 0);
833:
834: -- we need to create assignment_actions only if the GROSS
835: -- is greater than ZERO.
836: hr_utility.trace('Before IF Check for GROSS > 0 ');
837: if ln_gross_bal > 0 then
838:
839: hr_utility.set_location(l_procedure_name, 220);
840: hr_utility.trace('Before inserting the action record');

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

835: -- is greater than ZERO.
836: hr_utility.trace('Before IF Check for GROSS > 0 ');
837: if ln_gross_bal > 0 then
838:
839: hr_utility.set_location(l_procedure_name, 220);
840: hr_utility.trace('Before inserting the action record');
841:
842: select pay_assignment_actions_s.nextval
843: into lockingactid

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

836: hr_utility.trace('Before IF Check for GROSS > 0 ');
837: if ln_gross_bal > 0 then
838:
839: hr_utility.set_location(l_procedure_name, 220);
840: hr_utility.trace('Before inserting the action record');
841:
842: select pay_assignment_actions_s.nextval
843: into lockingactid
844: from dual;

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

855: end loop;
856: close c_actions_with_state;
857:
858: end if;
859: hr_utility.set_location(l_procedure_name, 230);
860:
861: /* when assignment set is entered */
862: if l_asg_set_id is not null then
863:

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

861: /* when assignment set is entered */
862: if l_asg_set_id is not null then
863:
864: if l_range_person_on = TRUE Then
865: hr_utility.set_location(l_procedure_name, 240);
866: hr_utility.trace('Range Person ID Functionality is enabled') ;
867: c_actions_with_assign_sql :=
868: 'SELECT paa_arch.assignment_action_id,
869: paa_arch.assignment_id,

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

862: if l_asg_set_id is not null then
863:
864: if l_range_person_on = TRUE Then
865: hr_utility.set_location(l_procedure_name, 240);
866: hr_utility.trace('Range Person ID Functionality is enabled') ;
867: c_actions_with_assign_sql :=
868: 'SELECT paa_arch.assignment_action_id,
869: paa_arch.assignment_id,
870: paa_arch.tax_unit_id,

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

889: where hasa.assignment_set_id = ' || l_asg_set_id || '
890: and hasa.assignment_id = paa_arch.assignment_id
891: and upper(hasa.include_or_exclude) = ''I'')';
892: else
893: hr_utility.set_location(l_procedure_name, 250);
894: c_actions_with_assign_sql :=
895: 'SELECT paa_arch.assignment_action_id,
896: paa_arch.assignment_id,
897: paa_arch.tax_unit_id,

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

914: and hasa.assignment_id = paa_arch.assignment_id
915: and upper(hasa.include_or_exclude) = ''I'')';
916: end if ;
917:
918: hr_utility.set_location(l_procedure_name, 260);
919: OPEN c_actions_with_assign_set FOR c_actions_with_assign_sql;
920: num := 0;
921:
922: loop

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

923: fetch c_actions_with_assign_set into lockedactid,assignid,greid,l_effective_end_date;
924:
925: if c_actions_with_assign_set%found then
926: num := num + 1;
927: hr_utility.trace('In the c_actions_with_assign_set%found in action cursor');
928: else
929: hr_utility.trace('In the c_actions_with_assign_set%notfound in action cursor');
930: exit;
931: end if;

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

925: if c_actions_with_assign_set%found then
926: num := num + 1;
927: hr_utility.trace('In the c_actions_with_assign_set%found in action cursor');
928: else
929: hr_utility.trace('In the c_actions_with_assign_set%notfound in action cursor');
930: exit;
931: end if;
932:
933:

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

939: 0);
940:
941: -- we need to create assignment_actions only if the GROSS
942: -- is greater than ZERO.
943: hr_utility.trace('Before IF Check for GROSS > 0 ');
944: if ln_gross_bal > 0 then
945:
946: hr_utility.set_location(l_procedure_name, 270);
947: hr_utility.trace('Before inserting the action record');

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

942: -- is greater than ZERO.
943: hr_utility.trace('Before IF Check for GROSS > 0 ');
944: if ln_gross_bal > 0 then
945:
946: hr_utility.set_location(l_procedure_name, 270);
947: hr_utility.trace('Before inserting the action record');
948:
949: hr_utility.set_location('procpyr',3);
950:

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

943: hr_utility.trace('Before IF Check for GROSS > 0 ');
944: if ln_gross_bal > 0 then
945:
946: hr_utility.set_location(l_procedure_name, 270);
947: hr_utility.trace('Before inserting the action record');
948:
949: hr_utility.set_location('procpyr',3);
950:
951: select pay_assignment_actions_s.nextval

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

945:
946: hr_utility.set_location(l_procedure_name, 270);
947: hr_utility.trace('Before inserting the action record');
948:
949: hr_utility.set_location('procpyr',3);
950:
951: select pay_assignment_actions_s.nextval
952: into lockingactid
953: from dual;

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

965: close c_actions_with_assign_set;
966:
967: end if;
968:
969: hr_utility.set_location(l_procedure_name, 300);
970: /* } 4946225 */
971:
972: hr_utility.trace('End of the action cursor');
973: hr_utility.trace('Leaving :'||l_procedure_name);

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

968:
969: hr_utility.set_location(l_procedure_name, 300);
970: /* } 4946225 */
971:
972: hr_utility.trace('End of the action cursor');
973: hr_utility.trace('Leaving :'||l_procedure_name);
974:
975: end action_creation;
976:

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

969: hr_utility.set_location(l_procedure_name, 300);
970: /* } 4946225 */
971:
972: hr_utility.trace('End of the action cursor');
973: hr_utility.trace('Leaving :'||l_procedure_name);
974:
975: end action_creation;
976:
977: ---------------------------------- sort_action ------------------------------

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

989: l_procedure_name VARCHAR2(100);
990:
991: begin
992: l_procedure_name := g_package||'sort_action';
993: hr_utility.trace('Entering :'||l_procedure_name);
994: hr_utility.trace('Beginning of the sort_action cursor');
995: select to_char(ppa.effective_date, 'DD-MON-YYYY'),
996: to_char(fnd_date.canonical_to_date(pay_1099R_pkg.get_parameter('EFFECTIVE_DATE',
997: ppa.legislative_parameters)),'DD-MON-YYYY')

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

990:
991: begin
992: l_procedure_name := g_package||'sort_action';
993: hr_utility.trace('Entering :'||l_procedure_name);
994: hr_utility.trace('Beginning of the sort_action cursor');
995: select to_char(ppa.effective_date, 'DD-MON-YYYY'),
996: to_char(fnd_date.canonical_to_date(pay_1099R_pkg.get_parameter('EFFECTIVE_DATE',
997: ppa.legislative_parameters)),'DD-MON-YYYY')
998: into l_effective_date, l_session_date

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

1065: null, null,
1066: substr(hr_us_w2_rep.get_per_item(paa.assignment_action_id,''A_PER_MIDDLE_NAMES''),1,1)))';
1067:
1068: len := length(sqlstr); -- return the length of the string.
1069: hr_utility.trace('length of Sort Cursor '||len);
1070:
1071: hr_utility.trace('End of the sort_Action cursor');
1072: hr_utility.trace('Leaving :'||l_procedure_name);
1073: end sort_action;

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

1067:
1068: len := length(sqlstr); -- return the length of the string.
1069: hr_utility.trace('length of Sort Cursor '||len);
1070:
1071: hr_utility.trace('End of the sort_Action cursor');
1072: hr_utility.trace('Leaving :'||l_procedure_name);
1073: end sort_action;
1074: --
1075: ------------------------------ get_parameter -------------------------------

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

1068: len := length(sqlstr); -- return the length of the string.
1069: hr_utility.trace('length of Sort Cursor '||len);
1070:
1071: hr_utility.trace('End of the sort_Action cursor');
1072: hr_utility.trace('Leaving :'||l_procedure_name);
1073: end sort_action;
1074: --
1075: ------------------------------ get_parameter -------------------------------
1076: function get_parameter(name in varchar2,

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

1114: l_proc_name varchar2(100) := 'pay_1099r_pkg.load_xml';
1115: l_data varchar2(500);
1116: BEGIN
1117:
1118: hr_utility.trace('Entering : '||l_proc_name);
1119:
1120: IF p_node_type = 'CS' THEN
1121: pay_core_files.write_to_magtape_lob('<'||p_node||'>');
1122: ELSIF p_node_type = 'CE' THEN

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

1130: l_data := REPLACE (l_data, '"', '"');
1131: pay_core_files.write_to_magtape_lob('<'||p_node||'>'||l_data||'');
1132: END IF;
1133:
1134: hr_utility.trace('Leaving : '||l_proc_name);
1135:
1136: END LOAD_XML;
1137:
1138: ------------------------------ generate_header_xml -------------------------------

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

1140:
1141: l_proc_name varchar2(50) := 'pay_1099r_pkg.generate_header_xml';
1142:
1143: BEGIN
1144: hr_utility.trace('Entering : '||l_proc_name);
1145:
1146: load_xml('CS','US_1099R','');
1147: load_xml('CE','US_1099R','');
1148:

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

1145:
1146: load_xml('CS','US_1099R','');
1147: load_xml('CE','US_1099R','');
1148:
1149: hr_utility.trace('Leaving : '||l_proc_name);
1150:
1151:
1152: END generate_header_xml;
1153:

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

1156: PROCEDURE generate_footer_xml is
1157: l_proc_name varchar2(50) := 'pay_1099r_pkg.generate_footer_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_footer_xml;
1169:

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

1544: END generate_detail_xml;
1545:
1546: --begin
1547:
1548: --hr_utility.trace_on(null, 'pyus109r');
1549:
1550: end pay_1099R_pkg;