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_GET_ITEM_DATA_PKG dependencies on HR_UTILITY

Line 231: hr_utility.trace('Fetching Contact Person Information CR_PERSON');

227: c_item_name := 'CR_PERSON';
228: END IF;
229:
230: l_valid_address:=FALSE;
231: hr_utility.trace('Fetching Contact Person Information CR_PERSON');
232: l_person_id:=replace(p_person_id,' ');
233: OPEN get_person_infm(to_number(l_person_id),
234: p_date_earned);
235:

Line 249: hr_utility.trace('Contact person information not found');

245: p_contact_prsn_name :=l_full_name;
246: p_contact_prsn_phone :=l_phone;
247: p_contact_prsn_extension :=l_extension;
248: p_contact_prsn_email :=l_email;
249: hr_utility.trace('Contact person information not found');
250: --}
251: ELSIF get_person_infm%FOUND THEN
252: --{
253: p_contact_prsn_name := l_full_name;

Line 274: hr_utility.trace('Contact person PHONE Found.'||p_contact_prsn_phone);

270:
271: IF l_phone_type = 'W1' THEN -- Work Phone
272: p_contact_prsn_phone :=
273: replace(pay_us_reporting_utils_pkg.Character_check(l_phone),'-');
274: hr_utility.trace('Contact person PHONE Found.'||p_contact_prsn_phone);
275: ELSIF l_phone_type = 'WF' THEN -- Work Fax
276: p_contact_prsn_fax :=
277: replace(pay_us_reporting_utils_pkg.Character_check(l_phone),'-');
278: hr_utility.trace('Contact Person Fax found.'||p_contact_prsn_fax);

Line 278: hr_utility.trace('Contact Person Fax found.'||p_contact_prsn_fax);

274: hr_utility.trace('Contact person PHONE Found.'||p_contact_prsn_phone);
275: ELSIF l_phone_type = 'WF' THEN -- Work Fax
276: p_contact_prsn_fax :=
277: replace(pay_us_reporting_utils_pkg.Character_check(l_phone),'-');
278: hr_utility.trace('Contact Person Fax found.'||p_contact_prsn_fax);
279: END IF;
280:
281: END LOOP; /* get_phone_fax */
282: CLOSE get_phone_fax;

Line 292: hr_utility.trace('Contact person PHONE Extension '||p_contact_prsn_extension);

288: p_contact_prsn_extension :=
289: rpad(nvl(substr(p_contact_prsn_phone,11,5),' '),5); --Extension
290: p_contact_prsn_phone :=
291: rpad(substr(nvl(p_contact_prsn_phone,' '),1,10),15); --Phone number
292: hr_utility.trace('Contact person PHONE Extension '||p_contact_prsn_extension);
293: --}
294: IF c_item_name <> 'CS_PERSON' THEN -- For title
295:
296: IF p_report_type IN ( 'W2', 'W2C') THEN

Line 301: hr_utility.trace('Formatting Contact Person Info for W2 reporting ');

297: --{
298: --
299: -- This procedure formats contact information fields specific to W2 reporting
300: --
301: hr_utility.trace('Formatting Contact Person Info for W2 reporting ');
302: pay_us_mmrf_w2_format_record.format_w2_contact_prsn_info(
303: p_report_qualifier,
304: p_record_name,
305: p_validate,

Line 317: hr_utility.trace('Contact Person info formatted for W2 reporting ');

313: p_contact_prsn_middle_name,
314: p_contact_prsn_last_name
315: );
316: --}
317: hr_utility.trace('Contact Person info formatted for W2 reporting ');
318: ELSIF p_report_type = 'SQWL' THEN
319: --{
320: --
321: -- This procedure formats contact information fields specific to SQWL reporting

Line 323: hr_utility.trace('Formatting Contact Person Info for SQWL reporting ');

319: --{
320: --
321: -- This procedure formats contact information fields specific to SQWL reporting
322: --
323: hr_utility.trace('Formatting Contact Person Info for SQWL reporting ');
324: pay_us_mmrf_sqwl_format_record.format_sqwl_contact_prsn_info(
325: p_report_qualifier,
326: p_record_name,
327: p_validate,

Line 382: hr_utility.trace('Contact Person Information found. Full Name = '

378: ITEM NAME used is 'CS_PERSON' */
379:
380: END IF; -- For title
381:
382: hr_utility.trace('Contact Person Information found. Full Name = '
383: ||p_contact_prsn_name);
384: END IF; --get_person_infm%NOTFOUND
385: CLOSE get_person_infm;
386: return p_contact_prsn_name;

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

467: lr_employee_addr pay_us_get_item_data_pkg.person_name_address;
468: l_effective_date date;
469: l_input_2 varchar2(200);
470: BEGIN
471: hr_utility.trace('In function GET_MMREF_EMPLOYEE_ADDRESS');
472: c_item_name:='EE_ADDRESS';
473: --
474: -- This change is made for Mag W-2 reporting purpose
475: -- For W2, SQWL and 1099R Mag was not reporting address change beyond

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

481: l_effective_date := fnd_date.canonical_TO_DATE(l_input_2);
482: else
483: l_effective_date := p_effective_date;
484: end if;
485: hr_utility.trace('In function GET_MMREF_EMPLOYEE_ADDRESS');
486: --
487: lr_employee_addr :=
488: pay_us_get_item_data_pkg.GET_PERSON_NAME_ADDRESS(
489: p_report_type,

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

492: p_date_earned,
493: l_effective_date,
494: p_validate,
495: p_record_name);
496: hr_utility.trace('Employee '||lr_employee_addr.full_name ||' Info found ');
497: hr_utility.trace('Formatting Employee Address for '||p_report_type
498: ||' Reporting ');
499: --
500: -- Format Employee Address for W2 / SQWL

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

493: l_effective_date,
494: p_validate,
495: p_record_name);
496: hr_utility.trace('Employee '||lr_employee_addr.full_name ||' Info found ');
497: hr_utility.trace('Formatting Employee Address for '||p_report_type
498: ||' Reporting ');
499: --
500: -- Format Employee Address for W2 / SQWL
501: --

Line 620: hr_utility.trace('FUNCTION GET_MMREF_EMPLOYER_ADDRESS for Employer Address');

616: l_emp_number varchar2(40);
617: l_locality_company_id varchar2(50);
618: lr_employer_addr pay_us_get_item_data_pkg.organization_name_address;
619: BEGIN
620: hr_utility.trace('FUNCTION GET_MMREF_EMPLOYER_ADDRESS for Employer Address');
621: c_tax_unit_id := p_tax_unit_id;
622: c_item_name := 'ER_ADDRESS';
623:
624: hr_utility.trace('Tax Unit Id = '||to_char(c_tax_unit_id));

Line 624: hr_utility.trace('Tax Unit Id = '||to_char(c_tax_unit_id));

620: hr_utility.trace('FUNCTION GET_MMREF_EMPLOYER_ADDRESS for Employer Address');
621: c_tax_unit_id := p_tax_unit_id;
622: c_item_name := 'ER_ADDRESS';
623:
624: hr_utility.trace('Tax Unit Id = '||to_char(c_tax_unit_id));
625: /* This would be used for Philadelphia locality only
626: subsequently this can be enhanced to generalise for any locality */
627:
628: IF p_input_1 = 'PHILA' THEN

Line 629: hr_utility.trace('Fetch Locality_Company_Id ...');

625: /* This would be used for Philadelphia locality only
626: subsequently this can be enhanced to generalise for any locality */
627:
628: IF p_input_1 = 'PHILA' THEN
629: hr_utility.trace('Fetch Locality_Company_Id ...');
630: OPEN get_locality_company_id(c_tax_unit_id);
631: FETCH get_locality_company_id INTO l_locality_company_id;
632: CLOSE get_locality_company_id ;
633: hr_utility.trace('ER_ADDRESS Locality_Company_Id ...'||

Line 633: hr_utility.trace('ER_ADDRESS Locality_Company_Id ...'||

629: hr_utility.trace('Fetch Locality_Company_Id ...');
630: OPEN get_locality_company_id(c_tax_unit_id);
631: FETCH get_locality_company_id INTO l_locality_company_id;
632: CLOSE get_locality_company_id ;
633: hr_utility.trace('ER_ADDRESS Locality_Company_Id ...'||
634: l_locality_company_id );
635: END IF;
636: lr_employer_addr :=
637: pay_us_get_item_data_pkg.get_organization_name_address(

Line 984: hr_utility.trace('Date Earned or Period End Date '||to_char(p_period_end_date,'dd-mon-yyyy'));

980: else
981: l_effective_date := p_effective_date;
982: end if;
983: --
984: hr_utility.trace('Date Earned or Period End Date '||to_char(p_period_end_date,'dd-mon-yyyy'));
985: hr_utility.trace('Date Effective or Session Date '||to_char(l_effective_date,'dd-mon-yyyy'));
986: --
987: if p_report_type IN ('W2','SQWL','1099R','W2C') then
988: l_report_type := 'MMREF';

Line 985: hr_utility.trace('Date Effective or Session Date '||to_char(l_effective_date,'dd-mon-yyyy'));

981: l_effective_date := p_effective_date;
982: end if;
983: --
984: hr_utility.trace('Date Earned or Period End Date '||to_char(p_period_end_date,'dd-mon-yyyy'));
985: hr_utility.trace('Date Effective or Session Date '||to_char(l_effective_date,'dd-mon-yyyy'));
986: --
987: if p_report_type IN ('W2','SQWL','1099R','W2C') then
988: l_report_type := 'MMREF';
989: else

Line 1078: hr_utility.trace('WARNING: Employee Address not found ');

1074: -- This is validate person Address
1075: IF P_validate = 'Y' THEN
1076: --{
1077: IF l_addr_count = 0 THEN
1078: hr_utility.trace('WARNING: Employee Address not found ');
1079: l_valid_address := 'N';
1080: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
1081: pay_core_utils.push_token('record_name',l_record);
1082: pay_core_utils.push_token('name_or_number',

Line 1086: hr_utility.trace('Too many rows for the address');

1082: pay_core_utils.push_token('name_or_number',
1083: lr_person_name_address.employee_number);
1084: pay_core_utils.push_token('description',l_token2);
1085: ELSIF l_addr_count > 1 THEN
1086: hr_utility.trace('Too many rows for the address');
1087: l_valid_address := 'N';
1088: pay_core_utils.push_message(801,'PAY_INVALID_EE_FORMAT_WARNING','A');
1089: pay_core_utils.push_token('record_name',l_record);
1090: pay_core_utils.push_token('name_or_number',

Line 1095: hr_utility.trace('Single Primary Valid Address Found ..'||l_valid_address);

1091: lr_person_name_address.employee_number);
1092: pay_core_utils.push_token('description',l_too_many_adr_token3);
1093: ELSIF l_addr_count = 1 THEN
1094: l_valid_address:= 'Y';
1095: hr_utility.trace('Single Primary Valid Address Found ..'||l_valid_address);
1096: END IF;
1097: --}
1098: ELSE
1099: l_valid_address:= 'Y';

Line 1167: hr_utility.trace('ER_ADDRESS No data found for Tax_Unit_Id = '

1163: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1164: pay_core_utils.push_token('record_name',p_source_type||' record');
1165: pay_core_utils.push_token('description',l_token2);
1166: l_valid_address:='N';
1167: hr_utility.trace('ER_ADDRESS No data found for Tax_Unit_Id = '
1168: ||to_char(p_organization_id));
1169: ELSIF l_addr_count > 1 THEN
1170: hr_utility.trace('Too many rows for the address');
1171: l_valid_address := 'N';

Line 1170: hr_utility.trace('Too many rows for the address');

1166: l_valid_address:='N';
1167: hr_utility.trace('ER_ADDRESS No data found for Tax_Unit_Id = '
1168: ||to_char(p_organization_id));
1169: ELSIF l_addr_count > 1 THEN
1170: hr_utility.trace('Too many rows for the address');
1171: l_valid_address := 'N';
1172: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
1173: pay_core_utils.push_token('record_name',p_source_type||' record');
1174: pay_core_utils.push_token('description',l_too_many_adr_token3);

Line 1176: hr_utility.trace('ER_ADDRESS Employer Address Found ');

1172: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','A');
1173: pay_core_utils.push_token('record_name',p_source_type||' record');
1174: pay_core_utils.push_token('description',l_too_many_adr_token3);
1175: ELSIF l_addr_count = 1 THEN
1176: hr_utility.trace('ER_ADDRESS Employer Address Found ');
1177: l_valid_address:='Y';
1178: END IF;
1179: --}
1180: END IF;

Line 1228: hr_utility.trace('Magnetic Process Payroll_Action_Id '||to_char(l_payroll_action_id));

1224: --
1225: start_ptr := instr(parameter_list, token_val) + length(token_val);
1226: end_ptr := instr(parameter_list, ' ',start_ptr);
1227:
1228: hr_utility.trace('Magnetic Process Payroll_Action_Id '||to_char(l_payroll_action_id));
1229: --hr_utility.trace('Prameter List '||parameter_list);
1230: --hr_utility.trace('Token Value '||token_val);
1231: --hr_utility.trace('Start Ptr '||to_char(start_ptr));
1232: --hr_utility.trace('End Ptr '||to_char(end_ptr));

Line 1229: --hr_utility.trace('Prameter List '||parameter_list);

1225: start_ptr := instr(parameter_list, token_val) + length(token_val);
1226: end_ptr := instr(parameter_list, ' ',start_ptr);
1227:
1228: hr_utility.trace('Magnetic Process Payroll_Action_Id '||to_char(l_payroll_action_id));
1229: --hr_utility.trace('Prameter List '||parameter_list);
1230: --hr_utility.trace('Token Value '||token_val);
1231: --hr_utility.trace('Start Ptr '||to_char(start_ptr));
1232: --hr_utility.trace('End Ptr '||to_char(end_ptr));
1233: --

Line 1230: --hr_utility.trace('Token Value '||token_val);

1226: end_ptr := instr(parameter_list, ' ',start_ptr);
1227:
1228: hr_utility.trace('Magnetic Process Payroll_Action_Id '||to_char(l_payroll_action_id));
1229: --hr_utility.trace('Prameter List '||parameter_list);
1230: --hr_utility.trace('Token Value '||token_val);
1231: --hr_utility.trace('Start Ptr '||to_char(start_ptr));
1232: --hr_utility.trace('End Ptr '||to_char(end_ptr));
1233: --
1234: /* if there is no spaces use then length of the string */

Line 1231: --hr_utility.trace('Start Ptr '||to_char(start_ptr));

1227:
1228: hr_utility.trace('Magnetic Process Payroll_Action_Id '||to_char(l_payroll_action_id));
1229: --hr_utility.trace('Prameter List '||parameter_list);
1230: --hr_utility.trace('Token Value '||token_val);
1231: --hr_utility.trace('Start Ptr '||to_char(start_ptr));
1232: --hr_utility.trace('End Ptr '||to_char(end_ptr));
1233: --
1234: /* if there is no spaces use then length of the string */
1235: if end_ptr = 0 then

Line 1232: --hr_utility.trace('End Ptr '||to_char(end_ptr));

1228: hr_utility.trace('Magnetic Process Payroll_Action_Id '||to_char(l_payroll_action_id));
1229: --hr_utility.trace('Prameter List '||parameter_list);
1230: --hr_utility.trace('Token Value '||token_val);
1231: --hr_utility.trace('Start Ptr '||to_char(start_ptr));
1232: --hr_utility.trace('End Ptr '||to_char(end_ptr));
1233: --
1234: /* if there is no spaces use then length of the string */
1235: if end_ptr = 0 then
1236: end_ptr := length(parameter_list)+1;

Line 1254: hr_utility.trace('Parameter Value Returned '||par_value);

1250: if par_value IS NULL then
1251: par_value := 'NULL';
1252: end if;
1253: --
1254: hr_utility.trace('Parameter Value Returned '||par_value);
1255: return par_value;
1256: END GET_CPROG_PARAMETER_VALUE;
1257: --}
1258: --

Line 1260: --hr_utility.trace_on(null,'GETITEMDATA');

1256: END GET_CPROG_PARAMETER_VALUE;
1257: --}
1258: --
1259: --BEGIN
1260: --hr_utility.trace_on(null,'GETITEMDATA');
1261: END pay_us_get_item_data_pkg; --End of Package Body