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_VALIDATE dependencies on HR_H2PI_ERROR

Line 69: hr_h2pi_error.data_error(p_from_id => p_from_client_id,

65: INTO l_method_of_gen_emp_num
66: FROM per_business_groups
67: WHERE business_group_id = hr_h2pi_upload.g_to_business_group_id;
68: IF l_method_of_gen_emp_num <> 'M' THEN
69: hr_h2pi_error.data_error(p_from_id => p_from_client_id,
70: p_table_name => 'HR_H2PI_BG_AND_GRE',
71: p_message_level => 'FATAL',
72: p_message_name => 'HR_289292_EMP_NUM_GEN_MANUAL');
73: END IF;

Line 91: hr_h2pi_error.data_error(p_from_id => v_ud_rec.organization_id,

87: p_from_id => v_ud_rec.organization_id);
88:
89: IF l_organization_to_id = -1 THEN
90: hr_utility.set_location(l_proc, 30);
91: hr_h2pi_error.data_error(p_from_id => v_ud_rec.organization_id,
92: p_table_name => 'HR_H2PI_BG_AND_GRE',
93: p_message_level => 'FATAL',
94: p_message_name => 'HR_289260_UD_DATA_ADDED');
95: ELSE

Line 114: hr_h2pi_error.data_error(p_from_id => v_ud_rec.organization_id,

110: IF l_ed_rec.date_from <> v_ud_rec.date_from OR
111: l_ed_rec.date_to <> v_ud_rec.date_to OR
112: NVL(l_ed_rec.location_id, -1) <> NVL(l_location_id, -1) THEN
113: hr_utility.set_location(l_proc, 50);
114: hr_h2pi_error.data_error(p_from_id => v_ud_rec.organization_id,
115: p_table_name => 'HR_H2PI_BG_AND_GRE',
116: p_message_level => 'FATAL',
117: p_message_name => 'HR_289237_DATA_MISMATCH');
118: END IF;

Line 123: hr_h2pi_error.data_error(p_from_id => v_ud_rec.organization_id,

119:
120: EXCEPTION
121: WHEN NO_DATA_FOUND THEN
122: hr_utility.set_location(l_proc, 60);
123: hr_h2pi_error.data_error(p_from_id => v_ud_rec.organization_id,
124: p_table_name => 'HR_H2PI_BG_AND_GRE',
125: p_message_level=> 'FATAL',
126: p_message_name => 'HR_289235_ED_DATA_REMOVED');
127: WHEN MAPPING_ID_MISSING THEN

Line 155: hr_h2pi_error.data_error(p_from_id => l_organization_id,

151:
152: IF csr_payroll_data_added%FOUND then
153: hr_utility.set_location(l_proc, 110);
154:
155: hr_h2pi_error.data_error(p_from_id => l_organization_id,
156: p_table_name => 'HR_H2PI_BG_AND_GRE',
157: p_message_level => 'FATAL',
158: p_message_name => 'HR_289259_ED_DATA_ADDED');
159: CLOSE csr_payroll_data_added;

Line 170: hr_h2pi_error.data_error(p_from_id => l_organization_id,

166: FETCH csr_hr_data_removed into l_organization_id;
167: IF csr_hr_data_removed%FOUND then
168: hr_utility.set_location(l_proc, 120);
169: --HR Data removed
170: hr_h2pi_error.data_error(p_from_id => l_organization_id,
171: p_table_name => 'HR_H2PI_BG_AND_GRE',
172: p_message_level => 'FATAL',
173: p_message_name => 'HR_289236_UD_DATA_REMOVED');
174: END IF;

Line 252: hr_h2pi_error.data_error(p_from_id => v_ud_rec.pay_basis_id,

248: p_from_id => v_ud_rec.pay_basis_id);
249:
250: IF l_pay_basis_to_id = -1 THEN
251: hr_utility.set_location(l_proc, 30);
252: hr_h2pi_error.data_error(p_from_id => v_ud_rec.pay_basis_id,
253: p_table_name => 'HR_H2PI_PAY_BASES',
254: p_message_level => 'FATAL',
255: p_message_name => 'HR_289260_UD_DATA_ADDED');
256: ELSE

Line 270: hr_h2pi_error.data_error(p_from_id => v_ud_rec.pay_basis_id,

266:
267: IF l_ed_rec.name <> v_ud_rec.name OR
268: l_ed_rec.pay_basis <> v_ud_rec.pay_basis THEN
269: hr_utility.set_location(l_proc, 50);
270: hr_h2pi_error.data_error(p_from_id => v_ud_rec.pay_basis_id,
271: p_table_name => 'HR_H2PI_PAY_BASES',
272: p_message_level => 'FATAL',
273: p_message_name => 'HR_289237_DATA_MISMATCH');
274: END IF;

Line 279: hr_h2pi_error.data_error(p_from_id => v_ud_rec.pay_basis_id,

275:
276: EXCEPTION
277: WHEN NO_DATA_FOUND THEN
278: hr_utility.set_location(l_proc, 60);
279: hr_h2pi_error.data_error(p_from_id => v_ud_rec.pay_basis_id,
280: p_table_name => 'HR_H2PI_PAY_BASES',
281: p_message_level=> 'FATAL',
282: p_message_name => 'HR_289235_ED_DATA_REMOVED');
283: WHEN MAPPING_ID_MISSING THEN

Line 310: hr_h2pi_error.data_error(p_from_id => l_pay_basis_id,

306:
307: IF csr_payroll_data_added%FOUND then
308: -- Pay basis data added.
309: hr_utility.set_location(l_proc, 100);
310: hr_h2pi_error.data_error(p_from_id => l_pay_basis_id,
311: p_table_name => 'HR_H2PI_PAY_BASES',
312: p_message_level => 'FATAL',
313: p_message_name => 'HR_289259_ED_DATA_ADDED');
314: CLOSE csr_payroll_data_added;

Line 326: hr_h2pi_error.data_error(p_from_id => l_pay_basis_id,

322: FETCH csr_hr_data_removed into l_pay_basis_id;
323: IF csr_hr_data_removed%FOUND then
324: --HR Data removed
325: hr_utility.set_location(l_proc, 120);
326: hr_h2pi_error.data_error(p_from_id => l_pay_basis_id,
327: p_table_name => 'HR_H2PI_PAY_BASES',
328: p_message_level => 'FATAL',
329: p_message_name => 'HR_289236_UD_DATA_REMOVED');
330: END IF;

Line 407: hr_h2pi_error.data_error(p_from_id => v_ud_rec.payroll_id,

403: p_from_id => v_ud_rec.payroll_id);
404:
405: IF l_payroll_to_id = -1 THEN
406: hr_utility.set_location(l_proc, 30);
407: hr_h2pi_error.data_error(p_from_id => v_ud_rec.payroll_id,
408: p_table_name => 'HR_H2PI_PAYROLLS',
409: p_message_level => 'FATAL',
410: p_message_name => 'HR_289260_UD_DATA_ADDED');
411: ELSE

Line 431: hr_h2pi_error.data_error(p_from_id => v_ud_rec.payroll_id,

427: l_ed_rec.period_type <> v_ud_rec.period_type OR
428: l_ed_rec.effective_start_date <> v_ud_rec.effective_start_date OR
429: l_ed_rec.effective_end_date <> v_ud_rec.effective_end_date THEN
430: hr_utility.set_location(l_proc, 50);
431: hr_h2pi_error.data_error(p_from_id => v_ud_rec.payroll_id,
432: p_table_name => 'HR_H2PI_PAYROLLS',
433: p_message_level => 'FATAL',
434: p_message_name => 'HR_289237_DATA_MISMATCH');
435: END IF;

Line 440: hr_h2pi_error.data_error(p_from_id => v_ud_rec.payroll_id,

436:
437: EXCEPTION
438: WHEN NO_DATA_FOUND THEN
439: hr_utility.set_location(l_proc, 60);
440: hr_h2pi_error.data_error(p_from_id => v_ud_rec.payroll_id,
441: p_table_name => 'HR_H2PI_PAYROLLS',
442: p_message_level=> 'FATAL',
443: p_message_name => 'HR_289235_ED_DATA_REMOVED');
444: WHEN MAPPING_ID_MISSING THEN

Line 471: hr_h2pi_error.data_error(p_from_id => l_payroll_id,

467:
468: IF csr_payroll_data_added%FOUND then
469: -- Payroll Data added.
470: hr_utility.set_location(l_proc, 100);
471: hr_h2pi_error.data_error(p_from_id => l_payroll_id,
472: p_table_name => 'HR_H2PI_PAYROLLS',
473: p_message_level => 'FATAL',
474: p_message_name => 'HR_289259_ED_DATA_ADDED');
475: CLOSE csr_payroll_data_added;

Line 487: hr_h2pi_error.data_error(p_from_id => l_payroll_id,

483: FETCH csr_hr_data_removed into l_payroll_id;
484: IF csr_hr_data_removed%FOUND then
485: --HR Data removed
486: hr_utility.set_location(l_proc, 120);
487: hr_h2pi_error.data_error(p_from_id => l_payroll_id,
488: p_table_name => 'HR_H2PI_PAYROLLS',
489: p_message_level => 'FATAL',
490: p_message_name => 'HR_289236_UD_DATA_REMOVED');
491: END IF;

Line 569: hr_h2pi_error.data_error(p_from_id => v_ud_rec.element_type_id,

565: p_from_id => v_ud_rec.element_type_id);
566:
567: IF l_element_type_to_id = -1 THEN
568: hr_utility.set_location(l_proc, 30);
569: hr_h2pi_error.data_error(p_from_id => v_ud_rec.element_type_id,
570: p_table_name => 'HR_H2PI_ELEMENT_TYPES',
571: p_message_level => 'FATAL',
572: p_message_name => 'HR_289260_UD_DATA_ADDED');
573: ELSE

Line 591: hr_h2pi_error.data_error(p_from_id => v_ud_rec.element_type_id,

587: l_ed_rec.processing_type <> v_ud_rec.processing_type OR
588: l_ed_rec.effective_start_date <> v_ud_rec.effective_start_date OR
589: l_ed_rec.effective_end_date <> v_ud_rec.effective_end_date THEN
590: hr_utility.set_location(l_proc, 50);
591: hr_h2pi_error.data_error(p_from_id => v_ud_rec.element_type_id,
592: p_table_name => 'HR_H2PI_ELEMENT_TYPES',
593: p_message_level => 'FATAL',
594: p_message_name => 'HR_289237_DATA_MISMATCH');
595: END IF;

Line 600: hr_h2pi_error.data_error(p_from_id => v_ud_rec.element_type_id,

596:
597: EXCEPTION
598: WHEN NO_DATA_FOUND THEN
599: hr_utility.set_location(l_proc, 60);
600: hr_h2pi_error.data_error(p_from_id => v_ud_rec.element_type_id,
601: p_table_name => 'HR_H2PI_ELEMENT_TYPES',
602: p_message_level=> 'FATAL',
603: p_message_name => 'HR_289235_ED_DATA_REMOVED');
604: WHEN MAPPING_ID_MISSING THEN

Line 631: hr_h2pi_error.data_error(p_from_id => l_element_type_id,

627:
628: IF csr_payroll_data_added%FOUND then
629:
630: hr_utility.set_location(l_proc, 100);
631: hr_h2pi_error.data_error(p_from_id => l_element_type_id,
632: p_table_name => 'HR_H2PI_ELEMENT_TYPES',
633: p_message_level => 'FATAL',
634: p_message_name => 'HR_289259_ED_DATA_ADDED');
635: CLOSE csr_payroll_data_added;

Line 647: hr_h2pi_error.data_error(p_from_id => l_element_type_id,

643: FETCH csr_hr_data_removed into l_element_type_id;
644: IF csr_hr_data_removed%FOUND then
645: hr_utility.set_location(l_proc, 130);
646: --HR Data removed
647: hr_h2pi_error.data_error(p_from_id => l_element_type_id,
648: p_table_name => 'HR_H2PI_ELEMENT_TYPES',
649: p_message_level => 'FATAL',
650: p_message_name => 'HR_289236_UD_DATA_REMOVED');
651: END IF;

Line 729: hr_h2pi_error.data_error(p_from_id => v_ud_rec.org_payment_method_id,

725: p_from_id => v_ud_rec.org_payment_method_id);
726:
727: IF l_org_payment_method_to_id = -1 THEN
728: hr_utility.set_location(l_proc, 30);
729: hr_h2pi_error.data_error(p_from_id => v_ud_rec.org_payment_method_id,
730: p_table_name => 'HR_H2PI_ORG_PAYMENT_METHODS',
731: p_message_level => 'FATAL',
732: p_message_name => 'HR_289260_UD_DATA_ADDED');
733: ELSE

Line 754: hr_h2pi_error.data_error(p_from_id => v_ud_rec.org_payment_method_id,

750: l_ed_rec.currency_code <> v_ud_rec.currency_code OR
751: l_ed_rec.payment_type_name <> v_ud_rec.payment_type_name OR
752: l_ed_rec.territory_code <> v_ud_rec.territory_code THEN
753: hr_utility.set_location(l_proc, 50);
754: hr_h2pi_error.data_error(p_from_id => v_ud_rec.org_payment_method_id,
755: p_table_name => 'HR_H2PI_ORG_PAYMENT_METHODS',
756: p_message_level => 'FATAL',
757: p_message_name => 'HR_289237_DATA_MISMATCH');
758: END IF;

Line 763: hr_h2pi_error.data_error(p_from_id => v_ud_rec.org_payment_method_id,

759:
760: EXCEPTION
761: WHEN NO_DATA_FOUND THEN
762: hr_utility.set_location(l_proc, 60);
763: hr_h2pi_error.data_error(p_from_id => v_ud_rec.org_payment_method_id,
764: p_table_name => 'HR_H2PI_ORG_PAYMENT_METHODS',
765: p_message_level =>'FATAL',
766: p_message_name =>'HR_289235_ED_DATA_REMOVED');
767: WHEN MAPPING_ID_MISSING THEN

Line 794: hr_h2pi_error.data_error(p_from_id => l_org_payment_method_id,

790:
791: IF csr_payroll_data_added%FOUND then
792: hr_utility.set_location(l_proc, 100);
793:
794: hr_h2pi_error.data_error(p_from_id => l_org_payment_method_id,
795: p_table_name => 'HR_H2PI_ORG_PAYMENT_METHODS',
796: p_message_level => 'FATAL',
797: p_message_name => 'HR_289259_ED_DATA_ADDED');
798: CLOSE csr_payroll_data_added;

Line 810: hr_h2pi_error.data_error(p_from_id => l_org_payment_method_id,

806: FETCH csr_hr_data_removed into l_org_payment_method_id;
807: hr_utility.set_location(l_proc, 120);
808: IF csr_hr_data_removed%FOUND then
809: --HR Data removed
810: hr_h2pi_error.data_error(p_from_id => l_org_payment_method_id,
811: p_table_name => 'HR_H2PI_ORG_PAYMENT_METHODS',
812: p_message_level => 'FATAL',
813: p_message_name => 'HR_289236_UD_DATA_REMOVED');
814: END IF;

Line 900: hr_h2pi_error.data_error(p_from_id => v_ud_rec.element_link_id,

896: p_from_id => v_ud_rec.element_link_id);
897:
898: IF l_element_link_to_id = -1 THEN
899: hr_utility.set_location(l_proc, 30);
900: hr_h2pi_error.data_error(p_from_id => v_ud_rec.element_link_id,
901: p_table_name => 'HR_H2PI_ELEMENT_LINKS',
902: p_message_level => 'FATAL',
903: p_message_name => 'HR_289260_UD_DATA_ADDED');
904: ELSE

Line 940: hr_h2pi_error.data_error(p_from_id => v_ud_rec.element_link_id,

936: NVL(l_ed_rec.pay_basis_id, -1) <> NVL(l_pay_basis_id, -1) OR
937: l_ed_rec.link_to_all_payrolls_flag
938: <> v_ud_rec.link_to_all_payrolls_flag THEN
939: hr_utility.set_location(l_proc, 50);
940: hr_h2pi_error.data_error(p_from_id => v_ud_rec.element_link_id,
941: p_table_name => 'HR_H2PI_ELEMENT_LINKS',
942: p_message_level => 'FATAL',
943: p_message_name => 'HR_289237_DATA_MISMATCH');
944: END IF;

Line 949: hr_h2pi_error.data_error(p_from_id => v_ud_rec.element_link_id,

945:
946: EXCEPTION
947: WHEN NO_DATA_FOUND THEN
948: hr_utility.set_location(l_proc, 60);
949: hr_h2pi_error.data_error(p_from_id => v_ud_rec.element_link_id,
950: p_table_name => 'HR_H2PI_ELEMENT_LINKS',
951: p_message_level=> 'FATAL',
952: p_message_name => 'HR_289235_ED_DATA_REMOVED');
953: WHEN MAPPING_ID_MISSING THEN

Line 980: hr_h2pi_error.data_error(p_from_id => l_element_link_id,

976:
977: IF csr_payroll_data_added%FOUND then
978: hr_utility.set_location(l_proc, 100);
979:
980: hr_h2pi_error.data_error(p_from_id => l_element_link_id,
981: p_table_name => 'HR_H2PI_ELEMENT_LINKS',
982: p_message_level => 'FATAL',
983: p_message_name => 'HR_289259_ED_DATA_ADDED');
984: CLOSE csr_payroll_data_added;

Line 996: hr_h2pi_error.data_error(p_from_id => l_element_link_id,

992: FETCH csr_hr_data_removed into l_element_link_id;
993: IF csr_hr_data_removed%FOUND then
994: --HR Data removed
995: hr_utility.set_location(l_proc, 120);
996: hr_h2pi_error.data_error(p_from_id => l_element_link_id,
997: p_table_name => 'HR_H2PI_ELEMENT_LINKS',
998: p_message_level => 'FATAL',
999: p_message_name => 'HR_289236_UD_DATA_REMOVED');
1000: END IF;

Line 1175: hr_h2pi_error.data_error(p_from_id => l_state_code ||

1171: l_county_code,
1172: l_city_code) LOOP
1173: IF l_city_code LIKE 'U%' THEN
1174: hr_utility.set_location(l_proc, 90);
1175: hr_h2pi_error.data_error(p_from_id => l_state_code ||
1176: l_county_code ||
1177: REPLACE(l_city_code,'U',0),
1178: p_table_name => 'HR_H2PI_US_MODIFIED_GEOCODES',
1179: p_message_level => 'FATAL',

Line 1184: hr_h2pi_error.data_error(p_from_id => l_state_code ||

1180: p_message_name => 'HR_289269_USER_CITY_CODE');
1181: -- Message name to be changed.
1182: ELSIF csr_ud_city_tax_comp%FOUND THEN
1183: hr_utility.set_location(l_proc, 100);
1184: hr_h2pi_error.data_error(p_from_id => l_state_code ||
1185: l_county_code ||
1186: REPLACE(l_city_code,'U',0),
1187: p_table_name => 'HR_H2PI_US_MODIFIED_GEOCODES',
1188: p_message_level => 'FATAL',

Line 1209: hr_h2pi_error.data_error(p_from_id => l_state_code ||

1205: l_county_code,
1206: l_city_code) LOOP
1207: IF l_city_code LIKE 'U%' THEN
1208:
1209: hr_h2pi_error.data_error(p_from_id => l_state_code ||
1210: l_county_code ||
1211: REPLACE(l_city_code,'U',0),
1212: p_table_name => 'HR_H2PI_US_MODIFIED_GEOCODES',
1213: p_message_level => 'FATAL',

Line 1216: hr_h2pi_error.data_error(p_from_id => l_state_code ||

1212: p_table_name => 'HR_H2PI_US_MODIFIED_GEOCODES',
1213: p_message_level => 'FATAL',
1214: p_message_name => 'HR_289269_USER_CITY_CODE');
1215: ELSIF csr_ed_city_tax_comp%FOUND THEN
1216: hr_h2pi_error.data_error(p_from_id => l_state_code ||
1217: l_county_code ||
1218: REPLACE(l_city_code,'U',0),
1219: p_table_name => 'HR_H2PI_US_MODIFIED_GEOCODES',
1220: p_message_level => 'FATAL',

Line 1236: hr_h2pi_error.data_error(p_from_id => '99999',

1232: hr_utility.set_location('Leaving:'|| l_proc, 130);
1233: EXCEPTION
1234: WHEN e_ed_more_then_two_ver_ahead THEN
1235: hr_utility.set_location(l_proc, 140);
1236: hr_h2pi_error.data_error(p_from_id => '99999',
1237: p_table_name => 'HR_H2PI_US_MODIFIED_GEOCODES',
1238: p_message_level => 'FATAL',
1239: p_message_name => 'HR_289235_ED_DATA_REMOVED');
1240: --RAISE;

Line 1243: hr_h2pi_error.data_error(p_from_id => '99999',

1239: p_message_name => 'HR_289235_ED_DATA_REMOVED');
1240: --RAISE;
1241: WHEN e_ud_more_then_two_ver_ahead THEN
1242: hr_utility.set_location(l_proc, 150);
1243: hr_h2pi_error.data_error(p_from_id => '99999',
1244: p_table_name => 'HR_H2PI_US_MODIFIED_GEOCODES',
1245: p_message_level => 'FATAL',
1246: p_message_name => 'HR_289235_ED_DATA_REMOVED');
1247: --RAISE;