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.PER_PERUSHRM_XMLP_PKG dependencies on HR_UTILITY

Line 9: hr_utility.set_location('Entering.... :' || l_name,10);

5: l_name varchar2(61) := 'BEFORE_REPORT';
6:
7: begin
8: -- hr_standard.event('BEFORE REPORT');
9: hr_utility.set_location('Entering.... :' || l_name,10);
10: p_multi_state_1 := p_multi_state;
11: c_end_of_time := hr_general.end_of_time;
12:
13: c_business_group_name := hr_reports.get_business_group(p_business_group_id);

Line 33: hr_utility.set_location(l_name,20);

29: c_state_name := hr_us_reports.get_state_name
30: (p_state_code);
31: end if;
32:
33: hr_utility.set_location(l_name,20);
34:
35: --file_io.open;
36: hr_utility.set_location(l_name,30);
37: --file_io.open_a01;

Line 36: hr_utility.set_location(l_name,30);

32:
33: hr_utility.set_location(l_name,20);
34:
35: --file_io.open;
36: hr_utility.set_location(l_name,30);
37: --file_io.open_a01;
38:
39:
40: hr_utility.set_location(l_name,40);

Line 40: hr_utility.set_location(l_name,40);

36: hr_utility.set_location(l_name,30);
37: --file_io.open_a01;
38:
39:
40: hr_utility.set_location(l_name,40);
41: char_set_init('US7ASCII') ;
42:
43: if p_audit_report = 'Y' then
44: hr_utility.set_location(l_name,50);

Line 44: hr_utility.set_location(l_name,50);

40: hr_utility.set_location(l_name,40);
41: char_set_init('US7ASCII') ;
42:
43: if p_audit_report = 'Y' then
44: hr_utility.set_location(l_name,50);
45: --file_io.open_a03;
46: end if;
47:
48: hr_utility.set_location('Leaving.....:' || l_name,100);

Line 48: hr_utility.set_location('Leaving.....:' || l_name,100);

44: hr_utility.set_location(l_name,50);
45: --file_io.open_a03;
46: end if;
47:
48: hr_utility.set_location('Leaving.....:' || l_name,100);
49: return (TRUE);
50:
51: RETURN NULL; exception when no_data_found then null;
52: RETURN NULL; when others then

Line 95: hr_utility.set_location('Entered c_salary formula', 5);

91: l_salary number;
92:
93: begin
94:
95: hr_utility.set_location('Entered c_salary formula', 5);
96:
97: if p_state_code = 'TX' or p_state_code = 'OR'
98: or p_state_code = 'MD' then
99: l_business_group_id := P_BUSINESS_GROUP_ID;

Line 106: hr_utility.set_location('Leaving c_salary formula', 10);

102: l_salary := hr_us_reports.get_salary(l_business_group_id,
103: assignment_id,
104: l_report_date
105: );
106: hr_utility.set_location('Leaving c_salary formula', 10);
107: if p_state_code = 'TX' then
108: return(l_salary);
109: else
110: return(l_salary/12);

Line 113: hr_utility.set_location('Leaving c_salary formula', 15);

109: else
110: return(l_salary/12);
111: end if;
112: else
113: hr_utility.set_location('Leaving c_salary formula', 15);
114: return(NULL);
115: end if;
116:
117:

Line 134: hr_utility.set_location('Entered after report trigger',1);

130: begin
131:
132: --hr_standard.event('AFTER REPORT');
133:
134: hr_utility.set_location('Entered after report trigger',1);
135:
136:
137: if c_fatal_error_flag is null and C_NO_OF_NEWHIRE > 0 then
138: total_record() ;

Line 139: hr_utility.set_location('after report trigger',2);

135:
136:
137: if c_fatal_error_flag is null and C_NO_OF_NEWHIRE > 0 then
138: total_record() ;
139: hr_utility.set_location('after report trigger',2);
140: end if;
141: hr_utility.set_location('after report trigger',3);
142:
143: -- file_io.close;

Line 141: hr_utility.set_location('after report trigger',3);

137: if c_fatal_error_flag is null and C_NO_OF_NEWHIRE > 0 then
138: total_record() ;
139: hr_utility.set_location('after report trigger',2);
140: end if;
141: hr_utility.set_location('after report trigger',3);
142:
143: -- file_io.close;
144:
145: if c_fatal_error_flag is null then

Line 146: hr_utility.set_location('after report trigger',4);

142:
143: -- file_io.close;
144:
145: if c_fatal_error_flag is null then
146: hr_utility.set_location('after report trigger',4);
147: p_output_new_hire_null() ;
148: hr_utility.set_location('after report trigger',5);
149: p_mag_update_status() ;
150: hr_utility.set_location('after report trigger',6);

Line 148: hr_utility.set_location('after report trigger',5);

144:
145: if c_fatal_error_flag is null then
146: hr_utility.set_location('after report trigger',4);
147: p_output_new_hire_null() ;
148: hr_utility.set_location('after report trigger',5);
149: p_mag_update_status() ;
150: hr_utility.set_location('after report trigger',6);
151: end if;
152:

Line 150: hr_utility.set_location('after report trigger',6);

146: hr_utility.set_location('after report trigger',4);
147: p_output_new_hire_null() ;
148: hr_utility.set_location('after report trigger',5);
149: p_mag_update_status() ;
150: hr_utility.set_location('after report trigger',6);
151: end if;
152:
153:
154: if c_fatal_error_flag is null then

Line 161: hr_utility.set_location('after report trigger',8);

157: -- file_io.close_a01;
158:
159:
160: if p_audit_report = 'Y' then
161: hr_utility.set_location('after report trigger',8);
162: -- file_io.close_a03;
163: end if;
164: hr_utility.set_location('Leaving after report trigger',10);
165: return(TRUE);

Line 164: hr_utility.set_location('Leaving after report trigger',10);

160: if p_audit_report = 'Y' then
161: hr_utility.set_location('after report trigger',8);
162: -- file_io.close_a03;
163: end if;
164: hr_utility.set_location('Leaving after report trigger',10);
165: return(TRUE);
166: RETURN NULL; exception when others then
167: hr_utility.set_location('Error found in after report trigger',20);
168: hr_utility.trace('The error message is '||sqlerrm);

Line 167: hr_utility.set_location('Error found in after report trigger',20);

163: end if;
164: hr_utility.set_location('Leaving after report trigger',10);
165: return(TRUE);
166: RETURN NULL; exception when others then
167: hr_utility.set_location('Error found in after report trigger',20);
168: hr_utility.trace('The error message is '||sqlerrm);
169:
170: RETURN NULL; end;
171:

Line 168: hr_utility.trace('The error message is '||sqlerrm);

164: hr_utility.set_location('Leaving after report trigger',10);
165: return(TRUE);
166: RETURN NULL; exception when others then
167: hr_utility.set_location('Error found in after report trigger',20);
168: hr_utility.trace('The error message is '||sqlerrm);
169:
170: RETURN NULL; end;
171:
172: function G_new_hiresGroupFilter return boolean is

Line 183: hr_utility.set_location('Entered between page trigger',5);

179: end;
180:
181: function BetweenPage return boolean is
182: begin
183: hr_utility.set_location('Entered between page trigger',5);
184: return (TRUE);
185: end;
186:
187: function CF_new_hireFormula (SUI_COMPANY_STATE_ID in varchar2,DATE_START in date,FEDERAL_ID in varchar2,

Line 195: hr_utility.set_location('Entering... :' || l_name,10);

191: c_contact_name in varchar2,c_contact_phone in varchar2)return Number is
192: l_name varchar2(60) := 'CF_new_hireFormula';
193: begin
194:
195: hr_utility.set_location('Entering... :' || l_name,10);
196:
197: new_hire_record(person_id ,NATIONAL_IDENTIFIER ,FIRST_NAME,MIDDLE_NAME ,LAST_NAME,DATE_START,
198: FULL_MIDDLE_NAME ,gre_location_id ,DATE_OF_BIRTH ,HIRE_STATE ,FEDERAL_ID,SUI_COMPANY_STATE_ID,
199: TAX_UNIT_NAME ,c_contact_phone ,c_contact_name ,SIT_COMPANY_STATE_ID );

Line 201: hr_utility.set_location('Leaving... :' || l_name,20);

197: new_hire_record(person_id ,NATIONAL_IDENTIFIER ,FIRST_NAME,MIDDLE_NAME ,LAST_NAME,DATE_START,
198: FULL_MIDDLE_NAME ,gre_location_id ,DATE_OF_BIRTH ,HIRE_STATE ,FEDERAL_ID,SUI_COMPANY_STATE_ID,
199: TAX_UNIT_NAME ,c_contact_phone ,c_contact_name ,SIT_COMPANY_STATE_ID );
200:
201: hr_utility.set_location('Leaving... :' || l_name,20);
202:
203: return(0);
204: end;
205:

Line 253: hr_utility.set_location('Entering....' || l_name,10);

249:
250:
251: BEGIN
252:
253: hr_utility.set_location('Entering....' || l_name,10);
254: l_person_id := person_id;
255:
256:
257: if p_state_code = 'CA' then

Line 258: hr_utility.set_location(l_name,20);

254: l_person_id := person_id;
255:
256:
257: if p_state_code = 'CA' then
258: hr_utility.set_location(l_name,20);
259:
260: per_new_hire_pkg.get_employee_address
261: (l_person_id,l_address,l_city,l_state,l_zip,l_zip_extension);
262: l_buffer := per_new_hire_pkg.ca_w4_record(

Line 275: hr_utility.set_location(l_name,30);

271: ,p_zip => l_zip
272: ,p_zip_extension => l_zip_extension
273: ,p_date_of_hire => DATE_START
274: );
275: hr_utility.set_location(l_name,30);
276: c_no_of_newhire := c_no_of_newhire + 1;
277: -- file_io.put(l_buffer);
278: if p_audit_report = 'Y' then
279:

Line 294: hr_utility.set_location(l_name,35);

290: ,p_emp_zip_extension => l_zip_extension
291: ,p_date_of_hire => DATE_START
292:
293: );
294: hr_utility.set_location(l_name,35);
295: -- file_io.put_a03(l_buffer);
296: end if;
297: elsif p_state_code = 'NY' then
298: hr_utility.set_location(l_name,40);

Line 298: hr_utility.set_location(l_name,40);

294: hr_utility.set_location(l_name,35);
295: -- file_io.put_a03(l_buffer);
296: end if;
297: elsif p_state_code = 'NY' then
298: hr_utility.set_location(l_name,40);
299:
300: per_new_hire_pkg.get_employee_address
301: (l_person_id,l_address,l_city,l_state,l_zip,l_zip_extension);
302: hr_utility.trace('date_start = ' ||to_char(DATE_START));

Line 302: hr_utility.trace('date_start = ' ||to_char(DATE_START));

298: hr_utility.set_location(l_name,40);
299:
300: per_new_hire_pkg.get_employee_address
301: (l_person_id,l_address,l_city,l_state,l_zip,l_zip_extension);
302: hr_utility.trace('date_start = ' ||to_char(DATE_START));
303:
304: l_buffer := per_new_hire_pkg.ny_1h_record(
305: p_record_identifier => '1H'
306: ,p_last_name => LAST_NAME

Line 340: hr_utility.set_location(l_name,50);

336: );
337: --file_io.put_a03(l_buffer);
338: end if;
339:
340: hr_utility.set_location(l_name,50);
341: elsif p_state_code = 'FL' then
342: hr_utility.trace('p_state_code = FL');
343: l_location_id := gre_location_id;
344: per_new_hire_pkg.get_location_address_3lines

Line 342: hr_utility.trace('p_state_code = FL');

338: end if;
339:
340: hr_utility.set_location(l_name,50);
341: elsif p_state_code = 'FL' then
342: hr_utility.trace('p_state_code = FL');
343: l_location_id := gre_location_id;
344: per_new_hire_pkg.get_location_address_3lines
345: (l_location_id,l_loc_address_line1,l_loc_address_line2,l_loc_address_line3
346: ,l_loc_city,l_loc_state,l_loc_zip,l_loc_zip_extension,l_loc_country);

Line 350: hr_utility.set_location(l_name,51);

346: ,l_loc_city,l_loc_state,l_loc_zip,l_loc_zip_extension,l_loc_country);
347: per_new_hire_pkg.get_employee_address_3lines
348: (l_person_id,l_emp_address_line1,l_emp_address_line2,l_emp_address_line3
349: ,l_emp_city,l_emp_state,l_emp_zip,l_emp_zip_extension,l_emp_country);
350: hr_utility.set_location(l_name,51);
351: hr_utility.trace('p_mult_state = ' || p_multi_state_1);
352: hr_utility.trace('l_loc_state = ' || l_loc_state);
353: l_buffer := per_new_hire_pkg.fl_new_hire_record(
354: p_record_identifier => 'FL Newhire Record'

Line 351: hr_utility.trace('p_mult_state = ' || p_multi_state_1);

347: per_new_hire_pkg.get_employee_address_3lines
348: (l_person_id,l_emp_address_line1,l_emp_address_line2,l_emp_address_line3
349: ,l_emp_city,l_emp_state,l_emp_zip,l_emp_zip_extension,l_emp_country);
350: hr_utility.set_location(l_name,51);
351: hr_utility.trace('p_mult_state = ' || p_multi_state_1);
352: hr_utility.trace('l_loc_state = ' || l_loc_state);
353: l_buffer := per_new_hire_pkg.fl_new_hire_record(
354: p_record_identifier => 'FL Newhire Record'
355: ,p_national_identifier => NATIONAL_IDENTIFIER

Line 352: hr_utility.trace('l_loc_state = ' || l_loc_state);

348: (l_person_id,l_emp_address_line1,l_emp_address_line2,l_emp_address_line3
349: ,l_emp_city,l_emp_state,l_emp_zip,l_emp_zip_extension,l_emp_country);
350: hr_utility.set_location(l_name,51);
351: hr_utility.trace('p_mult_state = ' || p_multi_state_1);
352: hr_utility.trace('l_loc_state = ' || l_loc_state);
353: l_buffer := per_new_hire_pkg.fl_new_hire_record(
354: p_record_identifier => 'FL Newhire Record'
355: ,p_national_identifier => NATIONAL_IDENTIFIER
356: ,p_first_name => FIRST_NAME

Line 499: hr_utility.trace('gre_location_id = ' || l_location_id);

495: -- file_io.put_a03(l_buffer);
496: end if;
497: elsif p_state_code = 'TX' then
498: l_location_id := gre_location_id;
499: hr_utility.trace('gre_location_id = ' || l_location_id);
500: per_new_hire_pkg.get_location_address_3lines
501: (l_location_id,l_loc_address_line1,l_loc_address_line2,l_loc_address_line3
502: ,l_loc_city,l_loc_state,l_loc_zip,l_loc_zip_extension,l_loc_country);
503: per_new_hire_pkg.get_employee_address_3lines

Line 586: hr_utility.set_location('Leaving...' || l_name,100);

582: );
583: -- file_io.put_a03(l_buffer);
584: end if;
585: end if;
586: hr_utility.set_location('Leaving...' || l_name,100);
587: exception when others then
588: hr_utility.set_location('Leaving....' || l_name,999);
589: c_fatal_error_flag := 7;
590: /*srw.message(288, 'Error found in ' || l_name);*/null;

Line 588: hr_utility.set_location('Leaving....' || l_name,999);

584: end if;
585: end if;
586: hr_utility.set_location('Leaving...' || l_name,100);
587: exception when others then
588: hr_utility.set_location('Leaving....' || l_name,999);
589: c_fatal_error_flag := 7;
590: /*srw.message(288, 'Error found in ' || l_name);*/null;
591:
592: fnd_message.raise_error;

Line 600: hr_utility.set_location('Entering.....:' || l_name,10);

596: l_buffer varchar2(2000);
597: l_name varchar(60) := 'TOTAL_RECORD';
598: BEGIN
599:
600: hr_utility.set_location('Entering.....:' || l_name,10);
601: if p_state_code = 'CA' then
602: l_buffer := per_new_hire_pkg.ca_t4_record(
603: p_record_identifier => 'T4'
604: ,p_number_of_employee => C_NO_OF_NEWHIRE

Line 607: hr_utility.trace('l_buffer = ' || l_buffer);

603: p_record_identifier => 'T4'
604: ,p_number_of_employee => C_NO_OF_NEWHIRE
605: );
606:
607: hr_utility.trace('l_buffer = ' || l_buffer);
608: --file_io.put(l_buffer);
609: elsif p_state_code = 'NY' then
610: l_buffer := per_new_hire_pkg.ny_1t_record(
611: p_record_identifier => '1T'

Line 615: hr_utility.trace('l_buffer = ' || l_buffer);

611: p_record_identifier => '1T'
612: ,p_number_of_employee => C_NO_OF_NEWHIRE
613: );
614:
615: hr_utility.trace('l_buffer = ' || l_buffer);
616: --file_io.put(l_buffer);
617: l_buffer := per_new_hire_pkg.ny_1f_record(
618: p_record_identifier => '1F'
619: ,p_number_of_employer => c_no_of_gre

Line 622: hr_utility.trace('l_buffer = ' || l_buffer);

618: p_record_identifier => '1F'
619: ,p_number_of_employer => c_no_of_gre
620: );
621:
622: hr_utility.trace('l_buffer = ' || l_buffer);
623: --file_io.put(l_buffer);
624:
625: end if;
626: hr_utility.set_location('Leaving.....:' || l_name,100);

Line 626: hr_utility.set_location('Leaving.....:' || l_name,100);

622: hr_utility.trace('l_buffer = ' || l_buffer);
623: --file_io.put(l_buffer);
624:
625: end if;
626: hr_utility.set_location('Leaving.....:' || l_name,100);
627: exception when others then
628: hr_utility.set_location('Leaving....' || l_name,999);
629: c_fatal_error_flag := 9;
630: /*srw.message(288, 'Error found in ' || l_name);*/null;

Line 628: hr_utility.set_location('Leaving....' || l_name,999);

624:
625: end if;
626: hr_utility.set_location('Leaving.....:' || l_name,100);
627: exception when others then
628: hr_utility.set_location('Leaving....' || l_name,999);
629: c_fatal_error_flag := 9;
630: /*srw.message(288, 'Error found in ' || l_name);*/null;
631:
632:

Line 661: hr_utility.set_location('Entering....' || l_name,10);

657: and hou.organization_id = TAX_UNIT_ID;
658:
659: BEGIN
660:
661: hr_utility.set_location('Entering....' || l_name,10);
662: hr_utility.trace('p_tax_unit_id = ' || to_char(P_TAX_UNIT_ID));
663: hr_utility.trace('p_business_group_id = ' || to_char(P_BUSINESS_GROUP_ID));
664:
665: open c_tax_unit_name;

Line 662: hr_utility.trace('p_tax_unit_id = ' || to_char(P_TAX_UNIT_ID));

658:
659: BEGIN
660:
661: hr_utility.set_location('Entering....' || l_name,10);
662: hr_utility.trace('p_tax_unit_id = ' || to_char(P_TAX_UNIT_ID));
663: hr_utility.trace('p_business_group_id = ' || to_char(P_BUSINESS_GROUP_ID));
664:
665: open c_tax_unit_name;
666: fetch c_tax_unit_name into l_tax_unit_name,l_location_id;

Line 663: hr_utility.trace('p_business_group_id = ' || to_char(P_BUSINESS_GROUP_ID));

659: BEGIN
660:
661: hr_utility.set_location('Entering....' || l_name,10);
662: hr_utility.trace('p_tax_unit_id = ' || to_char(P_TAX_UNIT_ID));
663: hr_utility.trace('p_business_group_id = ' || to_char(P_BUSINESS_GROUP_ID));
664:
665: open c_tax_unit_name;
666: fetch c_tax_unit_name into l_tax_unit_name,l_location_id;
667: close c_tax_unit_name;

Line 669: hr_utility.trace('location_id = ' || to_char(l_location_id));

665: open c_tax_unit_name;
666: fetch c_tax_unit_name into l_tax_unit_name,l_location_id;
667: close c_tax_unit_name;
668:
669: hr_utility.trace('location_id = ' || to_char(l_location_id));
670: per_new_hire_pkg.get_location_address_3lines
671: (l_location_id,l_loc_address_line1,l_loc_address_line2,l_loc_address_line3
672: ,l_loc_city,l_loc_state,l_loc_zip,l_loc_zip_extension,l_loc_country);
673:

Line 694: hr_utility.set_location('Leaving....' || l_name,100);

690: else
691: file_io.put_a01('zip : ' || l_loc_zip || '-' || l_loc_zip_extension || g_delimiter);
692: end if;
693: file_io.put_a01(g_delimiter); */
694: hr_utility.set_location('Leaving....' || l_name,100);
695:
696: exception when others then
697: hr_utility.set_location('Leaving....' || l_name,999);
698: c_fatal_error_flag := 3;

Line 697: hr_utility.set_location('Leaving....' || l_name,999);

693: file_io.put_a01(g_delimiter); */
694: hr_utility.set_location('Leaving....' || l_name,100);
695:
696: exception when others then
697: hr_utility.set_location('Leaving....' || l_name,999);
698: c_fatal_error_flag := 3;
699: /*srw.message(288, 'Error found in ' || l_name);*/null;
700:
701:

Line 712: hr_utility.set_location('Entering....' || l_name,10);

708:
709:
710: BEGIN
711:
712: hr_utility.set_location('Entering....' || l_name,10);
713: l_total_number := CS_NO_OF_NEW_HIRE ;
714: -- file_io.put_a01('All state new hire reported Totals : ' || l_total_number);
715: hr_utility.set_location('Leaving....' || l_name,100);
716: END;

Line 715: hr_utility.set_location('Leaving....' || l_name,100);

711:
712: hr_utility.set_location('Entering....' || l_name,10);
713: l_total_number := CS_NO_OF_NEW_HIRE ;
714: -- file_io.put_a01('All state new hire reported Totals : ' || l_total_number);
715: hr_utility.set_location('Leaving....' || l_name,100);
716: END;
717:
718: PROCEDURE A03_HEADER_RECORD IS
719: l_name varchar(60) := 'a03_header_record';

Line 724: hr_utility.set_location('Entering....' || l_name,10);

720: l_buffer varchar2(2000);
721:
722: BEGIN
723:
724: hr_utility.set_location('Entering....' || l_name,10);
725: if p_state_code = 'CA' then
726: l_buffer := per_new_hire_pkg.a03_ca_new_hire_header;
727: elsif p_state_code = 'NY' then
728: l_buffer := per_new_hire_pkg.a03_ny_new_hire_header;

Line 736: hr_utility.set_location('Entering....' || l_name,20);

732: l_buffer := per_new_hire_pkg.a03_fl_new_hire_header;
733: elsif p_state_code = 'TX' then
734: l_buffer := per_new_hire_pkg.a03_tx_new_hire_header;
735: end if;
736: hr_utility.set_location('Entering....' || l_name,20);
737:
738: -- file_io.put_a03(l_buffer);
739:
740: hr_utility.set_location('Leaving....' || l_name,100);

Line 740: hr_utility.set_location('Leaving....' || l_name,100);

736: hr_utility.set_location('Entering....' || l_name,20);
737:
738: -- file_io.put_a03(l_buffer);
739:
740: hr_utility.set_location('Leaving....' || l_name,100);
741: exception when others then
742: hr_utility.set_location('Leaving....' || l_name,999);
743: c_fatal_error_flag := 4;
744: /*srw.message(288, 'Error found in ' || l_name);*/null;

Line 742: hr_utility.set_location('Leaving....' || l_name,999);

738: -- file_io.put_a03(l_buffer);
739:
740: hr_utility.set_location('Leaving....' || l_name,100);
741: exception when others then
742: hr_utility.set_location('Leaving....' || l_name,999);
743: c_fatal_error_flag := 4;
744: /*srw.message(288, 'Error found in ' || l_name);*/null;
745:
746: END;

Line 875: hr_utility.set_location('Entered ......:' || l_name,10);

871: l_name varchar(60) := 'P_MAG_UPDATE_STATUS';
872: g_delimiter varchar2(1) := fnd_global.local_chr(10);
873:
874: BEGIN
875: hr_utility.set_location('Entered ......:' || l_name,10);
876: if c_person_id%ISOPEN then
877: close c_person_id;
878: end if;
879: OPEN c_person_id;

Line 884: hr_utility.trace('v_person_id = ' || to_char(v_person_id));

880: LOOP
881:
882: FETCH c_person_id INTO v_person_id, v_last_name, v_first_name, v_state;
883:
884: hr_utility.trace('v_person_id = ' || to_char(v_person_id));
885: hr_utility.trace('v_state = ' || v_state);
886:
887: if p_report_mode = 'F' then
888: UPDATE per_people_f

Line 885: hr_utility.trace('v_state = ' || v_state);

881:
882: FETCH c_person_id INTO v_person_id, v_last_name, v_first_name, v_state;
883:
884: hr_utility.trace('v_person_id = ' || to_char(v_person_id));
885: hr_utility.trace('v_state = ' || v_state);
886:
887: if p_report_mode = 'F' then
888: UPDATE per_people_f
889: SET per_information7 = 'DONE'

Line 895: hr_utility.trace('c_old_state = ' || c_old_state);

891: AND per_information7 = 'INCL';
892: end if;
893:
894:
895: hr_utility.trace('c_old_state = ' || c_old_state);
896: if c_old_state is NULL then
897: hr_utility.set_location(l_name,20);
898: c_old_state := v_state;
899: c_state_count := 1;

Line 897: hr_utility.set_location(l_name,20);

893:
894:
895: hr_utility.trace('c_old_state = ' || c_old_state);
896: if c_old_state is NULL then
897: hr_utility.set_location(l_name,20);
898: c_old_state := v_state;
899: c_state_count := 1;
900: elsif c_old_state <> v_state then
901: hr_utility.set_location(l_name,30);

Line 901: hr_utility.set_location(l_name,30);

897: hr_utility.set_location(l_name,20);
898: c_old_state := v_state;
899: c_state_count := 1;
900: elsif c_old_state <> v_state then
901: hr_utility.set_location(l_name,30);
902: -- file_io.put_a01(c_old_state || ' state new hire reported Totals : ' || c_state_count || g_delimiter);
903: c_state_count := 1;
904: c_old_state := v_state;
905: else

Line 906: hr_utility.set_location(l_name,40);

902: -- file_io.put_a01(c_old_state || ' state new hire reported Totals : ' || c_state_count || g_delimiter);
903: c_state_count := 1;
904: c_old_state := v_state;
905: else
906: hr_utility.set_location(l_name,40);
907: c_state_count := c_state_count + 1;
908: hr_utility.trace('c_state_count =' || c_state_count);
909: end if;
910:

Line 908: hr_utility.trace('c_state_count =' || c_state_count);

904: c_old_state := v_state;
905: else
906: hr_utility.set_location(l_name,40);
907: c_state_count := c_state_count + 1;
908: hr_utility.trace('c_state_count =' || c_state_count);
909: end if;
910:
911: EXIT WHEN c_person_id%NOTFOUND;
912:

Line 915: hr_utility.set_location(l_name,50);

911: EXIT WHEN c_person_id%NOTFOUND;
912:
913: END LOOP;
914:
915: hr_utility.set_location(l_name,50);
916:
917: c_state_count := c_state_count - 1;
918: if c_state_count <> 0 then
919: -- file_io.put_a01(c_old_state || ' state new hire reported Totals : ' || c_state_count || g_delimiter);

Line 922: hr_utility.set_location(l_name,60);

918: if c_state_count <> 0 then
919: -- file_io.put_a01(c_old_state || ' state new hire reported Totals : ' || c_state_count || g_delimiter);
920: null;
921: end if;
922: hr_utility.set_location(l_name,60);
923: CLOSE c_person_id;
924: COMMIT;
925: hr_utility.set_location(l_name,90);
926:

Line 925: hr_utility.set_location(l_name,90);

921: end if;
922: hr_utility.set_location(l_name,60);
923: CLOSE c_person_id;
924: COMMIT;
925: hr_utility.set_location(l_name,90);
926:
927: /*srw.message('101', 'Report Mode : ' || p_report_mode);*/null;
928:
929: if p_report_mode = 'F' then

Line 935: hr_utility.set_location('Leaving....' || l_name,100);

931:
932: end if;
933: /*srw.message('102', 'Called Status Update');*/null;
934:
935: hr_utility.set_location('Leaving....' || l_name,100);
936: exception
937: when others then
938: /*srw.message(290, 'The error message is '||sqlerrm);*/null;
939:

Line 953: hr_utility.set_location('Entering...' || l_name,0);

949: l_buffer varchar2(1000);
950: g_delimiter varchar2(1) := fnd_global.local_chr(10);
951: begin
952:
953: hr_utility.set_location('Entering...' || l_name,0);
954: hr_utility.trace('p_audit_report = ' || p_audit_report);
955: hr_utility.trace('p_state_code = ' || p_state_code);
956:
957: hr_utility.set_location(l_name,20);

Line 954: hr_utility.trace('p_audit_report = ' || p_audit_report);

950: g_delimiter varchar2(1) := fnd_global.local_chr(10);
951: begin
952:
953: hr_utility.set_location('Entering...' || l_name,0);
954: hr_utility.trace('p_audit_report = ' || p_audit_report);
955: hr_utility.trace('p_state_code = ' || p_state_code);
956:
957: hr_utility.set_location(l_name,20);
958: gre_record(gre_location_id,tax_unit_id,FEDERAL_ID,SIT_COMPANY_STATE_ID,TAX_UNIT_NAME) ;

Line 955: hr_utility.trace('p_state_code = ' || p_state_code);

951: begin
952:
953: hr_utility.set_location('Entering...' || l_name,0);
954: hr_utility.trace('p_audit_report = ' || p_audit_report);
955: hr_utility.trace('p_state_code = ' || p_state_code);
956:
957: hr_utility.set_location(l_name,20);
958: gre_record(gre_location_id,tax_unit_id,FEDERAL_ID,SIT_COMPANY_STATE_ID,TAX_UNIT_NAME) ;
959: hr_utility.set_location(l_name,30);

Line 957: hr_utility.set_location(l_name,20);

953: hr_utility.set_location('Entering...' || l_name,0);
954: hr_utility.trace('p_audit_report = ' || p_audit_report);
955: hr_utility.trace('p_state_code = ' || p_state_code);
956:
957: hr_utility.set_location(l_name,20);
958: gre_record(gre_location_id,tax_unit_id,FEDERAL_ID,SIT_COMPANY_STATE_ID,TAX_UNIT_NAME) ;
959: hr_utility.set_location(l_name,30);
960:
961:

Line 959: hr_utility.set_location(l_name,30);

955: hr_utility.trace('p_state_code = ' || p_state_code);
956:
957: hr_utility.set_location(l_name,20);
958: gre_record(gre_location_id,tax_unit_id,FEDERAL_ID,SIT_COMPANY_STATE_ID,TAX_UNIT_NAME) ;
959: hr_utility.set_location(l_name,30);
960:
961:
962: hr_utility.set_location('Leaving....:' || l_name,100);
963: return(0);

Line 962: hr_utility.set_location('Leaving....:' || l_name,100);

958: gre_record(gre_location_id,tax_unit_id,FEDERAL_ID,SIT_COMPANY_STATE_ID,TAX_UNIT_NAME) ;
959: hr_utility.set_location(l_name,30);
960:
961:
962: hr_utility.set_location('Leaving....:' || l_name,100);
963: return(0);
964:
965: end;
966:

Line 994: hr_utility.set_location('Entered c_person_dets',5);

990: l_contact_title,
991: l_contact_phone
992: );
993:
994: hr_utility.set_location('Entered c_person_dets',5);
995:
996:
997: hr_utility.trace('Contact name => '||l_contact_name);
998: hr_utility.set_location('Leaving c_contact_name', 10);

Line 997: hr_utility.trace('Contact name => '||l_contact_name);

993:
994: hr_utility.set_location('Entered c_person_dets',5);
995:
996:
997: hr_utility.trace('Contact name => '||l_contact_name);
998: hr_utility.set_location('Leaving c_contact_name', 10);
999:
1000: return(l_contact_name);
1001:

Line 998: hr_utility.set_location('Leaving c_contact_name', 10);

994: hr_utility.set_location('Entered c_person_dets',5);
995:
996:
997: hr_utility.trace('Contact name => '||l_contact_name);
998: hr_utility.set_location('Leaving c_contact_name', 10);
999:
1000: return(l_contact_name);
1001:
1002: exception when NO_DATA_FOUND then

Line 1003: hr_utility.trace('Error is found in c_contact_name');

999:
1000: return(l_contact_name);
1001:
1002: exception when NO_DATA_FOUND then
1003: hr_utility.trace('Error is found in c_contact_name');
1004: null;
1005:
1006: end;
1007:

Line 1038: hr_utility.set_location('Entered c_contact_phone',5);

1034: l_contact_title,
1035: l_contact_phone
1036: );
1037:
1038: hr_utility.set_location('Entered c_contact_phone',5);
1039:
1040:
1041: hr_utility.trace('Contact phone => '||l_contact_phone);
1042: hr_utility.set_location('Leaving c_contact_phone', 10);

Line 1041: hr_utility.trace('Contact phone => '||l_contact_phone);

1037:
1038: hr_utility.set_location('Entered c_contact_phone',5);
1039:
1040:
1041: hr_utility.trace('Contact phone => '||l_contact_phone);
1042: hr_utility.set_location('Leaving c_contact_phone', 10);
1043:
1044: return(l_contact_phone);
1045:

Line 1042: hr_utility.set_location('Leaving c_contact_phone', 10);

1038: hr_utility.set_location('Entered c_contact_phone',5);
1039:
1040:
1041: hr_utility.trace('Contact phone => '||l_contact_phone);
1042: hr_utility.set_location('Leaving c_contact_phone', 10);
1043:
1044: return(l_contact_phone);
1045:
1046: exception when NO_DATA_FOUND then

Line 1047: hr_utility.trace('Error is found in c_contact_phone');

1043:
1044: return(l_contact_phone);
1045:
1046: exception when NO_DATA_FOUND then
1047: hr_utility.trace('Error is found in c_contact_phone');
1048: null;
1049:
1050: end;
1051:

Line 1081: hr_utility.set_location('Entered c_contact_title',5);

1077: l_contact_title,
1078: l_contact_phone
1079: );
1080:
1081: hr_utility.set_location('Entered c_contact_title',5);
1082:
1083:
1084: hr_utility.trace('Contact title => '||l_contact_title);
1085: hr_utility.set_location('Leaving c_contact_title',10);

Line 1084: hr_utility.trace('Contact title => '||l_contact_title);

1080:
1081: hr_utility.set_location('Entered c_contact_title',5);
1082:
1083:
1084: hr_utility.trace('Contact title => '||l_contact_title);
1085: hr_utility.set_location('Leaving c_contact_title',10);
1086:
1087: return(l_contact_title);
1088:

Line 1085: hr_utility.set_location('Leaving c_contact_title',10);

1081: hr_utility.set_location('Entered c_contact_title',5);
1082:
1083:
1084: hr_utility.trace('Contact title => '||l_contact_title);
1085: hr_utility.set_location('Leaving c_contact_title',10);
1086:
1087: return(l_contact_title);
1088:
1089: exception when NO_DATA_FOUND then

Line 1090: hr_utility.trace('Error is found in c_contact_title');

1086:
1087: return(l_contact_title);
1088:
1089: exception when NO_DATA_FOUND then
1090: hr_utility.trace('Error is found in c_contact_title');
1091: null;
1092:
1093: end;
1094:

Line 1112: hr_utility.trace('the error is '|| to_char(sqlcode)||sqlerrm);

1108: return(l_tax_unit_address);
1109:
1110: exception
1111: when others then
1112: hr_utility.trace('the error is '|| to_char(sqlcode)||sqlerrm);
1113: /*srw.message('1','Error is found in tax_unit_address formula');*/null;
1114:
1115: /*srw.message('10','sqlcode is : '||to_char(sqlcode)||sqlerrm);*/null;
1116:

Line 1298: hr_utility.set_location('Entering.. ' || l_name,10);

1294:
1295:
1296:
1297: BEGIN
1298: hr_utility.set_location('Entering.. ' || l_name,10);
1299: l_location_id := gre_location_id;
1300: hr_utility.trace('l_location_id = ' || l_location_id);
1301: hr_utility.set_location(l_name,20);
1302: hr_utility.trace('p_state_code = ' || p_state_code);

Line 1300: hr_utility.trace('l_location_id = ' || l_location_id);

1296:
1297: BEGIN
1298: hr_utility.set_location('Entering.. ' || l_name,10);
1299: l_location_id := gre_location_id;
1300: hr_utility.trace('l_location_id = ' || l_location_id);
1301: hr_utility.set_location(l_name,20);
1302: hr_utility.trace('p_state_code = ' || p_state_code);
1303:
1304: if p_state_code = 'CA' then

Line 1301: hr_utility.set_location(l_name,20);

1297: BEGIN
1298: hr_utility.set_location('Entering.. ' || l_name,10);
1299: l_location_id := gre_location_id;
1300: hr_utility.trace('l_location_id = ' || l_location_id);
1301: hr_utility.set_location(l_name,20);
1302: hr_utility.trace('p_state_code = ' || p_state_code);
1303:
1304: if p_state_code = 'CA' then
1305: hr_utility.set_location(l_name,30);

Line 1302: hr_utility.trace('p_state_code = ' || p_state_code);

1298: hr_utility.set_location('Entering.. ' || l_name,10);
1299: l_location_id := gre_location_id;
1300: hr_utility.trace('l_location_id = ' || l_location_id);
1301: hr_utility.set_location(l_name,20);
1302: hr_utility.trace('p_state_code = ' || p_state_code);
1303:
1304: if p_state_code = 'CA' then
1305: hr_utility.set_location(l_name,30);
1306: hr_utility.trace('cp_pre_tax_unit_id = ' || cp_pre_tax_unit_id);

Line 1305: hr_utility.set_location(l_name,30);

1301: hr_utility.set_location(l_name,20);
1302: hr_utility.trace('p_state_code = ' || p_state_code);
1303:
1304: if p_state_code = 'CA' then
1305: hr_utility.set_location(l_name,30);
1306: hr_utility.trace('cp_pre_tax_unit_id = ' || cp_pre_tax_unit_id);
1307: hr_utility.trace('tax_unit_id = ' || tax_unit_id);
1308:
1309: per_new_hire_pkg.get_location_address

Line 1306: hr_utility.trace('cp_pre_tax_unit_id = ' || cp_pre_tax_unit_id);

1302: hr_utility.trace('p_state_code = ' || p_state_code);
1303:
1304: if p_state_code = 'CA' then
1305: hr_utility.set_location(l_name,30);
1306: hr_utility.trace('cp_pre_tax_unit_id = ' || cp_pre_tax_unit_id);
1307: hr_utility.trace('tax_unit_id = ' || tax_unit_id);
1308:
1309: per_new_hire_pkg.get_location_address
1310: (l_location_id,l_address,l_city,l_state,l_zip,l_zip_extension);

Line 1307: hr_utility.trace('tax_unit_id = ' || tax_unit_id);

1303:
1304: if p_state_code = 'CA' then
1305: hr_utility.set_location(l_name,30);
1306: hr_utility.trace('cp_pre_tax_unit_id = ' || cp_pre_tax_unit_id);
1307: hr_utility.trace('tax_unit_id = ' || tax_unit_id);
1308:
1309: per_new_hire_pkg.get_location_address
1310: (l_location_id,l_address,l_city,l_state,l_zip,l_zip_extension);
1311:

Line 1327: hr_utility.trace('l_buffer = ' || l_buffer);

1323: ,p_state => l_state
1324: ,p_zip => l_zip
1325: ,p_zip_extension => l_zip_extension
1326: );
1327: hr_utility.trace('l_buffer = ' || l_buffer);
1328: --file_io.put(l_buffer);
1329: cp_pre_tax_unit_id := tax_unit_id;
1330: c_no_of_newhire := 0;
1331: c_no_of_gre := c_no_of_gre + 1;

Line 1338: hr_utility.trace('l_buffer = ' || l_buffer);

1334: p_record_identifier => 'T4'
1335: ,p_number_of_employee => C_NO_OF_NEWHIRE
1336: );
1337:
1338: hr_utility.trace('l_buffer = ' || l_buffer);
1339: --file_io.put(l_buffer);
1340:
1341: a01_header_record(TAX_UNIT_ID,federal_id) ;
1342:

Line 1355: hr_utility.trace('l_buffer = ' || l_buffer);

1351: ,p_state => l_state
1352: ,p_zip => l_zip
1353: ,p_zip_extension => l_zip_extension
1354: );
1355: hr_utility.trace('l_buffer = ' || l_buffer);
1356: --file_io.put(l_buffer);
1357: cp_pre_tax_unit_id := tax_unit_id;
1358: c_no_of_newhire := 0;
1359: c_no_of_gre := c_no_of_gre + 1;

Line 1363: hr_utility.set_location(l_name,40);

1359: c_no_of_gre := c_no_of_gre + 1;
1360: end if;
1361:
1362: elsif p_state_code = 'NY' then
1363: hr_utility.set_location(l_name,40);
1364: hr_utility.trace('p_report_date = ' || p_report_date);
1365: per_new_hire_pkg.get_location_address
1366: (l_location_id,l_address,l_city,l_state,l_zip,l_zip_extension);
1367:

Line 1364: hr_utility.trace('p_report_date = ' || p_report_date);

1360: end if;
1361:
1362: elsif p_state_code = 'NY' then
1363: hr_utility.set_location(l_name,40);
1364: hr_utility.trace('p_report_date = ' || p_report_date);
1365: per_new_hire_pkg.get_location_address
1366: (l_location_id,l_address,l_city,l_state,l_zip,l_zip_extension);
1367:
1368: if cp_pre_tax_unit_id is NULL then

Line 1369: hr_utility.set_location(l_name,41);

1365: per_new_hire_pkg.get_location_address
1366: (l_location_id,l_address,l_city,l_state,l_zip,l_zip_extension);
1367:
1368: if cp_pre_tax_unit_id is NULL then
1369: hr_utility.set_location(l_name,41);
1370: open c_transmitter;
1371: fetch c_transmitter into l_trans_tax_unit_name,l_trans_federal_id,
1372: l_trans_tax_unit_id,l_trans_location_id;
1373: if c_transmitter%NOTFOUND then

Line 1374: hr_utility.set_location(l_name,42);

1370: open c_transmitter;
1371: fetch c_transmitter into l_trans_tax_unit_name,l_trans_federal_id,
1372: l_trans_tax_unit_id,l_trans_location_id;
1373: if c_transmitter%NOTFOUND then
1374: hr_utility.set_location(l_name,42);
1375: close c_transmitter;
1376: /*srw.message('100', 'You have selected New York to be your reporting state, but have not identified a GRE as the transmitter for the New Hire report.');*/null;
1377:
1378: /*srw.message('100', 'Please select one of your GREs as the transmitter for this report in the New Hire Reporting organization information type.');*/null;

Line 1385: hr_utility.trace('transmitter count = ' || to_char(l_transmitter_count));

1381: fnd_message.raise_error;
1382: else
1383: open c_transmitter_count;
1384: fetch c_transmitter_count into l_transmitter_count;
1385: hr_utility.trace('transmitter count = ' || to_char(l_transmitter_count));
1386: if l_transmitter_count > 1 then
1387: hr_utility.set_location(l_name,43);
1388: close c_transmitter_count;
1389: close c_transmitter;

Line 1387: hr_utility.set_location(l_name,43);

1383: open c_transmitter_count;
1384: fetch c_transmitter_count into l_transmitter_count;
1385: hr_utility.trace('transmitter count = ' || to_char(l_transmitter_count));
1386: if l_transmitter_count > 1 then
1387: hr_utility.set_location(l_name,43);
1388: close c_transmitter_count;
1389: close c_transmitter;
1390: c_fatal_error_flag := 2;
1391: /*srw.message('100', 'You have selected New York to be your reporting state, and have identified two GREs as the transmitter for the New Hire report.');*/null;

Line 1400: hr_utility.trace('transmitter_tax_unit_name = ' || l_trans_tax_unit_name);

1396: end if;
1397: close c_transmitter_count;
1398: end if;
1399: close c_transmitter;
1400: hr_utility.trace('transmitter_tax_unit_name = ' || l_trans_tax_unit_name);
1401: hr_utility.trace('transmitter_federal_id = ' || l_trans_federal_id);
1402: hr_utility.trace('transmitter_location_id = ' || to_char(l_trans_location_id));
1403:
1404: per_new_hire_pkg.get_location_address

Line 1401: hr_utility.trace('transmitter_federal_id = ' || l_trans_federal_id);

1397: close c_transmitter_count;
1398: end if;
1399: close c_transmitter;
1400: hr_utility.trace('transmitter_tax_unit_name = ' || l_trans_tax_unit_name);
1401: hr_utility.trace('transmitter_federal_id = ' || l_trans_federal_id);
1402: hr_utility.trace('transmitter_location_id = ' || to_char(l_trans_location_id));
1403:
1404: per_new_hire_pkg.get_location_address
1405: (l_trans_location_id,l_trans_address

Line 1402: hr_utility.trace('transmitter_location_id = ' || to_char(l_trans_location_id));

1398: end if;
1399: close c_transmitter;
1400: hr_utility.trace('transmitter_tax_unit_name = ' || l_trans_tax_unit_name);
1401: hr_utility.trace('transmitter_federal_id = ' || l_trans_federal_id);
1402: hr_utility.trace('transmitter_location_id = ' || to_char(l_trans_location_id));
1403:
1404: per_new_hire_pkg.get_location_address
1405: (l_trans_location_id,l_trans_address
1406: ,l_trans_city,l_trans_state,l_trans_zip,l_trans_zip_extension);

Line 1420: hr_utility.set_location(l_name,42);

1416: ,p_state => l_trans_state
1417: ,p_zip => l_trans_zip
1418: );
1419:
1420: hr_utility.set_location(l_name,42);
1421: /*file_io.put(l_buffer);
1422:
1423: file_io.put_a01('Transmitter Record' || g_delimiter);
1424: file_io.put_a01(g_delimiter);

Line 1448: hr_utility.set_location(l_name,45);

1444: ,p_city => l_city
1445: ,p_state => l_state
1446: ,p_zip => l_zip
1447: );
1448: hr_utility.set_location(l_name,45);
1449: hr_utility.trace('l_buffer = ' || l_buffer);
1450: -- file_io.put(l_buffer);
1451: cp_pre_tax_unit_id := tax_unit_id;
1452: c_no_of_newhire := 0;

Line 1449: hr_utility.trace('l_buffer = ' || l_buffer);

1445: ,p_state => l_state
1446: ,p_zip => l_zip
1447: );
1448: hr_utility.set_location(l_name,45);
1449: hr_utility.trace('l_buffer = ' || l_buffer);
1450: -- file_io.put(l_buffer);
1451: cp_pre_tax_unit_id := tax_unit_id;
1452: c_no_of_newhire := 0;
1453: c_no_of_gre := 1;

Line 1456: hr_utility.set_location(l_name,50);

1452: c_no_of_newhire := 0;
1453: c_no_of_gre := 1;
1454:
1455: elsif cp_pre_tax_unit_id <> tax_unit_id then
1456: hr_utility.set_location(l_name,50);
1457:
1458: a01_header_record(TAX_UNIT_ID,federal_id) ;
1459:
1460: l_buffer := per_new_hire_pkg.ny_1t_record(

Line 1465: hr_utility.trace('l_buffer = ' || l_buffer);

1461: p_record_identifier => '1T'
1462: ,p_number_of_employee => C_NO_OF_NEWHIRE
1463: );
1464:
1465: hr_utility.trace('l_buffer = ' || l_buffer);
1466: -- file_io.put(l_buffer);
1467: l_buffer := per_new_hire_pkg.ny_1e_record(
1468: p_record_identifier => '1E'
1469: ,p_federal_id => FEDERAL_ID

Line 1476: hr_utility.set_location(l_name,60);

1472: ,p_city => l_city
1473: ,p_state => l_state
1474: ,p_zip => l_zip
1475: );
1476: hr_utility.set_location(l_name,60);
1477: hr_utility.trace('l_buffer = ' || l_buffer);
1478: -- file_io.put(l_buffer);
1479: cp_pre_tax_unit_id := tax_unit_id;
1480: c_no_of_newhire := 0;

Line 1477: hr_utility.trace('l_buffer = ' || l_buffer);

1473: ,p_state => l_state
1474: ,p_zip => l_zip
1475: );
1476: hr_utility.set_location(l_name,60);
1477: hr_utility.trace('l_buffer = ' || l_buffer);
1478: -- file_io.put(l_buffer);
1479: cp_pre_tax_unit_id := tax_unit_id;
1480: c_no_of_newhire := 0;
1481: C_no_of_gre := c_no_of_gre + 1;

Line 1484: hr_utility.set_location(l_name,70);

1480: c_no_of_newhire := 0;
1481: C_no_of_gre := c_no_of_gre + 1;
1482: end if;
1483: elsif p_state_code = 'TX' then
1484: hr_utility.set_location(l_name,70);
1485: if cp_pre_tax_unit_id is NULL then
1486: hr_utility.set_location(l_name,71);
1487: a01_header_record(TAX_UNIT_ID,federal_id) ;
1488: cp_pre_tax_unit_id := tax_unit_id;

Line 1486: hr_utility.set_location(l_name,71);

1482: end if;
1483: elsif p_state_code = 'TX' then
1484: hr_utility.set_location(l_name,70);
1485: if cp_pre_tax_unit_id is NULL then
1486: hr_utility.set_location(l_name,71);
1487: a01_header_record(TAX_UNIT_ID,federal_id) ;
1488: cp_pre_tax_unit_id := tax_unit_id;
1489: open c_tx_emp_number;
1490: fetch c_tx_emp_number into l_tx_emp_num;

Line 1496: hr_utility.trace('l_tx_emp_num = ' || l_tx_emp_num);

1492: l_tx_emp_num := 0;
1493: end if;
1494: close c_tx_emp_number;
1495:
1496: hr_utility.trace('l_tx_emp_num = ' || l_tx_emp_num);
1497: open c_tx_term_number;
1498: fetch c_tx_term_number into l_tx_term_num;
1499: if c_tx_term_number%NOTFOUND then
1500: l_tx_term_num := 0;

Line 1503: hr_utility.trace('l_tx_term_num = ' || l_tx_term_num);

1499: if c_tx_term_number%NOTFOUND then
1500: l_tx_term_num := 0;
1501: end if;
1502: close c_tx_term_number;
1503: hr_utility.trace('l_tx_term_num = ' || l_tx_term_num);
1504:
1505: l_buffer := per_new_hire_pkg.tx_t4_record(
1506: p_record_identifier => 'T4'
1507: ,p_number_of_employee => l_tx_emp_num + l_tx_term_num

Line 1510: hr_utility.trace('l_buffer = ' || l_buffer);

1506: p_record_identifier => 'T4'
1507: ,p_number_of_employee => l_tx_emp_num + l_tx_term_num
1508: );
1509:
1510: hr_utility.trace('l_buffer = ' || l_buffer);
1511: --file_io.put(l_buffer);
1512: elsif cp_pre_tax_unit_id <> tax_unit_id then
1513: hr_utility.set_location(l_name,72);
1514: a01_header_record(TAX_UNIT_ID,federal_id) ;

Line 1513: hr_utility.set_location(l_name,72);

1509:
1510: hr_utility.trace('l_buffer = ' || l_buffer);
1511: --file_io.put(l_buffer);
1512: elsif cp_pre_tax_unit_id <> tax_unit_id then
1513: hr_utility.set_location(l_name,72);
1514: a01_header_record(TAX_UNIT_ID,federal_id) ;
1515: cp_pre_tax_unit_id := tax_unit_id;
1516: end if;
1517: else hr_utility.set_location(l_name,80);

Line 1517: else hr_utility.set_location(l_name,80);

1513: hr_utility.set_location(l_name,72);
1514: a01_header_record(TAX_UNIT_ID,federal_id) ;
1515: cp_pre_tax_unit_id := tax_unit_id;
1516: end if;
1517: else hr_utility.set_location(l_name,80);
1518: if cp_pre_tax_unit_id is NULL then
1519: hr_utility.set_location(l_name,81);
1520: a01_header_record(TAX_UNIT_ID,federal_id) ;
1521: cp_pre_tax_unit_id := tax_unit_id;

Line 1519: hr_utility.set_location(l_name,81);

1515: cp_pre_tax_unit_id := tax_unit_id;
1516: end if;
1517: else hr_utility.set_location(l_name,80);
1518: if cp_pre_tax_unit_id is NULL then
1519: hr_utility.set_location(l_name,81);
1520: a01_header_record(TAX_UNIT_ID,federal_id) ;
1521: cp_pre_tax_unit_id := tax_unit_id;
1522: elsif cp_pre_tax_unit_id <> tax_unit_id then
1523: hr_utility.set_location(l_name,82);

Line 1523: hr_utility.set_location(l_name,82);

1519: hr_utility.set_location(l_name,81);
1520: a01_header_record(TAX_UNIT_ID,federal_id) ;
1521: cp_pre_tax_unit_id := tax_unit_id;
1522: elsif cp_pre_tax_unit_id <> tax_unit_id then
1523: hr_utility.set_location(l_name,82);
1524: a01_header_record(TAX_UNIT_ID,federal_id) ;
1525: cp_pre_tax_unit_id := tax_unit_id;
1526: end if;
1527: end if;

Line 1528: hr_utility.set_location('Leaving... ' || l_name,100);

1524: a01_header_record(TAX_UNIT_ID,federal_id) ;
1525: cp_pre_tax_unit_id := tax_unit_id;
1526: end if;
1527: end if;
1528: hr_utility.set_location('Leaving... ' || l_name,100);
1529: exception when others then
1530: hr_utility.set_location('Leaving....' || l_name,999);
1531: c_fatal_error_flag := 6;
1532: fnd_message.raise_error;

Line 1530: hr_utility.set_location('Leaving....' || l_name,999);

1526: end if;
1527: end if;
1528: hr_utility.set_location('Leaving... ' || l_name,100);
1529: exception when others then
1530: hr_utility.set_location('Leaving....' || l_name,999);
1531: c_fatal_error_flag := 6;
1532: fnd_message.raise_error;
1533:
1534: END;

Line 1654: hr_utility.set_location('Entered p_output_new_hire_null',10);

1650: v_state hr_locations_all.region_2%TYPE;
1651:
1652:
1653: BEGIN
1654: hr_utility.set_location('Entered p_output_new_hire_null',10);
1655: v_header := 0;
1656: if c_person_id%ISOPEN then
1657: close c_person_id;
1658: end if;

Line 1701: hr_utility.set_location('p_output_new_hire_null',100);

1697:
1698: END LOOP;
1699: fnd_file.put_line(1,' ');
1700:
1701: hr_utility.set_location('p_output_new_hire_null',100);
1702:
1703: CLOSE c_person_id;
1704: exception
1705: when others then