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_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.5 2007/01/17 06:44:29 gkhangar noship $ */
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 165: IF (hr_utility.chk_product_install('Oracle Payroll','NL')) THEN

161: l_special_rate_income_add :=0;
162: l_sum_prev_year_income :=0;
163: l_prev_year_income :=0;
164:
165: IF (hr_utility.chk_product_install('Oracle Payroll','NL')) THEN
166: null;
167: ELSE
168: return 0;
169: END IF;

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

167: ELSE
168: return 0;
169: END IF;
170:
171: --hr_utility.trace_on(null,'GR');
172: --OPEN get_dp_period(payroll_action_id);
173: --FETCH get_dp_period INTO l_dp_start_date,l_dp_end_date;
174: --CLOSE get_dp_period;
175:

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

175:
176: /* Determine the previous year and current year e.g. 2003 and 2004 respectively.*/
177: l_current_year:=TO_CHAR(p_effective_date,'YYYY');
178: l_prev_year:=l_current_year-1;
179: --hr_utility.trace_on(NULL,'NL_PREV');
180: --if g_debug then
181: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year'||l_prev_year,2000);
182: --end if;
183:

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

177: l_current_year:=TO_CHAR(p_effective_date,'YYYY');
178: l_prev_year:=l_current_year-1;
179: --hr_utility.trace_on(NULL,'NL_PREV');
180: --if g_debug then
181: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year'||l_prev_year,2000);
182: --end if;
183:
184: l_curr_year_start_date:=TO_DATE('01/'||'01/'||l_current_year,'DD/MM/YYYY');
185: l_prev_year_start_date:=TO_DATE('01/'||'01/'||l_prev_year,'DD/MM/YYYY');

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

185: l_prev_year_start_date:=TO_DATE('01/'||'01/'||l_prev_year,'DD/MM/YYYY');
186: l_prev_year_end_date :=TO_DATE('31/'||'12/'||l_prev_year,'DD/MM/YYYY');
187:
188: --if g_debug then
189: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,2100);
190: --end if;
191:
192:
193:

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

197: l_date_earned =>p_effective_date,
198: l_global_name =>'NL_TAX_HOLIDAY_ALLOWANCE_PERCENTAGE'));
199:
200: --if g_debug then
201: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_hol_allow_perc'||l_hol_allow_perc,2200);
202: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: p_assignment_id'||p_assignment_id,2300);
203: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: p_effective_date'||p_effective_date,2300);
204: --end if;
205:

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

198: l_global_name =>'NL_TAX_HOLIDAY_ALLOWANCE_PERCENTAGE'));
199:
200: --if g_debug then
201: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_hol_allow_perc'||l_hol_allow_perc,2200);
202: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: p_assignment_id'||p_assignment_id,2300);
203: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: p_effective_date'||p_effective_date,2300);
204: --end if;
205:
206: /* LOOP through all assignments for the person, effective in the previous year and current year.*/

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

199:
200: --if g_debug then
201: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_hol_allow_perc'||l_hol_allow_perc,2200);
202: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: p_assignment_id'||p_assignment_id,2300);
203: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: p_effective_date'||p_effective_date,2300);
204: --end if;
205:
206: /* LOOP through all assignments for the person, effective in the previous year and current year.*/
207: FOR l_assignment IN get_all_assignments(p_assignment_id) LOOP

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

216:
217: --FOR l_assignment IN get_all_assignments(p_assignment_id,p_effective_date) LOOP
218:
219: --if g_debug then
220: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: EFFECTIVE_START_DATE'||l_asg_start_date,2400);
221: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: EFFECTIVE_END_DATE'||l_asg_end_date,2400);
222: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: PAYROLL_ID'||l_payroll_id,2400);
223: --end if;
224: l_start_of_the_period:=0;

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

217: --FOR l_assignment IN get_all_assignments(p_assignment_id,p_effective_date) LOOP
218:
219: --if g_debug then
220: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: EFFECTIVE_START_DATE'||l_asg_start_date,2400);
221: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: EFFECTIVE_END_DATE'||l_asg_end_date,2400);
222: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: PAYROLL_ID'||l_payroll_id,2400);
223: --end if;
224: l_start_of_the_period:=0;
225: l_periods_of_year:=0;

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

218:
219: --if g_debug then
220: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: EFFECTIVE_START_DATE'||l_asg_start_date,2400);
221: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: EFFECTIVE_END_DATE'||l_asg_end_date,2400);
222: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: PAYROLL_ID'||l_payroll_id,2400);
223: --end if;
224: l_start_of_the_period:=0;
225: l_periods_of_year:=0;
226: l_periods_in_service:=0;

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

231: OPEN get_start_date_period(l_payroll_id,l_prev_year);
232: FETCH get_start_date_period INTO l_prev_year_start_date,l_dummy,l_dummy_num;
233: CLOSE get_start_date_period;
234:
235: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_asg_start_date'||l_asg_start_date,2400);
236: l_temp_asg_start_date:=l_asg_start_date;
237: IF l_asg_start_date < l_prev_year_start_date THEN
238: l_temp_asg_start_date:= l_prev_year_start_date;
239: END IF;

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

236: l_temp_asg_start_date:=l_asg_start_date;
237: IF l_asg_start_date < l_prev_year_start_date THEN
238: l_temp_asg_start_date:= l_prev_year_start_date;
239: END IF;
240: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_temp_asg_start_date'||l_temp_asg_start_date,2400);
241: FOR l_start_date IN get_start_date_period(l_payroll_id,l_prev_year) LOOP
242:
243: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_start_date.START_DATE'||l_start_date.START_DATE,2410);
244:

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

239: END IF;
240: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_temp_asg_start_date'||l_temp_asg_start_date,2400);
241: FOR l_start_date IN get_start_date_period(l_payroll_id,l_prev_year) LOOP
242:
243: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_start_date.START_DATE'||l_start_date.START_DATE,2410);
244:
245: IF l_start_date.START_DATE = l_temp_asg_start_date THEN
246: l_start_of_the_period:=1;
247: END IF;

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

245: IF l_start_date.START_DATE = l_temp_asg_start_date THEN
246: l_start_of_the_period:=1;
247: END IF;
248: l_periods_of_year:=l_periods_of_year+1;
249: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_start_of_the_period'||l_start_of_the_period,2420);
250: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2420);
251:
252: IF l_temp_asg_start_date >= l_start_date.START_DATE THEN
253:

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

246: l_start_of_the_period:=1;
247: END IF;
248: l_periods_of_year:=l_periods_of_year+1;
249: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_start_of_the_period'||l_start_of_the_period,2420);
250: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2420);
251:
252: IF l_temp_asg_start_date >= l_start_date.START_DATE THEN
253:
254: l_first_period:=l_start_date.PERIOD_NUM;

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

253:
254: l_first_period:=l_start_date.PERIOD_NUM;
255: l_period_start_date:=l_start_date.START_DATE;
256: l_period_end_date:=l_start_date.END_DATE;
257: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_first_period'||l_first_period,2430);
258: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_period_start_date'||l_period_start_date,2430);
259: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_period_end_date'||l_period_end_date,2430);
260: END IF;
261: --IF l_start_date.START_DATE >= l_asg_end_date and l_last_period is null THEN

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

254: l_first_period:=l_start_date.PERIOD_NUM;
255: l_period_start_date:=l_start_date.START_DATE;
256: l_period_end_date:=l_start_date.END_DATE;
257: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_first_period'||l_first_period,2430);
258: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_period_start_date'||l_period_start_date,2430);
259: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_period_end_date'||l_period_end_date,2430);
260: END IF;
261: --IF l_start_date.START_DATE >= l_asg_end_date and l_last_period is null THEN
262: --l_last_period:=l_start_date.PERIOD_NUM;

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

255: l_period_start_date:=l_start_date.START_DATE;
256: l_period_end_date:=l_start_date.END_DATE;
257: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_first_period'||l_first_period,2430);
258: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_period_start_date'||l_period_start_date,2430);
259: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_period_end_date'||l_period_end_date,2430);
260: END IF;
261: --IF l_start_date.START_DATE >= l_asg_end_date and l_last_period is null THEN
262: --l_last_period:=l_start_date.PERIOD_NUM;
263: --END IF;

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

260: END IF;
261: --IF l_start_date.START_DATE >= l_asg_end_date and l_last_period is null THEN
262: --l_last_period:=l_start_date.PERIOD_NUM;
263: --END IF;
264: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_last_period'||l_last_period,2440);
265: IF l_start_date.PERIOD_NUM=1 THEN
266: l_prev_year_start_date:=l_start_date.START_DATE;
267: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_start_date'||l_prev_year_start_date,2440);
268: END IF;

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

263: --END IF;
264: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_last_period'||l_last_period,2440);
265: IF l_start_date.PERIOD_NUM=1 THEN
266: l_prev_year_start_date:=l_start_date.START_DATE;
267: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_start_date'||l_prev_year_start_date,2440);
268: END IF;
269: l_prev_year_end_date:=l_start_date.END_DATE;
270: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: PAYROLL_ID'||l_payroll_id,2450);
271: END LOOP;

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

266: l_prev_year_start_date:=l_start_date.START_DATE;
267: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_start_date'||l_prev_year_start_date,2440);
268: END IF;
269: l_prev_year_end_date:=l_start_date.END_DATE;
270: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: PAYROLL_ID'||l_payroll_id,2450);
271: END LOOP;
272:
273: --if g_debug then
274: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2500);

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

270: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: PAYROLL_ID'||l_payroll_id,2450);
271: END LOOP;
272:
273: --if g_debug then
274: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2500);
275: --end if;
276: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2500);
277: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_first_period'||l_first_period,2500);
278:

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

272:
273: --if g_debug then
274: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2500);
275: --end if;
276: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2500);
277: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_first_period'||l_first_period,2500);
278:
279: l_periods_in_service:=l_periods_of_year - l_first_period;
280: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_in_service'||l_periods_in_service,2501);

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

273: --if g_debug then
274: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2500);
275: --end if;
276: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2500);
277: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_first_period'||l_first_period,2500);
278:
279: l_periods_in_service:=l_periods_of_year - l_first_period;
280: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_in_service'||l_periods_in_service,2501);
281: l_periods_in_service:=l_periods_in_service+1;

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

276: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2500);
277: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_first_period'||l_first_period,2500);
278:
279: l_periods_in_service:=l_periods_of_year - l_first_period;
280: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_in_service'||l_periods_in_service,2501);
281: l_periods_in_service:=l_periods_in_service+1;
282:
283: /*IF l_asg_end_date < l_prev_year_end_date THEN
284: l_periods_after_last_period:=l_periods_of_year - l_last_period + 1;

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

281: l_periods_in_service:=l_periods_in_service+1;
282:
283: /*IF l_asg_end_date < l_prev_year_end_date THEN
284: l_periods_after_last_period:=l_periods_of_year - l_last_period + 1;
285: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_after_last_period'||l_periods_after_last_period,2502);
286: l_periods_in_service:=l_periods_in_service - l_periods_after_last_period;
287: END IF;*/
288:
289: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2503);

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

285: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_after_last_period'||l_periods_after_last_period,2502);
286: l_periods_in_service:=l_periods_in_service - l_periods_after_last_period;
287: END IF;*/
288:
289: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2503);
290: --if g_debug then
291: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_in_service'||l_periods_in_service,2504);
292: --end if;
293: OPEN get_start_date_period(l_payroll_id,l_current_year);

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

287: END IF;*/
288:
289: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,2503);
290: --if g_debug then
291: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_in_service'||l_periods_in_service,2504);
292: --end if;
293: OPEN get_start_date_period(l_payroll_id,l_current_year);
294: FETCH get_start_date_period INTO l_curr_year_start_date,l_dummy,l_dummy_num;
295: CLOSE get_start_date_period;

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

358: );
359: END IF;
360:
361: --if g_debug then
362: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_std_tax_income'||l_std_tax_income,2600);
363: --end if;
364: IF l_periods_in_service IS NULL OR l_periods_in_service=0 THEN
365: l_periods_in_service:=1;
366: END IF;

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

399: l_sum_prev_year_income:=l_sum_prev_year_income + l_std_tax_income + l_spl_tax_income + l_retrostd_tax_income +
400: l_retrostdcurrq_tax_income + l_retrospl_tax_income;
401:
402: --if g_debug then
403: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_prev_year_income'||l_sum_prev_year_income,2800);
404: --end if;
405:
406: /* If assignment started at the beginning of a period in the previous year.*/
407: 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 410: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,2900);

406: /* If assignment started at the beginning of a period in the previous year.*/
407: 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
408:
409: --if g_debug then
410: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,2900);
411: --end if;
412: /* Add together the values of balances Standard Taxable Income, Special Taxable
413: Income, Retro Standard Taxable Income, Retro Standard Taxable Income
414: Current Quarter and Retro Special Taxable Income for the previous year.*/

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

417: l_retrostdcurrq_tax_income + l_retrospl_tax_income;
418:
419:
420: --if g_debug then
421: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_hol_allow_pay_income'||l_hol_allow_pay_income,3000);
422: --end if;
423: /* Remove the value of balance Holiday Allowance Payment for the previous year. */
424:
425: l_prev_year_income:= l_prev_year_income - l_hol_allow_pay_income;

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

425: l_prev_year_income:= l_prev_year_income - l_hol_allow_pay_income;
426:
427: /* Divide the total by the number of payroll periods in service.*/
428: --if g_debug then
429: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,3100);
430: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_in_service'||l_periods_in_service,3200);
431: --end if;
432: l_prev_year_income:= l_prev_year_income/l_periods_in_service;
433: /* Multiply by the total number of payroll periods in the year to provide the estimated taxable income for the previous year */

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

426:
427: /* Divide the total by the number of payroll periods in service.*/
428: --if g_debug then
429: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,3100);
430: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_in_service'||l_periods_in_service,3200);
431: --end if;
432: l_prev_year_income:= l_prev_year_income/l_periods_in_service;
433: /* Multiply by the total number of payroll periods in the year to provide the estimated taxable income for the previous year */
434: --if g_debug then

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

431: --end if;
432: l_prev_year_income:= l_prev_year_income/l_periods_in_service;
433: /* Multiply by the total number of payroll periods in the year to provide the estimated taxable income for the previous year */
434: --if g_debug then
435: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,3300);
436: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,3300);
437: --end if;
438: l_prev_year_income:=l_prev_year_income * l_periods_of_year;
439:

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

432: l_prev_year_income:= l_prev_year_income/l_periods_in_service;
433: /* Multiply by the total number of payroll periods in the year to provide the estimated taxable income for the previous year */
434: --if g_debug then
435: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_periods_of_year'||l_periods_of_year,3300);
436: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,3300);
437: --end if;
438: l_prev_year_income:=l_prev_year_income * l_periods_of_year;
439:
440:

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

447: --Bug 3479044
448: l_sum_hol_allow_tax_income:=l_sum_hol_allow_tax_income-l_hol_allow_pay_income;
449:
450: --if g_debug then
451: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_allow_tax_income'||l_sum_hol_allow_tax_income,3400);
452: --end if;
453: l_sum_hol_allow_tax_income:= l_sum_hol_allow_tax_income/l_periods_in_service;
454: l_sum_hol_allow_tax_income:=l_sum_hol_allow_tax_income * l_periods_of_year;
455:

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

453: l_sum_hol_allow_tax_income:= l_sum_hol_allow_tax_income/l_periods_in_service;
454: l_sum_hol_allow_tax_income:=l_sum_hol_allow_tax_income * l_periods_of_year;
455:
456: --if g_debug then
457: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_allow_tax_income'||l_sum_hol_allow_tax_income,3500);
458: --end if;
459: l_estimated_hol_allow:=l_sum_hol_allow_tax_income * l_hol_allow_perc/100;
460:
461: --if g_debug then

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

458: --end if;
459: l_estimated_hol_allow:=l_sum_hol_allow_tax_income * l_hol_allow_perc/100;
460:
461: --if g_debug then
462: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_estimated_hol_allow'||l_estimated_hol_allow,3600);
463: --end if;
464: /* Add the estimated holiday allowance to the estimated taxable income, to provide
465: the previous year?s taxable income for this assignment */
466:

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

469:
470: l_sum_prev_year_income:=l_sum_prev_year_income +l_prev_year_income;
471:
472: --if g_debug then
473: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,3700);
474: --end if;
475: /* If the assignment started part way through a period in the previous year */
476: ELSIF l_asg_end_date >= l_prev_year_start_date AND l_asg_start_date < l_curr_year_start_date THEN
477:

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

480:
481: l_week_days:= pay_nl_si_pkg.get_week_days(l_asg_start_date,l_period_end_date);
482:
483: --if g_debug then
484: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_week_days'||l_week_days,3800);
485: --end if;
486: IF l_week_days IS NULL OR l_week_days=0 THEN
487: l_week_days:=1;
488: END IF;

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

494: IF l_total_week_days IS NULL THEN
495: l_total_week_days:=0;
496: END IF;
497: --if g_debug then
498: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_total_week_days'||l_total_week_days,3900);
499: --end if;
500:
501: /*Add together the balances Standard Taxable Income, Special Taxable
502: Income, Retro Standard Taxable Income, Retro Standard Taxable Income

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

504:
505: l_first_period_income:= l_std_tax_income_ptd + l_spl_tax_income_ptd + l_retrostd_tax_income_ptd +
506: l_retrostdcurrq_tax_income_ptd + l_retrospl_tax_income_ptd;
507: --if g_debug then
508: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_first_period_income'||l_first_period_income,4000);
509: --end if;
510:
511: l_prev_year_income:= l_std_tax_income + l_spl_tax_income + l_retrostd_tax_income +
512: l_retrostdcurrq_tax_income + l_retrospl_tax_income;

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

510:
511: l_prev_year_income:= l_std_tax_income + l_spl_tax_income + l_retrostd_tax_income +
512: l_retrostdcurrq_tax_income + l_retrospl_tax_income;
513: --if g_debug then
514: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,4100);
515: --end if;
516:
517: l_prev_year_income:=l_prev_year_income - l_first_period_income;
518:

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

516:
517: l_prev_year_income:=l_prev_year_income - l_first_period_income;
518:
519: --if g_debug then
520: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,4200);
521: --end if;
522:
523: /*Then divide this by the number of week days worked and then multiply by the number
524: of week days in the period. This will provide an estimated taxable income for the

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

528:
529: l_first_period_income:=l_first_period_income/l_week_days;
530: l_first_period_income:=l_first_period_income * l_total_week_days;
531: --if g_debug then
532: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_first_period_income'||l_first_period_income,4300);
533: --end if;
534:
535: /*Add together the balances Standard Taxable Income, Special Taxable
536: Income, Retro Standard Taxable Income, Retro Standard Taxable Income

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

545: /*Then add this total to the estimated taxable income for the first period. */
546: l_prev_year_income:=l_prev_year_income + l_first_period_income;
547:
548: --if g_debug then
549: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,4500);
550: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_hol_allow_pay_income'||l_hol_allow_pay_income,4400);
551: --end if;
552: /*Remove the value of balance Holiday Allowance Payment for the previous year.*/
553:

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

546: l_prev_year_income:=l_prev_year_income + l_first_period_income;
547:
548: --if g_debug then
549: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,4500);
550: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_hol_allow_pay_income'||l_hol_allow_pay_income,4400);
551: --end if;
552: /*Remove the value of balance Holiday Allowance Payment for the previous year.*/
553:
554: -- l_prev_year_income:=l_prev_year_income - l_hol_allow_pay_income;

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

553:
554: -- l_prev_year_income:=l_prev_year_income - l_hol_allow_pay_income;
555:
556: --if g_debug then
557: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,4600);
558: --end if;
559: /*Divide the total by the number of periods in service (including the part period and
560: treating this as a full period).*/
561:

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

560: treating this as a full period).*/
561:
562: l_prev_year_income:= l_prev_year_income/l_periods_in_service;
563: --if g_debug then
564: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,4700);
565: --end if;
566: /*Multiply by the total number of payroll periods in the year, to provide the
567: estimated taxable income for the previous year.*/
568:

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

567: estimated taxable income for the previous year.*/
568:
569: l_prev_year_income:=l_prev_year_income * l_periods_of_year;
570: --if g_debug then
571: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,4800);
572: --end if;
573: /*Calculate the estimated value for holiday allowance as a percentage of an
574: adjusted total of balances Holiday Allowance Taxable Income and Retro Holiday
575: Allowance Taxable Income in the previous year.*/

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

575: Allowance Taxable Income in the previous year.*/
576:
577: l_sum_hol_first_period:=l_hol_allow_tax_income_ptd + l_rethol_allow_tax_income_ptd;
578: --if g_debug then
579: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_first_period'||l_sum_hol_first_period,4900);
580: --end if;
581: l_sum_hol_prev_year:=l_hol_allow_tax_income + l_retrohol_allow_tax_income;
582:
583: --if g_debug then

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

580: --end if;
581: l_sum_hol_prev_year:=l_hol_allow_tax_income + l_retrohol_allow_tax_income;
582:
583: --if g_debug then
584: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_prev_year'||l_sum_hol_prev_year,5000);
585: --end if;
586:
587: /*convert the holiday allowance taxable income for the first part period to an estimated value
588: for the whole period, adding this to the holiday allowance taxable income for the

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

590: by the total number of payroll periods in the year. */
591:
592: l_sum_hol_prev_year:=l_sum_hol_prev_year - l_sum_hol_first_period;
593: --if g_debug then
594: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_prev_year'||l_sum_hol_prev_year,5100);
595: --end if;
596: l_sum_hol_first_period:=l_sum_hol_first_period - l_hol_allow_pay_income_ptd;
597:
598: l_sum_hol_first_period:=l_sum_hol_first_period/l_week_days;

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

597:
598: l_sum_hol_first_period:=l_sum_hol_first_period/l_week_days;
599:
600: --if g_debug then
601: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_first_period'||l_sum_hol_first_period,5200);
602: --end if;
603:
604: l_sum_hol_first_period:=l_sum_hol_first_period * l_total_week_days;
605:

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

603:
604: l_sum_hol_first_period:=l_sum_hol_first_period * l_total_week_days;
605:
606: --if g_debug then
607: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_first_period'||l_sum_hol_first_period,5300);
608: --end if;
609: l_sum_hol_prev_year:=l_sum_hol_prev_year - l_hol_allow_pay_income;
610:
611: l_sum_hol_prev_year:=l_sum_hol_prev_year + l_sum_hol_first_period;

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

610:
611: l_sum_hol_prev_year:=l_sum_hol_prev_year + l_sum_hol_first_period;
612:
613: --if g_debug then
614: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_prev_year'||l_sum_hol_prev_year,5400);
615: --end if;
616:
617: l_sum_hol_prev_year:=l_sum_hol_prev_year/l_periods_in_service;
618:

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

616:
617: l_sum_hol_prev_year:=l_sum_hol_prev_year/l_periods_in_service;
618:
619: --if g_debug then
620: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_prev_year'||l_sum_hol_prev_year,5500);
621: --end if;
622:
623: l_sum_hol_prev_year:=l_sum_hol_prev_year * l_periods_of_year;
624:

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

622:
623: l_sum_hol_prev_year:=l_sum_hol_prev_year * l_periods_of_year;
624:
625: --if g_debug then
626: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_hol_prev_year'||l_sum_hol_prev_year,5600);
627: --end if;
628:
629: l_estimated_hol_allow:=l_sum_hol_prev_year * l_hol_allow_perc/100;
630:

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

628:
629: l_estimated_hol_allow:=l_sum_hol_prev_year * l_hol_allow_perc/100;
630:
631: --if g_debug then
632: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_estimated_hol_allow'||l_estimated_hol_allow,5700);
633: --end if;
634: /* Add the estimated holiday allowance to the estimated taxable income, to provide
635: the previous year?s taxable income for this assignment. */
636:

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

635: the previous year?s taxable income for this assignment. */
636:
637: l_prev_year_income:=l_prev_year_income +l_estimated_hol_allow;
638: --if g_debug then
639: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_prev_year_income'||l_prev_year_income,5800);
640: --end if;
641:
642: l_sum_prev_year_income:=l_sum_prev_year_income +l_prev_year_income;
643: --if g_debug then

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

640: --end if;
641:
642: l_sum_prev_year_income:=l_sum_prev_year_income +l_prev_year_income;
643: --if g_debug then
644: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME: l_sum_prev_year_income'||l_sum_prev_year_income,5900);
645: --end if;
646:
647: END IF;
648:

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

651:
652: --
653: l_type := 'DP';
654: IF p_payroll_action_id <> -1 THEN
655: hr_utility.trace('~~VV3');
656: l_ass_act_id := NULL;
657: OPEN get_ass_act_id(l_assignment.assignment_id,l_current_period_start_date,l_current_period_end_date);
658: FETCH get_ass_act_id INTO l_ass_act_id;
659: CLOSE get_ass_act_id;

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

662: ,l_assignment.assignment_id
663: ,l_ass_act_id);
664: --
665:
666: hr_utility.trace('~~VV l_type : '||l_type);
667: IF l_type = 'DE' THEN
668: l_spl_rate_income_dbaid_ptd:=pay_nl_general.get_defined_balance_id('SPECIAL_RATE_INCOME_ASG_BDATE_PTD');
669: IF l_ass_act_id is NOT NULL THEN
670: l_special_rate_income_ptd :=pay_balance_pkg.get_value(p_defined_balance_id=> l_spl_rate_income_dbaid_ptd

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

697: l_special_rate_income_ptd := 0;
698: END IF;
699: END IF;
700: ELSE
701: hr_utility.trace('~~VV 2');
702: l_spl_rate_income_dbaid_ptd:=pay_nl_general.get_defined_balance_id('SPECIAL_RATE_INCOME_ASG_PTD');
703: l_special_rate_income_ptd :=pay_balance_pkg.get_value(l_spl_rate_income_dbaid_ptd
704: ,l_assignment.assignment_id,l_current_period_end_date);
705: END IF;

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

731: END IF;
732: END LOOP;
733:
734: --if g_debug then
735: hr_utility.set_location('Inside GET_PREV_YEAR_TAX_INCOME:l_sum_prev_year_income '||l_sum_prev_year_income,6000);
736: --end if;
737: --Return the Previous Year Taxable Income
738: l_sum_prev_year_income:=FLOOR(l_sum_prev_year_income);
739:

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

741:
742: l_sum_prev_year_income:=l_sum_prev_year_income+l_special_rate_annual_income;
743:
744:
745: hr_utility.set_location('~~ Final'|| l_sum_prev_year_income,11111);
746: --hr_utility.trace_off();
747: RETURN l_sum_prev_year_income;
748:
749:

Line 746: --hr_utility.trace_off();

742: l_sum_prev_year_income:=l_sum_prev_year_income+l_special_rate_annual_income;
743:
744:
745: hr_utility.set_location('~~ Final'|| l_sum_prev_year_income,11111);
746: --hr_utility.trace_off();
747: RETURN l_sum_prev_year_income;
748:
749:
750: EXCEPTION

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

748:
749:
750: EXCEPTION
751: WHEN NO_DATA_FOUND THEN
752: hr_utility.set_location('GET_PREV_YEAR_TAX_INCOME'||SQLERRM||SQLCODE,4200);
753: RETURN 0;
754:
755: END GET_PREV_YEAR_TAX_INCOME;
756: --

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

826: l_retrohol_allow_dbalid_ptd :=pay_nl_general.get_defined_balance_id('RETRO_HOLIDAY_ALLOWANCE_TAXABLE_INCOME_ASG_PTD');
827:
828:
829: --if g_debug then
830: hr_utility.set_location('Inside get_balance_values: l_std_tax_dbalid'||l_std_tax_dbalid,2510);
831: --end if;
832:
833: l_std_tax_income :=pay_balance_pkg.get_value(l_std_tax_dbalid
834: ,l_assignment_id

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

845: l_retrospl_tax_income :=pay_balance_pkg.get_value(l_retrospl_tax_dbalid
846: ,l_assignment_id
847: ,l_prev_year_end_date);
848: --if g_debug then
849: hr_utility.set_location('Inside get_balance_values: l_retrospl_tax_income'||l_retrospl_tax_income,2520);
850: --end if;
851:
852: l_hol_allow_pay_income :=pay_balance_pkg.get_value(l_hol_allow_pay_dbalid
853: ,l_assignment_id

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

859: ,l_assignment_id
860: ,l_prev_year_end_date);
861:
862: --if g_debug then
863: hr_utility.set_location('Inside get_balance_values: l_std_tax_dbalid_ptd'||l_std_tax_dbalid_ptd,2530);
864: hr_utility.set_location('Inside get_balance_values: l_assignment_id'||l_assignment_id,2530);
865: hr_utility.set_location('Inside get_balance_values: l_period_end_date'||l_period_end_date,2530);
866: --end if;
867:

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

860: ,l_prev_year_end_date);
861:
862: --if g_debug then
863: hr_utility.set_location('Inside get_balance_values: l_std_tax_dbalid_ptd'||l_std_tax_dbalid_ptd,2530);
864: hr_utility.set_location('Inside get_balance_values: l_assignment_id'||l_assignment_id,2530);
865: hr_utility.set_location('Inside get_balance_values: l_period_end_date'||l_period_end_date,2530);
866: --end if;
867:
868:

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

861:
862: --if g_debug then
863: hr_utility.set_location('Inside get_balance_values: l_std_tax_dbalid_ptd'||l_std_tax_dbalid_ptd,2530);
864: hr_utility.set_location('Inside get_balance_values: l_assignment_id'||l_assignment_id,2530);
865: hr_utility.set_location('Inside get_balance_values: l_period_end_date'||l_period_end_date,2530);
866: --end if;
867:
868:
869: l_std_tax_income_ptd :=pay_balance_pkg.get_value(l_std_tax_dbalid_ptd

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

869: l_std_tax_income_ptd :=pay_balance_pkg.get_value(l_std_tax_dbalid_ptd
870: ,l_assignment_id
871: ,l_period_end_date);
872: --if g_debug then
873: hr_utility.set_location('Inside get_balance_values: l_std_tax_income_ptd'||l_std_tax_income_ptd,2531);
874: --end if;
875:
876: l_spl_tax_income_ptd :=pay_balance_pkg.get_value(l_spl_tax_dbalid_ptd
877: ,l_assignment_id

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

876: l_spl_tax_income_ptd :=pay_balance_pkg.get_value(l_spl_tax_dbalid_ptd
877: ,l_assignment_id
878: ,l_period_end_date);
879: --if g_debug then
880: hr_utility.set_location('Inside get_balance_values: l_spl_tax_income_ptd'||l_spl_tax_income_ptd,2532);
881: --end if;
882:
883: l_retrostd_tax_income_ptd :=pay_balance_pkg.get_value(l_retrostd_tax_dbalid_ptd
884: ,l_assignment_id

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

883: l_retrostd_tax_income_ptd :=pay_balance_pkg.get_value(l_retrostd_tax_dbalid_ptd
884: ,l_assignment_id
885: ,l_period_end_date);
886: --if g_debug then
887: hr_utility.set_location('Inside get_balance_values: l_retrostd_tax_income_ptd'||l_retrostd_tax_income_ptd,2533);
888: --end if;
889:
890: l_retrostdcurrq_tax_income_ptd :=pay_balance_pkg.get_value(l_retrostdcurrq_tax_dbalid_ptd
891: ,l_assignment_id

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

890: l_retrostdcurrq_tax_income_ptd :=pay_balance_pkg.get_value(l_retrostdcurrq_tax_dbalid_ptd
891: ,l_assignment_id
892: ,l_period_end_date);
893: --if g_debug then
894: hr_utility.set_location('Inside get_balance_values: l_retrostdcurrq_tax_income_ptd'||l_retrostdcurrq_tax_income_ptd,2534);
895: --end if;
896:
897: l_retrospl_tax_income_ptd :=pay_balance_pkg.get_value(l_retrospl_tax_dbalid_ptd
898: ,l_assignment_id

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

897: l_retrospl_tax_income_ptd :=pay_balance_pkg.get_value(l_retrospl_tax_dbalid_ptd
898: ,l_assignment_id
899: ,l_period_end_date);
900: --if g_debug then
901: hr_utility.set_location('Inside get_balance_values: l_retrospl_tax_income_ptd'||l_retrospl_tax_income_ptd,2540);
902: --end if;
903:
904: l_hol_allow_pay_income_ptd :=pay_balance_pkg.get_value(l_hol_allow_pay_dbalid_ptd
905: ,l_assignment_id

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

910: l_rethol_allow_tax_income_ptd :=pay_balance_pkg.get_value(l_retrohol_allow_dbalid_ptd
911: ,l_assignment_id
912: ,l_period_end_date);
913: --if g_debug then
914: hr_utility.set_location('Inside get_balance_values: l_rethol_allow_tax_income_ptd'||l_rethol_allow_tax_income_ptd,2550);
915: --end if;
916:
917: Exception
918: WHEN NO_DATA_FOUND THEN

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

915: --end if;
916:
917: Exception
918: WHEN NO_DATA_FOUND THEN
919: hr_utility.set_location('get_balance_values'||SQLERRM||SQLCODE,1200);
920: l_std_tax_income:=0;
921: l_spl_tax_income:=0;
922: l_retrostd_tax_income:=0;
923: l_retrostdcurrq_tax_income:=0;

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

1009: --l_asg_details csr_get_asg_details%ROWTYPE;
1010:
1011:
1012: Begin
1013: --hr_utility.trace_on(null,'RESET_OVERRIDE');
1014: --hr_utility.trace('In reset override');
1015:
1016: retcode := 0;
1017:

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

1010:
1011:
1012: Begin
1013: --hr_utility.trace_on(null,'RESET_OVERRIDE');
1014: --hr_utility.trace('In reset override');
1015:
1016: retcode := 0;
1017:
1018: --------------------------------------------------------------------

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

1028: else
1029: l_datetrack_update_mode := 'UPDATE';
1030: end if;
1031: Begin
1032: --hr_utility.trace(l_datetrack_update_mode);
1033: --hr_utility.trace(l_asg_details.assignment_id);
1034: --hr_utility.trace(l_asg_details.assignment_number);
1035: --hr_utility.trace(l_asg_details.effective_start_date);
1036: --hr_utility.trace(l_asg_details.effective_end_date);

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

1029: l_datetrack_update_mode := 'UPDATE';
1030: end if;
1031: Begin
1032: --hr_utility.trace(l_datetrack_update_mode);
1033: --hr_utility.trace(l_asg_details.assignment_id);
1034: --hr_utility.trace(l_asg_details.assignment_number);
1035: --hr_utility.trace(l_asg_details.effective_start_date);
1036: --hr_utility.trace(l_asg_details.effective_end_date);
1037: --hr_utility.trace(fnd_date.canonical_to_date(p_date));

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

1030: end if;
1031: Begin
1032: --hr_utility.trace(l_datetrack_update_mode);
1033: --hr_utility.trace(l_asg_details.assignment_id);
1034: --hr_utility.trace(l_asg_details.assignment_number);
1035: --hr_utility.trace(l_asg_details.effective_start_date);
1036: --hr_utility.trace(l_asg_details.effective_end_date);
1037: --hr_utility.trace(fnd_date.canonical_to_date(p_date));
1038: --hr_utility.trace(hr_general.end_of_time);

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

1031: Begin
1032: --hr_utility.trace(l_datetrack_update_mode);
1033: --hr_utility.trace(l_asg_details.assignment_id);
1034: --hr_utility.trace(l_asg_details.assignment_number);
1035: --hr_utility.trace(l_asg_details.effective_start_date);
1036: --hr_utility.trace(l_asg_details.effective_end_date);
1037: --hr_utility.trace(fnd_date.canonical_to_date(p_date));
1038: --hr_utility.trace(hr_general.end_of_time);
1039:

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

1032: --hr_utility.trace(l_datetrack_update_mode);
1033: --hr_utility.trace(l_asg_details.assignment_id);
1034: --hr_utility.trace(l_asg_details.assignment_number);
1035: --hr_utility.trace(l_asg_details.effective_start_date);
1036: --hr_utility.trace(l_asg_details.effective_end_date);
1037: --hr_utility.trace(fnd_date.canonical_to_date(p_date));
1038: --hr_utility.trace(hr_general.end_of_time);
1039:
1040: --fnd_file.put_line(fnd_file.log,l_asg_details.assignment_id);

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

1033: --hr_utility.trace(l_asg_details.assignment_id);
1034: --hr_utility.trace(l_asg_details.assignment_number);
1035: --hr_utility.trace(l_asg_details.effective_start_date);
1036: --hr_utility.trace(l_asg_details.effective_end_date);
1037: --hr_utility.trace(fnd_date.canonical_to_date(p_date));
1038: --hr_utility.trace(hr_general.end_of_time);
1039:
1040: --fnd_file.put_line(fnd_file.log,l_asg_details.assignment_id);
1041: l_soft_coding_keyflex_id := NULL; -- Bug 5763286

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

1034: --hr_utility.trace(l_asg_details.assignment_number);
1035: --hr_utility.trace(l_asg_details.effective_start_date);
1036: --hr_utility.trace(l_asg_details.effective_end_date);
1037: --hr_utility.trace(fnd_date.canonical_to_date(p_date));
1038: --hr_utility.trace(hr_general.end_of_time);
1039:
1040: --fnd_file.put_line(fnd_file.log,l_asg_details.assignment_id);
1041: l_soft_coding_keyflex_id := NULL; -- Bug 5763286
1042: hr_nl_assignment_api.update_nl_emp_asg

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

1061: ,p_gsp_post_process_warning => l_gsp_post_process_warning
1062: );
1063: Exception
1064: WHEN others THEN
1065: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1066: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1067: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1068: hr_utility.raise_error;
1069: end;

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

1062: );
1063: Exception
1064: WHEN others THEN
1065: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1066: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1067: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1068: hr_utility.raise_error;
1069: end;
1070: end loop;

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

1063: Exception
1064: WHEN others THEN
1065: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1066: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1067: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1068: hr_utility.raise_error;
1069: end;
1070: end loop;
1071:

Line 1068: hr_utility.raise_error;

1064: WHEN others THEN
1065: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
1066: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
1067: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
1068: hr_utility.raise_error;
1069: end;
1070: end loop;
1071:
1072: End reset_override_lastyr_sal ;

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

1142: l_datetrack_update_mode varchar2(2000);
1143:
1144:
1145: Begin
1146: --hr_utility.trace_on(NULL,'NL_LYS');
1147: if g_debug then
1148: hr_utility.set_location('Inside update_assignments: p_person_id'||p_person_id,900);
1149: hr_utility.set_location('Inside update_assignments: p_effective_date'||p_effective_date,900);
1150: hr_utility.set_location('Inside update_assignments: p_override_value'||p_override_value,900);

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

1144:
1145: Begin
1146: --hr_utility.trace_on(NULL,'NL_LYS');
1147: if g_debug then
1148: hr_utility.set_location('Inside update_assignments: p_person_id'||p_person_id,900);
1149: hr_utility.set_location('Inside update_assignments: p_effective_date'||p_effective_date,900);
1150: hr_utility.set_location('Inside update_assignments: p_override_value'||p_override_value,900);
1151: end if;
1152:

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

1145: Begin
1146: --hr_utility.trace_on(NULL,'NL_LYS');
1147: if g_debug then
1148: hr_utility.set_location('Inside update_assignments: p_person_id'||p_person_id,900);
1149: hr_utility.set_location('Inside update_assignments: p_effective_date'||p_effective_date,900);
1150: hr_utility.set_location('Inside update_assignments: p_override_value'||p_override_value,900);
1151: end if;
1152:
1153: FOR l_assignment IN get_all_assignments(p_person_id ,p_effective_date) LOOP

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

1146: --hr_utility.trace_on(NULL,'NL_LYS');
1147: if g_debug then
1148: hr_utility.set_location('Inside update_assignments: p_person_id'||p_person_id,900);
1149: hr_utility.set_location('Inside update_assignments: p_effective_date'||p_effective_date,900);
1150: hr_utility.set_location('Inside update_assignments: p_override_value'||p_override_value,900);
1151: end if;
1152:
1153: FOR l_assignment IN get_all_assignments(p_person_id ,p_effective_date) LOOP
1154:

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

1152:
1153: FOR l_assignment IN get_all_assignments(p_person_id ,p_effective_date) LOOP
1154:
1155: if g_debug then
1156: hr_utility.set_location('Inside update_assignments: l_object_version_number'||l_object_version_number,1000);
1157: hr_utility.set_location('Inside update_assignments: p_override_value'||p_override_value,1000);
1158: end if;
1159: /* l_datetrack_update_mode:='UPDATE';
1160:

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

1153: FOR l_assignment IN get_all_assignments(p_person_id ,p_effective_date) LOOP
1154:
1155: if g_debug then
1156: hr_utility.set_location('Inside update_assignments: l_object_version_number'||l_object_version_number,1000);
1157: hr_utility.set_location('Inside update_assignments: p_override_value'||p_override_value,1000);
1158: end if;
1159: /* l_datetrack_update_mode:='UPDATE';
1160:
1161: if g_debug then

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

1158: end if;
1159: /* l_datetrack_update_mode:='UPDATE';
1160:
1161: if g_debug then
1162: hr_utility.set_location('Inside l_assignment.effective_start_date'||l_assignment.effective_start_date,1150);
1163: hr_utility.set_location('Inside l_assignment.effective_end_date'||l_assignment.effective_end_date,1150);
1164: end if;
1165:
1166: IF p_effective_date = l_assignment.effective_start_date THEN

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

1159: /* l_datetrack_update_mode:='UPDATE';
1160:
1161: if g_debug then
1162: hr_utility.set_location('Inside l_assignment.effective_start_date'||l_assignment.effective_start_date,1150);
1163: hr_utility.set_location('Inside l_assignment.effective_end_date'||l_assignment.effective_end_date,1150);
1164: end if;
1165:
1166: IF p_effective_date = l_assignment.effective_start_date THEN
1167: l_datetrack_update_mode:='CORRECTION';

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

1169: l_datetrack_update_mode := 'UPDATE_CHANGE_INSERT';
1170: END IF; */
1171:
1172: if g_debug then
1173: hr_utility.set_location('Inside l_datetrack_update_mode'||l_datetrack_update_mode,1200);
1174: hr_utility.set_location('Inside p_assignment_id'||p_assignment_id,1200);
1175: hr_utility.set_location('Inside l_assignment.assignment_id'||l_assignment.assignment_id,1200);
1176: hr_utility.set_location('Inside l_assignment.segment12'||l_assignment.segment12,1200);
1177: hr_utility.set_location('Inside update_assignments: p_override_value'||fnd_number.number_to_canonical(p_override_value),1200);

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

1170: END IF; */
1171:
1172: if g_debug then
1173: hr_utility.set_location('Inside l_datetrack_update_mode'||l_datetrack_update_mode,1200);
1174: hr_utility.set_location('Inside p_assignment_id'||p_assignment_id,1200);
1175: hr_utility.set_location('Inside l_assignment.assignment_id'||l_assignment.assignment_id,1200);
1176: hr_utility.set_location('Inside l_assignment.segment12'||l_assignment.segment12,1200);
1177: hr_utility.set_location('Inside update_assignments: p_override_value'||fnd_number.number_to_canonical(p_override_value),1200);
1178: end if;

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

1171:
1172: if g_debug then
1173: hr_utility.set_location('Inside l_datetrack_update_mode'||l_datetrack_update_mode,1200);
1174: hr_utility.set_location('Inside p_assignment_id'||p_assignment_id,1200);
1175: hr_utility.set_location('Inside l_assignment.assignment_id'||l_assignment.assignment_id,1200);
1176: hr_utility.set_location('Inside l_assignment.segment12'||l_assignment.segment12,1200);
1177: hr_utility.set_location('Inside update_assignments: p_override_value'||fnd_number.number_to_canonical(p_override_value),1200);
1178: end if;
1179:

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

1172: if g_debug then
1173: hr_utility.set_location('Inside l_datetrack_update_mode'||l_datetrack_update_mode,1200);
1174: hr_utility.set_location('Inside p_assignment_id'||p_assignment_id,1200);
1175: hr_utility.set_location('Inside l_assignment.assignment_id'||l_assignment.assignment_id,1200);
1176: hr_utility.set_location('Inside l_assignment.segment12'||l_assignment.segment12,1200);
1177: hr_utility.set_location('Inside update_assignments: p_override_value'||fnd_number.number_to_canonical(p_override_value),1200);
1178: end if;
1179:
1180: 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 1177: hr_utility.set_location('Inside update_assignments: p_override_value'||fnd_number.number_to_canonical(p_override_value),1200);

1173: hr_utility.set_location('Inside l_datetrack_update_mode'||l_datetrack_update_mode,1200);
1174: hr_utility.set_location('Inside p_assignment_id'||p_assignment_id,1200);
1175: hr_utility.set_location('Inside l_assignment.assignment_id'||l_assignment.assignment_id,1200);
1176: hr_utility.set_location('Inside l_assignment.segment12'||l_assignment.segment12,1200);
1177: hr_utility.set_location('Inside update_assignments: p_override_value'||fnd_number.number_to_canonical(p_override_value),1200);
1178: end if;
1179:
1180: 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
1181: hr_utility.set_location('Inside If '||l_assignment.segment12,1200);

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

1177: hr_utility.set_location('Inside update_assignments: p_override_value'||fnd_number.number_to_canonical(p_override_value),1200);
1178: end if;
1179:
1180: 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
1181: hr_utility.set_location('Inside If '||l_assignment.segment12,1200);
1182: l_soft_coding_keyflex_id := NULL; -- Bug 5763286
1183: hr_nl_assignment_api.update_nl_emp_asg
1184: (p_validate => FALSE
1185: ,p_effective_date => p_effective_date

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

1204: END LOOP;
1205: --commit; /*commented for bug 4058149 */
1206: Exception
1207: When Others Then
1208: hr_utility.set_location('In update_assignments SQLERRM'||SQLERRM||'SQLCODE'||SQLCODE,2000);
1209:
1210: End update_assignments;
1211: END pay_nl_eoy_pkg;