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

Line 30: --hr_utility.trace_on(NULL,'EVS');

26: PROCEDURE get_parameters( p_payroll_action_id IN NUMBER ) IS
27: l_proc varchar2(40) := g_package || 'get_parameters';
28: --
29: BEGIN
30: --hr_utility.trace_on(NULL,'EVS');
31: hr_utility.set_location(l_proc,10);
32: --
33: -- If parameters haven't already been set, then set them
34: --

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

27: l_proc varchar2(40) := g_package || 'get_parameters';
28: --
29: BEGIN
30: --hr_utility.trace_on(NULL,'EVS');
31: hr_utility.set_location(l_proc,10);
32: --
33: -- If parameters haven't already been set, then set them
34: --
35: IF (g_business_group_id IS NULL) THEN

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

32: --
33: -- If parameters haven't already been set, then set them
34: --
35: IF (g_business_group_id IS NULL) THEN
36: hr_utility.set_location(l_proc,20);
37: --
38: SELECT
39: ppa.business_group_id
40: ,nvl(pay_core_utils.get_parameter('END_DATE',ppa.legislative_parameters), to_char(sysdate,'YYYY') || '/12/31')

Line 55: hr_utility.trace('g_business_group_id : ' || g_business_group_id);

51: FROM pay_payroll_actions ppa
52: WHERE payroll_action_id = p_payroll_action_id;
53: --
54: --
55: hr_utility.trace('g_business_group_id : ' || g_business_group_id);
56: hr_utility.trace('g_start_date : ' || g_start_date);
57: hr_utility.trace('g_end_date : ' || g_end_date);
58: hr_utility.trace('g_tax_unit_id : ' || g_tax_unit_id);
59:

Line 56: hr_utility.trace('g_start_date : ' || g_start_date);

52: WHERE payroll_action_id = p_payroll_action_id;
53: --
54: --
55: hr_utility.trace('g_business_group_id : ' || g_business_group_id);
56: hr_utility.trace('g_start_date : ' || g_start_date);
57: hr_utility.trace('g_end_date : ' || g_end_date);
58: hr_utility.trace('g_tax_unit_id : ' || g_tax_unit_id);
59:
60: END IF;

Line 57: hr_utility.trace('g_end_date : ' || g_end_date);

53: --
54: --
55: hr_utility.trace('g_business_group_id : ' || g_business_group_id);
56: hr_utility.trace('g_start_date : ' || g_start_date);
57: hr_utility.trace('g_end_date : ' || g_end_date);
58: hr_utility.trace('g_tax_unit_id : ' || g_tax_unit_id);
59:
60: END IF;
61: hr_utility.set_location(l_proc,30);

Line 58: hr_utility.trace('g_tax_unit_id : ' || g_tax_unit_id);

54: --
55: hr_utility.trace('g_business_group_id : ' || g_business_group_id);
56: hr_utility.trace('g_start_date : ' || g_start_date);
57: hr_utility.trace('g_end_date : ' || g_end_date);
58: hr_utility.trace('g_tax_unit_id : ' || g_tax_unit_id);
59:
60: END IF;
61: hr_utility.set_location(l_proc,30);
62: --

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

57: hr_utility.trace('g_end_date : ' || g_end_date);
58: hr_utility.trace('g_tax_unit_id : ' || g_tax_unit_id);
59:
60: END IF;
61: hr_utility.set_location(l_proc,30);
62: --
63: END get_parameters;
64:
65: -------------------------------------------------------------------------------

Line 104: hr_utility.set_location(l_proc,10);

100: l_gre_name VARCHAR2(2000);
101:
102: BEGIN
103:
104: hr_utility.set_location(l_proc,10);
105: get_parameters(p_payroll_action_id => pactid);
106:
107:
108: IF g_tax_unit_id IS NULL THEN

Line 257: hr_utility.trace('RK Modified SQL: ' || sqlstr);

253: order by ppf.person_id';
254: */
255:
256:
257: hr_utility.trace('RK Modified SQL: ' || sqlstr);
258:
259: END range_cursor;
260:
261: -- -----------------------------------------------------------------------------

Line 538: --hr_utility.trace_on(NULL,'EVS');

534: l_proc varchar2(40) := g_package || 'action_creation';
535: --
536: BEGIN
537: --
538: --hr_utility.trace_on(NULL,'EVS');
539: hr_utility.set_location('Entering.. ' || l_proc,10);
540: get_parameters( p_payroll_action_id => pactid );
541:
542: hr_utility.trace('g_business_group_id :'||to_char(g_business_group_id));

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

535: --
536: BEGIN
537: --
538: --hr_utility.trace_on(NULL,'EVS');
539: hr_utility.set_location('Entering.. ' || l_proc,10);
540: get_parameters( p_payroll_action_id => pactid );
541:
542: hr_utility.trace('g_business_group_id :'||to_char(g_business_group_id));
543: hr_utility.trace('g_start_date :'||to_char(g_start_date));

Line 542: hr_utility.trace('g_business_group_id :'||to_char(g_business_group_id));

538: --hr_utility.trace_on(NULL,'EVS');
539: hr_utility.set_location('Entering.. ' || l_proc,10);
540: get_parameters( p_payroll_action_id => pactid );
541:
542: hr_utility.trace('g_business_group_id :'||to_char(g_business_group_id));
543: hr_utility.trace('g_start_date :'||to_char(g_start_date));
544: hr_utility.trace('g_end_date :'||to_char(g_end_date));
545: hr_utility.trace('Stperson :'||to_char(stperson));
546: hr_utility.trace('Endperson :'||to_char(endperson));

Line 543: hr_utility.trace('g_start_date :'||to_char(g_start_date));

539: hr_utility.set_location('Entering.. ' || l_proc,10);
540: get_parameters( p_payroll_action_id => pactid );
541:
542: hr_utility.trace('g_business_group_id :'||to_char(g_business_group_id));
543: hr_utility.trace('g_start_date :'||to_char(g_start_date));
544: hr_utility.trace('g_end_date :'||to_char(g_end_date));
545: hr_utility.trace('Stperson :'||to_char(stperson));
546: hr_utility.trace('Endperson :'||to_char(endperson));
547: hr_utility.trace('tax_unit_id :'||to_char(g_tax_unit_id));

Line 544: hr_utility.trace('g_end_date :'||to_char(g_end_date));

540: get_parameters( p_payroll_action_id => pactid );
541:
542: hr_utility.trace('g_business_group_id :'||to_char(g_business_group_id));
543: hr_utility.trace('g_start_date :'||to_char(g_start_date));
544: hr_utility.trace('g_end_date :'||to_char(g_end_date));
545: hr_utility.trace('Stperson :'||to_char(stperson));
546: hr_utility.trace('Endperson :'||to_char(endperson));
547: hr_utility.trace('tax_unit_id :'||to_char(g_tax_unit_id));
548:

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

541:
542: hr_utility.trace('g_business_group_id :'||to_char(g_business_group_id));
543: hr_utility.trace('g_start_date :'||to_char(g_start_date));
544: hr_utility.trace('g_end_date :'||to_char(g_end_date));
545: hr_utility.trace('Stperson :'||to_char(stperson));
546: hr_utility.trace('Endperson :'||to_char(endperson));
547: hr_utility.trace('tax_unit_id :'||to_char(g_tax_unit_id));
548:
549: hr_utility.trace('g_evs_category : ' || g_evs_category);

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

542: hr_utility.trace('g_business_group_id :'||to_char(g_business_group_id));
543: hr_utility.trace('g_start_date :'||to_char(g_start_date));
544: hr_utility.trace('g_end_date :'||to_char(g_end_date));
545: hr_utility.trace('Stperson :'||to_char(stperson));
546: hr_utility.trace('Endperson :'||to_char(endperson));
547: hr_utility.trace('tax_unit_id :'||to_char(g_tax_unit_id));
548:
549: hr_utility.trace('g_evs_category : ' || g_evs_category);
550:

Line 547: hr_utility.trace('tax_unit_id :'||to_char(g_tax_unit_id));

543: hr_utility.trace('g_start_date :'||to_char(g_start_date));
544: hr_utility.trace('g_end_date :'||to_char(g_end_date));
545: hr_utility.trace('Stperson :'||to_char(stperson));
546: hr_utility.trace('Endperson :'||to_char(endperson));
547: hr_utility.trace('tax_unit_id :'||to_char(g_tax_unit_id));
548:
549: hr_utility.trace('g_evs_category : ' || g_evs_category);
550:
551: if g_evs_category = 'EMPLOYEE' then

Line 549: hr_utility.trace('g_evs_category : ' || g_evs_category);

545: hr_utility.trace('Stperson :'||to_char(stperson));
546: hr_utility.trace('Endperson :'||to_char(endperson));
547: hr_utility.trace('tax_unit_id :'||to_char(g_tax_unit_id));
548:
549: hr_utility.trace('g_evs_category : ' || g_evs_category);
550:
551: if g_evs_category = 'EMPLOYEE' then
552: hr_utility.set_location(l_proc,20);
553: for asgrec in c_actions_ee(pactid,stperson, endperson) loop

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

548:
549: hr_utility.trace('g_evs_category : ' || g_evs_category);
550:
551: if g_evs_category = 'EMPLOYEE' then
552: hr_utility.set_location(l_proc,20);
553: for asgrec in c_actions_ee(pactid,stperson, endperson) loop
554: hr_utility.trace('RK in c_actions_ee cursor');
555: SELECT pay_assignment_actions_s.nextval
556: INTO lockingactid

Line 554: hr_utility.trace('RK in c_actions_ee cursor');

550:
551: if g_evs_category = 'EMPLOYEE' then
552: hr_utility.set_location(l_proc,20);
553: for asgrec in c_actions_ee(pactid,stperson, endperson) loop
554: hr_utility.trace('RK in c_actions_ee cursor');
555: SELECT pay_assignment_actions_s.nextval
556: INTO lockingactid
557: FROM dual;
558: -- insert the action record.

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

560: asgrec.segment1);
561: --
562: end loop;
563: elsif g_evs_category = 'NEWHIRE' then
564: hr_utility.set_location(l_proc,30);
565: hr_utility.trace('g_evs_category = NEWHIRE Satisfied ');
566: for asgrec in c_actions_nh(pactid,stperson, endperson) loop
567:
568: SELECT pay_assignment_actions_s.nextval

Line 565: hr_utility.trace('g_evs_category = NEWHIRE Satisfied ');

561: --
562: end loop;
563: elsif g_evs_category = 'NEWHIRE' then
564: hr_utility.set_location(l_proc,30);
565: hr_utility.trace('g_evs_category = NEWHIRE Satisfied ');
566: for asgrec in c_actions_nh(pactid,stperson, endperson) loop
567:
568: SELECT pay_assignment_actions_s.nextval
569: INTO lockingactid

Line 575: hr_utility.trace('Created New Asg_Action: '||to_char(lockingactid));

571:
572: -- insert the action record.
573: hr_nonrun_asact.insact(lockingactid,asgrec.assignment_id,pactid,chunk,
574: asgrec.segment1);
575: hr_utility.trace('Created New Asg_Action: '||to_char(lockingactid));
576: hr_utility.trace('Asg_id: '||to_char(asgrec.assignment_id));
577: hr_utility.trace('GRE: '||asgrec.segment1);
578: --
579: end loop;

Line 576: hr_utility.trace('Asg_id: '||to_char(asgrec.assignment_id));

572: -- insert the action record.
573: hr_nonrun_asact.insact(lockingactid,asgrec.assignment_id,pactid,chunk,
574: asgrec.segment1);
575: hr_utility.trace('Created New Asg_Action: '||to_char(lockingactid));
576: hr_utility.trace('Asg_id: '||to_char(asgrec.assignment_id));
577: hr_utility.trace('GRE: '||asgrec.segment1);
578: --
579: end loop;
580: elsif g_evs_category = 'RETIREE' then

Line 577: hr_utility.trace('GRE: '||asgrec.segment1);

573: hr_nonrun_asact.insact(lockingactid,asgrec.assignment_id,pactid,chunk,
574: asgrec.segment1);
575: hr_utility.trace('Created New Asg_Action: '||to_char(lockingactid));
576: hr_utility.trace('Asg_id: '||to_char(asgrec.assignment_id));
577: hr_utility.trace('GRE: '||asgrec.segment1);
578: --
579: end loop;
580: elsif g_evs_category = 'RETIREE' then
581: hr_utility.set_location(l_proc,40);

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

577: hr_utility.trace('GRE: '||asgrec.segment1);
578: --
579: end loop;
580: elsif g_evs_category = 'RETIREE' then
581: hr_utility.set_location(l_proc,40);
582: for asgrec in c_actions_rt(pactid,stperson, endperson) loop
583:
584: SELECT pay_assignment_actions_s.nextval
585: INTO lockingactid

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

590: asgrec.segment1);
591: --
592: end loop;
593: elsif g_evs_category = 'EMPRTR' then
594: hr_utility.set_location(l_proc,50);
595: for asgrec in c_actions_ee(pactid,stperson, endperson) loop
596:
597: SELECT pay_assignment_actions_s.nextval
598: INTO lockingactid

Line 609: hr_utility.set_location('Leaving.. ' || l_proc,60);

605: end loop;
606: end if;
607:
608: --
609: hr_utility.set_location('Leaving.. ' || l_proc,60);
610: /* hr_utility.trace_off; */
611: END action_creation;
612: --
613:

Line 610: /* hr_utility.trace_off; */

606: end if;
607:
608: --
609: hr_utility.set_location('Leaving.. ' || l_proc,60);
610: /* hr_utility.trace_off; */
611: END action_creation;
612: --
613:
614: -- ----------------------------------------------------------------------------

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

656: l_proc varchar2(72);
657: BEGIN
658: l_proc := g_package||'get_root_dir';
659:
660: hr_utility.set_location('Entering:' || l_proc,10);
661:
662: IF INSTR(p_path,',',1) = 0 THEN
663: IF INSTR(p_path,';',1) = 0 THEN
664: RETURN SUBSTR(p_path , 1 ,LENGTH(p_path));

Line 671: hr_utility.set_location('Leaving:' || l_proc,20);

667: END IF;
668: ELSE
669: RETURN SUBSTR(p_path , 1 ,INSTR(p_path,',',1)-1);
670: END IF;
671: hr_utility.set_location('Leaving:' || l_proc,20);
672:
673: EXCEPTION
674: WHEN OTHERS THEN
675: hr_utility.set_location(l_proc || substr(sqlerrm,1,50),999);

Line 675: hr_utility.set_location(l_proc || substr(sqlerrm,1,50),999);

671: hr_utility.set_location('Leaving:' || l_proc,20);
672:
673: EXCEPTION
674: WHEN OTHERS THEN
675: hr_utility.set_location(l_proc || substr(sqlerrm,1,50),999);
676: fnd_file.put_line(fnd_file.log,SQLERRM);
677: END get_root_dir;
678:
679: ---------------------------------------------------------------------------

Line 917: hr_utility.set_location('Enteriing : ' || l_proc,10);

913: l_multiple_req_indicator varchar2(3);
914: begin
915:
916: l_proc := g_package||'evs_mag_report';
917: hr_utility.set_location('Enteriing : ' || l_proc,10);
918: hr_utility.trace('p_path = ' || p_path);
919: hr_utility.trace('p_start_date = ' || p_start_date);
920: hr_utility.trace('p_end_date = ' || p_end_date);
921: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);

Line 918: hr_utility.trace('p_path = ' || p_path);

914: begin
915:
916: l_proc := g_package||'evs_mag_report';
917: hr_utility.set_location('Enteriing : ' || l_proc,10);
918: hr_utility.trace('p_path = ' || p_path);
919: hr_utility.trace('p_start_date = ' || p_start_date);
920: hr_utility.trace('p_end_date = ' || p_end_date);
921: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
922: hr_utility.trace('p_report_category = ' || p_report_category);

Line 919: hr_utility.trace('p_start_date = ' || p_start_date);

915:
916: l_proc := g_package||'evs_mag_report';
917: hr_utility.set_location('Enteriing : ' || l_proc,10);
918: hr_utility.trace('p_path = ' || p_path);
919: hr_utility.trace('p_start_date = ' || p_start_date);
920: hr_utility.trace('p_end_date = ' || p_end_date);
921: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
922: hr_utility.trace('p_report_category = ' || p_report_category);
923: hr_utility.trace('p_user_control_data = ' || p_user_control_data);

Line 920: hr_utility.trace('p_end_date = ' || p_end_date);

916: l_proc := g_package||'evs_mag_report';
917: hr_utility.set_location('Enteriing : ' || l_proc,10);
918: hr_utility.trace('p_path = ' || p_path);
919: hr_utility.trace('p_start_date = ' || p_start_date);
920: hr_utility.trace('p_end_date = ' || p_end_date);
921: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
922: hr_utility.trace('p_report_category = ' || p_report_category);
923: hr_utility.trace('p_user_control_data = ' || p_user_control_data);
924: hr_utility.trace('p_requester_id_code = ' || p_requester_id_code);

Line 921: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);

917: hr_utility.set_location('Enteriing : ' || l_proc,10);
918: hr_utility.trace('p_path = ' || p_path);
919: hr_utility.trace('p_start_date = ' || p_start_date);
920: hr_utility.trace('p_end_date = ' || p_end_date);
921: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
922: hr_utility.trace('p_report_category = ' || p_report_category);
923: hr_utility.trace('p_user_control_data = ' || p_user_control_data);
924: hr_utility.trace('p_requester_id_code = ' || p_requester_id_code);
925: hr_utility.trace('p_report_category = ' || p_report_category);

Line 922: hr_utility.trace('p_report_category = ' || p_report_category);

918: hr_utility.trace('p_path = ' || p_path);
919: hr_utility.trace('p_start_date = ' || p_start_date);
920: hr_utility.trace('p_end_date = ' || p_end_date);
921: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
922: hr_utility.trace('p_report_category = ' || p_report_category);
923: hr_utility.trace('p_user_control_data = ' || p_user_control_data);
924: hr_utility.trace('p_requester_id_code = ' || p_requester_id_code);
925: hr_utility.trace('p_report_category = ' || p_report_category);
926:

Line 923: hr_utility.trace('p_user_control_data = ' || p_user_control_data);

919: hr_utility.trace('p_start_date = ' || p_start_date);
920: hr_utility.trace('p_end_date = ' || p_end_date);
921: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
922: hr_utility.trace('p_report_category = ' || p_report_category);
923: hr_utility.trace('p_user_control_data = ' || p_user_control_data);
924: hr_utility.trace('p_requester_id_code = ' || p_requester_id_code);
925: hr_utility.trace('p_report_category = ' || p_report_category);
926:
927:

Line 924: hr_utility.trace('p_requester_id_code = ' || p_requester_id_code);

920: hr_utility.trace('p_end_date = ' || p_end_date);
921: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
922: hr_utility.trace('p_report_category = ' || p_report_category);
923: hr_utility.trace('p_user_control_data = ' || p_user_control_data);
924: hr_utility.trace('p_requester_id_code = ' || p_requester_id_code);
925: hr_utility.trace('p_report_category = ' || p_report_category);
926:
927:
928: l_count := p_count;

Line 925: hr_utility.trace('p_report_category = ' || p_report_category);

921: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
922: hr_utility.trace('p_report_category = ' || p_report_category);
923: hr_utility.trace('p_user_control_data = ' || p_user_control_data);
924: hr_utility.trace('p_requester_id_code = ' || p_requester_id_code);
925: hr_utility.trace('p_report_category = ' || p_report_category);
926:
927:
928: l_count := p_count;
929: l_file_count := 0;

Line 939: hr_utility.trace('l_report_category = ' || l_report_category);

935: else
936: l_report_category := p_report_category;
937: end if;
938:
939: hr_utility.trace('l_report_category = ' || l_report_category);
940:
941: if l_report_category = 'EMPLOYEE' then
942: hr_utility.set_location(l_proc,20);
943: FOR ee_record IN csr_get_ee_info(p_tax_unit_id) LOOP

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

938:
939: hr_utility.trace('l_report_category = ' || l_report_category);
940:
941: if l_report_category = 'EMPLOYEE' then
942: hr_utility.set_location(l_proc,20);
943: FOR ee_record IN csr_get_ee_info(p_tax_unit_id) LOOP
944: evs_put_record
945: (p_file_id => g_file_id
946: ,p_ssn => ee_record.national_identifier

Line 958: hr_utility.trace('l_count = ' || l_count);

954: ,p_multiple_req_indicator => l_file_count
955: );
956: l_count := l_count + 1;
957: l_gre_count := l_gre_count + 1;
958: hr_utility.trace('l_count = ' || l_count);
959: hr_utility.trace('l_gre_count = ' || l_gre_count);
960: if p_media_type = 'DISKETTE' then
961: if l_count >= 11000 then
962: utl_file.fclose(g_file_id);

Line 959: hr_utility.trace('l_gre_count = ' || l_gre_count);

955: );
956: l_count := l_count + 1;
957: l_gre_count := l_gre_count + 1;
958: hr_utility.trace('l_count = ' || l_count);
959: hr_utility.trace('l_gre_count = ' || l_gre_count);
960: if p_media_type = 'DISKETTE' then
961: if l_count >= 11000 then
962: utl_file.fclose(g_file_id);
963: l_file_count := l_file_count + 1 ;

Line 964: hr_utility.set_location(l_proc,25);

960: if p_media_type = 'DISKETTE' then
961: if l_count >= 11000 then
962: utl_file.fclose(g_file_id);
963: l_file_count := l_file_count + 1 ;
964: hr_utility.set_location(l_proc,25);
965: g_file_id := utl_file.fopen(p_path, g_file_name || l_file_count, 'w');
966: l_count := 0;
967: end if;
968: end if;

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

967: end if;
968: end if;
969: END LOOP;
970: elsif l_report_category = 'NEWHIRE' then
971: hr_utility.set_location(l_proc,30);
972: FOR ee_record IN csr_get_nh_info(p_tax_unit_id) LOOP
973: evs_put_record
974: (p_file_id => g_file_id
975: ,p_ssn => ee_record.national_identifier

Line 987: hr_utility.trace('l_count = ' || l_count);

983: ,p_multiple_req_indicator => l_file_count
984: );
985: l_count := l_count + 1;
986: l_gre_count := l_gre_count + 1;
987: hr_utility.trace('l_count = ' || l_count);
988: hr_utility.trace('l_gre_count = ' || l_gre_count);
989: if p_media_type = 'DISKETTE' then
990: if l_count >= 11000 then
991: hr_utility.set_location(l_proc,35);

Line 988: hr_utility.trace('l_gre_count = ' || l_gre_count);

984: );
985: l_count := l_count + 1;
986: l_gre_count := l_gre_count + 1;
987: hr_utility.trace('l_count = ' || l_count);
988: hr_utility.trace('l_gre_count = ' || l_gre_count);
989: if p_media_type = 'DISKETTE' then
990: if l_count >= 11000 then
991: hr_utility.set_location(l_proc,35);
992: utl_file.fclose(g_file_id);

Line 991: hr_utility.set_location(l_proc,35);

987: hr_utility.trace('l_count = ' || l_count);
988: hr_utility.trace('l_gre_count = ' || l_gre_count);
989: if p_media_type = 'DISKETTE' then
990: if l_count >= 11000 then
991: hr_utility.set_location(l_proc,35);
992: utl_file.fclose(g_file_id);
993: l_file_count := l_file_count + 1 ;
994: g_file_id := utl_file.fopen(p_path, g_file_name || l_file_count, 'w');
995: l_count := 0;

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

996: end if;
997: end if;
998: END LOOP;
999: elsif l_report_category = 'RETIREE' then
1000: hr_utility.set_location(l_proc,40);
1001: FOR ee_record IN csr_get_retire_info(p_tax_unit_id) LOOP
1002: evs_put_record
1003: (p_file_id => g_file_id
1004: ,p_ssn => ee_record.national_identifier

Line 1016: hr_utility.trace('l_count = ' || l_count);

1012: ,p_multiple_req_indicator => l_file_count
1013: );
1014: l_count := l_count + 1;
1015: l_gre_count := l_gre_count + 1;
1016: hr_utility.trace('l_count = ' || l_count);
1017: hr_utility.trace('l_gre_count = ' || l_gre_count);
1018: if p_media_type = 'DISKETTE' then
1019: if l_count >= 11000 then
1020: hr_utility.set_location(l_proc,45);

Line 1017: hr_utility.trace('l_gre_count = ' || l_gre_count);

1013: );
1014: l_count := l_count + 1;
1015: l_gre_count := l_gre_count + 1;
1016: hr_utility.trace('l_count = ' || l_count);
1017: hr_utility.trace('l_gre_count = ' || l_gre_count);
1018: if p_media_type = 'DISKETTE' then
1019: if l_count >= 11000 then
1020: hr_utility.set_location(l_proc,45);
1021: utl_file.fclose(g_file_id);

Line 1020: hr_utility.set_location(l_proc,45);

1016: hr_utility.trace('l_count = ' || l_count);
1017: hr_utility.trace('l_gre_count = ' || l_gre_count);
1018: if p_media_type = 'DISKETTE' then
1019: if l_count >= 11000 then
1020: hr_utility.set_location(l_proc,45);
1021: utl_file.fclose(g_file_id);
1022: l_file_count := l_file_count + 1 ;
1023: g_file_id := utl_file.fopen(p_path, g_file_name || l_file_count, 'w');
1024: l_count := 0;

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

1025: end if;
1026: end if;
1027: END LOOP;
1028: elsif l_report_category = 'EMPRTR' then
1029: hr_utility.set_location(l_proc,50);
1030: FOR ee_record IN csr_get_ee_info(p_tax_unit_id) LOOP --BUG3930540
1031: evs_put_record
1032: (p_file_id => g_file_id
1033: ,p_ssn => ee_record.national_identifier

Line 1044: hr_utility.trace('l_count = ' || l_count);

1040: ,p_requester_id_code => p_requester_id_code
1041: ,p_multiple_req_indicator => l_file_count
1042: );
1043: l_count := l_count + 1;
1044: hr_utility.trace('l_count = ' || l_count);
1045: l_gre_count := l_gre_count + 1;
1046: hr_utility.trace('l_gre_count = ' || l_gre_count);
1047: if p_media_type = 'DISKETTE' then
1048: if l_count >= 11000 then

Line 1046: hr_utility.trace('l_gre_count = ' || l_gre_count);

1042: );
1043: l_count := l_count + 1;
1044: hr_utility.trace('l_count = ' || l_count);
1045: l_gre_count := l_gre_count + 1;
1046: hr_utility.trace('l_gre_count = ' || l_gre_count);
1047: if p_media_type = 'DISKETTE' then
1048: if l_count >= 11000 then
1049: hr_utility.set_location(l_proc,55);
1050: utl_file.fclose(g_file_id);

Line 1049: hr_utility.set_location(l_proc,55);

1045: l_gre_count := l_gre_count + 1;
1046: hr_utility.trace('l_gre_count = ' || l_gre_count);
1047: if p_media_type = 'DISKETTE' then
1048: if l_count >= 11000 then
1049: hr_utility.set_location(l_proc,55);
1050: utl_file.fclose(g_file_id);
1051: l_file_count := l_file_count + 1 ;
1052: g_file_id := utl_file.fopen(p_path, g_file_name || l_file_count, 'w');
1053: l_count := 0;

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

1055: end if;
1056: END LOOP;
1057: end if;
1058: p_gre_count := l_gre_count;
1059: hr_utility.set_location('Leaving : ' || l_proc,100);
1060: end evs_mag_report;
1061:
1062: ---------------------------------------------------------------------------
1063: -- EVS_PUT_REPORT

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

1084: l_multiple_req_indicator varchar2(3);
1085:
1086: begin
1087: l_proc := g_package || 'evs_put_record';
1088: hr_utility.set_location('Entering : ' || l_proc,10);
1089:
1090: if p_multiple_req_indicator = 0 then
1091: l_multiple_req_indicator := ' ';
1092: else

Line 1128: hr_utility.trace('l_buff = ' || l_buff);

1124: || rpad(nvl(l_multiple_req_indicator,' '),3,' ')
1125: --
1126: || l_delimiter -- BUG4447245
1127: ;
1128: hr_utility.trace('l_buff = ' || l_buff);
1129:
1130: fnd_file.put_line
1131: (which => fnd_file.output
1132: ,buff => l_buff

Line 1138: hr_utility.set_location('Leavning : ' || l_proc,100);

1134:
1135: utl_file.put(g_file_id,l_buff);
1136: utl_file.fflush(g_file_id); -- XXXXX
1137:
1138: hr_utility.set_location('Leavning : ' || l_proc,100);
1139: end evs_put_record;
1140: ------------------------------------------------------------------------------
1141: --
1142: -- EVS_MAG_REPORT_MAIN

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

1231: l_all_count := 0;
1232: l_header := 0;
1233: l_gre_count := 0;
1234:
1235: hr_utility.set_location('Entering:' || l_proc,10);
1236: --
1237: -- GET UTL_FILE_DIR
1238: --
1239: OPEN csr_valid_profile;

Line 1243: hr_utility.trace('l_valid_profile : ' || l_valid_profile);

1239: OPEN csr_valid_profile;
1240: FETCH csr_valid_profile INTO l_valid_profile;
1241: if csr_valid_profile%FOUND then
1242: close csr_valid_profile;
1243: hr_utility.trace('l_valid_profile : ' || l_valid_profile);
1244: l_path := GET_ROOT_DIR(l_valid_profile);
1245: hr_utility.trace('UTL_FILE_DIR : ' || l_path );
1246: else
1247: null;

Line 1245: hr_utility.trace('UTL_FILE_DIR : ' || l_path );

1241: if csr_valid_profile%FOUND then
1242: close csr_valid_profile;
1243: hr_utility.trace('l_valid_profile : ' || l_valid_profile);
1244: l_path := GET_ROOT_DIR(l_valid_profile);
1245: hr_utility.trace('UTL_FILE_DIR : ' || l_path );
1246: else
1247: null;
1248: close csr_valid_profile;
1249: end if;

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

1247: null;
1248: close csr_valid_profile;
1249: end if;
1250: --
1251: hr_utility.set_location(l_proc,20);
1252:
1253: if p_start_date is null then
1254: l_start_date := fnd_date.canonical_to_date(to_char(sysdate,'YYYY/MM/DD'));
1255: else

Line 1271: hr_utility.trace('l_start_date = ' || l_start_date);

1267: else
1268: l_media_type := p_media_type;
1269: end if;
1270:
1271: hr_utility.trace('l_start_date = ' || l_start_date);
1272: hr_utility.trace('l_end_date = ' || l_end_date);
1273: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
1274: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
1275: hr_utility.trace('p_report_category = ' || p_report_category);

Line 1272: hr_utility.trace('l_end_date = ' || l_end_date);

1268: l_media_type := p_media_type;
1269: end if;
1270:
1271: hr_utility.trace('l_start_date = ' || l_start_date);
1272: hr_utility.trace('l_end_date = ' || l_end_date);
1273: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
1274: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
1275: hr_utility.trace('p_report_category = ' || p_report_category);
1276: hr_utility.trace('p_media_type = ' || l_media_type);

Line 1273: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);

1269: end if;
1270:
1271: hr_utility.trace('l_start_date = ' || l_start_date);
1272: hr_utility.trace('l_end_date = ' || l_end_date);
1273: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
1274: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
1275: hr_utility.trace('p_report_category = ' || p_report_category);
1276: hr_utility.trace('p_media_type = ' || l_media_type);
1277:

Line 1274: hr_utility.trace('p_business_group_id = ' || p_business_group_id);

1270:
1271: hr_utility.trace('l_start_date = ' || l_start_date);
1272: hr_utility.trace('l_end_date = ' || l_end_date);
1273: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
1274: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
1275: hr_utility.trace('p_report_category = ' || p_report_category);
1276: hr_utility.trace('p_media_type = ' || l_media_type);
1277:
1278:

Line 1275: hr_utility.trace('p_report_category = ' || p_report_category);

1271: hr_utility.trace('l_start_date = ' || l_start_date);
1272: hr_utility.trace('l_end_date = ' || l_end_date);
1273: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
1274: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
1275: hr_utility.trace('p_report_category = ' || p_report_category);
1276: hr_utility.trace('p_media_type = ' || l_media_type);
1277:
1278:
1279: if p_tax_unit_id is not NULL then

Line 1276: hr_utility.trace('p_media_type = ' || l_media_type);

1272: hr_utility.trace('l_end_date = ' || l_end_date);
1273: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
1274: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
1275: hr_utility.trace('p_report_category = ' || p_report_category);
1276: hr_utility.trace('p_media_type = ' || l_media_type);
1277:
1278:
1279: if p_tax_unit_id is not NULL then
1280:

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

1277:
1278:
1279: if p_tax_unit_id is not NULL then
1280:
1281: hr_utility.set_location(l_proc,30);
1282:
1283: open csr_get_org_info;
1284: fetch csr_get_org_info into l_requester_id_code
1285: ,l_user_control_data

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

1296: else
1297: close csr_get_org_info;
1298: end if;
1299:
1300: hr_utility.set_location(l_proc,40);
1301:
1302: hr_utility.trace('l_requestoer_id_code = ' || l_requester_id_code);
1303: hr_utility.trace('l_user_control_data = ' || l_user_control_data);
1304: hr_utility.trace('p_report_category = ' || p_report_category);

Line 1302: hr_utility.trace('l_requestoer_id_code = ' || l_requester_id_code);

1298: end if;
1299:
1300: hr_utility.set_location(l_proc,40);
1301:
1302: hr_utility.trace('l_requestoer_id_code = ' || l_requester_id_code);
1303: hr_utility.trace('l_user_control_data = ' || l_user_control_data);
1304: hr_utility.trace('p_report_category = ' || p_report_category);
1305:
1306: --

Line 1303: hr_utility.trace('l_user_control_data = ' || l_user_control_data);

1299:
1300: hr_utility.set_location(l_proc,40);
1301:
1302: hr_utility.trace('l_requestoer_id_code = ' || l_requester_id_code);
1303: hr_utility.trace('l_user_control_data = ' || l_user_control_data);
1304: hr_utility.trace('p_report_category = ' || p_report_category);
1305:
1306: --
1307: -- File Open

Line 1304: hr_utility.trace('p_report_category = ' || p_report_category);

1300: hr_utility.set_location(l_proc,40);
1301:
1302: hr_utility.trace('l_requestoer_id_code = ' || l_requester_id_code);
1303: hr_utility.trace('l_user_control_data = ' || l_user_control_data);
1304: hr_utility.trace('p_report_category = ' || p_report_category);
1305:
1306: --
1307: -- File Open
1308: --

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

1321: ,p_media_type => l_media_type
1322: ,p_gre_count => l_gre_count
1323: );
1324:
1325: hr_utility.set_location(l_proc,50);
1326: utl_file.fclose(g_file_id);
1327: if l_header = 0 then
1328: fnd_file.put_line
1329: (which => fnd_file.log

Line 1359: hr_utility.set_location(l_proc,60);

1355: (which => fnd_file.log
1356: ,buff => ' '
1357: );
1358: else
1359: hr_utility.set_location(l_proc,60);
1360: --
1361: -- GRE parameter is blank
1362: --
1363:

Line 1390: hr_utility.set_location(l_proc,70);

1386: ,p_media_type => l_media_type
1387: ,p_gre_count => l_gre_count
1388: );
1389:
1390: hr_utility.set_location(l_proc,70);
1391:
1392: if l_header = 0 then
1393: fnd_file.put_line
1394: (which => fnd_file.log

Line 1415: hr_utility.set_location(l_proc,71);

1411: ,buff => ' ------------------- ------------- '
1412: );
1413: l_header := 1;
1414: end if;
1415: hr_utility.set_location(l_proc,71);
1416: fnd_file.put_line
1417: (which => fnd_file.log
1418: ,buff => ' ' || rpad(gre_record.name,20,' ') ||
1419: ' ' || to_char(l_gre_count)

Line 1423: hr_utility.set_location(l_proc,72);

1419: ' ' || to_char(l_gre_count)
1420: );
1421: l_all_count := l_all_count + l_gre_count;
1422: END LOOP;
1423: hr_utility.set_location(l_proc,72);
1424: fnd_file.put_line
1425: (which => fnd_file.log
1426: ,buff => ' ' || rpad('ALL GREs',20,' ') ||
1427: ' ' || to_char(l_all_count)

Line 1434: hr_utility.set_location(l_proc,74);

1430: (which => fnd_file.log
1431: ,buff => ' '
1432: );
1433: -- utl_file.fclose(g_file_id); -- 08-JUL-2005
1434: hr_utility.set_location(l_proc,74);
1435: end if;
1436: hr_utility.set_location('Leaving..: ' || l_proc,100);
1437:
1438: EXCEPTION

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

1432: );
1433: -- utl_file.fclose(g_file_id); -- 08-JUL-2005
1434: hr_utility.set_location(l_proc,74);
1435: end if;
1436: hr_utility.set_location('Leaving..: ' || l_proc,100);
1437:
1438: EXCEPTION
1439: WHEN OTHERS THEN
1440: hr_utility.set_location(l_proc || substr(sqlerrm,1,50),999);

Line 1440: hr_utility.set_location(l_proc || substr(sqlerrm,1,50),999);

1436: hr_utility.set_location('Leaving..: ' || l_proc,100);
1437:
1438: EXCEPTION
1439: WHEN OTHERS THEN
1440: hr_utility.set_location(l_proc || substr(sqlerrm,1,50),999);
1441: fnd_file.put_line(fnd_file.log,SQLERRM);
1442: RAISE;
1443:
1444: end evs_mag_report_main;