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.
[Home] [Help]
APPS.PAY_YEPP_MISS_ASSIGN_PKG dependencies on PAY_US_PAYROLL_UTILS
Line 94: pay_us_payroll_utils.formated_data_string (p_input_string => 'Year '
90: lv_ni_name := NVL(lv_ni_name, 'Employee SS #');
91:
92:
93: lv_format1 :=
94: pay_us_payroll_utils.formated_data_string (p_input_string => 'Year '
95: ,p_bold => 'Y'
96: ,p_output_file_type => p_output_file_type) ;
97: if (p_pre_or_gre is not null) then
98: if p_pre_or_gre= 'PRE' then
Line 99: lv_format1 := lv_format1 ||pay_us_payroll_utils.formated_data_string
95: ,p_bold => 'Y'
96: ,p_output_file_type => p_output_file_type) ;
97: if (p_pre_or_gre is not null) then
98: if p_pre_or_gre= 'PRE' then
99: lv_format1 := lv_format1 ||pay_us_payroll_utils.formated_data_string
100: (p_input_string => 'PRE '
101: ,p_bold => 'Y'
102: ,p_output_file_type => p_output_file_type);
103: elsif p_pre_or_gre = 'GRE' then
Line 104: lv_format1 := lv_format1 ||pay_us_payroll_utils.formated_data_string
100: (p_input_string => 'PRE '
101: ,p_bold => 'Y'
102: ,p_output_file_type => p_output_file_type);
103: elsif p_pre_or_gre = 'GRE' then
104: lv_format1 := lv_format1 ||pay_us_payroll_utils.formated_data_string
105: (p_input_string => 'GRE '
106: ,p_bold => 'Y'
107: ,p_output_file_type => p_output_file_type);
108: end if;
Line 110: lv_format1 := lv_format1 ||pay_us_payroll_utils.formated_data_string
106: ,p_bold => 'Y'
107: ,p_output_file_type => p_output_file_type);
108: end if;
109: else
110: lv_format1 := lv_format1 ||pay_us_payroll_utils.formated_data_string
111: (p_input_string => 'GRE '
112: ,p_bold => 'Y'
113: ,p_output_file_type => p_output_file_type);
114: end if;
Line 116: lv_format1 := lv_format1 || pay_us_payroll_utils.formated_data_string
112: ,p_bold => 'Y'
113: ,p_output_file_type => p_output_file_type);
114: end if;
115:
116: lv_format1 := lv_format1 || pay_us_payroll_utils.formated_data_string
117: (p_input_string => 'Employee Name '
118: ,p_bold => 'Y'
119: ,p_output_file_type => p_output_file_type) ||
120: pay_us_payroll_utils.formated_data_string (p_input_string => lv_ni_name||' '
Line 120: pay_us_payroll_utils.formated_data_string (p_input_string => lv_ni_name||' '
116: lv_format1 := lv_format1 || pay_us_payroll_utils.formated_data_string
117: (p_input_string => 'Employee Name '
118: ,p_bold => 'Y'
119: ,p_output_file_type => p_output_file_type) ||
120: pay_us_payroll_utils.formated_data_string (p_input_string => lv_ni_name||' '
121: ,p_bold => 'Y'
122: ,p_output_file_type => p_output_file_type) ||
123: pay_us_payroll_utils.formated_data_string (p_input_string => 'Employee #'
124: ,p_bold => 'Y'
Line 123: pay_us_payroll_utils.formated_data_string (p_input_string => 'Employee #'
119: ,p_output_file_type => p_output_file_type) ||
120: pay_us_payroll_utils.formated_data_string (p_input_string => lv_ni_name||' '
121: ,p_bold => 'Y'
122: ,p_output_file_type => p_output_file_type) ||
123: pay_us_payroll_utils.formated_data_string (p_input_string => 'Employee #'
124: ,p_bold => 'Y'
125: ,p_output_file_type => p_output_file_type) ;
126:
127: hr_utility.trace('Static Label1 = ' || lv_format1);
Line 159: pay_us_payroll_utils.formated_data_string (p_input_string => p_year
155: BEGIN
156:
157: hr_utility.set_location(gv_package_name || '.formated_detail_string', 10);
158: lv_format1 :=
159: pay_us_payroll_utils.formated_data_string (p_input_string => p_year
160: ,p_bold => 'N'
161: ,p_output_file_type => p_output_file_type) ||
162: pay_us_payroll_utils.formated_data_string (p_input_string => p_gre
163: ,p_bold => 'N'
Line 162: pay_us_payroll_utils.formated_data_string (p_input_string => p_gre
158: lv_format1 :=
159: pay_us_payroll_utils.formated_data_string (p_input_string => p_year
160: ,p_bold => 'N'
161: ,p_output_file_type => p_output_file_type) ||
162: pay_us_payroll_utils.formated_data_string (p_input_string => p_gre
163: ,p_bold => 'N'
164: ,p_output_file_type => p_output_file_type) ||
165: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_name
166: ,p_bold => 'N'
Line 165: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_name
161: ,p_output_file_type => p_output_file_type) ||
162: pay_us_payroll_utils.formated_data_string (p_input_string => p_gre
163: ,p_bold => 'N'
164: ,p_output_file_type => p_output_file_type) ||
165: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_name
166: ,p_bold => 'N'
167: ,p_output_file_type => p_output_file_type) ||
168: pay_us_payroll_utils.formated_data_string (p_input_string => P_employee_ssn
169: ,p_bold => 'N'
Line 168: pay_us_payroll_utils.formated_data_string (p_input_string => P_employee_ssn
164: ,p_output_file_type => p_output_file_type) ||
165: pay_us_payroll_utils.formated_data_string (p_input_string => p_employee_name
166: ,p_bold => 'N'
167: ,p_output_file_type => p_output_file_type) ||
168: pay_us_payroll_utils.formated_data_string (p_input_string => P_employee_ssn
169: ,p_bold => 'N'
170: ,p_output_file_type => p_output_file_type) ||
171: pay_us_payroll_utils.formated_data_string (p_input_string => p_emplyee_number
172: ,p_bold => 'N'
Line 171: pay_us_payroll_utils.formated_data_string (p_input_string => p_emplyee_number
167: ,p_output_file_type => p_output_file_type) ||
168: pay_us_payroll_utils.formated_data_string (p_input_string => P_employee_ssn
169: ,p_bold => 'N'
170: ,p_output_file_type => p_output_file_type) ||
171: pay_us_payroll_utils.formated_data_string (p_input_string => p_emplyee_number
172: ,p_bold => 'N'
173: ,p_output_file_type => p_output_file_type);
174:
175:
Line 200: pay_us_payroll_utils.formated_data_string (p_input_string => lvc_message
196: lvc_message := 'No person was picked up based on selection parameters.' ||
197: ' The YEPP Archive for the GRE has no missing assignments.';
198: hr_utility.set_location(gv_package_name || '.formated_zero_count', 10);
199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
200: pay_us_payroll_utils.formated_data_string (p_input_string => lvc_message
201: ,p_bold => 'N'
202: ,p_output_file_type => output_file_type));
203: hr_utility.set_location(gv_package_name || '.formated_zero_count', 20);
204: END;
Line 238: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
234: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
235:
236:
237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
238: 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:
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
Line 243: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,
239: p_bold => 'N',
240: p_output_file_type => output_file_type)||'
');
241:
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
243: 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,''||
Line 248: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message3,
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_message3,
249: p_bold => 'N',
250: p_output_file_type => output_file_type)||' ');
251: ELSE
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
Line 253: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
249: p_bold => 'N',
250: p_output_file_type => output_file_type)||'');
251: ELSE
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
253: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
254: p_bold => 'N',
255: p_output_file_type => output_file_type));
256:
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
Line 258: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,
254: p_bold => 'N',
255: p_output_file_type => output_file_type));
256:
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
258: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,
259: p_bold => 'N',
260: p_output_file_type => output_file_type));
261:
262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
Line 263: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message3,
259: p_bold => 'N',
260: p_output_file_type => output_file_type));
261:
262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
263: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message3,
264: p_bold => 'N',
265: p_output_file_type => output_file_type));
266: END IF;
267:
Line 286: lv_format:= pay_us_payroll_utils.formated_data_string(p_input_string=>'Element Name'
282: lv_format VARCHAR2(32000);
283:
284: BEGIN
285: hr_utility.set_location(gv_package_name || '.formated_element_header.',10);
286: lv_format:= pay_us_payroll_utils.formated_data_string(p_input_string=>'Element Name'
287: ,p_output_file_type=>p_output_file_type
288: ,p_bold=>'Y')||
289: pay_us_payroll_utils.formated_data_string(p_input_string=>'Classification'
290: ,p_output_file_type=>p_output_file_type
Line 289: pay_us_payroll_utils.formated_data_string(p_input_string=>'Classification'
285: hr_utility.set_location(gv_package_name || '.formated_element_header.',10);
286: lv_format:= pay_us_payroll_utils.formated_data_string(p_input_string=>'Element Name'
287: ,p_output_file_type=>p_output_file_type
288: ,p_bold=>'Y')||
289: pay_us_payroll_utils.formated_data_string(p_input_string=>'Classification'
290: ,p_output_file_type=>p_output_file_type
291: ,p_bold=>'Y');
292: /*||
293: pay_us_payroll_utils.formated_data_string(p_input_string=>'Input Value Name'
Line 293: pay_us_payroll_utils.formated_data_string(p_input_string=>'Input Value Name'
289: pay_us_payroll_utils.formated_data_string(p_input_string=>'Classification'
290: ,p_output_file_type=>p_output_file_type
291: ,p_bold=>'Y');
292: /*||
293: pay_us_payroll_utils.formated_data_string(p_input_string=>'Input Value Name'
294: ,p_output_file_type=>p_output_file_type
295: ,p_bold=>'Y')*/
296:
297: p_static_label := lv_format;
Line 324: pay_us_payroll_utils.formated_data_string (p_input_string=>p_element_name
320:
321: hr_utility.set_location(gv_package_name || '.formated_element_row', 10);
322:
323: lv_format :=
324: pay_us_payroll_utils.formated_data_string (p_input_string=>p_element_name
325: ,p_output_file_type=>p_output_file_type
326: ,p_bold=>'N'
327: )||
328: pay_us_payroll_utils.formated_data_string (p_input_string=>p_classification
Line 328: pay_us_payroll_utils.formated_data_string (p_input_string=>p_classification
324: pay_us_payroll_utils.formated_data_string (p_input_string=>p_element_name
325: ,p_output_file_type=>p_output_file_type
326: ,p_bold=>'N'
327: )||
328: pay_us_payroll_utils.formated_data_string (p_input_string=>p_classification
329: ,p_output_file_type=>p_output_file_type
330: ,p_bold=>'N'
331: );
332: /*||
Line 333: pay_us_payroll_utils.formated_data_string (p_input_string=>p_input_value_name
329: ,p_output_file_type=>p_output_file_type
330: ,p_bold=>'N'
331: );
332: /*||
333: pay_us_payroll_utils.formated_data_string (p_input_string=>p_input_value_name
334: ,p_output_file_type=>p_output_file_type
335: ,p_bold=>'N'
336: );*/
337:
Line 519: select pay_us_payroll_utils.get_parameter(
515: into lv_legislative_param
516: from pay_payroll_actions
517: where payroll_action_id = p_payroll_action_id;
518:
519: select pay_us_payroll_utils.get_parameter(
520: 'ASSIGNMENT_SET',
521: lv_legislative_param),
522: pay_us_payroll_utils.get_parameter(
523: 'OUTPUT_TYPE',
Line 522: pay_us_payroll_utils.get_parameter(
518:
519: select pay_us_payroll_utils.get_parameter(
520: 'ASSIGNMENT_SET',
521: lv_legislative_param),
522: pay_us_payroll_utils.get_parameter(
523: 'OUTPUT_TYPE',
524: lv_legislative_param)
525: into lv_assignment_set, lv_output_file_type
526: from dual;
Line 541: pay_us_payroll_utils.formated_header_string(gv_title || ':- Tax Year: ' ||
537: hr_utility.trace('lv_assignment_set = ' || lv_assignment_set);
538: hr_utility.trace('lv_output_file_type = ' || lv_output_file_type);
539:
540: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
541: pay_us_payroll_utils.formated_header_string(gv_title || ':- Tax Year: ' ||
542: to_char(lv_effective_date,'YYYY'),lv_output_file_type ));
543:
544: open c_get_business_group_id(nvl(p_tax_unit_id,l_pre_organization_id));
545: fetch c_get_business_group_id into lv_business_group_id;
Line 700: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_header_string(
696:
697: lv_element_count := 0;
698:
699: lv_title := 'Element Information';
700: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_header_string(
701: lv_title
702: ,lv_output_file_type
703: ));
704:
Line 711: pay_us_payroll_utils.formated_data_string (p_input_string =>lv_element_info,
707:
708: IF lv_output_file_type ='HTML' THEN
709: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
710: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
711: pay_us_payroll_utils.formated_data_string (p_input_string =>lv_element_info,
712: p_bold => 'N',
713: p_output_file_type => lv_output_file_type)||'
');
714: ELSE
715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
Line 716: pay_us_payroll_utils.formated_data_string (p_input_string =>lv_element_info,
712: p_bold => 'N',
713: p_output_file_type => lv_output_file_type)||'
');
714: ELSE
715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
716: pay_us_payroll_utils.formated_data_string (p_input_string =>lv_element_info,
717: p_bold => 'N',
718: p_output_file_type => lv_output_file_type));
719: END IF;
720:
Line 774: lv_element_count_info := pay_us_payroll_utils.formated_data_string
770:
771: -- hr_utility.set_location(gv_package_name || '.select_employee', 170);
772: END IF;
773:
774: lv_element_count_info := pay_us_payroll_utils.formated_data_string
775: (p_input_string =>'Number of Elements Found = '|| lv_element_count
776: ,p_bold => 'N'
777: ,p_output_file_type => lv_output_file_type);
778: