eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_WEB_W4 dependencies on HR_UTILITY

Line 247: hr_utility.trace('Entering Into '||gv_package_name||'.Fed_State_Filing_Status_Match');

243: lv_state_fs_meaning hr_lookups.meaning%TYPE;
244: lv_state_04_fs_meaning hr_lookups.meaning%TYPE;
245:
246: BEGIN
247: hr_utility.trace('Entering Into '||gv_package_name||'.Fed_State_Filing_Status_Match');
248: hr_utility.trace('p_state_code := '||p_state_code);
249: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
250: hr_utility.trace('p_fed_org_filing_status_code := '||p_fed_org_filing_status_code);
251: hr_utility.trace('p_fed_org_wa := '||p_fed_org_wa);

Line 248: hr_utility.trace('p_state_code := '||p_state_code);

244: lv_state_04_fs_meaning hr_lookups.meaning%TYPE;
245:
246: BEGIN
247: hr_utility.trace('Entering Into '||gv_package_name||'.Fed_State_Filing_Status_Match');
248: hr_utility.trace('p_state_code := '||p_state_code);
249: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
250: hr_utility.trace('p_fed_org_filing_status_code := '||p_fed_org_filing_status_code);
251: hr_utility.trace('p_fed_org_wa := '||p_fed_org_wa);
252: hr_utility.trace('p_state_org_wa := '||p_state_org_wa);

Line 249: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);

245:
246: BEGIN
247: hr_utility.trace('Entering Into '||gv_package_name||'.Fed_State_Filing_Status_Match');
248: hr_utility.trace('p_state_code := '||p_state_code);
249: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
250: hr_utility.trace('p_fed_org_filing_status_code := '||p_fed_org_filing_status_code);
251: hr_utility.trace('p_fed_org_wa := '||p_fed_org_wa);
252: hr_utility.trace('p_state_org_wa := '||p_state_org_wa);
253: hr_utility.trace('p_fed_exmpt_cnt := '||p_fed_exmpt_cnt);

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

246: BEGIN
247: hr_utility.trace('Entering Into '||gv_package_name||'.Fed_State_Filing_Status_Match');
248: hr_utility.trace('p_state_code := '||p_state_code);
249: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
250: hr_utility.trace('p_fed_org_filing_status_code := '||p_fed_org_filing_status_code);
251: hr_utility.trace('p_fed_org_wa := '||p_fed_org_wa);
252: hr_utility.trace('p_state_org_wa := '||p_state_org_wa);
253: hr_utility.trace('p_fed_exmpt_cnt := '||p_fed_exmpt_cnt);
254: hr_utility.trace('p_state_empt_cnt := '||p_state_empt_cnt);

Line 251: hr_utility.trace('p_fed_org_wa := '||p_fed_org_wa);

247: hr_utility.trace('Entering Into '||gv_package_name||'.Fed_State_Filing_Status_Match');
248: hr_utility.trace('p_state_code := '||p_state_code);
249: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
250: hr_utility.trace('p_fed_org_filing_status_code := '||p_fed_org_filing_status_code);
251: hr_utility.trace('p_fed_org_wa := '||p_fed_org_wa);
252: hr_utility.trace('p_state_org_wa := '||p_state_org_wa);
253: hr_utility.trace('p_fed_exmpt_cnt := '||p_fed_exmpt_cnt);
254: hr_utility.trace('p_state_empt_cnt := '||p_state_empt_cnt);
255: hr_utility.trace('p_new_filing_status_code := '||p_new_filing_status_code);

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

248: hr_utility.trace('p_state_code := '||p_state_code);
249: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
250: hr_utility.trace('p_fed_org_filing_status_code := '||p_fed_org_filing_status_code);
251: hr_utility.trace('p_fed_org_wa := '||p_fed_org_wa);
252: hr_utility.trace('p_state_org_wa := '||p_state_org_wa);
253: hr_utility.trace('p_fed_exmpt_cnt := '||p_fed_exmpt_cnt);
254: hr_utility.trace('p_state_empt_cnt := '||p_state_empt_cnt);
255: hr_utility.trace('p_new_filing_status_code := '||p_new_filing_status_code);
256:

Line 253: hr_utility.trace('p_fed_exmpt_cnt := '||p_fed_exmpt_cnt);

249: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
250: hr_utility.trace('p_fed_org_filing_status_code := '||p_fed_org_filing_status_code);
251: hr_utility.trace('p_fed_org_wa := '||p_fed_org_wa);
252: hr_utility.trace('p_state_org_wa := '||p_state_org_wa);
253: hr_utility.trace('p_fed_exmpt_cnt := '||p_fed_exmpt_cnt);
254: hr_utility.trace('p_state_empt_cnt := '||p_state_empt_cnt);
255: hr_utility.trace('p_new_filing_status_code := '||p_new_filing_status_code);
256:
257: lv_fed_03_meaning := REPLACE(UPPER('Married, but Withhold at Higher Single Rate'), ',');

Line 254: hr_utility.trace('p_state_empt_cnt := '||p_state_empt_cnt);

250: hr_utility.trace('p_fed_org_filing_status_code := '||p_fed_org_filing_status_code);
251: hr_utility.trace('p_fed_org_wa := '||p_fed_org_wa);
252: hr_utility.trace('p_state_org_wa := '||p_state_org_wa);
253: hr_utility.trace('p_fed_exmpt_cnt := '||p_fed_exmpt_cnt);
254: hr_utility.trace('p_state_empt_cnt := '||p_state_empt_cnt);
255: hr_utility.trace('p_new_filing_status_code := '||p_new_filing_status_code);
256:
257: lv_fed_03_meaning := REPLACE(UPPER('Married, but Withhold at Higher Single Rate'), ',');
258:

Line 255: hr_utility.trace('p_new_filing_status_code := '||p_new_filing_status_code);

251: hr_utility.trace('p_fed_org_wa := '||p_fed_org_wa);
252: hr_utility.trace('p_state_org_wa := '||p_state_org_wa);
253: hr_utility.trace('p_fed_exmpt_cnt := '||p_fed_exmpt_cnt);
254: hr_utility.trace('p_state_empt_cnt := '||p_state_empt_cnt);
255: hr_utility.trace('p_new_filing_status_code := '||p_new_filing_status_code);
256:
257: lv_fed_03_meaning := REPLACE(UPPER('Married, but Withhold at Higher Single Rate'), ',');
258:
259: OPEN cur_state_name(p_state_code);

Line 263: hr_utility.trace('lv_state_name := '||lv_state_name);

259: OPEN cur_state_name(p_state_code);
260: FETCH cur_state_name INTO lv_state_name;
261: CLOSE cur_state_name;
262:
263: hr_utility.trace('lv_state_name := '||lv_state_name);
264:
265: OPEN cur_filing_status_meaning(p_state_code
266: ,p_state_org_filing_status_code) ;
267: FETCH cur_filing_status_meaning INTO lv_state_fs_meaning;

Line 270: hr_utility.trace('lv_state_fs_meaning := '||lv_state_fs_meaning);

266: ,p_state_org_filing_status_code) ;
267: FETCH cur_filing_status_meaning INTO lv_state_fs_meaning;
268: CLOSE cur_filing_status_meaning;
269:
270: hr_utility.trace('lv_state_fs_meaning := '||lv_state_fs_meaning);
271:
272: OPEN cur_filing_status_meaning(p_state_code
273: ,'04') ;
274: FETCH cur_filing_status_meaning INTO lv_state_04_fs_meaning;

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

273: ,'04') ;
274: FETCH cur_filing_status_meaning INTO lv_state_04_fs_meaning;
275: CLOSE cur_filing_status_meaning;
276:
277: hr_utility.trace('lv_state_04_fs_meaning := '||lv_state_04_fs_meaning);
278:
279: IF p_state_code IN ('06','08','13','17', '24', '27', '28', '32', '35', '37', '38', '40', '41', '45') THEN
280: -- For States that should Follow Federal
281: IF p_fed_org_filing_status_code <> p_new_filing_status_code THEN

Line 292: hr_utility.trace('p_new_filing_status_code 1 := ' ||p_new_filing_status_code);

288: IF p_new_filing_status_code = '03' THEN
289: /* Modified for bug no 7521930*/
290: IF p_state_code NOT IN ('27','38','41','45') THEN
291: p_new_filing_status_code := '04';
292: hr_utility.trace('p_new_filing_status_code 1 := ' ||p_new_filing_status_code);
293: RETURN TRUE;
294: ELSE
295: hr_utility.trace('p_new_filing_status_code 1 := ' ||p_new_filing_status_code);
296: RETURN TRUE;

Line 295: hr_utility.trace('p_new_filing_status_code 1 := ' ||p_new_filing_status_code);

291: p_new_filing_status_code := '04';
292: hr_utility.trace('p_new_filing_status_code 1 := ' ||p_new_filing_status_code);
293: RETURN TRUE;
294: ELSE
295: hr_utility.trace('p_new_filing_status_code 1 := ' ||p_new_filing_status_code);
296: RETURN TRUE;
297: END IF ;
298:
299: ELSE

Line 300: hr_utility.trace('p_new_filing_status_code 2 := ' ||p_new_filing_status_code);

296: RETURN TRUE;
297: END IF ;
298:
299: ELSE
300: hr_utility.trace('p_new_filing_status_code 2 := ' ||p_new_filing_status_code);
301: RETURN TRUE;
302: END IF;
303:
304: ELSIF (p_fed_org_filing_status_code = '03' AND p_state_org_filing_status_code = '04'

Line 307: hr_utility.trace('p_new_filing_status_code 2 := ' ||p_new_filing_status_code);

303:
304: ELSIF (p_fed_org_filing_status_code = '03' AND p_state_org_filing_status_code = '04'
305: AND p_state_org_wa = p_fed_org_wa
306: AND p_state_empt_cnt = p_fed_exmpt_cnt) THEN
307: hr_utility.trace('p_new_filing_status_code 2 := ' ||p_new_filing_status_code);
308: RETURN TRUE;
309: ELSE
310: IF INSTR(NVL(g_not_matching_state_list, '0'), lv_state_name) = 0 THEN
311:

Line 321: hr_utility.trace('p_new_filing_status_code 3 := ' || p_new_filing_status_code);

317: g_nonmatch_cntr := g_nonmatch_cntr + 1;
318: END IF;
319:
320: p_new_filing_status_code := p_state_org_filing_status_code ;
321: hr_utility.trace('p_new_filing_status_code 3 := ' || p_new_filing_status_code);
322: hr_utility.trace('g_nonmatch_cntr := '|| g_nonmatch_cntr);
323: hr_utility.trace('Not Going to Update State Info From Federal.');
324: RETURN FALSE;
325: END IF;

Line 322: hr_utility.trace('g_nonmatch_cntr := '|| g_nonmatch_cntr);

318: END IF;
319:
320: p_new_filing_status_code := p_state_org_filing_status_code ;
321: hr_utility.trace('p_new_filing_status_code 3 := ' || p_new_filing_status_code);
322: hr_utility.trace('g_nonmatch_cntr := '|| g_nonmatch_cntr);
323: hr_utility.trace('Not Going to Update State Info From Federal.');
324: RETURN FALSE;
325: END IF;
326:

Line 323: hr_utility.trace('Not Going to Update State Info From Federal.');

319:
320: p_new_filing_status_code := p_state_org_filing_status_code ;
321: hr_utility.trace('p_new_filing_status_code 3 := ' || p_new_filing_status_code);
322: hr_utility.trace('g_nonmatch_cntr := '|| g_nonmatch_cntr);
323: hr_utility.trace('Not Going to Update State Info From Federal.');
324: RETURN FALSE;
325: END IF;
326:
327: ELSIF p_fed_org_filing_status_code = p_new_filing_status_code THEN

Line 338: hr_utility.trace('p_new_filing_status_code 4 := ' ||p_new_filing_status_code);

334: AND p_state_org_wa = p_fed_org_wa
335: AND p_state_empt_cnt = p_fed_exmpt_cnt) THEN
336:
337: p_new_filing_status_code := p_state_org_filing_status_code;
338: hr_utility.trace('p_new_filing_status_code 4 := ' ||p_new_filing_status_code);
339: RETURN TRUE;
340: ELSE
341: IF INSTR(NVL(g_not_matching_state_list, '0'), lv_state_name) = 0 THEN
342:

Line 352: hr_utility.trace('p_new_filing_status_code 4 := ' || p_new_filing_status_code);

348: g_nonmatch_cntr := g_nonmatch_cntr + 1;
349: END IF;
350:
351: p_new_filing_status_code := p_state_org_filing_status_code ;
352: hr_utility.trace('p_new_filing_status_code 4 := ' || p_new_filing_status_code);
353: hr_utility.trace('g_nonmatch_cntr := '|| g_nonmatch_cntr);
354: hr_utility.trace('Not Going to Update State Info From Federal.');
355:
356: RETURN FALSE;

Line 353: hr_utility.trace('g_nonmatch_cntr := '|| g_nonmatch_cntr);

349: END IF;
350:
351: p_new_filing_status_code := p_state_org_filing_status_code ;
352: hr_utility.trace('p_new_filing_status_code 4 := ' || p_new_filing_status_code);
353: hr_utility.trace('g_nonmatch_cntr := '|| g_nonmatch_cntr);
354: hr_utility.trace('Not Going to Update State Info From Federal.');
355:
356: RETURN FALSE;
357: END IF;

Line 354: hr_utility.trace('Not Going to Update State Info From Federal.');

350:
351: p_new_filing_status_code := p_state_org_filing_status_code ;
352: hr_utility.trace('p_new_filing_status_code 4 := ' || p_new_filing_status_code);
353: hr_utility.trace('g_nonmatch_cntr := '|| g_nonmatch_cntr);
354: hr_utility.trace('Not Going to Update State Info From Federal.');
355:
356: RETURN FALSE;
357: END IF;
358: END IF; -- p_fed_org_filing_status_code <> p_new_filing_status_code

Line 392: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);

388: END IF;
389: g_nonmatch_cntr := g_nonmatch_cntr + 1;
390: END IF;
391: p_new_filing_status_code := p_state_org_filing_status_code ;
392: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);
393: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
394: hr_utility.trace('Not Going to Update State Info From Federal.');
395: RETURN FALSE;
396: END IF;

Line 393: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);

389: g_nonmatch_cntr := g_nonmatch_cntr + 1;
390: END IF;
391: p_new_filing_status_code := p_state_org_filing_status_code ;
392: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);
393: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
394: hr_utility.trace('Not Going to Update State Info From Federal.');
395: RETURN FALSE;
396: END IF;
397: ELSE

Line 394: hr_utility.trace('Not Going to Update State Info From Federal.');

390: END IF;
391: p_new_filing_status_code := p_state_org_filing_status_code ;
392: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);
393: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
394: hr_utility.trace('Not Going to Update State Info From Federal.');
395: RETURN FALSE;
396: END IF;
397: ELSE
398: IF INSTR(NVL(g_not_matching_state_list, '0'), lv_state_name) = 0 THEN

Line 408: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);

404: END IF;
405: g_nonmatch_cntr := g_nonmatch_cntr + 1;
406: END IF;
407: p_new_filing_status_code := p_state_org_filing_status_code ;
408: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);
409: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
410: hr_utility.trace('Not Going to Update State Info From Federal.');
411: RETURN FALSE;
412:

Line 409: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);

405: g_nonmatch_cntr := g_nonmatch_cntr + 1;
406: END IF;
407: p_new_filing_status_code := p_state_org_filing_status_code ;
408: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);
409: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
410: hr_utility.trace('Not Going to Update State Info From Federal.');
411: RETURN FALSE;
412:
413: END IF;

Line 410: hr_utility.trace('Not Going to Update State Info From Federal.');

406: END IF;
407: p_new_filing_status_code := p_state_org_filing_status_code ;
408: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);
409: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
410: hr_utility.trace('Not Going to Update State Info From Federal.');
411: RETURN FALSE;
412:
413: END IF;
414:

Line 442: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);

438: END IF;
439: g_nonmatch_cntr := g_nonmatch_cntr + 1;
440: END IF;
441: p_new_filing_status_code := p_state_org_filing_status_code ;
442: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);
443: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
444: hr_utility.trace('Not Going to Update State Info From Federal.');
445: RETURN FALSE;
446: END IF;

Line 443: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);

439: g_nonmatch_cntr := g_nonmatch_cntr + 1;
440: END IF;
441: p_new_filing_status_code := p_state_org_filing_status_code ;
442: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);
443: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
444: hr_utility.trace('Not Going to Update State Info From Federal.');
445: RETURN FALSE;
446: END IF;
447: ELSE

Line 444: hr_utility.trace('Not Going to Update State Info From Federal.');

440: END IF;
441: p_new_filing_status_code := p_state_org_filing_status_code ;
442: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);
443: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
444: hr_utility.trace('Not Going to Update State Info From Federal.');
445: RETURN FALSE;
446: END IF;
447: ELSE
448: IF INSTR(NVL(g_not_matching_state_list, '0'), lv_state_name) = 0 THEN

Line 458: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);

454: END IF;
455: g_nonmatch_cntr := g_nonmatch_cntr + 1;
456: END IF;
457: p_new_filing_status_code := p_state_org_filing_status_code ;
458: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);
459: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
460: hr_utility.trace('Not Going to Update State Info From Federal.');
461: RETURN FALSE;
462: END IF;

Line 459: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);

455: g_nonmatch_cntr := g_nonmatch_cntr + 1;
456: END IF;
457: p_new_filing_status_code := p_state_org_filing_status_code ;
458: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);
459: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
460: hr_utility.trace('Not Going to Update State Info From Federal.');
461: RETURN FALSE;
462: END IF;
463:

Line 460: hr_utility.trace('Not Going to Update State Info From Federal.');

456: END IF;
457: p_new_filing_status_code := p_state_org_filing_status_code ;
458: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);
459: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
460: hr_utility.trace('Not Going to Update State Info From Federal.');
461: RETURN FALSE;
462: END IF;
463:
464: ELSIF p_state_code = '22' THEN -- For MA, Single (04), Married (04) --> Other than Head of Household

Line 491: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);

487: END IF;
488: g_nonmatch_cntr := g_nonmatch_cntr + 1;
489: END IF;
490: p_new_filing_status_code := p_state_org_filing_status_code ;
491: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);
492: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
493: hr_utility.trace('Not Going to Update State Info From Federal.');
494: RETURN FALSE;
495: END IF;

Line 492: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);

488: g_nonmatch_cntr := g_nonmatch_cntr + 1;
489: END IF;
490: p_new_filing_status_code := p_state_org_filing_status_code ;
491: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);
492: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
493: hr_utility.trace('Not Going to Update State Info From Federal.');
494: RETURN FALSE;
495: END IF;
496: ELSE

Line 493: hr_utility.trace('Not Going to Update State Info From Federal.');

489: END IF;
490: p_new_filing_status_code := p_state_org_filing_status_code ;
491: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);
492: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
493: hr_utility.trace('Not Going to Update State Info From Federal.');
494: RETURN FALSE;
495: END IF;
496: ELSE
497: IF INSTR(NVL(g_not_matching_state_list, '0'), lv_state_name) = 0 THEN

Line 507: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);

503: END IF;
504: g_nonmatch_cntr := g_nonmatch_cntr + 1;
505: END IF;
506: p_new_filing_status_code := p_state_org_filing_status_code ;
507: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);
508: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
509: RETURN FALSE;
510: END IF;
511:

Line 508: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);

504: g_nonmatch_cntr := g_nonmatch_cntr + 1;
505: END IF;
506: p_new_filing_status_code := p_state_org_filing_status_code ;
507: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);
508: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
509: RETURN FALSE;
510: END IF;
511:
512: END IF; -- p_state_code NOT IN ('19', '22)

Line 540: hr_utility.trace('p_new_filing_status_code 4 := ' ||p_new_filing_status_code);

536: AND p_state_code = '22')
537: THEN
538:
539: p_new_filing_status_code := p_state_org_filing_status_code;
540: hr_utility.trace('p_new_filing_status_code 4 := ' ||p_new_filing_status_code);
541: RETURN TRUE;
542: ELSE
543:
544: IF INSTR(NVL(g_not_matching_state_list, '0'), lv_state_name) = 0 THEN

Line 554: hr_utility.trace('g_nonmatch_cntr 3 := '||g_nonmatch_cntr);

550: END IF;
551: g_nonmatch_cntr := g_nonmatch_cntr + 1;
552: END IF;
553: p_new_filing_status_code := p_state_org_filing_status_code ;
554: hr_utility.trace('g_nonmatch_cntr 3 := '||g_nonmatch_cntr);
555: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
556: RETURN FALSE;
557:
558: END IF;

Line 555: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);

551: g_nonmatch_cntr := g_nonmatch_cntr + 1;
552: END IF;
553: p_new_filing_status_code := p_state_org_filing_status_code ;
554: hr_utility.trace('g_nonmatch_cntr 3 := '||g_nonmatch_cntr);
555: hr_utility.trace('p_state_org_filing_status_code := '||p_state_org_filing_status_code);
556: RETURN FALSE;
557:
558: END IF;
559: END IF; -- p_fed_org_filing_status_code <> p_new_filing_status_code

Line 572: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);

568: g_nonmatch_cntr := g_nonmatch_cntr + 1;
569: END IF;
570: p_new_filing_status_code := p_state_org_filing_status_code ;
571:
572: hr_utility.trace('g_nonmatch_cntr 2 := '||g_nonmatch_cntr);
573: RETURN FALSE;
574: END IF; -- State Following Federal Or NOT
575:
576: END Fed_State_Filing_Status_Match;

Line 666: hr_utility.trace('Entering ' || gv_package_name || '.check_update_status');

662: lv_update_method VARCHAR2(30);
663:
664: BEGIN
665:
666: hr_utility.trace('Entering ' || gv_package_name || '.check_update_status');
667:
668:
669: lv_update_method := fnd_profile.value('HR_OTF_UPDATE_METHOD');
670: hr_utility.trace('OTF Update Method = ' || lv_update_method);

Line 670: hr_utility.trace('OTF Update Method = ' || lv_update_method);

666: hr_utility.trace('Entering ' || gv_package_name || '.check_update_status');
667:
668:
669: lv_update_method := fnd_profile.value('HR_OTF_UPDATE_METHOD');
670: hr_utility.trace('OTF Update Method = ' || lv_update_method);
671:
672: -- check for update method set to NONE
673: hr_utility.trace('Testing PROFILE HR_OTF_UPDATE_METHOD');
674:

Line 673: hr_utility.trace('Testing PROFILE HR_OTF_UPDATE_METHOD');

669: lv_update_method := fnd_profile.value('HR_OTF_UPDATE_METHOD');
670: hr_utility.trace('OTF Update Method = ' || lv_update_method);
671:
672: -- check for update method set to NONE
673: hr_utility.trace('Testing PROFILE HR_OTF_UPDATE_METHOD');
674:
675: if lv_update_method = 'PRIMARY' then
676: l_primary_only := 'Y';
677:

Line 687: hr_utility.trace('Passed PROFILE HR_OTF_UPDATE_METHOD');

683: l_primary_only := 'Y';
684:
685: end if;
686:
687: hr_utility.trace('Passed PROFILE HR_OTF_UPDATE_METHOD');
688:
689: -- check for excessive wa reject date or override amounts
690: -- Note: we don't actually check the date of the reject, just
691: -- it's existence shuts the employee out

Line 693: hr_utility.trace('Testing FED_EXCESSIVE_WA_REJECT_DATE/OVERRIDES');

689: -- check for excessive wa reject date or override amounts
690: -- Note: we don't actually check the date of the reject, just
691: -- it's existence shuts the employee out
692:
693: hr_utility.trace('Testing FED_EXCESSIVE_WA_REJECT_DATE/OVERRIDES');
694: open c_excess_over_fed;
695: fetch c_excess_over_fed into curs_dummy;
696:
697: if c_excess_over_fed%FOUND then

Line 698: hr_utility.trace('Failed on FED_EXCESSIVE_WA_REJECT_DATE/OVERRIDES');

694: open c_excess_over_fed;
695: fetch c_excess_over_fed into curs_dummy;
696:
697: if c_excess_over_fed%FOUND then
698: hr_utility.trace('Failed on FED_EXCESSIVE_WA_REJECT_DATE/OVERRIDES');
699: close c_excess_over_fed;
700: return ('PAY-PAY_US_OTF_REJECT_DATE_OR_OVER');
701: end if;
702:

Line 704: hr_utility.trace('Passed FED_EXCESSIVE_WA_REJECT_DATE/OVERRIDES');

700: return ('PAY-PAY_US_OTF_REJECT_DATE_OR_OVER');
701: end if;
702:
703: close c_excess_over_fed;
704: hr_utility.trace('Passed FED_EXCESSIVE_WA_REJECT_DATE/OVERRIDES');
705:
706: hr_utility.trace('Testing STATE_EXCESSIVE_WA_REJECT_DATE/OVERRIDES');
707: open c_excess_over_state;
708: fetch c_excess_over_state into curs_dummy;

Line 706: hr_utility.trace('Testing STATE_EXCESSIVE_WA_REJECT_DATE/OVERRIDES');

702:
703: close c_excess_over_fed;
704: hr_utility.trace('Passed FED_EXCESSIVE_WA_REJECT_DATE/OVERRIDES');
705:
706: hr_utility.trace('Testing STATE_EXCESSIVE_WA_REJECT_DATE/OVERRIDES');
707: open c_excess_over_state;
708: fetch c_excess_over_state into curs_dummy;
709:
710: if c_excess_over_state%FOUND then

Line 711: hr_utility.trace('Failed on STATE_EXCESSIVE_WA_REJECT_DATE/OVERRIDES');

707: open c_excess_over_state;
708: fetch c_excess_over_state into curs_dummy;
709:
710: if c_excess_over_state%FOUND then
711: hr_utility.trace('Failed on STATE_EXCESSIVE_WA_REJECT_DATE/OVERRIDES');
712: close c_excess_over_state;
713: return ('PAY-PAY_US_OTF_REJECT_DATE_OR_OVER');
714: end if;
715: close c_excess_over_state;

Line 716: hr_utility.trace('Passed STATE_EXCESSIVE_WA_REJECT_DATE/OVERRIDES');

712: close c_excess_over_state;
713: return ('PAY-PAY_US_OTF_REJECT_DATE_OR_OVER');
714: end if;
715: close c_excess_over_state;
716: hr_utility.trace('Passed STATE_EXCESSIVE_WA_REJECT_DATE/OVERRIDES');
717:
718:
719: -- check for any future dated changes in non-retiree asgs for both state and fed
720:

Line 721: hr_utility.trace('Testing FED_FUTURE_DATED_CHANGES');

717:
718:
719: -- check for any future dated changes in non-retiree asgs for both state and fed
720:
721: hr_utility.trace('Testing FED_FUTURE_DATED_CHANGES');
722: open c_future_fed_recs;
723: fetch c_future_fed_recs into curs_dummy;
724: if c_future_fed_recs%FOUND then
725: hr_utility.trace('Failed on FED_FUTURE_DATED_CHANGES');

Line 725: hr_utility.trace('Failed on FED_FUTURE_DATED_CHANGES');

721: hr_utility.trace('Testing FED_FUTURE_DATED_CHANGES');
722: open c_future_fed_recs;
723: fetch c_future_fed_recs into curs_dummy;
724: if c_future_fed_recs%FOUND then
725: hr_utility.trace('Failed on FED_FUTURE_DATED_CHANGES');
726: return ('PAY-PAY_US_OTF_FUTURE_RECORDS');
727: end if;
728:
729: close c_future_fed_recs;

Line 730: hr_utility.trace('Passed FED_FUTURE_DATED_CHANGES');

726: return ('PAY-PAY_US_OTF_FUTURE_RECORDS');
727: end if;
728:
729: close c_future_fed_recs;
730: hr_utility.trace('Passed FED_FUTURE_DATED_CHANGES');
731:
732: hr_utility.trace('Testing STATE_FUTURE_DATED_CHANGES');
733: open c_future_state_recs;
734: fetch c_future_state_recs into curs_dummy;

Line 732: hr_utility.trace('Testing STATE_FUTURE_DATED_CHANGES');

728:
729: close c_future_fed_recs;
730: hr_utility.trace('Passed FED_FUTURE_DATED_CHANGES');
731:
732: hr_utility.trace('Testing STATE_FUTURE_DATED_CHANGES');
733: open c_future_state_recs;
734: fetch c_future_state_recs into curs_dummy;
735: if c_future_state_recs%FOUND then
736: hr_utility.trace('Failed on STATE_FUTURE_DATED_CHANGES');

Line 736: hr_utility.trace('Failed on STATE_FUTURE_DATED_CHANGES');

732: hr_utility.trace('Testing STATE_FUTURE_DATED_CHANGES');
733: open c_future_state_recs;
734: fetch c_future_state_recs into curs_dummy;
735: if c_future_state_recs%FOUND then
736: hr_utility.trace('Failed on STATE_FUTURE_DATED_CHANGES');
737: return ('PAY-PAY_US_OTF_FUTURE_RECORDS');
738: end if;
739:
740: close c_future_state_recs;

Line 741: hr_utility.trace('Passed STATE_FUTURE_DATED_CHANGES');

737: return ('PAY-PAY_US_OTF_FUTURE_RECORDS');
738: end if;
739:
740: close c_future_state_recs;
741: hr_utility.trace('Passed STATE_FUTURE_DATED_CHANGES');
742:
743: -- if we've reached this point, then allow update
744: hr_utility.trace('Leaving ' || gv_package_name || '.check_update_status');
745: return null;

Line 744: hr_utility.trace('Leaving ' || gv_package_name || '.check_update_status');

740: close c_future_state_recs;
741: hr_utility.trace('Passed STATE_FUTURE_DATED_CHANGES');
742:
743: -- if we've reached this point, then allow update
744: hr_utility.trace('Leaving ' || gv_package_name || '.check_update_status');
745: return null;
746:
747: EXCEPTION
748: WHEN OTHERS THEN

Line 883: hr_utility.trace('Entering '|| gv_package_name || '.validate_submission');

879:
880:
881: BEGIN
882:
883: hr_utility.trace('Entering '|| gv_package_name || '.validate_submission');
884: hr_utility.trace('p_filing_status_code = ' || p_filing_status_code);
885: hr_utility.trace('p_exempt_status_code = ' || p_exempt_status_code);
886: hr_utility.trace('p_allowances = ' || p_allowances);
887: hr_utility.trace('p_additional_amount = ' || p_additional_amount);

Line 884: hr_utility.trace('p_filing_status_code = ' || p_filing_status_code);

880:
881: BEGIN
882:
883: hr_utility.trace('Entering '|| gv_package_name || '.validate_submission');
884: hr_utility.trace('p_filing_status_code = ' || p_filing_status_code);
885: hr_utility.trace('p_exempt_status_code = ' || p_exempt_status_code);
886: hr_utility.trace('p_allowances = ' || p_allowances);
887: hr_utility.trace('p_additional_amount = ' || p_additional_amount);
888: hr_utility.trace('p_itemtype = ' || p_itemtype);

Line 885: hr_utility.trace('p_exempt_status_code = ' || p_exempt_status_code);

881: BEGIN
882:
883: hr_utility.trace('Entering '|| gv_package_name || '.validate_submission');
884: hr_utility.trace('p_filing_status_code = ' || p_filing_status_code);
885: hr_utility.trace('p_exempt_status_code = ' || p_exempt_status_code);
886: hr_utility.trace('p_allowances = ' || p_allowances);
887: hr_utility.trace('p_additional_amount = ' || p_additional_amount);
888: hr_utility.trace('p_itemtype = ' || p_itemtype);
889: hr_utility.trace('p_itemkey = ' || p_itemkey);

Line 886: hr_utility.trace('p_allowances = ' || p_allowances);

882:
883: hr_utility.trace('Entering '|| gv_package_name || '.validate_submission');
884: hr_utility.trace('p_filing_status_code = ' || p_filing_status_code);
885: hr_utility.trace('p_exempt_status_code = ' || p_exempt_status_code);
886: hr_utility.trace('p_allowances = ' || p_allowances);
887: hr_utility.trace('p_additional_amount = ' || p_additional_amount);
888: hr_utility.trace('p_itemtype = ' || p_itemtype);
889: hr_utility.trace('p_itemkey = ' || p_itemkey);
890: hr_utility.trace('p_activity_id = ' || p_activity_id);

Line 887: hr_utility.trace('p_additional_amount = ' || p_additional_amount);

883: hr_utility.trace('Entering '|| gv_package_name || '.validate_submission');
884: hr_utility.trace('p_filing_status_code = ' || p_filing_status_code);
885: hr_utility.trace('p_exempt_status_code = ' || p_exempt_status_code);
886: hr_utility.trace('p_allowances = ' || p_allowances);
887: hr_utility.trace('p_additional_amount = ' || p_additional_amount);
888: hr_utility.trace('p_itemtype = ' || p_itemtype);
889: hr_utility.trace('p_itemkey = ' || p_itemkey);
890: hr_utility.trace('p_activity_id = ' || p_activity_id);
891: hr_utility.trace('p_last_name_diff = ' || p_last_name_diff);

Line 888: hr_utility.trace('p_itemtype = ' || p_itemtype);

884: hr_utility.trace('p_filing_status_code = ' || p_filing_status_code);
885: hr_utility.trace('p_exempt_status_code = ' || p_exempt_status_code);
886: hr_utility.trace('p_allowances = ' || p_allowances);
887: hr_utility.trace('p_additional_amount = ' || p_additional_amount);
888: hr_utility.trace('p_itemtype = ' || p_itemtype);
889: hr_utility.trace('p_itemkey = ' || p_itemkey);
890: hr_utility.trace('p_activity_id = ' || p_activity_id);
891: hr_utility.trace('p_last_name_diff = ' || p_last_name_diff);
892:

Line 889: hr_utility.trace('p_itemkey = ' || p_itemkey);

885: hr_utility.trace('p_exempt_status_code = ' || p_exempt_status_code);
886: hr_utility.trace('p_allowances = ' || p_allowances);
887: hr_utility.trace('p_additional_amount = ' || p_additional_amount);
888: hr_utility.trace('p_itemtype = ' || p_itemtype);
889: hr_utility.trace('p_itemkey = ' || p_itemkey);
890: hr_utility.trace('p_activity_id = ' || p_activity_id);
891: hr_utility.trace('p_last_name_diff = ' || p_last_name_diff);
892:
893: -- first this is we clear the global value of g_state_list before we continue

Line 890: hr_utility.trace('p_activity_id = ' || p_activity_id);

886: hr_utility.trace('p_allowances = ' || p_allowances);
887: hr_utility.trace('p_additional_amount = ' || p_additional_amount);
888: hr_utility.trace('p_itemtype = ' || p_itemtype);
889: hr_utility.trace('p_itemkey = ' || p_itemkey);
890: hr_utility.trace('p_activity_id = ' || p_activity_id);
891: hr_utility.trace('p_last_name_diff = ' || p_last_name_diff);
892:
893: -- first this is we clear the global value of g_state_list before we continue
894: -- this will ensure we get the fresh list everytime a user comes back from the

Line 891: hr_utility.trace('p_last_name_diff = ' || p_last_name_diff);

887: hr_utility.trace('p_additional_amount = ' || p_additional_amount);
888: hr_utility.trace('p_itemtype = ' || p_itemtype);
889: hr_utility.trace('p_itemkey = ' || p_itemkey);
890: hr_utility.trace('p_activity_id = ' || p_activity_id);
891: hr_utility.trace('p_last_name_diff = ' || p_last_name_diff);
892:
893: -- first this is we clear the global value of g_state_list before we continue
894: -- this will ensure we get the fresh list everytime a user comes back from the
895: -- review page.

Line 910: hr_utility.trace('Checking filing status');

906:
907: -- validate filing status
908:
909: BEGIN
910: hr_utility.trace('Checking filing status');
911: -- next call the api chk_procedure
912: -- we call it with a null id to insure that it is validated
913: -- withhout having to worry about calling api_updating
914: -- we also provide the sysdate and end-of-time as the validation

Line 926: hr_utility.trace('Rejecting Filing Status');

922: ,p_validation_end_date => to_date('31/12/4712','DD/MM/YYYY')
923: );
924: EXCEPTION
925: WHEN OTHERS then
926: hr_utility.trace('Rejecting Filing Status');
927:
928: if l_error is null then
929: l_error := 'PAY-PAY_FILING_STATUS_ERROR-FilingStatusCode';
930: else

Line 940: hr_utility.trace('Checking total allowances');

936: END;
937:
938: -- validate allowances
939: BEGIN
940: hr_utility.trace('Checking total allowances');
941: -- First we convert it into a NUMBER
942:
943: l_allowances := to_number(nvl(p_allowances,0),'999');
944:

Line 945: hr_utility.trace('l_allowances = ' || to_char(l_allowances));

941: -- First we convert it into a NUMBER
942:
943: l_allowances := to_number(nvl(p_allowances,0),'999');
944:
945: hr_utility.trace('l_allowances = ' || to_char(l_allowances));
946:
947: if l_allowances < 0 then
948: raise VALUE_ERROR;
949: end if;

Line 958: hr_utility.trace('Rejecting Total Allowances - number err');

954: ,p_withholding_allowances => l_allowances
955: );
956: EXCEPTION
957: WHEN VALUE_ERROR then
958: hr_utility.trace('Rejecting Total Allowances - number err');
959:
960: if l_error is null then
961: l_error := 'PAY-PAY_US_OTF_FED_WA_NUMBER-WithholdingAllowances';
962: else

Line 970: hr_utility.trace('Reject Total Allowances - api err');

966: l_num := l_num + 1;
967: lv_has_errors := 'Y';
968:
969: WHEN OTHERS then
970: hr_utility.trace('Reject Total Allowances - api err');
971:
972: if l_error is null then
973: l_error := 'PAY-PAY_PLSQL_ERROR-WithholdingAllowances';
974: else

Line 990: hr_utility.trace('ORG get_org_context lv_notify = '||lv_notify);

986: lv_level := 'ORG';
987:
988: lv_notify := get_org_context(ln_person_id, lv_context,lv_level);
989:
990: hr_utility.trace('ORG get_org_context lv_notify = '||lv_notify);
991: if lv_notify = 'NOTFOUND' then
992: -- Business Group Level Context
993: lv_context := 'US_BG_REP_PREFERENCES';
994: lv_level := 'BG';

Line 996: hr_utility.trace('BG get_org_context lv_notify = '||lv_notify);

992: -- Business Group Level Context
993: lv_context := 'US_BG_REP_PREFERENCES';
994: lv_level := 'BG';
995: lv_notify := get_org_context(ln_person_id, lv_context,lv_level);
996: hr_utility.trace('BG get_org_context lv_notify = '||lv_notify);
997: end if;
998:
999:
1000: -- Also check if the allowance entered by the user is > to the federal allowance limit.

Line 1006: hr_utility.trace('b4 checking lv_notify = '||lv_notify);

1002: open c_fed_allowance_limit;
1003: fetch c_fed_allowance_limit into l_fed_allowance_limit;
1004: close c_fed_allowance_limit;
1005:
1006: hr_utility.trace('b4 checking lv_notify = '||lv_notify);
1007:
1008: --------------- added by vaprakas bug 5601735
1009: l_student_flag :='No';
1010:

Line 1071: hr_utility.trace('Checking Additional Tax');

1067: end if;
1068:
1069: -- validate additional tax
1070: BEGIN
1071: hr_utility.trace('Checking Additional Tax');
1072:
1073: ln_add_tax := nvl(p_additional_amount,0);
1074:
1075: hr_utility.trace('ln_add_tax value is : '||ln_add_tax);

Line 1075: hr_utility.trace('ln_add_tax value is : '||ln_add_tax);

1071: hr_utility.trace('Checking Additional Tax');
1072:
1073: ln_add_tax := nvl(p_additional_amount,0);
1074:
1075: hr_utility.trace('ln_add_tax value is : '||ln_add_tax);
1076: l_additional_tax := ln_add_tax;
1077: hr_utility.trace('l_additional_tax value is : '|| l_additional_tax);
1078:
1079: if l_additional_tax < 0 then

Line 1077: hr_utility.trace('l_additional_tax value is : '|| l_additional_tax);

1073: ln_add_tax := nvl(p_additional_amount,0);
1074:
1075: hr_utility.trace('ln_add_tax value is : '||ln_add_tax);
1076: l_additional_tax := ln_add_tax;
1077: hr_utility.trace('l_additional_tax value is : '|| l_additional_tax);
1078:
1079: if l_additional_tax < 0 then
1080: raise value_error;
1081: end if;

Line 1090: hr_utility.trace('Rejecting add. tax - number err');

1086: ,p_fit_additional_tax => l_additional_tax
1087: );
1088: EXCEPTION
1089: WHEN VALUE_ERROR then
1090: hr_utility.trace('Rejecting add. tax - number err');
1091:
1092: if l_error is null then
1093: l_error := 'PAY-PAY_US_OTF_FED_ADD_TAX_NUMBER-TaxString';
1094: else

Line 1102: hr_utility.trace('Rejecting add. tax - api err');

1098: l_num := l_num + 1;
1099: lv_has_errors := 'Y';
1100:
1101: WHEN OTHERS then
1102: hr_utility.trace('Rejecting add. tax - api err');
1103:
1104: if l_error is null then
1105: l_error := 'PAY-PAY_PLSQL_ERROR-TaxString';
1106: else

Line 1116: hr_utility.trace('Checking exempt status');

1112: END;
1113:
1114: -- validate exempt status code
1115:
1116: hr_utility.trace('Checking exempt status');
1117: -- the only validation we do is replace a 'N' for null
1118: if p_exempt_status_code = 'on' then
1119: l_exempt_status_code := 'Yes';
1120:

Line 1131: hr_utility.trace('Checking agreement flag');

1127: l_exempt_status_code := 'No';
1128: end if;
1129:
1130: -- validate the agreement prompt
1131: hr_utility.trace('Checking agreement flag');
1132:
1133: if p_agreement = 'on' then
1134: l_agreement := 'Y';
1135: else

Line 1136: hr_utility.trace('Rejecting agreement flag');

1132:
1133: if p_agreement = 'on' then
1134: l_agreement := 'Y';
1135: else
1136: hr_utility.trace('Rejecting agreement flag');
1137:
1138: if l_error is null then
1139: l_error := 'PAY-PAY_US_OTF_AGREE_ERROR-Agreementflag';
1140: else

Line 1149: hr_utility.trace('Checking Last Name Different flag');

1145: lv_has_errors := 'Y';
1146: end if;
1147:
1148: -- validate the Last name Different Flag
1149: hr_utility.trace('Checking Last Name Different flag');
1150:
1151: if p_last_name_diff = 'on' then
1152: l_last_name_diff_flag := 'Y';
1153: else

Line 1164: hr_utility.trace('Error string : '|| p_error);

1160:
1161: p_errorcnt := l_num ;
1162: p_error := l_error;
1163:
1164: hr_utility.trace('Error string : '|| p_error);
1165: hr_utility.trace('Number of Errors : '|| to_char(p_errorcnt));
1166: hr_utility.trace('Validation Error - returning to Update');
1167:
1168: raise common_exception;

Line 1165: hr_utility.trace('Number of Errors : '|| to_char(p_errorcnt));

1161: p_errorcnt := l_num ;
1162: p_error := l_error;
1163:
1164: hr_utility.trace('Error string : '|| p_error);
1165: hr_utility.trace('Number of Errors : '|| to_char(p_errorcnt));
1166: hr_utility.trace('Validation Error - returning to Update');
1167:
1168: raise common_exception;
1169:

Line 1166: hr_utility.trace('Validation Error - returning to Update');

1162: p_error := l_error;
1163:
1164: hr_utility.trace('Error string : '|| p_error);
1165: hr_utility.trace('Number of Errors : '|| to_char(p_errorcnt));
1166: hr_utility.trace('Validation Error - returning to Update');
1167:
1168: raise common_exception;
1169:
1170: end if;

Line 1195: hr_utility.trace('The global state list is : '|| g_state_list);

1191: p_source_name => lv_source_name,
1192: --p_update_method => lv_update_method,
1193: p_validate => TRUE );
1194:
1195: hr_utility.trace('The global state list is : '|| g_state_list);
1196: hr_utility.trace('The global state exempt list is : '|| g_state_exempt_list);
1197:
1198: -- Forming Proper Message Text
1199:

Line 1196: hr_utility.trace('The global state exempt list is : '|| g_state_exempt_list);

1192: --p_update_method => lv_update_method,
1193: p_validate => TRUE );
1194:
1195: hr_utility.trace('The global state list is : '|| g_state_list);
1196: hr_utility.trace('The global state exempt list is : '|| g_state_exempt_list);
1197:
1198: -- Forming Proper Message Text
1199:
1200: IF g_nonmatch_cntr > 0 then

Line 1202: hr_utility.trace('The global Not Matching list is : '|| g_not_matching_state_list);

1198: -- Forming Proper Message Text
1199:
1200: IF g_nonmatch_cntr > 0 then
1201:
1202: hr_utility.trace('The global Not Matching list is : '|| g_not_matching_state_list);
1203: hr_utility.trace('Final g_nonmatch_cntr := ' || g_nonmatch_cntr);
1204:
1205: ln_prev_comma_position := 0;
1206: FOR i IN 1..g_nonmatch_cntr

Line 1203: hr_utility.trace('Final g_nonmatch_cntr := ' || g_nonmatch_cntr);

1199:
1200: IF g_nonmatch_cntr > 0 then
1201:
1202: hr_utility.trace('The global Not Matching list is : '|| g_not_matching_state_list);
1203: hr_utility.trace('Final g_nonmatch_cntr := ' || g_nonmatch_cntr);
1204:
1205: ln_prev_comma_position := 0;
1206: FOR i IN 1..g_nonmatch_cntr
1207: LOOP

Line 1209: hr_utility.trace('i := ' || i);

1205: ln_prev_comma_position := 0;
1206: FOR i IN 1..g_nonmatch_cntr
1207: LOOP
1208: ln_comma_position := INSTR(g_not_matching_state_list, ',', 1, i);
1209: hr_utility.trace('i := ' || i);
1210: hr_utility.trace('ln_comma_position := ' || ln_comma_position);
1211:
1212: IF ln_comma_position = 0 THEN
1213: ln_comma_position := LENGTH(g_not_matching_state_list) + 1;

Line 1210: hr_utility.trace('ln_comma_position := ' || ln_comma_position);

1206: FOR i IN 1..g_nonmatch_cntr
1207: LOOP
1208: ln_comma_position := INSTR(g_not_matching_state_list, ',', 1, i);
1209: hr_utility.trace('i := ' || i);
1210: hr_utility.trace('ln_comma_position := ' || ln_comma_position);
1211:
1212: IF ln_comma_position = 0 THEN
1213: ln_comma_position := LENGTH(g_not_matching_state_list) + 1;
1214: END IF;

Line 1215: hr_utility.trace('ln_comma_position := ' || ln_comma_position);

1211:
1212: IF ln_comma_position = 0 THEN
1213: ln_comma_position := LENGTH(g_not_matching_state_list) + 1;
1214: END IF;
1215: hr_utility.trace('ln_comma_position := ' || ln_comma_position);
1216: hr_utility.trace('ln_prev_comma_position := ' || ln_prev_comma_position);
1217:
1218: lv_notmatch_state := LTRIM(RTRIM(SUBSTR(g_not_matching_state_list, (ln_prev_comma_position + 1), (ln_comma_position - ln_prev_comma_position - 1))));
1219: hr_utility.trace('lv_notmatch_state := ' || lv_notmatch_state);

Line 1216: hr_utility.trace('ln_prev_comma_position := ' || ln_prev_comma_position);

1212: IF ln_comma_position = 0 THEN
1213: ln_comma_position := LENGTH(g_not_matching_state_list) + 1;
1214: END IF;
1215: hr_utility.trace('ln_comma_position := ' || ln_comma_position);
1216: hr_utility.trace('ln_prev_comma_position := ' || ln_prev_comma_position);
1217:
1218: lv_notmatch_state := LTRIM(RTRIM(SUBSTR(g_not_matching_state_list, (ln_prev_comma_position + 1), (ln_comma_position - ln_prev_comma_position - 1))));
1219: hr_utility.trace('lv_notmatch_state := ' || lv_notmatch_state);
1220:

Line 1219: hr_utility.trace('lv_notmatch_state := ' || lv_notmatch_state);

1215: hr_utility.trace('ln_comma_position := ' || ln_comma_position);
1216: hr_utility.trace('ln_prev_comma_position := ' || ln_prev_comma_position);
1217:
1218: lv_notmatch_state := LTRIM(RTRIM(SUBSTR(g_not_matching_state_list, (ln_prev_comma_position + 1), (ln_comma_position - ln_prev_comma_position - 1))));
1219: hr_utility.trace('lv_notmatch_state := ' || lv_notmatch_state);
1220:
1221: IF INSTR(g_state_list, lv_notmatch_state) <> 0 THEN
1222: IF INSTR(g_state_list, lv_notmatch_state || ',') <> 0 THEN
1223: g_state_list := REPLACE(g_state_list, lv_notmatch_state || ',');

Line 1235: hr_utility.trace('Success ' || i);

1231: ELSE
1232: g_state_exempt_list := REPLACE(g_state_exempt_list, lv_notmatch_state );
1233: END IF;
1234: END IF;
1235: hr_utility.trace('Success ' || i);
1236: ln_prev_comma_position := ln_comma_position;
1237: END LOOP;
1238: g_not_matching_state_list := hr_util_misc_web.return_msg_text('PAY_US_OTF_NOTMATCHING_STATES','PAY')
1239: || g_not_matching_state_list;

Line 1266: hr_utility.trace('The global state list is : '|| g_state_list);

1262: else
1263: p_exempt_state_list := g_state_exempt_list;
1264: end if;
1265:
1266: hr_utility.trace('The global state list is : '|| g_state_list);
1267: hr_utility.trace('The global state exempt list is : '|| g_state_exempt_list);
1268:
1269:
1270: /* If we have come so far that means we have no errors. So insert data

Line 1267: hr_utility.trace('The global state exempt list is : '|| g_state_exempt_list);

1263: p_exempt_state_list := g_state_exempt_list;
1264: end if;
1265:
1266: hr_utility.trace('The global state list is : '|| g_state_list);
1267: hr_utility.trace('The global state exempt list is : '|| g_state_exempt_list);
1268:
1269:
1270: /* If we have come so far that means we have no errors. So insert data
1271: into hr_api_transactions, hr_api_transaction_steps and hr_api_transaction_values.

Line 1281: hr_utility.trace('l_transaction_id is null INSERTING');

1277: l_transaction_id := hr_transaction_ss.get_transaction_id(p_itemtype, p_itemkey);
1278:
1279: if l_transaction_id is null then /* transaction does not exists */
1280:
1281: hr_utility.trace('l_transaction_id is null INSERTING');
1282:
1283: /*
1284: hr_transaction_api.create_transaction( p_creator_person_id => ln_person_id ,
1285: p_transaction_privilege => 'PRIVATE',

Line 1346: hr_utility.trace('l_transaction_id : '|| l_transaction_id);

1342: avalue => l_transaction_id);
1343:
1344: else /* transaction exists */
1345:
1346: hr_utility.trace('l_transaction_id : '|| l_transaction_id);
1347: select transaction_step_id into l_transaction_step_id
1348: from HR_API_TRANSACTION_STEPS
1349: where transaction_id = l_transaction_id;
1350:

Line 1358: hr_utility.trace('After END IF');

1354:
1355: -- Filing Status Meaning
1356: -- get the filing status meaning to store in the transaction_value table
1357:
1358: hr_utility.trace('After END IF');
1359:
1360: select fcl.meaning Meaning into transaction_value_fs
1361: from fnd_common_lookups fcl
1362: where fcl.lookup_type = 'US_FIT_FILING_STATUS'

Line 1389: hr_utility.trace('transaction_step_id = ' || l_transaction_step_id);

1385: select fcl.meaning Meaning into transaction_value_fs
1386: from fnd_common_lookups fcl
1387: where fcl.lookup_type = 'US_FIT_FILING_STATUS'
1388: and fcl.lookup_code = p_original_fs ;
1389: hr_utility.trace('transaction_step_id = ' || l_transaction_step_id);
1390: hr_transaction_api.set_varchar2_value (
1391: p_transaction_step_id => l_transaction_step_id
1392: ,p_person_id => ln_person_id
1393: ,p_name => 'P_ORG_FILING_STATUS'

Line 1466: hr_utility.trace('B4 Commit');

1462: ,p_person_id => ln_person_id
1463: ,p_name => 'P_LAST_NAME_DIFF'
1464: ,p_value => l_last_name_diff_flag ) ;
1465:
1466: hr_utility.trace('B4 Commit');
1467: commit;
1468:
1469: hr_utility.trace('Leaving ' || gv_package_name || '.validate_submission');
1470:

Line 1469: hr_utility.trace('Leaving ' || gv_package_name || '.validate_submission');

1465:
1466: hr_utility.trace('B4 Commit');
1467: commit;
1468:
1469: hr_utility.trace('Leaving ' || gv_package_name || '.validate_submission');
1470:
1471: EXCEPTION
1472:
1473: When common_exception then

Line 1474: hr_utility.trace('In exception common_exception');

1470:
1471: EXCEPTION
1472:
1473: When common_exception then
1474: hr_utility.trace('In exception common_exception');
1475: return;
1476:
1477: When no_data_found then
1478: hr_utility.trace('In exception no_data_found');

Line 1478: hr_utility.trace('In exception no_data_found');

1474: hr_utility.trace('In exception common_exception');
1475: return;
1476:
1477: When no_data_found then
1478: hr_utility.trace('In exception no_data_found');
1479: return;
1480:
1481:
1482: WHEN OTHERS THEN

Line 1483: hr_utility.trace(gv_package_name || '.validate_submission FATAL ERROR');

1479: return;
1480:
1481:
1482: WHEN OTHERS THEN
1483: hr_utility.trace(gv_package_name || '.validate_submission FATAL ERROR');
1484: hr_utility.trace(SQLERRM || ' ' || SQLCODE);
1485:
1486: l_error := l_error ||';'||'PAY-'||gv_package_name || '.validate_submission'||
1487: SQLERRM || ' ' ||SQLCODE||'-Dummy';

Line 1484: hr_utility.trace(SQLERRM || ' ' || SQLCODE);

1480:
1481:
1482: WHEN OTHERS THEN
1483: hr_utility.trace(gv_package_name || '.validate_submission FATAL ERROR');
1484: hr_utility.trace(SQLERRM || ' ' || SQLCODE);
1485:
1486: l_error := l_error ||';'||'PAY-'||gv_package_name || '.validate_submission'||
1487: SQLERRM || ' ' ||SQLCODE||'-Dummy';
1488:

Line 1529: hr_utility.trace('Transaction Id is : '|| p_trans_id);

1525:
1526: common_exception EXCEPTION;
1527: BEGIN
1528:
1529: hr_utility.trace('Transaction Id is : '|| p_trans_id);
1530: hr_utility.trace('Transaction Step Id is : '|| p_step_id);
1531:
1532: if (p_trans_id is null and p_step_id is null) then
1533: p_out_values := 'Error: Please enter Transaction Id or Transaction Step Id';

Line 1530: hr_utility.trace('Transaction Step Id is : '|| p_step_id);

1526: common_exception EXCEPTION;
1527: BEGIN
1528:
1529: hr_utility.trace('Transaction Id is : '|| p_trans_id);
1530: hr_utility.trace('Transaction Step Id is : '|| p_step_id);
1531:
1532: if (p_trans_id is null and p_step_id is null) then
1533: p_out_values := 'Error: Please enter Transaction Id or Transaction Step Id';
1534: raise common_exception;

Line 1568: hr_utility.trace('The out value is : '|| p_out_values);

1564:
1565: end loop;
1566: close c_trans_values;
1567:
1568: hr_utility.trace('The out value is : '|| p_out_values);
1569:
1570: exception when common_exception then
1571:
1572: hr_utility.trace('Error: Please enter Transaction Id or Transaction Step Id');

Line 1572: hr_utility.trace('Error: Please enter Transaction Id or Transaction Step Id');

1568: hr_utility.trace('The out value is : '|| p_out_values);
1569:
1570: exception when common_exception then
1571:
1572: hr_utility.trace('Error: Please enter Transaction Id or Transaction Step Id');
1573: return;
1574:
1575:
1576: END;

Line 1912: hr_utility.trace('Entering ' || gv_package_name || '.update_tax_records');

1908: l_state_tax_rec c_state_tax_rows%rowtype;
1909:
1910: BEGIN
1911:
1912: hr_utility.trace('Entering ' || gv_package_name || '.update_tax_records');
1913:
1914: -- set a savepoint before we do anything
1915: SAVEPOINT update_tax_records;
1916:

Line 1948: hr_utility.trace('Update Method = ' || lv_update_method);

1944:
1945: lv_fed_exemptions_count := 0;
1946: lv_state_exemptions_count := 0;
1947:
1948: hr_utility.trace('Update Method = ' || lv_update_method);
1949:
1950: lv_filing_status_code := p_filing_status_code;
1951:
1952: -- lock records

Line 1953: hr_utility.trace(gv_package_name||'.update_tax_records - Locking Employee Tax Records');

1949:
1950: lv_filing_status_code := p_filing_status_code;
1951:
1952: -- lock records
1953: hr_utility.trace(gv_package_name||'.update_tax_records - Locking Employee Tax Records');
1954: open c_fed_tax_rows;
1955:
1956: loop /* Federal cursor loop */
1957:

Line 1980: hr_utility.trace(gv_package_name ||'.update_tax_records - BEFORE FED UPDATE');

1976: + l_fed_tax_rec.futa_tax_exempt_count
1977: + l_fed_tax_rec.medicare_tax_exempt_count
1978: + l_fed_tax_rec.ss_tax_exempt_count ;
1979:
1980: hr_utility.trace(gv_package_name ||'.update_tax_records - BEFORE FED UPDATE');
1981:
1982: -- We insert using datetrack mode of UPDATE
1983: -- future dated records will cause an error
1984: -- if the old start date = sysdate, we perform a correction instead

Line 1993: hr_utility.trace('Updating Fed Record ID = ' || to_char(ln_fed_tax_rule_id));

1989: else
1990: lv_datetrack_mode := 'UPDATE';
1991: end if;
1992:
1993: hr_utility.trace('Updating Fed Record ID = ' || to_char(ln_fed_tax_rule_id));
1994:
1995: /*
1996: pay_federal_tax_rule_api.update_fed_tax_rule
1997: (p_emp_fed_tax_rule_id => ln_fed_tax_rule_id

Line 2111: hr_utility.trace('Primary Flag is = ' || l_fed_tax_rec.primary_flag);

2107: for the primary flag. */
2108:
2109: if l_fed_tax_rec.primary_flag = 'Y' then
2110:
2111: hr_utility.trace('Primary Flag is = ' || l_fed_tax_rec.primary_flag);
2112: pay_aud_ins.ins(
2113: p_effective_date => l_fed_tax_rec.cur_sysdate
2114: ,p_transaction_type => lv_trans_type --'ONLINE_TAX_FORMS'
2115: ,p_transaction_date => l_fed_tax_rec.cur_sysdate

Line 2140: hr_utility.trace('Executed pay_aud_ins.ins ' );

2136: ,p_stat_trans_audit_id => ln_parent_audit_id
2137: ,p_object_version_number => l_fed_tax_rec.object_version_number
2138: );
2139:
2140: hr_utility.trace('Executed pay_aud_ins.ins ' );
2141: else /* l_primary_flag */
2142:
2143: /* reversing ln_dummy and ln_parent_audit_id */
2144:

Line 2145: hr_utility.trace('Primary Flag is = ' || l_fed_tax_rec.primary_flag);

2141: else /* l_primary_flag */
2142:
2143: /* reversing ln_dummy and ln_parent_audit_id */
2144:
2145: hr_utility.trace('Primary Flag is = ' || l_fed_tax_rec.primary_flag);
2146: pay_aud_ins.ins(
2147: p_effective_date => l_fed_tax_rec.cur_sysdate
2148: ,p_transaction_type => lv_trans_type --'ONLINE_TAX_FORMS'
2149: ,p_transaction_date => l_fed_tax_rec.cur_sysdate

Line 2180: hr_utility.trace('ld_start_date is : '|| ld_start_date);

2176: /* Commenting this for bug 2038691
2177: -- as a sanity check we make sure that the dates are right
2178: if (ld_start_date <> trunc(sysdate)) or
2179: (ld_end_date <> to_date('31/12/4712','DD/MM/YYYY')) then
2180: hr_utility.trace('ld_start_date is : '|| ld_start_date);
2181: hr_utility.trace('trunc(sysdate) is : '|| trunc(sysdate));
2182: hr_utility.trace('ld_end_date is : '|| ld_end_date);
2183: hr_utility.trace('Date sanity checking');
2184: raise e_date_error;

Line 2181: hr_utility.trace('trunc(sysdate) is : '|| trunc(sysdate));

2177: -- as a sanity check we make sure that the dates are right
2178: if (ld_start_date <> trunc(sysdate)) or
2179: (ld_end_date <> to_date('31/12/4712','DD/MM/YYYY')) then
2180: hr_utility.trace('ld_start_date is : '|| ld_start_date);
2181: hr_utility.trace('trunc(sysdate) is : '|| trunc(sysdate));
2182: hr_utility.trace('ld_end_date is : '|| ld_end_date);
2183: hr_utility.trace('Date sanity checking');
2184: raise e_date_error;
2185: end if;

Line 2182: hr_utility.trace('ld_end_date is : '|| ld_end_date);

2178: if (ld_start_date <> trunc(sysdate)) or
2179: (ld_end_date <> to_date('31/12/4712','DD/MM/YYYY')) then
2180: hr_utility.trace('ld_start_date is : '|| ld_start_date);
2181: hr_utility.trace('trunc(sysdate) is : '|| trunc(sysdate));
2182: hr_utility.trace('ld_end_date is : '|| ld_end_date);
2183: hr_utility.trace('Date sanity checking');
2184: raise e_date_error;
2185: end if;
2186: Commenting this for bug 2038691*/

Line 2183: hr_utility.trace('Date sanity checking');

2179: (ld_end_date <> to_date('31/12/4712','DD/MM/YYYY')) then
2180: hr_utility.trace('ld_start_date is : '|| ld_start_date);
2181: hr_utility.trace('trunc(sysdate) is : '|| trunc(sysdate));
2182: hr_utility.trace('ld_end_date is : '|| ld_end_date);
2183: hr_utility.trace('Date sanity checking');
2184: raise e_date_error;
2185: end if;
2186: Commenting this for bug 2038691*/
2187:

Line 2196: hr_utility.trace('p_filing_status_code = ' || p_filing_status_code);

2192: -- We will update state record only if the one of the following has changed.
2193:
2194: /* to update state tax Yes or No */
2195:
2196: hr_utility.trace('p_filing_status_code = ' || p_filing_status_code);
2197: hr_utility.trace('p_org_filing_status_code = ' || p_org_filing_status_code);
2198:
2199: hr_utility.trace('p_allowances = ' || p_allowances);
2200: hr_utility.trace('p_org_allowances = ' || p_org_allowances);

Line 2197: hr_utility.trace('p_org_filing_status_code = ' || p_org_filing_status_code);

2193:
2194: /* to update state tax Yes or No */
2195:
2196: hr_utility.trace('p_filing_status_code = ' || p_filing_status_code);
2197: hr_utility.trace('p_org_filing_status_code = ' || p_org_filing_status_code);
2198:
2199: hr_utility.trace('p_allowances = ' || p_allowances);
2200: hr_utility.trace('p_org_allowances = ' || p_org_allowances);
2201:

Line 2199: hr_utility.trace('p_allowances = ' || p_allowances);

2195:
2196: hr_utility.trace('p_filing_status_code = ' || p_filing_status_code);
2197: hr_utility.trace('p_org_filing_status_code = ' || p_org_filing_status_code);
2198:
2199: hr_utility.trace('p_allowances = ' || p_allowances);
2200: hr_utility.trace('p_org_allowances = ' || p_org_allowances);
2201:
2202: hr_utility.trace('p_exempt_status_code = ' || p_exempt_status_code);
2203: hr_utility.trace('p_org_exempt_status_code = ' || p_org_exempt_status_code);

Line 2200: hr_utility.trace('p_org_allowances = ' || p_org_allowances);

2196: hr_utility.trace('p_filing_status_code = ' || p_filing_status_code);
2197: hr_utility.trace('p_org_filing_status_code = ' || p_org_filing_status_code);
2198:
2199: hr_utility.trace('p_allowances = ' || p_allowances);
2200: hr_utility.trace('p_org_allowances = ' || p_org_allowances);
2201:
2202: hr_utility.trace('p_exempt_status_code = ' || p_exempt_status_code);
2203: hr_utility.trace('p_org_exempt_status_code = ' || p_org_exempt_status_code);
2204:

Line 2202: hr_utility.trace('p_exempt_status_code = ' || p_exempt_status_code);

2198:
2199: hr_utility.trace('p_allowances = ' || p_allowances);
2200: hr_utility.trace('p_org_allowances = ' || p_org_allowances);
2201:
2202: hr_utility.trace('p_exempt_status_code = ' || p_exempt_status_code);
2203: hr_utility.trace('p_org_exempt_status_code = ' || p_org_exempt_status_code);
2204:
2205: if ((p_filing_status_code <> p_org_filing_status_code ) OR
2206: (p_allowances <> p_org_allowances) OR

Line 2203: hr_utility.trace('p_org_exempt_status_code = ' || p_org_exempt_status_code);

2199: hr_utility.trace('p_allowances = ' || p_allowances);
2200: hr_utility.trace('p_org_allowances = ' || p_org_allowances);
2201:
2202: hr_utility.trace('p_exempt_status_code = ' || p_exempt_status_code);
2203: hr_utility.trace('p_org_exempt_status_code = ' || p_org_exempt_status_code);
2204:
2205: if ((p_filing_status_code <> p_org_filing_status_code ) OR
2206: (p_allowances <> p_org_allowances) OR
2207: (p_exempt_status_code <> p_org_exempt_status_code) ) then

Line 2209: hr_utility.trace('* Updating State Record * ' );

2205: if ((p_filing_status_code <> p_org_filing_status_code ) OR
2206: (p_allowances <> p_org_allowances) OR
2207: (p_exempt_status_code <> p_org_exempt_status_code) ) then
2208:
2209: hr_utility.trace('*** Updating State Record *** ' );
2210:
2211: if p_filing_status_code <> p_org_filing_status_code then
2212:
2213: lv_filing_status_changed := TRUE;

Line 2251: hr_utility.trace('Fetched state : '|| l_state_tax_rec.state_code );

2247:
2248:
2249: exit when c_state_tax_rows%NOTFOUND;
2250:
2251: hr_utility.trace('Fetched state : '|| l_state_tax_rec.state_code );
2252: hr_utility.trace(' FS : '|| l_state_tax_rec.filing_status_code ||
2253: ' WA : '|| to_char(l_state_tax_rec.withholding_allowances) );
2254:
2255: -- count the no. of State Tax Exemptions

Line 2252: hr_utility.trace(' FS : '|| l_state_tax_rec.filing_status_code ||

2248:
2249: exit when c_state_tax_rows%NOTFOUND;
2250:
2251: hr_utility.trace('Fetched state : '|| l_state_tax_rec.state_code );
2252: hr_utility.trace(' FS : '|| l_state_tax_rec.filing_status_code ||
2253: ' WA : '|| to_char(l_state_tax_rec.withholding_allowances) );
2254:
2255: -- count the no. of State Tax Exemptions
2256: lv_state_exemptions_count := l_state_tax_rec.sit_exempt_count

Line 2261: hr_utility.trace(gv_package_name||'.update_tax_records-BEFORE STATE UPDATE');

2257: + l_state_tax_rec.sui_exempt_count
2258: + l_state_tax_rec.sdi_exempt_count
2259: + l_state_tax_rec.wc_exempt_count;
2260:
2261: hr_utility.trace(gv_package_name||'.update_tax_records-BEFORE STATE UPDATE');
2262:
2263: if l_state_tax_rec.effective_start_date = l_state_tax_rec.cur_sysdate then
2264: lv_datetrack_mode := 'CORRECTION';
2265: else

Line 2278: hr_utility.trace('cu_state_fs_code = ' || l_state_tax_rec.filing_status_code);

2274: the state records also. Bug 1668926.
2275:
2276: Check fed = state FS and WA */
2277:
2278: hr_utility.trace('cu_state_fs_code = ' || l_state_tax_rec.filing_status_code);
2279: hr_utility.trace('cu_fed_fs_code = ' || l_fed_tax_rec.filing_status_code);
2280:
2281: hr_utility.trace('cu_state_wa = ' || l_state_tax_rec.withholding_allowances);
2282: hr_utility.trace('cu_fed_wa = ' || l_fed_tax_rec.withholding_allowances);

Line 2279: hr_utility.trace('cu_fed_fs_code = ' || l_fed_tax_rec.filing_status_code);

2275:
2276: Check fed = state FS and WA */
2277:
2278: hr_utility.trace('cu_state_fs_code = ' || l_state_tax_rec.filing_status_code);
2279: hr_utility.trace('cu_fed_fs_code = ' || l_fed_tax_rec.filing_status_code);
2280:
2281: hr_utility.trace('cu_state_wa = ' || l_state_tax_rec.withholding_allowances);
2282: hr_utility.trace('cu_fed_wa = ' || l_fed_tax_rec.withholding_allowances);
2283:

Line 2281: hr_utility.trace('cu_state_wa = ' || l_state_tax_rec.withholding_allowances);

2277:
2278: hr_utility.trace('cu_state_fs_code = ' || l_state_tax_rec.filing_status_code);
2279: hr_utility.trace('cu_fed_fs_code = ' || l_fed_tax_rec.filing_status_code);
2280:
2281: hr_utility.trace('cu_state_wa = ' || l_state_tax_rec.withholding_allowances);
2282: hr_utility.trace('cu_fed_wa = ' || l_fed_tax_rec.withholding_allowances);
2283:
2284: hr_utility.trace('lv_fed_exemptions_count = ' || lv_fed_exemptions_count);
2285: hr_utility.trace('lv_state_exemptions_count = ' || lv_state_exemptions_count);

Line 2282: hr_utility.trace('cu_fed_wa = ' || l_fed_tax_rec.withholding_allowances);

2278: hr_utility.trace('cu_state_fs_code = ' || l_state_tax_rec.filing_status_code);
2279: hr_utility.trace('cu_fed_fs_code = ' || l_fed_tax_rec.filing_status_code);
2280:
2281: hr_utility.trace('cu_state_wa = ' || l_state_tax_rec.withholding_allowances);
2282: hr_utility.trace('cu_fed_wa = ' || l_fed_tax_rec.withholding_allowances);
2283:
2284: hr_utility.trace('lv_fed_exemptions_count = ' || lv_fed_exemptions_count);
2285: hr_utility.trace('lv_state_exemptions_count = ' || lv_state_exemptions_count);
2286:

Line 2284: hr_utility.trace('lv_fed_exemptions_count = ' || lv_fed_exemptions_count);

2280:
2281: hr_utility.trace('cu_state_wa = ' || l_state_tax_rec.withholding_allowances);
2282: hr_utility.trace('cu_fed_wa = ' || l_fed_tax_rec.withholding_allowances);
2283:
2284: hr_utility.trace('lv_fed_exemptions_count = ' || lv_fed_exemptions_count);
2285: hr_utility.trace('lv_state_exemptions_count = ' || lv_state_exemptions_count);
2286:
2287: lv_filing_status_code_o := p_filing_status_code;
2288:

Line 2285: hr_utility.trace('lv_state_exemptions_count = ' || lv_state_exemptions_count);

2281: hr_utility.trace('cu_state_wa = ' || l_state_tax_rec.withholding_allowances);
2282: hr_utility.trace('cu_fed_wa = ' || l_fed_tax_rec.withholding_allowances);
2283:
2284: hr_utility.trace('lv_fed_exemptions_count = ' || lv_fed_exemptions_count);
2285: hr_utility.trace('lv_state_exemptions_count = ' || lv_state_exemptions_count);
2286:
2287: lv_filing_status_code_o := p_filing_status_code;
2288:
2289: /*if (l_state_tax_rec.filing_status_code = l_fed_tax_rec.filing_status_code and

Line 2308: hr_utility.trace('B4 g_state_list = ' || g_state_list);

2304: ,lv_state_exemptions_count
2305: ,lv_filing_status_code_o) THEN
2306:
2307: if p_validate then
2308: hr_utility.trace('B4 g_state_list = ' || g_state_list);
2309: g_state_list := get_state_list(ln_person_id,l_primary_only);
2310: hr_utility.trace('g_state_list = ' || g_state_list);
2311: hr_utility.trace('g_state_exempt_list = ' || g_state_exempt_list);
2312:

Line 2310: hr_utility.trace('g_state_list = ' || g_state_list);

2306:
2307: if p_validate then
2308: hr_utility.trace('B4 g_state_list = ' || g_state_list);
2309: g_state_list := get_state_list(ln_person_id,l_primary_only);
2310: hr_utility.trace('g_state_list = ' || g_state_list);
2311: hr_utility.trace('g_state_exempt_list = ' || g_state_exempt_list);
2312:
2313: end if;
2314:

Line 2311: hr_utility.trace('g_state_exempt_list = ' || g_state_exempt_list);

2307: if p_validate then
2308: hr_utility.trace('B4 g_state_list = ' || g_state_list);
2309: g_state_list := get_state_list(ln_person_id,l_primary_only);
2310: hr_utility.trace('g_state_list = ' || g_state_list);
2311: hr_utility.trace('g_state_exempt_list = ' || g_state_exempt_list);
2312:
2313: end if;
2314:
2315: /* allow update of state tax record(s).

Line 2357: hr_utility.trace('Updating State Record ID = ' || to_char(l_state_tax_rec.emp_state_tax_rule_id));

2353: lv_state_fs_changed := TRUE;
2354:
2355: end if;
2356:
2357: hr_utility.trace('Updating State Record ID = ' || to_char(l_state_tax_rec.emp_state_tax_rule_id));
2358:
2359: /* Check the state exempt code here -- If the code Y then default the exempt code from federal
2360: else do not replace the exempt code */
2361:

Line 2376: hr_utility.trace('*** l_state_exempt = ' || l_state_exempt);

2372: -- we cannot default
2373: l_state_exempt := NVL(l_state_tax_rec.sit_exempt, 'N');
2374: end if;
2375:
2376: hr_utility.trace('*** l_state_exempt = ' || l_state_exempt);
2377: hr_utility.trace('*** p_exempt_status_code = ' || p_exempt_status_code);
2378: hr_utility.trace('*** cu_sit_exempt = ' || l_state_tax_rec.sit_exempt);
2379:
2380:

Line 2377: hr_utility.trace('*** p_exempt_status_code = ' || p_exempt_status_code);

2373: l_state_exempt := NVL(l_state_tax_rec.sit_exempt, 'N');
2374: end if;
2375:
2376: hr_utility.trace('*** l_state_exempt = ' || l_state_exempt);
2377: hr_utility.trace('*** p_exempt_status_code = ' || p_exempt_status_code);
2378: hr_utility.trace('*** cu_sit_exempt = ' || l_state_tax_rec.sit_exempt);
2379:
2380:
2381: --If lv_filing_status_changed or lv_allowance_changed then

Line 2378: hr_utility.trace('*** cu_sit_exempt = ' || l_state_tax_rec.sit_exempt);

2374: end if;
2375:
2376: hr_utility.trace('*** l_state_exempt = ' || l_state_exempt);
2377: hr_utility.trace('*** p_exempt_status_code = ' || p_exempt_status_code);
2378: hr_utility.trace('*** cu_sit_exempt = ' || l_state_tax_rec.sit_exempt);
2379:
2380:
2381: --If lv_filing_status_changed or lv_allowance_changed then
2382: /* If lv_state_fs_changed or lv_allowance_changed then

Line 2413: hr_utility.trace('Update state info : '|| l_state_tax_rec.emp_state_tax_rule_id);

2409: /* Modified for bug no 7005814 */
2410:
2411: if lv_insert_flag then /* mehul */
2412:
2413: hr_utility.trace('Update state info : '|| l_state_tax_rec.emp_state_tax_rule_id);
2414: /*
2415: pay_state_tax_rule_api.update_state_tax_rule
2416: (p_emp_state_tax_rule_id => l_state_tax_rec.emp_state_tax_rule_id
2417: ,p_withholding_allowances => p_allowances

Line 2527: hr_utility.trace('State Context is : ' || lv_context);

2523: -- store it, otherwise there is nothing stored except the child
2524: -- record info
2525:
2526: lv_context := 'W4 State';
2527: hr_utility.trace('State Context is : ' || lv_context);
2528:
2529: -- insert a row in the transaction table
2530: pay_aud_ins.ins(
2531: p_effective_date => l_state_tax_rec.cur_sysdate

Line 2558: hr_utility.trace('State Context is : ' || lv_context ||' after insert ');

2554: ,p_stat_trans_audit_id => ln_dummy
2555: ,p_object_version_number => l_state_tax_rec.object_version_number
2556: );
2557:
2558: hr_utility.trace('State Context is : ' || lv_context ||' after insert ');
2559:
2560: end if; /* mehul */
2561: /* Commenting this for bug 2038691
2562: -- as a sanity check we make sure that the dates are right

Line 2589: hr_utility.trace('Leaving ' || gv_package_name || '.update_tax_records');

2585: else
2586: commit;
2587: end if;
2588:
2589: hr_utility.trace('Leaving ' || gv_package_name || '.update_tax_records');
2590:
2591:
2592: EXCEPTION
2593: WHEN OTHERS THEN

Line 2647: hr_utility.trace('Entering package update_w4_info ');

2643: lv_trans_type VARCHAR2(50);
2644: lv_source_name VARCHAR2(50);
2645:
2646: begin
2647: hr_utility.trace('Entering package update_w4_info ');
2648: hr_utility.trace('p_transaction_step_id is : ' || p_transaction_step_id );
2649:
2650: open c_trans_step;
2651: fetch c_trans_step into l_transaction_id,l_person_id;

Line 2648: hr_utility.trace('p_transaction_step_id is : ' || p_transaction_step_id );

2644: lv_source_name VARCHAR2(50);
2645:
2646: begin
2647: hr_utility.trace('Entering package update_w4_info ');
2648: hr_utility.trace('p_transaction_step_id is : ' || p_transaction_step_id );
2649:
2650: open c_trans_step;
2651: fetch c_trans_step into l_transaction_id,l_person_id;
2652: close c_trans_step;

Line 2696: hr_utility.trace(' Transaction Id is : '|| to_char(l_transaction_id));

2692:
2693: end loop;
2694: close c_trans_value;
2695:
2696: hr_utility.trace(' Transaction Id is : '|| to_char(l_transaction_id));
2697: hr_utility.trace(' Person Id is : '|| to_char(l_person_id));
2698:
2699: hr_utility.trace(' Filing Status is : '|| l_filing_status_code);
2700: hr_utility.trace(' Allowances are : '|| to_char(l_allowances));

Line 2697: hr_utility.trace(' Person Id is : '|| to_char(l_person_id));

2693: end loop;
2694: close c_trans_value;
2695:
2696: hr_utility.trace(' Transaction Id is : '|| to_char(l_transaction_id));
2697: hr_utility.trace(' Person Id is : '|| to_char(l_person_id));
2698:
2699: hr_utility.trace(' Filing Status is : '|| l_filing_status_code);
2700: hr_utility.trace(' Allowances are : '|| to_char(l_allowances));
2701: hr_utility.trace(' Additional Tax is : '|| to_char(l_add_tax));

Line 2699: hr_utility.trace(' Filing Status is : '|| l_filing_status_code);

2695:
2696: hr_utility.trace(' Transaction Id is : '|| to_char(l_transaction_id));
2697: hr_utility.trace(' Person Id is : '|| to_char(l_person_id));
2698:
2699: hr_utility.trace(' Filing Status is : '|| l_filing_status_code);
2700: hr_utility.trace(' Allowances are : '|| to_char(l_allowances));
2701: hr_utility.trace(' Additional Tax is : '|| to_char(l_add_tax));
2702: hr_utility.trace(' Exempt Status is : '|| l_exempt);
2703:

Line 2700: hr_utility.trace(' Allowances are : '|| to_char(l_allowances));

2696: hr_utility.trace(' Transaction Id is : '|| to_char(l_transaction_id));
2697: hr_utility.trace(' Person Id is : '|| to_char(l_person_id));
2698:
2699: hr_utility.trace(' Filing Status is : '|| l_filing_status_code);
2700: hr_utility.trace(' Allowances are : '|| to_char(l_allowances));
2701: hr_utility.trace(' Additional Tax is : '|| to_char(l_add_tax));
2702: hr_utility.trace(' Exempt Status is : '|| l_exempt);
2703:
2704: lv_trans_type := 'ONLINE_TAX_FORMS';

Line 2701: hr_utility.trace(' Additional Tax is : '|| to_char(l_add_tax));

2697: hr_utility.trace(' Person Id is : '|| to_char(l_person_id));
2698:
2699: hr_utility.trace(' Filing Status is : '|| l_filing_status_code);
2700: hr_utility.trace(' Allowances are : '|| to_char(l_allowances));
2701: hr_utility.trace(' Additional Tax is : '|| to_char(l_add_tax));
2702: hr_utility.trace(' Exempt Status is : '|| l_exempt);
2703:
2704: lv_trans_type := 'ONLINE_TAX_FORMS';
2705: lv_source_name := 'ONLINE W4 FORM';

Line 2702: hr_utility.trace(' Exempt Status is : '|| l_exempt);

2698:
2699: hr_utility.trace(' Filing Status is : '|| l_filing_status_code);
2700: hr_utility.trace(' Allowances are : '|| to_char(l_allowances));
2701: hr_utility.trace(' Additional Tax is : '|| to_char(l_add_tax));
2702: hr_utility.trace(' Exempt Status is : '|| l_exempt);
2703:
2704: lv_trans_type := 'ONLINE_TAX_FORMS';
2705: lv_source_name := 'ONLINE W4 FORM';
2706:

Line 2721: hr_utility.trace('Leaving package update_w4_info ');

2717: p_transaction_type => lv_trans_type,
2718: p_source_name => lv_source_name,
2719: p_validate => p_validate);
2720:
2721: hr_utility.trace('Leaving package update_w4_info ');
2722: End;
2723:
2724: FUNCTION get_state_list(p_person_id IN per_people_f.person_id%TYPE,
2725: p_primary_flag IN varchar2 )

Line 2768: hr_utility.trace('Entering get_state_list');

2764: l_state_count number(3) := 0 ;
2765: l_state_exempt_count number(3) := 0 ;
2766:
2767: Begin
2768: hr_utility.trace('Entering get_state_list');
2769:
2770: lv_state_list := hr_util_misc_web.return_msg_text('PAY_US_OTF_STATE_LIST','PAY');
2771: g_state_exempt_list := hr_util_misc_web.return_msg_text('PAY_US_OTF_EXEMPT_STATE_LIST','PAY');
2772:

Line 2779: --hr_utility.trace('state is --> '|| lv_state_name ||' Code is --> '|| lv_state_default_code||' Exempt Code is --> '|| lv_state_exempt_code);

2775: exit when c_state_tax_rows%NOTFOUND;
2776:
2777: FETCH c_state_tax_rows INTO lv_state_name, lv_state_default_code,lv_state_exempt_code;
2778:
2779: --hr_utility.trace('state is --> '|| lv_state_name ||' Code is --> '|| lv_state_default_code||' Exempt Code is --> '|| lv_state_exempt_code);
2780: -- append the name to the state list to the message
2781: -- we do not append it if the code is 'Y QUIET'
2782: -- instr(lv_state_list,lv_state_name) will ensure that the state
2783: -- is appended only once to the list.

Line 2821: hr_utility.trace('Leaving get_state_list');

2817:
2818: g_state_exempt_list := null;
2819: end if;
2820:
2821: hr_utility.trace('Leaving get_state_list');
2822: return lv_state_list;
2823:
2824: End;
2825:

Line 2865: hr_utility.trace('Entering '||lv_proc);

2861:
2862: Begin
2863: lv_proc := gv_package_name || '.get_org_context';
2864:
2865: hr_utility.trace('Entering '||lv_proc);
2866:
2867: OPEN c_person_info;
2868: FETCH c_person_info INTO lr_person_info_rec;
2869:

Line 2877: hr_utility.trace('lr_person_info_rec.organization_id = '||lr_person_info_rec.organization_id);

2873: ELSE
2874: close c_person_info;
2875: end if;
2876:
2877: hr_utility.trace('lr_person_info_rec.organization_id = '||lr_person_info_rec.organization_id);
2878: hr_utility.trace('lr_person_info_rec.business_group_id = '||lr_person_info_rec.business_group_id);
2879:
2880: if p_level = 'BG' then
2881: OPEN c_org_context(lr_person_info_rec.business_group_id);

Line 2878: hr_utility.trace('lr_person_info_rec.business_group_id = '||lr_person_info_rec.business_group_id);

2874: close c_person_info;
2875: end if;
2876:
2877: hr_utility.trace('lr_person_info_rec.organization_id = '||lr_person_info_rec.organization_id);
2878: hr_utility.trace('lr_person_info_rec.business_group_id = '||lr_person_info_rec.business_group_id);
2879:
2880: if p_level = 'BG' then
2881: OPEN c_org_context(lr_person_info_rec.business_group_id);
2882: FETCH c_org_context INTO lr_org_info_rec;

Line 2900: hr_utility.trace('lr_org_info_rec.org_information2 = '||lr_org_info_rec.org_information2);

2896: end if;
2897: CLOSE c_org_context;
2898: end if;
2899:
2900: hr_utility.trace('lr_org_info_rec.org_information2 = '||lr_org_info_rec.org_information2);
2901: hr_utility.trace('lv_result = '||lv_result);
2902:
2903: hr_utility.trace('Leaving '||lv_proc);
2904: return lv_result;

Line 2901: hr_utility.trace('lv_result = '||lv_result);

2897: CLOSE c_org_context;
2898: end if;
2899:
2900: hr_utility.trace('lr_org_info_rec.org_information2 = '||lr_org_info_rec.org_information2);
2901: hr_utility.trace('lv_result = '||lv_result);
2902:
2903: hr_utility.trace('Leaving '||lv_proc);
2904: return lv_result;
2905:

Line 2903: hr_utility.trace('Leaving '||lv_proc);

2899:
2900: hr_utility.trace('lr_org_info_rec.org_information2 = '||lr_org_info_rec.org_information2);
2901: hr_utility.trace('lv_result = '||lv_result);
2902:
2903: hr_utility.trace('Leaving '||lv_proc);
2904: return lv_result;
2905:
2906: exception
2907: when no_data_found then

Line 2908: hr_utility.trace('Person Data not Found');

2904: return lv_result;
2905:
2906: exception
2907: when no_data_found then
2908: hr_utility.trace('Person Data not Found');
2909: hr_utility.trace('In Exception '||lv_proc);
2910:
2911: End get_org_context;
2912:

Line 2909: hr_utility.trace('In Exception '||lv_proc);

2905:
2906: exception
2907: when no_data_found then
2908: hr_utility.trace('Person Data not Found');
2909: hr_utility.trace('In Exception '||lv_proc);
2910:
2911: End get_org_context;
2912:
2913: /* Uncomment following two lines for debug */

Line 2915: -- hr_utility.trace_on(null,'pyuswbw4');

2911: End get_org_context;
2912:
2913: /* Uncomment following two lines for debug */
2914: -- begin
2915: -- hr_utility.trace_on(null,'pyuswbw4');
2916:
2917: END pay_us_web_w4;