DBA Data[Home] [Help]

APPS.PAY_US_GEOCODE_REPORT_PKG dependencies on HR_UTILITY

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

62:
63: lv_format varchar2(1000);
64:
65: BEGIN
66: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);
67: if p_output_file_type = 'CSV' then
68: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);
69: lv_format := gc_csv_data_delimiter || p_input_string ||
70: gc_csv_data_delimiter || gc_csv_delimiter;

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

64:
65: BEGIN
66: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);
67: if p_output_file_type = 'CSV' then
68: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);
69: lv_format := gc_csv_data_delimiter || p_input_string ||
70: gc_csv_data_delimiter || gc_csv_delimiter;
71: elsif p_output_file_type = 'HTML' then
72: if p_input_string is null then

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

69: lv_format := gc_csv_data_delimiter || p_input_string ||
70: gc_csv_data_delimiter || gc_csv_delimiter;
71: elsif p_output_file_type = 'HTML' then
72: if p_input_string is null then
73: hr_utility.set_location(gv_package_name || '.formated_data_string', 30);
74: lv_format := gv_html_start_data || '&'||'nbsp;' || gv_html_end_data;
75: else
76: if p_bold = 'Y' then
77: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);

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

73: hr_utility.set_location(gv_package_name || '.formated_data_string', 30);
74: lv_format := gv_html_start_data || '&'||'nbsp;' || gv_html_end_data;
75: else
76: if p_bold = 'Y' then
77: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);
78: lv_format := gv_html_start_data || ' ' || p_input_string
79: || '' || gv_html_end_data;
80: else
81: hr_utility.set_location(gv_package_name || '.formated_data_string', 50);

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

77: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);
78: lv_format := gv_html_start_data || ' ' || p_input_string
79: || '' || gv_html_end_data;
80: else
81: hr_utility.set_location(gv_package_name || '.formated_data_string', 50);
82: lv_format := gv_html_start_data || p_input_string || gv_html_end_data;
83: end if;
84: end if;
85: end if;

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

83: end if;
84: end if;
85: end if;
86:
87: hr_utility.set_location(gv_package_name || '.formated_data_string', 60);
88: return lv_format;
89:
90: END formated_data_string;
91:

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

102:
103: lv_format varchar2(1000);
104:
105: BEGIN
106: hr_utility.set_location(gv_package_name || '.formated_header_string', 10);
107: if p_output_file_type = 'CSV' then
108: hr_utility.set_location(gv_package_name || '.formated_header_string', 20);
109: lv_format := p_input_string;
110: elsif p_output_file_type = 'HTML' then

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

104:
105: BEGIN
106: hr_utility.set_location(gv_package_name || '.formated_header_string', 10);
107: if p_output_file_type = 'CSV' then
108: hr_utility.set_location(gv_package_name || '.formated_header_string', 20);
109: lv_format := p_input_string;
110: elsif p_output_file_type = 'HTML' then
111: hr_utility.set_location(gv_package_name || '.formated_header_string', 30);
112: -- lv_format := '

' || p_input_string ||

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

107: if p_output_file_type = 'CSV' then
108: hr_utility.set_location(gv_package_name || '.formated_header_string', 20);
109: lv_format := p_input_string;
110: elsif p_output_file_type = 'HTML' then
111: hr_utility.set_location(gv_package_name || '.formated_header_string', 30);
112: -- lv_format := '

' || p_input_string ||
113: -- '

';
114: lv_format := '

' || p_input_string ||
115: '

';

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

114: lv_format := '

' || p_input_string ||
115: '

';
116: end if;
117:
118: hr_utility.set_location(gv_package_name || '.formated_header_string', 40);
119: return lv_format;
120:
121: END formated_header_string;
122:

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

133: lv_format1 varchar2(32000);
134:
135: BEGIN
136:
137: hr_utility.set_location(gv_package_name || '.formated_static_header', 10);
138:
139: lv_format1 :=
140: formated_data_string (p_input_string => 'Full Name'
141: ,p_bold => 'Y'

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

152: ,p_bold => 'Y'
153: ,p_output_file_type => p_output_file_type)
154: ;
155:
156: hr_utility.set_location(gv_package_name || '.formated_static_header', 20);
157:
158: p_static_label1 := lv_format1;
159: hr_utility.trace('Static Label1 = ' || lv_format1);
160: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);

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

155:
156: hr_utility.set_location(gv_package_name || '.formated_static_header', 20);
157:
158: p_static_label1 := lv_format1;
159: hr_utility.trace('Static Label1 = ' || lv_format1);
160: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);
161:
162: END;
163:

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

156: hr_utility.set_location(gv_package_name || '.formated_static_header', 20);
157:
158: p_static_label1 := lv_format1;
159: hr_utility.trace('Static Label1 = ' || lv_format1);
160: hr_utility.set_location(gv_package_name || '.formated_static_header', 40);
161:
162: END;
163:
164:

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

185:
186:
187: BEGIN
188:
189: hr_utility.set_location(gv_package_name || '.formated_static_data', 10);
190:
191: if p_full_name is not NULL THEN
192:
193: lv_format1 := lv_format1 ||

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

243: ,p_output_file_type => p_output_file_type);
244: end if;
245:
246:
247: hr_utility.set_location(gv_package_name || '.formated_static_data', 30);
248:
249:
250: p_static_data1 := lv_format1;
251: hr_utility.trace('Static Data1 = ' || lv_format1);

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

247: hr_utility.set_location(gv_package_name || '.formated_static_data', 30);
248:
249:
250: p_static_data1 := lv_format1;
251: hr_utility.trace('Static Data1 = ' || lv_format1);
252: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
253:
254: END formated_static_data;
255: /*****************************************************************

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

248:
249:
250: p_static_data1 := lv_format1;
251: hr_utility.trace('Static Data1 = ' || lv_format1);
252: hr_utility.set_location(gv_package_name || '.formated_static_data', 40);
253:
254: END formated_static_data;
255: /*****************************************************************
256: ** This procudure returns the Mandatory Static Labels.

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

274:
275:
276: BEGIN
277:
278: hr_utility.set_location(gv_package_name || '.formated_static_data2', 10);
279: lv_format1 :=
280: formated_data_string (p_input_string => p_full_name
281: ,p_output_file_type => p_output_file_type) ||
282: formated_data_string (p_input_string => p_assignment_id

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

315: ,p_output_file_type => p_output_file_type);
316: end if;
317:
318:
319: hr_utility.set_location(gv_package_name || '.formated_static_data2', 30);
320:
321:
322: p_static_data1 := lv_format1;
323: hr_utility.trace('Static Data1 = ' || lv_format1);

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

319: hr_utility.set_location(gv_package_name || '.formated_static_data2', 30);
320:
321:
322: p_static_data1 := lv_format1;
323: hr_utility.trace('Static Data1 = ' || lv_format1);
324: hr_utility.set_location(gv_package_name || '.formated_static_data2', 40);
325:
326: END formated_static_data2;
327:

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

320:
321:
322: p_static_data1 := lv_format1;
323: hr_utility.trace('Static Data1 = ' || lv_format1);
324: hr_utility.set_location(gv_package_name || '.formated_static_data2', 40);
325:
326: END formated_static_data2;
327:
328: PROCEDURE report_1

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

369:
370:
371: BEGIN
372:
373: hr_utility.set_location(gv_package_name || '.report_1', 10);
374:
375: /****************************************************************
376: ** Concatnating the second Header Label which includes the User
377: ** Defined data set so that it is printed at the end of the

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

413: ,p_output_file_type
414: ));
415:
416:
417: hr_utility.set_location(gv_package_name || '.report_1', 12);
418: /****************************************************************
419: ** Print the Header Information. If the format is HTML then open
420: ** the body and table before printing the header info, otherwise
421: ** just print the header information.

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

424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
427: end if;
428: hr_utility.set_location(gv_package_name || '.report_1', 15);
429:
430: lv_format1 :=
431: formated_data_string (p_input_string => 'Full Name'
432: ,p_bold => 'Y'

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

443: ,p_bold => 'Y'
444: ,p_output_file_type => p_output_file_type)
445: ;
446:
447: hr_utility.set_location(gv_package_name || '.report_1', 20);
448:
449:
450: fnd_file.put_line(fnd_file.output, lv_format1);
451:

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

452: if p_output_file_type ='HTML' then
453: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
454: end if;
455:
456: hr_utility.set_location(gv_package_name || '.report_1', 30);
457: /*****************************************************
458: ** Start of the Data Section of the Report
459: *****************************************************/
460:

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

457: /*****************************************************
458: ** Start of the Data Section of the Report
459: *****************************************************/
460:
461: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
462: open c_cursor( p_process_mode
463: ,p_geocode_patch_name
464: );
465:

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

463: ,p_geocode_patch_name
464: );
465:
466: loop
467: hr_utility.set_location(gv_package_name || '.report_1', 40);
468:
469: fetch c_cursor into ln_full_name
470: ,ln_assignment_id
471: ,ln_assignment_number

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

471: ,ln_assignment_number
472: ,ln_error_description;
473:
474: if c_cursor%notfound then
475: hr_utility.set_location(gv_package_name || '.report_1', 50);
476: exit;
477: end if;
478:
479:

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

481: ** If Assignment Set is used, pick up only those employee
482: ** assignments which are part of the Assignment Set - STATIC
483: ** or DYNAMIC.
484: ************************************************************/
485: hr_utility.set_location(gv_package_name || '.report_1', 60);
486: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
487:
488: formated_static_data( ln_full_name
489: ,ln_assignment_id

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

482: ** assignments which are part of the Assignment Set - STATIC
483: ** or DYNAMIC.
484: ************************************************************/
485: hr_utility.set_location(gv_package_name || '.report_1', 60);
486: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
487:
488: formated_static_data( ln_full_name
489: ,ln_assignment_id
490: ,ln_assignment_number

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

497: ,p_output_file_type
498: ,lv_data_row1);
499:
500: lv_data_row := lv_data_row1;
501: hr_utility.set_location(gv_package_name || '.report_1', 70);
502:
503: -- if p_output_file_type ='HTML' then
504: lv_data_row := '

' || lv_data_row || '' ;
505: -- end if;

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

566:
567:
568: BEGIN
569:
570: hr_utility.set_location(gv_package_name || '.report_2', 10);
571:
572: /****************************************************************
573: ** Concatnating the second Header Label which includes the User
574: ** Defined data set so that it is printed at the end of the

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

604: '(or total of all the cities) to not exceed 100% time in total. '
605: ,p_output_file_type
606: ));
607:
608: hr_utility.set_location(gv_package_name || '.report_2', 15);
609: /****************************************************************
610: ** Print the Header Information. If the format is HTML then open
611: ** the body and table before printing the header info, otherwise
612: ** just print the header information.

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

615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
617: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
618: end if;
619: hr_utility.set_location(gv_package_name || '.report_2', 20);
620:
621: lv_format1 :=
622: formated_data_string (p_input_string => 'Full Name'
623: ,p_bold => 'Y'

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

629: formated_data_string (p_input_string => 'Assignment Number'
630: ,p_bold => 'Y'
631: ,p_output_file_type => p_output_file_type) ;
632:
633: hr_utility.set_location(gv_package_name || '.report_2', 30);
634:
635:
636: fnd_file.put_line(fnd_file.output, lv_format1);
637:

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

638: if p_output_file_type ='HTML' then
639: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
640: end if;
641:
642: hr_utility.set_location(gv_package_name || '.report_2', 40);
643: /*****************************************************
644: ** Start of the Data Section of the Report
645: *****************************************************/
646:

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

643: /*****************************************************
644: ** Start of the Data Section of the Report
645: *****************************************************/
646:
647: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
648: open c_cursor( p_process_mode
649: ,p_geocode_patch_name
650: );
651:

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

649: ,p_geocode_patch_name
650: );
651:
652: loop
653: hr_utility.set_location(gv_package_name || '.report_2', 50);
654:
655: fetch c_cursor into ln_full_name
656: ,ln_assignment_id
657: ,ln_assignment_number;

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

656: ,ln_assignment_id
657: ,ln_assignment_number;
658:
659: if c_cursor%notfound then
660: hr_utility.set_location(gv_package_name || '.report_2', 60);
661: exit;
662: end if;
663:
664:

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

666: ** If Assignment Set is used, pick up only those employee
667: ** assignments which are part of the Assignment Set - STATIC
668: ** or DYNAMIC.
669: ************************************************************/
670: hr_utility.set_location(gv_package_name || '.report_2', 70);
671:
672: hr_utility.set_location(gv_package_name || '.report_2', 80);
673: formated_static_data( ln_full_name
674: ,ln_assignment_id

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

668: ** or DYNAMIC.
669: ************************************************************/
670: hr_utility.set_location(gv_package_name || '.report_2', 70);
671:
672: hr_utility.set_location(gv_package_name || '.report_2', 80);
673: formated_static_data( ln_full_name
674: ,ln_assignment_id
675: ,ln_assignment_number
676: ,null

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

682: ,p_output_file_type
683: ,lv_data_row1);
684:
685: lv_data_row := lv_data_row1;
686: hr_utility.set_location(gv_package_name || '.report_2', 90);
687:
688: -- if p_output_file_type ='HTML' then
689: lv_data_row := '

' || lv_data_row || '' ;
690: -- end if;

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

751:
752:
753: BEGIN
754:
755: hr_utility.set_location(gv_package_name || '.report_3', 10);
756:
757: /****************************************************************
758: ** Concatnating the second Header Label which includes the User
759: ** Defined data set so that it is printed at the end of the

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

779: 'Please correct this by creating a new county tax record from the W-4 form.'
780: ,p_output_file_type
781: ));
782:
783: hr_utility.set_location(gv_package_name || '.report_3', 15);
784: /****************************************************************
785: ** Print the Header Information. If the format is HTML then open
786: ** the body and table before printing the header info, otherwise
787: ** just print the header information.

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

790: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
791: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
792: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
793: end if;
794: hr_utility.set_location(gv_package_name || '.report_3', 20);
795:
796: lv_format1 :=
797: formated_data_string (p_input_string => 'Full Name'
798: ,p_bold => 'Y'

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

805: ,p_bold => 'Y'
806: ,p_output_file_type => p_output_file_type)
807: ;
808:
809: hr_utility.set_location(gv_package_name || '.report_3', 30);
810:
811:
812: fnd_file.put_line(fnd_file.output, lv_format1);
813:

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

814: if p_output_file_type ='HTML' then
815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
816: end if;
817:
818: hr_utility.set_location(gv_package_name || '.report_3', 40);
819: /*****************************************************
820: ** Start of the Data Section of the Report
821: *****************************************************/
822:

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

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

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

825: ,p_geocode_patch_name
826: );
827:
828: loop
829: hr_utility.set_location(gv_package_name || '.report_3', 50);
830:
831: fetch c_cursor into ln_full_name
832: ,ln_assignment_id
833: ,ln_assignment_number;

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

832: ,ln_assignment_id
833: ,ln_assignment_number;
834:
835: if c_cursor%notfound then
836: hr_utility.set_location(gv_package_name || '.report_3', 60);
837: exit;
838: end if;
839:
840:

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

842: ** If Assignment Set is used, pick up only those employee
843: ** assignments which are part of the Assignment Set - STATIC
844: ** or DYNAMIC.
845: ************************************************************/
846: hr_utility.set_location(gv_package_name || '.report_3', 70);
847: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
848:
849:
850: hr_utility.set_location(gv_package_name || '.report_3', 80);

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

843: ** assignments which are part of the Assignment Set - STATIC
844: ** or DYNAMIC.
845: ************************************************************/
846: hr_utility.set_location(gv_package_name || '.report_3', 70);
847: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
848:
849:
850: hr_utility.set_location(gv_package_name || '.report_3', 80);
851: formated_static_data( ln_full_name

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

846: hr_utility.set_location(gv_package_name || '.report_3', 70);
847: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
848:
849:
850: hr_utility.set_location(gv_package_name || '.report_3', 80);
851: formated_static_data( ln_full_name
852: ,ln_assignment_id
853: ,ln_assignment_number
854: ,null

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

860: ,p_output_file_type
861: ,lv_data_row1);
862:
863: lv_data_row := lv_data_row1;
864: hr_utility.set_location(gv_package_name || '.report_3', 90);
865:
866: -- if p_output_file_type ='HTML' then
867: lv_data_row := '

' || lv_data_row || '' ;
868: -- end if;

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

952:
953:
954: BEGIN
955:
956: hr_utility.set_location(gv_package_name || '.report_4', 10);
957:
958: /****************************************************************
959: ** Concatnating the second Header Label which includes the User
960: ** Defined data set so that it is printed at the end of the

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

990: 'The city displayed here is the NEW PRIMARY CITY for the assignment.'
991: ,p_output_file_type
992: ));
993:
994: hr_utility.set_location(gv_package_name || '.report_4', 15);
995: /****************************************************************
996: ** Print the Header Information. If the format is HTML then open
997: ** the body and table before printing the header info, otherwise
998: ** just print the header information.

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

1001: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1002: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1003: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1004: end if;
1005: hr_utility.set_location(gv_package_name || '.report_4', 20);
1006:
1007: lv_format1 :=
1008: formated_data_string (p_input_string => 'Full Name'
1009: ,p_bold => 'Y'

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

1038: ,p_output_file_type => p_output_file_type)
1039: ;
1040:
1041:
1042: hr_utility.set_location(gv_package_name || '.report_4', 30);
1043:
1044:
1045: fnd_file.put_line(fnd_file.output, lv_format1);
1046:

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

1047: if p_output_file_type ='HTML' then
1048: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1049: end if;
1050:
1051: hr_utility.set_location(gv_package_name || '.report_4', 40);
1052: /*****************************************************
1053: ** Start of the Data Section of the Report
1054: *****************************************************/
1055:

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

1052: /*****************************************************
1053: ** Start of the Data Section of the Report
1054: *****************************************************/
1055:
1056: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
1057: open c_cursor( p_process_mode
1058: ,p_geocode_patch_name
1059: );
1060:

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

1058: ,p_geocode_patch_name
1059: );
1060:
1061: loop
1062: hr_utility.set_location(gv_package_name || '.report_4', 50);
1063:
1064: fetch c_cursor into ln_full_name
1065: ,ln_assignment_id
1066: ,ln_assignment_number

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

1070: ,ln_old_pri_city
1071: ,ln_table_name;
1072:
1073: if c_cursor%notfound then
1074: hr_utility.set_location(gv_package_name || '.report_4', 60);
1075: exit;
1076: end if;
1077:
1078:

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

1080: ** If Assignment Set is used, pick up only those employee
1081: ** assignments which are part of the Assignment Set - STATIC
1082: ** or DYNAMIC.
1083: ************************************************************/
1084: hr_utility.set_location(gv_package_name || '.report_4', 70);
1085: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1086:
1087:
1088: hr_utility.set_location(gv_package_name || '.report_4', 80);

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

1081: ** assignments which are part of the Assignment Set - STATIC
1082: ** or DYNAMIC.
1083: ************************************************************/
1084: hr_utility.set_location(gv_package_name || '.report_4', 70);
1085: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1086:
1087:
1088: hr_utility.set_location(gv_package_name || '.report_4', 80);
1089: formated_static_data( ln_full_name

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

1084: hr_utility.set_location(gv_package_name || '.report_4', 70);
1085: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1086:
1087:
1088: hr_utility.set_location(gv_package_name || '.report_4', 80);
1089: formated_static_data( ln_full_name
1090: ,ln_assignment_id
1091: ,ln_assignment_number
1092: ,null

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

1098: ,p_output_file_type
1099: ,lv_data_row1);
1100:
1101: lv_data_row := lv_data_row1;
1102: hr_utility.set_location(gv_package_name || '.report_4', 90);
1103:
1104: -- if p_output_file_type ='HTML' then
1105: lv_data_row := '

' || lv_data_row || '' ;
1106: -- end if;

Line 1187: hr_utility.set_location(gv_package_name || '.report_5', 10);

1183:
1184:
1185: BEGIN
1186:
1187: hr_utility.set_location(gv_package_name || '.report_5', 10);
1188:
1189: /****************************************************************
1190: ** Concatnating the second Header Label which includes the User
1191: ** Defined data set so that it is printed at the end of the

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

1211: 'because a primary citys jurisdiction code has changed.'
1212: ,p_output_file_type
1213: ));
1214:
1215: hr_utility.set_location(gv_package_name || '.report_5', 15);
1216: /****************************************************************
1217: ** Print the Header Information. If the format is HTML then open
1218: ** the body and table before printing the header info, otherwise
1219: ** just print the header information.

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

1222: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1223: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1224: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1225: end if;
1226: hr_utility.set_location(gv_package_name || '.report_5', 20);
1227:
1228: lv_format1 :=
1229: formated_data_string (p_input_string => 'Full Name'
1230: ,p_bold => 'Y'

Line 1259: hr_utility.set_location(gv_package_name || '.report_5', 30);

1255: ,p_output_file_type => p_output_file_type)
1256: ;
1257:
1258:
1259: hr_utility.set_location(gv_package_name || '.report_5', 30);
1260:
1261:
1262: fnd_file.put_line(fnd_file.output, lv_format1);
1263:

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

1264: if p_output_file_type ='HTML' then
1265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1266: end if;
1267:
1268: hr_utility.set_location(gv_package_name || '.report_5', 40);
1269: /*****************************************************
1270: ** Start of the Data Section of the Report
1271: *****************************************************/
1272:

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

1269: /*****************************************************
1270: ** Start of the Data Section of the Report
1271: *****************************************************/
1272:
1273: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
1274: open c_cursor( p_process_mode
1275: ,p_geocode_patch_name
1276: );
1277:

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

1275: ,p_geocode_patch_name
1276: );
1277:
1278: loop
1279: hr_utility.set_location(gv_package_name || '.report_5', 50);
1280:
1281: fetch c_cursor into ln_full_name
1282: ,ln_assignment_id
1283: ,ln_assignment_number

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

1286: ,ln_old_juri_code
1287: ,ln_table_name;
1288:
1289: if c_cursor%notfound then
1290: hr_utility.set_location(gv_package_name || '.report_5', 60);
1291: exit;
1292: end if;
1293:
1294:

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

1296: ** If Assignment Set is used, pick up only those employee
1297: ** assignments which are part of the Assignment Set - STATIC
1298: ** or DYNAMIC.
1299: ************************************************************/
1300: hr_utility.set_location(gv_package_name || '.report_5', 70);
1301: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1302:
1303:
1304: hr_utility.set_location(gv_package_name || '.report_5', 80);

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

1297: ** assignments which are part of the Assignment Set - STATIC
1298: ** or DYNAMIC.
1299: ************************************************************/
1300: hr_utility.set_location(gv_package_name || '.report_5', 70);
1301: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1302:
1303:
1304: hr_utility.set_location(gv_package_name || '.report_5', 80);
1305: formated_static_data( ln_full_name

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

1300: hr_utility.set_location(gv_package_name || '.report_5', 70);
1301: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1302:
1303:
1304: hr_utility.set_location(gv_package_name || '.report_5', 80);
1305: formated_static_data( ln_full_name
1306: ,ln_assignment_id
1307: ,ln_assignment_number
1308: ,null

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

1314: ,p_output_file_type
1315: ,lv_data_row1);
1316:
1317: lv_data_row := lv_data_row1;
1318: hr_utility.set_location(gv_package_name || '.report_5', 90);
1319:
1320: -- if p_output_file_type ='HTML' then
1321: lv_data_row := '

' || lv_data_row || '' ;
1322: -- end if;

Line 1410: hr_utility.set_location(gv_package_name || '.report_6', 10);

1406:
1407:
1408: BEGIN
1409:
1410: hr_utility.set_location(gv_package_name || '.report_6', 10);
1411:
1412: /****************************************************************
1413: ** Concatnating the second Header Label which includes the User
1414: ** Defined data set so that it is printed at the end of the

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

1479: 'cities may be ignored and are listed for information only.'
1480: ,p_output_file_type
1481: ));
1482:
1483: hr_utility.set_location(gv_package_name || '.report_6', 15);
1484: /****************************************************************
1485: ** Print the Header Information. If the format is HTML then open
1486: ** the body and table before printing the header info, otherwise
1487: ** just print the header information.

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

1490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1492: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1493: end if;
1494: hr_utility.set_location(gv_package_name || '.report_6', 20);
1495:
1496: lv_format1 :=
1497: formated_data_string (p_input_string => 'Full Name'
1498: ,p_bold => 'Y'

Line 1531: hr_utility.set_location(gv_package_name || '.report_6', 30);

1527: ,p_output_file_type => p_output_file_type)
1528: ;
1529:
1530:
1531: hr_utility.set_location(gv_package_name || '.report_6', 30);
1532:
1533:
1534: fnd_file.put_line(fnd_file.output, lv_format1);
1535:

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

1536: if p_output_file_type ='HTML' then
1537: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1538: end if;
1539:
1540: hr_utility.set_location(gv_package_name || '.report_6', 40);
1541: /*****************************************************
1542: ** Start of the Data Section of the Report
1543: *****************************************************/
1544:

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

1541: /*****************************************************
1542: ** Start of the Data Section of the Report
1543: *****************************************************/
1544:
1545: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
1546: open c_cursor( p_process_mode
1547: ,p_geocode_patch_name
1548: );
1549:

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

1547: ,p_geocode_patch_name
1548: );
1549:
1550: loop
1551: hr_utility.set_location(gv_package_name || '.report_6', 50);
1552:
1553: fetch c_cursor into ln_full_name
1554: ,ln_assignment_id
1555: ,ln_assignment_number

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

1559: ,ln_old_juri_code
1560: ,ln_new_juri_code;
1561:
1562: if c_cursor%notfound then
1563: hr_utility.set_location(gv_package_name || '.report_6', 60);
1564: exit;
1565: end if;
1566:
1567:

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

1569: ** If Assignment Set is used, pick up only those employee
1570: ** assignments which are part of the Assignment Set - STATIC
1571: ** or DYNAMIC.
1572: ************************************************************/
1573: hr_utility.set_location(gv_package_name || '.report_6', 70);
1574: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1575:
1576:
1577: hr_utility.set_location(gv_package_name || '.report_6', 80);

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

1570: ** assignments which are part of the Assignment Set - STATIC
1571: ** or DYNAMIC.
1572: ************************************************************/
1573: hr_utility.set_location(gv_package_name || '.report_6', 70);
1574: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1575:
1576:
1577: hr_utility.set_location(gv_package_name || '.report_6', 80);
1578: formated_static_data2(ln_full_name

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

1573: hr_utility.set_location(gv_package_name || '.report_6', 70);
1574: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
1575:
1576:
1577: hr_utility.set_location(gv_package_name || '.report_6', 80);
1578: formated_static_data2(ln_full_name
1579: ,ln_assignment_id
1580: ,ln_assignment_number
1581: ,ln_city_name

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

1586: ,p_output_file_type
1587: ,lv_data_row1);
1588:
1589: lv_data_row := lv_data_row1;
1590: hr_utility.set_location(gv_package_name || '.report_6', 90);
1591:
1592: -- if p_output_file_type ='HTML' then
1593: lv_data_row := '

' || lv_data_row || '' ;
1594: -- end if;

Line 1701: hr_utility.set_location(gv_package_name || '.report_7', 10);

1697:
1698:
1699: BEGIN
1700:
1701: hr_utility.set_location(gv_package_name || '.report_7', 10);
1702:
1703: /****************************************************************
1704: ** Concatnating the second Header Label which includes the User
1705: ** Defined data set so that it is printed at the end of the

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

1726: ,p_output_file_type
1727: ));
1728:
1729:
1730: hr_utility.set_location(gv_package_name || '.report_7', 15);
1731: /****************************************************************
1732: ** Print the Header Information. If the format is HTML then open
1733: ** the body and table before printing the header info, otherwise
1734: ** just print the header information.

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

1737: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1738: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1739: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1740: end if;
1741: hr_utility.set_location(gv_package_name || '.report_7', 20);
1742:
1743: lv_format1 :=
1744: formated_data_string (p_input_string => 'Full Name'
1745: ,p_bold => 'Y'

Line 1757: hr_utility.set_location(gv_package_name || '.report_7', 30);

1753: ,p_bold => 'Y'
1754: ,p_output_file_type => p_output_file_type)
1755: ;
1756:
1757: hr_utility.set_location(gv_package_name || '.report_7', 30);
1758:
1759:
1760: fnd_file.put_line(fnd_file.output, lv_format1);
1761:

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

1762: if p_output_file_type ='HTML' then
1763: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1764: end if;
1765:
1766: hr_utility.set_location(gv_package_name || '.report_7', 40);
1767: /*****************************************************
1768: ** Start of the Data Section of the Report
1769: *****************************************************/
1770:

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

1767: /*****************************************************
1768: ** Start of the Data Section of the Report
1769: *****************************************************/
1770:
1771: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
1772: open c_cursor( p_process_mode
1773: ,p_geocode_patch_name
1774: );
1775:

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

1773: ,p_geocode_patch_name
1774: );
1775:
1776: loop
1777: hr_utility.set_location(gv_package_name || '.report_7', 50);
1778:
1779: fetch c_cursor into ln_full_name
1780: ,ln_old_city_name
1781: ,ln_new_city_name;

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

1780: ,ln_old_city_name
1781: ,ln_new_city_name;
1782:
1783: if c_cursor%notfound then
1784: hr_utility.set_location(gv_package_name || '.report_7', 60);
1785: exit;
1786: end if;
1787:
1788:

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

1790: ** If Assignment Set is used, pick up only those employee
1791: ** assignments which are part of the Assignment Set - STATIC
1792: ** or DYNAMIC.
1793: ************************************************************/
1794: hr_utility.set_location(gv_package_name || '.report_7', 70);
1795:
1796: hr_utility.set_location(gv_package_name || '.report_7', 80);
1797: formated_static_data(ln_full_name
1798: ,null

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

1792: ** or DYNAMIC.
1793: ************************************************************/
1794: hr_utility.set_location(gv_package_name || '.report_7', 70);
1795:
1796: hr_utility.set_location(gv_package_name || '.report_7', 80);
1797: formated_static_data(ln_full_name
1798: ,null
1799: ,null
1800: ,null

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

1806: ,p_output_file_type
1807: ,lv_data_row1);
1808:
1809: lv_data_row := lv_data_row1;
1810: hr_utility.set_location(gv_package_name || '.report_7', 90);
1811:
1812: -- if p_output_file_type ='HTML' then
1813: lv_data_row := '

' || lv_data_row || '' ;
1814: -- end if;

Line 1872: hr_utility.set_location(gv_package_name || '.report_8', 10);

1868:
1869:
1870: BEGIN
1871:
1872: hr_utility.set_location(gv_package_name || '.report_8', 10);
1873:
1874: /****************************************************************
1875: ** Concatnating the second Header Label which includes the User
1876: ** Defined data set so that it is printed at the end of the

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

1892: ,p_output_file_type
1893: ));
1894:
1895:
1896: hr_utility.set_location(gv_package_name || '.report_8', 15);
1897: /****************************************************************
1898: ** Print the Header Information. If the format is HTML then open
1899: ** the body and table before printing the header info, otherwise
1900: ** just print the header information.

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

1903: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1904: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1905: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1906: end if;
1907: hr_utility.set_location(gv_package_name || '.report_8', 20);
1908:
1909: lv_format1 :=
1910: formated_data_string (p_input_string => 'Old User Defined JD'
1911: ,p_bold => 'Y'

Line 1923: hr_utility.set_location(gv_package_name || '.report_8', 30);

1919: ,p_bold => 'Y'
1920: ,p_output_file_type => p_output_file_type)
1921: ;
1922:
1923: hr_utility.set_location(gv_package_name || '.report_8', 30);
1924:
1925:
1926: fnd_file.put_line(fnd_file.output, lv_format1);
1927:

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

1928: if p_output_file_type ='HTML' then
1929: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1930: end if;
1931:
1932: hr_utility.set_location(gv_package_name || '.report_8', 40);
1933: /*****************************************************
1934: ** Start of the Data Section of the Report
1935: *****************************************************/
1936:

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

1933: /*****************************************************
1934: ** Start of the Data Section of the Report
1935: *****************************************************/
1936:
1937: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
1938: open c_cursor( p_process_mode
1939: ,p_geocode_patch_name
1940: );
1941:

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

1939: ,p_geocode_patch_name
1940: );
1941:
1942: loop
1943: hr_utility.set_location(gv_package_name || '.report_8', 50);
1944:
1945: fetch c_cursor into ln_old_juri_code
1946: ,ln_new_juri_code
1947: ,ln_city_name;

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

1946: ,ln_new_juri_code
1947: ,ln_city_name;
1948:
1949: if c_cursor%notfound then
1950: hr_utility.set_location(gv_package_name || '.report_8', 60);
1951: exit;
1952: end if;
1953:
1954:

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

1956: ** If Assignment Set is used, pick up only those employee
1957: ** assignments which are part of the Assignment Set - STATIC
1958: ** or DYNAMIC.
1959: ************************************************************/
1960: hr_utility.set_location(gv_package_name || '.report_8', 70);
1961:
1962: hr_utility.set_location(gv_package_name || '.report_8', 80);
1963: formated_static_data( null
1964: ,null

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

1958: ** or DYNAMIC.
1959: ************************************************************/
1960: hr_utility.set_location(gv_package_name || '.report_8', 70);
1961:
1962: hr_utility.set_location(gv_package_name || '.report_8', 80);
1963: formated_static_data( null
1964: ,null
1965: ,null
1966: ,ln_old_juri_code -- Intentional see report format

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

1972: ,p_output_file_type
1973: ,lv_data_row1);
1974:
1975: lv_data_row := lv_data_row1;
1976: hr_utility.set_location(gv_package_name || '.report_8', 90);
1977:
1978: -- if p_output_file_type ='HTML' then
1979: lv_data_row := '

' || lv_data_row || '' ;
1980: -- end if;

Line 2060: hr_utility.set_location(gv_package_name || '.report_9', 10);

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

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

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

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

2096: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2097: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2098: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2099: end if;
2100: hr_utility.set_location(gv_package_name || '.report_9', 20);
2101:
2102: lv_format1 :=
2103: formated_data_string (p_input_string => 'Full Name'
2104: ,p_bold => 'Y'

Line 2123: hr_utility.set_location(gv_package_name || '.report_9', 30);

2119: formated_data_string (p_input_string => 'Jurisdiction Code'
2120: ,p_bold => 'Y'
2121: ,p_output_file_type => p_output_file_type) ;
2122:
2123: hr_utility.set_location(gv_package_name || '.report_9', 30);
2124:
2125:
2126: fnd_file.put_line(fnd_file.output, lv_format1);
2127:

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

2128: if p_output_file_type ='HTML' then
2129: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2130: end if;
2131:
2132: hr_utility.set_location(gv_package_name || '.report_9', 40);
2133: /*****************************************************
2134: ** Start of the Data Section of the Report
2135: *****************************************************/
2136:

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

2133: /*****************************************************
2134: ** Start of the Data Section of the Report
2135: *****************************************************/
2136:
2137: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
2138: open c_cursor( p_process_mode
2139: ,p_geocode_patch_name
2140: );
2141:

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

2139: ,p_geocode_patch_name
2140: );
2141:
2142: loop
2143: hr_utility.set_location(gv_package_name || '.report_9', 50);
2144:
2145: fetch c_cursor into ln_full_name
2146: ,ln_assignment_id
2147: ,ln_assignment_number

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

2148: ,ln_city_name
2149: ,ln_jd_code;
2150:
2151: if c_cursor%notfound then
2152: hr_utility.set_location(gv_package_name || '.report_9', 60);
2153: exit;
2154: end if;
2155:
2156:

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

2158: ** If Assignment Set is used, pick up only those employee
2159: ** assignments which are part of the Assignment Set - STATIC
2160: ** or DYNAMIC.
2161: ************************************************************/
2162: hr_utility.set_location(gv_package_name || '.report_9', 70);
2163: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
2164:
2165:
2166: hr_utility.set_location(gv_package_name || '.report_9', 80);

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

2159: ** assignments which are part of the Assignment Set - STATIC
2160: ** or DYNAMIC.
2161: ************************************************************/
2162: hr_utility.set_location(gv_package_name || '.report_9', 70);
2163: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
2164:
2165:
2166: hr_utility.set_location(gv_package_name || '.report_9', 80);
2167: formated_static_data( ln_full_name

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

2162: hr_utility.set_location(gv_package_name || '.report_9', 70);
2163: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
2164:
2165:
2166: hr_utility.set_location(gv_package_name || '.report_9', 80);
2167: formated_static_data( ln_full_name
2168: ,ln_assignment_id
2169: ,ln_assignment_number
2170: ,null

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

2176: ,p_output_file_type
2177: ,lv_data_row1);
2178:
2179: lv_data_row := lv_data_row1;
2180: hr_utility.set_location(gv_package_name || '.report_9', 90);
2181:
2182: -- if p_output_file_type ='HTML' then
2183: lv_data_row := '

' || lv_data_row || '' ;
2184: -- end if;

Line 2265: hr_utility.set_location(gv_package_name || '.report_10', 10);

2261:
2262:
2263: BEGIN
2264:
2265: hr_utility.set_location(gv_package_name || '.report_10', 10);
2266:
2267: /****************************************************************
2268: ** Concatnating the second Header Label which includes the User
2269: ** Defined data set so that it is printed at the end of the

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

2295: ,p_output_file_type
2296: ));
2297:
2298:
2299: hr_utility.set_location(gv_package_name || '.report_10', 15);
2300: /****************************************************************
2301: ** Print the Header Information. If the format is HTML then open
2302: ** the body and table before printing the header info, otherwise
2303: ** just print the header information.

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

2306: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2309: end if;
2310: hr_utility.set_location(gv_package_name || '.report_10', 20);
2311:
2312: lv_format1 :=
2313: formated_data_string (p_input_string => 'Full Name'
2314: ,p_bold => 'Y'

Line 2333: hr_utility.set_location(gv_package_name || '.report_10', 30);

2329: formated_data_string (p_input_string => 'Jurisdiction Code'
2330: ,p_bold => 'Y'
2331: ,p_output_file_type => p_output_file_type) ;
2332:
2333: hr_utility.set_location(gv_package_name || '.report_10', 30);
2334:
2335:
2336: fnd_file.put_line(fnd_file.output, lv_format1);
2337:

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

2338: if p_output_file_type ='HTML' then
2339: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2340: end if;
2341:
2342: hr_utility.set_location(gv_package_name || '.report_10', 40);
2343: /*****************************************************
2344: ** Start of the Data Section of the Report
2345: *****************************************************/
2346:

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

2343: /*****************************************************
2344: ** Start of the Data Section of the Report
2345: *****************************************************/
2346:
2347: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
2348: open c_cursor( p_process_mode
2349: ,p_geocode_patch_name
2350: );
2351:

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

2349: ,p_geocode_patch_name
2350: );
2351:
2352: loop
2353: hr_utility.set_location(gv_package_name || '.report_10', 50);
2354:
2355: fetch c_cursor into ln_full_name
2356: ,ln_assignment_id
2357: ,ln_assignment_number

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

2358: ,ln_city_name
2359: ,ln_jd_code;
2360:
2361: if c_cursor%notfound then
2362: hr_utility.set_location(gv_package_name || '.report_10', 60);
2363: exit;
2364: end if;
2365:
2366:

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

2368: ** If Assignment Set is used, pick up only those employee
2369: ** assignments which are part of the Assignment Set - STATIC
2370: ** or DYNAMIC.
2371: ************************************************************/
2372: hr_utility.set_location(gv_package_name || '.report_10', 70);
2373: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
2374:
2375:
2376: hr_utility.set_location(gv_package_name || '.report_10', 80);

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

2369: ** assignments which are part of the Assignment Set - STATIC
2370: ** or DYNAMIC.
2371: ************************************************************/
2372: hr_utility.set_location(gv_package_name || '.report_10', 70);
2373: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
2374:
2375:
2376: hr_utility.set_location(gv_package_name || '.report_10', 80);
2377: formated_static_data( ln_full_name

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

2372: hr_utility.set_location(gv_package_name || '.report_10', 70);
2373: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
2374:
2375:
2376: hr_utility.set_location(gv_package_name || '.report_10', 80);
2377: formated_static_data( ln_full_name
2378: ,ln_assignment_id
2379: ,ln_assignment_number
2380: ,null

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

2386: ,p_output_file_type
2387: ,lv_data_row1);
2388:
2389: lv_data_row := lv_data_row1;
2390: hr_utility.set_location(gv_package_name || '.report_10', 90);
2391:
2392: -- if p_output_file_type ='HTML' then
2393: lv_data_row := '

' || lv_data_row || '' ;
2394: -- end if;

Line 2456: hr_utility.set_location(gv_package_name || '.report_11', 10);

2452:
2453:
2454: BEGIN
2455:
2456: hr_utility.set_location(gv_package_name || '.report_11', 10);
2457:
2458: /****************************************************************
2459: ** Concatnating the second Header Label which includes the User
2460: ** Defined data set so that it is printed at the end of the

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

2470: 'The taxability rules have been changed for the following jurisdiction codes to reflect the new jurisdiction code.'
2471: ,p_output_file_type
2472: ));
2473:
2474: hr_utility.set_location(gv_package_name || '.report_11', 15);
2475: /****************************************************************
2476: ** Print the Header Information. If the format is HTML then open
2477: ** the body and table before printing the header info, otherwise
2478: ** just print the header information.

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

2481: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2482: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2483: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2484: end if;
2485: hr_utility.set_location(gv_package_name || '.report_11', 20);
2486:
2487: lv_format1 :=
2488: formated_data_string (p_input_string => 'Old JD'
2489: ,p_bold => 'Y'

Line 2497: hr_utility.set_location(gv_package_name || '.report_11', 30);

2493: ,p_bold => 'Y'
2494: ,p_output_file_type => p_output_file_type)
2495: ;
2496:
2497: hr_utility.set_location(gv_package_name || '.report_11', 30);
2498:
2499:
2500: fnd_file.put_line(fnd_file.output, lv_format1);
2501:

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

2502: if p_output_file_type ='HTML' then
2503: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2504: end if;
2505:
2506: hr_utility.set_location(gv_package_name || '.report_11', 40);
2507: /*****************************************************
2508: ** Start of the Data Section of the Report
2509: *****************************************************/
2510:

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

2507: /*****************************************************
2508: ** Start of the Data Section of the Report
2509: *****************************************************/
2510:
2511: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
2512: open c_cursor( p_process_mode
2513: ,p_geocode_patch_name
2514: );
2515:

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

2513: ,p_geocode_patch_name
2514: );
2515:
2516: loop
2517: hr_utility.set_location(gv_package_name || '.report_11', 50);
2518:
2519: fetch c_cursor into ln_old_jd_code
2520: ,ln_new_jd_code;
2521:

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

2519: fetch c_cursor into ln_old_jd_code
2520: ,ln_new_jd_code;
2521:
2522: if c_cursor%notfound then
2523: hr_utility.set_location(gv_package_name || '.report_11', 60);
2524: exit;
2525: end if;
2526:
2527:

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

2529: ** If Assignment Set is used, pick up only those employee
2530: ** assignments which are part of the Assignment Set - STATIC
2531: ** or DYNAMIC.
2532: ************************************************************/
2533: hr_utility.set_location(gv_package_name || '.report_11', 70);
2534:
2535: hr_utility.set_location(gv_package_name || '.report_11', 80);
2536: formated_static_data( null
2537: ,null

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

2531: ** or DYNAMIC.
2532: ************************************************************/
2533: hr_utility.set_location(gv_package_name || '.report_11', 70);
2534:
2535: hr_utility.set_location(gv_package_name || '.report_11', 80);
2536: formated_static_data( null
2537: ,null
2538: ,null
2539: ,ln_old_jd_code

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

2545: ,p_output_file_type
2546: ,lv_data_row1);
2547:
2548: lv_data_row := lv_data_row1;
2549: hr_utility.set_location(gv_package_name || '.report_11', 90);
2550:
2551: -- if p_output_file_type ='HTML' then
2552: lv_data_row := '

' || lv_data_row || '' ;
2553: -- end if;

Line 2642: hr_utility.set_location(gv_package_name || '.report_12', 10);

2638:
2639:
2640: BEGIN
2641:
2642: hr_utility.set_location(gv_package_name || '.report_12', 10);
2643:
2644: /****************************************************************
2645: ** Concatnating the second Header Label which includes the User
2646: ** Defined data set so that it is printed at the end of the

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

2677: ,p_output_file_type
2678: ));
2679:
2680:
2681: hr_utility.set_location(gv_package_name || '.report_12', 15);
2682: /****************************************************************
2683: ** Print the Header Information. If the format is HTML then open
2684: ** the body and table before printing the header info, otherwise
2685: ** just print the header information.

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

2688: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2689: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2690: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2691: end if;
2692: hr_utility.set_location(gv_package_name || '.report_12', 20);
2693:
2694: lv_format1 :=
2695: formated_data_string (p_input_string => 'Full Name'
2696: ,p_bold => 'Y'

Line 2727: hr_utility.set_location(gv_package_name || '.report_12', 30);

2723: formated_data_string (p_input_string => 'City Name'
2724: ,p_bold => 'Y'
2725: ,p_output_file_type => p_output_file_type) ;
2726:
2727: hr_utility.set_location(gv_package_name || '.report_12', 30);
2728:
2729:
2730: fnd_file.put_line(fnd_file.output, lv_format1);
2731:

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

2732: if p_output_file_type ='HTML' then
2733: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2734: end if;
2735:
2736: hr_utility.set_location(gv_package_name || '.report_12', 40);
2737: /*****************************************************
2738: ** Start of the Data Section of the Report
2739: *****************************************************/
2740:

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

2737: /*****************************************************
2738: ** Start of the Data Section of the Report
2739: *****************************************************/
2740:
2741: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
2742: open c_cursor( p_process_mode
2743: ,p_geocode_patch_name
2744: );
2745:

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

2743: ,p_geocode_patch_name
2744: );
2745:
2746: loop
2747: hr_utility.set_location(gv_package_name || '.report_12', 50);
2748:
2749: fetch c_cursor into ln_full_name
2750: ,ln_assignment_id
2751: ,ln_assignment_number

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

2755: ,ln_new_juri_code
2756: ,ln_new_county;
2757:
2758: if c_cursor%notfound then
2759: hr_utility.set_location(gv_package_name || '.report_12', 60);
2760: exit;
2761: end if;
2762:
2763:

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

2765: ** If Assignment Set is used, pick up only those employee
2766: ** assignments which are part of the Assignment Set - STATIC
2767: ** or DYNAMIC.
2768: ************************************************************/
2769: hr_utility.set_location(gv_package_name || '.report_12', 70);
2770: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
2771:
2772:
2773: hr_utility.set_location(gv_package_name || '.report_12', 80);

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

2766: ** assignments which are part of the Assignment Set - STATIC
2767: ** or DYNAMIC.
2768: ************************************************************/
2769: hr_utility.set_location(gv_package_name || '.report_12', 70);
2770: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
2771:
2772:
2773: hr_utility.set_location(gv_package_name || '.report_12', 80);
2774: formated_static_data( ln_full_name

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

2769: hr_utility.set_location(gv_package_name || '.report_12', 70);
2770: hr_utility.trace('Assignment ID = ' || ln_assignment_id);
2771:
2772:
2773: hr_utility.set_location(gv_package_name || '.report_12', 80);
2774: formated_static_data( ln_full_name
2775: ,ln_assignment_id
2776: ,ln_assignment_number
2777: ,null

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

2783: ,p_output_file_type
2784: ,lv_data_row1);
2785:
2786: lv_data_row := lv_data_row1;
2787: hr_utility.set_location(gv_package_name || '.report_12', 90);
2788:
2789: -- if p_output_file_type ='HTML' then
2790: lv_data_row := '

' || lv_data_row || '' ;
2791: -- end if;

Line 2833: hr_utility.set_location(gv_package_name || '.report_13', 10);

2829:
2830:
2831: BEGIN
2832:
2833: hr_utility.set_location(gv_package_name || '.report_13', 10);
2834:
2835: /****************************************************************
2836: ** Concatnating the second Header Label which includes the User
2837: ** Defined data set so that it is printed at the end of the

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

2853: ,p_output_file_type
2854: ));
2855:
2856:
2857: hr_utility.set_location(gv_package_name || '.report_13', 15);
2858: /****************************************************************
2859: ** Print the Header Information. If the format is HTML then open
2860: ** the body and table before printing the header info, otherwise
2861: ** just print the header information.

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

2864: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2865: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2866: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2867: end if;
2868: hr_utility.set_location(gv_package_name || '.report_13', 20);
2869:
2870: lv_format1 :=
2871: formated_data_string (p_input_string => 'Table Name'
2872: ,p_bold => 'Y'

Line 2880: hr_utility.set_location(gv_package_name || '.report_13', 30);

2876: ,p_bold => 'Y'
2877: ,p_output_file_type => p_output_file_type)
2878: ;
2879:
2880: hr_utility.set_location(gv_package_name || '.report_13', 30);
2881:
2882:
2883: fnd_file.put_line(fnd_file.output, lv_format1);
2884:

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

2885: if p_output_file_type ='HTML' then
2886: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2887: end if;
2888:
2889: hr_utility.set_location(gv_package_name || '.report_13', 40);
2890: /*****************************************************
2891: ** Start of the Data Section of the Report
2892: *****************************************************/
2893:

Line 2894: hr_utility.set_location(gv_package_name || '.report_13', 50);

2890: /*****************************************************
2891: ** Start of the Data Section of the Report
2892: *****************************************************/
2893:
2894: hr_utility.set_location(gv_package_name || '.report_13', 50);
2895:
2896: /************************************************************
2897: ** If Assignment Set is used, pick up only those employee
2898: ** assignments which are part of the Assignment Set - STATIC

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

2898: ** assignments which are part of the Assignment Set - STATIC
2899: ** or DYNAMIC.
2900: ************************************************************/
2901:
2902: hr_utility.set_location(gv_package_name || '.report_13', 60);
2903:
2904: -- count for pay_us_states --
2905:
2906: ln_row_count := 0;

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

2922: ,lv_data_row1);
2923:
2924:
2925: lv_data_row := lv_data_row1;
2926: hr_utility.set_location(gv_package_name || '.report_13', 65);
2927:
2928: lv_data_row := '

' || lv_data_row || '' ;
2929:
2930: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

Line 2954: hr_utility.set_location(gv_package_name || '.report_13', 70);

2950: ,lv_data_row1);
2951:
2952:
2953: lv_data_row := lv_data_row1;
2954: hr_utility.set_location(gv_package_name || '.report_13', 70);
2955:
2956: lv_data_row := '

' || lv_data_row || '' ;
2957:
2958: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

Line 2981: hr_utility.set_location(gv_package_name || '.report_13', 75);

2977: ,p_output_file_type
2978: ,lv_data_row1);
2979:
2980: lv_data_row := lv_data_row1;
2981: hr_utility.set_location(gv_package_name || '.report_13', 75);
2982:
2983: lv_data_row := '

' || lv_data_row || '' ;
2984:
2985: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

Line 3008: hr_utility.set_location(gv_package_name || '.report_13', 80);

3004: ,p_output_file_type
3005: ,lv_data_row1);
3006:
3007: lv_data_row := lv_data_row1;
3008: hr_utility.set_location(gv_package_name || '.report_13', 80);
3009:
3010: lv_data_row := '

' || lv_data_row || '' ;
3011:
3012: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

Line 3035: hr_utility.set_location(gv_package_name || '.report_13', 85);

3031: ,p_output_file_type
3032: ,lv_data_row1);
3033:
3034: lv_data_row := lv_data_row1;
3035: hr_utility.set_location(gv_package_name || '.report_13', 85);
3036:
3037: lv_data_row := '

' || lv_data_row || '' ;
3038:
3039: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

Line 3062: hr_utility.set_location(gv_package_name || '.report_13', 90);

3058: ,p_output_file_type
3059: ,lv_data_row1);
3060:
3061: lv_data_row := lv_data_row1;
3062: hr_utility.set_location(gv_package_name || '.report_13', 90);
3063:
3064: lv_data_row := '

' || lv_data_row || '' ;
3065:
3066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

Line 3201: hr_utility.set_location(gv_package_name || '.report_14', 10);

3197:
3198:
3199: BEGIN
3200:
3201: hr_utility.set_location(gv_package_name || '.report_14', 10);
3202:
3203: /****************************************************************
3204: ** Concatnating the second Header Label which includes the User
3205: ** Defined data set so that it is printed at the end of the

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

3231: ,p_output_file_type
3232: ));
3233:
3234:
3235: hr_utility.set_location(gv_package_name || '.report_14', 15);
3236: /****************************************************************
3237: ** Print the Header Information. If the format is HTML then open
3238: ** the body and table before printing the header info, otherwise
3239: ** just print the header information.

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

3242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3245: end if;
3246: hr_utility.set_location(gv_package_name || '.report_14', 20);
3247:
3248: lv_format1 :=
3249: formated_data_string (p_input_string => 'Work Location'
3250: ,p_bold => 'Y'

Line 3278: hr_utility.set_location(gv_package_name || '.report_14', 30);

3274: ,p_bold => 'Y'
3275: ,p_output_file_type => p_output_file_type)
3276: ;
3277:
3278: hr_utility.set_location(gv_package_name || '.report_14', 30);
3279:
3280:
3281: fnd_file.put_line(fnd_file.output, lv_format1);
3282:

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

3283: if p_output_file_type ='HTML' then
3284: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3285: end if;
3286:
3287: hr_utility.set_location(gv_package_name || '.report_14', 40);
3288: /*****************************************************
3289: ** Start of the Data Section of the Report
3290: *****************************************************/
3291:

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

3288: /*****************************************************
3289: ** Start of the Data Section of the Report
3290: *****************************************************/
3291:
3292: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
3293: open c_cursor( p_process_mode
3294: ,p_geocode_patch_name
3295: );
3296:

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

3294: ,p_geocode_patch_name
3295: );
3296:
3297: loop
3298: hr_utility.set_location(gv_package_name || '.report_14', 50);
3299:
3300: fetch c_cursor into ln_work_location
3301: ,ln_loc_description
3302: ,ln_address

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

3305: ,ln_state
3306: ,ln_zip_code;
3307:
3308: if c_cursor%notfound then
3309: hr_utility.set_location(gv_package_name || '.report_14', 60);
3310: exit;
3311: end if;
3312:
3313:

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

3315: ** If Assignment Set is used, pick up only those employee
3316: ** assignments which are part of the Assignment Set - STATIC
3317: ** or DYNAMIC.
3318: ************************************************************/
3319: hr_utility.set_location(gv_package_name || '.report_14', 70);
3320:
3321: hr_utility.set_location(gv_package_name || '.report_14', 80);
3322: formated_static_data( ln_work_location
3323: ,null

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

3317: ** or DYNAMIC.
3318: ************************************************************/
3319: hr_utility.set_location(gv_package_name || '.report_14', 70);
3320:
3321: hr_utility.set_location(gv_package_name || '.report_14', 80);
3322: formated_static_data( ln_work_location
3323: ,null
3324: ,ln_loc_description
3325: ,ln_city_name

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

3331: ,p_output_file_type
3332: ,lv_data_row1);
3333:
3334: lv_data_row := lv_data_row1;
3335: hr_utility.set_location(gv_package_name || '.report_14', 90);
3336:
3337: -- if p_output_file_type ='HTML' then
3338: lv_data_row := '

' || lv_data_row || '' ;
3339: -- end if;

Line 3479: hr_utility.set_location(gv_package_name || '.report_15', 10);

3475:
3476:
3477: BEGIN
3478:
3479: hr_utility.set_location(gv_package_name || '.report_15', 10);
3480:
3481: /****************************************************************
3482: ** Concatnating the second Header Label which includes the User
3483: ** Defined data set so that it is printed at the end of the

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

3509: ,p_output_file_type
3510: ));
3511:
3512:
3513: hr_utility.set_location(gv_package_name || '.report_15', 15);
3514: /****************************************************************
3515: ** Print the Header Information. If the format is HTML then open
3516: ** the body and table before printing the header info, otherwise
3517: ** just print the header information.

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

3520: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3521: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3522: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3523: end if;
3524: hr_utility.set_location(gv_package_name || '.report_15', 20);
3525:
3526: lv_format1 :=
3527: formated_data_string (p_input_string => 'Full Name'
3528: ,p_bold => 'Y'

Line 3552: hr_utility.set_location(gv_package_name || '.report_15', 30);

3548: ,p_bold => 'Y'
3549: ,p_output_file_type => p_output_file_type)
3550: ;
3551:
3552: hr_utility.set_location(gv_package_name || '.report_15', 30);
3553:
3554:
3555: fnd_file.put_line(fnd_file.output, lv_format1);
3556:

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

3557: if p_output_file_type ='HTML' then
3558: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3559: end if;
3560:
3561: hr_utility.set_location(gv_package_name || '.report_15', 40);
3562: /*****************************************************
3563: ** Start of the Data Section of the Report
3564: *****************************************************/
3565:

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

3562: /*****************************************************
3563: ** Start of the Data Section of the Report
3564: *****************************************************/
3565:
3566: -- HR_UTILITY.TRACE_ON(NULL,'TCL');
3567: open c_cursor( p_process_mode
3568: ,p_geocode_patch_name
3569: );
3570:

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

3568: ,p_geocode_patch_name
3569: );
3570:
3571: loop
3572: hr_utility.set_location(gv_package_name || '.report_15', 50);
3573:
3574: fetch c_cursor into ln_full_name
3575: ,ln_address
3576: ,ln_city_name

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

3578: ,ln_state
3579: ,ln_zip_code;
3580:
3581: if c_cursor%notfound then
3582: hr_utility.set_location(gv_package_name || '.report_15', 60);
3583: exit;
3584: end if;
3585:
3586:

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

3588: ** If Assignment Set is used, pick up only those employee
3589: ** assignments which are part of the Assignment Set - STATIC
3590: ** or DYNAMIC.
3591: ************************************************************/
3592: hr_utility.set_location(gv_package_name || '.report_15', 70);
3593:
3594: hr_utility.set_location(gv_package_name || '.report_15', 80);
3595: formated_static_data( ln_full_name
3596: ,null

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

3590: ** or DYNAMIC.
3591: ************************************************************/
3592: hr_utility.set_location(gv_package_name || '.report_15', 70);
3593:
3594: hr_utility.set_location(gv_package_name || '.report_15', 80);
3595: formated_static_data( ln_full_name
3596: ,null
3597: ,null
3598: ,ln_city_name

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

3604: ,p_output_file_type
3605: ,lv_data_row1);
3606:
3607: lv_data_row := lv_data_row1;
3608: hr_utility.set_location(gv_package_name || '.report_15', 90);
3609:
3610: -- if p_output_file_type ='HTML' then
3611: lv_data_row := '

' || lv_data_row || '' ;
3612: -- end if;

Line 3655: hr_utility.set_location(gv_package_name || '.extract_data', 10);

3651: BEGIN
3652:
3653: lv_output_file_type := 'HTML';
3654:
3655: hr_utility.set_location(gv_package_name || '.extract_data', 10);
3656:
3657: report_1 ( p_process_mode => p_process_mode
3658: ,p_geocode_patch_name => p_geocode_patch_name
3659: ,p_output_file_type => lv_output_file_type);

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

3713: report_15 ( p_process_mode => p_process_mode
3714: ,p_geocode_patch_name => p_geocode_patch_name
3715: ,p_output_file_type => lv_output_file_type);
3716:
3717: hr_utility.trace('Concurrent Request ID = ' || FND_GLOBAL.CONC_REQUEST_ID);
3718:
3719: END extract_data;
3720:
3721: --begin

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

3718:
3719: END extract_data;
3720:
3721: --begin
3722: --hr_utility.trace_on(null, 'ELE');
3723: end pay_us_geocode_report_pkg;