eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_1099R_UDFS dependencies on HR_UTILITY

Line 32: 17-NOV-2003 sodhingr 115.15 removed the to_char from hr_utility.trace

28: format_pub1220_address
29: 11/06/03 jgoswami 115.13 Added Distribution code to get_1099R_values
30: added procedure format_1099r_wv_address
31: 13-NOV-2003 jgoswami 115.14 3241256 Added GET_1099R_TRANSMITTER_VALUE
32: 17-NOV-2003 sodhingr 115.15 removed the to_char from hr_utility.trace
33: 09-DEC-2003 jgoswami 115.16 3308537 modified format_1099r_wv_address package
34: 13-DEC-2003 jgoswami 115.17 3317434 modified GET_1099R_TRANSMITTER_VALU E to
35: return '0' for other states and federal
36: except 'CT'.

Line 95: hr_utility.trace('SIT : ' || l_sit);

91: BEGIN
92: l_SIT := to_char(p_SIT);
93: l_LIT := to_char(p_LIT);
94:
95: hr_utility.trace('SIT : ' || l_sit);
96: hr_utility.trace('LIT : ' || l_lit);
97:
98: --
99: ----------------------------------------------------------------

Line 96: hr_utility.trace('LIT : ' || l_lit);

92: l_SIT := to_char(p_SIT);
93: l_LIT := to_char(p_LIT);
94:
95: hr_utility.trace('SIT : ' || l_sit);
96: hr_utility.trace('LIT : ' || l_lit);
97:
98: --
99: ----------------------------------------------------------------
100: --increment table

Line 182: hr_utility.trace('Value of l34 is ' || l_f34);

178: lpad(substr(l_SIT,1,12),12,'0') ||
179: lpad(substr(l_LIT,1,12),12,'0') ;
180: END IF;
181: --
182: hr_utility.trace('Value of l34 is ' || l_f34);
183: return l_f34;
184: --
185: END state_1099R_specs;
186: --

Line 290: hr_utility.trace ('Removing ' || l_char ||

286:
287: --
288: IF (l_ascii >= ASCII('A') and l_ascii <= ASCII('Z')) or
289: (l_ascii = ASCII('-')) or (l_ascii = ASCII(' ')) THEN
290: hr_utility.trace ('Removing ' || l_char ||
291: 'from NE-SEIN.');
292: ELSE
293: l_result := l_result || l_char;
294: l_num := l_num + 1;

Line 427: -- hr_utility.trace_on(NULL,'oracle');

423: /* context assignment action id */
424:
425:
426: BEGIN
427: -- hr_utility.trace_on(NULL,'oracle');
428: /* call to funciton to get the value of 1099R Balanaces */
429: hr_utility.trace('Calling for 1099R balnaces for following value');
430:
431: hr_utility.trace('Assignment_action_id = '||to_char(p_assignment_action_id));

Line 429: hr_utility.trace('Calling for 1099R balnaces for following value');

425:
426: BEGIN
427: -- hr_utility.trace_on(NULL,'oracle');
428: /* call to funciton to get the value of 1099R Balanaces */
429: hr_utility.trace('Calling for 1099R balnaces for following value');
430:
431: hr_utility.trace('Assignment_action_id = '||to_char(p_assignment_action_id));
432: hr_utility.trace('Tax_unit_id = '||to_char(p_tax_unit_id));
433:

Line 431: hr_utility.trace('Assignment_action_id = '||to_char(p_assignment_action_id));

427: -- hr_utility.trace_on(NULL,'oracle');
428: /* call to funciton to get the value of 1099R Balanaces */
429: hr_utility.trace('Calling for 1099R balnaces for following value');
430:
431: hr_utility.trace('Assignment_action_id = '||to_char(p_assignment_action_id));
432: hr_utility.trace('Tax_unit_id = '||to_char(p_tax_unit_id));
433:
434: dbi_table(1).p_user_name := 'A_CAPITAL_GAIN_PER_GRE_YTD';
435: dbi_table(2).p_user_name := 'A_OTHER_EE_ANNUITY_CONTRACT_AMT_PER_GRE_YTD';

Line 432: hr_utility.trace('Tax_unit_id = '||to_char(p_tax_unit_id));

428: /* call to funciton to get the value of 1099R Balanaces */
429: hr_utility.trace('Calling for 1099R balnaces for following value');
430:
431: hr_utility.trace('Assignment_action_id = '||to_char(p_assignment_action_id));
432: hr_utility.trace('Tax_unit_id = '||to_char(p_tax_unit_id));
433:
434: dbi_table(1).p_user_name := 'A_CAPITAL_GAIN_PER_GRE_YTD';
435: dbi_table(2).p_user_name := 'A_OTHER_EE_ANNUITY_CONTRACT_AMT_PER_GRE_YTD';
436: dbi_table(3).p_user_name := 'A_TOTAL_EE_CONTRIBUTIONS_PER_GRE_YTD';

Line 446: hr_utility.trace('Getting the user_entity id');

442: dbi_table(8).p_user_name := 'A_EMPLOYEE_DISTRIBUTION_PERCENT';
443: dbi_table(9).p_user_name := 'A_TOTAL_DISTRIBUTION_PERCENT';
444: dbi_table(10).p_user_name := 'A_DISTRIBUTION_CODE_FOR_1099R';
445:
446: hr_utility.trace('Getting the user_entity id');
447:
448: FOR i in dbi_table.first .. dbi_table.last loop
449:
450: OPEN get_user_entity_id(dbi_table(i).p_user_name);

Line 462: hr_utility.trace('get_user_entity_id = '||to_char(l_entity_id));

458: dbi_table(i).p_archived_value:='0';
459:
460: ELSE
461:
462: hr_utility.trace('get_user_entity_id = '||to_char(l_entity_id));
463: hr_utility.trace('p_assignment_action_id = '||to_char(p_assignment_action_id));
464: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));
465:
466: IF substr(dbi_table(i).p_user_name,-11) = 'PER_GRE_YTD' THEN

Line 463: hr_utility.trace('p_assignment_action_id = '||to_char(p_assignment_action_id));

459:
460: ELSE
461:
462: hr_utility.trace('get_user_entity_id = '||to_char(l_entity_id));
463: hr_utility.trace('p_assignment_action_id = '||to_char(p_assignment_action_id));
464: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));
465:
466: IF substr(dbi_table(i).p_user_name,-11) = 'PER_GRE_YTD' THEN
467:

Line 464: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));

460: ELSE
461:
462: hr_utility.trace('get_user_entity_id = '||to_char(l_entity_id));
463: hr_utility.trace('p_assignment_action_id = '||to_char(p_assignment_action_id));
464: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));
465:
466: IF substr(dbi_table(i).p_user_name,-11) = 'PER_GRE_YTD' THEN
467:
468: OPEN get_archived_values(l_entity_id,

Line 475: hr_utility.trace('Archived_values not found for user name ' ||dbi_table(i).p_user_name);

471: FETCH get_archived_values INTO l_archived_value;
472:
473: IF get_archived_values%NOTFOUND THEN
474: dbi_table(i).p_archived_value:='0';
475: hr_utility.trace('Archived_values not found for user name ' ||dbi_table(i).p_user_name);
476: ELSIF get_archived_values%FOUND THEN
477: dbi_table(i).p_archived_value := l_archived_value;
478: hr_utility.trace('Archived_values found for user name ' ||dbi_table(i).p_user_name);
479: hr_utility.trace('Archived_value before neg check= '||l_archived_value);

Line 478: hr_utility.trace('Archived_values found for user name ' ||dbi_table(i).p_user_name);

474: dbi_table(i).p_archived_value:='0';
475: hr_utility.trace('Archived_values not found for user name ' ||dbi_table(i).p_user_name);
476: ELSIF get_archived_values%FOUND THEN
477: dbi_table(i).p_archived_value := l_archived_value;
478: hr_utility.trace('Archived_values found for user name ' ||dbi_table(i).p_user_name);
479: hr_utility.trace('Archived_value before neg check= '||l_archived_value);
480:
481: END IF;
482: CLOSE get_archived_values;

Line 479: hr_utility.trace('Archived_value before neg check= '||l_archived_value);

475: hr_utility.trace('Archived_values not found for user name ' ||dbi_table(i).p_user_name);
476: ELSIF get_archived_values%FOUND THEN
477: dbi_table(i).p_archived_value := l_archived_value;
478: hr_utility.trace('Archived_values found for user name ' ||dbi_table(i).p_user_name);
479: hr_utility.trace('Archived_value before neg check= '||l_archived_value);
480:
481: END IF;
482: CLOSE get_archived_values;
483: ELSE

Line 492: hr_utility.trace('Archived_values not found for user name ' ||dbi_table(i).p_user_name);

488: FETCH get_archived_values_assignment INTO l_archived_value;
489:
490: IF get_archived_values_assignment%NOTFOUND THEN
491: dbi_table(i).p_archived_value:='0';
492: hr_utility.trace('Archived_values not found for user name ' ||dbi_table(i).p_user_name);
493: ELSE
494: dbi_table(i).p_archived_value := l_archived_value;
495: hr_utility.trace('Archived_values found for user name ' ||dbi_table(i).p_user_name);
496: hr_utility.trace('Archived_value before neg check= '||l_archived_value);

Line 495: hr_utility.trace('Archived_values found for user name ' ||dbi_table(i).p_user_name);

491: dbi_table(i).p_archived_value:='0';
492: hr_utility.trace('Archived_values not found for user name ' ||dbi_table(i).p_user_name);
493: ELSE
494: dbi_table(i).p_archived_value := l_archived_value;
495: hr_utility.trace('Archived_values found for user name ' ||dbi_table(i).p_user_name);
496: hr_utility.trace('Archived_value before neg check= '||l_archived_value);
497: END IF; /* get_archive_value_assignment not_found */
498: CLOSE get_archived_values_assignment;
499: END IF; /* PER_GRE_YTD */

Line 496: hr_utility.trace('Archived_value before neg check= '||l_archived_value);

492: hr_utility.trace('Archived_values not found for user name ' ||dbi_table(i).p_user_name);
493: ELSE
494: dbi_table(i).p_archived_value := l_archived_value;
495: hr_utility.trace('Archived_values found for user name ' ||dbi_table(i).p_user_name);
496: hr_utility.trace('Archived_value before neg check= '||l_archived_value);
497: END IF; /* get_archive_value_assignment not_found */
498: CLOSE get_archived_values_assignment;
499: END IF; /* PER_GRE_YTD */
500: END IF; /* USER_ENTITY_FOUND */

Line 535: hr_utility.trace('sp_out_10 = '||sp_out_10);

531: END IF;
532: sp_out_9 := nvl(dbi_table(9).p_archived_value,'0');
533: sp_out_10 := nvl(dbi_table(10).p_archived_value,'7');
534: --sp_out_10:= ' ';
535: hr_utility.trace('sp_out_10 = '||sp_out_10);
536:
537: l_main_return := ' ';
538: return l_main_return;
539:

Line 674: hr_utility.trace('In function GET_1099R_ITEM_DATA');

670: l_effective_date date;
671: l_input_2 varchar2(200);
672:
673: BEGIN
674: hr_utility.trace('In function GET_1099R_ITEM_DATA');
675: c_item_name:='EE_ADDRESS';
676: l_input_2 := ltrim(rtrim(p_input_2));
677: if l_input_2 is not null then
678: l_effective_date := fnd_date.canonical_TO_DATE(l_input_2);

Line 682: hr_utility.trace('In function GET_MMREF_EMPLOYEE_ADDRESS');

678: l_effective_date := fnd_date.canonical_TO_DATE(l_input_2);
679: else
680: l_effective_date := p_effective_date;
681: end if;
682: hr_utility.trace('In function GET_MMREF_EMPLOYEE_ADDRESS');
683: lr_employee_addr :=
684: pay_us_get_item_data_pkg.GET_PERSON_NAME_ADDRESS(
685: p_report_type,
686: l_person_id,

Line 692: hr_utility.trace('Employee '||lr_employee_addr.full_name ||' Info found ');

688: l_effective_date,
689: p_date_earned,
690: p_validate,
691: p_record_name);
692: hr_utility.trace('Employee '||lr_employee_addr.full_name ||' Info found ');
693: hr_utility.trace('Formatting Employee Address for '||p_report_type
694: ||' Reporting ');
695:
696: /*

Line 693: hr_utility.trace('Formatting Employee Address for '||p_report_type

689: p_date_earned,
690: p_validate,
691: p_record_name);
692: hr_utility.trace('Employee '||lr_employee_addr.full_name ||' Info found ');
693: hr_utility.trace('Formatting Employee Address for '||p_report_type
694: ||' Reporting ');
695:
696: /*
697: l_country := lr_employee_addr.country;

Line 879: hr_utility.trace('Valid Address found ');

875: lpad(' ',40));
876: -- Format for Valid Address
877: IF p_valid_address = 'Y' THEN
878: --{
879: hr_utility.trace('Valid Address found ');
880: hr_utility.trace('Location address '||l_location_addr);
881: hr_utility.trace('Delivery address '||l_delivery_addr);
882: hr_utility.trace('town_or_city '||l_city);
883: hr_utility.trace('postal_code '||p_postal_code);

Line 880: hr_utility.trace('Location address '||l_location_addr);

876: -- Format for Valid Address
877: IF p_valid_address = 'Y' THEN
878: --{
879: hr_utility.trace('Valid Address found ');
880: hr_utility.trace('Location address '||l_location_addr);
881: hr_utility.trace('Delivery address '||l_delivery_addr);
882: hr_utility.trace('town_or_city '||l_city);
883: hr_utility.trace('postal_code '||p_postal_code);
884: hr_utility.trace('State '||l_state);

Line 881: hr_utility.trace('Delivery address '||l_delivery_addr);

877: IF p_valid_address = 'Y' THEN
878: --{
879: hr_utility.trace('Valid Address found ');
880: hr_utility.trace('Location address '||l_location_addr);
881: hr_utility.trace('Delivery address '||l_delivery_addr);
882: hr_utility.trace('town_or_city '||l_city);
883: hr_utility.trace('postal_code '||p_postal_code);
884: hr_utility.trace('State '||l_state);
885: hr_utility.trace('p_country '||p_country);

Line 882: hr_utility.trace('town_or_city '||l_city);

878: --{
879: hr_utility.trace('Valid Address found ');
880: hr_utility.trace('Location address '||l_location_addr);
881: hr_utility.trace('Delivery address '||l_delivery_addr);
882: hr_utility.trace('town_or_city '||l_city);
883: hr_utility.trace('postal_code '||p_postal_code);
884: hr_utility.trace('State '||l_state);
885: hr_utility.trace('p_country '||p_country);
886:

Line 883: hr_utility.trace('postal_code '||p_postal_code);

879: hr_utility.trace('Valid Address found ');
880: hr_utility.trace('Location address '||l_location_addr);
881: hr_utility.trace('Delivery address '||l_delivery_addr);
882: hr_utility.trace('town_or_city '||l_city);
883: hr_utility.trace('postal_code '||p_postal_code);
884: hr_utility.trace('State '||l_state);
885: hr_utility.trace('p_country '||p_country);
886:
887: IF c_item_name = 'EE_ADDRESS' THEN

Line 884: hr_utility.trace('State '||l_state);

880: hr_utility.trace('Location address '||l_location_addr);
881: hr_utility.trace('Delivery address '||l_delivery_addr);
882: hr_utility.trace('town_or_city '||l_city);
883: hr_utility.trace('postal_code '||p_postal_code);
884: hr_utility.trace('State '||l_state);
885: hr_utility.trace('p_country '||p_country);
886:
887: IF c_item_name = 'EE_ADDRESS' THEN
888: l_level := 'A';

Line 885: hr_utility.trace('p_country '||p_country);

881: hr_utility.trace('Delivery address '||l_delivery_addr);
882: hr_utility.trace('town_or_city '||l_city);
883: hr_utility.trace('postal_code '||p_postal_code);
884: hr_utility.trace('State '||l_state);
885: hr_utility.trace('p_country '||p_country);
886:
887: IF c_item_name = 'EE_ADDRESS' THEN
888: l_level := 'A';
889: l_mesg_name := 'PAY_INVALID_EE_FORMAT';

Line 970: hr_utility.trace('Zip or Postal Code is null');

966: --{
967: sp_out_5:= lpad(' ',5); --zip
968: sp_out_8:= lpad(' ',9); -- foreign zip
969: sp_out_6:= lpad(' ', 4); --extension
970: hr_utility.trace('Zip or Postal Code is null');
971: --}
972: END IF;
973: IF (p_item_name = 'ER_ADDRESS') THEN
974: sp_out_10:= p_name;

Line 975: hr_utility.trace('Organization Name = '||p_name);

971: --}
972: END IF;
973: IF (p_item_name = 'ER_ADDRESS') THEN
974: sp_out_10:= p_name;
975: hr_utility.trace('Organization Name = '||p_name);
976: ELSIF p_item_name = 'EE_ADDRESS' THEN
977: sp_out_10:= pay_us_reporting_utils_pkg.Character_check(p_emp_number);
978: END IF;
979: --}

Line 1006: hr_utility.trace('location address '||sp_out_1);

1002: l_err :=TRUE;
1003: END IF;
1004: --}
1005: END IF; --p_valid_address
1006: hr_utility.trace('location address '||sp_out_1);
1007: hr_utility.trace('delivery address '||sp_out_2);
1008: hr_utility.trace('City '||sp_out_3);
1009: hr_utility.trace('State '||sp_out_4);
1010: hr_utility.trace('Zip '||sp_out_5);

Line 1007: hr_utility.trace('delivery address '||sp_out_2);

1003: END IF;
1004: --}
1005: END IF; --p_valid_address
1006: hr_utility.trace('location address '||sp_out_1);
1007: hr_utility.trace('delivery address '||sp_out_2);
1008: hr_utility.trace('City '||sp_out_3);
1009: hr_utility.trace('State '||sp_out_4);
1010: hr_utility.trace('Zip '||sp_out_5);
1011: hr_utility.trace('Zip Code Extension '||sp_out_6);

Line 1008: hr_utility.trace('City '||sp_out_3);

1004: --}
1005: END IF; --p_valid_address
1006: hr_utility.trace('location address '||sp_out_1);
1007: hr_utility.trace('delivery address '||sp_out_2);
1008: hr_utility.trace('City '||sp_out_3);
1009: hr_utility.trace('State '||sp_out_4);
1010: hr_utility.trace('Zip '||sp_out_5);
1011: hr_utility.trace('Zip Code Extension '||sp_out_6);
1012: hr_utility.trace('Foreign State/Province '||sp_out_7);

Line 1009: hr_utility.trace('State '||sp_out_4);

1005: END IF; --p_valid_address
1006: hr_utility.trace('location address '||sp_out_1);
1007: hr_utility.trace('delivery address '||sp_out_2);
1008: hr_utility.trace('City '||sp_out_3);
1009: hr_utility.trace('State '||sp_out_4);
1010: hr_utility.trace('Zip '||sp_out_5);
1011: hr_utility.trace('Zip Code Extension '||sp_out_6);
1012: hr_utility.trace('Foreign State/Province '||sp_out_7);
1013: hr_utility.trace('Foreign Zip '||sp_out_8);

Line 1010: hr_utility.trace('Zip '||sp_out_5);

1006: hr_utility.trace('location address '||sp_out_1);
1007: hr_utility.trace('delivery address '||sp_out_2);
1008: hr_utility.trace('City '||sp_out_3);
1009: hr_utility.trace('State '||sp_out_4);
1010: hr_utility.trace('Zip '||sp_out_5);
1011: hr_utility.trace('Zip Code Extension '||sp_out_6);
1012: hr_utility.trace('Foreign State/Province '||sp_out_7);
1013: hr_utility.trace('Foreign Zip '||sp_out_8);
1014: hr_utility.trace('Country '||sp_out_9);

Line 1011: hr_utility.trace('Zip Code Extension '||sp_out_6);

1007: hr_utility.trace('delivery address '||sp_out_2);
1008: hr_utility.trace('City '||sp_out_3);
1009: hr_utility.trace('State '||sp_out_4);
1010: hr_utility.trace('Zip '||sp_out_5);
1011: hr_utility.trace('Zip Code Extension '||sp_out_6);
1012: hr_utility.trace('Foreign State/Province '||sp_out_7);
1013: hr_utility.trace('Foreign Zip '||sp_out_8);
1014: hr_utility.trace('Country '||sp_out_9);
1015: IF (p_item_name = 'ER_ADDRESS') THEN

Line 1012: hr_utility.trace('Foreign State/Province '||sp_out_7);

1008: hr_utility.trace('City '||sp_out_3);
1009: hr_utility.trace('State '||sp_out_4);
1010: hr_utility.trace('Zip '||sp_out_5);
1011: hr_utility.trace('Zip Code Extension '||sp_out_6);
1012: hr_utility.trace('Foreign State/Province '||sp_out_7);
1013: hr_utility.trace('Foreign Zip '||sp_out_8);
1014: hr_utility.trace('Country '||sp_out_9);
1015: IF (p_item_name = 'ER_ADDRESS') THEN
1016: hr_utility.trace('Organization Name '||sp_out_10);

Line 1013: hr_utility.trace('Foreign Zip '||sp_out_8);

1009: hr_utility.trace('State '||sp_out_4);
1010: hr_utility.trace('Zip '||sp_out_5);
1011: hr_utility.trace('Zip Code Extension '||sp_out_6);
1012: hr_utility.trace('Foreign State/Province '||sp_out_7);
1013: hr_utility.trace('Foreign Zip '||sp_out_8);
1014: hr_utility.trace('Country '||sp_out_9);
1015: IF (p_item_name = 'ER_ADDRESS') THEN
1016: hr_utility.trace('Organization Name '||sp_out_10);
1017: ELSE

Line 1014: hr_utility.trace('Country '||sp_out_9);

1010: hr_utility.trace('Zip '||sp_out_5);
1011: hr_utility.trace('Zip Code Extension '||sp_out_6);
1012: hr_utility.trace('Foreign State/Province '||sp_out_7);
1013: hr_utility.trace('Foreign Zip '||sp_out_8);
1014: hr_utility.trace('Country '||sp_out_9);
1015: IF (p_item_name = 'ER_ADDRESS') THEN
1016: hr_utility.trace('Organization Name '||sp_out_10);
1017: ELSE
1018: hr_utility.trace('Employee Number '||sp_out_10);

Line 1016: hr_utility.trace('Organization Name '||sp_out_10);

1012: hr_utility.trace('Foreign State/Province '||sp_out_7);
1013: hr_utility.trace('Foreign Zip '||sp_out_8);
1014: hr_utility.trace('Country '||sp_out_9);
1015: IF (p_item_name = 'ER_ADDRESS') THEN
1016: hr_utility.trace('Organization Name '||sp_out_10);
1017: ELSE
1018: hr_utility.trace('Employee Number '||sp_out_10);
1019: END IF;
1020: --

Line 1018: hr_utility.trace('Employee Number '||sp_out_10);

1014: hr_utility.trace('Country '||sp_out_9);
1015: IF (p_item_name = 'ER_ADDRESS') THEN
1016: hr_utility.trace('Organization Name '||sp_out_10);
1017: ELSE
1018: hr_utility.trace('Employee Number '||sp_out_10);
1019: END IF;
1020: --
1021: -- Check to include or exclude record on the basis of validity of address
1022: --

Line 1026: hr_utility.trace('p_validate is Y .error '||p_exclude_from_output);

1022: --
1023: IF p_validate = 'Y' THEN
1024: IF l_err THEN
1025: p_exclude_from_output := 'Y';
1026: hr_utility.trace('p_validate is Y .error '||p_exclude_from_output);
1027: END IF;
1028: END IF;
1029: IF p_exclude_from_output IS NULL THEN
1030: p_exclude_from_output := 'N';

Line 1106: hr_utility.trace('Valid Address found ');

1102: lpad(' ',25));
1103: -- Format for Valid Address
1104: IF p_valid_address = 'Y' THEN
1105: --{
1106: hr_utility.trace('Valid Address found ');
1107: hr_utility.trace('Location address '||l_location_addr);
1108: hr_utility.trace('Delivery address '||l_delivery_addr);
1109: hr_utility.trace('town_or_city '||l_city);
1110: hr_utility.trace('postal_code '||p_postal_code);

Line 1107: hr_utility.trace('Location address '||l_location_addr);

1103: -- Format for Valid Address
1104: IF p_valid_address = 'Y' THEN
1105: --{
1106: hr_utility.trace('Valid Address found ');
1107: hr_utility.trace('Location address '||l_location_addr);
1108: hr_utility.trace('Delivery address '||l_delivery_addr);
1109: hr_utility.trace('town_or_city '||l_city);
1110: hr_utility.trace('postal_code '||p_postal_code);
1111: hr_utility.trace('State '||l_state);

Line 1108: hr_utility.trace('Delivery address '||l_delivery_addr);

1104: IF p_valid_address = 'Y' THEN
1105: --{
1106: hr_utility.trace('Valid Address found ');
1107: hr_utility.trace('Location address '||l_location_addr);
1108: hr_utility.trace('Delivery address '||l_delivery_addr);
1109: hr_utility.trace('town_or_city '||l_city);
1110: hr_utility.trace('postal_code '||p_postal_code);
1111: hr_utility.trace('State '||l_state);
1112: hr_utility.trace('p_country '||p_country);

Line 1109: hr_utility.trace('town_or_city '||l_city);

1105: --{
1106: hr_utility.trace('Valid Address found ');
1107: hr_utility.trace('Location address '||l_location_addr);
1108: hr_utility.trace('Delivery address '||l_delivery_addr);
1109: hr_utility.trace('town_or_city '||l_city);
1110: hr_utility.trace('postal_code '||p_postal_code);
1111: hr_utility.trace('State '||l_state);
1112: hr_utility.trace('p_country '||p_country);
1113:

Line 1110: hr_utility.trace('postal_code '||p_postal_code);

1106: hr_utility.trace('Valid Address found ');
1107: hr_utility.trace('Location address '||l_location_addr);
1108: hr_utility.trace('Delivery address '||l_delivery_addr);
1109: hr_utility.trace('town_or_city '||l_city);
1110: hr_utility.trace('postal_code '||p_postal_code);
1111: hr_utility.trace('State '||l_state);
1112: hr_utility.trace('p_country '||p_country);
1113:
1114: IF c_item_name = 'EE_ADDRESS' THEN

Line 1111: hr_utility.trace('State '||l_state);

1107: hr_utility.trace('Location address '||l_location_addr);
1108: hr_utility.trace('Delivery address '||l_delivery_addr);
1109: hr_utility.trace('town_or_city '||l_city);
1110: hr_utility.trace('postal_code '||p_postal_code);
1111: hr_utility.trace('State '||l_state);
1112: hr_utility.trace('p_country '||p_country);
1113:
1114: IF c_item_name = 'EE_ADDRESS' THEN
1115: l_level := 'A';

Line 1112: hr_utility.trace('p_country '||p_country);

1108: hr_utility.trace('Delivery address '||l_delivery_addr);
1109: hr_utility.trace('town_or_city '||l_city);
1110: hr_utility.trace('postal_code '||p_postal_code);
1111: hr_utility.trace('State '||l_state);
1112: hr_utility.trace('p_country '||p_country);
1113:
1114: IF c_item_name = 'EE_ADDRESS' THEN
1115: l_level := 'A';
1116: l_mesg_name := 'PAY_INVALID_EE_FORMAT';

Line 1198: hr_utility.trace('Zip or Postal Code is null');

1194: --{
1195: sp_out_5:= lpad(' ',5); --zip
1196: sp_out_8:= lpad(' ',5); -- foreign zip
1197: sp_out_6:= lpad(' ', 5); --extension
1198: hr_utility.trace('Zip or Postal Code is null');
1199: --}
1200: END IF;
1201: IF (p_item_name = 'ER_ADDRESS') THEN
1202: sp_out_10:= p_name;

Line 1203: hr_utility.trace('Organization Name = '||p_name);

1199: --}
1200: END IF;
1201: IF (p_item_name = 'ER_ADDRESS') THEN
1202: sp_out_10:= p_name;
1203: hr_utility.trace('Organization Name = '||p_name);
1204: ELSIF p_item_name = 'EE_ADDRESS' THEN
1205: sp_out_10:= pay_us_reporting_utils_pkg.Character_check(p_emp_number);
1206: END IF;
1207: --}

Line 1234: hr_utility.trace('location address '||sp_out_1);

1230: l_err :=TRUE;
1231: END IF;
1232: --}
1233: END IF; --p_valid_address
1234: hr_utility.trace('location address '||sp_out_1);
1235: hr_utility.trace('delivery address '||sp_out_2);
1236: hr_utility.trace('City '||sp_out_3);
1237: hr_utility.trace('State '||sp_out_4);
1238: hr_utility.trace('Zip '||sp_out_5);

Line 1235: hr_utility.trace('delivery address '||sp_out_2);

1231: END IF;
1232: --}
1233: END IF; --p_valid_address
1234: hr_utility.trace('location address '||sp_out_1);
1235: hr_utility.trace('delivery address '||sp_out_2);
1236: hr_utility.trace('City '||sp_out_3);
1237: hr_utility.trace('State '||sp_out_4);
1238: hr_utility.trace('Zip '||sp_out_5);
1239: hr_utility.trace('Zip Code Extension '||sp_out_6);

Line 1236: hr_utility.trace('City '||sp_out_3);

1232: --}
1233: END IF; --p_valid_address
1234: hr_utility.trace('location address '||sp_out_1);
1235: hr_utility.trace('delivery address '||sp_out_2);
1236: hr_utility.trace('City '||sp_out_3);
1237: hr_utility.trace('State '||sp_out_4);
1238: hr_utility.trace('Zip '||sp_out_5);
1239: hr_utility.trace('Zip Code Extension '||sp_out_6);
1240: hr_utility.trace('Foreign State/Province '||sp_out_7);

Line 1237: hr_utility.trace('State '||sp_out_4);

1233: END IF; --p_valid_address
1234: hr_utility.trace('location address '||sp_out_1);
1235: hr_utility.trace('delivery address '||sp_out_2);
1236: hr_utility.trace('City '||sp_out_3);
1237: hr_utility.trace('State '||sp_out_4);
1238: hr_utility.trace('Zip '||sp_out_5);
1239: hr_utility.trace('Zip Code Extension '||sp_out_6);
1240: hr_utility.trace('Foreign State/Province '||sp_out_7);
1241: hr_utility.trace('Foreign Zip '||sp_out_8);

Line 1238: hr_utility.trace('Zip '||sp_out_5);

1234: hr_utility.trace('location address '||sp_out_1);
1235: hr_utility.trace('delivery address '||sp_out_2);
1236: hr_utility.trace('City '||sp_out_3);
1237: hr_utility.trace('State '||sp_out_4);
1238: hr_utility.trace('Zip '||sp_out_5);
1239: hr_utility.trace('Zip Code Extension '||sp_out_6);
1240: hr_utility.trace('Foreign State/Province '||sp_out_7);
1241: hr_utility.trace('Foreign Zip '||sp_out_8);
1242: hr_utility.trace('Country '||sp_out_9);

Line 1239: hr_utility.trace('Zip Code Extension '||sp_out_6);

1235: hr_utility.trace('delivery address '||sp_out_2);
1236: hr_utility.trace('City '||sp_out_3);
1237: hr_utility.trace('State '||sp_out_4);
1238: hr_utility.trace('Zip '||sp_out_5);
1239: hr_utility.trace('Zip Code Extension '||sp_out_6);
1240: hr_utility.trace('Foreign State/Province '||sp_out_7);
1241: hr_utility.trace('Foreign Zip '||sp_out_8);
1242: hr_utility.trace('Country '||sp_out_9);
1243:

Line 1240: hr_utility.trace('Foreign State/Province '||sp_out_7);

1236: hr_utility.trace('City '||sp_out_3);
1237: hr_utility.trace('State '||sp_out_4);
1238: hr_utility.trace('Zip '||sp_out_5);
1239: hr_utility.trace('Zip Code Extension '||sp_out_6);
1240: hr_utility.trace('Foreign State/Province '||sp_out_7);
1241: hr_utility.trace('Foreign Zip '||sp_out_8);
1242: hr_utility.trace('Country '||sp_out_9);
1243:
1244:

Line 1241: hr_utility.trace('Foreign Zip '||sp_out_8);

1237: hr_utility.trace('State '||sp_out_4);
1238: hr_utility.trace('Zip '||sp_out_5);
1239: hr_utility.trace('Zip Code Extension '||sp_out_6);
1240: hr_utility.trace('Foreign State/Province '||sp_out_7);
1241: hr_utility.trace('Foreign Zip '||sp_out_8);
1242: hr_utility.trace('Country '||sp_out_9);
1243:
1244:
1245: hr_utility.trace('location address '||replace(sp_out_1,' ','*'));

Line 1242: hr_utility.trace('Country '||sp_out_9);

1238: hr_utility.trace('Zip '||sp_out_5);
1239: hr_utility.trace('Zip Code Extension '||sp_out_6);
1240: hr_utility.trace('Foreign State/Province '||sp_out_7);
1241: hr_utility.trace('Foreign Zip '||sp_out_8);
1242: hr_utility.trace('Country '||sp_out_9);
1243:
1244:
1245: hr_utility.trace('location address '||replace(sp_out_1,' ','*'));
1246: hr_utility.trace('delivery address '||replace(sp_out_2,' ','*'));

Line 1245: hr_utility.trace('location address '||replace(sp_out_1,' ','*'));

1241: hr_utility.trace('Foreign Zip '||sp_out_8);
1242: hr_utility.trace('Country '||sp_out_9);
1243:
1244:
1245: hr_utility.trace('location address '||replace(sp_out_1,' ','*'));
1246: hr_utility.trace('delivery address '||replace(sp_out_2,' ','*'));
1247: hr_utility.trace('City '||replace(sp_out_3,' ','*'));
1248: hr_utility.trace('State '||replace(sp_out_4,' ','*'));
1249: hr_utility.trace('Zip '||replace(sp_out_5,' ','*'));

Line 1246: hr_utility.trace('delivery address '||replace(sp_out_2,' ','*'));

1242: hr_utility.trace('Country '||sp_out_9);
1243:
1244:
1245: hr_utility.trace('location address '||replace(sp_out_1,' ','*'));
1246: hr_utility.trace('delivery address '||replace(sp_out_2,' ','*'));
1247: hr_utility.trace('City '||replace(sp_out_3,' ','*'));
1248: hr_utility.trace('State '||replace(sp_out_4,' ','*'));
1249: hr_utility.trace('Zip '||replace(sp_out_5,' ','*'));
1250: hr_utility.trace('Zip Code Extension '||replace(sp_out_6,' ','*'));

Line 1247: hr_utility.trace('City '||replace(sp_out_3,' ','*'));

1243:
1244:
1245: hr_utility.trace('location address '||replace(sp_out_1,' ','*'));
1246: hr_utility.trace('delivery address '||replace(sp_out_2,' ','*'));
1247: hr_utility.trace('City '||replace(sp_out_3,' ','*'));
1248: hr_utility.trace('State '||replace(sp_out_4,' ','*'));
1249: hr_utility.trace('Zip '||replace(sp_out_5,' ','*'));
1250: hr_utility.trace('Zip Code Extension '||replace(sp_out_6,' ','*'));
1251: hr_utility.trace('Foreign State/Province '||replace(sp_out_7,' ','*'));

Line 1248: hr_utility.trace('State '||replace(sp_out_4,' ','*'));

1244:
1245: hr_utility.trace('location address '||replace(sp_out_1,' ','*'));
1246: hr_utility.trace('delivery address '||replace(sp_out_2,' ','*'));
1247: hr_utility.trace('City '||replace(sp_out_3,' ','*'));
1248: hr_utility.trace('State '||replace(sp_out_4,' ','*'));
1249: hr_utility.trace('Zip '||replace(sp_out_5,' ','*'));
1250: hr_utility.trace('Zip Code Extension '||replace(sp_out_6,' ','*'));
1251: hr_utility.trace('Foreign State/Province '||replace(sp_out_7,' ','*'));
1252: hr_utility.trace('Foreign Zip '||replace(sp_out_8,' ','*'));

Line 1249: hr_utility.trace('Zip '||replace(sp_out_5,' ','*'));

1245: hr_utility.trace('location address '||replace(sp_out_1,' ','*'));
1246: hr_utility.trace('delivery address '||replace(sp_out_2,' ','*'));
1247: hr_utility.trace('City '||replace(sp_out_3,' ','*'));
1248: hr_utility.trace('State '||replace(sp_out_4,' ','*'));
1249: hr_utility.trace('Zip '||replace(sp_out_5,' ','*'));
1250: hr_utility.trace('Zip Code Extension '||replace(sp_out_6,' ','*'));
1251: hr_utility.trace('Foreign State/Province '||replace(sp_out_7,' ','*'));
1252: hr_utility.trace('Foreign Zip '||replace(sp_out_8,' ','*'));
1253: hr_utility.trace('Country '||replace(sp_out_9,' ','*'));

Line 1250: hr_utility.trace('Zip Code Extension '||replace(sp_out_6,' ','*'));

1246: hr_utility.trace('delivery address '||replace(sp_out_2,' ','*'));
1247: hr_utility.trace('City '||replace(sp_out_3,' ','*'));
1248: hr_utility.trace('State '||replace(sp_out_4,' ','*'));
1249: hr_utility.trace('Zip '||replace(sp_out_5,' ','*'));
1250: hr_utility.trace('Zip Code Extension '||replace(sp_out_6,' ','*'));
1251: hr_utility.trace('Foreign State/Province '||replace(sp_out_7,' ','*'));
1252: hr_utility.trace('Foreign Zip '||replace(sp_out_8,' ','*'));
1253: hr_utility.trace('Country '||replace(sp_out_9,' ','*'));
1254:

Line 1251: hr_utility.trace('Foreign State/Province '||replace(sp_out_7,' ','*'));

1247: hr_utility.trace('City '||replace(sp_out_3,' ','*'));
1248: hr_utility.trace('State '||replace(sp_out_4,' ','*'));
1249: hr_utility.trace('Zip '||replace(sp_out_5,' ','*'));
1250: hr_utility.trace('Zip Code Extension '||replace(sp_out_6,' ','*'));
1251: hr_utility.trace('Foreign State/Province '||replace(sp_out_7,' ','*'));
1252: hr_utility.trace('Foreign Zip '||replace(sp_out_8,' ','*'));
1253: hr_utility.trace('Country '||replace(sp_out_9,' ','*'));
1254:
1255:

Line 1252: hr_utility.trace('Foreign Zip '||replace(sp_out_8,' ','*'));

1248: hr_utility.trace('State '||replace(sp_out_4,' ','*'));
1249: hr_utility.trace('Zip '||replace(sp_out_5,' ','*'));
1250: hr_utility.trace('Zip Code Extension '||replace(sp_out_6,' ','*'));
1251: hr_utility.trace('Foreign State/Province '||replace(sp_out_7,' ','*'));
1252: hr_utility.trace('Foreign Zip '||replace(sp_out_8,' ','*'));
1253: hr_utility.trace('Country '||replace(sp_out_9,' ','*'));
1254:
1255:
1256: IF (p_item_name = 'ER_ADDRESS') THEN

Line 1253: hr_utility.trace('Country '||replace(sp_out_9,' ','*'));

1249: hr_utility.trace('Zip '||replace(sp_out_5,' ','*'));
1250: hr_utility.trace('Zip Code Extension '||replace(sp_out_6,' ','*'));
1251: hr_utility.trace('Foreign State/Province '||replace(sp_out_7,' ','*'));
1252: hr_utility.trace('Foreign Zip '||replace(sp_out_8,' ','*'));
1253: hr_utility.trace('Country '||replace(sp_out_9,' ','*'));
1254:
1255:
1256: IF (p_item_name = 'ER_ADDRESS') THEN
1257: hr_utility.trace('Organization Name '||sp_out_10);

Line 1257: hr_utility.trace('Organization Name '||sp_out_10);

1253: hr_utility.trace('Country '||replace(sp_out_9,' ','*'));
1254:
1255:
1256: IF (p_item_name = 'ER_ADDRESS') THEN
1257: hr_utility.trace('Organization Name '||sp_out_10);
1258: ELSE
1259: hr_utility.trace('Employee Number '||sp_out_10);
1260: END IF;
1261: --

Line 1259: hr_utility.trace('Employee Number '||sp_out_10);

1255:
1256: IF (p_item_name = 'ER_ADDRESS') THEN
1257: hr_utility.trace('Organization Name '||sp_out_10);
1258: ELSE
1259: hr_utility.trace('Employee Number '||sp_out_10);
1260: END IF;
1261: --
1262: -- Check to include or exclude record on the basis of validity of address
1263: --

Line 1267: hr_utility.trace('p_validate is Y .error '||p_exclude_from_output);

1263: --
1264: IF p_validate = 'Y' THEN
1265: IF l_err THEN
1266: p_exclude_from_output := 'Y';
1267: hr_utility.trace('p_validate is Y .error '||p_exclude_from_output);
1268: END IF;
1269: END IF;
1270: IF p_exclude_from_output IS NULL THEN
1271: p_exclude_from_output := 'N';

Line 1306: -- hr_utility.trace_on(NULL,'oracle');

1302: FROM pay_assignment_actions paa
1303: WHERE paa.payroll_action_id = to_number(pact_id);
1304:
1305: BEGIN
1306: -- hr_utility.trace_on(NULL,'oracle');
1307: /* call to funciton to get the value of 1099R Transmitter */
1308: hr_utility.trace('Payroll_action_id = '||p_payroll_action_id);
1309: hr_utility.trace('p_state = '||p_state);
1310:

Line 1308: hr_utility.trace('Payroll_action_id = '||p_payroll_action_id);

1304:
1305: BEGIN
1306: -- hr_utility.trace_on(NULL,'oracle');
1307: /* call to funciton to get the value of 1099R Transmitter */
1308: hr_utility.trace('Payroll_action_id = '||p_payroll_action_id);
1309: hr_utility.trace('p_state = '||p_state);
1310:
1311: OPEN get_payee_count(p_payroll_action_id);
1312: FETCH get_payee_count INTO l_payee_count;

Line 1309: hr_utility.trace('p_state = '||p_state);

1305: BEGIN
1306: -- hr_utility.trace_on(NULL,'oracle');
1307: /* call to funciton to get the value of 1099R Transmitter */
1308: hr_utility.trace('Payroll_action_id = '||p_payroll_action_id);
1309: hr_utility.trace('p_state = '||p_state);
1310:
1311: OPEN get_payee_count(p_payroll_action_id);
1312: FETCH get_payee_count INTO l_payee_count;
1313:

Line 1320: hr_utility.trace('Payee Count = '||to_char(l_payee_count));

1316: l_message:='Error: No Payee found for Transmitter';
1317:
1318: l_payee_count := 0;
1319:
1320: hr_utility.trace('Payee Count = '||to_char(l_payee_count));
1321: ELSE
1322:
1323: hr_utility.trace('Payroll_action_id = '||p_payroll_action_id);
1324: hr_utility.trace('Payee Count = '||to_char(l_payee_count));

Line 1323: hr_utility.trace('Payroll_action_id = '||p_payroll_action_id);

1319:
1320: hr_utility.trace('Payee Count = '||to_char(l_payee_count));
1321: ELSE
1322:
1323: hr_utility.trace('Payroll_action_id = '||p_payroll_action_id);
1324: hr_utility.trace('Payee Count = '||to_char(l_payee_count));
1325:
1326: END IF; /* get_payee_count */
1327:

Line 1324: hr_utility.trace('Payee Count = '||to_char(l_payee_count));

1320: hr_utility.trace('Payee Count = '||to_char(l_payee_count));
1321: ELSE
1322:
1323: hr_utility.trace('Payroll_action_id = '||p_payroll_action_id);
1324: hr_utility.trace('Payee Count = '||to_char(l_payee_count));
1325:
1326: END IF; /* get_payee_count */
1327:
1328: CLOSE get_payee_count;

Line 1349: hr_utility.trace('sp_out_1 = '||sp_out_1);

1345: sp_out_8 :=' ';
1346: sp_out_9 :=' ';
1347: sp_out_10 :=' ';
1348:
1349: hr_utility.trace('sp_out_1 = '||sp_out_1);
1350:
1351: l_main_return := ' ';
1352: return l_main_return;
1353: