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

Line 106: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);

102:
103: lv_format varchar2(32000);
104:
105: BEGIN
106: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);
107:
108: if p_output_file_type = 'CSV' then
109:
110:

Line 111: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);

107:
108: if p_output_file_type = 'CSV' then
109:
110:
111: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);
112:
113: lv_format := gc_csv_data_delimiter || p_input_string ||
114: gc_csv_data_delimiter || gc_csv_delimiter;
115:

Line 129: hr_utility.set_location(gv_package_name || '.formated_data_string', 30);

125:
126: end if;
127:
128: if p_input_string is null then
129: hr_utility.set_location(gv_package_name || '.formated_data_string', 30);
130: lv_format := gv_html_start_data || ' ' || gv_html_end_data;
131: else
132: if p_bold = 'Y' then
133: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);

Line 133: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);

129: hr_utility.set_location(gv_package_name || '.formated_data_string', 30);
130: lv_format := gv_html_start_data || ' ' || gv_html_end_data;
131: else
132: if p_bold = 'Y' then
133: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);
134: lv_format := gv_html_start_data || ' ' || p_input_string
135: || '' || gv_html_end_data;
136: else
137: hr_utility.set_location(gv_package_name || '.formated_data_string', 50);

Line 137: hr_utility.set_location(gv_package_name || '.formated_data_string', 50);

133: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);
134: lv_format := gv_html_start_data || ' ' || p_input_string
135: || '' || gv_html_end_data;
136: else
137: hr_utility.set_location(gv_package_name || '.formated_data_string', 50);
138: lv_format := gv_html_start_data || p_input_string || gv_html_end_data;
139: end if;
140: end if;
141:

Line 144: hr_utility.set_location(gv_package_name || '.formated_data_string', 60);

140: end if;
141:
142: end if;
143:
144: hr_utility.set_location(gv_package_name || '.formated_data_string', 60);
145:
146: return lv_format;
147:
148: END formated_data_string;

Line 163: hr_utility.set_location(gv_package_name || '.formated_header_string', 10);

159:
160: lv_format varchar2(1000);
161:
162: BEGIN
163: hr_utility.set_location(gv_package_name || '.formated_header_string', 10);
164: if p_output_file_type = 'CSV' then
165: hr_utility.set_location(gv_package_name || '.formated_header_string', 20);
166: lv_format := p_input_string;
167: elsif p_output_file_type = 'HTML' then

Line 165: hr_utility.set_location(gv_package_name || '.formated_header_string', 20);

161:
162: BEGIN
163: hr_utility.set_location(gv_package_name || '.formated_header_string', 10);
164: if p_output_file_type = 'CSV' then
165: hr_utility.set_location(gv_package_name || '.formated_header_string', 20);
166: lv_format := p_input_string;
167: elsif p_output_file_type = 'HTML' then
168: hr_utility.set_location(gv_package_name || '.formated_header_string', 30);
169: lv_format := '

' || p_input_string ||

Line 168: hr_utility.set_location(gv_package_name || '.formated_header_string', 30);

164: if p_output_file_type = 'CSV' then
165: hr_utility.set_location(gv_package_name || '.formated_header_string', 20);
166: lv_format := p_input_string;
167: elsif p_output_file_type = 'HTML' then
168: hr_utility.set_location(gv_package_name || '.formated_header_string', 30);
169: lv_format := '
' || p_input_string ||
170: '
';
171: end if;
172:

Line 174: hr_utility.set_location(gv_package_name || '.formated_header_string', 40);

170: '

';
171: end if;
172:
173:
174: hr_utility.set_location(gv_package_name || '.formated_header_string', 40);
175: return lv_format;
176:
177: END formated_header_string;
178:

Line 199: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);

195: lv_format2 varchar2(32000);
196:
197: BEGIN
198:
199: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);
200: IF p_header = 'Header1' THEN
201:
202:
203: if p_report_type = 'PRW2EXCEPTION' then

Line 544: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);

540:
541:
542: BEGIN
543:
544: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);
545: hr_utility.trace('ER Name = '||p_tax_unit_name);
546: hr_utility.trace('EIN = '||p_ein);
547: hr_utility.trace('Year = '||p_year);
548: hr_utility.trace('EE Name = '||p_first_name);

Line 545: hr_utility.trace('ER Name = '||p_tax_unit_name);

541:
542: BEGIN
543:
544: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);
545: hr_utility.trace('ER Name = '||p_tax_unit_name);
546: hr_utility.trace('EIN = '||p_ein);
547: hr_utility.trace('Year = '||p_year);
548: hr_utility.trace('EE Name = '||p_first_name);
549: --5855662 Changed for employee file format

Line 546: hr_utility.trace('EIN = '||p_ein);

542: BEGIN
543:
544: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);
545: hr_utility.trace('ER Name = '||p_tax_unit_name);
546: hr_utility.trace('EIN = '||p_ein);
547: hr_utility.trace('Year = '||p_year);
548: hr_utility.trace('EE Name = '||p_first_name);
549: --5855662 Changed for employee file format
550: --7566756 Formatted p_ein

Line 547: hr_utility.trace('Year = '||p_year);

543:
544: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);
545: hr_utility.trace('ER Name = '||p_tax_unit_name);
546: hr_utility.trace('EIN = '||p_ein);
547: hr_utility.trace('Year = '||p_year);
548: hr_utility.trace('EE Name = '||p_first_name);
549: --5855662 Changed for employee file format
550: --7566756 Formatted p_ein
551: lv_format1 :=

Line 548: hr_utility.trace('EE Name = '||p_first_name);

544: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);
545: hr_utility.trace('ER Name = '||p_tax_unit_name);
546: hr_utility.trace('EIN = '||p_ein);
547: hr_utility.trace('Year = '||p_year);
548: hr_utility.trace('EE Name = '||p_first_name);
549: --5855662 Changed for employee file format
550: --7566756 Formatted p_ein
551: lv_format1 :=
552: formated_data_string (p_input_string => format_data(replace(p_ssn,'-',''),9)

Line 736: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);

732: formated_data_string (p_input_string => to_char(p_ee_health_coverage,'999,999,999,999,990.00')
733: ,p_type => 'N'
734: ,p_output_file_type => p_output_file_type); -- 13462230
735:
736: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
737:
738:
739: hr_utility.trace('Static Data1 = ' || lv_format1);
740: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);

Line 739: hr_utility.trace('Static Data1 = ' || lv_format1);

735:
736: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
737:
738:
739: hr_utility.trace('Static Data1 = ' || lv_format1);
740: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
741:
742: return (lv_format1);
743: END;

Line 740: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);

736: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
737:
738:
739: hr_utility.trace('Static Data1 = ' || lv_format1);
740: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
741:
742: return (lv_format1);
743: END;
744:

Line 906: -- hr_utility.trace_on(null, 'PRW2');

902: ln_count number(2);
903:
904: BEGIN
905:
906: -- hr_utility.trace_on(null, 'PRW2');
907: hr_utility.trace('Entered Main package');
908: hr_utility.trace('p_seq_num = '||p_seq_num);
909: hr_utility.trace('p_report_type = '||p_report_type);
910:

Line 907: hr_utility.trace('Entered Main package');

903:
904: BEGIN
905:
906: -- hr_utility.trace_on(null, 'PRW2');
907: hr_utility.trace('Entered Main package');
908: hr_utility.trace('p_seq_num = '||p_seq_num);
909: hr_utility.trace('p_report_type = '||p_report_type);
910:
911: /* report_type

Line 908: hr_utility.trace('p_seq_num = '||p_seq_num);

904: BEGIN
905:
906: -- hr_utility.trace_on(null, 'PRW2');
907: hr_utility.trace('Entered Main package');
908: hr_utility.trace('p_seq_num = '||p_seq_num);
909: hr_utility.trace('p_report_type = '||p_report_type);
910:
911: /* report_type
912: PRW2REGISTER - Register Report

Line 909: hr_utility.trace('p_report_type = '||p_report_type);

905:
906: -- hr_utility.trace_on(null, 'PRW2');
907: hr_utility.trace('Entered Main package');
908: hr_utility.trace('p_seq_num = '||p_seq_num);
909: hr_utility.trace('p_report_type = '||p_report_type);
910:
911: /* report_type
912: PRW2REGISTER - Register Report
913: PRW2TOTAL - Total Report

Line 932: hr_utility.trace ('Opened c_er_total cursor');

928:
929: i := 0;
930:
931: open c_er_total(p_seq_num,'PRW2REGISTER');
932: hr_utility.trace ('Opened c_er_total cursor');
933:
934: fetch c_er_total into er_name,
935: er_ein,
936: er_addr_line_1,

Line 968: hr_utility.trace('No total information found for seq num = '||p_seq_num);

964: ee_health_coverage;--13462230
965:
966: if c_er_total%NOTFOUND then
967:
968: hr_utility.trace('No total information found for seq num = '||p_seq_num);
969:
970: else
971:
972: er_name := replace(er_name,',');

Line 974: hr_utility.trace('wages ='||ee_wages);

970: else
971:
972: er_name := replace(er_name,',');
973:
974: hr_utility.trace('wages ='||ee_wages);
975: hr_utility.trace('commissions ='||ee_commissions);
976: hr_utility.trace('allowances ='||ee_allowances);
977: hr_utility.trace('tips ='||ee_tips);
978: hr_utility.trace('total ='||ee_total);

Line 975: hr_utility.trace('commissions ='||ee_commissions);

971:
972: er_name := replace(er_name,',');
973:
974: hr_utility.trace('wages ='||ee_wages);
975: hr_utility.trace('commissions ='||ee_commissions);
976: hr_utility.trace('allowances ='||ee_allowances);
977: hr_utility.trace('tips ='||ee_tips);
978: hr_utility.trace('total ='||ee_total);
979: hr_utility.trace('reimb ='||ee_reimb);

Line 976: hr_utility.trace('allowances ='||ee_allowances);

972: er_name := replace(er_name,',');
973:
974: hr_utility.trace('wages ='||ee_wages);
975: hr_utility.trace('commissions ='||ee_commissions);
976: hr_utility.trace('allowances ='||ee_allowances);
977: hr_utility.trace('tips ='||ee_tips);
978: hr_utility.trace('total ='||ee_total);
979: hr_utility.trace('reimb ='||ee_reimb);
980: hr_utility.trace('tax ='||ee_tax);

Line 977: hr_utility.trace('tips ='||ee_tips);

973:
974: hr_utility.trace('wages ='||ee_wages);
975: hr_utility.trace('commissions ='||ee_commissions);
976: hr_utility.trace('allowances ='||ee_allowances);
977: hr_utility.trace('tips ='||ee_tips);
978: hr_utility.trace('total ='||ee_total);
979: hr_utility.trace('reimb ='||ee_reimb);
980: hr_utility.trace('tax ='||ee_tax);
981: hr_utility.trace('ret_fund ='||ee_ret_fund);

Line 978: hr_utility.trace('total ='||ee_total);

974: hr_utility.trace('wages ='||ee_wages);
975: hr_utility.trace('commissions ='||ee_commissions);
976: hr_utility.trace('allowances ='||ee_allowances);
977: hr_utility.trace('tips ='||ee_tips);
978: hr_utility.trace('total ='||ee_total);
979: hr_utility.trace('reimb ='||ee_reimb);
980: hr_utility.trace('tax ='||ee_tax);
981: hr_utility.trace('ret_fund ='||ee_ret_fund);
982: hr_utility.trace('coda ='||ee_coda);

Line 979: hr_utility.trace('reimb ='||ee_reimb);

975: hr_utility.trace('commissions ='||ee_commissions);
976: hr_utility.trace('allowances ='||ee_allowances);
977: hr_utility.trace('tips ='||ee_tips);
978: hr_utility.trace('total ='||ee_total);
979: hr_utility.trace('reimb ='||ee_reimb);
980: hr_utility.trace('tax ='||ee_tax);
981: hr_utility.trace('ret_fund ='||ee_ret_fund);
982: hr_utility.trace('coda ='||ee_coda);
983: hr_utility.trace('ss_wages ='||ee_ss_wages);

Line 980: hr_utility.trace('tax ='||ee_tax);

976: hr_utility.trace('allowances ='||ee_allowances);
977: hr_utility.trace('tips ='||ee_tips);
978: hr_utility.trace('total ='||ee_total);
979: hr_utility.trace('reimb ='||ee_reimb);
980: hr_utility.trace('tax ='||ee_tax);
981: hr_utility.trace('ret_fund ='||ee_ret_fund);
982: hr_utility.trace('coda ='||ee_coda);
983: hr_utility.trace('ss_wages ='||ee_ss_wages);
984: hr_utility.trace('ss_Tax ='||ee_ss_Tax);

Line 981: hr_utility.trace('ret_fund ='||ee_ret_fund);

977: hr_utility.trace('tips ='||ee_tips);
978: hr_utility.trace('total ='||ee_total);
979: hr_utility.trace('reimb ='||ee_reimb);
980: hr_utility.trace('tax ='||ee_tax);
981: hr_utility.trace('ret_fund ='||ee_ret_fund);
982: hr_utility.trace('coda ='||ee_coda);
983: hr_utility.trace('ss_wages ='||ee_ss_wages);
984: hr_utility.trace('ss_Tax ='||ee_ss_Tax);
985: hr_utility.trace('ss_tips ='||ee_ss_tips);

Line 982: hr_utility.trace('coda ='||ee_coda);

978: hr_utility.trace('total ='||ee_total);
979: hr_utility.trace('reimb ='||ee_reimb);
980: hr_utility.trace('tax ='||ee_tax);
981: hr_utility.trace('ret_fund ='||ee_ret_fund);
982: hr_utility.trace('coda ='||ee_coda);
983: hr_utility.trace('ss_wages ='||ee_ss_wages);
984: hr_utility.trace('ss_Tax ='||ee_ss_Tax);
985: hr_utility.trace('ss_tips ='||ee_ss_tips);
986: hr_utility.trace('med_Wages ='||ee_med_Wages);

Line 983: hr_utility.trace('ss_wages ='||ee_ss_wages);

979: hr_utility.trace('reimb ='||ee_reimb);
980: hr_utility.trace('tax ='||ee_tax);
981: hr_utility.trace('ret_fund ='||ee_ret_fund);
982: hr_utility.trace('coda ='||ee_coda);
983: hr_utility.trace('ss_wages ='||ee_ss_wages);
984: hr_utility.trace('ss_Tax ='||ee_ss_Tax);
985: hr_utility.trace('ss_tips ='||ee_ss_tips);
986: hr_utility.trace('med_Wages ='||ee_med_Wages);
987: hr_utility.trace('med_tax ='||ee_med_tax);

Line 984: hr_utility.trace('ss_Tax ='||ee_ss_Tax);

980: hr_utility.trace('tax ='||ee_tax);
981: hr_utility.trace('ret_fund ='||ee_ret_fund);
982: hr_utility.trace('coda ='||ee_coda);
983: hr_utility.trace('ss_wages ='||ee_ss_wages);
984: hr_utility.trace('ss_Tax ='||ee_ss_Tax);
985: hr_utility.trace('ss_tips ='||ee_ss_tips);
986: hr_utility.trace('med_Wages ='||ee_med_Wages);
987: hr_utility.trace('med_tax ='||ee_med_tax);
988: hr_utility.trace('ss_tax_on_tips ='||ee_ss_tax_on_tips);

Line 985: hr_utility.trace('ss_tips ='||ee_ss_tips);

981: hr_utility.trace('ret_fund ='||ee_ret_fund);
982: hr_utility.trace('coda ='||ee_coda);
983: hr_utility.trace('ss_wages ='||ee_ss_wages);
984: hr_utility.trace('ss_Tax ='||ee_ss_Tax);
985: hr_utility.trace('ss_tips ='||ee_ss_tips);
986: hr_utility.trace('med_Wages ='||ee_med_Wages);
987: hr_utility.trace('med_tax ='||ee_med_tax);
988: hr_utility.trace('ss_tax_on_tips ='||ee_ss_tax_on_tips);
989: hr_utility.trace('med_tax_on_tips='||ee_med_tax_on_tips);

Line 986: hr_utility.trace('med_Wages ='||ee_med_Wages);

982: hr_utility.trace('coda ='||ee_coda);
983: hr_utility.trace('ss_wages ='||ee_ss_wages);
984: hr_utility.trace('ss_Tax ='||ee_ss_Tax);
985: hr_utility.trace('ss_tips ='||ee_ss_tips);
986: hr_utility.trace('med_Wages ='||ee_med_Wages);
987: hr_utility.trace('med_tax ='||ee_med_tax);
988: hr_utility.trace('ss_tax_on_tips ='||ee_ss_tax_on_tips);
989: hr_utility.trace('med_tax_on_tips='||ee_med_tax_on_tips);
990: hr_utility.trace('hire_act_wages='||ee_hire_act_wages); --10435466

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

983: hr_utility.trace('ss_wages ='||ee_ss_wages);
984: hr_utility.trace('ss_Tax ='||ee_ss_Tax);
985: hr_utility.trace('ss_tips ='||ee_ss_tips);
986: hr_utility.trace('med_Wages ='||ee_med_Wages);
987: hr_utility.trace('med_tax ='||ee_med_tax);
988: hr_utility.trace('ss_tax_on_tips ='||ee_ss_tax_on_tips);
989: hr_utility.trace('med_tax_on_tips='||ee_med_tax_on_tips);
990: hr_utility.trace('hire_act_wages='||ee_hire_act_wages); --10435466
991: hr_utility.trace('PR W2 Charitable Contributions='||ee_charitable_contributions); --13462230

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

984: hr_utility.trace('ss_Tax ='||ee_ss_Tax);
985: hr_utility.trace('ss_tips ='||ee_ss_tips);
986: hr_utility.trace('med_Wages ='||ee_med_Wages);
987: hr_utility.trace('med_tax ='||ee_med_tax);
988: hr_utility.trace('ss_tax_on_tips ='||ee_ss_tax_on_tips);
989: hr_utility.trace('med_tax_on_tips='||ee_med_tax_on_tips);
990: hr_utility.trace('hire_act_wages='||ee_hire_act_wages); --10435466
991: hr_utility.trace('PR W2 Charitable Contributions='||ee_charitable_contributions); --13462230
992: hr_utility.trace('PR W2 Contr To Save and Double Money='||ee_save_and_double_money); --13462230

Line 989: hr_utility.trace('med_tax_on_tips='||ee_med_tax_on_tips);

985: hr_utility.trace('ss_tips ='||ee_ss_tips);
986: hr_utility.trace('med_Wages ='||ee_med_Wages);
987: hr_utility.trace('med_tax ='||ee_med_tax);
988: hr_utility.trace('ss_tax_on_tips ='||ee_ss_tax_on_tips);
989: hr_utility.trace('med_tax_on_tips='||ee_med_tax_on_tips);
990: hr_utility.trace('hire_act_wages='||ee_hire_act_wages); --10435466
991: hr_utility.trace('PR W2 Charitable Contributions='||ee_charitable_contributions); --13462230
992: hr_utility.trace('PR W2 Contr To Save and Double Money='||ee_save_and_double_money); --13462230
993: hr_utility.trace('W2 Health Coverage='||ee_health_coverage); --13462230

Line 990: hr_utility.trace('hire_act_wages='||ee_hire_act_wages); --10435466

986: hr_utility.trace('med_Wages ='||ee_med_Wages);
987: hr_utility.trace('med_tax ='||ee_med_tax);
988: hr_utility.trace('ss_tax_on_tips ='||ee_ss_tax_on_tips);
989: hr_utility.trace('med_tax_on_tips='||ee_med_tax_on_tips);
990: hr_utility.trace('hire_act_wages='||ee_hire_act_wages); --10435466
991: hr_utility.trace('PR W2 Charitable Contributions='||ee_charitable_contributions); --13462230
992: hr_utility.trace('PR W2 Contr To Save and Double Money='||ee_save_and_double_money); --13462230
993: hr_utility.trace('W2 Health Coverage='||ee_health_coverage); --13462230
994:

Line 991: hr_utility.trace('PR W2 Charitable Contributions='||ee_charitable_contributions); --13462230

987: hr_utility.trace('med_tax ='||ee_med_tax);
988: hr_utility.trace('ss_tax_on_tips ='||ee_ss_tax_on_tips);
989: hr_utility.trace('med_tax_on_tips='||ee_med_tax_on_tips);
990: hr_utility.trace('hire_act_wages='||ee_hire_act_wages); --10435466
991: hr_utility.trace('PR W2 Charitable Contributions='||ee_charitable_contributions); --13462230
992: hr_utility.trace('PR W2 Contr To Save and Double Money='||ee_save_and_double_money); --13462230
993: hr_utility.trace('W2 Health Coverage='||ee_health_coverage); --13462230
994:
995:

Line 992: hr_utility.trace('PR W2 Contr To Save and Double Money='||ee_save_and_double_money); --13462230

988: hr_utility.trace('ss_tax_on_tips ='||ee_ss_tax_on_tips);
989: hr_utility.trace('med_tax_on_tips='||ee_med_tax_on_tips);
990: hr_utility.trace('hire_act_wages='||ee_hire_act_wages); --10435466
991: hr_utility.trace('PR W2 Charitable Contributions='||ee_charitable_contributions); --13462230
992: hr_utility.trace('PR W2 Contr To Save and Double Money='||ee_save_and_double_money); --13462230
993: hr_utility.trace('W2 Health Coverage='||ee_health_coverage); --13462230
994:
995:
996: i := i+1;

Line 993: hr_utility.trace('W2 Health Coverage='||ee_health_coverage); --13462230

989: hr_utility.trace('med_tax_on_tips='||ee_med_tax_on_tips);
990: hr_utility.trace('hire_act_wages='||ee_hire_act_wages); --10435466
991: hr_utility.trace('PR W2 Charitable Contributions='||ee_charitable_contributions); --13462230
992: hr_utility.trace('PR W2 Contr To Save and Double Money='||ee_save_and_double_money); --13462230
993: hr_utility.trace('W2 Health Coverage='||ee_health_coverage); --13462230
994:
995:
996: i := i+1;
997: total_rec_tab(i).r_label := 'Employer Name';

Line 1127: hr_utility.trace( 'J = '|| j );

1123:
1124:
1125: /*
1126: for j in total_rec_tab.first .. total_rec_tab.last loop
1127: hr_utility.trace( 'J = '|| j );
1128: hr_utility.trace( 'label = '||total_rec_tab(j).r_label);
1129: hr_utility.trace( 'value = '||total_rec_tab(j).r_value);
1130: hr_utility.trace( 'type = '||total_rec_tab(j).r_type);
1131: end loop;

Line 1128: hr_utility.trace( 'label = '||total_rec_tab(j).r_label);

1124:
1125: /*
1126: for j in total_rec_tab.first .. total_rec_tab.last loop
1127: hr_utility.trace( 'J = '|| j );
1128: hr_utility.trace( 'label = '||total_rec_tab(j).r_label);
1129: hr_utility.trace( 'value = '||total_rec_tab(j).r_value);
1130: hr_utility.trace( 'type = '||total_rec_tab(j).r_type);
1131: end loop;
1132: */

Line 1129: hr_utility.trace( 'value = '||total_rec_tab(j).r_value);

1125: /*
1126: for j in total_rec_tab.first .. total_rec_tab.last loop
1127: hr_utility.trace( 'J = '|| j );
1128: hr_utility.trace( 'label = '||total_rec_tab(j).r_label);
1129: hr_utility.trace( 'value = '||total_rec_tab(j).r_value);
1130: hr_utility.trace( 'type = '||total_rec_tab(j).r_type);
1131: end loop;
1132: */
1133:

Line 1130: hr_utility.trace( 'type = '||total_rec_tab(j).r_type);

1126: for j in total_rec_tab.first .. total_rec_tab.last loop
1127: hr_utility.trace( 'J = '|| j );
1128: hr_utility.trace( 'label = '||total_rec_tab(j).r_label);
1129: hr_utility.trace( 'value = '||total_rec_tab(j).r_value);
1130: hr_utility.trace( 'type = '||total_rec_tab(j).r_type);
1131: end loop;
1132: */
1133:
1134: hr_utility.trace( 'B4 formated header string ');

Line 1134: hr_utility.trace( 'B4 formated header string ');

1130: hr_utility.trace( 'type = '||total_rec_tab(j).r_type);
1131: end loop;
1132: */
1133:
1134: hr_utility.trace( 'B4 formated header string ');
1135: fnd_file.put_line(fnd_file.output,
1136: formated_header_string(gv_title,'HTML'));
1137: fnd_file.new_line(fnd_file.output,1);
1138: hr_utility.trace( 'A4 formated header string new line ');

Line 1138: hr_utility.trace( 'A4 formated header string new line ');

1134: hr_utility.trace( 'B4 formated header string ');
1135: fnd_file.put_line(fnd_file.output,
1136: formated_header_string(gv_title,'HTML'));
1137: fnd_file.new_line(fnd_file.output,1);
1138: hr_utility.trace( 'A4 formated header string new line ');
1139: /****************************************************************
1140: ** Print the Header Information. If the format is HTML then open
1141: ** the body and table before printing the header info, otherwise
1142: ** just print the header information.

Line 1166: hr_utility.trace( 'label 0 = '||total_rec_tab(i).r_label);

1162: ,p_type => total_rec_tab(i).r_type
1163: ,p_output_file_type => l_output_file_type));
1164:
1165: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1166: hr_utility.trace( 'label 0 = '||total_rec_tab(i).r_label);
1167: hr_utility.trace( 'value 0 = '||total_rec_tab(i).r_value);
1168: hr_utility.trace( 'value 0 = '||total_rec_tab(i).r_type);
1169: end loop ;
1170:

Line 1167: hr_utility.trace( 'value 0 = '||total_rec_tab(i).r_value);

1163: ,p_output_file_type => l_output_file_type));
1164:
1165: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1166: hr_utility.trace( 'label 0 = '||total_rec_tab(i).r_label);
1167: hr_utility.trace( 'value 0 = '||total_rec_tab(i).r_value);
1168: hr_utility.trace( 'value 0 = '||total_rec_tab(i).r_type);
1169: end loop ;
1170:
1171: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 1168: hr_utility.trace( 'value 0 = '||total_rec_tab(i).r_type);

1164:
1165: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1166: hr_utility.trace( 'label 0 = '||total_rec_tab(i).r_label);
1167: hr_utility.trace( 'value 0 = '||total_rec_tab(i).r_value);
1168: hr_utility.trace( 'value 0 = '||total_rec_tab(i).r_type);
1169: end loop ;
1170:
1171: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1172: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

Line 1182: hr_utility.trace('Total# of Records ='||to_char(ln_count));

1178: FROM pay_us_rpt_totals
1179: WHERE attribute2 = 'PRW2REGISTER'
1180: AND session_id = to_number(p_seq_num);
1181:
1182: hr_utility.trace('Total# of Records ='||to_char(ln_count));
1183: */
1184: DELETE from pay_us_rpt_totals
1185: WHERE attribute2 = 'PRW2REGISTER'
1186: AND session_id = to_number(p_seq_num);

Line 1299: hr_utility.trace('Exception value found for '||ee_last_name);

1295:
1296:
1297: EXIT WHEN c_ee_exception%notfound;
1298:
1299: hr_utility.trace('Exception value found for '||ee_last_name);
1300:
1301: IF c_ee_exception%ROWCOUNT =1 THEN
1302:
1303: fnd_file.put_line(fnd_file.output

Line 1376: hr_utility.trace('Total# of Records ='||to_char(ln_count));

1372: FROM pay_us_rpt_totals
1373: WHERE attribute2 = p_report_type
1374: AND session_id = to_number(p_seq_num);
1375:
1376: hr_utility.trace('Total# of Records ='||to_char(ln_count));
1377: */
1378: DELETE FROM pay_us_rpt_totals
1379: WHERE attribute2 = p_report_type
1380: AND session_id = to_number(p_seq_num);