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_UTILITY

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

58: l_proc VARCHAR2(72) := g_package||'validate_bg_and_gre';
59:
60: l_method_of_gen_emp_num per_business_groups.method_of_generation_emp_num%TYPE;
61: BEGIN
62: hr_utility.set_location('Entering:'|| l_proc, 10);
63: BEGIN
64: SELECT method_of_generation_emp_num
65: INTO l_method_of_gen_emp_num
66: FROM per_business_groups

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

80:
81: <>
82: FOR v_ud_rec IN csr_bg_and_gre LOOP
83: SAVEPOINT org_start;
84: hr_utility.set_location(l_proc, 20);
85: l_organization_to_id := hr_h2pi_map.get_to_id
86: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',
87: p_from_id => v_ud_rec.organization_id);
88:

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

86: (p_table_name => 'HR_ALL_ORGANIZATION_UNITS',
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');

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

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
96: hr_utility.set_location(l_proc, 40);
97: BEGIN
98: SELECT DISTINCT *
99: INTO l_ed_rec
100: FROM hr_h2pi_bg_and_gre_v

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

109: p_report_error => TRUE);
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');

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

118: END IF;
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');

Line 128: hr_utility.set_location(l_proc, 70);

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
128: hr_utility.set_location(l_proc, 70);
129: END;
130: END IF;
131: END LOOP main_loop;
132:

Line 135: hr_utility.set_location(l_proc, 80);

131: END LOOP main_loop;
132:
133: BEGIN
134: <>
135: hr_utility.set_location(l_proc, 80);
136: FOR csr_pay_bg_and_gre_rec in csr_pay_bg_and_gre LOOP
137: hr_utility.set_location(l_proc, 90);
138: l_record_ok := FALSE;
139:

Line 137: hr_utility.set_location(l_proc, 90);

133: BEGIN
134: <>
135: hr_utility.set_location(l_proc, 80);
136: FOR csr_pay_bg_and_gre_rec in csr_pay_bg_and_gre LOOP
137: hr_utility.set_location(l_proc, 90);
138: l_record_ok := FALSE;
139:
140: <>
141: FOR j IN 1..l_counter LOOP

Line 148: hr_utility.set_location(l_proc, 100);

144: END IF;
145: END LOOP inner_loop;
146:
147: IF NOT l_record_ok THEN
148: hr_utility.set_location(l_proc, 100);
149: OPEN csr_payroll_data_added(csr_pay_bg_and_gre_rec.organization_id);
150: FETCH csr_payroll_data_added INTO l_organization_id;
151:
152: IF csr_payroll_data_added%FOUND then

Line 153: hr_utility.set_location(l_proc, 110);

149: OPEN csr_payroll_data_added(csr_pay_bg_and_gre_rec.organization_id);
150: FETCH csr_payroll_data_added INTO 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',

Line 168: hr_utility.set_location(l_proc, 120);

164:
165: OPEN csr_hr_data_removed(csr_pay_bg_and_gre_rec.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',

Line 179: hr_utility.set_location(l_proc, 130);

175: CLOSE csr_hr_data_removed;
176: END IF;
177: END IF;
178: END LOOP outer_loop;
179: hr_utility.set_location(l_proc, 130);
180: END ;
181: COMMIT;
182: hr_utility.set_location('Leaving:' || l_proc, 140);
183: END validate_bg_and_gre;

Line 182: hr_utility.set_location('Leaving:' || l_proc, 140);

178: END LOOP outer_loop;
179: hr_utility.set_location(l_proc, 130);
180: END ;
181: COMMIT;
182: hr_utility.set_location('Leaving:' || l_proc, 140);
183: END validate_bg_and_gre;
184:
185: --
186: -- For Pay Basis validation

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

235:
236: l_proc VARCHAR2(72) := g_package||'validate_pay_basis';
237:
238: BEGIN
239: hr_utility.set_location('Entering:'|| l_proc, 10);
240: l_counter := 0;
241:
242: <>
243: FOR v_ud_rec IN csr_pay_bases LOOP

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

241:
242: <>
243: FOR v_ud_rec IN csr_pay_bases LOOP
244: SAVEPOINT pay_basis_start;
245: hr_utility.set_location(l_proc, 20);
246: l_pay_basis_to_id := hr_h2pi_map.get_to_id
247: (p_table_name => 'PER_PAY_BASES',
248: p_from_id => v_ud_rec.pay_basis_id);
249:

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

247: (p_table_name => 'PER_PAY_BASES',
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');

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

253: p_table_name => 'HR_H2PI_PAY_BASES',
254: p_message_level => 'FATAL',
255: p_message_name => 'HR_289260_UD_DATA_ADDED');
256: ELSE
257: hr_utility.set_location(l_proc, 40);
258: BEGIN
259: SELECT *
260: INTO l_ed_rec
261: FROM hr_h2pi_pay_bases_v

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

265: pay_bases_tab(l_counter) := l_pay_basis_to_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');

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

274: END IF;
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');

Line 284: hr_utility.set_location(l_proc, 70);

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
284: hr_utility.set_location(l_proc, 70);
285: END;
286: END IF;
287: END LOOP main_loop;
288:

Line 292: hr_utility.set_location(l_proc, 80);

288:
289: BEGIN
290: <>
291: FOR csr_pay_pay_bases_rec in csr_pay_pay_bases LOOP
292: hr_utility.set_location(l_proc, 80);
293: l_record_ok := FALSE;
294:
295: <>
296: FOR j IN 1..l_counter LOOP

Line 303: hr_utility.set_location(l_proc, 90);

299: END IF;
300: END LOOP inner_loop;
301:
302: IF NOT l_record_ok THEN
303: hr_utility.set_location(l_proc, 90);
304: OPEN csr_payroll_data_added(csr_pay_pay_bases_rec.pay_basis_id);
305: FETCH csr_payroll_data_added INTO l_pay_basis_id;
306:
307: IF csr_payroll_data_added%FOUND then

Line 309: hr_utility.set_location(l_proc, 100);

305: FETCH csr_payroll_data_added INTO 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');

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

314: CLOSE csr_payroll_data_added;
315:
316: ELSE
317:
318: hr_utility.set_location(l_proc, 110);
319: CLOSE csr_payroll_data_added;
320:
321: OPEN csr_hr_data_removed(csr_pay_pay_bases_rec.pay_basis_id);
322: FETCH csr_hr_data_removed into l_pay_basis_id;

Line 325: hr_utility.set_location(l_proc, 120);

321: OPEN csr_hr_data_removed(csr_pay_pay_bases_rec.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');

Line 337: hr_utility.set_location('Leaving:' || l_proc, 130);

333: END IF;
334: END LOOP outer_loop;
335: END ;
336: COMMIT;
337: hr_utility.set_location('Leaving:' || l_proc, 130);
338: END validate_pay_basis;
339:
340: --
341: -- For Payroll validation

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

390:
391: l_proc VARCHAR2(72) := g_package||'validate_payroll';
392:
393: BEGIN
394: hr_utility.set_location('Entering:' || l_proc, 10);
395: l_counter := 0;
396:
397: <>
398: FOR v_ud_rec IN csr_payrolls LOOP

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

396:
397: <>
398: FOR v_ud_rec IN csr_payrolls LOOP
399: SAVEPOINT payroll_start;
400: hr_utility.set_location(l_proc, 20);
401: l_payroll_to_id := hr_h2pi_map.get_to_id
402: (p_table_name => 'PAY_ALL_PAYROLLS_F',
403: p_from_id => v_ud_rec.payroll_id);
404:

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

402: (p_table_name => 'PAY_ALL_PAYROLLS_F',
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');

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

409: p_message_level => 'FATAL',
410: p_message_name => 'HR_289260_UD_DATA_ADDED');
411: ELSE
412: BEGIN
413: hr_utility.set_location(l_proc, 40);
414: SELECT *
415: INTO l_ed_rec
416: FROM hr_h2pi_payrolls_v
417: WHERE payroll_id = l_payroll_to_id

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

426: l_ed_rec.number_of_years <> v_ud_rec.number_of_years OR
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');

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

435: END IF;
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');

Line 445: hr_utility.set_location(l_proc, 70);

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
445: hr_utility.set_location(l_proc, 70);
446: END;
447: END IF;
448: END LOOP main_loop;
449:

Line 453: hr_utility.set_location(l_proc, 80);

449:
450: BEGIN
451: <>
452: FOR csr_pay_payrolls_rec in csr_pay_payrolls LOOP
453: hr_utility.set_location(l_proc, 80);
454: l_record_ok := FALSE;
455:
456: <>
457: FOR j IN 1..l_counter LOOP

Line 464: hr_utility.set_location(l_proc, 90);

460: END IF;
461: END LOOP inner_loop;
462:
463: IF NOT l_record_ok THEN
464: hr_utility.set_location(l_proc, 90);
465: OPEN csr_payroll_data_added(csr_pay_payrolls_rec.payroll_id);
466: FETCH csr_payroll_data_added INTO l_payroll_id;
467:
468: IF csr_payroll_data_added%FOUND then

Line 470: hr_utility.set_location(l_proc, 100);

466: FETCH csr_payroll_data_added INTO 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');

Line 479: hr_utility.set_location(l_proc, 110);

475: CLOSE csr_payroll_data_added;
476:
477: ELSE
478:
479: hr_utility.set_location(l_proc, 110);
480: CLOSE csr_payroll_data_added;
481:
482: OPEN csr_hr_data_removed(csr_pay_payrolls_rec.payroll_id);
483: FETCH csr_hr_data_removed into l_payroll_id;

Line 486: hr_utility.set_location(l_proc, 120);

482: OPEN csr_hr_data_removed(csr_pay_payrolls_rec.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');

Line 498: hr_utility.set_location('Leaving:' || l_proc, 130);

494: END IF;
495: END LOOP outer_loop;
496: END ;
497: COMMIT;
498: hr_utility.set_location('Leaving:' || l_proc, 130);
499: END validate_payroll;
500:
501: --
502: -- For Element Type validation

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

552:
553: l_proc VARCHAR2(72) := g_package||'validate_element_type';
554:
555: BEGIN
556: hr_utility.set_location('Entering:' || l_proc, 10);
557: l_counter := 0;
558:
559: <>
560: FOR v_ud_rec IN csr_element_type LOOP

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

558:
559: <>
560: FOR v_ud_rec IN csr_element_type LOOP
561: SAVEPOINT element_type_start;
562: hr_utility.set_location(l_proc, 20);
563: l_element_type_to_id := hr_h2pi_map.get_to_id
564: (p_table_name => 'PAY_ELEMENT_TYPES_F',
565: p_from_id => v_ud_rec.element_type_id);
566:

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

564: (p_table_name => 'PAY_ELEMENT_TYPES_F',
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');

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

571: p_message_level => 'FATAL',
572: p_message_name => 'HR_289260_UD_DATA_ADDED');
573: ELSE
574: BEGIN
575: hr_utility.set_location(l_proc, 40);
576: SELECT *
577: INTO l_ed_rec
578: FROM hr_h2pi_element_types_v
579: WHERE element_type_id = l_element_type_to_id

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

586: IF l_ed_rec.element_name <> v_ud_rec.element_name OR
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');

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

595: END IF;
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');

Line 605: hr_utility.set_location(l_proc, 70);

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
605: hr_utility.set_location(l_proc, 70);
606: END;
607: END IF;
608: END LOOP main_loop;
609:

Line 613: hr_utility.set_location(l_proc, 80);

609:
610: BEGIN
611: <>
612: FOR csr_pay_element_type_rec in csr_pay_element_type LOOP
613: hr_utility.set_location(l_proc, 80);
614: l_record_ok := FALSE;
615:
616: <>
617: FOR j IN 1..l_counter LOOP

Line 624: hr_utility.set_location(l_proc, 90);

620: END IF;
621: END LOOP inner_loop;
622:
623: IF NOT l_record_ok THEN
624: hr_utility.set_location(l_proc, 90);
625: OPEN csr_payroll_data_added(csr_pay_element_type_rec.element_type_id);
626: FETCH csr_payroll_data_added INTO l_element_type_id;
627:
628: IF csr_payroll_data_added%FOUND then

Line 630: hr_utility.set_location(l_proc, 100);

626: FETCH csr_payroll_data_added INTO 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');

Line 639: hr_utility.set_location(l_proc, 110);

635: CLOSE csr_payroll_data_added;
636:
637: ELSE
638:
639: hr_utility.set_location(l_proc, 110);
640: CLOSE csr_payroll_data_added;
641:
642: OPEN csr_hr_data_removed(csr_pay_element_type_rec.element_type_id);
643: FETCH csr_hr_data_removed into l_element_type_id;

Line 645: hr_utility.set_location(l_proc, 130);

641:
642: OPEN csr_hr_data_removed(csr_pay_element_type_rec.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',

Line 658: hr_utility.set_location('Leaving:' || l_proc, 130);

654: END IF;
655: END LOOP outer_loop;
656: END ;
657: COMMIT;
658: hr_utility.set_location('Leaving:' || l_proc, 130);
659: END validate_element_type;
660:
661: --
662: -- For org payment method validation

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

712:
713: l_proc VARCHAR2(72) := g_package||'validate_org_payment_methods';
714:
715: BEGIN
716: hr_utility.set_location('Entering:'|| l_proc, 10);
717: l_counter := 0;
718:
719: <>
720: FOR v_ud_rec IN csr_org_payment_method LOOP

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

718:
719: <>
720: FOR v_ud_rec IN csr_org_payment_method LOOP
721: SAVEPOINT org_payment_start;
722: hr_utility.set_location(l_proc, 20);
723: l_org_payment_method_to_id := hr_h2pi_map.get_to_id
724: (p_table_name => 'PAY_ORG_PAYMENT_METHODS_F',
725: p_from_id => v_ud_rec.org_payment_method_id);
726:

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

724: (p_table_name => 'PAY_ORG_PAYMENT_METHODS_F',
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');

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

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
734: hr_utility.set_location(l_proc, 40);
735: BEGIN
736: SELECT *
737: INTO l_ed_rec
738: FROM hr_h2pi_org_payment_methods_v

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

749: --l_ed_rec.external_account_id <> v_ud_rec.external_account_id OR
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');

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

758: END IF;
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');

Line 768: hr_utility.set_location(l_proc, 70);

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
768: hr_utility.set_location(l_proc, 70);
769: END;
770: END IF;
771: END LOOP main_loop;
772:

Line 776: hr_utility.set_location(l_proc, 80);

772:
773: BEGIN
774: <>
775: FOR csr_pay_org_payment_method_rec in csr_pay_org_payment_method LOOP
776: hr_utility.set_location(l_proc, 80);
777: l_record_ok := FALSE;
778:
779: <>
780: FOR j IN 1..l_counter LOOP

Line 787: hr_utility.set_location(l_proc, 90);

783: END IF;
784: END LOOP inner_loop;
785:
786: IF NOT l_record_ok THEN
787: hr_utility.set_location(l_proc, 90);
788: OPEN csr_payroll_data_added(csr_pay_org_payment_method_rec.org_payment_method_id);
789: FETCH csr_payroll_data_added INTO l_org_payment_method_id;
790:
791: IF csr_payroll_data_added%FOUND then

Line 792: hr_utility.set_location(l_proc, 100);

788: OPEN csr_payroll_data_added(csr_pay_org_payment_method_rec.org_payment_method_id);
789: FETCH csr_payroll_data_added INTO 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',

Line 802: hr_utility.set_location(l_proc, 110);

798: CLOSE csr_payroll_data_added;
799:
800: ELSE
801:
802: hr_utility.set_location(l_proc, 110);
803: CLOSE csr_payroll_data_added;
804:
805: OPEN csr_hr_data_removed(csr_pay_org_payment_method_rec.org_payment_method_id);
806: FETCH csr_hr_data_removed into l_org_payment_method_id;

Line 807: hr_utility.set_location(l_proc, 120);

803: CLOSE csr_payroll_data_added;
804:
805: OPEN csr_hr_data_removed(csr_pay_org_payment_method_rec.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',

Line 821: hr_utility.set_location('Leaving: '|| l_proc, 130);

817: END IF;
818: END LOOP outer_loop;
819: END ;
820: COMMIT;
821: hr_utility.set_location('Leaving: '|| l_proc, 130);
822: END validate_org_payment_method;
823:
824: --
825: -- For Element Link validation

Line 887: hr_utility.set_location('Leaving: '|| l_proc, 10);

883:
884: l_proc VARCHAR2(72) := g_package||'validate_element_link';
885:
886: BEGIN
887: hr_utility.set_location('Leaving: '|| l_proc, 10);
888: l_counter := 0;
889:
890: <>
891: FOR v_ud_rec IN csr_element_link LOOP

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

889:
890: <>
891: FOR v_ud_rec IN csr_element_link LOOP
892: SAVEPOINT element_link_start;
893: hr_utility.set_location(l_proc, 20);
894: l_element_link_to_id := hr_h2pi_map.get_to_id
895: (p_table_name => 'PAY_ELEMENT_LINKS_F',
896: p_from_id => v_ud_rec.element_link_id);
897:

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

895: (p_table_name => 'PAY_ELEMENT_LINKS_F',
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');

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

902: p_message_level => 'FATAL',
903: p_message_name => 'HR_289260_UD_DATA_ADDED');
904: ELSE
905: BEGIN
906: hr_utility.set_location(l_proc, 40);
907: SELECT *
908: INTO l_ed_rec
909: FROM hr_h2pi_element_links_v
910: WHERE element_link_id = l_element_link_to_id

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

935: <> NVL(l_organization_id, -1) OR
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');

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

944: END IF;
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');

Line 954: hr_utility.set_location(l_proc, 70);

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
954: hr_utility.set_location(l_proc, 70);
955: END;
956: END IF;
957: END LOOP main_loop;
958:

Line 962: hr_utility.set_location(l_proc, 80);

958:
959: BEGIN
960: <>
961: FOR csr_pay_element_link_rec in csr_pay_element_link LOOP
962: hr_utility.set_location(l_proc, 80);
963: l_record_ok := FALSE;
964:
965: <>
966: FOR j IN 1..l_counter LOOP

Line 973: hr_utility.set_location(l_proc, 90);

969: END IF;
970: END LOOP inner_loop;
971:
972: IF NOT l_record_ok THEN
973: hr_utility.set_location(l_proc, 90);
974: OPEN csr_payroll_data_added(csr_pay_element_link_rec.element_link_id);
975: FETCH csr_payroll_data_added INTO l_element_link_id;
976:
977: IF csr_payroll_data_added%FOUND then

Line 978: hr_utility.set_location(l_proc, 100);

974: OPEN csr_payroll_data_added(csr_pay_element_link_rec.element_link_id);
975: FETCH csr_payroll_data_added INTO 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',

Line 988: hr_utility.set_location(l_proc, 110);

984: CLOSE csr_payroll_data_added;
985:
986: ELSE
987:
988: hr_utility.set_location(l_proc, 110);
989: CLOSE csr_payroll_data_added;
990:
991: OPEN csr_hr_data_removed(csr_pay_element_link_rec.element_link_id);
992: FETCH csr_hr_data_removed into l_element_link_id;

Line 995: hr_utility.set_location(l_proc, 120);

991: OPEN csr_hr_data_removed(csr_pay_element_link_rec.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');

Line 1007: hr_utility.set_location('Leaving: '|| l_proc, 130);

1003: END IF;
1004: END LOOP outer_loop;
1005: END ;
1006: COMMIT;
1007: hr_utility.set_location('Leaving: '|| l_proc, 130);
1008: END validate_element_link;
1009: --
1010: -- This procedure checks for the GEOCODE changes on HR and Payroll system
1011: -- If HR or Payroll systems are more then one patches out of sync then

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

1106: l_proc VARCHAR2(72) := g_package||'validate_geocodes';
1107:
1108: BEGIN
1109: SAVEPOINT geocode_start;
1110: hr_utility.set_location('Entering:'|| l_proc, 10);
1111: OPEN csr_ud_geocode;
1112: OPEN csr_ed_geocode;
1113: FETCH csr_ud_geocode INTO l_ud_geocode;
1114: SELECT count(*)

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

1116: FROM hr_h2pi_patch_status_v
1117: WHERE patch_name > l_ud_geocode;
1118:
1119: IF l_ed_more_then_two_ver_ahead > 1 then
1120: hr_utility.set_location(l_proc, 20);
1121: RAISE e_ed_more_then_two_ver_ahead;
1122: END IF;
1123:
1124: FETCH csr_ed_geocode INTO l_ed_geocode;

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

1128: WHERE patch_name > l_ed_geocode
1129: AND client_id = p_from_client_id;
1130:
1131: IF l_ud_more_then_two_ver_ahead > 1 then
1132: hr_utility.set_location(l_proc, 30);
1133: RAISE e_ud_more_then_two_ver_ahead;
1134: END IF;
1135: IF l_ud_geocode < l_ed_geocode THEN
1136: hr_utility.set_location(l_proc, 40);

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

1132: hr_utility.set_location(l_proc, 30);
1133: RAISE e_ud_more_then_two_ver_ahead;
1134: END IF;
1135: IF l_ud_geocode < l_ed_geocode THEN
1136: hr_utility.set_location(l_proc, 40);
1137: l_geocode_status := 'UD LATER';
1138: ELSIF l_ud_geocode > l_ed_geocode THEN
1139: hr_utility.set_location(l_proc, 50);
1140: l_geocode_status := 'ED LATER';

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

1135: IF l_ud_geocode < l_ed_geocode THEN
1136: hr_utility.set_location(l_proc, 40);
1137: l_geocode_status := 'UD LATER';
1138: ELSIF l_ud_geocode > l_ed_geocode THEN
1139: hr_utility.set_location(l_proc, 50);
1140: l_geocode_status := 'ED LATER';
1141: ELSE
1142: hr_utility.set_location(l_proc, 60);
1143: l_geocode_status := 'MATCHES';

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

1138: ELSIF l_ud_geocode > l_ed_geocode THEN
1139: hr_utility.set_location(l_proc, 50);
1140: l_geocode_status := 'ED LATER';
1141: ELSE
1142: hr_utility.set_location(l_proc, 60);
1143: l_geocode_status := 'MATCHES';
1144: END IF;
1145: CLOSE csr_ud_geocode;
1146: CLOSE csr_ed_geocode;

Line 1149: hr_utility.set_location(l_proc, 70);

1145: CLOSE csr_ud_geocode;
1146: CLOSE csr_ed_geocode;
1147:
1148: IF l_geocode_status = 'ED LATER' then
1149: hr_utility.set_location(l_proc, 70);
1150: --
1151: open csr_input_values;
1152: fetch csr_input_values into l_input_value1;
1153: fetch csr_input_values into l_input_value2;

Line 1165: hr_utility.set_location(l_proc, 80);

1161: p_report_error => TRUE);
1162:
1163: --
1164: FOR csr_ud_city_tax_rec IN csr_ud_city_tax LOOP
1165: hr_utility.set_location(l_proc, 80);
1166: l_state_code := substr(csr_ud_city_tax_rec.jurisdiction_code,1,2);
1167: l_county_code := substr(csr_ud_city_tax_rec.jurisdiction_code,4,3);
1168: l_city_code := substr(csr_ud_city_tax_rec.jurisdiction_code,8,4);
1169: -- This is user defined city write an error

Line 1174: hr_utility.set_location(l_proc, 90);

1170: FOR csr_ud_city_tax_comp_rec IN csr_ud_city_tax_comp(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',

Line 1183: hr_utility.set_location(l_proc, 100);

1179: p_message_level => 'FATAL',
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',

Line 1198: hr_utility.set_location(l_proc, 110);

1194: END IF;
1195: END LOOP;
1196: END LOOP;
1197: ELSIF l_geocode_status = 'UD LATER' then
1198: hr_utility.set_location(l_proc, 110);
1199: FOR csr_ed_city_tax_rec IN csr_ed_city_tax LOOP
1200: l_state_code := substr(csr_ed_city_tax_rec.jurisdiction_code,1,2);
1201: l_county_code := substr(csr_ed_city_tax_rec.jurisdiction_code,4,3);
1202: l_city_code := substr(csr_ed_city_tax_rec.jurisdiction_code,8,4);

Line 1203: hr_utility.set_location(l_proc, 120);

1199: FOR csr_ed_city_tax_rec IN csr_ed_city_tax LOOP
1200: l_state_code := substr(csr_ed_city_tax_rec.jurisdiction_code,1,2);
1201: l_county_code := substr(csr_ed_city_tax_rec.jurisdiction_code,4,3);
1202: l_city_code := substr(csr_ed_city_tax_rec.jurisdiction_code,8,4);
1203: hr_utility.set_location(l_proc, 120);
1204: FOR csr_ed_city_tax_comp_rec IN csr_ed_city_tax_comp(l_state_code,
1205: l_county_code,
1206: l_city_code) LOOP
1207: IF l_city_code LIKE 'U%' THEN

Line 1232: hr_utility.set_location('Leaving:'|| l_proc, 130);

1228: END LOOP;
1229: END LOOP;
1230: END IF;
1231: COMMIT;
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',

Line 1235: hr_utility.set_location(l_proc, 140);

1231: COMMIT;
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');

Line 1242: hr_utility.set_location(l_proc, 150);

1238: p_message_level => 'FATAL',
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');

Line 1249: hr_utility.set_location(l_proc, 160);

1245: p_message_level => 'FATAL',
1246: p_message_name => 'HR_289235_ED_DATA_REMOVED');
1247: --RAISE;
1248: WHEN MAPPING_ID_MISSING THEN
1249: hr_utility.set_location(l_proc, 160);
1250:
1251: END validate_geocode;
1252:
1253: END hr_h2pi_validate;