' || p_input_string ||

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

137: if p_output_file_type = 'CSV' then
138: hr_utility.set_location(gv_package_name || '.formated_header_string', 20);
139: lv_format := p_input_string;
140: elsif p_output_file_type = 'HTML' then
141: hr_utility.set_location(gv_package_name || '.formated_header_string', 30);
142: lv_format := '

' || p_input_string ||
143: '

';
144: end if;
145:

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

142: lv_format := '

' || p_input_string ||
143: '

';
144: end if;
145:
146: hr_utility.set_location(gv_package_name || '.formated_header_string', 40);
147: return lv_format;
148:
149: END formated_header_string;
150:

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

167: lv_format varchar2(1000);
168: lv_bold varchar2(10);
169: BEGIN
170: lv_bold := nvl(p_bold,'N');
171: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);
172: if p_output_file_type = 'CSV' then
173: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);
174: lv_format := gc_csv_data_delimiter || p_input_string ||
175: gc_csv_data_delimiter || gc_csv_delimiter;

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

169: BEGIN
170: lv_bold := nvl(p_bold,'N');
171: hr_utility.set_location(gv_package_name || '.formated_data_string', 10);
172: if p_output_file_type = 'CSV' then
173: hr_utility.set_location(gv_package_name || '.formated_data_string', 20);
174: lv_format := gc_csv_data_delimiter || p_input_string ||
175: gc_csv_data_delimiter || gc_csv_delimiter;
176: elsif p_output_file_type = 'HTML' then
177: if p_input_string is null then

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

174: lv_format := gc_csv_data_delimiter || p_input_string ||
175: gc_csv_data_delimiter || gc_csv_delimiter;
176: elsif p_output_file_type = 'HTML' then
177: if p_input_string is null then
178: hr_utility.set_location(gv_package_name || '.formated_data_string', 30);
179: lv_format := gv_html_start_data || ' ' || gv_html_end_data;
180: else
181: if lv_bold = 'Y' then
182: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);

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

178: hr_utility.set_location(gv_package_name || '.formated_data_string', 30);
179: lv_format := gv_html_start_data || ' ' || gv_html_end_data;
180: else
181: if lv_bold = 'Y' then
182: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);
183: lv_format := gv_html_start_data || ' ' || p_input_string
184: || '' || gv_html_end_data;
185: else
186: hr_utility.set_location(gv_package_name || '.formated_data_string', 50);

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

182: hr_utility.set_location(gv_package_name || '.formated_data_string', 40);
183: lv_format := gv_html_start_data || ' ' || p_input_string
184: || '' || gv_html_end_data;
185: else
186: hr_utility.set_location(gv_package_name || '.formated_data_string', 50);
187: lv_format := gv_html_start_data || p_input_string || gv_html_end_data;
188: end if;
189: end if;
190: end if;

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

188: end if;
189: end if;
190: end if;
191:
192: hr_utility.set_location(gv_package_name || '.formated_data_string', 60);
193: return lv_format;
194:
195: END formated_data_string;
196:

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

204: lv_format2 varchar2(32000);
205:
206: BEGIN
207:
208: hr_utility.set_location(gv_package_name || '.formated_header_state', 10);
209: lv_format1 :=
210: formated_data_string (p_input_string => 'Year '
211: ,p_bold => 'Y'
212: ,p_output_file_type => p_output_file_type) ||

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

237: ,p_bold => 'Y'
238: ,p_output_file_type => p_output_file_type)
239: ;
240:
241: hr_utility.set_location(gv_package_name || '.formated_header_state', 20);
242: lv_format2 :=
243: formated_data_string (p_input_string => 'Live '
244: ,p_bold => 'Y'
245: ,p_output_file_type => p_output_file_type) ||

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

247: ,p_bold => 'Y'
248: ,p_output_file_type => p_output_file_type)
249: ;
250:
251: hr_utility.trace('Static Label1 = ' || lv_format1);
252: hr_utility.trace('Static Label2 = ' || lv_format2);
253:
254: return lv_format1 || lv_format2;
255:

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

248: ,p_output_file_type => p_output_file_type)
249: ;
250:
251: hr_utility.trace('Static Label1 = ' || lv_format1);
252: hr_utility.trace('Static Label2 = ' || lv_format2);
253:
254: return lv_format1 || lv_format2;
255:
256: hr_utility.set_location(gv_package_name || '.formated_header_state', 40);

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

252: hr_utility.trace('Static Label2 = ' || lv_format2);
253:
254: return lv_format1 || lv_format2;
255:
256: hr_utility.set_location(gv_package_name || '.formated_header_state', 40);
257:
258: END formated_header_state;
259:
260:

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

267: lv_format2 varchar2(32000);
268:
269: BEGIN
270:
271: hr_utility.set_location(gv_package_name || '.formated_header_federal', 10);
272: lv_format1 :=
273: formated_data_string (p_input_string => 'Year '
274: ,p_bold => 'Y'
275: ,p_output_file_type => p_output_file_type) ||

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

292: ,p_bold => 'Y'
293: ,p_output_file_type => p_output_file_type)
294: ;
295:
296: hr_utility.set_location(gv_package_name || '.formated_header_federal', 20);
297: lv_format2 :=
298: formated_data_string (p_input_string => 'Live '
299: ,p_bold => 'Y'
300: ,p_output_file_type => p_output_file_type) ||

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

302: ,p_bold => 'Y'
303: ,p_output_file_type => p_output_file_type)
304: ;
305:
306: hr_utility.trace('Static Label1 = ' || lv_format1);
307: hr_utility.trace('Static Label2 = ' || lv_format2);
308: return lv_format1 || lv_format2;
309:
310: hr_utility.set_location(gv_package_name || '.formated_header_federal', 40);

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

303: ,p_output_file_type => p_output_file_type)
304: ;
305:
306: hr_utility.trace('Static Label1 = ' || lv_format1);
307: hr_utility.trace('Static Label2 = ' || lv_format2);
308: return lv_format1 || lv_format2;
309:
310: hr_utility.set_location(gv_package_name || '.formated_header_federal', 40);
311:

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

306: hr_utility.trace('Static Label1 = ' || lv_format1);
307: hr_utility.trace('Static Label2 = ' || lv_format2);
308: return lv_format1 || lv_format2;
309:
310: hr_utility.set_location(gv_package_name || '.formated_header_federal', 40);
311:
312: END formated_header_federal;
313:
314:

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

333: lv_format2 varchar2(10000);
334:
335: BEGIN
336:
337: hr_utility.set_location(gv_package_name || '.formated_detail_state', 10);
338: lv_format1 :=
339: formated_data_string (p_input_string => p_year
340: ,p_bold => 'N'
341: ,p_output_file_type => p_output_file_type) ||

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

364: ,p_bold => 'N'
365: ,p_output_file_type => p_output_file_type)
366: ;
367:
368: hr_utility.set_location(gv_package_name || '.formated_detail_state', 20);
369: lv_format2 :=
370: formated_data_string (p_input_string => p_live_balance
371: ,p_bold => 'N'
372: ,p_output_file_type => p_output_file_type) ||

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

374: ,p_bold => 'N'
375: ,p_output_file_type => p_output_file_type)
376: ;
377:
378: hr_utility.trace('Static Label1 = ' || lv_format1);
379: hr_utility.trace('Static Label2 = ' || lv_format2);
380:
381: hr_utility.set_location(gv_package_name || '.formated_detail_state', 30);
382:

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

375: ,p_output_file_type => p_output_file_type)
376: ;
377:
378: hr_utility.trace('Static Label1 = ' || lv_format1);
379: hr_utility.trace('Static Label2 = ' || lv_format2);
380:
381: hr_utility.set_location(gv_package_name || '.formated_detail_state', 30);
382:
383: return lv_format1 || lv_format2;

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

377:
378: hr_utility.trace('Static Label1 = ' || lv_format1);
379: hr_utility.trace('Static Label2 = ' || lv_format2);
380:
381: hr_utility.set_location(gv_package_name || '.formated_detail_state', 30);
382:
383: return lv_format1 || lv_format2;
384:
385: END formated_detail_state;

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

403: lv_format2 varchar2(10000);
404:
405: BEGIN
406:
407: hr_utility.set_location(gv_package_name || '.formated_detail_federal', 10);
408: lv_format1 :=
409: formated_data_string (p_input_string => p_year
410: ,p_bold => 'N'
411: ,p_output_file_type => p_output_file_type) ||

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

428: ,p_bold => 'N'
429: ,p_output_file_type => p_output_file_type)
430: ;
431:
432: hr_utility.set_location(gv_package_name || '.formated_detail_federal', 20);
433: lv_format2 :=
434: formated_data_string (p_input_string => p_live_balance
435: ,p_bold => 'N'
436: ,p_output_file_type => p_output_file_type) ||

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

438: ,p_bold => 'N'
439: ,p_output_file_type => p_output_file_type)
440: ;
441:
442: hr_utility.trace('Static Label1 = ' || lv_format1);
443: hr_utility.trace('Static Label2 = ' || lv_format2);
444:
445: hr_utility.set_location(gv_package_name || '.formated_detail_federal', 30);
446:

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

439: ,p_output_file_type => p_output_file_type)
440: ;
441:
442: hr_utility.trace('Static Label1 = ' || lv_format1);
443: hr_utility.trace('Static Label2 = ' || lv_format2);
444:
445: hr_utility.set_location(gv_package_name || '.formated_detail_federal', 30);
446:
447: return lv_format1 || lv_format2;

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

441:
442: hr_utility.trace('Static Label1 = ' || lv_format1);
443: hr_utility.trace('Static Label2 = ' || lv_format2);
444:
445: hr_utility.set_location(gv_package_name || '.formated_detail_federal', 30);
446:
447: return lv_format1 || lv_format2;
448:
449: END formated_detail_federal;

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

461: lvc_message := 'For ' || substr(p_lookup_description,1,30) || ', Number of Employees compared = '
462: || to_char(p_employee_count)
463: || ' Number of Employees with difference = '
464: || to_char(p_diff_count);
465: hr_utility.set_location(gv_package_name || '.formated_no_diff', 10);
466: fnd_file.put_line(fnd_file.output,formated_data_string (p_input_string => lvc_message
467: ,p_bold => 'N'
468: ,p_output_file_type => output_file_type));
469: END IF;

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

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

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

484: fnd_file.put_line(fnd_file.output, formated_data_string (p_input_string => lvc_message
485: ,p_bold => 'N'
486: ,p_output_file_type => output_file_type));
487: -- END IF;
488: hr_utility.set_location(gv_package_name || '.formated_zero_count', 20);
489: END;
490:
491: /* get the archive value */
492:

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

499: IS
500:
501: BEGIN
502:
503: hr_utility.set_location(gv_package_name || '.get_archive_value', 10);
504:
505:
506:
507: /* Set jurisdiction value */

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

507: /* Set jurisdiction value */
508:
509: 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);
510:
511: hr_utility.set_location(gv_package_name || '.get_archive_value', 20);
512:
513: END; /* get_archive_value */
514:
515:

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

734: IS
735: lvn_cal_value number ;
736: l_direct_fed_bal_call VARCHAR2(2):= 'N';
737: BEGIN
738: hr_utility.set_location(gv_package_name || '.get_live_value', 10);
739: hr_utility.trace('balance_name = ' || p_balance_name );
740: IF p_balance_name = 'A_WAGES' THEN
741:
742: l_direct_fed_bal_call := nvl(fnd_profile.value('PAY_DIRECT_US_FEDERAL_BALANCES'),'N'); /*Added for Bug#13326069*/

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

735: lvn_cal_value number ;
736: l_direct_fed_bal_call VARCHAR2(2):= 'N';
737: BEGIN
738: hr_utility.set_location(gv_package_name || '.get_live_value', 10);
739: hr_utility.trace('balance_name = ' || p_balance_name );
740: IF p_balance_name = 'A_WAGES' THEN
741:
742: l_direct_fed_bal_call := nvl(fnd_profile.value('PAY_DIRECT_US_FEDERAL_BALANCES'),'N'); /*Added for Bug#13326069*/
743:

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

778:
779: lvn_cal_value := gvr_balance(1).bal_value ;
780: END IF;
781: return lvn_cal_value;
782: hr_utility.set_location(gv_package_name || '.get_live_value', 20);
783: END; /* Get Live value fucntion call */
784:
785:
786: /*****************************************************************

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

955: lvn_live_aaid number := 0;
956: lvc_message varchar2(32000);
957: BEGIN
958: gv_direct_fed_data_archived := hr_us_ff_udfs.direct_fed_data_archived(p_year); /*Added for Bug#13614766*/
959: hr_utility.set_location(gv_package_name || '.select_employee', 10);
960: /* build the jurisdiction code based on State Code */
961: IF p_fed_state = 'Federal' THEN
962: /* Bug 2554865 - Modified to handle 1099R specific Federal lookup */
963: IF p_box_type = 'W-2' THEN

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

1023:
1024:
1025: EXCEPTION
1026: WHEN OTHERS THEN
1027: hr_utility.trace(' State Abbereviation or GRE Name cursor failed');
1028: END;
1029:
1030: hr_utility.set_location(gv_package_name || '.select_employee', 20);
1031: -- code is hard coded to get only one value dJoshi will change and will be based on value

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

1026: WHEN OTHERS THEN
1027: hr_utility.trace(' State Abbereviation or GRE Name cursor failed');
1028: END;
1029:
1030: hr_utility.set_location(gv_package_name || '.select_employee', 20);
1031: -- code is hard coded to get only one value dJoshi will change and will be based on value
1032:
1033:
1034: /* set the context for the give Tax unit_id and jurisdiction only once in report */

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

1047:
1048:
1049:
1050:
1051: hr_utility.set_location(gv_package_name || '.select_employee', 30);
1052: /* Get the assignment action id for the live call */
1053:
1054: open c_live_ass_action_id(lvn_person_id, lvn_tax_unit_id,
1055: lvd_start_of_year , lvd_end_of_year );

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

1071:
1072: /* Get Live Balance */
1073: populate_balance_value(lvn_live_aaid,p_box_name);
1074:
1075: hr_utility.set_location(gv_package_name || '.select_employee', 40);
1076: lvn_live_value := get_live_value (
1077: lvc_balance_name
1078: ) ;
1079:

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

1076: lvn_live_value := get_live_value (
1077: lvc_balance_name
1078: ) ;
1079:
1080: hr_utility.set_location(gv_package_name || '.select_employee', 50);
1081: /* Compare the Balances */
1082: IF lvn_live_value <> lvn_archive_value THEN
1083: /* Get the value of person */
1084: null;

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

1083: /* Get the value of person */
1084: null;
1085: /* get person Value */
1086:
1087: hr_utility.set_location(gv_package_name || '.select_employee', 60);
1088: lvc_last_name := hr_us_w2_rep.get_per_item(i.assignment_action_id,'A_PER_LAST_NAME' );
1089: lvc_first_name :=hr_us_w2_rep.get_per_item(i.assignment_action_id,'A_PER_FIRST_NAME' );
1090: lvc_national_identifier := nvl(hr_us_w2_rep.get_per_item(i.assignment_action_id, 'A_PER_NATIONAL_IDENTIFIER'),'Applied For');
1091: open c_employee_number(i.serial_number);

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

1094:
1095: lvc_name := lvc_first_name || ' ' || lvc_last_name ;
1096: lvc_name := replace(lvc_name,',',' ');
1097:
1098: hr_utility.set_location(gv_package_name || '.select_employee', 70);
1099:
1100: /* Print header for the first time for Federal or state comparision*/
1101: if lvn_diff_count = 0 THEN
1102:

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

1128: lvn_diff_value := lvn_archive_value - lvn_live_value ;
1129:
1130: /* print details based on record */
1131:
1132: hr_utility.set_location(gv_package_name || '.select_employee', 80);
1133: IF p_fed_state = 'Federal' THEN
1134:
1135:
1136: lv_data_row := formated_detail_federal(

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

1151:
1152: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1153:
1154:
1155: hr_utility.set_location(gv_package_name || '.select_employee', 90);
1156: ELSIF p_fed_state = 'State' THEN
1157:
1158:
1159: lv_data_row := formated_detail_state(

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

1176: end if;
1177:
1178: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1179:
1180: hr_utility.set_location(gv_package_name || '.select_employee', 100);
1181:
1182: END IF; /* to print the details */
1183:
1184: /* increament the count of Imployee */

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

1199:
1200:
1201: IF lvn_employee_count = 0 THEN
1202: formated_zero_count(p_output_file_type);
1203: hr_utility.set_location(gv_package_name || '.select_employee', 110);
1204: END IF ;
1205:
1206: /* If there was anything written then clsoe for HTML format */
1207:

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

1229: lvn_employee_count, lvn_diff_count);
1230: END IF; /* if html */
1231:
1232: END IF; /* count > 0 */
1233: hr_utility.set_location(gv_package_name || '.select_employee', 130);
1234: END IF; /* IF employee Count > 0 */
1235:
1236:
1237: IF p_output_file_type ='HTML' THEN

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

1241:
1242: COMMIT;
1243: END IF;
1244:
1245: hr_utility.set_location(gv_package_name || '.select_employee', 160);
1246:
1247: END select_employee;
1248:
1249:

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

1248:
1249:
1250:
1251: --begin
1252: --hr_utility.trace_on(null, 'ORACLE');
1253: end pay_livearchive_pkg;