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

Line 125: hr_utility.trace('Entered standard_hours_worked');

121: v_curr_date := NULL;
122: v_curr_day :=NULL;
123:
124: -- Check for valid range
125: hr_utility.trace('Entered standard_hours_worked');
126:
127: IF p_range_start > p_range_end THEN
128: hr_utility.trace('p_range_start greater than p_range_end');
129: RETURN v_total_hours;

Line 128: hr_utility.trace('p_range_start greater than p_range_end');

124: -- Check for valid range
125: hr_utility.trace('Entered standard_hours_worked');
126:
127: IF p_range_start > p_range_end THEN
128: hr_utility.trace('p_range_start greater than p_range_end');
129: RETURN v_total_hours;
130: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
131: -- hr_utility.raise_error;
132: END IF;

Line 130: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');

126:
127: IF p_range_start > p_range_end THEN
128: hr_utility.trace('p_range_start greater than p_range_end');
129: RETURN v_total_hours;
130: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
131: -- hr_utility.raise_error;
132: END IF;
133: --
134:

Line 131: -- hr_utility.raise_error;

127: IF p_range_start > p_range_end THEN
128: hr_utility.trace('p_range_start greater than p_range_end');
129: RETURN v_total_hours;
130: -- hr_utility.set_message(801,'PAY_xxxx_INVALID_DATE_RANGE');
131: -- hr_utility.raise_error;
132: END IF;
133: --
134:
135: IF UPPER(p_std_freq) = 'WEEK' THEN

Line 136: hr_utility.trace('p_std_freq = WEEK ');

132: END IF;
133: --
134:
135: IF UPPER(p_std_freq) = 'WEEK' THEN
136: hr_utility.trace('p_std_freq = WEEK ');
137:
138: v_wrkday_hours := p_std_hrs / c_wkdays_per_week;
139:
140: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));

Line 140: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));

136: hr_utility.trace('p_std_freq = WEEK ');
137:
138: v_wrkday_hours := p_std_hrs / c_wkdays_per_week;
139:
140: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
141: hr_utility.trace('c_wkdays_per_week ='||to_number(c_wkdays_per_week));
142: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
143:
144: ELSIF UPPER(p_std_freq) = 'MONTH' THEN

Line 141: hr_utility.trace('c_wkdays_per_week ='||to_number(c_wkdays_per_week));

137:
138: v_wrkday_hours := p_std_hrs / c_wkdays_per_week;
139:
140: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
141: hr_utility.trace('c_wkdays_per_week ='||to_number(c_wkdays_per_week));
142: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
143:
144: ELSIF UPPER(p_std_freq) = 'MONTH' THEN
145:

Line 142: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));

138: v_wrkday_hours := p_std_hrs / c_wkdays_per_week;
139:
140: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
141: hr_utility.trace('c_wkdays_per_week ='||to_number(c_wkdays_per_week));
142: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
143:
144: ELSIF UPPER(p_std_freq) = 'MONTH' THEN
145:
146: hr_utility.trace('p_std_freq = MONTH ');

Line 146: hr_utility.trace('p_std_freq = MONTH ');

142: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
143:
144: ELSIF UPPER(p_std_freq) = 'MONTH' THEN
145:
146: hr_utility.trace('p_std_freq = MONTH ');
147:
148: v_wrkday_hours := p_std_hrs / c_wkdays_per_month;
149:
150:

Line 151: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));

147:
148: v_wrkday_hours := p_std_hrs / c_wkdays_per_month;
149:
150:
151: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
152: hr_utility.trace('c_wkdays_per_month ='||to_number(c_wkdays_per_month));
153: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
154:
155: ELSIF UPPER(p_std_freq) = 'YEAR' THEN

Line 152: hr_utility.trace('c_wkdays_per_month ='||to_number(c_wkdays_per_month));

148: v_wrkday_hours := p_std_hrs / c_wkdays_per_month;
149:
150:
151: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
152: hr_utility.trace('c_wkdays_per_month ='||to_number(c_wkdays_per_month));
153: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
154:
155: ELSIF UPPER(p_std_freq) = 'YEAR' THEN
156:

Line 153: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));

149:
150:
151: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
152: hr_utility.trace('c_wkdays_per_month ='||to_number(c_wkdays_per_month));
153: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
154:
155: ELSIF UPPER(p_std_freq) = 'YEAR' THEN
156:
157: hr_utility.trace('p_std_freq = YEAR ');

Line 157: hr_utility.trace('p_std_freq = YEAR ');

153: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
154:
155: ELSIF UPPER(p_std_freq) = 'YEAR' THEN
156:
157: hr_utility.trace('p_std_freq = YEAR ');
158: v_wrkday_hours := p_std_hrs / c_wkdays_per_year;
159:
160: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
161: hr_utility.trace('c_wkdays_per_year ='||to_number(c_wkdays_per_year));

Line 160: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));

156:
157: hr_utility.trace('p_std_freq = YEAR ');
158: v_wrkday_hours := p_std_hrs / c_wkdays_per_year;
159:
160: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
161: hr_utility.trace('c_wkdays_per_year ='||to_number(c_wkdays_per_year));
162: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
163:
164: ELSE

Line 161: hr_utility.trace('c_wkdays_per_year ='||to_number(c_wkdays_per_year));

157: hr_utility.trace('p_std_freq = YEAR ');
158: v_wrkday_hours := p_std_hrs / c_wkdays_per_year;
159:
160: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
161: hr_utility.trace('c_wkdays_per_year ='||to_number(c_wkdays_per_year));
162: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
163:
164: ELSE
165: hr_utility.trace('p_std_freq in ELSE ');

Line 162: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));

158: v_wrkday_hours := p_std_hrs / c_wkdays_per_year;
159:
160: hr_utility.trace('p_std_hrs ='||to_number(p_std_hrs));
161: hr_utility.trace('c_wkdays_per_year ='||to_number(c_wkdays_per_year));
162: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
163:
164: ELSE
165: hr_utility.trace('p_std_freq in ELSE ');
166: v_wrkday_hours := p_std_hrs;

Line 165: hr_utility.trace('p_std_freq in ELSE ');

161: hr_utility.trace('c_wkdays_per_year ='||to_number(c_wkdays_per_year));
162: hr_utility.trace('v_wrkday_hours ='||to_number(v_wrkday_hours));
163:
164: ELSE
165: hr_utility.trace('p_std_freq in ELSE ');
166: v_wrkday_hours := p_std_hrs;
167: END IF;
168:
169: v_curr_date := p_range_start;

Line 171: hr_utility.trace('v_curr_date is range start'||to_char(v_curr_date));

167: END IF;
168:
169: v_curr_date := p_range_start;
170:
171: hr_utility.trace('v_curr_date is range start'||to_char(v_curr_date));
172:
173:
174: LOOP
175:

Line 184: hr_utility.trace(' v_day_no = '||to_char(v_day_no));

180:
181:
182: v_total_hours := nvl(v_total_hours,0) + v_wrkday_hours;
183:
184: hr_utility.trace(' v_day_no = '||to_char(v_day_no));
185: hr_utility.trace(' v_total_hours = '||to_char(v_total_hours));
186: END IF;
187:
188: v_curr_date := v_curr_date + 1;

Line 185: hr_utility.trace(' v_total_hours = '||to_char(v_total_hours));

181:
182: v_total_hours := nvl(v_total_hours,0) + v_wrkday_hours;
183:
184: hr_utility.trace(' v_day_no = '||to_char(v_day_no));
185: hr_utility.trace(' v_total_hours = '||to_char(v_total_hours));
186: END IF;
187:
188: v_curr_date := v_curr_date + 1;
189: EXIT WHEN v_curr_date > p_range_end;

Line 191: hr_utility.trace(' Final v_total_hours = '||to_char(v_total_hours));

187:
188: v_curr_date := v_curr_date + 1;
189: EXIT WHEN v_curr_date > p_range_end;
190: END LOOP;
191: hr_utility.trace(' Final v_total_hours = '||to_char(v_total_hours));
192: hr_utility.trace(' Leaving standard_hours_worked' );
193: --
194: RETURN v_total_hours;
195: --

Line 192: hr_utility.trace(' Leaving standard_hours_worked' );

188: v_curr_date := v_curr_date + 1;
189: EXIT WHEN v_curr_date > p_range_end;
190: END LOOP;
191: hr_utility.trace(' Final v_total_hours = '||to_char(v_total_hours));
192: hr_utility.trace(' Leaving standard_hours_worked' );
193: --
194: RETURN v_total_hours;
195: --
196: END standard_hours_worked;

Line 277: hr_utility.trace(' Entered Get_Annualizing_Factor ');

273: -- Selecting "count" because we want to continue processing even if
274: -- the from_freq is not a pay basis.
275: --
276:
277: hr_utility.trace(' Entered Get_Annualizing_Factor ');
278:
279: BEGIN -- Is Freq pay basis?
280:
281: --

Line 286: hr_utility.trace(' Getting lookup code for lookup_type = PAY_BASIS');

282: -- Decode pay basis and set v_annualizing_factor accordingly.
283: -- PAY_BASIS "Meaning" is passed from FF !
284: --
285:
286: hr_utility.trace(' Getting lookup code for lookup_type = PAY_BASIS');
287: hr_utility.trace(' p_freq = '||p_freq);
288:
289: SELECT lookup_code
290: INTO v_pay_basis

Line 287: hr_utility.trace(' p_freq = '||p_freq);

283: -- PAY_BASIS "Meaning" is passed from FF !
284: --
285:
286: hr_utility.trace(' Getting lookup code for lookup_type = PAY_BASIS');
287: hr_utility.trace(' p_freq = '||p_freq);
288:
289: SELECT lookup_code
290: INTO v_pay_basis
291: FROM hr_lookups lkp

Line 296: hr_utility.trace(' Lookup_code ie v_pay_basis ='||v_pay_basis);

292: WHERE lkp.application_id = 800
293: AND lkp.lookup_type = 'PAY_BASIS'
294: AND lkp.meaning = p_freq;
295:
296: hr_utility.trace(' Lookup_code ie v_pay_basis ='||v_pay_basis);
297:
298: v_use_pay_basis := 1;
299:
300: IF v_pay_basis = 'MONTHLY' THEN

Line 302: hr_utility.trace(' Entered for MONTHLY v_pay_basis');

298: v_use_pay_basis := 1;
299:
300: IF v_pay_basis = 'MONTHLY' THEN
301:
302: hr_utility.trace(' Entered for MONTHLY v_pay_basis');
303:
304: v_annualizing_factor := 12;
305:
306: hr_utility.trace(' v_annualizing_factor = 12 ');

Line 306: hr_utility.trace(' v_annualizing_factor = 12 ');

302: hr_utility.trace(' Entered for MONTHLY v_pay_basis');
303:
304: v_annualizing_factor := 12;
305:
306: hr_utility.trace(' v_annualizing_factor = 12 ');
307:
308: ELSIF v_pay_basis = 'HOURLY' THEN
309:
310: hr_utility.trace(' Entered for HOURLY v_pay_basis');

Line 310: hr_utility.trace(' Entered for HOURLY v_pay_basis');

306: hr_utility.trace(' v_annualizing_factor = 12 ');
307:
308: ELSIF v_pay_basis = 'HOURLY' THEN
309:
310: hr_utility.trace(' Entered for HOURLY v_pay_basis');
311:
312: IF p_period_start_date IS NOT NULL THEN
313:
314: hr_utility.trace(' p_period_start_date IS NOT NULL ' ||

Line 314: hr_utility.trace(' p_period_start_date IS NOT NULL ' ||

310: hr_utility.trace(' Entered for HOURLY v_pay_basis');
311:
312: IF p_period_start_date IS NOT NULL THEN
313:
314: hr_utility.trace(' p_period_start_date IS NOT NULL ' ||
315: ' v_period_hours=T');
316:
317: v_range_start := p_period_start_date;
318: v_range_end := p_period_end_date;

Line 323: hr_utility.trace(' p_period_start_date IS NULL');

319: v_period_hours := TRUE;
320:
321: ELSE
322:
323: hr_utility.trace(' p_period_start_date IS NULL');
324:
325: v_range_start := sysdate;
326: v_range_end := sysdate + 6;
327: v_period_hours := FALSE;

Line 336: hr_utility.trace(' Hourly employee using work schedule');

332:
333: -- Hourly employee using work schedule.
334: -- Get work schedule name
335:
336: hr_utility.trace(' Hourly employee using work schedule');
337: hr_utility.trace(' Get work schedule name');
338:
339: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);
340:

Line 337: hr_utility.trace(' Get work schedule name');

333: -- Hourly employee using work schedule.
334: -- Get work schedule name
335:
336: hr_utility.trace(' Hourly employee using work schedule');
337: hr_utility.trace(' Get work schedule name');
338:
339: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);
340:
341: hr_utility.trace(' v_ws_id ='||to_number(v_ws_id));

Line 341: hr_utility.trace(' v_ws_id ='||to_number(v_ws_id));

337: hr_utility.trace(' Get work schedule name');
338:
339: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);
340:
341: hr_utility.trace(' v_ws_id ='||to_number(v_ws_id));
342:
343:
344: SELECT user_column_name
345: INTO v_work_sched_name

Line 351: hr_utility.trace(' v_work_sched_name ='||v_work_sched_name);

347: WHERE user_column_id = v_ws_id
348: AND NVL(business_group_id, p_bg) = p_bg
349: AND NVL(legislation_code,'MX') = 'MX';
350:
351: hr_utility.trace(' v_work_sched_name ='||v_work_sched_name);
352: hr_utility.trace(' Calling Work_Sch_Total_Hours_or_Days');
353:
354: v_hrs_per_range :=
355: Work_Sch_Total_Hours_or_Days(p_bg,

Line 352: hr_utility.trace(' Calling Work_Sch_Total_Hours_or_Days');

348: AND NVL(business_group_id, p_bg) = p_bg
349: AND NVL(legislation_code,'MX') = 'MX';
350:
351: hr_utility.trace(' v_work_sched_name ='||v_work_sched_name);
352: hr_utility.trace(' Calling Work_Sch_Total_Hours_or_Days');
353:
354: v_hrs_per_range :=
355: Work_Sch_Total_Hours_or_Days(p_bg,
356: v_work_sched_name,

Line 362: hr_utility.trace(' Hourly emp using Standard Hours on asg');

358: v_range_end);
359:
360: ELSE-- Hourly emp using Standard Hours on asg.
361:
362: hr_utility.trace(' Hourly emp using Standard Hours on asg');
363: hr_utility.trace(' calling Standard_Hours_Worked');
364:
365: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,
366: v_range_start,

Line 363: hr_utility.trace(' calling Standard_Hours_Worked');

359:
360: ELSE-- Hourly emp using Standard Hours on asg.
361:
362: hr_utility.trace(' Hourly emp using Standard Hours on asg');
363: hr_utility.trace(' calling Standard_Hours_Worked');
364:
365: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,
366: v_range_start,
367: v_range_end,

Line 374: hr_utility.trace(' v_period_hours is TRUE');

370: END IF;
371:
372: IF v_period_hours THEN
373:
374: hr_utility.trace(' v_period_hours is TRUE');
375:
376: SELECT TPT.number_per_fiscal_year
377: INTO v_periods_per_fiscal_yr
378: FROM pay_payrolls_f PPF,

Line 398: hr_utility.trace(' v_pay_basis = PERIOD');

394: END IF;
395:
396: ELSIF v_pay_basis = 'PERIOD' THEN
397:
398: hr_utility.trace(' v_pay_basis = PERIOD');
399:
400: SELECT TPT.number_per_fiscal_year
401: INTO v_annualizing_factor
402: FROM pay_payrolls_f PRL,

Line 416: hr_utility.trace(' v_pay_basis = ANNUAL');

412:
413: ELSIF v_pay_basis = 'ANNUAL' THEN
414:
415:
416: hr_utility.trace(' v_pay_basis = ANNUAL');
417:
418: v_annualizing_factor := 1;
419:
420: ELSE

Line 425: hr_utility.trace(' Did not recognize pay basis');

421:
422: -- Did not recognize "pay basis", return -999 as annualizing factor.
423: -- Remember this for debugging when zeroes come out as results!!!
424:
425: hr_utility.trace(' Did not recognize pay basis');
426:
427: v_annualizing_factor := 0;
428:
429: RETURN v_annualizing_factor;

Line 437: hr_utility.trace(' When no data found' );

433: EXCEPTION
434:
435: WHEN NO_DATA_FOUND THEN
436:
437: hr_utility.trace(' When no data found' );
438: v_use_pay_basis := 0;
439:
440: END; /* SELECT LOOKUP CODE */
441:

Line 444: hr_utility.trace(' Not using pay basis as frequency');

440: END; /* SELECT LOOKUP CODE */
441:
442: IF v_use_pay_basis = 0 THEN
443:
444: hr_utility.trace(' Not using pay basis as frequency');
445:
446: -- Not using pay basis as frequency...
447:
448: IF (p_freq IS NULL) OR

Line 455: hr_utility.trace('Get annuallizing factor from period '||

451: THEN
452:
453: -- Get "annuallizing factor" from period type of the payroll.
454:
455: hr_utility.trace('Get annuallizing factor from period '||
456: 'type of the payroll');
457:
458: SELECT TPT.number_per_fiscal_year
459: INTO v_annualizing_factor

Line 470: hr_utility.trace('v_annualizing_factor ='||

466: AND PRL.effective_end_date
467: AND PRL.payroll_id = p_payroll
468: AND PRL.business_group_id + 0 = p_bg;
469:
470: hr_utility.trace('v_annualizing_factor ='||
471: to_number(v_annualizing_factor));
472:
473: ELSIF UPPER(p_freq) = 'DAILY' THEN
474:

Line 475: hr_utility.trace(' Daily Employee');

471: to_number(v_annualizing_factor));
472:
473: ELSIF UPPER(p_freq) = 'DAILY' THEN
474:
475: hr_utility.trace(' Daily Employee');
476:
477: v_annualizing_factor :=
478: pay_mx_utility.get_days_in_year(p_bg, p_txu_id, p_payroll);
479:

Line 483: hr_utility.trace(' Hourly Employee');

479:
480:
481: ELSIF UPPER(p_freq) = 'HOURLY' THEN -- Hourly employee...
482:
483: hr_utility.trace(' Hourly Employee');
484:
485: IF p_period_start_date IS NOT NULL THEN
486: v_range_start := p_period_start_date;
487: v_range_end := p_period_end_date;

Line 518: hr_utility.trace(' Hourly emp using Standard Hours on asg');

514: v_range_end);
515:
516: ELSE-- Hourly emp using Standard Hours on asg.
517:
518: hr_utility.trace(' Hourly emp using Standard Hours on asg');
519:
520: hr_utility.trace('calling Standard_Hours_Worked');
521:
522: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,

Line 520: hr_utility.trace('calling Standard_Hours_Worked');

516: ELSE-- Hourly emp using Standard Hours on asg.
517:
518: hr_utility.trace(' Hourly emp using Standard Hours on asg');
519:
520: hr_utility.trace('calling Standard_Hours_Worked');
521:
522: v_hrs_per_range := Standard_Hours_Worked(p_asg_std_hrs,
523: v_range_start,
524: v_range_end,

Line 527: hr_utility.trace('returned Standard_Hours_Worked');

523: v_range_start,
524: v_range_end,
525: p_asg_std_freq);
526:
527: hr_utility.trace('returned Standard_Hours_Worked');
528: END IF;
529:
530:
531: IF v_period_hours THEN

Line 533: hr_utility.trace('v_period_hours = TRUE');

529:
530:
531: IF v_period_hours THEN
532:
533: hr_utility.trace('v_period_hours = TRUE');
534:
535: SELECT TPT.number_per_fiscal_year
536: INTO v_periods_per_fiscal_yr
537: FROM pay_payrolls_f ppf,

Line 549: hr_utility.trace('v_hrs_per_range ='||

545:
546: v_annualizing_factor :=
547: v_hrs_per_range * v_periods_per_fiscal_yr;
548:
549: hr_utility.trace('v_hrs_per_range ='||
550: to_number(v_hrs_per_range));
551: hr_utility.trace('v_periods_per_fiscal_yr ='||
552: to_number(v_periods_per_fiscal_yr));
553: hr_utility.trace('v_annualizing_factor ='||

Line 551: hr_utility.trace('v_periods_per_fiscal_yr ='||

547: v_hrs_per_range * v_periods_per_fiscal_yr;
548:
549: hr_utility.trace('v_hrs_per_range ='||
550: to_number(v_hrs_per_range));
551: hr_utility.trace('v_periods_per_fiscal_yr ='||
552: to_number(v_periods_per_fiscal_yr));
553: hr_utility.trace('v_annualizing_factor ='||
554: to_number(v_annualizing_factor));
555:

Line 553: hr_utility.trace('v_annualizing_factor ='||

549: hr_utility.trace('v_hrs_per_range ='||
550: to_number(v_hrs_per_range));
551: hr_utility.trace('v_periods_per_fiscal_yr ='||
552: to_number(v_periods_per_fiscal_yr));
553: hr_utility.trace('v_annualizing_factor ='||
554: to_number(v_annualizing_factor));
555:
556: ELSE
557:

Line 558: hr_utility.trace('v_period_hours = FALSE');

554: to_number(v_annualizing_factor));
555:
556: ELSE
557:
558: hr_utility.trace('v_period_hours = FALSE');
559:
560: v_annualizing_factor := v_hrs_per_range * c_weeks_per_year;
561:
562: hr_utility.trace('v_hrs_per_range ='||

Line 562: hr_utility.trace('v_hrs_per_range ='||

558: hr_utility.trace('v_period_hours = FALSE');
559:
560: v_annualizing_factor := v_hrs_per_range * c_weeks_per_year;
561:
562: hr_utility.trace('v_hrs_per_range ='||
563: to_number(v_hrs_per_range));
564: hr_utility.trace('c_weeks_per_year ='||
565: to_number(c_weeks_per_year));
566: hr_utility.trace('v_annualizing_factor ='||

Line 564: hr_utility.trace('c_weeks_per_year ='||

560: v_annualizing_factor := v_hrs_per_range * c_weeks_per_year;
561:
562: hr_utility.trace('v_hrs_per_range ='||
563: to_number(v_hrs_per_range));
564: hr_utility.trace('c_weeks_per_year ='||
565: to_number(c_weeks_per_year));
566: hr_utility.trace('v_annualizing_factor ='||
567: to_number(v_annualizing_factor));
568:

Line 566: hr_utility.trace('v_annualizing_factor ='||

562: hr_utility.trace('v_hrs_per_range ='||
563: to_number(v_hrs_per_range));
564: hr_utility.trace('c_weeks_per_year ='||
565: to_number(c_weeks_per_year));
566: hr_utility.trace('v_annualizing_factor ='||
567: to_number(v_annualizing_factor));
568:
569: END IF;
570:

Line 575: hr_utility.trace('Not hourly - an actual time period type');

571: ELSE
572:
573: -- Not hourly, an actual time period type!
574:
575: hr_utility.trace('Not hourly - an actual time period type');
576:
577: BEGIN
578:
579: hr_utility.trace(' selecting from per_time_period_types');

Line 579: hr_utility.trace(' selecting from per_time_period_types');

575: hr_utility.trace('Not hourly - an actual time period type');
576:
577: BEGIN
578:
579: hr_utility.trace(' selecting from per_time_period_types');
580:
581: SELECT PT.number_per_fiscal_year
582: INTO v_annualizing_factor
583: FROM per_time_period_types PT

Line 586: hr_utility.trace('v_annualizing_factor ='||

582: INTO v_annualizing_factor
583: FROM per_time_period_types PT
584: WHERE UPPER(PT.period_type) = UPPER(p_freq);
585:
586: hr_utility.trace('v_annualizing_factor ='||
587: to_number(v_annualizing_factor));
588:
589: EXCEPTION WHEN no_data_found THEN
590:

Line 598: hr_utility.trace(' p_freq = DAY');

594: -- 'Day' or 'Month' which do not map to a time period type.
595: -- So we'll do these by hand.
596:
597: IF UPPER(p_freq) = 'DAY' THEN
598: hr_utility.trace(' p_freq = DAY');
599: v_annualizing_factor := c_days_per_year;
600: ELSIF UPPER(p_freq) = 'MONTH' THEN
601: v_annualizing_factor := c_months_per_year;
602: hr_utility.trace(' p_freq = MONTH');

Line 602: hr_utility.trace(' p_freq = MONTH');

598: hr_utility.trace(' p_freq = DAY');
599: v_annualizing_factor := c_days_per_year;
600: ELSIF UPPER(p_freq) = 'MONTH' THEN
601: v_annualizing_factor := c_months_per_year;
602: hr_utility.trace(' p_freq = MONTH');
603: END IF;
604:
605: END;
606:

Line 612: hr_utility.trace(' Getting out of Get_Annualizing_Factor for '||

608:
609: END IF; -- (v_use_pay_basis = 0)
610:
611:
612: hr_utility.trace(' Getting out of Get_Annualizing_Factor for '||
613: v_pay_basis);
614: RETURN v_annualizing_factor;
615:
616: END Get_Annualizing_Factor;

Line 623: --hr_utility.trace_on(null,'UDFS');

619: BEGIN -- Convert Figure
620:
621: --begin_convert_period_type
622:
623: --hr_utility.trace_on(null,'UDFS');
624:
625: hr_utility.trace('UDFS Entered Convert_Period_Type');
626:
627: hr_utility.trace(' p_bus_grp_id: '|| p_bus_grp_id);

Line 625: hr_utility.trace('UDFS Entered Convert_Period_Type');

621: --begin_convert_period_type
622:
623: --hr_utility.trace_on(null,'UDFS');
624:
625: hr_utility.trace('UDFS Entered Convert_Period_Type');
626:
627: hr_utility.trace(' p_bus_grp_id: '|| p_bus_grp_id);
628: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
629: hr_utility.trace(' p_tax_unit_id: '||p_tax_unit_id);

Line 627: hr_utility.trace(' p_bus_grp_id: '|| p_bus_grp_id);

623: --hr_utility.trace_on(null,'UDFS');
624:
625: hr_utility.trace('UDFS Entered Convert_Period_Type');
626:
627: hr_utility.trace(' p_bus_grp_id: '|| p_bus_grp_id);
628: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
629: hr_utility.trace(' p_tax_unit_id: '||p_tax_unit_id);
630: hr_utility.trace(' p_asst_work_schedule: '||p_asst_work_schedule);
631: hr_utility.trace(' p_asst_std_hours: '||p_asst_std_hours);

Line 628: hr_utility.trace(' p_payroll_id: '||p_payroll_id);

624:
625: hr_utility.trace('UDFS Entered Convert_Period_Type');
626:
627: hr_utility.trace(' p_bus_grp_id: '|| p_bus_grp_id);
628: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
629: hr_utility.trace(' p_tax_unit_id: '||p_tax_unit_id);
630: hr_utility.trace(' p_asst_work_schedule: '||p_asst_work_schedule);
631: hr_utility.trace(' p_asst_std_hours: '||p_asst_std_hours);
632: hr_utility.trace(' p_figure: '||p_figure);

Line 629: hr_utility.trace(' p_tax_unit_id: '||p_tax_unit_id);

625: hr_utility.trace('UDFS Entered Convert_Period_Type');
626:
627: hr_utility.trace(' p_bus_grp_id: '|| p_bus_grp_id);
628: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
629: hr_utility.trace(' p_tax_unit_id: '||p_tax_unit_id);
630: hr_utility.trace(' p_asst_work_schedule: '||p_asst_work_schedule);
631: hr_utility.trace(' p_asst_std_hours: '||p_asst_std_hours);
632: hr_utility.trace(' p_figure: '||p_figure);
633: hr_utility.trace(' p_from_freq : '||p_from_freq);

Line 630: hr_utility.trace(' p_asst_work_schedule: '||p_asst_work_schedule);

626:
627: hr_utility.trace(' p_bus_grp_id: '|| p_bus_grp_id);
628: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
629: hr_utility.trace(' p_tax_unit_id: '||p_tax_unit_id);
630: hr_utility.trace(' p_asst_work_schedule: '||p_asst_work_schedule);
631: hr_utility.trace(' p_asst_std_hours: '||p_asst_std_hours);
632: hr_utility.trace(' p_figure: '||p_figure);
633: hr_utility.trace(' p_from_freq : '||p_from_freq);
634: hr_utility.trace(' p_to_freq: '||p_to_freq);

Line 631: hr_utility.trace(' p_asst_std_hours: '||p_asst_std_hours);

627: hr_utility.trace(' p_bus_grp_id: '|| p_bus_grp_id);
628: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
629: hr_utility.trace(' p_tax_unit_id: '||p_tax_unit_id);
630: hr_utility.trace(' p_asst_work_schedule: '||p_asst_work_schedule);
631: hr_utility.trace(' p_asst_std_hours: '||p_asst_std_hours);
632: hr_utility.trace(' p_figure: '||p_figure);
633: hr_utility.trace(' p_from_freq : '||p_from_freq);
634: hr_utility.trace(' p_to_freq: '||p_to_freq);
635: hr_utility.trace(' p_period_start_date: '||p_period_start_date);

Line 632: hr_utility.trace(' p_figure: '||p_figure);

628: hr_utility.trace(' p_payroll_id: '||p_payroll_id);
629: hr_utility.trace(' p_tax_unit_id: '||p_tax_unit_id);
630: hr_utility.trace(' p_asst_work_schedule: '||p_asst_work_schedule);
631: hr_utility.trace(' p_asst_std_hours: '||p_asst_std_hours);
632: hr_utility.trace(' p_figure: '||p_figure);
633: hr_utility.trace(' p_from_freq : '||p_from_freq);
634: hr_utility.trace(' p_to_freq: '||p_to_freq);
635: hr_utility.trace(' p_period_start_date: '||p_period_start_date);
636:

Line 633: hr_utility.trace(' p_from_freq : '||p_from_freq);

629: hr_utility.trace(' p_tax_unit_id: '||p_tax_unit_id);
630: hr_utility.trace(' p_asst_work_schedule: '||p_asst_work_schedule);
631: hr_utility.trace(' p_asst_std_hours: '||p_asst_std_hours);
632: hr_utility.trace(' p_figure: '||p_figure);
633: hr_utility.trace(' p_from_freq : '||p_from_freq);
634: hr_utility.trace(' p_to_freq: '||p_to_freq);
635: hr_utility.trace(' p_period_start_date: '||p_period_start_date);
636:
637: hr_utility.trace(' p_period_end_date: '||p_period_end_date);

Line 634: hr_utility.trace(' p_to_freq: '||p_to_freq);

630: hr_utility.trace(' p_asst_work_schedule: '||p_asst_work_schedule);
631: hr_utility.trace(' p_asst_std_hours: '||p_asst_std_hours);
632: hr_utility.trace(' p_figure: '||p_figure);
633: hr_utility.trace(' p_from_freq : '||p_from_freq);
634: hr_utility.trace(' p_to_freq: '||p_to_freq);
635: hr_utility.trace(' p_period_start_date: '||p_period_start_date);
636:
637: hr_utility.trace(' p_period_end_date: '||p_period_end_date);
638: hr_utility.trace(' p_asst_std_freq: '||p_asst_std_freq);

Line 635: hr_utility.trace(' p_period_start_date: '||p_period_start_date);

631: hr_utility.trace(' p_asst_std_hours: '||p_asst_std_hours);
632: hr_utility.trace(' p_figure: '||p_figure);
633: hr_utility.trace(' p_from_freq : '||p_from_freq);
634: hr_utility.trace(' p_to_freq: '||p_to_freq);
635: hr_utility.trace(' p_period_start_date: '||p_period_start_date);
636:
637: hr_utility.trace(' p_period_end_date: '||p_period_end_date);
638: hr_utility.trace(' p_asst_std_freq: '||p_asst_std_freq);
639:

Line 637: hr_utility.trace(' p_period_end_date: '||p_period_end_date);

633: hr_utility.trace(' p_from_freq : '||p_from_freq);
634: hr_utility.trace(' p_to_freq: '||p_to_freq);
635: hr_utility.trace(' p_period_start_date: '||p_period_start_date);
636:
637: hr_utility.trace(' p_period_end_date: '||p_period_end_date);
638: hr_utility.trace(' p_asst_std_freq: '||p_asst_std_freq);
639:
640: --
641: -- If From_Freq and To_Freq are the same, then we're done.

Line 638: hr_utility.trace(' p_asst_std_freq: '||p_asst_std_freq);

634: hr_utility.trace(' p_to_freq: '||p_to_freq);
635: hr_utility.trace(' p_period_start_date: '||p_period_start_date);
636:
637: hr_utility.trace(' p_period_end_date: '||p_period_end_date);
638: hr_utility.trace(' p_asst_std_freq: '||p_asst_std_freq);
639:
640: --
641: -- If From_Freq and To_Freq are the same, then we're done.
642: --

Line 651: hr_utility.trace('Calling Get_Annualizing_Factor for FROM case');

647: RETURN p_figure;
648:
649: END IF;
650:
651: hr_utility.trace('Calling Get_Annualizing_Factor for FROM case');
652:
653: v_from_annualizing_factor := Get_Annualizing_Factor(
654: p_bg => p_bus_grp_id,
655: p_payroll => p_payroll_id,

Line 662: hr_utility.trace('Calling Get_Annualizing_Factor for TO case');

658: p_asg_work_sched => p_asst_work_schedule,
659: p_asg_std_hrs => p_asst_std_hours,
660: p_asg_std_freq => p_asst_std_freq);
661:
662: hr_utility.trace('Calling Get_Annualizing_Factor for TO case');
663:
664: v_to_annualizing_factor := Get_Annualizing_Factor(
665: p_bg => p_bus_grp_id,
666: p_payroll => p_payroll_id,

Line 677: hr_utility.trace('v_from_annualizing_factor ='||

673: --
674: -- Annualize "Figure" and convert to To_Freq.
675: --
676:
677: hr_utility.trace('v_from_annualizing_factor ='||
678: to_char(v_from_annualizing_factor));
679: hr_utility.trace('v_to_annualizing_factor ='||
680: to_char(v_to_annualizing_factor));
681:

Line 679: hr_utility.trace('v_to_annualizing_factor ='||

675: --
676:
677: hr_utility.trace('v_from_annualizing_factor ='||
678: to_char(v_from_annualizing_factor));
679: hr_utility.trace('v_to_annualizing_factor ='||
680: to_char(v_to_annualizing_factor));
681:
682: IF v_to_annualizing_factor = 0 OR
683: v_to_annualizing_factor = -999 OR

Line 687: hr_utility.trace(' v_to_ann =0 or -999 or v_from = -999');

683: v_to_annualizing_factor = -999 OR
684: v_from_annualizing_factor = -999
685: THEN
686:
687: hr_utility.trace(' v_to_ann =0 or -999 or v_from = -999');
688:
689: v_converted_figure := 0;
690:
691: ELSE

Line 693: hr_utility.trace(' v_to_ann NOT 0 or -999 or v_from = -999');

689: v_converted_figure := 0;
690:
691: ELSE
692:
693: hr_utility.trace(' v_to_ann NOT 0 or -999 or v_from = -999');
694:
695: hr_utility.trace('p_figure Monthly Salary = '||p_figure);
696: hr_utility.trace('v_from_annualizing_factor = '||
697: v_from_annualizing_factor);

Line 695: hr_utility.trace('p_figure Monthly Salary = '||p_figure);

691: ELSE
692:
693: hr_utility.trace(' v_to_ann NOT 0 or -999 or v_from = -999');
694:
695: hr_utility.trace('p_figure Monthly Salary = '||p_figure);
696: hr_utility.trace('v_from_annualizing_factor = '||
697: v_from_annualizing_factor);
698: hr_utility.trace('v_to_annualizing_factor = '||
699: v_to_annualizing_factor);

Line 696: hr_utility.trace('v_from_annualizing_factor = '||

692:
693: hr_utility.trace(' v_to_ann NOT 0 or -999 or v_from = -999');
694:
695: hr_utility.trace('p_figure Monthly Salary = '||p_figure);
696: hr_utility.trace('v_from_annualizing_factor = '||
697: v_from_annualizing_factor);
698: hr_utility.trace('v_to_annualizing_factor = '||
699: v_to_annualizing_factor);
700:

Line 698: hr_utility.trace('v_to_annualizing_factor = '||

694:
695: hr_utility.trace('p_figure Monthly Salary = '||p_figure);
696: hr_utility.trace('v_from_annualizing_factor = '||
697: v_from_annualizing_factor);
698: hr_utility.trace('v_to_annualizing_factor = '||
699: v_to_annualizing_factor);
700:
701: v_converted_figure :=
702: (p_figure * v_from_annualizing_factor) / v_to_annualizing_factor;

Line 704: hr_utility.trace('conv figure is monthly_sal * ann_from div by ann to');

700:
701: v_converted_figure :=
702: (p_figure * v_from_annualizing_factor) / v_to_annualizing_factor;
703:
704: hr_utility.trace('conv figure is monthly_sal * ann_from div by ann to');
705:
706: END IF;
707:
708:

Line 709: hr_utility.trace('UDFS v_converted_figure := '||v_converted_figure);

705:
706: END IF;
707:
708:
709: hr_utility.trace('UDFS v_converted_figure := '||v_converted_figure);
710:
711: --hr_utility.trace_off;
712:
713: RETURN v_converted_figure;

Line 711: --hr_utility.trace_off;

707:
708:
709: hr_utility.trace('UDFS v_converted_figure := '||v_converted_figure);
710:
711: --hr_utility.trace_off;
712:
713: RETURN v_converted_figure;
714:
715: END Convert_Period_Type;

Line 750: --hr_utility.trace_on(null,'UDFS');

746: v_day_no NUMBER;
747:
748: BEGIN -- Work_Sch_Total_Hours_or_Days
749:
750: --hr_utility.trace_on(null,'UDFS');
751: hr_utility.trace('p_bg_id '||p_bg_id);
752: hr_utility.trace('p_ws_name '||p_ws_name);
753: hr_utility.trace('p_range_start '||p_range_start);
754: hr_utility.trace('p_range_end '||p_range_end);

Line 751: hr_utility.trace('p_bg_id '||p_bg_id);

747:
748: BEGIN -- Work_Sch_Total_Hours_or_Days
749:
750: --hr_utility.trace_on(null,'UDFS');
751: hr_utility.trace('p_bg_id '||p_bg_id);
752: hr_utility.trace('p_ws_name '||p_ws_name);
753: hr_utility.trace('p_range_start '||p_range_start);
754: hr_utility.trace('p_range_end '||p_range_end);
755: hr_utility.trace('p_mode '||p_mode);

Line 752: hr_utility.trace('p_ws_name '||p_ws_name);

748: BEGIN -- Work_Sch_Total_Hours_or_Days
749:
750: --hr_utility.trace_on(null,'UDFS');
751: hr_utility.trace('p_bg_id '||p_bg_id);
752: hr_utility.trace('p_ws_name '||p_ws_name);
753: hr_utility.trace('p_range_start '||p_range_start);
754: hr_utility.trace('p_range_end '||p_range_end);
755: hr_utility.trace('p_mode '||p_mode);
756:

Line 753: hr_utility.trace('p_range_start '||p_range_start);

749:
750: --hr_utility.trace_on(null,'UDFS');
751: hr_utility.trace('p_bg_id '||p_bg_id);
752: hr_utility.trace('p_ws_name '||p_ws_name);
753: hr_utility.trace('p_range_start '||p_range_start);
754: hr_utility.trace('p_range_end '||p_range_end);
755: hr_utility.trace('p_mode '||p_mode);
756:
757: /* Init */

Line 754: hr_utility.trace('p_range_end '||p_range_end);

750: --hr_utility.trace_on(null,'UDFS');
751: hr_utility.trace('p_bg_id '||p_bg_id);
752: hr_utility.trace('p_ws_name '||p_ws_name);
753: hr_utility.trace('p_range_start '||p_range_start);
754: hr_utility.trace('p_range_end '||p_range_end);
755: hr_utility.trace('p_mode '||p_mode);
756:
757: /* Init */
758:

Line 755: hr_utility.trace('p_mode '||p_mode);

751: hr_utility.trace('p_bg_id '||p_bg_id);
752: hr_utility.trace('p_ws_name '||p_ws_name);
753: hr_utility.trace('p_range_start '||p_range_start);
754: hr_utility.trace('p_range_end '||p_range_end);
755: hr_utility.trace('p_mode '||p_mode);
756:
757: /* Init */
758:
759: v_total_units := 0;

Line 892: hr_utility.trace('v_day_no '||v_day_no);

888: END IF;
889:
890: v_total_units := v_total_units + v_unit;
891:
892: hr_utility.trace('v_day_no '||v_day_no);
893: hr_utility.trace('v_unit '||v_unit);
894: hr_utility.trace('v_total_units '||v_total_units);
895:
896: v_curr_date := v_curr_date + 1;

Line 893: hr_utility.trace('v_unit '||v_unit);

889:
890: v_total_units := v_total_units + v_unit;
891:
892: hr_utility.trace('v_day_no '||v_day_no);
893: hr_utility.trace('v_unit '||v_unit);
894: hr_utility.trace('v_total_units '||v_total_units);
895:
896: v_curr_date := v_curr_date + 1;
897:

Line 894: hr_utility.trace('v_total_units '||v_total_units);

890: v_total_units := v_total_units + v_unit;
891:
892: hr_utility.trace('v_day_no '||v_day_no);
893: hr_utility.trace('v_unit '||v_unit);
894: hr_utility.trace('v_total_units '||v_total_units);
895:
896: v_curr_date := v_curr_date + 1;
897:
898: --

Line 909: --hr_utility.trace_off;

905: END LOOP;
906:
907: --
908:
909: --hr_utility.trace_off;
910:
911: RETURN v_total_units;
912:
913: --

Line 1079: hr_utility.raise_error;

1075: RETURN rn_rate;
1076:
1077: EXCEPTION WHEN OTHERS
1078: THEN
1079: hr_utility.raise_error;
1080: RETURN rn_rate;
1081: END get_fixed_idw;
1082:
1083: BEGIN

Line 1124: hr_utility.trace('Get IDW Calc Method ');

1120: --
1121: -- IDW Factor Table Method Modification
1122: --
1123: -- Get the idw calc method
1124: hr_utility.trace('Get IDW Calc Method ');
1125: hr_utility.trace('p_tax_unit_id ='||to_char(p_tax_unit_id));
1126: hr_utility.trace('p_effective_date ='||to_char(p_effective_date));
1127:
1128: lv_idw_calc_method := 'A';

Line 1125: hr_utility.trace('p_tax_unit_id ='||to_char(p_tax_unit_id));

1121: -- IDW Factor Table Method Modification
1122: --
1123: -- Get the idw calc method
1124: hr_utility.trace('Get IDW Calc Method ');
1125: hr_utility.trace('p_tax_unit_id ='||to_char(p_tax_unit_id));
1126: hr_utility.trace('p_effective_date ='||to_char(p_effective_date));
1127:
1128: lv_idw_calc_method := 'A';
1129: OPEN c_get_idw_calc_method (p_tax_unit_id,

Line 1126: hr_utility.trace('p_effective_date ='||to_char(p_effective_date));

1122: --
1123: -- Get the idw calc method
1124: hr_utility.trace('Get IDW Calc Method ');
1125: hr_utility.trace('p_tax_unit_id ='||to_char(p_tax_unit_id));
1126: hr_utility.trace('p_effective_date ='||to_char(p_effective_date));
1127:
1128: lv_idw_calc_method := 'A';
1129: OPEN c_get_idw_calc_method (p_tax_unit_id,
1130: p_effective_date );

Line 1134: hr_utility.trace('lv_idw_calc_method = '|| nvl(lv_idw_calc_method,'null'));

1130: p_effective_date );
1131: FETCH c_get_idw_calc_method INTO lv_idw_calc_method;
1132: CLOSE c_get_idw_calc_method;
1133:
1134: hr_utility.trace('lv_idw_calc_method = '|| nvl(lv_idw_calc_method,'null'));
1135:
1136: IF lv_idw_calc_method is null or lv_idw_calc_method ='A' then
1137:
1138: hr_utility.trace('calculating using Method A Earnings Method' );

Line 1138: hr_utility.trace('calculating using Method A Earnings Method' );

1134: hr_utility.trace('lv_idw_calc_method = '|| nvl(lv_idw_calc_method,'null'));
1135:
1136: IF lv_idw_calc_method is null or lv_idw_calc_method ='A' then
1137:
1138: hr_utility.trace('calculating using Method A Earnings Method' );
1139:
1140: -- calculate using Method A Earnings Method
1141: ln_rate := 0;
1142: ln_rate := get_mx_historic_rate (

Line 1152: hr_utility.trace('calculating using Method B Factor Table Method' );

1148: ,p_rate_code => 'MX_IDWF' );
1149:
1150: ELSIF lv_idw_calc_method ='B' then
1151:
1152: hr_utility.trace('calculating using Method B Factor Table Method' );
1153: hr_utility.trace('Get IDW Factor Table Name' );
1154: hr_utility.trace('assignment_id ='||to_char(asg_rec.assignment_id));
1155:
1156: -- calculate using Method B IDW Factor Method

Line 1153: hr_utility.trace('Get IDW Factor Table Name' );

1149:
1150: ELSIF lv_idw_calc_method ='B' then
1151:
1152: hr_utility.trace('calculating using Method B Factor Table Method' );
1153: hr_utility.trace('Get IDW Factor Table Name' );
1154: hr_utility.trace('assignment_id ='||to_char(asg_rec.assignment_id));
1155:
1156: -- calculate using Method B IDW Factor Method
1157: -- Get the IDW Factor table name entered in

Line 1154: hr_utility.trace('assignment_id ='||to_char(asg_rec.assignment_id));

1150: ELSIF lv_idw_calc_method ='B' then
1151:
1152: hr_utility.trace('calculating using Method B Factor Table Method' );
1153: hr_utility.trace('Get IDW Factor Table Name' );
1154: hr_utility.trace('assignment_id ='||to_char(asg_rec.assignment_id));
1155:
1156: -- calculate using Method B IDW Factor Method
1157: -- Get the IDW Factor table name entered in
1158: -- Integrated Daily Wage element

Line 1165: hr_utility.trace('lv_idw_factor_tab_name='||lv_idw_factor_tab_name);

1161: FETCH c_get_idw_factor_tab_name INTO lv_idw_lookup_code
1162: ,lv_idw_factor_tab_name;
1163: CLOSE c_get_idw_factor_tab_name ;
1164:
1165: hr_utility.trace('lv_idw_factor_tab_name='||lv_idw_factor_tab_name);
1166:
1167: IF lv_idw_factor_tab_name is null then
1168: --hr_utility.raise_error;
1169: RETURN rn_idw;

Line 1168: --hr_utility.raise_error;

1164:
1165: hr_utility.trace('lv_idw_factor_tab_name='||lv_idw_factor_tab_name);
1166:
1167: IF lv_idw_factor_tab_name is null then
1168: --hr_utility.raise_error;
1169: RETURN rn_idw;
1170: END IF;
1171:
1172: -- Check user table exists or not for lv_idw_factor_tab_name

Line 1208: hr_utility.trace('Get Seniority' );

1204:
1205: END IF;
1206:
1207: -- get the seniority
1208: hr_utility.trace('Get Seniority' );
1209:
1210: ln_seniority_years := hr_mx_utility.get_seniority_social_security(
1211: p_person_id => asg_rec.person_id
1212: ,p_effective_date => p_effective_date);

Line 1214: hr_utility.trace('ln_seniority_years = '||ln_seniority_years);

1210: ln_seniority_years := hr_mx_utility.get_seniority_social_security(
1211: p_person_id => asg_rec.person_id
1212: ,p_effective_date => p_effective_date);
1213:
1214: hr_utility.trace('ln_seniority_years = '||ln_seniority_years);
1215:
1216: -- get the FACTOR from the table
1217: -- by passing seniority years,
1218: -- Added fnd_number.canonical_to_number for bug 6815180

Line 1226: hr_utility.trace('ln_idw_factor = '||to_char(ln_idw_factor));

1222: p_col_name => 'Factor',
1223: p_row_value => ln_seniority_years,
1224: p_effective_date => p_effective_date));
1225:
1226: hr_utility.trace('ln_idw_factor = '||to_char(ln_idw_factor));
1227:
1228: hr_utility.trace('Get Base Pay ');
1229: hr_utility.trace('lv_contract_name =' || lv_contract_name );
1230:

Line 1228: hr_utility.trace('Get Base Pay ');

1224: p_effective_date => p_effective_date));
1225:
1226: hr_utility.trace('ln_idw_factor = '||to_char(ln_idw_factor));
1227:
1228: hr_utility.trace('Get Base Pay ');
1229: hr_utility.trace('lv_contract_name =' || lv_contract_name );
1230:
1231: -- Get the Base Pay using historic rates
1232: ln_basepay_rate := 0;

Line 1229: hr_utility.trace('lv_contract_name =' || lv_contract_name );

1225:
1226: hr_utility.trace('ln_idw_factor = '||to_char(ln_idw_factor));
1227:
1228: hr_utility.trace('Get Base Pay ');
1229: hr_utility.trace('lv_contract_name =' || lv_contract_name );
1230:
1231: -- Get the Base Pay using historic rates
1232: ln_basepay_rate := 0;
1233: ln_basepay_rate := get_daily_base_pay (

Line 1241: hr_utility.trace('ln_basepay_rate = '||to_char(ln_basepay_rate));

1237: ,p_payroll_id => asg_rec.payroll_id
1238: ,p_effective_date => p_effective_date);
1239:
1240:
1241: hr_utility.trace('ln_basepay_rate = '||to_char(ln_basepay_rate));
1242:
1243: -- Calculate the fixed portion of idw
1244: ln_rate := ln_basepay_rate * ln_idw_factor ;
1245:

Line 1246: hr_utility.trace('fixed portion of idw ln_rate = '||to_char(ln_rate));

1242:
1243: -- Calculate the fixed portion of idw
1244: ln_rate := ln_basepay_rate * ln_idw_factor ;
1245:
1246: hr_utility.trace('fixed portion of idw ln_rate = '||to_char(ln_rate));
1247:
1248: END IF ; -- lv_idw_calc_method
1249:
1250: p_fixed_idw := p_fixed_idw + ln_rate;

Line 1566: hr_utility.trace('Entering pay_mx_ff_udfs.get_contract_name');

1562: BEGIN
1563: --{
1564:
1565: lb_contract_exists := TRUE;
1566: hr_utility.trace('Entering pay_mx_ff_udfs.get_contract_name');
1567: pay_mx_utility.get_no_of_days_for_org(
1568: p_business_group_id => p_business_group_id,
1569: p_org_id => p_tax_unit_id,
1570: p_gre_or_le => 'GRE',

Line 1589: hr_utility.trace('ln_days_year = '|| to_char(ln_days_year));

1585: p_gre_or_le => 'LE',
1586: p_days_year => ln_days_year,
1587: p_days_month => ln_days_month);
1588:
1589: hr_utility.trace('ln_days_year = '|| to_char(ln_days_year));
1590: IF (ln_days_year IS NULL)
1591: THEN
1592: --{
1593: SELECT period_type

Line 1619: hr_utility.raise_error;

1615: rv_contract_name := 'IDW CALCULATION (Ten Days PAYROLL)';
1616: --}
1617: ELSE
1618: --{
1619: hr_utility.raise_error;
1620: --}
1621: END IF;
1622:
1623: --}

Line 1644: hr_utility.trace('Getting contract days..');

1640:
1641: BEGIN
1642: --{
1643: ln_contract_days := NULL;
1644: hr_utility.trace('Getting contract days..');
1645: ln_contract_days := fnd_number.canonical_to_number(hruserdt.get_table_value(
1646: p_bus_group_id => p_business_group_id,
1647: p_table_name => 'PQP_CONTRACT_TYPES',
1648: p_col_name => 'Days Divisor',

Line 1651: hr_utility.trace('ln_contract_days = '|| TO_CHAR (ln_contract_days));

1647: p_table_name => 'PQP_CONTRACT_TYPES',
1648: p_col_name => 'Days Divisor',
1649: p_row_value => rv_contract_name,
1650: p_effective_date => p_calculation_date));
1651: hr_utility.trace('ln_contract_days = '|| TO_CHAR (ln_contract_days));
1652: EXCEPTION
1653: WHEN NO_DATA_FOUND THEN
1654: lb_contract_exists := FALSE;
1655: --}

Line 1667: hr_utility.trace('leaving pay_mx_ff_udfs.get_contract_name');

1663: p_days_in_year => ln_days_year,
1664: p_exists => lb_contract_exists);
1665: --}
1666: END IF;
1667: hr_utility.trace('leaving pay_mx_ff_udfs.get_contract_name');
1668: RETURN rv_contract_name;
1669: --}
1670:
1671: END get_contract_name;

Line 1684: hr_utility.trace('before getting the rate from pqp..');

1680: p_business_group_id => p_business_group_id,
1681: p_tax_unit_id => p_tax_unit_id,
1682: p_payroll_id => p_payroll_id,
1683: p_calculation_date => p_effective_date);
1684: hr_utility.trace('before getting the rate from pqp..');
1685: ln_rate := pqp_rates_history_calc.get_historic_rate(
1686: p_assignment_id => p_assignment_id,
1687: p_rate_name => lv_rate_name,
1688: p_effective_date => p_effective_date,

Line 1692: hr_utility.trace('pqp_rates_history_calc.get_historic_rate');

1688: p_effective_date => p_effective_date,
1689: p_time_dimension => 'D',
1690: p_rate_type_or_element => 'R',
1691: p_contract_type => lv_contract_name);
1692: hr_utility.trace('pqp_rates_history_calc.get_historic_rate');
1693: RETURN ln_rate;
1694:
1695: EXCEPTION
1696: WHEN others THEN

Line 1712: hr_utility.trace('Get Daily Base Pay ');

1708: ln_daily_base_pay NUMBER;
1709:
1710: BEGIN
1711:
1712: hr_utility.trace('Get Daily Base Pay ');
1713:
1714: -- Get the Base Pay using historic rates
1715: ln_daily_base_pay := 0;
1716: ln_daily_base_pay := get_mx_historic_rate (

Line 1724: hr_utility.trace('ln_daily_base_pay = '||to_char(ln_daily_base_pay));

1720: ,p_payroll_id => p_payroll_id
1721: ,p_effective_date => p_effective_date
1722: ,p_rate_code => 'MX_BASE' );
1723:
1724: hr_utility.trace('ln_daily_base_pay = '||to_char(ln_daily_base_pay));
1725:
1726: RETURN ln_daily_base_pay;
1727:
1728: EXCEPTION

Line 1748: hr_utility.trace('Begin Get Base Pay for Tax Calculation');

1744: ln_days_in_a_month NUMBER;
1745: lv_period_type pay_all_payrolls_f.period_type%TYPE;
1746:
1747: BEGIN
1748: hr_utility.trace('Begin Get Base Pay for Tax Calculation');
1749:
1750: -- Get the Base Pay using historic rates
1751: ln_daily_base_pay := 0;
1752: ln_daily_base_pay := get_daily_base_pay (

Line 1759: hr_utility.trace('ln_daily_base_pay = '||ln_daily_base_pay);

1755: ,p_tax_unit_id => p_tax_unit_id
1756: ,p_payroll_id => p_payroll_id
1757: ,p_effective_date => p_effective_date);
1758:
1759: hr_utility.trace('ln_daily_base_pay = '||ln_daily_base_pay);
1760:
1761: IF p_month_or_pay_period = 'MONTH' THEN
1762:
1763: ln_days_in_a_month := pay_mx_utility.get_days_in_month(

Line 1811: hr_utility.trace('ln_base_pay = '|| ln_base_pay);

1807:
1808:
1809: END IF;
1810:
1811: hr_utility.trace('ln_base_pay = '|| ln_base_pay);
1812: hr_utility.trace('End Get Base Pay for Tax Calculation');
1813:
1814: RETURN ( ln_base_pay );
1815:

Line 1812: hr_utility.trace('End Get Base Pay for Tax Calculation');

1808:
1809: END IF;
1810:
1811: hr_utility.trace('ln_base_pay = '|| ln_base_pay);
1812: hr_utility.trace('End Get Base Pay for Tax Calculation');
1813:
1814: RETURN ( ln_base_pay );
1815:
1816: EXCEPTION