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

Line 3: g_debug boolean := hr_utility.debug_enabled;

1: package body pay_nl_eoy_pkg AS
2: /* $Header: pynleoy.pkb 120.10.12020000.4 2013/01/24 10:17:20 sgmaram ship $ */
3: g_debug boolean := hr_utility.debug_enabled;
4: ---------------------------------------------------------------------------
5: -- Procedure: get_prev_year_tax_income
6: -- Procedure which returns the balance values of a assignment for a given date
7: ---------------------------------------------------------------------------

Line 193: IF (hr_utility.chk_product_install('Oracle Payroll','NL')) THEN

189: l_special_rate_income_add :=0;
190: l_sum_prev_year_income :=0;
191: l_prev_year_income :=0;
192:
193: IF (hr_utility.chk_product_install('Oracle Payroll','NL')) THEN
194: null;
195: ELSE
196: return 0;
197: END IF;

Line 199: --hr_utility.trace_on(null,'GR');

195: ELSE
196: return 0;
197: END IF;
198:
199: --hr_utility.trace_on(null,'GR');
200: --OPEN get_dp_period(payroll_action_id);
201: --FETCH get_dp_period INTO l_dp_start_date,l_dp_end_date;
202: --CLOSE get_dp_period;
203:

Line 207: --hr_utility.trace_on(NULL,'NL_PREV');

203:
204: /* Determine the previous year and current year e.g. 2003 and 2004 respectively.*/
205: l_current_year:=TO_CHAR(p_effective_date,'YYYY');
206: l_prev_year:=l_current_year-1;
207: --hr_utility.trace_on(NULL,'NL_PREV');
208: --if g_debug then
209: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year'||l_prev_year,2000);
210: --end if;
211:

Line 209: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year'||l_prev_year,2000);

205: l_current_year:=TO_CHAR(p_effective_date,'YYYY');
206: l_prev_year:=l_current_year-1;
207: --hr_utility.trace_on(NULL,'NL_PREV');
208: --if g_debug then
209: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year'||l_prev_year,2000);
210: --end if;
211:
212: l_curr_year_start_date:=TO_DATE('01/'||'01/'||l_current_year,'DD/MM/YYYY');
213: l_prev_year_start_date:=TO_DATE('01/'||'01/'||l_prev_year,'DD/MM/YYYY');

Line 217: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,2100);

213: l_prev_year_start_date:=TO_DATE('01/'||'01/'||l_prev_year,'DD/MM/YYYY');
214: l_prev_year_end_date :=TO_DATE('31/'||'12/'||l_prev_year,'DD/MM/YYYY');
215:
216: --if g_debug then
217: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,2100);
218: --end if;
219:
220:
221:

Line 229: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_hol_allow_perc'||l_hol_allow_perc,2200);

225: l_date_earned =>p_effective_date,
226: l_global_name =>'NL_TAX_HOLIDAY_ALLOWANCE_PERCENTAGE'));
227:
228: --if g_debug then
229: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_hol_allow_perc'||l_hol_allow_perc,2200);
230: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: p_assignment_id'||p_assignment_id,2300);
231: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: p_effective_date'||p_effective_date,2300);
232: --end if;
233:

Line 230: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: p_assignment_id'||p_assignment_id,2300);

226: l_global_name =>'NL_TAX_HOLIDAY_ALLOWANCE_PERCENTAGE'));
227:
228: --if g_debug then
229: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_hol_allow_perc'||l_hol_allow_perc,2200);
230: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: p_assignment_id'||p_assignment_id,2300);
231: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: p_effective_date'||p_effective_date,2300);
232: --end if;
233:
234: /* LOOP through all assignments for the person, effective in the previous year and current year.*/

Line 231: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: p_effective_date'||p_effective_date,2300);

227:
228: --if g_debug then
229: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_hol_allow_perc'||l_hol_allow_perc,2200);
230: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: p_assignment_id'||p_assignment_id,2300);
231: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: p_effective_date'||p_effective_date,2300);
232: --end if;
233:
234: /* LOOP through all assignments for the person, effective in the previous year and current year.*/
235: FOR l_assignment IN get_all_assignments(p_assignment_id,p_effective_date,l_prev_year_start_date) LOOP --12576775

Line 248: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: EFFECTIVE_START_DATE'||l_asg_start_date,2400);

244:
245: --FOR l_assignment IN get_all_assignments(p_assignment_id,p_effective_date) LOOP
246:
247: --if g_debug then
248: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: EFFECTIVE_START_DATE'||l_asg_start_date,2400);
249: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: EFFECTIVE_END_DATE'||l_asg_end_date,2400);
250: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: PAYROLL_ID'||l_payroll_id,2400);
251: --end if;
252: l_start_of_the_period:=0;

Line 249: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: EFFECTIVE_END_DATE'||l_asg_end_date,2400);

245: --FOR l_assignment IN get_all_assignments(p_assignment_id,p_effective_date) LOOP
246:
247: --if g_debug then
248: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: EFFECTIVE_START_DATE'||l_asg_start_date,2400);
249: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: EFFECTIVE_END_DATE'||l_asg_end_date,2400);
250: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: PAYROLL_ID'||l_payroll_id,2400);
251: --end if;
252: l_start_of_the_period:=0;
253: l_periods_of_year:=0;

Line 250: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: PAYROLL_ID'||l_payroll_id,2400);

246:
247: --if g_debug then
248: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: EFFECTIVE_START_DATE'||l_asg_start_date,2400);
249: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: EFFECTIVE_END_DATE'||l_asg_end_date,2400);
250: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: PAYROLL_ID'||l_payroll_id,2400);
251: --end if;
252: l_start_of_the_period:=0;
253: l_periods_of_year:=0;
254: l_periods_in_service:=0;

Line 263: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_asg_start_date'||l_asg_start_date,2400);

259: OPEN get_start_date_period(l_payroll_id,l_prev_year);
260: FETCH get_start_date_period INTO l_prev_year_start_date,l_dummy,l_dummy_num;
261: CLOSE get_start_date_period;
262:
263: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_asg_start_date'||l_asg_start_date,2400);
264: l_temp_asg_start_date:=l_asg_start_date;
265: IF l_asg_start_date < l_prev_year_start_date THEN
266: l_temp_asg_start_date:= l_prev_year_start_date;
267: END IF;

Line 268: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_temp_asg_start_date'||l_temp_asg_start_date,2400);

264: l_temp_asg_start_date:=l_asg_start_date;
265: IF l_asg_start_date < l_prev_year_start_date THEN
266: l_temp_asg_start_date:= l_prev_year_start_date;
267: END IF;
268: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_temp_asg_start_date'||l_temp_asg_start_date,2400);
269: FOR l_start_date IN get_start_date_period(l_payroll_id,l_prev_year) LOOP
270:
271: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_start_date.START_DATE'||l_start_date.START_DATE,2410);
272:

Line 271: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_start_date.START_DATE'||l_start_date.START_DATE,2410);

267: END IF;
268: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_temp_asg_start_date'||l_temp_asg_start_date,2400);
269: FOR l_start_date IN get_start_date_period(l_payroll_id,l_prev_year) LOOP
270:
271: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_start_date.START_DATE'||l_start_date.START_DATE,2410);
272:
273: IF l_start_date.START_DATE = l_temp_asg_start_date THEN
274: l_start_of_the_period:=1;
275: END IF;

Line 277: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_start_of_the_period'||l_start_of_the_period,2420);

273: IF l_start_date.START_DATE = l_temp_asg_start_date THEN
274: l_start_of_the_period:=1;
275: END IF;
276: l_periods_of_year:=l_periods_of_year+1;
277: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_start_of_the_period'||l_start_of_the_period,2420);
278: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2420);
279:
280: IF l_temp_asg_start_date >= l_start_date.START_DATE THEN
281:

Line 278: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2420);

274: l_start_of_the_period:=1;
275: END IF;
276: l_periods_of_year:=l_periods_of_year+1;
277: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_start_of_the_period'||l_start_of_the_period,2420);
278: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2420);
279:
280: IF l_temp_asg_start_date >= l_start_date.START_DATE THEN
281:
282: l_first_period:=l_start_date.PERIOD_NUM;

Line 285: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_first_period'||l_first_period,2430);

281:
282: l_first_period:=l_start_date.PERIOD_NUM;
283: l_period_start_date:=l_start_date.START_DATE;
284: l_period_end_date:=l_start_date.END_DATE;
285: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_first_period'||l_first_period,2430);
286: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_period_start_date'||l_period_start_date,2430);
287: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_period_end_date'||l_period_end_date,2430);
288: END IF;
289: --IF l_start_date.START_DATE >= l_asg_end_date and l_last_period is null THEN

Line 286: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_period_start_date'||l_period_start_date,2430);

282: l_first_period:=l_start_date.PERIOD_NUM;
283: l_period_start_date:=l_start_date.START_DATE;
284: l_period_end_date:=l_start_date.END_DATE;
285: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_first_period'||l_first_period,2430);
286: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_period_start_date'||l_period_start_date,2430);
287: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_period_end_date'||l_period_end_date,2430);
288: END IF;
289: --IF l_start_date.START_DATE >= l_asg_end_date and l_last_period is null THEN
290: --l_last_period:=l_start_date.PERIOD_NUM;

Line 287: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_period_end_date'||l_period_end_date,2430);

283: l_period_start_date:=l_start_date.START_DATE;
284: l_period_end_date:=l_start_date.END_DATE;
285: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_first_period'||l_first_period,2430);
286: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_period_start_date'||l_period_start_date,2430);
287: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_period_end_date'||l_period_end_date,2430);
288: END IF;
289: --IF l_start_date.START_DATE >= l_asg_end_date and l_last_period is null THEN
290: --l_last_period:=l_start_date.PERIOD_NUM;
291: --END IF;

Line 292: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_last_period'||l_last_period,2440);

288: END IF;
289: --IF l_start_date.START_DATE >= l_asg_end_date and l_last_period is null THEN
290: --l_last_period:=l_start_date.PERIOD_NUM;
291: --END IF;
292: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_last_period'||l_last_period,2440);
293: IF l_start_date.PERIOD_NUM=1 THEN
294: l_prev_year_start_date:=l_start_date.START_DATE;
295: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_start_date'||l_prev_year_start_date,2440);
296: END IF;

Line 295: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_start_date'||l_prev_year_start_date,2440);

291: --END IF;
292: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_last_period'||l_last_period,2440);
293: IF l_start_date.PERIOD_NUM=1 THEN
294: l_prev_year_start_date:=l_start_date.START_DATE;
295: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_start_date'||l_prev_year_start_date,2440);
296: END IF;
297: l_prev_year_end_date:=l_start_date.END_DATE;
298: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: PAYROLL_ID'||l_payroll_id,2450);
299: END LOOP;

Line 298: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: PAYROLL_ID'||l_payroll_id,2450);

294: l_prev_year_start_date:=l_start_date.START_DATE;
295: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_start_date'||l_prev_year_start_date,2440);
296: END IF;
297: l_prev_year_end_date:=l_start_date.END_DATE;
298: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: PAYROLL_ID'||l_payroll_id,2450);
299: END LOOP;
300:
301: --11854614
302: OPEN get_pay_date_offset(l_payroll_id);

Line 309: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2500);

305: l_prev_year_end_date := l_prev_year_end_date + l_pay_date_offset;
306: --11854614
307:
308: --if g_debug then
309: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2500);
310: --end if;
311: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2500);
312: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_first_period'||l_first_period,2500);
313:

Line 311: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2500);

307:
308: --if g_debug then
309: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2500);
310: --end if;
311: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2500);
312: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_first_period'||l_first_period,2500);
313:
314: l_periods_in_service:=l_periods_of_year - l_first_period;
315: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_in_service'||l_periods_in_service,2501);

Line 312: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_first_period'||l_first_period,2500);

308: --if g_debug then
309: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2500);
310: --end if;
311: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2500);
312: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_first_period'||l_first_period,2500);
313:
314: l_periods_in_service:=l_periods_of_year - l_first_period;
315: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_in_service'||l_periods_in_service,2501);
316: l_periods_in_service:=l_periods_in_service+1;

Line 315: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_in_service'||l_periods_in_service,2501);

311: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2500);
312: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_first_period'||l_first_period,2500);
313:
314: l_periods_in_service:=l_periods_of_year - l_first_period;
315: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_in_service'||l_periods_in_service,2501);
316: l_periods_in_service:=l_periods_in_service+1;
317:
318: /*IF l_asg_end_date < l_prev_year_end_date THEN
319: l_periods_after_last_period:=l_periods_of_year - l_last_period + 1;

Line 320: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_after_last_period'||l_periods_after_last_period,2502);

316: l_periods_in_service:=l_periods_in_service+1;
317:
318: /*IF l_asg_end_date < l_prev_year_end_date THEN
319: l_periods_after_last_period:=l_periods_of_year - l_last_period + 1;
320: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_after_last_period'||l_periods_after_last_period,2502);
321: l_periods_in_service:=l_periods_in_service - l_periods_after_last_period;
322: END IF;*/
323:
324: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2503);

Line 324: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2503);

320: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_after_last_period'||l_periods_after_last_period,2502);
321: l_periods_in_service:=l_periods_in_service - l_periods_after_last_period;
322: END IF;*/
323:
324: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2503);
325: --if g_debug then
326: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_in_service'||l_periods_in_service,2504);
327: --end if;
328: OPEN get_start_date_period(l_payroll_id,l_current_year);

Line 326: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_in_service'||l_periods_in_service,2504);

322: END IF;*/
323:
324: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2503);
325: --if g_debug then
326: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_in_service'||l_periods_in_service,2504);
327: --end if;
328: OPEN get_start_date_period(l_payroll_id,l_current_year);
329: FETCH get_start_date_period INTO l_curr_year_start_date,l_dummy,l_dummy_num;
330: CLOSE get_start_date_period;

Line 408: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_std_tax_income'||l_std_tax_income,2600);

404: );
405: END IF;
406:
407: --if g_debug then
408: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_std_tax_income'||l_std_tax_income,2600);
409: --end if;
410: IF l_periods_in_service IS NULL OR l_periods_in_service=0 THEN
411: l_periods_in_service:=1;
412: END IF;

Line 449: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_prev_year_income'||l_sum_prev_year_income,2800);

445: l_sum_prev_year_income:=l_sum_prev_year_income + l_std_tax_income + l_spl_tax_income + l_retrostd_tax_income +
446: l_retrostdcurrq_tax_income + l_retrospl_tax_income;
447:
448: --if g_debug then
449: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_prev_year_income'||l_sum_prev_year_income,2800);
450: --end if;
451:
452: /* If assignment started at the beginning of a period in the previous year.*/
453: ELSIF l_start_of_the_period = 1 and l_asg_end_date >= l_prev_year_start_date AND l_asg_start_date < l_curr_year_start_date THEN

Line 456: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,2900);

452: /* If assignment started at the beginning of a period in the previous year.*/
453: ELSIF l_start_of_the_period = 1 and l_asg_end_date >= l_prev_year_start_date AND l_asg_start_date < l_curr_year_start_date THEN
454:
455: --if g_debug then
456: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,2900);
457: --end if;
458: /* Add together the values of balances Standard Taxable Income, Special Taxable
459: Income, Retro Standard Taxable Income, Retro Standard Taxable Income
460: Current Quarter and Retro Special Taxable Income for the previous year.*/

Line 467: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_hol_allow_pay_income'||l_hol_allow_pay_income,3000);

463: l_retrostdcurrq_tax_income + l_retrospl_tax_income;
464:
465:
466: --if g_debug then
467: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_hol_allow_pay_income'||l_hol_allow_pay_income,3000);
468: --end if;
469: /* Remove the value of balance Holiday Allowance Payment for the previous year. */
470:
471: l_prev_year_income:= l_prev_year_income - l_hol_allow_pay_income;

Line 475: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,3100);

471: l_prev_year_income:= l_prev_year_income - l_hol_allow_pay_income;
472:
473: /* Divide the total by the number of payroll periods in service.*/
474: --if g_debug then
475: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,3100);
476: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_in_service'||l_periods_in_service,3200);
477: --end if;
478: l_prev_year_income:= l_prev_year_income/l_periods_in_service;
479: /* Multiply by the total number of payroll periods in the year to provide the estimated taxable income for the previous year */

Line 476: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_in_service'||l_periods_in_service,3200);

472:
473: /* Divide the total by the number of payroll periods in service.*/
474: --if g_debug then
475: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,3100);
476: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_in_service'||l_periods_in_service,3200);
477: --end if;
478: l_prev_year_income:= l_prev_year_income/l_periods_in_service;
479: /* Multiply by the total number of payroll periods in the year to provide the estimated taxable income for the previous year */
480: --if g_debug then

Line 481: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,3300);

477: --end if;
478: l_prev_year_income:= l_prev_year_income/l_periods_in_service;
479: /* Multiply by the total number of payroll periods in the year to provide the estimated taxable income for the previous year */
480: --if g_debug then
481: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,3300);
482: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,3300);
483: --end if;
484: l_prev_year_income:=l_prev_year_income * l_periods_of_year;
485:

Line 482: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,3300);

478: l_prev_year_income:= l_prev_year_income/l_periods_in_service;
479: /* Multiply by the total number of payroll periods in the year to provide the estimated taxable income for the previous year */
480: --if g_debug then
481: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,3300);
482: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,3300);
483: --end if;
484: l_prev_year_income:=l_prev_year_income * l_periods_of_year;
485:
486:

Line 497: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_allow_tax_income'||l_sum_hol_allow_tax_income,3400);

493: --Bug 3479044
494: l_sum_hol_allow_tax_income:=l_sum_hol_allow_tax_income-l_hol_allow_pay_income;
495:
496: --if g_debug then
497: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_allow_tax_income'||l_sum_hol_allow_tax_income,3400);
498: --end if;
499: l_sum_hol_allow_tax_income:= l_sum_hol_allow_tax_income/l_periods_in_service;
500: l_sum_hol_allow_tax_income:=l_sum_hol_allow_tax_income * l_periods_of_year;
501:

Line 503: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_allow_tax_income'||l_sum_hol_allow_tax_income,3500);

499: l_sum_hol_allow_tax_income:= l_sum_hol_allow_tax_income/l_periods_in_service;
500: l_sum_hol_allow_tax_income:=l_sum_hol_allow_tax_income * l_periods_of_year;
501:
502: --if g_debug then
503: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_allow_tax_income'||l_sum_hol_allow_tax_income,3500);
504: --end if;
505: l_estimated_hol_allow:=l_sum_hol_allow_tax_income * l_hol_allow_perc/100;
506:
507: --if g_debug then

Line 508: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_estimated_hol_allow'||l_estimated_hol_allow,3600);

504: --end if;
505: l_estimated_hol_allow:=l_sum_hol_allow_tax_income * l_hol_allow_perc/100;
506:
507: --if g_debug then
508: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_estimated_hol_allow'||l_estimated_hol_allow,3600);
509: --end if;
510: /* Add the estimated holiday allowance to the estimated taxable income, to provide
511: the previous year?s taxable income for this assignment */
512:

Line 519: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,3700);

515:
516: l_sum_prev_year_income:=l_sum_prev_year_income +l_prev_year_income;
517:
518: --if g_debug then
519: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,3700);
520: --end if;
521: /* If the assignment started part way through a period in the previous year */
522: ELSIF l_asg_end_date >= l_prev_year_start_date AND l_asg_start_date < l_curr_year_start_date THEN
523:

Line 530: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_week_days'||l_week_days,3800);

526:
527: l_week_days:= pay_nl_si_pkg.get_week_days(l_asg_start_date,l_period_end_date);
528:
529: --if g_debug then
530: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_week_days'||l_week_days,3800);
531: --end if;
532: IF l_week_days IS NULL OR l_week_days=0 THEN
533: l_week_days:=1;
534: END IF;

Line 544: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_total_week_days'||l_total_week_days,3900);

540: IF l_total_week_days IS NULL THEN
541: l_total_week_days:=0;
542: END IF;
543: --if g_debug then
544: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_total_week_days'||l_total_week_days,3900);
545: --end if;
546:
547: /*Add together the balances Standard Taxable Income, Special Taxable
548: Income, Retro Standard Taxable Income, Retro Standard Taxable Income

Line 554: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_first_period_income'||l_first_period_income,4000);

550:
551: l_first_period_income:= l_std_tax_income_ptd + l_spl_tax_income_ptd + l_retrostd_tax_income_ptd +
552: l_retrostdcurrq_tax_income_ptd + l_retrospl_tax_income_ptd;
553: --if g_debug then
554: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_first_period_income'||l_first_period_income,4000);
555: --end if;
556:
557: l_prev_year_income:= l_std_tax_income + l_spl_tax_income + l_retrostd_tax_income +
558: l_retrostdcurrq_tax_income + l_retrospl_tax_income;

Line 560: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,4100);

556:
557: l_prev_year_income:= l_std_tax_income + l_spl_tax_income + l_retrostd_tax_income +
558: l_retrostdcurrq_tax_income + l_retrospl_tax_income;
559: --if g_debug then
560: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,4100);
561: --end if;
562:
563: l_prev_year_income:=l_prev_year_income - l_first_period_income;
564:

Line 566: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,4200);

562:
563: l_prev_year_income:=l_prev_year_income - l_first_period_income;
564:
565: --if g_debug then
566: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,4200);
567: --end if;
568:
569: /*Then divide this by the number of week days worked and then multiply by the number
570: of week days in the period. This will provide an estimated taxable income for the

Line 578: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_first_period_income'||l_first_period_income,4300);

574:
575: l_first_period_income:=l_first_period_income/l_week_days;
576: l_first_period_income:=l_first_period_income * l_total_week_days;
577: --if g_debug then
578: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_first_period_income'||l_first_period_income,4300);
579: --end if;
580:
581: /*Add together the balances Standard Taxable Income, Special Taxable
582: Income, Retro Standard Taxable Income, Retro Standard Taxable Income

Line 595: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,4500);

591: /*Then add this total to the estimated taxable income for the first period. */
592: l_prev_year_income:=l_prev_year_income + l_first_period_income;
593:
594: --if g_debug then
595: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,4500);
596: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_hol_allow_pay_income'||l_hol_allow_pay_income,4400);
597: --end if;
598: /*Remove the value of balance Holiday Allowance Payment for the previous year.*/
599:

Line 596: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_hol_allow_pay_income'||l_hol_allow_pay_income,4400);

592: l_prev_year_income:=l_prev_year_income + l_first_period_income;
593:
594: --if g_debug then
595: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,4500);
596: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_hol_allow_pay_income'||l_hol_allow_pay_income,4400);
597: --end if;
598: /*Remove the value of balance Holiday Allowance Payment for the previous year.*/
599:
600: -- l_prev_year_income:=l_prev_year_income - l_hol_allow_pay_income;

Line 603: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,4600);

599:
600: -- l_prev_year_income:=l_prev_year_income - l_hol_allow_pay_income;
601:
602: --if g_debug then
603: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,4600);
604: --end if;
605: /*Divide the total by the number of periods in service (including the part period and
606: treating this as a full period).*/
607:

Line 610: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,4700);

606: treating this as a full period).*/
607:
608: l_prev_year_income:= l_prev_year_income/l_periods_in_service;
609: --if g_debug then
610: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,4700);
611: --end if;
612: /*Multiply by the total number of payroll periods in the year, to provide the
613: estimated taxable income for the previous year.*/
614:

Line 617: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,4800);

613: estimated taxable income for the previous year.*/
614:
615: l_prev_year_income:=l_prev_year_income * l_periods_of_year;
616: --if g_debug then
617: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,4800);
618: --end if;
619: /*Calculate the estimated value for holiday allowance as a percentage of an
620: adjusted total of balances Holiday Allowance Taxable Income and Retro Holiday
621: Allowance Taxable Income in the previous year.*/

Line 625: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_first_period'||l_sum_hol_first_period,4900);

621: Allowance Taxable Income in the previous year.*/
622:
623: l_sum_hol_first_period:=l_hol_allow_tax_income_ptd + l_rethol_allow_tax_income_ptd;
624: --if g_debug then
625: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_first_period'||l_sum_hol_first_period,4900);
626: --end if;
627: l_sum_hol_prev_year:=l_hol_allow_tax_income + l_retrohol_allow_tax_income;
628:
629: --if g_debug then

Line 630: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_prev_year'||l_sum_hol_prev_year,5000);

626: --end if;
627: l_sum_hol_prev_year:=l_hol_allow_tax_income + l_retrohol_allow_tax_income;
628:
629: --if g_debug then
630: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_prev_year'||l_sum_hol_prev_year,5000);
631: --end if;
632:
633: /*convert the holiday allowance taxable income for the first part period to an estimated value
634: for the whole period, adding this to the holiday allowance taxable income for the

Line 640: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_prev_year'||l_sum_hol_prev_year,5100);

636: by the total number of payroll periods in the year. */
637:
638: l_sum_hol_prev_year:=l_sum_hol_prev_year - l_sum_hol_first_period;
639: --if g_debug then
640: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_prev_year'||l_sum_hol_prev_year,5100);
641: --end if;
642: l_sum_hol_first_period:=l_sum_hol_first_period - l_hol_allow_pay_income_ptd;
643:
644: l_sum_hol_first_period:=l_sum_hol_first_period/l_week_days;

Line 647: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_first_period'||l_sum_hol_first_period,5200);

643:
644: l_sum_hol_first_period:=l_sum_hol_first_period/l_week_days;
645:
646: --if g_debug then
647: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_first_period'||l_sum_hol_first_period,5200);
648: --end if;
649:
650: l_sum_hol_first_period:=l_sum_hol_first_period * l_total_week_days;
651:

Line 653: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_first_period'||l_sum_hol_first_period,5300);

649:
650: l_sum_hol_first_period:=l_sum_hol_first_period * l_total_week_days;
651:
652: --if g_debug then
653: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_first_period'||l_sum_hol_first_period,5300);
654: --end if;
655: l_sum_hol_prev_year:=l_sum_hol_prev_year - l_hol_allow_pay_income;
656:
657: l_sum_hol_prev_year:=l_sum_hol_prev_year + l_sum_hol_first_period;

Line 660: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_prev_year'||l_sum_hol_prev_year,5400);

656:
657: l_sum_hol_prev_year:=l_sum_hol_prev_year + l_sum_hol_first_period;
658:
659: --if g_debug then
660: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_prev_year'||l_sum_hol_prev_year,5400);
661: --end if;
662:
663: l_sum_hol_prev_year:=l_sum_hol_prev_year/l_periods_in_service;
664:

Line 666: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_prev_year'||l_sum_hol_prev_year,5500);

662:
663: l_sum_hol_prev_year:=l_sum_hol_prev_year/l_periods_in_service;
664:
665: --if g_debug then
666: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_prev_year'||l_sum_hol_prev_year,5500);
667: --end if;
668:
669: l_sum_hol_prev_year:=l_sum_hol_prev_year * l_periods_of_year;
670:

Line 672: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_prev_year'||l_sum_hol_prev_year,5600);

668:
669: l_sum_hol_prev_year:=l_sum_hol_prev_year * l_periods_of_year;
670:
671: --if g_debug then
672: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_prev_year'||l_sum_hol_prev_year,5600);
673: --end if;
674:
675: l_estimated_hol_allow:=l_sum_hol_prev_year * l_hol_allow_perc/100;
676:

Line 678: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_estimated_hol_allow'||l_estimated_hol_allow,5700);

674:
675: l_estimated_hol_allow:=l_sum_hol_prev_year * l_hol_allow_perc/100;
676:
677: --if g_debug then
678: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_estimated_hol_allow'||l_estimated_hol_allow,5700);
679: --end if;
680: /* Add the estimated holiday allowance to the estimated taxable income, to provide
681: the previous year?s taxable income for this assignment. */
682:

Line 685: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,5800);

681: the previous year?s taxable income for this assignment. */
682:
683: l_prev_year_income:=l_prev_year_income +l_estimated_hol_allow;
684: --if g_debug then
685: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,5800);
686: --end if;
687:
688: l_sum_prev_year_income:=l_sum_prev_year_income +l_prev_year_income;
689: --if g_debug then

Line 690: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_prev_year_income'||l_sum_prev_year_income,5900);

686: --end if;
687:
688: l_sum_prev_year_income:=l_sum_prev_year_income +l_prev_year_income;
689: --if g_debug then
690: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_prev_year_income'||l_sum_prev_year_income,5900);
691: --end if;
692:
693: END IF;
694:

Line 701: hr_utility.trace('~~VV3');

697:
698: --
699: l_type := 'DP';
700: IF p_payroll_action_id <> -1 THEN
701: hr_utility.trace('~~VV3');
702: l_ass_act_id := NULL;
703: OPEN get_ass_act_id(l_assignment.assignment_id,l_current_period_start_date,l_current_period_end_date);
704: FETCH get_ass_act_id INTO l_ass_act_id;
705: CLOSE get_ass_act_id;

Line 712: hr_utility.trace('~~VV l_type : '||l_type);

708: ,l_assignment.assignment_id
709: ,l_ass_act_id);
710: --
711:
712: hr_utility.trace('~~VV l_type : '||l_type);
713: IF l_type = 'DE' THEN
714: l_spl_rate_income_dbaid_ptd:=pay_nl_general.get_defined_balance_id('SPECIAL_RATE_INCOME_ASG_BDATE_PTD');
715: IF l_ass_act_id is NOT NULL THEN
716: l_special_rate_income_ptd :=pay_balance_pkg.get_value(p_defined_balance_id=> l_spl_rate_income_dbaid_ptd

Line 747: hr_utility.trace('~~VV 2');

743: l_special_rate_income_ptd := 0;
744: END IF;
745: END IF;
746: ELSE
747: hr_utility.trace('~~VV 2');
748: l_spl_rate_income_dbaid_ptd:=pay_nl_general.get_defined_balance_id('SPECIAL_RATE_INCOME_ASG_PTD');
749: --12576775
750: IF l_current_period_end_date BETWEEN l_asg_start_date and l_asg_end_date THEN
751: l_special_rate_income_ptd :=pay_balance_pkg.get_value(l_spl_rate_income_dbaid_ptd

Line 787: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME:l_sum_prev_year_income '||l_sum_prev_year_income,6000);

783: END IF;
784: END LOOP;
785:
786: --if g_debug then
787: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME:l_sum_prev_year_income '||l_sum_prev_year_income,6000);
788: --end if;
789: --Return the Previous Year Taxable Income
790: l_sum_prev_year_income:=FLOOR(l_sum_prev_year_income);
791:

Line 797: hr_utility.set_location('~~ Final'|| l_sum_prev_year_income,11111);

793:
794: l_sum_prev_year_income:=l_sum_prev_year_income+l_special_rate_annual_income;
795:
796:
797: hr_utility.set_location('~~ Final'|| l_sum_prev_year_income,11111);
798: --hr_utility.trace_off();
799: RETURN l_sum_prev_year_income;
800:
801:

Line 798: --hr_utility.trace_off();

794: l_sum_prev_year_income:=l_sum_prev_year_income+l_special_rate_annual_income;
795:
796:
797: hr_utility.set_location('~~ Final'|| l_sum_prev_year_income,11111);
798: --hr_utility.trace_off();
799: RETURN l_sum_prev_year_income;
800:
801:
802: EXCEPTION

Line 804: hr_utility.set_location('GET_PREV_YEAR_TAX_INCOME'||SQLERRM||SQLCODE,4200);

800:
801:
802: EXCEPTION
803: WHEN NO_DATA_FOUND THEN
804: hr_utility.set_location('GET_PREV_YEAR_TAX_INCOME'||SQLERRM||SQLCODE,4200);
805: RETURN 0;
806:
807: END GET_PREV_YEAR_TAX_INCOME;
808: --

Line 882: hr_utility.set_location('Inside get_balance_values: l_std_tax_dbalid'||l_std_tax_dbalid,2510);

878: l_retrohol_allow_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_PTD');
879:
880:
881: --if g_debug then
882: hr_utility.set_location('Inside get_balance_values: l_std_tax_dbalid'||l_std_tax_dbalid,2510);
883: --end if;
884:
885: l_std_tax_income :=pay_balance_pkg.get_value(l_std_tax_dbalid
886: ,l_assignment_id

Line 901: hr_utility.set_location('Inside get_balance_values: l_retrospl_tax_income'||l_retrospl_tax_income,2520);

897: l_retrospl_tax_income :=pay_balance_pkg.get_value(l_retrospl_tax_dbalid
898: ,l_assignment_id
899: ,l_prev_year_end_date);
900: --if g_debug then
901: hr_utility.set_location('Inside get_balance_values: l_retrospl_tax_income'||l_retrospl_tax_income,2520);
902: --end if;
903:
904: l_hol_allow_pay_income :=pay_balance_pkg.get_value(l_hol_allow_pay_dbalid
905: ,l_assignment_id

Line 915: hr_utility.set_location('Inside get_balance_values: l_std_tax_dbalid_ptd'||l_std_tax_dbalid_ptd,2530);

911: ,l_assignment_id
912: ,l_prev_year_end_date);
913:
914: --if g_debug then
915: hr_utility.set_location('Inside get_balance_values: l_std_tax_dbalid_ptd'||l_std_tax_dbalid_ptd,2530);
916: hr_utility.set_location('Inside get_balance_values: l_assignment_id'||l_assignment_id,2530);
917: hr_utility.set_location('Inside get_balance_values: l_period_end_date'||l_period_end_date,2530);
918: --end if;
919:

Line 916: hr_utility.set_location('Inside get_balance_values: l_assignment_id'||l_assignment_id,2530);

912: ,l_prev_year_end_date);
913:
914: --if g_debug then
915: hr_utility.set_location('Inside get_balance_values: l_std_tax_dbalid_ptd'||l_std_tax_dbalid_ptd,2530);
916: hr_utility.set_location('Inside get_balance_values: l_assignment_id'||l_assignment_id,2530);
917: hr_utility.set_location('Inside get_balance_values: l_period_end_date'||l_period_end_date,2530);
918: --end if;
919:
920:

Line 917: hr_utility.set_location('Inside get_balance_values: l_period_end_date'||l_period_end_date,2530);

913:
914: --if g_debug then
915: hr_utility.set_location('Inside get_balance_values: l_std_tax_dbalid_ptd'||l_std_tax_dbalid_ptd,2530);
916: hr_utility.set_location('Inside get_balance_values: l_assignment_id'||l_assignment_id,2530);
917: hr_utility.set_location('Inside get_balance_values: l_period_end_date'||l_period_end_date,2530);
918: --end if;
919:
920:
921: l_std_tax_income_ptd :=pay_balance_pkg.get_value(l_std_tax_dbalid_ptd

Line 925: hr_utility.set_location('Inside get_balance_values: l_std_tax_income_ptd'||l_std_tax_income_ptd,2531);

921: l_std_tax_income_ptd :=pay_balance_pkg.get_value(l_std_tax_dbalid_ptd
922: ,l_assignment_id
923: ,l_period_end_date);
924: --if g_debug then
925: hr_utility.set_location('Inside get_balance_values: l_std_tax_income_ptd'||l_std_tax_income_ptd,2531);
926: --end if;
927:
928: l_spl_tax_income_ptd :=pay_balance_pkg.get_value(l_spl_tax_dbalid_ptd
929: ,l_assignment_id

Line 932: hr_utility.set_location('Inside get_balance_values: l_spl_tax_income_ptd'||l_spl_tax_income_ptd,2532);

928: l_spl_tax_income_ptd :=pay_balance_pkg.get_value(l_spl_tax_dbalid_ptd
929: ,l_assignment_id
930: ,l_period_end_date);
931: --if g_debug then
932: hr_utility.set_location('Inside get_balance_values: l_spl_tax_income_ptd'||l_spl_tax_income_ptd,2532);
933: --end if;
934:
935: l_retrostd_tax_income_ptd :=pay_balance_pkg.get_value(l_retrostd_tax_dbalid_ptd
936: ,l_assignment_id

Line 939: hr_utility.set_location('Inside get_balance_values: l_retrostd_tax_income_ptd'||l_retrostd_tax_income_ptd,2533);

935: l_retrostd_tax_income_ptd :=pay_balance_pkg.get_value(l_retrostd_tax_dbalid_ptd
936: ,l_assignment_id
937: ,l_period_end_date);
938: --if g_debug then
939: hr_utility.set_location('Inside get_balance_values: l_retrostd_tax_income_ptd'||l_retrostd_tax_income_ptd,2533);
940: --end if;
941:
942: l_retrostdcurrq_tax_income_ptd :=pay_balance_pkg.get_value(l_retrostdcurrq_tax_dbalid_ptd
943: ,l_assignment_id

Line 946: hr_utility.set_location('Inside get_balance_values: l_retrostdcurrq_tax_income_ptd'||l_retrostdcurrq_tax_income_ptd,2534);

942: l_retrostdcurrq_tax_income_ptd :=pay_balance_pkg.get_value(l_retrostdcurrq_tax_dbalid_ptd
943: ,l_assignment_id
944: ,l_period_end_date);
945: --if g_debug then
946: hr_utility.set_location('Inside get_balance_values: l_retrostdcurrq_tax_income_ptd'||l_retrostdcurrq_tax_income_ptd,2534);
947: --end if;
948:
949: l_retrospl_tax_income_ptd :=pay_balance_pkg.get_value(l_retrospl_tax_dbalid_ptd
950: ,l_assignment_id

Line 953: hr_utility.set_location('Inside get_balance_values: l_retrospl_tax_income_ptd'||l_retrospl_tax_income_ptd,2540);

949: l_retrospl_tax_income_ptd :=pay_balance_pkg.get_value(l_retrospl_tax_dbalid_ptd
950: ,l_assignment_id
951: ,l_period_end_date);
952: --if g_debug then
953: hr_utility.set_location('Inside get_balance_values: l_retrospl_tax_income_ptd'||l_retrospl_tax_income_ptd,2540);
954: --end if;
955:
956: l_hol_allow_pay_income_ptd :=pay_balance_pkg.get_value(l_hol_allow_pay_dbalid_ptd
957: ,l_assignment_id

Line 966: hr_utility.set_location('Inside get_balance_values: l_rethol_allow_tax_income_ptd'||l_rethol_allow_tax_income_ptd,2550);

962: l_rethol_allow_tax_income_ptd :=pay_balance_pkg.get_value(l_retrohol_allow_dbalid_ptd
963: ,l_assignment_id
964: ,l_period_end_date);
965: --if g_debug then
966: hr_utility.set_location('Inside get_balance_values: l_rethol_allow_tax_income_ptd'||l_rethol_allow_tax_income_ptd,2550);
967: --end if;
968:
969: Exception
970: WHEN NO_DATA_FOUND THEN

Line 971: hr_utility.set_location('get_balance_values'||SQLERRM||SQLCODE,1200);

967: --end if;
968:
969: Exception
970: WHEN NO_DATA_FOUND THEN
971: hr_utility.set_location('get_balance_values'||SQLERRM||SQLCODE,1200);
972: l_std_tax_income:=0;
973: l_spl_tax_income:=0;
974: l_retrostd_tax_income:=0;
975: l_retrostdcurrq_tax_income:=0;

Line 1098: --hr_utility.trace_on(null,'RESET_OVERRIDE');

1094: FROM per_all_assignments_f asg
1095: WHERE asg.assignment_id = p_asg_id;
1096: --12608988 End
1097: Begin
1098: --hr_utility.trace_on(null,'RESET_OVERRIDE');
1099: --hr_utility.trace('In reset override');
1100:
1101: retcode := 0;
1102: l_st_date := fnd_date.canonical_to_date(p_date); --12322620

Line 1099: --hr_utility.trace('In reset override');

1095: WHERE asg.assignment_id = p_asg_id;
1096: --12608988 End
1097: Begin
1098: --hr_utility.trace_on(null,'RESET_OVERRIDE');
1099: --hr_utility.trace('In reset override');
1100:
1101: retcode := 0;
1102: l_st_date := fnd_date.canonical_to_date(p_date); --12322620
1103:

Line 1138: --hr_utility.trace(l_datetrack_update_mode);

1134: else
1135: l_datetrack_update_mode := 'UPDATE';
1136: end if;
1137: Begin
1138: --hr_utility.trace(l_datetrack_update_mode);
1139: --hr_utility.trace(l_asg_details.assignment_id);
1140: --hr_utility.trace(l_asg_details.assignment_number);
1141: --hr_utility.trace(l_asg_details.effective_start_date);
1142: --hr_utility.trace(l_asg_details.effective_end_date);

Line 1139: --hr_utility.trace(l_asg_details.assignment_id);

1135: l_datetrack_update_mode := 'UPDATE';
1136: end if;
1137: Begin
1138: --hr_utility.trace(l_datetrack_update_mode);
1139: --hr_utility.trace(l_asg_details.assignment_id);
1140: --hr_utility.trace(l_asg_details.assignment_number);
1141: --hr_utility.trace(l_asg_details.effective_start_date);
1142: --hr_utility.trace(l_asg_details.effective_end_date);
1143: --hr_utility.trace(fnd_date.canonical_to_date(p_date));

Line 1140: --hr_utility.trace(l_asg_details.assignment_number);

1136: end if;
1137: Begin
1138: --hr_utility.trace(l_datetrack_update_mode);
1139: --hr_utility.trace(l_asg_details.assignment_id);
1140: --hr_utility.trace(l_asg_details.assignment_number);
1141: --hr_utility.trace(l_asg_details.effective_start_date);
1142: --hr_utility.trace(l_asg_details.effective_end_date);
1143: --hr_utility.trace(fnd_date.canonical_to_date(p_date));
1144: --hr_utility.trace(hr_general.end_of_time);

Line 1141: --hr_utility.trace(l_asg_details.effective_start_date);

1137: Begin
1138: --hr_utility.trace(l_datetrack_update_mode);
1139: --hr_utility.trace(l_asg_details.assignment_id);
1140: --hr_utility.trace(l_asg_details.assignment_number);
1141: --hr_utility.trace(l_asg_details.effective_start_date);
1142: --hr_utility.trace(l_asg_details.effective_end_date);
1143: --hr_utility.trace(fnd_date.canonical_to_date(p_date));
1144: --hr_utility.trace(hr_general.end_of_time);
1145:

Line 1142: --hr_utility.trace(l_asg_details.effective_end_date);

1138: --hr_utility.trace(l_datetrack_update_mode);
1139: --hr_utility.trace(l_asg_details.assignment_id);
1140: --hr_utility.trace(l_asg_details.assignment_number);
1141: --hr_utility.trace(l_asg_details.effective_start_date);
1142: --hr_utility.trace(l_asg_details.effective_end_date);
1143: --hr_utility.trace(fnd_date.canonical_to_date(p_date));
1144: --hr_utility.trace(hr_general.end_of_time);
1145:
1146: --fnd_file.put_line(fnd_file.log,l_asg_details.assignment_id);

Line 1143: --hr_utility.trace(fnd_date.canonical_to_date(p_date));

1139: --hr_utility.trace(l_asg_details.assignment_id);
1140: --hr_utility.trace(l_asg_details.assignment_number);
1141: --hr_utility.trace(l_asg_details.effective_start_date);
1142: --hr_utility.trace(l_asg_details.effective_end_date);
1143: --hr_utility.trace(fnd_date.canonical_to_date(p_date));
1144: --hr_utility.trace(hr_general.end_of_time);
1145:
1146: --fnd_file.put_line(fnd_file.log,l_asg_details.assignment_id);
1147: l_soft_coding_keyflex_id := NULL; -- Bug 5763286

Line 1144: --hr_utility.trace(hr_general.end_of_time);

1140: --hr_utility.trace(l_asg_details.assignment_number);
1141: --hr_utility.trace(l_asg_details.effective_start_date);
1142: --hr_utility.trace(l_asg_details.effective_end_date);
1143: --hr_utility.trace(fnd_date.canonical_to_date(p_date));
1144: --hr_utility.trace(hr_general.end_of_time);
1145:
1146: --fnd_file.put_line(fnd_file.log,l_asg_details.assignment_id);
1147: l_soft_coding_keyflex_id := NULL; -- Bug 5763286
1148: hr_nl_assignment_api.update_nl_emp_asg

Line 1174: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');

1170: Exception
1171: WHEN others THEN
1172: --12608988 Start
1173: /*
1174: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1175: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1176: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1177: hr_utility.raise_error;
1178: */

Line 1175: hr_utility.set_message_token('2',substr(sqlerrm,1,200));

1171: WHEN others THEN
1172: --12608988 Start
1173: /*
1174: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1175: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1176: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1177: hr_utility.raise_error;
1178: */
1179: exceptions_count := exceptions_count+1;

Line 1176: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);

1172: --12608988 Start
1173: /*
1174: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1175: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1176: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1177: hr_utility.raise_error;
1178: */
1179: exceptions_count := exceptions_count+1;
1180: tab_exceptions(exceptions_count) :=

Line 1177: hr_utility.raise_error;

1173: /*
1174: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1175: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1176: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1177: hr_utility.raise_error;
1178: */
1179: exceptions_count := exceptions_count+1;
1180: tab_exceptions(exceptions_count) :=
1181: rpad(substr(l_asg_details.assignment_number,1,20),22,' ') ||

Line 1289: --hr_utility.trace_on(NULL,'NL_LYS');

1285: l_datetrack_update_mode varchar2(2000);
1286:
1287:
1288: Begin
1289: --hr_utility.trace_on(NULL,'NL_LYS');
1290: if g_debug then
1291: hr_utility.set_location('Inside update_assignments: p_person_id'||p_person_id,900);
1292: hr_utility.set_location('Inside update_assignments: p_effective_date'||p_effective_date,900);
1293: hr_utility.set_location('Inside update_assignments: p_override_value'||p_override_value,900);

Line 1291: hr_utility.set_location('Inside update_assignments: p_person_id'||p_person_id,900);

1287:
1288: Begin
1289: --hr_utility.trace_on(NULL,'NL_LYS');
1290: if g_debug then
1291: hr_utility.set_location('Inside update_assignments: p_person_id'||p_person_id,900);
1292: hr_utility.set_location('Inside update_assignments: p_effective_date'||p_effective_date,900);
1293: hr_utility.set_location('Inside update_assignments: p_override_value'||p_override_value,900);
1294: end if;
1295:

Line 1292: hr_utility.set_location('Inside update_assignments: p_effective_date'||p_effective_date,900);

1288: Begin
1289: --hr_utility.trace_on(NULL,'NL_LYS');
1290: if g_debug then
1291: hr_utility.set_location('Inside update_assignments: p_person_id'||p_person_id,900);
1292: hr_utility.set_location('Inside update_assignments: p_effective_date'||p_effective_date,900);
1293: hr_utility.set_location('Inside update_assignments: p_override_value'||p_override_value,900);
1294: end if;
1295:
1296: FOR l_assignment IN get_all_assignments(p_person_id ,p_effective_date) LOOP

Line 1293: hr_utility.set_location('Inside update_assignments: p_override_value'||p_override_value,900);

1289: --hr_utility.trace_on(NULL,'NL_LYS');
1290: if g_debug then
1291: hr_utility.set_location('Inside update_assignments: p_person_id'||p_person_id,900);
1292: hr_utility.set_location('Inside update_assignments: p_effective_date'||p_effective_date,900);
1293: hr_utility.set_location('Inside update_assignments: p_override_value'||p_override_value,900);
1294: end if;
1295:
1296: FOR l_assignment IN get_all_assignments(p_person_id ,p_effective_date) LOOP
1297:

Line 1299: hr_utility.set_location('Inside update_assignments: l_object_version_number'||l_object_version_number,1000);

1295:
1296: FOR l_assignment IN get_all_assignments(p_person_id ,p_effective_date) LOOP
1297:
1298: if g_debug then
1299: hr_utility.set_location('Inside update_assignments: l_object_version_number'||l_object_version_number,1000);
1300: hr_utility.set_location('Inside update_assignments: p_override_value'||p_override_value,1000);
1301: end if;
1302: /* l_datetrack_update_mode:='UPDATE';
1303:

Line 1300: hr_utility.set_location('Inside update_assignments: p_override_value'||p_override_value,1000);

1296: FOR l_assignment IN get_all_assignments(p_person_id ,p_effective_date) LOOP
1297:
1298: if g_debug then
1299: hr_utility.set_location('Inside update_assignments: l_object_version_number'||l_object_version_number,1000);
1300: hr_utility.set_location('Inside update_assignments: p_override_value'||p_override_value,1000);
1301: end if;
1302: /* l_datetrack_update_mode:='UPDATE';
1303:
1304: if g_debug then

Line 1305: hr_utility.set_location('Inside l_assignment.effective_start_date'||l_assignment.effective_start_date,1150);

1301: end if;
1302: /* l_datetrack_update_mode:='UPDATE';
1303:
1304: if g_debug then
1305: hr_utility.set_location('Inside l_assignment.effective_start_date'||l_assignment.effective_start_date,1150);
1306: hr_utility.set_location('Inside l_assignment.effective_end_date'||l_assignment.effective_end_date,1150);
1307: end if;
1308:
1309: IF p_effective_date = l_assignment.effective_start_date THEN

Line 1306: hr_utility.set_location('Inside l_assignment.effective_end_date'||l_assignment.effective_end_date,1150);

1302: /* l_datetrack_update_mode:='UPDATE';
1303:
1304: if g_debug then
1305: hr_utility.set_location('Inside l_assignment.effective_start_date'||l_assignment.effective_start_date,1150);
1306: hr_utility.set_location('Inside l_assignment.effective_end_date'||l_assignment.effective_end_date,1150);
1307: end if;
1308:
1309: IF p_effective_date = l_assignment.effective_start_date THEN
1310: l_datetrack_update_mode:='CORRECTION';

Line 1316: hr_utility.set_location('Inside l_datetrack_update_mode'||l_datetrack_update_mode,1200);

1312: l_datetrack_update_mode := 'UPDATE_CHANGE_INSERT';
1313: END IF; */
1314:
1315: if g_debug then
1316: hr_utility.set_location('Inside l_datetrack_update_mode'||l_datetrack_update_mode,1200);
1317: hr_utility.set_location('Inside p_assignment_id'||p_assignment_id,1200);
1318: hr_utility.set_location('Inside l_assignment.assignment_id'||l_assignment.assignment_id,1200);
1319: hr_utility.set_location('Inside l_assignment.segment12'||l_assignment.segment12,1200);
1320: hr_utility.set_location('Inside update_assignments: p_override_value'||fnd_number.number_to_canonical(p_override_value),1200);

Line 1317: hr_utility.set_location('Inside p_assignment_id'||p_assignment_id,1200);

1313: END IF; */
1314:
1315: if g_debug then
1316: hr_utility.set_location('Inside l_datetrack_update_mode'||l_datetrack_update_mode,1200);
1317: hr_utility.set_location('Inside p_assignment_id'||p_assignment_id,1200);
1318: hr_utility.set_location('Inside l_assignment.assignment_id'||l_assignment.assignment_id,1200);
1319: hr_utility.set_location('Inside l_assignment.segment12'||l_assignment.segment12,1200);
1320: hr_utility.set_location('Inside update_assignments: p_override_value'||fnd_number.number_to_canonical(p_override_value),1200);
1321: end if;

Line 1318: hr_utility.set_location('Inside l_assignment.assignment_id'||l_assignment.assignment_id,1200);

1314:
1315: if g_debug then
1316: hr_utility.set_location('Inside l_datetrack_update_mode'||l_datetrack_update_mode,1200);
1317: hr_utility.set_location('Inside p_assignment_id'||p_assignment_id,1200);
1318: hr_utility.set_location('Inside l_assignment.assignment_id'||l_assignment.assignment_id,1200);
1319: hr_utility.set_location('Inside l_assignment.segment12'||l_assignment.segment12,1200);
1320: hr_utility.set_location('Inside update_assignments: p_override_value'||fnd_number.number_to_canonical(p_override_value),1200);
1321: end if;
1322:

Line 1319: hr_utility.set_location('Inside l_assignment.segment12'||l_assignment.segment12,1200);

1315: if g_debug then
1316: hr_utility.set_location('Inside l_datetrack_update_mode'||l_datetrack_update_mode,1200);
1317: hr_utility.set_location('Inside p_assignment_id'||p_assignment_id,1200);
1318: hr_utility.set_location('Inside l_assignment.assignment_id'||l_assignment.assignment_id,1200);
1319: hr_utility.set_location('Inside l_assignment.segment12'||l_assignment.segment12,1200);
1320: hr_utility.set_location('Inside update_assignments: p_override_value'||fnd_number.number_to_canonical(p_override_value),1200);
1321: end if;
1322:
1323: IF p_assignment_id <> l_assignment.assignment_id and /*4606747*/ nvl(p_override_value,0) <> nvl(fnd_number.canonical_to_number(l_assignment.segment12),0) THEN

Line 1320: hr_utility.set_location('Inside update_assignments: p_override_value'||fnd_number.number_to_canonical(p_override_value),1200);

1316: hr_utility.set_location('Inside l_datetrack_update_mode'||l_datetrack_update_mode,1200);
1317: hr_utility.set_location('Inside p_assignment_id'||p_assignment_id,1200);
1318: hr_utility.set_location('Inside l_assignment.assignment_id'||l_assignment.assignment_id,1200);
1319: hr_utility.set_location('Inside l_assignment.segment12'||l_assignment.segment12,1200);
1320: hr_utility.set_location('Inside update_assignments: p_override_value'||fnd_number.number_to_canonical(p_override_value),1200);
1321: end if;
1322:
1323: IF p_assignment_id <> l_assignment.assignment_id and /*4606747*/ nvl(p_override_value,0) <> nvl(fnd_number.canonical_to_number(l_assignment.segment12),0) THEN
1324: hr_utility.set_location('Inside If '||l_assignment.segment12,1200);

Line 1324: hr_utility.set_location('Inside If '||l_assignment.segment12,1200);

1320: hr_utility.set_location('Inside update_assignments: p_override_value'||fnd_number.number_to_canonical(p_override_value),1200);
1321: end if;
1322:
1323: IF p_assignment_id <> l_assignment.assignment_id and /*4606747*/ nvl(p_override_value,0) <> nvl(fnd_number.canonical_to_number(l_assignment.segment12),0) THEN
1324: hr_utility.set_location('Inside If '||l_assignment.segment12,1200);
1325: l_soft_coding_keyflex_id := NULL; -- Bug 5763286
1326: hr_nl_assignment_api.update_nl_emp_asg
1327: (p_validate => FALSE
1328: ,p_effective_date => p_effective_date

Line 1351: hr_utility.set_location('In update_assignments SQLERRM'||SQLERRM||'SQLCODE'||SQLCODE,2000);

1347: END LOOP;
1348: --commit; /*commented for bug 4058149 */
1349: Exception
1350: When Others Then
1351: hr_utility.set_location('In update_assignments SQLERRM'||SQLERRM||'SQLCODE'||SQLCODE,2000);
1352:
1353: End update_assignments;
1354: END pay_nl_eoy_pkg;