DBA Data[Home] [Help]

APPS.PQP_GB_PENSIONS_TEMPLATE dependencies on HR_UTILITY

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

155: AND business_group_id is NULL;
156: --
157: BEGIN
158: --
159: hr_utility.set_location('Entering: '||l_proc, 10);
160: --
161: l_template_name := 'PQP PENSION AND AVCS';
162: --
163: hr_utility.set_location(l_proc, 30);

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

159: hr_utility.set_location('Entering: '||l_proc, 10);
160: --
161: l_template_name := 'PQP PENSION AND AVCS';
162: --
163: hr_utility.set_location(l_proc, 30);
164: --
165: for c4_rec in c4 loop
166: l_template_id := c4_rec.template_id;
167: end loop;

Line 169: hr_utility.set_location('Leaving: '||l_proc, 100);

165: for c4_rec in c4 loop
166: l_template_id := c4_rec.template_id;
167: end loop;
168: --
169: hr_utility.set_location('Leaving: '||l_proc, 100);
170: --
171: RETURN l_template_id;
172: --
173: END get_template_id;

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

323: AND ptco.template_id = psbt.template_id
324: AND ptco.shadow_object_id = psbt.balance_type_id;
325: --
326: BEGIN
327: hr_utility.set_location('Entering: '||l_proc, 10);
328: --
329: if p_object_type = 'ELE' then
330: for c2_rec in c2 (p_object_name) loop
331: l_object_id := c2_rec.element_type_id; -- element id

Line 339: hr_utility.set_location('Leaving: '||l_proc, 50);

335: l_object_id := c3_rec.core_object_id; -- balance id
336: end loop;
337: end if;
338: --
339: hr_utility.set_location('Leaving: '||l_proc, 50);
340: --
341: RETURN l_object_id;
342: --
343: END get_object_id;

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

345: --===============================================================================
346: -- MAIN FUNCTION
347: --===============================================================================
348: BEGIN
349: hr_utility.set_location('Entering : '||l_proc, 10);
350: ---------------------
351: -- Set session date
352: ---------------------
353:

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

352: ---------------------
353:
354: pay_db_pay_setup.set_session_date(nvl(p_ele_eff_start_date, sysdate));
355: --
356: hr_utility.set_location(l_proc, 20);
357: ---------------------------
358: -- Get Source Template ID
359: ---------------------------
360: l_source_template_id := get_template_id

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

359: ---------------------------
360: l_source_template_id := get_template_id
361: (p_legislation_code => 'GB'
362: );
363: hr_utility.set_location(l_proc, 30);
364: --
365: /*--------------------------------------------------------------------------
366: Create the user Structure
367: The Configuration Flex segments for the Exclusion Rules are as follows:

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

497: ,p_object_version_number => l_object_version_number
498: );
499: --
500:
501: hr_utility.set_location(l_proc, 80);
502: ---------------------------------------------------------------------------
503: ---------------------------- Update Shadow Structure ----------------------
504: --
505:

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

591:
592: -------------------------------------------------------------------------
593: --
594: --
595: hr_utility.set_location(l_proc, 110);
596: ---------------------------------------------------------------------------
597: ---------------------------- Generate Core Objects ------------------------
598: ---------------------------------------------------------------------------
599:

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

603: ,p_hr_only => false
604: ,p_hr_to_payroll => false
605: ,p_template_id => l_template_id);
606: --
607: hr_utility.set_location(l_proc, 120);
608: --
609: pay_element_template_api.generate_part2
610: (p_validate => false
611: ,p_effective_date => p_ele_eff_start_date

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

611: ,p_effective_date => p_ele_eff_start_date
612: ,p_template_id => l_template_id);
613: --
614:
615: hr_utility.set_location(l_proc, 130);
616:
617: --
618: -- Update base element formula if contribution type is flat rate
619: --

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

622: update_eletyp_for(p_ele_name
623: ,'ONCE_EACH_PERIOD');
624: END IF; -- End if of contribution method check...
625:
626: hr_utility.set_location(l_proc, 140);
627:
628: --
629: -- Update Input Values Default Values
630: --

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

643: ,l_name
644: ,p_emp_contribution);
645: END IF; -- End if of emp_contribution value check...
646:
647: hr_utility.set_location(l_proc, 150);
648:
649: IF p_eer_contribution = 'Y' AND
650: p_eer_rate IS NOT NULL THEN
651:

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

661: ,l_name
662: ,p_eer_rate);
663: END IF; -- End if of employer contribution check...
664:
665: hr_utility.set_location(l_proc, 160);
666:
667: l_base_element_type_id := get_object_id ('ELE', p_ele_name);
668:
669: hr_utility.set_location(l_proc, 170);

Line 669: hr_utility.set_location(l_proc, 170);

665: hr_utility.set_location(l_proc, 160);
666:
667: l_base_element_type_id := get_object_id ('ELE', p_ele_name);
668:
669: hr_utility.set_location(l_proc, 170);
670:
671: -- Create a row in pay_element_extra_info with all the element information
672:
673: pay_element_extra_info_api.create_element_extra_info

Line 692: hr_utility.set_location('Leaving :'||l_proc, 180);

688: ,p_eei_information12 => l_eei_information12
689: ,p_element_type_extra_info_id => l_eei_info_id
690: ,p_object_version_number => l_ovn_eei);
691:
692: hr_utility.set_location('Leaving :'||l_proc, 180);
693:
694: RETURN l_base_element_type_id;
695:
696: --

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

727: AND template_type = 'U';
728: --
729: BEGIN
730: --
731: hr_utility.set_location('Entering :'||l_proc, 10);
732: --
733: OPEN eei;
734: LOOP
735: FETCH eei INTO l_eei_info_id ;

Line 759: hr_utility.set_location('Leaving :'||l_proc, 50);

755: ,p_drop_formula_packages => true
756: ,p_template_id => l_template_id);
757: --
758:
759: hr_utility.set_location('Leaving :'||l_proc, 50);
760: --
761: END delete_user_template;
762: --
763: END pqp_gb_pensions_template;