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

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

110:
111: lv_format varchar2(1000);
112:
113: BEGIN
114: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);
115: if p_output_file_type = 'CSV' then
116: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);
117: lv_format := gc_csv_data_delimiter || p_input_string ||
118: gc_csv_data_delimiter || gc_csv_delimiter;

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

112:
113: BEGIN
114: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);
115: if p_output_file_type = 'CSV' then
116: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);
117: lv_format := gc_csv_data_delimiter || p_input_string ||
118: gc_csv_data_delimiter || gc_csv_delimiter;
119: elsif p_output_file_type = 'HTML' then
120: if p_input_string is null then

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

117: lv_format := gc_csv_data_delimiter || p_input_string ||
118: gc_csv_data_delimiter || gc_csv_delimiter;
119: elsif p_output_file_type = 'HTML' then
120: if p_input_string is null then
121: hr_utility.set_location(gv_package_name || '.formated_data_string', 30);
122: lv_format := gv_html_start_data || '&'||'nbsp;' || gv_html_end_data;
123: else
124: if p_bold = 'Y' then
125: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);

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

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

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

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

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

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

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

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

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

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

' || p_input_string ||

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

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

' || p_input_string ||
161: -- '
';
162: lv_format := '
' || p_input_string ||
163: '
';

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

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

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

181: lv_format1 varchar2(32000);
182:
183: BEGIN
184:
185: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);
186:
187: lv_format1 :=
188: formated_data_string (p_input_string => 'Full Name'
189: ,p_bold => 'Y'

Line 204: hr_utility.set_location(gv_package_name || '.formated_static_header', 20);

200: ,p_bold => 'Y'
201: ,p_output_file_type => p_output_file_type)
202: ;
203:
204: hr_utility.set_location(gv_package_name || '.formated_static_header', 20);
205:
206: p_static_label1 := lv_format1;
207: hr_utility.trace('Static Label1 = ' || lv_format1);
208: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);

Line 207: hr_utility.trace('Static Label1 = ' || lv_format1);

203:
204: hr_utility.set_location(gv_package_name || '.formated_static_header', 20);
205:
206: p_static_label1 := lv_format1;
207: hr_utility.trace('Static Label1 = ' || lv_format1);
208: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);
209:
210: END;
211:

Line 208: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);

204: hr_utility.set_location(gv_package_name || '.formated_static_header', 20);
205:
206: p_static_label1 := lv_format1;
207: hr_utility.trace('Static Label1 = ' || lv_format1);
208: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);
209:
210: END;
211:
212:

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

233:
234:
235: BEGIN
236:
237: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);
238:
239: if p_full_name is not NULL THEN
240:
241: lv_format1 := lv_format1 ||

Line 295: hr_utility.set_location(gv_package_name || '.formated_static_data', 30);

291: ,p_output_file_type => p_output_file_type);
292: end if;
293:
294:
295: hr_utility.set_location(gv_package_name || '.formated_static_data', 30);
296:
297:
298: p_static_data1 := lv_format1;
299: hr_utility.trace('Static Data1 = ' || lv_format1);

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

295: hr_utility.set_location(gv_package_name || '.formated_static_data', 30);
296:
297:
298: p_static_data1 := lv_format1;
299: hr_utility.trace('Static Data1 = ' || lv_format1);
300: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
301:
302: END formated_static_data;
303: /***

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

296:
297:
298: p_static_data1 := lv_format1;
299: hr_utility.trace('Static Data1 = ' || lv_format1);
300: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
301:
302: END formated_static_data;
303: /*
304: This procudure returns the Mandatory Static Labels.

Line 326: hr_utility.set_location(gv_package_name || '.formated_static_data2', 10);

322:
323:
324: BEGIN
325:
326: hr_utility.set_location(gv_package_name || '.formated_static_data2', 10);
327: lv_format1 :=
328: formated_data_string (p_input_string => p_full_name
329: ,p_output_file_type => p_output_file_type) ||
330: formated_data_string (p_input_string => p_assignment_id

Line 367: hr_utility.set_location(gv_package_name || '.formated_static_data2', 30);

363: ,p_output_file_type => p_output_file_type);
364: end if;
365:
366:
367: hr_utility.set_location(gv_package_name || '.formated_static_data2', 30);
368:
369:
370: p_static_data1 := lv_format1;
371: hr_utility.trace('Static Data1 = ' || lv_format1);

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

367: hr_utility.set_location(gv_package_name || '.formated_static_data2', 30);
368:
369:
370: p_static_data1 := lv_format1;
371: hr_utility.trace('Static Data1 = ' || lv_format1);
372: hr_utility.set_location(gv_package_name || '.formated_static_data2', 40);
373:
374: END formated_static_data2;
375:

Line 372: hr_utility.set_location(gv_package_name || '.formated_static_data2', 40);

368:
369:
370: p_static_data1 := lv_format1;
371: hr_utility.trace('Static Data1 = ' || lv_format1);
372: hr_utility.set_location(gv_package_name || '.formated_static_data2', 40);
373:
374: END formated_static_data2;
375:
376: /Added for Bug#14314081 /

Line 401: hr_utility.set_location(gv_package_name || '.formated_static_data3', 10);

397:
398:
399: BEGIN
400:
401: hr_utility.set_location(gv_package_name || '.formated_static_data3', 10);
402:
403: if p_country is not NULL THEN
404:
405: lv_format1 := lv_format1 ||

Line 446: hr_utility.set_location(gv_package_name || '.formated_static_data3', 30);

442: formated_data_string (p_input_string => p_new_city_name
443: ,p_output_file_type => p_output_file_type);
444: end if;
445:
446: hr_utility.set_location(gv_package_name || '.formated_static_data3', 30);
447:
448:
449: p_static_data1 := lv_format1;
450: hr_utility.trace('Static Data1 = ' || lv_format1);

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

446: hr_utility.set_location(gv_package_name || '.formated_static_data3', 30);
447:
448:
449: p_static_data1 := lv_format1;
450: hr_utility.trace('Static Data1 = ' || lv_format1);
451: hr_utility.set_location(gv_package_name || '.formated_static_data3', 40);
452:
453: END formated_static_data3;
454:

Line 451: hr_utility.set_location(gv_package_name || '.formated_static_data3', 40);

447:
448:
449: p_static_data1 := lv_format1;
450: hr_utility.trace('Static Data1 = ' || lv_format1);
451: hr_utility.set_location(gv_package_name || '.formated_static_data3', 40);
452:
453: END formated_static_data3;
454:
455: /***********************************

Line 478: hr_utility.set_location(gv_package_name || '.formated_static_data4', 10);

474:
475:
476: BEGIN
477:
478: hr_utility.set_location(gv_package_name || '.formated_static_data4', 10);
479:
480: if p_full_name is not NULL THEN
481:
482: lv_format1 := lv_format1 ||

Line 523: hr_utility.set_location(gv_package_name || '.formated_static_data4', 30);

519: formated_data_string (p_input_string => p_update_description
520: ,p_output_file_type => p_output_file_type);
521: end if;
522:
523: hr_utility.set_location(gv_package_name || '.formated_static_data4', 30);
524:
525:
526: p_static_data1 := lv_format1;
527: hr_utility.trace('Static Data1 = ' || lv_format1);

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

523: hr_utility.set_location(gv_package_name || '.formated_static_data4', 30);
524:
525:
526: p_static_data1 := lv_format1;
527: hr_utility.trace('Static Data1 = ' || lv_format1);
528: hr_utility.set_location(gv_package_name || '.formated_static_data4', 40);
529:
530: END formated_static_data4;
531:

Line 528: hr_utility.set_location(gv_package_name || '.formated_static_data4', 40);

524:
525:
526: p_static_data1 := lv_format1;
527: hr_utility.trace('Static Data1 = ' || lv_format1);
528: hr_utility.set_location(gv_package_name || '.formated_static_data4', 40);
529:
530: END formated_static_data4;
531:
532: /*

Line 554: hr_utility.set_location(gv_package_name || '.formated_static_data5', 10);

550:
551:
552: BEGIN
553:
554: hr_utility.set_location(gv_package_name || '.formated_static_data5', 10);
555:
556: if p_location_name is not NULL THEN
557:
558: lv_format1 := lv_format1 ||

Line 593: hr_utility.set_location(gv_package_name || '.formated_static_data5', 30);

589: formated_data_string (p_input_string => p_update_description
590: ,p_output_file_type => p_output_file_type);
591: end if;
592:
593: hr_utility.set_location(gv_package_name || '.formated_static_data5', 30);
594:
595:
596: p_static_data1 := lv_format1;
597: hr_utility.trace('Static Data1 = ' || lv_format1);

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

593: hr_utility.set_location(gv_package_name || '.formated_static_data5', 30);
594:
595:
596: p_static_data1 := lv_format1;
597: hr_utility.trace('Static Data1 = ' || lv_format1);
598: hr_utility.set_location(gv_package_name || '.formated_static_data5', 40);
599:
600: END formated_static_data5;
601:

Line 598: hr_utility.set_location(gv_package_name || '.formated_static_data5', 40);

594:
595:
596: p_static_data1 := lv_format1;
597: hr_utility.trace('Static Data1 = ' || lv_format1);
598: hr_utility.set_location(gv_package_name || '.formated_static_data5', 40);
599:
600: END formated_static_data5;
601:
602: /********************************************

Line 624: hr_utility.set_location(gv_package_name || '.formated_static_data6', 10);

620:
621:
622: BEGIN
623:
624: hr_utility.set_location(gv_package_name || '.formated_static_data6', 10);
625:
626: if p_organization_name is not NULL THEN
627:
628: lv_format1 := lv_format1 ||

Line 663: hr_utility.set_location(gv_package_name || '.formated_static_data6', 30);

659: formated_data_string (p_input_string => p_update_description
660: ,p_output_file_type => p_output_file_type);
661: end if;
662:
663: hr_utility.set_location(gv_package_name || '.formated_static_data6', 30);
664:
665:
666: p_static_data1 := lv_format1;
667: hr_utility.trace('Static Data1 = ' || lv_format1);

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

663: hr_utility.set_location(gv_package_name || '.formated_static_data6', 30);
664:
665:
666: p_static_data1 := lv_format1;
667: hr_utility.trace('Static Data1 = ' || lv_format1);
668: hr_utility.set_location(gv_package_name || '.formated_static_data6', 40);
669:
670: END formated_static_data6;
671:

Line 668: hr_utility.set_location(gv_package_name || '.formated_static_data6', 40);

664:
665:
666: p_static_data1 := lv_format1;
667: hr_utility.trace('Static Data1 = ' || lv_format1);
668: hr_utility.set_location(gv_package_name || '.formated_static_data6', 40);
669:
670: END formated_static_data6;
671:
672: /End of changes for Bug#14314081 /

Line 737: hr_utility.set_location(gv_package_name || '.report_1', 10);

733:
734:
735: BEGIN
736:
737: hr_utility.set_location(gv_package_name || '.report_1', 10);
738:
739: /****************************
740: Concatnating the second Header Label which includes the User
741: Defined data set so that it is printed at the end of the

Line 781: hr_utility.set_location(gv_package_name || '.report_1', 12);

777: ,p_output_file_type
778: ));
779:
780:
781: hr_utility.set_location(gv_package_name || '.report_1', 12);
782: /
783: Print the Header Information. If the format is HTML then open
784: the body and table before printing the header info, otherwise
785: just print the header information.

Line 792: hr_utility.set_location(gv_package_name || '.report_1', 15);

788: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
789: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
790: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
791: end if;
792: hr_utility.set_location(gv_package_name || '.report_1', 15);
793:
794: lv_format1 :=
795: formated_data_string (p_input_string => 'Full Name'
796: ,p_bold => 'Y'
Line 811: hr_utility.set_location(gv_package_name || '.report_1', 20);

807: ,p_bold => 'Y'
808: ,p_output_file_type => p_output_file_type)
809: ;
810:
811: hr_utility.set_location(gv_package_name || '.report_1', 20);
812:
813:
814: fnd_file.put_line(fnd_file.output, lv_format1);
815:

Line 820: hr_utility.set_location(gv_package_name || '.report_1', 30);

816: if p_output_file_type ='HTML' then
817: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
818: end if;
819:
820: hr_utility.set_location(gv_package_name || '.report_1', 30);
821: /*
822: Start of the Data Section of the Report
823: ***/
824:
Line 825: -- HR_UTILITY.TRACE_ON(NULL,'TCL');

821: /*
822: Start of the Data Section of the Report
823: */
824:
825: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
826: open c_cursor( p_process_mode
827: ,p_geocode_patch_name
828: );
829:

Line 831: hr_utility.set_location(gv_package_name || '.report_1', 40);

827: ,p_geocode_patch_name
828: );
829:
830: loop
831: hr_utility.set_location(gv_package_name || '.report_1', 40);
832:
833: fetch c_cursor into ln_full_name
834: ,ln_assignment_id
835: ,ln_assignment_number

Line 839: hr_utility.set_location(gv_package_name || '.report_1', 50);

835: ,ln_assignment_number
836: ,ln_error_description;
837:
838: if c_cursor%notfound then
839: hr_utility.set_location(gv_package_name || '.report_1', 50);
840: exit;
841: end if;
842:
843:

Line 849: hr_utility.set_location(gv_package_name || '.report_1', 60);

845: If Assignment Set is used, pick up only those employee
846: assignments which are part of the Assignment Set - STATIC
847: or DYNAMIC.
848: /
849: hr_utility.set_location(gv_package_name || '.report_1', 60);
850: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
851:
852: formated_static_data( ln_full_name
853: ,ln_assignment_id

Line 850: hr_utility.trace('Assignment ID = ' || ln_assignment_id);

846: assignments which are part of the Assignment Set - STATIC
847: or DYNAMIC.
848: /
849: hr_utility.set_location(gv_package_name || '.report_1', 60);
850: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
851:
852: formated_static_data( ln_full_name
853: ,ln_assignment_id
854: ,ln_assignment_number

Line 865: hr_utility.set_location(gv_package_name || '.report_1', 70);

861: ,p_output_file_type
862: ,lv_data_row1);
863:
864: lv_data_row := lv_data_row1;
865: hr_utility.set_location(gv_package_name || '.report_1', 70);
866:
867: -- if p_output_file_type ='HTML' then
868: lv_data_row := '
' || lv_data_row || '' ;
869: -- end if;
Line 934: hr_utility.set_location(gv_package_name || '.report_2', 10);

930:
931:
932: BEGIN
933:
934: hr_utility.set_location(gv_package_name || '.report_2', 10);
935:
936: /
937: Concatnating the second Header Label which includes the User
938: Defined data set so that it is printed at the end of the

Line 972: hr_utility.set_location(gv_package_name || '.report_2', 15);

968: '(or total of all the cities) to not exceed 100% time in total. '
969: ,p_output_file_type
970: ));
971:
972: hr_utility.set_location(gv_package_name || '.report_2', 15);
973: /**
974: Print the Header Information. If the format is HTML then open
975: the body and table before printing the header info, otherwise
976: just print the header information.

Line 983: hr_utility.set_location(gv_package_name || '.report_2', 20);

979: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
980: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
981: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
982: end if;
983: hr_utility.set_location(gv_package_name || '.report_2', 20);
984:
985: lv_format1 :=
986: formated_data_string (p_input_string => 'Full Name'
987: ,p_bold => 'Y'
Line 997: hr_utility.set_location(gv_package_name || '.report_2', 30);

993: formated_data_string (p_input_string => 'Assignment Number'
994: ,p_bold => 'Y'
995: ,p_output_file_type => p_output_file_type) ;
996:
997: hr_utility.set_location(gv_package_name || '.report_2', 30);
998:
999:
1000: fnd_file.put_line(fnd_file.output, lv_format1);
1001:

Line 1006: hr_utility.set_location(gv_package_name || '.report_2', 40);

1002: if p_output_file_type ='HTML' then
1003: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1004: end if;
1005:
1006: hr_utility.set_location(gv_package_name || '.report_2', 40);
1007: /*
1008: Start of the Data Section of the Report
1009: ***/
1010:
Line 1011: -- HR_UTILITY.TRACE_ON(NULL,'TCL');

1007: /*
1008: Start of the Data Section of the Report
1009: */
1010:
1011: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
1012: open c_cursor( p_process_mode
1013: ,p_geocode_patch_name
1014: );
1015:

Line 1017: hr_utility.set_location(gv_package_name || '.report_2', 50);

1013: ,p_geocode_patch_name
1014: );
1015:
1016: loop
1017: hr_utility.set_location(gv_package_name || '.report_2', 50);
1018:
1019: fetch c_cursor into ln_full_name
1020: ,ln_assignment_id
1021: ,ln_assignment_number;

Line 1024: hr_utility.set_location(gv_package_name || '.report_2', 60);

1020: ,ln_assignment_id
1021: ,ln_assignment_number;
1022:
1023: if c_cursor%notfound then
1024: hr_utility.set_location(gv_package_name || '.report_2', 60);
1025: exit;
1026: end if;
1027:
1028:

Line 1034: hr_utility.set_location(gv_package_name || '.report_2', 70);

1030: If Assignment Set is used, pick up only those employee
1031: assignments which are part of the Assignment Set - STATIC
1032: or DYNAMIC.
1033: /
1034: hr_utility.set_location(gv_package_name || '.report_2', 70);
1035:
1036: hr_utility.set_location(gv_package_name || '.report_2', 80);
1037: formated_static_data( ln_full_name
1038: ,ln_assignment_id

Line 1036: hr_utility.set_location(gv_package_name || '.report_2', 80);

1032: or DYNAMIC.
1033: /
1034: hr_utility.set_location(gv_package_name || '.report_2', 70);
1035:
1036: hr_utility.set_location(gv_package_name || '.report_2', 80);
1037: formated_static_data( ln_full_name
1038: ,ln_assignment_id
1039: ,ln_assignment_number
1040: ,null

Line 1050: hr_utility.set_location(gv_package_name || '.report_2', 90);

1046: ,p_output_file_type
1047: ,lv_data_row1);
1048:
1049: lv_data_row := lv_data_row1;
1050: hr_utility.set_location(gv_package_name || '.report_2', 90);
1051:
1052: -- if p_output_file_type ='HTML' then
1053: lv_data_row := '
' || lv_data_row || '' ;
1054: -- end if;
Line 1119: hr_utility.set_location(gv_package_name || '.report_3', 10);

1115:
1116:
1117: BEGIN
1118:
1119: hr_utility.set_location(gv_package_name || '.report_3', 10);
1120:
1121: /
1122: Concatnating the second Header Label which includes the User
1123: Defined data set so that it is printed at the end of the

Line 1147: hr_utility.set_location(gv_package_name || '.report_3', 15);

1143: 'Please correct this by creating a new county tax record from the W-4 form.'
1144: ,p_output_file_type
1145: ));
1146:
1147: hr_utility.set_location(gv_package_name || '.report_3', 15);
1148: /****
1149: Print the Header Information. If the format is HTML then open
1150: the body and table before printing the header info, otherwise
1151: just print the header information.

Line 1158: hr_utility.set_location(gv_package_name || '.report_3', 20);

1154: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1157: end if;
1158: hr_utility.set_location(gv_package_name || '.report_3', 20);
1159:
1160: lv_format1 :=
1161: formated_data_string (p_input_string => 'Full Name'
1162: ,p_bold => 'Y'
Line 1173: hr_utility.set_location(gv_package_name || '.report_3', 30);

1169: ,p_bold => 'Y'
1170: ,p_output_file_type => p_output_file_type)
1171: ;
1172:
1173: hr_utility.set_location(gv_package_name || '.report_3', 30);
1174:
1175:
1176: fnd_file.put_line(fnd_file.output, lv_format1);
1177:

Line 1182: hr_utility.set_location(gv_package_name || '.report_3', 40);

1178: if p_output_file_type ='HTML' then
1179: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1180: end if;
1181:
1182: hr_utility.set_location(gv_package_name || '.report_3', 40);
1183: /*
1184: Start of the Data Section of the Report
1185: ***/
1186:
Line 1187: -- HR_UTILITY.TRACE_ON(NULL,'TCL');

1183: /*
1184: Start of the Data Section of the Report
1185: */
1186:
1187: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
1188: open c_cursor( p_process_mode
1189: ,p_geocode_patch_name
1190: );
1191:

Line 1193: hr_utility.set_location(gv_package_name || '.report_3', 50);

1189: ,p_geocode_patch_name
1190: );
1191:
1192: loop
1193: hr_utility.set_location(gv_package_name || '.report_3', 50);
1194:
1195: fetch c_cursor into ln_full_name
1196: ,ln_assignment_id
1197: ,ln_assignment_number;

Line 1200: hr_utility.set_location(gv_package_name || '.report_3', 60);

1196: ,ln_assignment_id
1197: ,ln_assignment_number;
1198:
1199: if c_cursor%notfound then
1200: hr_utility.set_location(gv_package_name || '.report_3', 60);
1201: exit;
1202: end if;
1203:
1204:

Line 1210: hr_utility.set_location(gv_package_name || '.report_3', 70);

1206: If Assignment Set is used, pick up only those employee
1207: assignments which are part of the Assignment Set - STATIC
1208: or DYNAMIC.
1209: /
1210: hr_utility.set_location(gv_package_name || '.report_3', 70);
1211: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1212:
1213:
1214: hr_utility.set_location(gv_package_name || '.report_3', 80);

Line 1211: hr_utility.trace('Assignment ID = ' || ln_assignment_id);

1207: assignments which are part of the Assignment Set - STATIC
1208: or DYNAMIC.
1209: /
1210: hr_utility.set_location(gv_package_name || '.report_3', 70);
1211: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1212:
1213:
1214: hr_utility.set_location(gv_package_name || '.report_3', 80);
1215: formated_static_data( ln_full_name

Line 1214: hr_utility.set_location(gv_package_name || '.report_3', 80);

1210: hr_utility.set_location(gv_package_name || '.report_3', 70);
1211: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1212:
1213:
1214: hr_utility.set_location(gv_package_name || '.report_3', 80);
1215: formated_static_data( ln_full_name
1216: ,ln_assignment_id
1217: ,ln_assignment_number
1218: ,null

Line 1228: hr_utility.set_location(gv_package_name || '.report_3', 90);

1224: ,p_output_file_type
1225: ,lv_data_row1);
1226:
1227: lv_data_row := lv_data_row1;
1228: hr_utility.set_location(gv_package_name || '.report_3', 90);
1229:
1230: -- if p_output_file_type ='HTML' then
1231: lv_data_row := '
' || lv_data_row || '' ;
1232: -- end if;
Line 1320: hr_utility.set_location(gv_package_name || '.report_4', 10);

1316:
1317:
1318: BEGIN
1319:
1320: hr_utility.set_location(gv_package_name || '.report_4', 10);
1321:
1322: /
1323: Concatnating the second Header Label which includes the User
1324: Defined data set so that it is printed at the end of the

Line 1358: hr_utility.set_location(gv_package_name || '.report_4', 15);

1354: 'The city displayed here is the NEW PRIMARY CITY for the assignment.'
1355: ,p_output_file_type
1356: ));
1357:
1358: hr_utility.set_location(gv_package_name || '.report_4', 15);
1359: /**
1360: Print the Header Information. If the format is HTML then open
1361: the body and table before printing the header info, otherwise
1362: just print the header information.

Line 1369: hr_utility.set_location(gv_package_name || '.report_4', 20);

1365: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1366: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1367: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1368: end if;
1369: hr_utility.set_location(gv_package_name || '.report_4', 20);
1370:
1371: lv_format1 :=
1372: formated_data_string (p_input_string => 'Full Name'
1373: ,p_bold => 'Y'
Line 1406: hr_utility.set_location(gv_package_name || '.report_4', 30);

1402: ,p_output_file_type => p_output_file_type)
1403: ;
1404:
1405:
1406: hr_utility.set_location(gv_package_name || '.report_4', 30);
1407:
1408:
1409: fnd_file.put_line(fnd_file.output, lv_format1);
1410:

Line 1415: hr_utility.set_location(gv_package_name || '.report_4', 40);

1411: if p_output_file_type ='HTML' then
1412: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1413: end if;
1414:
1415: hr_utility.set_location(gv_package_name || '.report_4', 40);
1416: /*
1417: Start of the Data Section of the Report
1418: ***/
1419:
Line 1420: -- HR_UTILITY.TRACE_ON(NULL,'TCL');

1416: /*
1417: Start of the Data Section of the Report
1418: */
1419:
1420: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
1421: open c_cursor( p_process_mode
1422: ,p_geocode_patch_name
1423: );
1424:

Line 1426: hr_utility.set_location(gv_package_name || '.report_4', 50);

1422: ,p_geocode_patch_name
1423: );
1424:
1425: loop
1426: hr_utility.set_location(gv_package_name || '.report_4', 50);
1427:
1428: fetch c_cursor into ln_full_name
1429: ,ln_assignment_id
1430: ,ln_assignment_number

Line 1438: hr_utility.set_location(gv_package_name || '.report_4', 60);

1434: ,ln_old_pri_city
1435: ,ln_table_name;
1436:
1437: if c_cursor%notfound then
1438: hr_utility.set_location(gv_package_name || '.report_4', 60);
1439: exit;
1440: end if;
1441:
1442:

Line 1448: hr_utility.set_location(gv_package_name || '.report_4', 70);

1444: If Assignment Set is used, pick up only those employee
1445: assignments which are part of the Assignment Set - STATIC
1446: or DYNAMIC.
1447: /
1448: hr_utility.set_location(gv_package_name || '.report_4', 70);
1449: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1450:
1451:
1452: hr_utility.set_location(gv_package_name || '.report_4', 80);

Line 1449: hr_utility.trace('Assignment ID = ' || ln_assignment_id);

1445: assignments which are part of the Assignment Set - STATIC
1446: or DYNAMIC.
1447: /
1448: hr_utility.set_location(gv_package_name || '.report_4', 70);
1449: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1450:
1451:
1452: hr_utility.set_location(gv_package_name || '.report_4', 80);
1453: formated_static_data( ln_full_name

Line 1452: hr_utility.set_location(gv_package_name || '.report_4', 80);

1448: hr_utility.set_location(gv_package_name || '.report_4', 70);
1449: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1450:
1451:
1452: hr_utility.set_location(gv_package_name || '.report_4', 80);
1453: formated_static_data( ln_full_name
1454: ,ln_assignment_id
1455: ,ln_assignment_number
1456: ,null

Line 1466: hr_utility.set_location(gv_package_name || '.report_4', 90);

1462: ,p_output_file_type
1463: ,lv_data_row1);
1464:
1465: lv_data_row := lv_data_row1;
1466: hr_utility.set_location(gv_package_name || '.report_4', 90);
1467:
1468: -- if p_output_file_type ='HTML' then
1469: lv_data_row := '
' || lv_data_row || '' ;
1470: -- end if;
Line 1551: hr_utility.set_location(gv_package_name || '.report_5', 10);

1547:
1548:
1549: BEGIN
1550:
1551: hr_utility.set_location(gv_package_name || '.report_5', 10);
1552:
1553: /
1554: Concatnating the second Header Label which includes the User
1555: Defined data set so that it is printed at the end of the

Line 1579: hr_utility.set_location(gv_package_name || '.report_5', 15);

1575: 'because a primary citys jurisdiction code has changed.'
1576: ,p_output_file_type
1577: ));
1578:
1579: hr_utility.set_location(gv_package_name || '.report_5', 15);
1580: /**
1581: Print the Header Information. If the format is HTML then open
1582: the body and table before printing the header info, otherwise
1583: just print the header information.

Line 1590: hr_utility.set_location(gv_package_name || '.report_5', 20);

1586: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1587: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1588: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1589: end if;
1590: hr_utility.set_location(gv_package_name || '.report_5', 20);
1591:
1592: lv_format1 :=
1593: formated_data_string (p_input_string => 'Full Name'
1594: ,p_bold => 'Y'
Line 1623: hr_utility.set_location(gv_package_name || '.report_5', 30);

1619: ,p_output_file_type => p_output_file_type)
1620: ;
1621:
1622:
1623: hr_utility.set_location(gv_package_name || '.report_5', 30);
1624:
1625:
1626: fnd_file.put_line(fnd_file.output, lv_format1);
1627:

Line 1632: hr_utility.set_location(gv_package_name || '.report_5', 40);

1628: if p_output_file_type ='HTML' then
1629: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1630: end if;
1631:
1632: hr_utility.set_location(gv_package_name || '.report_5', 40);
1633: /*
1634: Start of the Data Section of the Report
1635: ***/
1636:
Line 1637: -- HR_UTILITY.TRACE_ON(NULL,'TCL');

1633: /*
1634: Start of the Data Section of the Report
1635: */
1636:
1637: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
1638: open c_cursor( p_process_mode
1639: ,p_geocode_patch_name
1640: );
1641:

Line 1643: hr_utility.set_location(gv_package_name || '.report_5', 50);

1639: ,p_geocode_patch_name
1640: );
1641:
1642: loop
1643: hr_utility.set_location(gv_package_name || '.report_5', 50);
1644:
1645: fetch c_cursor into ln_full_name
1646: ,ln_assignment_id
1647: ,ln_assignment_number

Line 1654: hr_utility.set_location(gv_package_name || '.report_5', 60);

1650: ,ln_new_juri_code
1651: ,ln_table_name;
1652:
1653: if c_cursor%notfound then
1654: hr_utility.set_location(gv_package_name || '.report_5', 60);
1655: exit;
1656: end if;
1657:
1658:

Line 1664: hr_utility.set_location(gv_package_name || '.report_5', 70);

1660: If Assignment Set is used, pick up only those employee
1661: assignments which are part of the Assignment Set - STATIC
1662: or DYNAMIC.
1663: /
1664: hr_utility.set_location(gv_package_name || '.report_5', 70);
1665: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1666:
1667:
1668: hr_utility.set_location(gv_package_name || '.report_5', 80);

Line 1665: hr_utility.trace('Assignment ID = ' || ln_assignment_id);

1661: assignments which are part of the Assignment Set - STATIC
1662: or DYNAMIC.
1663: /
1664: hr_utility.set_location(gv_package_name || '.report_5', 70);
1665: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1666:
1667:
1668: hr_utility.set_location(gv_package_name || '.report_5', 80);
1669: formated_static_data( ln_full_name

Line 1668: hr_utility.set_location(gv_package_name || '.report_5', 80);

1664: hr_utility.set_location(gv_package_name || '.report_5', 70);
1665: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1666:
1667:
1668: hr_utility.set_location(gv_package_name || '.report_5', 80);
1669: formated_static_data( ln_full_name
1670: ,ln_assignment_id
1671: ,ln_assignment_number
1672: ,null

Line 1682: hr_utility.set_location(gv_package_name || '.report_5', 90);

1678: ,p_output_file_type
1679: ,lv_data_row1);
1680:
1681: lv_data_row := lv_data_row1;
1682: hr_utility.set_location(gv_package_name || '.report_5', 90);
1683:
1684: -- if p_output_file_type ='HTML' then
1685: lv_data_row := '
' || lv_data_row || '' ;
1686: -- end if;
Line 1774: hr_utility.set_location(gv_package_name || '.report_6', 10);

1770:
1771:
1772: BEGIN
1773:
1774: hr_utility.set_location(gv_package_name || '.report_6', 10);
1775:
1776: /
1777: Concatnating the second Header Label which includes the User
1778: Defined data set so that it is printed at the end of the

Line 1847: hr_utility.set_location(gv_package_name || '.report_6', 15);

1843: 'cities may be ignored and are listed for information only.'
1844: ,p_output_file_type
1845: ));
1846:
1847: hr_utility.set_location(gv_package_name || '.report_6', 15);
1848: /**
1849: Print the Header Information. If the format is HTML then open
1850: the body and table before printing the header info, otherwise
1851: just print the header information.

Line 1858: hr_utility.set_location(gv_package_name || '.report_6', 20);

1854: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1855: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1856: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1857: end if;
1858: hr_utility.set_location(gv_package_name || '.report_6', 20);
1859:
1860: lv_format1 :=
1861: formated_data_string (p_input_string => 'Full Name'
1862: ,p_bold => 'Y'
Line 1895: hr_utility.set_location(gv_package_name || '.report_6', 30);

1891: ,p_output_file_type => p_output_file_type)
1892: ;
1893:
1894:
1895: hr_utility.set_location(gv_package_name || '.report_6', 30);
1896:
1897:
1898: fnd_file.put_line(fnd_file.output, lv_format1);
1899:

Line 1904: hr_utility.set_location(gv_package_name || '.report_6', 40);

1900: if p_output_file_type ='HTML' then
1901: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1902: end if;
1903:
1904: hr_utility.set_location(gv_package_name || '.report_6', 40);
1905: /*
1906: Start of the Data Section of the Report
1907: ***/
1908:
Line 1909: -- HR_UTILITY.TRACE_ON(NULL,'TCL');

1905: /*
1906: Start of the Data Section of the Report
1907: */
1908:
1909: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
1910: open c_cursor( p_process_mode
1911: ,p_geocode_patch_name
1912: );
1913:

Line 1915: hr_utility.set_location(gv_package_name || '.report_6', 50);

1911: ,p_geocode_patch_name
1912: );
1913:
1914: loop
1915: hr_utility.set_location(gv_package_name || '.report_6', 50);
1916:
1917: fetch c_cursor into ln_full_name
1918: ,ln_assignment_id
1919: ,ln_assignment_number

Line 1927: hr_utility.set_location(gv_package_name || '.report_6', 60);

1923: ,ln_old_juri_code
1924: ,ln_new_juri_code;
1925:
1926: if c_cursor%notfound then
1927: hr_utility.set_location(gv_package_name || '.report_6', 60);
1928: exit;
1929: end if;
1930:
1931:

Line 1937: hr_utility.set_location(gv_package_name || '.report_6', 70);

1933: If Assignment Set is used, pick up only those employee
1934: assignments which are part of the Assignment Set - STATIC
1935: or DYNAMIC.
1936: /
1937: hr_utility.set_location(gv_package_name || '.report_6', 70);
1938: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1939:
1940:
1941: hr_utility.set_location(gv_package_name || '.report_6', 80);

Line 1938: hr_utility.trace('Assignment ID = ' || ln_assignment_id);

1934: assignments which are part of the Assignment Set - STATIC
1935: or DYNAMIC.
1936: /
1937: hr_utility.set_location(gv_package_name || '.report_6', 70);
1938: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1939:
1940:
1941: hr_utility.set_location(gv_package_name || '.report_6', 80);
1942: formated_static_data2(ln_full_name

Line 1941: hr_utility.set_location(gv_package_name || '.report_6', 80);

1937: hr_utility.set_location(gv_package_name || '.report_6', 70);
1938: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1939:
1940:
1941: hr_utility.set_location(gv_package_name || '.report_6', 80);
1942: formated_static_data2(ln_full_name
1943: ,ln_assignment_id
1944: ,ln_assignment_number
1945: ,ln_city_name

Line 1954: hr_utility.set_location(gv_package_name || '.report_6', 90);

1950: ,p_output_file_type
1951: ,lv_data_row1);
1952:
1953: lv_data_row := lv_data_row1;
1954: hr_utility.set_location(gv_package_name || '.report_6', 90);
1955:
1956: -- if p_output_file_type ='HTML' then
1957: lv_data_row := '
' || lv_data_row || '' ;
1958: -- end if;
Line 2063: hr_utility.set_location(gv_package_name || '.report_7', 10);

2059:
2060:
2061: BEGIN
2062:
2063: hr_utility.set_location(gv_package_name || '.report_7', 10);
2064:
2065: /
2066: Concatnating the second Header Label which includes the User
2067: Defined data set so that it is printed at the end of the

Line 2092: hr_utility.set_location(gv_package_name || '.report_7', 15);

2088: ,p_output_file_type
2089: ));
2090:
2091:
2092: hr_utility.set_location(gv_package_name || '.report_7', 15);
2093: /**
2094: Print the Header Information. If the format is HTML then open
2095: the body and table before printing the header info, otherwise
2096: just print the header information.

Line 2103: hr_utility.set_location(gv_package_name || '.report_7', 20);

2099: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2102: end if;
2103: hr_utility.set_location(gv_package_name || '.report_7', 20);
2104:
2105: lv_format1 :=
2106: formated_data_string (p_input_string => 'Full Name'
2107: ,p_bold => 'Y'
Line 2119: hr_utility.set_location(gv_package_name || '.report_7', 30);

2115: ,p_bold => 'Y'
2116: ,p_output_file_type => p_output_file_type)
2117: ;
2118:
2119: hr_utility.set_location(gv_package_name || '.report_7', 30);
2120:
2121:
2122: fnd_file.put_line(fnd_file.output, lv_format1);
2123:

Line 2128: hr_utility.set_location(gv_package_name || '.report_7', 40);

2124: if p_output_file_type ='HTML' then
2125: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
2126: end if;
2127:
2128: hr_utility.set_location(gv_package_name || '.report_7', 40);
2129: /*
2130: Start of the Data Section of the Report
2131: ***/
2132:
Line 2133: -- HR_UTILITY.TRACE_ON(NULL,'TCL');

2129: /*
2130: Start of the Data Section of the Report
2131: */
2132:
2133: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
2134: open c_cursor( p_process_mode
2135: ,p_geocode_patch_name
2136: );
2137:

Line 2139: hr_utility.set_location(gv_package_name || '.report_7', 50);

2135: ,p_geocode_patch_name
2136: );
2137:
2138: loop
2139: hr_utility.set_location(gv_package_name || '.report_7', 50);
2140:
2141: fetch c_cursor into ln_full_name
2142: ,ln_old_city_name
2143: ,ln_new_city_name;

Line 2146: hr_utility.set_location(gv_package_name || '.report_7', 60);

2142: ,ln_old_city_name
2143: ,ln_new_city_name;
2144:
2145: if c_cursor%notfound then
2146: hr_utility.set_location(gv_package_name || '.report_7', 60);
2147: exit;
2148: end if;
2149:
2150:

Line 2156: hr_utility.set_location(gv_package_name || '.report_7', 70);

2152: If Assignment Set is used, pick up only those employee
2153: assignments which are part of the Assignment Set - STATIC
2154: or DYNAMIC.
2155: /
2156: hr_utility.set_location(gv_package_name || '.report_7', 70);
2157:
2158: hr_utility.set_location(gv_package_name || '.report_7', 80);
2159: formated_static_data(ln_full_name
2160: ,null

Line 2158: hr_utility.set_location(gv_package_name || '.report_7', 80);

2154: or DYNAMIC.
2155: /
2156: hr_utility.set_location(gv_package_name || '.report_7', 70);
2157:
2158: hr_utility.set_location(gv_package_name || '.report_7', 80);
2159: formated_static_data(ln_full_name
2160: ,null
2161: ,null
2162: ,null

Line 2172: hr_utility.set_location(gv_package_name || '.report_7', 90);

2168: ,p_output_file_type
2169: ,lv_data_row1);
2170:
2171: lv_data_row := lv_data_row1;
2172: hr_utility.set_location(gv_package_name || '.report_7', 90);
2173:
2174: -- if p_output_file_type ='HTML' then
2175: lv_data_row := '
' || lv_data_row || '' ;
2176: -- end if;
Line 2234: hr_utility.set_location(gv_package_name || '.report_8', 10);

2230:
2231:
2232: BEGIN
2233:
2234: hr_utility.set_location(gv_package_name || '.report_8', 10);
2235:
2236: /
2237: Concatnating the second Header Label which includes the User
2238: Defined data set so that it is printed at the end of the

Line 2258: hr_utility.set_location(gv_package_name || '.report_8', 15);

2254: ,p_output_file_type
2255: ));
2256:
2257:
2258: hr_utility.set_location(gv_package_name || '.report_8', 15);
2259: /****
2260: Print the Header Information. If the format is HTML then open
2261: the body and table before printing the header info, otherwise
2262: just print the header information.

Line 2269: hr_utility.set_location(gv_package_name || '.report_8', 20);

2265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2266: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2268: end if;
2269: hr_utility.set_location(gv_package_name || '.report_8', 20);
2270:
2271: lv_format1 :=
2272: formated_data_string (p_input_string => 'Old User Defined JD'
2273: ,p_bold => 'Y'
Line 2285: hr_utility.set_location(gv_package_name || '.report_8', 30);

2281: ,p_bold => 'Y'
2282: ,p_output_file_type => p_output_file_type)
2283: ;
2284:
2285: hr_utility.set_location(gv_package_name || '.report_8', 30);
2286:
2287:
2288: fnd_file.put_line(fnd_file.output, lv_format1);
2289:

Line 2294: hr_utility.set_location(gv_package_name || '.report_8', 40);

2290: if p_output_file_type ='HTML' then
2291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
2292: end if;
2293:
2294: hr_utility.set_location(gv_package_name || '.report_8', 40);
2295: /*
2296: Start of the Data Section of the Report
2297: ***/
2298:
Line 2299: -- HR_UTILITY.TRACE_ON(NULL,'TCL');

2295: /*
2296: Start of the Data Section of the Report
2297: */
2298:
2299: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
2300: open c_cursor( p_process_mode
2301: ,p_geocode_patch_name
2302: );
2303:

Line 2305: hr_utility.set_location(gv_package_name || '.report_8', 50);

2301: ,p_geocode_patch_name
2302: );
2303:
2304: loop
2305: hr_utility.set_location(gv_package_name || '.report_8', 50);
2306:
2307: fetch c_cursor into ln_old_juri_code
2308: ,ln_new_juri_code
2309: ,ln_city_name;

Line 2312: hr_utility.set_location(gv_package_name || '.report_8', 60);

2308: ,ln_new_juri_code
2309: ,ln_city_name;
2310:
2311: if c_cursor%notfound then
2312: hr_utility.set_location(gv_package_name || '.report_8', 60);
2313: exit;
2314: end if;
2315:
2316:

Line 2322: hr_utility.set_location(gv_package_name || '.report_8', 70);

2318: If Assignment Set is used, pick up only those employee
2319: assignments which are part of the Assignment Set - STATIC
2320: or DYNAMIC.
2321: /
2322: hr_utility.set_location(gv_package_name || '.report_8', 70);
2323:
2324: hr_utility.set_location(gv_package_name || '.report_8', 80);
2325: formated_static_data( null
2326: ,null

Line 2324: hr_utility.set_location(gv_package_name || '.report_8', 80);

2320: or DYNAMIC.
2321: /
2322: hr_utility.set_location(gv_package_name || '.report_8', 70);
2323:
2324: hr_utility.set_location(gv_package_name || '.report_8', 80);
2325: formated_static_data( null
2326: ,null
2327: ,null
2328: ,ln_old_juri_code -- Intentional see report format

Line 2338: hr_utility.set_location(gv_package_name || '.report_8', 90);

2334: ,p_output_file_type
2335: ,lv_data_row1);
2336:
2337: lv_data_row := lv_data_row1;
2338: hr_utility.set_location(gv_package_name || '.report_8', 90);
2339:
2340: -- if p_output_file_type ='HTML' then
2341: lv_data_row := '
' || lv_data_row || '' ;
2342: -- end if;
Line 2422: hr_utility.set_location(gv_package_name || '.report_9', 10);

2418:
2419:
2420: BEGIN
2421:
2422: hr_utility.set_location(gv_package_name || '.report_9', 10);
2423:
2424: /
2425: Concatnating the second Header Label which includes the User
2426: Defined data set so that it is printed at the end of the

Line 2451: hr_utility.set_location(gv_package_name || '.report_9', 15);

2447: ,p_output_file_type
2448: ));
2449:
2450:
2451: hr_utility.set_location(gv_package_name || '.report_9', 15);
2452: /****
2453: Print the Header Information. If the format is HTML then open
2454: the body and table before printing the header info, otherwise
2455: just print the header information.

Line 2462: hr_utility.set_location(gv_package_name || '.report_9', 20);

2458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2459: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2460: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2461: end if;
2462: hr_utility.set_location(gv_package_name || '.report_9', 20);
2463:
2464: lv_format1 :=
2465: formated_data_string (p_input_string => 'Full Name'
2466: ,p_bold => 'Y'
Line 2485: hr_utility.set_location(gv_package_name || '.report_9', 30);

2481: formated_data_string (p_input_string => 'Jurisdiction Code'
2482: ,p_bold => 'Y'
2483: ,p_output_file_type => p_output_file_type) ;
2484:
2485: hr_utility.set_location(gv_package_name || '.report_9', 30);
2486:
2487:
2488: fnd_file.put_line(fnd_file.output, lv_format1);
2489:

Line 2494: hr_utility.set_location(gv_package_name || '.report_9', 40);

2490: if p_output_file_type ='HTML' then
2491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
2492: end if;
2493:
2494: hr_utility.set_location(gv_package_name || '.report_9', 40);
2495: /*
2496: Start of the Data Section of the Report
2497: ***/
2498:
Line 2499: -- HR_UTILITY.TRACE_ON(NULL,'TCL');

2495: /*
2496: Start of the Data Section of the Report
2497: */
2498:
2499: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
2500: open c_cursor( p_process_mode
2501: ,p_geocode_patch_name
2502: );
2503:

Line 2505: hr_utility.set_location(gv_package_name || '.report_9', 50);

2501: ,p_geocode_patch_name
2502: );
2503:
2504: loop
2505: hr_utility.set_location(gv_package_name || '.report_9', 50);
2506:
2507: fetch c_cursor into ln_full_name
2508: ,ln_assignment_id
2509: ,ln_assignment_number

Line 2514: hr_utility.set_location(gv_package_name || '.report_9', 60);

2510: ,ln_city_name
2511: ,ln_jd_code;
2512:
2513: if c_cursor%notfound then
2514: hr_utility.set_location(gv_package_name || '.report_9', 60);
2515: exit;
2516: end if;
2517:
2518:

Line 2524: hr_utility.set_location(gv_package_name || '.report_9', 70);

2520: If Assignment Set is used, pick up only those employee
2521: assignments which are part of the Assignment Set - STATIC
2522: or DYNAMIC.
2523: /
2524: hr_utility.set_location(gv_package_name || '.report_9', 70);
2525: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
2526:
2527:
2528: hr_utility.set_location(gv_package_name || '.report_9', 80);

Line 2525: hr_utility.trace('Assignment ID = ' || ln_assignment_id);

2521: assignments which are part of the Assignment Set - STATIC
2522: or DYNAMIC.
2523: /
2524: hr_utility.set_location(gv_package_name || '.report_9', 70);
2525: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
2526:
2527:
2528: hr_utility.set_location(gv_package_name || '.report_9', 80);
2529: formated_static_data( ln_full_name

Line 2528: hr_utility.set_location(gv_package_name || '.report_9', 80);

2524: hr_utility.set_location(gv_package_name || '.report_9', 70);
2525: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
2526:
2527:
2528: hr_utility.set_location(gv_package_name || '.report_9', 80);
2529: formated_static_data( ln_full_name
2530: ,ln_assignment_id
2531: ,ln_assignment_number
2532: ,null

Line 2542: hr_utility.set_location(gv_package_name || '.report_9', 90);

2538: ,p_output_file_type
2539: ,lv_data_row1);
2540:
2541: lv_data_row := lv_data_row1;
2542: hr_utility.set_location(gv_package_name || '.report_9', 90);
2543:
2544: -- if p_output_file_type ='HTML' then
2545: lv_data_row := '
' || lv_data_row || '' ;
2546: -- end if;
Line 2627: hr_utility.set_location(gv_package_name || '.report_10', 10);

2623:
2624:
2625: BEGIN
2626:
2627: hr_utility.set_location(gv_package_name || '.report_10', 10);
2628:
2629: /
2630: Concatnating the second Header Label which includes the User
2631: Defined data set so that it is printed at the end of the

Line 2661: hr_utility.set_location(gv_package_name || '.report_10', 15);

2657: ,p_output_file_type
2658: ));
2659:
2660:
2661: hr_utility.set_location(gv_package_name || '.report_10', 15);
2662: /**
2663: Print the Header Information. If the format is HTML then open
2664: the body and table before printing the header info, otherwise
2665: just print the header information.

Line 2672: hr_utility.set_location(gv_package_name || '.report_10', 20);

2668: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2669: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2670: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2671: end if;
2672: hr_utility.set_location(gv_package_name || '.report_10', 20);
2673:
2674: lv_format1 :=
2675: formated_data_string (p_input_string => 'Full Name'
2676: ,p_bold => 'Y'
Line 2695: hr_utility.set_location(gv_package_name || '.report_10', 30);

2691: formated_data_string (p_input_string => 'Jurisdiction Code'
2692: ,p_bold => 'Y'
2693: ,p_output_file_type => p_output_file_type) ;
2694:
2695: hr_utility.set_location(gv_package_name || '.report_10', 30);
2696:
2697:
2698: fnd_file.put_line(fnd_file.output, lv_format1);
2699:

Line 2704: hr_utility.set_location(gv_package_name || '.report_10', 40);

2700: if p_output_file_type ='HTML' then
2701: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
2702: end if;
2703:
2704: hr_utility.set_location(gv_package_name || '.report_10', 40);
2705: /*
2706: Start of the Data Section of the Report
2707: ***/
2708:
Line 2709: -- HR_UTILITY.TRACE_ON(NULL,'TCL');

2705: /*
2706: Start of the Data Section of the Report
2707: */
2708:
2709: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
2710: open c_cursor( p_process_mode
2711: ,p_geocode_patch_name
2712: );
2713:

Line 2715: hr_utility.set_location(gv_package_name || '.report_10', 50);

2711: ,p_geocode_patch_name
2712: );
2713:
2714: loop
2715: hr_utility.set_location(gv_package_name || '.report_10', 50);
2716:
2717: fetch c_cursor into ln_full_name
2718: ,ln_assignment_id
2719: ,ln_assignment_number

Line 2724: hr_utility.set_location(gv_package_name || '.report_10', 60);

2720: ,ln_city_name
2721: ,ln_jd_code;
2722:
2723: if c_cursor%notfound then
2724: hr_utility.set_location(gv_package_name || '.report_10', 60);
2725: exit;
2726: end if;
2727:
2728:

Line 2734: hr_utility.set_location(gv_package_name || '.report_10', 70);

2730: If Assignment Set is used, pick up only those employee
2731: assignments which are part of the Assignment Set - STATIC
2732: or DYNAMIC.
2733: /
2734: hr_utility.set_location(gv_package_name || '.report_10', 70);
2735: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
2736:
2737:
2738: hr_utility.set_location(gv_package_name || '.report_10', 80);

Line 2735: hr_utility.trace('Assignment ID = ' || ln_assignment_id);

2731: assignments which are part of the Assignment Set - STATIC
2732: or DYNAMIC.
2733: /
2734: hr_utility.set_location(gv_package_name || '.report_10', 70);
2735: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
2736:
2737:
2738: hr_utility.set_location(gv_package_name || '.report_10', 80);
2739: formated_static_data( ln_full_name

Line 2738: hr_utility.set_location(gv_package_name || '.report_10', 80);

2734: hr_utility.set_location(gv_package_name || '.report_10', 70);
2735: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
2736:
2737:
2738: hr_utility.set_location(gv_package_name || '.report_10', 80);
2739: formated_static_data( ln_full_name
2740: ,ln_assignment_id
2741: ,ln_assignment_number
2742: ,null

Line 2752: hr_utility.set_location(gv_package_name || '.report_10', 90);

2748: ,p_output_file_type
2749: ,lv_data_row1);
2750:
2751: lv_data_row := lv_data_row1;
2752: hr_utility.set_location(gv_package_name || '.report_10', 90);
2753:
2754: -- if p_output_file_type ='HTML' then
2755: lv_data_row := '
' || lv_data_row || '' ;
2756: -- end if;
Line 2818: hr_utility.set_location(gv_package_name || '.report_11', 10);

2814:
2815:
2816: BEGIN
2817:
2818: hr_utility.set_location(gv_package_name || '.report_11', 10);
2819:
2820: /
2821: Concatnating the second Header Label which includes the User
2822: Defined data set so that it is printed at the end of the

Line 2836: hr_utility.set_location(gv_package_name || '.report_11', 15);

2832: 'The taxability rules have been changed for the following jurisdiction codes to reflect the new jurisdiction code.'
2833: ,p_output_file_type
2834: ));
2835:
2836: hr_utility.set_location(gv_package_name || '.report_11', 15);
2837: /**
2838: Print the Header Information. If the format is HTML then open
2839: the body and table before printing the header info, otherwise
2840: just print the header information.

Line 2847: hr_utility.set_location(gv_package_name || '.report_11', 20);

2843: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2844: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2845: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2846: end if;
2847: hr_utility.set_location(gv_package_name || '.report_11', 20);
2848:
2849: lv_format1 :=
2850: formated_data_string (p_input_string => 'Old JD'
2851: ,p_bold => 'Y'
Line 2859: hr_utility.set_location(gv_package_name || '.report_11', 30);

2855: ,p_bold => 'Y'
2856: ,p_output_file_type => p_output_file_type)
2857: ;
2858:
2859: hr_utility.set_location(gv_package_name || '.report_11', 30);
2860:
2861:
2862: fnd_file.put_line(fnd_file.output, lv_format1);
2863:

Line 2868: hr_utility.set_location(gv_package_name || '.report_11', 40);

2864: if p_output_file_type ='HTML' then
2865: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
2866: end if;
2867:
2868: hr_utility.set_location(gv_package_name || '.report_11', 40);
2869: /*
2870: Start of the Data Section of the Report
2871: ***/
2872:
Line 2873: -- HR_UTILITY.TRACE_ON(NULL,'TCL');

2869: /*
2870: Start of the Data Section of the Report
2871: */
2872:
2873: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
2874: open c_cursor( p_process_mode
2875: ,p_geocode_patch_name
2876: );
2877:

Line 2879: hr_utility.set_location(gv_package_name || '.report_11', 50);

2875: ,p_geocode_patch_name
2876: );
2877:
2878: loop
2879: hr_utility.set_location(gv_package_name || '.report_11', 50);
2880:
2881: fetch c_cursor into ln_old_jd_code
2882: ,ln_new_jd_code;
2883:

Line 2885: hr_utility.set_location(gv_package_name || '.report_11', 60);

2881: fetch c_cursor into ln_old_jd_code
2882: ,ln_new_jd_code;
2883:
2884: if c_cursor%notfound then
2885: hr_utility.set_location(gv_package_name || '.report_11', 60);
2886: exit;
2887: end if;
2888:
2889:

Line 2895: hr_utility.set_location(gv_package_name || '.report_11', 70);

2891: If Assignment Set is used, pick up only those employee
2892: assignments which are part of the Assignment Set - STATIC
2893: or DYNAMIC.
2894: /
2895: hr_utility.set_location(gv_package_name || '.report_11', 70);
2896:
2897: hr_utility.set_location(gv_package_name || '.report_11', 80);
2898: formated_static_data( null
2899: ,null

Line 2897: hr_utility.set_location(gv_package_name || '.report_11', 80);

2893: or DYNAMIC.
2894: /
2895: hr_utility.set_location(gv_package_name || '.report_11', 70);
2896:
2897: hr_utility.set_location(gv_package_name || '.report_11', 80);
2898: formated_static_data( null
2899: ,null
2900: ,null
2901: ,ln_old_jd_code

Line 2911: hr_utility.set_location(gv_package_name || '.report_11', 90);

2907: ,p_output_file_type
2908: ,lv_data_row1);
2909:
2910: lv_data_row := lv_data_row1;
2911: hr_utility.set_location(gv_package_name || '.report_11', 90);
2912:
2913: -- if p_output_file_type ='HTML' then
2914: lv_data_row := '
' || lv_data_row || '' ;
2915: -- end if;
Line 3020: hr_utility.set_location(gv_package_name || '.report_12', 10);

3016:
3017:
3018: BEGIN
3019:
3020: hr_utility.set_location(gv_package_name || '.report_12', 10);
3021:
3022: /
3023: Concatnating the second Header Label which includes the User
3024: Defined data set so that it is printed at the end of the

Line 3059: hr_utility.set_location(gv_package_name || '.report_12', 15);

3055: ,p_output_file_type
3056: ));
3057:
3058:
3059: hr_utility.set_location(gv_package_name || '.report_12', 15);
3060: /****
3061: Print the Header Information. If the format is HTML then open
3062: the body and table before printing the header info, otherwise
3063: just print the header information.

Line 3070: hr_utility.set_location(gv_package_name || '.report_12', 20);

3066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3067: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3068: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3069: end if;
3070: hr_utility.set_location(gv_package_name || '.report_12', 20);
3071:
3072: lv_format1 :=
3073: formated_data_string (p_input_string => 'Full Name'
3074: ,p_bold => 'Y'
Line 3105: hr_utility.set_location(gv_package_name || '.report_12', 30);

3101: formated_data_string (p_input_string => 'City Name'
3102: ,p_bold => 'Y'
3103: ,p_output_file_type => p_output_file_type) ;
3104:
3105: hr_utility.set_location(gv_package_name || '.report_12', 30);
3106:
3107:
3108: fnd_file.put_line(fnd_file.output, lv_format1);
3109:

Line 3114: hr_utility.set_location(gv_package_name || '.report_12', 40);

3110: if p_output_file_type ='HTML' then
3111: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
3112: end if;
3113:
3114: hr_utility.set_location(gv_package_name || '.report_12', 40);
3115: /*
3116: Start of the Data Section of the Report
3117: ***/
3118:
Line 3119: -- HR_UTILITY.TRACE_ON(NULL,'TCL');

3115: /*
3116: Start of the Data Section of the Report
3117: */
3118:
3119: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
3120: open c_cursor( p_process_mode
3121: ,p_geocode_patch_name
3122: );
3123:

Line 3125: hr_utility.set_location(gv_package_name || '.report_12', 50);

3121: ,p_geocode_patch_name
3122: );
3123:
3124: loop
3125: hr_utility.set_location(gv_package_name || '.report_12', 50);
3126:
3127: fetch c_cursor into ln_full_name
3128: ,ln_assignment_id
3129: ,ln_assignment_number

Line 3137: hr_utility.set_location(gv_package_name || '.report_12', 60);

3133: ,ln_new_juri_code
3134: ,ln_new_county;
3135:
3136: if c_cursor%notfound then
3137: hr_utility.set_location(gv_package_name || '.report_12', 60);
3138: exit;
3139: end if;
3140:
3141:

Line 3147: hr_utility.set_location(gv_package_name || '.report_12', 70);

3143: If Assignment Set is used, pick up only those employee
3144: assignments which are part of the Assignment Set - STATIC
3145: or DYNAMIC.
3146: /
3147: hr_utility.set_location(gv_package_name || '.report_12', 70);
3148: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
3149:
3150:
3151: hr_utility.set_location(gv_package_name || '.report_12', 80);

Line 3148: hr_utility.trace('Assignment ID = ' || ln_assignment_id);

3144: assignments which are part of the Assignment Set - STATIC
3145: or DYNAMIC.
3146: /
3147: hr_utility.set_location(gv_package_name || '.report_12', 70);
3148: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
3149:
3150:
3151: hr_utility.set_location(gv_package_name || '.report_12', 80);
3152: formated_static_data( ln_full_name

Line 3151: hr_utility.set_location(gv_package_name || '.report_12', 80);

3147: hr_utility.set_location(gv_package_name || '.report_12', 70);
3148: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
3149:
3150:
3151: hr_utility.set_location(gv_package_name || '.report_12', 80);
3152: formated_static_data( ln_full_name
3153: ,ln_assignment_id
3154: ,ln_assignment_number
3155: ,null

Line 3165: hr_utility.set_location(gv_package_name || '.report_12', 90);

3161: ,p_output_file_type
3162: ,lv_data_row1);
3163:
3164: lv_data_row := lv_data_row1;
3165: hr_utility.set_location(gv_package_name || '.report_12', 90);
3166:
3167: -- if p_output_file_type ='HTML' then
3168: lv_data_row := '
' || lv_data_row || '' ;
3169: -- end if;
Line 3244: hr_utility.set_location(gv_package_name || '.report_13', 10);

3240:
3241:
3242: BEGIN
3243:
3244: hr_utility.set_location(gv_package_name || '.report_13', 10);
3245:
3246: /
3247: Concatnating the second Header Label which includes the User
3248: Defined data set so that it is printed at the end of the

Line 3268: hr_utility.set_location(gv_package_name || '.report_13', 15);

3264: ,p_output_file_type
3265: ));
3266:
3267:
3268: hr_utility.set_location(gv_package_name || '.report_13', 15);
3269: /**
3270: Print the Header Information. If the format is HTML then open
3271: the body and table before printing the header info, otherwise
3272: just print the header information.

Line 3279: hr_utility.set_location(gv_package_name || '.report_13', 20);

3275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3278: end if;
3279: hr_utility.set_location(gv_package_name || '.report_13', 20);
3280:
3281: lv_format1 :=
3282: formated_data_string (p_input_string => 'Table Name'
3283: ,p_bold => 'Y'
Line 3291: hr_utility.set_location(gv_package_name || '.report_13', 30);

3287: ,p_bold => 'Y'
3288: ,p_output_file_type => p_output_file_type)
3289: ;
3290:
3291: hr_utility.set_location(gv_package_name || '.report_13', 30);
3292:
3293:
3294: fnd_file.put_line(fnd_file.output, lv_format1);
3295:

Line 3300: hr_utility.set_location(gv_package_name || '.report_13', 40);

3296: if p_output_file_type ='HTML' then
3297: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
3298: end if;
3299:
3300: hr_utility.set_location(gv_package_name || '.report_13', 40);
3301: /*
3302: Start of the Data Section of the Report
3303: ***/
3304:
Line 3305: hr_utility.set_location(gv_package_name || '.report_13', 50);

3301: /*
3302: Start of the Data Section of the Report
3303: */
3304:
3305: hr_utility.set_location(gv_package_name || '.report_13', 50);
3306:
3307: /
3308: If Assignment Set is used, pick up only those employee
3309: assignments which are part of the Assignment Set - STATIC

Line 3313: hr_utility.set_location(gv_package_name || '.report_13', 60);

3309: assignments which are part of the Assignment Set - STATIC
3310: or DYNAMIC.
3311: /
3312:
3313: hr_utility.set_location(gv_package_name || '.report_13', 60);
3314:
3315: -- count for pay_us_states --
3316:
3317: ln_row_count := 0;

Line 3337: hr_utility.set_location(gv_package_name || '.report_13', 65);

3333: ,lv_data_row1);
3334:
3335:
3336: lv_data_row := lv_data_row1;
3337: hr_utility.set_location(gv_package_name || '.report_13', 65);
3338:
3339: lv_data_row := '
' || lv_data_row || '' ;
3340:
3341: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
Line 3365: hr_utility.set_location(gv_package_name || '.report_13', 70);

3361: ,lv_data_row1);
3362:
3363:
3364: lv_data_row := lv_data_row1;
3365: hr_utility.set_location(gv_package_name || '.report_13', 70);
3366:
3367: lv_data_row := '
' || lv_data_row || '' ;
3368:
3369: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
Line 3392: hr_utility.set_location(gv_package_name || '.report_13', 75);

3388: ,p_output_file_type
3389: ,lv_data_row1);
3390:
3391: lv_data_row := lv_data_row1;
3392: hr_utility.set_location(gv_package_name || '.report_13', 75);
3393:
3394: lv_data_row := '
' || lv_data_row || '' ;
3395:
3396: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
Line 3419: hr_utility.set_location(gv_package_name || '.report_13', 80);

3415: ,p_output_file_type
3416: ,lv_data_row1);
3417:
3418: lv_data_row := lv_data_row1;
3419: hr_utility.set_location(gv_package_name || '.report_13', 80);
3420:
3421: lv_data_row := '
' || lv_data_row || '' ;
3422:
3423: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
Line 3446: hr_utility.set_location(gv_package_name || '.report_13', 85);

3442: ,p_output_file_type
3443: ,lv_data_row1);
3444:
3445: lv_data_row := lv_data_row1;
3446: hr_utility.set_location(gv_package_name || '.report_13', 85);
3447:
3448: lv_data_row := '
' || lv_data_row || '' ;
3449:
3450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
Line 3473: hr_utility.set_location(gv_package_name || '.report_13', 90);

3469: ,p_output_file_type
3470: ,lv_data_row1);
3471:
3472: lv_data_row := lv_data_row1;
3473: hr_utility.set_location(gv_package_name || '.report_13', 90);
3474:
3475: lv_data_row := '
' || lv_data_row || '' ;
3476:
3477: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
Line 3612: hr_utility.set_location(gv_package_name || '.report_14', 10);

3608:
3609:
3610: BEGIN
3611:
3612: hr_utility.set_location(gv_package_name || '.report_14', 10);
3613:
3614: /
3615: Concatnating the second Header Label which includes the User
3616: Defined data set so that it is printed at the end of the

Line 3646: hr_utility.set_location(gv_package_name || '.report_14', 15);

3642: ,p_output_file_type
3643: ));
3644:
3645:
3646: hr_utility.set_location(gv_package_name || '.report_14', 15);
3647: /****
3648: Print the Header Information. If the format is HTML then open
3649: the body and table before printing the header info, otherwise
3650: just print the header information.

Line 3657: hr_utility.set_location(gv_package_name || '.report_14', 20);

3653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3654: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3655: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3656: end if;
3657: hr_utility.set_location(gv_package_name || '.report_14', 20);
3658:
3659: lv_format1 :=
3660: formated_data_string (p_input_string => 'Work Location'
3661: ,p_bold => 'Y'
Line 3689: hr_utility.set_location(gv_package_name || '.report_14', 30);

3685: ,p_bold => 'Y'
3686: ,p_output_file_type => p_output_file_type)
3687: ;
3688:
3689: hr_utility.set_location(gv_package_name || '.report_14', 30);
3690:
3691:
3692: fnd_file.put_line(fnd_file.output, lv_format1);
3693:

Line 3698: hr_utility.set_location(gv_package_name || '.report_14', 40);

3694: if p_output_file_type ='HTML' then
3695: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
3696: end if;
3697:
3698: hr_utility.set_location(gv_package_name || '.report_14', 40);
3699: /*
3700: Start of the Data Section of the Report
3701: ***/
3702:
Line 3703: -- HR_UTILITY.TRACE_ON(NULL,'TCL');

3699: /*
3700: Start of the Data Section of the Report
3701: */
3702:
3703: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
3704: open c_cursor( p_process_mode
3705: ,p_geocode_patch_name
3706: );
3707:

Line 3709: hr_utility.set_location(gv_package_name || '.report_14', 50);

3705: ,p_geocode_patch_name
3706: );
3707:
3708: loop
3709: hr_utility.set_location(gv_package_name || '.report_14', 50);
3710:
3711: fetch c_cursor into ln_work_location
3712: ,ln_loc_description
3713: ,ln_address

Line 3720: hr_utility.set_location(gv_package_name || '.report_14', 60);

3716: ,ln_state
3717: ,ln_zip_code;
3718:
3719: if c_cursor%notfound then
3720: hr_utility.set_location(gv_package_name || '.report_14', 60);
3721: exit;
3722: end if;
3723:
3724:

Line 3730: hr_utility.set_location(gv_package_name || '.report_14', 70);

3726: If Assignment Set is used, pick up only those employee
3727: assignments which are part of the Assignment Set - STATIC
3728: or DYNAMIC.
3729: /
3730: hr_utility.set_location(gv_package_name || '.report_14', 70);
3731: --Modified for AGEO2010 such that the Data of Location is shown in same order
3732: --as indicated in Header Record.Also updated loc_description such that a space
3733: --will be printed in case it is left blank.
3734: hr_utility.set_location(gv_package_name || '.report_14', 80);

Line 3734: hr_utility.set_location(gv_package_name || '.report_14', 80);

3730: hr_utility.set_location(gv_package_name || '.report_14', 70);
3731: --Modified for AGEO2010 such that the Data of Location is shown in same order
3732: --as indicated in Header Record.Also updated loc_description such that a space
3733: --will be printed in case it is left blank.
3734: hr_utility.set_location(gv_package_name || '.report_14', 80);
3735: formated_static_data( ln_work_location
3736: ,null
3737: ,nvl(ln_loc_description,' ')
3738: ,ln_address

Line 3749: hr_utility.set_location(gv_package_name || '.report_14', 90);

3745: ,p_output_file_type
3746: ,lv_data_row1);
3747:
3748: lv_data_row := lv_data_row1;
3749: hr_utility.set_location(gv_package_name || '.report_14', 90);
3750:
3751: -- if p_output_file_type ='HTML' then
3752: lv_data_row := '
' || lv_data_row || '' ;
3753: -- end if;
Line 3893: hr_utility.set_location(gv_package_name || '.report_15', 10);

3889:
3890:
3891: BEGIN
3892:
3893: hr_utility.set_location(gv_package_name || '.report_15', 10);
3894:
3895: /
3896: Concatnating the second Header Label which includes the User
3897: Defined data set so that it is printed at the end of the

Line 3927: hr_utility.set_location(gv_package_name || '.report_15', 15);

3923: ,p_output_file_type
3924: ));
3925:
3926:
3927: hr_utility.set_location(gv_package_name || '.report_15', 15);
3928: /**
3929: Print the Header Information. If the format is HTML then open
3930: the body and table before printing the header info, otherwise
3931: just print the header information.

Line 3938: hr_utility.set_location(gv_package_name || '.report_15', 20);

3934: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3935: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3937: end if;
3938: hr_utility.set_location(gv_package_name || '.report_15', 20);
3939:
3940: lv_format1 :=
3941: formated_data_string (p_input_string => 'Full Name'
3942: ,p_bold => 'Y'
Line 3966: hr_utility.set_location(gv_package_name || '.report_15', 30);

3962: ,p_bold => 'Y'
3963: ,p_output_file_type => p_output_file_type)
3964: ;
3965:
3966: hr_utility.set_location(gv_package_name || '.report_15', 30);
3967:
3968:
3969: fnd_file.put_line(fnd_file.output, lv_format1);
3970:

Line 3975: hr_utility.set_location(gv_package_name || '.report_15', 40);

3971: if p_output_file_type ='HTML' then
3972: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
3973: end if;
3974:
3975: hr_utility.set_location(gv_package_name || '.report_15', 40);
3976: /*
3977: Start of the Data Section of the Report
3978: ***/
3979:
Line 3980: -- HR_UTILITY.TRACE_ON(NULL,'TCL');

3976: /*
3977: Start of the Data Section of the Report
3978: */
3979:
3980: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
3981: open c_cursor( p_process_mode
3982: ,p_geocode_patch_name
3983: );
3984:

Line 3986: hr_utility.set_location(gv_package_name || '.report_15', 50);

3982: ,p_geocode_patch_name
3983: );
3984:
3985: loop
3986: hr_utility.set_location(gv_package_name || '.report_15', 50);
3987:
3988: fetch c_cursor into ln_full_name
3989: ,ln_address
3990: ,ln_city_name

Line 3996: hr_utility.set_location(gv_package_name || '.report_15', 60);

3992: ,ln_state
3993: ,ln_zip_code;
3994:
3995: if c_cursor%notfound then
3996: hr_utility.set_location(gv_package_name || '.report_15', 60);
3997: exit;
3998: end if;
3999:
4000:

Line 4006: hr_utility.set_location(gv_package_name || '.report_15', 70);

4002: If Assignment Set is used, pick up only those employee
4003: assignments which are part of the Assignment Set - STATIC
4004: or DYNAMIC.
4005: /
4006: hr_utility.set_location(gv_package_name || '.report_15', 70);
4007:
4008: hr_utility.set_location(gv_package_name || '.report_15', 80);
4009: formated_static_data( ln_full_name
4010: ,null

Line 4008: hr_utility.set_location(gv_package_name || '.report_15', 80);

4004: or DYNAMIC.
4005: ************************/
4006: hr_utility.set_location(gv_package_name || '.report_15', 70);
4007:
4008: hr_utility.set_location(gv_package_name || '.report_15', 80);
4009: formated_static_data( ln_full_name
4010: ,null
4011: ,ln_address
4012: ,ln_city_name

Line 4022: hr_utility.set_location(gv_package_name || '.report_15', 90);

4018: ,p_output_file_type
4019: ,lv_data_row1);
4020:
4021: lv_data_row := lv_data_row1;
4022: hr_utility.set_location(gv_package_name || '.report_15', 90);
4023:
4024: -- if p_output_file_type ='HTML' then
4025: lv_data_row := '
' || lv_data_row || '' ;
4026: -- end if;
Line 4260: hr_utility.set_location(gv_package_name || '.report_16', 10);

4256: lv_format1 varchar2(32000);
4257:
4258: BEGIN
4259:
4260: hr_utility.set_location(gv_package_name || '.report_16', 10);
4261:
4262: fnd_file.put_line(fnd_file.output, formated_header_string(
4263: 'XVI. City Name Change'
4264: ,p_output_file_type

Line 4277: hr_utility.set_location(gv_package_name || '.report_16', 15);

4273: 'The following are the City Name changes.'
4274: ,p_output_file_type
4275: ));
4276:
4277: hr_utility.set_location(gv_package_name || '.report_16', 15);
4278:
4279: /Start of City Name change details section /
4280:
4281: if p_output_file_type ='HTML' then

Line 4287: hr_utility.set_location(gv_package_name || '.report_16', 20);

4283: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
4284: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4285: end if;
4286:
4287: hr_utility.set_location(gv_package_name || '.report_16', 20);
4288:
4289: lv_format1 :=
4290: formated_data_string (p_input_string => 'Country'
4291: ,p_bold => 'Y'
Line 4319: hr_utility.set_location(gv_package_name || '.report_16', 25);

4315: ,p_bold => 'Y'
4316: ,p_output_file_type => p_output_file_type)
4317: ;
4318:
4319: hr_utility.set_location(gv_package_name || '.report_16', 25);
4320:
4321: fnd_file.put_line(fnd_file.output, lv_format1);
4322:
4323: if p_output_file_type ='HTML' then

Line 4331: hr_utility.set_location(gv_package_name || '.report_16', 30);

4327: /*************************
4328: Start of the Data Section
4329: /
4330:
4331: hr_utility.set_location(gv_package_name || '.report_16', 30);
4332:
4333: open c_city_name_change( p_geocode_patch_name);
4334:
4335: loop

Line 4337: hr_utility.set_location(gv_package_name || '.report_16', 35);

4333: open c_city_name_change( p_geocode_patch_name);
4334:
4335: loop
4336:
4337: hr_utility.set_location(gv_package_name || '.report_16', 35);
4338:
4339: fetch c_city_name_change into ln_city_name_change;
4340:
4341: if c_city_name_change%notfound then

Line 4342: hr_utility.set_location(gv_package_name || '.report_16', 40);

4338:
4339: fetch c_city_name_change into ln_city_name_change;
4340:
4341: if c_city_name_change%notfound then
4342: hr_utility.set_location(gv_package_name || '.report_16', 40);
4343: exit;
4344: end if;
4345:
4346: hr_utility.set_location(gv_package_name || '.report_16', 50);

Line 4346: hr_utility.set_location(gv_package_name || '.report_16', 50);

4342: hr_utility.set_location(gv_package_name || '.report_16', 40);
4343: exit;
4344: end if;
4345:
4346: hr_utility.set_location(gv_package_name || '.report_16', 50);
4347:
4348: formated_static_data3( ln_city_name_change.country
4349: ,ln_city_name_change.state_code
4350: ,ln_city_name_change.state_abbrev

Line 4360: hr_utility.set_location(gv_package_name || '.report_16', 60);

4356: ,lv_data_row1);
4357:
4358: lv_data_row := lv_data_row1;
4359:
4360: hr_utility.set_location(gv_package_name || '.report_16', 60);
4361:
4362: lv_data_row := '
' || lv_data_row || '' ;
4363:
4364: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
Line 4395: hr_utility.set_location(gv_package_name || '.report_16', 70);

4391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
4392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4393: end if;
4394:
4395: hr_utility.set_location(gv_package_name || '.report_16', 70);
4396:
4397: lv_format1 :=
4398: formated_data_string (p_input_string => 'Full Name'
4399: ,p_bold => 'Y'
Line 4427: hr_utility.set_location(gv_package_name || '.report_16', 80);

4423: ,p_bold => 'Y'
4424: ,p_output_file_type => p_output_file_type)
4425: ;
4426:
4427: hr_utility.set_location(gv_package_name || '.report_16', 80);
4428:
4429: fnd_file.put_line(fnd_file.output, lv_format1);
4430:
4431: if p_output_file_type ='HTML' then

Line 4435: hr_utility.set_location(gv_package_name || '.report_16', 90);

4431: if p_output_file_type ='HTML' then
4432: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
4433: end if;
4434:
4435: hr_utility.set_location(gv_package_name || '.report_16', 90);
4436:
4437: /
4438: Start of the Data Section
4439: ***/
Line 4446: hr_utility.set_location(gv_package_name || '.report_16', 100);

4442: ,p_geocode_patch_name
4443: );
4444:
4445: loop
4446: hr_utility.set_location(gv_package_name || '.report_16', 100);
4447:
4448: fetch c_person_cursor into ln_full_name
4449: ,ln_person_id
4450: ,ln_employee_number

Line 4457: hr_utility.set_location(gv_package_name || '.report_16', 110);

4453: ,ln_new_city_name
4454: ,ln_update_description;
4455:
4456: if c_person_cursor%notfound then
4457: hr_utility.set_location(gv_package_name || '.report_16', 110);
4458: exit;
4459: end if;
4460:
4461: hr_utility.set_location(gv_package_name || '.report_16', 120);

Line 4461: hr_utility.set_location(gv_package_name || '.report_16', 120);

4457: hr_utility.set_location(gv_package_name || '.report_16', 110);
4458: exit;
4459: end if;
4460:
4461: hr_utility.set_location(gv_package_name || '.report_16', 120);
4462:
4463: formated_static_data4( ln_full_name
4464: ,ln_person_id
4465: ,ln_employee_number

Line 4475: hr_utility.set_location(gv_package_name || '.report_16', 130);

4471: ,lv_data_row1);
4472:
4473: lv_data_row := lv_data_row1;
4474:
4475: hr_utility.set_location(gv_package_name || '.report_16', 130);
4476:
4477: lv_data_row := '
' || lv_data_row || '' ;
4478:
4479: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
Line 4510: hr_utility.set_location(gv_package_name || '.report_16', 140);

4506: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
4507: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4508: end if;
4509:
4510: hr_utility.set_location(gv_package_name || '.report_16', 140);
4511:
4512: lv_format1 :=
4513: formated_data_string (p_input_string => 'Location Name'
4514: ,p_bold => 'Y'
Line 4538: hr_utility.set_location(gv_package_name || '.report_16', 150);

4534: ,p_bold => 'Y'
4535: ,p_output_file_type => p_output_file_type)
4536: ;
4537:
4538: hr_utility.set_location(gv_package_name || '.report_16', 150);
4539:
4540: fnd_file.put_line(fnd_file.output, lv_format1);
4541:
4542: if p_output_file_type ='HTML' then

Line 4546: hr_utility.set_location(gv_package_name || '.report_16', 160);

4542: if p_output_file_type ='HTML' then
4543: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
4544: end if;
4545:
4546: hr_utility.set_location(gv_package_name || '.report_16', 160);
4547:
4548: /*
4549: Start of the Data Section
4550: ***/
Line 4557: hr_utility.set_location(gv_package_name || '.report_16', 170);

4553: ,p_geocode_patch_name
4554: );
4555:
4556: loop
4557: hr_utility.set_location(gv_package_name || '.report_16', 170);
4558:
4559: fetch c_location_cursor into ln_location_name
4560: ,ln_location_id
4561: ,ln_jurisdiction_code

Line 4567: hr_utility.set_location(gv_package_name || '.report_16', 180);

4563: ,ln_new_city_name
4564: ,ln_update_description;
4565:
4566: if c_location_cursor%notfound then
4567: hr_utility.set_location(gv_package_name || '.report_16', 180);
4568: exit;
4569: end if;
4570:
4571: hr_utility.set_location(gv_package_name || '.report_16', 190);

Line 4571: hr_utility.set_location(gv_package_name || '.report_16', 190);

4567: hr_utility.set_location(gv_package_name || '.report_16', 180);
4568: exit;
4569: end if;
4570:
4571: hr_utility.set_location(gv_package_name || '.report_16', 190);
4572:
4573: formated_static_data5( ln_location_name
4574: ,ln_location_id
4575: ,ln_jurisdiction_code

Line 4584: hr_utility.set_location(gv_package_name || '.report_16', 200);

4580: ,lv_data_row1);
4581:
4582: lv_data_row := lv_data_row1;
4583:
4584: hr_utility.set_location(gv_package_name || '.report_16', 200);
4585:
4586: lv_data_row := '
' || lv_data_row || '' ;
4587:
4588: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
Line 4619: hr_utility.set_location(gv_package_name || '.report_16', 210);

4615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
4616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4617: end if;
4618:
4619: hr_utility.set_location(gv_package_name || '.report_16', 210);
4620:
4621: lv_format1 :=
4622: formated_data_string (p_input_string => 'Organization Name'
4623: ,p_bold => 'Y'
Line 4647: hr_utility.set_location(gv_package_name || '.report_16', 220);

4643: ,p_bold => 'Y'
4644: ,p_output_file_type => p_output_file_type)
4645: ;
4646:
4647: hr_utility.set_location(gv_package_name || '.report_16', 220);
4648:
4649: fnd_file.put_line(fnd_file.output, lv_format1);
4650:
4651: if p_output_file_type ='HTML' then

Line 4655: hr_utility.set_location(gv_package_name || '.report_16', 230);

4651: if p_output_file_type ='HTML' then
4652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
4653: end if;
4654:
4655: hr_utility.set_location(gv_package_name || '.report_16', 230);
4656:
4657: /*
4658: Start of the Data Section
4659: *************************/
Line 4666: hr_utility.set_location(gv_package_name || '.report_16', 240);

4662: ,p_geocode_patch_name
4663: );
4664:
4665: loop
4666: hr_utility.set_location(gv_package_name || '.report_16', 240);
4667:
4668: fetch c_org_cursor into ln_organization_name
4669: ,ln_organization_id
4670: ,ln_jurisdiction_code

Line 4676: hr_utility.set_location(gv_package_name || '.report_16', 250);

4672: ,ln_new_city_name
4673: ,ln_update_description;
4674:
4675: if c_org_cursor%notfound then
4676: hr_utility.set_location(gv_package_name || '.report_16', 250);
4677: exit;
4678: end if;
4679:
4680: hr_utility.set_location(gv_package_name || '.report_16', 260);

Line 4680: hr_utility.set_location(gv_package_name || '.report_16', 260);

4676: hr_utility.set_location(gv_package_name || '.report_16', 250);
4677: exit;
4678: end if;
4679:
4680: hr_utility.set_location(gv_package_name || '.report_16', 260);
4681:
4682: formated_static_data6( ln_organization_name
4683: ,ln_organization_id
4684: ,ln_jurisdiction_code

Line 4693: hr_utility.set_location(gv_package_name || '.report_16', 270);

4689: ,lv_data_row1);
4690:
4691: lv_data_row := lv_data_row1;
4692:
4693: hr_utility.set_location(gv_package_name || '.report_16', 270);
4694:
4695: lv_data_row := '
' || lv_data_row || '' ;
4696:
4697: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
Line 4737: hr_utility.set_location(gv_package_name || '.extract_data', 10);

4733: BEGIN
4734:
4735: lv_output_file_type := 'HTML';
4736:
4737: hr_utility.set_location(gv_package_name || '.extract_data', 10);
4738:
4739: report_1 ( p_process_mode => p_process_mode
4740: ,p_geocode_patch_name => p_geocode_patch_name
4741: ,p_output_file_type => lv_output_file_type);

Line 4807: hr_utility.trace('Concurrent Request ID = ' || FND_GLOBAL.CONC_REQUEST_ID);

4803: ,p_output_file_type => lv_output_file_type);
4804:
4805: /* End of changes for Bug#14314081 /
4806:
4807: hr_utility.trace('Concurrent Request ID = ' || FND_GLOBAL.CONC_REQUEST_ID);
4808:
4809: END extract_data;
4810:
4811: / Added for Bug#14314081 to generate the Output related to City Name changes.

Line 4858: --hr_utility.trace_on(null, 'ELE');

4854:
4855: END city_name_change_report;
4856:
4857: --begin
4858: --hr_utility.trace_on(null, 'ELE');
4859: end pay_us_geocode_report_pkg;

APPS.PAY_US_GEOCODE_REPORT_PKG dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

' || p_input_string || 161: -- '

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

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

Line 204: hr_utility.set_location(gv_package_name || '.formated_static_header', 20);

Line 207: hr_utility.trace('Static Label1 = ' || lv_format1);

Line 208: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);

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

Line 295: hr_utility.set_location(gv_package_name || '.formated_static_data', 30);

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

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

Line 326: hr_utility.set_location(gv_package_name || '.formated_static_data2', 10);

Line 367: hr_utility.set_location(gv_package_name || '.formated_static_data2', 30);

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

Line 372: hr_utility.set_location(gv_package_name || '.formated_static_data2', 40);

Line 401: hr_utility.set_location(gv_package_name || '.formated_static_data3', 10);

Line 446: hr_utility.set_location(gv_package_name || '.formated_static_data3', 30);

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

Line 451: hr_utility.set_location(gv_package_name || '.formated_static_data3', 40);

Line 478: hr_utility.set_location(gv_package_name || '.formated_static_data4', 10);

Line 523: hr_utility.set_location(gv_package_name || '.formated_static_data4', 30);

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

Line 528: hr_utility.set_location(gv_package_name || '.formated_static_data4', 40);

Line 554: hr_utility.set_location(gv_package_name || '.formated_static_data5', 10);

Line 593: hr_utility.set_location(gv_package_name || '.formated_static_data5', 30);

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

Line 598: hr_utility.set_location(gv_package_name || '.formated_static_data5', 40);

Line 624: hr_utility.set_location(gv_package_name || '.formated_static_data6', 10);

Line 663: hr_utility.set_location(gv_package_name || '.formated_static_data6', 30);

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

Line 668: hr_utility.set_location(gv_package_name || '.formated_static_data6', 40);

Line 737: hr_utility.set_location(gv_package_name || '.report_1', 10);

Line 781: hr_utility.set_location(gv_package_name || '.report_1', 12);

Line 792: hr_utility.set_location(gv_package_name || '.report_1', 15);

Line 811: hr_utility.set_location(gv_package_name || '.report_1', 20);

Line 820: hr_utility.set_location(gv_package_name || '.report_1', 30);

Line 825: -- HR_UTILITY.TRACE_ON(NULL,'TCL');

Line 831: hr_utility.set_location(gv_package_name || '.report_1', 40);

Line 839: hr_utility.set_location(gv_package_name || '.report_1', 50);

Line 849: hr_utility.set_location(gv_package_name || '.report_1', 60);

Line 850: hr_utility.trace('Assignment ID = ' || ln_assignment_id);

Line 865: hr_utility.set_location(gv_package_name || '.report_1', 70);

Line 934: hr_utility.set_location(gv_package_name || '.report_2', 10);

Line 972: hr_utility.set_location(gv_package_name || '.report_2', 15);

Line 983: hr_utility.set_location(gv_package_name || '.report_2', 20);

Line 997: hr_utility.set_location(gv_package_name || '.report_2', 30);

Line 1006: hr_utility.set_location(gv_package_name || '.report_2', 40);

Line 1011: -- HR_UTILITY.TRACE_ON(NULL,'TCL');

Line 1017: hr_utility.set_location(gv_package_name || '.report_2', 50);

Line 1024: hr_utility.set_location(gv_package_name || '.report_2', 60);

Line 1034: hr_utility.set_location(gv_package_name || '.report_2', 70);

Line 1036: hr_utility.set_location(gv_package_name || '.report_2', 80);

Line 1050: hr_utility.set_location(gv_package_name || '.report_2', 90);

Line 1119: hr_utility.set_location(gv_package_name || '.report_3', 10);

Line 1147: hr_utility.set_location(gv_package_name || '.report_3', 15);

Line 1158: hr_utility.set_location(gv_package_name || '.report_3', 20);

Line 1173: hr_utility.set_location(gv_package_name || '.report_3', 30);

Line 1182: hr_utility.set_location(gv_package_name || '.report_3', 40);

Line 1187: -- HR_UTILITY.TRACE_ON(NULL,'TCL');

Line 1193: hr_utility.set_location(gv_package_name || '.report_3', 50);

Line 1200: hr_utility.set_location(gv_package_name || '.report_3', 60);

Line 1210: hr_utility.set_location(gv_package_name || '.report_3', 70);

Line 1211: hr_utility.trace('Assignment ID = ' || ln_assignment_id);

Line 1214: hr_utility.set_location(gv_package_name || '.report_3', 80);

Line 1228: hr_utility.set_location(gv_package_name || '.report_3', 90);

Line 1320: hr_utility.set_location(gv_package_name || '.report_4', 10);

Line 1358: hr_utility.set_location(gv_package_name || '.report_4', 15);

Line 1369: hr_utility.set_location(gv_package_name || '.report_4', 20);

Line 1406: hr_utility.set_location(gv_package_name || '.report_4', 30);

Line 1415: hr_utility.set_location(gv_package_name || '.report_4', 40);

Line 1420: -- HR_UTILITY.TRACE_ON(NULL,'TCL');

' || p_input_string ||
161: -- '