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

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

231: BEGIN
232:
233: -- input parameters
234:
235: hr_utility.set_location('p_file_name '||p_file_name,1);
236: hr_utility.set_location('p_effective_date '||p_effective_date,1);
237: hr_utility.set_location('p_business_group_id '||p_business_group_id,1 );
238: hr_utility.set_location('p_delimiter '||p_delimiter,1);
239: hr_utility.set_location('p_action_if_exists '||p_action_if_exists,1);

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

232:
233: -- input parameters
234:
235: hr_utility.set_location('p_file_name '||p_file_name,1);
236: hr_utility.set_location('p_effective_date '||p_effective_date,1);
237: hr_utility.set_location('p_business_group_id '||p_business_group_id,1 );
238: hr_utility.set_location('p_delimiter '||p_delimiter,1);
239: hr_utility.set_location('p_action_if_exists '||p_action_if_exists,1);
240: hr_utility.set_location('p_date_effective_changes '||p_date_effective_changes,1);

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

233: -- input parameters
234:
235: hr_utility.set_location('p_file_name '||p_file_name,1);
236: hr_utility.set_location('p_effective_date '||p_effective_date,1);
237: hr_utility.set_location('p_business_group_id '||p_business_group_id,1 );
238: hr_utility.set_location('p_delimiter '||p_delimiter,1);
239: hr_utility.set_location('p_action_if_exists '||p_action_if_exists,1);
240: hr_utility.set_location('p_date_effective_changes '||p_date_effective_changes,1);
241: hr_utility.set_location('p_batch_name '||p_batch_name,1);

Line 238: hr_utility.set_location('p_delimiter '||p_delimiter,1);

234:
235: hr_utility.set_location('p_file_name '||p_file_name,1);
236: hr_utility.set_location('p_effective_date '||p_effective_date,1);
237: hr_utility.set_location('p_business_group_id '||p_business_group_id,1 );
238: hr_utility.set_location('p_delimiter '||p_delimiter,1);
239: hr_utility.set_location('p_action_if_exists '||p_action_if_exists,1);
240: hr_utility.set_location('p_date_effective_changes '||p_date_effective_changes,1);
241: hr_utility.set_location('p_batch_name '||p_batch_name,1);
242:

Line 239: hr_utility.set_location('p_action_if_exists '||p_action_if_exists,1);

235: hr_utility.set_location('p_file_name '||p_file_name,1);
236: hr_utility.set_location('p_effective_date '||p_effective_date,1);
237: hr_utility.set_location('p_business_group_id '||p_business_group_id,1 );
238: hr_utility.set_location('p_delimiter '||p_delimiter,1);
239: hr_utility.set_location('p_action_if_exists '||p_action_if_exists,1);
240: hr_utility.set_location('p_date_effective_changes '||p_date_effective_changes,1);
241: hr_utility.set_location('p_batch_name '||p_batch_name,1);
242:
243:

Line 240: hr_utility.set_location('p_date_effective_changes '||p_date_effective_changes,1);

236: hr_utility.set_location('p_effective_date '||p_effective_date,1);
237: hr_utility.set_location('p_business_group_id '||p_business_group_id,1 );
238: hr_utility.set_location('p_delimiter '||p_delimiter,1);
239: hr_utility.set_location('p_action_if_exists '||p_action_if_exists,1);
240: hr_utility.set_location('p_date_effective_changes '||p_date_effective_changes,1);
241: hr_utility.set_location('p_batch_name '||p_batch_name,1);
242:
243:
244:

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

237: hr_utility.set_location('p_business_group_id '||p_business_group_id,1 );
238: hr_utility.set_location('p_delimiter '||p_delimiter,1);
239: hr_utility.set_location('p_action_if_exists '||p_action_if_exists,1);
240: hr_utility.set_location('p_date_effective_changes '||p_date_effective_changes,1);
241: hr_utility.set_location('p_batch_name '||p_batch_name,1);
242:
243:
244:
245: hr_utility.set_location ( 'Entering:' || l_proc, 10);

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

241: hr_utility.set_location('p_batch_name '||p_batch_name,1);
242:
243:
244:
245: hr_utility.set_location ( 'Entering:' || l_proc, 10);
246: OPEN csr_leg (p_business_group_id);
247: FETCH csr_leg INTO l_legislation_code;
248: CLOSE csr_leg;
249: hr_utility.set_location ( 'Legislation = ' || l_legislation_code, 20);

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

245: hr_utility.set_location ( 'Entering:' || l_proc, 10);
246: OPEN csr_leg (p_business_group_id);
247: FETCH csr_leg INTO l_legislation_code;
248: CLOSE csr_leg;
249: hr_utility.set_location ( 'Legislation = ' || l_legislation_code, 20);
250:
251: l_filename := p_file_name;
252: fnd_profile.get (c_data_exchange_dir, l_location);
253: hr_utility.set_location ( 'directory = ' || l_location, 30);

Line 253: hr_utility.set_location ( 'directory = ' || l_location, 30);

249: hr_utility.set_location ( 'Legislation = ' || l_legislation_code, 20);
250:
251: l_filename := p_file_name;
252: fnd_profile.get (c_data_exchange_dir, l_location);
253: hr_utility.set_location ( 'directory = ' || l_location, 30);
254:
255: IF l_location IS NULL
256: THEN
257: -- error : I/O directory not defined

Line 296: hr_utility.set_location (l_proc, 180);

292: THEN
293: UTL_FILE.fclose (l_file_handle);
294: END IF;
295:
296: hr_utility.set_location (l_proc, 180);
297: retcode := c_error;
298: -- The error will mean batch_seq doesn't get upped so add 1 when
299: -- reporting line
300: errbuf := 'Input line (line nr = '

Line 312: hr_utility.set_location ( 'line read: '

308: THEN
309: EXIT;
310: END;
311:
312: hr_utility.set_location ( 'line read: '
313: || SUBSTR (l_line_read, 1, 40),
314: 30
315: );
316:

Line 359: hr_utility.set_message (800, 'HR_78041_NO_MATCHING_TYPE');

355: THEN
356: -- Set retcode to 1, indicating a WARNING to the ConcMgr
357: retcode := c_warning;
358: -- Set the application error
359: hr_utility.set_message (800, 'HR_78041_NO_MATCHING_TYPE');
360: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
361: hr_utility.set_message_token (800, 'LINE', l_line_read);
362: -- Write the message to log file, do not raise an application error but continue
363: -- (with next line)

Line 360: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);

356: -- Set retcode to 1, indicating a WARNING to the ConcMgr
357: retcode := c_warning;
358: -- Set the application error
359: hr_utility.set_message (800, 'HR_78041_NO_MATCHING_TYPE');
360: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
361: hr_utility.set_message_token (800, 'LINE', l_line_read);
362: -- Write the message to log file, do not raise an application error but continue
363: -- (with next line)
364: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

Line 361: hr_utility.set_message_token (800, 'LINE', l_line_read);

357: retcode := c_warning;
358: -- Set the application error
359: hr_utility.set_message (800, 'HR_78041_NO_MATCHING_TYPE');
360: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
361: hr_utility.set_message_token (800, 'LINE', l_line_read);
362: -- Write the message to log file, do not raise an application error but continue
363: -- (with next line)
364: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
365:

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

360: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
361: hr_utility.set_message_token (800, 'LINE', l_line_read);
362: -- Write the message to log file, do not raise an application error but continue
363: -- (with next line)
364: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
365:
366: WHEN e_no_matching_element
367: -- The element_name or element_id provided does not match an element in the database
368: THEN

Line 372: hr_utility.set_message (800, 'HR_78042_NO_MATCHING_ELEMENT');

368: THEN
369: -- Set retcode to 1, indicating a WARNING to the ConcMgr
370: retcode := c_warning;
371: -- Set the application error
372: hr_utility.set_message (800, 'HR_78042_NO_MATCHING_ELEMENT');
373: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
374: hr_utility.set_message_token (800, 'LINE', l_line_read);
375: -- Write the message to log file, do not raise an application error but continue
376: -- (with next line)

Line 373: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);

369: -- Set retcode to 1, indicating a WARNING to the ConcMgr
370: retcode := c_warning;
371: -- Set the application error
372: hr_utility.set_message (800, 'HR_78042_NO_MATCHING_ELEMENT');
373: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
374: hr_utility.set_message_token (800, 'LINE', l_line_read);
375: -- Write the message to log file, do not raise an application error but continue
376: -- (with next line)
377: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

Line 374: hr_utility.set_message_token (800, 'LINE', l_line_read);

370: retcode := c_warning;
371: -- Set the application error
372: hr_utility.set_message (800, 'HR_78042_NO_MATCHING_ELEMENT');
373: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
374: hr_utility.set_message_token (800, 'LINE', l_line_read);
375: -- Write the message to log file, do not raise an application error but continue
376: -- (with next line)
377: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
378:

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

373: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
374: hr_utility.set_message_token (800, 'LINE', l_line_read);
375: -- Write the message to log file, do not raise an application error but continue
376: -- (with next line)
377: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
378:
379: WHEN e_no_matching_assignment
380: -- The assignment id or assignment number provided do not match an assignment in the database
381: THEN

Line 385: hr_utility.set_message (800, 'HR_78044_NO_MATCHING_ASSG'); -- name too long

381: THEN
382: -- Set retcode to 1, indicating a WARNING to the ConcMgr
383: retcode := c_warning;
384: -- Set the application error
385: hr_utility.set_message (800, 'HR_78044_NO_MATCHING_ASSG'); -- name too long
386: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
387: hr_utility.set_message_token (800, 'LINE', l_line_read);
388: -- Write the message to log file, do not raise an application error but continue
389: -- (with next line)

Line 386: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);

382: -- Set retcode to 1, indicating a WARNING to the ConcMgr
383: retcode := c_warning;
384: -- Set the application error
385: hr_utility.set_message (800, 'HR_78044_NO_MATCHING_ASSG'); -- name too long
386: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
387: hr_utility.set_message_token (800, 'LINE', l_line_read);
388: -- Write the message to log file, do not raise an application error but continue
389: -- (with next line)
390: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

Line 387: hr_utility.set_message_token (800, 'LINE', l_line_read);

383: retcode := c_warning;
384: -- Set the application error
385: hr_utility.set_message (800, 'HR_78044_NO_MATCHING_ASSG'); -- name too long
386: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
387: hr_utility.set_message_token (800, 'LINE', l_line_read);
388: -- Write the message to log file, do not raise an application error but continue
389: -- (with next line)
390: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
391:

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

386: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
387: hr_utility.set_message_token (800, 'LINE', l_line_read);
388: -- Write the message to log file, do not raise an application error but continue
389: -- (with next line)
390: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
391:
392: WHEN e_wrong_id_type
393: -- The id type provided provided does not match P(erson), N(ational Identifier),
394: -- E(mployee number or A(ssignment). Currently these are the only id's accepted.

Line 399: hr_utility.set_message (800, 'HR_78043_WRONG_ID_TYPE');

395: THEN
396: -- Set retcode to 1, indicating a WARNING to the ConcMgr
397: retcode := c_warning;
398: -- Set the application error
399: hr_utility.set_message (800, 'HR_78043_WRONG_ID_TYPE');
400: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
401: hr_utility.set_message_token (800, 'LINE', l_line_read);
402: -- Write the message to log file, do not raise an application error but continue
403: -- (with next line)

Line 400: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);

396: -- Set retcode to 1, indicating a WARNING to the ConcMgr
397: retcode := c_warning;
398: -- Set the application error
399: hr_utility.set_message (800, 'HR_78043_WRONG_ID_TYPE');
400: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
401: hr_utility.set_message_token (800, 'LINE', l_line_read);
402: -- Write the message to log file, do not raise an application error but continue
403: -- (with next line)
404: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

Line 401: hr_utility.set_message_token (800, 'LINE', l_line_read);

397: retcode := c_warning;
398: -- Set the application error
399: hr_utility.set_message (800, 'HR_78043_WRONG_ID_TYPE');
400: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
401: hr_utility.set_message_token (800, 'LINE', l_line_read);
402: -- Write the message to log file, do not raise an application error but continue
403: -- (with next line)
404: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
405:

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

400: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
401: hr_utility.set_message_token (800, 'LINE', l_line_read);
402: -- Write the message to log file, do not raise an application error but continue
403: -- (with next line)
404: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
405:
406: WHEN e_effective_date_issue
407: -- The dates provided for the effective date fields are not in the correct format
408: THEN

Line 413: hr_utility.set_message (800, 'HR_78036_WRONG_DATE_FORMAT');

409: -- Set retcode to 1, indicating a WARNING to the ConcMgr
410: retcode := c_warning;
411:
412: -- Set the application error
413: hr_utility.set_message (800, 'HR_78036_WRONG_DATE_FORMAT');
414: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
415: hr_utility.set_message_token (800, 'FORMAT',fnd_date.user_mask);
416:
417:

Line 414: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);

410: retcode := c_warning;
411:
412: -- Set the application error
413: hr_utility.set_message (800, 'HR_78036_WRONG_DATE_FORMAT');
414: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
415: hr_utility.set_message_token (800, 'FORMAT',fnd_date.user_mask);
416:
417:
418: hr_utility.set_message_token (800, 'LINE', l_line_read);

Line 415: hr_utility.set_message_token (800, 'FORMAT',fnd_date.user_mask);

411:
412: -- Set the application error
413: hr_utility.set_message (800, 'HR_78036_WRONG_DATE_FORMAT');
414: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
415: hr_utility.set_message_token (800, 'FORMAT',fnd_date.user_mask);
416:
417:
418: hr_utility.set_message_token (800, 'LINE', l_line_read);
419: -- Write the message to log file, do not raise an application error but continue

Line 418: hr_utility.set_message_token (800, 'LINE', l_line_read);

414: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
415: hr_utility.set_message_token (800, 'FORMAT',fnd_date.user_mask);
416:
417:
418: hr_utility.set_message_token (800, 'LINE', l_line_read);
419: -- Write the message to log file, do not raise an application error but continue
420: -- (with next line)
421:
422: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

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

418: hr_utility.set_message_token (800, 'LINE', l_line_read);
419: -- Write the message to log file, do not raise an application error but continue
420: -- (with next line)
421:
422: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
423:
424: WHEN e_conf_flag_not_set
425: -- The confirmation flag is not set in the text file for NPA process
426: THEN

Line 431: hr_utility.set_message (800, 'PAY_KR_CONF_FLAG_NOT_SET');

427: -- Set retcode to 1, indicating a WARNING to the ConcMgr
428: retcode := c_warning;
429:
430: -- Set the application error
431: hr_utility.set_message (800, 'PAY_KR_CONF_FLAG_NOT_SET');
432: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
433: hr_utility.set_message_token (800, 'LINE', l_line_read);
434: -- Write the message to log file, do not raise an application error but continue
435: -- (with next line)

Line 432: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);

428: retcode := c_warning;
429:
430: -- Set the application error
431: hr_utility.set_message (800, 'PAY_KR_CONF_FLAG_NOT_SET');
432: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
433: hr_utility.set_message_token (800, 'LINE', l_line_read);
434: -- Write the message to log file, do not raise an application error but continue
435: -- (with next line)
436:

Line 433: hr_utility.set_message_token (800, 'LINE', l_line_read);

429:
430: -- Set the application error
431: hr_utility.set_message (800, 'PAY_KR_CONF_FLAG_NOT_SET');
432: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
433: hr_utility.set_message_token (800, 'LINE', l_line_read);
434: -- Write the message to log file, do not raise an application error but continue
435: -- (with next line)
436:
437: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);

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

433: hr_utility.set_message_token (800, 'LINE', l_line_read);
434: -- Write the message to log file, do not raise an application error but continue
435: -- (with next line)
436:
437: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
438:
439: WHEN VALUE_ERROR
440: -- A field in the file does not match type with the field in the BEE table or the field
441: -- is to long

Line 449: hr_utility.set_message (800, 'HR_78035_VALUE_ERROR');

445: retcode := c_warning;
446:
447: -- Set the application error
448:
449: hr_utility.set_message (800, 'HR_78035_VALUE_ERROR');
450: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
451: hr_utility.set_message_token (800, 'LINE', l_line_read);
452:
453: -- Write the message to log file, do not raise an application error but continue

Line 450: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);

446:
447: -- Set the application error
448:
449: hr_utility.set_message (800, 'HR_78035_VALUE_ERROR');
450: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
451: hr_utility.set_message_token (800, 'LINE', l_line_read);
452:
453: -- Write the message to log file, do not raise an application error but continue
454: -- (with next line)

Line 451: hr_utility.set_message_token (800, 'LINE', l_line_read);

447: -- Set the application error
448:
449: hr_utility.set_message (800, 'HR_78035_VALUE_ERROR');
450: hr_utility.set_message_token (800, 'LINE_NR', l_batch_seq);
451: hr_utility.set_message_token (800, 'LINE', l_line_read);
452:
453: -- Write the message to log file, do not raise an application error but continue
454: -- (with next line)
455:

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

452:
453: -- Write the message to log file, do not raise an application error but continue
454: -- (with next line)
455:
456: fnd_file.put_line (fnd_file.LOG, hr_utility.get_message);
457: END;
458: END LOOP read_lines_in_file;
459:
460: -- Commit the outstanding records

Line 463: hr_utility.set_location ( 'Leaving:'|| l_proc, 50);

459:
460: -- Commit the outstanding records
461: COMMIT;
462: UTL_FILE.fclose (l_file_handle);
463: hr_utility.set_location ( 'Leaving:'|| l_proc, 50);
464:
465: -- Most off these exceptions are not translated as they should not happen normally
466: -- If they do happen, something is seriously wrong and SysAdmin interference will be necessary.
467:

Line 478: hr_utility.set_location (l_proc, 100);

474: THEN
475: UTL_FILE.fclose (l_file_handle);
476: END IF;
477:
478: hr_utility.set_location (l_proc, 100);
479:
480: -- Set retcode to 2, indicating an ERROR to the ConcMgr
481: retcode := c_error;
482:

Line 484: hr_utility.set_message (800, 'HR_78040_DATA_EXCHANGE_DIR_MIS');

480: -- Set retcode to 2, indicating an ERROR to the ConcMgr
481: retcode := c_error;
482:
483: -- Set the application error
484: hr_utility.set_message (800, 'HR_78040_DATA_EXCHANGE_DIR_MIS');
485:
486: -- Return the message to the ConcMgr (This msg will appear in the log file)
487: errbuf := hr_utility.get_message;
488:

Line 487: errbuf := hr_utility.get_message;

483: -- Set the application error
484: hr_utility.set_message (800, 'HR_78040_DATA_EXCHANGE_DIR_MIS');
485:
486: -- Return the message to the ConcMgr (This msg will appear in the log file)
487: errbuf := hr_utility.get_message;
488:
489: WHEN UTL_FILE.invalid_operation
490: -- File could not be opened as requested, perhaps because of operating system permissions
491: -- Also raised when attempting a write operation on a file opened for read, or a read operation

Line 500: hr_utility.set_location (l_proc, 110);

496: THEN
497: UTL_FILE.fclose (l_file_handle);
498: END IF;
499:
500: hr_utility.set_location (l_proc, 110);
501: retcode := c_error;
502: errbuf := 'Reading File ('||l_location ||' -> '
503: || l_filename
504: || ') - Invalid Operation.';

Line 513: hr_utility.set_location (l_proc, 120);

509: THEN
510: UTL_FILE.fclose (l_file_handle);
511: END IF;
512:
513: hr_utility.set_location (l_proc, 120);
514: retcode := c_error;
515: errbuf := 'Reading File ('
516: || l_location
517: || ' -> '

Line 529: hr_utility.set_location (l_proc, 130);

525: THEN
526: UTL_FILE.fclose (l_file_handle);
527: END IF;
528:
529: hr_utility.set_location (l_proc, 130);
530: retcode := c_error;
531: errbuf := 'Reading File ('
532: || l_location
533: || ' -> '

Line 551: hr_utility.set_location (l_proc, 140);

547: || l_location
548: || ' -> '
549: || l_filename
550: || ') - Invalid Path or Filename.';
551: hr_utility.set_location (l_proc, 140);
552:
553: WHEN UTL_FILE.invalid_filehandle
554: -- File handle does not specify an open file
555: THEN

Line 561: hr_utility.set_location (l_proc, 150);

557: THEN
558: UTL_FILE.fclose (l_file_handle);
559: END IF;
560:
561: hr_utility.set_location (l_proc, 150);
562: retcode := c_error;
563: errbuf := 'Reading File ('
564: || l_location
565: || ' -> '

Line 577: hr_utility.set_location (l_proc, 160);

573: THEN
574: UTL_FILE.fclose (l_file_handle);
575: END IF;
576:
577: hr_utility.set_location (l_proc, 160);
578: retcode := c_error;
579: errbuf := 'Reading File ('
580: || l_location
581: || ' -> '

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

621: l_final_process_date per_periods_of_service.final_process_date%TYPE := NULL;
622:
623:
624: BEGIN
625: hr_utility.set_location ( 'Entering:'|| l_proc, 10);
626:
627: -- First field in file is the session_date, this should be NULL
628: BEGIN
629: p_batch_line.session_date :=

Line 1006: hr_utility.set_location ( 'Leaving:'

1002: p_batch_line.entry_information29 :=
1003: get_field (p_line => l_line, p_delimiter => p_delimiter);
1004: p_batch_line.entry_information30 :=
1005: get_field (p_line => l_line, p_delimiter => p_delimiter);
1006: hr_utility.set_location ( 'Leaving:'
1007: || l_proc, 1000);
1008: END break_up_line;
1009:
1010: -- This function will take a string in which fields are delimited and return the field that is identified

Line 1038: hr_utility.set_location (

1034: IF (l_position > 0)
1035: THEN
1036: l_field := SUBSTR (p_line, 1, l_position
1037: - 1);
1038: hr_utility.set_location (
1039: RPAD ('Field', 31)
1040: || RPAD (LPAD (l_position, 3), 4)
1041: || l_field,
1042: 70

Line 1090: hr_utility.set_location ( 'Entering:'

1086: c_batch_source VARCHAR2 (50) := g_batch_source;
1087: c_comments VARCHAR2 (100) := g_batch_comments ;
1088:
1089: BEGIN
1090: hr_utility.set_location ( 'Entering:'
1091: || l_proc, 10);
1092:
1093: -- CREATE_BATCH_HEADER definition
1094: /****************************************************************

Line 1137: hr_utility.set_location ( 'Leaving:'

1133: p_comments => c_comments,
1134: p_batch_id => p_batch_id, -- out
1135: p_object_version_number => p_ovn -- out
1136: );
1137: hr_utility.set_location ( 'Leaving:'
1138: || l_proc, 20);
1139: END create_batch_header;
1140:
1141: PROCEDURE create_batch_line (

Line 1260: hr_utility.set_location ( 'Entering:'

1256: l_proc CONSTANT VARCHAR2 (72)
1257: := g_package || 'create_batch_line';
1258: c_element_entry CONSTANT VARCHAR2 (30) := 'E';
1259: BEGIN
1260: hr_utility.set_location ( 'Entering:'
1261: || l_proc, 10);
1262: -- CREATE_BATCH_LINE definition
1263: /****************************************************************
1264: procedure create_batch_line

Line 1410: hr_utility.set_location ( 'Leaving:'|| l_proc, 20);

1406: p_entry_information30 => p_entry_information20,
1407: p_batch_line_id => p_bl_id, -- out
1408: p_object_version_number => p_ovn -- out
1409: );
1410: hr_utility.set_location ( 'Leaving:'|| l_proc, 20);
1411: END create_batch_line;
1412:
1413: -- OVERLOADING PROCEDURE
1414:

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

1420: IS
1421: l_proc CONSTANT VARCHAR2 (72)
1422: := g_package|| 'create_batch_line';
1423: BEGIN
1424: hr_utility.set_location ( 'Entering:'|| l_proc, 10);
1425:
1426: create_batch_line (
1427: p_session_date => p_batch_line.session_date,
1428: p_batch_id => p_batch_line.batch_id,

Line 1540: hr_utility.set_location ( 'Leaving:'

1536: p_entry_information30 => p_batch_line.entry_information30,
1537: p_bl_id => p_bline_id,
1538: p_ovn => p_obj_vn
1539: );
1540: hr_utility.set_location ( 'Leaving:'
1541: || l_proc, 20);
1542: END create_batch_line;
1543:
1544: FUNCTION correct_type_id (p_id_type VARCHAR2)

Line 1668: hr_utility.set_location ( 'Entering:'

1664: l_dt_start per_periods_of_service.date_start%TYPE := NULL;
1665: l_finproc_dt per_periods_of_service.final_process_date%TYPE
1666: := NULL;
1667: BEGIN
1668: hr_utility.set_location ( 'Entering:'
1669: || l_proc, 10);
1670: hr_utility.set_location ( 'Effective Date used:
1671: '|| p_effective_date, 20
1672: );

Line 1670: hr_utility.set_location ( 'Effective Date used:

1666: := NULL;
1667: BEGIN
1668: hr_utility.set_location ( 'Entering:'
1669: || l_proc, 10);
1670: hr_utility.set_location ( 'Effective Date used:
1671: '|| p_effective_date, 20
1672: );
1673:
1674: IF (p_id_type = c_type_assignment_id)

Line 1755: hr_utility.set_location ( 'Leaving:'

1751: p_assg_nr := NULL;
1752: p_assg_id := NULL;
1753: END IF;
1754:
1755: hr_utility.set_location ( 'Leaving:'
1756: || l_proc, 100);
1757: END get_assignment_info;
1758:
1759: PROCEDURE get_element_info (

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

1801:
1802: l_element_type_id pay_element_types_f.element_type_id%TYPE;
1803: l_element_name pay_element_types_f.element_name%TYPE;
1804: BEGIN
1805: hr_utility.set_location ( 'Entering:' || l_proc, 10);
1806: -- Added for Bug# 2485470
1807: -- Start of Bug# 2485470
1808:
1809: IF (p_element_name IS NULL) AND (p_element_type_id IS NOT NULL) THEN

Line 1852: hr_utility.set_location ( 'Leaving:' || l_proc, 100);

1848: p_element_name := NULL;
1849: END IF;
1850:
1851: -- End of Bug# 2485470
1852: hr_utility.set_location ( 'Leaving:' || l_proc, 100);
1853: END get_element_info;
1854:
1855:
1856: /* procedure to upload health insurance info */