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 99: hr_utility.trace('SIT : ' || l_sit);

95: BEGIN
96: l_SIT := to_char(p_SIT);
97: l_LIT := to_char(p_LIT);
98:
99: hr_utility.trace('SIT : ' || l_sit);
100: hr_utility.trace('LIT : ' || l_lit);
101:
102: --
103: ----------------------------------------------------------------

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

96: l_SIT := to_char(p_SIT);
97: l_LIT := to_char(p_LIT);
98:
99: hr_utility.trace('SIT : ' || l_sit);
100: hr_utility.trace('LIT : ' || l_lit);
101:
102: --
103: ----------------------------------------------------------------
104: --increment table

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

535: END IF;
536: sp_out_9 := nvl(dbi_table(9).p_archived_value,'0');
537: sp_out_10 := nvl(dbi_table(10).p_archived_value,'7');
538: --sp_out_10:= ' ';
539: hr_utility.trace('sp_out_10 = '||sp_out_10);
540:
541: l_main_return := ' ';
542: return l_main_return;
543:

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

682: where paa.assignment_id = c_assignment_id
683: and c_effective_date between paa.effective_start_date and paa.effective_end_date ;
684:
685: BEGIN
686: hr_utility.trace('In function GET_1099R_ITEM_DATA');
687: c_item_name:='EE_ADDRESS';
688: l_input_2 := ltrim(rtrim(p_input_2));
689: if l_input_2 is not null then
690: l_effective_date := fnd_date.canonical_TO_DATE(l_input_2);

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

696: open get_person_id( p_assignment_id ,p_effective_date );
697: fetch get_person_id into l_person_id ;
698: close get_person_id ;
699:
700: hr_utility.trace('In function GET_MMREF_EMPLOYEE_ADDRESS');
701: lr_employee_addr :=
702: pay_us_get_item_data_pkg.GET_PERSON_NAME_ADDRESS(
703: p_report_type,
704: l_person_id,

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

706: l_effective_date,
707: p_date_earned,
708: p_validate,
709: p_record_name);
710: hr_utility.trace('Employee '||lr_employee_addr.full_name ||' Info found ');
711: hr_utility.trace('Formatting Employee Address for '||p_report_type
712: ||' Reporting ');
713:
714: /*

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

707: p_date_earned,
708: p_validate,
709: p_record_name);
710: hr_utility.trace('Employee '||lr_employee_addr.full_name ||' Info found ');
711: hr_utility.trace('Formatting Employee Address for '||p_report_type
712: ||' Reporting ');
713:
714: /*
715: l_country := lr_employee_addr.country;

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

899: lpad(' ',40));
900: -- Format for Valid Address
901: IF p_valid_address = 'Y' THEN
902: --{
903: hr_utility.trace('Valid Address found ');
904: hr_utility.trace('Location address '||l_location_addr);
905: hr_utility.trace('Delivery address '||l_delivery_addr);
906: hr_utility.trace('town_or_city '||l_city);
907: hr_utility.trace('postal_code '||p_postal_code);

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

900: -- Format for Valid Address
901: IF p_valid_address = 'Y' THEN
902: --{
903: hr_utility.trace('Valid Address found ');
904: hr_utility.trace('Location address '||l_location_addr);
905: hr_utility.trace('Delivery address '||l_delivery_addr);
906: hr_utility.trace('town_or_city '||l_city);
907: hr_utility.trace('postal_code '||p_postal_code);
908: hr_utility.trace('State '||l_state);

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

901: IF p_valid_address = 'Y' THEN
902: --{
903: hr_utility.trace('Valid Address found ');
904: hr_utility.trace('Location address '||l_location_addr);
905: hr_utility.trace('Delivery address '||l_delivery_addr);
906: hr_utility.trace('town_or_city '||l_city);
907: hr_utility.trace('postal_code '||p_postal_code);
908: hr_utility.trace('State '||l_state);
909: hr_utility.trace('p_country '||p_country);

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

902: --{
903: hr_utility.trace('Valid Address found ');
904: hr_utility.trace('Location address '||l_location_addr);
905: hr_utility.trace('Delivery address '||l_delivery_addr);
906: hr_utility.trace('town_or_city '||l_city);
907: hr_utility.trace('postal_code '||p_postal_code);
908: hr_utility.trace('State '||l_state);
909: hr_utility.trace('p_country '||p_country);
910:

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

903: hr_utility.trace('Valid Address found ');
904: hr_utility.trace('Location address '||l_location_addr);
905: hr_utility.trace('Delivery address '||l_delivery_addr);
906: hr_utility.trace('town_or_city '||l_city);
907: hr_utility.trace('postal_code '||p_postal_code);
908: hr_utility.trace('State '||l_state);
909: hr_utility.trace('p_country '||p_country);
910:
911: IF c_item_name = 'EE_ADDRESS' THEN

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

904: hr_utility.trace('Location address '||l_location_addr);
905: hr_utility.trace('Delivery address '||l_delivery_addr);
906: hr_utility.trace('town_or_city '||l_city);
907: hr_utility.trace('postal_code '||p_postal_code);
908: hr_utility.trace('State '||l_state);
909: hr_utility.trace('p_country '||p_country);
910:
911: IF c_item_name = 'EE_ADDRESS' THEN
912: l_level := 'A';

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

905: hr_utility.trace('Delivery address '||l_delivery_addr);
906: hr_utility.trace('town_or_city '||l_city);
907: hr_utility.trace('postal_code '||p_postal_code);
908: hr_utility.trace('State '||l_state);
909: hr_utility.trace('p_country '||p_country);
910:
911: IF c_item_name = 'EE_ADDRESS' THEN
912: l_level := 'A';
913: l_mesg_name := 'PAY_INVALID_EE_FORMAT';

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

990: --{
991: sp_out_5:= lpad(' ',5); --zip
992: sp_out_8:= lpad(' ',9); -- foreign zip
993: sp_out_6:= lpad(' ', 4); --extension
994: hr_utility.trace('Zip or Postal Code is null');
995: --}
996: END IF;
997: IF (p_item_name = 'ER_ADDRESS') THEN
998: sp_out_10:= p_name;

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

995: --}
996: END IF;
997: IF (p_item_name = 'ER_ADDRESS') THEN
998: sp_out_10:= p_name;
999: hr_utility.trace('Organization Name = '||p_name);
1000: ELSIF p_item_name = 'EE_ADDRESS' THEN
1001: sp_out_10:= pay_us_reporting_utils_pkg.Character_check(p_emp_number);
1002: END IF;
1003: --}

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

1026: l_err :=TRUE;
1027: END IF;
1028: --}
1029: END IF; --p_valid_address
1030: hr_utility.trace('location address '||sp_out_1);
1031: hr_utility.trace('delivery address '||sp_out_2);
1032: hr_utility.trace('City '||sp_out_3);
1033: hr_utility.trace('State '||sp_out_4);
1034: hr_utility.trace('Zip '||sp_out_5);

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

1027: END IF;
1028: --}
1029: END IF; --p_valid_address
1030: hr_utility.trace('location address '||sp_out_1);
1031: hr_utility.trace('delivery address '||sp_out_2);
1032: hr_utility.trace('City '||sp_out_3);
1033: hr_utility.trace('State '||sp_out_4);
1034: hr_utility.trace('Zip '||sp_out_5);
1035: hr_utility.trace('Zip Code Extension '||sp_out_6);

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

1028: --}
1029: END IF; --p_valid_address
1030: hr_utility.trace('location address '||sp_out_1);
1031: hr_utility.trace('delivery address '||sp_out_2);
1032: hr_utility.trace('City '||sp_out_3);
1033: hr_utility.trace('State '||sp_out_4);
1034: hr_utility.trace('Zip '||sp_out_5);
1035: hr_utility.trace('Zip Code Extension '||sp_out_6);
1036: hr_utility.trace('Foreign State/Province '||sp_out_7);

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

1029: END IF; --p_valid_address
1030: hr_utility.trace('location address '||sp_out_1);
1031: hr_utility.trace('delivery address '||sp_out_2);
1032: hr_utility.trace('City '||sp_out_3);
1033: hr_utility.trace('State '||sp_out_4);
1034: hr_utility.trace('Zip '||sp_out_5);
1035: hr_utility.trace('Zip Code Extension '||sp_out_6);
1036: hr_utility.trace('Foreign State/Province '||sp_out_7);
1037: hr_utility.trace('Foreign Zip '||sp_out_8);

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

1030: hr_utility.trace('location address '||sp_out_1);
1031: hr_utility.trace('delivery address '||sp_out_2);
1032: hr_utility.trace('City '||sp_out_3);
1033: hr_utility.trace('State '||sp_out_4);
1034: hr_utility.trace('Zip '||sp_out_5);
1035: hr_utility.trace('Zip Code Extension '||sp_out_6);
1036: hr_utility.trace('Foreign State/Province '||sp_out_7);
1037: hr_utility.trace('Foreign Zip '||sp_out_8);
1038: hr_utility.trace('Country '||sp_out_9);

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

1031: hr_utility.trace('delivery address '||sp_out_2);
1032: hr_utility.trace('City '||sp_out_3);
1033: hr_utility.trace('State '||sp_out_4);
1034: hr_utility.trace('Zip '||sp_out_5);
1035: hr_utility.trace('Zip Code Extension '||sp_out_6);
1036: hr_utility.trace('Foreign State/Province '||sp_out_7);
1037: hr_utility.trace('Foreign Zip '||sp_out_8);
1038: hr_utility.trace('Country '||sp_out_9);
1039: IF (p_item_name = 'ER_ADDRESS') THEN

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

1032: hr_utility.trace('City '||sp_out_3);
1033: hr_utility.trace('State '||sp_out_4);
1034: hr_utility.trace('Zip '||sp_out_5);
1035: hr_utility.trace('Zip Code Extension '||sp_out_6);
1036: hr_utility.trace('Foreign State/Province '||sp_out_7);
1037: hr_utility.trace('Foreign Zip '||sp_out_8);
1038: hr_utility.trace('Country '||sp_out_9);
1039: IF (p_item_name = 'ER_ADDRESS') THEN
1040: hr_utility.trace('Organization Name '||sp_out_10);

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

1033: hr_utility.trace('State '||sp_out_4);
1034: hr_utility.trace('Zip '||sp_out_5);
1035: hr_utility.trace('Zip Code Extension '||sp_out_6);
1036: hr_utility.trace('Foreign State/Province '||sp_out_7);
1037: hr_utility.trace('Foreign Zip '||sp_out_8);
1038: hr_utility.trace('Country '||sp_out_9);
1039: IF (p_item_name = 'ER_ADDRESS') THEN
1040: hr_utility.trace('Organization Name '||sp_out_10);
1041: ELSE

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

1034: hr_utility.trace('Zip '||sp_out_5);
1035: hr_utility.trace('Zip Code Extension '||sp_out_6);
1036: hr_utility.trace('Foreign State/Province '||sp_out_7);
1037: hr_utility.trace('Foreign Zip '||sp_out_8);
1038: hr_utility.trace('Country '||sp_out_9);
1039: IF (p_item_name = 'ER_ADDRESS') THEN
1040: hr_utility.trace('Organization Name '||sp_out_10);
1041: ELSE
1042: hr_utility.trace('Employee Number '||sp_out_10);

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

1036: hr_utility.trace('Foreign State/Province '||sp_out_7);
1037: hr_utility.trace('Foreign Zip '||sp_out_8);
1038: hr_utility.trace('Country '||sp_out_9);
1039: IF (p_item_name = 'ER_ADDRESS') THEN
1040: hr_utility.trace('Organization Name '||sp_out_10);
1041: ELSE
1042: hr_utility.trace('Employee Number '||sp_out_10);
1043: END IF;
1044: --

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

1038: hr_utility.trace('Country '||sp_out_9);
1039: IF (p_item_name = 'ER_ADDRESS') THEN
1040: hr_utility.trace('Organization Name '||sp_out_10);
1041: ELSE
1042: hr_utility.trace('Employee Number '||sp_out_10);
1043: END IF;
1044: --
1045: -- Check to include or exclude record on the basis of validity of address
1046: --

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

1046: --
1047: IF p_validate = 'Y' THEN
1048: IF l_err THEN
1049: p_exclude_from_output := 'Y';
1050: hr_utility.trace('p_validate is Y .error '||p_exclude_from_output);
1051: END IF;
1052: END IF;
1053: IF p_exclude_from_output IS NULL THEN
1054: p_exclude_from_output := 'N';

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

1126: lpad(' ',25));
1127: -- Format for Valid Address
1128: IF p_valid_address = 'Y' THEN
1129: --{
1130: hr_utility.trace('Valid Address found ');
1131: hr_utility.trace('Location address '||l_location_addr);
1132: hr_utility.trace('Delivery address '||l_delivery_addr);
1133: hr_utility.trace('town_or_city '||l_city);
1134: hr_utility.trace('postal_code '||p_postal_code);

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

1127: -- Format for Valid Address
1128: IF p_valid_address = 'Y' THEN
1129: --{
1130: hr_utility.trace('Valid Address found ');
1131: hr_utility.trace('Location address '||l_location_addr);
1132: hr_utility.trace('Delivery address '||l_delivery_addr);
1133: hr_utility.trace('town_or_city '||l_city);
1134: hr_utility.trace('postal_code '||p_postal_code);
1135: hr_utility.trace('State '||l_state);

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

1128: IF p_valid_address = 'Y' THEN
1129: --{
1130: hr_utility.trace('Valid Address found ');
1131: hr_utility.trace('Location address '||l_location_addr);
1132: hr_utility.trace('Delivery address '||l_delivery_addr);
1133: hr_utility.trace('town_or_city '||l_city);
1134: hr_utility.trace('postal_code '||p_postal_code);
1135: hr_utility.trace('State '||l_state);
1136: hr_utility.trace('p_country '||p_country);

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

1129: --{
1130: hr_utility.trace('Valid Address found ');
1131: hr_utility.trace('Location address '||l_location_addr);
1132: hr_utility.trace('Delivery address '||l_delivery_addr);
1133: hr_utility.trace('town_or_city '||l_city);
1134: hr_utility.trace('postal_code '||p_postal_code);
1135: hr_utility.trace('State '||l_state);
1136: hr_utility.trace('p_country '||p_country);
1137:

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

1130: hr_utility.trace('Valid Address found ');
1131: hr_utility.trace('Location address '||l_location_addr);
1132: hr_utility.trace('Delivery address '||l_delivery_addr);
1133: hr_utility.trace('town_or_city '||l_city);
1134: hr_utility.trace('postal_code '||p_postal_code);
1135: hr_utility.trace('State '||l_state);
1136: hr_utility.trace('p_country '||p_country);
1137:
1138: IF c_item_name = 'EE_ADDRESS' THEN

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

1131: hr_utility.trace('Location address '||l_location_addr);
1132: hr_utility.trace('Delivery address '||l_delivery_addr);
1133: hr_utility.trace('town_or_city '||l_city);
1134: hr_utility.trace('postal_code '||p_postal_code);
1135: hr_utility.trace('State '||l_state);
1136: hr_utility.trace('p_country '||p_country);
1137:
1138: IF c_item_name = 'EE_ADDRESS' THEN
1139: l_level := 'A';

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

1132: hr_utility.trace('Delivery address '||l_delivery_addr);
1133: hr_utility.trace('town_or_city '||l_city);
1134: hr_utility.trace('postal_code '||p_postal_code);
1135: hr_utility.trace('State '||l_state);
1136: hr_utility.trace('p_country '||p_country);
1137:
1138: IF c_item_name = 'EE_ADDRESS' THEN
1139: l_level := 'A';
1140: l_mesg_name := 'PAY_INVALID_EE_FORMAT';

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

1218: --{
1219: sp_out_5:= lpad(' ',5); --zip
1220: sp_out_8:= lpad(' ',5); -- foreign zip
1221: sp_out_6:= lpad(' ', 5); --extension
1222: hr_utility.trace('Zip or Postal Code is null');
1223: --}
1224: END IF;
1225: IF (p_item_name = 'ER_ADDRESS') THEN
1226: sp_out_10:= p_name;

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

1223: --}
1224: END IF;
1225: IF (p_item_name = 'ER_ADDRESS') THEN
1226: sp_out_10:= p_name;
1227: hr_utility.trace('Organization Name = '||p_name);
1228: ELSIF p_item_name = 'EE_ADDRESS' THEN
1229: sp_out_10:= pay_us_reporting_utils_pkg.Character_check(p_emp_number);
1230: END IF;
1231: --}

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

1254: l_err :=TRUE;
1255: END IF;
1256: --}
1257: END IF; --p_valid_address
1258: hr_utility.trace('location address '||sp_out_1);
1259: hr_utility.trace('delivery address '||sp_out_2);
1260: hr_utility.trace('City '||sp_out_3);
1261: hr_utility.trace('State '||sp_out_4);
1262: hr_utility.trace('Zip '||sp_out_5);

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

1255: END IF;
1256: --}
1257: END IF; --p_valid_address
1258: hr_utility.trace('location address '||sp_out_1);
1259: hr_utility.trace('delivery address '||sp_out_2);
1260: hr_utility.trace('City '||sp_out_3);
1261: hr_utility.trace('State '||sp_out_4);
1262: hr_utility.trace('Zip '||sp_out_5);
1263: hr_utility.trace('Zip Code Extension '||sp_out_6);

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

1256: --}
1257: END IF; --p_valid_address
1258: hr_utility.trace('location address '||sp_out_1);
1259: hr_utility.trace('delivery address '||sp_out_2);
1260: hr_utility.trace('City '||sp_out_3);
1261: hr_utility.trace('State '||sp_out_4);
1262: hr_utility.trace('Zip '||sp_out_5);
1263: hr_utility.trace('Zip Code Extension '||sp_out_6);
1264: hr_utility.trace('Foreign State/Province '||sp_out_7);

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

1257: END IF; --p_valid_address
1258: hr_utility.trace('location address '||sp_out_1);
1259: hr_utility.trace('delivery address '||sp_out_2);
1260: hr_utility.trace('City '||sp_out_3);
1261: hr_utility.trace('State '||sp_out_4);
1262: hr_utility.trace('Zip '||sp_out_5);
1263: hr_utility.trace('Zip Code Extension '||sp_out_6);
1264: hr_utility.trace('Foreign State/Province '||sp_out_7);
1265: hr_utility.trace('Foreign Zip '||sp_out_8);

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

1258: hr_utility.trace('location address '||sp_out_1);
1259: hr_utility.trace('delivery address '||sp_out_2);
1260: hr_utility.trace('City '||sp_out_3);
1261: hr_utility.trace('State '||sp_out_4);
1262: hr_utility.trace('Zip '||sp_out_5);
1263: hr_utility.trace('Zip Code Extension '||sp_out_6);
1264: hr_utility.trace('Foreign State/Province '||sp_out_7);
1265: hr_utility.trace('Foreign Zip '||sp_out_8);
1266: hr_utility.trace('Country '||sp_out_9);

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

1259: hr_utility.trace('delivery address '||sp_out_2);
1260: hr_utility.trace('City '||sp_out_3);
1261: hr_utility.trace('State '||sp_out_4);
1262: hr_utility.trace('Zip '||sp_out_5);
1263: hr_utility.trace('Zip Code Extension '||sp_out_6);
1264: hr_utility.trace('Foreign State/Province '||sp_out_7);
1265: hr_utility.trace('Foreign Zip '||sp_out_8);
1266: hr_utility.trace('Country '||sp_out_9);
1267:

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

1260: hr_utility.trace('City '||sp_out_3);
1261: hr_utility.trace('State '||sp_out_4);
1262: hr_utility.trace('Zip '||sp_out_5);
1263: hr_utility.trace('Zip Code Extension '||sp_out_6);
1264: hr_utility.trace('Foreign State/Province '||sp_out_7);
1265: hr_utility.trace('Foreign Zip '||sp_out_8);
1266: hr_utility.trace('Country '||sp_out_9);
1267:
1268:

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

1261: hr_utility.trace('State '||sp_out_4);
1262: hr_utility.trace('Zip '||sp_out_5);
1263: hr_utility.trace('Zip Code Extension '||sp_out_6);
1264: hr_utility.trace('Foreign State/Province '||sp_out_7);
1265: hr_utility.trace('Foreign Zip '||sp_out_8);
1266: hr_utility.trace('Country '||sp_out_9);
1267:
1268:
1269: hr_utility.trace('location address '||replace(sp_out_1,' ','*'));

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

1262: hr_utility.trace('Zip '||sp_out_5);
1263: hr_utility.trace('Zip Code Extension '||sp_out_6);
1264: hr_utility.trace('Foreign State/Province '||sp_out_7);
1265: hr_utility.trace('Foreign Zip '||sp_out_8);
1266: hr_utility.trace('Country '||sp_out_9);
1267:
1268:
1269: hr_utility.trace('location address '||replace(sp_out_1,' ','*'));
1270: hr_utility.trace('delivery address '||replace(sp_out_2,' ','*'));

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

1265: hr_utility.trace('Foreign Zip '||sp_out_8);
1266: hr_utility.trace('Country '||sp_out_9);
1267:
1268:
1269: hr_utility.trace('location address '||replace(sp_out_1,' ','*'));
1270: hr_utility.trace('delivery address '||replace(sp_out_2,' ','*'));
1271: hr_utility.trace('City '||replace(sp_out_3,' ','*'));
1272: hr_utility.trace('State '||replace(sp_out_4,' ','*'));
1273: hr_utility.trace('Zip '||replace(sp_out_5,' ','*'));

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

1266: hr_utility.trace('Country '||sp_out_9);
1267:
1268:
1269: hr_utility.trace('location address '||replace(sp_out_1,' ','*'));
1270: hr_utility.trace('delivery address '||replace(sp_out_2,' ','*'));
1271: hr_utility.trace('City '||replace(sp_out_3,' ','*'));
1272: hr_utility.trace('State '||replace(sp_out_4,' ','*'));
1273: hr_utility.trace('Zip '||replace(sp_out_5,' ','*'));
1274: hr_utility.trace('Zip Code Extension '||replace(sp_out_6,' ','*'));

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

1267:
1268:
1269: hr_utility.trace('location address '||replace(sp_out_1,' ','*'));
1270: hr_utility.trace('delivery address '||replace(sp_out_2,' ','*'));
1271: hr_utility.trace('City '||replace(sp_out_3,' ','*'));
1272: hr_utility.trace('State '||replace(sp_out_4,' ','*'));
1273: hr_utility.trace('Zip '||replace(sp_out_5,' ','*'));
1274: hr_utility.trace('Zip Code Extension '||replace(sp_out_6,' ','*'));
1275: hr_utility.trace('Foreign State/Province '||replace(sp_out_7,' ','*'));

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

1268:
1269: hr_utility.trace('location address '||replace(sp_out_1,' ','*'));
1270: hr_utility.trace('delivery address '||replace(sp_out_2,' ','*'));
1271: hr_utility.trace('City '||replace(sp_out_3,' ','*'));
1272: hr_utility.trace('State '||replace(sp_out_4,' ','*'));
1273: hr_utility.trace('Zip '||replace(sp_out_5,' ','*'));
1274: hr_utility.trace('Zip Code Extension '||replace(sp_out_6,' ','*'));
1275: hr_utility.trace('Foreign State/Province '||replace(sp_out_7,' ','*'));
1276: hr_utility.trace('Foreign Zip '||replace(sp_out_8,' ','*'));

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

1269: hr_utility.trace('location address '||replace(sp_out_1,' ','*'));
1270: hr_utility.trace('delivery address '||replace(sp_out_2,' ','*'));
1271: hr_utility.trace('City '||replace(sp_out_3,' ','*'));
1272: hr_utility.trace('State '||replace(sp_out_4,' ','*'));
1273: hr_utility.trace('Zip '||replace(sp_out_5,' ','*'));
1274: hr_utility.trace('Zip Code Extension '||replace(sp_out_6,' ','*'));
1275: hr_utility.trace('Foreign State/Province '||replace(sp_out_7,' ','*'));
1276: hr_utility.trace('Foreign Zip '||replace(sp_out_8,' ','*'));
1277: hr_utility.trace('Country '||replace(sp_out_9,' ','*'));

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

1270: hr_utility.trace('delivery address '||replace(sp_out_2,' ','*'));
1271: hr_utility.trace('City '||replace(sp_out_3,' ','*'));
1272: hr_utility.trace('State '||replace(sp_out_4,' ','*'));
1273: hr_utility.trace('Zip '||replace(sp_out_5,' ','*'));
1274: hr_utility.trace('Zip Code Extension '||replace(sp_out_6,' ','*'));
1275: hr_utility.trace('Foreign State/Province '||replace(sp_out_7,' ','*'));
1276: hr_utility.trace('Foreign Zip '||replace(sp_out_8,' ','*'));
1277: hr_utility.trace('Country '||replace(sp_out_9,' ','*'));
1278:

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

1271: hr_utility.trace('City '||replace(sp_out_3,' ','*'));
1272: hr_utility.trace('State '||replace(sp_out_4,' ','*'));
1273: hr_utility.trace('Zip '||replace(sp_out_5,' ','*'));
1274: hr_utility.trace('Zip Code Extension '||replace(sp_out_6,' ','*'));
1275: hr_utility.trace('Foreign State/Province '||replace(sp_out_7,' ','*'));
1276: hr_utility.trace('Foreign Zip '||replace(sp_out_8,' ','*'));
1277: hr_utility.trace('Country '||replace(sp_out_9,' ','*'));
1278:
1279:

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

1272: hr_utility.trace('State '||replace(sp_out_4,' ','*'));
1273: hr_utility.trace('Zip '||replace(sp_out_5,' ','*'));
1274: hr_utility.trace('Zip Code Extension '||replace(sp_out_6,' ','*'));
1275: hr_utility.trace('Foreign State/Province '||replace(sp_out_7,' ','*'));
1276: hr_utility.trace('Foreign Zip '||replace(sp_out_8,' ','*'));
1277: hr_utility.trace('Country '||replace(sp_out_9,' ','*'));
1278:
1279:
1280: IF (p_item_name = 'ER_ADDRESS') THEN

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

1273: hr_utility.trace('Zip '||replace(sp_out_5,' ','*'));
1274: hr_utility.trace('Zip Code Extension '||replace(sp_out_6,' ','*'));
1275: hr_utility.trace('Foreign State/Province '||replace(sp_out_7,' ','*'));
1276: hr_utility.trace('Foreign Zip '||replace(sp_out_8,' ','*'));
1277: hr_utility.trace('Country '||replace(sp_out_9,' ','*'));
1278:
1279:
1280: IF (p_item_name = 'ER_ADDRESS') THEN
1281: hr_utility.trace('Organization Name '||sp_out_10);

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

1277: hr_utility.trace('Country '||replace(sp_out_9,' ','*'));
1278:
1279:
1280: IF (p_item_name = 'ER_ADDRESS') THEN
1281: hr_utility.trace('Organization Name '||sp_out_10);
1282: ELSE
1283: hr_utility.trace('Employee Number '||sp_out_10);
1284: END IF;
1285: --

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

1279:
1280: IF (p_item_name = 'ER_ADDRESS') THEN
1281: hr_utility.trace('Organization Name '||sp_out_10);
1282: ELSE
1283: hr_utility.trace('Employee Number '||sp_out_10);
1284: END IF;
1285: --
1286: -- Check to include or exclude record on the basis of validity of address
1287: --

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

1287: --
1288: IF p_validate = 'Y' THEN
1289: IF l_err THEN
1290: p_exclude_from_output := 'Y';
1291: hr_utility.trace('p_validate is Y .error '||p_exclude_from_output);
1292: END IF;
1293: END IF;
1294: IF p_exclude_from_output IS NULL THEN
1295: p_exclude_from_output := 'N';

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

1326: FROM pay_assignment_actions paa
1327: WHERE paa.payroll_action_id = to_number(pact_id);
1328:
1329: BEGIN
1330: -- hr_utility.trace_on(NULL,'oracle');
1331: /* call to funciton to get the value of 1099R Transmitter */
1332: hr_utility.trace('Payroll_action_id = '||p_payroll_action_id);
1333: hr_utility.trace('p_state = '||p_state);
1334:

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

1328:
1329: BEGIN
1330: -- hr_utility.trace_on(NULL,'oracle');
1331: /* call to funciton to get the value of 1099R Transmitter */
1332: hr_utility.trace('Payroll_action_id = '||p_payroll_action_id);
1333: hr_utility.trace('p_state = '||p_state);
1334:
1335: OPEN get_payee_count(p_payroll_action_id);
1336: FETCH get_payee_count INTO l_payee_count;

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

1329: BEGIN
1330: -- hr_utility.trace_on(NULL,'oracle');
1331: /* call to funciton to get the value of 1099R Transmitter */
1332: hr_utility.trace('Payroll_action_id = '||p_payroll_action_id);
1333: hr_utility.trace('p_state = '||p_state);
1334:
1335: OPEN get_payee_count(p_payroll_action_id);
1336: FETCH get_payee_count INTO l_payee_count;
1337:

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

1340: l_message:='Error: No Payee found for Transmitter';
1341:
1342: l_payee_count := 0;
1343:
1344: hr_utility.trace('Payee Count = '||to_char(l_payee_count));
1345: ELSE
1346:
1347: hr_utility.trace('Payroll_action_id = '||p_payroll_action_id);
1348: hr_utility.trace('Payee Count = '||to_char(l_payee_count));

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

1343:
1344: hr_utility.trace('Payee Count = '||to_char(l_payee_count));
1345: ELSE
1346:
1347: hr_utility.trace('Payroll_action_id = '||p_payroll_action_id);
1348: hr_utility.trace('Payee Count = '||to_char(l_payee_count));
1349:
1350: END IF; /* get_payee_count */
1351:

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

1344: hr_utility.trace('Payee Count = '||to_char(l_payee_count));
1345: ELSE
1346:
1347: hr_utility.trace('Payroll_action_id = '||p_payroll_action_id);
1348: hr_utility.trace('Payee Count = '||to_char(l_payee_count));
1349:
1350: END IF; /* get_payee_count */
1351:
1352: CLOSE get_payee_count;

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

1369: sp_out_8 :=' ';
1370: sp_out_9 :=' ';
1371: sp_out_10 :=' ';
1372:
1373: hr_utility.trace('sp_out_1 = '||sp_out_1);
1374:
1375: l_main_return := ' ';
1376: return l_main_return;
1377: