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_UTILITY

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

122: l_stage_rec_count number(10):= 0 ;
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

Line 269: hr_utility.set_location('Leaving:'|| l_proc, 30);

265: into l_stage_rec_count
266: from hr_h2pi_us_modified_geocodes
267: where client_id = l_from_client_id;
268:
269: hr_utility.set_location('Leaving:'|| l_proc, 30);
270: if l_stage_rec_count > 0 then
271: return TRUE;
272: else
273: return FALSE;

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

284: l_dstatus varchar2(80);
285: l_message varchar2(80);
286: l_proc varchar2(72) := g_package || 'get_request_id';
287: BEGIN
288: hr_utility.set_location('Entering:' || l_proc,10);
289: l_call_status := fnd_concurrent.get_request_status
290: (l_request_id,
291: 'PER',
292: p_process,

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

294: l_rstatus,
295: l_dphase,
296: l_dstatus,
297: l_message);
298: hr_utility.set_location('Leaving:' || l_proc,20);
299: return l_request_id;
300: EXCEPTION
301: when others then
302: hr_utility.set_location(l_proc,30);

Line 302: hr_utility.set_location(l_proc,30);

298: hr_utility.set_location('Leaving:' || l_proc,20);
299: return l_request_id;
300: EXCEPTION
301: when others then
302: hr_utility.set_location(l_proc,30);
303: fnd_message.raise_error;
304: END get_request_id;
305:
306:

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

309: l_from_business_group_id NUMBER(15);
310: l_proc VARCHAR2(72) := g_package||'get_from_business_group_id';
311:
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

Line 318: hr_utility.set_location(l_proc, 20);

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,
321: p_table_name => 'HR_H2PI_BG_AND_GRE',
322: p_message_level => 'FATAL',

Line 326: hr_utility.set_location('Leaving:'|| l_proc, 30);

322: p_message_level => 'FATAL',
323: p_message_name => 'HR_289241_MAPPING_ID_MISSING');
324: END IF;
325:
326: hr_utility.set_location('Leaving:'|| l_proc, 30);
327: RETURN l_from_business_group_id;
328: END;
329:
330: PROCEDURE upload_core (p_from_client_id NUMBER) IS

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

332: l_proc VARCHAR2(72) := g_package||'upload_core';
333: l_message VARCHAR2(2000);
334:
335: BEGIN
336: hr_utility.set_location('Entering:'|| l_proc, 10);
337:
338: hr_h2pi_validate.validate_bg_and_gre(p_from_client_id);
339: hr_h2pi_validate.validate_pay_basis(p_from_client_id);
340: hr_h2pi_validate.validate_payroll(p_from_client_id);

Line 346: hr_utility.set_location(l_proc, 20);

342: hr_h2pi_validate.validate_element_type(p_from_client_id);
343: hr_h2pi_validate.validate_element_link(p_from_client_id);
344: hr_h2pi_validate.validate_geocode(p_from_client_id);
345: IF hr_h2pi_error.check_for_errors THEN
346: hr_utility.set_location(l_proc, 20);
347: hr_h2pi_error.generate_error_report;
348: clear_staging_tables(p_from_client_id);
349: return;
350: END IF;

Line 352: hr_utility.set_location(l_proc, 30);

348: clear_staging_tables(p_from_client_id);
349: return;
350: END IF;
351:
352: hr_utility.set_location(l_proc, 30);
353: hr_h2pi_bg_upload.upload_location(p_from_client_id);
354: hr_h2pi_bg_upload.upload_hr_organization(p_from_client_id);
355: hr_h2pi_bg_upload.upload_element_type(p_from_client_id);
356: IF hr_h2pi_error.check_for_errors THEN

Line 357: hr_utility.set_location(l_proc, 40);

353: hr_h2pi_bg_upload.upload_location(p_from_client_id);
354: hr_h2pi_bg_upload.upload_hr_organization(p_from_client_id);
355: hr_h2pi_bg_upload.upload_element_type(p_from_client_id);
356: IF hr_h2pi_error.check_for_errors THEN
357: hr_utility.set_location(l_proc, 40);
358: hr_h2pi_error.generate_error_report;
359: return;
360: END IF;
361:

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

358: hr_h2pi_error.generate_error_report;
359: return;
360: END IF;
361:
362: hr_utility.set_location(l_proc, 50);
363: hr_h2pi_person_upload.upload_person_level(p_from_client_id);
364: IF hr_h2pi_error.check_for_errors THEN
365: hr_utility.set_location(l_proc, 60);
366: hr_h2pi_error.generate_error_report;

Line 365: hr_utility.set_location(l_proc, 60);

361:
362: hr_utility.set_location(l_proc, 50);
363: hr_h2pi_person_upload.upload_person_level(p_from_client_id);
364: IF hr_h2pi_error.check_for_errors THEN
365: hr_utility.set_location(l_proc, 60);
366: hr_h2pi_error.generate_error_report;
367: return;
368: ELSE
369: DELETE FROM hr_h2pi_message_lines

Line 376: hr_utility.set_location('Leaving:'|| l_proc, 70);

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;
375:
376: hr_utility.set_location('Leaving:'|| l_proc, 70);
377:
378: END;
379:
380: PROCEDURE upload (p_errbuf OUT NOCOPY VARCHAR2,

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

388: l_from_business_group_id hr_all_organization_units.organization_id%TYPE;
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:

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

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);
400: ELSE
401: hr_h2pi_upload.upload(p_errbuf => p_errbuf,
402: p_retcode => p_retcode,
403: p_file_name => p_file_name);

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

402: p_retcode => p_retcode,
403: p_file_name => p_file_name);
404:
405: upload_core(l_from_client_id);
406: hr_utility.set_location('Leaving:'|| l_proc, 20);
407: END IF;
408: END;
409:
410: -- Remove retry upload after removing concurrent program.

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

418: l_from_business_group_id hr_all_organization_units.organization_id%TYPE;
419: l_from_client_id hr_all_organization_units.organization_id%TYPE;
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;

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

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;
431: --
432: END hr_h2pi_main_upload;