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.NTG_EARNINGS_TEMPLATE dependencies on HR_UTILITY

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

121: AND NVL(pbt.business_group_id, p_bg_id) = p_bg_id
122: AND NVL(pbt.legislation_code, p_legislation_code) = p_legislation_code;
123: --
124: BEGIN
125: hr_utility.set_location('Entering: '||l_proc, 10);
126: --
127: IF p_object_type = 'ELEMENT' then
128: FOr c_rec in c_element LOOP
129: l_object_id := c_rec.element_type_id; -- element id

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

136: FOR c_rec in c_get_ipv_id LOOP
137: l_object_id := c_rec.input_value_id; -- input value id
138: END LOOP;
139: END IF;
140: hr_utility.set_location('Leaving: '||l_proc, 50);
141: --
142: RETURN l_object_id;
143: END get_obj_id;
144: ---------------------------------------------------------------------------------

Line 148: -- hr_utility.trace_on('Y','ELISA');

144: ---------------------------------------------------------------------------------
145: ---------------------------------- MAIN FUNCTION --------------------------------
146: ---------------------------------------------------------------------------------
147: BEGIN
148: -- hr_utility.trace_on('Y','ELISA');
149:
150: hr_utility.set_location('Entering : '||l_proc, 10);
151: --
152: -- Set session date and Source template id

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

146: ---------------------------------------------------------------------------------
147: BEGIN
148: -- hr_utility.trace_on('Y','ELISA');
149:
150: hr_utility.set_location('Entering : '||l_proc, 10);
151: --
152: -- Set session date and Source template id
153: --
154: pay_db_pay_setup.set_session_date(nvl(p_ele_eff_start_date, sysdate));

Line 158: hr_utility.set_location(l_proc, 15);

154: pay_db_pay_setup.set_session_date(nvl(p_ele_eff_start_date, sysdate));
155: --
156: -- Check Element Name
157: --
158: hr_utility.set_location(l_proc, 15);
159: --
160: BEGIN
161: select 'Y'
162: into l_reserved

Line 174: hr_utility.set_location(l_proc,16);

170:
171: END;
172:
173: if l_reserved = 'Y' then
174: hr_utility.set_location(l_proc,16);
175: hr_utility.set_message(801,'HR_7564_ALL_RES_WORDS');
176: hr_utility.raise_error;
177: end if;
178:

Line 175: hr_utility.set_message(801,'HR_7564_ALL_RES_WORDS');

171: END;
172:
173: if l_reserved = 'Y' then
174: hr_utility.set_location(l_proc,16);
175: hr_utility.set_message(801,'HR_7564_ALL_RES_WORDS');
176: hr_utility.raise_error;
177: end if;
178:
179: hr_utility.set_location(l_proc, 20);

Line 176: hr_utility.raise_error;

172:
173: if l_reserved = 'Y' then
174: hr_utility.set_location(l_proc,16);
175: hr_utility.set_message(801,'HR_7564_ALL_RES_WORDS');
176: hr_utility.raise_error;
177: end if;
178:
179: hr_utility.set_location(l_proc, 20);
180: --

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

175: hr_utility.set_message(801,'HR_7564_ALL_RES_WORDS');
176: hr_utility.raise_error;
177: end if;
178:
179: hr_utility.set_location(l_proc, 20);
180: --
181: -- Set Skip Rules
182: --
183: if p_ele_classification = 'Supplemental Earnings' then

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

210: --------------------------------------------
211: -- Create the user Structure
212: --------------------------------------------
213: --
214: hr_utility.set_location(l_proc, 60);
215: --
216: -- This procedure replaces with actual
217: -- element name that the user passed and creates
218: -- all elements in user schema (in template tables).

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

236: ,p_configuration_information11 => p_sep_check_option
237: ,p_template_id => l_template_id
238: ,p_object_version_number => l_ovn );
239: --
240: hr_utility.set_location(l_proc, 80);
241: --
242: ---------------------- Get Element Type ID of new Template -----------------
243: --
244: select element_type_id, object_version_number

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

277: ,p_standard_link_flag => nvl(p_ele_standard_link, hr_api.g_varchar2)
278: ,p_skip_formula => l_skip_formula
279: ,p_object_version_number => l_ele_obj_ver_number
280: );
281: hr_utility.set_location(l_proc, 90);
282:
283: /* NO SPECIAL FEATURES FOR NTG
284:
285: ------------------------------------------------------------------

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

300: */
301: ------------------------------------------------------------
302: -- Generate Core Objects
303: ------------------------------------------------------------
304: hr_utility.set_location(l_proc, 120);
305:
306: pay_element_template_api.generate_part1
307: (p_validate => false
308: ,p_effective_date => p_ele_eff_start_date

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

309: ,p_hr_only => false
310: ,p_hr_to_payroll => false
311: ,p_template_id => l_template_id);
312: --
313: hr_utility.set_location(l_proc, 130);
314: --
315: if (hr_utility.chk_product_install('Oracle Payroll','US')) then
316: pay_element_template_api.generate_part2
317: (p_validate => false

Line 315: if (hr_utility.chk_product_install('Oracle Payroll','US')) then

311: ,p_template_id => l_template_id);
312: --
313: hr_utility.set_location(l_proc, 130);
314: --
315: if (hr_utility.chk_product_install('Oracle Payroll','US')) then
316: pay_element_template_api.generate_part2
317: (p_validate => false
318: ,p_effective_date => p_ele_eff_start_date
319: ,p_template_id => l_template_id);

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

317: (p_validate => false
318: ,p_effective_date => p_ele_eff_start_date
319: ,p_template_id => l_template_id);
320: end if;
321: hr_utility.set_location(l_proc, 140);
322: --
323: -------------------------------------------------------------------
324: -- Get Element and Balance Id's to update the Further Information
325: -------------------------------------------------------------------

Line 336: hr_utility.set_location(l_proc, 145);

332: --
333: OPEN c_iter_formula_id;
334: FETCH c_iter_formula_id into l_iter_formula_id;
335: IF c_iter_formula_id%NOTFOUND then
336: hr_utility.set_location(l_proc, 145);
337: hr_utility.set_message(800,'ITERATIVE FORMULA NOT FOUND');
338: hr_utility.raise_error;
339: END IF;
340: CLOSE c_iter_formula_id;

Line 337: hr_utility.set_message(800,'ITERATIVE FORMULA NOT FOUND');

333: OPEN c_iter_formula_id;
334: FETCH c_iter_formula_id into l_iter_formula_id;
335: IF c_iter_formula_id%NOTFOUND then
336: hr_utility.set_location(l_proc, 145);
337: hr_utility.set_message(800,'ITERATIVE FORMULA NOT FOUND');
338: hr_utility.raise_error;
339: END IF;
340: CLOSE c_iter_formula_id;
341: ----------------------------------------------

Line 338: hr_utility.raise_error;

334: FETCH c_iter_formula_id into l_iter_formula_id;
335: IF c_iter_formula_id%NOTFOUND then
336: hr_utility.set_location(l_proc, 145);
337: hr_utility.set_message(800,'ITERATIVE FORMULA NOT FOUND');
338: hr_utility.raise_error;
339: END IF;
340: CLOSE c_iter_formula_id;
341: ----------------------------------------------
342: -- Set iterative formula and Termination Rule

Line 393: hr_utility.set_location('p_ele_eff_start_date = '||p_ele_eff_start_date, 149);

389: end if;
390:
391: IF l_insert = 'Y' THEN
392:
393: hr_utility.set_location('p_ele_eff_start_date = '||p_ele_eff_start_date, 149);
394:
395: pay_iterative_rules_api.create_iterative_rule
396: (
397: p_effective_date => p_ele_eff_start_date

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

411: l_insert := 'N';
412: END LOOP;
413:
414: --
415: hr_utility.set_location(l_proc, 150);
416: -------------------------------------------------------------------
417: -- Update Input values with default values, validation formula etc.
418: -------------------------------------------------------------------
419: t_ipv_id(1) := get_obj_id('IPV', 'Separate Check', l_pri_ele_type_id);

Line 424: hr_utility.set_location('Leaving: '||l_proc, 170);

420: t_form_id(1) := NULL;
421: t_we_flag(1) := NULL;
422: t_def_val(1) := p_sep_check_option;
423:
424: hr_utility.set_location('Leaving: '||l_proc, 170);
425: FOR i in 1..1 LOOP
426: UPDATE pay_input_values_f
427: SET formula_id = t_form_id(i)
428: ,warning_or_error = t_we_flag(i)

Line 433: hr_utility.set_location('Leaving: '||l_proc, 175);

429: ,default_value = t_def_val(i)
430: WHERE input_value_id = t_ipv_id(i);
431: END LOOP;
432:
433: hr_utility.set_location('Leaving: '||l_proc, 175);
434:
435: --
436: hr_utility.set_location('Leaving: '||l_proc, 180);
437:

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

432:
433: hr_utility.set_location('Leaving: '||l_proc, 175);
434:
435: --
436: hr_utility.set_location('Leaving: '||l_proc, 180);
437:
438: -- Amount needs to feed the Seeded element (FIT_GROSSUP_ADJUSTMENT)
439: -- of Input Value Amount.
440: -- Thus need to get the element_type_id of the seeded element

Line 442: hr_utility.set_location('select element type id', 136);

438: -- Amount needs to feed the Seeded element (FIT_GROSSUP_ADJUSTMENT)
439: -- of Input Value Amount.
440: -- Thus need to get the element_type_id of the seeded element
441: -- and input_value_id of Amount from the seeded element.
442: hr_utility.set_location('select element type id', 136);
443:
444: Select element_type_id
445: into l_seeded_ele_type_id
446: from pay_element_types_f

Line 450: hr_utility.set_location('element type id' || l_seeded_ele_type_id , 137);

446: from pay_element_types_f
447: where upper(element_name) = 'FIT_GROSSUP_ADJUSTMENT'
448: and legislation_code = 'US';
449:
450: hr_utility.set_location('element type id' || l_seeded_ele_type_id , 137);
451: Select input_value_id
452: into l_seeded_input_val_id
453: from pay_input_values_f
454: where element_type_id = l_seeded_ele_type_id

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

527: AND template_type = 'U';
528: --
529: BEGIN
530: --
531: hr_utility.set_location('Entering :'||l_proc, 10);
532: for c1_rec in c1 loop
533: l_template_id := c1_rec.template_id;
534: end loop;
535: --

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

536: pay_element_template_api.delete_user_structure
537: (p_validate => false
538: ,p_drop_formula_packages => true
539: ,p_template_id => l_template_id);
540: hr_utility.set_location('Leaving :'||l_proc, 50);
541: --
542: END delete_user_template_objects;
543: --
544: END ntg_earnings_template;