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_TAX_BALS_ADJ_PKG dependencies on HR_UTILITY

Line 238: Hr_Utility.Trace('Entering '|| c_proc);

234: l_element_entry_id NUMBER;
235:
236: BEGIN
237:
238: Hr_Utility.Trace('Entering '|| c_proc);
239:
240: -- set up adjustment date
241: l_adjustment_date := p_adjustmnt_date;
242:

Line 288: Hr_Utility.Trace('Leaving pay_us_tax_bals_adj_pkg.create_adjustment');

284: WHERE source_id = l_element_entry_id
285: and source_type = 'E';
286: END IF;
287:
288: Hr_Utility.Trace('Leaving pay_us_tax_bals_adj_pkg.create_adjustment');
289:
290: END create_adjustment;
291:
292:

Line 300: Hr_Utility.Trace('|' || p_procedure_name || '() : ' || p_msg_txt);

296: p_msg_txt IN VARCHAR2) IS
297:
298: BEGIN
299:
300: Hr_Utility.Trace('|' || p_procedure_name || '() : ' || p_msg_txt);
301:
302: END private_trace;
303:
304:

Line 356: Hr_Utility.Set_Location(c_proc, 10);

352: c_proc VARCHAR2(100) := 'pay_us_tax_bals_adj_pkg.process_input';
353: l_jurisdiction_code VARCHAR2(11);
354:
355: BEGIN
356: Hr_Utility.Set_Location(c_proc, 10);
357:
358: OPEN csr_inputs (p_element_type_id, p_input_name);
359: FETCH csr_inputs INTO l_input_value_id;
360: CLOSE csr_inputs;

Line 363: Hr_Utility.Set_Location(c_proc, 20);

359: FETCH csr_inputs INTO l_input_value_id;
360: CLOSE csr_inputs;
361:
362: IF (l_input_value_id IS NULL) THEN
363: Hr_Utility.Set_Location(c_proc, 20);
364: Hr_Utility.Trace('input_value_id not found for ' ||
365: p_input_name ||
366: ' for ele_type_id ' ||
367: To_Char(p_element_type_id));

Line 364: Hr_Utility.Trace('input_value_id not found for ' ||

360: CLOSE csr_inputs;
361:
362: IF (l_input_value_id IS NULL) THEN
363: Hr_Utility.Set_Location(c_proc, 20);
364: Hr_Utility.Trace('input_value_id not found for ' ||
365: p_input_name ||
366: ' for ele_type_id ' ||
367: To_Char(p_element_type_id));
368: Hr_Utility.Set_Message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');

Line 368: Hr_Utility.Set_Message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');

364: Hr_Utility.Trace('input_value_id not found for ' ||
365: p_input_name ||
366: ' for ele_type_id ' ||
367: To_Char(p_element_type_id));
368: Hr_Utility.Set_Message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
369: Hr_Utility.Raise_Error;
370: END IF;
371:
372: -- check taxability of the tax balance element

Line 369: Hr_Utility.Raise_Error;

365: p_input_name ||
366: ' for ele_type_id ' ||
367: To_Char(p_element_type_id));
368: Hr_Utility.Set_Message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
369: Hr_Utility.Raise_Error;
370: END IF;
371:
372: -- check taxability of the tax balance element
373: Hr_Utility.Set_Location(c_proc, 30);

Line 373: Hr_Utility.Set_Location(c_proc, 30);

369: Hr_Utility.Raise_Error;
370: END IF;
371:
372: -- check taxability of the tax balance element
373: Hr_Utility.Set_Location(c_proc, 30);
374:
375: IF (g_classification IN ('Imputed Earnings', 'Supplemental Earnings')) THEN
376:
377: /** sbilling **/

Line 388: Hr_Utility.Set_Location(c_proc, 40);

384: ** causing the taxable amount to appear in Excess,
385: */
386: IF (p_input_name = 'Subj Whable' OR p_input_name = 'TAXABLE') THEN
387:
388: Hr_Utility.Set_Location(c_proc, 40);
389:
390: IF (p_element_type IN ('SUI_EE', 'SUI_SUBJECT_EE',
391: 'SUI_ER', 'SUI_SUBJECT_ER')) THEN
392: Hr_Utility.Set_Location(c_proc, 41);

Line 392: Hr_Utility.Set_Location(c_proc, 41);

388: Hr_Utility.Set_Location(c_proc, 40);
389:
390: IF (p_element_type IN ('SUI_EE', 'SUI_SUBJECT_EE',
391: 'SUI_ER', 'SUI_SUBJECT_ER')) THEN
392: Hr_Utility.Set_Location(c_proc, 41);
393: OPEN csr_chk_taxability ('SUI', g_state_jd );
394: FETCH csr_chk_taxability INTO l_taxable;
395: CLOSE csr_chk_taxability;
396:

Line 398: Hr_Utility.Set_Location(c_proc, 42);

394: FETCH csr_chk_taxability INTO l_taxable;
395: CLOSE csr_chk_taxability;
396:
397: ELSIF (p_element_type IN ('Medicare_EE', 'Medicare_ER')) THEN
398: Hr_Utility.Set_Location(c_proc, 42);
399: OPEN csr_chk_fed_taxability ('MEDICARE');
400: FETCH csr_chk_fed_taxability INTO l_taxable;
401: CLOSE csr_chk_fed_taxability;
402:

Line 404: Hr_Utility.Set_Location(c_proc, 43);

400: FETCH csr_chk_fed_taxability INTO l_taxable;
401: CLOSE csr_chk_fed_taxability;
402:
403: ELSIF (p_element_type IN ('SS_EE', 'SS_ER')) THEN
404: Hr_Utility.Set_Location(c_proc, 43);
405: OPEN csr_chk_fed_taxability ('SS');
406: FETCH csr_chk_fed_taxability INTO l_taxable;
407: CLOSE csr_chk_fed_taxability;
408:

Line 410: Hr_Utility.Set_Location(c_proc, 43);

406: FETCH csr_chk_fed_taxability INTO l_taxable;
407: CLOSE csr_chk_fed_taxability;
408:
409: ELSIF (p_element_type IN ('FUTA')) THEN
410: Hr_Utility.Set_Location(c_proc, 43);
411: OPEN csr_chk_fed_taxability ('FUTA');
412: FETCH csr_chk_fed_taxability INTO l_taxable;
413: CLOSE csr_chk_fed_taxability;
414:

Line 417: Hr_Utility.Set_Location(c_proc, 42);

413: CLOSE csr_chk_fed_taxability;
414:
415: ELSIF (p_element_type IN ('SDI_EE', 'SDI_SUBJECT_EE',
416: 'SDI_ER', 'SDI_SUBJECT_ER')) THEN
417: Hr_Utility.Set_Location(c_proc, 42);
418: OPEN csr_chk_taxability ('SDI', g_state_jd );
419: FETCH csr_chk_taxability into l_taxable;
420: CLOSE csr_chk_taxability;
421:

Line 423: Hr_Utility.Set_Location(c_proc, 43);

419: FETCH csr_chk_taxability into l_taxable;
420: CLOSE csr_chk_taxability;
421:
422: ELSIF (p_element_type IN ('SIT_SUBJECT_WK')) THEN
423: Hr_Utility.Set_Location(c_proc, 43);
424: OPEN csr_chk_taxability ('SIT', g_state_jd );
425: FETCH csr_chk_taxability INTO l_taxable;
426: CLOSE csr_chk_taxability;
427:

Line 429: Hr_Utility.Set_Location(c_proc, 44);

425: FETCH csr_chk_taxability INTO l_taxable;
426: CLOSE csr_chk_taxability;
427:
428: ELSIF (p_element_type IN ('City_SUBJECT_WK')) THEN
429: Hr_Utility.Set_Location(c_proc, 44);
430: l_jurisdiction_code := substr(g_city_jd,1,3) || '000' || substr(g_city_jd,7,5);
431: OPEN csr_chk_taxability ('CITY', l_jurisdiction_code);
432: FETCH csr_chk_taxability INTO l_taxable;
433: -- If the above query returns no rows then check the state level taxablility rule

Line 444: Hr_Utility.Set_Location(c_proc, 45);

440: CLOSE csr_chk_taxability;
441: END IF;
442:
443: ELSIF (p_element_type IN ('County_SUBJECT_WK')) THEN
444: Hr_Utility.Set_Location(c_proc, 45);
445: OPEN csr_chk_taxability ('COUNTY', g_county_jd);
446: FETCH csr_chk_taxability INTO l_taxable;
447: -- If the above query returns no rows then check the state level taxablility rule
448: IF csr_chk_taxability%NOTFOUND THEN

Line 460: Hr_Utility.Set_Location(c_proc, 50);

456:
457: END IF;
458:
459: ELSIF (p_input_name = 'Subj NWhable') THEN
460: Hr_Utility.Set_Location(c_proc, 50);
461:
462: IF (p_element_type IN ('SIT_SUBJECT_WK')) THEN
463: Hr_Utility.Set_Location(c_proc, 51);
464: OPEN csr_chk_taxability ('NW_SIT', g_state_jd);

Line 463: Hr_Utility.Set_Location(c_proc, 51);

459: ELSIF (p_input_name = 'Subj NWhable') THEN
460: Hr_Utility.Set_Location(c_proc, 50);
461:
462: IF (p_element_type IN ('SIT_SUBJECT_WK')) THEN
463: Hr_Utility.Set_Location(c_proc, 51);
464: OPEN csr_chk_taxability ('NW_SIT', g_state_jd);
465: FETCH csr_chk_taxability INTO l_taxable;
466: CLOSE csr_chk_taxability;
467:

Line 469: Hr_Utility.Set_Location(c_proc, 52);

465: FETCH csr_chk_taxability INTO l_taxable;
466: CLOSE csr_chk_taxability;
467:
468: ELSIF (p_element_type IN ('City_SUBJECT_WK')) THEN
469: Hr_Utility.Set_Location(c_proc, 52);
470: l_jurisdiction_code := substr(g_city_jd,1,3) || '000' || substr(g_city_jd,7,5);
471: OPEN csr_chk_taxability ('NW_CITY', l_jurisdiction_code);
472: FETCH csr_chk_taxability INTO l_taxable;
473: -- If the above query returns no rows then check the state level taxablility rule

Line 484: Hr_Utility.Set_Location(c_proc, 53);

480: CLOSE csr_chk_taxability;
481: END IF;
482:
483: ELSIF (p_element_type IN ('County_SUBJECT_WK')) THEN
484: Hr_Utility.Set_Location(c_proc, 53);
485: OPEN csr_chk_taxability ('NW_COUNTY', g_county_jd);
486: FETCH csr_chk_taxability INTO l_taxable;
487: -- If the above query returns no rows then check the state level taxablility rule
488: IF csr_chk_taxability%NOTFOUND THEN

Line 500: Hr_Utility.Set_Location(c_proc, 60);

496:
497: END IF;
498:
499: ELSE
500: Hr_Utility.Set_Location(c_proc, 60);
501: -- otherwise we do not need to check taxability_rules
502: -- in order to set the value of the input value,
503: -- NB. that this step gets executed for tax elements like FIT, Medicare
504: -- as well as Tax balance elements like SUI_SUBJECT_EE

Line 510: Hr_Utility.Set_Location(c_proc, 70);

506: END IF;
507:
508: ELSE
509: -- an Earnings Element so no taxability rules
510: Hr_Utility.Set_Location(c_proc, 70);
511:
512: l_taxable := 'Y';
513:
514: END IF;

Line 518: Hr_Utility.Set_Location (c_proc, 200);

514: END IF;
515:
516:
517: IF (l_taxable = 'Y') THEN
518: Hr_Utility.Set_Location (c_proc, 200);
519: Hr_Utility.Trace('row ' ||
520: To_Char(p_row) ||
521: ' inpvl_id>' ||
522: To_Char(l_input_value_id) ||

Line 519: Hr_Utility.Trace('row ' ||

515:
516:
517: IF (l_taxable = 'Y') THEN
518: Hr_Utility.Set_Location (c_proc, 200);
519: Hr_Utility.Trace('row ' ||
520: To_Char(p_row) ||
521: ' inpvl_id>' ||
522: To_Char(l_input_value_id) ||
523: '< ' ||

Line 621: Hr_Utility.Set_Location(c_proc, 10);

617: /** stub - find an apppriate error message **/
618: IF (l_futa_wage_limit IS NULL OR
619: l_ss_ee_wage_limit IS NULL OR
620: l_ss_er_wage_limit IS NULL) THEN
621: Hr_Utility.Set_Location(c_proc, 10);
622: Hr_Utility.Set_Message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
623: Hr_Utility.Raise_Error;
624: END IF;
625:

Line 622: Hr_Utility.Set_Message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');

618: IF (l_futa_wage_limit IS NULL OR
619: l_ss_ee_wage_limit IS NULL OR
620: l_ss_er_wage_limit IS NULL) THEN
621: Hr_Utility.Set_Location(c_proc, 10);
622: Hr_Utility.Set_Message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
623: Hr_Utility.Raise_Error;
624: END IF;
625:
626:

Line 623: Hr_Utility.Raise_Error;

619: l_ss_ee_wage_limit IS NULL OR
620: l_ss_er_wage_limit IS NULL) THEN
621: Hr_Utility.Set_Location(c_proc, 10);
622: Hr_Utility.Set_Message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
623: Hr_Utility.Raise_Error;
624: END IF;
625:
626:
627: /*

Line 661: Hr_Utility.Trace('|');

657: l_limit NUMBER;
658:
659: BEGIN
660:
661: Hr_Utility.Trace('|');
662: private_trace(c_proc, p_element_type);
663: Hr_Utility.Trace('| ***** Start Dump *****');
664: FOR l_i IN 1..(p_num_ev - 1) LOOP
665:

Line 663: Hr_Utility.Trace('| * Start Dump *');

659: BEGIN
660:
661: Hr_Utility.Trace('|');
662: private_trace(c_proc, p_element_type);
663: Hr_Utility.Trace('| ***** Start Dump *****');
664: FOR l_i IN 1..(p_num_ev - 1) LOOP
665:
666: Hr_Utility.Trace('| ' ||
667: To_Char(l_i) ||

Line 666: Hr_Utility.Trace('| ' ||

662: private_trace(c_proc, p_element_type);
663: Hr_Utility.Trace('| ***** Start Dump *****');
664: FOR l_i IN 1..(p_num_ev - 1) LOOP
665:
666: Hr_Utility.Trace('| ' ||
667: To_Char(l_i) ||
668: ' ' ||
669: p_iv_names_tbl(l_i) ||
670: ' ' ||

Line 680: Hr_Utility.Trace('| * End Dump *');

676: NULL;
677: END LOOP;
678:
679: END LOOP;
680: Hr_Utility.Trace('| ***** End Dump *****');
681:
682:
683: /*
684: ** find position of TAXABLE IV in tbl structure

Line 741: Hr_Utility.Set_Location(c_proc, 10);

737: l_old_taxable_bal := g_sui_er_taxable;
738: l_limit := g_sui_er_wage_limit;
739: ELSE
740: /** stub - find appropriate message **/
741: Hr_Utility.Set_Location(c_proc, 10);
742: Hr_Utility.Set_Message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
743: Hr_Utility.Raise_Error;
744:
745: END IF;

Line 742: Hr_Utility.Set_Message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');

738: l_limit := g_sui_er_wage_limit;
739: ELSE
740: /** stub - find appropriate message **/
741: Hr_Utility.Set_Location(c_proc, 10);
742: Hr_Utility.Set_Message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
743: Hr_Utility.Raise_Error;
744:
745: END IF;
746:

Line 743: Hr_Utility.Raise_Error;

739: ELSE
740: /** stub - find appropriate message **/
741: Hr_Utility.Set_Location(c_proc, 10);
742: Hr_Utility.Set_Message(801, 'PY_50014_TXADJ_IV_ID_NOT_FOUND');
743: Hr_Utility.Raise_Error;
744:
745: END IF;
746:
747:

Line 877: Hr_Utility.Trace('Entering pay_us_tax_bals_adj_pkg.process_element');

873: l_payroll_action_id NUMBER;
874:
875: BEGIN
876:
877: Hr_Utility.Trace('Entering pay_us_tax_bals_adj_pkg.process_element');
878: Hr_Utility.Set_Location(c_proc, 10);
879: OPEN csr_element;
880: FETCH csr_element INTO l_element;
881: CLOSE csr_element;

Line 878: Hr_Utility.Set_Location(c_proc, 10);

874:
875: BEGIN
876:
877: Hr_Utility.Trace('Entering pay_us_tax_bals_adj_pkg.process_element');
878: Hr_Utility.Set_Location(c_proc, 10);
879: OPEN csr_element;
880: FETCH csr_element INTO l_element;
881: CLOSE csr_element;
882:

Line 884: Hr_Utility.Set_Location(c_proc, 20);

880: FETCH csr_element INTO l_element;
881: CLOSE csr_element;
882:
883: IF (l_element.element_type_id IS NULL) THEN
884: Hr_Utility.Set_Location(c_proc, 20);
885: Hr_Utility.Trace('Element does not exist: '||p_element_type);
886: Hr_Utility.Set_Message(801, 'HR_6884_ELE_ENTRY_NO_ELEMENT');
887: Hr_Utility.Raise_Error;
888: END IF;

Line 885: Hr_Utility.Trace('Element does not exist: '||p_element_type);

881: CLOSE csr_element;
882:
883: IF (l_element.element_type_id IS NULL) THEN
884: Hr_Utility.Set_Location(c_proc, 20);
885: Hr_Utility.Trace('Element does not exist: '||p_element_type);
886: Hr_Utility.Set_Message(801, 'HR_6884_ELE_ENTRY_NO_ELEMENT');
887: Hr_Utility.Raise_Error;
888: END IF;
889:

Line 886: Hr_Utility.Set_Message(801, 'HR_6884_ELE_ENTRY_NO_ELEMENT');

882:
883: IF (l_element.element_type_id IS NULL) THEN
884: Hr_Utility.Set_Location(c_proc, 20);
885: Hr_Utility.Trace('Element does not exist: '||p_element_type);
886: Hr_Utility.Set_Message(801, 'HR_6884_ELE_ENTRY_NO_ELEMENT');
887: Hr_Utility.Raise_Error;
888: END IF;
889:
890: Hr_Utility.Set_Location(c_proc, 30);

Line 887: Hr_Utility.Raise_Error;

883: IF (l_element.element_type_id IS NULL) THEN
884: Hr_Utility.Set_Location(c_proc, 20);
885: Hr_Utility.Trace('Element does not exist: '||p_element_type);
886: Hr_Utility.Set_Message(801, 'HR_6884_ELE_ENTRY_NO_ELEMENT');
887: Hr_Utility.Raise_Error;
888: END IF;
889:
890: Hr_Utility.Set_Location(c_proc, 30);
891: l_ele_link_id := hr_entry_api.get_link(

Line 890: Hr_Utility.Set_Location(c_proc, 30);

886: Hr_Utility.Set_Message(801, 'HR_6884_ELE_ENTRY_NO_ELEMENT');
887: Hr_Utility.Raise_Error;
888: END IF;
889:
890: Hr_Utility.Set_Location(c_proc, 30);
891: l_ele_link_id := hr_entry_api.get_link(
892: p_assignment_id => p_assignment_id,
893: p_element_type_id => l_element.element_type_id,
894: p_session_date => p_adjustment_date);

Line 897: Hr_Utility.Set_Location(c_proc, 40);

893: p_element_type_id => l_element.element_type_id,
894: p_session_date => p_adjustment_date);
895:
896: IF (l_ele_link_id IS NULL) THEN
897: Hr_Utility.Set_Location(c_proc, 40);
898: Hr_Utility.Trace('Link does not exist for element: '||p_element_type);
899: Hr_Utility.Set_Message(801, 'PY_51132_TXADJ_LINK_MISSING');
900: Hr_Utility.Set_Message_token ('ELEMENT', p_element_type);
901: Hr_Utility.Raise_Error;

Line 898: Hr_Utility.Trace('Link does not exist for element: '||p_element_type);

894: p_session_date => p_adjustment_date);
895:
896: IF (l_ele_link_id IS NULL) THEN
897: Hr_Utility.Set_Location(c_proc, 40);
898: Hr_Utility.Trace('Link does not exist for element: '||p_element_type);
899: Hr_Utility.Set_Message(801, 'PY_51132_TXADJ_LINK_MISSING');
900: Hr_Utility.Set_Message_token ('ELEMENT', p_element_type);
901: Hr_Utility.Raise_Error;
902: END IF;

Line 899: Hr_Utility.Set_Message(801, 'PY_51132_TXADJ_LINK_MISSING');

895:
896: IF (l_ele_link_id IS NULL) THEN
897: Hr_Utility.Set_Location(c_proc, 40);
898: Hr_Utility.Trace('Link does not exist for element: '||p_element_type);
899: Hr_Utility.Set_Message(801, 'PY_51132_TXADJ_LINK_MISSING');
900: Hr_Utility.Set_Message_token ('ELEMENT', p_element_type);
901: Hr_Utility.Raise_Error;
902: END IF;
903:

Line 900: Hr_Utility.Set_Message_token ('ELEMENT', p_element_type);

896: IF (l_ele_link_id IS NULL) THEN
897: Hr_Utility.Set_Location(c_proc, 40);
898: Hr_Utility.Trace('Link does not exist for element: '||p_element_type);
899: Hr_Utility.Set_Message(801, 'PY_51132_TXADJ_LINK_MISSING');
900: Hr_Utility.Set_Message_token ('ELEMENT', p_element_type);
901: Hr_Utility.Raise_Error;
902: END IF;
903:
904:

Line 901: Hr_Utility.Raise_Error;

897: Hr_Utility.Set_Location(c_proc, 40);
898: Hr_Utility.Trace('Link does not exist for element: '||p_element_type);
899: Hr_Utility.Set_Message(801, 'PY_51132_TXADJ_LINK_MISSING');
900: Hr_Utility.Set_Message_token ('ELEMENT', p_element_type);
901: Hr_Utility.Raise_Error;
902: END IF;
903:
904:
905: -- initialize tables

Line 915: Hr_Utility.Set_Location(c_proc, 50);

911:
912: -- explicitly set the various input values,
913: -- this clearly identifies which input values are expected and will cause failure
914: -- if the input value has been deleted somehow
915: Hr_Utility.Set_Location(c_proc, 50);
916:
917: IF (l_element.classification_name IN ('Earnings', 'Imputed Earnings',
918: 'Supplemental Earnings')) THEN
919: -- element is an Earnings element,

Line 932: Hr_Utility.Set_Location (c_proc, 60);

928: p_bg_id, p_adjustment_date,
929: 'Pay Value', fnd_number.number_to_canonical(p_earn_amount), l_num_ev);
930:
931: ELSIF (p_element_type IN ('FIT')) THEN
932: Hr_Utility.Set_Location (c_proc, 60);
933: process_input(p_element_type, l_element.element_type_id,
934: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
935: p_bg_id, p_adjustment_date,
936: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);

Line 946: Hr_Utility.Set_Location (c_proc, 65);

942: 'Supp Tax', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
943: END IF;
944:
945: ELSIF (p_element_type IN ('FIT 3rd Party')) THEN
946: Hr_Utility.Set_Location (c_proc, 65);
947: process_input(p_element_type, l_element.element_type_id,
948: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
949: p_bg_id, p_adjustment_date,
950: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);

Line 953: Hr_Utility.Set_Location(c_proc, 71);

949: p_bg_id, p_adjustment_date,
950: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
951:
952: ELSIF (p_element_type IN ('SS_EE', 'Medicare_EE')) THEN
953: Hr_Utility.Set_Location(c_proc, 71);
954: IF (p_adj_amount <> 0) THEN
955: process_input(p_element_type, l_element.element_type_id,
956: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
957: p_bg_id, p_adjustment_date,

Line 961: Hr_Utility.Set_Location(c_proc, 72);

957: p_bg_id, p_adjustment_date,
958: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
959: END IF;
960:
961: Hr_Utility.Set_Location(c_proc, 72);
962: process_input(p_element_type, l_element.element_type_id,
963: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
964: p_bg_id, p_adjustment_date,
965: 'TAXABLE', fnd_number.number_to_canonical(p_earn_amount), l_num_ev);

Line 1008: Hr_Utility.Set_Location(c_proc, 81);

1004:
1005:
1006:
1007: ELSIF (p_element_type IN ('SIT_WK')) THEN
1008: Hr_Utility.Set_Location(c_proc, 81);
1009:
1010: process_input(p_element_type, l_element.element_type_id,
1011: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1012: p_bg_id, p_adjustment_date,

Line 1014: Hr_Utility.Set_Location(c_proc, 82);

1010: process_input(p_element_type, l_element.element_type_id,
1011: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1012: p_bg_id, p_adjustment_date,
1013: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
1014: Hr_Utility.Set_Location(c_proc, 82);
1015:
1016: process_input(p_element_type, l_element.element_type_id,
1017: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1018: p_bg_id, p_adjustment_date,

Line 1037: Hr_Utility.Set_Location(c_proc, 81);

1033: /*
1034: ** new tax element to be processed, use SIT_WK as a template
1035: */
1036: ELSIF (p_element_type IN ('County_SC_WK')) THEN
1037: Hr_Utility.Set_Location(c_proc, 81);
1038:
1039: process_input(p_element_type, l_element.element_type_id,
1040: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1041: p_bg_id, p_adjustment_date,

Line 1043: Hr_Utility.Set_Location(c_proc, 82);

1039: process_input(p_element_type, l_element.element_type_id,
1040: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1041: p_bg_id, p_adjustment_date,
1042: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
1043: Hr_Utility.Set_Location(c_proc, 82);
1044:
1045:
1046: /*
1047: ** can't put the Gross for the BA into the Gross for the school district tax,

Line 1061: Hr_Utility.Set_Location(c_proc, 91);

1057:
1058:
1059:
1060: ELSIF (p_element_type IN ('SUI_EE', 'SDI_EE')) THEN
1061: Hr_Utility.Set_Location(c_proc, 91);
1062:
1063: IF (p_adj_amount <> 0) THEN
1064: process_input(p_element_type, l_element.element_type_id,
1065: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,

Line 1068: Hr_Utility.Set_Location(c_proc, 915);

1064: process_input(p_element_type, l_element.element_type_id,
1065: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1066: p_bg_id, p_adjustment_date,
1067: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
1068: Hr_Utility.Set_Location(c_proc, 915);
1069: END IF;
1070:
1071: Hr_Utility.Set_Location(c_proc, 92);
1072:

Line 1071: Hr_Utility.Set_Location(c_proc, 92);

1067: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
1068: Hr_Utility.Set_Location(c_proc, 915);
1069: END IF;
1070:
1071: Hr_Utility.Set_Location(c_proc, 92);
1072:
1073: process_input(p_element_type, l_element.element_type_id,
1074: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1075: p_bg_id, p_adjustment_date,

Line 1077: Hr_Utility.Set_Location(c_proc, 93);

1073: process_input(p_element_type, l_element.element_type_id,
1074: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1075: p_bg_id, p_adjustment_date,
1076: 'TAXABLE', fnd_number.number_to_canonical(p_earn_amount), l_num_ev);
1077: Hr_Utility.Set_Location(c_proc, 93);
1078:
1079: process_input(p_element_type, l_element.element_type_id,
1080: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1081: p_bg_id, p_adjustment_date,

Line 1097: Hr_Utility.Set_Location(c_proc, 101);

1093:
1094:
1095:
1096: ELSIF (p_element_type IN ('City_WK', 'County_WK')) THEN
1097: Hr_Utility.Set_Location(c_proc, 101);
1098:
1099: process_input(p_element_type, l_element.element_type_id,
1100: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1101: p_bg_id, p_adjustment_date,

Line 1103: Hr_Utility.Set_Location(c_proc, 102);

1099: process_input(p_element_type, l_element.element_type_id,
1100: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1101: p_bg_id, p_adjustment_date,
1102: 'Pay Value', fnd_number.number_to_canonical(p_adj_amount), l_num_ev);
1103: Hr_Utility.Set_Location(c_proc, 102);
1104:
1105: process_input(p_element_type, l_element.element_type_id,
1106: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1107: p_bg_id, p_adjustment_date,

Line 1112: Hr_Utility.Set_Location(c_proc, 111);

1108: 'Jurisdiction', p_jurisdiction, l_num_ev);
1109:
1110: ELSIF (p_element_type IN ('SIT_SUBJECT_WK', 'City_SUBJECT_WK',
1111: 'County_SUBJECT_WK')) THEN
1112: Hr_Utility.Set_Location(c_proc, 111);
1113:
1114: process_input(p_element_type, l_element.element_type_id,
1115: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1116: p_bg_id, p_adjustment_date,

Line 1118: Hr_Utility.Set_Location(c_proc, 112);

1114: process_input(p_element_type, l_element.element_type_id,
1115: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1116: p_bg_id, p_adjustment_date,
1117: 'Jurisdiction', p_jurisdiction, l_num_ev);
1118: Hr_Utility.Set_Location(c_proc, 112);
1119:
1120: process_input(p_element_type, l_element.element_type_id,
1121: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1122: p_bg_id, p_adjustment_date,

Line 1124: Hr_Utility.Set_Location(c_proc, 113);

1120: process_input(p_element_type, l_element.element_type_id,
1121: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1122: p_bg_id, p_adjustment_date,
1123: 'Gross', fnd_number.number_to_canonical(p_earn_amount), l_num_ev);
1124: Hr_Utility.Set_Location(c_proc, 113);
1125:
1126: process_input(p_element_type, l_element.element_type_id,
1127: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1128: p_bg_id, p_adjustment_date,

Line 1130: Hr_Utility.Set_Location(c_proc, 114);

1126: process_input(p_element_type, l_element.element_type_id,
1127: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1128: p_bg_id, p_adjustment_date,
1129: 'Subj Whable', fnd_number.number_to_canonical(p_earn_amount), l_num_ev);
1130: Hr_Utility.Set_Location(c_proc, 114);
1131:
1132: IF (g_classification IN ('Imputed Earnings',
1133: 'Supplemental Earnings')) THEN
1134: Hr_Utility.Set_Location(c_proc, 115);

Line 1134: Hr_Utility.Set_Location(c_proc, 115);

1130: Hr_Utility.Set_Location(c_proc, 114);
1131:
1132: IF (g_classification IN ('Imputed Earnings',
1133: 'Supplemental Earnings')) THEN
1134: Hr_Utility.Set_Location(c_proc, 115);
1135:
1136: process_input (p_element_type, l_element.element_type_id,
1137: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1138: p_bg_id, p_adjustment_date,

Line 1144: Hr_Utility.Set_Location(c_proc, 121);

1140: END IF;
1141:
1142: ELSIF (p_element_type IN ('SDI_SUBJECT_EE', 'SDI_SUBJECT_ER',
1143: 'SUI_SUBJECT_EE', 'SUI_SUBJECT_ER')) THEN
1144: Hr_Utility.Set_Location(c_proc, 121);
1145:
1146: process_input(p_element_type, l_element.element_type_id,
1147: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1148: p_bg_id, p_adjustment_date,

Line 1150: Hr_Utility.Set_Location(c_proc, 122);

1146: process_input(p_element_type, l_element.element_type_id,
1147: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1148: p_bg_id, p_adjustment_date,
1149: 'Jurisdiction', p_jurisdiction, l_num_ev);
1150: Hr_Utility.Set_Location(c_proc, 122);
1151:
1152: process_input(p_element_type, l_element.element_type_id,
1153: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1154: p_bg_id, p_adjustment_date,

Line 1156: Hr_Utility.Set_Location(c_proc, 123);

1152: process_input(p_element_type, l_element.element_type_id,
1153: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1154: p_bg_id, p_adjustment_date,
1155: 'Gross', fnd_number.number_to_canonical(p_earn_amount), l_num_ev);
1156: Hr_Utility.Set_Location(c_proc, 123);
1157:
1158: process_input(p_element_type, l_element.element_type_id,
1159: l_iv_tbl, l_iv_names_tbl, l_ev_tbl,
1160: p_bg_id, p_adjustment_date,

Line 1164: Hr_Utility.Set_Location (c_proc, 124);

1160: p_bg_id, p_adjustment_date,
1161: 'Subj Whable', fnd_number.number_to_canonical(p_earn_amount), l_num_ev);
1162:
1163: ELSIF (p_element_type IN ('SUI_ER', 'SDI_ER')) THEN
1164: Hr_Utility.Set_Location (c_proc, 124);
1165:
1166:
1167: /** sbilling **/
1168: /*

Line 1202: Hr_Utility.Set_Location(c_proc, 130);

1198:
1199:
1200: -- set mandatory input values,
1201: -- cannot set these to null, core package expects mandatory values to be entered
1202: Hr_Utility.Set_Location(c_proc, 130);
1203:
1204: FOR l_req_input IN csr_set_mandatory_inputs (l_element.element_type_id) LOOP
1205: -- first, check if the mandatory input value was explicitly
1206: -- set above, do nothing in this case

Line 1207: Hr_Utility.Set_Location(c_proc, 140);

1203:
1204: FOR l_req_input IN csr_set_mandatory_inputs (l_element.element_type_id) LOOP
1205: -- first, check if the mandatory input value was explicitly
1206: -- set above, do nothing in this case
1207: Hr_Utility.Set_Location(c_proc, 140);
1208:
1209: FOR l_counter IN 1..l_num_ev LOOP
1210:
1211: IF (l_req_input.input_name = l_iv_names_tbl(l_counter)) THEN

Line 1216: Hr_Utility.Set_Location(c_proc, 150);

1212: NULL;
1213: ELSE
1214: -- then the input value was not previously set by one of the
1215: -- process_inputs called in process_elements
1216: Hr_Utility.Set_Location(c_proc, 150);
1217: l_num_ev := l_num_ev + 1;
1218:
1219: l_iv_tbl(l_num_ev) := l_req_input.input_value_id;
1220: l_iv_names_tbl(l_num_ev) := l_req_input.input_name;

Line 1228: Hr_Utility.Set_Location(c_proc, 160);

1224: END LOOP;
1225:
1226: END LOOP;
1227:
1228: Hr_Utility.Set_Location(c_proc, 160);
1229: create_adjustment(
1230: p_adjustmnt_date => p_adjustment_date,
1231: p_assignment_id => p_assignment_id,
1232: p_element_link_id => l_ele_link_id,

Line 1243: Hr_Utility.Set_Location(c_proc, 200);

1239: p_cost => p_cost);
1240:
1241: -- populate the payroll_actions table with the adjustment
1242: -- payroll_action_id
1243: Hr_Utility.Set_Location(c_proc, 200);
1244: Hr_Utility.Trace('Tax type= '||p_element_type ||
1245: ' pactid = '||To_Char(l_payroll_action_id));
1246: g_tax_type_tbl(g_pact_cntr) := p_abbrev_element_type;
1247: g_tax_adj_pactid_tbl(g_pact_cntr) := l_payroll_action_id;

Line 1244: Hr_Utility.Trace('Tax type= '||p_element_type ||

1240:
1241: -- populate the payroll_actions table with the adjustment
1242: -- payroll_action_id
1243: Hr_Utility.Set_Location(c_proc, 200);
1244: Hr_Utility.Trace('Tax type= '||p_element_type ||
1245: ' pactid = '||To_Char(l_payroll_action_id));
1246: g_tax_type_tbl(g_pact_cntr) := p_abbrev_element_type;
1247: g_tax_adj_pactid_tbl(g_pact_cntr) := l_payroll_action_id;
1248: g_pact_cntr := g_pact_cntr + 1;

Line 1250: Hr_Utility.Trace('Leaving pay_us_tax_bals_adj_pkg.process_element');

1246: g_tax_type_tbl(g_pact_cntr) := p_abbrev_element_type;
1247: g_tax_adj_pactid_tbl(g_pact_cntr) := l_payroll_action_id;
1248: g_pact_cntr := g_pact_cntr + 1;
1249:
1250: Hr_Utility.Trace('Leaving pay_us_tax_bals_adj_pkg.process_element');
1251:
1252: END process_element;
1253:
1254:

Line 1314: Hr_Utility.Set_Location(c_proc, 10);

1310:
1311: BEGIN
1312:
1313: IF (p_city_name IS NOT NULL AND p_zip_code IS NOT NULL) THEN
1314: Hr_Utility.Set_Location(c_proc, 10);
1315: l_geocode := hr_us_ff_udfs.addr_val(
1316: p_state_abbrev => p_state_abbrev,
1317: p_county_name => p_county_name,
1318: p_city_name => p_city_name,

Line 1326: Hr_Utility.Set_Location(c_proc, 15);

1322: FETCH csr_chk_local INTO l_valid_for_asg;
1323: CLOSE csr_chk_local;
1324:
1325: IF (l_valid_for_asg = 'FAIL') THEN
1326: Hr_Utility.Set_Location(c_proc, 15);
1327: Hr_Utility.Trace('The city is not valid for the assignment');
1328: Hr_Utility.Set_Message(801, 'PY_51133_TXADJ_INVALID_CITY');
1329: Hr_Utility.Raise_Error;
1330: END IF;

Line 1327: Hr_Utility.Trace('The city is not valid for the assignment');

1323: CLOSE csr_chk_local;
1324:
1325: IF (l_valid_for_asg = 'FAIL') THEN
1326: Hr_Utility.Set_Location(c_proc, 15);
1327: Hr_Utility.Trace('The city is not valid for the assignment');
1328: Hr_Utility.Set_Message(801, 'PY_51133_TXADJ_INVALID_CITY');
1329: Hr_Utility.Raise_Error;
1330: END IF;
1331:

Line 1328: Hr_Utility.Set_Message(801, 'PY_51133_TXADJ_INVALID_CITY');

1324:
1325: IF (l_valid_for_asg = 'FAIL') THEN
1326: Hr_Utility.Set_Location(c_proc, 15);
1327: Hr_Utility.Trace('The city is not valid for the assignment');
1328: Hr_Utility.Set_Message(801, 'PY_51133_TXADJ_INVALID_CITY');
1329: Hr_Utility.Raise_Error;
1330: END IF;
1331:
1332: ELSIF (p_county_name IS NOT NULL AND p_state_abbrev IS NOT NULL) THEN

Line 1329: Hr_Utility.Raise_Error;

1325: IF (l_valid_for_asg = 'FAIL') THEN
1326: Hr_Utility.Set_Location(c_proc, 15);
1327: Hr_Utility.Trace('The city is not valid for the assignment');
1328: Hr_Utility.Set_Message(801, 'PY_51133_TXADJ_INVALID_CITY');
1329: Hr_Utility.Raise_Error;
1330: END IF;
1331:
1332: ELSIF (p_county_name IS NOT NULL AND p_state_abbrev IS NOT NULL) THEN
1333: Hr_Utility.Set_Location(c_proc, 20);

Line 1333: Hr_Utility.Set_Location(c_proc, 20);

1329: Hr_Utility.Raise_Error;
1330: END IF;
1331:
1332: ELSIF (p_county_name IS NOT NULL AND p_state_abbrev IS NOT NULL) THEN
1333: Hr_Utility.Set_Location(c_proc, 20);
1334: OPEN csr_county_code;
1335: FETCH csr_county_code INTO l_state_code, l_county_code;
1336: CLOSE csr_county_code;
1337: l_geocode := l_state_code||'-'||l_county_code||'-0000';

Line 1344: Hr_Utility.Set_Location(c_proc, 25);

1340: FETCH csr_chk_local INTO l_valid_for_asg;
1341: CLOSE csr_chk_local;
1342:
1343: IF (l_valid_for_asg = 'FAIL') THEN
1344: Hr_Utility.Set_Location(c_proc, 25);
1345: Hr_Utility.Trace('The county is not valid for the assignment');
1346: Hr_Utility.Set_Message(801, 'PY_51133_TXADJ_INVALID_CITY');
1347: Hr_Utility.Raise_Error;
1348: END IF;

Line 1345: Hr_Utility.Trace('The county is not valid for the assignment');

1341: CLOSE csr_chk_local;
1342:
1343: IF (l_valid_for_asg = 'FAIL') THEN
1344: Hr_Utility.Set_Location(c_proc, 25);
1345: Hr_Utility.Trace('The county is not valid for the assignment');
1346: Hr_Utility.Set_Message(801, 'PY_51133_TXADJ_INVALID_CITY');
1347: Hr_Utility.Raise_Error;
1348: END IF;
1349:

Line 1346: Hr_Utility.Set_Message(801, 'PY_51133_TXADJ_INVALID_CITY');

1342:
1343: IF (l_valid_for_asg = 'FAIL') THEN
1344: Hr_Utility.Set_Location(c_proc, 25);
1345: Hr_Utility.Trace('The county is not valid for the assignment');
1346: Hr_Utility.Set_Message(801, 'PY_51133_TXADJ_INVALID_CITY');
1347: Hr_Utility.Raise_Error;
1348: END IF;
1349:
1350: ELSIF (p_county_name IS NULL AND p_state_abbrev IS NOT NULL) THEN

Line 1347: Hr_Utility.Raise_Error;

1343: IF (l_valid_for_asg = 'FAIL') THEN
1344: Hr_Utility.Set_Location(c_proc, 25);
1345: Hr_Utility.Trace('The county is not valid for the assignment');
1346: Hr_Utility.Set_Message(801, 'PY_51133_TXADJ_INVALID_CITY');
1347: Hr_Utility.Raise_Error;
1348: END IF;
1349:
1350: ELSIF (p_county_name IS NULL AND p_state_abbrev IS NOT NULL) THEN
1351: Hr_Utility.Set_Location(c_proc, 30);

Line 1351: Hr_Utility.Set_Location(c_proc, 30);

1347: Hr_Utility.Raise_Error;
1348: END IF;
1349:
1350: ELSIF (p_county_name IS NULL AND p_state_abbrev IS NOT NULL) THEN
1351: Hr_Utility.Set_Location(c_proc, 30);
1352: OPEN csr_state_code;
1353: FETCH csr_state_code INTO l_state_code;
1354: CLOSE csr_state_code;
1355: l_geocode := l_state_code||'-000-0000';

Line 1362: Hr_Utility.Set_Location(c_proc, 25);

1358: FETCH csr_chk_state INTO l_valid_for_asg;
1359: CLOSE csr_chk_state;
1360:
1361: IF (l_valid_for_asg = 'FAIL') THEN
1362: Hr_Utility.Set_Location(c_proc, 25);
1363: Hr_Utility.Trace('The state is not valid for the assignment');
1364: Hr_Utility.Set_Message(801, 'PY_51133_TXADJ_INVALID_CITY');
1365: Hr_Utility.Raise_Error;
1366: END IF;

Line 1363: Hr_Utility.Trace('The state is not valid for the assignment');

1359: CLOSE csr_chk_state;
1360:
1361: IF (l_valid_for_asg = 'FAIL') THEN
1362: Hr_Utility.Set_Location(c_proc, 25);
1363: Hr_Utility.Trace('The state is not valid for the assignment');
1364: Hr_Utility.Set_Message(801, 'PY_51133_TXADJ_INVALID_CITY');
1365: Hr_Utility.Raise_Error;
1366: END IF;
1367:

Line 1364: Hr_Utility.Set_Message(801, 'PY_51133_TXADJ_INVALID_CITY');

1360:
1361: IF (l_valid_for_asg = 'FAIL') THEN
1362: Hr_Utility.Set_Location(c_proc, 25);
1363: Hr_Utility.Trace('The state is not valid for the assignment');
1364: Hr_Utility.Set_Message(801, 'PY_51133_TXADJ_INVALID_CITY');
1365: Hr_Utility.Raise_Error;
1366: END IF;
1367:
1368: ELSE

Line 1365: Hr_Utility.Raise_Error;

1361: IF (l_valid_for_asg = 'FAIL') THEN
1362: Hr_Utility.Set_Location(c_proc, 25);
1363: Hr_Utility.Trace('The state is not valid for the assignment');
1364: Hr_Utility.Set_Message(801, 'PY_51133_TXADJ_INVALID_CITY');
1365: Hr_Utility.Raise_Error;
1366: END IF;
1367:
1368: ELSE
1369: l_geocode := '00-000-0000';

Line 1373: Hr_Utility.Trace('|derived geocode>' || l_geocode || '<');

1369: l_geocode := '00-000-0000';
1370:
1371: END IF;
1372:
1373: Hr_Utility.Trace('|derived geocode>' || l_geocode || '<');
1374: Return (l_geocode);
1375:
1376: END derive_jd_geocode;
1377:

Line 1630: --Hr_Utility.Trace_on(NULL, 'RANJANA');

1626: l_sch_dist_jur VARCHAR2(10);
1627:
1628:
1629: BEGIN
1630: --Hr_Utility.Trace_on(NULL, 'RANJANA');
1631:
1632: -- copy parameters to local variables and set to 0 if null
1633: l_gross_amount := Nvl(p_gross_amount, 0);
1634: l_net_amount := Nvl(p_net_amount, 0);

Line 1652: Hr_Utility.Set_Location(c_proc, 5);

1648: l_sch_dist_wh_ee := Nvl(p_sch_dist_wh_ee, 0);
1649: l_sch_dist_jur := Nvl(p_sch_dist_jur, '');
1650:
1651: BEGIN
1652: Hr_Utility.Set_Location(c_proc, 5);
1653: SELECT a.assignment_id,
1654: a.business_group_id
1655: INTO l_assignment_id,
1656: l_bg_id

Line 1667: Hr_Utility.Set_Message(801, 'PY_51135_TXADJ_ASG_NOT_FOUND');

1663: a.effective_start_date AND a.effective_end_date
1664: ;
1665: EXCEPTION
1666: WHEN NO_DATA_FOUND OR too_many_rows THEN
1667: Hr_Utility.Set_Message(801, 'PY_51135_TXADJ_ASG_NOT_FOUND');
1668: Hr_Utility.Raise_Error;
1669: END;
1670:
1671:

Line 1668: Hr_Utility.Raise_Error;

1664: ;
1665: EXCEPTION
1666: WHEN NO_DATA_FOUND OR too_many_rows THEN
1667: Hr_Utility.Set_Message(801, 'PY_51135_TXADJ_ASG_NOT_FOUND');
1668: Hr_Utility.Raise_Error;
1669: END;
1670:
1671:
1672: l_jd_entered := derive_jd_geocode(p_assignment_id => l_assignment_id,

Line 1713: Hr_Utility.Set_Message(801, 'PY_51134_TXADJ_TAX_NET_TOT');

1709: l_sui_ee + l_sdi_ee + l_county + l_city +
1710: l_sch_dist_wh_ee;
1711:
1712: IF (l_gross_amount <> l_net_amount + l_total_taxes_withheld) THEN
1713: Hr_Utility.Set_Message(801, 'PY_51134_TXADJ_TAX_NET_TOT');
1714: Hr_Utility.Raise_Error;
1715: END IF;
1716:
1717: END IF;

Line 1714: Hr_Utility.Raise_Error;

1710: l_sch_dist_wh_ee;
1711:
1712: IF (l_gross_amount <> l_net_amount + l_total_taxes_withheld) THEN
1713: Hr_Utility.Set_Message(801, 'PY_51134_TXADJ_TAX_NET_TOT');
1714: Hr_Utility.Raise_Error;
1715: END IF;
1716:
1717: END IF;
1718:

Line 1723: Hr_Utility.Set_Message(801, 'PY_51140_TXADJ_EARN_ELE_REQ');

1719:
1720: -- 2. check that if an earnings element is provided if Gross is non-zero
1721:
1722: IF (l_gross_amount <> 0 AND p_earning_element_type IS NULL) THEN
1723: Hr_Utility.Set_Message(801, 'PY_51140_TXADJ_EARN_ELE_REQ');
1724: Hr_Utility.Raise_Error;
1725: END IF;
1726:
1727:

Line 1724: Hr_Utility.Raise_Error;

1720: -- 2. check that if an earnings element is provided if Gross is non-zero
1721:
1722: IF (l_gross_amount <> 0 AND p_earning_element_type IS NULL) THEN
1723: Hr_Utility.Set_Message(801, 'PY_51140_TXADJ_EARN_ELE_REQ');
1724: Hr_Utility.Raise_Error;
1725: END IF;
1726:
1727:
1728: -- 3. check that SIT = 0 for Alaska, Florida, Nevada, New Hampshire, South Dakota,

Line 1734: Hr_Utility.Set_Message(801, 'PY_51141_TXADJ_SIT_EXEMPT');

1730:
1731: IF ((l_sit <> 0 OR l_city <> 0 OR l_county <> 0) AND
1732: --p_state_abbrev IN ('AK', 'FL', 'NV', 'NH', 'SD', 'TN', 'TX', 'WA', 'WY', 'VI')) THEN
1733: (tax_exists(l_jd_entered, 'SIT', p_adjustment_date) = 'N')) THEN
1734: Hr_Utility.Set_Message(801, 'PY_51141_TXADJ_SIT_EXEMPT');
1735: Hr_Utility.Raise_Error;
1736: END IF;
1737:
1738: /* **** NOT USING JIT TABLES TO CHECK FOR CITY AND COUNTY TAXES YET **** */

Line 1735: Hr_Utility.Raise_Error;

1731: IF ((l_sit <> 0 OR l_city <> 0 OR l_county <> 0) AND
1732: --p_state_abbrev IN ('AK', 'FL', 'NV', 'NH', 'SD', 'TN', 'TX', 'WA', 'WY', 'VI')) THEN
1733: (tax_exists(l_jd_entered, 'SIT', p_adjustment_date) = 'N')) THEN
1734: Hr_Utility.Set_Message(801, 'PY_51141_TXADJ_SIT_EXEMPT');
1735: Hr_Utility.Raise_Error;
1736: END IF;
1737:
1738: /* **** NOT USING JIT TABLES TO CHECK FOR CITY AND COUNTY TAXES YET **** */
1739: /* Wait until the payroll run stops maintaining those balances, and users

Line 1746: Hr_Utility.Set_Message(801, 'PY_50980_TXADJ_COUNTY_EXEMPT');

1742: out corrupt balances. */
1743:
1744: IF ((l_county <> 0) AND
1745: (tax_exists(l_jd_entered, 'COUNTY', p_adjustment_date) = 'N')) THEN
1746: Hr_Utility.Set_Message(801, 'PY_50980_TXADJ_COUNTY_EXEMPT');
1747: Hr_Utility.Raise_Error;
1748: END IF;
1749:
1750: IF ((l_city <> 0) AND

Line 1747: Hr_Utility.Raise_Error;

1743:
1744: IF ((l_county <> 0) AND
1745: (tax_exists(l_jd_entered, 'COUNTY', p_adjustment_date) = 'N')) THEN
1746: Hr_Utility.Set_Message(801, 'PY_50980_TXADJ_COUNTY_EXEMPT');
1747: Hr_Utility.Raise_Error;
1748: END IF;
1749:
1750: IF ((l_city <> 0) AND
1751: (tax_exists(l_jd_entered, 'CITY', p_adjustment_date) = 'N')) THEN

Line 1752: Hr_Utility.Set_Message(801, 'PY_50981_TXADJ_CITY_EXEMPT');

1748: END IF;
1749:
1750: IF ((l_city <> 0) AND
1751: (tax_exists(l_jd_entered, 'CITY', p_adjustment_date) = 'N')) THEN
1752: Hr_Utility.Set_Message(801, 'PY_50981_TXADJ_CITY_EXEMPT');
1753: Hr_Utility.Raise_Error;
1754: END IF;
1755:
1756:

Line 1753: Hr_Utility.Raise_Error;

1749:
1750: IF ((l_city <> 0) AND
1751: (tax_exists(l_jd_entered, 'CITY', p_adjustment_date) = 'N')) THEN
1752: Hr_Utility.Set_Message(801, 'PY_50981_TXADJ_CITY_EXEMPT');
1753: Hr_Utility.Raise_Error;
1754: END IF;
1755:
1756:
1757: -- 4. check that SDI = 0 for all states but California, Hawaii, New Jersey, New York,

Line 1772: Hr_Utility.Set_Message(801, 'PY_51327_TXADJ_SDI_JD');

1768: FETCH csr_sdi_check INTO l_primary_asg_state;
1769: CLOSE csr_sdi_check;
1770:
1771: IF (l_primary_asg_state <> p_state_abbrev) THEN
1772: Hr_Utility.Set_Message(801, 'PY_51327_TXADJ_SDI_JD');
1773: Hr_Utility.Raise_Error;
1774: END IF;
1775:
1776: END IF;

Line 1773: Hr_Utility.Raise_Error;

1769: CLOSE csr_sdi_check;
1770:
1771: IF (l_primary_asg_state <> p_state_abbrev) THEN
1772: Hr_Utility.Set_Message(801, 'PY_51327_TXADJ_SDI_JD');
1773: Hr_Utility.Raise_Error;
1774: END IF;
1775:
1776: END IF;
1777:

Line 1781: Hr_Utility.Set_Message(801, 'PY_51142_TXADJ_SDI_EXEMPT');

1777:
1778: IF ( l_sdi_ee <> 0) THEN
1779: --IF (p_state_abbrev NOT IN ('CA', 'HI', 'NJ', 'NY', 'RI')) THEN
1780: IF (tax_exists(l_jd_entered, 'SDI_EE', p_adjustment_date) = 'N') THEN
1781: Hr_Utility.Set_Message(801, 'PY_51142_TXADJ_SDI_EXEMPT');
1782: Hr_Utility.Raise_Error;
1783: END IF;
1784:
1785: END IF;

Line 1782: Hr_Utility.Raise_Error;

1778: IF ( l_sdi_ee <> 0) THEN
1779: --IF (p_state_abbrev NOT IN ('CA', 'HI', 'NJ', 'NY', 'RI')) THEN
1780: IF (tax_exists(l_jd_entered, 'SDI_EE', p_adjustment_date) = 'N') THEN
1781: Hr_Utility.Set_Message(801, 'PY_51142_TXADJ_SDI_EXEMPT');
1782: Hr_Utility.Raise_Error;
1783: END IF;
1784:
1785: END IF;
1786:

Line 1790: Hr_Utility.Set_Message(801, 'PY_51142_TXADJ_SDI_EXEMPT');

1786:
1787: IF ( l_sdi_er <> 0) THEN
1788: --IF (p_state_abbrev NOT IN ('NJ', 'NY')) THEN
1789: IF (tax_exists(l_jd_entered, 'SDI_ER', p_adjustment_date) = 'N') THEN
1790: Hr_Utility.Set_Message(801, 'PY_51142_TXADJ_SDI_EXEMPT');
1791: Hr_Utility.Raise_Error;
1792: END IF;
1793:
1794: END IF;

Line 1791: Hr_Utility.Raise_Error;

1787: IF ( l_sdi_er <> 0) THEN
1788: --IF (p_state_abbrev NOT IN ('NJ', 'NY')) THEN
1789: IF (tax_exists(l_jd_entered, 'SDI_ER', p_adjustment_date) = 'N') THEN
1790: Hr_Utility.Set_Message(801, 'PY_51142_TXADJ_SDI_EXEMPT');
1791: Hr_Utility.Raise_Error;
1792: END IF;
1793:
1794: END IF;
1795:

Line 1817: Hr_Utility.Set_Message(801, 'PY_51328_TXADJ_SUI_EXEMPT');

1813: --IF (p_state_abbrev NOT IN ('AK', 'NJ')) OR
1814:
1815: IF (tax_exists(l_jd_entered, 'SUI_EE', p_adjustment_date) = 'N') OR
1816: (g_sui_state_code <> p_state_abbrev) THEN
1817: Hr_Utility.Set_Message(801, 'PY_51328_TXADJ_SUI_EXEMPT');
1818: Hr_Utility.Raise_Error;
1819: END IF;
1820:
1821: END IF;

Line 1818: Hr_Utility.Raise_Error;

1814:
1815: IF (tax_exists(l_jd_entered, 'SUI_EE', p_adjustment_date) = 'N') OR
1816: (g_sui_state_code <> p_state_abbrev) THEN
1817: Hr_Utility.Set_Message(801, 'PY_51328_TXADJ_SUI_EXEMPT');
1818: Hr_Utility.Raise_Error;
1819: END IF;
1820:
1821: END IF;
1822:

Line 1827: Hr_Utility.Set_Location(c_proc, 5);

1823:
1824: -- determine system keys
1825: /*
1826: BEGIN
1827: Hr_Utility.Set_Location(c_proc, 5);
1828: SELECT a.assignment_id,
1829: a.business_group_id
1830: INTO l_assignment_id,
1831: l_bg_id

Line 1842: Hr_Utility.Set_Message(801, 'PY_51135_TXADJ_ASG_NOT_FOUND');

1838: a.effective_start_date AND a.effective_end_date
1839: ;
1840: EXCEPTION
1841: WHEN NO_DATA_FOUND OR too_many_rows THEN
1842: Hr_Utility.Set_Message(801, 'PY_51135_TXADJ_ASG_NOT_FOUND');
1843: Hr_Utility.Raise_Error;
1844: END;
1845: */
1846:

Line 1843: Hr_Utility.Raise_Error;

1839: ;
1840: EXCEPTION
1841: WHEN NO_DATA_FOUND OR too_many_rows THEN
1842: Hr_Utility.Set_Message(801, 'PY_51135_TXADJ_ASG_NOT_FOUND');
1843: Hr_Utility.Raise_Error;
1844: END;
1845: */
1846:
1847: Hr_Utility.Trace('|');

Line 1847: Hr_Utility.Trace('|');

1843: Hr_Utility.Raise_Error;
1844: END;
1845: */
1846:
1847: Hr_Utility.Trace('|');
1848: private_trace(c_proc, 'taxable balances before any BAs');
1849:
1850: BEGIN
1851: Hr_Utility.Set_Location(c_proc, 10);

Line 1851: Hr_Utility.Set_Location(c_proc, 10);

1847: Hr_Utility.Trace('|');
1848: private_trace(c_proc, 'taxable balances before any BAs');
1849:
1850: BEGIN
1851: Hr_Utility.Set_Location(c_proc, 10);
1852: SELECT consolidation_set_id
1853: INTO l_consolidation_set_id
1854: FROM PAY_CONSOLIDATION_SETS
1855: WHERE consolidation_set_name = p_consolidation_set

Line 1860: Hr_Utility.Set_Message(801, 'PY_51136_TXADJ_CONSET_NOT_FND');

1856: and business_group_id = l_bg_id
1857: ;
1858: EXCEPTION
1859: WHEN NO_DATA_FOUND OR too_many_rows THEN
1860: Hr_Utility.Set_Message(801, 'PY_51136_TXADJ_CONSET_NOT_FND');
1861: Hr_Utility.Raise_Error;
1862: END;
1863:
1864: l_jd_entered := derive_jd_geocode(p_assignment_id => l_assignment_id,

Line 1861: Hr_Utility.Raise_Error;

1857: ;
1858: EXCEPTION
1859: WHEN NO_DATA_FOUND OR too_many_rows THEN
1860: Hr_Utility.Set_Message(801, 'PY_51136_TXADJ_CONSET_NOT_FND');
1861: Hr_Utility.Raise_Error;
1862: END;
1863:
1864: l_jd_entered := derive_jd_geocode(p_assignment_id => l_assignment_id,
1865: p_state_abbrev => p_state_abbrev,

Line 1925: Hr_Utility.Set_Location(c_proc, 15);

1921: -- more error checking
1922:
1923: -- check the level of l_jd_entered to see if all taxes entered
1924: -- are applicable for the jurisdiction entered
1925: Hr_Utility.Set_Location(c_proc, 15);
1926:
1927: IF (l_city <> 0 ) THEN -- jd level needed is for a city
1928: l_jd_level_needed := 4;
1929:

Line 1959: Hr_Utility.Set_Location(c_proc, 20);

1955:
1956:
1957: -- now compare the level of jd entered against the level required
1958: IF (l_jd_level_needed > l_jd_level_entered) THEN
1959: Hr_Utility.Set_Location(c_proc, 20);
1960: Hr_Utility.Trace('Jursidiction entered is insufficient for all taxes');
1961: Hr_Utility.Set_Message(801, 'PY_50015_TXADJ_JD_INSUFF');
1962: Hr_Utility.Raise_Error;
1963: END IF;

Line 1960: Hr_Utility.Trace('Jursidiction entered is insufficient for all taxes');

1956:
1957: -- now compare the level of jd entered against the level required
1958: IF (l_jd_level_needed > l_jd_level_entered) THEN
1959: Hr_Utility.Set_Location(c_proc, 20);
1960: Hr_Utility.Trace('Jursidiction entered is insufficient for all taxes');
1961: Hr_Utility.Set_Message(801, 'PY_50015_TXADJ_JD_INSUFF');
1962: Hr_Utility.Raise_Error;
1963: END IF;
1964:

Line 1961: Hr_Utility.Set_Message(801, 'PY_50015_TXADJ_JD_INSUFF');

1957: -- now compare the level of jd entered against the level required
1958: IF (l_jd_level_needed > l_jd_level_entered) THEN
1959: Hr_Utility.Set_Location(c_proc, 20);
1960: Hr_Utility.Trace('Jursidiction entered is insufficient for all taxes');
1961: Hr_Utility.Set_Message(801, 'PY_50015_TXADJ_JD_INSUFF');
1962: Hr_Utility.Raise_Error;
1963: END IF;
1964:
1965:

Line 1962: Hr_Utility.Raise_Error;

1958: IF (l_jd_level_needed > l_jd_level_entered) THEN
1959: Hr_Utility.Set_Location(c_proc, 20);
1960: Hr_Utility.Trace('Jursidiction entered is insufficient for all taxes');
1961: Hr_Utility.Set_Message(801, 'PY_50015_TXADJ_JD_INSUFF');
1962: Hr_Utility.Raise_Error;
1963: END IF;
1964:
1965:
1966: -- main processing

Line 1967: Hr_Utility.Set_Location(c_proc, 30);

1963: END IF;
1964:
1965:
1966: -- main processing
1967: Hr_Utility.Set_Location(c_proc, 30);
1968:
1969: IF (l_gross_amount <> 0) THEN
1970: process_element(p_assignment_id => l_assignment_id,
1971: p_consolidation_set_id => l_consolidation_set_id,

Line 2385: Hr_Utility.Set_Location (c_proc, 100);

2381: -- finally, group the payroll_actions by concatenating the tax type with
2382: -- the payroll_action
2383: g_pact_cntr := g_pact_cntr - 1;
2384:
2385: Hr_Utility.Set_Location (c_proc, 100);
2386:
2387: FOR l_counter in 1..g_pact_cntr LOOP
2388:
2389: /* l_grp_key := l_grp_key || g_tax_type_tbl(l_counter) ||

Line 2401: Hr_Utility.Set_Location (c_proc, 120);

2397: WHERE payroll_action_id = g_tax_adj_pactid_tbl(l_counter);
2398:
2399: END LOOP;
2400:
2401: Hr_Utility.Set_Location (c_proc, 120);
2402:
2403: /* FOR l_counter IN 1..g_pact_cntr LOOP
2404:
2405: UPDATE pay_payroll_actions