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.HR_H2PI_MAIN_UPLOAD dependencies on HR_H2PI_UPLOAD

Line 127: l_from_client_id := hr_h2pi_upload.get_from_client_id;

123: l_from_client_id number(15);
124:
125: BEGIN
126: hr_utility.set_location('Entering:'|| l_proc, 10);
127: l_from_client_id := hr_h2pi_upload.get_from_client_id;
128:
129: select l_stage_rec_count + count(*)
130: into l_stage_rec_count
131: from hr_h2pi_addresses

Line 316: p_to_id => hr_h2pi_upload.g_to_business_group_id);

312: BEGIN
313: hr_utility.set_location('Entering:'|| l_proc, 10);
314: l_from_business_group_id := hr_h2pi_map.get_from_id
315: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',
316: p_to_id => hr_h2pi_upload.g_to_business_group_id);
317: IF l_from_business_group_id = -1 THEN
318: hr_utility.set_location(l_proc, 20);
319: hr_h2pi_error.data_error
320: (p_from_id => hr_h2pi_upload.g_to_business_group_id,

Line 320: (p_from_id => hr_h2pi_upload.g_to_business_group_id,

316: p_to_id => hr_h2pi_upload.g_to_business_group_id);
317: IF l_from_business_group_id = -1 THEN
318: hr_utility.set_location(l_proc, 20);
319: hr_h2pi_error.data_error
320: (p_from_id => hr_h2pi_upload.g_to_business_group_id,
321: p_table_name => 'HR_H2PI_BG_AND_GRE',
322: p_message_level => 'FATAL',
323: p_message_name => 'HR_289241_MAPPING_ID_MISSING');
324: END IF;

Line 370: WHERE to_business_group_id = hr_h2pi_upload.g_to_business_group_id;

366: hr_h2pi_error.generate_error_report;
367: return;
368: ELSE
369: DELETE FROM hr_h2pi_message_lines
370: WHERE to_business_group_id = hr_h2pi_upload.g_to_business_group_id;
371: fnd_message.set_name('PER', 'HR_289295_UPLOAD_SUCCESSFULL');
372: l_message := fnd_message.get_string('PER','HR_289295_UPLOAD_SUCCESSFULL');
373: fnd_file.put_line(FND_FILE.LOG,l_message);
374: END IF;

Line 393: hr_h2pi_upload.g_request_id := get_request_id('H2PI_UPLOAD');

389: l_from_client_id hr_all_organization_units.organization_id%TYPE;
390:
391: BEGIN
392: hr_utility.set_location('Entering:'|| l_proc, 10);
393: hr_h2pi_upload.g_request_id := get_request_id('H2PI_UPLOAD');
394: hr_h2pi_upload.g_to_business_group_id := p_business_group_id;
395: l_from_client_id := hr_h2pi_upload.get_from_client_id;
396:
397: IF check_incomplete_upload THEN

Line 394: hr_h2pi_upload.g_to_business_group_id := p_business_group_id;

390:
391: BEGIN
392: hr_utility.set_location('Entering:'|| l_proc, 10);
393: hr_h2pi_upload.g_request_id := get_request_id('H2PI_UPLOAD');
394: hr_h2pi_upload.g_to_business_group_id := p_business_group_id;
395: l_from_client_id := hr_h2pi_upload.get_from_client_id;
396:
397: IF check_incomplete_upload THEN
398: upload_core(l_from_client_id);

Line 395: l_from_client_id := hr_h2pi_upload.get_from_client_id;

391: BEGIN
392: hr_utility.set_location('Entering:'|| l_proc, 10);
393: hr_h2pi_upload.g_request_id := get_request_id('H2PI_UPLOAD');
394: hr_h2pi_upload.g_to_business_group_id := p_business_group_id;
395: l_from_client_id := hr_h2pi_upload.get_from_client_id;
396:
397: IF check_incomplete_upload THEN
398: upload_core(l_from_client_id);
399: hr_utility.set_location('Leaving:'|| l_proc, 20);

Line 401: hr_h2pi_upload.upload(p_errbuf => p_errbuf,

397: IF check_incomplete_upload THEN
398: upload_core(l_from_client_id);
399: hr_utility.set_location('Leaving:'|| l_proc, 20);
400: ELSE
401: hr_h2pi_upload.upload(p_errbuf => p_errbuf,
402: p_retcode => p_retcode,
403: p_file_name => p_file_name);
404:
405: upload_core(l_from_client_id);

Line 424: hr_h2pi_upload.g_request_id := get_request_id('H2PI_RETRY_UPLOAD');

420:
421: BEGIN
422: hr_utility.set_location('Entering:'|| l_proc, 10);
423:
424: hr_h2pi_upload.g_request_id := get_request_id('H2PI_RETRY_UPLOAD');
425: hr_h2pi_upload.g_to_business_group_id := p_business_group_id;
426: l_from_client_id := hr_h2pi_upload.get_from_client_id;
427:
428: --upload_core(l_from_client_id);

Line 425: hr_h2pi_upload.g_to_business_group_id := p_business_group_id;

421: BEGIN
422: hr_utility.set_location('Entering:'|| l_proc, 10);
423:
424: hr_h2pi_upload.g_request_id := get_request_id('H2PI_RETRY_UPLOAD');
425: hr_h2pi_upload.g_to_business_group_id := p_business_group_id;
426: l_from_client_id := hr_h2pi_upload.get_from_client_id;
427:
428: --upload_core(l_from_client_id);
429: hr_utility.set_location('Leaving:'|| l_proc, 20);

Line 426: l_from_client_id := hr_h2pi_upload.get_from_client_id;

422: hr_utility.set_location('Entering:'|| l_proc, 10);
423:
424: hr_h2pi_upload.g_request_id := get_request_id('H2PI_RETRY_UPLOAD');
425: hr_h2pi_upload.g_to_business_group_id := p_business_group_id;
426: l_from_client_id := hr_h2pi_upload.get_from_client_id;
427:
428: --upload_core(l_from_client_id);
429: hr_utility.set_location('Leaving:'|| l_proc, 20);
430: END;