DBA Data[Home] [Help]

APPS.PQP_EARNINGS_TEMPLATE dependencies on HR_UTILITY

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

121: ------------------------------------------------------------------------------
122: -- MAIN FUNCTION
123: ------------------------------------------------------------------------------
124: BEGIN
125: hr_utility.set_location('Entering : '||l_proc, 10);
126: --
127: -- Set the global variables
128: --
129: g_bg_id := p_bg_id;

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

138: FOR c_rec IN c_template('Alien Earning') LOOP
139: l_source_template_id := c_rec.template_id;
140: END LOOP;
141: --
142: hr_utility.set_location(l_proc, 20);
143: --------------------------------------------
144: -- Create the user Structure
145: --------------------------------------------
146: -- The Configuration Flex segments for the Exclusion Rules are as follows:

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

168: l_config4_hr := 'Y';
169: l_calc_type := 'HOURS_X_RATE';
170: END IF;
171: --
172: hr_utility.set_location(l_proc, 60);
173: --
174: pay_element_template_api.create_user_structure
175: (p_validate => false
176: ,p_effective_date => p_ele_eff_start_date

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

187: ,p_configuration_information7 => p_ele_ot_base
188: ,p_template_id => l_template_id
189: ,p_object_version_number => l_ovn );
190: --
191: hr_utility.set_location(l_proc, 80);
192: -----------------------------------------------------------
193: -- Update Base shadow Element with user-specified details
194: -----------------------------------------------------------
195: FOR c_rec in c_element ( p_ele_name ) LOOP

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

215: ,p_element_information8 => p_ele_ot_base
216: ,p_element_information11 => p_flsa_hours
217: ,p_object_version_number => l_ovn
218: );
219: hr_utility.set_location(l_proc, 90);
220: ------------------------------------------------------------------
221: -- Update user-specified details on Supp Special Features Element.
222: ------------------------------------------------------------------
223: FOR c1_rec in c_element ( p_ele_name||' Supp SF') LOOP

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

235: ,p_element_information8 => p_ele_ot_base
236: ,p_object_version_number => l_ovn
237: );
238: END LOOP;
239: hr_utility.set_location(l_proc, 100);
240: -------------------------------------------------------------------
241: -- Update user-specified details on Alien Special Features Element.
242: -------------------------------------------------------------------
243: FOR c1_rec in c_element ( p_ele_name||' Alien SF') LOOP

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

254: ,p_element_information8 => p_ele_ot_base
255: ,p_object_version_number => l_ovn
256: );
257: END LOOP;
258: hr_utility.set_location(l_proc, 110);
259: --------------------------------------------------------------------
260: -- Update user-specified Classification Special Inputs if it exists.
261: --------------------------------------------------------------------
262: IF p_ele_processing_type = 'R' THEN

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

276: ,p_object_version_number => l_ovn
277: );
278: END IF;
279: --
280: hr_utility.set_location(l_proc, 120);
281: ------------------------------------------------------------
282: -- Generate Core Objects
283: ------------------------------------------------------------
284: pay_element_template_api.generate_part1

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

287: ,p_hr_only => false
288: ,p_hr_to_payroll => false
289: ,p_template_id => l_template_id);
290: --
291: hr_utility.set_location(l_proc, 130);
292: --
293: -- Add logic to generate part2 only if payroll is installed
294: --
295: pay_element_template_api.generate_part2

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

295: pay_element_template_api.generate_part2
296: (p_validate => false
297: ,p_effective_date => p_ele_eff_start_date
298: ,p_template_id => l_template_id);
299: hr_utility.set_location(l_proc, 140);
300: --
301: -------------------------------------------------------------------
302: -- Get Element and Balance Id's to update the Further Information
303: -------------------------------------------------------------------

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

349: AND business_group_id = p_bg_id;*/
350: --
351:
352: --
353: hr_utility.set_location(l_proc, 150);
354: --------------------------------------------------------------------
355: -- Update the Further Information for the Alien Supplemental element
356: --------------------------------------------------------------------
357: l_supp_bal_id := get_obj_id('BAL', p_ele_name||' Supp');

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

423: t_bal_id(17) := get_obj_id('BAL', 'Alien 1042s for SIT');
424: t_ipv_id(18) := get_obj_id('IPV', 'Alien SIT 1042s', l_ssf_ele_type_id);
425: t_bal_id(18) := get_obj_id('BAL', 'Alien 1042s for NWSIT');
426: --
427: hr_utility.set_location(l_proc, 160);
428: FOR i in 1..18 LOOP
429: hr_balances.ins_balance_feed(
430: p_option => 'INS_MANUAL_FEED',
431: p_input_value_id => t_ipv_id(i),

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

439: p_business_group => p_bg_id,
440: p_legislation_code => NULL,
441: p_mode => 'USER');
442: END LOOP;
443: hr_utility.set_location(l_proc, 170);
444: -------------------------------------------------------------------
445: -- Update Input values with default values, validation formula etc.
446: -------------------------------------------------------------------
447: t_ipv_id(1) := get_obj_id('IPV', 'Deduction Processing', l_pri_ele_type_id);

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

461: -- END LOOP;
462: -- t_we_flag(3) := 'E'; -- warning or error flag
463: -- t_def_val(3) := NULL; -- default value
464: --
465: hr_utility.set_location(l_proc, 170);
466: FOR i in 1..2 LOOP
467: UPDATE pay_input_values_f
468: SET formula_id = t_form_id(i)
469: ,warning_or_error = t_we_flag(i)

Line 476: hr_utility.set_location(l_proc, 180);

472: END LOOP;
473: -------------------------------------------------------------------
474: -- Create the balance feeds for FLSA Hours and Reduce Regular
475: -------------------------------------------------------------------
476: hr_utility.set_location(l_proc, 180);
477: add_flsa_reduce_reg_feeds
478: (p_ele_ot_base => p_ele_ot_base
479: ,p_flsa_hours => p_flsa_hours
480: ,p_reduce_regular => p_reduce_regular

Line 486: hr_utility.set_location('Leaving: '||l_proc, 200);

482: ,p_ssf_ele_type_id => l_ssf_ele_type_id
483: ,p_asf_ele_type_id => l_asf_ele_type_id
484: ,p_ele_eff_start_date => p_ele_eff_start_date );
485: --
486: hr_utility.set_location('Leaving: '||l_proc, 200);
487: -------------------------
488: RETURN l_pri_ele_type_id;
489: -------------------------
490: END create_ele_template_objects;

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

521: AND NVL(pbt.business_group_id, g_bg_id) = g_bg_id
522: AND NVL(pbt.legislation_code, g_legislation_code) = g_legislation_code;
523: --
524: BEGIN
525: hr_utility.set_location('Entering: '||l_proc, 10);
526: --
527: IF p_object_type = 'ELE' then
528: FOR c_rec in c_element LOOP
529: l_object_id := c_rec.element_type_id; -- element id

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

536: FOR c_rec in c_get_ipv_id LOOP
537: l_object_id := c_rec.input_value_id; -- input value id
538: END LOOP;
539: END IF;
540: hr_utility.set_location('Leaving: '||l_proc, 50);
541: --
542: RETURN l_object_id;
543: END get_obj_id;
544: --===========================================================================

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

589: AND piv.legislation_code = 'US') ;
590: --
591: BEGIN
592: --
593: hr_utility.set_location(l_proc, 60);
594: IF p_flsa_hours = 'Y' THEN
595: -- create balance feeds for FLSA hours
596: hr_utility.set_location(l_proc, 60);
597: l_count := l_count + 1;

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

592: --
593: hr_utility.set_location(l_proc, 60);
594: IF p_flsa_hours = 'Y' THEN
595: -- create balance feeds for FLSA hours
596: hr_utility.set_location(l_proc, 60);
597: l_count := l_count + 1;
598: t_ipv_id(l_count) := get_obj_id('IPV', 'Hours', p_pri_ele_type_id);
599: t_bal_id(l_count) := get_obj_id('BAL', 'FLSA Hours');
600: t_scale(l_count) := 1;

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

654: p_business_group => g_bg_id,
655: p_legislation_code => NULL,
656: p_mode => 'USER');
657: END LOOP;
658: hr_utility.set_location(l_proc, 70);
659: --
660: END add_flsa_reduce_reg_feeds;
661: --===========================================================================
662: -- Deletion procedure

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

680:
681: --
682: BEGIN
683: --
684: hr_utility.set_location('Entering :'||l_proc, 10);
685: for c1_rec in c1 loop
686: l_template_id := c1_rec.template_id;
687: end loop;
688: --

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

689: pay_element_template_api.delete_user_structure
690: (p_validate => false
691: ,p_drop_formula_packages => true
692: ,p_template_id => l_template_id);
693: hr_utility.set_location('Leaving :'||l_proc, 50);
694: --
695: END delete_ele_template_objects;
696: --
697: END pqp_earnings_template;