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 1290: hr_utility.trace(' =======================================================');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1373: hr_utility.trace(l_message);

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

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

1422: END IF;
1423: END IF;
1424:
1425: IF g_debug THEN
1426: hr_utility.trace(' =======================================================');
1427: hr_utility.trace(' . EE Rate : '||p_ee_rate);
1428: hr_utility.trace(' . EE Rate Type : '||p_ee_rate_type);
1429: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);
1430: hr_utility.trace(' . ER Rate : '||p_er_rate);

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

1423: END IF;
1424:
1425: IF g_debug THEN
1426: hr_utility.trace(' =======================================================');
1427: hr_utility.trace(' . EE Rate : '||p_ee_rate);
1428: hr_utility.trace(' . EE Rate Type : '||p_ee_rate_type);
1429: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);
1430: hr_utility.trace(' . ER Rate : '||p_er_rate);
1431: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);

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

1424:
1425: IF g_debug THEN
1426: hr_utility.trace(' =======================================================');
1427: hr_utility.trace(' . EE Rate : '||p_ee_rate);
1428: hr_utility.trace(' . EE Rate Type : '||p_ee_rate_type);
1429: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);
1430: hr_utility.trace(' . ER Rate : '||p_er_rate);
1431: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);
1432: hr_utility.trace(' . ER Rounding Method : '||p_er_rounding_method);

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

1425: IF g_debug THEN
1426: hr_utility.trace(' =======================================================');
1427: hr_utility.trace(' . EE Rate : '||p_ee_rate);
1428: hr_utility.trace(' . EE Rate Type : '||p_ee_rate_type);
1429: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);
1430: hr_utility.trace(' . ER Rate : '||p_er_rate);
1431: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);
1432: hr_utility.trace(' . ER Rounding Method : '||p_er_rounding_method);
1433: hr_utility.trace(' . EE Tax Threshold Rate : '||p_ee_thrhld_rate);

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

1426: hr_utility.trace(' =======================================================');
1427: hr_utility.trace(' . EE Rate : '||p_ee_rate);
1428: hr_utility.trace(' . EE Rate Type : '||p_ee_rate_type);
1429: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);
1430: hr_utility.trace(' . ER Rate : '||p_er_rate);
1431: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);
1432: hr_utility.trace(' . ER Rounding Method : '||p_er_rounding_method);
1433: hr_utility.trace(' . EE Tax Threshold Rate : '||p_ee_thrhld_rate);
1434: hr_utility.trace(' . ER Tax Threshold Rate : '||p_er_thrhld_rate);

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

1427: hr_utility.trace(' . EE Rate : '||p_ee_rate);
1428: hr_utility.trace(' . EE Rate Type : '||p_ee_rate_type);
1429: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);
1430: hr_utility.trace(' . ER Rate : '||p_er_rate);
1431: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);
1432: hr_utility.trace(' . ER Rounding Method : '||p_er_rounding_method);
1433: hr_utility.trace(' . EE Tax Threshold Rate : '||p_ee_thrhld_rate);
1434: hr_utility.trace(' . ER Tax Threshold Rate : '||p_er_thrhld_rate);
1435: hr_utility.trace(' =======================================================');

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

1428: hr_utility.trace(' . EE Rate Type : '||p_ee_rate_type);
1429: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);
1430: hr_utility.trace(' . ER Rate : '||p_er_rate);
1431: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);
1432: hr_utility.trace(' . ER Rounding Method : '||p_er_rounding_method);
1433: hr_utility.trace(' . EE Tax Threshold Rate : '||p_ee_thrhld_rate);
1434: hr_utility.trace(' . ER Tax Threshold Rate : '||p_er_thrhld_rate);
1435: hr_utility.trace(' =======================================================');
1436: END IF;

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

1429: hr_utility.trace(' . EE Rounding Method : '||p_ee_rounding_method);
1430: hr_utility.trace(' . ER Rate : '||p_er_rate);
1431: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);
1432: hr_utility.trace(' . ER Rounding Method : '||p_er_rounding_method);
1433: hr_utility.trace(' . EE Tax Threshold Rate : '||p_ee_thrhld_rate);
1434: hr_utility.trace(' . ER Tax Threshold Rate : '||p_er_thrhld_rate);
1435: hr_utility.trace(' =======================================================');
1436: END IF;
1437:

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

1430: hr_utility.trace(' . ER Rate : '||p_er_rate);
1431: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);
1432: hr_utility.trace(' . ER Rounding Method : '||p_er_rounding_method);
1433: hr_utility.trace(' . EE Tax Threshold Rate : '||p_ee_thrhld_rate);
1434: hr_utility.trace(' . ER Tax Threshold Rate : '||p_er_thrhld_rate);
1435: hr_utility.trace(' =======================================================');
1436: END IF;
1437:
1438: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 70);

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

1431: hr_utility.trace(' . ER Rate Type : '||p_er_rate_type);
1432: hr_utility.trace(' . ER Rounding Method : '||p_er_rounding_method);
1433: hr_utility.trace(' . EE Tax Threshold Rate : '||p_ee_thrhld_rate);
1434: hr_utility.trace(' . ER Tax Threshold Rate : '||p_er_thrhld_rate);
1435: hr_utility.trace(' =======================================================');
1436: END IF;
1437:
1438: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 70);
1439: RETURN l_message;

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

1570:
1571: p_cont_base_amount := l_cont_base_amount;
1572:
1573: IF g_debug THEN
1574: hr_utility.trace(' ==============================================');
1575: hr_utility.trace(' . Cont Base Method : '||p_cont_base_method);
1576: hr_utility.trace(' . PHF_SI_EARNINGS (PTD) : '||p_phf_si_earnings_asg_ptd);
1577: hr_utility.trace(' . PHF_SI_EARNINGS (PMTH): '||p_phf_si_earnings_asg_pmth);
1578: hr_utility.trace(' . PHF_SI_EARNINGS (AVG) : '||p_phf_si_earnings_asg_avg);

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

1571: p_cont_base_amount := l_cont_base_amount;
1572:
1573: IF g_debug THEN
1574: hr_utility.trace(' ==============================================');
1575: hr_utility.trace(' . Cont Base Method : '||p_cont_base_method);
1576: hr_utility.trace(' . PHF_SI_EARNINGS (PTD) : '||p_phf_si_earnings_asg_ptd);
1577: hr_utility.trace(' . PHF_SI_EARNINGS (PMTH): '||p_phf_si_earnings_asg_pmth);
1578: hr_utility.trace(' . PHF_SI_EARNINGS (AVG) : '||p_phf_si_earnings_asg_avg);
1579: hr_utility.trace(' . Average Salary : '||p_average_salary);

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

1572:
1573: IF g_debug THEN
1574: hr_utility.trace(' ==============================================');
1575: hr_utility.trace(' . Cont Base Method : '||p_cont_base_method);
1576: hr_utility.trace(' . PHF_SI_EARNINGS (PTD) : '||p_phf_si_earnings_asg_ptd);
1577: hr_utility.trace(' . PHF_SI_EARNINGS (PMTH): '||p_phf_si_earnings_asg_pmth);
1578: hr_utility.trace(' . PHF_SI_EARNINGS (AVG) : '||p_phf_si_earnings_asg_avg);
1579: hr_utility.trace(' . Average Salary : '||p_average_salary);
1580: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_average_salary);

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

1573: IF g_debug THEN
1574: hr_utility.trace(' ==============================================');
1575: hr_utility.trace(' . Cont Base Method : '||p_cont_base_method);
1576: hr_utility.trace(' . PHF_SI_EARNINGS (PTD) : '||p_phf_si_earnings_asg_ptd);
1577: hr_utility.trace(' . PHF_SI_EARNINGS (PMTH): '||p_phf_si_earnings_asg_pmth);
1578: hr_utility.trace(' . PHF_SI_EARNINGS (AVG) : '||p_phf_si_earnings_asg_avg);
1579: hr_utility.trace(' . Average Salary : '||p_average_salary);
1580: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_average_salary);
1581: hr_utility.trace(' . Fixed Amount : '||p_fixed_amount);

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

1574: hr_utility.trace(' ==============================================');
1575: hr_utility.trace(' . Cont Base Method : '||p_cont_base_method);
1576: hr_utility.trace(' . PHF_SI_EARNINGS (PTD) : '||p_phf_si_earnings_asg_ptd);
1577: hr_utility.trace(' . PHF_SI_EARNINGS (PMTH): '||p_phf_si_earnings_asg_pmth);
1578: hr_utility.trace(' . PHF_SI_EARNINGS (AVG) : '||p_phf_si_earnings_asg_avg);
1579: hr_utility.trace(' . Average Salary : '||p_average_salary);
1580: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_average_salary);
1581: hr_utility.trace(' . Fixed Amount : '||p_fixed_amount);
1582: hr_utility.trace(' . Cont Base Amount : '||p_cont_base_amount);

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

1575: hr_utility.trace(' . Cont Base Method : '||p_cont_base_method);
1576: hr_utility.trace(' . PHF_SI_EARNINGS (PTD) : '||p_phf_si_earnings_asg_ptd);
1577: hr_utility.trace(' . PHF_SI_EARNINGS (PMTH): '||p_phf_si_earnings_asg_pmth);
1578: hr_utility.trace(' . PHF_SI_EARNINGS (AVG) : '||p_phf_si_earnings_asg_avg);
1579: hr_utility.trace(' . Average Salary : '||p_average_salary);
1580: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_average_salary);
1581: hr_utility.trace(' . Fixed Amount : '||p_fixed_amount);
1582: hr_utility.trace(' . Cont Base Amount : '||p_cont_base_amount);
1583: hr_utility.trace(' ==============================================');

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

1576: hr_utility.trace(' . PHF_SI_EARNINGS (PTD) : '||p_phf_si_earnings_asg_ptd);
1577: hr_utility.trace(' . PHF_SI_EARNINGS (PMTH): '||p_phf_si_earnings_asg_pmth);
1578: hr_utility.trace(' . PHF_SI_EARNINGS (AVG) : '||p_phf_si_earnings_asg_avg);
1579: hr_utility.trace(' . Average Salary : '||p_average_salary);
1580: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_average_salary);
1581: hr_utility.trace(' . Fixed Amount : '||p_fixed_amount);
1582: hr_utility.trace(' . Cont Base Amount : '||p_cont_base_amount);
1583: hr_utility.trace(' ==============================================');
1584: END IF;

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

1577: hr_utility.trace(' . PHF_SI_EARNINGS (PMTH): '||p_phf_si_earnings_asg_pmth);
1578: hr_utility.trace(' . PHF_SI_EARNINGS (AVG) : '||p_phf_si_earnings_asg_avg);
1579: hr_utility.trace(' . Average Salary : '||p_average_salary);
1580: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_average_salary);
1581: hr_utility.trace(' . Fixed Amount : '||p_fixed_amount);
1582: hr_utility.trace(' . Cont Base Amount : '||p_cont_base_amount);
1583: hr_utility.trace(' ==============================================');
1584: END IF;
1585:

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

1578: hr_utility.trace(' . PHF_SI_EARNINGS (AVG) : '||p_phf_si_earnings_asg_avg);
1579: hr_utility.trace(' . Average Salary : '||p_average_salary);
1580: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_average_salary);
1581: hr_utility.trace(' . Fixed Amount : '||p_fixed_amount);
1582: hr_utility.trace(' . Cont Base Amount : '||p_cont_base_amount);
1583: hr_utility.trace(' ==============================================');
1584: END IF;
1585:
1586: l_message:='SUCCESS';

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

1579: hr_utility.trace(' . Average Salary : '||p_average_salary);
1580: hr_utility.trace(' . Lowest Avg Salary : '||p_lowest_average_salary);
1581: hr_utility.trace(' . Fixed Amount : '||p_fixed_amount);
1582: hr_utility.trace(' . Cont Base Amount : '||p_cont_base_amount);
1583: hr_utility.trace(' ==============================================');
1584: END IF;
1585:
1586: l_message:='SUCCESS';
1587: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 130);

Line 1594: hr_utility.trace(l_message);

1590: EXCEPTION
1591: WHEN OTHERS THEN
1592: p_cont_base_amount := hr_api.g_number;
1593: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
1594: hr_utility.trace(l_message);
1595: RETURN l_message;
1596: END get_cont_base_amount;
1597:
1598: --------------------------------------------------------------------------

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

1672: l_return_value := 'Y';
1673: END IF;
1674:
1675: IF g_debug THEN
1676: hr_utility.trace(' ==============================================');
1677: hr_utility.trace(' . Switch Periodicity : '||p_switch_periodicity);
1678: hr_utility.trace(' . Switch Month : '||p_switch_month);
1679: hr_utility.trace(' . Calculation Date : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
1680: hr_utility.trace(' . Process Date : '||TO_CHAR(p_process_date, 'DD-MM-YYYY'));

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

1673: END IF;
1674:
1675: IF g_debug THEN
1676: hr_utility.trace(' ==============================================');
1677: hr_utility.trace(' . Switch Periodicity : '||p_switch_periodicity);
1678: hr_utility.trace(' . Switch Month : '||p_switch_month);
1679: hr_utility.trace(' . Calculation Date : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
1680: hr_utility.trace(' . Process Date : '||TO_CHAR(p_process_date, 'DD-MM-YYYY'));
1681: hr_utility.trace(' . Temporary Date : '||TO_CHAR(l_temp_date,'DD-MM-YYYY'));

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

1674:
1675: IF g_debug THEN
1676: hr_utility.trace(' ==============================================');
1677: hr_utility.trace(' . Switch Periodicity : '||p_switch_periodicity);
1678: hr_utility.trace(' . Switch Month : '||p_switch_month);
1679: hr_utility.trace(' . Calculation Date : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
1680: hr_utility.trace(' . Process Date : '||TO_CHAR(p_process_date, 'DD-MM-YYYY'));
1681: hr_utility.trace(' . Temporary Date : '||TO_CHAR(l_temp_date,'DD-MM-YYYY'));
1682: hr_utility.trace(' . Recalculate Flag : '||l_return_value);

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

1675: IF g_debug THEN
1676: hr_utility.trace(' ==============================================');
1677: hr_utility.trace(' . Switch Periodicity : '||p_switch_periodicity);
1678: hr_utility.trace(' . Switch Month : '||p_switch_month);
1679: hr_utility.trace(' . Calculation Date : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
1680: hr_utility.trace(' . Process Date : '||TO_CHAR(p_process_date, 'DD-MM-YYYY'));
1681: hr_utility.trace(' . Temporary Date : '||TO_CHAR(l_temp_date,'DD-MM-YYYY'));
1682: hr_utility.trace(' . Recalculate Flag : '||l_return_value);
1683: hr_utility.trace(' ==============================================');

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

1676: hr_utility.trace(' ==============================================');
1677: hr_utility.trace(' . Switch Periodicity : '||p_switch_periodicity);
1678: hr_utility.trace(' . Switch Month : '||p_switch_month);
1679: hr_utility.trace(' . Calculation Date : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
1680: hr_utility.trace(' . Process Date : '||TO_CHAR(p_process_date, 'DD-MM-YYYY'));
1681: hr_utility.trace(' . Temporary Date : '||TO_CHAR(l_temp_date,'DD-MM-YYYY'));
1682: hr_utility.trace(' . Recalculate Flag : '||l_return_value);
1683: hr_utility.trace(' ==============================================');
1684: END IF;

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

1677: hr_utility.trace(' . Switch Periodicity : '||p_switch_periodicity);
1678: hr_utility.trace(' . Switch Month : '||p_switch_month);
1679: hr_utility.trace(' . Calculation Date : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
1680: hr_utility.trace(' . Process Date : '||TO_CHAR(p_process_date, 'DD-MM-YYYY'));
1681: hr_utility.trace(' . Temporary Date : '||TO_CHAR(l_temp_date,'DD-MM-YYYY'));
1682: hr_utility.trace(' . Recalculate Flag : '||l_return_value);
1683: hr_utility.trace(' ==============================================');
1684: END IF;
1685: --

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

1678: hr_utility.trace(' . Switch Month : '||p_switch_month);
1679: hr_utility.trace(' . Calculation Date : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
1680: hr_utility.trace(' . Process Date : '||TO_CHAR(p_process_date, 'DD-MM-YYYY'));
1681: hr_utility.trace(' . Temporary Date : '||TO_CHAR(l_temp_date,'DD-MM-YYYY'));
1682: hr_utility.trace(' . Recalculate Flag : '||l_return_value);
1683: hr_utility.trace(' ==============================================');
1684: END IF;
1685: --
1686: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 50);

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

1679: hr_utility.trace(' . Calculation Date : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
1680: hr_utility.trace(' . Process Date : '||TO_CHAR(p_process_date, 'DD-MM-YYYY'));
1681: hr_utility.trace(' . Temporary Date : '||TO_CHAR(l_temp_date,'DD-MM-YYYY'));
1682: hr_utility.trace(' . Recalculate Flag : '||l_return_value);
1683: hr_utility.trace(' ==============================================');
1684: END IF;
1685: --
1686: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 50);
1687: RETURN l_return_value;

Line 1692: hr_utility.trace (l_message);

1688: --
1689: EXCEPTION
1690: WHEN OTHERS THEN
1691: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
1692: hr_utility.trace (l_message);
1693: RETURN 'E';
1694: END get_recalculate_flag;
1695:
1696:

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

1821:
1822: p_amount := get_rounded_value(l_amount,p_rounding_method);
1823:
1824: IF g_debug THEN
1825: hr_utility.trace(' ==============================================');
1826: hr_utility.trace(' . Low Limit Method : '||p_low_limit_method);
1827: hr_utility.trace(' . Low Limit Amount : '||l_low_limit_amount);
1828: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);
1829: hr_utility.trace(' . High Limit Amount : '||l_high_limit_amount);

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

1822: p_amount := get_rounded_value(l_amount,p_rounding_method);
1823:
1824: IF g_debug THEN
1825: hr_utility.trace(' ==============================================');
1826: hr_utility.trace(' . Low Limit Method : '||p_low_limit_method);
1827: hr_utility.trace(' . Low Limit Amount : '||l_low_limit_amount);
1828: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);
1829: hr_utility.trace(' . High Limit Amount : '||l_high_limit_amount);
1830: hr_utility.trace(' . Amount In Limit is : '||l_amount);

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

1823:
1824: IF g_debug THEN
1825: hr_utility.trace(' ==============================================');
1826: hr_utility.trace(' . Low Limit Method : '||p_low_limit_method);
1827: hr_utility.trace(' . Low Limit Amount : '||l_low_limit_amount);
1828: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);
1829: hr_utility.trace(' . High Limit Amount : '||l_high_limit_amount);
1830: hr_utility.trace(' . Amount In Limit is : '||l_amount);
1831: hr_utility.trace(' . Rounding Method : '||p_rounding_method);

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

1824: IF g_debug THEN
1825: hr_utility.trace(' ==============================================');
1826: hr_utility.trace(' . Low Limit Method : '||p_low_limit_method);
1827: hr_utility.trace(' . Low Limit Amount : '||l_low_limit_amount);
1828: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);
1829: hr_utility.trace(' . High Limit Amount : '||l_high_limit_amount);
1830: hr_utility.trace(' . Amount In Limit is : '||l_amount);
1831: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
1832: hr_utility.trace(' . Rounded Amount : '||p_amount);

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

1825: hr_utility.trace(' ==============================================');
1826: hr_utility.trace(' . Low Limit Method : '||p_low_limit_method);
1827: hr_utility.trace(' . Low Limit Amount : '||l_low_limit_amount);
1828: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);
1829: hr_utility.trace(' . High Limit Amount : '||l_high_limit_amount);
1830: hr_utility.trace(' . Amount In Limit is : '||l_amount);
1831: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
1832: hr_utility.trace(' . Rounded Amount : '||p_amount);
1833: hr_utility.trace(' ==============================================');

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

1826: hr_utility.trace(' . Low Limit Method : '||p_low_limit_method);
1827: hr_utility.trace(' . Low Limit Amount : '||l_low_limit_amount);
1828: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);
1829: hr_utility.trace(' . High Limit Amount : '||l_high_limit_amount);
1830: hr_utility.trace(' . Amount In Limit is : '||l_amount);
1831: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
1832: hr_utility.trace(' . Rounded Amount : '||p_amount);
1833: hr_utility.trace(' ==============================================');
1834: END IF;

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

1827: hr_utility.trace(' . Low Limit Amount : '||l_low_limit_amount);
1828: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);
1829: hr_utility.trace(' . High Limit Amount : '||l_high_limit_amount);
1830: hr_utility.trace(' . Amount In Limit is : '||l_amount);
1831: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
1832: hr_utility.trace(' . Rounded Amount : '||p_amount);
1833: hr_utility.trace(' ==============================================');
1834: END IF;
1835: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 20);

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

1828: hr_utility.trace(' . High Limit Method : '||p_high_limit_method);
1829: hr_utility.trace(' . High Limit Amount : '||l_high_limit_amount);
1830: hr_utility.trace(' . Amount In Limit is : '||l_amount);
1831: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
1832: hr_utility.trace(' . Rounded Amount : '||p_amount);
1833: hr_utility.trace(' ==============================================');
1834: END IF;
1835: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 20);
1836:

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

1829: hr_utility.trace(' . High Limit Amount : '||l_high_limit_amount);
1830: hr_utility.trace(' . Amount In Limit is : '||l_amount);
1831: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
1832: hr_utility.trace(' . Rounded Amount : '||p_amount);
1833: hr_utility.trace(' ==============================================');
1834: END IF;
1835: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 20);
1836:
1837: EXCEPTION

Line 1840: hr_utility.trace (p_message);

1836:
1837: EXCEPTION
1838: WHEN OTHERS THEN
1839: p_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
1840: hr_utility.trace (p_message);
1841:
1842: END get_in_limit;
1843:
1844: --------------------------------------------------------------------------

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

2090: CLOSE c_exists;
2091: --
2092: hr_cn_api.set_location(g_debug,' ' || g_procedure_name,40);
2093: IF g_debug THEN
2094: hr_utility.trace(' ==============================================');
2095: hr_utility.trace ('. Calling pay_element_entry_api.');
2096: hr_utility.trace ('. Element Entry : '||TO_CHAR(p_element_entry_id));
2097: hr_utility.trace ('. Effective Date : '||TO_CHAR(p_calculation_date+1,'DD-MM-YYYY'));
2098: hr_utility.trace ('. Input Value Id : '||TO_CHAR(l_iv_id));

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

2091: --
2092: hr_cn_api.set_location(g_debug,' ' || g_procedure_name,40);
2093: IF g_debug THEN
2094: hr_utility.trace(' ==============================================');
2095: hr_utility.trace ('. Calling pay_element_entry_api.');
2096: hr_utility.trace ('. Element Entry : '||TO_CHAR(p_element_entry_id));
2097: hr_utility.trace ('. Effective Date : '||TO_CHAR(p_calculation_date+1,'DD-MM-YYYY'));
2098: hr_utility.trace ('. Input Value Id : '||TO_CHAR(l_iv_id));
2099: hr_utility.trace ('. Entry Value : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));

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

2092: hr_cn_api.set_location(g_debug,' ' || g_procedure_name,40);
2093: IF g_debug THEN
2094: hr_utility.trace(' ==============================================');
2095: hr_utility.trace ('. Calling pay_element_entry_api.');
2096: hr_utility.trace ('. Element Entry : '||TO_CHAR(p_element_entry_id));
2097: hr_utility.trace ('. Effective Date : '||TO_CHAR(p_calculation_date+1,'DD-MM-YYYY'));
2098: hr_utility.trace ('. Input Value Id : '||TO_CHAR(l_iv_id));
2099: hr_utility.trace ('. Entry Value : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
2100: hr_utility.trace ('. OVN : '||to_char(l_ovn));

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

2093: IF g_debug THEN
2094: hr_utility.trace(' ==============================================');
2095: hr_utility.trace ('. Calling pay_element_entry_api.');
2096: hr_utility.trace ('. Element Entry : '||TO_CHAR(p_element_entry_id));
2097: hr_utility.trace ('. Effective Date : '||TO_CHAR(p_calculation_date+1,'DD-MM-YYYY'));
2098: hr_utility.trace ('. Input Value Id : '||TO_CHAR(l_iv_id));
2099: hr_utility.trace ('. Entry Value : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
2100: hr_utility.trace ('. OVN : '||to_char(l_ovn));
2101: hr_utility.trace ('. Date-track Mode : '||l_upd_mode);

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

2094: hr_utility.trace(' ==============================================');
2095: hr_utility.trace ('. Calling pay_element_entry_api.');
2096: hr_utility.trace ('. Element Entry : '||TO_CHAR(p_element_entry_id));
2097: hr_utility.trace ('. Effective Date : '||TO_CHAR(p_calculation_date+1,'DD-MM-YYYY'));
2098: hr_utility.trace ('. Input Value Id : '||TO_CHAR(l_iv_id));
2099: hr_utility.trace ('. Entry Value : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
2100: hr_utility.trace ('. OVN : '||to_char(l_ovn));
2101: hr_utility.trace ('. Date-track Mode : '||l_upd_mode);
2102: hr_utility.trace(' ==============================================');

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

2095: hr_utility.trace ('. Calling pay_element_entry_api.');
2096: hr_utility.trace ('. Element Entry : '||TO_CHAR(p_element_entry_id));
2097: hr_utility.trace ('. Effective Date : '||TO_CHAR(p_calculation_date+1,'DD-MM-YYYY'));
2098: hr_utility.trace ('. Input Value Id : '||TO_CHAR(l_iv_id));
2099: hr_utility.trace ('. Entry Value : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
2100: hr_utility.trace ('. OVN : '||to_char(l_ovn));
2101: hr_utility.trace ('. Date-track Mode : '||l_upd_mode);
2102: hr_utility.trace(' ==============================================');
2103: END IF;

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

2096: hr_utility.trace ('. Element Entry : '||TO_CHAR(p_element_entry_id));
2097: hr_utility.trace ('. Effective Date : '||TO_CHAR(p_calculation_date+1,'DD-MM-YYYY'));
2098: hr_utility.trace ('. Input Value Id : '||TO_CHAR(l_iv_id));
2099: hr_utility.trace ('. Entry Value : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
2100: hr_utility.trace ('. OVN : '||to_char(l_ovn));
2101: hr_utility.trace ('. Date-track Mode : '||l_upd_mode);
2102: hr_utility.trace(' ==============================================');
2103: END IF;
2104:

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

2097: hr_utility.trace ('. Effective Date : '||TO_CHAR(p_calculation_date+1,'DD-MM-YYYY'));
2098: hr_utility.trace ('. Input Value Id : '||TO_CHAR(l_iv_id));
2099: hr_utility.trace ('. Entry Value : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
2100: hr_utility.trace ('. OVN : '||to_char(l_ovn));
2101: hr_utility.trace ('. Date-track Mode : '||l_upd_mode);
2102: hr_utility.trace(' ==============================================');
2103: END IF;
2104:
2105: BEGIN

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

2098: hr_utility.trace ('. Input Value Id : '||TO_CHAR(l_iv_id));
2099: hr_utility.trace ('. Entry Value : '||TO_CHAR(p_calculation_date,'DD-MM-YYYY'));
2100: hr_utility.trace ('. OVN : '||to_char(l_ovn));
2101: hr_utility.trace ('. Date-track Mode : '||l_upd_mode);
2102: hr_utility.trace(' ==============================================');
2103: END IF;
2104:
2105: BEGIN
2106: pay_element_entry_api.update_element_entry

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

2175: hr_cn_api.set_location(g_debug,' Entering : '||g_procedure_name, 10);
2176:
2177: p_message := 'SUCCESS';
2178: IF g_debug THEN
2179: hr_utility.trace(' ==============================================');
2180: hr_utility.trace(' . Rate Type : '||p_rate_type);
2181: hr_utility.trace(' . Rate : '||p_rate_amount);
2182: hr_utility.trace(' . Contribution Base : '||p_cont_base);
2183: END IF;

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

2176:
2177: p_message := 'SUCCESS';
2178: IF g_debug THEN
2179: hr_utility.trace(' ==============================================');
2180: hr_utility.trace(' . Rate Type : '||p_rate_type);
2181: hr_utility.trace(' . Rate : '||p_rate_amount);
2182: hr_utility.trace(' . Contribution Base : '||p_cont_base);
2183: END IF;
2184: IF p_rate_type = 'FIXED' THEN

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

2177: p_message := 'SUCCESS';
2178: IF g_debug THEN
2179: hr_utility.trace(' ==============================================');
2180: hr_utility.trace(' . Rate Type : '||p_rate_type);
2181: hr_utility.trace(' . Rate : '||p_rate_amount);
2182: hr_utility.trace(' . Contribution Base : '||p_cont_base);
2183: END IF;
2184: IF p_rate_type = 'FIXED' THEN
2185: l_amount := p_rate_amount;

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

2178: IF g_debug THEN
2179: hr_utility.trace(' ==============================================');
2180: hr_utility.trace(' . Rate Type : '||p_rate_type);
2181: hr_utility.trace(' . Rate : '||p_rate_amount);
2182: hr_utility.trace(' . Contribution Base : '||p_cont_base);
2183: END IF;
2184: IF p_rate_type = 'FIXED' THEN
2185: l_amount := p_rate_amount;
2186:

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

2189:
2190: END IF;
2191:
2192: IF g_debug THEN
2193: hr_utility.trace(' . Contribution Amount : '||l_amount);
2194: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
2195: END IF;
2196:
2197: l_amount := get_rounded_value(l_amount, p_rounding_method);

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

2190: END IF;
2191:
2192: IF g_debug THEN
2193: hr_utility.trace(' . Contribution Amount : '||l_amount);
2194: hr_utility.trace(' . Rounding Method : '||p_rounding_method);
2195: END IF;
2196:
2197: l_amount := get_rounded_value(l_amount, p_rounding_method);
2198:

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

2196:
2197: l_amount := get_rounded_value(l_amount, p_rounding_method);
2198:
2199: IF g_debug THEN
2200: hr_utility.trace(' . Rounded Amount : '||l_amount);
2201: hr_utility.trace(' ==============================================');
2202: END IF;
2203:
2204: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 40);

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

2197: l_amount := get_rounded_value(l_amount, p_rounding_method);
2198:
2199: IF g_debug THEN
2200: hr_utility.trace(' . Rounded Amount : '||l_amount);
2201: hr_utility.trace(' ==============================================');
2202: END IF;
2203:
2204: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 40);
2205: RETURN l_amount;

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

2271: l_message := 'SUCCESS';
2272: l_default_date := TO_DATE ('01-01-0001','DD-MM-YYYY');
2273:
2274: IF g_debug THEN
2275: hr_utility.trace ('==============================================');
2276: hr_utility.trace (' Actual Probn End Date : '||p_actual_probation_end_date);
2277: hr_utility.trace (' Cont. Probn End Date : '||p_const_probation_end_date);
2278: hr_utility.trace (' Defer Deductions : '||p_defer_deductions);
2279: hr_utility.trace (' Deduct in Probation Expiry : '||p_deduct_in_probation_expiry);

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

2272: l_default_date := TO_DATE ('01-01-0001','DD-MM-YYYY');
2273:
2274: IF g_debug THEN
2275: hr_utility.trace ('==============================================');
2276: hr_utility.trace (' Actual Probn End Date : '||p_actual_probation_end_date);
2277: hr_utility.trace (' Cont. Probn End Date : '||p_const_probation_end_date);
2278: hr_utility.trace (' Defer Deductions : '||p_defer_deductions);
2279: hr_utility.trace (' Deduct in Probation Expiry : '||p_deduct_in_probation_expiry);
2280: hr_utility.trace (' Taxable Earnings : '||p_taxable_earnings_asg_er_ptd);

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

2273:
2274: IF g_debug THEN
2275: hr_utility.trace ('==============================================');
2276: hr_utility.trace (' Actual Probn End Date : '||p_actual_probation_end_date);
2277: hr_utility.trace (' Cont. Probn End Date : '||p_const_probation_end_date);
2278: hr_utility.trace (' Defer Deductions : '||p_defer_deductions);
2279: hr_utility.trace (' Deduct in Probation Expiry : '||p_deduct_in_probation_expiry);
2280: hr_utility.trace (' Taxable Earnings : '||p_taxable_earnings_asg_er_ptd);
2281:

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

2274: IF g_debug THEN
2275: hr_utility.trace ('==============================================');
2276: hr_utility.trace (' Actual Probn End Date : '||p_actual_probation_end_date);
2277: hr_utility.trace (' Cont. Probn End Date : '||p_const_probation_end_date);
2278: hr_utility.trace (' Defer Deductions : '||p_defer_deductions);
2279: hr_utility.trace (' Deduct in Probation Expiry : '||p_deduct_in_probation_expiry);
2280: hr_utility.trace (' Taxable Earnings : '||p_taxable_earnings_asg_er_ptd);
2281:
2282: hr_utility.trace (' Old EE PHF/SI amount : '||p_ee_phf_si_amount);

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

2275: hr_utility.trace ('==============================================');
2276: hr_utility.trace (' Actual Probn End Date : '||p_actual_probation_end_date);
2277: hr_utility.trace (' Cont. Probn End Date : '||p_const_probation_end_date);
2278: hr_utility.trace (' Defer Deductions : '||p_defer_deductions);
2279: hr_utility.trace (' Deduct in Probation Expiry : '||p_deduct_in_probation_expiry);
2280: hr_utility.trace (' Taxable Earnings : '||p_taxable_earnings_asg_er_ptd);
2281:
2282: hr_utility.trace (' Old EE PHF/SI amount : '||p_ee_phf_si_amount);
2283: hr_utility.trace (' Old ER PHF/SI amount : '||p_er_phf_si_amount);

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

2276: hr_utility.trace (' Actual Probn End Date : '||p_actual_probation_end_date);
2277: hr_utility.trace (' Cont. Probn End Date : '||p_const_probation_end_date);
2278: hr_utility.trace (' Defer Deductions : '||p_defer_deductions);
2279: hr_utility.trace (' Deduct in Probation Expiry : '||p_deduct_in_probation_expiry);
2280: hr_utility.trace (' Taxable Earnings : '||p_taxable_earnings_asg_er_ptd);
2281:
2282: hr_utility.trace (' Old EE PHF/SI amount : '||p_ee_phf_si_amount);
2283: hr_utility.trace (' Old ER PHF/SI amount : '||p_er_phf_si_amount);
2284: hr_utility.trace (' Old Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);

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

2278: hr_utility.trace (' Defer Deductions : '||p_defer_deductions);
2279: hr_utility.trace (' Deduct in Probation Expiry : '||p_deduct_in_probation_expiry);
2280: hr_utility.trace (' Taxable Earnings : '||p_taxable_earnings_asg_er_ptd);
2281:
2282: hr_utility.trace (' Old EE PHF/SI amount : '||p_ee_phf_si_amount);
2283: hr_utility.trace (' Old ER PHF/SI amount : '||p_er_phf_si_amount);
2284: hr_utility.trace (' Old Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);
2285: hr_utility.trace (' Old Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);
2286: hr_utility.trace (' p_pay_proc_period_end_date : '||TO_CHAR(p_pay_proc_period_end_date,'DD-MM-YYYY'));

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

2279: hr_utility.trace (' Deduct in Probation Expiry : '||p_deduct_in_probation_expiry);
2280: hr_utility.trace (' Taxable Earnings : '||p_taxable_earnings_asg_er_ptd);
2281:
2282: hr_utility.trace (' Old EE PHF/SI amount : '||p_ee_phf_si_amount);
2283: hr_utility.trace (' Old ER PHF/SI amount : '||p_er_phf_si_amount);
2284: hr_utility.trace (' Old Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);
2285: hr_utility.trace (' Old Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);
2286: hr_utility.trace (' p_pay_proc_period_end_date : '||TO_CHAR(p_pay_proc_period_end_date,'DD-MM-YYYY'));
2287: hr_utility.trace ('==============================================');

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

2280: hr_utility.trace (' Taxable Earnings : '||p_taxable_earnings_asg_er_ptd);
2281:
2282: hr_utility.trace (' Old EE PHF/SI amount : '||p_ee_phf_si_amount);
2283: hr_utility.trace (' Old ER PHF/SI amount : '||p_er_phf_si_amount);
2284: hr_utility.trace (' Old Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);
2285: hr_utility.trace (' Old Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);
2286: hr_utility.trace (' p_pay_proc_period_end_date : '||TO_CHAR(p_pay_proc_period_end_date,'DD-MM-YYYY'));
2287: hr_utility.trace ('==============================================');
2288: END IF;

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

2281:
2282: hr_utility.trace (' Old EE PHF/SI amount : '||p_ee_phf_si_amount);
2283: hr_utility.trace (' Old ER PHF/SI amount : '||p_er_phf_si_amount);
2284: hr_utility.trace (' Old Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);
2285: hr_utility.trace (' Old Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);
2286: hr_utility.trace (' p_pay_proc_period_end_date : '||TO_CHAR(p_pay_proc_period_end_date,'DD-MM-YYYY'));
2287: hr_utility.trace ('==============================================');
2288: END IF;
2289:

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

2282: hr_utility.trace (' Old EE PHF/SI amount : '||p_ee_phf_si_amount);
2283: hr_utility.trace (' Old ER PHF/SI amount : '||p_er_phf_si_amount);
2284: hr_utility.trace (' Old Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);
2285: hr_utility.trace (' Old Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);
2286: hr_utility.trace (' p_pay_proc_period_end_date : '||TO_CHAR(p_pay_proc_period_end_date,'DD-MM-YYYY'));
2287: hr_utility.trace ('==============================================');
2288: END IF;
2289:
2290:

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

2283: hr_utility.trace (' Old ER PHF/SI amount : '||p_er_phf_si_amount);
2284: hr_utility.trace (' Old Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);
2285: hr_utility.trace (' Old Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);
2286: hr_utility.trace (' p_pay_proc_period_end_date : '||TO_CHAR(p_pay_proc_period_end_date,'DD-MM-YYYY'));
2287: hr_utility.trace ('==============================================');
2288: END IF;
2289:
2290:
2291: --3042788 Code is modified to consider the defaulting of Actual,Const Probation end dates

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

2347:
2348: END IF;
2349:
2350: IF g_debug THEN
2351: hr_utility.trace(' ==============================================');
2352: hr_utility.trace(' New EE PHF/SI amount : '||p_ee_phf_si_amount);
2353: hr_utility.trace(' New ER PHF/SI amount : '||p_er_phf_si_amount);
2354: hr_utility.trace(' New Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);
2355: hr_utility.trace(' New Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);

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

2348: END IF;
2349:
2350: IF g_debug THEN
2351: hr_utility.trace(' ==============================================');
2352: hr_utility.trace(' New EE PHF/SI amount : '||p_ee_phf_si_amount);
2353: hr_utility.trace(' New ER PHF/SI amount : '||p_er_phf_si_amount);
2354: hr_utility.trace(' New Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);
2355: hr_utility.trace(' New Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);
2356: hr_utility.trace(' ==============================================');

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

2349:
2350: IF g_debug THEN
2351: hr_utility.trace(' ==============================================');
2352: hr_utility.trace(' New EE PHF/SI amount : '||p_ee_phf_si_amount);
2353: hr_utility.trace(' New ER PHF/SI amount : '||p_er_phf_si_amount);
2354: hr_utility.trace(' New Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);
2355: hr_utility.trace(' New Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);
2356: hr_utility.trace(' ==============================================');
2357: END IF;

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

2350: IF g_debug THEN
2351: hr_utility.trace(' ==============================================');
2352: hr_utility.trace(' New EE PHF/SI amount : '||p_ee_phf_si_amount);
2353: hr_utility.trace(' New ER PHF/SI amount : '||p_er_phf_si_amount);
2354: hr_utility.trace(' New Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);
2355: hr_utility.trace(' New Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);
2356: hr_utility.trace(' ==============================================');
2357: END IF;
2358:

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

2351: hr_utility.trace(' ==============================================');
2352: hr_utility.trace(' New EE PHF/SI amount : '||p_ee_phf_si_amount);
2353: hr_utility.trace(' New ER PHF/SI amount : '||p_er_phf_si_amount);
2354: hr_utility.trace(' New Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);
2355: hr_utility.trace(' New Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);
2356: hr_utility.trace(' ==============================================');
2357: END IF;
2358:
2359: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 60);

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

2352: hr_utility.trace(' New EE PHF/SI amount : '||p_ee_phf_si_amount);
2353: hr_utility.trace(' New ER PHF/SI amount : '||p_er_phf_si_amount);
2354: hr_utility.trace(' New Undeducted EE PHF LTD : '||p_undeducted_ee_phf_ltd);
2355: hr_utility.trace(' New Undeducted ER PHF LTD : '||p_undeducted_er_phf_ltd);
2356: hr_utility.trace(' ==============================================');
2357: END IF;
2358:
2359: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 60);
2360: RETURN l_message;

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

2418: END IF;
2419: CLOSE csr_def_bal_id;
2420:
2421: IF g_debug THEN
2422: hr_utility.trace ('. '||RPAD(TRIM(p_balance_name||p_dimension_name),35,' ')||' : '||l_def_bal_id);
2423: END IF;
2424:
2425: RETURN l_def_bal_id;
2426:

Line 2430: hr_utility.trace(l_message);

2426:
2427: EXCEPTION
2428: WHEN OTHERS THEN
2429: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
2430: hr_utility.trace(l_message);
2431:
2432: END get_def_bal_id ;
2433:
2434: ----------------------------------------------------------------------------

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

2502: FETCH c_element_name INTO l_element_name,l_insurance_type;
2503: CLOSE c_element_name;
2504:
2505: IF g_debug THEN
2506: hr_utility.trace ('===================== Defined Balances =========================');
2507: END IF;
2508:
2509: p_balance_value_tab(1).defined_balance_id := get_def_bal_id('PHF SI Earnings','_ASG_PTD');
2510: p_balance_value_tab(2).defined_balance_id := get_def_bal_id('PHF SI Earnings','_ASG_PYEAR');

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

2520: p_balance_value_tab(11).defined_balance_id := get_def_bal_id('Undeducted EE '||l_element_name,'_ASG_ER_PTD');
2521: p_balance_value_tab(12).defined_balance_id := get_def_bal_id('Undeducted ER '||l_element_name,'_ASG_ER_PTD');
2522:
2523: IF g_debug THEN
2524: hr_utility.trace ('===================== Defined Balances =========================');
2525: END IF;
2526:
2527: IF g_debug THEN
2528: hr_utility.trace ('===================== Balance Values =========================');

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

2524: hr_utility.trace ('===================== Defined Balances =========================');
2525: END IF;
2526:
2527: IF g_debug THEN
2528: hr_utility.trace ('===================== Balance Values =========================');
2529: END IF;
2530:
2531: FOR cnt in p_balance_value_tab.first .. p_balance_value_tab.last
2532: LOOP

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

2542: ,p_date_earned => NULL
2543: ,p_get_rr_route => NULL
2544: ,p_get_rb_route => 'TRUE');
2545:
2546: hr_utility.trace ('. Defined balance ID '||p_balance_value_tab(cnt).defined_balance_id||' has balance value '||p_balance_value_tab(cnt).balance_value);
2547: END LOOP;
2548:
2549: IF g_debug THEN
2550: hr_utility.trace ('===================== Balance Values =========================');

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

2546: hr_utility.trace ('. Defined balance ID '||p_balance_value_tab(cnt).defined_balance_id||' has balance value '||p_balance_value_tab(cnt).balance_value);
2547: END LOOP;
2548:
2549: IF g_debug THEN
2550: hr_utility.trace ('===================== Balance Values =========================');
2551: END IF;
2552:
2553: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 20);
2554:

Line 2558: hr_utility.trace(l_message);

2554:
2555: EXCEPTION
2556: WHEN OTHERS THEN
2557: l_message := hr_cn_api.get_pay_message('HR_374610_ORACLE_GENERIC_ERROR', 'FUNCTION:'||g_procedure_name, 'SQLERRMC:'||sqlerrm);
2558: hr_utility.trace(l_message);
2559:
2560: END get_phf_si_balances;
2561:
2562:

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

2712: hr_cn_api.set_location(g_debug,' Entering PHF and SI Enhancements started from 1-Jan-2006 : ', 230);
2713:
2714:
2715: IF g_debug THEN
2716: hr_utility.trace(' =======================================================');
2717: hr_utility.trace('p_phf_si_type '||p_phf_si_type);
2718: hr_utility.trace('p_ee_rate '|| p_ee_rate);
2719: hr_utility.trace('p_er_rate '|| p_er_rate);
2720: hr_utility.trace('p_ee_rate_type '|| p_ee_rate_type);

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

2713:
2714:
2715: IF g_debug THEN
2716: hr_utility.trace(' =======================================================');
2717: hr_utility.trace('p_phf_si_type '||p_phf_si_type);
2718: hr_utility.trace('p_ee_rate '|| p_ee_rate);
2719: hr_utility.trace('p_er_rate '|| p_er_rate);
2720: hr_utility.trace('p_ee_rate_type '|| p_ee_rate_type);
2721: hr_utility.trace('p_er_rate_type '|| p_er_rate_type);

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

2714:
2715: IF g_debug THEN
2716: hr_utility.trace(' =======================================================');
2717: hr_utility.trace('p_phf_si_type '||p_phf_si_type);
2718: hr_utility.trace('p_ee_rate '|| p_ee_rate);
2719: hr_utility.trace('p_er_rate '|| p_er_rate);
2720: hr_utility.trace('p_ee_rate_type '|| p_ee_rate_type);
2721: hr_utility.trace('p_er_rate_type '|| p_er_rate_type);
2722: hr_utility.trace('p_ee_cont_base_method '|| p_ee_cont_base_method);

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

2715: IF g_debug THEN
2716: hr_utility.trace(' =======================================================');
2717: hr_utility.trace('p_phf_si_type '||p_phf_si_type);
2718: hr_utility.trace('p_ee_rate '|| p_ee_rate);
2719: hr_utility.trace('p_er_rate '|| p_er_rate);
2720: hr_utility.trace('p_ee_rate_type '|| p_ee_rate_type);
2721: hr_utility.trace('p_er_rate_type '|| p_er_rate_type);
2722: hr_utility.trace('p_ee_cont_base_method '|| p_ee_cont_base_method);
2723: hr_utility.trace('p_er_cont_base_method '|| p_er_cont_base_method);

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

2716: hr_utility.trace(' =======================================================');
2717: hr_utility.trace('p_phf_si_type '||p_phf_si_type);
2718: hr_utility.trace('p_ee_rate '|| p_ee_rate);
2719: hr_utility.trace('p_er_rate '|| p_er_rate);
2720: hr_utility.trace('p_ee_rate_type '|| p_ee_rate_type);
2721: hr_utility.trace('p_er_rate_type '|| p_er_rate_type);
2722: hr_utility.trace('p_ee_cont_base_method '|| p_ee_cont_base_method);
2723: hr_utility.trace('p_er_cont_base_method '|| p_er_cont_base_method);
2724: hr_utility.trace('p_ee_cont_base_amount '|| p_ee_cont_base_amount);

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

2717: hr_utility.trace('p_phf_si_type '||p_phf_si_type);
2718: hr_utility.trace('p_ee_rate '|| p_ee_rate);
2719: hr_utility.trace('p_er_rate '|| p_er_rate);
2720: hr_utility.trace('p_ee_rate_type '|| p_ee_rate_type);
2721: hr_utility.trace('p_er_rate_type '|| p_er_rate_type);
2722: hr_utility.trace('p_ee_cont_base_method '|| p_ee_cont_base_method);
2723: hr_utility.trace('p_er_cont_base_method '|| p_er_cont_base_method);
2724: hr_utility.trace('p_ee_cont_base_amount '|| p_ee_cont_base_amount);
2725: hr_utility.trace('p_er_cont_base_amount '|| p_er_cont_base_amount);

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

2718: hr_utility.trace('p_ee_rate '|| p_ee_rate);
2719: hr_utility.trace('p_er_rate '|| p_er_rate);
2720: hr_utility.trace('p_ee_rate_type '|| p_ee_rate_type);
2721: hr_utility.trace('p_er_rate_type '|| p_er_rate_type);
2722: hr_utility.trace('p_ee_cont_base_method '|| p_ee_cont_base_method);
2723: hr_utility.trace('p_er_cont_base_method '|| p_er_cont_base_method);
2724: hr_utility.trace('p_ee_cont_base_amount '|| p_ee_cont_base_amount);
2725: hr_utility.trace('p_er_cont_base_amount '|| p_er_cont_base_amount);
2726: hr_utility.trace('p_ee_fixed_amount '|| p_ee_fixed_amount);

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

2719: hr_utility.trace('p_er_rate '|| p_er_rate);
2720: hr_utility.trace('p_ee_rate_type '|| p_ee_rate_type);
2721: hr_utility.trace('p_er_rate_type '|| p_er_rate_type);
2722: hr_utility.trace('p_ee_cont_base_method '|| p_ee_cont_base_method);
2723: hr_utility.trace('p_er_cont_base_method '|| p_er_cont_base_method);
2724: hr_utility.trace('p_ee_cont_base_amount '|| p_ee_cont_base_amount);
2725: hr_utility.trace('p_er_cont_base_amount '|| p_er_cont_base_amount);
2726: hr_utility.trace('p_ee_fixed_amount '|| p_ee_fixed_amount);
2727: hr_utility.trace('p_er_fixed_amount '|| p_er_fixed_amount);

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

2720: hr_utility.trace('p_ee_rate_type '|| p_ee_rate_type);
2721: hr_utility.trace('p_er_rate_type '|| p_er_rate_type);
2722: hr_utility.trace('p_ee_cont_base_method '|| p_ee_cont_base_method);
2723: hr_utility.trace('p_er_cont_base_method '|| p_er_cont_base_method);
2724: hr_utility.trace('p_ee_cont_base_amount '|| p_ee_cont_base_amount);
2725: hr_utility.trace('p_er_cont_base_amount '|| p_er_cont_base_amount);
2726: hr_utility.trace('p_ee_fixed_amount '|| p_ee_fixed_amount);
2727: hr_utility.trace('p_er_fixed_amount '|| p_er_fixed_amount);
2728: hr_utility.trace('p_average_salary '|| p_average_salary);

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

2721: hr_utility.trace('p_er_rate_type '|| p_er_rate_type);
2722: hr_utility.trace('p_ee_cont_base_method '|| p_ee_cont_base_method);
2723: hr_utility.trace('p_er_cont_base_method '|| p_er_cont_base_method);
2724: hr_utility.trace('p_ee_cont_base_amount '|| p_ee_cont_base_amount);
2725: hr_utility.trace('p_er_cont_base_amount '|| p_er_cont_base_amount);
2726: hr_utility.trace('p_ee_fixed_amount '|| p_ee_fixed_amount);
2727: hr_utility.trace('p_er_fixed_amount '|| p_er_fixed_amount);
2728: hr_utility.trace('p_average_salary '|| p_average_salary);
2729: hr_utility.trace('p_lowest_avg_salary '|| p_lowest_avg_salary);

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

2722: hr_utility.trace('p_ee_cont_base_method '|| p_ee_cont_base_method);
2723: hr_utility.trace('p_er_cont_base_method '|| p_er_cont_base_method);
2724: hr_utility.trace('p_ee_cont_base_amount '|| p_ee_cont_base_amount);
2725: hr_utility.trace('p_er_cont_base_amount '|| p_er_cont_base_amount);
2726: hr_utility.trace('p_ee_fixed_amount '|| p_ee_fixed_amount);
2727: hr_utility.trace('p_er_fixed_amount '|| p_er_fixed_amount);
2728: hr_utility.trace('p_average_salary '|| p_average_salary);
2729: hr_utility.trace('p_lowest_avg_salary '|| p_lowest_avg_salary);
2730: hr_utility.trace('p_ee_rate_rounding_method '|| p_ee_rate_rounding_method);

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

2723: hr_utility.trace('p_er_cont_base_method '|| p_er_cont_base_method);
2724: hr_utility.trace('p_ee_cont_base_amount '|| p_ee_cont_base_amount);
2725: hr_utility.trace('p_er_cont_base_amount '|| p_er_cont_base_amount);
2726: hr_utility.trace('p_ee_fixed_amount '|| p_ee_fixed_amount);
2727: hr_utility.trace('p_er_fixed_amount '|| p_er_fixed_amount);
2728: hr_utility.trace('p_average_salary '|| p_average_salary);
2729: hr_utility.trace('p_lowest_avg_salary '|| p_lowest_avg_salary);
2730: hr_utility.trace('p_ee_rate_rounding_method '|| p_ee_rate_rounding_method);
2731: hr_utility.trace('p_er_rate_rounding_method '|| p_er_rate_rounding_method);

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

2724: hr_utility.trace('p_ee_cont_base_amount '|| p_ee_cont_base_amount);
2725: hr_utility.trace('p_er_cont_base_amount '|| p_er_cont_base_amount);
2726: hr_utility.trace('p_ee_fixed_amount '|| p_ee_fixed_amount);
2727: hr_utility.trace('p_er_fixed_amount '|| p_er_fixed_amount);
2728: hr_utility.trace('p_average_salary '|| p_average_salary);
2729: hr_utility.trace('p_lowest_avg_salary '|| p_lowest_avg_salary);
2730: hr_utility.trace('p_ee_rate_rounding_method '|| p_ee_rate_rounding_method);
2731: hr_utility.trace('p_er_rate_rounding_method '|| p_er_rate_rounding_method);
2732:

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

2725: hr_utility.trace('p_er_cont_base_amount '|| p_er_cont_base_amount);
2726: hr_utility.trace('p_ee_fixed_amount '|| p_ee_fixed_amount);
2727: hr_utility.trace('p_er_fixed_amount '|| p_er_fixed_amount);
2728: hr_utility.trace('p_average_salary '|| p_average_salary);
2729: hr_utility.trace('p_lowest_avg_salary '|| p_lowest_avg_salary);
2730: hr_utility.trace('p_ee_rate_rounding_method '|| p_ee_rate_rounding_method);
2731: hr_utility.trace('p_er_rate_rounding_method '|| p_er_rate_rounding_method);
2732:
2733: hr_utility.trace('p_ee_phf_si_amount '|| p_ee_phf_si_amount);

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

2726: hr_utility.trace('p_ee_fixed_amount '|| p_ee_fixed_amount);
2727: hr_utility.trace('p_er_fixed_amount '|| p_er_fixed_amount);
2728: hr_utility.trace('p_average_salary '|| p_average_salary);
2729: hr_utility.trace('p_lowest_avg_salary '|| p_lowest_avg_salary);
2730: hr_utility.trace('p_ee_rate_rounding_method '|| p_ee_rate_rounding_method);
2731: hr_utility.trace('p_er_rate_rounding_method '|| p_er_rate_rounding_method);
2732:
2733: hr_utility.trace('p_ee_phf_si_amount '|| p_ee_phf_si_amount);
2734: hr_utility.trace('p_er_phf_si_amount '|| p_er_phf_si_amount);

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

2727: hr_utility.trace('p_er_fixed_amount '|| p_er_fixed_amount);
2728: hr_utility.trace('p_average_salary '|| p_average_salary);
2729: hr_utility.trace('p_lowest_avg_salary '|| p_lowest_avg_salary);
2730: hr_utility.trace('p_ee_rate_rounding_method '|| p_ee_rate_rounding_method);
2731: hr_utility.trace('p_er_rate_rounding_method '|| p_er_rate_rounding_method);
2732:
2733: hr_utility.trace('p_ee_phf_si_amount '|| p_ee_phf_si_amount);
2734: hr_utility.trace('p_er_phf_si_amount '|| p_er_phf_si_amount);
2735:

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

2729: hr_utility.trace('p_lowest_avg_salary '|| p_lowest_avg_salary);
2730: hr_utility.trace('p_ee_rate_rounding_method '|| p_ee_rate_rounding_method);
2731: hr_utility.trace('p_er_rate_rounding_method '|| p_er_rate_rounding_method);
2732:
2733: hr_utility.trace('p_ee_phf_si_amount '|| p_ee_phf_si_amount);
2734: hr_utility.trace('p_er_phf_si_amount '|| p_er_phf_si_amount);
2735:
2736: hr_utility.trace('p_phf_si_earnings_asg_ptd '|| p_phf_si_earnings_asg_ptd);
2737: hr_utility.trace('p_phf_si_earnings_asg_pyear '|| p_phf_si_earnings_asg_pyear);

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

2730: hr_utility.trace('p_ee_rate_rounding_method '|| p_ee_rate_rounding_method);
2731: hr_utility.trace('p_er_rate_rounding_method '|| p_er_rate_rounding_method);
2732:
2733: hr_utility.trace('p_ee_phf_si_amount '|| p_ee_phf_si_amount);
2734: hr_utility.trace('p_er_phf_si_amount '|| p_er_phf_si_amount);
2735:
2736: hr_utility.trace('p_phf_si_earnings_asg_ptd '|| p_phf_si_earnings_asg_ptd);
2737: hr_utility.trace('p_phf_si_earnings_asg_pyear '|| p_phf_si_earnings_asg_pyear);
2738: hr_utility.trace('p_phf_si_earnings_asg_pmth '|| p_phf_si_earnings_asg_pmth);

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

2732:
2733: hr_utility.trace('p_ee_phf_si_amount '|| p_ee_phf_si_amount);
2734: hr_utility.trace('p_er_phf_si_amount '|| p_er_phf_si_amount);
2735:
2736: hr_utility.trace('p_phf_si_earnings_asg_ptd '|| p_phf_si_earnings_asg_ptd);
2737: hr_utility.trace('p_phf_si_earnings_asg_pyear '|| p_phf_si_earnings_asg_pyear);
2738: hr_utility.trace('p_phf_si_earnings_asg_pmth '|| p_phf_si_earnings_asg_pmth);
2739:
2740: hr_utility.trace('p_ee_hi_cont_type '||p_ee_hi_cont_type );

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

2733: hr_utility.trace('p_ee_phf_si_amount '|| p_ee_phf_si_amount);
2734: hr_utility.trace('p_er_phf_si_amount '|| p_er_phf_si_amount);
2735:
2736: hr_utility.trace('p_phf_si_earnings_asg_ptd '|| p_phf_si_earnings_asg_ptd);
2737: hr_utility.trace('p_phf_si_earnings_asg_pyear '|| p_phf_si_earnings_asg_pyear);
2738: hr_utility.trace('p_phf_si_earnings_asg_pmth '|| p_phf_si_earnings_asg_pmth);
2739:
2740: hr_utility.trace('p_ee_hi_cont_type '||p_ee_hi_cont_type );
2741: hr_utility.trace('p_er_hi_cont_type '||p_er_hi_cont_type );

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

2734: hr_utility.trace('p_er_phf_si_amount '|| p_er_phf_si_amount);
2735:
2736: hr_utility.trace('p_phf_si_earnings_asg_ptd '|| p_phf_si_earnings_asg_ptd);
2737: hr_utility.trace('p_phf_si_earnings_asg_pyear '|| p_phf_si_earnings_asg_pyear);
2738: hr_utility.trace('p_phf_si_earnings_asg_pmth '|| p_phf_si_earnings_asg_pmth);
2739:
2740: hr_utility.trace('p_ee_hi_cont_type '||p_ee_hi_cont_type );
2741: hr_utility.trace('p_er_hi_cont_type '||p_er_hi_cont_type );
2742: hr_utility.trace('p_ee_hi_cont_amt '||p_ee_hi_cont_amt );

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

2736: hr_utility.trace('p_phf_si_earnings_asg_ptd '|| p_phf_si_earnings_asg_ptd);
2737: hr_utility.trace('p_phf_si_earnings_asg_pyear '|| p_phf_si_earnings_asg_pyear);
2738: hr_utility.trace('p_phf_si_earnings_asg_pmth '|| p_phf_si_earnings_asg_pmth);
2739:
2740: hr_utility.trace('p_ee_hi_cont_type '||p_ee_hi_cont_type );
2741: hr_utility.trace('p_er_hi_cont_type '||p_er_hi_cont_type );
2742: hr_utility.trace('p_ee_hi_cont_amt '||p_ee_hi_cont_amt );
2743: hr_utility.trace('p_er_hi_cont_amt '||p_er_hi_cont_amt );
2744: hr_utility.trace('p_ee_hi_cont_base_meth '||p_ee_hi_cont_base_meth );

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

2737: hr_utility.trace('p_phf_si_earnings_asg_pyear '|| p_phf_si_earnings_asg_pyear);
2738: hr_utility.trace('p_phf_si_earnings_asg_pmth '|| p_phf_si_earnings_asg_pmth);
2739:
2740: hr_utility.trace('p_ee_hi_cont_type '||p_ee_hi_cont_type );
2741: hr_utility.trace('p_er_hi_cont_type '||p_er_hi_cont_type );
2742: hr_utility.trace('p_ee_hi_cont_amt '||p_ee_hi_cont_amt );
2743: hr_utility.trace('p_er_hi_cont_amt '||p_er_hi_cont_amt );
2744: hr_utility.trace('p_ee_hi_cont_base_meth '||p_ee_hi_cont_base_meth );
2745: hr_utility.trace('p_er_hi_cont_base_meth '||p_er_hi_cont_base_meth );

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

2738: hr_utility.trace('p_phf_si_earnings_asg_pmth '|| p_phf_si_earnings_asg_pmth);
2739:
2740: hr_utility.trace('p_ee_hi_cont_type '||p_ee_hi_cont_type );
2741: hr_utility.trace('p_er_hi_cont_type '||p_er_hi_cont_type );
2742: hr_utility.trace('p_ee_hi_cont_amt '||p_ee_hi_cont_amt );
2743: hr_utility.trace('p_er_hi_cont_amt '||p_er_hi_cont_amt );
2744: hr_utility.trace('p_ee_hi_cont_base_meth '||p_ee_hi_cont_base_meth );
2745: hr_utility.trace('p_er_hi_cont_base_meth '||p_er_hi_cont_base_meth );
2746: hr_utility.trace('p_ee_hi_cont_base_amount '||p_ee_hi_cont_base_amount);

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

2739:
2740: hr_utility.trace('p_ee_hi_cont_type '||p_ee_hi_cont_type );
2741: hr_utility.trace('p_er_hi_cont_type '||p_er_hi_cont_type );
2742: hr_utility.trace('p_ee_hi_cont_amt '||p_ee_hi_cont_amt );
2743: hr_utility.trace('p_er_hi_cont_amt '||p_er_hi_cont_amt );
2744: hr_utility.trace('p_ee_hi_cont_base_meth '||p_ee_hi_cont_base_meth );
2745: hr_utility.trace('p_er_hi_cont_base_meth '||p_er_hi_cont_base_meth );
2746: hr_utility.trace('p_ee_hi_cont_base_amount '||p_ee_hi_cont_base_amount);
2747: hr_utility.trace('p_er_hi_cont_base_amount '||p_er_hi_cont_base_amount);

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

2740: hr_utility.trace('p_ee_hi_cont_type '||p_ee_hi_cont_type );
2741: hr_utility.trace('p_er_hi_cont_type '||p_er_hi_cont_type );
2742: hr_utility.trace('p_ee_hi_cont_amt '||p_ee_hi_cont_amt );
2743: hr_utility.trace('p_er_hi_cont_amt '||p_er_hi_cont_amt );
2744: hr_utility.trace('p_ee_hi_cont_base_meth '||p_ee_hi_cont_base_meth );
2745: hr_utility.trace('p_er_hi_cont_base_meth '||p_er_hi_cont_base_meth );
2746: hr_utility.trace('p_ee_hi_cont_base_amount '||p_ee_hi_cont_base_amount);
2747: hr_utility.trace('p_er_hi_cont_base_amount '||p_er_hi_cont_base_amount);
2748: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont);

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

2741: hr_utility.trace('p_er_hi_cont_type '||p_er_hi_cont_type );
2742: hr_utility.trace('p_ee_hi_cont_amt '||p_ee_hi_cont_amt );
2743: hr_utility.trace('p_er_hi_cont_amt '||p_er_hi_cont_amt );
2744: hr_utility.trace('p_ee_hi_cont_base_meth '||p_ee_hi_cont_base_meth );
2745: hr_utility.trace('p_er_hi_cont_base_meth '||p_er_hi_cont_base_meth );
2746: hr_utility.trace('p_ee_hi_cont_base_amount '||p_ee_hi_cont_base_amount);
2747: hr_utility.trace('p_er_hi_cont_base_amount '||p_er_hi_cont_base_amount);
2748: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont);
2749: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont);

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

2742: hr_utility.trace('p_ee_hi_cont_amt '||p_ee_hi_cont_amt );
2743: hr_utility.trace('p_er_hi_cont_amt '||p_er_hi_cont_amt );
2744: hr_utility.trace('p_ee_hi_cont_base_meth '||p_ee_hi_cont_base_meth );
2745: hr_utility.trace('p_er_hi_cont_base_meth '||p_er_hi_cont_base_meth );
2746: hr_utility.trace('p_ee_hi_cont_base_amount '||p_ee_hi_cont_base_amount);
2747: hr_utility.trace('p_er_hi_cont_base_amount '||p_er_hi_cont_base_amount);
2748: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont);
2749: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont);
2750: hr_utility.trace('p_date_earned '||p_date_earned);

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

2743: hr_utility.trace('p_er_hi_cont_amt '||p_er_hi_cont_amt );
2744: hr_utility.trace('p_ee_hi_cont_base_meth '||p_ee_hi_cont_base_meth );
2745: hr_utility.trace('p_er_hi_cont_base_meth '||p_er_hi_cont_base_meth );
2746: hr_utility.trace('p_ee_hi_cont_base_amount '||p_ee_hi_cont_base_amount);
2747: hr_utility.trace('p_er_hi_cont_base_amount '||p_er_hi_cont_base_amount);
2748: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont);
2749: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont);
2750: hr_utility.trace('p_date_earned '||p_date_earned);
2751: hr_utility.trace('p_ee_tax_thrhld_rate '||p_ee_tax_thrhld_rate);

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

2744: hr_utility.trace('p_ee_hi_cont_base_meth '||p_ee_hi_cont_base_meth );
2745: hr_utility.trace('p_er_hi_cont_base_meth '||p_er_hi_cont_base_meth );
2746: hr_utility.trace('p_ee_hi_cont_base_amount '||p_ee_hi_cont_base_amount);
2747: hr_utility.trace('p_er_hi_cont_base_amount '||p_er_hi_cont_base_amount);
2748: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont);
2749: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont);
2750: hr_utility.trace('p_date_earned '||p_date_earned);
2751: hr_utility.trace('p_ee_tax_thrhld_rate '||p_ee_tax_thrhld_rate);
2752: hr_utility.trace('p_er_tax_thrhld_rate '||p_er_tax_thrhld_rate);

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

2745: hr_utility.trace('p_er_hi_cont_base_meth '||p_er_hi_cont_base_meth );
2746: hr_utility.trace('p_ee_hi_cont_base_amount '||p_ee_hi_cont_base_amount);
2747: hr_utility.trace('p_er_hi_cont_base_amount '||p_er_hi_cont_base_amount);
2748: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont);
2749: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont);
2750: hr_utility.trace('p_date_earned '||p_date_earned);
2751: hr_utility.trace('p_ee_tax_thrhld_rate '||p_ee_tax_thrhld_rate);
2752: hr_utility.trace('p_er_tax_thrhld_rate '||p_er_tax_thrhld_rate);
2753: hr_utility.trace('p_tax_thrhld_amount '||p_tax_thrhld_amount);

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

2746: hr_utility.trace('p_ee_hi_cont_base_amount '||p_ee_hi_cont_base_amount);
2747: hr_utility.trace('p_er_hi_cont_base_amount '||p_er_hi_cont_base_amount);
2748: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont);
2749: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont);
2750: hr_utility.trace('p_date_earned '||p_date_earned);
2751: hr_utility.trace('p_ee_tax_thrhld_rate '||p_ee_tax_thrhld_rate);
2752: hr_utility.trace('p_er_tax_thrhld_rate '||p_er_tax_thrhld_rate);
2753: hr_utility.trace('p_tax_thrhld_amount '||p_tax_thrhld_amount);
2754: hr_utility.trace(' =======================================================');

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

2747: hr_utility.trace('p_er_hi_cont_base_amount '||p_er_hi_cont_base_amount);
2748: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont);
2749: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont);
2750: hr_utility.trace('p_date_earned '||p_date_earned);
2751: hr_utility.trace('p_ee_tax_thrhld_rate '||p_ee_tax_thrhld_rate);
2752: hr_utility.trace('p_er_tax_thrhld_rate '||p_er_tax_thrhld_rate);
2753: hr_utility.trace('p_tax_thrhld_amount '||p_tax_thrhld_amount);
2754: hr_utility.trace(' =======================================================');
2755: END IF;

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

2748: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont);
2749: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont);
2750: hr_utility.trace('p_date_earned '||p_date_earned);
2751: hr_utility.trace('p_ee_tax_thrhld_rate '||p_ee_tax_thrhld_rate);
2752: hr_utility.trace('p_er_tax_thrhld_rate '||p_er_tax_thrhld_rate);
2753: hr_utility.trace('p_tax_thrhld_amount '||p_tax_thrhld_amount);
2754: hr_utility.trace(' =======================================================');
2755: END IF;
2756: ---------------------------------------------------------------------------------------------

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

2749: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont);
2750: hr_utility.trace('p_date_earned '||p_date_earned);
2751: hr_utility.trace('p_ee_tax_thrhld_rate '||p_ee_tax_thrhld_rate);
2752: hr_utility.trace('p_er_tax_thrhld_rate '||p_er_tax_thrhld_rate);
2753: hr_utility.trace('p_tax_thrhld_amount '||p_tax_thrhld_amount);
2754: hr_utility.trace(' =======================================================');
2755: END IF;
2756: ---------------------------------------------------------------------------------------------
2757: /* Start Bug 5563042 (PHF and SI Enhancements), check for employee level data */

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

2750: hr_utility.trace('p_date_earned '||p_date_earned);
2751: hr_utility.trace('p_ee_tax_thrhld_rate '||p_ee_tax_thrhld_rate);
2752: hr_utility.trace('p_er_tax_thrhld_rate '||p_er_tax_thrhld_rate);
2753: hr_utility.trace('p_tax_thrhld_amount '||p_tax_thrhld_amount);
2754: hr_utility.trace(' =======================================================');
2755: END IF;
2756: ---------------------------------------------------------------------------------------------
2757: /* Start Bug 5563042 (PHF and SI Enhancements), check for employee level data */
2758: ---------------------------------------------------------------------------------------------

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

2792: l_tax_thrhld_amount := p_tax_thrhld_amount;
2793:
2794:
2795: IF g_debug THEN
2796: hr_utility.trace(' =======================================================');
2797: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);
2798: hr_utility.trace(' . l_er_rate : '||l_er_rate);
2799: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
2800: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);

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

2793:
2794:
2795: IF g_debug THEN
2796: hr_utility.trace(' =======================================================');
2797: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);
2798: hr_utility.trace(' . l_er_rate : '||l_er_rate);
2799: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
2800: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
2801: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);

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

2794:
2795: IF g_debug THEN
2796: hr_utility.trace(' =======================================================');
2797: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);
2798: hr_utility.trace(' . l_er_rate : '||l_er_rate);
2799: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
2800: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
2801: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
2802: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);

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

2795: IF g_debug THEN
2796: hr_utility.trace(' =======================================================');
2797: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);
2798: hr_utility.trace(' . l_er_rate : '||l_er_rate);
2799: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
2800: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
2801: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
2802: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
2803: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);

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

2796: hr_utility.trace(' =======================================================');
2797: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);
2798: hr_utility.trace(' . l_er_rate : '||l_er_rate);
2799: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
2800: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
2801: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
2802: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
2803: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
2804: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);

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

2797: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);
2798: hr_utility.trace(' . l_er_rate : '||l_er_rate);
2799: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
2800: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
2801: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
2802: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
2803: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
2804: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
2805: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);

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

2798: hr_utility.trace(' . l_er_rate : '||l_er_rate);
2799: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
2800: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
2801: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
2802: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
2803: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
2804: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
2805: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
2806: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);

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

2799: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
2800: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
2801: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
2802: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
2803: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
2804: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
2805: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
2806: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
2807: hr_utility.trace(' . l_average_salary : '||l_average_salary);

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

2800: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
2801: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
2802: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
2803: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
2804: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
2805: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
2806: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
2807: hr_utility.trace(' . l_average_salary : '||l_average_salary);
2808: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);

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

2801: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
2802: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
2803: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
2804: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
2805: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
2806: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
2807: hr_utility.trace(' . l_average_salary : '||l_average_salary);
2808: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
2809: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);

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

2802: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
2803: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
2804: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
2805: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
2806: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
2807: hr_utility.trace(' . l_average_salary : '||l_average_salary);
2808: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
2809: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
2810: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);

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

2803: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
2804: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
2805: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
2806: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
2807: hr_utility.trace(' . l_average_salary : '||l_average_salary);
2808: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
2809: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
2810: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
2811: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);

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

2804: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
2805: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
2806: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
2807: hr_utility.trace(' . l_average_salary : '||l_average_salary);
2808: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
2809: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
2810: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
2811: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
2812: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);

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

2805: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
2806: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
2807: hr_utility.trace(' . l_average_salary : '||l_average_salary);
2808: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
2809: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
2810: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
2811: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
2812: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
2813: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);

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

2806: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
2807: hr_utility.trace(' . l_average_salary : '||l_average_salary);
2808: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
2809: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
2810: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
2811: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
2812: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
2813: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
2814: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);

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

2807: hr_utility.trace(' . l_average_salary : '||l_average_salary);
2808: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
2809: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
2810: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
2811: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
2812: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
2813: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
2814: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
2815: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);

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

2808: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
2809: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
2810: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
2811: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
2812: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
2813: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
2814: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
2815: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
2816: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );

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

2809: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
2810: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
2811: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
2812: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
2813: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
2814: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
2815: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
2816: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2817: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );

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

2810: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
2811: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
2812: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
2813: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
2814: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
2815: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
2816: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2817: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2818: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );

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

2811: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
2812: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
2813: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
2814: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
2815: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
2816: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2817: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2818: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2819: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );

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

2812: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
2813: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
2814: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
2815: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
2816: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2817: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2818: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2819: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2820: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );

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

2813: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
2814: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
2815: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
2816: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2817: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2818: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2819: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2820: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2821: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );

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

2814: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
2815: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
2816: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2817: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2818: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2819: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2820: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2821: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2822: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);

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

2815: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
2816: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2817: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2818: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2819: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2820: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2821: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2822: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
2823: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);

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

2816: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2817: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2818: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2819: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2820: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2821: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2822: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
2823: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
2824: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);

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

2817: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2818: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2819: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2820: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2821: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2822: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
2823: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
2824: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
2825: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);

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

2818: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2819: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2820: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2821: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2822: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
2823: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
2824: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
2825: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
2826: hr_utility.trace(' . l_ee_tax_thrhld_rate : '||l_ee_tax_thrhld_rate);

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

2819: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2820: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2821: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2822: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
2823: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
2824: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
2825: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
2826: hr_utility.trace(' . l_ee_tax_thrhld_rate : '||l_ee_tax_thrhld_rate);
2827: hr_utility.trace(' . l_er_tax_thrhld_rate : '||l_er_tax_thrhld_rate);

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

2820: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2821: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2822: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
2823: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
2824: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
2825: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
2826: hr_utility.trace(' . l_ee_tax_thrhld_rate : '||l_ee_tax_thrhld_rate);
2827: hr_utility.trace(' . l_er_tax_thrhld_rate : '||l_er_tax_thrhld_rate);
2828: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);

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

2821: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2822: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
2823: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
2824: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
2825: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
2826: hr_utility.trace(' . l_ee_tax_thrhld_rate : '||l_ee_tax_thrhld_rate);
2827: hr_utility.trace(' . l_er_tax_thrhld_rate : '||l_er_tax_thrhld_rate);
2828: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);
2829: hr_utility.trace(' =======================================================');

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

2822: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
2823: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
2824: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
2825: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
2826: hr_utility.trace(' . l_ee_tax_thrhld_rate : '||l_ee_tax_thrhld_rate);
2827: hr_utility.trace(' . l_er_tax_thrhld_rate : '||l_er_tax_thrhld_rate);
2828: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);
2829: hr_utility.trace(' =======================================================');
2830: END IF;

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

2823: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
2824: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
2825: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
2826: hr_utility.trace(' . l_ee_tax_thrhld_rate : '||l_ee_tax_thrhld_rate);
2827: hr_utility.trace(' . l_er_tax_thrhld_rate : '||l_er_tax_thrhld_rate);
2828: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);
2829: hr_utility.trace(' =======================================================');
2830: END IF;
2831:

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

2824: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
2825: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
2826: hr_utility.trace(' . l_ee_tax_thrhld_rate : '||l_ee_tax_thrhld_rate);
2827: hr_utility.trace(' . l_er_tax_thrhld_rate : '||l_er_tax_thrhld_rate);
2828: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);
2829: hr_utility.trace(' =======================================================');
2830: END IF;
2831:
2832: IF (p_ee_hi_cont_amt = -1) THEN

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

2825: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
2826: hr_utility.trace(' . l_ee_tax_thrhld_rate : '||l_ee_tax_thrhld_rate);
2827: hr_utility.trace(' . l_er_tax_thrhld_rate : '||l_er_tax_thrhld_rate);
2828: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);
2829: hr_utility.trace(' =======================================================');
2830: END IF;
2831:
2832: IF (p_ee_hi_cont_amt = -1) THEN
2833: l_ee_hi_cont_amt := l_ee_rate;

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

2851: l_out_er_hi_cont_base_amount := l_er_cont_base_amount;
2852: END IF;
2853:
2854: IF g_debug THEN
2855: hr_utility.trace(' =======================================================');
2856: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2857: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2858: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2859: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );

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

2852: END IF;
2853:
2854: IF g_debug THEN
2855: hr_utility.trace(' =======================================================');
2856: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2857: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2858: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2859: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2860: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );

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

2853:
2854: IF g_debug THEN
2855: hr_utility.trace(' =======================================================');
2856: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2857: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2858: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2859: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2860: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2861: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );

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

2854: IF g_debug THEN
2855: hr_utility.trace(' =======================================================');
2856: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2857: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2858: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2859: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2860: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2861: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2862: hr_utility.trace(' . l_ee_hi_cont_base_amount: '||l_ee_hi_cont_base_amount);

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

2855: hr_utility.trace(' =======================================================');
2856: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2857: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2858: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2859: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2860: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2861: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2862: hr_utility.trace(' . l_ee_hi_cont_base_amount: '||l_ee_hi_cont_base_amount);
2863: hr_utility.trace(' . l_er_hi_cont_base_amount: '||l_er_hi_cont_base_amount);

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

2856: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2857: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2858: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2859: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2860: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2861: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2862: hr_utility.trace(' . l_ee_hi_cont_base_amount: '||l_ee_hi_cont_base_amount);
2863: hr_utility.trace(' . l_er_hi_cont_base_amount: '||l_er_hi_cont_base_amount);
2864: hr_utility.trace(' . l_out_ee_hi_cont_base_amount: '||l_out_ee_hi_cont_base_amount);

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

2857: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2858: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2859: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2860: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2861: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2862: hr_utility.trace(' . l_ee_hi_cont_base_amount: '||l_ee_hi_cont_base_amount);
2863: hr_utility.trace(' . l_er_hi_cont_base_amount: '||l_er_hi_cont_base_amount);
2864: hr_utility.trace(' . l_out_ee_hi_cont_base_amount: '||l_out_ee_hi_cont_base_amount);
2865: hr_utility.trace(' . l_out_er_hi_cont_base_amount: '||l_out_er_hi_cont_base_amount);

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

2858: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2859: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2860: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2861: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2862: hr_utility.trace(' . l_ee_hi_cont_base_amount: '||l_ee_hi_cont_base_amount);
2863: hr_utility.trace(' . l_er_hi_cont_base_amount: '||l_er_hi_cont_base_amount);
2864: hr_utility.trace(' . l_out_ee_hi_cont_base_amount: '||l_out_ee_hi_cont_base_amount);
2865: hr_utility.trace(' . l_out_er_hi_cont_base_amount: '||l_out_er_hi_cont_base_amount);
2866: hr_utility.trace(' =======================================================');

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

2859: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2860: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2861: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2862: hr_utility.trace(' . l_ee_hi_cont_base_amount: '||l_ee_hi_cont_base_amount);
2863: hr_utility.trace(' . l_er_hi_cont_base_amount: '||l_er_hi_cont_base_amount);
2864: hr_utility.trace(' . l_out_ee_hi_cont_base_amount: '||l_out_ee_hi_cont_base_amount);
2865: hr_utility.trace(' . l_out_er_hi_cont_base_amount: '||l_out_er_hi_cont_base_amount);
2866: hr_utility.trace(' =======================================================');
2867: END IF;

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

2860: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
2861: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2862: hr_utility.trace(' . l_ee_hi_cont_base_amount: '||l_ee_hi_cont_base_amount);
2863: hr_utility.trace(' . l_er_hi_cont_base_amount: '||l_er_hi_cont_base_amount);
2864: hr_utility.trace(' . l_out_ee_hi_cont_base_amount: '||l_out_ee_hi_cont_base_amount);
2865: hr_utility.trace(' . l_out_er_hi_cont_base_amount: '||l_out_er_hi_cont_base_amount);
2866: hr_utility.trace(' =======================================================');
2867: END IF;
2868:

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

2861: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
2862: hr_utility.trace(' . l_ee_hi_cont_base_amount: '||l_ee_hi_cont_base_amount);
2863: hr_utility.trace(' . l_er_hi_cont_base_amount: '||l_er_hi_cont_base_amount);
2864: hr_utility.trace(' . l_out_ee_hi_cont_base_amount: '||l_out_ee_hi_cont_base_amount);
2865: hr_utility.trace(' . l_out_er_hi_cont_base_amount: '||l_out_er_hi_cont_base_amount);
2866: hr_utility.trace(' =======================================================');
2867: END IF;
2868:
2869: IF (l_out_ee_hi_cont_base_amount = 0) THEN

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

2862: hr_utility.trace(' . l_ee_hi_cont_base_amount: '||l_ee_hi_cont_base_amount);
2863: hr_utility.trace(' . l_er_hi_cont_base_amount: '||l_er_hi_cont_base_amount);
2864: hr_utility.trace(' . l_out_ee_hi_cont_base_amount: '||l_out_ee_hi_cont_base_amount);
2865: hr_utility.trace(' . l_out_er_hi_cont_base_amount: '||l_out_er_hi_cont_base_amount);
2866: hr_utility.trace(' =======================================================');
2867: END IF;
2868:
2869: IF (l_out_ee_hi_cont_base_amount = 0) THEN
2870: l_message :=

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

2945: END IF;
2946:
2947:
2948: IF g_debug THEN
2949: hr_utility.trace(' =======================================================');
2950: hr_utility.trace(' . p_phf_si_type : '||p_phf_si_type );
2951: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2952: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2953: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );

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

2946:
2947:
2948: IF g_debug THEN
2949: hr_utility.trace(' =======================================================');
2950: hr_utility.trace(' . p_phf_si_type : '||p_phf_si_type );
2951: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2952: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2953: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2954: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );

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

2947:
2948: IF g_debug THEN
2949: hr_utility.trace(' =======================================================');
2950: hr_utility.trace(' . p_phf_si_type : '||p_phf_si_type );
2951: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2952: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2953: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2954: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2955: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type );

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

2948: IF g_debug THEN
2949: hr_utility.trace(' =======================================================');
2950: hr_utility.trace(' . p_phf_si_type : '||p_phf_si_type );
2951: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2952: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2953: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2954: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2955: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type );
2956: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );

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

2949: hr_utility.trace(' =======================================================');
2950: hr_utility.trace(' . p_phf_si_type : '||p_phf_si_type );
2951: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2952: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2953: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2954: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2955: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type );
2956: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
2957: hr_utility.trace(' . l_ee_phf_si_amount_higher: '||l_ee_phf_si_amount_higher);

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

2950: hr_utility.trace(' . p_phf_si_type : '||p_phf_si_type );
2951: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2952: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2953: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2954: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2955: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type );
2956: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
2957: hr_utility.trace(' . l_ee_phf_si_amount_higher: '||l_ee_phf_si_amount_higher);
2958: hr_utility.trace(' . l_er_phf_si_amount_higher: '||l_er_phf_si_amount_higher);

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

2951: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
2952: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2953: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2954: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2955: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type );
2956: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
2957: hr_utility.trace(' . l_ee_phf_si_amount_higher: '||l_ee_phf_si_amount_higher);
2958: hr_utility.trace(' . l_er_phf_si_amount_higher: '||l_er_phf_si_amount_higher);
2959: hr_utility.trace(' =======================================================');

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

2952: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
2953: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2954: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2955: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type );
2956: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
2957: hr_utility.trace(' . l_ee_phf_si_amount_higher: '||l_ee_phf_si_amount_higher);
2958: hr_utility.trace(' . l_er_phf_si_amount_higher: '||l_er_phf_si_amount_higher);
2959: hr_utility.trace(' =======================================================');
2960: END IF;

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

2953: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
2954: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2955: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type );
2956: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
2957: hr_utility.trace(' . l_ee_phf_si_amount_higher: '||l_ee_phf_si_amount_higher);
2958: hr_utility.trace(' . l_er_phf_si_amount_higher: '||l_er_phf_si_amount_higher);
2959: hr_utility.trace(' =======================================================');
2960: END IF;
2961:

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

2954: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
2955: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type );
2956: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
2957: hr_utility.trace(' . l_ee_phf_si_amount_higher: '||l_ee_phf_si_amount_higher);
2958: hr_utility.trace(' . l_er_phf_si_amount_higher: '||l_er_phf_si_amount_higher);
2959: hr_utility.trace(' =======================================================');
2960: END IF;
2961:
2962:

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

2955: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type );
2956: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
2957: hr_utility.trace(' . l_ee_phf_si_amount_higher: '||l_ee_phf_si_amount_higher);
2958: hr_utility.trace(' . l_er_phf_si_amount_higher: '||l_er_phf_si_amount_higher);
2959: hr_utility.trace(' =======================================================');
2960: END IF;
2961:
2962:
2963: /* 6828199 - all the 4 phf si types can enter this piece of code now

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

3170:
3171:
3172:
3173: IF g_debug THEN
3174: hr_utility.trace(' =======================================================');
3175: hr_utility.trace('p_ee_phf_si_amount '||p_ee_phf_si_amount );
3176: hr_utility.trace('p_er_phf_si_amount '||p_er_phf_si_amount );
3177: hr_utility.trace('p_er_cont_base_amount '||p_er_cont_base_amount );
3178: hr_utility.trace('p_ee_cont_base_amount '||p_ee_cont_base_amount );

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

3171:
3172:
3173: IF g_debug THEN
3174: hr_utility.trace(' =======================================================');
3175: hr_utility.trace('p_ee_phf_si_amount '||p_ee_phf_si_amount );
3176: hr_utility.trace('p_er_phf_si_amount '||p_er_phf_si_amount );
3177: hr_utility.trace('p_er_cont_base_amount '||p_er_cont_base_amount );
3178: hr_utility.trace('p_ee_cont_base_amount '||p_ee_cont_base_amount );
3179: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont );

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

3172:
3173: IF g_debug THEN
3174: hr_utility.trace(' =======================================================');
3175: hr_utility.trace('p_ee_phf_si_amount '||p_ee_phf_si_amount );
3176: hr_utility.trace('p_er_phf_si_amount '||p_er_phf_si_amount );
3177: hr_utility.trace('p_er_cont_base_amount '||p_er_cont_base_amount );
3178: hr_utility.trace('p_ee_cont_base_amount '||p_ee_cont_base_amount );
3179: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont );
3180: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont );

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

3173: IF g_debug THEN
3174: hr_utility.trace(' =======================================================');
3175: hr_utility.trace('p_ee_phf_si_amount '||p_ee_phf_si_amount );
3176: hr_utility.trace('p_er_phf_si_amount '||p_er_phf_si_amount );
3177: hr_utility.trace('p_er_cont_base_amount '||p_er_cont_base_amount );
3178: hr_utility.trace('p_ee_cont_base_amount '||p_ee_cont_base_amount );
3179: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont );
3180: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont );
3181: hr_utility.trace(' =======================================================');

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

3174: hr_utility.trace(' =======================================================');
3175: hr_utility.trace('p_ee_phf_si_amount '||p_ee_phf_si_amount );
3176: hr_utility.trace('p_er_phf_si_amount '||p_er_phf_si_amount );
3177: hr_utility.trace('p_er_cont_base_amount '||p_er_cont_base_amount );
3178: hr_utility.trace('p_ee_cont_base_amount '||p_ee_cont_base_amount );
3179: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont );
3180: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont );
3181: hr_utility.trace(' =======================================================');
3182: END IF;

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

3175: hr_utility.trace('p_ee_phf_si_amount '||p_ee_phf_si_amount );
3176: hr_utility.trace('p_er_phf_si_amount '||p_er_phf_si_amount );
3177: hr_utility.trace('p_er_cont_base_amount '||p_er_cont_base_amount );
3178: hr_utility.trace('p_ee_cont_base_amount '||p_ee_cont_base_amount );
3179: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont );
3180: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont );
3181: hr_utility.trace(' =======================================================');
3182: END IF;
3183:

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

3176: hr_utility.trace('p_er_phf_si_amount '||p_er_phf_si_amount );
3177: hr_utility.trace('p_er_cont_base_amount '||p_er_cont_base_amount );
3178: hr_utility.trace('p_ee_cont_base_amount '||p_ee_cont_base_amount );
3179: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont );
3180: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont );
3181: hr_utility.trace(' =======================================================');
3182: END IF;
3183:
3184: hr_cn_api.set_location(g_debug,' Leaving PHF and SI Enhancements started from 1-Jan-2006: ', 460);

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

3177: hr_utility.trace('p_er_cont_base_amount '||p_er_cont_base_amount );
3178: hr_utility.trace('p_ee_cont_base_amount '||p_ee_cont_base_amount );
3179: hr_utility.trace('p_ee_taxable_cont '||p_ee_taxable_cont );
3180: hr_utility.trace('p_er_taxable_cont '||p_er_taxable_cont );
3181: hr_utility.trace(' =======================================================');
3182: END IF;
3183:
3184: hr_cn_api.set_location(g_debug,' Leaving PHF and SI Enhancements started from 1-Jan-2006: ', 460);
3185:

Line 3412: g_debug := hr_utility.debug_enabled;

3408:
3409:
3410: BEGIN
3411:
3412: g_debug := hr_utility.debug_enabled;
3413: g_procedure_name := g_package_name || 'calculate_contribution';
3414:
3415: hr_cn_api.set_location(g_debug, ' Entering: '||g_procedure_name, 10);
3416:

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

3475: ,p_ee_rounding_method => l_ee_rate_rounding_method
3476: ,p_er_rounding_method => l_er_rate_rounding_method
3477: );
3478:
3479: hr_utility.trace(' Calculate_contribution : Message=>' || l_message);
3480: IF l_message <> 'SUCCESS'
3481: THEN
3482: hr_cn_api.set_location(g_debug,' Leaving : '||g_procedure_name, 25);
3483: RAISE initialize_on_error;

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

3508: ,p_er_fixed_amount => l_er_fixed_amount
3509: ,p_tax_thrhld_amount => l_tax_thrhld_amount -- added for bug 6828199
3510: );
3511:
3512: hr_utility.trace(' get_cont_base_method : Message=>' || l_message);
3513:
3514: IF l_message <> 'SUCCESS'
3515: THEN
3516: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 45);

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

3544: ,p_switch_month => l_switch_month
3545: ,p_calculation_date => l_calculation_date
3546: ,p_process_date => p_pay_proc_period_end_date);
3547:
3548: hr_utility.trace(' l_recalculate_flag : Message=>' || l_recalculate_flag);
3549:
3550: IF l_recalculate_flag='N' THEN
3551: --
3552: -- Step 3: Assign the contribution base amounts with corresponding

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

3744:
3745: END IF;
3746:
3747: */
3748: hr_utility.trace(' l_ee_rate =>' || l_ee_rate);
3749: hr_utility.trace(' l_er_rate =>' || l_er_rate);
3750:
3751: l_ee_phf_si_amount :=
3752: get_cont_amount

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

3745: END IF;
3746:
3747: */
3748: hr_utility.trace(' l_ee_rate =>' || l_ee_rate);
3749: hr_utility.trace(' l_er_rate =>' || l_er_rate);
3750:
3751: l_ee_phf_si_amount :=
3752: get_cont_amount
3753: (p_cont_base => l_ee_cont_base_amount

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

3764: RETURN l_message;
3765: END IF;
3766:
3767: IF g_debug THEN
3768: hr_utility.trace(' =======================================================');
3769: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount );
3770: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
3771: hr_utility.trace(' . l_er_rate : '||l_er_rate );
3772: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method );

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

3765: END IF;
3766:
3767: IF g_debug THEN
3768: hr_utility.trace(' =======================================================');
3769: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount );
3770: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
3771: hr_utility.trace(' . l_er_rate : '||l_er_rate );
3772: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method );
3773: hr_utility.trace(' =======================================================');

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

3766:
3767: IF g_debug THEN
3768: hr_utility.trace(' =======================================================');
3769: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount );
3770: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
3771: hr_utility.trace(' . l_er_rate : '||l_er_rate );
3772: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method );
3773: hr_utility.trace(' =======================================================');
3774: END IF;

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

3767: IF g_debug THEN
3768: hr_utility.trace(' =======================================================');
3769: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount );
3770: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
3771: hr_utility.trace(' . l_er_rate : '||l_er_rate );
3772: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method );
3773: hr_utility.trace(' =======================================================');
3774: END IF;
3775:

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

3768: hr_utility.trace(' =======================================================');
3769: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount );
3770: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
3771: hr_utility.trace(' . l_er_rate : '||l_er_rate );
3772: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method );
3773: hr_utility.trace(' =======================================================');
3774: END IF;
3775:
3776: l_er_phf_si_amount :=

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

3769: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount );
3770: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type );
3771: hr_utility.trace(' . l_er_rate : '||l_er_rate );
3772: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method );
3773: hr_utility.trace(' =======================================================');
3774: END IF;
3775:
3776: l_er_phf_si_amount :=
3777: get_cont_amount

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

3789:
3790:
3791:
3792: IF g_debug THEN
3793: hr_utility.trace(' =======================================================');
3794: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);
3795: hr_utility.trace(' . l_er_rate : '||l_er_rate);
3796: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
3797: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);

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

3790:
3791:
3792: IF g_debug THEN
3793: hr_utility.trace(' =======================================================');
3794: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);
3795: hr_utility.trace(' . l_er_rate : '||l_er_rate);
3796: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
3797: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
3798: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);

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

3791:
3792: IF g_debug THEN
3793: hr_utility.trace(' =======================================================');
3794: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);
3795: hr_utility.trace(' . l_er_rate : '||l_er_rate);
3796: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
3797: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
3798: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
3799: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);

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

3792: IF g_debug THEN
3793: hr_utility.trace(' =======================================================');
3794: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);
3795: hr_utility.trace(' . l_er_rate : '||l_er_rate);
3796: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
3797: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
3798: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
3799: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
3800: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);

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

3793: hr_utility.trace(' =======================================================');
3794: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);
3795: hr_utility.trace(' . l_er_rate : '||l_er_rate);
3796: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
3797: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
3798: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
3799: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
3800: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
3801: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);

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

3794: hr_utility.trace(' . l_ee_rate : '||l_ee_rate);
3795: hr_utility.trace(' . l_er_rate : '||l_er_rate);
3796: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
3797: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
3798: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
3799: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
3800: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
3801: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
3802: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);

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

3795: hr_utility.trace(' . l_er_rate : '||l_er_rate);
3796: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
3797: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
3798: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
3799: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
3800: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
3801: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
3802: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
3803: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);

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

3796: hr_utility.trace(' . l_ee_rate_type : '||l_ee_rate_type);
3797: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
3798: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
3799: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
3800: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
3801: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
3802: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
3803: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
3804: hr_utility.trace(' . l_average_salary : '||l_average_salary);

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

3797: hr_utility.trace(' . l_er_rate_type : '||l_er_rate_type);
3798: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
3799: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
3800: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
3801: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
3802: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
3803: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
3804: hr_utility.trace(' . l_average_salary : '||l_average_salary);
3805: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);

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

3798: hr_utility.trace(' . l_ee_cont_base_method : '||l_ee_cont_base_method);
3799: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
3800: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
3801: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
3802: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
3803: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
3804: hr_utility.trace(' . l_average_salary : '||l_average_salary);
3805: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
3806: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);

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

3799: hr_utility.trace(' . l_er_cont_base_method : '||l_er_cont_base_method);
3800: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
3801: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
3802: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
3803: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
3804: hr_utility.trace(' . l_average_salary : '||l_average_salary);
3805: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
3806: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
3807: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);

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

3800: hr_utility.trace(' . l_ee_cont_base_amount : '||l_ee_cont_base_amount);
3801: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
3802: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
3803: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
3804: hr_utility.trace(' . l_average_salary : '||l_average_salary);
3805: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
3806: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
3807: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
3808: hr_utility.trace(' . l_phf_high_lim_exemp : '||l_phf_high_lim_exemp);

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

3801: hr_utility.trace(' . l_er_cont_base_amount : '||l_er_cont_base_amount);
3802: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
3803: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
3804: hr_utility.trace(' . l_average_salary : '||l_average_salary);
3805: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
3806: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
3807: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
3808: hr_utility.trace(' . l_phf_high_lim_exemp : '||l_phf_high_lim_exemp);
3809: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);

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

3802: hr_utility.trace(' . l_ee_fixed_amount : '||l_ee_fixed_amount);
3803: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
3804: hr_utility.trace(' . l_average_salary : '||l_average_salary);
3805: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
3806: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
3807: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
3808: hr_utility.trace(' . l_phf_high_lim_exemp : '||l_phf_high_lim_exemp);
3809: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
3810: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);

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

3803: hr_utility.trace(' . l_er_fixed_amount : '||l_er_fixed_amount);
3804: hr_utility.trace(' . l_average_salary : '||l_average_salary);
3805: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
3806: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
3807: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
3808: hr_utility.trace(' . l_phf_high_lim_exemp : '||l_phf_high_lim_exemp);
3809: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
3810: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
3811:

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

3804: hr_utility.trace(' . l_average_salary : '||l_average_salary);
3805: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
3806: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
3807: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
3808: hr_utility.trace(' . l_phf_high_lim_exemp : '||l_phf_high_lim_exemp);
3809: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
3810: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
3811:
3812: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);

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

3805: hr_utility.trace(' . l_lowest_avg_salary : '||l_lowest_avg_salary);
3806: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
3807: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
3808: hr_utility.trace(' . l_phf_high_lim_exemp : '||l_phf_high_lim_exemp);
3809: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
3810: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
3811:
3812: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
3813: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);

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

3806: hr_utility.trace(' . l_ee_rate_rounding_method : '||l_ee_rate_rounding_method);
3807: hr_utility.trace(' . l_er_rate_rounding_method : '||l_er_rate_rounding_method);
3808: hr_utility.trace(' . l_phf_high_lim_exemp : '||l_phf_high_lim_exemp);
3809: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
3810: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
3811:
3812: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
3813: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
3814: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);

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

3808: hr_utility.trace(' . l_phf_high_lim_exemp : '||l_phf_high_lim_exemp);
3809: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
3810: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
3811:
3812: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
3813: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
3814: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
3815:
3816: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );

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

3809: hr_utility.trace(' . l_ee_phf_si_amount : '||l_ee_phf_si_amount);
3810: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
3811:
3812: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
3813: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
3814: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
3815:
3816: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
3817: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );

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

3810: hr_utility.trace(' . l_er_phf_si_amount : '||l_er_phf_si_amount);
3811:
3812: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
3813: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
3814: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
3815:
3816: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
3817: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
3818: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );

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

3812: hr_utility.trace(' . l_phf_si_earnings_asg_ptd : '||l_phf_si_earnings_asg_ptd);
3813: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
3814: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
3815:
3816: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
3817: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
3818: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
3819: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
3820: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );

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

3813: hr_utility.trace(' . l_phf_si_earnings_asg_pyear : '||l_phf_si_earnings_asg_pyear);
3814: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
3815:
3816: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
3817: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
3818: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
3819: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
3820: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
3821: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );

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

3814: hr_utility.trace(' . l_phf_si_earnings_asg_pmth : '||l_phf_si_earnings_asg_pmth);
3815:
3816: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
3817: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
3818: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
3819: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
3820: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
3821: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
3822: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);

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

3815:
3816: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
3817: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
3818: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
3819: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
3820: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
3821: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
3822: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
3823: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);

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

3816: hr_utility.trace(' . l_ee_hi_cont_type : '||l_ee_hi_cont_type );
3817: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
3818: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
3819: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
3820: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
3821: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
3822: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
3823: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
3824: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);

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

3817: hr_utility.trace(' . l_er_hi_cont_type : '||l_er_hi_cont_type );
3818: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
3819: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
3820: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
3821: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
3822: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
3823: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
3824: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
3825: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);

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

3818: hr_utility.trace(' . l_ee_hi_cont_amt : '||l_ee_hi_cont_amt );
3819: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
3820: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
3821: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
3822: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
3823: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
3824: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
3825: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
3826: hr_utility.trace(' . l_ee_thrhld_rate : '||l_ee_thrhld_rate);

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

3819: hr_utility.trace(' . l_er_hi_cont_amt : '||l_er_hi_cont_amt );
3820: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
3821: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
3822: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
3823: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
3824: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
3825: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
3826: hr_utility.trace(' . l_ee_thrhld_rate : '||l_ee_thrhld_rate);
3827: hr_utility.trace(' . l_er_thrhld_rate : '||l_er_thrhld_rate);

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

3820: hr_utility.trace(' . l_ee_hi_cont_base_meth : '||l_ee_hi_cont_base_meth );
3821: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
3822: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
3823: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
3824: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
3825: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
3826: hr_utility.trace(' . l_ee_thrhld_rate : '||l_ee_thrhld_rate);
3827: hr_utility.trace(' . l_er_thrhld_rate : '||l_er_thrhld_rate);
3828: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);

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

3821: hr_utility.trace(' . l_er_hi_cont_base_meth : '||l_er_hi_cont_base_meth );
3822: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
3823: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
3824: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
3825: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
3826: hr_utility.trace(' . l_ee_thrhld_rate : '||l_ee_thrhld_rate);
3827: hr_utility.trace(' . l_er_thrhld_rate : '||l_er_thrhld_rate);
3828: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);
3829: hr_utility.trace(' =======================================================');

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

3822: hr_utility.trace(' . l_ee_hi_cont_base_amount : '||l_ee_hi_cont_base_amount);
3823: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
3824: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
3825: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
3826: hr_utility.trace(' . l_ee_thrhld_rate : '||l_ee_thrhld_rate);
3827: hr_utility.trace(' . l_er_thrhld_rate : '||l_er_thrhld_rate);
3828: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);
3829: hr_utility.trace(' =======================================================');
3830: END IF;

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

3823: hr_utility.trace(' . l_er_hi_cont_base_amount : '||l_er_hi_cont_base_amount);
3824: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
3825: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
3826: hr_utility.trace(' . l_ee_thrhld_rate : '||l_ee_thrhld_rate);
3827: hr_utility.trace(' . l_er_thrhld_rate : '||l_er_thrhld_rate);
3828: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);
3829: hr_utility.trace(' =======================================================');
3830: END IF;
3831:

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

3824: hr_utility.trace(' . l_ee_taxable_cont : '||l_ee_taxable_cont);
3825: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
3826: hr_utility.trace(' . l_ee_thrhld_rate : '||l_ee_thrhld_rate);
3827: hr_utility.trace(' . l_er_thrhld_rate : '||l_er_thrhld_rate);
3828: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);
3829: hr_utility.trace(' =======================================================');
3830: END IF;
3831:
3832:

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

3825: hr_utility.trace(' . l_er_taxable_cont : '||l_er_taxable_cont);
3826: hr_utility.trace(' . l_ee_thrhld_rate : '||l_ee_thrhld_rate);
3827: hr_utility.trace(' . l_er_thrhld_rate : '||l_er_thrhld_rate);
3828: hr_utility.trace(' . l_tax_thrhld_amount : '||l_tax_thrhld_amount);
3829: hr_utility.trace(' =======================================================');
3830: END IF;
3831:
3832:
3833:

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

3962: --
3963: -- In case there is a previous run, subtract the PHF/SI amounts if any
3964: --
3965: IF g_debug THEN
3966: hr_utility.trace(' ====================================================================');
3967: hr_utility.trace(' EE PHF SI Amount (RUN) : '|| l_ee_phf_si_amount);
3968: hr_utility.trace(' ER PHF SI Amount (RUN) : '|| l_er_phf_si_amount);
3969: hr_utility.trace(' EE PHF SI Amount (PTD) : '|| l_ee_deductions_asg_er_ptd);
3970: hr_utility.trace(' ER PHF SI Amount (PTD) : '|| l_er_deductions_asg_er_ptd);

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

3963: -- In case there is a previous run, subtract the PHF/SI amounts if any
3964: --
3965: IF g_debug THEN
3966: hr_utility.trace(' ====================================================================');
3967: hr_utility.trace(' EE PHF SI Amount (RUN) : '|| l_ee_phf_si_amount);
3968: hr_utility.trace(' ER PHF SI Amount (RUN) : '|| l_er_phf_si_amount);
3969: hr_utility.trace(' EE PHF SI Amount (PTD) : '|| l_ee_deductions_asg_er_ptd);
3970: hr_utility.trace(' ER PHF SI Amount (PTD) : '|| l_er_deductions_asg_er_ptd);
3971: hr_utility.trace(' Undeducted EE PHF SI Amount (PTD) : '|| l_undeducted_ee_asg_er_ptd);

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

3964: --
3965: IF g_debug THEN
3966: hr_utility.trace(' ====================================================================');
3967: hr_utility.trace(' EE PHF SI Amount (RUN) : '|| l_ee_phf_si_amount);
3968: hr_utility.trace(' ER PHF SI Amount (RUN) : '|| l_er_phf_si_amount);
3969: hr_utility.trace(' EE PHF SI Amount (PTD) : '|| l_ee_deductions_asg_er_ptd);
3970: hr_utility.trace(' ER PHF SI Amount (PTD) : '|| l_er_deductions_asg_er_ptd);
3971: hr_utility.trace(' Undeducted EE PHF SI Amount (PTD) : '|| l_undeducted_ee_asg_er_ptd);
3972: hr_utility.trace(' Undeducted ER PHF SI Amount (PTD) : '|| l_undeducted_er_asg_er_ptd);

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

3965: IF g_debug THEN
3966: hr_utility.trace(' ====================================================================');
3967: hr_utility.trace(' EE PHF SI Amount (RUN) : '|| l_ee_phf_si_amount);
3968: hr_utility.trace(' ER PHF SI Amount (RUN) : '|| l_er_phf_si_amount);
3969: hr_utility.trace(' EE PHF SI Amount (PTD) : '|| l_ee_deductions_asg_er_ptd);
3970: hr_utility.trace(' ER PHF SI Amount (PTD) : '|| l_er_deductions_asg_er_ptd);
3971: hr_utility.trace(' Undeducted EE PHF SI Amount (PTD) : '|| l_undeducted_ee_asg_er_ptd);
3972: hr_utility.trace(' Undeducted ER PHF SI Amount (PTD) : '|| l_undeducted_er_asg_er_ptd);
3973: END IF;

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

3966: hr_utility.trace(' ====================================================================');
3967: hr_utility.trace(' EE PHF SI Amount (RUN) : '|| l_ee_phf_si_amount);
3968: hr_utility.trace(' ER PHF SI Amount (RUN) : '|| l_er_phf_si_amount);
3969: hr_utility.trace(' EE PHF SI Amount (PTD) : '|| l_ee_deductions_asg_er_ptd);
3970: hr_utility.trace(' ER PHF SI Amount (PTD) : '|| l_er_deductions_asg_er_ptd);
3971: hr_utility.trace(' Undeducted EE PHF SI Amount (PTD) : '|| l_undeducted_ee_asg_er_ptd);
3972: hr_utility.trace(' Undeducted ER PHF SI Amount (PTD) : '|| l_undeducted_er_asg_er_ptd);
3973: END IF;
3974:

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

3967: hr_utility.trace(' EE PHF SI Amount (RUN) : '|| l_ee_phf_si_amount);
3968: hr_utility.trace(' ER PHF SI Amount (RUN) : '|| l_er_phf_si_amount);
3969: hr_utility.trace(' EE PHF SI Amount (PTD) : '|| l_ee_deductions_asg_er_ptd);
3970: hr_utility.trace(' ER PHF SI Amount (PTD) : '|| l_er_deductions_asg_er_ptd);
3971: hr_utility.trace(' Undeducted EE PHF SI Amount (PTD) : '|| l_undeducted_ee_asg_er_ptd);
3972: hr_utility.trace(' Undeducted ER PHF SI Amount (PTD) : '|| l_undeducted_er_asg_er_ptd);
3973: END IF;
3974:
3975: l_ee_phf_si_amount:= l_ee_phf_si_amount - l_ee_deductions_asg_er_ptd - l_undeducted_ee_asg_er_ptd;

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

3968: hr_utility.trace(' ER PHF SI Amount (RUN) : '|| l_er_phf_si_amount);
3969: hr_utility.trace(' EE PHF SI Amount (PTD) : '|| l_ee_deductions_asg_er_ptd);
3970: hr_utility.trace(' ER PHF SI Amount (PTD) : '|| l_er_deductions_asg_er_ptd);
3971: hr_utility.trace(' Undeducted EE PHF SI Amount (PTD) : '|| l_undeducted_ee_asg_er_ptd);
3972: hr_utility.trace(' Undeducted ER PHF SI Amount (PTD) : '|| l_undeducted_er_asg_er_ptd);
3973: END IF;
3974:
3975: l_ee_phf_si_amount:= l_ee_phf_si_amount - l_ee_deductions_asg_er_ptd - l_undeducted_ee_asg_er_ptd;
3976: l_er_phf_si_amount:= l_er_phf_si_amount - l_er_deductions_asg_er_ptd - l_undeducted_er_asg_er_ptd;

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

3977: l_ee_taxable_cont := l_ee_taxable_cont - p_lt_ee_taxable_cont_ptd;
3978: l_er_taxable_cont := l_er_taxable_cont - p_lt_er_taxable_cont_ptd;
3979:
3980: IF g_debug THEN
3981: hr_utility.trace(' EE PHF SI Amount (Final) : '|| l_ee_phf_si_amount);
3982: hr_utility.trace(' ER PHF SI Amount (Final) : '|| l_er_phf_si_amount);
3983: hr_utility.trace(' ====================================================================');
3984: END IF;
3985: --

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

3978: l_er_taxable_cont := l_er_taxable_cont - p_lt_er_taxable_cont_ptd;
3979:
3980: IF g_debug THEN
3981: hr_utility.trace(' EE PHF SI Amount (Final) : '|| l_ee_phf_si_amount);
3982: hr_utility.trace(' ER PHF SI Amount (Final) : '|| l_er_phf_si_amount);
3983: hr_utility.trace(' ====================================================================');
3984: END IF;
3985: --
3986:

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

3979:
3980: IF g_debug THEN
3981: hr_utility.trace(' EE PHF SI Amount (Final) : '|| l_ee_phf_si_amount);
3982: hr_utility.trace(' ER PHF SI Amount (Final) : '|| l_er_phf_si_amount);
3983: hr_utility.trace(' ====================================================================');
3984: END IF;
3985: --
3986:
3987: -- Finally set all the output variables

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

3998: p_ee_taxable_cont := l_ee_taxable_cont;
3999: p_er_taxable_cont := l_er_taxable_cont;
4000:
4001: IF g_debug THEN
4002: hr_utility.trace(' ====================================================================');
4003: hr_utility.trace(' Calculation Date : '|| p_calculation_date);
4004: hr_utility.trace(' Employee PHF SI Amount : '|| p_ee_phf_si_amount);
4005: hr_utility.trace(' Employer PHF SI Amount : '|| p_er_phf_si_amount);
4006: hr_utility.trace(' Undeducted Employee PHF SI Amount : '|| p_undeducted_ee_phf_si_amount);

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

3999: p_er_taxable_cont := l_er_taxable_cont;
4000:
4001: IF g_debug THEN
4002: hr_utility.trace(' ====================================================================');
4003: hr_utility.trace(' Calculation Date : '|| p_calculation_date);
4004: hr_utility.trace(' Employee PHF SI Amount : '|| p_ee_phf_si_amount);
4005: hr_utility.trace(' Employer PHF SI Amount : '|| p_er_phf_si_amount);
4006: hr_utility.trace(' Undeducted Employee PHF SI Amount : '|| p_undeducted_ee_phf_si_amount);
4007: hr_utility.trace(' Undeducted Employer PHF SI Amount : '|| p_undeducted_er_phf_si_amount);

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

4000:
4001: IF g_debug THEN
4002: hr_utility.trace(' ====================================================================');
4003: hr_utility.trace(' Calculation Date : '|| p_calculation_date);
4004: hr_utility.trace(' Employee PHF SI Amount : '|| p_ee_phf_si_amount);
4005: hr_utility.trace(' Employer PHF SI Amount : '|| p_er_phf_si_amount);
4006: hr_utility.trace(' Undeducted Employee PHF SI Amount : '|| p_undeducted_ee_phf_si_amount);
4007: hr_utility.trace(' Undeducted Employer PHF SI Amount : '|| p_undeducted_er_phf_si_amount);
4008: hr_utility.trace(' Employee new cont base Amount : '|| p_new_ee_cont_base_amount);

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

4001: IF g_debug THEN
4002: hr_utility.trace(' ====================================================================');
4003: hr_utility.trace(' Calculation Date : '|| p_calculation_date);
4004: hr_utility.trace(' Employee PHF SI Amount : '|| p_ee_phf_si_amount);
4005: hr_utility.trace(' Employer PHF SI Amount : '|| p_er_phf_si_amount);
4006: hr_utility.trace(' Undeducted Employee PHF SI Amount : '|| p_undeducted_ee_phf_si_amount);
4007: hr_utility.trace(' Undeducted Employer PHF SI Amount : '|| p_undeducted_er_phf_si_amount);
4008: hr_utility.trace(' Employee new cont base Amount : '|| p_new_ee_cont_base_amount);
4009: hr_utility.trace(' Employer new cont base Amount : '|| p_new_er_cont_base_amount);

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

4002: hr_utility.trace(' ====================================================================');
4003: hr_utility.trace(' Calculation Date : '|| p_calculation_date);
4004: hr_utility.trace(' Employee PHF SI Amount : '|| p_ee_phf_si_amount);
4005: hr_utility.trace(' Employer PHF SI Amount : '|| p_er_phf_si_amount);
4006: hr_utility.trace(' Undeducted Employee PHF SI Amount : '|| p_undeducted_ee_phf_si_amount);
4007: hr_utility.trace(' Undeducted Employer PHF SI Amount : '|| p_undeducted_er_phf_si_amount);
4008: hr_utility.trace(' Employee new cont base Amount : '|| p_new_ee_cont_base_amount);
4009: hr_utility.trace(' Employer new cont base Amount : '|| p_new_er_cont_base_amount);
4010: hr_utility.trace(' Employee cont base Amount : '|| p_ee_cont_base_amount);

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

4003: hr_utility.trace(' Calculation Date : '|| p_calculation_date);
4004: hr_utility.trace(' Employee PHF SI Amount : '|| p_ee_phf_si_amount);
4005: hr_utility.trace(' Employer PHF SI Amount : '|| p_er_phf_si_amount);
4006: hr_utility.trace(' Undeducted Employee PHF SI Amount : '|| p_undeducted_ee_phf_si_amount);
4007: hr_utility.trace(' Undeducted Employer PHF SI Amount : '|| p_undeducted_er_phf_si_amount);
4008: hr_utility.trace(' Employee new cont base Amount : '|| p_new_ee_cont_base_amount);
4009: hr_utility.trace(' Employer new cont base Amount : '|| p_new_er_cont_base_amount);
4010: hr_utility.trace(' Employee cont base Amount : '|| p_ee_cont_base_amount);
4011: hr_utility.trace(' Employer cont base Amount : '|| p_er_cont_base_amount);

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

4004: hr_utility.trace(' Employee PHF SI Amount : '|| p_ee_phf_si_amount);
4005: hr_utility.trace(' Employer PHF SI Amount : '|| p_er_phf_si_amount);
4006: hr_utility.trace(' Undeducted Employee PHF SI Amount : '|| p_undeducted_ee_phf_si_amount);
4007: hr_utility.trace(' Undeducted Employer PHF SI Amount : '|| p_undeducted_er_phf_si_amount);
4008: hr_utility.trace(' Employee new cont base Amount : '|| p_new_ee_cont_base_amount);
4009: hr_utility.trace(' Employer new cont base Amount : '|| p_new_er_cont_base_amount);
4010: hr_utility.trace(' Employee cont base Amount : '|| p_ee_cont_base_amount);
4011: hr_utility.trace(' Employer cont base Amount : '|| p_er_cont_base_amount);
4012: hr_utility.trace(' =====================================================================');

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

4005: hr_utility.trace(' Employer PHF SI Amount : '|| p_er_phf_si_amount);
4006: hr_utility.trace(' Undeducted Employee PHF SI Amount : '|| p_undeducted_ee_phf_si_amount);
4007: hr_utility.trace(' Undeducted Employer PHF SI Amount : '|| p_undeducted_er_phf_si_amount);
4008: hr_utility.trace(' Employee new cont base Amount : '|| p_new_ee_cont_base_amount);
4009: hr_utility.trace(' Employer new cont base Amount : '|| p_new_er_cont_base_amount);
4010: hr_utility.trace(' Employee cont base Amount : '|| p_ee_cont_base_amount);
4011: hr_utility.trace(' Employer cont base Amount : '|| p_er_cont_base_amount);
4012: hr_utility.trace(' =====================================================================');
4013: END IF;

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

4006: hr_utility.trace(' Undeducted Employee PHF SI Amount : '|| p_undeducted_ee_phf_si_amount);
4007: hr_utility.trace(' Undeducted Employer PHF SI Amount : '|| p_undeducted_er_phf_si_amount);
4008: hr_utility.trace(' Employee new cont base Amount : '|| p_new_ee_cont_base_amount);
4009: hr_utility.trace(' Employer new cont base Amount : '|| p_new_er_cont_base_amount);
4010: hr_utility.trace(' Employee cont base Amount : '|| p_ee_cont_base_amount);
4011: hr_utility.trace(' Employer cont base Amount : '|| p_er_cont_base_amount);
4012: hr_utility.trace(' =====================================================================');
4013: END IF;
4014:

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

4007: hr_utility.trace(' Undeducted Employer PHF SI Amount : '|| p_undeducted_er_phf_si_amount);
4008: hr_utility.trace(' Employee new cont base Amount : '|| p_new_ee_cont_base_amount);
4009: hr_utility.trace(' Employer new cont base Amount : '|| p_new_er_cont_base_amount);
4010: hr_utility.trace(' Employee cont base Amount : '|| p_ee_cont_base_amount);
4011: hr_utility.trace(' Employer cont base Amount : '|| p_er_cont_base_amount);
4012: hr_utility.trace(' =====================================================================');
4013: END IF;
4014:
4015: hr_cn_api.set_location(g_debug,' Leaving ' || g_procedure_name,300);

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

4008: hr_utility.trace(' Employee new cont base Amount : '|| p_new_ee_cont_base_amount);
4009: hr_utility.trace(' Employer new cont base Amount : '|| p_new_er_cont_base_amount);
4010: hr_utility.trace(' Employee cont base Amount : '|| p_ee_cont_base_amount);
4011: hr_utility.trace(' Employer cont base Amount : '|| p_er_cont_base_amount);
4012: hr_utility.trace(' =====================================================================');
4013: END IF;
4014:
4015: hr_cn_api.set_location(g_debug,' Leaving ' || g_procedure_name,300);
4016: RETURN l_message;

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

4126: );
4127:
4128: IF NOT l_flag THEN
4129:
4130: hr_utility.trace('Invalid Contribution Base Setup');
4131:
4132: l_indep_seg := hr_cn_api.get_dff_tl_value(p_column_name => 'Switch Period Periodicity'
4133: ,p_dff => 'Org Developer DF'
4134: ,p_dff_context_code => 'PER_CONT_AREA_CONT_BASE_CN'

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

4570: ,p_er_fixed_amount => l_er_fixed_amount
4571: ,p_tax_thrhld_amount => l_tax_thrhld_amount
4572: );
4573:
4574: hr_utility.trace(' get_cont_base_method : Message=>' || l_message);
4575:
4576: IF l_message <> 'SUCCESS'
4577: THEN
4578: hr_cn_api.set_location(g_debug,' ' || g_procedure_name, 10);

Line 4605: hr_utility.trace('Asg Year Action ID' || l_asg_yr_action_id);

4601: OPEN get_prev_mth_asg_act_id(p_assignment_id,l_temp_date);
4602: FETCH get_prev_mth_asg_act_id INTO l_asg_mth_action_id;
4603: CLOSE get_prev_mth_asg_act_id;
4604:
4605: hr_utility.trace('Asg Year Action ID' || l_asg_yr_action_id);
4606: hr_utility.trace('Asg Mth Action ID' || l_asg_mth_action_id);
4607:
4608: IF l_asg_yr_action_id IS NULL THEN
4609: /* No latest assignment action exists for the target span */

Line 4606: hr_utility.trace('Asg Mth Action ID' || l_asg_mth_action_id);

4602: FETCH get_prev_mth_asg_act_id INTO l_asg_mth_action_id;
4603: CLOSE get_prev_mth_asg_act_id;
4604:
4605: hr_utility.trace('Asg Year Action ID' || l_asg_yr_action_id);
4606: hr_utility.trace('Asg Mth Action ID' || l_asg_mth_action_id);
4607:
4608: IF l_asg_yr_action_id IS NULL THEN
4609: /* No latest assignment action exists for the target span */
4610: p_phf_si_earnings_pyear := 0;

Line 4628: hr_utility.trace('PHFSI Constituents for Retro Elements' || l_phfsi_retro_earnings_pyear);

4624: ,p_get_rb_route => 'TRUE');
4625: ELSE
4626: l_phfsi_retro_earnings_pyear := 0;
4627: END IF;
4628: hr_utility.trace('PHFSI Constituents for Retro Elements' || l_phfsi_retro_earnings_pyear);
4629:
4630: /* call pay_balance_pkg and fetch the value of the PHF_SI_EARNINGS YTD dimension */
4631: l_phfsi_earnings_pyear := pay_balance_pkg.get_value
4632: (p_defined_balance_id => get_def_bal_id('PHF SI Earnings','_ASG_YTD')

Line 4643: hr_utility.trace('PHF/SI Earnings Prev Yr' || l_phfsi_earnings_pyear);

4639: ,p_date_earned => NULL
4640: ,p_get_rr_route => NULL
4641: ,p_get_rb_route => 'TRUE');
4642:
4643: hr_utility.trace('PHF/SI Earnings Prev Yr' || l_phfsi_earnings_pyear);
4644: p_phf_si_earnings_pyear := nvl(l_phfsi_earnings_pyear,0) + nvl(l_phfsi_retro_earnings_pyear,0);
4645: hr_utility.trace('Total PHF/SI Earnings Prev Yr' || p_phf_si_earnings_pyear);
4646:
4647: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_temp_date));

Line 4645: hr_utility.trace('Total PHF/SI Earnings Prev Yr' || p_phf_si_earnings_pyear);

4641: ,p_get_rb_route => 'TRUE');
4642:
4643: hr_utility.trace('PHF/SI Earnings Prev Yr' || l_phfsi_earnings_pyear);
4644: p_phf_si_earnings_pyear := nvl(l_phfsi_earnings_pyear,0) + nvl(l_phfsi_retro_earnings_pyear,0);
4645: hr_utility.trace('Total PHF/SI Earnings Prev Yr' || p_phf_si_earnings_pyear);
4646:
4647: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_temp_date));
4648: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);
4649: l_pay_runs_prev_yr := fnd_number.canonical_to_number(

Line 4651: hr_utility.trace('Payroll runs Prev Yr' || l_pay_runs_prev_yr);

4647: pay_balance_pkg.set_context('DATE_EARNED',fnd_date.date_to_canonical(l_temp_date));
4648: pay_balance_pkg.set_context('ASSIGNMENT_ID',p_assignment_id);
4649: l_pay_runs_prev_yr := fnd_number.canonical_to_number(
4650: pay_balance_pkg.run_db_item('CN_PAYROLL_RUN_MONTHS_PREV_YEAR',p_business_group_id,'CN'));
4651: hr_utility.trace('Payroll runs Prev Yr' || l_pay_runs_prev_yr);
4652: p_phf_si_earnings_pyear := p_phf_si_earnings_pyear / l_pay_runs_prev_yr ;
4653: END IF;
4654:
4655: IF l_asg_mth_action_id IS NULL THEN

Line 4671: hr_utility.trace('PHF/SI Earnings Prev Mth' || p_phf_si_earnings_pmth);

4667: ,p_tax_group => NULL
4668: ,p_date_earned => NULL
4669: ,p_get_rr_route => NULL
4670: ,p_get_rb_route => 'TRUE');
4671: hr_utility.trace('PHF/SI Earnings Prev Mth' || p_phf_si_earnings_pmth);
4672: END IF;
4673:
4674:
4675: return l_message;

Line 4720: hr_utility.trace('YOS Option' || l_use_yos_option );

4716: BEGIN
4717:
4718: l_use_yos_option := null;
4719:
4720: hr_utility.trace('YOS Option' || l_use_yos_option );
4721:
4722: OPEN get_rule( p_date_earned
4723: , p_tax_area
4724: );

Line 4732: hr_utility.trace('YOS Option' || l_use_yos_option );

4728: IF l_use_yos_option is null then
4729: l_use_yos_option := 'N';
4730: END IF;
4731:
4732: hr_utility.trace('YOS Option' || l_use_yos_option );
4733:
4734: RETURN l_use_yos_option;
4735:
4736: EXCEPTION

Line 4823: hr_utility.trace('Calculate Tax on Enterprise Annuity: ' || l_calculate_tax );

4819:
4820: IF l_calculate_tax is null then
4821: l_calculate_tax := 'N';
4822: END IF;
4823: hr_utility.trace('Calculate Tax on Enterprise Annuity: ' || l_calculate_tax );
4824: RETURN l_calculate_tax;
4825:
4826: EXCEPTION
4827: WHEN OTHERS THEN