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_USER_DEDN_DRV dependencies on HR_UTILITY

Line 92: hr_utility.set_location('pyusddwp.insert_formula',10);

88: r_ele_formula_name VARCHAR2(80);
89: r_ele_name VARCHAR2(80);
90:
91: BEGIN
92: hr_utility.set_location('pyusddwp.insert_formula',10);
93: SELECT FF.formula_text, FF.formula_type_id, FF.description
94: INTO r_skeleton_formula_text, r_skeleton_formula_type_id, r_description
95: FROM ff_formulas_f FF
96: WHERE FF.formula_name = p_ff_formula_name

Line 103: hr_utility.set_location('pyusddwp.insert_formula',15);

99: AND p_eff_start_date between FF.effective_start_date and FF.effective_end_date
100: AND FF.formula_id >= 0; -- Bug#3349575
101:
102: -- Replace element name placeholders with current element name:
103: hr_utility.set_location('pyusddwp.insert_formula',15);
104: r_ele_name := REPLACE(LTRIM(RTRIM(UPPER(p_ff_ele_name))),' ','_');
105:
106: r_ele_formula_name := SUBSTR(REPLACE(LTRIM(RTRIM(UPPER(p_ele_formula_name))),' ','_'), 1, 80);
107:

Line 119: hr_utility.set_location('pyusddwp.insert_formula',30);

115: --
116: -- Insert the new formula into current business goup:
117: -- Get new id
118:
119: hr_utility.set_location('pyusddwp.insert_formula',30);
120: SELECT ff_formulas_s.nextval
121: INTO r_formula_id
122: FROM sys.dual;
123:

Line 124: hr_utility.set_location('pyusddwp.insert_formula',40);

120: SELECT ff_formulas_s.nextval
121: INTO r_formula_id
122: FROM sys.dual;
123:
124: hr_utility.set_location('pyusddwp.insert_formula',40);
125: INSERT INTO ff_formulas_f (
126: FORMULA_ID,
127: EFFECTIVE_START_DATE,
128: EFFECTIVE_END_DATE,

Line 185: hr_utility.set_location('pyusddwp.do_employer_match',10);

181: * and inserts the Result Rule for the formula
182: */
183:
184: BEGIN
185: hr_utility.set_location('pyusddwp.do_employer_match',10);
186: v_formula_name := p_er_ename;
187:
188: v_formula_id:= insert_formula (
189: p_ff_ele_name => p_ename,

Line 196: hr_utility.set_location('pyusddwp.do_employer_match',20);

192: p_ff_bg_id => p_bg_id,
193: p_eff_start_date => p_start_date,
194: p_eff_end_date => p_end_date);
195:
196: hr_utility.set_location('pyusddwp.do_employer_match',20);
197: -- get input values, element_id
198: OPEN csr_input_id(p_er_ename,v_inpval_name,p_bg_id, p_start_date);
199: FETCH csr_input_id INTO
200: v_inpval_id

Line 203: hr_utility.set_location('pyusddwp.do_employer_match',30);

199: FETCH csr_input_id INTO
200: v_inpval_id
201: ,v_frr_iv_ele_id;
202: IF csr_input_id%FOUND THEN
203: hr_utility.set_location('pyusddwp.do_employer_match',30);
204: v_stat_proc_rule_id :=
205: pay_formula_results.ins_stat_proc_rule (
206: p_business_group_id => p_bg_id,
207: p_legislation_code => NULL,

Line 217: hr_utility.set_location('pyusddwp.do_employer_match',40);

213: p_formula_id => v_formula_id,
214: p_processing_rule => 'P');
215:
216:
217: hr_utility.set_location('pyusddwp.do_employer_match',40);
218:
219: v_fres_rule_id := pay_formula_results.ins_form_res_rule (
220: p_business_group_id => p_bg_id,
221: p_legislation_code => NULL,

Line 232: hr_utility.set_location('pyusddwp.do_employer_match',50);

228: p_result_rule_type => 'D',
229: p_severity_level => NULL,
230: p_element_type_id => v_frr_iv_ele_id);
231:
232: hr_utility.set_location('pyusddwp.do_employer_match',50);
233: END IF;
234: CLOSE csr_input_id;
235:
236: END do_employer_match;

Line 268: hr_utility.set_location('pyusddwp.do_passthru_feed',10);

264: AND business_group_id + 0 = p_bg_id;
265:
266:
267: BEGIN
268: hr_utility.set_location('pyusddwp.do_passthru_feed',10);
269: OPEN csr_input_id(p_src_ele,p_src_iv,p_bg_id,p_eff_start_date);
270: FETCH csr_input_id INTO
271: l_inpval_id
272: ,l_dummy;

Line 274: hr_utility.set_location('pyusddwp.do_passthru_feed',20);

270: FETCH csr_input_id INTO
271: l_inpval_id
272: ,l_dummy;
273: IF csr_input_id%NOTFOUND THEN
274: hr_utility.set_location('pyusddwp.do_passthru_feed',20);
275: ELSE
276: hr_utility.set_location('pyusddwp.do_passthru_feed',30);
277: OPEN csr_bal(p_targ_bal);
278: FETCH csr_bal INTO l_balance_type_id;

Line 276: hr_utility.set_location('pyusddwp.do_passthru_feed',30);

272: ,l_dummy;
273: IF csr_input_id%NOTFOUND THEN
274: hr_utility.set_location('pyusddwp.do_passthru_feed',20);
275: ELSE
276: hr_utility.set_location('pyusddwp.do_passthru_feed',30);
277: OPEN csr_bal(p_targ_bal);
278: FETCH csr_bal INTO l_balance_type_id;
279: IF csr_bal%FOUND THEN
280: pay_balance_feeds_f_pkg.insert_row (l_row,

Line 291: hr_utility.set_location('pyusddwp.do_passthru_feed',40);

287: l_inpval_id,
288: 1,
289: g_template_leg_subgroup);
290: ELSE
291: hr_utility.set_location('pyusddwp.do_passthru_feed',40);
292: END IF;
293: CLOSE csr_bal;
294: hr_utility.set_location('pyusddwp.do_passthru_feed',50);
295:

Line 294: hr_utility.set_location('pyusddwp.do_passthru_feed',50);

290: ELSE
291: hr_utility.set_location('pyusddwp.do_passthru_feed',40);
292: END IF;
293: CLOSE csr_bal;
294: hr_utility.set_location('pyusddwp.do_passthru_feed',50);
295:
296: END IF; -- input _id
297: CLOSE csr_input_id;
298: hr_utility.set_location('pyusddwp.do_passthru_feed',60);

Line 298: hr_utility.set_location('pyusddwp.do_passthru_feed',60);

294: hr_utility.set_location('pyusddwp.do_passthru_feed',50);
295:
296: END IF; -- input _id
297: CLOSE csr_input_id;
298: hr_utility.set_location('pyusddwp.do_passthru_feed',60);
299:
300: END do_passthru_feed;
301: ----------------------- END do_passthru_feed ---------------------
302: -------------------- BEGIN Main Driver Program -------------------

Line 349: hr_utility.set_location('pyusddwp.ins_deduction_template',10);

345: --
346: BEGIN
347: IF p_ele_classification = 'Pre-Tax Deductions' THEN
348:
349: hr_utility.set_location('pyusddwp.ins_deduction_template',10);
350:
351: l_ele_id:=
352: hr_generate_pretax.pretax_deduction_template (
353: p_ele_name => p_ele_name,

Line 381: hr_utility.set_location('pyusddwp.ins_deduction_template',20);

377:
378: -- Add Employer Match Formula for Pre-Tax --
379: IF p_ele_er_match = 'Y' THEN
380: --
381: hr_utility.set_location('pyusddwp.ins_deduction_template',20);
382:
383: do_employer_match(
384: p_ename => p_ele_name
385: , p_bg_id => p_bg_id

Line 392: --hr_utility.trace_on;

388: , p_leg_code => g_template_leg_subgroup
389: , p_er_ename => l_er_ename);
390: END IF; -- Employer Match
391:
392: --hr_utility.trace_on;
393:
394: -- Check to see if Aftertax components need to be created
395: IF p_ele_at_component = 'Y' THEN
396:

Line 397: hr_utility.set_location('pyusddwp.ins_deduction_template',30);

393:
394: -- Check to see if Aftertax components need to be created
395: IF p_ele_at_component = 'Y' THEN
396:
397: hr_utility.set_location('pyusddwp.ins_deduction_template',30);
398:
399: -- This Pre-tax deduction has an associated Aftertax Component
400: -- Redefine element names for Aftertax components
401:

Line 434: hr_utility.set_location('pyusddwp.ins_deduction_template',40);

430: p_ele_eff_end_date => p_ele_eff_end_date,
431: p_bg_id => p_bg_id,
432: p_termination_rule => p_termination_rule);
433:
434: hr_utility.set_location('pyusddwp.ins_deduction_template',40);
435:
436: -- Add Employer Match Formula for AT component--
437: IF p_ele_er_match = 'Y' THEN
438: --

Line 439: hr_utility.set_location('pyusddwp.ins_deduction_template',50);

435:
436: -- Add Employer Match Formula for AT component--
437: IF p_ele_er_match = 'Y' THEN
438: --
439: hr_utility.set_location('pyusddwp.ins_deduction_template',50);
440:
441: do_employer_match(
442: p_ename => l_at_ename
443: , p_bg_id => p_bg_id

Line 450: hr_utility.set_location('pyusddwp.ins_deduction_template',60);

446: , p_leg_code => g_template_leg_code
447: , p_er_ename => l_er_ename);
448: END IF; -- Employer Match
449:
450: hr_utility.set_location('pyusddwp.ins_deduction_template',60);
451:
452: do_passthru_feed(
453: p_src_ele => l_withhold_ele
454: , p_bg_id => p_bg_id

Line 460: hr_utility.set_location('pyusddwp.ins_deduction_template',70);

456: , p_targ_bal => l_limit_bal
457: , p_eff_start_date=> p_ele_eff_start_date
458: , p_eff_end_date => p_ele_eff_end_date);
459:
460: hr_utility.set_location('pyusddwp.ins_deduction_template',70);
461:
462:
463: END IF; -- AT Component = 'Y'
464:

Line 468: hr_utility.set_location('pyusddwp.ins_deduction_template',90);

464:
465: ELSE
466: -- Not a 'PRE-Tax' Deduction element, do standard processing
467:
468: hr_utility.set_location('pyusddwp.ins_deduction_template',90);
469:
470: l_ele_id:=
471: hr_user_init_dedn.ins_deduction_template (
472: p_ele_name => p_ele_name,

Line 498: hr_utility.set_location('pyusddwp.ins_deduction_template',100);

494: p_ele_eff_end_date => p_ele_eff_end_date,
495: p_bg_id => p_bg_id,
496: p_termination_rule => p_termination_rule);
497:
498: hr_utility.set_location('pyusddwp.ins_deduction_template',100);
499:
500: END IF ; -- Classification = 'Pre-tax'
501:
502: --hr_utility.trace_off;

Line 502: --hr_utility.trace_off;

498: hr_utility.set_location('pyusddwp.ins_deduction_template',100);
499:
500: END IF ; -- Classification = 'Pre-tax'
501:
502: --hr_utility.trace_off;
503: hr_utility.set_location('pyusddwp.ins_deduction_template',110);
504:
505: RETURN l_ele_id;
506:

Line 503: hr_utility.set_location('pyusddwp.ins_deduction_template',110);

499:
500: END IF ; -- Classification = 'Pre-tax'
501:
502: --hr_utility.trace_off;
503: hr_utility.set_location('pyusddwp.ins_deduction_template',110);
504:
505: RETURN l_ele_id;
506:
507: end ins_deduction_template;