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

Line 70: --hr_utility.trace_on (NULL, 'Vineet');

66: l_payroll_text VARCHAR2(70);
67: l_consolidation_set_text VARCHAR2(50);
68: l_proc_name VARCHAR2(100) := g_package_name||'.RANGE_CURSOR';
69: BEGIN
70: --hr_utility.trace_on (NULL, 'Vineet');
71: fnd_file.put_line(FND_FILE.LOG,'pay_mx_payreg_pkg.range_cursor ');
72: hr_utility.set_location(l_proc_name,5);
73:
74: SELECT legislative_parameters

Line 72: hr_utility.set_location(l_proc_name,5);

68: l_proc_name VARCHAR2(100) := g_package_name||'.RANGE_CURSOR';
69: BEGIN
70: --hr_utility.trace_on (NULL, 'Vineet');
71: fnd_file.put_line(FND_FILE.LOG,'pay_mx_payreg_pkg.range_cursor ');
72: hr_utility.set_location(l_proc_name,5);
73:
74: SELECT legislative_parameters
75: INTO leg_param
76: FROM pay_payroll_actions ppa

Line 79: hr_utility.set_location(l_proc_name,10);

75: INTO leg_param
76: FROM pay_payroll_actions ppa
77: WHERE ppa.payroll_action_id = pactid;
78:
79: hr_utility.set_location(l_proc_name,10);
80: SELECT ppa.legislative_parameters,
81: pay_payrg_pkg.get_parameter('C_ST_ID', ppa.legislative_parameters),
82: pay_payrg_pkg.get_parameter('PY_ID', ppa.legislative_parameters),
83: pay_payrg_pkg.get_parameter('O_ID', ppa.legislative_parameters),

Line 97: hr_utility.set_location(l_proc_name,15);

93: l_business_group_id
94: FROM pay_payroll_actions ppa
95: WHERE ppa.payroll_action_id = pactid;
96:
97: hr_utility.set_location(l_proc_name,15);
98: IF l_consolidation_set_id IS NOT NULL THEN
99: hr_utility.set_location(l_proc_name,20);
100: l_consolidation_set_text := 'and pa1.consolidation_set_id = ' || to_char(l_consolidation_set_id) ;
101: ELSE

Line 99: hr_utility.set_location(l_proc_name,20);

95: WHERE ppa.payroll_action_id = pactid;
96:
97: hr_utility.set_location(l_proc_name,15);
98: IF l_consolidation_set_id IS NOT NULL THEN
99: hr_utility.set_location(l_proc_name,20);
100: l_consolidation_set_text := 'and pa1.consolidation_set_id = ' || to_char(l_consolidation_set_id) ;
101: ELSE
102: hr_utility.set_location(l_proc_name,25);
103: l_consolidation_set_text := NULL;

Line 102: hr_utility.set_location(l_proc_name,25);

98: IF l_consolidation_set_id IS NOT NULL THEN
99: hr_utility.set_location(l_proc_name,20);
100: l_consolidation_set_text := 'and pa1.consolidation_set_id = ' || to_char(l_consolidation_set_id) ;
101: ELSE
102: hr_utility.set_location(l_proc_name,25);
103: l_consolidation_set_text := NULL;
104: END IF;
105:
106: IF l_payroll_id IS NOT NULL THEN

Line 107: hr_utility.set_location(l_proc_name,30);

103: l_consolidation_set_text := NULL;
104: END IF;
105:
106: IF l_payroll_id IS NOT NULL THEN
107: hr_utility.set_location(l_proc_name,30);
108: l_payroll_text := 'and pa1.payroll_id = ' || to_char(l_payroll_id) ;
109: ELSE
110: hr_utility.set_location(l_proc_name,35);
111: l_payroll_text := null;

Line 110: hr_utility.set_location(l_proc_name,35);

106: IF l_payroll_id IS NOT NULL THEN
107: hr_utility.set_location(l_proc_name,30);
108: l_payroll_text := 'and pa1.payroll_id = ' || to_char(l_payroll_id) ;
109: ELSE
110: hr_utility.set_location(l_proc_name,35);
111: l_payroll_text := null;
112: END IF;
113:
114: hr_utility.set_location(l_proc_name,40);

Line 114: hr_utility.set_location(l_proc_name,40);

110: hr_utility.set_location(l_proc_name,35);
111: l_payroll_text := null;
112: END IF;
113:
114: hr_utility.set_location(l_proc_name,40);
115: sqlstr :=
116: 'SELECT distinct asg.person_id
117: FROM pay_payroll_actions ppa,
118: pay_payroll_actions pa1,

Line 145: hr_utility.set_location('Exiting :'||l_proc_name,45);

141: and ppa.effective_date between ppf.effective_start_date and ppf.effective_end_date
142: and ppf.payroll_id >=0
143: order by asg.person_id';
144:
145: hr_utility.set_location('Exiting :'||l_proc_name,45);
146:
147: END range_cursor;
148:
149:

Line 491: hr_utility.trace('pay_mx_payreg_pkg.action_creation ');

487: -- personal payment methods.
488: BEGIN
489:
490: FND_FILE.PUT_LINE(FND_FILE.LOG,'pay_mx_payreg_pkg.action_creation ');
491: hr_utility.trace('pay_mx_payreg_pkg.action_creation ');
492: hr_utility.set_location('Entering '||l_proc_name,5);
493:
494: SELECT legislative_parameters
495: INTO l_leg_param

Line 492: hr_utility.set_location('Entering '||l_proc_name,5);

488: BEGIN
489:
490: FND_FILE.PUT_LINE(FND_FILE.LOG,'pay_mx_payreg_pkg.action_creation ');
491: hr_utility.trace('pay_mx_payreg_pkg.action_creation ');
492: hr_utility.set_location('Entering '||l_proc_name,5);
493:
494: SELECT legislative_parameters
495: INTO l_leg_param
496: FROM pay_payroll_actions ppa

Line 499: hr_utility.set_location(l_proc_name,10);

495: INTO l_leg_param
496: FROM pay_payroll_actions ppa
497: WHERE ppa.payroll_action_id = pactid;
498:
499: hr_utility.set_location(l_proc_name,10);
500:
501: OPEN c_inputs( pactid);
502: FETCH c_inputs INTO l_payroll_id,
503: l_consolidation_set_id ,

Line 513: hr_utility.trace('stperson '||stperson);

509: cp_start_date,
510: cp_effective_date ;
511: CLOSE c_inputs;
512:
513: hr_utility.trace('stperson '||stperson);
514: hr_utility.trace('endperson '||endperson);
515: hr_utility.trace('l_payroll_id '||l_payroll_id);
516: hr_utility.trace('l_consolidation_set_id '||l_consolidation_set_id);
517: hr_utility.trace('l_tax_unit_id '||l_tax_unit_id);

Line 514: hr_utility.trace('endperson '||endperson);

510: cp_effective_date ;
511: CLOSE c_inputs;
512:
513: hr_utility.trace('stperson '||stperson);
514: hr_utility.trace('endperson '||endperson);
515: hr_utility.trace('l_payroll_id '||l_payroll_id);
516: hr_utility.trace('l_consolidation_set_id '||l_consolidation_set_id);
517: hr_utility.trace('l_tax_unit_id '||l_tax_unit_id);
518: hr_utility.trace('l_location_id '||l_location_id);

Line 515: hr_utility.trace('l_payroll_id '||l_payroll_id);

511: CLOSE c_inputs;
512:
513: hr_utility.trace('stperson '||stperson);
514: hr_utility.trace('endperson '||endperson);
515: hr_utility.trace('l_payroll_id '||l_payroll_id);
516: hr_utility.trace('l_consolidation_set_id '||l_consolidation_set_id);
517: hr_utility.trace('l_tax_unit_id '||l_tax_unit_id);
518: hr_utility.trace('l_location_id '||l_location_id);
519: hr_utility.trace('l_organization_id '||l_organization_id);

Line 516: hr_utility.trace('l_consolidation_set_id '||l_consolidation_set_id);

512:
513: hr_utility.trace('stperson '||stperson);
514: hr_utility.trace('endperson '||endperson);
515: hr_utility.trace('l_payroll_id '||l_payroll_id);
516: hr_utility.trace('l_consolidation_set_id '||l_consolidation_set_id);
517: hr_utility.trace('l_tax_unit_id '||l_tax_unit_id);
518: hr_utility.trace('l_location_id '||l_location_id);
519: hr_utility.trace('l_organization_id '||l_organization_id);
520: hr_utility.trace('l_business_group_id '||l_business_group_id);

Line 517: hr_utility.trace('l_tax_unit_id '||l_tax_unit_id);

513: hr_utility.trace('stperson '||stperson);
514: hr_utility.trace('endperson '||endperson);
515: hr_utility.trace('l_payroll_id '||l_payroll_id);
516: hr_utility.trace('l_consolidation_set_id '||l_consolidation_set_id);
517: hr_utility.trace('l_tax_unit_id '||l_tax_unit_id);
518: hr_utility.trace('l_location_id '||l_location_id);
519: hr_utility.trace('l_organization_id '||l_organization_id);
520: hr_utility.trace('l_business_group_id '||l_business_group_id);
521: hr_utility.trace('l_assignment_set_id '||l_assignment_set_id);

Line 518: hr_utility.trace('l_location_id '||l_location_id);

514: hr_utility.trace('endperson '||endperson);
515: hr_utility.trace('l_payroll_id '||l_payroll_id);
516: hr_utility.trace('l_consolidation_set_id '||l_consolidation_set_id);
517: hr_utility.trace('l_tax_unit_id '||l_tax_unit_id);
518: hr_utility.trace('l_location_id '||l_location_id);
519: hr_utility.trace('l_organization_id '||l_organization_id);
520: hr_utility.trace('l_business_group_id '||l_business_group_id);
521: hr_utility.trace('l_assignment_set_id '||l_assignment_set_id);
522: hr_utility.trace('l_legal_emp_id '||l_legal_emp_id);

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

515: hr_utility.trace('l_payroll_id '||l_payroll_id);
516: hr_utility.trace('l_consolidation_set_id '||l_consolidation_set_id);
517: hr_utility.trace('l_tax_unit_id '||l_tax_unit_id);
518: hr_utility.trace('l_location_id '||l_location_id);
519: hr_utility.trace('l_organization_id '||l_organization_id);
520: hr_utility.trace('l_business_group_id '||l_business_group_id);
521: hr_utility.trace('l_assignment_set_id '||l_assignment_set_id);
522: hr_utility.trace('l_legal_emp_id '||l_legal_emp_id);
523: hr_utility.trace('cp_start_date '||cp_start_date);

Line 520: hr_utility.trace('l_business_group_id '||l_business_group_id);

516: hr_utility.trace('l_consolidation_set_id '||l_consolidation_set_id);
517: hr_utility.trace('l_tax_unit_id '||l_tax_unit_id);
518: hr_utility.trace('l_location_id '||l_location_id);
519: hr_utility.trace('l_organization_id '||l_organization_id);
520: hr_utility.trace('l_business_group_id '||l_business_group_id);
521: hr_utility.trace('l_assignment_set_id '||l_assignment_set_id);
522: hr_utility.trace('l_legal_emp_id '||l_legal_emp_id);
523: hr_utility.trace('cp_start_date '||cp_start_date);
524: hr_utility.trace('cp_effective_date '||cp_effective_date);

Line 521: hr_utility.trace('l_assignment_set_id '||l_assignment_set_id);

517: hr_utility.trace('l_tax_unit_id '||l_tax_unit_id);
518: hr_utility.trace('l_location_id '||l_location_id);
519: hr_utility.trace('l_organization_id '||l_organization_id);
520: hr_utility.trace('l_business_group_id '||l_business_group_id);
521: hr_utility.trace('l_assignment_set_id '||l_assignment_set_id);
522: hr_utility.trace('l_legal_emp_id '||l_legal_emp_id);
523: hr_utility.trace('cp_start_date '||cp_start_date);
524: hr_utility.trace('cp_effective_date '||cp_effective_date);
525:

Line 522: hr_utility.trace('l_legal_emp_id '||l_legal_emp_id);

518: hr_utility.trace('l_location_id '||l_location_id);
519: hr_utility.trace('l_organization_id '||l_organization_id);
520: hr_utility.trace('l_business_group_id '||l_business_group_id);
521: hr_utility.trace('l_assignment_set_id '||l_assignment_set_id);
522: hr_utility.trace('l_legal_emp_id '||l_legal_emp_id);
523: hr_utility.trace('cp_start_date '||cp_start_date);
524: hr_utility.trace('cp_effective_date '||cp_effective_date);
525:
526: IF l_assignment_set_id IS NULL THEN

Line 523: hr_utility.trace('cp_start_date '||cp_start_date);

519: hr_utility.trace('l_organization_id '||l_organization_id);
520: hr_utility.trace('l_business_group_id '||l_business_group_id);
521: hr_utility.trace('l_assignment_set_id '||l_assignment_set_id);
522: hr_utility.trace('l_legal_emp_id '||l_legal_emp_id);
523: hr_utility.trace('cp_start_date '||cp_start_date);
524: hr_utility.trace('cp_effective_date '||cp_effective_date);
525:
526: IF l_assignment_set_id IS NULL THEN
527: hr_utility.set_location(l_proc_name,15);

Line 524: hr_utility.trace('cp_effective_date '||cp_effective_date);

520: hr_utility.trace('l_business_group_id '||l_business_group_id);
521: hr_utility.trace('l_assignment_set_id '||l_assignment_set_id);
522: hr_utility.trace('l_legal_emp_id '||l_legal_emp_id);
523: hr_utility.trace('cp_start_date '||cp_start_date);
524: hr_utility.trace('cp_effective_date '||cp_effective_date);
525:
526: IF l_assignment_set_id IS NULL THEN
527: hr_utility.set_location(l_proc_name,15);
528: OPEN c_actions(stperson

Line 527: hr_utility.set_location(l_proc_name,15);

523: hr_utility.trace('cp_start_date '||cp_start_date);
524: hr_utility.trace('cp_effective_date '||cp_effective_date);
525:
526: IF l_assignment_set_id IS NULL THEN
527: hr_utility.set_location(l_proc_name,15);
528: OPEN c_actions(stperson
529: ,endperson
530: ,l_payroll_id
531: ,l_consolidation_set_id

Line 540: hr_utility.set_location(l_proc_name,20);

536: ,l_business_group_id
537: ,cp_start_date
538: ,cp_effective_date);
539: ELSE
540: hr_utility.set_location(l_proc_name,20);
541: OPEN c_actions_1( stperson
542: ,endperson
543: ,l_payroll_id
544: ,l_consolidation_set_id

Line 556: hr_utility.set_location(l_proc_name,25);

552: ,cp_effective_date);
553:
554: END IF;
555:
556: hr_utility.set_location(l_proc_name,25);
557: l_asg_set_id := pay_payrg_pkg.get_parameter('PASID',l_leg_param);
558: num := 0;
559:
560: LOOP

Line 561: hr_utility.set_location(l_proc_name,30);

557: l_asg_set_id := pay_payrg_pkg.get_parameter('PASID',l_leg_param);
558: num := 0;
559:
560: LOOP
561: hr_utility.set_location(l_proc_name,30);
562:
563: IF l_assignment_set_id IS NULL THEN
564: hr_utility.set_location(l_proc_name,35);
565:

Line 564: hr_utility.set_location(l_proc_name,35);

560: LOOP
561: hr_utility.set_location(l_proc_name,30);
562:
563: IF l_assignment_set_id IS NULL THEN
564: hr_utility.set_location(l_proc_name,35);
565:
566: FETCH c_actions INTO lockedactid
567: ,assignid
568: ,greid

Line 575: hr_utility.set_location(l_proc_name,40);

571: ,l_source_action_id
572: ,l_start_date;
573:
574: IF c_actions%found then
575: hr_utility.set_location(l_proc_name,40);
576: num := num + 1;
577: END IF;
578: EXIT WHEN c_actions%NOTFOUND;
579:

Line 581: hr_utility.set_location(l_proc_name,45);

577: END IF;
578: EXIT WHEN c_actions%NOTFOUND;
579:
580: ELSE
581: hr_utility.set_location(l_proc_name,45);
582: FETCH c_actions_1 INTO lockedactid
583: ,assignid
584: ,greid
585: ,actiontype

Line 591: hr_utility.set_location(l_proc_name,50);

587: ,l_source_action_id
588: ,l_start_date;
589:
590: IF c_actions_1%found THEN
591: hr_utility.set_location(l_proc_name,50);
592: num := num + 1;
593: END IF;
594: EXIT WHEN c_actions_1%NOTFOUND;
595: END IF;

Line 597: hr_utility.set_location(l_proc_name,55);

593: END IF;
594: EXIT WHEN c_actions_1%NOTFOUND;
595: END IF;
596:
597: hr_utility.set_location(l_proc_name,55);
598: l_asg_flag := 'N';
599: IF l_asg_set_id IS NOT NULL THEN
600: hr_utility.set_location(l_proc_name,60);
601: l_asg_flag := hr_assignment_set.assignment_in_set(l_asg_set_id, assignid);

Line 600: hr_utility.set_location(l_proc_name,60);

596:
597: hr_utility.set_location(l_proc_name,55);
598: l_asg_flag := 'N';
599: IF l_asg_set_id IS NOT NULL THEN
600: hr_utility.set_location(l_proc_name,60);
601: l_asg_flag := hr_assignment_set.assignment_in_set(l_asg_set_id, assignid);
602: ELSE -- l_asg_set_id is null
603: hr_utility.set_location(l_proc_name,65);
604: l_asg_flag := 'Y';

Line 603: hr_utility.set_location(l_proc_name,65);

599: IF l_asg_set_id IS NOT NULL THEN
600: hr_utility.set_location(l_proc_name,60);
601: l_asg_flag := hr_assignment_set.assignment_in_set(l_asg_set_id, assignid);
602: ELSE -- l_asg_set_id is null
603: hr_utility.set_location(l_proc_name,65);
604: l_asg_flag := 'Y';
605: END IF;
606:
607: hr_utility.set_location(l_proc_name,70);

Line 607: hr_utility.set_location(l_proc_name,70);

603: hr_utility.set_location(l_proc_name,65);
604: l_asg_flag := 'Y';
605: END IF;
606:
607: hr_utility.set_location(l_proc_name,70);
608: IF (actiontype = 'P'
609: OR actiontype = 'U') THEN
610:
611: hr_utility.set_location(l_proc_name,75);

Line 611: hr_utility.set_location(l_proc_name,75);

607: hr_utility.set_location(l_proc_name,70);
608: IF (actiontype = 'P'
609: OR actiontype = 'U') THEN
610:
611: hr_utility.set_location(l_proc_name,75);
612: OPEN c_run_eff_date (lockedactid);
613:
614: hr_utility.set_location(l_proc_name,80);
615: FETCH c_run_eff_date INTO l_run_eff_date,

Line 614: hr_utility.set_location(l_proc_name,80);

610:
611: hr_utility.set_location(l_proc_name,75);
612: OPEN c_run_eff_date (lockedactid);
613:
614: hr_utility.set_location(l_proc_name,80);
615: FETCH c_run_eff_date INTO l_run_eff_date,
616: run_action_type;
617:
618: IF c_run_eff_date%NOTFOUND THEN

Line 619: hr_utility.set_location(l_proc_name,85);

615: FETCH c_run_eff_date INTO l_run_eff_date,
616: run_action_type;
617:
618: IF c_run_eff_date%NOTFOUND THEN
619: hr_utility.set_location(l_proc_name,85);
620: l_asg_flag := 'N';
621: END IF;
622: CLOSE c_run_eff_date;
623:

Line 624: hr_utility.set_location(l_proc_name,90);

620: l_asg_flag := 'N';
621: END IF;
622: CLOSE c_run_eff_date;
623:
624: hr_utility.set_location(l_proc_name,90);
625: IF l_run_eff_date BETWEEN cp_start_date AND cp_effective_date THEN
626: hr_utility.set_location(l_proc_name,95);
627: NULL;
628: ELSE

Line 626: hr_utility.set_location(l_proc_name,95);

622: CLOSE c_run_eff_date;
623:
624: hr_utility.set_location(l_proc_name,90);
625: IF l_run_eff_date BETWEEN cp_start_date AND cp_effective_date THEN
626: hr_utility.set_location(l_proc_name,95);
627: NULL;
628: ELSE
629: hr_utility.set_location(l_proc_name,100);
630: l_asg_flag := 'N';

Line 629: hr_utility.set_location(l_proc_name,100);

625: IF l_run_eff_date BETWEEN cp_start_date AND cp_effective_date THEN
626: hr_utility.set_location(l_proc_name,95);
627: NULL;
628: ELSE
629: hr_utility.set_location(l_proc_name,100);
630: l_asg_flag := 'N';
631: END IF;
632: END IF;
633:

Line 634: hr_utility.set_location(l_proc_name,105);

630: l_asg_flag := 'N';
631: END IF;
632: END IF;
633:
634: hr_utility.set_location(l_proc_name,105);
635:
636: IF l_asg_flag = 'Y' THEN
637: -- we need to insert one action for each of the
638: -- rows that we return from the cursor (i.e. one

Line 640: hr_utility.set_location(l_proc_name,110);

636: IF l_asg_flag = 'Y' THEN
637: -- we need to insert one action for each of the
638: -- rows that we return from the cursor (i.e. one
639: -- for each assignment/pre-payment/reversal).
640: hr_utility.set_location(l_proc_name,110);
641:
642: IF actiontype in ('P', 'U') THEN
643: hr_utility.set_location(l_proc_name,115);
644: OPEN c_payment_info (lockedactid);

Line 643: hr_utility.set_location(l_proc_name,115);

639: -- for each assignment/pre-payment/reversal).
640: hr_utility.set_location(l_proc_name,110);
641:
642: IF actiontype in ('P', 'U') THEN
643: hr_utility.set_location(l_proc_name,115);
644: OPEN c_payment_info (lockedactid);
645: LOOP
646: FETCH c_payment_info INTO ln_source_action_id;
647: EXIT WHEN c_payment_info%NOTFOUND;

Line 649: hr_utility.set_location(l_proc_name,120);

645: LOOP
646: FETCH c_payment_info INTO ln_source_action_id;
647: EXIT WHEN c_payment_info%NOTFOUND;
648: IF ln_source_action_id = -999 THEN
649: hr_utility.set_location(l_proc_name,120);
650: SELECT pay_assignment_actions_s.nextval
651: INTO lockingactid
652: FROM dual;
653: hr_utility.set_location(l_proc_name,125);

Line 653: hr_utility.set_location(l_proc_name,125);

649: hr_utility.set_location(l_proc_name,120);
650: SELECT pay_assignment_actions_s.nextval
651: INTO lockingactid
652: FROM dual;
653: hr_utility.set_location(l_proc_name,125);
654: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
655:
656: hr_utility.set_location(l_proc_name,130);
657: hr_nonrun_asact.insint(lockingactid,lockedactid);

Line 656: hr_utility.set_location(l_proc_name,130);

652: FROM dual;
653: hr_utility.set_location(l_proc_name,125);
654: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
655:
656: hr_utility.set_location(l_proc_name,130);
657: hr_nonrun_asact.insint(lockingactid,lockedactid);
658:
659: hr_utility.set_location(l_proc_name,135);
660: OPEN c_payroll_run (lockedactid);

Line 659: hr_utility.set_location(l_proc_name,135);

655:
656: hr_utility.set_location(l_proc_name,130);
657: hr_nonrun_asact.insint(lockingactid,lockedactid);
658:
659: hr_utility.set_location(l_proc_name,135);
660: OPEN c_payroll_run (lockedactid);
661: FETCH c_payroll_run INTO ln_master_action_id,lv_run_action_type;
662: CLOSE c_payroll_run;
663:

Line 670: hr_utility.set_location(l_proc_name,140);

666: UPDATE pay_assignment_actions
667: SET serial_number = serialno
668: WHERE assignment_action_id = lockingactid
669: AND tax_unit_id = greid;
670: hr_utility.set_location(l_proc_name,140);
671: -- Insert a row in pay_us_rpt_totals which includes
672: -- payroll_action_id,
673: -- report created assignment_action_id (lockingactid)
674: -- and "payroll run" assignment_action id.

Line 688: hr_utility.set_location(l_proc_name,145);

684: lockingactid,
685: ln_master_action_id,
686: assignid,
687: 'MX_PYR');
688: hr_utility.set_location(l_proc_name,145);
689: ELSIF ln_source_action_id <> -999 THEN
690: hr_utility.set_location(l_proc_name,150);
691: -- #16364431 Start
692: SELECT pay_assignment_actions_s.nextval

Line 690: hr_utility.set_location(l_proc_name,150);

686: assignid,
687: 'MX_PYR');
688: hr_utility.set_location(l_proc_name,145);
689: ELSIF ln_source_action_id <> -999 THEN
690: hr_utility.set_location(l_proc_name,150);
691: -- #16364431 Start
692: SELECT pay_assignment_actions_s.nextval
693: INTO lockingactid
694: FROM dual;

Line 695: hr_utility.set_location(l_proc_name,152);

691: -- #16364431 Start
692: SELECT pay_assignment_actions_s.nextval
693: INTO lockingactid
694: FROM dual;
695: hr_utility.set_location(l_proc_name,152);
696:
697: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
698:
699: hr_utility.set_location(l_proc_name,153);

Line 699: hr_utility.set_location(l_proc_name,153);

695: hr_utility.set_location(l_proc_name,152);
696:
697: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
698:
699: hr_utility.set_location(l_proc_name,153);
700: -- #16364431 End
701: /**************************************************************
702: ** we need to insert one action for each of the rows that we
703: ** return from the cursor (i.e. one for each assignment/pre-payment source).

Line 707: hr_utility.set_location(l_proc_name,155);

703: ** return from the cursor (i.e. one for each assignment/pre-payment source).
704: **************************************************************/
705: hr_nonrun_asact.insint(lockingactid,lockedactid);
706:
707: hr_utility.set_location(l_proc_name,155);
708: serialno := actiontype || to_char(ln_source_action_id);
709: -- update pay_assignment_actions serial_number with runactid.
710: UPDATE pay_assignment_actions
711: SET serial_number = serialno

Line 716: hr_utility.set_location(l_proc_name,160);

712: WHERE assignment_action_id = lockingactid
713: AND tax_unit_id = greid;
714: runactid := ln_source_action_id;
715: lv_sep_check := 'Y';
716: hr_utility.set_location(l_proc_name,160);
717: INSERT INTO pay_us_rpt_totals
718: (session_id,
719: tax_unit_id,
720: location_id,

Line 732: hr_utility.set_location(l_proc_name,165);

728: runactid,
729: assignid,
730: lv_sep_check,
731: 'MX_PYR');
732: hr_utility.set_location(l_proc_name,165);
733: END IF;
734: hr_utility.set_location(l_proc_name,170);
735: END LOOP;
736: CLOSE c_payment_info;

Line 734: hr_utility.set_location(l_proc_name,170);

730: lv_sep_check,
731: 'MX_PYR');
732: hr_utility.set_location(l_proc_name,165);
733: END IF;
734: hr_utility.set_location(l_proc_name,170);
735: END LOOP;
736: CLOSE c_payment_info;
737: ELSE -- This is a void action.
738: hr_utility.set_location(l_proc_name,175);

Line 738: hr_utility.set_location(l_proc_name,175);

734: hr_utility.set_location(l_proc_name,170);
735: END LOOP;
736: CLOSE c_payment_info;
737: ELSE -- This is a void action.
738: hr_utility.set_location(l_proc_name,175);
739: SELECT pay_assignment_actions_s.nextval
740: INTO lockingactid
741: FROM dual;
742: hr_utility.set_location(l_proc_name,180);

Line 742: hr_utility.set_location(l_proc_name,180);

738: hr_utility.set_location(l_proc_name,175);
739: SELECT pay_assignment_actions_s.nextval
740: INTO lockingactid
741: FROM dual;
742: hr_utility.set_location(l_proc_name,180);
743: -- insert the action record.
744: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
745:
746: hr_utility.set_location(l_proc_name,190);

Line 746: hr_utility.set_location(l_proc_name,190);

742: hr_utility.set_location(l_proc_name,180);
743: -- insert the action record.
744: hr_nonrun_asact.insact(lockingactid,assignid,pactid,chunk,greid);
745:
746: hr_utility.set_location(l_proc_name,190);
747: -- insert an interlock to this action.
748: hr_nonrun_asact.insint(lockingactid,lockedactid);
749: hr_utility.set_location(l_proc_name,200);
750:

Line 749: hr_utility.set_location(l_proc_name,200);

745:
746: hr_utility.set_location(l_proc_name,190);
747: -- insert an interlock to this action.
748: hr_nonrun_asact.insint(lockingactid,lockedactid);
749: hr_utility.set_location(l_proc_name,200);
750:
751: BEGIN
752: hr_utility.set_location(l_proc_name,205);
753: serialno := actiontype || to_char(lockedactid);

Line 752: hr_utility.set_location(l_proc_name,205);

748: hr_nonrun_asact.insint(lockingactid,lockedactid);
749: hr_utility.set_location(l_proc_name,200);
750:
751: BEGIN
752: hr_utility.set_location(l_proc_name,205);
753: serialno := actiontype || to_char(lockedactid);
754: -- update pay_assignment_actions serial_number with runactid.
755: UPDATE pay_assignment_actions
756: SET serial_number = serialno

Line 761: hr_utility.set_location(l_proc_name,210);

757: WHERE assignment_action_id = lockingactid
758: AND tax_unit_id = greid;
759: EXCEPTION
760: WHEN OTHERS THEN
761: hr_utility.set_location(l_proc_name,210);
762: NULL;
763: END;
764: hr_utility.set_location(l_proc_name,215);
765: -- Insert a row in pay_us_rpt_totals which includes

Line 764: hr_utility.set_location(l_proc_name,215);

760: WHEN OTHERS THEN
761: hr_utility.set_location(l_proc_name,210);
762: NULL;
763: END;
764: hr_utility.set_location(l_proc_name,215);
765: -- Insert a row in pay_us_rpt_totals which includes
766: -- payroll_action_id,
767: -- report created assignment_action_id (lockingactid)
768: -- and "payroll run" assignment_action id.

Line 784: hr_utility.set_location(l_proc_name,220);

780: lockedactid,
781: assignid,
782: 'MX_PYR'
783: );
784: hr_utility.set_location(l_proc_name,220);
785: END IF; -- if action_type in ('P', 'U');
786: hr_utility.set_location(l_proc_name,225);
787: END IF; -- if l_asg_flag = 'Y'
788: hr_utility.set_location(l_proc_name,230);

Line 786: hr_utility.set_location(l_proc_name,225);

782: 'MX_PYR'
783: );
784: hr_utility.set_location(l_proc_name,220);
785: END IF; -- if action_type in ('P', 'U');
786: hr_utility.set_location(l_proc_name,225);
787: END IF; -- if l_asg_flag = 'Y'
788: hr_utility.set_location(l_proc_name,230);
789: END LOOP;
790:

Line 788: hr_utility.set_location(l_proc_name,230);

784: hr_utility.set_location(l_proc_name,220);
785: END IF; -- if action_type in ('P', 'U');
786: hr_utility.set_location(l_proc_name,225);
787: END IF; -- if l_asg_flag = 'Y'
788: hr_utility.set_location(l_proc_name,230);
789: END LOOP;
790:
791: IF l_assignment_set_id is NULL then
792: -- hr_utility.trace('Closing c_actions');

Line 792: -- hr_utility.trace('Closing c_actions');

788: hr_utility.set_location(l_proc_name,230);
789: END LOOP;
790:
791: IF l_assignment_set_id is NULL then
792: -- hr_utility.trace('Closing c_actions');
793: hr_utility.set_location(l_proc_name,235);
794: CLOSE c_actions;
795: ELSE
796: -- hr_utility.trace('Closing c_actions_1');

Line 793: hr_utility.set_location(l_proc_name,235);

789: END LOOP;
790:
791: IF l_assignment_set_id is NULL then
792: -- hr_utility.trace('Closing c_actions');
793: hr_utility.set_location(l_proc_name,235);
794: CLOSE c_actions;
795: ELSE
796: -- hr_utility.trace('Closing c_actions_1');
797: hr_utility.set_location(l_proc_name,240);

Line 796: -- hr_utility.trace('Closing c_actions_1');

792: -- hr_utility.trace('Closing c_actions');
793: hr_utility.set_location(l_proc_name,235);
794: CLOSE c_actions;
795: ELSE
796: -- hr_utility.trace('Closing c_actions_1');
797: hr_utility.set_location(l_proc_name,240);
798: CLOSE c_actions_1;
799: END IF;
800: --hr_utility.trace_off;

Line 797: hr_utility.set_location(l_proc_name,240);

793: hr_utility.set_location(l_proc_name,235);
794: CLOSE c_actions;
795: ELSE
796: -- hr_utility.trace('Closing c_actions_1');
797: hr_utility.set_location(l_proc_name,240);
798: CLOSE c_actions_1;
799: END IF;
800: --hr_utility.trace_off;
801: END action_creation;

Line 800: --hr_utility.trace_off;

796: -- hr_utility.trace('Closing c_actions_1');
797: hr_utility.set_location(l_proc_name,240);
798: CLOSE c_actions_1;
799: END IF;
800: --hr_utility.trace_off;
801: END action_creation;
802:
803: -------------------------------- write_to_magtape ------------------------------
804:

Line 822: hr_utility.set_location('Entering:'||l_proc_name,10);

818: l_xml VARCHAR2(240);
819:
820: BEGIN
821: fnd_file.put_line(fnd_file.log,'pay_mx_payreg_pkg.load_xml_internal ');
822: hr_utility.set_location('Entering:'||l_proc_name,10);
823:
824: IF p_node_type = 'CS' THEN
825:
826: l_xml := '<'||p_node||'>'||EOL;

Line 846: hr_utility.set_location('Leaving:'||l_proc_name,20);

842: END IF;
843:
844: write_to_magtape_lob (l_xml);
845:
846: hr_utility.set_location('Leaving:'||l_proc_name,20);
847:
848: END load_xml_internal;
849:
850: -------------------------------- populate_xml_table -----------------------------

Line 1045: hr_utility.set_location ('Entering'|| l_proc_name ,10);

1041: l_proc_name VARCHAR2(100) := g_package_name||'.GENERATE_XML';
1042: BEGIN
1043:
1044: FND_FILE.PUT_LINE(FND_FILE.LOG,'pay_mx_payreg_pkg.generate_xml ');
1045: hr_utility.set_location ('Entering'|| l_proc_name ,10);
1046:
1047: ln_payroll_act_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1048: ln_curr_assign_act_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
1049: hr_utility.trace ('ln_payroll_act_id ='||ln_payroll_act_id );

Line 1049: hr_utility.trace ('ln_payroll_act_id ='||ln_payroll_act_id );

1045: hr_utility.set_location ('Entering'|| l_proc_name ,10);
1046:
1047: ln_payroll_act_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1048: ln_curr_assign_act_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
1049: hr_utility.trace ('ln_payroll_act_id ='||ln_payroll_act_id );
1050: hr_utility.trace ('ln_curr_assign_act_id ='||ln_curr_assign_act_id );
1051:
1052: OPEN c_inputs (ln_payroll_act_id);
1053: FETCH c_inputs INTO ln_tax_unit_id,

Line 1050: hr_utility.trace ('ln_curr_assign_act_id ='||ln_curr_assign_act_id );

1046:
1047: ln_payroll_act_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1048: ln_curr_assign_act_id := pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
1049: hr_utility.trace ('ln_payroll_act_id ='||ln_payroll_act_id );
1050: hr_utility.trace ('ln_curr_assign_act_id ='||ln_curr_assign_act_id );
1051:
1052: OPEN c_inputs (ln_payroll_act_id);
1053: FETCH c_inputs INTO ln_tax_unit_id,
1054: ln_organization_id,

Line 1058: hr_utility.set_location ('Entering'|| l_proc_name ,10);

1054: ln_organization_id,
1055: ln_business_group_id,
1056: ln_dimension_type;
1057: CLOSE c_inputs;
1058: hr_utility.set_location ('Entering'|| l_proc_name ,10);
1059:
1060: IF ln_tax_unit_id IS NULL THEN
1061: hr_utility.set_location (l_proc_name ,15);
1062: SELECT tax_unit_id

Line 1061: hr_utility.set_location (l_proc_name ,15);

1057: CLOSE c_inputs;
1058: hr_utility.set_location ('Entering'|| l_proc_name ,10);
1059:
1060: IF ln_tax_unit_id IS NULL THEN
1061: hr_utility.set_location (l_proc_name ,15);
1062: SELECT tax_unit_id
1063: INTO ln_tax_unit_id
1064: FROM pay_assignment_actions paa
1065: WHERE paa.payroll_Action_id = ln_payroll_act_id

Line 1069: hr_utility.set_location (l_proc_name ,20);

1065: WHERE paa.payroll_Action_id = ln_payroll_act_id
1066: AND assignment_action_id = ln_curr_assign_act_id;
1067: END IF;
1068:
1069: hr_utility.set_location (l_proc_name ,20);
1070: lt_pr_bal_context_tab(1).tax_unit_id := ln_tax_unit_id;
1071:
1072: IF ln_dimension_type = 1 THEN
1073: hr_utility.set_location (l_proc_name ,25);

Line 1073: hr_utility.set_location (l_proc_name ,25);

1069: hr_utility.set_location (l_proc_name ,20);
1070: lt_pr_bal_context_tab(1).tax_unit_id := ln_tax_unit_id;
1071:
1072: IF ln_dimension_type = 1 THEN
1073: hr_utility.set_location (l_proc_name ,25);
1074: OPEN c_get_def_bal_id ;
1075: FETCH c_get_def_bal_id BULK COLLECT INTO g_pay_reg_defbal_details;
1076: CLOSE c_get_def_bal_id;
1077:

Line 1079: hr_utility.set_location (l_proc_name ,30);

1075: FETCH c_get_def_bal_id BULK COLLECT INTO g_pay_reg_defbal_details;
1076: CLOSE c_get_def_bal_id;
1077:
1078: ELSIF ln_dimension_type = 2 THEN
1079: hr_utility.set_location (l_proc_name ,30);
1080: OPEN c_get_def_bal_id_mtd;
1081: FETCH c_get_def_bal_id_mtd BULK COLLECT INTO g_pay_reg_defbal_details;
1082: CLOSE c_get_def_bal_id_mtd;
1083:

Line 1085: hr_utility.set_location (l_proc_name ,35);

1081: FETCH c_get_def_bal_id_mtd BULK COLLECT INTO g_pay_reg_defbal_details;
1082: CLOSE c_get_def_bal_id_mtd;
1083:
1084: ELSIF ln_dimension_type = 3 THEN
1085: hr_utility.set_location (l_proc_name ,35);
1086: pay_us_balance_view_pkg.set_session_var('YTD','TRUE');
1087: OPEN c_get_def_bal_id_ytd;
1088: FETCH c_get_def_bal_id_ytd BULK COLLECT INTO g_pay_reg_defbal_details;
1089: CLOSE c_get_def_bal_id_ytd;

Line 1092: hr_utility.set_location (l_proc_name ,40);

1088: FETCH c_get_def_bal_id_ytd BULK COLLECT INTO g_pay_reg_defbal_details;
1089: CLOSE c_get_def_bal_id_ytd;
1090: END IF;
1091:
1092: hr_utility.set_location (l_proc_name ,40);
1093: FOR i IN g_pay_reg_defbal_details.first..g_pay_reg_defbal_details.last
1094: LOOP
1095: hr_utility.set_location ('Entering'|| l_proc_name ,45);
1096: g_pr_balance_value_tab(i).defined_balance_id := g_pay_reg_defbal_details(i).def_bal_id;

Line 1095: hr_utility.set_location ('Entering'|| l_proc_name ,45);

1091:
1092: hr_utility.set_location (l_proc_name ,40);
1093: FOR i IN g_pay_reg_defbal_details.first..g_pay_reg_defbal_details.last
1094: LOOP
1095: hr_utility.set_location ('Entering'|| l_proc_name ,45);
1096: g_pr_balance_value_tab(i).defined_balance_id := g_pay_reg_defbal_details(i).def_bal_id;
1097: END LOOP;
1098:
1099: hr_utility.set_location (l_proc_name ,50);

Line 1099: hr_utility.set_location (l_proc_name ,50);

1095: hr_utility.set_location ('Entering'|| l_proc_name ,45);
1096: g_pr_balance_value_tab(i).defined_balance_id := g_pay_reg_defbal_details(i).def_bal_id;
1097: END LOOP;
1098:
1099: hr_utility.set_location (l_proc_name ,50);
1100: OPEN c_get_assig_id (ln_payroll_act_id
1101: ,ln_curr_assign_act_id);
1102: FETCH c_get_assig_id INTO ln_assig_id;
1103: CLOSE c_get_assig_id;

Line 1105: hr_utility.set_location (l_proc_name ,55);

1101: ,ln_curr_assign_act_id);
1102: FETCH c_get_assig_id INTO ln_assig_id;
1103: CLOSE c_get_assig_id;
1104:
1105: hr_utility.set_location (l_proc_name ,55);
1106: OPEN c_get_assig_act_id (ln_payroll_act_id
1107: ,ln_curr_assign_act_id);
1108: FETCH c_get_assig_act_id INTO ln_assignment_act_id;
1109: CLOSE c_get_assig_act_id;

Line 1111: hr_utility.set_location (l_proc_name ,60);

1107: ,ln_curr_assign_act_id);
1108: FETCH c_get_assig_act_id INTO ln_assignment_act_id;
1109: CLOSE c_get_assig_act_id;
1110:
1111: hr_utility.set_location (l_proc_name ,60);
1112: OPEN c_get_emp_name (ln_assig_id);
1113: FETCH c_get_emp_name INTO lv_person_name, lv_assignment_number;
1114: CLOSE c_get_emp_name;
1115:

Line 1116: hr_utility.set_location (l_proc_name ,65);

1112: OPEN c_get_emp_name (ln_assig_id);
1113: FETCH c_get_emp_name INTO lv_person_name, lv_assignment_number;
1114: CLOSE c_get_emp_name;
1115:
1116: hr_utility.set_location (l_proc_name ,65);
1117: OPEN c_get_payroll_period(ln_assignment_act_id);
1118: FETCH c_get_payroll_period INTO ld_period_start_date, ld_period_end_date;
1119: CLOSE c_get_payroll_period;
1120:

Line 1121: hr_utility.set_location (l_proc_name ,70);

1117: OPEN c_get_payroll_period(ln_assignment_act_id);
1118: FETCH c_get_payroll_period INTO ld_period_start_date, ld_period_end_date;
1119: CLOSE c_get_payroll_period;
1120:
1121: hr_utility.set_location (l_proc_name ,70);
1122: OPEN c_get_payroll_details(ln_assignment_act_id);
1123: FETCH c_get_payroll_details INTO lv_payroll_name, lv_consolidated_set_name;
1124: CLOSE c_get_payroll_details;
1125:

Line 1126: hr_utility.set_location (l_proc_name ,75);

1122: OPEN c_get_payroll_details(ln_assignment_act_id);
1123: FETCH c_get_payroll_details INTO lv_payroll_name, lv_consolidated_set_name;
1124: CLOSE c_get_payroll_details;
1125:
1126: hr_utility.set_location (l_proc_name ,75);
1127: pay_balance_pkg.get_value
1128: (p_assignment_action_id => ln_assignment_act_id
1129: ,p_defined_balance_lst => g_pr_balance_value_tab
1130: ,p_context_lst => lt_pr_bal_context_tab

Line 1133: hr_utility.set_location (l_proc_name ,80);

1129: ,p_defined_balance_lst => g_pr_balance_value_tab
1130: ,p_context_lst => lt_pr_bal_context_tab
1131: ,p_output_table => lt_pr_bal_result_tab
1132: );
1133: hr_utility.set_location (l_proc_name ,80);
1134:
1135: FOR j IN g_pay_reg_defbal_details.first..g_pay_reg_defbal_details.last
1136: LOOP
1137: hr_utility.set_location (l_proc_name ,85);

Line 1137: hr_utility.set_location (l_proc_name ,85);

1133: hr_utility.set_location (l_proc_name ,80);
1134:
1135: FOR j IN g_pay_reg_defbal_details.first..g_pay_reg_defbal_details.last
1136: LOOP
1137: hr_utility.set_location (l_proc_name ,85);
1138: g_pay_reg_defbal_details(j).bal_value := nvl(lt_pr_bal_result_tab(j).balance_value,0);
1139: populate_xml_table (g_pay_reg_defbal_details(j).user_entity_name,g_pay_reg_defbal_details(j).bal_value,'TEXT');
1140: END LOOP;
1141:

Line 1142: hr_utility.set_location (l_proc_name ,90);

1138: g_pay_reg_defbal_details(j).bal_value := nvl(lt_pr_bal_result_tab(j).balance_value,0);
1139: populate_xml_table (g_pay_reg_defbal_details(j).user_entity_name,g_pay_reg_defbal_details(j).bal_value,'TEXT');
1140: END LOOP;
1141:
1142: hr_utility.set_location (l_proc_name ,90);
1143: load_xml_internal('CS','EMPLOYEE',NULL);
1144: load_xml_internal('D','ASSIGNMENT_NO',lv_assignment_number);
1145: load_xml_internal('D','EMPLOYEE_NAME',lv_person_name);
1146: load_xml_internal('D','PERIOD_START_DATE',to_char(ld_period_start_date,'DD-MON-YYYY'));

Line 1150: hr_utility.set_location (l_proc_name ,95);

1146: load_xml_internal('D','PERIOD_START_DATE',to_char(ld_period_start_date,'DD-MON-YYYY'));
1147: load_xml_internal('D','PERIOD_END_DATE',to_char(ld_period_end_date,'DD-MON-YYYY'));
1148: load_xml_internal('D','PAYROLL_NAME',lv_payroll_name);
1149: load_xml_internal('D','CONS_SET_NAME',lv_consolidated_set_name);
1150: hr_utility.set_location (l_proc_name ,95);
1151:
1152: FOR i IN payroll_reg_xml_tbl.FIRST..payroll_reg_xml_tbl.LAST LOOP
1153: hr_utility.set_location (l_proc_name ,100);
1154: load_xml_internal('D',payroll_reg_xml_tbl(i).name,payroll_reg_xml_tbl(i).value);

Line 1153: hr_utility.set_location (l_proc_name ,100);

1149: load_xml_internal('D','CONS_SET_NAME',lv_consolidated_set_name);
1150: hr_utility.set_location (l_proc_name ,95);
1151:
1152: FOR i IN payroll_reg_xml_tbl.FIRST..payroll_reg_xml_tbl.LAST LOOP
1153: hr_utility.set_location (l_proc_name ,100);
1154: load_xml_internal('D',payroll_reg_xml_tbl(i).name,payroll_reg_xml_tbl(i).value);
1155:
1156: hr_utility.set_location (l_proc_name ,105);
1157: INSERT INTO pay_us_rpt_totals (session_id

Line 1156: hr_utility.set_location (l_proc_name ,105);

1152: FOR i IN payroll_reg_xml_tbl.FIRST..payroll_reg_xml_tbl.LAST LOOP
1153: hr_utility.set_location (l_proc_name ,100);
1154: load_xml_internal('D',payroll_reg_xml_tbl(i).name,payroll_reg_xml_tbl(i).value);
1155:
1156: hr_utility.set_location (l_proc_name ,105);
1157: INSERT INTO pay_us_rpt_totals (session_id
1158: ,business_group_id
1159: ,tax_unit_id
1160: ,attribute1

Line 1179: hr_utility.set_location (l_proc_name ,110);

1175: ,payroll_reg_xml_tbl(i).name
1176: ,payroll_reg_xml_tbl(i).value
1177: ,'MX_PYR'
1178: );
1179: hr_utility.set_location (l_proc_name ,110);
1180: END LOOP;
1181:
1182: hr_utility.set_location (l_proc_name ,115);
1183: load_xml_internal('CE','EMPLOYEE',NULL);

Line 1182: hr_utility.set_location (l_proc_name ,115);

1178: );
1179: hr_utility.set_location (l_proc_name ,110);
1180: END LOOP;
1181:
1182: hr_utility.set_location (l_proc_name ,115);
1183: load_xml_internal('CE','EMPLOYEE',NULL);
1184:
1185: hr_utility.set_location (l_proc_name ,120);
1186: payroll_reg_xml_tbl.DELETE;

Line 1185: hr_utility.set_location (l_proc_name ,120);

1181:
1182: hr_utility.set_location (l_proc_name ,115);
1183: load_xml_internal('CE','EMPLOYEE',NULL);
1184:
1185: hr_utility.set_location (l_proc_name ,120);
1186: payroll_reg_xml_tbl.DELETE;
1187:
1188: hr_utility.set_location ('Leaving '||l_proc_name ,120);
1189: END generate_xml;

Line 1188: hr_utility.set_location ('Leaving '||l_proc_name ,120);

1184:
1185: hr_utility.set_location (l_proc_name ,120);
1186: payroll_reg_xml_tbl.DELETE;
1187:
1188: hr_utility.set_location ('Leaving '||l_proc_name ,120);
1189: END generate_xml;
1190:
1191: ---------------------------------- generate_xml_header -------------------------------
1192: PROCEDURE generate_xml_header AS

Line 1289: hr_utility.set_location ('Entering'|| l_proc_name ,10);

1285: l_proc_name VARCHAR2(100) := g_package_name||'.GENERATE_XML_HEADER';
1286: lv_sort_option VARCHAR2(240);
1287:
1288: BEGIN
1289: hr_utility.set_location ('Entering'|| l_proc_name ,10);
1290: FND_FILE.PUT_LINE(FND_FILE.LOG,'pay_mx_payreg_pkg.generate_xml_header ');
1291: payroll_reg_xml_tbl.delete;
1292:
1293: hr_utility.set_location ( l_proc_name ,15);

Line 1293: hr_utility.set_location ( l_proc_name ,15);

1289: hr_utility.set_location ('Entering'|| l_proc_name ,10);
1290: FND_FILE.PUT_LINE(FND_FILE.LOG,'pay_mx_payreg_pkg.generate_xml_header ');
1291: payroll_reg_xml_tbl.delete;
1292:
1293: hr_utility.set_location ( l_proc_name ,15);
1294: ln_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1295:
1296: hr_utility.set_location ( l_proc_name ,20);
1297:

Line 1296: hr_utility.set_location ( l_proc_name ,20);

1292:
1293: hr_utility.set_location ( l_proc_name ,15);
1294: ln_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1295:
1296: hr_utility.set_location ( l_proc_name ,20);
1297:
1298: OPEN c_inputs (ln_payroll_action_id);
1299: FETCH c_inputs INTO ln_payroll_id,
1300: ln_consolidation_set_id,

Line 1311: hr_utility.set_location ( l_proc_name ,25);

1307: ld_start_date,
1308: ld_effective_date;
1309: CLOSE c_inputs;
1310:
1311: hr_utility.set_location ( l_proc_name ,25);
1312: OPEN c_get_payroll_name (ln_payroll_id);
1313: FETCH c_get_payroll_name INTO lv_payroll_name;
1314: CLOSE c_get_payroll_name;
1315:

Line 1316: hr_utility.set_location ( l_proc_name ,30);

1312: OPEN c_get_payroll_name (ln_payroll_id);
1313: FETCH c_get_payroll_name INTO lv_payroll_name;
1314: CLOSE c_get_payroll_name;
1315:
1316: hr_utility.set_location ( l_proc_name ,30);
1317: OPEN c_get_consolidation_set_name (ln_consolidation_set_id);
1318: FETCH c_get_consolidation_set_name INTO lv_consolidation_set_name;
1319: CLOSE c_get_consolidation_set_name;
1320:

Line 1321: hr_utility.set_location ( l_proc_name ,35);

1317: OPEN c_get_consolidation_set_name (ln_consolidation_set_id);
1318: FETCH c_get_consolidation_set_name INTO lv_consolidation_set_name;
1319: CLOSE c_get_consolidation_set_name;
1320:
1321: hr_utility.set_location ( l_proc_name ,35);
1322: OPEN c_get_gre_name (ln_tax_unit_id);
1323: FETCH c_get_gre_name INTO lv_gre_name;
1324: CLOSE c_get_gre_name;
1325:

Line 1326: hr_utility.set_location ( l_proc_name ,40);

1322: OPEN c_get_gre_name (ln_tax_unit_id);
1323: FETCH c_get_gre_name INTO lv_gre_name;
1324: CLOSE c_get_gre_name;
1325:
1326: hr_utility.set_location ( l_proc_name ,40);
1327: OPEN c_get_gre_name (ln_legal_emp_id);
1328: FETCH c_get_gre_name INTO lv_le_name;
1329: CLOSE c_get_gre_name;
1330:

Line 1331: hr_utility.set_location ( l_proc_name ,45);

1327: OPEN c_get_gre_name (ln_legal_emp_id);
1328: FETCH c_get_gre_name INTO lv_le_name;
1329: CLOSE c_get_gre_name;
1330:
1331: hr_utility.set_location ( l_proc_name ,45);
1332: OPEN c_get_gre_name (ln_org_id);
1333: FETCH c_get_gre_name INTO lv_org_name;
1334: CLOSE c_get_gre_name;
1335:

Line 1336: hr_utility.set_location ( l_proc_name ,50);

1332: OPEN c_get_gre_name (ln_org_id);
1333: FETCH c_get_gre_name INTO lv_org_name;
1334: CLOSE c_get_gre_name;
1335:
1336: hr_utility.set_location ( l_proc_name ,50);
1337: OPEN c_get_assig_set_id (ln_assignment_set_id);
1338: FETCH c_get_assig_set_id INTO lv_assignment_set_name;
1339: CLOSE c_get_assig_set_id;
1340:

Line 1341: hr_utility.set_location ( l_proc_name ,55);

1337: OPEN c_get_assig_set_id (ln_assignment_set_id);
1338: FETCH c_get_assig_set_id INTO lv_assignment_set_name;
1339: CLOSE c_get_assig_set_id;
1340:
1341: hr_utility.set_location ( l_proc_name ,55);
1342: OPEN c_get_dimension_type (ln_dimension_id);
1343: FETCH c_get_dimension_type INTO lv_dimension_name;
1344: CLOSE c_get_dimension_type;
1345:

Line 1346: hr_utility.set_location ( l_proc_name ,57);

1342: OPEN c_get_dimension_type (ln_dimension_id);
1343: FETCH c_get_dimension_type INTO lv_dimension_name;
1344: CLOSE c_get_dimension_type;
1345:
1346: hr_utility.set_location ( l_proc_name ,57);
1347: OPEN c_get_sort_option (lv_sort_1);
1348: FETCH c_get_sort_option INTO lv_sort_option;
1349: CLOSE c_get_sort_option;
1350:

Line 1354: hr_utility.set_location ( l_proc_name ,60);

1350:
1351:
1352: lv_buf := pay_magtape_generic.get_parameter_value('ROOT_XML_TAG');
1353:
1354: hr_utility.set_location ( l_proc_name ,60);
1355: write_to_magtape_lob (lv_buf);
1356:
1357: hr_utility.set_location ( l_proc_name ,65);
1358: populate_xml_table('START_DATE', ld_start_date,'TEXT');

Line 1357: hr_utility.set_location ( l_proc_name ,65);

1353:
1354: hr_utility.set_location ( l_proc_name ,60);
1355: write_to_magtape_lob (lv_buf);
1356:
1357: hr_utility.set_location ( l_proc_name ,65);
1358: populate_xml_table('START_DATE', ld_start_date,'TEXT');
1359: populate_xml_table('END_DATE',ld_effective_date,'TEXT');
1360: populate_xml_table('PAYROLL', lv_payroll_name,'TEXT');
1361: populate_xml_table('CONSOLIDATION_SET', lv_consolidation_set_name,'TEXT');

Line 1369: hr_utility.set_location ( l_proc_name ,70);

1365: populate_xml_table('ASSIGNMENT_SET', lv_assignment_set_name,'TEXT');
1366: populate_xml_table('DIMENSION_ID', ln_dimension_id,'TEXT');
1367: populate_xml_table('DIMENSION', lv_dimension_name,'TEXT');
1368: populate_xml_table('SORT_OPTION_1', lv_sort_option,'TEXT');
1369: hr_utility.set_location ( l_proc_name ,70);
1370:
1371: load_xml_internal('CS','REPORT_PARMETERS',NULL);
1372: hr_utility.set_location ( l_proc_name ,75);
1373:

Line 1372: hr_utility.set_location ( l_proc_name ,75);

1368: populate_xml_table('SORT_OPTION_1', lv_sort_option,'TEXT');
1369: hr_utility.set_location ( l_proc_name ,70);
1370:
1371: load_xml_internal('CS','REPORT_PARMETERS',NULL);
1372: hr_utility.set_location ( l_proc_name ,75);
1373:
1374: FOR i IN payroll_reg_xml_tbl.FIRST..payroll_reg_xml_tbl.LAST
1375: LOOP
1376: hr_utility.set_location ( l_proc_name ,80);

Line 1376: hr_utility.set_location ( l_proc_name ,80);

1372: hr_utility.set_location ( l_proc_name ,75);
1373:
1374: FOR i IN payroll_reg_xml_tbl.FIRST..payroll_reg_xml_tbl.LAST
1375: LOOP
1376: hr_utility.set_location ( l_proc_name ,80);
1377: load_xml_internal('D',payroll_reg_xml_tbl(i).name,payroll_reg_xml_tbl(i).value);
1378: END LOOP;
1379:
1380: hr_utility.set_location ( l_proc_name ,85);

Line 1380: hr_utility.set_location ( l_proc_name ,85);

1376: hr_utility.set_location ( l_proc_name ,80);
1377: load_xml_internal('D',payroll_reg_xml_tbl(i).name,payroll_reg_xml_tbl(i).value);
1378: END LOOP;
1379:
1380: hr_utility.set_location ( l_proc_name ,85);
1381: load_xml_internal('CE','REPORT_PARMETERS',NULL);
1382:
1383: hr_utility.set_location ( l_proc_name ,90);
1384: payroll_reg_xml_tbl.DELETE;

Line 1383: hr_utility.set_location ( l_proc_name ,90);

1379:
1380: hr_utility.set_location ( l_proc_name ,85);
1381: load_xml_internal('CE','REPORT_PARMETERS',NULL);
1382:
1383: hr_utility.set_location ( l_proc_name ,90);
1384: payroll_reg_xml_tbl.DELETE;
1385:
1386: FOR i IN csr_get_le_tot(ln_payroll_action_id)
1387: LOOP

Line 1388: hr_utility.set_location ( l_proc_name ,95);

1384: payroll_reg_xml_tbl.DELETE;
1385:
1386: FOR i IN csr_get_le_tot(ln_payroll_action_id)
1387: LOOP
1388: hr_utility.set_location ( l_proc_name ,95);
1389: load_xml_internal('D','LE_'||i.balance_name,i.total);
1390: END LOOP;
1391:
1392: hr_utility.set_location ( 'Leaving'||l_proc_name ,100);

Line 1392: hr_utility.set_location ( 'Leaving'||l_proc_name ,100);

1388: hr_utility.set_location ( l_proc_name ,95);
1389: load_xml_internal('D','LE_'||i.balance_name,i.total);
1390: END LOOP;
1391:
1392: hr_utility.set_location ( 'Leaving'||l_proc_name ,100);
1393: END generate_xml_header;
1394:
1395: ---------------------------------- generate_xml_footer ----------------------------------
1396: PROCEDURE generate_xml_footer AS

Line 1403: hr_utility.set_location ( 'Entering'||l_proc_name ,10);

1399: ln_payroll_action_id NUMBER;
1400: l_proc_name VARCHAR2(100) := g_package_name||'.GENERATE_XML_FOOTER';
1401: l_remove_act VARCHAR2(10);
1402: BEGIN
1403: hr_utility.set_location ( 'Entering'||l_proc_name ,10);
1404: FND_FILE.PUT_LINE(FND_FILE.LOG,'pay_mx_payreg_pkg.generate_xml_footer ');
1405:
1406: lv_buf := ' 1407: SUBSTR(pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'),

Line 1412: hr_utility.set_location ( l_proc_name ,20);

1408: 2);
1409:
1410: write_to_magtape_lob (lv_buf);
1411:
1412: hr_utility.set_location ( l_proc_name ,20);
1413: ln_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1414:
1415: SELECT get_parameter('REMOVE_ACT', pa1.legislative_parameters)
1416: INTO l_remove_act

Line 1420: hr_utility.set_location ( l_proc_name ,30);

1416: INTO l_remove_act
1417: FROM pay_payroll_actions pa1
1418: WHERE pa1.payroll_action_id = ln_payroll_action_id;
1419:
1420: hr_utility.set_location ( l_proc_name ,30);
1421: IF (l_remove_act IS NULL OR l_remove_act = 'Y') THEN
1422: hr_utility.set_location ( l_proc_name ,40);
1423: DELETE FROM pay_us_rpt_totals
1424: WHERE session_id = ln_payroll_action_id

Line 1422: hr_utility.set_location ( l_proc_name ,40);

1418: WHERE pa1.payroll_action_id = ln_payroll_action_id;
1419:
1420: hr_utility.set_location ( l_proc_name ,30);
1421: IF (l_remove_act IS NULL OR l_remove_act = 'Y') THEN
1422: hr_utility.set_location ( l_proc_name ,40);
1423: DELETE FROM pay_us_rpt_totals
1424: WHERE session_id = ln_payroll_action_id
1425: AND attribute30 = 'MX_PYR';
1426: END IF;

Line 1428: hr_utility.set_location ( 'Leaving'||l_proc_name ,50);

1424: WHERE session_id = ln_payroll_action_id
1425: AND attribute30 = 'MX_PYR';
1426: END IF;
1427:
1428: hr_utility.set_location ( 'Leaving'||l_proc_name ,50);
1429:
1430: END generate_xml_footer;
1431:
1432: ---------------------------------- generate_gre_xml_header -------------------------------

Line 1458: hr_utility.set_location ( 'Entering'||l_proc_name ,10);

1454: lv_gre_name VARCHAR2(30);
1455: l_proc_name VARCHAR2(100) := g_package_name||'.GENERATE_GRE_XML_HEADER';
1456:
1457: BEGIN
1458: hr_utility.set_location ( 'Entering'||l_proc_name ,10);
1459: FND_FILE.PUT_LINE(FND_FILE.LOG,'pay_mx_payreg_pkg.generate_gre_xml_header ');
1460: payroll_reg_xml_tbl.delete;
1461:
1462: hr_utility.set_location (l_proc_name ,15);

Line 1462: hr_utility.set_location (l_proc_name ,15);

1458: hr_utility.set_location ( 'Entering'||l_proc_name ,10);
1459: FND_FILE.PUT_LINE(FND_FILE.LOG,'pay_mx_payreg_pkg.generate_gre_xml_header ');
1460: payroll_reg_xml_tbl.delete;
1461:
1462: hr_utility.set_location (l_proc_name ,15);
1463: ln_payroll_action_id := pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID');
1464: ln_tax_unit_id := pay_magtape_generic.get_parameter_value('TRANSFER_GRE_ID');
1465:
1466:

Line 1470: hr_utility.set_location (l_proc_name ,20);

1466:
1467: lv_buf := pay_magtape_generic.get_parameter_value('ROOT_GRE_TAG');
1468: write_to_magtape_lob (lv_buf);
1469:
1470: hr_utility.set_location (l_proc_name ,20);
1471: OPEN c_get_gre_name (ln_tax_unit_id);
1472: FETCH c_get_gre_name INTO lv_gre_name;
1473: CLOSE c_get_gre_name;
1474:

Line 1475: hr_utility.set_location (l_proc_name ,25);

1471: OPEN c_get_gre_name (ln_tax_unit_id);
1472: FETCH c_get_gre_name INTO lv_gre_name;
1473: CLOSE c_get_gre_name;
1474:
1475: hr_utility.set_location (l_proc_name ,25);
1476: populate_xml_table('GRE_NAME', lv_gre_name,'TEXT');
1477:
1478: hr_utility.set_location (l_proc_name ,30);
1479: FOR i IN payroll_reg_xml_tbl.FIRST..payroll_reg_xml_tbl.LAST LOOP

Line 1478: hr_utility.set_location (l_proc_name ,30);

1474:
1475: hr_utility.set_location (l_proc_name ,25);
1476: populate_xml_table('GRE_NAME', lv_gre_name,'TEXT');
1477:
1478: hr_utility.set_location (l_proc_name ,30);
1479: FOR i IN payroll_reg_xml_tbl.FIRST..payroll_reg_xml_tbl.LAST LOOP
1480: hr_utility.set_location (l_proc_name ,35);
1481: load_xml_internal('D',payroll_reg_xml_tbl(i).name,payroll_reg_xml_tbl(i).value);
1482: END LOOP;

Line 1480: hr_utility.set_location (l_proc_name ,35);

1476: populate_xml_table('GRE_NAME', lv_gre_name,'TEXT');
1477:
1478: hr_utility.set_location (l_proc_name ,30);
1479: FOR i IN payroll_reg_xml_tbl.FIRST..payroll_reg_xml_tbl.LAST LOOP
1480: hr_utility.set_location (l_proc_name ,35);
1481: load_xml_internal('D',payroll_reg_xml_tbl(i).name,payroll_reg_xml_tbl(i).value);
1482: END LOOP;
1483:
1484: hr_utility.set_location (l_proc_name ,40);

Line 1484: hr_utility.set_location (l_proc_name ,40);

1480: hr_utility.set_location (l_proc_name ,35);
1481: load_xml_internal('D',payroll_reg_xml_tbl(i).name,payroll_reg_xml_tbl(i).value);
1482: END LOOP;
1483:
1484: hr_utility.set_location (l_proc_name ,40);
1485: FOR i IN csr_get_gre_tot(ln_payroll_action_id,ln_tax_unit_id)
1486: LOOP
1487: hr_utility.set_location (l_proc_name ,45);
1488: load_xml_internal('D','GRE_'||i.balance_name,i.total);

Line 1487: hr_utility.set_location (l_proc_name ,45);

1483:
1484: hr_utility.set_location (l_proc_name ,40);
1485: FOR i IN csr_get_gre_tot(ln_payroll_action_id,ln_tax_unit_id)
1486: LOOP
1487: hr_utility.set_location (l_proc_name ,45);
1488: load_xml_internal('D','GRE_'||i.balance_name,i.total);
1489: END LOOP;
1490:
1491: payroll_reg_xml_tbl.DELETE;

Line 1492: hr_utility.set_location ('Leaving'||l_proc_name ,50);

1488: load_xml_internal('D','GRE_'||i.balance_name,i.total);
1489: END LOOP;
1490:
1491: payroll_reg_xml_tbl.DELETE;
1492: hr_utility.set_location ('Leaving'||l_proc_name ,50);
1493: END generate_gre_xml_header;
1494:
1495: ---------------------------------- generate_xml_footer ----------------------------------
1496: PROCEDURE generate_gre_xml_footer AS

Line 1500: hr_utility.trace ('Entering generate_gre_xml_footer');

1496: PROCEDURE generate_gre_xml_footer AS
1497: lv_buf VARCHAR2(8000);
1498: l_proc_name VARCHAR2(100) := g_package_name||'.GENERATE_GRE_XML_FOOTER';
1499: BEGIN
1500: hr_utility.trace ('Entering generate_gre_xml_footer');
1501: FND_FILE.PUT_LINE(FND_FILE.LOG,'pay_mx_payreg_pkg.generate_gre_xml_footer ');
1502: lv_buf := ' 1503: SUBSTR(pay_magtape_generic.get_parameter_value('ROOT_GRE_TAG'),
1504: 2);

Line 1508: hr_utility.trace ('Leaving generate_gre_xml_footer');

1504: 2);
1505:
1506: write_to_magtape_lob (lv_buf);
1507:
1508: hr_utility.trace ('Leaving generate_gre_xml_footer');
1509:
1510: END generate_gre_xml_footer;
1511:
1512: ---------------------------------- sort_action ----------------------------------

Line 1526: hr_utility.set_location ('Entering'||l_proc_name ,10);

1522: l_proc_name VARCHAR2(100) := g_package_name||'.SORT_ACTION';
1523:
1524: BEGIN
1525: FND_FILE.PUT_LINE(FND_FILE.LOG,'pay_mx_payreg_pkg.sort_action ');
1526: hr_utility.set_location ('Entering'||l_proc_name ,10);
1527: SELECT pay_payrg_pkg.get_parameter('P_S1', ppa.legislative_parameters)
1528: INTO l_sort_1
1529: FROM pay_payroll_actions ppa
1530: WHERE ppa.payroll_action_id = payactid;

Line 1532: hr_utility.set_location ('Entering'||l_proc_name ,20);

1528: INTO l_sort_1
1529: FROM pay_payroll_actions ppa
1530: WHERE ppa.payroll_action_id = payactid;
1531: --Modified the sort query for sorting by employee name and payroll name
1532: hr_utility.set_location ('Entering'||l_proc_name ,20);
1533: sqlstr :=
1534: 'SELECT paa.rowid
1535: FROM pay_assignment_actions paa,
1536: pay_payroll_actions ppa

Line 1561: hr_utility.set_location ('Leaving'||l_proc_name ,20);

1557: )
1558: for update of paa.assignment_id';
1559:
1560: len := LENGTH(sqlstr); -- return the length of the string.
1561: hr_utility.set_location ('Leaving'||l_proc_name ,20);
1562: END sort_action;
1563:
1564: ----------------------------- get_parameter -------------------------------
1565: FUNCTION get_parameter(name in varchar2

Line 1606: hr_utility.set_location ('Entering '||l_proc_name ,10);

1602: return_val varchar2(240);
1603: l_proc_name VARCHAR2(100) := g_package_name||'.SORT_OPTION';
1604: BEGIN
1605: FND_FILE.PUT_LINE(FND_FILE.LOG,'pay_mx_payreg_pkg.sort_option ');
1606: hr_utility.set_location ('Entering '||l_proc_name ,10);
1607: --Modified the sort query for sorting by employee name(EMP_NAME) and
1608: --payroll name(PAY_NAME)
1609: /* IF c_option_name = 'GRE' THEN
1610: SELECT hou1.name

Line 1633: hr_utility.set_location ('Entering '||l_proc_name ,15);

1629: AND rownum = 1;
1630: END IF; */
1631:
1632: IF c_option_name = 'EMP_NAME' Then
1633: hr_utility.set_location ('Entering '||l_proc_name ,15);
1634: SELECT ppf.full_name
1635: INTO return_val
1636: FROM per_all_assignments_f paf
1637: ,per_all_people_f ppf

Line 1646: hr_utility.set_location ('Entering '||l_proc_name ,20);

1642: ppf.effective_start_date AND ppf.effective_end_date
1643: AND paf.assignment_id = c_assignment_id
1644: AND rownum = 1;
1645: ELSIF c_option_name = 'PAY_NAME' Then
1646: hr_utility.set_location ('Entering '||l_proc_name ,20);
1647: SELECT ppf.payroll_name||' '||papf.full_name
1648: INTO return_val
1649: FROM per_all_assignments_f paf
1650: ,pay_payrolls_f ppf

Line 1662: hr_utility.set_location ('Entering '||l_proc_name ,25);

1658: AND paf.person_id = papf.person_id
1659: AND c_effective_date BETWEEN
1660: papf.effective_start_date AND papf.effective_end_date;
1661: ELSIF c_option_name = 'GRE' Then
1662: hr_utility.set_location ('Entering '||l_proc_name ,25);
1663: SELECT hou1.name
1664: INTO return_val
1665: FROM hr_all_organization_units hou1
1666: WHERE hou1.organization_id = c_tax_unit_id

Line 1670: hr_utility.set_location ('Leaving '||l_proc_name ,30);

1666: WHERE hou1.organization_id = c_tax_unit_id
1667: AND rownum = 1;
1668: END IF;
1669:
1670: hr_utility.set_location ('Leaving '||l_proc_name ,30);
1671: RETURN return_val;
1672:
1673: EXCEPTION
1674: WHEN OTHERS THEN

Line 1675: hr_utility.set_location ('Exception:'||l_proc_name ,25);

1671: RETURN return_val;
1672:
1673: EXCEPTION
1674: WHEN OTHERS THEN
1675: hr_utility.set_location ('Exception:'||l_proc_name ,25);
1676: RETURN '1';
1677:
1678: END sort_option;
1679: