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

Line 66: hr_utility.trace(' =======================================================');

62:
63: hr_cn_api.set_location(g_debug,'l_exempt_flag: '|| l_exempt_flag, 15);
64:
65: IF g_debug THEN
66: hr_utility.trace(' =======================================================');
67: hr_utility.trace(' . Exempt Flag : '||l_exempt_flag);
68: hr_utility.trace(' =======================================================');
69: END IF;
70:

Line 67: hr_utility.trace(' . Exempt Flag : '||l_exempt_flag);

63: hr_cn_api.set_location(g_debug,'l_exempt_flag: '|| l_exempt_flag, 15);
64:
65: IF g_debug THEN
66: hr_utility.trace(' =======================================================');
67: hr_utility.trace(' . Exempt Flag : '||l_exempt_flag);
68: hr_utility.trace(' =======================================================');
69: END IF;
70:
71: RETURN NVL(l_exempt_flag, 'N');

Line 68: hr_utility.trace(' =======================================================');

64:
65: IF g_debug THEN
66: hr_utility.trace(' =======================================================');
67: hr_utility.trace(' . Exempt Flag : '||l_exempt_flag);
68: hr_utility.trace(' =======================================================');
69: END IF;
70:
71: RETURN NVL(l_exempt_flag, 'N');
72:

Line 392: hr_utility.trace(l_message);

388: EXCEPTION
389: WHEN OTHERS THEN
390: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
391: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 40);
392: hr_utility.trace(l_message);
393: RETURN FALSE;
394:
395: END validate_cont_base_method;
396:

Line 464: hr_utility.trace(l_message);

460: EXCEPTION
461: WHEN OTHERS THEN
462: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
463: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 90);
464: hr_utility.trace(l_message);
465: RETURN FALSE;
466:
467:
468: END VALIDATE_SWITCH_WITH_CONT_BASE;

Line 545: hr_utility.trace(l_message);

541: EXCEPTION
542: WHEN OTHERS THEN
543: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
544: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 40);
545: hr_utility.trace(l_message);
546: RETURN FALSE;
547:
548: END validate_low_limit_method;
549:

Line 614: hr_utility.trace(l_message);

610: EXCEPTION
611: WHEN OTHERS THEN
612: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
613: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 40);
614: hr_utility.trace(l_message);
615: RETURN FALSE;
616:
617: END validate_high_limit_method;
618:

Line 648: hr_utility.trace('=======================================================');

644: BEGIN
645: g_procedure_name := g_package_name||'get_rounded_value';
646: hr_cn_api.set_location(g_debug,' Entering : '|| g_procedure_name, 10);
647: IF g_debug THEN
648: hr_utility.trace('=======================================================');
649: hr_utility.trace(' P_Value : '||TO_CHAR(p_value));
650: hr_utility.trace(' P_Rounding_Method : '||p_rounding_method);
651: END IF;
652:

Line 649: hr_utility.trace(' P_Value : '||TO_CHAR(p_value));

645: g_procedure_name := g_package_name||'get_rounded_value';
646: hr_cn_api.set_location(g_debug,' Entering : '|| g_procedure_name, 10);
647: IF g_debug THEN
648: hr_utility.trace('=======================================================');
649: hr_utility.trace(' P_Value : '||TO_CHAR(p_value));
650: hr_utility.trace(' P_Rounding_Method : '||p_rounding_method);
651: END IF;
652:
653: /* Possible rounding methods are:

Line 650: hr_utility.trace(' P_Rounding_Method : '||p_rounding_method);

646: hr_cn_api.set_location(g_debug,' Entering : '|| g_procedure_name, 10);
647: IF g_debug THEN
648: hr_utility.trace('=======================================================');
649: hr_utility.trace(' P_Value : '||TO_CHAR(p_value));
650: hr_utility.trace(' P_Rounding_Method : '||p_rounding_method);
651: END IF;
652:
653: /* Possible rounding methods are:
654: ROUND CENT Round to nearest Cent (0.01)

Line 676: hr_utility.trace(' P_Rounded_Value : '||TO_CHAR(l_amount));

672: l_amount := round(p_value,2);
673: END IF;
674:
675: IF g_debug THEN
676: hr_utility.trace(' P_Rounded_Value : '||TO_CHAR(l_amount));
677: hr_utility.trace('=======================================================');
678: END IF ;
679: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);
680: RETURN l_amount;

Line 677: hr_utility.trace('=======================================================');

673: END IF;
674:
675: IF g_debug THEN
676: hr_utility.trace(' P_Rounded_Value : '||TO_CHAR(l_amount));
677: hr_utility.trace('=======================================================');
678: END IF ;
679: hr_cn_api.set_location(g_debug,' Leaving : '|| g_procedure_name, 20);
680: RETURN l_amount;
681:

Line 686: hr_utility.trace(l_message);

682: EXCEPTION
683: WHEN OTHERS THEN
684: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
685: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 40);
686: hr_utility.trace(l_message);
687: RETURN 0;
688: END get_rounded_value;
689:
690: --------------------------------------------------------------------------

Line 901: hr_utility.trace(' =======================================================');

897:
898: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 40);
899:
900: IF g_debug THEN
901: hr_utility.trace(' =======================================================');
902: hr_utility.trace(' . EE Cont Base Method : '||p_ee_cont_base_method);
903: hr_utility.trace(' . ER Cont Base Method : '||p_er_cont_base_method);
904: hr_utility.trace(' . Low Limit Method : '||p_low_limit_method);
905: hr_utility.trace(' . Low Limit Amount : '||p_low_limit_amount);

Line 902: hr_utility.trace(' . EE Cont Base Method : '||p_ee_cont_base_method);

898: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 40);
899:
900: IF g_debug THEN
901: hr_utility.trace(' =======================================================');
902: hr_utility.trace(' . EE Cont Base Method : '||p_ee_cont_base_method);
903: hr_utility.trace(' . ER Cont Base Method : '||p_er_cont_base_method);
904: hr_utility.trace(' . Low Limit Method : '||p_low_limit_method);
905: hr_utility.trace(' . Low Limit Amount : '||p_low_limit_amount);
906: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);

Line 903: hr_utility.trace(' . ER Cont Base Method : '||p_er_cont_base_method);

899:
900: IF g_debug THEN
901: hr_utility.trace(' =======================================================');
902: hr_utility.trace(' . EE Cont Base Method : '||p_ee_cont_base_method);
903: hr_utility.trace(' . ER Cont Base Method : '||p_er_cont_base_method);
904: hr_utility.trace(' . Low Limit Method : '||p_low_limit_method);
905: hr_utility.trace(' . Low Limit Amount : '||p_low_limit_amount);
906: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);
907: hr_utility.trace(' . High Limit Amount : '||p_high_limit_amount);

Line 904: hr_utility.trace(' . Low Limit Method : '||p_low_limit_method);

900: IF g_debug THEN
901: hr_utility.trace(' =======================================================');
902: hr_utility.trace(' . EE Cont Base Method : '||p_ee_cont_base_method);
903: hr_utility.trace(' . ER Cont Base Method : '||p_er_cont_base_method);
904: hr_utility.trace(' . Low Limit Method : '||p_low_limit_method);
905: hr_utility.trace(' . Low Limit Amount : '||p_low_limit_amount);
906: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);
907: hr_utility.trace(' . High Limit Amount : '||p_high_limit_amount);
908: hr_utility.trace(' . Switch Periodicity : '||p_switch_periodicity);

Line 905: hr_utility.trace(' . Low Limit Amount : '||p_low_limit_amount);

901: hr_utility.trace(' =======================================================');
902: hr_utility.trace(' . EE Cont Base Method : '||p_ee_cont_base_method);
903: hr_utility.trace(' . ER Cont Base Method : '||p_er_cont_base_method);
904: hr_utility.trace(' . Low Limit Method : '||p_low_limit_method);
905: hr_utility.trace(' . Low Limit Amount : '||p_low_limit_amount);
906: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);
907: hr_utility.trace(' . High Limit Amount : '||p_high_limit_amount);
908: hr_utility.trace(' . Switch Periodicity : '||p_switch_periodicity);
909: hr_utility.trace(' . Switch Period Month : '||p_switch_month);

Line 906: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);

902: hr_utility.trace(' . EE Cont Base Method : '||p_ee_cont_base_method);
903: hr_utility.trace(' . ER Cont Base Method : '||p_er_cont_base_method);
904: hr_utility.trace(' . Low Limit Method : '||p_low_limit_method);
905: hr_utility.trace(' . Low Limit Amount : '||p_low_limit_amount);
906: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);
907: hr_utility.trace(' . High Limit Amount : '||p_high_limit_amount);
908: hr_utility.trace(' . Switch Periodicity : '||p_switch_periodicity);
909: hr_utility.trace(' . Switch Period Month : '||p_switch_month);
910: hr_utility.trace(' . Rounding Method : '||p_rounding_method);

Line 907: hr_utility.trace(' . High Limit Amount : '||p_high_limit_amount);

903: hr_utility.trace(' . ER Cont Base Method : '||p_er_cont_base_method);
904: hr_utility.trace(' . Low Limit Method : '||p_low_limit_method);
905: hr_utility.trace(' . Low Limit Amount : '||p_low_limit_amount);
906: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);
907: hr_utility.trace(' . High Limit Amount : '||p_high_limit_amount);
908: hr_utility.trace(' . Switch Periodicity : '||p_switch_periodicity);
909: hr_utility.trace(' . Switch Period Month : '||p_switch_month);
910: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
911: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_avg_salary);

Line 908: hr_utility.trace(' . Switch Periodicity : '||p_switch_periodicity);

904: hr_utility.trace(' . Low Limit Method : '||p_low_limit_method);
905: hr_utility.trace(' . Low Limit Amount : '||p_low_limit_amount);
906: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);
907: hr_utility.trace(' . High Limit Amount : '||p_high_limit_amount);
908: hr_utility.trace(' . Switch Periodicity : '||p_switch_periodicity);
909: hr_utility.trace(' . Switch Period Month : '||p_switch_month);
910: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
911: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_avg_salary);
912: hr_utility.trace(' . Average Salary : '||p_average_salary);

Line 909: hr_utility.trace(' . Switch Period Month : '||p_switch_month);

905: hr_utility.trace(' . Low Limit Amount : '||p_low_limit_amount);
906: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);
907: hr_utility.trace(' . High Limit Amount : '||p_high_limit_amount);
908: hr_utility.trace(' . Switch Periodicity : '||p_switch_periodicity);
909: hr_utility.trace(' . Switch Period Month : '||p_switch_month);
910: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
911: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_avg_salary);
912: hr_utility.trace(' . Average Salary : '||p_average_salary);
913: hr_utility.trace(' . EE Fixed Amount : '||p_ee_fixed_amount);

Line 910: hr_utility.trace(' . Rounding Method : '||p_rounding_method);

906: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);
907: hr_utility.trace(' . High Limit Amount : '||p_high_limit_amount);
908: hr_utility.trace(' . Switch Periodicity : '||p_switch_periodicity);
909: hr_utility.trace(' . Switch Period Month : '||p_switch_month);
910: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
911: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_avg_salary);
912: hr_utility.trace(' . Average Salary : '||p_average_salary);
913: hr_utility.trace(' . EE Fixed Amount : '||p_ee_fixed_amount);
914: hr_utility.trace(' . ER Fixed Amount : '||p_er_fixed_amount);

Line 911: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_avg_salary);

907: hr_utility.trace(' . High Limit Amount : '||p_high_limit_amount);
908: hr_utility.trace(' . Switch Periodicity : '||p_switch_periodicity);
909: hr_utility.trace(' . Switch Period Month : '||p_switch_month);
910: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
911: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_avg_salary);
912: hr_utility.trace(' . Average Salary : '||p_average_salary);
913: hr_utility.trace(' . EE Fixed Amount : '||p_ee_fixed_amount);
914: hr_utility.trace(' . ER Fixed Amount : '||p_er_fixed_amount);
915: hr_utility.trace(' . Tax Threshold Amount : '||p_tax_thrhld_amount);

Line 912: hr_utility.trace(' . Average Salary : '||p_average_salary);

908: hr_utility.trace(' . Switch Periodicity : '||p_switch_periodicity);
909: hr_utility.trace(' . Switch Period Month : '||p_switch_month);
910: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
911: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_avg_salary);
912: hr_utility.trace(' . Average Salary : '||p_average_salary);
913: hr_utility.trace(' . EE Fixed Amount : '||p_ee_fixed_amount);
914: hr_utility.trace(' . ER Fixed Amount : '||p_er_fixed_amount);
915: hr_utility.trace(' . Tax Threshold Amount : '||p_tax_thrhld_amount);
916: hr_utility.trace(' =======================================================');

Line 913: hr_utility.trace(' . EE Fixed Amount : '||p_ee_fixed_amount);

909: hr_utility.trace(' . Switch Period Month : '||p_switch_month);
910: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
911: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_avg_salary);
912: hr_utility.trace(' . Average Salary : '||p_average_salary);
913: hr_utility.trace(' . EE Fixed Amount : '||p_ee_fixed_amount);
914: hr_utility.trace(' . ER Fixed Amount : '||p_er_fixed_amount);
915: hr_utility.trace(' . Tax Threshold Amount : '||p_tax_thrhld_amount);
916: hr_utility.trace(' =======================================================');
917: END IF;

Line 914: hr_utility.trace(' . ER Fixed Amount : '||p_er_fixed_amount);

910: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
911: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_avg_salary);
912: hr_utility.trace(' . Average Salary : '||p_average_salary);
913: hr_utility.trace(' . EE Fixed Amount : '||p_ee_fixed_amount);
914: hr_utility.trace(' . ER Fixed Amount : '||p_er_fixed_amount);
915: hr_utility.trace(' . Tax Threshold Amount : '||p_tax_thrhld_amount);
916: hr_utility.trace(' =======================================================');
917: END IF;
918:

Line 915: hr_utility.trace(' . Tax Threshold Amount : '||p_tax_thrhld_amount);

911: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_avg_salary);
912: hr_utility.trace(' . Average Salary : '||p_average_salary);
913: hr_utility.trace(' . EE Fixed Amount : '||p_ee_fixed_amount);
914: hr_utility.trace(' . ER Fixed Amount : '||p_er_fixed_amount);
915: hr_utility.trace(' . Tax Threshold Amount : '||p_tax_thrhld_amount);
916: hr_utility.trace(' =======================================================');
917: END IF;
918:
919: IF l_found_flag = 'N' THEN

Line 916: hr_utility.trace(' =======================================================');

912: hr_utility.trace(' . Average Salary : '||p_average_salary);
913: hr_utility.trace(' . EE Fixed Amount : '||p_ee_fixed_amount);
914: hr_utility.trace(' . ER Fixed Amount : '||p_er_fixed_amount);
915: hr_utility.trace(' . Tax Threshold Amount : '||p_tax_thrhld_amount);
916: hr_utility.trace(' =======================================================');
917: END IF;
918:
919: IF l_found_flag = 'N' THEN
920: --Bug 3034481

Line 955: hr_utility.trace(l_message);

951: CLOSE c_cont2;
952: END IF;
953:
954: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
955: hr_utility.trace(l_message);
956: RETURN l_message;
957:
958: END get_cont_base_methods;
959:

Line 1288: hr_utility.trace(' =======================================================');

1284: CLOSE c_annuity_round;
1285:
1286:
1287: IF g_debug THEN
1288: hr_utility.trace(' =======================================================');
1289: hr_utility.trace(' . EE Rate : '||p_ee_rate);
1290: hr_utility.trace(' . EE Rate Type : '||p_ee_rate_type);
1291: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);
1292: hr_utility.trace(' . ER Rate : '||p_er_rate);

Line 1289: hr_utility.trace(' . EE Rate : '||p_ee_rate);

1285:
1286:
1287: IF g_debug THEN
1288: hr_utility.trace(' =======================================================');
1289: hr_utility.trace(' . EE Rate : '||p_ee_rate);
1290: hr_utility.trace(' . EE Rate Type : '||p_ee_rate_type);
1291: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);
1292: hr_utility.trace(' . ER Rate : '||p_er_rate);
1293: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);

Line 1290: hr_utility.trace(' . EE Rate Type : '||p_ee_rate_type);

1286:
1287: IF g_debug THEN
1288: hr_utility.trace(' =======================================================');
1289: hr_utility.trace(' . EE Rate : '||p_ee_rate);
1290: hr_utility.trace(' . EE Rate Type : '||p_ee_rate_type);
1291: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);
1292: hr_utility.trace(' . ER Rate : '||p_er_rate);
1293: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);
1294: hr_utility.trace(' . ER Rounding Method : '||p_er_rounding_method);

Line 1291: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);

1287: IF g_debug THEN
1288: hr_utility.trace(' =======================================================');
1289: hr_utility.trace(' . EE Rate : '||p_ee_rate);
1290: hr_utility.trace(' . EE Rate Type : '||p_ee_rate_type);
1291: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);
1292: hr_utility.trace(' . ER Rate : '||p_er_rate);
1293: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);
1294: hr_utility.trace(' . ER Rounding Method : '||p_er_rounding_method);
1295: hr_utility.trace(' =======================================================');

Line 1292: hr_utility.trace(' . ER Rate : '||p_er_rate);

1288: hr_utility.trace(' =======================================================');
1289: hr_utility.trace(' . EE Rate : '||p_ee_rate);
1290: hr_utility.trace(' . EE Rate Type : '||p_ee_rate_type);
1291: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);
1292: hr_utility.trace(' . ER Rate : '||p_er_rate);
1293: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);
1294: hr_utility.trace(' . ER Rounding Method : '||p_er_rounding_method);
1295: hr_utility.trace(' =======================================================');
1296: END IF;

Line 1293: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);

1289: hr_utility.trace(' . EE Rate : '||p_ee_rate);
1290: hr_utility.trace(' . EE Rate Type : '||p_ee_rate_type);
1291: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);
1292: hr_utility.trace(' . ER Rate : '||p_er_rate);
1293: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);
1294: hr_utility.trace(' . ER Rounding Method : '||p_er_rounding_method);
1295: hr_utility.trace(' =======================================================');
1296: END IF;
1297:

Line 1294: hr_utility.trace(' . ER Rounding Method : '||p_er_rounding_method);

1290: hr_utility.trace(' . EE Rate Type : '||p_ee_rate_type);
1291: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);
1292: hr_utility.trace(' . ER Rate : '||p_er_rate);
1293: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);
1294: hr_utility.trace(' . ER Rounding Method : '||p_er_rounding_method);
1295: hr_utility.trace(' =======================================================');
1296: END IF;
1297:
1298: RETURN l_message;

Line 1295: hr_utility.trace(' =======================================================');

1291: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);
1292: hr_utility.trace(' . ER Rate : '||p_er_rate);
1293: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);
1294: hr_utility.trace(' . ER Rounding Method : '||p_er_rounding_method);
1295: hr_utility.trace(' =======================================================');
1296: END IF;
1297:
1298: RETURN l_message;
1299: END IF;

Line 1371: hr_utility.trace(l_message);

1367: IF c_org4%NOTFOUND THEN
1368: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 50);
1369: l_message := hr_cn_api.get_pay_message('HR_374608_PHF_SI_RATES_MISSING','PHFSI:'||p_phf_si_type);
1370: IF g_debug THEN
1371: hr_utility.trace(l_message);
1372: END IF;
1373: END IF;
1374: CLOSE c_org4;
1375: END IF;

Line 1411: hr_utility.trace(' =======================================================');

1407: --
1408:
1409:
1410: IF g_debug THEN
1411: hr_utility.trace(' =======================================================');
1412: hr_utility.trace(' . EE Rate : '||p_ee_rate);
1413: hr_utility.trace(' . EE Rate Type : '||p_ee_rate_type);
1414: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);
1415: hr_utility.trace(' . ER Rate : '||p_er_rate);

Line 1412: hr_utility.trace(' . EE Rate : '||p_ee_rate);

1408:
1409:
1410: IF g_debug THEN
1411: hr_utility.trace(' =======================================================');
1412: hr_utility.trace(' . EE Rate : '||p_ee_rate);
1413: hr_utility.trace(' . EE Rate Type : '||p_ee_rate_type);
1414: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);
1415: hr_utility.trace(' . ER Rate : '||p_er_rate);
1416: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);

Line 1413: hr_utility.trace(' . EE Rate Type : '||p_ee_rate_type);

1409:
1410: IF g_debug THEN
1411: hr_utility.trace(' =======================================================');
1412: hr_utility.trace(' . EE Rate : '||p_ee_rate);
1413: hr_utility.trace(' . EE Rate Type : '||p_ee_rate_type);
1414: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);
1415: hr_utility.trace(' . ER Rate : '||p_er_rate);
1416: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);
1417: hr_utility.trace(' . ER Rounding Method : '||p_er_rounding_method);

Line 1414: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);

1410: IF g_debug THEN
1411: hr_utility.trace(' =======================================================');
1412: hr_utility.trace(' . EE Rate : '||p_ee_rate);
1413: hr_utility.trace(' . EE Rate Type : '||p_ee_rate_type);
1414: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);
1415: hr_utility.trace(' . ER Rate : '||p_er_rate);
1416: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);
1417: hr_utility.trace(' . ER Rounding Method : '||p_er_rounding_method);
1418: hr_utility.trace(' . EE Tax Threshold Rate : '||p_ee_thrhld_rate);

Line 1415: hr_utility.trace(' . ER Rate : '||p_er_rate);

1411: hr_utility.trace(' =======================================================');
1412: hr_utility.trace(' . EE Rate : '||p_ee_rate);
1413: hr_utility.trace(' . EE Rate Type : '||p_ee_rate_type);
1414: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);
1415: hr_utility.trace(' . ER Rate : '||p_er_rate);
1416: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);
1417: hr_utility.trace(' . ER Rounding Method : '||p_er_rounding_method);
1418: hr_utility.trace(' . EE Tax Threshold Rate : '||p_ee_thrhld_rate);
1419: hr_utility.trace(' . ER Tax Threshold Rate : '||p_er_thrhld_rate);

Line 1416: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);

1412: hr_utility.trace(' . EE Rate : '||p_ee_rate);
1413: hr_utility.trace(' . EE Rate Type : '||p_ee_rate_type);
1414: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);
1415: hr_utility.trace(' . ER Rate : '||p_er_rate);
1416: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);
1417: hr_utility.trace(' . ER Rounding Method : '||p_er_rounding_method);
1418: hr_utility.trace(' . EE Tax Threshold Rate : '||p_ee_thrhld_rate);
1419: hr_utility.trace(' . ER Tax Threshold Rate : '||p_er_thrhld_rate);
1420: hr_utility.trace(' =======================================================');

Line 1417: hr_utility.trace(' . ER Rounding Method : '||p_er_rounding_method);

1413: hr_utility.trace(' . EE Rate Type : '||p_ee_rate_type);
1414: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);
1415: hr_utility.trace(' . ER Rate : '||p_er_rate);
1416: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);
1417: hr_utility.trace(' . ER Rounding Method : '||p_er_rounding_method);
1418: hr_utility.trace(' . EE Tax Threshold Rate : '||p_ee_thrhld_rate);
1419: hr_utility.trace(' . ER Tax Threshold Rate : '||p_er_thrhld_rate);
1420: hr_utility.trace(' =======================================================');
1421: END IF;

Line 1418: hr_utility.trace(' . EE Tax Threshold Rate : '||p_ee_thrhld_rate);

1414: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);
1415: hr_utility.trace(' . ER Rate : '||p_er_rate);
1416: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);
1417: hr_utility.trace(' . ER Rounding Method : '||p_er_rounding_method);
1418: hr_utility.trace(' . EE Tax Threshold Rate : '||p_ee_thrhld_rate);
1419: hr_utility.trace(' . ER Tax Threshold Rate : '||p_er_thrhld_rate);
1420: hr_utility.trace(' =======================================================');
1421: END IF;
1422:

Line 1419: hr_utility.trace(' . ER Tax Threshold Rate : '||p_er_thrhld_rate);

1415: hr_utility.trace(' . ER Rate : '||p_er_rate);
1416: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);
1417: hr_utility.trace(' . ER Rounding Method : '||p_er_rounding_method);
1418: hr_utility.trace(' . EE Tax Threshold Rate : '||p_ee_thrhld_rate);
1419: hr_utility.trace(' . ER Tax Threshold Rate : '||p_er_thrhld_rate);
1420: hr_utility.trace(' =======================================================');
1421: END IF;
1422:
1423: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 70);

Line 1420: hr_utility.trace(' =======================================================');

1416: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);
1417: hr_utility.trace(' . ER Rounding Method : '||p_er_rounding_method);
1418: hr_utility.trace(' . EE Tax Threshold Rate : '||p_ee_thrhld_rate);
1419: hr_utility.trace(' . ER Tax Threshold Rate : '||p_er_thrhld_rate);
1420: hr_utility.trace(' =======================================================');
1421: END IF;
1422:
1423: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 70);
1424: RETURN l_message;

Line 1559: hr_utility.trace(' ==============================================');

1555:
1556: p_cont_base_amount := l_cont_base_amount;
1557:
1558: IF g_debug THEN
1559: hr_utility.trace(' ==============================================');
1560: hr_utility.trace(' . Cont Base Method : '||p_cont_base_method);
1561: hr_utility.trace(' . PHF_SI_EARNINGS (PTD) : '||p_phf_si_earnings_asg_ptd);
1562: hr_utility.trace(' . PHF_SI_EARNINGS (PMTH): '||p_phf_si_earnings_asg_pmth);
1563: hr_utility.trace(' . PHF_SI_EARNINGS (AVG) : '||p_phf_si_earnings_asg_avg);

Line 1560: hr_utility.trace(' . Cont Base Method : '||p_cont_base_method);

1556: p_cont_base_amount := l_cont_base_amount;
1557:
1558: IF g_debug THEN
1559: hr_utility.trace(' ==============================================');
1560: hr_utility.trace(' . Cont Base Method : '||p_cont_base_method);
1561: hr_utility.trace(' . PHF_SI_EARNINGS (PTD) : '||p_phf_si_earnings_asg_ptd);
1562: hr_utility.trace(' . PHF_SI_EARNINGS (PMTH): '||p_phf_si_earnings_asg_pmth);
1563: hr_utility.trace(' . PHF_SI_EARNINGS (AVG) : '||p_phf_si_earnings_asg_avg);
1564: hr_utility.trace(' . Average Salary : '||p_average_salary);

Line 1561: hr_utility.trace(' . PHF_SI_EARNINGS (PTD) : '||p_phf_si_earnings_asg_ptd);

1557:
1558: IF g_debug THEN
1559: hr_utility.trace(' ==============================================');
1560: hr_utility.trace(' . Cont Base Method : '||p_cont_base_method);
1561: hr_utility.trace(' . PHF_SI_EARNINGS (PTD) : '||p_phf_si_earnings_asg_ptd);
1562: hr_utility.trace(' . PHF_SI_EARNINGS (PMTH): '||p_phf_si_earnings_asg_pmth);
1563: hr_utility.trace(' . PHF_SI_EARNINGS (AVG) : '||p_phf_si_earnings_asg_avg);
1564: hr_utility.trace(' . Average Salary : '||p_average_salary);
1565: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_average_salary);

Line 1562: hr_utility.trace(' . PHF_SI_EARNINGS (PMTH): '||p_phf_si_earnings_asg_pmth);

1558: IF g_debug THEN
1559: hr_utility.trace(' ==============================================');
1560: hr_utility.trace(' . Cont Base Method : '||p_cont_base_method);
1561: hr_utility.trace(' . PHF_SI_EARNINGS (PTD) : '||p_phf_si_earnings_asg_ptd);
1562: hr_utility.trace(' . PHF_SI_EARNINGS (PMTH): '||p_phf_si_earnings_asg_pmth);
1563: hr_utility.trace(' . PHF_SI_EARNINGS (AVG) : '||p_phf_si_earnings_asg_avg);
1564: hr_utility.trace(' . Average Salary : '||p_average_salary);
1565: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_average_salary);
1566: hr_utility.trace(' . Fixed Amount : '||p_fixed_amount);

Line 1563: hr_utility.trace(' . PHF_SI_EARNINGS (AVG) : '||p_phf_si_earnings_asg_avg);

1559: hr_utility.trace(' ==============================================');
1560: hr_utility.trace(' . Cont Base Method : '||p_cont_base_method);
1561: hr_utility.trace(' . PHF_SI_EARNINGS (PTD) : '||p_phf_si_earnings_asg_ptd);
1562: hr_utility.trace(' . PHF_SI_EARNINGS (PMTH): '||p_phf_si_earnings_asg_pmth);
1563: hr_utility.trace(' . PHF_SI_EARNINGS (AVG) : '||p_phf_si_earnings_asg_avg);
1564: hr_utility.trace(' . Average Salary : '||p_average_salary);
1565: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_average_salary);
1566: hr_utility.trace(' . Fixed Amount : '||p_fixed_amount);
1567: hr_utility.trace(' . Cont Base Amount : '||p_cont_base_amount);

Line 1564: hr_utility.trace(' . Average Salary : '||p_average_salary);

1560: hr_utility.trace(' . Cont Base Method : '||p_cont_base_method);
1561: hr_utility.trace(' . PHF_SI_EARNINGS (PTD) : '||p_phf_si_earnings_asg_ptd);
1562: hr_utility.trace(' . PHF_SI_EARNINGS (PMTH): '||p_phf_si_earnings_asg_pmth);
1563: hr_utility.trace(' . PHF_SI_EARNINGS (AVG) : '||p_phf_si_earnings_asg_avg);
1564: hr_utility.trace(' . Average Salary : '||p_average_salary);
1565: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_average_salary);
1566: hr_utility.trace(' . Fixed Amount : '||p_fixed_amount);
1567: hr_utility.trace(' . Cont Base Amount : '||p_cont_base_amount);
1568: hr_utility.trace(' ==============================================');

Line 1565: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_average_salary);

1561: hr_utility.trace(' . PHF_SI_EARNINGS (PTD) : '||p_phf_si_earnings_asg_ptd);
1562: hr_utility.trace(' . PHF_SI_EARNINGS (PMTH): '||p_phf_si_earnings_asg_pmth);
1563: hr_utility.trace(' . PHF_SI_EARNINGS (AVG) : '||p_phf_si_earnings_asg_avg);
1564: hr_utility.trace(' . Average Salary : '||p_average_salary);
1565: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_average_salary);
1566: hr_utility.trace(' . Fixed Amount : '||p_fixed_amount);
1567: hr_utility.trace(' . Cont Base Amount : '||p_cont_base_amount);
1568: hr_utility.trace(' ==============================================');
1569: END IF;

Line 1566: hr_utility.trace(' . Fixed Amount : '||p_fixed_amount);

1562: hr_utility.trace(' . PHF_SI_EARNINGS (PMTH): '||p_phf_si_earnings_asg_pmth);
1563: hr_utility.trace(' . PHF_SI_EARNINGS (AVG) : '||p_phf_si_earnings_asg_avg);
1564: hr_utility.trace(' . Average Salary : '||p_average_salary);
1565: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_average_salary);
1566: hr_utility.trace(' . Fixed Amount : '||p_fixed_amount);
1567: hr_utility.trace(' . Cont Base Amount : '||p_cont_base_amount);
1568: hr_utility.trace(' ==============================================');
1569: END IF;
1570:

Line 1567: hr_utility.trace(' . Cont Base Amount : '||p_cont_base_amount);

1563: hr_utility.trace(' . PHF_SI_EARNINGS (AVG) : '||p_phf_si_earnings_asg_avg);
1564: hr_utility.trace(' . Average Salary : '||p_average_salary);
1565: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_average_salary);
1566: hr_utility.trace(' . Fixed Amount : '||p_fixed_amount);
1567: hr_utility.trace(' . Cont Base Amount : '||p_cont_base_amount);
1568: hr_utility.trace(' ==============================================');
1569: END IF;
1570:
1571: l_message:='SUCCESS';

Line 1568: hr_utility.trace(' ==============================================');

1564: hr_utility.trace(' . Average Salary : '||p_average_salary);
1565: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_average_salary);
1566: hr_utility.trace(' . Fixed Amount : '||p_fixed_amount);
1567: hr_utility.trace(' . Cont Base Amount : '||p_cont_base_amount);
1568: hr_utility.trace(' ==============================================');
1569: END IF;
1570:
1571: l_message:='SUCCESS';
1572: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 130);

Line 1579: hr_utility.trace(l_message);

1575: EXCEPTION
1576: WHEN OTHERS THEN
1577: p_cont_base_amount := hr_api.g_number;
1578: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
1579: hr_utility.trace(l_message);
1580: RETURN l_message;
1581: END get_cont_base_amount;
1582:
1583: --------------------------------------------------------------------------

Line 1666: hr_utility.trace(' ==============================================');

1662: -- Bug 3555258 changes end
1663: --
1664:
1665: IF g_debug THEN
1666: hr_utility.trace(' ==============================================');
1667: hr_utility.trace(' . Switch Periodicity : '||p_switch_periodicity);
1668: hr_utility.trace(' . Switch Month : '||p_switch_month);
1669: hr_utility.trace(' . Calculation Date : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
1670: hr_utility.trace(' . Process Date : '||TO_CHAR(p_process_date, 'DD-MM-YYYY'));

Line 1667: hr_utility.trace(' . Switch Periodicity : '||p_switch_periodicity);

1663: --
1664:
1665: IF g_debug THEN
1666: hr_utility.trace(' ==============================================');
1667: hr_utility.trace(' . Switch Periodicity : '||p_switch_periodicity);
1668: hr_utility.trace(' . Switch Month : '||p_switch_month);
1669: hr_utility.trace(' . Calculation Date : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
1670: hr_utility.trace(' . Process Date : '||TO_CHAR(p_process_date, 'DD-MM-YYYY'));
1671: hr_utility.trace(' . Temporary Date : '||TO_CHAR(l_temp_date,'DD-MM-YYYY'));

Line 1668: hr_utility.trace(' . Switch Month : '||p_switch_month);

1664:
1665: IF g_debug THEN
1666: hr_utility.trace(' ==============================================');
1667: hr_utility.trace(' . Switch Periodicity : '||p_switch_periodicity);
1668: hr_utility.trace(' . Switch Month : '||p_switch_month);
1669: hr_utility.trace(' . Calculation Date : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
1670: hr_utility.trace(' . Process Date : '||TO_CHAR(p_process_date, 'DD-MM-YYYY'));
1671: hr_utility.trace(' . Temporary Date : '||TO_CHAR(l_temp_date,'DD-MM-YYYY'));
1672: hr_utility.trace(' . Recalculate Flag : '||l_return_value);

Line 1669: hr_utility.trace(' . Calculation Date : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));

1665: IF g_debug THEN
1666: hr_utility.trace(' ==============================================');
1667: hr_utility.trace(' . Switch Periodicity : '||p_switch_periodicity);
1668: hr_utility.trace(' . Switch Month : '||p_switch_month);
1669: hr_utility.trace(' . Calculation Date : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
1670: hr_utility.trace(' . Process Date : '||TO_CHAR(p_process_date, 'DD-MM-YYYY'));
1671: hr_utility.trace(' . Temporary Date : '||TO_CHAR(l_temp_date,'DD-MM-YYYY'));
1672: hr_utility.trace(' . Recalculate Flag : '||l_return_value);
1673: hr_utility.trace(' ==============================================');

Line 1670: hr_utility.trace(' . Process Date : '||TO_CHAR(p_process_date, 'DD-MM-YYYY'));

1666: hr_utility.trace(' ==============================================');
1667: hr_utility.trace(' . Switch Periodicity : '||p_switch_periodicity);
1668: hr_utility.trace(' . Switch Month : '||p_switch_month);
1669: hr_utility.trace(' . Calculation Date : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
1670: hr_utility.trace(' . Process Date : '||TO_CHAR(p_process_date, 'DD-MM-YYYY'));
1671: hr_utility.trace(' . Temporary Date : '||TO_CHAR(l_temp_date,'DD-MM-YYYY'));
1672: hr_utility.trace(' . Recalculate Flag : '||l_return_value);
1673: hr_utility.trace(' ==============================================');
1674: END IF;

Line 1671: hr_utility.trace(' . Temporary Date : '||TO_CHAR(l_temp_date,'DD-MM-YYYY'));

1667: hr_utility.trace(' . Switch Periodicity : '||p_switch_periodicity);
1668: hr_utility.trace(' . Switch Month : '||p_switch_month);
1669: hr_utility.trace(' . Calculation Date : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
1670: hr_utility.trace(' . Process Date : '||TO_CHAR(p_process_date, 'DD-MM-YYYY'));
1671: hr_utility.trace(' . Temporary Date : '||TO_CHAR(l_temp_date,'DD-MM-YYYY'));
1672: hr_utility.trace(' . Recalculate Flag : '||l_return_value);
1673: hr_utility.trace(' ==============================================');
1674: END IF;
1675: --

Line 1672: hr_utility.trace(' . Recalculate Flag : '||l_return_value);

1668: hr_utility.trace(' . Switch Month : '||p_switch_month);
1669: hr_utility.trace(' . Calculation Date : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
1670: hr_utility.trace(' . Process Date : '||TO_CHAR(p_process_date, 'DD-MM-YYYY'));
1671: hr_utility.trace(' . Temporary Date : '||TO_CHAR(l_temp_date,'DD-MM-YYYY'));
1672: hr_utility.trace(' . Recalculate Flag : '||l_return_value);
1673: hr_utility.trace(' ==============================================');
1674: END IF;
1675: --
1676: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 50);

Line 1673: hr_utility.trace(' ==============================================');

1669: hr_utility.trace(' . Calculation Date : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
1670: hr_utility.trace(' . Process Date : '||TO_CHAR(p_process_date, 'DD-MM-YYYY'));
1671: hr_utility.trace(' . Temporary Date : '||TO_CHAR(l_temp_date,'DD-MM-YYYY'));
1672: hr_utility.trace(' . Recalculate Flag : '||l_return_value);
1673: hr_utility.trace(' ==============================================');
1674: END IF;
1675: --
1676: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 50);
1677: RETURN l_return_value;

Line 1682: hr_utility.trace (l_message);

1678: --
1679: EXCEPTION
1680: WHEN OTHERS THEN
1681: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
1682: hr_utility.trace (l_message);
1683: RETURN 'E';
1684: END get_recalculate_flag;
1685:
1686:

Line 1815: hr_utility.trace(' ==============================================');

1811:
1812: p_amount := get_rounded_value(l_amount,p_rounding_method);
1813:
1814: IF g_debug THEN
1815: hr_utility.trace(' ==============================================');
1816: hr_utility.trace(' . Low Limit Method : '||p_low_limit_method);
1817: hr_utility.trace(' . Low Limit Amount : '||l_low_limit_amount);
1818: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);
1819: hr_utility.trace(' . High Limit Amount : '||l_high_limit_amount);

Line 1816: hr_utility.trace(' . Low Limit Method : '||p_low_limit_method);

1812: p_amount := get_rounded_value(l_amount,p_rounding_method);
1813:
1814: IF g_debug THEN
1815: hr_utility.trace(' ==============================================');
1816: hr_utility.trace(' . Low Limit Method : '||p_low_limit_method);
1817: hr_utility.trace(' . Low Limit Amount : '||l_low_limit_amount);
1818: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);
1819: hr_utility.trace(' . High Limit Amount : '||l_high_limit_amount);
1820: hr_utility.trace(' . Amount In Limit is : '||l_amount);

Line 1817: hr_utility.trace(' . Low Limit Amount : '||l_low_limit_amount);

1813:
1814: IF g_debug THEN
1815: hr_utility.trace(' ==============================================');
1816: hr_utility.trace(' . Low Limit Method : '||p_low_limit_method);
1817: hr_utility.trace(' . Low Limit Amount : '||l_low_limit_amount);
1818: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);
1819: hr_utility.trace(' . High Limit Amount : '||l_high_limit_amount);
1820: hr_utility.trace(' . Amount In Limit is : '||l_amount);
1821: hr_utility.trace(' . Rounding Method : '||p_rounding_method);

Line 1818: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);

1814: IF g_debug THEN
1815: hr_utility.trace(' ==============================================');
1816: hr_utility.trace(' . Low Limit Method : '||p_low_limit_method);
1817: hr_utility.trace(' . Low Limit Amount : '||l_low_limit_amount);
1818: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);
1819: hr_utility.trace(' . High Limit Amount : '||l_high_limit_amount);
1820: hr_utility.trace(' . Amount In Limit is : '||l_amount);
1821: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
1822: hr_utility.trace(' . Rounded Amount : '||p_amount);

Line 1819: hr_utility.trace(' . High Limit Amount : '||l_high_limit_amount);

1815: hr_utility.trace(' ==============================================');
1816: hr_utility.trace(' . Low Limit Method : '||p_low_limit_method);
1817: hr_utility.trace(' . Low Limit Amount : '||l_low_limit_amount);
1818: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);
1819: hr_utility.trace(' . High Limit Amount : '||l_high_limit_amount);
1820: hr_utility.trace(' . Amount In Limit is : '||l_amount);
1821: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
1822: hr_utility.trace(' . Rounded Amount : '||p_amount);
1823: hr_utility.trace(' ==============================================');

Line 1820: hr_utility.trace(' . Amount In Limit is : '||l_amount);

1816: hr_utility.trace(' . Low Limit Method : '||p_low_limit_method);
1817: hr_utility.trace(' . Low Limit Amount : '||l_low_limit_amount);
1818: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);
1819: hr_utility.trace(' . High Limit Amount : '||l_high_limit_amount);
1820: hr_utility.trace(' . Amount In Limit is : '||l_amount);
1821: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
1822: hr_utility.trace(' . Rounded Amount : '||p_amount);
1823: hr_utility.trace(' ==============================================');
1824: END IF;

Line 1821: hr_utility.trace(' . Rounding Method : '||p_rounding_method);

1817: hr_utility.trace(' . Low Limit Amount : '||l_low_limit_amount);
1818: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);
1819: hr_utility.trace(' . High Limit Amount : '||l_high_limit_amount);
1820: hr_utility.trace(' . Amount In Limit is : '||l_amount);
1821: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
1822: hr_utility.trace(' . Rounded Amount : '||p_amount);
1823: hr_utility.trace(' ==============================================');
1824: END IF;
1825: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 20);

Line 1822: hr_utility.trace(' . Rounded Amount : '||p_amount);

1818: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);
1819: hr_utility.trace(' . High Limit Amount : '||l_high_limit_amount);
1820: hr_utility.trace(' . Amount In Limit is : '||l_amount);
1821: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
1822: hr_utility.trace(' . Rounded Amount : '||p_amount);
1823: hr_utility.trace(' ==============================================');
1824: END IF;
1825: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 20);
1826:

Line 1823: hr_utility.trace(' ==============================================');

1819: hr_utility.trace(' . High Limit Amount : '||l_high_limit_amount);
1820: hr_utility.trace(' . Amount In Limit is : '||l_amount);
1821: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
1822: hr_utility.trace(' . Rounded Amount : '||p_amount);
1823: hr_utility.trace(' ==============================================');
1824: END IF;
1825: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 20);
1826:
1827: EXCEPTION

Line 1830: hr_utility.trace (p_message);

1826:
1827: EXCEPTION
1828: WHEN OTHERS THEN
1829: p_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
1830: hr_utility.trace (p_message);
1831:
1832: END get_in_limit;
1833:
1834: --------------------------------------------------------------------------

Line 2084: hr_utility.trace(' ==============================================');

2080: CLOSE c_exists;
2081: --
2082: hr_cn_api.set_location(g_debug,' ' || g_procedure_name,40);
2083: IF g_debug THEN
2084: hr_utility.trace(' ==============================================');
2085: hr_utility.trace ('. Calling pay_element_entry_api.');
2086: hr_utility.trace ('. Element Entry : '||TO_CHAR(p_element_entry_id));
2087: hr_utility.trace ('. Effective Date : '||TO_CHAR(p_calculation_date+1,'DD-MM-YYYY'));
2088: hr_utility.trace ('. Input Value Id : '||TO_CHAR(l_iv_id));

Line 2085: hr_utility.trace ('. Calling pay_element_entry_api.');

2081: --
2082: hr_cn_api.set_location(g_debug,' ' || g_procedure_name,40);
2083: IF g_debug THEN
2084: hr_utility.trace(' ==============================================');
2085: hr_utility.trace ('. Calling pay_element_entry_api.');
2086: hr_utility.trace ('. Element Entry : '||TO_CHAR(p_element_entry_id));
2087: hr_utility.trace ('. Effective Date : '||TO_CHAR(p_calculation_date+1,'DD-MM-YYYY'));
2088: hr_utility.trace ('. Input Value Id : '||TO_CHAR(l_iv_id));
2089: hr_utility.trace ('. Entry Value : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));

Line 2086: hr_utility.trace ('. Element Entry : '||TO_CHAR(p_element_entry_id));

2082: hr_cn_api.set_location(g_debug,' ' || g_procedure_name,40);
2083: IF g_debug THEN
2084: hr_utility.trace(' ==============================================');
2085: hr_utility.trace ('. Calling pay_element_entry_api.');
2086: hr_utility.trace ('. Element Entry : '||TO_CHAR(p_element_entry_id));
2087: hr_utility.trace ('. Effective Date : '||TO_CHAR(p_calculation_date+1,'DD-MM-YYYY'));
2088: hr_utility.trace ('. Input Value Id : '||TO_CHAR(l_iv_id));
2089: hr_utility.trace ('. Entry Value : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
2090: hr_utility.trace ('. OVN : '||to_char(l_ovn));

Line 2087: hr_utility.trace ('. Effective Date : '||TO_CHAR(p_calculation_date+1,'DD-MM-YYYY'));

2083: IF g_debug THEN
2084: hr_utility.trace(' ==============================================');
2085: hr_utility.trace ('. Calling pay_element_entry_api.');
2086: hr_utility.trace ('. Element Entry : '||TO_CHAR(p_element_entry_id));
2087: hr_utility.trace ('. Effective Date : '||TO_CHAR(p_calculation_date+1,'DD-MM-YYYY'));
2088: hr_utility.trace ('. Input Value Id : '||TO_CHAR(l_iv_id));
2089: hr_utility.trace ('. Entry Value : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
2090: hr_utility.trace ('. OVN : '||to_char(l_ovn));
2091: hr_utility.trace ('. Date-track Mode : '||l_upd_mode);

Line 2088: hr_utility.trace ('. Input Value Id : '||TO_CHAR(l_iv_id));

2084: hr_utility.trace(' ==============================================');
2085: hr_utility.trace ('. Calling pay_element_entry_api.');
2086: hr_utility.trace ('. Element Entry : '||TO_CHAR(p_element_entry_id));
2087: hr_utility.trace ('. Effective Date : '||TO_CHAR(p_calculation_date+1,'DD-MM-YYYY'));
2088: hr_utility.trace ('. Input Value Id : '||TO_CHAR(l_iv_id));
2089: hr_utility.trace ('. Entry Value : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
2090: hr_utility.trace ('. OVN : '||to_char(l_ovn));
2091: hr_utility.trace ('. Date-track Mode : '||l_upd_mode);
2092: hr_utility.trace(' ==============================================');

Line 2089: hr_utility.trace ('. Entry Value : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));

2085: hr_utility.trace ('. Calling pay_element_entry_api.');
2086: hr_utility.trace ('. Element Entry : '||TO_CHAR(p_element_entry_id));
2087: hr_utility.trace ('. Effective Date : '||TO_CHAR(p_calculation_date+1,'DD-MM-YYYY'));
2088: hr_utility.trace ('. Input Value Id : '||TO_CHAR(l_iv_id));
2089: hr_utility.trace ('. Entry Value : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
2090: hr_utility.trace ('. OVN : '||to_char(l_ovn));
2091: hr_utility.trace ('. Date-track Mode : '||l_upd_mode);
2092: hr_utility.trace(' ==============================================');
2093: END IF;

Line 2090: hr_utility.trace ('. OVN : '||to_char(l_ovn));

2086: hr_utility.trace ('. Element Entry : '||TO_CHAR(p_element_entry_id));
2087: hr_utility.trace ('. Effective Date : '||TO_CHAR(p_calculation_date+1,'DD-MM-YYYY'));
2088: hr_utility.trace ('. Input Value Id : '||TO_CHAR(l_iv_id));
2089: hr_utility.trace ('. Entry Value : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
2090: hr_utility.trace ('. OVN : '||to_char(l_ovn));
2091: hr_utility.trace ('. Date-track Mode : '||l_upd_mode);
2092: hr_utility.trace(' ==============================================');
2093: END IF;
2094:

Line 2091: hr_utility.trace ('. Date-track Mode : '||l_upd_mode);

2087: hr_utility.trace ('. Effective Date : '||TO_CHAR(p_calculation_date+1,'DD-MM-YYYY'));
2088: hr_utility.trace ('. Input Value Id : '||TO_CHAR(l_iv_id));
2089: hr_utility.trace ('. Entry Value : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
2090: hr_utility.trace ('. OVN : '||to_char(l_ovn));
2091: hr_utility.trace ('. Date-track Mode : '||l_upd_mode);
2092: hr_utility.trace(' ==============================================');
2093: END IF;
2094:
2095: BEGIN

Line 2092: hr_utility.trace(' ==============================================');

2088: hr_utility.trace ('. Input Value Id : '||TO_CHAR(l_iv_id));
2089: hr_utility.trace ('. Entry Value : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
2090: hr_utility.trace ('. OVN : '||to_char(l_ovn));
2091: hr_utility.trace ('. Date-track Mode : '||l_upd_mode);
2092: hr_utility.trace(' ==============================================');
2093: END IF;
2094:
2095: BEGIN
2096: pay_element_entry_api.update_element_entry

Line 2169: hr_utility.trace(' ==============================================');

2165: hr_cn_api.set_location(g_debug,' Entering : '||g_procedure_name, 10);
2166:
2167: p_message := 'SUCCESS';
2168: IF g_debug THEN
2169: hr_utility.trace(' ==============================================');
2170: hr_utility.trace(' . Rate Type : '||p_rate_type);
2171: hr_utility.trace(' . Rate : '||p_rate_amount);
2172: hr_utility.trace(' . Contribution Base : '||p_cont_base);
2173: END IF;

Line 2170: hr_utility.trace(' . Rate Type : '||p_rate_type);

2166:
2167: p_message := 'SUCCESS';
2168: IF g_debug THEN
2169: hr_utility.trace(' ==============================================');
2170: hr_utility.trace(' . Rate Type : '||p_rate_type);
2171: hr_utility.trace(' . Rate : '||p_rate_amount);
2172: hr_utility.trace(' . Contribution Base : '||p_cont_base);
2173: END IF;
2174: IF p_rate_type = 'FIXED' THEN

Line 2171: hr_utility.trace(' . Rate : '||p_rate_amount);

2167: p_message := 'SUCCESS';
2168: IF g_debug THEN
2169: hr_utility.trace(' ==============================================');
2170: hr_utility.trace(' . Rate Type : '||p_rate_type);
2171: hr_utility.trace(' . Rate : '||p_rate_amount);
2172: hr_utility.trace(' . Contribution Base : '||p_cont_base);
2173: END IF;
2174: IF p_rate_type = 'FIXED' THEN
2175: l_amount := p_rate_amount;

Line 2172: hr_utility.trace(' . Contribution Base : '||p_cont_base);

2168: IF g_debug THEN
2169: hr_utility.trace(' ==============================================');
2170: hr_utility.trace(' . Rate Type : '||p_rate_type);
2171: hr_utility.trace(' . Rate : '||p_rate_amount);
2172: hr_utility.trace(' . Contribution Base : '||p_cont_base);
2173: END IF;
2174: IF p_rate_type = 'FIXED' THEN
2175: l_amount := p_rate_amount;
2176:

Line 2183: hr_utility.trace(' . Contribution Amount : '||l_amount);

2179:
2180: END IF;
2181:
2182: IF g_debug THEN
2183: hr_utility.trace(' . Contribution Amount : '||l_amount);
2184: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
2185: END IF;
2186:
2187: l_amount := get_rounded_value(l_amount, p_rounding_method);

Line 2184: hr_utility.trace(' . Rounding Method : '||p_rounding_method);

2180: END IF;
2181:
2182: IF g_debug THEN
2183: hr_utility.trace(' . Contribution Amount : '||l_amount);
2184: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
2185: END IF;
2186:
2187: l_amount := get_rounded_value(l_amount, p_rounding_method);
2188:

Line 2190: hr_utility.trace(' . Rounded Amount : '||l_amount);

2186:
2187: l_amount := get_rounded_value(l_amount, p_rounding_method);
2188:
2189: IF g_debug THEN
2190: hr_utility.trace(' . Rounded Amount : '||l_amount);
2191: hr_utility.trace(' ==============================================');
2192: END IF;
2193:
2194: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 40);

Line 2191: hr_utility.trace(' ==============================================');

2187: l_amount := get_rounded_value(l_amount, p_rounding_method);
2188:
2189: IF g_debug THEN
2190: hr_utility.trace(' . Rounded Amount : '||l_amount);
2191: hr_utility.trace(' ==============================================');
2192: END IF;
2193:
2194: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 40);
2195: RETURN l_amount;

Line 2265: hr_utility.trace ('==============================================');

2261: l_message := 'SUCCESS';
2262: l_default_date := TO_DATE ('01-01-0001','DD-MM-YYYY');
2263:
2264: IF g_debug THEN
2265: hr_utility.trace ('==============================================');
2266: hr_utility.trace (' Actual Probn End Date : '||p_actual_probation_end_date);
2267: hr_utility.trace (' Cont. Probn End Date : '||p_const_probation_end_date);
2268: hr_utility.trace (' Defer Deductions : '||p_defer_deductions);
2269: hr_utility.trace (' Deduct in Probation Expiry : '||p_deduct_in_probation_expiry);

Line 2266: hr_utility.trace (' Actual Probn End Date : '||p_actual_probation_end_date);

2262: l_default_date := TO_DATE ('01-01-0001','DD-MM-YYYY');
2263:
2264: IF g_debug THEN
2265: hr_utility.trace ('==============================================');
2266: hr_utility.trace (' Actual Probn End Date : '||p_actual_probation_end_date);
2267: hr_utility.trace (' Cont. Probn End Date : '||p_const_probation_end_date);
2268: hr_utility.trace (' Defer Deductions : '||p_defer_deductions);
2269: hr_utility.trace (' Deduct in Probation Expiry : '||p_deduct_in_probation_expiry);
2270: hr_utility.trace (' Taxable Earnings : '||p_taxable_earnings_asg_er_ptd);

Line 2267: hr_utility.trace (' Cont. Probn End Date : '||p_const_probation_end_date);

2263:
2264: IF g_debug THEN
2265: hr_utility.trace ('==============================================');
2266: hr_utility.trace (' Actual Probn End Date : '||p_actual_probation_end_date);
2267: hr_utility.trace (' Cont. Probn End Date : '||p_const_probation_end_date);
2268: hr_utility.trace (' Defer Deductions : '||p_defer_deductions);
2269: hr_utility.trace (' Deduct in Probation Expiry : '||p_deduct_in_probation_expiry);
2270: hr_utility.trace (' Taxable Earnings : '||p_taxable_earnings_asg_er_ptd);
2271:

Line 2268: hr_utility.trace (' Defer Deductions : '||p_defer_deductions);

2264: IF g_debug THEN
2265: hr_utility.trace ('==============================================');
2266: hr_utility.trace (' Actual Probn End Date : '||p_actual_probation_end_date);
2267: hr_utility.trace (' Cont. Probn End Date : '||p_const_probation_end_date);
2268: hr_utility.trace (' Defer Deductions : '||p_defer_deductions);
2269: hr_utility.trace (' Deduct in Probation Expiry : '||p_deduct_in_probation_expiry);
2270: hr_utility.trace (' Taxable Earnings : '||p_taxable_earnings_asg_er_ptd);
2271:
2272: hr_utility.trace (' Old EE PHF/SI amount : '||p_ee_phf_si_amount);

Line 2269: hr_utility.trace (' Deduct in Probation Expiry : '||p_deduct_in_probation_expiry);

2265: hr_utility.trace ('==============================================');
2266: hr_utility.trace (' Actual Probn End Date : '||p_actual_probation_end_date);
2267: hr_utility.trace (' Cont. Probn End Date : '||p_const_probation_end_date);
2268: hr_utility.trace (' Defer Deductions : '||p_defer_deductions);
2269: hr_utility.trace (' Deduct in Probation Expiry : '||p_deduct_in_probation_expiry);
2270: hr_utility.trace (' Taxable Earnings : '||p_taxable_earnings_asg_er_ptd);
2271:
2272: hr_utility.trace (' Old EE PHF/SI amount : '||p_ee_phf_si_amount);
2273: hr_utility.trace (' Old ER PHF/SI amount : '||p_er_phf_si_amount);

Line 2270: hr_utility.trace (' Taxable Earnings : '||p_taxable_earnings_asg_er_ptd);

2266: hr_utility.trace (' Actual Probn End Date : '||p_actual_probation_end_date);
2267: hr_utility.trace (' Cont. Probn End Date : '||p_const_probation_end_date);
2268: hr_utility.trace (' Defer Deductions : '||p_defer_deductions);
2269: hr_utility.trace (' Deduct in Probation Expiry : '||p_deduct_in_probation_expiry);
2270: hr_utility.trace (' Taxable Earnings : '||p_taxable_earnings_asg_er_ptd);
2271:
2272: hr_utility.trace (' Old EE PHF/SI amount : '||p_ee_phf_si_amount);
2273: hr_utility.trace (' Old ER PHF/SI amount : '||p_er_phf_si_amount);
2274: hr_utility.trace (' Old Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);

Line 2272: hr_utility.trace (' Old EE PHF/SI amount : '||p_ee_phf_si_amount);

2268: hr_utility.trace (' Defer Deductions : '||p_defer_deductions);
2269: hr_utility.trace (' Deduct in Probation Expiry : '||p_deduct_in_probation_expiry);
2270: hr_utility.trace (' Taxable Earnings : '||p_taxable_earnings_asg_er_ptd);
2271:
2272: hr_utility.trace (' Old EE PHF/SI amount : '||p_ee_phf_si_amount);
2273: hr_utility.trace (' Old ER PHF/SI amount : '||p_er_phf_si_amount);
2274: hr_utility.trace (' Old Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);
2275: hr_utility.trace (' Old Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);
2276: hr_utility.trace (' p_pay_proc_period_end_date : '||TO_CHAR(p_pay_proc_period_end_date,'DD-MM-YYYY'));

Line 2273: hr_utility.trace (' Old ER PHF/SI amount : '||p_er_phf_si_amount);

2269: hr_utility.trace (' Deduct in Probation Expiry : '||p_deduct_in_probation_expiry);
2270: hr_utility.trace (' Taxable Earnings : '||p_taxable_earnings_asg_er_ptd);
2271:
2272: hr_utility.trace (' Old EE PHF/SI amount : '||p_ee_phf_si_amount);
2273: hr_utility.trace (' Old ER PHF/SI amount : '||p_er_phf_si_amount);
2274: hr_utility.trace (' Old Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);
2275: hr_utility.trace (' Old Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);
2276: hr_utility.trace (' p_pay_proc_period_end_date : '||TO_CHAR(p_pay_proc_period_end_date,'DD-MM-YYYY'));
2277: hr_utility.trace ('==============================================');

Line 2274: hr_utility.trace (' Old Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);

2270: hr_utility.trace (' Taxable Earnings : '||p_taxable_earnings_asg_er_ptd);
2271:
2272: hr_utility.trace (' Old EE PHF/SI amount : '||p_ee_phf_si_amount);
2273: hr_utility.trace (' Old ER PHF/SI amount : '||p_er_phf_si_amount);
2274: hr_utility.trace (' Old Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);
2275: hr_utility.trace (' Old Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);
2276: hr_utility.trace (' p_pay_proc_period_end_date : '||TO_CHAR(p_pay_proc_period_end_date,'DD-MM-YYYY'));
2277: hr_utility.trace ('==============================================');
2278: END IF;

Line 2275: hr_utility.trace (' Old Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);

2271:
2272: hr_utility.trace (' Old EE PHF/SI amount : '||p_ee_phf_si_amount);
2273: hr_utility.trace (' Old ER PHF/SI amount : '||p_er_phf_si_amount);
2274: hr_utility.trace (' Old Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);
2275: hr_utility.trace (' Old Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);
2276: hr_utility.trace (' p_pay_proc_period_end_date : '||TO_CHAR(p_pay_proc_period_end_date,'DD-MM-YYYY'));
2277: hr_utility.trace ('==============================================');
2278: END IF;
2279:

Line 2276: hr_utility.trace (' p_pay_proc_period_end_date : '||TO_CHAR(p_pay_proc_period_end_date,'DD-MM-YYYY'));

2272: hr_utility.trace (' Old EE PHF/SI amount : '||p_ee_phf_si_amount);
2273: hr_utility.trace (' Old ER PHF/SI amount : '||p_er_phf_si_amount);
2274: hr_utility.trace (' Old Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);
2275: hr_utility.trace (' Old Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);
2276: hr_utility.trace (' p_pay_proc_period_end_date : '||TO_CHAR(p_pay_proc_period_end_date,'DD-MM-YYYY'));
2277: hr_utility.trace ('==============================================');
2278: END IF;
2279:
2280:

Line 2277: hr_utility.trace ('==============================================');

2273: hr_utility.trace (' Old ER PHF/SI amount : '||p_er_phf_si_amount);
2274: hr_utility.trace (' Old Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);
2275: hr_utility.trace (' Old Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);
2276: hr_utility.trace (' p_pay_proc_period_end_date : '||TO_CHAR(p_pay_proc_period_end_date,'DD-MM-YYYY'));
2277: hr_utility.trace ('==============================================');
2278: END IF;
2279:
2280:
2281: --3042788 Code is modified to consider the defaulting of Actual,Const Probation end dates

Line 2341: hr_utility.trace(' ==============================================');

2337:
2338: END IF;
2339:
2340: IF g_debug THEN
2341: hr_utility.trace(' ==============================================');
2342: hr_utility.trace(' New EE PHF/SI amount : '||p_ee_phf_si_amount);
2343: hr_utility.trace(' New ER PHF/SI amount : '||p_er_phf_si_amount);
2344: hr_utility.trace(' New Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);
2345: hr_utility.trace(' New Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);

Line 2342: hr_utility.trace(' New EE PHF/SI amount : '||p_ee_phf_si_amount);

2338: END IF;
2339:
2340: IF g_debug THEN
2341: hr_utility.trace(' ==============================================');
2342: hr_utility.trace(' New EE PHF/SI amount : '||p_ee_phf_si_amount);
2343: hr_utility.trace(' New ER PHF/SI amount : '||p_er_phf_si_amount);
2344: hr_utility.trace(' New Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);
2345: hr_utility.trace(' New Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);
2346: hr_utility.trace(' ==============================================');

Line 2343: hr_utility.trace(' New ER PHF/SI amount : '||p_er_phf_si_amount);

2339:
2340: IF g_debug THEN
2341: hr_utility.trace(' ==============================================');
2342: hr_utility.trace(' New EE PHF/SI amount : '||p_ee_phf_si_amount);
2343: hr_utility.trace(' New ER PHF/SI amount : '||p_er_phf_si_amount);
2344: hr_utility.trace(' New Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);
2345: hr_utility.trace(' New Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);
2346: hr_utility.trace(' ==============================================');
2347: END IF;

Line 2344: hr_utility.trace(' New Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);

2340: IF g_debug THEN
2341: hr_utility.trace(' ==============================================');
2342: hr_utility.trace(' New EE PHF/SI amount : '||p_ee_phf_si_amount);
2343: hr_utility.trace(' New ER PHF/SI amount : '||p_er_phf_si_amount);
2344: hr_utility.trace(' New Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);
2345: hr_utility.trace(' New Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);
2346: hr_utility.trace(' ==============================================');
2347: END IF;
2348:

Line 2345: hr_utility.trace(' New Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);

2341: hr_utility.trace(' ==============================================');
2342: hr_utility.trace(' New EE PHF/SI amount : '||p_ee_phf_si_amount);
2343: hr_utility.trace(' New ER PHF/SI amount : '||p_er_phf_si_amount);
2344: hr_utility.trace(' New Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);
2345: hr_utility.trace(' New Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);
2346: hr_utility.trace(' ==============================================');
2347: END IF;
2348:
2349: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 60);

Line 2346: hr_utility.trace(' ==============================================');

2342: hr_utility.trace(' New EE PHF/SI amount : '||p_ee_phf_si_amount);
2343: hr_utility.trace(' New ER PHF/SI amount : '||p_er_phf_si_amount);
2344: hr_utility.trace(' New Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);
2345: hr_utility.trace(' New Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);
2346: hr_utility.trace(' ==============================================');
2347: END IF;
2348:
2349: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 60);
2350: RETURN l_message;

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

2404: INTO l_def_bal_id;
2405: CLOSE csr_def_bal_id;
2406:
2407: IF g_debug THEN
2408: hr_utility.trace ('. '||RPAD(TRIM(p_balance_name||p_dimension_name),35,' ')||' : '||l_def_bal_id);
2409: END IF;
2410:
2411: RETURN l_def_bal_id;
2412:

Line 2416: hr_utility.trace(l_message);

2412:
2413: EXCEPTION
2414: WHEN OTHERS THEN
2415: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
2416: hr_utility.trace(l_message);
2417:
2418: END get_def_bal_id ;
2419:
2420: ----------------------------------------------------------------------------

Line 2492: hr_utility.trace ('===================== Defined Balances =========================');

2488: FETCH c_element_name INTO l_element_name,l_insurance_type;
2489: CLOSE c_element_name;
2490:
2491: IF g_debug THEN
2492: hr_utility.trace ('===================== Defined Balances =========================');
2493: END IF;
2494:
2495: p_balance_value_tab(1).defined_balance_id := get_def_bal_id('PHF SI Earnings','_ASG_PTD');
2496: p_balance_value_tab(2).defined_balance_id := get_def_bal_id('PHF SI Earnings','_ASG_PYEAR');

Line 2510: hr_utility.trace ('===================== Defined Balances =========================');

2506: p_balance_value_tab(11).defined_balance_id := get_def_bal_id('Undeducted EE '||l_element_name,'_ASG_ER_PTD');
2507: p_balance_value_tab(12).defined_balance_id := get_def_bal_id('Undeducted ER '||l_element_name,'_ASG_ER_PTD');
2508:
2509: IF g_debug THEN
2510: hr_utility.trace ('===================== Defined Balances =========================');
2511: END IF;
2512:
2513: IF g_debug THEN
2514: hr_utility.trace ('===================== Balance Values =========================');

Line 2514: hr_utility.trace ('===================== Balance Values =========================');

2510: hr_utility.trace ('===================== Defined Balances =========================');
2511: END IF;
2512:
2513: IF g_debug THEN
2514: hr_utility.trace ('===================== Balance Values =========================');
2515: END IF;
2516:
2517: FOR cnt in p_balance_value_tab.first .. p_balance_value_tab.last
2518: LOOP

Line 2532: hr_utility.trace ('. Defined balance ID '||p_balance_value_tab(cnt).defined_balance_id||' has balance value '||p_balance_value_tab(cnt).balance_value);

2528: ,p_date_earned => NULL
2529: ,p_get_rr_route => NULL
2530: ,p_get_rb_route => 'TRUE');
2531:
2532: hr_utility.trace ('. Defined balance ID '||p_balance_value_tab(cnt).defined_balance_id||' has balance value '||p_balance_value_tab(cnt).balance_value);
2533: END LOOP;
2534:
2535: IF g_debug THEN
2536: hr_utility.trace ('===================== Balance Values =========================');

Line 2536: hr_utility.trace ('===================== Balance Values =========================');

2532: hr_utility.trace ('. Defined balance ID '||p_balance_value_tab(cnt).defined_balance_id||' has balance value '||p_balance_value_tab(cnt).balance_value);
2533: END LOOP;
2534:
2535: IF g_debug THEN
2536: hr_utility.trace ('===================== Balance Values =========================');
2537: END IF;
2538:
2539: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 20);
2540:

Line 2544: hr_utility.trace(l_message);

2540:
2541: EXCEPTION
2542: WHEN OTHERS THEN
2543: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
2544: hr_utility.trace(l_message);
2545:
2546: END get_phf_si_balances;
2547:
2548:

Line 2702: hr_utility.trace(' =======================================================');

2698: hr_cn_api.set_location(g_debug,' Entering PHF and SI Enhancements started from 1-Jan-2006 : ', 230);
2699:
2700:
2701: IF g_debug THEN
2702: hr_utility.trace(' =======================================================');
2703: hr_utility.trace('p_phf_si_type '||p_phf_si_type);
2704: hr_utility.trace('p_ee_rate '|| p_ee_rate);
2705: hr_utility.trace('p_er_rate '|| p_er_rate);
2706: hr_utility.trace('p_ee_rate_type '|| p_ee_rate_type);

Line 2703: hr_utility.trace('p_phf_si_type '||p_phf_si_type);

2699:
2700:
2701: IF g_debug THEN
2702: hr_utility.trace(' =======================================================');
2703: hr_utility.trace('p_phf_si_type '||p_phf_si_type);
2704: hr_utility.trace('p_ee_rate '|| p_ee_rate);
2705: hr_utility.trace('p_er_rate '|| p_er_rate);
2706: hr_utility.trace('p_ee_rate_type '|| p_ee_rate_type);
2707: hr_utility.trace('p_er_rate_type '|| p_er_rate_type);

Line 2704: hr_utility.trace('p_ee_rate '|| p_ee_rate);

2700:
2701: IF g_debug THEN
2702: hr_utility.trace(' =======================================================');
2703: hr_utility.trace('p_phf_si_type '||p_phf_si_type);
2704: hr_utility.trace('p_ee_rate '|| p_ee_rate);
2705: hr_utility.trace('p_er_rate '|| p_er_rate);
2706: hr_utility.trace('p_ee_rate_type '|| p_ee_rate_type);
2707: hr_utility.trace('p_er_rate_type '|| p_er_rate_type);
2708: hr_utility.trace('p_ee_cont_base_method '|| p_ee_cont_base_method);

Line 2705: hr_utility.trace('p_er_rate '|| p_er_rate);

2701: IF g_debug THEN
2702: hr_utility.trace(' =======================================================');
2703: hr_utility.trace('p_phf_si_type '||p_phf_si_type);
2704: hr_utility.trace('p_ee_rate '|| p_ee_rate);
2705: hr_utility.trace('p_er_rate '|| p_er_rate);
2706: hr_utility.trace('p_ee_rate_type '|| p_ee_rate_type);
2707: hr_utility.trace('p_er_rate_type '|| p_er_rate_type);
2708: hr_utility.trace('p_ee_cont_base_method '|| p_ee_cont_base_method);
2709: hr_utility.trace('p_er_cont_base_method '|| p_er_cont_base_method);

Line 2706: hr_utility.trace('p_ee_rate_type '|| p_ee_rate_type);

2702: hr_utility.trace(' =======================================================');
2703: hr_utility.trace('p_phf_si_type '||p_phf_si_type);
2704: hr_utility.trace('p_ee_rate '|| p_ee_rate);
2705: hr_utility.trace('p_er_rate '|| p_er_rate);
2706: hr_utility.trace('p_ee_rate_type '|| p_ee_rate_type);
2707: hr_utility.trace('p_er_rate_type '|| p_er_rate_type);
2708: hr_utility.trace('p_ee_cont_base_method '|| p_ee_cont_base_method);
2709: hr_utility.trace('p_er_cont_base_method '|| p_er_cont_base_method);
2710: hr_utility.trace('p_ee_cont_base_amount '|| p_ee_cont_base_amount);

Line 2707: hr_utility.trace('p_er_rate_type '|| p_er_rate_type);

2703: hr_utility.trace('p_phf_si_type '||p_phf_si_type);
2704: hr_utility.trace('p_ee_rate '|| p_ee_rate);
2705: hr_utility.trace('p_er_rate '|| p_er_rate);
2706: hr_utility.trace('p_ee_rate_type '|| p_ee_rate_type);
2707: hr_utility.trace('p_er_rate_type '|| p_er_rate_type);
2708: hr_utility.trace('p_ee_cont_base_method '|| p_ee_cont_base_method);
2709: hr_utility.trace('p_er_cont_base_method '|| p_er_cont_base_method);
2710: hr_utility.trace('p_ee_cont_base_amount '|| p_ee_cont_base_amount);
2711: hr_utility.trace('p_er_cont_base_amount '|| p_er_cont_base_amount);

Line 2708: hr_utility.trace('p_ee_cont_base_method '|| p_ee_cont_base_method);

2704: hr_utility.trace('p_ee_rate '|| p_ee_rate);
2705: hr_utility.trace('p_er_rate '|| p_er_rate);
2706: hr_utility.trace('p_ee_rate_type '|| p_ee_rate_type);
2707: hr_utility.trace('p_er_rate_type '|| p_er_rate_type);
2708: hr_utility.trace('p_ee_cont_base_method '|| p_ee_cont_base_method);
2709: hr_utility.trace('p_er_cont_base_method '|| p_er_cont_base_method);
2710: hr_utility.trace('p_ee_cont_base_amount '|| p_ee_cont_base_amount);
2711: hr_utility.trace('p_er_cont_base_amount '|| p_er_cont_base_amount);
2712: hr_utility.trace('p_ee_fixed_amount '|| p_ee_fixed_amount);

Line 2709: hr_utility.trace('p_er_cont_base_method '|| p_er_cont_base_method);

2705: hr_utility.trace('p_er_rate '|| p_er_rate);
2706: hr_utility.trace('p_ee_rate_type '|| p_ee_rate_type);
2707: hr_utility.trace('p_er_rate_type '|| p_er_rate_type);
2708: hr_utility.trace('p_ee_cont_base_method '|| p_ee_cont_base_method);
2709: hr_utility.trace('p_er_cont_base_method '|| p_er_cont_base_method);
2710: hr_utility.trace('p_ee_cont_base_amount '|| p_ee_cont_base_amount);
2711: hr_utility.trace('p_er_cont_base_amount '|| p_er_cont_base_amount);
2712: hr_utility.trace('p_ee_fixed_amount '|| p_ee_fixed_amount);
2713: hr_utility.trace('p_er_fixed_amount '|| p_er_fixed_amount);

Line 2710: hr_utility.trace('p_ee_cont_base_amount '|| p_ee_cont_base_amount);

2706: hr_utility.trace('p_ee_rate_type '|| p_ee_rate_type);
2707: hr_utility.trace('p_er_rate_type '|| p_er_rate_type);
2708: hr_utility.trace('p_ee_cont_base_method '|| p_ee_cont_base_method);
2709: hr_utility.trace('p_er_cont_base_method '|| p_er_cont_base_method);
2710: hr_utility.trace('p_ee_cont_base_amount '|| p_ee_cont_base_amount);
2711: hr_utility.trace('p_er_cont_base_amount '|| p_er_cont_base_amount);
2712: hr_utility.trace('p_ee_fixed_amount '|| p_ee_fixed_amount);
2713: hr_utility.trace('p_er_fixed_amount '|| p_er_fixed_amount);
2714: hr_utility.trace('p_average_salary '|| p_average_salary);

Line 2711: hr_utility.trace('p_er_cont_base_amount '|| p_er_cont_base_amount);

2707: hr_utility.trace('p_er_rate_type '|| p_er_rate_type);
2708: hr_utility.trace('p_ee_cont_base_method '|| p_ee_cont_base_method);
2709: hr_utility.trace('p_er_cont_base_method '|| p_er_cont_base_method);
2710: hr_utility.trace('p_ee_cont_base_amount '|| p_ee_cont_base_amount);
2711: hr_utility.trace('p_er_cont_base_amount '|| p_er_cont_base_amount);
2712: hr_utility.trace('p_ee_fixed_amount '|| p_ee_fixed_amount);
2713: hr_utility.trace('p_er_fixed_amount '|| p_er_fixed_amount);
2714: hr_utility.trace('p_average_salary '|| p_average_salary);
2715: hr_utility.trace('p_lowest_avg_salary '|| p_lowest_avg_salary);

Line 2712: hr_utility.trace('p_ee_fixed_amount '|| p_ee_fixed_amount);

2708: hr_utility.trace('p_ee_cont_base_method '|| p_ee_cont_base_method);
2709: hr_utility.trace('p_er_cont_base_method '|| p_er_cont_base_method);
2710: hr_utility.trace('p_ee_cont_base_amount '|| p_ee_cont_base_amount);
2711: hr_utility.trace('p_er_cont_base_amount '|| p_er_cont_base_amount);
2712: hr_utility.trace('p_ee_fixed_amount '|| p_ee_fixed_amount);
2713: hr_utility.trace('p_er_fixed_amount '|| p_er_fixed_amount);
2714: hr_utility.trace('p_average_salary '|| p_average_salary);
2715: hr_utility.trace('p_lowest_avg_salary '|| p_lowest_avg_salary);
2716: hr_utility.trace('p_ee_rate_rounding_method '|| p_ee_rate_rounding_method);

Line 2713: hr_utility.trace('p_er_fixed_amount '|| p_er_fixed_amount);

2709: hr_utility.trace('p_er_cont_base_method '|| p_er_cont_base_method);
2710: hr_utility.trace('p_ee_cont_base_amount '|| p_ee_cont_base_amount);
2711: hr_utility.trace('p_er_cont_base_amount '|| p_er_cont_base_amount);
2712: hr_utility.trace('p_ee_fixed_amount '|| p_ee_fixed_amount);
2713: hr_utility.trace('p_er_fixed_amount '|| p_er_fixed_amount);
2714: hr_utility.trace('p_average_salary '|| p_average_salary);
2715: hr_utility.trace('p_lowest_avg_salary '|| p_lowest_avg_salary);
2716: hr_utility.trace('p_ee_rate_rounding_method '|| p_ee_rate_rounding_method);
2717: hr_utility.trace('p_er_rate_rounding_method '|| p_er_rate_rounding_method);

Line 2714: hr_utility.trace('p_average_salary '|| p_average_salary);

2710: hr_utility.trace('p_ee_cont_base_amount '|| p_ee_cont_base_amount);
2711: hr_utility.trace('p_er_cont_base_amount '|| p_er_cont_base_amount);
2712: hr_utility.trace('p_ee_fixed_amount '|| p_ee_fixed_amount);
2713: hr_utility.trace('p_er_fixed_amount '|| p_er_fixed_amount);
2714: hr_utility.trace('p_average_salary '|| p_average_salary);
2715: hr_utility.trace('p_lowest_avg_salary '|| p_lowest_avg_salary);
2716: hr_utility.trace('p_ee_rate_rounding_method '|| p_ee_rate_rounding_method);
2717: hr_utility.trace('p_er_rate_rounding_method '|| p_er_rate_rounding_method);
2718:

Line 2715: hr_utility.trace('p_lowest_avg_salary '|| p_lowest_avg_salary);

2711: hr_utility.trace('p_er_cont_base_amount '|| p_er_cont_base_amount);
2712: hr_utility.trace('p_ee_fixed_amount '|| p_ee_fixed_amount);
2713: hr_utility.trace('p_er_fixed_amount '|| p_er_fixed_amount);
2714: hr_utility.trace('p_average_salary '|| p_average_salary);
2715: hr_utility.trace('p_lowest_avg_salary '|| p_lowest_avg_salary);
2716: hr_utility.trace('p_ee_rate_rounding_method '|| p_ee_rate_rounding_method);
2717: hr_utility.trace('p_er_rate_rounding_method '|| p_er_rate_rounding_method);
2718:
2719: hr_utility.trace('p_ee_phf_si_amount '|| p_ee_phf_si_amount);

Line 2716: hr_utility.trace('p_ee_rate_rounding_method '|| p_ee_rate_rounding_method);

2712: hr_utility.trace('p_ee_fixed_amount '|| p_ee_fixed_amount);
2713: hr_utility.trace('p_er_fixed_amount '|| p_er_fixed_amount);
2714: hr_utility.trace('p_average_salary '|| p_average_salary);
2715: hr_utility.trace('p_lowest_avg_salary '|| p_lowest_avg_salary);
2716: hr_utility.trace('p_ee_rate_rounding_method '|| p_ee_rate_rounding_method);
2717: hr_utility.trace('p_er_rate_rounding_method '|| p_er_rate_rounding_method);
2718:
2719: hr_utility.trace('p_ee_phf_si_amount '|| p_ee_phf_si_amount);
2720: hr_utility.trace('p_er_phf_si_amount '|| p_er_phf_si_amount);

Line 2717: hr_utility.trace('p_er_rate_rounding_method '|| p_er_rate_rounding_method);

2713: hr_utility.trace('p_er_fixed_amount '|| p_er_fixed_amount);
2714: hr_utility.trace('p_average_salary '|| p_average_salary);
2715: hr_utility.trace('p_lowest_avg_salary '|| p_lowest_avg_salary);
2716: hr_utility.trace('p_ee_rate_rounding_method '|| p_ee_rate_rounding_method);
2717: hr_utility.trace('p_er_rate_rounding_method '|| p_er_rate_rounding_method);
2718:
2719: hr_utility.trace('p_ee_phf_si_amount '|| p_ee_phf_si_amount);
2720: hr_utility.trace('p_er_phf_si_amount '|| p_er_phf_si_amount);
2721:

Line 2719: hr_utility.trace('p_ee_phf_si_amount '|| p_ee_phf_si_amount);

2715: hr_utility.trace('p_lowest_avg_salary '|| p_lowest_avg_salary);
2716: hr_utility.trace('p_ee_rate_rounding_method '|| p_ee_rate_rounding_method);
2717: hr_utility.trace('p_er_rate_rounding_method '|| p_er_rate_rounding_method);
2718:
2719: hr_utility.trace('p_ee_phf_si_amount '|| p_ee_phf_si_amount);
2720: hr_utility.trace('p_er_phf_si_amount '|| p_er_phf_si_amount);
2721:
2722: hr_utility.trace('p_phf_si_earnings_asg_ptd '|| p_phf_si_earnings_asg_ptd);
2723: hr_utility.trace('p_phf_si_earnings_asg_pyear '|| p_phf_si_earnings_asg_pyear);

Line 2720: hr_utility.trace('p_er_phf_si_amount '|| p_er_phf_si_amount);

2716: hr_utility.trace('p_ee_rate_rounding_method '|| p_ee_rate_rounding_method);
2717: hr_utility.trace('p_er_rate_rounding_method '|| p_er_rate_rounding_method);
2718:
2719: hr_utility.trace('p_ee_phf_si_amount '|| p_ee_phf_si_amount);
2720: hr_utility.trace('p_er_phf_si_amount '|| p_er_phf_si_amount);
2721:
2722: hr_utility.trace('p_phf_si_earnings_asg_ptd '|| p_phf_si_earnings_asg_ptd);
2723: hr_utility.trace('p_phf_si_earnings_asg_pyear '|| p_phf_si_earnings_asg_pyear);
2724: hr_utility.trace('p_phf_si_earnings_asg_pmth '|| p_phf_si_earnings_asg_pmth);

Line 2722: hr_utility.trace('p_phf_si_earnings_asg_ptd '|| p_phf_si_earnings_asg_ptd);

2718:
2719: hr_utility.trace('p_ee_phf_si_amount '|| p_ee_phf_si_amount);
2720: hr_utility.trace('p_er_phf_si_amount '|| p_er_phf_si_amount);
2721:
2722: hr_utility.trace('p_phf_si_earnings_asg_ptd '|| p_phf_si_earnings_asg_ptd);
2723: hr_utility.trace('p_phf_si_earnings_asg_pyear '|| p_phf_si_earnings_asg_pyear);
2724: hr_utility.trace('p_phf_si_earnings_asg_pmth '|| p_phf_si_earnings_asg_pmth);
2725:
2726: hr_utility.trace('p_ee_hi_cont_type '||p_ee_hi_cont_type );

Line 2723: hr_utility.trace('p_phf_si_earnings_asg_pyear '|| p_phf_si_earnings_asg_pyear);

2719: hr_utility.trace('p_ee_phf_si_amount '|| p_ee_phf_si_amount);
2720: hr_utility.trace('p_er_phf_si_amount '|| p_er_phf_si_amount);
2721:
2722: hr_utility.trace('p_phf_si_earnings_asg_ptd '|| p_phf_si_earnings_asg_ptd);
2723: hr_utility.trace('p_phf_si_earnings_asg_pyear '|| p_phf_si_earnings_asg_pyear);
2724: hr_utility.trace('p_phf_si_earnings_asg_pmth '|| p_phf_si_earnings_asg_pmth);
2725:
2726: hr_utility.trace('p_ee_hi_cont_type '||p_ee_hi_cont_type );
2727: hr_utility.trace('p_er_hi_cont_type '||p_er_hi_cont_type );

Line 2724: hr_utility.trace('p_phf_si_earnings_asg_pmth '|| p_phf_si_earnings_asg_pmth);

2720: hr_utility.trace('p_er_phf_si_amount '|| p_er_phf_si_amount);
2721:
2722: hr_utility.trace('p_phf_si_earnings_asg_ptd '|| p_phf_si_earnings_asg_ptd);
2723: hr_utility.trace('p_phf_si_earnings_asg_pyear '|| p_phf_si_earnings_asg_pyear);
2724: hr_utility.trace('p_phf_si_earnings_asg_pmth '|| p_phf_si_earnings_asg_pmth);
2725:
2726: hr_utility.trace('p_ee_hi_cont_type '||p_ee_hi_cont_type );
2727: hr_utility.trace('p_er_hi_cont_type '||p_er_hi_cont_type );
2728: hr_utility.trace('p_ee_hi_cont_amt '||p_ee_hi_cont_amt );

Line 2726: hr_utility.trace('p_ee_hi_cont_type '||p_ee_hi_cont_type );

2722: hr_utility.trace('p_phf_si_earnings_asg_ptd '|| p_phf_si_earnings_asg_ptd);
2723: hr_utility.trace('p_phf_si_earnings_asg_pyear '|| p_phf_si_earnings_asg_pyear);
2724: hr_utility.trace('p_phf_si_earnings_asg_pmth '|| p_phf_si_earnings_asg_pmth);
2725:
2726: hr_utility.trace('p_ee_hi_cont_type '||p_ee_hi_cont_type );
2727: hr_utility.trace('p_er_hi_cont_type '||p_er_hi_cont_type );
2728: hr_utility.trace('p_ee_hi_cont_amt '||p_ee_hi_cont_amt );
2729: hr_utility.trace('p_er_hi_cont_amt '||p_er_hi_cont_amt );
2730: hr_utility.trace('p_ee_hi_cont_base_meth '||p_ee_hi_cont_base_meth );

Line 2727: hr_utility.trace('p_er_hi_cont_type '||p_er_hi_cont_type );

2723: hr_utility.trace('p_phf_si_earnings_asg_pyear '|| p_phf_si_earnings_asg_pyear);
2724: hr_utility.trace('p_phf_si_earnings_asg_pmth '|| p_phf_si_earnings_asg_pmth);
2725:
2726: hr_utility.trace('p_ee_hi_cont_type '||p_ee_hi_cont_type );
2727: hr_utility.trace('p_er_hi_cont_type '||p_er_hi_cont_type );
2728: hr_utility.trace('p_ee_hi_cont_amt '||p_ee_hi_cont_amt );
2729: hr_utility.trace('p_er_hi_cont_amt '||p_er_hi_cont_amt );
2730: hr_utility.trace('p_ee_hi_cont_base_meth '||p_ee_hi_cont_base_meth );
2731: hr_utility.trace('p_er_hi_cont_base_meth '||p_er_hi_cont_base_meth );

Line 2728: hr_utility.trace('p_ee_hi_cont_amt '||p_ee_hi_cont_amt );

2724: hr_utility.trace('p_phf_si_earnings_asg_pmth '|| p_phf_si_earnings_asg_pmth);
2725:
2726: hr_utility.trace('p_ee_hi_cont_type '||p_ee_hi_cont_type );
2727: hr_utility.trace('p_er_hi_cont_type '||p_er_hi_cont_type );
2728: hr_utility.trace('p_ee_hi_cont_amt '||p_ee_hi_cont_amt );
2729: hr_utility.trace('p_er_hi_cont_amt '||p_er_hi_cont_amt );
2730: hr_utility.trace('p_ee_hi_cont_base_meth '||p_ee_hi_cont_base_meth );
2731: hr_utility.trace('p_er_hi_cont_base_meth '||p_er_hi_cont_base_meth );
2732: hr_utility.trace('p_ee_hi_cont_base_amount '||p_ee_hi_cont_base_amount);

Line 2729: hr_utility.trace('p_er_hi_cont_amt '||p_er_hi_cont_amt );

2725:
2726: hr_utility.trace('p_ee_hi_cont_type '||p_ee_hi_cont_type );
2727: hr_utility.trace('p_er_hi_cont_type '||p_er_hi_cont_type );
2728: hr_utility.trace('p_ee_hi_cont_amt '||p_ee_hi_cont_amt );
2729: hr_utility.trace('p_er_hi_cont_amt '||p_er_hi_cont_amt );
2730: hr_utility.trace('p_ee_hi_cont_base_meth '||p_ee_hi_cont_base_meth );
2731: hr_utility.trace('p_er_hi_cont_base_meth '||p_er_hi_cont_base_meth );
2732: hr_utility.trace('p_ee_hi_cont_base_amount '||p_ee_hi_cont_base_amount);
2733: hr_utility.trace('p_er_hi_cont_base_amount '||p_er_hi_cont_base_amount);

Line 2730: hr_utility.trace('p_ee_hi_cont_base_meth '||p_ee_hi_cont_base_meth );

2726: hr_utility.trace('p_ee_hi_cont_type '||p_ee_hi_cont_type );
2727: hr_utility.trace('p_er_hi_cont_type '||p_er_hi_cont_type );
2728: hr_utility.trace('p_ee_hi_cont_amt '||p_ee_hi_cont_amt );
2729: hr_utility.trace('p_er_hi_cont_amt '||p_er_hi_cont_amt );
2730: hr_utility.trace('p_ee_hi_cont_base_meth '||p_ee_hi_cont_base_meth );
2731: hr_utility.trace('p_er_hi_cont_base_meth '||p_er_hi_cont_base_meth );
2732: hr_utility.trace('p_ee_hi_cont_base_amount '||p_ee_hi_cont_base_amount);
2733: hr_utility.trace('p_er_hi_cont_base_amount '||p_er_hi_cont_base_amount);
2734: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont);

Line 2731: hr_utility.trace('p_er_hi_cont_base_meth '||p_er_hi_cont_base_meth );

2727: hr_utility.trace('p_er_hi_cont_type '||p_er_hi_cont_type );
2728: hr_utility.trace('p_ee_hi_cont_amt '||p_ee_hi_cont_amt );
2729: hr_utility.trace('p_er_hi_cont_amt '||p_er_hi_cont_amt );
2730: hr_utility.trace('p_ee_hi_cont_base_meth '||p_ee_hi_cont_base_meth );
2731: hr_utility.trace('p_er_hi_cont_base_meth '||p_er_hi_cont_base_meth );
2732: hr_utility.trace('p_ee_hi_cont_base_amount '||p_ee_hi_cont_base_amount);
2733: hr_utility.trace('p_er_hi_cont_base_amount '||p_er_hi_cont_base_amount);
2734: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont);
2735: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont);

Line 2732: hr_utility.trace('p_ee_hi_cont_base_amount '||p_ee_hi_cont_base_amount);

2728: hr_utility.trace('p_ee_hi_cont_amt '||p_ee_hi_cont_amt );
2729: hr_utility.trace('p_er_hi_cont_amt '||p_er_hi_cont_amt );
2730: hr_utility.trace('p_ee_hi_cont_base_meth '||p_ee_hi_cont_base_meth );
2731: hr_utility.trace('p_er_hi_cont_base_meth '||p_er_hi_cont_base_meth );
2732: hr_utility.trace('p_ee_hi_cont_base_amount '||p_ee_hi_cont_base_amount);
2733: hr_utility.trace('p_er_hi_cont_base_amount '||p_er_hi_cont_base_amount);
2734: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont);
2735: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont);
2736: hr_utility.trace('p_date_earned '||p_date_earned);

Line 2733: hr_utility.trace('p_er_hi_cont_base_amount '||p_er_hi_cont_base_amount);

2729: hr_utility.trace('p_er_hi_cont_amt '||p_er_hi_cont_amt );
2730: hr_utility.trace('p_ee_hi_cont_base_meth '||p_ee_hi_cont_base_meth );
2731: hr_utility.trace('p_er_hi_cont_base_meth '||p_er_hi_cont_base_meth );
2732: hr_utility.trace('p_ee_hi_cont_base_amount '||p_ee_hi_cont_base_amount);
2733: hr_utility.trace('p_er_hi_cont_base_amount '||p_er_hi_cont_base_amount);
2734: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont);
2735: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont);
2736: hr_utility.trace('p_date_earned '||p_date_earned);
2737: hr_utility.trace('p_ee_tax_thrhld_rate '||p_ee_tax_thrhld_rate);

Line 2734: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont);

2730: hr_utility.trace('p_ee_hi_cont_base_meth '||p_ee_hi_cont_base_meth );
2731: hr_utility.trace('p_er_hi_cont_base_meth '||p_er_hi_cont_base_meth );
2732: hr_utility.trace('p_ee_hi_cont_base_amount '||p_ee_hi_cont_base_amount);
2733: hr_utility.trace('p_er_hi_cont_base_amount '||p_er_hi_cont_base_amount);
2734: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont);
2735: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont);
2736: hr_utility.trace('p_date_earned '||p_date_earned);
2737: hr_utility.trace('p_ee_tax_thrhld_rate '||p_ee_tax_thrhld_rate);
2738: hr_utility.trace('p_er_tax_thrhld_rate '||p_er_tax_thrhld_rate);

Line 2735: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont);

2731: hr_utility.trace('p_er_hi_cont_base_meth '||p_er_hi_cont_base_meth );
2732: hr_utility.trace('p_ee_hi_cont_base_amount '||p_ee_hi_cont_base_amount);
2733: hr_utility.trace('p_er_hi_cont_base_amount '||p_er_hi_cont_base_amount);
2734: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont);
2735: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont);
2736: hr_utility.trace('p_date_earned '||p_date_earned);
2737: hr_utility.trace('p_ee_tax_thrhld_rate '||p_ee_tax_thrhld_rate);
2738: hr_utility.trace('p_er_tax_thrhld_rate '||p_er_tax_thrhld_rate);
2739: hr_utility.trace('p_tax_thrhld_amount '||p_tax_thrhld_amount);

Line 2736: hr_utility.trace('p_date_earned '||p_date_earned);

2732: hr_utility.trace('p_ee_hi_cont_base_amount '||p_ee_hi_cont_base_amount);
2733: hr_utility.trace('p_er_hi_cont_base_amount '||p_er_hi_cont_base_amount);
2734: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont);
2735: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont);
2736: hr_utility.trace('p_date_earned '||p_date_earned);
2737: hr_utility.trace('p_ee_tax_thrhld_rate '||p_ee_tax_thrhld_rate);
2738: hr_utility.trace('p_er_tax_thrhld_rate '||p_er_tax_thrhld_rate);
2739: hr_utility.trace('p_tax_thrhld_amount '||p_tax_thrhld_amount);
2740: hr_utility.trace(' =======================================================');

Line 2737: hr_utility.trace('p_ee_tax_thrhld_rate '||p_ee_tax_thrhld_rate);

2733: hr_utility.trace('p_er_hi_cont_base_amount '||p_er_hi_cont_base_amount);
2734: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont);
2735: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont);
2736: hr_utility.trace('p_date_earned '||p_date_earned);
2737: hr_utility.trace('p_ee_tax_thrhld_rate '||p_ee_tax_thrhld_rate);
2738: hr_utility.trace('p_er_tax_thrhld_rate '||p_er_tax_thrhld_rate);
2739: hr_utility.trace('p_tax_thrhld_amount '||p_tax_thrhld_amount);
2740: hr_utility.trace(' =======================================================');
2741: END IF;

Line 2738: hr_utility.trace('p_er_tax_thrhld_rate '||p_er_tax_thrhld_rate);

2734: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont);
2735: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont);
2736: hr_utility.trace('p_date_earned '||p_date_earned);
2737: hr_utility.trace('p_ee_tax_thrhld_rate '||p_ee_tax_thrhld_rate);
2738: hr_utility.trace('p_er_tax_thrhld_rate '||p_er_tax_thrhld_rate);
2739: hr_utility.trace('p_tax_thrhld_amount '||p_tax_thrhld_amount);
2740: hr_utility.trace(' =======================================================');
2741: END IF;
2742: ---------------------------------------------------------------------------------------------

Line 2739: hr_utility.trace('p_tax_thrhld_amount '||p_tax_thrhld_amount);

2735: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont);
2736: hr_utility.trace('p_date_earned '||p_date_earned);
2737: hr_utility.trace('p_ee_tax_thrhld_rate '||p_ee_tax_thrhld_rate);
2738: hr_utility.trace('p_er_tax_thrhld_rate '||p_er_tax_thrhld_rate);
2739: hr_utility.trace('p_tax_thrhld_amount '||p_tax_thrhld_amount);
2740: hr_utility.trace(' =======================================================');
2741: END IF;
2742: ---------------------------------------------------------------------------------------------
2743: /* Start Bug 5563042 (PHF and SI Enhancements), check for employee level data */

Line 2740: hr_utility.trace(' =======================================================');

2736: hr_utility.trace('p_date_earned '||p_date_earned);
2737: hr_utility.trace('p_ee_tax_thrhld_rate '||p_ee_tax_thrhld_rate);
2738: hr_utility.trace('p_er_tax_thrhld_rate '||p_er_tax_thrhld_rate);
2739: hr_utility.trace('p_tax_thrhld_amount '||p_tax_thrhld_amount);
2740: hr_utility.trace(' =======================================================');
2741: END IF;
2742: ---------------------------------------------------------------------------------------------
2743: /* Start Bug 5563042 (PHF and SI Enhancements), check for employee level data */
2744: ---------------------------------------------------------------------------------------------

Line 2782: hr_utility.trace(' =======================================================');

2778: l_tax_thrhld_amount := p_tax_thrhld_amount;
2779:
2780:
2781: IF g_debug THEN
2782: hr_utility.trace(' =======================================================');
2783: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);
2784: hr_utility.trace(' . l_er_rate : '||l_er_rate);
2785: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
2786: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);

Line 2783: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);

2779:
2780:
2781: IF g_debug THEN
2782: hr_utility.trace(' =======================================================');
2783: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);
2784: hr_utility.trace(' . l_er_rate : '||l_er_rate);
2785: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
2786: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
2787: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);

Line 2784: hr_utility.trace(' . l_er_rate : '||l_er_rate);

2780:
2781: IF g_debug THEN
2782: hr_utility.trace(' =======================================================');
2783: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);
2784: hr_utility.trace(' . l_er_rate : '||l_er_rate);
2785: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
2786: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
2787: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
2788: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);

Line 2785: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);

2781: IF g_debug THEN
2782: hr_utility.trace(' =======================================================');
2783: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);
2784: hr_utility.trace(' . l_er_rate : '||l_er_rate);
2785: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
2786: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
2787: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
2788: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
2789: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);

Line 2786: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);

2782: hr_utility.trace(' =======================================================');
2783: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);
2784: hr_utility.trace(' . l_er_rate : '||l_er_rate);
2785: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
2786: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
2787: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
2788: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
2789: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
2790: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);

Line 2787: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);

2783: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);
2784: hr_utility.trace(' . l_er_rate : '||l_er_rate);
2785: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
2786: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
2787: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
2788: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
2789: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
2790: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
2791: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);

Line 2788: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);

2784: hr_utility.trace(' . l_er_rate : '||l_er_rate);
2785: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
2786: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
2787: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
2788: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
2789: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
2790: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
2791: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
2792: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);

Line 2789: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);

2785: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
2786: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
2787: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
2788: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
2789: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
2790: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
2791: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
2792: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
2793: hr_utility.trace(' . l_average_salary : '||l_average_salary);

Line 2790: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);

2786: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
2787: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
2788: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
2789: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
2790: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
2791: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
2792: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
2793: hr_utility.trace(' . l_average_salary : '||l_average_salary);
2794: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);

Line 2791: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);

2787: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
2788: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
2789: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
2790: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
2791: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
2792: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
2793: hr_utility.trace(' . l_average_salary : '||l_average_salary);
2794: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
2795: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);

Line 2792: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);

2788: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
2789: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
2790: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
2791: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
2792: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
2793: hr_utility.trace(' . l_average_salary : '||l_average_salary);
2794: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
2795: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
2796: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);

Line 2793: hr_utility.trace(' . l_average_salary : '||l_average_salary);

2789: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
2790: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
2791: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
2792: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
2793: hr_utility.trace(' . l_average_salary : '||l_average_salary);
2794: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
2795: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
2796: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
2797: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);

Line 2794: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);

2790: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
2791: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
2792: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
2793: hr_utility.trace(' . l_average_salary : '||l_average_salary);
2794: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
2795: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
2796: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
2797: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
2798: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);

Line 2795: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);

2791: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
2792: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
2793: hr_utility.trace(' . l_average_salary : '||l_average_salary);
2794: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
2795: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
2796: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
2797: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
2798: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
2799: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);

Line 2796: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);

2792: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
2793: hr_utility.trace(' . l_average_salary : '||l_average_salary);
2794: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
2795: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
2796: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
2797: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
2798: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
2799: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
2800: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);

Line 2797: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);

2793: hr_utility.trace(' . l_average_salary : '||l_average_salary);
2794: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
2795: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
2796: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
2797: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
2798: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
2799: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
2800: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
2801: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);

Line 2798: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);

2794: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
2795: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
2796: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
2797: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
2798: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
2799: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
2800: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
2801: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
2802: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );

Line 2799: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);

2795: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
2796: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
2797: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
2798: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
2799: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
2800: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
2801: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
2802: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2803: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );

Line 2800: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);

2796: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
2797: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
2798: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
2799: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
2800: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
2801: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
2802: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2803: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2804: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );

Line 2801: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);

2797: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
2798: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
2799: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
2800: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
2801: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
2802: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2803: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2804: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2805: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );

Line 2802: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );

2798: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
2799: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
2800: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
2801: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
2802: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2803: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2804: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2805: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2806: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );

Line 2803: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );

2799: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
2800: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
2801: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
2802: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2803: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2804: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2805: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2806: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2807: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );

Line 2804: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );

2800: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
2801: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
2802: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2803: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2804: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2805: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2806: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2807: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2808: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);

Line 2805: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );

2801: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
2802: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2803: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2804: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2805: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2806: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2807: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2808: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
2809: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);

Line 2806: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );

2802: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2803: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2804: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2805: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2806: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2807: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2808: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
2809: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
2810: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);

Line 2807: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );

2803: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2804: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2805: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2806: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2807: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2808: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
2809: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
2810: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
2811: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);

Line 2808: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);

2804: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2805: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2806: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2807: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2808: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
2809: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
2810: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
2811: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
2812: hr_utility.trace(' . l_ee_tax_thrhld_rate : '||l_ee_tax_thrhld_rate);

Line 2809: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);

2805: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2806: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2807: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2808: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
2809: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
2810: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
2811: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
2812: hr_utility.trace(' . l_ee_tax_thrhld_rate : '||l_ee_tax_thrhld_rate);
2813: hr_utility.trace(' . l_er_tax_thrhld_rate : '||l_er_tax_thrhld_rate);

Line 2810: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);

2806: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2807: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2808: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
2809: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
2810: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
2811: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
2812: hr_utility.trace(' . l_ee_tax_thrhld_rate : '||l_ee_tax_thrhld_rate);
2813: hr_utility.trace(' . l_er_tax_thrhld_rate : '||l_er_tax_thrhld_rate);
2814: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);

Line 2811: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);

2807: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2808: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
2809: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
2810: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
2811: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
2812: hr_utility.trace(' . l_ee_tax_thrhld_rate : '||l_ee_tax_thrhld_rate);
2813: hr_utility.trace(' . l_er_tax_thrhld_rate : '||l_er_tax_thrhld_rate);
2814: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);
2815: hr_utility.trace(' =======================================================');

Line 2812: hr_utility.trace(' . l_ee_tax_thrhld_rate : '||l_ee_tax_thrhld_rate);

2808: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
2809: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
2810: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
2811: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
2812: hr_utility.trace(' . l_ee_tax_thrhld_rate : '||l_ee_tax_thrhld_rate);
2813: hr_utility.trace(' . l_er_tax_thrhld_rate : '||l_er_tax_thrhld_rate);
2814: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);
2815: hr_utility.trace(' =======================================================');
2816: END IF;

Line 2813: hr_utility.trace(' . l_er_tax_thrhld_rate : '||l_er_tax_thrhld_rate);

2809: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
2810: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
2811: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
2812: hr_utility.trace(' . l_ee_tax_thrhld_rate : '||l_ee_tax_thrhld_rate);
2813: hr_utility.trace(' . l_er_tax_thrhld_rate : '||l_er_tax_thrhld_rate);
2814: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);
2815: hr_utility.trace(' =======================================================');
2816: END IF;
2817:

Line 2814: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);

2810: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
2811: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
2812: hr_utility.trace(' . l_ee_tax_thrhld_rate : '||l_ee_tax_thrhld_rate);
2813: hr_utility.trace(' . l_er_tax_thrhld_rate : '||l_er_tax_thrhld_rate);
2814: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);
2815: hr_utility.trace(' =======================================================');
2816: END IF;
2817:
2818: IF (p_ee_hi_cont_amt = -1) THEN

Line 2815: hr_utility.trace(' =======================================================');

2811: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
2812: hr_utility.trace(' . l_ee_tax_thrhld_rate : '||l_ee_tax_thrhld_rate);
2813: hr_utility.trace(' . l_er_tax_thrhld_rate : '||l_er_tax_thrhld_rate);
2814: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);
2815: hr_utility.trace(' =======================================================');
2816: END IF;
2817:
2818: IF (p_ee_hi_cont_amt = -1) THEN
2819: l_ee_hi_cont_amt := l_ee_rate;

Line 2841: hr_utility.trace(' =======================================================');

2837: l_out_er_hi_cont_base_amount := l_er_cont_base_amount;
2838: END IF;
2839:
2840: IF g_debug THEN
2841: hr_utility.trace(' =======================================================');
2842: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2843: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2844: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2845: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );

Line 2842: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );

2838: END IF;
2839:
2840: IF g_debug THEN
2841: hr_utility.trace(' =======================================================');
2842: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2843: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2844: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2845: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2846: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );

Line 2843: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );

2839:
2840: IF g_debug THEN
2841: hr_utility.trace(' =======================================================');
2842: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2843: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2844: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2845: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2846: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2847: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );

Line 2844: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );

2840: IF g_debug THEN
2841: hr_utility.trace(' =======================================================');
2842: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2843: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2844: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2845: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2846: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2847: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2848: hr_utility.trace(' . l_ee_hi_cont_base_amount: '||l_ee_hi_cont_base_amount);

Line 2845: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );

2841: hr_utility.trace(' =======================================================');
2842: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2843: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2844: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2845: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2846: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2847: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2848: hr_utility.trace(' . l_ee_hi_cont_base_amount: '||l_ee_hi_cont_base_amount);
2849: hr_utility.trace(' . l_er_hi_cont_base_amount: '||l_er_hi_cont_base_amount);

Line 2846: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );

2842: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2843: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2844: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2845: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2846: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2847: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2848: hr_utility.trace(' . l_ee_hi_cont_base_amount: '||l_ee_hi_cont_base_amount);
2849: hr_utility.trace(' . l_er_hi_cont_base_amount: '||l_er_hi_cont_base_amount);
2850: hr_utility.trace(' . l_out_ee_hi_cont_base_amount: '||l_out_ee_hi_cont_base_amount);

Line 2847: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );

2843: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2844: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2845: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2846: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2847: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2848: hr_utility.trace(' . l_ee_hi_cont_base_amount: '||l_ee_hi_cont_base_amount);
2849: hr_utility.trace(' . l_er_hi_cont_base_amount: '||l_er_hi_cont_base_amount);
2850: hr_utility.trace(' . l_out_ee_hi_cont_base_amount: '||l_out_ee_hi_cont_base_amount);
2851: hr_utility.trace(' . l_out_er_hi_cont_base_amount: '||l_out_er_hi_cont_base_amount);

Line 2848: hr_utility.trace(' . l_ee_hi_cont_base_amount: '||l_ee_hi_cont_base_amount);

2844: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2845: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2846: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2847: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2848: hr_utility.trace(' . l_ee_hi_cont_base_amount: '||l_ee_hi_cont_base_amount);
2849: hr_utility.trace(' . l_er_hi_cont_base_amount: '||l_er_hi_cont_base_amount);
2850: hr_utility.trace(' . l_out_ee_hi_cont_base_amount: '||l_out_ee_hi_cont_base_amount);
2851: hr_utility.trace(' . l_out_er_hi_cont_base_amount: '||l_out_er_hi_cont_base_amount);
2852: hr_utility.trace(' =======================================================');

Line 2849: hr_utility.trace(' . l_er_hi_cont_base_amount: '||l_er_hi_cont_base_amount);

2845: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2846: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2847: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2848: hr_utility.trace(' . l_ee_hi_cont_base_amount: '||l_ee_hi_cont_base_amount);
2849: hr_utility.trace(' . l_er_hi_cont_base_amount: '||l_er_hi_cont_base_amount);
2850: hr_utility.trace(' . l_out_ee_hi_cont_base_amount: '||l_out_ee_hi_cont_base_amount);
2851: hr_utility.trace(' . l_out_er_hi_cont_base_amount: '||l_out_er_hi_cont_base_amount);
2852: hr_utility.trace(' =======================================================');
2853: END IF;

Line 2850: hr_utility.trace(' . l_out_ee_hi_cont_base_amount: '||l_out_ee_hi_cont_base_amount);

2846: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2847: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2848: hr_utility.trace(' . l_ee_hi_cont_base_amount: '||l_ee_hi_cont_base_amount);
2849: hr_utility.trace(' . l_er_hi_cont_base_amount: '||l_er_hi_cont_base_amount);
2850: hr_utility.trace(' . l_out_ee_hi_cont_base_amount: '||l_out_ee_hi_cont_base_amount);
2851: hr_utility.trace(' . l_out_er_hi_cont_base_amount: '||l_out_er_hi_cont_base_amount);
2852: hr_utility.trace(' =======================================================');
2853: END IF;
2854:

Line 2851: hr_utility.trace(' . l_out_er_hi_cont_base_amount: '||l_out_er_hi_cont_base_amount);

2847: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2848: hr_utility.trace(' . l_ee_hi_cont_base_amount: '||l_ee_hi_cont_base_amount);
2849: hr_utility.trace(' . l_er_hi_cont_base_amount: '||l_er_hi_cont_base_amount);
2850: hr_utility.trace(' . l_out_ee_hi_cont_base_amount: '||l_out_ee_hi_cont_base_amount);
2851: hr_utility.trace(' . l_out_er_hi_cont_base_amount: '||l_out_er_hi_cont_base_amount);
2852: hr_utility.trace(' =======================================================');
2853: END IF;
2854:
2855: IF (l_out_ee_hi_cont_base_amount = 0) THEN

Line 2852: hr_utility.trace(' =======================================================');

2848: hr_utility.trace(' . l_ee_hi_cont_base_amount: '||l_ee_hi_cont_base_amount);
2849: hr_utility.trace(' . l_er_hi_cont_base_amount: '||l_er_hi_cont_base_amount);
2850: hr_utility.trace(' . l_out_ee_hi_cont_base_amount: '||l_out_ee_hi_cont_base_amount);
2851: hr_utility.trace(' . l_out_er_hi_cont_base_amount: '||l_out_er_hi_cont_base_amount);
2852: hr_utility.trace(' =======================================================');
2853: END IF;
2854:
2855: IF (l_out_ee_hi_cont_base_amount = 0) THEN
2856: l_message :=

Line 2926: hr_utility.trace(' =======================================================');

2922: END IF;
2923:
2924:
2925: IF g_debug THEN
2926: hr_utility.trace(' =======================================================');
2927: hr_utility.trace(' . p_phf_si_type : '||p_phf_si_type );
2928: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2929: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2930: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );

Line 2927: hr_utility.trace(' . p_phf_si_type : '||p_phf_si_type );

2923:
2924:
2925: IF g_debug THEN
2926: hr_utility.trace(' =======================================================');
2927: hr_utility.trace(' . p_phf_si_type : '||p_phf_si_type );
2928: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2929: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2930: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2931: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );

Line 2928: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );

2924:
2925: IF g_debug THEN
2926: hr_utility.trace(' =======================================================');
2927: hr_utility.trace(' . p_phf_si_type : '||p_phf_si_type );
2928: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2929: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2930: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2931: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2932: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type );

Line 2929: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );

2925: IF g_debug THEN
2926: hr_utility.trace(' =======================================================');
2927: hr_utility.trace(' . p_phf_si_type : '||p_phf_si_type );
2928: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2929: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2930: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2931: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2932: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type );
2933: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );

Line 2930: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );

2926: hr_utility.trace(' =======================================================');
2927: hr_utility.trace(' . p_phf_si_type : '||p_phf_si_type );
2928: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2929: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2930: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2931: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2932: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type );
2933: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
2934: hr_utility.trace(' . l_ee_phf_si_amount_higher: '||l_ee_phf_si_amount_higher);

Line 2931: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );

2927: hr_utility.trace(' . p_phf_si_type : '||p_phf_si_type );
2928: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2929: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2930: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2931: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2932: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type );
2933: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
2934: hr_utility.trace(' . l_ee_phf_si_amount_higher: '||l_ee_phf_si_amount_higher);
2935: hr_utility.trace(' . l_er_phf_si_amount_higher: '||l_er_phf_si_amount_higher);

Line 2932: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type );

2928: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2929: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2930: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2931: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2932: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type );
2933: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
2934: hr_utility.trace(' . l_ee_phf_si_amount_higher: '||l_ee_phf_si_amount_higher);
2935: hr_utility.trace(' . l_er_phf_si_amount_higher: '||l_er_phf_si_amount_higher);
2936: hr_utility.trace(' =======================================================');

Line 2933: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );

2929: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2930: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2931: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2932: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type );
2933: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
2934: hr_utility.trace(' . l_ee_phf_si_amount_higher: '||l_ee_phf_si_amount_higher);
2935: hr_utility.trace(' . l_er_phf_si_amount_higher: '||l_er_phf_si_amount_higher);
2936: hr_utility.trace(' =======================================================');
2937: END IF;

Line 2934: hr_utility.trace(' . l_ee_phf_si_amount_higher: '||l_ee_phf_si_amount_higher);

2930: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2931: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2932: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type );
2933: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
2934: hr_utility.trace(' . l_ee_phf_si_amount_higher: '||l_ee_phf_si_amount_higher);
2935: hr_utility.trace(' . l_er_phf_si_amount_higher: '||l_er_phf_si_amount_higher);
2936: hr_utility.trace(' =======================================================');
2937: END IF;
2938:

Line 2935: hr_utility.trace(' . l_er_phf_si_amount_higher: '||l_er_phf_si_amount_higher);

2931: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2932: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type );
2933: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
2934: hr_utility.trace(' . l_ee_phf_si_amount_higher: '||l_ee_phf_si_amount_higher);
2935: hr_utility.trace(' . l_er_phf_si_amount_higher: '||l_er_phf_si_amount_higher);
2936: hr_utility.trace(' =======================================================');
2937: END IF;
2938:
2939:

Line 2936: hr_utility.trace(' =======================================================');

2932: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type );
2933: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
2934: hr_utility.trace(' . l_ee_phf_si_amount_higher: '||l_ee_phf_si_amount_higher);
2935: hr_utility.trace(' . l_er_phf_si_amount_higher: '||l_er_phf_si_amount_higher);
2936: hr_utility.trace(' =======================================================');
2937: END IF;
2938:
2939:
2940: /* 6828199 - all the 4 phf si types can enter this piece of code now

Line 3131: hr_utility.trace(' =======================================================');

3127:
3128:
3129:
3130: IF g_debug THEN
3131: hr_utility.trace(' =======================================================');
3132: hr_utility.trace('p_ee_phf_si_amount '||p_ee_phf_si_amount );
3133: hr_utility.trace('p_er_phf_si_amount '||p_er_phf_si_amount );
3134: hr_utility.trace('p_er_cont_base_amount '||p_er_cont_base_amount );
3135: hr_utility.trace('p_ee_cont_base_amount '||p_ee_cont_base_amount );

Line 3132: hr_utility.trace('p_ee_phf_si_amount '||p_ee_phf_si_amount );

3128:
3129:
3130: IF g_debug THEN
3131: hr_utility.trace(' =======================================================');
3132: hr_utility.trace('p_ee_phf_si_amount '||p_ee_phf_si_amount );
3133: hr_utility.trace('p_er_phf_si_amount '||p_er_phf_si_amount );
3134: hr_utility.trace('p_er_cont_base_amount '||p_er_cont_base_amount );
3135: hr_utility.trace('p_ee_cont_base_amount '||p_ee_cont_base_amount );
3136: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont );

Line 3133: hr_utility.trace('p_er_phf_si_amount '||p_er_phf_si_amount );

3129:
3130: IF g_debug THEN
3131: hr_utility.trace(' =======================================================');
3132: hr_utility.trace('p_ee_phf_si_amount '||p_ee_phf_si_amount );
3133: hr_utility.trace('p_er_phf_si_amount '||p_er_phf_si_amount );
3134: hr_utility.trace('p_er_cont_base_amount '||p_er_cont_base_amount );
3135: hr_utility.trace('p_ee_cont_base_amount '||p_ee_cont_base_amount );
3136: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont );
3137: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont );

Line 3134: hr_utility.trace('p_er_cont_base_amount '||p_er_cont_base_amount );

3130: IF g_debug THEN
3131: hr_utility.trace(' =======================================================');
3132: hr_utility.trace('p_ee_phf_si_amount '||p_ee_phf_si_amount );
3133: hr_utility.trace('p_er_phf_si_amount '||p_er_phf_si_amount );
3134: hr_utility.trace('p_er_cont_base_amount '||p_er_cont_base_amount );
3135: hr_utility.trace('p_ee_cont_base_amount '||p_ee_cont_base_amount );
3136: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont );
3137: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont );
3138: hr_utility.trace(' =======================================================');

Line 3135: hr_utility.trace('p_ee_cont_base_amount '||p_ee_cont_base_amount );

3131: hr_utility.trace(' =======================================================');
3132: hr_utility.trace('p_ee_phf_si_amount '||p_ee_phf_si_amount );
3133: hr_utility.trace('p_er_phf_si_amount '||p_er_phf_si_amount );
3134: hr_utility.trace('p_er_cont_base_amount '||p_er_cont_base_amount );
3135: hr_utility.trace('p_ee_cont_base_amount '||p_ee_cont_base_amount );
3136: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont );
3137: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont );
3138: hr_utility.trace(' =======================================================');
3139: END IF;

Line 3136: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont );

3132: hr_utility.trace('p_ee_phf_si_amount '||p_ee_phf_si_amount );
3133: hr_utility.trace('p_er_phf_si_amount '||p_er_phf_si_amount );
3134: hr_utility.trace('p_er_cont_base_amount '||p_er_cont_base_amount );
3135: hr_utility.trace('p_ee_cont_base_amount '||p_ee_cont_base_amount );
3136: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont );
3137: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont );
3138: hr_utility.trace(' =======================================================');
3139: END IF;
3140:

Line 3137: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont );

3133: hr_utility.trace('p_er_phf_si_amount '||p_er_phf_si_amount );
3134: hr_utility.trace('p_er_cont_base_amount '||p_er_cont_base_amount );
3135: hr_utility.trace('p_ee_cont_base_amount '||p_ee_cont_base_amount );
3136: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont );
3137: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont );
3138: hr_utility.trace(' =======================================================');
3139: END IF;
3140:
3141: hr_cn_api.set_location(g_debug,' Leaving PHF and SI Enhancements started from 1-Jan-2006: ', 460);

Line 3138: hr_utility.trace(' =======================================================');

3134: hr_utility.trace('p_er_cont_base_amount '||p_er_cont_base_amount );
3135: hr_utility.trace('p_ee_cont_base_amount '||p_ee_cont_base_amount );
3136: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont );
3137: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont );
3138: hr_utility.trace(' =======================================================');
3139: END IF;
3140:
3141: hr_cn_api.set_location(g_debug,' Leaving PHF and SI Enhancements started from 1-Jan-2006: ', 460);
3142:

Line 3365: g_debug := hr_utility.debug_enabled;

3361:
3362:
3363: BEGIN
3364:
3365: g_debug := hr_utility.debug_enabled;
3366: g_procedure_name := g_package_name || 'calculate_contribution';
3367:
3368: hr_cn_api.set_location(g_debug, ' Entering: '||g_procedure_name, 10);
3369:

Line 3424: hr_utility.trace(' Calculate_contribution : Message=>' || l_message);

3420: ,p_ee_rounding_method => l_ee_rate_rounding_method
3421: ,p_er_rounding_method => l_er_rate_rounding_method
3422: );
3423:
3424: hr_utility.trace(' Calculate_contribution : Message=>' || l_message);
3425: IF l_message <> 'SUCCESS'
3426: THEN
3427: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 25);
3428: RAISE initialize_on_error;

Line 3457: hr_utility.trace(' get_cont_base_method : Message=>' || l_message);

3453: ,p_er_fixed_amount => l_er_fixed_amount
3454: ,p_tax_thrhld_amount => l_tax_thrhld_amount -- added for bug 6828199
3455: );
3456:
3457: hr_utility.trace(' get_cont_base_method : Message=>' || l_message);
3458:
3459: IF l_message <> 'SUCCESS'
3460: THEN
3461: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 45);

Line 3493: hr_utility.trace(' l_recalculate_flag : Message=>' || l_recalculate_flag);

3489: ,p_switch_month => l_switch_month
3490: ,p_calculation_date => l_calculation_date
3491: ,p_process_date => p_pay_proc_period_end_date);
3492:
3493: hr_utility.trace(' l_recalculate_flag : Message=>' || l_recalculate_flag);
3494:
3495: IF l_recalculate_flag='N' THEN
3496: --
3497: -- Step 3: Assign the contribution base amounts with corresponding

Line 3653: hr_utility.trace(' l_ee_rate =>' || l_ee_rate);

3649:
3650: END IF;
3651:
3652: */
3653: hr_utility.trace(' l_ee_rate =>' || l_ee_rate);
3654: hr_utility.trace(' l_er_rate =>' || l_er_rate);
3655:
3656: l_ee_phf_si_amount :=
3657: get_cont_amount

Line 3654: hr_utility.trace(' l_er_rate =>' || l_er_rate);

3650: END IF;
3651:
3652: */
3653: hr_utility.trace(' l_ee_rate =>' || l_ee_rate);
3654: hr_utility.trace(' l_er_rate =>' || l_er_rate);
3655:
3656: l_ee_phf_si_amount :=
3657: get_cont_amount
3658: (p_cont_base => l_ee_cont_base_amount

Line 3673: hr_utility.trace(' =======================================================');

3669: RETURN l_message;
3670: END IF;
3671:
3672: IF g_debug THEN
3673: hr_utility.trace(' =======================================================');
3674: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount );
3675: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
3676: hr_utility.trace(' . l_er_rate : '||l_er_rate );
3677: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method );

Line 3674: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount );

3670: END IF;
3671:
3672: IF g_debug THEN
3673: hr_utility.trace(' =======================================================');
3674: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount );
3675: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
3676: hr_utility.trace(' . l_er_rate : '||l_er_rate );
3677: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method );
3678: hr_utility.trace(' =======================================================');

Line 3675: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );

3671:
3672: IF g_debug THEN
3673: hr_utility.trace(' =======================================================');
3674: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount );
3675: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
3676: hr_utility.trace(' . l_er_rate : '||l_er_rate );
3677: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method );
3678: hr_utility.trace(' =======================================================');
3679: END IF;

Line 3676: hr_utility.trace(' . l_er_rate : '||l_er_rate );

3672: IF g_debug THEN
3673: hr_utility.trace(' =======================================================');
3674: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount );
3675: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
3676: hr_utility.trace(' . l_er_rate : '||l_er_rate );
3677: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method );
3678: hr_utility.trace(' =======================================================');
3679: END IF;
3680:

Line 3677: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method );

3673: hr_utility.trace(' =======================================================');
3674: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount );
3675: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
3676: hr_utility.trace(' . l_er_rate : '||l_er_rate );
3677: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method );
3678: hr_utility.trace(' =======================================================');
3679: END IF;
3680:
3681: l_er_phf_si_amount :=

Line 3678: hr_utility.trace(' =======================================================');

3674: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount );
3675: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
3676: hr_utility.trace(' . l_er_rate : '||l_er_rate );
3677: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method );
3678: hr_utility.trace(' =======================================================');
3679: END IF;
3680:
3681: l_er_phf_si_amount :=
3682: get_cont_amount

Line 3698: hr_utility.trace(' =======================================================');

3694:
3695:
3696:
3697: IF g_debug THEN
3698: hr_utility.trace(' =======================================================');
3699: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);
3700: hr_utility.trace(' . l_er_rate : '||l_er_rate);
3701: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
3702: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);

Line 3699: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);

3695:
3696:
3697: IF g_debug THEN
3698: hr_utility.trace(' =======================================================');
3699: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);
3700: hr_utility.trace(' . l_er_rate : '||l_er_rate);
3701: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
3702: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
3703: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);

Line 3700: hr_utility.trace(' . l_er_rate : '||l_er_rate);

3696:
3697: IF g_debug THEN
3698: hr_utility.trace(' =======================================================');
3699: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);
3700: hr_utility.trace(' . l_er_rate : '||l_er_rate);
3701: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
3702: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
3703: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
3704: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);

Line 3701: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);

3697: IF g_debug THEN
3698: hr_utility.trace(' =======================================================');
3699: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);
3700: hr_utility.trace(' . l_er_rate : '||l_er_rate);
3701: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
3702: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
3703: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
3704: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
3705: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);

Line 3702: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);

3698: hr_utility.trace(' =======================================================');
3699: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);
3700: hr_utility.trace(' . l_er_rate : '||l_er_rate);
3701: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
3702: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
3703: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
3704: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
3705: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
3706: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);

Line 3703: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);

3699: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);
3700: hr_utility.trace(' . l_er_rate : '||l_er_rate);
3701: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
3702: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
3703: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
3704: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
3705: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
3706: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
3707: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);

Line 3704: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);

3700: hr_utility.trace(' . l_er_rate : '||l_er_rate);
3701: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
3702: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
3703: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
3704: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
3705: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
3706: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
3707: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
3708: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);

Line 3705: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);

3701: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
3702: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
3703: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
3704: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
3705: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
3706: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
3707: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
3708: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
3709: hr_utility.trace(' . l_average_salary : '||l_average_salary);

Line 3706: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);

3702: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
3703: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
3704: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
3705: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
3706: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
3707: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
3708: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
3709: hr_utility.trace(' . l_average_salary : '||l_average_salary);
3710: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);

Line 3707: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);

3703: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
3704: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
3705: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
3706: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
3707: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
3708: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
3709: hr_utility.trace(' . l_average_salary : '||l_average_salary);
3710: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
3711: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);

Line 3708: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);

3704: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
3705: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
3706: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
3707: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
3708: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
3709: hr_utility.trace(' . l_average_salary : '||l_average_salary);
3710: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
3711: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
3712: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);

Line 3709: hr_utility.trace(' . l_average_salary : '||l_average_salary);

3705: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
3706: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
3707: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
3708: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
3709: hr_utility.trace(' . l_average_salary : '||l_average_salary);
3710: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
3711: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
3712: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
3713: hr_utility.trace(' . l_phf_high_lim_exemp : '||l_phf_high_lim_exemp);

Line 3710: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);

3706: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
3707: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
3708: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
3709: hr_utility.trace(' . l_average_salary : '||l_average_salary);
3710: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
3711: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
3712: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
3713: hr_utility.trace(' . l_phf_high_lim_exemp : '||l_phf_high_lim_exemp);
3714: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);

Line 3711: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);

3707: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
3708: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
3709: hr_utility.trace(' . l_average_salary : '||l_average_salary);
3710: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
3711: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
3712: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
3713: hr_utility.trace(' . l_phf_high_lim_exemp : '||l_phf_high_lim_exemp);
3714: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
3715: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);

Line 3712: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);

3708: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
3709: hr_utility.trace(' . l_average_salary : '||l_average_salary);
3710: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
3711: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
3712: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
3713: hr_utility.trace(' . l_phf_high_lim_exemp : '||l_phf_high_lim_exemp);
3714: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
3715: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
3716:

Line 3713: hr_utility.trace(' . l_phf_high_lim_exemp : '||l_phf_high_lim_exemp);

3709: hr_utility.trace(' . l_average_salary : '||l_average_salary);
3710: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
3711: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
3712: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
3713: hr_utility.trace(' . l_phf_high_lim_exemp : '||l_phf_high_lim_exemp);
3714: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
3715: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
3716:
3717: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);

Line 3714: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);

3710: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
3711: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
3712: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
3713: hr_utility.trace(' . l_phf_high_lim_exemp : '||l_phf_high_lim_exemp);
3714: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
3715: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
3716:
3717: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
3718: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);

Line 3715: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);

3711: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
3712: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
3713: hr_utility.trace(' . l_phf_high_lim_exemp : '||l_phf_high_lim_exemp);
3714: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
3715: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
3716:
3717: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
3718: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
3719: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);

Line 3717: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);

3713: hr_utility.trace(' . l_phf_high_lim_exemp : '||l_phf_high_lim_exemp);
3714: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
3715: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
3716:
3717: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
3718: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
3719: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
3720:
3721: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );

Line 3718: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);

3714: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
3715: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
3716:
3717: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
3718: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
3719: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
3720:
3721: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
3722: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );

Line 3719: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);

3715: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
3716:
3717: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
3718: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
3719: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
3720:
3721: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
3722: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
3723: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );

Line 3721: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );

3717: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
3718: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
3719: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
3720:
3721: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
3722: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
3723: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
3724: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
3725: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );

Line 3722: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );

3718: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
3719: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
3720:
3721: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
3722: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
3723: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
3724: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
3725: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
3726: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );

Line 3723: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );

3719: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
3720:
3721: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
3722: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
3723: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
3724: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
3725: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
3726: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
3727: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);

Line 3724: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );

3720:
3721: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
3722: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
3723: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
3724: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
3725: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
3726: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
3727: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
3728: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);

Line 3725: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );

3721: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
3722: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
3723: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
3724: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
3725: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
3726: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
3727: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
3728: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
3729: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);

Line 3726: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );

3722: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
3723: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
3724: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
3725: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
3726: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
3727: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
3728: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
3729: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
3730: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);

Line 3727: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);

3723: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
3724: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
3725: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
3726: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
3727: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
3728: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
3729: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
3730: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
3731: hr_utility.trace(' . l_ee_thrhld_rate : '||l_ee_thrhld_rate);

Line 3728: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);

3724: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
3725: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
3726: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
3727: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
3728: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
3729: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
3730: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
3731: hr_utility.trace(' . l_ee_thrhld_rate : '||l_ee_thrhld_rate);
3732: hr_utility.trace(' . l_er_thrhld_rate : '||l_er_thrhld_rate);

Line 3729: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);

3725: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
3726: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
3727: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
3728: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
3729: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
3730: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
3731: hr_utility.trace(' . l_ee_thrhld_rate : '||l_ee_thrhld_rate);
3732: hr_utility.trace(' . l_er_thrhld_rate : '||l_er_thrhld_rate);
3733: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);

Line 3730: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);

3726: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
3727: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
3728: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
3729: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
3730: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
3731: hr_utility.trace(' . l_ee_thrhld_rate : '||l_ee_thrhld_rate);
3732: hr_utility.trace(' . l_er_thrhld_rate : '||l_er_thrhld_rate);
3733: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);
3734: hr_utility.trace(' =======================================================');

Line 3731: hr_utility.trace(' . l_ee_thrhld_rate : '||l_ee_thrhld_rate);

3727: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
3728: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
3729: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
3730: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
3731: hr_utility.trace(' . l_ee_thrhld_rate : '||l_ee_thrhld_rate);
3732: hr_utility.trace(' . l_er_thrhld_rate : '||l_er_thrhld_rate);
3733: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);
3734: hr_utility.trace(' =======================================================');
3735: END IF;

Line 3732: hr_utility.trace(' . l_er_thrhld_rate : '||l_er_thrhld_rate);

3728: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
3729: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
3730: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
3731: hr_utility.trace(' . l_ee_thrhld_rate : '||l_ee_thrhld_rate);
3732: hr_utility.trace(' . l_er_thrhld_rate : '||l_er_thrhld_rate);
3733: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);
3734: hr_utility.trace(' =======================================================');
3735: END IF;
3736:

Line 3733: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);

3729: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
3730: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
3731: hr_utility.trace(' . l_ee_thrhld_rate : '||l_ee_thrhld_rate);
3732: hr_utility.trace(' . l_er_thrhld_rate : '||l_er_thrhld_rate);
3733: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);
3734: hr_utility.trace(' =======================================================');
3735: END IF;
3736:
3737:

Line 3734: hr_utility.trace(' =======================================================');

3730: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
3731: hr_utility.trace(' . l_ee_thrhld_rate : '||l_ee_thrhld_rate);
3732: hr_utility.trace(' . l_er_thrhld_rate : '||l_er_thrhld_rate);
3733: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);
3734: hr_utility.trace(' =======================================================');
3735: END IF;
3736:
3737:
3738:

Line 3851: hr_utility.trace(' ====================================================================');

3847: --
3848: -- In case there is a previous run, subtract the PHF/SI amounts if any
3849: --
3850: IF g_debug THEN
3851: hr_utility.trace(' ====================================================================');
3852: hr_utility.trace(' EE PHF SI Amount (RUN) : '|| l_ee_phf_si_amount);
3853: hr_utility.trace(' ER PHF SI Amount (RUN) : '|| l_er_phf_si_amount);
3854: hr_utility.trace(' EE PHF SI Amount (PTD) : '|| l_ee_deductions_asg_er_ptd);
3855: hr_utility.trace(' ER PHF SI Amount (PTD) : '|| l_er_deductions_asg_er_ptd);

Line 3852: hr_utility.trace(' EE PHF SI Amount (RUN) : '|| l_ee_phf_si_amount);

3848: -- In case there is a previous run, subtract the PHF/SI amounts if any
3849: --
3850: IF g_debug THEN
3851: hr_utility.trace(' ====================================================================');
3852: hr_utility.trace(' EE PHF SI Amount (RUN) : '|| l_ee_phf_si_amount);
3853: hr_utility.trace(' ER PHF SI Amount (RUN) : '|| l_er_phf_si_amount);
3854: hr_utility.trace(' EE PHF SI Amount (PTD) : '|| l_ee_deductions_asg_er_ptd);
3855: hr_utility.trace(' ER PHF SI Amount (PTD) : '|| l_er_deductions_asg_er_ptd);
3856: hr_utility.trace(' Undeducted EE PHF SI Amount (PTD) : '|| l_undeducted_ee_asg_er_ptd);

Line 3853: hr_utility.trace(' ER PHF SI Amount (RUN) : '|| l_er_phf_si_amount);

3849: --
3850: IF g_debug THEN
3851: hr_utility.trace(' ====================================================================');
3852: hr_utility.trace(' EE PHF SI Amount (RUN) : '|| l_ee_phf_si_amount);
3853: hr_utility.trace(' ER PHF SI Amount (RUN) : '|| l_er_phf_si_amount);
3854: hr_utility.trace(' EE PHF SI Amount (PTD) : '|| l_ee_deductions_asg_er_ptd);
3855: hr_utility.trace(' ER PHF SI Amount (PTD) : '|| l_er_deductions_asg_er_ptd);
3856: hr_utility.trace(' Undeducted EE PHF SI Amount (PTD) : '|| l_undeducted_ee_asg_er_ptd);
3857: hr_utility.trace(' Undeducted ER PHF SI Amount (PTD) : '|| l_undeducted_er_asg_er_ptd);

Line 3854: hr_utility.trace(' EE PHF SI Amount (PTD) : '|| l_ee_deductions_asg_er_ptd);

3850: IF g_debug THEN
3851: hr_utility.trace(' ====================================================================');
3852: hr_utility.trace(' EE PHF SI Amount (RUN) : '|| l_ee_phf_si_amount);
3853: hr_utility.trace(' ER PHF SI Amount (RUN) : '|| l_er_phf_si_amount);
3854: hr_utility.trace(' EE PHF SI Amount (PTD) : '|| l_ee_deductions_asg_er_ptd);
3855: hr_utility.trace(' ER PHF SI Amount (PTD) : '|| l_er_deductions_asg_er_ptd);
3856: hr_utility.trace(' Undeducted EE PHF SI Amount (PTD) : '|| l_undeducted_ee_asg_er_ptd);
3857: hr_utility.trace(' Undeducted ER PHF SI Amount (PTD) : '|| l_undeducted_er_asg_er_ptd);
3858: END IF;

Line 3855: hr_utility.trace(' ER PHF SI Amount (PTD) : '|| l_er_deductions_asg_er_ptd);

3851: hr_utility.trace(' ====================================================================');
3852: hr_utility.trace(' EE PHF SI Amount (RUN) : '|| l_ee_phf_si_amount);
3853: hr_utility.trace(' ER PHF SI Amount (RUN) : '|| l_er_phf_si_amount);
3854: hr_utility.trace(' EE PHF SI Amount (PTD) : '|| l_ee_deductions_asg_er_ptd);
3855: hr_utility.trace(' ER PHF SI Amount (PTD) : '|| l_er_deductions_asg_er_ptd);
3856: hr_utility.trace(' Undeducted EE PHF SI Amount (PTD) : '|| l_undeducted_ee_asg_er_ptd);
3857: hr_utility.trace(' Undeducted ER PHF SI Amount (PTD) : '|| l_undeducted_er_asg_er_ptd);
3858: END IF;
3859:

Line 3856: hr_utility.trace(' Undeducted EE PHF SI Amount (PTD) : '|| l_undeducted_ee_asg_er_ptd);

3852: hr_utility.trace(' EE PHF SI Amount (RUN) : '|| l_ee_phf_si_amount);
3853: hr_utility.trace(' ER PHF SI Amount (RUN) : '|| l_er_phf_si_amount);
3854: hr_utility.trace(' EE PHF SI Amount (PTD) : '|| l_ee_deductions_asg_er_ptd);
3855: hr_utility.trace(' ER PHF SI Amount (PTD) : '|| l_er_deductions_asg_er_ptd);
3856: hr_utility.trace(' Undeducted EE PHF SI Amount (PTD) : '|| l_undeducted_ee_asg_er_ptd);
3857: hr_utility.trace(' Undeducted ER PHF SI Amount (PTD) : '|| l_undeducted_er_asg_er_ptd);
3858: END IF;
3859:
3860: l_ee_phf_si_amount:= l_ee_phf_si_amount - l_ee_deductions_asg_er_ptd - l_undeducted_ee_asg_er_ptd;

Line 3857: hr_utility.trace(' Undeducted ER PHF SI Amount (PTD) : '|| l_undeducted_er_asg_er_ptd);

3853: hr_utility.trace(' ER PHF SI Amount (RUN) : '|| l_er_phf_si_amount);
3854: hr_utility.trace(' EE PHF SI Amount (PTD) : '|| l_ee_deductions_asg_er_ptd);
3855: hr_utility.trace(' ER PHF SI Amount (PTD) : '|| l_er_deductions_asg_er_ptd);
3856: hr_utility.trace(' Undeducted EE PHF SI Amount (PTD) : '|| l_undeducted_ee_asg_er_ptd);
3857: hr_utility.trace(' Undeducted ER PHF SI Amount (PTD) : '|| l_undeducted_er_asg_er_ptd);
3858: END IF;
3859:
3860: l_ee_phf_si_amount:= l_ee_phf_si_amount - l_ee_deductions_asg_er_ptd - l_undeducted_ee_asg_er_ptd;
3861: l_er_phf_si_amount:= l_er_phf_si_amount - l_er_deductions_asg_er_ptd - l_undeducted_er_asg_er_ptd;

Line 3866: hr_utility.trace(' EE PHF SI Amount (Final) : '|| l_ee_phf_si_amount);

3862: l_ee_taxable_cont := l_ee_taxable_cont - p_lt_ee_taxable_cont_ptd;
3863: l_er_taxable_cont := l_er_taxable_cont - p_lt_er_taxable_cont_ptd;
3864:
3865: IF g_debug THEN
3866: hr_utility.trace(' EE PHF SI Amount (Final) : '|| l_ee_phf_si_amount);
3867: hr_utility.trace(' ER PHF SI Amount (Final) : '|| l_er_phf_si_amount);
3868: hr_utility.trace(' ====================================================================');
3869: END IF;
3870: --

Line 3867: hr_utility.trace(' ER PHF SI Amount (Final) : '|| l_er_phf_si_amount);

3863: l_er_taxable_cont := l_er_taxable_cont - p_lt_er_taxable_cont_ptd;
3864:
3865: IF g_debug THEN
3866: hr_utility.trace(' EE PHF SI Amount (Final) : '|| l_ee_phf_si_amount);
3867: hr_utility.trace(' ER PHF SI Amount (Final) : '|| l_er_phf_si_amount);
3868: hr_utility.trace(' ====================================================================');
3869: END IF;
3870: --
3871:

Line 3868: hr_utility.trace(' ====================================================================');

3864:
3865: IF g_debug THEN
3866: hr_utility.trace(' EE PHF SI Amount (Final) : '|| l_ee_phf_si_amount);
3867: hr_utility.trace(' ER PHF SI Amount (Final) : '|| l_er_phf_si_amount);
3868: hr_utility.trace(' ====================================================================');
3869: END IF;
3870: --
3871:
3872: -- Finally set all the output variables

Line 3887: hr_utility.trace(' ====================================================================');

3883: p_ee_taxable_cont := l_ee_taxable_cont;
3884: p_er_taxable_cont := l_er_taxable_cont;
3885:
3886: IF g_debug THEN
3887: hr_utility.trace(' ====================================================================');
3888: hr_utility.trace(' Calculation Date : '|| p_calculation_date);
3889: hr_utility.trace(' Employee PHF SI Amount : '|| p_ee_phf_si_amount);
3890: hr_utility.trace(' Employer PHF SI Amount : '|| p_er_phf_si_amount);
3891: hr_utility.trace(' Undeducted Employee PHF SI Amount : '|| p_undeducted_ee_phf_si_amount);

Line 3888: hr_utility.trace(' Calculation Date : '|| p_calculation_date);

3884: p_er_taxable_cont := l_er_taxable_cont;
3885:
3886: IF g_debug THEN
3887: hr_utility.trace(' ====================================================================');
3888: hr_utility.trace(' Calculation Date : '|| p_calculation_date);
3889: hr_utility.trace(' Employee PHF SI Amount : '|| p_ee_phf_si_amount);
3890: hr_utility.trace(' Employer PHF SI Amount : '|| p_er_phf_si_amount);
3891: hr_utility.trace(' Undeducted Employee PHF SI Amount : '|| p_undeducted_ee_phf_si_amount);
3892: hr_utility.trace(' Undeducted Employer PHF SI Amount : '|| p_undeducted_er_phf_si_amount);

Line 3889: hr_utility.trace(' Employee PHF SI Amount : '|| p_ee_phf_si_amount);

3885:
3886: IF g_debug THEN
3887: hr_utility.trace(' ====================================================================');
3888: hr_utility.trace(' Calculation Date : '|| p_calculation_date);
3889: hr_utility.trace(' Employee PHF SI Amount : '|| p_ee_phf_si_amount);
3890: hr_utility.trace(' Employer PHF SI Amount : '|| p_er_phf_si_amount);
3891: hr_utility.trace(' Undeducted Employee PHF SI Amount : '|| p_undeducted_ee_phf_si_amount);
3892: hr_utility.trace(' Undeducted Employer PHF SI Amount : '|| p_undeducted_er_phf_si_amount);
3893: hr_utility.trace(' Employee new cont base Amount : '|| p_new_ee_cont_base_amount);

Line 3890: hr_utility.trace(' Employer PHF SI Amount : '|| p_er_phf_si_amount);

3886: IF g_debug THEN
3887: hr_utility.trace(' ====================================================================');
3888: hr_utility.trace(' Calculation Date : '|| p_calculation_date);
3889: hr_utility.trace(' Employee PHF SI Amount : '|| p_ee_phf_si_amount);
3890: hr_utility.trace(' Employer PHF SI Amount : '|| p_er_phf_si_amount);
3891: hr_utility.trace(' Undeducted Employee PHF SI Amount : '|| p_undeducted_ee_phf_si_amount);
3892: hr_utility.trace(' Undeducted Employer PHF SI Amount : '|| p_undeducted_er_phf_si_amount);
3893: hr_utility.trace(' Employee new cont base Amount : '|| p_new_ee_cont_base_amount);
3894: hr_utility.trace(' Employer new cont base Amount : '|| p_new_er_cont_base_amount);

Line 3891: hr_utility.trace(' Undeducted Employee PHF SI Amount : '|| p_undeducted_ee_phf_si_amount);

3887: hr_utility.trace(' ====================================================================');
3888: hr_utility.trace(' Calculation Date : '|| p_calculation_date);
3889: hr_utility.trace(' Employee PHF SI Amount : '|| p_ee_phf_si_amount);
3890: hr_utility.trace(' Employer PHF SI Amount : '|| p_er_phf_si_amount);
3891: hr_utility.trace(' Undeducted Employee PHF SI Amount : '|| p_undeducted_ee_phf_si_amount);
3892: hr_utility.trace(' Undeducted Employer PHF SI Amount : '|| p_undeducted_er_phf_si_amount);
3893: hr_utility.trace(' Employee new cont base Amount : '|| p_new_ee_cont_base_amount);
3894: hr_utility.trace(' Employer new cont base Amount : '|| p_new_er_cont_base_amount);
3895: hr_utility.trace(' Employee cont base Amount : '|| p_ee_cont_base_amount);

Line 3892: hr_utility.trace(' Undeducted Employer PHF SI Amount : '|| p_undeducted_er_phf_si_amount);

3888: hr_utility.trace(' Calculation Date : '|| p_calculation_date);
3889: hr_utility.trace(' Employee PHF SI Amount : '|| p_ee_phf_si_amount);
3890: hr_utility.trace(' Employer PHF SI Amount : '|| p_er_phf_si_amount);
3891: hr_utility.trace(' Undeducted Employee PHF SI Amount : '|| p_undeducted_ee_phf_si_amount);
3892: hr_utility.trace(' Undeducted Employer PHF SI Amount : '|| p_undeducted_er_phf_si_amount);
3893: hr_utility.trace(' Employee new cont base Amount : '|| p_new_ee_cont_base_amount);
3894: hr_utility.trace(' Employer new cont base Amount : '|| p_new_er_cont_base_amount);
3895: hr_utility.trace(' Employee cont base Amount : '|| p_ee_cont_base_amount);
3896: hr_utility.trace(' Employer cont base Amount : '|| p_er_cont_base_amount);

Line 3893: hr_utility.trace(' Employee new cont base Amount : '|| p_new_ee_cont_base_amount);

3889: hr_utility.trace(' Employee PHF SI Amount : '|| p_ee_phf_si_amount);
3890: hr_utility.trace(' Employer PHF SI Amount : '|| p_er_phf_si_amount);
3891: hr_utility.trace(' Undeducted Employee PHF SI Amount : '|| p_undeducted_ee_phf_si_amount);
3892: hr_utility.trace(' Undeducted Employer PHF SI Amount : '|| p_undeducted_er_phf_si_amount);
3893: hr_utility.trace(' Employee new cont base Amount : '|| p_new_ee_cont_base_amount);
3894: hr_utility.trace(' Employer new cont base Amount : '|| p_new_er_cont_base_amount);
3895: hr_utility.trace(' Employee cont base Amount : '|| p_ee_cont_base_amount);
3896: hr_utility.trace(' Employer cont base Amount : '|| p_er_cont_base_amount);
3897: hr_utility.trace(' =====================================================================');

Line 3894: hr_utility.trace(' Employer new cont base Amount : '|| p_new_er_cont_base_amount);

3890: hr_utility.trace(' Employer PHF SI Amount : '|| p_er_phf_si_amount);
3891: hr_utility.trace(' Undeducted Employee PHF SI Amount : '|| p_undeducted_ee_phf_si_amount);
3892: hr_utility.trace(' Undeducted Employer PHF SI Amount : '|| p_undeducted_er_phf_si_amount);
3893: hr_utility.trace(' Employee new cont base Amount : '|| p_new_ee_cont_base_amount);
3894: hr_utility.trace(' Employer new cont base Amount : '|| p_new_er_cont_base_amount);
3895: hr_utility.trace(' Employee cont base Amount : '|| p_ee_cont_base_amount);
3896: hr_utility.trace(' Employer cont base Amount : '|| p_er_cont_base_amount);
3897: hr_utility.trace(' =====================================================================');
3898: END IF;

Line 3895: hr_utility.trace(' Employee cont base Amount : '|| p_ee_cont_base_amount);

3891: hr_utility.trace(' Undeducted Employee PHF SI Amount : '|| p_undeducted_ee_phf_si_amount);
3892: hr_utility.trace(' Undeducted Employer PHF SI Amount : '|| p_undeducted_er_phf_si_amount);
3893: hr_utility.trace(' Employee new cont base Amount : '|| p_new_ee_cont_base_amount);
3894: hr_utility.trace(' Employer new cont base Amount : '|| p_new_er_cont_base_amount);
3895: hr_utility.trace(' Employee cont base Amount : '|| p_ee_cont_base_amount);
3896: hr_utility.trace(' Employer cont base Amount : '|| p_er_cont_base_amount);
3897: hr_utility.trace(' =====================================================================');
3898: END IF;
3899:

Line 3896: hr_utility.trace(' Employer cont base Amount : '|| p_er_cont_base_amount);

3892: hr_utility.trace(' Undeducted Employer PHF SI Amount : '|| p_undeducted_er_phf_si_amount);
3893: hr_utility.trace(' Employee new cont base Amount : '|| p_new_ee_cont_base_amount);
3894: hr_utility.trace(' Employer new cont base Amount : '|| p_new_er_cont_base_amount);
3895: hr_utility.trace(' Employee cont base Amount : '|| p_ee_cont_base_amount);
3896: hr_utility.trace(' Employer cont base Amount : '|| p_er_cont_base_amount);
3897: hr_utility.trace(' =====================================================================');
3898: END IF;
3899:
3900: hr_cn_api.set_location(g_debug,' Leaving ' || g_procedure_name,300);

Line 3897: hr_utility.trace(' =====================================================================');

3893: hr_utility.trace(' Employee new cont base Amount : '|| p_new_ee_cont_base_amount);
3894: hr_utility.trace(' Employer new cont base Amount : '|| p_new_er_cont_base_amount);
3895: hr_utility.trace(' Employee cont base Amount : '|| p_ee_cont_base_amount);
3896: hr_utility.trace(' Employer cont base Amount : '|| p_er_cont_base_amount);
3897: hr_utility.trace(' =====================================================================');
3898: END IF;
3899:
3900: hr_cn_api.set_location(g_debug,' Leaving ' || g_procedure_name,300);
3901: RETURN l_message;

Line 4015: hr_utility.trace('Invalid Contribution Base Setup');

4011: );
4012:
4013: IF NOT l_flag THEN
4014:
4015: hr_utility.trace('Invalid Contribution Base Setup');
4016:
4017: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'Switch Period Periodicity'
4018: ,p_dff => 'Org Developer DF'
4019: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'