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: -- Bug # 8528862
1063: -- F_EVS_REM_SPL_CHAR

Line 1073: hr_utility.trace('Original string passed : ' || p_input_string);

1069:
1070: ls_output_string VARCHAR2(100);
1071:
1072: BEGIN
1073: hr_utility.trace('Original string passed : ' || p_input_string);
1074: ls_output_string := translate(p_input_string,'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz''. -0123456789',
1075: 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz');
1076: hr_utility.trace('String returned : ' || ls_output_string);
1077: RETURN ls_output_string;

Line 1076: hr_utility.trace('String returned : ' || ls_output_string);

1072: BEGIN
1073: hr_utility.trace('Original string passed : ' || p_input_string);
1074: ls_output_string := translate(p_input_string,'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz''. -0123456789',
1075: 'ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz');
1076: hr_utility.trace('String returned : ' || ls_output_string);
1077: RETURN ls_output_string;
1078: EXCEPTION
1079: WHEN OTHERS THEN
1080: RETURN p_input_string;

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

1104: l_multiple_req_indicator varchar2(3);
1105:
1106: begin
1107: l_proc := g_package || 'evs_put_record';
1108: hr_utility.set_location('Entering : ' || l_proc,10);
1109:
1110: if p_multiple_req_indicator = 0 then
1111: l_multiple_req_indicator := ' ';
1112: else

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

1144: || rpad(nvl(l_multiple_req_indicator,' '),3,' ')
1145: --
1146: || l_delimiter -- BUG4447245
1147: ;
1148: hr_utility.trace('l_buff = ' || l_buff);
1149:
1150: fnd_file.put_line
1151: (which => fnd_file.output
1152: ,buff => l_buff

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

1154:
1155: utl_file.put(g_file_id,l_buff);
1156: utl_file.fflush(g_file_id); -- XXXXX
1157:
1158: hr_utility.set_location('Leavning : ' || l_proc,100);
1159: end evs_put_record;
1160: ------------------------------------------------------------------------------
1161: --
1162: -- EVS_MAG_REPORT_MAIN

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

1251: l_all_count := 0;
1252: l_header := 0;
1253: l_gre_count := 0;
1254:
1255: hr_utility.set_location('Entering:' || l_proc,10);
1256: --
1257: -- GET UTL_FILE_DIR
1258: --
1259: OPEN csr_valid_profile;

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

1259: OPEN csr_valid_profile;
1260: FETCH csr_valid_profile INTO l_valid_profile;
1261: if csr_valid_profile%FOUND then
1262: close csr_valid_profile;
1263: hr_utility.trace('l_valid_profile : ' || l_valid_profile);
1264: l_path := GET_ROOT_DIR(l_valid_profile);
1265: hr_utility.trace('UTL_FILE_DIR : ' || l_path );
1266: else
1267: null;

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

1261: if csr_valid_profile%FOUND then
1262: close csr_valid_profile;
1263: hr_utility.trace('l_valid_profile : ' || l_valid_profile);
1264: l_path := GET_ROOT_DIR(l_valid_profile);
1265: hr_utility.trace('UTL_FILE_DIR : ' || l_path );
1266: else
1267: null;
1268: close csr_valid_profile;
1269: end if;

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

1267: null;
1268: close csr_valid_profile;
1269: end if;
1270: --
1271: hr_utility.set_location(l_proc,20);
1272:
1273: if p_start_date is null then
1274: l_start_date := fnd_date.canonical_to_date(to_char(sysdate,'YYYY/MM/DD'));
1275: else

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

1287: else
1288: l_media_type := p_media_type;
1289: end if;
1290:
1291: hr_utility.trace('l_start_date = ' || l_start_date);
1292: hr_utility.trace('l_end_date = ' || l_end_date);
1293: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
1294: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
1295: hr_utility.trace('p_report_category = ' || p_report_category);

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

1288: l_media_type := p_media_type;
1289: end if;
1290:
1291: hr_utility.trace('l_start_date = ' || l_start_date);
1292: hr_utility.trace('l_end_date = ' || l_end_date);
1293: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
1294: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
1295: hr_utility.trace('p_report_category = ' || p_report_category);
1296: hr_utility.trace('p_media_type = ' || l_media_type);

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

1289: end if;
1290:
1291: hr_utility.trace('l_start_date = ' || l_start_date);
1292: hr_utility.trace('l_end_date = ' || l_end_date);
1293: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
1294: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
1295: hr_utility.trace('p_report_category = ' || p_report_category);
1296: hr_utility.trace('p_media_type = ' || l_media_type);
1297:

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

1290:
1291: hr_utility.trace('l_start_date = ' || l_start_date);
1292: hr_utility.trace('l_end_date = ' || l_end_date);
1293: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
1294: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
1295: hr_utility.trace('p_report_category = ' || p_report_category);
1296: hr_utility.trace('p_media_type = ' || l_media_type);
1297:
1298:

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

1291: hr_utility.trace('l_start_date = ' || l_start_date);
1292: hr_utility.trace('l_end_date = ' || l_end_date);
1293: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
1294: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
1295: hr_utility.trace('p_report_category = ' || p_report_category);
1296: hr_utility.trace('p_media_type = ' || l_media_type);
1297:
1298:
1299: if p_tax_unit_id is not NULL then

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

1292: hr_utility.trace('l_end_date = ' || l_end_date);
1293: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
1294: hr_utility.trace('p_business_group_id = ' || p_business_group_id);
1295: hr_utility.trace('p_report_category = ' || p_report_category);
1296: hr_utility.trace('p_media_type = ' || l_media_type);
1297:
1298:
1299: if p_tax_unit_id is not NULL then
1300:

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

1297:
1298:
1299: if p_tax_unit_id is not NULL then
1300:
1301: hr_utility.set_location(l_proc,30);
1302:
1303: open csr_get_org_info;
1304: fetch csr_get_org_info into l_requester_id_code
1305: ,l_user_control_data

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

1316: else
1317: close csr_get_org_info;
1318: end if;
1319:
1320: hr_utility.set_location(l_proc,40);
1321:
1322: hr_utility.trace('l_requestoer_id_code = ' || l_requester_id_code);
1323: hr_utility.trace('l_user_control_data = ' || l_user_control_data);
1324: hr_utility.trace('p_report_category = ' || p_report_category);

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

1318: end if;
1319:
1320: hr_utility.set_location(l_proc,40);
1321:
1322: hr_utility.trace('l_requestoer_id_code = ' || l_requester_id_code);
1323: hr_utility.trace('l_user_control_data = ' || l_user_control_data);
1324: hr_utility.trace('p_report_category = ' || p_report_category);
1325:
1326: --

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

1319:
1320: hr_utility.set_location(l_proc,40);
1321:
1322: hr_utility.trace('l_requestoer_id_code = ' || l_requester_id_code);
1323: hr_utility.trace('l_user_control_data = ' || l_user_control_data);
1324: hr_utility.trace('p_report_category = ' || p_report_category);
1325:
1326: --
1327: -- File Open

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

1320: hr_utility.set_location(l_proc,40);
1321:
1322: hr_utility.trace('l_requestoer_id_code = ' || l_requester_id_code);
1323: hr_utility.trace('l_user_control_data = ' || l_user_control_data);
1324: hr_utility.trace('p_report_category = ' || p_report_category);
1325:
1326: --
1327: -- File Open
1328: --

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

1341: ,p_media_type => l_media_type
1342: ,p_gre_count => l_gre_count
1343: );
1344:
1345: hr_utility.set_location(l_proc,50);
1346: utl_file.fclose(g_file_id);
1347: if l_header = 0 then
1348: fnd_file.put_line
1349: (which => fnd_file.log

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

1375: (which => fnd_file.log
1376: ,buff => ' '
1377: );
1378: else
1379: hr_utility.set_location(l_proc,60);
1380: --
1381: -- GRE parameter is blank
1382: --
1383:

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

1406: ,p_media_type => l_media_type
1407: ,p_gre_count => l_gre_count
1408: );
1409:
1410: hr_utility.set_location(l_proc,70);
1411:
1412: if l_header = 0 then
1413: fnd_file.put_line
1414: (which => fnd_file.log

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

1431: ,buff => ' ------------------- ------------- '
1432: );
1433: l_header := 1;
1434: end if;
1435: hr_utility.set_location(l_proc,71);
1436: fnd_file.put_line
1437: (which => fnd_file.log
1438: ,buff => ' ' || rpad(gre_record.name,20,' ') ||
1439: ' ' || to_char(l_gre_count)

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

1439: ' ' || to_char(l_gre_count)
1440: );
1441: l_all_count := l_all_count + l_gre_count;
1442: END LOOP;
1443: hr_utility.set_location(l_proc,72);
1444: fnd_file.put_line
1445: (which => fnd_file.log
1446: ,buff => ' ' || rpad('ALL GREs',20,' ') ||
1447: ' ' || to_char(l_all_count)

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

1450: (which => fnd_file.log
1451: ,buff => ' '
1452: );
1453: -- utl_file.fclose(g_file_id); -- 08-JUL-2005
1454: hr_utility.set_location(l_proc,74);
1455: end if;
1456: hr_utility.set_location('Leaving..: ' || l_proc,100);
1457:
1458: EXCEPTION

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

1452: );
1453: -- utl_file.fclose(g_file_id); -- 08-JUL-2005
1454: hr_utility.set_location(l_proc,74);
1455: end if;
1456: hr_utility.set_location('Leaving..: ' || l_proc,100);
1457:
1458: EXCEPTION
1459: WHEN OTHERS THEN
1460: hr_utility.set_location(l_proc || substr(sqlerrm,1,50),999);

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

1456: hr_utility.set_location('Leaving..: ' || l_proc,100);
1457:
1458: EXCEPTION
1459: WHEN OTHERS THEN
1460: hr_utility.set_location(l_proc || substr(sqlerrm,1,50),999);
1461: fnd_file.put_line(fnd_file.log,SQLERRM);
1462: RAISE;
1463:
1464: end evs_mag_report_main;