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 HR_UTILITY

Line 98: hr_utility.set_location(gv_package_name || '.formated_header_string', 10);

94: lv_format1 VARCHAR2(32000);
95:
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) ||

Line 117: hr_utility.trace('Static Label1 = ' || lv_format1);

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);
118:
119:
120: return lv_format1 ;
121:

Line 122: hr_utility.set_location(gv_package_name || '.formated_header_string', 30);

118:
119:
120: return lv_format1 ;
121:
122: hr_utility.set_location(gv_package_name || '.formated_header_string', 30);
123:
124: END formated_header_string;
125:
126:

Line 147: hr_utility.set_location(gv_package_name || '.formated_detail_string', 10);

143: lv_format1 VARCHAR2(22000);
144:
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) ||

Line 166: hr_utility.trace('Static Label1 = ' || lv_format1);

162: ,p_bold => 'N'
163: ,p_output_file_type => p_output_file_type);
164:
165:
166: hr_utility.trace('Static Label1 = ' || lv_format1);
167: return lv_format1;
168:
169: hr_utility.set_location(gv_package_name || '.formated_detail_string', 30);
170:

Line 169: hr_utility.set_location(gv_package_name || '.formated_detail_string', 30);

165:
166: hr_utility.trace('Static Label1 = ' || lv_format1);
167: return lv_format1;
168:
169: hr_utility.set_location(gv_package_name || '.formated_detail_string', 30);
170:
171:
172:
173: END formated_detail_string;

Line 188: hr_utility.set_location(gv_package_name || '.formated_zero_count', 10);

184: BEGIN
185: null;
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));

Line 193: hr_utility.set_location(gv_package_name || '.formated_zero_count', 20);

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;
195:
196: /**************************************************************************
197: Procedure to display the name of the assignment set to which the selected

Line 219: hr_utility.set_location(gv_package_name || '.formated_assign_count', 10);

215: END IF;
216: lvc_message2 := 'Assignment Set ID : ' || to_char(assignment_set_id);
217: lvc_message3 := 'Number of employees added to the assignment set : ' ||
218: to_char(record_count);
219: hr_utility.set_location(gv_package_name || '.formated_assign_count', 10);
220:
221: IF output_file_type ='HTML' THEN
222: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
223: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

Line 258: hr_utility.set_location(gv_package_name || '.formated_assign_count', 20);

254: p_bold => 'N',
255: p_output_file_type => output_file_type));
256: END IF;
257:
258: hr_utility.set_location(gv_package_name || '.formated_assign_count', 20);
259: END;
260:
261: /**************************************************************************
262: Procedure to display the Elements having input values of type Money

Line 275: hr_utility.set_location(gv_package_name || '.formated_element_header.',10);

271:
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'

Line 287: hr_utility.trace('Static Label = ' || p_static_label);

283: ,p_output_file_type=>p_output_file_type
284: ,p_bold=>'Y');
285:
286: p_static_label := lv_format;
287: hr_utility.trace('Static Label = ' || p_static_label);
288: hr_utility.set_location(gv_package_name || '.formated_element_header', 20);
289:
290: END formated_element_header;
291:

Line 288: hr_utility.set_location(gv_package_name || '.formated_element_header', 20);

284: ,p_bold=>'Y');
285:
286: p_static_label := lv_format;
287: hr_utility.trace('Static Label = ' || p_static_label);
288: hr_utility.set_location(gv_package_name || '.formated_element_header', 20);
289:
290: END formated_element_header;
291:
292: /************************************************************

Line 310: hr_utility.set_location(gv_package_name || '.formated_element_row', 10);

306: lv_format VARCHAR2(32000);
307:
308: BEGIN
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

Line 326: hr_utility.set_location(gv_package_name || '.formated_element_row', 20);

322: ,p_output_file_type=>p_output_file_type
323: ,p_bold=>'N'
324: );
325:
326: hr_utility.set_location(gv_package_name || '.formated_element_row', 20);
327:
328: p_static_data := lv_format;
329: hr_utility.trace('Static Data = ' || lv_format);
330: hr_utility.set_location(gv_package_name || '.formated_element_row', 30);

Line 329: hr_utility.trace('Static Data = ' || lv_format);

325:
326: hr_utility.set_location(gv_package_name || '.formated_element_row', 20);
327:
328: p_static_data := lv_format;
329: hr_utility.trace('Static Data = ' || lv_format);
330: hr_utility.set_location(gv_package_name || '.formated_element_row', 30);
331:
332: END formated_element_row;
333:

Line 330: hr_utility.set_location(gv_package_name || '.formated_element_row', 30);

326: hr_utility.set_location(gv_package_name || '.formated_element_row', 20);
327:
328: p_static_data := lv_format;
329: hr_utility.trace('Static Data = ' || lv_format);
330: hr_utility.set_location(gv_package_name || '.formated_element_row', 30);
331:
332: END formated_element_row;
333:
334: /* ******************************************************

Line 491: --hr_utility.trace_on(null,'PYUSYEMA');

487: lv_element_info varchar2(200);
488: lv_element_count_info varchar2(200);
489:
490: BEGIN
491: --hr_utility.trace_on(null,'PYUSYEMA');
492: hr_utility.set_location(gv_package_name || '.select_employee', 10);
493: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
494: hr_utility.trace('p_effective_date = ' || p_effective_date);
495: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);

Line 492: hr_utility.set_location(gv_package_name || '.select_employee', 10);

488: lv_element_count_info varchar2(200);
489:
490: BEGIN
491: --hr_utility.trace_on(null,'PYUSYEMA');
492: hr_utility.set_location(gv_package_name || '.select_employee', 10);
493: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
494: hr_utility.trace('p_effective_date = ' || p_effective_date);
495: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
496: hr_utility.trace('p_session_id = ' || p_session_id);

Line 493: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);

489:
490: BEGIN
491: --hr_utility.trace_on(null,'PYUSYEMA');
492: hr_utility.set_location(gv_package_name || '.select_employee', 10);
493: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
494: hr_utility.trace('p_effective_date = ' || p_effective_date);
495: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
496: hr_utility.trace('p_session_id = ' || p_session_id);
497:

Line 494: hr_utility.trace('p_effective_date = ' || p_effective_date);

490: BEGIN
491: --hr_utility.trace_on(null,'PYUSYEMA');
492: hr_utility.set_location(gv_package_name || '.select_employee', 10);
493: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
494: hr_utility.trace('p_effective_date = ' || p_effective_date);
495: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
496: hr_utility.trace('p_session_id = ' || p_session_id);
497:
498: lv_effective_date := fnd_date.canonical_to_date(FND_DATE.date_to_canonical(p_effective_date));

Line 495: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);

491: --hr_utility.trace_on(null,'PYUSYEMA');
492: hr_utility.set_location(gv_package_name || '.select_employee', 10);
493: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
494: hr_utility.trace('p_effective_date = ' || p_effective_date);
495: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
496: hr_utility.trace('p_session_id = ' || p_session_id);
497:
498: lv_effective_date := fnd_date.canonical_to_date(FND_DATE.date_to_canonical(p_effective_date));
499:

Line 496: hr_utility.trace('p_session_id = ' || p_session_id);

492: hr_utility.set_location(gv_package_name || '.select_employee', 10);
493: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_id);
494: hr_utility.trace('p_effective_date = ' || p_effective_date);
495: hr_utility.trace('p_tax_unit_id = ' || p_tax_unit_id);
496: hr_utility.trace('p_session_id = ' || p_session_id);
497:
498: lv_effective_date := fnd_date.canonical_to_date(FND_DATE.date_to_canonical(p_effective_date));
499:
500: select legislative_parameters

Line 514: hr_utility.set_location(gv_package_name || '.select_employee', 20);

510: lv_legislative_param)
511: into lv_assignment_set, lv_output_file_type
512: from dual;
513:
514: hr_utility.set_location(gv_package_name || '.select_employee', 20);
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,

Line 515: hr_utility.trace('lv_assignment_set = ' || lv_assignment_set);

511: into lv_assignment_set, lv_output_file_type
512: from dual;
513:
514: hr_utility.set_location(gv_package_name || '.select_employee', 20);
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: ' ||

Line 516: hr_utility.trace('lv_output_file_type = ' || lv_output_file_type);

512: from dual;
513:
514: hr_utility.set_location(gv_package_name || '.select_employee', 20);
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 ));

Line 531: hr_utility.set_location(gv_package_name || '.select_employee', 30);

527: fetch c_get_legislation_code into lv_legislation_code;
528: close c_get_legislation_code;
529: /* Report assignments picked up from PAY_US_RPT_TOTALS*/
530:
531: hr_utility.set_location(gv_package_name || '.select_employee', 30);
532:
533: OPEN c_get_missing_assignments(p_payroll_action_id, p_tax_unit_id);
534: LOOP
535: FETCH c_get_missing_assignments into lv_assignment_id;

Line 536: hr_utility.trace('lv_assignment_id = ' || lv_assignment_id);

532:
533: OPEN c_get_missing_assignments(p_payroll_action_id, p_tax_unit_id);
534: LOOP
535: FETCH c_get_missing_assignments into lv_assignment_id;
536: hr_utility.trace('lv_assignment_id = ' || lv_assignment_id);
537: EXIT when c_get_missing_assignments%NOTFOUND;
538:
539: lv_assignment_amd_exists:=0;
540: hr_utility.set_location(gv_package_name || '.select_employee', 40);

Line 540: hr_utility.set_location(gv_package_name || '.select_employee', 40);

536: hr_utility.trace('lv_assignment_id = ' || lv_assignment_id);
537: EXIT when c_get_missing_assignments%NOTFOUND;
538:
539: lv_assignment_amd_exists:=0;
540: hr_utility.set_location(gv_package_name || '.select_employee', 40);
541: IF lv_assignment_id IS NOT NULL THEN
542: OPEN c_gre_name(p_tax_unit_id);
543: FETCH c_gre_name into lv_gre_name;
544: CLOSE c_gre_name;

Line 555: hr_utility.set_location(gv_package_name || '.select_employee', 50);

551: FETCH c_employee_details into lv_emp_no,lv_emp_name,lv_emp_ssn;
552: CLOSE c_employee_details;
553:
554: /*create assignment set only when the first row is fetched*/
555: hr_utility.set_location(gv_package_name || '.select_employee', 50);
556: IF lv_miss_assignments=0 THEN
557: IF lv_output_file_type ='HTML' THEN
558: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
559: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
Line 570: hr_utility.set_location(gv_package_name || '.select_employee', 60);

566: IF lv_output_file_type ='HTML' THEN
567: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
568: END IF;
569:
570: hr_utility.set_location(gv_package_name || '.select_employee', 60);
571:
572: OPEN c_assignment_set_exists(lv_assignment_set);
573: FETCH c_assignment_set_exists into lv_assignment_set_id;
574: CLOSE c_assignment_set_exists;

Line 590: hr_utility.set_location(gv_package_name || '.select_employee', 70);

586: lv_formula_id);
587: lv_assign_set_created:=1;
588: END IF;
589:
590: hr_utility.set_location(gv_package_name || '.select_employee', 70);
591:
592: END IF; /*lv_miss_assignments = 0 */
593:
594: IF lv_assign_set_created=0 THEN

Line 595: hr_utility.set_location(gv_package_name || '.select_employee', 80);

591:
592: END IF; /*lv_miss_assignments = 0 */
593:
594: IF lv_assign_set_created=0 THEN
595: hr_utility.set_location(gv_package_name || '.select_employee', 80);
596: OPEN c_assignment_amd_exists(lv_assignment_id,lv_assignment_set_id);
597: FETCH c_assignment_amd_exists into lv_assignment_amd_exists;
598: CLOSE c_assignment_amd_exists;
599:

Line 608: hr_utility.set_location(gv_package_name || '.select_employee', 90);

604: hr_assignment_set_amds_pkg.insert_row(row_id,lv_assignment_id,lv_assignment_set_id,'I');
605: END IF; /*lv_assign_set_created=0 */
606:
607: lv_miss_assignments := lv_miss_assignments + 1;
608: hr_utility.set_location(gv_package_name || '.select_employee', 90);
609:
610:
611: lv_data_row := formated_detail_string(
612: lv_output_file_type

Line 621: hr_utility.set_location(gv_package_name || '.select_employee', 40);

617: ,lv_emp_no);
618: IF lv_output_file_type ='HTML' THEN
619: lv_data_row := '
' || lv_data_row || '' ;
620: END IF;
621: hr_utility.set_location(gv_package_name || '.select_employee', 40);
622: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
623:
624: END IF; /* lv_assignment_id IS NOT NULL */
625: END LOOP; /*loop c_get_missing_assignments */
Line 627: hr_utility.set_location(gv_package_name || '.select_employee', 100);

623:
624: END IF; /* lv_assignment_id IS NOT NULL */
625: END LOOP; /*loop c_get_missing_assignments */
626: CLOSE c_get_missing_assignments;
627: hr_utility.set_location(gv_package_name || '.select_employee', 100);
628:
629: IF lv_output_file_type='HTML' THEN
630: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
631:

Line 636: hr_utility.set_location(gv_package_name || '.select_employee', 110);

632: END IF;
633:
634: IF lv_miss_assignments=0 THEN
635: formated_zero_count(lv_output_file_type);
636: hr_utility.set_location(gv_package_name || '.select_employee', 110);
637: ELSE
638: formated_assign_count(lv_assignment_set,
639: lv_assignment_set_id,
640: lv_miss_assignments,

Line 643: hr_utility.set_location(gv_package_name || '.select_employee', 120);

639: lv_assignment_set_id,
640: lv_miss_assignments,
641: lv_assign_set_created,
642: lv_output_file_type);
643: hr_utility.set_location(gv_package_name || '.select_employee', 120);
644:
645: END IF;
646:
647: IF lv_output_file_type ='HTML' THEN

Line 657: hr_utility.set_location(gv_package_name || '.select_employee', 130);

653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
654:
655: COMMIT;
656: END IF;
657: hr_utility.set_location(gv_package_name || '.select_employee', 130);
658:
659: /* Code to Display Element List */
660:
661: /* Commented the code not to display the Element Information

Line 687: hr_utility.set_location(gv_package_name || '.select_employee', 140);

683: p_output_file_type => lv_output_file_type));
684: END IF;
685:
686:
687: hr_utility.set_location(gv_package_name || '.select_employee', 140);
688:
689: open c_get_elements(lv_business_group_id,
690: lv_legislation_code);
691: LOOP

Line 713: hr_utility.set_location(gv_package_name || '.select_employee', 150);

709:
710: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);
711: END IF;
712:
713: hr_utility.set_location(gv_package_name || '.select_employee', 150);
714:
715: lv_element_count := lv_element_count + 1;
716: formated_element_row(lv_element_name
717: ,lv_classification_name

Line 722: hr_utility.trace('lv_element_row = ' || lv_element_row);

718: ,lv_input_value_name
719: ,lv_output_file_type
720: ,lv_element_row);
721:
722: hr_utility.trace('lv_element_row = ' || lv_element_row);
723:
724: IF lv_output_file_type ='HTML' THEN
725: lv_element_row := '' || lv_element_row || '' ;
726: END IF;

Line 732: hr_utility.set_location(gv_package_name || '.select_employee', 160);

728: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_element_row);
729: END LOOP;
730: CLOSE c_get_elements;
731:
732: hr_utility.set_location(gv_package_name || '.select_employee', 160);
733:
734: IF lv_output_file_type='HTML' and lv_element_count > 0 THEN
735: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
736: --ELSIF lv_element_count = 0 THEN

Line 738: -- hr_utility.set_location(gv_package_name || '.select_employee', 170);

734: IF lv_output_file_type='HTML' and lv_element_count > 0 THEN
735: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
736: --ELSIF lv_element_count = 0 THEN
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

Line 754: hr_utility.set_location(gv_package_name || '.select_employee', 180);

750: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_element_count_info);
751: END IF;
752: */
753:
754: hr_utility.set_location(gv_package_name || '.select_employee', 180);
755:
756: END select_employee;
757:
758: END pay_us_yepp_miss_assign_pkg;