eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_SE_TAX_CARD dependencies on HR_UTILITY

Line 211: hr_utility.set_location('p_file_name '||p_file_name,1);

207: VALUES(userenv('SESSIONID'),fnd_date.canonical_to_date(p_effective_date)) ;
208:
209: -- input parameters
210:
211: hr_utility.set_location('p_file_name '||p_file_name,1);
212: hr_utility.set_location('p_effective_date '||p_effective_date,1);
213: hr_utility.set_location('p_business_group_id '||p_business_group_id,1 );
214: hr_utility.set_location('p_batch_name '||p_batch_name,1);
215:

Line 212: hr_utility.set_location('p_effective_date '||p_effective_date,1);

208:
209: -- input parameters
210:
211: hr_utility.set_location('p_file_name '||p_file_name,1);
212: hr_utility.set_location('p_effective_date '||p_effective_date,1);
213: hr_utility.set_location('p_business_group_id '||p_business_group_id,1 );
214: hr_utility.set_location('p_batch_name '||p_batch_name,1);
215:
216: hr_utility.set_location ( 'Entering:' || l_proc, 10);

Line 213: hr_utility.set_location('p_business_group_id '||p_business_group_id,1 );

209: -- input parameters
210:
211: hr_utility.set_location('p_file_name '||p_file_name,1);
212: hr_utility.set_location('p_effective_date '||p_effective_date,1);
213: hr_utility.set_location('p_business_group_id '||p_business_group_id,1 );
214: hr_utility.set_location('p_batch_name '||p_batch_name,1);
215:
216: hr_utility.set_location ( 'Entering:' || l_proc, 10);
217:

Line 214: hr_utility.set_location('p_batch_name '||p_batch_name,1);

210:
211: hr_utility.set_location('p_file_name '||p_file_name,1);
212: hr_utility.set_location('p_effective_date '||p_effective_date,1);
213: hr_utility.set_location('p_business_group_id '||p_business_group_id,1 );
214: hr_utility.set_location('p_batch_name '||p_batch_name,1);
215:
216: hr_utility.set_location ( 'Entering:' || l_proc, 10);
217:
218: OPEN csr_leg (p_business_group_id);

Line 216: hr_utility.set_location ( 'Entering:' || l_proc, 10);

212: hr_utility.set_location('p_effective_date '||p_effective_date,1);
213: hr_utility.set_location('p_business_group_id '||p_business_group_id,1 );
214: hr_utility.set_location('p_batch_name '||p_batch_name,1);
215:
216: hr_utility.set_location ( 'Entering:' || l_proc, 10);
217:
218: OPEN csr_leg (p_business_group_id);
219: FETCH csr_leg
220: INTO l_legislation_code, l_bg_name;

Line 223: hr_utility.set_location ( 'Legislation = ' || l_legislation_code, 20);

219: FETCH csr_leg
220: INTO l_legislation_code, l_bg_name;
221: CLOSE csr_leg;
222:
223: hr_utility.set_location ( 'Legislation = ' || l_legislation_code, 20);
224:
225: l_filename := p_file_name;
226: fnd_profile.get (c_data_exchange_dir, l_location);
227:

Line 228: hr_utility.set_location ( 'Directory = ' || l_location, 30);

224:
225: l_filename := p_file_name;
226: fnd_profile.get (c_data_exchange_dir, l_location);
227:
228: hr_utility.set_location ( 'Directory = ' || l_location, 30);
229:
230: IF l_location IS NULL
231: THEN
232: hr_utility.set_location ( 'Raising I/O error = ' || l_location, 35);

Line 232: hr_utility.set_location ( 'Raising I/O error = ' || l_location, 35);

228: hr_utility.set_location ( 'Directory = ' || l_location, 30);
229:
230: IF l_location IS NULL
231: THEN
232: hr_utility.set_location ( 'Raising I/O error = ' || l_location, 35);
233: -- error : I/O directory not defined
234: RAISE e_fatal_error;
235: END IF;
236:

Line 247: hr_utility.set_location ( ' Batch ID = ' || l_batch_id, 40);

243: (p_batch_name => p_batch_name,
244: p_business_group_name => l_bg_name,
245: p_reference => substr(p_reference||'('||fnd_date.date_to_displaydt(SYSDATE)||')',1,30));
246:
247: hr_utility.set_location ( ' Batch ID = ' || l_batch_id, 40);
248:
249: -- Loop over the file, reading in each line. GET_LINE will
250: -- raise NO_DATA_FOUND when it is done, so we use that as the
251: -- exit condition for the loop

Line 267: hr_utility.set_location (l_proc, 50);

263: THEN
264: UTL_FILE.fclose (l_file_type);
265: END IF;
266:
267: hr_utility.set_location (l_proc, 50);
268: retcode := c_error;
269: -- The error will mean batch_seq doesn't get upped so add 1 when
270: -- reporting line
271: errbuf := 'Input line (line nr = '|| l_batch_seq + 1 || ') too large for buffer (=' || c_max_linesize || ').';

Line 278: hr_utility.set_location ( ' line read: ' || SUBSTR (l_line_read, 1, 40),60);

274: THEN
275: EXIT;
276: END;
277:
278: hr_utility.set_location ( ' line read: ' || SUBSTR (l_line_read, 1, 40),60);
279:
280: BEGIN
281:
282: -- setting default value for element link found flag

Line 308: hr_utility.set_location ( ' PIN = ' || l_pin, 130);

304: ,p_return_value1 => l_pin
305: ,p_return_value2 => l_employer_org_no
306: );
307:
308: hr_utility.set_location ( ' PIN = ' || l_pin, 130);
309: hr_utility.set_location ( ' Employer Organization Number = ' || l_employer_org_no, 140);
310:
311: OPEN csr_get_prim_assg ( p_business_group_id => p_business_group_id
312: ,p_pin => l_pin ) ;

Line 309: hr_utility.set_location ( ' Employer Organization Number = ' || l_employer_org_no, 140);

305: ,p_return_value2 => l_employer_org_no
306: );
307:
308: hr_utility.set_location ( ' PIN = ' || l_pin, 130);
309: hr_utility.set_location ( ' Employer Organization Number = ' || l_employer_org_no, 140);
310:
311: OPEN csr_get_prim_assg ( p_business_group_id => p_business_group_id
312: ,p_pin => l_pin ) ;
313: FETCH csr_get_prim_assg

Line 317: hr_utility.set_location ( ' The Employee Does not have a primary Assignment ' , 150);

313: FETCH csr_get_prim_assg
314: INTO l_assignment_id;
315: IF csr_get_prim_assg%NOTFOUND
316: THEN
317: hr_utility.set_location ( ' The Employee Does not have a primary Assignment ' , 150);
318: RAISE e_prim_assg_error;
319: END IF;
320: CLOSE csr_get_prim_assg;
321:

Line 322: hr_utility.set_location ( ' assignment_id = ' || l_assignment_id, 160);

318: RAISE e_prim_assg_error;
319: END IF;
320: CLOSE csr_get_prim_assg;
321:
322: hr_utility.set_location ( ' assignment_id = ' || l_assignment_id, 160);
323:
324: OPEN csr_get_element_details(l_assignment_id ) ;
325: FETCH csr_get_element_details
326: INTO l_element_entry_id,l_element_name,l_effective_start_date,l_effective_end_date;

Line 334: hr_utility.set_location ( ' Element Entry ID = ' || l_element_entry_id, 170);

330: l_element_link_found := 'NOT_FOUND';
331: END IF;
332: CLOSE csr_get_element_details;
333:
334: hr_utility.set_location ( ' Element Entry ID = ' || l_element_entry_id, 170);
335: hr_utility.set_location ( ' Element Name = ' || l_element_name, 171);
336: hr_utility.set_location ( ' Element Entry Start Date = '||l_effective_start_date, 172);
337: hr_utility.set_location ( ' Element Entry End Date = '||l_effective_end_date, 173);
338:

Line 335: hr_utility.set_location ( ' Element Name = ' || l_element_name, 171);

331: END IF;
332: CLOSE csr_get_element_details;
333:
334: hr_utility.set_location ( ' Element Entry ID = ' || l_element_entry_id, 170);
335: hr_utility.set_location ( ' Element Name = ' || l_element_name, 171);
336: hr_utility.set_location ( ' Element Entry Start Date = '||l_effective_start_date, 172);
337: hr_utility.set_location ( ' Element Entry End Date = '||l_effective_end_date, 173);
338:
339: IF g_process = 'TCU' THEN

Line 336: hr_utility.set_location ( ' Element Entry Start Date = '||l_effective_start_date, 172);

332: CLOSE csr_get_element_details;
333:
334: hr_utility.set_location ( ' Element Entry ID = ' || l_element_entry_id, 170);
335: hr_utility.set_location ( ' Element Name = ' || l_element_name, 171);
336: hr_utility.set_location ( ' Element Entry Start Date = '||l_effective_start_date, 172);
337: hr_utility.set_location ( ' Element Entry End Date = '||l_effective_end_date, 173);
338:
339: IF g_process = 'TCU' THEN
340:

Line 337: hr_utility.set_location ( ' Element Entry End Date = '||l_effective_end_date, 173);

333:
334: hr_utility.set_location ( ' Element Entry ID = ' || l_element_entry_id, 170);
335: hr_utility.set_location ( ' Element Name = ' || l_element_name, 171);
336: hr_utility.set_location ( ' Element Entry Start Date = '||l_effective_start_date, 172);
337: hr_utility.set_location ( ' Element Entry End Date = '||l_effective_end_date, 173);
338:
339: IF g_process = 'TCU' THEN
340:
341: l_input_value_name1 := 'Method of Receipt' ;

Line 370: hr_utility.set_location ( ' The Element Staus = '||l_element_link_found , 174);

366: CLOSE csr_get_element_details;
367:
368: l_element_link_id := get_element_link_id(l_assignment_id ,p_business_group_id,p_effective_date,'Tax Card');
369:
370: hr_utility.set_location ( ' The Element Staus = '||l_element_link_found , 174);
371: hr_utility.set_location ( ' Element Entry ID = ' || l_element_entry_id, 175);
372: hr_utility.set_location ( ' Element Name = ' || l_element_name, 176);
373: hr_utility.set_location ( ' Element Entry Start Date = '||l_effective_start_date, 177);
374: hr_utility.set_location ( ' Element Entry End Date = '||l_effective_end_date, 178);

Line 371: hr_utility.set_location ( ' Element Entry ID = ' || l_element_entry_id, 175);

367:
368: l_element_link_id := get_element_link_id(l_assignment_id ,p_business_group_id,p_effective_date,'Tax Card');
369:
370: hr_utility.set_location ( ' The Element Staus = '||l_element_link_found , 174);
371: hr_utility.set_location ( ' Element Entry ID = ' || l_element_entry_id, 175);
372: hr_utility.set_location ( ' Element Name = ' || l_element_name, 176);
373: hr_utility.set_location ( ' Element Entry Start Date = '||l_effective_start_date, 177);
374: hr_utility.set_location ( ' Element Entry End Date = '||l_effective_end_date, 178);
375: hr_utility.set_location ( ' Element Link ID = ' || l_element_link_id, 180);

Line 372: hr_utility.set_location ( ' Element Name = ' || l_element_name, 176);

368: l_element_link_id := get_element_link_id(l_assignment_id ,p_business_group_id,p_effective_date,'Tax Card');
369:
370: hr_utility.set_location ( ' The Element Staus = '||l_element_link_found , 174);
371: hr_utility.set_location ( ' Element Entry ID = ' || l_element_entry_id, 175);
372: hr_utility.set_location ( ' Element Name = ' || l_element_name, 176);
373: hr_utility.set_location ( ' Element Entry Start Date = '||l_effective_start_date, 177);
374: hr_utility.set_location ( ' Element Entry End Date = '||l_effective_end_date, 178);
375: hr_utility.set_location ( ' Element Link ID = ' || l_element_link_id, 180);
376:

Line 373: hr_utility.set_location ( ' Element Entry Start Date = '||l_effective_start_date, 177);

369:
370: hr_utility.set_location ( ' The Element Staus = '||l_element_link_found , 174);
371: hr_utility.set_location ( ' Element Entry ID = ' || l_element_entry_id, 175);
372: hr_utility.set_location ( ' Element Name = ' || l_element_name, 176);
373: hr_utility.set_location ( ' Element Entry Start Date = '||l_effective_start_date, 177);
374: hr_utility.set_location ( ' Element Entry End Date = '||l_effective_end_date, 178);
375: hr_utility.set_location ( ' Element Link ID = ' || l_element_link_id, 180);
376:
377: -- Add User Keys for Data Pump

Line 374: hr_utility.set_location ( ' Element Entry End Date = '||l_effective_end_date, 178);

370: hr_utility.set_location ( ' The Element Staus = '||l_element_link_found , 174);
371: hr_utility.set_location ( ' Element Entry ID = ' || l_element_entry_id, 175);
372: hr_utility.set_location ( ' Element Name = ' || l_element_name, 176);
373: hr_utility.set_location ( ' Element Entry Start Date = '||l_effective_start_date, 177);
374: hr_utility.set_location ( ' Element Entry End Date = '||l_effective_end_date, 178);
375: hr_utility.set_location ( ' Element Link ID = ' || l_element_link_id, 180);
376:
377: -- Add User Keys for Data Pump
378: L_EE_USER_KEY :=NULL;

Line 375: hr_utility.set_location ( ' Element Link ID = ' || l_element_link_id, 180);

371: hr_utility.set_location ( ' Element Entry ID = ' || l_element_entry_id, 175);
372: hr_utility.set_location ( ' Element Name = ' || l_element_name, 176);
373: hr_utility.set_location ( ' Element Entry Start Date = '||l_effective_start_date, 177);
374: hr_utility.set_location ( ' Element Entry End Date = '||l_effective_end_date, 178);
375: hr_utility.set_location ( ' Element Link ID = ' || l_element_link_id, 180);
376:
377: -- Add User Keys for Data Pump
378: L_EE_USER_KEY :=NULL;
379: L_ASSIGNMENT_USER_KEY :=NULL;

Line 391: hr_utility.set_location ( ' User Key added ' , 190);

387: l_unique_key_id := user_key_to_id(l_ee_user_key);
388: IF l_unique_key_id = 0
389: THEN
390: hr_pump_utils.add_user_key(l_ee_user_key,l_element_entry_id);
391: hr_utility.set_location ( ' User Key added ' , 190);
392: ELSE
393: hr_pump_utils.modify_user_key(l_ee_user_key,l_ee_user_key,l_element_entry_id);
394: hr_utility.set_location ( ' User Key Modified ' , 190.1);
395:

Line 394: hr_utility.set_location ( ' User Key Modified ' , 190.1);

390: hr_pump_utils.add_user_key(l_ee_user_key,l_element_entry_id);
391: hr_utility.set_location ( ' User Key added ' , 190);
392: ELSE
393: hr_pump_utils.modify_user_key(l_ee_user_key,l_ee_user_key,l_element_entry_id);
394: hr_utility.set_location ( ' User Key Modified ' , 190.1);
395:
396: END IF ;
397:
398: /* Initialize values for input value names of the seeded element */

Line 400: hr_utility.set_location ( ' l_effective_start_date:' || to_char(l_effective_start_date), 191);

396: END IF ;
397:
398: /* Initialize values for input value names of the seeded element */
399:
400: hr_utility.set_location ( ' l_effective_start_date:' || to_char(l_effective_start_date), 191);
401: hr_utility.set_location ( ' l_effective_end_date:' || to_char(l_effective_end_date), 192);
402: hr_utility.set_location ( ' p_effective_date:' || to_char(fnd_date.canonical_to_date(p_effective_date)), 193);
403: hr_utility.set_location ( ' c_end_of_time:' || to_char(c_end_of_time), 194);
404:

Line 401: hr_utility.set_location ( ' l_effective_end_date:' || to_char(l_effective_end_date), 192);

397:
398: /* Initialize values for input value names of the seeded element */
399:
400: hr_utility.set_location ( ' l_effective_start_date:' || to_char(l_effective_start_date), 191);
401: hr_utility.set_location ( ' l_effective_end_date:' || to_char(l_effective_end_date), 192);
402: hr_utility.set_location ( ' p_effective_date:' || to_char(fnd_date.canonical_to_date(p_effective_date)), 193);
403: hr_utility.set_location ( ' c_end_of_time:' || to_char(c_end_of_time), 194);
404:
405: -- Define Datetrack Updation Mode

Line 402: hr_utility.set_location ( ' p_effective_date:' || to_char(fnd_date.canonical_to_date(p_effective_date)), 193);

398: /* Initialize values for input value names of the seeded element */
399:
400: hr_utility.set_location ( ' l_effective_start_date:' || to_char(l_effective_start_date), 191);
401: hr_utility.set_location ( ' l_effective_end_date:' || to_char(l_effective_end_date), 192);
402: hr_utility.set_location ( ' p_effective_date:' || to_char(fnd_date.canonical_to_date(p_effective_date)), 193);
403: hr_utility.set_location ( ' c_end_of_time:' || to_char(c_end_of_time), 194);
404:
405: -- Define Datetrack Updation Mode
406: IF(l_effective_start_date = fnd_date.canonical_to_date(p_effective_date))

Line 403: hr_utility.set_location ( ' c_end_of_time:' || to_char(c_end_of_time), 194);

399:
400: hr_utility.set_location ( ' l_effective_start_date:' || to_char(l_effective_start_date), 191);
401: hr_utility.set_location ( ' l_effective_end_date:' || to_char(l_effective_end_date), 192);
402: hr_utility.set_location ( ' p_effective_date:' || to_char(fnd_date.canonical_to_date(p_effective_date)), 193);
403: hr_utility.set_location ( ' c_end_of_time:' || to_char(c_end_of_time), 194);
404:
405: -- Define Datetrack Updation Mode
406: IF(l_effective_start_date = fnd_date.canonical_to_date(p_effective_date))
407: THEN

Line 416: hr_utility.set_location ( ' Datetrack Update Mode:' || l_datetrack_update_mode, 200);

412: ELSE
413: l_datetrack_update_mode := 'UPDATE';
414: END IF;
415:
416: hr_utility.set_location ( ' Datetrack Update Mode:' || l_datetrack_update_mode, 200);
417:
418: -- Data Pump procedure called to create batch lines to update element entries
419: hrdpp_update_element_entry.insert_batch_lines
420: (

Line 459: hr_utility.set_location ( ' Batch Lines created for Element Updation: ' , 210);

455: ,P_INPUT_VALUE_NAME13 => l_input_value_name13
456: ,P_INPUT_VALUE_NAME14 => l_input_value_name14
457: ,P_INPUT_VALUE_NAME15 => l_input_value_name15);
458:
459: hr_utility.set_location ( ' Batch Lines created for Element Updation: ' , 210);
460:
461: ELSE
462: L_EE_USER_KEY :=to_char(l_assignment_id )||to_char(L_ELEMENT_LINK_ID) ||' : ELEMENT ENTRY USER KEY';
463: L_ASSIGNMENT_USER_KEY :=to_char(l_assignment_id )||to_char(L_ELEMENT_LINK_ID) ||' : ASG USER KEY';

Line 472: hr_utility.set_location ( ' User Key deleted: ' , 201);

468: l_unique_key_id := user_key_to_id(l_ee_user_key);
469: IF l_unique_key_id > 0
470: THEN
471: BEGIN
472: hr_utility.set_location ( ' User Key deleted: ' , 201);
473: DELETE FROM HR_PUMP_BATCH_LINE_USER_KEYS WHERE unique_key_id =l_unique_key_id;
474: end;
475: END IF ;
476:

Line 482: hr_utility.set_location ( ' User Key Added: ' , 202);

478:
479: l_unique_key_id := user_key_to_id(L_ASSIGNMENT_USER_KEY);
480: IF l_unique_key_id = 0
481: THEN
482: hr_utility.set_location ( ' User Key Added: ' , 202);
483: hr_pump_utils.add_user_key(L_ASSIGNMENT_USER_KEY,L_ASSIGNMENT_ID);
484: END IF ;
485:
486: l_unique_key_id := user_key_to_id(L_ELEMENT_LINK_USER_KEY);

Line 489: hr_utility.set_location ( ' User Key Added: ' , 203);

485:
486: l_unique_key_id := user_key_to_id(L_ELEMENT_LINK_USER_KEY);
487: IF l_unique_key_id = 0
488: THEN
489: hr_utility.set_location ( ' User Key Added: ' , 203);
490: hr_pump_utils.add_user_key(L_ELEMENT_LINK_USER_KEY,L_ELEMENT_LINK_ID);
491: END IF ;
492:
493: hrdpp_create_element_entry.insert_batch_lines

Line 535: hr_utility.set_location ( ' Batch Lines created for Element Creation: ' , 210);

531: ,P_INPUT_VALUE_NAME13 => l_input_value_name13
532: ,P_INPUT_VALUE_NAME14 => l_input_value_name14
533: ,P_INPUT_VALUE_NAME15 => l_input_value_name15);
534:
535: hr_utility.set_location ( ' Batch Lines created for Element Creation: ' , 210);
536:
537: END IF ;
538:
539: hr_utility.set_location ( ' Batch Lines created ' , 220);

Line 539: hr_utility.set_location ( ' Batch Lines created ' , 220);

535: hr_utility.set_location ( ' Batch Lines created for Element Creation: ' , 210);
536:
537: END IF ;
538:
539: hr_utility.set_location ( ' Batch Lines created ' , 220);
540:
541: -- commit the records uppon reaching the commit point
542:
543: IF MOD (l_batch_seq, c_commit_point) = 0

Line 556: hr_utility.set_message (801, 'HR_377216_SE_WRONG_CSR_ROUTINE');

552: -- Set retcode to 1, indicating a WARNING to the ConcMgr
553: retcode := c_warning;
554:
555: -- Set the application error
556: hr_utility.set_message (801, 'HR_377216_SE_WRONG_CSR_ROUTINE');
557: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
558: hr_utility.set_message_token (801, 'LINE', l_line_read);
559: hr_utility.set_location (l_proc, 230);
560:

Line 557: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);

553: retcode := c_warning;
554:
555: -- Set the application error
556: hr_utility.set_message (801, 'HR_377216_SE_WRONG_CSR_ROUTINE');
557: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
558: hr_utility.set_message_token (801, 'LINE', l_line_read);
559: hr_utility.set_location (l_proc, 230);
560:
561: -- Write the message to log file, do not raise an application error but continue

Line 558: hr_utility.set_message_token (801, 'LINE', l_line_read);

554:
555: -- Set the application error
556: hr_utility.set_message (801, 'HR_377216_SE_WRONG_CSR_ROUTINE');
557: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
558: hr_utility.set_message_token (801, 'LINE', l_line_read);
559: hr_utility.set_location (l_proc, 230);
560:
561: -- Write the message to log file, do not raise an application error but continue
562: -- (with next line)

Line 559: hr_utility.set_location (l_proc, 230);

555: -- Set the application error
556: hr_utility.set_message (801, 'HR_377216_SE_WRONG_CSR_ROUTINE');
557: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
558: hr_utility.set_message_token (801, 'LINE', l_line_read);
559: hr_utility.set_location (l_proc, 230);
560:
561: -- Write the message to log file, do not raise an application error but continue
562: -- (with next line)
563:

Line 564: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

560:
561: -- Write the message to log file, do not raise an application error but continue
562: -- (with next line)
563:
564: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
565:
566: WHEN e_prim_assg_error
567: -- No primary assignment found for given PIN and Organization Number
568: THEN

Line 578: hr_utility.set_message (801, 'HR_377217_SE_ASSG_NOT_FOUND');

574: -- Set retcode to 1, indicating a WARNING to the ConcMgr
575: retcode := c_warning;
576:
577: -- Set the application error
578: hr_utility.set_message (801, 'HR_377217_SE_ASSG_NOT_FOUND');
579: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
580: hr_utility.set_message_token (801, 'LINE', l_line_read);
581: hr_utility.set_location (l_proc, 240);
582:

Line 579: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);

575: retcode := c_warning;
576:
577: -- Set the application error
578: hr_utility.set_message (801, 'HR_377217_SE_ASSG_NOT_FOUND');
579: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
580: hr_utility.set_message_token (801, 'LINE', l_line_read);
581: hr_utility.set_location (l_proc, 240);
582:
583: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

Line 580: hr_utility.set_message_token (801, 'LINE', l_line_read);

576:
577: -- Set the application error
578: hr_utility.set_message (801, 'HR_377217_SE_ASSG_NOT_FOUND');
579: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
580: hr_utility.set_message_token (801, 'LINE', l_line_read);
581: hr_utility.set_location (l_proc, 240);
582:
583: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
584:

Line 581: hr_utility.set_location (l_proc, 240);

577: -- Set the application error
578: hr_utility.set_message (801, 'HR_377217_SE_ASSG_NOT_FOUND');
579: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
580: hr_utility.set_message_token (801, 'LINE', l_line_read);
581: hr_utility.set_location (l_proc, 240);
582:
583: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
584:
585: WHEN e_err_in_csr

Line 583: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

579: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
580: hr_utility.set_message_token (801, 'LINE', l_line_read);
581: hr_utility.set_location (l_proc, 240);
582:
583: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
584:
585: WHEN e_err_in_csr
586: -- SVARSKOD field in CSR4 reply indicates error
587: THEN

Line 592: hr_utility.set_message (801, 'HR_377218_SE_ERROR_CSR_RECORD');

588: -- Set retcode to 1, indicating a WARNING to the ConcMgr
589: retcode := c_warning;
590:
591: -- Set the application error
592: hr_utility.set_message (801, 'HR_377218_SE_ERROR_CSR_RECORD');
593: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
594: hr_utility.set_message_token (801, 'LINE', l_line_read);
595: hr_utility.set_location (l_proc, 250);
596:

Line 593: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);

589: retcode := c_warning;
590:
591: -- Set the application error
592: hr_utility.set_message (801, 'HR_377218_SE_ERROR_CSR_RECORD');
593: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
594: hr_utility.set_message_token (801, 'LINE', l_line_read);
595: hr_utility.set_location (l_proc, 250);
596:
597: -- Write the message to log file, do not raise an application error but continue

Line 594: hr_utility.set_message_token (801, 'LINE', l_line_read);

590:
591: -- Set the application error
592: hr_utility.set_message (801, 'HR_377218_SE_ERROR_CSR_RECORD');
593: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
594: hr_utility.set_message_token (801, 'LINE', l_line_read);
595: hr_utility.set_location (l_proc, 250);
596:
597: -- Write the message to log file, do not raise an application error but continue
598: -- (with next line)

Line 595: hr_utility.set_location (l_proc, 250);

591: -- Set the application error
592: hr_utility.set_message (801, 'HR_377218_SE_ERROR_CSR_RECORD');
593: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
594: hr_utility.set_message_token (801, 'LINE', l_line_read);
595: hr_utility.set_location (l_proc, 250);
596:
597: -- Write the message to log file, do not raise an application error but continue
598: -- (with next line)
599:

Line 600: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

596:
597: -- Write the message to log file, do not raise an application error but continue
598: -- (with next line)
599:
600: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
601:
602: WHEN e_record_too_long
603: --Record is too long
604: THEN

Line 609: hr_utility.set_message (801, 'HR_377215_SE_RECORD_TOO_LONG');

605: -- Set retcode to 1, indicating a WARNING to the ConcMgr
606: retcode := c_warning;
607:
608: -- Set the application error
609: hr_utility.set_message (801, 'HR_377215_SE_RECORD_TOO_LONG');
610: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
611: hr_utility.set_message_token (801, 'LINE', l_line_read);
612: hr_utility.set_location (l_proc, 260);
613:

Line 610: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);

606: retcode := c_warning;
607:
608: -- Set the application error
609: hr_utility.set_message (801, 'HR_377215_SE_RECORD_TOO_LONG');
610: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
611: hr_utility.set_message_token (801, 'LINE', l_line_read);
612: hr_utility.set_location (l_proc, 260);
613:
614: -- Write the message to log file, do not raise an application error but continue

Line 611: hr_utility.set_message_token (801, 'LINE', l_line_read);

607:
608: -- Set the application error
609: hr_utility.set_message (801, 'HR_377215_SE_RECORD_TOO_LONG');
610: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
611: hr_utility.set_message_token (801, 'LINE', l_line_read);
612: hr_utility.set_location (l_proc, 260);
613:
614: -- Write the message to log file, do not raise an application error but continue
615: -- (with next line)

Line 612: hr_utility.set_location (l_proc, 260);

608: -- Set the application error
609: hr_utility.set_message (801, 'HR_377215_SE_RECORD_TOO_LONG');
610: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
611: hr_utility.set_message_token (801, 'LINE', l_line_read);
612: hr_utility.set_location (l_proc, 260);
613:
614: -- Write the message to log file, do not raise an application error but continue
615: -- (with next line)
616:

Line 617: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

613:
614: -- Write the message to log file, do not raise an application error but continue
615: -- (with next line)
616:
617: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
618:
619: WHEN e_no_tax_link
620: THEN
621: -- Set retcode to 1, indicating a WARNING to the ConcMgr

Line 625: hr_utility.set_message (801, 'HR_377219_SE_NO_TAX_CARD_LINK');

621: -- Set retcode to 1, indicating a WARNING to the ConcMgr
622: retcode := c_warning;
623:
624: -- Set the application error
625: hr_utility.set_message (801, 'HR_377219_SE_NO_TAX_CARD_LINK');
626: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
627: hr_utility.set_message_token (801, 'LINE', l_line_read);
628: hr_utility.set_location (l_proc, 255);
629:

Line 626: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);

622: retcode := c_warning;
623:
624: -- Set the application error
625: hr_utility.set_message (801, 'HR_377219_SE_NO_TAX_CARD_LINK');
626: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
627: hr_utility.set_message_token (801, 'LINE', l_line_read);
628: hr_utility.set_location (l_proc, 255);
629:
630: -- Write the message to log file, do not raise an application error but continue

Line 627: hr_utility.set_message_token (801, 'LINE', l_line_read);

623:
624: -- Set the application error
625: hr_utility.set_message (801, 'HR_377219_SE_NO_TAX_CARD_LINK');
626: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
627: hr_utility.set_message_token (801, 'LINE', l_line_read);
628: hr_utility.set_location (l_proc, 255);
629:
630: -- Write the message to log file, do not raise an application error but continue
631: -- (with next line)

Line 628: hr_utility.set_location (l_proc, 255);

624: -- Set the application error
625: hr_utility.set_message (801, 'HR_377219_SE_NO_TAX_CARD_LINK');
626: hr_utility.set_message_token (801, 'LINE_NO', l_batch_seq);
627: hr_utility.set_message_token (801, 'LINE', l_line_read);
628: hr_utility.set_location (l_proc, 255);
629:
630: -- Write the message to log file, do not raise an application error but continue
631: -- (with next line)
632:

Line 633: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

629:
630: -- Write the message to log file, do not raise an application error but continue
631: -- (with next line)
632:
633: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
634:
635: END;
636: END LOOP read_lines_in_file;
637:

Line 642: hr_utility.set_location ( 'Leaving:'|| l_proc, 260);

638: -- Commit the outstanding records
639: COMMIT;
640:
641: UTL_FILE.fclose (l_file_type);
642: hr_utility.set_location ( 'Leaving:'|| l_proc, 260);
643:
644: -- Most of these exceptions are not translated as they should not happen normally
645: -- If they do happen, something is seriously wrong and SysAdmin interference will be necessary.
646:

Line 657: hr_utility.set_location (l_proc, 270);

653: THEN
654: UTL_FILE.fclose (l_file_type);
655: END IF;
656:
657: hr_utility.set_location (l_proc, 270);
658: -- Set retcode to 2, indicating an ERROR to the ConcMgr
659: retcode := c_error;
660:
661: -- Set the application error

Line 662: hr_utility.set_message (801, 'HR_SE_DATA_EXCHANGE_DIR_MIS');

658: -- Set retcode to 2, indicating an ERROR to the ConcMgr
659: retcode := c_error;
660:
661: -- Set the application error
662: hr_utility.set_message (801, 'HR_SE_DATA_EXCHANGE_DIR_MIS');
663:
664: -- Return the message to the ConcMgr (This msg will appear in the log file)
665: errbuf := hr_utility.get_message;
666:

Line 665: errbuf := hr_utility.get_message;

661: -- Set the application error
662: hr_utility.set_message (801, 'HR_SE_DATA_EXCHANGE_DIR_MIS');
663:
664: -- Return the message to the ConcMgr (This msg will appear in the log file)
665: errbuf := hr_utility.get_message;
666:
667: WHEN UTL_FILE.invalid_operation
668: -- File could not be opened as requested, perhaps because of operating system permissions
669: -- Also raised when attempting a write operation on a file opened for read, or a read operation

Line 677: hr_utility.set_location (l_proc, 280);

673: THEN
674: UTL_FILE.fclose (l_file_type);
675: END IF;
676:
677: hr_utility.set_location (l_proc, 280);
678: retcode := c_error;
679: errbuf := 'Reading File ('||l_location ||' -> ' || l_filename || ') - Invalid Operation.';
680:
681: WHEN UTL_FILE.internal_error

Line 689: hr_utility.set_location (l_proc, 290);

685: THEN
686: UTL_FILE.fclose (l_file_type);
687: END IF;
688:
689: hr_utility.set_location (l_proc, 290);
690: retcode := c_error;
691: errbuf := 'Reading File (' || l_location || ' -> ' || l_filename || ') - Internal Error.';
692:
693: WHEN UTL_FILE.invalid_mode

Line 701: hr_utility.set_location (l_proc, 300);

697: THEN
698: UTL_FILE.fclose (l_file_type);
699: END IF;
700:
701: hr_utility.set_location (l_proc, 300);
702: retcode := c_error;
703: errbuf := 'Reading File (' || l_location || ' -> ' || l_filename || ') - Invalid Mode.';
704:
705: WHEN UTL_FILE.invalid_path

Line 715: hr_utility.set_location (l_proc, 310);

711: END IF;
712:
713: retcode := c_error;
714: errbuf := 'Reading File (' || l_location || ' -> ' || l_filename || ') - Invalid Path or Filename.';
715: hr_utility.set_location (l_proc, 310);
716:
717: WHEN UTL_FILE.invalid_filehandle
718: -- File type does not specify an open file
719: THEN

Line 725: hr_utility.set_location (l_proc, 320);

721: THEN
722: UTL_FILE.fclose (l_file_type);
723: END IF;
724:
725: hr_utility.set_location (l_proc, 320);
726: retcode := c_error;
727: errbuf := 'Reading File (' || l_location || ' -> ' || l_filename || ') - Invalid File Type.';
728: WHEN UTL_FILE.read_error
729:

Line 737: hr_utility.set_location (l_proc, 330);

733: THEN
734: UTL_FILE.fclose (l_file_type);
735: END IF;
736:
737: hr_utility.set_location (l_proc, 330);
738: retcode := c_error;
739: errbuf := 'Reading File (' || l_location || ' -> ' || l_filename || ') - Read Error.';
740: END upload;
741:

Line 798: hr_utility.set_location ( 'Entering:'|| l_proc, 70);

794: l_proc CONSTANT VARCHAR2 (72) := g_package|| '.read_record';
795:
796: BEGIN
797:
798: hr_utility.set_location ( 'Entering:'|| l_proc, 70);
799:
800: IF (p_process = 'TCU') THEN
801:
802: /* p_entry_value1 Method Of Receipt ( Not from file)

Line 814: hr_utility.set_location ( ' Record length:'|| l_record_length, 80);

810: */
811:
812: --Set record length
813: l_record_length := 73;
814: hr_utility.set_location ( ' Record length:'|| l_record_length, 80);
815:
816: IF ( substr( p_line, 1,4 )= 'CSR4') THEN
817: p_entry_value1 := 'ET';
818: /* Organization Number of Legal Employer */

Line 834: hr_utility.set_location ( ' SVARSKOD:'|| l_extra_value3, 90);

830: l_extra_value2 := substr( p_line ,37,3);
831: /*SVARSKOD, Value not zero marks an error, 1 position*/
832: l_extra_value3 := substr( p_line ,40,1);
833:
834: hr_utility.set_location ( ' SVARSKOD:'|| l_extra_value3, 90);
835: IF to_number(l_extra_value3) <> 0
836: THEN
837: RAISE e_err_in_csr;
838: END IF;

Line 876: hr_utility.set_location ( ' Wrong CSR routine', 100);

872: /*RESERV, Reserved for the Tax Office, 3 positions*/
873: l_extra_value8 := substr( p_line ,70,3);
874:
875: ELSE
876: hr_utility.set_location ( ' Wrong CSR routine', 100);
877: RAISE e_wrong_csr_routine;
878: END IF;
879: END IF;
880:

Line 884: hr_utility.set_location ( ' Record too long', 110);

880:
881: -- Error in record if it is too long according to given format
882: IF (length(p_line)> l_record_length)
883: THEN
884: hr_utility.set_location ( ' Record too long', 110);
885: RAISE e_record_too_long;
886: END IF;
887:
888: hr_utility.set_location ( 'Leaving:'|| l_proc, 120);

Line 888: hr_utility.set_location ( 'Leaving:'|| l_proc, 120);

884: hr_utility.set_location ( ' Record too long', 110);
885: RAISE e_record_too_long;
886: END IF;
887:
888: hr_utility.set_location ( 'Leaving:'|| l_proc, 120);
889:
890: END read_record;
891:
892: