APPS.PAY_GTNLOD_PKG dependencies on HR_UTILITY

Line 196: /* hr_utility.trace('view name = '|| l_ded_view_name);

192: l_status number :=0;
193:
194: BEGIN
195: /*-- Bug#4942114 starts -- */
196: /* hr_utility.trace('view name = '|| l_ded_view_name);
197:
198: OPEN cv FOR
199: 'select classification_name,
200: decode(classification_name,'||'''Pre-Tax Deductions'''||','||'''1'''||','||'''Involuntary Deductions'''||','||'''2'''||','||'''Voluntary Deductions'''||','||'''3'''||','||'''9'''||')subclass,

Line 209: hr_utility.trace('statement build success');

205: ' and classification_name in ('||'''Pre-Tax Deductions'''||','
206: ||'''Involuntary Deductions'''||','||
207: '''Voluntary Deductions'''||')';
208:
209: hr_utility.trace('statement build success');
210: */
211: hr_utility.trace('Balance Status1 = '|| p_ded_bal_status1);
212: hr_utility.trace('Balance Status2 = '|| p_ded_bal_status2);
213:

Line 211: hr_utility.trace('Balance Status1 = '|| p_ded_bal_status1);

207: '''Voluntary Deductions'''||')';
208:
209: hr_utility.trace('statement build success');
210: */
211: hr_utility.trace('Balance Status1 = '|| p_ded_bal_status1);
212: hr_utility.trace('Balance Status2 = '|| p_ded_bal_status2);
213:
214: if p_ded_bal_status1 = 'Y' AND p_ded_bal_status2 = 'Y' THEN
215: open csr_ded_rbr;

Line 212: hr_utility.trace('Balance Status2 = '|| p_ded_bal_status2);

208:
209: hr_utility.trace('statement build success');
210: */
211: hr_utility.trace('Balance Status1 = '|| p_ded_bal_status1);
212: hr_utility.trace('Balance Status2 = '|| p_ded_bal_status2);
213:
214: if p_ded_bal_status1 = 'Y' AND p_ded_bal_status2 = 'Y' THEN
215: open csr_ded_rbr;
216: else

Line 229: hr_utility.trace('-'||l_classification_name||'+'||l_subclass||'+'||l_element_name||'+'||l_cash_value||'-');

225: else
226: FETCH csr_ded INTO l_classification_name,l_subclass,l_element_name,l_cash_value;
227: EXIT WHEN csr_ded%NOTFOUND;
228: end if;
229: hr_utility.trace('-'||l_classification_name||'+'||l_subclass||'+'||l_element_name||'+'||l_cash_value||'-');
230:
231: /* FETCH cv INTO l_classification_name,l_subclass,l_element_name,l_cash_value;
232: hr_utility.trace('-'||l_classification_name||'+'||l_subclass||'+'||l_element_name||'+'||l_cash_value||'-');
233: EXIT WHEN cv%NOTFOUND;

Line 232: hr_utility.trace('-'||l_classification_name||'+'||l_subclass||'+'||l_element_name||'+'||l_cash_value||'-');

228: end if;
229: hr_utility.trace('-'||l_classification_name||'+'||l_subclass||'+'||l_element_name||'+'||l_cash_value||'-');
230:
231: /* FETCH cv INTO l_classification_name,l_subclass,l_element_name,l_cash_value;
232: hr_utility.trace('-'||l_classification_name||'+'||l_subclass||'+'||l_element_name||'+'||l_cash_value||'-');
233: EXIT WHEN cv%NOTFOUND;
234: */
235: /*-- Bug#4942114 ends -- */
236: if l_asg_flag <> 'Y' THEN

Line 244: hr_utility.trace('testing 1');

240: if g_totals_table(l_temp_index).attribute5 = l_element_name
241: and g_totals_table(l_temp_index).gre_name = l_gre_name
242: and g_totals_table(l_temp_index).organization_name = l_org_name
243: and g_totals_table(l_temp_index).location_name = l_location_code then
244: hr_utility.trace('testing 1');
245: g_totals_table(l_temp_index).value2 := g_totals_table(l_temp_index).value2 +
246: to_number(l_cash_value);
247: hr_utility.trace('for deductions...l_index ='||l_index);
248: hr_utility.trace('element name ='||l_element_name);

Line 247: hr_utility.trace('for deductions...l_index ='||l_index);

243: and g_totals_table(l_temp_index).location_name = l_location_code then
244: hr_utility.trace('testing 1');
245: g_totals_table(l_temp_index).value2 := g_totals_table(l_temp_index).value2 +
246: to_number(l_cash_value);
247: hr_utility.trace('for deductions...l_index ='||l_index);
248: hr_utility.trace('element name ='||l_element_name);
249: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
250: hr_utility.trace('gre_name='||l_gre_name);
251: hr_utility.trace('org name='||l_org_name);

Line 248: hr_utility.trace('element name ='||l_element_name);

244: hr_utility.trace('testing 1');
245: g_totals_table(l_temp_index).value2 := g_totals_table(l_temp_index).value2 +
246: to_number(l_cash_value);
247: hr_utility.trace('for deductions...l_index ='||l_index);
248: hr_utility.trace('element name ='||l_element_name);
249: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
250: hr_utility.trace('gre_name='||l_gre_name);
251: hr_utility.trace('org name='||l_org_name);
252: hr_utility.trace('location='||l_location_code);

Line 249: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));

245: g_totals_table(l_temp_index).value2 := g_totals_table(l_temp_index).value2 +
246: to_number(l_cash_value);
247: hr_utility.trace('for deductions...l_index ='||l_index);
248: hr_utility.trace('element name ='||l_element_name);
249: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
250: hr_utility.trace('gre_name='||l_gre_name);
251: hr_utility.trace('org name='||l_org_name);
252: hr_utility.trace('location='||l_location_code);
253: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));

Line 250: hr_utility.trace('gre_name='||l_gre_name);

246: to_number(l_cash_value);
247: hr_utility.trace('for deductions...l_index ='||l_index);
248: hr_utility.trace('element name ='||l_element_name);
249: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
250: hr_utility.trace('gre_name='||l_gre_name);
251: hr_utility.trace('org name='||l_org_name);
252: hr_utility.trace('location='||l_location_code);
253: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
254: hr_utility.trace('Cash Value ='||l_cash_value);

Line 251: hr_utility.trace('org name='||l_org_name);

247: hr_utility.trace('for deductions...l_index ='||l_index);
248: hr_utility.trace('element name ='||l_element_name);
249: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
250: hr_utility.trace('gre_name='||l_gre_name);
251: hr_utility.trace('org name='||l_org_name);
252: hr_utility.trace('location='||l_location_code);
253: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
254: hr_utility.trace('Cash Value ='||l_cash_value);
255: l_status := 1;

Line 252: hr_utility.trace('location='||l_location_code);

248: hr_utility.trace('element name ='||l_element_name);
249: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
250: hr_utility.trace('gre_name='||l_gre_name);
251: hr_utility.trace('org name='||l_org_name);
252: hr_utility.trace('location='||l_location_code);
253: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
254: hr_utility.trace('Cash Value ='||l_cash_value);
255: l_status := 1;
256: end if;

Line 253: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));

249: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
250: hr_utility.trace('gre_name='||l_gre_name);
251: hr_utility.trace('org name='||l_org_name);
252: hr_utility.trace('location='||l_location_code);
253: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
254: hr_utility.trace('Cash Value ='||l_cash_value);
255: l_status := 1;
256: end if;
257: end loop;

Line 254: hr_utility.trace('Cash Value ='||l_cash_value);

250: hr_utility.trace('gre_name='||l_gre_name);
251: hr_utility.trace('org name='||l_org_name);
252: hr_utility.trace('location='||l_location_code);
253: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
254: hr_utility.trace('Cash Value ='||l_cash_value);
255: l_status := 1;
256: end if;
257: end loop;
258: end if;

Line 272: hr_utility.trace('for deductions...l_index ='||l_index);

268: g_totals_table(l_index).value2 := to_number(l_cash_value);
269: g_totals_table(l_index).value3 := NULL;
270: g_totals_table(l_index).attribute1 := 'DEDUCTIONS';
271: g_totals_table(l_index).attribute2 := '4';
272: hr_utility.trace('for deductions...l_index ='||l_index);
273: hr_utility.trace('element name ='||l_element_name);
274: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
275: hr_utility.trace('gre_name='||l_gre_name);
276: hr_utility.trace('org name='||l_org_name);

Line 273: hr_utility.trace('element name ='||l_element_name);

269: g_totals_table(l_index).value3 := NULL;
270: g_totals_table(l_index).attribute1 := 'DEDUCTIONS';
271: g_totals_table(l_index).attribute2 := '4';
272: hr_utility.trace('for deductions...l_index ='||l_index);
273: hr_utility.trace('element name ='||l_element_name);
274: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
275: hr_utility.trace('gre_name='||l_gre_name);
276: hr_utility.trace('org name='||l_org_name);
277: hr_utility.trace('location='||l_location_code);

Line 274: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));

270: g_totals_table(l_index).attribute1 := 'DEDUCTIONS';
271: g_totals_table(l_index).attribute2 := '4';
272: hr_utility.trace('for deductions...l_index ='||l_index);
273: hr_utility.trace('element name ='||l_element_name);
274: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
275: hr_utility.trace('gre_name='||l_gre_name);
276: hr_utility.trace('org name='||l_org_name);
277: hr_utility.trace('location='||l_location_code);
278: hr_utility.trace('Cash Value ='||l_cash_value);

Line 275: hr_utility.trace('gre_name='||l_gre_name);

271: g_totals_table(l_index).attribute2 := '4';
272: hr_utility.trace('for deductions...l_index ='||l_index);
273: hr_utility.trace('element name ='||l_element_name);
274: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
275: hr_utility.trace('gre_name='||l_gre_name);
276: hr_utility.trace('org name='||l_org_name);
277: hr_utility.trace('location='||l_location_code);
278: hr_utility.trace('Cash Value ='||l_cash_value);
279: end if;

Line 276: hr_utility.trace('org name='||l_org_name);

272: hr_utility.trace('for deductions...l_index ='||l_index);
273: hr_utility.trace('element name ='||l_element_name);
274: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
275: hr_utility.trace('gre_name='||l_gre_name);
276: hr_utility.trace('org name='||l_org_name);
277: hr_utility.trace('location='||l_location_code);
278: hr_utility.trace('Cash Value ='||l_cash_value);
279: end if;
280: else

Line 277: hr_utility.trace('location='||l_location_code);

273: hr_utility.trace('element name ='||l_element_name);
274: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
275: hr_utility.trace('gre_name='||l_gre_name);
276: hr_utility.trace('org name='||l_org_name);
277: hr_utility.trace('location='||l_location_code);
278: hr_utility.trace('Cash Value ='||l_cash_value);
279: end if;
280: else
281: insert into pay_us_rpt_totals

Line 278: hr_utility.trace('Cash Value ='||l_cash_value);

274: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
275: hr_utility.trace('gre_name='||l_gre_name);
276: hr_utility.trace('org name='||l_org_name);
277: hr_utility.trace('location='||l_location_code);
278: hr_utility.trace('Cash Value ='||l_cash_value);
279: end if;
280: else
281: insert into pay_us_rpt_totals
282: (tax_unit_id,

Line 321: hr_utility.trace('l_index ='||to_char(l_index));

317: else
318: close csr_ded;
319: end if;
320: -- close cv;
321: hr_utility.trace('l_index ='||to_char(l_index));
322: exception
323: when others then
324: hr_utility.trace('Error occurred load_deductions ...' ||SQLERRM);
325: raise;

Line 324: hr_utility.trace('Error occurred load_deductions ...' ||SQLERRM);

320: -- close cv;
321: hr_utility.trace('l_index ='||to_char(l_index));
322: exception
323: when others then
324: hr_utility.trace('Error occurred load_deductions ...' ||SQLERRM);
325: raise;
326: end load_deductions;
327:
328:

Line 385: -- hr_utility.trace('l_earn_view_name = '|| l_earn_view_name);

381: l_status number :=0;
382: BEGIN
383:
384: /*-- Bug#4942114 starts -- */
385: -- hr_utility.trace('l_earn_view_name = '|| l_earn_view_name);
386:
387:
388: -- OPEN cv FOR
389: -- 'select /*+ index(pay_us_gtn_earnings_v.ernv.pec , pay_element_classification_pk)

Line 404: -- hr_utility.trace('statement build success');

400: -- ' and classification_name in ('||'''Earnings'''||','
401: -- ||'''Imputed Earnings'''||','||
402: -- '''Supplemental Earnings'''||','
403: -- ||'''Non-payroll Payments'''||')';
404: -- hr_utility.trace('statement build success');
405:
406: if p_earn_bal_status = 'Y' THEN
407: open csr_earn_rbr;
408: else

Line 441: hr_utility.trace('for earnings...l_index ='||l_index);

437: to_number(l_cash_value);
438: g_totals_table(l_temp_index).value3 := g_totals_table(l_temp_index).value3 +
439: to_number(l_hours_value);
440: l_status := 1;
441: hr_utility.trace('for earnings...l_index ='||l_index);
442: hr_utility.trace('element name ='||l_element_name);
443: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
444: hr_utility.trace('gre_name='||l_gre_name);
445: hr_utility.trace('org name='||l_org_name);

Line 442: hr_utility.trace('element name ='||l_element_name);

438: g_totals_table(l_temp_index).value3 := g_totals_table(l_temp_index).value3 +
439: to_number(l_hours_value);
440: l_status := 1;
441: hr_utility.trace('for earnings...l_index ='||l_index);
442: hr_utility.trace('element name ='||l_element_name);
443: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
444: hr_utility.trace('gre_name='||l_gre_name);
445: hr_utility.trace('org name='||l_org_name);
446: hr_utility.trace('location='||l_location_code);

Line 443: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));

439: to_number(l_hours_value);
440: l_status := 1;
441: hr_utility.trace('for earnings...l_index ='||l_index);
442: hr_utility.trace('element name ='||l_element_name);
443: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
444: hr_utility.trace('gre_name='||l_gre_name);
445: hr_utility.trace('org name='||l_org_name);
446: hr_utility.trace('location='||l_location_code);
447: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));

Line 444: hr_utility.trace('gre_name='||l_gre_name);

440: l_status := 1;
441: hr_utility.trace('for earnings...l_index ='||l_index);
442: hr_utility.trace('element name ='||l_element_name);
443: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
444: hr_utility.trace('gre_name='||l_gre_name);
445: hr_utility.trace('org name='||l_org_name);
446: hr_utility.trace('location='||l_location_code);
447: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
448: hr_utility.trace('Cash Value ='||l_cash_value);

Line 445: hr_utility.trace('org name='||l_org_name);

441: hr_utility.trace('for earnings...l_index ='||l_index);
442: hr_utility.trace('element name ='||l_element_name);
443: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
444: hr_utility.trace('gre_name='||l_gre_name);
445: hr_utility.trace('org name='||l_org_name);
446: hr_utility.trace('location='||l_location_code);
447: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
448: hr_utility.trace('Cash Value ='||l_cash_value);
449:

Line 446: hr_utility.trace('location='||l_location_code);

442: hr_utility.trace('element name ='||l_element_name);
443: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
444: hr_utility.trace('gre_name='||l_gre_name);
445: hr_utility.trace('org name='||l_org_name);
446: hr_utility.trace('location='||l_location_code);
447: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
448: hr_utility.trace('Cash Value ='||l_cash_value);
449:
450: end if;

Line 447: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));

443: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
444: hr_utility.trace('gre_name='||l_gre_name);
445: hr_utility.trace('org name='||l_org_name);
446: hr_utility.trace('location='||l_location_code);
447: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
448: hr_utility.trace('Cash Value ='||l_cash_value);
449:
450: end if;
451: end loop;

Line 448: hr_utility.trace('Cash Value ='||l_cash_value);

444: hr_utility.trace('gre_name='||l_gre_name);
445: hr_utility.trace('org name='||l_org_name);
446: hr_utility.trace('location='||l_location_code);
447: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
448: hr_utility.trace('Cash Value ='||l_cash_value);
449:
450: end if;
451: end loop;
452: end if;

Line 454: hr_utility.trace('l_status ='||l_status||' l_index ='||l_index);

450: end if;
451: end loop;
452: end if;
453: if l_status <> 1 or l_index = 0 then
454: hr_utility.trace('l_status ='||l_status||' l_index ='||l_index);
455: l_index := l_index + 1;
456: g_totals_table(l_index).gre_name := l_gre_name;
457: g_totals_table(l_index).organization_name := l_org_name;
458: g_totals_table(l_index).location_name := l_location_code;

Line 467: hr_utility.trace('for earnings...l_index ='||l_index);

463: g_totals_table(l_index).value2 := to_number(l_cash_value);
464: g_totals_table(l_index).value3 := to_number(l_hours_value);
465: g_totals_table(l_index).attribute1 := 'EARNINGS';
466: g_totals_table(l_index).attribute2 := '1';
467: hr_utility.trace('for earnings...l_index ='||l_index);
468: hr_utility.trace('element name ='||l_element_name);
469: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
470: hr_utility.trace('gre_name='||l_gre_name);
471: hr_utility.trace('org name='||l_org_name);

Line 468: hr_utility.trace('element name ='||l_element_name);

464: g_totals_table(l_index).value3 := to_number(l_hours_value);
465: g_totals_table(l_index).attribute1 := 'EARNINGS';
466: g_totals_table(l_index).attribute2 := '1';
467: hr_utility.trace('for earnings...l_index ='||l_index);
468: hr_utility.trace('element name ='||l_element_name);
469: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
470: hr_utility.trace('gre_name='||l_gre_name);
471: hr_utility.trace('org name='||l_org_name);
472: hr_utility.trace('location='||l_location_code);

Line 469: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));

465: g_totals_table(l_index).attribute1 := 'EARNINGS';
466: g_totals_table(l_index).attribute2 := '1';
467: hr_utility.trace('for earnings...l_index ='||l_index);
468: hr_utility.trace('element name ='||l_element_name);
469: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
470: hr_utility.trace('gre_name='||l_gre_name);
471: hr_utility.trace('org name='||l_org_name);
472: hr_utility.trace('location='||l_location_code);
473: hr_utility.trace('Cash Value ='||l_cash_value);

Line 470: hr_utility.trace('gre_name='||l_gre_name);

466: g_totals_table(l_index).attribute2 := '1';
467: hr_utility.trace('for earnings...l_index ='||l_index);
468: hr_utility.trace('element name ='||l_element_name);
469: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
470: hr_utility.trace('gre_name='||l_gre_name);
471: hr_utility.trace('org name='||l_org_name);
472: hr_utility.trace('location='||l_location_code);
473: hr_utility.trace('Cash Value ='||l_cash_value);
474: end if;

Line 471: hr_utility.trace('org name='||l_org_name);

467: hr_utility.trace('for earnings...l_index ='||l_index);
468: hr_utility.trace('element name ='||l_element_name);
469: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
470: hr_utility.trace('gre_name='||l_gre_name);
471: hr_utility.trace('org name='||l_org_name);
472: hr_utility.trace('location='||l_location_code);
473: hr_utility.trace('Cash Value ='||l_cash_value);
474: end if;
475: else

Line 472: hr_utility.trace('location='||l_location_code);

468: hr_utility.trace('element name ='||l_element_name);
469: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
470: hr_utility.trace('gre_name='||l_gre_name);
471: hr_utility.trace('org name='||l_org_name);
472: hr_utility.trace('location='||l_location_code);
473: hr_utility.trace('Cash Value ='||l_cash_value);
474: end if;
475: else
476: insert into pay_us_rpt_totals

Line 473: hr_utility.trace('Cash Value ='||l_cash_value);

469: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
470: hr_utility.trace('gre_name='||l_gre_name);
471: hr_utility.trace('org name='||l_org_name);
472: hr_utility.trace('location='||l_location_code);
473: hr_utility.trace('Cash Value ='||l_cash_value);
474: end if;
475: else
476: insert into pay_us_rpt_totals
477: (tax_unit_id,

Line 522: hr_utility.trace('Error occurred load_earnings ...' ||SQLERRM);

518: /*-- Bug#4942114 ends -- */
519:
520: exception
521: when others then
522: hr_utility.trace('Error occurred load_earnings ...' ||SQLERRM);
523: raise;
524: end load_earnings;
525: --------------------------------------------------------------
526: -- Following procedure has been added by tmehra on 02-JAN-2001

Line 548: hr_utility.trace('Number of Earnings Records fetched = '||to_char(ee_earn%ROWCOUNT));

544: begin
545: open ee_earn ;
546: loop
547: fetch ee_earn into ee_earn_rec;
548: hr_utility.trace('Number of Earnings Records fetched = '||to_char(ee_earn%ROWCOUNT));
549: exit when ee_earn%notfound;
550: insert into pay_us_rpt_totals
551: (tax_unit_id, gre_name, organization_name, location_name,
552: attribute1,

Line 576: hr_utility.trace('Error occurred load_earnings ...' ||SQLERRM);

572: end loop;
573: close ee_earn;
574: exception
575: when others then
576: hr_utility.trace('Error occurred load_earnings ...' ||SQLERRM);
577: raise;
578: end load_alien_earnings;
579: --------------------------------------------------------------
580: /*-- Bug#4942114 starts -- */

Line 706: /* hr_utility.trace('view names = '|| l_fed_view_name || l_state_view_name || l_local_view_name);

702: and DS.SCHOOL_DST_CODE = p_sd_code
703: and ST.state_code = DS.state_code;
704: BEGIN
705: /*-- Bug#4942114 starts -- */
706: /* hr_utility.trace('view names = '|| l_fed_view_name || l_state_view_name || l_local_view_name);
707:
708: OPEN cv FOR
709: 'select user_reporting_name,''1'' sub_class,run_val,null,null
710: from '||l_fed_view_name||

Line 751: hr_utility.trace('statement build success');

747: AND state.assignment_id = paa.assignment_id
748: AND ppa.payroll_action_id = paa.payroll_action_id
749: AND paa.assignment_action_id ='|| l_assignment_action_id||
750: ' AND ppa.effective_date BETWEEN state.effective_start_date AND state.effective_end_date';
751: hr_utility.trace('statement build success');
752: LOOP
753: FETCH cv INTO l_user_reporting_name,l_sub_class,l_run_val
754: , l_tax_type_code, l_jurisdiction_code; */
755:

Line 793: hr_utility.trace('testing 1');

789: g_totals_table(l_temp_index).gre_name = l_gre_name and
790: g_totals_table(l_temp_index).organization_name = l_org_name and
791: g_totals_table(l_temp_index).location_name = l_location_code then
792:
793: hr_utility.trace('testing 1');
794: g_totals_table(l_temp_index).value2 := g_totals_table(l_temp_index).value2 +
795: to_number(l_run_val);
796: l_status := 1;
797: hr_utility.trace('for ee tax...l_index ='||l_index);

Line 797: hr_utility.trace('for ee tax...l_index ='||l_index);

793: hr_utility.trace('testing 1');
794: g_totals_table(l_temp_index).value2 := g_totals_table(l_temp_index).value2 +
795: to_number(l_run_val);
796: l_status := 1;
797: hr_utility.trace('for ee tax...l_index ='||l_index);
798: hr_utility.trace('element name ='||l_user_reporting_name);
799: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
800: hr_utility.trace('gre_name='||l_gre_name);
801: hr_utility.trace('org name='||l_org_name);

Line 798: hr_utility.trace('element name ='||l_user_reporting_name);

794: g_totals_table(l_temp_index).value2 := g_totals_table(l_temp_index).value2 +
795: to_number(l_run_val);
796: l_status := 1;
797: hr_utility.trace('for ee tax...l_index ='||l_index);
798: hr_utility.trace('element name ='||l_user_reporting_name);
799: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
800: hr_utility.trace('gre_name='||l_gre_name);
801: hr_utility.trace('org name='||l_org_name);
802: hr_utility.trace('location='||l_location_code);

Line 799: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));

795: to_number(l_run_val);
796: l_status := 1;
797: hr_utility.trace('for ee tax...l_index ='||l_index);
798: hr_utility.trace('element name ='||l_user_reporting_name);
799: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
800: hr_utility.trace('gre_name='||l_gre_name);
801: hr_utility.trace('org name='||l_org_name);
802: hr_utility.trace('location='||l_location_code);
803: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));

Line 800: hr_utility.trace('gre_name='||l_gre_name);

796: l_status := 1;
797: hr_utility.trace('for ee tax...l_index ='||l_index);
798: hr_utility.trace('element name ='||l_user_reporting_name);
799: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
800: hr_utility.trace('gre_name='||l_gre_name);
801: hr_utility.trace('org name='||l_org_name);
802: hr_utility.trace('location='||l_location_code);
803: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
804: hr_utility.trace('Cash Value ='||l_run_val);

Line 801: hr_utility.trace('org name='||l_org_name);

797: hr_utility.trace('for ee tax...l_index ='||l_index);
798: hr_utility.trace('element name ='||l_user_reporting_name);
799: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
800: hr_utility.trace('gre_name='||l_gre_name);
801: hr_utility.trace('org name='||l_org_name);
802: hr_utility.trace('location='||l_location_code);
803: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
804: hr_utility.trace('Cash Value ='||l_run_val);
805: end if;

Line 802: hr_utility.trace('location='||l_location_code);

798: hr_utility.trace('element name ='||l_user_reporting_name);
799: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
800: hr_utility.trace('gre_name='||l_gre_name);
801: hr_utility.trace('org name='||l_org_name);
802: hr_utility.trace('location='||l_location_code);
803: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
804: hr_utility.trace('Cash Value ='||l_run_val);
805: end if;
806: end loop;

Line 803: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));

799: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
800: hr_utility.trace('gre_name='||l_gre_name);
801: hr_utility.trace('org name='||l_org_name);
802: hr_utility.trace('location='||l_location_code);
803: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
804: hr_utility.trace('Cash Value ='||l_run_val);
805: end if;
806: end loop;
807: end if;

Line 804: hr_utility.trace('Cash Value ='||l_run_val);

800: hr_utility.trace('gre_name='||l_gre_name);
801: hr_utility.trace('org name='||l_org_name);
802: hr_utility.trace('location='||l_location_code);
803: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
804: hr_utility.trace('Cash Value ='||l_run_val);
805: end if;
806: end loop;
807: end if;
808: if l_status <> 1 or l_index = 0 then

Line 809: hr_utility.trace('testing 6');

805: end if;
806: end loop;
807: end if;
808: if l_status <> 1 or l_index = 0 then
809: hr_utility.trace('testing 6');
810: l_index := l_index + 1;
811: g_totals_table(l_index).gre_name := l_gre_name;
812: g_totals_table(l_index).organization_name := l_org_name;
813: g_totals_table(l_index).location_name := l_location_code;

Line 823: hr_utility.trace('for ee tax...l_index ='||l_index);

819: g_totals_table(l_index).value3 := NULL;
820: g_totals_table(l_index).attribute1 := 'EE-TAX';
821: g_totals_table(l_index).attribute2 := '2';
822: end if;
823: hr_utility.trace('for ee tax...l_index ='||l_index);
824: hr_utility.trace('element name ='||l_user_reporting_name);
825: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
826: hr_utility.trace('gre_name='||l_gre_name);
827: hr_utility.trace('org name='||l_org_name);

Line 824: hr_utility.trace('element name ='||l_user_reporting_name);

820: g_totals_table(l_index).attribute1 := 'EE-TAX';
821: g_totals_table(l_index).attribute2 := '2';
822: end if;
823: hr_utility.trace('for ee tax...l_index ='||l_index);
824: hr_utility.trace('element name ='||l_user_reporting_name);
825: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
826: hr_utility.trace('gre_name='||l_gre_name);
827: hr_utility.trace('org name='||l_org_name);
828: hr_utility.trace('location='||l_location_code);

Line 825: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));

821: g_totals_table(l_index).attribute2 := '2';
822: end if;
823: hr_utility.trace('for ee tax...l_index ='||l_index);
824: hr_utility.trace('element name ='||l_user_reporting_name);
825: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
826: hr_utility.trace('gre_name='||l_gre_name);
827: hr_utility.trace('org name='||l_org_name);
828: hr_utility.trace('location='||l_location_code);
829: hr_utility.trace('Cash Value ='||l_run_val);

Line 826: hr_utility.trace('gre_name='||l_gre_name);

822: end if;
823: hr_utility.trace('for ee tax...l_index ='||l_index);
824: hr_utility.trace('element name ='||l_user_reporting_name);
825: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
826: hr_utility.trace('gre_name='||l_gre_name);
827: hr_utility.trace('org name='||l_org_name);
828: hr_utility.trace('location='||l_location_code);
829: hr_utility.trace('Cash Value ='||l_run_val);
830: else

Line 827: hr_utility.trace('org name='||l_org_name);

823: hr_utility.trace('for ee tax...l_index ='||l_index);
824: hr_utility.trace('element name ='||l_user_reporting_name);
825: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
826: hr_utility.trace('gre_name='||l_gre_name);
827: hr_utility.trace('org name='||l_org_name);
828: hr_utility.trace('location='||l_location_code);
829: hr_utility.trace('Cash Value ='||l_run_val);
830: else
831: insert into pay_us_rpt_totals

Line 828: hr_utility.trace('location='||l_location_code);

824: hr_utility.trace('element name ='||l_user_reporting_name);
825: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
826: hr_utility.trace('gre_name='||l_gre_name);
827: hr_utility.trace('org name='||l_org_name);
828: hr_utility.trace('location='||l_location_code);
829: hr_utility.trace('Cash Value ='||l_run_val);
830: else
831: insert into pay_us_rpt_totals
832: (tax_unit_id, gre_name, organization_name, location_name,

Line 829: hr_utility.trace('Cash Value ='||l_run_val);

825: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
826: hr_utility.trace('gre_name='||l_gre_name);
827: hr_utility.trace('org name='||l_org_name);
828: hr_utility.trace('location='||l_location_code);
829: hr_utility.trace('Cash Value ='||l_run_val);
830: else
831: insert into pay_us_rpt_totals
832: (tax_unit_id, gre_name, organization_name, location_name,
833: attribute1,

Line 866: hr_utility.trace('Error occurred load_ee_tax ...' ||SQLERRM);

862: end if;
863: /*-- Bug#4942114 ends -- */
864: exception
865: when others then
866: hr_utility.trace('Error occurred load_ee_tax ...' ||SQLERRM);
867: raise;
868: end load_ee_tax;
869:
870: /*-- Bug#4942114 starts -- */

Line 936: /* hr_utility.trace('view names = '|| l_fed_liab_view_name || l_state_liab_view_name || l_local_liab_view_name);

932: l_status number :=0;
933: -- lv_sql_query varchar2(3000); -- Bug#4942114
934: BEGIN
935: /*-- Bug#4942114 ends -- */
936: /* hr_utility.trace('view names = '|| l_fed_liab_view_name || l_state_liab_view_name || l_local_liab_view_name);
937:
938: lv_sql_query := 'select user_reporting_name,''1'' sub_class,run_val
939: from ' || l_fed_liab_view_name ||
940: ' where assignment_action_id ='|| l_assignment_action_id||

Line 971: hr_utility.trace('statement build success');

967: ' and ee_or_er_code = ''ER''';
968:
969: OPEN cv FOR lv_sql_query;
970:
971: hr_utility.trace('statement build success');
972: LOOP
973: fetch cv into l_user_reporting_name, l_sub_class, l_run_val;
974: hr_utility.trace('assignment_Action_id in load_er_tax ='||to_char(l_assignment_action_id));
975: EXIT WHEN cv%NOTFOUND; */

Line 974: hr_utility.trace('assignment_Action_id in load_er_tax ='||to_char(l_assignment_action_id));

970:
971: hr_utility.trace('statement build success');
972: LOOP
973: fetch cv into l_user_reporting_name, l_sub_class, l_run_val;
974: hr_utility.trace('assignment_Action_id in load_er_tax ='||to_char(l_assignment_action_id));
975: EXIT WHEN cv%NOTFOUND; */
976:
977: if p_fed_liab_bal_status = 'Y' and p_state_liab_bal_status = 'Y' and p_local_bal_status = 'Y' then
978: open csr_er_tax_rbr;

Line 992: hr_utility.trace('assignment_Action_id in load_er_tax ='||to_char(l_assignment_action_id));

988: else
989: fetch csr_er_tax into l_user_reporting_name, l_sub_class, l_run_val;
990: EXIT WHEN csr_er_tax%NOTFOUND;
991: end if;
992: hr_utility.trace('assignment_Action_id in load_er_tax ='||to_char(l_assignment_action_id));
993: /*-- Bug#4942114 ends -- */
994:
995:
996: if l_asg_flag <> 'Y' THEN

Line 1005: hr_utility.trace('testing 1');

1001: g_totals_table(l_temp_index).gre_name = l_gre_name and
1002: g_totals_table(l_temp_index).organization_name = l_org_name and
1003: g_totals_table(l_temp_index).location_name = l_location_code then
1004:
1005: hr_utility.trace('testing 1');
1006: g_totals_table(l_temp_index).value2 := g_totals_table(l_temp_index).value2 +
1007: to_number(l_run_val);
1008: l_status := 1;
1009: hr_utility.trace('for er tax...l_index ='||l_index);

Line 1009: hr_utility.trace('for er tax...l_index ='||l_index);

1005: hr_utility.trace('testing 1');
1006: g_totals_table(l_temp_index).value2 := g_totals_table(l_temp_index).value2 +
1007: to_number(l_run_val);
1008: l_status := 1;
1009: hr_utility.trace('for er tax...l_index ='||l_index);
1010: hr_utility.trace('element name ='||l_user_reporting_name);
1011: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1012: hr_utility.trace('gre_name='||l_gre_name);
1013: hr_utility.trace('org name='||l_org_name);

Line 1010: hr_utility.trace('element name ='||l_user_reporting_name);

1006: g_totals_table(l_temp_index).value2 := g_totals_table(l_temp_index).value2 +
1007: to_number(l_run_val);
1008: l_status := 1;
1009: hr_utility.trace('for er tax...l_index ='||l_index);
1010: hr_utility.trace('element name ='||l_user_reporting_name);
1011: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1012: hr_utility.trace('gre_name='||l_gre_name);
1013: hr_utility.trace('org name='||l_org_name);
1014: hr_utility.trace('location='||l_location_code);

Line 1011: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));

1007: to_number(l_run_val);
1008: l_status := 1;
1009: hr_utility.trace('for er tax...l_index ='||l_index);
1010: hr_utility.trace('element name ='||l_user_reporting_name);
1011: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1012: hr_utility.trace('gre_name='||l_gre_name);
1013: hr_utility.trace('org name='||l_org_name);
1014: hr_utility.trace('location='||l_location_code);
1015: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));

Line 1012: hr_utility.trace('gre_name='||l_gre_name);

1008: l_status := 1;
1009: hr_utility.trace('for er tax...l_index ='||l_index);
1010: hr_utility.trace('element name ='||l_user_reporting_name);
1011: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1012: hr_utility.trace('gre_name='||l_gre_name);
1013: hr_utility.trace('org name='||l_org_name);
1014: hr_utility.trace('location='||l_location_code);
1015: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
1016: hr_utility.trace('Cash Value ='||l_run_val);

Line 1013: hr_utility.trace('org name='||l_org_name);

1009: hr_utility.trace('for er tax...l_index ='||l_index);
1010: hr_utility.trace('element name ='||l_user_reporting_name);
1011: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1012: hr_utility.trace('gre_name='||l_gre_name);
1013: hr_utility.trace('org name='||l_org_name);
1014: hr_utility.trace('location='||l_location_code);
1015: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
1016: hr_utility.trace('Cash Value ='||l_run_val);
1017:

Line 1014: hr_utility.trace('location='||l_location_code);

1010: hr_utility.trace('element name ='||l_user_reporting_name);
1011: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1012: hr_utility.trace('gre_name='||l_gre_name);
1013: hr_utility.trace('org name='||l_org_name);
1014: hr_utility.trace('location='||l_location_code);
1015: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
1016: hr_utility.trace('Cash Value ='||l_run_val);
1017:
1018: end if;

Line 1015: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));

1011: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1012: hr_utility.trace('gre_name='||l_gre_name);
1013: hr_utility.trace('org name='||l_org_name);
1014: hr_utility.trace('location='||l_location_code);
1015: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
1016: hr_utility.trace('Cash Value ='||l_run_val);
1017:
1018: end if;
1019: end loop;

Line 1016: hr_utility.trace('Cash Value ='||l_run_val);

1012: hr_utility.trace('gre_name='||l_gre_name);
1013: hr_utility.trace('org name='||l_org_name);
1014: hr_utility.trace('location='||l_location_code);
1015: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
1016: hr_utility.trace('Cash Value ='||l_run_val);
1017:
1018: end if;
1019: end loop;
1020: end if;

Line 1022: hr_utility.trace('testing 6');

1018: end if;
1019: end loop;
1020: end if;
1021: if l_status <> 1 or l_index = 0 then
1022: hr_utility.trace('testing 6');
1023: l_index := l_index + 1;
1024: g_totals_table(l_index).gre_name := l_gre_name;
1025: g_totals_table(l_index).organization_name := l_org_name;
1026: g_totals_table(l_index).location_name := l_location_code;

Line 1035: hr_utility.trace('for er tax...l_index ='||l_index);

1031: g_totals_table(l_index).value2 := to_number(l_run_val);
1032: g_totals_table(l_index).value3 := NULL;
1033: g_totals_table(l_index).attribute1 := 'ER-TAX';
1034: g_totals_table(l_index).attribute2 := '6';
1035: hr_utility.trace('for er tax...l_index ='||l_index);
1036: hr_utility.trace('element name ='||l_user_reporting_name);
1037: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
1038: hr_utility.trace('gre_name='||l_gre_name);
1039: hr_utility.trace('org name='||l_org_name);

Line 1036: hr_utility.trace('element name ='||l_user_reporting_name);

1032: g_totals_table(l_index).value3 := NULL;
1033: g_totals_table(l_index).attribute1 := 'ER-TAX';
1034: g_totals_table(l_index).attribute2 := '6';
1035: hr_utility.trace('for er tax...l_index ='||l_index);
1036: hr_utility.trace('element name ='||l_user_reporting_name);
1037: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
1038: hr_utility.trace('gre_name='||l_gre_name);
1039: hr_utility.trace('org name='||l_org_name);
1040: hr_utility.trace('location='||l_location_code);

Line 1037: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));

1033: g_totals_table(l_index).attribute1 := 'ER-TAX';
1034: g_totals_table(l_index).attribute2 := '6';
1035: hr_utility.trace('for er tax...l_index ='||l_index);
1036: hr_utility.trace('element name ='||l_user_reporting_name);
1037: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
1038: hr_utility.trace('gre_name='||l_gre_name);
1039: hr_utility.trace('org name='||l_org_name);
1040: hr_utility.trace('location='||l_location_code);
1041: hr_utility.trace('Cash Value ='||l_run_val);

Line 1038: hr_utility.trace('gre_name='||l_gre_name);

1034: g_totals_table(l_index).attribute2 := '6';
1035: hr_utility.trace('for er tax...l_index ='||l_index);
1036: hr_utility.trace('element name ='||l_user_reporting_name);
1037: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
1038: hr_utility.trace('gre_name='||l_gre_name);
1039: hr_utility.trace('org name='||l_org_name);
1040: hr_utility.trace('location='||l_location_code);
1041: hr_utility.trace('Cash Value ='||l_run_val);
1042: end if;

Line 1039: hr_utility.trace('org name='||l_org_name);

1035: hr_utility.trace('for er tax...l_index ='||l_index);
1036: hr_utility.trace('element name ='||l_user_reporting_name);
1037: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
1038: hr_utility.trace('gre_name='||l_gre_name);
1039: hr_utility.trace('org name='||l_org_name);
1040: hr_utility.trace('location='||l_location_code);
1041: hr_utility.trace('Cash Value ='||l_run_val);
1042: end if;
1043: else

Line 1040: hr_utility.trace('location='||l_location_code);

1036: hr_utility.trace('element name ='||l_user_reporting_name);
1037: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
1038: hr_utility.trace('gre_name='||l_gre_name);
1039: hr_utility.trace('org name='||l_org_name);
1040: hr_utility.trace('location='||l_location_code);
1041: hr_utility.trace('Cash Value ='||l_run_val);
1042: end if;
1043: else
1044: insert into pay_us_rpt_totals

Line 1041: hr_utility.trace('Cash Value ='||l_run_val);

1037: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
1038: hr_utility.trace('gre_name='||l_gre_name);
1039: hr_utility.trace('org name='||l_org_name);
1040: hr_utility.trace('location='||l_location_code);
1041: hr_utility.trace('Cash Value ='||l_run_val);
1042: end if;
1043: else
1044: insert into pay_us_rpt_totals
1045: ( tax_unit_id, gre_name, organization_name, location_name,

Line 1078: hr_utility.trace('Leaving load_er_tax');

1074: close csr_er_tax;
1075: end if;
1076:
1077: /*-- Bug#4942114 ends -- */
1078: hr_utility.trace('Leaving load_er_tax');
1079: exception
1080: when others then
1081: hr_utility.trace('Error occurred load_er_tax ...' ||SQLERRM);
1082: raise;

Line 1081: hr_utility.trace('Error occurred load_er_tax ...' ||SQLERRM);

1077: /*-- Bug#4942114 ends -- */
1078: hr_utility.trace('Leaving load_er_tax');
1079: exception
1080: when others then
1081: hr_utility.trace('Error occurred load_er_tax ...' ||SQLERRM);
1082: raise;
1083: end load_er_tax;
1084: --------------------------------------------------------------------------------
1085: /*-- Bug#4942114 starts -- */

Line 1126: /* hr_utility.trace('view names = '|| l_fed_view_name || l_state_view_name);

1122: l_run_val number(20,2);
1123: l_status number :=0;
1124: BEGIN
1125: /*-- Bug#4942114 starts -- */
1126: /* hr_utility.trace('view names = '|| l_fed_view_name || l_state_view_name);
1127: OPEN cv FOR
1128: 'select user_reporting_name,run_val
1129: from '||l_fed_view_name||
1130: ' where assignment_action_id ='|| l_assignment_action_id||

Line 1138: hr_utility.trace('statement build success');

1134: from '||l_state_view_name||
1135: ' where assignment_action_id ='||l_assignment_action_id||
1136: ' and ee_or_er_code = ''EE''
1137: and tax_type_code = ''STEIC''';
1138: hr_utility.trace('statement build success');
1139: loop
1140: fetch cv into l_user_reporting_name, l_run_val;
1141: exit when cv%notfound; */
1142:

Line 1173: hr_utility.trace('for er credit...l_index ='||l_index);

1169:
1170: g_totals_table(l_temp_index).value2 := g_totals_table(l_temp_index).value2 -
1171: to_number(l_run_val);
1172: l_status := 1;
1173: hr_utility.trace('for er credit...l_index ='||l_index);
1174: hr_utility.trace('element name ='||l_user_reporting_name);
1175: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1176: hr_utility.trace('gre_name='||l_gre_name);
1177: hr_utility.trace('org name='||l_org_name);

Line 1174: hr_utility.trace('element name ='||l_user_reporting_name);

1170: g_totals_table(l_temp_index).value2 := g_totals_table(l_temp_index).value2 -
1171: to_number(l_run_val);
1172: l_status := 1;
1173: hr_utility.trace('for er credit...l_index ='||l_index);
1174: hr_utility.trace('element name ='||l_user_reporting_name);
1175: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1176: hr_utility.trace('gre_name='||l_gre_name);
1177: hr_utility.trace('org name='||l_org_name);
1178: hr_utility.trace('location='||l_location_code);

Line 1175: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));

1171: to_number(l_run_val);
1172: l_status := 1;
1173: hr_utility.trace('for er credit...l_index ='||l_index);
1174: hr_utility.trace('element name ='||l_user_reporting_name);
1175: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1176: hr_utility.trace('gre_name='||l_gre_name);
1177: hr_utility.trace('org name='||l_org_name);
1178: hr_utility.trace('location='||l_location_code);
1179: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));

Line 1176: hr_utility.trace('gre_name='||l_gre_name);

1172: l_status := 1;
1173: hr_utility.trace('for er credit...l_index ='||l_index);
1174: hr_utility.trace('element name ='||l_user_reporting_name);
1175: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1176: hr_utility.trace('gre_name='||l_gre_name);
1177: hr_utility.trace('org name='||l_org_name);
1178: hr_utility.trace('location='||l_location_code);
1179: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
1180: hr_utility.trace('Cash Value ='||l_run_val);

Line 1177: hr_utility.trace('org name='||l_org_name);

1173: hr_utility.trace('for er credit...l_index ='||l_index);
1174: hr_utility.trace('element name ='||l_user_reporting_name);
1175: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1176: hr_utility.trace('gre_name='||l_gre_name);
1177: hr_utility.trace('org name='||l_org_name);
1178: hr_utility.trace('location='||l_location_code);
1179: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
1180: hr_utility.trace('Cash Value ='||l_run_val);
1181:

Line 1178: hr_utility.trace('location='||l_location_code);

1174: hr_utility.trace('element name ='||l_user_reporting_name);
1175: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1176: hr_utility.trace('gre_name='||l_gre_name);
1177: hr_utility.trace('org name='||l_org_name);
1178: hr_utility.trace('location='||l_location_code);
1179: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
1180: hr_utility.trace('Cash Value ='||l_run_val);
1181:
1182: end if;

Line 1179: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));

1175: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1176: hr_utility.trace('gre_name='||l_gre_name);
1177: hr_utility.trace('org name='||l_org_name);
1178: hr_utility.trace('location='||l_location_code);
1179: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
1180: hr_utility.trace('Cash Value ='||l_run_val);
1181:
1182: end if;
1183: end loop;

Line 1180: hr_utility.trace('Cash Value ='||l_run_val);

1176: hr_utility.trace('gre_name='||l_gre_name);
1177: hr_utility.trace('org name='||l_org_name);
1178: hr_utility.trace('location='||l_location_code);
1179: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
1180: hr_utility.trace('Cash Value ='||l_run_val);
1181:
1182: end if;
1183: end loop;
1184: end if;

Line 1186: hr_utility.trace('testing 6');

1182: end if;
1183: end loop;
1184: end if;
1185: if l_status <> 1 or l_index = 0 then
1186: hr_utility.trace('testing 6');
1187: l_index := l_index + 1;
1188: g_totals_table(l_index).gre_name := l_gre_name;
1189: g_totals_table(l_index).organization_name := l_org_name;
1190: g_totals_table(l_index).location_name := l_location_code;

Line 1200: hr_utility.trace('for er credit...l_index ='||l_index);

1196: g_totals_table(l_index).value3 := NULL;
1197: g_totals_table(l_index).attribute1 := 'EE-CREDIT';
1198: g_totals_table(l_index).attribute2 := '3';
1199: end if;
1200: hr_utility.trace('for er credit...l_index ='||l_index);
1201: hr_utility.trace('element name ='||l_user_reporting_name);
1202: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
1203: hr_utility.trace('gre_name='||l_gre_name);
1204: hr_utility.trace('org name='||l_org_name);

Line 1201: hr_utility.trace('element name ='||l_user_reporting_name);

1197: g_totals_table(l_index).attribute1 := 'EE-CREDIT';
1198: g_totals_table(l_index).attribute2 := '3';
1199: end if;
1200: hr_utility.trace('for er credit...l_index ='||l_index);
1201: hr_utility.trace('element name ='||l_user_reporting_name);
1202: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
1203: hr_utility.trace('gre_name='||l_gre_name);
1204: hr_utility.trace('org name='||l_org_name);
1205: hr_utility.trace('location='||l_location_code);

Line 1202: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));

1198: g_totals_table(l_index).attribute2 := '3';
1199: end if;
1200: hr_utility.trace('for er credit...l_index ='||l_index);
1201: hr_utility.trace('element name ='||l_user_reporting_name);
1202: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
1203: hr_utility.trace('gre_name='||l_gre_name);
1204: hr_utility.trace('org name='||l_org_name);
1205: hr_utility.trace('location='||l_location_code);
1206: hr_utility.trace('Cash Value ='||l_run_val);

Line 1203: hr_utility.trace('gre_name='||l_gre_name);

1199: end if;
1200: hr_utility.trace('for er credit...l_index ='||l_index);
1201: hr_utility.trace('element name ='||l_user_reporting_name);
1202: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
1203: hr_utility.trace('gre_name='||l_gre_name);
1204: hr_utility.trace('org name='||l_org_name);
1205: hr_utility.trace('location='||l_location_code);
1206: hr_utility.trace('Cash Value ='||l_run_val);
1207: else

Line 1204: hr_utility.trace('org name='||l_org_name);

1200: hr_utility.trace('for er credit...l_index ='||l_index);
1201: hr_utility.trace('element name ='||l_user_reporting_name);
1202: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
1203: hr_utility.trace('gre_name='||l_gre_name);
1204: hr_utility.trace('org name='||l_org_name);
1205: hr_utility.trace('location='||l_location_code);
1206: hr_utility.trace('Cash Value ='||l_run_val);
1207: else
1208: insert into pay_us_rpt_totals

Line 1205: hr_utility.trace('location='||l_location_code);

1201: hr_utility.trace('element name ='||l_user_reporting_name);
1202: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
1203: hr_utility.trace('gre_name='||l_gre_name);
1204: hr_utility.trace('org name='||l_org_name);
1205: hr_utility.trace('location='||l_location_code);
1206: hr_utility.trace('Cash Value ='||l_run_val);
1207: else
1208: insert into pay_us_rpt_totals
1209: (tax_unit_id, gre_name, organization_name, location_name,

Line 1206: hr_utility.trace('Cash Value ='||l_run_val);

1202: hr_utility.trace('payroll action='||to_char(l_payroll_action_id));
1203: hr_utility.trace('gre_name='||l_gre_name);
1204: hr_utility.trace('org name='||l_org_name);
1205: hr_utility.trace('location='||l_location_code);
1206: hr_utility.trace('Cash Value ='||l_run_val);
1207: else
1208: insert into pay_us_rpt_totals
1209: (tax_unit_id, gre_name, organization_name, location_name,
1210: attribute1,

Line 1245: hr_utility.trace('Error occurred load_ee_credit ...' ||SQLERRM);

1241: end if;
1242: /*-- Bug#4942114 ends -- */
1243: exception
1244: when others then
1245: hr_utility.trace('Error occurred load_ee_credit ...' ||SQLERRM);
1246: raise;
1247: end load_ee_credit;
1248: ---------------------------------------------------------------------------------------------
1249: /*-- Bug#4942114 starts -- */

Line 1287: hr_utility.trace('Entered load_csr_er_credit');

1283: l_jurisdiction_code varchar2(15); -- Bug 4443935
1284: l_tname varchar2(60);
1285: begin
1286:
1287: hr_utility.trace('Entered load_csr_er_credit');
1288:
1289: /*-- Bug#4942114 starts -- */
1290: /* if (instr(l_futa_from,'prb') > 0) then
1291: l_tname := 'prb';

Line 1298: --hr_utility.trace('l_futa_where ='||l_futa_where);

1294: end if;
1295:
1296: -- ||l_tname||'.jurisdiction_code jurisdiction_code
1297:
1298: --hr_utility.trace('l_futa_where ='||l_futa_where);
1299: --hr_utility.trace('l_futa_from ='||l_futa_from);
1300: --hr_utility.trace('l_tname ='||l_tname);
1301: -- Bug 5409416 : Removed prr.jurisdiction_code with
1302: OPEN cv FOR

Line 1299: --hr_utility.trace('l_futa_from ='||l_futa_from);

1295:
1296: -- ||l_tname||'.jurisdiction_code jurisdiction_code
1297:
1298: --hr_utility.trace('l_futa_where ='||l_futa_where);
1299: --hr_utility.trace('l_futa_from ='||l_futa_from);
1300: --hr_utility.trace('l_tname ='||l_tname);
1301: -- Bug 5409416 : Removed prr.jurisdiction_code with
1302: OPEN cv FOR
1303: ' select distinct'||'''ER Tax Credits'''||' classification_name ,'||'''FUTA CREDIT'''||' balance_name ,

Line 1300: --hr_utility.trace('l_tname ='||l_tname);

1296: -- ||l_tname||'.jurisdiction_code jurisdiction_code
1297:
1298: --hr_utility.trace('l_futa_where ='||l_futa_where);
1299: --hr_utility.trace('l_futa_from ='||l_futa_from);
1300: --hr_utility.trace('l_tname ='||l_tname);
1301: -- Bug 5409416 : Removed prr.jurisdiction_code with
1302: OPEN cv FOR
1303: ' select distinct'||'''ER Tax Credits'''||' classification_name ,'||'''FUTA CREDIT'''||' balance_name ,
1304: pet.element_name element_name,'|| l_tname||'.jurisdiction_code jurisdiction_code

Line 1311: hr_utility.trace('statement build success');

1307: ' where '''||l_effective_date||''' between pet.effective_start_date and pet.effective_end_date
1308: and pet.element_name ='||'''FUTA CREDIT'''||
1309: ' and '||l_futa_where;
1310:
1311: hr_utility.trace('statement build success');
1312: loop
1313: fetch cv into l_classification_name,
1314: l_balance_name,
1315: l_element_name,

Line 1318: hr_utility.trace('assignment_Action_id in load_er_credit ='||to_char(l_assignment_action_id));

1314: l_balance_name,
1315: l_element_name,
1316: l_jurisdiction_code;
1317:
1318: hr_utility.trace('assignment_Action_id in load_er_credit ='||to_char(l_assignment_action_id));
1319: hr_utility.trace('Number of ER CREDIT Records fetched = '||to_char(cv%ROWCOUNT));
1320: exit when cv%notfound; */
1321:
1322: if p_futa_status_count = 1 then

Line 1319: hr_utility.trace('Number of ER CREDIT Records fetched = '||to_char(cv%ROWCOUNT));

1315: l_element_name,
1316: l_jurisdiction_code;
1317:
1318: hr_utility.trace('assignment_Action_id in load_er_credit ='||to_char(l_assignment_action_id));
1319: hr_utility.trace('Number of ER CREDIT Records fetched = '||to_char(cv%ROWCOUNT));
1320: exit when cv%notfound; */
1321:
1322: if p_futa_status_count = 1 then
1323: open csr_er_credit_rbr;

Line 1334: hr_utility.trace('assignment_Action_id in load_er_credit ='||to_char(l_assignment_action_id));

1330: fetch csr_er_credit_rbr into l_classification_name,
1331: l_balance_name,
1332: l_element_name,
1333: l_jurisdiction_code;
1334: hr_utility.trace('assignment_Action_id in load_er_credit ='||to_char(l_assignment_action_id));
1335: hr_utility.trace('Number of ER CREDIT Records fetched = '||to_char(csr_er_credit_rbr%ROWCOUNT));
1336: exit when csr_er_credit_rbr%notfound;
1337: else
1338: fetch csr_er_credit into l_classification_name,

Line 1335: hr_utility.trace('Number of ER CREDIT Records fetched = '||to_char(csr_er_credit_rbr%ROWCOUNT));

1331: l_balance_name,
1332: l_element_name,
1333: l_jurisdiction_code;
1334: hr_utility.trace('assignment_Action_id in load_er_credit ='||to_char(l_assignment_action_id));
1335: hr_utility.trace('Number of ER CREDIT Records fetched = '||to_char(csr_er_credit_rbr%ROWCOUNT));
1336: exit when csr_er_credit_rbr%notfound;
1337: else
1338: fetch csr_er_credit into l_classification_name,
1339: l_balance_name,

Line 1342: hr_utility.trace('assignment_Action_id in load_er_credit ='||to_char(l_assignment_action_id));

1338: fetch csr_er_credit into l_classification_name,
1339: l_balance_name,
1340: l_element_name,
1341: l_jurisdiction_code;
1342: hr_utility.trace('assignment_Action_id in load_er_credit ='||to_char(l_assignment_action_id));
1343: hr_utility.trace('Number of ER CREDIT Records fetched = '||to_char(csr_er_credit%ROWCOUNT));
1344: exit when csr_er_credit%notfound;
1345: end if;
1346:

Line 1343: hr_utility.trace('Number of ER CREDIT Records fetched = '||to_char(csr_er_credit%ROWCOUNT));

1339: l_balance_name,
1340: l_element_name,
1341: l_jurisdiction_code;
1342: hr_utility.trace('assignment_Action_id in load_er_credit ='||to_char(l_assignment_action_id));
1343: hr_utility.trace('Number of ER CREDIT Records fetched = '||to_char(csr_er_credit%ROWCOUNT));
1344: exit when csr_er_credit%notfound;
1345: end if;
1346:
1347: /*-- Bug#4942114 ends -- */

Line 1357: hr_utility.trace('l_bal_value : '|| l_bal_value );

1353: 'GRE',
1354: l_tax_unit_id,
1355: l_business_group_id,
1356: l_jurisdiction_code); -- 4443935
1357: hr_utility.trace('l_bal_value : '|| l_bal_value );
1358: if l_asg_flag <> 'Y' THEN
1359: if l_index <>0 then
1360: l_status :=0;
1361: for l_temp_index in g_totals_table.first..g_totals_table.last LOOP

Line 1367: hr_utility.trace('testing 1');

1363: g_totals_table(l_temp_index).gre_name = l_gre_name and
1364: g_totals_table(l_temp_index).organization_name = l_org_name and
1365: g_totals_table(l_temp_index).location_name = l_location_code then
1366:
1367: hr_utility.trace('testing 1');
1368: g_totals_table(l_temp_index).value2 := g_totals_table(l_temp_index).value2 +
1369: to_number(l_bal_value);
1370: l_status := 1;
1371: hr_utility.trace('bulk elename ='|| l_element_name);

Line 1371: hr_utility.trace('bulk elename ='|| l_element_name);

1367: hr_utility.trace('testing 1');
1368: g_totals_table(l_temp_index).value2 := g_totals_table(l_temp_index).value2 +
1369: to_number(l_bal_value);
1370: l_status := 1;
1371: hr_utility.trace('bulk elename ='|| l_element_name);
1372: hr_utility.trace('bulk cashval='|| l_bal_value);
1373: hr_utility.trace('bulk totalcashval='|| g_totals_table(l_temp_index).value2);
1374: end if;
1375: end loop;

Line 1372: hr_utility.trace('bulk cashval='|| l_bal_value);

1368: g_totals_table(l_temp_index).value2 := g_totals_table(l_temp_index).value2 +
1369: to_number(l_bal_value);
1370: l_status := 1;
1371: hr_utility.trace('bulk elename ='|| l_element_name);
1372: hr_utility.trace('bulk cashval='|| l_bal_value);
1373: hr_utility.trace('bulk totalcashval='|| g_totals_table(l_temp_index).value2);
1374: end if;
1375: end loop;
1376: end if;

Line 1373: hr_utility.trace('bulk totalcashval='|| g_totals_table(l_temp_index).value2);

1369: to_number(l_bal_value);
1370: l_status := 1;
1371: hr_utility.trace('bulk elename ='|| l_element_name);
1372: hr_utility.trace('bulk cashval='|| l_bal_value);
1373: hr_utility.trace('bulk totalcashval='|| g_totals_table(l_temp_index).value2);
1374: end if;
1375: end loop;
1376: end if;
1377: if l_status <> 1 or l_index = 0 then

Line 1378: hr_utility.trace('testing 6');

1374: end if;
1375: end loop;
1376: end if;
1377: if l_status <> 1 or l_index = 0 then
1378: hr_utility.trace('testing 6');
1379: l_index := l_index + 1;
1380: g_totals_table(l_index).gre_name := l_gre_name;
1381: g_totals_table(l_index).organization_name := l_org_name;
1382: g_totals_table(l_index).location_name := l_location_code;

Line 1392: hr_utility.trace('bulk elename ='|| l_element_name);

1388: g_totals_table(l_index).value3 := NULL;
1389: g_totals_table(l_index).attribute1 := 'ER-CREDIT';
1390: g_totals_table(l_index).attribute2 := '7';
1391: end if;
1392: hr_utility.trace('bulk elename ='|| l_element_name);
1393: hr_utility.trace('bulk cashval='|| l_bal_value);
1394: hr_utility.trace('gre name='||l_gre_name);
1395: hr_utility.trace('org name='||l_org_name);
1396: hr_utility.trace('loc name='||l_location_code);

Line 1393: hr_utility.trace('bulk cashval='|| l_bal_value);

1389: g_totals_table(l_index).attribute1 := 'ER-CREDIT';
1390: g_totals_table(l_index).attribute2 := '7';
1391: end if;
1392: hr_utility.trace('bulk elename ='|| l_element_name);
1393: hr_utility.trace('bulk cashval='|| l_bal_value);
1394: hr_utility.trace('gre name='||l_gre_name);
1395: hr_utility.trace('org name='||l_org_name);
1396: hr_utility.trace('loc name='||l_location_code);
1397: else

Line 1394: hr_utility.trace('gre name='||l_gre_name);

1390: g_totals_table(l_index).attribute2 := '7';
1391: end if;
1392: hr_utility.trace('bulk elename ='|| l_element_name);
1393: hr_utility.trace('bulk cashval='|| l_bal_value);
1394: hr_utility.trace('gre name='||l_gre_name);
1395: hr_utility.trace('org name='||l_org_name);
1396: hr_utility.trace('loc name='||l_location_code);
1397: else
1398: insert into pay_us_rpt_totals

Line 1395: hr_utility.trace('org name='||l_org_name);

1391: end if;
1392: hr_utility.trace('bulk elename ='|| l_element_name);
1393: hr_utility.trace('bulk cashval='|| l_bal_value);
1394: hr_utility.trace('gre name='||l_gre_name);
1395: hr_utility.trace('org name='||l_org_name);
1396: hr_utility.trace('loc name='||l_location_code);
1397: else
1398: insert into pay_us_rpt_totals
1399: (tax_unit_id, gre_name, organization_name, location_name,

Line 1396: hr_utility.trace('loc name='||l_location_code);

1392: hr_utility.trace('bulk elename ='|| l_element_name);
1393: hr_utility.trace('bulk cashval='|| l_bal_value);
1394: hr_utility.trace('gre name='||l_gre_name);
1395: hr_utility.trace('org name='||l_org_name);
1396: hr_utility.trace('loc name='||l_location_code);
1397: else
1398: insert into pay_us_rpt_totals
1399: (tax_unit_id, gre_name, organization_name, location_name,
1400: attribute1,

Line 1499: hr_utility.trace('entered er_liab');

1495: l_element_name varchar2(60);
1496: l_run_val number(20,2);
1497: l_status number :=0;
1498: BEGIN
1499: hr_utility.trace('entered er_liab');
1500:
1501: /*-- Bug#4942114 starts -- */
1502: /*open cv FOR
1503: 'select distinct pec.classification_name classification_name,

Line 1525: hr_utility.trace('assignment_Action_id in load_er_liab ='||to_char(l_assignment_action_id));

1521: loop
1522: fetch cv into l_classification_name,
1523: l_balance_name,
1524: l_element_name;
1525: hr_utility.trace('assignment_Action_id in load_er_liab ='||to_char(l_assignment_action_id));
1526: hr_utility.trace('Number of ER LIAB Records fetched = '||to_char(cv%ROWCOUNT));
1527: exit when cv%notfound; */
1528:
1529: if p_er_liab_status = 'Y' then

Line 1526: hr_utility.trace('Number of ER LIAB Records fetched = '||to_char(cv%ROWCOUNT));

1522: fetch cv into l_classification_name,
1523: l_balance_name,
1524: l_element_name;
1525: hr_utility.trace('assignment_Action_id in load_er_liab ='||to_char(l_assignment_action_id));
1526: hr_utility.trace('Number of ER LIAB Records fetched = '||to_char(cv%ROWCOUNT));
1527: exit when cv%notfound; */
1528:
1529: if p_er_liab_status = 'Y' then
1530: open csr_er_liab_rbr;

Line 1541: hr_utility.trace('assignment_Action_id in load_er_liab ='||to_char(l_assignment_action_id));

1537: if p_er_liab_status = 'Y' then
1538: fetch csr_er_liab_rbr into l_classification_name,
1539: l_balance_name,
1540: l_element_name;
1541: hr_utility.trace('assignment_Action_id in load_er_liab ='||to_char(l_assignment_action_id));
1542: hr_utility.trace('Number of ER LIAB Records fetched = '||to_char(csr_er_liab_rbr%ROWCOUNT));
1543: exit when csr_er_liab_rbr%notfound;
1544: else
1545: fetch csr_er_liab into l_classification_name,

Line 1542: hr_utility.trace('Number of ER LIAB Records fetched = '||to_char(csr_er_liab_rbr%ROWCOUNT));

1538: fetch csr_er_liab_rbr into l_classification_name,
1539: l_balance_name,
1540: l_element_name;
1541: hr_utility.trace('assignment_Action_id in load_er_liab ='||to_char(l_assignment_action_id));
1542: hr_utility.trace('Number of ER LIAB Records fetched = '||to_char(csr_er_liab_rbr%ROWCOUNT));
1543: exit when csr_er_liab_rbr%notfound;
1544: else
1545: fetch csr_er_liab into l_classification_name,
1546: l_balance_name,

Line 1548: hr_utility.trace('assignment_Action_id in load_er_liab ='||to_char(l_assignment_action_id));

1544: else
1545: fetch csr_er_liab into l_classification_name,
1546: l_balance_name,
1547: l_element_name;
1548: hr_utility.trace('assignment_Action_id in load_er_liab ='||to_char(l_assignment_action_id));
1549: hr_utility.trace('Number of ER LIAB Records fetched = '||to_char(csr_er_liab%ROWCOUNT));
1550: exit when csr_er_liab%notfound;
1551: end if;
1552: /*-- Bug#4942114 ends -- */

Line 1549: hr_utility.trace('Number of ER LIAB Records fetched = '||to_char(csr_er_liab%ROWCOUNT));

1545: fetch csr_er_liab into l_classification_name,
1546: l_balance_name,
1547: l_element_name;
1548: hr_utility.trace('assignment_Action_id in load_er_liab ='||to_char(l_assignment_action_id));
1549: hr_utility.trace('Number of ER LIAB Records fetched = '||to_char(csr_er_liab%ROWCOUNT));
1550: exit when csr_er_liab%notfound;
1551: end if;
1552: /*-- Bug#4942114 ends -- */
1553: l_bal_value := pay_us_taxbal_view_pkg.us_named_balance(upper(l_balance_name),

Line 1571: hr_utility.trace('testing 1');

1567: g_totals_table(l_temp_index).gre_name = l_gre_name and
1568: g_totals_table(l_temp_index).organization_name = l_org_name and
1569: g_totals_table(l_temp_index).location_name = l_location_code then
1570:
1571: hr_utility.trace('testing 1');
1572: g_totals_table(l_temp_index).value2 := g_totals_table(l_temp_index).value2 +
1573: to_number(l_bal_value);
1574: l_status := 1;
1575: hr_utility.trace('for er liab...l_index ='||l_index);

Line 1575: hr_utility.trace('for er liab...l_index ='||l_index);

1571: hr_utility.trace('testing 1');
1572: g_totals_table(l_temp_index).value2 := g_totals_table(l_temp_index).value2 +
1573: to_number(l_bal_value);
1574: l_status := 1;
1575: hr_utility.trace('for er liab...l_index ='||l_index);
1576: hr_utility.trace('element name ='||l_element_name);
1577: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1578: hr_utility.trace('gre_name='||l_gre_name);
1579: hr_utility.trace('org name='||l_org_name);

Line 1576: hr_utility.trace('element name ='||l_element_name);

1572: g_totals_table(l_temp_index).value2 := g_totals_table(l_temp_index).value2 +
1573: to_number(l_bal_value);
1574: l_status := 1;
1575: hr_utility.trace('for er liab...l_index ='||l_index);
1576: hr_utility.trace('element name ='||l_element_name);
1577: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1578: hr_utility.trace('gre_name='||l_gre_name);
1579: hr_utility.trace('org name='||l_org_name);
1580: hr_utility.trace('location='||l_location_code);

Line 1577: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));

1573: to_number(l_bal_value);
1574: l_status := 1;
1575: hr_utility.trace('for er liab...l_index ='||l_index);
1576: hr_utility.trace('element name ='||l_element_name);
1577: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1578: hr_utility.trace('gre_name='||l_gre_name);
1579: hr_utility.trace('org name='||l_org_name);
1580: hr_utility.trace('location='||l_location_code);
1581: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));

Line 1578: hr_utility.trace('gre_name='||l_gre_name);

1574: l_status := 1;
1575: hr_utility.trace('for er liab...l_index ='||l_index);
1576: hr_utility.trace('element name ='||l_element_name);
1577: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1578: hr_utility.trace('gre_name='||l_gre_name);
1579: hr_utility.trace('org name='||l_org_name);
1580: hr_utility.trace('location='||l_location_code);
1581: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
1582: hr_utility.trace('Cash Value ='||l_bal_value);

Line 1579: hr_utility.trace('org name='||l_org_name);

1575: hr_utility.trace('for er liab...l_index ='||l_index);
1576: hr_utility.trace('element name ='||l_element_name);
1577: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1578: hr_utility.trace('gre_name='||l_gre_name);
1579: hr_utility.trace('org name='||l_org_name);
1580: hr_utility.trace('location='||l_location_code);
1581: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
1582: hr_utility.trace('Cash Value ='||l_bal_value);
1583: end if;

Line 1580: hr_utility.trace('location='||l_location_code);

1576: hr_utility.trace('element name ='||l_element_name);
1577: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1578: hr_utility.trace('gre_name='||l_gre_name);
1579: hr_utility.trace('org name='||l_org_name);
1580: hr_utility.trace('location='||l_location_code);
1581: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
1582: hr_utility.trace('Cash Value ='||l_bal_value);
1583: end if;
1584: end loop;

Line 1581: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));

1577: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1578: hr_utility.trace('gre_name='||l_gre_name);
1579: hr_utility.trace('org name='||l_org_name);
1580: hr_utility.trace('location='||l_location_code);
1581: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
1582: hr_utility.trace('Cash Value ='||l_bal_value);
1583: end if;
1584: end loop;
1585: end if;

Line 1582: hr_utility.trace('Cash Value ='||l_bal_value);

1578: hr_utility.trace('gre_name='||l_gre_name);
1579: hr_utility.trace('org name='||l_org_name);
1580: hr_utility.trace('location='||l_location_code);
1581: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
1582: hr_utility.trace('Cash Value ='||l_bal_value);
1583: end if;
1584: end loop;
1585: end if;
1586: if l_status <> 1 or l_index = 0 then

Line 1587: hr_utility.trace('testing 6');

1583: end if;
1584: end loop;
1585: end if;
1586: if l_status <> 1 or l_index = 0 then
1587: hr_utility.trace('testing 6');
1588: l_index := l_index + 1;
1589: g_totals_table(l_index).gre_name := l_gre_name;
1590: g_totals_table(l_index).organization_name := l_org_name;
1591: g_totals_table(l_index).location_name := l_location_code;

Line 1601: hr_utility.trace('for er liab...l_index ='||l_index);

1597: g_totals_table(l_index).value3 := NULL;
1598: g_totals_table(l_index).attribute1 := 'ER-LIAB';
1599: g_totals_table(l_index).attribute2 := '5';
1600: end if;
1601: hr_utility.trace('for er liab...l_index ='||l_index);
1602: hr_utility.trace('element name ='||l_element_name);
1603: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1604: hr_utility.trace('gre_name='||l_gre_name);
1605: hr_utility.trace('org name='||l_org_name);

Line 1602: hr_utility.trace('element name ='||l_element_name);

1598: g_totals_table(l_index).attribute1 := 'ER-LIAB';
1599: g_totals_table(l_index).attribute2 := '5';
1600: end if;
1601: hr_utility.trace('for er liab...l_index ='||l_index);
1602: hr_utility.trace('element name ='||l_element_name);
1603: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1604: hr_utility.trace('gre_name='||l_gre_name);
1605: hr_utility.trace('org name='||l_org_name);
1606: hr_utility.trace('location='||l_location_code);

Line 1603: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));

1599: g_totals_table(l_index).attribute2 := '5';
1600: end if;
1601: hr_utility.trace('for er liab...l_index ='||l_index);
1602: hr_utility.trace('element name ='||l_element_name);
1603: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1604: hr_utility.trace('gre_name='||l_gre_name);
1605: hr_utility.trace('org name='||l_org_name);
1606: hr_utility.trace('location='||l_location_code);
1607: hr_utility.trace('Cash Value ='||l_bal_value);

Line 1604: hr_utility.trace('gre_name='||l_gre_name);

1600: end if;
1601: hr_utility.trace('for er liab...l_index ='||l_index);
1602: hr_utility.trace('element name ='||l_element_name);
1603: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1604: hr_utility.trace('gre_name='||l_gre_name);
1605: hr_utility.trace('org name='||l_org_name);
1606: hr_utility.trace('location='||l_location_code);
1607: hr_utility.trace('Cash Value ='||l_bal_value);
1608: else

Line 1605: hr_utility.trace('org name='||l_org_name);

1601: hr_utility.trace('for er liab...l_index ='||l_index);
1602: hr_utility.trace('element name ='||l_element_name);
1603: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1604: hr_utility.trace('gre_name='||l_gre_name);
1605: hr_utility.trace('org name='||l_org_name);
1606: hr_utility.trace('location='||l_location_code);
1607: hr_utility.trace('Cash Value ='||l_bal_value);
1608: else
1609: insert into pay_us_rpt_totals

Line 1606: hr_utility.trace('location='||l_location_code);

1602: hr_utility.trace('element name ='||l_element_name);
1603: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1604: hr_utility.trace('gre_name='||l_gre_name);
1605: hr_utility.trace('org name='||l_org_name);
1606: hr_utility.trace('location='||l_location_code);
1607: hr_utility.trace('Cash Value ='||l_bal_value);
1608: else
1609: insert into pay_us_rpt_totals
1610: (tax_unit_id, gre_name, organization_name, location_name,

Line 1607: hr_utility.trace('Cash Value ='||l_bal_value);

1603: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
1604: hr_utility.trace('gre_name='||l_gre_name);
1605: hr_utility.trace('org name='||l_org_name);
1606: hr_utility.trace('location='||l_location_code);
1607: hr_utility.trace('Cash Value ='||l_bal_value);
1608: else
1609: insert into pay_us_rpt_totals
1610: (tax_unit_id, gre_name, organization_name, location_name,
1611: attribute1,

Line 1644: hr_utility.trace('Error occurred load_er_liab ...' ||SQLERRM);

1640: end if;
1641: /*-- Bug#4942114 ends -- */
1642: exception
1643: when others then
1644: hr_utility.trace('Error occurred load_er_liab ...' ||SQLERRM);
1645: raise;
1646: end load_er_liab;
1647:
1648:

Line 1743: hr_utility.trace('Number of PPP_ACTION Records fetched = '||to_char(ppp_action%ROWCOUNT));

1739:
1740: open ppp_action ;
1741: loop
1742: fetch ppp_action into l_ppp_pre_payment_id;
1743: hr_utility.trace('Number of PPP_ACTION Records fetched = '||to_char(ppp_action%ROWCOUNT));
1744: exit when ppp_action%notfound;
1745: /* ppp_action found */
1746:
1747: open chk_ppp(l_ppp_pre_payment_id);

Line 1749: hr_utility.trace('Number of CHK_PPP Records fetched = '||to_char(chk_ppp%ROWCOUNT));

1745: /* ppp_action found */
1746:
1747: open chk_ppp(l_ppp_pre_payment_id);
1748: fetch chk_ppp into l_found;
1749: hr_utility.trace('Number of CHK_PPP Records fetched = '||to_char(chk_ppp%ROWCOUNT));
1750: if chk_ppp%notfound then
1751:
1752: open nacha_details;
1753: fetch nacha_details into l_payment_method_name, l_account_type,

Line 1864: hr_utility.trace('Error occurred load_mesg_line ...' ||SQLERRM);

1860: close ppp_action;
1861:
1862: exception
1863: when others then
1864: hr_utility.trace('Error occurred load_mesg_line ...' ||SQLERRM);
1865: raise;
1866: end load_mesg_line;
1867:
1868:

Line 1924: hr_utility.trace('Payroll_id = '||to_char(t_payroll_id));

1920:
1921: l_pmt_name varchar2(60);
1922: l_pmt_value number(20,2);
1923: begin
1924: hr_utility.trace('Payroll_id = '||to_char(t_payroll_id));
1925: hr_utility.trace('CONC_id = '||to_char(t_consolidation_set_id));
1926: hr_utility.trace('GRE_id = '||to_char(t_gre_id));
1927: hr_utility.trace('Start DT = '||to_char(l_leg_start_date));
1928: hr_utility.trace('END DT = '||to_char(l_leg_end_date));

Line 1925: hr_utility.trace('CONC_id = '||to_char(t_consolidation_set_id));

1921: l_pmt_name varchar2(60);
1922: l_pmt_value number(20,2);
1923: begin
1924: hr_utility.trace('Payroll_id = '||to_char(t_payroll_id));
1925: hr_utility.trace('CONC_id = '||to_char(t_consolidation_set_id));
1926: hr_utility.trace('GRE_id = '||to_char(t_gre_id));
1927: hr_utility.trace('Start DT = '||to_char(l_leg_start_date));
1928: hr_utility.trace('END DT = '||to_char(l_leg_end_date));
1929:

Line 1926: hr_utility.trace('GRE_id = '||to_char(t_gre_id));

1922: l_pmt_value number(20,2);
1923: begin
1924: hr_utility.trace('Payroll_id = '||to_char(t_payroll_id));
1925: hr_utility.trace('CONC_id = '||to_char(t_consolidation_set_id));
1926: hr_utility.trace('GRE_id = '||to_char(t_gre_id));
1927: hr_utility.trace('Start DT = '||to_char(l_leg_start_date));
1928: hr_utility.trace('END DT = '||to_char(l_leg_end_date));
1929:
1930: -- Determine is this assignment_action is the max action sequence.

Line 1927: hr_utility.trace('Start DT = '||to_char(l_leg_start_date));

1923: begin
1924: hr_utility.trace('Payroll_id = '||to_char(t_payroll_id));
1925: hr_utility.trace('CONC_id = '||to_char(t_consolidation_set_id));
1926: hr_utility.trace('GRE_id = '||to_char(t_gre_id));
1927: hr_utility.trace('Start DT = '||to_char(l_leg_start_date));
1928: hr_utility.trace('END DT = '||to_char(l_leg_end_date));
1929:
1930: -- Determine is this assignment_action is the max action sequence.
1931:

Line 1928: hr_utility.trace('END DT = '||to_char(l_leg_end_date));

1924: hr_utility.trace('Payroll_id = '||to_char(t_payroll_id));
1925: hr_utility.trace('CONC_id = '||to_char(t_consolidation_set_id));
1926: hr_utility.trace('GRE_id = '||to_char(t_gre_id));
1927: hr_utility.trace('Start DT = '||to_char(l_leg_start_date));
1928: hr_utility.trace('END DT = '||to_char(l_leg_end_date));
1929:
1930: -- Determine is this assignment_action is the max action sequence.
1931:
1932: select paa_outer.assignment_action_id

Line 1967: hr_utility.trace('Number of prepay Records fetched = '||to_char(prepay%ROWCOUNT));

1963: fetch prepay into l_pre_pay_aaid,
1964: l_pmt_name,
1965: l_pmt_value,
1966: l_pre_pay_id;
1967: hr_utility.trace('Number of prepay Records fetched = '||to_char(prepay%ROWCOUNT));
1968: exit when prepay%notfound;
1969:
1970: BEGIN
1971:

Line 2013: hr_utility.trace('Error occurred load_prepay ...' ||SQLERRM);

2009:
2010: END IF;
2011: exception
2012: when others then
2013: hr_utility.trace('Error occurred load_prepay ...' ||SQLERRM);
2014: raise;
2015: end load_prepay;
2016:
2017:

Line 2025: hr_utility.trace('Entered Reversals...');

2021:
2022: l_reverse_amt number(12,2);
2023:
2024: begin
2025: hr_utility.trace('Entered Reversals...');
2026: pay_balance_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
2027: l_reverse_amt := nvl(pay_balance_pkg.get_value(
2028: p_defined_balance_id => l_defined_balance_id,
2029: p_assignment_action_id => l_assignment_action_id),0);

Line 2049: hr_utility.trace('Exited Reversals...');

2045: '1',
2046: 'Reversals',
2047: 'Reversals',
2048: l_reverse_amt, l_assignment_action_id);
2049: hr_utility.trace('Exited Reversals...');
2050: exception
2051: when others then
2052: hr_utility.trace('Error occurred load_reversals ...' ||SQLERRM);
2053: raise;

Line 2052: hr_utility.trace('Error occurred load_reversals ...' ||SQLERRM);

2048: l_reverse_amt, l_assignment_action_id);
2049: hr_utility.trace('Exited Reversals...');
2050: exception
2051: when others then
2052: hr_utility.trace('Error occurred load_reversals ...' ||SQLERRM);
2053: raise;
2054: end load_reversals;
2055:
2056: -------------------------------------------------------------------------------------------

Line 2159: hr_utility.trace('entered load_wc_er_liab');

2155: l_run_val number(20,2);
2156: l_state_name varchar2(60);
2157: l_status number;
2158: BEGIN
2159: hr_utility.trace('entered load_wc_er_liab');
2160:
2161: /*-- Bug#4942114 starts -- */
2162: /* hr_utility.trace('l_wc_er_liab_where ='|| l_wc_er_liab_where);
2163: OPEN cv FOR

Line 2162: /* hr_utility.trace('l_wc_er_liab_where ='|| l_wc_er_liab_where);

2158: BEGIN
2159: hr_utility.trace('entered load_wc_er_liab');
2160:
2161: /*-- Bug#4942114 starts -- */
2162: /* hr_utility.trace('l_wc_er_liab_where ='|| l_wc_er_liab_where);
2163: OPEN cv FOR
2164: 'select pec.classification_name classification_name,
2165: pbt.balance_name balance_name,
2166: pet.element_name element_name,

Line 2203: hr_utility.trace('Number of WC ER LIAB Records fetched = '||to_char(cv%ROWCOUNT));

2199: l_balance_name,
2200: l_element_name,
2201: l_jurisdiction_code,
2202: l_state_name ;
2203: hr_utility.trace('Number of WC ER LIAB Records fetched = '||to_char(cv%ROWCOUNT));
2204: exit when cv%notfound; */
2205:
2206: if p_wc_er_liab_status_count = 3 then
2207: open csr_wc_er_liab_rbr;

Line 2220: hr_utility.trace('Number of WC ER LIAB Records fetched = '||to_char(csr_wc_er_liab_rbr%ROWCOUNT));

2216: l_balance_name,
2217: l_element_name,
2218: l_jurisdiction_code,
2219: l_state_name ;
2220: hr_utility.trace('Number of WC ER LIAB Records fetched = '||to_char(csr_wc_er_liab_rbr%ROWCOUNT));
2221: exit when csr_wc_er_liab_rbr%notfound;
2222: else
2223: fetch csr_wc_er_liab into l_classification_name,
2224: l_balance_name,

Line 2228: hr_utility.trace('Number of WC ER LIAB Records fetched = '||to_char(csr_wc_er_liab%ROWCOUNT));

2224: l_balance_name,
2225: l_element_name,
2226: l_jurisdiction_code,
2227: l_state_name ;
2228: hr_utility.trace('Number of WC ER LIAB Records fetched = '||to_char(csr_wc_er_liab%ROWCOUNT));
2229: exit when csr_wc_er_liab%notfound;
2230:
2231: end if;
2232:

Line 2253: hr_utility.trace('testing 1');

2249: g_totals_table(l_temp_index).gre_name = l_gre_name and
2250: g_totals_table(l_temp_index).organization_name = l_org_name and
2251: g_totals_table(l_temp_index).location_name = l_location_code then
2252:
2253: hr_utility.trace('testing 1');
2254: g_totals_table(l_temp_index).value2 := g_totals_table(l_temp_index).value2 +
2255: to_number(l_bal_value);
2256: l_status := 1;
2257: hr_utility.trace('for wc er liab...l_index ='||l_index);

Line 2257: hr_utility.trace('for wc er liab...l_index ='||l_index);

2253: hr_utility.trace('testing 1');
2254: g_totals_table(l_temp_index).value2 := g_totals_table(l_temp_index).value2 +
2255: to_number(l_bal_value);
2256: l_status := 1;
2257: hr_utility.trace('for wc er liab...l_index ='||l_index);
2258: hr_utility.trace('element name ='||l_element_name||' '||l_state_name);
2259: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
2260: hr_utility.trace('gre_name='||l_gre_name);
2261: hr_utility.trace('org name='||l_org_name);

Line 2258: hr_utility.trace('element name ='||l_element_name||' '||l_state_name);

2254: g_totals_table(l_temp_index).value2 := g_totals_table(l_temp_index).value2 +
2255: to_number(l_bal_value);
2256: l_status := 1;
2257: hr_utility.trace('for wc er liab...l_index ='||l_index);
2258: hr_utility.trace('element name ='||l_element_name||' '||l_state_name);
2259: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
2260: hr_utility.trace('gre_name='||l_gre_name);
2261: hr_utility.trace('org name='||l_org_name);
2262: hr_utility.trace('location='||l_location_code);

Line 2259: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));

2255: to_number(l_bal_value);
2256: l_status := 1;
2257: hr_utility.trace('for wc er liab...l_index ='||l_index);
2258: hr_utility.trace('element name ='||l_element_name||' '||l_state_name);
2259: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
2260: hr_utility.trace('gre_name='||l_gre_name);
2261: hr_utility.trace('org name='||l_org_name);
2262: hr_utility.trace('location='||l_location_code);
2263: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));

Line 2260: hr_utility.trace('gre_name='||l_gre_name);

2256: l_status := 1;
2257: hr_utility.trace('for wc er liab...l_index ='||l_index);
2258: hr_utility.trace('element name ='||l_element_name||' '||l_state_name);
2259: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
2260: hr_utility.trace('gre_name='||l_gre_name);
2261: hr_utility.trace('org name='||l_org_name);
2262: hr_utility.trace('location='||l_location_code);
2263: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
2264: hr_utility.trace('Cash Value ='||l_bal_value);

Line 2261: hr_utility.trace('org name='||l_org_name);

2257: hr_utility.trace('for wc er liab...l_index ='||l_index);
2258: hr_utility.trace('element name ='||l_element_name||' '||l_state_name);
2259: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
2260: hr_utility.trace('gre_name='||l_gre_name);
2261: hr_utility.trace('org name='||l_org_name);
2262: hr_utility.trace('location='||l_location_code);
2263: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
2264: hr_utility.trace('Cash Value ='||l_bal_value);
2265: end if;

Line 2262: hr_utility.trace('location='||l_location_code);

2258: hr_utility.trace('element name ='||l_element_name||' '||l_state_name);
2259: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
2260: hr_utility.trace('gre_name='||l_gre_name);
2261: hr_utility.trace('org name='||l_org_name);
2262: hr_utility.trace('location='||l_location_code);
2263: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
2264: hr_utility.trace('Cash Value ='||l_bal_value);
2265: end if;
2266: end loop;

Line 2263: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));

2259: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
2260: hr_utility.trace('gre_name='||l_gre_name);
2261: hr_utility.trace('org name='||l_org_name);
2262: hr_utility.trace('location='||l_location_code);
2263: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
2264: hr_utility.trace('Cash Value ='||l_bal_value);
2265: end if;
2266: end loop;
2267: end if;

Line 2264: hr_utility.trace('Cash Value ='||l_bal_value);

2260: hr_utility.trace('gre_name='||l_gre_name);
2261: hr_utility.trace('org name='||l_org_name);
2262: hr_utility.trace('location='||l_location_code);
2263: hr_utility.trace('Toal Cash value ='||to_char(g_totals_table(l_temp_index).value2));
2264: hr_utility.trace('Cash Value ='||l_bal_value);
2265: end if;
2266: end loop;
2267: end if;
2268: if l_status <> 1 or l_index = 0 then

Line 2269: hr_utility.trace('testing 6');

2265: end if;
2266: end loop;
2267: end if;
2268: if l_status <> 1 or l_index = 0 then
2269: hr_utility.trace('testing 6');
2270: l_index := l_index + 1;
2271: g_totals_table(l_index).gre_name := l_gre_name;
2272: g_totals_table(l_index).organization_name := l_org_name;
2273: g_totals_table(l_index).location_name := l_location_code;

Line 2283: hr_utility.trace('for wc er liab...l_index ='||l_index);

2279: g_totals_table(l_index).value3 := NULL;
2280: g_totals_table(l_index).attribute1 := 'ER-TAX';
2281: g_totals_table(l_index).attribute2 := '6';
2282: end if;
2283: hr_utility.trace('for wc er liab...l_index ='||l_index);
2284: hr_utility.trace('element name ='||l_element_name||' '||l_state_name);
2285: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
2286: hr_utility.trace('gre_name='||l_gre_name);
2287: hr_utility.trace('org name='||l_org_name);

Line 2284: hr_utility.trace('element name ='||l_element_name||' '||l_state_name);

2280: g_totals_table(l_index).attribute1 := 'ER-TAX';
2281: g_totals_table(l_index).attribute2 := '6';
2282: end if;
2283: hr_utility.trace('for wc er liab...l_index ='||l_index);
2284: hr_utility.trace('element name ='||l_element_name||' '||l_state_name);
2285: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
2286: hr_utility.trace('gre_name='||l_gre_name);
2287: hr_utility.trace('org name='||l_org_name);
2288: hr_utility.trace('location='||l_location_code);

Line 2285: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));

2281: g_totals_table(l_index).attribute2 := '6';
2282: end if;
2283: hr_utility.trace('for wc er liab...l_index ='||l_index);
2284: hr_utility.trace('element name ='||l_element_name||' '||l_state_name);
2285: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
2286: hr_utility.trace('gre_name='||l_gre_name);
2287: hr_utility.trace('org name='||l_org_name);
2288: hr_utility.trace('location='||l_location_code);
2289: hr_utility.trace('Cash Value ='||l_bal_value);

Line 2286: hr_utility.trace('gre_name='||l_gre_name);

2282: end if;
2283: hr_utility.trace('for wc er liab...l_index ='||l_index);
2284: hr_utility.trace('element name ='||l_element_name||' '||l_state_name);
2285: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
2286: hr_utility.trace('gre_name='||l_gre_name);
2287: hr_utility.trace('org name='||l_org_name);
2288: hr_utility.trace('location='||l_location_code);
2289: hr_utility.trace('Cash Value ='||l_bal_value);
2290: else

Line 2287: hr_utility.trace('org name='||l_org_name);

2283: hr_utility.trace('for wc er liab...l_index ='||l_index);
2284: hr_utility.trace('element name ='||l_element_name||' '||l_state_name);
2285: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
2286: hr_utility.trace('gre_name='||l_gre_name);
2287: hr_utility.trace('org name='||l_org_name);
2288: hr_utility.trace('location='||l_location_code);
2289: hr_utility.trace('Cash Value ='||l_bal_value);
2290: else
2291: insert into pay_us_rpt_totals

Line 2288: hr_utility.trace('location='||l_location_code);

2284: hr_utility.trace('element name ='||l_element_name||' '||l_state_name);
2285: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
2286: hr_utility.trace('gre_name='||l_gre_name);
2287: hr_utility.trace('org name='||l_org_name);
2288: hr_utility.trace('location='||l_location_code);
2289: hr_utility.trace('Cash Value ='||l_bal_value);
2290: else
2291: insert into pay_us_rpt_totals
2292: (tax_unit_id, gre_name, organization_name, location_name,

Line 2289: hr_utility.trace('Cash Value ='||l_bal_value);

2285: hr_utility.trace('payroll action='||to_char(g_totals_table(l_index).tax_unit_id));
2286: hr_utility.trace('gre_name='||l_gre_name);
2287: hr_utility.trace('org name='||l_org_name);
2288: hr_utility.trace('location='||l_location_code);
2289: hr_utility.trace('Cash Value ='||l_bal_value);
2290: else
2291: insert into pay_us_rpt_totals
2292: (tax_unit_id, gre_name, organization_name, location_name,
2293: attribute1,

Line 2326: hr_utility.trace('Error occurred load_wc_er_liab ...' ||SQLERRM);

2322: end if;
2323: /*-- Bug#4942114 ends -- */
2324: exception
2325: when others then
2326: hr_utility.trace('Error occurred load_wc_er_liab ...' ||SQLERRM);
2327: raise;
2328: end load_wc_er_liab;
2329: -----------------------------------------------------------------------------------
2330: procedure load_data

Line 2393: -- hr_utility.trace_on('Y','GTN');

2389: l_er_liab_from varchar2(2000);
2390: l_wc_er_liab_where varchar2(2000);
2391: l_wc_er_liab_from varchar2(2000);
2392: begin
2393: -- hr_utility.trace_on('Y','GTN');
2394: l_row_count := 0;
2395: hr_utility.trace('PACTID = '||pactid);
2396: hr_utility.trace('CHNKNO = '||to_char(chnkno));
2397: hr_utility.trace('PPA_FINDER = '||ppa_finder);

Line 2395: hr_utility.trace('PACTID = '||pactid);

2391: l_wc_er_liab_from varchar2(2000);
2392: begin
2393: -- hr_utility.trace_on('Y','GTN');
2394: l_row_count := 0;
2395: hr_utility.trace('PACTID = '||pactid);
2396: hr_utility.trace('CHNKNO = '||to_char(chnkno));
2397: hr_utility.trace('PPA_FINDER = '||ppa_finder);
2398: begin
2399: select ppa.legislative_parameters,

Line 2396: hr_utility.trace('CHNKNO = '||to_char(chnkno));

2392: begin
2393: -- hr_utility.trace_on('Y','GTN');
2394: l_row_count := 0;
2395: hr_utility.trace('PACTID = '||pactid);
2396: hr_utility.trace('CHNKNO = '||to_char(chnkno));
2397: hr_utility.trace('PPA_FINDER = '||ppa_finder);
2398: begin
2399: select ppa.legislative_parameters,
2400: ppa.business_group_id,

Line 2397: hr_utility.trace('PPA_FINDER = '||ppa_finder);

2393: -- hr_utility.trace_on('Y','GTN');
2394: l_row_count := 0;
2395: hr_utility.trace('PACTID = '||pactid);
2396: hr_utility.trace('CHNKNO = '||to_char(chnkno));
2397: hr_utility.trace('PPA_FINDER = '||ppa_finder);
2398: begin
2399: select ppa.legislative_parameters,
2400: ppa.business_group_id,
2401: ppa.start_date,

Line 2418: hr_utility.trace('Legislative Details not found...');

2414: t_payroll_action_id
2415: from pay_payroll_actions ppa
2416: where ppa.payroll_action_id = pactid;
2417: exception when no_data_found then
2418: hr_utility.trace('Legislative Details not found...');
2419: raise;
2420: end;
2421:
2422: begin

Line 2432: hr_utility.trace('Error getting defined balance id');

2428: and ue.user_entity_id = di.user_entity_id
2429: and ue.creator_type = 'B'
2430: and nvl(ue.legislation_code,'US') = 'US';
2431: exception when others then
2432: hr_utility.trace('Error getting defined balance id');
2433: raise;
2434: end;
2435:
2436: -- #3270485: moved to range_cursor procedure.

Line 2497: hr_utility.trace('Number of Records fetched = '||to_char(sel_aaid%ROWCOUNT));

2493: l_location_code,
2494: l_assignment_number,
2495: l_person_id;
2496:
2497: hr_utility.trace('Number of Records fetched = '||to_char(sel_aaid%ROWCOUNT));
2498: exit when sel_aaid%notfound;
2499:
2500: hr_utility.trace('Chunk No = '||to_char(chnkno));
2501: hr_utility.trace('Start Date = '||to_char(l_start_date));

Line 2500: hr_utility.trace('Chunk No = '||to_char(chnkno));

2496:
2497: hr_utility.trace('Number of Records fetched = '||to_char(sel_aaid%ROWCOUNT));
2498: exit when sel_aaid%notfound;
2499:
2500: hr_utility.trace('Chunk No = '||to_char(chnkno));
2501: hr_utility.trace('Start Date = '||to_char(l_start_date));
2502: hr_utility.trace('End Date = '||to_char(l_end_date));
2503: hr_utility.trace('BG ID = '||to_char(l_business_group_id));
2504: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));

Line 2501: hr_utility.trace('Start Date = '||to_char(l_start_date));

2497: hr_utility.trace('Number of Records fetched = '||to_char(sel_aaid%ROWCOUNT));
2498: exit when sel_aaid%notfound;
2499:
2500: hr_utility.trace('Chunk No = '||to_char(chnkno));
2501: hr_utility.trace('Start Date = '||to_char(l_start_date));
2502: hr_utility.trace('End Date = '||to_char(l_end_date));
2503: hr_utility.trace('BG ID = '||to_char(l_business_group_id));
2504: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
2505: hr_utility.trace('Effective Date = '||to_char(l_effective_date));

Line 2502: hr_utility.trace('End Date = '||to_char(l_end_date));

2498: exit when sel_aaid%notfound;
2499:
2500: hr_utility.trace('Chunk No = '||to_char(chnkno));
2501: hr_utility.trace('Start Date = '||to_char(l_start_date));
2502: hr_utility.trace('End Date = '||to_char(l_end_date));
2503: hr_utility.trace('BG ID = '||to_char(l_business_group_id));
2504: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
2505: hr_utility.trace('Effective Date = '||to_char(l_effective_date));
2506: hr_utility.trace('Action Type = '||l_action_type);

Line 2503: hr_utility.trace('BG ID = '||to_char(l_business_group_id));

2499:
2500: hr_utility.trace('Chunk No = '||to_char(chnkno));
2501: hr_utility.trace('Start Date = '||to_char(l_start_date));
2502: hr_utility.trace('End Date = '||to_char(l_end_date));
2503: hr_utility.trace('BG ID = '||to_char(l_business_group_id));
2504: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
2505: hr_utility.trace('Effective Date = '||to_char(l_effective_date));
2506: hr_utility.trace('Action Type = '||l_action_type);
2507: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));

Line 2504: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));

2500: hr_utility.trace('Chunk No = '||to_char(chnkno));
2501: hr_utility.trace('Start Date = '||to_char(l_start_date));
2502: hr_utility.trace('End Date = '||to_char(l_end_date));
2503: hr_utility.trace('BG ID = '||to_char(l_business_group_id));
2504: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
2505: hr_utility.trace('Effective Date = '||to_char(l_effective_date));
2506: hr_utility.trace('Action Type = '||l_action_type);
2507: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));
2508: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));

Line 2505: hr_utility.trace('Effective Date = '||to_char(l_effective_date));

2501: hr_utility.trace('Start Date = '||to_char(l_start_date));
2502: hr_utility.trace('End Date = '||to_char(l_end_date));
2503: hr_utility.trace('BG ID = '||to_char(l_business_group_id));
2504: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
2505: hr_utility.trace('Effective Date = '||to_char(l_effective_date));
2506: hr_utility.trace('Action Type = '||l_action_type);
2507: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));
2508: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
2509: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));

Line 2506: hr_utility.trace('Action Type = '||l_action_type);

2502: hr_utility.trace('End Date = '||to_char(l_end_date));
2503: hr_utility.trace('BG ID = '||to_char(l_business_group_id));
2504: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
2505: hr_utility.trace('Effective Date = '||to_char(l_effective_date));
2506: hr_utility.trace('Action Type = '||l_action_type);
2507: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));
2508: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
2509: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));
2510: hr_utility.trace('GRE Name = '||l_gre_name);

Line 2507: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));

2503: hr_utility.trace('BG ID = '||to_char(l_business_group_id));
2504: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
2505: hr_utility.trace('Effective Date = '||to_char(l_effective_date));
2506: hr_utility.trace('Action Type = '||l_action_type);
2507: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));
2508: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
2509: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));
2510: hr_utility.trace('GRE Name = '||l_gre_name);
2511: hr_utility.trace('ORG ID = '||to_char(l_organization_id));

Line 2508: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));

2504: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
2505: hr_utility.trace('Effective Date = '||to_char(l_effective_date));
2506: hr_utility.trace('Action Type = '||l_action_type);
2507: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));
2508: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
2509: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));
2510: hr_utility.trace('GRE Name = '||l_gre_name);
2511: hr_utility.trace('ORG ID = '||to_char(l_organization_id));
2512: hr_utility.trace('ORG Name = '||l_org_name);

Line 2509: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));

2505: hr_utility.trace('Effective Date = '||to_char(l_effective_date));
2506: hr_utility.trace('Action Type = '||l_action_type);
2507: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));
2508: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
2509: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));
2510: hr_utility.trace('GRE Name = '||l_gre_name);
2511: hr_utility.trace('ORG ID = '||to_char(l_organization_id));
2512: hr_utility.trace('ORG Name = '||l_org_name);
2513: hr_utility.trace('Loc ID = '||to_char(l_location_id));

Line 2510: hr_utility.trace('GRE Name = '||l_gre_name);

2506: hr_utility.trace('Action Type = '||l_action_type);
2507: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));
2508: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
2509: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));
2510: hr_utility.trace('GRE Name = '||l_gre_name);
2511: hr_utility.trace('ORG ID = '||to_char(l_organization_id));
2512: hr_utility.trace('ORG Name = '||l_org_name);
2513: hr_utility.trace('Loc ID = '||to_char(l_location_id));
2514: hr_utility.trace('Loc Code = '||l_location_code);

Line 2511: hr_utility.trace('ORG ID = '||to_char(l_organization_id));

2507: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));
2508: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
2509: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));
2510: hr_utility.trace('GRE Name = '||l_gre_name);
2511: hr_utility.trace('ORG ID = '||to_char(l_organization_id));
2512: hr_utility.trace('ORG Name = '||l_org_name);
2513: hr_utility.trace('Loc ID = '||to_char(l_location_id));
2514: hr_utility.trace('Loc Code = '||l_location_code);
2515: /*--Bug#4942114 starts --*/

Line 2512: hr_utility.trace('ORG Name = '||l_org_name);

2508: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
2509: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));
2510: hr_utility.trace('GRE Name = '||l_gre_name);
2511: hr_utility.trace('ORG ID = '||to_char(l_organization_id));
2512: hr_utility.trace('ORG Name = '||l_org_name);
2513: hr_utility.trace('Loc ID = '||to_char(l_location_id));
2514: hr_utility.trace('Loc Code = '||l_location_code);
2515: /*--Bug#4942114 starts --*/
2516: /*load_deductions(l_assignment_action_id,l_ded_view_name);

Line 2513: hr_utility.trace('Loc ID = '||to_char(l_location_id));

2509: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));
2510: hr_utility.trace('GRE Name = '||l_gre_name);
2511: hr_utility.trace('ORG ID = '||to_char(l_organization_id));
2512: hr_utility.trace('ORG Name = '||l_org_name);
2513: hr_utility.trace('Loc ID = '||to_char(l_location_id));
2514: hr_utility.trace('Loc Code = '||l_location_code);
2515: /*--Bug#4942114 starts --*/
2516: /*load_deductions(l_assignment_action_id,l_ded_view_name);
2517: load_earnings (l_assignment_action_id,l_earn_view_name);

Line 2514: hr_utility.trace('Loc Code = '||l_location_code);

2510: hr_utility.trace('GRE Name = '||l_gre_name);
2511: hr_utility.trace('ORG ID = '||to_char(l_organization_id));
2512: hr_utility.trace('ORG Name = '||l_org_name);
2513: hr_utility.trace('Loc ID = '||to_char(l_location_id));
2514: hr_utility.trace('Loc Code = '||l_location_code);
2515: /*--Bug#4942114 starts --*/
2516: /*load_deductions(l_assignment_action_id,l_ded_view_name);
2517: load_earnings (l_assignment_action_id,l_earn_view_name);
2518: -- load_alien_earnings (l_assignment_action_id);

Line 2539: hr_utility.trace('End of LOAD DATA');

2535: l_row_count := 0;
2536: commit;
2537: end if;
2538: end loop;
2539: hr_utility.trace('End of LOAD DATA');
2540: close sel_aaid;
2541: if (l_index <>0) then
2542: for x in g_totals_table.first..g_totals_table.last LOOP
2543: INSERT INTO pay_us_rpt_totals(tax_unit_id, gre_name,

Line 2574: hr_utility.trace('Error occurred load_data ...' ||SQLERRM);

2570: end if;
2571: commit;
2572: exception
2573: when others then
2574: hr_utility.trace('Error occurred load_data ...' ||SQLERRM);
2575: raise;
2576: end load_data;
2577:
2578: procedure load_data

Line 2664: -- hr_utility.trace_on('Y','GTN');

2660: where ppf.person_id = l_person_id
2661: and l_effective_date between ppf.effective_start_date and ppf.effective_end_date;
2662: l_chnk_number number;
2663: begin
2664: -- hr_utility.trace_on('Y','GTN');
2665: l_row_count := 0;
2666: hr_utility.trace('PPCTID = '||p_payroll_action_id);
2667: hr_utility.trace('PPA_FINDER = '||ppa_finder);
2668: hr_utility.trace('p_asg_flag ='||p_asg_flag);

Line 2666: hr_utility.trace('PPCTID = '||p_payroll_action_id);

2662: l_chnk_number number;
2663: begin
2664: -- hr_utility.trace_on('Y','GTN');
2665: l_row_count := 0;
2666: hr_utility.trace('PPCTID = '||p_payroll_action_id);
2667: hr_utility.trace('PPA_FINDER = '||ppa_finder);
2668: hr_utility.trace('p_asg_flag ='||p_asg_flag);
2669:
2670: begin

Line 2667: hr_utility.trace('PPA_FINDER = '||ppa_finder);

2663: begin
2664: -- hr_utility.trace_on('Y','GTN');
2665: l_row_count := 0;
2666: hr_utility.trace('PPCTID = '||p_payroll_action_id);
2667: hr_utility.trace('PPA_FINDER = '||ppa_finder);
2668: hr_utility.trace('p_asg_flag ='||p_asg_flag);
2669:
2670: begin
2671: select to_number(ue.creator_id)

Line 2668: hr_utility.trace('p_asg_flag ='||p_asg_flag);

2664: -- hr_utility.trace_on('Y','GTN');
2665: l_row_count := 0;
2666: hr_utility.trace('PPCTID = '||p_payroll_action_id);
2667: hr_utility.trace('PPA_FINDER = '||ppa_finder);
2668: hr_utility.trace('p_asg_flag ='||p_asg_flag);
2669:
2670: begin
2671: select to_number(ue.creator_id)
2672: into l_defined_balance_id

Line 2680: hr_utility.trace('Error getting defined balance id');

2676: and ue.user_entity_id = di.user_entity_id
2677: and ue.creator_type = 'B'
2678: and nvl(ue.legislation_code,'US') = 'US';
2679: exception when others then
2680: hr_utility.trace('Error getting defined balance id');
2681: raise;
2682: end;
2683:
2684: -- #3270485: moved to range_cursor procedure.

Line 2697: hr_utility.trace('l_asg_flag ='||l_asg_flag);

2693: -- commit;
2694: -- end if;
2695:
2696: l_asg_flag := nvl(p_asg_flag,'N');
2697: hr_utility.trace('l_asg_flag ='||l_asg_flag);
2698: pay_us_balance_view_pkg.set_view_mode('ASG');
2699: pay_us_balance_view_pkg.set_calc_all_timetypes_flag(0);
2700: pay_us_balance_view_pkg.set_session_var('PTD', 'FALSE');
2701: pay_us_balance_view_pkg.set_session_var('PYDATE', 'FALSE');

Line 2730: hr_utility.trace('Number of Records fetched = '||to_char(sel_aaid%ROWCOUNT));

2726: l_assignment_number,
2727: l_person_id,
2728: l_chnk_number;
2729:
2730: hr_utility.trace('Number of Records fetched = '||to_char(sel_aaid%ROWCOUNT));
2731:
2732: exit when sel_aaid%notfound;
2733: open sel_empname(l_person_id,l_effective_date);
2734: fetch sel_empname into l_full_name;

Line 2754: hr_utility.trace('Legislative Details not found...');

2750: t_payroll_action_id
2751: from pay_payroll_actions ppa
2752: where ppa.payroll_action_id = l_payroll_action_id;
2753: exception when no_data_found then
2754: hr_utility.trace('Legislative Details not found...');
2755: raise;
2756: end;
2757: hr_utility.trace('Start Date = '||to_char(l_start_date));
2758: hr_utility.trace('End Date = '||to_char(l_end_date));

Line 2757: hr_utility.trace('Start Date = '||to_char(l_start_date));

2753: exception when no_data_found then
2754: hr_utility.trace('Legislative Details not found...');
2755: raise;
2756: end;
2757: hr_utility.trace('Start Date = '||to_char(l_start_date));
2758: hr_utility.trace('End Date = '||to_char(l_end_date));
2759: hr_utility.trace('BG ID = '||to_char(l_business_group_id));
2760: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
2761: hr_utility.trace('Effective Date = '||to_char(l_effective_date));

Line 2758: hr_utility.trace('End Date = '||to_char(l_end_date));

2754: hr_utility.trace('Legislative Details not found...');
2755: raise;
2756: end;
2757: hr_utility.trace('Start Date = '||to_char(l_start_date));
2758: hr_utility.trace('End Date = '||to_char(l_end_date));
2759: hr_utility.trace('BG ID = '||to_char(l_business_group_id));
2760: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
2761: hr_utility.trace('Effective Date = '||to_char(l_effective_date));
2762: hr_utility.trace('Action Type = '||l_action_type);

Line 2759: hr_utility.trace('BG ID = '||to_char(l_business_group_id));

2755: raise;
2756: end;
2757: hr_utility.trace('Start Date = '||to_char(l_start_date));
2758: hr_utility.trace('End Date = '||to_char(l_end_date));
2759: hr_utility.trace('BG ID = '||to_char(l_business_group_id));
2760: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
2761: hr_utility.trace('Effective Date = '||to_char(l_effective_date));
2762: hr_utility.trace('Action Type = '||l_action_type);
2763: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));

Line 2760: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));

2756: end;
2757: hr_utility.trace('Start Date = '||to_char(l_start_date));
2758: hr_utility.trace('End Date = '||to_char(l_end_date));
2759: hr_utility.trace('BG ID = '||to_char(l_business_group_id));
2760: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
2761: hr_utility.trace('Effective Date = '||to_char(l_effective_date));
2762: hr_utility.trace('Action Type = '||l_action_type);
2763: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));
2764: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));

Line 2761: hr_utility.trace('Effective Date = '||to_char(l_effective_date));

2757: hr_utility.trace('Start Date = '||to_char(l_start_date));
2758: hr_utility.trace('End Date = '||to_char(l_end_date));
2759: hr_utility.trace('BG ID = '||to_char(l_business_group_id));
2760: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
2761: hr_utility.trace('Effective Date = '||to_char(l_effective_date));
2762: hr_utility.trace('Action Type = '||l_action_type);
2763: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));
2764: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
2765: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));

Line 2762: hr_utility.trace('Action Type = '||l_action_type);

2758: hr_utility.trace('End Date = '||to_char(l_end_date));
2759: hr_utility.trace('BG ID = '||to_char(l_business_group_id));
2760: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
2761: hr_utility.trace('Effective Date = '||to_char(l_effective_date));
2762: hr_utility.trace('Action Type = '||l_action_type);
2763: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));
2764: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
2765: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));
2766: hr_utility.trace('GRE Name = '||l_gre_name);

Line 2763: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));

2759: hr_utility.trace('BG ID = '||to_char(l_business_group_id));
2760: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
2761: hr_utility.trace('Effective Date = '||to_char(l_effective_date));
2762: hr_utility.trace('Action Type = '||l_action_type);
2763: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));
2764: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
2765: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));
2766: hr_utility.trace('GRE Name = '||l_gre_name);
2767: hr_utility.trace('ORG ID = '||to_char(l_organization_id));

Line 2764: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));

2760: hr_utility.trace('Payroll Action ID = '||to_char(l_payroll_action_id));
2761: hr_utility.trace('Effective Date = '||to_char(l_effective_date));
2762: hr_utility.trace('Action Type = '||l_action_type);
2763: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));
2764: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
2765: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));
2766: hr_utility.trace('GRE Name = '||l_gre_name);
2767: hr_utility.trace('ORG ID = '||to_char(l_organization_id));
2768: hr_utility.trace('ORG Name = '||l_org_name);

Line 2765: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));

2761: hr_utility.trace('Effective Date = '||to_char(l_effective_date));
2762: hr_utility.trace('Action Type = '||l_action_type);
2763: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));
2764: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
2765: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));
2766: hr_utility.trace('GRE Name = '||l_gre_name);
2767: hr_utility.trace('ORG ID = '||to_char(l_organization_id));
2768: hr_utility.trace('ORG Name = '||l_org_name);
2769: hr_utility.trace('Loc ID = '||to_char(l_location_id));

Line 2766: hr_utility.trace('GRE Name = '||l_gre_name);

2762: hr_utility.trace('Action Type = '||l_action_type);
2763: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));
2764: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
2765: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));
2766: hr_utility.trace('GRE Name = '||l_gre_name);
2767: hr_utility.trace('ORG ID = '||to_char(l_organization_id));
2768: hr_utility.trace('ORG Name = '||l_org_name);
2769: hr_utility.trace('Loc ID = '||to_char(l_location_id));
2770: hr_utility.trace('Loc Code = '||l_location_code);

Line 2767: hr_utility.trace('ORG ID = '||to_char(l_organization_id));

2763: hr_utility.trace('Asg Act ID = '||to_char(l_assignment_action_id));
2764: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
2765: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));
2766: hr_utility.trace('GRE Name = '||l_gre_name);
2767: hr_utility.trace('ORG ID = '||to_char(l_organization_id));
2768: hr_utility.trace('ORG Name = '||l_org_name);
2769: hr_utility.trace('Loc ID = '||to_char(l_location_id));
2770: hr_utility.trace('Loc Code = '||l_location_code);
2771: hr_utility.trace('Chunk Number = '||l_chnk_number);

Line 2768: hr_utility.trace('ORG Name = '||l_org_name);

2764: hr_utility.trace('Asg ID = '||to_char(l_assignment_id));
2765: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));
2766: hr_utility.trace('GRE Name = '||l_gre_name);
2767: hr_utility.trace('ORG ID = '||to_char(l_organization_id));
2768: hr_utility.trace('ORG Name = '||l_org_name);
2769: hr_utility.trace('Loc ID = '||to_char(l_location_id));
2770: hr_utility.trace('Loc Code = '||l_location_code);
2771: hr_utility.trace('Chunk Number = '||l_chnk_number);
2772:

Line 2769: hr_utility.trace('Loc ID = '||to_char(l_location_id));

2765: hr_utility.trace('Tax Unit ID = '||to_char(l_tax_unit_id));
2766: hr_utility.trace('GRE Name = '||l_gre_name);
2767: hr_utility.trace('ORG ID = '||to_char(l_organization_id));
2768: hr_utility.trace('ORG Name = '||l_org_name);
2769: hr_utility.trace('Loc ID = '||to_char(l_location_id));
2770: hr_utility.trace('Loc Code = '||l_location_code);
2771: hr_utility.trace('Chunk Number = '||l_chnk_number);
2772:
2773: -- Bug#4942114 starts

Line 2770: hr_utility.trace('Loc Code = '||l_location_code);

2766: hr_utility.trace('GRE Name = '||l_gre_name);
2767: hr_utility.trace('ORG ID = '||to_char(l_organization_id));
2768: hr_utility.trace('ORG Name = '||l_org_name);
2769: hr_utility.trace('Loc ID = '||to_char(l_location_id));
2770: hr_utility.trace('Loc Code = '||l_location_code);
2771: hr_utility.trace('Chunk Number = '||l_chnk_number);
2772:
2773: -- Bug#4942114 starts
2774: /*

Line 2771: hr_utility.trace('Chunk Number = '||l_chnk_number);

2767: hr_utility.trace('ORG ID = '||to_char(l_organization_id));
2768: hr_utility.trace('ORG Name = '||l_org_name);
2769: hr_utility.trace('Loc ID = '||to_char(l_location_id));
2770: hr_utility.trace('Loc Code = '||l_location_code);
2771: hr_utility.trace('Chunk Number = '||l_chnk_number);
2772:
2773: -- Bug#4942114 starts
2774: /*
2775: hr_utility.trace('p_futa_where = '||p_futa_where);

Line 2775: hr_utility.trace('p_futa_where = '||p_futa_where);

2771: hr_utility.trace('Chunk Number = '||l_chnk_number);
2772:
2773: -- Bug#4942114 starts
2774: /*
2775: hr_utility.trace('p_futa_where = '||p_futa_where);
2776: hr_utility.trace('p_futa_from = '||p_futa_from);
2777: load_deductions(l_assignment_action_id,p_ded_view_name);
2778: load_earnings (l_assignment_action_id,p_earn_view_name);
2779: -- load_alien_earnings (l_assignment_action_id);

Line 2776: hr_utility.trace('p_futa_from = '||p_futa_from);

2772:
2773: -- Bug#4942114 starts
2774: /*
2775: hr_utility.trace('p_futa_where = '||p_futa_where);
2776: hr_utility.trace('p_futa_from = '||p_futa_from);
2777: load_deductions(l_assignment_action_id,p_ded_view_name);
2778: load_earnings (l_assignment_action_id,p_earn_view_name);
2779: -- load_alien_earnings (l_assignment_action_id);
2780: load_ee_tax (l_assignment_action_id,p_fed_view_name,p_state_view_name,p_local_view_name);

Line 2811: hr_utility.trace('End of LOAD DATA');

2807: l_row_count := 0;
2808: commit;
2809: end if;*/
2810: end loop;
2811: hr_utility.trace('End of LOAD DATA');
2812: close sel_aaid;
2813: if (l_index <>0) then
2814: for x in g_totals_table.first..g_totals_table.last LOOP
2815: INSERT INTO pay_us_rpt_totals(tax_unit_id, gre_name,

Line 2847: hr_utility.trace('Error occurred load_data ...' ||SQLERRM);

2843: end if;
2844: -- commit;
2845: exception
2846: when others then
2847: hr_utility.trace('Error occurred load_data ...' ||SQLERRM);
2848: raise;
2849: end load_data;
2850: --
2851: ------------------------------ end load data -------------------------------