APPS.PER_NEW_HIRE_PKG dependencies on HR_UTILITY

Line 86: --hr_utility.trace_on(null,'NEWHIRE');

82: l_api_name varchar2(61) := g_package_name || '.char_set_init';
83: l_package_name varchar2(30) := g_package_name;
84: begin
85: --
86: --hr_utility.trace_on(null,'NEWHIRE');
87: hr_utility.set_location('Entering:' ||l_api_name,10);
88: --
89: -- Check mandatory argument.
90: --

Line 87: hr_utility.set_location('Entering:' ||l_api_name,10);

83: l_package_name varchar2(30) := g_package_name;
84: begin
85: --
86: --hr_utility.trace_on(null,'NEWHIRE');
87: hr_utility.set_location('Entering:' ||l_api_name,10);
88: --
89: -- Check mandatory argument.
90: --
91: hr_api.mandatory_arg_error(

Line 100: hr_utility.set_location(l_api_name,20);

96: -- Initialize global variables.
97: --
98: g_character_set := p_character_set;
99: --
100: hr_utility.set_location(l_api_name,20);
101: --
102: hr_utility.set_location('Leaving.... :' || l_api_name,50);
103: end char_set_init;
104:

Line 102: hr_utility.set_location('Leaving.... :' || l_api_name,50);

98: g_character_set := p_character_set;
99: --
100: hr_utility.set_location(l_api_name,20);
101: --
102: hr_utility.set_location('Leaving.... :' || l_api_name,50);
103: end char_set_init;
104:
105: /****************************************************************
106: * This procedure formats California E4 record *

Line 130: hr_utility.set_location('Entering:' ||l_api_name,10);

126: v_sit varchar2(40);
127: p_end_of_rec varchar2(2000);
128: begin
129:
130: hr_utility.set_location('Entering:' ||l_api_name,10);
131:
132: --
133: -- Check mandatory argument.
134: --

Line 140: hr_utility.set_location(l_api_name,11);

136: p_api_name => l_api_name,
137: p_argument => 'p_record_identifier',
138: p_argument_value => p_record_identifier);
139:
140: hr_utility.set_location(l_api_name,11);
141: hr_utility.trace('p_federal_id= ' || p_federal_id);
142: hr_utility.trace('p_sit_company_state_id= ' || p_sit_company_state_id);
143:
144: v_sit := replace(p_sit_company_state_id,'-',null);

Line 141: hr_utility.trace('p_federal_id= ' || p_federal_id);

137: p_argument => 'p_record_identifier',
138: p_argument_value => p_record_identifier);
139:
140: hr_utility.set_location(l_api_name,11);
141: hr_utility.trace('p_federal_id= ' || p_federal_id);
142: hr_utility.trace('p_sit_company_state_id= ' || p_sit_company_state_id);
143:
144: v_sit := replace(p_sit_company_state_id,'-',null);
145:

Line 142: hr_utility.trace('p_sit_company_state_id= ' || p_sit_company_state_id);

138: p_argument_value => p_record_identifier);
139:
140: hr_utility.set_location(l_api_name,11);
141: hr_utility.trace('p_federal_id= ' || p_federal_id);
142: hr_utility.trace('p_sit_company_state_id= ' || p_sit_company_state_id);
143:
144: v_sit := replace(p_sit_company_state_id,'-',null);
145:
146: hr_utility.trace('v_sit_company_state_id= ' || v_sit);

Line 146: hr_utility.trace('v_sit_company_state_id= ' || v_sit);

142: hr_utility.trace('p_sit_company_state_id= ' || p_sit_company_state_id);
143:
144: v_sit := replace(p_sit_company_state_id,'-',null);
145:
146: hr_utility.trace('v_sit_company_state_id= ' || v_sit);
147:
148: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
149: hr_utility.trace('p_street_address= ' || p_street_address);
150: hr_utility.trace('p_city= ' || p_city);

Line 148: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);

144: v_sit := replace(p_sit_company_state_id,'-',null);
145:
146: hr_utility.trace('v_sit_company_state_id= ' || v_sit);
147:
148: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
149: hr_utility.trace('p_street_address= ' || p_street_address);
150: hr_utility.trace('p_city= ' || p_city);
151: hr_utility.trace('p_state= ' || p_state);
152: hr_utility.trace('p_zip= ' || p_zip);

Line 149: hr_utility.trace('p_street_address= ' || p_street_address);

145:
146: hr_utility.trace('v_sit_company_state_id= ' || v_sit);
147:
148: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
149: hr_utility.trace('p_street_address= ' || p_street_address);
150: hr_utility.trace('p_city= ' || p_city);
151: hr_utility.trace('p_state= ' || p_state);
152: hr_utility.trace('p_zip= ' || p_zip);
153: hr_utility.trace('p_zip_extension= ' || p_zip_extension);

Line 150: hr_utility.trace('p_city= ' || p_city);

146: hr_utility.trace('v_sit_company_state_id= ' || v_sit);
147:
148: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
149: hr_utility.trace('p_street_address= ' || p_street_address);
150: hr_utility.trace('p_city= ' || p_city);
151: hr_utility.trace('p_state= ' || p_state);
152: hr_utility.trace('p_zip= ' || p_zip);
153: hr_utility.trace('p_zip_extension= ' || p_zip_extension);
154:

Line 151: hr_utility.trace('p_state= ' || p_state);

147:
148: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
149: hr_utility.trace('p_street_address= ' || p_street_address);
150: hr_utility.trace('p_city= ' || p_city);
151: hr_utility.trace('p_state= ' || p_state);
152: hr_utility.trace('p_zip= ' || p_zip);
153: hr_utility.trace('p_zip_extension= ' || p_zip_extension);
154:
155: hr_utility.set_location(l_api_name,30);

Line 152: hr_utility.trace('p_zip= ' || p_zip);

148: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
149: hr_utility.trace('p_street_address= ' || p_street_address);
150: hr_utility.trace('p_city= ' || p_city);
151: hr_utility.trace('p_state= ' || p_state);
152: hr_utility.trace('p_zip= ' || p_zip);
153: hr_utility.trace('p_zip_extension= ' || p_zip_extension);
154:
155: hr_utility.set_location(l_api_name,30);
156:

Line 153: hr_utility.trace('p_zip_extension= ' || p_zip_extension);

149: hr_utility.trace('p_street_address= ' || p_street_address);
150: hr_utility.trace('p_city= ' || p_city);
151: hr_utility.trace('p_state= ' || p_state);
152: hr_utility.trace('p_zip= ' || p_zip);
153: hr_utility.trace('p_zip_extension= ' || p_zip_extension);
154:
155: hr_utility.set_location(l_api_name,30);
156:
157: --

Line 155: hr_utility.set_location(l_api_name,30);

151: hr_utility.trace('p_state= ' || p_state);
152: hr_utility.trace('p_zip= ' || p_zip);
153: hr_utility.trace('p_zip_extension= ' || p_zip_extension);
154:
155: hr_utility.set_location(l_api_name,30);
156:
157: --
158: -- format new hire rocord
159: --

Line 176: hr_utility.set_location('Leaving.... :' || l_api_name,40);

172: rpad(nvl(p_zip_extension,' '),4,' ') ||
173: lpad(' ',32,' '))||p_end_of_rec ;
174:
175:
176: hr_utility.set_location('Leaving.... :' || l_api_name,40);
177:
178: return convert(l_buffer,g_character_set);
179: exception
180: when others then

Line 181: hr_utility.set_location('Leaving.... :' || l_api_name,70);

177:
178: return convert(l_buffer,g_character_set);
179: exception
180: when others then
181: hr_utility.set_location('Leaving.... :' || l_api_name,70);
182: -- fnd_message.set_name('PER','HR_ERROR');
183: -- fnd_message.set_token('SQL',g_ca_e4_sql);
184: -- fnd_message.raise_error;
185: raise;

Line 213: hr_utility.set_location('Entering:' ||l_api_name,10);

209: l_buffer varchar2(2000);
210: v_ssn varchar(9);
211: p_end_of_rec varchar2(2000);
212: begin
213: hr_utility.set_location('Entering:' ||l_api_name,10);
214:
215: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
216: hr_utility.trace('p_national_identifier= ' || p_national_identifier);
217:

Line 215: hr_utility.trace('p_record_identifier= ' || p_record_identifier);

211: p_end_of_rec varchar2(2000);
212: begin
213: hr_utility.set_location('Entering:' ||l_api_name,10);
214:
215: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
216: hr_utility.trace('p_national_identifier= ' || p_national_identifier);
217:
218: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
219:

Line 216: hr_utility.trace('p_national_identifier= ' || p_national_identifier);

212: begin
213: hr_utility.set_location('Entering:' ||l_api_name,10);
214:
215: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
216: hr_utility.trace('p_national_identifier= ' || p_national_identifier);
217:
218: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
219:
220: hr_utility.trace('v_ssn= ' || v_ssn);

Line 220: hr_utility.trace('v_ssn= ' || v_ssn);

216: hr_utility.trace('p_national_identifier= ' || p_national_identifier);
217:
218: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
219:
220: hr_utility.trace('v_ssn= ' || v_ssn);
221:
222: hr_utility.trace('p_first_name= ' || p_first_name);
223:
224: hr_utility.trace('p_middle_name= ' || p_middle_name);

Line 222: hr_utility.trace('p_first_name= ' || p_first_name);

218: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
219:
220: hr_utility.trace('v_ssn= ' || v_ssn);
221:
222: hr_utility.trace('p_first_name= ' || p_first_name);
223:
224: hr_utility.trace('p_middle_name= ' || p_middle_name);
225: hr_utility.trace('p_last_name= ' || p_last_name);
226:

Line 224: hr_utility.trace('p_middle_name= ' || p_middle_name);

220: hr_utility.trace('v_ssn= ' || v_ssn);
221:
222: hr_utility.trace('p_first_name= ' || p_first_name);
223:
224: hr_utility.trace('p_middle_name= ' || p_middle_name);
225: hr_utility.trace('p_last_name= ' || p_last_name);
226:
227: hr_utility.trace('p_street_address= ' || p_street_address);
228: hr_utility.trace('p_city= ' || p_city);

Line 225: hr_utility.trace('p_last_name= ' || p_last_name);

221:
222: hr_utility.trace('p_first_name= ' || p_first_name);
223:
224: hr_utility.trace('p_middle_name= ' || p_middle_name);
225: hr_utility.trace('p_last_name= ' || p_last_name);
226:
227: hr_utility.trace('p_street_address= ' || p_street_address);
228: hr_utility.trace('p_city= ' || p_city);
229: hr_utility.trace('p_state= ' || p_state);

Line 227: hr_utility.trace('p_street_address= ' || p_street_address);

223:
224: hr_utility.trace('p_middle_name= ' || p_middle_name);
225: hr_utility.trace('p_last_name= ' || p_last_name);
226:
227: hr_utility.trace('p_street_address= ' || p_street_address);
228: hr_utility.trace('p_city= ' || p_city);
229: hr_utility.trace('p_state= ' || p_state);
230: hr_utility.trace('p_zip= ' || p_zip);
231: hr_utility.trace('p_zip_extension= ' || p_zip_extension);

Line 228: hr_utility.trace('p_city= ' || p_city);

224: hr_utility.trace('p_middle_name= ' || p_middle_name);
225: hr_utility.trace('p_last_name= ' || p_last_name);
226:
227: hr_utility.trace('p_street_address= ' || p_street_address);
228: hr_utility.trace('p_city= ' || p_city);
229: hr_utility.trace('p_state= ' || p_state);
230: hr_utility.trace('p_zip= ' || p_zip);
231: hr_utility.trace('p_zip_extension= ' || p_zip_extension);
232: hr_utility.trace('p_date_of_hire= ' || to_char(p_date_of_hire));

Line 229: hr_utility.trace('p_state= ' || p_state);

225: hr_utility.trace('p_last_name= ' || p_last_name);
226:
227: hr_utility.trace('p_street_address= ' || p_street_address);
228: hr_utility.trace('p_city= ' || p_city);
229: hr_utility.trace('p_state= ' || p_state);
230: hr_utility.trace('p_zip= ' || p_zip);
231: hr_utility.trace('p_zip_extension= ' || p_zip_extension);
232: hr_utility.trace('p_date_of_hire= ' || to_char(p_date_of_hire));
233:

Line 230: hr_utility.trace('p_zip= ' || p_zip);

226:
227: hr_utility.trace('p_street_address= ' || p_street_address);
228: hr_utility.trace('p_city= ' || p_city);
229: hr_utility.trace('p_state= ' || p_state);
230: hr_utility.trace('p_zip= ' || p_zip);
231: hr_utility.trace('p_zip_extension= ' || p_zip_extension);
232: hr_utility.trace('p_date_of_hire= ' || to_char(p_date_of_hire));
233:
234: --

Line 231: hr_utility.trace('p_zip_extension= ' || p_zip_extension);

227: hr_utility.trace('p_street_address= ' || p_street_address);
228: hr_utility.trace('p_city= ' || p_city);
229: hr_utility.trace('p_state= ' || p_state);
230: hr_utility.trace('p_zip= ' || p_zip);
231: hr_utility.trace('p_zip_extension= ' || p_zip_extension);
232: hr_utility.trace('p_date_of_hire= ' || to_char(p_date_of_hire));
233:
234: --
235: -- format new hire rocord

Line 232: hr_utility.trace('p_date_of_hire= ' || to_char(p_date_of_hire));

228: hr_utility.trace('p_city= ' || p_city);
229: hr_utility.trace('p_state= ' || p_state);
230: hr_utility.trace('p_zip= ' || p_zip);
231: hr_utility.trace('p_zip_extension= ' || p_zip_extension);
232: hr_utility.trace('p_date_of_hire= ' || to_char(p_date_of_hire));
233:
234: --
235: -- format new hire rocord
236: --

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

250: rpad(nvl(p_zip_extension,' '),4,' ') ||
251: nvl(to_char(p_date_of_hire,'YYYYMMDD'),' ') ||
252: lpad(' ',33,' '))||p_end_of_rec;
253:
254: hr_utility.trace('l_buffer = ' || l_buffer);
255:
256:
257: hr_utility.set_location('Leaving.... :' || l_api_name,60);
258:

Line 257: hr_utility.set_location('Leaving.... :' || l_api_name,60);

253:
254: hr_utility.trace('l_buffer = ' || l_buffer);
255:
256:
257: hr_utility.set_location('Leaving.... :' || l_api_name,60);
258:
259: return convert(l_buffer,g_character_set);
260: exception
261: when others then

Line 262: hr_utility.set_location('Leaving.... :' || l_api_name,70);

258:
259: return convert(l_buffer,g_character_set);
260: exception
261: when others then
262: hr_utility.set_location('Leaving.... :' || l_api_name,70);
263: raise;
264: end ca_w4_record;
265: --
266: /****************************************************************

Line 282: hr_utility.set_location('Entering:' ||l_api_name,10);

278: l_buffer varchar2(2000);
279: p_end_of_rec varchar2(2000);
280: begin
281: --
282: hr_utility.set_location('Entering:' ||l_api_name,10);
283:
284: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
285: hr_utility.trace('p_number_of_emplyee = ' || p_number_of_employee);
286:

Line 284: hr_utility.trace('p_record_identifier= ' || p_record_identifier);

280: begin
281: --
282: hr_utility.set_location('Entering:' ||l_api_name,10);
283:
284: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
285: hr_utility.trace('p_number_of_emplyee = ' || p_number_of_employee);
286:
287: --
288: -- format new hire rocord

Line 285: hr_utility.trace('p_number_of_emplyee = ' || p_number_of_employee);

281: --
282: hr_utility.set_location('Entering:' ||l_api_name,10);
283:
284: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
285: hr_utility.trace('p_number_of_emplyee = ' || p_number_of_employee);
286:
287: --
288: -- format new hire rocord
289: --

Line 298: hr_utility.set_location(l_api_name,20);

294: p_record_identifier ||
295: lpad(to_char(p_number_of_employee),11,'0') ||
296: lpad(' ',162,' '))||p_end_of_rec;
297:
298: hr_utility.set_location(l_api_name,20);
299:
300: return convert(l_buffer,g_character_set);
301: exception
302: when others then

Line 303: hr_utility.set_location('Leaving.... :' || l_api_name,30);

299:
300: return convert(l_buffer,g_character_set);
301: exception
302: when others then
303: hr_utility.set_location('Leaving.... :' || l_api_name,30);
304: raise;
305: end ca_t4_record;
306: --
307: /****************************************************************

Line 329: hr_utility.set_location('Entering...:' ||l_api_name,10);

325: l_buffer varchar2(2000);
326: p_end_of_rec varchar2(2000);
327: begin
328:
329: hr_utility.set_location('Entering...:' ||l_api_name,10);
330:
331: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
332: hr_utility.trace('p_federal_id= ' || p_federal_id);
333: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);

Line 331: hr_utility.trace('p_record_identifier= ' || p_record_identifier);

327: begin
328:
329: hr_utility.set_location('Entering...:' ||l_api_name,10);
330:
331: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
332: hr_utility.trace('p_federal_id= ' || p_federal_id);
333: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
334: hr_utility.trace('p_street_address= ' || p_street_address);
335: hr_utility.trace('p_city= ' || p_city);

Line 332: hr_utility.trace('p_federal_id= ' || p_federal_id);

328:
329: hr_utility.set_location('Entering...:' ||l_api_name,10);
330:
331: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
332: hr_utility.trace('p_federal_id= ' || p_federal_id);
333: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
334: hr_utility.trace('p_street_address= ' || p_street_address);
335: hr_utility.trace('p_city= ' || p_city);
336: hr_utility.trace('p_state= ' || p_state);

Line 333: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);

329: hr_utility.set_location('Entering...:' ||l_api_name,10);
330:
331: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
332: hr_utility.trace('p_federal_id= ' || p_federal_id);
333: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
334: hr_utility.trace('p_street_address= ' || p_street_address);
335: hr_utility.trace('p_city= ' || p_city);
336: hr_utility.trace('p_state= ' || p_state);
337: hr_utility.trace('p_zip= ' || p_zip);

Line 334: hr_utility.trace('p_street_address= ' || p_street_address);

330:
331: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
332: hr_utility.trace('p_federal_id= ' || p_federal_id);
333: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
334: hr_utility.trace('p_street_address= ' || p_street_address);
335: hr_utility.trace('p_city= ' || p_city);
336: hr_utility.trace('p_state= ' || p_state);
337: hr_utility.trace('p_zip= ' || p_zip);
338:

Line 335: hr_utility.trace('p_city= ' || p_city);

331: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
332: hr_utility.trace('p_federal_id= ' || p_federal_id);
333: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
334: hr_utility.trace('p_street_address= ' || p_street_address);
335: hr_utility.trace('p_city= ' || p_city);
336: hr_utility.trace('p_state= ' || p_state);
337: hr_utility.trace('p_zip= ' || p_zip);
338:
339: hr_utility.set_location(l_api_name,30);

Line 336: hr_utility.trace('p_state= ' || p_state);

332: hr_utility.trace('p_federal_id= ' || p_federal_id);
333: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
334: hr_utility.trace('p_street_address= ' || p_street_address);
335: hr_utility.trace('p_city= ' || p_city);
336: hr_utility.trace('p_state= ' || p_state);
337: hr_utility.trace('p_zip= ' || p_zip);
338:
339: hr_utility.set_location(l_api_name,30);
340:

Line 337: hr_utility.trace('p_zip= ' || p_zip);

333: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
334: hr_utility.trace('p_street_address= ' || p_street_address);
335: hr_utility.trace('p_city= ' || p_city);
336: hr_utility.trace('p_state= ' || p_state);
337: hr_utility.trace('p_zip= ' || p_zip);
338:
339: hr_utility.set_location(l_api_name,30);
340:
341: --

Line 339: hr_utility.set_location(l_api_name,30);

335: hr_utility.trace('p_city= ' || p_city);
336: hr_utility.trace('p_state= ' || p_state);
337: hr_utility.trace('p_zip= ' || p_zip);
338:
339: hr_utility.set_location(l_api_name,30);
340:
341: --
342: -- format new hire rocord
343: --

Line 358: hr_utility.set_location('Leaving.... :' || l_api_name,40);

354: rpad(nvl(p_zip,' '),9,' ') ||
355: lpad(' ',10,' '))||p_end_of_rec;
356:
357:
358: hr_utility.set_location('Leaving.... :' || l_api_name,40);
359:
360: return convert(l_buffer,g_character_set);
361: exception
362: when others then

Line 363: hr_utility.set_location('Leaving.... :' || l_api_name,70);

359:
360: return convert(l_buffer,g_character_set);
361: exception
362: when others then
363: hr_utility.set_location('Leaving.... :' || l_api_name,70);
364: raise;
365: end ny_1a_record;
366: --
367: /****************************************************************

Line 388: hr_utility.set_location('Entering:' ||l_api_name,10);

384: l_buffer varchar2(2000);
385: p_end_of_rec varchar2(2000);
386: begin
387:
388: hr_utility.set_location('Entering:' ||l_api_name,10);
389:
390: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
391: hr_utility.trace('p_federal_id= ' || p_federal_id);
392: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);

Line 390: hr_utility.trace('p_record_identifier= ' || p_record_identifier);

386: begin
387:
388: hr_utility.set_location('Entering:' ||l_api_name,10);
389:
390: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
391: hr_utility.trace('p_federal_id= ' || p_federal_id);
392: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
393: hr_utility.trace('p_street_address= ' || p_street_address);
394: hr_utility.trace('p_city= ' || p_city);

Line 391: hr_utility.trace('p_federal_id= ' || p_federal_id);

387:
388: hr_utility.set_location('Entering:' ||l_api_name,10);
389:
390: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
391: hr_utility.trace('p_federal_id= ' || p_federal_id);
392: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
393: hr_utility.trace('p_street_address= ' || p_street_address);
394: hr_utility.trace('p_city= ' || p_city);
395: hr_utility.trace('p_state= ' || p_state);

Line 392: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);

388: hr_utility.set_location('Entering:' ||l_api_name,10);
389:
390: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
391: hr_utility.trace('p_federal_id= ' || p_federal_id);
392: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
393: hr_utility.trace('p_street_address= ' || p_street_address);
394: hr_utility.trace('p_city= ' || p_city);
395: hr_utility.trace('p_state= ' || p_state);
396: hr_utility.trace('p_zip= ' || p_zip);

Line 393: hr_utility.trace('p_street_address= ' || p_street_address);

389:
390: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
391: hr_utility.trace('p_federal_id= ' || p_federal_id);
392: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
393: hr_utility.trace('p_street_address= ' || p_street_address);
394: hr_utility.trace('p_city= ' || p_city);
395: hr_utility.trace('p_state= ' || p_state);
396: hr_utility.trace('p_zip= ' || p_zip);
397:

Line 394: hr_utility.trace('p_city= ' || p_city);

390: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
391: hr_utility.trace('p_federal_id= ' || p_federal_id);
392: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
393: hr_utility.trace('p_street_address= ' || p_street_address);
394: hr_utility.trace('p_city= ' || p_city);
395: hr_utility.trace('p_state= ' || p_state);
396: hr_utility.trace('p_zip= ' || p_zip);
397:
398: hr_utility.set_location(l_api_name,30);

Line 395: hr_utility.trace('p_state= ' || p_state);

391: hr_utility.trace('p_federal_id= ' || p_federal_id);
392: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
393: hr_utility.trace('p_street_address= ' || p_street_address);
394: hr_utility.trace('p_city= ' || p_city);
395: hr_utility.trace('p_state= ' || p_state);
396: hr_utility.trace('p_zip= ' || p_zip);
397:
398: hr_utility.set_location(l_api_name,30);
399:

Line 396: hr_utility.trace('p_zip= ' || p_zip);

392: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
393: hr_utility.trace('p_street_address= ' || p_street_address);
394: hr_utility.trace('p_city= ' || p_city);
395: hr_utility.trace('p_state= ' || p_state);
396: hr_utility.trace('p_zip= ' || p_zip);
397:
398: hr_utility.set_location(l_api_name,30);
399:
400: --

Line 398: hr_utility.set_location(l_api_name,30);

394: hr_utility.trace('p_city= ' || p_city);
395: hr_utility.trace('p_state= ' || p_state);
396: hr_utility.trace('p_zip= ' || p_zip);
397:
398: hr_utility.set_location(l_api_name,30);
399:
400: --
401: -- format new hire rocord
402: --

Line 419: hr_utility.set_location('Leaving.... :' || l_api_name,40);

415: rpad(nvl(p_zip,' '),9,' ') ||
416: lpad(' ',10,' '))||p_end_of_rec;
417:
418:
419: hr_utility.set_location('Leaving.... :' || l_api_name,40);
420:
421: return convert(l_buffer,g_character_set);
422: exception
423: when others then

Line 424: hr_utility.set_location('Leaving.... :' || l_api_name,70);

420:
421: return convert(l_buffer,g_character_set);
422: exception
423: when others then
424: hr_utility.set_location('Leaving.... :' || l_api_name,70);
425: raise;
426: end ny_1e_record;
427: --
428: --

Line 453: hr_utility.set_location('Entering:' ||l_api_name,10);

449: l_buffer varchar2(2000);
450: v_ssn varchar(9);
451: p_end_of_rec varchar2(2000);
452: begin
453: hr_utility.set_location('Entering:' ||l_api_name,10);
454:
455: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
456: hr_utility.trace('p_national_identifier= ' || p_national_identifier);
457:

Line 455: hr_utility.trace('p_record_identifier= ' || p_record_identifier);

451: p_end_of_rec varchar2(2000);
452: begin
453: hr_utility.set_location('Entering:' ||l_api_name,10);
454:
455: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
456: hr_utility.trace('p_national_identifier= ' || p_national_identifier);
457:
458: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
459:

Line 456: hr_utility.trace('p_national_identifier= ' || p_national_identifier);

452: begin
453: hr_utility.set_location('Entering:' ||l_api_name,10);
454:
455: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
456: hr_utility.trace('p_national_identifier= ' || p_national_identifier);
457:
458: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
459:
460: hr_utility.trace('v_ssn= ' || v_ssn);

Line 460: hr_utility.trace('v_ssn= ' || v_ssn);

456: hr_utility.trace('p_national_identifier= ' || p_national_identifier);
457:
458: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
459:
460: hr_utility.trace('v_ssn= ' || v_ssn);
461: hr_utility.trace('p_first_name= ' || p_first_name);
462: hr_utility.trace('p_middle_name= ' || p_middle_name);
463: hr_utility.trace('p_last_name= ' || p_last_name);
464:

Line 461: hr_utility.trace('p_first_name= ' || p_first_name);

457:
458: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
459:
460: hr_utility.trace('v_ssn= ' || v_ssn);
461: hr_utility.trace('p_first_name= ' || p_first_name);
462: hr_utility.trace('p_middle_name= ' || p_middle_name);
463: hr_utility.trace('p_last_name= ' || p_last_name);
464:
465: hr_utility.trace('p_street_address= ' || p_street_address);

Line 462: hr_utility.trace('p_middle_name= ' || p_middle_name);

458: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
459:
460: hr_utility.trace('v_ssn= ' || v_ssn);
461: hr_utility.trace('p_first_name= ' || p_first_name);
462: hr_utility.trace('p_middle_name= ' || p_middle_name);
463: hr_utility.trace('p_last_name= ' || p_last_name);
464:
465: hr_utility.trace('p_street_address= ' || p_street_address);
466: hr_utility.trace('p_city= ' || p_city);

Line 463: hr_utility.trace('p_last_name= ' || p_last_name);

459:
460: hr_utility.trace('v_ssn= ' || v_ssn);
461: hr_utility.trace('p_first_name= ' || p_first_name);
462: hr_utility.trace('p_middle_name= ' || p_middle_name);
463: hr_utility.trace('p_last_name= ' || p_last_name);
464:
465: hr_utility.trace('p_street_address= ' || p_street_address);
466: hr_utility.trace('p_city= ' || p_city);
467: hr_utility.trace('p_state= ' || p_state);

Line 465: hr_utility.trace('p_street_address= ' || p_street_address);

461: hr_utility.trace('p_first_name= ' || p_first_name);
462: hr_utility.trace('p_middle_name= ' || p_middle_name);
463: hr_utility.trace('p_last_name= ' || p_last_name);
464:
465: hr_utility.trace('p_street_address= ' || p_street_address);
466: hr_utility.trace('p_city= ' || p_city);
467: hr_utility.trace('p_state= ' || p_state);
468: hr_utility.trace('p_zip= ' || p_zip);
469: hr_utility.trace('p_date_of_hire= ' || to_char(p_date_of_hire));

Line 466: hr_utility.trace('p_city= ' || p_city);

462: hr_utility.trace('p_middle_name= ' || p_middle_name);
463: hr_utility.trace('p_last_name= ' || p_last_name);
464:
465: hr_utility.trace('p_street_address= ' || p_street_address);
466: hr_utility.trace('p_city= ' || p_city);
467: hr_utility.trace('p_state= ' || p_state);
468: hr_utility.trace('p_zip= ' || p_zip);
469: hr_utility.trace('p_date_of_hire= ' || to_char(p_date_of_hire));
470:

Line 467: hr_utility.trace('p_state= ' || p_state);

463: hr_utility.trace('p_last_name= ' || p_last_name);
464:
465: hr_utility.trace('p_street_address= ' || p_street_address);
466: hr_utility.trace('p_city= ' || p_city);
467: hr_utility.trace('p_state= ' || p_state);
468: hr_utility.trace('p_zip= ' || p_zip);
469: hr_utility.trace('p_date_of_hire= ' || to_char(p_date_of_hire));
470:
471: --

Line 468: hr_utility.trace('p_zip= ' || p_zip);

464:
465: hr_utility.trace('p_street_address= ' || p_street_address);
466: hr_utility.trace('p_city= ' || p_city);
467: hr_utility.trace('p_state= ' || p_state);
468: hr_utility.trace('p_zip= ' || p_zip);
469: hr_utility.trace('p_date_of_hire= ' || to_char(p_date_of_hire));
470:
471: --
472: -- format new hire rocord

Line 469: hr_utility.trace('p_date_of_hire= ' || to_char(p_date_of_hire));

465: hr_utility.trace('p_street_address= ' || p_street_address);
466: hr_utility.trace('p_city= ' || p_city);
467: hr_utility.trace('p_state= ' || p_state);
468: hr_utility.trace('p_zip= ' || p_zip);
469: hr_utility.trace('p_date_of_hire= ' || to_char(p_date_of_hire));
470:
471: --
472: -- format new hire rocord
473: --

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

486: ' ' || -- blank 1
487: rpad(nvl(to_char(p_date_of_hire,'MMDDRR'),' '),6,' ') ||
488: lpad(' ',27,' '))||p_end_of_rec;
489:
490: hr_utility.trace('l_buffer = ' || l_buffer);
491:
492:
493: hr_utility.set_location('Leaving.... :' || l_api_name,60);
494:

Line 493: hr_utility.set_location('Leaving.... :' || l_api_name,60);

489:
490: hr_utility.trace('l_buffer = ' || l_buffer);
491:
492:
493: hr_utility.set_location('Leaving.... :' || l_api_name,60);
494:
495: return convert(l_buffer,g_character_set);
496: exception
497: when others then

Line 498: hr_utility.set_location('Leaving.... :' || l_api_name,70);

494:
495: return convert(l_buffer,g_character_set);
496: exception
497: when others then
498: hr_utility.set_location('Leaving.... :' || l_api_name,70);
499: raise;
500: end ny_1h_record;
501: --
502: /****************************************************************

Line 518: hr_utility.set_location('Entering:' ||l_api_name,10);

514: l_buffer varchar2(2000);
515: p_end_of_rec varchar2(2000);
516: begin
517: --
518: hr_utility.set_location('Entering:' ||l_api_name,10);
519:
520: hr_utility.trace('p_number_of_emplyee = ' || p_number_of_employee);
521:
522: --

Line 520: hr_utility.trace('p_number_of_emplyee = ' || p_number_of_employee);

516: begin
517: --
518: hr_utility.set_location('Entering:' ||l_api_name,10);
519:
520: hr_utility.trace('p_number_of_emplyee = ' || p_number_of_employee);
521:
522: --
523: -- format new hire rocord
524: --

Line 533: hr_utility.set_location(l_api_name,20);

529: p_record_identifier ||
530: lpad(to_char(p_number_of_employee),7,' ') ||
531: lpad(' ',119,' '))||p_end_of_rec;
532:
533: hr_utility.set_location(l_api_name,20);
534:
535: return convert(l_buffer,g_character_set);
536: exception
537: when others then

Line 538: hr_utility.set_location('Leaving.... :' || l_api_name,30);

534:
535: return convert(l_buffer,g_character_set);
536: exception
537: when others then
538: hr_utility.set_location('Leaving.... :' || l_api_name,30);
539: raise;
540: end ny_1t_record;
541: --
542: /****************************************************************

Line 558: hr_utility.set_location('Entering:' ||l_api_name,10);

554: l_buffer varchar2(2000);
555: p_end_of_rec varchar2(2000);
556: begin
557: --
558: hr_utility.set_location('Entering:' ||l_api_name,10);
559:
560: hr_utility.trace('p_number_of_emplyer = ' || p_number_of_employer);
561:
562: --

Line 560: hr_utility.trace('p_number_of_emplyer = ' || p_number_of_employer);

556: begin
557: --
558: hr_utility.set_location('Entering:' ||l_api_name,10);
559:
560: hr_utility.trace('p_number_of_emplyer = ' || p_number_of_employer);
561:
562: --
563: -- format new hire rocord
564: --

Line 573: hr_utility.set_location(l_api_name,20);

569: p_record_identifier ||
570: lpad(to_char(p_number_of_employer),7,' ') ||
571: lpad(' ',119,' '))||p_end_of_rec;
572:
573: hr_utility.set_location(l_api_name,20);
574:
575: return convert(l_buffer,g_character_set);
576: exception
577: when others then

Line 578: hr_utility.set_location('Leaving.... :' || l_api_name,30);

574:
575: return convert(l_buffer,g_character_set);
576: exception
577: when others then
578: hr_utility.set_location('Leaving.... :' || l_api_name,30);
579: raise;
580: end ny_1f_record;
581: --
582: /****************************************************************

Line 640: hr_utility.set_location('Entering...: ' || l_api_name,10);

636: l_phone varchar(10);
637: l_opt_phone varchar(10);
638: begin
639:
640: hr_utility.set_location('Entering...: ' || l_api_name,10);
641:
642: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
643:
644: hr_utility.trace('p_first_name= ' || p_first_name);

Line 642: hr_utility.trace('p_record_identifier= ' || p_record_identifier);

638: begin
639:
640: hr_utility.set_location('Entering...: ' || l_api_name,10);
641:
642: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
643:
644: hr_utility.trace('p_first_name= ' || p_first_name);
645: hr_utility.trace('p_middle_name= ' || p_middle_name);
646: hr_utility.trace('p_last_name= ' || p_last_name);

Line 644: hr_utility.trace('p_first_name= ' || p_first_name);

640: hr_utility.set_location('Entering...: ' || l_api_name,10);
641:
642: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
643:
644: hr_utility.trace('p_first_name= ' || p_first_name);
645: hr_utility.trace('p_middle_name= ' || p_middle_name);
646: hr_utility.trace('p_last_name= ' || p_last_name);
647:
648: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);

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

641:
642: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
643:
644: hr_utility.trace('p_first_name= ' || p_first_name);
645: hr_utility.trace('p_middle_name= ' || p_middle_name);
646: hr_utility.trace('p_last_name= ' || p_last_name);
647:
648: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
649:

Line 646: hr_utility.trace('p_last_name= ' || p_last_name);

642: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
643:
644: hr_utility.trace('p_first_name= ' || p_first_name);
645: hr_utility.trace('p_middle_name= ' || p_middle_name);
646: hr_utility.trace('p_last_name= ' || p_last_name);
647:
648: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
649:
650: hr_utility.trace('v_ssn= ' || v_ssn);

Line 650: hr_utility.trace('v_ssn= ' || v_ssn);

646: hr_utility.trace('p_last_name= ' || p_last_name);
647:
648: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
649:
650: hr_utility.trace('v_ssn= ' || v_ssn);
651: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
652: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
653: hr_utility.trace('p_emp_address_line3= ' || p_emp_address_line3);
654: hr_utility.trace('p_emp_city= ' || p_emp_city);

Line 651: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);

647:
648: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
649:
650: hr_utility.trace('v_ssn= ' || v_ssn);
651: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
652: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
653: hr_utility.trace('p_emp_address_line3= ' || p_emp_address_line3);
654: hr_utility.trace('p_emp_city= ' || p_emp_city);
655: hr_utility.trace('p_emp_state= ' || p_emp_state);

Line 652: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);

648: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
649:
650: hr_utility.trace('v_ssn= ' || v_ssn);
651: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
652: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
653: hr_utility.trace('p_emp_address_line3= ' || p_emp_address_line3);
654: hr_utility.trace('p_emp_city= ' || p_emp_city);
655: hr_utility.trace('p_emp_state= ' || p_emp_state);
656: hr_utility.trace('p_emp_zip= ' || p_emp_zip);

Line 653: hr_utility.trace('p_emp_address_line3= ' || p_emp_address_line3);

649:
650: hr_utility.trace('v_ssn= ' || v_ssn);
651: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
652: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
653: hr_utility.trace('p_emp_address_line3= ' || p_emp_address_line3);
654: hr_utility.trace('p_emp_city= ' || p_emp_city);
655: hr_utility.trace('p_emp_state= ' || p_emp_state);
656: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
657: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);

Line 654: hr_utility.trace('p_emp_city= ' || p_emp_city);

650: hr_utility.trace('v_ssn= ' || v_ssn);
651: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
652: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
653: hr_utility.trace('p_emp_address_line3= ' || p_emp_address_line3);
654: hr_utility.trace('p_emp_city= ' || p_emp_city);
655: hr_utility.trace('p_emp_state= ' || p_emp_state);
656: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
657: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
658: hr_utility.trace('p_emp_country_code= ' || p_emp_country_code);

Line 655: hr_utility.trace('p_emp_state= ' || p_emp_state);

651: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
652: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
653: hr_utility.trace('p_emp_address_line3= ' || p_emp_address_line3);
654: hr_utility.trace('p_emp_city= ' || p_emp_city);
655: hr_utility.trace('p_emp_state= ' || p_emp_state);
656: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
657: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
658: hr_utility.trace('p_emp_country_code= ' || p_emp_country_code);
659: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);

Line 656: hr_utility.trace('p_emp_zip= ' || p_emp_zip);

652: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
653: hr_utility.trace('p_emp_address_line3= ' || p_emp_address_line3);
654: hr_utility.trace('p_emp_city= ' || p_emp_city);
655: hr_utility.trace('p_emp_state= ' || p_emp_state);
656: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
657: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
658: hr_utility.trace('p_emp_country_code= ' || p_emp_country_code);
659: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
660: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);

Line 657: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);

653: hr_utility.trace('p_emp_address_line3= ' || p_emp_address_line3);
654: hr_utility.trace('p_emp_city= ' || p_emp_city);
655: hr_utility.trace('p_emp_state= ' || p_emp_state);
656: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
657: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
658: hr_utility.trace('p_emp_country_code= ' || p_emp_country_code);
659: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
660: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
661:

Line 658: hr_utility.trace('p_emp_country_code= ' || p_emp_country_code);

654: hr_utility.trace('p_emp_city= ' || p_emp_city);
655: hr_utility.trace('p_emp_state= ' || p_emp_state);
656: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
657: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
658: hr_utility.trace('p_emp_country_code= ' || p_emp_country_code);
659: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
660: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
661:
662: hr_utility.trace('p_federal_id= ' || p_federal_id);

Line 659: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);

655: hr_utility.trace('p_emp_state= ' || p_emp_state);
656: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
657: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
658: hr_utility.trace('p_emp_country_code= ' || p_emp_country_code);
659: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
660: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
661:
662: hr_utility.trace('p_federal_id= ' || p_federal_id);
663: hr_utility.trace('p_sit_company_state_id=' || p_sit_company_state_id);

Line 660: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);

656: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
657: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
658: hr_utility.trace('p_emp_country_code= ' || p_emp_country_code);
659: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
660: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
661:
662: hr_utility.trace('p_federal_id= ' || p_federal_id);
663: hr_utility.trace('p_sit_company_state_id=' || p_sit_company_state_id);
664: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);

Line 662: hr_utility.trace('p_federal_id= ' || p_federal_id);

658: hr_utility.trace('p_emp_country_code= ' || p_emp_country_code);
659: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
660: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
661:
662: hr_utility.trace('p_federal_id= ' || p_federal_id);
663: hr_utility.trace('p_sit_company_state_id=' || p_sit_company_state_id);
664: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
665: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
666: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);

Line 663: hr_utility.trace('p_sit_company_state_id=' || p_sit_company_state_id);

659: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
660: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
661:
662: hr_utility.trace('p_federal_id= ' || p_federal_id);
663: hr_utility.trace('p_sit_company_state_id=' || p_sit_company_state_id);
664: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
665: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
666: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
667: hr_utility.trace('p_loc_address_line3= ' || p_loc_address_line3);

Line 664: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);

660: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
661:
662: hr_utility.trace('p_federal_id= ' || p_federal_id);
663: hr_utility.trace('p_sit_company_state_id=' || p_sit_company_state_id);
664: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
665: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
666: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
667: hr_utility.trace('p_loc_address_line3= ' || p_loc_address_line3);
668: hr_utility.trace('p_loc_city= ' || p_loc_city);

Line 665: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);

661:
662: hr_utility.trace('p_federal_id= ' || p_federal_id);
663: hr_utility.trace('p_sit_company_state_id=' || p_sit_company_state_id);
664: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
665: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
666: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
667: hr_utility.trace('p_loc_address_line3= ' || p_loc_address_line3);
668: hr_utility.trace('p_loc_city= ' || p_loc_city);
669: hr_utility.trace('p_loc_state= ' || p_loc_state);

Line 666: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);

662: hr_utility.trace('p_federal_id= ' || p_federal_id);
663: hr_utility.trace('p_sit_company_state_id=' || p_sit_company_state_id);
664: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
665: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
666: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
667: hr_utility.trace('p_loc_address_line3= ' || p_loc_address_line3);
668: hr_utility.trace('p_loc_city= ' || p_loc_city);
669: hr_utility.trace('p_loc_state= ' || p_loc_state);
670: hr_utility.trace('p_loc_zip= ' || p_loc_zip);

Line 667: hr_utility.trace('p_loc_address_line3= ' || p_loc_address_line3);

663: hr_utility.trace('p_sit_company_state_id=' || p_sit_company_state_id);
664: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
665: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
666: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
667: hr_utility.trace('p_loc_address_line3= ' || p_loc_address_line3);
668: hr_utility.trace('p_loc_city= ' || p_loc_city);
669: hr_utility.trace('p_loc_state= ' || p_loc_state);
670: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
671: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);

Line 668: hr_utility.trace('p_loc_city= ' || p_loc_city);

664: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
665: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
666: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
667: hr_utility.trace('p_loc_address_line3= ' || p_loc_address_line3);
668: hr_utility.trace('p_loc_city= ' || p_loc_city);
669: hr_utility.trace('p_loc_state= ' || p_loc_state);
670: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
671: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
672: hr_utility.trace('p_loc_country_code= ' || p_loc_country_code);

Line 669: hr_utility.trace('p_loc_state= ' || p_loc_state);

665: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
666: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
667: hr_utility.trace('p_loc_address_line3= ' || p_loc_address_line3);
668: hr_utility.trace('p_loc_city= ' || p_loc_city);
669: hr_utility.trace('p_loc_state= ' || p_loc_state);
670: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
671: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
672: hr_utility.trace('p_loc_country_code= ' || p_loc_country_code);
673: hr_utility.trace('p_loc_phone= ' || p_loc_phone);

Line 670: hr_utility.trace('p_loc_zip= ' || p_loc_zip);

666: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
667: hr_utility.trace('p_loc_address_line3= ' || p_loc_address_line3);
668: hr_utility.trace('p_loc_city= ' || p_loc_city);
669: hr_utility.trace('p_loc_state= ' || p_loc_state);
670: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
671: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
672: hr_utility.trace('p_loc_country_code= ' || p_loc_country_code);
673: hr_utility.trace('p_loc_phone= ' || p_loc_phone);
674:

Line 671: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);

667: hr_utility.trace('p_loc_address_line3= ' || p_loc_address_line3);
668: hr_utility.trace('p_loc_city= ' || p_loc_city);
669: hr_utility.trace('p_loc_state= ' || p_loc_state);
670: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
671: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
672: hr_utility.trace('p_loc_country_code= ' || p_loc_country_code);
673: hr_utility.trace('p_loc_phone= ' || p_loc_phone);
674:
675: l_phone := replace(replace(replace(replace(replace(nvl(p_loc_phone,' '),'(',null),'-',null),'.',null),')',null),' ',null);

Line 672: hr_utility.trace('p_loc_country_code= ' || p_loc_country_code);

668: hr_utility.trace('p_loc_city= ' || p_loc_city);
669: hr_utility.trace('p_loc_state= ' || p_loc_state);
670: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
671: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
672: hr_utility.trace('p_loc_country_code= ' || p_loc_country_code);
673: hr_utility.trace('p_loc_phone= ' || p_loc_phone);
674:
675: l_phone := replace(replace(replace(replace(replace(nvl(p_loc_phone,' '),'(',null),'-',null),'.',null),')',null),' ',null);
676:

Line 673: hr_utility.trace('p_loc_phone= ' || p_loc_phone);

669: hr_utility.trace('p_loc_state= ' || p_loc_state);
670: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
671: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
672: hr_utility.trace('p_loc_country_code= ' || p_loc_country_code);
673: hr_utility.trace('p_loc_phone= ' || p_loc_phone);
674:
675: l_phone := replace(replace(replace(replace(replace(nvl(p_loc_phone,' '),'(',null),'-',null),'.',null),')',null),' ',null);
676:
677: hr_utility.trace('l_phone= ' || l_phone);

Line 677: hr_utility.trace('l_phone= ' || l_phone);

673: hr_utility.trace('p_loc_phone= ' || p_loc_phone);
674:
675: l_phone := replace(replace(replace(replace(replace(nvl(p_loc_phone,' '),'(',null),'-',null),'.',null),')',null),' ',null);
676:
677: hr_utility.trace('l_phone= ' || l_phone);
678: hr_utility.trace('p_loc_contact= ' || p_loc_contact);
679:
680: l_opt_phone := replace(replace(replace(replace(replace(nvl(p_opt_phone,' '),'(',null),'-',null),'.',null),')',null),' ',null);
681:

Line 678: hr_utility.trace('p_loc_contact= ' || p_loc_contact);

674:
675: l_phone := replace(replace(replace(replace(replace(nvl(p_loc_phone,' '),'(',null),'-',null),'.',null),')',null),' ',null);
676:
677: hr_utility.trace('l_phone= ' || l_phone);
678: hr_utility.trace('p_loc_contact= ' || p_loc_contact);
679:
680: l_opt_phone := replace(replace(replace(replace(replace(nvl(p_opt_phone,' '),'(',null),'-',null),'.',null),')',null),' ',null);
681:
682: hr_utility.trace('l_opt_phone= ' || l_opt_phone);

Line 682: hr_utility.trace('l_opt_phone= ' || l_opt_phone);

678: hr_utility.trace('p_loc_contact= ' || p_loc_contact);
679:
680: l_opt_phone := replace(replace(replace(replace(replace(nvl(p_opt_phone,' '),'(',null),'-',null),'.',null),')',null),' ',null);
681:
682: hr_utility.trace('l_opt_phone= ' || l_opt_phone);
683: hr_utility.trace('p_multi_state= ' || p_multi_state);
684: hr_utility.set_location(l_api_name,30);
685:
686: --

Line 683: hr_utility.trace('p_multi_state= ' || p_multi_state);

679:
680: l_opt_phone := replace(replace(replace(replace(replace(nvl(p_opt_phone,' '),'(',null),'-',null),'.',null),')',null),' ',null);
681:
682: hr_utility.trace('l_opt_phone= ' || l_opt_phone);
683: hr_utility.trace('p_multi_state= ' || p_multi_state);
684: hr_utility.set_location(l_api_name,30);
685:
686: --
687: -- format new hire rocord

Line 684: hr_utility.set_location(l_api_name,30);

680: l_opt_phone := replace(replace(replace(replace(replace(nvl(p_opt_phone,' '),'(',null),'-',null),'.',null),')',null),' ',null);
681:
682: hr_utility.trace('l_opt_phone= ' || l_opt_phone);
683: hr_utility.trace('p_multi_state= ' || p_multi_state);
684: hr_utility.set_location(l_api_name,30);
685:
686: --
687: -- format new hire rocord
688: --

Line 737: hr_utility.set_location('Leaving.... :' || l_api_name,40);

733: rpad(nvl(p_multi_state,' '),1,' ') ||
734: rpad(' ',30,' '); -- filler blank 30
735:
736:
737: hr_utility.set_location('Leaving.... :' || l_api_name,40);
738:
739: return convert(l_buffer,g_character_set);
740: exception
741: when others then

Line 742: hr_utility.set_location('Leaving.... with ERROR :' || l_api_name,200);

738:
739: return convert(l_buffer,g_character_set);
740: exception
741: when others then
742: hr_utility.set_location('Leaving.... with ERROR :' || l_api_name,200);
743: raise;
744: end fl_new_hire_record;
745: --
746: /****************************************************************

Line 786: hr_utility.set_location('Entering...: ' ||l_api_name,10);

782: l_buffer varchar2(2000);
783: v_ssn varchar(9);
784: begin
785:
786: hr_utility.set_location('Entering...: ' ||l_api_name,10);
787:
788: hr_utility.trace('p_record_identifier= ' ||p_record_identifier);
789: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
790:

Line 788: hr_utility.trace('p_record_identifier= ' ||p_record_identifier);

784: begin
785:
786: hr_utility.set_location('Entering...: ' ||l_api_name,10);
787:
788: hr_utility.trace('p_record_identifier= ' ||p_record_identifier);
789: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
790:
791: hr_utility.trace('v_ssn= ' ||v_ssn);
792:

Line 791: hr_utility.trace('v_ssn= ' ||v_ssn);

787:
788: hr_utility.trace('p_record_identifier= ' ||p_record_identifier);
789: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
790:
791: hr_utility.trace('v_ssn= ' ||v_ssn);
792:
793: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
794: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
795: hr_utility.trace('p_emp_city= ' || p_emp_city);

Line 793: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);

789: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
790:
791: hr_utility.trace('v_ssn= ' ||v_ssn);
792:
793: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
794: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
795: hr_utility.trace('p_emp_city= ' || p_emp_city);
796: hr_utility.trace('p_emp_state= ' || p_emp_state);
797: hr_utility.trace('p_emp_zip= ' || p_emp_zip);

Line 794: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);

790:
791: hr_utility.trace('v_ssn= ' ||v_ssn);
792:
793: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
794: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
795: hr_utility.trace('p_emp_city= ' || p_emp_city);
796: hr_utility.trace('p_emp_state= ' || p_emp_state);
797: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
798: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);

Line 795: hr_utility.trace('p_emp_city= ' || p_emp_city);

791: hr_utility.trace('v_ssn= ' ||v_ssn);
792:
793: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
794: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
795: hr_utility.trace('p_emp_city= ' || p_emp_city);
796: hr_utility.trace('p_emp_state= ' || p_emp_state);
797: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
798: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
799: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);

Line 796: hr_utility.trace('p_emp_state= ' || p_emp_state);

792:
793: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
794: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
795: hr_utility.trace('p_emp_city= ' || p_emp_city);
796: hr_utility.trace('p_emp_state= ' || p_emp_state);
797: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
798: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
799: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
800:

Line 797: hr_utility.trace('p_emp_zip= ' || p_emp_zip);

793: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
794: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
795: hr_utility.trace('p_emp_city= ' || p_emp_city);
796: hr_utility.trace('p_emp_state= ' || p_emp_state);
797: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
798: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
799: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
800:
801: hr_utility.trace('p_federal_id= ' || p_federal_id);

Line 798: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);

794: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
795: hr_utility.trace('p_emp_city= ' || p_emp_city);
796: hr_utility.trace('p_emp_state= ' || p_emp_state);
797: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
798: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
799: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
800:
801: hr_utility.trace('p_federal_id= ' || p_federal_id);
802: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);

Line 799: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);

795: hr_utility.trace('p_emp_city= ' || p_emp_city);
796: hr_utility.trace('p_emp_state= ' || p_emp_state);
797: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
798: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
799: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
800:
801: hr_utility.trace('p_federal_id= ' || p_federal_id);
802: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
803: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);

Line 801: hr_utility.trace('p_federal_id= ' || p_federal_id);

797: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
798: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
799: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
800:
801: hr_utility.trace('p_federal_id= ' || p_federal_id);
802: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
803: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
804: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
805: hr_utility.trace('p_loc_city= ' || p_loc_city);

Line 802: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);

798: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
799: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
800:
801: hr_utility.trace('p_federal_id= ' || p_federal_id);
802: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
803: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
804: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
805: hr_utility.trace('p_loc_city= ' || p_loc_city);
806: hr_utility.trace('p_loc_state= ' || p_loc_state);

Line 803: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);

799: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
800:
801: hr_utility.trace('p_federal_id= ' || p_federal_id);
802: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
803: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
804: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
805: hr_utility.trace('p_loc_city= ' || p_loc_city);
806: hr_utility.trace('p_loc_state= ' || p_loc_state);
807: hr_utility.trace('p_loc_zip= ' || p_loc_zip);

Line 804: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);

800:
801: hr_utility.trace('p_federal_id= ' || p_federal_id);
802: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
803: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
804: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
805: hr_utility.trace('p_loc_city= ' || p_loc_city);
806: hr_utility.trace('p_loc_state= ' || p_loc_state);
807: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
808: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);

Line 805: hr_utility.trace('p_loc_city= ' || p_loc_city);

801: hr_utility.trace('p_federal_id= ' || p_federal_id);
802: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
803: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
804: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
805: hr_utility.trace('p_loc_city= ' || p_loc_city);
806: hr_utility.trace('p_loc_state= ' || p_loc_state);
807: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
808: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
809:

Line 806: hr_utility.trace('p_loc_state= ' || p_loc_state);

802: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
803: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
804: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
805: hr_utility.trace('p_loc_city= ' || p_loc_city);
806: hr_utility.trace('p_loc_state= ' || p_loc_state);
807: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
808: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
809:
810: hr_utility.set_location(l_api_name,30);

Line 807: hr_utility.trace('p_loc_zip= ' || p_loc_zip);

803: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
804: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
805: hr_utility.trace('p_loc_city= ' || p_loc_city);
806: hr_utility.trace('p_loc_state= ' || p_loc_state);
807: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
808: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
809:
810: hr_utility.set_location(l_api_name,30);
811: --

Line 808: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);

804: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
805: hr_utility.trace('p_loc_city= ' || p_loc_city);
806: hr_utility.trace('p_loc_state= ' || p_loc_state);
807: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
808: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
809:
810: hr_utility.set_location(l_api_name,30);
811: --
812: -- format new hire rocord

Line 810: hr_utility.set_location(l_api_name,30);

806: hr_utility.trace('p_loc_state= ' || p_loc_state);
807: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
808: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
809:
810: hr_utility.set_location(l_api_name,30);
811: --
812: -- format new hire rocord
813: --
814: l_buffer := p_record_identifier || -- 'W4'

Line 853: hr_utility.set_location('Leaving.... :' || l_api_name,100);

849: rpad(' ',50,' ') ;
850:
851:
852:
853: hr_utility.set_location('Leaving.... :' || l_api_name,100);
854:
855: return convert(l_buffer,g_character_set);
856: exception
857: when others then

Line 858: hr_utility.set_location('Leaving.... :' || l_api_name,200);

854:
855: return convert(l_buffer,g_character_set);
856: exception
857: when others then
858: hr_utility.set_location('Leaving.... :' || l_api_name,200);
859: raise;
860: end il_new_hire_record;
861:
862: -- sjawid al

Line 939: hr_utility.set_location('Entering:' ||l_api_name,10);

935: l_api_name varchar2(61) := g_package_name || '.tx_t4_record';
936: l_buffer varchar2(2000);
937: begin
938: --
939: hr_utility.set_location('Entering:' ||l_api_name,10);
940:
941: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
942: hr_utility.trace('p_number_of_emplyee = ' || p_number_of_employee);
943:

Line 941: hr_utility.trace('p_record_identifier= ' || p_record_identifier);

937: begin
938: --
939: hr_utility.set_location('Entering:' ||l_api_name,10);
940:
941: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
942: hr_utility.trace('p_number_of_emplyee = ' || p_number_of_employee);
943:
944: --
945: -- format new hire rocord

Line 942: hr_utility.trace('p_number_of_emplyee = ' || p_number_of_employee);

938: --
939: hr_utility.set_location('Entering:' ||l_api_name,10);
940:
941: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
942: hr_utility.trace('p_number_of_emplyee = ' || p_number_of_employee);
943:
944: --
945: -- format new hire rocord
946: --

Line 952: hr_utility.set_location(l_api_name,20);

948: p_record_identifier ||
949: lpad(to_char(p_number_of_employee),11,'0') ||
950: lpad(' ',788,' '));
951:
952: hr_utility.set_location(l_api_name,20);
953:
954: return convert(l_buffer,g_character_set);
955: exception
956: when others then

Line 957: hr_utility.set_location('Leaving.... :' || l_api_name,30);

953:
954: return convert(l_buffer,g_character_set);
955: exception
956: when others then
957: hr_utility.set_location('Leaving.... :' || l_api_name,30);
958: raise;
959: end tx_t4_record;
960: --
961: /****************************************************************

Line 1017: hr_utility.set_location('Entering...: ' || l_api_name,10);

1013: l_buffer varchar2(2000);
1014: v_ssn varchar(9);
1015: begin
1016:
1017: hr_utility.set_location('Entering...: ' || l_api_name,10);
1018:
1019: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
1020: hr_utility.trace('p_federal_id= ' || p_federal_id);
1021: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);

Line 1019: hr_utility.trace('p_record_identifier= ' || p_record_identifier);

1015: begin
1016:
1017: hr_utility.set_location('Entering...: ' || l_api_name,10);
1018:
1019: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
1020: hr_utility.trace('p_federal_id= ' || p_federal_id);
1021: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1022: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1023:

Line 1020: hr_utility.trace('p_federal_id= ' || p_federal_id);

1016:
1017: hr_utility.set_location('Entering...: ' || l_api_name,10);
1018:
1019: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
1020: hr_utility.trace('p_federal_id= ' || p_federal_id);
1021: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1022: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1023:
1024: hr_utility.trace('v_ssn= ' || v_ssn);

Line 1021: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);

1017: hr_utility.set_location('Entering...: ' || l_api_name,10);
1018:
1019: hr_utility.trace('p_record_identifier= ' || p_record_identifier);
1020: hr_utility.trace('p_federal_id= ' || p_federal_id);
1021: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1022: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1023:
1024: hr_utility.trace('v_ssn= ' || v_ssn);
1025: hr_utility.trace('p_first_name = ' || p_first_name);

Line 1024: hr_utility.trace('v_ssn= ' || v_ssn);

1020: hr_utility.trace('p_federal_id= ' || p_federal_id);
1021: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1022: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1023:
1024: hr_utility.trace('v_ssn= ' || v_ssn);
1025: hr_utility.trace('p_first_name = ' || p_first_name);
1026: hr_utility.trace('p_middle_name = ' || p_middle_name);
1027: hr_utility.trace('p_last_name = ' || p_last_name);
1028: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);

Line 1025: hr_utility.trace('p_first_name = ' || p_first_name);

1021: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1022: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1023:
1024: hr_utility.trace('v_ssn= ' || v_ssn);
1025: hr_utility.trace('p_first_name = ' || p_first_name);
1026: hr_utility.trace('p_middle_name = ' || p_middle_name);
1027: hr_utility.trace('p_last_name = ' || p_last_name);
1028: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1029: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);

Line 1026: hr_utility.trace('p_middle_name = ' || p_middle_name);

1022: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1023:
1024: hr_utility.trace('v_ssn= ' || v_ssn);
1025: hr_utility.trace('p_first_name = ' || p_first_name);
1026: hr_utility.trace('p_middle_name = ' || p_middle_name);
1027: hr_utility.trace('p_last_name = ' || p_last_name);
1028: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1029: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1030: hr_utility.trace('p_emp_city= ' || p_emp_city);

Line 1027: hr_utility.trace('p_last_name = ' || p_last_name);

1023:
1024: hr_utility.trace('v_ssn= ' || v_ssn);
1025: hr_utility.trace('p_first_name = ' || p_first_name);
1026: hr_utility.trace('p_middle_name = ' || p_middle_name);
1027: hr_utility.trace('p_last_name = ' || p_last_name);
1028: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1029: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1030: hr_utility.trace('p_emp_city= ' || p_emp_city);
1031: hr_utility.trace('p_emp_state= ' || p_emp_state);

Line 1028: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);

1024: hr_utility.trace('v_ssn= ' || v_ssn);
1025: hr_utility.trace('p_first_name = ' || p_first_name);
1026: hr_utility.trace('p_middle_name = ' || p_middle_name);
1027: hr_utility.trace('p_last_name = ' || p_last_name);
1028: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1029: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1030: hr_utility.trace('p_emp_city= ' || p_emp_city);
1031: hr_utility.trace('p_emp_state= ' || p_emp_state);
1032: hr_utility.trace('p_emp_zip= ' || p_emp_zip);

Line 1029: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);

1025: hr_utility.trace('p_first_name = ' || p_first_name);
1026: hr_utility.trace('p_middle_name = ' || p_middle_name);
1027: hr_utility.trace('p_last_name = ' || p_last_name);
1028: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1029: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1030: hr_utility.trace('p_emp_city= ' || p_emp_city);
1031: hr_utility.trace('p_emp_state= ' || p_emp_state);
1032: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1033: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);

Line 1030: hr_utility.trace('p_emp_city= ' || p_emp_city);

1026: hr_utility.trace('p_middle_name = ' || p_middle_name);
1027: hr_utility.trace('p_last_name = ' || p_last_name);
1028: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1029: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1030: hr_utility.trace('p_emp_city= ' || p_emp_city);
1031: hr_utility.trace('p_emp_state= ' || p_emp_state);
1032: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1033: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1034: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);

Line 1031: hr_utility.trace('p_emp_state= ' || p_emp_state);

1027: hr_utility.trace('p_last_name = ' || p_last_name);
1028: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1029: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1030: hr_utility.trace('p_emp_city= ' || p_emp_city);
1031: hr_utility.trace('p_emp_state= ' || p_emp_state);
1032: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1033: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1034: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
1035: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);

Line 1032: hr_utility.trace('p_emp_zip= ' || p_emp_zip);

1028: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1029: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1030: hr_utility.trace('p_emp_city= ' || p_emp_city);
1031: hr_utility.trace('p_emp_state= ' || p_emp_state);
1032: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1033: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1034: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
1035: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1036: hr_utility.trace('p_state_of_hire= ' || p_state_of_hire);

Line 1033: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);

1029: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1030: hr_utility.trace('p_emp_city= ' || p_emp_city);
1031: hr_utility.trace('p_emp_state= ' || p_emp_state);
1032: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1033: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1034: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
1035: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1036: hr_utility.trace('p_state_of_hire= ' || p_state_of_hire);
1037:

Line 1034: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);

1030: hr_utility.trace('p_emp_city= ' || p_emp_city);
1031: hr_utility.trace('p_emp_state= ' || p_emp_state);
1032: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1033: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1034: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
1035: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1036: hr_utility.trace('p_state_of_hire= ' || p_state_of_hire);
1037:
1038: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);

Line 1035: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);

1031: hr_utility.trace('p_emp_state= ' || p_emp_state);
1032: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1033: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1034: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
1035: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1036: hr_utility.trace('p_state_of_hire= ' || p_state_of_hire);
1037:
1038: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
1039: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);

Line 1036: hr_utility.trace('p_state_of_hire= ' || p_state_of_hire);

1032: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1033: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1034: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
1035: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1036: hr_utility.trace('p_state_of_hire= ' || p_state_of_hire);
1037:
1038: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
1039: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
1040: hr_utility.trace('p_loc_address_line3= ' || p_loc_address_line3);

Line 1038: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);

1034: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
1035: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1036: hr_utility.trace('p_state_of_hire= ' || p_state_of_hire);
1037:
1038: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
1039: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
1040: hr_utility.trace('p_loc_address_line3= ' || p_loc_address_line3);
1041: hr_utility.trace('p_loc_city= ' || p_loc_city);
1042: hr_utility.trace('p_loc_state= ' || p_loc_state);

Line 1039: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);

1035: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1036: hr_utility.trace('p_state_of_hire= ' || p_state_of_hire);
1037:
1038: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
1039: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
1040: hr_utility.trace('p_loc_address_line3= ' || p_loc_address_line3);
1041: hr_utility.trace('p_loc_city= ' || p_loc_city);
1042: hr_utility.trace('p_loc_state= ' || p_loc_state);
1043: hr_utility.trace('p_loc_zip= ' || p_loc_zip);

Line 1040: hr_utility.trace('p_loc_address_line3= ' || p_loc_address_line3);

1036: hr_utility.trace('p_state_of_hire= ' || p_state_of_hire);
1037:
1038: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
1039: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
1040: hr_utility.trace('p_loc_address_line3= ' || p_loc_address_line3);
1041: hr_utility.trace('p_loc_city= ' || p_loc_city);
1042: hr_utility.trace('p_loc_state= ' || p_loc_state);
1043: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
1044: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);

Line 1041: hr_utility.trace('p_loc_city= ' || p_loc_city);

1037:
1038: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
1039: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
1040: hr_utility.trace('p_loc_address_line3= ' || p_loc_address_line3);
1041: hr_utility.trace('p_loc_city= ' || p_loc_city);
1042: hr_utility.trace('p_loc_state= ' || p_loc_state);
1043: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
1044: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
1045:

Line 1042: hr_utility.trace('p_loc_state= ' || p_loc_state);

1038: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
1039: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
1040: hr_utility.trace('p_loc_address_line3= ' || p_loc_address_line3);
1041: hr_utility.trace('p_loc_city= ' || p_loc_city);
1042: hr_utility.trace('p_loc_state= ' || p_loc_state);
1043: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
1044: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
1045:
1046: hr_utility.trace('p_salary= ' || p_salary);

Line 1043: hr_utility.trace('p_loc_zip= ' || p_loc_zip);

1039: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
1040: hr_utility.trace('p_loc_address_line3= ' || p_loc_address_line3);
1041: hr_utility.trace('p_loc_city= ' || p_loc_city);
1042: hr_utility.trace('p_loc_state= ' || p_loc_state);
1043: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
1044: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
1045:
1046: hr_utility.trace('p_salary= ' || p_salary);
1047: hr_utility.trace('p_frequency= ' || p_frequency);

Line 1044: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);

1040: hr_utility.trace('p_loc_address_line3= ' || p_loc_address_line3);
1041: hr_utility.trace('p_loc_city= ' || p_loc_city);
1042: hr_utility.trace('p_loc_state= ' || p_loc_state);
1043: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
1044: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
1045:
1046: hr_utility.trace('p_salary= ' || p_salary);
1047: hr_utility.trace('p_frequency= ' || p_frequency);
1048:

Line 1046: hr_utility.trace('p_salary= ' || p_salary);

1042: hr_utility.trace('p_loc_state= ' || p_loc_state);
1043: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
1044: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
1045:
1046: hr_utility.trace('p_salary= ' || p_salary);
1047: hr_utility.trace('p_frequency= ' || p_frequency);
1048:
1049: hr_utility.set_location(l_api_name,30);
1050:

Line 1047: hr_utility.trace('p_frequency= ' || p_frequency);

1043: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
1044: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
1045:
1046: hr_utility.trace('p_salary= ' || p_salary);
1047: hr_utility.trace('p_frequency= ' || p_frequency);
1048:
1049: hr_utility.set_location(l_api_name,30);
1050:
1051: --

Line 1049: hr_utility.set_location(l_api_name,30);

1045:
1046: hr_utility.trace('p_salary= ' || p_salary);
1047: hr_utility.trace('p_frequency= ' || p_frequency);
1048:
1049: hr_utility.set_location(l_api_name,30);
1050:
1051: --
1052: -- format new hire rocord
1053: --

Line 1102: hr_utility.set_location('Leaving.... :' || l_api_name,100);

1098: ' ' || -- rpad(nvl(p_frequency,' '),1,' ') ||
1099: rpad(' ',30,' ')) ;
1100:
1101:
1102: hr_utility.set_location('Leaving.... :' || l_api_name,100);
1103:
1104:
1105: return convert(l_buffer,g_character_set);
1106: exception

Line 1108: hr_utility.set_location('Leaving.... :' || l_api_name,200);

1104:
1105: return convert(l_buffer,g_character_set);
1106: exception
1107: when others then
1108: hr_utility.set_location('Leaving.... :' || l_api_name,200);
1109: raise;
1110: end tx_new_hire_record;
1111: --
1112: /****************************************************************

Line 1124: hr_utility.set_location('Entering...: ' || l_api_name,10);

1120: l_api_name varchar2(61) := g_package_name || '.a03_fl_new_hire_header';
1121: l_buffer varchar2(2000);
1122: begin
1123: --
1124: hr_utility.set_location('Entering...: ' || l_api_name,10);
1125: l_buffer := 'First Name' || g_delimiter ||
1126: 'Middle Name' || g_delimiter ||
1127: 'Last Name' || g_delimiter ||
1128: 'Social Security Number' || g_delimiter ||

Line 1156: hr_utility.set_location('Leaving.... :' || l_api_name,100);

1152: 'Employer Contact' || g_delimiter ||
1153: 'Multi-State Indicator' ||
1154: g_eol;
1155:
1156: hr_utility.set_location('Leaving.... :' || l_api_name,100);
1157:
1158: return l_buffer;
1159: exception
1160: when others then

Line 1161: hr_utility.set_location('Leaving.... :' || l_api_name,200);

1157:
1158: return l_buffer;
1159: exception
1160: when others then
1161: hr_utility.set_location('Leaving.... :' || l_api_name,200);
1162: raise;
1163: end a03_fl_new_hire_header;
1164: --
1165: /****************************************************************

Line 1209: hr_utility.set_location('Entering...: ' || l_api_name,10);

1205: l_buffer varchar2(2000);
1206: v_ssn varchar(9);
1207: begin
1208:
1209: hr_utility.set_location('Entering...: ' || l_api_name,10);
1210:
1211: hr_utility.trace('p_federal_id= ' || p_federal_id);
1212: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1213: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);

Line 1211: hr_utility.trace('p_federal_id= ' || p_federal_id);

1207: begin
1208:
1209: hr_utility.set_location('Entering...: ' || l_api_name,10);
1210:
1211: hr_utility.trace('p_federal_id= ' || p_federal_id);
1212: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1213: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1214:
1215: hr_utility.trace('v_ssn= ' || v_ssn);

Line 1212: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);

1208:
1209: hr_utility.set_location('Entering...: ' || l_api_name,10);
1210:
1211: hr_utility.trace('p_federal_id= ' || p_federal_id);
1212: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1213: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1214:
1215: hr_utility.trace('v_ssn= ' || v_ssn);
1216: hr_utility.trace('p_first_name= ' || p_first_name);

Line 1215: hr_utility.trace('v_ssn= ' || v_ssn);

1211: hr_utility.trace('p_federal_id= ' || p_federal_id);
1212: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1213: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1214:
1215: hr_utility.trace('v_ssn= ' || v_ssn);
1216: hr_utility.trace('p_first_name= ' || p_first_name);
1217: hr_utility.trace('p_middle_name= ' || p_middle_name);
1218: hr_utility.trace('p_last_name= ' || p_last_name);
1219: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);

Line 1216: hr_utility.trace('p_first_name= ' || p_first_name);

1212: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1213: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1214:
1215: hr_utility.trace('v_ssn= ' || v_ssn);
1216: hr_utility.trace('p_first_name= ' || p_first_name);
1217: hr_utility.trace('p_middle_name= ' || p_middle_name);
1218: hr_utility.trace('p_last_name= ' || p_last_name);
1219: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1220: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);

Line 1217: hr_utility.trace('p_middle_name= ' || p_middle_name);

1213: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1214:
1215: hr_utility.trace('v_ssn= ' || v_ssn);
1216: hr_utility.trace('p_first_name= ' || p_first_name);
1217: hr_utility.trace('p_middle_name= ' || p_middle_name);
1218: hr_utility.trace('p_last_name= ' || p_last_name);
1219: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1220: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1221: hr_utility.trace('p_emp_city= ' || p_emp_city);

Line 1218: hr_utility.trace('p_last_name= ' || p_last_name);

1214:
1215: hr_utility.trace('v_ssn= ' || v_ssn);
1216: hr_utility.trace('p_first_name= ' || p_first_name);
1217: hr_utility.trace('p_middle_name= ' || p_middle_name);
1218: hr_utility.trace('p_last_name= ' || p_last_name);
1219: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1220: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1221: hr_utility.trace('p_emp_city= ' || p_emp_city);
1222: hr_utility.trace('p_emp_state= ' || p_emp_state);

Line 1219: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);

1215: hr_utility.trace('v_ssn= ' || v_ssn);
1216: hr_utility.trace('p_first_name= ' || p_first_name);
1217: hr_utility.trace('p_middle_name= ' || p_middle_name);
1218: hr_utility.trace('p_last_name= ' || p_last_name);
1219: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1220: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1221: hr_utility.trace('p_emp_city= ' || p_emp_city);
1222: hr_utility.trace('p_emp_state= ' || p_emp_state);
1223: hr_utility.trace('p_emp_zip= ' || p_emp_zip);

Line 1220: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);

1216: hr_utility.trace('p_first_name= ' || p_first_name);
1217: hr_utility.trace('p_middle_name= ' || p_middle_name);
1218: hr_utility.trace('p_last_name= ' || p_last_name);
1219: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1220: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1221: hr_utility.trace('p_emp_city= ' || p_emp_city);
1222: hr_utility.trace('p_emp_state= ' || p_emp_state);
1223: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1224: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);

Line 1221: hr_utility.trace('p_emp_city= ' || p_emp_city);

1217: hr_utility.trace('p_middle_name= ' || p_middle_name);
1218: hr_utility.trace('p_last_name= ' || p_last_name);
1219: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1220: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1221: hr_utility.trace('p_emp_city= ' || p_emp_city);
1222: hr_utility.trace('p_emp_state= ' || p_emp_state);
1223: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1224: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1225: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);

Line 1222: hr_utility.trace('p_emp_state= ' || p_emp_state);

1218: hr_utility.trace('p_last_name= ' || p_last_name);
1219: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1220: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1221: hr_utility.trace('p_emp_city= ' || p_emp_city);
1222: hr_utility.trace('p_emp_state= ' || p_emp_state);
1223: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1224: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1225: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
1226: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);

Line 1223: hr_utility.trace('p_emp_zip= ' || p_emp_zip);

1219: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1220: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1221: hr_utility.trace('p_emp_city= ' || p_emp_city);
1222: hr_utility.trace('p_emp_state= ' || p_emp_state);
1223: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1224: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1225: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
1226: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1227:

Line 1224: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);

1220: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1221: hr_utility.trace('p_emp_city= ' || p_emp_city);
1222: hr_utility.trace('p_emp_state= ' || p_emp_state);
1223: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1224: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1225: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
1226: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1227:
1228: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);

Line 1225: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);

1221: hr_utility.trace('p_emp_city= ' || p_emp_city);
1222: hr_utility.trace('p_emp_state= ' || p_emp_state);
1223: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1224: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1225: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
1226: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1227:
1228: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
1229: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);

Line 1226: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);

1222: hr_utility.trace('p_emp_state= ' || p_emp_state);
1223: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1224: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1225: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
1226: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1227:
1228: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
1229: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
1230: hr_utility.trace('p_loc_city= ' || p_loc_city);

Line 1228: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);

1224: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1225: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
1226: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1227:
1228: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
1229: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
1230: hr_utility.trace('p_loc_city= ' || p_loc_city);
1231: hr_utility.trace('p_loc_state= ' || p_loc_state);
1232: hr_utility.trace('p_loc_zip= ' || p_loc_zip);

Line 1229: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);

1225: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
1226: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1227:
1228: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
1229: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
1230: hr_utility.trace('p_loc_city= ' || p_loc_city);
1231: hr_utility.trace('p_loc_state= ' || p_loc_state);
1232: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
1233: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);

Line 1230: hr_utility.trace('p_loc_city= ' || p_loc_city);

1226: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1227:
1228: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
1229: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
1230: hr_utility.trace('p_loc_city= ' || p_loc_city);
1231: hr_utility.trace('p_loc_state= ' || p_loc_state);
1232: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
1233: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
1234: hr_utility.trace('p_contact_phone = ' || p_contact_phone);

Line 1231: hr_utility.trace('p_loc_state= ' || p_loc_state);

1227:
1228: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
1229: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
1230: hr_utility.trace('p_loc_city= ' || p_loc_city);
1231: hr_utility.trace('p_loc_state= ' || p_loc_state);
1232: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
1233: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
1234: hr_utility.trace('p_contact_phone = ' || p_contact_phone);
1235: hr_utility.trace('p_contact_name = ' || p_contact_name);

Line 1232: hr_utility.trace('p_loc_zip= ' || p_loc_zip);

1228: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
1229: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
1230: hr_utility.trace('p_loc_city= ' || p_loc_city);
1231: hr_utility.trace('p_loc_state= ' || p_loc_state);
1232: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
1233: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
1234: hr_utility.trace('p_contact_phone = ' || p_contact_phone);
1235: hr_utility.trace('p_contact_name = ' || p_contact_name);
1236:

Line 1233: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);

1229: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
1230: hr_utility.trace('p_loc_city= ' || p_loc_city);
1231: hr_utility.trace('p_loc_state= ' || p_loc_state);
1232: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
1233: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
1234: hr_utility.trace('p_contact_phone = ' || p_contact_phone);
1235: hr_utility.trace('p_contact_name = ' || p_contact_name);
1236:
1237:

Line 1234: hr_utility.trace('p_contact_phone = ' || p_contact_phone);

1230: hr_utility.trace('p_loc_city= ' || p_loc_city);
1231: hr_utility.trace('p_loc_state= ' || p_loc_state);
1232: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
1233: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
1234: hr_utility.trace('p_contact_phone = ' || p_contact_phone);
1235: hr_utility.trace('p_contact_name = ' || p_contact_name);
1236:
1237:
1238: hr_utility.set_location(l_api_name,30);

Line 1235: hr_utility.trace('p_contact_name = ' || p_contact_name);

1231: hr_utility.trace('p_loc_state= ' || p_loc_state);
1232: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
1233: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
1234: hr_utility.trace('p_contact_phone = ' || p_contact_phone);
1235: hr_utility.trace('p_contact_name = ' || p_contact_name);
1236:
1237:
1238: hr_utility.set_location(l_api_name,30);
1239:

Line 1238: hr_utility.set_location(l_api_name,30);

1234: hr_utility.trace('p_contact_phone = ' || p_contact_phone);
1235: hr_utility.trace('p_contact_name = ' || p_contact_name);
1236:
1237:
1238: hr_utility.set_location(l_api_name,30);
1239:
1240: --
1241: -- format new hire rocord
1242: --

Line 1274: hr_utility.set_location('Leaving.... :' || l_api_name,100);

1270: replace(nvl(p_contact_name,' '),',',' ') || g_delimiter ||
1271: nvl(p_multi_state,' ') ||
1272: g_eol;
1273:
1274: hr_utility.set_location('Leaving.... :' || l_api_name,100);
1275:
1276: return l_buffer;
1277: exception
1278: when others then

Line 1279: hr_utility.set_location('Leaving.... :' || l_api_name,200);

1275:
1276: return l_buffer;
1277: exception
1278: when others then
1279: hr_utility.set_location('Leaving.... :' || l_api_name,200);
1280: raise;
1281: end a03_fl_new_hire_record;
1282: --
1283:

Line 1293: hr_utility.set_location('Entering...: ' || l_api_name,10);

1289: l_api_name varchar2(61) := g_package_name || '.a03_al_new_hire_header';
1290: l_buffer varchar2(2000);
1291: begin
1292: --
1293: hr_utility.set_location('Entering...: ' || l_api_name,10);
1294: l_buffer := 'First Name' || g_delimiter ||
1295: 'Middle Name' || g_delimiter ||
1296: 'Last Name' || g_delimiter ||
1297: 'Social Security Number' || g_delimiter ||

Line 1325: hr_utility.set_location('Leaving.... :' || l_api_name,100);

1321: 'Employer Contact' || g_delimiter ||
1322: 'Multi-State Indicator' ||
1323: g_eol;
1324:
1325: hr_utility.set_location('Leaving.... :' || l_api_name,100);
1326:
1327: return l_buffer;
1328: exception
1329: when others then

Line 1330: hr_utility.set_location('Leaving.... :' || l_api_name,200);

1326:
1327: return l_buffer;
1328: exception
1329: when others then
1330: hr_utility.set_location('Leaving.... :' || l_api_name,200);
1331: raise;
1332: end a03_al_new_hire_header;
1333:
1334:

Line 1374: hr_utility.set_location('Entering...: ' || l_api_name,10);

1370: l_buffer varchar2(2000);
1371: v_ssn varchar(9);
1372: begin
1373:
1374: hr_utility.set_location('Entering...: ' || l_api_name,10);
1375:
1376: hr_utility.trace('p_federal_id= ' || p_federal_id);
1377: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1378: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);

Line 1376: hr_utility.trace('p_federal_id= ' || p_federal_id);

1372: begin
1373:
1374: hr_utility.set_location('Entering...: ' || l_api_name,10);
1375:
1376: hr_utility.trace('p_federal_id= ' || p_federal_id);
1377: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1378: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1379:
1380: hr_utility.trace('v_ssn= ' || v_ssn);

Line 1377: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);

1373:
1374: hr_utility.set_location('Entering...: ' || l_api_name,10);
1375:
1376: hr_utility.trace('p_federal_id= ' || p_federal_id);
1377: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1378: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1379:
1380: hr_utility.trace('v_ssn= ' || v_ssn);
1381: hr_utility.trace('p_first_name= ' || p_first_name);

Line 1380: hr_utility.trace('v_ssn= ' || v_ssn);

1376: hr_utility.trace('p_federal_id= ' || p_federal_id);
1377: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1378: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1379:
1380: hr_utility.trace('v_ssn= ' || v_ssn);
1381: hr_utility.trace('p_first_name= ' || p_first_name);
1382: hr_utility.trace('p_middle_name= ' || p_middle_name);
1383: hr_utility.trace('p_last_name= ' || p_last_name);
1384: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);

Line 1381: hr_utility.trace('p_first_name= ' || p_first_name);

1377: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1378: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1379:
1380: hr_utility.trace('v_ssn= ' || v_ssn);
1381: hr_utility.trace('p_first_name= ' || p_first_name);
1382: hr_utility.trace('p_middle_name= ' || p_middle_name);
1383: hr_utility.trace('p_last_name= ' || p_last_name);
1384: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1385: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);

Line 1382: hr_utility.trace('p_middle_name= ' || p_middle_name);

1378: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1379:
1380: hr_utility.trace('v_ssn= ' || v_ssn);
1381: hr_utility.trace('p_first_name= ' || p_first_name);
1382: hr_utility.trace('p_middle_name= ' || p_middle_name);
1383: hr_utility.trace('p_last_name= ' || p_last_name);
1384: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1385: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1386: hr_utility.trace('p_emp_city= ' || p_emp_city);

Line 1383: hr_utility.trace('p_last_name= ' || p_last_name);

1379:
1380: hr_utility.trace('v_ssn= ' || v_ssn);
1381: hr_utility.trace('p_first_name= ' || p_first_name);
1382: hr_utility.trace('p_middle_name= ' || p_middle_name);
1383: hr_utility.trace('p_last_name= ' || p_last_name);
1384: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1385: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1386: hr_utility.trace('p_emp_city= ' || p_emp_city);
1387: hr_utility.trace('p_emp_state= ' || p_emp_state);

Line 1384: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);

1380: hr_utility.trace('v_ssn= ' || v_ssn);
1381: hr_utility.trace('p_first_name= ' || p_first_name);
1382: hr_utility.trace('p_middle_name= ' || p_middle_name);
1383: hr_utility.trace('p_last_name= ' || p_last_name);
1384: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1385: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1386: hr_utility.trace('p_emp_city= ' || p_emp_city);
1387: hr_utility.trace('p_emp_state= ' || p_emp_state);
1388: hr_utility.trace('p_emp_zip= ' || p_emp_zip);

Line 1385: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);

1381: hr_utility.trace('p_first_name= ' || p_first_name);
1382: hr_utility.trace('p_middle_name= ' || p_middle_name);
1383: hr_utility.trace('p_last_name= ' || p_last_name);
1384: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1385: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1386: hr_utility.trace('p_emp_city= ' || p_emp_city);
1387: hr_utility.trace('p_emp_state= ' || p_emp_state);
1388: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1389: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);

Line 1386: hr_utility.trace('p_emp_city= ' || p_emp_city);

1382: hr_utility.trace('p_middle_name= ' || p_middle_name);
1383: hr_utility.trace('p_last_name= ' || p_last_name);
1384: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1385: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1386: hr_utility.trace('p_emp_city= ' || p_emp_city);
1387: hr_utility.trace('p_emp_state= ' || p_emp_state);
1388: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1389: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1390: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);

Line 1387: hr_utility.trace('p_emp_state= ' || p_emp_state);

1383: hr_utility.trace('p_last_name= ' || p_last_name);
1384: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1385: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1386: hr_utility.trace('p_emp_city= ' || p_emp_city);
1387: hr_utility.trace('p_emp_state= ' || p_emp_state);
1388: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1389: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1390: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
1391: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);

Line 1388: hr_utility.trace('p_emp_zip= ' || p_emp_zip);

1384: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1385: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1386: hr_utility.trace('p_emp_city= ' || p_emp_city);
1387: hr_utility.trace('p_emp_state= ' || p_emp_state);
1388: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1389: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1390: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
1391: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1392:

Line 1389: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);

1385: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1386: hr_utility.trace('p_emp_city= ' || p_emp_city);
1387: hr_utility.trace('p_emp_state= ' || p_emp_state);
1388: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1389: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1390: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
1391: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1392:
1393: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);

Line 1390: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);

1386: hr_utility.trace('p_emp_city= ' || p_emp_city);
1387: hr_utility.trace('p_emp_state= ' || p_emp_state);
1388: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1389: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1390: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
1391: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1392:
1393: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
1394: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);

Line 1391: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);

1387: hr_utility.trace('p_emp_state= ' || p_emp_state);
1388: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1389: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1390: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
1391: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1392:
1393: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
1394: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
1395: hr_utility.trace('p_loc_city= ' || p_loc_city);

Line 1393: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);

1389: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1390: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
1391: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1392:
1393: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
1394: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
1395: hr_utility.trace('p_loc_city= ' || p_loc_city);
1396: hr_utility.trace('p_loc_state= ' || p_loc_state);
1397: hr_utility.trace('p_loc_zip= ' || p_loc_zip);

Line 1394: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);

1390: hr_utility.trace('p_date_of_birth= ' || p_date_of_birth);
1391: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1392:
1393: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
1394: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
1395: hr_utility.trace('p_loc_city= ' || p_loc_city);
1396: hr_utility.trace('p_loc_state= ' || p_loc_state);
1397: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
1398: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);

Line 1395: hr_utility.trace('p_loc_city= ' || p_loc_city);

1391: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1392:
1393: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
1394: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
1395: hr_utility.trace('p_loc_city= ' || p_loc_city);
1396: hr_utility.trace('p_loc_state= ' || p_loc_state);
1397: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
1398: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
1399: hr_utility.trace('p_contact_phone = ' || p_contact_phone);

Line 1396: hr_utility.trace('p_loc_state= ' || p_loc_state);

1392:
1393: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
1394: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
1395: hr_utility.trace('p_loc_city= ' || p_loc_city);
1396: hr_utility.trace('p_loc_state= ' || p_loc_state);
1397: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
1398: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
1399: hr_utility.trace('p_contact_phone = ' || p_contact_phone);
1400: hr_utility.trace('p_contact_name = ' || p_contact_name);

Line 1397: hr_utility.trace('p_loc_zip= ' || p_loc_zip);

1393: hr_utility.trace('p_loc_address_line1= ' || p_loc_address_line1);
1394: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
1395: hr_utility.trace('p_loc_city= ' || p_loc_city);
1396: hr_utility.trace('p_loc_state= ' || p_loc_state);
1397: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
1398: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
1399: hr_utility.trace('p_contact_phone = ' || p_contact_phone);
1400: hr_utility.trace('p_contact_name = ' || p_contact_name);
1401:

Line 1398: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);

1394: hr_utility.trace('p_loc_address_line2= ' || p_loc_address_line2);
1395: hr_utility.trace('p_loc_city= ' || p_loc_city);
1396: hr_utility.trace('p_loc_state= ' || p_loc_state);
1397: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
1398: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
1399: hr_utility.trace('p_contact_phone = ' || p_contact_phone);
1400: hr_utility.trace('p_contact_name = ' || p_contact_name);
1401:
1402:

Line 1399: hr_utility.trace('p_contact_phone = ' || p_contact_phone);

1395: hr_utility.trace('p_loc_city= ' || p_loc_city);
1396: hr_utility.trace('p_loc_state= ' || p_loc_state);
1397: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
1398: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
1399: hr_utility.trace('p_contact_phone = ' || p_contact_phone);
1400: hr_utility.trace('p_contact_name = ' || p_contact_name);
1401:
1402:
1403: hr_utility.set_location(l_api_name,30);

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

1396: hr_utility.trace('p_loc_state= ' || p_loc_state);
1397: hr_utility.trace('p_loc_zip= ' || p_loc_zip);
1398: hr_utility.trace('p_loc_zip_extension= ' || p_loc_zip_extension);
1399: hr_utility.trace('p_contact_phone = ' || p_contact_phone);
1400: hr_utility.trace('p_contact_name = ' || p_contact_name);
1401:
1402:
1403: hr_utility.set_location(l_api_name,30);
1404:

Line 1403: hr_utility.set_location(l_api_name,30);

1399: hr_utility.trace('p_contact_phone = ' || p_contact_phone);
1400: hr_utility.trace('p_contact_name = ' || p_contact_name);
1401:
1402:
1403: hr_utility.set_location(l_api_name,30);
1404:
1405: --
1406: -- format new hire rocord
1407: --

Line 1439: hr_utility.set_location('Leaving.... :' || l_api_name,100);

1435: replace(nvl(p_contact_name,' '),',',' ') || g_delimiter ||
1436: nvl(p_multi_state,' ') ||
1437: g_eol;
1438:
1439: hr_utility.set_location('Leaving.... :' || l_api_name,100);
1440:
1441: return l_buffer;
1442: exception
1443: when others then

Line 1444: hr_utility.set_location('Leaving.... :' || l_api_name,200);

1440:
1441: return l_buffer;
1442: exception
1443: when others then
1444: hr_utility.set_location('Leaving.... :' || l_api_name,200);
1445: raise;
1446: end a03_al_new_hire_record;
1447: --
1448:

Line 1461: hr_utility.set_location('Entering...: ' || l_api_name,10);

1457: l_api_name varchar2(61) := g_package_name || '.a03_il_new_hire_header';
1458: l_buffer varchar2(2000);
1459: begin
1460: --
1461: hr_utility.set_location('Entering...: ' || l_api_name,10);
1462: l_buffer := 'Social Security Number' || g_delimiter ||
1463: 'First Name' || g_delimiter ||
1464: 'Middle Name' || g_delimiter ||
1465: 'Last Name' || g_delimiter ||

Line 1483: hr_utility.set_location('Leaving.... :' || l_api_name,100);

1479: 'Employer Zip' || g_delimiter ||
1480: 'Employer Zip Extension' || g_delimiter ||
1481: g_eol;
1482:
1483: hr_utility.set_location('Leaving.... :' || l_api_name,100);
1484:
1485: return l_buffer;
1486: exception
1487: when others then

Line 1488: hr_utility.set_location('Leaving.... :' || l_api_name,200);

1484:
1485: return l_buffer;
1486: exception
1487: when others then
1488: hr_utility.set_location('Leaving.... :' || l_api_name,200);
1489: raise;
1490: end a03_il_new_hire_header;
1491: --
1492: /****************************************************************

Line 1525: hr_utility.set_location('Entering...: ' || l_api_name,10);

1521: l_buffer varchar2(2000);
1522: v_ssn varchar(9);
1523: begin
1524:
1525: hr_utility.set_location('Entering...: ' || l_api_name,10);
1526:
1527: hr_utility.trace('p_federal_id= ' || p_federal_id);
1528: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1529: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);

Line 1527: hr_utility.trace('p_federal_id= ' || p_federal_id);

1523: begin
1524:
1525: hr_utility.set_location('Entering...: ' || l_api_name,10);
1526:
1527: hr_utility.trace('p_federal_id= ' || p_federal_id);
1528: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1529: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1530:
1531: hr_utility.trace('v_ssn= ' || v_ssn);

Line 1528: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);

1524:
1525: hr_utility.set_location('Entering...: ' || l_api_name,10);
1526:
1527: hr_utility.trace('p_federal_id= ' || p_federal_id);
1528: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1529: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1530:
1531: hr_utility.trace('v_ssn= ' || v_ssn);
1532: hr_utility.trace('p_first_name= ' || p_first_name);

Line 1531: hr_utility.trace('v_ssn= ' || v_ssn);

1527: hr_utility.trace('p_federal_id= ' || p_federal_id);
1528: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1529: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1530:
1531: hr_utility.trace('v_ssn= ' || v_ssn);
1532: hr_utility.trace('p_first_name= ' || p_first_name);
1533: hr_utility.trace('p_middle_name= ' || p_middle_name);
1534: hr_utility.trace('p_last_name= ' || p_last_name);
1535: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);

Line 1532: hr_utility.trace('p_first_name= ' || p_first_name);

1528: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1529: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1530:
1531: hr_utility.trace('v_ssn= ' || v_ssn);
1532: hr_utility.trace('p_first_name= ' || p_first_name);
1533: hr_utility.trace('p_middle_name= ' || p_middle_name);
1534: hr_utility.trace('p_last_name= ' || p_last_name);
1535: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1536: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);

Line 1533: hr_utility.trace('p_middle_name= ' || p_middle_name);

1529: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1530:
1531: hr_utility.trace('v_ssn= ' || v_ssn);
1532: hr_utility.trace('p_first_name= ' || p_first_name);
1533: hr_utility.trace('p_middle_name= ' || p_middle_name);
1534: hr_utility.trace('p_last_name= ' || p_last_name);
1535: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1536: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1537: hr_utility.trace('p_emp_city= ' || p_emp_city);

Line 1534: hr_utility.trace('p_last_name= ' || p_last_name);

1530:
1531: hr_utility.trace('v_ssn= ' || v_ssn);
1532: hr_utility.trace('p_first_name= ' || p_first_name);
1533: hr_utility.trace('p_middle_name= ' || p_middle_name);
1534: hr_utility.trace('p_last_name= ' || p_last_name);
1535: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1536: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1537: hr_utility.trace('p_emp_city= ' || p_emp_city);
1538: hr_utility.trace('p_emp_state= ' || p_emp_state);

Line 1535: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);

1531: hr_utility.trace('v_ssn= ' || v_ssn);
1532: hr_utility.trace('p_first_name= ' || p_first_name);
1533: hr_utility.trace('p_middle_name= ' || p_middle_name);
1534: hr_utility.trace('p_last_name= ' || p_last_name);
1535: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1536: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1537: hr_utility.trace('p_emp_city= ' || p_emp_city);
1538: hr_utility.trace('p_emp_state= ' || p_emp_state);
1539: hr_utility.trace('p_emp_zip= ' || p_emp_zip);

Line 1536: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);

1532: hr_utility.trace('p_first_name= ' || p_first_name);
1533: hr_utility.trace('p_middle_name= ' || p_middle_name);
1534: hr_utility.trace('p_last_name= ' || p_last_name);
1535: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1536: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1537: hr_utility.trace('p_emp_city= ' || p_emp_city);
1538: hr_utility.trace('p_emp_state= ' || p_emp_state);
1539: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1540: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);

Line 1537: hr_utility.trace('p_emp_city= ' || p_emp_city);

1533: hr_utility.trace('p_middle_name= ' || p_middle_name);
1534: hr_utility.trace('p_last_name= ' || p_last_name);
1535: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1536: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1537: hr_utility.trace('p_emp_city= ' || p_emp_city);
1538: hr_utility.trace('p_emp_state= ' || p_emp_state);
1539: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1540: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1541: hr_utility.trace('p_date_of_birth= ' || p_date_of_hire);

Line 1538: hr_utility.trace('p_emp_state= ' || p_emp_state);

1534: hr_utility.trace('p_last_name= ' || p_last_name);
1535: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1536: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1537: hr_utility.trace('p_emp_city= ' || p_emp_city);
1538: hr_utility.trace('p_emp_state= ' || p_emp_state);
1539: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1540: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1541: hr_utility.trace('p_date_of_birth= ' || p_date_of_hire);
1542:

Line 1539: hr_utility.trace('p_emp_zip= ' || p_emp_zip);

1535: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1536: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1537: hr_utility.trace('p_emp_city= ' || p_emp_city);
1538: hr_utility.trace('p_emp_state= ' || p_emp_state);
1539: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1540: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1541: hr_utility.trace('p_date_of_birth= ' || p_date_of_hire);
1542:
1543: hr_utility.set_location(l_api_name,30);

Line 1540: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);

1536: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1537: hr_utility.trace('p_emp_city= ' || p_emp_city);
1538: hr_utility.trace('p_emp_state= ' || p_emp_state);
1539: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1540: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1541: hr_utility.trace('p_date_of_birth= ' || p_date_of_hire);
1542:
1543: hr_utility.set_location(l_api_name,30);
1544:

Line 1541: hr_utility.trace('p_date_of_birth= ' || p_date_of_hire);

1537: hr_utility.trace('p_emp_city= ' || p_emp_city);
1538: hr_utility.trace('p_emp_state= ' || p_emp_state);
1539: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1540: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1541: hr_utility.trace('p_date_of_birth= ' || p_date_of_hire);
1542:
1543: hr_utility.set_location(l_api_name,30);
1544:
1545: --

Line 1543: hr_utility.set_location(l_api_name,30);

1539: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1540: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1541: hr_utility.trace('p_date_of_birth= ' || p_date_of_hire);
1542:
1543: hr_utility.set_location(l_api_name,30);
1544:
1545: --
1546: -- format new hire rocord
1547: --

Line 1569: hr_utility.set_location('Leaving.... :' || l_api_name,100);

1565: nvl(p_loc_zip,' ') || g_delimiter ||
1566: nvl(p_loc_zip_extension,' ') ||
1567: g_eol;
1568:
1569: hr_utility.set_location('Leaving.... :' || l_api_name,100);
1570:
1571: return l_buffer;
1572: exception
1573: when others then

Line 1574: hr_utility.set_location('Leaving.... :' || l_api_name,200);

1570:
1571: return l_buffer;
1572: exception
1573: when others then
1574: hr_utility.set_location('Leaving.... :' || l_api_name,200);
1575: raise;
1576: end a03_il_new_hire_record;
1577: --
1578: --

Line 1591: hr_utility.set_location('Entering...: ' || l_api_name,10);

1587: l_api_name varchar2(61) := g_package_name || '.a03_tx_new_hire_header';
1588: l_buffer varchar2(2000);
1589: begin
1590: --
1591: hr_utility.set_location('Entering...: ' || l_api_name,10);
1592: l_buffer := upper(
1593: 'Social Security Number' || g_delimiter ||
1594: 'First Name' || g_delimiter ||
1595: 'Middle Name' || g_delimiter ||

Line 1625: hr_utility.set_location('Leaving.... :' || l_api_name,100);

1621: -- 'Employer Foreign Country Name' || g_delimiter ||
1622: -- 'Employer Foreign Country Zip' ||
1623: g_eol);
1624:
1625: hr_utility.set_location('Leaving.... :' || l_api_name,100);
1626:
1627: return l_buffer;
1628: exception
1629: when others then

Line 1630: hr_utility.set_location('Leaving.... :' || l_api_name,200);

1626:
1627: return l_buffer;
1628: exception
1629: when others then
1630: hr_utility.set_location('Leaving.... :' || l_api_name,200);
1631: raise;
1632: end a03_tx_new_hire_header;
1633: --
1634: /****************************************************************

Line 1678: hr_utility.set_location('Entering...: ' || l_api_name,10);

1674: l_buffer varchar2(2000);
1675: v_ssn varchar(9);
1676: begin
1677:
1678: hr_utility.set_location('Entering...: ' || l_api_name,10);
1679:
1680: hr_utility.trace('p_federal_id= ' || p_federal_id);
1681: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1682: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);

Line 1680: hr_utility.trace('p_federal_id= ' || p_federal_id);

1676: begin
1677:
1678: hr_utility.set_location('Entering...: ' || l_api_name,10);
1679:
1680: hr_utility.trace('p_federal_id= ' || p_federal_id);
1681: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1682: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1683:
1684: hr_utility.trace('v_ssn= ' || v_ssn);

Line 1681: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);

1677:
1678: hr_utility.set_location('Entering...: ' || l_api_name,10);
1679:
1680: hr_utility.trace('p_federal_id= ' || p_federal_id);
1681: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1682: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1683:
1684: hr_utility.trace('v_ssn= ' || v_ssn);
1685: hr_utility.trace('p_first_name= ' || p_first_name);

Line 1684: hr_utility.trace('v_ssn= ' || v_ssn);

1680: hr_utility.trace('p_federal_id= ' || p_federal_id);
1681: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1682: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1683:
1684: hr_utility.trace('v_ssn= ' || v_ssn);
1685: hr_utility.trace('p_first_name= ' || p_first_name);
1686: hr_utility.trace('p_middle_name= ' || p_middle_name);
1687: hr_utility.trace('p_last_name= ' || p_last_name);
1688: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);

Line 1685: hr_utility.trace('p_first_name= ' || p_first_name);

1681: hr_utility.trace('p_tax_unit_name= ' || p_tax_unit_name);
1682: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1683:
1684: hr_utility.trace('v_ssn= ' || v_ssn);
1685: hr_utility.trace('p_first_name= ' || p_first_name);
1686: hr_utility.trace('p_middle_name= ' || p_middle_name);
1687: hr_utility.trace('p_last_name= ' || p_last_name);
1688: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1689: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);

Line 1686: hr_utility.trace('p_middle_name= ' || p_middle_name);

1682: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1683:
1684: hr_utility.trace('v_ssn= ' || v_ssn);
1685: hr_utility.trace('p_first_name= ' || p_first_name);
1686: hr_utility.trace('p_middle_name= ' || p_middle_name);
1687: hr_utility.trace('p_last_name= ' || p_last_name);
1688: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1689: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1690: hr_utility.trace('p_emp_address_line3= ' || p_emp_address_line2);

Line 1687: hr_utility.trace('p_last_name= ' || p_last_name);

1683:
1684: hr_utility.trace('v_ssn= ' || v_ssn);
1685: hr_utility.trace('p_first_name= ' || p_first_name);
1686: hr_utility.trace('p_middle_name= ' || p_middle_name);
1687: hr_utility.trace('p_last_name= ' || p_last_name);
1688: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1689: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1690: hr_utility.trace('p_emp_address_line3= ' || p_emp_address_line2);
1691: hr_utility.trace('p_emp_city= ' || p_emp_city);

Line 1688: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);

1684: hr_utility.trace('v_ssn= ' || v_ssn);
1685: hr_utility.trace('p_first_name= ' || p_first_name);
1686: hr_utility.trace('p_middle_name= ' || p_middle_name);
1687: hr_utility.trace('p_last_name= ' || p_last_name);
1688: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1689: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1690: hr_utility.trace('p_emp_address_line3= ' || p_emp_address_line2);
1691: hr_utility.trace('p_emp_city= ' || p_emp_city);
1692: hr_utility.trace('p_emp_state= ' || p_emp_state);

Line 1689: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);

1685: hr_utility.trace('p_first_name= ' || p_first_name);
1686: hr_utility.trace('p_middle_name= ' || p_middle_name);
1687: hr_utility.trace('p_last_name= ' || p_last_name);
1688: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1689: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1690: hr_utility.trace('p_emp_address_line3= ' || p_emp_address_line2);
1691: hr_utility.trace('p_emp_city= ' || p_emp_city);
1692: hr_utility.trace('p_emp_state= ' || p_emp_state);
1693: hr_utility.trace('p_emp_zip= ' || p_emp_zip);

Line 1690: hr_utility.trace('p_emp_address_line3= ' || p_emp_address_line2);

1686: hr_utility.trace('p_middle_name= ' || p_middle_name);
1687: hr_utility.trace('p_last_name= ' || p_last_name);
1688: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1689: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1690: hr_utility.trace('p_emp_address_line3= ' || p_emp_address_line2);
1691: hr_utility.trace('p_emp_city= ' || p_emp_city);
1692: hr_utility.trace('p_emp_state= ' || p_emp_state);
1693: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1694: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);

Line 1691: hr_utility.trace('p_emp_city= ' || p_emp_city);

1687: hr_utility.trace('p_last_name= ' || p_last_name);
1688: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1689: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1690: hr_utility.trace('p_emp_address_line3= ' || p_emp_address_line2);
1691: hr_utility.trace('p_emp_city= ' || p_emp_city);
1692: hr_utility.trace('p_emp_state= ' || p_emp_state);
1693: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1694: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1695: hr_utility.trace('p_date_of_birth= ' || p_date_of_hire);

Line 1692: hr_utility.trace('p_emp_state= ' || p_emp_state);

1688: hr_utility.trace('p_emp_address_line1= ' || p_emp_address_line1);
1689: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1690: hr_utility.trace('p_emp_address_line3= ' || p_emp_address_line2);
1691: hr_utility.trace('p_emp_city= ' || p_emp_city);
1692: hr_utility.trace('p_emp_state= ' || p_emp_state);
1693: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1694: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1695: hr_utility.trace('p_date_of_birth= ' || p_date_of_hire);
1696: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);

Line 1693: hr_utility.trace('p_emp_zip= ' || p_emp_zip);

1689: hr_utility.trace('p_emp_address_line2= ' || p_emp_address_line2);
1690: hr_utility.trace('p_emp_address_line3= ' || p_emp_address_line2);
1691: hr_utility.trace('p_emp_city= ' || p_emp_city);
1692: hr_utility.trace('p_emp_state= ' || p_emp_state);
1693: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1694: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1695: hr_utility.trace('p_date_of_birth= ' || p_date_of_hire);
1696: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1697: hr_utility.trace('p_state_of_hire= ' || p_state_of_hire);

Line 1694: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);

1690: hr_utility.trace('p_emp_address_line3= ' || p_emp_address_line2);
1691: hr_utility.trace('p_emp_city= ' || p_emp_city);
1692: hr_utility.trace('p_emp_state= ' || p_emp_state);
1693: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1694: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1695: hr_utility.trace('p_date_of_birth= ' || p_date_of_hire);
1696: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1697: hr_utility.trace('p_state_of_hire= ' || p_state_of_hire);
1698:

Line 1695: hr_utility.trace('p_date_of_birth= ' || p_date_of_hire);

1691: hr_utility.trace('p_emp_city= ' || p_emp_city);
1692: hr_utility.trace('p_emp_state= ' || p_emp_state);
1693: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1694: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1695: hr_utility.trace('p_date_of_birth= ' || p_date_of_hire);
1696: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1697: hr_utility.trace('p_state_of_hire= ' || p_state_of_hire);
1698:
1699: hr_utility.set_location(l_api_name,30);

Line 1696: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);

1692: hr_utility.trace('p_emp_state= ' || p_emp_state);
1693: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1694: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1695: hr_utility.trace('p_date_of_birth= ' || p_date_of_hire);
1696: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1697: hr_utility.trace('p_state_of_hire= ' || p_state_of_hire);
1698:
1699: hr_utility.set_location(l_api_name,30);
1700:

Line 1697: hr_utility.trace('p_state_of_hire= ' || p_state_of_hire);

1693: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1694: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1695: hr_utility.trace('p_date_of_birth= ' || p_date_of_hire);
1696: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1697: hr_utility.trace('p_state_of_hire= ' || p_state_of_hire);
1698:
1699: hr_utility.set_location(l_api_name,30);
1700:
1701: --

Line 1699: hr_utility.set_location(l_api_name,30);

1695: hr_utility.trace('p_date_of_birth= ' || p_date_of_hire);
1696: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1697: hr_utility.trace('p_state_of_hire= ' || p_state_of_hire);
1698:
1699: hr_utility.set_location(l_api_name,30);
1700:
1701: --
1702: -- format new hire rocord
1703: --

Line 1734: hr_utility.set_location('Leaving.... :' || l_api_name,100);

1730: nvl(p_loc_zip,' ') || g_delimiter ||
1731: nvl(p_loc_zip_extension,' ') || g_delimiter ||
1732: g_eol);
1733:
1734: hr_utility.set_location('Leaving.... :' || l_api_name,100);
1735:
1736: return l_buffer;
1737: exception
1738: when others then

Line 1739: hr_utility.set_location('Leaving.... :' || l_api_name,200);

1735:
1736: return l_buffer;
1737: exception
1738: when others then
1739: hr_utility.set_location('Leaving.... :' || l_api_name,200);
1740: raise;
1741: end a03_tx_new_hire_record;
1742:
1743:

Line 1756: hr_utility.set_location('Entering...: ' || l_api_name,10);

1752: l_api_name varchar2(61) := g_package_name || '.a03_ca_new_hire_header';
1753: l_buffer varchar2(2000);
1754: begin
1755: --
1756: hr_utility.set_location('Entering...: ' || l_api_name,10);
1757: l_buffer := 'SOCIAL SECURITY NUMBER' || g_delimiter ||
1758: 'FIRST NAME' || g_delimiter ||
1759: 'MIDDLE INITIAL' || g_delimiter ||
1760: 'LAST NAME' || g_delimiter ||

Line 1769: hr_utility.set_location('Leaving.... :' || l_api_name,100);

1765: 'EMPLOYEE ZIP EXTENSION' || g_delimiter ||
1766: 'DATE OF HIRE' ||
1767: g_eol;
1768:
1769: hr_utility.set_location('Leaving.... :' || l_api_name,100);
1770:
1771: return l_buffer;
1772: exception
1773: when others then

Line 1774: hr_utility.set_location('Leaving.... :' || l_api_name,200);

1770:
1771: return l_buffer;
1772: exception
1773: when others then
1774: hr_utility.set_location('Leaving.... :' || l_api_name,200);
1775: raise;
1776: end a03_ca_new_hire_header;
1777: --
1778: /****************************************************************

Line 1802: hr_utility.set_location('Entering...: ' || l_api_name,10);

1798: l_buffer varchar2(2000);
1799: v_ssn varchar(9);
1800: begin
1801:
1802: hr_utility.set_location('Entering...: ' || l_api_name,10);
1803:
1804: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1805:
1806: hr_utility.trace('v_ssn= ' || v_ssn);

Line 1806: hr_utility.trace('v_ssn= ' || v_ssn);

1802: hr_utility.set_location('Entering...: ' || l_api_name,10);
1803:
1804: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1805:
1806: hr_utility.trace('v_ssn= ' || v_ssn);
1807: hr_utility.trace('p_first_name= ' || p_first_name);
1808: hr_utility.trace('p_middle_name= ' || p_middle_name);
1809: hr_utility.trace('p_last_name= ' || p_last_name);
1810: hr_utility.trace('p_emp_address_line = ' || p_emp_address_line);

Line 1807: hr_utility.trace('p_first_name= ' || p_first_name);

1803:
1804: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1805:
1806: hr_utility.trace('v_ssn= ' || v_ssn);
1807: hr_utility.trace('p_first_name= ' || p_first_name);
1808: hr_utility.trace('p_middle_name= ' || p_middle_name);
1809: hr_utility.trace('p_last_name= ' || p_last_name);
1810: hr_utility.trace('p_emp_address_line = ' || p_emp_address_line);
1811: hr_utility.trace('p_emp_city= ' || p_emp_city);

Line 1808: hr_utility.trace('p_middle_name= ' || p_middle_name);

1804: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1805:
1806: hr_utility.trace('v_ssn= ' || v_ssn);
1807: hr_utility.trace('p_first_name= ' || p_first_name);
1808: hr_utility.trace('p_middle_name= ' || p_middle_name);
1809: hr_utility.trace('p_last_name= ' || p_last_name);
1810: hr_utility.trace('p_emp_address_line = ' || p_emp_address_line);
1811: hr_utility.trace('p_emp_city= ' || p_emp_city);
1812: hr_utility.trace('p_emp_state= ' || p_emp_state);

Line 1809: hr_utility.trace('p_last_name= ' || p_last_name);

1805:
1806: hr_utility.trace('v_ssn= ' || v_ssn);
1807: hr_utility.trace('p_first_name= ' || p_first_name);
1808: hr_utility.trace('p_middle_name= ' || p_middle_name);
1809: hr_utility.trace('p_last_name= ' || p_last_name);
1810: hr_utility.trace('p_emp_address_line = ' || p_emp_address_line);
1811: hr_utility.trace('p_emp_city= ' || p_emp_city);
1812: hr_utility.trace('p_emp_state= ' || p_emp_state);
1813: hr_utility.trace('p_emp_zip= ' || p_emp_zip);

Line 1810: hr_utility.trace('p_emp_address_line = ' || p_emp_address_line);

1806: hr_utility.trace('v_ssn= ' || v_ssn);
1807: hr_utility.trace('p_first_name= ' || p_first_name);
1808: hr_utility.trace('p_middle_name= ' || p_middle_name);
1809: hr_utility.trace('p_last_name= ' || p_last_name);
1810: hr_utility.trace('p_emp_address_line = ' || p_emp_address_line);
1811: hr_utility.trace('p_emp_city= ' || p_emp_city);
1812: hr_utility.trace('p_emp_state= ' || p_emp_state);
1813: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1814: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);

Line 1811: hr_utility.trace('p_emp_city= ' || p_emp_city);

1807: hr_utility.trace('p_first_name= ' || p_first_name);
1808: hr_utility.trace('p_middle_name= ' || p_middle_name);
1809: hr_utility.trace('p_last_name= ' || p_last_name);
1810: hr_utility.trace('p_emp_address_line = ' || p_emp_address_line);
1811: hr_utility.trace('p_emp_city= ' || p_emp_city);
1812: hr_utility.trace('p_emp_state= ' || p_emp_state);
1813: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1814: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1815: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);

Line 1812: hr_utility.trace('p_emp_state= ' || p_emp_state);

1808: hr_utility.trace('p_middle_name= ' || p_middle_name);
1809: hr_utility.trace('p_last_name= ' || p_last_name);
1810: hr_utility.trace('p_emp_address_line = ' || p_emp_address_line);
1811: hr_utility.trace('p_emp_city= ' || p_emp_city);
1812: hr_utility.trace('p_emp_state= ' || p_emp_state);
1813: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1814: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1815: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1816:

Line 1813: hr_utility.trace('p_emp_zip= ' || p_emp_zip);

1809: hr_utility.trace('p_last_name= ' || p_last_name);
1810: hr_utility.trace('p_emp_address_line = ' || p_emp_address_line);
1811: hr_utility.trace('p_emp_city= ' || p_emp_city);
1812: hr_utility.trace('p_emp_state= ' || p_emp_state);
1813: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1814: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1815: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1816:
1817: hr_utility.set_location(l_api_name,30);

Line 1814: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);

1810: hr_utility.trace('p_emp_address_line = ' || p_emp_address_line);
1811: hr_utility.trace('p_emp_city= ' || p_emp_city);
1812: hr_utility.trace('p_emp_state= ' || p_emp_state);
1813: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1814: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1815: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1816:
1817: hr_utility.set_location(l_api_name,30);
1818:

Line 1815: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);

1811: hr_utility.trace('p_emp_city= ' || p_emp_city);
1812: hr_utility.trace('p_emp_state= ' || p_emp_state);
1813: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1814: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1815: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1816:
1817: hr_utility.set_location(l_api_name,30);
1818:
1819: --

Line 1817: hr_utility.set_location(l_api_name,30);

1813: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1814: hr_utility.trace('p_emp_zip_extension= ' || p_emp_zip_extension);
1815: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1816:
1817: hr_utility.set_location(l_api_name,30);
1818:
1819: --
1820: -- format new hire rocord
1821: --

Line 1836: hr_utility.set_location('Leaving.... :' || l_api_name,100);

1832: nvl(to_char(p_date_of_hire,'YYYYMMDD'),' ') ||
1833: g_eol
1834: );
1835:
1836: hr_utility.set_location('Leaving.... :' || l_api_name,100);
1837:
1838: return l_buffer;
1839: exception
1840: when others then

Line 1841: hr_utility.set_location('Leaving.... :' || l_api_name,200);

1837:
1838: return l_buffer;
1839: exception
1840: when others then
1841: hr_utility.set_location('Leaving.... :' || l_api_name,200);
1842: raise;
1843: end a03_ca_new_hire_record;
1844: --
1845: /****************************************************************

Line 1857: hr_utility.set_location('Entering...: ' || l_api_name,10);

1853: l_api_name varchar2(61) := g_package_name || '.a03_ny_new_hire_header';
1854: l_buffer varchar2(2000);
1855: begin
1856: --
1857: hr_utility.set_location('Entering...: ' || l_api_name,10);
1858: l_buffer := upper(
1859: 'Social Security Number' || g_delimiter ||
1860: 'Last Name' || g_delimiter ||
1861: 'First Name' || g_delimiter ||

Line 1870: hr_utility.set_location('Leaving.... :' || l_api_name,100);

1866: 'Employee Zip' || g_delimiter ||
1867: 'Hire Date' || g_delimiter ||
1868: g_eol);
1869:
1870: hr_utility.set_location('Leaving.... :' || l_api_name,100);
1871:
1872: return l_buffer;
1873: exception
1874: when others then

Line 1875: hr_utility.set_location('Leaving.... :' || l_api_name,200);

1871:
1872: return l_buffer;
1873: exception
1874: when others then
1875: hr_utility.set_location('Leaving.... :' || l_api_name,200);
1876: raise;
1877: end a03_ny_new_hire_header;
1878: --
1879: /****************************************************************

Line 1902: hr_utility.set_location('Entering...: ' || l_api_name,10);

1898: l_buffer varchar2(2000);
1899: v_ssn varchar(9);
1900: begin
1901:
1902: hr_utility.set_location('Entering...: ' || l_api_name,10);
1903:
1904: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1905:
1906: hr_utility.trace('v_ssn= ' || v_ssn);

Line 1906: hr_utility.trace('v_ssn= ' || v_ssn);

1902: hr_utility.set_location('Entering...: ' || l_api_name,10);
1903:
1904: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1905:
1906: hr_utility.trace('v_ssn= ' || v_ssn);
1907: hr_utility.trace('p_first_name= ' || p_first_name);
1908: hr_utility.trace('p_middle_name= ' || p_middle_name);
1909: hr_utility.trace('p_last_name= ' || p_last_name);
1910: hr_utility.trace('p_emp_address_line = ' || p_emp_address_line);

Line 1907: hr_utility.trace('p_first_name= ' || p_first_name);

1903:
1904: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1905:
1906: hr_utility.trace('v_ssn= ' || v_ssn);
1907: hr_utility.trace('p_first_name= ' || p_first_name);
1908: hr_utility.trace('p_middle_name= ' || p_middle_name);
1909: hr_utility.trace('p_last_name= ' || p_last_name);
1910: hr_utility.trace('p_emp_address_line = ' || p_emp_address_line);
1911: hr_utility.trace('p_emp_city= ' || p_emp_city);

Line 1908: hr_utility.trace('p_middle_name= ' || p_middle_name);

1904: v_ssn := substr(p_national_identifier,1,3) || substr(p_national_identifier,5,2) || substr(p_national_identifier,8,4);
1905:
1906: hr_utility.trace('v_ssn= ' || v_ssn);
1907: hr_utility.trace('p_first_name= ' || p_first_name);
1908: hr_utility.trace('p_middle_name= ' || p_middle_name);
1909: hr_utility.trace('p_last_name= ' || p_last_name);
1910: hr_utility.trace('p_emp_address_line = ' || p_emp_address_line);
1911: hr_utility.trace('p_emp_city= ' || p_emp_city);
1912: hr_utility.trace('p_emp_state= ' || p_emp_state);

Line 1909: hr_utility.trace('p_last_name= ' || p_last_name);

1905:
1906: hr_utility.trace('v_ssn= ' || v_ssn);
1907: hr_utility.trace('p_first_name= ' || p_first_name);
1908: hr_utility.trace('p_middle_name= ' || p_middle_name);
1909: hr_utility.trace('p_last_name= ' || p_last_name);
1910: hr_utility.trace('p_emp_address_line = ' || p_emp_address_line);
1911: hr_utility.trace('p_emp_city= ' || p_emp_city);
1912: hr_utility.trace('p_emp_state= ' || p_emp_state);
1913: hr_utility.trace('p_emp_zip= ' || p_emp_zip);

Line 1910: hr_utility.trace('p_emp_address_line = ' || p_emp_address_line);

1906: hr_utility.trace('v_ssn= ' || v_ssn);
1907: hr_utility.trace('p_first_name= ' || p_first_name);
1908: hr_utility.trace('p_middle_name= ' || p_middle_name);
1909: hr_utility.trace('p_last_name= ' || p_last_name);
1910: hr_utility.trace('p_emp_address_line = ' || p_emp_address_line);
1911: hr_utility.trace('p_emp_city= ' || p_emp_city);
1912: hr_utility.trace('p_emp_state= ' || p_emp_state);
1913: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1914: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);

Line 1911: hr_utility.trace('p_emp_city= ' || p_emp_city);

1907: hr_utility.trace('p_first_name= ' || p_first_name);
1908: hr_utility.trace('p_middle_name= ' || p_middle_name);
1909: hr_utility.trace('p_last_name= ' || p_last_name);
1910: hr_utility.trace('p_emp_address_line = ' || p_emp_address_line);
1911: hr_utility.trace('p_emp_city= ' || p_emp_city);
1912: hr_utility.trace('p_emp_state= ' || p_emp_state);
1913: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1914: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1915:

Line 1912: hr_utility.trace('p_emp_state= ' || p_emp_state);

1908: hr_utility.trace('p_middle_name= ' || p_middle_name);
1909: hr_utility.trace('p_last_name= ' || p_last_name);
1910: hr_utility.trace('p_emp_address_line = ' || p_emp_address_line);
1911: hr_utility.trace('p_emp_city= ' || p_emp_city);
1912: hr_utility.trace('p_emp_state= ' || p_emp_state);
1913: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1914: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1915:
1916: hr_utility.set_location(l_api_name,30);

Line 1913: hr_utility.trace('p_emp_zip= ' || p_emp_zip);

1909: hr_utility.trace('p_last_name= ' || p_last_name);
1910: hr_utility.trace('p_emp_address_line = ' || p_emp_address_line);
1911: hr_utility.trace('p_emp_city= ' || p_emp_city);
1912: hr_utility.trace('p_emp_state= ' || p_emp_state);
1913: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1914: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1915:
1916: hr_utility.set_location(l_api_name,30);
1917:

Line 1914: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);

1910: hr_utility.trace('p_emp_address_line = ' || p_emp_address_line);
1911: hr_utility.trace('p_emp_city= ' || p_emp_city);
1912: hr_utility.trace('p_emp_state= ' || p_emp_state);
1913: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1914: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1915:
1916: hr_utility.set_location(l_api_name,30);
1917:
1918: --

Line 1916: hr_utility.set_location(l_api_name,30);

1912: hr_utility.trace('p_emp_state= ' || p_emp_state);
1913: hr_utility.trace('p_emp_zip= ' || p_emp_zip);
1914: hr_utility.trace('p_date_of_hire= ' || p_date_of_hire);
1915:
1916: hr_utility.set_location(l_api_name,30);
1917:
1918: --
1919: -- format new hire rocord
1920: --

Line 1933: hr_utility.set_location('Leaving.... :' || l_api_name,100);

1929: nvl(p_emp_zip,' ') || g_delimiter ||
1930: nvl(to_char(p_date_of_hire,'MMDDYY'),' ') ||
1931: g_eol);
1932:
1933: hr_utility.set_location('Leaving.... :' || l_api_name,100);
1934:
1935: return l_buffer;
1936: exception
1937: when others then

Line 1938: hr_utility.set_location('Leaving.... :' || l_api_name,200);

1934:
1935: return l_buffer;
1936: exception
1937: when others then
1938: hr_utility.set_location('Leaving.... :' || l_api_name,200);
1939: raise;
1940: end a03_ny_new_hire_record;
1941: --
1942:

Line 1983: hr_utility.set_location('Entering :' || l_api_name, 5);

1979: where location_id = p_location_id;
1980: --
1981: begin
1982: --
1983: hr_utility.set_location('Entering :' || l_api_name, 5);
1984: hr_utility.trace('location_id is ' || to_char(p_location_id));
1985: --
1986: open get_location_record;
1987: --

Line 1984: hr_utility.trace('location_id is ' || to_char(p_location_id));

1980: --
1981: begin
1982: --
1983: hr_utility.set_location('Entering :' || l_api_name, 5);
1984: hr_utility.trace('location_id is ' || to_char(p_location_id));
1985: --
1986: open get_location_record;
1987: --
1988: fetch get_location_record into v_address_line_1, v_address_line_2,

Line 1992: hr_utility.set_location(l_api_name, 10);

1988: fetch get_location_record into v_address_line_1, v_address_line_2,
1989: v_address_line_3, v_town_or_city, v_region_1
1990: ,v_region_2, v_postal_code ,v_style;
1991: --
1992: hr_utility.set_location(l_api_name, 10);
1993: --
1994: if get_location_record%found
1995: then
1996: --

Line 2002: hr_utility.set_location(l_api_name, 11);

1998: then
1999: f_address := v_address_line_1;
2000: end if;
2001: --
2002: hr_utility.set_location(l_api_name, 11);
2003: if v_address_line_2 is not null
2004: then
2005: f_address := f_address || ' ' || v_address_line_2;
2006: end if;

Line 2008: hr_utility.set_location(l_api_name, 12);

2004: then
2005: f_address := f_address || ' ' || v_address_line_2;
2006: end if;
2007: --
2008: hr_utility.set_location(l_api_name, 12);
2009: if v_address_line_3 is not null
2010: then
2011: f_address := f_address || ' ' || v_address_line_3;
2012: end if;

Line 2013: hr_utility.trace('street address is '|| f_address);

2009: if v_address_line_3 is not null
2010: then
2011: f_address := f_address || ' ' || v_address_line_3;
2012: end if;
2013: hr_utility.trace('street address is '|| f_address);
2014: --
2015: hr_utility.set_location(l_api_name, 13);
2016: if v_town_or_city is not null
2017: then

Line 2015: hr_utility.set_location(l_api_name, 13);

2011: f_address := f_address || ' ' || v_address_line_3;
2012: end if;
2013: hr_utility.trace('street address is '|| f_address);
2014: --
2015: hr_utility.set_location(l_api_name, 13);
2016: if v_town_or_city is not null
2017: then
2018: f_city:= rpad(v_town_or_city,48,' ');
2019: end if;

Line 2020: hr_utility.trace('city is '|| f_city);

2016: if v_town_or_city is not null
2017: then
2018: f_city:= rpad(v_town_or_city,48,' ');
2019: end if;
2020: hr_utility.trace('city is '|| f_city);
2021: --
2022: if (v_style = 'US' or v_style = 'US_GLB') and v_region_2 is not null
2023: then
2024: f_state := v_region_2;

Line 2028: hr_utility.trace('state is '|| f_state);

2024: f_state := v_region_2;
2025: elsif v_style = 'CA' and v_region_1 is not null then
2026: f_state := v_region_1;
2027: end if;
2028: hr_utility.trace('state is '|| f_state);
2029: --
2030: if v_postal_code is not null
2031: then
2032: f_zip := v_postal_code;

Line 2042: hr_utility.trace('postal code is '|| f_zip);

2038: else
2039: f_zip_extension := null;
2040: end if;
2041: end if;
2042: hr_utility.trace('postal code is '|| f_zip);
2043: hr_utility.trace('postal code extension is '|| f_zip_extension);
2044:
2045:
2046: --

Line 2043: hr_utility.trace('postal code extension is '|| f_zip_extension);

2039: f_zip_extension := null;
2040: end if;
2041: end if;
2042: hr_utility.trace('postal code is '|| f_zip);
2043: hr_utility.trace('postal code extension is '|| f_zip_extension);
2044:
2045:
2046: --
2047: close get_location_record;

Line 2049: hr_utility.set_location(l_api_name, 20);

2045:
2046: --
2047: close get_location_record;
2048: --
2049: hr_utility.set_location(l_api_name, 20);
2050:
2051: p_address := f_address;
2052: p_city := f_city;
2053: p_state := f_state;

Line 2059: hr_utility.set_location('Leaving ..' || l_api_name, 100);

2055: p_zip_extension := f_zip_extension;
2056: --
2057: end if;
2058: --
2059: hr_utility.set_location('Leaving ..' || l_api_name, 100);
2060:
2061: exception
2062: when others then
2063: hr_utility.trace('Error in ' || l_api_name);

Line 2063: hr_utility.trace('Error in ' || l_api_name);

2059: hr_utility.set_location('Leaving ..' || l_api_name, 100);
2060:
2061: exception
2062: when others then
2063: hr_utility.trace('Error in ' || l_api_name);
2064: hr_utility.set_location(l_api_name, 30);
2065: --
2066: end get_location_address;
2067: /****************************************************************

Line 2064: hr_utility.set_location(l_api_name, 30);

2060:
2061: exception
2062: when others then
2063: hr_utility.trace('Error in ' || l_api_name);
2064: hr_utility.set_location(l_api_name, 30);
2065: --
2066: end get_location_address;
2067: /****************************************************************
2068: * This procedure retrieves location address *

Line 2114: hr_utility.set_location('Entering :' || l_api_name, 5);

2110: where location_id = p_location_id;
2111: --
2112: begin
2113: --
2114: hr_utility.set_location('Entering :' || l_api_name, 5);
2115: hr_utility.trace('location_id is ' || to_char(p_location_id));
2116: --
2117: open get_location_record;
2118: --

Line 2115: hr_utility.trace('location_id is ' || to_char(p_location_id));

2111: --
2112: begin
2113: --
2114: hr_utility.set_location('Entering :' || l_api_name, 5);
2115: hr_utility.trace('location_id is ' || to_char(p_location_id));
2116: --
2117: open get_location_record;
2118: --
2119: fetch get_location_record into v_address_line_1, v_address_line_2,

Line 2123: hr_utility.set_location(l_api_name, 10);

2119: fetch get_location_record into v_address_line_1, v_address_line_2,
2120: v_address_line_3, v_town_or_city, v_region_1,v_region_2
2121: , v_postal_code ,v_country, v_style;
2122: --
2123: hr_utility.set_location(l_api_name, 10);
2124: --
2125: if get_location_record%found
2126: then
2127: --

Line 2131: hr_utility.trace('address_line1 is '|| f_address_line1);

2127: --
2128: if v_address_line_1 is not null
2129: then
2130: f_address_line1 := v_address_line_1;
2131: hr_utility.trace('address_line1 is '|| f_address_line1);
2132: end if;
2133: --
2134: hr_utility.set_location(l_api_name, 11);
2135: if v_address_line_2 is not null

Line 2134: hr_utility.set_location(l_api_name, 11);

2130: f_address_line1 := v_address_line_1;
2131: hr_utility.trace('address_line1 is '|| f_address_line1);
2132: end if;
2133: --
2134: hr_utility.set_location(l_api_name, 11);
2135: if v_address_line_2 is not null
2136: then
2137: f_address_line2 := v_address_line_2;
2138: hr_utility.trace('address_line2 is '|| f_address_line2);

Line 2138: hr_utility.trace('address_line2 is '|| f_address_line2);

2134: hr_utility.set_location(l_api_name, 11);
2135: if v_address_line_2 is not null
2136: then
2137: f_address_line2 := v_address_line_2;
2138: hr_utility.trace('address_line2 is '|| f_address_line2);
2139: end if;
2140: --
2141: hr_utility.set_location(l_api_name, 12);
2142: if v_address_line_3 is not null

Line 2141: hr_utility.set_location(l_api_name, 12);

2137: f_address_line2 := v_address_line_2;
2138: hr_utility.trace('address_line2 is '|| f_address_line2);
2139: end if;
2140: --
2141: hr_utility.set_location(l_api_name, 12);
2142: if v_address_line_3 is not null
2143: then
2144: f_address_line3 := v_address_line_3;
2145: hr_utility.trace('address_line3 is '|| f_address_line3);

Line 2145: hr_utility.trace('address_line3 is '|| f_address_line3);

2141: hr_utility.set_location(l_api_name, 12);
2142: if v_address_line_3 is not null
2143: then
2144: f_address_line3 := v_address_line_3;
2145: hr_utility.trace('address_line3 is '|| f_address_line3);
2146: end if;
2147: --
2148: hr_utility.set_location(l_api_name, 13);
2149: if v_town_or_city is not null

Line 2148: hr_utility.set_location(l_api_name, 13);

2144: f_address_line3 := v_address_line_3;
2145: hr_utility.trace('address_line3 is '|| f_address_line3);
2146: end if;
2147: --
2148: hr_utility.set_location(l_api_name, 13);
2149: if v_town_or_city is not null
2150: then
2151: f_city:= rpad(v_town_or_city,48,' ');
2152: end if;

Line 2153: hr_utility.trace('city is '|| f_city);

2149: if v_town_or_city is not null
2150: then
2151: f_city:= rpad(v_town_or_city,48,' ');
2152: end if;
2153: hr_utility.trace('city is '|| f_city);
2154: --
2155: if (v_style = 'US' or v_style = 'US_GLB') and v_region_2 is not null
2156: then
2157: f_state := v_region_2;

Line 2161: hr_utility.trace('state is '|| f_state);

2157: f_state := v_region_2;
2158: elsif v_style = 'CA' and v_region_1 is not null then
2159: f_state := v_region_1;
2160: end if;
2161: hr_utility.trace('state is '|| f_state);
2162: --
2163: if v_country = 'US'
2164: then
2165: if v_postal_code is not null

Line 2182: hr_utility.trace('country code is '|| v_country);

2178: else
2179: f_zip := v_postal_code;
2180: f_zip_extension := null;
2181: end if;
2182: hr_utility.trace('country code is '|| v_country);
2183: hr_utility.trace('postal code is '|| f_zip);
2184: hr_utility.trace('postal code extension is '|| f_zip_extension);
2185:
2186:

Line 2183: hr_utility.trace('postal code is '|| f_zip);

2179: f_zip := v_postal_code;
2180: f_zip_extension := null;
2181: end if;
2182: hr_utility.trace('country code is '|| v_country);
2183: hr_utility.trace('postal code is '|| f_zip);
2184: hr_utility.trace('postal code extension is '|| f_zip_extension);
2185:
2186:
2187: --

Line 2184: hr_utility.trace('postal code extension is '|| f_zip_extension);

2180: f_zip_extension := null;
2181: end if;
2182: hr_utility.trace('country code is '|| v_country);
2183: hr_utility.trace('postal code is '|| f_zip);
2184: hr_utility.trace('postal code extension is '|| f_zip_extension);
2185:
2186:
2187: --
2188: close get_location_record;

Line 2190: hr_utility.set_location(l_api_name, 20);

2186:
2187: --
2188: close get_location_record;
2189: --
2190: hr_utility.set_location(l_api_name, 20);
2191:
2192: p_address_line1 := f_address_line1;
2193: p_address_line2 := f_address_line2;
2194: p_address_line3 := f_address_line3;

Line 2203: hr_utility.set_location('Leaving ..' || l_api_name, 100);

2199: p_country := v_country;
2200: --
2201: end if;
2202: --
2203: hr_utility.set_location('Leaving ..' || l_api_name, 100);
2204:
2205: exception
2206: when others then
2207: hr_utility.trace('Error in ' || l_api_name);

Line 2207: hr_utility.trace('Error in ' || l_api_name);

2203: hr_utility.set_location('Leaving ..' || l_api_name, 100);
2204:
2205: exception
2206: when others then
2207: hr_utility.trace('Error in ' || l_api_name);
2208: hr_utility.set_location(l_api_name, 30);
2209: --
2210: end get_location_address_3lines;
2211: --

Line 2208: hr_utility.set_location(l_api_name, 30);

2204:
2205: exception
2206: when others then
2207: hr_utility.trace('Error in ' || l_api_name);
2208: hr_utility.set_location(l_api_name, 30);
2209: --
2210: end get_location_address_3lines;
2211: --
2212: /****************************************************************

Line 2258: hr_utility.set_location(l_api_name, 0);

2254: and nvl(date_to, sysdate) >= sysdate;
2255: --
2256: begin
2257: --
2258: hr_utility.set_location(l_api_name, 0);
2259: --
2260: open get_address_record;
2261: --
2262: fetch get_address_record into v_address_line1, v_address_line2,

Line 2266: hr_utility.set_location(l_api_name, 5);

2262: fetch get_address_record into v_address_line1, v_address_line2,
2263: v_address_line3, v_town_or_city, v_region_1
2264: ,v_region_2, v_postal_code,v_style;
2265: --
2266: hr_utility.set_location(l_api_name, 5);
2267: --
2268: if get_address_record%found
2269: then
2270: --

Line 2286: hr_utility.trace('Person Address is '|| f_address);

2282: then
2283: f_address := f_address || ' ' || v_address_line3;
2284: end if;
2285: --
2286: hr_utility.trace('Person Address is '|| f_address);
2287:
2288: if v_town_or_city is not null
2289: then
2290: f_city:= rpad(v_town_or_city,31,' ');

Line 2292: hr_utility.trace('city is '|| f_city);

2288: if v_town_or_city is not null
2289: then
2290: f_city:= rpad(v_town_or_city,31,' ');
2291: end if;
2292: hr_utility.trace('city is '|| f_city);
2293: --
2294: if (v_style = 'US' or v_style = 'US_GLB') and v_region_2 is not null
2295: then
2296: f_state := v_region_2;

Line 2300: hr_utility.trace('state is '|| f_state);

2296: f_state := v_region_2;
2297: elsif v_style = 'CA' and v_region_1 is not null then
2298: f_state := v_region_1;
2299: end if;
2300: hr_utility.trace('state is '|| f_state);
2301: --
2302: if v_postal_code is not null
2303: then
2304: f_zip := v_postal_code;

Line 2314: hr_utility.trace('country code is '|| v_country);

2310: else
2311: f_zip_extension := null;
2312: end if;
2313: end if;
2314: hr_utility.trace('country code is '|| v_country);
2315: hr_utility.trace('postal code is '|| f_zip);
2316: hr_utility.trace('postal extension code is '|| f_zip_extension);
2317:
2318: --

Line 2315: hr_utility.trace('postal code is '|| f_zip);

2311: f_zip_extension := null;
2312: end if;
2313: end if;
2314: hr_utility.trace('country code is '|| v_country);
2315: hr_utility.trace('postal code is '|| f_zip);
2316: hr_utility.trace('postal extension code is '|| f_zip_extension);
2317:
2318: --
2319: hr_utility.set_location(l_api_name, 10);

Line 2316: hr_utility.trace('postal extension code is '|| f_zip_extension);

2312: end if;
2313: end if;
2314: hr_utility.trace('country code is '|| v_country);
2315: hr_utility.trace('postal code is '|| f_zip);
2316: hr_utility.trace('postal extension code is '|| f_zip_extension);
2317:
2318: --
2319: hr_utility.set_location(l_api_name, 10);
2320: close get_address_record;

Line 2319: hr_utility.set_location(l_api_name, 10);

2315: hr_utility.trace('postal code is '|| f_zip);
2316: hr_utility.trace('postal extension code is '|| f_zip_extension);
2317:
2318: --
2319: hr_utility.set_location(l_api_name, 10);
2320: close get_address_record;
2321: --
2322: --
2323: p_address := f_address;

Line 2331: hr_utility.set_location('Leaving...:' || l_api_name, 50);

2327: p_zip_extension := f_zip_extension;
2328: --
2329: end if;
2330: --
2331: hr_utility.set_location('Leaving...:' || l_api_name, 50);
2332: --
2333: exception when NO_DATA_FOUND then NULL;
2334: --
2335: end get_employee_address;

Line 2388: hr_utility.set_location(l_api_name, 0);

2384: and nvl(date_to, sysdate) >= sysdate;
2385: --
2386: begin
2387: --
2388: hr_utility.set_location(l_api_name, 0);
2389: --
2390: open get_address_record;
2391: --
2392: fetch get_address_record into v_address_line1, v_address_line2,

Line 2396: hr_utility.set_location(l_api_name, 5);

2392: fetch get_address_record into v_address_line1, v_address_line2,
2393: v_address_line3, v_town_or_city, v_region_1,v_region_2
2394: , v_postal_code ,v_country,v_style;
2395: --
2396: hr_utility.set_location(l_api_name, 5);
2397: --
2398: if get_address_record%found
2399: then
2400: --

Line 2404: hr_utility.trace('address_line1 is '|| f_address_line1);

2400: --
2401: if v_address_line1 is not null
2402: then
2403: f_address_line1 := v_address_line1;
2404: hr_utility.trace('address_line1 is '|| f_address_line1);
2405: end if;
2406: --
2407: if v_address_line2 is not null
2408: then

Line 2410: hr_utility.trace('address_line2 is '|| f_address_line2);

2406: --
2407: if v_address_line2 is not null
2408: then
2409: f_address_line2 := v_address_line2;
2410: hr_utility.trace('address_line2 is '|| f_address_line2);
2411: end if;
2412: --
2413: if v_address_line3 is not null
2414: then

Line 2416: hr_utility.trace('address_line3 is '|| f_address_line3);

2412: --
2413: if v_address_line3 is not null
2414: then
2415: f_address_line3 := v_address_line3;
2416: hr_utility.trace('address_line3 is '|| f_address_line3);
2417: end if;
2418: --
2419:
2420: if v_town_or_city is not null

Line 2424: hr_utility.trace('city is '|| f_city);

2420: if v_town_or_city is not null
2421: then
2422: f_city:= rpad(v_town_or_city,31,' ');
2423: end if;
2424: hr_utility.trace('city is '|| f_city);
2425: --
2426: if (v_style = 'US' or v_style = 'US_GLB') and v_region_2 is not null
2427: then
2428: f_state := v_region_2;

Line 2432: hr_utility.trace('state is '|| f_state);

2428: f_state := v_region_2;
2429: elsif v_style = 'CA' and v_region_1 is not null then
2430: f_state := v_region_1;
2431: end if;
2432: hr_utility.trace('state is '|| f_state);
2433: --
2434: if v_country = 'US'
2435: then
2436: if v_postal_code is not null

Line 2453: hr_utility.trace('country code is '|| v_country);

2449: else
2450: f_zip := v_postal_code;
2451: f_zip_extension := null;
2452: end if;
2453: hr_utility.trace('country code is '|| v_country);
2454: hr_utility.trace('postal code is '|| f_zip);
2455: hr_utility.trace('postal extension code is '|| f_zip_extension);
2456:
2457: --

Line 2454: hr_utility.trace('postal code is '|| f_zip);

2450: f_zip := v_postal_code;
2451: f_zip_extension := null;
2452: end if;
2453: hr_utility.trace('country code is '|| v_country);
2454: hr_utility.trace('postal code is '|| f_zip);
2455: hr_utility.trace('postal extension code is '|| f_zip_extension);
2456:
2457: --
2458: hr_utility.set_location(l_api_name, 10);

Line 2455: hr_utility.trace('postal extension code is '|| f_zip_extension);

2451: f_zip_extension := null;
2452: end if;
2453: hr_utility.trace('country code is '|| v_country);
2454: hr_utility.trace('postal code is '|| f_zip);
2455: hr_utility.trace('postal extension code is '|| f_zip_extension);
2456:
2457: --
2458: hr_utility.set_location(l_api_name, 10);
2459: close get_address_record;

Line 2458: hr_utility.set_location(l_api_name, 10);

2454: hr_utility.trace('postal code is '|| f_zip);
2455: hr_utility.trace('postal extension code is '|| f_zip_extension);
2456:
2457: --
2458: hr_utility.set_location(l_api_name, 10);
2459: close get_address_record;
2460: --
2461: --
2462: p_address_line1 := f_address_line1;

Line 2473: hr_utility.set_location('Leaving...:' || l_api_name, 50);

2469: p_country := v_country;
2470: --
2471: end if;
2472: --
2473: hr_utility.set_location('Leaving...:' || l_api_name, 50);
2474: --
2475: exception when NO_DATA_FOUND then NULL;
2476: --
2477: end get_employee_address_3lines;

Line 2531: hr_utility.set_location('Entering....:' || l_api_name,10);

2527:
2528: --
2529: begin
2530: --
2531: hr_utility.set_location('Entering....:' || l_api_name,10);
2532: --
2533: OPEN c_new_hire_record;
2534: --LOOP
2535: FETCH c_new_hire_record INTO v_contact_name, v_contact_title, v_contact_phone;

Line 2546: hr_utility.trace('Contact name : '||v_contact_name);

2542: --END LOOP;
2543:
2544: CLOSE c_new_hire_record;
2545: --
2546: hr_utility.trace('Contact name : '||v_contact_name);
2547: hr_utility.trace('Contact title : '||v_contact_title);
2548: hr_utility.set_location('Leaving....:' || l_api_name ,100);
2549: --
2550: exception

Line 2547: hr_utility.trace('Contact title : '||v_contact_title);

2543:
2544: CLOSE c_new_hire_record;
2545: --
2546: hr_utility.trace('Contact name : '||v_contact_name);
2547: hr_utility.trace('Contact title : '||v_contact_title);
2548: hr_utility.set_location('Leaving....:' || l_api_name ,100);
2549: --
2550: exception
2551: when no_data_found then

Line 2548: hr_utility.set_location('Leaving....:' || l_api_name ,100);

2544: CLOSE c_new_hire_record;
2545: --
2546: hr_utility.trace('Contact name : '||v_contact_name);
2547: hr_utility.trace('Contact title : '||v_contact_title);
2548: hr_utility.set_location('Leaving....:' || l_api_name ,100);
2549: --
2550: exception
2551: when no_data_found then
2552: hr_utility.set_location('Error found in ' || l_api_name,20);

Line 2552: hr_utility.set_location('Error found in ' || l_api_name,20);

2548: hr_utility.set_location('Leaving....:' || l_api_name ,100);
2549: --
2550: exception
2551: when no_data_found then
2552: hr_utility.set_location('Error found in ' || l_api_name,20);
2553: NULL;
2554: when others then
2555: hr_utility.set_location('Error found in ' || l_api_name,30);
2556: --

Line 2555: hr_utility.set_location('Error found in ' || l_api_name,30);

2551: when no_data_found then
2552: hr_utility.set_location('Error found in ' || l_api_name,20);
2553: NULL;
2554: when others then
2555: hr_utility.set_location('Error found in ' || l_api_name,30);
2556: --
2557: end get_new_hire_contact;
2558: --
2559: --