' || p_input_string ||

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

130: if p_output_file_type = 'CSV' then
131: hr_utility.set_location(gv_package_name || '.formated_header_string', 20);
132: lv_format := p_input_string;
133: elsif p_output_file_type = 'HTML' then
134: hr_utility.set_location(gv_package_name || '.formated_header_string', 30);
135: lv_format := '

' || p_input_string ||
136: '

';
137: end if;
138:

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

135: lv_format := '

' || p_input_string ||
136: '

';
137: end if;
138:
139: hr_utility.set_location(gv_package_name || '.formated_header_string', 40);
140: return lv_format;
141:
142: END formated_header_string;
143:

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

160: lv_format varchar2(1000);
161: lv_bold varchar2(10);
162: BEGIN
163: lv_bold := nvl(p_bold,'N');
164: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);
165: if p_output_file_type = 'CSV' then
166: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);
167: lv_format := gc_csv_data_delimiter || p_input_string ||
168: gc_csv_data_delimiter || gc_csv_delimiter;

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

162: BEGIN
163: lv_bold := nvl(p_bold,'N');
164: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);
165: if p_output_file_type = 'CSV' then
166: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);
167: lv_format := gc_csv_data_delimiter || p_input_string ||
168: gc_csv_data_delimiter || gc_csv_delimiter;
169: elsif p_output_file_type = 'HTML' then
170: if p_input_string is null then

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

167: lv_format := gc_csv_data_delimiter || p_input_string ||
168: gc_csv_data_delimiter || gc_csv_delimiter;
169: elsif p_output_file_type = 'HTML' then
170: if p_input_string is null then
171: hr_utility.set_location(gv_package_name || '.formated_data_string', 30);
172: lv_format := gv_html_start_data || ' ' || gv_html_end_data;
173: else
174: if lv_bold = 'Y' then
175: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);

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

171: hr_utility.set_location(gv_package_name || '.formated_data_string', 30);
172: lv_format := gv_html_start_data || ' ' || gv_html_end_data;
173: else
174: if lv_bold = 'Y' then
175: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);
176: lv_format := gv_html_start_data || ' ' || p_input_string
177: || '' || gv_html_end_data;
178: else
179: hr_utility.set_location(gv_package_name || '.formated_data_string', 50);

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

175: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);
176: lv_format := gv_html_start_data || ' ' || p_input_string
177: || '' || gv_html_end_data;
178: else
179: hr_utility.set_location(gv_package_name || '.formated_data_string', 50);
180: lv_format := gv_html_start_data || p_input_string || gv_html_end_data;
181: end if;
182: end if;
183: end if;

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

181: end if;
182: end if;
183: end if;
184:
185: hr_utility.set_location(gv_package_name || '.formated_data_string', 60);
186: return lv_format;
187:
188: END formated_data_string;
189:

Line 201: hr_utility.set_location(gv_package_name || '.formated_header_state', 10);

197: lv_format2 varchar2(32000);
198:
199: BEGIN
200:
201: hr_utility.set_location(gv_package_name || '.formated_header_state', 10);
202: lv_format1 :=
203: formated_data_string (p_input_string => 'Year '
204: ,p_bold => 'Y'
205: ,p_output_file_type => p_output_file_type) ||

Line 234: hr_utility.set_location(gv_package_name || '.formated_header_state', 20);

230: ,p_bold => 'Y'
231: ,p_output_file_type => p_output_file_type)
232: ;
233:
234: hr_utility.set_location(gv_package_name || '.formated_header_state', 20);
235: lv_format2 :=
236: formated_data_string (p_input_string => 'Live '
237: ,p_bold => 'Y'
238: ,p_output_file_type => p_output_file_type) ||

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

240: ,p_bold => 'Y'
241: ,p_output_file_type => p_output_file_type)
242: ;
243:
244: hr_utility.trace('Static Label1 = ' || lv_format1);
245: hr_utility.trace('Static Label2 = ' || lv_format2);
246:
247: return lv_format1 || lv_format2;
248:

Line 245: hr_utility.trace('Static Label2 = ' || lv_format2);

241: ,p_output_file_type => p_output_file_type)
242: ;
243:
244: hr_utility.trace('Static Label1 = ' || lv_format1);
245: hr_utility.trace('Static Label2 = ' || lv_format2);
246:
247: return lv_format1 || lv_format2;
248:
249: hr_utility.set_location(gv_package_name || '.formated_header_state', 40);

Line 249: hr_utility.set_location(gv_package_name || '.formated_header_state', 40);

245: hr_utility.trace('Static Label2 = ' || lv_format2);
246:
247: return lv_format1 || lv_format2;
248:
249: hr_utility.set_location(gv_package_name || '.formated_header_state', 40);
250:
251: END formated_header_state;
252:
253:

Line 264: hr_utility.set_location(gv_package_name || '.formated_header_federal', 10);

260: lv_format2 varchar2(32000);
261:
262: BEGIN
263:
264: hr_utility.set_location(gv_package_name || '.formated_header_federal', 10);
265: lv_format1 :=
266: formated_data_string (p_input_string => 'Year '
267: ,p_bold => 'Y'
268: ,p_output_file_type => p_output_file_type) ||

Line 289: hr_utility.set_location(gv_package_name || '.formated_header_federal', 20);

285: ,p_bold => 'Y'
286: ,p_output_file_type => p_output_file_type)
287: ;
288:
289: hr_utility.set_location(gv_package_name || '.formated_header_federal', 20);
290: lv_format2 :=
291: formated_data_string (p_input_string => 'Live '
292: ,p_bold => 'Y'
293: ,p_output_file_type => p_output_file_type) ||

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

295: ,p_bold => 'Y'
296: ,p_output_file_type => p_output_file_type)
297: ;
298:
299: hr_utility.trace('Static Label1 = ' || lv_format1);
300: hr_utility.trace('Static Label2 = ' || lv_format2);
301: return lv_format1 || lv_format2;
302:
303: hr_utility.set_location(gv_package_name || '.formated_header_federal', 40);

Line 300: hr_utility.trace('Static Label2 = ' || lv_format2);

296: ,p_output_file_type => p_output_file_type)
297: ;
298:
299: hr_utility.trace('Static Label1 = ' || lv_format1);
300: hr_utility.trace('Static Label2 = ' || lv_format2);
301: return lv_format1 || lv_format2;
302:
303: hr_utility.set_location(gv_package_name || '.formated_header_federal', 40);
304:

Line 303: hr_utility.set_location(gv_package_name || '.formated_header_federal', 40);

299: hr_utility.trace('Static Label1 = ' || lv_format1);
300: hr_utility.trace('Static Label2 = ' || lv_format2);
301: return lv_format1 || lv_format2;
302:
303: hr_utility.set_location(gv_package_name || '.formated_header_federal', 40);
304:
305: END formated_header_federal;
306:
307:

Line 330: hr_utility.set_location(gv_package_name || '.formated_detail_state', 10);

326: lv_format2 varchar2(10000);
327:
328: BEGIN
329:
330: hr_utility.set_location(gv_package_name || '.formated_detail_state', 10);
331: lv_format1 :=
332: formated_data_string (p_input_string => p_year
333: ,p_bold => 'N'
334: ,p_output_file_type => p_output_file_type) ||

Line 361: hr_utility.set_location(gv_package_name || '.formated_detail_state', 20);

357: ,p_bold => 'N'
358: ,p_output_file_type => p_output_file_type)
359: ;
360:
361: hr_utility.set_location(gv_package_name || '.formated_detail_state', 20);
362: lv_format2 :=
363: formated_data_string (p_input_string => p_live_balance
364: ,p_bold => 'N'
365: ,p_output_file_type => p_output_file_type) ||

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

367: ,p_bold => 'N'
368: ,p_output_file_type => p_output_file_type)
369: ;
370:
371: hr_utility.trace('Static Label1 = ' || lv_format1);
372: hr_utility.trace('Static Label2 = ' || lv_format2);
373:
374: hr_utility.set_location(gv_package_name || '.formated_detail_state', 30);
375:

Line 372: hr_utility.trace('Static Label2 = ' || lv_format2);

368: ,p_output_file_type => p_output_file_type)
369: ;
370:
371: hr_utility.trace('Static Label1 = ' || lv_format1);
372: hr_utility.trace('Static Label2 = ' || lv_format2);
373:
374: hr_utility.set_location(gv_package_name || '.formated_detail_state', 30);
375:
376: return lv_format1 || lv_format2;

Line 374: hr_utility.set_location(gv_package_name || '.formated_detail_state', 30);

370:
371: hr_utility.trace('Static Label1 = ' || lv_format1);
372: hr_utility.trace('Static Label2 = ' || lv_format2);
373:
374: hr_utility.set_location(gv_package_name || '.formated_detail_state', 30);
375:
376: return lv_format1 || lv_format2;
377:
378: END formated_detail_state;

Line 400: hr_utility.set_location(gv_package_name || '.formated_detail_federal', 10);

396: lv_format2 varchar2(10000);
397:
398: BEGIN
399:
400: hr_utility.set_location(gv_package_name || '.formated_detail_federal', 10);
401: lv_format1 :=
402: formated_data_string (p_input_string => p_year
403: ,p_bold => 'N'
404: ,p_output_file_type => p_output_file_type) ||

Line 425: hr_utility.set_location(gv_package_name || '.formated_detail_federal', 20);

421: ,p_bold => 'N'
422: ,p_output_file_type => p_output_file_type)
423: ;
424:
425: hr_utility.set_location(gv_package_name || '.formated_detail_federal', 20);
426: lv_format2 :=
427: formated_data_string (p_input_string => p_live_balance
428: ,p_bold => 'N'
429: ,p_output_file_type => p_output_file_type) ||

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

431: ,p_bold => 'N'
432: ,p_output_file_type => p_output_file_type)
433: ;
434:
435: hr_utility.trace('Static Label1 = ' || lv_format1);
436: hr_utility.trace('Static Label2 = ' || lv_format2);
437:
438: hr_utility.set_location(gv_package_name || '.formated_detail_federal', 30);
439:

Line 436: hr_utility.trace('Static Label2 = ' || lv_format2);

432: ,p_output_file_type => p_output_file_type)
433: ;
434:
435: hr_utility.trace('Static Label1 = ' || lv_format1);
436: hr_utility.trace('Static Label2 = ' || lv_format2);
437:
438: hr_utility.set_location(gv_package_name || '.formated_detail_federal', 30);
439:
440: return lv_format1 || lv_format2;

Line 438: hr_utility.set_location(gv_package_name || '.formated_detail_federal', 30);

434:
435: hr_utility.trace('Static Label1 = ' || lv_format1);
436: hr_utility.trace('Static Label2 = ' || lv_format2);
437:
438: hr_utility.set_location(gv_package_name || '.formated_detail_federal', 30);
439:
440: return lv_format1 || lv_format2;
441:
442: END formated_detail_federal;

Line 458: hr_utility.set_location(gv_package_name || '.formated_no_diff', 10);

454: lvc_message := 'For ' || substr(p_lookup_description,1,30) || ', Number of Employees compared = '
455: || to_char(p_employee_count)
456: || ' Number of Employees with difference = '
457: || to_char(p_diff_count);
458: hr_utility.set_location(gv_package_name || '.formated_no_diff', 10);
459: fnd_file.put_line(fnd_file.output,formated_data_string (p_input_string => lvc_message
460: ,p_bold => 'N'
461: ,p_output_file_type => output_file_type));
462: END IF;

Line 476: hr_utility.set_location(gv_package_name || '.formated_zero_count', 10);

472: null;
473: -- IF output_file_type = 'CSV' THEN
474: lvc_message := 'No person was picked up for comparision based on selection parameters.' ||
475: ' Ensure GRE has employees and all employees were successfully archived in the YEPP for the GRE.';
476: hr_utility.set_location(gv_package_name || '.formated_zero_count', 10);
477: fnd_file.put_line(fnd_file.output, formated_data_string (p_input_string => lvc_message
478: ,p_bold => 'N'
479: ,p_output_file_type => output_file_type));
480: -- END IF;

Line 481: hr_utility.set_location(gv_package_name || '.formated_zero_count', 20);

477: fnd_file.put_line(fnd_file.output, formated_data_string (p_input_string => lvc_message
478: ,p_bold => 'N'
479: ,p_output_file_type => output_file_type));
480: -- END IF;
481: hr_utility.set_location(gv_package_name || '.formated_zero_count', 20);
482: END;
483:
484: /* get the archive value */
485:

Line 496: hr_utility.set_location(gv_package_name || '.get_archive_value', 10);

492: IS
493:
494: BEGIN
495:
496: hr_utility.set_location(gv_package_name || '.get_archive_value', 10);
497:
498:
499:
500: /* Set jurisdiction value */

Line 504: hr_utility.set_location(gv_package_name || '.get_archive_value', 20);

500: /* Set jurisdiction value */
501:
502: return hr_us_w2_rep.get_w2_arch_bal(p_assignment_action_id,p_balance_name,p_tax_unit_id, p_jurisdiction,p_jurisdiction_level);
503:
504: hr_utility.set_location(gv_package_name || '.get_archive_value', 20);
505:
506: END; /* get_archive_value */
507:
508:

Line 670: hr_utility.set_location(gv_package_name || '.get_live_value', 10);

666: ) return number
667: IS
668: lvn_cal_value number ;
669: BEGIN
670: hr_utility.set_location(gv_package_name || '.get_live_value', 10);
671: hr_utility.trace('balance_name = ' || p_balance_name );
672: IF p_balance_name = 'A_WAGES' THEN
673: lvn_cal_value := gvr_balance(1).bal_value
674: + gvr_balance(2).bal_value

Line 671: hr_utility.trace('balance_name = ' || p_balance_name );

667: IS
668: lvn_cal_value number ;
669: BEGIN
670: hr_utility.set_location(gv_package_name || '.get_live_value', 10);
671: hr_utility.trace('balance_name = ' || p_balance_name );
672: IF p_balance_name = 'A_WAGES' THEN
673: lvn_cal_value := gvr_balance(1).bal_value
674: + gvr_balance(2).bal_value
675: + gvr_balance(3).bal_value

Line 693: hr_utility.set_location(gv_package_name || '.get_live_value', 20);

689:
690: lvn_cal_value := gvr_balance(1).bal_value ;
691: END IF;
692: return lvn_cal_value;
693: hr_utility.set_location(gv_package_name || '.get_live_value', 20);
694: END; /* Get Live value fucntion call */
695:
696:
697: /*****************************************************************

Line 870: hr_utility.set_location(gv_package_name || '.select_employee', 10);

866: lvn_live_aaid number := 0;
867: lvc_message varchar2(32000);
868: BEGIN
869:
870: hr_utility.set_location(gv_package_name || '.select_employee', 10);
871: /* build the jurisdiction code based on State Code */
872: IF p_fed_state = 'Federal' THEN
873: /* Bug 2554865 - Modified to handle 1099R specific Federal lookup */
874: IF p_box_type = 'W-2' THEN

Line 938: hr_utility.trace(' State Abbereviation or GRE Name cursor failed');

934:
935:
936: EXCEPTION
937: WHEN OTHERS THEN
938: hr_utility.trace(' State Abbereviation or GRE Name cursor failed');
939: END;
940:
941: hr_utility.set_location(gv_package_name || '.select_employee', 20);
942: -- code is hard coded to get only one value dJoshi will change and will be based on value

Line 941: hr_utility.set_location(gv_package_name || '.select_employee', 20);

937: WHEN OTHERS THEN
938: hr_utility.trace(' State Abbereviation or GRE Name cursor failed');
939: END;
940:
941: hr_utility.set_location(gv_package_name || '.select_employee', 20);
942: -- code is hard coded to get only one value dJoshi will change and will be based on value
943:
944:
945: /* set the context for the give Tax unit_id and jurisdiction only once in report */

Line 962: hr_utility.set_location(gv_package_name || '.select_employee', 30);

958:
959:
960:
961:
962: hr_utility.set_location(gv_package_name || '.select_employee', 30);
963: /* Get the assignment action id for the live call */
964:
965: open c_live_ass_action_id(lvn_person_id, lvn_tax_unit_id,
966: lvd_start_of_year , lvd_end_of_year );

Line 986: hr_utility.set_location(gv_package_name || '.select_employee', 40);

982:
983: /* Get Live Balance */
984: populate_balance_value(lvn_live_aaid,p_box_name);
985:
986: hr_utility.set_location(gv_package_name || '.select_employee', 40);
987: lvn_live_value := get_live_value (
988: lvc_balance_name
989: ) ;
990:

Line 991: hr_utility.set_location(gv_package_name || '.select_employee', 50);

987: lvn_live_value := get_live_value (
988: lvc_balance_name
989: ) ;
990:
991: hr_utility.set_location(gv_package_name || '.select_employee', 50);
992: /* Compare the Balances */
993: IF lvn_live_value <> lvn_archive_value THEN
994: /* Get the value of person */
995: null;

Line 998: hr_utility.set_location(gv_package_name || '.select_employee', 60);

994: /* Get the value of person */
995: null;
996: /* get person Value */
997:
998: hr_utility.set_location(gv_package_name || '.select_employee', 60);
999: lvc_last_name := hr_us_w2_rep.get_per_item(i.assignment_action_id,'A_PER_LAST_NAME' );
1000: lvc_first_name :=hr_us_w2_rep.get_per_item(i.assignment_action_id,'A_PER_FIRST_NAME' );
1001: lvc_national_identifier := nvl(hr_us_w2_rep.get_per_item(i.assignment_action_id, 'A_PER_NATIONAL_IDENTIFIER'),'Applied For');
1002: open c_employee_number(i.serial_number);

Line 1009: hr_utility.set_location(gv_package_name || '.select_employee', 70);

1005:
1006: lvc_name := lvc_first_name || ' ' || lvc_last_name ;
1007: lvc_name := replace(lvc_name,',',' ');
1008:
1009: hr_utility.set_location(gv_package_name || '.select_employee', 70);
1010:
1011: /* Print header for the first time for Federal or state comparision*/
1012: if lvn_diff_count = 0 THEN
1013:

Line 1043: hr_utility.set_location(gv_package_name || '.select_employee', 80);

1039: lvn_diff_value := lvn_archive_value - lvn_live_value ;
1040:
1041: /* print details based on record */
1042:
1043: hr_utility.set_location(gv_package_name || '.select_employee', 80);
1044: IF p_fed_state = 'Federal' THEN
1045:
1046:
1047: lv_data_row := formated_detail_federal(

Line 1066: hr_utility.set_location(gv_package_name || '.select_employee', 90);

1062:
1063: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1064:
1065:
1066: hr_utility.set_location(gv_package_name || '.select_employee', 90);
1067: ELSIF p_fed_state = 'State' THEN
1068:
1069:
1070: lv_data_row := formated_detail_state(

Line 1091: hr_utility.set_location(gv_package_name || '.select_employee', 100);

1087: end if;
1088:
1089: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1090:
1091: hr_utility.set_location(gv_package_name || '.select_employee', 100);
1092:
1093: END IF; /* to print the details */
1094:
1095: /* increament the count of Imployee */

Line 1114: hr_utility.set_location(gv_package_name || '.select_employee', 110);

1110:
1111:
1112: IF lvn_employee_count = 0 THEN
1113: formated_zero_count(p_output_file_type);
1114: hr_utility.set_location(gv_package_name || '.select_employee', 110);
1115: END IF ;
1116:
1117: /* If there was anything written then clsoe for HTML format */
1118:

Line 1144: hr_utility.set_location(gv_package_name || '.select_employee', 130);

1140: lvn_employee_count, lvn_diff_count);
1141: END IF; /* if html */
1142:
1143: END IF; /* count > 0 */
1144: hr_utility.set_location(gv_package_name || '.select_employee', 130);
1145: END IF; /* IF employee Count > 0 */
1146:
1147:
1148: IF p_output_file_type ='HTML' THEN

Line 1156: hr_utility.set_location(gv_package_name || '.select_employee', 160);

1152:
1153: COMMIT;
1154: END IF;
1155:
1156: hr_utility.set_location(gv_package_name || '.select_employee', 160);
1157:
1158: END select_employee;
1159:
1160:

Line 1163: --hr_utility.trace_on(null, 'ORACLE');

1159:
1160:
1161:
1162: --begin
1163: --hr_utility.trace_on(null, 'ORACLE');
1164: end pay_livearchive_pkg;