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

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

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;

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

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:

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

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:

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

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) ||

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

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:

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

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;

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

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));

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

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

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

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, '
');

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

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

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

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'

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

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:

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

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: /************************************************************

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

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

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

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);

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

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:

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

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: /* ******************************************************

Line 505: --hr_utility.trace_on(null,'rdhingra_PYUSYEMA');

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);

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

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);

Line 507: hr_utility.trace('p_payroll_action_id = ' || p_payroll_action_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:

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

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));

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

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:

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

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

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

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,

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

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

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

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 ));

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

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;

Line 558: hr_utility.trace('lv_assignment_id = ' || 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);

Line 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;

Line 565: hr_utility.trace('hhh');

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:

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

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, '');
583: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
Line 598: hr_utility.set_location(gv_package_name || '.select_employee', 60);

594: IF lv_output_file_type ='HTML' THEN
595: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
596: END IF;
597:
598: hr_utility.set_location(gv_package_name || '.select_employee', 60);
599:
600: OPEN c_assignment_set_exists(lv_assignment_set);
601: FETCH c_assignment_set_exists into lv_assignment_set_id;
602: CLOSE c_assignment_set_exists;

Line 603: hr_utility.trace('lv_assignment_set_id='||lv_assignment_set_id);

599:
600: OPEN c_assignment_set_exists(lv_assignment_set);
601: FETCH c_assignment_set_exists into lv_assignment_set_id;
602: CLOSE c_assignment_set_exists;
603: hr_utility.trace('lv_assignment_set_id='||lv_assignment_set_id);
604: /*if assignment set does not exist,create a new one*/
605: IF lv_assignment_set_id=0 THEN
606: hr_utility.trace('assignment set not exists');
607: OPEN c_assignment_set_id;

Line 606: hr_utility.trace('assignment set not exists');

602: CLOSE c_assignment_set_exists;
603: hr_utility.trace('lv_assignment_set_id='||lv_assignment_set_id);
604: /*if assignment set does not exist,create a new one*/
605: IF lv_assignment_set_id=0 THEN
606: hr_utility.trace('assignment set not exists');
607: OPEN c_assignment_set_id;
608: FETCH c_assignment_set_id into lv_assignment_set_id;
609: CLOSE c_assignment_set_id;
610: hr_assignment_sets_pkg.insert_row(row_id,

Line 617: hr_utility.trace('lv_assignment_set_id='||lv_assignment_set_id);

613: lv_payroll_id,
614: lv_assignment_set,
615: lv_formula_id);
616: lv_assign_set_created:=1;
617: hr_utility.trace('lv_assignment_set_id='||lv_assignment_set_id);
618: END IF;
619:
620: hr_utility.set_location(gv_package_name || '.select_employee', 70);
621:

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

616: lv_assign_set_created:=1;
617: hr_utility.trace('lv_assignment_set_id='||lv_assignment_set_id);
618: END IF;
619:
620: hr_utility.set_location(gv_package_name || '.select_employee', 70);
621:
622: END IF; /*lv_miss_assignments = 0 */
623:
624: IF lv_assign_set_created=0 THEN

Line 625: hr_utility.trace('assignment set newly created');

621:
622: END IF; /*lv_miss_assignments = 0 */
623:
624: IF lv_assign_set_created=0 THEN
625: hr_utility.trace('assignment set newly created');
626: hr_utility.set_location(gv_package_name || '.select_employee', 80);
627: OPEN c_assignment_amd_exists(lv_assignment_id,lv_assignment_set_id);
628: FETCH c_assignment_amd_exists into lv_assignment_amd_exists;
629: CLOSE c_assignment_amd_exists;

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

622: END IF; /*lv_miss_assignments = 0 */
623:
624: IF lv_assign_set_created=0 THEN
625: hr_utility.trace('assignment set newly created');
626: hr_utility.set_location(gv_package_name || '.select_employee', 80);
627: OPEN c_assignment_amd_exists(lv_assignment_id,lv_assignment_set_id);
628: FETCH c_assignment_amd_exists into lv_assignment_amd_exists;
629: CLOSE c_assignment_amd_exists;
630: hr_utility.trace('lv_assignment_amd_exists='||lv_assignment_amd_exists);

Line 630: hr_utility.trace('lv_assignment_amd_exists='||lv_assignment_amd_exists);

626: hr_utility.set_location(gv_package_name || '.select_employee', 80);
627: OPEN c_assignment_amd_exists(lv_assignment_id,lv_assignment_set_id);
628: FETCH c_assignment_amd_exists into lv_assignment_amd_exists;
629: CLOSE c_assignment_amd_exists;
630: hr_utility.trace('lv_assignment_amd_exists='||lv_assignment_amd_exists);
631:
632: IF lv_assignment_amd_exists=0 THEN
633: hr_utility.trace('lv_assignment_amd_exists='||lv_assignment_amd_exists);
634: /*** inserting into HR_ASSIGNMENT_SET_AMENDMENTS **/

Line 633: hr_utility.trace('lv_assignment_amd_exists='||lv_assignment_amd_exists);

629: CLOSE c_assignment_amd_exists;
630: hr_utility.trace('lv_assignment_amd_exists='||lv_assignment_amd_exists);
631:
632: IF lv_assignment_amd_exists=0 THEN
633: hr_utility.trace('lv_assignment_amd_exists='||lv_assignment_amd_exists);
634: /*** inserting into HR_ASSIGNMENT_SET_AMENDMENTS **/
635: hr_assignment_set_amds_pkg.insert_row(row_id,lv_assignment_id,lv_assignment_set_id,'I');
636: END IF;
637: ELSE

Line 638: hr_utility.trace('assignment set already exists');

634: /*** inserting into HR_ASSIGNMENT_SET_AMENDMENTS **/
635: hr_assignment_set_amds_pkg.insert_row(row_id,lv_assignment_id,lv_assignment_set_id,'I');
636: END IF;
637: ELSE
638: hr_utility.trace('assignment set already exists');
639: hr_assignment_set_amds_pkg.insert_row(row_id,lv_assignment_id,lv_assignment_set_id,'I');
640: END IF; /*lv_assign_set_created=0 */
641:
642: lv_miss_assignments := lv_miss_assignments + 1;

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

639: hr_assignment_set_amds_pkg.insert_row(row_id,lv_assignment_id,lv_assignment_set_id,'I');
640: END IF; /*lv_assign_set_created=0 */
641:
642: lv_miss_assignments := lv_miss_assignments + 1;
643: hr_utility.set_location(gv_package_name || '.select_employee', 90);
644:
645: hr_utility.trace('lv_gre_or_pre_name ='||lv_gre_or_pre_name);
646: lv_data_row := formated_detail_string(
647: lv_output_file_type

Line 645: hr_utility.trace('lv_gre_or_pre_name ='||lv_gre_or_pre_name);

641:
642: lv_miss_assignments := lv_miss_assignments + 1;
643: hr_utility.set_location(gv_package_name || '.select_employee', 90);
644:
645: hr_utility.trace('lv_gre_or_pre_name ='||lv_gre_or_pre_name);
646: lv_data_row := formated_detail_string(
647: lv_output_file_type
648: ,to_char(lv_effective_date,'YYYY')
649: ,lv_gre_or_pre_name

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

652: ,lv_emp_no);
653: IF lv_output_file_type ='HTML' THEN
654: lv_data_row := '
' || lv_data_row || '' ;
655: END IF;
656: hr_utility.set_location(gv_package_name || '.select_employee', 40);
657: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
658: hr_utility.trace('10');
659: END IF; /* lv_assignment_id IS NOT NULL */
660: END LOOP; /*loop c_get_missing_assignments */
Line 658: hr_utility.trace('10');

654: lv_data_row := '
' || lv_data_row || '' ;
655: END IF;
656: hr_utility.set_location(gv_package_name || '.select_employee', 40);
657: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
658: hr_utility.trace('10');
659: END IF; /* lv_assignment_id IS NOT NULL */
660: END LOOP; /*loop c_get_missing_assignments */
661: CLOSE c_get_missing_assignments;
662: hr_utility.set_location(gv_package_name || '.select_employee', 100);
Line 662: hr_utility.set_location(gv_package_name || '.select_employee', 100);

658: hr_utility.trace('10');
659: END IF; /* lv_assignment_id IS NOT NULL */
660: END LOOP; /*loop c_get_missing_assignments */
661: CLOSE c_get_missing_assignments;
662: hr_utility.set_location(gv_package_name || '.select_employee', 100);
663:
664: IF lv_output_file_type='HTML' THEN
665: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
666:

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

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,

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

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

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

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:

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

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

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

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

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

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 := '' || lv_element_row || '' ;
759: END IF;

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

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

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

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

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

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;