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.

[Home] [Help]

APPS.HR_USER_DEDN_DRV dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 391: --hr_utility.trace_on;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 501: --hr_utility.trace_off;

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

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

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