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 31: g_debug := hr_utility.debug_enabled;

27: l_date_offset number;
28: l_pub_sect_flag VARCHAR2(20);
29: BEGIN
30: l_procedure := g_package||'get_tax_year_start';
31: g_debug := hr_utility.debug_enabled;
32: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
33:
34: select to_number(nvl(PAY_DATE_OFFSET,0)),PRL_INFORMATION1 into l_date_offset,l_pub_sect_flag
35: from pay_payrolls_f

Line 91: g_debug := hr_utility.debug_enabled;

87: l_message VARCHAR2(250);
88:
89: BEGIN
90: l_procedure := g_package||'get_financial_year_start';
91: g_debug := hr_utility.debug_enabled;
92: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
93:
94: if to_number(to_char(p_date,'MM')) >=4 then
95: l_year := to_char(p_date,'YYYY');

Line 124: g_debug := hr_utility.debug_enabled;

120: l_end_date varchar2(10);
121: l_pub_sect_flag VARCHAR2(20);
122: BEGIN
123: l_procedure := g_package||'get_tax_year_end';
124: g_debug := hr_utility.debug_enabled;
125: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
126: l_end_date := '01-FEB-';
127: select to_number(nvl(PAY_DATE_OFFSET,0)),PRL_INFORMATION1 into l_date_offset,l_pub_sect_flag
128: from pay_payrolls_f

Line 183: g_debug := hr_utility.debug_enabled;

179: l_procedure VARCHAR2(100);
180: l_message VARCHAR2(250);
181: BEGIN
182: l_procedure := g_package||'get_financial_year_end';
183: g_debug := hr_utility.debug_enabled;
184: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
185:
186: if to_number(to_char(p_date,'MM')) <=3 then
187: l_year := to_char(p_date,'YYYY');

Line 229: g_debug := hr_utility.debug_enabled;

225: l_status VARCHAR(2);
226: l_procedure VARCHAR2(250);
227: l_message VARCHAR2(250);
228: BEGIN
229: g_debug := hr_utility.debug_enabled;
230: l_procedure := g_package ||'get_metro_status';
231: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
232:
233: IF (g_debug)

Line 287: g_debug := hr_utility.debug_enabled;

283:
284: l_procedure VARCHAR2(250);
285: l_message VARCHAR2(250);
286: BEGIN
287: g_debug := hr_utility.debug_enabled;
288: l_procedure := g_package ||'get_period_number';
289: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
290:
291: l_period_num :=-99;

Line 385: hr_utility.trace('p_effective_date'||p_effective_date);

381: l_message VARCHAR2(250);
382: BEGIN
383: l_procedure := g_package||'get_house_rent_info_entry_id';
384: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
385: hr_utility.trace('p_effective_date'||p_effective_date);
386: hr_utility.trace('p_assact'||p_assact);
387:
388: l_entry_id_type_flag :='E';
389: open c_ele_id ;

Line 386: hr_utility.trace('p_assact'||p_assact);

382: BEGIN
383: l_procedure := g_package||'get_house_rent_info_entry_id';
384: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
385: hr_utility.trace('p_effective_date'||p_effective_date);
386: hr_utility.trace('p_assact'||p_assact);
387:
388: l_entry_id_type_flag :='E';
389: open c_ele_id ;
390: fetch c_ele_id into l_houserentinfo_entry_id,p_entry_end_date ;

Line 393: hr_utility.trace('p_entry_end_date'||p_entry_end_date);

389: open c_ele_id ;
390: fetch c_ele_id into l_houserentinfo_entry_id,p_entry_end_date ;
391: close c_ele_id ;
392:
393: hr_utility.trace('p_entry_end_date'||p_entry_end_date);
394:
395: pay_in_utils.set_location(g_debug,l_procedure,20);
396:
397: if l_houserentinfo_entry_id = -999 then

Line 407: hr_utility.trace('p_entry_end_date'||p_entry_end_date);

403: fetch c_ele_id_latest into l_houserentinfo_entry_id,p_entry_end_date ;
404: close c_ele_id_latest ;
405: pay_in_utils.set_location(g_debug,l_procedure,30);
406:
407: hr_utility.trace('p_entry_end_date'||p_entry_end_date);
408:
409: if l_houserentinfo_entry_id = -999 then
410: --
411: -- ok. entry id still not found in this financial year.

Line 463: g_debug := hr_utility.debug_enabled;

459: l_message VARCHAR2(255);
460: l_procedure VARCHAR2(100);
461:
462: BEGIN
463: g_debug := hr_utility.debug_enabled;
464: l_procedure := g_package ||'get_defined_balance';
465: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure, 10);
466: l_message := 'SUCCESS';
467:

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

472:
473: pay_in_utils.set_location(g_debug,l_procedure, 20);
474:
475: IF g_debug THEN
476: hr_utility.trace ('. '||RPAD(TRIM(p_balance_type||p_dimension_name),35,' ')||' : '||l_def_bal_id);
477: END IF;
478:
479: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 30);
480:

Line 486: hr_utility.trace(l_message);

482:
483: EXCEPTION
484: WHEN OTHERS THEN
485: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
486: hr_utility.trace(l_message);
487: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 40);
488: RETURN -1;
489:
490: END get_defined_balance ;

Line 560: hr_utility.trace('p_element_entry_id'||p_element_entry_id);

556:
557: BEGIN
558: l_procedure := g_package ||'get_monthly_rent';
559: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure, 10);
560: hr_utility.trace('p_element_entry_id'||p_element_entry_id);
561:
562:
563: if p_entry_end_date < p_effective_date then
564: l_effective_date := p_entry_end_date ;

Line 570: hr_utility.trace('l_effective_date'||l_effective_date);

566: l_effective_date := p_effective_date ;
567: end if ;
568:
569: pay_in_utils.set_location(g_debug,l_procedure, 20);
570: hr_utility.trace('l_effective_date'||l_effective_date);
571:
572: select to_number(nvl(PAY_DATE_OFFSET,0)),PRL_INFORMATION1 into l_date_offset,l_pub_sect_flag
573: from pay_payrolls_f
574: where payroll_id = p_payroll_id

Line 691: hr_utility.trace('prev_element_entry_id'||l_prev_element_entry_id);

687: open get_house_rent_entry_id(l_prev_house_rent_entry_date);
688: fetch get_house_rent_entry_id into l_prev_element_entry_id;
689: close get_house_rent_entry_id;
690:
691: hr_utility.trace('prev_element_entry_id'||l_prev_element_entry_id);
692: p_rent_paid(1) := 0;
693: if l_prev_element_entry_id <> -999 then
694: open get_mar_month_rent(l_prev_house_rent_entry_date,l_prev_element_entry_id);
695: fetch get_mar_month_rent into p_rent_paid(1), p_month(1);

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

761: end loop ;
762: end if ;
763:
764: if g_debug then
765: hr_utility.trace('----------House Rent Information ----------');
766: for i in p_rent_paid.first..p_rent_paid.last loop
767: hr_utility.trace(p_month(i)||'------------------'||p_rent_paid(i));
768: end loop ;
769:

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

763:
764: if g_debug then
765: hr_utility.trace('----------House Rent Information ----------');
766: for i in p_rent_paid.first..p_rent_paid.last loop
767: hr_utility.trace(p_month(i)||'------------------'||p_rent_paid(i));
768: end loop ;
769:
770: hr_utility.trace('-------------------------------------------');
771: end if ;

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

766: for i in p_rent_paid.first..p_rent_paid.last loop
767: hr_utility.trace(p_month(i)||'------------------'||p_rent_paid(i));
768: end loop ;
769:
770: hr_utility.trace('-------------------------------------------');
771: end if ;
772:
773: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure, 120);
774:

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

870: end if;
871:
872:
873: if g_debug then
874: hr_utility.trace('----------Maximum Assignment action ----------');
875: for i in 1..p_assact_tbl.count loop
876: hr_utility.trace(p_assact_tbl(i));
877: end loop ;
878: hr_utility.trace('-------------------------------------------');

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

872:
873: if g_debug then
874: hr_utility.trace('----------Maximum Assignment action ----------');
875: for i in 1..p_assact_tbl.count loop
876: hr_utility.trace(p_assact_tbl(i));
877: end loop ;
878: hr_utility.trace('-------------------------------------------');
879: end if ;
880:

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

874: hr_utility.trace('----------Maximum Assignment action ----------');
875: for i in 1..p_assact_tbl.count loop
876: hr_utility.trace(p_assact_tbl(i));
877: end loop ;
878: hr_utility.trace('-------------------------------------------');
879: end if ;
880:
881: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure, 10);
882: END get_monthly_max_assact;

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

905: l_procedure := g_package ||'hra_tax_rule';
906: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure, 10);
907:
908: if g_debug then
909: hr_utility.trace('---------------------------------------');
910: hr_utility.trace('hra received -'||hra_received);
911: hr_utility.trace('hra salary - '||hra_salary);
912: hr_utility.trace('rent paid - '||rent_paid);
913: end if ;

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

906: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure, 10);
907:
908: if g_debug then
909: hr_utility.trace('---------------------------------------');
910: hr_utility.trace('hra received -'||hra_received);
911: hr_utility.trace('hra salary - '||hra_salary);
912: hr_utility.trace('rent paid - '||rent_paid);
913: end if ;
914:

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

907:
908: if g_debug then
909: hr_utility.trace('---------------------------------------');
910: hr_utility.trace('hra received -'||hra_received);
911: hr_utility.trace('hra salary - '||hra_salary);
912: hr_utility.trace('rent paid - '||rent_paid);
913: end if ;
914:
915: if metro_flag = 'Y' then

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

908: if g_debug then
909: hr_utility.trace('---------------------------------------');
910: hr_utility.trace('hra received -'||hra_received);
911: hr_utility.trace('hra salary - '||hra_salary);
912: hr_utility.trace('rent paid - '||rent_paid);
913: end if ;
914:
915: if metro_flag = 'Y' then
916: l_percent :=0.5 ;

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

921: exempt_hra := least ( hra_salary*l_percent , hra_received, greatest((rent_paid - 0.10 * hra_salary ),0)) ;
922: taxable_hra := greatest((hra_received - exempt_hra),0) ;
923:
924: if g_debug then
925: hr_utility.trace('exempt_hra - '||exempt_hra);
926: hr_utility.trace('taxable hra -'||taxable_hra);
927: hr_utility.trace('---------------------------------------');
928: END IF;
929: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure, 20);

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

922: taxable_hra := greatest((hra_received - exempt_hra),0) ;
923:
924: if g_debug then
925: hr_utility.trace('exempt_hra - '||exempt_hra);
926: hr_utility.trace('taxable hra -'||taxable_hra);
927: hr_utility.trace('---------------------------------------');
928: END IF;
929: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure, 20);
930:

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

923:
924: if g_debug then
925: hr_utility.trace('exempt_hra - '||exempt_hra);
926: hr_utility.trace('taxable hra -'||taxable_hra);
927: hr_utility.trace('---------------------------------------');
928: END IF;
929: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure, 20);
930:
931: END hra_tax_rule;

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

1033: /* Bug:3907894 pass p_eff_date_tbl as the out parameter */
1034: get_monthly_max_assact( p_assignment_id , p_year_start, p_year_end , l_assact_tbl,p_eff_date_tbl);
1035:
1036: if g_debug then
1037: hr_utility.trace('-----------------------------------------');
1038: end if ;
1039:
1040: for i in 1..l_assact_tbl.count loop
1041: IF l_assact_tbl(i) > 0 THEN

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

1047: p_hra_sal_tbl(i) := 0 ;
1048: END IF;
1049:
1050: if g_debug then
1051: hr_utility.trace('Assact Id -----HRA Allow----HRA Salary--');
1052: hr_utility.trace(l_assact_tbl(i)||'-----'||p_hra_tbl(i)||'------'||p_hra_sal_tbl(i));
1053: end if ;
1054:
1055: end loop;

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

1048: END IF;
1049:
1050: if g_debug then
1051: hr_utility.trace('Assact Id -----HRA Allow----HRA Salary--');
1052: hr_utility.trace(l_assact_tbl(i)||'-----'||p_hra_tbl(i)||'------'||p_hra_sal_tbl(i));
1053: end if ;
1054:
1055: end loop;
1056:

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

1054:
1055: end loop;
1056:
1057: if g_debug then
1058: hr_utility.trace('-----------------------------------------');
1059: end if ;
1060: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure, 10);
1061:
1062: end get_hra_bal_information ;

Line 1174: g_debug := hr_utility.debug_enabled;

1170: l_message VARCHAR2(250);
1171:
1172: BEGIN
1173:
1174: g_debug := hr_utility.debug_enabled;
1175: l_procedure := g_package ||'taxable_hra';
1176: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure, 10);
1177:
1178: IF (g_debug)

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

1245: ------------------------------
1246: OPEN csr_get_current_gre(l_assignment_id);
1247: FETCH csr_get_current_gre INTO l_current_gre;
1248: CLOSE csr_get_current_gre;
1249: hr_utility.trace('INHRA:l_current_gre : '||l_current_gre);
1250:
1251: --------------------------------------------------------
1252: /*To get the end date of GRE in which payroll is run */
1253: --------------------------------------------------------

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

1261: EXIT WHEN csr_get_date%NOTFOUND;
1262: END LOOP;
1263: CLOSE csr_get_date;
1264:
1265: hr_utility.trace('INHRA:l_current_gre_end_date : '||l_current_gre_end_date);
1266:
1267: pay_in_utils.set_location(g_debug,l_procedure, 20);
1268:
1269: --------------------------------

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

1291:
1292: pay_in_utils.set_location(g_debug,l_procedure, 30);
1293:
1294: IF g_debug THEN
1295: hr_utility.trace('INHRA: Last Period Number : '||l_last_period_num);
1296: hr_utility.trace('INHRA: current no : '||p_pay_period_num);
1297: hr_utility.trace('INHRA: Assgn End Date : '||l_asg_end_date);
1298: END IF ;
1299:

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

1292: pay_in_utils.set_location(g_debug,l_procedure, 30);
1293:
1294: IF g_debug THEN
1295: hr_utility.trace('INHRA: Last Period Number : '||l_last_period_num);
1296: hr_utility.trace('INHRA: current no : '||p_pay_period_num);
1297: hr_utility.trace('INHRA: Assgn End Date : '||l_asg_end_date);
1298: END IF ;
1299:
1300: --

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

1293:
1294: IF g_debug THEN
1295: hr_utility.trace('INHRA: Last Period Number : '||l_last_period_num);
1296: hr_utility.trace('INHRA: current no : '||p_pay_period_num);
1297: hr_utility.trace('INHRA: Assgn End Date : '||l_asg_end_date);
1298: END IF ;
1299:
1300: --
1301: -- get metro status of the employee

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

1368: l_hra_sal_tbl,
1369: l_eff_date_tbl);
1370:
1371: IF g_debug THEN
1372: hr_utility.trace('INHRA: ------- HRA Amount--------');
1373: FOR i in 1..l_hra_tbl.count LOOP
1374: hr_utility.trace('INHRA: '||l_hra_tbl(i));
1375: END LOOP ;
1376: hr_utility.trace('INHRA: ------- HRA Salary--------');

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

1370:
1371: IF g_debug THEN
1372: hr_utility.trace('INHRA: ------- HRA Amount--------');
1373: FOR i in 1..l_hra_tbl.count LOOP
1374: hr_utility.trace('INHRA: '||l_hra_tbl(i));
1375: END LOOP ;
1376: hr_utility.trace('INHRA: ------- HRA Salary--------');
1377: FOR i in 1..l_hra_sal_tbl.count loop
1378: hr_utility.trace('INHRA: '||l_hra_sal_tbl(i));

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

1372: hr_utility.trace('INHRA: ------- HRA Amount--------');
1373: FOR i in 1..l_hra_tbl.count LOOP
1374: hr_utility.trace('INHRA: '||l_hra_tbl(i));
1375: END LOOP ;
1376: hr_utility.trace('INHRA: ------- HRA Salary--------');
1377: FOR i in 1..l_hra_sal_tbl.count loop
1378: hr_utility.trace('INHRA: '||l_hra_sal_tbl(i));
1379: END LOOP ;
1380: END IF ;

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

1374: hr_utility.trace('INHRA: '||l_hra_tbl(i));
1375: END LOOP ;
1376: hr_utility.trace('INHRA: ------- HRA Salary--------');
1377: FOR i in 1..l_hra_sal_tbl.count loop
1378: hr_utility.trace('INHRA: '||l_hra_sal_tbl(i));
1379: END LOOP ;
1380: END IF ;
1381:
1382: -- Bug:3907894 Get the metro status as of the payroll period

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

1394: pay_in_utils.set_location(g_debug,l_procedure, 80);
1395:
1396: --
1397: -- There is no update on the rent paid information this year
1398: hr_utility.trace('INHRA: --tax_unit_id =>'||l_current_gre);
1399:
1400: l_taxable_hra_asg_ytd := pay_balance_pkg.get_value(l_taxable_hra_def_bal_id,
1401: p_assact_id ,
1402: null,

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

1425:
1426: -- END IF ;
1427:
1428: IF g_debug THEN
1429: hr_utility.trace('INHRA: No update to HRI element. Hence direct results');
1430: hr_utility.trace ('INHRA: Taxable HRA_ASG_YTD : '||l_taxable_hra_asg_ytd);
1431: hr_utility.trace ('INHRA: Retro Taxable HRA_ASG_YTD : '||l_ret_tax_hra_asg_ytd);
1432: END IF;
1433: --

Line 1430: hr_utility.trace ('INHRA: Taxable HRA_ASG_YTD : '||l_taxable_hra_asg_ytd);

1426: -- END IF ;
1427:
1428: IF g_debug THEN
1429: hr_utility.trace('INHRA: No update to HRI element. Hence direct results');
1430: hr_utility.trace ('INHRA: Taxable HRA_ASG_YTD : '||l_taxable_hra_asg_ytd);
1431: hr_utility.trace ('INHRA: Retro Taxable HRA_ASG_YTD : '||l_ret_tax_hra_asg_ytd);
1432: END IF;
1433: --
1434: -- Calculate current month's taxable hra

Line 1431: hr_utility.trace ('INHRA: Retro Taxable HRA_ASG_YTD : '||l_ret_tax_hra_asg_ytd);

1427:
1428: IF g_debug THEN
1429: hr_utility.trace('INHRA: No update to HRI element. Hence direct results');
1430: hr_utility.trace ('INHRA: Taxable HRA_ASG_YTD : '||l_taxable_hra_asg_ytd);
1431: hr_utility.trace ('INHRA: Retro Taxable HRA_ASG_YTD : '||l_ret_tax_hra_asg_ytd);
1432: END IF;
1433: --
1434: -- Calculate current month's taxable hra
1435: --

Line 1451: hr_utility.trace ('INHRA: Taxable HRA_ASG_DE_PTD : '||l_taxable_hra_curr);

1447: --
1448: -- calculate projected value of taxable hra for future months in this tax year
1449: --
1450: IF g_debug THEN
1451: hr_utility.trace ('INHRA: Taxable HRA_ASG_DE_PTD : '||l_taxable_hra_curr);
1452: hr_utility.trace ('INHRA: Exemption_on_HRA : '||l_exemption_on_hra);
1453: END IF;
1454:
1455: pay_in_utils.set_location(g_debug,l_procedure, 90);

Line 1452: hr_utility.trace ('INHRA: Exemption_on_HRA : '||l_exemption_on_hra);

1448: -- calculate projected value of taxable hra for future months in this tax year
1449: --
1450: IF g_debug THEN
1451: hr_utility.trace ('INHRA: Taxable HRA_ASG_DE_PTD : '||l_taxable_hra_curr);
1452: hr_utility.trace ('INHRA: Exemption_on_HRA : '||l_exemption_on_hra);
1453: END IF;
1454:
1455: pay_in_utils.set_location(g_debug,l_procedure, 90);
1456: --

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

1509:
1510: p_hra_taxable_mth := l_taxable_hra_curr - l_taxable_hra_ASG_DE_PTD;
1511:
1512: IF g_debug THEN
1513: hr_utility.trace ('INHRA: p_hra_taxable_annual : '||p_hra_taxable_annual);
1514: hr_utility.trace ('INHRA: p_hra_taxable_mth : '||p_hra_taxable_mth);
1515: END IF;
1516:
1517: RETURN 0 ;

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

1510: p_hra_taxable_mth := l_taxable_hra_curr - l_taxable_hra_ASG_DE_PTD;
1511:
1512: IF g_debug THEN
1513: hr_utility.trace ('INHRA: p_hra_taxable_annual : '||p_hra_taxable_annual);
1514: hr_utility.trace ('INHRA: p_hra_taxable_mth : '||p_hra_taxable_mth);
1515: END IF;
1516:
1517: RETURN 0 ;
1518:

Line 1625: g_debug := hr_utility.debug_enabled;

1621: l_procedure VARCHAR2(250);
1622: l_message VARCHAR2(250);
1623: BEGIN
1624:
1625: g_debug := hr_utility.debug_enabled;
1626: l_procedure := g_package ||'prev_emplr_details';
1627: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1628: IF (g_debug)
1629: THEN

Line 1767: g_debug := hr_utility.debug_enabled;

1763: l_procedure VARCHAR2(250);
1764: l_message VARCHAR2(250);
1765: l_res_status VARCHAR2(30);
1766: BEGIN
1767: g_debug := hr_utility.debug_enabled;
1768: l_procedure := g_package ||'get_residential_status';
1769: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1770: IF (g_debug)
1771: THEN

Line 1827: g_debug := hr_utility.debug_enabled;

1823:
1824: l_procedure VARCHAR2(250);
1825: l_message VARCHAR2(250);
1826: BEGIN
1827: g_debug := hr_utility.debug_enabled;
1828: l_procedure := g_package ||'other_allowance_details';
1829: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1830: IF (g_debug)
1831: THEN

Line 1893: g_debug := hr_utility.debug_enabled;

1889: l_proof Varchar2(10);
1890: l_procedure VARCHAR2(250);
1891: l_message VARCHAR2(250);
1892: BEGIN
1893: g_debug := hr_utility.debug_enabled;
1894: l_procedure := g_package ||'get_disability_details';
1895: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1896:
1897: IF (g_debug)

Line 1959: g_debug := hr_utility.debug_enabled;

1955:
1956: l_procedure VARCHAR2(250);
1957: l_message VARCHAR2(250);
1958: BEGIN
1959: g_debug := hr_utility.debug_enabled;
1960: l_procedure := g_package ||'get_age';
1961: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
1962: IF (g_debug)
1963: THEN

Line 2031: g_debug := hr_utility.debug_enabled;

2027: l_procedure VARCHAR2(250);
2028: l_message VARCHAR2(250);
2029:
2030: BEGIN
2031: g_debug := hr_utility.debug_enabled;
2032: l_procedure := g_package ||'act_rent_paid';
2033: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2034: IF (g_debug)
2035: THEN

Line 2140: g_debug := hr_utility.debug_enabled;

2136: l_payroll_id NUMBER;
2137: l_procedure VARCHAR2(250);
2138: l_message VARCHAR2(250);
2139: BEGIN
2140: g_debug := hr_utility.debug_enabled;
2141: l_procedure := g_package ||'check_ee_exists';
2142: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2143: IF (g_debug)
2144: THEN

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

2156: INTO l_business_group_id, l_payroll_id;
2157: CLOSE csr_asg_details;
2158:
2159: IF g_debug THEN
2160: hr_utility.trace('Business Group ID : '||l_business_group_id);
2161: hr_utility.trace('Payroll ID : '||l_payroll_id);
2162: END IF;
2163:
2164: OPEN csr_element_link (l_business_group_id, l_payroll_id);

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

2157: CLOSE csr_asg_details;
2158:
2159: IF g_debug THEN
2160: hr_utility.trace('Business Group ID : '||l_business_group_id);
2161: hr_utility.trace('Payroll ID : '||l_payroll_id);
2162: END IF;
2163:
2164: OPEN csr_element_link (l_business_group_id, l_payroll_id);
2165: FETCH csr_element_link INTO l_element_link_id;

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

2169: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure,20);
2170: RETURN FALSE;
2171: ELSE
2172: IF g_debug THEN
2173: hr_utility.trace('Element Link ID : '||l_element_link_id);
2174: END IF;
2175:
2176: CLOSE csr_element_link;
2177: --

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

2177: --
2178: OPEN csr_element_entry(l_element_link_id) ;
2179: FETCH csr_element_entry INTO p_element_entry_id, p_ee_ovn, p_start_date ;
2180: IF g_debug then
2181: hr_utility.trace('Element Entry ID : '||p_element_entry_id);
2182: END IF;
2183:
2184: IF p_element_entry_id IS NULL OR csr_element_entry%NOTFOUND
2185: THEN

Line 2224: g_debug := hr_utility.debug_enabled;

2220: l_date DATE;
2221: l_procedure VARCHAR2(250);
2222: l_message VARCHAR2(250);
2223: BEGIN
2224: g_debug := hr_utility.debug_enabled;
2225: l_procedure := g_package ||'get_date_earned';
2226: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2227: IF (g_debug)
2228: THEN

Line 2273: g_debug := hr_utility.debug_enabled;

2269: p_value number;
2270: l_procedure VARCHAR2(250);
2271: l_message VARCHAR2(250);
2272: BEGIN
2273: g_debug := hr_utility.debug_enabled;
2274: l_procedure := g_package ||'get_projected_loan_perquisite';
2275: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2276: IF (g_debug)
2277: THEN

Line 2348: g_debug := hr_utility.debug_enabled ;

2344: l_procedure VARCHAR2(100);
2345: l_message VARCHAR2(255);
2346:
2347: BEGIN
2348: g_debug := hr_utility.debug_enabled ;
2349: l_procedure := 'pay_in_tax_utils.get_perquisite_details' ;
2350: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2351: p_taxable_flag := 'Y';
2352:

Line 2375: hr_utility.trace(l_message);

2371: RETURN -1;
2372: WHEN OTHERS THEN
2373: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
2374: pay_in_utils.set_location(g_debug,' Leaving : '||l_procedure, 40);
2375: hr_utility.trace(l_message);
2376: RETURN -1;
2377:
2378: END get_perquisite_details;
2379:

Line 2471: g_debug := hr_utility.debug_enabled;

2467: l_procedure VARCHAR2(250);
2468: l_message VARCHAR2(250);
2469:
2470: BEGIN
2471: g_debug := hr_utility.debug_enabled;
2472: l_procedure := g_package ||'calculate_80gg_exemption';
2473: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2474: IF (g_debug)
2475: THEN

Line 2753: g_debug := hr_utility.debug_enabled;

2749: l_prev_emplr_prev_blk NUMBER;
2750: l_curr_emplr_curr_blk_exempted NUMBER;
2751: l_message VARCHAR2(250);
2752: BEGIN
2753: g_debug := hr_utility.debug_enabled;
2754: l_procedure := g_package ||'check_ltc_exemption';
2755: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
2756:
2757: /*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 2974: g_debug := hr_utility.debug_enabled;

2970: l_message VARCHAR2(255);
2971: l_procedure VARCHAR2(100);
2972: l_def_bal_id NUMBER ;
2973: BEGIN
2974: g_debug := hr_utility.debug_enabled;
2975: l_procedure := g_package ||'get_balance_value';
2976: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure, 10);
2977: l_message := 'SUCCESS';
2978:

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

2987: RETURN -1;
2988: END IF;
2989:
2990: IF g_debug THEN
2991: hr_utility.trace ('INDIA: Assignment Action Id : '||p_assignment_action_id);
2992: hr_utility.trace ('INDIA: Balance Name : '||p_balance_name);
2993: hr_utility.trace ('INDIA: Dimension_name : '||p_dimension_name);
2994: hr_utility.trace ('INDIA: Defined Balance Id : '||l_def_bal_id);
2995: hr_utility.trace ('INDIA: Context Name : '||p_context_name);

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

2988: END IF;
2989:
2990: IF g_debug THEN
2991: hr_utility.trace ('INDIA: Assignment Action Id : '||p_assignment_action_id);
2992: hr_utility.trace ('INDIA: Balance Name : '||p_balance_name);
2993: hr_utility.trace ('INDIA: Dimension_name : '||p_dimension_name);
2994: hr_utility.trace ('INDIA: Defined Balance Id : '||l_def_bal_id);
2995: hr_utility.trace ('INDIA: Context Name : '||p_context_name);
2996: hr_utility.trace ('INDIA: Context Value : '||p_context_value);

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

2989:
2990: IF g_debug THEN
2991: hr_utility.trace ('INDIA: Assignment Action Id : '||p_assignment_action_id);
2992: hr_utility.trace ('INDIA: Balance Name : '||p_balance_name);
2993: hr_utility.trace ('INDIA: Dimension_name : '||p_dimension_name);
2994: hr_utility.trace ('INDIA: Defined Balance Id : '||l_def_bal_id);
2995: hr_utility.trace ('INDIA: Context Name : '||p_context_name);
2996: hr_utility.trace ('INDIA: Context Value : '||p_context_value);
2997: END IF;

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

2990: IF g_debug THEN
2991: hr_utility.trace ('INDIA: Assignment Action Id : '||p_assignment_action_id);
2992: hr_utility.trace ('INDIA: Balance Name : '||p_balance_name);
2993: hr_utility.trace ('INDIA: Dimension_name : '||p_dimension_name);
2994: hr_utility.trace ('INDIA: Defined Balance Id : '||l_def_bal_id);
2995: hr_utility.trace ('INDIA: Context Name : '||p_context_name);
2996: hr_utility.trace ('INDIA: Context Value : '||p_context_value);
2997: END IF;
2998:

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

2991: hr_utility.trace ('INDIA: Assignment Action Id : '||p_assignment_action_id);
2992: hr_utility.trace ('INDIA: Balance Name : '||p_balance_name);
2993: hr_utility.trace ('INDIA: Dimension_name : '||p_dimension_name);
2994: hr_utility.trace ('INDIA: Defined Balance Id : '||l_def_bal_id);
2995: hr_utility.trace ('INDIA: Context Name : '||p_context_name);
2996: hr_utility.trace ('INDIA: Context Value : '||p_context_value);
2997: END IF;
2998:
2999: IF p_context_name = 'NULL' THEN

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

2992: hr_utility.trace ('INDIA: Balance Name : '||p_balance_name);
2993: hr_utility.trace ('INDIA: Dimension_name : '||p_dimension_name);
2994: hr_utility.trace ('INDIA: Defined Balance Id : '||l_def_bal_id);
2995: hr_utility.trace ('INDIA: Context Name : '||p_context_name);
2996: hr_utility.trace ('INDIA: Context Value : '||p_context_value);
2997: END IF;
2998:
2999: IF p_context_name = 'NULL' THEN
3000: pay_in_utils.set_location(g_debug,l_procedure, 30);

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

3108: END IF;
3109: END IF;
3110: END IF;
3111:
3112: hr_utility.trace ('INDIA: Balance Value : '||to_char(l_balance_value));
3113: pay_in_utils.set_location(g_debug,'Leaving: '||l_procedure, 120);
3114: RETURN l_balance_value;
3115:
3116: EXCEPTION

Line 3119: hr_utility.trace(l_message);

3115:
3116: EXCEPTION
3117: WHEN OTHERS THEN
3118: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
3119: hr_utility.trace(l_message);
3120: pay_in_utils.set_location(g_debug,'Leaving : '||l_procedure, 130);
3121: RETURN -1;
3122: END get_balance_value;
3123:

Line 3172: g_debug := hr_utility.debug_enabled;

3168:
3169: BEGIN
3170:
3171: l_procedure := g_package||'get_org_id';
3172: g_debug := hr_utility.debug_enabled;
3173:
3174: pay_in_utils.set_location(g_debug,'Entering : '||l_procedure, 10);
3175:
3176: OPEN cur_org (p_assignment_id

Line 3201: hr_utility.trace(l_message);

3197: EXCEPTION
3198: WHEN OTHERS THEN
3199: l_message := pay_in_utils.get_pay_message('PER_IN_ORACLE_GENERIC_ERROR', 'FUNCTION:'||l_procedure, 'SQLERRMC:'||sqlerrm);
3200: pay_in_utils.set_location(g_debug,' Leaving : '||l_procedure, 30);
3201: hr_utility.trace(l_message);
3202: RETURN NULL;
3203:
3204:
3205: END get_org_id;

Line 3253: g_debug := hr_utility.debug_enabled;

3249:
3250: l_procedure VARCHAR2(250);
3251: l_message VARCHAR2(250);
3252: BEGIN
3253: g_debug := hr_utility.debug_enabled;
3254: l_procedure := g_package ||'le_start_date';
3255: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
3256: IF (g_debug)
3257: THEN

Line 3338: g_debug := hr_utility.debug_enabled;

3334:
3335: l_procedure VARCHAR2(250);
3336: l_message VARCHAR2(250);
3337: BEGIN
3338: g_debug := hr_utility.debug_enabled;
3339: l_procedure := g_package ||'le_end_date';
3340: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
3341:
3342: IF (g_debug)

Line 3420: g_debug := hr_utility.debug_enabled;

3416: l_procedure VARCHAR2(250);
3417: l_message VARCHAR2(250);
3418:
3419: BEGIN
3420: g_debug := hr_utility.debug_enabled;
3421: l_procedure := g_package ||'get_pay_periods';
3422: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
3423: IF (g_debug)
3424: THEN

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

3438: -- Bug 12401381
3439: l_year_end := get_tax_year_end(p_payroll_id, p_period_end_date);
3440: l_year_start := get_tax_year_start(p_payroll_id, p_period_end_date);
3441:
3442: hr_utility.trace('p_payroll_id = '||to_char(p_payroll_id));
3443: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));
3444: hr_utility.trace('p_period_number = '||to_char(p_period_number));
3445: hr_utility.trace('l_year_end = '||to_char(l_year_end,'DD-MM-YYYY'));
3446: hr_utility.trace('l_year_start = '||to_char(l_year_start,'DD-MM-YYYY'));

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

3439: l_year_end := get_tax_year_end(p_payroll_id, p_period_end_date);
3440: l_year_start := get_tax_year_start(p_payroll_id, p_period_end_date);
3441:
3442: hr_utility.trace('p_payroll_id = '||to_char(p_payroll_id));
3443: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));
3444: hr_utility.trace('p_period_number = '||to_char(p_period_number));
3445: hr_utility.trace('l_year_end = '||to_char(l_year_end,'DD-MM-YYYY'));
3446: hr_utility.trace('l_year_start = '||to_char(l_year_start,'DD-MM-YYYY'));
3447:

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

3440: l_year_start := get_tax_year_start(p_payroll_id, p_period_end_date);
3441:
3442: hr_utility.trace('p_payroll_id = '||to_char(p_payroll_id));
3443: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));
3444: hr_utility.trace('p_period_number = '||to_char(p_period_number));
3445: hr_utility.trace('l_year_end = '||to_char(l_year_end,'DD-MM-YYYY'));
3446: hr_utility.trace('l_year_start = '||to_char(l_year_start,'DD-MM-YYYY'));
3447:
3448: IF p_condition = 'GRE' THEN

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

3441:
3442: hr_utility.trace('p_payroll_id = '||to_char(p_payroll_id));
3443: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));
3444: hr_utility.trace('p_period_number = '||to_char(p_period_number));
3445: hr_utility.trace('l_year_end = '||to_char(l_year_end,'DD-MM-YYYY'));
3446: hr_utility.trace('l_year_start = '||to_char(l_year_start,'DD-MM-YYYY'));
3447:
3448: IF p_condition = 'GRE' THEN
3449: l_le_end := le_end_date(p_tax_unit_id, p_assignment_id, p_date_earned);

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

3442: hr_utility.trace('p_payroll_id = '||to_char(p_payroll_id));
3443: hr_utility.trace('p_tax_unit_id = '||to_char(p_tax_unit_id));
3444: hr_utility.trace('p_period_number = '||to_char(p_period_number));
3445: hr_utility.trace('l_year_end = '||to_char(l_year_end,'DD-MM-YYYY'));
3446: hr_utility.trace('l_year_start = '||to_char(l_year_start,'DD-MM-YYYY'));
3447:
3448: IF p_condition = 'GRE' THEN
3449: l_le_end := le_end_date(p_tax_unit_id, p_assignment_id, p_date_earned);
3450: ELSE

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

3449: l_le_end := le_end_date(p_tax_unit_id, p_assignment_id, p_date_earned);
3450: ELSE
3451: l_le_end := l_year_end;
3452: END IF;
3453: hr_utility.trace('l_le_end = '||to_char(l_le_end,'DD-MM-YYYY'));
3454:
3455: l_term := GREATEST(p_termination_date, l_year_start);
3456:
3457: l_end_date := LEAST(l_year_end, l_le_end, l_term);

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

3455: l_term := GREATEST(p_termination_date, l_year_start);
3456:
3457: l_end_date := LEAST(l_year_end, l_le_end, l_term);
3458:
3459: hr_utility.trace('l_end_date = '||to_char(l_end_date,'DD-MM-YYYY'));
3460:
3461: l_tot_pay_periods := get_period_number(p_payroll_id,l_end_date);
3462: l_rem_pay_periods := GREATEST(l_tot_pay_periods - p_period_number, 0);
3463:

Line 3549: g_debug := hr_utility.debug_enabled;

3545:
3546: l_procedure VARCHAR2(250);
3547: l_message VARCHAR2(250);
3548: BEGIN
3549: g_debug := hr_utility.debug_enabled;
3550: l_procedure := g_package ||'get_income_tax';
3551: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
3552: IF (g_debug)
3553: THEN

Line 3951: g_debug := hr_utility.debug_enabled;

3947:
3948: l_procedure VARCHAR2(250);
3949: l_message VARCHAR2(250);
3950: BEGIN
3951: g_debug := hr_utility.debug_enabled;
3952: l_procedure := g_package ||'get_income_tax';
3953: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
3954: IF (g_debug)
3955: THEN

Line 4317: g_debug := hr_utility.debug_enabled;

4313:
4314: l_procedure VARCHAR2(250);
4315: l_message VARCHAR2(250);
4316: BEGIN
4317: g_debug := hr_utility.debug_enabled;
4318: l_procedure := g_package ||'set_context';
4319: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
4320: IF (g_debug)
4321: THEN

Line 4406: g_debug := hr_utility.debug_enabled;

4402: l_message VARCHAR2(250);
4403:
4404: BEGIN
4405: --
4406: g_debug := hr_utility.debug_enabled;
4407: l_proc := g_package||'get_value_on_le_start';
4408:
4409: IF (g_debug)
4410: THEN

Line 4532: g_debug := hr_utility.debug_enabled;

4528: l_procedure VARCHAR2(250);
4529: l_message VARCHAR2(250);
4530: BEGIN
4531:
4532: g_debug := hr_utility.debug_enabled;
4533: l_procedure := g_package ||'prev_med_reimbursement';
4534: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
4535: IF (g_debug)
4536: THEN

Line 4642: g_debug := hr_utility.debug_enabled;

4638: l_procedure VARCHAR2(250);
4639:
4640: BEGIN
4641:
4642: g_debug := hr_utility.debug_enabled;
4643: l_procedure := g_package ||'get_value_prev_period';
4644: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
4645:
4646:

Line 4740: g_debug := hr_utility.debug_enabled;

4736: l_exists VARCHAR2(10);
4737: l_procedure VARCHAR2(250);
4738:
4739: BEGIN
4740: g_debug := hr_utility.debug_enabled;
4741: l_procedure := g_package ||'get_regular_run_exists';
4742: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
4743:
4744: IF (g_debug)

Line 4818: g_debug := hr_utility.debug_enabled;

4814:
4815:
4816: BEGIN
4817:
4818: g_debug := hr_utility.debug_enabled;
4819: l_procedure := g_package ||'bon_section_89_relief';
4820: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
4821:
4822: IF (g_debug)

Line 4970: g_debug := hr_utility.debug_enabled;

4966:
4967: BEGIN
4968:
4969: /* 80gg Starts without bonus */
4970: g_debug := hr_utility.debug_enabled;
4971: l_procedure := g_package ||'bon_calculate_80g_gg';
4972: pay_in_utils.set_location(g_debug,'Entering: '||l_procedure,10);
4973:
4974: