79: lv_ni_name fnd_new_messages.message_text%TYPE;
80:
81: BEGIN
82:
83: hr_utility.set_location(gv_package_name || '.formated_header_string', 10);
84:
85: lv_ni_name := NULL;
86: OPEN get_national_id_name(p_legislation_code);
87: FETCH get_national_id_name INTO lv_ni_name;
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);
128:
129:
130: return lv_format1 ;
131:
128:
129:
130: return lv_format1 ;
131:
132: hr_utility.set_location(gv_package_name || '.formated_header_string', 30);
133:
134: END formated_header_string;
135:
136:
153: lv_format1 VARCHAR2(22000);
154:
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) ||
172: ,p_bold => 'N'
173: ,p_output_file_type => p_output_file_type);
174:
175:
176: hr_utility.trace('Static Label1 = ' || lv_format1);
177: return lv_format1;
178:
179: hr_utility.set_location(gv_package_name || '.formated_detail_string', 30);
180:
175:
176: hr_utility.trace('Static Label1 = ' || lv_format1);
177: return lv_format1;
178:
179: hr_utility.set_location(gv_package_name || '.formated_detail_string', 30);
180:
181:
182:
183: END formated_detail_string;
194: BEGIN
195: null;
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));
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;
205:
206: /**************************************************************************
207: Procedure to display the name of the assignment set to which the selected
225: END IF;
226: lvc_message2 := 'Assignment Set ID : ' || to_char(assignment_set_id);
227: lvc_message3 := 'Number of employees added to the assignment set : ' ||
228: to_char(record_count);
229: hr_utility.set_location(gv_package_name || '.formated_assign_count', 10);
230:
231: IF output_file_type ='HTML' THEN
232: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
233: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
264: p_bold => 'N',
265: p_output_file_type => output_file_type));
266: END IF;
267:
268: hr_utility.set_location(gv_package_name || '.formated_assign_count', 20);
269: END;
270:
271: /**************************************************************************
272: Procedure to display the Elements having input values of type Money
281:
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'
294: ,p_output_file_type=>p_output_file_type
295: ,p_bold=>'Y')*/
296:
297: p_static_label := lv_format;
298: hr_utility.trace('Static Label = ' || p_static_label);
299: hr_utility.set_location(gv_package_name || '.formated_element_header', 20);
300:
301: END formated_element_header;
302:
295: ,p_bold=>'Y')*/
296:
297: p_static_label := lv_format;
298: hr_utility.trace('Static Label = ' || p_static_label);
299: hr_utility.set_location(gv_package_name || '.formated_element_header', 20);
300:
301: END formated_element_header;
302:
303: /************************************************************
317: lv_format VARCHAR2(32000);
318:
319: BEGIN
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
334: ,p_output_file_type=>p_output_file_type
335: ,p_bold=>'N'
336: );*/
337:
338: hr_utility.set_location(gv_package_name || '.formated_element_row', 20);
339:
340: p_static_data := lv_format;
341: hr_utility.trace('Static Data = ' || lv_format);
342: hr_utility.set_location(gv_package_name || '.formated_element_row', 30);
337:
338: hr_utility.set_location(gv_package_name || '.formated_element_row', 20);
339:
340: p_static_data := lv_format;
341: hr_utility.trace('Static Data = ' || lv_format);
342: hr_utility.set_location(gv_package_name || '.formated_element_row', 30);
343:
344: END formated_element_row;
345:
338: hr_utility.set_location(gv_package_name || '.formated_element_row', 20);
339:
340: p_static_data := lv_format;
341: hr_utility.trace('Static Data = ' || lv_format);
342: hr_utility.set_location(gv_package_name || '.formated_element_row', 30);
343:
344: END formated_element_row;
345:
346: /* ******************************************************
501: l_pre_or_gre varchar2(4);
502: --lv_legislative_parameters varchar2(500);
503:
504: BEGIN
505: --hr_utility.trace_on(null,'rdhingra_PYUSYEMA');
506: hr_utility.set_location(gv_package_name || '.select_employee', 10);
507: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
508: hr_utility.trace('p_effective_date = ' || p_effective_date);
509: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
502: --lv_legislative_parameters varchar2(500);
503:
504: BEGIN
505: --hr_utility.trace_on(null,'rdhingra_PYUSYEMA');
506: hr_utility.set_location(gv_package_name || '.select_employee', 10);
507: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
508: hr_utility.trace('p_effective_date = ' || p_effective_date);
509: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
510: hr_utility.trace('p_session_id = ' || p_session_id);
503:
504: BEGIN
505: --hr_utility.trace_on(null,'rdhingra_PYUSYEMA');
506: hr_utility.set_location(gv_package_name || '.select_employee', 10);
507: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
508: hr_utility.trace('p_effective_date = ' || p_effective_date);
509: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
510: hr_utility.trace('p_session_id = ' || p_session_id);
511:
504: BEGIN
505: --hr_utility.trace_on(null,'rdhingra_PYUSYEMA');
506: hr_utility.set_location(gv_package_name || '.select_employee', 10);
507: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
508: hr_utility.trace('p_effective_date = ' || p_effective_date);
509: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
510: hr_utility.trace('p_session_id = ' || p_session_id);
511:
512: lv_effective_date := fnd_date.canonical_to_date(FND_DATE.date_to_canonical(p_effective_date));
505: --hr_utility.trace_on(null,'rdhingra_PYUSYEMA');
506: hr_utility.set_location(gv_package_name || '.select_employee', 10);
507: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
508: hr_utility.trace('p_effective_date = ' || p_effective_date);
509: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
510: hr_utility.trace('p_session_id = ' || p_session_id);
511:
512: lv_effective_date := fnd_date.canonical_to_date(FND_DATE.date_to_canonical(p_effective_date));
513:
506: hr_utility.set_location(gv_package_name || '.select_employee', 10);
507: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
508: hr_utility.trace('p_effective_date = ' || p_effective_date);
509: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
510: hr_utility.trace('p_session_id = ' || p_session_id);
511:
512: lv_effective_date := fnd_date.canonical_to_date(FND_DATE.date_to_canonical(p_effective_date));
513:
514: select legislative_parameters
532: elsif p_tax_unit_id is not null then
533: l_pre_or_gre := 'GRE';
534: end if;
535:
536: hr_utility.set_location(gv_package_name || '.select_employee', 20);
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,
533: l_pre_or_gre := 'GRE';
534: end if;
535:
536: hr_utility.set_location(gv_package_name || '.select_employee', 20);
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: ' ||
534: end if;
535:
536: hr_utility.set_location(gv_package_name || '.select_employee', 20);
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 ));
549: fetch c_get_legislation_code into lv_legislation_code;
550: close c_get_legislation_code;
551: /* Report assignments picked up from PAY_US_RPT_TOTALS*/
552:
553: hr_utility.set_location(gv_package_name || '.select_employee', 30);
554:
555: OPEN c_get_missing_assignments(p_payroll_action_id, nvl(p_tax_unit_id,0));
556: LOOP
557: FETCH c_get_missing_assignments into lv_assignment_id;
554:
555: OPEN c_get_missing_assignments(p_payroll_action_id, nvl(p_tax_unit_id,0));
556: LOOP
557: FETCH c_get_missing_assignments into lv_assignment_id;
558: hr_utility.trace('lv_assignment_id = ' || lv_assignment_id);
559: EXIT when c_get_missing_assignments%NOTFOUND;
560:
561: lv_assignment_amd_exists:=0;
562: hr_utility.set_location(gv_package_name || '.select_employee', 40);
558: hr_utility.trace('lv_assignment_id = ' || lv_assignment_id);
559: EXIT when c_get_missing_assignments%NOTFOUND;
560:
561: lv_assignment_amd_exists:=0;
562: hr_utility.set_location(gv_package_name || '.select_employee', 40);
563: IF lv_assignment_id IS NOT NULL THEN
564: OPEN c_gre_or_pre_name(nvl(p_tax_unit_id,l_pre_organization_id));
565: hr_utility.trace('hhh');
566: FETCH c_gre_or_pre_name into lv_gre_or_pre_name;
561: lv_assignment_amd_exists:=0;
562: hr_utility.set_location(gv_package_name || '.select_employee', 40);
563: IF lv_assignment_id IS NOT NULL THEN
564: OPEN c_gre_or_pre_name(nvl(p_tax_unit_id,l_pre_organization_id));
565: hr_utility.trace('hhh');
566: FETCH c_gre_or_pre_name into lv_gre_or_pre_name;
567: CLOSE c_gre_or_pre_name;
568:
569:
575: FETCH c_employee_details into lv_emp_no,lv_emp_name,lv_emp_ssn;
576: CLOSE c_employee_details;
577:
578: /*create assignment set only when the first row is fetched*/
579: hr_utility.set_location(gv_package_name || '.select_employee', 50);
580: IF lv_miss_assignments=0 THEN
581: IF lv_output_file_type ='HTML' THEN
582: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
667: END IF;
668:
669: IF lv_miss_assignments=0 THEN
670: formated_zero_count(lv_output_file_type);
671: hr_utility.set_location(gv_package_name || '.select_employee', 110);
672: ELSE
673: formated_assign_count(lv_assignment_set,
674: lv_assignment_set_id,
675: lv_miss_assignments,
674: lv_assignment_set_id,
675: lv_miss_assignments,
676: lv_assign_set_created,
677: lv_output_file_type);
678: hr_utility.set_location(gv_package_name || '.select_employee', 120);
679:
680: END IF;
681:
682: IF lv_output_file_type ='HTML' THEN
688: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
689:
690: COMMIT;
691: END IF;
692: hr_utility.set_location(gv_package_name || '.select_employee', 130);
693:
694: /* Code to Display Element List */
695:
696:
718: p_output_file_type => lv_output_file_type));
719: END IF;
720:
721:
722: hr_utility.set_location(gv_package_name || '.select_employee', 140);
723:
724: open c_get_elements(lv_business_group_id,
725: lv_legislation_code);
726: LOOP
743:
744: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);
745: END IF;
746:
747: hr_utility.set_location(gv_package_name || '.select_employee', 150);
748:
749: lv_element_count := lv_element_count + 1;
750: formated_element_row(lv_element_name
751: ,lv_classification_name
751: ,lv_classification_name
752: ,lv_output_file_type
753: ,lv_element_row);
754:
755: hr_utility.trace('lv_element_row = ' || lv_element_row);
756:
757: IF lv_output_file_type ='HTML' THEN
758: lv_element_row := '
761: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_element_row);
762: END LOOP;
763: CLOSE c_get_elements;
764:
765: hr_utility.set_location(gv_package_name || '.select_employee', 160);
766:
767: IF lv_output_file_type='HTML' and lv_element_count > 0 THEN
768: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
769: --ELSIF lv_element_count = 0 THEN
767: IF lv_output_file_type='HTML' and lv_element_count > 0 THEN
768: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
769: --ELSIF lv_element_count = 0 THEN
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
783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_element_count_info);
784: END IF;
785:
786:
787: hr_utility.set_location(gv_package_name || '.select_employee', 180);
788:
789: END select_employee;
790:
791: END pay_yepp_miss_assign_pkg;