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_YEPP_MISS_ASSIGN_PKG dependencies on PAY_US_PAYROLL_UTILS

Line 100: pay_us_payroll_utils.formated_data_string (p_input_string => 'Year '

96: BEGIN
97:
98: hr_utility.set_location(gv_package_name || '.formated_header_string', 10);
99: lv_format1 :=
100: pay_us_payroll_utils.formated_data_string (p_input_string => 'Year '
101: ,p_bold => 'Y'
102: ,p_output_file_type => p_output_file_type) ||
103: pay_us_payroll_utils.formated_data_string (p_input_string => 'GRE '
104: ,p_bold => 'Y'

Line 103: pay_us_payroll_utils.formated_data_string (p_input_string => 'GRE '

99: lv_format1 :=
100: pay_us_payroll_utils.formated_data_string (p_input_string => 'Year '
101: ,p_bold => 'Y'
102: ,p_output_file_type => p_output_file_type) ||
103: pay_us_payroll_utils.formated_data_string (p_input_string => 'GRE '
104: ,p_bold => 'Y'
105: ,p_output_file_type => p_output_file_type) ||
106:
107: pay_us_payroll_utils.formated_data_string (p_input_string => 'Employee Name '

Line 107: pay_us_payroll_utils.formated_data_string (p_input_string => 'Employee Name '

103: pay_us_payroll_utils.formated_data_string (p_input_string => 'GRE '
104: ,p_bold => 'Y'
105: ,p_output_file_type => p_output_file_type) ||
106:
107: pay_us_payroll_utils.formated_data_string (p_input_string => 'Employee Name '
108: ,p_bold => 'Y'
109: ,p_output_file_type => p_output_file_type) ||
110: pay_us_payroll_utils.formated_data_string (p_input_string => 'Employee SS # '
111: ,p_bold => 'Y'

Line 110: pay_us_payroll_utils.formated_data_string (p_input_string => 'Employee SS # '

106:
107: pay_us_payroll_utils.formated_data_string (p_input_string => 'Employee Name '
108: ,p_bold => 'Y'
109: ,p_output_file_type => p_output_file_type) ||
110: pay_us_payroll_utils.formated_data_string (p_input_string => 'Employee SS # '
111: ,p_bold => 'Y'
112: ,p_output_file_type => p_output_file_type) ||
113: pay_us_payroll_utils.formated_data_string (p_input_string => 'Employee #'
114: ,p_bold => 'Y'

Line 113: pay_us_payroll_utils.formated_data_string (p_input_string => 'Employee #'

109: ,p_output_file_type => p_output_file_type) ||
110: pay_us_payroll_utils.formated_data_string (p_input_string => 'Employee SS # '
111: ,p_bold => 'Y'
112: ,p_output_file_type => p_output_file_type) ||
113: pay_us_payroll_utils.formated_data_string (p_input_string => 'Employee #'
114: ,p_bold => 'Y'
115: ,p_output_file_type => p_output_file_type) ;
116:
117: hr_utility.trace('Static Label1 = ' || lv_format1);

Line 149: pay_us_payroll_utils.formated_data_string (p_input_string => p_year

145: BEGIN
146:
147: hr_utility.set_location(gv_package_name || '.formated_detail_string', 10);
148: lv_format1 :=
149: pay_us_payroll_utils.formated_data_string (p_input_string => p_year
150: ,p_bold => 'N'
151: ,p_output_file_type => p_output_file_type) ||
152: pay_us_payroll_utils.formated_data_string (p_input_string => p_gre
153: ,p_bold => 'N'

Line 152: pay_us_payroll_utils.formated_data_string (p_input_string => p_gre

148: lv_format1 :=
149: pay_us_payroll_utils.formated_data_string (p_input_string => p_year
150: ,p_bold => 'N'
151: ,p_output_file_type => p_output_file_type) ||
152: pay_us_payroll_utils.formated_data_string (p_input_string => p_gre
153: ,p_bold => 'N'
154: ,p_output_file_type => p_output_file_type) ||
155: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_name
156: ,p_bold => 'N'

Line 155: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_name

151: ,p_output_file_type => p_output_file_type) ||
152: pay_us_payroll_utils.formated_data_string (p_input_string => p_gre
153: ,p_bold => 'N'
154: ,p_output_file_type => p_output_file_type) ||
155: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_name
156: ,p_bold => 'N'
157: ,p_output_file_type => p_output_file_type) ||
158: pay_us_payroll_utils.formated_data_string (p_input_string => P_employee_ssn
159: ,p_bold => 'N'

Line 158: pay_us_payroll_utils.formated_data_string (p_input_string => P_employee_ssn

154: ,p_output_file_type => p_output_file_type) ||
155: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_name
156: ,p_bold => 'N'
157: ,p_output_file_type => p_output_file_type) ||
158: pay_us_payroll_utils.formated_data_string (p_input_string => P_employee_ssn
159: ,p_bold => 'N'
160: ,p_output_file_type => p_output_file_type) ||
161: pay_us_payroll_utils.formated_data_string (p_input_string => p_emplyee_number
162: ,p_bold => 'N'

Line 161: pay_us_payroll_utils.formated_data_string (p_input_string => p_emplyee_number

157: ,p_output_file_type => p_output_file_type) ||
158: pay_us_payroll_utils.formated_data_string (p_input_string => P_employee_ssn
159: ,p_bold => 'N'
160: ,p_output_file_type => p_output_file_type) ||
161: pay_us_payroll_utils.formated_data_string (p_input_string => p_emplyee_number
162: ,p_bold => 'N'
163: ,p_output_file_type => p_output_file_type);
164:
165:

Line 190: pay_us_payroll_utils.formated_data_string (p_input_string => lvc_message

186: lvc_message := 'No person was picked up based on selection parameters.' ||
187: ' The YEPP Archive for the GRE has no missing assignments.';
188: hr_utility.set_location(gv_package_name || '.formated_zero_count', 10);
189: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
190: pay_us_payroll_utils.formated_data_string (p_input_string => lvc_message
191: ,p_bold => 'N'
192: ,p_output_file_type => output_file_type));
193: hr_utility.set_location(gv_package_name || '.formated_zero_count', 20);
194: END;

Line 228: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,

224: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
225:
226:
227: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
228: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
229: p_bold => 'N',
230: p_output_file_type => output_file_type)||'');
231:
232: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
Line 233: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,

229: p_bold => 'N',
230: p_output_file_type => output_file_type)||'
');
231:
232: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
233: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,
234: p_bold => 'N',
235: p_output_file_type => output_file_type)||'');
236:
237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
Line 238: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message3,

234: p_bold => 'N',
235: p_output_file_type => output_file_type)||'
');
236:
237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
238: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message3,
239: p_bold => 'N',
240: p_output_file_type => output_file_type)||'');
241: ELSE
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
Line 243: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,

239: p_bold => 'N',
240: p_output_file_type => output_file_type)||'');
241: ELSE
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
243: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
244: p_bold => 'N',
245: p_output_file_type => output_file_type));
246:
247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

Line 248: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,

244: p_bold => 'N',
245: p_output_file_type => output_file_type));
246:
247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
248: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,
249: p_bold => 'N',
250: p_output_file_type => output_file_type));
251:
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

Line 253: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message3,

249: p_bold => 'N',
250: p_output_file_type => output_file_type));
251:
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
253: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message3,
254: p_bold => 'N',
255: p_output_file_type => output_file_type));
256: END IF;
257:

Line 276: lv_format:= pay_us_payroll_utils.formated_data_string(p_input_string=>'Element Name'

272: lv_format VARCHAR2(32000);
273:
274: BEGIN
275: hr_utility.set_location(gv_package_name || '.formated_element_header.',10);
276: lv_format:= pay_us_payroll_utils.formated_data_string(p_input_string=>'Element Name'
277: ,p_output_file_type=>p_output_file_type
278: ,p_bold=>'Y')||
279: pay_us_payroll_utils.formated_data_string(p_input_string=>'Classification'
280: ,p_output_file_type=>p_output_file_type

Line 279: pay_us_payroll_utils.formated_data_string(p_input_string=>'Classification'

275: hr_utility.set_location(gv_package_name || '.formated_element_header.',10);
276: lv_format:= pay_us_payroll_utils.formated_data_string(p_input_string=>'Element Name'
277: ,p_output_file_type=>p_output_file_type
278: ,p_bold=>'Y')||
279: pay_us_payroll_utils.formated_data_string(p_input_string=>'Classification'
280: ,p_output_file_type=>p_output_file_type
281: ,p_bold=>'Y')||
282: pay_us_payroll_utils.formated_data_string(p_input_string=>'Input Value Name'
283: ,p_output_file_type=>p_output_file_type

Line 282: pay_us_payroll_utils.formated_data_string(p_input_string=>'Input Value Name'

278: ,p_bold=>'Y')||
279: pay_us_payroll_utils.formated_data_string(p_input_string=>'Classification'
280: ,p_output_file_type=>p_output_file_type
281: ,p_bold=>'Y')||
282: pay_us_payroll_utils.formated_data_string(p_input_string=>'Input Value Name'
283: ,p_output_file_type=>p_output_file_type
284: ,p_bold=>'Y');
285:
286: p_static_label := lv_format;

Line 313: pay_us_payroll_utils.formated_data_string (p_input_string=>p_element_name

309:
310: hr_utility.set_location(gv_package_name || '.formated_element_row', 10);
311:
312: lv_format :=
313: pay_us_payroll_utils.formated_data_string (p_input_string=>p_element_name
314: ,p_output_file_type=>p_output_file_type
315: ,p_bold=>'N'
316: )||
317: pay_us_payroll_utils.formated_data_string (p_input_string=>p_classification

Line 317: pay_us_payroll_utils.formated_data_string (p_input_string=>p_classification

313: pay_us_payroll_utils.formated_data_string (p_input_string=>p_element_name
314: ,p_output_file_type=>p_output_file_type
315: ,p_bold=>'N'
316: )||
317: pay_us_payroll_utils.formated_data_string (p_input_string=>p_classification
318: ,p_output_file_type=>p_output_file_type
319: ,p_bold=>'N'
320: )||
321: pay_us_payroll_utils.formated_data_string (p_input_string=>p_input_value_name

Line 321: pay_us_payroll_utils.formated_data_string (p_input_string=>p_input_value_name

317: pay_us_payroll_utils.formated_data_string (p_input_string=>p_classification
318: ,p_output_file_type=>p_output_file_type
319: ,p_bold=>'N'
320: )||
321: pay_us_payroll_utils.formated_data_string (p_input_string=>p_input_value_name
322: ,p_output_file_type=>p_output_file_type
323: ,p_bold=>'N'
324: );
325:

Line 505: select pay_us_payroll_utils.get_parameter(

501: into lv_legislative_param
502: from pay_payroll_actions
503: where payroll_action_id = p_payroll_action_id;
504:
505: select pay_us_payroll_utils.get_parameter(
506: 'ASSIGNMENT_SET',
507: lv_legislative_param),
508: pay_us_payroll_utils.get_parameter(
509: 'OUTPUT_TYPE',

Line 508: pay_us_payroll_utils.get_parameter(

504:
505: select pay_us_payroll_utils.get_parameter(
506: 'ASSIGNMENT_SET',
507: lv_legislative_param),
508: pay_us_payroll_utils.get_parameter(
509: 'OUTPUT_TYPE',
510: lv_legislative_param)
511: into lv_assignment_set, lv_output_file_type
512: from dual;

Line 519: pay_us_payroll_utils.formated_header_string(gv_title || ':- Tax Year: ' ||

515: hr_utility.trace('lv_assignment_set = ' || lv_assignment_set);
516: hr_utility.trace('lv_output_file_type = ' || lv_output_file_type);
517:
518: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
519: pay_us_payroll_utils.formated_header_string(gv_title || ':- Tax Year: ' ||
520: to_char(lv_effective_date,'YYYY'),lv_output_file_type ));
521:
522: open c_get_business_group_id(p_tax_unit_id);
523: fetch c_get_business_group_id into lv_business_group_id;

Line 666: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_header_string(

662:
663: lv_element_count := 0;
664:
665: lv_title := 'Element Information';
666: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_header_string(
667: lv_title
668: ,lv_output_file_type
669: ));
670:

Line 676: pay_us_payroll_utils.formated_data_string (p_input_string =>lv_element_info,

672:
673: IF lv_output_file_type ='HTML' THEN
674: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
675: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
676: pay_us_payroll_utils.formated_data_string (p_input_string =>lv_element_info,
677: p_bold => 'N',
678: p_output_file_type => lv_output_file_type)||'
');
679: ELSE
680: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
Line 681: pay_us_payroll_utils.formated_data_string (p_input_string =>lv_element_info,

677: p_bold => 'N',
678: p_output_file_type => lv_output_file_type)||'
');
679: ELSE
680: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
681: pay_us_payroll_utils.formated_data_string (p_input_string =>lv_element_info,
682: p_bold => 'N',
683: p_output_file_type => lv_output_file_type));
684: END IF;
685:
Line 741: lv_element_count_info := pay_us_payroll_utils.formated_data_string

737:
738: -- hr_utility.set_location(gv_package_name || '.select_employee', 170);
739: END IF;
740:
741: lv_element_count_info := pay_us_payroll_utils.formated_data_string
742: (p_input_string =>'Number of Elements Found = '|| lv_element_count
743: ,p_bold => 'N'
744: ,p_output_file_type => lv_output_file_type);
745: