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',
323: p_message_name => 'HR_289241_MAPPING_ID_MISSING');
341: hr_h2pi_validate.validate_org_payment_method(p_from_client_id);
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;
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;
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
357: hr_utility.set_location(l_proc, 40);
358: hr_h2pi_error.generate_error_report;
359: return;
360: END IF;
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:
362: hr_utility.set_location(l_proc, 50);
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;
367: return;
368: ELSE
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
370: WHERE to_business_group_id = hr_h2pi_upload.g_to_business_group_id;