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

Line 28: g_debug := hr_utility.debug_enabled;

24: l_procedure VARCHAR2(100);
25: l_message VARCHAR2(250);
26: BEGIN
27: l_procedure := g_package||'get_financial_year_start';
28: g_debug := hr_utility.debug_enabled;
29: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
30:
31: if to_number(to_char(p_date,'MM')) >=4 then
32: l_year := to_char(p_date,'YYYY');

Line 58: g_debug := hr_utility.debug_enabled;

54: l_procedure VARCHAR2(100);
55: l_message VARCHAR2(250);
56: BEGIN
57: l_procedure := g_package||'get_financial_year_end';
58: g_debug := hr_utility.debug_enabled;
59: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
60:
61: if to_number(to_char(p_date,'MM')) <=3 then
62: l_year := to_char(p_date,'YYYY');

Line 104: g_debug := hr_utility.debug_enabled;

100: l_status VARCHAR(2);
101: l_procedure VARCHAR2(250);
102: l_message VARCHAR2(250);
103: BEGIN
104: g_debug := hr_utility.debug_enabled;
105: l_procedure := g_package ||'get_metro_status';
106: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
107:
108: IF (g_debug)

Line 165: g_debug := hr_utility.debug_enabled;

161:
162: l_procedure VARCHAR2(250);
163: l_message VARCHAR2(250);
164: BEGIN
165: g_debug := hr_utility.debug_enabled;
166: l_procedure := g_package ||'get_period_number';
167: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
168:
169: l_period_num :=-99;

Line 335: g_debug := hr_utility.debug_enabled;

331: l_message VARCHAR2(255);
332: l_procedure VARCHAR2(100);
333:
334: BEGIN
335: g_debug := hr_utility.debug_enabled;
336: l_procedure := g_package ||'get_defined_balance';
337: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure, 10);
338: l_message := 'SUCCESS';
339:

Line 348: hr_utility.trace ('. '||RPAD(TRIM(p_balance_type||p_dimension_name),35,' ')||' : '||l_def_bal_id);

344:
345: pay_in_utils.set_location(g_debug,l_procedure, 20);
346:
347: IF g_debug THEN
348: hr_utility.trace ('. '||RPAD(TRIM(p_balance_type||p_dimension_name),35,' ')||' : '||l_def_bal_id);
349: END IF;
350:
351: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
352:

Line 358: hr_utility.trace(l_message);

354:
355: EXCEPTION
356: WHEN OTHERS THEN
357: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
358: hr_utility.trace(l_message);
359: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);
360: RETURN -1;
361:
362: END get_defined_balance ;

Line 454: hr_utility.trace('----------House Rent Information ----------');

450: end loop ;
451: end if ;
452:
453: if g_debug then
454: hr_utility.trace('----------House Rent Information ----------');
455: for i in p_rent_paid.first..p_rent_paid.last loop
456: hr_utility.trace(p_month(i)||'------------------'||p_rent_paid(i));
457: end loop ;
458:

Line 456: hr_utility.trace(p_month(i)||'------------------'||p_rent_paid(i));

452:
453: if g_debug then
454: hr_utility.trace('----------House Rent Information ----------');
455: for i in p_rent_paid.first..p_rent_paid.last loop
456: hr_utility.trace(p_month(i)||'------------------'||p_rent_paid(i));
457: end loop ;
458:
459: hr_utility.trace('-------------------------------------------');
460: end if ;

Line 459: hr_utility.trace('-------------------------------------------');

455: for i in p_rent_paid.first..p_rent_paid.last loop
456: hr_utility.trace(p_month(i)||'------------------'||p_rent_paid(i));
457: end loop ;
458:
459: hr_utility.trace('-------------------------------------------');
460: end if ;
461:
462: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure, 50);
463:

Line 563: hr_utility.trace('----------Maximum Assignment action ----------');

559: end if;
560:
561:
562: if g_debug then
563: hr_utility.trace('----------Maximum Assignment action ----------');
564: for i in 1..p_assact_tbl.count loop
565: hr_utility.trace(p_assact_tbl(i));
566: end loop ;
567: hr_utility.trace('-------------------------------------------');

Line 565: hr_utility.trace(p_assact_tbl(i));

561:
562: if g_debug then
563: hr_utility.trace('----------Maximum Assignment action ----------');
564: for i in 1..p_assact_tbl.count loop
565: hr_utility.trace(p_assact_tbl(i));
566: end loop ;
567: hr_utility.trace('-------------------------------------------');
568: end if ;
569:

Line 567: hr_utility.trace('-------------------------------------------');

563: hr_utility.trace('----------Maximum Assignment action ----------');
564: for i in 1..p_assact_tbl.count loop
565: hr_utility.trace(p_assact_tbl(i));
566: end loop ;
567: hr_utility.trace('-------------------------------------------');
568: end if ;
569:
570: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure, 10);
571: END get_monthly_max_assact;

Line 598: hr_utility.trace('---------------------------------------');

594: l_procedure := g_package ||'hra_tax_rule';
595: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure, 10);
596:
597: if g_debug then
598: hr_utility.trace('---------------------------------------');
599: hr_utility.trace('hra received -'||hra_received);
600: hr_utility.trace('hra salary - '||hra_salary);
601: hr_utility.trace('rent paid - '||rent_paid);
602: end if ;

Line 599: hr_utility.trace('hra received -'||hra_received);

595: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure, 10);
596:
597: if g_debug then
598: hr_utility.trace('---------------------------------------');
599: hr_utility.trace('hra received -'||hra_received);
600: hr_utility.trace('hra salary - '||hra_salary);
601: hr_utility.trace('rent paid - '||rent_paid);
602: end if ;
603:

Line 600: hr_utility.trace('hra salary - '||hra_salary);

596:
597: if g_debug then
598: hr_utility.trace('---------------------------------------');
599: hr_utility.trace('hra received -'||hra_received);
600: hr_utility.trace('hra salary - '||hra_salary);
601: hr_utility.trace('rent paid - '||rent_paid);
602: end if ;
603:
604: if metro_flag = 'Y' then

Line 601: hr_utility.trace('rent paid - '||rent_paid);

597: if g_debug then
598: hr_utility.trace('---------------------------------------');
599: hr_utility.trace('hra received -'||hra_received);
600: hr_utility.trace('hra salary - '||hra_salary);
601: hr_utility.trace('rent paid - '||rent_paid);
602: end if ;
603:
604: if metro_flag = 'Y' then
605: l_percent :=0.5 ;

Line 614: hr_utility.trace('exempt_hra - '||exempt_hra);

610: exempt_hra := least ( hra_salary*l_percent , hra_received, greatest((rent_paid - 0.10 * hra_salary ),0)) ;
611: taxable_hra := greatest((hra_received - exempt_hra),0) ;
612:
613: if g_debug then
614: hr_utility.trace('exempt_hra - '||exempt_hra);
615: hr_utility.trace('taxable hra -'||taxable_hra);
616: hr_utility.trace('---------------------------------------');
617: END IF;
618: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure, 20);

Line 615: hr_utility.trace('taxable hra -'||taxable_hra);

611: taxable_hra := greatest((hra_received - exempt_hra),0) ;
612:
613: if g_debug then
614: hr_utility.trace('exempt_hra - '||exempt_hra);
615: hr_utility.trace('taxable hra -'||taxable_hra);
616: hr_utility.trace('---------------------------------------');
617: END IF;
618: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure, 20);
619:

Line 616: hr_utility.trace('---------------------------------------');

612:
613: if g_debug then
614: hr_utility.trace('exempt_hra - '||exempt_hra);
615: hr_utility.trace('taxable hra -'||taxable_hra);
616: hr_utility.trace('---------------------------------------');
617: END IF;
618: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure, 20);
619:
620: END hra_tax_rule;

Line 726: hr_utility.trace('-----------------------------------------');

722: /* Bug:3907894 pass p_eff_date_tbl as the out parameter */
723: get_monthly_max_assact( p_assignment_id , p_year_start, p_year_end , l_assact_tbl,p_eff_date_tbl);
724:
725: if g_debug then
726: hr_utility.trace('-----------------------------------------');
727: end if ;
728:
729: for i in 1..l_assact_tbl.count loop
730: IF l_assact_tbl(i) > 0 THEN

Line 740: hr_utility.trace('Assact Id -----HRA Allow----HRA Salary--');

736: p_hra_sal_tbl(i) := 0 ;
737: END IF;
738:
739: if g_debug then
740: hr_utility.trace('Assact Id -----HRA Allow----HRA Salary--');
741: hr_utility.trace(l_assact_tbl(i)||'-----'||p_hra_tbl(i)||'------'||p_hra_sal_tbl(i));
742: end if ;
743:
744: end loop;

Line 741: hr_utility.trace(l_assact_tbl(i)||'-----'||p_hra_tbl(i)||'------'||p_hra_sal_tbl(i));

737: END IF;
738:
739: if g_debug then
740: hr_utility.trace('Assact Id -----HRA Allow----HRA Salary--');
741: hr_utility.trace(l_assact_tbl(i)||'-----'||p_hra_tbl(i)||'------'||p_hra_sal_tbl(i));
742: end if ;
743:
744: end loop;
745:

Line 747: hr_utility.trace('-----------------------------------------');

743:
744: end loop;
745:
746: if g_debug then
747: hr_utility.trace('-----------------------------------------');
748: end if ;
749: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure, 10);
750:
751: end get_hra_bal_information ;

Line 857: g_debug := hr_utility.debug_enabled;

853: l_message VARCHAR2(250);
854:
855: BEGIN
856:
857: g_debug := hr_utility.debug_enabled;
858: l_procedure := g_package ||'taxable_hra';
859: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure, 10);
860:
861: IF (g_debug)

Line 919: hr_utility.trace('INHRA:l_current_gre : '||l_current_gre);

915: ------------------------------
916: OPEN csr_get_current_gre(l_assignment_id);
917: FETCH csr_get_current_gre INTO l_current_gre;
918: CLOSE csr_get_current_gre;
919: hr_utility.trace('INHRA:l_current_gre : '||l_current_gre);
920:
921: --------------------------------------------------------
922: /*To get the end date of GRE in which payroll is run */
923: --------------------------------------------------------

Line 935: hr_utility.trace('INHRA:l_current_gre_end_date : '||l_current_gre_end_date);

931: EXIT WHEN csr_get_date%NOTFOUND;
932: END LOOP;
933: CLOSE csr_get_date;
934:
935: hr_utility.trace('INHRA:l_current_gre_end_date : '||l_current_gre_end_date);
936:
937: pay_in_utils.set_location(g_debug,l_procedure, 20);
938:
939: --------------------------------

Line 965: hr_utility.trace('INHRA: Last Period Number : '||l_last_period_num);

961:
962: pay_in_utils.set_location(g_debug,l_procedure, 30);
963:
964: IF g_debug THEN
965: hr_utility.trace('INHRA: Last Period Number : '||l_last_period_num);
966: hr_utility.trace('INHRA: current no : '||p_pay_period_num);
967: hr_utility.trace('INHRA: Assgn End Date : '||l_asg_end_date);
968: END IF ;
969:

Line 966: hr_utility.trace('INHRA: current no : '||p_pay_period_num);

962: pay_in_utils.set_location(g_debug,l_procedure, 30);
963:
964: IF g_debug THEN
965: hr_utility.trace('INHRA: Last Period Number : '||l_last_period_num);
966: hr_utility.trace('INHRA: current no : '||p_pay_period_num);
967: hr_utility.trace('INHRA: Assgn End Date : '||l_asg_end_date);
968: END IF ;
969:
970: --

Line 967: hr_utility.trace('INHRA: Assgn End Date : '||l_asg_end_date);

963:
964: IF g_debug THEN
965: hr_utility.trace('INHRA: Last Period Number : '||l_last_period_num);
966: hr_utility.trace('INHRA: current no : '||p_pay_period_num);
967: hr_utility.trace('INHRA: Assgn End Date : '||l_asg_end_date);
968: END IF ;
969:
970: --
971: -- get metro status of the employee

Line 1038: hr_utility.trace('INHRA: ------- HRA Amount--------');

1034: l_hra_sal_tbl,
1035: l_eff_date_tbl);
1036:
1037: IF g_debug THEN
1038: hr_utility.trace('INHRA: ------- HRA Amount--------');
1039: FOR i in 1..l_hra_tbl.count LOOP
1040: hr_utility.trace('INHRA: '||l_hra_tbl(i));
1041: END LOOP ;
1042: hr_utility.trace('INHRA: ------- HRA Salary--------');

Line 1040: hr_utility.trace('INHRA: '||l_hra_tbl(i));

1036:
1037: IF g_debug THEN
1038: hr_utility.trace('INHRA: ------- HRA Amount--------');
1039: FOR i in 1..l_hra_tbl.count LOOP
1040: hr_utility.trace('INHRA: '||l_hra_tbl(i));
1041: END LOOP ;
1042: hr_utility.trace('INHRA: ------- HRA Salary--------');
1043: FOR i in 1..l_hra_sal_tbl.count loop
1044: hr_utility.trace('INHRA: '||l_hra_sal_tbl(i));

Line 1042: hr_utility.trace('INHRA: ------- HRA Salary--------');

1038: hr_utility.trace('INHRA: ------- HRA Amount--------');
1039: FOR i in 1..l_hra_tbl.count LOOP
1040: hr_utility.trace('INHRA: '||l_hra_tbl(i));
1041: END LOOP ;
1042: hr_utility.trace('INHRA: ------- HRA Salary--------');
1043: FOR i in 1..l_hra_sal_tbl.count loop
1044: hr_utility.trace('INHRA: '||l_hra_sal_tbl(i));
1045: END LOOP ;
1046: END IF ;

Line 1044: hr_utility.trace('INHRA: '||l_hra_sal_tbl(i));

1040: hr_utility.trace('INHRA: '||l_hra_tbl(i));
1041: END LOOP ;
1042: hr_utility.trace('INHRA: ------- HRA Salary--------');
1043: FOR i in 1..l_hra_sal_tbl.count loop
1044: hr_utility.trace('INHRA: '||l_hra_sal_tbl(i));
1045: END LOOP ;
1046: END IF ;
1047:
1048: -- Bug:3907894 Get the metro status as of the payroll period

Line 1063: hr_utility.trace('INHRA: --tax_unit_id =>'||l_current_gre);

1059: pay_in_utils.set_location(g_debug,l_procedure, 80);
1060:
1061: --
1062: -- There is no update on the rent paid information this year
1063: hr_utility.trace('INHRA: --tax_unit_id =>'||l_current_gre);
1064:
1065: l_taxable_hra_asg_ytd := pay_balance_pkg.get_value(l_taxable_hra_def_bal_id,
1066: p_assact_id ,
1067: null,

Line 1079: hr_utility.trace ('INHRA: No update to HRI element. Hence direct results');

1075:
1076: END IF ;
1077:
1078: IF g_debug THEN
1079: hr_utility.trace ('INHRA: No update to HRI element. Hence direct results');
1080: hr_utility.trace ('INHRA: Taxable HRA_LE_ASG_YTD : '||l_taxable_hra_asg_ytd);
1081: END IF;
1082: --
1083: -- Calculate current month's taxable hra

Line 1080: hr_utility.trace ('INHRA: Taxable HRA_LE_ASG_YTD : '||l_taxable_hra_asg_ytd);

1076: END IF ;
1077:
1078: IF g_debug THEN
1079: hr_utility.trace ('INHRA: No update to HRI element. Hence direct results');
1080: hr_utility.trace ('INHRA: Taxable HRA_LE_ASG_YTD : '||l_taxable_hra_asg_ytd);
1081: END IF;
1082: --
1083: -- Calculate current month's taxable hra
1084: --

Line 1100: hr_utility.trace ('INHRA: Taxable HRA_ASG_PTD : '||l_taxable_hra_curr);

1096: --
1097: -- calculate projected value of taxable hra for future months in this tax year
1098: --
1099: IF g_debug THEN
1100: hr_utility.trace ('INHRA: Taxable HRA_ASG_PTD : '||l_taxable_hra_curr);
1101: END IF;
1102:
1103: pay_in_utils.set_location(g_debug,l_procedure, 90);
1104: --

Line 1158: hr_utility.trace ('INHRA: p_hra_taxable_annual : '||p_hra_taxable_annual);

1154:
1155: p_hra_taxable_mth := l_taxable_hra_curr - l_taxable_hra_asg_ptd;
1156:
1157: IF g_debug THEN
1158: hr_utility.trace ('INHRA: p_hra_taxable_annual : '||p_hra_taxable_annual);
1159: hr_utility.trace ('INHRA: p_hra_taxable_mth : '||p_hra_taxable_mth);
1160: END IF;
1161:
1162: RETURN 0 ;

Line 1159: hr_utility.trace ('INHRA: p_hra_taxable_mth : '||p_hra_taxable_mth);

1155: p_hra_taxable_mth := l_taxable_hra_curr - l_taxable_hra_asg_ptd;
1156:
1157: IF g_debug THEN
1158: hr_utility.trace ('INHRA: p_hra_taxable_annual : '||p_hra_taxable_annual);
1159: hr_utility.trace ('INHRA: p_hra_taxable_mth : '||p_hra_taxable_mth);
1160: END IF;
1161:
1162: RETURN 0 ;
1163:

Line 1267: g_debug := hr_utility.debug_enabled;

1263: l_procedure VARCHAR2(250);
1264: l_message VARCHAR2(250);
1265: BEGIN
1266:
1267: g_debug := hr_utility.debug_enabled;
1268: l_procedure := g_package ||'prev_emplr_details';
1269: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1270: IF (g_debug)
1271: THEN

Line 1416: g_debug := hr_utility.debug_enabled;

1412:
1413: l_procedure VARCHAR2(250);
1414: l_message VARCHAR2(250);
1415: BEGIN
1416: g_debug := hr_utility.debug_enabled;
1417: l_procedure := g_package ||'other_allowance_details';
1418: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1419: IF (g_debug)
1420: THEN

Line 1482: g_debug := hr_utility.debug_enabled;

1478: l_proof Varchar2(10);
1479: l_procedure VARCHAR2(250);
1480: l_message VARCHAR2(250);
1481: BEGIN
1482: g_debug := hr_utility.debug_enabled;
1483: l_procedure := g_package ||'get_disability_details';
1484: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1485:
1486: IF (g_debug)

Line 1548: g_debug := hr_utility.debug_enabled;

1544:
1545: l_procedure VARCHAR2(250);
1546: l_message VARCHAR2(250);
1547: BEGIN
1548: g_debug := hr_utility.debug_enabled;
1549: l_procedure := g_package ||'get_age';
1550: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1551: IF (g_debug)
1552: THEN

Line 1620: g_debug := hr_utility.debug_enabled;

1616: l_procedure VARCHAR2(250);
1617: l_message VARCHAR2(250);
1618:
1619: BEGIN
1620: g_debug := hr_utility.debug_enabled;
1621: l_procedure := g_package ||'act_rent_paid';
1622: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1623: IF (g_debug)
1624: THEN

Line 1729: g_debug := hr_utility.debug_enabled;

1725: l_payroll_id NUMBER;
1726: l_procedure VARCHAR2(250);
1727: l_message VARCHAR2(250);
1728: BEGIN
1729: g_debug := hr_utility.debug_enabled;
1730: l_procedure := g_package ||'check_ee_exists';
1731: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1732: IF (g_debug)
1733: THEN

Line 1749: hr_utility.trace('Business Group ID : '||l_business_group_id);

1745: INTO l_business_group_id, l_payroll_id;
1746: CLOSE csr_asg_details;
1747:
1748: IF g_debug THEN
1749: hr_utility.trace('Business Group ID : '||l_business_group_id);
1750: hr_utility.trace('Payroll ID : '||l_payroll_id);
1751: END IF;
1752:
1753: OPEN csr_element_link (l_business_group_id, l_payroll_id);

Line 1750: hr_utility.trace('Payroll ID : '||l_payroll_id);

1746: CLOSE csr_asg_details;
1747:
1748: IF g_debug THEN
1749: hr_utility.trace('Business Group ID : '||l_business_group_id);
1750: hr_utility.trace('Payroll ID : '||l_payroll_id);
1751: END IF;
1752:
1753: OPEN csr_element_link (l_business_group_id, l_payroll_id);
1754: FETCH csr_element_link INTO l_element_link_id;

Line 1762: hr_utility.trace('Element Link ID : '||l_element_link_id);

1758: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
1759: RETURN FALSE;
1760: ELSE
1761: IF g_debug THEN
1762: hr_utility.trace('Element Link ID : '||l_element_link_id);
1763: END IF;
1764:
1765: CLOSE csr_element_link;
1766: --

Line 1770: hr_utility.trace('Element Entry ID : '||p_element_entry_id);

1766: --
1767: OPEN csr_element_entry(l_element_link_id) ;
1768: FETCH csr_element_entry INTO p_element_entry_id, p_ee_ovn, p_start_date ;
1769: IF g_debug then
1770: hr_utility.trace('Element Entry ID : '||p_element_entry_id);
1771: END IF;
1772:
1773: IF p_element_entry_id IS NULL OR csr_element_entry%NOTFOUND
1774: THEN

Line 1813: g_debug := hr_utility.debug_enabled;

1809: l_date DATE;
1810: l_procedure VARCHAR2(250);
1811: l_message VARCHAR2(250);
1812: BEGIN
1813: g_debug := hr_utility.debug_enabled;
1814: l_procedure := g_package ||'get_date_earned';
1815: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1816: IF (g_debug)
1817: THEN

Line 1862: g_debug := hr_utility.debug_enabled;

1858: p_value number;
1859: l_procedure VARCHAR2(250);
1860: l_message VARCHAR2(250);
1861: BEGIN
1862: g_debug := hr_utility.debug_enabled;
1863: l_procedure := g_package ||'get_projected_loan_perquisite';
1864: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1865: IF (g_debug)
1866: THEN

Line 1937: g_debug := hr_utility.debug_enabled ;

1933: l_procedure VARCHAR2(100);
1934: l_message VARCHAR2(255);
1935:
1936: BEGIN
1937: g_debug := hr_utility.debug_enabled ;
1938: l_procedure := 'pay_in_tax_utils.get_perquisite_details' ;
1939: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1940: p_taxable_flag := 'Y';
1941:

Line 1964: hr_utility.trace(l_message);

1960: RETURN -1;
1961: WHEN OTHERS THEN
1962: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
1963: pay_in_utils.set_location(g_debug,' Leaving : '||l_procedure, 40);
1964: hr_utility.trace(l_message);
1965: RETURN -1;
1966:
1967: END get_perquisite_details;
1968:

Line 2036: g_debug := hr_utility.debug_enabled;

2032: l_procedure VARCHAR2(250);
2033: l_message VARCHAR2(250);
2034:
2035: BEGIN
2036: g_debug := hr_utility.debug_enabled;
2037: l_procedure := g_package ||'calculate_80gg_exemption';
2038: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2039: IF (g_debug)
2040: THEN

Line 2317: g_debug := hr_utility.debug_enabled;

2313: l_prev_emplr_prev_blk NUMBER;
2314: l_curr_emplr_curr_blk_exempted NUMBER;
2315: l_message VARCHAR2(250);
2316: BEGIN
2317: g_debug := hr_utility.debug_enabled;
2318: l_procedure := g_package ||'check_ltc_exemption';
2319: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2320:
2321: /*1.Find the LTC entries which have been carried over from previous LTC Block in the current run and store it in a PL/SQL table.

Line 2538: g_debug := hr_utility.debug_enabled;

2534: l_message VARCHAR2(255);
2535: l_procedure VARCHAR2(100);
2536: l_def_bal_id NUMBER ;
2537: BEGIN
2538: g_debug := hr_utility.debug_enabled;
2539: l_procedure := g_package ||'get_balance_value';
2540: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure, 10);
2541: l_message := 'SUCCESS';
2542:

Line 2555: hr_utility.trace ('INDIA: Assignment Action Id : '||p_assignment_action_id);

2551: RETURN -1;
2552: END IF;
2553:
2554: IF g_debug THEN
2555: hr_utility.trace ('INDIA: Assignment Action Id : '||p_assignment_action_id);
2556: hr_utility.trace ('INDIA: Balance Name : '||p_balance_name);
2557: hr_utility.trace ('INDIA: Dimension_name : '||p_dimension_name);
2558: hr_utility.trace ('INDIA: Defined Balance Id : '||l_def_bal_id);
2559: hr_utility.trace ('INDIA: Context Name : '||p_context_name);

Line 2556: hr_utility.trace ('INDIA: Balance Name : '||p_balance_name);

2552: END IF;
2553:
2554: IF g_debug THEN
2555: hr_utility.trace ('INDIA: Assignment Action Id : '||p_assignment_action_id);
2556: hr_utility.trace ('INDIA: Balance Name : '||p_balance_name);
2557: hr_utility.trace ('INDIA: Dimension_name : '||p_dimension_name);
2558: hr_utility.trace ('INDIA: Defined Balance Id : '||l_def_bal_id);
2559: hr_utility.trace ('INDIA: Context Name : '||p_context_name);
2560: hr_utility.trace ('INDIA: Context Value : '||p_context_value);

Line 2557: hr_utility.trace ('INDIA: Dimension_name : '||p_dimension_name);

2553:
2554: IF g_debug THEN
2555: hr_utility.trace ('INDIA: Assignment Action Id : '||p_assignment_action_id);
2556: hr_utility.trace ('INDIA: Balance Name : '||p_balance_name);
2557: hr_utility.trace ('INDIA: Dimension_name : '||p_dimension_name);
2558: hr_utility.trace ('INDIA: Defined Balance Id : '||l_def_bal_id);
2559: hr_utility.trace ('INDIA: Context Name : '||p_context_name);
2560: hr_utility.trace ('INDIA: Context Value : '||p_context_value);
2561: END IF;

Line 2558: hr_utility.trace ('INDIA: Defined Balance Id : '||l_def_bal_id);

2554: IF g_debug THEN
2555: hr_utility.trace ('INDIA: Assignment Action Id : '||p_assignment_action_id);
2556: hr_utility.trace ('INDIA: Balance Name : '||p_balance_name);
2557: hr_utility.trace ('INDIA: Dimension_name : '||p_dimension_name);
2558: hr_utility.trace ('INDIA: Defined Balance Id : '||l_def_bal_id);
2559: hr_utility.trace ('INDIA: Context Name : '||p_context_name);
2560: hr_utility.trace ('INDIA: Context Value : '||p_context_value);
2561: END IF;
2562:

Line 2559: hr_utility.trace ('INDIA: Context Name : '||p_context_name);

2555: hr_utility.trace ('INDIA: Assignment Action Id : '||p_assignment_action_id);
2556: hr_utility.trace ('INDIA: Balance Name : '||p_balance_name);
2557: hr_utility.trace ('INDIA: Dimension_name : '||p_dimension_name);
2558: hr_utility.trace ('INDIA: Defined Balance Id : '||l_def_bal_id);
2559: hr_utility.trace ('INDIA: Context Name : '||p_context_name);
2560: hr_utility.trace ('INDIA: Context Value : '||p_context_value);
2561: END IF;
2562:
2563: IF p_context_name = 'NULL' THEN

Line 2560: hr_utility.trace ('INDIA: Context Value : '||p_context_value);

2556: hr_utility.trace ('INDIA: Balance Name : '||p_balance_name);
2557: hr_utility.trace ('INDIA: Dimension_name : '||p_dimension_name);
2558: hr_utility.trace ('INDIA: Defined Balance Id : '||l_def_bal_id);
2559: hr_utility.trace ('INDIA: Context Name : '||p_context_name);
2560: hr_utility.trace ('INDIA: Context Value : '||p_context_value);
2561: END IF;
2562:
2563: IF p_context_name = 'NULL' THEN
2564: pay_in_utils.set_location(g_debug,l_procedure, 30);

Line 2676: hr_utility.trace ('INDIA: Balance Value : '||to_char(l_balance_value));

2672: END IF;
2673: END IF;
2674: END IF;
2675:
2676: hr_utility.trace ('INDIA: Balance Value : '||to_char(l_balance_value));
2677: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure, 120);
2678: RETURN l_balance_value;
2679:
2680: EXCEPTION

Line 2683: hr_utility.trace(l_message);

2679:
2680: EXCEPTION
2681: WHEN OTHERS THEN
2682: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
2683: hr_utility.trace(l_message);
2684: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 130);
2685: RETURN -1;
2686: END get_balance_value;
2687:

Line 2736: g_debug := hr_utility.debug_enabled;

2732:
2733: BEGIN
2734:
2735: l_procedure := g_package||'get_org_id';
2736: g_debug := hr_utility.debug_enabled;
2737:
2738: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure, 10);
2739:
2740: OPEN cur_org (p_assignment_id

Line 2765: hr_utility.trace(l_message);

2761: EXCEPTION
2762: WHEN OTHERS THEN
2763: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
2764: pay_in_utils.set_location(g_debug,' Leaving : '||l_procedure, 30);
2765: hr_utility.trace(l_message);
2766: RETURN NULL;
2767:
2768:
2769: END get_org_id;

Line 2817: g_debug := hr_utility.debug_enabled;

2813:
2814: l_procedure VARCHAR2(250);
2815: l_message VARCHAR2(250);
2816: BEGIN
2817: g_debug := hr_utility.debug_enabled;
2818: l_procedure := g_package ||'le_start_date';
2819: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2820: IF (g_debug)
2821: THEN

Line 2902: g_debug := hr_utility.debug_enabled;

2898:
2899: l_procedure VARCHAR2(250);
2900: l_message VARCHAR2(250);
2901: BEGIN
2902: g_debug := hr_utility.debug_enabled;
2903: l_procedure := g_package ||'le_end_date';
2904: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2905:
2906: IF (g_debug)

Line 2983: g_debug := hr_utility.debug_enabled;

2979: l_end_date DATE;
2980: l_procedure VARCHAR2(250);
2981: l_message VARCHAR2(250);
2982: BEGIN
2983: g_debug := hr_utility.debug_enabled;
2984: l_procedure := g_package ||'get_pay_periods';
2985: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2986: IF (g_debug)
2987: THEN

Line 3004: hr_utility.trace('p_payroll_id = '||to_char(p_payroll_id));

3000: l_tot_pay_periods :=12;
3001: l_year_end := get_financial_year_end(p_period_end_date);
3002: l_year_start := get_financial_year_start(p_period_end_date);
3003:
3004: hr_utility.trace('p_payroll_id = '||to_char(p_payroll_id));
3005: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));
3006: hr_utility.trace('p_period_number = '||to_char(p_period_number));
3007: hr_utility.trace('l_year_end = '||to_char(l_year_end,'DD-MM-YYYY'));
3008: hr_utility.trace('l_year_start = '||to_char(l_year_start,'DD-MM-YYYY'));

Line 3005: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));

3001: l_year_end := get_financial_year_end(p_period_end_date);
3002: l_year_start := get_financial_year_start(p_period_end_date);
3003:
3004: hr_utility.trace('p_payroll_id = '||to_char(p_payroll_id));
3005: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));
3006: hr_utility.trace('p_period_number = '||to_char(p_period_number));
3007: hr_utility.trace('l_year_end = '||to_char(l_year_end,'DD-MM-YYYY'));
3008: hr_utility.trace('l_year_start = '||to_char(l_year_start,'DD-MM-YYYY'));
3009:

Line 3006: hr_utility.trace('p_period_number = '||to_char(p_period_number));

3002: l_year_start := get_financial_year_start(p_period_end_date);
3003:
3004: hr_utility.trace('p_payroll_id = '||to_char(p_payroll_id));
3005: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));
3006: hr_utility.trace('p_period_number = '||to_char(p_period_number));
3007: hr_utility.trace('l_year_end = '||to_char(l_year_end,'DD-MM-YYYY'));
3008: hr_utility.trace('l_year_start = '||to_char(l_year_start,'DD-MM-YYYY'));
3009:
3010: IF p_condition = 'GRE' THEN

Line 3007: hr_utility.trace('l_year_end = '||to_char(l_year_end,'DD-MM-YYYY'));

3003:
3004: hr_utility.trace('p_payroll_id = '||to_char(p_payroll_id));
3005: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));
3006: hr_utility.trace('p_period_number = '||to_char(p_period_number));
3007: hr_utility.trace('l_year_end = '||to_char(l_year_end,'DD-MM-YYYY'));
3008: hr_utility.trace('l_year_start = '||to_char(l_year_start,'DD-MM-YYYY'));
3009:
3010: IF p_condition = 'GRE' THEN
3011: l_le_end := le_end_date(p_tax_unit_id, p_assignment_id, p_date_earned);

Line 3008: hr_utility.trace('l_year_start = '||to_char(l_year_start,'DD-MM-YYYY'));

3004: hr_utility.trace('p_payroll_id = '||to_char(p_payroll_id));
3005: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));
3006: hr_utility.trace('p_period_number = '||to_char(p_period_number));
3007: hr_utility.trace('l_year_end = '||to_char(l_year_end,'DD-MM-YYYY'));
3008: hr_utility.trace('l_year_start = '||to_char(l_year_start,'DD-MM-YYYY'));
3009:
3010: IF p_condition = 'GRE' THEN
3011: l_le_end := le_end_date(p_tax_unit_id, p_assignment_id, p_date_earned);
3012: ELSE

Line 3015: hr_utility.trace('l_le_end = '||to_char(l_le_end,'DD-MM-YYYY'));

3011: l_le_end := le_end_date(p_tax_unit_id, p_assignment_id, p_date_earned);
3012: ELSE
3013: l_le_end := l_year_end;
3014: END IF;
3015: hr_utility.trace('l_le_end = '||to_char(l_le_end,'DD-MM-YYYY'));
3016:
3017: l_term := GREATEST(p_termination_date, l_year_start);
3018:
3019: l_end_date := LEAST(l_year_end, l_le_end, l_term);

Line 3021: hr_utility.trace('l_end_date = '||to_char(l_end_date,'DD-MM-YYYY'));

3017: l_term := GREATEST(p_termination_date, l_year_start);
3018:
3019: l_end_date := LEAST(l_year_end, l_le_end, l_term);
3020:
3021: hr_utility.trace('l_end_date = '||to_char(l_end_date,'DD-MM-YYYY'));
3022:
3023: l_tot_pay_periods := get_period_number(p_payroll_id,l_end_date);
3024: l_rem_pay_periods := GREATEST(l_tot_pay_periods - p_period_number, 0);
3025:

Line 3097: g_debug := hr_utility.debug_enabled;

3093:
3094: l_procedure VARCHAR2(250);
3095: l_message VARCHAR2(250);
3096: BEGIN
3097: g_debug := hr_utility.debug_enabled;
3098: l_procedure := g_package ||'get_income_tax';
3099: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
3100: IF (g_debug)
3101: THEN

Line 3264: g_debug := hr_utility.debug_enabled;

3260:
3261: l_procedure VARCHAR2(250);
3262: l_message VARCHAR2(250);
3263: BEGIN
3264: g_debug := hr_utility.debug_enabled;
3265: l_procedure := g_package ||'set_context';
3266: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
3267: IF (g_debug)
3268: THEN

Line 3353: g_debug := hr_utility.debug_enabled;

3349: l_message VARCHAR2(250);
3350:
3351: BEGIN
3352: --
3353: g_debug := hr_utility.debug_enabled;
3354: l_proc := g_package||'get_value_on_le_start';
3355:
3356: IF (g_debug)
3357: THEN

Line 3479: g_debug := hr_utility.debug_enabled;

3475: l_procedure VARCHAR2(250);
3476: l_message VARCHAR2(250);
3477: BEGIN
3478:
3479: g_debug := hr_utility.debug_enabled;
3480: l_procedure := g_package ||'prev_med_reimbursement';
3481: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
3482: IF (g_debug)
3483: THEN

Line 3589: g_debug := hr_utility.debug_enabled;

3585: l_procedure VARCHAR2(250);
3586:
3587: BEGIN
3588:
3589: g_debug := hr_utility.debug_enabled;
3590: l_procedure := g_package ||'get_value_prev_period';
3591: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
3592:
3593:

Line 3687: g_debug := hr_utility.debug_enabled;

3683: l_exists VARCHAR2(10);
3684: l_procedure VARCHAR2(250);
3685:
3686: BEGIN
3687: g_debug := hr_utility.debug_enabled;
3688: l_procedure := g_package ||'get_regular_run_exists';
3689: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
3690:
3691: IF (g_debug)

Line 3763: g_debug := hr_utility.debug_enabled;

3759:
3760:
3761: BEGIN
3762:
3763: g_debug := hr_utility.debug_enabled;
3764: l_procedure := g_package ||'bon_section_89_relief';
3765: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
3766:
3767: IF (g_debug)

Line 3911: g_debug := hr_utility.debug_enabled;

3907:
3908: BEGIN
3909:
3910: /* 80gg Starts without bonus */
3911: g_debug := hr_utility.debug_enabled;
3912: l_procedure := g_package ||'bon_calculate_80g_gg';
3913: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
3914:
3915: