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.

[Home] [Help]

APPS.PAY_US_PR_W2 dependencies on HR_UTILITY

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

92:
93: lv_format varchar2(32000);
94:
95: BEGIN
96: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);
97:
98: if p_output_file_type = 'CSV' then
99:
100:

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

97:
98: if p_output_file_type = 'CSV' then
99:
100:
101: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);
102:
103: lv_format := gc_csv_data_delimiter || p_input_string ||
104: gc_csv_data_delimiter || gc_csv_delimiter;
105:

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

115:
116: end if;
117:
118: if p_input_string is null then
119: hr_utility.set_location(gv_package_name || '.formated_data_string', 30);
120: lv_format := gv_html_start_data || ' ' || gv_html_end_data;
121: else
122: if p_bold = 'Y' then
123: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);

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

119: hr_utility.set_location(gv_package_name || '.formated_data_string', 30);
120: lv_format := gv_html_start_data || ' ' || gv_html_end_data;
121: else
122: if p_bold = 'Y' then
123: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);
124: lv_format := gv_html_start_data || ' ' || p_input_string
125: || '' || gv_html_end_data;
126: else
127: hr_utility.set_location(gv_package_name || '.formated_data_string', 50);

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

123: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);
124: lv_format := gv_html_start_data || ' ' || p_input_string
125: || '' || gv_html_end_data;
126: else
127: hr_utility.set_location(gv_package_name || '.formated_data_string', 50);
128: lv_format := gv_html_start_data || p_input_string || gv_html_end_data;
129: end if;
130: end if;
131:

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

130: end if;
131:
132: end if;
133:
134: hr_utility.set_location(gv_package_name || '.formated_data_string', 60);
135:
136: return lv_format;
137:
138: END formated_data_string;

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

149:
150: lv_format varchar2(1000);
151:
152: BEGIN
153: hr_utility.set_location(gv_package_name || '.formated_header_string', 10);
154: if p_output_file_type = 'CSV' then
155: hr_utility.set_location(gv_package_name || '.formated_header_string', 20);
156: lv_format := p_input_string;
157: elsif p_output_file_type = 'HTML' then

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

151:
152: BEGIN
153: hr_utility.set_location(gv_package_name || '.formated_header_string', 10);
154: if p_output_file_type = 'CSV' then
155: hr_utility.set_location(gv_package_name || '.formated_header_string', 20);
156: lv_format := p_input_string;
157: elsif p_output_file_type = 'HTML' then
158: hr_utility.set_location(gv_package_name || '.formated_header_string', 30);
159: lv_format := '

' || p_input_string ||

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

154: if p_output_file_type = 'CSV' then
155: hr_utility.set_location(gv_package_name || '.formated_header_string', 20);
156: lv_format := p_input_string;
157: elsif p_output_file_type = 'HTML' then
158: hr_utility.set_location(gv_package_name || '.formated_header_string', 30);
159: lv_format := '
' || p_input_string ||
160: '
';
161: end if;
162:

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

160: '

';
161: end if;
162:
163:
164: hr_utility.set_location(gv_package_name || '.formated_header_string', 40);
165: return lv_format;
166:
167: END formated_header_string;
168:

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

185: lv_format2 varchar2(32000);
186:
187: BEGIN
188:
189: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);
190: IF p_header = 'Header1' THEN
191:
192:
193: if p_report_type = 'PRW2EXCEPTION' then

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

506:
507:
508: BEGIN
509:
510: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);
511: hr_utility.trace('ER Name = '||p_tax_unit_name);
512: hr_utility.trace('EIN = '||p_ein);
513: hr_utility.trace('Year = '||p_year);
514: hr_utility.trace('EE Name = '||p_first_name);

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

507:
508: BEGIN
509:
510: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);
511: hr_utility.trace('ER Name = '||p_tax_unit_name);
512: hr_utility.trace('EIN = '||p_ein);
513: hr_utility.trace('Year = '||p_year);
514: hr_utility.trace('EE Name = '||p_first_name);
515: --5855662 Changed for employee file format

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

508: BEGIN
509:
510: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);
511: hr_utility.trace('ER Name = '||p_tax_unit_name);
512: hr_utility.trace('EIN = '||p_ein);
513: hr_utility.trace('Year = '||p_year);
514: hr_utility.trace('EE Name = '||p_first_name);
515: --5855662 Changed for employee file format
516: --6751130 Formatted p_ein

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

509:
510: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);
511: hr_utility.trace('ER Name = '||p_tax_unit_name);
512: hr_utility.trace('EIN = '||p_ein);
513: hr_utility.trace('Year = '||p_year);
514: hr_utility.trace('EE Name = '||p_first_name);
515: --5855662 Changed for employee file format
516: --6751130 Formatted p_ein
517: lv_format1 :=

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

510: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);
511: hr_utility.trace('ER Name = '||p_tax_unit_name);
512: hr_utility.trace('EIN = '||p_ein);
513: hr_utility.trace('Year = '||p_year);
514: hr_utility.trace('EE Name = '||p_first_name);
515: --5855662 Changed for employee file format
516: --6751130 Formatted p_ein
517: lv_format1 :=
518: formated_data_string (p_input_string => format_data(replace(p_ssn,'-',''),9)

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

683: formated_data_string (p_input_string => to_char(p_Med_Tax_on_tips,'999,999,999,999,990.00')
684: ,p_type => 'N'
685: ,p_output_file_type => p_output_file_type) ;
686:
687: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
688:
689:
690: hr_utility.trace('Static Data1 = ' || lv_format1);
691: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);

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

686:
687: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
688:
689:
690: hr_utility.trace('Static Data1 = ' || lv_format1);
691: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
692:
693: return (lv_format1);
694: END;

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

687: hr_utility.set_location(gv_package_name || '.formated_static_data', 20);
688:
689:
690: hr_utility.trace('Static Data1 = ' || lv_format1);
691: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
692:
693: return (lv_format1);
694: END;
695:

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

836: ln_count number(2);
837:
838: BEGIN
839:
840: -- hr_utility.trace_on(null, 'PRW2');
841: hr_utility.trace('Entered Main package');
842: hr_utility.trace('p_seq_num = '||p_seq_num);
843: hr_utility.trace('p_report_type = '||p_report_type);
844:

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

837:
838: BEGIN
839:
840: -- hr_utility.trace_on(null, 'PRW2');
841: hr_utility.trace('Entered Main package');
842: hr_utility.trace('p_seq_num = '||p_seq_num);
843: hr_utility.trace('p_report_type = '||p_report_type);
844:
845: /* report_type

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

838: BEGIN
839:
840: -- hr_utility.trace_on(null, 'PRW2');
841: hr_utility.trace('Entered Main package');
842: hr_utility.trace('p_seq_num = '||p_seq_num);
843: hr_utility.trace('p_report_type = '||p_report_type);
844:
845: /* report_type
846: PRW2REGISTER - Register Report

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

839:
840: -- hr_utility.trace_on(null, 'PRW2');
841: hr_utility.trace('Entered Main package');
842: hr_utility.trace('p_seq_num = '||p_seq_num);
843: hr_utility.trace('p_report_type = '||p_report_type);
844:
845: /* report_type
846: PRW2REGISTER - Register Report
847: PRW2TOTAL - Total Report

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

862:
863: i := 0;
864:
865: open c_er_total(p_seq_num,'PRW2REGISTER');
866: hr_utility.trace ('Opened c_er_total cursor');
867:
868: fetch c_er_total into er_name,
869: er_ein,
870: er_addr_line_1,

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

894: ee_med_tax_on_tips;
895:
896: if c_er_total%NOTFOUND then
897:
898: hr_utility.trace('No total information found for seq num = '||p_seq_num);
899:
900: else
901:
902: er_name := replace(er_name,',');

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

900: else
901:
902: er_name := replace(er_name,',');
903:
904: hr_utility.trace('wages ='||ee_wages);
905: hr_utility.trace('commissions ='||ee_commissions);
906: hr_utility.trace('allowances ='||ee_allowances);
907: hr_utility.trace('tips ='||ee_tips);
908: hr_utility.trace('total ='||ee_total);

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

901:
902: er_name := replace(er_name,',');
903:
904: hr_utility.trace('wages ='||ee_wages);
905: hr_utility.trace('commissions ='||ee_commissions);
906: hr_utility.trace('allowances ='||ee_allowances);
907: hr_utility.trace('tips ='||ee_tips);
908: hr_utility.trace('total ='||ee_total);
909: hr_utility.trace('reimb ='||ee_reimb);

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

902: er_name := replace(er_name,',');
903:
904: hr_utility.trace('wages ='||ee_wages);
905: hr_utility.trace('commissions ='||ee_commissions);
906: hr_utility.trace('allowances ='||ee_allowances);
907: hr_utility.trace('tips ='||ee_tips);
908: hr_utility.trace('total ='||ee_total);
909: hr_utility.trace('reimb ='||ee_reimb);
910: hr_utility.trace('tax ='||ee_tax);

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

903:
904: hr_utility.trace('wages ='||ee_wages);
905: hr_utility.trace('commissions ='||ee_commissions);
906: hr_utility.trace('allowances ='||ee_allowances);
907: hr_utility.trace('tips ='||ee_tips);
908: hr_utility.trace('total ='||ee_total);
909: hr_utility.trace('reimb ='||ee_reimb);
910: hr_utility.trace('tax ='||ee_tax);
911: hr_utility.trace('ret_fund ='||ee_ret_fund);

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

904: hr_utility.trace('wages ='||ee_wages);
905: hr_utility.trace('commissions ='||ee_commissions);
906: hr_utility.trace('allowances ='||ee_allowances);
907: hr_utility.trace('tips ='||ee_tips);
908: hr_utility.trace('total ='||ee_total);
909: hr_utility.trace('reimb ='||ee_reimb);
910: hr_utility.trace('tax ='||ee_tax);
911: hr_utility.trace('ret_fund ='||ee_ret_fund);
912: hr_utility.trace('coda ='||ee_coda);

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

905: hr_utility.trace('commissions ='||ee_commissions);
906: hr_utility.trace('allowances ='||ee_allowances);
907: hr_utility.trace('tips ='||ee_tips);
908: hr_utility.trace('total ='||ee_total);
909: hr_utility.trace('reimb ='||ee_reimb);
910: hr_utility.trace('tax ='||ee_tax);
911: hr_utility.trace('ret_fund ='||ee_ret_fund);
912: hr_utility.trace('coda ='||ee_coda);
913: hr_utility.trace('ss_wages ='||ee_ss_wages);

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

906: hr_utility.trace('allowances ='||ee_allowances);
907: hr_utility.trace('tips ='||ee_tips);
908: hr_utility.trace('total ='||ee_total);
909: hr_utility.trace('reimb ='||ee_reimb);
910: hr_utility.trace('tax ='||ee_tax);
911: hr_utility.trace('ret_fund ='||ee_ret_fund);
912: hr_utility.trace('coda ='||ee_coda);
913: hr_utility.trace('ss_wages ='||ee_ss_wages);
914: hr_utility.trace('ss_Tax ='||ee_ss_Tax);

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

907: hr_utility.trace('tips ='||ee_tips);
908: hr_utility.trace('total ='||ee_total);
909: hr_utility.trace('reimb ='||ee_reimb);
910: hr_utility.trace('tax ='||ee_tax);
911: hr_utility.trace('ret_fund ='||ee_ret_fund);
912: hr_utility.trace('coda ='||ee_coda);
913: hr_utility.trace('ss_wages ='||ee_ss_wages);
914: hr_utility.trace('ss_Tax ='||ee_ss_Tax);
915: hr_utility.trace('ss_tips ='||ee_ss_tips);

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

908: hr_utility.trace('total ='||ee_total);
909: hr_utility.trace('reimb ='||ee_reimb);
910: hr_utility.trace('tax ='||ee_tax);
911: hr_utility.trace('ret_fund ='||ee_ret_fund);
912: hr_utility.trace('coda ='||ee_coda);
913: hr_utility.trace('ss_wages ='||ee_ss_wages);
914: hr_utility.trace('ss_Tax ='||ee_ss_Tax);
915: hr_utility.trace('ss_tips ='||ee_ss_tips);
916: hr_utility.trace('med_Wages ='||ee_med_Wages);

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

909: hr_utility.trace('reimb ='||ee_reimb);
910: hr_utility.trace('tax ='||ee_tax);
911: hr_utility.trace('ret_fund ='||ee_ret_fund);
912: hr_utility.trace('coda ='||ee_coda);
913: hr_utility.trace('ss_wages ='||ee_ss_wages);
914: hr_utility.trace('ss_Tax ='||ee_ss_Tax);
915: hr_utility.trace('ss_tips ='||ee_ss_tips);
916: hr_utility.trace('med_Wages ='||ee_med_Wages);
917: hr_utility.trace('med_tax ='||ee_med_tax);

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

910: hr_utility.trace('tax ='||ee_tax);
911: hr_utility.trace('ret_fund ='||ee_ret_fund);
912: hr_utility.trace('coda ='||ee_coda);
913: hr_utility.trace('ss_wages ='||ee_ss_wages);
914: hr_utility.trace('ss_Tax ='||ee_ss_Tax);
915: hr_utility.trace('ss_tips ='||ee_ss_tips);
916: hr_utility.trace('med_Wages ='||ee_med_Wages);
917: hr_utility.trace('med_tax ='||ee_med_tax);
918: hr_utility.trace('ss_tax_on_tips ='||ee_ss_tax_on_tips);

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

911: hr_utility.trace('ret_fund ='||ee_ret_fund);
912: hr_utility.trace('coda ='||ee_coda);
913: hr_utility.trace('ss_wages ='||ee_ss_wages);
914: hr_utility.trace('ss_Tax ='||ee_ss_Tax);
915: hr_utility.trace('ss_tips ='||ee_ss_tips);
916: hr_utility.trace('med_Wages ='||ee_med_Wages);
917: hr_utility.trace('med_tax ='||ee_med_tax);
918: hr_utility.trace('ss_tax_on_tips ='||ee_ss_tax_on_tips);
919: hr_utility.trace('med_tax_on_tips='||ee_med_tax_on_tips);

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

912: hr_utility.trace('coda ='||ee_coda);
913: hr_utility.trace('ss_wages ='||ee_ss_wages);
914: hr_utility.trace('ss_Tax ='||ee_ss_Tax);
915: hr_utility.trace('ss_tips ='||ee_ss_tips);
916: hr_utility.trace('med_Wages ='||ee_med_Wages);
917: hr_utility.trace('med_tax ='||ee_med_tax);
918: hr_utility.trace('ss_tax_on_tips ='||ee_ss_tax_on_tips);
919: hr_utility.trace('med_tax_on_tips='||ee_med_tax_on_tips);
920:

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

913: hr_utility.trace('ss_wages ='||ee_ss_wages);
914: hr_utility.trace('ss_Tax ='||ee_ss_Tax);
915: hr_utility.trace('ss_tips ='||ee_ss_tips);
916: hr_utility.trace('med_Wages ='||ee_med_Wages);
917: hr_utility.trace('med_tax ='||ee_med_tax);
918: hr_utility.trace('ss_tax_on_tips ='||ee_ss_tax_on_tips);
919: hr_utility.trace('med_tax_on_tips='||ee_med_tax_on_tips);
920:
921:

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

914: hr_utility.trace('ss_Tax ='||ee_ss_Tax);
915: hr_utility.trace('ss_tips ='||ee_ss_tips);
916: hr_utility.trace('med_Wages ='||ee_med_Wages);
917: hr_utility.trace('med_tax ='||ee_med_tax);
918: hr_utility.trace('ss_tax_on_tips ='||ee_ss_tax_on_tips);
919: hr_utility.trace('med_tax_on_tips='||ee_med_tax_on_tips);
920:
921:
922: i := i+1;

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

915: hr_utility.trace('ss_tips ='||ee_ss_tips);
916: hr_utility.trace('med_Wages ='||ee_med_Wages);
917: hr_utility.trace('med_tax ='||ee_med_tax);
918: hr_utility.trace('ss_tax_on_tips ='||ee_ss_tax_on_tips);
919: hr_utility.trace('med_tax_on_tips='||ee_med_tax_on_tips);
920:
921:
922: i := i+1;
923: total_rec_tab(i).r_label := 'Employer Name';

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

1029: total_rec_tab(i).r_type := 'N';
1030:
1031: /*
1032: for j in total_rec_tab.first .. total_rec_tab.last loop
1033: hr_utility.trace( 'J = '|| j );
1034: hr_utility.trace( 'label = '||total_rec_tab(j).r_label);
1035: hr_utility.trace( 'value = '||total_rec_tab(j).r_value);
1036: hr_utility.trace( 'type = '||total_rec_tab(j).r_type);
1037: end loop;

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

1030:
1031: /*
1032: for j in total_rec_tab.first .. total_rec_tab.last loop
1033: hr_utility.trace( 'J = '|| j );
1034: hr_utility.trace( 'label = '||total_rec_tab(j).r_label);
1035: hr_utility.trace( 'value = '||total_rec_tab(j).r_value);
1036: hr_utility.trace( 'type = '||total_rec_tab(j).r_type);
1037: end loop;
1038: */

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

1031: /*
1032: for j in total_rec_tab.first .. total_rec_tab.last loop
1033: hr_utility.trace( 'J = '|| j );
1034: hr_utility.trace( 'label = '||total_rec_tab(j).r_label);
1035: hr_utility.trace( 'value = '||total_rec_tab(j).r_value);
1036: hr_utility.trace( 'type = '||total_rec_tab(j).r_type);
1037: end loop;
1038: */
1039:

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

1032: for j in total_rec_tab.first .. total_rec_tab.last loop
1033: hr_utility.trace( 'J = '|| j );
1034: hr_utility.trace( 'label = '||total_rec_tab(j).r_label);
1035: hr_utility.trace( 'value = '||total_rec_tab(j).r_value);
1036: hr_utility.trace( 'type = '||total_rec_tab(j).r_type);
1037: end loop;
1038: */
1039:
1040: hr_utility.trace( 'B4 formated header string ');

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

1036: hr_utility.trace( 'type = '||total_rec_tab(j).r_type);
1037: end loop;
1038: */
1039:
1040: hr_utility.trace( 'B4 formated header string ');
1041: fnd_file.put_line(fnd_file.output,
1042: formated_header_string(gv_title,'HTML'));
1043: fnd_file.new_line(fnd_file.output,1);
1044: hr_utility.trace( 'A4 formated header string new line ');

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

1040: hr_utility.trace( 'B4 formated header string ');
1041: fnd_file.put_line(fnd_file.output,
1042: formated_header_string(gv_title,'HTML'));
1043: fnd_file.new_line(fnd_file.output,1);
1044: hr_utility.trace( 'A4 formated header string new line ');
1045: /****************************************************************
1046: ** Print the Header Information. If the format is HTML then open
1047: ** the body and table before printing the header info, otherwise
1048: ** just print the header information.

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

1068: ,p_type => total_rec_tab(i).r_type
1069: ,p_output_file_type => l_output_file_type));
1070:
1071: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1072: hr_utility.trace( 'label 0 = '||total_rec_tab(i).r_label);
1073: hr_utility.trace( 'value 0 = '||total_rec_tab(i).r_value);
1074: hr_utility.trace( 'value 0 = '||total_rec_tab(i).r_type);
1075: end loop ;
1076:

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

1069: ,p_output_file_type => l_output_file_type));
1070:
1071: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1072: hr_utility.trace( 'label 0 = '||total_rec_tab(i).r_label);
1073: hr_utility.trace( 'value 0 = '||total_rec_tab(i).r_value);
1074: hr_utility.trace( 'value 0 = '||total_rec_tab(i).r_type);
1075: end loop ;
1076:
1077: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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

1070:
1071: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1072: hr_utility.trace( 'label 0 = '||total_rec_tab(i).r_label);
1073: hr_utility.trace( 'value 0 = '||total_rec_tab(i).r_value);
1074: hr_utility.trace( 'value 0 = '||total_rec_tab(i).r_type);
1075: end loop ;
1076:
1077: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1078: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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

1084: FROM pay_us_rpt_totals
1085: WHERE attribute2 = 'PRW2REGISTER'
1086: AND session_id = to_number(p_seq_num);
1087:
1088: hr_utility.trace('Total# of Records ='||to_char(ln_count));
1089: */
1090: DELETE from pay_us_rpt_totals
1091: WHERE attribute2 = 'PRW2REGISTER'
1092: AND session_id = to_number(p_seq_num);

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

1191: ee_med_tax_on_tips;
1192:
1193: EXIT WHEN c_ee_exception%notfound;
1194:
1195: hr_utility.trace('Exception value found for '||ee_last_name);
1196:
1197: IF c_ee_exception%ROWCOUNT =1 THEN
1198:
1199: fnd_file.put_line(fnd_file.output

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

1263: FROM pay_us_rpt_totals
1264: WHERE attribute2 = p_report_type
1265: AND session_id = to_number(p_seq_num);
1266:
1267: hr_utility.trace('Total# of Records ='||to_char(ln_count));
1268: */
1269: DELETE FROM pay_us_rpt_totals
1270: WHERE attribute2 = p_report_type
1271: AND session_id = to_number(p_seq_num);