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: