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

Line 135: ------hr_utility.trace('Into fill_table get_data emp no '||p_employee_number||' BG ID '||to_char(p_bg_id)||' Date '||to_char(p_effective_date));

131: lc_trg_addr c_trg_addr%ROWTYPE;
132: l_naf_meaning varchar2(40);
133: begin
134:
135: ------hr_utility.trace('Into fill_table get_data emp no '||p_employee_number||' BG ID '||to_char(p_bg_id)||' Date '||to_char(p_effective_date));
136:
137: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'report_date';
138: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := to_char(sysdate,'YYYY-MM-DD');
139: vCtr:=vCtr+1;

Line 155: ------hr_utility.trace('Into cursor '||p_employee_number);

151:
152: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'FLAG';
153: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := '1';
154: vCtr:=vCtr+1;
155: ------hr_utility.trace('Into cursor '||p_employee_number);
156: for l_c_get_lookup in c_get_lookup ----From Lookup BIAF_LOOKUP_CODE --
157: loop
158:
159:

Line 168: ------------hr_utility.trace('Into fill_table get_data emp no '||(p_employee_number));

164:
165: end loop; ---Label of the template
166:
167:
168: ------------hr_utility.trace('Into fill_table get_data emp no '||(p_employee_number));
169: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'employee_number';
170: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := p_employee_number;
171: vCtr:=vCtr+1;
172:

Line 301: hr_utility.trace('Establishment Headcount ');

297: lp_udt_column => 'INCLUDE_DUE'
298: -- lp_include_suspended =>'Y'
299: ));
300: vCtr:=vCtr+1;
301: hr_utility.trace('Establishment Headcount ');
302:
303: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'establishment_name';
304: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (l_cursor_get_data.establishment_name);
305: vCtr:=vCtr+1;

Line 369: hr_utility.trace('Training Address ');

365:
366: open c_trg_addr(l_cursor_get_data.trg_bd_id, p_bg_id);
367: fetch c_trg_addr into lc_trg_addr;
368:
369: hr_utility.trace('Training Address ');
370:
371: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagName := 'tax_paid_to';
372: PER_FR_BIAF_REPORT.vXMLTable(vCtr).TagValue := (lc_trg_addr.trg_bd_name);
373: vCtr:=vCtr+1;

Line 658: --hr_utility.trace_on(null,'BIAF1');

654: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));
655:
656:
657:
658: --hr_utility.trace_on(null,'BIAF1');
659: PER_FR_BIAF_REPORT.vXMLTable.DELETE;
660: vCtr:=0;
661:
662: hr_utility.TRACE('Effective Date ' || to_char(l_effective_date));

Line 662: hr_utility.TRACE('Effective Date ' || to_char(l_effective_date));

658: --hr_utility.trace_on(null,'BIAF1');
659: PER_FR_BIAF_REPORT.vXMLTable.DELETE;
660: vCtr:=0;
661:
662: hr_utility.TRACE('Effective Date ' || to_char(l_effective_date));
663: ------hr_utility.TRACE('Business Group ID ' || p_bg_id);
664: ------hr_utility.TRACE('Assignment Or Employee ' || p_asg_emp);
665:
666:

Line 663: ------hr_utility.TRACE('Business Group ID ' || p_bg_id);

659: PER_FR_BIAF_REPORT.vXMLTable.DELETE;
660: vCtr:=0;
661:
662: hr_utility.TRACE('Effective Date ' || to_char(l_effective_date));
663: ------hr_utility.TRACE('Business Group ID ' || p_bg_id);
664: ------hr_utility.TRACE('Assignment Or Employee ' || p_asg_emp);
665:
666:
667: if (p_asg_emp='A') then

Line 664: ------hr_utility.TRACE('Assignment Or Employee ' || p_asg_emp);

660: vCtr:=0;
661:
662: hr_utility.TRACE('Effective Date ' || to_char(l_effective_date));
663: ------hr_utility.TRACE('Business Group ID ' || p_bg_id);
664: ------hr_utility.TRACE('Assignment Or Employee ' || p_asg_emp);
665:
666:
667: if (p_asg_emp='A') then
668:

Line 678: ------hr_utility.TRACE('Inside assignment Set ' );

674:
675: if (l_c_asg_amendments.ioe='I' /*and l_c_asg_amendments.cnt > 0*/) then
676: for l_c_asg_set in c_asg_set1(p_asg_id,p_bg_id,l_effective_date) ----Assignment Set Loop
677: loop
678: ------hr_utility.TRACE('Inside assignment Set ' );
679:
680: hr_utility.TRACE('Employee Number ' || to_char(l_c_asg_set.employee_number));
681: fill_table(l_c_asg_set.employee_number,p_bg_id,p_asg_id,l_effective_date);
682:

Line 680: hr_utility.TRACE('Employee Number ' || to_char(l_c_asg_set.employee_number));

676: for l_c_asg_set in c_asg_set1(p_asg_id,p_bg_id,l_effective_date) ----Assignment Set Loop
677: loop
678: ------hr_utility.TRACE('Inside assignment Set ' );
679:
680: hr_utility.TRACE('Employee Number ' || to_char(l_c_asg_set.employee_number));
681: fill_table(l_c_asg_set.employee_number,p_bg_id,p_asg_id,l_effective_date);
682:
683: end loop ; ----For Assignment Set
684: end if;

Line 690: ------hr_utility.TRACE('Inside assignment Set ' );

686: if (l_c_asg_amendments.ioe='E' /* and l_c_asg_amendments.cnt > 0*/) then
687:
688: for l_c_asg_set in c_asg_set2(p_asg_id,p_bg_id,l_effective_date) ----Assignment Set Loop
689: loop
690: ------hr_utility.TRACE('Inside assignment Set ' );
691:
692: hr_utility.TRACE('Employee Number2 ' || to_char(l_c_asg_set.employee_number));
693: fill_table(l_c_asg_set.employee_number,p_bg_id,p_asg_id,l_effective_date);
694:

Line 692: hr_utility.TRACE('Employee Number2 ' || to_char(l_c_asg_set.employee_number));

688: for l_c_asg_set in c_asg_set2(p_asg_id,p_bg_id,l_effective_date) ----Assignment Set Loop
689: loop
690: ------hr_utility.TRACE('Inside assignment Set ' );
691:
692: hr_utility.TRACE('Employee Number2 ' || to_char(l_c_asg_set.employee_number));
693: fill_table(l_c_asg_set.employee_number,p_bg_id,p_asg_id,l_effective_date);
694:
695: end loop ; ----For Assignment Set
696: end if;

Line 702: ------hr_utility.TRACE('Inside assignment Set ' );

698:
699: else ---- No amendment is mentioned
700: for l_c_asg_set in c_asg_set2(p_asg_id,p_bg_id,l_effective_date) ----Assignment Set Loop
701: loop
702: ------hr_utility.TRACE('Inside assignment Set ' );
703:
704: hr_utility.TRACE('Employee Number3 ' || to_char(l_c_asg_set.employee_number));
705: fill_table(l_c_asg_set.employee_number,p_bg_id,p_asg_id,l_effective_date);
706:

Line 704: hr_utility.TRACE('Employee Number3 ' || to_char(l_c_asg_set.employee_number));

700: for l_c_asg_set in c_asg_set2(p_asg_id,p_bg_id,l_effective_date) ----Assignment Set Loop
701: loop
702: ------hr_utility.TRACE('Inside assignment Set ' );
703:
704: hr_utility.TRACE('Employee Number3 ' || to_char(l_c_asg_set.employee_number));
705: fill_table(l_c_asg_set.employee_number,p_bg_id,p_asg_id,l_effective_date);
706:
707: end loop ; ----For Assignment Set
708: end if;

Line 712: hr_utility.TRACE('Employee Number4 ' || to_char(p_employee_number));

708: end if;
709:
710: close c_asg_amendments;
711: else
712: hr_utility.TRACE('Employee Number4 ' || to_char(p_employee_number));
713: fill_table(p_employee_number,p_bg_id,p_asg_id,l_effective_date);
714:
715: end if;
716:

Line 717: --hr_utility.TRACE('Counter ' || (vCtr));

713: fill_table(p_employee_number,p_bg_id,p_asg_id,l_effective_date);
714:
715: end if;
716:
717: --hr_utility.TRACE('Counter ' || (vCtr));
718:
719: PER_FR_BIAF_REPORT.WritetoCLOB (p_xfdf_blob );
720:
721:

Line 742: ----------hr_utility.set_location('Entered Procedure Write to clob ',100);

738: l_str8 varchar2(1000);
739: l_str9 varchar2(1000);
740: l_boo number :=1;
741: begin
742: ----------hr_utility.set_location('Entered Procedure Write to clob ',100);
743: l_str1 := '
744: ';
745: -- ' ;
746: l_str2 := '<';

Line 756: ----hr_utility.TRACE('TAble count :'||(vXMLTable.count));

752:
753: ';
754: dbms_lob.createtemporary(l_xfdf_string,FALSE,DBMS_LOB.CALL);
755: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
756: ----hr_utility.TRACE('TAble count :'||(vXMLTable.count));
757: if vXMLTable.count > 2 then
758: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
759: --hr_utility.trace(l_str1);
760: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP

Line 759: --hr_utility.trace(l_str1);

755: dbms_lob.open(l_xfdf_string,dbms_lob.lob_readwrite);
756: ----hr_utility.TRACE('TAble count :'||(vXMLTable.count));
757: if vXMLTable.count > 2 then
758: dbms_lob.writeAppend( l_xfdf_string, length(l_str1), l_str1 );
759: --hr_utility.trace(l_str1);
760: FOR ctr_table IN vXMLTable.FIRST .. vXMLTable.LAST LOOP
761: l_str8 := vXMLTable(ctr_table).TagName;
762: l_str9 := vXMLTable(ctr_table).TagValue;
763:

Line 770: --hr_utility.trace(l_str2||l_str8||l_str3);

766: IF (l_boo=1) THEN
767: dbms_lob.writeAppend( l_xfdf_string, length(l_str2), l_str2 );--- <
768: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);------ name
769: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );---->
770: --hr_utility.trace(l_str2||l_str8||l_str3);
771: ELSE
772: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );---- 773: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);----- name
774: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );----- >

Line 775: --hr_utility.trace(l_str5||l_str8||l_str3);

771: ELSE
772: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );---- 773: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);----- name
774: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );----- >
775: --hr_utility.trace(l_str5||l_str8||l_str3);
776: END IF;
777: l_boo:=l_boo*(-1);
778: END IF;
779:

Line 790: --hr_utility.trace(l_str2||l_str8||l_str3||l_str9||l_str5||l_str8||l_str3);

786: dbms_lob.writeAppend( l_xfdf_string, length(l_str9), l_str9);-----value
787: dbms_lob.writeAppend( l_xfdf_string, length(l_str5), l_str5 );---- 788: dbms_lob.writeAppend( l_xfdf_string, length(l_str8),l_str8);----- name
789: dbms_lob.writeAppend( l_xfdf_string, length(l_str3), l_str3 );----- >
790: --hr_utility.trace(l_str2||l_str8||l_str3||l_str9||l_str5||l_str8||l_str3);
791: else
792: null;
793: end if;
794:

Line 797: --hr_utility.trace(l_str6);

793: end if;
794:
795: END LOOP;
796: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
797: --hr_utility.trace(l_str6);
798: else
799: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
800: --hr_utility.trace(l_str7);
801: end if;

Line 800: --hr_utility.trace(l_str7);

796: dbms_lob.writeAppend( l_xfdf_string, length(l_str6), l_str6 );
797: --hr_utility.trace(l_str6);
798: else
799: dbms_lob.writeAppend( l_xfdf_string, length(l_str7), l_str7 );
800: --hr_utility.trace(l_str7);
801: end if;
802: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
803: clob_to_blob(l_xfdf_string,p_xfdf_blob);
804: ----hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);

Line 804: ----hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);

800: --hr_utility.trace(l_str7);
801: end if;
802: DBMS_LOB.CREATETEMPORARY(p_xfdf_blob,TRUE);
803: clob_to_blob(l_xfdf_string,p_xfdf_blob);
804: ----hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
805: --return p_xfdf_blob;
806: EXCEPTION
807: WHEN OTHERS then
808: ----hr_utility.TRACE('sqleerm ' || SQLERRM);

Line 808: ----hr_utility.TRACE('sqleerm ' || SQLERRM);

804: ----hr_utility.set_location('Finished Procedure Write to CLOB ,Before clob to blob ',110);
805: --return p_xfdf_blob;
806: EXCEPTION
807: WHEN OTHERS then
808: ----hr_utility.TRACE('sqleerm ' || SQLERRM);
809: ----hr_utility.RAISE_ERROR;
810: null;
811: END WritetoCLOB;
812:

Line 809: ----hr_utility.RAISE_ERROR;

805: --return p_xfdf_blob;
806: EXCEPTION
807: WHEN OTHERS then
808: ----hr_utility.TRACE('sqleerm ' || SQLERRM);
809: ----hr_utility.RAISE_ERROR;
810: null;
811: END WritetoCLOB;
812:
813:

Line 831: hr_utility.set_location('Entered Procedure clob to blob',120);

827: l_raw_buffer_len pls_integer;
828: l_blob_offset pls_integer := 1;
829:
830: begin
831: hr_utility.set_location('Entered Procedure clob to blob',120);
832: select userenv('LANGUAGE') into g_nls_db_char from dual;
833: l_length_clob := dbms_lob.getlength(p_clob);
834: l_offset := 1;
835: while l_length_clob > 0 loop

Line 836: hr_utility.trace('l_length_clob '|| l_length_clob);

832: select userenv('LANGUAGE') into g_nls_db_char from dual;
833: l_length_clob := dbms_lob.getlength(p_clob);
834: l_offset := 1;
835: while l_length_clob > 0 loop
836: hr_utility.trace('l_length_clob '|| l_length_clob);
837: if l_length_clob < l_buffer_len then
838: l_chunk_len := l_length_clob;
839: else
840: l_chunk_len := l_buffer_len;

Line 855: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));

851: --fnd_file.put_line(fnd_file.log,l_varchar_buffer);
852: l_blob_offset := l_blob_offset + l_raw_buffer_len;
853: l_offset := l_offset + l_chunk_len;
854: l_length_clob := l_length_clob - l_chunk_len;
855: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));
856: end loop;
857: hr_utility.set_location('Finished Procedure clob to blob ',130);
858: end;
859:

Line 857: hr_utility.set_location('Finished Procedure clob to blob ',130);

853: l_offset := l_offset + l_chunk_len;
854: l_length_clob := l_length_clob - l_chunk_len;
855: hr_utility.trace('l_length_blob '|| dbms_lob.getlength(p_blob));
856: end loop;
857: hr_utility.set_location('Finished Procedure clob to blob ',130);
858: end;
859:
860:
861: end PER_FR_BIAF_REPORT;