DBA Data[Home] [Help]

APPS.HR_H2PI_PERSON_UPLOAD dependencies on HR_H2PI_ERROR

Line 663: IF NOT hr_h2pi_error.check_for_errors THEN

659: END;
660:
661: END LOOP;
662:
663: IF NOT hr_h2pi_error.check_for_errors THEN
664: hr_utility.set_location(l_proc, 70);
665: remove_staging_table_data(l_from_client_id);
666: END IF;
667:

Line 909: hr_h2pi_error.data_error

905: IF csr_ed_person%NOTFOUND THEN
906: hr_utility.set_location(l_proc, 60);
907: CLOSE csr_ed_person;
908: ROLLBACK;
909: hr_h2pi_error.data_error
910: (p_from_id => l_person_id,
911: p_table_name => 'HR_H2PI_EMPLOYEES',
912: p_message_level => 'FATAL',
913: p_message_name => 'HR_289240_MAPPING_ID_INVALID');

Line 1163: hr_h2pi_error.data_error

1159: ROLLBACK;
1160: hr_utility.set_location(l_proc, 200);
1161: l_encoded_message := fnd_message.get_encoded;
1162: hr_utility.set_location(l_encoded_message, 200);
1163: hr_h2pi_error.data_error
1164: (p_from_id => v_ud_per.person_id,
1165: p_table_name => 'HR_H2PI_EMPLOYEES',
1166: p_message_level => 'FATAL',
1167: p_message_text => l_encoded_message);

Line 1357: hr_h2pi_error.data_error

1353: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
1354: ROLLBACK;
1355: hr_utility.set_location(l_proc, 60);
1356: l_encoded_message := fnd_message.get_encoded;
1357: hr_h2pi_error.data_error
1358: (p_from_id => l_ud_address_id,
1359: p_table_name => 'HR_H2PI_ADDRESSES',
1360: p_message_level => 'FATAL',
1361: p_message_text => l_encoded_message);

Line 1490: hr_h2pi_error.data_error

1486: hr_utility.set_location(l_proc, 60);
1487: CLOSE csr_ed_address;
1488: ROLLBACK;
1489: hr_utility.set_location(l_proc, 70);
1490: hr_h2pi_error.data_error
1491: (p_from_id => l_address_id,
1492: p_table_name => 'HR_H2PI_ADDRESSES',
1493: p_message_level => 'FATAL',
1494: p_message_name => 'HR_289240_MAPPING_ID_INVALID');

Line 1564: hr_h2pi_error.data_error

1560: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
1561: ROLLBACK;
1562: hr_utility.set_location(l_proc, 110);
1563: l_encoded_message := fnd_message.get_encoded;
1564: hr_h2pi_error.data_error
1565: (p_from_id => v_ud_adr.address_id,
1566: p_table_name => 'HR_H2PI_ADDRESSES',
1567: p_message_level => 'FATAL',
1568: p_message_text => l_encoded_message);

Line 1964: hr_h2pi_error.data_error

1960: hr_utility.set_location(l_proc, 110);
1961: CLOSE csr_ed_assignment;
1962: ROLLBACK;
1963: hr_utility.set_location(l_proc, 220);
1964: hr_h2pi_error.data_error
1965: (p_from_id => l_assignment_id,
1966: p_table_name => 'HR_H2PI_ASSIGNMENTS',
1967: p_message_level => 'FATAL',
1968: p_message_name => 'HR_289240_MAPPING_ID_INVALID');

Line 2388: hr_h2pi_error.data_error

2384: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
2385: ROLLBACK;
2386: hr_utility.set_location(l_proc, 260);
2387: l_encoded_message := fnd_message.get_encoded;
2388: hr_h2pi_error.data_error
2389: (p_from_id => v_ud_asg.assignment_id,
2390: p_table_name => 'HR_H2PI_ASSIGNMENTS',
2391: p_message_level => 'FATAL',
2392: p_message_text => l_encoded_message);

Line 2464: hr_h2pi_error.data_error

2460: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
2461: ROLLBACK;
2462: hr_utility.set_location(l_proc, 70);
2463: l_encoded_message := fnd_message.get_encoded;
2464: hr_h2pi_error.data_error
2465: (p_from_id => v_ud_pos.period_of_service_id,
2466: p_table_name => 'HR_H2PI_PERIODS_OF_SERVICE',
2467: p_message_level => 'FATAL',
2468: p_message_text => l_encoded_message);

Line 2594: hr_h2pi_error.data_error

2590: hr_utility.set_location(l_proc, 60);
2591: CLOSE csr_ed_salary;
2592: ROLLBACK;
2593: hr_utility.set_location(l_proc, 70);
2594: hr_h2pi_error.data_error
2595: (p_from_id => l_pay_proposal_id,
2596: p_table_name => 'HR_H2PI_SALARIES',
2597: p_message_level => 'FATAL',
2598: p_message_name => 'HR_289240_MAPPING_ID_INVALID');

Line 2655: hr_h2pi_error.data_error

2651: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
2652: ROLLBACK;
2653: hr_utility.set_location(l_proc, 110);
2654: l_encoded_message := fnd_message.get_encoded;
2655: hr_h2pi_error.data_error
2656: (p_from_id => v_ud_ppp.pay_proposal_id,
2657: p_table_name => 'HR_H2PI_SALARIES',
2658: p_message_level => 'FATAL',
2659: p_message_text => l_encoded_message);

Line 2796: hr_h2pi_error.data_error

2792: ELSIF v_ud_ppm.payee_type = 'P' THEN
2793: hr_utility.set_location(l_proc, 72);
2794: l_payee_type := null;
2795: l_payee_id := null;
2796: hr_h2pi_error.data_error
2797: (p_from_id => v_ud_ppm.payee_id,
2798: p_table_name => 'HR_H2PI_EMPLOYEES',
2799: p_message_level => 'FATAL',
2800: p_message_name => 'HR_289240_MAPPING_ID_INVALID');

Line 2898: hr_h2pi_error.data_error

2894: hr_utility.set_location(l_proc, 110);
2895: CLOSE csr_ed_payment_method;
2896: ROLLBACK;
2897: hr_utility.set_location(l_proc, 120);
2898: hr_h2pi_error.data_error
2899: (p_from_id => l_personal_pay_method_id,
2900: p_table_name => 'HR_H2PI_PAYMENT_METHODS',
2901: p_message_level => 'FATAL',
2902: p_message_name => 'HR_289240_MAPPING_ID_INVALID');

Line 3055: hr_h2pi_error.data_error

3051: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
3052: ROLLBACK;
3053: hr_utility.set_location(l_proc, 230);
3054: l_encoded_message := fnd_message.get_encoded;
3055: hr_h2pi_error.data_error
3056: (p_from_id => v_ud_ppm.personal_payment_method_id,
3057: p_table_name => 'HR_H2PI_PAYMENT_METHODS',
3058: p_message_level => 'FATAL',
3059: p_message_text => l_encoded_message);

Line 3232: hr_h2pi_error.data_error

3228: hr_utility.set_location(l_proc, 80);
3229: CLOSE csr_ed_cost_allocation;
3230: ROLLBACK;
3231: hr_utility.set_location(l_proc, 90);
3232: hr_h2pi_error.data_error
3233: (p_from_id => l_cost_allocation_id,
3234: p_table_name => 'HR_H2PI_COST_ALLOCATIONS',
3235: p_message_level => 'FATAL',
3236: p_message_name => 'HR_289240_MAPPING_ID_INVALID');

Line 3366: hr_h2pi_error.data_error

3362: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
3363: ROLLBACK;
3364: hr_utility.set_location(l_proc, 190);
3365: l_encoded_message := fnd_message.get_encoded;
3366: hr_h2pi_error.data_error
3367: (p_from_id => v_ud_hca.cost_allocation_id,
3368: p_table_name => 'HR_H2PI_COST_ALLOCATIONS',
3369: p_message_level => 'FATAL',
3370: p_message_text => l_encoded_message);

Line 3516: hr_h2pi_error.data_error

3512: EXCEPTION
3513: WHEN NO_DATA_FOUND THEN
3514: ROLLBACK;
3515: hr_utility.set_location(l_proc, 35);
3516: hr_h2pi_error.data_error
3517: (p_from_id => a_input_value_id(l_index),
3518: p_table_name => 'HR_H2PI_ELEMENT_ENTRY_VALUES',
3519: p_message_level => 'FATAL',
3520: p_message_name => 'HR_289240_MAPPING_ID_INVALID');

Line 3705: hr_h2pi_error.data_error

3701: hr_utility.set_location(l_proc, 80);
3702: CLOSE csr_ed_element_entry;
3703: ROLLBACK;
3704: hr_utility.set_location(l_proc, 90);
3705: hr_h2pi_error.data_error
3706: (p_from_id => l_element_entry_id,
3707: p_table_name => 'HR_H2PI_ELEMENT_ENTRIES',
3708: p_message_level => 'FATAL',
3709: p_message_name => 'HR_289240_MAPPING_ID_INVALID');

Line 3912: hr_h2pi_error.data_error

3908: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
3909: ROLLBACK;
3910: hr_utility.set_location(l_proc, 190);
3911: l_encoded_message := fnd_message.get_encoded;
3912: hr_h2pi_error.data_error
3913: (p_from_id => v_ud_ele.element_entry_id,
3914: p_table_name => 'HR_H2PI_ELEMENT_ENTRIES',
3915: p_message_level => 'FATAL',
3916: p_message_text => l_encoded_message);

Line 4002: hr_h2pi_error.data_error

3998: hr_utility.set_location(l_proc, 80);
3999: CLOSE csr_ed_federal_tax_rule;
4000: ROLLBACK;
4001: hr_utility.set_location(l_proc, 90);
4002: hr_h2pi_error.data_error
4003: (p_from_id => l_emp_fed_tax_rule_id,
4004: p_table_name => 'HR_H2PI_FEDERAL_TAX_RULES',
4005: p_message_level => 'FATAL',
4006: p_message_name => 'HR_289240_MAPPING_ID_INVALID');

Line 4145: hr_h2pi_error.data_error

4141: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
4142: ROLLBACK;
4143: hr_utility.set_location(l_proc, 190);
4144: l_encoded_message := fnd_message.get_encoded;
4145: hr_h2pi_error.data_error
4146: (p_from_id => v_ud_fed.emp_fed_tax_rule_id,
4147: p_table_name => 'HR_H2PI_FEDERAL_TAX_RULES',
4148: p_message_level => 'FATAL',
4149: p_message_text => l_encoded_message);

Line 4278: hr_h2pi_error.data_error

4274: hr_utility.set_location(l_proc, 60);
4275: CLOSE csr_ed_state_tax_rule;
4276: ROLLBACK;
4277: hr_utility.set_location(l_proc, 70);
4278: hr_h2pi_error.data_error
4279: (p_from_id => l_emp_state_tax_rule_id,
4280: p_table_name => 'HR_H2PI_STATE_TAX_RULES',
4281: p_message_level => 'FATAL',
4282: p_message_name => 'HR_289240_MAPPING_ID_INVALID');

Line 4426: hr_h2pi_error.data_error

4422: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
4423: ROLLBACK;
4424: hr_utility.set_location(l_proc, 170);
4425: l_encoded_message := fnd_message.get_encoded;
4426: hr_h2pi_error.data_error
4427: (p_from_id => v_ud_sta.emp_state_tax_rule_id,
4428: p_table_name => 'HR_H2PI_STATE_TAX_RULES',
4429: p_message_level => 'FATAL',
4430: p_message_text => l_encoded_message);

Line 4551: hr_h2pi_error.data_error

4547: hr_utility.set_location(l_proc, 60);
4548: CLOSE csr_ed_county_tax_rule;
4549: ROLLBACK;
4550: hr_utility.set_location(l_proc, 70);
4551: hr_h2pi_error.data_error
4552: (p_from_id => l_emp_county_tax_rule_id,
4553: p_table_name => 'HR_H2PI_COUNTY_TAX_RULES',
4554: p_message_level => 'FATAL',
4555: p_message_name => 'HR_289240_MAPPING_ID_INVALID');

Line 4682: hr_h2pi_error.data_error

4678: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
4679: ROLLBACK;
4680: hr_utility.set_location(l_proc, 170);
4681: l_encoded_message := fnd_message.get_encoded;
4682: hr_h2pi_error.data_error
4683: (p_from_id => v_ud_cnt.emp_county_tax_rule_id,
4684: p_table_name => 'HR_H2PI_COUNTY_TAX_RULES',
4685: p_message_level => 'FATAL',
4686: p_message_text => l_encoded_message);

Line 4807: hr_h2pi_error.data_error

4803: hr_utility.set_location(l_proc, 60);
4804: CLOSE csr_ed_city_tax_rule;
4805: ROLLBACK;
4806: hr_utility.set_location(l_proc, 70);
4807: hr_h2pi_error.data_error
4808: (p_from_id => l_emp_city_tax_rule_id,
4809: p_table_name => 'HR_H2PI_CITY_TAX_RULES',
4810: p_message_level => 'FATAL',
4811: p_message_name => 'HR_289240_MAPPING_ID_INVALID');

Line 4936: hr_h2pi_error.data_error

4932: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
4933: ROLLBACK;
4934: hr_utility.set_location(l_proc, 170);
4935: l_encoded_message := fnd_message.get_encoded;
4936: hr_h2pi_error.data_error
4937: (p_from_id => v_ud_cty.emp_city_tax_rule_id,
4938: p_table_name => 'HR_H2PI_CITY_TAX_RULES',
4939: p_message_level => 'FATAL',
4940: p_message_text => l_encoded_message);

Line 5293: hr_h2pi_error.data_error

5289: WHEN APP_EXCEPTIONS.APPLICATION_EXCEPTION THEN
5290: ROLLBACK;
5291: hr_utility.set_location(l_proc, 140);
5292: l_encoded_message := fnd_message.get_encoded;
5293: hr_h2pi_error.data_error
5294: (p_from_id => l_ud_assignment_id,
5295: p_table_name => 'HR_H2PI_ASSIGNMENTS',
5296: p_message_level => 'FATAL',
5297: p_message_text => l_encoded_message);