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

Line 310: hr_utility.trace('Entering check_emp_personal_payment');

306: ln_time_period_id NUMBER;
307:
308: BEGIN
309:
310: hr_utility.trace('Entering check_emp_personal_payment');
311: hr_utility.trace('p_effective_date='||p_effective_date);
312: hr_utility.trace('p_time_period_id='||p_time_period_id);
313:
314: IF p_payment_category IS NOT NULL THEN

Line 311: hr_utility.trace('p_effective_date='||p_effective_date);

307:
308: BEGIN
309:
310: hr_utility.trace('Entering check_emp_personal_payment');
311: hr_utility.trace('p_effective_date='||p_effective_date);
312: hr_utility.trace('p_time_period_id='||p_time_period_id);
313:
314: IF p_payment_category IS NOT NULL THEN
315:

Line 312: hr_utility.trace('p_time_period_id='||p_time_period_id);

308: BEGIN
309:
310: hr_utility.trace('Entering check_emp_personal_payment');
311: hr_utility.trace('p_effective_date='||p_effective_date);
312: hr_utility.trace('p_time_period_id='||p_time_period_id);
313:
314: IF p_payment_category IS NOT NULL THEN
315:
316: lv_return_flag := 'Y';

Line 341: hr_utility.trace('ln_time_period_id='||ln_time_period_id);

337: end if;
338: close c_get_date_earned;
339: end if;
340:
341: hr_utility.trace('ln_time_period_id='||ln_time_period_id);
342: open c_view_offset(ln_time_period_id);
343: fetch c_view_offset into ld_view_payslip_offset_date;
344: close c_view_offset;
345: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));

Line 345: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));

341: hr_utility.trace('ln_time_period_id='||ln_time_period_id);
342: open c_view_offset(ln_time_period_id);
343: fetch c_view_offset into ld_view_payslip_offset_date;
344: close c_view_offset;
345: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));
346: hr_utility.trace('p_effective_date='||trunc(p_effective_date));
347: hr_utility.trace('sysdate='||trunc(sysdate));
348:
349: /* check if the Payslip view date is populated. If it is, check the value

Line 346: hr_utility.trace('p_effective_date='||trunc(p_effective_date));

342: open c_view_offset(ln_time_period_id);
343: fetch c_view_offset into ld_view_payslip_offset_date;
344: close c_view_offset;
345: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));
346: hr_utility.trace('p_effective_date='||trunc(p_effective_date));
347: hr_utility.trace('sysdate='||trunc(sysdate));
348:
349: /* check if the Payslip view date is populated. If it is, check the value
350: and make sure it is > sysdate otherwise don't show payslip */

Line 347: hr_utility.trace('sysdate='||trunc(sysdate));

343: fetch c_view_offset into ld_view_payslip_offset_date;
344: close c_view_offset;
345: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));
346: hr_utility.trace('p_effective_date='||trunc(p_effective_date));
347: hr_utility.trace('sysdate='||trunc(sysdate));
348:
349: /* check if the Payslip view date is populated. If it is, check the value
350: and make sure it is > sysdate otherwise don't show payslip */
351: if ld_view_payslip_offset_date is not null and

Line 353: hr_utility.trace('View offset return N');

349: /* check if the Payslip view date is populated. If it is, check the value
350: and make sure it is > sysdate otherwise don't show payslip */
351: if ld_view_payslip_offset_date is not null and
352: trunc(ld_view_payslip_offset_date) > trunc(sysdate) then
353: hr_utility.trace('View offset return N');
354: return('N');
355: end if;
356:
357: open c_check_for_reversal(ln_prepay_action_id);

Line 404: hr_utility.trace('lv_return_flag='||lv_return_flag);

400: END IF;
401: CLOSE c_no_prepayments;
402: END IF;
403:
404: hr_utility.trace('lv_return_flag='||lv_return_flag);
405: hr_utility.trace('Leaving check_emp_personal_payment');
406:
407: return lv_return_flag;
408: ELSE

Line 405: hr_utility.trace('Leaving check_emp_personal_payment');

401: CLOSE c_no_prepayments;
402: END IF;
403:
404: hr_utility.trace('lv_return_flag='||lv_return_flag);
405: hr_utility.trace('Leaving check_emp_personal_payment');
406:
407: return lv_return_flag;
408: ELSE
409: return(check_emp_personal_payment(

Line 583: hr_utility.trace('Entering check_emp_personal_payment');

579: ln_time_period_id NUMBER;
580:
581: BEGIN
582:
583: hr_utility.trace('Entering check_emp_personal_payment');
584: hr_utility.trace('p_effective_date='||p_effective_date);
585: hr_utility.trace('p_time_period_id='||p_time_period_id);
586:
587: lv_return_flag := 'Y';

Line 584: hr_utility.trace('p_effective_date='||p_effective_date);

580:
581: BEGIN
582:
583: hr_utility.trace('Entering check_emp_personal_payment');
584: hr_utility.trace('p_effective_date='||p_effective_date);
585: hr_utility.trace('p_time_period_id='||p_time_period_id);
586:
587: lv_return_flag := 'Y';
588: open c_prepay_arch_action(p_assignment_action_id);

Line 585: hr_utility.trace('p_time_period_id='||p_time_period_id);

581: BEGIN
582:
583: hr_utility.trace('Entering check_emp_personal_payment');
584: hr_utility.trace('p_effective_date='||p_effective_date);
585: hr_utility.trace('p_time_period_id='||p_time_period_id);
586:
587: lv_return_flag := 'Y';
588: open c_prepay_arch_action(p_assignment_action_id);
589: fetch c_prepay_arch_action into ln_prepay_action_id;

Line 612: hr_utility.trace('ln_time_period_id='||ln_time_period_id);

608: end if;
609: close c_get_date_earned;
610: end if;
611:
612: hr_utility.trace('ln_time_period_id='||ln_time_period_id);
613: open c_view_offset(ln_time_period_id);
614: fetch c_view_offset into ld_view_payslip_offset_date;
615: close c_view_offset;
616: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));

Line 616: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));

612: hr_utility.trace('ln_time_period_id='||ln_time_period_id);
613: open c_view_offset(ln_time_period_id);
614: fetch c_view_offset into ld_view_payslip_offset_date;
615: close c_view_offset;
616: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));
617: hr_utility.trace('p_effective_date='||trunc(p_effective_date));
618: hr_utility.trace('sysdate='||trunc(sysdate));
619:
620: /* check if the Payslip view date is populated. If it is, check the value

Line 617: hr_utility.trace('p_effective_date='||trunc(p_effective_date));

613: open c_view_offset(ln_time_period_id);
614: fetch c_view_offset into ld_view_payslip_offset_date;
615: close c_view_offset;
616: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));
617: hr_utility.trace('p_effective_date='||trunc(p_effective_date));
618: hr_utility.trace('sysdate='||trunc(sysdate));
619:
620: /* check if the Payslip view date is populated. If it is, check the value
621: and make sure it is > sysdate otherwise don't show payslip */

Line 618: hr_utility.trace('sysdate='||trunc(sysdate));

614: fetch c_view_offset into ld_view_payslip_offset_date;
615: close c_view_offset;
616: hr_utility.trace('ld_view_payslip_offset_date='||trunc(ld_view_payslip_offset_date));
617: hr_utility.trace('p_effective_date='||trunc(p_effective_date));
618: hr_utility.trace('sysdate='||trunc(sysdate));
619:
620: /* check if the Payslip view date is populated. If it is, check the value
621: and make sure it is > sysdate otherwise don't show payslip */
622: if ld_view_payslip_offset_date is not null and

Line 624: hr_utility.trace('View offset return N');

620: /* check if the Payslip view date is populated. If it is, check the value
621: and make sure it is > sysdate otherwise don't show payslip */
622: if ld_view_payslip_offset_date is not null and
623: trunc(ld_view_payslip_offset_date) > trunc(sysdate) then
624: hr_utility.trace('View offset return N');
625: return('N');
626: end if;
627: --bug 6840881 starts here
628: open get_sprt_pymnt_dtls(p_assignment_action_id);

Line 632: hr_utility.trace('lv_action_chkng_rvrsl Y'||lv_action_chkng_rvrsl);

628: open get_sprt_pymnt_dtls(p_assignment_action_id);
629: fetch get_sprt_pymnt_dtls into lv_sprt_pymnt_actn_id,lv_sprt_pymnt_flag;
630: if(lv_sprt_pymnt_flag= 'Y') then
631: lv_action_chkng_rvrsl:=lv_sprt_pymnt_actn_id;
632: hr_utility.trace('lv_action_chkng_rvrsl Y'||lv_action_chkng_rvrsl);
633: else
634: open get_regular_action(lv_sprt_pymnt_actn_id,p_assignment_action_id);
635: fetch get_regular_action into lv_action_chkng_rvrsl;
636: hr_utility.trace('lv_action_chkng_rvrsl NY'||lv_action_chkng_rvrsl);

Line 636: hr_utility.trace('lv_action_chkng_rvrsl NY'||lv_action_chkng_rvrsl);

632: hr_utility.trace('lv_action_chkng_rvrsl Y'||lv_action_chkng_rvrsl);
633: else
634: open get_regular_action(lv_sprt_pymnt_actn_id,p_assignment_action_id);
635: fetch get_regular_action into lv_action_chkng_rvrsl;
636: hr_utility.trace('lv_action_chkng_rvrsl NY'||lv_action_chkng_rvrsl);
637: close get_regular_action;
638: end if;
639: hr_utility.trace('lv_action_chkng_rvrsl' ||lv_action_chkng_rvrsl);
640: close get_sprt_pymnt_dtls;

Line 639: hr_utility.trace('lv_action_chkng_rvrsl' ||lv_action_chkng_rvrsl);

635: fetch get_regular_action into lv_action_chkng_rvrsl;
636: hr_utility.trace('lv_action_chkng_rvrsl NY'||lv_action_chkng_rvrsl);
637: close get_regular_action;
638: end if;
639: hr_utility.trace('lv_action_chkng_rvrsl' ||lv_action_chkng_rvrsl);
640: close get_sprt_pymnt_dtls;
641: -- open c_check_for_reversal(ln_prepay_action_id);
642: open c_check_for_reversal(lv_action_chkng_rvrsl);
643: --bug 6840881 ends here

Line 676: hr_utility.trace('lv_return_flag='||lv_return_flag);

672:
673: end if;
674: close c_check_for_reversal;
675:
676: hr_utility.trace('lv_return_flag='||lv_return_flag);
677: hr_utility.trace('Leaving check_emp_personal_payment');
678:
679: return lv_return_flag;
680:

Line 677: hr_utility.trace('Leaving check_emp_personal_payment');

673: end if;
674: close c_check_for_reversal;
675:
676: hr_utility.trace('lv_return_flag='||lv_return_flag);
677: hr_utility.trace('Leaving check_emp_personal_payment');
678:
679: return lv_return_flag;
680:
681: END check_emp_personal_payment;

Line 732: hr_utility.trace('Entering check_emp_personal_payment without time period');

728: ln_time_period_id NUMBER;
729:
730: BEGIN
731:
732: hr_utility.trace('Entering check_emp_personal_payment without time period');
733: open c_get_date_earned(p_assignment_action_id);
734: fetch c_get_date_earned into ld_earned_date;
735: if c_get_date_earned%found then
736: open c_time_period(p_payroll_id, ld_earned_date);

Line 742: hr_utility.trace('ln_time_period_id='||ln_time_period_id);

738: close c_time_period;
739: end if;
740: close c_get_date_earned;
741:
742: hr_utility.trace('ln_time_period_id='||ln_time_period_id);
743: return(check_emp_personal_payment(
744: p_assignment_id => p_assignment_id
745: ,p_payroll_id => p_payroll_id
746: ,p_time_period_id => ln_time_period_id

Line 1317: hr_utility.set_location(l_mesg,5);

1313: l_bg_cache varchar2(10);
1314:
1315: BEGIN
1316: l_mesg := 'pay_us_employee_payslip_web.get_doc_eit';
1317: hr_utility.set_location(l_mesg,5);
1318: l_location_cache := 'NOT FOUND';
1319: l_org_cache := 'NOT FOUND';
1320: l_bg_cache := 'NOT FOUND';
1321: l_rowCount := pay_us_employee_payslip_web.eit_tab.count;

Line 1324: hr_utility.set_location(l_mesg, 10);

1320: l_bg_cache := 'NOT FOUND';
1321: l_rowCount := pay_us_employee_payslip_web.eit_tab.count;
1322:
1323: IF upper(p_level) = 'ASSIGNMENT' THEN
1324: hr_utility.set_location(l_mesg, 10);
1325: OPEN get_person_info(p_id);
1326: FETCH get_person_info INTO l_bg_id, l_org_id, l_loc_id, l_person_id;
1327: CLOSE get_person_info;
1328:

Line 1382: hr_utility.set_location(l_mesg,20);

1378:
1379: END IF; /* p_level = assignment */
1380:
1381: IF upper(p_level) = 'PERSON' THEN
1382: hr_utility.set_location(l_mesg,20);
1383: OPEN get_person_eit(p_id);
1384: FETCH get_person_eit INTO l_online, l_print;
1385:
1386: IF get_person_eit%FOUND THEN

Line 1401: hr_utility.set_location(l_mesg,30);

1397: RETURN l_value;
1398: END IF;
1399:
1400: IF upper(p_level) = 'LOCATION' THEN
1401: hr_utility.set_location(l_mesg,30);
1402: hr_utility.trace('Before LOOP l_location_cache = '||l_location_cache);
1403: IF (l_rowCount > 0) THEN
1404: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
1405: pay_us_employee_payslip_web.eit_tab.last

Line 1402: hr_utility.trace('Before LOOP l_location_cache = '||l_location_cache);

1398: END IF;
1399:
1400: IF upper(p_level) = 'LOCATION' THEN
1401: hr_utility.set_location(l_mesg,30);
1402: hr_utility.trace('Before LOOP l_location_cache = '||l_location_cache);
1403: IF (l_rowCount > 0) THEN
1404: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
1405: pay_us_employee_payslip_web.eit_tab.last
1406: LOOP

Line 1420: hr_utility.trace('AFter LOOP l_location_cache = '||l_location_cache);

1416: END IF;
1417: END IF;
1418: END LOOP;
1419: END IF; -- l_rowCount > 0
1420: hr_utility.trace('AFter LOOP l_location_cache = '||l_location_cache);
1421:
1422: IF l_location_cache = 'NOT FOUND' THEN
1423: hr_utility.set_location(l_mesg,40);
1424: ---- Location Level is not cached so find it ----

Line 1423: hr_utility.set_location(l_mesg,40);

1419: END IF; -- l_rowCount > 0
1420: hr_utility.trace('AFter LOOP l_location_cache = '||l_location_cache);
1421:
1422: IF l_location_cache = 'NOT FOUND' THEN
1423: hr_utility.set_location(l_mesg,40);
1424: ---- Location Level is not cached so find it ----
1425:
1426: OPEN get_loc_eit(p_id);
1427: FETCH get_loc_eit INTO l_online, l_print;

Line 1428: hr_utility.trace('l_online = '||l_online);

1424: ---- Location Level is not cached so find it ----
1425:
1426: OPEN get_loc_eit(p_id);
1427: FETCH get_loc_eit INTO l_online, l_print;
1428: hr_utility.trace('l_online = '||l_online);
1429: hr_utility.trace('l_print = '||l_print);
1430: l_count := pay_us_employee_payslip_web.eit_tab.count + 1 ;
1431: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
1432: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Location';

Line 1429: hr_utility.trace('l_print = '||l_print);

1425:
1426: OPEN get_loc_eit(p_id);
1427: FETCH get_loc_eit INTO l_online, l_print;
1428: hr_utility.trace('l_online = '||l_online);
1429: hr_utility.trace('l_print = '||l_print);
1430: l_count := pay_us_employee_payslip_web.eit_tab.count + 1 ;
1431: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;
1432: pay_us_employee_payslip_web.eit_tab(l_count).t_level := 'Location';
1433:

Line 1442: hr_utility.trace('eit_tab(l_count).t_online = '||

1438: pay_us_employee_payslip_web.eit_tab(l_count).t_online := 'Y';
1439: pay_us_employee_payslip_web.eit_tab(l_count).t_print := 'Y';
1440: END IF;
1441:
1442: hr_utility.trace('eit_tab(l_count).t_online = '||
1443: pay_us_employee_payslip_web.eit_tab(l_count).t_online);
1444: hr_utility.trace('eit_tab(l_count).t_print = '||
1445: pay_us_employee_payslip_web.eit_tab(l_count).t_print);
1446: IF p_mode = 'ONLINE' THEN

Line 1444: hr_utility.trace('eit_tab(l_count).t_print = '||

1440: END IF;
1441:
1442: hr_utility.trace('eit_tab(l_count).t_online = '||
1443: pay_us_employee_payslip_web.eit_tab(l_count).t_online);
1444: hr_utility.trace('eit_tab(l_count).t_print = '||
1445: pay_us_employee_payslip_web.eit_tab(l_count).t_print);
1446: IF p_mode = 'ONLINE' THEN
1447: l_value := pay_us_employee_payslip_web.eit_tab(l_count).t_online;
1448: ELSIF p_mode = 'PRINT' THEN

Line 1457: hr_utility.set_location(l_mesg,50);

1453: return l_value;
1454: END IF; -- if p_level = Location
1455:
1456: IF upper(p_level) = 'ORGANIZATION' THEN
1457: hr_utility.set_location(l_mesg,50);
1458: IF (l_rowCount > 0) THEN
1459: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
1460: pay_us_employee_payslip_web.eit_tab.last
1461: LOOP

Line 1478: hr_utility.trace('Org cache NOT FOUND');

1474:
1475: ---- Organization Level is not cached so find it ----
1476:
1477: IF l_org_cache = 'NOT FOUND' THEN
1478: hr_utility.trace('Org cache NOT FOUND');
1479: hr_utility.set_location(l_mesg,60);
1480: OPEN get_org_eit(p_id);
1481: FETCH get_org_eit INTO l_online, l_print;
1482: l_count := pay_us_employee_payslip_web.eit_tab.count + 1 ;

Line 1479: hr_utility.set_location(l_mesg,60);

1475: ---- Organization Level is not cached so find it ----
1476:
1477: IF l_org_cache = 'NOT FOUND' THEN
1478: hr_utility.trace('Org cache NOT FOUND');
1479: hr_utility.set_location(l_mesg,60);
1480: OPEN get_org_eit(p_id);
1481: FETCH get_org_eit INTO l_online, l_print;
1482: l_count := pay_us_employee_payslip_web.eit_tab.count + 1 ;
1483: pay_us_employee_payslip_web.eit_tab(l_count).t_id := p_id;

Line 1507: hr_utility.set_location(l_mesg,70);

1503:
1504: --- So look for Cached Business Group EIT ---
1505:
1506: IF upper(p_level) = 'BUSINESS GROUP' THEN
1507: hr_utility.set_location(l_mesg,70);
1508: IF (l_rowCount > 0) THEN
1509: FOR i in pay_us_employee_payslip_web.eit_tab.first ..
1510: pay_us_employee_payslip_web.eit_tab.last LOOP
1511: IF (pay_us_employee_payslip_web.eit_tab(i).t_id = p_id AND

Line 1527: hr_utility.set_location(l_mesg,80);

1523:
1524: --- business Group Level EIT not cached ----
1525:
1526: IF l_bg_cache = 'NOT FOUND' THEN
1527: hr_utility.set_location(l_mesg,80);
1528:
1529: OPEN get_bg_eit(p_id);
1530: FETCH get_bg_eit INTO l_online, l_print;
1531: l_count := pay_us_employee_payslip_web.eit_tab.count + 1;

Line 1613: hr_utility.set_location(gv_package || lv_procedure_name, 10);

1609: lv_state_code := substr(p_jurisdiction_code,1,2);
1610: lv_county_code := substr(p_jurisdiction_code,4,3);
1611: lv_city_code := substr(p_jurisdiction_code,8,4);
1612: lv_jurisdiction_name := null;
1613: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1614:
1615: if p_jurisdiction_code like '__-000-0000' then
1616: open c_get_state(lv_state_code);
1617: fetch c_get_state into lv_jurisdiction_name;

Line 1636: hr_utility.set_location(gv_package || lv_procedure_name, 30);

1632: lv_jurisdiction_name
1633: := pay_us_employee_payslip_web.get_school_dsts_name(p_jurisdiction_code);
1634: end if;
1635:
1636: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1637: return (lv_jurisdiction_name);
1638: END get_jurisdiction_name;
1639:
1640:

Line 1828: hr_utility.set_location(gv_package || lv_procedure_name, 10);

1824: lv_county_code := substr(p_jurisdiction_code,4,3);
1825: lv_city_code := substr(p_jurisdiction_code,8,4);
1826: lv_jurisdiction_name := null;
1827:
1828: hr_utility.set_location(gv_package || lv_procedure_name, 10);
1829: if p_jurisdiction_code like '__-000-0000' then
1830: lv_jurisdiction_name := pay_us_employee_payslip_web.get_jurisdiction_name
1831: (lv_state_code || '-000-0000');
1832:

Line 1850: hr_utility.set_location('p_jurisdiction_code -> '||p_jurisdiction_code, 30);

1846: (lv_state_code || '-' || lv_county_code || '-0000');
1847: lv_city_name := pay_us_employee_payslip_web.get_jurisdiction_name
1848: (p_jurisdiction_code);
1849:
1850: hr_utility.set_location('p_jurisdiction_code -> '||p_jurisdiction_code, 30);
1851: hr_utility.set_location('lv_state_abbrev -> '|| lv_state_abbrev, 30);
1852: hr_utility.set_location('lv_county_name -> '|| lv_county_name, 30);
1853: hr_utility.set_location('lv_city_name -> '|| lv_city_name, 30);
1854:

Line 1851: hr_utility.set_location('lv_state_abbrev -> '|| lv_state_abbrev, 30);

1847: lv_city_name := pay_us_employee_payslip_web.get_jurisdiction_name
1848: (p_jurisdiction_code);
1849:
1850: hr_utility.set_location('p_jurisdiction_code -> '||p_jurisdiction_code, 30);
1851: hr_utility.set_location('lv_state_abbrev -> '|| lv_state_abbrev, 30);
1852: hr_utility.set_location('lv_county_name -> '|| lv_county_name, 30);
1853: hr_utility.set_location('lv_city_name -> '|| lv_city_name, 30);
1854:
1855: lv_jurisdiction_name := lv_state_abbrev ||', '||

Line 1852: hr_utility.set_location('lv_county_name -> '|| lv_county_name, 30);

1848: (p_jurisdiction_code);
1849:
1850: hr_utility.set_location('p_jurisdiction_code -> '||p_jurisdiction_code, 30);
1851: hr_utility.set_location('lv_state_abbrev -> '|| lv_state_abbrev, 30);
1852: hr_utility.set_location('lv_county_name -> '|| lv_county_name, 30);
1853: hr_utility.set_location('lv_city_name -> '|| lv_city_name, 30);
1854:
1855: lv_jurisdiction_name := lv_state_abbrev ||', '||
1856: lv_county_name ||', '||

Line 1853: hr_utility.set_location('lv_city_name -> '|| lv_city_name, 30);

1849:
1850: hr_utility.set_location('p_jurisdiction_code -> '||p_jurisdiction_code, 30);
1851: hr_utility.set_location('lv_state_abbrev -> '|| lv_state_abbrev, 30);
1852: hr_utility.set_location('lv_county_name -> '|| lv_county_name, 30);
1853: hr_utility.set_location('lv_city_name -> '|| lv_city_name, 30);
1854:
1855: lv_jurisdiction_name := lv_state_abbrev ||', '||
1856: lv_county_name ||', '||
1857: lv_city_name;

Line 1867: hr_utility.set_location(gv_package || lv_procedure_name, 30);

1863: lv_jurisdiction_name := lv_state_abbrev || ', ' ||
1864: lv_school_dst;
1865:
1866: end if;
1867: hr_utility.set_location(gv_package || lv_procedure_name, 30);
1868: return (lv_jurisdiction_name);
1869: END get_full_jurisdiction_name;
1870:
1871: -- This Function will be called from View Definition of

Line 1901: hr_utility.trace('Entering into pay_us_employee_payslip_web.get_netpaydistr_segment');

1897: lv_legislation_code VARCHAR2(100);
1898: lv_exists VARCHAR2(10);
1899:
1900: BEGIN
1901: hr_utility.trace('Entering into pay_us_employee_payslip_web.get_netpaydistr_segment');
1902: hr_utility.trace('p_business_grp_id := ' || p_business_grp_id);
1903: hr_utility.trace('p_org_pay_meth_id := ' || p_org_pay_meth_id);
1904:
1905: open cur_legislation(p_business_grp_id);

Line 1902: hr_utility.trace('p_business_grp_id := ' || p_business_grp_id);

1898: lv_exists VARCHAR2(10);
1899:
1900: BEGIN
1901: hr_utility.trace('Entering into pay_us_employee_payslip_web.get_netpaydistr_segment');
1902: hr_utility.trace('p_business_grp_id := ' || p_business_grp_id);
1903: hr_utility.trace('p_org_pay_meth_id := ' || p_org_pay_meth_id);
1904:
1905: open cur_legislation(p_business_grp_id);
1906: fetch cur_legislation into lv_legislation_code;

Line 1903: hr_utility.trace('p_org_pay_meth_id := ' || p_org_pay_meth_id);

1899:
1900: BEGIN
1901: hr_utility.trace('Entering into pay_us_employee_payslip_web.get_netpaydistr_segment');
1902: hr_utility.trace('p_business_grp_id := ' || p_business_grp_id);
1903: hr_utility.trace('p_org_pay_meth_id := ' || p_org_pay_meth_id);
1904:
1905: open cur_legislation(p_business_grp_id);
1906: fetch cur_legislation into lv_legislation_code;
1907: close cur_legislation;

Line 1909: hr_utility.trace('lv_legislation_code := ' || lv_legislation_code);

1905: open cur_legislation(p_business_grp_id);
1906: fetch cur_legislation into lv_legislation_code;
1907: close cur_legislation;
1908:
1909: hr_utility.trace('lv_legislation_code := ' || lv_legislation_code);
1910:
1911: -- Legislation Check Should not be needed here and Added for Safer Side
1912: -- Can be removed if it can be confirmed that for All Localizations
1913: -- Payment category is 'CH' for Check / Cheque

Line 1922: hr_utility.trace('lv_exists := ' || lv_exists);

1918: ,p_org_pay_meth_id);
1919: FETCH cur_payment_typ INTO lv_exists;
1920: CLOSE cur_payment_typ;
1921:
1922: hr_utility.trace('lv_exists := ' || lv_exists);
1923:
1924: IF lv_exists = '1' THEN
1925: RETURN 'TRUE';
1926: ELSE

Line 1939: -- hr_utility.trace_on(null, 'PAYSLIP');

1935:
1936:
1937: BEGIN
1938: gv_package := 'pay_us_employee_payslip_web';
1939: -- hr_utility.trace_on(null, 'PAYSLIP');
1940: END pay_us_employee_payslip_web;